explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XF5

Settings
# exclusive inclusive rows x rows loops node
1. 3.847 79.231 ↓ 6.6 2,999 1

Nested Loop (cost=12.620..42,648.640 rows=453 width=279) (actual time=0.790..79.231 rows=2,999 loops=1)

2. 0.340 0.414 ↓ 210.0 210 1

Bitmap Heap Scan on xray_yankee alpha_seven (cost=3.340..4.480 rows=1 width=263) (actual time=0.085..0.414 rows=210 loops=1)

  • Recheck Cond: (((kilo_tango = 'india_three'::text) AND (tango_foxtrot_papa >= (zulu_golf() - 'two_oscar'::interval)) AND (tango_foxtrot_papa <= zulu_golf())) OR ((kilo_tango = 'india_three'::text) AND (four_charlie_india >= (zulu_golf() - 'two_oscar'::interval)) AND (four_charlie_india <= zulu_golf())))
  • Filter: (((tango_foxtrot_papa >= (zulu_golf() - 'two_oscar'::interval)) AND (tango_foxtrot_papa <= zulu_golf())) OR ((four_charlie_india >= (zulu_golf() - 'two_oscar'::interval)) AND (four_charlie_india <= zulu_golf()) AND (tango_foxtrot_papa five_romeo_foxtrot NULL)))
  • Heap Blocks: exact=55
3. 0.002 0.074 ↓ 0.0 0 1

BitmapOr (cost=3.340..3.340 rows=1 width=0) (actual time=0.073..0.074 rows=0 loops=1)

4. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on zulu_kilo (cost=0.000..1.550 rows=1 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((kilo_tango = 'india_three'::text) AND (tango_foxtrot_papa >= (zulu_golf() - 'two_oscar'::interval)) AND (tango_foxtrot_papa <= zulu_golf()))
5. 0.057 0.057 ↓ 210.0 210 1

Bitmap Index Scan on echo_bravo (cost=0.000..1.800 rows=1 width=0) (actual time=0.057..0.057 rows=210 loops=1)

  • Index Cond: ((kilo_tango = 'india_three'::text) AND (four_charlie_india >= (zulu_golf() - 'two_oscar'::interval)) AND (four_charlie_india <= zulu_golf()))
6. 23.100 74.970 ↑ 2,531.6 14 210

Append (cost=9.270..42,289.740 rows=35,442 width=20) (actual time=0.330..0.357 rows=14 loops=210)

7. 0.210 0.840 ↓ 0.0 0 210

Bitmap Heap Scan on quebec_zulu november_mike_golf (cost=9.270..633.400 rows=528 width=20) (actual time=0.004..0.004 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
8. 0.630 0.630 ↓ 0.0 0 210

Bitmap Index Scan on sierra_uniform_three (cost=0.000..9.140 rows=575 width=0) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
9. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on two_yankee echo_yankee (cost=9.660..686.120 rows=573 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
10. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on charlie_three (cost=0.000..9.520 rows=625 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
11. 0.420 0.420 ↓ 0.0 0 210

Index Scan using two_golf on alpha_uniform_foxtrot yankee_bravo_alpha (cost=0.430..433.820 rows=352 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
12. 0.420 0.420 ↓ 0.0 0 210

Index Scan using delta_zulu_six on hotel_yankee two_kilo (cost=0.430..378.790 rows=305 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
13. 0.420 0.420 ↓ 0.0 0 210

Index Scan using tango_tango on papa_romeo whiskey_victor (cost=0.430..409.770 rows=325 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
14. 0.420 0.420 ↓ 0.0 0 210

Index Scan using papa_hotel on zulu_five three_lima (cost=0.430..338.740 rows=263 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
15. 0.420 0.420 ↓ 0.0 0 210

Index Scan using seven_mike on november_quebec five_november (cost=0.430..415.440 rows=332 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
16. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on three_mike whiskey_juliet (cost=9.280..636.440 rows=522 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
17. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on whiskey_foxtrot (cost=0.000..9.150 rows=576 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
18. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on oscar_bravo yankee_kilo (cost=11.290..763.940 rows=632 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
19. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on two_november_whiskey (cost=0.000..11.130 rows=694 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
20. 0.630 0.630 ↓ 0.0 0 210

Index Scan using oscar_four on quebec_mike four_charlie_romeo (cost=0.430..480.380 rows=385 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
21. 0.420 0.420 ↓ 0.0 0 210

Index Scan using yankee_alpha on kilo_lima oscar_whiskey (cost=0.430..397.480 rows=312 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
22. 0.420 0.420 ↓ 0.0 0 210

Index Scan using oscar_charlie on tango_three oscar_seven (cost=0.430..362.170 rows=277 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
23. 0.420 0.420 ↓ 0.0 0 210

Index Scan using juliet_quebec on tango_foxtrot_romeo golf_delta_charlie (cost=0.430..379.780 rows=304 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
24. 0.420 0.420 ↓ 0.0 0 210

Index Scan using six_three on sierra_kilo romeo_four_two (cost=0.430..401.700 rows=321 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
25. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on whiskey_hotel six_charlie_xray (cost=9.130..615.640 rows=519 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
26. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on three_foxtrot (cost=0.000..9.000 rows=556 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
27. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on whiskey_charlie zulu_whiskey (cost=9.240..630.860 rows=528 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
28. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on golf_sierra_three (cost=0.000..9.110 rows=571 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
29. 0.420 0.420 ↓ 0.0 0 210

Index Scan using three_whiskey on golf_echo foxtrot_four (cost=0.430..503.110 rows=408 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
30. 0.420 0.420 ↓ 0.0 0 210

Index Scan using romeo_bravo on november_lima lima_hotel (cost=0.430..413.430 rows=332 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
31. 0.420 0.420 ↓ 0.0 0 210

Index Scan using golf_uniform_sierra on uniform_quebec_charlie sierra_golf (cost=0.430..409.220 rows=346 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
32. 0.420 0.420 ↓ 0.0 0 210

Index Scan using sierra_uniform_uniform on bravo_oscar hotel_six (cost=0.430..334.750 rows=268 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
33. 0.420 0.420 ↓ 0.0 0 210

Index Scan using delta_alpha on mike_whiskey alpha_india (cost=0.430..367.350 rows=287 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
34. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on whiskey_three victor_papa_three (cost=7.660..561.960 rows=467 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
35. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on uniform_sierra (cost=0.000..7.550 rows=509 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
36. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on sierra_hotel lima_bravo (cost=9.130..612.470 rows=511 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
37. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on seven_seven (cost=0.000..9.000 rows=556 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
38. 0.420 0.420 ↓ 0.0 0 210

Index Scan using golf_hotel on juliet_november kilo_two (cost=0.430..422.020 rows=346 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
39. 0.420 0.420 ↓ 0.0 0 210

Index Scan using golf_four on whiskey_alpha alpha_three (cost=0.430..362.130 rows=291 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
40. 0.420 0.420 ↓ 0.0 0 210

Index Scan using foxtrot_delta on kilo_golf victor_delta (cost=0.430..359.780 rows=285 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
41. 0.420 0.420 ↓ 0.0 0 210

Index Scan using yankee_quebec on papa_two papa_lima (cost=0.430..414.030 rows=335 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
42. 0.420 0.420 ↓ 0.0 0 210

Index Scan using six_mike_bravo on zulu_india_alpha five_seven_papa (cost=0.430..431.270 rows=365 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
43. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on alpha_golf tango_romeo (cost=9.160..617.400 rows=539 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
44. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on bravo_juliet_oscar (cost=0.000..9.020 rows=559 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
45. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on whiskey_delta kilo_november_victor (cost=7.660..559.220 rows=485 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
46. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on uniform_seven (cost=0.000..7.540 rows=508 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
47. 0.420 0.420 ↓ 0.0 0 210

Index Scan using five_two on xray_victor echo_oscar (cost=0.430..449.410 rows=383 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
48. 0.420 0.420 ↓ 0.0 0 210

Index Scan using delta_echo on delta_juliet_lima papa_india (cost=0.430..281.570 rows=230 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
49. 0.420 0.420 ↓ 0.0 0 210

Index Scan using five_sierra on six_kilo five_three (cost=0.430..295.890 rows=232 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
50. 0.420 0.420 ↓ 0.0 0 210

Index Scan using november_bravo on tango_echo_kilo foxtrot_six (cost=0.430..298.450 rows=242 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
51. 0.420 0.420 ↓ 0.0 0 210

Index Scan using quebec_sierra on golf_delta_victor oscar_golf_mike (cost=0.430..273.600 rows=224 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
52. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on papa_kilo xray_three (cost=6.590..409.140 rows=338 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
53. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on oscar_golf_three (cost=0.000..6.500 rows=370 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
54. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on zulu_india_uniform tango_charlie (cost=8.950..583.470 rows=494 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
55. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on four_xray (cost=0.000..8.830 rows=533 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
56. 0.420 0.420 ↓ 0.0 0 210

Index Scan using foxtrot_alpha on romeo_november foxtrot_five_zulu (cost=0.430..384.830 rows=315 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
57. 0.420 0.420 ↓ 0.0 0 210

Index Scan using quebec_uniform on victor_romeo juliet_papa (cost=0.430..333.660 rows=273 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
58. 0.420 0.420 ↓ 0.0 0 210

Index Scan using six_golf_papa on four_yankee zulu_alpha_alpha_delta (cost=0.430..345.350 rows=282 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
59. 0.420 0.420 ↓ 0.0 0 210

Index Scan using mike_romeo on three_three papa_oscar (cost=0.430..358.410 rows=291 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
60. 0.420 0.420 ↓ 0.0 0 210

Index Scan using charlie_kilo on golf_sierra_charlie four_golf (cost=0.430..426.000 rows=333 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
61. 0.420 0.420 ↓ 0.0 0 210

Index Scan using zulu_tango on romeo_kilo_tango victor_quebec (cost=0.430..597.720 rows=475 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
62. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on romeo_three delta_delta (cost=9.920..725.950 rows=617 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
63. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on romeo_kilo_november (cost=0.000..9.770 rows=658 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
64. 0.420 0.420 ↓ 0.0 0 210

Index Scan using foxtrot_kilo_whiskey on victor_three delta_oscar (cost=0.430..431.620 rows=361 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
65. 0.420 0.420 ↓ 0.0 0 210

Index Scan using five_romeo_romeo on juliet_sierra xray_two (cost=0.430..394.020 rows=330 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
66. 0.420 0.420 ↓ 0.0 0 210

Index Scan using papa_charlie on xray_foxtrot quebec_lima (cost=0.430..335.720 rows=283 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
67. 0.420 0.420 ↓ 0.0 0 210

Index Scan using five_mike on mike_india november_xray (cost=0.430..260.350 rows=228 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
68. 0.420 0.420 ↓ 0.0 0 210

Index Scan using seven_zulu on seven_oscar kilo_india (cost=0.430..323.450 rows=275 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
69. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on kilo_november_five two_three (cost=5.260..376.040 rows=324 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
70. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on india_kilo (cost=0.000..5.180 rows=340 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
71. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on november_uniform papa_echo_echo (cost=7.730..566.200 rows=498 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
72. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on delta_charlie (cost=0.000..7.610 rows=517 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
73. 0.420 0.420 ↓ 0.0 0 210

Index Scan using four_zulu on golf_xray_two november_mike_five (cost=0.430..261.390 rows=223 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
74. 0.420 0.420 ↓ 0.0 0 210

Index Scan using yankee_lima on lima_lima alpha_uniform_tango (cost=0.430..226.380 rows=188 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
75. 0.630 0.630 ↓ 0.0 0 210

Index Scan using uniform_victor on six_seven_echo whiskey_whiskey (cost=0.430..234.230 rows=185 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
76. 0.420 0.420 ↓ 0.0 0 210

Index Scan using six_seven_xray on lima_six juliet_romeo_romeo (cost=0.430..285.390 rows=240 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
77. 0.420 0.420 ↓ 0.0 0 210

Index Scan using uniform_oscar on delta_zulu_foxtrot charlie_bravo (cost=0.430..359.940 rows=289 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
78. 0.420 0.420 ↓ 0.0 0 210

Index Scan using foxtrot_golf on november_oscar delta_five (cost=0.430..446.190 rows=361 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
79. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on tango_echo_six bravo_xray (cost=7.410..525.500 rows=432 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
80. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on seven_yankee (cost=0.000..7.300 rows=476 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
81. 0.420 0.420 ↓ 0.0 0 210

Index Scan using five_juliet on india_mike kilo_november_bravo (cost=0.430..296.470 rows=239 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
82. 0.420 0.420 ↓ 0.0 0 210

Index Scan using lima_echo on romeo_lima mike_lima (cost=0.430..284.700 rows=230 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
83. 0.420 0.420 ↓ 0.0 0 210

Index Scan using charlie_xray on xray_zulu golf_juliet (cost=0.430..343.730 rows=266 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
84. 0.420 0.420 ↓ 0.0 0 210

Index Scan using alpha_zulu on four_tango six_golf_xray (cost=0.430..273.580 rows=230 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
85. 0.420 0.420 ↓ 0.0 0 210

Index Scan using golf_india on papa_yankee tango_zulu (cost=0.430..260.900 rows=221 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
86. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on four_mike november_delta (cost=7.340..514.640 rows=450 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
87. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on golf_five (cost=0.000..7.220 rows=466 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
88. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on foxtrot_quebec golf_xray_yankee (cost=9.590..674.980 rows=604 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
89. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on xray_india (cost=0.000..9.440 rows=615 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
90. 0.420 0.420 ↓ 0.0 0 210

Index Scan using papa_delta_zulu on six_mike_romeo five_hotel (cost=0.430..283.880 rows=244 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
91. 0.420 0.420 ↓ 0.0 0 210

Index Scan using golf_quebec on delta_quebec bravo_yankee (cost=0.430..302.010 rows=264 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
92. 0.420 0.420 ↓ 0.0 0 210

Index Scan using delta_sierra_juliet on mike_bravo zulu_two (cost=0.430..207.600 rows=190 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
93. 0.420 0.420 ↓ 0.0 0 210

Index Scan using hotel_two on november_juliet three_victor (cost=0.430..288.050 rows=249 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
94. 0.420 0.420 ↓ 0.0 0 210

Index Scan using four_delta on whiskey_golf tango_xray (cost=0.430..282.500 rows=232 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
95. 0.420 0.420 ↓ 0.0 0 210

Index Scan using juliet_hotel on xray_hotel india_lima (cost=0.430..424.870 rows=334 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
96. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on november_three zulu_alpha_alpha_whiskey (cost=8.950..587.150 rows=502 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
97. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on delta_sierra_romeo (cost=0.000..8.820 rows=532 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
98. 0.420 0.420 ↓ 0.0 0 210

Index Scan using delta_hotel on echo_india bravo_romeo (cost=0.430..389.900 rows=314 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
99. 0.420 0.420 ↓ 0.0 0 210

Index Scan using foxtrot_five_delta on india_two uniform_quebec_oscar (cost=0.430..249.930 rows=178 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
100. 0.420 0.420 ↓ 0.0 0 210

Index Scan using four_three on victor_juliet golf_alpha (cost=0.430..276.350 rows=233 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
101. 0.420 0.420 ↓ 0.0 0 210

Index Scan using mike_quebec on kilo_oscar uniform_yankee (cost=0.430..298.440 rows=252 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
102. 0.420 0.420 ↓ 0.0 0 210

Index Scan using kilo_foxtrot on victor_victor golf_uniform_bravo (cost=0.430..422.800 rows=362 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
103. 0.630 0.630 ↓ 0.0 0 210

Index Scan using mike_yankee on papa_delta_golf juliet_delta (cost=0.430..449.290 rows=390 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
104. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on five_seven_oscar two_alpha (cost=7.710..566.380 rows=501 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
105. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on lima_juliet (cost=0.000..7.580 rows=514 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
106. 0.420 0.420 ↓ 0.0 0 210

Index Scan using charlie_mike_zulu on whiskey_oscar_foxtrot charlie_mike_papa (cost=0.430..480.130 rows=417 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
107. 0.420 0.420 ↓ 0.0 0 210

Index Scan using hotel_sierra on five_quebec delta_kilo (cost=0.430..440.240 rows=359 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
108. 0.420 0.420 ↓ 0.0 0 210

Index Scan using juliet_romeo_lima on victor_papa_romeo uniform_india (cost=0.430..561.490 rows=487 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
109. 0.420 0.420 ↓ 0.0 0 210

Index Scan using victor_tango on yankee_bravo_seven foxtrot_kilo_four (cost=0.430..542.490 rows=470 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
110. 0.420 0.420 ↓ 0.0 0 210

Index Scan using two_victor on victor_kilo xray_xray (cost=0.430..510.020 rows=443 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
111. 0.420 0.420 ↓ 0.0 0 210

Index Scan using hotel_kilo on six_charlie_mike lima_four (cost=0.430..636.480 rows=557 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
112. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on six_oscar foxtrot_mike (cost=9.640..686.580 rows=607 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
113. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on mike_two (cost=0.000..9.490 rows=621 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
114. 0.420 0.420 ↓ 0.0 0 210

Index Scan using two_november_sierra on golf_uniform_five whiskey_bravo (cost=0.430..525.590 rows=458 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
115. 0.420 0.420 ↓ 0.0 0 210

Index Scan using sierra_five on hotel_delta victor_bravo (cost=0.430..562.660 rows=496 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
116. 0.420 0.420 ↓ 0.0 0 210

Index Scan using romeo_oscar_zulu on yankee_sierra victor_two (cost=0.430..694.750 rows=615 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
117. 0.630 0.630 ↓ 0.0 0 210

Index Scan using oscar_oscar on juliet_juliet mike_golf (cost=0.430..490.960 rows=430 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
118. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on hotel_four whiskey_xray (cost=6.980..465.010 rows=410 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
119. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on alpha_alpha (cost=0.000..6.880 rows=420 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
120. 0.210 0.630 ↓ 0.0 0 210

Bitmap Heap Scan on bravo_whiskey romeo_juliet (cost=9.560..671.740 rows=601 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
121. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on alpha_november (cost=0.000..9.410 rows=611 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
122. 0.420 0.840 ↓ 0.0 0 210

Bitmap Heap Scan on tango_juliet whiskey_oscar_delta (cost=7.570..547.670 rows=486 width=20) (actual time=0.004..0.004 rows=0 loops=210)

  • Recheck Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
123. 0.420 0.420 ↓ 0.0 0 210

Bitmap Index Scan on romeo_oscar_echo (cost=0.000..7.450 rows=496 width=0) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
124. 0.420 0.420 ↓ 0.0 0 210

Index Scan using india_november on delta_juliet_papa romeo_four_quebec (cost=0.430..250.930 rows=212 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
125. 0.420 0.420 ↓ 0.0 0 210

Index Scan using mike_four on xray_uniform hotel_uniform (cost=0.430..324.030 rows=274 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
126. 0.630 0.630 ↓ 0.0 0 210

Index Scan using zulu_india_oscar on yankee_seven foxtrot_india (cost=0.430..382.130 rows=333 width=20) (actual time=0.003..0.003 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
127. 0.420 0.420 ↓ 0.0 0 210

Index Scan using zulu_three on bravo_juliet_india mike_six (cost=0.430..313.630 rows=269 width=20) (actual time=0.002..0.002 rows=0 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
128. 4.620 4.620 ↑ 24.6 14 210

Index Scan using papa_echo_foxtrot on uniform_whiskey uniform_delta (cost=0.430..402.610 rows=344 width=20) (actual time=0.006..0.022 rows=14 loops=210)

  • Index Cond: (yankee_delta = alpha_seven.quebec_seven)
  • Filter: (six_mike_victor > 'november_golf'::double precision)
Planning time : 6.088 ms
Execution time : 80.986 ms