Re: [PERFORM] pg_stat_* collection

2007-05-04 Thread Michael Stone
On Fri, May 04, 2007 at 12:53:55AM -0400, Greg Smith wrote: It's also completely inappropriate for any environment I work in, because there really is no thought of security whatsoever in the whole thing. That makes it sound more like snmp, not less. :-) Mike Stone ---

Re: [PERFORM] pg_stat_* collection

2007-05-03 Thread Tobias Brox
[Greg Smith - Fri at 12:53:55AM -0400] > Munin is a very interesting solution to this class of problem. They've > managed to streamline the whole data collection process by layering clever > Perl hacks three deep. It's like the anti-SNMP--just build the simplest > possible interface that will

Re: [PERFORM] pg_stat_* collection

2007-05-03 Thread Greg Smith
On Thu, 3 May 2007, Alexander Staubo wrote: I have a bunch of plugin scripts for Munin that collect PostgreSQL statistics. I have been considering tarring them up as a proper release at some point. Excellent plan. Pop out a tar file, trade good ideas with Tobias, have some other people play

Re: [PERFORM] pg_stat_* collection

2007-05-03 Thread Jeff Davis
On Thu, 2007-05-03 at 10:45 -0400, Greg Smith 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 databa

Re: [PERFORM] pg_stat_* collection

2007-05-03 Thread Tobias Brox
[Alexander Staubo - Thu at 04:52:55PM +0200] > I have been considering tarring them up as a proper release at some > point. Anyone interested? Yes. Eventually I have my own collection as well: db_activity - counts the number of (all, slow, very slow, stuck "idle in transaction") queries in prog

Re: [PERFORM] pg_stat_* collection

2007-05-03 Thread Magnus Hagander
On Thu, May 03, 2007 at 10:45:48AM -0400, Greg Smith 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

Re: [PERFORM] pg_stat_* collection

2007-05-03 Thread Alexander Staubo
On 5/3/07, Greg Smith <[EMAIL PROTECTED]> 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

[PERFORM] pg_stat_* collection

2007-05-03 Thread Greg Smith
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 da