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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
