From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexander Stanier <alexander.stanier@egsgroup.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Change in logging behaviour between 8.1 and 8.2
Date: Fri, 24 Oct 2008 19:56:01 -0400
Message-ID: <6092.1224892561@sss.pgh.pa.us> (raw)
In-Reply-To: <4901E4ED.7090301@egsgroup.com>
References: <4901E4ED.7090301@egsgroup.com>
Alexander Stanier <alexander.stanier@egsgroup.com> writes:
> We have the following parameters in our postgresql.conf:
> log_min_duration_statement = 10000
> log_duration = on
> log_statement = 'all'
> In PostgreSQL 8.2, it seems the statement and duration are no longer
> logged together (i.e. not on the same log line) which means that you
> can't easily decipher those durations/statements which have been logged
> by log_duration/log_statement from those that have been logged by
> log_min_duration_statement. The fact that they were on one line made
> them very easy to pull out of the logs.
> Was this change intentional?
Yes. People complained about double logging of the full statement text.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, alexander.stanier@egsgroup.com
Subject: Re: Change in logging behaviour between 8.1 and 8.2
In-Reply-To: <6092.1224892561@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox