explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yaM3

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

Index Scan using demographics_2019_gen_geometry_1578581398166 on demographics_2019_gen demographics_2019_gen (cost=0..0 rows=0 width=0) (actual rows=297 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 : 18.901 ms
Execution time : 41.688 ms