Postgres Pro
Downloads
Home   >   mailing lists

Re: How to log query parameters instead of variables with log_min_duration_statement - Mailing list pgsql-general

From Max Williams
Subject Re: How to log query parameters instead of variables with log_min_duration_statement
Date
Msg-id 0357196CB603794BB76F4F6B373F27330506EACE9C@SERVER.ddnglobal.local
Whole thread Raw
In response to Re: How to log query parameters instead of variables with log_min_duration_statement  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to log query parameters instead of variables with log_min_duration_statement  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Neubert Joachim"
Date:
Subject: convert accented character to base character
Next
From: Thom Brown
Date:
Subject: Re: convert accented character to base character