Querying SQL Stack Information

Function

This API is used to query SQL stack information of waiting events. Before calling this API:

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

Debugging

You can debug this API in API Explorer.

Constraints

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

URI

GET /v3/{project_id}/instances/{instance_id}/slow-sql/optimization/stack

**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

**Table 2** Request body parameters
Parameter	Mandatory	Type	Description
pid	Yes	String	Definition Thread ID. Constraints N/A Range N/A Default Value N/A
node_id	Yes	String	Definition Node ID. Constraints N/A Range N/A Default Value N/A
comp_id	No	String	Definition ID of a component on a node. Constraints N/A Range N/A Default Value N/A

Request Parameters

**Table 3** 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

Response Parameters

**Table 4** Response body parameters
Parameter	Type	Description
gs_stack	String	Definition Stack information. Range N/A

Example Request

GET https://gaussdb-opengauss.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/cc6fd964d93f4003851dfc29d57d30a5in14/slow-sql/optimization/stack?pid=139898020947520&node_id=7bae4d3eedb840da95545569bd662d5ano14&comp_id=dn_6001

Example Response

{
    "gs_stack": "__select + 0x14d\npg_usleep(long) + 0x59\npg_sleep(FunctionCallInfoData*) + 0xca\nunsigned long exec_make_nosets_funcresult<false, false>(FuncExprState*, ExprContext*, bool*, ExprDoneCond*) + 0x501\nexec_targetlist(List*, ExprContext*, unsigned long*, bool*, ExprDoneCond*, ExprDoneCond*) + 0x1c5\nexec_project_byrec(ProjectionInfo*, ExprDoneCond*) + 0xf3\nResultOperator::get_next() + 0x37d\nPlanState::get_next() + 0x115\nexec_standard_executor_run(QueryDesc*, ScanDirection, long) + 0x266\nsqlcmd_explain_executor_run(QueryDesc*, ScanDirection, long) + 0x115\nexec_executor_run(QueryDesc*, ScanDirection, long) + 0xe3\nPortalRunSelect(PortalData*, bool, long, _DestReceiver*) + 0x4ee\nPortalRun(PortalData*, long, bool, _DestReceiver*, _DestReceiver*, char*, SnapshotData*) + 0x798\nexec_simple_query(char const*, MessageType, GsStringData*) [clone .constprop.0] + 0x4aa\ngs_process_command(int, GsStringData*, bool volatile*) + 0x109\nPostgresMain(int, char**, char const*, char const*) + 0x185b\nbackend_run(Port*) + 0x222\nint gauss_db_thread_main<(knl_thread_role)2>(knl_thread_arg*) + 0x348\ninternal_thread_func(void*) + 0x1a\nunknown\nunknown\n"
}