Обсуждение: [GENERAL] Read/Write operation counts
Hi,
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.
Thanks,
Anirudh
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. -- john r pierce, recycling bits in santa cruz
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.