Querying Slow Query Logs
Function
This API is used to query the slow query logs of a specified DB instance. Before calling this API:
- Learn how to authorize and authenticate it.
- Obtain the required region and endpoint.
URI
POST /v3.1/{project_id}/instances/{instance_id}/slow-logs
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
project_id |
Yes |
String |
Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID. |
instance_id |
Yes |
String |
Instance ID, which is compliant with the UUID format. |
Request Parameters
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
X-Auth-Token |
Yes |
String |
User token. If the following response body is returned for calling the API used to obtain a user token, the request is successful. After the request is processed, the value of X-Subject-Token in the message header is the token value. |
X-Language |
No |
String |
Request language type. The default value is en-us. Value:
|
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
node_id |
Yes |
String |
Node ID. |
start_time |
Yes |
String |
Start time in the "yyyy-mm-ddThh:mm:ssZ" format. T is the separator between the calendar and the hourly notation of time. Z indicates the time zone offset. For example, if the time zone offset is one hour, the value of Z is +0100. |
end_time |
Yes |
String |
End time in the "yyyy-mm-ddThh:mm:ssZ" format. T is the separator between the calendar and the hourly notation of time. Z indicates the time zone offset. For example, if the time zone offset is one hour, the value of Z is +0100. |
limit |
Yes |
Integer |
Number of records to be queried. |
line_num |
No |
String |
Sequence number of a log event. This parameter is not required for the first query, but is required for subsequent pagination queries. The value can be obtained from the response of the last query. |
operate_type |
No |
String |
Statement type. If it is left blank, all statement types are queried. Value:
|
database |
No |
String |
Database which slow logs belong to. |
Response Parameters
Status code: 200
Parameter |
Type |
Description |
---|---|---|
slow_log_list |
Array of LtsLogSlowDetail objects |
Slow query logs. |
Parameter |
Type |
Description |
---|---|---|
node_id |
String |
Node ID. |
count |
String |
Number of executions. |
time |
String |
Execution time. |
lock_time |
String |
Lock wait time. |
rows_sent |
String |
Number of sent rows. |
rows_examined |
String |
Number of scanned rows. |
database |
String |
Database which slow logs belong to. |
users |
String |
Account. |
query_sample |
String |
Execution syntax. |
type |
String |
Statement type. |
start_time |
String |
Start time in the UTC format. |
client_ip |
String |
IP address. |
line_num |
String |
Sequence number of a log event. |
Status code: 400
Parameter |
Type |
Description |
---|---|---|
error_code |
String |
Error code. |
error_msg |
String |
Error message. |
Status code: 500
Parameter |
Type |
Description |
---|---|---|
error_code |
String |
Error code. |
error_msg |
String |
Error message. |
Example Request
Querying slow query logs
POST https://{endpoint}/v3.1/056538411200d4cd2f79c003c7606412/instances/096c0fc43e804757b59946b80dc27f8bin07/slow-logs { "start_time" : "2022-11-20T00:00:00+0800", "end_time" : "2022-11-29T00:00:00+0800", "node_id" : "cc07c60e94ec4575989840e648fb4f66no07", "limit" : 10, "line_num" : 1669344916000 }
Example Response
Status code: 200
Success.
{ "slow_log_list" : [ { "node_id" : "cc07c60e94ec4575989840e648fb4f66no07", "count" : 1, "time" : "1.04899 s", "lock_time" : "0.00003 s", "rows_sent" : 0, "rows_examined" : 0, "database" : "gaussdb-mysql", "users" : "root", "query_sample" : "INSERT INTO time_zone_name (Name, Time_zone_id) VALUES (N @time_zone_id);", "type" : "INSERT", "start_time" : "2022-11-25T10:55:16.000", "client_ip" : "192.*.*.1", "line_num" : 1669344916000 } ] }
Status Code
For details, see Status Codes.
Error Code
For details, see Error Codes.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot