Re: Persistent server stats collection

Kieren Scott <kierenscott@xxxxxxxxxxx> · Fri, 27 Aug 2010 10:18:41 +0000

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@xxxxxxxxxxx
To: bnichols@xxxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx
Subject: Re:  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@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.