explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XVUc : union all

Settings
# exclusive inclusive rows x rows loops node
1. 5.205 1,672,097.257 ↓ 0.0 0 1

ModifyTable (cost=65,574.410..65,574.440 rows=1 width=1,138) (actual time=1,672,097.257..1,672,097.257 rows=0 loops=1)

2. 3.539 1,672,092.052 ↓ 1,619.0 1,619 1

Subquery Scan on yankee_victor (cost=65,574.410..65,574.440 rows=1 width=1,138) (actual time=1,672,087.732..1,672,092.052 rows=1,619 loops=1)

3. 0.726 1,672,088.513 ↓ 1,619.0 1,619 1

Unique (cost=65,574.410..65,574.430 rows=1 width=928) (actual time=1,672,087.677..1,672,088.513 rows=1,619 loops=1)

4. 12.849 1,672,087.787 ↓ 1,619.0 1,619 1

Sort (cost=65,574.410..65,574.410 rows=1 width=928) (actual time=1,672,087.675..1,672,087.787 rows=1,619 loops=1)

  • Sort Method: quicksort Memory: 774kB
5. 2.188 1,672,074.938 ↓ 1,619.0 1,619 1

Nested Loop (cost=34,919.860..65,574.410 rows=1 width=928) (actual time=1,650,784.777..1,672,074.938 rows=1,619 loops=1)

6. 2.170 1,671,753.807 ↓ 1,619.0 1,619 1

Nested Loop (cost=34,919.860..65,521.750 rows=1 width=947) (actual time=1,650,784.506..1,671,753.807 rows=1,619 loops=1)

7. 1.501 1,671,728.971 ↓ 1,619.0 1,619 1

Nested Loop (cost=34,919.780..65,519.870 rows=1 width=966) (actual time=1,650,784.482..1,671,728.971 rows=1,619 loops=1)

8. 0.214 1,671,692.904 ↓ 548.7 1,646 1

Append (cost=34,919.690..65,507.600 rows=3 width=928) (actual time=1,650,784.436..1,671,692.904 rows=1,646 loops=1)

9. 0.675 1,670,553.899 ↓ 596.5 1,193 1

Result (cost=34,919.690..51,929.170 rows=2 width=950) (actual time=1,650,784.435..1,670,553.899 rows=1,193 loops=1)

10. 0.129 1,670,553.224 ↓ 596.5 1,193 1

Append (cost=34,919.690..51,929.160 rows=2 width=946) (actual time=1,650,784.431..1,670,553.224 rows=1,193 loops=1)

11. 0.976 1,650,785.695 ↓ 1,189.0 1,189 1

Unique (cost=34,919.690..34,919.700 rows=1 width=344) (actual time=1,650,784.430..1,650,785.695 rows=1,189 loops=1)

12. 11.679 1,650,784.719 ↓ 1,189.0 1,189 1

Sort (cost=34,919.690..34,919.690 rows=1 width=344) (actual time=1,650,784.428..1,650,784.719 rows=1,189 loops=1)

  • Sort Method: quicksort Memory: 661kB
13. 60.955 1,650,773.040 ↓ 1,189.0 1,189 1

Nested Loop (cost=22,189.140..34,919.690 rows=1 width=344) (actual time=12,958.929..1,650,773.040 rows=1,189 loops=1)

14. 5.814 1,650,676.415 ↓ 1,189.0 1,189 1

Nested Loop (cost=22,189.050..34,919.450 rows=1 width=440) (actual time=12,958.853..1,650,676.415 rows=1,189 loops=1)

15. 135.909 1,650,649.199 ↓ 1,189.0 1,189 1

Nested Loop (cost=22,189.000..34,919.380 rows=1 width=417) (actual time=12,958.820..1,650,649.199 rows=1,189 loops=1)

16. 7,361.620 1,648,785.149 ↓ 1,191.0 1,191 1

Nested Loop (cost=14,841.310..27,546.090 rows=1 width=330) (actual time=12,930.690..1,648,785.149 rows=1,191 loops=1)

17. 38.124 181.405 ↓ 9,756.0 9,756 1

Hash Join (cost=252.500..2,927.580 rows=1 width=38) (actual time=4.272..181.405 rows=9,756 loops=1)

18. 139.279 140.194 ↓ 7.8 9,772 1

Bitmap Heap Scan on hotel_golf papa_juliet (cost=100.450..2,773.650 rows=1,246 width=42) (actual time=1.170..140.194 rows=9,772 loops=1)

  • Filter: ((whiskey_yankee five_romeo_foxtrot NOT NULL) AND (whiskey_yankee <= ((('hotel_two'::cstring)::date + 'two_three'::interval) - 'seven_oscar'::interval)))
19. 0.915 0.915 ↓ 1.0 10,891 1

Bitmap Index Scan on papa_lima (cost=0.000..100.380 rows=10,867 width=0) (actual time=0.915..0.915 rows=10,891 loops=1)

  • Index Cond: ((romeo_quebec_zulu)::text = 'xray_uniform'::text)
20. 1.659 3.087 ↑ 1.0 9,865 1

Hash (cost=112.590..112.590 rows=9,865 width=23) (actual time=3.087..3.087 rows=9,865 loops=1)

21. 1.428 1.428 ↑ 1.0 9,865 1

Seq Scan on hotel_seven oscar_victor (cost=0.000..112.590 rows=9,865 width=23) (actual time=0.012..1.428 rows=9,865 loops=1)

22. 15,441.054 1,641,242.124 ↓ 26.0 1,661 9,756

Hash Join (cost=14,588.800..24,618.220 rows=64 width=311) (actual time=0.128..168.229 rows=1,661 loops=9,756)

23. 13,951.080 1,625,408.136 ↓ 26.0 1,661 9,756

Nested Loop (cost=4,102.320..14,131.690 rows=64 width=279) (actual time=0.086..166.606 rows=1,661 loops=9,756)

24. 22,243.680 1,417,000.464 ↓ 25.6 1,661 9,756

Nested Loop (cost=4,102.240..14,120.370 rows=65 width=279) (actual time=0.072..145.244 rows=1,661 loops=9,756)

25. 20,048.580 1,220,417.064 ↓ 7.0 1,787 9,756

Nested Loop (cost=4,102.150..13,989.720 rows=255 width=290) (actual time=0.060..125.094 rows=1,787 loops=9,756)

26. 11,560.850 956,292.876 ↓ 5.9 1,787 9,756

Hash Join (cost=4,102.070..13,921.690 rows=302 width=290) (actual time=0.043..98.021 rows=1,787 loops=9,756)

27. 13,251.869 944,732.016 ↓ 1.0 1,787 9,756

Hash Join (cost=4,101.050..13,918.470 rows=1,734 width=269) (actual time=0.042..96.836 rows=1,787 loops=9,756)

28. 4,507.272 931,424.832 ↓ 1.0 1,787 9,756

Nested Loop (cost=0.080..9,816.590 rows=1,734 width=146) (actual time=0.036..95.472 rows=1,787 loops=9,756)

29. 560,804.148 560,804.148 ↓ 1.0 1,787 9,756

Seq Scan on five_romeo_golf lima_juliet (cost=0.000..5,876.860 rows=1,734 width=29) (actual time=0.010..57.483 rows=1,787 loops=9,756)

  • Filter: ((uniform_mike_four_foxtrot = 2018) AND (kilo_bravo = 11))
30. 366,113.412 366,113.412 ↑ 1.0 1 17,433,972

Index Scan using foxtrot_golf on mike_four xray_yankee_golf (cost=0.080..2.270 rows=1 width=117) (actual time=0.021..0.021 rows=1 loops=17,433,972)

  • Index Cond: ((india_sierra)::text = (lima_juliet.mike_delta)::text)
31. 1.304 55.315 ↑ 1.1 4,418 1

Hash (cost=4,084.620..4,084.620 rows=4,670 width=123) (actual time=55.315..55.315 rows=4,418 loops=1)

32. 0.631 54.011 ↑ 1.1 4,418 1

Subquery Scan on foxtrot_sierra (cost=4,056.600..4,084.620 rows=4,670 width=123) (actual time=51.138..54.011 rows=4,418 loops=1)

33. 6.282 53.380 ↑ 1.1 4,418 1

Aggregate (cost=4,056.600..4,070.610 rows=4,670 width=139) (actual time=51.137..53.380 rows=4,418 loops=1)

34. 9.752 47.098 ↑ 1.0 4,660 1

Hash Join (cost=1,115.400..4,023.910 rows=4,670 width=123) (actual time=12.760..47.098 rows=4,660 loops=1)

35. 24.622 24.622 ↑ 1.0 67,257 1

Seq Scan on hotel_golf uniform_zulu (cost=0.000..2,810.240 rows=67,412 width=38) (actual time=0.005..24.622 rows=67,257 loops=1)

36. 1.349 12.724 ↑ 1.0 4,660 1

Hash (cost=1,099.030..1,099.030 rows=4,677 width=123) (actual time=12.724..12.724 rows=4,660 loops=1)

37. 11.375 11.375 ↑ 1.0 4,667 1

Seq Scan on tango_foxtrot lima_yankee (cost=0.000..1,099.030 rows=4,677 width=123) (actual time=0.011..11.375 rows=4,667 loops=1)

38. 0.002 0.010 ↑ 1.0 3 1

Hash (cost=1.010..1.010 rows=3 width=27) (actual time=0.010..0.010 rows=3 loops=1)

39. 0.008 0.008 ↑ 1.0 3 1

Seq Scan on six_whiskey zulu_november (cost=0.000..1.010 rows=3 width=27) (actual time=0.007..0.008 rows=3 loops=1)

40. 244,075.608 244,075.608 ↑ 1.0 1 17,433,972

Index Scan using two_romeo on bravo_kilo uniform_yankee (cost=0.080..0.230 rows=1 width=38) (actual time=0.014..0.014 rows=1 loops=17,433,972)

  • Index Cond: ((india_sierra)::text = (romeo_mike1.bravo_kilo)::text)
41. 174,339.720 174,339.720 ↑ 1.0 1 17,433,972

Index Scan using six_lima on zulu_india_quebec zulu_mike (cost=0.080..0.510 rows=1 width=27) (actual time=0.010..0.010 rows=1 loops=17,433,972)

  • Index Cond: ((india_sierra)::text = (uniform_yankee.lima_five)::text)
42. 194,456.592 194,456.592 ↑ 1.0 1 16,204,716

Index Only Scan using quebec_echo on delta_golf delta_golf (cost=0.080..0.170 rows=1 width=19) (actual time=0.012..0.012 rows=1 loops=16,204,716)

  • Index Cond: (india_sierra = (romeo_mike1.victor_november)::text)
43. 1.583 392.934 ↓ 9,183.0 9,183 1

Hash (cost=10,486.480..10,486.480 rows=1 width=51) (actual time=392.934..392.934 rows=9,183 loops=1)

44. 1.168 391.351 ↓ 9,183.0 9,183 1

Subquery Scan on xray_yankee_two (cost=10,486.470..10,486.480 rows=1 width=51) (actual time=380.460..391.351 rows=9,183 loops=1)

45. 8.557 390.183 ↓ 9,183.0 9,183 1

Aggregate (cost=10,486.470..10,486.480 rows=1 width=75) (actual time=380.459..390.183 rows=9,183 loops=1)

46. 78.988 381.626 ↓ 9,190.0 9,190 1

Sort (cost=10,486.470..10,486.470 rows=1 width=43) (actual time=380.432..381.626 rows=9,190 loops=1)

  • Sort Method: quicksort Memory: 1305kB
47. 5.485 302.638 ↓ 9,190.0 9,190 1

Nested Loop (cost=1,410.040..10,486.470 rows=1 width=43) (actual time=143.321..302.638 rows=9,190 loops=1)

48. 7.105 167.723 ↓ 543.8 9,245 1

Hash Join (cost=1,409.960..10,477.610 rows=17 width=35) (actual time=143.249..167.723 rows=9,245 loops=1)

49. 5.601 154.607 ↓ 545.6 9,276 1

Hash Join (cost=797.910..9,865.500 rows=17 width=48) (actual time=137.206..154.607 rows=9,276 loops=1)

50. 138.165 138.165 ↓ 618.3 9,275 1

Seq Scan on charlie_six quebec_kilo (cost=0.000..9,063.730 rows=15 width=20) (actual time=126.310..138.165 rows=9,275 loops=1)

  • Filter: ((echo_tango('quebec_four_delta'::text, india_quebec) = 'zulu_india_two'::double precision) AND (echo_tango('kilo_lima'::text, india_quebec) = 'lima_two_victor'::double precision))
51. 1.504 10.841 ↓ 1.0 10,163 1

Hash (cost=762.340..762.340 rows=10,162 width=40) (actual time=10.841..10.841 rows=10,163 loops=1)

52. 0.749 9.337 ↓ 1.0 10,163 1

Append (cost=0.000..762.340 rows=10,162 width=40) (actual time=0.089..9.337 rows=10,163 loops=1)

53. 0.002 1.619 ↓ 2.0 2 1

Subquery Scan on victor_victor (cost=0.000..240.570 rows=1 width=40) (actual time=0.088..1.619 rows=2 loops=1)

54. 1.617 1.617 ↓ 2.0 2 1

Seq Scan on five_sierra five_sierra (cost=0.000..240.560 rows=1 width=52) (actual time=0.087..1.617 rows=2 loops=1)

  • Filter: (november_lima ~~ 'uniform_tango'::text)
55. 0.001 1.203 ↓ 2.0 2 1

Subquery Scan on bravo_alpha (cost=0.000..240.570 rows=1 width=40) (actual time=0.051..1.203 rows=2 loops=1)

56. 1.202 1.202 ↓ 2.0 2 1

Seq Scan on five_sierra tango_charlie (cost=0.000..240.560 rows=1 width=52) (actual time=0.050..1.202 rows=2 loops=1)

  • Filter: (november_lima ~~ 'uniform_tango'::text)
57. 0.936 5.766 ↑ 1.0 10,159 1

Subquery Scan on bravo_bravo_kilo (cost=0.000..281.200 rows=10,160 width=40) (actual time=0.011..5.766 rows=10,159 loops=1)

58. 4.830 4.830 ↑ 1.0 10,159 1

Seq Scan on five_sierra five_quebec (cost=0.000..250.720 rows=10,160 width=52) (actual time=0.010..4.830 rows=10,159 loops=1)

  • Filter: (november_lima !~~ 'uniform_tango'::text)
59. 2.146 6.011 ↑ 1.0 13,677 1

Hash (cost=564.100..564.100 rows=13,700 width=28) (actual time=6.011..6.011 rows=13,677 loops=1)

60. 3.865 3.865 ↑ 1.0 13,677 1

Seq Scan on yankee_charlie whiskey_tango (cost=0.000..564.100 rows=13,700 width=28) (actual time=0.011..3.865 rows=13,677 loops=1)

61. 129.430 129.430 ↑ 1.0 1 9,245

Index Scan using romeo_quebec_uniform on hotel_golf foxtrot_india (cost=0.080..0.520 rows=1 width=38) (actual time=0.014..0.014 rows=1 loops=9,245)

  • Index Cond: ((india_sierra)::text = (whiskey_tango.golf_whiskey)::text)
  • Filter: ((charlie_charlie five_romeo_foxtrot NOT NULL) AND (echo_seven five_romeo_foxtrot NOT NULL) AND (charlie_charlie <= ((('hotel_two'::cstring)::date + 'two_three'::interval) - 'seven_oscar'::interval)))
62. 1,568.547 1,728.141 ↑ 1.3 1,307 1,191

Aggregate (cost=7,347.690..7,361.880 rows=1,756 width=110) (actual time=0.037..1.451 rows=1,307 loops=1,191)

63. 142.345 159.594 ↓ 1.1 1,937 1,191

Sort (cost=7,347.690..7,348.590 rows=1,790 width=56) (actual time=0.024..0.134 rows=1,937 loops=1,191)

  • Sort Method: quicksort Memory: 320kB
64. 2.577 17.249 ↓ 1.1 1,937 1

Bitmap Heap Scan on oscar_charlie oscar_charlie (cost=4,983.340..7,328.350 rows=1,790 width=56) (actual time=14.830..17.249 rows=1,937 loops=1)

65. 14.672 14.672 ↓ 1.1 1,937 1

Bitmap Index Scan on uniform_november (cost=0.000..4,983.250 rows=1,790 width=0) (actual time=14.672..14.672 rows=1,937 loops=1)

  • Index Cond: ((victor_tango = 2018) AND (four = 11))
66. 21.402 21.402 ↑ 1.0 1 1,189

Index Scan using papa_yankee on india_xray lima_india (cost=0.060..0.070 rows=1 width=23) (actual time=0.018..0.018 rows=1 loops=1,189)

  • Index Cond: ((mike_delta)::text = (romeo_mike1.india_sierra)::text)
67. 35.670 35.670 ↑ 1.0 1 1,189

Index Scan using six_mike on hotel_golf hotel_golf (cost=0.080..0.230 rows=1 width=123) (actual time=0.025..0.030 rows=1 loops=1,189)

  • Index Cond: ((mike_four)::text = (romeo_mike1.india_sierra)::text)
  • Filter: ((romeo_quebec_zulu)::text = 'uniform_oscar'::text)
68. 0.009 19,767.400 ↓ 4.0 4 1

Subquery Scan on echo_uniform (cost=17,009.440..17,009.450 rows=1 width=344) (actual time=19,767.391..19,767.400 rows=4 loops=1)

69. 0.006 19,767.391 ↓ 4.0 4 1

Unique (cost=17,009.440..17,009.450 rows=1 width=284) (actual time=19,767.385..19,767.391 rows=4 loops=1)

70. 0.051 19,767.385 ↓ 4.0 4 1

Sort (cost=17,009.440..17,009.440 rows=1 width=284) (actual time=19,767.384..19,767.385 rows=4 loops=1)

  • Sort Method: quicksort Memory: 26kB
71. 4.829 19,767.334 ↓ 4.0 4 1

Nested Loop (cost=13,651.090..17,009.440 rows=1 width=284) (actual time=2,485.020..19,767.334 rows=4 loops=1)

  • Filter: (hotel_victor((lima_sierra(sierra_charlie1.india_sierra, ''::character varying))::text) = 0)
72. 2,874.970 19,728.633 ↓ 1,168.0 1,168 1

Nested Loop (cost=13,651.010..17,008.960 rows=1 width=356) (actual time=909.612..19,728.633 rows=1,168 loops=1)

73. 35.315 13,270.239 ↓ 1,168.0 1,168 1

Hash Join (cost=13,651.010..16,395.000 rows=1 width=337) (actual time=904.250..13,270.239 rows=1,168 loops=1)

74. 22.200 12,487.955 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,309.520..7,033.670 rows=1 width=292) (actual time=61.431..12,487.955 rows=7,468 loops=1)

75. 12.331 12,458.287 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,309.520..7,032.650 rows=1 width=271) (actual time=61.419..12,458.287 rows=7,468 loops=1)

76. 11.405 12,341.404 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,309.430..7,032.310 rows=1 width=252) (actual time=61.394..12,341.404 rows=7,468 loops=1)

77. 2,145.455 12,217.979 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,309.350..7,031.230 rows=1 width=271) (actual time=61.356..12,217.979 rows=7,468 loops=1)

78. 19.079 662.844 ↓ 7,468.0 7,468 1

Nested Loop (cost=252.750..2,930.260 rows=1 width=148) (actual time=4.477..662.844 rows=7,468 loops=1)

79. 10.768 557.221 ↓ 9,616.0 9,616 1

Nested Loop (cost=252.670..2,929.750 rows=1 width=159) (actual time=4.453..557.221 rows=9,616 loops=1)

80. 10.171 392.453 ↓ 9,625.0 9,625 1

Nested Loop (cost=252.580..2,929.270 rows=1 width=159) (actual time=4.429..392.453 rows=9,625 loops=1)

81. 13.201 40.822 ↓ 9,756.0 9,756 1

Hash Join (cost=252.500..2,927.580 rows=1 width=61) (actual time=4.266..40.822 rows=9,756 loops=1)

82. 23.627 24.544 ↓ 7.8 9,772 1

Bitmap Heap Scan on hotel_golf golf_juliet (cost=100.450..2,773.650 rows=1,246 width=42) (actual time=1.170..24.544 rows=9,772 loops=1)

  • Filter: ((whiskey_yankee five_romeo_foxtrot NOT NULL) AND (whiskey_yankee <= ((('hotel_two'::cstring)::date + 'two_three'::interval) - 'seven_oscar'::interval)))
83. 0.917 0.917 ↓ 1.0 10,891 1

Bitmap Index Scan on papa_lima (cost=0.000..100.380 rows=10,867 width=0) (actual time=0.917..0.917 rows=10,891 loops=1)

  • Index Cond: ((romeo_quebec_zulu)::text = 'xray_uniform'::text)
84. 1.648 3.077 ↑ 1.0 9,865 1

Hash (cost=112.590..112.590 rows=9,865 width=23) (actual time=3.077..3.077 rows=9,865 loops=1)

85. 1.429 1.429 ↑ 1.0 9,865 1

Seq Scan on hotel_seven golf_golf (cost=0.000..112.590 rows=9,865 width=23) (actual time=0.025..1.429 rows=9,865 loops=1)

86. 341.460 341.460 ↑ 1.0 1 9,756

Index Scan using foxtrot_golf on mike_four echo_november (cost=0.080..1.700 rows=1 width=117) (actual time=0.035..0.035 rows=1 loops=9,756)

  • Index Cond: ((india_sierra)::text = (oscar_victor2.mike_delta)::text)
  • Filter: ((yankee_five)::text ~~ 'kilo_five'::text)
87. 154.000 154.000 ↑ 1.0 1 9,625

Index Scan using two_romeo on bravo_kilo sierra_juliet (cost=0.080..0.480 rows=1 width=38) (actual time=0.016..0.016 rows=1 loops=9,625)

  • Index Cond: ((india_sierra)::text = (romeo_mike2.bravo_kilo)::text)
88. 86.544 86.544 ↑ 1.0 1 9,616

Index Scan using six_lima on zulu_india_quebec zulu_xray (cost=0.080..0.510 rows=1 width=27) (actual time=0.009..0.009 rows=1 loops=9,616)

  • Index Cond: ((india_sierra)::text = (juliet_lima1.lima_five)::text)
89. 9,359.433 9,409.680 ↑ 1.3 3,534 7,468

Aggregate (cost=4,056.600..4,070.610 rows=4,670 width=139) (actual time=0.008..1.260 rows=3,534 loops=7,468)

90. 9.721 50.247 ↑ 1.0 4,660 1

Hash Join (cost=1,115.400..4,023.910 rows=4,670 width=123) (actual time=15.696..50.247 rows=4,660 loops=1)

91. 24.873 24.873 ↑ 1.0 67,257 1

Seq Scan on hotel_golf uniform_mike_four_tango (cost=0.000..2,810.240 rows=67,412 width=38) (actual time=0.015..24.873 rows=67,257 loops=1)

92. 1.466 15.653 ↑ 1.0 4,660 1

Hash (cost=1,099.030..1,099.030 rows=4,677 width=123) (actual time=15.653..15.653 rows=4,660 loops=1)

93. 14.187 14.187 ↑ 1.0 4,667 1

Seq Scan on tango_foxtrot two_juliet (cost=0.000..1,099.030 rows=4,677 width=123) (actual time=0.011..14.187 rows=4,667 loops=1)

94. 112.020 112.020 ↑ 1.0 1 7,468

Index Only Scan using six_lima on zulu_india_quebec lima_two_kilo (cost=0.080..1.080 rows=1 width=19) (actual time=0.015..0.015 rows=1 loops=7,468)

  • Index Cond: (india_sierra = (romeo_mike2.india_juliet)::text)
95. 104.552 104.552 ↑ 1.0 1 7,468

Index Only Scan using quebec_echo on delta_golf victor_lima (cost=0.080..0.330 rows=1 width=19) (actual time=0.014..0.014 rows=1 loops=7,468)

  • Index Cond: (india_sierra = (romeo_mike2.victor_november)::text)
96. 7.468 7.468 ↑ 1.0 3 7,468

Seq Scan on six_whiskey oscar_romeo (cost=0.000..1.010 rows=3 width=27) (actual time=0.001..0.001 rows=3 loops=7,468)

97. 84.338 746.969 ↓ 6.3 265,157 1

Hash (cost=9,153.580..9,153.580 rows=41,758 width=87) (actual time=746.969..746.969 rows=265,157 loops=1)

98. 40.477 662.631 ↓ 6.3 265,157 1

Subquery Scan on tango_tango (cost=8,861.280..9,153.580 rows=41,758 width=87) (actual time=363.751..662.631 rows=265,157 loops=1)

99. 578.533 622.154 ↓ 6.3 265,157 1

Aggregate (cost=8,861.280..9,028.310 rows=41,758 width=110) (actual time=363.750..622.154 rows=265,157 loops=1)

100. 43.621 43.621 ↑ 1.0 417,581 1

Seq Scan on oscar_charlie five_yankee (cost=0.000..7,399.740 rows=417,581 width=56) (actual time=0.010..43.621 rows=417,581 loops=1)

101. 3,583.424 3,583.424 ↑ 1.0 12,445 1,168

Seq Scan on yankee_charlie yankee_charlie (cost=0.000..564.100 rows=12,466 width=35) (actual time=0.003..3.068 rows=12,445 loops=1,168)

  • Filter: (xray_sierra five_romeo_foxtrot NULL)
102. 33.872 33.872 ↑ 1.0 1 1,168

Index Scan using six_mike on hotel_golf kilo_xray (cost=0.080..0.460 rows=1 width=38) (actual time=0.025..0.029 rows=1 loops=1,168)

  • Index Cond: ((romeo_mike2.india_sierra)::text = (mike_four)::text)
  • Filter: (((romeo_quebec_zulu)::text = 'romeo_two'::text) AND (charlie_charlie <= ((('hotel_two'::cstring)::date + 'two_three'::interval) - 'seven_oscar'::interval)))
103. 0.334 1,138.791 ↓ 453.0 453 1

Subquery Scan on bravo_seven (cost=13,578.420..13,578.430 rows=1 width=361) (actual time=1,138.026..1,138.791 rows=453 loops=1)

104. 0.346 1,138.457 ↓ 453.0 453 1

Unique (cost=13,578.420..13,578.430 rows=1 width=297) (actual time=1,138.020..1,138.457 rows=453 loops=1)

105. 2.403 1,138.111 ↓ 453.0 453 1

Sort (cost=13,578.420..13,578.420 rows=1 width=297) (actual time=1,138.019..1,138.111 rows=453 loops=1)

  • Sort Method: quicksort Memory: 145kB
106. 5.403 1,135.708 ↓ 453.0 453 1

Hash Join (cost=10,713.110..13,578.420 rows=1 width=297) (actual time=1,100.454..1,135.708 rows=453 loops=1)

107. 8.974 34.506 ↓ 1,092.3 15,292 1

Hash Join (cost=220.010..3,085.300 rows=14 width=134) (actual time=4.536..34.506 rows=15,292 loops=1)

108. 21.039 21.039 ↓ 1.0 20,027 1

Seq Scan on hotel_golf five_xray (cost=0.000..2,843.940 rows=19,855 width=123) (actual time=0.010..21.039 rows=20,027 loops=1)

  • Filter: ((romeo_quebec_zulu)::text = 'uniform_oscar'::text)
109. 2.512 4.493 ↑ 1.0 15,287 1

Hash (cost=158.860..158.860 rows=15,287 width=23) (actual time=4.493..4.493 rows=15,287 loops=1)

110. 1.981 1.981 ↑ 1.0 15,287 1

Seq Scan on india_xray victor_echo (cost=0.000..158.860 rows=15,287 width=23) (actual time=0.007..1.981 rows=15,287 loops=1)

111. 0.542 1,095.799 ↓ 453.0 453 1

Hash (cost=10,493.100..10,493.100 rows=1 width=210) (actual time=1,095.799..1,095.799 rows=453 loops=1)

112. 1.186 1,095.257 ↓ 453.0 453 1

Nested Loop (cost=10,486.970..10,493.100 rows=1 width=210) (actual time=373.273..1,095.257 rows=453 loops=1)

  • Filter: (hotel_victor((lima_sierra(sierra_charlie3.india_sierra, ''::character varying))::text) = 0)
113. 2.258 1,061.591 ↓ 1,624.0 1,624 1

Nested Loop (cost=10,486.890..10,492.850 rows=1 width=191) (actual time=373.230..1,061.591 rows=1,624 loops=1)

114. 10.230 936.918 ↓ 8,161.0 8,161 1

Nested Loop (cost=10,486.800..10,492.500 rows=1 width=162) (actual time=372.982..936.918 rows=8,161 loops=1)

115. 4.556 918.521 ↓ 8,167.0 8,167 1

Nested Loop (cost=10,486.800..10,491.480 rows=1 width=141) (actual time=372.966..918.521 rows=8,167 loops=1)

116. 18.558 815.961 ↓ 8,167.0 8,167 1

Nested Loop (cost=10,486.720..10,491.310 rows=1 width=141) (actual time=372.938..815.961 rows=8,167 loops=1)

117. 4.855 715.134 ↓ 9,141.0 9,141 1

Nested Loop (cost=10,486.640..10,490.800 rows=1 width=152) (actual time=372.908..715.134 rows=9,141 loops=1)

118. 7.583 581.717 ↓ 9,183.0 9,183 1

Nested Loop (cost=10,486.550..10,490.570 rows=1 width=152) (actual time=372.877..581.717 rows=9,183 loops=1)

119. 14.870 390.474 ↓ 9,183.0 9,183 1

Aggregate (cost=10,486.470..10,486.480 rows=1 width=75) (actual time=372.819..390.474 rows=9,183 loops=1)

120. 80.004 375.604 ↓ 9,190.0 9,190 1

Sort (cost=10,486.470..10,486.470 rows=1 width=43) (actual time=372.793..375.604 rows=9,190 loops=1)

  • Sort Method: quicksort Memory: 1305kB
121. 10.590 295.600 ↓ 9,190.0 9,190 1

Nested Loop (cost=1,410.040..10,486.470 rows=1 width=43) (actual time=142.725..295.600 rows=9,190 loops=1)

122. 5.618 164.825 ↓ 543.8 9,245 1

Hash Join (cost=1,409.960..10,477.610 rows=17 width=35) (actual time=142.675..164.825 rows=9,245 loops=1)

123. 4.977 153.501 ↓ 545.6 9,276 1

Hash Join (cost=797.910..9,865.500 rows=17 width=48) (actual time=136.939..153.501 rows=9,276 loops=1)

124. 137.883 137.883 ↓ 618.3 9,275 1

Seq Scan on charlie_six quebec_whiskey (cost=0.000..9,063.730 rows=15 width=20) (actual time=126.255..137.883 rows=9,275 loops=1)

  • Filter: ((echo_tango('quebec_four_delta'::text, india_quebec) = 'zulu_india_two'::double precision) AND (echo_tango('kilo_lima'::text, india_quebec) = 'lima_two_victor'::double precision))
125. 1.495 10.641 ↓ 1.0 10,163 1

Hash (cost=762.340..762.340 rows=10,162 width=40) (actual time=10.641..10.641 rows=10,163 loops=1)

126. 0.737 9.146 ↓ 1.0 10,163 1

Append (cost=0.000..762.340 rows=10,162 width=40) (actual time=0.084..9.146 rows=10,163 loops=1)

127. 0.001 1.573 ↓ 2.0 2 1

Subquery Scan on mike_echo (cost=0.000..240.570 rows=1 width=40) (actual time=0.084..1.573 rows=2 loops=1)

128. 1.572 1.572 ↓ 2.0 2 1

Seq Scan on five_sierra sierra_lima (cost=0.000..240.560 rows=1 width=52) (actual time=0.083..1.572 rows=2 loops=1)

  • Filter: (november_lima ~~ 'uniform_tango'::text)
129. 0.001 1.191 ↓ 2.0 2 1

Subquery Scan on juliet_hotel (cost=0.000..240.570 rows=1 width=40) (actual time=0.049..1.191 rows=2 loops=1)

130. 1.190 1.190 ↓ 2.0 2 1

Seq Scan on five_sierra bravo_bravo_four (cost=0.000..240.560 rows=1 width=52) (actual time=0.049..1.190 rows=2 loops=1)

  • Filter: (november_lima ~~ 'uniform_tango'::text)
131. 0.910 5.645 ↑ 1.0 10,159 1

Subquery Scan on foxtrot_november (cost=0.000..281.200 rows=10,160 width=40) (actual time=0.005..5.645 rows=10,159 loops=1)

132. 4.735 4.735 ↑ 1.0 10,159 1

Seq Scan on five_sierra seven_two (cost=0.000..250.720 rows=10,160 width=52) (actual time=0.004..4.735 rows=10,159 loops=1)

  • Filter: (november_lima !~~ 'uniform_tango'::text)
133. 2.161 5.706 ↑ 1.0 13,677 1

Hash (cost=564.100..564.100 rows=13,700 width=28) (actual time=5.706..5.706 rows=13,677 loops=1)

134. 3.545 3.545 ↑ 1.0 13,677 1

Seq Scan on yankee_charlie sierra_mike (cost=0.000..564.100 rows=13,700 width=28) (actual time=0.006..3.545 rows=13,677 loops=1)

135. 120.185 120.185 ↑ 1.0 1 9,245

Index Scan using romeo_quebec_uniform on hotel_golf delta_bravo (cost=0.080..0.520 rows=1 width=38) (actual time=0.013..0.013 rows=1 loops=9,245)

  • Index Cond: ((india_sierra)::text = (golf_bravo1.golf_whiskey)::text)
  • Filter: ((charlie_charlie five_romeo_foxtrot NOT NULL) AND (echo_seven five_romeo_foxtrot NOT NULL) AND (charlie_charlie <= ((('hotel_two'::cstring)::date + 'two_three'::interval) - 'seven_oscar'::interval)))
136. 183.660 183.660 ↑ 1.0 1 9,183

Index Scan using foxtrot_golf on mike_four six_victor (cost=0.080..4.090 rows=1 width=101) (actual time=0.020..0.020 rows=1 loops=9,183)

  • Index Cond: ((india_sierra)::text = (echo_five1.mike_four)::text)
137. 128.562 128.562 ↑ 1.0 1 9,183

Index Scan using two_romeo on bravo_kilo kilo_alpha (cost=0.080..0.230 rows=1 width=38) (actual time=0.014..0.014 rows=1 loops=9,183)

  • Index Cond: ((india_sierra)::text = (romeo_mike3.bravo_kilo)::text)
138. 82.269 82.269 ↑ 1.0 1 9,141

Index Scan using six_lima on zulu_india_quebec quebec_four_echo (cost=0.080..0.510 rows=1 width=27) (actual time=0.009..0.009 rows=1 loops=9,141)

  • Index Cond: ((india_sierra)::text = (juliet_lima2.lima_five)::text)
139. 98.004 98.004 ↑ 1.0 1 8,167

Index Only Scan using quebec_echo on delta_golf seven_xray (cost=0.080..0.170 rows=1 width=19) (actual time=0.012..0.012 rows=1 loops=8,167)

  • Index Cond: (india_sierra = (romeo_mike3.victor_november)::text)
140. 8.167 8.167 ↑ 1.0 3 8,167

Seq Scan on six_whiskey kilo_november (cost=0.000..1.010 rows=3 width=27) (actual time=0.000..0.001 rows=3 loops=8,167)

141. 122.415 122.415 ↓ 0.0 0 8,161

Index Scan using uniform_whiskey on five_romeo_golf delta_whiskey (cost=0.080..0.350 rows=1 width=29) (actual time=0.015..0.015 rows=0 loops=8,161)

  • Index Cond: (((mike_delta)::text = (romeo_mike3.india_sierra)::text) AND (uniform_mike_four_foxtrot = 2018) AND (kilo_bravo = 11))
142. 32.480 32.480 ↑ 1.0 1 1,624

Index Scan using six_mike on hotel_golf three_romeo (cost=0.080..0.240 rows=1 width=38) (actual time=0.018..0.020 rows=1 loops=1,624)

  • Index Cond: ((romeo_mike3.india_sierra)::text = (mike_four)::text)
  • Filter: (((romeo_quebec_zulu)::text = 'xray_uniform'::text) AND (whiskey_yankee <= ((('hotel_two'::cstring)::date + 'two_three'::interval) - 'seven_oscar'::interval)))
143. 34.566 34.566 ↑ 1.0 1 1,646

Index Scan using foxtrot_golf on mike_four mike_four (cost=0.080..4.090 rows=1 width=38) (actual time=0.021..0.021 rows=1 loops=1,646)

  • Index Cond: ((india_sierra)::text = (romeo_mike1.india_sierra)::text)
  • Filter: november_six
144. 22.666 22.666 ↑ 1.0 1 1,619

Index Scan using two_romeo on bravo_kilo bravo_kilo (cost=0.080..1.880 rows=1 width=19) (actual time=0.014..0.014 rows=1 loops=1,619)

  • Index Cond: ((india_sierra)::text = (mike_four.bravo_kilo)::text)
  • Filter: (lima_five five_romeo_foxtrot NOT NULL)
145. 318.943 318.943 ↓ 0.0 0 1,619

Seq Scan on three_charlie three_charlie (cost=0.000..52.650 rows=1 width=19) (actual time=0.197..0.197 rows=0 loops=1,619)

  • Filter: (hotel_zulu five_romeo_foxtrot NULL)