Planner Viewer

Paste JSON Planner Explain
Cost Flag Limit
[ { "Plan": { "Node Type": "Result", "Startup Cost": 0.00, "Total Cost": 50.13, "Plan Rows": 7, "Plan Width": 405, "Actual Startup Time": 0.139, "Actual Total Time": 0.231, "Actual Rows": 4, "Actual Loops": 1, "Plans": [ { "Node Type": "Append", "Parent Relationship": "Outer", "Startup Cost": 0.00, "Total Cost": 50.11, "Plan Rows": 7, "Plan Width": 405, "Actual Startup Time": 0.131, "Actual Total Time": 0.218, "Actual Rows": 4, "Actual Loops": 1, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Member", "Scan Direction": "NoMovement", "Index Name": "idx_paris_tags", "Relation Name": "paris", "Alias": "paris", "Startup Cost": 0.00, "Total Cost": 8.27, "Plan Rows": 1, "Plan Width": 450, "Actual Startup Time": 0.009, "Actual Total Time": 0.009, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "(tags ? 'tourism'::text)", "Filter": "(ar_num = 8)" }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Relation Name": "paris_linestrings", "Alias": "paris", "Startup Cost": 0.00, "Total Cost": 11.80, "Plan Rows": 1, "Plan Width": 450, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 1, "Filter": "((tags ? 'tourism'::text) AND (ar_num = 8))" }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Scan Direction": "NoMovement", "Index Name": "idx_paris_points_tags", "Relation Name": "paris_points", "Alias": "paris", "Startup Cost": 0.00, "Total Cost": 8.27, "Plan Rows": 1, "Plan Width": 450, "Actual Startup Time": 0.003, "Actual Total Time": 0.003, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "(tags ? 'tourism'::text)", "Filter": "(ar_num = 8)" }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Scan Direction": "NoMovement", "Index Name": "idx_paris_polygons_tags", "Relation Name": "paris_polygons", "Alias": "paris", "Startup Cost": 0.00, "Total Cost": 8.27, "Plan Rows": 1, "Plan Width": 450, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "(tags ? 'tourism'::text)", "Filter": "(ar_num = 8)" }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Relation Name": "paris_linestrings_ar_08", "Alias": "paris", "Startup Cost": 0.00, "Total Cost": 7.27, "Plan Rows": 1, "Plan Width": 513, "Actual Startup Time": 0.103, "Actual Total Time": 0.103, "Actual Rows": 0, "Actual Loops": 1, "Filter": "((tags ? 'tourism'::text) AND (ar_num = 8))" }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Relation Name": "paris_points_ar_08", "Alias": "paris", "Startup Cost": 0.00, "Total Cost": 5.16, "Plan Rows": 1, "Plan Width": 72, "Actual Startup Time": 0.009, "Actual Total Time": 0.085, "Actual Rows": 4, "Actual Loops": 1, "Filter": "((tags ? 'tourism'::text) AND (ar_num = 8))" }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Relation Name": "paris_polygons_ar_08", "Alias": "paris", "Startup Cost": 0.00, "Total Cost": 1.08, "Plan Rows": 1, "Plan Width": 450, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Filter": "((tags ? 'tourism'::text) AND (ar_num = 8))" } ] } ] }, "Triggers": [ ], "Total Runtime": 1.238 } ]

Display PostgreSQL Planner