Relational Database ServiceRelational Database Service

Compute
Elastic Cloud Server
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
Domain Name Service
VPC Endpoint
Cloud Connect
Enterprise Switch
Security & Compliance
Anti-DDoS
Web Application Firewall
Host Security Service
Data Encryption Workshop
Database Security Service
Advanced Anti-DDoS
Data Security Center
Container Guard Service
Situation Awareness
Managed Threat Detection
Compass
Cloud Certificate Manager
Anti-DDoS Service
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GaussDB NoSQL
GaussDB(for MySQL)
Distributed Database Middleware
GaussDB(for openGauss)
Developer Services
ServiceStage
Distributed Cache Service
Simple Message Notification
Application Performance Management
Application Operations Management
Blockchain Service
API Gateway
Cloud Performance Test Service
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
DevCloud
ProjectMan
CodeHub
CloudRelease
CloudPipeline
CloudBuild
CloudDeploy
Cloud Communications
Message & SMS
Cloud Ecosystem
Marketplace
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP License Service
Support Plans
Customer Operation Capabilities
Partner Support Plans
Professional Services
enterprise-collaboration
Meeting
IoT
IoT
Intelligent EdgeFabric
DeveloperTools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Updated at: Apr 02, 2022 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%

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    rds002_mem_util

    Memory Usage

    Memory usage of the monitored object

    0-100%

    Monitored object: ECS

    Monitored instance type: 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

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    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

    1 minute

    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

    1 minute

    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

    1 minute

    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

    1 minute

    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

    1 minute

    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

    1 minute

    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

    1 minute

    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

    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

    Monitored object: database

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    rds046_replication_lag

    Replication Lag

    Replication lag

    ≥ 0 ms

    Monitored object: database

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    rds047_disk_total_size

    Total Storage Space

    Total storage space of the monitored object

    40–4,000 GB

    If you want to create a DB instance with storage up to 15,000 GB, contact customer service to apply for the required permission.

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    rds048_disk_used_size

    Used Storage Space

    Used storage space of the monitored object

    0–4,000 GB

    If you want to create a DB instance with storage up to 15,000 GB, contact customer service to apply for the required permission.

    Monitored object: ECS

    Monitored instance type: 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

    Monitored object: ECS

    Monitored instance type: 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

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    rds082_tps

    TPS

    Execution times of submitted and rollback transactions per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    rds083_conn_usage

    Connection Usage

    Percent of used PostgreSQL connections to the total number of connections

    0-100%

    Monitored object: database

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    row_per_second

    Operation Rows

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

    ≥ 0

    Monitored object: database

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    active_connections

    Active Connections

    Number of active database connections

    ≥ 0

    Monitored object: database

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    disk_io_usage

    Disk I/O Usage

    I/O usage of disks

    0-100%

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    lock_waiting_sessions

    Sessions Waiting for Locks

    Number of blocked sessions

    ≥ 0

    Monitored object: database

    Monitored instance type: 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

    Monitored object: ECS

    Monitored instance type: 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

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    swap_total_size

    Total Swap Size

    Total size of the swap partition

    ≥ 0 MB

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL instance

    1 minute

    swap_usage

    Swap Usage

    Usage of the swap partition

    0-100%

    Monitored object: ECS

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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%

    Monitored object: ECS

    Monitored instance type: 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%

    Monitored object: ECS

    Monitored instance type: 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%

    Monitored object: ECS

    Monitored instance type: 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

    Monitored object: ECS

    Monitored instance type: 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

    Monitored object: ECS

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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

    Monitored object: database

    Monitored instance type: 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%

    Monitored object: database

    Monitored instance type: RDS for PostgreSQL instance

    NOTE:

    Only RDS for PostgreSQL 12 is supported.

    1 minute

  • Table 2 lists the metrics of RDS for PostgreSQL database proxy.
    Table 2 RDS for PostgreSQL database proxy 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%

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

    rds002_mem_util

    Memory Usage

    Memory usage of the monitored object

    0-100%

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

    rds004_bytes_in

    Network Input Throughput

    Incoming traffic in bytes per second

    ≥ 0 bytes/s

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

    rds005_bytes_out

    Network Output Throughput

    Outgoing traffic in bytes per second

    ≥ 0 bytes/s

    Monitored object: ECS

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

    max_conn

    Total Connections

    Maximum number of PostgreSQL proxy connections. The value is the total number of lines in the show pool_pools command output, or the product of num_init_children, max_pool, and nodes.

    ≥ 0 counts

    Monitored object: PostgreSQL proxy

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

    active_conn

    Active Connections

    Number of frontend connections. The value is the total number of lines where pool_connected is 1 in the show pool_pools command output.

    ≥ 0 counts

    Monitored object: PostgreSQL proxy

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

    idle_conn

    Idle Connections

    Number of connections established only between the PostgreSQL proxy and databases. The value is the total number of lines where pool_backendpid is not 0 and pool_connected is 0 in the show pool_pools command output.

    ≥ 0 counts

    Monitored object: PostgreSQL proxy

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

    unused_conn

    Unused Connections

    Number of connections that are neither established between the PostgreSQL proxy and databases nor established between the PostgreSQL proxy and clients. The value is the total number of lines where pool_backendpid is 0 and pool_connected is 0 in the show pool_pools command output.

    ≥ 0 counts

    Monitored object: PostgreSQL proxy

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

    pool_counter

    Connection Usage Times

    Number of times the client uses connection pools. The value is the sum of the pool_counter values in the show pool_pools command output.

    ≥ 0 counts

    Monitored object: PostgreSQL proxy

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

    master_slave_read_ratio

    Read Ratio of Primary Node

    Proportion of read queries on an RDS for PostgreSQL primary DB instance. The default value is 0.

    0-100%

    Monitored object: PostgreSQL proxy

    Monitored instance type: RDS for PostgreSQL proxy instance

    1 minute

Dimension

Key

Value

postgresql_cluster_id

RDS for PostgreSQL DB instance ID

dbproxy_instance_id

RDS for PostgreSQL proxy instance ID

dbproxy_node_id

RDS for PostgreSQL proxy node ID

Did you find this page helpful?

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel