-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 03/12/07 12:16, Erik Jones wrote:
>
> 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.
Like a system montitor that tracks reads, writes, transactions, etc?
>
> erik jones <erik@myemma.com>
> sofware developer
> 615-296-0838
> emma(r)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFF9ZiyS9HxQb37XmcRAiNKAKCxG7RJUEQTpyU6N6bqlllOcvUJ6wCfZh+8
7s3LprWsR2IEB3n+FwyLy58=
=cPIV
-----END PGP SIGNATURE-----