# Query Response Time Details dashboard

**URL:** <https://forums.percona.com/t/query-response-time-details-dashboard/14124>\
**Category:** PMM 2.x\
**Tags:** mysql\
**Created:** [January 27, 2022, 9:44am UTC](https://forums.percona.com/t/query-response-time-details-dashboard/14124 "2022-01-27T09:44:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![life\_teo](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/life_teo/32/5614_2.png) [@life\_teo](https://forums.percona.com/u/life_teo)\
**Post date:** [January 27, 2022, 9:44am UTC](https://forums.percona.com/t/query-response-time-details-dashboard/14124/1 "2022-01-27T09:44:41Z")

</div>

As I understand it, the MySQL Query Response Time Details dashboard is based on the query\_response\_time.so plugin which has been deprecated and its functionality has been incorporated into the Performance Schema ([The file query\_response\_time.so does not exists into mysql version Ver 8.0.19](https://forums.percona.com/t/the-file-query-response-time-so-does-not-exists-into-mysql-version-ver-8-0-19/7977) ).  
How can I get access to these metrics, provided that Slow query log is used?

I use version 8 of Percon server

---

<div class="post-metadata">

**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:** [January 27, 2022, 8:13pm UTC](https://forums.percona.com/t/query-response-time-details-dashboard/14124/2 "2022-01-27T20:13:05Z")

</div>

Hello @life_teo,  
Unfortunately with PMM and MySQL 8, the query response time data is not processed and displayed. You would need to enable the correct performance\_schema tables and then write a custom query in PMM to collect the data.

[https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html](https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html)

> **[PMM's Custom Queries in Action: Adding a Graph for InnoDB mutex waits -...](https://www.percona.com/blog/2019/03/12/pmms-custom-queries-in-action-adding-a-graph-for-innodb-mutex-waits/)**
>
> Use custom queries to extend Percona Monitoring and Management graphs. Daniel Guzmán Burgos takes advantage of PMM's flexibility to add mutex wait metrics.

Please also comment on this ticket for adding the support back to PMM  
[https://jira.percona.com/browse/PMM-4812](https://jira.percona.com/browse/PMM-4812)

Query execution metrics are already available in the QAN, so the current situation from our PMM developers is why this additional information is needed and why the current information is not enough.