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

From: Max Williams <Max(dot)Williams(at)mflow(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to log query parameters instead of variables with log_min_duration_statement
Date: 2010-06-28 15:30:01
Message-ID: 0357196CB603794BB76F4F6B373F27330506EACE9C@SERVER.ddnglobal.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 28 June 2010 15:28
To: Max Williams
Cc: pgsql-general(at)postgresql(dot)org
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-06-28 15:33:18 Re: convert accented character to base character
Previous Message Neubert Joachim 2010-06-28 15:22:19 convert accented character to base character