Slow query on a one-tuple table - Mailing list pgsql-performance

From Luís Roberto Weck
Subject Slow query on a one-tuple table
Date
Msg-id 774d6080-d6d7-e9e7-7351-9a412c7d5956@siscobra.com.br
Whole thread Raw
In response to Re: comparing output of internal pg tables of referenced tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Slow query on a one-tuple table  (Michael Lewis <mlewis@entrata.com>)
List pgsql-performance
Hi!

I have a query that SELECT's only one tuple using a PK (https://explain.depesz.com/s/Hskt)

the field I am selecting are a bigint and a text. Why does it read 1095 shared buffers read?

If I adda LIMIT 1 clause, the query runs much faster: https://explain.depesz.com/s/bSZn

This table has only one tuple anyway, so I can't understand why does it takes so long without the LIMIT 1.

pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Delete huge Table under XFS
Next
From: Joao Junior
Date:
Subject: Re: Delete huge Table under XFS