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: [email protected] To: [email protected]; [email protected] Subject: Re: [ADMIN] Persistent server stats collection Date: Thu, 26 Aug 2010 15:06:30 +0000 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: [email protected] To: [email protected] Subject: Re: [ADMIN] 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.
