You can call this operation to query entries in slow query logs of an ApsaraDB for MongoDB instance.

  • 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.