Advertisement
Guest User

Untitled

a guest
Apr 28th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. altmos_beta=# explain analyze SELECT ST_AsGeoJSON(renovation_house.center) AS center
  2. FROM renovation_house
  3. WHERE (ST_Contains('POLYGON((56.056702371098076 38.60595703125,56.056702371098076 36.62841796875001, 55.43836325152422 36.62841796875001,55.43836325152422 38.60595703125, 56.056702371098076 38.60595703125))', renovation_house.center)); Bitmap Heap Scan on renovation_house (cost=4.22..48.12 rows=3 width=32) (actual time=3.596..87.040 rows=8817 loops=1)
  4. Recheck Cond: ('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D434067BCF60542074C4000000000904D434
  5. 0'::geometry ~ center)
  6. Filter: _st_contains('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D434067BCF60542074C40000000009
  7. 04D4340'::geometry, center)
  8. Heap Blocks: exact=1087
  9. -> Bitmap Index Scan on center_house_index (cost=0.00..4.22 rows=9 width=0) (actual time=3.251..3.251 rows=8817 loops=1)
  10. Index Cond: ('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D434067BCF60542074C4000000000904
  11. D4340'::geometry ~ center)
  12. Planning time: 0.338 ms
  13. Execution time: 88.655 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement