Help Center/ GaussDB/ API Reference/ APIs (Recommended)/ Slow SQL Statements/ Querying Nodes Where There Are Slow SQL Statements

Updated on 2025-10-20 GMT+08:00

View PDF

Querying Nodes Where There Are Slow SQL Statements

Function

This API is used to query nodes where there are slow SQL statements based on the instance ID. Before calling this API:

Learn how to authenticate this API.
Obtain the required region and endpoint.

Constraints

This API is suitable only for nodes with CNs or DNs (primary or standby DNs).

Debugging

You can debug this API in API Explorer.

URI

POST /v3/{project_id}/instances/{instance_id}/slow-sql-execute-node

**Table 1** Parameter description
Parameter	Mandatory	Description
project_id	Yes	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 allowed. Default Value N/A
instance_id	Yes	Definition Instance ID, which uniquely identifies an instance. Constraints N/A Range The value can contain 36 characters. Only letters and digits are allowed. Default Value N/A

Request Parameters

**Table 2** Request header parameters
Parameter	Mandatory	Type	Description
X-Auth-Token	Yes	String	Definition User token. You can obtain the token by calling the IAM API used to obtain a user token. After the request is processed, the value of X-Subject-Token in the message header is the token value. Constraints N/A Range N/A Default Value N/A
X-Language	No	String	Definition Language. Constraints N/A Range zh-cn en-us Default Value en-us

**Table 3** Request body parameters
Parameter	Mandatory	Type	Description
action	Yes	String	Definition Type. Constraints The value can only be slow. Range slow Default Value N/A

Response Parameters

**Table 4** Response body parameters
Parameter	Type	Description
nodes	Array of objects	Definition Node information list. For details, see Table 5.

**Table 5** SlowSqlNodeList
Parameter	Type	Description
node_id	String	Definition Node ID. Range N/A
node_name	String	Definition Node name. Range N/A
role	String	Definition Node role. Range master: primary node slave: standby node secondary: log node readreplica: read replica
instance_id	String	Definition Instance ID. Range N/A
component_type	String	Definition Component type. Range CN: CN component DN: DN component

Example Request

Querying nodes where there are slow SQL statements

POST https://gaussdb-opengauss.ap-southeast-1.myhuaweicloud.com/v3/0611f1bd8b00d5d32f17c017f15b599f/instances/3d39c18788b54a919bab633874c159dfin14/slow-sql-execute-node
{ 
  "action" : "slow" 
}

Example Response

Node information queried.

{
   "nodes" : [ {
      "node_id" : "0d9ca6ce53ef4c158aab7084e9885108no14",
      "node_name" : "gauss-xhy_gaussdbv5_hcs2-0_0",
      "role" : "master",
      "instance_id" : "d04686c6baae4f65a742771186f47b7ain14",
      "component_type" : "CN"
      } ]
}