explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DDGL

Settings
# exclusive inclusive rows x rows loops node
1. 548.184 5,642.066 ↑ 1.0 24,349 1

Bitmap Heap Scan on api_data.incidents (cost=126,369.34..154,273.75 rows=25,289 width=232) (actual time=5,095.376..5,642.066 rows=24,349 loops=1)

  • Output: id, ccn, city, date, state, agencyid, location, narrative, createdate, postalcode, updatedate, incidenttype, blockizedaddress, parentincidenttype, g
  • Recheck Cond: ((incidents.date >= '2016-08-03'::date) AND (incidents.date <= '2016-08-05'::date) AND (incidents.parentincidenttype = 'Traffic'::text))
  • Rows Removed by Index Recheck: 162602
  • Heap Blocks: exact=6509
2. 1.888 5,093.882 ↓ 0.0 0 1

BitmapAnd (cost=126,369.34..126,369.34 rows=25,289 width=0) (actual time=5,093.882..5,093.882 rows=0 loops=1)

3. 1,829.282 1,829.282 ↓ 1.0 200,909 1

Bitmap Index Scan on incidents_date_idx (cost=0.00..2,571.95 rows=197,518 width=0) (actual time=1,829.282..1,829.282 rows=200,909 loops=1)

  • Index Cond: ((incidents.date >= '2016-08-03'::date) AND (incidents.date <= '2016-08-05'::date))
4. 3,262.712 3,262.712 ↓ 1.0 10,960,218 1

Bitmap Index Scan on incidents_parentincidenttype_idx (cost=0.00..123,784.50 rows=10,895,991 width=0) (actual time=3,262.712..3,262.712 rows=10,960,218 loops=1)

  • Index Cond: (incidents.parentincidenttype = 'Traffic'::text)