# | 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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|
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)
|