Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted by A ( 13 years ago )
gis=# explain SELECT ST_LineMerge(ST_Union(way)) as way,ref,highway,char_length(ref) as reflength FROM planet_osm_line WHERE way && ST_SetSRID('BOX3D(4060334.942508562 7504281.688925464,4236445.855677609 7680392.602094511)'::box3d, 900913) and ref is not null and highway is not null GROUP BY ref,highway;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
HashAggregate (cost=393541.60..393547.70 rows=23 width=1068)
-> Bitmap Heap Scan on planet_osm_line (cost=5056.15..393463.71 rows=10385 width=1068)
Recheck Cond: (way && '010300002031BF0D000100000005000000DD1EA47857FA4E41D45A176C66A05C41DD1EA47857FA4E416AB78826624C5D41056CC376272950416AB78826624C5D41056CC37627295041D45A176C66A05C41DD1EA47857FA4E41D45A176C66A05C41'::geometry)
Filter: ((ref IS NOT NULL) AND (highway IS NOT NULL))
-> Bitmap Index Scan on planet_osm_line_index (cost=0.00..5053.56 rows=135441 width=0)
Index Cond: (way && '010300002031BF0D000100000005000000DD1EA47857FA4E41D45A176C66A05C41DD1EA47857FA4E416AB78826624C5D41056CC376272950416AB78826624C5D41056CC37627295041D45A176C66A05C41DD1EA47857FA4E41D45A176C66A05C41'::geometry)
(6 rows)
Revise this Paste