Re: Is there any tool which will help me run and explain analyze about 150 queries?
| От | kunwar singh |
|---|---|
| Тема | Re: Is there any tool which will help me run and explain analyze about 150 queries? |
| Дата | |
| Msg-id | CAJSrDUp=eVr7=h5bxiW=v+afS0dhaHni=ggkZfV7t8-wxjftQw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Is there any tool which will help me run and explain analyze about 150 queries? (kyle Hailey <kylelf@gmail.com>) |
| Список | 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@gmail.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.111@gmail.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
Kunwar
В списке pgsql-performance по дате отправления: