explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YpA

Settings
# exclusive inclusive rows x rows loops node
1. 200.809 796.726 ↑ 3.6 360,499 1

Gather (cost=31,762.83..44,174,665.27 rows=1,293,429 width=12) (actual time=76.128..796.726 rows=360,499 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 71.182 595.917 ↑ 4.5 120,166 3 / 3

Nested Loop (cost=30,762.83..44,044,322.37 rows=538,929 width=12) (actual time=65.739..595.917 rows=120,166 loops=3)

3. 10.299 83.135 ↑ 1.1 22,080 3 / 3

Merge Left Join (cost=28,982.74..29,390.61 rows=24,690 width=28) (actual time=65.634..83.135 rows=22,080 loops=3)

  • Merge Cond: ((place.place_type = boxinginplace.place_type) AND (place.place_id = boxinginplace.place_id))
4. 33.075 49.387 ↑ 1.1 22,080 3 / 3

Sort (cost=25,689.64..25,751.36 rows=24,690 width=20) (actual time=40.224..49.387 rows=22,080 loops=3)

  • Sort Key: place.place_type, place.place_id
  • Sort Method: quicksort Memory: 3024kB
5. 16.312 16.312 ↑ 1.1 22,080 3 / 3

Parallel Index Scan using parent_place_idx on place (cost=0.43..23,888.30 rows=24,690 width=20) (actual time=0.032..16.312 rows=22,080 loops=3)

  • Index Cond: ((parent_place_id = 116) AND (parent_place_type = 4))
6. 16.459 23.449 ↑ 2.1 14,970 3 / 3

Sort (cost=3,278.68..3,356.40 rows=31,088 width=20) (actual time=22.123..23.449 rows=14,970 loops=3)

  • Sort Key: boxinginplace.place_type, boxinginplace.place_id
  • Sort Method: quicksort Memory: 2154kB
7. 6.990 6.990 ↑ 1.8 17,737 3 / 3

Seq Scan on boxing_in_place boxinginplace (cost=0.00..958.88 rows=31,088 width=20) (actual time=0.042..6.990 rows=17,737 loops=3)

8. 331.200 441.600 ↑ 2.2 5 66,240 / 3

Bitmap Heap Scan on instance_in_place instanceinplace (cost=1,780.10..1,782.59 rows=11 width=20) (actual time=0.008..0.020 rows=5 loops=66,240)

  • Recheck Cond: (((place.place_id = place_id) AND (place.place_type = place_type) AND (place_type = 2)) OR ((boxinginplace.id = place_id) AND (place_type = 2)))
  • Filter: (place.warehouse_id = warehouse_id)
  • Heap Blocks: exact=135571
9. 22.080 110.400 ↓ 0.0 0 66,240 / 3

BitmapOr (cost=1,780.10..1,780.10 rows=22 width=0) (actual time=0.005..0.005 rows=0 loops=66,240)

10. 88.320 88.320 ↓ 1.2 5 66,240 / 3

Bitmap Index Scan on instance_in_place_place_idx (cost=0.00..1.21 rows=4 width=0) (actual time=0.004..0.004 rows=5 loops=66,240)

  • Index Cond: ((place.place_id = place_id) AND (place.place_type = place_type) AND (place_type = 2))
11. 0.000 0.000 ↓ 0.0 0 66,240 / 3

Bitmap Index Scan on instance_in_place_place_idx (cost=0.00..1.48 rows=18 width=0) (actual time=0.000..0.000 rows=0 loops=66,240)

  • Index Cond: ((boxinginplace.id = place_id) AND (place_type = 2))
Planning time : 0.554 ms
Execution time : 816.527 ms