monitor postgresql 🔗 link

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

McGraw, Robert P wrote:

Would you not be able to write a script to do this? All you would really 
need are the postgres clients on the hobbit server (or you could even 
run in as an ext script on the client)

Even better, if you output it into NCV (Name colon value) format you 
could graph it

Cheers

Iain