explain.depesz.com

A tool for finding a real cause for slow queries.

Result: uVe : s

options
# exclusive inclusive rows x rows loops node
1. 604.134 107717.675 ↑ 137.2 4452 1
→

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

  • 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_juliet)::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.223 0.223 ↑ 1.0 1 1
→

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

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo((("oscar_two"())::character varying)::text))
4. 1274.566 2944.085 ↓ 32.7 185951 1
→

Sort (cost=25290.080..25304.320 rows=5694 width=2285) (actual time=2696.883..2944.085 rows=185951 loops=1)

  • Sort Key: tango_seven.three_tango
  • Sort Method: external merge Disk: 103376kB
5. 317.088 1669.519 ↓ 32.7 185951 1
→

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

6. 135.792 794.578 ↓ 32.7 185951 1
→

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

  • Hash Cond: (tango_seven.uniform = mike_hotel_echo.bravo.xray_foxtrot_charlie)
7. 492.311 635.594 ↓ 3.4 185951 1
→

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

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

Initplan (forHash Join)
9. 0.168 0.168 ↑ 1.0 1 1
→

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

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo((("oscar_two"())::character varying)::text))
10. 0.175 0.175 ↑ 1.0 1 1
→

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

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

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

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo((("oscar_two"())::character varying)::text))
12. 0.166 0.166 ↑ 1.0 1 1
→

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

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

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

  • Filter: (golf_romeo((echo_sierra)::text) = golf_romeo((("oscar_two"())::character varying)::text))
14. 142.087 142.087 ↑ 1.0 185951 1
→

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

  • Filter: (xray_three AND ((golf_five)::text !~~ 'victor'::text))
15. 0.016 0.687 ↓ 3.6 36 1
→

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
16. 0.048 0.671 ↓ 3.6 36 1
→

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

  • Hash Cond: (mike_hotel_echo.four.yankee = mike_hotel_echo.bravo.xray_foxtrot_charlie)
17. 0.019 0.227 ↓ 1.7 36 1
→

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

  • Recheck Cond: ((echo_sierra)::text = ($1)::text)
18. 0.208 0.208 ↓ 1.7 36 1
→

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

  • Index Cond: ((echo_sierra)::text = ($1)::text)
19. 0.014 0.396 ↓ 2.0 36 1
→

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

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
20. 0.382 0.382 ↓ 2.0 36 1
→

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

  • 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.040 23.192 ↓ 1.7 36 1
→

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

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
22. 0.058 23.152 ↓ 1.7 36 1
→

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

  • Hash Cond: (mike_hotel_echo.four.yankee = mike_hotel_echo.bravo.xray_foxtrot_charlie)
23. 0.062 23.059 ↓ 1.7 36 1
→

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

  • Recheck Cond: ((echo_sierra)::text = ($0)::text)
24. 22.997 22.997 ↓ 1.7 36 1
→

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

  • Index Cond: ((echo_sierra)::text = ($0)::text)
25. 0.020 0.035 ↑ 1.0 36 1
→

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

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
26. 0.015 0.015 ↑ 1.0 36 1
→

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

27. 557.853 557.853 ↑ 1.0 1 185951
→

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

  • Index Cond: (xray_foxtrot_quebec = tango_seven.charlie)
28. 112.019 104169.233 ↓ 8.6 183948 1
→

Materialize (cost=0.000..226694.570 rows=21447 width=28) (actual time=48.670..104169.233 rows=183948 loops=1)

29. 3717.585 104057.214 ↓ 8.6 183948 1
→

GroupAggregate (cost=0.000..226426.480 rows=21447 width=18) (actual time=48.666..104057.214 rows=183948 loops=1)

30. 100339.629 100339.629 ↓ 1.0 1501045 1
→

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

  • Filter: xray_three