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.