pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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. +



view thread (9+ messages)

Message-ID: <200810160217.m9G2HwL03422@momjian.us>
Permalink:  ../200810160217.m9G2HwL03422@momjian.us/
Also on:    postgresql.org/message-id/200810160217.m9G2HwL03422@momjian.us

 · 

reply

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