PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Collect some sample sar data by following these steps:

1. Display the default sar output with the following command:

sar

2. Show the disk device status every 5 seconds with this command:

sar -d 5

3. View memory usage between 4:00 A.M. and 6:00 A.M. today with this command:

sar -r -s 04:00:00 -e 06:00:00

Examine the I/O statistics for any existing past dates by following these steps:

1. Find the appropriate sysstat log directory:

• Red Hat, Fedora, CentOS, and Scientific Linux users should use the /var/log/sa directory.
• Debian, Mint, and Ubuntu users should use the /var/log/sysstat directory.

2. List the contents of that directory and choose a file. Files are simply binary formats containing sar data for each retained date. Files ...