All Products
Search
Document Center

ApsaraDB for ClickHouse:DescribeDBClusterPerformance

Last Updated:Mar 01, 2024

Queries performance data about an ApsaraDB for ClickHouse cluster.

Operation description

You can query the performance data of a specified cluster over a specific time range based on the performance metrics. The data is collected every 30 seconds.

Note You can call this operation only for ApsaraDB for ClickHouse clusters that were created before December 1, 2021.

Debugging

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

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

ParameterTypeRequiredDescriptionExample
DBClusterIdstringYes

The cluster ID.

cc-bp125e3uu94wo****
KeystringNo

The performance metrics that you want to query. Separate multiple performance metrics with commas (,). You can query up to five performance metrics at a time. You can query the following performance metrics:

Note The Key parameter is required.
  • CPU:

    • CPU_USAGE: the CPU utilization
  • Memory:

    • MEM_USAGE: the memory usage
    • MEM_USAGE_SIZE: the used memory. Unit: MB
  • Disk:

    • DISK_USAGE: the disk usage
    • DISK_USAGE_SIZE: the size of the used disks. Unit: MB
    • IOPS: the disk Input/Output Operations per Second (IOPS)
  • Connection:

    • CONN_USAGE: the database connection usage
    • CONN_USAGE_COUNT: the number of database connections used
  • Write:

    • TPS: the number of rows written per second
    • INSERT_SIZE: the amount of data written per second. Unit: MB
  • Query:

    • QPS: the queries per second
    • AVG_SEEK: the average number of random seek calls
  • WAIT:

    • ZK_WAIT: the average ZooKeeper wait time. Unit: ms
    • IO_WAIT: the average I/O wait time. Unit: ms
    • CPU_WAIT: the average CPU wait time. Unit: ms
MEM_USAGE
StartTimestringYes

The beginning of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mmZ format. The time must be in Coordinated Universal Time (UTC).

2021-11-27T16:37Z
EndTimestringYes

The end of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mmZ format. The time must be in UTC.

Note The end time must be later than the start time. The interval cannot be more than 32 days.
2021-11-27T16:38Z

Response parameters

ParameterTypeDescriptionExample
object
EndTimestring

The end of the time range to query. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in Coordinated Universal Time (UTC).

2021-11-27T16:38Z
RequestIdstring

The request ID.

FE242962-6DA3-5FC8-9691-37B62A3210F7
StartTimestring

The beginning of the time range to query. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC.

2021-11-27T16:37Z
DBClusterIdstring

The cluster ID.

cc-bp125e3uu94wo****
Performancesobject []

The values of the queried performance metrics of the cluster.

Keystring

The name of the performance metric.

MEM_USAGE
Unitstring

The unit of the performance metric.

%
Seriesobject []

The queried performance pamaters.

Valuesobject []

The values of the performance parameter. Each value of the performance parameter is collected at a point in time.

Pointarray

The values of a metric.

string

The values of the performance metrics at different points in time.

[ "2021-11-26T16:39:00Z","15.08" ]
Namestring

The name of the list of performance metric values.

cc-bp125e3uu94wo1s0k16****
Namestring

The name of the performance metric value.

mem_usage

Examples

Sample success responses

JSONformat

{
  "EndTime": "2021-11-27T16:38Z",
  "RequestId": "FE242962-6DA3-5FC8-9691-37B62A3210F7",
  "StartTime": "2021-11-27T16:37Z",
  "DBClusterId": "cc-bp125e3uu94wo****",
  "Performances": [
    {
      "Key": "MEM_USAGE",
      "Unit": "%",
      "Series": [
        {
          "Values": [
            {
              "Point": [
                "[ \"2021-11-26T16:39:00Z\",\"15.08\" ]"
              ]
            }
          ],
          "Name": "cc-bp125e3uu94wo1s0k16****"
        }
      ],
      "Name": "mem_usage"
    }
  ]
}

Error codes

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

Change history

Change timeSummary of changesOperation
No change history