ListSlowQueryAdviceApi--数据库工作台-火山引擎

文档中心

立即注册

导航

ListSlowQueryAdviceApi

最近更新时间：2025.06.26 19:14:48首次发布时间：2025.06.26 19:14:48

调用 ListSlowQueryAdviceApi 接口获取慢日志诊断详情信息。

请求类型

同步请求。

请求参数

参数	类型	是否必选	示例值	描述
Action	String	是	ListSlowQueryAdviceApi	本次请求的目的，取值为 `ListSlowQueryAdviceApi`。
Version	String	是	2018-01-01	API 的版本号，取值为`2018-01-01`。
InstanceType	String	是	LA8L	数据库类型，取值如下： `MySQL`：表示云数据库 MySQL 版实例。 `VeDBMySQL`：表示云数据库 veDB MySQL 版实例。
InstanceId	String	是	vRVvTs0	实例 ID。说明您可以调用 DescribeDBInstances 接口查询 MySQL 的实例 ID。调用 DescribeDBInstances 接口查询 veDB MySQL 的实例 ID。
AdviceType	String	是	YQ8eQrEz	建议类型，取值如下：
:::	`no_advice`：无建议。 `index_advice`：索引建议。 `rewrite_sql_advice`：改写 SQL 建议。
SummaryId	String	是	3FR9M8VJ	每次慢日志诊断的唯一标识。
GroupBy	String	是	C1Tze2zO1LH	聚合类型，取值如下： `Advice` ：按建议聚合。 `Module`：按模块聚合。
OrderBy	String	是	fZTELKr51	排序类型，取值如下： `QueryTimeRatioNow`：按当前查询时间占比排序。 `Benefit` : 按收益排序。
PageNumber	Integer	是	1	页码，默认值为 1。
PageSize	Integer	是	10	每页记录数，取值范围1～100，默认值为 10。

返回参数

参数	类型	示例值	描述
Total	Integer	923	慢日志诊断建议总数
AdvicesByGroup	Array of Object	Array of AdvicesByGroup Object	按建议聚合的诊断建议。如果请求参数中 `GroupBy` 取值为 `Advice`，返回参数是 `AdvicesByGroup`。
Advices	Array of Object	Array of Advices Object	按模块聚合的诊断建议。如果请求参数中聚合类型是 `Module`，返回参数是 `Advices`。

请求示例

POST /?Action=ListSlowQueryAdviceApi&Version=2018-01-01 HTTP/1.1
Host: /
Content-Type: application/json; charset=UTF-8
X-Date: 20250626T033530Z
X-Content-Sha256: 287e874e******d653b44d21e
Authorization: HMAC-SHA256 Credential=Adfks******wekfwe/20250626/cn-beijing/dbw/request, SignedHeaders=host;x-content-sha256;x-date, Signature=47a7d934ff7b37c03938******cd7b8278a40a1057690c401e92246a0e41085f

{
  "InstanceType": "LA8L",
  "InstanceId": "vRVvTs0",
  "AdviceType": "YQ8eQrEz",
  "SummaryId": "3FR9M8VJ",
  "GroupBy": "C1Tze2zO1LH",
  "OrderBy": "fZTELKr51",
  "PageNumber": 1,
  "PageSize": 10
}

返回示例

{
  "ResponseMetadata": {
    "RequestId": "20250626113541144150034220213AA3",
    "Action": "ListSlowQueryAdviceApi",
    "Version": "2018-01-01",
    "Service": "dbw",
    "Region": "cn-beijing"
  },
  "Result": {
    "Total": 923,
    "AdvicesByGroup": [
      {
        "Advice": "ki7U4t",
        "advices": [
          {
            "DB": "UA2j",
            "agg": {
              "DB": "XvsxOx1cfE",
              "PSM": "1W26qrX1ji",
              "User": "2NUU9",
              "Table": "Ua",
              "SourceIP": "1ez",
              "SqlMethod": "VTGmKLiqj",
              "SQLTemplate": "C9",
              "ExecuteCount": 184,
              "LockTimeRatio": 49.593738069774595,
              "LockTimeStats": {
                "Max": 412.1837852399512,
                "Min": 303.3981830644388,
                "Total": 327.6012657411565,
                "Average": 884.5788448844304
              },
              "RowsSentRatio": 962.1237900583367,
              "RowsSentStats": {
                "Max": 193.9950340637744,
                "Min": 719.7396024872132,
                "Total": 44.397676330359936,
                "Average": 599.6852644411423
              },
              "SQLTemplateID": "Ebim",
              "LastAppearTime": 282,
              "QueryTimeRatio": 673.6140848577814,
              "QueryTimeStats": {
                "Max": 110.00471676020312,
                "Min": 559.1363877621384,
                "Total": 461.0285326293491,
                "Average": 721.7543936936573
              },
              "SqlFingerprint": "Vm",
              "FirstAppearTime": 545,
              "PTAnalysisResult": "3pZ9yMCLM",
              "ExecuteCountRatio": 90.83858884467239,
              "RowsExaminedRatio": 535.8721354757309,
              "RowsExaminedStats": {
                "Max": 307.3436334216496,
                "Min": 260.96945250948625,
                "Total": 122.52262261341264,
                "Average": 548.8263749092656
              }
            },
            "Risk": "yzeIMaio",
            "User": [
              "zpg"
            ],
            "Advice": "pw6lw0pt",
            "Benefit": 260.95760477352076,
            "SpeedUp": 917.6981529190973,
            "SQLModule": "O6Vv",
            "SourceIPs": [
              "k0NxOG9"
            ],
            "TableName": "L",
            "AdviceLevel": "X7s00gANR",
            "AdviceIndexSize": 995.2089979631796,
            "QueryTimeAvgAfter": 87.67546975473299
          }
        ]
      }
    ],
    "Advices": [
      {
        "DB": "IZLYaBG",
        "agg": {
          "DB": "4RQyQ",
          "PSM": "PlfL1FXh",
          "User": "m",
          "Table": "MnbbO",
          "SourceIP": "GTfgXC8u39",
          "SqlMethod": "RA",
          "SQLTemplate": "mHRZAoMc",
          "ExecuteCount": 175,
          "LockTimeRatio": 137.2567987752116,
          "LockTimeStats": {},
          "RowsSentRatio": 4.137434511933327,
          "RowsSentStats": {},
          "SQLTemplateID": "kMNwG",
          "LastAppearTime": 940,
          "QueryTimeRatio": 864.9235842137609,
          "QueryTimeStats": {},
          "SqlFingerprint": "T",
          "FirstAppearTime": 340,
          "PTAnalysisResult": "YVKc",
          "ExecuteCountRatio": 118.8011698617565,
          "RowsExaminedRatio": 681.9197703919931,
          "RowsExaminedStats": {}
        },
        "Risk": "zSHRkuM03",
        "User": [
          "aUQ"
        ],
        "Advice": "ByP85Vrz7hG",
        "Benefit": 396.8526870378074,
        "SpeedUp": 690.8143225785291,
        "SQLModule": "t",
        "SourceIPs": [
          "kzpGz"
        ],
        "TableName": "IihuJ2",
        "AdviceLevel": "1af",
        "AdviceIndexSize": 625.5266852886408,
        "QueryTimeAvgAfter": 933.815610218813
      }
    ]
  }
}

错误码

更多详情，请参见错误码。