explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NHVY

Settings

Optimization(s) for this plan:

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

GroupAggregate (cost=82,387.47..82,404.90 rows=155 width=434) (actual rows= loops=)

  • Group Key: five_seven2020kilo_oscar05.two_tango, yankee_uniform.six_six, kilo_quebec.quebec_india_alpha, kilo_quebec.zulu_whiskey, (uniform_bravo((hotel_two.six_four)::text)), hotel_two.xray_papa, hotel_two.tango_whiskey, kilo_quebec.mike_juliet_charlie, kilo_quebec.oscar_lima_three, kilo_quebec.quebec_india_sierra, (oscar_lima_five((five_seven2020kilo_oscar05.delta_delta)::text, 1, 6)), (hotel_delta((five_seven2020kilo_oscar05.kilo_zulu)::text, 'papa_uniform'::text)), (hotel_delta((five_seven2020kilo_oscar05.victor_two_sierra)::text, 'papa_uniform'::text)), (hotel_delta((five_seven2020kilo_oscar05.five_zulu)::text, 'papa_uniform'::text)), kilo_quebec.victor_two_foxtrot, kilo_quebec.echo_sierra, four_india.alpha_golf, golf_quebec.six_uniform, five_seven2020kilo_oscar05.five_bravo, alpha_delta_golf.alpha_six, foxtrot_papa2.alpha_six, four_india.sierra_juliet, kilo_quebec.zulu_juliet
2. 0.000 0.000 ↓ 0.0

Sort (cost=82,387.47..82,387.85 rows=155 width=363) (actual rows= loops=)

  • Sort Key: five_seven2020kilo_oscar05.two_tango, kilo_quebec.quebec_india_alpha, kilo_quebec.zulu_whiskey, (uniform_bravo((hotel_two.six_four)::text)), hotel_two.xray_papa, kilo_quebec.mike_juliet_charlie, kilo_quebec.oscar_lima_three, kilo_quebec.quebec_india_sierra, (oscar_lima_five((five_seven2020kilo_oscar05.delta_delta)::text, 1, 6)), (hotel_delta((five_seven2020kilo_oscar05.kilo_zulu)::text, 'papa_uniform'::text)), (hotel_delta((five_seven2020kilo_oscar05.victor_two_sierra)::text, 'papa_uniform'::text)), (hotel_delta((five_seven2020kilo_oscar05.five_zulu)::text, 'papa_uniform'::text)), kilo_quebec.victor_two_foxtrot, kilo_quebec.echo_sierra, four_india.alpha_golf, golf_quebec.six_uniform, alpha_delta_golf.alpha_six, foxtrot_papa2.alpha_six, four_india.sierra_juliet, kilo_quebec.zulu_juliet
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,775.18..82,381.83 rows=155 width=363) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10,774.75..82,039.20 rows=24 width=233) (actual rows= loops=)

  • Join Filter: (five_seven2020kilo_oscar05.november_sierra = alpha_delta_golf.november_sierra)
5. 0.000 0.000 ↓ 0.0

Append (cost=5,320.42..5,648.35 rows=859 width=256) (actual rows= loops=)

6.          

CTE alpha_delta_golf

7. 0.000 0.000 ↓ 0.0

Append (cost=0.00..5,320.42 rows=3,756 width=356) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Subquery Scan on victor_victor (cost=0.00..141.66 rows=856 width=86) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray romeo_oscar_yankee (cost=0.00..130.96 rows=856 width=82) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
10. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike3.mike_tango = lima_bravo1.lima_victor)
11. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray zulu_romeo (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
12. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray hotel_alpha (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: (((juliet_xray)::text = 'xray_three'::text) AND (uniform_seven = 'uniform_five'::bpchar))
14. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike4.mike_tango = lima_bravo1kilo_oscar1.lima_victor)
15. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray india_alpha (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
16. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar1.mike_tango = lima_bravo2.lima_victor)
18. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray echo_two (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
19. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray foxtrot_mike (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
21. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike5.mike_tango = lima_bravo1kilo_oscar2.lima_victor)
22. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray delta_victor (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
23. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar2.mike_tango = lima_bravo2kilo_oscar1.lima_victor)
25. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray delta_yankee (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
26. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar1.mike_tango = lima_bravo3.lima_victor)
28. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray november_alpha (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
29. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray four_zulu (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
31. 0.000 0.000 ↓ 0.0

Hash Join (cost=595.51..736.86 rows=397 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike6.mike_tango = lima_bravo1kilo_oscar3.lima_victor)
32. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray victor_two_six (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
33. 0.000 0.000 ↓ 0.0

Hash (cost=589.77..589.77 rows=459 width=53) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar3.mike_tango = lima_bravo2kilo_oscar2.lima_victor)
35. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray mike_alpha (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
36. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar2.mike_tango = lima_bravo3kilo_oscar1.lima_victor)
38. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray oscar_golf (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
39. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo3kilo_oscar1.mike_tango = lima_bravo4.lima_victor)
41. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray four_juliet (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
42. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray bravo_six (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
44. 0.000 0.000 ↓ 0.0

Hash Join (cost=741.82..881.58 rows=344 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike7.mike_tango = lima_bravo1kilo_oscar4.lima_victor)
45. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray four_alpha (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
46. 0.000 0.000 ↓ 0.0

Hash (cost=736.86..736.86 rows=397 width=53) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Hash Join (cost=595.51..736.86 rows=397 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar4.mike_tango = lima_bravo2kilo_oscar3.lima_victor)
48. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray romeo_zulu (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
49. 0.000 0.000 ↓ 0.0

Hash (cost=589.77..589.77 rows=459 width=53) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar3.mike_tango = lima_bravo3kilo_oscar2.lima_victor)
51. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray four_mike (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
52. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo3kilo_oscar2.mike_tango = lima_bravo4kilo_oscar1.lima_victor)
54. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray oscar_alpha (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
55. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo4kilo_oscar1.mike_tango = lima_bravo5.lima_victor)
57. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray delta_november (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
58. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray bravo_delta (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
60. 0.000 0.000 ↓ 0.0

Hash Join (cost=885.88..1,025.17 rows=298 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike8.mike_tango = lima_bravo1kilo_oscar5.lima_victor)
61. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray yankee_delta (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
62. 0.000 0.000 ↓ 0.0

Hash (cost=881.58..881.58 rows=344 width=53) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Hash Join (cost=741.82..881.58 rows=344 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar5.mike_tango = lima_bravo2kilo_oscar4.lima_victor)
64. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray three_victor (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
65. 0.000 0.000 ↓ 0.0

Hash (cost=736.86..736.86 rows=397 width=53) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Hash Join (cost=595.51..736.86 rows=397 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar4.mike_tango = lima_bravo3kilo_oscar3.lima_victor)
67. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray delta_six (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
68. 0.000 0.000 ↓ 0.0

Hash (cost=589.77..589.77 rows=459 width=53) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo3kilo_oscar3.mike_tango = lima_bravo4kilo_oscar2.lima_victor)
70. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray three_november (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
71. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo4kilo_oscar2.mike_tango = lima_bravo5kilo_oscar1.lima_victor)
73. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray tango_sierra (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
74. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo5kilo_oscar1.mike_tango = lima_bravo6.lima_victor)
76. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray three_romeo (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
77. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray lima_papa (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
79. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,028.89..1,166.72 rows=258 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike9.mike_tango = lima_bravo1kilo_oscar6.lima_victor)
80. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray romeo_oscar_seven (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
81. 0.000 0.000 ↓ 0.0

Hash (cost=1,025.17..1,025.17 rows=298 width=53) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Hash Join (cost=885.88..1,025.17 rows=298 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar6.mike_tango = lima_bravo2kilo_oscar5.lima_victor)
83. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray alpha_sierra (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
84. 0.000 0.000 ↓ 0.0

Hash (cost=881.58..881.58 rows=344 width=53) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Hash Join (cost=741.82..881.58 rows=344 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar5.mike_tango = lima_bravo3kilo_oscar4.lima_victor)
86. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray sierra_romeo (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
87. 0.000 0.000 ↓ 0.0

Hash (cost=736.86..736.86 rows=397 width=53) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Hash Join (cost=595.51..736.86 rows=397 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo3kilo_oscar4.mike_tango = lima_bravo4kilo_oscar3.lima_victor)
89. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray lima_charlie (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
90. 0.000 0.000 ↓ 0.0

Hash (cost=589.77..589.77 rows=459 width=53) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo4kilo_oscar3.mike_tango = lima_bravo5kilo_oscar2.lima_victor)
92. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray alpha_oscar (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
93. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo5kilo_oscar2.mike_tango = lima_bravo6kilo_oscar1.lima_victor)
95. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray sierra_six (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
96. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo6kilo_oscar1.mike_tango = lima_bravo7.lima_victor)
98. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray bravo_three (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
99. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray bravo_four (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
101. 0.000 0.000 ↓ 0.0

CTE Scan on alpha_delta_golf (cost=0.00..84.51 rows=19 width=356) (actual rows= loops=)

  • Filter: ((whiskey_oscar)::text = 'uniform_three'::text)
102. 0.000 0.000 ↓ 0.0

Subquery Scan on echo_uniform_mike (cost=0.00..0.00 rows=1 width=121) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=117) (actual rows= loops=)

  • One-Time Filter: false
104. 0.000 0.000 ↓ 0.0

Subquery Scan on bravo_seven (cost=0.00..0.00 rows=1 width=121) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=117) (actual rows= loops=)

  • One-Time Filter: false
106. 0.000 0.000 ↓ 0.0

Subquery Scan on four_golf (cost=84.75..238.93 rows=837 width=121) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=84.75..228.46 rows=837 width=117) (actual rows= loops=)

  • Hash Cond: (bravo_yankee.november_sierra = foxtrot_papa1.november_sierra)
108. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray bravo_yankee (cost=0.00..130.96 rows=856 width=37) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
109. 0.000 0.000 ↓ 0.0

Hash (cost=84.51..84.51 rows=19 width=8) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

CTE Scan on alpha_delta_golf november_mike (cost=0.00..84.51 rows=19 width=8) (actual rows= loops=)

  • Filter: ((whiskey_oscar)::text = 'uniform_three'::text)
111. 0.000 0.000 ↓ 0.0

Subquery Scan on uniform_papa (cost=0.00..0.00 rows=1 width=121) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=117) (actual rows= loops=)

  • One-Time Filter: false
113. 0.000 0.000 ↓ 0.0

Materialize (cost=5,454.32..76,266.32 rows=9 width=217) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5,454.32..76,266.27 rows=9 width=217) (actual rows= loops=)

  • Join Filter: (four_india.quebec_uniform = foxtrot_papa2.november_sierra)
115. 0.000 0.000 ↓ 0.0

Append (cost=5,320.42..5,648.35 rows=859 width=256) (actual rows= loops=)

116.          

CTE alpha_delta_golf

117. 0.000 0.000 ↓ 0.0

Append (cost=0.00..5,320.42 rows=3,756 width=356) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Subquery Scan on mike_echo (cost=0.00..141.66 rows=856 width=86) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray seven_yankee (cost=0.00..130.96 rows=856 width=82) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
120. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike11.mike_tango = lima_bravo1kilo_oscar7.lima_victor)
121. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray oscar_delta (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
122. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray uniform_victor (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: (((juliet_xray)::text = 'xray_three'::text) AND (uniform_seven = 'uniform_five'::bpchar))
124. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike12.mike_tango = lima_bravo1kilo_oscar8.lima_victor)
125. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray foxtrot_seven (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
126. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar8.mike_tango = lima_bravo2kilo_oscar6.lima_victor)
128. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray zulu_four (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
129. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray foxtrot_whiskey (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
131. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike13.mike_tango = lima_bravo1kilo_oscar9.lima_victor)
132. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray november_quebec (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
133. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar9.mike_tango = lima_bravo2kilo_oscar7.lima_victor)
135. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray golf_romeo (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
136. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar7.mike_tango = lima_bravo3kilo_oscar5.lima_victor)
138. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray lima_six (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
139. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray golf_hotel (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
141. 0.000 0.000 ↓ 0.0

Hash Join (cost=595.51..736.86 rows=397 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike14.mike_tango = lima_bravo1kilo_oscar10.lima_victor)
142. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray delta_alpha (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
143. 0.000 0.000 ↓ 0.0

Hash (cost=589.77..589.77 rows=459 width=53) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar10.mike_tango = lima_bravo2kilo_oscar8.lima_victor)
145. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray five_whiskey (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
146. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar8.mike_tango = lima_bravo3kilo_oscar6.lima_victor)
148. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray quebec_golf (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
149. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo3kilo_oscar6.mike_tango = lima_bravo4kilo_oscar4.lima_victor)
151. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray whiskey_delta (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
152. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray romeo_six (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
154. 0.000 0.000 ↓ 0.0

Hash Join (cost=741.82..881.58 rows=344 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike15.mike_tango = lima_bravo1kilo_oscar11.lima_victor)
155. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray charlie_six (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
156. 0.000 0.000 ↓ 0.0

Hash (cost=736.86..736.86 rows=397 width=53) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Hash Join (cost=595.51..736.86 rows=397 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar11.mike_tango = lima_bravo2kilo_oscar9.lima_victor)
158. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray four_victor (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
159. 0.000 0.000 ↓ 0.0

Hash (cost=589.77..589.77 rows=459 width=53) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar9.mike_tango = lima_bravo3kilo_oscar7.lima_victor)
161. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray victor_alpha (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
162. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo3kilo_oscar7.mike_tango = lima_bravo4kilo_oscar5.lima_victor)
164. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray zulu_lima (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
165. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo4kilo_oscar5.mike_tango = lima_bravo5kilo_oscar3.lima_victor)
167. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray papa_foxtrot (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
168. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray whiskey_india_papa (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
170. 0.000 0.000 ↓ 0.0

Hash Join (cost=885.88..1,025.17 rows=298 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike16.mike_tango = lima_bravo1kilo_oscar12.lima_victor)
171. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray hotel_foxtrot (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
172. 0.000 0.000 ↓ 0.0

Hash (cost=881.58..881.58 rows=344 width=53) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Hash Join (cost=741.82..881.58 rows=344 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar12.mike_tango = lima_bravo2kilo_oscar10.lima_victor)
174. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray mike_uniform (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
175. 0.000 0.000 ↓ 0.0

Hash (cost=736.86..736.86 rows=397 width=53) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Hash Join (cost=595.51..736.86 rows=397 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar10.mike_tango = lima_bravo3kilo_oscar8.lima_victor)
177. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray papa_seven (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
178. 0.000 0.000 ↓ 0.0

Hash (cost=589.77..589.77 rows=459 width=53) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo3kilo_oscar8.mike_tango = lima_bravo4kilo_oscar6.lima_victor)
180. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray seven_six (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
181. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo4kilo_oscar6.mike_tango = lima_bravo5kilo_oscar4.lima_victor)
183. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray three_bravo (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
184. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo5kilo_oscar4.mike_tango = lima_bravo6kilo_oscar2.lima_victor)
186. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray india_mike (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
187. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

188. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray seven_papa (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
189. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,028.89..1,166.72 rows=258 width=86) (actual rows= loops=)

  • Hash Cond: (oscar_mike17.mike_tango = lima_bravo1kilo_oscar13.lima_victor)
190. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray alpha_two (cost=0.00..130.96 rows=856 width=45) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
191. 0.000 0.000 ↓ 0.0

Hash (cost=1,025.17..1,025.17 rows=298 width=53) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Hash Join (cost=885.88..1,025.17 rows=298 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo1kilo_oscar13.mike_tango = lima_bravo2kilo_oscar11.lima_victor)
193. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray quebec_two (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
194. 0.000 0.000 ↓ 0.0

Hash (cost=881.58..881.58 rows=344 width=53) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Hash Join (cost=741.82..881.58 rows=344 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo2kilo_oscar11.mike_tango = lima_bravo3kilo_oscar9.lima_victor)
196. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray seven_two (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
197. 0.000 0.000 ↓ 0.0

Hash (cost=736.86..736.86 rows=397 width=53) (actual rows= loops=)

198. 0.000 0.000 ↓ 0.0

Hash Join (cost=595.51..736.86 rows=397 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo3kilo_oscar9.mike_tango = lima_bravo4kilo_oscar7.lima_victor)
199. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray sierra_hotel (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
200. 0.000 0.000 ↓ 0.0

Hash (cost=589.77..589.77 rows=459 width=53) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Hash Join (cost=447.79..589.77 rows=459 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo4kilo_oscar7.mike_tango = lima_bravo5kilo_oscar5.lima_victor)
202. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray juliet_india (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
203. 0.000 0.000 ↓ 0.0

Hash (cost=441.15..441.15 rows=531 width=53) (actual rows= loops=)

204. 0.000 0.000 ↓ 0.0

Hash Join (cost=297.39..441.15 rows=531 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo5kilo_oscar5.mike_tango = lima_bravo6kilo_oscar3.lima_victor)
205. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray bravo_whiskey (cost=0.00..130.96 rows=856 width=16) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
206. 0.000 0.000 ↓ 0.0

Hash (cost=289.73..289.73 rows=613 width=53) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

Hash Join (cost=143.00..289.73 rows=613 width=53) (actual rows= loops=)

  • Hash Cond: (lima_bravo6kilo_oscar3.mike_tango = lima_bravo7kilo_oscar1.lima_victor)
208. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray romeo_foxtrot (cost=0.00..130.96 rows=856 width=24) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
209. 0.000 0.000 ↓ 0.0

Hash (cost=134.16..134.16 rows=708 width=45) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray whiskey_hotel (cost=0.00..134.16 rows=708 width=45) (actual rows= loops=)

  • Filter: ((uniform_seven = 'uniform_five'::bpchar) AND ((juliet_xray)::text = 'xray_three'::text))
211. 0.000 0.000 ↓ 0.0

CTE Scan on alpha_delta_golf victor_golf (cost=0.00..84.51 rows=19 width=356) (actual rows= loops=)

  • Filter: ((whiskey_oscar)::text = 'uniform_three'::text)
212. 0.000 0.000 ↓ 0.0

Subquery Scan on bravo_alpha (cost=0.00..0.00 rows=1 width=121) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=117) (actual rows= loops=)

  • One-Time Filter: false
214. 0.000 0.000 ↓ 0.0

Subquery Scan on bravo_bravo (cost=0.00..0.00 rows=1 width=121) (actual rows= loops=)

215. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=117) (actual rows= loops=)

  • One-Time Filter: false
216. 0.000 0.000 ↓ 0.0

Subquery Scan on alpha_delta_five (cost=84.75..238.93 rows=837 width=121) (actual rows= loops=)

217. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=84.75..228.46 rows=837 width=117) (actual rows= loops=)

  • Hash Cond: (oscar_mike1.november_sierra = foxtrot_papa3.november_sierra)
218. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray mike_juliet_quebec (cost=0.00..130.96 rows=856 width=37) (actual rows= loops=)

  • Filter: (uniform_seven = 'uniform_five'::bpchar)
219. 0.000 0.000 ↓ 0.0

Hash (cost=84.51..84.51 rows=19 width=8) (actual rows= loops=)

220. 0.000 0.000 ↓ 0.0

CTE Scan on alpha_delta_golf whiskey_india_golf (cost=0.00..84.51 rows=19 width=8) (actual rows= loops=)

  • Filter: ((whiskey_oscar)::text = 'uniform_three'::text)
221. 0.000 0.000 ↓ 0.0

Subquery Scan on india_quebec (cost=0.00..0.00 rows=1 width=121) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.00 rows=0 width=117) (actual rows= loops=)

  • One-Time Filter: false
223. 0.000 0.000 ↓ 0.0

Materialize (cost=133.90..70,557.80 rows=4 width=193) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Nested Loop (cost=133.90..70,557.78 rows=4 width=193) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Nested Loop (cost=133.61..70,529.51 rows=15 width=186) (actual rows= loops=)

226. 0.000 0.000 ↓ 0.0

Hash Join (cost=133.18..70,431.98 rows=48 width=143) (actual rows= loops=)

  • Hash Cond: (five_seven2020kilo_oscar05.sierra_charlie = hotel_two.sierra_charlie)
  • Join Filter: ((five_seven2020kilo_oscar05.five_bravo >= hotel_two.kilo_mike) AND (five_seven2020kilo_oscar05.five_bravo < hotel_two.seven_three))
227. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.57..70,229.18 rows=962 width=115) (actual rows= loops=)

228. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_xray yankee_uniform (cost=0.00..130.96 rows=1 width=34) (actual rows= loops=)

  • Filter: ((six_six)::text = 'kilo_five'::text)
229. 0.000 0.000 ↓ 0.0

Append (cost=0.57..70,071.87 rows=2,635 width=97) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

Index Scan using seven_lima on zulu_three (cost=0.57..70,058.69 rows=2,635 width=97) (actual rows= loops=)

  • Index Cond: ((five_bravo >= yankee_uniform.kilo_mike) AND (five_bravo < yankee_uniform.seven_three) AND (five_bravo = 'mike_hotel'::date))
  • Filter: (yankee_uniform.november_sierra = november_sierra)
231. 0.000 0.000 ↓ 0.0

Hash (cost=129.25..129.25 rows=269 width=60) (actual rows= loops=)

232. 0.000 0.000 ↓ 0.0

Seq Scan on hotel_two (cost=1.07..129.25 rows=269 width=60) (actual rows= loops=)

  • Filter: (((tango_whiskey)::text = 'echo_uniform_four'::text) AND (((tango_whiskey)::text <> 'juliet_oscar'::text) OR (mike_mike delta_four 1)))
233.          

SubPlan (for Seq Scan)

234. 0.000 0.000 ↓ 0.0

Seq Scan on mike_charlie (cost=0.00..1.06 rows=6 width=7) (actual rows= loops=)

235. 0.000 0.000 ↓ 0.0

Index Scan using bravo_uniform on four_india (cost=0.43..2.02 rows=1 width=75) (actual rows= loops=)

  • Index Cond: ((two_tango = five_seven2020kilo_oscar05.two_tango) AND (uniform_quebec = five_seven2020kilo_oscar05.uniform_quebec) AND (five_seven2020kilo_oscar05.five_bravo >= kilo_mike))
  • Filter: (((sierra_juliet)::text <> 'sierra_bravo'::text) AND (five_seven2020kilo_oscar05.five_bravo < seven_three))
236. 0.000 0.000 ↓ 0.0

Index Scan using november_yankee on golf_quebec (cost=0.29..1.88 rows=1 width=39) (actual rows= loops=)

  • Index Cond: ((lima_lima = four_india.charlie_india) AND (five_seven2020kilo_oscar05.five_bravo >= kilo_mike))
  • Filter: (five_seven2020kilo_oscar05.five_bravo < seven_three)
237. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot_three on kilo_quebec (cost=0.43..14.14 rows=6 width=141) (actual rows= loops=)

  • Index Cond: ((two_tango = five_seven2020kilo_oscar05.two_tango) AND (five_seven2020kilo_oscar05.five_bravo >= kilo_mike))" two_seven: (five_seven2020kilo_oscar05.five_bravo < seven_three)