Just stumbled acress pg_statsinfo-2.0 which looks as though it provides stats capture and reporting too.
Anybody else using pg_statsinfo? If so what are your thoughts?
TIA
From: kierenscott@hotmail.com
To: bnichols@ca.afilias.info; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Persistent server stats collection
Date: Thu, 26 Aug 2010 15:06:30 +0000
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
Thanks Brad. Just installed it on a test database and it's all up and running, looks good.
Date: Thu, 26 Aug 2010 09:24:45 -0400
From: bnichols@ca.afilias.info
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Persistent server stats collection
On 10-08-26 05:15 AM, Kieren Scott wrote:
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
Hi,
I'm interested in finding a way of gathering and retaining system statistics in my
postgres instances, 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, 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/pgstatspack/
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.