explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IIIR

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.029 193,636.637 ↓ 65.0 65 1

Subquery Scan on country_names (cost=16,293,189.56..16,293,189.60 rows=1 width=60) (actual time=193,636.610..193,636.637 rows=65 loops=1)

2. 0.133 193,636.608 ↓ 65.0 65 1

Sort (cost=16,293,189.56..16,293,189.56 rows=1 width=64) (actual time=193,636.601..193,636.608 rows=65 loops=1)

  • Sort Key: planet_osm_polygon.way_area DESC
  • Sort Method: quicksort Memory: 34kB
3. 1.131 193,636.475 ↓ 65.0 65 1

Gather (cost=1,000.00..16,293,189.55 rows=1 width=64) (actual time=66,989.587..193,636.475 rows=65 loops=1)

  • Workers Planned: 8
  • Workers Launched: 0
4. 193,635.344 193,635.344 ↓ 65.0 65 1

Parallel Seq Scan on planet_osm_polygon (cost=0.00..16,292,189.45 rows=1 width=64) (actual time=66,988.696..193,635.344 rows=65 loops=1)

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