Re: Average connections

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

First of all thank you very much to everyone that shared their views
on the task at hand!

I've actually accomplished it using MRTG :)

BR,

Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

Bill Moran wrote:
> In response to Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>:
>
> 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.
>
>
>> Can't imagine why you're not seeing it. It existed in 8.2, and I
>>
> don't
>> know of any config setting that would make it not show up.
>
> Bill Moran wrote:
>>>> In response to Pedro Doria Meunier <pdoria(at)netmadeira(dot)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

iD8DBQFKL/fv2FH5GXCfxAsRAiFmAKCP5i4lH7g0F/aldAM3+jzRO5KfdACgsU73
2ui5R+4Gb8HPCt+4uO7SH8w=
=GTGK
-----END PGP SIGNATURE-----