On Wed, Oct 26, 2022 at 3:03 PM Christopher Swingley <[email protected]> wrote: > Can you do EXPLAIN ANALYZE on both systems for a query that's slower on the > AWS side to see what's consuming more time?
Importantly, "EXPLAIN ANALYZE" will give you the database-side execution time of a given query, and won't be affected by differences in network transit time. Good for comparing a local vs. a cloud query, since common tools (pgadmin, psql) will include the data transfer time in their default timing output. _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
