explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U3ev

Settings
# exclusive inclusive rows x rows loops node
1. 0.184 12,326.263 ↑ 1.0 1,000 1

Limit (cost=0.29..1,473.37 rows=1,000 width=87) (actual time=0.655..12,326.263 rows=1,000 loops=1)

2. 12,326.079 12,326.079 ↑ 251.3 1,000 1

Index Scan using planet_osm_polygon_lowzoom_lakelabel_1 on planet_osm_polygon (cost=0.29..367,694.36 rows=251,315 width=87) (actual time=0.653..12,326.079 rows=1,000 loops=1)

Planning time : 0.364 ms
Execution time : 12,326.453 ms