EDIT: It seems to have been fixed thanks to @graycube@lemmy.world. Running analyze verbose; in postgres.
After updating to 0.19.5 from 0.19.3 my postgres is often using up 500%+ of CPU according to docker stats and often going to 100% CPU on most cores according to htop. Also noticed in the uptime monitor:
htop shows one of the 5 postgres processes constantly on UPDATE. I think this might be part of the problem.
I'm not comfortable with postgres and am honestly completely in the dark how or where to mitigate or even pinpoint this issue.