Advertisement
Guest User

Untitled

a guest
Apr 28th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.55 KB | None | 0 0
  1. 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));
  2.  
  3.  
  4. QUERY PLAN
  5.  
  6.  
  7. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  8. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  9. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  10. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  11. -----------------------------------------------------------------------------------------------------------
  12. Seq Scan on renovation_house (cost=0.00..13554.27 rows=2920 width=32) (actual time=0.084..77.746 rows=8752 loops=1)
  13. Filter: (is_active AND ((('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D434067BCF60542074C400000
  14. 0000904D4340'::geometry ~ center) AND _st_contains('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B4000000000904D43
  15. 4067BCF60542074C4000000000904D4340'::geometry, center)) OR (('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000000705042404A887A491CB84B400000
  16. 0000904D434067BCF60542074C4000000000904D4340'::geometry && outline_edited) AND _st_overlaps('0103000000010000000500000067BCF60542074C4000000000904D434067BCF60542074C4001000000705042404A887A491CB84B4001000
  17. 000705042404A887A491CB84B4000000000904D434067BCF60542074C4000000000904D4340'::geometry, outline_edited))))
  18. Rows Removed by Filter: 66
  19. Planning time: 0.425 ms
  20. Execution time: 78.664 ms
  21. (5 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement