explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BG8G : Optimization for: Optimization for: plan #IIIR; plan #pd7P

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.023 995.614 ↓ 65.0 65 1

Subquery Scan on country_names (cost=2.82..2.86 rows=1 width=60) (actual time=995.594..995.614 rows=65 loops=1)

2. 0.157 995.591 ↓ 65.0 65 1

Sort (cost=2.82..2.82 rows=1 width=64) (actual time=995.587..995.591 rows=65 loops=1)

  • Sort Key: planet_osm_polygon.way_area DESC
  • Sort Method: quicksort Memory: 34kB
3. 995.434 995.434 ↓ 65.0 65 1

Index Scan using ix_planet_osm_1 on planet_osm_polygon (cost=0.57..2.81 rows=1 width=64) (actual time=53.337..995.434 rows=65 loops=1)

  • Index Cond: ((boundary = 'administrative'::text) AND (admin_level = '2'::text))
  • Filter: ((name IS NOT NULL) AND (way && '01030000A0110F00000100000005000000D61B7C45F81B33C100000040F81B73C10000000000000000D61B7C45F81B33C1D61B7C45F81B3341000000000000000000000040F81B7341D61B7C45F81B3341000000000000000000000040F81B734100000040F81B73C10000000000000000D61B7C45F81B33C100000040F81B73C10000000000000000'::geometry) AND (way_area > '9572549033.16736'::double precision) AND (osm_id < 0))
  • Rows Removed by Filter: 202
Planning time : 1.727 ms