gis=# explain analyze select asbinary(way) as geom,"boundary","highway" from (select * from planet_osm_line order by z_order) as roads where way && setSRID('BOX3D(-10664494.18634779 4676723.13860022,-10312272.3600097 5028944.964938315)'::box3d,900913); QUERY PLAN --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Subquery Scan roads (cost=722365.76..725194.35 rows=188573 width=96) (actual time=23612.238..28642.267 rows=180450 loops=1) -> Sort (cost=722365.76..722837.19 rows=188573 width=863) (actual time=23612.161..24862.514 rows=180450 loops=1) Sort Key: z_order -> Bitmap Heap Scan on planet_osm_line (cost=1863.01..402332.27 rows=188573 width=863) (actual time=749.158..6088.303 rows=180450 loops=1) Filter: (way && '010300002031BF0D000100000005000000A48FF6C5455764C175D3DEC81CD75141A48FF6C5455764C1A28CC13D142F53411033850B4AAB63C1A28CC13D142F53411033850B4AAB63C175D3DEC81CD75141A48FF6C5455764C175D3DEC81CD75141'::geometry) -> Bitmap Index Scan on planet_osm_line_index (cost=0.00..1863.01 rows=188573 width=0) (actual time=738.467..738.467 rows=180450 loops=1) Index Cond: (way && '010300002031BF0D000100000005000000A48FF6C5455764C175D3DEC81CD75141A48FF6C5455764C1A28CC13D142F53411033850B4AAB63C1A28CC13D142F53411033850B4AAB63C175D3DEC81CD75141A48FF6C5455764C175D3DEC81CD75141'::geometry) Total runtime: 30132.918 ms (8 rows)