Re: Read/Write operation counts

On Wed, Jan 18, 2017 at 4:10 PM, John R Pierce <pierce(at)hogranch(dot)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.

See: https://www.postgresql.org/docs/9.6/static/monitoring-stats.html

--
David Rader
davidr(at)openscg(dot)com