explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cWhr

Settings
# exclusive inclusive rows x rows loops node
1. 0.508 2.168 ↑ 1.0 1 1

Aggregate (cost=739.98..739.99 rows=1 width=32) (actual time=2.167..2.168 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.033 0.033 ↑ 1.0 1 1

Index Scan using parcel_pkey on parcels pp (cost=0.42..8.44 rows=1 width=138) (actual time=0.032..0.033 rows=1 loops=1)

  • Index Cond: (gid = 512)
4. 1.627 1.627 ↑ 4.3 3 1

Index Scan using parcels_geom_idx on parcels p (cost=25.28..731.51 rows=13 width=138) (actual time=1.389..1.627 rows=3 loops=1)

  • Index Cond: (geom && st_buffer($0, '1e-08'::double precision, ''::text))
  • Filter: st_intersects(geom, st_buffer($0, '1e-08'::double precision, ''::text))