Re: Capturing just slow queries

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(dot)bertels(at)ucll(dot)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
>
>
>
>