Queries a slow SQL query.

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 DescribeDrdsSlowSqls

The operation that you want to perform. Set the value to DescribeDrdsSlowSqls.

DbName String Yes test_db

The name of the database.

DrdsInstanceId String Yes drds***************

The ID of the instance.

EndTime Long Yes 1568267711000

The start time of the SQL query. Specify the time in the UNIX timestamp format. The time must be in UTC. Unit: ms.

ExeTime Long Yes 1000

The SQL execution time. Unit: ms.

StartTime Long Yes 1568269711000

The end time of the SQL query. Specify the time in the UNIX timestamp format. The time must be in UTC. Unit: ms.

PageNumber Integer No 1

The page number.

PageSize Integer No 20

The number of entries to return on each page.

Response parameters

Parameter Type Example Description
Items Array of Item

The details of the slow SQL query.

Item
Host String 10.0.***. ***

The IP address of the execution machine.

ResponseTime Long 1568267711

The response time. Unit: ms.

Schema String user

The name of the database.

SendTime Long 1568267711

The time when the slow SQL query was sent. Unit: ms.

Sql String SELECT count(1) from payment_order where order_status = '08';

The content of the slow SQL query.

PageNumber Integer 1

The page number.

PageSize Integer 20

The number of entries returned per page.

RequestId String 509BDE17-505A-4B3B-854D-30D3F0******

The ID of the request.

Success Boolean true

Indicates whether the request is successful.

Total Integer 1

The total number of entries.

Examples

Sample requests

http(s)://drds.cn-hangzhou.aliyuncs.com/? Action=DescribeDrdsSlowSqls
&DbName=test_db
&DrdsInstanceId=drds***************
&EndTime=1568267711000
&ExeTime=1000
&StartTime=1568269711000
&<Common request parameters>

Sample success responses

XML format

<DescribeDrdsSlowSqlsReponse>
  <RequestId>509BDE17-505A-4B3B-854D-30D3F0******</RequestId>
  <PageSize>20</PageSize>
  <PageNumber>1</PageNumber>
  <Total>1</Total>
  <Items>
        <Item>
              <SendTime>1568267711</SendTime>
              <Schema>user</Schema>
              <ResponseTime>1568267711</ResponseTime>
              <Host>10.0. ***. ***</Host>
              <Sql>SELECT   count(1) from   payment_order where   order_status = '08';</Sql>
        </Item>
  </Items>
  <Success>true</Success>
</DescribeDrdsSlowSqlsReponse>

JSON format

{
    "DescribeDrdsSlowSqlsReponse": {
        "RequestId": "509BDE17-505A-4B3B-854D-30D3F0******",
        "PageSize": 20,
        "PageNumber": 1,
        "Total": 1,
        "Items": {
            "Item": {
                "SendTime": 1568267711,
                "Schema": "user",
                "ResponseTime": 1568267711,
                "Host": "10.0. ***. ***",
                "Sql": "SELECT   count(1) from   payment_order where   order_status = '08';"
            }
        },
        "Success": true
    }
}

Error codes

HttpCode Error code Error message Description
400 ActionUnauthorized The specified action is not available for you The error message returned because you are not authorized to perform this action. Perform Resource Access Management (RAM) authorization first.

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