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@xxxxxxxxxxxxxxx To: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Persistent server stats collection
On 10-08-26 05:15 AM, Kieren Scott wrote:
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.
|