[postgis-users] ST_Overlaps and performance

[DrYSG]

explain analyze:

"Bitmap Heap Scan on catalog cat  (cost=57.58..6059.77 rows=1532 width=843)
(actual time=2182.439..12578.026 rows=2649 loops=1)"

"  Recheck Cond: (location &&
'0103000020E61000000100000005000000EC8A749A60BC51C0DA53724EECC444408ABAC5B2CF2152C0DA53724EECC444408ABAC5B2CF2152C093CE763BB1934440EC8A749A60BC51C093CE763BB1934440EC8A749A60BC51C0DA53724EECC44440'::geometry)"

"  ->  Bitmap Index Scan on catalog_location_idx  (cost=0.00..57.19
rows=1532 width=0) (actual time=2181.640..2181.640 rows=2665 loops=1)"

"        Index Cond: (location &&
'0103000020E61000000100000005000000EC8A749A60BC51C0DA53724EECC444408ABAC5B2CF2152C0DA53724EECC444408ABAC5B2CF2152C093CE763BB1934440EC8A749A60BC51C093CE763BB1934440EC8A749A60BC51C0DA53724EECC44440'::geometry)"

"Total runtime: 12578.939 ms"

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