Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id D4E3E2E0035 for ; Tue, 8 Apr 2008 04:48:33 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 77286-02 for ; Tue, 8 Apr 2008 04:48:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com [69.36.227.170]) by developer.postgresql.org (Postfix) with ESMTP id DE2072E003A for ; Tue, 8 Apr 2008 04:48:18 -0300 (ADT) Received: from [32.172.234.212] (port=1060 helo=[10.184.48.21]) by glacier.frostconsultingllc.com with esmtpsa (TLSv1:RC4-MD5:128) (Exim 4.69) (envelope-from ) id 1Jj8Yr-00021M-Io; Tue, 08 Apr 2008 00:48:10 -0700 From: "Jeff Frost" To: "Michael Monnerie" CC: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Message-ID: <200804080047580000@3254630908> Subject: Re: Tuning Date: Tue, 8 Apr 2008 00:47:57 -0700 Content-Transfer-Encoding: 8bit X-SA-Exim-Connect-IP: 32.172.234.212 X-SA-Exim-Mail-From: jeff@glacier.frostconsultingllc.com X-SA-Exim-Scanned: No (on glacier.frostconsultingllc.com); SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/65 X-Sequence-Number: 28829 > Are there scripts to automate this look at stats? > Or could one draw graphs from that values, to visualize how well the db > is? E.g., if you could calculate a % value, you could make RRD stats to > see it's change over time. Is there any project on this? I don't know about rrd graphing it, but there are some great nagios plugins for this at http://bucardo.org/nagios You could have a look at the queries used in those and roll your own mrtg plugins. If you do, please share.