Hello,
I have noticed that there is no regression tests for default monitoring roles such as pg_read_all_stats.
In this patch the test called defroles is added. It tests permissions of pg_read_all_stats role to query database size without CONNECT permission on it, to query tablespace size without CREATE permission on it, and to read "query" column of pg_stat_activity table without SUPERUSER privilege.
Best regards,
Alexandra Ryzhevich