Re: Is there any tool which will help me run and explain analyze about 150 queries?

Поиск
Список
Период
Сортировка
От kyle Hailey
Тема Re: Is there any tool which will help me run and explain analyze about 150 queries?
Дата
Msg-id CADsdiQg-9d-eB16BadUtbTjuWFBEKecfunP90ce8vSccpsK2-g@mail.gmail.com
обсуждение исходный текст
Ответ на Is there any tool which will help me run and explain analyze about 150 queries?  (kunwar singh <krishsingh.111@gmail.com>)
Ответы Re: Is there any tool which will help me run and explain analyze about 150 queries?  (kunwar singh <krishsingh.111@gmail.com>)
Список 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.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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: 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?