Re: Unused indexes - PostgreSQL 9.2

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>
Cc: Melvin Davidson <melvin6925(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unused indexes - PostgreSQL 9.2
Date: 2016-05-24 00:18:09
Message-ID: CAMkU=1yMLepnUiEqWJ7x1bLpkaoZk+N5tt+ZsV17SBNjDwqCpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 23, 2016 at 4:23 PM, Lucas Possamai <drum(dot)lucas(at)gmail(dot)com> wrote:
>
> That index has been added just 3 hours ago, and you can see that the
> times_used goes over 41000.... How is that possible??

Well, that is what it is there for, right , to be used? My ancient
laptop can use an index that many times in less than 20 seconds,
running flat out.

>
> Don't think the query is right.
>
> Can you please check ?

The query seems right to me.

Cheers,

Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lucas Possamai 2016-05-24 00:33:07 Re: Unused indexes - PostgreSQL 9.2
Previous Message dandl 2016-05-24 00:18:05 Re: Fatal error "stack empty" on ROLLBACK