DescribeSlowSQLList - ApsaraDB for OceanBase - Alibaba Cloud Documentation Center

You can call this operation to query the list of slow SQL statements

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.	t2mr3oae0****
StartTime	string	Yes	The start time of the time range for querying slow SQL statements. The value must be UTC time in the format of YYYY-MM-DDThh:mm:ssZ.	2021-06-13T15:40:43Z
EndTime	string	Yes	The end time of the time range for querying slow SQL statements. The value must be UTC time in the format of YYYY-MM-DDThh:mm:ssZ.	2021-09-13T15:40:43Z
DbName	string	No	The name of the database.	testdb
SearchKeyWord	string	No	The search keyword.	update
SearchParameter	string	No	The search parameter.	cputime
SearchRule	string	No	The search rule.	>
SearchValue	string	No	The search value.	0.01
SQLId	string	No	The SQL ID, which uniquely identifies an SQL statement.	8D6E84**0B8FB1823D199E2CA1**
NodeIp	string	No	The IP address of the database node.	i-bp18qljorblo8es*****
PageNumber	integer	No	The number of rows to return on each page. Maximum value: 100 Default value: 10	10
PageSize	integer	No	The number of the page to return. Start value: 1 Default value: 1	1
FilterCondition	object	No	The filter condition.	[dbName:sys]
SortColumn	string	No	The sorted column.	cputime
SortOrder	string	No	The sorting rule.	desc

Response parameters

Parameter	Type	Description	Example
	object	The return result of the request.
TotalCount	long	The total count.	2
RequestId	string	The request ID.	473469C7-AA6F-4DC5-B3DB-A3DC0DE3C83E
SlowSQLList	object []	The list of slow SQL statements.
Key	long	The sequence number of the returned SQL statement.	1
ExecPerSecond	float	The number of executions per second.	163.0
SQLText	string	The SQL text.	SELECT ** FROM WHERE = ? AND = ? ORDER BY ** ASC
MaxCpuTime	float	The maximum CPU time.	257.967
BlockCacheHit	long	The number of block cache hits.	14
DecodeTime	float	The time to wait for decoding.	0.0
RemotePlans	long	The number of remote plans.	0
RPCCount	long	The number of RPCs.	0
NetWaitTime	float	The network latency.	0.0
DiskRead	long	The number of physical reads.	0
NodeIp	string	The IP address of the node.	i-bp18qljorblo8es*****
ConcurrencyWaitTime	float	The wait time in concurrent execution.	0.0
MemstoreReadRowCount	long	The number of rows read from the memory.	527
DbName	string	The name of the database.	testdb
AppWaitTime	float	The wait time of the client.	0.0
ElapsedTime	float	The average response time.	76.382
MissPlans	long	The number of plan misses.	0
AffectedRows	long	The number of rows affected.	0
ScheduleTime	float	The scheduling duration.	0.0
Event	string	The wait event.	mysql response wait client
TotalWaitTime	float	The internal wait time.	10.966
ReturnRows	long	The number of rows returned.	1
ExecuteTime	float	The internal execution time.	61.044
UserName	string	The username.	tester
Executions	long	The number of executions.	89403
GetPlanTime	float	The time spent in hard parsing.	0.052
CpuTime	float	The average CPU time.	50.13
MaxElapsedTime	float	The maximum response time.	260.044
SQLType	long	The SQL type.	1
BlockIndexCacheHit	long	The number of block index cache hits.	4
RetryCount	long	The number of retries.	0
SQLId	string	SQLID.	8D6E84**0B8FB1823D199E2CA1**
ClientIp	string	The IP address of the client.	12.*.13.***
BloomFilterCacheHit	long	The number of Bloom filter cache hits.	0
IOWaitTime	float	The I/O wait time.	0.0
FailTimes	long	The number of failures.	0
QueueTime	float	The queuing time.	15.275
RowCacheHit	long	The number of row cache hits.	0
LogicalRead	long	The number of logical reads.	19
SsstoreReadRowCount	long	The number of rows read from the disk.	43086

Examples

Sample success responses

JSONformat

{
  "TotalCount": 2,
  "RequestId": "473469C7-AA6F-4DC5-B3DB-A3DC0DE3C83E",
  "SlowSQLList": [
    {
      "Key": 1,
      "ExecPerSecond": 163,
      "SQLText": "SELECT  ****   FROM ****   WHERE **** = ? AND **** = ?   ORDER BY **** ASC",
      "MaxCpuTime": 257.967,
      "BlockCacheHit": 14,
      "DecodeTime": 0,
      "RemotePlans": 0,
      "RPCCount": 0,
      "NetWaitTime": 0,
      "DiskRead": 0,
      "NodeIp": "i-bp18qljorblo8es*****",
      "ConcurrencyWaitTime": 0,
      "MemstoreReadRowCount": 527,
      "DbName": "testdb",
      "AppWaitTime": 0,
      "ElapsedTime": 76.382,
      "MissPlans": 0,
      "AffectedRows": 0,
      "ScheduleTime": 0,
      "Event": "mysql response wait client",
      "TotalWaitTime": 10.966,
      "ReturnRows": 1,
      "ExecuteTime": 61.044,
      "UserName": "tester",
      "Executions": 89403,
      "GetPlanTime": 0.052,
      "CpuTime": 50.13,
      "MaxElapsedTime": 260.044,
      "SQLType": 1,
      "BlockIndexCacheHit": 4,
      "RetryCount": 0,
      "SQLId": "8D6E84****0B8FB1823D199E2CA1****",
      "ClientIp": "1*2.***.1*3.***",
      "BloomFilterCacheHit": 0,
      "IOWaitTime": 0,
      "FailTimes": 0,
      "QueueTime": 15.275,
      "RowCacheHit": 0,
      "LogicalRead": 19,
      "SsstoreReadRowCount": 43086
    }
  ]
}

Error codes

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

Change history

Change time	Summary of changes	Operation

No change history