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.040, ↵
"Actual Total Time": 2.088, ↵
"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.016, ↵
"Actual Total Time": 0.082, ↵
"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": 2.004, ↵
"Actual Rows": 15, ↵
"Actual Loops": 1, ↵
"Filter": "(added_by = 'depesz'::text)",↵
"Rows Removed by Filter": 13205 ↵
} ↵
] ↵
}, ↵
"Planning Time": 0.039, ↵
"Triggers": [ ↵
], ↵
"Execution Time": 2.097 ↵
} ↵
]
(1 row)