Re: Tracking disk writes? (again)

[Erik Jones <erik@xxxxxxxxxx>]

On Mar 12, 2007, at 1:31 PM, Martijn van Oosterhout wrote:

On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote:

Hi, is there any way that I can track the number of actual disk  

writes done by a particular database or database cluster?  I already  

sent this question last Friday and, while even I usually frown upon  

reposts to lists and forums, I really need some kind of answer, even  

if it's "you can't" in which case a why would also be cool.

I'm not sure it's what you mean, but the pg_stats* tables include stuff

like blocks read from tables and indexes and the like... You do need to

enable it in the config though.

That is exactly what I mean except that there doesn't seem to be anything in there for tracking writes done by the database.  There's the number of reads from disk and reads from the cache, but nothing that I can see wrt writes to disk.

erik jones <erik@xxxxxxxxxx>

sofware developer

615-296-0838

emma(r)