-----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@xxxxxxxxxxxxxx>: > > 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@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 iD8DBQFKL/fv2FH5GXCfxAsRAiFmAKCP5i4lH7g0F/aldAM3+jzRO5KfdACgsU73 2ui5R+4Gb8HPCt+4uO7SH8w= =GTGK -----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
