Re: SQL Performance Analyzer equivalent in Postgres

+1 to discussing Postgres for the same reasons.

Thanks for your great input, Mladen! I will review POWA.

On Sun, Apr 9, 2023 at 11:44 AM kyle Hailey <kylelf_at_gmail.com> wrote:

>
> I super support Postgres questions here. Oracle traffic has practically
> stopped here. Most of us have branched out into MySQL and/or Postgres as
> well as Oracle over the past 10 years.
> I'd rather discuss Postgres with people here than the postgres community.
> We have a shared understanding and a shared empathy.
>
>
>
> On Sat, Apr 8, 2023 at 9:10 PM Mladen Gogala <gogala.mladen_at_gmail.com>
> wrote:
>
>> 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-1217https://dbwhisperer.wordpress.com
>>
>>

-- 
Cheers,
Kunwar

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