Capturing just slow queries

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

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: