monitor postgresql

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