Prepend "EXPLAIN ANALYZE " on every statement :
cat foo.sql | awk '{print " EXPLAIN (ANALYZE, BUFFERS, TIMING, SUMMARY)
" $0}' | psql testdb -f -
Στις 7/4/23 20:57, ο/η kunwar singh έγραψε:
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 :)
--
Cheers,
Kunwar
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt
