explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wRXO : plan 12b1

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 292,623.314 ↑ 303.0 33 1

Limit (cost=796,538.890..796,563.890 rows=10,000 width=688) (actual time=292,623.311..292,623.314 rows=33 loops=1)

2. 0.145 292,623.310 ↑ 7,437.2 33 1

Sort (cost=796,538.890..797,152.460 rows=245,429 width=688) (actual time=292,623.309..292,623.310 rows=33 loops=1)

  • Sort Key: (CASE WHEN (mike_mike delta_four 1) THEN 0 ELSE 1 END), (lima_sierra(uniform_delta.quebec_quebec, 'echo_whiskey'::numeric)) DESC, (lima_sierra(uniform_delta.bravo, 'seven_juliet'::date)) DESC
  • Sort Method: quicksort Memory: 37kB
3. 0.045 292,623.165 ↑ 7,437.2 33 1

Subquery Scan on uniform_delta (cost=773,483.640..779,005.800 rows=245,429 width=688) (actual time=292,621.328..292,623.165 rows=33 loops=1)

4. 2.755 292,089.657 ↑ 7,437.2 33 1

HashAggregate (cost=721,338.560..723,792.850 rows=245,429 width=652) (actual time=292,087.836..292,089.657 rows=33 loops=1)

  • Group Key: lima_papa.two_romeo, foxtrot_foxtrot.two_romeo
5. 0.705 292,086.902 ↑ 341.3 719 1

Hash Left Join (cost=674,015.700..702,931.390 rows=245,429 width=658) (actual time=292,022.767..292,086.902 rows=719 loops=1)

  • Hash Cond: (lima_papa.two_romeo = foxtrot_kilo.two_romeo)
6. 8.650 5,499.905 ↑ 95.2 719 1

Hash Right Join (cost=367,530.670..396,266.610 rows=68,467 width=510) (actual time=5,435.957..5,499.905 rows=719 loops=1)

  • Hash Cond: (mike_whiskey.two_romeo = foxtrot_foxtrot.two_romeo)
7. 58.423 58.423 ↓ 1.0 85,823 1

Index Only Scan using two_three on lima_kilo mike_whiskey (cost=0.420..27,815.410 rows=85,813 width=4) (actual time=0.065..58.423 rows=85,823 loops=1)

  • Index Cond: (xray = 'juliet_quebec'::text)
  • Heap Fetches: 1008
8. 0.253 5,432.832 ↑ 287.7 238 1

Hash (cost=366,674.410..366,674.410 rows=68,467 width=510) (actual time=5,432.832..5,432.832 rows=238 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 1094kB
9. 35.224 5,432.579 ↑ 287.7 238 1

Hash Join (cost=283,334.890..366,674.410 rows=68,467 width=510) (actual time=3,193.202..5,432.579 rows=238 loops=1)

  • Hash Cond: (foxtrot_foxtrot.two_romeo = echo_lima.two_romeo)
10. 126.418 4,279.833 ↓ 1.2 474,804 1

Hash Left Join (cost=215,881.010..297,388.570 rows=407,722 width=514) (actual time=1,892.911..4,279.833 rows=474,804 loops=1)

  • Hash Cond: (lima_papa.two_romeo = kilo_charlie_four.two_romeo)
11. 120.907 3,907.469 ↓ 4.2 474,804 1

Hash Left Join (cost=160,705.700..241,914.640 rows=113,742 width=450) (actual time=1,646.524..3,907.469 rows=474,804 loops=1)

  • Hash Cond: (lima_kilo.two_romeo = hotel_foxtrot.two_romeo)
12. 95.368 3,668.151 ↓ 10.0 474,804 1

Hash Left Join (cost=126,138.140..207,222.400 rows=47,487 width=418) (actual time=1,527.675..3,668.151 rows=474,804 loops=1)

  • Hash Cond: (lima_kilo.two_romeo = golf_november_foxtrot.two_romeo)
13. 217.539 3,533.979 ↓ 10.0 474,804 1

Nested Loop (cost=118,184.800..199,144.390 rows=47,487 width=386) (actual time=1,488.796..3,533.979 rows=474,804 loops=1)

14. 330.325 1,892.028 ↓ 10.0 474,804 1

Hash Right Join (cost=118,184.380..135,506.130 rows=47,487 width=61) (actual time=1,488.742..1,892.028 rows=474,804 loops=1)

  • Hash Cond: (quebec_whiskey.whiskey_echo_hotel = lima_kilo.whiskey_echo_hotel)
15. 85.072 85.072 ↑ 1.0 744,210 1

Seq Scan on quebec_whiskey (cost=0.000..14,056.100 rows=744,210 width=8) (actual time=11.846..85.072 rows=744,210 loops=1)

16. 122.685 1,476.631 ↓ 10.0 474,804 1

Hash (cost=117,590.790..117,590.790 rows=47,487 width=57) (actual time=1,476.631..1,476.631 rows=474,804 loops=1)

  • Buckets: 524288 (originally 65536) Batches: 1 (originally 1) Memory Usage: 43829kB
17. 112.401 1,353.946 ↓ 10.0 474,804 1

Hash Join (cost=20,932.700..117,590.790 rows=47,487 width=57) (actual time=219.894..1,353.946 rows=474,804 loops=1)

  • Hash Cond: (lima_kilo.two_romeo = foxtrot_foxtrot.two_romeo)
18. 82.728 1,177.484 ↓ 9.8 477,657 1

Hash Join (cost=14,239.870..110,770.440 rows=48,578 width=14) (actual time=155.376..1,177.484 rows=477,657 loops=1)

  • Hash Cond: ((lima_kilo.xray)::text = (three_hotel.xray)::text)
19. 944.391 1,036.565 ↓ 1.3 477,657 1

Bitmap Heap Scan on lima_kilo (cost=14,155.890..108,304.420 rows=379,252 width=17) (actual time=97.160..1,036.565 rows=477,657 loops=1)

  • Recheck Cond: (((six_tango)::text = 'juliet_bravo'::text) AND (papa_five_yankee five_romeo NULL) AND ((six_lima_oscar)::text = 'juliet_bravo'::text))
  • Filter: ((NOT three_lima) AND ((xray)::text = ANY ('seven_three'::text[])))
  • Rows Removed by Filter: 17372
  • Heap Blocks: exact=34344
20. 92.174 92.174 ↓ 1.3 495,182 1

Bitmap Index Scan on uniform_xray (cost=0.000..14,061.080 rows=391,092 width=0) (actual time=92.174..92.174 rows=495,182 loops=1)

  • Index Cond: (((six_tango)::text = 'juliet_bravo'::text) AND (papa_five_yankee five_romeo NULL) AND ((six_lima_oscar)::text = 'juliet_bravo'::text))
21. 0.170 58.191 ↓ 8.3 141 1

Hash (cost=83.770..83.770 rows=17 width=3) (actual time=58.190..58.191 rows=141 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
22. 58.021 58.021 ↓ 8.3 141 1

Seq Scan on three_hotel (cost=0.000..83.770 rows=17 width=3) (actual time=29.537..58.021 rows=141 loops=1)

  • Filter: ((seven_six_delta.zulu_golf() >= juliet_alpha) AND (seven_six_delta.zulu_golf() <= hotel_delta))
  • Rows Removed by Filter: 10
23. 17.245 64.061 ↑ 1.0 95,712 1

Hash (cost=5,494.610..5,494.610 rows=95,858 width=43) (actual time=64.061..64.061 rows=95,712 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8010kB
24. 46.816 46.816 ↑ 1.0 95,712 1

Seq Scan on foxtrot_foxtrot (cost=0.000..5,494.610 rows=95,858 width=43) (actual time=0.020..46.816 rows=95,712 loops=1)

  • Filter: (NOT three_lima)
  • Rows Removed by Filter: 2349
25. 1,424.412 1,424.412 ↑ 1.0 1 474,804

Index Scan using hotel_papa on lima_papa (cost=0.420..1.340 rows=1 width=333) (actual time=0.003..0.003 rows=1 loops=474,804)

  • Index Cond: (whiskey_echo_hotel = lima_kilo.whiskey_echo_hotel)
26. 1.480 38.804 ↑ 1.2 10,429 1

Hash (cost=7,800.300..7,800.300 rows=12,243 width=36) (actual time=38.804..38.804 rows=10,429 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 622kB
27. 0.675 37.324 ↑ 1.2 10,429 1

Subquery Scan on golf_november_foxtrot (cost=7,555.440..7,800.300 rows=12,243 width=36) (actual time=35.100..37.324 rows=10,429 loops=1)

28. 12.593 36.649 ↑ 1.2 10,429 1

HashAggregate (cost=7,555.440..7,677.870 rows=12,243 width=36) (actual time=35.098..36.649 rows=10,429 loops=1)

  • Group Key: foxtrot_juliet.two_romeo
29. 7.507 24.056 ↑ 1.0 15,628 1

Sort (cost=3,330.010..3,369.880 rows=15,945 width=150) (actual time=23.257..24.056 rows=15,628 loops=1)

  • Sort Key: (CASE WHEN (quebec_sierra.seven_six_hotel five_romeo NOT NULL) THEN quebec_sierra.seven_six_hotel ELSE quebec_sierra.zulu_mike END)
  • Sort Method: quicksort Memory: 1135kB
30. 2.895 16.549 ↑ 1.0 15,628 1

Hash Join (cost=10.010..2,216.990 rows=15,945 width=150) (actual time=0.139..16.549 rows=15,628 loops=1)

  • Hash Cond: ((foxtrot_juliet.xray)::text = (quebec_sierra.xray)::text)
31. 13.542 13.542 ↑ 1.0 15,628 1

Seq Scan on six_five foxtrot_juliet (cost=0.000..2,164.120 rows=15,945 width=7) (actual time=0.015..13.542 rows=15,628 loops=1)

  • Filter: ((quebec_alpha)::text = 'delta_oscar'::text)
  • Rows Removed by Filter: 86782
32. 0.034 0.112 ↑ 1.0 178 1

Hash (cost=7.780..7.780 rows=178 width=19) (actual time=0.112..0.112 rows=178 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
33. 0.078 0.078 ↑ 1.0 178 1

Seq Scan on four_lima quebec_sierra (cost=0.000..7.780 rows=178 width=19) (actual time=0.006..0.078 rows=178 loops=1)

34. 11.760 118.411 ↓ 1.3 86,114 1

Hash (cost=33,737.650..33,737.650 rows=66,393 width=36) (actual time=118.411..118.411 rows=86,114 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4706kB
35. 5.381 106.651 ↓ 1.3 86,114 1

Subquery Scan on hotel_foxtrot (cost=32,409.790..33,737.650 rows=66,393 width=36) (actual time=89.053..106.651 rows=86,114 loops=1)

36. 37.064 101.270 ↓ 1.3 86,114 1

HashAggregate (cost=32,409.790..33,073.720 rows=66,393 width=36) (actual time=89.051..101.270 rows=86,114 loops=1)

  • Group Key: oscar_alpha1.two_romeo
37. 37.891 64.206 ↓ 1.0 86,782 1

Sort (cost=9,496.560..9,712.730 rows=86,465 width=150) (actual time=59.814..64.206 rows=86,782 loops=1)

  • Sort Key: (CASE WHEN (golf_juliet1.seven_six_hotel five_romeo NOT NULL) THEN golf_juliet1.seven_six_hotel ELSE golf_juliet1.zulu_mike END)
  • Sort Method: quicksort Memory: 7210kB
38. 15.523 26.315 ↓ 1.0 86,782 1

Hash Join (cost=10.010..2,406.510 rows=86,465 width=150) (actual time=0.109..26.315 rows=86,782 loops=1)

  • Hash Cond: ((oscar_alpha1.xray)::text = (golf_juliet1.xray)::text)
39. 10.706 10.706 ↓ 1.0 86,782 1

Seq Scan on six_five romeo_romeo (cost=0.000..2,164.120 rows=86,465 width=7) (actual time=0.008..10.706 rows=86,782 loops=1)

  • Filter: ((quebec_alpha)::text = 'uniform_five'::text)
  • Rows Removed by Filter: 15628
40. 0.033 0.086 ↑ 1.0 178 1

Hash (cost=7.780..7.780 rows=178 width=19) (actual time=0.086..0.086 rows=178 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
41. 0.053 0.053 ↑ 1.0 178 1

Seq Scan on four_lima zulu_zulu (cost=0.000..7.780 rows=178 width=19) (actual time=0.003..0.053 rows=178 loops=1)

42. 15.402 245.946 ↑ 1.0 98,061 1

Hash (cost=53,949.550..53,949.550 rows=98,061 width=68) (actual time=245.945..245.946 rows=98,061 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5573kB
43. 6.346 230.544 ↑ 1.0 98,061 1

Subquery Scan on kilo_charlie_four (cost=51,988.330..53,949.550 rows=98,061 width=68) (actual time=206.730..230.544 rows=98,061 loops=1)

44. 55.764 224.198 ↑ 1.0 98,061 1

HashAggregate (cost=51,988.330..52,968.940 rows=98,061 width=68) (actual time=206.727..224.198 rows=98,061 loops=1)

  • Group Key: romeo_three.two_romeo
45. 16.814 168.434 ↓ 1.1 104,589 1

Hash Left Join (cost=25,061.480..26,982.780 rows=98,061 width=26) (actual time=131.766..168.434 rows=104,589 loops=1)

  • Hash Cond: ((romeo_three.whiskey_echo_tango)::text = (golf_juliet2.tango)::text)
46. 18.201 151.602 ↓ 1.1 104,589 1

Hash Right Join (cost=25,059.580..26,698.710 rows=98,061 width=19) (actual time=131.736..151.602 rows=104,589 loops=1)

  • Hash Cond: (six_lima_november1.two_romeo = romeo_three.two_romeo)
47. 12.549 90.589 ↑ 3.3 32,574 1

Sort (cost=18,339.200..18,610.130 rows=108,372 width=15) (actual time=88.488..90.589 rows=32,574 loops=1)

  • Sort Key: six_lima_november1.two_romeo, golf_juliet3.zulu_mike
  • Sort Method: quicksort Memory: 2377kB
48. 5.295 78.040 ↑ 3.3 32,574 1

Hash Join (cost=6,722.270..9,276.250 rows=108,372 width=15) (actual time=34.384..78.040 rows=32,574 loops=1)

  • Hash Cond: ((two_yankee.tango)::text = (golf_juliet3.tango)::text)
49. 27.565 72.721 ↑ 3.3 32,574 1

Hash Join (cost=6,720.370..8,959.740 rows=108,372 width=8) (actual time=34.350..72.721 rows=32,574 loops=1)

  • Hash Cond: (two_yankee.two_romeo = six_lima_november1.two_romeo)
  • Join Filter: ((two_yankee.tango)::text <> (six_lima_november1.whiskey_echo_tango)::text)
  • Rows Removed by Join Filter: 96246
50. 11.271 11.271 ↑ 1.0 128,820 1

Seq Scan on papa_four two_yankee (cost=0.000..1,901.200 rows=128,820 width=8) (actual time=0.025..11.271 rows=128,820 loops=1)

51. 12.402 33.885 ↑ 1.0 98,061 1

Hash (cost=5,494.610..5,494.610 rows=98,061 width=8) (actual time=33.885..33.885 rows=98,061 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4827kB
52. 21.483 21.483 ↑ 1.0 98,061 1

Seq Scan on foxtrot_foxtrot victor_echo (cost=0.000..5,494.610 rows=98,061 width=8) (actual time=0.003..21.483 rows=98,061 loops=1)

53. 0.011 0.024 ↑ 1.0 40 1

Hash (cost=1.400..1.400 rows=40 width=15) (actual time=0.024..0.024 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
54. 0.013 0.013 ↑ 1.0 40 1

Seq Scan on five_xray four_yankee (cost=0.000..1.400 rows=40 width=15) (actual time=0.007..0.013 rows=40 loops=1)

55. 12.537 42.812 ↑ 1.0 98,061 1

Hash (cost=5,494.610..5,494.610 rows=98,061 width=8) (actual time=42.812..42.812 rows=98,061 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4827kB
56. 30.275 30.275 ↑ 1.0 98,061 1

Seq Scan on foxtrot_foxtrot romeo_three (cost=0.000..5,494.610 rows=98,061 width=8) (actual time=0.008..30.275 rows=98,061 loops=1)

57. 0.009 0.018 ↑ 1.0 40 1

Hash (cost=1.400..1.400 rows=40 width=15) (actual time=0.018..0.018 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
58. 0.009 0.009 ↑ 1.0 40 1

Seq Scan on five_xray romeo_two (cost=0.000..1.400 rows=40 width=15) (actual time=0.004..0.009 rows=40 loops=1)

59. 0.033 1,117.522 ↑ 395.0 33 1

Hash (cost=67,290.930..67,290.930 rows=13,036 width=4) (actual time=1,117.522..1,117.522 rows=33 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 130kB
60. 0.169 1,117.489 ↑ 395.0 33 1

HashAggregate (cost=67,160.570..67,290.930 rows=13,036 width=4) (actual time=1,117.392..1,117.489 rows=33 loops=1)

  • Group Key: echo_lima.two_romeo
61. 1,117.320 1,117.320 ↑ 143.2 115 1

Seq Scan on echo_lima (cost=0.000..67,119.400 rows=16,467 width=4) (actual time=12.536..1,117.320 rows=115 loops=1)

  • Filter: ((((alpha)::text = 'foxtrot_four'::text) OR ((alpha)::text ~~ 'sierra_alpha'::text)) AND ((yankee_uniform((hotel_sierra)::text) ~~ 'india_sierra'::text) OR (yankee_uniform((hotel_sierra)::text) ~~ 'charlie'::text)))
  • Rows Removed by Filter: 2038621
62. 26.519 286,586.292 ↑ 1.0 97,296 1

Hash (cost=305,259.260..305,259.260 rows=98,061 width=152) (actual time=286,586.292..286,586.292 rows=97,296 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8252kB
63. 12.413 286,559.773 ↑ 1.0 97,296 1

Subquery Scan on foxtrot_kilo (cost=216,952.470..305,259.260 rows=98,061 width=152) (actual time=285,019.723..286,559.773 rows=97,296 loops=1)

64. 1,489.380 286,547.360 ↑ 1.0 97,296 1

GroupAggregate (cost=216,952.470..304,278.650 rows=98,061 width=152) (actual time=285,019.719..286,547.360 rows=97,296 loops=1)

  • Group Key: six_lima_november2.two_romeo
65. 295.971 285,057.980 ↓ 3.1 467,123 1

Sort (cost=216,952.470..217,335.280 rows=153,121 width=67) (actual time=285,019.473..285,057.980 rows=467,123 loops=1)

  • Sort Key: six_lima_november2.two_romeo
  • Sort Method: quicksort Memory: 73135kB
66. 225.425 284,762.009 ↓ 3.1 467,123 1

Hash Left Join (cost=200,711.270..203,765.450 rows=153,121 width=67) (actual time=1,486.045..284,762.009 rows=467,123 loops=1)

  • Hash Cond: ((whiskey_uniform1.xray)::text = (hotel_golf.xray)::text)
67. 282,759.432 284,536.440 ↓ 3.1 467,123 1

Hash Left Join (cost=200,673.150..203,301.940 rows=153,121 width=64) (actual time=1,485.883..284,536.440 rows=467,123 loops=1)

  • Hash Cond: (lima_sierra(six_lima_november2.victor_romeo, 1) = foxtrot_hotel.victor_romeo)
  • Join Filter: (whiskey_uniform1.six_sierra = foxtrot_hotel.uniform_juliet)
  • Rows Removed by Join Filter: 4549925366
68. 203.582 1,417.044 ↓ 3.1 467,123 1

Merge Left Join (cost=156,992.110..159,218.960 rows=153,121 width=62) (actual time=1,120.184..1,417.044 rows=467,123 loops=1)

  • Merge Cond: (whiskey_uniform1.six_sierra = kilo_november.uniform_juliet)
69. 236.055 1,204.554 ↓ 3.1 467,123 1

Sort (cost=142,792.850..143,175.650 rows=153,121 width=52) (actual time=1,113.255..1,204.554 rows=467,123 loops=1)

  • Sort Key: whiskey_uniform1.six_sierra
  • Sort Method: quicksort Memory: 71327kB
70. 93.679 968.499 ↓ 3.1 467,123 1

Hash Join (cost=127,102.860..129,605.830 rows=153,121 width=52) (actual time=727.069..968.499 rows=467,123 loops=1)

  • Hash Cond: (whiskey_uniform1.two_romeo = six_lima_november2.two_romeo)
71. 93.017 827.962 ↓ 3.1 467,123 1

Merge Left Join (cost=120,382.480..122,483.490 rows=153,121 width=44) (actual time=679.747..827.962 rows=467,123 loops=1)

  • Merge Cond: (whiskey_uniform1.seven_six_romeo = four_bravo.uniform_juliet)
72. 177.842 724.897 ↓ 3.1 467,123 1

Sort (cost=106,183.220..106,566.020 rows=153,121 width=34) (actual time=670.748..724.897 rows=467,123 loops=1)

  • Sort Key: whiskey_uniform1.seven_six_romeo
  • Sort Method: quicksort Memory: 52687kB
73. 148.886 547.055 ↓ 3.1 467,123 1

Hash Join (cost=9.530..92,996.200 rows=153,121 width=34) (actual time=0.127..547.055 rows=467,123 loops=1)

  • Hash Cond: ((whiskey_uniform1.xray)::text = (golf_juliet4.xray)::text)
74. 398.071 398.071 ↓ 1.3 494,865 1

Seq Scan on lima_papa six_charlie (cost=0.000..91,925.090 rows=395,007 width=34) (actual time=0.009..398.071 rows=494,865 loops=1)

  • Filter: ((papa_five_yankee five_romeo NULL) AND ((six_tango)::text = 'juliet_bravo'::text) AND ((six_lima_oscar)::text = 'juliet_bravo'::text))
  • Rows Removed by Filter: 248883
75. 0.030 0.098 ↓ 1.6 107 1

Hash (cost=8.670..8.670 rows=69 width=3) (actual time=0.098..0.098 rows=107 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
76. 0.068 0.068 ↓ 1.6 107 1

Seq Scan on four_lima lima_tango (cost=0.000..8.670 rows=69 width=3) (actual time=0.025..0.068 rows=107 loops=1)

  • Filter: (((yankee_whiskey)::text = 'uniform_five'::text) AND ((kilo_charlie_papa)::text = 'uniform_five'::text))
  • Rows Removed by Filter: 71
77. 4.153 10.048 ↓ 1.0 17,385 1

Sort (cost=14,199.260..14,240.950 rows=16,675 width=18) (actual time=8.980..10.048 rows=17,385 loops=1)

  • Sort Key: four_bravo.uniform_juliet
  • Sort Method: quicksort Memory: 1583kB
78. 4.749 5.895 ↓ 1.0 17,385 1

Bitmap Heap Scan on golf_yankee four_bravo (cost=617.660..13,029.900 rows=16,675 width=18) (actual time=1.268..5.895 rows=17,385 loops=1)

  • Recheck Cond: (victor_romeo = 1)
  • Heap Blocks: exact=1357
79. 1.146 1.146 ↓ 1.0 17,385 1

Bitmap Index Scan on sierra_delta (cost=0.000..613.490 rows=16,675 width=0) (actual time=1.146..1.146 rows=17,385 loops=1)

  • Index Cond: (victor_romeo = 1)
80. 14.058 46.858 ↑ 1.0 98,061 1

Hash (cost=5,494.610..5,494.610 rows=98,061 width=12) (actual time=46.858..46.858 rows=98,061 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4823kB
81. 32.800 32.800 ↑ 1.0 98,061 1

Seq Scan on foxtrot_foxtrot quebec_bravo (cost=0.000..5,494.610 rows=98,061 width=12) (actual time=0.009..32.800 rows=98,061 loops=1)

82. 4.928 8.908 ↓ 1.0 17,385 1

Sort (cost=14,199.260..14,240.950 rows=16,675 width=18) (actual time=6.916..8.908 rows=17,385 loops=1)

  • Sort Key: kilo_november.uniform_juliet
  • Sort Method: quicksort Memory: 1583kB
83. 3.116 3.980 ↓ 1.0 17,385 1

Bitmap Heap Scan on golf_yankee kilo_november (cost=617.660..13,029.900 rows=16,675 width=18) (actual time=0.983..3.980 rows=17,385 loops=1)

  • Recheck Cond: (victor_romeo = 1)
  • Heap Blocks: exact=1357
84. 0.864 0.864 ↓ 1.0 17,385 1

Bitmap Index Scan on sierra_delta (cost=0.000..613.490 rows=16,675 width=0) (actual time=0.864..0.864 rows=17,385 loops=1)

  • Index Cond: (victor_romeo = 1)
85. 187.150 359.964 ↑ 1.0 1,425,246 1

Hash (cost=25,865.460..25,865.460 rows=1,425,246 width=22) (actual time=359.964..359.964 rows=1,425,246 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 98328kB
86. 172.814 172.814 ↑ 1.0 1,425,246 1

Seq Scan on golf_yankee foxtrot_hotel (cost=0.000..25,865.460 rows=1,425,246 width=22) (actual time=0.010..172.814 rows=1,425,246 loops=1)

87. 0.019 0.144 ↓ 12.2 110 1

Hash (cost=38.000..38.000 rows=9 width=3) (actual time=0.144..0.144 rows=110 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
88. 0.076 0.125 ↓ 12.2 110 1

Bitmap Heap Scan on hotel_golf (cost=4.360..38.000 rows=9 width=3) (actual time=0.065..0.125 rows=110 loops=1)

  • Recheck Cond: (papa_five_charlie = 11279)
  • Filter: yankee_alpha
  • Heap Blocks: exact=8
89. 0.049 0.049 ↓ 11.0 110 1

Bitmap Index Scan on india_whiskey (cost=0.000..4.360 rows=10 width=0) (actual time=0.049..0.049 rows=110 loops=1)

  • Index Cond: (papa_five_charlie = 11279)
90.          

SubPlan (forSubquery Scan)

91. 0.014 533.463 ↑ 94.0 1 1

HashAggregate (cost=52,143.910..52,144.850 rows=94 width=4) (actual time=533.462..533.463 rows=1 loops=1)

  • Group Key: lima_mike1.two_romeo
92. 0.002 533.449 ↑ 47.0 2 1

Append (cost=0.000..52,143.670 rows=94 width=4) (actual time=27.707..533.449 rows=2 loops=1)

93. 107.240 107.240 ↑ 20.0 1 1

Seq Scan on foxtrot_foxtrot five_oscar (cost=0.000..6,475.220 rows=20 width=4) (actual time=27.706..107.240 rows=1 loops=1)

  • Filter: ((yankee_uniform((november)::text) ~~ 'golf_november_charlie'::text) OR (yankee_uniform((victor_four)::text) ~~ 'golf_november_charlie'::text))
  • Rows Removed by Filter: 98060
94. 0.006 426.207 ↑ 74.0 1 1

Unique (cost=45,666.670..45,667.040 rows=74 width=4) (actual time=426.204..426.207 rows=1 loops=1)

95. 0.016 426.201 ↑ 5.7 13 1

Sort (cost=45,666.670..45,666.860 rows=74 width=4) (actual time=426.200..426.201 rows=13 loops=1)

  • Sort Key: victor_oscar1.two_romeo
  • Sort Method: quicksort Memory: 25kB
96. 426.185 426.185 ↑ 5.7 13 1

Seq Scan on lima_kilo sierra_charlie (cost=0.000..45,664.380 rows=74 width=4) (actual time=374.480..426.185 rows=13 loops=1)

  • Filter: (yankee_uniform((oscar_three)::text) ~~ 'golf_november_charlie'::text)
  • Rows Removed by Filter: 744202