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. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
