Re: fix log_min_duration_statement logic error
| От | Tom Lane |
|---|---|
| Тема | Re: fix log_min_duration_statement logic error |
| Дата | |
| Msg-id | 15038.1065389452@sss.pgh.pa.us обсуждение |
| Ответ на | Re: fix log_min_duration_statement logic error (Bruce Momjian <pgman@candle.pha.pa.us>) |
| Ответы |
Re: fix log_min_duration_statement logic error
|
| Список | 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 по дате отправления: