Hey folks, I'm having an issue with my project on the Pro plan. I think I overloaded my database with too aggressive polling (queries every 1-2 min from multiple endpoints + several Realtime subscriptions running simultaneously). I've already fixed this — increased polling intervals to 10 min, disabled most Realtime channels, and significantly reduced the number of queries hitting the DB.
The problem is the database still shows "Unhealthy" status in the dashboard and I can't use it properly (getting 522 errors, ~11s response times). I'm afraid to do Pause/Restore because last time (on the free plan) the project got stuck and wouldn't come back — I had to wait the entire weekend for support to manually restore it. This is a production app so I can't afford that downtime.
Does anyone know how to get the database back to Healthy without pausing? Is there a way to restart the services or clear phantom subscribers?