explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x0eS

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 87.397 32,117.930 ↑ 1.3 9,723 1

Hash Left Join (cost=8,890.680..8,638,862.400 rows=12,562 width=1,751) (actual time=206.008..32,117.930 rows=9,723 loops=1)

  • Hash Cond: (foxtrot_three.zulu = sierra_lima1.quebec_seven)
2. 112.775 971.747 ↑ 1.3 9,723 1

Hash Left Join (cost=8,887.100..24,245.860 rows=12,562 width=1,698) (actual time=200.072..971.747 rows=9,723 loops=1)

  • Hash Cond: (foxtrot_three.sierra_three = hotel1.quebec_seven)
3. 659.408 659.408 ↑ 1.3 9,723 1

Index Scan using foxtrot_two on foxtrot_three (cost=0.560..15,194.200 rows=12,562 width=1,550) (actual time=0.039..659.408 rows=9,723 loops=1)

  • Index Cond: ((golf)::text = 'papa'::text)
4. 1.263 199.564 ↑ 57.6 2,033 1

Hash (cost=7,424.020..7,424.020 rows=117,002 width=148) (actual time=199.564..199.564 rows=2,033 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 1,360kB
5. 198.301 198.301 ↑ 57.6 2,033 1

Seq Scan on two five (cost=0.000..7,424.020 rows=117,002 width=148) (actual time=0.006..198.301 rows=2,033 loops=1)

6. 0.020 0.067 ↑ 1.0 70 1

Hash (cost=2.700..2.700 rows=70 width=53) (actual time=0.067..0.067 rows=70 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
7. 0.047 0.047 ↑ 1.0 70 1

Seq Scan on whiskey quebec_golf (cost=0.000..2.700 rows=70 width=53) (actual time=0.005..0.047 rows=70 loops=1)

8.          

SubPlan (for Hash Left Join)

9. 0.607 24,310.957 ↑ 1.0 1 607

Limit (cost=166.780..661.420 rows=1 width=6) (actual time=40.051..40.051 rows=1 loops=607)

10. 28.598 24,310.350 ↑ 1.0 1 607

Nested Loop (cost=166.780..661.420 rows=1 width=6) (actual time=40.050..40.050 rows=1 loops=607)

11. 114.723 24,241.152 ↑ 1.0 1 607

Hash Join (cost=166.350..657.980 rows=1 width=4) (actual time=39.936..39.936 rows=1 loops=607)

  • Hash Cond: (bravo.quebec_seven = four.mike_india)
12. 24,073.620 24,073.620 ↑ 1.8 304 607

Index Scan using victor_seven on bravo (cost=0.570..490.150 rows=545 width=8) (actual time=1.069..39.660 rows=304 loops=607)

  • Index Cond: ((juliet_charlie)::text = 'november'::text)
13. 13.354 52.809 ↑ 22.2 16 607

Hash (cost=161.340..161.340 rows=355 width=8) (actual time=0.087..0.087 rows=16 loops=607)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 39.455 39.455 ↑ 22.2 16 607

Index Scan using charlie on four (cost=0.570..161.340 rows=355 width=8) (actual time=0.060..0.065 rows=16 loops=607)

  • Index Cond: (tango = foxtrot_three.quebec_seven)
15. 40.600 40.600 ↑ 1.0 1 580

Index Scan using alpha on seven (cost=0.430..3.430 rows=1 width=10) (actual time=0.070..0.070 rows=1 loops=580)

  • Index Cond: (quebec_seven = four.victor_hotel)
16. 9.723 855.624 ↑ 1.0 1 9,723

Limit (cost=0.850..6.900 rows=1 width=23) (actual time=0.088..0.088 rows=1 loops=9,723)

17. 58.338 845.901 ↑ 1.0 1 9,723

Nested Loop (cost=0.850..6.900 rows=1 width=23) (actual time=0.087..0.087 rows=1 loops=9,723)

18. 573.657 573.657 ↑ 1.0 1 9,723

Index Only Scan using foxtrot_bravo on lima_lima (cost=0.430..3.450 rows=1 width=4) (actual time=0.059..0.059 rows=1 loops=9,723)

  • Index Cond: (quebec_seven = foxtrot_three.kilo)
  • Heap Fetches: 9,220
19. 213.906 213.906 ↑ 1.0 1 9,723

Index Scan using lima_mike on victor_kilo (cost=0.430..3.450 rows=1 width=27) (actual time=0.022..0.022 rows=1 loops=9,723)

  • Index Cond: (quebec_seven = lima_lima.foxtrot_uniform)
20. 622.272 1,108.422 ↑ 1.0 1 9,723

Limit (cost=3.460..4.610 rows=1 width=8) (actual time=0.113..0.114 rows=1 loops=9,723)

21. 114.537 486.150 ↑ 1.0 1 9,723

Hash Join (cost=3.460..4.610 rows=1 width=8) (actual time=0.050..0.050 rows=1 loops=9,723)

  • Hash Cond: (three.quebec_seven = juliet_romeo1.oscar)
22. 109.092 109.092 ↑ 1.7 6 9,091

Seq Scan on three (cost=0.000..1.100 rows=10 width=12) (actual time=0.011..0.012 rows=6 loops=9,091)

23. 38.892 262.521 ↑ 1.0 1 9,723

Hash (cost=3.450..3.450 rows=1 width=4) (actual time=0.027..0.027 rows=1 loops=9,723)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
24. 223.629 223.629 ↑ 1.0 1 9,723

Index Scan using foxtrot_bravo on lima_lima six_zulu (cost=0.430..3.450 rows=1 width=4) (actual time=0.010..0.023 rows=1 loops=9,723)

  • Index Cond: (quebec_seven = foxtrot_three.kilo)
25. 9.723 77.784 ↑ 1.0 1 9,723

Limit (cost=0.430..3.450 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=9,723)

26. 68.061 68.061 ↑ 1.0 1 9,723

Index Scan using foxtrot_bravo on lima_lima six_echo (cost=0.430..3.450 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=9,723)

  • Index Cond: (quebec_seven = foxtrot_three.kilo)
27. 19.446 4,705.932 ↑ 1.0 1 9,723

Aggregate (cost=9.370..9.380 rows=1 width=0) (actual time=0.483..0.484 rows=1 loops=9,723)

28. 4,686.486 4,686.486 ↓ 0.0 0 9,723

Index Scan using romeo on mike_oscar (cost=0.270..9.370 rows=1 width=0) (actual time=0.443..0.482 rows=0 loops=9,723)

  • Filter: (zulu = sierra_lima1.quebec_seven)
  • Rows Removed by Filter: 10
Planning time : 3.929 ms
Execution time : 32,119.515 ms