Postgres Pro
Downloads
Home   >   mailing lists

Re: select query does not pick up the right index - Mailing list pgsql-performance

From David Rowley
Subject Re: select query does not pick up the right index
Date
Msg-id CAKJS1f_h27-bR8P2sW5iAmjY9fhXs_d5DcjQ=zX0AW8WghUcZw@mail.gmail.com
Whole thread Raw
In response to RE: select query does not pick up the right index  (Abadie Lana <Lana.Abadie@iter.org>)
Responses RE: select query does not pick up the right index  (Abadie Lana <Lana.Abadie@iter.org>)
List pgsql-performance
Tree view 
On Fri, 4 Jan 2019 at 01:57, Abadie Lana <Lana.Abadie@iter.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

pgsql-performance by date:

Previous
From: Abadie Lana
Date:
Subject: RE: select query does not pick up the right index
Next
From: Abadie Lana
Date:
Subject: RE: select query does not pick up the right index