From: | kyle Hailey <kylelf(at)gmail(dot)com> |
---|---|
To: | kunwar singh <krishsingh(dot)111(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 18:40:47 |
Message-ID: | CADsdiQg-9d-eB16BadUtbTjuWFBEKecfunP90ce8vSccpsK2-g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | kunwar singh | 2023-04-07 20:48:59 | Re: Is there any tool which will help me run and explain analyze about 150 queries? |
Previous Message | Achilleas Mantzios | 2023-04-07 18:19:36 | Re: Is there any tool which will help me run and explain analyze about 150 queries? |