Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BD4BC9F9259 for ; Tue, 28 Aug 2007 00:54:50 -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 34808-03 for ; Tue, 28 Aug 2007 00:54:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outbound-mail-10.bluehost.com (outbound-mail-10.bluehost.com [69.89.17.210]) by postgresql.org (Postfix) with SMTP id 229FC9F9278 for ; Tue, 28 Aug 2007 00:54:42 -0300 (ADT) Received: (qmail 18278 invoked by uid 0); 28 Aug 2007 03:54:40 -0000 Received: from unknown (HELO box54.bluehost.com) (69.89.20.54) by mailproxy1.bluehost.com with SMTP; 28 Aug 2007 03:54:40 -0000 Received: from vdsl-151-118-147-91.dnvr.qwest.net ([151.118.147.91] helo=new-host.home) by box54.bluehost.com with esmtp (Exim 4.66) (envelope-from ) id 1IPsA2-0002rp-N4 for pgsql-admin@postgresql.org; Mon, 27 Aug 2007 21:54:38 -0600 From: Kevin Kempter To: pgsql-admin@postgresql.org Subject: Re: how to tell what tables have been vacuumed ? Date: Mon, 27 Aug 2007 21:52:56 -0600 User-Agent: KMail/1.9.7 References: <200708272133.15927.kevin@kevinkempterllc.com> <14943.1188272669@sss.pgh.pa.us> In-Reply-To: <14943.1188272669@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200708272152.56684.kevin@kevinkempterllc.com> X-Identified-User: {840:box54.bluehost.com:kevinkem:kevinkempterllc.com} {sentby:bopbeforesmtp 151.118.147.91 authed with ossfusion.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.436 tagged_above=0 required=5 tests=AWL=-0.695, BAYES_50=0.001, DNS_FROM_OPENWHOIS=1.13 X-Spam-Level: X-Archive-Number: 200708/341 X-Sequence-Number: 26672 On Monday 27 August 2007 21:44:29 Tom Lane wrote: > Kevin Kempter writes: > > How do I check to see which tables have been vacuumed recently and when > > they were last vacuumed? > > As of 8.2, there are columns about this in the pg_stat views, assuming > you have the right stats collection options turned on. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq Anything in the system catalogs in 8.1.4 ? (we're moving to 8.2.4 soon) Thanks /Kevin