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.904
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.826
Actual Rows: 15
Actual Loops: 1
Filter: "(added_by = 'depesz'::text)"
Rows Removed by Filter: 13205
Planning Time: 0.038
Triggers:
Execution Time: 1.912
(1 row)