explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qv1p

Settings
# exclusive inclusive rows x rows loops node
1. 120.997 6,677.066 ↓ 1.0 102,142 1

Hash Join (cost=964,749.230..1,429,462.310 rows=102,130 width=28) (actual time=5,845.840..6,677.066 rows=102,142 loops=1)

2. 30.638 6,540.127 ↓ 1.0 102,142 1

Merge Join (cost=962,439.200..1,414,117.930 rows=102,130 width=148) (actual time=5,829.864..6,540.127 rows=102,142 loops=1)

3. 27.244 6,361.924 ↓ 1.0 102,142 1

Merge Join (cost=936,667.860..1,371,801.790 rows=102,130 width=132) (actual time=5,729.572..6,361.924 rows=102,142 loops=1)

4. 32.463 2,605.364 ↓ 1.0 102,142 1

Merge Join (cost=191,735.340..546,144.800 rows=102,130 width=116) (actual time=2,223.206..2,605.364 rows=102,142 loops=1)

5. 51.984 2,447.784 ↓ 1.0 102,142 1

Merge Join (cost=190,734.030..201,193.030 rows=102,130 width=100) (actual time=2,217.236..2,447.784 rows=102,142 loops=1)

6. 82.192 2,242.789 ↓ 1.0 102,142 1

Sort (cost=190,733.620..190,988.940 rows=102,130 width=84) (actual time=2,217.184..2,242.789 rows=102,142 loops=1)

  • Sort Key: five_hotel.bravo_romeo
  • Sort Method: external merge Disk: 8904kB
7. 24.170 2,160.597 ↓ 1.0 102,142 1

Hash Join (cost=151,189.040..177,346.880 rows=102,130 width=84) (actual time=1,784.705..2,160.597 rows=102,142 loops=1)

8. 61.554 2,122.266 ↓ 1.0 102,142 1

Hash Join (cost=149,872.230..175,761.960 rows=102,130 width=84) (actual time=1,770.369..2,122.266 rows=102,142 loops=1)

9. 62.665 2,030.298 ↓ 1.0 102,142 1

Hash Join (cost=146,173.430..168,607.070 rows=102,130 width=84) (actual time=1,739.614..2,030.298 rows=102,142 loops=1)

10. 154.245 1,937.281 ↓ 1.0 102,142 1

Hash Join (cost=142,274.100..161,251.630 rows=102,130 width=84) (actual time=1,708.795..1,937.281 rows=102,142 loops=1)

11. 74.438 74.438 ↑ 1.0 503,379 1

Seq Scan on victor bravo_four (cost=0.000..10,751.790 rows=503,379 width=8) (actual time=0.031..74.438 rows=503,379 loops=1)

12. 30.820 1,708.598 ↓ 1.0 102,142 1

Hash (cost=139,600.470..139,600.470 rows=102,130 width=84) (actual time=1,708.597..1,708.598 rows=102,142 loops=1)

13. 145.087 1,677.778 ↓ 1.0 102,142 1

Hash Join (cost=120,623.310..139,600.470 rows=102,130 width=84) (actual time=1,459.878..1,677.778 rows=102,142 loops=1)

14. 73.004 73.004 ↑ 1.0 503,379 1

Seq Scan on victor quebec_two (cost=0.000..10,751.790 rows=503,379 width=8) (actual time=0.028..73.004 rows=503,379 loops=1)

15. 30.553 1,459.687 ↓ 1.0 102,142 1

Hash (cost=117,949.690..117,949.690 rows=102,130 width=84) (actual time=1,459.687..1,459.687 rows=102,142 loops=1)

16. 141.612 1,429.134 ↓ 1.0 102,142 1

Hash Join (cost=98,972.520..117,949.690 rows=102,130 width=84) (actual time=1,217.557..1,429.134 rows=102,142 loops=1)

17. 70.140 70.140 ↑ 1.0 503,379 1

Seq Scan on victor oscar_mike (cost=0.000..10,751.790 rows=503,379 width=8) (actual time=0.025..70.140 rows=503,379 loops=1)

18. 30.516 1,217.382 ↓ 1.0 102,142 1

Hash (cost=96,298.900..96,298.900 rows=102,130 width=84) (actual time=1,217.382..1,217.382 rows=102,142 loops=1)

19. 145.996 1,186.866 ↓ 1.0 102,142 1

Hash Join (cost=77,321.740..96,298.900 rows=102,130 width=84) (actual time=970.266..1,186.866 rows=102,142 loops=1)

20. 70.783 70.783 ↑ 1.0 503,379 1

Seq Scan on victor tango (cost=0.000..10,751.790 rows=503,379 width=8) (actual time=0.028..70.783 rows=503,379 loops=1)

21. 32.319 970.087 ↓ 1.0 102,142 1

Hash (cost=74,648.110..74,648.110 rows=102,130 width=84) (actual time=970.087..970.087 rows=102,142 loops=1)

22. 31.046 937.768 ↓ 1.0 102,142 1

Hash Join (cost=36,759.300..74,648.110 rows=102,130 width=84) (actual time=363.434..937.768 rows=102,142 loops=1)

23. 68.941 890.102 ↓ 1.0 102,142 1

Hash Join (cost=34,891.230..72,511.940 rows=102,130 width=84) (actual time=346.638..890.102 rows=102,142 loops=1)

24. 55.025 553.795 ↓ 1.0 102,142 1

Hash Join (cost=10,791.050..44,112.470 rows=102,130 width=60) (actual time=79.091..553.795 rows=102,142 loops=1)

25. 54.940 470.826 ↓ 1.0 102,142 1

Hash Join (cost=7,339.430..37,997.750 rows=102,130 width=56) (actual time=50.817..470.826 rows=102,142 loops=1)

26. 28.131 365.574 ↓ 1.0 102,142 1

Merge Join (cost=1.010..27,995.220 rows=102,130 width=56) (actual time=0.088..365.574 rows=102,142 loops=1)

27. 37.392 254.238 ↓ 1.0 102,142 1

Merge Join (cost=0.710..20,029.280 rows=102,130 width=40) (actual time=0.056..254.238 rows=102,142 loops=1)

28. 45.588 45.588 ↓ 1.0 102,142 1

Index Scan using xray_november on zulu_six five_hotel (cost=0.290..3,991.390 rows=102,130 width=24) (actual time=0.013..45.588 rows=102,142 loops=1)

29. 70.082 171.258 ↓ 1.2 84,002 1

Aggregate (cost=0.420..14,187.540 rows=70,890 width=20) (actual time=0.039..171.258 rows=84,002 loops=1)

30. 101.176 101.176 ↑ 1.0 270,934 1

Index Scan using xray_kilo on uniform whiskey (cost=0.420..10,091.960 rows=270,934 width=8) (actual time=0.027..101.176 rows=270,934 loops=1)

31. 37.091 83.205 ↓ 1.1 70,692 1

Aggregate (cost=0.290..6,241.280 rows=65,304 width=20) (actual time=0.029..83.205 rows=70,692 loops=1)

32. 46.114 46.114 ↑ 1.0 110,747 1

Index Scan using golf on six_alpha six_alpha (cost=0.290..4,203.900 rows=110,747 width=8) (actual time=0.022..46.114 rows=110,747 loops=1)

33. 15.561 50.312 ↑ 1.0 102,142 1

Hash (cost=5,661.520..5,661.520 rows=102,152 width=8) (actual time=50.312..50.312 rows=102,142 loops=1)

34. 34.751 34.751 ↑ 1.0 102,142 1

Seq Scan on five_three five_three (cost=0.000..5,661.520 rows=102,152 width=8) (actual time=0.014..34.751 rows=102,142 loops=1)

35. 14.753 27.944 ↓ 1.0 102,142 1

Hash (cost=1,776.720..1,776.720 rows=102,072 width=8) (actual time=27.944..27.944 rows=102,142 loops=1)

36. 13.191 13.191 ↓ 1.0 102,142 1

Seq Scan on four four (cost=0.000..1,776.720 rows=102,072 width=8) (actual time=0.018..13.191 rows=102,142 loops=1)

37. 23.191 267.366 ↑ 1.0 102,142 1

Hash (cost=22,124.410..22,124.410 rows=102,142 width=32) (actual time=267.366..267.366 rows=102,142 loops=1)

38. 135.844 244.175 ↑ 1.0 102,142 1

Hash Join (cost=3,845.200..22,124.410 rows=102,142 width=32) (actual time=37.957..244.175 rows=102,142 loops=1)

39. 70.601 70.601 ↑ 1.0 503,379 1

Seq Scan on victor hotel (cost=0.000..10,751.790 rows=503,379 width=8) (actual time=0.011..70.601 rows=503,379 loops=1)

40. 19.121 37.730 ↑ 1.0 102,142 1

Hash (cost=1,869.420..1,869.420 rows=102,142 width=32) (actual time=37.730..37.730 rows=102,142 loops=1)

41. 18.609 18.609 ↑ 1.0 102,142 1

Seq Scan on bravo_november bravo_november (cost=0.000..1,869.420 rows=102,142 width=32) (actual time=0.010..18.609 rows=102,142 loops=1)

42. 7.834 16.620 ↑ 1.0 60,581 1

Hash (cost=1,110.810..1,110.810 rows=60,581 width=8) (actual time=16.620..16.620 rows=60,581 loops=1)

43. 8.786 8.786 ↑ 1.0 60,581 1

Seq Scan on echo sierra_hotel (cost=0.000..1,110.810 rows=60,581 width=8) (actual time=0.025..8.786 rows=60,581 loops=1)

44. 14.397 30.352 ↑ 1.0 100,726 1

Hash (cost=2,246.260..2,246.260 rows=100,726 width=8) (actual time=30.352..30.352 rows=100,726 loops=1)

45. 15.955 15.955 ↑ 1.0 100,726 1

Seq Scan on lima_golf november_november (cost=0.000..2,246.260 rows=100,726 width=8) (actual time=0.014..15.955 rows=100,726 loops=1)

46. 15.493 30.414 ↑ 1.0 100,702 1

Hash (cost=2,046.020..2,046.020 rows=100,702 width=8) (actual time=30.414..30.414 rows=100,702 loops=1)

47. 14.921 14.921 ↑ 1.0 100,702 1

Seq Scan on bravo_sierra zulu_three (cost=0.000..2,046.020 rows=100,702 width=8) (actual time=0.009..14.921 rows=100,702 loops=1)

48. 6.192 14.161 ↑ 1.0 40,125 1

Hash (cost=815.250..815.250 rows=40,125 width=8) (actual time=14.161..14.161 rows=40,125 loops=1)

49. 7.969 7.969 ↑ 1.0 40,125 1

Seq Scan on kilo juliet (cost=0.000..815.250 rows=40,125 width=8) (actual time=0.009..7.969 rows=40,125 loops=1)

50. 85.226 153.011 ↓ 1.1 102,142 1

Aggregate (cost=0.420..7,761.130 rows=97,228 width=20) (actual time=0.046..153.011 rows=102,142 loops=1)

51. 67.785 67.785 ↑ 1.0 112,349 1

Index Scan using india_november on romeo romeo (cost=0.420..5,384.220 rows=112,370 width=8) (actual time=0.034..67.785 rows=112,349 loops=1)

52. 24.195 125.117 ↑ 1.6 60,583 1

Aggregate (cost=1,001.310..342,508.820 rows=97,228 width=20) (actual time=5.968..125.117 rows=60,583 loops=1)

53. 0.000 100.922 ↑ 1.1 60,597 1

Gather Merge (cost=1,001.310..341,025.700 rows=68,112 width=20) (actual time=5.935..100.922 rows=60,597 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
54. 26.813 325.693 ↑ 2.2 30,298 2 / 2

Aggregate (cost=1.300..332,363.090 rows=68,112 width=20) (actual time=1.340..325.693 rows=30,298 loops=2)

55. 90.224 298.880 ↑ 1.2 57,841 2 / 2

Nested Loop (cost=1.300..330,830.570 rows=68,112 width=8) (actual time=1.329..298.880 rows=57,841 loops=2)

56. 40.132 40.132 ↑ 1.2 56,174 2 / 2

Index Scan using india_november on romeo charlie (cost=0.420..4,921.520 rows=66,100 width=12) (actual time=0.014..40.132 rows=56,174 loops=2)

57. 56.175 168.524 ↑ 2.0 1 112,349 / 2

Bitmap Heap Scan on yankee mike (cost=0.880..4.910 rows=2 width=8) (actual time=0.003..0.003 rows=1 loops=112,349)

  • Heap Blocks: exact=12849
58. 0.000 112.349 ↓ 0.0 0 112,349 / 2

BitmapOr (cost=0.880..0.880 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=112,349)

59. 56.175 56.175 ↑ 1.0 1 112,349 / 2

Bitmap Index Scan on lima_yankee (cost=0.000..0.440 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=112,349)

  • Index Cond: (seven_three1.alpha_juliet = quebec_seven)
60. 56.175 56.175 ↓ 0.0 0 112,349 / 2

Bitmap Index Scan on lima_yankee (cost=0.000..0.440 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=112,349)

  • Index Cond: (seven_three1.bravo_alpha = quebec_seven)
61. 9.543 3,729.316 ↑ 3.9 20,116 1

Aggregate (cost=744,932.520..823,654.000 rows=77,674 width=20) (actual time=3,506.363..3,729.316 rows=20,116 loops=1)

62. 0.027 3,719.773 ↑ 5.4 28,989 1

Gather Merge (cost=744,932.520..821,712.150 rows=155,348 width=20) (actual time=3,506.356..3,719.773 rows=28,989 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
63. 146.501 3,719.746 ↑ 8.0 9,663 3 / 3

Aggregate (cost=743,932.490..802,781.120 rows=77,674 width=20) (actual time=3,501.736..3,719.746 rows=9,663 loops=3)

64. 589.366 3,573.245 ↑ 4.6 839,962 3 / 3

Sort (cost=743,932.490..753,611.140 rows=3,871,459 width=8) (actual time=3,501.712..3,573.245 rows=839,962 loops=3)

  • Sort Key: november_yankee.bravo_romeo
  • Sort Method: external sort Disk: 14832kB
65. 865.952 2,983.879 ↑ 4.6 839,962 3 / 3

Merge Join (cost=212.160..214,447.820 rows=3,871,459 width=8) (actual time=2.131..2,983.879 rows=839,962 loops=3)

66. 448.616 448.616 ↑ 1.3 839,962 3 / 3

Index Scan using six_golf on zulu_india bravo_zulu (cost=0.430..77,725.240 rows=1,049,953 width=8) (actual time=0.035..448.616 rows=839,962 loops=3)

67. 1,669.311 1,669.311 ↑ 3.7 2,519,775 3 / 3

Index Scan using seven_whiskey on november_yankee november_yankee (cost=0.430..434,977.720 rows=9,291,502 width=8) (actual time=0.022..1,669.311 rows=2,519,775 loops=3)

68. 13.490 147.565 ↑ 2.4 35,070 1

Aggregate (cost=25,771.340..40,133.940 rows=85,639 width=20) (actual time=100.286..147.565 rows=35,070 loops=1)

69. 15.646 134.075 ↑ 2.4 35,271 1

Gather Merge (cost=25,771.340..38,635.250 rows=85,639 width=20) (actual time=100.282..134.075 rows=35,271 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
70. 15.896 118.429 ↑ 4.9 17,636 2 / 2

Aggregate (cost=24,771.330..28,000.860 rows=85,639 width=20) (actual time=97.973..118.429 rows=17,636 loops=2)

71. 11.913 102.533 ↑ 3.1 50,992 2 / 2

Sort (cost=24,771.330..25,166.850 rows=158,209 width=8) (actual time=97.968..102.533 rows=50,992 loops=2)

  • Sort Key: two.bravo_romeo
  • Sort Method: quicksort Memory: 3987kB
72. 27.169 90.620 ↑ 3.1 50,992 2 / 2

Merge Join (cost=0.710..8,942.320 rows=158,209 width=8) (actual time=0.646..90.620 rows=50,992 loops=2)

73. 20.483 20.483 ↑ 1.2 50,992 2 / 2

Index Scan using oscar_delta on quebec_uniform seven_november (cost=0.290..3,852.800 rows=59,990 width=8) (actual time=0.024..20.483 rows=50,992 loops=2)

74. 42.968 42.968 ↑ 2.6 101,952 2 / 2

Index Scan using alpha_quebec on two two (cost=0.420..10,883.490 rows=268,956 width=8) (actual time=0.020..42.968 rows=101,952 loops=2)

75. 6.755 15.942 ↑ 1.0 60,579 1

Hash (cost=1,552.790..1,552.790 rows=60,579 width=8) (actual time=15.942..15.942 rows=60,579 loops=1)

76. 9.187 9.187 ↑ 1.0 60,579 1

Seq Scan on india_three sierra_alpha (cost=0.000..1,552.790 rows=60,579 width=8) (actual time=0.010..9.187 rows=60,579 loops=1)

Planning time : 14.175 ms
Execution time : 6,686.964 ms