explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uqeh : ㅁㅁ

Settings
# exclusive inclusive rows x rows loops node
1. 0.122 1,513,825.598 ↓ 15.0 15 1

Subquery Scan on romeo_three (cost=642,685,125,908.070..642,685,125,910.720 rows=1 width=340) (actual time=1,513,825.087..1,513,825.598 rows=15 loops=1)

  • Filter: ((romeo_three.charlie >= 1) AND (romeo_three.charlie <= 15))
  • Rows Removed by Filter: 1045
  • Buffers: shared hit=9493180 read=95450
2. 0.786 1,513,825.476 ↓ 18.0 1,060 1

WindowAgg (cost=642,685,125,908.070..642,685,125,909.840 rows=59 width=340) (actual time=1,513,825.085..1,513,825.476 rows=1,060 loops=1)

  • Buffers: shared hit=9493180 read=95450
3. 0.458 1,513,824.690 ↓ 18.0 1,060 1

WindowAgg (cost=642,685,125,908.070..642,685,125,909.100 rows=59 width=332) (actual time=1,513,824.137..1,513,824.690 rows=1,060 loops=1)

  • Buffers: shared hit=9493180 read=95450
4. 2.927 1,513,824.232 ↓ 18.0 1,060 1

Sort (cost=642,685,125,908.070..642,685,125,908.210 rows=59 width=324) (actual time=1,513,824.132..1,513,824.232 rows=1,060 loops=1)

  • Sort Key: six_lima1.bravo_lima DESC
  • Sort Method: quicksort Memory: 198kB
  • Buffers: shared hit=9493180 read=95450
5. 0.441 1,513,821.305 ↓ 18.0 1,060 1

WindowAgg (cost=642,685,125,903.090..642,685,125,906.330 rows=59 width=324) (actual time=1,513,819.876..1,513,821.305 rows=1,060 loops=1)

  • Buffers: shared hit=9493177 read=95450
6. 0.900 1,513,820.864 ↓ 18.0 1,060 1

GroupAggregate (cost=642,685,125,903.090..642,685,125,905.450 rows=59 width=316) (actual time=1,513,819.871..1,513,820.864 rows=1,060 loops=1)

  • Group Key: six_lima1.bravo_lima, six_lima1.alpha_victor, six_lima1.india_three, six_lima1.oscar_echo, six_lima1.november_oscar, six_lima1.yankee_echo
  • Filter: (five_two(CASE WHEN (six_lima1.zulu_xray = 'uniform_five'::text) THEN 1 ELSE NULL::integer END) > 0)
  • Buffers: shared hit=9493177 read=95450
7. 6.492 1,513,819.964 ↓ 36.3 2,143 1

Sort (cost=642,685,125,903.090..642,685,125,903.230 rows=59 width=332) (actual time=1,513,819.862..1,513,819.964 rows=2,143 loops=1)

  • Sort Key: six_lima1.bravo_lima, six_lima1.alpha_victor, six_lima1.india_three, six_lima1.oscar_echo, six_lima1.november_oscar, six_lima1.yankee_echo
  • Sort Method: quicksort Memory: 339kB
  • Buffers: shared hit=9493177 read=95450
8. 1.201 1,513,813.472 ↓ 36.3 2,143 1

Subquery Scan on victor (cost=0.710..642,685,125,901.350 rows=59 width=332) (actual time=1,231,849.832..1,513,813.472 rows=2,143 loops=1)

  • Buffers: shared hit=9493174 read=95450
9. 966,681.537 1,513,812.271 ↓ 36.3 2,143 1

Nested Loop (cost=0.710..642,685,125,900.760 rows=59 width=340) (actual time=1,231,849.830..1,513,812.271 rows=2,143 loops=1)

  • Join Filter: ((hotel_zulu.bravo_lima)::text = (november_mike.bravo_lima)::text)
  • Rows Removed by Join Filter: 10762308868
  • Buffers: shared hit=9493174 read=95450
10. 1,167.151 1,167.151 ↓ 1.0 5,022,077 1

Seq Scan on juliet_zulu november_mike (cost=0.000..175,662.490 rows=5,021,049 width=18) (actual time=1.560..1,167.151 rows=5,022,077 loops=1)

  • Buffers: shared hit=31448 read=94044
11. 520,553.224 532,340.162 ↓ 36.3 2,143 5,022,077

Materialize (cost=0.710..626,932,480,890.660 rows=59 width=43) (actual time=0.000..0.106 rows=2,143 loops=5,022,077)

  • Buffers: shared hit=4420009 read=1076
12. 3.415 11,786.938 ↓ 36.3 2,143 1

Nested Loop (cost=0.710..626,932,480,890.360 rows=59 width=43) (actual time=185.615..11,786.938 rows=2,143 loops=1)

  • Buffers: shared hit=4420009 read=1076
13. 371.868 371.868 ↓ 1.3 2,985 1

Index Scan using lima_hotel on xray lima_echo (cost=0.420..29,372.900 rows=2,349 width=16) (actual time=97.770..371.868 rows=2,985 loops=1)

  • Filter: ((kilo_quebec >= ('golf_lima_echo'::cstring)::date) AND (kilo_quebec <= (('golf_lima_echo'::cstring)::date + 'two_three'::interval)))
  • Rows Removed by Filter: 211195
  • Buffers: shared hit=15171 read=562
14. 20.295 11,411.655 ↑ 1.0 1 2,985

Index Scan using juliet_sierra on alpha_romeo hotel_zulu (cost=0.290..266,893,338.230 rows=1 width=27) (actual time=3.823..3.823 rows=1 loops=2,985)

  • Index Cond: ((bravo_lima)::text = (lima_echo.bravo_lima)::text)
  • Filter: ((lima_echo.kilo_quebec >= kilo_quebec) AND (lima_sierra((delta_four 15), 'november_golf'::numeric) > 'november_golf'::numeric))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4404838 read=514
15.          

SubPlan (for Index Scan)

16. 4.352 11,391.360 ↑ 1.0 1 2,176

Aggregate (cost=266,893,337.680..266,893,337.690 rows=1 width=32) (actual time=5.235..5.235 rows=1 loops=2,176)

  • Buffers: shared hit=4396587 read=513
17. 7.629 11,387.008 ↓ 2.0 2 2,176

Nested Loop Semi Join (cost=0.980..266,893,337.680 rows=1 width=5) (actual time=2.492..5.233 rows=2 loops=2,176)

  • Join Filter: ((foxtrot_seven3.kilo_quebec <= alpha_echo2.kilo_quebec) AND (lima_sierra((delta_four 13), ((delta_four 14))::timestamp without time zone) >= alpha_echo2.kilo_quebec))
  • Buffers: shared hit=4396587 read=513
18. 5.293 1,553.664 ↓ 2.0 2 2,176

Nested Loop (cost=0.980..73.800 rows=1 width=13) (actual time=0.524..0.714 rows=2 loops=2,176)

  • Buffers: shared hit=158718 read=513
19. 926.976 926.976 ↓ 3.0 3 2,176

Index Scan using six_bravo on foxtrot_bravo juliet_juliet (cost=0.560..8.590 rows=1 width=23) (actual time=0.420..0.426 rows=3 loops=2,176)

  • Index Cond: (((bravo_lima)::text = (hotel_zulu.bravo_lima)::text) AND ((seven_delta_echo)::text = 'zulu_india'::text))
  • Filter: ((romeo_mike)::text = 'seven_seven'::text)
  • Rows Removed by Filter: 7
  • Buffers: shared hit=21688 read=505
20. 621.395 621.395 ↑ 1.0 1 6,541

Index Scan using quebec on xray two_kilo (cost=0.420..65.200 rows=1 width=22) (actual time=0.070..0.095 rows=1 loops=6,541)

  • Index Cond: ((kilo_uniform)::text = (oscar_mike1.zulu_golf1sierra_mike)::text)
  • Filter: ((kilo_quebec >= hotel_zulu.kilo_quebec) AND (kilo_quebec >= ('golf_lima_echo'::cstring)::date) AND (oscar_mike1.zulu_golf2tango = (golf_victor)::integer) AND (kilo_quebec <= (('golf_lima_echo'::cstring)::date + 'two_three'::interval)))
  • Rows Removed by Filter: 81
  • Buffers: shared hit=137030 read=8
21. 0.000 9.890 ↑ 11,980.0 1 4,945

Append (cost=0.000..226.610 rows=11,980 width=16) (actual time=0.002..0.002 rows=1 loops=4,945)

  • Buffers: shared hit=4945
22. 9.890 9.890 ↑ 11,890.0 1 4,945

Seq Scan on alpha_romeo six_xray (cost=0.000..215.900 rows=11,890 width=16) (actual time=0.002..0.002 rows=1 loops=4,945)

  • Buffers: shared hit=4945
23. 0.000 0.000 ↓ 0.0 0

Subquery Scan on juliet_hotel (cost=0.000..10.710 rows=90 width=16) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on four_mike oscar_papa (cost=0.000..9.810 rows=90 width=286) (never executed)

  • Filter: ((six_four)::text = 'india_tango'::text)
25.          

SubPlan (for Nested Loop Semi Join)

26. 4.945 29.670 ↓ 0.0 0 4,945

Limit (cost=8.540..8.540 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=4,945)

  • Buffers: shared hit=9893
27. 9.890 24.725 ↓ 0.0 0 4,945

Sort (cost=8.540..8.540 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=4,945)

  • Sort Key: whiskey_six6.kilo_quebec
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9893
28. 0.000 14.835 ↓ 0.0 0 4,945

Bitmap Heap Scan on four_mike alpha_papa (cost=4.290..8.530 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=4,945)

  • Recheck Cond: ((bravo_lima)::text = (foxtrot_seven3.bravo_lima)::text)
  • Filter: ((kilo_quebec > foxtrot_seven3.kilo_quebec) AND ((six_four)::text = 'hotel_november'::text))
  • Buffers: shared hit=9890
29. 14.835 14.835 ↓ 0.0 0 4,945

Bitmap Index Scan on mike (cost=0.000..4.290 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=4,945)

  • Index Cond: ((bravo_lima)::text = (foxtrot_seven3.bravo_lima)::text)
  • Buffers: shared hit=9890
30. 123.625 9,786.155 ↑ 1.0 1 4,945

Aggregate (cost=22,269.640..22,269.660 rows=1 width=4) (actual time=1.978..1.979 rows=1 loops=4,945)

  • Buffers: shared hit=4223031
31. 346.150 9,662.530 ↓ 14.2 85 4,945

Nested Loop (cost=1.410..22,269.630 rows=6 width=10) (actual time=0.436..1.954 rows=85 loops=4,945)

  • Buffers: shared hit=4223031
32. 301.645 7,536.180 ↓ 15.0 90 4,945

Nested Loop (cost=1.120..22,258.820 rows=6 width=17) (actual time=0.024..1.524 rows=90 loops=4,945)

  • Buffers: shared hit=3332930
33. 336.260 336.260 ↑ 2.3 155 4,945

Index Scan using oscar_charlie on yankee_yankee whiskey_oscar (cost=0.560..1,136.730 rows=351 width=41) (actual time=0.010..0.068 rows=155 loops=4,945)

  • Index Cond: ((bravo_lima)::text = (foxtrot_seven3.bravo_lima)::text)
  • Filter: ((romeo_romeo)::text <> november_november ('oscar_six'::text[]))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=59340
34. 6,898.275 6,898.275 ↑ 1.0 1 766,475

Index Scan using bravo_november on romeo_zulu india_romeo (cost=0.560..60.170 rows=1 width=19) (actual time=0.009..0.009 rows=1 loops=766,475)

  • Index Cond: ((golf_echo)::text = (six_foxtrot2.golf_echo)::text)
  • Filter: ((CASE WHEN ((six_foxtrot2.golf_lima_victor)::text = 'seven_delta_zulu'::text) THEN three ELSE six_foxtrot2.three END = three) AND (((lima_sierra(seven_six, 'november_golf'::numeric) * lima_sierra(oscar_seven, 'november_golf'::numeric)) - (((lima_sierra(golf_four, 'november_golf'::numeric) + lima_sierra(hotel_seven, 'november_golf'::numeric)) + lima_sierra(romeo_five, 'november_golf'::numeric)) + lima_sierra(two_quebec, 'november_golf'::numeric))) > 'november_golf'::numeric))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3273590
35. 1,780.200 1,780.200 ↑ 1.0 1 445,050

Index Only Scan using delta_sierra on zulu_five kilo_delta (cost=0.290..1.800 rows=1 width=7) (actual time=0.004..0.004 rows=1 loops=445,050)

  • Index Cond: (kilo_uniform = (six_foxtrot2.kilo_uniform)::text)
  • Heap Fetches: 0
  • Buffers: shared hit=890101
36.          

SubPlan (for Nested Loop)

37. 6.429 19.287 ↓ 0.0 0 2,143

Bitmap Heap Scan on four_mike (cost=4.290..8.530 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=2,143)

  • Recheck Cond: ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text)
  • Filter: ((kilo_quebec >= hotel_zulu.kilo_quebec) AND ((six_four)::text = 'hotel_november'::text))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=48
  • Buffers: shared hit=4346
38. 12.858 12.858 ↓ 0.0 0 2,143

Bitmap Index Scan on mike (cost=0.000..4.290 rows=2 width=0) (actual time=0.006..0.006 rows=0 loops=2,143)

  • Index Cond: ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text)
  • Buffers: shared hit=4298
39. 0.018 0.114 ↑ 1.0 1 6

Limit (cost=8.540..8.540 rows=1 width=19) (actual time=0.018..0.019 rows=1 loops=6)

  • Buffers: shared hit=18
40. 0.042 0.096 ↑ 1.0 1 6

Sort (cost=8.540..8.540 rows=1 width=19) (actual time=0.016..0.016 rows=1 loops=6)

  • Sort Key: whiskey_six1.kilo_quebec
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=18
41. 0.030 0.054 ↑ 1.0 1 6

Bitmap Heap Scan on four_mike four_india (cost=4.290..8.530 rows=1 width=19) (actual time=0.008..0.009 rows=1 loops=6)

  • Recheck Cond: ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text)
  • Filter: ((kilo_quebec >= hotel_zulu.kilo_quebec) AND ((six_four)::text = 'hotel_november'::text))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=6
  • Buffers: shared hit=18
42. 0.024 0.024 ↑ 1.0 2 6

Bitmap Index Scan on mike (cost=0.000..4.290 rows=2 width=0) (actual time=0.004..0.004 rows=2 loops=6)

  • Index Cond: ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text)
  • Buffers: shared hit=12
43. 2.137 8.548 ↓ 0.0 0 2,137

Bitmap Heap Scan on four_mike yankee_hotel (cost=4.290..8.530 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=2,137)

  • Recheck Cond: ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text)
  • Filter: ((kilo_quebec >= hotel_zulu.kilo_quebec) AND ((six_four)::text = 'golf_whiskey'::text))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=25
  • Buffers: shared hit=4311
44. 6.411 6.411 ↓ 0.0 0 2,137

Bitmap Index Scan on mike (cost=0.000..4.290 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=2,137)

  • Index Cond: ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text)
  • Buffers: shared hit=4286
45. 0.040 0.280 ↑ 1.0 1 20

Limit (cost=8.540..8.540 rows=1 width=19) (actual time=0.013..0.014 rows=1 loops=20)

  • Buffers: shared hit=77
46. 0.100 0.240 ↑ 1.0 1 20

Sort (cost=8.540..8.540 rows=1 width=19) (actual time=0.012..0.012 rows=1 loops=20)

  • Sort Key: whiskey_six3.kilo_quebec
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=77
47. 0.060 0.140 ↑ 1.0 1 20

Bitmap Heap Scan on four_mike juliet_uniform (cost=4.290..8.530 rows=1 width=19) (actual time=0.007..0.007 rows=1 loops=20)

  • Recheck Cond: ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text)
  • Filter: ((kilo_quebec >= hotel_zulu.kilo_quebec) AND ((six_four)::text = 'golf_whiskey'::text))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=37
  • Buffers: shared hit=77
48. 0.080 0.080 ↑ 1.0 2 20

Bitmap Index Scan on mike (cost=0.000..4.290 rows=2 width=0) (actual time=0.004..0.004 rows=2 loops=20)

  • Index Cond: ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text)
  • Buffers: shared hit=40
49. 619.327 1,178.650 ↑ 1.0 1 2,143

Index Only Scan using oscar_romeo on juliet_zulu golf_lima_juliet (cost=0.430..29.950 rows=1 width=32) (actual time=0.548..0.550 rows=1 loops=2,143)

  • Index Cond: (bravo_lima = (november_mike.bravo_lima)::text)
  • Heap Fetches: 0
  • Buffers: shared hit=21091 read=330
50.          

SubPlan (for Index Only Scan)

51. 559.323 559.323 ↑ 1,000.0 1 2,143

Function Scan on sierra_quebec (cost=0.250..21.500 rows=1,000 width=32) (actual time=0.261..0.261 rows=1 loops=2,143)

  • Buffers: shared hit=14939 read=5
52. 5.349 1,647.967 ↑ 2.0 1 2,143

Append (cost=0.290..44,576.460 rows=2 width=0) (actual time=0.769..0.769 rows=1 loops=2,143)

  • Buffers: shared hit=615174
53. 21.498 1,641.538 ↑ 1.0 1 2,143

Index Scan using juliet_sierra on alpha_romeo india_oscar (cost=0.290..22,286.510 rows=1 width=0) (actual time=0.766..0.766 rows=1 loops=2,143)

  • Index Cond: ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text)
  • Filter: ((kilo_quebec <= lima_echo.kilo_quebec) AND (lima_sierra((delta_four 7), ((delta_four 8))::timestamp without time zone) >= lima_echo.kilo_quebec))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=614848
54.          

SubPlan (for Index Scan)

55. 2.146 21.460 ↓ 0.0 0 2,146

Limit (cost=8.540..8.540 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=2,146)

  • Buffers: shared hit=4363
56. 8.584 19.314 ↓ 0.0 0 2,146

Sort (cost=8.540..8.540 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=2,146)

  • Sort Key: whiskey_six4.kilo_quebec
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=4363
57. 4.292 10.730 ↓ 0.0 0 2,146

Bitmap Heap Scan on four_mike alpha_november (cost=4.290..8.530 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=2,146)

  • Recheck Cond: ((bravo_lima)::text = (foxtrot_seven1.bravo_lima)::text)
  • Filter: ((kilo_quebec > foxtrot_seven1.kilo_quebec) AND ((six_four)::text = 'hotel_november'::text))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=51
  • Buffers: shared hit=4356
58. 6.438 6.438 ↓ 0.0 0 2,146

Bitmap Index Scan on mike (cost=0.000..4.290 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=2,146)

  • Index Cond: ((bravo_lima)::text = (foxtrot_seven1.bravo_lima)::text)
  • Buffers: shared hit=4305
59. 23.540 1,598.580 ↑ 1.0 1 2,140

Aggregate (cost=22,269.640..22,269.660 rows=1 width=4) (actual time=0.747..0.747 rows=1 loops=2,140)

  • Buffers: shared hit=604365
60. 20.715 1,575.040 ↓ 5.8 35 2,140

Nested Loop (cost=1.410..22,269.630 rows=6 width=10) (actual time=0.082..0.736 rows=35 loops=2,140)

  • Buffers: shared hit=604365
61. 16.982 1,162.020 ↓ 6.2 37 2,140

Nested Loop (cost=1.120..22,258.820 rows=6 width=17) (actual time=0.041..0.543 rows=37 loops=2,140)

  • Buffers: shared hit=445666
62. 87.740 87.740 ↑ 7.8 45 2,140

Index Scan using oscar_charlie on yankee_yankee five_papa (cost=0.560..1,136.730 rows=351 width=41) (actual time=0.017..0.041 rows=45 loops=2,140)

  • Index Cond: ((bravo_lima)::text = (foxtrot_seven1.bravo_lima)::text)
  • Filter: ((romeo_romeo)::text <> november_november ('oscar_six'::text[]))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=29925
63. 1,057.298 1,057.298 ↑ 1.0 1 96,118

Index Scan using bravo_november on romeo_zulu six_three (cost=0.560..60.170 rows=1 width=19) (actual time=0.010..0.011 rows=1 loops=96,118)

  • Index Cond: ((golf_echo)::text = (five_papa.golf_echo)::text)
  • Filter: ((CASE WHEN ((five_papa.golf_lima_victor)::text = 'seven_delta_zulu'::text) THEN three ELSE five_papa.three END = three) AND (((lima_sierra(seven_six, 'november_golf'::numeric) * lima_sierra(oscar_seven, 'november_golf'::numeric)) - (((lima_sierra(golf_four, 'november_golf'::numeric) + lima_sierra(hotel_seven, 'november_golf'::numeric)) + lima_sierra(romeo_five, 'november_golf'::numeric)) + lima_sierra(two_quebec, 'november_golf'::numeric))) > 'november_golf'::numeric))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=415741
64. 392.305 392.305 ↑ 1.0 1 78,461

Index Only Scan using delta_sierra on zulu_five alpha_seven (cost=0.290..1.800 rows=1 width=7) (actual time=0.005..0.005 rows=1 loops=78,461)

  • Index Cond: (kilo_uniform = (five_papa.kilo_uniform)::text)
  • Heap Fetches: 739
  • Buffers: shared hit=158699
65. 0.957 1.080 ↑ 1.0 1 3

Subquery Scan on echo (cost=0.000..22,289.950 rows=1 width=0) (actual time=0.360..0.360 rows=1 loops=3)

  • Filter: (lima_sierra((delta_four 7), ((delta_four 8))::timestamp without time zone) >= lima_echo.kilo_quebec)
  • Buffers: shared hit=326
66. 0.123 0.123 ↑ 1.0 1 3

Seq Scan on four_mike delta_whiskey (cost=0.000..11.740 rows=1 width=286) (actual time=0.041..0.041 rows=1 loops=3)

  • Filter: ((kilo_quebec <= lima_echo.kilo_quebec) AND ((six_four)::text = 'india_tango'::text) AND ((bravo_lima)::text = (hotel_zulu.bravo_lima)::text))
  • Rows Removed by Filter: 216
  • Buffers: shared hit=8
67. 6.429 10,768.575 ↑ 1.0 1 2,143

Aggregate (cost=266,893,337.680..266,893,337.690 rows=1 width=32) (actual time=5.025..5.025 rows=1 loops=2,143)

  • Buffers: shared hit=4396700
68. 15.942 10,762.146 ↓ 2.0 2 2,143

Nested Loop Semi Join (cost=0.980..266,893,337.680 rows=1 width=5) (actual time=2.191..5.022 rows=2 loops=2,143)

  • Join Filter: ((foxtrot_seven2.kilo_quebec <= alpha_echo1.kilo_quebec) AND (lima_sierra((delta_four 10), ((delta_four 11))::timestamp without time zone) >= alpha_echo1.kilo_quebec))
  • Buffers: shared hit=4396700
69. 10.198 767.194 ↓ 2.0 2 2,143

Nested Loop (cost=0.980..73.800 rows=1 width=13) (actual time=0.141..0.358 rows=2 loops=2,143)

  • Buffers: shared hit=158834
70. 51.432 51.432 ↓ 3.0 3 2,143

Index Scan using six_bravo on foxtrot_bravo kilo_foxtrot (cost=0.560..8.590 rows=1 width=23) (actual time=0.018..0.024 rows=3 loops=2,143)

  • Index Cond: (((bravo_lima)::text = (hotel_zulu.bravo_lima)::text) AND ((seven_delta_echo)::text = 'zulu_india'::text))
  • Filter: ((romeo_mike)::text = 'seven_seven'::text)
  • Rows Removed by Filter: 7
  • Buffers: shared hit=21970
71. 705.564 705.564 ↑ 1.0 1 6,533

Index Scan using quebec on xray kilo_bravo (cost=0.420..65.200 rows=1 width=22) (actual time=0.079..0.108 rows=1 loops=6,533)

  • Index Cond: ((kilo_uniform)::text = (kilo_foxtrot.zulu_golf1sierra_mike)::text)
  • Filter: ((kilo_quebec >= hotel_zulu.kilo_quebec) AND (kilo_quebec >= ('golf_lima_echo'::cstring)::date) AND (kilo_foxtrot.zulu_golf2tango = (golf_victor)::integer) AND (kilo_quebec <= (('golf_lima_echo'::cstring)::date + 'two_three'::interval)))
  • Rows Removed by Filter: 81
  • Buffers: shared hit=136864
72. 4.945 14.835 ↑ 11,980.0 1 4,945

Append (cost=0.000..226.610 rows=11,980 width=16) (actual time=0.003..0.003 rows=1 loops=4,945)

  • Buffers: shared hit=4945
73. 9.890 9.890 ↑ 11,890.0 1 4,945

Seq Scan on alpha_romeo whiskey_three (cost=0.000..215.900 rows=11,890 width=16) (actual time=0.002..0.002 rows=1 loops=4,945)

  • Buffers: shared hit=4945
74. 0.000 0.000 ↓ 0.0 0

Subquery Scan on bravo_alpha (cost=0.000..10.710 rows=90 width=16) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Seq Scan on four_mike bravo_oscar (cost=0.000..9.810 rows=90 width=286) (never executed)

  • Filter: ((six_four)::text = 'india_tango'::text)
76.          

SubPlan (for Nested Loop Semi Join)

77. 4.945 34.615 ↓ 0.0 0 4,945

Limit (cost=8.540..8.540 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=4,945)

  • Buffers: shared hit=9890
78. 9.890 29.670 ↓ 0.0 0 4,945

Sort (cost=8.540..8.540 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=4,945)

  • Sort Key: whiskey_six5.kilo_quebec
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=9890
79. 4.945 19.780 ↓ 0.0 0 4,945

Bitmap Heap Scan on four_mike delta_oscar (cost=4.290..8.530 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=4,945)

  • Recheck Cond: ((bravo_lima)::text = (foxtrot_seven2.bravo_lima)::text)
  • Filter: ((kilo_quebec > foxtrot_seven2.kilo_quebec) AND ((six_four)::text = 'hotel_november'::text))
  • Buffers: shared hit=9890
80. 14.835 14.835 ↓ 0.0 0 4,945

Bitmap Index Scan on mike (cost=0.000..4.290 rows=2 width=0) (actual time=0.003..0.003 rows=0 loops=4,945)

  • Index Cond: ((bravo_lima)::text = (foxtrot_seven2.bravo_lima)::text)
  • Buffers: shared hit=9890
81. 123.625 9,929.560 ↑ 1.0 1 4,945

Aggregate (cost=22,269.640..22,269.660 rows=1 width=4) (actual time=2.008..2.008 rows=1 loops=4,945)

  • Buffers: shared hit=4223031
82. 430.215 9,805.935 ↓ 14.2 85 4,945

Nested Loop (cost=1.410..22,269.630 rows=6 width=10) (actual time=0.448..1.983 rows=85 loops=4,945)

  • Buffers: shared hit=4223031
83. 331.315 7,595.520 ↓ 15.0 90 4,945

Nested Loop (cost=1.120..22,258.820 rows=6 width=17) (actual time=0.028..1.536 rows=90 loops=4,945)

  • Buffers: shared hit=3332930
84. 365.930 365.930 ↑ 2.3 155 4,945

Index Scan using oscar_charlie on yankee_yankee sierra_lima (cost=0.560..1,136.730 rows=351 width=41) (actual time=0.012..0.074 rows=155 loops=4,945)

  • Index Cond: ((bravo_lima)::text = (foxtrot_seven2.bravo_lima)::text)
  • Filter: ((romeo_romeo)::text <> november_november ('oscar_six'::text[]))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=59340
85. 6,898.275 6,898.275 ↑ 1.0 1 766,475

Index Scan using bravo_november on romeo_zulu oscar_three (cost=0.560..60.170 rows=1 width=19) (actual time=0.009..0.009 rows=1 loops=766,475)

  • Index Cond: ((golf_echo)::text = (six_foxtrot1.golf_echo)::text)
  • Filter: ((CASE WHEN ((six_foxtrot1.golf_lima_victor)::text = 'seven_delta_zulu'::text) THEN three ELSE six_foxtrot1.three END = three) AND (((lima_sierra(seven_six, 'november_golf'::numeric) * lima_sierra(oscar_seven, 'november_golf'::numeric)) - (((lima_sierra(golf_four, 'november_golf'::numeric) + lima_sierra(hotel_seven, 'november_golf'::numeric)) + lima_sierra(romeo_five, 'november_golf'::numeric)) + lima_sierra(two_quebec, 'november_golf'::numeric))) > 'november_golf'::numeric))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3273590
86. 1,780.200 1,780.200 ↑ 1.0 1 445,050

Index Only Scan using delta_sierra on zulu_five uniform_charlie (cost=0.290..1.800 rows=1 width=7) (actual time=0.004..0.004 rows=1 loops=445,050)

  • Index Cond: (kilo_uniform = (six_foxtrot1.kilo_uniform)::text)
  • Heap Fetches: 0
  • Buffers: shared hit=890101