McGraw, Robert P wrote:
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?
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
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