Re: How to log query parameters instead of variables with log_min_duration_statement

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!

Max

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 28 June 2010 15:28
To: Max Williams
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to log query parameters instead of variables with log_min_duration_statement

Max Williams <Max.Williams@mflow.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