[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [hobbit] monitor postgresql

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

Is there some plugin that does this or could be modified a little to do

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




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