Hi There are lot of useful queries (views), that are on our wiki. Some queries are necessary for maintenance, and I am thinking these queries should be integrated part of Postgres.
Mainly queries for detecting table bloat, index bloat, But some queries over pg_locks should be useful too. Notes, comments? Regards Pavel