explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TiBu

Settings
# exclusive inclusive rows x rows loops node
1. 6,469.730 6,469.730 ↓ 0.0 0 1

Index Scan using incidents_g_idx on api_data.incidents (cost=0.42..3.03 rows=1 width=232) (actual time=6,469.730..6,469.730 rows=0 loops=1)

  • Output: id, ccn, city, date, state, agencyid, location, narrative, createdate, postalcode, updatedate, incidenttype, blockizedaddress, parentincidenttype, g
  • Index Cond: (incidents.g && '0101000020E61000007C7C4276DE5954C003B5183C4C8B3C40'::geography)
  • Filter: ((incidents.date >= '2016-08-03'::date) AND (incidents.date <= '2016-08-05'::date) AND (incidents.parentincidenttype = 'Traffic'::text) AND ('0101000020E61000007C7C4276DE5954C003B5183C4C8B3C40'::geography && _st_expand(incidents.g, '5000'::double precision)) AND _st_dwithin('0101000020E61000.
  • Rows Removed by Filter: 17248