Re: Consulta de indices

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Mario Alberto Soto Cordones <mario_soto(at)venezolanadeavaluos(dot)com>
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Consulta de indices
Date: 2004-05-23 21:08:53
Message-ID: 20040523210853.GC27973@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

On Sun, May 23, 2004 at 03:53:45PM -0400, Mario Alberto Soto Cordones wrote:
> Hola lista, existe alguna forma de saber cual indice o cueles indices
> nunca se han ocupado, para poder asi eliminarlos.

Mira la vista pg_stat_user_indexes.

Ojo con los indices unicos (UNIQUE), esos no puedes eliminarlos aunque
no se usen nunca.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The only difference is that Saddam would kill you on private, where the
Americans will kill you in public" (Mohammad Saleh, 39, a building contractor)

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Mario Alberto Soto Cordones 2004-05-23 21:31:09 Re: Consulta de indices
Previous Message Mario Alberto Soto Cordones 2004-05-23 19:53:45 Consulta de indices