#	exclusive	inclusive	rows x	rows	loops	node
1.	40.313	69.479	↑ 1.0	22531	1	→ Hash Join (cost=1.09..1428.58 rows=22533 width=105) (actual time=0.034..69.479 rows=22531 loops=1) Hash Cond: (pk2012_services.srv_sdf_id_fk = pk2012_service_definitions.sdf_id)
2.	29.153	29.153	↑ 1.0	22531	1	→ Seq Scan on pk2012_services (cost=0.00..1117.66 rows=22533 width=95) (actual time=0.007..29.153 rows=22531 loops=1) Filter: ((srv_state)::text = 'Z'::text)
3.	0.005	0.013	↑ 1.0	4	1	→ Hash (cost=1.04..1.04 rows=4 width=26) (actual time=0.013..0.013 rows=4 loops=1)
4.	0.008	0.008	↑ 1.0	4	1	→ Seq Scan on pk2012_service_definitions (cost=0.00..1.04 rows=4 width=26) (actual time=0.004..0.008 rows=4 loops=1)

'Hash Join  (cost=1.09..1428.58 rows=22533 width=105) (actual time=0.034..69.479 rows=22531 loops=1)'
'  Hash Cond: (pk2012_services.srv_sdf_id_fk = pk2012_service_definitions.sdf_id)'
'  ->  Seq Scan on pk2012_services  (cost=0.00..1117.66 rows=22533 width=95) (actual time=0.007..29.153 rows=22531 loops=1)'
'        Filter: ((srv_state)::text = 'Z'::text)'
'  ->  Hash  (cost=1.04..1.04 rows=4 width=26) (actual time=0.013..0.013 rows=4 loops=1)'
'        ->  Seq Scan on pk2012_service_definitions  (cost=0.00..1.04 rows=4 width=26) (actual time=0.004..0.008 rows=4 loops=1)'
'Total runtime: 85.853 ms'

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.005 ms	0.0 %
Hash Join	1	40.313 ms	58.0 %
Seq Scan	2	29.161 ms	42.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
pk2012_service_definitions	1	0.008 ms	0.0 %
Seq Scan	1	0.008 ms	100.0 %
pk2012_services	1	29.153 ms	42.0 %
Seq Scan	1	29.153 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: nYG

Colorize:

Columns visibility:

Per node type stats

Per table stats