Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 5B3A01FA959 for ; Wed, 9 Nov 2011 11:41:58 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 20883-07 for ; Wed, 9 Nov 2011 15:41:51 +0000 (UTC) X-Greylist: delayed 00:19:29.709272 by SQLgrey-1.8.0-rc2 Received: from mail2.sdb.it (mail2.sdb.it [85.37.147.67]) by mail.postgresql.org (Postfix) with ESMTP id E829A1FA958 for ; Wed, 9 Nov 2011 11:41:50 -0400 (AST) Received: by mail2.sdb.it (Postfix, from userid 500) id AFC598070; Wed, 9 Nov 2011 16:22:20 +0100 (CET) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail2.sdb.it (Postfix) with ESMTP id AA442806D for ; Wed, 9 Nov 2011 16:22:20 +0100 (CET) Received: from mailtech.sdb.it (localhost [127.0.0.1]) by geronimo.sdb.it (Postfix) with ESMTP id 1667C380820 for ; Wed, 9 Nov 2011 16:22:10 +0100 (CET) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id 848C060061 for ; Wed, 9 Nov 2011 16:17:22 +0100 (CET) Message-ID: <4EBA9AAC.9030900@tech.sdb.it> Date: Wed, 09 Nov 2011 16:22:20 +0100 From: Silvio Brandani User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.9.2.23) Gecko/20110920 Thunderbird/3.1.15 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: database not using indexes Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Private-Material: Please read notice X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.401 tagged_above=-10 required=5 tests=BAYES_50=0.8, RP_MATCHES_RCVD=-1.201 X-Spam-Level: X-Archive-Number: 201111/29 X-Sequence-Number: 38623 Our database seems not using index anymore, please help with, is a production database. is there a script to check missing index on foreign key ?? thanks a lot --- Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalitą amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/privacy.html Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html L'Azienda non si assume alcuna responsabilitą giuridica qualora pervengano da questo indirizzo messaggi estranei all'attivitą lavorativa o contrari a norme. --