#	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)

"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"
"  CTE objects_depth"
"    ->  Recursive Union  (cost=0.00..22.20 rows=112 width=12) (actual time=0.010..0.107 rows=11 loops=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)"
"          ->  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)"
"                ->  WorkTable Scan on objects_depth  (cost=0.00..0.40 rows=20 width=8) (actual time=0.001..0.002 rows=3 loops=4)"
"                ->  Hash  (cost=1.11..1.11 rows=11 width=8) (actual time=0.020..0.020 rows=11 loops=1)"
"                      ->  Seq Scan on topiccategories  (cost=0.00..1.11 rows=11 width=8) (actual time=0.002..0.009 rows=11 loops=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)"
"        ->  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)"
"        ->  Hash  (cost=30.56..30.56 rows=11 width=24) (actual time=0.229..0.229 rows=1 loops=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)"
"                    ->  HashAggregate  (cost=26.26..27.66 rows=112 width=4) (actual time=0.188..0.189 rows=1 loops=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)"
"                                ->  Seq Scan on topics  (cost=0.00..15.70 rows=570 width=4) (actual time=0.002..0.006 rows=5 loops=1)"
"                                ->  Hash  (cost=2.24..2.24 rows=112 width=8) (actual time=0.138..0.138 rows=11 loops=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)"
"                    ->  Hash  (cost=1.11..1.11 rows=11 width=12) (actual time=0.025..0.025 rows=11 loops=1)"
"                          ->  Seq Scan on topiccategories  (cost=0.00..1.11 rows=11 width=12) (actual time=0.004..0.011 rows=11 loops=1)"
"Total runtime: 0.378 ms"

Per node type stats

node type	count	sum of times	% of query
CTE Scan	1	0.127 ms	45.0 %
Hash	4	0.038 ms	13.5 %
Hash Join	4	0.114 ms	40.4 %
HashAggregate	1	0.010 ms	3.5 %
Recursive Union	1	0.023 ms	8.2 %
Seq Scan	5	0.061 ms	21.6 %
Sort	1	0.008 ms	2.8 %
WorkTable Scan on objects_depth	1	0.008 ms	2.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
topiccategories	3	0.032 ms	11.3 %
Seq Scan	3	0.032 ms	100.0 %
topiccategories_i18n	1	0.023 ms	8.2 %
Seq Scan	1	0.023 ms	100.0 %
topics	1	0.006 ms	2.1 %
Seq Scan	1	0.006 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Kq1

Colorize:

Columns visibility:

Per node type stats

Per table stats