Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3AE0F2E00D4 for ; Mon, 4 Feb 2008 18:28:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 20325-05 for ; Mon, 4 Feb 2008 18:28:32 -0400 (AST) Received: from polaris.pinpointresearch.com (66-7-238-130.static-ip.telepacific.net [66.7.238.130]) by postgresql.org (Postfix) with ESMTP id 067372E007A for ; Mon, 4 Feb 2008 18:28:37 -0400 (AST) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id BFB23E00EC83; Mon, 4 Feb 2008 14:28:34 -0800 (PST) Message-ID: <47A79192.9030808@pinpointresearch.com> Date: Mon, 04 Feb 2008 14:28:34 -0800 From: Steve Crawford User-Agent: Thunderbird 2.0.0.6 (X11/20071022) MIME-Version: 1.0 To: Kevin Kempter CC: pgsql-admin@postgresql.org Subject: Re: last analyze / vacuum References: <200802041500.27254.kevin@kevinkempterllc.com> In-Reply-To: <200802041500.27254.kevin@kevinkempterllc.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/22 X-Sequence-Number: 28096 Kevin Kempter wrote: > Hi List; > > Is there a system catalog, or other means where I can find out the last time a > table was analyzed and the last time a table was vacuumed? > Start with: select * from pg_stat_all_tables; Cheers, Steve