monitor postgresql

[McGraw, Robert P]

A user has asked for the following:

It would be pretty awesome to have some hobbit plugins that ran
sql queries against the postgresql install.

Things like:
select count(*) from pg_stat_activity; -- < 700 is bad
select count(*), datname from pg_stat_activity group by datname;

or even:

select min(query_start), current_query from pg_stat_activity group by
current_query;

Is there some plugin that does this or could be modified a little to do
this?

Robert


--------------------------------------------------------------------
Robert P. McGraw, Jr.
Manager, Computer System                 EMAIL: rmcgraw at purdue.edu
Purdue University                         ROOM: MATH-807
Department of Mathematics                PHONE: (765) 494-6055
150 N. University Street                                               
West Lafayette, IN 47907-2067            

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3105 bytes
Desc: not available
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20080411/bce86bf8/attachment.bin>