explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V9jA : Dump Rpt

Settings
# exclusive inclusive rows x rows loops node
1. 3.741 4,723.709 ↓ 26.1 1,986 1

Group (cost=708,036.720..708,258.830 rows=76 width=961) (actual time=4,719.409..4,723.709 rows=1,986 loops=1)

  • Group Key: lima_delta_tango.quebec_seven, 'victor_whiskey'::text, (juliet_golf((lima_delta_tango.seven_golf)::text, (lima_delta_tango.kilo_kilo_alpha)::text)), zulu_delta.bravo_papa, (juliet_golf((quebec_foxtrot_two.seven_golf)::text, (quebec_foxtrot_two.kilo_kilo_alpha)::text)), quebec_foxtrot_two.zulu_lima, lima_delta_sierra.victor_zulu, five_hotel.two_three, five_hotel.mike_oscar, three_four.seven_delta, hotel_zulu_three.victor_juliet, five_yankee_sierra1.november_lima, five_yankee_sierra2.november_lima, charlie_zulu.two_mike_three, ((charlie_xray('november_victor'::text, ((papa_delta((echo_tango('uniform_whiskey'::text, foxtrot_six.tango_delta) + (((((charlie_quebec.seven_two)::text || ''yankee_foxtrot_three'india_golf'xray_romeo'india_golf'oscar_echo'echo_seven_xray'four_echo'sierra_three'golf_mike'papa_kilo'sierra_two'romeo_lima_alpha'five_golf'india_golf'kilo_seven'india_golf'kilo_delta'echo_seven_xray'xray_five_kilo'sierra_three'yankee_three_sierra'kilo_echo'yankee_three_yankee'two_foxtrot'romeo_juliet'papa_tango'whiskey_sierra'yankee_yankee'golf_hotel'four_juliet'uniform_charlie'india_golf'november_bravo'kilo_echo'zulu_victor'golf_papa for romeo_tango'november_bravo'kilo_echo'alpha_four'papa_tango'sierra_zulu'yankee_yankee'india_papa'four_juliet'alpha_mike'echo_seven_xray'quebec_foxtrot_golf'golf_papa for romeo_tango'bravo_delta'kilo_echo'whiskey_mike'tango_golf'yankee_six'two_foxtrot'whiskey_mike'tango_golf'tango_five'foxtrot_sierra'delta_hotel_four'kilo_india'charlie_alpha'tango_golf'yankee_six'four_juliet'whiskey_mike'tango_golf'echo_two'uniform_foxtrot'quebec_yankee'tango_golf'whiskey_kilo_echo'Not tango_golf'bravo_delta'kilo_echo'delta_whiskey'two_foxtrot'november_sierra'foxtrot_sierra'delta_hotel_four'kilo_india'charlie_alpha'india_xray tango_bravo'two_romeo'four_juliet'whiskey_mike'seven_alpha three_juliet'six_juliet_xray'uniform_foxtrot'november_charlie'uniform_foxtrot'kilo_mike_oscar'seven_alpha three_juliet'echo_echo'kilo_two romeo_delta'two_mike_lima'Not tango_golf'november_five'whiskey_uniform'whiskey_mike'quebec_foxtrot_whiskey'tango_papa'echo_papa'whiskey_mike'kilo_oscar'whiskey_kilo_echo'whiskey_uniform/november_xray_golf'foxtrot_xray'whiskey_uniform'whiskey_mike'quebec_foxtrot_whiskey'victor_victor_quebec_two'echo_papa'whiskey_mike'kilo_oscar'romeo_victor'echo_papa'whiskey_mike'kilo_oscar'uniform_three'whiskey_uniform'whiskey_mike'quebec_foxtrot_whiskey'whiskey_kilo_echo'whiskey_uniform/november_xray_golf'::text END)
2. 4.008 4,719.968 ↓ 26.1 1,987 1

Sort (cost=708,036.720..708,036.910 rows=76 width=897) (actual time=4,719.393..4,719.968 rows=1,987 loops=1)

  • Sort Key: lima_delta_tango.quebec_seven, (juliet_golf((lima_delta_tango.seven_golf)::text, (lima_delta_tango.kilo_kilo_alpha)::text)), zulu_delta.bravo_papa, (juliet_golf((quebec_foxtrot_two.seven_golf)::text, (quebec_foxtrot_two.kilo_kilo_alpha)::text)), quebec_foxtrot_two.zulu_lima, lima_delta_sierra.victor_zulu, five_hotel.two_three, five_hotel.mike_oscar, three_four.seven_delta, hotel_zulu_three.victor_juliet, five_yankee_sierra1.november_lima, five_yankee_sierra2.november_lima, charlie_zulu.two_mike_three, ((charlie_xray('november_victor'::text, ((papa_delta((echo_tango('uniform_whiskey'::text, foxtrot_six.tango_delta) + (((((charlie_quebec.seven_two)::text || ''yankee_foxtrot_three'india_golf'xray_romeo'india_golf'oscar_echo'echo_seven_xray'four_echo'sierra_three'golf_mike'papa_kilo'sierra_two'romeo_lima_alpha'five_golf'india_golf'kilo_seven'india_golf'kilo_delta'echo_seven_xray'xray_five_kilo'sierra_three'yankee_three_sierra'kilo_echo'yankee_three_yankee'two_foxtrot'romeo_juliet'papa_tango'whiskey_sierra'yankee_yankee'golf_hotel'four_juliet'uniform_charlie'india_golf'november_bravo'kilo_echo'zulu_victor'golf_papa for romeo_tango'november_bravo'kilo_echo'alpha_four'papa_tango'sierra_zulu'yankee_yankee'india_papa'four_juliet'alpha_mike'echo_seven_xray'quebec_foxtrot_golf'golf_papa for romeo_tango'bravo_delta'kilo_echo'whiskey_mike'tango_golf'yankee_six'two_foxtrot'whiskey_mike'tango_golf'tango_five'foxtrot_sierra'delta_hotel_four'kilo_india'charlie_alpha'tango_golf'yankee_six'four_juliet'whiskey_mike'tango_golf'echo_two'uniform_foxtrot'quebec_yankee'tango_golf'whiskey_kilo_echo'Not tango_golf'bravo_delta'kilo_echo'delta_whiskey'two_foxtrot'november_sierra'foxtrot_sierra'delta_hotel_four'kilo_india'charlie_alpha'india_xray tango_bravo'two_romeo'four_juliet'whiskey_mike'seven_alpha three_juliet'six_juliet_xray'uniform_foxtrot'november_charlie'uniform_foxtrot'kilo_mike_oscar'seven_alpha three_juliet'echo_echo'kilo_two romeo_delta'two_mike_lima'Not tango_golf'november_five'whiskey_uniform'whiskey_mike'quebec_foxtrot_whiskey'tango_papa'echo_papa'whiskey_mike'kilo_oscar'whiskey_kilo_echo'whiskey_uniform/november_xray_golf'foxtrot_xray'whiskey_uniform'whiskey_mike'quebec_foxtrot_whiskey'victor_victor_quebec_two'echo_papa'whiskey_mike'kilo_oscar'romeo_victor'echo_papa'whiskey_mike'kilo_oscar'uniform_three'whiskey_uniform'whiskey_mike'quebec_foxtrot_whiskey'whiskey_kilo_echo'whiskey_uniform/november_xray_golf'::text END)
  • Sort Method: quicksort Memory: 1036kB
3. 22.042 4,715.960 ↓ 26.1 1,987 1

Hash Left Join (cost=485,287.150..708,034.350 rows=76 width=897) (actual time=4,131.312..4,715.960 rows=1,987 loops=1)

  • Hash Cond: (charlie_zulu.quebec_seven = alpha_bravo.kilo_mike_delta)
4. 1.254 4,676.316 ↓ 26.1 1,987 1

Hash Left Join (cost=485,285.140..707,818.490 rows=76 width=801) (actual time=4,131.213..4,676.316 rows=1,987 loops=1)

  • Hash Cond: (five_five.victor_victor_quebec_mike1 = five_yankee_sierra1.quebec_seven)
5. 1.577 4,674.986 ↓ 26.1 1,987 1

Hash Join (cost=485,277.030..707,809.340 rows=76 width=798) (actual time=4,131.130..4,674.986 rows=1,987 loops=1)

  • Hash Cond: ((five_hotel.charlie_xray)::text = (charlie_quebec.oscar_five)::text)
6. 1.357 4,673.399 ↓ 26.1 1,987 1

Hash Left Join (cost=485,275.990..707,807.250 rows=76 width=792) (actual time=4,131.111..4,673.399 rows=1,987 loops=1)

  • Hash Cond: (foxtrot_six.kilo_romeo = kilo_three.quebec_seven)
7. 1.035 4,671.868 ↓ 26.1 1,987 1

Hash Left Join (cost=485,255.650..707,785.860 rows=76 width=780) (actual time=4,130.932..4,671.868 rows=1,987 loops=1)

  • Hash Cond: (zulu_delta.alpha_delta = golf_november.quebec_seven)
8. 7.819 4,670.653 ↓ 26.1 1,987 1

Hash Join (cost=485,235.300..707,765.220 rows=76 width=768) (actual time=4,130.743..4,670.653 rows=1,987 loops=1)

  • Hash Cond: (five_hotel.quebec_seven = five_five.zulu_tango)
9. 10.316 4,655.570 ↓ 1.8 30,619 1

Hash Left Join (cost=484,153.160..706,618.070 rows=17,132 width=765) (actual time=4,113.323..4,655.570 rows=30,619 loops=1)

  • Hash Cond: (zulu_delta.two_five = lima_papa.quebec_seven)
10. 10.418 4,645.011 ↓ 1.8 30,619 1

Hash Left Join (cost=484,132.810..706,533.470 rows=17,132 width=753) (actual time=4,113.071..4,645.011 rows=30,619 loops=1)

  • Hash Cond: (four_delta2.kilo_romeo = three_six.quebec_seven)
11. 12.687 4,634.329 ↓ 1.8 30,619 1

Hash Left Join (cost=484,112.470..706,314.460 rows=17,132 width=741) (actual time=4,112.801..4,634.329 rows=30,619 loops=1)

  • Hash Cond: (four_delta1.kilo_romeo = november_xray_yankee.quebec_seven)
12. 12.416 4,621.447 ↓ 1.8 30,619 1

Hash Left Join (cost=484,092.130..706,095.460 rows=17,132 width=729) (actual time=4,112.600..4,621.447 rows=30,619 loops=1)

  • Hash Cond: (zulu_delta.kilo_mike_delta = charlie_zulu.quebec_seven)
13. 13.550 4,609.000 ↓ 1.8 30,619 1

Hash Join (cost=484,090.120..705,859.790 rows=17,132 width=716) (actual time=4,112.560..4,609.000 rows=30,619 loops=1)

  • Hash Cond: (six_zulu_bravo.kilo_sierra = hotel_zulu_three.quebec_seven)
14. 12.966 4,595.418 ↓ 1.8 30,619 1

Hash Join (cost=484,087.070..705,621.180 rows=17,132 width=711) (actual time=4,112.518..4,595.418 rows=30,619 loops=1)

  • Hash Cond: (five_hotel.xray_five_xray = charlie_hotel.quebec_seven)
15. 14.516 4,582.431 ↓ 1.8 30,619 1

Hash Join (cost=484,084.710..705,383.250 rows=17,132 width=715) (actual time=4,112.489..4,582.431 rows=30,619 loops=1)

  • Hash Cond: (five_hotel.kilo_sierra = six_zulu_bravo.quebec_seven)
16. 16.865 4,567.895 ↓ 1.8 30,619 1

Hash Join (cost=484,082.470..705,145.450 rows=17,132 width=715) (actual time=4,112.461..4,567.895 rows=30,619 loops=1)

  • Hash Cond: (five_hotel.whiskey_india = three_four.quebec_seven)
17. 13.704 4,549.373 ↓ 1.8 30,619 1

Hash Join (cost=483,890.290..704,717.700 rows=17,132 width=710) (actual time=4,110.768..4,549.373 rows=30,619 loops=1)

  • Hash Cond: (lima_delta_tango.whiskey_november = lima_delta_sierra.quebec_seven)
18. 11.984 4,535.546 ↓ 1.8 30,619 1

Hash Left Join (cost=483,876.510..704,468.360 rows=17,132 width=696) (actual time=4,110.636..4,535.546 rows=30,619 loops=1)

  • Hash Cond: (lima_delta_tango.quebec_seven = romeo_romeo.quebec_seven)
  • Join Filter: (xray_golf.romeo_golf = 'victor_whiskey'::date)
19. 10.461 4,523.480 ↓ 1.8 30,619 1

Hash Left Join (cost=483,811.050..704,338.650 rows=17,132 width=696) (actual time=4,110.549..4,523.480 rows=30,619 loops=1)

  • Hash Cond: (lima_delta_tango.quebec_seven = xray_golf.quebec_seven)
20. 14.094 4,512.854 ↓ 1.8 30,619 1

Hash Left Join (cost=474,737.170..692,798.760 rows=17,132 width=688) (actual time=4,110.372..4,512.854 rows=30,619 loops=1)

  • Hash Cond: (lima_delta_tango.quebec_seven = foxtrot_tango.delta_mike)
21. 18.139 4,490.207 ↓ 1.8 30,619 1

Nested Loop Left Join (cost=473,368.380..690,658.850 rows=17,132 width=688) (actual time=4,101.808..4,490.207 rows=30,619 loops=1)

22. 9.066 4,472.068 ↓ 1.8 30,619 1

Nested Loop Left Join (cost=473,368.090..676,741.450 rows=17,132 width=666) (actual time=4,101.805..4,472.068 rows=30,619 loops=1)

23. 23.413 4,401.764 ↓ 1.8 30,619 1

Hash Join (cost=473,367.800..662,859.670 rows=17,132 width=638) (actual time=4,101.792..4,401.764 rows=30,619 loops=1)

  • Hash Cond: (lima_delta_tango.foxtrot_yankee = five_hotel.quebec_seven)
24. 941.488 4,354.797 ↓ 1.8 30,619 1

Hash Right Join (cost=471,034.800..660,291.110 rows=17,132 width=590) (actual time=4,077.996..4,354.797 rows=30,619 loops=1)

  • Hash Cond: (four_delta2.yankee_xray = foxtrot_six.quebec_seven)
  • Join Filter: (four_delta1.golf_tango_victor = 2)
  • Rows Removed by Join Filter: 24322
25. 685.493 685.493 ↑ 1.1 3,890,672 1

Seq Scan on foxtrot_foxtrot tango_kilo (cost=0.000..127,641.000 rows=4,452,800 width=12) (actual time=0.090..685.493 rows=3,890,672 loops=1)

26. 25.241 2,727.816 ↓ 1.8 30,619 1

Hash (cost=469,531.650..469,531.650 rows=17,132 width=590) (actual time=2,727.816..2,727.816 rows=30,619 loops=1)

  • Buckets: 8192 Batches: 4 Memory Usage: 3359kB
27. 1,109.041 2,702.575 ↓ 1.8 30,619 1

Hash Right Join (cost=274,698.840..469,531.650 rows=17,132 width=590) (actual time=1,973.274..2,702.575 rows=30,619 loops=1)

  • Hash Cond: (four_delta1.yankee_xray = foxtrot_six.quebec_seven)
28. 1,053.607 1,053.607 ↑ 1.1 3,540,846 1

Seq Scan on foxtrot_foxtrot xray_alpha (cost=0.000..138,773.000 rows=4,045,963 width=16) (actual time=0.110..1,053.607 rows=3,540,846 loops=1)

  • Filter: (golf_tango_victor = 1)
  • Rows Removed by Filter: 349826
29. 25.043 539.927 ↓ 1.8 30,615 1

Hash (cost=273,212.690..273,212.690 rows=17,132 width=578) (actual time=539.927..539.927 rows=30,615 loops=1)

  • Buckets: 8192 Batches: 4 Memory Usage: 3293kB
30. 23.825 514.884 ↓ 1.8 30,615 1

Nested Loop Left Join (cost=35,492.680..273,212.690 rows=17,132 width=578) (actual time=291.920..514.884 rows=30,615 loops=1)

31. 6.976 429.829 ↓ 1.8 30,615 1

Merge Left Join (cost=35,492.250..161,949.450 rows=17,132 width=199) (actual time=291.910..429.829 rows=30,615 loops=1)

  • Merge Cond: (lima_delta_tango.quebec_seven = juliet_four.hotel_quebec)
32. 22.755 411.133 ↓ 1.8 30,614 1

Nested Loop Left Join (cost=31,694.970..158,030.000 rows=17,132 width=181) (actual time=280.245..411.133 rows=30,614 loops=1)

33. 8.662 296.536 ↓ 1.8 30,614 1

Merge Left Join (cost=31,694.410..31,804.700 rows=17,132 width=129) (actual time=280.229..296.536 rows=30,614 loops=1)

  • Merge Cond: (lima_delta_tango.quebec_seven = oscar_bravo.hotel_quebec)
34. 35.576 285.051 ↓ 1.8 30,614 1

Sort (cost=30,824.040..30,866.870 rows=17,132 width=121) (actual time=277.410..285.051 rows=30,614 loops=1)

  • Sort Key: lima_delta_tango.quebec_seven
  • Sort Method: external merge Disk: 3704kB
35. 10.576 249.475 ↓ 1.8 30,614 1

Hash Right Join (cost=13,408.200..29,619.280 rows=17,132 width=121) (actual time=230.294..249.475 rows=30,614 loops=1)

  • Hash Cond: (zulu_india.hotel_quebec = lima_delta_tango.quebec_seven)
36. 67.214 67.214 ↑ 12.6 3,722 1

Seq Scan on alpha_india zulu_india (cost=0.000..15,898.330 rows=47,077 width=8) (actual time=41.107..67.214 rows=3,722 loops=1)

  • Filter: (('victor_whiskey'::date >= juliet_alpha_hotel) AND ('victor_whiskey'::date <= hotel_delta))
  • Rows Removed by Filter: 518936
37. 14.123 171.685 ↓ 1.8 30,599 1

Hash (cost=13,194.050..13,194.050 rows=17,132 width=113) (actual time=171.685..171.685 rows=30,599 loops=1)

  • Buckets: 32768 (originally 32768) Batches: 2 (originally 1) Memory Usage: 3841kB
38. 12.434 157.562 ↓ 1.8 30,599 1

Hash Right Join (cost=11,328.770..13,194.050 rows=17,132 width=113) (actual time=143.983..157.562 rows=30,599 loops=1)

  • Hash Cond: (sierra_november.hotel_quebec = lima_delta_tango.quebec_seven)
39. 7.850 7.850 ↑ 21.8 398 1

Seq Scan on two_charlie sierra_november (cost=0.000..1,807.670 rows=8,672 width=8) (actual time=6.543..7.850 rows=398 loops=1)

  • Filter: (('victor_whiskey'::date >= juliet_alpha_hotel) AND ('victor_whiskey'::date <= hotel_delta))
  • Rows Removed by Filter: 59147
40. 14.080 137.278 ↓ 1.8 30,598 1

Hash (cost=11,114.620..11,114.620 rows=17,132 width=105) (actual time=137.278..137.278 rows=30,598 loops=1)

  • Buckets: 32768 (originally 32768) Batches: 2 (originally 1) Memory Usage: 3841kB
41. 6.619 123.198 ↓ 1.8 30,598 1

Hash Join (cost=8,381.280..11,114.620 rows=17,132 width=105) (actual time=78.517..123.198 rows=30,598 loops=1)

  • Hash Cond: (mike_delta.golf_tango_echo = foxtrot_five.golf_tango_echo)
42. 26.351 116.550 ↓ 1.2 31,526 1

Hash Join (cost=8,377.980..10,839.190 rows=26,880 width=109) (actual time=78.480..116.550 rows=31,526 loops=1)

  • Hash Cond: (mike_delta.zulu_lima = kilo_hotel.quebec_seven)
43. 11.995 11.995 ↑ 1.0 60,571 1

Seq Scan on papa_papa mike_delta (cost=0.000..1,963.710 rows=60,986 width=8) (actual time=0.112..11.995 rows=60,571 loops=1)

  • Filter: (yankee_zulu = 1)
  • Rows Removed by Filter: 23812
44. 15.303 78.204 ↓ 1.2 30,599 1

Hash (cost=8,052.040..8,052.040 rows=26,075 width=109) (actual time=78.204..78.204 rows=30,599 loops=1)

  • Buckets: 32768 (originally 32768) Batches: 2 (originally 1) Memory Usage: 3841kB
45. 16.000 62.901 ↓ 1.2 30,599 1

Hash Join (cost=2,959.530..8,052.040 rows=26,075 width=109) (actual time=22.518..62.901 rows=30,599 loops=1)

  • Hash Cond: (lima_delta_tango.quebec_seven = kilo_hotel.delta_bravo_uniform)
46. 24.701 24.701 ↑ 1.1 30,599 1

Seq Scan on delta_juliet lima_delta_tango (cost=0.000..4,589.100 rows=32,355 width=105) (actual time=0.080..24.701 rows=30,599 loops=1)

  • Filter: ((uniform_six = 7) AND (yankee_zulu = 1))
  • Rows Removed by Filter: 28635
47. 7.376 22.200 ↓ 1.0 47,834 1

Hash (cost=2,362.490..2,362.490 rows=47,763 width=8) (actual time=22.200..22.200 rows=47,834 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2381kB
48. 14.824 14.824 ↓ 1.0 47,850 1

Seq Scan on lima_november kilo_hotel (cost=0.000..2,362.490 rows=47,763 width=8) (actual time=0.083..14.824 rows=47,850 loops=1)

  • Filter: (uniform_six = 7)
  • Rows Removed by Filter: 11438
49. 0.010 0.029 ↓ 1.1 62 1

Hash (cost=2.580..2.580 rows=58 width=4) (actual time=0.029..0.029 rows=62 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
50. 0.019 0.019 ↓ 1.1 62 1

Seq Scan on sierra_alpha foxtrot_five (cost=0.000..2.580 rows=58 width=4) (actual time=0.004..0.019 rows=62 loops=1)

51. 0.031 2.823 ↑ 62.4 50 1

Sort (cost=870.370..878.170 rows=3,120 width=8) (actual time=2.815..2.823 rows=50 loops=1)

  • Sort Key: oscar_bravo.hotel_quebec
  • Sort Method: quicksort Memory: 27kB
52. 2.792 2.792 ↑ 62.4 50 1

Seq Scan on november_whiskey oscar_bravo (cost=0.000..689.290 rows=3,120 width=8) (actual time=2.351..2.792 rows=50 loops=1)

  • Filter: (('victor_whiskey'::date >= juliet_alpha_hotel) AND ('victor_whiskey'::date <= hotel_delta))
  • Rows Removed by Filter: 22695
53. 91.842 91.842 ↑ 1.0 1 30,614

Index Scan using november_echo on tango_four zulu_delta (cost=0.560..7.360 rows=1 width=56) (actual time=0.003..0.003 rows=1 loops=30,614)

  • Index Cond: ((hotel_quebec = lima_delta_tango.quebec_seven) AND (foxtrot_three = 'golf_tango_uniform'::timestamp without time zone) AND (oscar_seven = 0))
54. 0.119 11.720 ↑ 45.7 220 1

Sort (cost=3,797.270..3,822.400 rows=10,052 width=18) (actual time=11.660..11.720 rows=220 loops=1)

  • Sort Key: juliet_four.hotel_quebec
  • Sort Method: quicksort Memory: 42kB
55. 0.055 11.601 ↑ 45.7 220 1

Hash Left Join (cost=3.670..3,129.060 rows=10,052 width=18) (actual time=0.925..11.601 rows=220 loops=1)

  • Hash Cond: (juliet_four.sierra_mike = lima_four.quebec_seven)
56. 11.513 11.513 ↑ 45.7 220 1

Seq Scan on whiskey_victor juliet_four (cost=0.000..2,987.180 rows=10,052 width=12) (actual time=0.883..11.513 rows=220 loops=1)

  • Filter: (('victor_whiskey'::date >= juliet_alpha_hotel) AND ('victor_whiskey'::date <= hotel_delta) AND (yankee_zulu = 1))
  • Rows Removed by Filter: 87579
57. 0.016 0.033 ↓ 1.1 81 1

Hash (cost=2.740..2.740 rows=74 width=14) (actual time=0.033..0.033 rows=81 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
58. 0.017 0.017 ↓ 1.1 81 1

Seq Scan on tango_alpha lima_four (cost=0.000..2.740 rows=74 width=14) (actual time=0.004..0.017 rows=81 loops=1)

59. 61.230 61.230 ↑ 1.0 1 30,615

Index Scan using six_zulu_three on yankee_foxtrot_hotel foxtrot_six (cost=0.430..6.480 rows=1 width=387) (actual time=0.002..0.002 rows=1 loops=30,615)

  • Index Cond: ((five_yankee_hotel = zulu_delta.quebec_seven) AND (romeo_four = 1))
60. 10.647 23.554 ↑ 1.0 41,771 1

Hash (cost=1,810.220..1,810.220 rows=41,822 width=48) (actual time=23.554..23.554 rows=41,771 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3886kB
61. 12.907 12.907 ↑ 1.0 41,771 1

Seq Scan on kilo_kilo_uniform five_hotel (cost=0.000..1,810.220 rows=41,822 width=48) (actual time=0.078..12.907 rows=41,771 loops=1)

62. 61.238 61.238 ↑ 1.0 1 30,619

Index Scan using xray_three on delta_juliet quebec_foxtrot_two (cost=0.290..0.800 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=30,619)

  • Index Cond: (quebec_seven = lima_delta_tango.whiskey_oscar)
63. 0.000 0.000 ↓ 0.0 0 30,619

Index Scan using xray_three on delta_juliet five_juliet (cost=0.290..0.800 rows=1 width=26) (actual time=0.000..0.000 rows=0 loops=30,619)

  • Index Cond: (quebec_seven = zulu_delta.six_tango)
64. 1.623 8.553 ↓ 189.3 11,356 1

Hash (cost=1,368.050..1,368.050 rows=60 width=4) (actual time=8.553..8.553 rows=11,356 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 528kB
65. 6.930 6.930 ↓ 189.3 11,356 1

Seq Scan on two_india foxtrot_tango (cost=0.000..1,368.050 rows=60 width=4) (actual time=0.089..6.930 rows=11,356 loops=1)

  • Filter: ((yankee_zulu = 1) AND ('four_uniform'::double precision = (mike_three)::double precision))
  • Rows Removed by Filter: 39586
66. 0.000 0.165 ↓ 0.0 0 1

Hash (cost=9,059.730..9,059.730 rows=1,132 width=8) (actual time=0.165..0.165 rows=0 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
67. 0.001 0.165 ↓ 0.0 0 1

Subquery Scan on xray_golf (cost=9,037.090..9,059.730 rows=1,132 width=8) (actual time=0.165..0.165 rows=0 loops=1)

68. 0.005 0.164 ↓ 0.0 0 1

HashAggregate (cost=9,037.090..9,048.410 rows=1,132 width=892) (actual time=0.164..0.164 rows=0 loops=1)

  • Group Key: echo_seven_kilo.india_four, echo_seven_kilo.romeo_golf, (xray_yankee((echo_seven_kilo.romeo_golf)::timestamp with time zone, 'delta_bravo_mike'::text)), six_alpha1.quebec_seven, six_alpha1.foxtrot_yankee, six_alpha1.zulu_lima, six_alpha1.seven_golf, whiskey_golf1.xray_five_xray, whiskey_golf1.kilo_sierra, whiskey_golf1.whiskey_india, six_alpha1.uniform_six
69. 0.001 0.159 ↓ 0.0 0 1

Append (cost=3,128.520..9,005.960 rows=1,132 width=892) (actual time=0.159..0.159 rows=0 loops=1)

70. 0.004 0.048 ↓ 0.0 0 1

HashAggregate (cost=3,128.520..3,143.900 rows=1,025 width=97) (actual time=0.048..0.048 rows=0 loops=1)

  • Group Key: echo_seven_kilo.india_four, echo_seven_kilo.romeo_golf, six_alpha1.quebec_seven, whiskey_golf1.xray_five_xray, whiskey_golf1.kilo_sierra, whiskey_golf1.whiskey_india
71. 0.000 0.044 ↓ 0.0 0 1

Nested Loop (cost=81.120..3,113.150 rows=1,025 width=65) (actual time=0.044..0.044 rows=0 loops=1)

  • Join Filter: (echo_seven_kilo.xray_five_xray = whiskey_golf1.xray_five_xray)
72. 0.001 0.044 ↓ 0.0 0 1

Nested Loop (cost=80.830..2,626.990 rows=1,032 width=57) (actual time=0.044..0.044 rows=0 loops=1)

73. 0.043 0.043 ↓ 0.0 0 1

Seq Scan on six_oscar echo_seven_kilo (cost=0.000..8.180 rows=1 width=25) (actual time=0.043..0.043 rows=0 loops=1)

  • Filter: ((zulu_foxtrot = 1) AND (yankee_zulu = 1) AND (romeo_golf = 'victor_whiskey'::date))
  • Rows Removed by Filter: 214
74. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on delta_juliet three_kilo (cost=80.830..2,606.700 rows=1,211 width=36) (never executed)

  • Recheck Cond: ((uniform_six = echo_seven_kilo.uniform_six) AND (yankee_zulu = 1))
75. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on quebec_two (cost=0.000..80.530 rows=1,211 width=0) (never executed)

  • Index Cond: ((uniform_six = echo_seven_kilo.uniform_six) AND (yankee_zulu = 1))
76. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey_kilo_romeo on kilo_kilo_uniform yankee_seven (cost=0.290..0.460 rows=1 width=16) (never executed)

  • Index Cond: (quebec_seven = six_alpha1.foxtrot_yankee)
77. 0.000 0.061 ↓ 0.0 0 1

Group (cost=3,198.250..3,200.260 rows=89 width=97) (actual time=0.061..0.061 rows=0 loops=1)

  • Group Key: tango_three1.india_four, tango_three1.romeo_golf, six_alpha2.quebec_seven, whiskey_golf2.xray_five_xray, whiskey_golf2.kilo_sierra, whiskey_golf2.whiskey_india
78. 0.009 0.061 ↓ 0.0 0 1

Sort (cost=3,198.250..3,198.480 rows=89 width=65) (actual time=0.061..0.061 rows=0 loops=1)

  • Sort Key: tango_three1.india_four, six_alpha2.quebec_seven, whiskey_golf2.xray_five_xray, whiskey_golf2.kilo_sierra, whiskey_golf2.whiskey_india
  • Sort Method: quicksort Memory: 25kB
79. 0.001 0.052 ↓ 0.0 0 1

Merge Join (cost=282.630..3,195.370 rows=89 width=65) (actual time=0.052..0.052 rows=0 loops=1)

  • Merge Cond: (tango_three1.quebec_seven = juliet_lima1.hotel_zulu_two)
  • Join Filter: (whiskey_golf2.kilo_sierra = juliet_lima1.kilo_sierra)
80. 0.001 0.051 ↓ 0.0 0 1

Nested Loop (cost=81.260..3,122.990 rows=1,032 width=69) (actual time=0.051..0.051 rows=0 loops=1)

81. 0.000 0.050 ↓ 0.0 0 1

Nested Loop (cost=80.970..2,639.410 rows=1,032 width=57) (actual time=0.050..0.050 rows=0 loops=1)

82. 0.050 0.050 ↓ 0.0 0 1

Index Scan using india_sierra on six_oscar kilo_six (cost=0.140..20.600 rows=1 width=25) (actual time=0.050..0.050 rows=0 loops=1)

  • Filter: ((romeo_lima_victor = 1) AND (yankee_zulu = 1) AND (romeo_golf = 'victor_whiskey'::date))
  • Rows Removed by Filter: 214
83. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on delta_juliet oscar_tango (cost=80.830..2,606.700 rows=1,211 width=36) (never executed)

  • Recheck Cond: ((uniform_six = tango_three1.uniform_six) AND (yankee_zulu = 1))
84. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on quebec_two (cost=0.000..80.530 rows=1,211 width=0) (never executed)

  • Index Cond: ((uniform_six = tango_three1.uniform_six) AND (yankee_zulu = 1))
85. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey_kilo_romeo on kilo_kilo_uniform lima_romeo (cost=0.290..0.460 rows=1 width=16) (never executed)

  • Index Cond: (quebec_seven = six_alpha2.foxtrot_yankee)
86. 0.000 0.000 ↓ 0.0 0

Sort (cost=33.220..34.540 rows=529 width=8) (never executed)

  • Sort Key: juliet_lima1.hotel_zulu_two
87. 0.000 0.000 ↓ 0.0 0

Seq Scan on alpha_lima quebec_kilo (cost=0.000..9.290 rows=529 width=8) (never executed)

88. 0.001 0.049 ↓ 0.0 0 1

Group (cost=2,650.080..2,650.480 rows=18 width=97) (actual time=0.049..0.049 rows=0 loops=1)

  • Group Key: tango_three2.india_four, tango_three2.romeo_golf, six_alpha3.quebec_seven, whiskey_golf3.xray_five_xray, whiskey_golf3.kilo_sierra, whiskey_golf3.whiskey_india
89. 0.003 0.048 ↓ 0.0 0 1

Sort (cost=2,650.080..2,650.120 rows=18 width=65) (actual time=0.048..0.048 rows=0 loops=1)

  • Sort Key: tango_three2.india_four, six_alpha3.quebec_seven, whiskey_golf3.xray_five_xray, whiskey_golf3.kilo_sierra, whiskey_golf3.whiskey_india
  • Sort Method: quicksort Memory: 25kB
90. 0.002 0.045 ↓ 0.0 0 1

Merge Join (cost=250.670..2,649.700 rows=18 width=65) (actual time=0.045..0.045 rows=0 loops=1)

  • Merge Cond: (tango_three2.quebec_seven = juliet_alpha_victor.hotel_zulu_two)
  • Join Filter: (whiskey_golf3.whiskey_india = juliet_alpha_victor.whiskey_india)
91. 0.000 0.043 ↓ 0.0 0 1

Nested Loop (cost=81.260..3,122.990 rows=1,032 width=69) (actual time=0.043..0.043 rows=0 loops=1)

92. 0.000 0.043 ↓ 0.0 0 1

Nested Loop (cost=80.970..2,639.410 rows=1,032 width=57) (actual time=0.043..0.043 rows=0 loops=1)

93. 0.043 0.043 ↓ 0.0 0 1

Index Scan using india_sierra on six_oscar six_juliet_four (cost=0.140..20.600 rows=1 width=25) (actual time=0.043..0.043 rows=0 loops=1)

  • Filter: ((four_whiskey = 1) AND (yankee_zulu = 1) AND (romeo_golf = 'victor_whiskey'::date))
  • Rows Removed by Filter: 214
94. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on delta_juliet yankee_kilo (cost=80.830..2,606.700 rows=1,211 width=36) (never executed)

  • Recheck Cond: ((uniform_six = tango_three2.uniform_six) AND (yankee_zulu = 1))
95. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on quebec_two (cost=0.000..80.530 rows=1,211 width=0) (never executed)

  • Index Cond: ((uniform_six = tango_three2.uniform_six) AND (yankee_zulu = 1))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey_kilo_romeo on kilo_kilo_uniform charlie_tango (cost=0.290..0.460 rows=1 width=16) (never executed)

  • Index Cond: (quebec_seven = six_alpha3.foxtrot_yankee)
97. 0.000 0.000 ↓ 0.0 0

Sort (cost=1.270..1.290 rows=10 width=8) (never executed)

  • Sort Key: juliet_alpha_victor.hotel_zulu_two
98. 0.000 0.000 ↓ 0.0 0

Seq Scan on echo_lima juliet_alpha_victor (cost=0.000..1.100 rows=10 width=8) (never executed)

99. 0.000 0.082 ↓ 0.0 0 1

Hash (cost=65.420..65.420 rows=3 width=4) (actual time=0.082..0.082 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
100. 0.001 0.082 ↓ 0.0 0 1

Subquery Scan on romeo_romeo (cost=65.360..65.420 rows=3 width=4) (actual time=0.082..0.082 rows=0 loops=1)

101. 0.001 0.081 ↓ 0.0 0 1

HashAggregate (cost=65.360..65.390 rows=3 width=892) (actual time=0.081..0.081 rows=0 loops=1)

  • Group Key: tango_three3.india_four, tango_three3.romeo_golf, (xray_yankee((tango_three3.romeo_golf)::timestamp with time zone, 'delta_bravo_mike'::text)), six_alpha4.quebec_seven, six_alpha4.foxtrot_yankee, six_alpha4.zulu_lima, six_alpha4.seven_golf, whiskey_golf4.xray_five_xray, whiskey_golf4.kilo_sierra, whiskey_golf4.whiskey_india, tango_three3.uniform_six
102. 0.002 0.080 ↓ 0.0 0 1

Append (cost=0.700..65.280 rows=3 width=892) (actual time=0.080..0.080 rows=0 loops=1)

103. 0.001 0.053 ↓ 0.0 0 1

Nested Loop (cost=0.700..21.630 rows=1 width=97) (actual time=0.053..0.053 rows=0 loops=1)

  • Join Filter: (whiskey_golf4.quebec_seven = six_alpha4.foxtrot_yankee)
104. 0.000 0.052 ↓ 0.0 0 1

Nested Loop (cost=0.290..13.610 rows=1 width=37) (actual time=0.052..0.052 rows=0 loops=1)

  • Join Filter: (tango_three3.xray_five_xray = whiskey_golf4.xray_five_xray)
105. 0.052 0.052 ↓ 0.0 0 1

Seq Scan on six_oscar three_romeo (cost=0.000..7.580 rows=1 width=25) (actual time=0.052..0.052 rows=0 loops=1)

  • Filter: ((uniform_six five_romeo NULL) AND (zulu_foxtrot = 1) AND (yankee_zulu = 1))
  • Rows Removed by Filter: 214
106. 0.000 0.000 ↓ 0.0 0

Index Scan using charlie_romeo on kilo_kilo_uniform quebec_zulu (cost=0.290..6.010 rows=1 width=16) (never executed)

  • Index Cond: (uniform_six five_romeo NULL)
107. 0.000 0.000 ↓ 0.0 0

Index Scan using quebec_two on delta_juliet seven_hotel (cost=0.410..8.010 rows=1 width=32) (never executed)

  • Index Cond: (uniform_six five_romeo NULL)
108. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=14.190..25.780 rows=1 width=97) (actual time=0.022..0.022 rows=0 loops=1)

109. 0.007 0.022 ↓ 0.0 0 1

Hash Join (cost=14.040..25.550 rows=1 width=48) (actual time=0.022..0.022 rows=0 loops=1)

  • Hash Cond: (juliet_lima2.kilo_sierra = whiskey_golf5.kilo_sierra)
110. 0.008 0.008 ↑ 529.0 1 1

Seq Scan on alpha_lima delta_uniform (cost=0.000..9.290 rows=529 width=8) (actual time=0.008..0.008 rows=1 loops=1)

111. 0.000 0.007 ↓ 0.0 0 1

Hash (cost=14.030..14.030 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
112. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.700..14.030 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=1)

  • Join Filter: (whiskey_golf5.quebec_seven = six_alpha5.foxtrot_yankee)
113. 0.007 0.007 ↓ 0.0 0 1

Index Scan using charlie_romeo on kilo_kilo_uniform oscar_mike (cost=0.290..6.010 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (uniform_six five_romeo NULL)
114. 0.000 0.000 ↓ 0.0 0

Index Scan using quebec_two on delta_juliet three_november (cost=0.410..8.010 rows=1 width=32) (never executed)

  • Index Cond: (uniform_six five_romeo NULL)
115. 0.000 0.000 ↓ 0.0 0

Index Scan using india_sierra on six_oscar delta_tango (cost=0.140..0.210 rows=1 width=25) (never executed)

  • Index Cond: (quebec_seven = juliet_lima2.hotel_zulu_two)
  • Filter: ((uniform_six five_romeo NULL) AND (romeo_lima_victor = 1) AND (yankee_zulu = 1))
116. 0.001 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.850..17.840 rows=1 width=97) (actual time=0.003..0.003 rows=0 loops=1)

  • Join Filter: (whiskey_golf6.quebec_seven = six_alpha6.foxtrot_yankee)
117. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.430..9.820 rows=1 width=37) (actual time=0.002..0.002 rows=0 loops=1)

118. 0.000 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.290..7.240 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Join Filter: (foxtrot_whiskey1.whiskey_india = whiskey_golf6.whiskey_india)
119. 0.002 0.002 ↓ 0.0 0 1

Index Scan using charlie_romeo on kilo_kilo_uniform echo_three (cost=0.290..6.010 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (uniform_six five_romeo NULL)
120. 0.000 0.000 ↓ 0.0 0

Seq Scan on echo_lima foxtrot_oscar (cost=0.000..1.100 rows=10 width=8) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Index Scan using india_sierra on six_oscar five_kilo (cost=0.140..2.570 rows=1 width=25) (never executed)

  • Index Cond: (quebec_seven = foxtrot_whiskey1.hotel_zulu_two)
  • Filter: ((uniform_six five_romeo NULL) AND (four_whiskey = 1) AND (yankee_zulu = 1))
122. 0.000 0.000 ↓ 0.0 0

Index Scan using quebec_two on delta_juliet three_whiskey (cost=0.410..8.010 rows=1 width=32) (never executed)

  • Index Cond: (uniform_six five_romeo NULL)
123. 0.076 0.123 ↓ 1.0 397 1

Hash (cost=8.900..8.900 rows=390 width=22) (actual time=0.123..0.123 rows=397 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
124. 0.047 0.047 ↓ 1.0 397 1

Seq Scan on alpha_november lima_delta_sierra (cost=0.000..8.900 rows=390 width=22) (actual time=0.003..0.047 rows=397 loops=1)

125. 0.933 1.657 ↓ 1.0 5,821 1

Hash (cost=119.860..119.860 rows=5,786 width=13) (actual time=1.657..1.657 rows=5,821 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 330kB
126. 0.724 0.724 ↓ 1.0 5,821 1

Seq Scan on papa_whiskey three_four (cost=0.000..119.860 rows=5,786 width=13) (actual time=0.004..0.724 rows=5,821 loops=1)

127. 0.011 0.020 ↑ 1.0 55 1

Hash (cost=1.550..1.550 rows=55 width=8) (actual time=0.020..0.020 rows=55 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
128. 0.009 0.009 ↑ 1.0 55 1

Seq Scan on six_zulu_bravo (cost=0.000..1.550 rows=55 width=8) (actual time=0.003..0.009 rows=55 loops=1)

129. 0.004 0.021 ↑ 1.0 4 1

Hash (cost=2.310..2.310 rows=4 width=4) (actual time=0.021..0.021 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
130. 0.009 0.017 ↑ 1.0 4 1

Hash Join (cost=1.090..2.310 rows=4 width=4) (actual time=0.015..0.017 rows=4 loops=1)

  • Hash Cond: (four_kilo.xray_five_xray = charlie_hotel.xray_five_xray)
131. 0.002 0.002 ↑ 1.0 13 1

Seq Scan on victor_tango four_kilo (cost=0.000..1.130 rows=13 width=4) (actual time=0.002..0.002 rows=13 loops=1)

132. 0.004 0.006 ↑ 1.0 4 1

Hash (cost=1.040..1.040 rows=4 width=8) (actual time=0.006..0.006 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
133. 0.002 0.002 ↑ 1.0 4 1

Seq Scan on charlie_hotel (cost=0.000..1.040 rows=4 width=8) (actual time=0.002..0.002 rows=4 loops=1)

134. 0.017 0.032 ↑ 1.0 91 1

Hash (cost=1.910..1.910 rows=91 width=13) (actual time=0.032..0.032 rows=91 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
135. 0.015 0.015 ↑ 1.0 91 1

Seq Scan on bravo_echo hotel_zulu_three (cost=0.000..1.910 rows=91 width=13) (actual time=0.004..0.015 rows=91 loops=1)

136. 0.016 0.031 ↓ 1.1 48 1

Hash (cost=1.450..1.450 rows=45 width=17) (actual time=0.031..0.031 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
137. 0.015 0.015 ↓ 1.1 48 1

Seq Scan on delta_hotel_quebec charlie_zulu (cost=0.000..1.450 rows=45 width=17) (actual time=0.006..0.015 rows=48 loops=1)

138. 0.097 0.195 ↑ 1.0 591 1

Hash (cost=12.930..12.930 rows=593 width=20) (actual time=0.195..0.195 rows=591 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
139. 0.098 0.098 ↑ 1.0 591 1

Seq Scan on hotel_foxtrot november_xray_yankee (cost=0.000..12.930 rows=593 width=20) (actual time=0.003..0.098 rows=591 loops=1)

140. 0.145 0.264 ↑ 1.0 591 1

Hash (cost=12.930..12.930 rows=593 width=20) (actual time=0.264..0.264 rows=591 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
141. 0.119 0.119 ↑ 1.0 591 1

Seq Scan on hotel_foxtrot three_six (cost=0.000..12.930 rows=593 width=20) (actual time=0.005..0.119 rows=591 loops=1)

142. 0.128 0.243 ↑ 1.0 591 1

Hash (cost=12.930..12.930 rows=593 width=20) (actual time=0.243..0.243 rows=591 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
143. 0.115 0.115 ↑ 1.0 591 1

Seq Scan on hotel_foxtrot lima_papa (cost=0.000..12.930 rows=593 width=20) (actual time=0.003..0.115 rows=591 loops=1)

144. 0.379 7.264 ↓ 12.1 2,245 1

Hash (cost=1,079.820..1,079.820 rows=186 width=15) (actual time=7.264..7.264 rows=2,245 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 136kB
145. 3.934 6.885 ↓ 12.1 2,245 1

Hash Join (cost=5.570..1,079.820 rows=186 width=15) (actual time=0.135..6.885 rows=2,245 loops=1)

  • Hash Cond: (five_five.victor_victor_quebec_mike2 = five_yankee_sierra2.quebec_seven)
146. 2.919 2.919 ↑ 1.0 41,771 1

Seq Scan on november_three five_five (cost=0.000..914.380 rows=42,138 width=16) (actual time=0.078..2.919 rows=41,771 loops=1)

147. 0.002 0.032 ↑ 1.0 1 1

Hash (cost=5.550..5.550 rows=1 width=11) (actual time=0.032..0.032 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
148. 0.030 0.030 ↑ 1.0 1 1

Seq Scan on xray_hotel kilo_quebec (cost=0.000..5.550 rows=1 width=11) (actual time=0.009..0.030 rows=1 loops=1)

  • Filter: (quebec_seven = ANY ('golf_delta'::integer[]))
  • Rows Removed by Filter: 252
149. 0.106 0.180 ↑ 1.0 591 1

Hash (cost=12.930..12.930 rows=593 width=20) (actual time=0.180..0.180 rows=591 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
150. 0.074 0.074 ↑ 1.0 591 1

Seq Scan on hotel_foxtrot golf_november (cost=0.000..12.930 rows=593 width=20) (actual time=0.004..0.074 rows=591 loops=1)

151. 0.091 0.174 ↑ 1.0 591 1

Hash (cost=12.930..12.930 rows=593 width=20) (actual time=0.174..0.174 rows=591 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
152. 0.083 0.083 ↑ 1.0 591 1

Seq Scan on hotel_foxtrot kilo_three (cost=0.000..12.930 rows=593 width=20) (actual time=0.002..0.083 rows=591 loops=1)

153. 0.006 0.010 ↑ 1.0 2 1

Hash (cost=1.020..1.020 rows=2 width=14) (actual time=0.010..0.010 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
154. 0.004 0.004 ↑ 1.0 2 1

Seq Scan on hotel_sierra charlie_quebec (cost=0.000..1.020 rows=2 width=14) (actual time=0.004..0.004 rows=2 loops=1)

155. 0.043 0.076 ↓ 1.1 253 1

Hash (cost=5.270..5.270 rows=227 width=11) (actual time=0.076..0.076 rows=253 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
156. 0.033 0.033 ↓ 1.1 253 1

Seq Scan on xray_hotel sierra_kilo (cost=0.000..5.270 rows=227 width=11) (actual time=0.004..0.033 rows=253 loops=1)

157. 0.008 0.016 ↓ 1.1 48 1

Hash (cost=1.450..1.450 rows=45 width=4) (actual time=0.016..0.016 rows=48 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
158. 0.008 0.008 ↓ 1.1 48 1

Seq Scan on papa_alpha alpha_bravo (cost=0.000..1.450 rows=45 width=4) (actual time=0.004..0.008 rows=48 loops=1)

159.          

SubPlan (forHash Left Join)

160. 3.974 15.896 ↑ 1.0 1 1,987

Aggregate (cost=1.250..1.260 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=1,987)

161. 11.922 11.922 ↑ 14.3 7 1,987

Function Scan on seven_oscar (cost=0.000..1.000 rows=100 width=32) (actual time=0.005..0.006 rows=7 loops=1,987)

162. 1.690 1.690 ↑ 1.0 1 1,690

Aggregate (cost=1.250..1.260 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,690)

163. 0.000 0.000 ↓ 0.0 0 1,690

Function Scan on seven_oscar foxtrot_papa (cost=0.000..1.000 rows=100 width=32) (actual time=0.000..0.000 rows=0 loops=1,690)