explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zqXr

Settings
# exclusive inclusive rows x rows loops node
1. 1.011 1,481.274 ↑ 229.0 1 1

HashAggregate (cost=143,310.78..143,318.79 rows=229 width=225) (actual time=1,481.273..1,481.274 rows=1 loops=1)

2. 0.326 1,480.263 ↓ 1.7 400 1

Nested Loop Left Join (cost=141,190.17..143,290.74 rows=229 width=225) (actual time=1,457.118..1,480.263 rows=400 loops=1)

  • Join Filter: (oop.id = oopl.one_off_pick_id)
3. 0.002 0.106 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..39.06 rows=1 width=212) (actual time=0.068..0.106 rows=1 loops=1)

4. 0.001 0.104 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..30.79 rows=1 width=199) (actual time=0.067..0.104 rows=1 loops=1)

5. 0.001 0.094 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.69..22.51 rows=1 width=186) (actual time=0.062..0.094 rows=1 loops=1)

6. 0.006 0.093 ↑ 1.0 1 1

Nested Loop (cost=1.69..14.23 rows=1 width=173) (actual time=0.061..0.093 rows=1 loops=1)

7. 0.043 0.081 ↑ 1.0 1 1

Hash Right Join (cost=1.69..5.95 rows=1 width=164) (actual time=0.051..0.081 rows=1 loops=1)

  • Hash Cond: (loc.loc = oop.pick_location)
8. 0.015 0.015 ↑ 1.0 91 1

Seq Scan on location loc (cost=0.00..3.91 rows=91 width=17) (actual time=0.002..0.015 rows=91 loops=1)

9. 0.003 0.023 ↑ 1.0 1 1

Hash (cost=1.67..1.67 rows=1 width=151) (actual time=0.023..0.023 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
10. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on one_off_pick oop (cost=0.00..1.67 rows=1 width=151) (actual time=0.019..0.020 rows=1 loops=1)

  • Filter: ((active = ANY ('{t,f}'::boolean[])) AND (id = 13,406))
  • Rows Removed by Filter: 44
11. 0.006 0.006 ↑ 1.0 1 1

Index Scan using user_id_unique on ult_users uu (cost=0.00..8.27 rows=1 width=17) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (user_id = oop.create_uid)
12. 0.000 0.000 ↓ 0.0 0 1

Index Scan using user_id_unique on ult_users uup (cost=0.00..8.27 rows=1 width=17) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (user_id = oop.picker_uid)
13. 0.009 0.009 ↑ 1.0 1 1

Index Scan using user_id_unique on ult_users uupp (cost=0.00..8.27 rows=1 width=17) (actual time=0.004..0.009 rows=1 loops=1)

  • Index Cond: (user_id = oop.primary_picker)
14. 0.000 0.000 ↓ 0.0 0 1

Index Scan using user_id_unique on ult_users uusp (cost=0.00..8.27 rows=1 width=17) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (user_id = oop.secondary_picker)
15. 6.464 1,479.831 ↓ 1.7 400 1

Hash Right Join (cost=141,188.49..143,244.23 rows=229 width=17) (actual time=1,457.030..1,479.831 rows=400 loops=1)

  • Hash Cond: (one_off_pick_picks.one_off_pick_lines_id = oopl.id)
16. 62.442 1,470.873 ↑ 1.3 66,935 1

HashAggregate (cost=140,811.31..141,676.85 rows=86,554 width=8) (actual time=1,453.574..1,470.873 rows=66,935 loops=1)

17. 865.293 1,408.431 ↓ 1.1 92,045 1

Hash Join (cost=49,602.35..140,378.54 rows=86,554 width=8) (actual time=68.099..1,408.431 rows=92,045 loops=1)

  • Hash Cond: (one_off_pick_picks.one_off_pick_lines_id = one_off_pick_lines.id)
18. 475.164 475.164 ↑ 1.0 2,681,911 1

Seq Scan on one_off_pick_picks (cost=0.00..53,026.75 rows=2,682,465 width=8) (actual time=0.004..475.164 rows=2,681,911 loops=1)

  • Filter: active
  • Rows Removed by Filter: 2,164
19. 15.831 67.974 ↑ 1.0 70,243 1

Hash (cost=48,698.21..48,698.21 rows=72,331 width=4) (actual time=67.974..67.974 rows=70,243 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 2,470kB
20. 41.889 52.143 ↑ 1.0 70,243 1

Bitmap Heap Scan on one_off_pick_lines (cost=1,357.06..48,698.21 rows=72,331 width=4) (actual time=14.967..52.143 rows=70,243 loops=1)

  • Recheck Cond: (one_off_pick_id = 13,406)
21. 10.254 10.254 ↑ 1.0 70,264 1

Bitmap Index Scan on one_off_pick_lines_one_off_pick_id_idx (cost=0.00..1,338.98 rows=72,331 width=0) (actual time=10.254..10.254 rows=70,264 loops=1)

  • Index Cond: (one_off_pick_id = 13,406)
22. 0.105 2.494 ↓ 1.7 400 1

Hash (cost=374.32..374.32 rows=229 width=17) (actual time=2.494..2.494 rows=400 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
23. 2.389 2.389 ↓ 1.7 400 1

Index Scan using one_off_pick_lines_active_seq on one_off_pick_lines oopl (cost=0.00..374.32 rows=229 width=17) (actual time=0.012..2.389 rows=400 loops=1)

  • Index Cond: (active = true)
  • Filter: (active AND (one_off_pick_id = 13,406))
  • Rows Removed by Filter: 6,586