From: Alexander Staubo <alex@purefiction.net>
To: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_stat_* collection
Date: Thu, 3 May 2007 16:52:55 +0200
Message-ID: <88daf38c0705030752sa4e38c3h78bcb64a651e6b1a@mail.gmail.com> (raw)
In-Reply-To: <Pine.GSO.4.64.0705031039390.12098@westnet.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alex@purefiction.net, gsmith@gregsmith.com
Subject: Re: pg_stat_* collection
In-Reply-To: <88daf38c0705030752sa4e38c3h78bcb64a651e6b1a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox