monitor postgresql

["McGraw, Robert P" <rmcgraw (at) purdue.edu>]

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