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 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 > > > >
Re: 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
Capturing just slow queries
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
