| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Erik Jones <erik(at)myemma(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tracking disk writes? (again) |
| Date: | 2007-03-12 18:31:06 |
| Message-ID: | 20070312183106.GA23724@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2007-03-12 19:01:25 | Re: Tsearch2 / Create rule on select |
| Previous Message | Ron Johnson | 2007-03-12 18:15:14 | Re: Tracking disk writes? (again) |