Just wrote up my experiences setting up auto_explain on Google Cloud SQL to get explain analyze:
On Fri, Apr 7, 2023 at 9:40 PM Jerry Sievers <gsievers19@xxxxxxxxxxx> wrote:
kunwar singh <krishsingh.111@xxxxxxxxx> 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
