#	exclusive	inclusive	rows x	rows	loops	node
1.	0.206	0.276	↑ 1.0	576	1	→ Hash Join (cost=4.00..16.08 rows=576 width=615) (actual time=0.057..0.276 rows=576 loops=1) Hash Cond: (s3_.service_offer_id = s2_.id)
2.	0.026	0.026	↑ 1.0	288	1	→ Seq Scan on service_offer_capability s3_ (cost=0.00..4.88 rows=288 width=13) (actual time=0.007..0.026 rows=288 loops=1)
3.	0.013	0.044	↑ 1.0	18	1	→ Hash (cost=3.78..3.78 rows=18 width=602) (actual time=0.044..0.044 rows=18 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 12kB
4.	0.009	0.031	↑ 1.0	18	1	→ Hash Join (cost=2.34..3.78 rows=18 width=602) (actual time=0.021..0.031 rows=18 loops=1) Hash Cond: (s0_.id = s1_.service_id)
5.	0.009	0.015	↑ 1.0	9	1	→ Hash Join (cost=1.11..2.33 rows=9 width=58) (actual time=0.011..0.015 rows=9 loops=1) Hash Cond: (s2_.service_id = s0_.id)
6.	0.001	0.001	↑ 1.0	9	1	→ Seq Scan on service_offer s2_ (cost=0.00..1.09 rows=9 width=29) (actual time=0.000..0.001 rows=9 loops=1)
7.	0.002	0.005	↑ 1.0	5	1	→ Hash (cost=1.05..1.05 rows=5 width=29) (actual time=0.005..0.005 rows=5 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
8.	0.003	0.003	↑ 1.0	5	1	→ Seq Scan on service s0_ (cost=0.00..1.05 rows=5 width=29) (actual time=0.001..0.003 rows=5 loops=1)
9.	0.005	0.007	↑ 1.0	10	1	→ Hash (cost=1.10..1.10 rows=10 width=544) (actual time=0.007..0.007 rows=10 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 6kB
10.	0.002	0.002	↑ 1.0	10	1	→ Seq Scan on service_tr s1_ (cost=0.00..1.10 rows=10 width=544) (actual time=0.001..0.002 rows=10 loops=1)

"Hash Join  (cost=4.00..16.08 rows=576 width=615) (actual time=0.057..0.276 rows=576 loops=1)"
"  Hash Cond: (s3_.service_offer_id = s2_.id)"
"  ->  Seq Scan on service_offer_capability s3_  (cost=0.00..4.88 rows=288 width=13) (actual time=0.007..0.026 rows=288 loops=1)"
"  ->  Hash  (cost=3.78..3.78 rows=18 width=602) (actual time=0.044..0.044 rows=18 loops=1)"
"        Buckets: 1024  Batches: 1  Memory Usage: 12kB"
"        ->  Hash Join  (cost=2.34..3.78 rows=18 width=602) (actual time=0.021..0.031 rows=18 loops=1)"
"              Hash Cond: (s0_.id = s1_.service_id)"
"              ->  Hash Join  (cost=1.11..2.33 rows=9 width=58) (actual time=0.011..0.015 rows=9 loops=1)"
"                    Hash Cond: (s2_.service_id = s0_.id)"
"                    ->  Seq Scan on service_offer s2_  (cost=0.00..1.09 rows=9 width=29) (actual time=0.000..0.001 rows=9 loops=1)"
"                    ->  Hash  (cost=1.05..1.05 rows=5 width=29) (actual time=0.005..0.005 rows=5 loops=1)"
"                          Buckets: 1024  Batches: 1  Memory Usage: 1kB"
"                          ->  Seq Scan on service s0_  (cost=0.00..1.05 rows=5 width=29) (actual time=0.001..0.003 rows=5 loops=1)"
"              ->  Hash  (cost=1.10..1.10 rows=10 width=544) (actual time=0.007..0.007 rows=10 loops=1)"
"                    Buckets: 1024  Batches: 1  Memory Usage: 6kB"
"                    ->  Seq Scan on service_tr s1_  (cost=0.00..1.10 rows=10 width=544) (actual time=0.001..0.002 rows=10 loops=1)"
"Total runtime: 0.345 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	3	0.020 ms	7.2 %
Hash Join	3	0.224 ms	81.2 %
Seq Scan	4	0.032 ms	11.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
service	1	0.003 ms	1.1 %
Seq Scan	1	0.003 ms	100.0 %
service_offer	1	0.001 ms	0.4 %
Seq Scan	1	0.001 ms	100.0 %
service_offer_capability	1	0.026 ms	9.4 %
Seq Scan	1	0.026 ms	100.0 %
service_tr	1	0.002 ms	0.7 %
Seq Scan	1	0.002 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 6Xf

Colorize:

Columns visibility:

Per node type stats

Per table stats