On Wed, Jan 18, 2017 at 4:10 PM, John R Pierce <pie...@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. See: https://www.postgresql.org/docs/9.6/static/monitoring-stats.html -- David Rader dav...@openscg.com
