explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F3RM : SQL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=348,957,067.000..593,977,498.830 rows=166,115,547 width=1,747) (actual rows= loops=)

  • Group Key: juliet_bravo.kilo_quebec, juliet_bravo.kilo_india, juliet_bravo.bravo_xray, juliet_bravo.romeo_zulu_xray, juliet_bravo.uniform_quebec, juliet_bravo.four_yankee, juliet_bravo.charlie_alpha, juliet_bravo.yankee_tango, juliet_bravo.quebec, juliet_bravo.oscar_hotel, juliet_bravo.zulu_zulu, romeo_three001.victor_mike, romeo_three001victor_seven.november_lima_uniform1, alpha_romeo01.two_victor, five_india.hotel_victor, echo_foxtrot.hotel_victor, three_zulu.hotel_victor, (uniform_bravo((lima_sierra(five_lima1.november_juliet_foxtrot1, ''juliet_uniform''::character varying))::text)), golf_six.india_uniform, zulu_mike.india_uniform, india_papa.november_lima_uniform1, india_papa.quebec, uniform_four.november_golf_xray, uniform_four.charlie_quebec, uniform_four.five_sierra_lima, whiskey_charlie.mike_india, whiskey_charlie.papa_oscar, whiskey_charlie.zulu_yankee, whiskey_charlie.bravo_india, juliet_bravo.oscar_victor, juliet_bravo.two_india, juliet_bravo.lima_charlie, uniform_juliet.mike_echo, juliet_six.charlie_quebec, juliet_six.five_sierra_lima, juliet_six.foxtrot01, juliet_six.whiskey_foxtrot, juliet_six.sierra, uniform_juliet.yankee_november_hotel, india_kilo.yankee_november_hotel, india_papa.yankee_november_hotel, uniform_juliet.lima_three, india_kilo.lima_three, india_papa.lima_three, two_two.romeo_uniform, india_kilo.three_whiskey, india_kilo.kilo_charlie_uniform, india_kilo.seven_whiskey, india_kilo.six_two2, india_kilo.six_two3, india_kilo.two_quebec2, india_kilo.two_quebec3, whiskey_xray.yankee_november_hotel, whiskey_xray.three_whiskey, whiskey_xray.kilo_charlie_uniform, whiskey_xray.seven_whiskey, whiskey_xray.six_two2, whiskey_xray.six_two3, whiskey_xray.two_quebec2, whiskey_xray.two_quebec3, xray_alpha.yankee_november_hotel, xray_alpha.three_whiskey, xray_alpha.kilo_charlie_uniform, xray_alpha.seven_whiskey, xray_alpha.six_two2, xray_alpha.six_two3, xray_alpha.two_quebec2, xray_alpha.two_quebec3, kilo_oscar_delta.yankee_november_hotel, kilo_oscar_delta.three_whiskey, kilo_oscar_delta.kilo_charlie_uniform, kilo_oscar_delta.seven_whiskey, kilo_oscar_delta.six_two2, kilo_oscar_delta.six_two3, kilo_oscar_delta.two_quebec2, kilo_oscar_delta.two_quebec3
2. 0.000 0.000 ↓ 0.0

Sort (cost=348,957,067.000..349,372,355.870 rows=166,115,547 width=967) (actual rows= loops=)

  • Sort Key: juliet_bravo.kilo_quebec, juliet_bravo.kilo_india, juliet_bravo.bravo_xray, juliet_bravo.romeo_zulu_xray, juliet_bravo.uniform_quebec, juliet_bravo.four_yankee, juliet_bravo.charlie_alpha, juliet_bravo.yankee_tango, juliet_bravo.quebec, juliet_bravo.oscar_hotel, juliet_bravo.zulu_zulu, romeo_three001.victor_mike, romeo_three001victor_seven.november_lima_uniform1, alpha_romeo01.two_victor, five_india.hotel_victor, echo_foxtrot.hotel_victor, three_zulu.hotel_victor, (uniform_bravo((lima_sierra(five_lima1.november_juliet_foxtrot1, ''juliet_uniform''::character varying))::text)), golf_six.india_uniform, zulu_mike.india_uniform, india_papa.november_lima_uniform1, india_papa.quebec, uniform_four.november_golf_xray, uniform_four.charlie_quebec, uniform_four.five_sierra_lima, whiskey_charlie.mike_india, whiskey_charlie.papa_oscar, whiskey_charlie.zulu_yankee, whiskey_charlie.bravo_india, juliet_bravo.oscar_victor, juliet_bravo.two_india, juliet_bravo.lima_charlie, uniform_juliet.mike_echo, juliet_six.charlie_quebec, juliet_six.five_sierra_lima, juliet_six.foxtrot01, juliet_six.whiskey_foxtrot, juliet_six.sierra, uniform_juliet.yankee_november_hotel, india_kilo.yankee_november_hotel, india_papa.yankee_november_hotel, uniform_juliet.lima_three, india_kilo.lima_three, india_papa.lima_three, two_two.romeo_uniform, india_kilo.three_whiskey, india_kilo.kilo_charlie_uniform, india_kilo.seven_whiskey, india_kilo.six_two2, india_kilo.six_two3, india_kilo.two_quebec2, india_kilo.two_quebec3, whiskey_xray.yankee_november_hotel, whiskey_xray.three_whiskey, whiskey_xray.kilo_charlie_uniform, whiskey_xray.seven_whiskey, whiskey_xray.six_two2, whiskey_xray.six_two3, whiskey_xray.two_quebec2, whiskey_xray.two_quebec3, xray_alpha.yankee_november_hotel, xray_alpha.three_whiskey, xray_alpha.kilo_charlie_uniform, xray_alpha.seven_whiskey, xray_alpha.six_two2, xray_alpha.six_two3, xray_alpha.two_quebec2, xray_alpha.two_quebec3, kilo_oscar_delta.yankee_november_hotel, kilo_oscar_delta.three_whiskey, kilo_oscar_delta.kilo_charlie_uniform, kilo_oscar_delta.seven_whiskey, kilo_oscar_delta.six_two2, kilo_oscar_delta.six_two3, kilo_oscar_delta.two_quebec2, kilo_oscar_delta.two_quebec3
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=21,431,802.480..44,658,202.590 rows=166,115,547 width=967) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = echo_foxtrot.four_echo) AND ((juliet_bravo.four_yankee)::text = (echo_foxtrot.mike_zulu)::text))
4. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=21,430,800.440..22,057,842.940 rows=34,752,203 width=943) (actual rows= loops=)

  • Merge Cond: ((juliet_bravo.oscar_hotel)::text = (juliet_seven1.oscar_hotel)::text)
  • Join Filter: (juliet_seven1.four_echo = juliet_bravo.two_juliet)
5. 0.000 0.000 ↓ 0.0

Sort (cost=21,415,255.130..21,423,963.480 rows=3,483,340 width=911) (actual rows= loops=)

  • Sort Key: juliet_bravo.oscar_hotel
6. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=16,791,873.070..16,857,765.210 rows=3,483,340 width=911) (actual rows= loops=)

  • Merge Cond: ((juliet_bravo.quebec)::text = (five_lima1.quebec)::text)
  • Join Filter: (five_lima1.four_echo = juliet_bravo.two_juliet)
7. 0.000 0.000 ↓ 0.0

Sort (cost=16,777,116.330..16,779,049.860 rows=773,410 width=879) (actual rows= loops=)

  • Sort Key: juliet_bravo.quebec
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15,404,049.770..16,104,037.450 rows=773,410 width=879) (actual rows= loops=)

  • Hash Cond: (((juliet_bravo.bravo_xray)::text = (two_two.india_three)::text) AND ((juliet_bravo.charlie_alpha)::text = (two_two.five_tango)::text))
9. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15,403,989.230..15,922,213.430 rows=773,410 width=866) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = three_zulu.four_echo) AND ((juliet_bravo.yankee_tango)::text = (three_zulu.alpha_golf)::text) AND ((juliet_bravo.romeo_zulu_xray)::text = (three_zulu.romeo_zulu_xray)::text))
10. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15,403,060.430..15,907,459.980 rows=773,410 width=834) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = five_india.four_echo) AND ((juliet_bravo.charlie_alpha)::text = (five_india.charlie_alpha)::text) AND ((juliet_bravo.romeo_zulu_xray)::text = (five_india.romeo_zulu_xray)::text))
11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15,402,238.850..15,892,813.700 rows=773,410 width=802) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = alpha_romeo01.four_echo) AND ((juliet_bravo.romeo_zulu_xray)::text = (alpha_romeo01.romeo_zulu_xray)::text))
12. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15,402,228.800..15,886,299.970 rows=773,410 width=770) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = romeo_three001victor_seven.four_echo) AND ((juliet_bravo.uniform_quebec)::text = (romeo_three001victor_seven.uniform_quebec)::text))
13. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15,402,199.870..15,832,260.770 rows=773,410 width=738) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = romeo_three001.four_echo) AND ((juliet_bravo.bravo_xray)::text = (romeo_three001.echo_quebec)::text))
14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15,402,186.110..15,818,712.330 rows=773,410 width=706) (actual rows= loops=)

  • Hash Cond: (golf_two((juliet_bravo.oscar_hotel)::text, 'november_golf_sierra'::text) = zulu_mike.five_bravo)
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15,355,763.760..15,622,985.830 rows=773,410 width=642) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = uniform_four.four_echo) AND ((juliet_bravo.zulu_zulu)::text = (uniform_four.zulu_zulu)::text))
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=15,340,463.260..15,476,959.890 rows=773,410 width=599) (actual rows= loops=)

  • Hash Cond: (golf_two((juliet_bravo.quebec)::text, 'november_golf_sierra'::text) = golf_six.five_bravo)
17. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=15,294,040.910..15,302,381.400 rows=773,410 width=535) (actual rows= loops=)

  • Merge Cond: (((juliet_bravo.bravo_xray)::text = (india_papa.echo_quebec)::text) AND ((juliet_bravo.lima_charlie)::text = (india_papa.yankee_november_hotel)::text) AND (juliet_bravo.india_seven = india_papa.victor_romeo))
  • Join Filter: (juliet_bravo.two_juliet = india_papa.four_echo)
18. 0.000 0.000 ↓ 0.0

Sort (cost=15,288,517.530..15,290,451.050 rows=773,410 width=474) (actual rows= loops=)

  • Sort Key: juliet_bravo.bravo_xray, juliet_bravo.lima_charlie, juliet_bravo.india_seven
19. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8,822,728.130..14,879,793.650 rows=773,410 width=474) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8,822,727.570..12,563,270.930 rows=290,855 width=436) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,822,727.000..10,233,286.790 rows=290,855 width=417) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = india_kilo.four_echo) AND (((juliet_bravo.lima_charlie)::text || (juliet_bravo.india_seven)::text) = (india_kilo.victor_alpha)::text))
22. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=7,575,398.340..8,618,739.430 rows=290,855 width=349) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = kilo_oscar_delta.four_echo) AND ((juliet_bravo.lima_charlie)::text = (kilo_oscar_delta.victor_alpha)::text))
23. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,368,042.690..7,109,360.200 rows=290,855 width=299) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = xray_alpha.four_echo) AND (((juliet_bravo.lima_charlie)::text || (juliet_bravo.romeo_charlie)::text) = (xray_alpha.victor_alpha)::text))
24. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,160,687.030..5,596,117.600 rows=290,855 width=256) (actual rows= loops=)

  • Hash Cond: ((juliet_bravo.two_juliet = whiskey_xray.four_echo) AND ((((juliet_bravo.lima_charlie)::text || (juliet_bravo.bravo_xray)::text) || (juliet_bravo.india_seven)::text) = (whiskey_xray.victor_alpha)::text))
25. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=3,953,331.380..4,064,468.870 rows=290,855 width=206) (actual rows= loops=)

  • Merge Cond: ((juliet_bravo.golf_zulu = juliet_six.golf_zulu) AND ((juliet_bravo.oscar_victor)::text = (juliet_six.oscar_victor)::text))
  • Join Filter: (juliet_bravo.two_juliet = juliet_six.four_echo)
26. 0.000 0.000 ↓ 0.0

Sort (cost=950,855.070..951,582.210 rows=290,855 width=163) (actual rows= loops=)

  • Sort Key: juliet_bravo.golf_zulu, juliet_bravo.oscar_victor
27. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on juliet_bravo (cost=6,173.850..900,600.560 rows=290,855 width=163) (actual rows= loops=)

  • Recheck Cond: (((lima_four)::bigint >= (juliet_golf('november_juliet_victor', 'zulu_five', 'zulu_five'))::bigint) AND ((lima_four)::bigint < (xray_yankee((hotel_delta('yankee_four'::text, 'xray_three'::text) + 'two_three'::interval), 'xray_three'::text))::bigint))
  • Filter: (two_juliet = 300)
28. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on delta_kilo (cost=0.000..6,101.130 rows=290,855 width=0) (actual rows= loops=)

  • Index Cond: (((lima_four)::bigint >= (juliet_golf('november_juliet_victor', 'zulu_five', 'zulu_five'))::bigint) AND ((lima_four)::bigint < (xray_yankee((hotel_delta('yankee_four'::text, 'xray_three'::text) + 'two_three'::interval), 'xray_three'::text))::bigint))
29. 0.000 0.000 ↓ 0.0

Materialize (cost=3,002,476.310..3,056,730.160 rows=10,850,770 width=78) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Sort (cost=3,002,476.310..3,029,603.230 rows=10,850,770 width=78) (actual rows= loops=)

  • Sort Key: juliet_six.golf_zulu, juliet_six.oscar_victor
31. 0.000 0.000 ↓ 0.0

Seq Scan on juliet_xray juliet_six (cost=0.000..288,076.630 rows=10,850,770 width=78) (actual rows= loops=)

  • Filter: (four_echo = 300)
32. 0.000 0.000 ↓ 0.0

Hash (cost=640,536.030..640,536.030 rows=20,466,242 width=73) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_uniform whiskey_xray (cost=0.000..640,536.030 rows=20,466,242 width=73) (actual rows= loops=)

  • Filter: (four_echo = 300)
34. 0.000 0.000 ↓ 0.0

Hash (cost=640,536.030..640,536.030 rows=20,466,242 width=73) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_uniform xray_alpha (cost=0.000..640,536.030 rows=20,466,242 width=73) (actual rows= loops=)

  • Filter: (four_echo = 300)
36. 0.000 0.000 ↓ 0.0

Hash (cost=640,536.030..640,536.030 rows=20,466,242 width=73) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_uniform kilo_oscar_delta (cost=0.000..640,536.030 rows=20,466,242 width=73) (actual rows= loops=)

  • Filter: (four_echo = 300)
38. 0.000 0.000 ↓ 0.0

Hash (cost=640,536.030..640,536.030 rows=20,466,242 width=91) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_uniform india_kilo (cost=0.000..640,536.030 rows=20,466,242 width=91) (actual rows= loops=)

  • Filter: (four_echo = 300)
40. 0.000 0.000 ↓ 0.0

Index Scan using victor_sierra on six_quebec whiskey_charlie (cost=0.570..8.000 rows=1 width=43) (actual rows= loops=)

  • Index Cond: (((juliet_bravo.uniform_quebec)::text = (uniform_three)::text) AND ((juliet_bravo.zulu_zulu)::text = (zulu_zulu)::text))
  • Filter: ((four_echo = 300) AND (juliet_bravo.two_juliet = four_echo))
41. 0.000 0.000 ↓ 0.0

Index Scan using mike_lima on zulu_uniform uniform_juliet (cost=0.560..7.950 rows=1 width=51) (actual rows= loops=)

  • Index Cond: (((juliet_bravo.lima_charlie)::text = (yankee_november_hotel)::text) AND (juliet_bravo.india_seven = victor_romeo) AND ((juliet_bravo.bravo_xray)::text = (echo_quebec)::text))
42. 0.000 0.000 ↓ 0.0

Materialize (cost=5,523.380..5,701.490 rows=35,622 width=90) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Sort (cost=5,523.380..5,612.440 rows=35,622 width=90) (actual rows= loops=)

  • Sort Key: india_papa.echo_quebec, india_papa.yankee_november_hotel, india_papa.victor_romeo
44. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_hotel india_papa (cost=0.000..1,003.280 rows=35,622 width=90) (actual rows= loops=)

  • Filter: (four_echo = 300)
45. 0.000 0.000 ↓ 0.0

Hash (cost=24,958.820..24,958.820 rows=851,882 width=74) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on november_sierra golf_six (cost=0.000..24,958.820 rows=851,882 width=74) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Hash (cost=7,402.770..7,402.770 rows=306,782 width=62) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Seq Scan on seven_quebec uniform_four (cost=0.000..7,402.770 rows=306,782 width=62) (actual rows= loops=)

  • Filter: (four_echo = 300)
49. 0.000 0.000 ↓ 0.0

Hash (cost=24,958.820..24,958.820 rows=851,882 width=74) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Seq Scan on november_sierra zulu_mike (cost=0.000..24,958.820 rows=851,882 width=74) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Hash (cost=12.760..12.760 rows=67 width=45) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Subquery Scan on whiskey_six (cost=11.250..12.760 rows=67 width=45) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

HashAggregate (cost=11.250..12.090 rows=67 width=45) (actual rows= loops=)

  • Group Key: romeo_three001kilo_oscar_quebec1.four_echo, romeo_three001kilo_oscar_quebec1.echo_quebec, uniform_bravo((lima_sierra(romeo_three001kilo_oscar_quebec1.victor_mike, ''::character varying))::text)
54. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_six papa_four (cost=0.000..10.740 rows=68 width=45) (actual rows= loops=)

  • Filter: (four_echo = 300)
55. 0.000 0.000 ↓ 0.0

Hash (cost=25.420..25.420 rows=234 width=44) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Subquery Scan on juliet_four (cost=20.150..25.420 rows=234 width=44) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

HashAggregate (cost=20.150..23.080 rows=234 width=44) (actual rows= loops=)

  • Group Key: romeo_three001yankee_november_seven1.four_echo, romeo_three001yankee_november_seven1.uniform_quebec, uniform_bravo((lima_sierra(romeo_three001yankee_november_seven1.november_lima_uniform1, ''::character varying))::text)
58. 0.000 0.000 ↓ 0.0

Seq Scan on juliet_four india_lima (cost=0.000..18.400 rows=234 width=44) (actual rows= loops=)

  • Filter: (four_echo = 300)
59. 0.000 0.000 ↓ 0.0

Hash (cost=10.040..10.040 rows=1 width=556) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Subquery Scan on seven_delta (cost=10.010..10.040 rows=1 width=556) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Group (cost=10.010..10.030 rows=1 width=556) (actual rows= loops=)

  • Group Key: alpha_romeo01kilo_oscar_quebec1.four_echo, alpha_romeo01kilo_oscar_quebec1.romeo_zulu_xray, (uniform_bravo((lima_sierra(alpha_romeo01kilo_oscar_quebec1.two_victor, ''::character varying))::text))
62. 0.000 0.000 ↓ 0.0

Sort (cost=10.010..10.020 rows=1 width=556) (actual rows= loops=)

  • Sort Key: alpha_romeo01kilo_oscar_quebec1.romeo_zulu_xray, (uniform_bravo((lima_sierra(alpha_romeo01kilo_oscar_quebec1.two_victor, ''::character varying))::text))
63. 0.000 0.000 ↓ 0.0

Seq Scan on seven_delta xray_charlie (cost=0.000..10.000 rows=1 width=556) (actual rows= loops=)

  • Filter: (four_echo = 300)
64. 0.000 0.000 ↓ 0.0

Hash (cost=821.320..821.320 rows=15 width=54) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Subquery Scan on five_india (cost=759.950..821.320 rows=15 width=54) (actual rows= loops=)

  • Filter: (five_india.four_echo = 300)
66. 0.000 0.000 ↓ 0.0

Unique (cost=759.950..784.090 rows=2,978 width=63) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Sort (cost=759.950..768.000 rows=3,219 width=63) (actual rows= loops=)

  • Sort Key: victor_juliet1.romeo_zulu_xray, victor_juliet1.charlie_alpha, victor_juliet1.five_two DESC
68. 0.000 0.000 ↓ 0.0

Seq Scan on five_india hotel_november (cost=0.000..572.400 rows=3,219 width=63) (actual rows= loops=)

  • Filter: (((november_lima_lima)::text = 'delta_sierra'::text) AND (four_echo = 300))
69. 0.000 0.000 ↓ 0.0

Hash (cost=928.330..928.330 rows=27 width=55) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Subquery Scan on three_zulu (cost=817.940..928.330 rows=27 width=55) (actual rows= loops=)

  • Filter: (three_zulu.four_echo = 300)
71. 0.000 0.000 ↓ 0.0

Unique (cost=817.940..860.550 rows=5,422 width=64) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Sort (cost=817.940..832.150 rows=5,681 width=64) (actual rows= loops=)

  • Sort Key: six_lima1.alpha_golf, six_lima1.romeo_zulu_xray, six_lima1.five_two DESC
73. 0.000 0.000 ↓ 0.0

Seq Scan on three_zulu kilo_whiskey (cost=0.000..463.680 rows=5,681 width=64) (actual rows= loops=)

  • Filter: (((november_lima_lima)::text = 'delta_sierra'::text) AND (four_echo = 300))
74. 0.000 0.000 ↓ 0.0

Hash (cost=46.670..46.670 rows=925 width=28) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Subquery Scan on two_two (cost=28.170..46.670 rows=925 width=28) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

HashAggregate (cost=28.170..37.420 rows=925 width=28) (actual rows= loops=)

  • Group Key: romeo_zulu_kilo1.india_three, romeo_zulu_kilo1.five_tango, romeo_zulu_kilo1.romeo_uniform
77. 0.000 0.000 ↓ 0.0

Seq Scan on two_two delta_oscar (cost=0.000..20.810 rows=981 width=28) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Materialize (cost=14,756.740..15,941.890 rows=47,404 width=50) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Group (cost=14,756.740..15,349.340 rows=47,404 width=50) (actual rows= loops=)

  • Group Key: five_lima1.four_echo, five_lima1.quebec, (uniform_bravo((lima_sierra(five_lima1.november_juliet_foxtrot1, ''::character varying))::text))
80. 0.000 0.000 ↓ 0.0

Sort (cost=14,756.740..14,875.260 rows=47,409 width=50) (actual rows= loops=)

  • Sort Key: five_lima1.quebec, (uniform_bravo((lima_sierra(five_lima1.november_juliet_foxtrot1, ''::character varying))::text))
81. 0.000 0.000 ↓ 0.0

Seq Scan on five_sierra_xray echo_juliet (cost=0.000..11,074.750 rows=47,409 width=50) (actual rows= loops=)

  • Filter: (four_echo = 300)
82. 0.000 0.000 ↓ 0.0

Materialize (cost=15,545.310..17,169.480 rows=64,769 width=50) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Group (cost=15,545.310..16,359.870 rows=64,769 width=50) (actual rows= loops=)

  • Group Key: juliet_seven1.four_echo, juliet_seven1.oscar_hotel, (uniform_bravo((lima_sierra(juliet_seven1.november_lima_uniform1, ''::character varying))::text))
84. 0.000 0.000 ↓ 0.0

Sort (cost=15,545.310..15,708.470 rows=65,264 width=50) (actual rows= loops=)

  • Sort Key: juliet_seven1.oscar_hotel, (uniform_bravo((lima_sierra(juliet_seven1.november_lima_uniform1, ''::character varying))::text))
85. 0.000 0.000 ↓ 0.0

Seq Scan on kilo_seven lima_xray (cost=0.000..8,093.150 rows=65,264 width=50) (actual rows= loops=)

  • Filter: (four_echo = 300)
86. 0.000 0.000 ↓ 0.0

Hash (cost=966.190..966.190 rows=2,390 width=50) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Subquery Scan on echo_foxtrot (cost=912.420..966.190 rows=2,390 width=50) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

HashAggregate (cost=912.420..942.290 rows=2,390 width=50) (actual rows= loops=)

  • Group Key: kilo_charlie_kilo1.four_echo, kilo_charlie_kilo1.mike_zulu, uniform_bravo((lima_sierra(kilo_charlie_kilo1.hotel_victor, ''::character varying))::text)
89. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on echo_foxtrot yankee_mike (cost=159.850..893.110 rows=2,574 width=50) (actual rows= loops=)

  • Recheck Cond: ((november_lima_lima)::text = 'delta_sierra'::text)
  • Filter: (four_echo = 300)
90. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on charlie_oscar (cost=0.000..159.200 rows=7,322 width=0) (actual rows= loops=)

  • Index Cond: ((november_lima_lima)::text = 'delta_sierra'::text)