Re: SQL Performance Analyzer equivalent in Postgres

From: kyle Hailey <kylelf_at_gmail.com>
Date: Sun, 9 Apr 2023 08:42:46 -0700
Message-ID: <CADsdiQgtmOejd0Mzytr-pL9888HDVO9xP+NBLmnJeKjFgeAvdQ_at_mail.gmail.com>



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
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Apr 09 2023 - 17:42:46 CEST

Original text of this message