# QAN window not logging db queries running on RDS Aurora

**URL:** <https://forums.percona.com/t/qan-window-not-logging-db-queries-running-on-rds-aurora/5628>\
**Category:** PMM 1.x\
**Created:** [May 22, 2017, 12:06pm UTC](https://forums.percona.com/t/qan-window-not-logging-db-queries-running-on-rds-aurora/5628 "2017-05-22T12:06:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![govindareddy20](https://avatars.discourse-cdn.com/v4/letter/g/e480ec/32.png) [@govindareddy20](https://forums.percona.com/u/govindareddy20)\
**Post date:** [May 22, 2017, 12:06pm UTC](https://forums.percona.com/t/qan-window-not-logging-db-queries-running-on-rds-aurora/5628/1 "2017-05-22T12:06:56Z")

</div>

Hi,  
I installed pmm 1.1.3 on EC2 instance and added aurora clusters to collect mysql metrics.  
I used the below command to install pmm-server,  
sudo docker run -d -p 80:80 --volumes-from pmm-data --name pmm-server -e METRICS\_RETENTION=360h -e METRICS\_RESOLUTION=5s --restart always percona/pmm-server:1.1.3  
Performance\_schema and slow\_log are ON and QAN is using performance\_schema. I’m not seeing actual db queries running on Aurora instance in QAN window. It’s logging the queries running by pmm-server means the queries that needs the metrics. Grafana is working fine.

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [May 26, 2017, 2:24am UTC](https://forums.percona.com/t/qan-window-not-logging-db-queries-running-on-rds-aurora/5628/2 "2017-05-26T02:24:45Z")

</div>

Hi,

1. can you share output?
2. can you run query and post output?
3. is monitoring user has the following grants?

```auto

GRANT SELECT, PROCESS, REPLICATION CLIENT ON *.* TO 'pmm'&#64;'%' IDENTIFIED BY 'pass' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO 'pmm'&#64;'%'; 

```

---

<div class="post-metadata">

**Author:** ![purnary](https://avatars.discourse-cdn.com/v4/letter/p/73ab20/32.png) [@purnary](https://forums.percona.com/u/purnary)\
**Post date:** [May 8, 2023, 5:30am UTC](https://forums.percona.com/t/qan-window-not-logging-db-queries-running-on-rds-aurora/5628/3 "2023-05-08T05:30:25Z")

</div>

Do you have the solution for this issue?  
I add DB from RDS Aurora to PMM but can’t see the QAN. Other metric like host utilization is available.