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.038 ↵
Actual Total Time: 1.909 ↵
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.014 ↵
Actual Total Time: 0.087 ↵
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.024 ↵
Actual Total Time: 1.820 ↵
Actual Rows: 15 ↵
Actual Loops: 1 ↵
Filter: "(added_by = 'depesz'::text)"↵
Rows Removed by Filter: 13205 ↵
Planning Time: 0.043 ↵
Triggers: ↵
Execution Time: 1.919
(1 row)