DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
	b=FN4fkcFNHNd2k7JfW/5bNQ1i7wWeCjAxjwuyu86Ykaj2UTfEG2vUwLn2OIYSoBdpktYHxzBXG4UAogbnSsEZHcsh61b0G5WKA28cpVNeU/Ft6ar51ECSNPIy6ikeGLUhKoWlkGzljIbaSOGlOg7VaSH+BgrfNqewGyrbM3Uhb/Q=
Message-ID: <88daf38c0705030752sa4e38c3h78bcb64a651e6b1a@mail.gmail.com>
Date: Thu, 3 May 2007 16:52:55 +0200
From: "Alexander Staubo" <alex@purefiction.net>
To: "Greg Smith" <gsmith@gregsmith.com>
Subject: Re: pg_stat_* collection
Cc: pgsql-performance@postgresql.org
In-Reply-To: <Pine.GSO.4.64.0705031039390.12098@westnet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <Pine.GSO.4.64.0705031039390.12098@westnet.com>

On 5/3/07, Greg Smith <gsmith@gregsmith.com> wrote:
> Today's survey is:  just what are *you* doing to collect up the
> information about your system made available by the various pg_stat views?
> I have this hacked together script that dumps them into a file, imports
> them into another database, and then queries against some of the more
> interesting data.  You would thing there would be an organized project
> addressing this need around to keep everyone from reinventing that wheel,
> but I'm not aware of one.

I have a bunch of plugin scripts for Munin
(http://munin.projects.linpro.no/) that collect PostgreSQL statistics.
Graphs like this are useful:

  http://purefiction.net/paste/pg_munin_example.png

I have been considering tarring them up as a proper release at some
point. Anyone interested?

Alexander.