explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5EqG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=17,297,560,790,843,199,488.000..7,047,160,806,901,816,492,032.000 rows=468,656,909,333,469,690,068,992 width=1,950) (actual rows= loops=)

  • Merge Cond: (three_victor.hotel_xray = echo_papa.six_india)
2.          

CTE november_victor

3. 0.000 0.000 ↓ 0.0

Seq Scan on november_victor november_golf (cost=0.000..45,861.870 rows=2,650 width=55) (actual rows= loops=)

4.          

SubPlan (forSeq Scan)

5. 0.000 0.000 ↓ 0.0

Aggregate (cost=17.200..17.210 rows=1 width=32) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on six_sierra (cost=4.380..17.160 rows=13 width=4) (actual rows= loops=)

  • Recheck Cond: (delta_whiskey = quebec_zulu1.quebec_seven)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on xray_romeo_juliet (cost=0.000..4.380 rows=13 width=0) (actual rows= loops=)

  • Index Cond: (delta_whiskey = quebec_zulu1.quebec_seven)
8.          

CTE bravo_hotel

9. 0.000 0.000 ↓ 0.0

Seq Scan on bravo_hotel two_papa (cost=0.000..4,790,548.820 rows=7,002 width=108) (actual rows= loops=)

10.          

SubPlan (forSeq Scan)

11. 0.000 0.000 ↓ 0.0

Aggregate (cost=277.120..277.130 rows=1 width=32) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

HashAggregate (cost=274.800..275.830 rows=103 width=4) (actual rows= loops=)

  • Group Key: bravo_three.xray_five
13. 0.000 0.000 ↓ 0.0

Append (cost=144.060..274.540 rows=103 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=144.060..243.730 rows=88 width=4) (actual rows= loops=)

  • Hash Cond: (romeo_zulu.india_juliet = bravo_three.quebec_seven)
15. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on romeo_zulu (cost=4.970..103.430 rows=88 width=4) (actual rows= loops=)

  • Recheck Cond: (kilo_foxtrot_six = seven_two1.quebec_seven)
16. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on alpha_india_delta (cost=0.000..4.950 rows=88 width=0) (actual rows= loops=)

  • Index Cond: (kilo_foxtrot_six = seven_two1.quebec_seven)
17. 0.000 0.000 ↓ 0.0

Hash (cost=81.820..81.820 rows=4,582 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on bravo_three (cost=0.000..81.820 rows=4,582 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on alpha_papa (cost=4.390..20.070 rows=14 width=4) (actual rows= loops=)

  • Recheck Cond: (kilo_foxtrot_six = seven_two1.quebec_seven)
20. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on foxtrot_tango (cost=0.000..4.390 rows=14 width=0) (actual rows= loops=)

  • Index Cond: (kilo_foxtrot_six = seven_two1.quebec_seven)
21. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.280..9.710 rows=1 width=4) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on four_zulu (cost=0.000..1.400 rows=1 width=4) (actual rows= loops=)

  • Filter: (kilo_foxtrot_six = seven_two1.quebec_seven)
23. 0.000 0.000 ↓ 0.0

Index Scan using kilo_papa on tango_six (cost=0.280..8.290 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven = four_zulu.tango_golf)
24. 0.000 0.000 ↓ 0.0

Aggregate (cost=292.100..292.110 rows=1 width=32) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

HashAggregate (cost=289.780..290.810 rows=103 width=38) (actual rows= loops=)

  • Group Key: oscar_three.four_three
26. 0.000 0.000 ↓ 0.0

Append (cost=151.820..289.520 rows=103 width=38) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash Join (cost=151.820..252.700 rows=88 width=38) (actual rows= loops=)

  • Hash Cond: (whiskey1.xray_five = oscar_three.quebec_seven)
28. 0.000 0.000 ↓ 0.0

Hash Join (cost=144.060..243.730 rows=88 width=4) (actual rows= loops=)

  • Hash Cond: (charlie1.india_juliet = whiskey1.quebec_seven)
29. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on romeo_zulu four_whiskey (cost=4.970..103.430 rows=88 width=4) (actual rows= loops=)

  • Recheck Cond: (kilo_foxtrot_six = seven_two1.quebec_seven)
30. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on alpha_india_delta (cost=0.000..4.950 rows=88 width=0) (actual rows= loops=)

  • Index Cond: (kilo_foxtrot_six = seven_two1.quebec_seven)
31. 0.000 0.000 ↓ 0.0

Hash (cost=81.820..81.820 rows=4,582 width=8) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on bravo_three alpha_yankee (cost=0.000..81.820 rows=4,582 width=8) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=4.560..4.560 rows=256 width=42) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on oscar_three (cost=0.000..4.560 rows=256 width=42) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Hash Join (cost=20.240..25.900 rows=14 width=38) (actual rows= loops=)

  • Hash Cond: (tango_uniform_november1.quebec_seven = five_golf1.xray_five)
36. 0.000 0.000 ↓ 0.0

Seq Scan on oscar_three kilo_whiskey (cost=0.000..4.560 rows=256 width=42) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash (cost=20.070..20.070 rows=14 width=4) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on alpha_papa romeo_sierra (cost=4.390..20.070 rows=14 width=4) (actual rows= loops=)

  • Recheck Cond: (kilo_foxtrot_six = seven_two1.quebec_seven)
39. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on foxtrot_tango (cost=0.000..4.390 rows=14 width=0) (actual rows= loops=)

  • Index Cond: (kilo_foxtrot_six = seven_two1.quebec_seven)
40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.420..9.890 rows=1 width=38) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.280..9.710 rows=1 width=4) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Seq Scan on four_zulu golf_xray (cost=0.000..1.400 rows=1 width=4) (actual rows= loops=)

  • Filter: (kilo_foxtrot_six = seven_two1.quebec_seven)
43. 0.000 0.000 ↓ 0.0

Index Scan using kilo_papa on tango_six echo_zulu (cost=0.280..8.290 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven = victor_quebec1.tango_golf)
44. 0.000 0.000 ↓ 0.0

Index Scan using zulu_oscar on oscar_three delta_sierra (cost=0.140..0.170 rows=1 width=42) (actual rows= loops=)

  • Index Cond: (quebec_seven = hotel_papa1.xray_five)
45. 0.000 0.000 ↓ 0.0

Aggregate (cost=114.840..114.850 rows=1 width=32) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on juliet_alpha (cost=0.000..114.750 rows=34 width=4) (actual rows= loops=)

  • Filter: (kilo_foxtrot_six = seven_two1.quebec_seven)
47.          

CTE victor_yankee

48. 0.000 0.000 ↓ 0.0

Seq Scan on victor_yankee delta_golf (cost=0.000..129.090 rows=6,009 width=62) (actual rows= loops=)

49.          

CTE bravo_mike_zulu

50. 0.000 0.000 ↓ 0.0

Seq Scan on bravo_mike_zulu kilo_romeo (cost=0.000..7,481.150 rows=190,732 width=36) (actual rows= loops=)

51.          

CTE victor_whiskey

52. 0.000 0.000 ↓ 0.0

Seq Scan on victor_whiskey xray_tango (cost=3,494.660..4,028,759.160 rows=13,411 width=165) (actual rows= loops=)

53.          

CTE juliet_golf

54. 0.000 0.000 ↓ 0.0

Seq Scan on uniform_echo (cost=0.000..3,494.660 rows=1 width=8) (actual rows= loops=)

  • Filter: ((NOT mike_lima) AND ((victor_juliet)::text = 'six_kilo'::text) AND ((alpha_bravo)::text = 'seven_papa'::text))
55.          

SubPlan (forSeq Scan)

56. 0.000 0.000 ↓ 0.0

Aggregate (cost=66.540..66.560 rows=1 width=32) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on bravo_juliet (cost=4.790..66.380 rows=65 width=4) (actual rows= loops=)

  • Recheck Cond: (zulu_tango = two_sierra_oscar1.quebec_seven)
58. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on five_uniform (cost=0.000..4.770 rows=65 width=0) (actual rows= loops=)

  • Index Cond: (zulu_tango = two_sierra_oscar1.quebec_seven)
59. 0.000 0.000 ↓ 0.0

Aggregate (cost=225.160..225.170 rows=1 width=32) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.770..225.090 rows=26 width=8) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on two_sierra_mike (cost=4.480..28.960 rows=26 width=4) (actual rows= loops=)

  • Recheck Cond: (zulu_tango = two_sierra_oscar1.quebec_seven)
62. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on kilo_tango (cost=0.000..4.480 rows=26 width=0) (actual rows= loops=)

  • Index Cond: (zulu_tango = two_sierra_oscar1.quebec_seven)
63. 0.000 0.000 ↓ 0.0

Index Scan using seven_charlie on papa_mike_lima (cost=0.290..7.530 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (quebec_seven = two_sierra_mike.four_victor)
64. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.330..8.340 rows=1 width=8) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.280..8.330 rows=1 width=0) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

CTE Scan on juliet_golf (cost=0.000..0.020 rows=1 width=8) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Index Only Scan using romeo_mike on yankee_romeo alpha_hotel (cost=0.280..8.300 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((zulu_tango = two_sierra_oscar1.delta_mike) AND (oscar_foxtrot = juliet_golf.quebec_seven))
68.          

CTE echo_papa

69. 0.000 0.000 ↓ 0.0

Seq Scan on echo_papa kilo_november (cost=3,494.660..5,613,874.040 rows=180,271 width=589) (actual rows= loops=)

70.          

CTE juliet_golf

71. 0.000 0.000 ↓ 0.0

Seq Scan on uniform_echo xray_romeo_alpha (cost=0.000..3,494.660 rows=1 width=8) (actual rows= loops=)

  • Filter: ((NOT mike_lima) AND ((victor_juliet)::text = 'six_kilo'::text) AND ((alpha_bravo)::text = 'seven_papa'::text))
72.          

SubPlan (forSeq Scan)

73. 0.000 0.000 ↓ 0.0

Aggregate (cost=31.090..31.100 rows=1 width=8) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.430..31.070 rows=7 width=0) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

CTE Scan on juliet_golf bravo_mike_november (cost=0.000..0.020 rows=1 width=8) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on five_zulu lima_two (cost=4.430..30.980 rows=7 width=4) (actual rows= loops=)

  • Recheck Cond: ((bravo_tango = sierra_golf1.delta_mike) AND (oscar_foxtrot = two_whiskey1.quebec_seven))
77. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on four_delta (cost=0.000..4.430 rows=7 width=0) (actual rows= loops=)

  • Index Cond: ((bravo_tango = sierra_golf1.delta_mike) AND (oscar_foxtrot = two_whiskey1.quebec_seven))
78.          

CTE november_juliet

79. 0.000 0.000 ↓ 0.0

Seq Scan on alpha_seven_india (cost=0.000..326.240 rows=1,461 width=48) (actual rows= loops=)

  • Filter: (('hotel_bravo'::timestamp without time zone >= foxtrot_three) AND ('hotel_bravo'::timestamp without time zone <= lima_romeo))
80.          

CTE five_five

81. 0.000 0.000 ↓ 0.0

Seq Scan on five_five romeo_bravo (cost=0.000..229.030 rows=7,703 width=162) (actual rows= loops=)

82.          

CTE echo_golf

83. 0.000 0.000 ↓ 0.0

HashAggregate (cost=4,381.740..4,383.740 rows=200 width=20) (actual rows= loops=)

  • Group Key: four_uniform.mike_romeo
84. 0.000 0.000 ↓ 0.0

Seq Scan on four_uniform (cost=0.000..3,452.280 rows=123,928 width=12) (actual rows= loops=)

85.          

CTE november_kilo

86. 0.000 0.000 ↓ 0.0

Seq Scan on november_kilo alpha_seven_victor (cost=0.000..1,803.960 rows=27,496 width=16) (actual rows= loops=)

87.          

CTE juliet_victor

88. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=58.300..286.780 rows=1,251 width=52) (actual rows= loops=)

  • Hash Cond: (november_mike.bravo_tango = echo_three.bravo_tango)
89. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=33.300..248.190 rows=1,251 width=44) (actual rows= loops=)

  • Hash Cond: (november_mike.bravo_tango = lima_tango.bravo_tango)
90. 0.000 0.000 ↓ 0.0

Seq Scan on november_uniform november_mike (cost=0.000..198.510 rows=1,251 width=36) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash (cost=18.690..18.690 rows=1,169 width=12) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Seq Scan on delta_tango lima_tango (cost=0.000..18.690 rows=1,169 width=12) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Hash (cost=13.890..13.890 rows=889 width=12) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Seq Scan on lima_india echo_three (cost=0.000..13.890 rows=889 width=12) (actual rows= loops=)

95.          

CTE echo_foxtrot

96. 0.000 0.000 ↓ 0.0

Seq Scan on echo_foxtrot victor_alpha (cost=0.000..39.120 rows=2,712 width=8) (actual rows= loops=)

97.          

CTE six_yankee

98. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15.840..20.220 rows=66 width=100) (actual rows= loops=)

  • Hash Cond: (five_alpha3.bravo_tango = hotel_victor.bravo_tango)
99.          

CTE mike_foxtrot

100. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.160..3.140 rows=66 width=36) (actual rows= loops=)

  • Hash Cond: (victor_two.yankee_lima = mike_xray.quebec_seven)
101. 0.000 0.000 ↓ 0.0

Seq Scan on victor_two (cost=0.000..1.660 rows=66 width=8) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Hash (cost=1.070..1.070 rows=7 width=36) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Seq Scan on mike_xray (cost=0.000..1.070 rows=7 width=36) (actual rows= loops=)

104.          

CTE alpha_india_india

105. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.160..3.140 rows=66 width=36) (actual rows= loops=)

  • Hash Cond: (five_alpha1.mike_juliet = tango_alpha.quebec_seven)
106. 0.000 0.000 ↓ 0.0

Seq Scan on victor_two alpha_oscar (cost=0.000..1.660 rows=66 width=8) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Hash (cost=1.070..1.070 rows=7 width=36) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Seq Scan on tango_alpha (cost=0.000..1.070 rows=7 width=36) (actual rows= loops=)

109.          

CTE hotel_victor

110. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.160..3.140 rows=66 width=36) (actual rows= loops=)

  • Hash Cond: (five_alpha2.sierra_kilo = romeo_five.quebec_seven)
111. 0.000 0.000 ↓ 0.0

Seq Scan on victor_two zulu_six (cost=0.000..1.660 rows=66 width=8) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Hash (cost=1.070..1.070 rows=7 width=36) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_five (cost=0.000..1.070 rows=7 width=36) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=4.290..7.770 rows=66 width=68) (actual rows= loops=)

  • Hash Cond: (five_alpha3.bravo_tango = alpha_india_india.bravo_tango)
115. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2.150..4.710 rows=66 width=36) (actual rows= loops=)

  • Hash Cond: (five_alpha3.bravo_tango = mike_foxtrot.bravo_tango)
116. 0.000 0.000 ↓ 0.0

Seq Scan on victor_two seven_four (cost=0.000..1.660 rows=66 width=4) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Hash (cost=1.320..1.320 rows=66 width=36) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

CTE Scan on mike_foxtrot (cost=0.000..1.320 rows=66 width=36) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Hash (cost=1.320..1.320 rows=66 width=36) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

CTE Scan on alpha_india_india (cost=0.000..1.320 rows=66 width=36) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Hash (cost=1.320..1.320 rows=66 width=36) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

CTE Scan on hotel_victor (cost=0.000..1.320 rows=66 width=36) (actual rows= loops=)

123.          

CTE three_xray

124. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=9.580..10.760 rows=7 width=100) (actual rows= loops=)

  • Hash Cond: (golf_hotel.quebec_seven = india_charlie.oscar_mike_six)
125.          

CTE foxtrot_zulu

126. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.040..3.160 rows=1 width=36) (actual rows= loops=)

  • Hash Cond: ((sierra_seven1.quebec_seven)::text = two_tango1.uniform_six)
127. 0.000 0.000 ↓ 0.0

Seq Scan on mike_xray tango_uniform_india (cost=0.000..1.070 rows=7 width=36) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Hash (cost=2.030..2.030 rows=1 width=36) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Seq Scan on three_xray kilo_golf (cost=0.000..2.030 rows=1 width=36) (actual rows= loops=)

  • Filter: (november_lima = 'sierra_uniform_uniform'::text)
130.          

CTE kilo_foxtrot_uniform

131. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.040..3.160 rows=1 width=36) (actual rows= loops=)

  • Hash Cond: ((papa_juliet1.quebec_seven)::text = two_tango2.uniform_six)
132. 0.000 0.000 ↓ 0.0

Seq Scan on tango_alpha five_yankee (cost=0.000..1.070 rows=7 width=36) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Hash (cost=2.030..2.030 rows=1 width=36) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Seq Scan on three_xray foxtrot_four (cost=0.000..2.030 rows=1 width=36) (actual rows= loops=)

  • Filter: (november_lima = 'seven_echo'::text)
135.          

CTE india_charlie

136. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.040..3.160 rows=1 width=36) (actual rows= loops=)

  • Hash Cond: ((mike_whiskey1.quebec_seven)::text = two_tango3.uniform_six)
137. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_five sierra_uniform_xray (cost=0.000..1.070 rows=7 width=36) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Hash (cost=2.030..2.030 rows=1 width=36) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Seq Scan on three_xray foxtrot_india (cost=0.000..2.030 rows=1 width=36) (actual rows= loops=)

  • Filter: (november_lima = 'tango_tango'::text)
140. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.070..1.210 rows=7 width=68) (actual rows= loops=)

  • Hash Cond: (golf_hotel.quebec_seven = kilo_foxtrot_uniform.oscar_mike_six)
141. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.030..1.140 rows=7 width=36) (actual rows= loops=)

  • Hash Cond: (golf_hotel.quebec_seven = foxtrot_zulu.oscar_mike_six)
142. 0.000 0.000 ↓ 0.0

Seq Scan on golf_hotel (cost=0.000..1.070 rows=7 width=4) (actual rows= loops=)

143. 0.000 0.000 ↓ 0.0

Hash (cost=0.020..0.020 rows=1 width=36) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

CTE Scan on foxtrot_zulu (cost=0.000..0.020 rows=1 width=36) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

Hash (cost=0.020..0.020 rows=1 width=36) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

CTE Scan on kilo_foxtrot_uniform (cost=0.000..0.020 rows=1 width=36) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Hash (cost=0.020..0.020 rows=1 width=36) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

CTE Scan on india_charlie (cost=0.000..0.020 rows=1 width=36) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Sort (cost=3,909,214.880..3,970,638.190 rows=24,569,326 width=20) (actual rows= loops=)

  • Sort Key: three_victor.hotel_xray
150. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=20,745.640..389,423.010 rows=24,569,326 width=20) (actual rows= loops=)

  • Merge Cond: (november_kilo.two_zulu = three_victor.two_zulu)
151. 0.000 0.000 ↓ 0.0

Sort (cost=2,577.330..2,646.070 rows=27,496 width=16) (actual rows= loops=)

  • Sort Key: november_kilo.two_zulu
152. 0.000 0.000 ↓ 0.0

CTE Scan on november_kilo (cost=0.000..549.920 rows=27,496 width=16) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Sort (cost=18,168.310..18,615.090 rows=178,712 width=8) (actual rows= loops=)

  • Sort Key: three_victor.two_zulu
154. 0.000 0.000 ↓ 0.0

Seq Scan on three_victor (cost=0.000..2,578.120 rows=178,712 width=8) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Materialize (cost=17,297,560,790,824,796,160.000..17,316,635,669,554,128,896.000 rows=3,814,975,745,866,537,472 width=1,934) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Sort (cost=17,297,560,790,824,796,160.000..17,307,098,230,189,461,504.000 rows=3,814,975,745,866,537,472 width=1,934) (actual rows= loops=)

  • Sort Key: echo_papa.six_india
157. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=57,682,589,315.040..146,789,430,997,980,448.000 rows=3,814,975,745,866,537,472 width=1,934) (actual rows= loops=)

  • Hash Cond: (echo_papa.quebec_seven = echo_foxtrot.oscar_mike_seven)
158. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=57,682,589,215.550..12,632,264,005,616,172.000 rows=281,340,394,237,945,216 width=1,826) (actual rows= loops=)

  • Hash Cond: (echo_papa.quebec_seven = juliet_victor.bravo_tango)
159. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=57,682,589,174.890..2,678,526,316,590,189.000 rows=44,978,480,293,836,160 width=1,774) (actual rows= loops=)

  • Hash Cond: (echo_papa.quebec_seven = six_yankee.alpha_xray)
160. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=57,682,589,172.750..2,361,428,030,518,641.500 rows=44,978,480,293,836,160 width=1,674) (actual rows= loops=)

  • Hash Cond: (echo_papa.zulu_three = echo_golf.zulu_three)
161. 0.000 0.000 ↓ 0.0

Merge Join (cost=57,682,589,166.250..674,735,019,499,779.500 rows=44,978,480,293,836,160 width=1,654) (actual rows= loops=)

  • Merge Cond: (echo_papa.zulu_tango = victor_whiskey.zulu_tango)
162. 0.000 0.000 ↓ 0.0

Sort (cost=73,941,685.440..74,369,330.430 rows=171,057,994 width=625) (actual rows= loops=)

  • Sort Key: echo_papa.zulu_tango
163. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=39,800.730..2,606,567.490 rows=171,057,994 width=625) (actual rows= loops=)

  • Merge Cond: (echo_papa.zulu_juliet = bravo_mike_zulu.papa_mike_seven)
164. 0.000 0.000 ↓ 0.0

Sort (cost=19,257.770..19,706.190 rows=179,370 width=589) (actual rows= loops=)

  • Sort Key: echo_papa.zulu_juliet
165. 0.000 0.000 ↓ 0.0

CTE Scan on echo_papa (cost=0.000..3,605.420 rows=179,370 width=589) (actual rows= loops=)

  • Filter: (uniform_two five_romeo NOT NULL)
166. 0.000 0.000 ↓ 0.0

Sort (cost=20,542.970..21,019.800 rows=190,732 width=36) (actual rows= loops=)

  • Sort Key: bravo_mike_zulu.papa_mike_seven
167. 0.000 0.000 ↓ 0.0

CTE Scan on bravo_mike_zulu (cost=0.000..3,814.640 rows=190,732 width=36) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Materialize (cost=57,608,647,480.810..57,871,590,353.300 rows=52,588,574,499 width=1,029) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Sort (cost=57,608,647,480.810..57,740,118,917.060 rows=52,588,574,499 width=1,029) (actual rows= loops=)

  • Sort Key: victor_whiskey.zulu_tango
170. 0.000 0.000 ↓ 0.0

Merge Join (cost=2,375,466.530..791,220,518.200 rows=52,588,574,499 width=1,029) (actual rows= loops=)

  • Merge Cond: (bravo_hotel.kilo_foxtrot_six = victor_whiskey.bravo_hotel)
171. 0.000 0.000 ↓ 0.0

Sort (cost=884,130.470..891,099.110 rows=2,787,455 width=424) (actual rows= loops=)

  • Sort Key: bravo_hotel.kilo_foxtrot_six
172. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=10,347.840..52,189.710 rows=2,787,455 width=424) (actual rows= loops=)

  • Merge Cond: (victor_yankee.uniform_india = bravo_hotel.zulu_uniform)
173. 0.000 0.000 ↓ 0.0

Sort (cost=497.330..512.350 rows=6,009 width=62) (actual rows= loops=)

  • Sort Key: victor_yankee.uniform_india
174. 0.000 0.000 ↓ 0.0

CTE Scan on victor_yankee (cost=0.000..120.180 rows=6,009 width=62) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Sort (cost=9,850.510..10,082.450 rows=92,776 width=362) (actual rows= loops=)

  • Sort Key: bravo_hotel.zulu_uniform
176. 0.000 0.000 ↓ 0.0

Merge Join (cost=790.920..2,195.810 rows=92,776 width=362) (actual rows= loops=)

  • Merge Cond: (november_victor.delta_whiskey = bravo_hotel.uniform_uniform)
177. 0.000 0.000 ↓ 0.0

Sort (cost=203.680..210.300 rows=2,650 width=254) (actual rows= loops=)

  • Sort Key: november_victor.delta_whiskey
178. 0.000 0.000 ↓ 0.0

CTE Scan on november_victor (cost=0.000..53.000 rows=2,650 width=254) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Sort (cost=587.240..604.750 rows=7,002 width=108) (actual rows= loops=)

  • Sort Key: bravo_hotel.uniform_uniform
180. 0.000 0.000 ↓ 0.0

CTE Scan on bravo_hotel (cost=0.000..140.040 rows=7,002 width=108) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Materialize (cost=1,491,336.060..1,510,202.050 rows=3,773,199 width=605) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Sort (cost=1,491,336.060..1,500,769.050 rows=3,773,199 width=605) (actual rows= loops=)

  • Sort Key: victor_whiskey.bravo_hotel
183. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,944.970..60,324.430 rows=3,773,199 width=605) (actual rows= loops=)

  • Merge Cond: (victor_whiskey.victor_delta = five_five.quebec_seven)
184. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,293.640..2,830.200 rows=97,967 width=443) (actual rows= loops=)

  • Merge Cond: (victor_whiskey.victor_delta = november_juliet.india_two)
185. 0.000 0.000 ↓ 0.0

Sort (cost=1,187.620..1,221.150 rows=13,411 width=395) (actual rows= loops=)

  • Sort Key: victor_whiskey.victor_delta
186. 0.000 0.000 ↓ 0.0

CTE Scan on victor_whiskey (cost=0.000..268.220 rows=13,411 width=395) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Sort (cost=106.020..109.670 rows=1,461 width=48) (actual rows= loops=)

  • Sort Key: november_juliet.india_two
188. 0.000 0.000 ↓ 0.0

CTE Scan on november_juliet (cost=0.000..29.220 rows=1,461 width=48) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Sort (cost=651.340..670.590 rows=7,703 width=162) (actual rows= loops=)

  • Sort Key: five_five.quebec_seven
190. 0.000 0.000 ↓ 0.0

CTE Scan on five_five (cost=0.000..154.060 rows=7,703 width=162) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Hash (cost=4.000..4.000 rows=200 width=20) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

CTE Scan on echo_golf (cost=0.000..4.000 rows=200 width=20) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Hash (cost=1.320..1.320 rows=66 width=100) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

CTE Scan on six_yankee (cost=0.000..1.320 rows=66 width=100) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Hash (cost=25.020..25.020 rows=1,251 width=52) (actual rows= loops=)

196. 0.000 0.000 ↓ 0.0

CTE Scan on juliet_victor (cost=0.000..25.020 rows=1,251 width=52) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

Hash (cost=65.590..65.590 rows=2,712 width=108) (actual rows= loops=)

198. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.230..65.590 rows=2,712 width=108) (actual rows= loops=)

  • Hash Cond: (echo_foxtrot.five_hotel = three_xray.kilo_oscar)
199. 0.000 0.000 ↓ 0.0

CTE Scan on echo_foxtrot (cost=0.000..54.240 rows=2,712 width=8) (actual rows= loops=)

200. 0.000 0.000 ↓ 0.0

Hash (cost=0.140..0.140 rows=7 width=100) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

CTE Scan on three_xray (cost=0.000..0.140 rows=7 width=100) (actual rows= loops=)