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 renovation_house.is_active = true AND (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) OR ST_Overlaps('POLYGON((56.056702371098076 38.60595703125,56.056702371098076 36.62841796875001, 55.43836325152422 36.62841796875001,55.43836325152422 38.60595703125, 56.056702371098076 38.60595703125))', renovation_house.outline_edited));
- QUERY PLAN
- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- -----------------------------------------------------------------------------------------------------------
- Seq Scan on renovation_house (cost=0.00..13554.27 rows=2920 width=32) (actual time=0.084..77.746 rows=8752 loops=1)
- Filter: (is_active AND ((('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D434067BCF60542074C400000
- 0000904D4340'::geometry ~ center) AND _st_contains('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D43
- 4067BCF60542074C4000000000904D4340'::geometry, center)) OR (('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B400000
- 0000904D434067BCF60542074C4000000000904D4340'::geometry && outline_edited) AND _st_overlaps('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000
- 000705042404A887A491CB84B4000000000904D434067BCF60542074C4000000000904D4340'::geometry, outline_edited))))
- Rows Removed by Filter: 66
- Planning time: 0.425 ms
- Execution time: 78.664 ms
- (5 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement