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.bert...@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 > > > >
