Re: [GENERAL] Average connections

2009-06-10 Thread Pedro Doria Meunier
-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 Pedr

Re: [GENERAL] Average connections

2009-06-10 Thread Bill Moran
In response to Pedro Doria Meunier : > -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. Can't imagine why you're not seein

Re: [GENERAL] Average connections

2009-06-10 Thread Brad Nicholson
On Wed, 2009-06-10 at 15:29 +0100, Pedro Doria Meunier wrote: > -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, h

Re: [GENERAL] Average connections

2009-06-10 Thread Pedro Doria Meunier
-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:

Re: [GENERAL] Average connections

2009-06-10 Thread Bill Moran
In response to Pedro Doria Meunier : > -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 hold

[GENERAL] Average connections

2009-06-10 Thread Pedro Doria Meunier
-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. BR, - -- Pedro Doria Meunier GSM: +351 96 17 20 188 Skype: pdoriam -BEGIN PGP SI