RE: Slow query on a one-tuple table

From: Igor Neyman <ineyman(at)perceptron(dot)com>
To: Luís Roberto Weck <luisroberto(at)siscobra(dot)com(dot)br>, Michael Lewis <mlewis(at)entrata(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: RE: Slow query on a one-tuple table
Date: 2019-09-19 20:11:11
Message-ID: BN6PR1701MB1890A207FBF02BBC5E3C9F01DA890@BN6PR1701MB1890.namprd17.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

With LIMIT 1, I get 3 shared buffers hit, pretty much always.

____________________________________________________________________________________

Check if assessoria_pkey index is bloated.

Regards,
Igor Neyman

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Luís Roberto Weck 2019-09-19 20:24:39 Re: Slow query on a one-tuple table
Previous Message Luís Roberto Weck 2019-09-19 19:59:01 Re: Slow query on a one-tuple table