Re: select query does not pick up the right index

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Abadie Lana <Lana(dot)Abadie(at)iter(dot)org>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: select query does not pick up the right index
Date: 2019-01-03 13:01:09
Message-ID: CAKJS1f_h27-bR8P2sW5iAmjY9fhXs_d5DcjQ=zX0AW8WghUcZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 4 Jan 2019 at 01:57, Abadie Lana <Lana(dot)Abadie(at)iter(dot)org> wrote:
> 4) name is unique, constraint and index created. Right index is picked up and query time is rather constant there 40sec.

That's surprisingly slow. Can you share the EXPLAIN (ANALYZE, BUFFERS) of that?

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Abadie Lana 2019-01-03 13:13:14 RE: select query does not pick up the right index
Previous Message Abadie Lana 2019-01-03 12:58:06 RE: select query does not pick up the right index