Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 3BA66632B8D
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 26 Aug 2010 10:24:56 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 23825-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 26 Aug 2010 13:24:48 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from outbound.afilias.info (outbound.afilias.info [69.46.124.26])
	by mail.postgresql.org (Postfix) with ESMTP id ACEED632A48
	for <pgsql-admin@postgresql.org>; Thu, 26 Aug 2010 10:24:48 -0300 (ADT)
Received: from ms5.yyz2.afilias-ops.info ([10.50.129.111]
	helo=smtp.afilias.info)
	by outbound.afilias.info with esmtp (Exim 4.69)
	(envelope-from <bnichols@ca.afilias.info>) id 1OocRi-00051A-4E
	for pgsql-admin@postgresql.org; Thu, 26 Aug 2010 13:24:46 +0000
Received: from tor-gateway.afilias.info ([199.15.87.4] helo=[10.10.46.12])
	by smtp.afilias.info with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69)
	(envelope-from <bnichols@ca.afilias.info>) id 1OocRi-0006kK-3r
	for pgsql-admin@postgresql.org; Thu, 26 Aug 2010 13:24:46 +0000
Message-ID: <4C766B1D.5010805@ca.afilias.info>
Date: Thu, 26 Aug 2010 09:24:45 -0400
From: Brad Nicholson <bnichols@ca.afilias.info>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.7) Gecko/20100720 Lightning/1.0b2 Thunderbird/3.1.1
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Persistent server stats collection
References: <BAY149-w32FC3A294C463F1FA190B3AE850@phx.gbl>
In-Reply-To: <BAY149-w32FC3A294C463F1FA190B3AE850@phx.gbl>
Content-Type: multipart/alternative;
	boundary="------------040403010104080408090508"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-4.209 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201008/232
X-Sequence-Number: 35481

This is a multi-part message in MIME format.
--------------040403010104080408090508
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

  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.



--------------040403010104080408090508
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#ffffff">
    On 10-08-26 05:15 AM, Kieren Scott wrote:
    <blockquote cite="mid:BAY149-w32FC3A294C463F1FA190B3AE850@phx.gbl"
      type="cite">
      <style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
      Hi,<br>
      <br>
      I'm interested in finding a way of gathering and retaining system
      statistics in my <br>
      postgres instances, so I can see how certain things are changing
      over time. I know <br>
      postgres provides a range of pre-defined views for viewing current
      activity, but are <br>
      there any modules/scripts that are available to help capture (on a
      scheduled basis)<br>
      and retain necessary server stats in tables?<br>
      <br>
      Thanks in advance.<br>
    </blockquote>
    <br>
    <a class="moz-txt-link-freetext" href="http://pgfoundry.org/projects/pgstatspack/">http://pgfoundry.org/projects/pgstatspack/</a><br>
    <br>
    <pre class="moz-signature" cols="72">-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.

</pre>
  </body>
</html>

--------------040403010104080408090508--