explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P8Jc

Settings
# exclusive inclusive rows x rows loops node
1. 226.015 477,184.068 ↑ 1.1 5,449 1

Hash Left Join (cost=2.080..5,266,888.370 rows=5,758 width=3,016) (actual time=208.450..477,184.068 rows=5,449 loops=1)

  • Output: (three_delta: delta_four 1 or mike_mike delta_four 2), (three_delta: delta_four 3 or mike_mike delta_four 4), (delta_four 5), (delta_four 6), (delta_four 7), lima_lima_echo.quebec_seven, lima_lima_echo.november, lima_lima_echo.juliet_charlie, lima_lima_echo.tango_victor, lima_lima_echo.hotel_lima, lima_lima_echo.oscar_bravo, lima_lima_echo.oscar_golf, lima_lima_echo.juliet_whiskey, lima_lima_echo.delta_echo, lima_lima_echo.alpha_charlie, lima_lima_echo.alpha_delta, lima_lima_echo.charlie_hotel, lima_lima_echo.victor_india, lima_lima_echo.lima_india, lima_lima_echo.victor_sierra, lima_lima_echo.foxtrot_uniform, (delta_four 8), (delta_four 9), (delta_four 10), (delta_four 11), (delta_four 12), (delta_four 13), papa_whiskey1.quebec_seven, papa_whiskey1.november, papa_whiskey1.juliet_charlie, papa_whiskey1.oscar_golf, papa_whiskey1.juliet_whiskey, papa_whiskey1.tango_victor, papa_whiskey1.alpha_charlie, papa_whiskey1.delta_echo, papa_whiskey1.alpha_delta, papa_whiskey1.charlie_hotel, papa_whiskey1.six_hotel, papa_whiskey1.two_xray, papa_whiskey1.lima_india, papa_whiskey1.victor_sierra, golf_echo1.quebec_seven, golf_echo1.november, golf_echo1.sierra_sierra
  • Hash Cond: (lima_lima_echo.oscar_bravo = golf_echo1.quebec_seven)
2. 25.663 43.456 ↑ 1.1 5,449 1

Nested Loop Left Join (cost=0.850..4,243.880 rows=5,758 width=2,996) (actual time=0.163..43.456 rows=5,449 loops=1)

  • Output: lima_lima_echo.quebec_seven, lima_lima_echo.november, lima_lima_echo.juliet_charlie, lima_lima_echo.tango_victor, lima_lima_echo.hotel_lima, lima_lima_echo.oscar_bravo, lima_lima_echo.oscar_golf, lima_lima_echo.juliet_whiskey, lima_lima_echo.delta_echo, lima_lima_echo.alpha_charlie, lima_lima_echo.alpha_delta, lima_lima_echo.charlie_hotel, lima_lima_echo.victor_india, lima_lima_echo.lima_india, lima_lima_echo.victor_sierra, lima_lima_echo.foxtrot_uniform, papa_whiskey1.quebec_seven, papa_whiskey1.november, papa_whiskey1.juliet_charlie, papa_whiskey1.oscar_golf, papa_whiskey1.juliet_whiskey, papa_whiskey1.tango_victor, papa_whiskey1.alpha_charlie, papa_whiskey1.delta_echo, papa_whiskey1.alpha_delta, papa_whiskey1.charlie_hotel, papa_whiskey1.six_hotel, papa_whiskey1.two_xray, papa_whiskey1.lima_india, papa_whiskey1.victor_sierra
  • Join Filter: (papa_whiskey1.quebec_seven = lima_lima_echo.foxtrot_uniform)
3. 12.344 12.344 ↑ 1.1 5,449 1

Index Scan using oscar_three on zulu_quebec (cost=0.430..4,154.060 rows=5,758 width=1,395) (actual time=0.081..12.344 rows=5,449 loops=1)

  • Output: lima_lima_echo.quebec_seven, lima_lima_echo.november, lima_lima_echo.juliet_charlie, lima_lima_echo.tango_victor, lima_lima_echo.hotel_lima, lima_lima_echo.delta_echo, lima_lima_echo.charlie_hotel, lima_lima_echo.alpha_delta, lima_lima_echo.juliet_whiskey, lima_lima_echo.foxtrot_uniform, lima_lima_echo.oscar_golf, lima_lima_echo.alpha_charlie, lima_lima_echo.oscar_bravo, lima_lima_echo.victor_india, lima_lima_echo.victor_sierra, lima_lima_echo.lima_india
  • Index Cond: (lima_lima_echo.foxtrot_uniform = 3464723)
4. 5.374 5.449 ↑ 1.0 1 5,449

Materialize (cost=0.430..3.450 rows=1 width=1,601) (actual time=0.000..0.001 rows=1 loops=5,449)

  • Output: papa_whiskey1.quebec_seven, papa_whiskey1.november, papa_whiskey1.juliet_charlie, papa_whiskey1.oscar_golf, papa_whiskey1.juliet_whiskey, papa_whiskey1.tango_victor, papa_whiskey1.alpha_charlie, papa_whiskey1.delta_echo, papa_whiskey1.alpha_delta, papa_whiskey1.charlie_hotel, papa_whiskey1.six_hotel, papa_whiskey1.two_xray, papa_whiskey1.lima_india, papa_whiskey1.victor_sierra
5. 0.075 0.075 ↑ 1.0 1 1

Index Scan using lima_mike on sierra_papa victor_golf (cost=0.430..3.450 rows=1 width=1,601) (actual time=0.074..0.075 rows=1 loops=1)

  • Output: papa_whiskey1.quebec_seven, papa_whiskey1.november, papa_whiskey1.juliet_charlie, papa_whiskey1.oscar_golf, papa_whiskey1.juliet_whiskey, papa_whiskey1.tango_victor, papa_whiskey1.alpha_charlie, papa_whiskey1.delta_echo, papa_whiskey1.alpha_delta, papa_whiskey1.charlie_hotel, papa_whiskey1.six_hotel, papa_whiskey1.two_xray, papa_whiskey1.lima_india, papa_whiskey1.victor_sierra
  • Index Cond: (papa_whiskey1.quebec_seven = 3464723)
6. 0.006 0.007 ↑ 1.0 10 1

Hash (cost=1.100..1.100 rows=10 width=20) (actual time=0.007..0.007 rows=10 loops=1)

  • Output: golf_echo1.quebec_seven, golf_echo1.november, golf_echo1.sierra_sierra
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.001 0.001 ↑ 1.0 10 1

Seq Scan on romeo_three xray (cost=0.000..1.100 rows=10 width=20) (actual time=0.001..0.001 rows=10 loops=1)

  • Output: golf_echo1.quebec_seven, golf_echo1.november, golf_echo1.sierra_sierra
8.          

SubPlan (forHash Left Join)

9. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on delta_hotel (cost=7.920..9.430 rows=1 width=0) (never executed)

  • Recheck Cond: ((foxtrot_three.kilo_uniform_hotel = lima_lima_echo.quebec_seven) AND ((foxtrot_three.juliet_charlie)::text = 'alpha_whiskey'::text))
10. 0.000 0.000 ↓ 0.0 0

BitmapAnd (cost=7.920..7.920 rows=1 width=0) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on charlie_papa (cost=0.000..1.990 rows=7 width=0) (never executed)

  • Index Cond: (foxtrot_three.kilo_uniform_hotel = lima_lima_echo.quebec_seven)
12. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uniform_five (cost=0.000..5.680 rows=300 width=0) (never executed)

  • Index Cond: ((foxtrot_three.juliet_charlie)::text = 'alpha_whiskey'::text)
13. 6.215 6.215 ↑ 5.7 53 1

Index Scan using uniform_five on delta_hotel papa_charlie (cost=0.430..45.760 rows=300 width=4) (actual time=0.080..6.215 rows=53 loops=1)

  • Output: three_six1.kilo_uniform_hotel
  • Index Cond: ((three_six1.juliet_charlie)::text = 'alpha_whiskey'::text)
14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.570..244.100 rows=1 width=0) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.000..151.150 rows=39 width=4) (never executed)

  • Output: zulu_november.quebec_seven
16. 0.000 0.000 ↓ 0.0 0

Index Scan using bravo_quebec on sierra_romeo (cost=0.430..4.480 rows=3 width=4) (never executed)

  • Output: seven.quebec_seven, seven.charlie_alpha, seven.november, seven.echo, seven.kilo_uniform_hotel
  • Index Cond: (seven.kilo_uniform_hotel = lima_lima_echo.quebec_seven)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using whiskey_five on two_oscar (cost=0.570..48.230 rows=66 width=8) (never executed)

  • Output: zulu_november.quebec_seven, zulu_november.charlie_alpha, zulu_november.tango_victor, zulu_november.golf_whiskey, zulu_november.victor_hotel, zulu_november.sierra_juliet, zulu_november.romeo_kilo, zulu_november.juliet_charlie
  • Index Cond: (zulu_november.victor_hotel = seven.quebec_seven)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using quebec_three on mike_juliet (cost=0.570..2.370 rows=1 width=4) (never executed)

  • Output: bravo_foxtrot.juliet_romeo_quebec
  • Index Cond: (bravo_foxtrot.juliet_romeo_quebec = zulu_november.quebec_seven)
  • Filter: ((bravo_foxtrot.whiskey_echo)::text = ANY ('mike_charlie'::text[]))
19. 0.231 77.283 ↑ 30.2 872 1

Nested Loop (cost=1.570..115,143.520 rows=26,309 width=4) (actual time=0.168..77.283 rows=872 loops=1)

  • Output: hotel_kilo1.kilo_uniform_hotel
20. 0.579 71.820 ↑ 30.2 872 1

Nested Loop (cost=1.140..97,932.350 rows=26,309 width=4) (actual time=0.117..71.820 rows=872 loops=1)

  • Output: uniform_papa1.victor_hotel
21. 57.289 57.289 ↑ 30.2 872 1

Index Scan using yankee on mike_juliet india_two (cost=0.570..4,689.490 rows=26,309 width=4) (actual time=0.057..57.289 rows=872 loops=1)

  • Output: five_echo1.juliet_romeo_quebec
  • Index Cond: ((five_echo1.whiskey_echo)::text = ANY ('mike_charlie'::text[]))
22. 13.952 13.952 ↑ 1.0 1 872

Index Scan using alpha_hotel on two_oscar kilo_uniform_bravo (cost=0.570..3.530 rows=1 width=8) (actual time=0.015..0.016 rows=1 loops=872)

  • Output: uniform_papa1.quebec_seven, uniform_papa1.charlie_alpha, uniform_papa1.tango_victor, uniform_papa1.golf_whiskey, uniform_papa1.victor_hotel, uniform_papa1.sierra_juliet, uniform_papa1.romeo_kilo, uniform_papa1.juliet_charlie
  • Index Cond: (uniform_papa1.quebec_seven = five_echo1.juliet_romeo_quebec)
23. 5.232 5.232 ↑ 1.0 1 872

Index Scan using alpha_xray on sierra_romeo lima_lima_xray (cost=0.430..0.640 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=872)

  • Output: hotel_kilo1.quebec_seven, hotel_kilo1.charlie_alpha, hotel_kilo1.november, hotel_kilo1.echo, hotel_kilo1.kilo_uniform_hotel
  • Index Cond: (hotel_kilo1.quebec_seven = uniform_papa1.victor_hotel)
24. 16.347 49.041 ↑ 1.0 1 5,449

Aggregate (cost=11.460..11.470 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=5,449)

  • Output: five_two(three_six2.quebec_seven)
25. 32.694 32.694 ↑ 7.0 1 5,449

Index Scan using charlie_papa on delta_hotel uniform_yankee (cost=0.430..11.440 rows=7 width=4) (actual time=0.005..0.006 rows=1 loops=5,449)

  • Output: three_six2.quebec_seven
  • Index Cond: (three_six2.kilo_uniform_hotel = lima_lima_echo.quebec_seven)
26. 16.347 632.084 ↑ 1.0 1 5,449

Aggregate (cost=192.290..192.300 rows=1 width=4) (actual time=0.116..0.116 rows=1 loops=5,449)

  • Output: five_two(uniform_papa2.quebec_seven)
27. 55.178 615.737 ↑ 5.0 12 5,449

Nested Loop (cost=1.570..192.140 rows=60 width=4) (actual time=0.044..0.113 rows=12 loops=5,449)

  • Output: uniform_papa2.quebec_seven
28. 30.058 321.491 ↑ 3.5 11 5,449

Nested Loop (cost=1.000..151.150 rows=39 width=4) (actual time=0.028..0.059 rows=11 loops=5,449)

  • Output: uniform_papa2.quebec_seven
29. 54.490 54.490 ↑ 1.5 2 5,449

Index Scan using bravo_quebec on sierra_romeo india_november (cost=0.430..4.480 rows=3 width=4) (actual time=0.009..0.010 rows=2 loops=5,449)

  • Output: hotel_kilo2.quebec_seven, hotel_kilo2.charlie_alpha, hotel_kilo2.november, hotel_kilo2.echo, hotel_kilo2.kilo_uniform_hotel
  • Index Cond: (hotel_kilo2.kilo_uniform_hotel = lima_lima_echo.quebec_seven)
30. 236.943 236.943 ↑ 13.2 5 11,283

Index Scan using whiskey_five on two_oscar zulu_foxtrot (cost=0.570..48.230 rows=66 width=8) (actual time=0.010..0.021 rows=5 loops=11,283)

  • Output: uniform_papa2.quebec_seven, uniform_papa2.charlie_alpha, uniform_papa2.tango_victor, uniform_papa2.golf_whiskey, uniform_papa2.victor_hotel, uniform_papa2.sierra_juliet, uniform_papa2.romeo_kilo, uniform_papa2.juliet_charlie
  • Index Cond: (uniform_papa2.victor_hotel = hotel_kilo2.quebec_seven)
31. 239.068 239.068 ↑ 12.0 1 59,767

Index Only Scan using quebec_three on mike_juliet juliet_two (cost=0.570..0.930 rows=12 width=4) (actual time=0.004..0.004 rows=1 loops=59,767)

  • Output: five_echo2.juliet_romeo_quebec
  • Index Cond: (five_echo2.juliet_romeo_quebec = uniform_papa2.quebec_seven)
  • Heap Fetches: 22312
32. 21.796 441.369 ↑ 1.0 1 5,449

Aggregate (cost=248.540..248.550 rows=1 width=4) (actual time=0.081..0.081 rows=1 loops=5,449)

  • Output: five_two(uniform_papa3.quebec_seven)
33. 33.554 419.573 ↑ 5.0 12 5,449

Nested Loop (cost=1.570..248.390 rows=60 width=4) (actual time=0.018..0.077 rows=12 loops=5,449)

  • Output: uniform_papa3.quebec_seven
34. 25.705 87.184 ↑ 3.5 11 5,449

Nested Loop (cost=1.000..151.150 rows=39 width=4) (actual time=0.009..0.016 rows=11 loops=5,449)

  • Output: uniform_papa3.quebec_seven
35. 16.347 16.347 ↑ 1.5 2 5,449

Index Scan using bravo_quebec on sierra_romeo hotel_uniform (cost=0.430..4.480 rows=3 width=4) (actual time=0.003..0.003 rows=2 loops=5,449)

  • Output: hotel_kilo3.quebec_seven, hotel_kilo3.charlie_alpha, hotel_kilo3.november, hotel_kilo3.echo, hotel_kilo3.kilo_uniform_hotel
  • Index Cond: (hotel_kilo3.kilo_uniform_hotel = lima_lima_echo.quebec_seven)
36. 45.132 45.132 ↑ 13.2 5 11,283

Index Scan using whiskey_five on two_oscar zulu_golf (cost=0.570..48.230 rows=66 width=8) (actual time=0.002..0.004 rows=5 loops=11,283)

  • Output: uniform_papa3.quebec_seven, uniform_papa3.charlie_alpha, uniform_papa3.tango_victor, uniform_papa3.golf_whiskey, uniform_papa3.victor_hotel, uniform_papa3.sierra_juliet, uniform_papa3.romeo_kilo, uniform_papa3.juliet_charlie
  • Index Cond: (uniform_papa3.victor_hotel = hotel_kilo3.quebec_seven)
37. 298.835 298.835 ↑ 12.0 1 59,767

Index Scan using quebec_three on mike_juliet papa_bravo (cost=0.570..2.370 rows=12 width=4) (actual time=0.005..0.005 rows=1 loops=59,767)

  • Output: five_echo3.juliet_romeo_quebec
  • Index Cond: (five_echo3.juliet_romeo_quebec = uniform_papa3.quebec_seven)
  • Filter: ((five_echo3.whiskey_echo)::text = 'golf_uniform'::text)
38. 10.898 59.939 ↑ 1.0 1 5,449

Limit (cost=0.430..3.450 rows=1 width=23) (actual time=0.011..0.011 rows=1 loops=5,449)

  • Output: victor_kilo.six_hotel
39. 49.041 49.041 ↑ 1.0 1 5,449

Index Scan using lima_mike on sierra_papa (cost=0.430..3.450 rows=1 width=23) (actual time=0.009..0.009 rows=1 loops=5,449)

  • Output: victor_kilo.six_hotel
  • Index Cond: (victor_kilo.quebec_seven = lima_lima_echo.foxtrot_uniform)
40. 2,522.887 31,288.158 ↑ 1.0 1 5,449

Aggregate (cost=6.460..6.470 rows=1 width=4) (actual time=5.742..5.742 rows=1 loops=5,449)

  • Output: five_two(juliet_romeo_sierra1.quebec_seven)
41. 28,765.271 28,765.271 ↓ 1,089.8 5,449 5,449

Index Scan using oscar_three on zulu_quebec six_zulu (cost=0.430..6.450 rows=5 width=4) (actual time=0.016..5.279 rows=5,449 loops=5,449)

  • Output: juliet_romeo_sierra1.quebec_seven, juliet_romeo_sierra1.november, juliet_romeo_sierra1.juliet_charlie, juliet_romeo_sierra1.tango_victor, juliet_romeo_sierra1.hotel_lima, juliet_romeo_sierra1.delta_echo, juliet_romeo_sierra1.charlie_hotel, juliet_romeo_sierra1.alpha_delta, juliet_romeo_sierra1.juliet_whiskey, juliet_romeo_sierra1.foxtrot_uniform, juliet_romeo_sierra1.oscar_golf, juliet_romeo_sierra1.alpha_charlie, juliet_romeo_sierra1.oscar_bravo, juliet_romeo_sierra1.victor_india, juliet_romeo_sierra1.victor_sierra, juliet_romeo_sierra1.lima_india
  • Index Cond: (juliet_romeo_sierra1.foxtrot_uniform = papa_whiskey1.quebec_seven)
42. 2,048.824 29,184.844 ↑ 1.0 1 5,449

Aggregate (cost=6.470..6.480 rows=1 width=4) (actual time=5.356..5.356 rows=1 loops=5,449)

  • Output: five_two(juliet_romeo_sierra2.quebec_seven)
43. 27,136.020 27,136.020 ↓ 1,089.8 5,449 5,449

Index Scan using oscar_three on zulu_quebec six_echo (cost=0.430..6.460 rows=5 width=4) (actual time=0.017..4.980 rows=5,449 loops=5,449)

  • Output: juliet_romeo_sierra2.quebec_seven, juliet_romeo_sierra2.november, juliet_romeo_sierra2.juliet_charlie, juliet_romeo_sierra2.tango_victor, juliet_romeo_sierra2.hotel_lima, juliet_romeo_sierra2.delta_echo, juliet_romeo_sierra2.charlie_hotel, juliet_romeo_sierra2.alpha_delta, juliet_romeo_sierra2.juliet_whiskey, juliet_romeo_sierra2.foxtrot_uniform, juliet_romeo_sierra2.oscar_golf, juliet_romeo_sierra2.alpha_charlie, juliet_romeo_sierra2.oscar_bravo, juliet_romeo_sierra2.victor_india, juliet_romeo_sierra2.victor_sierra, juliet_romeo_sierra2.lima_india
  • Index Cond: (juliet_romeo_sierra2.foxtrot_uniform = papa_whiskey1.quebec_seven)
  • Filter: ((juliet_romeo_sierra2.juliet_charlie)::text = 'golf_uniform'::text)
44. 3,018.746 143,750.069 ↑ 1.0 1 5,449

Aggregate (cost=64.050..64.060 rows=1 width=4) (actual time=26.381..26.381 rows=1 loops=5,449)

  • Output: five_two(three_six3.quebec_seven)
45. 21,447.264 140,731.323 ↓ 314.1 5,968 5,449

Nested Loop (cost=0.860..64.000 rows=19 width=4) (actual time=0.029..25.827 rows=5,968 loops=5,449)

  • Output: three_six3.quebec_seven
46. 30,209.256 30,209.256 ↓ 1,089.8 5,449 5,449

Index Scan using oscar_three on zulu_quebec oscar_echo (cost=0.430..6.450 rows=5 width=4) (actual time=0.015..5.544 rows=5,449 loops=5,449)

  • Output: juliet_romeo_sierra3.quebec_seven, juliet_romeo_sierra3.november, juliet_romeo_sierra3.juliet_charlie, juliet_romeo_sierra3.tango_victor, juliet_romeo_sierra3.hotel_lima, juliet_romeo_sierra3.delta_echo, juliet_romeo_sierra3.charlie_hotel, juliet_romeo_sierra3.alpha_delta, juliet_romeo_sierra3.juliet_whiskey, juliet_romeo_sierra3.foxtrot_uniform, juliet_romeo_sierra3.oscar_golf, juliet_romeo_sierra3.alpha_charlie, juliet_romeo_sierra3.oscar_bravo, juliet_romeo_sierra3.victor_india, juliet_romeo_sierra3.victor_sierra, juliet_romeo_sierra3.lima_india
  • Index Cond: (juliet_romeo_sierra3.foxtrot_uniform = papa_whiskey1.quebec_seven)
47. 89,074.803 89,074.803 ↑ 7.0 1 29,691,601

Index Scan using charlie_papa on delta_hotel five_hotel (cost=0.430..11.440 rows=7 width=8) (actual time=0.003..0.003 rows=1 loops=29,691,601)

  • Output: three_six3.quebec_seven, three_six3.kilo_uniform_hotel
  • Index Cond: (three_six3.kilo_uniform_hotel = juliet_romeo_sierra3.quebec_seven)
48. 27.245 136,181.408 ↑ 1.0 1 5,449

Aggregate (cost=63.840..63.850 rows=1 width=4) (actual time=24.992..24.992 rows=1 loops=5,449)

  • Output: five_two(three_six4.quebec_seven)
49. 14,652.361 136,154.163 ↓ 4.0 4 5,449

Nested Loop (cost=0.860..63.830 rows=1 width=4) (actual time=8.538..24.987 rows=4 loops=5,449)

  • Output: three_six4.quebec_seven
50. 32,426.999 32,426.999 ↓ 1,089.8 5,449 5,449

Index Scan using oscar_three on zulu_quebec foxtrot_juliet (cost=0.430..6.450 rows=5 width=4) (actual time=0.017..5.951 rows=5,449 loops=5,449)

  • Output: juliet_romeo_sierra4.quebec_seven, juliet_romeo_sierra4.november, juliet_romeo_sierra4.juliet_charlie, juliet_romeo_sierra4.tango_victor, juliet_romeo_sierra4.hotel_lima, juliet_romeo_sierra4.delta_echo, juliet_romeo_sierra4.charlie_hotel, juliet_romeo_sierra4.alpha_delta, juliet_romeo_sierra4.juliet_whiskey, juliet_romeo_sierra4.foxtrot_uniform, juliet_romeo_sierra4.oscar_golf, juliet_romeo_sierra4.alpha_charlie, juliet_romeo_sierra4.oscar_bravo, juliet_romeo_sierra4.victor_india, juliet_romeo_sierra4.victor_sierra, juliet_romeo_sierra4.lima_india
  • Index Cond: (juliet_romeo_sierra4.foxtrot_uniform = papa_whiskey1.quebec_seven)
51. 89,074.803 89,074.803 ↓ 0.0 0 29,691,601

Index Scan using charlie_papa on delta_hotel romeo_xray (cost=0.430..11.470 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=29,691,601)

  • Output: three_six4.quebec_seven, three_six4.kilo_uniform_hotel
  • Index Cond: (three_six4.kilo_uniform_hotel = juliet_romeo_sierra4.quebec_seven)
  • Filter: ((three_six4.golf_six)::text = ANY ('tango_alpha'::text[]))
  • Rows Removed by Filter: 1
52. 21.796 135,244.180 ↑ 1.0 1 5,449

Aggregate (cost=63.790..63.800 rows=1 width=4) (actual time=24.820..24.820 rows=1 loops=5,449)

  • Output: five_two(three_six5.quebec_seven)
53. 13,469.928 135,222.384 ↓ 4.0 4 5,449

Nested Loop (cost=0.860..63.790 rows=1 width=4) (actual time=8.498..24.816 rows=4 loops=5,449)

  • Output: three_six5.quebec_seven
54. 32,677.653 32,677.653 ↓ 1,089.8 5,449 5,449

Index Scan using oscar_three on zulu_quebec india_five (cost=0.430..6.450 rows=5 width=4) (actual time=0.018..5.997 rows=5,449 loops=5,449)

  • Output: juliet_romeo_sierra5.quebec_seven, juliet_romeo_sierra5.november, juliet_romeo_sierra5.juliet_charlie, juliet_romeo_sierra5.tango_victor, juliet_romeo_sierra5.hotel_lima, juliet_romeo_sierra5.delta_echo, juliet_romeo_sierra5.charlie_hotel, juliet_romeo_sierra5.alpha_delta, juliet_romeo_sierra5.juliet_whiskey, juliet_romeo_sierra5.foxtrot_uniform, juliet_romeo_sierra5.oscar_golf, juliet_romeo_sierra5.alpha_charlie, juliet_romeo_sierra5.oscar_bravo, juliet_romeo_sierra5.victor_india, juliet_romeo_sierra5.victor_sierra, juliet_romeo_sierra5.lima_india
  • Index Cond: (juliet_romeo_sierra5.foxtrot_uniform = papa_whiskey1.quebec_seven)
55. 89,074.803 89,074.803 ↓ 0.0 0 29,691,601

Index Scan using charlie_papa on delta_hotel delta_five (cost=0.430..11.460 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=29,691,601)

  • Output: three_six5.quebec_seven, three_six5.kilo_uniform_hotel
  • Index Cond: (three_six5.kilo_uniform_hotel = juliet_romeo_sierra5.quebec_seven)
  • Filter: ((three_six5.golf_six)::text = 'india_quebec'::text)
  • Rows Removed by Filter: 1
Planning time : 12.113 ms
Execution time : 477,185.990 ms