explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XuNG

Settings
# exclusive inclusive rows x rows loops node
1. 24.899 24.899 ↓ 0.0 0 1

Index Scan using incidents_g_idx on api_data.incidents (cost=0.42..3.02 rows=1 width=232) (actual time=24.899..24.899 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 ('0101000020E61000007C7C4276DE5954C003B5183C4C8B3C40'::geography && _st_expand(incidents.g, '5000'::double precision)) AND _st_dwithin('0101000020E61000007C7C4276DE5954C003B5183C4C8B3C40'::geography, incid.
  • Rows Removed by Filter: 17248