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