explain.depesz.com

A tool for finding a real cause for slow queries.

Result: tvS : s

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

Merge Left Join (cost=25296.310..277917.170 rows=610670 width=2309) (actual time=.. rows= loops=)

  • Merge Cond: (tango_seven.three_tango = papa.echo_whiskey)
  • Filter: ((((tango_seven.three_sierra)::double precision - lima_sierra((five(CASE ((papa.golf_five)::text ~~ 'victor'::text) WHEN seven THEN 0::double precision ELSE (papa.india)::double precision END)), 0::double precision)) > 1lima_delta-05::double precision) OR (lima_sierra((five(CASE (((papa.golf_five)::text = 'alpha_golf'::text) AND ((papa.oscar)::text <> 'romeo'::text)) WHEN seven THEN (papa.india)::double precision ELSE 0::double precision END)), 0::double precision) <> 0::double precision) OR (lima_sierra((five(CASE ((papa.golf_five)::text ~~ 'victor'::text) WHEN seven THEN (papa.india)::double precision ELSE 0::double precision END)), 0::double precision) <> 0::double precision))
2.          

Initplan (forMerge Left Join)
3. 0.000 0.000 ↓ 0.0
→

Seq Scan on delta (cost=0.000..6.230 rows=1 width=12) (actual time=.. rows= loops=)

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo(((current_user())::character varying)::text))
4. 0.000 0.000 ↓ 0.0
→

Sort (cost=25290.080..25304.320 rows=5694 width=2285) (actual time=.. rows= loops=)

  • Sort Key: tango_seven.three_tango
5. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=53.190..13685.910 rows=5694 width=2285) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=53.190..11969.070 rows=5694 width=805) (actual time=.. rows= loops=)

  • Hash Cond: (tango_seven.uniform = mike_hotel_echo.bravo.xray_foxtrot_charlie)
7. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=42.150..11155.340 rows=54236 width=451) (actual time=.. rows= loops=)

  • Hash Cond: (tango_seven.uniform = mike_hotel_echo.bravo.xray_foxtrot_charlie)
8.          

Initplan (forHash Join)
9. 0.000 0.000 ↓ 0.0
→

Seq Scan on delta (cost=0.000..6.230 rows=1 width=12) (actual time=.. rows= loops=)

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo(((current_user())::character varying)::text))
10. 0.000 0.000 ↓ 0.0
→

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

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo(((current_user())::character varying)::text))
11. 0.000 0.000 ↓ 0.0
→

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

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo(((current_user())::character varying)::text))
12. 0.000 0.000 ↓ 0.0
→

Seq Scan on delta (cost=0.000..6.230 rows=1 width=1) (actual time=.. rows= loops=)

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo(((current_user())::character varying)::text))
13. 0.000 0.000 ↓ 0.0
→

Seq Scan on delta (cost=0.000..6.230 rows=1 width=1) (actual time=.. rows= loops=)

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo(((current_user())::character varying)::text))
14. 0.000 0.000 ↓ 0.0
→

Seq Scan on tango_seven (cost=0.000..9221.390 rows=185951 width=451) (actual time=.. rows= loops=)

  • Filter: (xray_three AND ((golf_five)::text !~~ 'victor'::text))
15. 0.000 0.000 ↓ 0.0
→

Hash (cost=10.890..10.890 rows=10 width=8) (actual time=.. rows= loops=)

16. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=6.450..10.890 rows=10 width=8) (actual time=.. rows= loops=)

  • Hash Cond: (mike_hotel_echo.four.yankee = mike_hotel_echo.bravo.xray_foxtrot_charlie)
17. 0.000 0.000 ↓ 0.0
→

Bitmap Heap Scan on four (cost=4.410..8.680 rows=21 width=4) (actual time=.. rows= loops=)

  • Recheck Cond: ((echo_sierra)::text = ($1)::text)
18. 0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on tango_yankee (cost=0.000..4.410 rows=21 width=0) (actual time=.. rows= loops=)

  • Index Cond: ((echo_sierra)::text = ($1)::text)
19. 0.000 0.000 ↓ 0.0
→

Hash (cost=1.810..1.810 rows=18 width=4) (actual time=.. rows= loops=)

20. 0.000 0.000 ↓ 0.0
→

Seq Scan on bravo (cost=0.000..1.810 rows=18 width=4) (actual time=.. rows= loops=)

  • Filter: CASE ($2 <> 0) WHEN seven THEN (xray_foxtrot_charlie = $3) ELSE CASE (($4)::text <> ''::text) WHEN seven THEN ((three_five)::text = ($5)::text) ELSE (xray_foxtrot_charlie <> 0) END END
21. 0.000 0.000 ↓ 0.0
→

Hash (cost=10.770..10.770 rows=21 width=350) (actual time=.. rows= loops=)

22. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=6.220..10.770 rows=21 width=350) (actual time=.. rows= loops=)

  • Hash Cond: (mike_hotel_echo.four.yankee = mike_hotel_echo.bravo.xray_foxtrot_charlie)
23. 0.000 0.000 ↓ 0.0
→

Bitmap Heap Scan on four (cost=4.410..8.680 rows=21 width=4) (actual time=.. rows= loops=)

  • Recheck Cond: ((echo_sierra)::text = ($0)::text)
24. 0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on tango_yankee (cost=0.000..4.410 rows=21 width=0) (actual time=.. rows= loops=)

  • Index Cond: ((echo_sierra)::text = ($0)::text)
25. 0.000 0.000 ↓ 0.0
→

Hash (cost=1.360..1.360 rows=36 width=346) (actual time=.. rows= loops=)

26. 0.000 0.000 ↓ 0.0
→

Seq Scan on bravo (cost=0.000..1.360 rows=36 width=346) (actual time=.. rows= loops=)

27. 0.000 0.000 ↓ 0.0
→

Index Scan using mike_hotel_bravo on hotel (cost=0.000..0.290 rows=1 width=1480) (actual time=.. rows= loops=)

  • Index Cond: (xray_foxtrot_quebec = tango_seven.charlie)
28. 0.000 0.000 ↓ 0.0
→

Materialize (cost=0.000..226694.570 rows=21447 width=28) (actual time=.. rows= loops=)

29. 0.000 0.000 ↓ 0.0
→

GroupAggregate (cost=0.000..226426.480 rows=21447 width=18) (actual time=.. rows= loops=)

30. 0.000 0.000 ↓ 0.0
→

Index Scan using alpha_xray on papa (cost=0.000..184937.180 rows=1500903 width=18) (actual time=.. rows= loops=)

  • Filter: xray_three