Re: postgres seems to ignore log_min_duration_statement

From: "Vladimir Rusinov" <vladimir(at)greenmice(dot)info>
To: "Martin A(dot) Brooks" <martin(at)antibodymx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres seems to ignore log_min_duration_statement
Date: 2008-10-14 11:41:45
Message-ID: f6fdfb550810140441y75db39f3l7aea87cce27cc37f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Oct 14, 2008 at 1:23 PM, Martin A. Brooks <martin(at)antibodymx(dot)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(at)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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Martin A. Brooks 2008-10-14 11:48:25 Re: postgres seems to ignore log_min_duration_statement
Previous Message Martin A. Brooks 2008-10-14 11:26:40 Re: postgres seems to ignore log_min_duration_statement