# Setup alerts for slow queries in PMM

**URL:** <https://forums.percona.com/t/setup-alerts-for-slow-queries-in-pmm/23067>\
**Category:** Percona Monitoring and Management (PMM)\
**Tags:** postgresql\
**Created:** [June 23, 2023, 10:45am UTC](https://forums.percona.com/t/setup-alerts-for-slow-queries-in-pmm/23067 "2023-06-23T10:45:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkumar11](https://avatars.discourse-cdn.com/v4/letter/b/cdc98d/32.png) [@bkumar11](https://forums.percona.com/u/bkumar11)\
**Post date:** [June 23, 2023, 10:45am UTC](https://forums.percona.com/t/setup-alerts-for-slow-queries-in-pmm/23067/1 "2023-06-23T10:45:13Z")

</div>

Hi Team,

I would like to add alert for slow queries from query analytics in PMM.  
Let me know if it is possible.

Thanks  
Bharath

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [July 23, 2023, 11:12am UTC](https://forums.percona.com/t/setup-alerts-for-slow-queries-in-pmm/23067/2 "2023-07-23T11:12:48Z")

</div>

Hi @bkumar11,

If you’re looking to create an alert on Query Analytics dashboard, I don’t think this is possible. There are possible options for you to track the side effect of the slow queries for eg, increased load, connections, CPU, disk io etc. That said, can you elaborate on your question on what exactly are you planning to do?

Thanks,  
K

---

<div class="post-metadata">

**Author:** ![bkumar11](https://avatars.discourse-cdn.com/v4/letter/b/cdc98d/32.png) [@bkumar11](https://forums.percona.com/u/bkumar11)\
**Post date:** [July 24, 2023, 6:29am UTC](https://forums.percona.com/t/setup-alerts-for-slow-queries-in-pmm/23067/3 "2023-07-24T06:29:42Z")

</div>

Hi @kedarpercona ,

We are using PMM for AWS RDS Aurora PostgreSQL.  
We have enable pg\_stat\_statements in order to collect the queries executed in our database and in PMM query analytics we could see the queries as well. Our requirement is, from the QAN for a query if the time taken for it to execute is greater than a certain threshold we should be able to send alerts.

Regards,  
Bharath
