explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZPvY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 298 1

Index Scan using demographics_2019_geometry_1578581398166 on demographics_2019 demographics_2019 (cost=0..0 rows=0 width=0) (actual rows=298 loops=1)

  • Index Cond: (geometry && '0101000020E61000001AC05B20417D54C0E10B93A982814140'::geography)
  • Filter: (('0101000020E61000001AC05B20417D54C0E10B93A982814140'::geography && _st_expand(geometry, '32168'::double precision)) AND _st_dwithin('0101000020E61000001AC05B20417D54C0E10B93A982814140'::geography, geometry, '32168'::double precision, true))
Planning time : 21.469 ms
Execution time : 189.749 ms