explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ixx

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Bitmap Heap Scan on results_flattenedresponse (cost=7118.24..39119.29 rows=15585 width=251) (actual time=.. rows= loops=)

  • 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.000 0.000 ↓ 0.0
→

BitmapAnd (cost=7118.24..7118.24 rows=15585 width=0) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on results_flattenedresponse_created (cost=0.00..3325.41 rows=158493 width=0) (actual time=.. rows= loops=)

  • 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. 0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on results_flattenedresponse_installation_id (cost=0.00..3784.79 rows=204842 width=0) (actual time=.. rows= loops=)

  • Index Cond: (installation_id = 40)