Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5938D9FB69B for ; Thu, 3 May 2007 15:21:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77310-01 for ; Thu, 3 May 2007 15:21:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from serv01.siteground137.com (ns1.siteground137.com [67.15.250.10]) by postgresql.org (Postfix) with ESMTP id 140899FBA1D for ; Thu, 3 May 2007 15:21:35 -0300 (ADT) Received: from nat.vinton.com ([209.162.219.253]:56349 helo=dogma.v10.wvs) by serv01.siteground137.com with esmtpa (Exim 4.52) id 1Hjfvl-00087s-1S; Thu, 03 May 2007 13:21:29 -0500 Subject: Re: pg_stat_* collection From: Jeff Davis To: Greg Smith Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Thu, 03 May 2007 11:21:30 -0700 Message-Id: <1178216490.28383.277.camel@dogma.v10.wvs> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - serv01.siteground137.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - j-davis.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/25 X-Sequence-Number: 24415 On Thu, 2007-05-03 at 10:45 -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. > Is anyone out there collecting their own statistics? What's the easiest way to take statistical samples of the data in a table without reading the entire thing? Regards, Jeff Davis