explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3h9

Settings
# exclusive inclusive rows x rows loops node
1. 206.413 253.897 ↓ 5.2 890,723 1

Hash Join (cost=4,490.440..7,423.810 rows=172,780 width=91) (actual time=27.313..253.897 rows=890,723 loops=1)

  • Hash Cond: (kilo1.romeo = lima.quebec)
2. 15.367 43.395 ↑ 1.0 32,633 1

Hash Join (cost=4,385.070..5,305.100 rows=32,633 width=4) (actual time=23.211..43.395 rows=32,633 loops=1)

  • Hash Cond: (kilo1.xray_zulu = tango.quebec)
3. 5.147 5.147 ↑ 1.0 32,633 1

Seq Scan on echo oscar (cost=0.000..471.330 rows=32,633 width=8) (actual time=0.015..5.147 rows=32,633 loops=1)

4. 9.160 22.881 ↑ 1.0 24,492 1

Hash (cost=4,078.920..4,078.920 rows=24,492 width=4) (actual time=22.881..22.881 rows=24,492 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1118kB
5. 13.721 13.721 ↑ 1.0 24,492 1

Seq Scan on tango (cost=0.000..4,078.920 rows=24,492 width=4) (actual time=0.010..13.721 rows=24,492 loops=1)

6. 0.926 4.089 ↓ 1.1 1,318 1

Hash (cost=90.550..90.550 rows=1,186 width=99) (actual time=4.089..4.089 rows=1,318 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 196kB
7. 0.703 3.163 ↓ 1.1 1,318 1

Hash Join (cost=40.070..90.550 rows=1,186 width=99) (actual time=1.136..3.163 rows=1,318 loops=1)

  • Hash Cond: (alpha1.romeo = lima.quebec)
8. 0.886 2.310 ↓ 1.1 1,318 1

Hash Join (cost=30.030..64.200 rows=1,186 width=95) (actual time=0.980..2.310 rows=1,318 loops=1)

  • Hash Cond: (alpha1.sierra = foxtrot.quebec)
9. 0.470 0.470 ↓ 1.1 1,318 1

Seq Scan on xray_golf november (cost=0.000..17.860 rows=1,186 width=8) (actual time=0.016..0.470 rows=1,318 loops=1)

10. 0.461 0.954 ↑ 1.0 757 1

Hash (cost=20.570..20.570 rows=757 width=91) (actual time=0.954..0.954 rows=757 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
11. 0.493 0.493 ↑ 1.0 757 1

Seq Scan on foxtrot (cost=0.000..20.570 rows=757 width=91) (actual time=0.057..0.493 rows=757 loops=1)

12. 0.060 0.150 ↑ 1.0 224 1

Hash (cost=7.240..7.240 rows=224 width=4) (actual time=0.149..0.150 rows=224 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
13. 0.090 0.090 ↑ 1.0 224 1

Seq Scan on lima (cost=0.000..7.240 rows=224 width=4) (actual time=0.015..0.090 rows=224 loops=1)