DescribeOasSlowSQLList - ApsaraDB for OceanBase - Alibaba Cloud Documentation Center

You can call this API to view a list of slow queries.

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
InstanceId	string	Yes	The ID of the OceanBase cluster.	ob317v4uif****
TenantId	string	Yes	The ID of the tenant.	t4louaeei****
StartTime	string	Yes	The start time of querying slow SQL historical parameters. The value must be UTC time in the format of YYYY-MM-DDThh:mm:ssZ.	2023-04-12T04:38:38Z
EndTime	string	Yes	The end time of querying slow SQL historical parameters. The value must be UTC time in the format of YYYY-MM-DDThh:mm:ssZ.	2023-04-12T05:38:38Z
DbName	string	No	The name of the database.	test_db
SearchKeyWord	string	No	The search keyword.	update
SearchParam	string	No	The search parameter.	cputime
SearchRule	string	No	The search rule.	>
SearchValue	string	No	The search value.	0.01
SqlId	string	No	SQL ID, the unique identifier of the SQL.	8D6E84**0B8FB1823D199E2CA1**
NodeIp	string	No	The IP of the database node.	i-bp18qljorblo8es*****
FilterCondition	string	No	All parameters are referenced by the symbol @. For a list of available parameters, refer to the returned parameters in Query performance indicators of an SQL statement.	@avgCpuTime > 20 and @executions > 100
AcceptLanguage	string	No	The language of the response.	zh-CN
SqlTextLength	long	No	Max length of the returned SQL text.	65535

Response parameters

Parameter	Type	Description	Example
	object	Returned response.
RequestId	string	The request ID.	EE205C00-30E4-**-**-87E3A8A2AA0C
Data	object []	The list of slow queries.
Executions	double	Total number of executions during the execution period.	1
RpcCount	double	RPC count during the execution period.	0
RemotePlans	double	Remote execution count during the execution period.	0
MissPlans	double	Missed hit count of the execution plan during the execution period.	0
MaxElapsedTime	double	Max response time during the execution period.	260.044
TotalWaitTime	double	Total wait time during the execution period.	10.966
ExecPs	double	Average execution count per second during the execution period.	0.31
MaxCpuTime	double	Max CPU time.	257.967
ClientIp	string	Client IP.	12.*.13.***
UserName	string	Username.	test_user
DbName	string	The name of the database.	test_db
RetCode4012Count	long	Number of occurrences of code 4012 during the execution period.	0
RetCode4013Count	long	Number of occurrences of code 4013 during the execution period.	0
RetCode5001Count	long	Number of occurrences of code 5001 during the execution period.	0
RetCode5024Count	long	Number of occurrences of code 5024 during the execution period.	0
RetCode5167Count	long	Number of occurrences of code 5167 during the execution period.	0
RetCode5217Count	long	Number of occurrences of code 5217 during the execution period.	0
RetCode6002Count	long	Number of occurrences of code 6002 during the execution period.	0
FailPercentage	double	Error percentage during the execution period.	0.0
SumWaitTime	double	The total wait time (in milliseconds) during the internal waiting period.	9421.73
AvgWaitCount	double	Average number of waits during the execution period.	0.0
AvgRpcCount	double	Average number of RPC sent during the execution.	8.0
LocalPlanPercentage	double	Local plan percentage during the execution period.	0.0
RemotePlanPercentage	double	Remote plan percentage during the execution period.	0.0
DistPlanPercentage	double	Distributed plan percentage during the execution period.	100.0
SumElapsedTime	double	Total response time (in milliseconds) during the execution period.	11452126.36
AvgNetTime	double	Average network transmission time (in milliseconds) during the execution period.	0.0
AvgExecutorRpcCount	double	Average number of RPC requests executed during the execution period.	0.0
MissPlanPercentage	double	Plan hit rage during the execution period.	0.0
TableScanPercentage	double	Table scan percentage during the execution period.	0.0
StrongConsistencyPercentage	double	Strong consistent transaction percentage during the execution period.	100.0
WeakConsistencyPercentage	double	Eventually consistent transaction percentage during the execution period.	0.0
MaxAffectedRows	double	Max affected rows during the execution period.	10000.0
MaxReturnRows	double	Max returned rows during the execution period.	0.0
MaxWaitTime	double	Max wait time (in milliseconds) during the execution period.	3.4
MaxApplicationWaitTime	double	Max Application event wait time (in milliseconds) during the execution period	0.0
MaxConcurrencyWaitTime	double	Max Concurrency event wait time (in milliseconds) during the execution period	0.0
MaxUserIoWaitTime	double	Max UserIO event wait time (in milliseconds) during the execution period.	0.0
MaxDiskReads	double	Max physical read count during the execution period.	0.0
AvgExpectedWorkerCount	double	Average degree of parallelism during the execution period.	3
AvgUsedWorkerCount	double	Average number of threads used of the SQL during the execution period.	3
SumLogicalReads	double	Total logical reads of the SQL during the execution period.	0.0
Server	string	The server where the SQL is executed.	i-bp1db1as038mej**
ServerIp	string	The IP address of the server.	i-bp1db1as038mej**
ServerPort	long	The server port where the SQL is executed.	10110
SqlTextShort	string	SQL text (the first 100 characters).	select a from b where
SqlType	string	SQL type.	select
SqlId	string	SQL ID.	8D6E84**0B8FB1823D199E2CA1**
Inner	boolean	Whether an internal SQL.	false
WaitEvent	string	Longest wait event during the execution period.	none
AvgAffectedRows	double	Average updated rows during the execution period.	9978.75
AvgReturnRows	double	Average number of rows returned during the execution period.	0.0
AvgPartitionCount	double	Average number of partition accessed during the execution period.	1.0
FailCount	double	Average number of partition accessed during the execution period.	0
AvgWaitTime	double	Average wait time (in milliseconds) during the execution period.	1.42
AvgElapsedTime	double	Average response time (in milliseconds) during the execution period.	1876.78
AvgCpuTime	double	Average CPU time (in milliseconds) during the execution period.	1875.34
AvgNetWaitTime	double	Average network enqueue time (in milliseconds) during the network waiting period.	0.0
AvgQueueTime	double	Average queueing time (in milliseconds) during the execution period.	0.01
AvgDecodeTime	double	Average syntax parsing time (in milliseconds) during the execution period.	0.0
AvgGetPlanTime	double	Average plan generation time (in milliseconds) during the execution period.	0.0
AvgExecuteTime	double	Average plan execution time (in milliseconds) during the execution period.	1895.7
AvgApplicationWaitTime	double	Average Application event wait time (in milliseconds) during the client waiting period.	0.0
AvgConcurrencyWaitTime	double	Average Concurrency event wait time (in milliseconds) during the execution period.	0.0
AvgUserIoWaitTime	double	Average UserIO event wait time (in milliseconds) during the execution period.	0.0
AvgScheduleTime	double	Average Schedule event wait time (in milliseconds) during the scheduling period.	0.0
AvgRowCacheHit	double	Average RowCache hit count during the execution period.	0.0
AvgBloomFilterCacheHit	double	Average BloomFilterCache hit count during the execution period.	0.0
AvgBlockCacheHit	double	Average BlockCache hit count during the execution period.	0.0
AvgBlockIndexCacheHit	double	Average BlockIndexCache hit count during the execution period.	0.0
AvgDiskReads	double	Average physical read count during the execution period.	0.0
RetryCount	double	Total number of retries during the execution period.	5
AvgMemstoreReadRows	double	Strong consistent transaction percentage during the execution period.	0.0
AvgSsstoreReadRows	double	Eventually consistent transaction percentage during the execution period.	0.0
AvgLogicalReads	double	Average logical reads of the SQL during the execution period.	0.0

Examples

Sample success responses

JSONformat

{
  "RequestId": "EE205C00-30E4-****-****-87E3A8A2AA0C",
  "Data": [
    {
      "Executions": 1,
      "RpcCount": 0,
      "RemotePlans": 0,
      "MissPlans": 0,
      "MaxElapsedTime": 260.044,
      "TotalWaitTime": 10.966,
      "ExecPs": 0.31,
      "MaxCpuTime": 257.967,
      "ClientIp": "1*2.***.1*3.***",
      "UserName": "test_user",
      "DbName": "test_db",
      "RetCode4012Count": 0,
      "RetCode4013Count": 0,
      "RetCode5001Count": 0,
      "RetCode5024Count": 0,
      "RetCode5167Count": 0,
      "RetCode5217Count": 0,
      "RetCode6002Count": 0,
      "FailPercentage": 0,
      "SumWaitTime": 9421.73,
      "AvgWaitCount": 0,
      "AvgRpcCount": 8,
      "LocalPlanPercentage": 0,
      "RemotePlanPercentage": 0,
      "DistPlanPercentage": 100,
      "SumElapsedTime": 11452126.36,
      "AvgNetTime": 0,
      "AvgExecutorRpcCount": 0,
      "MissPlanPercentage": 0,
      "TableScanPercentage": 0,
      "StrongConsistencyPercentage": 100,
      "WeakConsistencyPercentage": 0,
      "MaxAffectedRows": 10000,
      "MaxReturnRows": 0,
      "MaxWaitTime": 3.4,
      "MaxApplicationWaitTime": 0,
      "MaxConcurrencyWaitTime": 0,
      "MaxUserIoWaitTime": 0,
      "MaxDiskReads": 0,
      "AvgExpectedWorkerCount": 3,
      "AvgUsedWorkerCount": 3,
      "SumLogicalReads": 0,
      "Server": "i-bp1db1a**s038**mej**",
      "ServerIp": "i-bp1db1a**s038**mej**",
      "ServerPort": 10110,
      "SqlTextShort": "select a from b where",
      "SqlType": "select ",
      "SqlId": "8D6E84****0B8FB1823D199E2CA1****",
      "Inner": false,
      "WaitEvent": "none",
      "AvgAffectedRows": 9978.75,
      "AvgReturnRows": 0,
      "AvgPartitionCount": 1,
      "FailCount": 0,
      "AvgWaitTime": 1.42,
      "AvgElapsedTime": 1876.78,
      "AvgCpuTime": 1875.34,
      "AvgNetWaitTime": 0,
      "AvgQueueTime": 0.01,
      "AvgDecodeTime": 0,
      "AvgGetPlanTime": 0,
      "AvgExecuteTime": 1895.7,
      "AvgApplicationWaitTime": 0,
      "AvgConcurrencyWaitTime": 0,
      "AvgUserIoWaitTime": 0,
      "AvgScheduleTime": 0,
      "AvgRowCacheHit": 0,
      "AvgBloomFilterCacheHit": 0,
      "AvgBlockCacheHit": 0,
      "AvgBlockIndexCacheHit": 0,
      "AvgDiskReads": 0,
      "RetryCount": 5,
      "AvgMemstoreReadRows": 0,
      "AvgSsstoreReadRows": 0,
      "AvgLogicalReads": 0
    }
  ]
}

Error codes

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

Change history

Change time

Summary of changes

Operation

2024-04-15

The response structure of the API has changed

see changesets

Change item	Change content
Output Parameters	The response structure of the API has changed.

2023-08-21

The request parameters of the API has changed. The response structure of the API has changed

see changesets

Change item	Change content
Input Parameters	The request parameters of the API has changed.
	Added Input Parameters: DynamicSql
	Added Input Parameters: MergeDynamicSql
Output Parameters	The response structure of the API has changed.