Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 90DCF9FB4FF for ; Mon, 2 Apr 2007 05:17:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 08365-10 for ; Mon, 2 Apr 2007 05:17:39 -0300 (ADT) X-Greylist: delayed 00:06:38.61708 by SQLgrey-1.7.4 Received: from mail-eye.com (mail-eye.com [213.132.196.200]) by postgresql.org (Postfix) with SMTP id 696D19FB609 for ; Mon, 2 Apr 2007 05:17:39 -0300 (ADT) Received: (qmail 11470 invoked by uid 0); 2 Apr 2007 08:23:37 -0000 Received: from unknown (HELO lishtovny) (d.lishtovny@chronopay.com@213.247.247.121) by 0 with SMTP; 2 Apr 2007 08:23:37 -0000 From: "Denis Lishtovny" To: Subject: How to determine which indexes are not using or using seldom in database Date: Mon, 2 Apr 2007 12:12:52 +0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0019_01C77520.3D8DE0A0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: Acd0/rXq/vTG25hyRAK8/T3QNd+wIg== Message-Id: <20070402081739.696D19FB609@postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.395 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001, MSGID_FROM_MTA_ID=1.393 X-Spam-Level: * X-Archive-Number: 200704/4 X-Sequence-Number: 23881 This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C77520.3D8DE0A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello All. I have a lot of tables and indexes in database. I must to determine which indexes are not using or using seldon in databese . I enabled all posible statistics in config but a can`t uderstand how to do this. Thanks. p.s for example i need this to reduce database size for increase backup and restore speed. ------=_NextPart_000_0019_01C77520.3D8DE0A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello All.

I have a lot of tables and indexes in database. I must to determine = which indexes are not using or using seldon in databese . I enabled all = posible statistics in config but a can`t uderstand how to do this.
Thanks.

p.s for example i need this to reduce database size for increase backup = and restore speed.

------=_NextPart_000_0019_01C77520.3D8DE0A0--