Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id D429114BD8AE
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  9 Nov 2011 11:58:07 -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 33916-02-5
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  9 Nov 2011 15:58:01 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from smtp22.mail.ru (smtp22.mail.ru [94.100.176.175])
	by mail.postgresql.org (Postfix) with ESMTP id 2DBE414BD8A2
	for <pgsql-admin@postgresql.org>; Wed,  9 Nov 2011 11:58:01 -0400 (AST)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=mail.ru;
	s=mail;
	h=Content-Transfer-Encoding:Content-Type:Mime-Version:References:In-Reply-To:Message-ID:Subject:Cc:To:From:Date;
	bh=du8wERGqoV9WjWeqlc2ZI26FTW/iIhJAAMUNH4mH4WE=;
	b=ururXA/IY5LdglkbibOJ8BvgxmO+aduyR4alx6urUC5WZC0FFSG6onP8T51uQCWF1p/QSrqOPQMBtMg4tH9/ovU5e+te+hlumPySRlsp2/VCFBgy1v6GTHJnd9suYYnE;
Received: from [95.174.102.250] (port=8212 helo=localhost)
	by smtp22.mail.ru with asmtp
	id 1ROAXI-00047i-00; Wed, 09 Nov 2011 19:58:00 +0400
Date: Wed, 9 Nov 2011 19:58:38 +0400
From: "Ruslan A. Bondar" <fsat@list.ru>
To: Silvio Brandani <silvio.brandani@tech.sdb.it>
Cc: pgsql-admin@postgresql.org
Subject: Re: database not using indexes
Message-ID: <20111109195838.237a4470@list.ru>
In-Reply-To: <4EBA9AAC.9030900@tech.sdb.it>
References: <4EBA9AAC.9030900@tech.sdb.it>
X-Mailer: Claws Mail 3.7.10 (GTK+ 2.24.6; i686-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Spam: Not detected
X-Mras: Ok
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8
X-Spam-Level: 
X-Archive-Number: 201111/33
X-Sequence-Number: 38627


Why have you decided it isn't using indexes?
If index exists - postgres will use it.
To write a script for this I need at least database version.

On Wed, 09 Nov 2011 16:22:20 +0100
Silvio Brandani <silvio.brandani@tech.sdb.it> wrote:

> Our database seems not using index anymore, please help with, is a=20
> production database.
>=20
> is there a script to check missing index on foreign key ??
>=20
> thanks a lot
>=20
> ---
>=20
>=20
>=20
>=20
>=20
>=20
> Utilizziamo i dati personali che la riguardano esclusivamente per
> nostre finalit=E0 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=E0 giuridica qualora pervengano da
> questo indirizzo messaggi estranei all'attivit=E0 lavorativa o contrari
> a norme. --
>=20