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, the two tools that can help you with that are Perl and Python. Basically, you should run explain on both versions, spool it into a file and then use scripting languages to compare the plans. Other than that, this is an Oracle group. I don't think that this group is meant for discussing PostgreSQL. You should try a Postgres mailing list. BTW, your list is far too long. Application suite usually hangs on 20 or so queries. 150 is a lot.

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

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