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

From: David Pradier <david(dot)pradier(at)clarisys(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: A tool to extract the problematic points of the postgresl log.
Date: 2005-10-11 09:59:29
Message-ID: 20051011095929.GD12162@clarisys.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Pieter-Jan Savat 2005-10-11 10:18:17 Memory/Performance issue: server closed the connection unexpectedly
Previous Message Will Lewis 2005-10-11 07:56:08 Fwd: Question: 2 GB file limit on linux