I would suspect it’s because of memory. I remember years ago my cheap 512m mem vps is easily bottlenecked by pg’s memory usage. CPU is idle when idled, memory eat by pg does not get released. Scaling memory is not cheap. Memory is the “scarce” for cloud hosting.