+----------------------------------------------------+ | QUERY PLAN | +----------------------------------------------------+ | [ | | { | | "Plan": { | | "Node Type": "Nested Loop", | | "Parallel Aware": false, | | "Join Type": "Inner", | | "Startup Cost": 0.00, | | "Total Cost": 2017.80, | | "Plan Rows": 15, | | "Plan Width": 133, | | "Actual Startup Time": 0.037, | | "Actual Total Time": 1.905, | | "Actual Rows": 15, | | "Actual Loops": 1, | | "Inner Unique": false, | | "Plans": [ | | { | | "Node Type": "Seq Scan", | | "Parent Relationship": "Outer", | | "Parallel Aware": false, | | "Relation Name": "users", | | "Alias": "u", | | "Startup Cost": 0.00, | | "Total Cost": 41.40, | | "Plan Rows": 1, | | "Plan Width": 129, | | "Actual Startup Time": 0.013, | | "Actual Total Time": 0.077, | | "Actual Rows": 1, | | "Actual Loops": 1, | | "Filter": "(username = 'depesz'::text)", | | "Rows Removed by Filter": 1231 | | }, | | { | | "Node Type": "Seq Scan", | | "Parent Relationship": "Inner", | | "Parallel Aware": false, | | "Relation Name": "part_0", | | "Alias": "p", | | "Startup Cost": 0.00, | | "Total Cost": 1976.25, | | "Plan Rows": 15, | | "Plan Width": 17, | | "Actual Startup Time": 0.023, | | "Actual Total Time": 1.825, | | "Actual Rows": 15, | | "Actual Loops": 1, | | "Filter": "(added_by = 'depesz'::text)", | | "Rows Removed by Filter": 13205 | | } | | ] | | }, | | "Planning Time": 0.041, | | "Triggers": [ | | ], | | "Execution Time": 1.913 | | } | | ] | +----------------------------------------------------+ (1 row)