Re: Persistent server stats collection - Mailing list pgsql-admin

From Kieren Scott
Subject Re: Persistent server stats collection
Date
Msg-id BAY149-w527FE5E6957EAE67A25CD2AE850@phx.gbl
Whole thread Raw
In response to Re: Persistent server stats collection  (Brad Nicholson <bnichols@ca.afilias.info>)
Responses Re: Persistent server stats collection
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Brad Nicholson
Date:
Subject: Re: Persistent server stats collection
Next
From: Tom Lane
Date:
Subject: Re: Unable to drop role