explain.depesz.com

A tool for finding a real cause for slow queries.

Result: YOW

options
# exclusive inclusive rows x rows loops node
1. 43.167 152.308 ↓ 1.5 22932 1
→

Bitmap Heap Scan on results_flattenedresponse (cost=6961.50..38183.74 rows=14930 width=251) (actual time=110.032..152.308 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.594 109.141 ↓ 0.0 0 1
→

BitmapAnd (cost=6961.50..6961.50 rows=14930 width=0) (actual time=109.141..109.141 rows=0 loops=1)

3. 16.388 16.388 ↑ 1.0 154396 1
→

Bitmap Index Scan on results_flattenedresponse_created (cost=0.00..3346.43 rows=159395 width=0) (actual time=16.388..16.388 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. 92.159 92.159 ↓ 1.0 199168 1
→

Bitmap Index Scan on results_flattenedresponse_installation_id (cost=0.00..3607.36 rows=195051 width=0) (actual time=92.159..92.159 rows=199168 loops=1)

  • Index Cond: (installation_id = 40)