From: | kunwar singh <krishsingh(dot)111(at)gmail(dot)com> |
---|---|
To: | kyle Hailey <kylelf(at)gmail(dot)com> |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: Is there any tool which will help me run and explain analyze about 150 queries? |
Date: | 2023-04-07 20:48:59 |
Message-ID: | CAJSrDUp=eVr7=h5bxiW=v+afS0dhaHni=ggkZfV7t8-wxjftQw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Thanks Kyle. I am also trying to get it working :).
@Archilleas ,Thanks for your inputs. Appreciate it. I am further
interested in learning if we can automate the generation/creation of foo.sql
by including queries with bind variables defined and bind values populated
( speaking in Oracle linguistics , pardon my Postgres ignorance, a newbie
here)
On Fri, Apr 7, 2023 at 2:41 PM kyle Hailey <kylelf(at)gmail(dot)com> wrote:
>
> In my opinion, Datadog is the best Postgres monitor available, but it
> doesn't have a feature that has been discussed. However, you can use
> auto_explain to analyze long-running queries by setting a limit. I recently
> enabled it in GCP Cloud SQL, but I haven't seen any results in the logs
> yet. I need to figure out which parameters to enable to get it working.
>
>
>
>
> On Fri, Apr 7, 2023 at 10:57 AM kunwar singh <krishsingh(dot)111(at)gmail(dot)com>
> 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
>>
>
--
Cheers,
Kunwar
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry Sievers | 2023-04-08 04:40:36 | Re: Is there any tool which will help me run and explain analyze about 150 queries? |
Previous Message | kyle Hailey | 2023-04-07 18:40:47 | Re: Is there any tool which will help me run and explain analyze about 150 queries? |