Re: Tracking disk writes? (again) - Mailing list pgsql-general

From Erik Jones
Subject Re: Tracking disk writes? (again)
Date
Msg-id B52D3C58-96B8-4427-BEB8-45190EF4B7F1@myemma.com
Whole thread Raw
In response to Re: Tracking disk writes? (again)  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
Responses Re: Tracking disk writes? (again)  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general

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

Erik,

for solaris I think dtrace can be of help:


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



pgsql-general by date:

Previous
From: "Harald Armin Massa"
Date:
Subject: Re: Tracking disk writes? (again)
Next
From: Ron Johnson
Date:
Subject: Re: Tracking disk writes? (again)