Unnamed

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)