This topic describes the performance parameters of AnalyticDB for PostgreSQL.

Elastic storage mode

You can call the DescribeHealthStatus operation to return the following metric parameters.

Parameter Metric Unit Description
adbpg_status Instance health status N/A
  • critical: The coordinator node or a compute node is unavailable. In this case, this metric is marked in red in the console.
  • healthy: All nodes are available. In this case, this metric is marked in green in the console.
adbpg_connection_status Instance connection health status N/A The connection health status of the instance. Valid values:
  • critical: The instance connection usage is greater than 95%. In this case, this metric is marked in red in the console.
  • warning: The instance connection usage is greater than 90% and less than or equal to 95%. In this case, this metric is marked in yellow in the console.
  • healthy: The instance connection usage is less than or equal to 90%. In this case, this metric is marked in green in the console.
Note The instance connection usage is the maximum connection usage among all the coordinator and compute nodes.
adbpg_disk_status Instance storage status N/A The storage status of the instance. Valid values:
  • critical: The instance storage usage is greater than or equal to 90%. In this case, this metric is marked in red in the console and the instance is locked.
  • warning: The instance storage usage is greater than or equal to 70% and less than 90%. In this case, this metric is marked in yellow in the console.
  • healthy: The instance storage usage is less than 70%. In this case, this metric is marked in green in the console.
Note The instance storage usage is the average storage usage of all compute nodes.
adbpg_disk_usage_percent Instance storage usage % The status corresponding to the storage usage of the instance. Valid values:
  • critical: The instance storage usage is greater than or equal to 90%. In this case, the instance is locked.
  • warning: The instance storage usage is greater than or equal to 70% and less than 90%.
  • healthy: The instance storage usage is less than 70%.
Note The instance storage usage is the average storage usage of all compute nodes.
adbpg_master_disk_usage_percent_max Maximum coordinator node storage usage % The status corresponding to the maximum storage usage of the coordinator node. Valid values:
  • critical: The coordinator node storage usage is greater than or equal to 90%. In this case, the instance is locked.
  • warning: The coordinator node storage usage is greater than or equal to 70% and less than 90%.
  • healthy: The coordinator node storage usage is less than 70%.
adbgp_segment_disk_usage_percent_max Maximum compute node storage usage % The status corresponding to the maximum storage usage among all compute nodes. Valid values:
  • critical: The compute node storage usage is greater than or equal to 90%. In this case, the instance is locked.
  • warning: The compute node storage usage is greater than or equal to 80% and less than 90%.
  • healthy: The compute node storage usage is less than 80%.
node_master_status Coordinator node health status N/A The health status of the coordinator node. Valid values:
  • critical: The coordinator node is unavailable. In this case, this metric is marked in red in the console.
  • healthy: The coordinator node is available. In this case, this metric is marked in green in the console.
node_segment_disk_status Compute node storage status N/A The storage status of compute nodes. Valid values:
  • critical: The compute node storage usage is greater than or equal to 90%. In this case, this metric is marked in red in the console and the instance is locked.
  • warning: The compute node storage usage is greater than or equal to 80% and less than 90%. In this case, this metric is marked in yellow in the console.
  • healthy: The compute node storage usage is less than 80%. In this case, this metric is marked in green in the console.
Note The compute node storage usage is the maximum storage usage among all compute nodes.
node_master_connection_status Coordinator node connection health status N/A The connection health status of the coordinator node. Valid values:
  • critical: The coordinator node connection usage is greater than 95%. In this case, this metric is marked in red in the console.
  • warning: The coordinator node connection usage is greater than or equal to 90% and less than 95%. In this case, this metric is marked in yellow in the console.
  • healthy: The coordinator node connection usage is less than 90%. In this case, this metric is marked in green in the console.
Note The coordinator node connection usage is the maximum connection usage of the coordinator node.
node_segment_connection_status Compute node connection health status N/A The connection health status of compute nodes. Valid values:
  • critical: The compute node connection usage is greater than or equal to 95%. In this case, this metric is marked in red in the console.
  • warning: The compute node connection usage is greater than or equal to 90% and less than 95%. In this case, this metric is marked in yellow in the console.
  • healthy: The compute node connection usage is less than 90%. In this case, this metric is marked in green in the console.
Note The compute node connection usage is the maximum connection usage among all compute nodes.

You can call the DescribeDBClusterPerformance operation to return the following metric parameters.

Parameter Metric Unit Description
adbpg_segment_cnt Number of compute nodes N/A The number of compute nodes collected per hour.
adbpg_instance_disk_used_mb Instance storage used MB The amount of storage space used by all compute nodes.
adbpg_instance_disk_usage_percent Instance storage usage % The storage usage of the instance, which is calculated by using the following formula: Storage space used by all compute nodes/Reserved storage space of all compute nodes.
node_master_connection_count Number of coordinator node connections N/A The number of connections to the coordinator node.
node_segment_connection_count Number of compute node connections N/A The number of connections to compute nodes.
node_segment_workfile_used_mb Temporary disk file size MB The size of temporary files written to disks.
node_cpu_used_percent CPU utilization % The CPU utilization of the coordinator node or compute nodes.
node_mem_used_percent Memory usage % The memory usage of the coordinator node or compute nodes.
node_disk_iops_percent I/O usage % The I/O usage of the coordinator node or compute nodes.
node_disk_used_mb Storage used MB The amount of storage space used by each compute node.
node_disk_usage_percent Storage usage % The storage usage of each compute node, which is calculated by using the following formula: Storage space used by each compute node/Reserved storage space of each compute node.

Serverless mode

You can call the DescribeHealthStatus operation to return the following metric parameters.

Parameter Metric Unit Description
adbpg_status Instance health status N/A
  • critical: The coordinator node or a compute node is unavailable. In this case, this metric is marked in red in the console.
  • healthy: All nodes are available. In this case, this metric is marked in green in the console.
adbpg_connection_status Instance connection health status N/A The connection health status of the instance. Valid values:
  • critical: The instance connection usage is greater than 95%. In this case, this metric is marked in red in the console.
  • warning: The instance connection usage is greater than 90% and less than or equal to 95%. In this case, this metric is marked in yellow in the console.
  • healthy: The instance connection usage is less than or equal to 90%. In this case, this metric is marked in green in the console.
Note The instance connection usage is the maximum connection usage among all the coordinator and compute nodes.
node_master_status Coordinator node health status N/A The health status of the coordinator node. Valid values:
  • critical: The coordinator node is unavailable. In this case, this metric is marked in red in the console.
  • healthy: The coordinator node is available. In this case, this metric is marked in green in the console.
node_master_connection_status Coordinator node connection health status N/A The connection health status of the coordinator node. Valid values:
  • critical: The coordinator node connection usage is greater than 95%. In this case, this metric is marked in red in the console.
  • warning: The coordinator node connection usage is greater than or equal to 90% and less than 95%. In this case, this metric is marked in yellow in the console.
  • healthy: The coordinator node connection usage is less than 90%. In this case, this metric is marked in green in the console.
Note The coordinator node connection usage is the maximum connection usage of the coordinator node.
node_segment_connection_status Compute node connection health status N/A The connection health status of compute nodes. Valid values:
  • critical: The compute node connection usage is greater than or equal to 95%. In this case, this metric is marked in red in the console.
  • warning: The compute node connection usage is greater than or equal to 90% and less than 95%. In this case, this metric is marked in yellow in the console.
  • healthy: The compute node connection usage is less than 90%. In this case, this metric is marked in green in the console.
Note The compute node connection usage is the maximum connection usage among all compute nodes.

You can call the DescribeDBClusterPerformance operation to return the following metric parameters.

Parameter Metric Unit Description
adbpg_segment_cnt Number of compute nodes N/A The number of compute nodes collected per hour.
adbpg_instance_disk_used_mb Instance storage used MB The amount of Object Storage Service (OSS) storage space used by the instance.
node_master_connection_count Number of coordinator node connections N/A The number of connections to the coordinator node.
node_segment_connection_count Number of compute node connections N/A The number of connections to compute nodes.
node_segment_workfile_used_mb Temporary disk file size MB The size of temporary files written to disks.
node_cpu_used_percent CPU utilization % The CPU utilization of the coordinator node or compute nodes.
node_mem_used_percent Memory usage % The memory usage of the coordinator node or compute nodes.

Reserved storage mode

You can call the DescribeDBClusterPerformance operation to return the following metric parameters.

Parameter Description
adbpg_conn_count The number of connections to the coordinator node.
adbpg_group_mem_used_percent The memory usage.
adbpg_group_cpu_used_percent The CPU utilization.
adbpg_group_disk_iops_total The I/O throughput.
adbpg_group_disk_iops_read The read IOPS.
adbpg_group_disk_iops_write The write IOPS.
adbpg_group_disk_used_bytes The disk space. Unit: MB.