Home > mailing lists

Re: Unused indexes - PostgreSQL 9.2 - Mailing list pgsql-general

From	Lucas Possamai
Subject	Re: Unused indexes - PostgreSQL 9.2
Date	May 11, 2016 00:55:39
Msg-id	CAE_gQfVvfrKiHZzpsa7sp0yYhWiJkOJo2Oh0r_zV3d=fxDLoJQ@mail.gmail.com Whole thread Raw
In response to	Re: Unused indexes - PostgreSQL 9.2 (Melvin Davidson <melvin6925@gmail.com>)
List	pgsql-general

On 11 May 2016 at 09:50, Melvin Davidson <melvin6925@gmail.com> wrote:

My bad, WHERE indexrelname = ' {YOUR INDEX NAME } ';

Oh! ok...

public ja_feedlog ix_ja_feedlog_visitids 1 94 GB 1939 MB 0 CREATE INDEX "ix_ja_feedlog_visitids" ON "ja_feedlog" USING "btree" ("visitid")

Two rows for the same index.

From: Melvin Davidson
Date: 11 May 2016, 00:51:02
Subject: Re: Unused indexes - PostgreSQL 9.2

From: Sergey Konoplev
Date: 11 May 2016, 04:15:49
Subject: Re: Increased I/O / Writes