查询
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
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
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
| 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
