explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8A8n

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

GroupAggregate (cost=1,346,738.380..1,346,743.210 rows=5 width=389) (actual rows= loops=)

  • Group Key: tango_juliet.foxtrot_lima, tango_juliet.two_three_india, tango_juliet.three_three, tango_juliet.foxtrot_foxtrot, tango_juliet.charlie_hotel, tango_juliet.juliet_oscar, tango_juliet.oscar_mike_alpha, (five_echo_tango(tango_juliet.india_two)), tango_juliet.four_whiskey_oscar
  • Functions: 498
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Sort (cost=1,346,738.380..1,346,738.420 rows=14 width=553) (actual rows= loops=)

  • Sort Key: tango_juliet.foxtrot_lima, tango_juliet.two_three_india, tango_juliet.three_three, tango_juliet.foxtrot_foxtrot, tango_juliet.charlie_hotel, tango_juliet.juliet_oscar, tango_juliet.oscar_mike_alpha, (five_echo_tango(tango_juliet.india_two)), tango_juliet.four_whiskey_oscar
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=856,222.670..1,346,738.120 rows=14 width=553) (actual rows= loops=)

  • Join Filter: ((november_mike.charlie_hotel = tango_juliet.charlie_hotel) AND (november_mike.four_whiskey_oscar = tango_juliet.four_whiskey_oscar))
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=856,222.110..916,688.740 rows=14 width=549) (actual rows= loops=)

  • Hash Cond: ((tango_juliet.charlie_hotel = delta_yankee_seven.charlie_hotel) AND (tango_juliet.four_whiskey_oscar = delta_yankee_seven.four_whiskey_oscar))
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=851,661.780..912,128.330 rows=14 width=541) (actual rows= loops=)

  • Join Filter: (tango_juliet.four_whiskey_oscar = 0)
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=851,661.490..904,237.110 rows=14 width=537) (actual rows= loops=)

  • Hash Cond: ((tango_juliet.charlie_hotel = xray_four_juliet.charlie_hotel) AND (tango_juliet.four_whiskey_oscar = xray_four_juliet.four_whiskey_oscar))
7. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=847,179.980..899,755.520 rows=14 width=529) (actual rows= loops=)

  • Merge Cond: (tango_juliet.four_mike_zulu = ((charlie_whiskey.six_seven #>> 'foxtrot_november'::text[])))
  • Join Filter: ((0) = tango_juliet.four_whiskey_oscar)
8. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=820,689.960..873,251.000 rows=14 width=561) (actual rows= loops=)

  • Merge Cond: (tango_juliet.four_mike_zulu = papa_golf1.juliet_seven_november)
  • Join Filter: (tango_juliet.four_whiskey_oscar = (0))
9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=583,457.190..623,037.550 rows=5 width=509) (actual rows= loops=)

  • Join Filter: ((tango_juliet.charlie_hotel = five_echo_india.charlie_hotel) AND (tango_juliet.four_whiskey_oscar = five_echo_india.four_whiskey_oscar))
10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=508,561.950..521,000.150 rows=5 width=293) (actual rows= loops=)

  • Join Filter: ((tango_juliet.charlie_hotel = lima_papa.charlie_hotel) AND (tango_juliet.four_whiskey_oscar = lima_papa.four_whiskey_oscar))
11. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=122,438.560..122,576.350 rows=5 width=285) (actual rows= loops=)

  • Merge Cond: ((tango_juliet.four_mike_zulu = zulu_sierra_four.four_mike_zulu) AND (tango_juliet.four_whiskey_oscar = zulu_sierra_four.four_whiskey_oscar))
12. 0.000 0.000 ↓ 0.0

Sort (cost=60,748.410..60,748.430 rows=5 width=277) (actual rows= loops=)

  • Sort Key: tango_juliet.four_mike_zulu, tango_juliet.four_whiskey_oscar
13. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=60,489.040..60,748.360 rows=5 width=277) (actual rows= loops=)

  • Merge Cond: (tango_juliet.charlie_hotel = uniform_quebec.india_papa)
  • Join Filter: (tango_juliet.four_whiskey_oscar = (0))
14. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=54,778.330..54,884.460 rows=5 width=269) (actual rows= loops=)

  • Merge Cond: (tango_juliet.charlie_hotel = november_yankee_papa1.india_papa)
  • Join Filter: (tango_juliet.four_whiskey_oscar = (0))
15. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=4,050.910..4,068.680 rows=5 width=261) (actual rows= loops=)

  • Merge Cond: ((tango_juliet.charlie_hotel = xray_four_three.charlie_hotel) AND (tango_juliet.four_whiskey_oscar = xray_four_three.four_whiskey_oscar))
16. 0.000 0.000 ↓ 0.0

Sort (cost=308.750..308.770 rows=5 width=213) (actual rows= loops=)

  • Sort Key: tango_juliet.charlie_hotel, tango_juliet.four_whiskey_oscar
17. 0.000 0.000 ↓ 0.0

Subquery Scan on tango_juliet (cost=267.350..308.700 rows=5 width=213) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash Join (cost=267.350..308.650 rows=5 width=213) (actual rows= loops=)

  • Hash Cond: ((five_zulu() zulu_quebec (?)) = (five_zulu() zulu_quebec (?)))
19. 0.000 0.000 ↓ 0.0

WindowAgg (cost=59.850..87.350 rows=1,000 width=24) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Sort (cost=59.850..62.350 rows=1,000 width=8) (actual rows= loops=)

  • Sort Key: xray_yankee.xray_yankee
21. 0.000 0.000 ↓ 0.0

Function Scan on xray_yankee (cost=0.020..10.020 rows=1,000 width=8) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash (cost=207.490..207.490 rows=1 width=213) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7.410..207.490 rows=1 width=213) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=7.330..207.370 rows=1 width=201) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7.060..207.060 rows=1 width=201) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.500..204.520 rows=1 width=185) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Index Scan using four_mike_oscar on juliet_victor victor_oscar (cost=0.430..2.650 rows=1 width=52) (actual rows= loops=)

  • Index Cond: (two_charlie = 'whiskey_two'::text)
  • Filter: (november_lima <> november_november ('oscar_kilo'::text[]))
28. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on yankee_zulu xray_four_alpha (cost=6.070..198.660 rows=321 width=166) (actual rows= loops=)

  • Recheck Cond: (foxtrot_lima = victor_oscar.juliet_delta)
29. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on three_bravo (cost=0.000..5.990 rows=321 width=0) (actual rows= loops=)

  • Index Cond: (foxtrot_lima = victor_oscar.juliet_delta)
30. 0.000 0.000 ↓ 0.0

Index Scan using two_victor on juliet_victor sierra_bravo (cost=0.560..2.540 rows=1 width=52) (actual rows= loops=)

  • Index Cond: (juliet_delta = echo_foxtrot1.three_three)
31. 0.000 0.000 ↓ 0.0

Index Only Scan using xray_six on bravo_four (cost=0.280..0.300 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (india_papa = echo_foxtrot1.juliet_delta)
32. 0.000 0.000 ↓ 0.0

WindowAgg (cost=0.070..0.090 rows=1 width=16) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Sort (cost=0.070..0.080 rows=1 width=4) (actual rows= loops=)

  • Sort Key: golf_november1.xray_yankee
34. 0.000 0.000 ↓ 0.0

Function Scan on xray_yankee foxtrot_xray (cost=0.050..0.060 rows=1 width=4) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Sort (cost=3,742.160..3,748.060 rows=2,362 width=87) (actual rows= loops=)

  • Sort Key: xray_four_three.charlie_hotel, xray_four_three.four_whiskey_oscar
36. 0.000 0.000 ↓ 0.0

Subquery Scan on xray_four_three (cost=3,275.970..3,609.820 rows=2,362 width=87) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=3,275.970..3,586.200 rows=2,362 width=87) (actual rows= loops=)

  • Group Key: india_quebec.india_papa, 0
38. 0.000 0.000 ↓ 0.0

Sort (cost=3,275.970..3,284.660 rows=3,474 width=61) (actual rows= loops=)

  • Sort Key: india_quebec.india_papa
39. 0.000 0.000 ↓ 0.0

Index Scan using november_five on india_quebec (cost=0.450..3,071.660 rows=3,474 width=61) (actual rows= loops=)

  • Index Cond: ((zulu_tango_xray = 'four_uniform'::text) AND (november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
40. 0.000 0.000 ↓ 0.0

Materialize (cost=50,727.420..50,808.730 rows=2,502 width=47) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=50,727.420..50,777.460 rows=2,502 width=47) (actual rows= loops=)

  • Group Key: november_yankee_papa1.india_papa, 0
42. 0.000 0.000 ↓ 0.0

Sort (cost=50,727.420..50,733.670 rows=2,502 width=39) (actual rows= loops=)

  • Sort Key: november_yankee_papa1.india_papa
43. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,385.440..50,586.200 rows=2,502 width=39) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on two_zulu two_two (cost=6,385.010..21,259.470 rows=14,119 width=80) (actual rows= loops=)

  • Recheck Cond: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone) AND (sierra_romeo < 5) AND (lima_uniform = 'india_hotel'::text))
45. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=6,385.010..6,385.010 rows=14,119 width=0) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sierra_four (cost=0.000..2,129.380 rows=85,676 width=0) (actual rows= loops=)

  • Index Cond: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone) AND (sierra_romeo < 5))
47. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hotel_india (cost=0.000..4,248.320 rows=403,879 width=0) (actual rows= loops=)

  • Index Cond: (lima_uniform = 'india_hotel'::text)
48. 0.000 0.000 ↓ 0.0

Index Scan using oscar_xray_mike on delta_four zulu_six (cost=0.430..2.070 rows=1 width=44) (actual rows= loops=)

  • Index Cond: (zulu_sierra_hotel = november_yankee_papa1.juliet_delta)
  • Filter: ((five_echo_tango(papa_five('six_uniform'::text, november_uniform)) - five_echo_tango(papa_five('six_uniform'::text, november_yankee_papa1.november_uniform))) <= 2)
49. 0.000 0.000 ↓ 0.0

Materialize (cost=5,710.700..5,853.970 rows=3,525 width=47) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,710.700..5,809.900 rows=3,525 width=47) (actual rows= loops=)

  • Group Key: uniform_quebec.india_papa, 0
51. 0.000 0.000 ↓ 0.0

Sort (cost=5,710.700..5,726.690 rows=6,395 width=39) (actual rows= loops=)

  • Sort Key: uniform_quebec.india_papa
52. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on foxtrot_echo uniform_quebec (cost=85.800..5,306.450 rows=6,395 width=39) (actual rows= loops=)

  • Recheck Cond: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
53. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on kilo_charlie (cost=0.000..84.200 rows=6,395 width=0) (actual rows= loops=)

  • Index Cond: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
54. 0.000 0.000 ↓ 0.0

Sort (cost=61,690.140..61,736.050 rows=18,365 width=48) (actual rows= loops=)

  • Sort Key: zulu_sierra_four.four_mike_zulu, zulu_sierra_four.four_whiskey_oscar
55. 0.000 0.000 ↓ 0.0

Subquery Scan on zulu_sierra_four (cost=59,821.570..60,389.470 rows=18,365 width=48) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=59,821.570..60,205.820 rows=18,365 width=48) (actual rows= loops=)

  • Group Key: juliet_victor.juliet_seven_november, 0
57. 0.000 0.000 ↓ 0.0

Sort (cost=59,821.570..59,871.720 rows=20,060 width=40) (actual rows= loops=)

  • Sort Key: juliet_victor.juliet_seven_november
58. 0.000 0.000 ↓ 0.0

Index Scan using four_mike_oscar on juliet_victor (cost=0.430..58,388.080 rows=20,060 width=40) (actual rows= loops=)

  • Index Cond: (two_charlie = 'zulu_alpha'::text)
  • Filter: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
59. 0.000 0.000 ↓ 0.0

Materialize (cost=386,123.390..398,406.800 rows=200 width=47) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Subquery Scan on lima_papa (cost=386,123.390..398,405.800 rows=200 width=47) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=386,123.390..398,403.800 rows=200 width=47) (actual rows= loops=)

  • Group Key: kilo_foxtrot.india_papa, 0
62. 0.000 0.000 ↓ 0.0

Sort (cost=386,123.390..389,192.990 rows=1,227,841 width=39) (actual rows= loops=)

  • Sort Key: kilo_foxtrot.india_papa
63. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=217,833.640..222,610.140 rows=1,227,841 width=39) (actual rows= loops=)

  • Hash Cond: (kilo_foxtrot.romeo_xray = whiskey_lima1.romeo_xray)
  • Filter: (((alpha_four(whiskey_lima1.november_uniform)) five_romeo NULL) OR ((@ ((CASE WHEN (alpha_four(tango_oscar.three_mike) <> ''::text) THEN (alpha_four(tango_oscar.three_mike))::date ELSE alpha_four(kilo_foxtrot.delta_hotel) END) - ((alpha_four(whiskey_lima1.november_uniform)))::date)) > 60))
64. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=195,658.360..199,220.690 rows=6,690 width=75) (actual rows= loops=)

  • Group Key: kilo_foxtrot.india_papa, kilo_foxtrot.romeo_xray
  • Filter: ((alpha_four(kilo_foxtrot.delta_hotel) >= papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval))) AND CASE WHEN (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) = papa_five('six_uniform'::text, zulu_golf())) THEN (alpha_four(kilo_foxtrot.delta_hotel) <= ((papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval) - 'alpha_delta'::interval)) ELSE (alpha_four(kilo_foxtrot.delta_hotel) <= ((papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval) + 'seven_oscar'::interval)) END)
65. 0.000 0.000 ↓ 0.0

Sort (cost=195,658.360..195,758.700 rows=40,139 width=79) (actual rows= loops=)

  • Sort Key: kilo_foxtrot.india_papa, kilo_foxtrot.romeo_xray
66. 0.000 0.000 ↓ 0.0

Merge Anti Join (cost=191,986.180..192,589.190 rows=40,139 width=79) (actual rows= loops=)

  • Merge Cond: (kilo_foxtrot.romeo_xray = golf_oscar_juliet1.romeo_xray)
67. 0.000 0.000 ↓ 0.0

Sort (cost=105,433.060..105,543.170 rows=44,043 width=79) (actual rows= loops=)

  • Sort Key: kilo_foxtrot.romeo_xray
68. 0.000 0.000 ↓ 0.0

Hash Join (cost=77,343.540..100,887.880 rows=44,043 width=79) (actual rows= loops=)

  • Hash Cond: (kilo_foxtrot.romeo_xray = tango_oscar.romeo_xray)
  • Join Filter: (kilo_foxtrot.november_uniform < tango_oscar.november_uniform)
69. 0.000 0.000 ↓ 0.0

Seq Scan on foxtrot_echo kilo_foxtrot (cost=0.000..12,912.500 rows=323,750 width=83) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Hash (cost=75,096.550..75,096.550 rows=105,519 width=48) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Subquery Scan on tango_oscar (cost=73,226.120..75,096.550 rows=105,519 width=48) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Unique (cost=73,226.120..74,041.360 rows=105,519 width=80) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Sort (cost=73,226.120..73,633.740 rows=163,048 width=80) (actual rows= loops=)

  • Sort Key: victor_lima.romeo_xray, victor_lima.november_uniform DESC
74. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on victor_lima (cost=5,709.790..54,866.790 rows=163,048 width=80) (actual rows= loops=)

  • Recheck Cond: ((november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval) - 'juliet_echo'::interval)) OR (november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval) - 'juliet_echo'::interval)))
  • Filter: (((three_seven = 'charlie_india_charlie'::text) AND (november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval) - 'juliet_echo'::interval))) OR (november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval) - 'juliet_echo'::interval)))
75. 0.000 0.000 ↓ 0.0

BitmapOr (cost=5,709.790..5,709.790 rows=338,480 width=0) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on juliet_seven_two (cost=0.000..2,916.680 rows=175,432 width=0) (actual rows= loops=)

  • Index Cond: (november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval) - 'juliet_echo'::interval))
77. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on juliet_seven_two (cost=0.000..2,711.600 rows=163,048 width=0) (actual rows= loops=)

  • Index Cond: (november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval) - 'juliet_echo'::interval))
78. 0.000 0.000 ↓ 0.0

Sort (cost=86,553.120..86,610.410 rows=22,917 width=44) (actual rows= loops=)

  • Sort Key: golf_oscar_juliet1.romeo_xray, golf_oscar_juliet1.november_uniform DESC
79. 0.000 0.000 ↓ 0.0

Append (cost=56,392.150..84,893.450 rows=22,917 width=44) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Unique (cost=56,392.150..56,502.720 rows=20,848 width=44) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Sort (cost=56,392.150..56,447.430 rows=22,114 width=44) (actual rows= loops=)

  • Sort Key: golf_oscar_juliet1.romeo_xray
82. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on victor_lima two_mike (cost=5,639.330..54,796.330 rows=22,114 width=44) (actual rows= loops=)

  • Recheck Cond: ((november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval) - 'juliet_echo'::interval)) OR (november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval) - 'juliet_echo'::interval)))
  • Filter: (sierra_juliet <> 'sierra_three'::text)
83. 0.000 0.000 ↓ 0.0

BitmapOr (cost=5,639.330..5,639.330 rows=338,480 width=0) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on juliet_seven_two (cost=0.000..2,916.680 rows=175,432 width=0) (actual rows= loops=)

  • Index Cond: (november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval) - 'juliet_echo'::interval))
85. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on juliet_seven_two (cost=0.000..2,711.600 rows=163,048 width=0) (actual rows= loops=)

  • Index Cond: (november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval) - 'juliet_echo'::interval))
86. 0.000 0.000 ↓ 0.0

Unique (cost=28,036.480..28,046.980 rows=2,069 width=44) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Sort (cost=28,036.480..28,041.730 rows=2,100 width=44) (actual rows= loops=)

  • Sort Key: alpha_hotel.romeo_xray
88. 0.000 0.000 ↓ 0.0

Seq Scan on alpha_hotel (cost=0.000..27,920.600 rows=2,100 width=44) (actual rows= loops=)

  • Filter: ((three_sierra_mike = 'romeo_hotel'::text) AND ((november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval) - 'juliet_echo'::interval)) OR (november_uniform > ((papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval) - 'juliet_echo'::interval))))
89. 0.000 0.000 ↓ 0.0

Hash (cost=19,853.410..19,853.410 rows=109,030 width=44) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.420..18,763.110 rows=109,030 width=44) (actual rows= loops=)

  • Group Key: whiskey_lima1.romeo_xray
91. 0.000 0.000 ↓ 0.0

Index Scan using golf_uniform on india_quebec bravo_five (cost=0.420..16,820.970 rows=170,369 width=44) (actual rows= loops=)

  • Index Cond: (zulu_tango_xray = 'four_uniform'::text)
92. 0.000 0.000 ↓ 0.0

Materialize (cost=74,895.240..101,638.070 rows=4,698 width=255) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Subquery Scan on five_echo_india (cost=74,895.240..101,614.580 rows=4,698 width=255) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=74,895.240..101,567.600 rows=4,698 width=279) (actual rows= loops=)

  • Group Key: two_zulu.india_papa, 0
95. 0.000 0.000 ↓ 0.0

Sort (cost=74,895.240..75,126.770 rows=92,610 width=127) (actual rows= loops=)

  • Sort Key: two_zulu.india_papa
96. 0.000 0.000 ↓ 0.0

Index Scan using yankee_delta on two_zulu (cost=0.460..63,731.480 rows=92,610 width=127) (actual rows= loops=)

  • Index Cond: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
97. 0.000 0.000 ↓ 0.0

Materialize (cost=237,232.770..249,908.590 rows=108,388 width=56) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=237,232.770..248,553.740 rows=108,388 width=56) (actual rows= loops=)

  • Group Key: papa_golf1.juliet_seven_november, 0
99. 0.000 0.000 ↓ 0.0

Sort (cost=237,232.770..239,280.190 rows=818,967 width=76) (actual rows= loops=)

  • Sort Key: papa_golf1.juliet_seven_november
100. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=58,144.290..114,164.300 rows=818,967 width=76) (actual rows= loops=)

  • Hash Cond: (papa_golf1.juliet_delta = zulu_tango_quebec.xray_india)
101. 0.000 0.000 ↓ 0.0

Index Scan using four_mike_oscar on juliet_victor alpha_charlie (cost=0.430..31,771.650 rows=818,967 width=72) (actual rows= loops=)

  • Index Cond: (two_charlie = 'zulu_alpha'::text)
102. 0.000 0.000 ↓ 0.0

Hash (cost=50,597.250..50,597.250 rows=371,489 width=36) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Group (cost=0.420..46,882.360 rows=371,489 width=36) (actual rows= loops=)

  • Group Key: zulu_tango_quebec.xray_india
104. 0.000 0.000 ↓ 0.0

Index Only Scan using seven_hotel on zulu_tango_quebec (cost=0.420..45,395.710 rows=594,662 width=36) (actual rows= loops=)

  • Index Cond: (papa_foxtrot = true)
105. 0.000 0.000 ↓ 0.0

Materialize (cost=26,490.020..26,503.810 rows=200 width=40) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Group (cost=26,490.020..26,501.310 rows=200 width=40) (actual rows= loops=)

  • Group Key: ((charlie_whiskey.six_seven #>> 'foxtrot_november'::text[])), 0
107. 0.000 0.000 ↓ 0.0

Sort (cost=26,490.020..26,493.620 rows=1,439 width=36) (actual rows= loops=)

  • Sort Key: ((charlie_whiskey.six_seven #>> 'foxtrot_november'::text[]))
108. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.460..26,414.540 rows=1,439 width=36) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Unique (cost=0.040..0.040 rows=2 width=32) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Sort (cost=0.040..0.040 rows=2 width=32) (actual rows= loops=)

  • Sort Key: "quebec_kilo".victor_juliet_quebec1
111. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.000..0.030 rows=2 width=32) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Append (cost=0.420..12,903.590 rows=30,186 width=615) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Index Scan using tango_delta on charlie_whiskey (cost=0.420..3.180 rows=1 width=551) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
114. 0.000 0.000 ↓ 0.0

Seq Scan on alpha_yankee_golf (cost=0.000..2.110 rows=1 width=32) (actual rows= loops=)

  • Filter: (("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text)) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
115. 0.000 0.000 ↓ 0.0

Index Scan using oscar_mike_india on golf_seven (cost=0.130..2.330 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
116. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sierra_kilo (cost=16.550..21.510 rows=3 width=1,430) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
117. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=16.550..16.550 rows=3 width=0) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tango_foxtrot (cost=0.000..7.920 rows=560 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
119. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on oscar_alpha (cost=0.000..8.250 rows=560 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
120. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on alpha_three (cost=310.280..412.350 rows=62 width=18) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
121. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=310.280..310.280 rows=62 width=0) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on alpha_mike (cost=0.000..145.740 rows=12,334 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
123. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on golf_delta (cost=0.000..161.200 rows=12,334 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
124. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on lima_zulu (cost=4.170..5.820 rows=1 width=18) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
125. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=4.170..4.170 rows=1 width=0) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mike_golf (cost=0.000..1.860 rows=63 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
127. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hotel_whiskey (cost=0.000..2.040 rows=63 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
128. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on zulu_victor (cost=173.820..228.310 rows=33 width=1,060) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
129. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=173.820..173.820 rows=33 width=0) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on six_quebec_bravo (cost=0.000..85.990 rows=6,568 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
131. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on golf_kilo (cost=0.000..85.940 rows=6,568 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
132. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on uniform_yankee (cost=11.970..15.270 rows=2 width=18) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
133. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=11.970..11.970 rows=2 width=0) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on victor_charlie (cost=0.000..5.400 rows=371 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
135. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on zulu_echo (cost=0.000..6.230 rows=371 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
136. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on india_november (cost=9.410..11.070 rows=1 width=872) (actual rows= loops=)

  • Recheck Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone) AND ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1))
137. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=9.410..9.410 rows=1 width=0) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mike_oscar (cost=0.000..4.310 rows=289 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
139. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on five_charlie (cost=0.000..4.780 rows=289 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
140. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on echo_two (cost=4.250..5.910 rows=1 width=1,307) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
141. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=4.250..4.250 rows=1 width=0) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on india_delta (cost=0.000..1.900 rows=68 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
143. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on charlie_charlie (cost=0.000..2.090 rows=68 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
144. 0.000 0.000 ↓ 0.0

Index Scan using hotel_six on mike_kilo (cost=0.170..2.400 rows=1 width=1,133) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
145. 0.000 0.000 ↓ 0.0

Index Scan using oscar_oscar on kilo_kilo (cost=0.170..2.400 rows=1 width=1,069) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
146. 0.000 0.000 ↓ 0.0

Index Scan using echo_bravo on hotel_four (cost=0.170..2.390 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
147. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on five_four (cost=54.920..73.080 rows=11 width=1,835) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
148. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=54.920..54.920 rows=11 width=0) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on five_alpha (cost=0.000..26.080 rows=2,101 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
150. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on whiskey_charlie (cost=0.000..28.060 rows=2,101 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
151. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on foxtrot_hotel (cost=3.290..4.940 rows=1 width=18) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
152. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.290..3.290 rows=1 width=0) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
154. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
155. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on victor_juliet_zulu (cost=3.170..4.830 rows=1 width=1,734) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
156. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.170..3.170 rows=1 width=0) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on quebec_yankee (cost=0.000..1.440 rows=8 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
158. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on echo_november (cost=0.000..1.490 rows=8 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
159. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on lima_quebec (cost=133.780..176.690 rows=26 width=337) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
160. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=133.780..133.780 rows=26 width=0) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on lima_xray (cost=0.000..62.840 rows=5,242 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
162. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on kilo_juliet (cost=0.000..69.370 rows=5,242 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
163. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on zulu_uniform (cost=3.490..5.140 rows=1 width=1,749) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
164. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.490..3.490 rows=1 width=0) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on whiskey_bravo (cost=0.000..1.570 rows=25 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
166. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on papa_four (cost=0.000..1.660 rows=25 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
167. 0.000 0.000 ↓ 0.0

Index Scan using delta_papa on victor_foxtrot_foxtrot (cost=0.320..1,550.330 rows=7,673 width=249) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
168. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on four_whiskey_november (cost=4.630..6.290 rows=1 width=40) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
169. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=4.630..4.630 rows=1 width=0) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on romeo_alpha (cost=0.000..2.060 rows=89 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
171. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on oscar_uniform_india (cost=0.000..2.310 rows=89 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
172. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tango_seven (cost=7.920..9.570 rows=1 width=1,389) (actual rows= loops=)

  • Recheck Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone) AND ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1))
173. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=7.920..7.920 rows=1 width=0) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on juliet_kilo (cost=0.000..3.470 rows=205 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
175. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on golf_bravo (cost=0.000..4.150 rows=205 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
176. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on whiskey_romeo (cost=12.220..15.510 rows=2 width=20) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
177. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=12.220..12.220 rows=2 width=0) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sierra_seven (cost=0.000..5.510 rows=385 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
179. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mike_alpha (cost=0.000..6.370 rows=385 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
180. 0.000 0.000 ↓ 0.0

Index Scan using papa_xray on three_five (cost=0.450..1,685.000 rows=1,514 width=1,286) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
181. 0.000 0.000 ↓ 0.0

Index Scan using india_xray on uniform_five (cost=0.300..4.780 rows=3 width=1,819) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
182. 0.000 0.000 ↓ 0.0

Index Scan using victor_delta on kilo_xray (cost=0.300..100.830 rows=339 width=1,903) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
183. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on whiskey_mike (cost=3.610..5.260 rows=1 width=1,190) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
184. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.610..3.610 rows=1 width=0) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hotel_romeo (cost=0.000..1.620 rows=32 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
186. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on sierra_oscar (cost=0.000..1.730 rows=32 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
187. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on zulu_hotel (cost=12.310..15.610 rows=2 width=1,250) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
188. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=12.310..12.310 rows=2 width=0) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hotel_seven_sierra (cost=0.000..5.540 rows=390 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
190. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on five_yankee (cost=0.000..6.420 rows=390 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
191. 0.000 0.000 ↓ 0.0

Index Scan using hotel_victor on juliet_five (cost=0.320..6,469.860 rows=15,771 width=1,791) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
192. 0.000 0.000 ↓ 0.0

Index Scan using charlie_november on two_golf (cost=0.310..1,505.100 rows=4,661 width=1,485) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
193. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on charlie_oscar (cost=3.590..5.250 rows=1 width=1,005) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
194. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.590..3.590 rows=1 width=0) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on oscar_xray_golf (cost=0.000..1.610 rows=31 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
196. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on six_foxtrot (cost=0.000..1.720 rows=31 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
197. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on lima_charlie (cost=3.120..4.770 rows=1 width=1,218) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
198. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.120..3.120 rows=1 width=0) (actual rows= loops=)

199. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on echo_whiskey_charlie (cost=0.000..1.410 rows=5 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
200. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on zulu_kilo (cost=0.000..1.450 rows=5 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
201. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on romeo_papa (cost=7.020..8.670 rows=1 width=1,358) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
202. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=7.020..7.020 rows=1 width=0) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on two_six_zulu (cost=0.000..3.130 rows=216 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
204. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on tango_papa (cost=0.000..3.580 rows=216 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
205. 0.000 0.000 ↓ 0.0

Index Scan using six_romeo on india_kilo (cost=0.170..2.400 rows=1 width=1,588) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
206. 0.000 0.000 ↓ 0.0

Index Scan using hotel_uniform on india_mike (cost=0.300..5.900 rows=4 width=842) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
207. 0.000 0.000 ↓ 0.0

Index Scan using quebec_zulu on oscar_uniform_foxtrot (cost=0.170..2.400 rows=1 width=952) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
208. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on quebec_tango (cost=42.000..53.560 rows=7 width=1,740) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
209. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=42.000..42.000 rows=7 width=0) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on india_seven (cost=0.000..20.450 rows=1,497 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
211. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on six_charlie (cost=0.000..20.920 rows=1,497 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
212. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on six_quebec_echo (cost=3.190..4.850 rows=1 width=623) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
213. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.190..3.190 rows=1 width=0) (actual rows= loops=)

214. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on november_delta (cost=0.000..1.450 rows=9 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
215. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on golf_xray_bravo (cost=0.000..1.500 rows=9 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
216. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on echo_five (cost=49.650..64.490 rows=9 width=170) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
217. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=49.650..49.650 rows=9 width=0) (actual rows= loops=)

218. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hotel_zulu_delta (cost=0.000..23.220 rows=1,866 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
219. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hotel_zulu_oscar (cost=0.000..25.710 rows=1,866 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
220. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on two_bravo (cost=3.250..4.900 rows=1 width=20) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
221. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=3.250..3.250 rows=1 width=0) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on victor_tango (cost=0.000..1.470 rows=12 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
223. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on golf_whiskey (cost=0.000..1.530 rows=12 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
224. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on three_romeo (cost=44.320..57.510 rows=8 width=59) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
225. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=44.320..44.320 rows=8 width=0) (actual rows= loops=)

226. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on hotel_seven_yankee (cost=0.000..20.800 rows=1,690 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
227. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on lima_victor (cost=0.000..22.850 rows=1,690 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
228. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on november_victor (cost=11.600..14.900 rows=2 width=898) (actual rows= loops=)

  • Recheck Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone) AND ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1))
229. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=11.600..11.600 rows=2 width=0) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on uniform_lima (cost=0.000..4.920 rows=350 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
231. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on three_sierra_lima (cost=0.000..6.340 rows=350 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
232. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on bravo_two (cost=86.660..114.650 rows=17 width=23) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
233. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=86.660..86.660 rows=17 width=0) (actual rows= loops=)

234. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on echo_whiskey_mike (cost=0.000..40.640 rows=3,455 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
235. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on golf_alpha (cost=0.000..44.900 rows=3,455 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
236. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on victor_november (cost=12.430..15.740 rows=2 width=1,413) (actual rows= loops=)

  • Recheck Cond: (((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
237. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=12.430..12.430 rows=2 width=0) (actual rows= loops=)

238. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on xray_whiskey (cost=0.000..5.600 rows=397 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
239. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on zulu_two (cost=0.000..6.490 rows=397 width=0) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
240. 0.000 0.000 ↓ 0.0

Index Scan using yankee_golf on five_victor (cost=0.140..2.350 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
241. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sierra_tango (cost=9.540..11.190 rows=1 width=1,099) (actual rows= loops=)

  • Recheck Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone) AND ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1))
242. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=9.540..9.540 rows=1 width=0) (actual rows= loops=)

243. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
244. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on golf_sierra (cost=0.000..4.830 rows=296 width=0) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
245. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_sierra on tango_uniform_uniform (cost=0.170..2.390 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
  • Filter: ("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text))
246. 0.000 0.000 ↓ 0.0

Index Scan using kilo_echo on four_hotel (cost=0.140..2.890 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
247. 0.000 0.000 ↓ 0.0

Index Scan using delta_uniform_foxtrot on bravo_november (cost=0.280..3.040 rows=1 width=682) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
248. 0.000 0.000 ↓ 0.0

Index Scan using kilo_five on six_india (cost=0.140..2.900 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
249. 0.000 0.000 ↓ 0.0

Index Scan using golf_juliet on golf_oscar_golf (cost=0.280..3.040 rows=1 width=678) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
250. 0.000 0.000 ↓ 0.0

Index Scan using juliet_juliet on delta_uniform_lima (cost=0.430..3.190 rows=1 width=293) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
251. 0.000 0.000 ↓ 0.0

Seq Scan on hotel_hotel (cost=0.000..1.550 rows=1 width=32) (actual rows= loops=)

  • Filter: (("quebec_kilo".victor_juliet_quebec1 = (six_seven ->> 'tango_whiskey'::text)) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
252. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_charlie on victor_romeo (cost=0.430..3.190 rows=1 width=638) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
253. 0.000 0.000 ↓ 0.0

Index Scan using xray_charlie on romeo_golf (cost=0.280..3.040 rows=1 width=599) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
254. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_yankee on xray_alpha (cost=0.140..2.900 rows=1 width=1,078) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
255. 0.000 0.000 ↓ 0.0

Index Scan using papa_two on foxtrot_india (cost=0.420..3.180 rows=1 width=808) (actual rows= loops=)

  • Index Cond: ((six_seven ->> 'tango_whiskey'::text) = "quebec_kilo".victor_juliet_quebec1)
  • Filter: ((golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (golf_xray_lima((six_seven ->> 'oscar_romeo'::text)) < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
256. 0.000 0.000 ↓ 0.0

Hash (cost=4,451.360..4,451.360 rows=2,010 width=47) (actual rows= loops=)

257. 0.000 0.000 ↓ 0.0

Subquery Scan on xray_four_juliet (cost=4,385.190..4,451.360 rows=2,010 width=47) (actual rows= loops=)

258. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4,385.190..4,431.260 rows=2,010 width=47) (actual rows= loops=)

  • Group Key: zulu_mike.india_papa, 0
259. 0.000 0.000 ↓ 0.0

Sort (cost=4,385.190..4,391.680 rows=2,597 width=39) (actual rows= loops=)

  • Sort Key: zulu_mike.india_papa
260. 0.000 0.000 ↓ 0.0

Index Scan using golf_golf on four_mike_uniform zulu_mike (cost=0.560..4,237.910 rows=2,597 width=39) (actual rows= loops=)

  • Index Cond: (tango_two = 'golf_lima'::text)
  • Filter: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
261. 0.000 0.000 ↓ 0.0

Index Scan using romeo_yankee on yankee_zulu mike_foxtrot (cost=0.280..563.650 rows=1 width=40) (actual rows= loops=)

  • Index Cond: (juliet_delta = tango_juliet.charlie_hotel)
262.          

SubPlan (forIndex Scan)

263. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.560..1,894.740 rows=6 width=0) (actual rows= loops=)

  • Join Filter: (charlie_india_four1.tango_two = "xray_kilo".victor_juliet_quebec1)
264. 0.000 0.000 ↓ 0.0

Index Scan using xray_juliet on four_mike_uniform alpha_yankee_juliet (cost=0.560..1,891.320 rows=75 width=14) (actual rows= loops=)

  • Index Cond: (india_papa = mike_foxtrot.juliet_delta)
  • Filter: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
265. 0.000 0.000 ↓ 0.0

Materialize (cost=0.000..0.050 rows=3 width=32) (actual rows= loops=)

266. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*_1" (cost=0.000..0.040 rows=3 width=32) (actual rows= loops=)

267. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.620..46,603.100 rows=28,006 width=35) (actual rows= loops=)

268. 0.000 0.000 ↓ 0.0

Unique (cost=0.060..0.080 rows=3 width=32) (actual rows= loops=)

269. 0.000 0.000 ↓ 0.0

Sort (cost=0.060..0.070 rows=3 width=32) (actual rows= loops=)

  • Sort Key: "delta_yankee_bravo".victor_juliet_quebec1
270. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*_2" (cost=0.000..0.040 rows=3 width=32) (actual rows= loops=)

271. 0.000 0.000 ↓ 0.0

Index Scan using golf_golf on four_mike_uniform charlie_zulu (cost=0.560..15,440.990 rows=9,335 width=49) (actual rows= loops=)

  • Index Cond: (tango_two = "delta_yankee_bravo".victor_juliet_quebec1)
  • Filter: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
272. 0.000 0.000 ↓ 0.0

Index Scan using charlie_six on juliet_victor zulu_whiskey (cost=0.560..36.150 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (juliet_seven_november = mike_foxtrot.foxtrot_romeo)
  • Filter: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
273. 0.000 0.000 ↓ 0.0

Index Scan using tango_uniform_mike on india_quebec india_charlie (cost=0.450..208.740 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone) AND (india_papa = mike_foxtrot.juliet_delta))
  • Filter: (zulu_tango_xray = 'four_uniform'::text)
274. 0.000 0.000 ↓ 0.0

Index Scan using november_five on india_quebec uniform_november (cost=0.450..3,071.660 rows=3,474 width=35) (actual rows= loops=)

  • Index Cond: ((zulu_tango_xray = 'four_uniform'::text) AND (november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
275. 0.000 0.000 ↓ 0.0

Hash (cost=4,533.910..4,533.910 rows=1,762 width=47) (actual rows= loops=)

276. 0.000 0.000 ↓ 0.0

Subquery Scan on delta_yankee_seven (cost=4,204.210..4,533.910 rows=1,762 width=47) (actual rows= loops=)

277. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4,204.210..4,516.290 rows=1,762 width=47) (actual rows= loops=)

  • Group Key: two_six_echo1.india_papa, 0
278. 0.000 0.000 ↓ 0.0

Sort (cost=4,204.210..4,246.280 rows=16,826 width=81) (actual rows= loops=)

  • Sort Key: two_six_echo1.india_papa
279. 0.000 0.000 ↓ 0.0

Index Scan using echo_seven on hotel_kilo lima_mike (cost=0.450..3,023.160 rows=16,826 width=81) (actual rows= loops=)

  • Index Cond: ((november_uniform >= (papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'two_three_victor'::interval)))::timestamp without time zone) AND (november_uniform < ((papa_five('six_uniform'::text, (papa_five('kilo_lima'::text, zulu_golf()) - 'seven_oscar'::interval)) + 'seven_oscar'::interval))::timestamp without time zone))
280. 0.000 0.000 ↓ 0.0

Materialize (cost=0.560..428,625.630 rows=5,871 width=47) (actual rows= loops=)

281. 0.000 0.000 ↓ 0.0

Subquery Scan on november_mike (cost=0.560..428,596.270 rows=5,871 width=47) (actual rows= loops=)

282. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.560..428,537.560 rows=5,871 width=47) (actual rows= loops=)

  • Group Key: november_yankee_sierra.charlie_hotel, 0
283. 0.000 0.000 ↓ 0.0

Index Only Scan using victor_foxtrot_uniform on november_yankee_sierra (cost=0.560..360,103.210 rows=9,108,924 width=47) (actual rows= loops=)