Re: [hobbit] monitor postgresql

[Iain M Conochie <iain (at) shihad.org>]

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            
>
>