# P99 latency zero in RED dashboard

**URL:** <https://forums.percona.com/t/p99-latency-zero-in-red-dashboard/18678>\
**Category:** Percona Monitoring and Management (PMM)\
**Tags:** closed-no-reply\
**Created:** [November 20, 2022, 6:14pm UTC](https://forums.percona.com/t/p99-latency-zero-in-red-dashboard/18678 "2022-11-20T18:14:15Z")\
**Posts on this page:** 1\
**Page:** 1

<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:** [November 20, 2022, 6:14pm UTC](https://forums.percona.com/t/p99-latency-zero-in-red-dashboard/18678/1 "2022-11-20T18:14:15Z")

</div>

we are on 2.32 version and we notice p99 latency as zero for all nodes in mysql.

SELECT  
$timeSeries as t,  
sum(m\_query\_time\_sum)/sum(m\_query\_time\_cnt) as AvgLatency,  
avg(m\_query\_time\_p99) as p99Latency  
FROM $table  
WHERE $timeFilter and service\_type=‘mysql’  
GROUP BY t  
ORDER BY t