explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ivgk : hcs2

Settings
# exclusive inclusive rows x rows loops node
1. 2.774 678,117.547 ↓ 2.0 1,574 1

Sort (cost=51,121,572.810..51,121,574.800 rows=796 width=559) (actual time=678,117.419..678,117.547 rows=1,574 loops=1)

  • Sort Key: (five_echo(five_hotel_lima.alpha_echo))
  • Sort Method: quicksort Memory: 813kB
2. 7.035 678,114.773 ↓ 2.0 1,574 1

Nested Loop Left Join (cost=49,480,234.610..51,121,534.460 rows=796 width=559) (actual time=677,669.775..678,114.773 rows=1,574 loops=1)

3. 79.136 677,950.338 ↓ 2.0 1,574 1

Merge Right Join (cost=49,480,234.190..51,121,124.040 rows=796 width=479) (actual time=677,666.880..677,950.338 rows=1,574 loops=1)

  • Merge Cond: ((hotel_hotel.mike_yankee_yankee)::text = (five_hotel_lima.mike_yankee_yankee)::text)
4. 213.937 240,982.820 ↑ 20.2 372,912 1

Group (cost=6,897,282.270..7,556,239.170 rows=7,530,936 width=1,683) (actual time=240,415.075..240,982.820 rows=372,912 loops=1)

  • Group Key: hotel_hotel.mike_yankee_yankee, alpha_seven1.india_zulu, five_romeo.lima_juliet, five_romeo.golf_five, five_romeo.juliet_charlie, five_romeo.uniform_foxtrot, five_romeo.three_juliet, five_romeo.hotel_papa, five_romeo.charlie_yankee, five_romeo.echo_two, five_romeo.whiskey_hotel, five_romeo.lima_mike_lima, five_romeo.delta_alpha, xray_seven.romeo_xray, five_romeo.seven_lima, five_romeo.tango_foxtrot, five_romeo.romeo_bravo, alpha_seven2.india_zulu, quebec_tango_tango1.lima_juliet, quebec_tango_tango1.golf_five, quebec_tango_tango1.juliet_charlie, quebec_tango_tango1.uniform_foxtrot, quebec_tango_tango1.three_juliet, quebec_tango_tango1.hotel_papa, quebec_tango_tango1.charlie_yankee, quebec_tango_tango1.echo_two, quebec_tango_tango1.whiskey_hotel, quebec_tango_tango1.lima_mike_lima, quebec_tango_tango1.delta_alpha, quebec_tango_tango1.seven_lima, quebec_tango_tango1.tango_foxtrot, quebec_tango_tango1.romeo_bravo, five_romeo.mike_tango, quebec_tango_tango1.mike_tango
5. 10,714.493 240,768.883 ↑ 20.2 373,172 1

Sort (cost=6,897,282.270..6,916,109.610 rows=7,530,936 width=1,683) (actual time=240,415.069..240,768.883 rows=373,172 loops=1)

  • Sort Key: hotel_hotel.mike_yankee_yankee, alpha_seven1.india_zulu, five_romeo.lima_juliet, five_romeo.golf_five, five_romeo.juliet_charlie, five_romeo.uniform_foxtrot, five_romeo.three_juliet, five_romeo.hotel_papa, five_romeo.charlie_yankee, five_romeo.echo_two, five_romeo.whiskey_hotel, five_romeo.lima_mike_lima, five_romeo.delta_alpha, xray_seven.romeo_xray, five_romeo.seven_lima, five_romeo.tango_foxtrot, five_romeo.romeo_bravo, alpha_seven2.india_zulu, quebec_tango_tango1.lima_juliet, quebec_tango_tango1.golf_five, quebec_tango_tango1.juliet_charlie, quebec_tango_tango1.uniform_foxtrot, quebec_tango_tango1.three_juliet, quebec_tango_tango1.hotel_papa, quebec_tango_tango1.charlie_yankee, quebec_tango_tango1.echo_two, quebec_tango_tango1.whiskey_hotel, quebec_tango_tango1.lima_mike_lima, quebec_tango_tango1.delta_alpha, quebec_tango_tango1.seven_lima, quebec_tango_tango1.tango_foxtrot, quebec_tango_tango1.romeo_bravo, five_romeo.mike_tango, quebec_tango_tango1.mike_tango
  • Sort Method: external merge Disk: 1386912kB
6. 7,469.790 230,054.390 ↑ 1.0 7,526,603 1

Merge Left Join (cost=1,711,969.790..2,102,463.780 rows=7,530,936 width=1,683) (actual time=204,415.346..230,054.390 rows=7,526,603 loops=1)

  • Merge Cond: ((hotel_hotel.mike_yankee_yankee)::text = (alpha_seven1.mike_yankee_yankee)::text)
7. 2,648.304 27,469.281 ↑ 1.0 7,526,601 1

Merge Left Join (cost=113,851.780..480,240.340 rows=7,530,936 width=841) (actual time=18,135.757..27,469.281 rows=7,526,601 loops=1)

  • Merge Cond: ((hotel_hotel.mike_yankee_yankee)::text = (alpha_seven2.mike_yankee_yankee)::text)
8. 6,666.164 6,666.164 ↑ 1.0 7,526,601 1

Index Only Scan using yankee_six on hotel_kilo hotel_hotel (cost=0.560..347,533.360 rows=7,530,936 width=15) (actual time=0.042..6,666.164 rows=7,526,601 loops=1)

  • Heap Fetches: 2808216
9. 250.230 18,154.813 ↓ 132.0 97,047 1

Sort (cost=113,851.220..113,853.060 rows=735 width=841) (actual time=18,135.706..18,154.813 rows=97,047 loops=1)

  • Sort Key: alpha_seven2.mike_yankee_yankee
  • Sort Method: quicksort Memory: 10957kB
10. 30.726 17,904.583 ↓ 66.0 48,525 1

Gather (cost=1,001.550..113,816.230 rows=735 width=841) (actual time=1.996..17,904.583 rows=48,525 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
11. 46.769 17,873.857 ↓ 56.2 24,262 2 / 2

Nested Loop (cost=1.550..112,742.730 rows=432 width=841) (actual time=1.868..17,873.857 rows=24,262 loops=2)

12. 45.966 12,716.867 ↓ 52.0 25,174 2 / 2

Nested Loop (cost=0.990..112,412.460 rows=484 width=826) (actual time=1.199..12,716.867 rows=25,174 loops=2)

13. 78.929 78.929 ↑ 1.1 24,498 2 / 2

Parallel Index Scan using three_echo on quebec_quebec mike_yankee_six (cost=0.430..6,144.390 rows=27,216 width=20) (actual time=0.034..78.929 rows=24,498 loops=2)

  • Index Cond: (golf_november = 2)
14. 12,591.972 12,591.972 ↑ 1.0 1 48,996 / 2

Index Scan using bravo_uniform on sierra uniform_yankee (cost=0.560..3.870 rows=1 width=846) (actual time=0.403..0.514 rows=1 loops=48,996)

  • Index Cond: ((romeo_xray)::text = (two_yankee1.romeo_xray)::text)
  • Filter: (two_yankee1.kilo_sierra_romeo = kilo_sierra_romeo)
  • Rows Removed by Filter: 1
15. 5,110.221 5,110.221 ↑ 1.0 1 50,347 / 2

Index Scan using yankee_sierra on hotel_kilo quebec_five (cost=0.560..0.650 rows=1 width=29) (actual time=0.201..0.203 rows=1 loops=50,347)

  • Index Cond: ((india_zulu)::text = (quebec_tango_tango1.india_zulu)::text)
16. 788.562 195,115.319 ↓ 58.7 7,525,754 1

Materialize (cost=1,598,118.010..1,598,759.400 rows=128,277 width=857) (actual time=186,279.569..195,115.319 rows=7,525,754 loops=1)

17. 42,222.176 194,326.757 ↓ 58.3 7,477,209 1

Sort (cost=1,598,118.010..1,598,438.700 rows=128,277 width=857) (actual time=186,279.547..194,326.757 rows=7,477,209 loops=1)

  • Sort Key: alpha_seven1.mike_yankee_yankee
  • Sort Method: external merge Disk: 1358576kB
18. 357.495 152,104.581 ↓ 58.3 7,477,209 1

Gather (cost=1,001.670..1,552,469.410 rows=128,277 width=857) (actual time=2.801..152,104.581 rows=7,477,209 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
19. 3,925.840 151,747.086 ↓ 69.9 3,738,604 2 / 2

Nested Loop (cost=1.680..1,538,641.710 rows=53,449 width=857) (actual time=54.041..151,747.086 rows=3,738,604 loops=2)

20. 8,007.016 90,246.106 ↓ 68.7 4,112,510 2 / 2

Merge Join (cost=1.120..1,497,769.470 rows=59,897 width=842) (actual time=53.913..90,246.106 rows=4,112,510 loops=2)

  • Merge Cond: ((xray_seven.romeo_xray)::text = (five_romeo.romeo_xray)::text)
  • Join Filter: (five_romeo.kilo_sierra_romeo = xray_seven.kilo_sierra_romeo)
  • Rows Removed by Join Filter: 113665
21. 13,459.405 13,459.405 ↓ 1.2 4,037,418 2 / 2

Parallel Index Scan using six_two on quebec_quebec xray_seven (cost=0.560..522,097.620 rows=3,366,184 width=20) (actual time=0.262..13,459.405 rows=4,037,418 loops=2)

  • Filter: (golf_november = 1)
  • Rows Removed by Filter: 24498
22. 68,779.685 68,779.685 ↓ 1.0 8,458,951 2 / 2

Index Scan using bravo_uniform on sierra five_romeo (cost=0.560..832,660.620 rows=8,439,442 width=846) (actual time=0.061..68,779.685 rows=8,458,951 loops=2)

23. 57,575.140 57,575.140 ↑ 1.0 1 8,225,020 / 2

Index Scan using yankee_sierra on hotel_kilo kilo_mike (cost=0.560..0.650 rows=1 width=29) (actual time=0.014..0.014 rows=1 loops=8,225,020)

  • Index Cond: ((india_zulu)::text = (five_romeo.india_zulu)::text)
24. 2.261 436,888.382 ↓ 2.0 1,574 1

Materialize (cost=42,582,951.930..43,320,108.950 rows=796 width=451) (actual time=436,771.659..436,888.382 rows=1,574 loops=1)

25. 90.317 436,886.121 ↓ 2.0 1,574 1

Merge Left Join (cost=42,582,951.930..43,320,106.960 rows=796 width=451) (actual time=436,771.649..436,886.121 rows=1,574 loops=1)

  • Merge Cond: ((five_hotel_lima.mike_yankee_yankee)::text = (tango_delta.mike_yankee_yankee)::text)
26. 5.458 14,631.456 ↓ 1.5 1,176 1

Sort (cost=716,243.110..716,245.100 rows=796 width=329) (actual time=14,630.968..14,631.456 rows=1,176 loops=1)

  • Sort Key: five_hotel_lima.mike_yankee_yankee
  • Sort Method: quicksort Memory: 621kB
27. 28.296 14,625.998 ↓ 1.5 1,176 1

Gather (cost=694,531.020..716,204.750 rows=796 width=329) (actual time=14,280.882..14,625.998 rows=1,176 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
28. 0.862 14,597.702 ↓ 1.2 392 3 / 3

Nested Loop Left Join (cost=693,531.020..715,125.150 rows=332 width=329) (actual time=14,258.687..14,597.702 rows=392 loops=3)

29. 0.629 14,439.256 ↓ 1.2 392 3 / 3

Nested Loop Left Join (cost=693,530.460..714,912.910 rows=332 width=334) (actual time=14,257.116..14,439.256 rows=392 loops=3)

30. 0.614 14,417.067 ↓ 1.2 392 3 / 3

Nested Loop Left Join (cost=693,530.040..714,759.290 rows=332 width=335) (actual time=14,254.027..14,417.067 rows=392 loops=3)

31. 0.650 14,403.517 ↓ 1.2 392 3 / 3

Nested Loop Left Join (cost=693,529.480..714,537.560 rows=332 width=326) (actual time=14,253.177..14,403.517 rows=392 loops=3)

32. 0.498 14,391.107 ↓ 1.2 392 3 / 3

Hash Left Join (cost=693,528.920..713,280.620 rows=332 width=312) (actual time=14,251.947..14,391.107 rows=392 loops=3)

  • Hash Cond: ((five_hotel_xray.bravo_three)::text = (hotel_zulu.romeo_romeo)::text)
33. 0.494 14,390.564 ↓ 1.2 392 3 / 3

Nested Loop Left Join (cost=693,526.610..713,276.930 rows=332 width=316) (actual time=14,251.861..14,390.564 rows=392 loops=3)

34. 0.312 14,355.574 ↓ 1.2 392 3 / 3

Hash Left Join (cost=693,526.180..713,107.210 rows=332 width=307) (actual time=14,250.268..14,355.574 rows=392 loops=3)

  • Hash Cond: ((kilo_sierra_mike.india_seven)::text = (golf_kilo_five.whiskey_five)::text)
35. 0.508 14,354.814 ↓ 1.2 392 3 / 3

Hash Left Join (cost=693,451.050..713,031.210 rows=332 width=283) (actual time=14,249.787..14,354.814 rows=392 loops=3)

  • Hash Cond: ((kilo_sierra_mike.seven_papa)::text = (quebec_bravo.whiskey_five)::text)
36. 0.681 14,353.700 ↓ 1.2 392 3 / 3

Nested Loop Left Join (cost=693,375.930..712,955.220 rows=332 width=269) (actual time=14,249.112..14,353.700 rows=392 loops=3)

37. 0.768 14,349.491 ↓ 1.2 392 3 / 3

Hash Left Join (cost=693,375.650..712,850.630 rows=332 width=256) (actual time=14,248.882..14,349.491 rows=392 loops=3)

  • Hash Cond: (kilo_sierra_mike.lima_quebec = golf_kilo_charlie.lima_quebec)
38. 0.724 14,348.691 ↓ 1.2 392 3 / 3

Nested Loop Left Join (cost=693,374.400..712,845.930 rows=332 width=254) (actual time=14,248.577..14,348.691 rows=392 loops=3)

39. 0.741 14,327.191 ↓ 1.2 392 3 / 3

Nested Loop (cost=693,373.010..712,296.090 rows=332 width=266) (actual time=14,248.273..14,327.191 rows=392 loops=3)

40. 1.114 14,323.943 ↑ 12.2 1,254 3 / 3

Nested Loop Left Join (cost=693,372.870..709,541.680 rows=15,247 width=252) (actual time=14,248.221..14,323.943 rows=1,254 loops=3)

41. 0.710 14,256.385 ↑ 12.2 1,254 3 / 3

Nested Loop Left Join (cost=693,372.440..702,013.300 rows=15,247 width=218) (actual time=14,248.144..14,256.385 rows=1,254 loops=3)

42. 1.002 14,249.407 ↑ 12.2 1,254 3 / 3

Merge Left Join (cost=693,372.020..693,449.680 rows=15,247 width=209) (actual time=14,248.081..14,249.407 rows=1,254 loops=3)

  • Merge Cond: ((five_hotel_lima.zulu_golf)::text = (india_two.uniform_six)::text)
43. 11.224 14,248.326 ↑ 12.2 1,254 3 / 3

Sort (cost=693,342.240..693,380.360 rows=15,247 width=161) (actual time=14,247.989..14,248.326 rows=1,254 loops=3)

  • Sort Key: five_hotel_lima.zulu_golf
  • Sort Method: quicksort Memory: 397kB
44. 6.610 14,237.102 ↑ 12.2 1,254 3 / 3

Nested Loop (cost=0.560..692,282.860 rows=15,247 width=161) (actual time=253.216..14,237.102 rows=1,254 loops=3)

45. 13,855.646 13,855.646 ↑ 12.2 1,254 3 / 3

Parallel Seq Scan on yankee_two five_hotel_lima (cost=0.000..630,391.400 rows=15,247 width=92) (actual time=252.715..13,855.646 rows=1,254 loops=3)

  • Filter: (yankee_bravo AND (juliet_charlie <> 'yankee_alpha'::bpchar) AND (five_echo(alpha_echo) >= 'bravo_golf'::date) AND (five_echo(alpha_echo) <= 'bravo_golf'::date))
  • Rows Removed by Filter: 3238981
46. 374.846 374.846 ↑ 1.0 1 3,761 / 3

Index Scan using kilo_lima on charlie_six kilo_sierra_mike (cost=0.560..4.060 rows=1 width=69) (actual time=0.299..0.299 rows=1 loops=3,761)

  • Index Cond: ((romeo_xray)::text = (five_hotel_lima.zulu_golf)::text)
47. 0.051 0.079 ↓ 0.0 0 3 / 3

Sort (cost=29.780..30.480 rows=280 width=48) (actual time=0.079..0.079 rows=0 loops=3)

  • Sort Key: india_two.uniform_six
  • Sort Method: quicksort Memory: 25kB
48. 0.028 0.028 ↓ 0.0 0 3 / 3

Seq Scan on kilo_tango india_two (cost=0.000..18.400 rows=280 width=48) (actual time=0.028..0.028 rows=0 loops=3)

49. 6.268 6.268 ↓ 0.0 0 3,761 / 3

Index Only Scan using romeo_golf on charlie_victor juliet_foxtrot (cost=0.420..0.560 rows=1 width=9) (actual time=0.005..0.005 rows=0 loops=3,761)

  • Index Cond: (mike_oscar = (five_hotel_lima.zulu_golf)::text)
  • Heap Fetches: 0
50. 66.444 66.444 ↑ 1.0 1 3,761 / 3

Index Scan using mike_five on romeo_victor five_hotel_xray (cost=0.430..0.490 rows=1 width=49) (actual time=0.053..0.053 rows=1 loops=3,761)

  • Index Cond: ((four_papa)::text = (kilo_sierra_mike.four_papa)::text)
51. 2.507 2.507 ↓ 0.0 0 3,761 / 3

Index Scan using november on foxtrot_oscar foxtrot_yankee (cost=0.140..0.180 rows=1 width=22) (actual time=0.002..0.002 rows=0 loops=3,761)

  • Index Cond: (five_four = kilo_sierra_mike.five_four)
  • Filter: ((oscar_mike)::text = 'quebec_hotel'::text)
  • Rows Removed by Filter: 1
52. 0.392 20.776 ↑ 1.0 1 1,176 / 3

Nested Loop Left Join (cost=1.390..1.630 rows=1 width=20) (actual time=0.052..0.053 rows=1 loops=1,176)

53. 0.784 12.936 ↑ 1.0 1 1,176 / 3

Nested Loop (cost=0.830..0.950 rows=1 width=20) (actual time=0.032..0.033 rows=1 loops=1,176)

54. 9.016 9.016 ↑ 1.0 1 1,176 / 3

Index Scan using six_two on quebec_quebec two_xray (cost=0.560..0.640 rows=1 width=42) (actual time=0.023..0.023 rows=1 loops=1,176)

  • Index Cond: ((romeo_xray)::text = (kilo_sierra_mike.romeo_xray)::text)
  • Filter: (golf_november = 1)
55. 3.136 3.136 ↑ 1.0 1 1,176 / 3

Index Only Scan using victor_hotel on three_foxtrot delta_juliet (cost=0.280..0.310 rows=1 width=10) (actual time=0.008..0.008 rows=1 loops=1,176)

  • Index Cond: (whiskey_five = (two_xray.golf_hotel)::text)
  • Heap Fetches: 0
56. 7.448 7.448 ↓ 0.0 0 1,176 / 3

Index Scan using six_two on quebec_quebec yankee_hotel (cost=0.560..0.640 rows=1 width=38) (actual time=0.019..0.019 rows=0 loops=1,176)

  • Index Cond: ((two_xray.romeo_xray)::text = (romeo_xray)::text)
  • Filter: (golf_november = 2)
  • Rows Removed by Filter: 1
57. 0.012 0.032 ↑ 1.0 4 3 / 3

Hash (cost=1.120..1.120 rows=4 width=6) (actual time=0.032..0.032 rows=4 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
58. 0.020 0.020 ↑ 1.0 4 3 / 3

Seq Scan on oscar_hotel golf_kilo_charlie (cost=0.000..1.120 rows=4 width=6) (actual time=0.018..0.020 rows=4 loops=3)

59. 3.528 3.528 ↑ 1.0 1 1,176 / 3

Index Scan using xray_sierra on kilo_six six_three (cost=0.280..0.320 rows=1 width=29) (actual time=0.009..0.009 rows=1 loops=1,176)

  • Index Cond: ((kilo_sierra_mike.oscar_alpha)::text = (oscar_alpha)::text)
60. 0.275 0.606 ↓ 1.0 675 3 / 3

Hash (cost=53.220..53.220 rows=674 width=34) (actual time=0.606..0.606 rows=675 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
61. 0.331 0.331 ↓ 1.0 675 3 / 3

Seq Scan on three_foxtrot quebec_bravo (cost=0.000..53.220 rows=674 width=34) (actual time=0.018..0.331 rows=675 loops=3)

62. 0.265 0.448 ↓ 1.0 675 3 / 3

Hash (cost=53.220..53.220 rows=674 width=34) (actual time=0.448..0.448 rows=675 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
63. 0.183 0.183 ↓ 1.0 675 3 / 3

Seq Scan on three_foxtrot golf_kilo_five (cost=0.000..53.220 rows=674 width=34) (actual time=0.006..0.183 rows=675 loops=3)

64. 34.496 34.496 ↑ 1.0 1 1,176 / 3

Index Scan using bravo_quebec on echo_six charlie_mike (cost=0.430..0.510 rows=1 width=17) (actual time=0.088..0.088 rows=1 loops=1,176)

  • Index Cond: (five_lima = two_xray.five_lima)
65. 0.015 0.045 ↑ 1.0 21 3 / 3

Hash (cost=1.630..1.630 rows=21 width=14) (actual time=0.045..0.045 rows=21 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
66. 0.030 0.030 ↑ 1.0 21 3 / 3

Seq Scan on alpha_yankee hotel_zulu (cost=0.000..1.630 rows=21 width=14) (actual time=0.024..0.030 rows=21 loops=3)

67. 11.760 11.760 ↑ 1.0 1 1,176 / 3

Index Scan using yankee_six on hotel_kilo six_echo (cost=0.560..3.760 rows=1 width=29) (actual time=0.029..0.030 rows=1 loops=1,176)

  • Index Cond: ((mike_yankee_yankee)::text = (five_hotel_lima.mike_yankee_yankee)::text)
68. 12.936 12.936 ↑ 1.0 1 1,176 / 3

Index Scan using romeo_charlie on sierra xray_echo (cost=0.560..0.670 rows=1 width=23) (actual time=0.033..0.033 rows=1 loops=1,176)

  • Index Cond: ((india_zulu)::text = (six_echo.india_zulu)::text)
69. 21.560 21.560 ↑ 1.0 1 1,176 / 3

Index Scan using charlie_delta on alpha_hotel seven_whiskey (cost=0.420..0.460 rows=1 width=17) (actual time=0.055..0.055 rows=1 loops=1,176)

  • Index Cond: ((lima_juliet)::text = (xray_echo.lima_juliet)::text)
  • Filter: (four_yankee = 'delta_oscar'::bpchar)
70. 157.584 157.584 ↑ 1.0 1 1,176 / 3

Index Scan using alpha_november_hotel on seven_five_hotel tango_sierra (cost=0.560..0.640 rows=1 width=23) (actual time=0.402..0.402 rows=1 loops=1,176)

  • Index Cond: ((india_zulu)::text = (xray_echo.india_zulu)::text)
71. 72.047 422,164.348 ↑ 8.0 483,111 1

Materialize (cost=41,866,708.820..42,594,151.110 rows=3,879,692 width=170) (actual time=421,803.750..422,164.348 rows=483,111 loops=1)

72. 120.852 422,092.301 ↑ 8.0 483,111 1

GroupAggregate (cost=41,866,708.820..42,468,061.120 rows=3,879,692 width=388) (actual time=421,803.744..422,092.301 rows=483,111 loops=1)

  • Group Key: tango_delta.mike_yankee_yankee, tango_delta.juliet_papa, tango_delta.alpha_november_yankee
73. 30,974.747 421,971.449 ↑ 79.4 488,557 1

Sort (cost=41,866,708.820..41,963,701.130 rows=38,796,923 width=388) (actual time=421,803.723..421,971.449 rows=488,557 loops=1)

  • Sort Key: tango_delta.mike_yankee_yankee, tango_delta.juliet_papa, tango_delta.alpha_november_yankee
  • Sort Method: external merge Disk: 415744kB
74. 838.041 390,996.702 ↑ 4.7 8,240,693 1

Subquery Scan on tango_delta (cost=30,790,173.020..32,051,073.020 rows=38,796,923 width=388) (actual time=387,426.095..390,996.702 rows=8,240,693 loops=1)

75. 30,961.492 390,158.661 ↑ 4.7 8,240,693 1

Sort (cost=30,790,173.020..30,887,165.330 rows=38,796,923 width=400) (actual time=387,426.090..390,158.661 rows=8,240,693 loops=1)

  • Sort Key: romeo_juliet.mike_yankee_yankee DESC
  • Sort Method: external merge Disk: 448680kB
76. 8,016.299 359,197.169 ↑ 4.7 8,240,693 1

Unique (cost=20,200,873.570..20,879,819.720 rows=38,796,923 width=400) (actual time=287,689.586..359,197.169 rows=8,240,693 loops=1)

77. 345,962.536 351,180.870 ↑ 1.0 38,200,977 1

Sort (cost=20,200,873.570..20,297,865.880 rows=38,796,923 width=400) (actual time=287,689.583..351,180.870 rows=38,200,977 loops=1)

  • Sort Key: romeo_juliet.mike_yankee_yankee, victor_xray.juliet_papa, victor_india.uniform_india, victor_india.seven_five_oscar, victor_india.charlie_four, victor_india.alpha_november_yankee
  • Sort Method: external merge Disk: 2075320kB
  • Index Cond: (uniform_india = quebec_xray2.uniform_india)
78. 4,847.760 4,847.760 ↑ 1.0 1 484,776

Index Only Scan using quebec_tango_four on romeo_juliet charlie_papa (cost=0.560..0.630 rows=1 width=10) (actual time=0.010..0.010 rows=1 loops=484,776)

  • Index Cond: (victor_quebec = (zulu_mike1.victor_quebec)::text)
  • Heap Fetches: 3081
79. 0.279 110.277 ↑ 1.4 222 3

Materialize (cost=27.240..1,030.340 rows=301 width=24) (actual time=2.141..36.759 rows=222 loops=3)

80. 6.813 109.998 ↑ 1.4 222 3

Merge Join (cost=27.240..1,029.590 rows=301 width=24) (actual time=2.130..36.666 rows=222 loops=3)

  • Merge Cond: (lima_two1.uniform_india = golf_romeo.uniform_india)
81. 102.555 102.555 ↑ 30.3 14,213 3

Index Scan using papa on five_six romeo_november (cost=0.420..29,736.970 rows=430,835 width=14) (actual time=1.037..34.185 rows=14,213 loops=3)

82. 0.450 0.630 ↑ 1.0 301 3

Sort (cost=26.420..27.170 rows=301 width=10) (actual time=0.146..0.210 rows=301 loops=3)

  • Sort Key: golf_romeo.uniform_india
  • Sort Method: quicksort Memory: 39kB
83. 0.180 0.180 ↑ 1.0 301 3

Seq Scan on six_india golf_romeo (cost=0.000..14.030 rows=301 width=10) (actual time=0.008..0.060 rows=301 loops=3)

84. 0.000 0.000 ↓ 0.0 0

Index Scan using quebec_tango_four on romeo_juliet lima_mike_sierra (cost=0.560..0.900 rows=1 width=24) (never executed)

  • Index Cond: ((victor_quebec)::text = (foxtrot_zulu.victor_quebec)::text)
85. 176.466 260.297 ↑ 12.0 35,192 1

Gather (cost=1,028.370..168,375.050 rows=423,979 width=42) (actual time=6.501..260.297 rows=35,192 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
86. 4.202 83.831 ↑ 15.1 11,731 3 / 3

Nested Loop (cost=28.370..124,977.150 rows=176,658 width=42) (actual time=0.567..83.831 rows=11,731 loops=3)

87. 1.953 9.245 ↑ 15.1 11,731 3 / 3

Nested Loop (cost=27.800..14,229.750 rows=176,658 width=52) (actual time=0.554..9.245 rows=11,731 loops=3)

  • Join Filter: (quebec_xray1.uniform_india = oscar_oscar1.uniform_india)
88. 0.457 2.704 ↑ 1.7 74 3 / 3

Merge Join (cost=27.240..761.240 rows=125 width=46) (actual time=0.545..2.704 rows=74 loops=3)

  • Merge Cond: (lima_two2.uniform_india = quebec_xray1.uniform_india)
89. 1.903 1.903 ↑ 37.9 4,738 3 / 3

Parallel Index Scan using papa on five_six whiskey_three (cost=0.420..22,197.360 rows=179,515 width=14) (actual time=0.083..1.903 rows=4,738 loops=3)

90. 0.176 0.344 ↑ 1.0 301 3 / 3

Sort (cost=26.420..27.170 rows=301 width=32) (actual time=0.314..0.344 rows=301 loops=3)

  • Sort Key: quebec_xray1.uniform_india
  • Sort Method: quicksort Memory: 48kB
91. 0.168 0.168 ↑ 1.0 301 3 / 3

Seq Scan on six_india romeo_four (cost=0.000..14.030 rows=301 width=32) (actual time=0.021..0.168 rows=301 loops=3)

92. 4.588 4.588 ↑ 9.2 159 222 / 3

Index Scan using four_kilo on victor_xray lima_oscar (cost=0.560..60.140 rows=1,465 width=14) (actual time=0.005..0.062 rows=159 loops=222)

  • Index Cond: (uniform_india = lima_two2.uniform_india)
93. 70.384 70.384 ↑ 1.0 1 35,192 / 3

Index Only Scan using quebec_tango_four on romeo_juliet kilo_yankee (cost=0.560..0.630 rows=1 width=10) (actual time=0.006..0.006 rows=1 loops=35,192)

  • Index Cond: (victor_quebec = (oscar_oscar1.victor_quebec)::text)
  • Heap Fetches: 0
94. 157.400 157.400 ↑ 1.0 1 1,574

Index Scan using charlie_delta on alpha_hotel xray_five (cost=0.420..0.460 rows=1 width=17) (actual time=0.100..0.100 rows=1 loops=1,574)

  • Index Cond: ((lima_juliet)::text = (tango_sierra.india_delta)::text)
Planning time : 27.646 ms
Execution time : 678,560.200 ms