PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

We hope it's obvious by now that the number of combinations available for the dstat output is effectively infinite. By default, the dstat output resembles this:

The default output from dstat enables CPU, disk, network, memory paging, and system modules. In this particular example, we can see that the wai column is extremely high, suggesting that the server is currently I/O bound.

Another interesting thing about dstat is that it really only displays the exact modules we request. For the second example, the output becomes this:

In this second example, we've only enabled the network (-n) and system load (-l) modules, thus extremely ...