Thread: 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
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:
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