I have two postgres db, prod and dev. Lately, dev has been really slow, so I checked into it, and it appears to be using CPU credits faster than I'm getting them. I could not figure out why, so I checked the cpu usage history, and it appears that after a strange spike, the baseline has settled to twice the usage it was before:
I could not find any active sessions which would warrant such cpu usage, but just to be sure, I stopped the db, let it sit for a bit, then started it again. Even after a fresh start, though, the cpu usage is still strangely high, even as compared to a very similar db:
How can I figure out what all of this usage is coming from?