From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | Jim Nasby <decibel(at)decibel(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Tracking disk writes? |
Date: | 2007-03-25 16:30:21 |
Message-ID: | 3EFF87EC-57D1-4D93-BD86-170FD66EFA24@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mar 24, 2007, at 1:06 PM, Jim Nasby wrote:
> On Mar 10, 2007, at 4:33 AM, Erik Jones wrote:
>> I've seen that I can get the total number of blocks read from disk
>> over the lifetime of a database via the pg_stat_database view, and
>> by taking successive readings I can track reads over time. How
>> can I track disk writes?
>
> Hey Erik...
>
> That's not currently tracked anywhere, but it would be good
> information to have. I suspect it could be added without a great
> deal of difficulty by looking at what's done for tracking blocks
> read, as well as another patch that added new statistics (I know
> there was one for vacuum stats back last summer).
>
> Also, someone on -hackers was recently looking into some stuff with
> the bgwriter and added some logging code; I don't remember if they
> also added some statistics.
Right on the usefulness part!! Although, Tom's thoughts wrt to the
bgwriter were that that would be the part that would make this non-
trivial.
erik jones <erik(at)myemma(dot)com>
software developer
615-296-0838
emma(r)
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick TJ McPhee | 2007-03-25 16:41:00 | Re: Check the existance of temporary table |
Previous Message | Yonatan Ben-Nes | 2007-03-25 16:23:17 | Tsearch2 can't be checked for equality? |