Re: pg_statio_all_indexes

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

David Hoksza <david(dot)hoksza(at)seznam(dot)cz> writes:
> Hi, I'm not sure about the value idx_blks_hit of pg_statio_all_indexes
> view. Is it total value of touched pages, or do I get total value when
> I add idx_blks_read to it?
> In other words - does idx_blks_hit cover also physical reads?

I believe blks_hit is the number of page requests that were found in
cache and hence did *not* require a read().  The other column is the
number of page requests that *did* require a read().

			regards, tom lane