ApsaraDB for RDS provides a wide range of performance metrics. You can view resource monitoring in the ApsaraDB for RDS console.

For PostgreSQL 11 Cluster Edition (Standard SSD) and PostgreSQL 10 Cluster Edition (Standard SSD)

  1. Log on to the ApsaraDB RDS PostgreSQL console.
  2. In the upper-left corner of the page, select the region where the instance is located.
  3. Find the instance and click the instance ID.
  4. In the left-side navigation pane, choose Monitoring and Alerts > Basic Monitoring.
  5. Select the time range to query the corresponding monitoring data. The following table lists the specific monitored metrics.
    Monitored metric Description
    TPS The number of transactions completed by the instance per second.
    Operation records The number of UPDATE, INSERT, DELETE, and other operations of the instance per second.
    RT The response time of the instance. Unit: seconds.
    Connections Shows the total number of connections, active connections, and idle connections of the instance.
    Longest bloat duration The time period between the earliest transaction that dead tuples cannot be vacuumed and the monitoring time.
    Slow queries The number of SQL statements whose execution time exceed 1 second, 3 seconds, or 5 seconds.
    Long-running transactions The number of long-running transactions. It includes the number of transactions whose execution time or idle time exceed 1 second, 3 seconds, or 5 seconds.
    2PC The number of transactions whose execution time exceed 1 second, 3 seconds, or 5 seconds during two-phase commits.
    Space The database space and log space of the instance. Unit: MB.
    Latency The latency of replication slots and the latency of the secondary database utilization. Unit: Bytes.
    Data disk IOPS The number of I/O requests on the data disk per second.
    Data disk read/write throughput The throughput of disk reads and writes on the data disk per second. Unit: KB.
    Data disk usage The overall usage and iNodes usage of the data disk.
    Server CPU utilization The CPU utilization of the instance.
    Server throughput The data volume received and sent through the instance NIC per second. Unit: MB.
    Server memory usage The memory usage of the instance.
    Server memory Shows the memory capacity, used memory size, and free memory size. Unit: MB.

For PostgreSQL 10 Cluster Edition (Local SSD), PostgreSQL 10 Basic Edition, and PostgreSQL 9.4

  1. Log on to the ApsaraDB for RDS console.
  2. In the upper-left corner of the page, select the region where the instance is located.
  3. Find the instance and click the instance ID.
  4. In the left-side navigation pane, click Monitoring and Alerts.
  5. On the Monitoring page, select the time range to query the corresponding monitoring data. The following table lists the specific monitored metrics.
    Monitored metric Description
    Disk space The used disk space of the instance. Unit: MB.
    IOPS The number of I/O requests of the data disk and log disk per second.
    Memory usage The memory usage of the instance.
    CPU utilization The CPU utilization of the instance.
    Total connections The total number of current connections of the instance.