Re: understanding pg_stat* numbers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: understanding pg_stat* numbers
Дата
Msg-id 18156.1111871104@sss.pgh.pa.us
обсуждение исходный текст
Ответ на understanding pg_stat* numbers  (Oleg Bartunov <oleg@sai.msu.su>)
Ответы Re: understanding pg_stat* numbers
Список pgsql-hackers
Oleg Bartunov <oleg@sai.msu.su> writes:
> I'm looking for blocks *actually* read from disk, since IO is the most 
> important factor.

Well, you won't find that out from Postgres, since it has no idea
whether a read() request was satisfied from kernel disk cache or had
to actually go to disk.

You could turn on log_statement_stats to get some possibly-more-reliable
numbers from the kernel via getrusage(), but this will only tell you
about totals across the whole backend process, not per-relation ...
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: minor windows & cygwin regression failures on stable branch
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: understanding pg_stat* numbers