Обсуждение: Persistent server stats collection

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.

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.

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.

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@hotmail.com
To: bnichols@ca.afilias.info; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Persistent server stats collection
Date: Thu, 26 Aug 2010 15:06:30 +0000

.ExternalClass .ecxhmmessage P {padding:0px;} .ExternalClass body.ecxhmmessage {font-size:10pt;font-family:Tahoma;} 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.