Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- altmos_beta=# explain analyze SELECT ST_AsGeoJSON(renovation_house.center) AS center
- FROM renovation_house
- 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)
- Recheck Cond: ('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D434067BCF60542074C4000000000904D434
- 0'::geometry ~ center)
- Filter: _st_contains('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D434067BCF60542074C40000000009
- 04D4340'::geometry, center)
- Heap Blocks: exact=1087
- -> 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)
- Index Cond: ('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D434067BCF60542074C4000000000904
- D4340'::geometry ~ center)
- Planning time: 0.338 ms
- Execution time: 88.655 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement