On Wed, Oct 26, 2022 at 3:03 PM Christopher Swingley <cswin...@gmail.com> 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 postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users