High CPU usage in Postgres: how to detect it, and how to fix it

High CPU usage can bring your database – and with it, your application – grinding to a halt. This is, unfortunately, a fairly common problem. But it also can be a relatively easy fix.