It's Almost Always the Queries, Part III: When the CPU Is Pegged

TL;DR
A relational database pinned at 100% CPU is almost never running one expensive query. It’s running a cheap one too many times. The slow-query log and mean-time sorting both look right past it; total_exec_time is the only view that finds it.

A client portal has a status dropdown at the to...