PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

While it may be somewhat inconvenient to need superuser access to invoke iotop, we're willing to make that sacrifice in this case. Our first command simply starts iotop as we would use top, interactively. We can sort the output into different columns with the arrow keys, reverse the sort order by pressing the R key, and quit by pressing Q. Of the columns presented here, we may be interested in the following:

• PID: This column provides the process ID (PID) of process that makes I/O requests. This can be used to investigate or terminate the program.
• DISK READ: This column illustrates the number of bytes read per second by the listed process.
• DISK WRITE: This column details the number of bytes written per second by the listed ...