DescribeSlowLogRecords

• This operation is applicable to replica set instances and sharded cluster 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.
• If the instance is purchased after June 6, 2021 and you want to view its slow query logs, you must enable the audit logs feature and select the admin and slow operation types that you want to audit. You can only view slow query logs that are generated after the audit logs feature is enabled.
  Note

  • You can call the ModifyAuditPolicy operation to enable or disable the audit logs feature.
  • You can call the ModifyAuditLogFilter operation to set the operation types that you want to audit.

Request parameters

Response parameters

Examples

Sample requests

http(s)://mongodb.aliyuncs.com/?Action=DescribeSlowLogRecords
&DBInstanceId=dds-bp1fc7e65108****
&NodeId=d-bp18b06ebc21****
&StartTime=2019-02-24T 12:10:10Z
&EndTime=2019-02-24T 13:10:10Z
&DBName=mongodbtest
&PageSize=30
&PageNumber=1
&OrderType=asc
&ResourceGroupId=rg-acfmyiu4ekp****
&<Common request parameters>

Sample success responses

XML format

HTTP/1.1 200 OK
Content-Type:application/xml

<DescribeSlowLogRecordsResponse>
    <TotalRecordCount>1</TotalRecordCount>
    <PageRecordCount>1</PageRecordCount>
    <RequestId>414A4E5-4C36-4461-95FC-23757A20****</RequestId>
    <PageNumber>1</PageNumber>
    <Items>
        <ExecutionStartTime>2019-02-25T 01:41:28Z</ExecutionStartTime>
        <HostAddress>192.168.XX.XX</HostAddress>
        <QueryTimes>600</QueryTimes>
        <TableName>C1</TableName>
        <SQLText>{\"op\":\"query\",\"ns\":\"mongodbtest.customer\",\"query\":{\"find\":\"customer\",\"filter\":{\"name\":\"jack\"}}}</SQLText>
        <ReturnRowCounts>0</ReturnRowCounts>
        <KeysExamined>0</KeysExamined>
        <DBName>mongodbtest</DBName>
        <DocsExamined>1000000</DocsExamined>
        <AccountName>root</AccountName>
    </Items>
    <Engine>MongoDB</Engine>
</DescribeSlowLogRecordsResponse>

JSON format

HTTP/1.1 200 OK
Content-Type:application/json

{
  "TotalRecordCount" : 1,
  "PageRecordCount" : 1,
  "RequestId" : "414A4E5-4C36-4461-95FC-23757A20****",
  "PageNumber" : 1,
  "Items" : [ {
    "ExecutionStartTime" : "2019-02-25T 01:41:28Z",
    "HostAddress" : "192.168.XX.XX",
    "QueryTimes" : "600",
    "TableName" : "C1",
    "SQLText" : "{\\\"op\\\":\\\"query\\\",\\\"ns\\\":\\\"mongodbtest.customer\\\",\\\"query\\\":{\\\"find\\\":\\\"customer\\\",\\\"filter\\\":{\\\"name\\\":\\\"jack\\\"}}}",
    "ReturnRowCounts" : 0,
    "KeysExamined" : 0,
    "DBName" : "mongodbtest",
    "DocsExamined" : 1000000,
    "AccountName" : "root"
  } ],
  "Engine" : "MongoDB"
}

Error codes

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