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