explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Kq1

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

Sort (cost=69.18..69.18 rows=1 width=148) (actual time=0.281..0.282 rows=1 loops=1)

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

CTE objects_depth

3. 0.023 0.107 ↑ 10.2 11 1

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

4. 0.012 0.012 ↑ 1.0 2 1

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

  • Filter: (parent_id = 0)
5. 0.044 0.072 ↑ 5.5 2 4

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

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

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

7. 0.011 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.009 0.009 ↑ 1.0 11 1

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

9. 0.022 0.274 ↑ 1.0 1 1

Hash Join (cost=30.70..46.97 rows=1 width=148) (actual time=0.256..0.274 rows=1 loops=1)

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

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

  • Filter: ((lang)::text = 'cz'::text)
11. 0.002 0.229 ↑ 11.0 1 1

Hash (cost=30.56..30.56 rows=11 width=24) (actual time=0.229..0.229 rows=1 loops=1)

12. 0.013 0.227 ↑ 11.0 1 1

Hash Join (cost=27.51..30.56 rows=11 width=24) (actual time=0.224..0.227 rows=1 loops=1)

  • Hash Cond: (objects_depth.top_parent = public.topiccategories.category_id)
13. 0.010 0.189 ↑ 112.0 1 1

HashAggregate (cost=26.26..27.66 rows=112 width=4) (actual time=0.188..0.189 rows=1 loops=1)

14. 0.035 0.179 ↑ 106.3 3 1

Hash Join (cost=3.64..24.67 rows=319 width=4) (actual time=0.172..0.179 rows=3 loops=1)

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

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

16. 0.011 0.138 ↑ 10.2 11 1

Hash (cost=2.24..2.24 rows=112 width=8) (actual time=0.138..0.138 rows=11 loops=1)

17. 0.127 0.127 ↑ 10.2 11 1

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

18. 0.014 0.025 ↑ 1.0 11 1

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

19. 0.011 0.011 ↑ 1.0 11 1

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