Re: Average connections

In response to Pedro Doria Meunier <pdoria@netmadeira.com>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all
>
> I've googled for an answer but couldn't find one.
> Is there anyway to monitor the average connections to a database?
>
> Thank you in advance for any insights.

The pg_stat_activity table holds 1 row for each connection with information
on what that connection is doing.

It wouldn't be very difficult to write a passthrough script for something
like MRTG to graph this data.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/