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.comhttp://people.collaborativefusion.com/~wmoran/
