explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wgdA

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

Aggregate (cost=366,076.82..366,076.83 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on planet_osm_polygon (cost=3,570.89..362,935.39 rows=251,315 width=100) (actual rows= loops=)

  • Recheck Cond: ((name IS NOT NULL) AND (("natural" = 'water'::text) OR (water = 'lake'::text) OR (landuse = ANY ('{basin,reservoir}'::text[]))))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on planet_osm_polygon_lowzoom_lakelabel_1 (cost=0.00..3,508.06 rows=251,315 width=0) (actual rows= loops=)