Updated on 2024-03-05 GMT+08:00

Configuring Displayed Metrics

The RDS Agent monitors RDS DB instances and collects monitoring metrics only.

Description

This section describes the metrics that can be monitored by Cloud Eye as well as their namespaces and dimensions. You can use APIs provided by Cloud Eye to query the monitoring metrics and alarms generated for RDS.

Namespace

SYS.RDS

DB Instance Monitoring Metrics

  • Table 1 lists the performance metrics of RDS for PostgreSQL DB instances.
    Table 1 Performance metrics

    Metric ID

    Name

    Description

    Value Range

    Monitored Object

    Monitoring Interval (Raw Data)

    rds001_cpu_util

    CPU Usage

    CPU usage of the monitored object

    0-100%

    RDS for PostgreSQL instance

    1 minute

    rds002_mem_util

    Memory Usage

    Memory usage of the monitored object

    0-100%

    RDS for PostgreSQL instance

    1 minute

    rds003_iops

    IOPS

    Average number of I/O requests processed by the system in a specified period

    ≥ 0 counts/s

    RDS for PostgreSQL instance

    1 minute

    rds004_bytes_in

    Network Input Throughput

    Incoming traffic in bytes per second

    ≥ 0 bytes/s

    RDS for PostgreSQL instance

    1 minute

    rds005_bytes_out

    Network Output Throughput

    Outgoing traffic in bytes per second

    ≥ 0 bytes/s

    RDS for PostgreSQL instance

    1 minute

    rds039_disk_util

    Storage Space Usage

    Storage space usage of the monitored object

    0-100%

    RDS for PostgreSQL instance

    1 minute

    rds040_transaction_logs_usage

    Transaction Logs Usage

    Storage space usage of transaction logs

    ≥ 0 MB

    RDS for PostgreSQL instance

    1 minute

    rds041_replication_slot_usage

    Replication Slot Usage

    Storage space usage of replication slot files

    ≥ 0 MB

    RDS for PostgreSQL instance

    1 minute

    rds042_database_connections

    Database Connections in Use

    Number of database connections in use

    ≥ 0 counts

    RDS for PostgreSQL instance

    1 minute

    rds043_maximum_used_transaction_ids

    Maximum Used Transaction IDs

    Maximum number of transaction IDs that have been used

    ≥ 0 counts

    RDS for PostgreSQL instance

    1 minute

    rds044_transaction_logs_generations

    Transaction Logs Generation

    Size of transaction logs generated per second

    ≥ 0 MB/s

    RDS for PostgreSQL instance

    1 minute

    rds045_oldest_replication_slot_lag

    Oldest Replication Slot Lag

    Lagging size of the most lagging replica in terms of WAL data received

    ≥ 0 MB

    RDS for PostgreSQL instance

    1 minute

    rds046_replication_lag

    Replication Lag

    Replication lag

    ≥ 0 ms

    RDS for PostgreSQL instance

    1 minute

    rds047_disk_total_size

    Total Storage Space

    Total storage space of the monitored object

    40–4,000 GB

    RDS for PostgreSQL instance

    1 minute

    rds048_disk_used_size

    Used Storage Space

    Used storage space of the monitored object

    0–4,000 GB

    RDS for PostgreSQL instance

    1 minute

    rds049_disk_read_throughput

    Disk Read Throughput

    Number of bytes read from the disk per second

    ≥ 0 bytes/s

    RDS for PostgreSQL instance

    1 minute

    rds050_disk_write_throughput

    Disk Write Throughput

    Number of bytes written into the disk per second

    ≥ 0 bytes/s

    RDS for PostgreSQL instance

    1 minute

    rds082_tps

    TPS

    Execution times of submitted and rollback transactions per second

    ≥ 0 counts/s

    RDS for PostgreSQL instance

    1 minute

    rds083_conn_usage

    Connection Usage

    Percent of used PostgreSQL connections to the total number of connections

    0-100%

    RDS for PostgreSQL instance

    1 minute

    row_per_second

    Operation Rows

    Number of rows that are being inserted, deleted, updated, or queried

    ≥ 0

    RDS for PostgreSQL instance

    1 minute

    active_connections

    Active Connections

    Number of active database connections

    ≥ 0

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 10 and later versions are supported.

    1 minute

    idle_transaction_connections

    Idle Transaction Connections

    Number of idle transaction connections

    ≥ 0

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 10 and later versions are supported.

    1 minute

    oldest_transaction_duration

    Oldest Active Transaction Duration

    Length of time since the start of the transaction that has been active longer than any other current transaction

    ≥ 0 ms

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 10 and later versions are supported.

    1 minute

    oldest_transaction_duration_2pc

    Oldest Two-Phase Commit Transaction Duration

    Length of time since the start of the transaction that has been prepared for two-phase commit longer than any other current transaction

    ≥ 0 ms

    RDS for PostgreSQL instance

    1 minute

    disk_io_usage

    Disk I/O Usage

    I/O usage of disks The disk I/O usage is the percentage of the time that the disk processes I/O requests to the total time.

    NOTE:

    If the disk I/O usage reaches 100%, data is being written to the disk during the statistical period. The disk performance is determined by multiple metrics, such as IOPS, disk throughput, and read/write latency.

    0-100%

    RDS for PostgreSQL instance

    1 minute

    lock_waiting_sessions

    Sessions Waiting for Locks

    Number of blocked sessions

    ≥ 0

    RDS for PostgreSQL instance

    1 minute

    swap_in_rate

    Swap-In Rate

    Volume of data written from the swap partition to the memory per second

    ≥ 0 KB/s

    RDS for PostgreSQL instance

    1 minute

    swap_out_rate

    Swap-Out Rate

    Volume of data written from the memory to the swap partition per second

    ≥ 0 KB/s

    RDS for PostgreSQL instance

    1 minute

    swap_total_size

    Total Swap Size

    Total size of the swap partition

    ≥ 0 MB

    RDS for PostgreSQL instance

    1 minute

    swap_usage

    Swap Usage

    Usage of the swap partition

    0-100%

    RDS for PostgreSQL instance

    1 minute

    db_max_age

    Maximum Database Age

    Maximum age of the current database, which is the value of max(age(datfrozenxid)) in the pg_database table

    ≥ 0

    RDS for PostgreSQL instance

    1 minute

    cpu_user_usage

    User-mode CPU Time Percentage

    Percentage of time that the CPU is in user mode

    0-100%

    RDS for PostgreSQL instance

    1 minute

    cpu_sys_usage

    Kernel-mode CPU Time Percentage

    Percentage of time that the CPU is in kernel mode

    0-100%

    RDS for PostgreSQL instance

    1 minute

    cpu_wait_usage

    Disk I/O Wait Time Percentage

    Percentage of time that the CPU is waiting for disk I/O operations to complete

    0-100%

    RDS for PostgreSQL instance

    1 minute

    io_read_delay

    Read I/O Latency

    Average latency (in milliseconds) of disks responding to read requests

    ≥ 0 ms

    RDS for PostgreSQL instance

    1 minute

    io_write_delay

    Write I/O Latency

    Average latency (in milliseconds) of disks responding to write requests

    ≥ 0 ms

    RDS for PostgreSQL instance

    1 minute

    slow_sql_one_second

    Number of SQL Statements Executed for More Than 1s

    Number of slow SQL statements whose execution time is longer than 1s

    ≥ 0

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 10 and later versions are supported.

    1 minute

    slow_sql_three_second

    Number of SQL Statements Executed for More Than 3s

    Number of slow SQL statements whose execution time is longer than 3s

    ≥ 0

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 10 and later versions are supported.

    1 minute

    slow_sql_five_second

    Number of SQL Statements Executed for More Than 5s

    Number of slow SQL statements whose execution time is longer than 5s

    ≥ 0

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 10 and later versions are supported.

    1 minute

    slow_sql_log_min_duration_statement

    Number of SQL Statements Executed for More Than log_min_duration_statement

    Number of slow SQL statements whose execution time is longer than the value of log_min_duration_statement. You can change the value of this metric as required.

    ≥ 0

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 10 and later versions are supported.

    1 minute

    pg_dr_repl_stat

    Replication Status Between Primary DB Instance and DR Instance

    Replication status between the primary DB instance and DR instance. The value ranges from 0 to 5.

    • 0: abnormal
    • 1: startup
    • 2: catchup
    • 3: streaming
    • 4: backup
    • 5: stopping

    ≥ 0

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 12 is supported.

    1 minute

    pg_dr_wal_delay

    LSN Latency Between Primary DB Instance and DR Instance

    Latency between the LSN of the primary DB instance and the replay LSN of the DR instance

    ≥ 0 bytes/s

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 12 is supported.

    1 minute

    round_trip_time

    Network Latency Between Primary DB Instance and DR Instance

    RTT between the primary DB instance and DR instance

    ≥ 0 ms

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 12 is supported.

    1 minute

    packet_loss_rate

    Packet Loss Rate Between Primary DB Instance and DR Instance

    Packet loss rate between the primary DB instance and DR instance

    0-100%

    RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 12 is supported.

    1 minute

    inactive_logical_replication_slot

    Inactive Logical Replication Slots

    Number of inactive logical replication slots

    ≥ 0

    RDS for PostgreSQL instance

    1 minute

    pgaudit_log_size

    Audit Log Size

    Size of audit logs

    ≥ 0 GB

    RDS for PostgreSQL instance

    5 minutes

    slave_replication_status

    Stream Replication Status of Standby Node

    Stream replication status of the standby node. The value 0 indicates abnormal stream replication; 1 indicates normal stream replication; and 2 means that this node is the primary node.

    For this metric, the standby node also includes read replicas.

    Count

    RDS for PostgreSQL instance

    1 minute

    synchronous_replication_blocking_time

    Synchronous Replication Blocking Time

    Time during which synchronous replication between the primary and standby nodes is blocked

    ≥ 0s

    RDS for PostgreSQL instance

    1 minute

    temporary_files_generation_num

    Temporary Files per Minute

    Number of temporary files generated within 1 minute

    ≥ 0 counts/min

    RDS for PostgreSQL instance

    1 minute

    temporary_files_generation_size

    Temporary File Size per Minute

    Size of temporary files generated within 1 minute

    ≥ 0 bytes/min

    RDS for PostgreSQL instance

    1 minute

    sent_lsn_replication_latency_size

    Size of Not Sent WAL

    Size of WAL logs that have not been sent from the primary node to the standby node

    ≥ 0 bytes

    RDS for PostgreSQL read replica

    1 minute

    write_lsn_replication_latency_size

    Size of Not Written WAL

    Size of WAL logs that have not been written to the disk by the standby node

    ≥ 0 bytes

    RDS for PostgreSQL read replica

    1 minute

    flush_lsn_replication_latency_size

    Size of Not Flushed WAL

    Size of WAL logs that have not been flushed to the disk by the standby node

    ≥ 0 bytes

    RDS for PostgreSQL read replica

    1 minute

    replay_lsn_replication_latency_size

    Size of Not Replayed WAL

    Size of WAL logs that have not been replayed by the standby node

    ≥ 0 bytes

    RDS for PostgreSQL read replica

    1 minute

Dimension

Key

Value

postgresql_instance_id

RDS for PostgreSQL DB instance ID