X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F2AA2D1B176 for ; Wed, 26 May 2004 10:29:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 63156-06 for ; Wed, 26 May 2004 10:29:09 -0300 (ADT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 79938D1B459 for ; Wed, 26 May 2004 10:29:05 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i4QBqv9U013566; Wed, 26 May 2004 07:52:57 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i4QDT9N13746; Wed, 26 May 2004 09:29:09 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id LP85GD3D; Wed, 26 May 2004 09:29:06 -0400 Subject: Re: where to find out when a table was last analyzed? From: Robert Treat To: Litao Wu Cc: pgsql-performance@postgresql.org In-Reply-To: <20040518211321.23032.qmail@web13121.mail.yahoo.com> References: <20040518211321.23032.qmail@web13121.mail.yahoo.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 26 May 2004 09:29:06 -0400 Message-Id: <1085578147.9127.1933.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/211 X-Sequence-Number: 7042 On Tue, 2004-05-18 at 17:13, Litao Wu wrote: > All, > > Does PG store when a table was last analyzed? > > Thanks, > no. you can do something like select attname,s.* from pg_statistic s, pg_attribute a, pg_class c where starelid = c.oid and attrelid = c.oid and staattnum = attnum and relname = 'mytable' to see the current statistics on the table, but its not timestamped. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL