explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Y1d

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

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

  • Index Cond: (geometry && '0101000020E61000001AC05B20417D54C0E10B93A982814140'::geography)
  • Filter: (('0101000020E61000001AC05B20417D54C0E10B93A982814140'::geography && _st_expand(geometry, '16093'::double precision)) AND _st_dwithin('0101000020E61000001AC05B20417D54C0E10B93A982814140'::geography, geometry, '16093'::double precision, false))
Planning time : 1.087 ms
Execution time : 67.332 ms