Re: [GENERAL] Read/Write operation counts

Поиск
Список
Период
Сортировка
От Rader, David
Тема Re: [GENERAL] Read/Write operation counts
Дата
Msg-id CAABt7R60R9f7smDLSV4Wu2XL93kr0jd837ditR0Pj=SsvSNQ-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Read/Write operation counts  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general

On Wed, Jan 18, 2017 at 4:10 PM, John R Pierce <pierce@hogranch.com> wrote:
On 1/18/2017 1:02 PM, Anirudh Jayakumar wrote:
Is there a way to retrieve the total read/write operations initiated by a PG server. I'm looking for measuring the IOPS of a server over a period of time.

postgres itself doesn't actually know how many physical disk operations are taking place as it only deals with files.

if its unix/linux, you can use iostat or sar to track all the disk I/O over an interval of time.


Depending on your goal, you can use pg_stat_database to see blocks read and blocks read from buffer cache as well as block read time and block write time per database. 



--
David Rader

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: [GENERAL] Read/Write operation counts
Следующее
От: William Ivanski
Дата:
Сообщение: Re: [GENERAL] migrate Sql Server database to PostgreSql