explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PYJ4

Settings
# exclusive inclusive rows x rows loops node
1. 0.253 994.068 ↓ 3.2 1,127 1

Subquery Scan on victor_india (cost=271,963.910..272,170.230 rows=347 width=548) (actual time=985.196..994.068 rows=1,127 loops=1)

  • Output: victor_india.alpha_delta, victor_india.uniform_quebec, victor_india.tango_india, victor_india.oscar_november_oscar, victor_india.bravo_foxtrot, victor_india.mike_india, victor_india.india_alpha_three, victor_india.yankee_hotel, victor_india.foxtrot_romeo_five, victor_india.oscar_seven_tango, victor_india.xray_november, victor_india.oscar_oscar, victor_india.oscar_november_xray, victor_india.xray_foxtrot_yankee, victor_india.oscar_quebec, victor_india.papa_november, victor_india.juliet_zulu, victor_india.tango_kilo_oscar
  • Buffers: shared hit=161457
2. 8.715 993.815 ↓ 3.2 1,127 1

GroupAggregate (cost=271,963.910..272,166.760 rows=347 width=588) (actual time=985.194..993.815 rows=1,127 loops=1)

  • Output: romeo_three_six.alpha_delta, CASE WHEN (romeo_three_six.uniform_quebec = 0) THEN 'juliet_six_oscar'::text WHEN (romeo_three_six.uniform_quebec = 2) THEN 'alpha_alpha_hotel'::text WHEN (romeo_three_six.uniform_quebec = 3) THEN 'alpha_charlie'::text WHEN (romeo_three_six.uniform_quebec = 4) THEN 'victor_oscar'::text WHEN (romeo_three_six.uniform_quebec = 5) THEN 'alpha_lima'::text WHEN (romeo_three_six.uniform_quebec = 6) THEN 'echo_six'::text WHEN (romeo_three_six.uniform_quebec = 8) THEN 'three_oscar_victor'::text WHEN (romeo_three_six.uniform_quebec = 9) THEN 'sierra_sierra'::text WHEN (romeo_three_six.uniform_quebec = 10) THEN 'seven_seven'::text WHEN (romeo_three_six.uniform_quebec = 12) THEN 'kilo_uniform'::text WHEN (romeo_three_six.uniform_quebec = 13) THEN 'uniform_tango'::text WHEN (romeo_three_six.uniform_quebec = 20) THEN 'yankee_delta_golf'::text WHEN (romeo_three_six.uniform_quebec = 25) THEN 'india_five'::text ELSE NULL::text END, romeo_three_six.tango_india, CASE WHEN (romeo_three_six.uniform_quebec = 2) THEN zulu_two_november(romeo_three_six.tango_india, 1) WHEN (romeo_three_six.uniform_quebec = 3) THEN CASE WHEN (romeo_three_six.charlie_papa_tango = 0) THEN 'golf_yankee'::text WHEN (romeo_three_six.charlie_papa_tango = 1) THEN 'yankee_papa'::text ELSE ''uniform_papa_tango''::text END), romeo_three_six.yankee_hotel, romeo_three_six.foxtrot_romeo_five, five_hotel(romeo_three_six.oscar_seven_tango), five_hotel(romeo_three_six.zulu_papa), five_hotel(romeo_three_six.uniform_hotel), (five_hotel(romeo_three_six.zulu_papa) - five_hotel(romeo_three_six.uniform_hotel)), five_hotel(romeo_three_six.delta_romeo), five_hotel(romeo_three_six.foxtrot_juliet_delta), romeo_three_six.papa_november, romeo_three_six.papa_november[xray_whiskey(romeo_three_six.papa_november, 1)], five_hotel(romeo_three_six.lima_quebec), romeo_three_six.charlie_papa_tango, romeo_three_six.uniform_quebec, romeo_three_six.two_quebec
  • Group Key: romeo_three_six.papa_november, romeo_three_six.foxtrot_romeo_five, romeo_three_six.charlie_papa_tango, romeo_three_six.alpha_delta, romeo_three_six.uniform_quebec, romeo_three_six.tango_india, romeo_three_six.november_romeo_foxtrot, romeo_three_six.two_quebec, romeo_three_six.bravo_foxtrot, (CASE WHEN (romeo_three_six.foxtrot_yankee = 6) THEN romeo_three_six.zulu_xray ELSE ''::text END), romeo_three_six.yankee_hotel
  • Buffers: shared hit=161457
3. 7.937 985.100 ↑ 2.2 1,595 1

Sort (cost=271,963.910..271,972.580 rows=3,467 width=460) (actual time=984.955..985.100 rows=1,595 loops=1)

  • Output: romeo_three_six.alpha_delta, romeo_three_six.tango_india, romeo_three_six.bravo_foxtrot, romeo_three_six.november_romeo_foxtrot, (CASE WHEN (romeo_three_six.foxtrot_yankee = 6) THEN romeo_three_six.zulu_xray ELSE ''::text END), romeo_three_six.yankee_hotel, romeo_three_six.foxtrot_romeo_five, romeo_three_six.papa_november, romeo_three_six.charlie_papa_tango, romeo_three_six.uniform_quebec, romeo_three_six.two_quebec, romeo_three_six.oscar_seven_tango, romeo_three_six.zulu_papa, romeo_three_six.uniform_hotel, romeo_three_six.delta_romeo, romeo_three_six.foxtrot_juliet_delta, romeo_three_six.lima_quebec
  • Sort Key: romeo_three_six.papa_november, romeo_three_six.foxtrot_romeo_five, romeo_three_six.charlie_papa_tango, romeo_three_six.alpha_delta, romeo_three_six.uniform_quebec, romeo_three_six.tango_india, romeo_three_six.november_romeo_foxtrot, romeo_three_six.two_quebec, romeo_three_six.bravo_foxtrot, (CASE WHEN (romeo_three_six.foxtrot_yankee = 6) THEN romeo_three_six.zulu_xray ELSE ''::text END), romeo_three_six.yankee_hotel
  • Sort Method: quicksort Memory: 511kB
  • Buffers: shared hit=160573
4. 0.374 977.163 ↑ 2.2 1,595 1

Subquery Scan on romeo_three_six (cost=268,724.360..271,760.060 rows=3,467 width=460) (actual time=576.102..977.163 rows=1,595 loops=1)

  • Output: romeo_three_six.alpha_delta, romeo_three_six.tango_india, romeo_three_six.bravo_foxtrot, romeo_three_six.november_romeo_foxtrot, CASE WHEN (romeo_three_six.foxtrot_yankee = 6) THEN romeo_three_six.zulu_xray ELSE ''::text END, romeo_three_six.yankee_hotel, romeo_three_six.foxtrot_romeo_five, romeo_three_six.papa_november, romeo_three_six.charlie_papa_tango, romeo_three_six.uniform_quebec, romeo_three_six.two_quebec, romeo_three_six.oscar_seven_tango, romeo_three_six.zulu_papa, romeo_three_six.uniform_hotel, romeo_three_six.delta_romeo, romeo_three_six.foxtrot_juliet_delta, romeo_three_six.lima_quebec
  • Buffers: shared hit=160573
5. 0.197 976.789 ↑ 2.2 1,595 1

Append (cost=268,724.360..271,716.720 rows=3,467 width=496) (actual time=576.100..976.789 rows=1,595 loops=1)

  • Buffers: shared hit=160573
6.          

CTE four_bravo_tango

7. 36.613 569.430 ↑ 2.2 1,595 1

Nested Loop Left Join (cost=77,373.700..268,645.810 rows=3,467 width=535) (actual time=2.564..569.430 rows=1,595 loops=1)

  • Output: five_kilo19.two_quebec, three_hotel.quebec_charlie, three_hotel.papa_november, three_hotel.alpha_delta, three_hotel.uniform_quebec, three_hotel.tango_india, five_kilo19.zulu_xray, five_kilo19.uniform_quebec, three_hotel.uniform_xray, three_hotel.foxtrot_romeo_five, three_hotel.mike_seven, five_kilo19.tango_india, lima_sierra_five(four_bravo_golf6.bravo_foxtrot, victor_echo_juliet.bravo_foxtrot), lima_sierra_five((((juliet_six_victor3.oscar_seven_tango * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five)) * quebec_hotel_uniform(juliet_six_victor3.oscar_seven_tango)), ((six_oscar((three_hotel.tango_india)::character varying, 1) * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five))), lima_sierra_five((((juliet_six_victor3.oscar_seven_tango * three_hotel.xray_victor) * three_hotel.seven_five) * quebec_hotel_uniform(juliet_six_victor3.oscar_seven_tango)), ((six_oscar((three_hotel.tango_india)::character varying, 1) * three_hotel.xray_victor) * three_hotel.seven_five)), CASE WHEN (three_hotel.uniform_quebec = 6) THEN 'november_golf'::numeric ELSE (((kilo_sierra_mike.oscar_alpha_november * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five))) END, ((((((five_hotel(oscar_mike3.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * ('four_uniform'::numeric - three_hotel.seven_five))), ((((((five_hotel(oscar_mike4.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * ('four_uniform'::numeric - three_hotel.seven_five))), CASE WHEN (three_hotel.uniform_quebec = 6) THEN 'november_golf'::numeric ELSE (((kilo_sierra_mike.oscar_alpha_november * three_hotel.xray_victor) * three_hotel.seven_five)) END, ((((((five_hotel(oscar_mike3.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * three_hotel.seven_five)), ((((((five_hotel(oscar_mike4.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * three_hotel.seven_five)), lima_sierra_five(lima_sierra_five(((((CASE WHEN ((five_kilo19.hotel_golf = 'november_golf'::numeric) AND (five_kilo19.zulu_zulu_whiskey = 'november_golf'::numeric)) THEN five_kilo19.sierra_alpha ELSE (five_kilo19.hotel_golf + five_kilo19.zulu_zulu_whiskey) END * (juliet_six_victor3.oscar_seven_tango * three_hotel.xray_victor)) / five_kilo19.oscar_seven_tango) * quebec_hotel_uniform(juliet_six_victor3.oscar_seven_tango)) * ('four_uniform'::numeric - three_hotel.seven_five)), ((kilo_sierra_alpha(three_hotel.tango_india, 1) * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five))), ((lima_victor(three_hotel.tango_india, three_hotel.zulu_xray, three_hotel.foxtrot_romeo_five, 1) * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five))), CASE WHEN (juliet_six_victor3.uniform_quebec = 3) THEN CASE WHEN ((juliet_six_victor3.five_lima five_romeo NULL) AND (juliet_six_victor3.hotel_echo five_romeo NULL)) THEN 2 WHEN ((juliet_six_victor3.five_lima five_romeo NULL) AND (juliet_six_victor3.hotel_echo five_romeo NOT NULL)) THEN 1 ELSE 0 END ELSE 'echo_whiskey'::integer END
  • Join Filter: (three_hotel.india_uniform = 0)
  • Rows Removed by Join Filter: 239
  • Buffers: shared hit=160573
8. 3.289 425.952 ↑ 2.2 1,595 1

Nested Loop Left Join (cost=77,326.910..100,827.560 rows=3,467 width=422) (actual time=0.120..425.952 rows=1,595 loops=1)

  • Output: three_hotel.quebec_charlie, three_hotel.papa_november, three_hotel.alpha_delta, three_hotel.uniform_quebec, three_hotel.tango_india, three_hotel.uniform_xray, three_hotel.foxtrot_romeo_five, three_hotel.mike_seven, three_hotel.xray_victor, three_hotel.seven_five, three_hotel.zulu_xray, three_hotel.india_uniform, five_kilo19.two_quebec, five_kilo19.zulu_xray, five_kilo19.uniform_quebec, five_kilo19.tango_india, five_kilo19.hotel_golf, five_kilo19.zulu_zulu_whiskey, five_kilo19.sierra_alpha, five_kilo19.oscar_seven_tango, juliet_six_victor3.oscar_seven_tango, juliet_six_victor3.uniform_quebec, juliet_six_victor3.five_lima, juliet_six_victor3.hotel_echo, four_bravo_golf6.bravo_foxtrot, victor_echo_juliet.bravo_foxtrot, (((kilo_sierra_mike.oscar_alpha_november * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five))), (((kilo_sierra_mike.oscar_alpha_november * three_hotel.xray_victor) * three_hotel.seven_five))
  • Join Filter: (three_hotel.india_uniform <> 0)
  • Buffers: shared hit=132312
9. 1.365 328.558 ↓ 1.8 1,595 1

Nested Loop Left Join (cost=77,311.500..86,395.960 rows=871 width=358) (actual time=0.110..328.558 rows=1,595 loops=1)

  • Output: three_hotel.quebec_charlie, three_hotel.papa_november, three_hotel.alpha_delta, three_hotel.uniform_quebec, three_hotel.tango_india, three_hotel.uniform_xray, three_hotel.foxtrot_romeo_five, three_hotel.mike_seven, three_hotel.xray_victor, three_hotel.seven_five, three_hotel.zulu_xray, three_hotel.india_uniform, five_kilo19.two_quebec, five_kilo19.zulu_xray, five_kilo19.uniform_quebec, five_kilo19.tango_india, five_kilo19.hotel_golf, five_kilo19.zulu_zulu_whiskey, five_kilo19.sierra_alpha, five_kilo19.oscar_seven_tango, juliet_six_victor3.oscar_seven_tango, juliet_six_victor3.uniform_quebec, juliet_six_victor3.five_lima, juliet_six_victor3.hotel_echo, four_bravo_golf6.bravo_foxtrot, victor_echo_juliet.bravo_foxtrot
  • Buffers: shared hit=105779
10. 1.866 322.408 ↓ 1.8 1,595 1

Nested Loop Left Join (cost=77,311.070..84,977.790 rows=871 width=369) (actual time=0.094..322.408 rows=1,595 loops=1)

  • Output: three_hotel.quebec_charlie, three_hotel.papa_november, three_hotel.alpha_delta, three_hotel.uniform_quebec, three_hotel.tango_india, three_hotel.uniform_xray, three_hotel.foxtrot_romeo_five, three_hotel.mike_seven, three_hotel.xray_victor, three_hotel.seven_five, three_hotel.zulu_xray, three_hotel.india_uniform, five_kilo19.two_quebec, five_kilo19.zulu_xray, five_kilo19.uniform_quebec, five_kilo19.tango_india, five_kilo19.hotel_golf, five_kilo19.zulu_zulu_whiskey, five_kilo19.sierra_alpha, five_kilo19.oscar_seven_tango, juliet_six_victor3.oscar_seven_tango, juliet_six_victor3.uniform_quebec, juliet_six_victor3.five_lima, juliet_six_victor3.hotel_echo, four_bravo_golf6.bravo_foxtrot, oscar_mike1.victor_bravo, oscar_mike1.sierra_mike
  • Buffers: shared hit=103013
11. 1.920 310.972 ↓ 1.8 1,595 1

Nested Loop Left Join (cost=77,310.650..82,999.490 rows=871 width=355) (actual time=0.078..310.972 rows=1,595 loops=1)

  • Output: three_hotel.quebec_charlie, three_hotel.papa_november, three_hotel.alpha_delta, three_hotel.uniform_quebec, three_hotel.tango_india, three_hotel.uniform_xray, three_hotel.foxtrot_romeo_five, three_hotel.mike_seven, three_hotel.xray_victor, three_hotel.seven_five, three_hotel.zulu_xray, three_hotel.india_uniform, five_kilo19.two_quebec, five_kilo19.zulu_xray, five_kilo19.uniform_quebec, five_kilo19.tango_india, five_kilo19.hotel_golf, five_kilo19.zulu_zulu_whiskey, five_kilo19.sierra_alpha, five_kilo19.oscar_seven_tango, juliet_six_victor3.oscar_seven_tango, juliet_six_victor3.uniform_quebec, juliet_six_victor3.five_lima, juliet_six_victor3.hotel_echo, four_bravo_golf6.bravo_foxtrot
  • Buffers: shared hit=97767
12. 1.448 296.292 ↓ 1.8 1,595 1

Nested Loop Left Join (cost=77,310.220..81,602.080 rows=871 width=366) (actual time=0.076..296.292 rows=1,595 loops=1)

  • Output: three_hotel.quebec_charlie, three_hotel.papa_november, three_hotel.alpha_delta, three_hotel.uniform_quebec, three_hotel.tango_india, three_hotel.uniform_xray, three_hotel.foxtrot_romeo_five, three_hotel.mike_seven, three_hotel.xray_victor, three_hotel.seven_five, three_hotel.zulu_xray, three_hotel.india_uniform, five_kilo19.two_quebec, five_kilo19.zulu_xray, five_kilo19.uniform_quebec, five_kilo19.tango_india, five_kilo19.hotel_golf, five_kilo19.zulu_zulu_whiskey, five_kilo19.sierra_alpha, five_kilo19.oscar_seven_tango, juliet_six_victor3.oscar_seven_tango, juliet_six_victor3.uniform_quebec, juliet_six_victor3.five_lima, juliet_six_victor3.hotel_echo, juliet_six_victor3.victor_bravo, juliet_six_victor3.sierra_mike
  • Inner Unique: true
  • Buffers: shared hit=90517
13. 3.396 290.059 ↓ 1.8 1,595 1

Nested Loop Left Join (cost=77,309.780..79,468.780 rows=871 width=335) (actual time=0.072..290.059 rows=1,595 loops=1)

  • Output: three_hotel.quebec_charlie, three_hotel.papa_november, three_hotel.alpha_delta, three_hotel.uniform_quebec, three_hotel.tango_india, three_hotel.uniform_xray, three_hotel.foxtrot_romeo_five, three_hotel.mike_seven, three_hotel.xray_victor, three_hotel.seven_five, three_hotel.zulu_xray, three_hotel.india_uniform, five_kilo19.two_quebec, five_kilo19.zulu_xray, five_kilo19.uniform_quebec, five_kilo19.tango_india, five_kilo19.hotel_golf, five_kilo19.zulu_zulu_whiskey, five_kilo19.sierra_alpha, five_kilo19.oscar_seven_tango
  • Inner Unique: true
  • Buffers: shared hit=84359
14. 281.878 281.878 ↓ 1.8 1,595 1

CTE Scan on quebec_bravo_sierra three_hotel (cost=77,309.340..77,326.760 rows=871 width=376) (actual time=0.061..281.878 rows=1,595 loops=1)

  • Output: three_hotel.india_uniform, three_hotel.alpha_delta, NULL::numeric, NULL::numeric, three_hotel.xray_victor, three_hotel.uniform_quebec, three_hotel.tango_india, NULL::uuid, three_hotel.seven_five, three_hotel.foxtrot_romeo_five, three_hotel.zulu_xray, three_hotel.uniform_xray, three_hotel.papa_november, three_hotel.yankee_lima, three_hotel.quebec_charlie, three_hotel.mike_seven
  • Buffers: shared hit=78201
15.          

CTE quebec_bravo_sierra

16. 2.896 277.930 ↓ 1.8 1,595 1

Recursive Union (cost=44.300..77,309.340 rows=871 width=381) (actual time=0.058..277.930 rows=1,595 loops=1)

  • Buffers: shared hit=78201
17. 0.015 0.057 ↑ 21.0 1 1

HashAggregate (cost=44.300..44.560 rows=21 width=306) (actual time=0.056..0.057 rows=1 loops=1)

  • Output: 'november_golf'::bigint, five_hotel(five_kilo12.oscar_seven_tango), 'four_uniform'::numeric, 'tango_zulu_november'::text, five_kilo12.uniform_quebec, 0, 'four_uniform'::numeric, 'foxtrot_romeo_charlie'::uuid, 'november_golf'::numeric, five_kilo12.foxtrot_romeo_five, five_kilo12.zulu_xray, five_kilo12.uniform_xray, 'victor_lima'::text[], 'november_golf'::bigint, 'foxtrot_romeo_charlie'::uuid, 'oscar_lima_papa'::uuid[], 'sierra_tango'::date, false
  • Group Key: five_kilo12.foxtrot_romeo_five, five_kilo12.zulu_xray, five_kilo12.uniform_xray, five_kilo12.uniform_quebec
  • Buffers: shared hit=9
18. 0.010 0.042 ↑ 7.0 3 1

Bitmap Heap Scan on five_victor_echo charlie_tango (cost=6.110..44.030 rows=21 width=30) (actual time=0.040..0.042 rows=3 loops=1)

  • Output: five_kilo12.india_uniform, five_kilo12.oscar_seven_tango, five_kilo12.victor_bravo, five_kilo12.foxtrot_romeo_five, five_kilo12.hotel_echo, five_kilo12.tango_india, five_kilo12.zulu_xray, five_kilo12.uniform_quebec, five_kilo12.quebec_golf, five_kilo12.zulu_sierra_romeo, five_kilo12.seven_alpha_india, five_kilo12.delta_victor, five_kilo12.sierra_xray, five_kilo12.zulu_zulu_whiskey, five_kilo12.hotel_golf, five_kilo12.sierra_alpha, five_kilo12.six_bravo_golf, five_kilo12.charlie_papa_tango, five_kilo12.uniform_xray, five_kilo12.sierra_mike, five_kilo12.five_lima, five_kilo12.two_quebec, five_kilo12.three_xray, five_kilo12.charlie_papa_four
  • Recheck Cond: (((five_kilo12.tango_india = 'tango_zulu_november'::text) AND (five_kilo12.uniform_quebec = 2)) OR ((five_kilo12.zulu_xray = ''charlie_victor'lima_golf0016622'::text) AND (five_kilo12.uniform_quebec = 6)))
  • Filter: ((five_kilo12.quebec_golf five_romeo NULL) AND (five_kilo12.hotel_echo five_romeo NOT NULL) AND (five_kilo12.sierra_mike = 1) AND ((five_kilo12.uniform_quebec = 2) OR ((five_kilo12.foxtrot_romeo_five = ''zulu_zulu_uniform''::text) AND (five_kilo12.uniform_quebec = 6))))
  • Heap Blocks: exact=1
  • Buffers: shared hit=9
19. 0.001 0.032 ↓ 0.0 0 1

BitmapOr (cost=6.110..6.110 rows=37 width=0) (actual time=0.032..0.032 rows=0 loops=1)

  • Buffers: shared hit=8
20. 0.022 0.022 ↑ 12.3 3 1

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

  • Index Cond: ((five_kilo12.tango_india = 'tango_zulu_november'::text) AND (five_kilo12.uniform_quebec = 2))
  • Buffers: shared hit=4
21. 0.000 0.009 ↓ 0.0 0 1

BitmapAnd (cost=3.920..3.920 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Buffers: shared hit=4
22. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on charlie_mike_zulu (cost=0.000..1.820 rows=34 width=0) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: (five_kilo12.zulu_xray = ''::text)
  • Buffers: shared hit=4
23. 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: ((five_kilo12.tango_india = 'tango_zulu_november'::text) AND (five_kilo12.uniform_quebec = 6))
24. 20.566 274.977 ↓ 2.1 177 9

Nested Loop (cost=7,663.910..7,724.740 rows=85 width=381) (actual time=5.876..30.553 rows=177 loops=9)

  • Output: juliet_xray.india_uniform, juliet_xray.oscar_seven_tango, juliet_xray.juliet_november, juliet_xray.tango_india, juliet_xray.uniform_quebec, (six_lima2.alpha_delta + 1), ((juliet_xray.juliet_november * six_lima2.xray_victor) * CASE WHEN ((six_lima2.uniform_quebec = 2) AND (six_lima2.alpha_delta <> 0)) THEN (CASE WHEN (six_lima2.xray_victor = 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (six_lima2.oscar_seven_tango / six_lima2.juliet_november) END / lima_sierra_five((delta_four 1), (delta_four 2))) WHEN ((six_lima2.uniform_quebec = 6) AND (six_lima2.uniform_xray <> ''three_oscar_delta'0'charlie_golf'0'oscar_charlie_kilo'1'alpha_yankee'1'tango_yankee'1'yankee_uniform'1'xray_seven'1'whiskey_uniform_six''::text END) = ANY (six_lima2.papa_november))
  • Buffers: shared hit=78192
25. 1.089 1.089 ↓ 64.0 64 9

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

  • Output: six_lima2.india_uniform, six_lima2.oscar_seven_tango, six_lima2.juliet_november, six_lima2.tango_india, six_lima2.uniform_quebec, six_lima2.alpha_delta, six_lima2.xray_victor, six_lima2.three_delta_six, six_lima2.seven_five, six_lima2.foxtrot_romeo_five, six_lima2.zulu_xray, six_lima2.uniform_xray, six_lima2.papa_november, six_lima2.yankee_lima, six_lima2.quebec_charlie, six_lima2.mike_seven, six_lima2.hotel_echo, six_lima2.lima_uniform_sierra
  • Filter: ((NOT six_lima2.lima_uniform_sierra) AND (six_lima2.xray_victor > 0.0000000001) AND (six_lima2.alpha_delta < 25) AND ((six_lima2.uniform_quebec = 2) OR (six_lima2.uniform_quebec = 6)))
  • Rows Removed by Filter: 113
26. 1.722 210.658 ↑ 28.3 3 574

Append (cost=7,663.910..7,691.660 rows=85 width=247) (actual time=0.336..0.367 rows=3 loops=574)

  • Buffers: shared hit=71320
27.          

CTE alpha_five

28. 6.351 198.030 ↑ 28.0 3 574

GroupAggregate (cost=7,652.360..7,663.070 rows=84 width=170) (actual time=0.328..0.345 rows=3 loops=574)

  • Output: "whiskey_charlie".quebec_xray, five_hotel("whiskey_charlie".kilo_yankee_echo), CASE WHEN ("whiskey_charlie".uniform_quebec = 2) THEN (five_hotel("whiskey_charlie".kilo_yankee_echo) / lima_sierra_five(lima_four(lima_sierra_five((delta_four 5), (delta_four 6)), 'november_golf'::numeric), 'four_uniform'::numeric)) ELSE five_hotel("whiskey_charlie".juliet_november) END, "whiskey_charlie".tango_india, "whiskey_charlie".uniform_quebec, "whiskey_charlie".november_whiskey, "whiskey_charlie".foxtrot_romeo_five, "whiskey_charlie".uniform_xray, "whiskey_charlie".zulu_xray, "whiskey_charlie".yankee_lima, "whiskey_charlie".hotel_echo
  • Group Key: "whiskey_charlie".quebec_xray, "whiskey_charlie".tango_india, "whiskey_charlie".uniform_quebec, "whiskey_charlie".november_whiskey, "whiskey_charlie".foxtrot_romeo_five, "whiskey_charlie".uniform_xray, "whiskey_charlie".zulu_xray, "whiskey_charlie".yankee_lima, "whiskey_charlie".hotel_echo
  • Buffers: shared hit=69695
29.          

CTE romeo_echo

30. 1.148 87.248 ↑ 11.0 3 574

Append (cost=212.520..230.780 rows=33 width=87) (actual time=0.080..0.152 rows=3 loops=574)

  • Buffers: shared hit=22976
31. 38.790 66.010 ↑ 15.5 2 574

Nested Loop (cost=212.520..215.490 rows=31 width=87) (actual time=0.058..0.115 rows=2 loops=574)

  • Output: quebec_three.india_uniform, quebec_three.oscar_seven_tango, quebec_three.tango_india, quebec_three.victor_bravo, quebec_three.foxtrot_romeo_five, quebec_three.hotel_echo, CASE WHEN (quebec_three.uniform_two = 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE ('four_uniform'::numeric - (((quebec_three.juliet_bravo / (lima_sierra_five(five_hotel(november_romeo_kilo.oscar_seven_tango), 'november_golf'::numeric))) * two_lima(($7)::character varying, 1, CASE WHEN ($8 = 2) THEN 'sierra_tango'::date ELSE $9 END)) / quebec_three.uniform_two)) END, quebec_three.delta_victor, quebec_three.four_seven
  • Buffers: shared hit=15696
32. 1.148 7.462 ↓ 0.0 0 574

Aggregate (cost=26.200..26.210 rows=1 width=32) (actual time=0.013..0.013 rows=0 loops=574)

  • Output: lima_sierra_five(five_hotel(november_romeo_kilo.oscar_seven_tango), 'november_golf'::numeric)
  • Filter: (lima_sierra_five(five_hotel(november_romeo_kilo.oscar_seven_tango), 'november_golf'::numeric) <> 'november_golf'::numeric)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=2538
33. 6.314 6.314 ↑ 10.5 2 574

Index Scan using papa_mike on five_victor_echo november_romeo_kilo (cost=0.560..26.090 rows=21 width=5) (actual time=0.011..0.011 rows=2 loops=574)

  • Output: november_romeo_kilo.india_uniform, november_romeo_kilo.oscar_seven_tango, november_romeo_kilo.victor_bravo, november_romeo_kilo.foxtrot_romeo_five, november_romeo_kilo.hotel_echo, november_romeo_kilo.tango_india, november_romeo_kilo.zulu_xray, november_romeo_kilo.uniform_quebec, november_romeo_kilo.quebec_golf, november_romeo_kilo.zulu_sierra_romeo, november_romeo_kilo.seven_alpha_india, november_romeo_kilo.delta_victor, november_romeo_kilo.sierra_xray, november_romeo_kilo.zulu_zulu_whiskey, november_romeo_kilo.hotel_golf, november_romeo_kilo.sierra_alpha, november_romeo_kilo.six_bravo_golf, november_romeo_kilo.charlie_papa_tango, november_romeo_kilo.uniform_xray, november_romeo_kilo.sierra_mike, november_romeo_kilo.five_lima, november_romeo_kilo.two_quebec, november_romeo_kilo.three_xray, november_romeo_kilo.charlie_papa_four
  • Index Cond: ((november_romeo_kilo.tango_india = $7) AND (november_romeo_kilo.uniform_quebec = 2))
  • Filter: ((november_romeo_kilo.quebec_golf five_romeo NULL) AND (november_romeo_kilo.sierra_mike = 1))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2538
34. 0.444 19.758 ↑ 5.2 6 222

Subquery Scan on quebec_three (cost=186.330..187.720 rows=31 width=119) (actual time=0.076..0.089 rows=6 loops=222)

  • Output: quebec_three.india_uniform, quebec_three.oscar_seven_tango, quebec_three.tango_india, quebec_three.victor_bravo, quebec_three.foxtrot_romeo_five, quebec_three.hotel_echo, quebec_three.uniform_two, quebec_three.juliet_bravo, quebec_three.delta_victor, quebec_three.four_seven, ((five_kilo1.hotel_echo five_romeo NOT NULL))
  • Filter: (quebec_three.hotel_echo five_romeo NOT NULL)
  • Buffers: shared hit=6464
35. 2.442 19.314 ↑ 5.2 6 222

WindowAgg (cost=186.330..187.410 rows=31 width=120) (actual time=0.075..0.087 rows=6 loops=222)

  • Output: five_kilo1.india_uniform, five_kilo1.oscar_seven_tango, five_kilo1.tango_india, five_kilo1.victor_bravo, five_kilo1.foxtrot_romeo_five, five_kilo1.hotel_echo, (five_hotel(five_kilo1.oscar_seven_tango) zulu_quebec (?)), five_hotel(five_kilo1.oscar_seven_tango) zulu_quebec (?), five_kilo1.delta_victor, alpha_quebec.four_seven, ((five_kilo1.hotel_echo five_romeo NOT NULL))
  • Buffers: shared hit=6464
36. 2.664 16.872 ↑ 5.2 6 222

WindowAgg (cost=186.330..186.950 rows=31 width=88) (actual time=0.069..0.076 rows=6 loops=222)

  • Output: five_kilo1.foxtrot_romeo_five, ((five_kilo1.hotel_echo five_romeo NOT NULL)), five_kilo1.india_uniform, five_kilo1.oscar_seven_tango, five_kilo1.tango_india, five_kilo1.victor_bravo, five_kilo1.hotel_echo, five_kilo1.delta_victor, alpha_quebec.four_seven, five_hotel(five_kilo1.oscar_seven_tango) zulu_quebec (?)
  • Buffers: shared hit=6464
37. 2.442 14.208 ↑ 5.2 6 222

Sort (cost=186.330..186.410 rows=31 width=56) (actual time=0.063..0.064 rows=6 loops=222)

  • Output: five_kilo1.foxtrot_romeo_five, ((five_kilo1.hotel_echo five_romeo NOT NULL)), five_kilo1.india_uniform, five_kilo1.oscar_seven_tango, five_kilo1.tango_india, five_kilo1.victor_bravo, five_kilo1.hotel_echo, five_kilo1.delta_victor, alpha_quebec.four_seven
  • Sort Key: five_kilo1.foxtrot_romeo_five, ((five_kilo1.hotel_echo five_romeo NOT NULL))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6464
38. 0.696 11.766 ↑ 5.2 6 222

Nested Loop (cost=0.980..185.560 rows=31 width=56) (actual time=0.019..0.053 rows=6 loops=222)

  • Output: five_kilo1.foxtrot_romeo_five, (five_kilo1.hotel_echo five_romeo NOT NULL), five_kilo1.india_uniform, five_kilo1.oscar_seven_tango, five_kilo1.tango_india, five_kilo1.victor_bravo, five_kilo1.hotel_echo, five_kilo1.delta_victor, alpha_quebec.four_seven
  • Inner Unique: true
  • Buffers: shared hit=6464
39. 3.108 3.108 ↑ 5.2 6 222

Index Scan using papa_mike on five_victor_echo whiskey_romeo (cost=0.560..111.080 rows=31 width=51) (actual time=0.010..0.014 rows=6 loops=222)

  • Output: five_kilo1.india_uniform, five_kilo1.oscar_seven_tango, five_kilo1.victor_bravo, five_kilo1.foxtrot_romeo_five, five_kilo1.hotel_echo, five_kilo1.tango_india, five_kilo1.zulu_xray, five_kilo1.uniform_quebec, five_kilo1.quebec_golf, five_kilo1.zulu_sierra_romeo, five_kilo1.seven_alpha_india, five_kilo1.delta_victor, five_kilo1.sierra_xray, five_kilo1.zulu_zulu_whiskey, five_kilo1.hotel_golf, five_kilo1.sierra_alpha, five_kilo1.six_bravo_golf, five_kilo1.charlie_papa_tango, five_kilo1.uniform_xray, five_kilo1.sierra_mike, five_kilo1.five_lima, five_kilo1.two_quebec, five_kilo1.three_xray, five_kilo1.charlie_papa_four
  • Index Cond: ((five_kilo1.tango_india = $7) AND (five_kilo1.uniform_quebec = 8))
  • Filter: ((five_kilo1.quebec_golf five_romeo NULL) AND (five_kilo1.foxtrot_romeo_five <> $10) AND (five_kilo1.sierra_mike = 1) AND ((five_kilo1.hotel_echo <= CASE WHEN ($8 = 2) THEN 'sierra_tango'::date ELSE $9 END) OR (five_kilo1.hotel_echo five_romeo NULL)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1156
40. 7.962 7.962 ↑ 1.0 1 1,327

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

  • Output: alpha_quebec.foxtrot_romeo_five, alpha_quebec.oscar_seven_november, alpha_quebec.xray_lima, alpha_quebec.four_seven, alpha_quebec.seven_yankee, alpha_quebec.zulu_juliet, alpha_quebec.three_xray, alpha_quebec.seven_kilo
  • Index Cond: (alpha_quebec.foxtrot_romeo_five = five_kilo1.foxtrot_romeo_five)
  • Buffers: shared hit=5308
41. 1.906 14.924 ↑ 1.0 1 574

Nested Loop (cost=4.340..7.400 rows=1 width=87) (actual time=0.025..0.026 rows=1 loops=574)

  • Output: five_kilo2.india_uniform, five_kilo2.oscar_seven_tango, five_kilo2.tango_india, five_kilo2.victor_bravo, five_kilo2.foxtrot_romeo_five, five_kilo2.hotel_echo, 'november_golf'::numeric, five_kilo2.delta_victor, xray_juliet1.four_seven
  • Buffers: shared hit=5501
42. 1.722 10.906 ↑ 1.0 1 574

Bitmap Heap Scan on five_victor_echo seven_three (cost=3.920..4.950 rows=1 width=51) (actual time=0.018..0.019 rows=1 loops=574)

  • Output: five_kilo2.india_uniform, five_kilo2.oscar_seven_tango, five_kilo2.victor_bravo, five_kilo2.foxtrot_romeo_five, five_kilo2.hotel_echo, five_kilo2.tango_india, five_kilo2.zulu_xray, five_kilo2.uniform_quebec, five_kilo2.quebec_golf, five_kilo2.zulu_sierra_romeo, five_kilo2.seven_alpha_india, five_kilo2.delta_victor, five_kilo2.sierra_xray, five_kilo2.zulu_zulu_whiskey, five_kilo2.hotel_golf, five_kilo2.sierra_alpha, five_kilo2.six_bravo_golf, five_kilo2.charlie_papa_tango, five_kilo2.uniform_xray, five_kilo2.sierra_mike, five_kilo2.five_lima, five_kilo2.two_quebec, five_kilo2.three_xray, five_kilo2.charlie_papa_four
  • Recheck Cond: ((five_kilo2.zulu_xray = $11) AND (five_kilo2.tango_india = $7) AND (five_kilo2.uniform_quebec = 6))
  • Filter: ((five_kilo2.hotel_echo five_romeo NOT NULL) AND (five_kilo2.quebec_golf five_romeo NULL) AND (five_kilo2.oscar_seven_tango < 'november_golf'::numeric) AND (five_kilo2.foxtrot_romeo_five = $10) AND (five_kilo2.sierra_mike = 1) AND (five_kilo2.hotel_echo <= CASE WHEN ($8 = 2) THEN 'sierra_tango'::date ELSE $9 END))
  • Heap Blocks: exact=352
  • Buffers: shared hit=4093
43. 0.368 9.184 ↓ 0.0 0 574

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

  • Buffers: shared hit=3741
44. 4.592 4.592 ↑ 34.0 1 574

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

  • Index Cond: (five_kilo2.zulu_xray = $11)
  • Buffers: shared hit=2296
45. 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: ((five_kilo2.tango_india = $7) AND (five_kilo2.uniform_quebec = 6))
  • Buffers: shared hit=1445
46. 2.112 2.112 ↑ 1.0 1 352

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

  • Output: xray_juliet1.foxtrot_romeo_five, xray_juliet1.oscar_seven_november, xray_juliet1.xray_lima, xray_juliet1.four_seven, xray_juliet1.seven_yankee, xray_juliet1.zulu_juliet, xray_juliet1.three_xray, xray_juliet1.seven_kilo
  • Index Cond: (xray_juliet1.foxtrot_romeo_five = $10)
  • Buffers: shared hit=1408
47. 0.060 5.166 ↓ 0.0 0 574

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

  • Output: five_kilo3.india_uniform, five_kilo3.oscar_seven_tango, five_kilo3.tango_india, five_kilo3.victor_bravo, five_kilo3.foxtrot_romeo_five, five_kilo3.hotel_echo, 'november_golf'::numeric, five_kilo3.delta_victor, xray_juliet2.four_seven
  • One-Time Filter: ($11 = ''::text)
  • Buffers: shared hit=1779
48. 0.444 5.106 ↓ 0.0 0 222

Nested Loop (cost=4.340..7.400 rows=1 width=55) (actual time=0.023..0.023 rows=0 loops=222)

  • Output: five_kilo3.india_uniform, five_kilo3.oscar_seven_tango, five_kilo3.tango_india, five_kilo3.victor_bravo, five_kilo3.foxtrot_romeo_five, five_kilo3.hotel_echo, five_kilo3.delta_victor, xray_juliet2.four_seven
  • Inner Unique: true
  • Buffers: shared hit=1779
49. 0.000 4.662 ↓ 0.0 0 222

Bitmap Heap Scan on five_victor_echo seven_india (cost=3.920..4.950 rows=1 width=51) (actual time=0.021..0.021 rows=0 loops=222)

  • Output: five_kilo3.india_uniform, five_kilo3.oscar_seven_tango, five_kilo3.victor_bravo, five_kilo3.foxtrot_romeo_five, five_kilo3.hotel_echo, five_kilo3.tango_india, five_kilo3.zulu_xray, five_kilo3.uniform_quebec, five_kilo3.quebec_golf, five_kilo3.zulu_sierra_romeo, five_kilo3.seven_alpha_india, five_kilo3.delta_victor, five_kilo3.sierra_xray, five_kilo3.zulu_zulu_whiskey, five_kilo3.hotel_golf, five_kilo3.sierra_alpha, five_kilo3.six_bravo_golf, five_kilo3.charlie_papa_tango, five_kilo3.uniform_xray, five_kilo3.sierra_mike, five_kilo3.five_lima, five_kilo3.two_quebec, five_kilo3.three_xray, five_kilo3.charlie_papa_four
  • Recheck Cond: ((five_kilo3.zulu_xray = $12) AND (five_kilo3.tango_india = $7) AND (five_kilo3.uniform_quebec = 6))
  • Filter: ((five_kilo3.hotel_echo five_romeo NOT NULL) AND (five_kilo3.quebec_golf five_romeo NULL) AND (five_kilo3.oscar_seven_tango < 'november_golf'::numeric) AND (five_kilo3.foxtrot_romeo_five = $10) AND (five_kilo3.sierra_mike = 1) AND (five_kilo3.hotel_echo <= CASE WHEN ($8 = 2) THEN 'sierra_tango'::date ELSE $9 END))
  • Buffers: shared hit=1779
50. 0.222 4.662 ↓ 0.0 0 222

BitmapAnd (cost=3.920..3.920 rows=1 width=0) (actual time=0.021..0.021 rows=0 loops=222)

  • Buffers: shared hit=1779
51. 2.442 2.442 ↑ 8.5 4 222

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

  • Index Cond: (five_kilo3.zulu_xray = $12)
  • Buffers: shared hit=891
52. 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: ((five_kilo3.tango_india = $7) AND (five_kilo3.uniform_quebec = 6))
  • Buffers: shared hit=888
53. 0.000 0.000 ↓ 0.0 0

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

  • Output: xray_juliet2.foxtrot_romeo_five, xray_juliet2.oscar_seven_november, xray_juliet2.xray_lima, xray_juliet2.four_seven, xray_juliet2.seven_yankee, xray_juliet2.zulu_juliet, xray_juliet2.three_xray, xray_juliet2.seven_kilo
  • Index Cond: (xray_juliet2.foxtrot_romeo_five = $10)
54. 4.592 184.828 ↑ 28.0 3 574

Sort (cost=7,421.580..7,421.790 rows=84 width=170) (actual time=0.322..0.322 rows=3 loops=574)

  • Output: "whiskey_charlie".quebec_xray, "whiskey_charlie".tango_india, "whiskey_charlie".uniform_quebec, "whiskey_charlie".november_whiskey, "whiskey_charlie".foxtrot_romeo_five, "whiskey_charlie".uniform_xray, "whiskey_charlie".zulu_xray, "whiskey_charlie".yankee_lima, "whiskey_charlie".hotel_echo, "whiskey_charlie".kilo_yankee_echo, "whiskey_charlie".juliet_november
  • Sort Key: "whiskey_charlie".quebec_xray, "whiskey_charlie".tango_india, "whiskey_charlie".uniform_quebec, "whiskey_charlie".november_whiskey, "whiskey_charlie".foxtrot_romeo_five, "whiskey_charlie".uniform_xray, "whiskey_charlie".zulu_xray, "whiskey_charlie".yankee_lima, "whiskey_charlie".hotel_echo
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=68570
55. 1.148 180.236 ↑ 28.0 3 574

Result (cost=61.010..7,418.900 rows=84 width=170) (actual time=0.187..0.314 rows=3 loops=574)

  • Output: "whiskey_charlie".quebec_xray, "whiskey_charlie".tango_india, "whiskey_charlie".uniform_quebec, "whiskey_charlie".november_whiskey, "whiskey_charlie".foxtrot_romeo_five, "whiskey_charlie".uniform_xray, "whiskey_charlie".zulu_xray, "whiskey_charlie".yankee_lima, "whiskey_charlie".hotel_echo, "whiskey_charlie".kilo_yankee_echo, "whiskey_charlie".juliet_november
  • Buffers: shared hit=68570
56. 0.574 179.088 ↑ 28.0 3 574

Append (cost=61.010..7,418.060 rows=84 width=170) (actual time=0.186..0.312 rows=3 loops=574)

  • Buffers: shared hit=68570
57. 0.574 118.244 ↓ 0.0 0 574

Subquery Scan on mike_echo (cost=61.010..2,767.330 rows=64 width=175) (actual time=0.148..0.206 rows=0 loops=574)

  • Output: "whiskey_charlie".quebec_xray, "whiskey_charlie".kilo_yankee_echo, "whiskey_charlie".uniform_quebec, "whiskey_charlie".tango_india, "whiskey_charlie".juliet_november, "whiskey_charlie".november_whiskey, "whiskey_charlie".foxtrot_romeo_five, "whiskey_charlie".uniform_xray, "whiskey_charlie".zulu_xray, "whiskey_charlie".yankee_lima, "whiskey_charlie".hotel_echo
  • Buffers: shared hit=28998
58. 0.623 117.670 ↓ 0.0 0 574

Nested Loop Left Join (cost=61.010..2,766.690 rows=64 width=175) (actual time=0.148..0.205 rows=0 loops=574)

  • Output: CASE WHEN (five_kilo5.uniform_quebec = 2) THEN 'november_golf'::bigint ELSE juliet_golf.india_uniform END, romeo_three_six2.oscar_seven_tango, ((CASE WHEN (juliet_golf.oscar_seven_tango = 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (romeo_three_six2.oscar_seven_tango / juliet_golf.oscar_seven_tango) END) * CASE WHEN (xray_juliet4.four_seven <> 2) THEN ((five_kilo5.oscar_seven_tango - five_kilo5.delta_victor) / five_kilo5.oscar_seven_tango) ELSE 'four_uniform'::numeric END), five_kilo5.tango_india, five_kilo5.uniform_quebec, romeo_echo.seven_five, lima_sierra_five(five_kilo5.foxtrot_romeo_five, tango_zulu_hotel5.foxtrot_romeo_five), five_kilo5.uniform_xray, five_kilo5.zulu_xray, CASE WHEN (five_kilo5.uniform_quebec = 2) THEN 'four_uniform'::bigint ELSE romeo_echo.india_uniform END, CASE WHEN (five_kilo5.uniform_quebec = 2) THEN CASE WHEN ($8 = 2) THEN 'sierra_tango'::date ELSE $9 END ELSE five_kilo5.hotel_echo END
  • Inner Unique: true
  • Buffers: shared hit=28998
59. 0.686 115.374 ↓ 0.0 0 574

Nested Loop (cost=60.590..2,669.040 rows=64 width=170) (actual time=0.146..0.201 rows=0 loops=574)

  • Output: romeo_echo.seven_five, romeo_echo.india_uniform, juliet_golf.india_uniform, romeo_three_six2.oscar_seven_tango, (CASE WHEN (juliet_golf.oscar_seven_tango = 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (romeo_three_six2.oscar_seven_tango / juliet_golf.oscar_seven_tango) END), five_kilo5.uniform_quebec, five_kilo5.oscar_seven_tango, five_kilo5.delta_victor, five_kilo5.tango_india, five_kilo5.foxtrot_romeo_five, five_kilo5.uniform_xray, five_kilo5.zulu_xray, five_kilo5.hotel_echo, tango_zulu_hotel5.foxtrot_romeo_five
  • Join Filter: ((five_kilo5.tango_india <> $7) OR (five_kilo5.uniform_xray <> $11) OR (five_kilo5.zulu_xray <> $12) OR (lima_sierra_five(five_kilo5.foxtrot_romeo_five, tango_zulu_hotel5.foxtrot_romeo_five) <> $10))
  • Buffers: shared hit=28042
60. 0.192 91.266 ↓ 0.0 0 574

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

  • Output: romeo_echo.seven_five, romeo_echo.india_uniform, romeo_echo.oscar_seven_tango, tango_zulu_hotel5.foxtrot_romeo_five
  • Inner Unique: true
  • Buffers: shared hit=23932
61. 90.118 90.118 ↓ 0.0 0 574

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

  • Output: romeo_echo.india_uniform, romeo_echo.oscar_seven_tango, romeo_echo.tango_india, romeo_echo.victor_bravo, romeo_echo.foxtrot_romeo_five, romeo_echo.hotel_echo, romeo_echo.seven_five, romeo_echo.delta_victor, romeo_echo.four_seven
  • Filter: (((romeo_echo.oscar_seven_tango - romeo_echo.delta_victor) <> 'november_golf'::numeric) OR (romeo_echo.four_seven = 2))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=22976
62. 0.956 0.956 ↑ 1.0 1 239

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

  • Output: tango_zulu_hotel5.india_uniform, tango_zulu_hotel5.oscar_seven_tango, tango_zulu_hotel5.victor_bravo, tango_zulu_hotel5.foxtrot_romeo_five, tango_zulu_hotel5.hotel_echo, tango_zulu_hotel5.tango_india, tango_zulu_hotel5.zulu_xray, tango_zulu_hotel5.uniform_quebec, tango_zulu_hotel5.quebec_golf, tango_zulu_hotel5.zulu_sierra_romeo, tango_zulu_hotel5.seven_alpha_india, tango_zulu_hotel5.delta_victor, tango_zulu_hotel5.sierra_xray, tango_zulu_hotel5.zulu_zulu_whiskey, tango_zulu_hotel5.hotel_golf, tango_zulu_hotel5.sierra_alpha, tango_zulu_hotel5.six_bravo_golf, tango_zulu_hotel5.charlie_papa_tango, tango_zulu_hotel5.uniform_xray, tango_zulu_hotel5.sierra_mike, tango_zulu_hotel5.five_lima, tango_zulu_hotel5.two_quebec, tango_zulu_hotel5.three_xray, tango_zulu_hotel5.charlie_papa_four
  • Index Cond: (tango_zulu_hotel5.india_uniform = romeo_echo.india_uniform)
  • Buffers: shared hit=956
63. 0.478 23.422 ↑ 2.0 1 239

Nested Loop (cost=60.150..80.880 rows=2 width=121) (actual time=0.095..0.098 rows=1 loops=239)

  • Output: juliet_golf.india_uniform, romeo_three_six2.oscar_seven_tango, (CASE WHEN (juliet_golf.oscar_seven_tango = 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (romeo_three_six2.oscar_seven_tango / juliet_golf.oscar_seven_tango) END), five_kilo5.uniform_quebec, five_kilo5.oscar_seven_tango, five_kilo5.delta_victor, five_kilo5.tango_india, five_kilo5.foxtrot_romeo_five, five_kilo5.uniform_xray, five_kilo5.zulu_xray, five_kilo5.hotel_echo
  • Inner Unique: true
  • Buffers: shared hit=4110
64. 0.239 21.988 ↑ 2.0 1 239

Append (cost=59.710..75.970 rows=2 width=72) (actual time=0.090..0.092 rows=1 loops=239)

  • Buffers: shared hit=3154
65. 0.239 21.749 ↑ 1.0 1 239

Result (cost=59.710..59.980 rows=1 width=72) (actual time=0.089..0.091 rows=1 loops=239)

  • Output: juliet_golf.india_uniform, romeo_three_six2.oscar_seven_tango, (CASE WHEN (juliet_golf.oscar_seven_tango = 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (romeo_three_six2.oscar_seven_tango / juliet_golf.oscar_seven_tango) END)
  • One-Time Filter: (romeo_echo.oscar_seven_tango < 'november_golf'::numeric)
  • Buffers: shared hit=3154
66. 0.478 21.510 ↑ 1.0 1 239

Nested Loop (cost=59.710..59.970 rows=1 width=72) (actual time=0.088..0.090 rows=1 loops=239)

  • Output: juliet_golf.india_uniform, romeo_three_six2.oscar_seven_tango, CASE WHEN (juliet_golf.oscar_seven_tango = 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (romeo_three_six2.oscar_seven_tango / juliet_golf.oscar_seven_tango) END
  • Join Filter: (romeo_three_six2.uniform_four = yankee_lima.tango_romeo)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=3154
67.          

CTE charlie_mike_xray

68. 0.478 9.321 ↑ 2.5 2 239

Append (cost=23.240..58.770 rows=5 width=56) (actual time=0.034..0.039 rows=2 loops=239)

  • Buffers: shared hit=3154
69.          

CTE oscar_charlie_two

70. 0.478 5.497 ↑ 1.0 1 239

Nested Loop (cost=1.280..7.350 rows=1 width=98) (actual time=0.022..0.023 rows=1 loops=239)

  • Output: five_kilo4.india_uniform, five_kilo4.oscar_seven_tango, five_kilo4.delta_victor, five_kilo4.hotel_echo, five_kilo4.foxtrot_romeo_five, five_kilo4.tango_india, five_kilo4.sierra_mike, five_kilo4.two_quebec, five_kilo4.victor_bravo, five_kilo4.uniform_quebec, five_kilo4.uniform_xray, xray_juliet3.four_seven, five_kilo4.zulu_xray, hotel_quebec_three.romeo_three_sierra, hotel_quebec_three.bravo_foxtrot, hotel_quebec_three.sierra_echo_uniform
  • Buffers: shared hit=3154
71. 0.717 2.868 ↑ 1.0 1 239

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

  • Output: five_kilo4.india_uniform, five_kilo4.oscar_seven_tango, five_kilo4.delta_victor, five_kilo4.hotel_echo, five_kilo4.foxtrot_romeo_five, five_kilo4.tango_india, five_kilo4.sierra_mike, five_kilo4.two_quebec, five_kilo4.victor_bravo, five_kilo4.uniform_quebec, five_kilo4.uniform_xray, five_kilo4.zulu_xray, xray_juliet3.four_seven
  • Inner Unique: true
  • Buffers: shared hit=1912
72. 0.717 0.717 ↑ 1.0 1 239

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

  • Output: five_kilo4.india_uniform, five_kilo4.oscar_seven_tango, five_kilo4.victor_bravo, five_kilo4.foxtrot_romeo_five, five_kilo4.hotel_echo, five_kilo4.tango_india, five_kilo4.zulu_xray, five_kilo4.uniform_quebec, five_kilo4.quebec_golf, five_kilo4.zulu_sierra_romeo, five_kilo4.seven_alpha_india, five_kilo4.delta_victor, five_kilo4.sierra_xray, five_kilo4.zulu_zulu_whiskey, five_kilo4.hotel_golf, five_kilo4.sierra_alpha, five_kilo4.six_bravo_golf, five_kilo4.charlie_papa_tango, five_kilo4.uniform_xray, five_kilo4.sierra_mike, five_kilo4.five_lima, five_kilo4.two_quebec, five_kilo4.three_xray, five_kilo4.charlie_papa_four
  • Index Cond: (five_kilo4.india_uniform = $18)
  • Buffers: shared hit=956
73. 1.434 1.434 ↑ 1.0 1 239

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

  • Output: xray_juliet3.foxtrot_romeo_five, xray_juliet3.oscar_seven_november, xray_juliet3.xray_lima, xray_juliet3.four_seven, xray_juliet3.seven_yankee, xray_juliet3.zulu_juliet, xray_juliet3.three_xray, xray_juliet3.seven_kilo
  • Index Cond: (xray_juliet3.foxtrot_romeo_five = five_kilo4.foxtrot_romeo_five)
  • Buffers: shared hit=956
74. 2.151 2.151 ↑ 1.0 1 239

Index Scan using mike_golf on uniform_seven hotel_quebec_three (cost=0.430..2.450 rows=1 width=36) (actual time=0.008..0.009 rows=1 loops=239)

  • Output: hotel_quebec_three.sierra_mike, hotel_quebec_three.india_uniform, hotel_quebec_three.victor_bravo, hotel_quebec_three.bravo_foxtrot, hotel_quebec_three.three_xray, hotel_quebec_three.romeo_three_sierra, hotel_quebec_three.juliet_six_yankee, hotel_quebec_three.sierra_echo_uniform
  • Index Cond: (hotel_quebec_three.victor_bravo = five_kilo4.victor_bravo)
  • Filter: (five_kilo4.sierra_mike = hotel_quebec_three.sierra_mike)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1242
75. 0.000 6.692 ↓ 0.0 0 239

Subquery Scan on victor_victor (cost=15.890..15.930 rows=1 width=56) (actual time=0.028..0.028 rows=0 loops=239)

  • Output: "india_alpha_india".oscar_seven_tango, "india_alpha_india".kilo_four, "india_alpha_india".india_uniform, "india_alpha_india".hotel_echo, "india_alpha_india".tango_romeo
  • Buffers: shared hit=3154
76. 0.239 6.692 ↓ 0.0 0 239

WindowAgg (cost=15.890..15.920 rows=1 width=88) (actual time=0.028..0.028 rows=0 loops=239)

  • Output: quebec_juliet((echo_juliet.oscar_seven_tango - echo_juliet.delta_victor)), CASE WHEN (echo_juliet.oscar_seven_tango >= 'november_golf'::numeric) THEN 1 ELSE 2 END, echo_juliet.india_uniform, echo_juliet.hotel_echo, five_zulu_six() zulu_quebec (?), (quebec_hotel_uniform(echo_juliet.oscar_seven_tango))
  • Buffers: shared hit=3154
77. 0.478 6.453 ↓ 0.0 0 239

Sort (cost=15.890..15.890 rows=1 width=53) (actual time=0.027..0.027 rows=0 loops=239)

  • Output: echo_juliet.india_uniform, echo_juliet.hotel_echo, (quebec_hotel_uniform(echo_juliet.oscar_seven_tango)), echo_juliet.oscar_seven_tango, echo_juliet.delta_victor
  • Sort Key: echo_juliet.hotel_echo, (quebec_hotel_uniform(echo_juliet.oscar_seven_tango)) DESC, echo_juliet.india_uniform
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3154
78. 0.000 5.975 ↓ 0.0 0 239

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

  • Output: echo_juliet.india_uniform, echo_juliet.hotel_echo, quebec_hotel_uniform(echo_juliet.oscar_seven_tango), echo_juliet.oscar_seven_tango, echo_juliet.delta_victor
  • Buffers: shared hit=3154
79. 5.975 5.975 ↓ 0.0 0 239

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

  • Output: oscar_charlie_two.india_uniform, oscar_charlie_two.oscar_seven_tango, oscar_charlie_two.delta_victor, oscar_charlie_two.hotel_echo, oscar_charlie_two.foxtrot_romeo_five, oscar_charlie_two.tango_india, oscar_charlie_two.sierra_mike, oscar_charlie_two.two_quebec, oscar_charlie_two.victor_bravo, oscar_charlie_two.uniform_quebec, oscar_charlie_two.uniform_xray, oscar_charlie_two.four_seven, oscar_charlie_two.zulu_xray, oscar_charlie_two.romeo_three_sierra, oscar_charlie_two.bravo_foxtrot, oscar_charlie_two.sierra_echo_uniform
  • Filter: ((oscar_charlie_two.four_seven <> 2) AND (oscar_charlie_two.uniform_quebec <> 0) AND (oscar_charlie_two.two_quebec = ''::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3154
80. 0.000 0.000 ↓ 0.0 0

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

  • Output: echo_juliet.oscar_seven_tango, echo_juliet.delta_victor, echo_juliet.india_uniform, echo_juliet.hotel_echo, echo_juliet.sierra_mike, echo_juliet.foxtrot_romeo_five, four_bravo_golf1.sierra_mike, four_bravo_golf1.bravo_foxtrot, four_bravo_golf1.romeo_three_sierra
81. 0.000 0.000 ↓ 0.0 0

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

  • Output: four_bravo_golf1.sierra_mike, four_bravo_golf1.india_uniform, four_bravo_golf1.victor_bravo, four_bravo_golf1.bravo_foxtrot, four_bravo_golf1.three_xray, four_bravo_golf1.romeo_three_sierra, four_bravo_golf1.juliet_six_yankee, four_bravo_golf1.sierra_echo_uniform
  • Index Cond: (four_bravo_golf1.romeo_three_sierra = oscar_charlie_two.romeo_three_sierra)
  • Filter: ((oscar_charlie_two.sierra_mike = four_bravo_golf1.sierra_mike) AND (oscar_charlie_two.bravo_foxtrot = four_bravo_golf1.bravo_foxtrot))
82. 0.000 0.000 ↓ 0.0 0

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

  • Output: echo_juliet.india_uniform, echo_juliet.oscar_seven_tango, echo_juliet.victor_bravo, echo_juliet.foxtrot_romeo_five, echo_juliet.hotel_echo, echo_juliet.tango_india, echo_juliet.zulu_xray, echo_juliet.uniform_quebec, echo_juliet.quebec_golf, echo_juliet.zulu_sierra_romeo, echo_juliet.seven_alpha_india, echo_juliet.delta_victor, echo_juliet.sierra_xray, echo_juliet.zulu_zulu_whiskey, echo_juliet.hotel_golf, echo_juliet.sierra_alpha, echo_juliet.six_bravo_golf, echo_juliet.charlie_papa_tango, echo_juliet.uniform_xray, echo_juliet.sierra_mike, echo_juliet.five_lima, echo_juliet.two_quebec, echo_juliet.three_xray, echo_juliet.charlie_papa_four
  • Index Cond: ((echo_juliet.victor_bravo = four_bravo_golf1.victor_bravo) AND (echo_juliet.foxtrot_romeo_five = oscar_charlie_two.foxtrot_romeo_five))
  • Filter: ((echo_juliet.hotel_echo five_romeo NOT NULL) AND (echo_juliet.quebec_golf five_romeo NULL) AND (echo_juliet.two_quebec = ''::text) AND (four_bravo_golf1.sierra_mike = echo_juliet.sierra_mike) AND ((echo_juliet.uniform_quebec <> 6) OR ((echo_juliet.uniform_quebec = 6) AND (NOT (delta_four 8)))))
83.          

SubPlan (forIndex Scan)

84. 0.000 0.000 ↓ 0.0 0

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

85. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_uniform on uniform_seven zulu_two_papa (cost=0.430..5.320 rows=1 width=14) (never executed)

  • Output: hotel_quebec_three2.sierra_mike, hotel_quebec_three2.india_uniform, hotel_quebec_three2.victor_bravo, hotel_quebec_three2.bravo_foxtrot, hotel_quebec_three2.three_xray, hotel_quebec_three2.romeo_three_sierra, hotel_quebec_three2.juliet_six_yankee, hotel_quebec_three2.sierra_echo_uniform
  • Index Cond: (hotel_quebec_three2.romeo_three_sierra = four_bravo_golf1.romeo_three_sierra)
  • Filter: ((hotel_quebec_three2.sierra_mike = echo_juliet.sierra_mike) AND (hotel_quebec_three2.bravo_foxtrot = four_bravo_golf1.bravo_foxtrot))
86. 0.000 0.000 ↓ 0.0 0

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

  • Output: november_romeo_kilo2.india_uniform, november_romeo_kilo2.oscar_seven_tango, november_romeo_kilo2.victor_bravo, november_romeo_kilo2.foxtrot_romeo_five, november_romeo_kilo2.hotel_echo, november_romeo_kilo2.tango_india, november_romeo_kilo2.zulu_xray, november_romeo_kilo2.uniform_quebec, november_romeo_kilo2.quebec_golf, november_romeo_kilo2.zulu_sierra_romeo, november_romeo_kilo2.seven_alpha_india, november_romeo_kilo2.delta_victor, november_romeo_kilo2.sierra_xray, november_romeo_kilo2.zulu_zulu_whiskey, november_romeo_kilo2.hotel_golf, november_romeo_kilo2.sierra_alpha, november_romeo_kilo2.six_bravo_golf, november_romeo_kilo2.charlie_papa_tango, november_romeo_kilo2.uniform_xray, november_romeo_kilo2.sierra_mike, november_romeo_kilo2.five_lima, november_romeo_kilo2.two_quebec, november_romeo_kilo2.three_xray, november_romeo_kilo2.charlie_papa_four
  • Index Cond: ((november_romeo_kilo2.victor_bravo = hotel_quebec_three2.victor_bravo) AND (november_romeo_kilo2.foxtrot_romeo_five = echo_juliet.foxtrot_romeo_five))
  • Filter: ((november_romeo_kilo2.sierra_mike = echo_juliet.sierra_mike) AND (november_romeo_kilo2.tango_india = echo_juliet.tango_india) AND ((november_romeo_kilo2.zulu_xray = echo_juliet.uniform_xray) OR (echo_juliet.zulu_xray = november_romeo_kilo2.uniform_xray)))
87. 0.239 0.956 ↓ 0.0 0 239

Subquery Scan on echo_uniform (cost=27.340..27.390 rows=1 width=56) (actual time=0.004..0.004 rows=0 loops=239)

  • Output: "golf_hotel".oscar_seven_tango, "golf_hotel".kilo_four, "golf_hotel".india_uniform, "golf_hotel".hotel_echo, "golf_hotel".tango_romeo
88. 0.000 0.717 ↓ 0.0 0 239

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

  • Output: quebec_juliet((juliet_six_victor1.oscar_seven_tango - juliet_six_victor1.delta_victor)), CASE WHEN (juliet_six_victor1.oscar_seven_tango >= 'november_golf'::numeric) THEN 1 ELSE 2 END, juliet_six_victor1.india_uniform, juliet_six_victor1.hotel_echo, five_zulu_six() zulu_quebec (?), (quebec_hotel_uniform(juliet_six_victor1.oscar_seven_tango))
89. 0.478 0.717 ↓ 0.0 0 239

Sort (cost=27.340..27.350 rows=1 width=53) (actual time=0.003..0.003 rows=0 loops=239)

  • Output: juliet_six_victor1.india_uniform, juliet_six_victor1.hotel_echo, (quebec_hotel_uniform(juliet_six_victor1.oscar_seven_tango)), juliet_six_victor1.oscar_seven_tango, juliet_six_victor1.delta_victor
  • Sort Key: juliet_six_victor1.hotel_echo, (quebec_hotel_uniform(juliet_six_victor1.oscar_seven_tango)) DESC, juliet_six_victor1.india_uniform
  • Sort Method: quicksort Memory: 25kB
90. 0.000 0.239 ↓ 0.0 0 239

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

  • Output: juliet_six_victor1.india_uniform, juliet_six_victor1.hotel_echo, quebec_hotel_uniform(juliet_six_victor1.oscar_seven_tango), juliet_six_victor1.oscar_seven_tango, juliet_six_victor1.delta_victor
91. 0.239 0.239 ↓ 0.0 0 239

CTE Scan on oscar_charlie_two kilo_hotel (cost=0.000..0.030 rows=1 width=76) (actual time=0.001..0.001 rows=0 loops=239)

  • Output: tango_zulu_hotel1.india_uniform, tango_zulu_hotel1.oscar_seven_tango, tango_zulu_hotel1.delta_victor, tango_zulu_hotel1.hotel_echo, tango_zulu_hotel1.foxtrot_romeo_five, tango_zulu_hotel1.tango_india, tango_zulu_hotel1.sierra_mike, tango_zulu_hotel1.two_quebec, tango_zulu_hotel1.victor_bravo, tango_zulu_hotel1.uniform_quebec, tango_zulu_hotel1.uniform_xray, tango_zulu_hotel1.four_seven, tango_zulu_hotel1.zulu_xray, tango_zulu_hotel1.romeo_three_sierra, tango_zulu_hotel1.bravo_foxtrot, tango_zulu_hotel1.sierra_echo_uniform
  • Filter: ((tango_zulu_hotel1.four_seven <> 2) AND (tango_zulu_hotel1.uniform_quebec <> 0) AND (tango_zulu_hotel1.two_quebec <> ''::text))
  • Rows Removed by Filter: 1
92. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on five_victor_echo four_papa (cost=26.270..27.290 rows=1 width=45) (never executed)

  • Output: juliet_six_victor1.india_uniform, juliet_six_victor1.oscar_seven_tango, juliet_six_victor1.victor_bravo, juliet_six_victor1.foxtrot_romeo_five, juliet_six_victor1.hotel_echo, juliet_six_victor1.tango_india, juliet_six_victor1.zulu_xray, juliet_six_victor1.uniform_quebec, juliet_six_victor1.quebec_golf, juliet_six_victor1.zulu_sierra_romeo, juliet_six_victor1.seven_alpha_india, juliet_six_victor1.delta_victor, juliet_six_victor1.sierra_xray, juliet_six_victor1.zulu_zulu_whiskey, juliet_six_victor1.hotel_golf, juliet_six_victor1.sierra_alpha, juliet_six_victor1.six_bravo_golf, juliet_six_victor1.charlie_papa_tango, juliet_six_victor1.uniform_xray, juliet_six_victor1.sierra_mike, juliet_six_victor1.five_lima, juliet_six_victor1.two_quebec, juliet_six_victor1.three_xray, juliet_six_victor1.charlie_papa_four
  • Recheck Cond: (((tango_zulu_hotel1.two_quebec = juliet_six_victor1.zulu_xray) OR (juliet_six_victor1.india_uniform = tango_zulu_hotel1.india_uniform)) AND (juliet_six_victor1.foxtrot_romeo_five = tango_zulu_hotel1.foxtrot_romeo_five))
  • Filter: ((juliet_six_victor1.hotel_echo five_romeo NOT NULL) AND (juliet_six_victor1.quebec_golf five_romeo NULL) AND (tango_zulu_hotel1.sierra_mike = juliet_six_victor1.sierra_mike))
93. 0.000 0.000 ↓ 0.0 0

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

94. 0.000 0.000 ↓ 0.0 0

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

95. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (juliet_six_victor1.zulu_xray = tango_zulu_hotel1.two_quebec)
96. 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: (juliet_six_victor1.india_uniform = tango_zulu_hotel1.india_uniform)
97. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (juliet_six_victor1.foxtrot_romeo_five = tango_zulu_hotel1.foxtrot_romeo_five)
98. 0.239 0.239 ↑ 1.0 1 239

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

  • Output: quebec_juliet(tango_zulu_hotel2.oscar_seven_tango), 1, tango_zulu_hotel2.india_uniform, tango_zulu_hotel2.hotel_echo, 'four_uniform'::bigint
  • Filter: (tango_zulu_hotel2.four_seven = 2)
99. 0.239 0.239 ↑ 1.0 1 239

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

  • Output: quebec_juliet(tango_zulu_hotel3.oscar_seven_tango), 2, tango_zulu_hotel3.india_uniform, tango_zulu_hotel3.hotel_echo, 'oscar_yankee'::bigint
  • Filter: (tango_zulu_hotel3.four_seven = 2)
100. 0.000 0.717 ↓ 0.0 0 239

Subquery Scan on uniform_papa_lima (cost=7.960..8.010 rows=1 width=56) (actual time=0.003..0.003 rows=0 loops=239)

  • Output: "romeo_xray".oscar_seven_tango, "romeo_xray".kilo_four, "romeo_xray".india_uniform, "romeo_xray".hotel_echo, "romeo_xray".tango_romeo
101. 0.239 0.717 ↓ 0.0 0 239

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

  • Output: quebec_juliet(juliet_six_victor2.oscar_seven_tango), CASE WHEN (juliet_six_victor2.oscar_seven_tango >= 'november_golf'::numeric) THEN 1 ELSE 2 END, juliet_six_victor2.india_uniform, juliet_six_victor2.hotel_echo, five_zulu_six() zulu_quebec (?), (quebec_hotel_uniform(juliet_six_victor2.oscar_seven_tango))
102. 0.239 0.478 ↓ 0.0 0 239

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

  • Output: juliet_six_victor2.india_uniform, juliet_six_victor2.hotel_echo, (quebec_hotel_uniform(juliet_six_victor2.oscar_seven_tango)), juliet_six_victor2.oscar_seven_tango
  • Sort Key: juliet_six_victor2.hotel_echo, (quebec_hotel_uniform(juliet_six_victor2.oscar_seven_tango)) DESC, juliet_six_victor2.india_uniform
  • Sort Method: quicksort Memory: 25kB
103. 0.239 0.239 ↓ 0.0 0 239

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

  • Output: juliet_six_victor2.india_uniform, juliet_six_victor2.hotel_echo, quebec_hotel_uniform(juliet_six_victor2.oscar_seven_tango), juliet_six_victor2.oscar_seven_tango
104. 0.000 0.000 ↓ 0.0 0 239

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

  • Output: tango_zulu_hotel4.india_uniform, tango_zulu_hotel4.oscar_seven_tango, tango_zulu_hotel4.delta_victor, tango_zulu_hotel4.hotel_echo, tango_zulu_hotel4.foxtrot_romeo_five, tango_zulu_hotel4.tango_india, tango_zulu_hotel4.sierra_mike, tango_zulu_hotel4.two_quebec, tango_zulu_hotel4.victor_bravo, tango_zulu_hotel4.uniform_quebec, tango_zulu_hotel4.uniform_xray, tango_zulu_hotel4.four_seven, tango_zulu_hotel4.zulu_xray, tango_zulu_hotel4.romeo_three_sierra, tango_zulu_hotel4.bravo_foxtrot, tango_zulu_hotel4.sierra_echo_uniform
  • Filter: ((tango_zulu_hotel4.uniform_quebec = 0) AND (tango_zulu_hotel4.two_quebec = ''::text))
  • Rows Removed by Filter: 1
105. 0.000 0.000 ↓ 0.0 0

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

  • Output: juliet_six_victor2.oscar_seven_tango, juliet_six_victor2.india_uniform, juliet_six_victor2.hotel_echo, juliet_six_victor2.sierra_mike, juliet_six_victor2.foxtrot_romeo_five, four_bravo_golf2.sierra_mike, four_bravo_golf2.bravo_foxtrot, four_bravo_golf2.romeo_three_sierra
106. 0.000 0.000 ↓ 0.0 0

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

  • Output: four_bravo_golf2.sierra_mike, four_bravo_golf2.india_uniform, four_bravo_golf2.victor_bravo, four_bravo_golf2.bravo_foxtrot, four_bravo_golf2.three_xray, four_bravo_golf2.romeo_three_sierra, four_bravo_golf2.juliet_six_yankee, four_bravo_golf2.sierra_echo_uniform
  • Index Cond: (four_bravo_golf2.romeo_three_sierra = tango_zulu_hotel4.romeo_three_sierra)
  • Filter: ((tango_zulu_hotel4.sierra_mike = four_bravo_golf2.sierra_mike) AND (tango_zulu_hotel4.bravo_foxtrot = four_bravo_golf2.bravo_foxtrot))
107. 0.000 0.000 ↓ 0.0 0

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

  • Output: juliet_six_victor2.india_uniform, juliet_six_victor2.oscar_seven_tango, juliet_six_victor2.victor_bravo, juliet_six_victor2.foxtrot_romeo_five, juliet_six_victor2.hotel_echo, juliet_six_victor2.tango_india, juliet_six_victor2.zulu_xray, juliet_six_victor2.uniform_quebec, juliet_six_victor2.quebec_golf, juliet_six_victor2.zulu_sierra_romeo, juliet_six_victor2.seven_alpha_india, juliet_six_victor2.delta_victor, juliet_six_victor2.sierra_xray, juliet_six_victor2.zulu_zulu_whiskey, juliet_six_victor2.hotel_golf, juliet_six_victor2.sierra_alpha, juliet_six_victor2.six_bravo_golf, juliet_six_victor2.charlie_papa_tango, juliet_six_victor2.uniform_xray, juliet_six_victor2.sierra_mike, juliet_six_victor2.five_lima, juliet_six_victor2.two_quebec, juliet_six_victor2.three_xray, juliet_six_victor2.charlie_papa_four
  • Index Cond: ((juliet_six_victor2.victor_bravo = four_bravo_golf2.victor_bravo) AND (juliet_six_victor2.foxtrot_romeo_five = tango_zulu_hotel4.foxtrot_romeo_five))
  • Filter: ((juliet_six_victor2.hotel_echo five_romeo NOT NULL) AND (juliet_six_victor2.quebec_golf five_romeo NULL) AND (juliet_six_victor2.uniform_quebec <> 6) AND (juliet_six_victor2.two_quebec = ''::text) AND (four_bravo_golf2.sierra_mike = juliet_six_victor2.sierra_mike))
108. 1.195 20.793 ↑ 1.0 1 239

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

  • Output: romeo_three_six2.oscar_seven_tango, romeo_three_six2.uniform_four, juliet_golf.india_uniform, juliet_golf.oscar_seven_tango
  • Hash Cond: (juliet_golf.tango_romeo = romeo_three_six2.xray_six)
  • Buffers: shared hit=3154
109. 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.001..0.001 rows=2 loops=239)

  • Output: juliet_golf.oscar_seven_tango, juliet_golf.kilo_four, juliet_golf.india_uniform, juliet_golf.hotel_echo, juliet_golf.tango_romeo
  • Buffers: shared hit=12
110. 0.239 19.359 ↑ 1.0 1 239

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

  • Output: romeo_three_six2.oscar_seven_tango, romeo_three_six2.uniform_four, romeo_three_six2.xray_six
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3142
111. 0.478 19.120 ↑ 1.0 1 239

Subquery Scan on foxtrot_juliet_november (cost=0.840..0.880 rows=1 width=48) (actual time=0.076..0.080 rows=1 loops=239)

  • Output: romeo_three_six2.oscar_seven_tango, romeo_three_six2.uniform_four, romeo_three_six2.xray_six
  • Filter: ((romeo_three_six2.oscar_seven_tango five_romeo NOT NULL) AND (romeo_three_six2.oscar_seven_tango <> 'november_golf'::numeric) AND (romeo_three_six2.oscar_seven_tango <> 'november_golf'::numeric))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=3142
112. 1.673 18.642 ↓ 4.0 4 239

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

  • Output: alpha_four(six_lima1.xray_six) zulu_quebec (?), alpha_four(six_lima1.uniform_four) zulu_quebec (?), (romeo_sierra(six_lima1.lima_juliet_juliet) zulu_quebec (?) - six_lima1.lima_juliet_juliet), six_lima1.lima_juliet_juliet
  • Buffers: shared hit=3142
113.          

Initplan (forWindowAgg)

114. 0.239 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)

  • Output: five_hotel(juliet_india.oscar_seven_tango)
115. 0.239 0.239 ↑ 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.001 rows=1 loops=239)

  • Output: juliet_india.oscar_seven_tango, juliet_india.kilo_four, juliet_india.india_uniform, juliet_india.hotel_echo, juliet_india.tango_romeo
  • Filter: (juliet_india.kilo_four = 2)
  • Rows Removed by Filter: 1
116. 0.956 16.491 ↓ 4.0 4 239

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

  • Output: six_lima1.lima_juliet_juliet, six_lima1.xray_six, six_lima1.uniform_four
  • Sort Key: six_lima1.lima_juliet_juliet
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3142
117. 1.195 15.535 ↓ 4.0 4 239

Subquery Scan on victor_echo_golf (cost=0.120..0.700 rows=1 width=48) (actual time=0.052..0.065 rows=4 loops=239)

  • Output: six_lima1.lima_juliet_juliet, six_lima1.xray_six, six_lima1.uniform_four
  • Filter: (six_lima1.lima_juliet_juliet <= $50)
  • Buffers: shared hit=3142
118. 0.478 14.340 ↑ 1.0 4 239

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

  • Buffers: shared hit=3142
119. 0.239 12.189 ↑ 1.0 2 239

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

  • Output: quebec_sierra1.tango_romeo, (0), ((five_hotel(quebec_sierra1.oscar_seven_tango) zulu_quebec (?) - quebec_sierra1.oscar_seven_tango))
  • Buffers: shared hit=3142
120. 0.239 11.950 ↑ 1.0 2 239

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

  • Buffers: shared hit=3142
121. 0.956 10.994 ↑ 1.0 1 239

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

  • Output: quebec_sierra1.tango_romeo, 0, (five_hotel(quebec_sierra1.oscar_seven_tango) zulu_quebec (?) - quebec_sierra1.oscar_seven_tango)
  • Buffers: shared hit=3142
122. 0.239 10.038 ↑ 1.0 1 239

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

  • Output: quebec_sierra1.tango_romeo, quebec_sierra1.oscar_seven_tango
  • Sort Key: quebec_sierra1.tango_romeo
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3142
123. 9.799 9.799 ↑ 1.0 1 239

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

  • Output: quebec_sierra1.tango_romeo, quebec_sierra1.oscar_seven_tango
  • Filter: (quebec_sierra1.kilo_four = 1)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3142
124. 0.239 0.717 ↑ 1.0 1 239

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

  • Output: 0, 0, "quebec_hotel_five".five_hotel
125. 0.478 0.478 ↑ 1.0 1 239

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

  • Output: 0, 0, five_hotel(quebec_sierra2.oscar_seven_tango)
126. 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)

  • Output: quebec_sierra2.oscar_seven_tango, quebec_sierra2.kilo_four, quebec_sierra2.india_uniform, quebec_sierra2.hotel_echo, quebec_sierra2.tango_romeo
  • Filter: (quebec_sierra2.kilo_four = 1)
  • Rows Removed by Filter: 1
127. 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.005..0.005 rows=1 loops=239)

  • Output: 0, "victor_romeo".uniform_four, "victor_romeo".lima_juliet_juliet
128. 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)

  • Output: 0, quebec_sierra3.tango_romeo, (five_hotel(quebec_sierra3.oscar_seven_tango) zulu_quebec (?) - quebec_sierra3.oscar_seven_tango)
129. 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)

  • Output: quebec_sierra3.tango_romeo, quebec_sierra3.oscar_seven_tango
  • Sort Key: quebec_sierra3.tango_romeo
  • Sort Method: quicksort Memory: 25kB
130. 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.001..0.001 rows=1 loops=239)

  • Output: quebec_sierra3.tango_romeo, quebec_sierra3.oscar_seven_tango
  • Filter: (quebec_sierra3.kilo_four = 2)
  • Rows Removed by Filter: 1
131. 0.000 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)

  • Output: 0, 0, "foxtrot_november_victor".five_hotel
132. 0.478 0.478 ↑ 1.0 1 239

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

  • Output: 0, 0, five_hotel(quebec_sierra4.oscar_seven_tango)
133. 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)

  • Output: quebec_sierra4.oscar_seven_tango, quebec_sierra4.kilo_four, quebec_sierra4.india_uniform, quebec_sierra4.hotel_echo, quebec_sierra4.tango_romeo
  • Filter: (quebec_sierra4.kilo_four = 2)
  • Rows Removed by Filter: 1
134. 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)

  • Output: yankee_lima.oscar_seven_tango, yankee_lima.kilo_four, yankee_lima.india_uniform, yankee_lima.hotel_echo, yankee_lima.tango_romeo
  • Filter: (yankee_lima.india_uniform = romeo_echo.india_uniform)
135. 0.000 0.000 ↓ 0.0 0 239

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

  • Output: quebec_sierra5.india_uniform, (((CASE WHEN ((quebec_sierra5.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra5.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra5.oscar_november_xray / quebec_sierra5.oscar_seven_tango) END * quebec_sierra5.oscar_seven_tango) * 'echo_whiskey'::numeric)), ((CASE WHEN ((quebec_sierra5.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra5.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra5.oscar_november_xray / quebec_sierra5.oscar_seven_tango) END * 'echo_whiskey'::numeric))
  • One-Time Filter: (romeo_echo.oscar_seven_tango > 'november_golf'::numeric)
136. 0.000 0.000 ↓ 0.0 0

Subquery Scan on hotel_quebec_whiskey (cost=0.440..15.950 rows=1 width=72) (never executed)

  • Output: quebec_sierra5.india_uniform, ((CASE WHEN ((quebec_sierra5.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra5.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra5.oscar_november_xray / quebec_sierra5.oscar_seven_tango) END * quebec_sierra5.oscar_seven_tango) * 'echo_whiskey'::numeric), (CASE WHEN ((quebec_sierra5.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra5.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra5.oscar_november_xray / quebec_sierra5.oscar_seven_tango) END * 'echo_whiskey'::numeric)
137. 0.000 0.000 ↓ 0.0 0

Subquery Scan on yankee_charlie_november (cost=0.440..15.920 rows=1 width=136) (never executed)

  • Output: juliet_india1.india_uniform, juliet_india1.oscar_seven_tango, NULL::text, juliet_india1.victor_mike, CASE WHEN (juliet_india1.victor_mike < 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (juliet_india1.oscar_seven_tango - juliet_india1.victor_mike) END
  • Filter: ((juliet_india1.india_uniform <> 0) AND ((juliet_india1.oscar_seven_tango - juliet_india1.victor_mike) >= 'november_golf'::numeric) AND (((CASE WHEN ((CASE WHEN (juliet_india1.victor_mike < 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (juliet_india1.oscar_seven_tango - juliet_india1.victor_mike) END = 'november_golf'::numeric) AND (juliet_india1.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (CASE WHEN (juliet_india1.victor_mike < 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (juliet_india1.oscar_seven_tango - juliet_india1.victor_mike) END / juliet_india1.oscar_seven_tango) END * juliet_india1.oscar_seven_tango) * 'echo_whiskey'::numeric) <> 'november_golf'::numeric))
138. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=0.440..15.780 rows=3 width=104) (never executed)

  • Output: "india_whiskey_whiskey".india_uniform, "india_whiskey_whiskey".oscar_seven_tango, NULL::text, five_hotel("india_whiskey_whiskey".oscar_seven_tango) zulu_quebec (?)
139. 0.000 0.000 ↓ 0.0 0

Append (cost=0.440..15.750 rows=3 width=40) (never executed)

140. 0.000 0.000 ↓ 0.0 0

Subquery Scan on papa_echo (cost=0.440..2.470 rows=1 width=40) (never executed)

  • Output: "india_whiskey_whiskey".india_uniform, "india_whiskey_whiskey".oscar_seven_tango
141. 0.000 0.000 ↓ 0.0 0

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

  • Output: 'november_golf'::bigint, ((five_kilo6.oscar_seven_tango - five_kilo6.delta_victor) * 'echo_whiskey'::numeric), NULL::text
  • Index Cond: (five_kilo6.india_uniform = romeo_echo.india_uniform)
142. 0.000 0.000 ↓ 0.0 0

Subquery Scan on zulu_foxtrot (cost=10.780..10.790 rows=1 width=40) (never executed)

  • Output: "whiskey_three".india_uniform, "whiskey_three".oscar_seven_tango
143. 0.000 0.000 ↓ 0.0 0

Sort (cost=10.780..10.780 rows=1 width=76) (never executed)

  • Output: five_kilo7.india_uniform, ((five_kilo7.oscar_seven_tango - five_kilo7.delta_victor)), NULL::text, five_kilo7.hotel_echo
  • Sort Key: five_kilo7.hotel_echo DESC, five_kilo7.india_uniform DESC
144. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.860..10.770 rows=1 width=76) (never executed)

  • Output: five_kilo7.india_uniform, (five_kilo7.oscar_seven_tango - five_kilo7.delta_victor), NULL::text, five_kilo7.hotel_echo
145. 0.000 0.000 ↓ 0.0 0

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

  • Output: tango_zulu_hotel6.india_uniform, tango_zulu_hotel6.oscar_seven_tango, tango_zulu_hotel6.victor_bravo, tango_zulu_hotel6.foxtrot_romeo_five, tango_zulu_hotel6.hotel_echo, tango_zulu_hotel6.tango_india, tango_zulu_hotel6.zulu_xray, tango_zulu_hotel6.uniform_quebec, tango_zulu_hotel6.quebec_golf, tango_zulu_hotel6.zulu_sierra_romeo, tango_zulu_hotel6.seven_alpha_india, tango_zulu_hotel6.delta_victor, tango_zulu_hotel6.sierra_xray, tango_zulu_hotel6.zulu_zulu_whiskey, tango_zulu_hotel6.hotel_golf, tango_zulu_hotel6.sierra_alpha, tango_zulu_hotel6.six_bravo_golf, tango_zulu_hotel6.charlie_papa_tango, tango_zulu_hotel6.uniform_xray, tango_zulu_hotel6.sierra_mike, tango_zulu_hotel6.five_lima, tango_zulu_hotel6.two_quebec, tango_zulu_hotel6.three_xray, tango_zulu_hotel6.charlie_papa_four
  • Index Cond: (tango_zulu_hotel6.india_uniform = romeo_echo.india_uniform)
146. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.420..8.300 rows=1 width=52) (never executed)

  • Output: five_kilo7.india_uniform, five_kilo7.oscar_seven_tango, five_kilo7.delta_victor, five_kilo7.hotel_echo, five_kilo7.sierra_mike, five_kilo7.foxtrot_romeo_five, six_uniform.victor_bravo, six_uniform.sierra_mike, four_bravo_golf3.sierra_mike
147. 0.000 0.000 ↓ 0.0 0

Index Scan using mike_golf on uniform_seven six_uniform (cost=0.430..2.450 rows=1 width=33) (never executed)

  • Output: six_uniform.sierra_mike, six_uniform.india_uniform, six_uniform.victor_bravo, six_uniform.bravo_foxtrot, six_uniform.three_xray, six_uniform.romeo_three_sierra, six_uniform.juliet_six_yankee, six_uniform.sierra_echo_uniform
  • Index Cond: (six_uniform.victor_bravo = tango_zulu_hotel6.victor_bravo)
  • Filter: (tango_zulu_hotel6.sierra_mike = six_uniform.sierra_mike)
148. 0.000 0.000 ↓ 0.0 0

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

  • Output: five_kilo7.india_uniform, five_kilo7.oscar_seven_tango, five_kilo7.delta_victor, five_kilo7.hotel_echo, five_kilo7.sierra_mike, five_kilo7.foxtrot_romeo_five, four_bravo_golf3.sierra_mike, four_bravo_golf3.bravo_foxtrot, four_bravo_golf3.romeo_three_sierra
149. 0.000 0.000 ↓ 0.0 0

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

  • Output: four_bravo_golf3.sierra_mike, four_bravo_golf3.india_uniform, four_bravo_golf3.victor_bravo, four_bravo_golf3.bravo_foxtrot, four_bravo_golf3.three_xray, four_bravo_golf3.romeo_three_sierra, four_bravo_golf3.juliet_six_yankee, four_bravo_golf3.sierra_echo_uniform
  • Index Cond: (four_bravo_golf3.romeo_three_sierra = six_uniform.romeo_three_sierra)
  • Filter: ((six_uniform.sierra_mike = four_bravo_golf3.sierra_mike) AND (six_uniform.bravo_foxtrot = four_bravo_golf3.bravo_foxtrot))
150. 0.000 0.000 ↓ 0.0 0

Index Scan using victor_alpha on five_victor_echo two_four (cost=0.560..2.590 rows=1 width=44) (never executed)

  • Output: five_kilo7.india_uniform, five_kilo7.oscar_seven_tango, five_kilo7.victor_bravo, five_kilo7.foxtrot_romeo_five, five_kilo7.hotel_echo, five_kilo7.tango_india, five_kilo7.zulu_xray, five_kilo7.uniform_quebec, five_kilo7.quebec_golf, five_kilo7.zulu_sierra_romeo, five_kilo7.seven_alpha_india, five_kilo7.delta_victor, five_kilo7.sierra_xray, five_kilo7.zulu_zulu_whiskey, five_kilo7.hotel_golf, five_kilo7.sierra_alpha, five_kilo7.six_bravo_golf, five_kilo7.charlie_papa_tango, five_kilo7.uniform_xray, five_kilo7.sierra_mike, five_kilo7.five_lima, five_kilo7.two_quebec, five_kilo7.three_xray, five_kilo7.charlie_papa_four
  • Index Cond: ((five_kilo7.victor_bravo = four_bravo_golf3.victor_bravo) AND (five_kilo7.foxtrot_romeo_five = tango_zulu_hotel6.foxtrot_romeo_five))
  • Filter: ((five_kilo7.quebec_golf five_romeo NULL) AND (five_kilo7.hotel_echo five_romeo NOT NULL) AND (five_kilo7.oscar_seven_tango > 'november_golf'::numeric) AND (five_kilo7.india_uniform <> romeo_echo.india_uniform) AND (four_bravo_golf3.sierra_mike = five_kilo7.sierra_mike))
151. 0.000 0.000 ↓ 0.0 0

Subquery Scan on bravo_bravo (cost=0.440..2.470 rows=1 width=40) (never executed)

  • Output: "golf_three".india_uniform, "golf_three".oscar_seven_tango
152. 0.000 0.000 ↓ 0.0 0

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

  • Output: five_kilo8.india_uniform, (five_kilo8.oscar_seven_tango - five_kilo8.delta_victor), NULL::text
  • Index Cond: (five_kilo8.india_uniform = romeo_echo.india_uniform)
153. 0.956 0.956 ↑ 1.0 1 239

Index Scan using five_mike on five_victor_echo uniform_uniform_sierra (cost=0.440..2.460 rows=1 width=57) (actual time=0.004..0.004 rows=1 loops=239)

  • Output: five_kilo5.india_uniform, five_kilo5.oscar_seven_tango, five_kilo5.victor_bravo, five_kilo5.foxtrot_romeo_five, five_kilo5.hotel_echo, five_kilo5.tango_india, five_kilo5.zulu_xray, five_kilo5.uniform_quebec, five_kilo5.quebec_golf, five_kilo5.zulu_sierra_romeo, five_kilo5.seven_alpha_india, five_kilo5.delta_victor, five_kilo5.sierra_xray, five_kilo5.zulu_zulu_whiskey, five_kilo5.hotel_golf, five_kilo5.sierra_alpha, five_kilo5.six_bravo_golf, five_kilo5.charlie_papa_tango, five_kilo5.uniform_xray, five_kilo5.sierra_mike, five_kilo5.five_lima, five_kilo5.two_quebec, five_kilo5.three_xray, five_kilo5.charlie_papa_four
  • Index Cond: (five_kilo5.india_uniform = juliet_golf.india_uniform)
  • Buffers: shared hit=956
154. 1.673 1.673 ↑ 1.0 1 239

Index Scan using yankee_echo on yankee_zulu kilo_xray (cost=0.420..1.510 rows=1 width=14) (actual time=0.007..0.007 rows=1 loops=239)

  • Output: xray_juliet4.foxtrot_romeo_five, xray_juliet4.oscar_seven_november, xray_juliet4.xray_lima, xray_juliet4.four_seven, xray_juliet4.seven_yankee, xray_juliet4.zulu_juliet, xray_juliet4.three_xray, xray_juliet4.seven_kilo
  • Index Cond: (xray_juliet4.foxtrot_romeo_five = five_kilo5.foxtrot_romeo_five)
  • Buffers: shared hit=956
155. 0.574 60.270 ↑ 6.7 3 574

Subquery Scan on bravo_alpha (cost=2.860..4,650.300 rows=20 width=152) (actual time=0.043..0.105 rows=3 loops=574)

  • Output: "three_two_juliet".quebec_xray, "three_two_juliet"."seven_alpha_zulu", "three_two_juliet".uniform_quebec, "three_two_juliet".tango_india, "three_two_juliet".juliet_november, "three_two_juliet".november_whiskey, "three_two_juliet".foxtrot_romeo_five, "three_two_juliet".uniform_xray, "three_two_juliet".zulu_xray, "three_two_juliet".yankee_lima, "three_two_juliet".hotel_echo
  • Buffers: shared hit=39572
156. 3.042 59.696 ↑ 6.7 3 574

Nested Loop Left Join (cost=2.860..4,650.100 rows=20 width=152) (actual time=0.042..0.104 rows=3 loops=574)

  • Output: CASE WHEN (five_kilo9.uniform_quebec = 2) THEN 'november_golf'::bigint ELSE india_sierra.romeo_romeo END, (five_kilo9.delta_victor * (quebec_juliet((whiskey_uniform_charlie1.delta_victor / five_kilo10.delta_victor)))), CASE WHEN (xray_juliet5.four_seven <> 2) THEN (((quebec_juliet((whiskey_uniform_charlie1.delta_victor / five_kilo10.delta_victor))) * five_kilo9.delta_victor) / five_kilo9.oscar_seven_tango) ELSE 'four_uniform'::numeric END, five_kilo9.tango_india, five_kilo9.uniform_quebec, yankee_five1.seven_five, five_kilo9.foxtrot_romeo_five, five_kilo9.uniform_xray, five_kilo9.zulu_xray, CASE WHEN (five_kilo9.uniform_quebec = 2) THEN 'four_uniform'::bigint ELSE yankee_five1.india_uniform END, CASE WHEN (five_kilo9.uniform_quebec = 2) THEN CASE WHEN ($8 = 2) THEN 'sierra_tango'::date ELSE $9 END ELSE five_kilo9.hotel_echo END
  • Inner Unique: true
  • Buffers: shared hit=39572
157. 0.660 47.642 ↑ 6.7 3 574

Nested Loop (cost=2.440..4,638.040 rows=20 width=129) (actual time=0.034..0.083 rows=3 loops=574)

  • Output: india_sierra.romeo_romeo, (quebec_juliet((whiskey_uniform_charlie1.delta_victor / five_kilo10.delta_victor))), yankee_five1.seven_five, yankee_five1.india_uniform, five_kilo9.uniform_quebec, five_kilo9.delta_victor, five_kilo9.oscar_seven_tango, five_kilo9.tango_india, five_kilo9.foxtrot_romeo_five, five_kilo9.uniform_xray, five_kilo9.zulu_xray, five_kilo9.hotel_echo
  • Inner Unique: true
  • Buffers: shared hit=33564
158. 0.574 42.476 ↑ 6.7 3 574

Append (cost=2.000..4,588.540 rows=20 width=80) (actual time=0.030..0.074 rows=3 loops=574)

  • Buffers: shared hit=27556
159. 0.726 40.754 ↑ 3.3 3 574

Nested Loop (cost=2.000..4,587.310 rows=10 width=80) (actual time=0.029..0.071 rows=3 loops=574)

  • Output: yankee_five1.india_uniform, india_sierra.romeo_romeo, (quebec_juliet((whiskey_uniform_charlie1.delta_victor / five_kilo10.delta_victor))), yankee_five1.seven_five
  • Buffers: shared hit=27556
160. 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)

  • Output: yankee_five1.india_uniform, yankee_five1.oscar_seven_tango, yankee_five1.tango_india, yankee_five1.victor_bravo, yankee_five1.foxtrot_romeo_five, yankee_five1.hotel_echo, yankee_five1.seven_five, yankee_five1.delta_victor, yankee_five1.four_seven
  • Filter: ((yankee_five1.four_seven <> 2) AND (yankee_five1.delta_victor <> 'november_golf'::numeric) AND (yankee_five1.oscar_seven_tango < 'november_golf'::numeric))
  • Rows Removed by Filter: 0
161. 2.694 38.880 ↑ 1.0 1 1,440

Nested Loop (cost=2.000..458.620 rows=1 width=40) (actual time=0.024..0.027 rows=1 loops=1,440)

  • Output: india_sierra.romeo_romeo, quebec_juliet((whiskey_uniform_charlie1.delta_victor / five_kilo10.delta_victor))
  • Inner Unique: true
  • Buffers: shared hit=27556
162. 2.694 31.680 ↑ 1.0 1 1,440

Nested Loop (cost=1.570..456.630 rows=1 width=12) (actual time=0.019..0.022 rows=1 loops=1,440)

  • Output: whiskey_uniform_charlie1.delta_victor, india_sierra.romeo_romeo
  • Buffers: shared hit=21548
163. 2.198 24.480 ↑ 1.0 1 1,440

Nested Loop (cost=1.130..454.170 rows=1 width=20) (actual time=0.015..0.017 rows=1 loops=1,440)

  • Output: whiskey_uniform_charlie1.delta_victor, whiskey_uniform_charlie1.romeo_romeo, india_sierra.romeo_romeo
  • Buffers: shared hit=15540
164. 5.760 5.760 ↑ 79.0 1 1,440

Index Scan using romeo_golf_mike on zulu_lima six_charlie (cost=0.560..4.110 rows=79 width=32) (actual time=0.004..0.004 rows=1 loops=1,440)

  • Output: whiskey_uniform_charlie1.india_uniform, whiskey_uniform_charlie1.romeo_romeo, whiskey_uniform_charlie1.delta_victor, whiskey_uniform_charlie1.romeo_bravo, whiskey_uniform_charlie1.zulu_sierra_victor, whiskey_uniform_charlie1.quebec_five, whiskey_uniform_charlie1.sierra_mike, whiskey_uniform_charlie1.three_xray
  • Index Cond: (whiskey_uniform_charlie1.romeo_romeo = yankee_five1.india_uniform)
  • Buffers: shared hit=7200
165. 16.522 16.522 ↑ 1.0 1 1,502

Index Scan using uniform_november_bravo on zulu_lima india_sierra (cost=0.560..5.690 rows=1 width=32) (actual time=0.010..0.011 rows=1 loops=1,502)

  • Output: india_sierra.india_uniform, india_sierra.romeo_romeo, india_sierra.delta_victor, india_sierra.romeo_bravo, india_sierra.zulu_sierra_victor, india_sierra.quebec_five, india_sierra.sierra_mike, india_sierra.three_xray
  • Index Cond: (india_sierra.romeo_bravo = whiskey_uniform_charlie1.romeo_bravo)
  • Filter: ((india_sierra.romeo_romeo <> yankee_five1.india_uniform) AND (india_sierra.zulu_sierra_victor <> whiskey_uniform_charlie1.zulu_sierra_victor) AND (whiskey_uniform_charlie1.sierra_mike = india_sierra.sierra_mike) AND (quebec_juliet(whiskey_uniform_charlie1.delta_victor) = quebec_juliet(india_sierra.delta_victor)))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=8340
166. 4.506 4.506 ↑ 1.0 1 1,502

Index Only Scan using five_mike on five_victor_echo golf_seven (cost=0.440..2.460 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1,502)

  • Output: five_kilo11.india_uniform
  • Index Cond: (five_kilo11.india_uniform = yankee_five1.india_uniform)
  • Heap Fetches: 1502
  • Buffers: shared hit=6008
167. 4.506 4.506 ↑ 1.0 1 1,502

Index Scan using five_mike on five_victor_echo five_victor_hotel (cost=0.440..1.980 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=1,502)

  • Output: five_kilo10.india_uniform, five_kilo10.oscar_seven_tango, five_kilo10.victor_bravo, five_kilo10.foxtrot_romeo_five, five_kilo10.hotel_echo, five_kilo10.tango_india, five_kilo10.zulu_xray, five_kilo10.uniform_quebec, five_kilo10.quebec_golf, five_kilo10.zulu_sierra_romeo, five_kilo10.seven_alpha_india, five_kilo10.delta_victor, five_kilo10.sierra_xray, five_kilo10.zulu_zulu_whiskey, five_kilo10.hotel_golf, five_kilo10.sierra_alpha, five_kilo10.six_bravo_golf, five_kilo10.charlie_papa_tango, five_kilo10.uniform_xray, five_kilo10.sierra_mike, five_kilo10.five_lima, five_kilo10.two_quebec, five_kilo10.three_xray, five_kilo10.charlie_papa_four
  • Index Cond: (five_kilo10.india_uniform = india_sierra.romeo_romeo)
  • Buffers: shared hit=6008
168. 0.574 1.148 ↓ 0.0 0 574

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

  • Output: "two_yankee".yankee_lima, "two_yankee".india_uniform, 'echo_whiskey'::integer, "two_yankee".november_whiskey
169. 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)

  • Output: yankee_five2.india_uniform, yankee_five2.india_uniform, 'echo_whiskey'::integer, yankee_five2.seven_five
  • Filter: ((yankee_five2.four_seven <> 2) AND (yankee_five2.delta_victor <> 'november_golf'::numeric) AND (yankee_five2.oscar_seven_tango >= 'november_golf'::numeric))
  • Rows Removed by Filter: 3
170. 4.506 4.506 ↑ 1.0 1 1,502

Index Scan using five_mike on five_victor_echo charlie_whiskey (cost=0.440..2.470 rows=1 width=57) (actual time=0.003..0.003 rows=1 loops=1,502)

  • Output: five_kilo9.india_uniform, five_kilo9.oscar_seven_tango, five_kilo9.victor_bravo, five_kilo9.foxtrot_romeo_five, five_kilo9.hotel_echo, five_kilo9.tango_india, five_kilo9.zulu_xray, five_kilo9.uniform_quebec, five_kilo9.quebec_golf, five_kilo9.zulu_sierra_romeo, five_kilo9.seven_alpha_india, five_kilo9.delta_victor, five_kilo9.sierra_xray, five_kilo9.zulu_zulu_whiskey, five_kilo9.hotel_golf, five_kilo9.sierra_alpha, five_kilo9.six_bravo_golf, five_kilo9.charlie_papa_tango, five_kilo9.uniform_xray, five_kilo9.sierra_mike, five_kilo9.five_lima, five_kilo9.two_quebec, five_kilo9.three_xray, five_kilo9.charlie_papa_four
  • Index Cond: (five_kilo9.india_uniform = india_sierra.romeo_romeo)
  • Filter: ((five_kilo9.tango_india <> $7) OR (five_kilo9.uniform_xray <> $11) OR (five_kilo9.zulu_xray <> $12) OR (five_kilo9.foxtrot_romeo_five <> $10))
  • Buffers: shared hit=6008
171. 9.012 9.012 ↑ 1.0 1 1,502

Index Scan using yankee_echo on yankee_zulu echo_two (cost=0.420..0.580 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=1,502)

  • Output: xray_juliet5.foxtrot_romeo_five, xray_juliet5.oscar_seven_november, xray_juliet5.xray_lima, xray_juliet5.four_seven, xray_juliet5.seven_yankee, xray_juliet5.zulu_juliet, xray_juliet5.three_xray, xray_juliet5.seven_kilo
  • Index Cond: (xray_juliet5.foxtrot_romeo_five = five_kilo9.foxtrot_romeo_five)
  • Buffers: shared hit=6008
172.          

SubPlan (forGroupAggregate)

173. 6.851 6.851 ↑ 1.0 1 221

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

  • Output: two_lima(("whiskey_charlie".tango_india)::character varying, 1, 'sierra_tango'::date)
  • Buffers: shared hit=1125
174. 0.000 0.000 ↓ 0.0 0

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

  • Output: six_oscar(("whiskey_charlie".tango_india)::character varying, 1)
175. 200.900 200.900 ↑ 28.0 3 574

CTE Scan on alpha_five juliet_xray (cost=0.000..1.890 rows=84 width=248) (actual time=0.330..0.350 rows=3 loops=574)

  • Output: juliet_xray.india_uniform, juliet_xray.oscar_seven_tango, juliet_xray.juliet_november, juliet_xray.tango_india, juliet_xray.uniform_quebec, juliet_xray.seven_five, juliet_xray.foxtrot_romeo_five, juliet_xray.uniform_xray, juliet_xray.zulu_xray, juliet_xray.yankee_lima, juliet_xray.hotel_echo
  • Filter: (juliet_xray.tango_india !~~ 'lima_sierra_zulu'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=69695
176. 0.574 8.036 ↓ 0.0 0 574

GroupAggregate (cost=24.450..24.590 rows=1 width=152) (actual time=0.014..0.014 rows=0 loops=574)

  • Output: (CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'november_golf'::bigint ELSE five_kilo13.india_uniform END), five_hotel((five_kilo13.oscar_seven_tango * (CASE WHEN ((quebec_sierra6.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra6.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra6.oscar_november_xray / quebec_sierra6.oscar_seven_tango) END))), CASE WHEN (five_kilo13.uniform_quebec = 2) THEN (five_hotel((five_kilo13.oscar_seven_tango * (CASE WHEN ((quebec_sierra6.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra6.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra6.oscar_november_xray / quebec_sierra6.oscar_seven_tango) END))) / lima_sierra_five(lima_four(lima_sierra_five((delta_four 12), (delta_four 13)), 'november_golf'::numeric), 'four_uniform'::numeric)) ELSE five_hotel((CASE WHEN ((quebec_sierra6.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra6.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra6.oscar_november_xray / quebec_sierra6.oscar_seven_tango) END)) END, five_kilo13.tango_india, five_kilo13.uniform_quebec, india_romeo1.seven_five, five_kilo13.foxtrot_romeo_five, five_kilo13.uniform_xray, five_kilo13.zulu_xray, india_romeo1.yankee_lima, (CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'sierra_tango'::date ELSE five_kilo13.hotel_echo END)
  • Group Key: (CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'november_golf'::bigint ELSE five_kilo13.india_uniform END), five_kilo13.tango_india, five_kilo13.uniform_quebec, india_romeo1.seven_five, five_kilo13.foxtrot_romeo_five, five_kilo13.uniform_xray, five_kilo13.zulu_xray, india_romeo1.yankee_lima, (CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'sierra_tango'::date ELSE five_kilo13.hotel_echo END)
  • Buffers: shared hit=1625
177. 2.870 7.462 ↓ 0.0 0 574

Sort (cost=24.450..24.450 rows=1 width=125) (actual time=0.013..0.013 rows=0 loops=574)

  • Output: (CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'november_golf'::bigint ELSE five_kilo13.india_uniform END), five_kilo13.tango_india, five_kilo13.uniform_quebec, india_romeo1.seven_five, five_kilo13.foxtrot_romeo_five, five_kilo13.uniform_xray, five_kilo13.zulu_xray, india_romeo1.yankee_lima, (CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'sierra_tango'::date ELSE five_kilo13.hotel_echo END), five_kilo13.oscar_seven_tango, (CASE WHEN ((quebec_sierra6.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra6.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra6.oscar_november_xray / quebec_sierra6.oscar_seven_tango) END)
  • Sort Key: (CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'november_golf'::bigint ELSE five_kilo13.india_uniform END), five_kilo13.tango_india, five_kilo13.uniform_quebec, india_romeo1.seven_five, five_kilo13.foxtrot_romeo_five, five_kilo13.uniform_xray, five_kilo13.zulu_xray, india_romeo1.yankee_lima, (CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'sierra_tango'::date ELSE five_kilo13.hotel_echo END)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1625
178. 0.478 4.592 ↓ 0.0 0 574

Nested Loop (cost=1.300..24.440 rows=1 width=125) (actual time=0.008..0.008 rows=0 loops=574)

  • Output: CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'november_golf'::bigint ELSE five_kilo13.india_uniform END, five_kilo13.tango_india, five_kilo13.uniform_quebec, india_romeo1.seven_five, five_kilo13.foxtrot_romeo_five, five_kilo13.uniform_xray, five_kilo13.zulu_xray, india_romeo1.yankee_lima, CASE WHEN (five_kilo13.uniform_quebec = 2) THEN 'sierra_tango'::date ELSE five_kilo13.hotel_echo END, five_kilo13.oscar_seven_tango, (CASE WHEN ((quebec_sierra6.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra6.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra6.oscar_november_xray / quebec_sierra6.oscar_seven_tango) END)
  • Inner Unique: true
  • Buffers: shared hit=1625
179. 0.254 4.018 ↓ 0.0 0 574

Nested Loop (cost=0.870..21.980 rows=1 width=80) (actual time=0.007..0.007 rows=0 loops=574)

  • Output: india_romeo1.seven_five, india_romeo1.yankee_lima, (CASE WHEN ((quebec_sierra6.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra6.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra6.oscar_november_xray / quebec_sierra6.oscar_seven_tango) END), quebec_sierra6.india_uniform
  • Buffers: shared hit=1529
180. 0.000 1.148 ↓ 0.0 0 574

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

  • Output: india_romeo1.seven_five, india_romeo1.yankee_lima, india_romeo1.oscar_seven_tango, india_romeo1.foxtrot_romeo_five, four_bravo_golf4.bravo_foxtrot, four_bravo_golf4.romeo_three_sierra
  • Buffers: shared hit=238
181. 0.502 1.148 ↓ 0.0 0 574

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

  • Output: india_romeo1.seven_five, india_romeo1.yankee_lima, india_romeo1.oscar_seven_tango, india_romeo1.foxtrot_romeo_five, six_lima3.victor_bravo, six_lima3.sierra_mike
  • Inner Unique: true
  • Buffers: shared hit=96
182. 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)

  • Output: india_romeo1.india_uniform, india_romeo1.oscar_seven_tango, india_romeo1.juliet_november, india_romeo1.tango_india, india_romeo1.uniform_quebec, india_romeo1.seven_five, india_romeo1.foxtrot_romeo_five, india_romeo1.uniform_xray, india_romeo1.zulu_xray, india_romeo1.yankee_lima, india_romeo1.hotel_echo
  • Filter: (india_romeo1.tango_india ~~ 'lima_sierra_zulu'::text)
  • Rows Removed by Filter: 3
183. 0.072 0.072 ↑ 1.0 1 24

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

  • Output: six_lima3.india_uniform, six_lima3.oscar_seven_tango, six_lima3.victor_bravo, six_lima3.foxtrot_romeo_five, six_lima3.hotel_echo, six_lima3.tango_india, six_lima3.zulu_xray, six_lima3.uniform_quebec, six_lima3.quebec_golf, six_lima3.zulu_sierra_romeo, six_lima3.seven_alpha_india, six_lima3.delta_victor, six_lima3.sierra_xray, six_lima3.zulu_zulu_whiskey, six_lima3.hotel_golf, six_lima3.sierra_alpha, six_lima3.six_bravo_golf, six_lima3.charlie_papa_tango, six_lima3.uniform_xray, six_lima3.sierra_mike, six_lima3.five_lima, six_lima3.two_quebec, six_lima3.three_xray, six_lima3.charlie_papa_four
  • Index Cond: (six_lima3.india_uniform = india_romeo1.india_uniform)
  • Buffers: shared hit=96
184. 0.240 0.240 ↑ 1.0 1 24

Index Scan using mike_golf on uniform_seven oscar_five (cost=0.430..1.560 rows=1 width=33) (actual time=0.009..0.010 rows=1 loops=24)

  • Output: four_bravo_golf4.sierra_mike, four_bravo_golf4.india_uniform, four_bravo_golf4.victor_bravo, four_bravo_golf4.bravo_foxtrot, four_bravo_golf4.three_xray, four_bravo_golf4.romeo_three_sierra, four_bravo_golf4.juliet_six_yankee, four_bravo_golf4.sierra_echo_uniform
  • Index Cond: (four_bravo_golf4.victor_bravo = six_lima3.victor_bravo)
  • Filter: (six_lima3.sierra_mike = four_bravo_golf4.sierra_mike)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=142
185. 0.024 2.616 ↑ 1.0 1 24

Subquery Scan on hotel_victor (cost=0.000..16.030 rows=1 width=40) (actual time=0.108..0.109 rows=1 loops=24)

  • Output: quebec_sierra6.india_uniform, CASE WHEN ((quebec_sierra6.oscar_november_xray = 'november_golf'::numeric) AND (quebec_sierra6.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (quebec_sierra6.oscar_november_xray / quebec_sierra6.oscar_seven_tango) END
  • Buffers: shared hit=1291
186. 0.096 2.592 ↑ 1.0 1 24

Subquery Scan on romeo_two (cost=0.000..16.010 rows=1 width=122) (actual time=0.107..0.108 rows=1 loops=24)

  • Output: juliet_india1kilo_oscar1.india_uniform, juliet_india1kilo_oscar1.oscar_seven_tango, NULL::text, juliet_india1kilo_oscar1.victor_mike, CASE WHEN (juliet_india1kilo_oscar1.victor_mike < 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (juliet_india1kilo_oscar1.oscar_seven_tango - juliet_india1kilo_oscar1.victor_mike) END
  • Filter: ((juliet_india1kilo_oscar1.india_uniform <> 0) AND ((juliet_india1kilo_oscar1.oscar_seven_tango - juliet_india1kilo_oscar1.victor_mike) >= 'november_golf'::numeric) AND (CASE WHEN ((CASE WHEN (juliet_india1kilo_oscar1.victor_mike < 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (juliet_india1kilo_oscar1.oscar_seven_tango - juliet_india1kilo_oscar1.victor_mike) END = 'november_golf'::numeric) AND (juliet_india1kilo_oscar1.victor_mike <= 'november_golf'::numeric)) THEN 'four_uniform'::numeric ELSE (CASE WHEN (juliet_india1kilo_oscar1.victor_mike < 'november_golf'::numeric) THEN 'november_golf'::numeric ELSE (juliet_india1kilo_oscar1.oscar_seven_tango - juliet_india1kilo_oscar1.victor_mike) END / juliet_india1kilo_oscar1.oscar_seven_tango) END <> 'november_golf'::numeric))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1291
187. 0.144 2.496 ↑ 1.0 2 24

WindowAgg (cost=0.000..15.930 rows=2 width=90) (actual time=0.102..0.104 rows=2 loops=24)

  • Output: ('november_golf'::bigint), ((- india_romeo1.oscar_seven_tango)), NULL::text, five_hotel(((- india_romeo1.oscar_seven_tango))) zulu_quebec (?)
  • Buffers: shared hit=1291
188. 0.024 2.352 ↑ 1.0 2 24

Append (cost=0.000..15.900 rows=2 width=26) (actual time=0.001..0.098 rows=2 loops=24)

  • Buffers: shared hit=1291
189. 0.024 0.024 ↑ 1.0 1 24

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

  • Output: 'november_golf'::bigint, (- india_romeo1.oscar_seven_tango)
190. 0.024 2.304 ↑ 1.0 1 24

Subquery Scan on five_oscar (cost=15.870..15.880 rows=1 width=13) (actual time=0.096..0.096 rows=1 loops=24)

  • Output: "six_quebec".india_uniform, "six_quebec".oscar_seven_tango
  • Buffers: shared hit=1291
191. 0.072 2.280 ↑ 1.0 1 24

Sort (cost=15.870..15.870 rows=1 width=49) (actual time=0.095..0.095 rows=1 loops=24)

  • Output: five_kilo14.india_uniform, five_kilo14.oscar_seven_tango, NULL::text, five_kilo14.hotel_echo
  • Sort Key: five_kilo14.hotel_echo DESC, five_kilo14.india_uniform DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1291
192. 0.123 2.208 ↑ 1.0 1 24

Nested Loop (cost=0.990..15.860 rows=1 width=49) (actual time=0.082..0.092 rows=1 loops=24)

  • Output: five_kilo14.india_uniform, five_kilo14.oscar_seven_tango, NULL::text, five_kilo14.hotel_echo
  • Buffers: shared hit=1291
193. 0.552 0.552 ↓ 3.0 3 24

Index Scan using alpha_uniform on uniform_seven bravo_tango (cost=0.430..5.340 rows=1 width=14) (actual time=0.012..0.023 rows=3 loops=24)

  • Output: four_bravo_golf5.sierra_mike, four_bravo_golf5.india_uniform, four_bravo_golf5.victor_bravo, four_bravo_golf5.bravo_foxtrot, four_bravo_golf5.three_xray, four_bravo_golf5.romeo_three_sierra, four_bravo_golf5.juliet_six_yankee, four_bravo_golf5.sierra_echo_uniform
  • Index Cond: (four_bravo_golf5.romeo_three_sierra = four_bravo_golf4.romeo_three_sierra)
  • Filter: ((four_bravo_golf5.sierra_mike = 1) AND (four_bravo_golf5.bravo_foxtrot ~~ (CASE WHEN (four_bravo_golf4.bravo_foxtrot ~~ 'tango_six'::text) THEN 'bravo_victor'::text ELSE four_bravo_golf4.bravo_foxtrot END || 'xray_alpha'::text)))
  • Rows Removed by Filter: 9
  • Buffers: shared hit=363
194. 0.939 1.533 ↓ 0.0 0 73

Index Scan using victor_alpha on five_victor_echo echo_november (cost=0.560..10.510 rows=1 width=31) (actual time=0.021..0.021 rows=0 loops=73)

  • Output: five_kilo14.india_uniform, five_kilo14.oscar_seven_tango, five_kilo14.victor_bravo, five_kilo14.foxtrot_romeo_five, five_kilo14.hotel_echo, five_kilo14.tango_india, five_kilo14.zulu_xray, five_kilo14.uniform_quebec, five_kilo14.quebec_golf, five_kilo14.zulu_sierra_romeo, five_kilo14.seven_alpha_india, five_kilo14.delta_victor, five_kilo14.sierra_xray, five_kilo14.zulu_zulu_whiskey, five_kilo14.hotel_golf, five_kilo14.sierra_alpha, five_kilo14.six_bravo_golf, five_kilo14.charlie_papa_tango, five_kilo14.uniform_xray, five_kilo14.sierra_mike, five_kilo14.five_lima, five_kilo14.two_quebec, five_kilo14.three_xray, five_kilo14.charlie_papa_four
  • Index Cond: ((five_kilo14.victor_bravo = four_bravo_golf5.victor_bravo) AND (five_kilo14.foxtrot_romeo_five = india_romeo1.foxtrot_romeo_five))
  • Filter: ((five_kilo14.quebec_golf five_romeo NULL) AND (five_kilo14.hotel_echo five_romeo NOT NULL) AND (five_kilo14.hotel_echo <= 'sierra_tango'::date) AND (five_kilo14.oscar_seven_tango > 'november_golf'::numeric) AND (five_kilo14.sierra_mike = 1) AND (five_kilo14.three_xray = 1) AND ((five_kilo14.uniform_quebec <> 6) OR ((five_kilo14.uniform_quebec = 6) AND (NOT (three_delta_three: delta_four 14 or mike_mike delta_four 15)))))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=928
195.          

SubPlan (forIndex Scan)

196. 0.000 0.594 ↓ 0.0 0 11

Result (cost=0.990..7.920 rows=1 width=0) (actual time=0.054..0.054 rows=0 loops=11)

  • One-Time Filter: (five_kilo14.sierra_mike = 1)
  • Buffers: shared hit=434
197. 0.015 0.594 ↓ 0.0 0 11

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

  • Buffers: shared hit=434
198. 0.209 0.209 ↓ 3.0 3 11

Index Scan using alpha_uniform on uniform_seven sierra_seven_xray (cost=0.430..5.320 rows=1 width=10) (actual time=0.010..0.019 rows=3 loops=11)

  • Output: hotel_quebec_three2kilo_oscar1.sierra_mike, hotel_quebec_three2kilo_oscar1.india_uniform, hotel_quebec_three2kilo_oscar1.victor_bravo, hotel_quebec_three2kilo_oscar1.bravo_foxtrot, hotel_quebec_three2kilo_oscar1.three_xray, hotel_quebec_three2kilo_oscar1.romeo_three_sierra, hotel_quebec_three2kilo_oscar1.juliet_six_yankee, hotel_quebec_three2kilo_oscar1.sierra_echo_uniform
  • Index Cond: (hotel_quebec_three2kilo_oscar1.romeo_three_sierra = $77)
  • Filter: (hotel_quebec_three2kilo_oscar1.bravo_foxtrot = CASE WHEN ($76 ~~ 'tango_six'::text) THEN 'bravo_victor'::text ELSE $76 END)
  • Rows Removed by Filter: 12
  • Buffers: shared hit=192
199. 0.370 0.370 ↓ 0.0 0 37

Index Scan using victor_alpha on five_victor_echo charlie_quebec_three (cost=0.560..2.590 rows=1 width=10) (actual time=0.010..0.010 rows=0 loops=37)

  • Output: november_romeo_kilo2kilo_oscar1.india_uniform, november_romeo_kilo2kilo_oscar1.oscar_seven_tango, november_romeo_kilo2kilo_oscar1.victor_bravo, november_romeo_kilo2kilo_oscar1.foxtrot_romeo_five, november_romeo_kilo2kilo_oscar1.hotel_echo, november_romeo_kilo2kilo_oscar1.tango_india, november_romeo_kilo2kilo_oscar1.zulu_xray, november_romeo_kilo2kilo_oscar1.uniform_quebec, november_romeo_kilo2kilo_oscar1.quebec_golf, november_romeo_kilo2kilo_oscar1.zulu_sierra_romeo, november_romeo_kilo2kilo_oscar1.seven_alpha_india, november_romeo_kilo2kilo_oscar1.delta_victor, november_romeo_kilo2kilo_oscar1.sierra_xray, november_romeo_kilo2kilo_oscar1.zulu_zulu_whiskey, november_romeo_kilo2kilo_oscar1.hotel_golf, november_romeo_kilo2kilo_oscar1.sierra_alpha, november_romeo_kilo2kilo_oscar1.six_bravo_golf, november_romeo_kilo2kilo_oscar1.charlie_papa_tango, november_romeo_kilo2kilo_oscar1.uniform_xray, november_romeo_kilo2kilo_oscar1.sierra_mike, november_romeo_kilo2kilo_oscar1.five_lima, november_romeo_kilo2kilo_oscar1.two_quebec, november_romeo_kilo2kilo_oscar1.three_xray, november_romeo_kilo2kilo_oscar1.charlie_papa_four
  • Index Cond: ((november_romeo_kilo2kilo_oscar1.victor_bravo = hotel_quebec_three2kilo_oscar1.victor_bravo) AND (november_romeo_kilo2kilo_oscar1.foxtrot_romeo_five = $78))
  • Filter: ((november_romeo_kilo2kilo_oscar1.tango_india = five_kilo14.tango_india) AND (november_romeo_kilo2kilo_oscar1.zulu_xray = five_kilo14.uniform_xray))
  • Rows Removed by Filter: 4
  • Buffers: shared hit=242
200. 0.000 0.000 ↓ 0.0 0

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

  • Output: november_romeo_kilo2kilo_oscar2.tango_india, november_romeo_kilo2kilo_oscar2.zulu_xray, 1
201. 0.000 0.000 ↓ 0.0 0

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

  • Output: hotel_quebec_three2kilo_oscar2.sierra_mike, hotel_quebec_three2kilo_oscar2.india_uniform, hotel_quebec_three2kilo_oscar2.victor_bravo, hotel_quebec_three2kilo_oscar2.bravo_foxtrot, hotel_quebec_three2kilo_oscar2.three_xray, hotel_quebec_three2kilo_oscar2.romeo_three_sierra, hotel_quebec_three2kilo_oscar2.juliet_six_yankee, hotel_quebec_three2kilo_oscar2.sierra_echo_uniform
  • Index Cond: (hotel_quebec_three2kilo_oscar2.romeo_three_sierra = $77)
  • Filter: (hotel_quebec_three2kilo_oscar2.bravo_foxtrot = CASE WHEN ($76 ~~ 'tango_six'::text) THEN 'bravo_victor'::text ELSE $76 END)
202. 0.000 0.000 ↓ 0.0 0

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

  • Output: november_romeo_kilo2kilo_oscar2.india_uniform, november_romeo_kilo2kilo_oscar2.oscar_seven_tango, november_romeo_kilo2kilo_oscar2.victor_bravo, november_romeo_kilo2kilo_oscar2.foxtrot_romeo_five, november_romeo_kilo2kilo_oscar2.hotel_echo, november_romeo_kilo2kilo_oscar2.tango_india, november_romeo_kilo2kilo_oscar2.zulu_xray, november_romeo_kilo2kilo_oscar2.uniform_quebec, november_romeo_kilo2kilo_oscar2.quebec_golf, november_romeo_kilo2kilo_oscar2.zulu_sierra_romeo, november_romeo_kilo2kilo_oscar2.seven_alpha_india, november_romeo_kilo2kilo_oscar2.delta_victor, november_romeo_kilo2kilo_oscar2.sierra_xray, november_romeo_kilo2kilo_oscar2.zulu_zulu_whiskey, november_romeo_kilo2kilo_oscar2.hotel_golf, november_romeo_kilo2kilo_oscar2.sierra_alpha, november_romeo_kilo2kilo_oscar2.six_bravo_golf, november_romeo_kilo2kilo_oscar2.charlie_papa_tango, november_romeo_kilo2kilo_oscar2.uniform_xray, november_romeo_kilo2kilo_oscar2.sierra_mike, november_romeo_kilo2kilo_oscar2.five_lima, november_romeo_kilo2kilo_oscar2.two_quebec, november_romeo_kilo2kilo_oscar2.three_xray, november_romeo_kilo2kilo_oscar2.charlie_papa_four
  • Index Cond: ((november_romeo_kilo2kilo_oscar2.victor_bravo = hotel_quebec_three2kilo_oscar2.victor_bravo) AND (november_romeo_kilo2kilo_oscar2.foxtrot_romeo_five = $78))
203. 0.096 0.096 ↑ 1.0 1 24

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

  • Output: five_kilo13.india_uniform, five_kilo13.oscar_seven_tango, five_kilo13.victor_bravo, five_kilo13.foxtrot_romeo_five, five_kilo13.hotel_echo, five_kilo13.tango_india, five_kilo13.zulu_xray, five_kilo13.uniform_quebec, five_kilo13.quebec_golf, five_kilo13.zulu_sierra_romeo, five_kilo13.seven_alpha_india, five_kilo13.delta_victor, five_kilo13.sierra_xray, five_kilo13.zulu_zulu_whiskey, five_kilo13.hotel_golf, five_kilo13.sierra_alpha, five_kilo13.six_bravo_golf, five_kilo13.charlie_papa_tango, five_kilo13.uniform_xray, five_kilo13.sierra_mike, five_kilo13.five_lima, five_kilo13.two_quebec, five_kilo13.three_xray, five_kilo13.charlie_papa_four
  • Index Cond: (five_kilo13.india_uniform = quebec_sierra6.india_uniform)
  • Buffers: shared hit=96
204.          

SubPlan (forGroupAggregate)

205. 0.000 0.000 ↓ 0.0 0

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

  • Output: two_lima((five_kilo13.tango_india)::character varying, 1, 'sierra_tango'::date)
206. 0.000 0.000 ↓ 0.0 0

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

  • Output: six_oscar((five_kilo13.tango_india)::character varying, 1)
207.          

SubPlan (forNested Loop)

208. 23.528 23.528 ↑ 1.0 1 692

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

  • Output: two_lima((six_lima2.tango_india)::character varying, 1, 'sierra_tango'::date)
  • Buffers: shared hit=3522
209. 0.000 0.000 ↓ 0.0 0

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

  • Output: six_oscar((six_lima2.tango_india)::character varying, 1)
210. 19.136 19.136 ↑ 1.0 1 368

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

  • Output: tango_sierra_oscar(six_lima2.tango_india, 1, six_lima2.foxtrot_romeo_five, six_lima2.uniform_xray, six_lima2.hotel_echo)
  • Buffers: shared hit=3350
211. 4.785 4.785 ↑ 1.0 1 1,595

Index Scan using five_mike on five_victor_echo november_kilo (cost=0.440..2.450 rows=1 width=55) (actual time=0.003..0.003 rows=1 loops=1,595)

  • Output: five_kilo19.india_uniform, five_kilo19.oscar_seven_tango, five_kilo19.victor_bravo, five_kilo19.foxtrot_romeo_five, five_kilo19.hotel_echo, five_kilo19.tango_india, five_kilo19.zulu_xray, five_kilo19.uniform_quebec, five_kilo19.quebec_golf, five_kilo19.zulu_sierra_romeo, five_kilo19.seven_alpha_india, five_kilo19.delta_victor, five_kilo19.sierra_xray, five_kilo19.zulu_zulu_whiskey, five_kilo19.hotel_golf, five_kilo19.sierra_alpha, five_kilo19.six_bravo_golf, five_kilo19.charlie_papa_tango, five_kilo19.uniform_xray, five_kilo19.sierra_mike, five_kilo19.five_lima, five_kilo19.two_quebec, five_kilo19.three_xray, five_kilo19.charlie_papa_four
  • Index Cond: (five_kilo19.india_uniform = three_hotel.yankee_lima)
  • Buffers: shared hit=6158
212. 4.785 4.785 ↑ 1.0 1 1,595

Index Scan using five_mike on five_victor_echo whiskey_delta_juliet (cost=0.440..2.450 rows=1 width=48) (actual time=0.003..0.003 rows=1 loops=1,595)

  • Output: juliet_six_victor3.india_uniform, juliet_six_victor3.oscar_seven_tango, juliet_six_victor3.victor_bravo, juliet_six_victor3.foxtrot_romeo_five, juliet_six_victor3.hotel_echo, juliet_six_victor3.tango_india, juliet_six_victor3.zulu_xray, juliet_six_victor3.uniform_quebec, juliet_six_victor3.quebec_golf, juliet_six_victor3.zulu_sierra_romeo, juliet_six_victor3.seven_alpha_india, juliet_six_victor3.delta_victor, juliet_six_victor3.sierra_xray, juliet_six_victor3.zulu_zulu_whiskey, juliet_six_victor3.hotel_golf, juliet_six_victor3.sierra_alpha, juliet_six_victor3.six_bravo_golf, juliet_six_victor3.charlie_papa_tango, juliet_six_victor3.uniform_xray, juliet_six_victor3.sierra_mike, juliet_six_victor3.five_lima, juliet_six_victor3.two_quebec, juliet_six_victor3.three_xray, juliet_six_victor3.charlie_papa_four
  • Index Cond: (juliet_six_victor3.india_uniform = three_hotel.india_uniform)
  • Buffers: shared hit=6158
213. 12.760 12.760 ↑ 1.0 1 1,595

Index Scan using mike_golf on uniform_seven romeo_golf_echo (cost=0.430..1.590 rows=1 width=17) (actual time=0.008..0.008 rows=1 loops=1,595)

  • Output: four_bravo_golf6.sierra_mike, four_bravo_golf6.india_uniform, four_bravo_golf6.victor_bravo, four_bravo_golf6.bravo_foxtrot, four_bravo_golf6.three_xray, four_bravo_golf6.romeo_three_sierra, four_bravo_golf6.juliet_six_yankee, four_bravo_golf6.sierra_echo_uniform
  • Index Cond: (four_bravo_golf6.victor_bravo = juliet_six_victor3.victor_bravo)
  • Filter: (four_bravo_golf6.sierra_mike = juliet_six_victor3.sierra_mike)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=7250
214. 9.570 9.570 ↓ 0.0 0 1,595

Index Scan using golf_echo on november_lima juliet_juliet (cost=0.420..2.260 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=1,595)

  • Output: oscar_mike1.india_uniform, oscar_mike1.six_juliet_quebec, oscar_mike1.oscar_november_oscar, oscar_mike1.foxtrot_romeo_five, oscar_mike1.zulu_xray, oscar_mike1.quebec_six, oscar_mike1.sierra_mike, oscar_mike1.victor_bravo, oscar_mike1.three_xray
  • Index Cond: (oscar_mike1.six_juliet_quebec = three_hotel.tango_india)
  • Filter: (oscar_mike1.sierra_mike = 1)
  • Buffers: shared hit=5246
215. 4.785 4.785 ↓ 0.0 0 1,595

Index Scan using mike_golf on uniform_seven victor_echo_juliet (cost=0.430..1.620 rows=1 width=17) (actual time=0.003..0.003 rows=0 loops=1,595)

  • Output: victor_echo_juliet.sierra_mike, victor_echo_juliet.india_uniform, victor_echo_juliet.victor_bravo, victor_echo_juliet.bravo_foxtrot, victor_echo_juliet.three_xray, victor_echo_juliet.romeo_three_sierra, victor_echo_juliet.juliet_six_yankee, victor_echo_juliet.sierra_echo_uniform
  • Index Cond: (victor_echo_juliet.victor_bravo = oscar_mike1.victor_bravo)
  • Filter: ((victor_echo_juliet.sierra_mike = 1) AND (victor_echo_juliet.sierra_mike = oscar_mike1.sierra_mike))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=2766
216. 1.595 94.105 ↑ 4.0 1 1,595

Append (cost=15.410..16.480 rows=4 width=240) (actual time=0.053..0.059 rows=1 loops=1,595)

  • Buffers: shared hit=26533
217.          

CTE delta_zulu

218. 1.849 12.760 ↑ 1.0 1 1,595

Nested Loop Left Join (cost=0.850..4.900 rows=1 width=99) (actual time=0.008..0.008 rows=1 loops=1,595)

  • Output: five_kilo15.five_lima, five_kilo15.uniform_quebec, five_kilo15.zulu_xray, five_kilo15.six_bravo_golf, five_kilo15.sierra_mike, xray_juliet6.four_seven, five_kilo15.hotel_echo, five_kilo15.tango_india, five_kilo15.charlie_papa_four, five_kilo15.oscar_seven_tango, five_kilo15.delta_victor, five_kilo15.hotel_golf, five_kilo15.foxtrot_romeo_five, five_kilo15.three_xray, five_kilo15.sierra_alpha, five_kilo15.zulu_zulu_whiskey, five_kilo15.sierra_xray
  • Inner Unique: true
  • Buffers: shared hit=10242
219. 4.785 4.785 ↑ 1.0 1 1,595

Index Scan using five_mike on five_victor_echo yankee_charlie_hotel (cost=0.440..2.460 rows=1 width=95) (actual time=0.003..0.003 rows=1 loops=1,595)

  • Output: five_kilo15.india_uniform, five_kilo15.oscar_seven_tango, five_kilo15.victor_bravo, five_kilo15.foxtrot_romeo_five, five_kilo15.hotel_echo, five_kilo15.tango_india, five_kilo15.zulu_xray, five_kilo15.uniform_quebec, five_kilo15.quebec_golf, five_kilo15.zulu_sierra_romeo, five_kilo15.seven_alpha_india, five_kilo15.delta_victor, five_kilo15.sierra_xray, five_kilo15.zulu_zulu_whiskey, five_kilo15.hotel_golf, five_kilo15.sierra_alpha, five_kilo15.six_bravo_golf, five_kilo15.charlie_papa_tango, five_kilo15.uniform_xray, five_kilo15.sierra_mike, five_kilo15.five_lima, five_kilo15.two_quebec, five_kilo15.three_xray, five_kilo15.charlie_papa_four
  • Index Cond: (five_kilo15.india_uniform = $93)
  • Filter: ((five_kilo15.uniform_quebec <> 2) AND (five_kilo15.uniform_quebec <> 6))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=6158
220. 6.126 6.126 ↑ 1.0 1 1,021

Index Scan using yankee_echo on yankee_zulu oscar_lima_india (cost=0.420..2.440 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=1,021)

  • Output: xray_juliet6.foxtrot_romeo_five, xray_juliet6.oscar_seven_november, xray_juliet6.xray_lima, xray_juliet6.four_seven, xray_juliet6.seven_yankee, xray_juliet6.zulu_juliet, xray_juliet6.three_xray, xray_juliet6.seven_kilo
  • Index Cond: (xray_juliet6.foxtrot_romeo_five = five_kilo15.foxtrot_romeo_five)
  • Buffers: shared hit=4084
221.          

CTE seven_xray

222. 2.042 2.042 ↑ 1.0 1 1,021

CTE Scan on delta_zulu bravo_six_tango (cost=0.000..0.040 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=1,021)

  • Output: CASE WHEN (five_kilo16.five_lima five_romeo NULL) THEN five_kilo16.sierra_alpha ELSE CASE WHEN (five_kilo16.four_seven = 2) THEN (- (five_kilo16.hotel_golf + five_kilo16.zulu_zulu_whiskey)) ELSE (five_kilo16.sierra_xray + (((five_kilo16.oscar_seven_tango - five_kilo16.delta_victor) / five_kilo16.oscar_seven_tango) * (five_kilo16.hotel_golf + five_kilo16.zulu_zulu_whiskey))) END END
223.          

CTE alpha_november

224. 1.021 11.231 ↑ 1.0 1 1,021

Nested Loop Left Join (cost=0.430..2.520 rows=1 width=32) (actual time=0.010..0.011 rows=1 loops=1,021)

  • Output: lima_sierra_five((lima_sierra_five(kilo_foxtrot.juliet_romeo, 'seven_mike'::text)), CASE WHEN (five_kilo17.sierra_mike = 0) THEN 'uniform_november_kilo'::text ELSE 'seven_mike'::text END)
  • Buffers: shared hit=3072
225. 0.000 0.000 ↑ 1.0 1 1,021

CTE Scan on delta_zulu uniform_charlie (cost=0.000..0.020 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1,021)

  • Output: five_kilo17.five_lima, five_kilo17.uniform_quebec, five_kilo17.zulu_xray, five_kilo17.six_bravo_golf, five_kilo17.sierra_mike, five_kilo17.four_seven, five_kilo17.hotel_echo, five_kilo17.tango_india, five_kilo17.charlie_papa_four, five_kilo17.oscar_seven_tango, five_kilo17.delta_victor, five_kilo17.hotel_golf, five_kilo17.foxtrot_romeo_five, five_kilo17.three_xray, five_kilo17.sierra_alpha, five_kilo17.zulu_zulu_whiskey, five_kilo17.sierra_xray
226. 1.509 10.210 ↑ 1.0 1 1,021

Nested Loop Left Join (cost=0.430..2.480 rows=1 width=32) (actual time=0.009..0.010 rows=1 loops=1,021)

  • Output: lima_sierra_five(kilo_foxtrot.juliet_romeo, 'seven_mike'::text)
  • Buffers: shared hit=3072
227. 1.021 1.021 ↑ 1.0 1 1,021

CTE Scan on delta_zulu juliet_yankee (cost=0.000..0.030 rows=1 width=96) (actual time=0.001..0.001 rows=1 loops=1,021)

  • Output: five_kilo18.five_lima, five_kilo18.uniform_quebec, five_kilo18.zulu_xray, five_kilo18.six_bravo_golf, five_kilo18.sierra_mike, five_kilo18.four_seven, five_kilo18.hotel_echo, five_kilo18.tango_india, five_kilo18.charlie_papa_four, five_kilo18.oscar_seven_tango, five_kilo18.delta_victor, five_kilo18.hotel_golf, five_kilo18.foxtrot_romeo_five, five_kilo18.three_xray, five_kilo18.sierra_alpha, five_kilo18.zulu_zulu_whiskey, five_kilo18.sierra_xray
  • Filter: ((five_kilo18.sierra_mike <> 0) AND (five_kilo18.uniform_quebec = 3))
  • Rows Removed by Filter: 0
228. 7.680 7.680 ↑ 1.0 1 768

Index Scan using echo_romeo on foxtrot_bravo kilo_foxtrot (cost=0.430..2.450 rows=1 width=32) (actual time=0.009..0.010 rows=1 loops=768)

  • Output: kilo_foxtrot.india_uniform, kilo_foxtrot.zulu_xray, kilo_foxtrot.foxtrot_romeo_five, kilo_foxtrot.six_hotel, kilo_foxtrot.sierra_mike, kilo_foxtrot.victor_bravo, kilo_foxtrot.juliet_romeo, kilo_foxtrot.three_xray, kilo_foxtrot.yankee_bravo_tango
  • Index Cond: ((kilo_foxtrot.zulu_xray = five_kilo18.zulu_xray) AND (kilo_foxtrot.six_hotel = five_kilo18.tango_india))
  • Filter: ((kilo_foxtrot.foxtrot_romeo_five)::text = five_kilo18.foxtrot_romeo_five)
  • Buffers: shared hit=3072
229. 8.986 90.915 ↑ 3.0 1 1,595

Nested Loop (cost=7.960..8.900 rows=3 width=240) (actual time=0.052..0.057 rows=1 loops=1,595)

  • Output: three_hotel.india_uniform, ((kilo_sierra_mike.oscar_alpha_november * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five)), (((kilo_sierra_mike.oscar_alpha_november / (lima_sierra_five(CASE WHEN (papa_india_four.foxtrot_india < 'yankee_bravo_india'::numeric) THEN NULL::numeric ELSE (papa_india_four.foxtrot_india / 'seven_whiskey'::numeric) END, ((six_alpha2.foxtrot_india / 'seven_whiskey'::numeric))))) * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five)), ((kilo_sierra_mike.oscar_alpha_november * three_hotel.xray_victor) * three_hotel.seven_five), (((kilo_sierra_mike.oscar_alpha_november / (lima_sierra_five(CASE WHEN (papa_india_four.foxtrot_india < 'yankee_bravo_india'::numeric) THEN NULL::numeric ELSE (papa_india_four.foxtrot_india / 'seven_whiskey'::numeric) END, ((six_alpha2.foxtrot_india / 'seven_whiskey'::numeric))))) * three_hotel.xray_victor) * three_hotel.seven_five), (sierra_six.juliet_romeo)::alpha_alpha_kilo, (lima_sierra_five(CASE WHEN (papa_india_four.foxtrot_india < 'yankee_bravo_india'::numeric) THEN NULL::numeric ELSE (papa_india_four.foxtrot_india / 'seven_whiskey'::numeric) END, ((six_alpha2.foxtrot_india / 'seven_whiskey'::numeric)))), (lima_sierra_five(three_november.yankee_delta_november, lima_sierra_five(papa_india_four.two_victor_hotel, lima_sierra_five(five_kilo21.hotel_echo)))), (CASE WHEN (three_november.yankee_delta_november five_romeo NOT NULL) THEN ((('juliet_quebec'::text || three_tango_uniform.juliet_romeo) || 'seven_papa'::text) || CASE WHEN (oscar_mike2.juliet_romeo = 'seven_mike'::text) THEN 'uniform_november_kilo'::text ELSE 'seven_mike'::text END) ELSE CASE WHEN (papa_india_four.two_victor_hotel five_romeo NOT NULL) THEN ((('juliet_quebec'::text || three_tango_uniform.juliet_romeo) || 'november_juliet'::text) || CASE WHEN (oscar_mike2.juliet_romeo = 'seven_mike'::text) THEN 'uniform_november_kilo'::text ELSE 'seven_mike'::text END) ELSE ((('juliet_quebec'::text || three_tango_uniform.juliet_romeo) || 'alpha_zulu'::text) || CASE WHEN (oscar_mike2.juliet_romeo = 'seven_mike'::text) THEN 'uniform_november_kilo'::text ELSE 'seven_mike'::text END) END END), ((((kilo_sierra_mike.oscar_alpha_november / (lima_sierra_five(CASE WHEN (papa_india_four.foxtrot_india < 'yankee_bravo_india'::numeric) THEN NULL::numeric ELSE (papa_india_four.foxtrot_india / 'seven_whiskey'::numeric) END, ((six_alpha2.foxtrot_india / 'seven_whiskey'::numeric))))) * ((six_alpha2.foxtrot_india / 'seven_whiskey'::numeric))) * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five))
  • Buffers: shared hit=26533
230. 1.529 31.900 ↑ 1.0 1 1,595

Nested Loop (cost=0.000..0.080 rows=1 width=64) (actual time=0.019..0.020 rows=1 loops=1,595)

  • Output: kilo_sierra_mike.oscar_alpha_november, sierra_six.juliet_romeo
  • Buffers: shared hit=13314
231. 0.127 19.140 ↑ 1.0 1 1,595

Nested Loop (cost=0.000..0.050 rows=1 width=32) (actual time=0.012..0.012 rows=1 loops=1,595)

  • Output: kilo_sierra_mike.oscar_alpha_november
  • Buffers: shared hit=10242
232. 15.950 15.950 ↑ 1.0 1 1,595

CTE Scan on delta_zulu five_zulu_kilo (cost=0.000..0.020 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=1,595)

  • Output: five_kilo20.five_lima, five_kilo20.uniform_quebec, five_kilo20.zulu_xray, five_kilo20.six_bravo_golf, five_kilo20.sierra_mike, five_kilo20.four_seven, five_kilo20.hotel_echo, five_kilo20.tango_india, five_kilo20.charlie_papa_four, five_kilo20.oscar_seven_tango, five_kilo20.delta_victor, five_kilo20.hotel_golf, five_kilo20.foxtrot_romeo_five, five_kilo20.three_xray, five_kilo20.sierra_alpha, five_kilo20.zulu_zulu_whiskey, five_kilo20.sierra_xray
  • Filter: (five_kilo20.sierra_mike <> 0)
  • Buffers: shared hit=10242
233. 3.063 3.063 ↑ 1.0 1 1,021

CTE Scan on seven_xray kilo_sierra_mike (cost=0.000..0.020 rows=1 width=32) (actual time=0.002..0.003 rows=1 loops=1,021)

  • Output: kilo_sierra_mike.oscar_alpha_november
234. 11.231 11.231 ↑ 1.0 1 1,021

CTE Scan on alpha_november sierra_six (cost=0.000..0.020 rows=1 width=32) (actual time=0.010..0.011 rows=1 loops=1,021)

  • Output: sierra_six.juliet_romeo
  • Buffers: shared hit=3072
235. 1.021 50.029 ↑ 3.0 1 1,021

Append (cost=7.960..8.610 rows=3 width=100) (actual time=0.043..0.049 rows=1 loops=1,021)

  • Buffers: shared hit=13219
236. 2.015 43.903 ↑ 1.0 1 1,021

Nested Loop (cost=7.960..8.180 rows=1 width=100) (actual time=0.039..0.043 rows=1 loops=1,021)

  • Output: ((six_alpha2.foxtrot_india / 'seven_whiskey'::numeric)), lima_sierra_five(CASE WHEN (papa_india_four.foxtrot_india < 'yankee_bravo_india'::numeric) THEN NULL::numeric ELSE (papa_india_four.foxtrot_india / 'seven_whiskey'::numeric) END, ((six_alpha2.foxtrot_india / 'seven_whiskey'::numeric))), lima_sierra_five(three_november.yankee_delta_november, lima_sierra_five(papa_india_four.two_victor_hotel, lima_sierra_five(five_kilo21.hotel_echo))), CASE WHEN (three_november.yankee_delta_november five_romeo NOT NULL) THEN ((('juliet_quebec'::text || three_tango_uniform.juliet_romeo) || 'seven_papa'::text) || CASE WHEN (oscar_mike2.juliet_romeo = 'seven_mike'::text) THEN 'uniform_november_kilo'::text ELSE 'seven_mike'::text END) ELSE CASE WHEN (papa_india_four.two_victor_hotel five_romeo NOT NULL) THEN ((('juliet_quebec'::text || three_tango_uniform.juliet_romeo) || 'november_juliet'::text) || CASE WHEN (oscar_mike2.juliet_romeo = 'seven_mike'::text) THEN 'uniform_november_kilo'::text ELSE 'seven_mike'::text END) ELSE ((('juliet_quebec'::text || three_tango_uniform.juliet_romeo) || 'alpha_zulu'::text) || CASE WHEN (oscar_mike2.juliet_romeo = 'seven_mike'::text) THEN 'uniform_november_kilo'::text ELSE 'seven_mike'::text END) END END
  • Buffers: shared hit=12460
237. 1.491 32.672 ↑ 1.0 1 1,021

Nested Loop Left Join (cost=7.670..7.810 rows=1 width=81) (actual time=0.028..0.032 rows=1 loops=1,021)

  • Output: five_kilo21.hotel_echo, three_tango_uniform.juliet_romeo, oscar_mike2.juliet_romeo, papa_india_four.foxtrot_india, papa_india_four.two_victor_hotel, three_november.yankee_delta_november
  • Buffers: shared hit=10156
238. 0.985 17.357 ↑ 1.0 1 1,021

Nested Loop Left Join (cost=2.770..2.880 rows=1 width=141) (actual time=0.014..0.017 rows=1 loops=1,021)

  • Output: five_kilo21.hotel_echo, five_kilo21.zulu_xray, five_kilo21.charlie_papa_four, three_tango_uniform.juliet_romeo, oscar_mike2.juliet_romeo, papa_india_four.foxtrot_india, papa_india_four.two_victor_hotel
  • Buffers: shared hit=4012
239. 0.759 4.084 ↑ 1.0 1 1,021

Nested Loop (cost=0.000..0.080 rows=1 width=172) (actual time=0.002..0.004 rows=1 loops=1,021)

  • Output: five_kilo21.hotel_echo, five_kilo21.six_bravo_golf, five_kilo21.sierra_mike, five_kilo21.three_xray, five_kilo21.zulu_xray, five_kilo21.charlie_papa_four, three_tango_uniform.juliet_romeo, oscar_mike2.juliet_romeo
240. 1.021 1.021 ↑ 1.0 1 1,021

Nested Loop (cost=0.000..0.060 rows=1 width=140) (actual time=0.001..0.001 rows=1 loops=1,021)

  • Output: five_kilo21.hotel_echo, five_kilo21.six_bravo_golf, five_kilo21.sierra_mike, five_kilo21.three_xray, five_kilo21.zulu_xray, five_kilo21.charlie_papa_four, three_tango_uniform.juliet_romeo
241. 0.000 0.000 ↑ 1.0 1 1,021

CTE Scan on delta_zulu bravo_echo (cost=0.000..0.030 rows=1 width=108) (actual time=0.000..0.000 rows=1 loops=1,021)

  • Output: five_kilo21.five_lima, five_kilo21.uniform_quebec, five_kilo21.zulu_xray, five_kilo21.six_bravo_golf, five_kilo21.sierra_mike, five_kilo21.four_seven, five_kilo21.hotel_echo, five_kilo21.tango_india, five_kilo21.charlie_papa_four, five_kilo21.oscar_seven_tango, five_kilo21.delta_victor, five_kilo21.hotel_golf, five_kilo21.foxtrot_romeo_five, five_kilo21.three_xray, five_kilo21.sierra_alpha, five_kilo21.zulu_zulu_whiskey, five_kilo21.sierra_xray
  • Filter: ((five_kilo21.sierra_mike <> 0) AND (five_kilo21.uniform_quebec = 3))
  • Rows Removed by Filter: 0
242. 0.000 0.000 ↑ 1.0 1 768

CTE Scan on alpha_november three_tango_uniform (cost=0.000..0.020 rows=1 width=32) (actual time=0.000..0.000 rows=1 loops=768)

  • Output: three_tango_uniform.juliet_romeo
243. 2.304 2.304 ↑ 1.0 1 768

CTE Scan on alpha_november charlie_oscar (cost=0.000..0.020 rows=1 width=32) (actual time=0.000..0.003 rows=1 loops=768)

  • Output: oscar_mike2.juliet_romeo
244. 0.768 12.288 ↑ 1.0 1 768

Limit (cost=2.770..2.770 rows=1 width=9) (actual time=0.015..0.016 rows=1 loops=768)

  • Output: papa_india_four.foxtrot_india, papa_india_four.two_victor_hotel
  • Buffers: shared hit=4012
245. 2.304 11.520 ↑ 1.0 1 768

Sort (cost=2.770..2.770 rows=1 width=9) (actual time=0.015..0.015 rows=1 loops=768)

  • Output: papa_india_four.foxtrot_india, papa_india_four.two_victor_hotel
  • Sort Key: papa_india_four.two_victor_hotel DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4012
246. 9.216 9.216 ↑ 1.0 1 768

Index Scan using romeo_papa on bravo_six_november papa_india_four (cost=0.430..2.760 rows=1 width=9) (actual time=0.011..0.012 rows=1 loops=768)

  • Output: papa_india_four.foxtrot_india, papa_india_four.two_victor_hotel
  • Index Cond: (papa_india_four.six_bravo_golf = five_kilo21.six_bravo_golf)
  • Filter: ((papa_india_four.sierra_mike = five_kilo21.sierra_mike) AND (papa_india_four.three_xray = five_kilo21.three_xray) AND ((papa_india_four.foxtrot_india > 'yankee_bravo_india'::numeric) OR ((papa_india_four.foxtrot_india <= 'yankee_bravo_india'::numeric) AND (three_tango_uniform.juliet_romeo = 'seven_mike'::text))))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4012
247. 0.768 13.824 ↑ 1.0 1 768

Limit (cost=4.910..4.910 rows=1 width=4) (actual time=0.017..0.018 rows=1 loops=768)

  • Output: three_november.yankee_delta_november
  • Buffers: shared hit=6144
248. 1.536 13.056 ↑ 1.0 1 768

Sort (cost=4.910..4.910 rows=1 width=4) (actual time=0.017..0.017 rows=1 loops=768)

  • Output: three_november.yankee_delta_november
  • Sort Key: three_november.yankee_delta_november DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6144
249. 1.536 11.520 ↑ 1.0 1 768

Nested Loop Left Join (cost=0.860..4.900 rows=1 width=4) (actual time=0.015..0.015 rows=1 loops=768)

  • Output: three_november.yankee_delta_november
  • Inner Unique: true
  • Buffers: shared hit=6144
250. 7.680 7.680 ↑ 1.0 1 768

Index Scan using november_six on delta_two india_lima (cost=0.430..2.450 rows=1 width=8) (actual time=0.009..0.010 rows=1 loops=768)

  • Output: india_lima.india_uniform, india_lima.zulu_xray, india_lima.charlie_papa_four, india_lima.quebec_two, india_lima.sierra_mike, india_lima.three_xray
  • Index Cond: ((india_lima.zulu_xray = five_kilo21.zulu_xray) AND (india_lima.charlie_papa_four = five_kilo21.charlie_papa_four))
  • Buffers: shared hit=3072
251. 2.304 2.304 ↑ 1.0 1 768

Index Scan using six_juliet_two on three_two_kilo three_november (cost=0.430..2.450 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=768)

  • Output: three_november.india_uniform, three_november.yankee_delta_november, three_november.charlie_papa_four, three_november.sierra_mike, three_november.three_xray
  • Index Cond: (three_november.india_uniform = india_lima.quebec_two)
  • Buffers: shared hit=3072
252. 0.768 9.216 ↑ 1.0 1 768

Limit (cost=0.280..0.320 rows=1 width=36) (actual time=0.011..0.012 rows=1 loops=768)

  • Output: ((six_alpha2.foxtrot_india / 'seven_whiskey'::numeric)), six_alpha2.uniform_uniform_lima
  • Buffers: shared hit=2304
253. 8.448 8.448 ↑ 1,523.0 1 768

Index Scan Backward using hotel_yankee on charlie_quebec_two oscar_tango (cost=0.280..52.660 rows=1,523 width=36) (actual time=0.010..0.011 rows=1 loops=768)

  • Output: (six_alpha2.foxtrot_india / 'seven_whiskey'::numeric), six_alpha2.uniform_uniform_lima
  • Index Cond: ((six_alpha2.uniform_uniform_lima <= lima_sierra_five(three_november.yankee_delta_november, lima_sierra_five(papa_india_four.two_victor_hotel, lima_sierra_five(five_kilo21.hotel_echo)))) AND (six_alpha2.uniform_uniform_lima five_romeo NOT NULL))
  • Buffers: shared hit=2304
254. 0.795 4.084 ↓ 0.0 0 1,021

Nested Loop (cost=0.280..0.360 rows=1 width=100) (actual time=0.004..0.004 rows=0 loops=1,021)

  • Output: ((six_alpha3.foxtrot_india / 'seven_whiskey'::numeric)), ((six_alpha3.foxtrot_india / 'seven_whiskey'::numeric)), five_kilo22.hotel_echo, 'echo_five'::text
  • Buffers: shared hit=759
255. 0.000 0.000 ↓ 0.0 0 1,021

CTE Scan on delta_zulu hotel_hotel (cost=0.000..0.030 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1,021)

  • Output: five_kilo22.five_lima, five_kilo22.uniform_quebec, five_kilo22.zulu_xray, five_kilo22.six_bravo_golf, five_kilo22.sierra_mike, five_kilo22.four_seven, five_kilo22.hotel_echo, five_kilo22.tango_india, five_kilo22.charlie_papa_four, five_kilo22.oscar_seven_tango, five_kilo22.delta_victor, five_kilo22.hotel_golf, five_kilo22.foxtrot_romeo_five, five_kilo22.three_xray, five_kilo22.sierra_alpha, five_kilo22.zulu_zulu_whiskey, five_kilo22.sierra_xray
  • Filter: ((five_kilo22.sierra_mike <> 0) AND (five_kilo22.uniform_quebec <> 3))
  • Rows Removed by Filter: 1
256. 0.253 3.289 ↑ 1.0 1 253

Limit (cost=0.280..0.320 rows=1 width=36) (actual time=0.013..0.013 rows=1 loops=253)

  • Output: ((six_alpha3.foxtrot_india / 'seven_whiskey'::numeric)), six_alpha3.uniform_uniform_lima
  • Buffers: shared hit=759
257. 3.036 3.036 ↑ 1,523.0 1 253

Index Scan Backward using hotel_yankee on charlie_quebec_two yankee_kilo (cost=0.280..52.660 rows=1,523 width=36) (actual time=0.012..0.012 rows=1 loops=253)

  • Output: (six_alpha3.foxtrot_india / 'seven_whiskey'::numeric), six_alpha3.uniform_uniform_lima
  • Index Cond: ((six_alpha3.uniform_uniform_lima <= five_kilo22.hotel_echo) AND (six_alpha3.uniform_uniform_lima five_romeo NOT NULL))
  • Buffers: shared hit=759
258. 1.021 1.021 ↓ 0.0 0 1,021

Subquery Scan on foxtrot_november_tango (cost=0.000..0.040 rows=1 width=100) (actual time=0.001..0.001 rows=0 loops=1,021)

  • Output: 1, 1, "mike_three".hotel_echo, ''::text
259. 0.000 0.000 ↓ 0.0 0 1,021

CTE Scan on delta_zulu xray_foxtrot_xray (cost=0.000..0.020 rows=1 width=44) (actual time=0.000..0.000 rows=0 loops=1,021)

  • Output: 1, 1, five_kilo23.hotel_echo, ''::text
  • Filter: (five_kilo23.sierra_mike = 0)
  • Rows Removed by Filter: 1
260. 1.595 1.595 ↓ 0.0 0 1,595

Subquery Scan on three_four_foxtrot (cost=0.000..0.080 rows=1 width=240) (actual time=0.001..0.001 rows=0 loops=1,595)

  • Output: "sierra_echo_zulu".two_victor_lima, "sierra_echo_zulu"."seven_alpha_zulu", 0.0, "sierra_echo_zulu"."two_romeo", 0.0, 'uniform_november_kilo'::alpha_alpha_kilo, 1, NULL::date, ''::text, 0.0
261. 0.000 0.000 ↓ 0.0 0 1,595

Nested Loop (cost=0.000..0.070 rows=1 width=212) (actual time=0.000..0.000 rows=0 loops=1,595)

  • Output: three_hotel.india_uniform, ((sierra_seven_uniform1.oscar_alpha_november * three_hotel.xray_victor) * ('four_uniform'::numeric - three_hotel.seven_five)), 0.0, ((sierra_seven_uniform1.oscar_alpha_november * three_hotel.xray_victor) * three_hotel.seven_five), 0.0, 'uniform_november_kilo'::alpha_alpha_kilo, 1, NULL::date, ''::text, 0.0
262. 0.000 0.000 ↓ 0.0 0 1,595

CTE Scan on delta_zulu xray_quebec (cost=0.000..0.020 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=1,595)

  • Output: five_kilo24.five_lima, five_kilo24.uniform_quebec, five_kilo24.zulu_xray, five_kilo24.six_bravo_golf, five_kilo24.sierra_mike, five_kilo24.four_seven, five_kilo24.hotel_echo, five_kilo24.tango_india, five_kilo24.charlie_papa_four, five_kilo24.oscar_seven_tango, five_kilo24.delta_victor, five_kilo24.hotel_golf, five_kilo24.foxtrot_romeo_five, five_kilo24.three_xray, five_kilo24.sierra_alpha, five_kilo24.zulu_zulu_whiskey, five_kilo24.sierra_xray
  • Filter: (five_kilo24.sierra_mike = 0)
  • Rows Removed by Filter: 1
263. 0.000 0.000 ↓ 0.0 0

CTE Scan on seven_xray two_two_papa (cost=0.000..0.020 rows=1 width=32) (never executed)

  • Output: sierra_seven_uniform1.oscar_alpha_november
264. 1.767 106.865 ↓ 0.0 0 1,595

Nested Loop (cost=46.790..48.200 rows=1 width=288) (actual time=0.066..0.067 rows=0 loops=1,595)

  • Output: ((((((five_hotel(oscar_mike3.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * ('four_uniform'::numeric - three_hotel.seven_five))), ((((((five_hotel(oscar_mike4.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * ('four_uniform'::numeric - three_hotel.seven_five))), ((((((five_hotel(oscar_mike3.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * three_hotel.seven_five)), ((((((five_hotel(oscar_mike4.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * three_hotel.seven_five)), NULL::numeric, NULL::numeric, NULL::numeric, NULL::numeric, NULL::text
  • Buffers: shared hit=23761
265. 1.595 20.735 ↓ 0.0 0 1,595

Limit (cost=0.560..1.800 rows=1 width=40) (actual time=0.013..0.013 rows=0 loops=1,595)

  • Output: five_kilo25.india_uniform, ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?)))
  • Buffers: shared hit=6885
266. 3.190 19.140 ↓ 0.0 0 1,595

WindowAgg (cost=0.560..26.500 rows=21 width=40) (actual time=0.012..0.012 rows=0 loops=1,595)

  • Output: five_kilo25.india_uniform, (five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))
  • Buffers: shared hit=6885
267. 15.950 15.950 ↑ 21.0 1 1,595

Index Scan using papa_mike on five_victor_echo tango_four (cost=0.560..26.180 rows=21 width=13) (actual time=0.009..0.010 rows=1 loops=1,595)

  • Output: five_kilo25.india_uniform, five_kilo25.oscar_seven_tango, five_kilo25.victor_bravo, five_kilo25.foxtrot_romeo_five, five_kilo25.hotel_echo, five_kilo25.tango_india, five_kilo25.zulu_xray, five_kilo25.uniform_quebec, five_kilo25.quebec_golf, five_kilo25.zulu_sierra_romeo, five_kilo25.seven_alpha_india, five_kilo25.delta_victor, five_kilo25.sierra_xray, five_kilo25.zulu_zulu_whiskey, five_kilo25.hotel_golf, five_kilo25.sierra_alpha, five_kilo25.six_bravo_golf, five_kilo25.charlie_papa_tango, five_kilo25.uniform_xray, five_kilo25.sierra_mike, five_kilo25.five_lima, five_kilo25.two_quebec, five_kilo25.three_xray, five_kilo25.charlie_papa_four
  • Index Cond: ((five_kilo25.tango_india = three_hotel.tango_india) AND (five_kilo25.uniform_quebec = 2))
  • Filter: ((five_kilo25.quebec_golf five_romeo NULL) AND (five_kilo25.hotel_echo five_romeo NOT NULL) AND (five_kilo25.oscar_seven_tango <> 'november_golf'::numeric) AND (five_kilo25.sierra_mike = 1))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=6885
268. 3.688 84.363 ↑ 1.0 1 461

Nested Loop Left Join (cost=46.230..46.370 rows=1 width=296) (actual time=0.182..0.183 rows=1 loops=461)

  • Output: NULL::bigint, (((((five_hotel(oscar_mike3.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * ('four_uniform'::numeric - three_hotel.seven_five)), (((((five_hotel(oscar_mike4.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * ('four_uniform'::numeric - three_hotel.seven_five)), (((((five_hotel(oscar_mike3.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * three_hotel.seven_five), (((((five_hotel(oscar_mike4.tango_sierra_three)) * five_kilo26.oscar_seven_tango) / lima_four(five_kilo26.yankee_two, 'november_golf'::numeric)) * (three_hotel.xray_victor / ((five_kilo25.oscar_seven_tango / five_hotel(five_kilo25.oscar_seven_tango) zulu_quebec (?))))) * three_hotel.seven_five), NULL::numeric, NULL::numeric, NULL::numeric, NULL::numeric, NULL::text
  • Buffers: shared hit=16876
269.          

CTE november_romeo_kilo

270. 16.135 16.135 ↑ 1.0 1 461

Index Scan using five_mike on five_victor_echo xray_xray (cost=0.440..2.480 rows=1 width=64) (actual time=0.035..0.035 rows=1 loops=461)

  • Output: xray_juliet7.india_uniform, xray_juliet7.uniform_quebec, xray_juliet7.tango_india, xray_juliet7.sierra_mike, xray_juliet7.oscar_seven_tango, two_lima((xray_juliet7.tango_india)::character varying, xray_juliet7.sierra_mike, 'sierra_tango'::date)
  • Index Cond: (xray_juliet7.india_uniform = $114)
  • Buffers: shared hit=4193
271. 0.461 80.675 ↑ 1.0 1 461

Nested Loop Left Join (cost=43.750..43.800 rows=1 width=64) (actual time=0.175..0.175 rows=1 loops=461)

  • Output: (five_hotel(oscar_mike3.tango_sierra_three)), (five_hotel(oscar_mike4.tango_sierra_three))
  • Buffers: shared hit=16876
272. 1.383 73.760 ↑ 1.0 1 461

Aggregate (cost=32.570..32.580 rows=1 width=96) (actual time=0.160..0.160 rows=1 loops=461)

  • Output: five_hotel(oscar_mike3.tango_sierra_three), NULL::numeric, NULL::numeric
  • Buffers: shared hit=15330
273. 2.187 72.377 ↑ 2.0 6 461

Nested Loop (cost=0.720..32.540 rows=12 width=4) (actual time=0.054..0.157 rows=6 loops=461)

  • Output: oscar_mike3.tango_sierra_three
  • Buffers: shared hit=15330
274. 1.383 24.894 ↑ 1.0 6 461

Nested Loop (cost=0.430..30.210 rows=6 width=12) (actual time=0.048..0.054 rows=6 loops=461)

  • Output: oscar_mike3.tango_sierra_three, oscar_mike3.xray_sierra, five_kilo27.sierra_mike
  • Buffers: shared hit=6837
275. 17.057 17.057 ↑ 1.0 1 461

CTE Scan on november_romeo_kilo zulu_charlie (cost=0.000..0.020 rows=1 width=36) (actual time=0.036..0.037 rows=1 loops=461)

  • Output: five_kilo27.india_uniform, five_kilo27.uniform_quebec, five_kilo27.tango_india, five_kilo27.sierra_mike, five_kilo27.oscar_seven_tango, five_kilo27.yankee_two
  • Buffers: shared hit=4193
276. 6.454 6.454 ↑ 1.0 6 461

Index Scan using three_four_hotel on whiskey_kilo papa_sierra (cost=0.430..30.130 rows=6 width=23) (actual time=0.010..0.014 rows=6 loops=461)

  • Output: oscar_mike3.india_uniform, oscar_mike3.yankee_whiskey, oscar_mike3.six_juliet_quebec, oscar_mike3.mike_zulu, oscar_mike3.sierra_mike, oscar_mike3.three_xray, oscar_mike3.xray_sierra, oscar_mike3.tango_sierra_three, oscar_mike3.foxtrot_romeo_quebec
  • Index Cond: (oscar_mike3.six_juliet_quebec = five_kilo27.tango_india)
  • Filter: ((five_kilo27.sierra_mike = oscar_mike3.sierra_mike) AND (quebec_juliet(oscar_mike3.tango_sierra_three) < 'papa_india_india'::numeric))
  • Buffers: shared hit=2644
277. 2.831 45.296 ↑ 2.0 1 2,831

Append (cost=0.280..0.370 rows=2 width=0) (actual time=0.015..0.016 rows=1 loops=2,831)

  • Buffers: shared hit=8493
278. 0.000 42.465 ↑ 1.0 1 2,831

Subquery Scan on lima_sierra_hotel (cost=0.280..0.340 rows=1 width=0) (actual time=0.015..0.015 rows=1 loops=2,831)

  • Buffers: shared hit=8493
279. 0.000 42.465 ↑ 1.0 1 2,831

Result (cost=0.280..0.330 rows=1 width=32) (actual time=0.015..0.015 rows=1 loops=2,831)

  • Output: NULL::numeric
  • One-Time Filter: (five_kilo27.sierra_mike <> 0)
  • Buffers: shared hit=8493
280. 2.831 42.465 ↑ 1.0 1 2,831

Limit (cost=0.280..0.310 rows=1 width=36) (actual time=0.014..0.015 rows=1 loops=2,831)

  • Output: NULL::numeric, six_alpha4.uniform_uniform_lima
  • Buffers: shared hit=8493
281. 39.634 39.634 ↑ 1,523.0 1 2,831

Index Only Scan Backward using hotel_yankee on charlie_quebec_two seven_hotel (cost=0.280..48.850 rows=1,523 width=36) (actual time=0.014..0.014 rows=1 loops=2,831)

  • Output: NULL::numeric, six_alpha4.uniform_uniform_lima
  • Index Cond: ((six_alpha4.uniform_uniform_lima <= oscar_mike3.xray_sierra) AND (six_alpha4.uniform_uniform_lima five_romeo NOT NULL))
  • Heap Fetches: 2831
  • Buffers: shared hit=8493
282. 0.000 0.000 ↓ 0.0 0 2,831

Subquery Scan on four_three_golf (cost=0.000..0.020 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=2,831)

283. 0.000 0.000 ↓ 0.0 0 2,831

Result (cost=0.000..0.010 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=2,831)

  • Output: NULL::numeric
  • One-Time Filter: (five_kilo27.sierra_mike = 0)
284. 0.922 6.454 ↑ 1.0 1 461

Aggregate (cost=11.170..11.180 rows=1 width=32) (actual time=0.013..0.014 rows=1 loops=461)

  • Output: five_hotel(oscar_mike4.tango_sierra_three)
  • Buffers: shared hit=1546
285. 0.922 5.532 ↑ 1.5 4 461

Nested Loop (cost=0.430..11.150 rows=6 width=7) (actual time=0.010..0.012 rows=4 loops=461)

  • Output: oscar_mike4.tango_sierra_three
  • Buffers: shared hit=1546
286. 0.000 0.000 ↑ 1.0 1 461

CTE Scan on november_romeo_kilo two_two_hotel (cost=0.000..0.020 rows=1 width=36) (actual time=0.000..0.000 rows=1 loops=461)

  • Output: five_kilo28.india_uniform, five_kilo28.uniform_quebec, five_kilo28.tango_india, five_kilo28.sierra_mike, five_kilo28.oscar_seven_tango, five_kilo28.yankee_two
287. 4.610 4.610 ↑ 1.5 4 461

Index Scan using two_charlie on three_tango_victor four_three_oscar (cost=0.430..11.070 rows=6 width=22) (actual time=0.009..0.010 rows=4 loops=461)

  • Output: oscar_mike4.india_uniform, oscar_mike4.tango_sierra_three, oscar_mike4.juliet_five, oscar_mike4.tango_india, oscar_mike4.sierra_mike, oscar_mike4.three_xray
  • Index Cond: (oscar_mike4.tango_india = five_kilo28.tango_india)
  • Filter: (five_kilo28.sierra_mike = oscar_mike4.sierra_mike)
  • Buffers: shared hit=1546
288. 0.000 0.000 ↑ 1.0 1 461

CTE Scan on november_romeo_kilo six_six (cost=0.000..0.020 rows=1 width=64) (actual time=0.000..0.000 rows=1 loops=461)

  • Output: five_kilo26.india_uniform, five_kilo26.uniform_quebec, five_kilo26.tango_india, five_kilo26.sierra_mike, five_kilo26.oscar_seven_tango, five_kilo26.yankee_two
289. 1.547 974.569 ↓ 16.4 574 1

Nested Loop (cost=78.550..2,837.850 rows=35 width=496) (actual time=576.099..974.569 rows=574 loops=1)

  • Output: lima_delta.two_quebec, lima_delta.charlie_papa_tango, lima_delta.papa_november, lima_delta.alpha_delta, lima_delta.uniform_quebec, lima_delta.tango_india, lima_delta.bravo_foxtrot, lima_delta.november_romeo_foxtrot, lima_delta.zulu_xray, lima_delta.foxtrot_yankee, lima_delta.yankee_hotel, lima_delta.foxtrot_romeo_five, six_bravo_mike(lima_delta.delta_seven, 4), six_bravo_mike(lima_delta.india_whiskey_zulu, 4), lima_delta.mike_seven, six_bravo_mike(lima_delta.xray_november, 2), six_bravo_mike((((lima_sierra_five(five_hotel(uniform_delta.oscar_alpha_november), 'november_golf'::numeric)) + (lima_sierra_five(five_hotel(uniform_delta.six_november), 'november_golf'::numeric))) + (lima_sierra_five(five_hotel(uniform_delta.alpha_whiskey), 'november_golf'::numeric))), 2), six_bravo_mike((((lima_sierra_five(five_hotel(uniform_delta.quebec_papa), 'november_golf'::numeric)) + (lima_sierra_five(five_hotel(uniform_delta.romeo_tango), 'november_golf'::numeric))) + (lima_sierra_five(five_hotel(uniform_delta.lima_juliet_alpha), 'november_golf'::numeric))), 2), six_bravo_mike(((lima_sierra_five(five_hotel(uniform_delta.six_november), 'november_golf'::numeric)) + (lima_sierra_five(five_hotel(uniform_delta.alpha_whiskey), 'november_golf'::numeric))), 2)
  • Buffers: shared hit=160573
290. 2.962 2.962 ↓ 16.4 574 1

CTE Scan on four_bravo_tango lima_delta (cost=0.000..86.680 rows=35 width=416) (actual time=2.568..2.962 rows=574 loops=1)

  • Output: lima_delta.two_quebec, lima_delta.quebec_charlie, lima_delta.papa_november, lima_delta.alpha_delta, lima_delta.uniform_quebec, lima_delta.tango_india, lima_delta.zulu_xray, lima_delta.foxtrot_yankee, lima_delta.yankee_hotel, lima_delta.foxtrot_romeo_five, lima_delta.mike_seven, lima_delta.november_romeo_foxtrot, lima_delta.bravo_foxtrot, lima_delta.delta_seven, lima_delta.india_whiskey_zulu, lima_delta.oscar_alpha_november, lima_delta.six_november, lima_delta.alpha_whiskey, lima_delta.quebec_papa, lima_delta.romeo_tango, lima_delta.lima_juliet_alpha, lima_delta.xray_november, lima_delta.charlie_papa_tango
  • Filter: ((lima_delta.uniform_quebec = 2) OR (lima_delta.uniform_quebec = 6))
  • Rows Removed by Filter: 1021
  • Buffers: shared hit=275
291. 4.592 970.060 ↑ 1.0 1 574

Aggregate (cost=78.550..78.560 rows=1 width=192) (actual time=1.690..1.690 rows=1 loops=574)

  • Output: lima_sierra_five(five_hotel(uniform_delta.oscar_alpha_november), 'november_golf'::numeric), lima_sierra_five(five_hotel(uniform_delta.six_november), 'november_golf'::numeric), lima_sierra_five(five_hotel(uniform_delta.alpha_whiskey), 'november_golf'::numeric), lima_sierra_five(five_hotel(uniform_delta.quebec_papa), 'november_golf'::numeric), lima_sierra_five(five_hotel(uniform_delta.romeo_tango), 'november_golf'::numeric), lima_sierra_five(five_hotel(uniform_delta.lima_juliet_alpha), 'november_golf'::numeric)
  • Buffers: shared hit=160298
292. 965.468 965.468 ↑ 5.0 7 574

CTE Scan on four_bravo_tango uniform_delta (cost=0.000..78.010 rows=35 width=192) (actual time=0.299..1.682 rows=7 loops=574)

  • Output: uniform_delta.two_quebec, uniform_delta.quebec_charlie, uniform_delta.papa_november, uniform_delta.alpha_delta, uniform_delta.uniform_quebec, uniform_delta.tango_india, uniform_delta.zulu_xray, uniform_delta.foxtrot_yankee, uniform_delta.yankee_hotel, uniform_delta.foxtrot_romeo_five, uniform_delta.mike_seven, uniform_delta.november_romeo_foxtrot, uniform_delta.bravo_foxtrot, uniform_delta.delta_seven, uniform_delta.india_whiskey_zulu, uniform_delta.oscar_alpha_november, uniform_delta.six_november, uniform_delta.alpha_whiskey, uniform_delta.quebec_papa, uniform_delta.romeo_tango, uniform_delta.lima_juliet_alpha, uniform_delta.xray_november, uniform_delta.charlie_papa_tango
  • Filter: (uniform_delta.mike_seven && ARRAY[lima_delta.quebec_charlie])
  • Rows Removed by Filter: 1588
  • Buffers: shared hit=160298
293. 2.023 2.023 ↑ 3.4 1,021 1

CTE Scan on four_bravo_tango three_kilo (cost=0.000..181.060 rows=3,432 width=496) (actual time=0.036..2.023 rows=1,021 loops=1)

  • Output: six_alpha1.two_quebec, six_alpha1.charlie_papa_tango, six_alpha1.papa_november, six_alpha1.alpha_delta, six_alpha1.uniform_quebec, six_alpha1.tango_india, six_alpha1.bravo_foxtrot, six_alpha1.november_romeo_foxtrot, six_alpha1.zulu_xray, six_alpha1.foxtrot_yankee, six_alpha1.yankee_hotel, six_alpha1.foxtrot_romeo_five, six_bravo_mike(six_alpha1.delta_seven, 4), six_bravo_mike(six_alpha1.india_whiskey_zulu, 4), six_alpha1.mike_seven, six_bravo_mike(six_alpha1.xray_november, 2), six_bravo_mike(((lima_sierra_five(six_alpha1.oscar_alpha_november, 'november_golf'::numeric) + lima_sierra_five(six_alpha1.six_november, 'november_golf'::numeric)) + lima_sierra_five(six_alpha1.alpha_whiskey, 'november_golf'::numeric)), 2), six_bravo_mike(((lima_sierra_five(six_alpha1.quebec_papa, 'november_golf'::numeric) + lima_sierra_five(six_alpha1.romeo_tango, 'november_golf'::numeric)) + lima_sierra_five(six_alpha1.lima_juliet_alpha, 'november_golf'::numeric)), 2), six_bravo_mike((lima_sierra_five(six_alpha1.six_november, 'november_golf'::numeric) + lima_sierra_five(six_alpha1.alpha_whiskey, 'november_golf'::numeric)), 2)
  • Filter: ((six_alpha1.uniform_quebec <> 2) AND (six_alpha1.uniform_quebec <> 6))
  • Rows Removed by Filter: 574
Planning time : 33.735 ms