> 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
