# \[QAN\] - Query Analytics configuration for PostgreSQL **URL:** \ **Category:** pg\_stat\_monitor\ **Tags:** community, pmm, percona\ **Created:** [September 26, 2022, 5:42pm UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677 "2022-09-26T17:42:41Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![waly\_ferreira](https://avatars.discourse-cdn.com/v4/letter/w/b3f665/32.png) [@waly\_ferreira](https://forums.percona.com/u/waly_ferreira)\ **Post date:** [September 26, 2022, 5:42pm UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677/1 "2022-09-26T17:42:41Z")
Hello, I have implemented Percona in my environment for PostgreSQL monitoring. All monitoring is happening normally, however when I check in the Query Analytics dashboard, I can only view system queries and not my database queries. Is there any specific configuration to put in place for QAN? Any PostgreSQL Role permissions? Attached, I am sending an image for better understanding. ![PMM_QAN](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c16ff1aef6f7e0344f07c5f6977fc03064c7da1b.png) I thank you in advance for your attention. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [September 26, 2022, 6:27pm UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677/2 "2022-09-26T18:27:43Z")
Did you install the PMM Agent on your PGSQL server and connect it to PMM Server? ---
**Author:** ![waly\_ferreira](https://avatars.discourse-cdn.com/v4/letter/w/b3f665/32.png) [@waly\_ferreira](https://forums.percona.com/u/waly_ferreira)\ **Post date:** [September 26, 2022, 8:04pm UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677/3 "2022-09-26T20:04:05Z")
Hi Matt, Yes, it was configured correctly. All other metrics are showing correctly as per Percona’s native templates. Only the QAN which doesn’t show me anything related to the database. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [September 26, 2022, 8:19pm UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677/4 "2022-09-26T20:19:50Z")
Change the interval to 5m and see if any data shows then. If still not, check the pmm-admin status on the server. ---
**Author:** ![waly\_ferreira](https://avatars.discourse-cdn.com/v4/letter/w/b3f665/32.png) [@waly\_ferreira](https://forums.percona.com/u/waly_ferreira)\ **Post date:** [September 27, 2022, 3:44pm UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677/5 "2022-09-27T15:44:03Z")
Matt, A question, for QAN to bring the metrics, the monitoring user created needs to be “superuser”?? This question also applies to other Databases such as MongoDB and MySQL. I’m asking, because all the settings are correct, but analyzing here, I saw that my monitoring users are not superusers. I’m grateful for the attention. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [September 27, 2022, 7:24pm UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677/6 "2022-09-27T19:24:22Z")
I’m not sure for PGSQL; I’ll have to ask one of our PG guys. Did you follow our documentation for setting up proper privileges? I can speak for MySQL, you do not need to be “super user”. In MySQL you typically scrap the slow log file on disk, or you query the performance\_schema tables. Neither requires elevated privileges, just the correct privileges. ---
**Author:** ![waly\_ferreira](https://avatars.discourse-cdn.com/v4/letter/w/b3f665/32.png) [@waly\_ferreira](https://forums.percona.com/u/waly_ferreira)\ **Post date:** [September 28, 2022, 12:39am UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677/7 "2022-09-28T00:39:47Z")
Matt, I followed yes and managed to find the error, now we are monitoring and the metrics in the QAN are appearing correctly. Thank you so much for the tips and attention. ---
**Author:** ![Lucas\_henrique](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lucas_henrique/32/8199_2.png) [@Lucas\_henrique](https://forums.percona.com/u/Lucas_henrique)\ **Post date:** [October 28, 2022, 7:43am UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677/8 "2022-10-28T07:43:05Z")
can share what u did? ---
**Author:** ![nikode](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nikode/32/8560_2.png) [@nikode](https://forums.percona.com/u/nikode)\ **Post date:** [December 5, 2022, 3:23pm UTC](https://forums.percona.com/t/qan-query-analytics-configuration-for-postgresql/17677/9 "2022-12-05T15:23:56Z")
what was the mistake?