The ApsaraDB for PolarDB console provides a variety of performance metrics for you to monitor the status of your instances.

Performance monitoring

  1. Log on to the ApsaraDB for PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster is located.
  3. Click the ID of the cluster.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Monitoring.
  5. You can view the performance information of a Cluster or Node as needed. For more information, see Metric description.
    • Cluster performance monitoring:

      Click the Cluster tab and set the monitoring time period. Click OK.

    • Node performance monitoring:

      Click the Node tab, select a node from the node list, and set the monitoring time period. Click OK.

Metric description

Category Metric Description
Cluster Storage Displays the usage of data space, log space, temporary space, and WAL log space.
CPU Displays the CPU utilization of each node.
Memory Displays the memory usage of each node.
Node TPS Displays the number of transactions per second of the selected node, including the number of committed transactions per second, deadlocked transactions per second, and rollback transactions per second.
CPU Displays the CPU utilization of the selected node.
Memory Displays the memory usage of the selected node.
Connections Displays the total number of current connections, active connections, and idle connections of the selected node.
Scanned Rows Displays the numbers of rows inserted, read, updated, deleted, and returned per second of the selected node.
Maximum Database Age Displays the difference between the transaction IDs of the oldest and newest transactions in the database.
I/O Throughput Displays the total I/O throughput, I/O read throughput, and I/O write throughput of the selected node.
IOPS Displays the input/output operations per second (IOPS) of the selected node, including the total IOPS, read IOPS, and write IOPS.
Cache Displays the cache reads per second and disk reads per second of the selected node.
Cache Hit Ratio Displays the cache hit ratio of the selected node.
Temporary Files Displays the number and total size of temporary files on the selected node.

Alert configuration

  1. Log on to the CloudMonitor console.
  2. In the left-side navigation pane, choose Alerts > Alert Rules.
  3. On the Alert Rules page, click Create Alert Rule to go to the Create Alert Rule page.
  4. Select ApsaraDB for PolarDB PostgreSQL/Oracle from the Product drop-down list and select a resource range from the Resource Range drop-down list. Set the alert rule and notification method, and click Confirm.
    Note For more information about alert rules, see Alarm rule parameters.