Max Williams writes:
> I'm running 8.4.4 so you are saying this should work?
Works for me, just as described here:
http://archives.postgresql.org/pgsql-committers/2006-09/msg00152.php
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
ql-general@postgresql.org
Subject: Re: [GENERAL] How to log query parameters instead of variables with
log_min_duration_statement
Max Williams 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 mor
Max Williams 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.
On Mon, Jun 28, 2010 at 5:29 AM, Max Williams wrote:
> Hi,
>
> I am logging long queries with log_min_duration_statement but would like to
> see the parameters for parameterized queries. Eg…
>
Consider increasing log level. I think you need to go to "debug" at least.
--
Sent via pgsql-general
Hi,
I am logging long queries with log_min_duration_statement but would like to see
the parameters for parameterized queries. Eg...
Jun 28 10:21:49 dbs1 postgres[20866]: [2-1] LOG: duration: 6625.543 ms
execute PRSTMT1405204512-1371060978/PORTAL1405204512-1371060978: SELECT COUNT(*)
Jun 28 10: