Re: pg_statio_all_indexes

[David Hoksza <david(dot)hoksza(at)seznam(dot)cz>]

Yes, you are right. I now tried to select from one table various amount of
records and when the amount exceeded some given number so the blks_hit begun
fall.

Thanks,
       David Hoksza

________________________________
30. července 2006, 20:24:33, napsal jste:

TL> 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?

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

TL>                         regards, tom lane