explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bLJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.313 76,778.790 ↑ 1.0 3,000 1

Limit (cost=2,334,454.260..2,334,461.760 rows=3,000 width=63) (actual time=76,778.231..76,778.790 rows=3,000 loops=1)

2. 1,910.249 76,778.477 ↑ 17.5 3,000 1

Sort (cost=2,334,454.260..2,334,585.430 rows=52,467 width=63) (actual time=76,778.230..76,778.477 rows=3,000 loops=1)

  • Sort Key: ((three.four five_romeo NULL)), three.four, three.foxtrot
  • Sort Method: top-N heapsort Memory: 427kB
3. 1,789.370 74,868.228 ↓ 98.7 5,177,846 1

Hash Left Join (cost=2,102,363.830..2,331,161.760 rows=52,467 width=63) (actual time=41,100.883..74,868.228 rows=5,177,846 loops=1)

  • Hash Cond: (india_november.papa_uniform = delta.india_seven)
  • Filter: ((NOT romeo_three19.papa_zulu) OR (romeo_three19.papa_zulu five_romeo NULL))
4. 3,551.748 73,069.374 ↓ 47.2 5,177,846 1

Hash Left Join (cost=2,101,569.090..2,328,720.330 rows=109,780 width=67) (actual time=41,091.367..73,069.374 rows=5,177,846 loops=1)

  • Hash Cond: (three.quebec = india_november.golf)
5. 1,898.191 69,322.365 ↓ 47.2 5,177,846 1

Hash Left Join (cost=2,089,740.960..2,315,780.880 rows=109,780 width=63) (actual time=40,895.811..69,322.365 rows=5,177,846 loops=1)

  • Hash Cond: (oscar.india_seven = romeo_three16.quebec)
  • Filter: ((NOT romeo_three16.papa_zulu) OR (romeo_three16.papa_zulu five_romeo NULL))
  • Rows Removed by Filter: 852
6. 1,120.499 67,412.192 ↓ 22.5 5,178,698 1

Hash Left Join (cost=2,088,829.890..2,309,988.690 rows=229,700 width=67) (actual time=40,883.799..67,412.192 rows=5,178,698 loops=1)

  • Hash Cond: (zulu_juliet.papa_uniform = oscar.india_seven)
7. 4,408.482 66,291.538 ↓ 22.5 5,178,698 1

Hash Left Join (cost=2,088,817.720..2,306,818.150 rows=229,700 width=67) (actual time=40,883.616..66,291.538 rows=5,178,698 loops=1)

  • Hash Cond: (three.quebec = zulu_juliet.golf)
8. 2,755.106 61,756.750 ↓ 22.5 5,178,698 1

Hash Left Join (cost=2,077,569.650..2,292,102.600 rows=229,700 width=63) (actual time=40,757.156..61,756.750 rows=5,178,698 loops=1)

  • Hash Cond: (bravo_seven.india_seven = romeo_three10.quebec)
  • Filter: ((NOT romeo_three10.papa_zulu) OR (romeo_three10.papa_zulu five_romeo NULL))
  • Rows Removed by Filter: 18633
9. 2,009.725 58,989.007 ↓ 10.8 5,197,331 1

Hash Left Join (cost=2,076,658.590..2,280,978.470 rows=480,615 width=67) (actual time=40,744.475..58,989.007 rows=5,197,331 loops=1)

  • Hash Cond: (whiskey_charlie.papa_uniform = bravo_seven.india_seven)
10. 3,749.414 56,976.676 ↓ 10.8 5,197,331 1

Hash Left Join (cost=2,076,464.810..2,270,571.630 rows=480,615 width=67) (actual time=40,741.837..56,976.676 rows=5,197,331 loops=1)

  • Hash Cond: (three.quebec = zulu_bravo.golf)
  • Filter: ((NOT romeo_three13.papa_zulu) OR (romeo_three13.papa_zulu five_romeo NULL))
11. 11,332.066 53,175.400 ↓ 5.2 5,197,331 1

Hash Right Join (cost=2,073,207.930..2,254,724.020 rows=1,005,618 width=67) (actual time=40,689.915..53,175.400 rows=5,197,331 loops=1)

  • Hash Cond: (whiskey_charlie.golf = three.quebec)
12. 1,153.970 1,153.970 ↓ 1.1 5,603,446 1

Seq Scan on whiskey_charlie (cost=0.000..160,159.500 rows=5,264,350 width=8) (actual time=0.039..1,153.970 rows=5,603,446 loops=1)

13. 3,366.988 40,689.364 ↓ 5.2 5,197,331 1

Hash (cost=2,060,637.710..2,060,637.710 rows=1,005,618 width=63) (actual time=40,689.364..40,689.364 rows=5,197,331 loops=1)

  • Buckets: 131072 Batches: 4 (originally 1) Memory Usage: 131073kB
14. 3,124.769 37,322.376 ↓ 5.2 5,197,331 1

Hash Left Join (cost=1,321,798.260..2,060,637.710 rows=1,005,618 width=63) (actual time=16,401.174..37,322.376 rows=5,197,331 loops=1)

  • Hash Cond: (hotel.papa_uniform = whiskey_four.india_seven)
  • Filter: ((NOT juliet.papa_zulu) OR (juliet.papa_zulu five_romeo NULL))
  • Rows Removed by Filter: 48293
15. 14,470.008 34,166.928 ↓ 2.5 5,245,624 1

Hash Right Join (cost=1,320,046.280..2,008,913.050 rows=2,104,113 width=67) (actual time=16,370.442..34,166.928 rows=5,245,624 loops=1)

  • Hash Cond: (hotel.golf = three.quebec)
16. 3,330.580 3,330.580 ↑ 1.4 12,359,404 1

Seq Scan on hotel (cost=0.000..439,354.000 rows=16,864,900 width=8) (actual time=0.043..3,330.580 rows=12,359,404 loops=1)

17. 2,698.386 16,366.340 ↓ 2.5 5,245,624 1

Hash (cost=1,271,141.870..1,271,141.870 rows=2,104,113 width=63) (actual time=16,366.340..16,366.340 rows=5,245,624 loops=1)

  • Buckets: 262144 Batches: 4 (originally 2) Memory Usage: 131073kB
18. 7,098.495 13,667.954 ↓ 2.5 5,245,624 1

Hash Left Join (cost=245,878.680..1,271,141.870 rows=2,104,113 width=63) (actual time=1,348.213..13,667.954 rows=5,245,624 loops=1)

  • Hash Cond: (three.quebec = romeo_echo.golf)
  • Filter: ((NOT romeo_three7.papa_zulu) OR (romeo_three7.papa_zulu five_romeo NULL))
  • Rows Removed by Filter: 859
19. 5,282.731 6,316.190 ↓ 1.2 5,246,483 1

Bitmap Heap Scan on three (cost=229,819.920..1,194,134.340 rows=4,402,560 width=63) (actual time=1,094.865..6,316.190 rows=5,246,483 loops=1)

  • Recheck Cond: ((victor)::text = ANY ('bravo_five'::text[]))
  • Filter: ((four five_romeo NULL) OR ((five_seven)::double precision <= echo('uniform'::text, ('alpha_romeo'::timestamp with time zone - four))))
  • Rows Removed by Filter: 8796
  • Heap Blocks: exact=189465
20. 1,033.459 1,033.459 ↑ 1.7 5,258,387 1

Bitmap Index Scan on alpha_yankee (cost=0.000..228,719.270 rows=8,725,619 width=0) (actual time=1,033.459..1,033.459 rows=5,258,387 loops=1)

  • Index Cond: ((victor)::text = ANY ('bravo_five'::text[]))
21. 65.040 253.269 ↓ 1.0 318,976 1

Hash (cost=12,210.420..12,210.420 rows=307,868 width=5) (actual time=253.269..253.269 rows=318,976 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 11526kB
22. 118.390 188.229 ↓ 1.0 318,976 1

Hash Left Join (cost=698.550..12,210.420 rows=307,868 width=5) (actual time=3.305..188.229 rows=318,976 loops=1)

  • Hash Cond: (romeo_echo.papa_uniform = india_quebec.india_seven)
23. 66.567 66.567 ↓ 1.0 318,976 1

Seq Scan on romeo_echo (cost=0.000..7,278.680 rows=307,868 width=8) (actual time=0.017..66.567 rows=318,976 loops=1)

24. 0.164 3.272 ↑ 1.0 452 1

Hash (cost=692.900..692.900 rows=452 width=5) (actual time=3.272..3.272 rows=452 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
25. 0.317 3.108 ↑ 1.0 452 1

Nested Loop Left Join (cost=0.290..692.900 rows=452 width=5) (actual time=0.066..3.108 rows=452 loops=1)

26. 0.079 0.079 ↑ 1.0 452 1

Seq Scan on india_quebec (cost=0.000..6.520 rows=452 width=4) (actual time=0.007..0.079 rows=452 loops=1)

27. 2.712 2.712 ↑ 1.0 1 452

Index Scan using zulu_mike on juliet papa_seven (cost=0.290..1.510 rows=1 width=5) (actual time=0.006..0.006 rows=1 loops=452)

  • Index Cond: (india_quebec.india_seven = quebec)
28. 4.138 30.679 ↓ 1.0 17,508 1

Hash (cost=1,534.000..1,534.000 rows=17,438 width=5) (actual time=30.679..30.679 rows=17,508 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 633kB
29. 10.332 26.541 ↓ 1.0 17,508 1

Hash Left Join (cost=911.060..1,534.000 rows=17,438 width=5) (actual time=13.488..26.541 rows=17,508 loops=1)

  • Hash Cond: (whiskey_four.india_seven = juliet.quebec)
30. 2.773 2.773 ↓ 1.0 17,508 1

Seq Scan on whiskey_four (cost=0.000..252.380 rows=17,438 width=4) (actual time=0.019..2.773 rows=17,508 loops=1)

31. 5.770 13.436 ↓ 1.0 27,439 1

Hash (cost=568.250..568.250 rows=27,425 width=5) (actual time=13.436..13.436 rows=27,439 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 992kB
32. 7.666 7.666 ↓ 1.0 27,439 1

Seq Scan on juliet (cost=0.000..568.250 rows=27,425 width=5) (actual time=0.022..7.666 rows=27,439 loops=1)

33. 14.889 51.862 ↑ 1.0 66,739 1

Hash (cost=2,421.150..2,421.150 rows=66,858 width=5) (actual time=51.862..51.862 rows=66,739 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2412kB
34. 23.784 36.973 ↑ 1.0 66,739 1

Hash Left Join (cost=374.270..2,421.150 rows=66,858 width=5) (actual time=1.751..36.973 rows=66,739 loops=1)

  • Hash Cond: (zulu_bravo.papa_uniform = papa_charlie.india_seven)
35. 11.477 11.477 ↑ 1.0 66,739 1

Seq Scan on zulu_bravo (cost=0.000..1,127.580 rows=66,858 width=8) (actual time=0.018..11.477 rows=66,739 loops=1)

36. 0.100 1.712 ↑ 1.0 226 1

Hash (cost=371.450..371.450 rows=226 width=5) (actual time=1.712..1.712 rows=226 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 0.205 1.612 ↑ 1.0 226 1

Nested Loop Left Join (cost=0.290..371.450 rows=226 width=5) (actual time=0.074..1.612 rows=226 loops=1)

38. 0.051 0.051 ↑ 1.0 226 1

Seq Scan on papa_charlie (cost=0.000..3.260 rows=226 width=4) (actual time=0.014..0.051 rows=226 loops=1)

39. 1.356 1.356 ↑ 1.0 1 226

Index Scan using zulu_mike on juliet india_three (cost=0.290..1.620 rows=1 width=5) (actual time=0.006..0.006 rows=1 loops=226)

  • Index Cond: (papa_charlie.india_seven = quebec)
40. 1.449 2.606 ↑ 1.0 6,993 1

Hash (cost=103.900..103.900 rows=7,190 width=4) (actual time=2.606..2.606 rows=6,993 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 246kB
41. 1.157 1.157 ↑ 1.0 6,993 1

Seq Scan on bravo_seven (cost=0.000..103.900 rows=7,190 width=4) (actual time=0.016..1.157 rows=6,993 loops=1)

42. 6.044 12.637 ↓ 1.0 27,439 1

Hash (cost=568.250..568.250 rows=27,425 width=5) (actual time=12.637..12.637 rows=27,439 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 992kB
43. 6.593 6.593 ↓ 1.0 27,439 1

Seq Scan on juliet tango (cost=0.000..568.250 rows=27,425 width=5) (actual time=0.011..6.593 rows=27,439 loops=1)

44. 63.649 126.306 ↓ 1.0 318,976 1

Hash (cost=7,329.700..7,329.700 rows=313,470 width=8) (actual time=126.306..126.306 rows=318,976 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 12460kB
45. 62.657 62.657 ↓ 1.0 318,976 1

Seq Scan on zulu_juliet (cost=0.000..7,329.700 rows=313,470 width=8) (actual time=0.018..62.657 rows=318,976 loops=1)

46. 0.097 0.155 ↑ 1.0 452 1

Hash (cost=6.520..6.520 rows=452 width=4) (actual time=0.155..0.155 rows=452 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
47. 0.058 0.058 ↑ 1.0 452 1

Seq Scan on oscar (cost=0.000..6.520 rows=452 width=4) (actual time=0.014..0.058 rows=452 loops=1)

48. 5.949 11.982 ↓ 1.0 27,439 1

Hash (cost=568.250..568.250 rows=27,425 width=5) (actual time=11.982..11.982 rows=27,439 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 992kB
49. 6.033 6.033 ↓ 1.0 27,439 1

Seq Scan on juliet lima (cost=0.000..568.250 rows=27,425 width=5) (actual time=0.005..6.033 rows=27,439 loops=1)

50. 116.869 195.261 ↑ 1.0 403,295 1

Hash (cost=6,786.950..6,786.950 rows=403,295 width=8) (actual time=195.261..195.261 rows=403,295 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 15754kB
51. 78.392 78.392 ↑ 1.0 403,295 1

Seq Scan on india_november (cost=0.000..6,786.950 rows=403,295 width=8) (actual time=0.019..78.392 rows=403,295 loops=1)

52. 0.414 9.484 ↑ 1.0 1,808 1

Hash (cost=772.130..772.130 rows=1,808 width=5) (actual time=9.484..9.484 rows=1,808 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 66kB
53. 5.530 9.070 ↑ 1.0 1,808 1

Hash Right Join (cost=48.680..772.130 rows=1,808 width=5) (actual time=2.271..9.070 rows=1,808 loops=1)

  • Hash Cond: (romeo_three19.quebec = delta.india_seven)
54. 2.851 2.851 ↓ 1.0 27,439 1

Seq Scan on juliet charlie (cost=0.000..568.250 rows=27,425 width=5) (actual time=0.004..2.851 rows=27,439 loops=1)

55. 0.378 0.689 ↑ 1.0 1,808 1

Hash (cost=26.080..26.080 rows=1,808 width=4) (actual time=0.689..0.689 rows=1,808 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 64kB
56. 0.311 0.311 ↑ 1.0 1,808 1

Seq Scan on delta (cost=0.000..26.080 rows=1,808 width=4) (actual time=0.015..0.311 rows=1,808 loops=1)