From: | Kieren Scott <kierenscott(at)hotmail(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Persistent server stats collection |
Date: | 2010-08-27 10:18:41 |
Message-ID: | BAY149-w5134C106056B1066D623EFAE860@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Łukasz Brodziak | 2010-08-27 12:50:48 | Tuple changes from relfilenodes |
Previous Message | Tom Lane | 2010-08-26 22:01:15 | Re: The function of lock file named ".s.PGSQL.<port>.lock" on Linux? |