Re: SQL Performance Analyzer equivalent in Postgres

On 4/7/23 13:43, kunwar singh wrote:
> 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

Well, in my dealings with Postgres, I usually used pgBadger combined with log_min_duration_statement parameter to make sure that only the statements above certain execution threshold are logged. However, that approach will give you the most expenive statements and will not be able to compare plans between different versions. Installing pg_hint_plan extension will help you with fixing the incorrect plans. However, a little bit of Googling resulted in discovering POWA (https://powa.readthedocs.io). I have never used it so I don't know how good it is, but it certainly looks interesting.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l