explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IQfh

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 6,425.961 ↑ 1.0 1 1

Limit (cost=3,073,356.610..3,073,356.610 rows=1 width=616) (actual time=6,425.941..6,425.961 rows=1 loops=1)

2.          

CTE victor_zulu

3. 3,499.883 5,477.843 ↑ 30.6 100,860 1

Hash Left Join (cost=42,956.280..621,131.310 rows=3,083,027 width=59) (actual time=884.855..5,477.843 rows=100,860 loops=1)

  • Hash Cond: (quebec_xray.delta_november = zulu_tango.yankee_whiskey)
  • Join Filter: ((zulu_tango.foxtrot_tango <= quebec_sierra.victor_xray) AND (zulu_tango.uniform_two >= quebec_sierra.victor_xray))
  • Rows Removed by Join Filter: 12378358
4. 52.477 1,968.140 ↓ 3.4 100,860 1

Hash Left Join (cost=42,340.970..84,002.290 rows=30,007 width=40) (actual time=874.998..1,968.140 rows=100,860 loops=1)

  • Hash Cond: (quebec_sierra.quebec_kilo = quebec_xray.quebec_kilo)
5. 124.952 1,915.280 ↓ 3.4 100,860 1

Hash Join (cost=42,310.610..83,559.340 rows=30,007 width=41) (actual time=874.600..1,915.280 rows=100,860 loops=1)

  • Hash Cond: (five_four.charlie_zulu = quebec_sierra.charlie_zulu)
6. 54.222 1,439.799 ↓ 3.4 100,866 1

Nested Loop (cost=31,168.780..70,654.810 rows=30,034 width=25) (actual time=523.029..1,439.799 rows=100,866 loops=1)

7. 109.497 880.532 ↓ 3.4 101,009 1

Hash Join (cost=31,168.360..41,765.470 rows=30,034 width=19) (actual time=522.985..880.532 rows=101,009 loops=1)

  • Hash Cond: (foxtrot_six.foxtrot_three = seven_uniform.foxtrot_three)
8. 198.165 523.381 ↓ 3.4 103,470 1

Hash Join (cost=17,937.860..26,848.190 rows=30,788 width=25) (actual time=274.434..523.381 rows=103,470 loops=1)

  • Hash Cond: (foxtrot_six.november_juliet = alpha_quebec2.november_juliet)
9. 51.133 51.133 ↓ 1.0 240,693 1

Seq Scan on bravo_charlie_sierra foxtrot_six (cost=0.000..7,699.890 rows=240,689 width=25) (actual time=0.010..51.133 rows=240,693 loops=1)

10. 33.282 274.083 ↓ 2.8 90,685 1

Hash (cost=17,531.160..17,531.160 rows=32,536 width=6) (actual time=274.083..274.083 rows=90,685 loops=1)

  • Buckets: 131072 (originally 32768) Batches: 2 (originally 1) Memory Usage: 3073kB
11. 219.550 240.801 ↓ 2.8 90,685 1

Bitmap Heap Scan on xray_november zulu_zulu (cost=2,251.130..17,531.160 rows=32,536 width=6) (actual time=23.603..240.801 rows=90,685 loops=1)

  • Recheck Cond: (seven_delta = ANY ('alpha_five'::numeric[]))
  • Filter: ((golf_foxtrot = ANY ('hotel_delta'::bpchar[])) AND ((delta_kilo)::date <= ('juliet_five'::cstring)::date))
  • Rows Removed by Filter: 20742
  • Heap Blocks: exact=10945
12. 21.251 21.251 ↓ 1.0 111,504 1

Bitmap Index Scan on kilo_juliet (cost=0.000..2,242.990 rows=110,630 width=0) (actual time=21.251..21.251 rows=111,504 loops=1)

  • Index Cond: (seven_delta = ANY ('alpha_five'::numeric[]))
13. 83.415 247.654 ↓ 1.0 217,409 1

Hash (cost=9,666.030..9,666.030 rows=217,237 width=6) (actual time=247.654..247.654 rows=217,409 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 3092kB
14. 164.239 164.239 ↓ 1.0 217,409 1

Seq Scan on papa_echo seven_uniform (cost=0.000..9,666.030 rows=217,237 width=6) (actual time=0.034..164.239 rows=217,409 loops=1)

  • Filter: (golf_foxtrot <> november_november ('mike_foxtrot'::bpchar[]))
  • Rows Removed by Filter: 5286
15. 505.045 505.045 ↑ 1.0 1 101,009

Index Scan using yankee_tango on romeo_delta five_four (cost=0.420..0.950 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=101,009)

  • Index Cond: (yankee_papa_hotel_romeo = foxtrot_six.yankee_papa_hotel_romeo)
16. 89.576 350.529 ↑ 1.0 137,058 1

Hash (cost=8,490.220..8,490.220 rows=137,089 width=28) (actual time=350.529..350.529 rows=137,058 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2613kB
17. 260.953 260.953 ↑ 1.0 137,058 1

Seq Scan on four_seven quebec_sierra (cost=0.000..8,490.220 rows=137,089 width=28) (actual time=0.049..260.953 rows=137,058 loops=1)

  • Filter: ((golf_foxtrot = ANY ('hotel_delta'::bpchar[])) AND (romeo_quebec <= ('juliet_five'::cstring)::date))
  • Rows Removed by Filter: 106
18. 0.140 0.383 ↑ 1.0 549 1

Hash (cost=23.490..23.490 rows=549 width=11) (actual time=0.383..0.383 rows=549 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
19. 0.243 0.243 ↑ 1.0 549 1

Seq Scan on india quebec_xray (cost=0.000..23.490 rows=549 width=11) (actual time=0.007..0.243 rows=549 loops=1)

20. 3.127 9.820 ↑ 1.0 13,565 1

Hash (cost=445.750..445.750 rows=13,565 width=28) (actual time=9.820..9.820 rows=13,565 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 986kB
21. 6.693 6.693 ↑ 1.0 13,565 1

Seq Scan on hotel_romeo zulu_tango (cost=0.000..445.750 rows=13,565 width=28) (actual time=0.017..6.693 rows=13,565 loops=1)

  • Filter: (delta_november = 'oscar_uniform'::numeric)
  • Rows Removed by Filter: 15
22.          

CTE yankee_papa_hotel_papa

23. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=781,013.460..858,889.140 rows=40,000 width=112) (never executed)

  • Group Key: seven_golf.november_juliet, (xray_yankee(seven_golf.romeo_quebec, 'romeo_juliet'::text))
24. 0.000 0.000 ↓ 0.0 0

Sort (cost=781,013.460..788,721.030 rows=3,083,027 width=120) (never executed)

  • Sort Key: seven_golf.november_juliet, (xray_yankee(seven_golf.romeo_quebec, 'romeo_juliet'::text))
25. 0.000 0.000 ↓ 0.0 0

CTE Scan on victor_zulu seven_golf (cost=0.000..69,368.110 rows=3,083,027 width=120) (never executed)

26.          

CTE four_foxtrot

27. 67.666 6,270.137 ↑ 9.5 49,440 1

GroupAggregate (cost=1,452,784.310..1,490,637.880 rows=468,220 width=78) (actual time=6,188.447..6,270.137 rows=49,440 loops=1)

  • Group Key: romeo_three.six_mike_xray, romeo_three.yankee_oscar
28. 73.498 6,202.471 ↑ 30.6 100,860 1

Sort (cost=1,452,784.310..1,460,491.870 rows=3,083,027 width=46) (actual time=6,188.296..6,202.471 rows=100,860 loops=1)

  • Sort Key: romeo_three.six_mike_xray, romeo_three.yankee_oscar
  • Sort Method: external sort Disk: 3008kB
29. 9.336 6,128.973 ↑ 30.6 100,860 1

Subquery Scan on romeo_three (cost=815,204.440..930,817.950 rows=3,083,027 width=46) (actual time=6,028.580..6,128.973 rows=100,860 loops=1)

30. 75.098 6,119.637 ↑ 30.6 100,860 1

WindowAgg (cost=815,204.440..899,987.680 rows=3,083,027 width=46) (actual time=6,028.579..6,119.637 rows=100,860 loops=1)

31. 96.416 6,044.539 ↑ 30.6 100,860 1

Sort (cost=815,204.440..822,912.010 rows=3,083,027 width=78) (actual time=6,028.550..6,044.539 rows=100,860 loops=1)

  • Sort Key: alpha_quebec.six_mike_xray
  • Sort Method: external merge Disk: 3160kB
32. 115.908 5,948.123 ↑ 30.6 100,860 1

Hash Join (cost=19,340.920..208,937.080 rows=3,083,027 width=78) (actual time=1,047.719..5,948.123 rows=100,860 loops=1)

  • Hash Cond: (xray_juliet1.november_juliet = alpha_quebec.november_juliet)
33. 5,671.833 5,671.833 ↑ 30.6 100,860 1

CTE Scan on victor_zulu oscar_foxtrot (cost=0.000..61,660.540 rows=3,083,027 width=88) (actual time=884.859..5,671.833 rows=100,860 loops=1)

34. 67.640 160.382 ↑ 1.0 254,343 1

Hash (cost=14,919.520..14,919.520 rows=254,352 width=12) (actual time=160.382..160.382 rows=254,343 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 3565kB
35. 92.742 92.742 ↑ 1.0 254,343 1

Seq Scan on xray_november alpha_quebec (cost=0.000..14,919.520 rows=254,352 width=12) (actual time=0.016..92.742 rows=254,343 loops=1)

36. 0.073 6,425.939 ↑ 101,322.0 1 1

Sort (cost=102,698.280..102,951.590 rows=101,322 width=616) (actual time=6,425.939..6,425.939 rows=1 loops=1)

  • Sort Key: (((papa_kilo.zulu_uniform)::text || 'kilo_november'::text))
  • Sort Method: top-N heapsort Memory: 25kB
37. 0.007 6,425.866 ↑ 5,629.0 18 1

Append (cost=94,739.730..101,178.450 rows=101,322 width=616) (actual time=6,425.348..6,425.866 rows=18 loops=1)

38. 7.604 6,425.855 ↑ 5,628.6 18 1

Merge Right Join (cost=94,739.730..100,165.310 rows=101,314 width=634) (actual time=6,425.347..6,425.855 rows=18 loops=1)

  • Merge Cond: (two_kilo_papa.six_mike_xray = papa_kilo.six_mike_xray)
39. 38.879 6,328.316 ↑ 9.5 49,440 1

Sort (cost=74,270.800..75,441.350 rows=468,220 width=80) (actual time=6,320.510..6,328.316 rows=49,440 loops=1)

  • Sort Key: two_kilo_papa.six_mike_xray
  • Sort Method: external sort Disk: 1704kB
40. 6,289.437 6,289.437 ↑ 9.5 49,440 1

CTE Scan on four_foxtrot two_kilo_papa (cost=0.000..9,364.400 rows=468,220 width=80) (actual time=6,188.450..6,289.437 rows=49,440 loops=1)

41. 0.010 89.935 ↑ 1,001.4 18 1

Materialize (cost=20,468.930..20,559.060 rows=18,026 width=321) (actual time=89.918..89.935 rows=18 loops=1)

42. 0.031 89.925 ↑ 1,001.4 18 1

Sort (cost=20,468.930..20,514.000 rows=18,026 width=321) (actual time=89.914..89.925 rows=18 loops=1)

  • Sort Key: papa_kilo.six_mike_xray
  • Sort Method: quicksort Memory: 34kB
43. 3.248 89.894 ↑ 1,001.4 18 1

Hash Right Join (cost=13,365.500..16,482.190 rows=18,026 width=321) (actual time=89.651..89.894 rows=18 loops=1)

  • Hash Cond: (echo_three.yankee_whiskey = lima_sierra(six_quebec.victor_india, six_quebec.delta_november))
  • Join Filter: ((echo_three.foxtrot_tango <= papa_kilo.kilo_four) AND (echo_three.uniform_two >= papa_kilo.kilo_four))
  • Rows Removed by Join Filter: 5181
44. 4.392 4.392 ↑ 1.0 13,565 1

Seq Scan on hotel_romeo echo_three (cost=0.000..445.750 rows=13,565 width=28) (actual time=0.014..4.392 rows=13,565 loops=1)

  • Filter: (delta_november = 'oscar_uniform'::numeric)
  • Rows Removed by Filter: 15
45. 0.020 82.254 ↑ 16.6 18 1

Hash (cost=13,361.760..13,361.760 rows=299 width=346) (actual time=82.254..82.254 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
46. 0.013 82.234 ↑ 16.6 18 1

Nested Loop Left Join (cost=52.440..13,361.760 rows=299 width=346) (actual time=64.307..82.234 rows=18 loops=1)

47. 0.012 82.095 ↑ 16.6 18 1

Nested Loop Left Join (cost=52.150..13,264.360 rows=299 width=293) (actual time=64.305..82.095 rows=18 loops=1)

48. 0.020 81.975 ↑ 4.8 18 1

Nested Loop Left Join (cost=51.730..11,276.660 rows=87 width=278) (actual time=64.281..81.975 rows=18 loops=1)

49. 0.012 81.919 ↑ 4.8 18 1

Nested Loop Left Join (cost=51.590..11,241.660 rows=87 width=279) (actual time=64.263..81.919 rows=18 loops=1)

50. 0.024 81.853 ↑ 4.8 18 1

Nested Loop Left Join (cost=51.300..10,662.250 rows=87 width=242) (actual time=64.256..81.853 rows=18 loops=1)

51. 0.020 81.775 ↑ 4.8 18 1

Nested Loop Left Join (cost=51.010..10,596.870 rows=87 width=204) (actual time=64.238..81.775 rows=18 loops=1)

52. 0.020 81.683 ↑ 4.8 18 1

Nested Loop Left Join (cost=50.730..10,117.690 rows=87 width=204) (actual time=64.204..81.683 rows=18 loops=1)

53. 0.017 81.591 ↑ 4.8 18 1

Nested Loop Left Join (cost=50.590..10,091.330 rows=87 width=177) (actual time=64.186..81.591 rows=18 loops=1)

54. 0.089 81.160 ↑ 4.8 18 1

Nested Loop Left Join (cost=49.320..9,330.530 rows=87 width=151) (actual time=64.069..81.160 rows=18 loops=1)

  • Join Filter: (alpha_two.delta_quebec = papa_kilo.kilo_hotel_tango_mike)
  • Rows Removed by Join Filter: 450
55. 0.024 80.621 ↑ 4.8 18 1

Nested Loop Left Join (cost=47.190..9,094.240 rows=87 width=151) (actual time=63.753..80.621 rows=18 loops=1)

  • Join Filter: ((lima_delta.six_mike_victor)::bpchar = papa_kilo.golf_foxtrot)
  • Rows Removed by Join Filter: 198
56. 0.021 80.129 ↑ 4.8 18 1

Nested Loop Left Join (cost=23.220..9,009.970 rows=87 width=115) (actual time=63.476..80.129 rows=18 loops=1)

  • Join Filter: ((foxtrot_victor_yankee_bravo.six_mike_victor)::text = (five_hotel.bravo_yankee)::text)
  • Rows Removed by Join Filter: 180
57. 0.052 79.568 ↑ 4.8 18 1

Nested Loop Left Join (cost=0.290..8,929.380 rows=87 width=118) (actual time=62.946..79.568 rows=18 loops=1)

58. 79.426 79.426 ↑ 4.8 18 1

Seq Scan on papa_alpha papa_kilo (cost=0.000..8,349.540 rows=87 width=84) (actual time=62.898..79.426 rows=18 loops=1)

  • Filter: ((kilo_four >= 'papa_delta'::date) AND (seven_delta = 'echo_golf'::numeric) AND (three_six = 'uniform_five'::bpchar) AND (juliet_romeo = 'lima_romeo'::numeric) AND (golf_foxtrot <> november_november ('mike_foxtrot'::bpchar[])))
  • Rows Removed by Filter: 83264
59. 0.090 0.090 ↑ 1.0 1 18

Index Scan using two_victor on xray_zulu five_hotel (cost=0.290..6.650 rows=1 width=69) (actual time=0.005..0.005 rows=1 loops=18)

  • Index Cond: (delta_quebec = papa_kilo.delta_quebec)
  • Filter: ((whiskey_kilo = 'uniform_five'::bpchar) OR (november_three = 'uniform_five'::bpchar))
60. 0.018 0.540 ↑ 1.0 10 18

Materialize (cost=22.930..67.570 rows=10 width=2) (actual time=0.025..0.030 rows=10 loops=18)

61. 0.246 0.522 ↑ 1.0 10 1

Hash Right Join (cost=22.930..67.520 rows=10 width=2) (actual time=0.456..0.522 rows=10 loops=1)

  • Hash Cond: (quebec_five.quebec_whiskey = foxtrot_victor_yankee_bravo.quebec_whiskey)
62. 0.221 0.221 ↓ 1.0 1,492 1

Seq Scan on sierra_yankee quebec_five (cost=0.000..38.900 rows=1,490 width=5) (actual time=0.013..0.221 rows=1,492 loops=1)

63. 0.005 0.055 ↑ 1.0 10 1

Hash (cost=22.800..22.800 rows=10 width=7) (actual time=0.055..0.055 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
64. 0.024 0.050 ↑ 1.0 10 1

Bitmap Heap Scan on bravo_charlie_november foxtrot_victor_yankee_bravo (cost=4.360..22.800 rows=10 width=7) (actual time=0.037..0.050 rows=10 loops=1)

  • Recheck Cond: (uniform_delta_mike = 'five_five'::numeric)
  • Heap Blocks: exact=2
65. 0.026 0.026 ↑ 1.0 10 1

Bitmap Index Scan on mike_uniform (cost=0.000..4.350 rows=10 width=0) (actual time=0.026..0.026 rows=10 loops=1)

  • Index Cond: (uniform_delta_mike = 'five_five'::numeric)
66. 0.024 0.468 ↑ 1.0 12 18

Materialize (cost=23.970..68.640 rows=12 width=41) (actual time=0.014..0.026 rows=12 loops=18)

67. 0.227 0.444 ↑ 1.0 12 1

Hash Right Join (cost=23.970..68.580 rows=12 width=41) (actual time=0.246..0.444 rows=12 loops=1)

  • Hash Cond: (bravo_papa.quebec_whiskey = lima_delta.quebec_whiskey)
68. 0.173 0.173 ↓ 1.0 1,492 1

Seq Scan on sierra_yankee bravo_papa (cost=0.000..38.900 rows=1,490 width=31) (actual time=0.004..0.173 rows=1,492 loops=1)

69. 0.004 0.044 ↑ 1.0 12 1

Hash (cost=23.820..23.820 rows=12 width=20) (actual time=0.044..0.044 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
70. 0.026 0.040 ↑ 1.0 12 1

Bitmap Heap Scan on bravo_charlie_november lima_delta (cost=4.370..23.820 rows=12 width=20) (actual time=0.022..0.040 rows=12 loops=1)

  • Recheck Cond: (uniform_delta_mike = 'charlie_papa'::numeric)
  • Heap Blocks: exact=3
71. 0.014 0.014 ↑ 1.0 12 1

Bitmap Index Scan on mike_uniform (cost=0.000..4.370 rows=12 width=0) (actual time=0.014..0.014 rows=12 loops=1)

  • Index Cond: (uniform_delta_mike = 'charlie_papa'::numeric)
72. 0.044 0.450 ↑ 1.0 26 18

Materialize (cost=2.140..202.430 rows=26 width=6) (actual time=0.006..0.025 rows=26 loops=18)

73. 0.019 0.406 ↑ 1.0 26 1

Nested Loop (cost=2.140..202.300 rows=26 width=6) (actual time=0.100..0.406 rows=26 loops=1)

74. 0.031 0.049 ↑ 1.0 26 1

HashAggregate (cost=1.850..2.110 rows=26 width=7) (actual time=0.045..0.049 rows=26 loops=1)

  • Group Key: papa_charlie.delta_quebec
75. 0.018 0.018 ↑ 1.0 68 1

Seq Scan on papa_charlie (cost=0.000..1.680 rows=68 width=7) (actual time=0.013..0.018 rows=68 loops=1)

76. 0.338 0.338 ↑ 1.0 1 26

Index Only Scan using two_victor on xray_zulu alpha_two (cost=0.290..7.690 rows=1 width=6) (actual time=0.013..0.013 rows=1 loops=26)

  • Index Cond: (delta_quebec = papa_charlie.delta_quebec)
  • Heap Fetches: 26
77. 0.072 0.414 ↑ 1.0 1 18

Nested Loop Left Join (cost=1.260..8.730 rows=1 width=38) (actual time=0.022..0.023 rows=1 loops=18)

78. 0.018 0.306 ↑ 1.0 1 18

Nested Loop Left Join (cost=0.990..8.330 rows=1 width=47) (actual time=0.016..0.017 rows=1 loops=18)

79. 0.018 0.216 ↑ 1.0 1 18

Nested Loop Left Join (cost=0.700..7.500 rows=1 width=32) (actual time=0.011..0.012 rows=1 loops=18)

80. 0.018 0.144 ↑ 1.0 1 18

Nested Loop Left Join (cost=0.430..6.270 rows=1 width=28) (actual time=0.008..0.008 rows=1 loops=18)

81. 0.072 0.072 ↑ 1.0 1 18

Index Scan using quebec_mike on kilo_charlie golf_three (cost=0.290..6.100 rows=1 width=19) (actual time=0.004..0.004 rows=1 loops=18)

  • Index Cond: (whiskey_juliet = papa_kilo.foxtrot_india)
  • Filter: (foxtrot_victor_yankee_four = 'whiskey_xray'::numeric)
82. 0.054 0.054 ↑ 1.0 1 18

Index Scan using three_two on zulu_papa mike_seven (cost=0.140..0.160 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=18)

  • Index Cond: (yankee_juliet = golf_three.yankee_juliet)
83. 0.054 0.054 ↑ 1.0 1 18

Index Scan using romeo_whiskey on five_kilo echo_echo (cost=0.270..1.220 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=18)

  • Index Cond: (six_sierra = mike_seven.six_sierra)
84. 0.072 0.072 ↑ 1.0 1 18

Index Scan using victor_kilo on xray_seven kilo_seven (cost=0.290..0.820 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=18)

  • Index Cond: (four_alpha = golf_three.four_alpha)
85. 0.036 0.036 ↑ 1.0 1 18

Index Scan using romeo_whiskey on five_kilo four_bravo (cost=0.270..0.290 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=18)

  • Index Cond: (six_sierra = kilo_seven.six_sierra)
86. 0.072 0.072 ↑ 1.0 1 18

Index Scan using zulu_four on romeo_xray six_quebec (cost=0.140..0.290 rows=1 width=48) (actual time=0.004..0.004 rows=1 loops=18)

  • Index Cond: (yankee_uniform = papa_kilo.yankee_uniform)
87. 0.072 0.072 ↑ 1.0 1 18

Index Scan using uniform_foxtrot on tango_golf kilo_hotel_tango_juliet (cost=0.290..5.500 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=18)

  • Index Cond: (uniform_delta_uniform = papa_kilo.echo_foxtrot)
88. 0.054 0.054 ↑ 1.0 1 18

Index Scan using two_victor on xray_zulu kilo_lima (cost=0.290..0.740 rows=1 width=50) (actual time=0.003..0.003 rows=1 loops=18)

  • Index Cond: (delta_quebec = kilo_hotel_tango_juliet.delta_quebec)
89. 0.054 0.054 ↑ 1.0 1 18

Index Scan using two_victor on xray_zulu lima_mike (cost=0.290..6.650 rows=1 width=50) (actual time=0.002..0.003 rows=1 loops=18)

  • Index Cond: (delta_quebec = papa_kilo.kilo_hotel_tango_mike)
90. 0.036 0.036 ↑ 1.0 1 18

Index Scan using bravo_golf on yankee_victor three_tango (cost=0.140..0.390 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=18)

  • Index Cond: (delta_november = papa_kilo.delta_november)
91. 0.108 0.108 ↑ 9.0 1 18

Index Scan using papa_november on tango_romeo mike_zulu (cost=0.420..22.760 rows=9 width=21) (actual time=0.005..0.006 rows=1 loops=18)

  • Index Cond: (six_mike_xray = papa_kilo.six_mike_xray)
92. 0.126 0.126 ↑ 1.0 1 18

Index Scan using quebec_papa on bravo_six two_kilo_foxtrot (cost=0.290..0.320 rows=1 width=65) (actual time=0.007..0.007 rows=1 loops=18)

  • Index Cond: (sierra_quebec = mike_zulu.sierra_quebec)
93. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.000..0.000 rows=0 width=633) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
94. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.000..0.000 rows=0 width=632) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
95. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.000..0.000 rows=0 width=632) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
96. 0.002 0.002 ↓ 0.0 0 1

Subquery Scan on uniform_papa (cost=0.000..0.000 rows=1 width=656) (actual time=0.002..0.002 rows=0 loops=1)

97. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.000..0.000 rows=0 width=656) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
98. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.000..0.000 rows=0 width=673) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
99. 0.000 0.000 ↓ 0.0 0 1

Subquery Scan on uniform_lima (cost=0.000..0.000 rows=1 width=510) (actual time=0.000..0.000 rows=0 loops=1)

100. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.000..0.000 rows=0 width=510) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
101. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.000..0.000 rows=0 width=656) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
102. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.000..0.000 rows=0 width=655) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false