explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9ZTY

Settings
# exclusive inclusive rows x rows loops node
1. 451.367 1,415.868 ↑ 1.6 353,814 1

HashAggregate (cost=73,847.46..79,425.61 rows=557,815 width=24) (actual time=1,323.486..1,415.868 rows=353,814 loops=1)

  • Group Key: zz_pr.road_link_id, hd.address_range_id, hd.road_name_id, chr.new_address_range_id, 1
2. 191.404 964.501 ↓ 1.7 938,959 1

Hash Left Join (cost=23,065.62..66,874.77 rows=557,815 width=24) (actual time=389.879..964.501 rows=938,959 loops=1)

  • Hash Cond: ((zz_pr.road_link_id = chr.road_link_id) AND (hd.unique_id = chr.address_range_id))
3. 339.273 771.818 ↓ 1.7 938,959 1

Hash Right Join (cost=22,969.38..62,594.90 rows=557,815 width=20) (actual time=388.499..771.818 rows=938,959 loops=1)

  • Hash Cond: ((hd.road_link_id = zz_pr.road_link_id) AND (hd.address_range_id = zz_pr.left_address_range_id))
4. 49.440 49.440 ↑ 1.0 299,478 1

Seq Scan on road_house_data hd (cost=0.00..5,490.78 rows=299,478 width=20) (actual time=0.007..49.440 rows=299,478 loops=1)

5. 139.097 383.105 ↑ 1.0 557,815 1

Hash (cost=14,602.15..14,602.15 rows=557,815 width=8) (actual time=383.105..383.105 rows=557,815 loops=1)

  • Buckets: 1048576 Batches: 1 Memory Usage: 29982kB
6. 244.008 244.008 ↑ 1.0 557,815 1

Seq Scan on zz_road_prerequisite_stage_one zz_pr (cost=0.00..14,602.15 rows=557,815 width=8) (actual time=0.033..244.008 rows=557,815 loops=1)

7. 0.724 1.279 ↑ 1.0 3,050 1

Hash (cost=50.50..50.50 rows=3,050 width=20) (actual time=1.279..1.279 rows=3,050 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 199kB
8. 0.555 0.555 ↑ 1.0 3,050 1

Seq Scan on collapsed_house_range chr (cost=0.00..50.50 rows=3,050 width=20) (actual time=0.012..0.555 rows=3,050 loops=1)

Planning time : 61.534 ms