pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Is this true?
2+ messages / 2 participants
[nested] [flat]

* Is this true?
@ 2007-06-06 20:58  Chris Hoover <revoohc@gmail.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 21:37  Jeff Davis <pgsql@j-davis.com>
  parent: Chris Hoover <revoohc@gmail.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