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. Select a region.
  3. Find the target cluster and click the cluster ID in the Cluster Name column.
  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.
    • To monitor cluster performance, click the Cluster tab and set the monitoring time period. Click OK.
    • To monitor node performance, click the Node tab, select a node from the Select Node drop-down list, and set the monitoring time period. Click OK.
      Note You can click More at the lower part of the Node tab to view more metrics.

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 usage 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 usage 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 settings

  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.