Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXPLAIN analyze SELECT ST_AsBinary("way") AS geom,"highway","railway" FROM (SELECT way,highway,
- CASE WHEN tunnel IN ('yes','true','1') THEN 'yes'::text ELSE tunnel END AS tunnel,
- CASE WHEN railway='preserved' AND service IN ('spur','siding','yard') THEN 'INT-preserved-ssy'::text ELSE railway END AS railway
- FROM planet_osm_roads
- WHERE highway IS NOT NULL
- OR (railway IS NOT NULL AND railway!='preserved' AND (service IS NULL OR service NOT IN ('spur','siding','yard')))
- OR railway='preserved'
- ORDER BY z_order
- ) AS roads WHERE "way" && ST_SetSRID('BOX3D(-136.4062500000068 39.90973623433025,-111.0937499999932 56.55948248355774)'::box3d, 4326)
- Subquery Scan ON roads (cost=627415.19..634464.81 ROWS=128175 width=633) (actual TIME=430.464..574.934 ROWS=121562 loops=1)
- -> Sort (cost=627415.19..627735.62 ROWS=128175 width=619) (actual TIME=430.433..461.885 ROWS=121562 loops=1)
- Sort KEY: planet_osm_roads.z_order
- Sort Method: quicksort Memory: 55454kB
- -> Bitmap Heap Scan ON planet_osm_roads (cost=36126.36..616540.98 ROWS=128175 width=619) (actual TIME=55.172..337.414 ROWS=121562 loops=1)
- Recheck Cond: (way && '0103000020E61000000100000005000000EF000000000D61C0A237A73C72F44340EF000000000D61C05DC83C1F9D474C4021FEFFFFFFC55BC05DC83C1F9D474C4021FEFFFFFFC55BC0A237A73C72F44340EF000000000D61C0A237A73C72F44340'::geometry)
- FILTER: ((highway IS NOT NULL) OR ((railway IS NOT NULL) AND (railway <> 'preserved'::text) AND ((service IS NULL) OR (service <> ALL ('{spur,siding,yard}'::text[])))) OR (railway = 'preserved'::text))
- ROWS Removed BY FILTER: 26972
- -> Bitmap INDEX Scan ON planet_osm_roads_index (cost=0.00..36094.31 ROWS=173586 width=0) (actual TIME=37.131..37.131 ROWS=148534 loops=1)
- INDEX Cond: (way && '0103000020E61000000100000005000000EF000000000D61C0A237A73C72F44340EF000000000D61C05DC83C1F9D474C4021FEFFFFFFC55BC05DC83C1F9D474C4021FEFFFFFFC55BC0A237A73C72F44340EF000000000D61C0A237A73C72F44340'::geometry)
- Total runtime: 599.185 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement