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.036, +
"Actual Total Time": 2.042, +
"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.012, +
"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.963, +
"Actual Rows": 15, +
"Actual Loops": 1, +
"Filter": "(added_by = 'depesz'::text)",+
"Rows Removed by Filter": 13205 +
} +
] +
}, +
"Planning Time": 0.039, +
"Triggers": [ +
], +
"Execution Time": 2.051 +
} +
]
(1 row)