#	exclusive	inclusive	rows x	rows	loops	node
1.	42.876	150.419	↓ 1.5	22932	1	→ Bitmap Heap Scan on results_flattenedresponse (cost=6961.50..38183.74 rows=14930 width=251) (actual time=108.379..150.419 rows=22932 loops=1) Recheck Cond: ((created > '2012-04-01 00:00:00-04'::timestamp with time zone) AND (created < '2012-05-01 00:00:00-04'::timestamp with time zone) AND (installation_id = 40))
2.	0.598	107.543	↓ 0.0	0	1	→ BitmapAnd (cost=6961.50..6961.50 rows=14930 width=0) (actual time=107.543..107.543 rows=0 loops=1)
3.	16.026	16.026	↑ 1.0	154396	1	→ Bitmap Index Scan on results_flattenedresponse_created (cost=0.00..3346.43 rows=159395 width=0) (actual time=16.026..16.026 rows=154396 loops=1) Index Cond: ((created > '2012-04-01 00:00:00-04'::timestamp with time zone) AND (created < '2012-05-01 00:00:00-04'::timestamp with time zone))
4.	90.919	90.919	↓ 1.0	199168	1	→ Bitmap Index Scan on results_flattenedresponse_installation_id (cost=0.00..3607.36 rows=195051 width=0) (actual time=90.919..90.919 rows=199168 loops=1) Index Cond: (installation_id = 40)

"Bitmap Heap Scan on results_flattenedresponse  (cost=6961.50..38183.74 rows=14930 width=251) (actual time=108.379..150.419 rows=22932 loops=1)"
"  Recheck Cond: ((created > '2012-04-01 00:00:00-04'::timestamp with time zone) AND (created < '2012-05-01 00:00:00-04'::timestamp with time zone) AND (installation_id = 40))"
"  ->  BitmapAnd  (cost=6961.50..6961.50 rows=14930 width=0) (actual time=107.543..107.543 rows=0 loops=1)"
"        ->  Bitmap Index Scan on results_flattenedresponse_created  (cost=0.00..3346.43 rows=159395 width=0) (actual time=16.026..16.026 rows=154396 loops=1)"
"              Index Cond: ((created > '2012-04-01 00:00:00-04'::timestamp with time zone) AND (created < '2012-05-01 00:00:00-04'::timestamp with time zone))"
"        ->  Bitmap Index Scan on results_flattenedresponse_installation_id  (cost=0.00..3607.36 rows=195051 width=0) (actual time=90.919..90.919 rows=199168 loops=1)"
"              Index Cond: (installation_id = 40)"
"Total runtime: 151.030 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	42.876 ms	28.5 %
Bitmap Index Scan	2	106.945 ms	71.1 %
BitmapAnd	1	0.598 ms	0.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
results_flattenedresponse	1	42.876 ms	28.5 %
Bitmap Heap Scan	1	42.876 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: JIe

Colorize:

Columns visibility:

Per node type stats

Per table stats