Tom Lane wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
> > http://developer.postgresql.org/pgdocs/postgres/monitoring-stats.html
> > says: "Note: blocks_fetched minus blocks_hit gives the number of
> > kernel read() calls issued for the table, index, or database; but the
> > actual number of physical reads is usually lower due to kernel-level
> > buffering." This seems to imply that anything that increases
> > blocks_hit should also increase blocks_fetched, but that doesn't seem
> > to match the actual behavior.
>
> > rhaas=# select heap_blks_read, heap_blks_hit from pg_statio_user_tables;
>
> It's talking about the underlying pg_stat_get_db_blocks_fetched()
> function, not heap_blks_read which is just a view field defined as
>
> pg_stat_get_blocks_fetched(C.oid) -
> pg_stat_get_blocks_hit(C.oid) AS heap_blks_read,
>
> Probably that sentence ought to spell out the full function name
> instead of abbreviating.
Done.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/monitoring.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/monitoring.sgml,v
retrieving revision 1.66
diff -c -c -r1.66 monitoring.sgml
*** doc/src/sgml/monitoring.sgml 28 Mar 2009 00:10:23 -0000 1.66
--- doc/src/sgml/monitoring.sgml 9 Apr 2009 22:31:00 -0000
***************
*** 924,931 ****
<note>
<para>
! <function>blocks_fetched</function> minus
! <function>blocks_hit</function> gives the number of kernel
<function>read()</> calls issued for the table, index, or
database; but the actual number of physical reads is usually
lower due to kernel-level buffering.
--- 924,931 ----
<note>
<para>
! <function>pg_stat_get_blocks_fetched</function> minus
! <function>pg_stat_get_blocks_hit</function> gives the number of kernel
<function>read()</> calls issued for the table, index, or
database; but the actual number of physical reads is usually
lower due to kernel-level buffering.