So I’ve got PMM set up and I can see certain things, but I can’t (in QAN) see everything. I can see the pmm_user and postgres database for example, but I cannot see the database where all of my schemas (and tables are). I also can not see any of the other users/roles. I am guessing this is a missing role/permission thing from pmm_user. I can see queries that are being run by pmm_user through QAN. Any idea on what I need to do to be able to see the details about the other databases and schemas?
I am running Postgres 9.6 hosted in GCP, and it is DaaS.