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

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

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: A tool to extract the problematic points of the postgresl log.
Date: 2005-10-11 14:14:05
Message-ID: dighal$2rj8$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-admin
http://pqa.projects.postgresql.org/

You need to have ruby installed, though.

On 11.10.2005 11:59, David Pradier wrote:
> 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 ?

-- 
Regards,
Hannes Dorbath

In response to

pgsql-admin by date

Next:From: faeizDate: 2005-10-11 14:17:55
Subject: PostgreSQL running in the background....
Previous:From: David PradierDate: 2005-10-11 14:05:10
Subject: Re: A tool to extract the problematic points of the postgresl log.

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