#	exclusive	inclusive	rows x	rows	loops	node
1.	0.127	0.237	↑ 1.0	288	1	→ Hash Join (cost=5.57..14.41 rows=288 width=143) (actual time=0.101..0.237 rows=288 loops=1) Hash Cond: (soc.capability_id = capability.id)
2.	0.025	0.025	↑ 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.025 rows=288 loops=1)
3.	0.015	0.085	↑ 1.0	33	1	→ Hash (cost=5.15..5.15 rows=33 width=143) (actual time=0.085..0.085 rows=33 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 5kB
4.	0.012	0.070	↑ 1.0	33	1	→ Hash Left Join (cost=3.17..5.15 rows=33 width=143) (actual time=0.041..0.070 rows=33 loops=1) Hash Cond: (capability.id = b.capability_id)
5.	0.022	0.047	↑ 1.0	33	1	→ Hash Right Join (cost=1.74..3.60 rows=33 width=88) (actual time=0.025..0.047 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.41 rows=32 width=59) (actual time=0.004..0.010 rows=32 loops=1) Filter: ((locale)::text = 'en'::text)
7.	0.007	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.008	0.008	↑ 1.0	33	1	→ Seq Scan on capability (cost=0.00..1.33 rows=33 width=33) (actual time=0.002..0.008 rows=33 loops=1)
9.	0.003	0.011	↓ 7.0	7	1	→ Hash (cost=1.41..1.41 rows=1 width=59) (actual time=0.011..0.011 rows=7 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
10.	0.008	0.008	↓ 7.0	7	1	→ Seq Scan on capability_tr b (cost=0.00..1.41 rows=1 width=59) (actual time=0.006..0.008 rows=7 loops=1) Filter: ((locale)::text = 'el'::text)

"Hash Join  (cost=5.57..14.41 rows=288 width=143) (actual time=0.101..0.237 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.025 rows=288 loops=1)"
"  ->  Hash  (cost=5.15..5.15 rows=33 width=143) (actual time=0.085..0.085 rows=33 loops=1)"
"        Buckets: 1024  Batches: 1  Memory Usage: 5kB"
"        ->  Hash Left Join  (cost=3.17..5.15 rows=33 width=143) (actual time=0.041..0.070 rows=33 loops=1)"
"              Hash Cond: (capability.id = b.capability_id)"
"              ->  Hash Right Join  (cost=1.74..3.60 rows=33 width=88) (actual time=0.025..0.047 rows=33 loops=1)"
"                    Hash Cond: (c.capability_id = capability.id)"
"                    ->  Seq Scan on capability_tr c  (cost=0.00..1.41 rows=32 width=59) (actual time=0.004..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.008 rows=33 loops=1)"
"              ->  Hash  (cost=1.41..1.41 rows=1 width=59) (actual time=0.011..0.011 rows=7 loops=1)"
"                    Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                    ->  Seq Scan on capability_tr b  (cost=0.00..1.41 rows=1 width=59) (actual time=0.006..0.008 rows=7 loops=1)"
"                          Filter: ((locale)::text = 'el'::text)"

Per node type stats

node type	count	sum of times	% of query
Hash	3	0.025 ms	10.5 %
Hash Join	1	0.127 ms	53.6 %
Hash Left Join	1	0.012 ms	5.1 %
Hash Right Join	1	0.022 ms	9.3 %
Seq Scan	4	0.051 ms	21.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
capability	1	0.008 ms	3.4 %
Seq Scan	1	0.008 ms	100.0 %
capability_tr	2	0.018 ms	7.6 %
Seq Scan	2	0.018 ms	100.0 %
service_offer_capability	1	0.025 ms	10.5 %
Seq Scan	1	0.025 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: qJY

Colorize:

Columns visibility:

Per node type stats

Per table stats