Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id AC0359FB28A; Tue, 8 May 2007 14:56:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 86285-03; Tue, 8 May 2007 14:56:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from serv01.siteground137.com (ns1.siteground137.com [67.15.250.10]) by postgresql.org (Postfix) with ESMTP id 74B1F9FA4D8; Tue, 8 May 2007 14:56:48 -0300 (ADT) Received: from nat.vinton.com ([209.162.219.253]:60400 helo=dogma.v10.wvs) by serv01.siteground137.com with esmtpa (Exim 4.52) id 1HlTvW-0004I9-9R; Tue, 08 May 2007 12:56:42 -0500 Subject: Re: [GENERAL] Time of previous REINDEX execution.. From: Jeff Davis To: Anoo Pillai Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org In-Reply-To: <75ff88c60705080521y7d64fb45w8d057222e467ed06@mail.gmail.com> References: <75ff88c60705080521y7d64fb45w8d057222e467ed06@mail.gmail.com> Content-Type: text/plain Date: Tue, 08 May 2007 10:56:44 -0700 Message-Id: <1178647004.24902.32.camel@dogma.v10.wvs> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-7) Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - serv01.siteground137.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - j-davis.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/58 X-Sequence-Number: 25378 On Tue, 2007-05-08 at 13:21 +0100, Anoo Pillai wrote: > Hi, > > How to get the time at which the previous REINDEX command was run? > I don't think that information is explicitly stored. You can log statements like that and that might help in the future. If you really need to know, a REINDEX changes the relfilenode, so you can see the creation time of the file in the data directory corresponding to the current indexes of the table. That will probably be the last time REINDEX was run. Does that help? Regards, Jeff Davis