Thread: Is this true?

Is this true?

From
"Chris Hoover"
Date:
Question,

Does (pg_stat_get_db_blocks_fetched(oid)-pg_stat_get_db_blocks_hit(oid)*8) = number of KB read from disk for the listed database since the last server startup?

Thanks,

Chris

Re: Is this true?

From
Jeff Davis
Date:
On Wed, 2007-06-06 at 16:58 -0400, Chris Hoover wrote:
> Question,
>
> Does (pg_stat_get_db_blocks_fetched(oid)-pg_stat_get_db_blocks_hit
> (oid)*8) = number of KB read from disk for the listed database since
> the last server startup?

That will give you the number of blocks requested from the OS. The OS
does it's own caching, and so many of those reads might come from the OS
buffer cache, and not the disk itself.

Also, if you're concerned with the number since the last server restart,
make sure you have stats_reset_on_server_start set appropriately.

Regards,
    Jeff Davis