Updated on 2025-09-01 GMT+08:00

RDS for PostgreSQL Metrics

Description

This section describes namespaces, descriptions, and dimensions of metrics reported by RDS for PostgreSQL to Cloud Eye. You can use APIs provided by Cloud Eye to retrieve metrics and alarms generated for RDS for PostgreSQL.

Namespace

SYS.RDS

Metrics

Table 1 RDS for PostgreSQL metrics

Metric ID

Name

Description

Value Range

Monitored Object and Instance Type

rds001_cpu_util

CPU Usage

CPU usage of the monitored object

0–100%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds002_mem_util

Memory Usage

Memory usage of the monitored object

0–100%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds003_iops

IOPS

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

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

read_count_per_second

Read IOPS

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

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

write_count_per_second

Write IOPS

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

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds004_bytes_in

Network Input Throughput

Incoming traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds005_bytes_out

Network Output Throughput

Outgoing traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds039_disk_util

Storage Space Usage

Storage space usage of the monitored object

0–100%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds040_transaction_logs_usage

Transaction Logs Usage

Storage space usage of transaction logs

≥ 0 MB

Monitored object: database

Monitored instance type: RDS for PostgreSQL instance

rds041_replication_slot_usage

Replication Slot Usage

Storage space usage of replication slot files

≥ 0 MB

Monitored object: database

Monitored instance type: RDS for PostgreSQL instance

rds042_database_connections

Database Connections in Use

Number of database connections in use

≥ 0 counts

Monitored object: database

Monitored instance type: RDS for PostgreSQL instance

rds043_maximum_used_transaction_ids

Maximum Used Transaction IDs

Maximum number of transaction IDs that have been used

≥ 0 counts

Monitored object: database

Monitored instance type: RDS for PostgreSQL instance

rds044_transaction_logs_generations

Transaction Logs Generation

Size of transaction logs generated per second

≥ 0 MB/s

Monitored object: database

Monitored instance type: RDS for PostgreSQL instance

rds045_oldest_replication_slot_lag

Oldest Replication Slot Lag

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

≥ 0 MB

Monitored object: database

Monitored instance type: RDS for PostgreSQL instance

rds046_replication_lag

Replication Lag

Replication lag

≥ 0 ms

Monitored object: database

Monitored instance type: RDS for PostgreSQL instance

rds047_disk_total_size

Total Storage Space

Total storage space of the monitored object

40–4000, in GB

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds048_disk_used_size

Used Storage Space

Used storage space of the monitored object

0–4000, in GB

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds049_disk_read_throughput

Disk Read Throughput

Number of bytes read from the disk per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds050_disk_write_throughput

Disk Write Throughput

Number of bytes written into the disk per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

ds082_tps

TPS

Execution times of submitted and rollback transactions per second

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

rds083_conn_usage

Connection Usage

Percent of used PostgreSQL connections to the total number of connections

0–100%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

row_per_second

Operation Rows

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

≥ 0

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

active_connections

Active Connections

Number of active database connections

≥ 0

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

idle_transaction_connections

Idle Transaction Connections

Number of idle transaction connections

≥ 0

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

lock_waiting_sessions

Sessions Waiting for Locks

Number of blocked sessions

≥ 0

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

swap_in_rate

Swap-In Rate

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

≥ 0 KB/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

swap_out_rate

Swap-Out Rate

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

≥ 0 KB/s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

swap_total_size

Total Swap Size

Total size of the swap partition

≥ 0 MB

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

swap_usage

Swap Usage

Usage of the swap partition

0–100%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

cpu_user_usage

User-mode CPU Time Percentage

Percentage of time that the CPU is in user mode

0–100%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

cpu_sys_usage

Kernel-mode CPU Time Percentage

Percentage of time that the CPU is in kernel mode

0–100%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

io_read_delay

Read I/O Latency

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

≥ 0 ms

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

io_write_delay

Write I/O Latency

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

≥ 0 ms

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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 counts

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

round_trip_time

Network Latency Between Primary DB Instance and DR Instance

RTT between the primary DB instance and DR instance

≥ 0 ms

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

inactive_logical_replication_slot

Inactive Logical Replication Slots

Number of inactive logical replication slots

≥ 0

Monitored object: database

Monitored instance type: RDS for PostgreSQL instance

pgaudit_log_size

Audit Log Size

Size of audit logs

≥ 0 GB

Monitored object: database

Monitored instance type: RDS for PostgreSQL instance

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.

  • 0
  • 1
  • 2

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

synchronous_replication_blocking_time

Synchronous Replication Blocking Time

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

≥ 0s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

temporary_files_generation_num

Temporary Files per Minute

Number of temporary files generated within 1 minute

≥ 0 counts/min

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

temporary_files_generation_size

Temporary File Size per Minute

Size of temporary files generated within 1 minute

≥ 0 bytes/min

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

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

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

data_disk_inode_used

Inodes

Used data disk inodes

≥ 0 counts

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

user_current_connections

Connections in Use

Number of connections in use (excluding built-in connections used for monitoring and O&M)

≥ 0 counts

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

user_active_connections

Active Connections of Users

Number of active connections used by users (excluding built-in active connections used for monitoring and O&M)

≥ 0 counts

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

wal_size

WAL Size

Size of WAL logs

≥ 0 GB

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

dbuser_passwd_deadline

The fastest expiration time for database users

Database user password expiration time minus current time

NOTE:

If no password expiration time is set, this metric cannot be collected.

≥ 0s

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

sys_memory_hit_rate

Memory Hit Rate

Memory hit rate

≥ 0%

Monitored object: ECS

Monitored instance type: RDS for PostgreSQL instance

Dimension

Key

Value

postgresql_cluster_id

RDS for PostgreSQL instance ID

API Calling

Use APIs to search for RDS monitoring metrics. For details about calling methods and parameter description, see Querying Monitoring Data in the Cloud Eye API Reference.

Examples:

  • Request
/V1.0/{project_id}/metric-data?namespace=SYS.RDS&metric_name=rds001_cpu_util&dim.0=rds_cluster_id,5ea170ad-cc6b-49cd-9020-e94fdbeea391&from=1484123686000&to=1568188853000&period=300&filter=average
  • Response:
{
    "datapoints": [
        {
            "average": 0.35, 
            "timestamp": 1484123400000, 
            "unit": "Ratio"
        },
        {
            "average": 0.11, 
            "timestamp": 1484123700000, 
            "unit": "Ratio"
        }
    ], 
    "metric_name": "rds001_cpu_util",
    "httpcode" : 200,
    "header" : {
    "Transfer-Encoding" : "chunked",
    "Server" : "Web Server",
    "X-Request-Id" : "te-I-CES-APISVR25.id-0418d62a-1e76-46ff-9a5f-9ce40b336e29.ts-1484123744291.c-15046",
    "X-Content-Type-Options" : "nosniff",
    "Connection" : "keep-alive",
    "X-Download-Options" : "noopen",
    "Date" : "Wed, 11 Jan 2017 08:35:44 GMT",
    "X-Frame-Options" : "DENY",
    "Strict-Transport-Security" : "max-age=31536000; includeSubdomains;",
    "Cache-Control" : "no-cache",
    "X-XSS-Protection" : "1; mode=block;",
    "Content-Length" : "165",
    "Content-Type" : "application/json"
}
}