Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id AD6A06322D4 for ; Mon, 19 Jan 2009 14:27:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 85000-02 for ; Mon, 19 Jan 2009 14:27:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from polaris.pinpointresearch.com (66-7-238-130.static-ip.telepacific.net [66.7.238.130]) by mail.postgresql.org (Postfix) with ESMTP id EE7366324BF for ; Mon, 19 Jan 2009 14:27:31 -0400 (AST) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 268FBE00FC11; Mon, 19 Jan 2009 10:27:28 -0800 (PST) Message-ID: <4974C60F.5050908@pinpointresearch.com> Date: Mon, 19 Jan 2009 10:27:27 -0800 From: Steve Crawford User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: Kevin Kempter CC: pgsql-admin@postgresql.org Subject: Re: check to see when tables were last vacummed References: <200901191114.47926.kevink@consistentstate.com> In-Reply-To: <200901191114.47926.kevink@consistentstate.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/66 X-Sequence-Number: 31113 Kevin Kempter wrote: > Hi all; > > Anyone know where to look to see when tables were last vacuumed via autovacuum > ? > Also, can I run this check only in 8.3+ or did it work also in 8.2, 8.1 ? > > > Thanks in advance > > In 8.3 look in the "pg_stat_user_tables" system table for the last_vacuum and last_autovacuum columns. I don't know when those columns were added. I don't see them in 8.1 and don't have 8.2 available at the moment. Cheers, Steve