explain.depesz.com

PostgreSQL's explain analyze made readable

Result: njtH : plan 9.4

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 11,860.645 ↑ 303.0 33 1

Limit (cost=961,183.520..961,208.520 rows=10,000 width=648) (actual time=11,860.641..11,860.645 rows=33 loops=1)

2. 0.146 11,860.641 ↑ 7,041.6 33 1

Sort (cost=961,183.520..961,764.450 rows=232,372 width=648) (actual time=11,860.639..11,860.641 rows=33 loops=1)

  • Sort Key: (CASE WHEN (mike_mike delta_four 1) THEN 0 ELSE 1 END), (lima_sierra(uniform_delta.quebec_quebec, (-1)::numeric)), (lima_sierra(uniform_delta.bravo, 'seven_juliet'::date))
  • Sort Method: quicksort Memory: 37kB
3. 0.036 11,860.495 ↑ 7,041.6 33 1

Subquery Scan on uniform_delta (cost=939,354.830..944,583.200 rows=232,372 width=648) (actual time=11,859.950..11,860.495 rows=33 loops=1)

4. 10.552 11,371.724 ↑ 7,041.6 33 1

HashAggregate (cost=886,257.330..888,581.050 rows=232,372 width=656) (actual time=11,371.193..11,371.724 rows=33 loops=1)

  • Group Key: lima_papa.two_romeo, foxtrot_foxtrot.two_romeo
5.          

CTE foxtrot_kilo

6. 1,831.411 4,198.487 ↑ 1.0 97,016 1

GroupAggregate (cost=315,041.090..412,417.300 rows=97,781 width=67) (actual time=2,332.624..4,198.487 rows=97,016 loops=1)

  • Group Key: six_lima_november2.two_romeo
7. 176.709 2,367.076 ↓ 2.7 465,548 1

Sort (cost=315,041.090..315,468.990 rows=171,158 width=67) (actual time=2,332.410..2,367.076 rows=465,548 loops=1)

  • Sort Key: six_lima_november2.two_romeo
  • Sort Method: quicksort Memory: 72941kB
8. 102.194 2,190.367 ↓ 2.7 465,548 1

Merge Right Join (cost=186,297.390..300,163.210 rows=171,158 width=67) (actual time=2,049.643..2,190.367 rows=465,548 loops=1)

  • Merge Cond: ((foxtrot_hotel.victor_romeo = (lima_sierra(six_lima_november2.victor_romeo, 1))) AND (foxtrot_hotel.uniform_juliet = whiskey_uniform1.six_sierra))
9. 4.051 4.051 ↑ 82.0 17,373 1

Index Scan using sierra_delta on golf_yankee foxtrot_hotel (cost=0.430..104,801.160 rows=1,423,998 width=22) (actual time=0.036..4.051 rows=17,373 loops=1)

10. 551.138 2,084.122 ↓ 2.7 465,548 1

Sort (cost=186,296.970..186,724.860 rows=171,158 width=65) (actual time=2,049.599..2,084.122 rows=465,548 loops=1)

  • Sort Key: (lima_sierra(six_lima_november2.victor_romeo, 1)), whiskey_uniform1.six_sierra
  • Sort Method: quicksort Memory: 76111kB
11. 174.723 1,532.984 ↓ 2.7 465,548 1

Hash Join (cost=162,208.020..171,419.080 rows=171,158 width=65) (actual time=1,202.370..1,532.984 rows=465,548 loops=1)

  • Hash Cond: (whiskey_uniform1.two_romeo = six_lima_november2.two_romeo)
12. 155.906 1,315.692 ↓ 2.7 465,548 1

Hash Right Join (cost=155,458.950..161,246.850 rows=171,158 width=57) (actual time=1,159.736..1,315.692 rows=465,548 loops=1)

  • Hash Cond: ((hotel_golf.xray)::text = (whiskey_uniform1.xray)::text)
13. 0.132 0.181 ↓ 1.1 110 1

Bitmap Heap Scan on hotel_golf (cost=5.140..190.340 rows=96 width=3) (actual time=0.065..0.181 rows=110 loops=1)

  • Recheck Cond: (papa_five_charlie = 11279)
  • Filter: yankee_alpha
  • Heap Blocks: exact=8
14. 0.049 0.049 ↑ 1.0 110 1

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

  • Index Cond: (papa_five_charlie = 11279)
15. 100.783 1,159.605 ↓ 3.1 465,548 1

Hash (cost=153,566.880..153,566.880 rows=150,954 width=54) (actual time=1,159.605..1,159.605 rows=465,548 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 38572kB
16. 124.356 1,058.822 ↓ 3.1 465,548 1

Merge Left Join (cost=150,607.140..153,566.880 rows=150,954 width=54) (actual time=880.011..1,058.822 rows=465,548 loops=1)

  • Merge Cond: (whiskey_uniform1.six_sierra = kilo_november.uniform_juliet)
17. 157.977 911.235 ↓ 3.1 465,548 1

Sort (cost=136,313.600..136,690.980 rows=150,954 width=44) (actual time=872.726..911.235 rows=465,548 loops=1)

  • Sort Key: whiskey_uniform1.six_sierra
  • Sort Method: quicksort Memory: 63892kB
18. 85.116 753.258 ↓ 3.1 465,548 1

Merge Right Join (cost=121,150.200..123,328.720 rows=150,954 width=44) (actual time=621.604..753.258 rows=465,548 loops=1)

  • Merge Cond: (four_bravo.uniform_juliet = whiskey_uniform1.seven_six_romeo)
19. 4.523 10.338 ↑ 1.0 17,372 1

Sort (cost=14,293.540..14,338.400 rows=17,942 width=18) (actual time=9.277..10.338 rows=17,372 loops=1)

  • Sort Key: four_bravo.uniform_juliet
  • Sort Method: quicksort Memory: 1583kB
20. 4.221 5.815 ↑ 1.0 17,372 1

Bitmap Heap Scan on golf_yankee four_bravo (cost=663.480..13,025.850 rows=17,942 width=18) (actual time=1.723..5.815 rows=17,372 loops=1)

  • Recheck Cond: (victor_romeo = 1)
  • Heap Blocks: exact=1347
21. 1.594 1.594 ↑ 1.0 17,372 1

Bitmap Index Scan on sierra_delta (cost=0.000..658.990 rows=17,942 width=0) (actual time=1.594..1.594 rows=17,372 loops=1)

  • Index Cond: (victor_romeo = 1)
22. 164.271 657.804 ↓ 3.1 465,548 1

Sort (cost=106,856.660..107,234.040 rows=150,954 width=34) (actual time=612.322..657.804 rows=465,548 loops=1)

  • Sort Key: whiskey_uniform1.seven_six_romeo
  • Sort Method: quicksort Memory: 52555kB
23. 142.369 493.533 ↓ 3.1 465,548 1

Hash Join (cost=9.530..93,871.790 rows=150,954 width=34) (actual time=0.086..493.533 rows=465,548 loops=1)

  • Hash Cond: ((whiskey_uniform1.xray)::text = (golf_juliet4.xray)::text)
24. 351.098 351.098 ↓ 1.3 493,181 1

Seq Scan on lima_papa six_charlie (cost=0.000..90,892.400 rows=389,418 width=34) (actual time=0.010..351.098 rows=493,181 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: 247547
25. 0.007 0.066 ↓ 1.6 107 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
26. 0.059 0.059 ↓ 1.6 107 1

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

  • Filter: (((yankee_whiskey)::text = 'uniform_five'::text) AND ((kilo_charlie)::text = 'uniform_five'::text))
  • Rows Removed by Filter: 71
27. 19.213 23.231 ↓ 25.1 451,213 1

Sort (cost=14,293.540..14,338.400 rows=17,942 width=18) (actual time=7.274..23.231 rows=451,213 loops=1)

  • Sort Key: kilo_november.uniform_juliet
  • Sort Method: quicksort Memory: 1583kB
28. 2.958 4.018 ↑ 1.0 17,372 1

Bitmap Heap Scan on golf_yankee kilo_november (cost=663.480..13,025.850 rows=17,942 width=18) (actual time=1.184..4.018 rows=17,372 loops=1)

  • Recheck Cond: (victor_romeo = 1)
  • Heap Blocks: exact=1347
29. 1.060 1.060 ↑ 1.0 17,372 1

Bitmap Index Scan on sierra_delta (cost=0.000..658.990 rows=17,942 width=0) (actual time=1.060..1.060 rows=17,372 loops=1)

  • Index Cond: (victor_romeo = 1)
30. 14.023 42.569 ↑ 1.0 97,781 1

Hash (cost=5,526.810..5,526.810 rows=97,781 width=12) (actual time=42.569..42.569 rows=97,781 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 3789kB
31. 28.546 28.546 ↑ 1.0 97,781 1

Seq Scan on foxtrot_foxtrot quebec_bravo (cost=0.000..5,526.810 rows=97,781 width=12) (actual time=0.006..28.546 rows=97,781 loops=1)

32. 7.484 11,361.172 ↑ 323.2 719 1

Hash Right Join (cost=417,166.950..456,412.130 rows=232,372 width=656) (actual time=11,329.777..11,361.172 rows=719 loops=1)

  • Hash Cond: (mike_whiskey.two_romeo = foxtrot_foxtrot.two_romeo)
33. 29.751 37.370 ↑ 1.0 85,563 1

Bitmap Heap Scan on lima_kilo mike_whiskey (cost=1,622.370..38,164.920 rows=86,444 width=4) (actual time=10.775..37.370 rows=85,563 loops=1)

  • Recheck Cond: ((xray)::text = 'juliet_quebec'::text)
  • Heap Blocks: exact=24486
34. 7.619 7.619 ↑ 1.0 85,583 1

Bitmap Index Scan on delta_bravo (cost=0.000..1,600.750 rows=86,444 width=0) (actual time=7.619..7.619 rows=85,583 loops=1)

  • Index Cond: ((xray)::text = 'juliet_quebec'::text)
35. 0.170 11,316.318 ↑ 976.4 238 1

Hash (cost=412,639.940..412,639.940 rows=232,372 width=656) (actual time=11,316.318..11,316.318 rows=238 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 81kB
36. 12.617 11,316.148 ↑ 976.4 238 1

Hash Right Join (cost=400,171.440..412,639.940 rows=232,372 width=656) (actual time=9,493.054..11,316.148 rows=238 loops=1)

  • Hash Cond: (foxtrot_kilo.two_romeo = lima_papa.two_romeo)
37. 4,234.261 4,234.261 ↑ 1.0 97,016 1

CTE Scan on foxtrot_kilo (cost=0.000..1,955.620 rows=97,781 width=152) (actual time=2,332.629..4,234.261 rows=97,016 loops=1)

38. 0.182 7,069.270 ↑ 273.3 238 1

Hash (cost=399,358.360..399,358.360 rows=65,046 width=508) (actual time=7,069.270..7,069.270 rows=238 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 70kB
39. 24.823 7,069.088 ↑ 273.3 238 1

Hash Join (cost=378,478.140..399,358.360 rows=65,046 width=508) (actual time=6,743.207..7,069.088 rows=238 loops=1)

  • Hash Cond: (foxtrot_foxtrot.two_romeo = echo.two_romeo)
40. 283.146 5,690.186 ↓ 1.2 473,235 1

Hash Right Join (cost=311,603.720..331,015.080 rows=388,863 width=512) (actual time=5,376.727..5,690.186 rows=473,235 loops=1)

  • Hash Cond: (romeo_three.two_romeo = lima_papa.two_romeo)
41. 78.140 257.152 ↑ 1.0 97,781 1

HashAggregate (cost=58,539.530..59,517.340 rows=97,781 width=26) (actual time=226.738..257.152 rows=97,781 loops=1)

  • Group Key: romeo_three.two_romeo
42. 19.844 179.012 ↓ 1.1 104,286 1

Hash Left Join (cost=24,745.700..33,605.380 rows=97,781 width=26) (actual time=115.927..179.012 rows=104,286 loops=1)

  • Hash Cond: (romeo_three.two_romeo = charlie_hotel.two_romeo)
43. 30.128 43.361 ↑ 1.0 97,781 1

Hash Left Join (cost=1.880..6,783.710 rows=97,781 width=15) (actual time=0.054..43.361 rows=97,781 loops=1)

  • Hash Cond: ((romeo_three.whiskey_echo_tango)::text = (quebec_sierra.tango)::text)
44. 13.212 13.212 ↑ 1.0 97,781 1

Seq Scan on foxtrot_foxtrot romeo_three (cost=0.000..5,526.810 rows=97,781 width=8) (actual time=0.006..13.212 rows=97,781 loops=1)

45. 0.005 0.021 ↑ 1.0 39 1

Hash (cost=1.390..1.390 rows=39 width=15) (actual time=0.021..0.021 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
46. 0.016 0.016 ↑ 1.0 39 1

Seq Scan on five_xray quebec_sierra (cost=0.000..1.390 rows=39 width=15) (actual time=0.005..0.016 rows=39 loops=1)

47. 4.629 115.807 ↑ 3.3 32,439 1

Hash (cost=23,394.510..23,394.510 rows=107,945 width=15) (actual time=115.807..115.807 rows=32,439 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1442kB
48. 2.649 111.178 ↑ 3.3 32,439 1

Subquery Scan on charlie_hotel (cost=22,045.200..23,394.510 rows=107,945 width=15) (actual time=106.928..111.178 rows=32,439 loops=1)

49. 11.247 108.529 ↑ 3.3 32,439 1

Sort (cost=22,045.200..22,315.060 rows=107,945 width=15) (actual time=106.927..108.529 rows=32,439 loops=1)

  • Sort Key: six_lima_november1.two_romeo, golf_juliet1.zulu_mike
  • Sort Method: quicksort Memory: 2370kB
50. 5.814 97.282 ↑ 3.3 32,439 1

Hash Join (cost=6,750.950..13,021.030 rows=107,945 width=15) (actual time=40.895..97.282 rows=32,439 loops=1)

  • Hash Cond: ((two_yankee.tango)::text = (golf_juliet1.tango)::text)
51. 39.996 91.456 ↑ 3.3 32,439 1

Hash Join (cost=6,749.070..11,534.910 rows=107,945 width=8) (actual time=40.871..91.456 rows=32,439 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: 95956
52. 10.669 10.669 ↑ 1.0 128,395 1

Seq Scan on papa_four two_yankee (cost=0.000..1,896.950 rows=128,395 width=8) (actual time=0.013..10.669 rows=128,395 loops=1)

53. 13.547 40.791 ↑ 1.0 97,781 1

Hash (cost=5,526.810..5,526.810 rows=97,781 width=8) (actual time=40.791..40.791 rows=97,781 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 3792kB
54. 27.244 27.244 ↑ 1.0 97,781 1

Seq Scan on foxtrot_foxtrot victor_echo (cost=0.000..5,526.810 rows=97,781 width=8) (actual time=0.002..27.244 rows=97,781 loops=1)

55. 0.009 0.012 ↑ 1.0 39 1

Hash (cost=1.390..1.390 rows=39 width=15) (actual time=0.012..0.012 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
56. 0.003 0.003 ↑ 1.0 39 1

Seq Scan on five_xray zulu_zulu (cost=0.000..1.390 rows=39 width=15) (actual time=0.001..0.003 rows=39 loops=1)

57. 224.582 5,149.888 ↓ 4.3 473,235 1

Hash (cost=251,703.550..251,703.550 rows=108,851 width=448) (actual time=5,149.888..5,149.888 rows=473,235 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 126773kB
58. 117.789 4,925.306 ↓ 4.3 473,235 1

Merge Left Join (cost=186,912.630..251,703.550 rows=108,851 width=448) (actual time=3,088.156..4,925.306 rows=473,235 loops=1)

  • Merge Cond: (lima_kilo.two_romeo = hotel_foxtrot.two_romeo)
59. 131.207 4,620.878 ↓ 10.2 473,235 1

Nested Loop (cost=147,005.040..210,047.130 rows=46,427 width=416) (actual time=2,928.508..4,620.878 rows=473,235 loops=1)

60. 108.498 3,069.966 ↓ 10.2 473,235 1

Merge Left Join (cost=147,004.610..147,535.670 rows=46,484 width=93) (actual time=2,928.456..3,069.966 rows=473,235 loops=1)

  • Merge Cond: (lima_kilo.two_romeo = golf_november_foxtrot.two_romeo)
61. 137.415 2,909.189 ↓ 10.2 473,235 1

Sort (cost=138,282.190..138,398.400 rows=46,484 width=61) (actual time=2,880.758..2,909.189 rows=473,235 loops=1)

  • Sort Key: foxtrot_foxtrot.two_romeo
  • Sort Method: quicksort Memory: 66774kB
62. 1,359.177 2,771.774 ↓ 10.2 473,235 1

Hash Right Join (cost=118,869.250..134,678.650 rows=46,484 width=61) (actual time=1,353.229..2,771.774 rows=473,235 loops=1)

  • Hash Cond: (quebec_whiskey.whiskey_echo_hotel = lima_kilo.whiskey_echo_hotel)
63. 110.090 110.090 ↓ 4.0 741,210 1

Seq Scan on quebec_whiskey (cost=0.000..14,998.910 rows=185,191 width=8) (actual time=50.680..110.090 rows=741,210 loops=1)

64. 108.637 1,302.507 ↓ 10.2 473,235 1

Hash (cost=118,288.200..118,288.200 rows=46,484 width=57) (actual time=1,302.507..1,302.507 rows=473,235 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 39599kB
65. 176.454 1,193.870 ↓ 10.2 473,235 1

Hash Join (cost=19,824.750..118,288.200 rows=46,484 width=57) (actual time=164.073..1,193.870 rows=473,235 loops=1)

  • Hash Cond: (lima_kilo.two_romeo = foxtrot_foxtrot.two_romeo)
66. 83.489 960.137 ↓ 10.0 476,070 1

Hash Join (cost=13,103.920..110,626.690 rows=47,583 width=14) (actual time=106.730..960.137 rows=476,070 loops=1)

  • Hash Cond: ((lima_kilo.xray)::text = (three_hotel.xray)::text)
67. 774.756 834.978 ↓ 1.3 476,070 1

Bitmap Heap Scan on lima_kilo (cost=13,019.940..108,176.540 rows=378,069 width=17) (actual time=65.040..834.978 rows=476,070 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: 17276
  • Heap Blocks: exact=35291
68. 60.222 60.222 ↓ 1.3 493,349 1

Bitmap Index Scan on uniform_xray (cost=0.000..12,925.420 rows=391,440 width=0) (actual time=60.222..60.222 rows=493,349 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))
69. 0.087 41.670 ↓ 8.3 141 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
70. 41.583 41.583 ↓ 8.3 141 1

Seq Scan on three_hotel (cost=0.000..83.770 rows=17 width=3) (actual time=24.584..41.583 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
71. 18.031 57.279 ↑ 1.0 95,452 1

Hash (cost=5,526.810..5,526.810 rows=95,522 width=43) (actual time=57.279..57.279 rows=95,452 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 6967kB
72. 39.248 39.248 ↑ 1.0 95,452 1

Seq Scan on foxtrot_foxtrot (cost=0.000..5,526.810 rows=95,522 width=43) (actual time=0.017..39.248 rows=95,452 loops=1)

  • Filter: (NOT three_lima)
  • Rows Removed by Filter: 2329
73. 7.003 52.279 ↓ 6.5 78,415 1

Sort (cost=8,722.420..8,752.590 rows=12,067 width=36) (actual time=47.689..52.279 rows=78,415 loops=1)

  • Sort Key: golf_november_foxtrot.two_romeo
  • Sort Method: quicksort Memory: 982kB
74. 0.727 45.276 ↑ 1.2 10,392 1

Subquery Scan on golf_november_foxtrot (cost=7,663.010..7,904.350 rows=12,067 width=36) (actual time=43.067..45.276 rows=10,392 loops=1)

75. 14.507 44.549 ↑ 1.2 10,392 1

HashAggregate (cost=7,663.010..7,783.680 rows=12,067 width=150) (actual time=43.066..44.549 rows=10,392 loops=1)

  • Group Key: foxtrot_juliet.two_romeo
76. 13.916 30.042 ↑ 1.0 15,569 1

Sort (cost=3,485.550..3,524.960 rows=15,764 width=20) (actual time=29.225..30.042 rows=15,569 loops=1)

  • Sort Key: (CASE WHEN (golf_juliet2.seven_six_hotel five_romeo NOT NULL) THEN golf_juliet2.seven_six_hotel ELSE golf_juliet2.zulu_mike END)
  • Sort Method: quicksort Memory: 1132kB
77. 3.052 16.126 ↑ 1.0 15,569 1

Hash Join (cost=10.010..2,386.460 rows=15,764 width=20) (actual time=0.138..16.126 rows=15,569 loops=1)

  • Hash Cond: ((foxtrot_juliet.xray)::text = (golf_juliet2.xray)::text)
78. 12.972 12.972 ↑ 1.0 15,569 1

Seq Scan on six_five foxtrot_juliet (cost=0.000..2,159.700 rows=15,764 width=7) (actual time=0.019..12.972 rows=15,569 loops=1)

  • Filter: ((quebec_alpha)::text = 'delta_oscar'::text)
  • Rows Removed by Filter: 86487
79. 0.031 0.102 ↑ 1.0 178 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
80. 0.071 0.071 ↑ 1.0 178 1

Seq Scan on four_lima romeo_two (cost=0.000..7.780 rows=178 width=19) (actual time=0.004..0.071 rows=178 loops=1)

81. 1,419.705 1,419.705 ↑ 1.0 1 473,235

Index Scan using hotel_papa on lima_papa (cost=0.420..1.330 rows=1 width=331) (actual time=0.002..0.003 rows=1 loops=473,235)

  • Index Cond: (whiskey_echo_hotel = lima_kilo.whiskey_echo_hotel)
82. 46.749 186.639 ↓ 6.8 448,902 1

Sort (cost=39,907.590..40,072.730 rows=66,056 width=36) (actual time=159.639..186.639 rows=448,902 loops=1)

  • Sort Key: hotel_foxtrot.two_romeo
  • Sort Method: quicksort Memory: 7179kB
83. 5.717 139.890 ↓ 1.3 85,819 1

Subquery Scan on hotel_foxtrot (cost=33,298.220..34,619.340 rows=66,056 width=36) (actual time=122.146..139.890 rows=85,819 loops=1)

84. 35.358 134.173 ↓ 1.3 85,819 1

HashAggregate (cost=33,298.220..33,958.780 rows=66,056 width=150) (actual time=122.146..134.173 rows=85,819 loops=1)

  • Group Key: oscar_alpha1.two_romeo
85. 71.128 98.815 ↓ 1.0 86,487 1

Sort (cost=10,430.840..10,646.570 rows=86,292 width=20) (actual time=94.709..98.815 rows=86,487 loops=1)

  • Sort Key: (CASE WHEN (golf_juliet3.seven_six_hotel five_romeo NOT NULL) THEN golf_juliet3.seven_six_hotel ELSE golf_juliet3.zulu_mike END)
  • Sort Method: quicksort Memory: 7196kB
86. 16.458 27.687 ↓ 1.0 86,487 1

Hash Join (cost=10.010..3,356.220 rows=86,292 width=20) (actual time=0.095..27.687 rows=86,487 loops=1)

  • Hash Cond: ((oscar_alpha1.xray)::text = (golf_juliet3.xray)::text)
87. 11.147 11.147 ↓ 1.0 86,487 1

Seq Scan on six_five romeo_romeo (cost=0.000..2,159.700 rows=86,292 width=7) (actual time=0.006..11.147 rows=86,487 loops=1)

  • Filter: ((quebec_alpha)::text = 'uniform_five'::text)
  • Rows Removed by Filter: 15569
88. 0.033 0.082 ↑ 1.0 178 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
89. 0.049 0.049 ↑ 1.0 178 1

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

90. 0.014 1,354.079 ↑ 8.1 33 1

Hash (cost=66,871.080..66,871.080 rows=267 width=4) (actual time=1,354.079..1,354.079 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
91. 0.046 1,354.065 ↑ 8.1 33 1

HashAggregate (cost=66,868.410..66,871.080 rows=267 width=4) (actual time=1,354.060..1,354.065 rows=33 loops=1)

  • Group Key: echo.two_romeo
92. 1,354.019 1,354.019 ↑ 142.2 115 1

Seq Scan on echo (cost=0.000..66,827.520 rows=16,356 width=4) (actual time=21.059..1,354.019 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_sierra'::text)))
  • Rows Removed by Filter: 2029426
93.          

SubPlan (forSubquery Scan)

94. 0.006 488.735 ↑ 23.0 1 1

HashAggregate (cost=53,097.210..53,097.440 rows=23 width=4) (actual time=488.735..488.735 rows=1 loops=1)

  • Group Key: lima_mike1.two_romeo
95. 0.002 488.729 ↑ 11.5 2 1

Append (cost=0.000..53,097.150 rows=23 width=4) (actual time=28.512..488.729 rows=2 loops=1)

96. 107.468 107.468 ↑ 20.0 1 1

Seq Scan on foxtrot_foxtrot five_oscar (cost=0.000..6,504.620 rows=20 width=4) (actual time=28.511..107.468 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: 97780
97. 0.015 381.259 ↑ 3.0 1 1

HashAggregate (cost=46,592.270..46,592.300 rows=3 width=4) (actual time=381.258..381.259 rows=1 loops=1)

  • Group Key: victor_oscar1.two_romeo
98. 381.244 381.244 ↑ 5.7 13 1

Seq Scan on lima_kilo sierra_charlie (cost=0.000..46,592.090 rows=74 width=4) (actual time=337.370..381.244 rows=13 loops=1)

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