explain.depesz.com

A tool for finding a real cause for slow queries.

Result: JIe

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 42.876 150.419 ↓ 1.5 22,932 1

Bitmap Heap Scan on results_flattenedresponse (cost=6,961.50..38,183.74 rows=14,930 width=251) (actual time=108.379..150.419 rows=22,932 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=6,961.50..6,961.50 rows=14,930 width=0) (actual time=107.543..107.543 rows=0 loops=1)

3. 16.026 16.026 ↑ 1.0 154,396 1

Bitmap Index Scan on results_flattenedresponse_created (cost=0.00..3,346.43 rows=159,395 width=0) (actual time=16.026..16.026 rows=154,396 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 199,168 1

Bitmap Index Scan on results_flattenedresponse_installation_id (cost=0.00..3,607.36 rows=195,051 width=0) (actual time=90.919..90.919 rows=199,168 loops=1)

  • Index Cond: (installation_id = 40)