# Locate Slow Query 


![left](./student-guide/diagram/20-Fast-location-and-slow-query-01-01.png)

------------------------------------------------------------
Locate slow query

There are times when the DBA receives feedback from the business side that the SQL duration for a certain period of time increases.

At this time, we can check the overview report in the grafana dashboard to judge the duration of the database in different dimensions such as 99,999. However, in the grafana dashboard, we can't see which specific SQL has a high duration. By slow querying the report, you can quickly and easily locate these problematic SQL statements.

In the slow queries page of the PD Dashboard, we can aggregate slow queries into the system according to different dimensions. Click Slow Down to query the corresponding SQL, and we can see the execution plan and related information for that SQL.
PD Dashboard can help us quickly locate which SQL needs to be optimized in case of emergency, so as to solve the problem in a targeted manner.