Feature idea: automatic PG health checks

[pawurb]

I'm adding the issue as placeholder to not to forget the idea and gather feedback.

I'd like to add a way to automatically check the health of your database based on both default and customizable conditions. Something on the lines of https://blog.heroku.com/pg-diagnose