explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aREv : why the high recursion cost estimate?

Settings
# exclusive inclusive rows x rows loops node
1. 227.857 227.857 ↓ 1.8 1,595 1

CTE Scan on quebec_bravo_sierra three_hotel (cost=85,800.720..85,818.120 rows=870 width=376) (actual time=0.067..227.857 rows=1,595 loops=1)

2.          

CTE quebec_bravo_sierra

3. 2.051 224.916 ↓ 1.8 1,595 1

Recursive Union (cost=44.270..85,800.720 rows=870 width=381) (actual time=0.063..224.916 rows=1,595 loops=1)

4. 0.015 0.061 ↑ 20.0 1 1

HashAggregate (cost=44.270..44.520 rows=20 width=306) (actual time=0.061..0.061 rows=1 loops=1)

  • Group Key: five_kilo14.foxtrot_romeo, five_kilo14.zulu_xray, five_kilo14.uniform_xray, five_kilo14.uniform_quebec
5. 0.010 0.046 ↑ 6.7 3 1

Bitmap Heap Scan on bravo_kilo echo_november (cost=6.100..44.020 rows=20 width=30) (actual time=0.044..0.046 rows=3 loops=1)

  • Recheck Cond: (((tango_india = 'tango_zulu_november'::text) AND (uniform_quebec = 2)) OR ((zulu_xray = ''sierra_four'lima_golf0016622'::text) AND (uniform_quebec = 6)))
  • Filter: ((quebec_golf five_romeo NULL) AND (hotel_echo five_romeo NOT NULL) AND (sierra_mike = 1) AND ((uniform_quebec = 2) OR ((foxtrot_romeo = ''quebec_five''::text) AND (uniform_quebec = 6))))
  • Heap Blocks: exact=1
6. 0.001 0.036 ↓ 0.0 0 1

BitmapOr (cost=6.100..6.100 rows=37 width=0) (actual time=0.036..0.036 rows=0 loops=1)

7. 0.024 0.024 ↑ 12.3 3 1

Bitmap Index Scan on papa_mike (cost=0.000..1.930 rows=37 width=0) (actual time=0.024..0.024 rows=3 loops=1)

  • Index Cond: ((tango_india = 'tango_zulu_november'::text) AND (uniform_quebec = 2))
8. 0.000 0.011 ↓ 0.0 0 1

BitmapAnd (cost=3.910..3.910 rows=1 width=0) (actual time=0.011..0.011 rows=0 loops=1)

9. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on charlie_mike_zulu (cost=0.000..1.810 rows=33 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (zulu_xray = ''::text)
10. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on papa_mike (cost=0.000..1.840 rows=28 width=0) (never executed)

  • Index Cond: ((tango_india = 'tango_zulu_november'::text) AND (uniform_quebec = 6))
11. 16.456 222.804 ↓ 2.1 177 9

Nested Loop (cost=8,513.130..8,573.880 rows=85 width=381) (actual time=4.042..24.756 rows=177 loops=9)

12. 1.008 1.008 ↓ 64.0 64 9

WorkTable Scan on (cost=0.000..6.000 rows=1 width=348) (actual time=0.001..0.112 rows=64 loops=9)

  • Filter: ((NOT lima_uniform_sierra) AND (xray_victor > 0.0000000001) AND (alpha_delta < 25) AND ((uniform_quebec = 2) OR (uniform_quebec = 6)))
  • Rows Removed by Filter: 113
13. 1.148 167.608 ↑ 28.3 3 574

Append (cost=8,513.130..8,541.100 rows=85 width=248) (actual time=0.270..0.292 rows=3 loops=574)

14.          

CTE alpha_five

15. 7.720 158.424 ↑ 28.0 3 574

HashAggregate (cost=8,504.310..8,512.290 rows=84 width=248) (actual time=0.261..0.276 rows=3 loops=574)

  • Group Key: juliet_xray.quebec_xray, juliet_xray.tango_india, juliet_xray.uniform_quebec, juliet_xray.november_whiskey, juliet_xray.foxtrot_romeo, juliet_xray.uniform_xray, juliet_xray.zulu_xray, juliet_xray.yankee_lima, juliet_xray.hotel_echo
16.          

CTE romeo_echo

17. 0.574 57.400 ↑ 11.0 3 574

Append (cost=211.530..228.180 rows=33 width=201) (actual time=0.078..0.100 rows=3 loops=574)

18. 2.406 37.310 ↑ 15.5 2 574

Nested Loop (cost=211.530..212.900 rows=31 width=208) (actual time=0.056..0.065 rows=2 loops=574)

19.          

CTE yankee_two

20. 6.438 6.438 ↑ 1.0 1 222

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

21.          

CTE quebec_six

22. 1.148 7.462 ↑ 1.0 1 574

Aggregate (cost=25.880..25.890 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=574)

23. 6.314 6.314 ↑ 10.5 2 574

Index Scan using papa_mike on bravo_kilo november_romeo (cost=0.560..25.820 rows=21 width=5) (actual time=0.011..0.011 rows=2 loops=574)

  • Index Cond: ((tango_india = $7) AND (uniform_quebec = 2))
  • Filter: ((quebec_golf five_romeo NULL) AND (sierra_mike = 1))
  • Rows Removed by Filter: 0
24.          

CTE golf_three

25. 2.220 18.426 ↑ 5.2 6 222

WindowAgg (cost=184.520..185.610 rows=31 width=120) (actual time=0.072..0.083 rows=6 loops=222)

26. 2.442 16.206 ↑ 5.2 6 222

WindowAgg (cost=184.520..185.140 rows=31 width=88) (actual time=0.066..0.073 rows=6 loops=222)

27. 2.442 13.764 ↑ 5.2 6 222

Sort (cost=184.520..184.600 rows=31 width=56) (actual time=0.061..0.062 rows=6 loops=222)

  • Sort Key: five_kilo1.foxtrot_romeo, ((five_kilo1.hotel_echo five_romeo NOT NULL))
  • Sort Method: quicksort Memory: 25kB
28. 0.474 11.322 ↑ 5.2 6 222

Nested Loop (cost=0.980..183.760 rows=31 width=56) (actual time=0.018..0.051 rows=6 loops=222)

29. 2.886 2.886 ↑ 5.2 6 222

Index Scan using papa_mike on bravo_kilo whiskey_romeo (cost=0.560..109.270 rows=31 width=51) (actual time=0.010..0.013 rows=6 loops=222)

  • Index Cond: ((tango_india = $7) AND (uniform_quebec = 8))
  • Filter: ((quebec_golf five_romeo NULL) AND (foxtrot_romeo <> $12) AND (sierra_mike = 1) AND ((hotel_echo <= CASE WHEN ($8 = 2) THEN 'sierra_tango'::date ELSE $9 END) OR (hotel_echo five_romeo NULL)))
  • Rows Removed by Filter: 0
30. 7.962 7.962 ↑ 1.0 1 1,327

Index Scan using yankee_echo on kilo_juliet alpha_quebec (cost=0.420..2.400 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=1,327)

  • Index Cond: (foxtrot_romeo = five_kilo1.foxtrot_romeo)
31. 0.228 14.924 ↓ 0.0 0 574

Nested Loop (cost=0.000..0.050 rows=1 width=64) (actual time=0.026..0.026 rows=0 loops=574)

32. 8.036 8.036 ↓ 0.0 0 574

CTE Scan on quebec_six charlie_echo (cost=0.000..0.020 rows=1 width=32) (actual time=0.014..0.014 rows=0 loops=574)

  • Filter: (oscar_seven <> 'november_golf'::numeric)
  • Rows Removed by Filter: 1
33. 6.660 6.660 ↑ 1.0 1 222

CTE Scan on yankee_two india_uniform_xray (cost=0.000..0.020 rows=1 width=32) (actual time=0.030..0.030 rows=1 loops=222)

34. 19.980 19.980 ↑ 5.2 6 222

CTE Scan on golf_three quebec_three (cost=0.000..0.620 rows=31 width=240) (actual time=0.074..0.090 rows=6 loops=222)

  • Filter: (hotel_echo five_romeo NOT NULL)
35. 1.554 14.350 ↑ 1.0 1 574

Nested Loop (cost=4.330..7.390 rows=1 width=87) (actual time=0.024..0.025 rows=1 loops=574)

36. 1.148 10.332 ↑ 1.0 1 574

Bitmap Heap Scan on bravo_kilo seven_three (cost=3.910..4.940 rows=1 width=51) (actual time=0.018..0.018 rows=1 loops=574)

  • Recheck Cond: ((zulu_xray = $15) AND (tango_india = $7) AND (uniform_quebec = 6))
  • Filter: ((hotel_echo five_romeo NOT NULL) AND (quebec_golf five_romeo NULL) AND (oscar_seven < 'november_golf'::numeric) AND (foxtrot_romeo = $12) AND (sierra_mike = 1) AND (hotel_echo <= CASE WHEN ($8 = 2) THEN 'sierra_tango'::date ELSE $9 END))
  • Heap Blocks: exact=352
37. 0.368 9.184 ↓ 0.0 0 574

BitmapAnd (cost=3.910..3.910 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=574)

38. 4.592 4.592 ↑ 33.0 1 574

Bitmap Index Scan on charlie_mike_zulu (cost=0.000..1.810 rows=33 width=0) (actual time=0.008..0.008 rows=1 loops=574)

  • Index Cond: (zulu_xray = $15)
39. 4.224 4.224 ↓ 1.7 48 352

Bitmap Index Scan on papa_mike (cost=0.000..1.850 rows=29 width=0) (actual time=0.012..0.012 rows=48 loops=352)

  • Index Cond: ((tango_india = $7) AND (uniform_quebec = 6))
40. 2.464 2.464 ↑ 1.0 1 352

Index Scan using yankee_echo on kilo_juliet two_uniform (cost=0.420..2.440 rows=1 width=14) (actual time=0.006..0.007 rows=1 loops=352)

  • Index Cond: (foxtrot_romeo = $12)
41. 0.282 5.166 ↓ 0.0 0 574

Result (cost=4.330..7.390 rows=1 width=87) (actual time=0.009..0.009 rows=0 loops=574)

  • One-Time Filter: ($15 = ''::text)
42. 0.222 4.884 ↓ 0.0 0 222

Nested Loop (cost=4.330..7.390 rows=1 width=55) (actual time=0.022..0.022 rows=0 loops=222)

43. 0.222 4.662 ↓ 0.0 0 222

Bitmap Heap Scan on bravo_kilo seven_india (cost=3.910..4.940 rows=1 width=51) (actual time=0.021..0.021 rows=0 loops=222)

  • Recheck Cond: ((zulu_xray = $16) AND (tango_india = $7) AND (uniform_quebec = 6))
  • Filter: ((hotel_echo five_romeo NOT NULL) AND (quebec_golf five_romeo NULL) AND (oscar_seven < 'november_golf'::numeric) AND (foxtrot_romeo = $12) AND (sierra_mike = 1) AND (hotel_echo <= CASE WHEN ($8 = 2) THEN 'sierra_tango'::date ELSE $9 END))
44. 0.000 4.440 ↓ 0.0 0 222

BitmapAnd (cost=3.910..3.910 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=222)

45. 2.442 2.442 ↑ 8.2 4 222

Bitmap Index Scan on charlie_mike_zulu (cost=0.000..1.810 rows=33 width=0) (actual time=0.011..0.011 rows=4 loops=222)

  • Index Cond: (zulu_xray = $16)
46. 1.998 1.998 ↓ 0.0 0 222

Bitmap Index Scan on papa_mike (cost=0.000..1.850 rows=29 width=0) (actual time=0.009..0.009 rows=0 loops=222)

  • Index Cond: ((tango_india = $7) AND (uniform_quebec = 6))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using yankee_echo on kilo_juliet oscar_alpha (cost=0.420..2.440 rows=1 width=14) (never executed)

  • Index Cond: (foxtrot_romeo = $12)
48.          

CTE alpha_five

49. 0.574 141.778 ↑ 28.0 3 574

Append (cost=62.360..8,271.090 rows=84 width=170) (actual time=0.149..0.247 rows=3 loops=574)

50. 0.862 84.378 ↓ 0.0 0 574

Nested Loop Left Join (cost=62.360..2,814.800 rows=64 width=175) (actual time=0.112..0.147 rows=0 loops=574)

51. 0.431 82.082 ↓ 0.0 0 574

Nested Loop (cost=61.940..2,717.150 rows=64 width=170) (actual time=0.111..0.143 rows=0 loops=574)

52. 0.157 80.934 ↓ 0.0 0 574

Nested Loop (cost=61.500..2,560.030 rows=64 width=121) (actual time=0.110..0.141 rows=0 loops=574)

53. 0.766 61.418 ↓ 0.0 0 574

Nested Loop (cost=0.440..79.470 rows=32 width=81) (actual time=0.098..0.107 rows=0 loops=574)

54. 59.696 59.696 ↓ 0.0 0 574

CTE Scan on romeo_echo (cost=0.000..0.910 rows=32 width=72) (actual time=0.097..0.104 rows=0 loops=574)

  • Filter: (((oscar_seven - delta_victor) <> 'november_golf'::numeric) OR (four_seven = 2))
  • Rows Removed by Filter: 3
55. 0.956 0.956 ↑ 1.0 1 239

Index Scan using five_mike on bravo_kilo foxtrot_four (cost=0.440..2.460 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=239)

  • Index Cond: (india_uniform_india = romeo_echo.india_uniform_india)
56. 0.478 19.359 ↑ 2.0 1 239

Append (cost=61.060..77.500 rows=2 width=72) (actual time=0.078..0.081 rows=1 loops=239)

57. 0.239 18.881 ↑ 1.0 1 239

Result (cost=61.060..61.330 rows=1 width=72) (actual time=0.078..0.079 rows=1 loops=239)

  • One-Time Filter: (romeo_echo.oscar_seven < 'november_golf'::numeric)
58. 0.478 18.642 ↑ 1.0 1 239

Nested Loop (cost=61.060..61.320 rows=1 width=72) (actual time=0.077..0.078 rows=1 loops=239)

  • Join Filter: (romeo_three_six2.uniform_four = yankee_lima.tango_romeo)
  • Rows Removed by Join Filter: 1
59.          

CTE charlie_mike_xray

60. 0.000 8.126 ↑ 2.5 2 239

Append (cost=23.410..60.120 rows=5 width=56) (actual time=0.030..0.034 rows=2 loops=239)

61.          

CTE oscar_charlie

62. 0.239 5.019 ↑ 1.0 1 239

Nested Loop (cost=1.410..7.480 rows=1 width=98) (actual time=0.020..0.021 rows=1 loops=239)

63. 0.478 2.629 ↑ 1.0 1 239

Nested Loop (cost=0.850..4.890 rows=1 width=76) (actual time=0.010..0.011 rows=1 loops=239)

64. 0.717 0.717 ↑ 1.0 1 239

Index Scan using five_mike on bravo_kilo bravo_whiskey (cost=0.440..2.460 rows=1 width=72) (actual time=0.003..0.003 rows=1 loops=239)

  • Index Cond: (india_uniform_india = $19)
65. 1.434 1.434 ↑ 1.0 1 239

Index Scan using yankee_echo on kilo_juliet echo_four (cost=0.420..2.440 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=239)

  • Index Cond: (foxtrot_romeo = five_kilo4.foxtrot_romeo)
66. 2.151 2.151 ↑ 1.0 1 239

Index Scan using mike_golf on lima_seven hotel_quebec_three (cost=0.560..2.580 rows=1 width=36) (actual time=0.008..0.009 rows=1 loops=239)

  • Index Cond: (victor_bravo = five_kilo4.victor_bravo)
  • Filter: (five_kilo4.sierra_mike = sierra_mike)
  • Rows Removed by Filter: 1
67. 0.239 6.214 ↓ 0.0 0 239

Subquery Scan on victor_victor (cost=15.940..15.980 rows=1 width=56) (actual time=0.026..0.026 rows=0 loops=239)

68. 0.000 5.975 ↓ 0.0 0 239

WindowAgg (cost=15.940..15.970 rows=1 width=88) (actual time=0.025..0.025 rows=0 loops=239)

69. 0.478 5.975 ↓ 0.0 0 239

Sort (cost=15.940..15.940 rows=1 width=53) (actual time=0.025..0.025 rows=0 loops=239)

  • Sort Key: echo_juliet.hotel_echo, (quebec_hotel(echo_juliet.oscar_seven)) DESC, echo_juliet.india_uniform_india
  • Sort Method: quicksort Memory: 25kB
70. 0.000 5.497 ↓ 0.0 0 239

Nested Loop (cost=0.990..15.930 rows=1 width=53) (actual time=0.023..0.023 rows=0 loops=239)

71. 5.497 5.497 ↓ 0.0 0 239

CTE Scan on oscar_charlie (cost=0.000..0.030 rows=1 width=100) (actual time=0.023..0.023 rows=0 loops=239)

  • Filter: ((four_seven <> 2) AND (uniform_quebec <> 0) AND (two_quebec = ''::text))
  • Rows Removed by Filter: 1
72. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.990..15.890 rows=1 width=57) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_uniform on lima_seven four_kilo (cost=0.430..5.340 rows=1 width=33) (never executed)

  • Index Cond: (romeo_three_sierra = oscar_charlie.romeo_three_sierra)
  • Filter: ((oscar_charlie.sierra_mike = sierra_mike) AND (oscar_charlie.bravo_foxtrot = bravo_foxtrot))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using victor_alpha on bravo_kilo echo_juliet (cost=0.560..10.540 rows=1 width=71) (never executed)

  • Index Cond: ((victor_bravo = four_bravo_golf1.victor_bravo) AND (foxtrot_romeo = oscar_charlie.foxtrot_romeo))
  • Filter: ((hotel_echo five_romeo NOT NULL) AND (quebec_golf five_romeo NULL) AND (two_quebec = ''::text) AND (four_bravo_golf1.sierra_mike = sierra_mike) AND ((uniform_quebec <> 6) OR ((uniform_quebec = 6) AND (NOT (delta_four 9)))))
75.          

SubPlan (for Index Scan)

76. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.990..7.940 rows=1 width=0) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_uniform on lima_seven zulu_two (cost=0.430..5.340 rows=1 width=14) (never executed)

  • Index Cond: (romeo_three_sierra = four_bravo_golf1.romeo_three_sierra)
  • Filter: ((sierra_mike = echo_juliet.sierra_mike) AND (bravo_foxtrot = four_bravo_golf1.bravo_foxtrot))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using victor_alpha on bravo_kilo foxtrot_zulu (cost=0.560..2.590 rows=1 width=14) (never executed)

  • Index Cond: ((victor_bravo = hotel_quebec_three2.victor_bravo) AND (foxtrot_romeo = echo_juliet.foxtrot_romeo))
  • Filter: ((sierra_mike = echo_juliet.sierra_mike) AND (tango_india = echo_juliet.tango_india) AND ((zulu_xray = echo_juliet.uniform_xray) OR (echo_juliet.zulu_xray = uniform_xray)))
79. 0.000 0.717 ↓ 0.0 0 239

Subquery Scan on echo_uniform (cost=28.490..28.540 rows=1 width=56) (actual time=0.003..0.003 rows=0 loops=239)

80. 0.239 0.717 ↓ 0.0 0 239

WindowAgg (cost=28.490..28.530 rows=1 width=88) (actual time=0.003..0.003 rows=0 loops=239)

81. 0.239 0.478 ↓ 0.0 0 239

Sort (cost=28.490..28.500 rows=1 width=53) (actual time=0.002..0.002 rows=0 loops=239)

  • Sort Key: juliet_six1.hotel_echo, (quebec_hotel(juliet_six1.oscar_seven)) DESC, juliet_six1.india_uniform_india
  • Sort Method: quicksort Memory: 25kB
82. 0.239 0.239 ↓ 0.0 0 239

Nested Loop (cost=27.420..28.480 rows=1 width=53) (actual time=0.001..0.001 rows=0 loops=239)

83. 0.000 0.000 ↓ 0.0 0 239

CTE Scan on oscar_charlie kilo_hotel_tango (cost=0.000..0.030 rows=1 width=76) (actual time=0.000..0.000 rows=0 loops=239)

  • Filter: ((four_seven <> 2) AND (uniform_quebec <> 0) AND (two_quebec <> ''::text))
  • Rows Removed by Filter: 1
84. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on bravo_kilo four_papa (cost=27.420..28.440 rows=1 width=45) (never executed)

  • Recheck Cond: (((tango_zulu_hotel1.two_quebec = zulu_xray) OR (india_uniform_india = tango_zulu_hotel1.india_uniform_india)) AND (foxtrot_romeo = tango_zulu_hotel1.foxtrot_romeo))
  • Filter: ((hotel_echo five_romeo NOT NULL) AND (quebec_golf five_romeo NULL) AND (tango_zulu_hotel1.sierra_mike = sierra_mike))
85. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=27.420..27.420 rows=1 width=0) (never executed)

86. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=3.260..3.260 rows=34 width=0) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on charlie_mike_zulu (cost=0.000..1.810 rows=33 width=0) (never executed)

  • Index Cond: (tango_zulu_hotel1.two_quebec = zulu_xray)
88. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on five_mike (cost=0.000..1.450 rows=1 width=0) (never executed)

  • Index Cond: (india_uniform_india = tango_zulu_hotel1.india_uniform_india)
89. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on mike_hotel (cost=0.000..23.910 rows=2,047 width=0) (never executed)

  • Index Cond: (foxtrot_romeo = tango_zulu_hotel1.foxtrot_romeo)
90. 0.239 0.239 ↑ 1.0 1 239

CTE Scan on oscar_charlie whiskey_delta (cost=0.000..0.020 rows=1 width=56) (actual time=0.001..0.001 rows=1 loops=239)

  • Filter: (four_seven = 2)
91. 0.239 0.239 ↑ 1.0 1 239

CTE Scan on oscar_charlie tango_kilo (cost=0.000..0.020 rows=1 width=56) (actual time=0.000..0.001 rows=1 loops=239)

  • Filter: (four_seven = 2)
92. 0.239 0.717 ↓ 0.0 0 239

Subquery Scan on uniform_papa (cost=7.990..8.030 rows=1 width=56) (actual time=0.003..0.003 rows=0 loops=239)

93. 0.000 0.478 ↓ 0.0 0 239

WindowAgg (cost=7.990..8.020 rows=1 width=88) (actual time=0.002..0.002 rows=0 loops=239)

94. 0.239 0.478 ↓ 0.0 0 239

Sort (cost=7.990..7.990 rows=1 width=49) (actual time=0.002..0.002 rows=0 loops=239)

  • Sort Key: juliet_six2.hotel_echo, (quebec_hotel(juliet_six2.oscar_seven)) DESC, juliet_six2.india_uniform_india
  • Sort Method: quicksort Memory: 25kB
95. 0.239 0.239 ↓ 0.0 0 239

Nested Loop (cost=0.990..7.980 rows=1 width=49) (actual time=0.001..0.001 rows=0 loops=239)

96. 0.000 0.000 ↓ 0.0 0 239

CTE Scan on oscar_charlie lima_uniform_hotel (cost=0.000..0.030 rows=1 width=100) (actual time=0.000..0.000 rows=0 loops=239)

  • Filter: ((uniform_quebec = 0) AND (two_quebec = ''::text))
  • Rows Removed by Filter: 1
97. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.990..7.940 rows=1 width=53) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_uniform on lima_seven six_kilo (cost=0.430..5.340 rows=1 width=33) (never executed)

  • Index Cond: (romeo_three_sierra = tango_zulu_hotel4.romeo_three_sierra)
  • Filter: ((tango_zulu_hotel4.sierra_mike = sierra_mike) AND (tango_zulu_hotel4.bravo_foxtrot = bravo_foxtrot))
99. 0.000 0.000 ↓ 0.0 0

Index Scan using victor_alpha on bravo_kilo hotel_india (cost=0.560..2.590 rows=1 width=40) (never executed)

  • Index Cond: ((victor_bravo = four_bravo_golf2.victor_bravo) AND (foxtrot_romeo = tango_zulu_hotel4.foxtrot_romeo))
  • Filter: ((hotel_echo five_romeo NOT NULL) AND (quebec_golf five_romeo NULL) AND (uniform_quebec <> 6) AND (two_quebec = ''::text) AND (four_bravo_golf2.sierra_mike = sierra_mike))
100. 0.717 17.925 ↑ 1.0 1 239

Hash Join (cost=0.890..1.020 rows=1 width=80) (actual time=0.075..0.075 rows=1 loops=239)

  • Hash Cond: (juliet_golf.tango_romeo = romeo_three_six2.xray_six)
101. 0.239 0.239 ↑ 2.5 2 239

CTE Scan on charlie_mike_xray juliet_golf (cost=0.000..0.100 rows=5 width=48) (actual time=0.000..0.001 rows=2 loops=239)

102. 0.239 16.969 ↑ 1.0 1 239

Hash (cost=0.880..0.880 rows=1 width=48) (actual time=0.071..0.071 rows=1 loops=239)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
103. 0.478 16.730 ↑ 1.0 1 239

Subquery Scan on foxtrot_juliet (cost=0.840..0.880 rows=1 width=48) (actual time=0.067..0.070 rows=1 loops=239)

  • Filter: ((romeo_three_six2.oscar_seven five_romeo NOT NULL) AND (romeo_three_six2.oscar_seven <> 'november_golf'::numeric) AND (romeo_three_six2.oscar_seven <> 'november_golf'::numeric))
  • Rows Removed by Filter: 3
104. 1.434 16.252 ↓ 4.0 4 239

WindowAgg (cost=0.840..0.860 rows=1 width=80) (actual time=0.064..0.068 rows=4 loops=239)

105.          

Initplan (for WindowAgg)

106. 0.478 0.478 ↑ 1.0 1 239

Aggregate (cost=0.120..0.130 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=239)

107. 0.000 0.000 ↑ 1.0 1 239

CTE Scan on charlie_mike_xray juliet_india (cost=0.000..0.110 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=239)

  • Filter: (kilo_four = 2)
  • Rows Removed by Filter: 1
108. 0.717 14.340 ↓ 4.0 4 239

Sort (cost=0.710..0.720 rows=1 width=48) (actual time=0.060..0.060 rows=4 loops=239)

  • Sort Key: romeo_three_six.lima_juliet
  • Sort Method: quicksort Memory: 25kB
109. 1.195 13.623 ↓ 4.0 4 239

Subquery Scan on romeo_three_six (cost=0.120..0.700 rows=1 width=48) (actual time=0.045..0.057 rows=4 loops=239)

  • Filter: (romeo_three_six.lima_juliet <= $51)
110. 0.000 12.428 ↑ 1.0 4 239

Append (cost=0.120..0.650 rows=4 width=48) (actual time=0.042..0.052 rows=4 loops=239)

111. 0.239 10.755 ↑ 1.0 2 239

Result (cost=0.120..0.330 rows=2 width=48) (actual time=0.041..0.045 rows=2 loops=239)

112. 0.239 10.516 ↑ 1.0 2 239

Append (cost=0.120..0.310 rows=2 width=44) (actual time=0.041..0.044 rows=2 loops=239)

113. 0.717 9.799 ↑ 1.0 1 239

WindowAgg (cost=0.120..0.150 rows=1 width=44) (actual time=0.040..0.041 rows=1 loops=239)

114. 0.478 9.082 ↑ 1.0 1 239

Sort (cost=0.120..0.130 rows=1 width=40) (actual time=0.038..0.038 rows=1 loops=239)

  • Sort Key: quebec_sierra1.tango_romeo
  • Sort Method: quicksort Memory: 25kB
115. 8.604 8.604 ↑ 1.0 1 239

CTE Scan on charlie_mike_xray bravo_mike (cost=0.000..0.110 rows=1 width=40) (actual time=0.032..0.036 rows=1 loops=239)

  • Filter: (kilo_four = 1)
  • Rows Removed by Filter: 1
116. 0.239 0.478 ↑ 1.0 1 239

Subquery Scan on juliet_hotel (cost=0.120..0.140 rows=1 width=44) (actual time=0.002..0.002 rows=1 loops=239)

117. 0.239 0.239 ↑ 1.0 1 239

Aggregate (cost=0.120..0.130 rows=1 width=40) (actual time=0.001..0.001 rows=1 loops=239)

118. 0.000 0.000 ↑ 1.0 1 239

CTE Scan on charlie_mike_xray tango_five (cost=0.000..0.110 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=239)

  • Filter: (kilo_four = 1)
  • Rows Removed by Filter: 1
119. 0.239 1.195 ↑ 1.0 1 239

Subquery Scan on bravo_seven (cost=0.120..0.160 rows=1 width=48) (actual time=0.004..0.005 rows=1 loops=239)

120. 0.478 0.956 ↑ 1.0 1 239

WindowAgg (cost=0.120..0.150 rows=1 width=44) (actual time=0.004..0.004 rows=1 loops=239)

121. 0.239 0.478 ↑ 1.0 1 239

Sort (cost=0.120..0.130 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=239)

  • Sort Key: quebec_sierra3.tango_romeo
  • Sort Method: quicksort Memory: 25kB
122. 0.239 0.239 ↑ 1.0 1 239

CTE Scan on charlie_mike_xray sierra_hotel (cost=0.000..0.110 rows=1 width=40) (actual time=0.000..0.001 rows=1 loops=239)

  • Filter: (kilo_four = 2)
  • Rows Removed by Filter: 1
123. 0.239 0.478 ↑ 1.0 1 239

Subquery Scan on four_golf (cost=0.120..0.140 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=239)

124. 0.239 0.239 ↑ 1.0 1 239

Aggregate (cost=0.120..0.130 rows=1 width=40) (actual time=0.001..0.001 rows=1 loops=239)

125. 0.000 0.000 ↑ 1.0 1 239

CTE Scan on charlie_mike_xray india_zulu (cost=0.000..0.110 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=239)

  • Filter: (kilo_four = 2)
  • Rows Removed by Filter: 1
126. 0.239 0.239 ↓ 2.0 2 239

CTE Scan on charlie_mike_xray yankee_lima (cost=0.000..0.110 rows=1 width=8) (actual time=0.000..0.001 rows=2 loops=239)

  • Filter: (india_uniform_india = romeo_echo.india_uniform_india)
127. 0.000 0.000 ↓ 0.0 0 239

Result (cost=16.070..16.140 rows=1 width=72) (actual time=0.000..0.000 rows=0 loops=239)

  • One-Time Filter: (romeo_echo.oscar_seven > 'november_golf'::numeric)
128. 0.000 0.000 ↓ 0.0 0

CTE Scan on charlie_mike_xray hotel_quebec_whiskey (cost=16.060..16.120 rows=1 width=72) (never executed)

  • Filter: ((india_uniform_india <> 0) AND (((CASE WHEN ((oscar_november = 'november_golf'::numeric) AND (victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (oscar_november / oscar_seven) END * oscar_seven) * 'echo_whiskey'::numeric) <> 'november_golf'::numeric))
129.          

CTE charlie_mike_xray

130. 0.000 0.000 ↓ 0.0 0

CTE Scan on romeo_three_four yankee_charlie (cost=15.980..16.060 rows=1 width=136) (never executed)

  • Filter: ((oscar_seven - victor_mike) >= 'november_golf'::numeric)
131.          

CTE romeo_three_four

132. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=15.890..15.980 rows=3 width=104) (never executed)

133.          

CTE five_sierra

134. 0.000 0.000 ↓ 0.0 0

Append (cost=0.440..15.890 rows=3 width=58) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Index Scan using five_mike on bravo_kilo uniform_uniform (cost=0.440..2.460 rows=1 width=72) (never executed)

  • Index Cond: (india_uniform_india = $53)
136. 0.000 0.000 ↓ 0.0 0

Subquery Scan on bravo_alpha (cost=10.920..10.930 rows=1 width=51) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Sort (cost=10.920..10.920 rows=1 width=55) (never executed)

  • Sort Key: five_kilo6.hotel_echo DESC, five_kilo6.india_uniform_india DESC
138. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.980..10.910 rows=1 width=55) (never executed)

139. 0.000 0.000 ↓ 0.0 0

Index Scan using five_mike on bravo_kilo two_november (cost=0.440..2.460 rows=1 width=23) (never executed)

  • Index Cond: (india_uniform_india = $53)
140. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.550..8.440 rows=1 width=63) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Index Scan using mike_golf on lima_seven six_uniform (cost=0.560..2.580 rows=1 width=33) (never executed)

  • Index Cond: (victor_bravo = tango_zulu_hotel5.victor_bravo)
  • Filter: (tango_zulu_hotel5.sierra_mike = sierra_mike)
142. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.990..5.860 rows=1 width=68) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_uniform on lima_seven kilo_five (cost=0.430..3.260 rows=1 width=33) (never executed)

  • Index Cond: (romeo_three_sierra = six_uniform.romeo_three_sierra)
  • Filter: ((six_uniform.sierra_mike = sierra_mike) AND (six_uniform.bravo_foxtrot = bravo_foxtrot))
144. 0.000 0.000 ↓ 0.0 0

Index Scan using victor_alpha on bravo_kilo quebec_bravo_lima (cost=0.560..2.590 rows=1 width=55) (never executed)

  • Index Cond: ((victor_bravo = four_bravo_golf3.victor_bravo) AND (foxtrot_romeo = tango_zulu_hotel5.foxtrot_romeo))
  • Filter: ((quebec_golf five_romeo NULL) AND (hotel_echo five_romeo NOT NULL) AND (oscar_seven > 'november_golf'::numeric) AND (india_uniform_india <> $53) AND (four_bravo_golf3.sierra_mike = sierra_mike))
145. 0.000 0.000 ↓ 0.0 0

Index Scan using five_mike on bravo_kilo two_four (cost=0.440..2.460 rows=1 width=51) (never executed)

  • Index Cond: (india_uniform_india = $53)
146. 0.000 0.000 ↓ 0.0 0

CTE Scan on five_sierra kilo_xray (cost=0.000..0.060 rows=3 width=72) (never executed)

147. 0.717 0.717 ↑ 1.0 1 239

Index Scan using five_mike on bravo_kilo charlie_whiskey (cost=0.440..2.460 rows=1 width=57) (actual time=0.003..0.003 rows=1 loops=239)

  • Index Cond: (india_uniform_india = juliet_golf.india_uniform_india)
148. 1.434 1.434 ↑ 1.0 1 239

Index Scan using yankee_echo on kilo_juliet echo_two (cost=0.420..1.510 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=239)

  • Index Cond: (foxtrot_romeo = five_kilo9.foxtrot_romeo)
149. 3.396 56.826 ↑ 6.7 3 574

Nested Loop Left Join (cost=9.500..5,455.030 rows=20 width=152) (actual time=0.041..0.099 rows=3 loops=574)

150. 1.014 45.920 ↑ 6.7 3 574

Nested Loop (cost=9.080..5,442.970 rows=20 width=129) (actual time=0.033..0.080 rows=3 loops=574)

151. 1.148 41.902 ↑ 6.7 3 574

Append (cost=8.640..5,393.670 rows=20 width=80) (actual time=0.030..0.073 rows=3 loops=574)

152. 1.592 40.180 ↑ 3.3 3 574

Nested Loop (cost=8.640..5,392.440 rows=10 width=80) (actual time=0.030..0.070 rows=3 loops=574)

153. 1.148 1.148 ↑ 3.3 3 574

CTE Scan on romeo_echo five_four (cost=0.000..0.910 rows=10 width=40) (actual time=0.001..0.002 rows=3 loops=574)

  • Filter: ((four_seven <> 2) AND (delta_victor <> 'november_golf'::numeric) AND (oscar_seven < 'november_golf'::numeric))
  • Rows Removed by Filter: 0
154. 2.694 37.440 ↑ 1.0 1 1,440

Nested Loop (cost=8.640..539.130 rows=1 width=40) (actual time=0.024..0.026 rows=1 loops=1,440)

155.          

CTE papa_xray

156. 1.440 11.520 ↑ 88.0 1 1,440

Nested Loop (cost=1.000..7.640 rows=88 width=28) (actual time=0.007..0.008 rows=1 loops=1,440)

157. 4.320 4.320 ↑ 1.0 1 1,440

Index Scan using five_mike on bravo_kilo kilo_yankee (cost=0.440..2.460 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=1,440)

  • Index Cond: (india_uniform_india = $65)
158. 5.760 5.760 ↑ 88.0 1 1,440

Index Scan using romeo_golf on sierra_quebec uniform_delta (cost=0.560..4.300 rows=88 width=32) (actual time=0.004..0.004 rows=1 loops=1,440)

  • Index Cond: (romeo_romeo = $65)
159. 0.758 30.240 ↑ 1.0 1 1,440

Nested Loop (cost=0.560..529.950 rows=1 width=40) (actual time=0.019..0.021 rows=1 loops=1,440)

160. 12.960 12.960 ↑ 88.0 1 1,440

CTE Scan on papa_xray (cost=0.000..1.760 rows=88 width=72) (actual time=0.008..0.009 rows=1 loops=1,440)

161. 16.522 16.522 ↑ 1.0 1 1,502

Index Scan using uniform_november on sierra_quebec india_sierra (cost=0.560..5.990 rows=1 width=32) (actual time=0.010..0.011 rows=1 loops=1,502)

  • Index Cond: (romeo_bravo = papa_xray.romeo_bravo)
  • Filter: ((romeo_romeo <> yankee_five1.india_uniform_india) AND (zulu_sierra <> papa_xray.zulu_sierra) AND (papa_xray.sierra_mike = sierra_mike) AND (quebec_juliet(papa_xray.delta_victor) = quebec_juliet(delta_victor)))
  • Rows Removed by Filter: 2
162. 4.506 4.506 ↑ 1.0 1 1,502

Index Scan using five_mike on bravo_kilo golf_seven (cost=0.440..1.540 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=1,502)

  • Index Cond: (india_uniform_india = india_sierra.romeo_romeo)
163. 0.000 0.574 ↓ 0.0 0 574

Subquery Scan on zulu_foxtrot (cost=0.000..1.030 rows=10 width=80) (actual time=0.001..0.001 rows=0 loops=574)

164. 0.574 0.574 ↓ 0.0 0 574

CTE Scan on romeo_echo four_bravo_seven (cost=0.000..0.910 rows=10 width=52) (actual time=0.001..0.001 rows=0 loops=574)

  • Filter: ((four_seven <> 2) AND (delta_victor <> 'november_golf'::numeric) AND (oscar_seven >= 'november_golf'::numeric))
  • Rows Removed by Filter: 3
165. 3.004 3.004 ↑ 1.0 1 1,502

Index Scan using five_mike on bravo_kilo five_victor (cost=0.440..2.460 rows=1 width=57) (actual time=0.002..0.002 rows=1 loops=1,502)

  • Index Cond: (india_uniform_india = india_sierra.romeo_romeo)
166. 7.510 7.510 ↑ 1.0 1 1,502

Index Scan using yankee_echo on kilo_juliet oscar_lima (cost=0.420..0.580 rows=1 width=14) (actual time=0.005..0.005 rows=1 loops=1,502)

  • Index Cond: (foxtrot_romeo = five_kilo10.foxtrot_romeo)
167. 144.074 144.074 ↑ 28.0 3 574

CTE Scan on alpha_five juliet_xray (cost=0.000..2.520 rows=84 width=248) (actual time=0.151..0.251 rows=3 loops=574)

  • Filter: ((tango_india <> $7) OR (uniform_xray <> $15) OR (zulu_xray <> $16) OR (foxtrot_romeo <> $12))
168.          

SubPlan (for HashAggregate)

169. 6.630 6.630 ↑ 1.0 1 221

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

170. 0.000 0.000 ↓ 0.0 0

Result (cost=0.000..0.040 rows=1 width=32) (never executed)

171. 161.294 161.294 ↑ 28.0 3 574

CTE Scan on alpha_five delta_five (cost=0.000..1.890 rows=84 width=248) (actual time=0.264..0.281 rows=3 loops=574)

  • Filter: (tango_india !~~ 'lima_sierra'::text)
  • Rows Removed by Filter: 0
172. 0.000 5.166 ↓ 0.0 0 574

HashAggregate (cost=24.720..24.810 rows=1 width=248) (actual time=0.009..0.009 rows=0 loops=574)

  • Group Key: india_romeo3.india_uniform_india, india_romeo3.tango_india, india_romeo3.uniform_quebec, india_romeo3.seven_five, india_romeo3.foxtrot_romeo, india_romeo3.uniform_xray, india_romeo3.zulu_xray, india_romeo3.yankee_lima, india_romeo3.hotel_echo
173.          

CTE charlie_mike_xray

174. 0.000 4.592 ↓ 0.0 0 574

Nested Loop (cost=17.550..24.670 rows=1 width=152) (actual time=0.008..0.008 rows=0 loops=574)

175. 0.564 4.592 ↓ 0.0 0 574

Nested Loop (cost=17.110..22.200 rows=1 width=80) (actual time=0.007..0.008 rows=0 loops=574)

176. 0.310 1.148 ↓ 0.0 0 574

Nested Loop (cost=0.990..6.040 rows=1 width=123) (actual time=0.002..0.002 rows=0 loops=574)

177. 0.000 0.574 ↓ 0.0 0 574

Nested Loop (cost=0.440..4.350 rows=1 width=118) (actual time=0.001..0.001 rows=0 loops=574)

178. 0.574 0.574 ↓ 0.0 0 574

CTE Scan on alpha_five quebec_oscar (cost=0.000..1.890 rows=1 width=112) (actual time=0.001..0.001 rows=0 loops=574)

  • Filter: (tango_india ~~ 'lima_sierra'::text)
  • Rows Removed by Filter: 3
179. 0.072 0.072 ↑ 1.0 1 24

Index Scan using five_mike on bravo_kilo victor_echo (cost=0.440..2.460 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=24)

  • Index Cond: (india_uniform_india = india_romeo1.india_uniform_india)
180. 0.264 0.264 ↑ 1.0 1 24

Index Scan using mike_golf on lima_seven bravo_tango (cost=0.560..1.690 rows=1 width=33) (actual time=0.011..0.011 rows=1 loops=24)

  • Index Cond: (victor_bravo = six_lima1.victor_bravo)
  • Filter: (six_lima1.sierra_mike = sierra_mike)
  • Rows Removed by Filter: 2
181. 2.880 2.880 ↑ 1.0 1 24

CTE Scan on kilo_hotel_bravo (cost=16.120..16.140 rows=1 width=40) (actual time=0.119..0.120 rows=1 loops=24)

  • Filter: (juliet_november <> 'november_golf'::numeric)
182.          

CTE kilo_hotel_bravo

183. 2.856 2.856 ↑ 1.0 1 24

CTE Scan on charlie_mike_xray hotel_victor (cost=16.090..16.120 rows=1 width=40) (actual time=0.118..0.119 rows=1 loops=24)

  • Filter: (india_uniform_india <> 0)
  • Rows Removed by Filter: 1
184.          

CTE charlie_mike_xray

185. 2.784 2.784 ↓ 2.0 2 24

CTE Scan on romeo_three_four romeo_two (cost=16.030..16.090 rows=1 width=136) (actual time=0.111..0.116 rows=2 loops=24)

  • Filter: ((oscar_seven - victor_mike) >= 'november_golf'::numeric)
  • Rows Removed by Filter: 0
186.          

CTE romeo_three_four

187. 0.144 2.664 ↑ 1.0 2 24

WindowAgg (cost=15.970..16.030 rows=2 width=104) (actual time=0.109..0.111 rows=2 loops=24)

188.          

CTE five_sierra

189. 0.000 2.472 ↑ 1.0 2 24

Append (cost=0.000..15.970 rows=2 width=48) (actual time=0.001..0.103 rows=2 loops=24)

190. 0.024 0.024 ↑ 1.0 1 24

Result (cost=0.000..0.010 rows=1 width=72) (actual time=0.001..0.001 rows=1 loops=24)

191. 0.048 2.448 ↑ 1.0 1 24

Subquery Scan on tango_delta (cost=15.920..15.930 rows=1 width=24) (actual time=0.101..0.102 rows=1 loops=24)

192. 0.072 2.400 ↑ 1.0 1 24

Sort (cost=15.920..15.920 rows=1 width=28) (actual time=0.100..0.100 rows=1 loops=24)

  • Sort Key: five_kilo12.hotel_echo DESC, five_kilo12.india_uniform_india DESC
  • Sort Method: quicksort Memory: 25kB
193. 0.122 2.328 ↑ 1.0 1 24

Nested Loop (cost=0.990..15.910 rows=1 width=28) (actual time=0.087..0.097 rows=1 loops=24)

194. 0.600 0.600 ↓ 3.0 3 24

Index Scan using alpha_uniform on lima_seven oscar_five (cost=0.430..5.360 rows=1 width=14) (actual time=0.013..0.025 rows=3 loops=24)

  • Index Cond: (romeo_three_sierra = $83)
  • Filter: ((sierra_mike = 1) AND (bravo_foxtrot ~~ (CASE WHEN ($82 ~~ 'tango_six'::text) THEN 'bravo_victor'::text ELSE $82 END || 'xray_alpha'::text)))
  • Rows Removed by Filter: 9
195. 1.023 1.606 ↓ 0.0 0 73

Index Scan using victor_alpha on bravo_kilo charlie_tango (cost=0.560..10.540 rows=1 width=42) (actual time=0.021..0.022 rows=0 loops=73)

  • Index Cond: ((victor_bravo = four_bravo_golf4.victor_bravo) AND (foxtrot_romeo = $84))
  • Filter: ((quebec_golf five_romeo NULL) AND (hotel_echo five_romeo NOT NULL) AND (hotel_echo <= 'sierra_tango'::date) AND (oscar_seven > 'november_golf'::numeric) AND (sierra_mike = 1) AND (three_xray = 1) AND ((uniform_quebec <> 6) OR ((uniform_quebec = 6) AND (NOT (three_delta: delta_four 20 or mike_mike delta_four 21)))))
  • Rows Removed by Filter: 4
196.          

SubPlan (for Index Scan)

197. 0.011 0.583 ↓ 0.0 0 11

Result (cost=0.990..7.940 rows=1 width=0) (actual time=0.053..0.053 rows=0 loops=11)

  • One-Time Filter: (five_kilo12.sierra_mike = 1)
198. 0.041 0.572 ↓ 0.0 0 11

Nested Loop (cost=0.990..7.940 rows=1 width=0) (actual time=0.052..0.052 rows=0 loops=11)

199. 0.198 0.198 ↓ 3.0 3 11

Index Scan using alpha_uniform on lima_seven sierra_seven (cost=0.430..5.340 rows=1 width=10) (actual time=0.009..0.018 rows=3 loops=11)

  • Index Cond: (romeo_three_sierra = $83)
  • Filter: (bravo_foxtrot = CASE WHEN ($82 ~~ 'tango_six'::text) THEN 'bravo_victor'::text ELSE $82 END)
  • Rows Removed by Filter: 12
200. 0.333 0.333 ↓ 0.0 0 37

Index Scan using victor_alpha on bravo_kilo charlie_quebec (cost=0.560..2.590 rows=1 width=10) (actual time=0.009..0.009 rows=0 loops=37)

  • Index Cond: ((victor_bravo = hotel_quebec_three2kilo_oscar1.victor_bravo) AND (foxtrot_romeo = $84))
  • Filter: ((tango_india = five_kilo12.tango_india) AND (zulu_xray = five_kilo12.uniform_xray))
  • Rows Removed by Filter: 4
201. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.990..7.930 rows=1 width=26) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_uniform on lima_seven four_foxtrot (cost=0.430..5.340 rows=1 width=10) (never executed)

  • Index Cond: (romeo_three_sierra = $83)
  • Filter: (bravo_foxtrot = CASE WHEN ($82 ~~ 'tango_six'::text) THEN 'bravo_victor'::text ELSE $82 END)
203. 0.000 0.000 ↓ 0.0 0

Index Scan using victor_alpha on bravo_kilo uniform_yankee (cost=0.560..2.580 rows=1 width=32) (never executed)

  • Index Cond: ((victor_bravo = hotel_quebec_three2kilo_oscar2.victor_bravo) AND (foxtrot_romeo = $84))
204. 2.520 2.520 ↑ 1.0 2 24

CTE Scan on five_sierra xray_xray (cost=0.000..0.040 rows=2 width=72) (actual time=0.002..0.105 rows=2 loops=24)

205. 0.096 0.096 ↑ 1.0 1 24

Index Scan using five_mike on bravo_kilo zulu_alpha (cost=0.440..2.460 rows=1 width=53) (actual time=0.004..0.004 rows=1 loops=24)

  • Index Cond: (india_uniform_india = kilo_hotel_bravo.india_uniform_india)
206. 5.166 5.166 ↓ 0.0 0 574

CTE Scan on charlie_mike_xray india_golf (cost=0.000..0.020 rows=1 width=248) (actual time=0.009..0.009 rows=0 loops=574)

207.          

SubPlan (for HashAggregate)

208. 0.000 0.000 ↓ 0.0 0

Result (cost=0.000..0.040 rows=1 width=32) (never executed)

209. 0.000 0.000 ↓ 0.0 0

Result (cost=0.000..0.040 rows=1 width=32) (never executed)

210.          

SubPlan (for Nested Loop)

211. 20.068 20.068 ↑ 1.0 1 692

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

212. 0.000 0.000 ↓ 0.0 0

Result (cost=0.000..0.040 rows=1 width=32) (never executed)

213. 17.664 17.664 ↑ 1.0 1 368

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

Planning time : 24.601 ms