explain.depesz.com

A tool for finding a real cause for slow queries.

Result: mOz

options
# exclusive inclusive rows x rows loops node
1. 0.011 0.246 ↓ 2.0 2 1
→

Sort (cost=71.93..71.93 rows=1 width=148) (actual time=0.245..0.246 rows=2 loops=1)

  • Sort Key: public.topiccategories.weight
  • Sort Method: quicksort Memory: 25kB
2.          

CTE objects_depth
3. 0.015 0.078 ↑ 22.6 5 1
→

Recursive Union (cost=0.00..24.85 rows=113 width=12) (actual time=0.012..0.078 rows=5 loops=1)

4. 0.011 0.011 ↑ 1.0 3 1
→

Seq Scan on topiccategories (cost=0.00..1.14 rows=3 width=8) (actual time=0.009..0.011 rows=3 loops=1)

  • Filter: (parent_id = 19)
5. 0.028 0.052 ↑ 11.0 1 2
→

Hash Join (cost=1.25..2.15 rows=11 width=12) (actual time=0.024..0.026 rows=1 loops=2)

  • Hash Cond: (objects_depth.category_id = public.topiccategories.parent_id)
6. 0.004 0.004 ↑ 15.0 2 2
→

WorkTable Scan on objects_depth (cost=0.00..0.60 rows=30 width=8) (actual time=0.001..0.002 rows=2 loops=2)

7. 0.009 0.020 ↑ 1.0 11 1
→

Hash (cost=1.11..1.11 rows=11 width=8) (actual time=0.020..0.020 rows=11 loops=1)

8. 0.011 0.011 ↑ 1.0 11 1
→

Seq Scan on topiccategories (cost=0.00..1.11 rows=11 width=8) (actual time=0.003..0.011 rows=11 loops=1)

9. 0.023 0.235 ↓ 2.0 2 1
→

Hash Join (cost=30.80..47.07 rows=1 width=148) (actual time=0.225..0.235 rows=2 loops=1)

  • Hash Cond: (topiccategories_i18n.category_id = objects_depth.top_parent)
10. 0.022 0.022 ↓ 5.5 11 1
→

Seq Scan on topiccategories_i18n (cost=0.00..16.25 rows=2 width=132) (actual time=0.014..0.022 rows=11 loops=1)

  • Filter: ((lang)::text = 'cz'::text)
11. 0.004 0.190 ↑ 5.5 2 1
→

Hash (cost=30.66..30.66 rows=11 width=24) (actual time=0.190..0.190 rows=2 loops=1)

12. 0.013 0.186 ↑ 5.5 2 1
→

Hash Join (cost=27.59..30.66 rows=11 width=24) (actual time=0.181..0.186 rows=2 loops=1)

  • Hash Cond: (objects_depth.top_parent = public.topiccategories.category_id)
13. 0.012 0.147 ↑ 56.5 2 1
→

HashAggregate (cost=26.34..27.75 rows=113 width=4) (actual time=0.145..0.147 rows=2 loops=1)

14. 0.036 0.135 ↑ 107.3 3 1
→

Hash Join (cost=3.67..24.73 rows=322 width=4) (actual time=0.129..0.135 rows=3 loops=1)

  • Hash Cond: (topics.category_id = objects_depth.category_id)
15. 0.004 0.004 ↑ 114.0 5 1
→

Seq Scan on topics (cost=0.00..15.70 rows=570 width=4) (actual time=0.002..0.004 rows=5 loops=1)

16. 0.006 0.095 ↑ 22.6 5 1
→

Hash (cost=2.26..2.26 rows=113 width=8) (actual time=0.095..0.095 rows=5 loops=1)

17. 0.089 0.089 ↑ 22.6 5 1
→

CTE Scan on objects_depth (cost=0.00..2.26 rows=113 width=8) (actual time=0.014..0.089 rows=5 loops=1)

18. 0.011 0.026 ↑ 1.0 11 1
→

Hash (cost=1.11..1.11 rows=11 width=12) (actual time=0.026..0.026 rows=11 loops=1)

19. 0.015 0.015 ↑ 1.0 11 1
→

Seq Scan on topiccategories (cost=0.00..1.11 rows=11 width=12) (actual time=0.004..0.015 rows=11 loops=1)