So I just had postgres got to 80% CPU for about 15 minutes. I have two questions:
1) Where would I start in trying to track down what happened? I ran this query but unfortunately after the fact: SELECT pid, datname, usename, query FROM pg_stat_activity; I spelunking in the logs right now but...