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.035 ↵
Actual Total Time: 1.827 ↵
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.075 ↵
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.022 ↵
Actual Total Time: 1.750 ↵
Actual Rows: 15 ↵
Actual Loops: 1 ↵
Filter: "(added_by = 'depesz'::text)"↵
Rows Removed by Filter: 13205 ↵
Planning Time: 0.038 ↵
Triggers: ↵
Execution Time: 1.835
(1 row)