Re: Tracking disk writes? (again)

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Tracking disk writes? (again)
Дата
Msg-id 20070312183106.GA23724@svana.org
обсуждение исходный текст
Ответ на Tracking disk writes? (again)  (Erik Jones <erik@myemma.com>)
Ответы Re: Tracking disk writes? (again)  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Tracking disk writes? (again)  (Erik Jones <erik@myemma.com>)
Список 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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Tracking disk writes? (again)
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Tsearch2 / Create rule on select