David Hoksza <david.hoksza@seznam.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