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