Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B9DD3632581 for ; Wed, 21 Jan 2009 15:35:02 -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 67837-01 for ; Wed, 21 Jan 2009 15:34:56 -0400 (AST) X-Greylist: delayed 00:18:54.108234 by SQLgrey-1.7.6 Received: from thebighonker.lerctr.org (thebighonker.lerctr.org [192.147.25.65]) by mail.postgresql.org (Postfix) with ESMTP id 6BCED63258D for ; Wed, 21 Jan 2009 15:34:52 -0400 (AST) Received: from 64.3.1.253.ptr.us.xo.net ([64.3.1.253]:44540 helo=LROSENMAN) by thebighonker.lerctr.org with esmtpa (Exim 4.69 (FreeBSD)) (envelope-from ) id 1LPiYM-000F7t-Mo; Wed, 21 Jan 2009 13:15:56 -0600 From: "Larry Rosenman" To: "'Steve Crawford'" , "'Kevin Kempter'" Cc: References: <200901191114.47926.kevink@consistentstate.com> <4974C60F.5050908@pinpointresearch.com> In-Reply-To: <4974C60F.5050908@pinpointresearch.com> Subject: Re: check to see when tables were last vacummed Date: Wed, 21 Jan 2009 13:15:44 -0600 Message-ID: <01de01c97bfc$ae866c70$0b934550$@org> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 thread-index: Acl6Y7HLFJlpxgg6TVmkT2qpLLW0cABmO+kA Content-Language: en-us X-LERCTR-Spam-Score: -2.4 (--) X-LERCTR-Spam-Report: SpamScore (-2.4/5.0) ALL_TRUSTED=-1.8, BAYES_00=-2.599, TVD_RCVD_IP=1.931, TW_PG=0.077 DomainKey-Status: no signature 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/104 X-Sequence-Number: 31151 They were added in 8.2 by me. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Steve Crawford Sent: Monday, January 19, 2009 12:27 PM To: Kevin Kempter Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] check to see when tables were last vacummed 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin