Re: Tracking disk writes? (again)

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(at)myemma(dot)com>
sofware developer
615-296-0838
emma(r)