due to a HN commenter on our before write-up We have now a fantastic query that is not hard to tweak to indicate unique views according to all that details:
Our authorities will remotely inspect your database scenarios https://www.ralantech.com/postgresql-database-health-check-consulting-service/