DescribeSlowLogRecords - Database Autonomy Service - Alibaba Cloud Documentation Center

Queries the slow log records of a database instance. You can filter and sort the records based on various conditions.

Operation description

The InstanceId parameter is required. This parameter specifies the ID of the instance.
The StartTime and EndTime parameters are required. These parameters specify the time range for the query.
You can set the PageNumber and PageSize parameters to paginate the results.
You can use the OrderBy parameter to sort the results. For more information about the sortable fields, see the documentation.
You can use the Filters parameter to refine the query conditions, such as filtering by host address or SQL ID.
Important Some database types, such as RDS for PostgreSQL and PolarDB for PostgreSQL, do not support specific sorting methods. Select appropriate parameters based on your database type.

Try it now

Try this API in OpenAPI Explorer, no manual signing needed. Successful calls auto-generate SDK code matching your parameters. Download it with built-in credential security for local usage.

Test

RAM authorization

The table below describes the authorization required to call this API. You can define it in a Resource Access Management (RAM) policy. The table's columns are detailed below:

Action: The actions can be used in the Action element of RAM permission policy statements to grant permissions to perform the operation.
API: The API that you can call to perform the action.
Access level: The predefined level of access granted for each API. Valid values: create, list, get, update, and delete.
Resource type: The type of the resource that supports authorization to perform the action. It indicates if the action supports resource-level permission. The specified resource must be compatible with the action. Otherwise, the policy will be ineffective.
- For APIs with resource-level permissions, required resource types are marked with an asterisk (*). Specify the corresponding Alibaba Cloud Resource Name (ARN) in the Resource element of the policy.
- For APIs without resource-level permissions, it is shown as All Resources. Use an asterisk (*) in the Resource element of the policy.
Condition key: The condition keys defined by the service. The key allows for granular control, applying to either actions alone or actions associated with specific resources. In addition to service-specific condition keys, Alibaba Cloud provides a set of common condition keys applicable across all RAM-supported services.
Dependent action: The dependent actions required to run the action. To complete the action, the RAM user or the RAM role must have the permissions to perform all dependent actions.

Action

Access level

Resource type

Condition key

Dependent action

hdm:DescribeSlowLogRecords

get

*All Resource

*

None

Request parameters

Parameter	Type	Required	Description	Example
InstanceId	string	Yes	The instance ID.	rm-8vbk4xz99su8****
NodeId	string	No	The node ID.	pi-d9j9fe7wq7t9i****
StartTime	integer	Yes	The beginning of the time range to query. This is a UNIX timestamp in milliseconds.	1596177993000
EndTime	integer	Yes	The end of the time range to query. This is a UNIX timestamp in milliseconds.	1634972640000
PageNumber	integer	No	The page number. Pages start from 1.	1
PageSize	integer	No	The number of entries per page.	10
Filters	array<object>	No	The list of filter conditions.
	object	No	The list of filter conditions.
Key	string	No	The filter key. Note For more information, see the Supported parameters for Key section.	None
Value	string	No	The value for the filter key.	None
OrderBy	string	No	MySQL QueryTimeSeconds: The query execution time in seconds. LockTimeSeconds: The lock duration in seconds. RowsSent: The number of rows sent. RowsExamined: The number of rows scanned. Redis QueryTime: The query execution time. Timestamp: The time when the query execution ended. MongoDB QueryTime: The query execution time. Timestamp: The time when the query execution ended. KeysExamined: The number of index entries scanned. DocExamined: The number of documents scanned. ReturnNum: The number of rows returned. Important Sorting is not supported for RDS for PostgreSQL, PolarDB for PostgreSQL, and RDS for SQL Server.	QueryTimeSeconds
Asc	boolean	No	Specifies whether to sort the results in ascending order. The default value is true. true: The results are sorted in ascending order. false: The results are sorted in descending order.	true

The following values are supported for the Key parameter:

RDS for MySQL, PolarDB for MySQL, RDS for PostgreSQL, and PolarDB for PostgreSQL
- hostAddress: The source IP address. Separate multiple values with commas.
- sqlId: The SQL ID. Separate multiple values with commas.
- user: The user. Separate multiple values with commas.
- dbName: The database name. Separate multiple values with commas.
- tags: The tags. Separate multiple values with commas.
MongoDB
- hostInsId: The role ID. Separate multiple values with commas.
- insRole: The instance role. Separate multiple values with commas.
- opType: The operation type. Separate multiple values with commas.
- namespace: The namespace. Separate multiple values with commas.
- nodeType: The component type. Separate multiple values with commas.
- queryId: The query ID. Separate multiple values with commas.
Tair
- hostAddress: The source IP address.
- user: The user.
- dbName: The database name.
- nodeType: The node type.
RDS for SQL Server
- hostAddress: The source IP address. Separate multiple values with commas.
- sqlId: The SQL ID. Separate multiple values with commas.
- user: The user. Separate multiple values with commas.
- dbName: The database name. Separate multiple values with commas.
- tags: The tags. Separate multiple values with commas.
PolarDB-X
- traceId: The trace ID of the instance.
- role: The role of the node. This key is required. Valid values: CN (compute node) and DN (data node).
- hostAddress: The source IP address. Separate multiple values with commas.
- sqlId: The SQL ID. Separate multiple values with commas.
- user: The user. Separate multiple values with commas.
- dbName: The database name. Separate multiple values with commas.
- tags: The tags. Separate multiple values with commas.

Note

For SQL engines, you can query data by sqlId. You can specify up to 20 sqlId values, separated by commas.
For MongoDB, you can query data by queryId. You can specify up to 20 queryId values, separated by commas.

Response elements

Element	Type	Description	Example
	object
Code	string	The HTTP status code.	200
Message	string	The returned message. Note If the request is successful, Successful is returned. If the request fails, an error message is returned, such as an error code.	Successful
RequestId	string	The request ID.	A1C79EE2-D04D-571B-8C60-961FAF8E****
Success	string	Indicates whether the request was successful. true: The request was successful. false: The request failed.	true
Data	object	A list of slow query log records.
DbInstanceName	string	The instance ID.	rm-bp157g54vy772****
NodeId	string	The node ID.	node123
ItemsNumbers	integer	The number of slow log records on the current page.	10
StartTime	string	The start time of the query.	1672531200000
EndTime	string	The end time of the query.	1672617600000
DbInstanceId	integer	The numerical ID of the instance.	100
TotalRecords	integer	The total number of slow log records.	100
PageNumbers	integer	The page number. Pages start from 1. The default value is 1.	1
MaxRecordsPerPage	integer	The maximum number of entries per page. Valid values: 5 to 100.	20
Logs	array<object>	The data returned by the query.
	array<object>	The data returned.
SqlId	string	The SQL template ID.	sqlId
Scheme	string	The data schema.	HTTPS
SubInstanceId	string	The sub-instance ID.	r-8vb219d10038****
DbInstanceName	string	The instance ID.	rm-2zebg30mk056g****
InsName	string	The instance name.	test
AccountName	string	The username.	user1
HostAddress	string	The source IP address.	192.168.1.1
QueryStartTime	string	The start time of the query. The time is in the `yyyy-MM-dd hh:mm:ss` format and is in UTC.	2024-04-01 11:00:00
SQLText	string	The SQL statement.	SELECT * FROM my_table WHERE ROWNUM <= 10
Psql	string	The SQL template.	SELECT * FROM my_table WHERE ROWNUM <= 10
DBName	string	The database name.	test
QueryTime	integer	The query execution time.	121
ReturnItemNumbers	string	The number of returned items.	test
DocsExamined	string	The number of documents scanned during the operation. This parameter is returned only for MongoDB instances.	100
KeysExamined	string	The number of index entries scanned. This parameter is returned only for MongoDB instances.	valueA
TableName	string	The table name.	tableNameExample
LockTime	number	The lock wait time.	100
RowsExamined	integer	The number of rows scanned.	100
RowsSent	integer	The number of rows returned.	10
ThreadId	string	The thread ID.	57472578
Timestamp	integer	The UNIX timestamp.	1747118812
SqlTag	object	The tags.
SqlId	string	The SQL ID.	8ad7069f236bcdaaa9b3ae4b6299****
Tags	string	The tags. Multiple tags are separated by commas.	DAS_IMPORTANT,DAS_IN_PLAN
Comments	string	The comments.	test
LockTimeSeconds	number	The lock wait time in seconds.	100
QueryTimeSeconds	number	The query execution time in seconds.	100
SqlType	string	The type of the SQL statement. SELECT UPDATE DELETE	SELECT
CPUTime	number	The CPU time consumed by the query. Note This parameter is returned only for RDS for SQL Server instances.	50
IOWrites	integer	The number of I/O writes. Note This parameter is returned only for RDS for SQL Server instances.	1
LastRowsCountAffected	integer	The number of rows affected by the last statement. Note This parameter is returned only for RDS for SQL Server instances.	10
LogicalIOReads	integer	The number of logical reads. Note This parameter is returned only for RDS for SQL Server instances.	1
PhysicalIOReads	integer	The number of physical reads. Note This parameter is returned only for RDS for SQL Server instances.	1
RowsCountAffected	integer	The number of affected rows. Note This parameter is returned only for RDS for SQL Server instances.	10
Command	string	The slow query statement. Note This parameter is returned only for Tair instances.	SELECT
Namespace	string	The namespace. Note This parameter is returned only for MongoDB instances.	pro-test
QueryId	string	The query ID. Note This parameter is returned only for MongoDB instances.	sq-1pzcdMwRb
ReturnNum	string	The number of rows returned. Note This parameter is returned only for MongoDB instances.	20
ApplicationName	string	The application name. Note This parameter is returned only for RDS for SQL Server instances.	MyApp
CPUTimeSeconds	number	The CPU time consumed by the query, in seconds. Note This parameter is returned only for RDS for SQL Server instances.	100
Rows	integer	The total number of rows updated or returned by the compute node of a PolarDB-X 2.0 instance. Note This parameter is returned only for PolarDB-X 2.0 instances.	20
Frows	integer	The number of rows pulled by the compute node (CN) of a PolarDB-X 2.0 instance. Note This parameter is returned only for PolarDB-X 2.0 instances.	10
Scnt	integer	The number of requests sent from the compute node (CN) to data nodes (DNs) in a PolarDB-X 2.0 instance. Note This parameter is returned only for PolarDB-X 2.0 instances.	10
TraceId	string	The trace ID of a PolarDB-X 2.0 instance. The trace ID is the execution ID of the SQL statement on a data node. Note This parameter is returned only for PolarDB-X 2.0 instances.	074ce334-5247-40b9-b0c1-158aea5d****
TemplateId	string	The template ID of a PolarDB-X 2.0 instance. Note This parameter is returned only for PolarDB-X 2.0 instances.	6a63b6ac4572abfaef7d1163f684****
NodeId	string
Cmd	string
Rt	integer
RequestSize	integer
ResponseSize	integer
ClientIp	string
DbId	string
OriginTime	string
OpType	string

Examples

Success response

JSON format

{
  "Code": "200",
  "Message": "Successful",
  "RequestId": "A1C79EE2-D04D-571B-8C60-961FAF8E****",
  "Success": "true",
  "Data": {
    "DbInstanceName": "rm-bp157g54vy772****",
    "NodeId": "node123",
    "ItemsNumbers": 10,
    "StartTime": "1672531200000",
    "EndTime": "1672617600000",
    "DbInstanceId": 100,
    "TotalRecords": 100,
    "PageNumbers": 1,
    "MaxRecordsPerPage": 20,
    "Logs": [
      {
        "SqlId": "sqlId",
        "Scheme": "HTTPS",
        "SubInstanceId": "r-8vb219d10038****",
        "DbInstanceName": "rm-2zebg30mk056g****",
        "InsName": "test",
        "AccountName": "user1",
        "HostAddress": "192.168.1.1",
        "QueryStartTime": "2024-04-01 11:00:00",
        "SQLText": "SELECT * FROM my_table WHERE ROWNUM <= 10",
        "Psql": "SELECT * FROM my_table WHERE ROWNUM <= 10\n",
        "DBName": "test",
        "QueryTime": 121,
        "ReturnItemNumbers": "test",
        "DocsExamined": "100",
        "KeysExamined": "valueA",
        "TableName": "tableNameExample",
        "LockTime": 100,
        "RowsExamined": 100,
        "RowsSent": 10,
        "ThreadId": "57472578",
        "Timestamp": 1747118812,
        "SqlTag": {
          "SqlId": "8ad7069f236bcdaaa9b3ae4b6299****",
          "Tags": "DAS_IMPORTANT,DAS_IN_PLAN",
          "Comments": "test"
        },
        "LockTimeSeconds": 100,
        "QueryTimeSeconds": 100,
        "SqlType": "SELECT",
        "CPUTime": 50,
        "IOWrites": 1,
        "LastRowsCountAffected": 10,
        "LogicalIOReads": 1,
        "PhysicalIOReads": 1,
        "RowsCountAffected": 10,
        "Command": "SELECT",
        "Namespace": "pro-test",
        "QueryId": "sq-1pzcdMwRb",
        "ReturnNum": "20",
        "ApplicationName": "MyApp",
        "CPUTimeSeconds": 100,
        "Rows": 20,
        "Frows": 10,
        "Scnt": 10,
        "TraceId": "074ce334-5247-40b9-b0c1-158aea5d****",
        "TemplateId": "6a63b6ac4572abfaef7d1163f684****",
        "NodeId": "",
        "Cmd": "",
        "Rt": 0,
        "RequestSize": 0,
        "ResponseSize": 0,
        "ClientIp": "",
        "DbId": "",
        "OriginTime": "",
        "OpType": ""
      }
    ]
  }
}

Error codes

HTTP status code	Error code	Error message	Description
400	InvalidParams	The request parameters are invalid.
403	NoPermission	You are not authorized to do this action.

See Error Codes for a complete list.

Release notes

See Release Notes for a complete list.