[postgis-users] Queries slow after PostGIS upgrade

[Paul Ramsey]

On Wed, Oct 26, 2022 at 3:03 PM Christopher Swingley <cswingle at 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.