pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedIs this true?
2+ messages / 2 participants
[nested] [flat]
* Is this true?
@ 2007-06-06 20:58 Chris Hoover <revoohc@gmail.com>
2007-06-06 21:37 ` Re: Is this true? Jeff Davis <pgsql@j-davis.com>
0 siblings, 1 reply; 2+ messages in thread
From: Chris Hoover @ 2007-06-06 20:58 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Is this true?
2007-06-06 20:58 Is this true? Chris Hoover <revoohc@gmail.com>
@ 2007-06-06 21:37 ` Jeff Davis <pgsql@j-davis.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jeff Davis @ 2007-06-06 21:37 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-06-06 21:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-06 20:58 Is this true? Chris Hoover <revoohc@gmail.com>
2007-06-06 21:37 ` Jeff Davis <pgsql@j-davis.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox