Re: Unused indexes - PostgreSQL 9.2

From: Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unused indexes - PostgreSQL 9.2
Date: 2016-05-10 21:54:55
Message-ID: CAE_gQfVvfrKiHZzpsa7sp0yYhWiJkOJo2Oh0r_zV3d=fxDLoJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11 May 2016 at 09:50, Melvin Davidson <melvin6925(at)gmail(dot)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")

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2016-05-11 01:15:23 Re: Increased I/O / Writes
Previous Message Melvin Davidson 2016-05-10 21:50:18 Re: Unused indexes - PostgreSQL 9.2