Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 43FED9F9FC1 for ; Tue, 28 Aug 2007 00:44:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 70357-02 for ; Tue, 28 Aug 2007 00:44:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C60CB9F9F14 for ; Tue, 28 Aug 2007 00:44:32 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l7S3iU3g014944; Mon, 27 Aug 2007 23:44:30 -0400 (EDT) To: Kevin Kempter cc: postgresql-admin Subject: Re: how to tell what tables have been vacuumed ? In-reply-to: <200708272133.15927.kevin@kevinkempterllc.com> References: <200708272133.15927.kevin@kevinkempterllc.com> Comments: In-reply-to Kevin Kempter message dated "Mon, 27 Aug 2007 21:33:15 -0600" Date: Mon, 27 Aug 2007 23:44:29 -0400 Message-ID: <14943.1188272669@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/340 X-Sequence-Number: 26671 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