Re: Persistent server stats collection

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(at)hotmail(dot)com
To: bnichols(at)ca(dot)afilias(dot)info; pgsql-admin(at)postgresql(dot)org
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: bnichols(at)ca(dot)afilias(dot)info
To: pgsql-admin(at)postgresql(dot)org
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.