Showing Intelligently Killed Sessions

Function

This API is used to show intelligently killed sessions. Before calling this API:

Learn how to authenticate it.
Obtain the required region and endpoint.

Calling Method

For details, see Calling APIs.

Authorization Information

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

If you are using role/policy-based authorization, see Permissions and Supported Actions for details on the required permissions.

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	Dependency
gaussdbformysql:instance:showIntelligentKillSession	Read	instance *	g:EnterpriseProjectId g:ResourceTag/<tag-key>	gaussdb:instance:showIntelligentKillSession	-

URI

GET /v3/{project_id}/instances/{instance_id}/intelligent-kill-session/statistic

**Table 1** URI parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Definition Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID. Constraints N/A Range The value contains 32 characters. Only letters and digits are allowed. Default Value N/A
instance_id	Yes	String	Definition Instance ID, which uniquely identifies an instance. To obtain this value, see Querying DB Instances. Constraints N/A Range The value contains 36 characters with a suffix of in07. Only letters and digits are allowed. Default Value N/A

**Table 2** Query parameters
Parameter	Mandatory	Type	Description
node_id	Yes	String	Definition Node ID, which uniquely identifies a node. To obtain this value, see Querying Details of a DB Instance. Constraints N/A Range The value contains 36 characters with a suffix of no07. Only letters and digits are allowed. Default Value N/A

Request Parameters

**Table 3** Request header parameters
Parameter	Mandatory	Type	Description
X-Auth-Token	Yes	String	Definition User token. To obtain this value, call the IAM API for obtaining a user token. The value of X-Subject-Token in the response header is the token value. Constraints N/A Range N/A Default Value N/A
X-Language	No	String	Definition Request language type. Constraints N/A Range en-us: English zh-cn: Chinese Default Value en-us

Response Parameters

Status code: 200

**Table 4** Response body parameter
Parameter	Type	Description
statistics	Array of IntelligentKillSessionStatistic objects	Definition List of displayed killed sessions.

**Table 5** IntelligentKillSessionStatistic
Parameter	Type	Description
keyword	String	Definition SQL template keyword of killed sessions. Range N/A
example_sql_text	String	Definition SQL statement being executed by the first session matched by the SQL template of killed sessions. Range N/A
ids	Array of longs	Definition List of session thread IDs matched by the SQL template of killed sessions.
count	Integer	Definition Number of sessions matched by the SQL template of killed sessions. Range ≥ 0
total_time	Double	Definition Total execution time (in seconds) of sessions matched by the SQL template of killed sessions. Range ≥ 0
avg_time	Double	Definition Average execution time (in seconds) of sessions matched by the SQL template of killed sessions. Range ≥ 0
max_time	Double	Definition Maximum execution time (in seconds) among all sessions matched by the SQL template of killed sessions. Range ≥ 0
strategy	String	Definition Killing rule matched by the SQL template of killed sessions. Range top3_time: The top 3 session groups with the longest execution duration will be killed. top3_count: The top 3 session groups with the largest session count will be killed. top3_avg_time: The top 3 session groups with the longest average execution duration will be killed.

Status code: 400

**Table 6** Response body parameters
Parameter	Type	Description
error_code	String	Error code.
error_msg	String	Error message.

Status code: 500

**Table 7** Response body parameters
Parameter	Type	Description
error_code	String	Error code.
error_msg	String	Error message.

Example Request

Showing intelligently killed sessions

GET https://{endpoint}/v3/054e292c9880d4992f02c0196d3ea468/instances/17b6bbb64d2f4c14a83a88f19da8dcc8in07/intelligent-kill-session/statistic?node_id=fb301dc800444b1cbea48efba97e94ebno07

Example Response

Status code: 200

Success.

{
  "statistics" : [ {
    "keyword" : "SELECT~code~SELECT~SLEEP~FROM~test~coupons~LIMIT",
    "example_sql_text" : "SELECT code, (SELECT SLEEP(550)) FROM test.coupons LIMIT 1",
    "ids" : [ 1866445, 1866450, 1866462, 1866457, 1866494 ],
    "count" : 5,
    "total_time" : 19.0,
    "avg_time" : 3.8,
    "max_time" : 5.0,
    "strategy" : "top3_time"
  }, {
    "keyword" : "SELECT~u~username~o~total_price~FROM~test~users~u~JOIN~test~orders~o~ON~u~id~o~user_id~WHERE~SELECT~SLEEP~LIMIT",
    "example_sql_text" : "SELECT u.username, o.total_price FROM test.users u JOIN test.orders o ON u.id = o.user_id WHERE (SELECT SLEEP(450)) = 0 LIMIT 1",
    "ids" : [ 1866447, 1866481, 1866490 ],
    "count" : 3,
    "total_time" : 8.0,
    "avg_time" : 2.6666666666666665,
    "max_time" : 5.0,
    "strategy" : "top3_time"
  } ]
}