osm_mapnik=# explain analyze select id from
planet_osm_ways where pending;
QUERY PLAN
-
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on planet_osm_ways (cost=0.00..1662990.31 rows=22160666 width=4) (actual
time=496448.422..496448.422 rows=0 loops=1)
Filter: pending
Total runtime: 496448.455 ms
After an ANALYZE it does an Index Scan, but this is not really faster:
QUERY
PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------
Index Scan using planet_osm_ways_idx on planet_osm_ways
(cost=0.00..9.82 rows=1 width=4)
(actual time=587600.044..587600.044 rows=0 loops=1)
Total runtime: 587600.088 ms
(2 rows)
Peter