Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group