pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kieren Scott <kierenscott@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Persistent server stats collection
Date: Thu, 26 Aug 2010 09:15:39 +0000
Message-ID: <BAY149-w32FC3A294C463F1FA190B3AE850@phx.gbl> (raw)


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.
 		 	   		  =

view thread (4+ messages)  latest in thread

Message-ID: <BAY149-w32FC3A294C463F1FA190B3AE850@phx.gbl>
Permalink:  ../BAY149-w32FC3A294C463F1FA190B3AE850@phx.gbl/
Also on:    postgresql.org/message-id/BAY149-w32FC3A294C463F1FA190B3AE850@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: kierenscott@hotmail.com
  Subject: Re: Persistent server stats collection
  In-Reply-To: <BAY149-w32FC3A294C463F1FA190B3AE850@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox