Re: pg_stat_* collection - Mailing list pgsql-performance

From Alexander Staubo
Subject Re: pg_stat_* collection
Date
Msg-id 88daf38c0705030752sa4e38c3h78bcb64a651e6b1a@mail.gmail.com
Whole thread Raw
In response to pg_stat_* collection  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: pg_stat_* collection  (Tobias Brox <tobias@nordicbet.com>)
Re: pg_stat_* collection  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: pg_stat_* collection
Next
From: Fei Liu
Date:
Subject: Re: Query performance problems with partitioned tables