Supported Metrics of GaussDB
Description
This section describes metrics reported by GaussDB as well as their namespaces and dimensions.
Namespace
SYS.GAUSSDBV5
Metric Collection Constraints
- Standby DNs of distributed instances: Metric data can be collected only when the instance version is V2.0-3.100.0 or later, and the transaction consistency must be eventual consistency.
- Standby DNs of centralized instances: Metric data can be collected only when the instance version is V2.0-2.0.10 or later
Supported Metrics
The following table lists the performance metrics of GaussDB.
|
Metric ID |
Metric |
Description |
Display Object |
Unit |
Monitored Object |
Monitoring Period (Raw Data) |
|---|---|---|---|---|---|---|
|
rds001_cpu_util |
CPU Usage |
CPU usage of the monitored object |
Current node |
% |
Node |
60s |
|
rds002_mem_util |
Memory Usage |
Memory usage of the monitored object |
Current node |
% |
Node |
60s |
|
rds003_bytes_in |
Data Write Volume |
Average number of bytes sent by the VM of the monitored object in a measurement period |
Current node |
Byte/s |
Node |
60s |
|
rds004_bytes_out |
Outgoing Data Volume |
Average number of bytes received by the VM of the monitored object in a measurement period |
Current node |
Byte/s |
Node |
60s |
|
rds014_iops |
Disk IOPS |
Real-time value of data disk reads and writes per second of the monitored node |
Current node |
Count/s |
Node |
60s |
|
rds016_disk_write_throughput |
Disk Write Throughput |
Real-time write throughput per second of the data disk on the monitored node |
Current node |
Byte/s |
Node |
60s |
|
rds017_disk_read_throughput |
Disk Read Throughput |
Real-time read throughput per second of the data disk on the monitored node |
Current node |
Byte/s |
Node |
60s |
|
rds020_avg_disk_ms_per_write |
Time Required for per Data Disk Write |
Average time required for a data disk write on the monitored node in a measurement period |
Current node |
ms |
Node |
60s |
|
rds021_avg_disk_ms_per_read |
Time Required for per Data Disk Read |
Average time required for a data disk read on the monitored node in a measurement period |
Current node |
ms |
Node |
60s |
|
io_bandwidth_usage |
Disk I/O Bandwidth Usage |
Percentage of current disk I/O bandwidth |
Current node |
% |
Node |
60s |
|
iops_usage |
IOPS Usage |
Percentage of used IOPS in the total IOPS |
Current node |
% |
Node |
60s |
|
rds005_instance_disk_used_size |
Used Instance Disk Size |
Real-time used data disk size of the monitored instance |
Instance |
GB |
Instance |
60s |
|
rds006_instance_disk_total_size |
Total Instance Disk Size |
Real-time total data disk size of the monitored instance |
Instance |
GB |
Instance |
60s |
|
rds007_instance_disk_usage |
Instance Disk Usage |
Real-time data disk usage of the monitored instance |
Instance |
% |
Instance |
60s |
|
rds035_buffer_hit_ratio |
Buffer Hit Rate |
Buffer hit rate of the database |
Instance |
% |
Instance |
60s |
|
rds036_deadlocks |
Deadlocks |
Incremental number of database transaction deadlocks in a measurement period |
Instance |
Count |
Instance |
60s |
|
rds048_P80 |
Response Time of 80% SQL Statements |
Real-time response time of 80% of database SQL statements |
Instance |
us |
Instance |
60s |
|
rds049_P95 |
Response Time of 95% SQL Statements |
Real-time response time of 95% of database SQL statements |
Instance |
us |
Instance |
60s |
|
rds008_disk_used_size |
Used Disk Size |
Real-time used data disk size of the monitored node |
Current node |
GB |
Component |
60s |
|
rds009_disk_total_size |
Total Disk Size |
Real-time total data disk size of the monitored node |
Current node |
GB |
Component |
60s |
|
rds010_disk_usage |
Disk Usage |
Real-time data disk usage of the monitored node |
Current node |
% |
Component |
60s |
|
rds024_current_sleep_time |
Primary Node Flow Control Duration |
Real-time primary node flow control duration on the monitored node |
Distributed: standby DN Centralized: standby DN |
us |
Component |
60s |
|
rds025_current_rto |
Standby Node RTO |
Real-time Recovery Time Objective (RTO) of the primary/standby replication of the monitored node |
Distributed: standby DN Centralized: standby DN |
s |
Component |
60s |
|
rds026_login_counter |
User Logins per Second |
Average number of logins per second in a measurement period |
Distributed: all CNs Centralized: primary DN |
Count/s |
Component |
60s |
|
rds027_logout_counter |
User Logouts per Second |
Average number of logouts per second in a measurement period |
Distributed: all CNs Centralized: primary DN |
Count/s |
Component |
60s |
|
rds028_standby_delay |
Standby Node Redo Progress |
Real-time redo progress of the standby node in a shard. It indicates the difference of the redo progress between the primary and standby nodes. |
Distributed: standby DN Centralized: primary DN |
Byte |
Component |
60s |
|
rds030_wait_ratio |
Lock-Waiting Session Rate |
Real-time rate of lock waiting sessions to active sessions |
Distributed: all CNs + primary DN Centralized: all DNs |
% |
Component |
60s |
|
rds031_active_ratio |
Active Session Rate |
Real-time rate of active sessions to all sessions |
Distributed: all CNs + primary DN Centralized: all DNs |
% |
Component |
60s |
|
rds034_inuse_counter |
CN Connections |
Real-time number of in-use connections in the CN connection pool |
Distributed: all CNs Centralized: N/A |
Count |
Component |
60s |
|
rds037_commit_counter |
User Committed Transactions per Second |
Average number of transactions committed by users per second in a measurement period |
Distributed: all CNs Centralized: primary DN |
Count/s |
Component |
60s |
|
rds038_rollback_counter |
User Rollback Transactions per Second |
Average number of transactions rolled back by users per second in a measurement period |
Distributed: all CNs Centralized: primary DN |
Count/s |
Component |
60s |
|
rds039_bg_commit_counter |
Background Committed Transactions per Second |
Average number of transactions committed by the background per second in a measurement period |
Distributed: all CNs Centralized: primary DN |
Count/s |
Component |
60s |
|
rds040_bg_rollback_counter |
Background Rollback Transactions per Second |
Average number of transactions rolled back by the background per second in a measurement period |
Distributed: all CNs Centralized: primary DN |
Count/s |
Component |
60s |
|
rds041_resp_avg |
Average Response Time of User Transactions |
Average response time of user transactions |
Distributed: all CNs Centralized: primary DN |
us |
Component |
60s |
|
rds042_rollback_ratio |
User Transaction Rollback Rate |
Average rate of user rollback transactions to all user committed and rolled back transactions in a measurement period |
Distributed: all CNs Centralized: primary DN |
% |
Component |
60s |
|
rds043_bg_rollback_ratio |
Background Transaction Rollback Rate |
Average rate of background rollback transactions to all user committed and rolled back transactions in a measurement period |
Distributed: all CNs Centralized: primary DN |
% |
Component |
60s |
|
rds044_ddl_count |
Data Definition Language/s |
Average number of DDL statements in user load at the query layer in a measurement period |
Distributed: all CNs + all DNs Centralized: all DNs |
Count/s |
Component |
60s |
|
rds045_dml_count |
Data Manipulation Language/s |
Average number of DML statements in user load at the query layer in a measurement period |
Distributed: all CNs + all DNs Centralized: all DNs |
Count/s |
Component |
60s |
|
rds046_dcl_count |
Data Control Language/s |
Average number of DCL statements in user load at the query layer in a measurement period |
Distributed: all CNs + all DNs Centralized: all DNs |
Count/s |
Component |
60s |
|
rds047_ddl_dcl_ratio |
DDL and DCL Rate |
Average rate of DDL and DCL statements to DDL, DCL, and DML statements in user load at the query layer in a measurement period |
Distributed: all CNs + all DNs Centralized: all DNs |
% |
Component |
60s |
|
rds050_ckpt_delay |
Data Volume to Be Flushed to Disks |
Real-time amount of data to be flushed to disks during synchronization |
Distributed: all CNs + primary DN Centralized: primary DN |
Byte |
Component |
60s |
|
rds051_phyrds |
Physical Reads per Second |
Average number of physical reads per second in a measurement period |
Distributed: all CNs + primary DN Centralized: all DNs |
Count/s |
Component |
60s |
|
rds052_phywrts |
Physical Writes per Second |
Average number of physical writes per second in a measurement period |
Distributed: all CNs + primary DN Centralized: all DNs |
Count/s |
Component |
60s |
|
rds053_online_session |
Online Sessions |
Real-time number of online sessions |
Distributed: all CNs + all DNs Centralized: all DNs |
Count |
Component |
60s |
|
rds054_active_session |
Active Sessions |
Real-time number of active sessions |
Distributed: all CNs + primary DN Centralized: primary DN |
Count |
Component |
60s |
|
rds055_online_ratio |
Online Session Rate |
Real-time percentage of online sessions on a CN (of a distributed instance) or a primary DN (of a centralized instance) |
Distributed: all CNs + primary DN Centralized: all DNs |
% |
Component |
60s |
|
rds060_long_running_transaction_exectime |
Maximum Execution Duration of Database Transactions |
Maximum execution duration of database transactions |
Distributed: all CNs + primary DN Centralized: all DNs |
s |
Component |
60s |
|
rds066_replication_slot_wal_log_size |
WAL Log Size in the Replication Slot |
Real-time size of WAL logs reserved in the replication slot of a primary DN |
Distributed: primary DN Centralized: all DNs |
Byte |
Component |
60s |
|
rds067_xlog_lsn |
Xlog Rate |
Real-time rate of Xlogs on CNs or primary DNs |
Distributed: all CNs + primary DN Centralized: primary DN |
Byte/s |
Component |
60s |
|
rds068_swap_used_ratio |
Swap Memory Usage |
Real-time swap memory usage of the OS |
Current node |
% |
Node |
60s |
|
rds069_swap_total_size |
Total Swap Memory |
Real-time total swap memory size of the OS |
Current node |
MB |
Node |
60s |
|
rds070_thread_pool |
Thread Pool Usage |
Real-time thread pool usage on a CN and DN |
Distributed: all CNs + primary DN Centralized: all DNs |
% |
Component |
60s |
|
rds071_locks_session |
Sessions Waiting for Locks |
Number of sessions waiting for locks on a CN or primary DN. This metric is updated in real time |
Distributed: all CNs + primary DN Centralized: all DNs |
Count |
Component |
60s |
|
rds072_streaming_dr_xlog_gap |
Shard Log Gap of DR Cluster |
Log difference between shards in the DR cluster and shards in the production cluster when streaming DR is enabled |
Distributed: all CNs + primary DN Centralized: primary DN |
Byte |
Component |
60s |
|
rds073_streaming_dr_xlog_to_be_replayed |
Size of Shard Logs to Be Replayed in DR Cluster |
Size of the logs to be replayed of each shard in the DR cluster when streaming DR is enabled |
Distributed: all CNs + primary DN Centralized: primary DN |
Byte |
Component |
60s |
|
rds074_streaming_dr_xlog_flushing_rate |
Flushing Rate of Shard Logs in DR Cluster |
Rate at which logs of each shard in the DR cluster are flushed to disk when streaming DR is enabled |
Distributed: all CNs + primary DN Centralized: primary DN |
Byte/s |
Component |
60s |
|
rds075_streaming_dr_xlog_replay_rate |
Replay Rate of Shard Logs in DR Cluster |
Rate at which logs of each shard in the DR cluster are replayed when streaming DR is enabled |
Distributed: all CNs + primary DN Centralized: primary DN |
Byte/s |
Component |
60s |
|
rds076_streaming_dr_rpo |
Shard RPO |
Real-time RPO of each shard when streaming DR is enabled |
Distributed: all CNs + primary DN Centralized: primary DN |
s |
Component |
60s |
|
rds077_streaming_dr_rto |
Shard RTO |
Real-time RTO of each shard when streaming DR is enabled |
Distributed: all CNs + primary DN Centralized: primary DN |
s |
Component |
60s |
|
rds078_inactive_replication_slot |
Inactive Replication Slots |
Number of physical and logical replication slots that are inactive |
Distributed: all CNs + primary DN Centralized: all DNs |
Count |
Component |
60s |
|
rds079_standy_not_replayed_log |
Size of Read Replica Logs Not Replayed |
Difference between the number of replayed read replica logs and the number of received read replica logs |
Distributed: standby DN Centralized: standby DN |
Byte |
Component |
60s |
|
rds080_xlog_num |
Xlogs |
Real-time number of Xlogs in the data directory on a CN or DN |
Distributed: all CNs + all DNs Centralized: all DNs |
Count |
Component |
60s |
|
rds081_xlog_size |
Xlog Size |
Real-time size of Xlogs in the data directory on a CN or DN |
Distributed: all CNs + all DNs Centralized: all DNs |
MB |
Component |
60s |
|
rds064_dynamic_used_memory |
Used Dynamic Memory |
Real-time used dynamic memory of the monitored object |
Distributed: all CNs + all DNs Centralized: all DNs |
MB |
Component |
60s |
|
rds065_dynamic_used_memory_usage |
Dynamic Memory Usage |
Real-time dynamic memory usage of the monitored object |
Distributed: all CNs + all DNs Centralized: all DNs |
% |
Component |
60s |
|
rds061_idle_in_transaction_num |
Idle Transactions |
Real-time reporting of how many idle transactions there are for the monitored object |
Distributed: all CNs + all DNs Centralized: all DNs |
Count |
Component |
60s |
|
rds062_slowquery_sys |
Slow SQL Statements in the System Database |
Real-time number of slow SQL statements in the system database on the primary DN or CN in a measurement period |
Distributed: all CNs Centralized: primary DN |
Count |
Component |
60s |
|
rds063_slowquery_user |
Slow SQL Statements in the User Database |
Real-time number of slow SQL statements in the user database on the primary DN or CN in a measurement period |
Distributed: all CNs Centralized: primary DN |
Count |
Component |
60s |
|
rds082_gaussv5_wait_session |
Waiting Sessions |
Real-time number of waiting sessions |
Distributed: all CNs + standby DN Centralized: all DNs |
Count |
Component |
60s |
|
rds083_cn_temp_dir_size |
CN Temporary Directory Size |
Real-time size of the temporary directories under the data directory on a CN |
Distributed: all CNs |
MB |
Component |
60s |
|
rds084_sys_database_size |
System Database Size |
Real-time postgres database size on the monitored instance |
Current node |
Byte |
Node |
60s |
|
rds085_user_database_size |
User Database Total Size |
Real-time user database size on the monitored instance |
Current node |
Byte |
Node |
60s |
|
rds086_select_distribution |
SELECT Distribution |
Real-time percentage of SELECT statements |
Distributed: all CNs + all DNs Centralized: all DNs |
% |
Component |
60s |
|
rds087_update_distribution |
UPDATE Distribution |
Real-time percentage of UPDATE statements |
Distributed: all CNs + all DNs Centralized: all DNs |
% |
Component |
60s |
|
rds088_insert_distribution |
INSERT Distribution |
Real-time percentage of INSERT statements |
Distributed: all CNs + all DNs Centralized: all DNs |
% |
Component |
60s |
|
rds089_delete_distribution |
DELETE Distribution |
Real-time percentage of DELETE statements |
Distributed: all CNs + all DNs Centralized: all DNs |
% |
Component |
60s |
|
rds091_gaussv5_qps |
Read Requests |
Average number of read requests per second of a tenant in a specified period |
Distributed: all CNs Centralized: all DNs |
Count |
Component |
60s |
|
rds092_gaussv5_tps_rt_insert |
INSERT Request Response Time |
Average response time for INSERT requests of a tenant in a specified period |
Distributed: all CNs Centralized: all DNs |
ms |
Component |
60s |
|
rds093_gaussv5_tps_rt_update |
UPDATE Request Response Time |
Average response time for UPDATE requests of a tenant in a specified period |
Distributed: all CNs Centralized: all DNs |
ms |
Component |
60s |
|
rds094_gaussv5_tps_rt_delete |
DELETE Request Response Time |
Average response time for DELETE requests of a tenant in a specified period |
Distributed: all CNs Centralized: all DNs |
ms |
Component |
60s |
|
rds095_gaussv5_qps_rt |
Read Request Response Time |
Average response time for read requests of a tenant in a specified period |
Distributed: all CNs Centralized: all DNs |
ms |
Component |
60s |
|
retrans_rate |
Retransmission Ratio |
Real-time retransmission ratio of TCP packets |
Current node |
% |
Node |
60s |
|
rds096_process_used_memory |
Process Used Memory |
Real-time used memory by a CN or DN |
Distributed: all CNs + all DNs Centralized: all DNs |
MB |
Component |
60s |
|
rds097_2pc_transaction_prepare |
Oldest Two-Phase Commit Transaction Duration |
Maximum duration of uncommitted transactions using two-phase commit |
Centralized: primary DN |
s |
Component |
60s |
|
rds098_dn_instance_status |
DN Status |
Real-time status of a DN. 1: a normal primary DN; 2: a normal standby DN; 3: a normal main standby DN; 4: a normal cascaded standby DN; 10: standby DN catching up with primary DN using Xlog files; 20: a properly connected standby DN with abnormal replication status; 21: a disconnected DN |
Centralized: all DNs |
N/A |
Component |
60s |
|
rds099_replication_slot_dir_size |
Replication Slot Directory Size |
Real-time size of the replication slot directory |
Centralized: all DNs |
KB |
Component |
300s |
|
rds100_standby_diff_redo_and_receive |
Difference Between Redo and Receipt Positions on Standby Node |
The difference (in bytes) between the redo position and data receipt position on the standby node. This metric is used to determine whether data inconsistency is caused by slow redo rate on the standby node or because the primary node has not sent redo data. |
Distributed: standby DN Centralized: standby DN |
Byte |
Component |
60s |
|
rds101_online_distinct_client_addr_count |
Online Clients |
Number of online clients on each CN |
Distributed: all CNs |
Count |
Component |
60s |
|
rds102_working_distinct_client_addr_count |
Active Clients |
Number of active client connections on each CN |
Distributed: all CNs |
Count |
Component |
60s |
|
rds103_shard_min_rto |
Shard RTO |
Shortest possible RTO among multiple standby DNs within the current shard. |
Centralized: primary DN Distributed: primary DN |
s |
Component |
60s |
|
rds104_invalid_usr_pwd_login_denied_count |
Login Attempts with Incorrect Usernames or Passwords |
The number of failed login attempts due to incorrect usernames or passwords in kernel logs. The value is the difference between two collected values (incremental value). |
Centralized: all DNs Distributed: all CNs |
Count |
Component |
300s |
Dimensions
|
Key |
Value |
|---|---|
|
gaussdbv5_instance_id |
GaussDB instance |
|
gaussdbv5_node_id |
GaussDB node |
|
gaussdbv5_component_id |
GaussDB component |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
