Re: log_statement GUC parameter

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: log_statement GUC parameter
Date: 2021-08-12 20:28:55
Message-ID: e9ab9151-6f4d-e7bf-d5d5-0ec3d06695cf@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/12/21 1:19 PM, Mladen Gogala wrote:
> Hi!
>

> The idea is to log all statements by the particular user, not by
> everybody. The user in question uses Weblogic 12.2.1.4  and creates a
> connection pool so I need to find out which statements are the longest
> running ones and make them perform.

Would pg_stat_statements work for you?:

https://www.postgresql.org/docs/current/pgstatstatements.html

>
> Regards
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-08-12 20:30:12 Re: log_statement GUC parameter
Previous Message Bruce Momjian 2021-08-12 20:23:08 Re: log_statement GUC parameter