explain.depesz.com

PostgreSQL's explain analyze made readable

Result: av8a

Settings
# exclusive inclusive rows x rows loops node
1. 0.574 538.971 ↑ 1.0 753 1

Sort (cost=8,667.120..8,669.010 rows=757 width=99) (actual time=538.892..538.971 rows=753 loops=1)

  • Sort Key: (five(tango.quebec)) DESC
  • Sort Method: quicksort Memory: 161kB
2. 249.024 538.397 ↑ 1.0 753 1

HashAggregate (cost=8,623.350..8,630.920 rows=757 width=99) (actual time=538.189..538.397 rows=753 loops=1)

  • Group Key: foxtrot.quebec
3. 230.343 289.373 ↓ 4.6 890,723 1

Hash Join (cost=4,496.830..7,663.300 rows=192,010 width=95) (actual time=35.027..289.373 rows=890,723 loops=1)

  • Hash Cond: (kilo1.romeo = lima.quebec)
4. 18.743 55.139 ↑ 1.0 32,633 1

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

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

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

6. 9.971 30.790 ↑ 1.0 24,492 1

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

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

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

8. 0.839 3.891 ↑ 1.0 1,318 1

Hash (cost=95.290..95.290 rows=1,318 width=99) (actual time=3.891..3.891 rows=1,318 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 196kB
9. 0.721 3.052 ↑ 1.0 1,318 1

Hash Join (cost=40.070..95.290 rows=1,318 width=99) (actual time=1.257..3.052 rows=1,318 loops=1)

  • Hash Cond: (alpha1.romeo = lima.quebec)
10. 0.871 2.095 ↑ 1.0 1,318 1

Hash Join (cost=30.030..67.120 rows=1,318 width=95) (actual time=1.000..2.095 rows=1,318 loops=1)

  • Hash Cond: (alpha1.sierra = foxtrot.quebec)
11. 0.297 0.297 ↑ 1.0 1,318 1

Seq Scan on xray_golf november (cost=0.000..19.180 rows=1,318 width=8) (actual time=0.036..0.297 rows=1,318 loops=1)

12. 0.516 0.927 ↑ 1.0 757 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
13. 0.411 0.411 ↑ 1.0 757 1

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

14. 0.095 0.236 ↑ 1.0 224 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
15. 0.141 0.141 ↑ 1.0 224 1

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