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.
sofware developer
615-296-0838
emma(r)
