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: user-33cf07af04dd@xymon.invalid
Purdue University ROOM: MATH-807
Department of Mathematics PHONE: (XXX) XXX-XXXX
XXX N. University Street
West Lafayette, IN XXXXX-XXXX