Re: Capturing just slow queries

Поиск
Список
Период
Сортировка
От Tiffany Thang
Тема Re: Capturing just slow queries
Дата
Msg-id CAB_W-NOsS+AMFGiu2aEoxTKpKxCZa6YGKeNTaPRqxL1e4K99eA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Capturing just slow queries  (Wim Bertels <wim.bertels@ucll.be>)
Список pgsql-general
Thank you for the information. That's a comprehensive list of monitoring solutions. I'll take a look. 

Tiff

On Fri, Jul 17, 2020 at 4:14 AM Wim Bertels <wim.bertels@ucll.be> wrote:
You might have a look at:
https://www.postgresql.org/docs/current/auto-explain.html

Also there are several monitoring solutions:
https://wiki.postgresql.org/wiki/Monitoring


Tiffany Thang schreef op do 16-07-2020 om 13:41 [-0400]:
> Hi,
> log_min_duration_statement captures all statements including DMLs
> that have exceeded the threshold. Is there a way in PG 12 to capture
> just select statements excluding all DMLs and DDLs? In my
> environment, it's acceptable for DMLs and DDLs to cross the threshold
> and we are more interested in capturing poor performing select
> statements.
>
> Thanks.
>
> Tiff
--
mvg,
Wim Bertels
--
Lector
UC Leuven-Limburg
--
There is no hunting like the hunting of man, and those who have hunted
armed men long enough and liked it, never care for anything else thereafter.
                -- Ernest Hemingway



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

Предыдущее
От: Wim Bertels
Дата:
Сообщение: Re: Capturing just slow queries
Следующее
От: Eugene Poole
Дата:
Сообщение: Where Do I Find...