：GetFullRequestOriginStatByInstanceId

The SQL Explorer feature allows you to check the health status of SQL statements and troubleshoot performance issues. For more information, see SQL Explorer.

• For information about database instances that support SQL Explorer, see Usage notes on DAS Professional Edition.
• If you use an SDK to call Database Autonomy Service (DAS), you must set the region to cn-shanghai.

Request parameters

Response parameters

Examples

Sample requests

http(s)://das.cn-shanghai.aliyuncs.com/?Action=GetFullRequestOriginStatByInstanceId
&UserId=196278346919****
&InstanceId=rm-2ze8g2am97624****
&Start=1644716649000
&End=1644803409000
&OrderBy=count
&PageNo=1
&PageSize=20
&SqlType=SELECT
&<Common request parameters>

Sample success responses

XML format

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

<GetFullRequestOriginStatByInstanceIdResponse>
    <Message>Successful</Message>
    <RequestId>7172BECE-588A-5961-8126-C216E16B****</RequestId>
    <Data>
        <List>
            <Key>172.26.6****</Key>
            <AvgFetchRows>0</AvgFetchRows>
            <AvgLockWaitTime>0.00009589874265269765</AvgLockWaitTime>
            <AvgLogicalRead>654.4470327860251</AvgLogicalRead>
            <AvgPhysicalAsyncRead>0</AvgPhysicalAsyncRead>
            <AvgPhysicalSyncRead>0</AvgPhysicalSyncRead>
            <AvgRows>0</AvgRows>
            <AvgExaminedRows>10000</AvgExaminedRows>
            <AvgReturnedRows>10000</AvgReturnedRows>
            <AvgUpdatedRows>10000</AvgUpdatedRows>
            <AvgRt>2.499</AvgRt>
            <AvgSqlCount>10000</AvgSqlCount>
            <Count>100000</Count>
            <CountRate>0.0586</CountRate>
            <Database>dbtest01</Database>
            <ErrorCount>1</ErrorCount>
            <FetchRows>200</FetchRows>
            <Ip>rm-uf6dyi58dm6****.mysql.rds.aliy****.com</Ip>
            <LockWaitTime>1089.4177720290281</LockWaitTime>
            <OriginHost>172.26.6****</OriginHost>
            <PhysicalAsyncRead>0</PhysicalAsyncRead>
            <PhysicalSyncRead>0</PhysicalSyncRead>
            <Port>3306</Port>
            <Rows>0</Rows>
            <ExaminedRows>10000</ExaminedRows>
            <RtGreaterThanOneSecondCount>2</RtGreaterThanOneSecondCount>
            <RtRate>0.1384</RtRate>
            <SqlCount>200</SqlCount>
            <SumUpdatedRows>200</SumUpdatedRows>
            <Version>1</Version>
            <VpcId>vpc-2zentqj1sk4qmolci****</VpcId>
        </List>
        <Total>1</Total>
    </Data>
    <Code>200</Code>
    <Success>true</Success>
</GetFullRequestOriginStatByInstanceIdResponse>

JSON format

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

{
  "Message" : "Successful",
  "RequestId" : "7172BECE-588A-5961-8126-C216E16B****",
  "Data" : {
    "List" : [ {
      "Key" : "172.26.6****",
      "AvgFetchRows" : 0,
      "AvgLockWaitTime" : 9.589874265269765E-5,
      "AvgLogicalRead" : 654.4470327860251,
      "AvgPhysicalAsyncRead" : 0,
      "AvgPhysicalSyncRead" : 0,
      "AvgRows" : 0,
      "AvgExaminedRows" : 10000,
      "AvgReturnedRows" : 10000,
      "AvgUpdatedRows" : 10000,
      "AvgRt" : 2.499,
      "AvgSqlCount" : 10000,
      "Count" : 100000,
      "CountRate" : 0.0586,
      "Database" : "dbtest01",
      "ErrorCount" : 1,
      "FetchRows" : 200,
      "Ip" : "rm-uf6dyi58dm6****.mysql.rds.aliy****.com",
      "LockWaitTime" : 1089.4177720290281,
      "OriginHost" : "172.26.6****",
      "PhysicalAsyncRead" : 0,
      "PhysicalSyncRead" : 0,
      "Port" : 3306,
      "Rows" : 0,
      "ExaminedRows" : 10000,
      "RtGreaterThanOneSecondCount" : 2,
      "RtRate" : 0.1384,
      "SqlCount" : 200,
      "SumUpdatedRows" : 200,
      "Version" : 1,
      "VpcId" : "vpc-2zentqj1sk4qmolci****"
    } ],
    "Total" : 1
  },
  "Code" : 200,
  "Success" : true
}

Error codes

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