Tom Lane wrote:
> "Martin A. Brooks" <[EMAIL PROTECTED]> 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 stat
"Martin A. Brooks" <[EMAIL PROTECTED]> 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
Vladimir Rusinov wrote:
May be you have log_min_messages = debug?
Please, show full logging section.
I don't explicitly set that parameter in my config. The full config
file can be found at http://www.antibodymx.net/postgresql.conf
Thanks
--
Martin A. Brooks | http://www.antibodymx.net/
On Tue, Oct 14, 2008 at 1:23 PM, Martin A. Brooks <[EMAIL PROTECTED]>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:
>
> [EMAIL PROTECTED]:/etc/postgresql/8.3/main# grep
Guillaume Lelarge wrote:
Martin A. Brooks a écrit :
I _want_ the stats, however I _only_ want the stats for queries taking
over 5 seconds.
Well, AFAIK, you can't.
Then that would seem to entirely negate the point of having the
log_min_duration_statement option, from what I can s
Martin A. Brooks a écrit :
> Guillaume Lelarge wrote:
>> Martin A. Brooks a écrit :
>>
>>> However, in the log files, I'm seeing entries for all SQL executed, not
>>> just that taking 5000ms or more. For example:
>>>
>>> 2008-10-14 10:15:50 BST PID:20349 DB:vhdb LOG: statement: select * from
>>>
Guillaume Lelarge wrote:
Martin A. Brooks a écrit :
However, in the log files, I'm seeing entries for all SQL executed, not
just that taking 5000ms or more. For example:
2008-10-14 10:15:50 BST PID:20349 DB:vhdb LOG: statement: select * from
vendors;
2008-10-14 10:15:50 BST PID:20349 DB:vhd
Martin A. Brooks a écrit :
> 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:
>
> [EMAIL PROTECTED]:/etc/postgresql/8.3/main# grep log_min_duration
> postgresql.conf
> log_min_du
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:
[EMAIL PROTECTED]:/etc/postgresql/8.3/main# grep log_min_duration
postgresql.conf
log_min_duration_statement = 5000 # -1 is di
