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.048
Actual Total Time: 2.925
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.015
Actual Total Time: 0.144
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.031
Actual Total Time: 2.778
Actual Rows: 15
Actual Loops: 1
Filter: "(added_by = 'depesz'::text)"
Rows Removed by Filter: 13205
Planning Time: 0.065
Triggers:
Execution Time: 2.938
(1 row)