:GetQueryOptimizeDataStats

• If you use an Alibaba Cloud SDK, make sure that the aliyun-sdk-core version is later than V2.1.8. We recommend that you use the latest version.
• The version of your Database Autonomy Service (DAS) SDK must be V2.1.8 or later.
• If you use an SDK to call API operations of DAS, you must set the region ID to cn-shanghai.
• This operation supports the following database engines:
  • ApsaraDB RDS for MySQL
  • PolarDB for MySQL
  • ApsaraDB RDS for PostgreSQL

Request parameters

Response parameters

Examples

Sample requests

http(s)://das.cn-shanghai.aliyuncs.com/?Action=GetQueryOptimizeDataStats
&Engine=MySQL
&InstanceIds=rm-2ze8g2am97624****
&TagNames=None
&Keywords=select update
&LogicalOperator=or
&Rules=DAS_NOT_IMPORTANT
&DbNames=testdb01
&Time=1642953600000
&PageSize=10
&PageNo=1
&OrderBy=count
&Asc=true
&OnlyOptimizedSql=false
&SqlIds=2e8147b5ca2dfc640dfd5e43d96a****
&Region=cn-china
&User=testUser
&Common request parameters

Sample success responses

XML format

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

<GetQueryOptimizeDataStatsResponse>
    <Code>200</Code>
    <Message>Successful</Message>
    <Data>
        <Total>10</Total>
        <Extra>None</Extra>
        <List>
            <InstanceId>rm-2ze8g2am97624****</InstanceId>
            <Dbname>testdb01</Dbname>
            <SqlId>2e8147b5ca2dfc640dfd5e43d96a****</SqlId>
            <SqlType>INSERT</SqlType>
            <Psql>select 1</Psql>
            <SqlSample>select 2</SqlSample>
            <Count>100</Count>
            <MaxQueryTime>1.1</MaxQueryTime>
            <AvgQueryTime>1.1</AvgQueryTime>
            <MaxLockTime>0.1</MaxLockTime>
            <AvgLockTime>0.1</AvgLockTime>
            <MaxRowsExamined>100000</MaxRowsExamined>
            <AvgRowsExamined>100.1</AvgRowsExamined>
            <MaxRowsSent>10000</MaxRowsSent>
            <AvgRowsSent>100.1</AvgRowsSent>
            <MaxRowsAffected>10000</MaxRowsAffected>
            <AvgRowsAffected>100.1</AvgRowsAffected>
            <RuleList>
                <Name>DAS_NOT_IMPORTANT</Name>
                <Type>Predefined</Type>
            </RuleList>
        </List>
    </Data>
    <RequestId>B6D17591-B48B-4D31-9CD6-9B9796B2****</RequestId>
    <Success>true</Success>
</GetQueryOptimizeDataStatsResponse>

JSON format

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

{
  "Code" : "200",
  "Message" : "Successful",
  "Data" : {
    "Total" : 10,
    "Extra" : "None",
    "List" : [ {
      "InstanceId" : "rm-2ze8g2am97624****",
      "Dbname" : "testdb01",
      "SqlId" : "2e8147b5ca2dfc640dfd5e43d96a****",
      "SqlType" : "INSERT",
      "Psql" : "select 1",
      "SqlSample" : "select 2",
      "Count" : 100,
      "MaxQueryTime" : 1.1,
      "AvgQueryTime" : 1.1,
      "MaxLockTime" : 0.1,
      "AvgLockTime" : 0.1,
      "MaxRowsExamined" : 100000,
      "AvgRowsExamined" : 100.1,
      "MaxRowsSent" : 10000,
      "AvgRowsSent" : 100.1,
      "MaxRowsAffected" : 10000,
      "AvgRowsAffected" : 100.1,
      "RuleList" : [ {
        "Name" : "DAS_NOT_IMPORTANT",
        "Type" : "Predefined"
      } ]
    } ]
  },
  "RequestId" : "B6D17591-B48B-4D31-9CD6-9B9796B2****",
  "Success" : "true"
}

Error codes

For a list of error codes, see Service error codes.