explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fyWy

Settings
# exclusive inclusive rows x rows loops node
1. 8,597.856 8,597.856 ↑ 2.1 590 1

Index Scan using planet_osm_polygon_lowzoom_lakelabel_2 on planet_osm_polygon (cost=0.29..256,245.84 rows=1,257 width=87) (actual time=0.890..8,597.856 rows=590 loops=1)

  • Filter: ((osm_id % '1000'::bigint) = 0)
  • Rows Removed by Filter: 530,035
Planning time : 0.149 ms
Execution time : 8,598.063 ms