A tool to extract the problematic points of the postgresl log.

Поиск
Список
Период
Сортировка
От David Pradier
Тема A tool to extract the problematic points of the postgresl log.
Дата
Msg-id 20051011095929.GD12162@clarisys.fr
обсуждение исходный текст
Ответы Re: A tool to extract the problematic points of the postgresl log.  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: A tool to extract the problematic points of the postgresl log.  (Hannes Dorbath <light@theendofthetunnel.de>)
Список pgsql-admin
Hi everybody,

i'd like to know if my database (settings, indexes, materialized views,
etc) is correctly tuned.
To do this, i think the best way is to watch the queries actually
processed and the time needed.

The postgres log is the right way to do this, i think.

But well, it's a bit dense.
Nothing i can't go through, but would you know a better tool than grep
to parse the file and extract the problematic points ?

As it might be a common problem, maybe somebody as already written a
generic tool to do this ?

Thanks in advance,
David
--
David Pradier -- Directeur Technique de Clarisys Informatique -- Chef de projet logiciels libres / open-source

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

Предыдущее
От: Stef
Дата:
Сообщение: Re: Compression of text columns
Следующее
От: Pieter-Jan Savat
Дата:
Сообщение: Memory/Performance issue: server closed the connection unexpectedly