[postgis-users] ST_Overlaps and performance

[DrYSG]

The explain query for your query is:

"Index Scan using loc_idx on metadata cat  (cost=0.00..1050.88 rows=253
width=845)"

> SELECT * 
> FROM portal.catalog as cat 
> WHERE ST_Contains(cat.location,'SRID=4326;POINT(70.9433962 
> 41.5384615)'::geometry) OR 
>        ST_Contains(cat.location,'SRID=4326;POINT(71.9433962 
> 40.5384615)'::geometry)  ; 


--
View this message in context: http://postgis.17.n6.nabble.com/ST-Overlaps-and-performance-tp4555465p4555707.html
Sent from the PostGIS - User mailing list archive at Nabble.com.