Capturing just slow queries - Mailing list pgsql-general

From Tiffany Thang
Subject Capturing just slow queries
Date
Msg-id CAB_W-NOT-XvBi02AkAZAyRgaNbtp5PPdpV3uYe3braUdTB9jzQ@mail.gmail.com
Whole thread Raw
Responses Re: Capturing just slow queries
List pgsql-general
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 

pgsql-general by date:

Previous
From: Jehan-Guillaume de Rorthais
Date:
Subject: Re: Clustering solution ?
Next
From: Devraj B
Date:
Subject: Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password?