Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 445A19FBBB9 for ; Thu, 3 May 2007 12:03:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 90182-03 for ; Thu, 3 May 2007 12:03:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr2.hagander.net (svr2.hagander.net [88.198.128.226]) by postgresql.org (Postfix) with ESMTP id 179AE9FBB69 for ; Thu, 3 May 2007 12:03:16 -0300 (ADT) Received: by svr2.hagander.net (Postfix, from userid 1000) id 24765DCC8FC; Thu, 3 May 2007 17:03:15 +0200 (CEST) Date: Thu, 3 May 2007 17:03:15 +0200 From: Magnus Hagander To: Greg Smith Cc: pgsql-performance@postgresql.org Subject: Re: pg_stat_* collection Message-ID: <20070503150315.GG17603@svr2.hagander.net> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/23 X-Sequence-Number: 24413 On Thu, May 03, 2007 at 10:45:48AM -0400, Greg Smith wrote: > Today's survey is: just what are *you* doing to collect up the > information about your system made available by the various pg_stat views? > I have this hacked together script that dumps them into a file, imports > them into another database, and then queries against some of the more > interesting data. You would thing there would be an organized project > addressing this need around to keep everyone from reinventing that wheel, > but I'm not aware of one. If you're interested in exposing them with snmp, join the pgsnmpd project :-) //Magnus