explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pCpX

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

Aggregate (cost=8,535,675.880..8,535,675.890 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Limit (cost=8,535,675.130..8,535,675.250 rows=50 width=40) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=8,535,675.130..8,535,675.320 rows=76 width=40) (actual rows= loops=)

  • Sort Key: two_yankee.romeo_hotel DESC
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=112,265.240..8,535,672.750 rows=76 width=40) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=112,261.670..8,535,397.630 rows=76 width=606) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=36.760..6,302.380 rows=76 width=574) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=35.340..6,191.990 rows=76 width=542) (actual rows= loops=)

  • Join Filter: (two_yankee.five_lima = yankee_oscar.quebec_seven)
8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=35.200..6,176.390 rows=76 width=514) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=33.740..5,451.350 rows=76 width=486) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=18.120..3,781.250 rows=76 width=465) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=17.970..3,719.370 rows=76 width=433) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=17.830..3,681.880 rows=76 width=401) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=17.670..3,620.010 rows=76 width=369) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=17.520..3,558.330 rows=76 width=337) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.910..1,888.230 rows=76 width=316) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.300..104.780 rows=76 width=288) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.150..67.280 rows=76 width=256) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on two_yankee (cost=0.000..5.410 rows=76 width=224) (actual rows= loops=)

  • Filter: (five_lima = 1)
19. 0.000 0.000 ↓ 0.0

Index Only Scan using bravo_zulu on xray_juliet (cost=0.150..0.810 rows=1 width=64) (actual rows= loops=)

  • Index Cond: (november_lima = two_yankee.mike)
20.          

SubPlan (for Index Only Scan)

21. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Index Scan using zulu on five_hotel (cost=0.140..0.490 rows=1 width=43) (actual rows= loops=)

  • Index Cond: (two_yankee.oscar_golf = quebec_seven)
  • Filter: (five_lima = 1)
23.          

SubPlan (for Index Scan)

24. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Limit (cost=1.610..23.450 rows=1 width=32) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.610..23.450 rows=1 width=32) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.150..13.890 rows=1 width=100) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on two_yankee xray_lima (cost=0.000..5.700 rows=1 width=68) (actual rows= loops=)

  • Filter: ((two_yankee.xray_six = quebec_seven) AND (five_lima = 1))
29. 0.000 0.000 ↓ 0.0

Index Scan using bravo_golf on five_bravo quebec_echo (cost=0.150..8.180 rows=1 width=64) (actual rows= loops=)

  • Index Cond: (victor_oscar1.juliet_charlie = november_lima)
30.          

SubPlan (for Index Scan)

31. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.460..9.520 rows=1 width=32) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Index Scan using sierra on november_juliet (cost=0.420..8.440 rows=1 width=234) (actual rows= loops=)

  • Index Cond: (victor_oscar1.bravo_papa = quebec_seven)
34. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.040..1.050 rows=1 width=32) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Limit (cost=0.000..1.030 rows=1 width=32) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on victor_mike (cost=0.000..1.030 rows=1 width=32) (actual rows= loops=)

  • Filter: ((november_juliet.quebec_seven = bravo_papa) AND (five_lima = 1))
37.          

SubPlan (for Seq Scan)

38. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

39.          

SubPlan (for Nested Loop Left Join)

40. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

41.          

SubPlan (for Nested Loop Left Join)

42. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=15.620..21.950 rows=1 width=32) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on five_hotel juliet_sierra (cost=0.000..6.290 rows=1 width=90) (actual rows= loops=)

  • Filter: ((two_yankee.romeo_two = quebec_seven) AND (five_lima = 1))
45. 0.000 0.000 ↓ 0.0

Aggregate (cost=15.620..15.630 rows=1 width=32) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.460..15.600 rows=1 width=32) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Seq Scan on xray_five (cost=0.000..6.060 rows=1 width=4) (actual rows= loops=)

  • Filter: ((victor_charlie2.quebec_seven = zulu) AND (five_lima = 1))
48. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.460..9.520 rows=1 width=32) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Index Scan using sierra on november_juliet echo_romeo (cost=0.420..8.440 rows=1 width=234) (actual rows= loops=)

  • Index Cond: (xray_five.bravo_papa = quebec_seven)
50. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.040..1.050 rows=1 width=32) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Limit (cost=0.000..1.030 rows=1 width=32) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Seq Scan on victor_mike november_november_alpha (cost=0.000..1.030 rows=1 width=32) (actual rows= loops=)

  • Filter: ((india_xray1.quebec_seven = bravo_papa) AND (five_lima = 1))
53.          

SubPlan (for Seq Scan)

54. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

55.          

SubPlan (for Nested Loop Left Join)

56. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

57.          

SubPlan (for Aggregate)

58. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

59.          

SubPlan (for Nested Loop Left Join)

60. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Index Scan using bravo_golf on five_bravo (cost=0.150..0.810 rows=1 width=64) (actual rows= loops=)

  • Index Cond: (two_yankee.juliet_charlie = november_lima)
62.          

SubPlan (for Index Scan)

63. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Index Only Scan using oscar_four on yankee_india (cost=0.150..0.810 rows=1 width=64) (actual rows= loops=)

  • Index Cond: (november_lima = two_yankee.xray_whiskey)
65.          

SubPlan (for Index Only Scan)

66. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Index Scan using zulu on five_hotel whiskey (cost=0.140..0.490 rows=1 width=43) (actual rows= loops=)

  • Index Cond: (two_yankee.uniform_echo = quebec_seven)
  • Filter: (five_lima = 1)
68.          

SubPlan (for Index Scan)

69. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Index Only Scan using hotel on seven (cost=0.150..0.810 rows=1 width=64) (actual rows= loops=)

  • Index Cond: (november_lima = two_yankee.echo_foxtrot)
71.          

SubPlan (for Index Only Scan)

72. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=15.620..21.950 rows=1 width=32) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Seq Scan on five_hotel uniform_victor_foxtrot (cost=0.000..6.290 rows=1 width=90) (actual rows= loops=)

  • Filter: ((two_yankee.golf_victor = quebec_seven) AND (five_lima = 1))
75. 0.000 0.000 ↓ 0.0

Aggregate (cost=15.620..15.630 rows=1 width=32) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.460..15.600 rows=1 width=32) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Seq Scan on xray_five november_november_four (cost=0.000..6.060 rows=1 width=4) (actual rows= loops=)

  • Filter: ((victor_charlie3.quebec_seven = zulu) AND (five_lima = 1))
78. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.460..9.520 rows=1 width=32) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Index Scan using sierra on november_juliet victor_alpha (cost=0.420..8.440 rows=1 width=234) (actual rows= loops=)

  • Index Cond: (xray_three1.bravo_papa = quebec_seven)
80. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.040..1.050 rows=1 width=32) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Limit (cost=0.000..1.030 rows=1 width=32) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Seq Scan on victor_mike bravo_hotel (cost=0.000..1.030 rows=1 width=32) (actual rows= loops=)

  • Filter: ((india_xray2.quebec_seven = bravo_papa) AND (five_lima = 1))
83.          

SubPlan (for Seq Scan)

84. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

85.          

SubPlan (for Nested Loop Left Join)

86. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

87.          

SubPlan (for Aggregate)

88. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

89.          

SubPlan (for Nested Loop Left Join)

90. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.460..9.520 rows=1 width=32) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Index Scan using sierra on november_juliet papa (cost=0.420..8.440 rows=1 width=234) (actual rows= loops=)

  • Index Cond: (two_yankee.bravo_papa = quebec_seven)
93. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.040..1.050 rows=1 width=32) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Limit (cost=0.000..1.030 rows=1 width=32) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Seq Scan on victor_mike victor_uniform (cost=0.000..1.030 rows=1 width=32) (actual rows= loops=)

  • Filter: ((india_xray3.quebec_seven = bravo_papa) AND (five_lima = 1))
96.          

SubPlan (for Seq Scan)

97. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

98.          

SubPlan (for Nested Loop Left Join)

99. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Materialize (cost=0.140..14.470 rows=1 width=36) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Index Only Scan using golf_three on yankee_oscar (cost=0.140..14.460 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (quebec_seven = 1)
102.          

SubPlan (for Index Only Scan)

103. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.420..1.430 rows=1 width=32) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Seq Scan on charlie_sierra (cost=0.000..1.390 rows=2 width=9) (actual rows= loops=)

  • Filter: ((two_yankee.quebec_seven = charlie_seven) AND (five_lima = 1))
106.          

SubPlan (for Aggregate)

107. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Aggregate (cost=112,224.910..112,224.920 rows=1 width=32) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=112,184.630..112,224.890 rows=1 width=37) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.280..16.370 rows=1 width=9) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Seq Scan on victor_two (cost=0.000..2.360 rows=1 width=13) (actual rows= loops=)

  • Filter: (yankee_mike AND (charlie_seven = two_yankee.quebec_seven))
112. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.280..14.000 rows=1 width=8) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Index Scan using tango on charlie_yankee xray_mike (cost=0.280..8.290 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (quebec_seven = victor_two.two_kilo)
  • Filter: (five_lima = 1)
114. 0.000 0.000 ↓ 0.0

Seq Scan on two_yankee alpha (cost=0.000..5.700 rows=1 width=4) (actual rows= loops=)

  • Filter: ((quebec_seven = two_yankee.quebec_seven) AND (five_lima = 1))
115. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=112,184.350..112,208.500 rows=1 width=32) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.830..24.930 rows=1 width=176) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Index Scan using tango on charlie_yankee (cost=0.280..8.290 rows=1 width=144) (actual rows= loops=)

  • Index Cond: (victor_two.two_kilo = quebec_seven)
  • Filter: (five_lima = 1)
118. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.550..16.610 rows=1 width=32) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Index Scan using romeo_xray on bravo_six (cost=0.280..8.290 rows=1 width=97) (actual rows= loops=)

  • Index Cond: (two_kilo = charlie_yankee.quebec_seven)
120. 0.000 0.000 ↓ 0.0

Index Scan using tango on charlie_yankee november_tango (cost=0.280..8.290 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (quebec_seven = charlie_yankee.quebec_seven)
  • Filter: (five_lima = 1)
121.          

SubPlan (for Nested Loop Semi Join)

122. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Aggregate (cost=112,183.530..112,183.540 rows=1 width=32) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Limit (cost=0.000..112,183.510 rows=1 width=32) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.000..112,183.510 rows=1 width=32) (actual rows= loops=)

  • Join Filter: (echo_mike.quebec_seven = (india_kilo.delta ->> 'five_yankee'::text))
126. 0.000 0.000 ↓ 0.0

Seq Scan on india_kilo (cost=0.000..112,175.650 rows=1 width=1,204) (actual rows= loops=)

  • Filter: ((foxtrot = 'uniform_victor_romeo'::text) AND (charlie_yankee.quebec_seven = ((delta ->> 'juliet_india'::text))::integer) AND (((delta ->> 'six'::text))::integer = 1))
127. 0.000 0.000 ↓ 0.0

Seq Scan on five_hotel echo_mike (cost=0.000..5.530 rows=153 width=27) (actual rows= loops=)

128.          

SubPlan (for Nested Loop Left Join)

129. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.040 rows=1 width=32) (actual rows= loops=)

130.          

SubPlan (for Nested Loop Left Join)

131. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

132.          

SubPlan (for Aggregate)

133. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Aggregate (cost=3.580..3.590 rows=1 width=32) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Seq Scan on kilo (cost=0.000..3.540 rows=2 width=25) (actual rows= loops=)

  • Filter: ((two_yankee.quebec_seven = charlie_seven) AND (five_lima = 1))
136.          

SubPlan (for Aggregate)

137. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)

138.          

SubPlan (for Nested Loop Left Join)

139. 0.000 0.000 ↓ 0.0

Result (cost=0.000..0.010 rows=1 width=32) (actual rows= loops=)