Select Clear Assigned User. Chapter 6 - Query Analyzer Start Query Analyzer The Query Analyzer tool provides a graphical representation for the query logs, enables you to monitor and optimize query performance, visualize query activity statistics, analyze SQL statements, quickly identify and resolve long running queries. To start using Query Analyzer, select an instance you want to analyze in the left pane, and analysis starts immediately. Note: A prompt may pop up asking you to authorize Navicat Monitor to get relevant data from your instance. After a while, analysis results are displayed: Navicat Monitor refreshes the metrics in the Query Analyzer every 60 seconds. To stop or start refreshing the metrics, click the or icon. Server data collection does not stop during the stop period. Long Running Queries Long Running Queries chart shows queries with an average hourly wait time greater than the policy. Use the SHOW LAST drop-down menu to select a time period. Each query is represented by a unique color. Hover over a bar segment provides a detail view of the query, including query statement and total wait time. To drill down into the chart, click on it to open the Long Running Queries page.
Select Clear Assigned User. Chapter 6 - Query Analyzer Start Query Analyzer The Query Analyzer tool provides a graphical representation for the query logs, enables you to monitor and optimize query performance, visualize query activity statistics, analyze SQL statements, quickly identify and resolve long running queries. To start using Query Analyzer, select an instance you want to analyze in the left pane, and analysis starts immediately. After a while, analysis results are displayed: Navicat Monitor refreshes the metrics in the Query Analyzer every 60 seconds. To stop or start refreshing the metrics, click the or icon. Server data collection does not stop during the stop period.
