Re: Capturing just slow queries

2020-07-17 Thread Tiffany Thang
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:

Re: Capturing just slow queries

2020-07-17 Thread Wim Bertels
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

Capturing just slow queries

2020-07-16 Thread Tiffany Thang
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