From: | Wim Bertels <wim(dot)bertels(at)ucll(dot)be> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Capturing just slow queries |
Date: | 2020-07-17 08:14:28 |
Message-ID: | 7641998463cb4bfaff549426d6f81a3d3f96188b.camel@ucll.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tiffany Thang | 2020-07-17 09:44:52 | Re: Capturing just slow queries |
Previous Message | Naresh Kumar | 2020-07-17 03:06:05 | Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" |