Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2BED22E3FE2 for ; Thu, 29 Nov 2007 17:52:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 55449-01-8 for ; Thu, 29 Nov 2007 17:51:56 -0400 (AST) Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id DEB7B2E400B for ; Thu, 29 Nov 2007 17:48:16 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1IxrEm-0004ME-Um for pgsql-admin@postgresql.org; Thu, 29 Nov 2007 16:48:01 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 6ED6C504FD; Thu, 29 Nov 2007 16:47:53 -0500 (EST) Date: Thu, 29 Nov 2007 16:47:53 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: clear statistics in pg_stat Message-ID: <20071129214753.GA8157@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/246 X-Sequence-Number: 27489 On Thu, Nov 29, 2007 at 03:32:59PM -0600, Campbell, Lance wrote: > How can I clear pg_stat views? I thought there was a command I could According to the manual, there's this: pg_stat_reset() I suggest you read the section of the manual about stats collection. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke