Re: Tracking disk writes? (again)

[Erik Jones <erik@xxxxxxxxxx>]

On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote:

Erik,

for solaris I think dtrace can be of help:

http://www.opensolaris.org/os/community/dtrace/

PostgreSQL 8.2 introduced dtrace-ability.

From what I read it is specifically created to do this kind of measurement.

Hmm... That would be a particulary heavy weight solution to what I was hoping for.  Basically, I'm looking to poll the db or "something" to get either the total number of block or page writes done by the db either ever or since my last reading.  That way I can graph disk writes over time and compare to the graphs I've already got for transactions committed, transactios rolled back, disk blocks read from disk, and disk blocks found in cache.

erik jones <erik@xxxxxxxxxx>

sofware developer

615-296-0838

emma(r)