explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cjUh

Settings
# exclusive inclusive rows x rows loops node
1. 0.488 31,298.081 ↓ 4.1 813 1

Sort (cost=64,165,044.000..64,165,044.500 rows=200 width=32) (actual time=31,297.903..31,298.081 rows=813 loops=1)

  • Sort Key: sierra_hotel.five_echo
  • Sort Method: quicksort Memory: 88kB
2.          

CTE sierra_hotel

3. 1.210 30,233.829 ↓ 4.0 797 1

GroupAggregate (cost=783,419.830..783,438.890 rows=200 width=16) (actual time=30,231.748..30,233.829 rows=797 loops=1)

  • Group Key: quebec_hotel.five_echo
4. 2.069 30,232.619 ↓ 1.4 3,217 1

Sort (cost=783,419.830..783,425.520 rows=2,274 width=16) (actual time=30,231.742..30,232.619 rows=3,217 loops=1)

  • Sort Key: quebec_hotel.five_echo
  • Sort Method: quicksort Memory: 247kB
5. 1.285 30,230.550 ↓ 1.4 3,217 1

Subquery Scan on quebec_hotel (cost=783,247.560..783,293.040 rows=2,274 width=16) (actual time=30,227.916..30,230.550 rows=3,217 loops=1)

6. 2.971 30,229.265 ↓ 1.4 3,217 1

HashAggregate (cost=783,247.560..783,270.300 rows=2,274 width=48) (actual time=30,227.915..30,229.265 rows=3,217 loops=1)

  • Group Key: ((((three_foxtrot.five_echo)::date))::timestamp with time zone), (CASE WHEN (three_foxtrot.sierra_hotel five_romeo NULL) THEN 'november_golf'::double precision ELSE three_foxtrot.sierra_hotel END), three_foxtrot.seven_papa
7. 1.214 30,226.294 ↓ 1.4 3,217 1

Append (cost=135.230..783,230.510 rows=2,274 width=48) (actual time=3.849..30,226.294 rows=3,217 loops=1)

8. 1.514 4.528 ↑ 1.0 1,872 1

HashAggregate (cost=135.230..158.660 rows=1,874 width=48) (actual time=3.847..4.528 rows=1,872 loops=1)

  • Group Key: ((three_foxtrot.five_echo)::date), (CASE WHEN (three_foxtrot.sierra_hotel five_romeo NULL) THEN 'november_golf'::double precision ELSE three_foxtrot.sierra_hotel END), three_foxtrot.seven_papa
9. 0.734 3.014 ↑ 1.0 1,874 1

Append (cost=0.000..121.180 rows=1,874 width=44) (actual time=0.018..3.014 rows=1,874 loops=1)

10. 0.751 0.751 ↑ 1.0 1,140 1

Seq Scan on three_foxtrot (cost=0.000..35.100 rows=1,140 width=19) (actual time=0.017..0.751 rows=1,140 loops=1)

11. 0.192 0.192 ↑ 1.0 281 1

Seq Scan on alpha_juliet (cost=0.000..9.210 rows=281 width=44) (actual time=0.010..0.192 rows=281 loops=1)

12. 0.148 0.148 ↑ 1.0 210 1

Seq Scan on mike_bravo (cost=0.000..6.150 rows=210 width=44) (actual time=0.007..0.148 rows=210 loops=1)

13. 0.087 1.189 ↑ 1.0 243 1

Subquery Scan on foxtrot_bravo (cost=45.900..51.970 rows=243 width=44) (actual time=0.930..1.189 rows=243 loops=1)

14. 0.641 1.102 ↑ 1.0 243 1

HashAggregate (cost=45.900..49.540 rows=243 width=56) (actual time=0.929..1.102 rows=243 loops=1)

  • Group Key: juliet_mike.five_echo
15. 0.461 0.461 ↑ 1.0 1,193 1

Seq Scan on juliet_mike (cost=0.000..39.930 rows=1,193 width=20) (actual time=0.003..0.461 rows=1,193 loops=1)

16. 0.680 29,612.974 ↓ 4.0 794 1

Subquery Scan on uniform_papa (cost=758,709.490..758,718.760 rows=200 width=48) (actual time=29,610.856..29,612.974 rows=794 loops=1)

17. 0.340 29,612.294 ↓ 4.0 794 1

Subquery Scan on oscar_quebec (cost=758,709.490..758,716.260 rows=200 width=72) (actual time=29,610.836..29,612.294 rows=794 loops=1)

18. 0.488 29,611.954 ↓ 4.0 794 1

Hash Left Join (cost=758,709.490..758,714.260 rows=200 width=112) (actual time=29,610.835..29,611.954 rows=794 loops=1)

  • Hash Cond: (golf_tango1.uniform_juliet = bravo_india1.uniform_juliet)
19.          

CTE foxtrot_zulu

20. 1.165 463.251 ↓ 372.0 744 1

GroupAggregate (cost=32,226.200..32,226.230 rows=2 width=16) (actual time=461.260..463.251 rows=744 loops=1)

  • Group Key: foxtrot_zulu.uniform_juliet
21.          

CTE foxtrot_zulu

22. 453.786 453.786 ↓ 22.1 10,634 1

CTE Scan on delta_india (cost=32,200.940..32,210.560 rows=481 width=48) (actual time=240.306..453.786 rows=10,634 loops=1)

23.          

CTE delta_india

24. 23.859 432.521 ↓ 22.1 10,634 1

Subquery Scan on charlie_sierra_alpha (cost=28,837.160..32,200.940 rows=481 width=349) (actual time=240.300..432.521 rows=10,634 loops=1)

  • Filter: (charlie_sierra_alpha.tango_four = 1)
  • Rows Removed by Filter: 85465
25. 110.002 408.662 ↑ 1.0 96,099 1

WindowAgg (cost=28,837.160..30,999.590 rows=96,108 width=349) (actual time=240.287..408.662 rows=96,099 loops=1)

26. 237.874 298.660 ↑ 1.0 96,099 1

Sort (cost=28,837.160..29,077.430 rows=96,108 width=341) (actual time=240.277..298.660 rows=96,099 loops=1)

  • Sort Key: "echo_tango".uniform_juliet, "echo_tango".india_lima, "echo_tango".xray_echo DESC
  • Sort Method: external merge Disk: 35760kB
27. 60.786 60.786 ↑ 1.0 96,099 1

Seq Scan on echo_tango (cost=0.000..5,770.080 rows=96,108 width=341) (actual time=0.025..60.786 rows=96,099 loops=1)

28. 1.970 462.086 ↓ 1,728.5 3,457 1

Sort (cost=10.830..10.840 rows=2 width=16) (actual time=461.251..462.086 rows=3,457 loops=1)

  • Sort Key: foxtrot_zulu.uniform_juliet
  • Sort Method: quicksort Memory: 259kB
29. 460.116 460.116 ↓ 1,728.5 3,457 1

CTE Scan on foxtrot_zulu (cost=0.000..10.820 rows=2 width=16) (actual time=240.329..460.116 rows=3,457 loops=1)

  • Filter: (hotel_hotel = 'india_romeo'::text)
  • Rows Removed by Filter: 7177
30.          

CTE xray_victor

31. 0.670 29,147.216 ↓ 4.0 794 1

Sort (cost=726,480.670..726,481.170 rows=200 width=104) (actual time=29,146.910..29,147.216 rows=794 loops=1)

  • Sort Key: xray_victor.uniform_juliet
  • Sort Method: quicksort Memory: 87kB
32.          

CTE xray_victor

33. 28,461.846 28,461.846 ↓ 34.7 198,455 1

CTE Scan on hotel_kilo (cost=726,126.010..726,240.350 rows=5,717 width=32) (actual time=24,309.598..28,461.846 rows=198,455 loops=1)

34.          

CTE hotel_kilo

35. 319.507 27,263.359 ↓ 34.7 198,455 1

Subquery Scan on mike_yankee (cost=686,105.640..726,126.010 rows=5,717 width=474) (actual time=24,309.592..27,263.359 rows=198,455 loops=1)

  • Filter: (romeo1.tango_four = 1)
  • Rows Removed by Filter: 942913
36. 1,651.200 26,943.852 ↑ 1.0 1,141,368 1

WindowAgg (cost=686,105.640..711,833.020 rows=1,143,439 width=474) (actual time=24,309.579..26,943.852 rows=1,141,368 loops=1)

37. 18,607.046 25,292.652 ↑ 1.0 1,141,368 1

Sort (cost=686,105.640..688,964.240 rows=1,143,439 width=466) (actual time=24,309.567..25,292.652 rows=1,141,368 loops=1)

  • Sort Key: "charlie_sierra_victor".uniform_juliet, "charlie_sierra_victor".india_lima, "charlie_sierra_victor".xray_echo DESC
  • Sort Method: external merge Disk: 562360kB
38. 6,685.606 6,685.606 ↑ 1.0 1,141,368 1

Seq Scan on echo_tango charlie_sierra_victor (cost=0.000..86,423.390 rows=1,143,439 width=466) (actual time=0.379..6,685.606 rows=1,141,368 loops=1)

39. 106.061 29,146.546 ↓ 4.0 794 1

HashAggregate (cost=171.510..175.510 rows=200 width=104) (actual time=29,145.697..29,146.546 rows=794 loops=1)

  • Group Key: xray_victor.uniform_juliet
40. 29,040.485 29,040.485 ↓ 34.7 198,455 1

CTE Scan on xray_victor (cost=0.000..114.340 rows=5,717 width=32) (actual time=24,309.601..29,040.485 rows=198,455 loops=1)

41. 29,147.565 29,147.565 ↓ 4.0 794 1

CTE Scan on xray_victor delta_zulu (cost=0.000..4.000 rows=200 width=40) (actual time=29,146.912..29,147.565 rows=794 loops=1)

42. 0.218 463.901 ↓ 372.0 744 1

Hash (cost=0.040..0.040 rows=2 width=8) (actual time=463.901..463.901 rows=744 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
43. 463.683 463.683 ↓ 372.0 744 1

CTE Scan on foxtrot_zulu lima_bravo (cost=0.000..0.040 rows=2 width=8) (actual time=461.262..463.683 rows=744 loops=1)

44. 0.262 607.578 ↓ 2.8 551 1

Subquery Scan on tango_delta (cost=24,348.590..24,351.090 rows=200 width=48) (actual time=607.190..607.578 rows=551 loops=1)

45. 0.344 607.316 ↓ 2.8 551 1

Sort (cost=24,348.590..24,349.090 rows=200 width=88) (actual time=607.188..607.316 rows=551 loops=1)

  • Sort Key: three_four.whiskey_six
  • Sort Method: quicksort Memory: 50kB
46.          

CTE three_four

47. 32.816 506.674 ↑ 1.0 40,288 1

Merge Left Join (cost=22,184.050..22,727.500 rows=40,288 width=152) (actual time=453.320..506.674 rows=40,288 loops=1)

  • Merge Cond: ((november_xray.alpha_golf = golf_juliet.uniform_four) AND (november_xray.whiskey_six = golf_juliet.foxtrot_seven) AND (november_xray.bravo_three = golf_juliet.tango_oscar) AND (november_xray.bravo_tango = golf_juliet.mike_juliet))
48.          

CTE november_xray

49. 31.193 31.193 ↑ 1.0 40,288 1

Seq Scan on four_sierra_alpha (cost=0.000..3,407.880 rows=40,288 width=226) (actual time=0.013..31.193 rows=40,288 loops=1)

50.          

CTE golf_juliet

51. 64.187 64.187 ↓ 1.0 3,285 1

Seq Scan on three_charlie (cost=0.000..10,782.580 rows=3,187 width=101) (actual time=0.204..64.187 rows=3,285 loops=1)

  • Filter: (charlie_hotel = 'golf_whiskey'::text)
  • Rows Removed by Filter: 236921
52. 308.700 394.218 ↑ 1.0 40,288 1

Sort (cost=7,744.400..7,845.120 rows=40,288 width=200) (actual time=374.981..394.218 rows=40,288 loops=1)

  • Sort Key: november_xray.alpha_golf, november_xray.whiskey_six, november_xray.bravo_three, november_xray.bravo_tango
  • Sort Method: external merge Disk: 7944kB
53. 85.518 85.518 ↑ 1.0 40,288 1

CTE Scan on november_xray (cost=0.000..805.760 rows=40,288 width=200) (actual time=0.016..85.518 rows=40,288 loops=1)

54. 12.245 79.640 ↓ 1.0 3,285 1

Sort (cost=249.190..257.160 rows=3,187 width=120) (actual time=78.325..79.640 rows=3,285 loops=1)

  • Sort Key: golf_juliet.uniform_four, golf_juliet.foxtrot_seven, golf_juliet.tango_oscar, golf_juliet.mike_juliet
  • Sort Method: quicksort Memory: 558kB
55. 67.395 67.395 ↓ 1.0 3,285 1

CTE Scan on golf_juliet (cost=0.000..63.740 rows=3,187 width=120) (actual time=0.209..67.395 rows=3,285 loops=1)

56. 16.312 606.972 ↓ 2.8 551 1

HashAggregate (cost=1,208.580..1,210.580 rows=200 width=88) (actual time=606.784..606.972 rows=551 loops=1)

  • Group Key: three_four.whiskey_six
57. 590.660 590.660 ↑ 1.0 39,937 1

CTE Scan on three_four (cost=0.000..1,007.200 rows=40,275 width=16) (actual time=453.354..590.660 rows=39,937 loops=1)

  • Filter: (golf_romeo(four_kilo) !~~ 'hotel_yankee'::text)
  • Rows Removed by Filter: 351
58.          

CTE sierra_charlie

59. 0.736 1,062.210 ↓ 3.5 700 1

GroupAggregate (cost=63,381,559.110..63,381,579.470 rows=200 width=16) (actual time=1,060.988..1,062.210 rows=700 loops=1)

  • Group Key: (papa_five('six_uniform'::text, (alpha_zulu.five_echo)::timestamp with time zone))
60. 1.125 1,061.474 ↑ 1.2 1,995 1

Sort (cost=63,381,559.110..63,381,564.900 rows=2,314 width=16) (actual time=1,060.982..1,061.474 rows=1,995 loops=1)

  • Sort Key: (papa_five('six_uniform'::text, (alpha_zulu.five_echo)::timestamp with time zone))
  • Sort Method: quicksort Memory: 142kB
61. 1.332 1,060.349 ↑ 1.2 1,995 1

Subquery Scan on alpha_zulu (cost=63,368,608.030..63,381,429.800 rows=2,314 width=16) (actual time=1,047.968..1,060.349 rows=1,995 loops=1)

62. 2.254 1,059.017 ↑ 1.2 1,995 1

Hash Join (cost=63,368,608.030..63,381,395.090 rows=2,314 width=160) (actual time=1,047.959..1,059.017 rows=1,995 loops=1)

  • Hash Cond: (november_alpha.zulu = (zulu.zulu)::text)
63.          

CTE november_alpha

64. 3.441 1,053.138 ↑ 69.2 6,420 1

Unique (cost=63,363,029.590..63,368,581.320 rows=444,138 width=76) (actual time=1,047.903..1,053.138 rows=6,420 loops=1)

65. 5.695 1,049.697 ↑ 69.2 6,420 1

Sort (cost=63,363,029.590..63,364,139.940 rows=444,138 width=76) (actual time=1,047.902..1,049.697 rows=6,420 loops=1)

  • Sort Key: ((four_sierra_quebec.five_echo)::date), (five_hotel_papa(four_sierra_quebec.november_juliet)), four_sierra_quebec.zulu, four_sierra_quebec.seven_papa
  • Sort Method: quicksort Memory: 694kB
66. 2.477 1,044.002 ↑ 69.2 6,420 1

Append (cost=63,285,915.670..63,301,631.510 rows=444,138 width=76) (actual time=1,017.711..1,044.002 rows=6,420 loops=1)

67. 13.959 1,040.559 ↑ 86.1 5,144 1

GroupAggregate (cost=63,285,915.670..63,297,132.100 rows=442,862 width=76) (actual time=1,017.710..1,040.559 rows=5,144 loops=1)

  • Group Key: ((four_sierra_quebec.five_echo)::date), four_sierra_quebec.zulu, four_sierra_quebec.seven_papa
68. 0.000 1,026.600 ↑ 13.0 34,959 1

Sort (cost=63,285,915.670..63,287,051.800 rows=454,452 width=76) (actual time=1,017.699..1,026.600 rows=34,959 loops=1)

  • Sort Key: ((four_sierra_quebec.five_echo)::date), four_sierra_quebec.zulu, four_sierra_quebec.seven_papa
  • Sort Method: quicksort Memory: 3677kB
69. 22.805 990.697 ↑ 13.0 34,959 1

Subquery Scan on four_sierra_quebec (cost=59,813,487.330..63,223,016.340 rows=454,452 width=76) (actual time=933.656..990.697 rows=34,959 loops=1)

  • Filter: (four_sierra_quebec.alpha_four = 'november_victor'::text)
  • Rows Removed by Filter: 1232
70. 22.311 967.892 ↑ 2,511.4 36,191 1

Unique (cost=59,813,487.330..62,085,749.250 rows=90,890,477 width=192) (actual time=933.637..967.892 rows=36,191 loops=1)

71. 57.837 945.581 ↑ 2,511.4 36,191 1

Sort (cost=59,813,487.330..60,040,713.520 rows=90,890,477 width=192) (actual time=933.636..945.581 rows=36,191 loops=1)

  • Sort Key: ((((((six_whiskey.five_echo)::date))::timestamp without time zone))::timestamp with time zone), six_whiskey.charlie_alpha_yankee, six_whiskey.hotel_romeo, six_whiskey.zulu, six_whiskey.november_juliet, six_whiskey.echo_charlie, six_whiskey.three_kilo, six_whiskey.seven_papa, six_whiskey.two_charlie
  • Sort Method: external merge Disk: 3744kB
72. 589.904 887.744 ↑ 2,511.4 36,191 1

Append (cost=735,346.380..14,247,467.220 rows=90,890,477 width=192) (actual time=256.973..887.744 rows=36,191 loops=1)

73. 15.399 297.840 ↑ 64.6 27,478 1

Result (cost=735,346.380..801,873.810 rows=1,774,065 width=192) (actual time=256.971..297.840 rows=27,478 loops=1)

74. 16.997 282.441 ↑ 64.6 27,478 1

Unique (cost=735,346.380..779,698.000 rows=1,774,065 width=192) (actual time=256.954..282.441 rows=27,478 loops=1)

75. 43.999 265.444 ↑ 64.6 27,478 1

Sort (cost=735,346.380..739,781.540 rows=1,774,065 width=192) (actual time=256.953..265.444 rows=27,478 loops=1)

  • Sort Key: ((((six_whiskey.five_echo)::date))::timestamp without time zone), six_whiskey.charlie_alpha_yankee, six_whiskey.hotel_romeo, six_whiskey.zulu, six_whiskey.november_juliet, six_whiskey.echo_charlie, six_whiskey.three_kilo, six_whiskey.seven_papa, six_whiskey.two_charlie
  • Sort Method: external sort Disk: 2816kB
76. 10.727 221.445 ↑ 64.6 27,478 1

Append (cost=370.120..223,764.610 rows=1,774,065 width=192) (actual time=8.662..221.445 rows=27,478 loops=1)

77. 4.701 10.584 ↑ 1.0 3,302 1

HashAggregate (cost=370.120..411.520 rows=3,312 width=192) (actual time=8.660..10.584 rows=3,302 loops=1)

  • Group Key: ((six_whiskey.five_echo)::date), six_whiskey.charlie_alpha_yankee, six_whiskey.hotel_romeo, six_whiskey.zulu, six_whiskey.november_juliet, six_whiskey.echo_charlie, six_whiskey.three_kilo, six_whiskey.seven_papa, six_whiskey.two_charlie
78. 1.293 5.883 ↓ 1.0 3,328 1

Append (cost=0.000..295.600 rows=3,312 width=188) (actual time=0.022..5.883 rows=3,328 loops=1)

79. 0.960 0.960 ↑ 1.0 1,258 1

Seq Scan on six_whiskey (cost=0.000..63.870 rows=1,258 width=90) (actual time=0.022..0.960 rows=1,258 loops=1)

80. 0.994 3.273 ↑ 1.0 2,036 1

Subquery Scan on echo_uniform (cost=0.000..194.170 rows=2,036 width=259) (actual time=0.023..3.273 rows=2,036 loops=1)

81. 2.279 2.279 ↑ 1.0 2,036 1

Seq Scan on five_mike (cost=0.000..168.720 rows=2,036 width=259) (actual time=0.019..2.279 rows=2,036 loops=1)

82. 0.028 0.357 ↓ 1.9 34 1

Subquery Scan on bravo_seven (cost=23.370..24.980 rows=18 width=188) (actual time=0.207..0.357 rows=34 loops=1)

83. 0.065 0.329 ↓ 1.9 34 1

Hash Join (cost=23.370..24.580 rows=18 width=188) (actual time=0.197..0.329 rows=34 loops=1)

  • Hash Cond: (alpha_november.charlie_alpha_yankee = juliet_juliet2.quebec_seven)
84.          

CTE sierra_zulu

85. 0.066 0.066 ↑ 1.0 18 1

Seq Scan on sierra_zulu five_hotel_uniform (cost=0.000..17.270 rows=18 width=584) (actual time=0.016..0.066 rows=18 loops=1)

  • Filter: (NOT victor_foxtrot)
86.          

CTE alpha_november

87. 0.052 0.052 ↑ 1.0 34 1

Seq Scan on oscar_whiskey five_quebec (cost=0.000..5.510 rows=34 width=160) (actual time=0.010..0.052 rows=34 loops=1)

88. 0.119 0.119 ↑ 1.0 34 1

CTE Scan on alpha_november (cost=0.000..0.680 rows=34 width=88) (actual time=0.016..0.119 rows=34 loops=1)

89. 0.005 0.145 ↑ 1.0 18 1

Hash (cost=0.360..0.360 rows=18 width=24) (actual time=0.145..0.145 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
90. 0.140 0.140 ↑ 1.0 18 1

CTE Scan on sierra_zulu charlie_delta (cost=0.000..0.360 rows=18 width=24) (actual time=0.025..0.140 rows=18 loops=1)

91. 11.075 200.134 ↑ 73.2 24,176 1

Subquery Scan on four_golf (cost=7,301.470..223,353.080 rows=1,770,753 width=192) (actual time=130.624..200.134 rows=24,176 loops=1)

92. 17.992 189.059 ↑ 73.2 24,176 1

Hash Left Join (cost=7,301.470..201,218.670 rows=1,770,753 width=192) (actual time=130.620..189.059 rows=24,176 loops=1)

  • Hash Cond: ((CASE WHEN ((india_papa1.zulu = ''delta_three'%foxtrot_uniform%yankee_romeo%'charlie_alpha_lima'whiskey_uniform211victor_india'seven_delta'%foxtrot_uniform%papa_whiskey%'charlie_alpha_lima'whiskey_uniform201victor_india'::text ELSE india_papa1.zulu END) = (five_hotel_lima.zulu)::text)
93. 0.000 171.067 ↑ 50.6 24,116 1

Merge Join (cost=7,284.950..53,130.560 rows=1,221,209 width=192) (actual time=130.568..171.067 rows=24,116 loops=1)

  • Merge Cond: (juliet_juliet3.quebec_seven = india_papa1.charlie_alpha_yankee)
94.          

CTE sierra_zulu

95. 20.518 20.518 ↑ 1.0 9,970 1

Seq Scan on sierra_zulu (cost=0.000..2,382.720 rows=10,054 width=759) (actual time=0.021..20.518 rows=9,970 loops=1)

  • Filter: ((NOT victor_foxtrot) AND (two_five <> golf_five))
  • Rows Removed by Filter: 136
96.          

CTE alpha_november

97. 21.189 21.189 ↑ 1.0 24,293 1

Seq Scan on oscar_whiskey (cost=0.000..1,777.390 rows=24,293 width=150) (actual time=0.015..21.189 rows=24,293 loops=1)

98. 7.144 68.039 ↑ 1.0 9,970 1

Sort (cost=869.440..894.580 rows=10,054 width=24) (actual time=65.249..68.039 rows=9,970 loops=1)

  • Sort Key: juliet_juliet3.quebec_seven
  • Sort Method: quicksort Memory: 1163kB
99. 60.895 60.895 ↑ 1.0 9,970 1

CTE Scan on sierra_zulu kilo (cost=0.000..201.080 rows=10,054 width=24) (actual time=0.029..60.895 rows=9,970 loops=1)

100. 11.557 72.452 ↑ 1.0 24,293 1

Sort (cost=2,255.390..2,316.130 rows=24,293 width=88) (actual time=65.278..72.452 rows=24,293 loops=1)

  • Sort Key: india_papa1.charlie_alpha_yankee
101. 60.895 60.895 ↑ 1.0 9,970 1

CTE Scan on sierra_zulu kilo (cost=0.000..201.080 rows=10,054 width=24) (actual time=0.029..60.895 rows=9,970 loops=1)

102. 72.452 72.452 ↑ 1.0 24,293 1

Sort (cost=2,255.390..2,316.130 rows=24,293 width=88) (actual time=65.278..72.452 rows=24,293 loops=1)

  • Sort Key: india_papa1.charlie_alpha_yankee
103. 22.805 990.697 ↑ 13.0 34,959 1

Subquery Scan on four_sierra_quebec (cost=59,813,487.330..63,223,016.340 rows=454,452 width=76) (actual time=933.656..990.697 rows=34,959 loops=1)

  • Filter: (four_sierra_quebec.alpha_four = 'november_victor'::text)
  • Rows Removed by Filter: 1232
104. 22.311 967.892 ↑ 2,511.4 36,191 1

Unique (cost=59,813,487.330..62,085,749.250 rows=90,890,477 width=192) (actual time=933.637..967.892 rows=36,191 loops=1)

105. 57.837 945.581 ↑ 2,511.4 36,191 1

Sort (cost=59,813,487.330..60,040,713.520 rows=90,890,477 width=192) (actual time=933.636..945.581 rows=36,191 loops=1)

  • Sort Key: ((((((six_whiskey.five_echo)::date))::timestamp without time zone))::timestamp with time zone), six_whiskey.charlie_alpha_yankee, six_whiskey.hotel_romeo, six_whiskey.zulu, six_whiskey.november_juliet, six_whiskey.echo_charlie, juliet_india
  • Sort Method: external merge Disk: 3744kB
106. 14.165 887.744 ↑ 2,511.4 36,191 1

Append (cost=735,346.380..14,247,467.220 rows=90,890,477 width=192) (actual time=256.973..887.744 rows=36,191 loops=1)

107. 15.399 297.840 ↑ 64.6 27,478 1

Result (cost=735,346.380..801,873.810 rows=1,774,065 width=192) (actual time=256.971..297.840 rows=27,478 loops=1)

108. 16.997 282.441 ↑ 64.6 27,478 1

Unique (cost=735,346.380..779,698.000 rows=1,774,065 width=192) (actual time=256.954..282.441 rows=27,478 loops=1)

109. 43.999 265.444 ↑ 64.6 27,478 1

Sort (cost=735,346.380..739,781.540 rows=1,774,065 width=192) (actual time=256.953..265.444 rows=27,478 loops=1)

  • Sort Key: ((((six_whiskey.five_echo)::date))::timestamp without time zone), six_whiskey.charlie_alpha_yankee, six_whiskey.hotel_romeo, six_whiskey.zulu, six_whiskey.november_juliet, six_whiskey.echo_charlie, six_whiskey
  • Sort Method: external sort Disk: 2816kB
110. 10.727 221.445 ↑ 64.6 27,478 1

Append (cost=370.120..223,764.610 rows=1,774,065 width=192) (actual time=8.662..221.445 rows=27,478 loops=1)

111. 4.701 10.584 ↑ 1.0 3,302 1

HashAggregate (cost=370.120..411.520 rows=3,312 width=192) (actual time=8.660..10.584 rows=3,302 loops=1)

  • Group Key: ((six_whiskey.five_echo)::date), six_whiskey.charlie_alpha_yankee, six_whiskey.hotel_romeo, six_whiskey.zulu, six_whiskey.november_juliet, six_whiskey.echo_charlie, six_whiskey.three_kilo, tango_whiskey
112. 1.293 5.883 ↓ 1.0 3,328 1

Append (cost=0.000..295.600 rows=3,312 width=188) (actual time=0.022..5.883 rows=3,328 loops=1)

113. 0.960 0.960 ↑ 1.0 1,258 1

Seq Scan on six_whiskey (cost=0.000..63.870 rows=1,258 width=90) (actual time=0.022..0.960 rows=1,258 loops=1)

114. 0.994 3.273 ↑ 1.0 2,036 1

Subquery Scan on echo_uniform (cost=0.000..194.170 rows=2,036 width=259) (actual time=0.023..3.273 rows=2,036 loops=1)

115. 2.279 2.279 ↑ 1.0 2,036 1

Seq Scan on five_mike (cost=0.000..168.720 rows=2,036 width=259) (actual time=0.019..2.279 rows=2,036 loops=1)

116. 0.028 0.357 ↓ 1.9 34 1

Subquery Scan on bravo_seven (cost=23.370..24.980 rows=18 width=188) (actual time=0.207..0.357 rows=34 loops=1)

117. 0.065 0.329 ↓ 1.9 34 1

Hash Join (cost=23.370..24.580 rows=18 width=188) (actual time=0.197..0.329 rows=34 loops=1)

  • Hash Cond: (alpha_november.charlie_alpha_yankee = juliet_juliet2.quebec_seven)
118.          

CTE sierra_zulu

119. 0.066 0.066 ↑ 1.0 18 1

Seq Scan on sierra_zulu five_hotel_uniform (cost=0.000..17.270 rows=18 width=584) (actual time=0.016..0.066 rows=18 loops=1)

  • Filter: (NOT victor_foxtrot)
120.          

CTE alpha_november

121. 0.052 0.052 ↑ 1.0 34 1

Seq Scan on oscar_whiskey five_quebec (cost=0.000..5.510 rows=34 width=160) (actual time=0.010..0.052 rows=34 loops=1)

122. 0.119 0.119 ↑ 1.0 34 1

CTE Scan on alpha_november (cost=0.000..0.680 rows=34 width=88) (actual time=0.016..0.119 rows=34 loops=1)

123. 0.005 0.145 ↑ 1.0 18 1

Hash (cost=0.360..0.360 rows=18 width=24) (actual time=0.145..0.145 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
124. 0.140 0.140 ↑ 1.0 18 1

CTE Scan on sierra_zulu charlie_delta (cost=0.000..0.360 rows=18 width=24) (actual time=0.025..0.140 rows=18 loops=1)

125. 11.075 200.134 ↑ 73.2 24,176 1

Subquery Scan on four_golf (cost=7,301.470..223,353.080 rows=1,770,753 width=192) (actual time=130.624..200.134 rows=24,176 loops=1)

126. 17.966 189.059 ↑ 73.2 24,176 1

Hash Left Join (cost=7,301.470..201,218.670 rows=1,770,753 width=192) (actual time=130.620..189.059 rows=24,176 loops=1)

  • Hash Cond: ((CASE WHEN ((india_papa1.zulu = ''delta_three'%foxtrot_uniform%yankee_romeo%'charlie_alpha_lima'whiskey_uniform211victor_india'::text WHEN ((india_papa1.zulu =
127. 30.576 171.067 ↑ 50.6 24,116 1

Merge Join (cost=7,284.950..53,130.560 rows=1,221,209 width=192) (actual time=130.568..171.067 rows=24,116 loops=1)

  • Merge Cond: (juliet_juliet3.quebec_seven = india_papa1.charlie_alpha_yankee)
128.          

CTE sierra_zulu

129. 20.518 20.518 ↑ 1.0 9,970 1

Seq Scan on sierra_zulu (cost=0.000..2,382.720 rows=10,054 width=759) (actual time=0.021..20.518 rows=9,970 loops=1)

  • Filter: ((NOT victor_foxtrot) AND (two_five <> golf_five))
  • Rows Removed by Filter: 136
130.          

CTE alpha_november

131. 21.189 21.189 ↑ 1.0 24,293 1

Seq Scan on oscar_whiskey (cost=0.000..1,777.390 rows=24,293 width=150) (actual time=0.015..21.189 rows=24,293 loops=1)

132. 7.144 68.039 ↑ 1.0 9,970 1

Sort (cost=869.440..894.580 rows=10,054 width=24) (actual time=65.249..68.039 rows=9,970 loops=1)

  • Sort Key: juliet_juliet3.quebec_seven
  • Sort Method: quicksort Memory: 1163kB
133. 60.895 60.895 ↑ 1.0 9,970 1

CTE Scan on sierra_zulu kilo (cost=0.000..201.080 rows=10,054 width=24) (actual time=0.029..60.895 rows=9,970 loops=1)

134. 19.580 72.452 ↑ 1.0 24,293 1

Sort (cost=2,255.390..2,316.130 rows=24,293 width=88) (actual time=65.278..72.452 rows=24,293 loops=1)

  • Sort Key: india_papa1.charlie_alpha_yankee
  • Sort Method: quicksort Memory: 3839kB
135. 52.872 52.872 ↑ 1.0 24,293 1

CTE Scan on alpha_november three_uniform (cost=0.000..485.860 rows=24,293 width=88) (actual time=0.019..52.872 rows=24,293 loops=1)

136. 0.012 0.026 ↑ 16.1 18 1

Hash (cost=12.900..12.900 rows=290 width=248) (actual time=0.026..0.026 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
137. 0.014 0.014 ↑ 16.1 18 1

Seq Scan on echo_echo five_hotel_lima (cost=0.000..12.900 rows=290 width=248) (actual time=0.008..0.014 rows=18 loops=1)

138. 4.702 575.739 ↑ 10,228.0 8,713 1

Subquery Scan on india_quebec (cost=5,404,964.360..13,445,593.410 rows=89,116,412 width=192) (actual time=510.594..575.739 rows=8,713 loops=1)

139. 571.037 571.037 ↑ 10,228.0 8,713 1

CTE Scan on seven_four (cost=5,404,964.360..10,994,892.080 rows=89,116,412 width=192) (actual time=510.588..571.037 rows=8,713 loops=1)

  • Filter: (two_golf AND (hotel_whiskey !~~ 'echo_hotel_uniform'::text))
  • Rows Removed by Filter: 2375
140.          

CTE seven_four

141. 28.687 556.444 ↑ 16,155.2 11,088 1

Merge Right Join (cost=475,204.890..3,613,679.690 rows=179,128,467 width=329) (actual time=510.567..556.444 rows=11,088 loops=1)

  • Merge Cond: (quebec_uniform.uniform_quebec = yankee_papa.quebec_seven)
142.          

CTE yankee_five

143. 3.510 3.510 ↑ 1.0 11,054 1

Seq Scan on three_golf (cost=0.000..1,136.540 rows=11,054 width=1,312) (actual time=0.013..3.510 rows=11,054 loops=1)

144.          

CTE yankee_papa

145. 7.943 7.943 ↓ 1.0 26,203 1

Seq Scan on seven_uniform (cost=0.000..2,250.010 rows=26,201 width=582) (actual time=0.012..7.943 rows=26,203 loops=1)

146.          

CTE quebec_uniform

147. 7.409 7.409 ↓ 1.1 26,294 1

Seq Scan on tango_india (cost=0.000..1,529.630 rows=24,863 width=429) (actual time=0.014..7.409 rows=26,294 loops=1)

148. 232.495 273.575 ↓ 1.1 26,294 1

Sort (cost=2,312.470..2,374.630 rows=24,863 width=144) (actual time=264.808..273.575 rows=26,294 loops=1)

  • Sort Key: quebec_uniform.uniform_quebec
  • Sort Method: external merge Disk: 2872kB
149. 41.080 41.080 ↓ 1.1 26,294 1

CTE Scan on quebec_uniform (cost=0.000..497.260 rows=24,863 width=144) (actual time=0.018..41.080 rows=26,294 loops=1)

150. 4.605 254.182 ↑ 130.0 11,088 1

Materialize (cost=467,976.240..475,180.860 rows=1,440,924 width=209) (actual time=245.590..254.182 rows=11,088 loops=1)

151. 46.411 249.577 ↑ 130.4 11,054 1

Sort (cost=467,976.240..471,578.550 rows=1,440,924 width=209) (actual time=245.586..249.577 rows=11,054 loops=1)

  • Sort Key: yankee_papa.quebec_seven
  • Sort Method: quicksort Memory: 3037kB
152. 18.504 203.166 ↑ 130.4 11,054 1

Merge Left Join (cost=3,406.220..25,075.070 rows=1,440,924 width=209) (actual time=178.518..203.166 rows=11,054 loops=1)

  • Merge Cond: (yankee_five.quebec_seven = yankee_papa.lima_two)
153. 54.573 77.439 ↓ 1.0 11,054 1

Sort (cost=959.390..986.890 rows=10,999 width=121) (actual time=74.415..77.439 rows=11,054 loops=1)

  • Sort Key: yankee_five.quebec_seven
  • Sort Method: quicksort Memory: 1939kB
154. 22.866 22.866 ↓ 1.0 11,054 1

CTE Scan on yankee_five (cost=0.000..221.080 rows=10,999 width=121) (actual time=0.020..22.866 rows=11,054 loops=1)

  • Filter: (echo_hotel_charlie five_romeo NOT NULL)
155. 60.740 107.223 ↑ 2.9 8,909 1

Sort (cost=2,446.820..2,512.330 rows=26,201 width=120) (actual time=104.092..107.223 rows=8,909 loops=1)

  • Sort Key: yankee_papa.lima_two
  • Sort Method: external sort Disk: 2448kB
156. 46.483 46.483 ↓ 1.0 26,203 1

CTE Scan on yankee_papa (cost=0.000..524.020 rows=26,201 width=120) (actual time=0.018..46.483 rows=26,203 loops=1)

157. 0.966 0.966 ↑ 1.0 1,276 1

Seq Scan on sierra_golf (cost=0.000..58.030 rows=1,276 width=28) (actual time=0.110..0.966 rows=1,276 loops=1)

  • Filter: (seven_papa <> 'charlie_victor'::text)
  • Rows Removed by Filter: 456
158. 1,056.735 1,056.735 ↑ 76.2 5,767 1

CTE Scan on november_alpha (cost=0.000..11,103.450 rows=439,708 width=44) (actual time=1,047.910..1,056.735 rows=5,767 loops=1)

  • Filter: ((seven_papa <> 'whiskey_two'::text) AND (seven_papa <> 'whiskey_four'::text))
  • Rows Removed by Filter: 653
159. 0.012 0.028 ↓ 2.3 16 1

Hash (cost=26.620..26.620 rows=7 width=11) (actual time=0.028..0.028 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
160. 0.016 0.016 ↓ 2.3 16 1

Seq Scan on hotel_mike zulu (cost=0.000..26.620 rows=7 width=11) (actual time=0.011..0.016 rows=16 loops=1)

  • Filter: (CASE WHEN (sierra_charlie five_romeo NOT NULL) THEN 'whiskey_seven'::text ELSE 'mike_five'::text END = 'whiskey_seven'::text)
  • Rows Removed by Filter: 12
161. 0.585 31,297.593 ↓ 4.1 813 1

Hash Full Join (cost=6.500..18.000 rows=200 width=32) (actual time=31,294.560..31,297.593 rows=813 loops=1)

  • Hash Cond: (sierra_hotel.five_echo = sierra_charlie.five_echo)
162. 30,234.223 30,234.223 ↓ 4.0 797 1

CTE Scan on sierra_hotel (cost=0.000..4.000 rows=200 width=16) (actual time=30,231.751..30,234.223 rows=797 loops=1)

163. 0.193 1,062.785 ↓ 3.5 700 1

Hash (cost=4.000..4.000 rows=200 width=16) (actual time=1,062.785..1,062.785 rows=700 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
164. 1,062.592 1,062.592 ↓ 3.5 700 1

CTE Scan on sierra_charlie (cost=0.000..4.000 rows=200 width=16) (actual time=1,060.991..1,062.592 rows=700 loops=1)