Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 71370632FFD for ; Thu, 26 Aug 2010 12:06:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 92736-04 for ; Thu, 26 Aug 2010 15:06:32 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from bay0-omc1-s24.bay0.hotmail.com (bay0-omc1-s24.bay0.hotmail.com [65.54.190.35]) by mail.postgresql.org (Postfix) with ESMTP id 52612632FB1 for ; Thu, 26 Aug 2010 12:06:32 -0300 (ADT) Received: from BAY149-W52 ([65.54.190.61]) by bay0-omc1-s24.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 26 Aug 2010 08:06:30 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_4ef27212-9d04-4ccf-91cd-8ad5784bc968_" X-Originating-IP: [91.206.0.43] From: Kieren Scott To: , Subject: Re: Persistent server stats collection Date: Thu, 26 Aug 2010 15:06:30 +0000 Importance: Normal In-Reply-To: <4C766B1D.5010805@ca.afilias.info> References: , <4C766B1D.5010805@ca.afilias.info> MIME-Version: 1.0 X-OriginalArrivalTime: 26 Aug 2010 15:06:30.0728 (UTC) FILETIME=[43BB3480:01CB4530] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/233 X-Sequence-Number: 35482 --_4ef27212-9d04-4ccf-91cd-8ad5784bc968_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks Brad. Just installed it on a test database and it's all up and runni= ng=2C looks good. Date: Thu=2C 26 Aug 2010 09:24:45 -0400 From: bnichols@ca.afilias.info To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Persistent server stats collection =20 =20 =20 =20 On 10-08-26 05:15 AM=2C Kieren Scott wrote: =20 =20 Hi=2C =20 I'm interested in finding a way of gathering and retaining system statistics in my=20 postgres instances=2C so I can see how certain things are changing over time. I know=20 postgres provides a range of pre-defined views for viewing current activity=2C but are=20 there any modules/scripts that are available to help capture (on a scheduled basis) and retain necessary server stats in tables? =20 Thanks in advance. =20 =20 http://pgfoundry.org/projects/pgstatspack/ =20 --=20 Brad Nicholson 416-673-4106 Database Administrator=2C Afilias Canada Corp. = --_4ef27212-9d04-4ccf-91cd-8ad5784bc968_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks Brad. Just installed it on a test database and it's all up and runni= ng=2C looks good.


Date: Thu=2C 26 Aug 2010 0= 9:24:45 -0400
From: bnichols@ca.afilias.info
To: pgsql-admin@postgres= ql.org
Subject: Re: [ADMIN] Persistent server stats collection

=20 =20 =20 =20 On 10-08-26 05:15 AM=2C Kieren Scott wrote:
Hi=2C

I'm interested in finding a way of gathering and retaining system statistics in my
postgres instances=2C so I can see how certain things are changing over time. I know
postgres provides a range of pre-defined views for viewing current activity=2C but are
there any modules/scripts that are available to help capture (on a scheduled basis)
and retain necessary server stats in tables?

Thanks in advance.

http://pgfoundry.org/projects/pgstatsp= ack/

-- 
Brad Nicholson 416-673-4106
= Database Administrator=2C Afilias Canada Corp.

= --_4ef27212-9d04-4ccf-91cd-8ad5784bc968_--