In response to Pedro Doria Meunier <pdo...@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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
