Capturing just slow queries

From: Tiffany Thang <tiffanythang(at)gmail(dot)com>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Capturing just slow queries
Date: 2020-07-16 17:41:56
Message-ID: CAB_W-NOT-XvBi02AkAZAyRgaNbtp5PPdpV3uYe3braUdTB9jzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devraj B 2020-07-16 19:04:13 Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password?
Previous Message Jehan-Guillaume de Rorthais 2020-07-16 11:03:17 Re: Clustering solution ?