# Any way to create alerts based off of the Query Analytics page?

**URL:** <https://forums.percona.com/t/any-way-to-create-alerts-based-off-of-the-query-analytics-page/9305>\
**Category:** PMM 2.x\
**Tags:** mysql\
**Created:** [February 16, 2021, 7:33pm UTC](https://forums.percona.com/t/any-way-to-create-alerts-based-off-of-the-query-analytics-page/9305 "2021-02-16T19:33:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeff\_K](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jeff_k/32/1327_2.png) [@Jeff\_K](https://forums.percona.com/u/Jeff_K)\
**Post date:** [February 16, 2021, 7:33pm UTC](https://forums.percona.com/t/any-way-to-create-alerts-based-off-of-the-query-analytics-page/9305/1 "2021-02-16T19:33:57Z")

</div>

I want to create an alert based on queries taking over x seconds.

I’ve created alerts in my own custom Alertmanager in the past by clicking on “Explore” on a specific dashboard in the PMM Grafana instance to pull the metric name I want to use for the promql needed to make the alert. However, when opening the Query Analyitics page in PMM, it doesn’t seem to use the same data stream as the Prometheus metrics? Is there any other way to do this?

---

<div class="post-metadata">

**Author:** ![steve.hoffman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/steve.hoffman/32/66_2.png) [@steve.hoffman](https://forums.percona.com/u/steve.hoffman)\
**Post date:** [February 16, 2021, 8:19pm UTC](https://forums.percona.com/t/any-way-to-create-alerts-based-off-of-the-query-analytics-page/9305/2 "2021-02-16T20:19:30Z")

</div>

Not as of yet but it will come in time (again, I’m talking about integrated alerting vs the native grafana alerts) but I believe the order of implementation will be from grafana panels first and QAN second BUT I will send this over to our PO to take as input on where the bigger value to the user will be.

In the mean time if there’s a particular component of QAN that you want to alert on just paste it here as we have a few PromQL wizards that can probably help craft the query to base the alert on.

---

<div class="post-metadata">

**Author:** ![Jeff\_K](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jeff_k/32/1327_2.png) [@Jeff\_K](https://forums.percona.com/u/Jeff_K)\
**Post date:** [February 16, 2021, 8:26pm UTC](https://forums.percona.com/t/any-way-to-create-alerts-based-off-of-the-query-analytics-page/9305/3 "2021-02-16T20:26:30Z")

</div>

Thanks for the info. We basically have this alert setup as a bash script (select \* from information\_schema.processlist where time \>3600;), but wanted to eliminate the need to have an outside computer do a login and query, since that info may already be contained in PMM.

---

<div class="post-metadata">

**Author:** ![Tanuj\_Bolisetty](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tanuj_bolisetty/32/4092_2.png) [@Tanuj\_Bolisetty](https://forums.percona.com/u/Tanuj_Bolisetty)\
**Post date:** [July 27, 2021, 8:49pm UTC](https://forums.percona.com/t/any-way-to-create-alerts-based-off-of-the-query-analytics-page/9305/4 "2021-07-27T20:49:57Z")

</div>

Is this feature made available in recent versions ? we are also intrested if we see a sudden increase in the avg query responsetime compared to the past.