explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7ohJ : pre split pre optimize post vacuum analyze full

Settings
# exclusive inclusive rows x rows loops node
1. 10.128 1,678,178.228 ↓ 0.0 0 1

ModifyTable (cost=65,452.940..65,519.660 rows=1 width=1,138) (actual time=1,678,178.228..1,678,178.228 rows=0 loops=1)

2. 6.439 1,678,168.100 ↓ 1,619.0 1,619 1

Subquery Scan on yankee_victor (cost=65,452.940..65,519.660 rows=1 width=1,138) (actual time=1,677,776.193..1,678,168.100 rows=1,619 loops=1)

3. 1.655 1,678,161.661 ↓ 1,619.0 1,619 1

Unique (cost=65,452.940..65,519.650 rows=1 width=928) (actual time=1,677,775.885..1,678,161.661 rows=1,619 loops=1)

4. 2.340 1,678,160.006 ↓ 1,619.0 1,619 1

Nested Loop (cost=65,452.940..65,519.640 rows=1 width=928) (actual time=1,677,775.883..1,678,160.006 rows=1,619 loops=1)

5. 0.506 1,677,838.723 ↓ 1,619.0 1,619 1

Nested Loop (cost=65,452.940..65,466.980 rows=1 width=947) (actual time=1,677,775.600..1,677,838.723 rows=1,619 loops=1)

6. 2.311 1,677,813.932 ↓ 1,619.0 1,619 1

Nested Loop (cost=65,452.860..65,465.090 rows=1 width=966) (actual time=1,677,775.559..1,677,813.932 rows=1,619 loops=1)

7. 1.244 1,677,777.055 ↓ 548.7 1,646 1

Unique (cost=65,452.780..65,452.810 rows=3 width=928) (actual time=1,677,775.494..1,677,777.055 rows=1,646 loops=1)

8. 13.069 1,677,775.811 ↓ 548.7 1,646 1

Sort (cost=65,452.780..65,452.780 rows=3 width=928) (actual time=1,677,775.492..1,677,775.811 rows=1,646 loops=1)

  • Sort Method: quicksort Memory: 783kB
9. 0.103 1,677,762.742 ↓ 548.7 1,646 1

Append (cost=51,882.070..65,452.770 rows=3 width=928) (actual time=1,676,603.765..1,677,762.742 rows=1,646 loops=1)

10. 0.353 1,676,604.650 ↓ 596.5 1,193 1

Result (cost=51,882.070..51,882.100 rows=2 width=950) (actual time=1,676,603.764..1,676,604.650 rows=1,193 loops=1)

11. 0.480 1,676,604.297 ↓ 596.5 1,193 1

Unique (cost=51,882.070..51,882.100 rows=2 width=946) (actual time=1,676,603.761..1,676,604.297 rows=1,193 loops=1)

12. 7.041 1,676,603.817 ↓ 596.5 1,193 1

Sort (cost=51,882.070..51,882.070 rows=2 width=946) (actual time=1,676,603.759..1,676,603.817 rows=1,193 loops=1)

  • Sort Method: quicksort Memory: 662kB
13. 0.084 1,676,596.776 ↓ 596.5 1,193 1

Append (cost=34,889.960..51,882.070 rows=2 width=946) (actual time=1,655,925.427..1,676,596.776 rows=1,193 loops=1)

14. 0.660 1,655,926.177 ↓ 1,189.0 1,189 1

Unique (cost=34,889.960..34,889.970 rows=1 width=344) (actual time=1,655,925.426..1,655,926.177 rows=1,189 loops=1)

15. 11.623 1,655,925.517 ↓ 1,189.0 1,189 1

Sort (cost=34,889.960..34,889.960 rows=1 width=344) (actual time=1,655,925.424..1,655,925.517 rows=1,189 loops=1)

  • Sort Method: quicksort Memory: 661kB
16. 61.740 1,655,913.894 ↓ 1,189.0 1,189 1

Nested Loop (cost=22,177.930..34,889.960 rows=1 width=344) (actual time=13,071.251..1,655,913.894 rows=1,189 loops=1)

17. 6.562 1,655,806.972 ↓ 1,189.0 1,189 1

Nested Loop (cost=22,177.840..34,889.710 rows=1 width=440) (actual time=13,071.091..1,655,806.972 rows=1,189 loops=1)

18. 130.548 1,655,776.630 ↓ 1,189.0 1,189 1

Nested Loop (cost=22,177.790..34,889.640 rows=1 width=417) (actual time=13,071.036..1,655,776.630 rows=1,189 loops=1)

19. 7,854.990 1,653,885.784 ↓ 1,191.0 1,191 1

Nested Loop (cost=14,830.100..27,516.350 rows=1 width=330) (actual time=13,029.763..1,653,885.784 rows=1,191 loops=1)

20. 32.919 174.082 ↓ 9,756.0 9,756 1

Hash Join (cost=252.460..2,921.380 rows=1 width=38) (actual time=4.523..174.082 rows=9,756 loops=1)

21. 136.912 138.025 ↓ 7.9 9,772 1

Bitmap Heap Scan on hotel_golf papa_juliet (cost=100.410..2,767.460 rows=1,243 width=42) (actual time=1.371..138.025 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)))
22. 1.113 1.113 ↓ 1.0 10,864 1

Bitmap Index Scan on papa_lima (cost=0.000..100.350 rows=10,842 width=0) (actual time=1.113..1.113 rows=10,864 loops=1)

  • Index Cond: ((romeo_quebec_zulu)::text = 'xray_uniform'::text)
23. 1.645 3.138 ↑ 1.0 9,865 1

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

24. 1.493 1.493 ↑ 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.010..1.493 rows=9,865 loops=1)

25. 15,141.312 1,645,856.712 ↓ 25.6 1,661 9,756

Nested Loop (cost=14,577.630..24,594.680 rows=65 width=311) (actual time=0.131..168.702 rows=1,661 loops=9,756)

26. 16,787.095 1,436,258.808 ↓ 25.6 1,661 9,756

Hash Join (cost=14,577.550..24,583.310 rows=65 width=311) (actual time=0.116..147.218 rows=1,661 loops=9,756)

27. 22,399.776 1,419,058.980 ↓ 25.6 1,661 9,756

Nested Loop (cost=4,092.240..14,097.950 rows=65 width=279) (actual time=0.072..145.455 rows=1,661 loops=9,756)

28. 21,268.080 1,222,319.484 ↓ 7.0 1,787 9,756

Nested Loop (cost=4,092.160..13,968.350 rows=255 width=290) (actual time=0.060..125.289 rows=1,787 loops=9,756)

29. 10,663.299 956,975.796 ↓ 5.9 1,787 9,756

Hash Join (cost=4,092.070..13,899.700 rows=302 width=290) (actual time=0.043..98.091 rows=1,787 loops=9,756)

30. 12,656.651 946,312.488 ↓ 1.0 1,787 9,756

Hash Join (cost=4,091.050..13,896.470 rows=1,734 width=269) (actual time=0.043..96.998 rows=1,787 loops=9,756)

31. 5,512.140 933,600.420 ↓ 1.0 1,787 9,756

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

32. 561,974.868 561,974.868 ↓ 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.603 rows=1,787 loops=9,756)

  • Filter: ((uniform_mike_four_foxtrot = 2018) AND (kilo_bravo = 11))
33. 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)
34. 1.293 55.417 ↑ 1.1 4,416 1

Hash (cost=4,074.670..4,074.670 rows=4,657 width=123) (actual time=55.417..55.417 rows=4,416 loops=1)

35. 0.746 54.124 ↑ 1.1 4,416 1

Subquery Scan on foxtrot_sierra (cost=4,046.730..4,074.670 rows=4,657 width=123) (actual time=51.033..54.124 rows=4,416 loops=1)

36. 6.516 53.378 ↑ 1.1 4,416 1

Aggregate (cost=4,046.730..4,060.700 rows=4,657 width=139) (actual time=51.032..53.378 rows=4,416 loops=1)

37. 9.737 46.862 ↑ 1.0 4,657 1

Hash Join (cost=1,112.320..4,014.130 rows=4,657 width=123) (actual time=11.311..46.862 rows=4,657 loops=1)

38. 25.847 25.847 ↑ 1.0 67,231 1

Seq Scan on hotel_golf uniform_zulu (cost=0.000..2,803.770 rows=67,257 width=38) (actual time=0.005..25.847 rows=67,231 loops=1)

39. 1.277 11.278 ↑ 1.0 4,657 1

Hash (cost=1,095.990..1,095.990 rows=4,664 width=123) (actual time=11.278..11.278 rows=4,657 loops=1)

40. 10.001 10.001 ↑ 1.0 4,664 1

Seq Scan on tango_foxtrot lima_yankee (cost=0.000..1,095.990 rows=4,664 width=123) (actual time=0.016..10.001 rows=4,664 loops=1)

41. 0.002 0.009 ↑ 1.0 3 1

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

42. 0.007 0.007 ↑ 1.0 3 1

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

43. 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)
44. 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)
45. 1.631 412.733 ↓ 9,184.0 9,184 1

Hash (cost=10,485.310..10,485.310 rows=1 width=51) (actual time=412.733..412.733 rows=9,184 loops=1)

46. 1.057 411.102 ↓ 9,184.0 9,184 1

Subquery Scan on xray_yankee_two (cost=10,485.300..10,485.310 rows=1 width=51) (actual time=400.293..411.102 rows=9,184 loops=1)

47. 8.567 410.045 ↓ 9,184.0 9,184 1

Aggregate (cost=10,485.300..10,485.300 rows=1 width=75) (actual time=400.291..410.045 rows=9,184 loops=1)

48. 77.564 401.478 ↓ 9,191.0 9,191 1

Sort (cost=10,485.300..10,485.300 rows=1 width=43) (actual time=400.265..401.478 rows=9,191 loops=1)

  • Sort Method: quicksort Memory: 1305kB
49. 2.497 323.914 ↓ 9,191.0 9,191 1

Nested Loop (cost=1,408.870..10,485.290 rows=1 width=43) (actual time=166.894..323.914 rows=9,191 loops=1)

50. 6.456 191.987 ↓ 543.8 9,245 1

Hash Join (cost=1,408.790..10,476.440 rows=17 width=35) (actual time=166.825..191.987 rows=9,245 loops=1)

51. 4.822 179.197 ↓ 545.6 9,276 1

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

52. 163.697 163.697 ↓ 618.3 9,275 1

Seq Scan on charlie_six quebec_kilo (cost=0.000..9,063.730 rows=15 width=20) (actual time=149.697..163.697 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))
53. 1.492 10.678 ↓ 1.0 10,163 1

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

54. 0.713 9.186 ↓ 1.0 10,163 1

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

55. 0.002 1.589 ↓ 2.0 2 1

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

56. 1.587 1.587 ↓ 2.0 2 1

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

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

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

58. 1.203 1.203 ↓ 2.0 2 1

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

  • Filter: (november_lima ~~ 'uniform_tango'::text)
59. 0.948 5.680 ↑ 1.0 10,159 1

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

60. 4.732 4.732 ↑ 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.005..4.732 rows=10,159 loops=1)

  • Filter: (november_lima !~~ 'uniform_tango'::text)
61. 2.191 6.334 ↑ 1.0 13,674 1

Hash (cost=563.020..563.020 rows=13,674 width=28) (actual time=6.334..6.334 rows=13,674 loops=1)

62. 4.143 4.143 ↑ 1.0 13,674 1

Seq Scan on yankee_charlie whiskey_tango (cost=0.000..563.020 rows=13,674 width=28) (actual time=0.008..4.143 rows=13,674 loops=1)

63. 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)))
64. 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)
65. 1,579.266 1,760.298 ↑ 1.3 1,307 1,191

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

66. 150.835 181.032 ↓ 1.1 1,937 1,191

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

  • Sort Method: quicksort Memory: 320kB
67. 2.553 30.197 ↓ 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=27.806..30.197 rows=1,937 loops=1)

68. 27.644 27.644 ↓ 1.1 1,937 1

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

  • Index Cond: ((victor_tango = 2018) AND (four = 11))
69. 23.780 23.780 ↑ 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.020..0.020 rows=1 loops=1,189)

  • Index Cond: ((mike_delta)::text = (romeo_mike1.india_sierra)::text)
70. 45.182 45.182 ↑ 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.033..0.038 rows=1 loops=1,189)

  • Index Cond: ((mike_four)::text = (romeo_mike1.india_sierra)::text)
  • Filter: ((romeo_quebec_zulu)::text = 'uniform_oscar'::text)
71. 0.007 20,670.515 ↓ 4.0 4 1

Subquery Scan on echo_uniform (cost=16,992.080..16,992.100 rows=1 width=344) (actual time=20,670.508..20,670.515 rows=4 loops=1)

72. 0.006 20,670.508 ↓ 4.0 4 1

Unique (cost=16,992.080..16,992.090 rows=1 width=284) (actual time=20,670.503..20,670.508 rows=4 loops=1)

73. 0.055 20,670.502 ↓ 4.0 4 1

Sort (cost=16,992.080..16,992.080 rows=1 width=284) (actual time=20,670.502..20,670.502 rows=4 loops=1)

  • Sort Method: quicksort Memory: 26kB
74. 4.847 20,670.447 ↓ 4.0 4 1

Nested Loop (cost=13,641.180..16,992.080 rows=1 width=284) (actual time=2,582.119..20,670.447 rows=4 loops=1)

  • Filter: (hotel_victor((lima_sierra(sierra_charlie1.india_sierra, ''::character varying))::text) = 0)
75. 2,874.021 20,628.224 ↓ 1,168.0 1,168 1

Nested Loop (cost=13,641.100..16,991.600 rows=1 width=356) (actual time=954.013..20,628.224 rows=1,168 loops=1)

76. 38.309 13,938.347 ↓ 1,168.0 1,168 1

Hash Join (cost=13,641.100..16,378.810 rows=1 width=337) (actual time=948.543..13,938.347 rows=1,168 loops=1)

77. 24.588 13,106.079 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,299.610..7,017.480 rows=1 width=292) (actual time=56.419..13,106.079 rows=7,468 loops=1)

78. 8.268 13,074.023 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,299.610..7,016.460 rows=1 width=271) (actual time=56.409..13,074.023 rows=7,468 loops=1)

79. 11.145 12,953.735 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,299.520..7,016.120 rows=1 width=252) (actual time=56.382..12,953.735 rows=7,468 loops=1)

80. 2,186.071 12,815.634 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,299.440..7,015.040 rows=1 width=271) (actual time=56.289..12,815.634 rows=7,468 loops=1)

81. 23.742 704.591 ↓ 7,468.0 7,468 1

Nested Loop (cost=252.710..2,924.070 rows=1 width=148) (actual time=4.456..704.591 rows=7,468 loops=1)

82. 7.854 594.305 ↓ 9,616.0 9,616 1

Nested Loop (cost=252.630..2,923.560 rows=1 width=159) (actual time=4.433..594.305 rows=9,616 loops=1)

83. 17.784 422.826 ↓ 9,625.0 9,625 1

Nested Loop (cost=252.550..2,923.080 rows=1 width=159) (actual time=4.405..422.826 rows=9,625 loops=1)

84. 14.124 44.070 ↓ 9,756.0 9,756 1

Hash Join (cost=252.460..2,921.380 rows=1 width=61) (actual time=4.298..44.070 rows=9,756 loops=1)

85. 25.925 26.877 ↓ 7.9 9,772 1

Bitmap Heap Scan on hotel_golf golf_juliet (cost=100.410..2,767.460 rows=1,243 width=42) (actual time=1.208..26.877 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)))
86. 0.952 0.952 ↓ 1.0 10,868 1

Bitmap Index Scan on papa_lima (cost=0.000..100.350 rows=10,842 width=0) (actual time=0.952..0.952 rows=10,868 loops=1)

  • Index Cond: ((romeo_quebec_zulu)::text = 'xray_uniform'::text)
87. 1.632 3.069 ↑ 1.0 9,865 1

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

88. 1.437 1.437 ↑ 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.020..1.437 rows=9,865 loops=1)

89. 360.972 360.972 ↑ 1.0 1 9,756

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

  • Index Cond: ((india_sierra)::text = (oscar_victor2.mike_delta)::text)
  • Filter: ((yankee_five)::text ~~ 'kilo_five'::text)
90. 163.625 163.625 ↑ 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.017..0.017 rows=1 loops=9,625)

  • Index Cond: ((india_sierra)::text = (romeo_mike2.bravo_kilo)::text)
91. 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)
92. 9,879.980 9,924.972 ↑ 1.3 3,532 7,468

Aggregate (cost=4,046.730..4,060.700 rows=4,657 width=139) (actual time=0.007..1.329 rows=3,532 loops=7,468)

93. 9.750 44.992 ↑ 1.0 4,657 1

Hash Join (cost=1,112.320..4,014.130 rows=4,657 width=123) (actual time=10.695..44.992 rows=4,657 loops=1)

94. 24.584 24.584 ↑ 1.0 67,231 1

Seq Scan on hotel_golf uniform_mike_four_tango (cost=0.000..2,803.770 rows=67,257 width=38) (actual time=0.008..24.584 rows=67,231 loops=1)

95. 1.223 10.658 ↑ 1.0 4,657 1

Hash (cost=1,095.990..1,095.990 rows=4,664 width=123) (actual time=10.658..10.658 rows=4,657 loops=1)

96. 9.435 9.435 ↑ 1.0 4,664 1

Seq Scan on tango_foxtrot two_juliet (cost=0.000..1,095.990 rows=4,664 width=123) (actual time=0.011..9.435 rows=4,664 loops=1)

97. 126.956 126.956 ↑ 1.0 1 7,468

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

  • Index Cond: (india_sierra = (romeo_mike2.india_juliet)::text)
98. 112.020 112.020 ↑ 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.015..0.015 rows=1 loops=7,468)

  • Index Cond: (india_sierra = (romeo_mike2.victor_november)::text)
99. 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)

100. 88.010 793.959 ↓ 6.3 265,157 1

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

101. 37.110 705.949 ↓ 6.3 265,157 1

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

102. 623.653 668.839 ↓ 6.3 265,157 1

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

103. 45.186 45.186 ↑ 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.008..45.186 rows=417,581 loops=1)

104. 3,815.856 3,815.856 ↑ 1.0 12,442 1,168

Seq Scan on yankee_charlie yankee_charlie (cost=0.000..563.020 rows=12,442 width=35) (actual time=0.004..3.267 rows=12,442 loops=1,168)

  • Filter: (xray_sierra five_romeo_foxtrot NULL)
105. 37.376 37.376 ↑ 1.0 1 1,168

Index Scan using six_mike on hotel_golf kilo_xray (cost=0.080..0.470 rows=1 width=38) (actual time=0.027..0.032 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)))
106. 0.183 1,157.989 ↓ 453.0 453 1

Subquery Scan on bravo_seven (cost=13,570.660..13,570.670 rows=1 width=361) (actual time=1,157.611..1,157.989 rows=453 loops=1)

107. 0.179 1,157.806 ↓ 453.0 453 1

Unique (cost=13,570.660..13,570.660 rows=1 width=297) (actual time=1,157.606..1,157.806 rows=453 loops=1)

108. 2.394 1,157.627 ↓ 453.0 453 1

Sort (cost=13,570.660..13,570.660 rows=1 width=297) (actual time=1,157.604..1,157.627 rows=453 loops=1)

  • Sort Method: quicksort Memory: 145kB
109. 5.469 1,155.233 ↓ 453.0 453 1

Hash Join (cost=10,711.940..13,570.650 rows=1 width=297) (actual time=1,118.880..1,155.233 rows=453 loops=1)

110. 9.309 36.011 ↓ 1,092.3 15,292 1

Hash Join (cost=220.010..3,078.700 rows=14 width=134) (actual time=5.006..36.011 rows=15,292 loops=1)

111. 21.746 21.746 ↓ 1.0 20,024 1

Seq Scan on hotel_golf five_xray (cost=0.000..2,837.400 rows=19,809 width=123) (actual time=0.015..21.746 rows=20,024 loops=1)

  • Filter: ((romeo_quebec_zulu)::text = 'uniform_oscar'::text)
112. 2.990 4.956 ↑ 1.0 15,287 1

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

113. 1.966 1.966 ↑ 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.008..1.966 rows=15,287 loops=1)

114. 0.560 1,113.753 ↓ 453.0 453 1

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

115. 0.911 1,113.193 ↓ 453.0 453 1

Nested Loop (cost=10,485.800..10,491.930 rows=1 width=210) (actual time=374.952..1,113.193 rows=453 loops=1)

  • Filter: (hotel_victor((lima_sierra(sierra_charlie3.india_sierra, ''::character varying))::text) = 0)
116. 7.001 1,078.178 ↓ 1,624.0 1,624 1

Nested Loop (cost=10,485.710..10,491.680 rows=1 width=191) (actual time=374.913..1,078.178 rows=1,624 loops=1)

117. 10.197 940.601 ↓ 8,161.0 8,161 1

Nested Loop (cost=10,485.630..10,491.320 rows=1 width=162) (actual time=374.630..940.601 rows=8,161 loops=1)

118. 7.603 922.237 ↓ 8,167.0 8,167 1

Nested Loop (cost=10,485.630..10,490.310 rows=1 width=141) (actual time=374.612..922.237 rows=8,167 loops=1)

119. 17.252 816.630 ↓ 8,167.0 8,167 1

Nested Loop (cost=10,485.540..10,490.130 rows=1 width=141) (actual time=374.585..816.630 rows=8,167 loops=1)

120. 5.955 717.100 ↓ 9,142.0 9,142 1

Nested Loop (cost=10,485.460..10,489.620 rows=1 width=152) (actual time=374.554..717.100 rows=9,142 loops=1)

121. 7.320 582.569 ↓ 9,184.0 9,184 1

Nested Loop (cost=10,485.380..10,489.390 rows=1 width=152) (actual time=374.524..582.569 rows=9,184 loops=1)

122. 14.508 391.569 ↓ 9,184.0 9,184 1

Aggregate (cost=10,485.300..10,485.300 rows=1 width=75) (actual time=374.458..391.569 rows=9,184 loops=1)

123. 80.118 377.061 ↓ 9,191.0 9,191 1

Sort (cost=10,485.300..10,485.300 rows=1 width=43) (actual time=374.429..377.061 rows=9,191 loops=1)

  • Sort Method: quicksort Memory: 1305kB
124. 4.137 296.943 ↓ 9,191.0 9,191 1

Nested Loop (cost=1,408.870..10,485.290 rows=1 width=43) (actual time=140.345..296.943 rows=9,191 loops=1)

125. 6.224 163.376 ↓ 543.8 9,245 1

Hash Join (cost=1,408.790..10,476.440 rows=17 width=35) (actual time=140.268..163.376 rows=9,245 loops=1)

126. 5.856 150.663 ↓ 545.6 9,276 1

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

127. 133.882 133.882 ↓ 618.3 9,275 1

Seq Scan on charlie_six quebec_whiskey (cost=0.000..9,063.730 rows=15 width=20) (actual time=122.606..133.882 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))
128. 1.853 10.925 ↓ 1.0 10,163 1

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

129. 0.604 9.072 ↓ 1.0 10,163 1

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

130. 0.002 1.586 ↓ 2.0 2 1

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

131. 1.584 1.584 ↓ 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.584 rows=2 loops=1)

  • Filter: (november_lima ~~ 'uniform_tango'::text)
132. 0.002 1.194 ↓ 2.0 2 1

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

133. 1.192 1.192 ↓ 2.0 2 1

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

  • Filter: (november_lima ~~ 'uniform_tango'::text)
134. 0.889 5.688 ↑ 1.0 10,159 1

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

135. 4.799 4.799 ↑ 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.007..4.799 rows=10,159 loops=1)

  • Filter: (november_lima !~~ 'uniform_tango'::text)
136. 2.711 6.489 ↑ 1.0 13,674 1

Hash (cost=563.020..563.020 rows=13,674 width=28) (actual time=6.489..6.489 rows=13,674 loops=1)

137. 3.778 3.778 ↑ 1.0 13,674 1

Seq Scan on yankee_charlie sierra_mike (cost=0.000..563.020 rows=13,674 width=28) (actual time=0.009..3.778 rows=13,674 loops=1)

138. 129.430 129.430 ↑ 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.014..0.014 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)))
139. 183.680 183.680 ↑ 1.0 1 9,184

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,184)

  • Index Cond: ((india_sierra)::text = (echo_five1.mike_four)::text)
140. 128.576 128.576 ↑ 1.0 1 9,184

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,184)

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

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,142)

  • Index Cond: ((india_sierra)::text = (juliet_lima2.lima_five)::text)
142. 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)
143. 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)

144. 130.576 130.576 ↓ 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.016..0.016 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))
145. 34.104 34.104 ↑ 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.019..0.021 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)))
146. 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
147. 24.285 24.285 ↑ 1.0 1 1,619

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

  • Index Cond: ((india_sierra)::text = (mike_four.bravo_kilo)::text)
  • Filter: (lima_five five_romeo_foxtrot NOT NULL)
148. 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)