Log actual params for prepared queries: TO-DO item?
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?
Ed
On 7/15/06, Ed L. <pgsql@bluepolka.net> 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?
Ed
i think this is the one you are requesting, it's a TODO item already:
o Allow protocol-level BIND parameter values to be logged
--
Atentamente,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
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@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +