Skip to content

Query

This document mainly introduces how we can use the Slow query monitoring function provided by the software.

Move the mouse to the top menu Monitor and wait for the drop-down options to appear, click Query to enter the query monitoring interface, which is similar to the following page

img.png

The upper part of the page is the data chart display & function configuration area, and the lower part is the detailed data list area

Data charting & Feature Configuration


The drop-down selection box on the top left is used to select the configured data source. After selection, the software will initiate a request to the service to obtain information, and return a data chart similar to the following

img_1.png

There is a Number input device at the top right

Numeric input is used to mark the maximum time-consuming limit of the query (unit: milliseconds)

Details of the data


The drop-down selection box on the top left is used to select the configured data source. After selection, the software will initiate a request to the service to obtain information, and return results similar to the following

img_2.png

Property Description
user Query the user used
host Query the client host
hash Query the generated hash data
time Query creation time
elapsed(ms) Query time (ms)
memoryUsage Memory used by query
rows Query the total number of rows
bytes Total number of bytes queried
readRows Query the total number of rows of read metadata
bytesRead Query the total number of bytes of metadata read
writtenRows The total number of bytes of metadata written to the query
bytesWritten The total number of bytes of metadata written to the query

Action


button To query the DDL statement of the operation

img_3.png

Back to top