Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9CCE96324B5 for ; Mon, 19 Jan 2009 14:14:58 -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 70958-02 for ; Mon, 19 Jan 2009 14:14:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound-mail-343.bluehost.com (outbound-mail-343.bluehost.com [66.147.249.4]) by mail.postgresql.org (Postfix) with SMTP id 01BAA632481 for ; Mon, 19 Jan 2009 14:14:51 -0400 (AST) Received: (qmail 21426 invoked by uid 0); 19 Jan 2009 18:12:13 -0000 Received: from unknown (HELO box498.bluehost.com) (66.147.242.98) by outboundproxy7.bluehost.com.bluehost.com with SMTP; 19 Jan 2009 18:12:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=consistentstate.com; h=Received:From:Organization:To:Subject:Date:User-Agent:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id:X-Identified-User; b=a3gl/a6N4JzzgGDldLs520S1spDQP3eP8vydF9A0PYB6REORfoVwRBbzwdn3Jbz9nOLVaMpvIglHPVIjnlX4exs0w+8rGOnZrRNRgJkNp+QxIRnULoQAx3FPWZVIEozj; Received: from [67.106.45.254] (helo=issac.consistentstate.com) by box498.bluehost.com with esmtpa (Exim 4.69) (envelope-from ) id 1LOyeB-00008n-Uu for pgsql-admin@postgresql.org; Mon, 19 Jan 2009 11:14:52 -0700 From: Kevin Kempter Organization: Consistent State To: pgsql-admin@postgresql.org Subject: check to see when tables were last vacummed Date: Mon, 19 Jan 2009 11:14:47 -0700 User-Agent: KMail/1.10.3 (Linux/2.6.27.9-159.fc10.x86_64; KDE/4.1.3; x86_64; ; ) MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200901191114.47926.kevink@consistentstate.com> X-Identified-User: {3049:box498.bluehost.com:consist3:consistentstate.com} {sentby:smtp auth 67.106.45.254 authed with kevink+consistentstate.com} 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/65 X-Sequence-Number: 31112 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