DescribeProcessList - ApsaraDB for ClickHouse - Alibaba Cloud Documentation Center

Queries the details of queries that are being executed in an ApsaraDB for ClickHouse cluster.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer.

Debug

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

Parameter	Type	Required	Description	Example
RegionId	string	Yes	The region ID. You can call the DescribeRegions operation to query the most recent region list.	cn-hangzhou
DBClusterId	string	Yes	The cluster ID. You can call the DescribeDBClusters operation to query information about all the clusters that are deployed in a specific region. The information includes the cluster IDs.	cc-bp1190tj036am****
QueryDurationMs	integer	Yes	The minimum query duration. The minimum value is 1000, and the default value is 1000. Unit: milliseconds. Queries that last longer than this duration are returned in response parameters.	500
InitialUser	string	No	The account that is used to log on to the database.	user
Keyword	string	No	The keyword that is used to query.	join
Order	string	No	Sorting by the specified column name. Valid values: elapsed: the cumulative execution time written_rows: the number of written rows read_rows: the number of read rows memory_usage: the memory usage	elapsed
PageSize	integer	No	The number of entries returned per page. Valid values: 30 (default) 50 100	30
PageNumber	integer	No	The page number. Pages start from page 1. Default value: 1.	1
InitialQueryId	string	No	The ID of the query statement.	6c69d508-f05f-4c74-857c-d982b7e7e79f

Response parameters

Parameter	Type	Description	Example
	object	The response parameters.
RequestId	string	The request ID.	FD61BB0D-788A-5185-A8E3-1B90BA8F6F04
ProcessList	object	The queries.
TableSchema	array<object>	Details of the columns.
	object
Type	string	The column type.	String
Name	string	The column name.	InitialUser
Data	array<object>	The details of the query.
	object
QueryStartTime	string	The beginning of the time range to query. The value is in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in Coordinated Universal Time (UTC).	2021-02-02T09:14:48Z
Query	string	The SQL statement that is executed in the query.	select * from test order by score limit 1;
InitialAddress	string	The IP address of the client that initiates the query.	::ffff:10.1.XX.XX
InitialQueryId	string	The query ID.	2dd144fd-4230-4249-b15c-e63f964fbb5a
InitialUser	string	The database account.	test
QueryDurationMs	string	The execution duration of the query. Unit: milliseconds.	2000
Rows	string	The number of rows returned for the query.	1145700
RowsBeforeLimitAtLeast	string	The number of entries returned per page.	1
Statistics	object	The statistics of the results.
RowsRead	integer	The number of scanned rows.	1000000
ElapsedTime	float	The average response time.	4156
BytesRead	integer	The size of the data that was scanned. Unit: bytes.	9141300000

Examples

Sample success responses

JSONformat

{
  "RequestId": "FD61BB0D-788A-5185-A8E3-1B90BA8F6F04",
  "ProcessList": {
    "TableSchema": {
      "ResultSet": [
        {
          "Type": "String",
          "Name": "InitialUser"
        }
      ]
    },
    "Data": {
      "ResultSet": [
        {
          "QueryStartTime": "2021-02-02T09:14:48Z",
          "Query": "select * from test order by score limit 1;",
          "InitialAddress": "::ffff:10.1.XX.XX",
          "InitialQueryId": "2dd144fd-4230-4249-b15c-e63f964fbb5a",
          "InitialUser": "test",
          "QueryDurationMs": "2000"
        }
      ]
    },
    "Rows": "1145700",
    "RowsBeforeLimitAtLeast": "1",
    "Statistics": {
      "RowsRead": 1000000,
      "ElapsedTime": 4156,
      "BytesRead": 9141300000
    }
  }
}

Error codes

HTTP status code	Error code	Error message	Description
500	InternalError	An error occurred while processing your request.	An error occurred while processing your request.
503	ServiceUnavailable	An error occurred while processing your request.	An error occurred while processing your request.

For a list of error codes, visit the Service error codes.

Change history

Change time	Summary of changes	Operation

No change history