RDS Monitoring Metrics Description

Function Description

This section describes namespaces, descriptions, and dimensions of monitoring metrics to be reported to Cloud Eye. Users can retrieve monitoring metrics and alarm information reported to Cloud Eye over its API.

Namespace

SYS.RDS

Monitoring Metrics

Table 1 RDS performance metrics

Metric

Name

Description

Value Range

Remarks

rds001_cpu_util

CPU Usage

CPU usage of the monitored object

0%-100%

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds002_mem_util

Memory Usage

Memory usage of the monitored object

0%-100%

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds003_iops

IOPS

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

>= 0 count/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds004_bytes_in

Network Input Throughput

Incoming traffic in bytes per second

>= 0 byte/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds005_bytes_out

Network Output Throughput

Outgoing traffic in bytes per second

>= 0 byte/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds006_conn_count

Total Connections

Total number of connections that attempt to connect to the MySQL server

>= 0 counts

Monitored object: database

Monitored instance type: MySQL instances

rds007_conn_active_count

Current Active Connections

Number of current active connections

>= 0 counts

Monitored object: database

Monitored instance type: MySQL instances

rds008_qps

QPS

Query times of SQL statements (including storage procedures) per second

>= 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds009_tps

TPS

Execution times of submitted and rollback transactions per second

>= 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds010_innodb_buf_usage

Buffer Pool Usage

Ratio of dirty data to all data in the InnoDB buffer

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds011_innodb_buf_hit

Buffer Pool Hit Rate

Ratio of read hits to read requests in the InnoDB buffer

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds012_innodb_buf_dirty

Buffer Pool Dirty Block Rate

Ratio of used pages to total pages in the InnoDB buffer

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds013_innodb_reads

InnoDB Read Throughput

Number of read bytes per second in the InnoDB buffer

>= 0 byte/s

Monitored object: database

Monitored instance type: MySQL instances

rds014_innodb_writes

InnoDB Write Throughput

Number of write bytes per second in the InnoDB buffer

>= 0 byte/s

Monitored object: database

Monitored instance type: MySQL instances

rds015_innodb_read_count

InnoDB File Read Frequency

Number of times that InnoDB reads data from files per second

>= 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds016_innodb_write_count

InnoDB File Write Frequency

Number of times that InnoDB writes data to files per second

>= 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds017_innodb_log_write_req_count

InnoDB Log Write Requests per Second

Number of InnoDB log write requests per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds018_innodb_log_write_count

InnoDB Log Physical Write Frequency

Number of InnoDB physical write times to log files per second

>= 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds019_innodb_log_fsync_count

InnoDB Log fsync() Write Frequency

Number of completed fsync() write times to InnoDB log files per second

>= 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds020_temp_tbl_rate

Temporary Tables Created per Second

Number of temporary tables created on hard disks per second

>= 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds021_myisam_buf_usage

Key Buffer Usage

MyISAM key buffer usage

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds022_myisam_buf_write_hit

Key Buffer Write Hit Ratio

MyISAM key buffer write hit ratio

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds023_myisam_buf_read_hit

Key Buffer Read Hit Ratio

MyISAM key buffer read hit ratio

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds024_myisam_disk_write_count

MyISAM Disk Write Frequency

Number of times that indexes are written to disks per second

>= 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds025_myisam_disk_read_count

MyISAM Disk Read Frequency

Number of times that indexes are read from disks per second

>= 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds026_myisam_buf_write_count

MyISAM Buffer Pool Write Requests per Second

Number of requests for writing indexes into the MyISAM buffer pool per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds027_myisam_buf_read_count

MyISAM Buffer Pool Read Requests per Second

Number of requests for reading indexes from the MyISAM buffer pool per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds028_comdml_del_count

DELETE Statements per Second

Number of DELETE statements executed per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds029_comdml_ins_count

INSERT Statements per Second

Number of INSERT statements executed per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds030_comdml_ins_sel_count

INSERT_SELECT Statements per Second

Number of INSERT_SELECT statements executed per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds031_comdml_rep_count

REPLACE Statements per Second

Number of REPLACE statements executed per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds032_comdml_rep_sel_count

REPLACE_SELECTION Statements per Second

Number of REPLACE_SELECTION statements executed per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds033_comdml_sel_count

SELECT Statements per Second

Number of SELECT statements executed per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds034_comdml_upd_count

UPDATE Statements per Second

Number of UPDATE statements executed per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds035_innodb_del_row_count

Row Delete Frequency

Number of rows deleted from the InnoDB table per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds036_innodb_ins_row_count

Row Insert Frequency

Number of rows inserted into the InnoDB table per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds037_innodb_read_row_count

Row Read Frequency

Number of rows read from the InnoDB table per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds038_innodb_upd_row_count

Row Update Frequency

Number of rows updated into the InnoDB table per second

>= 0 count/s

Monitored object: database

Monitored instance type: MySQL instances

rds039_disk_util

Storage Space Usage

Storage space usage of the monitored object

0%-100%

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds040_transaction_logs_usage

Transaction Logs Usage

Storage space usage of transaction logs

>= 0 MB

Monitored object: database

Monitored instance type: PostgreSQL instances

rds041_replication_slot_usage

Replication Slot Usage

Storage space usage of replication slot files

>= 0 MB

Monitored object: database

Monitored instance type: PostgreSQL instances

rds042_database_connections

Database Connections in Use

Number of database connections in use

>= 0 counts

Monitored object: database

Monitored instance type: PostgreSQL instances

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: PostgreSQL instances

rds044_transaction_logs_generations

Transaction Logs Generation

Size of transaction logs generated per second

>= 0 MB/s

Monitored object: database

Monitored instance type: PostgreSQL instances

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: PostgreSQL instances

rds046_replication_lag

Replication Lag

Replication lag delay

>= 0 ms

Monitored object: database

Monitored instance type: PostgreSQL instances

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: PostgreSQL instances

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: PostgreSQL instances

rds047_disk_total_size

Total Storage Space

Total storage space of the monitored object

40-4000 GB

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds048_disk_used_size

Used Storage Space

Used storage space of the monitored object

0-4000 GB

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds049_disk_read_throughput

Disk Read Throughput

Number of bytes read from the disk per second

>= 0 byte/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds050_disk_write_throughput

Disk Write Throughput

Number of bytes written into the disk per second

>= 0 byte/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL

  • PostgreSQL

  • Microsoft SQL Server

rds054_db_connections_in_use

Database Connections in Use

Number of database connections in use

>= 0 counts

Monitored object: database

Monitored instance type: Microsoft SQL Server instances

rds075_avg_disk_ms_per_read

Disk Read Time

Average time required for each disk read in a specified period

>= 0 ms

Monitored object: ECS

Monitored instance type: MySQL instance

rds076_avg_disk_ms_per_write

Disk Write Time

Average time required for each disk write in a specified period

>= 0 ms

Monitored object: ECS

Monitored instance type: MySQL instance

rds077_vma

VMA

Virtual memory area size of an RDS process

>= 0 counts

Monitored object: ECS

Monitored instance type: MySQL instance

rds078_threads

Threads

Number of threads in a process

>= 0 counts

Monitored object: ECS

Monitored instance type: MySQL instance

rds079_vm_hwm

Peak Resident Set Size

Peak physical memory usage of an RDS process

>= 0 KB

Monitored object: ECS

Monitored instance type: MySQL instance

rds080_vm_peak

Peak Virtual Memory Size

Peak virtual memory usage of an RDS process

>= 0 KB

Monitored object: ECS

Monitored instance type: MySQL instance

rds081_vm_ioutils

Disk I/O Usage

Percentage of CPU time during which I/O requests were issued to the device

0-100%

Monitored object: ECS

Monitored instance type: MySQL instance

rds082_semi_sync_tx_avg_wait_time

Transaction Wait Time

Average wait time of transactions in semi-synchronous mode

>= 0 microseconds

Monitored object: ECS

Monitored instance type: MySQL instance

rds072_conn_usage

Connection Usage

Percent of used MySQL connections to the total number of connections

0-100%

Monitored object: ECS.

Monitored DB instance type: MySQL instance

rds073_replication_delay

Real-Time Replication Delay

Real-time replication delay between standby DB instances or read replicas and primary DB instances, corresponding to seconds_behind_master

>= 0 s

Monitored object: ECS

Monitored instance type: MySQL instance

rds074_slow_queries

Slow Query Logs

Number of slow query logs generated per minute by RDS for MySQL

>= 0 counts/min

Monitored object: ECS

Monitored instance type: MySQL instance

rds_bytes_recv_rate

Received Bytes per Second

Number of bytes received by the database per second

>= 0 bytes/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_bytes_sent_rate

Sent Bytes per Second

Number of bytes sent from the database per second

>= 0 bytes/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_created_tmp_tables_rate

Temporary Tables Created per Second

Number of temporary tables created per second

>= 0 counts/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_buffer_pool_pages_flushed_rate

Innodb_buffer_pool Page Flushes per Second

Number of innodb_buffer_pool page flushes per second

>= 0 counts/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_buffer_pool_read_requests_rate

Innodb_buffer_pool Read Requests per Second

Number of innodb_buffer_pool read requests per second

>= 0 counts/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_buffer_pool_write_requests_rate

Innodb_buffer_pool Write Requests per Second

Number of innodb_buffer_pool write requests per second

>= 0 counts/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_lock_waits

Row Locks Waits

Number of InnoDB row lock waits

This metric indicates the total number of historical transactions waiting for row locks. Lock waits will be cleared after the instance is rebooted.

>= 0 counts

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_log_waits_rate

Flush Times to Disks Due to Insufficient Log Buffer

Times of transaction logs flushed to disks due to insufficient log buffer

>= 0 counts/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_os_log_written_rate

Redo Log Size Written per Second

Size of redo logs written per second

>= 0 bytes/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_pages_read_rate

Data Volume Read By InnoDB per Second

Data volume read by InnoDB per second

>= 0 Pages/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_pages_written_rate

Data Volume Written by InnoDB per Second

Data volume written by InnoDB per second

>= 0 Pages/s

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_row_lock_current_waits

Current Row Lock Waits

Number of current InnoDB row lock waits

This metric indicates the number of transactions that are currently waiting for row locks.

>= 0 counts

Monitored object: ECS

Monitored instance type: MySQL instance

rds_innodb_row_lock_time_avg

Historical InnoDB Row Lock Average Wait Time

Historical average time to acquire a row lock for InnoDB tables

> 0 ms

Monitored object: ECS

Monitored instance type: MySQL instance

rds_wait_thread_count

Waiting Threads

Number of waiting threads

>= 0 counts

Monitored object: ECS

Monitored instance type: MySQL instance

sys_swap_usage

SWAP Usage

SWAP usage of the monitored object

0-100%

Monitored object: ECS

Monitored instance type: MySQL instance

rds_mdl_lock_count

MDL Locks

Number of MDL locks

>= 0 counts

Monitored object: ECS

Monitored instance type: MySQL instance

Note

This metric can be queried only by rds_cluster_id.

rds_buffer_pool_wait_free

Dirty Pages to Be Flushed to Disks

When InnoDB needs to read or create a page and no clean pages are available, InnoDB flushes some dirty pages first and waits for that operation to finish. This counter counts instances of these waits.

>= 0 counts

Monitored object: ECS

Monitored instance type: MySQL instance

Note

This metric can be queried only by rds_cluster_id.

rds_conn_active_usage

Active Connection Usage

Usage of active connections

0-100%

Monitored object: ECS

Monitored instance type: MySQL instance

Note

This metric can be queried only by rds_cluster_id.

rds_innodb_log_waits_count

Log Buffer Status

Number of times that the log buffer was too small and a wait was required for it to be flushed before continuing

>= 0 counts

Monitored object: ECS

Monitored instance type: MySQL instance

Note

This metric can be queried only by rds_cluster_id.

rds_long_transaction

Long Transaction

Maximum duration for starting a transaction

A complete long transaction is counted only when the BEGIN and COMMIT commands exist before and after the related operation commands, respectively.

>= 0 seconds

Monitored object: ECS

Monitored instance type: MySQL instance

Note

This metric can be queried only by rds_cluster_id.

rds173_replication_delay_avg

Average Replication Delay

Average replication delay within 60s between standby DB instances or read replicas and primary DB instances, corresponding to seconds_behind_master

>= 0 s

Monitored object: ECS

Monitored instance type: MySQL instance

Note

This metric can be queried only by rds_cluster_id.

rds055_transactions_per_sec

Transactions per Second

Number of transactions started for the database per second

>= 0 counts/s

Microsoft SQL Server instance

rds056_batch_per_sec

Batches per Second

Number of Transact-SQL command batches received per second

>= 0 counts/s

Microsoft SQL Server instance

rds057_logins_per_sec

Logins per Second

Total number of logins started per second

>= 0 counts/s

Microsoft SQL Server instance

rds058_logouts_per_sec

Logouts per Second

Total number of logouts started per second

>= 0 counts/s

Microsoft SQL Server instance

rds059_cache_hit_ratio

Cache Hit Ratio

Ratio of pages found in the buffer cache without having to read from the disk to total pages

0%-100%

Microsoft SQL Server instance

rds060_sql_compilations_per_sec

SQL Compilations per Second

Number of SQL compilations per second

>= 0 counts/s

Microsoft SQL Server instance

rds061_sql_recompilations_per_sec

SQL Recompilations per Second

Number of SQL recompilations per second

>= 0 counts/s

Microsoft SQL Server instance

rds062_full_scans_per_sec

Full Scans per Second

Number of unrestricted full scans per second

>= 0 counts/s

Microsoft SQL Server instance

rds063_errors_per_sec

Errors per Second

Number of errors per second

>= 0 counts/s

Microsoft SQL Server instance

rds064_latch_waits_per_sec

Latch Waits per Second

Number of latch requests that have not been granted immediately

>= 0 counts/s

Microsoft SQL Server instance

rds065_lock_waits_per_sec

Lock Waits per Second

Number of lock wait requests per second

>= 0 counts/s

Microsoft SQL Server instance

rds066_lock_requests_per_sec

Lock Requests per Second

Number of new locks and lock conversions per second requested from the lock manager

>= 0 counts/s

Microsoft SQL Server instance

rds067_timeouts_per_sec

Lock Timeouts per Second

Number of lock timeouts per second

>= 0 counts/s

Microsoft SQL Server instance

rds068_avg_lock_wait_time

Average Lock Wait Time

Average wait time (ms) of lock requests

>= 0 ms

Microsoft SQL Server instance

rds069_deadlocks_per_sec

Deadlocks per Second

Number of deadlocks per second

>= 0 counts/s

Microsoft SQL Server instance

rds070_checkpoint_pages_per_sec

Checkpoint Pages per Second

Number of pages flushed to the disk per second by a checkpoint or other operations that require all dirty pages to be flushed

>= 0 counts/s

Microsoft SQL Server instance

rds077_replication_delay

Replication Delay

Delay for replication between primary and standby DB instances. The replication delay of RDS for SQL Server DB instances is at the database level because data is synchronized on each database. The instance-level replication delay refers to the maximum replication delay of the databases (the delay 0s for single DB instances).

>= 0s

Microsoft SQL Server instance

mssql_mem_grant_pending

Memory Grants Pending

Total number of processes waiting for a workspace memory grant

>=0 counts

Microsoft SQL Server instance

mssql_lazy_write_per_sec

Lazy Writes per Second

Number of lazy writes per second

>= 0 counts/s

Microsoft SQL Server instance

mssql_page_life_expectancy

Page Life Expectancy

Number of seconds a page will stay in the buffer pool without references

>= 0s

Microsoft SQL Server instance

mssql_page_reads_per_sec

Page Reads per Second

Number of page reads per second

>= 0 counts/s

Microsoft SQL Server 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

RDS for PostgreSQL instance

Note

Only RDS for PostgreSQL 10 and later versions are supported.

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.

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.

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.

row_per_second

Operation Rows

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

>= 0

RDS for PostgreSQL instance

rds083_conn_usage

Connection Usage

Percent of used PostgreSQL connections to the total number of connections

0-100%

RDS for PostgreSQL instance

rds082_tps

TPS

Execution times of submitted and rollback transactions per second

>= 0 counts/s

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

RDS for PostgreSQL instance

Note

This metric can be queried only by postgresql_cluster_id.

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

Note

This metric can be queried only by postgresql_cluster_id.

swap_total_size

Total Swap Size

Total size of the swap partition

>= 0 MB

RDS for PostgreSQL instance

Note

This metric can be queried only by postgresql_cluster_id.

swap_usage

Swap Usage

Usage of the swap partition

0-100%

RDS for PostgreSQL instance

Note

This metric can be queried only by postgresql_cluster_id.

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.

  • This metric can be queried only by postgresql_cluster_id.

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

Note

This metric can be queried only by postgresql_cluster_id.

lock_waiting_sessions

Sessions Waiting for Locks

Number of blocked sessions

>= 0

RDS for PostgreSQL instance

Note

This metric can be queried only by postgresql_cluster_id.

io_read_delay

Read I/O Latency

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

>= 0 ms

RDS for PostgreSQL instance

Note

This metric can be queried only by postgresql_cluster_id.

io_write_delay

Write I/O Latency

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

>= 0 ms

RDS for PostgreSQL instance

Note

This metric can be queried only by postgresql_cluster_id.

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.

  • This metric can be queried only by postgresql_cluster_id.

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

Note

This metric can be queried only by postgresql_cluster_id.

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

Note

This metric can be queried only by postgresql_cluster_id.

cpu_user_usage

User-mode CPU Time Percentage

Percentage of time that the CPU is in user mode

0-100%

RDS for PostgreSQL instance

Note

This metric can be queried only by postgresql_cluster_id.

cpu_sys_usage

Kernel-mode CPU Time Percentage

Percentage of time that the CPU is in kernel mode

0-100%

RDS for PostgreSQL instance

Note

This metric can be queried only by postgresql_cluster_id.

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

Note

This metric can be queried only by postgresql_cluster_id.

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.

  • This metric can be queried only by postgresql_cluster_id.

Dimension

Key

Value

rds_cluster_id

RDS for MySQL DB instance ID

rds_instance_id

RDS for MySQL Node ID

postgresql_cluster_id

RDS for PostgreSQL DB instance ID

postgresql_instance_id

RDS for PostgreSQL Node ID

rds_cluster_sqlserver_id

RDS for SQL Server DB instance ID

rds_instance_sqlserver_id

RDS for SQL Server Node ID

API Calling

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

Examples:

  • Request

/V1.0/{project_id}/metric-data?namespace=SYS.RDS&metric_name=rds001_cpu_usage&dim.0=rds_instance_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_usage",
    "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"
}
}