-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Thank you Bill for your tip. As far as the table's name is concerned the only one I can find is 'pg_statistic' (under pg_catalog). I'm using PGSQL 8.2.9 on x86_64. BR, Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam Bill Moran wrote: > In response to Pedro Doria Meunier <pdoria@xxxxxxxxxxxxxx>: > >> -----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. > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFKL8ND2FH5GXCfxAsRAu/XAJ43UGqlzv5gfzg1YgECbhvL2MaPzwCdEnt3 GfewITsorV/t7cfpq3WxVqM= =84cI -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
