On Wed, 2007-06-06 at 16:58 -0400, Chris Hoover wrote:
> 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.
In response to
pgsql-performance by date
|Next:||From: Dan Harris||Date: 2007-06-06 22:04:44|
|Subject: reclaiming disk space after major updates|
|Previous:||From: Scott Marlowe||Date: 2007-06-06 21:27:47|
|Subject: Re: VERY slow queries at random|