PMM Query Analytics for Postgres & Aurora Postgres

Did anyone tried query analytics for postgres and RDS? In status for qan-postgresql-pgstatements-agent it show Waiting.

Agent type Status Agent ID Service ID
pmm-agent connected /agent_id/03b9432d-1492-45d2-959b-0519047d3c5d
node_exporter running /agent_id/e011ddd1-bdc8-43b3-98de-710344eb0ec2
postgres_exporter running /agent_id/8acd987f-9f76-4ad1-87b9-a995e6d09c04 /service_id/87fc07a8-ea20-4ca3-a4f9-85da82816e56

qan-postgresql-pgstatements-agent waiting /agent_id/7a3565e9-c513-4c69-8b51-cf96e48e40ed /service_id/87fc07a8-ea20-4ca3-a4f9-85da82816e56

I have exactly the same behaviour with PostgreSQL 11.4. If you managed to identify the problem or misconfiguration, please let me know.

Thanks!

I had the same problem: I was not creating the pg_stat_statements extension in the right database.

This:
CREATE EXTENSION pg_stat_statements SCHEMA public;
has to be executed in the database used by pmm, which is the one with the same name as the username specified in the ‘pmm-admin add postgresql’ command.

For more details, see:
https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/54792-pmm-postgres_exporter-returns-database-does-not-exist

Hope it helps.