Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Situation Awareness
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
SoftWare Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive

Configuring Displayed Metrics

Updated on 2024-10-24 GMT+08:00

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

    read_count_per_second

    Read IOPS

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

    ≥ 0 counts/s

    RDS for PostgreSQL instance

    1 minute

    write_count_per_second

    Write IOPS

    Average number of write 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

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

    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.

    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

    data_disk_inode_used

    Inodes

    Used data disk inodes

    ≥ 0 Counts

    RDS for PostgreSQL instance

    5 minutes

    user_current_connections

    Connections in Use

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

    ≥ 0 Counts

    RDS for PostgreSQL instance

    1 minute

    user_active_connections

    Active Connections

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

    ≥ 0 Counts

    RDS for PostgreSQL instance

    1 minute

    wal_size

    WAL Size

    Size of WAL logs

    ≥ 0 GB

    RDS for PostgreSQL instance

    5 minutes

    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.

    ≥ 0 s

    RDS for PostgreSQL instance

    5 minutes

    sys_memory_hit_rate

    Memory Hit Rate

    Memory hit rate

    ≥ 0 %

    RDS for PostgreSQL instance

    1 minute

Dimension

Key

Value

postgresql_cluster_id

RDS for PostgreSQL DB instance ID

We use cookies to improve our site and your experience. By continuing to browse our site you accept our cookie policy. Find out more

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback