explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p11y

Settings
# exclusive inclusive rows x rows loops node
1. 4,532.905 74,970.286 ↑ 35.7 359,650 1

Hash Join (cost=1,128,792.40..1,760,598.52 rows=12,842,824 width=24) (actual time=36,410.028..74,970.286 rows=359,650 loops=1)

  • Hash Cond: (uce.udl_container_id = uc.udl_container_id)
2. 34,029.698 34,029.698 ↓ 1.0 12,853,731 1

Seq Scan on udl_container_event uce (cost=0.00..582,027.24 rows=12,842,824 width=24) (actual time=0.012..34,029.698 rows=12,853,731 loops=1)

3. 46.355 36,407.683 ↑ 1.6 160,199 1

Hash (cost=1,125,598.75..1,125,598.75 rows=255,492 width=8) (actual time=36,407.683..36,407.683 rows=160,199 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 8306kB
4. 159.816 36,361.328 ↑ 1.6 160,199 1

HashAggregate (cost=1,123,043.83..1,125,598.75 rows=255,492 width=8) (actual time=36,302.669..36,361.328 rows=160,199 loops=1)

  • Group Key: uc.udl_container_id
5. 2,422.898 36,201.512 ↑ 1.0 255,492 1

Hash Join (cost=975,063.76..1,122,405.10 rows=255,492 width=8) (actual time=33,496.084..36,201.512 rows=255,492 loops=1)

  • Hash Cond: ((iise.equipment_id)::text = (uc.container_number)::text)
6. 189.105 539.280 ↑ 1.0 255,492 1

Hash Join (cost=8,775.30..25,234.69 rows=255,492 width=11) (actual time=186.105..539.280 rows=255,492 loops=1)

  • Hash Cond: (iih.tx_set_hdr_number = iise.tx_set_hdr_number)
7. 165.321 165.321 ↑ 1.0 255,492 1

Seq Scan on stg_iftsta_in_header iih (cost=0.00..12,946.38 rows=255,492 width=12) (actual time=0.016..165.321 rows=255,492 loops=1)

  • Filter: (((intfc_processing_status)::text = 'COMPLETED'::text) AND (batch_id = 158243))
8. 86.712 184.854 ↑ 1.0 255,492 1

Hash (cost=5,581.65..5,581.65 rows=255,492 width=23) (actual time=184.854..184.854 rows=255,492 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 16021kB
9. 98.142 98.142 ↑ 1.0 255,492 1

Seq Scan on stg_iftsta_in_status_equip iise (cost=0.00..5,581.65 rows=255,492 width=23) (actual time=0.016..98.142 rows=255,492 loops=1)

  • Filter: (batch_id = 158243)
10. 8,910.004 33,239.334 ↑ 1.0 20,275,204 1

Hash (cost=594,033.76..594,033.76 rows=20,275,976 width=20) (actual time=33,239.334..33,239.334 rows=20,275,204 loops=1)

  • Buckets: 16777216 Batches: 2 Memory Usage: 686535kB
11. 24,329.330 24,329.330 ↑ 1.0 20,275,204 1

Seq Scan on udl_container uc (cost=0.00..594,033.76 rows=20,275,976 width=20) (actual time=0.009..24,329.330 rows=20,275,204 loops=1)