Updated on 2026-08-25 GMT+08:00

Querying the Trend of a Single SQL Template

Function

This API is used to obtain the trend of the number of executions and average execution time of a single SQL template.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action

Access Level

Resource Type (*: required)

Condition Key

Alias

Dependencies

das:clouddba:listTopSql

list

Instance

-

das:clouddba:topSqlList

-

Action	Access Level	Resource Type (*: required)	Condition Key	Alias	Dependencies
das:clouddba:listTopSql	list	Instance	-	das:clouddba:topSqlList	-

URI

GET /v3/{project_id}/fullsql/query-single-tpl-trend

**Table 1** URI parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID. Constraints N/A Range The value can contain 32 characters. Only letters and digits are supported. Default Value N/A

**Table 2** Query parameters
Parameter	Mandatory	Type	Description
instance_id	Yes	String	Definition Instance ID Constraints N/A Range The value can contain 32 characters. Only letters and digits are supported. Default Value N/A
node_id	No	String	Definition Node ID Constraints N/A Range The value can contain 32 characters. Only letters and digits are supported. Default Value N/A
template_id	Yes	String	Definition Template ID Constraints N/A Range N/A Default Value N/A
start_at	Yes	Long	Definition Start time, in milliseconds Constraints N/A Range N/A Default Value N/A
end_at	Yes	Long	Definition End time, in milliseconds Constraints N/A Range N/A Default Value N/A
interval_minutes	No	Long	Definition Aggregation interval in minutes Constraints N/A Range N/A Default Value N/A

Request Parameters

None

Response Parameters

Status code: 200

**Table 3** Response body parameters
Parameter	Type	Description
timestamps	Array of longs	Definition Timestamp of the trend chart Range N/A
trend_data_list	Array of objects in Table 4	Definition SQL trend list Range N/A

**Table 4** SQLTplCmp
Parameter	Type	Description
name	String	Definition Trend metric name Range N/A
values	Array of doubles	Definition Trend metric value Range N/A

Example Requests

GET https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/fullsql/query-single-tpl-trend?instance_id=bcfa975193f1402fa11a6d4fd6baf5fbin01&start_at=1764235496340&end_at=1764239096340&template_id=199E7DCA63EA8858&node_id=

Example Responses

Status code: 200

Success.

{
    "timestamps": [
        1764237070000,
        1764237080000,
        1764237090000
    ],
    "trend_data_list": [
        {
            "name": "executeNum",
            "values": [
                1.0,
                2.0,
                1.0
            ]
        },
        {
            "name": "avgRowsExamined",
            "values": [
                0.0,
                0.0,
                0.0
            ]
        },
        {
            "name": "avgRowsSent",
            "values": [
                1.0,
                1.0,
                1.0
            ]
        },
        {
            "name": "avgCost",
            "values": [
                0.0,
                0.0,
                0.0
            ]
        },
        {
            "name": "avgLockTime",
            "values": [
                0.0,
                0.0,
                0.0
            ]
        }
    ]
}

Status Codes

Status Code	Description
200	Success.
400	Client error.
500	Server error.

Error Codes

See Error Codes.

Parent topic: Intelligent O&M