Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx] 
Sent: 28 June 2010 15:28
To: Max Williams
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  How to log query parameters instead of variables with log_min_duration_statement 

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux