:Interroger le résumé des journaux de requêtes lentes

http(s)://rds.aliyuncs.com/?Action=DescribeSlowLogs
&DBInstanceId=rm-uf6wjk5xxxxxxx
&StartTime=2011-05-01Z
&EndTime=2011-05-30Z
&<Common request parameters>

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

<DescribeSlowLogsResponse>
    <EndTime>2011-05-30Z</EndTime>
    <StartTime>2011-05-30Z</StartTime>
    <RequestId>2553A660-E4EB-4AF4-A402-8AFF70A49143</RequestId>
    <PageRecordCount>10</PageRecordCount>
    <TotalRecordCount>5</TotalRecordCount>
    <DBInstanceId>rm-uf6wjk5xxxxxxx</DBInstanceId>
    <PageNumber>1</PageNumber>
    <Engine>MySQL</Engine>
    <Items>
        <MaxLastRowsAffectedCounts>0</MaxLastRowsAffectedCounts>
        <ReturnMaxRowCount>1</ReturnMaxRowCount>
        <SQLText>select id,name from tb_table</SQLText>
        <SQLServerMaxCpuTime>0</SQLServerMaxCpuTime>
        <CreateTime>2011-05-30Z</CreateTime>
        <AvgLastRowsAffectedCounts>0</AvgLastRowsAffectedCounts>
        <MinLastRowsAffectedCounts>0</MinLastRowsAffectedCounts>
        <ParseTotalRowCounts>1</ParseTotalRowCounts>
        <TotalLockTimes>0</TotalLockTimes>
        <MySQLTotalExecutionCounts>1</MySQLTotalExecutionCounts>
        <SQLServerMinCpuTime>0</SQLServerMinCpuTime>
        <SQLHASH>U2FsdGVkxxxx</SQLHASH>
        <MinIOWriteCounts>0</MinIOWriteCounts>
        <ParseMaxRowCount>1</ParseMaxRowCount>
        <MaxLogicalReadCounts>0</MaxLogicalReadCounts>
        <MySQLTotalExecutionTimes>1</MySQLTotalExecutionTimes>
        <SQLServerTotalExecutionCounts>1</SQLServerTotalExecutionCounts>
        <ReturnTotalRowCounts>1</ReturnTotalRowCounts>
        <MaxLockTime>0</MaxLockTime>
        <DBName>RDS_MySQL</DBName>
        <MinRowsAffectedCounts>0</MinRowsAffectedCounts>
        <TotalLogicalReadCounts>1</TotalLogicalReadCounts>
        <TotalPhysicalReadCounts>1</TotalPhysicalReadCounts>
        <ReportTime>2011-05-30Z</ReportTime>
        <MaxPhysicalReadCounts>0</MaxPhysicalReadCounts>
        <SQLServerTotalCpuTime>0</SQLServerTotalCpuTime>
        <TotalIOWriteCounts>0</TotalIOWriteCounts>
        <MaxRowsAffectedCounts>0</MaxRowsAffectedCounts>
        <AvgIOWriteCounts>0</AvgIOWriteCounts>
        <MinPhysicalReadCounts>0</MinPhysicalReadCounts>
        <SlowLogId>26584213</SlowLogId>
        <MaxExecutionTime>60</MaxExecutionTime>
        <AvgExecutionTime>1</AvgExecutionTime>
        <SQLServerAvgExecutionTime>0</SQLServerAvgExecutionTime>
        <MaxIOWriteCounts>0</MaxIOWriteCounts>
        <SQLServerAvgCpuTime>0</SQLServerAvgCpuTime>
        <TotalLastRowsAffectedCounts>0</TotalLastRowsAffectedCounts>
        <AvgLogicalReadCounts>0</AvgLogicalReadCounts>
        <SQLServerMinExecutionTime>0</SQLServerMinExecutionTime>
        <SQLIdStr>521584</SQLIdStr>
        <SQLServerTotalExecutionTimes>1000</SQLServerTotalExecutionTimes>
        <AvgRowsAffectedCounts>0</AvgRowsAffectedCounts>
        <TotalRowsAffectedCounts>0</TotalRowsAffectedCounts>
        <AvgPhysicalReadCounts>0</AvgPhysicalReadCounts>
        <MinLogicalReadCounts>0</MinLogicalReadCounts>
    </Items>
</DescribeSlowLogsResponse>

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

{
  "EndTime" : "2011-05-30Z",
  "StartTime" : "2011-05-30Z",
  "RequestId" : "2553A660-E4EB-4AF4-A402-8AFF70A49143",
  "PageRecordCount" : 10,
  "TotalRecordCount" : 5,
  "DBInstanceId" : "rm-uf6wjk5xxxxxxx",
  "PageNumber" : 1,
  "Engine" : "MySQL",
  "Items" : [ {
    "MaxLastRowsAffectedCounts" : 0,
    "ReturnMaxRowCount" : 1,
    "SQLText" : "select id,name from tb_table",
    "SQLServerMaxCpuTime" : 0,
    "CreateTime" : "2011-05-30Z",
    "AvgLastRowsAffectedCounts" : 0,
    "MinLastRowsAffectedCounts" : 0,
    "ParseTotalRowCounts" : 1,
    "TotalLockTimes" : 0,
    "MySQLTotalExecutionCounts" : 1,
    "SQLServerMinCpuTime" : 0,
    "SQLHASH" : "U2FsdGVkxxxx",
    "MinIOWriteCounts" : 0,
    "ParseMaxRowCount" : 1,
    "MaxLogicalReadCounts" : 0,
    "MySQLTotalExecutionTimes" : 1,
    "SQLServerTotalExecutionCounts" : 1,
    "ReturnTotalRowCounts" : 1,
    "MaxLockTime" : 0,
    "DBName" : "RDS_MySQL",
    "MinRowsAffectedCounts" : 0,
    "TotalLogicalReadCounts" : 1,
    "TotalPhysicalReadCounts" : 1,
    "ReportTime" : "2011-05-30Z",
    "MaxPhysicalReadCounts" : 0,
    "SQLServerTotalCpuTime" : 0,
    "TotalIOWriteCounts" : 0,
    "MaxRowsAffectedCounts" : 0,
    "AvgIOWriteCounts" : 0,
    "MinPhysicalReadCounts" : 0,
    "SlowLogId" : 26584213,
    "MaxExecutionTime" : 60,
    "AvgExecutionTime" : 1,
    "SQLServerAvgExecutionTime" : 0,
    "MaxIOWriteCounts" : 0,
    "SQLServerAvgCpuTime" : 0,
    "TotalLastRowsAffectedCounts" : 0,
    "AvgLogicalReadCounts" : 0,
    "SQLServerMinExecutionTime" : 0,
    "SQLIdStr" : "521584",
    "SQLServerTotalExecutionTimes" : 1000,
    "AvgRowsAffectedCounts" : 0,
    "TotalRowsAffectedCounts" : 0,
    "AvgPhysicalReadCounts" : 0,
    "MinLogicalReadCounts" : 0
  } ]
}