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.046 +
Actual Total Time: 2.485 +
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.029 +
Actual Total Time: 2.400 +
Actual Rows: 15 +
Actual Loops: 1 +
Filter: "(added_by = 'depesz'::text)"+
Rows Removed by Filter: 13205 +
Planning Time: 0.054 +
Triggers: +
Execution Time: 2.496
(1 row)