> 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
_______________________________________________
Maps-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/maps-l
