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

"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"
"  CTE objects_depth"
"    ->  Recursive Union  (cost=0.00..22.20 rows=112 width=12) (actual time=0.008..0.136 rows=11 loops=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)"
"          ->  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)"
"                ->  WorkTable Scan on objects_depth  (cost=0.00..0.40 rows=20 width=8) (actual time=0.001..0.004 rows=3 loops=4)"
"                ->  Hash  (cost=1.11..1.11 rows=11 width=8) (actual time=0.031..0.031 rows=11 loops=1)"
"                      ->  Seq Scan on topiccategories  (cost=0.00..1.11 rows=11 width=8) (actual time=0.002..0.015 rows=11 loops=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)"
"        ->  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)"
"        ->  Hash  (cost=5.10..5.10 rows=3 width=24) (actual time=0.271..0.271 rows=1 loops=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)"
"                    ->  Seq Scan on topiccategories  (cost=0.00..1.11 rows=11 width=12) (actual time=0.004..0.017 rows=11 loops=1)"
"                    ->  Hash  (cost=3.88..3.88 rows=3 width=12) (actual time=0.228..0.228 rows=1 loops=1)"
"                          ->  HashAggregate  (cost=3.82..3.85 rows=3 width=4) (actual time=0.223..0.224 rows=1 loops=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)"
"                                      ->  CTE Scan on objects_depth  (cost=0.00..2.24 rows=112 width=8) (actual time=0.012..0.165 rows=11 loops=1)"
"                                      ->  Hash  (cost=1.05..1.05 rows=5 width=4) (actual time=0.020..0.020 rows=3 loops=1)"
"                                            ->  Seq Scan on topics  (cost=0.00..1.05 rows=5 width=4) (actual time=0.004..0.011 rows=5 loops=1)"
"Total runtime: 0.458 ms"

Per node type stats

node type	count	sum of times	% of query
CTE Scan	1	0.165 ms	49.3 %
Hash	4	0.033 ms	9.9 %
Hash Join	4	0.115 ms	34.3 %
HashAggregate	1	0.011 ms	3.3 %
Recursive Union	1	0.039 ms	11.6 %
Seq Scan	5	0.080 ms	23.9 %
Sort	1	0.012 ms	3.6 %
WorkTable Scan on objects_depth	1	0.016 ms	4.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
topiccategories	3	0.041 ms	12.2 %
Seq Scan	3	0.041 ms	100.0 %
topiccategories_i18n	1	0.028 ms	8.4 %
Seq Scan	1	0.028 ms	100.0 %
topics	1	0.011 ms	3.3 %
Seq Scan	1	0.011 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: V5O

Colorize:

Columns visibility:

Per node type stats

Per table stats