explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FDhA : removed distinct

Settings
# exclusive inclusive rows x rows loops node
1. 12.246 1,680,518.202 ↓ 0.0 0 1

ModifyTable (cost=65,477.640..65,544.340 rows=1 width=1,138) (actual time=1,680,518.202..1,680,518.202 rows=0 loops=1)

2. 8.224 1,680,505.956 ↓ 1,619.0 1,619 1

Nested Loop (cost=65,477.640..65,544.340 rows=1 width=1,138) (actual time=1,680,109.742..1,680,505.956 rows=1,619 loops=1)

3. 1.500 1,680,175.551 ↓ 1,619.0 1,619 1

Nested Loop (cost=65,477.640..65,491.670 rows=1 width=947) (actual time=1,680,109.401..1,680,175.551 rows=1,619 loops=1)

4. 2.269 1,680,149.766 ↓ 1,619.0 1,619 1

Nested Loop (cost=65,477.560..65,489.790 rows=1 width=966) (actual time=1,680,109.367..1,680,149.766 rows=1,619 loops=1)

5. 1.552 1,680,111.285 ↓ 548.7 1,646 1

Unique (cost=65,477.470..65,477.510 rows=3 width=928) (actual time=1,680,109.293..1,680,111.285 rows=1,646 loops=1)

6. 12.983 1,680,109.733 ↓ 548.7 1,646 1

Sort (cost=65,477.470..65,477.480 rows=3 width=928) (actual time=1,680,109.291..1,680,109.733 rows=1,646 loops=1)

  • Sort Method: quicksort Memory: 783kB
7. 0.145 1,680,096.750 ↓ 548.7 1,646 1

Append (cost=51,903.480..65,477.470 rows=3 width=928) (actual time=1,678,929.749..1,680,096.750 rows=1,646 loops=1)

8. 0.336 1,678,930.733 ↓ 596.5 1,193 1

Result (cost=51,903.480..51,903.510 rows=2 width=950) (actual time=1,678,929.748..1,678,930.733 rows=1,193 loops=1)

9. 0.566 1,678,930.397 ↓ 596.5 1,193 1

Unique (cost=51,903.480..51,903.500 rows=2 width=946) (actual time=1,678,929.744..1,678,930.397 rows=1,193 loops=1)

10. 11.922 1,678,929.831 ↓ 596.5 1,193 1

Sort (cost=51,903.480..51,903.480 rows=2 width=946) (actual time=1,678,929.742..1,678,929.831 rows=1,193 loops=1)

  • Sort Method: quicksort Memory: 662kB
11. 1.139 1,678,917.909 ↓ 596.5 1,193 1

Append (cost=22,183.510..51,903.480 rows=2 width=946) (actual time=12,912.878..1,678,917.909 rows=1,193 loops=1)

12. 64.595 1,658,301.298 ↓ 1,189.0 1,189 1

Nested Loop (cost=22,183.510..34,902.740 rows=1 width=344) (actual time=12,912.877..1,658,301.298 rows=1,189 loops=1)

13. 6.494 1,658,199.844 ↓ 1,189.0 1,189 1

Nested Loop (cost=22,183.430..34,902.490 rows=1 width=440) (actual time=12,912.809..1,658,199.844 rows=1,189 loops=1)

14. 133.953 1,658,171.948 ↓ 1,189.0 1,189 1

Nested Loop (cost=22,183.370..34,902.420 rows=1 width=417) (actual time=12,912.781..1,658,171.948 rows=1,189 loops=1)

15. 7,355.556 1,656,287.225 ↓ 1,191.0 1,191 1

Nested Loop (cost=14,835.680..27,529.130 rows=1 width=330) (actual time=12,884.967..1,656,287.225 rows=1,191 loops=1)

16. 37.689 187.181 ↓ 9,756.0 9,756 1

Hash Join (cost=252.480..2,924.470 rows=1 width=38) (actual time=4.219..187.181 rows=9,756 loops=1)

17. 145.543 146.446 ↓ 7.9 9,772 1

Bitmap Heap Scan on hotel_golf papa_juliet (cost=100.430..2,770.550 rows=1,244 width=42) (actual time=1.159..146.446 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)))
18. 0.903 0.903 ↓ 1.0 10,877 1

Bitmap Index Scan on papa_lima (cost=0.000..100.360 rows=10,854 width=0) (actual time=0.903..0.903 rows=10,877 loops=1)

  • Index Cond: ((romeo_quebec_zulu)::text = 'xray_uniform'::text)
19. 1.653 3.046 ↑ 1.0 9,865 1

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

20. 1.393 1.393 ↑ 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.393 rows=9,865 loops=1)

21. 15,676.855 1,648,744.488 ↓ 26.0 1,661 9,756

Hash Join (cost=14,583.200..24,604.370 rows=64 width=311) (actual time=0.128..168.998 rows=1,661 loops=9,756)

22. 12,516.948 1,632,686.112 ↓ 26.0 1,661 9,756

Nested Loop (cost=4,097.880..14,119.000 rows=64 width=279) (actual time=0.088..167.352 rows=1,661 loops=9,756)

23. 27,941.184 1,425,712.572 ↓ 25.6 1,661 9,756

Nested Loop (cost=4,097.800..14,107.650 rows=65 width=279) (actual time=0.073..146.137 rows=1,661 loops=9,756)

24. 23,043.672 1,223,431.668 ↓ 7.0 1,787 9,756

Nested Loop (cost=4,097.720..13,977.590 rows=255 width=290) (actual time=0.060..125.403 rows=1,787 loops=9,756)

25. 9,746.236 956,312.388 ↓ 5.9 1,787 9,756

Hash Join (cost=4,097.630..13,909.260 rows=302 width=290) (actual time=0.043..98.023 rows=1,787 loops=9,756)

26. 14,083.119 946,566.144 ↓ 1.0 1,787 9,756

Hash Join (cost=4,096.610..13,906.030 rows=1,734 width=269) (actual time=0.043..97.024 rows=1,787 loops=9,756)

27. 4,497.516 932,429.700 ↓ 1.0 1,787 9,756

Nested Loop (cost=0.080..9,808.590 rows=1,734 width=146) (actual time=0.037..95.575 rows=1,787 loops=9,756)

28. 561,818.772 561,818.772 ↓ 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.587 rows=1,787 loops=9,756)

  • Filter: ((uniform_mike_four_foxtrot = 2018) AND (kilo_bravo = 11))
29. 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)
30. 1.391 53.325 ↑ 1.1 4,418 1

Hash (cost=4,080.200..4,080.200 rows=4,666 width=123) (actual time=53.325..53.325 rows=4,418 loops=1)

31. 0.651 51.934 ↑ 1.1 4,418 1

Subquery Scan on foxtrot_sierra (cost=4,052.200..4,080.200 rows=4,666 width=123) (actual time=49.081..51.934 rows=4,418 loops=1)

32. 6.264 51.283 ↑ 1.1 4,418 1

Aggregate (cost=4,052.200..4,066.200 rows=4,666 width=139) (actual time=49.079..51.283 rows=4,418 loops=1)

33. 9.671 45.019 ↑ 1.0 4,660 1

Hash Join (cost=1,114.370..4,019.540 rows=4,666 width=123) (actual time=10.747..45.019 rows=4,660 loops=1)

34. 24.631 24.631 ↑ 1.0 67,245 1

Seq Scan on hotel_golf uniform_zulu (cost=0.000..2,807.000 rows=67,334 width=38) (actual time=0.005..24.631 rows=67,245 loops=1)

35. 1.278 10.717 ↑ 1.0 4,660 1

Hash (cost=1,098.020..1,098.020 rows=4,673 width=123) (actual time=10.717..10.717 rows=4,660 loops=1)

36. 9.439 9.439 ↑ 1.0 4,667 1

Seq Scan on tango_foxtrot lima_yankee (cost=0.000..1,098.020 rows=4,673 width=123) (actual time=0.009..9.439 rows=4,667 loops=1)

37. 0.003 0.008 ↑ 1.0 3 1

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

38. 0.005 0.005 ↑ 1.0 3 1

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

39. 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)
40. 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)
41. 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)
42. 1.590 381.521 ↓ 9,184.0 9,184 1

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

43. 1.070 379.931 ↓ 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=369.545..379.931 rows=9,184 loops=1)

44. 8.379 378.861 ↓ 9,184.0 9,184 1

Aggregate (cost=10,485.300..10,485.310 rows=1 width=75) (actual time=369.544..378.861 rows=9,184 loops=1)

45. 78.265 370.482 ↓ 9,191.0 9,191 1

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

  • Sort Method: quicksort Memory: 1305kB
46. 10.960 292.217 ↓ 9,191.0 9,191 1

Nested Loop (cost=1,408.870..10,485.300 rows=1 width=43) (actual time=139.606..292.217 rows=9,191 loops=1)

47. 5.345 161.072 ↓ 543.8 9,245 1

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

48. 4.945 149.657 ↓ 545.6 9,276 1

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

49. 133.909 133.909 ↓ 618.3 9,275 1

Seq Scan on charlie_six quebec_kilo (cost=0.000..9,063.730 rows=15 width=20) (actual time=122.602..133.909 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))
50. 1.514 10.803 ↓ 1.0 10,163 1

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

51. 0.728 9.289 ↓ 1.0 10,163 1

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

52. 0.001 1.619 ↓ 2.0 2 1

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

53. 1.618 1.618 ↓ 2.0 2 1

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

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

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

55. 1.188 1.188 ↓ 2.0 2 1

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

  • Filter: (november_lima ~~ 'uniform_tango'::text)
56. 0.924 5.753 ↑ 1.0 10,159 1

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

57. 4.829 4.829 ↑ 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.009..4.829 rows=10,159 loops=1)

  • Filter: (november_lima !~~ 'uniform_tango'::text)
58. 2.190 6.070 ↑ 1.0 13,674 1

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

59. 3.880 3.880 ↑ 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.010..3.880 rows=13,674 loops=1)

60. 120.185 120.185 ↑ 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.013..0.013 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)))
61. 1,580.457 1,750.770 ↑ 1.3 1,307 1,191

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

62. 153.415 170.313 ↓ 1.1 1,937 1,191

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

  • Sort Method: quicksort Memory: 320kB
63. 2.446 16.898 ↓ 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.610..16.898 rows=1,937 loops=1)

64. 14.452 14.452 ↓ 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.452..14.452 rows=1,937 loops=1)

  • Index Cond: ((victor_tango = 2018) AND (four = 11))
65. 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)
66. 36.859 36.859 ↑ 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.026..0.031 rows=1 loops=1,189)

  • Index Cond: ((mike_four)::text = (romeo_mike1.india_sierra)::text)
  • Filter: ((romeo_quebec_zulu)::text = 'uniform_oscar'::text)
67. 0.015 20,615.472 ↓ 4.0 4 1

Subquery Scan on echo_uniform (cost=13,646.680..17,000.730 rows=1 width=344) (actual time=2,505.800..20,615.472 rows=4 loops=1)

68. 4.350 20,615.457 ↓ 4.0 4 1

Nested Loop (cost=13,646.680..17,000.730 rows=1 width=284) (actual time=2,505.796..20,615.457 rows=4 loops=1)

  • Filter: (hotel_victor((lima_sierra(sierra_charlie1.india_sierra, ''::character varying))::text) = 0)
69. 2,873.230 20,572.563 ↓ 1,168.0 1,168 1

Nested Loop (cost=13,646.590..17,000.250 rows=1 width=356) (actual time=908.039..20,572.563 rows=1,168 loops=1)

70. 40.809 13,905.669 ↓ 1,168.0 1,168 1

Hash Join (cost=13,646.590..16,387.460 rows=1 width=337) (actual time=902.587..13,905.669 rows=1,168 loops=1)

71. 27.227 13,121.886 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,305.100..7,026.130 rows=1 width=292) (actual time=62.563..13,121.886 rows=7,468 loops=1)

72. 9.156 13,087.191 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,305.100..7,025.110 rows=1 width=271) (actual time=62.548..13,087.191 rows=7,468 loops=1)

73. 14.833 12,966.015 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,305.020..7,024.780 rows=1 width=252) (actual time=62.523..12,966.015 rows=7,468 loops=1)

74. 2,147.514 12,831.694 ↓ 7,468.0 7,468 1

Nested Loop (cost=4,304.930..7,023.690 rows=1 width=271) (actual time=62.473..12,831.694 rows=7,468 loops=1)

75. 26.373 714.400 ↓ 7,468.0 7,468 1

Nested Loop (cost=252.730..2,927.160 rows=1 width=148) (actual time=4.368..714.400 rows=7,468 loops=1)

76. 11.959 601.483 ↓ 9,616.0 9,616 1

Nested Loop (cost=252.650..2,926.650 rows=1 width=159) (actual time=4.351..601.483 rows=9,616 loops=1)

77. 10.683 425.899 ↓ 9,625.0 9,625 1

Nested Loop (cost=252.560..2,926.170 rows=1 width=159) (actual time=4.328..425.899 rows=9,625 loops=1)

78. 14.498 44.488 ↓ 9,756.0 9,756 1

Hash Join (cost=252.480..2,924.470 rows=1 width=61) (actual time=4.248..44.488 rows=9,756 loops=1)

79. 26.015 26.923 ↓ 7.9 9,772 1

Bitmap Heap Scan on hotel_golf golf_juliet (cost=100.430..2,770.550 rows=1,244 width=42) (actual time=1.153..26.923 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)))
80. 0.908 0.908 ↓ 1.0 10,880 1

Bitmap Index Scan on papa_lima (cost=0.000..100.360 rows=10,854 width=0) (actual time=0.907..0.908 rows=10,880 loops=1)

  • Index Cond: ((romeo_quebec_zulu)::text = 'xray_uniform'::text)
81. 1.674 3.067 ↑ 1.0 9,865 1

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

82. 1.393 1.393 ↑ 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.013..1.393 rows=9,865 loops=1)

83. 370.728 370.728 ↑ 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.038..0.038 rows=1 loops=9,756)

  • Index Cond: ((india_sierra)::text = (oscar_victor2.mike_delta)::text)
  • Filter: ((yankee_five)::text ~~ 'kilo_five'::text)
84. 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)
85. 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)
86. 9,918.121 9,969.780 ↑ 1.3 3,534 7,468

Aggregate (cost=4,052.200..4,066.200 rows=4,666 width=139) (actual time=0.008..1.335 rows=3,534 loops=7,468)

87. 10.509 51.659 ↑ 1.0 4,660 1

Hash Join (cost=1,114.370..4,019.540 rows=4,666 width=123) (actual time=15.712..51.659 rows=4,660 loops=1)

88. 25.479 25.479 ↑ 1.0 67,245 1

Seq Scan on hotel_golf uniform_mike_four_tango (cost=0.000..2,807.000 rows=67,334 width=38) (actual time=0.007..25.479 rows=67,245 loops=1)

89. 1.513 15.671 ↑ 1.0 4,660 1

Hash (cost=1,098.020..1,098.020 rows=4,673 width=123) (actual time=15.671..15.671 rows=4,660 loops=1)

90. 14.158 14.158 ↑ 1.0 4,667 1

Seq Scan on tango_foxtrot two_juliet (cost=0.000..1,098.020 rows=4,673 width=123) (actual time=0.010..14.158 rows=4,667 loops=1)

91. 119.488 119.488 ↑ 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.016..0.016 rows=1 loops=7,468)

  • Index Cond: (india_sierra = (romeo_mike2.india_juliet)::text)
92. 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)
93. 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)

94. 87.641 742.974 ↓ 6.3 265,157 1

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

95. 39.978 655.333 ↓ 6.3 265,157 1

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

96. 571.734 615.355 ↓ 6.3 265,157 1

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

97. 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.009..43.621 rows=417,581 loops=1)

98. 3,793.664 3,793.664 ↑ 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.248 rows=12,442 loops=1,168)

  • Filter: (xray_sierra five_romeo_foxtrot NULL)
99. 38.544 38.544 ↑ 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.028..0.033 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)))
100. 0.224 1,165.872 ↓ 453.0 453 1

Subquery Scan on bravo_seven (cost=10,711.940..13,573.960 rows=1 width=361) (actual time=1,127.784..1,165.872 rows=453 loops=1)

101. 5.787 1,165.648 ↓ 453.0 453 1

Hash Join (cost=10,711.940..13,573.950 rows=1 width=297) (actual time=1,127.779..1,165.648 rows=453 loops=1)

102. 10.967 37.173 ↓ 1,092.3 15,292 1

Hash Join (cost=220.010..3,082.000 rows=14 width=134) (actual time=4.969..37.173 rows=15,292 loops=1)

103. 21.304 21.304 ↓ 1.0 20,026 1

Seq Scan on hotel_golf five_xray (cost=0.000..2,840.670 rows=19,832 width=123) (actual time=0.019..21.304 rows=20,026 loops=1)

  • Filter: ((romeo_quebec_zulu)::text = 'uniform_oscar'::text)
104. 2.684 4.902 ↑ 1.0 15,287 1

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

105. 2.218 2.218 ↑ 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.009..2.218 rows=15,287 loops=1)

106. 0.715 1,122.688 ↓ 453.0 453 1

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

107. 1.466 1,121.973 ↓ 453.0 453 1

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

  • Filter: (hotel_victor((lima_sierra(sierra_charlie3.india_sierra, ''::character varying))::text) = 0)
108. 2.686 1,086.403 ↓ 1,624.0 1,624 1

Nested Loop (cost=10,485.720..10,491.690 rows=1 width=191) (actual time=388.276..1,086.403 rows=1,624 loops=1)

109. 9.932 961.302 ↓ 8,161.0 8,161 1

Nested Loop (cost=10,485.640..10,491.330 rows=1 width=162) (actual time=388.017..961.302 rows=8,161 loops=1)

110. 6.540 943.203 ↓ 8,167.0 8,167 1

Nested Loop (cost=10,485.640..10,490.310 rows=1 width=141) (actual time=388.001..943.203 rows=8,167 loops=1)

111. 16.506 838.659 ↓ 8,167.0 8,167 1

Nested Loop (cost=10,485.550..10,490.140 rows=1 width=141) (actual time=387.973..838.659 rows=8,167 loops=1)

112. 10.569 739.875 ↓ 9,142.0 9,142 1

Nested Loop (cost=10,485.470..10,489.630 rows=1 width=152) (actual time=387.941..739.875 rows=9,142 loops=1)

113. 10.995 600.730 ↓ 9,184.0 9,184 1

Nested Loop (cost=10,485.390..10,489.400 rows=1 width=152) (actual time=387.909..600.730 rows=9,184 loops=1)

114. 14.931 406.055 ↓ 9,184.0 9,184 1

Aggregate (cost=10,485.300..10,485.310 rows=1 width=75) (actual time=387.840..406.055 rows=9,184 loops=1)

115. 83.411 391.124 ↓ 9,191.0 9,191 1

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

  • Sort Method: quicksort Memory: 1305kB
116. 8.693 307.713 ↓ 9,191.0 9,191 1

Nested Loop (cost=1,408.870..10,485.300 rows=1 width=43) (actual time=146.102..307.713 rows=9,191 loops=1)

117. 6.213 169.590 ↓ 543.8 9,245 1

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

118. 5.540 156.987 ↓ 545.6 9,276 1

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

119. 140.011 140.011 ↓ 618.3 9,275 1

Seq Scan on charlie_six quebec_whiskey (cost=0.000..9,063.730 rows=15 width=20) (actual time=128.130..140.011 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))
120. 1.654 11.436 ↓ 1.0 10,163 1

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

121. 0.668 9.782 ↓ 1.0 10,163 1

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

122. 0.002 1.708 ↓ 2.0 2 1

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

123. 1.706 1.706 ↓ 2.0 2 1

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

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

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

125. 1.276 1.276 ↓ 2.0 2 1

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

  • Filter: (november_lima ~~ 'uniform_tango'::text)
126. 1.039 6.129 ↑ 1.0 10,159 1

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

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

  • Filter: (november_lima !~~ 'uniform_tango'::text)
128. 2.458 6.390 ↑ 1.0 13,674 1

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

129. 3.932 3.932 ↑ 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.932 rows=13,674 loops=1)

130. 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)))
131. 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)
132. 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)
133. 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)
134. 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)
135. 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)

136. 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))
137. 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)))
138. 36.212 36.212 ↑ 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.022..0.022 rows=1 loops=1,646)

  • Index Cond: ((india_sierra)::text = (romeo_mike1.india_sierra)::text)
  • Filter: november_six
139. 24.285 24.285 ↑ 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.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)
140. 322.181 322.181 ↓ 0.0 0 1,619

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

  • Filter: (hotel_zulu five_romeo_foxtrot NULL)