> If that's what it looks like your server is running just fine. Load
> of 1.31, 85+% idle, no wait time. Or is that top and vmstat output
> from when the server is running fine?
Don't forget that there are 8 CPUs, and the backend will only run on one
of them.
But I concur that this seems ok.
How many rows are returned? Is 0.6 seconds an unacceptable time for that?
If there is a lot of sorting going on and the pages are residing in the
buffer, I would expect high CPU load.
Normally, I am quite happy if my database is CPU bound. I start worrying
if I/O wait grows too high.
Yours,
Laurenz Albe