Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXPLAIN analyze SELECT ST_AsBinary("way") AS geom,"landuse","military","natural" FROM (SELECT way,aeroway,amenity,landuse,leisure,man_made,military,"natural",POWER,tourism,name,highway,
- CASE WHEN religion IN ('christian','jewish') THEN religion ELSE 'INT-generic'::text END AS religion
- FROM planet_osm_polygon
- WHERE landuse IS NOT NULL
- OR leisure IS NOT NULL
- OR aeroway IN ('apron','aerodrome')
- OR amenity IN ('parking','university','college','school','hospital','kindergarten','grave_yard','prison')
- OR military IN ('barracks','danger_area')
- OR "natural" IN ('field','beach','desert','heath','mud','grassland','wood','sand','scrub')
- OR POWER IN ('station','sub_station','generator')
- OR tourism IN ('attraction','camp_site','caravan_site','picnic_site','zoo')
- OR highway IN ('services','rest_area')
- ORDER BY z_order,way_area DESC
- ) AS leisure WHERE "way" && ST_SetSRID('BOX3D(-90.35156250000171 40.71395582622718,-84.02343749999829 45.33670190991032)'::box3d, 4326)
- Subquery Scan ON leisure (cost=560972.26..566486.72 ROWS=100263 width=296) (actual TIME=795.796..944.726 ROWS=109992 loops=1)
- -> Sort (cost=560972.26..561222.91 ROWS=100263 width=391) (actual TIME=795.762..830.641 ROWS=109992 loops=1)
- Sort KEY: planet_osm_polygon.z_order, planet_osm_polygon.way_area
- Sort Method: quicksort Memory: 66602kB
- -> Bitmap Heap Scan ON planet_osm_polygon (cost=5552.37..552643.70 ROWS=100263 width=391) (actual TIME=57.694..282.032 ROWS=109992 loops=1)
- Recheck Cond: ((way && '0103000020E6100000010000000500000078000000809656C09A378EE7625B444078000000809656C064C8550C19AB464088FFFFFF7F0155C064C8550C19AB464088FFFFFF7F0155C09A378EE7625B444078000000809656C09A378EE7625B4440'::geometry) AND ((landuse IS NOT NULL) OR (leisure IS NOT NULL) OR (aeroway IS NOT NULL) OR (amenity IS NOT NULL) OR (military IS NOT NULL) OR ("natural" IS NOT NULL) OR (POWER IS NOT NULL) OR (tourism IS NOT NULL) OR (highway IS NOT NULL)))
- FILTER: ((landuse IS NOT NULL) OR (leisure IS NOT NULL) OR (aeroway = ANY ('{apron,aerodrome}'::text[])) OR (amenity = ANY ('{parking,university,college,school,hospital,kindergarten,grave_yard,prison}'::text[])) OR (military = ANY ('{barracks,danger_area}'::text[])) OR ("natural" = ANY ('{field,beach,desert,heath,mud,grassland,wood,sand,scrub}'::text[])) OR (POWER = ANY ('{station,sub_station,generator}'::text[])) OR (tourism = ANY ('{attraction,camp_site,caravan_site,picnic_site,zoo}'::text[])) OR (highway = ANY ('{services,rest_area}'::text[])))
- ROWS Removed BY FILTER: 52924
- -> Bitmap INDEX Scan ON planet_osm_polygon_leisure (cost=0.00..5527.31 ROWS=149185 width=0) (actual TIME=38.468..38.468 ROWS=162916 loops=1)
- INDEX Cond: (way && '0103000020E6100000010000000500000078000000809656C09A378EE7625B444078000000809656C064C8550C19AB464088FFFFFF7F0155C064C8550C19AB464088FFFFFF7F0155C09A378EE7625B444078000000809656C09A378EE7625B4440'::geometry)
- Total runtime: 967.613 ms
- EXPLAIN analyze SELECT ST_AsBinary("way") AS geom,"aeroway","name" FROM (SELECT *
- FROM planet_osm_polygon
- WHERE aeroway IN ('airport','aerodrome','helipad')
- OR barrier IN ('bollard','gate','lift_gate','block')
- OR highway IN ('mini_roundabout','gate')
- OR man_made IN ('lighthouse','power_wind','windmill','mast')
- OR (POWER='generator' AND ("generator:source"='wind' OR power_source='wind'))
- OR "natural" IN ('peak','volcano','spring','tree')
- OR railway='level_crossing'
- ) AS symbols WHERE "way" && ST_SetSRID('BOX3D(-90.35156250000171 40.71395582622718,-84.02343749999829 45.33670190991032)'::box3d, 4326)
- Bitmap Heap Scan ON planet_osm_polygon (cost=44733.09..2770447.55 ROWS=4646 width=300) (actual TIME=296.556..997.751 ROWS=234 loops=1)
- Recheck Cond: (way && '0103000020E6100000010000000500000078000000809656C09A378EE7625B444078000000809656C064C8550C19AB464088FFFFFF7F0155C064C8550C19AB464088FFFFFF7F0155C09A378EE7625B444078000000809656C09A378EE7625B4440'::geometry)
- FILTER: ((aeroway = ANY ('{airport,aerodrome,helipad}'::text[])) OR (barrier = ANY ('{bollard,gate,lift_gate,block}'::text[])) OR (highway = ANY ('{mini_roundabout,gate}'::text[])) OR (man_made = ANY ('{lighthouse,power_wind,windmill,mast}'::text[])) OR ((POWER = 'generator'::text) AND (("generator:source" = 'wind'::text) OR (power_source = 'wind'::text))) OR ("natural" = ANY ('{peak,volcano,spring,tree}'::text[])) OR (railway = 'level_crossing'::text))
- ROWS Removed BY FILTER: 1174268
- -> Bitmap INDEX Scan ON planet_osm_polygon_index (cost=0.00..44731.93 ROWS=917251 width=0) (actual TIME=253.408..253.408 ROWS=1174502 loops=1)
- INDEX Cond: (way && '0103000020E6100000010000000500000078000000809656C09A378EE7625B444078000000809656C064C8550C19AB464088FFFFFF7F0155C064C8550C19AB464088FFFFFF7F0155C09A378EE7625B444078000000809656C09A378EE7625B4440'::geometry)
- Total runtime: 997.892 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement