Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXPLAIN ANALYZE
- SELECT g.gap_sts AS gap_sts
- FROM usgovt g, risk r
- WHERE
- ST_Intersects(g.geom, r.geom);
- Nested Loop (cost=4.39..64.15 rows=48 width=2) (actual time=164.231..380784.381 rows=48456 loops=1)
- -> Seq Scan on risk r (cost=0.00..1.01 rows=1 width=32) (actual time=0.005..0.006 rows=1 loops=1)
- -> Bitmap Heap Scan on usgovt g (cost=4.39..63.09 rows=5 width=34) (actual time=164.223..380718.542 rows=48456 loops=1)
- Recheck Cond: (geom && r.geom)
- Filter: _st_intersects(geom, r.geom)
- Rows Removed by Filter: 71027
- Heap Blocks: exact=23099
- -> Bitmap Index Scan on usgovt_geom_idx (cost=0.00..4.39 rows=14 width=0) (actual time=24.500..24.500 rows=119483 loops=1)
- Index Cond: (geom && r.geom)
- Planning time: 0.328 ms
- Execution time: 380855.965 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement