Thanks, I'll check it out! On Sat, Apr 8, 2023 at 5:45 PM kyle Hailey <kyl...@gmail.com> wrote:
> > 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 >> >> >> -- Cheers, Kunwar
