explain.depesz.com

A tool for finding a real cause for slow queries.

Result: V5O

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.012 0.335 ↑ 3.0 1 1

Sort (cost=28.58..28.58 rows=3 width=41) (actual time=0.334..0.335 rows=1 loops=1)

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

CTE objects_depth

3. 0.039 0.136 ↑ 10.2 11 1

Recursive Union (cost=0.00..22.20 rows=112 width=12) (actual time=0.008..0.136 rows=11 loops=1)

4. 0.009 0.009 ↑ 1.0 2 1

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

  • Filter: (parent_id = 0)
5. 0.041 0.088 ↑ 5.5 2 4

Hash Join (cost=1.25..1.88 rows=11 width=12) (actual time=0.016..0.022 rows=2 loops=4)

  • Hash Cond: (objects_depth.category_id = public.topiccategories.parent_id)
6. 0.016 0.016 ↑ 6.7 3 4

WorkTable Scan on objects_depth (cost=0.00..0.40 rows=20 width=8) (actual time=0.001..0.004 rows=3 loops=4)

7. 0.016 0.031 ↑ 1.0 11 1

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

8. 0.015 0.015 ↑ 1.0 11 1

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

9. 0.024 0.323 ↑ 3.0 1 1

Hash Join (cost=5.14..6.35 rows=3 width=41) (actual time=0.295..0.323 rows=1 loops=1)

  • Hash Cond: (topiccategories_i18n.category_id = objects_depth.top_parent)
10. 0.028 0.028 ↑ 1.0 11 1

Seq Scan on topiccategories_i18n (cost=0.00..1.14 rows=11 width=25) (actual time=0.013..0.028 rows=11 loops=1)

  • Filter: ((lang)::text = 'cz'::text)
11. 0.004 0.271 ↑ 3.0 1 1

Hash (cost=5.10..5.10 rows=3 width=24) (actual time=0.271..0.271 rows=1 loops=1)

12. 0.022 0.267 ↑ 3.0 1 1

Hash Join (cost=3.92..5.10 rows=3 width=24) (actual time=0.241..0.267 rows=1 loops=1)

  • Hash Cond: (public.topiccategories.category_id = objects_depth.top_parent)
13. 0.017 0.017 ↑ 1.0 11 1

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

14. 0.004 0.228 ↑ 3.0 1 1

Hash (cost=3.88..3.88 rows=3 width=12) (actual time=0.228..0.228 rows=1 loops=1)

15. 0.011 0.224 ↑ 3.0 1 1

HashAggregate (cost=3.82..3.85 rows=3 width=4) (actual time=0.223..0.224 rows=1 loops=1)

16. 0.028 0.213 ↑ 1.0 3 1

Hash Join (cost=1.11..3.80 rows=3 width=4) (actual time=0.154..0.213 rows=3 loops=1)

  • Hash Cond: (objects_depth.category_id = topics.category_id)
17. 0.165 0.165 ↑ 10.2 11 1

CTE Scan on objects_depth (cost=0.00..2.24 rows=112 width=8) (actual time=0.012..0.165 rows=11 loops=1)

18. 0.009 0.020 ↑ 1.7 3 1

Hash (cost=1.05..1.05 rows=5 width=4) (actual time=0.020..0.020 rows=3 loops=1)

19. 0.011 0.011 ↑ 1.0 5 1

Seq Scan on topics (cost=0.00..1.05 rows=5 width=4) (actual time=0.004..0.011 rows=5 loops=1)