From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Martin A. Brooks <martin@antibodymx.net>
Cc: Vladimir Rusinov <vladimir@greenmice.info>
Cc: pgsql-admin@postgresql.org
Subject: Re: postgres seems to ignore log_min_duration_statement
Date: Wed, 15 Oct 2008 22:17:58 -0400 (EDT)
Message-ID: <200810160217.m9G2HwL03422@momjian.us> (raw)
In-Reply-To: <20724.1223989016@sss.pgh.pa.us>
Tom Lane wrote:
> "Martin A. Brooks" <martin@antibodymx.net> writes:
> > I don't explicitly set that parameter in my config. The full config
> > file can be found at http://www.antibodymx.net/postgresql.conf
>
> You've got log_duration on; that overrides log_min_duration_statement
> and forces statement durations to always be logged.
>
> (No, I'm not quite sure why we have both variables ...)
I believe log_duration prints just the duration and assumes you printed
the statement previously (when it arrived). log_min_duration_statement
by definition has to print after the statement completes.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
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: bruce@momjian.us, tgl@sss.pgh.pa.us, martin@antibodymx.net, vladimir@greenmice.info
Subject: Re: postgres seems to ignore log_min_duration_statement
In-Reply-To: <200810160217.m9G2HwL03422@momjian.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