owing to a HN commenter on our previously put up We have now an excellent query that is easy to tweak to show various views determined by all that info:
produce and maintain technological documentation making use of https://www.ralantech.com/postgresql-database-health-check-consulting-service/