explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uZh : OSM Counties in Colorado

Settings
# exclusive inclusive rows x rows loops node
1. 0.089 39.587 ↓ 21.7 65 1

Nested Loop (cost=0.15..1,581.86 rows=3 width=8,036) (actual time=2.248..39.587 rows=65 loops=1)

  • Output: i.osm_id, i.name, i.admin_level, i.boundary, i.way, i.code
  • Buffers: shared hit=2189
2. 2.880 2.880 ↑ 1.0 1 1

Seq Scan on osm.boundary_polygon bp (cost=0.00..1,472.12 rows=1 width=7,996) (actual time=0.746..2.880 rows=1 loops=1)

  • Output: bp.osm_id, bp.name, bp.admin_level, bp.boundary, bp.way, bp.code
  • Filter: (bp.name = 'Colorado'::text)
  • Rows Removed by Filter: 4009
  • Buffers: shared hit=1422
3. 36.618 36.618 ↓ 65.0 65 1

Index Scan using gix_osm_boundary_polygon on osm.boundary_polygon i (cost=0.15..109.73 rows=1 width=8,036) (actual time=1.463..36.618 rows=65 loops=1)

  • Output: i.osm_id, i.name, i.admin_level, i.boundary, i.way, i.code
  • Index Cond: (i.way @ bp.way)
  • Filter: ((i.admin_level = '6'::text) AND st_contains(bp.way, i.way))
  • Rows Removed by Filter: 428
  • Buffers: shared hit=762
Planning time : 1.354 ms
Execution time : 39.800 ms