The official Percona Monitoring and Management (PMM) documentation suggests creating a PMM user with
WITH SUPERUSER permission. However, I prefer to avoid granting such extensive permissions. While the PMM agent operates smoothly with basic permissions, I encountered an issue with Query Analytics.
GRANT SELECT ON pg_stat_statements TO pmm-user on all databases, I can observe query analytics on the ‘postgres’ system database, but not on other databases.
I’m seeking guidance on whether it’s possible to enable query analytics in PMM without granting superuser permissions to the user.
PMM Version: 2.40.0