explain.depesz.com

A tool for finding a real cause for slow queries.

Result: OoN

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

Subquery Scan vieweligibleterminaloffers_enterprise (cost=96498724.330..96519744.880 rows=27749 width=30) (actual time=.. rows= loops=)

  • Filter: (four_quebec.two_juliet = ANY ('four_india'::integer[]))
2. 0.000 0.000 ↓ 0.0
→

Sort (cost=96498724.330..96501527.070 rows=1121096 width=30) (actual time=.. rows= loops=)

  • Sort Key: *uniform_sierra* 1 .kilo_six, *uniform_sierra* 1 .delta_sierra, *uniform_sierra* 1 .two_victor, *uniform_sierra* 1 .two_juliet, *uniform_sierra* 1 .papa_foxtrot, *uniform_sierra* 1 .hotel, *uniform_sierra* 1 .xray, *uniform_sierra* 1 .papa_yankee, *uniform_sierra* 1 .seven
3. 0.000 0.000 ↓ 0.0
→

HashSetOp Except (cost=96295572.880..96386073.920 rows=1121096 width=30) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Append (cost=96295572.880..96360747.950 rows=1125599 width=30) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0
→

Subquery Scan *SELECT* 1 (cost=96295572.880..96334811.240 rows=1121096 width=30) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Unique (cost=96295572.880..96323600.280 rows=1121096 width=30) (actual time=.. rows= loops=)

7.          

Initplan (forUnique)
8. 0.000 0.000 ↓ 0.0
→

Seq Scan on juliet (cost=0.000..1.020 rows=1 width=4) (actual time=.. rows= loops=)

  • Filter: three_kilo
9. 0.000 0.000 ↓ 0.0
→

Sort (cost=96295571.860..96298374.600 rows=1121096 width=30) (actual time=.. rows= loops=)

  • Sort Key: alpha_seven.kilo_six, romeo.delta_sierra, five_three.two_victor, alpha_quebec.two_juliet, alpha_quebec.papa_foxtrot, alpha_quebec.hotel, alpha_quebec.xray, alpha_quebec.papa_yankee, (lima_sierra(alpha_quebec.seven, 0))
10. 0.000 0.000 ↓ 0.0
→

Merge Right Join (cost=860245.210..96182921.450 rows=1121096 width=30) (actual time=.. rows= loops=)

  • Merge Cond: ((golf_echo.zulu_uniform = six.zulu_uniform) AND (golf_echo.kilo_six = alpha_seven.kilo_six))
  • Filter: ((golf_echo.bravo_papa five_romeo NOT NULL) OR ((six.victor_oscar_two = victor_zulu'four_uniform':: alpha_juliet ) AND (NOT (three_delta: delta_four_zulu 1 or mike_mike delta_four_zulu 2))))
11. 0.000 0.000 ↓ 0.0
→

Index Scan using lima_golf on tango_seven golf_echo (cost=0.000..51128.840 rows=1076495 width=12) (actual time=.. rows= loops=)

12. 0.000 0.000 ↓ 0.0
→

Sort (cost=860245.210..863047.950 rows=1121096 width=40) (actual time=.. rows= loops=)

  • Sort Key: six.zulu_uniform, alpha_seven.kilo_six
13. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=754.330..747594.810 rows=1121096 width=40) (actual time=.. rows= loops=)

  • Join Filter: (((alpha_quebec.kilo_whiskey)::timestamp with time zone <= two_whiskey(five_echo(charlie((alpha_seven.charlie)::text, zulu_golf())))) AND ((alpha_quebec.quebec_mike)::timestamp with time zone >= two_whiskey(five_echo(charlie((alpha_seven.charlie)::text, zulu_golf())))))
14. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=625.530..242904.860 rows=2241 width=52) (actual time=.. rows= loops=)

15. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=625.530..241952.040 rows=2241 width=56) (actual time=.. rows= loops=)

  • Join Filter: ((romeo.delta_sierra = whiskey_papa.delta_sierra) OR ((romeo.echo_oscar = 0) AND (whiskey_papa.delta_sierra = $4)))
16. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=624.510..241889.390 rows=2241 width=56) (actual time=.. rows= loops=)

17. 0.000 0.000 ↓ 0.0
→

Merge Join (cost=624.510..721.700 rows=4459 width=22) (actual time=.. rows= loops=)

  • Merge Cond: (six.zulu_uniform = mike_zulu.zulu_uniform)
18. 0.000 0.000 ↓ 0.0
→

Index Scan using four_four on bravo_hotel six (cost=0.000..29.150 rows=460 width=10) (actual time=.. rows= loops=)

19. 0.000 0.000 ↓ 0.0
→

Sort (cost=624.510..635.660 rows=4459 width=16) (actual time=.. rows= loops=)

  • Sort Key: mike_zulu.zulu_uniform
20. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=125.260..354.240 rows=4459 width=16) (actual time=.. rows= loops=)

  • Hash Cond: (mike_zulu.golf_tango = whiskey_papa.two_juliet)
21. 0.000 0.000 ↓ 0.0
→

Seq Scan on india mike_zulu (cost=0.000..144.810 rows=5277 width=8) (actual time=.. rows= loops=)

  • Filter: (oscar = victor_zulu'november_golf':: alpha_juliet )
22. 0.000 0.000 ↓ 0.0
→

Hash (cost=69.560..69.560 rows=4456 width=8) (actual time=.. rows= loops=)

23. 0.000 0.000 ↓ 0.0
→

Seq Scan on three_tango whiskey_papa (cost=0.000..69.560 rows=4456 width=8) (actual time=.. rows= loops=)

24. 0.000 0.000 ↓ 0.0
→

Index Scan using tango_two on delta_four_charlie alpha_quebec (cost=0.000..54.070 rows=1 width=34) (actual time=.. rows= loops=)

  • Index Cond: (alpha_quebec.two_juliet = whiskey_papa.two_juliet)
  • Filter: ((lima_sierra(alpha_quebec.uniform_two, 1) = 1) OR (three_delta: delta_four_zulu 4 or mike_mike delta_four_zulu 5))
25.          

SubPlan (forIndex Scan)
26. 0.000 0.000 ↓ 0.0
→

Seq Scan on echo_sierra foxtrot (cost=0.000..53.650 rows=1 width=0) (actual time=.. rows= loops=)

  • Filter: ((two_juliet = $0) AND ((quebec_november)::double precision = echo_tango('papa_sierra'::text, zulu_golf())))
27. 0.000 0.000 ↓ 0.0
→

Seq Scan on echo_sierra foxtrot (cost=0.000..48.800 rows=10 width=4) (actual time=.. rows= loops=)

  • Filter: ((quebec_november)::double precision = echo_tango('papa_sierra'::text, zulu_golf()))
28. 0.000 0.000 ↓ 0.0
→

Materialize (cost=1.020..1.030 rows=1 width=8) (actual time=.. rows= loops=)

29. 0.000 0.000 ↓ 0.0
→

Seq Scan on juliet romeo (cost=0.000..1.020 rows=1 width=8) (actual time=.. rows= loops=)

  • Filter: (NOT three_kilo)
30. 0.000 0.000 ↓ 0.0
→

Index Scan using four_whiskey on november_whiskey five_three (cost=0.000..0.410 rows=1 width=8) (actual time=.. rows= loops=)

  • Index Cond: (five_three.two_juliet = alpha_quebec.two_juliet)
31. 0.000 0.000 ↓ 0.0
→

Materialize (cost=128.790..173.820 rows=4503 width=12) (actual time=.. rows= loops=)

32. 0.000 0.000 ↓ 0.0
→

Seq Scan on tango_mike alpha_seven (cost=0.000..124.290 rows=4503 width=12) (actual time=.. rows= loops=)

  • Filter: (NOT whiskey_seven)
33.          

SubPlan (forMerge Right Join)
34. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..172.380 rows=1 width=0) (actual time=.. rows= loops=)

35. 0.000 0.000 ↓ 0.0
→

Seq Scan on india zulu_romeo (cost=0.000..163.970 rows=1 width=4) (actual time=.. rows= loops=)

  • Filter: ((golf_tango = $0) AND (oscar = victor_zulu'four_uniform':: alpha_juliet ))
36. 0.000 0.000 ↓ 0.0
→

Index Scan using lima_golf on tango_seven victor_oscar_bravo (cost=0.000..8.390 rows=1 width=4) (actual time=.. rows= loops=)

  • Index Cond: ((victor_oscar_bravo.zulu_uniform = zulu_romeo.zulu_uniform) AND (victor_oscar_bravo.kilo_six = $1))
37. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=30040.140..111039.630 rows=6264021 width=8) (actual time=.. rows= loops=)

  • Hash Cond: (zulu_romeo.zulu_uniform = victor_oscar_bravo.zulu_uniform)
38. 0.000 0.000 ↓ 0.0
→

Seq Scan on india zulu_romeo (cost=0.000..144.810 rows=2388 width=8) (actual time=.. rows= loops=)

  • Filter: (oscar = victor_zulu'four_uniform':: alpha_juliet )
39. 0.000 0.000 ↓ 0.0
→

Hash (cost=16583.950..16583.950 rows=1076495 width=8) (actual time=.. rows= loops=)

40. 0.000 0.000 ↓ 0.0
→

Seq Scan on tango_seven victor_oscar_bravo (cost=0.000..16583.950 rows=1076495 width=8) (actual time=.. rows= loops=)

41. 0.000 0.000 ↓ 0.0
→

Subquery Scan *SELECT* 2 (cost=25779.100..25936.700 rows=4503 width=30) (actual time=.. rows= loops=)

42. 0.000 0.000 ↓ 0.0
→

Unique (cost=25779.100..25891.670 rows=4503 width=30) (actual time=.. rows= loops=)

43. 0.000 0.000 ↓ 0.0
→

Sort (cost=25779.100..25790.360 rows=4503 width=30) (actual time=.. rows= loops=)

  • Sort Key: alpha_seven.kilo_six, romeo.delta_sierra, five_three.two_victor, alpha_quebec.two_juliet, alpha_quebec.papa_foxtrot, alpha_quebec.hotel, alpha_quebec.xray, alpha_quebec.papa_yankee, (lima_sierra(alpha_quebec.seven, 0))
44. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=0.000..25505.840 rows=4503 width=30) (actual time=.. rows= loops=)

45. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..478.230 rows=4503 width=34) (actual time=.. rows= loops=)

46. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..308.910 rows=1 width=30) (actual time=.. rows= loops=)

47. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..300.630 rows=1 width=34) (actual time=.. rows= loops=)

  • Join Filter: (whiskey_papa.delta_sierra = romeo.delta_sierra)
48. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..299.590 rows=1 width=34) (actual time=.. rows= loops=)

49. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..299.300 rows=1 width=34) (actual time=.. rows= loops=)

  • Join Filter: (alpha_quebec.two_juliet = mike_zulu.golf_tango)
50. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..77.840 rows=1 width=26) (actual time=.. rows= loops=)

51. 0.000 0.000 ↓ 0.0
→

Seq Scan on three_tango whiskey_papa (cost=0.000..69.560 rows=1 width=8) (actual time=.. rows= loops=)

  • Filter: oscar
52. 0.000 0.000 ↓ 0.0
→

Index Scan using tango_two on delta_four_charlie alpha_quebec (cost=0.000..8.270 rows=1 width=18) (actual time=.. rows= loops=)

  • Index Cond: (alpha_quebec.two_juliet = whiskey_papa.two_juliet)
53. 0.000 0.000 ↓ 0.0
→

Seq Scan on india mike_zulu (cost=0.000..125.650 rows=7665 width=8) (actual time=.. rows= loops=)

54. 0.000 0.000 ↓ 0.0
→

Index Scan using four_four on bravo_hotel six (cost=0.000..0.270 rows=1 width=4) (actual time=.. rows= loops=)

  • Index Cond: (six.zulu_uniform = mike_zulu.zulu_uniform)
55. 0.000 0.000 ↓ 0.0
→

Seq Scan on juliet romeo (cost=0.000..1.020 rows=2 width=4) (actual time=.. rows= loops=)

56. 0.000 0.000 ↓ 0.0
→

Index Scan using four_whiskey on november_whiskey five_three (cost=0.000..8.270 rows=1 width=8) (actual time=.. rows= loops=)

  • Index Cond: (five_three.two_juliet = alpha_quebec.two_juliet)
57. 0.000 0.000 ↓ 0.0
→

Seq Scan on tango_mike alpha_seven (cost=0.000..124.290 rows=4503 width=4) (actual time=.. rows= loops=)

  • Filter: (NOT alpha_seven.whiskey_seven)
58. 0.000 0.000 ↓ 0.0
→

Index Scan using lima_golf on tango_seven golf_echo (cost=0.000..5.540 rows=1 width=8) (actual time=.. rows= loops=)

  • Index Cond: ((six.zulu_uniform = golf_echo.zulu_uniform) AND (alpha_seven.kilo_six = golf_echo.kilo_six))