Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 0773064FD2A
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 14 Oct 2008 08:42:02 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 11767-07 for <pgsql-admin-postgresql.org@postgresql.org>;
	Tue, 14 Oct 2008 08:41:48 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.232])
	by postgresql.org (Postfix) with ESMTP id F393B64FD25
	for <pgsql-admin@postgresql.org>; Tue, 14 Oct 2008 08:41:46 -0300 (ADT)
Received: by rv-out-0506.google.com with SMTP id b25so1938317rvf.43
	for <pgsql-admin@postgresql.org>; Tue, 14 Oct 2008 04:41:45 -0700 (PDT)
Received: by 10.141.29.18 with SMTP id g18mr4708076rvj.298.1223984505564;
	Tue, 14 Oct 2008 04:41:45 -0700 (PDT)
Received: by 10.140.134.11 with HTTP; Tue, 14 Oct 2008 04:41:45 -0700 (PDT)
Message-ID: <f6fdfb550810140441y75db39f3l7aea87cce27cc37f@mail.gmail.com>
Date: Tue, 14 Oct 2008 15:41:45 +0400
From: "Vladimir Rusinov" <vladimir@greenmice.info>
To: "Martin A. Brooks" <martin@antibodymx.net>
Subject: Re: postgres seems to ignore log_min_duration_statement
Cc: pgsql-admin@postgresql.org
In-Reply-To: <48F46514.1070203@antibodymx.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4136_17342320.1223984505561"
References: <48F46514.1070203@antibodymx.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200810/99
X-Sequence-Number: 30555

------=_Part_4136_17342320.1223984505561
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Tue, Oct 14, 2008 at 1:23 PM, Martin A. Brooks <martin@antibodymx.net>wrote:

> Hi
>
> I want to have postgres log sql statements that take longer than 5 seconds
> to execute.  In postgresql.conf I have set log_min_duration_statement as
> follows:
>
> root@martin-desktop:/etc/postgresql/8.3/main# grep log_min_duration
> postgresql.conf
> log_min_duration_statement = 5000       # -1 is disabled, 0 logs all
> statements



May be you have log_min_messages = debug?
Please, show full logging section.


-- 
Vladimir Rusinov
http://greenmice.info/

------=_Part_4136_17342320.1223984505561
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr"><br><br> <br><br><div class="gmail_quote">On Tue, Oct 14, 2008 at 1:23 PM, Martin A. Brooks <span dir="ltr">&lt;<a href="mailto:martin@antibodymx.net">martin@antibodymx.net</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi<br>
<br>
I want to have postgres log sql statements that take longer than 5 seconds to execute. &nbsp;In postgresql.conf I have set log_min_duration_statement as follows:<br>
<br>
root@martin-desktop:/etc/postgresql/8.3/main# grep log_min_duration postgresql.conf<br>
log_min_duration_statement = 5000 &nbsp; &nbsp; &nbsp; # -1 is disabled, 0 logs all statements</blockquote><div><br><br>May be you have log_min_messages = debug?<br>Please, show full logging section.<br></div></div><br clear="all"><br>
-- <br>Vladimir Rusinov<br><a href="http://greenmice.info/">http://greenmice.info/</a><br>
</div>

------=_Part_4136_17342320.1223984505561--