because of a HN commenter on our previously submit we have a great query that is not hard to tweak to show various sights according to all of that information: postgres-checkup – a strong tool automating health https://www.ralantech.com/postgresql-database-health-check-consulting-service/