DescribeSlowLogRecords - API Reference| Alibaba Cloud Documentation Center

This operation is applicable to replica set instances and sharded cluster instances, but not to standalone instances.
You can call this operation up to 30 times per minute. To call this operation at a higher frequency, use a Logstore. For more information, see Manage a Logstore.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters


Parameter	Type	Required	Example	Description
Action	String	Yes	DescribeSlowLogRecords	The operation that you want to perform. Set the value to DescribeSlowLogRecords.
StartTime	String	Yes	2019-02-24T12:10Z	The beginning of the time range to query. Specify the time in the yyyy-MM-ddTHH:mmZ format. The time must be in UTC.
EndTime	String	Yes	2019-02-24T13:10Z	The end of the time range to query. The end time must be later than the start time. Specify the time in the yyyy-MM-ddTHH:mmZ format. The time must be in UTC. Note The end time must be within 24 hours from the start time. Otherwise, the query fails.
DBInstanceId	String	Yes	dds-bpxxxxxxxx	The ID of the instance. Note If you specify this parameter to the ID of a sharded cluster instance, you must also specify the NodeId parameter.
NodeId	String	No	d-bpxxxxxxxx	The ID of the shard node. Note This parameter takes effect only when you specify the DBInstanceId parameter to the ID of a sharded cluster instance.
DBName	String	No	mongodbtest	The name of the database.
PageSize	Integer	No	30	The number of entries to return on each page. Valid values: 30 to 100.
PageNumber	Integer	No	1	The number of the page to return. The value must be an integer that is larger than 0. Default value: Default value: 1.
RegionId	String	No	cn-hangzhou	The region ID of the instance. You can call the DescribeDBInstanceAttribute operation to query the region ID of the instance.
OrderType	String	No	asc	The order of time in which the log entries to return are sorted. Valid values: asc: The log entries are sorted by time in ascending order. desc: The log entries are sorted by time in descending order.
ResourceGroupId	String	No	sg-bpxxxxxxxxxxxxxxxxxx	The ID of the resource group.

Response parameters


Parameter	Type	Example	Description
Engine	String	MongoDB	The database engine.
Items	Array of LogRecords		Details about the slow query logs.
LogRecords
AccountName	String	root	The user name of the database account that performs the operation.
DBName	String	mongodbtest	The name of the database.
DocsExamined	Long	1000000	The number of documents that are scanned during the operation.
ExecutionStartTime	String	2019-02-25T01:41:28Z	The start time of the operation. Specify the time in the yyyy-MM-ddTHH:mm:ssZ format. The time must be in UTC.
HostAddress	String	47.xxx.xxx.xx	The host IP address that is used to connect to the database.
KeysExamined	Long	0	The data entries that are scanned during indexing.
QueryTimes	String	600	The execution time of the statement. Unit: milliseconds.
ReturnRowCounts	Long	0	The number of returned rows.
SQLText	String	{\"op\":\"query\",\"ns\":\"mongodbtest.customer\",\"query\":{\"find\":\"customer\",\"filter\":{\"name\":\"jack\"}}}	The SQL statement that is executed during the slow operation.
TableName	String	C1	The name of the ApsaraDB for MongoDB collection.
PageNumber	Integer	1	The page number.
PageRecordCount	Integer	1	The number of slow query log entries on the page.
RequestId	String	414A4E5-4C36-4461-95FC-23757A20B5F8	The ID of the request.
TotalRecordCount	Integer	1	The total number of entries.

Examples

Sample requests

http(s)://mongodb.aliyuncs.com/? Action=DescribeSlowLogRecords
&StartTime=2019-02-24T12:10Z
&EndTime=2019-02-24T13:10Z
&DBInstanceId=dds-bpxxxxxxxx
&<Common request parameters>

Sample success responses

XML format

<DescribeSlowLogRecordsResponse>
	  <Items>
		    <LogRecords>
			      <ReturnRowCounts>0</ReturnRowCounts>
			      <KeysExamined>0</KeysExamined>
			      <HostAddress>47.xxx.xxx.xx</HostAddress>
			      <SQLText>{"op":"query","ns":"mongodbtest.customer","query":{"find":"customer","filter":{"name":"jack"}}}</SQLText>
			      <ExecutionStartTime>2019-02-25T01:41:28Z</ExecutionStartTime>
			      <AccountName>root</AccountName>
			      <QueryTimes>600</QueryTimes>
			      <DocsExamined>1000000</DocsExamined>
			      <DBName>mongodbtest</DBName>
		    </LogRecords>
	  </Items>
	  <PageNumber>1</PageNumber>
	  <TotalRecordCount>1</TotalRecordCount>
	  <RequestId>5414A4E5-4C36-4461-95FC-23757A20B5F8</RequestId>
	  <Engine>MongoDB</Engine>
	  <PageRecordCount>1</PageRecordCount>
</DescribeSlowLogRecordsResponse>

JSON format

{
	"Items": {
		"LogRecords": [
			{
				"ReturnRowCounts": 0,
				"KeysExamined": "0",
				"HostAddress": "47.110.74.177",
				"SQLText": "{\"op\":\"query\",\"ns\":\"mongodbtest.customer\",\"query\":{\"find\":\"customer\",\"filter\":{\"name\":\"ajackeyifeo1w\"}}}",
				"ExecutionStartTime": "2019-02-25T01:41:28Z",
				"AccountName": "root",
				"QueryTimes": 600,
				"DocsExamined": "1000000",
				"DBName": "mongodbtest"
			}
		]
	},
	"PageNumber": 1,
	"TotalRecordCount": 1,
	"RequestId": "5414A4E5-4C36-4461-95FC-23757A20B5F8",
	"Engine": "MongoDB",
	"PageRecordCount": 1
}

Error codes

For a list of error codes, visit the API Error Center.