Re: Log actual params for prepared queries: TO-DO item? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Log actual params for prepared queries: TO-DO item?
Date
Msg-id 200607181804.k6II4Pi09619@momjian.us
Whole thread Raw
In response to Log actual params for prepared queries: TO-DO item?  ("Ed L." <pgsql@bluepolka.net>)
List 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@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

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

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: PostgreSQL on Embeded Systems
Next
From: "Christian Rengstl"
Date:
Subject: Antw: Performance problem with query