查询SQL日志运行报告 - - 阿里云

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

强悍的鸵鸟 · 北川景子新片上映自评性格腹黑引吐槽【2】- ...· 2 周前 ·

爱逃课的墨镜 · NuGet Gallery ...· 1 月前 ·

没有腹肌的电影票 · Supervised Learning ...· 2 月前 ·

很酷的蚂蚁 · Python 3.8 安装详解 | ...· 2 月前 ·

豪气的炒饭 · 杭州云鲤悦酒店(未来科技城店)预订价格,联系 ...· 7 月前 ·

http(s)://rds.aliyuncs.com/?Action=DescribeSQLLogReports
&DBInstanceId=rm-uf6wjk5xxxxxxx
&EndTime=2021-03-18T16:00:00Z
&StartTime=2021-03-13T16:00:00Z
&<公共请求参数>

正常返回示例

XML 格式

HTTP/1.1 200 OK
Content-Type:application/xml
<DescribeSQLLogReportsResponse>
    <TotalRecordCount>60</TotalRecordCount>
    <PageRecordCount>30</PageRecordCount>
    <RequestId>08A3B71B-FE08-4B03-974F-CC7EA6DB1828	</RequestId>
    <PageNumber>1</PageNumber>
    <Items>
            <ReportTime>2019-03-27T16:00:00Z</ReportTime>
            <LatencyTopNItems>
                <LatencyTopNItem>
                    <AvgLatency>500</AvgLatency>
                    <SQLExecuteTimes>5</SQLExecuteTimes>
                    <SQLText>SELECT * FROM table_name;</SQLText>
                </LatencyTopNItem>
            </LatencyTopNItems>
            <QPSTopNItems>
                <QPSTopNItem>
                    <SQLExecuteTimes>5</SQLExecuteTimes>
                    <SQLText>SELECT * FROM table_name;</SQLText>
                </QPSTopNItem>
            </QPSTopNItems>
        </Item>
    </Items>
</DescribeSQLLogReportsResponse>

JSON 格式

HTTP/1.1 200 OK
Content-Type:application/json
  "TotalRecordCount" : "60",
  "PageRecordCount" : "30",
  "RequestId" : "08A3B71B-FE08-4B03-974F-CC7EA6DB1828\t",
  "PageNumber" : "1",
  "Items" : {
    "Item" : [ {
      "ReportTime" : "2019-03-27T16:00:00Z",
      "LatencyTopNItems" : {
        "LatencyTopNItem" : [ {
          "AvgLatency" : "500",
          "SQLExecuteTimes" : "5",
          "SQLText" : "SELECT * FROM table_name;"
      "QPSTopNItems" : {
        "QPSTopNItem" : [ {
          "SQLExecuteTimes" : "5",
          "SQLText" : "SELECT * FROM table_name;"
                  访问错误中心查看更多错误码。