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

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: logs of postgresql and pid-stamping. possible improvement?
Дата
Msg-id 20020815132600.X5642@mail.libertyrms.com
обсуждение исходный текст
Ответ на logs of postgresql and pid-stamping. possible improvement?  (Hubert depesz Lubaczewski <depesz@depesz.pl>)
Ответы Re: logs of postgresql and pid-stamping. possible improvement?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


В списке pgsql-general по дате отправления:

Предыдущее
От: Markus Wagner
Дата:
Сообщение: Re: how to synchronize database operations?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: logs of postgresql and pid-stamping. possible improvement?