Re: fix log_min_duration_statement logic error

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: fix log_min_duration_statement logic error
Дата
Msg-id
997.1065370668@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: fix log_min_duration_statement logic error Bruce Momjian <pgman@candle.pha.pa.us>
Peter Eisentraut  writes:
> Btw., I was wondering, are we kidding ourselves when we display
> microsecond precision to the user?  What accuracy do these measurements
> have in respect to what they are actually supposed to measure?

  The operating system API we are using is spec'd at microsecond
precision.  It's likely on any given hardware that some of the low order
digits might be bogus, but it is not our business to guess how many.
If we throw away low-order digits we may be losing useful information.
(This becomes more and more likely as machines get faster.)

We have EXPLAIN ANALYZE output showing two fractional digits of msec,
so it is discarding one potentially significant digit.  I did that for
consistency with the historical behavior of showing two fractional
digits of cost estimates, but could probably be talked into the idea
that three digits should be shown instead.

BTW, EXPLAIN ANALYZE puts out

 Total runtime: 406.53 msec

Do you want to make an exception to the string freeze to change this
to "ms"?

			regards, tom lane
В списке pgsql-patches по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ