DescribeSlowSQLHistoryList - ApsaraDB for OceanBase - Alibaba Cloud Documentation Center

You can call this operation to query the execution history of an SQL statement by SQL ID that is determined as a slow SQL statement during a specified period of time.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer.

Debug

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

Parameter	Type	Required	Description	Example
TenantId	string	Yes	The ID of the tenant.	t384tolsj****
StartTime	string	Yes	The start time of the time range for querying the execution history of the slow SQL statement. The value must be UTC time in the format of YYYY-MM-DDThh:mm:ssZ.	2021-12-14T02:34:49Z
EndTime	string	Yes	The end time of the time range for querying the execution history of the slow SQL statement. The value must be UTC time in the format of YYYY-MM-DDThh:mm:ssZ.	2021-12-14T08:34:49Z
SQLId	string	Yes	The SQL ID, which uniquely identifies an SQL statement.	8D6E84735C0**1823D199E2CA1**
PageNumber	integer	No	The number of the page to return. Start value: 1 Default value: 1	1
PageSize	integer	No	The number of rows to return on each page. Maximum value: 100 Default value: 10	10

Response parameters

Parameter	Type	Description	Example
	object	The return result of the request.
RequestId	string	The request ID.	EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C
SlowSQLHistoryList	object	The execution history of the slow SQL statement.
List	object []	The return result of the request.
SqlId	string	SQLID.	8D6E84**0B8FB1823D199E2CA1**
SqlType	string	The SQL type.	1
TenantName	string	The name of the tenant.	pay_online
UserName	string	The username.	tester
ClientIp	string	The IP address of the client.	12.*.13.***
DbName	string	The name of the database.	testdb
Event	string	The wait event.	mysql response wait client
NodeIp	string	The IP address of the node.	i-bp18qljorblo8es*****
AffectedRows	double	The number of rows affected.	0
BlockCacheHit	double	The number of block cache hits.	14
BlockIndexCacheHit	double	The number of block index cache hits.	4
BloomFilterCacheHit	double	The number of Bloom filter cache hits.	0
Executions	double	The number of executions.	89403
FailTimes	double	The number of failures.	0
RPCCount	double	The number of RPCs.	0
RemotePlans	double	The number of remote plans.	0
MissPlans	double	The number of plan misses.	0
ReturnRows	double	The number of rows returned.	1
LogicalRead	double	The number of logical reads.	19
RetryCount	double	The number of retries.	0
RowCacheHit	double	The number of row cache hits.	0
DiskRead	double	The number of physical reads.	0
MemstoreReadRowCount	double	The number of rows read from the memory.	527
SsstoreReadRowCount	double	The number of rows read from the disk.	43086
ExecPerSecond	double	The number of executions per second.	163.0
AppWaitTime	double	The wait time of the client.	0.0
ElapsedTime	double	The average response time.	76.382
ExecuteTime	double	The internal execution time.	61.044
QueueTime	double	The queuing time.	15.275
ConcurrencyWaitTime	double	The wait time in concurrent execution.	0.0
CpuTime	double	The average CPU time.	50.13
DecodeTime	double	The time to wait for decoding.	0.0
NetWaitTime	double	The wait time for network.	0.0
IOWaitTime	double	The I/O wait time.	0.0
GetPlanTime	double	Hard parsing time.	0.052
MaxElapsedTime	double	The maximum response time.	260.044
TotalWaitTime	double	The internal wait time.	10.966
ScheduleTime	double	The scheduling duration.	0.0
MaxCpuTime	double	The maximum CPU time.	257.967
EndTimeUTCString	string	The end time.	2021-12-28T02:08:18Z
Count	long	The quantity.	1

Examples

Sample success responses

JSONformat

{
  "RequestId": "EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C",
  "SlowSQLHistoryList": {
    "List": [
      {
        "SqlId": "8D6E84****0B8FB1823D199E2CA1****",
        "SqlType": "1",
        "TenantName": "pay_online",
        "UserName": "tester",
        "ClientIp": "1*2.***.1*3.***",
        "DbName": "testdb",
        "Event": "mysql response wait client",
        "NodeIp": "i-bp18qljorblo8es*****",
        "AffectedRows": 0,
        "BlockCacheHit": 14,
        "BlockIndexCacheHit": 4,
        "BloomFilterCacheHit": 0,
        "Executions": 89403,
        "FailTimes": 0,
        "RPCCount": 0,
        "RemotePlans": 0,
        "MissPlans": 0,
        "ReturnRows": 1,
        "LogicalRead": 19,
        "RetryCount": 0,
        "RowCacheHit": 0,
        "DiskRead": 0,
        "MemstoreReadRowCount": 527,
        "SsstoreReadRowCount": 43086,
        "ExecPerSecond": 163,
        "AppWaitTime": 0,
        "ElapsedTime": 76.382,
        "ExecuteTime": 61.044,
        "QueueTime": 15.275,
        "ConcurrencyWaitTime": 0,
        "CpuTime": 50.13,
        "DecodeTime": 0,
        "NetWaitTime": 0,
        "IOWaitTime": 0,
        "GetPlanTime": 0.052,
        "MaxElapsedTime": 260.044,
        "TotalWaitTime": 10.966,
        "ScheduleTime": 0,
        "MaxCpuTime": 257.967,
        "EndTimeUTCString": "2021-12-28T02:08:18Z"
      }
    ],
    "Count": 1
  }
}

Error codes

For a list of error codes, visit the Service error codes.

Change history

Change time	Summary of changes	Operation

No change history