explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JVyz : test_2

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

GroupAggregate (cost=2,119,496,537,757,188,352.000..2,119,496,537,757,188,352.000 rows=200 width=126) (actual rows= loops=)

  • Group Key: quebec_three.lima_quebec
2. 0.000 0.000 ↓ 0.0

Sort (cost=2,119,496,537,757,188,352.000..2,119,496,537,757,188,352.000 rows=3,570 width=126) (actual rows= loops=)

  • Sort Key: quebec_three.lima_quebec
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,119,496,537,757,188,096.000..2,119,496,537,757,188,096.000 rows=3,570 width=126) (actual rows= loops=)

  • Group Key: quebec_three.lima_quebec, yankee_quebec_six_kilo.lima_seven
4. 0.000 0.000 ↓ 0.0

Append (cost=2,119,485,370,112,586,752.000..2,119,496,537,757,188,096.000 rows=3,570 width=126) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Unique (cost=2,119,485,370,112,586,752.000..2,119,485,370,112,586,752.000 rows=200 width=126) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Unique (cost=2,119,485,370,112,586,752.000..2,119,485,370,112,586,752.000 rows=200 width=126) (actual rows= loops=)

7.          

CTE tango_two

8. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,119,485,370,112,585,728.000..2,119,485,370,112,585,728.000 rows=19,600 width=122) (actual rows= loops=)

  • Group Key: mike_november_quebec_xray2.lima_quebec, five_oscar_delta.quebec_papa
9. 0.000 0.000 ↓ 0.0

Append (cost=2,110,808,031,137,758,464.000..2,119,485,370,112,585,728.000 rows=19,600 width=122) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,110,808,031,137,758,464.000..2,110,808,031,137,758,464.000 rows=10,000 width=19) (actual rows= loops=)

  • Group Key: mike_november_quebec_xray2.lima_quebec, five_oscar_delta.quebec_papa
11. 0.000 0.000 ↓ 0.0

Merge Join (cost=50,186,400,094,231,296.000..469,146,269,000,505,344.000 rows=328,332,352,427,450,630,144 width=19) (actual rows= loops=)

  • Merge Cond: (romeo_tango1.quebec_papa = four_zulu.charlie_uniform)
12. 0.000 0.000 ↓ 0.0

Sort (cost=3,757,406.200..3,786,811.730 rows=11,762,210 width=12) (actual rows= loops=)

  • Sort Key: romeo_tango1.quebec_papa
13. 0.000 0.000 ↓ 0.0

Merge Join (cost=1,700,259.390..1,974,041.500 rows=11,762,210 width=12) (actual rows= loops=)

  • Merge Cond: (five_oscar_delta.quebec_papa = tango_lima1.foxtrot_sierra)
14. 0.000 0.000 ↓ 0.0

Unique (cost=937,874.060..998,859.690 rows=2,217,659 width=240) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Sort (cost=937,874.060..943,418.210 rows=2,217,659 width=240) (actual rows= loops=)

  • Sort Key: five_oscar_delta.quebec_papa, five_oscar_delta.alpha_charlie, five_oscar_delta.echo_seven, five_oscar_delta.mike_xray, five_oscar_delta.seven_oscar, five_oscar_delta.mike_foxtrot, five_oscar_delta.golf_victor, five_oscar_delta.hotel_lima, five_oscar_delta.four_alpha, five_oscar_delta.lima_five
16. 0.000 0.000 ↓ 0.0

Append (cost=0.000..203,850.090 rows=2,217,659 width=240) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on five_oscar_delta (cost=0.000..166,083.700 rows=2,217,658 width=115) (actual rows= loops=)

  • Filter: ((mike_foxtrot)::text = 'delta_sierra'::text)
18. 0.000 0.000 ↓ 0.0

Subquery Scan on echo_uniform (cost=0.000..4,501.510 rows=1 width=117) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_mike (cost=0.000..4,501.500 rows=1 width=115) (actual rows= loops=)

  • Filter: ((mike_foxtrot)::text = 'delta_sierra'::text)
20. 0.000 0.000 ↓ 0.0

Materialize (cost=762,385.320..779,670.530 rows=3,457,041 width=12) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Sort (cost=762,385.320..771,027.930 rows=3,457,041 width=12) (actual rows= loops=)

  • Sort Key: tango_lima1.foxtrot_sierra
22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=134,455.040..268,764.550 rows=3,457,041 width=12) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

HashAggregate (cost=134,454.470..134,473.990 rows=1,952 width=240) (actual rows= loops=)

  • Group Key: romeo_tango1.quebec_papa, romeo_tango1.alpha_charlie, romeo_tango1.echo_seven, romeo_tango1.mike_xray, romeo_tango1.seven_oscar, romeo_tango1.mike_foxtrot, romeo_tango1.golf_victor, romeo_tango1.hotel_lima, romeo_tango1.four_alpha, romeo_tango1.lima_five
24. 0.000 0.000 ↓ 0.0

Append (cost=1,000.000..134,405.670 rows=1,952 width=240) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.000..134,371.950 rows=1,951 width=115) (actual rows= loops=)

  • Workers Planned: 2
26. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on five_oscar_delta two (cost=0.000..133,176.850 rows=813 width=115) (actual rows= loops=)

  • Filter: (((seven_oscar)::text = 'lima_india'::text) AND ((mike_xray)::text = 'bravo_lima'::text))
27. 0.000 0.000 ↓ 0.0

Subquery Scan on bravo_alpha (cost=0.420..4.450 rows=1 width=117) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Index Scan using hotel_india on quebec_mike november_juliet (cost=0.420..4.440 rows=1 width=115) (actual rows= loops=)

  • Index Cond: ((seven_oscar)::text = 'lima_india'::text)
  • Filter: ((mike_xray)::text = 'bravo_lima'::text)
29. 0.000 0.000 ↓ 0.0

Index Only Scan using delta_zulu on four_zulu zulu_xray (cost=0.570..51.080 rows=1,771 width=8) (actual rows= loops=)

  • Index Cond: (charlie_uniform = romeo_tango1.quebec_papa)
30. 0.000 0.000 ↓ 0.0

Materialize (cost=50,186,400,090,473,888.000..50,666,508,383,761,520.000 rows=96,021,658,657,527,008 width=19) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Sort (cost=50,186,400,090,473,888.000..50,426,454,237,117,704.000 rows=96,021,658,657,527,008 width=19) (actual rows= loops=)

  • Sort Key: four_zulu.charlie_uniform
32. 0.000 0.000 ↓ 0.0

Merge Join (cost=9,450,663,223.800..1,440,334,421,605,282.250 rows=96,021,658,657,527,008 width=19) (actual rows= loops=)

  • Merge Cond: (romeo_tango2.quebec_papa = xray.hotel_oscar2)
33. 0.000 0.000 ↓ 0.0

Merge Join (cost=16,065,825.800..25,382,435.000 rows=594,738,384 width=12) (actual rows= loops=)

  • Merge Cond: (romeo_tango2.quebec_papa = four_zulu.foxtrot_sierra)
34. 0.000 0.000 ↓ 0.0

Unique (cost=2,673,814.940..2,822,585.980 rows=5,409,856 width=240) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Sort (cost=2,673,814.940..2,687,339.580 rows=5,409,856 width=240) (actual rows= loops=)

  • Sort Key: romeo_tango2.quebec_papa, romeo_tango2.alpha_charlie, romeo_tango2.echo_seven, romeo_tango2.mike_xray, romeo_tango2.seven_oscar, romeo_tango2.mike_foxtrot, romeo_tango2.golf_victor, romeo_tango2.hotel_lima, romeo_tango2.four_alpha, romeo_tango2.lima_five
36. 0.000 0.000 ↓ 0.0

Append (cost=0.000..238,208.400 rows=5,409,856 width=240) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on five_oscar_delta lima_three (cost=0.000..152,920.960 rows=5,265,096 width=115) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Subquery Scan on juliet_hotel (cost=0.000..5,587.200 rows=144,760 width=117) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_mike three_foxtrot_quebec (cost=0.000..4,139.600 rows=144,760 width=115) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Materialize (cost=13,392,010.860..13,750,289.260 rows=71,655,680 width=8) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Sort (cost=13,392,010.860..13,571,150.060 rows=71,655,680 width=8) (actual rows= loops=)

  • Sort Key: four_zulu.foxtrot_sierra
42. 0.000 0.000 ↓ 0.0

Seq Scan on four_zulu (cost=0.000..1,103,884.800 rows=71,655,680 width=8) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Materialize (cost=9,434,597,398.010..9,596,049,325.800 rows=32,290,385,558 width=19) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Sort (cost=9,434,597,398.010..9,515,323,361.900 rows=32,290,385,558 width=19) (actual rows= loops=)

  • Sort Key: xray.hotel_oscar2
45. 0.000 0.000 ↓ 0.0

Merge Join (cost=2,704,651.710..487,222,475.380 rows=32,290,385,558 width=19) (actual rows= loops=)

  • Merge Cond: (five_hotel.quebec_papa = xray.hotel_oscar1)
46. 0.000 0.000 ↓ 0.0

Sort (cost=563,357.040..566,196.570 rows=1,135,813 width=19) (actual rows= loops=)

  • Sort Key: five_hotel.quebec_papa
47. 0.000 0.000 ↓ 0.0

Hash Join (cost=363,528.490..425,824.970 rows=1,135,813 width=19) (actual rows= loops=)

  • Hash Cond: ((five_hotel.golf_victor)::text = (mike_november_quebec_xray2.golf_echo)::text)
48. 0.000 0.000 ↓ 0.0

Subquery Scan on five_hotel (cost=353,520.720..374,436.500 rows=557,754 width=36) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Unique (cost=353,520.720..368,858.960 rows=557,754 width=240) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Sort (cost=353,520.720..354,915.110 rows=557,754 width=240) (actual rows= loops=)

  • Sort Key: romeo_tango3.quebec_papa, romeo_tango3.alpha_charlie, romeo_tango3.echo_seven, romeo_tango3.mike_xray, romeo_tango3.seven_oscar, romeo_tango3.mike_foxtrot, romeo_tango3.golf_victor, romeo_tango3.hotel_lima, romeo_tango3.four_alpha, romeo_tango3.lima_five
51. 0.000 0.000 ↓ 0.0

Append (cost=0.000..174,460.140 rows=557,754 width=240) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Seq Scan on five_oscar_delta yankee_four (cost=0.000..166,083.700 rows=557,749 width=115) (actual rows= loops=)

  • Filter: ((mike_xray)::text = 'kilo_india'::text)
53. 0.000 0.000 ↓ 0.0

Subquery Scan on zulu_foxtrot (cost=0.420..10.180 rows=5 width=117) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Index Scan using victor on quebec_mike echo_hotel (cost=0.420..10.130 rows=5 width=115) (actual rows= loops=)

  • Index Cond: ((mike_xray)::text = 'kilo_india'::text)
55. 0.000 0.000 ↓ 0.0

Hash (cost=6,930.450..6,930.450 rows=159,145 width=27) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Seq Scan on tango_zulu oscar_four (cost=0.000..6,930.450 rows=159,145 width=27) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Materialize (cost=2,141,294.680..2,311,870.570 rows=5,685,863 width=8) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Unique (cost=2,141,294.680..2,240,797.280 rows=5,685,863 width=82) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Sort (cost=2,141,294.680..2,155,509.330 rows=5,685,863 width=82) (actual rows= loops=)

  • Sort Key: xray.hotel_oscar1, xray.hotel_oscar2, xray.mike_seven, xray.hotel_lima, xray.four_alpha, xray.lima_five
60. 0.000 0.000 ↓ 0.0

Append (cost=0.000..959,211.760 rows=5,685,863 width=82) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Seq Scan on xray (cost=0.000..873,922.800 rows=5,685,862 width=37) (actual rows= loops=)

  • Filter: ((mike_seven)::text = 'three_mike'::text)
62. 0.000 0.000 ↓ 0.0

Seq Scan on juliet_november (cost=0.000..1.010 rows=1 width=32) (actual rows= loops=)

  • Filter: ((mike_seven)::text = 'three_mike'::text)
63. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,677,338,974,826,737.000..8,677,338,974,826,833.000 rows=9,600 width=16) (actual rows= loops=)

  • Group Key: mike_november_quebec_xray3.lima_quebec, romeo_tango4.quebec_papa
64. 0.000 0.000 ↓ 0.0

Merge Join (cost=163,175,733,870,668.625..1,894,251,765,314,286.000 rows=1,356,617,441,902,490,112 width=16) (actual rows= loops=)

  • Merge Cond: (romeo_tango5.quebec_papa = tango_lima2.charlie_uniform)
65. 0.000 0.000 ↓ 0.0

Sort (cost=3,757,406.200..3,786,811.730 rows=11,762,210 width=12) (actual rows= loops=)

  • Sort Key: romeo_tango5.quebec_papa
66. 0.000 0.000 ↓ 0.0

Merge Join (cost=1,700,259.390..1,974,041.500 rows=11,762,210 width=12) (actual rows= loops=)

  • Merge Cond: (romeo_tango4.quebec_papa = tango_lima3.foxtrot_sierra)
67. 0.000 0.000 ↓ 0.0

Unique (cost=937,874.060..998,859.690 rows=2,217,659 width=240) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Sort (cost=937,874.060..943,418.210 rows=2,217,659 width=240) (actual rows= loops=)

  • Sort Key: romeo_tango4.quebec_papa, romeo_tango4.alpha_charlie, romeo_tango4.echo_seven, romeo_tango4.mike_xray, romeo_tango4.seven_oscar, romeo_tango4.mike_foxtrot, romeo_tango4.golf_victor, romeo_tango4.hotel_lima, romeo_tango4.four_alpha, romeo_tango4.lima_five
69. 0.000 0.000 ↓ 0.0

Append (cost=0.000..203,850.090 rows=2,217,659 width=240) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Seq Scan on five_oscar_delta sierra_charlie (cost=0.000..166,083.700 rows=2,217,658 width=115) (actual rows= loops=)

  • Filter: ((mike_foxtrot)::text = 'delta_sierra'::text)
71. 0.000 0.000 ↓ 0.0

Subquery Scan on tango_delta (cost=0.000..4,501.510 rows=1 width=117) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_mike six (cost=0.000..4,501.500 rows=1 width=115) (actual rows= loops=)

  • Filter: ((mike_foxtrot)::text = 'delta_sierra'::text)
73. 0.000 0.000 ↓ 0.0

Materialize (cost=762,385.320..779,670.530 rows=3,457,041 width=12) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Sort (cost=762,385.320..771,027.930 rows=3,457,041 width=12) (actual rows= loops=)

  • Sort Key: tango_lima3.foxtrot_sierra
75. 0.000 0.000 ↓ 0.0

Nested Loop (cost=134,455.040..268,764.550 rows=3,457,041 width=12) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

HashAggregate (cost=134,454.470..134,473.990 rows=1,952 width=240) (actual rows= loops=)

  • Group Key: romeo_tango5.quebec_papa, romeo_tango5.alpha_charlie, romeo_tango5.echo_seven, romeo_tango5.mike_xray, romeo_tango5.seven_oscar, romeo_tango5.mike_foxtrot, romeo_tango5.golf_victor, romeo_tango5.hotel_lima, romeo_tango5.four_alpha, romeo_tango5.lima_five
77. 0.000 0.000 ↓ 0.0

Append (cost=1,000.000..134,405.670 rows=1,952 width=240) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.000..134,371.950 rows=1,951 width=115) (actual rows= loops=)

  • Workers Planned: 2
79. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on five_oscar_delta tango_papa (cost=0.000..133,176.850 rows=813 width=115) (actual rows= loops=)

  • Filter: (((seven_oscar)::text = 'lima_india'::text) AND ((mike_xray)::text = 'bravo_lima'::text))
80. 0.000 0.000 ↓ 0.0

Subquery Scan on five_oscar_bravo (cost=0.420..4.450 rows=1 width=117) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Index Scan using hotel_india on quebec_mike four_romeo (cost=0.420..4.440 rows=1 width=115) (actual rows= loops=)

  • Index Cond: ((seven_oscar)::text = 'lima_india'::text)
  • Filter: ((mike_xray)::text = 'bravo_lima'::text)
82. 0.000 0.000 ↓ 0.0

Index Only Scan using delta_zulu on four_zulu sierra_quebec (cost=0.570..51.080 rows=1,771 width=8) (actual rows= loops=)

  • Index Cond: (charlie_uniform = romeo_tango5.quebec_papa)
83. 0.000 0.000 ↓ 0.0

Materialize (cost=163,175,730,113,262.438..165,159,461,779,851.562 rows=396,746,333,317,827 width=16) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Sort (cost=163,175,730,113,262.438..164,167,595,946,557.000 rows=396,746,333,317,827 width=16) (actual rows= loops=)

  • Sort Key: tango_lima2.charlie_uniform
85. 0.000 0.000 ↓ 0.0

Merge Join (cost=45,340,552.970..5,951,250,322,163.020 rows=396,746,333,317,827 width=16) (actual rows= loops=)

  • Merge Cond: (mike_november_quebec_five1.hotel_oscar2 = romeo_tango7.quebec_papa)
86. 0.000 0.000 ↓ 0.0

Sort (cost=29,274,727.170..29,608,274.110 rows=133,418,775 width=16) (actual rows= loops=)

  • Sort Key: mike_november_quebec_five1.hotel_oscar2
87. 0.000 0.000 ↓ 0.0

Merge Join (cost=2,270,952.760..4,428,619.090 rows=133,418,775 width=16) (actual rows= loops=)

  • Merge Cond: (romeo_tango6.quebec_papa = mike_november_quebec_five1.hotel_oscar1)
88. 0.000 0.000 ↓ 0.0

Sort (cost=129,658.090..129,669.820 rows=4,693 width=16) (actual rows= loops=)

  • Sort Key: romeo_tango6.quebec_papa
89. 0.000 0.000 ↓ 0.0

Hash Join (cost=129,228.950..129,371.900 rows=4,693 width=16) (actual rows= loops=)

  • Hash Cond: ((romeo_tango6.golf_victor)::text = (mike_november_quebec_xray3.kilo_oscar)::text)
90. 0.000 0.000 ↓ 0.0

HashAggregate (cost=129,169.610..129,203.010 rows=3,340 width=240) (actual rows= loops=)

  • Group Key: romeo_tango6.quebec_papa, romeo_tango6.alpha_charlie, romeo_tango6.echo_seven, romeo_tango6.mike_xray, romeo_tango6.seven_oscar, romeo_tango6.mike_foxtrot, romeo_tango6.golf_victor, romeo_tango6.hotel_lima, romeo_tango6.four_alpha, romeo_tango6.lima_five
91. 0.000 0.000 ↓ 0.0

Append (cost=1,000.000..129,086.110 rows=3,340 width=240) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.000..129,025.880 rows=3,335 width=115) (actual rows= loops=)

  • Workers Planned: 2
93. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on five_oscar_delta seven_xray (cost=0.000..127,692.380 rows=1,390 width=115) (actual rows= loops=)

  • Filter: ((mike_xray)::text = 'uniform_uniform'::text)
94. 0.000 0.000 ↓ 0.0

Subquery Scan on three_four (cost=0.420..10.180 rows=5 width=117) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Index Scan using victor on quebec_mike kilo_papa (cost=0.420..10.130 rows=5 width=115) (actual rows= loops=)

  • Index Cond: ((mike_xray)::text = 'uniform_uniform'::text)
96. 0.000 0.000 ↓ 0.0

Hash (cost=43.040..43.040 rows=1,304 width=18) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Seq Scan on oscar_lima india_november (cost=0.000..43.040 rows=1,304 width=18) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Materialize (cost=2,141,294.680..2,311,870.570 rows=5,685,863 width=8) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Unique (cost=2,141,294.680..2,240,797.280 rows=5,685,863 width=82) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Sort (cost=2,141,294.680..2,155,509.330 rows=5,685,863 width=82) (actual rows= loops=)

  • Sort Key: mike_november_quebec_five1.hotel_oscar1, mike_november_quebec_five1.hotel_oscar2, mike_november_quebec_five1.mike_seven, mike_november_quebec_five1.hotel_lima, mike_november_quebec_five1.four_alpha, mike_november_quebec_five1.lima_five
101. 0.000 0.000 ↓ 0.0

Append (cost=0.000..959,211.760 rows=5,685,863 width=82) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Seq Scan on xray papa_whiskey (cost=0.000..873,922.800 rows=5,685,862 width=37) (actual rows= loops=)

  • Filter: ((mike_seven)::text = 'three_mike'::text)
103. 0.000 0.000 ↓ 0.0

Seq Scan on juliet_november lima_kilo (cost=0.000..1.010 rows=1 width=32) (actual rows= loops=)

  • Filter: ((mike_seven)::text = 'three_mike'::text)
104. 0.000 0.000 ↓ 0.0

Materialize (cost=16,065,825.800..26,869,280.960 rows=594,738,384 width=12) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Merge Join (cost=16,065,825.800..25,382,435.000 rows=594,738,384 width=12) (actual rows= loops=)

  • Merge Cond: (romeo_tango7.quebec_papa = tango_lima2.foxtrot_sierra)
106. 0.000 0.000 ↓ 0.0

Unique (cost=2,673,814.940..2,822,585.980 rows=5,409,856 width=240) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Sort (cost=2,673,814.940..2,687,339.580 rows=5,409,856 width=240) (actual rows= loops=)

  • Sort Key: romeo_tango7.quebec_papa, romeo_tango7.alpha_charlie, romeo_tango7.echo_seven, romeo_tango7.mike_xray, romeo_tango7.seven_oscar, romeo_tango7.mike_foxtrot, romeo_tango7.golf_victor, romeo_tango7.hotel_lima, romeo_tango7.four_alpha, romeo_tango7.lima_five
108. 0.000 0.000 ↓ 0.0

Append (cost=0.000..238,208.400 rows=5,409,856 width=240) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Seq Scan on five_oscar_delta quebec_foxtrot (cost=0.000..152,920.960 rows=5,265,096 width=115) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Subquery Scan on four_three (cost=0.000..5,587.200 rows=144,760 width=117) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_mike charlie_charlie (cost=0.000..4,139.600 rows=144,760 width=115) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Materialize (cost=13,392,010.860..13,750,289.260 rows=71,655,680 width=8) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Sort (cost=13,392,010.860..13,571,150.060 rows=71,655,680 width=8) (actual rows= loops=)

  • Sort Key: tango_lima2.foxtrot_sierra
114. 0.000 0.000 ↓ 0.0

Seq Scan on four_zulu foxtrot_whiskey (cost=0.000..1,103,884.800 rows=71,655,680 width=8) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Sort (cost=1,029.690..1,039.980 rows=4,116 width=126) (actual rows= loops=)

  • Sort Key: quebec_three.lima_quebec, yankee_quebec_six_kilo.lima_seven
116. 0.000 0.000 ↓ 0.0

Hash Join (cost=637.000..782.590 rows=4,116 width=126) (actual rows= loops=)

  • Hash Cond: (yankee_quebec_six_kilo.bravo_foxtrot = quebec_three.quebec_papa)
117. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_quebec_six_kilo (cost=0.000..1.420 rows=42 width=12) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Hash (cost=392.000..392.000 rows=19,600 width=122) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

CTE Scan on tango_two quebec_three (cost=0.000..392.000 rows=19,600 width=122) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Unique (cost=11,167,644,600,573.971..11,167,644,601,332.221 rows=3,370 width=126) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Unique (cost=11,167,644,600,573.971..11,167,644,600,826.721 rows=33,700 width=126) (actual rows= loops=)

122.          

CTE whiskey_delta

123. 0.000 0.000 ↓ 0.0

HashAggregate (cost=11,167,644,594,334.689..11,167,644,594,434.689 rows=10,000 width=16) (actual rows= loops=)

  • Group Key: mike_november_quebec_xray4.lima_quebec, juliet_india.quebec_papa
124. 0.000 0.000 ↓ 0.0

Merge Join (cost=24,692,742.670..8,375,758,880,067.870 rows=558,377,142,853,364 width=16) (actual rows= loops=)

  • Merge Cond: (mike_november_quebec_five2.hotel_oscar2 = romeo_tango9.quebec_papa)
125. 0.000 0.000 ↓ 0.0

Sort (cost=6,173,011.050..6,227,666.410 rows=21,862,143 width=16) (actual rows= loops=)

  • Sort Key: mike_november_quebec_five2.hotel_oscar2
126. 0.000 0.000 ↓ 0.0

Merge Join (cost=2,276,264.460..2,760,561.690 rows=21,862,143 width=16) (actual rows= loops=)

  • Merge Cond: (romeo_tango8.quebec_papa = mike_november_quebec_five2.hotel_oscar1)
127. 0.000 0.000 ↓ 0.0

Sort (cost=134,969.790..134,971.710 rows=769 width=16) (actual rows= loops=)

  • Sort Key: romeo_tango8.quebec_papa
128. 0.000 0.000 ↓ 0.0

Hash Join (cost=134,870.910..134,932.930 rows=769 width=16) (actual rows= loops=)

  • Hash Cond: ((romeo_tango8.golf_victor)::text = (mike_november_quebec_xray4.yankee_bravo)::text)
  • Join Filter: ((((romeo_tango8.mike_xray)::text = 'bravo_kilo'::text) AND ((mike_november_quebec_xray4.romeo_juliet)::text = 'four_uniform'::text)) OR (((romeo_tango8.mike_xray)::text = 'november_six'::text) AND ((mike_november_quebec_xray4.romeo_juliet)::text = 'oscar_yankee'::text)))
129. 0.000 0.000 ↓ 0.0

HashAggregate (cost=134,421.050..134,435.190 rows=1,414 width=240) (actual rows= loops=)

  • Group Key: romeo_tango8.quebec_papa, romeo_tango8.alpha_charlie, romeo_tango8.echo_seven, romeo_tango8.mike_xray, romeo_tango8.seven_oscar, romeo_tango8.mike_foxtrot, romeo_tango8.golf_victor, romeo_tango8.hotel_lima, romeo_tango8.four_alpha, romeo_tango8.lima_five
130. 0.000 0.000 ↓ 0.0

Append (cost=1,000.000..134,385.700 rows=1,414 width=240) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.000..134,317.250 rows=1,404 width=115) (actual rows= loops=)

  • Workers Planned: 2
132. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on five_oscar_delta whiskey_charlie (cost=0.000..133,176.850 rows=585 width=115) (actual rows= loops=)

  • Filter: (((mike_xray)::text = 'bravo_kilo'::text) OR ((mike_xray)::text = 'november_six'::text))
133. 0.000 0.000 ↓ 0.0

Subquery Scan on three_foxtrot_oscar (cost=8.920..47.340 rows=10 width=117) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on quebec_mike delta_juliet (cost=8.920..47.240 rows=10 width=115) (actual rows= loops=)

  • Recheck Cond: (((mike_xray)::text = 'bravo_kilo'::text) OR ((mike_xray)::text = 'november_six'::text))
135. 0.000 0.000 ↓ 0.0

BitmapOr (cost=8.920..8.920 rows=10 width=0) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((mike_xray)::text = 'bravo_kilo'::text)
137. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((mike_xray)::text = 'november_six'::text)
138. 0.000 0.000 ↓ 0.0

Hash (cost=357.140..357.140 rows=7,417 width=21) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Seq Scan on lima_two alpha_foxtrot (cost=0.000..357.140 rows=7,417 width=21) (actual rows= loops=)

  • Filter: (((romeo_juliet)::text = 'four_uniform'::text) OR ((romeo_juliet)::text = 'oscar_yankee'::text))
140. 0.000 0.000 ↓ 0.0

Materialize (cost=2,141,294.680..2,311,870.570 rows=5,685,863 width=8) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Unique (cost=2,141,294.680..2,240,797.280 rows=5,685,863 width=82) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Sort (cost=2,141,294.680..2,155,509.330 rows=5,685,863 width=82) (actual rows= loops=)

  • Sort Key: mike_november_quebec_five2.hotel_oscar1, mike_november_quebec_five2.hotel_oscar2, mike_november_quebec_five2.mike_seven, mike_november_quebec_five2.hotel_lima, mike_november_quebec_five2.four_alpha, mike_november_quebec_five2.lima_five
143. 0.000 0.000 ↓ 0.0

Append (cost=0.000..959,211.760 rows=5,685,863 width=82) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Seq Scan on xray bravo_xray (cost=0.000..873,922.800 rows=5,685,862 width=37) (actual rows= loops=)

  • Filter: ((mike_seven)::text = 'three_mike'::text)
145. 0.000 0.000 ↓ 0.0

Seq Scan on juliet_november yankee_quebec_six_golf (cost=0.000..1.010 rows=1 width=32) (actual rows= loops=)

  • Filter: ((mike_seven)::text = 'three_mike'::text)
146. 0.000 0.000 ↓ 0.0

Materialize (cost=18,519,731.620..108,224,519.000 rows=5,108,164,766 width=12) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Merge Join (cost=18,519,731.620..95,454,107.090 rows=5,108,164,766 width=12) (actual rows= loops=)

  • Merge Cond: (romeo_tango9.quebec_papa = tango_lima4.charlie_uniform)
148. 0.000 0.000 ↓ 0.0

Unique (cost=2,673,814.940..2,822,585.980 rows=5,409,856 width=240) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Sort (cost=2,673,814.940..2,687,339.580 rows=5,409,856 width=240) (actual rows= loops=)

  • Sort Key: romeo_tango9.quebec_papa, romeo_tango9.alpha_charlie, romeo_tango9.echo_seven, romeo_tango9.mike_xray, romeo_tango9.seven_oscar, romeo_tango9.mike_foxtrot, romeo_tango9.golf_victor, romeo_tango9.hotel_lima, romeo_tango9.four_alpha, romeo_tango9.lima_five
150. 0.000 0.000 ↓ 0.0

Append (cost=0.000..238,208.400 rows=5,409,856 width=240) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Seq Scan on five_oscar_delta yankee_echo (cost=0.000..152,920.960 rows=5,265,096 width=115) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Subquery Scan on echo_whiskey (cost=0.000..5,587.200 rows=144,760 width=117) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_mike uniform_quebec (cost=0.000..4,139.600 rows=144,760 width=115) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Materialize (cost=15,845,916.680..16,036,935.020 rows=38,203,669 width=8) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Sort (cost=15,845,916.680..15,941,425.850 rows=38,203,669 width=8) (actual rows= loops=)

  • Sort Key: tango_lima4.charlie_uniform
156. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,564,011.470..9,467,740.910 rows=38,203,669 width=8) (actual rows= loops=)

  • Hash Cond: (juliet_india.quebec_papa = tango_lima4.foxtrot_sierra)
157. 0.000 0.000 ↓ 0.0

Subquery Scan on juliet_india (cost=284,525.670..297,557.220 rows=347,508 width=4) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Unique (cost=284,525.670..294,082.140 rows=347,508 width=240) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Sort (cost=284,525.670..285,394.440 rows=347,508 width=240) (actual rows= loops=)

  • Sort Key: romeo_tango10.quebec_papa, romeo_tango10.alpha_charlie, romeo_tango10.echo_seven, romeo_tango10.mike_xray, romeo_tango10.seven_oscar, romeo_tango10.mike_foxtrot, romeo_tango10.golf_victor, romeo_tango10.hotel_lima, romeo_tango10.four_alpha, romeo_tango10.lima_five
160. 0.000 0.000 ↓ 0.0

Append (cost=1,000.000..174,150.320 rows=347,508 width=240) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.000..168,927.550 rows=347,507 width=115) (actual rows= loops=)

  • Workers Planned: 2
162. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on five_oscar_delta golf_yankee (cost=0.000..133,176.850 rows=144,795 width=115) (actual rows= loops=)

  • Filter: (((mike_foxtrot)::text = 'delta_sierra'::text) AND ((mike_xray)::text = 'uniform_hotel'::text))
163. 0.000 0.000 ↓ 0.0

Subquery Scan on sierra_romeo (cost=0.420..10.160 rows=1 width=117) (actual rows= loops=)

164. 0.000 0.000 ↓ 0.0

Index Scan using victor on quebec_mike papa_tango (cost=0.420..10.150 rows=1 width=115) (actual rows= loops=)

  • Index Cond: ((mike_xray)::text = 'uniform_hotel'::text)
  • Filter: ((mike_foxtrot)::text = 'delta_sierra'::text)
165. 0.000 0.000 ↓ 0.0

Hash (cost=1,103,884.800..1,103,884.800 rows=71,655,680 width=8) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Seq Scan on four_zulu bravo_yankee (cost=0.000..1,103,884.800 rows=71,655,680 width=8) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Sort (cost=6,139.270..6,223.520 rows=33,700 width=126) (actual rows= loops=)

  • Sort Key: mike_november_quebec_xray1.lima_quebec, november_three.lima_seven
168. 0.000 0.000 ↓ 0.0

Merge Join (cost=864.660..1,413.960 rows=33,700 width=126) (actual rows= loops=)

  • Merge Cond: (november_three.echo_quebec = mike_november_quebec_xray1.quebec_papa)
169. 0.000 0.000 ↓ 0.0

Index Scan using india_xray on november_three (cost=0.280..42.390 rows=674 width=12) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Sort (cost=864.390..889.390 rows=10,000 width=122) (actual rows= loops=)

  • Sort Key: mike_november_quebec_xray1.quebec_papa
171. 0.000 0.000 ↓ 0.0

CTE Scan on whiskey_delta juliet_xray (cost=0.000..200.000 rows=10,000 width=122) (actual rows= loops=)