Gokulakannan Somasundaram wrote:
I was going to say that I'm really only interested in physical I/O. Logical
I/O which is satisfied by the kernel cache is only marginally interesting
and
buffer fetches from Postgres's shared buffer is entirely uninteresting
from
the point of view of trying to figure out what is slowing down a query.
Ok the Physical I/Os are already visible, if you enable log_statement_stats.
I think you missed the point. What log_statement_stats shows are not
physical I/Os, they're read() system calls. Unfortunately there's no
direct way to tell if a read() is satisfied from OS cache or not. Greg's
suggestion was about how to do that.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
