#	exclusive	inclusive	rows x	rows	loops	node
1.	36.876	102.622	↓ 1.3	22531	1	→ Hash Join (cost=49.29..3467.85 rows=17526 width=132) (actual time=0.971..102.622 rows=22531 loops=1) Hash Cond: (pk2012_services.srv_sdf_id_fk = pk2012_service_definitions.sdf_id)
2.	31.724	65.731	↓ 1.3	22531	1	→ Nested Loop (cost=48.20..3225.77 rows=17526 width=122) (actual time=0.948..65.731 rows=22531 loops=1)
3.	0.015	0.015	↑ 1.0	7	1	→ Seq Scan on pk2012_periods (cost=0.00..1.07 rows=7 width=35) (actual time=0.003..0.015 rows=7 loops=1)
4.	30.632	33.992	↓ 1.3	3219	7	→ Bitmap Heap Scan on pk2012_services (cost=48.20..423.11 rows=2504 width=95) (actual time=0.577..4.856 rows=3219 loops=7) Recheck Cond: ((pk2012_services.srv_state_change_date >= pk2012_periods.per_start_date) AND (pk2012_services.srv_state_change_date <= pk2012_periods.per_end_date)) Filter: ((srv_state)::text = 'Z'::text)
5.	3.360	3.360	↓ 1.3	3219	7	→ Bitmap Index Scan on pk2012_srv_state_change_date_idx (cost=0.00..47.58 rows=2504 width=0) (actual time=0.480..0.480 rows=3219 loops=7) Index Cond: ((pk2012_services.srv_state_change_date >= pk2012_periods.per_start_date) AND (pk2012_services.srv_state_change_date <= pk2012_periods.per_end_date))
6.	0.007	0.015	↑ 1.0	4	1	→ Hash (cost=1.04..1.04 rows=4 width=26) (actual time=0.015..0.015 rows=4 loops=1)
7.	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.005..0.008 rows=4 loops=1)

'Hash Join  (cost=49.29..3467.85 rows=17526 width=132) (actual time=0.971..102.622 rows=22531 loops=1)'
'  Hash Cond: (pk2012_services.srv_sdf_id_fk = pk2012_service_definitions.sdf_id)'
'  ->  Nested Loop  (cost=48.20..3225.77 rows=17526 width=122) (actual time=0.948..65.731 rows=22531 loops=1)'
'        ->  Seq Scan on pk2012_periods  (cost=0.00..1.07 rows=7 width=35) (actual time=0.003..0.015 rows=7 loops=1)'
'        ->  Bitmap Heap Scan on pk2012_services  (cost=48.20..423.11 rows=2504 width=95) (actual time=0.577..4.856 rows=3219 loops=7)'
'              Recheck Cond: ((pk2012_services.srv_state_change_date >= pk2012_periods.per_start_date) AND (pk2012_services.srv_state_change_date <= pk2012_periods.per_end_date))'
'              Filter: ((srv_state)::text = 'Z'::text)'
'              ->  Bitmap Index Scan on pk2012_srv_state_change_date_idx  (cost=0.00..47.58 rows=2504 width=0) (actual time=0.480..0.480 rows=3219 loops=7)'
'                    Index Cond: ((pk2012_services.srv_state_change_date >= pk2012_periods.per_start_date) AND (pk2012_services.srv_state_change_date <= pk2012_periods.per_end_date))'
'  ->  Hash  (cost=1.04..1.04 rows=4 width=26) (actual time=0.015..0.015 rows=4 loops=1)'
'        ->  Seq Scan on pk2012_service_definitions  (cost=0.00..1.04 rows=4 width=26) (actual time=0.005..0.008 rows=4 loops=1)'
'Total runtime: 117.660 ms'

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	30.632 ms	29.8 %
Bitmap Index Scan	1	3.360 ms	3.3 %
Hash	1	0.007 ms	0.0 %
Hash Join	1	36.876 ms	35.9 %
Nested Loop	1	31.724 ms	30.9 %
Seq Scan	2	0.023 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
pk2012_periods	1	0.015 ms	0.0 %
Seq Scan	1	0.015 ms	100.0 %
pk2012_service_definitions	1	0.008 ms	0.0 %
Seq Scan	1	0.008 ms	100.0 %
pk2012_services	1	30.632 ms	29.8 %
Bitmap Heap Scan	1	30.632 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: MTL

Colorize:

Columns visibility:

Per node type stats

Per table stats