Advertisement
Guest User

Untitled

a guest
Apr 24th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. EXPLAIN ANALYZE
  2. SELECT g.gap_sts AS gap_sts
  3. FROM usgovt g, risk r
  4. WHERE
  5. ST_Intersects(g.geom, r.geom);
  6.  
  7. Nested Loop (cost=4.39..64.15 rows=48 width=2) (actual time=164.231..380784.381 rows=48456 loops=1)
  8. -> Seq Scan on risk r (cost=0.00..1.01 rows=1 width=32) (actual time=0.005..0.006 rows=1 loops=1)
  9. -> 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)
  10. Recheck Cond: (geom && r.geom)
  11. Filter: _st_intersects(geom, r.geom)
  12. Rows Removed by Filter: 71027
  13. Heap Blocks: exact=23099
  14. -> 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)
  15. Index Cond: (geom && r.geom)
  16. Planning time: 0.328 ms
  17. Execution time: 380855.965 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement