Re: Tracking disk writes? (again)

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.

But it does not include disk writes, only reads.

I think it would make sense to add blocks dirtied and blocks written to
the block-level stats.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support