Just wrote up my experiences setting up auto_explain on Google Cloud SQL to get explain analyze:
https://www.kylehailey.com/post/auto_explain-on-google-cloud-sql-gcp On Fri, Apr 7, 2023 at 9:40 PM Jerry Sievers <gsiever...@comcast.net> wrote: > kunwar singh <krishsingh....@gmail.com> writes: > > > Hi Listers, > > Anyone here use such a tool for Postgres? Any recommendations? > > > > Say I have 150 queries in Postgres 11 and I want to upgrade to Postgres > 15. I want to run explain analyze for 150 in both versions for comparative > > analysis. > > > > I am looking for the easiest way to do it with a tool :) > > I'd use a tool like bash for this which is very affordable :-) > > Just load your queries into individual files in some directory with a > .sql suffix... > > for file in $some-directory/*.sql; do > psql <<EOF >$file.explain-output 2>&1 > explain analyze > $(<$file) > EOF > done > > >
