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.053, +
"Actual Total Time": 2.634, +
"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.017, +
"Actual Total Time": 0.084, +
"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.035, +
"Actual Total Time": 2.548, +
"Actual Rows": 15, +
"Actual Loops": 1, +
"Filter": "(added_by = 'depesz'::text)",+
"Rows Removed by Filter": 13205 +
} +
] +
}, +
"Planning Time": 0.056, +
"Triggers": [ +
], +
"Execution Time": 2.645 +
} +
]
(1 row)