#	exclusive	inclusive	rows x	rows	loops	node
1.	0.120	0.231	↑ 1.0	288	1	→ Hash Join (cost=5.89..14.73 rows=288 width=143) (actual time=0.099..0.231 rows=288 loops=1) Hash Cond: (soc.capability_id = capability.id)
2.	0.027	0.027	↑ 1.0	288	1	→ Seq Scan on service_offer_capability soc (cost=0.00..4.88 rows=288 width=4) (actual time=0.007..0.027 rows=288 loops=1)
3.	0.016	0.084	↑ 1.0	33	1	→ Hash (cost=5.48..5.48 rows=33 width=143) (actual time=0.084..0.084 rows=33 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 5kB
4.	0.014	0.068	↑ 1.0	33	1	→ Hash Left Join (cost=3.32..5.48 rows=33 width=143) (actual time=0.040..0.068 rows=33 loops=1) Hash Cond: (capability.id = b.capability_id)
5.	0.019	0.044	↑ 1.0	33	1	→ Hash Right Join (cost=1.74..3.67 rows=33 width=88) (actual time=0.025..0.044 rows=33 loops=1) Hash Cond: (c.capability_id = capability.id)
6.	0.010	0.010	↑ 1.0	32	1	→ Seq Scan on capability_tr c (cost=0.00..1.49 rows=32 width=59) (actual time=0.003..0.010 rows=32 loops=1) Filter: ((locale)::text = 'en'::text)
7.	0.009	0.015	↑ 1.0	33	1	→ Hash (cost=1.33..1.33 rows=33 width=33) (actual time=0.015..0.015 rows=33 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 3kB
8.	0.006	0.006	↑ 1.0	33	1	→ Seq Scan on capability (cost=0.00..1.33 rows=33 width=33) (actual time=0.002..0.006 rows=33 loops=1)
9.	0.002	0.010	↑ 1.0	7	1	→ Hash (cost=1.49..1.49 rows=7 width=59) (actual time=0.010..0.010 rows=7 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
10.	0.008	0.008	↑ 1.0	7	1	→ Seq Scan on capability_tr b (cost=0.00..1.49 rows=7 width=59) (actual time=0.006..0.008 rows=7 loops=1) Filter: ((locale)::text = 'el'::text)

"Hash Join  (cost=5.89..14.73 rows=288 width=143) (actual time=0.099..0.231 rows=288 loops=1)"
"  Hash Cond: (soc.capability_id = capability.id)"
"  ->  Seq Scan on service_offer_capability soc  (cost=0.00..4.88 rows=288 width=4) (actual time=0.007..0.027 rows=288 loops=1)"
"  ->  Hash  (cost=5.48..5.48 rows=33 width=143) (actual time=0.084..0.084 rows=33 loops=1)"
"        Buckets: 1024  Batches: 1  Memory Usage: 5kB"
"        ->  Hash Left Join  (cost=3.32..5.48 rows=33 width=143) (actual time=0.040..0.068 rows=33 loops=1)"
"              Hash Cond: (capability.id = b.capability_id)"
"              ->  Hash Right Join  (cost=1.74..3.67 rows=33 width=88) (actual time=0.025..0.044 rows=33 loops=1)"
"                    Hash Cond: (c.capability_id = capability.id)"
"                    ->  Seq Scan on capability_tr c  (cost=0.00..1.49 rows=32 width=59) (actual time=0.003..0.010 rows=32 loops=1)"
"                          Filter: ((locale)::text = 'en'::text)"
"                    ->  Hash  (cost=1.33..1.33 rows=33 width=33) (actual time=0.015..0.015 rows=33 loops=1)"
"                          Buckets: 1024  Batches: 1  Memory Usage: 3kB"
"                          ->  Seq Scan on capability  (cost=0.00..1.33 rows=33 width=33) (actual time=0.002..0.006 rows=33 loops=1)"
"              ->  Hash  (cost=1.49..1.49 rows=7 width=59) (actual time=0.010..0.010 rows=7 loops=1)"
"                    Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                    ->  Seq Scan on capability_tr b  (cost=0.00..1.49 rows=7 width=59) (actual time=0.006..0.008 rows=7 loops=1)"
"                          Filter: ((locale)::text = 'el'::text)"
"Total runtime: 0.294 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	3	0.027 ms	11.7 %
Hash Join	1	0.120 ms	51.9 %
Hash Left Join	1	0.014 ms	6.1 %
Hash Right Join	1	0.019 ms	8.2 %
Seq Scan	4	0.051 ms	22.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
capability	1	0.006 ms	2.6 %
Seq Scan	1	0.006 ms	100.0 %
capability_tr	2	0.018 ms	7.8 %
Seq Scan	2	0.018 ms	100.0 %
service_offer_capability	1	0.027 ms	11.7 %
Seq Scan	1	0.027 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ogU

Colorize:

Columns visibility:

Per node type stats

Per table stats