Re: [GENERAL] Average connections
In response to Pedro Doria Meunier pdo...@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. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Average connections
-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 pdo...@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- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Average connections
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, http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE pg_stat_database also has the number of active server processes connected to a database. Bill Moran wrote: In response to Pedro Doria Meunier pdo...@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- -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Average connections
In response to Pedro Doria Meunier pdo...@netmadeira.com: -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 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 pdo...@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- -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 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 pdo...@netmadeira.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 pdo...@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 iD8DBQFKL/fv2FH5GXCfxAsRAiFmAKCP5i4lH7g0F/aldAM3+jzRO5KfdACgsU73 2ui5R+4Gb8HPCt+4uO7SH8w= =GTGK -END PGP SIGNATURE- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general