I'm running 8.4.4 so you are saying this should work?
I don't really want to go to debug level logging, tried it for 5 mins and it just logs too much!
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 28 June 2010 15:28
To: Max Williams
Subject: Re: [GENERAL] How to log query parameters instead of variables with log_min_duration_statement
Max Williams <Max(dot)Williams(at)mflow(dot)com> writes:
> I am logging long queries with log_min_duration_statement but would like to see the parameters for parameterized queries. Eg...
You need a more recent version of Postgres. The versions that can do
that at all (8.2 and up) will do it automatically.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Thom Brown||Date: 2010-06-28 15:33:18|
|Subject: Re: convert accented character to base character|
|Previous:||From: Neubert Joachim||Date: 2010-06-28 15:22:19|
|Subject: convert accented character to base character|