Re: fix log_min_duration_statement logic error - Mailing list pgsql-patches

From Tom Lane
Subject Re: fix log_min_duration_statement logic error
Date
Msg-id 15038.1065389452@sss.pgh.pa.us
Whole thread Raw
In response to Re: fix log_min_duration_statement logic error  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: fix log_min_duration_statement logic error
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>            Sets a minimum statement execution time (in milliseconds)
>            above which a statement will be logged.  All SQL statements
>            that run longer than the time specified will be logged together
> !          with their actual duration.  Setting this to zero will print
> !          all queries with their durations.  Minus-one (the default)
> !          disables time-based logging.  For example, if you set it
>            to <literal>250</literal> then all SQL statements that run longer
> !          than 250ms will be logged.

You're being very unclear, not to say self-contradictory, as to whether
the condition is "> value" or ">= value".  I suspect it is really the
latter but this description sure doesn't convey the fact.

>            Only superusers can increase this or set it to zero if this option
>            is set to non-zero by the administrator.

If you're changing the "off" state to -1 then this last sentence is now
wrong, no?  Also, do the non-superuser adjustment constraints in guc.c
still work correctly with this meaning (probably so, but it needs to be
checked)?

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: fix log_min_duration_statement logic error
Next
From: Rod Taylor
Date:
Subject: Re: fix log_min_duration_statement logic error