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

From: zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to log query parameters instead of variables with log_min_duration_statement
Date: 2010-06-28 09:43:24
Message-ID: AANLkTikYoLba4GW-Npk6oXLq7TvEIwBYny8MJRUw0IUj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jun 28, 2010 at 5:29 AM, Max Williams <Max(dot)Williams(at)mflow(dot)com> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message RP Khare 2010-06-28 11:43:20 Enabling all backup options
Previous Message Max Williams 2010-06-28 09:29:29 How to log query parameters instead of variables with log_min_duration_statement