explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cRh9

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

Unique (cost=1,931,799.11..1,931,799.51 rows=6 width=1,008) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=1,931,799.11..1,931,799.12 rows=6 width=1,008) (actual rows= loops=)

  • Sort Key: golf_india.quebec_seven_victor_foxtrot, golf_india.november_lima, golf_india.two_delta, golf_india.november_whiskey_delta, golf_india.tango_charlie, golf_india.yankee_echo, golf_india.golf_golf, golf_india.quebec_foxtrot_zulu, golf_india.sierra_tango_mike, golf_india.papa_uniform_tango, golf_india.five_two_delta, golf_india.alpha, golf_india.uniform_xray, golf_india.oscar_six, golf_india.november_juliet, golf_india.sierra_tango_golf, golf_india.papa_two, golf_india.sierra_uniform, golf_india.xray_victor, golf_india.seven_papa, golf_india.romeo_hotel, golf_india.bravo_zulu, golf_india.delta_zulu, golf_india.golf_two, golf_india.foxtrot_november, golf_india.victor_hotel
3. 0.000 0.000 ↓ 0.0

Merge Join (cost=246,050.25..1,931,799.03 rows=6 width=1,008) (actual rows= loops=)

  • Merge Cond: (golf_india.quebec_seven_victor_foxtrot = whiskey_xray1.quebec_seven_victor_foxtrot)
4. 0.000 0.000 ↓ 0.0

Index Scan using four_delta on golf_india (cost=87,426.75..1,773,161.36 rows=112 width=1,008) (actual rows= loops=)

  • Filter: ((NOT alpha) AND (mike_mike delta_four 1) AND (oscar_delta = 0) AND (juliet = 2) AND (NOT (delta_four 2)))
5.          

SubPlan (for Index Scan)

6. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.71..87,413.26 rows=5,284 width=12) (actual rows= loops=)

  • Group Key: whiskey_xray3.quebec_seven_victor_foxtrot
  • Filter: (five_two_papa(november_xray1.*) < whiskey_xray3.november_juliet)
7. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=0.71..86,550.07 rows=133,007 width=653) (actual rows= loops=)

  • Merge Cond: (whiskey_xray3.quebec_seven_victor_foxtrot = november_xray1.kilo_november)
8. 0.000 0.000 ↓ 0.0

Index Scan using four_delta on golf_india oscar_charlie (cost=0.29..10,909.28 rows=15,852 width=12) (actual rows= loops=)

  • Filter: (NOT alpha)
9. 0.000 0.000 ↓ 0.0

Index Scan using delta_six_five on bravo_papa kilo_oscar (cost=0.42..73,938.58 rows=133,007 width=649) (actual rows= loops=)

  • Filter: (juliet = ANY ('delta_six_four'::integer[]))
10. 0.000 0.000 ↓ 0.0

Result (cost=0.42..210.68 rows=72 width=8) (actual rows= loops=)

  • One-Time Filter: (golf_india.sierra_tango_golf = ANY ('oscar_uniform'::integer[]))
11. 0.000 0.000 ↓ 0.0

Index Scan using bravo_lima on bravo_papa bravo_victor (cost=0.42..210.68 rows=72 width=8) (actual rows= loops=)

  • Index Cond: (zulu_lima = 'foxtrot_lima'::bigint)
12. 0.000 0.000 ↓ 0.0

Unique (cost=158,623.49..158,627.45 rows=791 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Sort (cost=158,623.49..158,625.47 rows=791 width=8) (actual rows= loops=)

  • Sort Key: whiskey_xray1.quebec_seven_victor_foxtrot
14. 0.000 0.000 ↓ 0.0

Hash Join (cost=87,554.33..158,585.42 rows=791 width=8) (actual rows= loops=)

  • Hash Cond: (whiskey_xray1.uniform_xray = quebec_four.quebec_seven_victor_foxtrot)
15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=87,479.59..158,508.59 rows=794 width=16) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

HashAggregate (cost=87,479.31..87,481.31 rows=200 width=8) (actual rows= loops=)

  • Group Key: whiskey_xray2.quebec_seven_victor_foxtrot
17. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.71..87,413.26 rows=5,284 width=12) (actual rows= loops=)

  • Group Key: whiskey_xray2.quebec_seven_victor_foxtrot
  • Filter: (five_two_papa(bravo_papa.*) < whiskey_xray2.november_juliet)
18. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=0.71..86,550.07 rows=133,007 width=653) (actual rows= loops=)

  • Merge Cond: (whiskey_xray2.quebec_seven_victor_foxtrot = bravo_papa.kilo_november)
19. 0.000 0.000 ↓ 0.0

Index Scan using four_delta on golf_india five_charlie (cost=0.29..10,909.28 rows=15,852 width=12) (actual rows= loops=)

  • Filter: (NOT alpha)
20. 0.000 0.000 ↓ 0.0

Index Scan using delta_six_five on bravo_papa (cost=0.42..73,938.58 rows=133,007 width=649) (actual rows= loops=)

  • Filter: (juliet = ANY ('delta_six_four'::integer[]))
21. 0.000 0.000 ↓ 0.0

Index Scan using four_delta on golf_india tango_sierra (cost=0.29..355.13 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (quebec_seven_victor_foxtrot = whiskey_xray2.quebec_seven_victor_foxtrot)
  • Filter: ((NOT alpha) AND ((NOT (three_delta_three: delta_four 3 or mike_mike delta_four 4)) OR (three_delta_three: delta_four 5 or mike_mike delta_four 6)) AND ((NOT (three_delta_three: delta_four 19 or mike_mike delta_four 20)) OR (three_delta_three: delta_four 21 or mike_mike delta_four 22)) AND ((NOT (three_delta_three: delta_four 7 or mike_mike delta_four 8)) OR (three_delta_three: delta_four 9 or mike_mike delta_four 10)) AND ((NOT (three_delta_three: delta_four 11 or mike_mike delta_four 12)) OR (three_delta_three: delta_four 13 or mike_mike delta_four 14)) AND ((NOT (three_delta_three: delta_four 15 or mike_mike delta_four 16)) OR (three_delta_three: delta_four 17 or mike_mike delta_four 18)) AND ((NOT (three_delta_three: delta_four 23 or mike_mike delta_four 24)) OR (three_delta_three: delta_four 25 or mike_mike delta_four 26)) AND ((NOT (three_delta_three: delta_four 33 or mike_mike delta_four 34)) OR (three_delta_three: delta_four 35 or mike_mike delta_four 36)) AND ((NOT (three_delta_three: delta_four 27 or mike_mike delta_four 28)) OR (delta_four 32)))
22.          

SubPlan (for Index Scan)

23. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'quebec_tango'::text)
24. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four mike_kilo (cost=0.00..2,678.99 rows=6,182 width=8) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'quebec_tango'::text)
25. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four echo_india (cost=0.29..16.27 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: (((two_charlie)::text = 'quebec_tango'::text) AND ((whiskey_alpha)::text = 'india'::text))
26. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four echo_alpha (cost=0.00..2,908.98 rows=386 width=8) (actual rows= loops=)

  • Filter: (((two_charlie)::text = 'quebec_tango'::text) AND ((whiskey_alpha)::text = 'india'::text))
27. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four kilo_foxtrot (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'romeo_five'::text)
28. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four sierra_papa (cost=0.00..2,678.99 rows=16,388 width=8) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'romeo_five'::text)
29. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four kilo_three_victor (cost=0.29..16.27 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: (((two_charlie)::text = 'romeo_five'::text) AND ((romeo_zulu_uniform)::text = 'uniform_charlie'::text))
30. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four five_two_juliet (cost=0.00..2,908.98 rows=2,783 width=8) (actual rows= loops=)

  • Filter: (((two_charlie)::text = 'romeo_five'::text) AND ((romeo_zulu_uniform)::text = 'uniform_charlie'::text))
31. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four november_tango (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'whiskey_romeo'::text)
32. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four bravo_juliet (cost=0.00..2,678.99 rows=15,999 width=8) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'whiskey_romeo'::text)
33. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four foxtrot_golf (cost=0.29..16.29 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((kilo_bravo <= 38) AND ((quebec_foxtrot_papa five_romeo NULL) OR (quebec_foxtrot_papa >= 38)) AND ((two_charlie)::text = 'whiskey_romeo'::text))
34. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four quebec_charlie (cost=0.00..3,138.98 rows=2,367 width=8) (actual rows= loops=)

  • Filter: ((kilo_bravo <= 38) AND ((quebec_foxtrot_papa five_romeo NULL) OR (quebec_foxtrot_papa >= 38)) AND ((two_charlie)::text = 'whiskey_romeo'::text))
35. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four romeo_six_echo (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'kilo_kilo'::text)
36. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four xray_alpha (cost=0.00..2,678.99 rows=264 width=8) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'kilo_kilo'::text)
37. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four foxtrot_six (cost=0.29..16.29 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: (((two_charlie)::text = 'kilo_kilo'::text) AND ((foxtrot_romeo_kilo)::text = 'bravo_five'::text) AND ((romeo_zulu_uniform)::text = 'uniform_charlie'::text))
38. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four victor_lima (cost=0.00..3,138.98 rows=1 width=8) (actual rows= loops=)

  • Filter: (((two_charlie)::text = 'kilo_kilo'::text) AND ((foxtrot_romeo_kilo)::text = 'bravo_five'::text) AND ((romeo_zulu_uniform)::text = 'uniform_charlie'::text))
39. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four november_oscar (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'whiskey_sierra'::text)
40. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four hotel_four (cost=0.00..2,678.99 rows=3,103 width=8) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'whiskey_sierra'::text)
41. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four golf_three (cost=0.29..16.95 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: (((two_charlie)::text = 'whiskey_sierra'::text) AND ((romeo_zulu_uniform)::text = 'uniform_charlie'::text) AND (('kilo_uniform'::double precision * six_two(oscar_lima((whiskey_victor(papa_uniform_kilo((((('november_golf'::double precision - lima_seven) * 'kilo_three_five'::double precision) / 'two_five'::double precision) / 'oscar_yankee'::double precision)), 'oscar_yankee'::double precision) + (('four_uniform'::double precision * lima_papa(((lima_seven * 'kilo_three_five'::double precision) / 'two_five'::double precision))) * whiskey_victor(papa_uniform_kilo((((('november_golf'::double precision - two_kilo) * 'kilo_three_five'::double precision) / 'two_five'::double precision) / 'oscar_yankee'::double precision)), 'oscar_yankee'::double precision)))))) >= 'november_golf'::double precision) AND (('kilo_uniform'::double precision * six_two(oscar_lima((whiskey_victor(papa_uniform_kilo((((('november_golf'::double precision - lima_seven) * 'kilo_three_five'::double precision) / 'two_five'::double precision) / 'oscar_yankee'::double precision)), 'oscar_yankee'::double precision) + (('four_uniform'::double precision * lima_papa(((lima_seven * 'kilo_three_five'::double precision) / 'two_five'::double precision))) * whiskey_victor(papa_uniform_kilo((((('november_golf'::double precision - two_kilo) * 'kilo_three_five'::double precision) / 'two_five'::double precision) / 'oscar_yankee'::double precision)), 'oscar_yankee'::double precision)))))) <= (five_five)::double precision))
42. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..9,434.83 rows=59 width=8) (actual rows= loops=)

  • Workers Planned: 1
43. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on whiskey_four delta_three (cost=0.00..8,428.93 rows=35 width=8) (actual rows= loops=)

  • Filter: (((two_charlie)::text = 'whiskey_sierra'::text) AND ((romeo_zulu_uniform)::text = 'uniform_charlie'::text) AND (('kilo_uniform'::double precision * six_two(oscar_lima((whiskey_victor(papa_uniform_kilo((((('november_golf'::double precision - lima_seven) * 'kilo_three_five'::double precision) / 'two_five'::double precision) / 'oscar_yankee'::double precision)), 'oscar_yankee'::double precision) + (('four_uniform'::double precision * lima_papa(((lima_seven * 'kilo_three_five'::double precision) / 'two_five'::double precision))) * whiskey_victor(papa_uniform_kilo((((('november_golf'::double precision - two_kilo) * 'kilo_three_five'::double precision) / 'two_five'::double precision) / 'oscar_yankee'::double precision)), 'oscar_yankee'::double precision)))))) >= 'november_golf'::double precision) AND (('kilo_uniform'::double precision * six_two(oscar_lima((whiskey_victor(papa_uniform_kilo((((('november_golf'::double precision - lima_seven) * 'kilo_three_five'::double precision) / 'two_five'::double precision) / 'oscar_yankee'::double precision)), 'oscar_yankee'::double precision) + (('four_uniform'::double precision * lima_papa(((lima_seven * 'kilo_three_five'::double precision) / 'two_five'::double precision))) * whiskey_victor(papa_uniform_kilo((((('november_golf'::double precision - two_kilo) * 'kilo_three_five'::double precision) / 'two_five'::double precision) / 'oscar_yankee'::double precision)), 'oscar_yankee'::double precision)))))) <= (five_five)::double precision))
44. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four kilo_juliet (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'kilo_quebec'::text)
45. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four sierra_romeo (cost=0.00..2,678.99 rows=16,020 width=8) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'kilo_quebec'::text)
46. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..24.72 rows=1 width=0) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four victor_tango (cost=0.29..16.26 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'kilo_quebec'::text)
48. 0.000 0.000 ↓ 0.0

Index Scan using oscar_india on hotel_tango (cost=0.42..8.45 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (((mike_oscar)::text = 'quebec_xray'::text) AND (charlie_echo = seven_whiskey22.quebec_seven_victor_foxtrot))
  • Filter: (tango_romeo = ANY ('uniform_bravo'::integer[]))
49. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,951.28..10,986.34 rows=6,792 width=8) (actual rows= loops=)

  • Hash Cond: (yankee_romeo1.charlie_echo = seven_whiskey23.quebec_seven_victor_foxtrot)
50. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on hotel_tango five_kilo (cost=2,072.04..8,004.72 rows=39,003 width=4) (actual rows= loops=)

  • Recheck Cond: ((mike_oscar)::text = 'quebec_xray'::text)
  • Filter: (tango_romeo = ANY ('uniform_bravo'::integer[]))
51. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on oscar_india (cost=0.00..2,062.29 rows=66,916 width=0) (actual rows= loops=)

  • Index Cond: ((mike_oscar)::text = 'quebec_xray'::text)
52. 0.000 0.000 ↓ 0.0

Hash (cost=2,678.99..2,678.99 rows=16,020 width=16) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four tango_zulu (cost=0.00..2,678.99 rows=16,020 width=16) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'kilo_quebec'::text)
54. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four foxtrot_alpha (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'bravo_sierra'::text)
55. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four five_zulu (cost=0.00..2,678.99 rows=1 width=8) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'bravo_sierra'::text)
56. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.00..45.95 rows=1 width=0) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four five_quebec_hotel (cost=0.29..16.26 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'bravo_sierra'::text)
58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.71..29.68 rows=1 width=8) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.29..21.22 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (seven_whiskey33.romeo_zulu_alpha = tango_november.quebec_seven_victor_foxtrot)
60. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..16.91 rows=1 width=28) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Index Scan using five_november on whiskey_four mike_five (cost=0.29..8.31 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (quebec_seven_victor_foxtrot = seven_whiskey32.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'bravo_sierra'::text)
62. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_romeo_four on mike_seven (cost=0.56..8.59 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((romeo_zulu_alpha = seven_whiskey33.romeo_zulu_alpha) AND (romeo_six_bravo = 113,426))
  • Filter: (six_mike >= seven_whiskey33.seven_oscar)
63. 0.000 0.000 ↓ 0.0

Index Only Scan using whiskey_three on tango_november (cost=0.43..4.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven_victor_foxtrot = mike_seven.romeo_zulu_alpha)
64. 0.000 0.000 ↓ 0.0

Index Scan using three_delta_papa on five_quebec_papa (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven_victor_foxtrot = 113,426)
  • Filter: ((juliet = 10) AND (((two_charlie)::text <> 'hotel_seven'::text) OR (((two_charlie)::text = 'hotel_seven'::text) AND zulu_mike)))
65. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.71..2,708.67 rows=1 width=8) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four lima_bravo (cost=0.00..2,678.99 rows=1 width=16) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'bravo_sierra'::text)
67. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.71..29.68 rows=1 width=8) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.29..21.22 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (seven_whiskey35.romeo_zulu_alpha = kilo_two1.quebec_seven_victor_foxtrot)
69. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..16.91 rows=1 width=28) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Index Scan using five_november on whiskey_four papa_juliet (cost=0.29..8.31 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (quebec_seven_victor_foxtrot = seven_whiskey34.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'bravo_sierra'::text)
71. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_romeo_four on mike_seven quebec_seven_victor_echo (cost=0.56..8.59 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((romeo_zulu_alpha = seven_whiskey35.romeo_zulu_alpha) AND (romeo_six_bravo = 113,426))
  • Filter: (six_mike >= seven_whiskey35.seven_oscar)
72. 0.000 0.000 ↓ 0.0

Index Only Scan using whiskey_three on tango_november six_uniform (cost=0.43..4.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven_victor_foxtrot = seven_hotel1.romeo_zulu_alpha)
73. 0.000 0.000 ↓ 0.0

Index Scan using three_delta_papa on five_quebec_papa delta_delta (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven_victor_foxtrot = 113,426)
  • Filter: ((juliet = 10) AND (((two_charlie)::text <> 'hotel_seven'::text) OR (((two_charlie)::text = 'hotel_seven'::text) AND zulu_mike)))
74. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four four_echo (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'three_charlie'::text)
75. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_four six_hotel (cost=0.00..2,678.99 rows=16,097 width=8) (actual rows= loops=)

  • Filter: ((two_charlie)::text = 'three_charlie'::text)
76. 0.000 0.000 ↓ 0.0

Result (cost=49.10..65.08 rows=1 width=0) (actual rows= loops=)

  • One-Time Filter: (((NOT $32) OR $33) AND (NOT $34))
77.          

Initplan (for Result)

78. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four yankee_uniform (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'four_four'::text)
79. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four papa_zulu (cost=0.29..16.29 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((delta_echo <= 3,978) AND ((hotel_three five_romeo NULL) OR (hotel_three >= 3,978)) AND ((two_charlie)::text = 'four_four'::text))
80. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four whiskey_kilo (cost=0.29..16.26 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: ((two_charlie)::text = 'november_whiskey_uniform'::text)
81. 0.000 0.000 ↓ 0.0

Index Scan using hotel_quebec on whiskey_four charlie_mike (cost=49.10..65.08 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_november = whiskey_xray1.quebec_seven_victor_foxtrot)
  • Filter: (((yankee_echo)::text ~~* 'five_hotel'::text) AND ((two_charlie)::text = 'three_charlie'::text))
82. 0.000 0.000 ↓ 0.0

Hash (cost=54.40..54.40 rows=1,627 width=4) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_four (cost=0.00..54.40 rows=1,627 width=4) (actual rows= loops=)

  • Filter: ((NOT alpha) AND (quebec_seven_victor_foxtrot <> november_november ('uniform_quebec'::integer[])))