explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CxGP

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 10,387.621 ↑ 2.0 1 1

Sort (cost=3,028,154.610..3,028,154.620 rows=2 width=1,291) (actual time=10,387.621..10,387.621 rows=1 loops=1)

  • Sort Key: mike_bravo."delta_foxtrot_hotel
  • Sort Method: quicksort Memory: 25kB
2. 0.187 10,387.603 ↑ 2.0 1 1

Nested Loop Left Join (cost=17.700..3,028,154.600 rows=2 width=1,291) (actual time=10,387.452..10,387.603 rows=1 loops=1)

  • Join Filter: (foxtrot_alpha."two_oscar" = mike_bravo."two_oscar")
3. 0.031 0.582 ↑ 2.0 1 1

Nested Loop Left Join (cost=17.270..157.780 rows=2 width=374) (actual time=0.436..0.582 rows=1 loops=1)

4. 0.042 0.543 ↑ 2.0 1 1

Nested Loop Left Join (cost=16.590..140.360 rows=2 width=362) (actual time=0.401..0.543 rows=1 loops=1)

5. 0.003 0.494 ↑ 2.0 1 1

Nested Loop Left Join (cost=15.900..122.940 rows=2 width=358) (actual time=0.354..0.494 rows=1 loops=1)

6. 0.004 0.482 ↑ 2.0 1 1

Nested Loop Left Join (cost=15.480..106.040 rows=2 width=311) (actual time=0.345..0.482 rows=1 loops=1)

  • Join Filter: (mike_bravo."two_oscar" = romeo1."two_oscar")
7. 0.042 0.312 ↑ 2.0 1 1

Nested Loop Left Join (cost=3.360..89.680 rows=2 width=169) (actual time=0.211..0.312 rows=1 loops=1)

8. 0.000 0.265 ↑ 2.0 1 1

Nested Loop Left Join (cost=2.670..72.260 rows=2 width=153) (actual time=0.166..0.265 rows=1 loops=1)

9. 0.003 0.256 ↑ 2.0 1 1

Nested Loop Left Join (cost=2.250..55.360 rows=2 width=106) (actual time=0.159..0.256 rows=1 loops=1)

10. 0.098 0.246 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.820..54.220 rows=2 width=106) (actual time=0.151..0.246 rows=1 loops=1)

11. 0.003 0.138 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.140..36.800 rows=2 width=86) (actual time=0.044..0.138 rows=1 loops=1)

12. 0.006 0.128 ↑ 2.0 1 1

Nested Loop Left Join (cost=0.850..20.160 rows=2 width=60) (actual time=0.036..0.128 rows=1 loops=1)

  • Join Filter: (three_tango_india."two_oscar" = mike_bravo."two_oscar")
13. 0.109 0.109 ↑ 2.0 1 1

Index Scan using lima_three on uniform_foxtrot mike_bravo (cost=0.420..11.690 rows=2 width=48) (actual time=0.019..0.109 rows=1 loops=1)

  • Index Cond: ("two_oscar" = 552065)
14. 0.003 0.013 ↑ 1.0 1 1

Materialize (cost=0.420..8.450 rows=1 width=16) (actual time=0.011..0.013 rows=1 loops=1)

15. 0.010 0.010 ↑ 1.0 1 1

Index Scan using six_foxtrot on lima_echo three_tango_india (cost=0.420..8.440 rows=1 width=16) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: ("two_oscar" = 552065)
16. 0.007 0.007 ↑ 1.0 1 1

Index Scan using mike_three on seven_lima_five xray_sierra (cost=0.290..8.310 rows=1 width=34) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: ("foxtrot_echo" = mike_bravo."foxtrot_echo")
17. 0.010 0.010 ↑ 1.0 1 1

Index Scan using juliet_echo on oscar_charlie india_five (cost=0.680..8.700 rows=1 width=24) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: ("seven_lima_whiskey" = tango_india(mike_bravo."hotel_juliet", 'five_four'::text))
18. 0.007 0.007 ↑ 1.0 1 1

Index Scan using november_four on tango_hotel xray_xray (cost=0.430..0.560 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: ("echo_november" = india_five."echo_november")
19. 0.009 0.009 ↑ 1.0 1 1

Index Scan using delta_six on papa_bravo_romeo yankee_charlie (cost=0.420..8.440 rows=1 width=55) (actual time=0.007..0.009 rows=1 loops=1)

  • Index Cond: ("yankee_golf" = mike_bravo."yankee_echo")
20. 0.005 0.005 ↑ 1.0 1 1

Index Scan using juliet_echo on oscar_charlie victor_romeo (cost=0.680..8.700 rows=1 width=20) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: ("seven_lima_whiskey" = tango_india(mike_bravo."hotel_juliet", 'echo_kilo'::text))
21. 0.005 0.166 ↑ 1.0 1 1

Materialize (cost=12.120..16.330 rows=1 width=142) (actual time=0.132..0.166 rows=1 loops=1)

22. 0.062 0.161 ↑ 1.0 1 1

Hash Right Join (cost=12.120..16.320 rows=1 width=142) (actual time=0.127..0.161 rows=1 loops=1)

  • Hash Cond: (lima_charlie."juliet_tango" = romeo1."six_hotel")
23. 0.025 0.025 ↑ 1.0 141 1

Seq Scan on two_xray lima_charlie (cost=0.000..3.410 rows=141 width=22) (actual time=0.006..0.025 rows=141 loops=1)

24. 0.004 0.074 ↑ 1.0 1 1

Hash (cost=12.110..12.110 rows=1 width=114) (actual time=0.074..0.074 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.022 0.070 ↑ 1.0 1 1

Hash Right Join (cost=8.450..12.110 rows=1 width=114) (actual time=0.061..0.070 rows=1 loops=1)

  • Hash Cond: (five_alpha."kilo_india" = romeo1."kilo_india")
26. 0.037 0.037 ↑ 1.0 120 1

Seq Scan on golf_delta five_alpha (cost=0.000..3.200 rows=120 width=17) (actual time=0.006..0.037 rows=120 loops=1)

27. 0.006 0.011 ↑ 1.0 1 1

Hash (cost=8.440..8.440 rows=1 width=105) (actual time=0.011..0.011 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 0.005 0.005 ↑ 1.0 1 1

Index Scan using six_foxtrot on lima_echo charlie_five (cost=0.420..8.440 rows=1 width=105) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: ("two_oscar" = 552065)
29. 0.009 0.009 ↑ 1.0 1 1

Index Scan using delta_six on papa_bravo_romeo six_victor (cost=0.420..8.440 rows=1 width=55) (actual time=0.007..0.009 rows=1 loops=1)

  • Index Cond: ("yankee_golf" = mike_bravo."whiskey_sierra")
30. 0.007 0.007 ↑ 1.0 1 1

Index Scan using juliet_echo on oscar_charlie tango_xray (cost=0.680..8.700 rows=1 width=8) (actual time=0.005..0.007 rows=1 loops=1)

  • Index Cond: ("seven_lima_whiskey" = tango_india(mike_bravo."hotel_juliet", 'bravo_delta'::text))
31. 0.008 0.008 ↑ 1.0 1 1

Index Scan using juliet_echo on oscar_charlie charlie_romeo (cost=0.680..8.700 rows=1 width=16) (actual time=0.004..0.008 rows=1 loops=1)

  • Index Cond: ("seven_lima_whiskey" = tango_india(mike_bravo."hotel_juliet", 'juliet_whiskey'::text))
32. 0.015 0.015 ↑ 1.0 1 1

Index Only Scan using two_whiskey on xray_six foxtrot_alpha (cost=0.430..0.540 rows=1 width=8) (actual time=0.012..0.015 rows=1 loops=1)

  • Index Cond: (("two_oscar" = 552065) AND ("three_two" = xray_xray."uniform_uniform"))
  • Heap Fetches: 1
33.          

SubPlan (forNested Loop Left Join)

34. 0.002 0.104 ↑ 1.0 1 1

Limit (cost=28.590..28.600 rows=1 width=31) (actual time=0.103..0.104 rows=1 loops=1)

35. 0.006 0.102 ↑ 1.0 1 1

Sort (cost=28.590..28.600 rows=1 width=31) (actual time=0.102..0.102 rows=1 loops=1)

  • Sort Key: india_seven."seven_tango" DESC, india_seven."uniform_november" DESC
  • Sort Method: quicksort Memory: 25kB
36. 0.036 0.096 ↑ 1.0 1 1

Nested Loop (cost=1.640..28.580 rows=1 width=31) (actual time=0.094..0.096 rows=1 loops=1)

37. 0.042 0.054 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.960..19.870 rows=1 width=35) (actual time=0.054..0.054 rows=1 loops=1)

38. 0.011 0.011 ↑ 1.0 1 1

Index Scan using oscar_victor on lima_quebec india_seven (cost=0.680..11.570 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ("seven_lima_whiskey" = tango_india(mike_bravo."hotel_juliet", 'bravo_delta'::text))
  • Filter: ("bravo_bravo" = 'delta_echo'::"victor_foxtrot")
39. 0.001 0.001 ↓ 0.0 0 1

Index Scan using lima_india on victor_charlie tango_quebec (cost=0.280..8.290 rows=1 width=27) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (india_seven."yankee_delta" = "whiskey_yankee")
40. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using juliet_echo on oscar_charlie mike_hotel (cost=0.680..8.700 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: ("seven_lima_whiskey" = tango_india(mike_bravo."hotel_juliet", 'bravo_delta'::text))
  • Heap Fetches: 1
41. 0.000 0.096 ↑ 1.0 1 1

Limit (cost=28.590..28.600 rows=1 width=31) (actual time=0.096..0.096 rows=1 loops=1)

42. 0.005 0.096 ↑ 1.0 1 1

Sort (cost=28.590..28.600 rows=1 width=31) (actual time=0.096..0.096 rows=1 loops=1)

  • Sort Key: oscar_papa."seven_tango" DESC, oscar_papa."uniform_november" DESC
  • Sort Method: quicksort Memory: 25kB
43. 0.034 0.091 ↑ 1.0 1 1

Nested Loop (cost=1.640..28.580 rows=1 width=31) (actual time=0.087..0.091 rows=1 loops=1)

44. 0.040 0.048 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.960..19.870 rows=1 width=35) (actual time=0.048..0.048 rows=1 loops=1)

45. 0.007 0.007 ↑ 1.0 1 1

Index Scan using oscar_victor on lima_quebec oscar_papa (cost=0.680..11.570 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ("seven_lima_whiskey" = tango_india(mike_bravo."hotel_juliet", 'juliet_whiskey'::text))
  • Filter: ("bravo_bravo" = 'delta_echo'::"victor_foxtrot")
46. 0.001 0.001 ↓ 0.0 0 1

Index Scan using lima_india on victor_charlie three_quebec (cost=0.280..8.290 rows=1 width=27) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (oscar_papa."yankee_delta" = "whiskey_yankee")
47. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using juliet_echo on oscar_charlie mike_six (cost=0.680..8.700 rows=1 width=4) (actual time=0.005..0.009 rows=1 loops=1)

  • Index Cond: ("seven_lima_whiskey" = tango_india(mike_bravo."hotel_juliet", 'juliet_whiskey'::text))
  • Heap Fetches: 3
48. 0.259 949.490 ↑ 1.0 1 1

Index Scan using six_foxtrot on lima_echo quebec (cost=127,337.410..127,346.190 rows=1 width=8) (actual time=949.488..949.490 rows=1 loops=1)

  • Index Cond: ("two_oscar" = romeo1."two_oscar")
49.          

Initplan (forIndex Scan)

50. 0.028 949.231 ↑ 35.0 1 1

GroupAggregate (cost=623.250..127,336.980 rows=35 width=36) (actual time=949.231..949.231 rows=1 loops=1)

  • Group Key: CASE golf_alpha."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN golf_alpha."mike_five" ELSE NULL::integer END
51. 0.026 949.203 ↑ 35.0 1 1

Hash Left Join (cost=623.250..127,336.280 rows=35 width=10) (actual time=705.897..949.203 rows=1 loops=1)

  • Hash Cond: (golf_alpha."mike_victor" = five_zulu."mike_victor")
  • Filter: ((CASE WHEN (golf_alpha."mike_victor" five_romeo NOT NULL) THEN five_zulu."kilo_uniform" WHEN ((golf_alpha."juliet_yankee" five_romeo NOT NULL) AND (NOT oscar_foxtrot."five_echo")) THEN 'echo_juliet'::character varying WHEN ((golf_alpha."juliet_yankee" five_romeo NOT NULL) AND oscar_foxtrot."five_echo") THEN 'victor_tango'::character varying ELSE golf_alpha."charlie_india" END)::text = 'echo_juliet'::text)
  • Rows Removed by Filter: 2
52. 0.112 948.572 ↑ 2,313.7 3 1

Hash Left Join (cost=588.540..127,262.410 rows=6,941 width=28) (actual time=704.232..948.572 rows=3 loops=1)

  • Hash Cond: (golf_alpha."juliet_yankee" = oscar_foxtrot."juliet_yankee")
53. 939.732 939.732 ↑ 2,313.7 3 1

Seq Scan on whiskey_tango golf_alpha (cost=0.000..126,609.310 rows=6,941 width=27) (actual time=695.401..939.732 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END five_romeo NOT NULL) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
54. 3.069 8.728 ↑ 1.0 11,503 1

Hash (cost=444.350..444.350 rows=11,535 width=5) (actual time=8.728..8.728 rows=11,503 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 544kB
55. 5.659 5.659 ↑ 1.0 11,503 1

Seq Scan on three_tango_mike oscar_foxtrot (cost=0.000..444.350 rows=11,535 width=5) (actual time=0.137..5.659 rows=11,503 loops=1)

56. 0.224 0.605 ↓ 1.0 880 1

Hash (cost=23.760..23.760 rows=876 width=9) (actual time=0.605..0.605 rows=880 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
57. 0.381 0.381 ↓ 1.0 880 1

Seq Scan on victor_bravo five_zulu (cost=0.000..23.760 rows=876 width=9) (actual time=0.005..0.381 rows=880 loops=1)

58. 0.024 951.522 ↑ 69.0 1 1

GroupAggregate (cost=623.250..127,337.750 rows=69 width=36) (actual time=951.522..951.522 rows=1 loops=1)

  • Group Key: CASE seven_bravo1."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo1."mike_five" ELSE NULL::integer END
59. 0.031 951.498 ↑ 34.5 2 1

Hash Left Join (cost=623.250..127,336.370 rows=69 width=10) (actual time=708.002..951.498 rows=2 loops=1)

  • Hash Cond: (seven_bravo1."mike_victor" = delta_seven1."mike_victor")
  • Filter: ((CASE WHEN (seven_bravo1."mike_victor" five_romeo NOT NULL) THEN delta_seven1."kilo_uniform" WHEN ((seven_bravo1."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey1."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo1."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey1."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo1."charlie_india" END)::text = ANY ('two_hotel'::text[]))
  • Rows Removed by Filter: 1
60. 0.119 950.859 ↑ 2,313.7 3 1

Hash Left Join (cost=588.540..127,262.410 rows=6,941 width=28) (actual time=707.367..950.859 rows=3 loops=1)

  • Hash Cond: (seven_bravo1."juliet_yankee" = bravo_whiskey1."juliet_yankee")
61. 942.116 942.116 ↑ 2,313.7 3 1

Seq Scan on whiskey_tango foxtrot_tango (cost=0.000..126,609.310 rows=6,941 width=27) (actual time=698.633..942.116 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END five_romeo NOT NULL) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
62. 3.063 8.624 ↑ 1.0 11,503 1

Hash (cost=444.350..444.350 rows=11,535 width=5) (actual time=8.624..8.624 rows=11,503 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 544kB
63. 5.561 5.561 ↑ 1.0 11,503 1

Seq Scan on three_tango_mike whiskey_golf (cost=0.000..444.350 rows=11,535 width=5) (actual time=0.136..5.561 rows=11,503 loops=1)

64. 0.226 0.608 ↓ 1.0 880 1

Hash (cost=23.760..23.760 rows=876 width=9) (actual time=0.608..0.608 rows=880 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 44kB
65. 0.382 0.382 ↓ 1.0 880 1

Seq Scan on victor_bravo foxtrot_romeo (cost=0.000..23.760 rows=876 width=9) (actual time=0.007..0.382 rows=880 loops=1)

66. 0.002 992.946 ↓ 0.0 0 1

GroupAggregate (cost=623.250..127,347.960 rows=1 width=36) (actual time=992.946..992.946 rows=0 loops=1)

  • Group Key: CASE seven_bravo2."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo2."mike_five" ELSE NULL::integer END
67. 0.028 992.944 ↓ 0.0 0 1

Hash Left Join (cost=623.250..127,347.940 rows=1 width=10) (actual time=992.944..992.944 rows=0 loops=1)

  • Hash Cond: (seven_bravo2."mike_victor" = delta_seven2."mike_victor")
  • Filter: (((CASE WHEN (seven_bravo2."mike_victor" five_romeo NOT NULL) THEN delta_seven2."kilo_uniform" WHEN ((seven_bravo2."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey2."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo2."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey2."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo2."charlie_india" END)::text = ANY ('zulu_two'::text[])) AND (CASE WHEN ((CASE WHEN (seven_bravo2."mike_victor" five_romeo NOT NULL) THEN delta_seven2."kilo_uniform" WHEN ((seven_bravo2."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey2."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo2."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey2."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo2."charlie_india" END)::text = 'victor_tango'::text) THEN "golf_mike"((bravo_whiskey2."november_yankee")::text, 1) ELSE "golf_mike"((delta_seven2."sierra")::text, 1) END = 'four'::text))
  • Rows Removed by Filter: 3
68. 0.133 992.255 ↑ 2,313.7 3 1

Hash Left Join (cost=588.540..127,262.410 rows=6,941 width=47) (actual time=745.625..992.255 rows=3 loops=1)

  • Hash Cond: (seven_bravo2."juliet_yankee" = bravo_whiskey2."juliet_yankee")
69. 982.525 982.525 ↑ 2,313.7 3 1

Seq Scan on whiskey_tango tango_six (cost=0.000..126,609.310 rows=6,941 width=27) (actual time=735.905..982.525 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END five_romeo NOT NULL) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
70. 3.765 9.597 ↑ 1.0 11,503 1

Hash (cost=444.350..444.350 rows=11,535 width=24) (actual time=9.597..9.597 rows=11,503 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 759kB
71. 5.832 5.832 ↑ 1.0 11,503 1

Seq Scan on three_tango_mike six_seven (cost=0.000..444.350 rows=11,535 width=24) (actual time=0.137..5.832 rows=11,503 loops=1)

72. 0.278 0.661 ↓ 1.0 880 1

Hash (cost=23.760..23.760 rows=876 width=23) (actual time=0.661..0.661 rows=880 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
73. 0.383 0.383 ↓ 1.0 880 1

Seq Scan on victor_bravo golf_charlie (cost=0.000..23.760 rows=876 width=23) (actual time=0.007..0.383 rows=880 loops=1)

74. 0.003 1,022.759 ↓ 0.0 0 1

GroupAggregate (cost=623.250..127,347.960 rows=1 width=36) (actual time=1,022.759..1,022.759 rows=0 loops=1)

  • Group Key: CASE seven_bravo3."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo3."mike_five" ELSE NULL::integer END
75. 0.035 1,022.756 ↓ 0.0 0 1

Hash Left Join (cost=623.250..127,347.940 rows=1 width=10) (actual time=1,022.756..1,022.756 rows=0 loops=1)

  • Hash Cond: (seven_bravo3."mike_victor" = delta_seven3."mike_victor")
  • Filter: (((CASE WHEN (seven_bravo3."mike_victor" five_romeo NOT NULL) THEN delta_seven3."kilo_uniform" WHEN ((seven_bravo3."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey3."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo3."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey3."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo3."charlie_india" END)::text = ANY ('zulu_two'::text[])) AND (CASE WHEN ((CASE WHEN (seven_bravo3."mike_victor" five_romeo NOT NULL) THEN delta_seven3."kilo_uniform" WHEN ((seven_bravo3."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey3."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo3."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey3."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo3."charlie_india" END)::text = 'victor_tango'::text) THEN "golf_mike"((bravo_whiskey3."november_yankee")::text, 1) ELSE "golf_mike"((delta_seven3."sierra")::text, 1) END = 'oscar_yankee'::text))
  • Rows Removed by Filter: 3
76. 0.134 1,022.042 ↑ 2,313.7 3 1

Hash Left Join (cost=588.540..127,262.410 rows=6,941 width=47) (actual time=769.650..1,022.042 rows=3 loops=1)

  • Hash Cond: (seven_bravo3."juliet_yankee" = bravo_whiskey3."juliet_yankee")
77. 1,012.466 1,012.466 ↑ 2,313.7 3 1

Seq Scan on whiskey_tango charlie_three (cost=0.000..126,609.310 rows=6,941 width=27) (actual time=760.084..1,012.466 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END five_romeo NOT NULL) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
78. 3.728 9.442 ↑ 1.0 11,503 1

Hash (cost=444.350..444.350 rows=11,535 width=24) (actual time=9.442..9.442 rows=11,503 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 759kB
79. 5.714 5.714 ↑ 1.0 11,503 1

Seq Scan on three_tango_mike tango_lima (cost=0.000..444.350 rows=11,535 width=24) (actual time=0.135..5.714 rows=11,503 loops=1)

80. 0.286 0.679 ↓ 1.0 880 1

Hash (cost=23.760..23.760 rows=876 width=23) (actual time=0.679..0.679 rows=880 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
81. 0.393 0.393 ↓ 1.0 880 1

Seq Scan on victor_bravo foxtrot_quebec (cost=0.000..23.760 rows=876 width=23) (actual time=0.008..0.393 rows=880 loops=1)

82. 0.003 971.167 ↓ 0.0 0 1

GroupAggregate (cost=623.250..127,347.960 rows=1 width=36) (actual time=971.167..971.167 rows=0 loops=1)

  • Group Key: CASE seven_bravo4."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo4."mike_five" ELSE NULL::integer END
83. 0.032 971.164 ↓ 0.0 0 1

Hash Left Join (cost=623.250..127,347.940 rows=1 width=10) (actual time=971.164..971.164 rows=0 loops=1)

  • Hash Cond: (seven_bravo4."mike_victor" = delta_seven4."mike_victor")
  • Filter: (((CASE WHEN (seven_bravo4."mike_victor" five_romeo NOT NULL) THEN delta_seven4."kilo_uniform" WHEN ((seven_bravo4."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey4."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo4."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey4."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo4."charlie_india" END)::text = ANY ('zulu_two'::text[])) AND (CASE WHEN ((CASE WHEN (seven_bravo4."mike_victor" five_romeo NOT NULL) THEN delta_seven4."kilo_uniform" WHEN ((seven_bravo4."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey4."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo4."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey4."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo4."charlie_india" END)::text = 'victor_tango'::text) THEN "golf_mike"((bravo_whiskey4."november_yankee")::text, 1) ELSE "golf_mike"((delta_seven4."sierra")::text, 1) END = 'kilo_oscar'::text))
  • Rows Removed by Filter: 3
84. 0.115 970.465 ↑ 2,313.7 3 1

Hash Left Join (cost=588.540..127,262.410 rows=6,941 width=47) (actual time=726.581..970.465 rows=3 loops=1)

  • Hash Cond: (seven_bravo4."juliet_yankee" = bravo_whiskey4."juliet_yankee")
85. 961.031 961.031 ↑ 2,313.7 3 1

Seq Scan on whiskey_tango whiskey_delta (cost=0.000..126,609.310 rows=6,941 width=27) (actual time=717.157..961.031 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END five_romeo NOT NULL) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
86. 3.725 9.319 ↑ 1.0 11,503 1

Hash (cost=444.350..444.350 rows=11,535 width=24) (actual time=9.319..9.319 rows=11,503 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 759kB
87. 5.594 5.594 ↑ 1.0 11,503 1

Seq Scan on three_tango_mike kilo_three (cost=0.000..444.350 rows=11,535 width=24) (actual time=0.126..5.594 rows=11,503 loops=1)

88. 0.282 0.667 ↓ 1.0 880 1

Hash (cost=23.760..23.760 rows=876 width=23) (actual time=0.667..0.667 rows=880 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
89. 0.385 0.385 ↓ 1.0 880 1

Seq Scan on victor_bravo foxtrot_three (cost=0.000..23.760 rows=876 width=23) (actual time=0.007..0.385 rows=880 loops=1)

90. 0.003 819.889 ↓ 0.0 0 1

GroupAggregate (cost=623.250..127,347.960 rows=1 width=36) (actual time=819.889..819.889 rows=0 loops=1)

  • Group Key: CASE seven_bravo5."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo5."mike_five" ELSE NULL::integer END
91. 0.032 819.886 ↓ 0.0 0 1

Hash Left Join (cost=623.250..127,347.940 rows=1 width=10) (actual time=819.886..819.886 rows=0 loops=1)

  • Hash Cond: (seven_bravo5."mike_victor" = delta_seven5."mike_victor")
  • Filter: (((CASE WHEN (seven_bravo5."mike_victor" five_romeo NOT NULL) THEN delta_seven5."kilo_uniform" WHEN ((seven_bravo5."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey5."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo5."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey5."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo5."charlie_india" END)::text = ANY ('zulu_two'::text[])) AND (CASE WHEN ((CASE WHEN (seven_bravo5."mike_victor" five_romeo NOT NULL) THEN delta_seven5."kilo_uniform" WHEN ((seven_bravo5."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey5."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo5."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey5."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo5."charlie_india" END)::text = 'victor_tango'::text) THEN "golf_mike"((bravo_whiskey5."november_yankee")::text, 1) ELSE "golf_mike"((delta_seven5."sierra")::text, 1) END = 'golf_november'::text))
  • Rows Removed by Filter: 3
92. 0.119 819.293 ↑ 2,313.7 3 1

Hash Left Join (cost=588.540..127,262.410 rows=6,941 width=47) (actual time=647.224..819.293 rows=3 loops=1)

  • Hash Cond: (seven_bravo5."juliet_yankee" = bravo_whiskey5."juliet_yankee")
93. 812.596 812.596 ↑ 2,313.7 3 1

Seq Scan on whiskey_tango golf_quebec (cost=0.000..126,609.310 rows=6,941 width=27) (actual time=640.536..812.596 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END five_romeo NOT NULL) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
94. 2.645 6.578 ↑ 1.0 11,503 1

Hash (cost=444.350..444.350 rows=11,535 width=24) (actual time=6.578..6.578 rows=11,503 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 759kB
95. 3.933 3.933 ↑ 1.0 11,503 1

Seq Scan on three_tango_mike delta_charlie (cost=0.000..444.350 rows=11,535 width=24) (actual time=0.132..3.933 rows=11,503 loops=1)

96. 0.240 0.561 ↓ 1.0 880 1

Hash (cost=23.760..23.760 rows=876 width=23) (actual time=0.561..0.561 rows=880 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
97. 0.321 0.321 ↓ 1.0 880 1

Seq Scan on victor_bravo six_uniform (cost=0.000..23.760 rows=876 width=23) (actual time=0.006..0.321 rows=880 loops=1)

98. 0.002 804.823 ↓ 0.0 0 1

GroupAggregate (cost=623.250..127,347.960 rows=1 width=36) (actual time=804.823..804.823 rows=0 loops=1)

  • Group Key: CASE seven_bravo6."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo6."mike_five" ELSE NULL::integer END
99. 0.025 804.821 ↓ 0.0 0 1

Hash Left Join (cost=623.250..127,347.940 rows=1 width=10) (actual time=804.821..804.821 rows=0 loops=1)

  • Hash Cond: (seven_bravo6."mike_victor" = delta_seven6."mike_victor")
  • Filter: (((CASE WHEN (seven_bravo6."mike_victor" five_romeo NOT NULL) THEN delta_seven6."kilo_uniform" WHEN ((seven_bravo6."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey6."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo6."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey6."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo6."charlie_india" END)::text = ANY ('zulu_two'::text[])) AND (CASE WHEN ((CASE WHEN (seven_bravo6."mike_victor" five_romeo NOT NULL) THEN delta_seven6."kilo_uniform" WHEN ((seven_bravo6."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey6."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo6."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey6."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo6."charlie_india" END)::text = 'victor_tango'::text) THEN "golf_mike"((bravo_whiskey6."november_yankee")::text, 1) ELSE "golf_mike"((delta_seven6."sierra")::text, 1) END = 'kilo_tango'::text))
  • Rows Removed by Filter: 3
100. 0.097 804.429 ↑ 2,313.7 3 1

Hash Left Join (cost=588.540..127,262.410 rows=6,941 width=47) (actual time=575.771..804.429 rows=3 loops=1)

  • Hash Cond: (seven_bravo6."juliet_yankee" = bravo_whiskey6."juliet_yankee")
101. 799.161 799.161 ↑ 2,313.7 3 1

Seq Scan on whiskey_tango victor_quebec (cost=0.000..126,609.310 rows=6,941 width=27) (actual time=570.513..799.161 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END five_romeo NOT NULL) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
102. 2.128 5.171 ↑ 1.0 11,503 1

Hash (cost=444.350..444.350 rows=11,535 width=24) (actual time=5.171..5.171 rows=11,503 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 759kB
103. 3.043 3.043 ↑ 1.0 11,503 1

Seq Scan on three_tango_mike hotel_foxtrot (cost=0.000..444.350 rows=11,535 width=24) (actual time=0.094..3.043 rows=11,503 loops=1)

104. 0.141 0.367 ↓ 1.0 880 1

Hash (cost=23.760..23.760 rows=876 width=23) (actual time=0.367..0.367 rows=880 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
105. 0.226 0.226 ↓ 1.0 880 1

Seq Scan on victor_bravo delta_foxtrot_lima (cost=0.000..23.760 rows=876 width=23) (actual time=0.004..0.226 rows=880 loops=1)

106. 0.003 629.145 ↓ 0.0 0 1

GroupAggregate (cost=623.250..127,347.960 rows=1 width=36) (actual time=629.145..629.145 rows=0 loops=1)

  • Group Key: CASE seven_bravo7."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo7."mike_five" ELSE NULL::integer END
107. 0.023 629.142 ↓ 0.0 0 1

Hash Left Join (cost=623.250..127,347.940 rows=1 width=10) (actual time=629.142..629.142 rows=0 loops=1)

  • Hash Cond: (seven_bravo7."mike_victor" = delta_seven7."mike_victor")
  • Filter: (((CASE WHEN (seven_bravo7."mike_victor" five_romeo NOT NULL) THEN delta_seven7."kilo_uniform" WHEN ((seven_bravo7."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey7."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo7."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey7."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo7."charlie_india" END)::text = ANY ('zulu_two'::text[])) AND (CASE WHEN ((CASE WHEN (seven_bravo7."mike_victor" five_romeo NOT NULL) THEN delta_seven7."kilo_uniform" WHEN ((seven_bravo7."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey7."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo7."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey7."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo7."charlie_india" END)::text = 'victor_tango'::text) THEN "golf_mike"((bravo_whiskey7."november_yankee")::text, 1) ELSE "golf_mike"((delta_seven7."sierra")::text, 1) END = 'charlie_mike'::text))
  • Rows Removed by Filter: 3
108. 0.107 628.763 ↑ 2,313.7 3 1

Hash Left Join (cost=588.540..127,262.410 rows=6,941 width=47) (actual time=493.295..628.763 rows=3 loops=1)

  • Hash Cond: (seven_bravo7."juliet_yankee" = bravo_whiskey7."juliet_yankee")
109. 621.672 621.672 ↑ 2,313.7 3 1

Seq Scan on whiskey_tango two_charlie (cost=0.000..126,609.310 rows=6,941 width=27) (actual time=486.209..621.672 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END five_romeo NOT NULL) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
110. 2.750 6.984 ↑ 1.0 11,503 1

Hash (cost=444.350..444.350 rows=11,535 width=24) (actual time=6.984..6.984 rows=11,503 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 759kB
111. 4.234 4.234 ↑ 1.0 11,503 1

Seq Scan on three_tango_mike india_two (cost=0.000..444.350 rows=11,535 width=24) (actual time=0.131..4.234 rows=11,503 loops=1)

112. 0.149 0.356 ↓ 1.0 880 1

Hash (cost=23.760..23.760 rows=876 width=23) (actual time=0.356..0.356 rows=880 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
113. 0.207 0.207 ↓ 1.0 880 1

Seq Scan on victor_bravo november_five (cost=0.000..23.760 rows=876 width=23) (actual time=0.005..0.207 rows=880 loops=1)

114. 0.001 537.960 ↓ 0.0 0 1

GroupAggregate (cost=623.250..127,355.430 rows=101 width=36) (actual time=537.960..537.960 rows=0 loops=1)

  • Group Key: CASE seven_bravo8."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo8."mike_five" ELSE NULL::integer END
115. 0.028 537.959 ↓ 0.0 0 1

Hash Left Join (cost=623.250..127,353.410 rows=101 width=10) (actual time=537.959..537.959 rows=0 loops=1)

  • Hash Cond: (seven_bravo8."mike_victor" = delta_seven8."mike_victor")
  • Filter: (((CASE WHEN (seven_bravo8."mike_victor" five_romeo NOT NULL) THEN delta_seven8."kilo_uniform" WHEN ((seven_bravo8."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey8."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo8."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey8."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo8."charlie_india" END)::text = ANY ('zulu_two'::text[])) AND (CASE WHEN ((CASE WHEN (seven_bravo8."mike_victor" five_romeo NOT NULL) THEN delta_seven8."kilo_uniform" WHEN ((seven_bravo8."juliet_yankee" five_romeo NOT NULL) AND (NOT bravo_whiskey8."five_echo")) THEN 'echo_juliet'::character varying WHEN ((seven_bravo8."juliet_yankee" five_romeo NOT NULL) AND bravo_whiskey8."five_echo") THEN 'victor_tango'::character varying ELSE seven_bravo8."charlie_india" END)::text = 'victor_tango'::text) THEN "golf_mike"((bravo_whiskey8."november_yankee")::text, 1) ELSE "golf_mike"((delta_seven8."sierra")::text, 1) END <> november_november ('kilo_juliet'::text[])))
  • Rows Removed by Filter: 3
116. 0.101 537.565 ↑ 2,313.7 3 1

Hash Left Join (cost=588.540..127,262.410 rows=6,941 width=47) (actual time=371.355..537.565 rows=3 loops=1)

  • Hash Cond: (seven_bravo8."juliet_yankee" = bravo_whiskey8."juliet_yankee")
117. 532.282 532.282 ↑ 2,313.7 3 1

Seq Scan on whiskey_tango yankee_tango (cost=0.000..126,609.310 rows=6,941 width=27) (actual time=366.080..532.282 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END five_romeo NOT NULL) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
118. 2.167 5.182 ↑ 1.0 11,503 1

Hash (cost=444.350..444.350 rows=11,535 width=24) (actual time=5.182..5.182 rows=11,503 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 759kB
119. 3.015 3.015 ↑ 1.0 11,503 1

Seq Scan on three_tango_mike papa_bravo_three (cost=0.000..444.350 rows=11,535 width=24) (actual time=0.095..3.015 rows=11,503 loops=1)

120. 0.144 0.366 ↓ 1.0 880 1

Hash (cost=23.760..23.760 rows=876 width=23) (actual time=0.366..0.366 rows=880 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 57kB
121. 0.222 0.222 ↓ 1.0 880 1

Seq Scan on victor_bravo lima_six (cost=0.000..23.760 rows=876 width=23) (actual time=0.006..0.222 rows=880 loops=1)

122. 0.310 920.162 ↑ 6,899.0 1 1

GroupAggregate (cost=0.000..121,393.680 rows=6,899 width=8) (actual time=920.162..920.162 rows=1 loops=1)

  • Group Key: CASE seven_bravo9."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo9."mike_five" ELSE NULL::integer END
123. 919.852 919.852 ↑ 2,325.3 3 1

Seq Scan on whiskey_tango papa_oscar (cost=0.000..119,528.570 rows=6,976 width=76) (actual time=694.869..919.852 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
124. 0.014 923.858 ↑ 6,311.0 1 1

GroupAggregate (cost=0.000..126,751.790 rows=6,311 width=36) (actual time=923.858..923.858 rows=1 loops=1)

  • Group Key: CASE seven_bravo10."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo10."mike_five" ELSE NULL::integer END
125. 923.844 923.844 ↑ 3,187.5 2 1

Seq Scan on whiskey_tango victor_echo (cost=0.000..126,625.250 rows=6,375 width=10) (actual time=692.302..923.844 rows=2 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (("charlie_india" five_romeo NULL) OR (("charlie_india")::text <> 'victor_zulu'::text)) AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846347
126. 0.043 862.898 ↑ 6,899.0 1 1

GroupAggregate (cost=0.000..119,666.930 rows=6,899 width=36) (actual time=862.898..862.898 rows=1 loops=1)

  • Group Key: CASE seven_bravo11."zulu_yankee" WHEN 'three_november'::"lima_mike" THEN seven_bravo11."mike_five" ELSE NULL::integer END
127. 862.855 862.855 ↑ 2,325.3 3 1

Seq Scan on whiskey_tango yankee_whiskey (cost=0.000..119,528.570 rows=6,976 width=10) (actual time=618.454..862.855 rows=3 loops=1)

  • Filter: ((NOT "bravo_hotel") AND (CASE "zulu_yankee" WHEN 'three_november'::"lima_mike" THEN "mike_five" ELSE NULL::integer END = mike_bravo."two_oscar"))
  • Rows Removed by Filter: 2846346
Planning time : 18.553 ms
Execution time : 10,390.746 ms