explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5SjR

Settings
# exclusive inclusive rows x rows loops node
1. 161.927 22,872.196 ↑ 1.3 360,499 1

Gather (cost=2,378.58..66,003,932.75 rows=470,704 width=12) (actual time=33.298..22,872.196 rows=360,499 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2,737.827 22,710.269 ↑ 1.6 120,166 3 / 3

Nested Loop (cost=1,378.58..65,955,862.35 rows=196,127 width=12) (actual time=21.791..22,710.269 rows=120,166 loops=3)

3. 1,386.244 1,937.975 ↑ 1.2 1,639,497 3 / 3

Hash Left Join (cost=1,347.48..86,026.51 rows=2,048,233 width=24) (actual time=21.475..1,937.975 rows=1,639,497 loops=3)

  • Hash Cond: (instanceinplace.place_id = boxinginplace.id)
4. 530.544 530.544 ↑ 1.2 1,639,497 3 / 3

Parallel Seq Scan on instance_in_place instanceinplace (cost=0.00..79,302.33 rows=2,048,233 width=12) (actual time=0.027..530.544 rows=1,639,497 loops=3)

5. 5.076 21.187 ↑ 1.8 17,734 3 / 3

Hash (cost=958.88..958.88 rows=31,088 width=20) (actual time=21.187..21.187 rows=17,734 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1157kB
6. 16.111 16.111 ↑ 1.8 17,734 3 / 3

Seq Scan on boxing_in_place boxinginplace (cost=0.00..958.88 rows=31,088 width=20) (actual time=0.020..16.111 rows=17,734 loops=3)

7. 6,557.988 18,034.467 ↓ 0.0 0 4,918,491 / 3

Bitmap Heap Scan on place (cost=31.10..32.15 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=4,918,491)

  • Recheck Cond: (((place_id = instanceinplace.place_id) AND (place_type = instanceinplace.place_type)) OR ((place_id = boxinginplace.place_id) AND (place_type = boxinginplace.place_type)))
  • Filter: ((parent_place_id = 116) AND (parent_place_type = 4))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=2527729
8. 1,639.497 11,476.479 ↓ 0.0 0 4,918,491 / 3

BitmapOr (cost=31.10..31.10 rows=2 width=0) (actual time=0.007..0.007 rows=0 loops=4,918,491)

9. 9,836.982 9,836.982 ↓ 2.0 2 4,918,491 / 3

Bitmap Index Scan on place_place_idx (cost=0.00..0.44 rows=1 width=0) (actual time=0.006..0.006 rows=2 loops=4,918,491)

  • Index Cond: ((place_id = instanceinplace.place_id) AND (place_type = instanceinplace.place_type))
10. 0.000 0.000 ↓ 0.0 0 4,918,491 / 3

Bitmap Index Scan on place_place_idx (cost=0.00..1.03 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=4,918,491)

  • Index Cond: ((place_id = boxinginplace.place_id) AND (place_type = boxinginplace.place_type))
Planning time : 1.327 ms
Execution time : 22,915.049 ms