Re: log_statement GUC parameter - Mailing list pgsql-general

From Adrian Klaver
Subject Re: log_statement GUC parameter
Date
Msg-id e9ab9151-6f4d-e7bf-d5d5-0ec3d06695cf@aklaver.com
Whole thread Raw
In response to log_statement GUC parameter  (Mladen Gogala <gogala.mladen@gmail.com>)
Responses Re: log_statement GUC parameter  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: log_statement GUC parameter
Next
From: Tom Lane
Date:
Subject: Re: log_statement GUC parameter