Much higher CPU load than usage on database

Hey Adam,

The CPU Usage shows how much of the CPU’s capacity is being used.

And the Load Average on the other side, shows the number of processes waiting to run or running.

Even if your CPU usage is only 60-80%, the load average can still be high if there are a lot of processes waiting in line. This usually happens when your system is doing lots of disk I/O (like reading/writing to the disk), waiting for resources, or running many queries at the same time.

Since your cluster has 2 vCPUs, a load average of 2 would mean the CPUs are fully utilized. But since your load average is 4-5, it means there are more processes waiting to be handled by the CPU. This is why it seems overloaded by load average but looks fine on CPU usage.

You might want to check disk I/O and see if there are any slow queries or heavy operations that could be causing this.

You might also want to check out these guides here:

https://www.digitalocean.com/community/tutorials/how-to-analyze-managed-postgresql-database-statistics-using-the-elastic-stack-on-ubuntu-18-04

https://docs.digitalocean.com/products/databases/postgresql/how-to/monitor-databases/

Hope this clears things up!

- Bobby