due to a HN commenter on our previously submit Now we have a terrific query that is not hard to tweak to indicate different views based on all of that info: postgres-checkup – a strong tool automating health checks https://www.ralantech.com/postgresql-database-health-check-consulting-service/