Re: fix log_min_duration_statement logic error

Peter Eisentraut wrote:
> Tom Lane writes:
>
> > I would prefer to see the log entries look like
> >
> > LOG: query: select * from pg_class;
> > LOG: duration: nn.nnn msec
>
> I'm not fond of the abbrevation "msec" or even "msecs". The official
> abbreviation is "ms".

Yep. Someone suggested "msec" in their example, so I used that, but I
like "ms" better too:

LOG: duration: 0.950 ms; select 1;
LOG: duration: 0.269 ms; set log_min_duration_statement = 1;

Patch attached.

> 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?

Not sure. I think the microsecond stuff is accurate to some degree, but
not sure how much. I think the tick is 10ms, but I thought the timing
was much more accurate than that.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073