Re: Log actual params for prepared queries: TO-DO item?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Log actual params for prepared queries: TO-DO item?
Date: 2006-07-18 18:04:25
Message-ID: 200607181804.k6II4Pi09619@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ed L. wrote:
>
> We'd like to attempt some log replay to simulate real loads, but
> in 8.1.2, it appears the formal parameters are logged ('$')
> instead of the actuals for prepared queries, e.g.:
>
> EXECUTE <unnamed> [PREPARE: UPDATE sessions SET a_session = $1
> WHERE id = $2]
>
> Thoughts on making this a to-do item?

It is already a TODO item:

* Allow protocol-level BIND parameter values to be logged

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christian Rengstl 2006-07-18 18:24:54 Antw: Performance problem with query
Previous Message Robert Treat 2006-07-18 17:50:13 Re: PostgreSQL on Embeded Systems