Re: logs of postgresql and pid-stamping. possible improvement?

On Thu, Aug 15, 2002 at 11:48:40AM +0200, Hubert depesz Lubaczewski wrote:
> hi,
> is there any way, one could spent some time to allow *full* pid-stamping
> in logs?
> right now logs look like:
> [5703] LOG: query: select *
> from
> pg_class
> WHERE
> relname='pg_class';
> [5703] LOG: QUERY STATISTICS
> ! system usage stats:
> ! 0.028300 elapsed 0.000000 user 0.000000 system sec
> ! [0.020000 user 0.010000 sys total]
> ! 0/0 [0/0] filesystem blocks in/out
> ! 9/7 [305/148] page faults/reclaims, 0 [0] swaps
> ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
> ! 0/0 [0/0] voluntary/involuntary context switches
> ! postgres usage stats:
> ! Shared blocks: 3 read, 0 written, buffer hit rate = 96,55%
> ! Local blocks: 0 read, 0 written, buffer hit rate = 0,00%
> ! Direct blocks: 0 read, 0 written

Yes, but all that stuff with the ! at the beginning is associated
with the LOG: QUERY STATISTICS ahead of it, no? Isn't that enough of
a separator to make it clear? Or am I missing something (likely)?

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110