Performance parameters for RDS-ApsaraDB RDS(RDS)-阿里云帮助中心

Use the DescribeDBInstancePerformance operation to query instance performance data. When you call this operation, specify the time range (StartTime and EndTime), the instance (DBInstanceId), and the performance metric (Key). The supported values for Key and the structure of the return values vary by database type:

MySQL and MariaDB

Note

RDS for MySQL and RDS for MariaDB share the same performance parameter names.

`Parameter`	Description
MySQL_NetworkTraffic	The average rate of inbound and outbound traffic for the instance. Unit: KB/s.
MySQL_QPSTPS	The average number of SQL statements executed and transactions per second. Unit: count/s.
MySQL_Sessions	The number of active and total connections. Unit: count.
MySQL_InnoDBBufferRatio	The read hit rate, utilization, and dirty block percentage in the InnoDB buffer pool. Unit: %.
MySQL_InnoDBDataReadWriten	The average amount of data read from and written to InnoDB per second. Unit: KB.
MySQL_InnoDBLogRequests	The average number of reads from and writes to the InnoDB buffer pool per second. Unit: count/s.
MySQL_InnoDBLogWrites	The average number of log write requests, physical writes to the log file, and completed `fsync()` writes to the log file per second. Unit: count/s.
MySQL_TempDiskTableCreates	The number of on-disk temporary tables created during statement execution. Unit: count.
MySQL_MyISAMKeyBufferRatio	The average utilization, read hit rate, and write hit rate of the MyISAM key buffer. Unit: %.
MySQL_MyISAMKeyReadWrites	For MyISAM, the average number of buffer reads, buffer writes, disk reads, and disk writes per second. Unit: count/s.
MySQL_COMDML	The average number of executions per second for the following statements: DELETE, INSERT, INSERT_SELECT, REPLACE, REPLACE_SELECT, SELECT, and UPDATE. Unit: count/s.
MySQL_RowDML	The average number of rows read, updated, deleted, and inserted per second in InnoDB tables, and the average number of physical writes to the log file per second. Unit: rows/s or count/s.
MySQL_MemCpuUsage (For non-Serverless instances)	The CPU and memory utilization of a non-Serverless instance, expressed as a percentage of total operating system resources. Unit: %.
MySQL_RCU_MemCpuUsage (For Serverless instances)	The CPU and memory utilization of a Serverless instance, expressed as a percentage of total operating system resources. Unit: %.
MySQL_IOPS	The IOPS of the instance. Unit: count/s.
MySQL_DetailedSpaceUsage	The total, data, log, temporary, and system space usage of the instance. Unit: MB.
slavestat	The replication delay of the read-only instance. Unit: seconds.
MySQL_ThreadStatus	The number of active threads and connected threads. Unit: count.
MySQL_ReplicationDelay	The replication delay of the replica instance. Unit: seconds.
MySQL_ReplicationThread	The status of the I/O replication thread and the SQL replication thread. A status of 1 indicates normal, while 0 indicates a missing thread.
MySQL_ROW_LOCK	The maximum wait time (ms), average wait time (ms), and number of waits (count) for a row lock.
MySQL_SelectScan	The number of full table scans performed by the instance. Unit: count.
MySQL_MBPS	The read and write throughput of the instance. Unit: B/s.

SQL Server

Note

Multiple metrics for a single key are separated by &.

Basic metrics

Standard monitoring chart name	Standard monitoring metric name	Description	Unit	OpenAPI Key	OpenAPI returned metric name
Instance Storage	`ins_size`	Total space used by the instance.	MB	`SQLServer_DetailedSpaceUsage`	`ins_size`
	`log_size`	Log space used.	MB		`log_size`
	`data_size`	Data space used.	MB		`data_size`
	`other_size`	System space used.	MB		`other_size`
	`tmp_size`	Temporary space used.	MB		`tmp_size`
	`disk_xel`	Disk space used by Extended Event log files.	MB		`disk_xel`
	`disk_trace`	Disk space used to store SQL Server trace files, such as SQL Profiler trace files.	MB		`disk_trace`
	`disk_dump`	Space used by dump files that are generated when the SQL Server kernel encounters an exception.	MB		`disk_dump`
	`disk_mastersize`	Disk space used to store the SQL Server system database master.	MB		`disk_mastersize`
	`disk_modelsize`	Disk space used to store the model database. The model database is the template for each new database.	MB		`disk_modelsize`
	`disk_msdbsize`	Disk space used to store the msdb database. The msdb database manages SQL Server Agent jobs and backup history.	MB		`disk_msdbsize`
	`disk_errorlog`	Disk space used by error log files. You can clear the error logs of an instance from the console or by calling an API operation.	MB		`disk_errorlog`
Instance Disk Usage	`disk_usage`	Space usage.	%	`SQLServer_InstanceDiskUsage`	`InstanceDiskUsage`
BufferHit	`cache_hit_ratio`	Cache hit ratio.	%	`SQLServer_BufferHit`	`Cache_Hit_Ratio`
BufferHit	`bufferpool_hit_ratio`	Percentage of pages found in the buffer cache without a read from disk.	%	`SQLServer_BufferHit`	`sqlserver_bufferpool`
CPU/Memory Utilization	`mem_usage`	Instance memory usage.	%	`SQLServer_InstanceMemUsage`	`sqlserver_insmem`
CPU/Memory Utilization	`cpu_usage`	Instance CPU usage as a percentage of total operating system CPU.	%	`SQLServer_InstanceCPUUsage`	`sqlserver_inscpu`
Network Traffic	`input_traffic`	Average number of bytes received from all clients per second.	KB	`SQLServer_NetworkTraffic`	`read_kb`
Network Traffic	`output_traffic`	Average number of bytes sent to all clients per second.	KB	`SQLServer_NetworkTraffic`	`write_kb`
Abnormal Items	`alarm_abnormal_db`	Number of databases with an abnormal mirroring configuration or a failed mirroring synchronization.	Count	`SQLServer_Alarm`	`alarm_abnormal_db`
Connections	`active_session`	Number of active threads.	Count	`SQLServer_Sessions`	`sqlserver_activesession`
Transactions	`transactions`	Average transactions per second.	Count/S	`SQLServer_Transactions`	`sqlserver_transactions`
Transactions	`write_transactions`	Average write transactions per second.	Count/S	`SQLServer_Transactions`	`sqlserver_write_transactions`
AlwaysOn Availability Group Performance	`sqlserver_alwayson_lagsecs`	SQL Server AlwaysOn replication lag.	S	`SQLServer_AGPerf`	`sqlserver_alwayson_lagsecs`
	`sqlserver_alwayson_redoqueuesize_kb`	Size of the log queue waiting to be redone on the replica, in KB.	KB		`sqlserver_alwayson_redoqueuesize_kb`
	`sqlserver_alwayson_sendqueuesize_kb`	Size of the log queue on the primary replica waiting to be sent to the replica, in KB.	KB		`sqlserver_alwayson_sendqueuesize_kb`
	`ag_unhealthydb_count`	Number of unhealthy databases in the availability group.	Count		`ag_unhealthydb_count`
	`ag_db_not_in_ag_count`	Number of databases that are not in the availability group.	Count		`ag_db_not_in_ag_count`
SQL Compilation Rate	`sql_compilations`	SQL compilations per second.	Count/S	`SQLServer_SQLCompilations`	`sqlserver_sqlcompilations`
SQL Compilation Rate	`resqlcompilations`	Statement recompilations per second.	Count/S	`SQLServer_SQLCompilations`	`sqlserver_resqlcompilations`
IOPS Utilization	`iops_usage_burst`	Actual IOPS usage.	%	`SQLServer_InstanceIOPSUsage`	`InstanceIOPSUsageBurst`
	`iops_usage_no_burst`	IOPS usage when I/O burst is disabled.	%		`InstanceIOPSUsageNoBurst`
	`iops_usage_burst_ratio`	Percentage of IOPS improvement after I/O burst is enabled.	%		`InstanceIOPSBurstRatio`
Lock Timeouts	`locktimeout`	Lock requests that timed out per second, including NOWAIT lock requests.	Count/S	`SQLServer_LockTimeout`	`sqlserver_locktimeout`
Mirroring Synchronization Performance (high-availability series only)	`sqlserver_log_send_queue`	Number of log bytes on the primary replica waiting to be sent to the replica.	KB	`SQLServer_MirrorPerf`	`sqlserver_log_send_queue`
	`sqlserver_redo_queue`	Number of log bytes waiting to be redone on the replica.	KB	`SQLServer_MirrorPerf`	`sqlserver_redo_queue`
Page Life Expectancy	`Page_life_expectancy`	Average time a cached data page stays in memory.	S	`SQLServer_PageLife`	`sqlserver_pagelife`
Blocking	`Wait_for_the_worker`	Length of the worker threads wait queue.	Count	`SQLServer_Block`	`Wait_for_the_worker`
	`uncommited_tran`	Number of uncommitted transactions.	Count		`uncommited_tran`
	`Longest_Transaction_Running_Time`	Duration of the longest-running transaction.	S		`Longest_Transaction_Running_Time`
	`Processes_blocked`	Number of blocked processes.	Count		`Processes_blocked`
Full Table Scan Rate	`fullscans`	Average full table scans per second.	Count/S	`SQLServer_FullScans`	`sqlserver_fullscans`
Throughput Utilization	`mBps_usage_no_burst`	Disk I/O throughput usage when I/O burst is disabled.	%	`SQLServer_InstanceMBPSUsage`	`mBps_usage_no_burst`
	`mBps_usage_burst`	Actual disk I/O throughput usage.	%		`mBps_usage_burst`
	`mBps_burst_ratio`	Percentage of disk I/O throughput improvement after I/O burst is enabled.	%		`mBps_burst_ratio`
IOPS	`db_io_read`	Read I/O requests per second.	Count/S	`SQLServer_IOPS`	`db_io_read`
	`db_io`	Total I/O requests per second.	Count/S		`db_io`
	`db_io_write`	Write I/O requests per second.	Count/S		`db_io_write`
	`iops_of_ecs`	Upper IOPS limit on the computing side.	Count/S		`iops_of_ecs`
	`iops_of_disk`	Upper IOPS limit on the storage side.	Count/S		`iops_of_disk`
	`iops_no_burst`	Upper IOPS limit when I/O burst is disabled.	Count/S		`iops_no_burst`
	`iops_burst`	Upper IOPS limit.	Count/S		`iops_burst`
QPS	`qps`	Average number of SQL statement executions per second.	Count/S	`SQLServer_QPS`	`sqlserver_qps`
Checkpoint Pages Written	`lazy_writes`	Writes to disk per second.	Count/S	`SQLServer_CheckPoint`	`sqlserver_lazy_writes`
Checkpoint Pages Written	`checkpoint`	Pages written to disk by checkpoints per second.	Count/S	`SQLServer_CheckPoint`	`sqlserver_checkpoint`
Deadlocks	`deadlock`	Deadlocks per second.	Count/S	`SQLServer_Deadlock`	`sqlserver_deadlock`
Page Performance	`sqlserver_pagereads`	Data pages read from disk per second (physical I/O).	Count/S	`SQLServer_PagePerf`	`sqlserver_pagereads`
Page Performance	`sqlserver_pagewrites`	Data pages written to disk per second (physical I/O).	Count/S	`SQLServer_PagePerf`	`sqlserver_pagewrites`
Throughput	`mBps_total`	Total disk I/O throughput per second.	MB/S	`SQLServer_MBPS`	`mBps_total`
	`mBps_read`	Disk read I/O throughput per second.	MB/S		`mBps_read`
	`mBps_write`	Disk write I/O throughput per second.	MB/S		`mBps_write`
	`mBps_of_ecs`	Upper disk I/O throughput limit per second on the computing side.	MB/S		`mBps_of_ecs`
	`mBps_of_disk`	Upper disk I/O throughput limit per second on the storage side.	MB/S		`mBps_of_disk`
	`mBps_no_burst`	Upper disk I/O throughput limit per second when I/O burst is disabled.	MB/S		`mBps_no_burst`
	`mBps_burst`	Upper disk I/O throughput limit per second.	MB/S		`mBps_burst`
Logons	`logins`	Logons per second.	Count/S	`SQLServer_Logins`	`sqlserver_logins`
Logons	`logout`	Logouts per second.	Count/S	`SQLServer_Logins`	`sqlserver_logout`
Serverless RCU (serverless instances only)	`rcu`	RDS Capacity Unit.	Count	`SQLServer_RCU`	`rcu`

Advanced metrics

Standard monitoring chart name	Standard monitoring metric name	Description	Unit	OpenAPI Key	OpenAPI returned metric name
Index Usage	`Index_Searches_per_sec`	Index searches per second.	Count/S	`SQLServer_IndexUsage`	`Index_Searches_per_sec`
Index Usage	`Forwarded_Records_per_sec`	Forwarded records accessed per second.	Count/S	`SQLServer_IndexUsage`	`Forwarded_Records_per_sec`
Connections	`active_temp_tables`	Number of active temporary tables.	Count	`SQLServer_Sessions`	`Active_Temp_Tables`
	`active_transactions`	Number of active transactions.	Count		`Active_Transactions`
	`active_cursors`	Number of active cursors.	Count		`Active_cursors`
	`connection_reset`	Logons initiated from the connection pool per second.	Count/S		`sqlserver_connectionreset`
	`user_connections`	Total number of connections.	Count		`sqlserver_sessions`
Cache	`Cache_Object_Counts`	Total number of objects in the cache.	Count	`SQLServer_Cache`	`Cache_Object_Counts`
	`Cache_Objects_in_use`	Number of cache objects currently in use.	Count		`Cache_Objects_in_use`
	`Cache_Pages`	Number of pages used by the cache.	Count		`Cache_Pages`
Advanced Memory Usage	`CACHESTORE_SQLCP_KB`	Memory used by the SQL compiled plan cache, in KB.	KB	`SQLServer_AdvancedMemUsage`	`CACHESTORE_SQLCP_KB`
	`CACHESTORE_PHDR_KB`	Memory used by the physical driver cache, in KB.	KB		`CACHESTORE_PHDR_KB`
	`CACHESTORE_OBJCP_KB`	Memory used by the object compiled plan cache, in KB.	KB		`CACHESTORE_OBJCP_KB`
	`MEMORYCLERK_SOSNODE_KB`	Memory allocated to operating system nodes, in KB.	KB		`MEMORYCLERK_SOSNODE_KB`
	`MEMORYCLERK_SQLCLR_KB`	Memory used by the common language runtime (CLR), in KB.	KB		`MEMORYCLERK_SQLCLR_KB`
	`MEMORYCLERK_SQLSTORENG_KB`	Memory used by the SQL storage engine, in KB.	KB		`MEMORYCLERK_SQLSTORENG_KB`
	`USERSTORE_SCHEMAMGR_KB`	Memory used by the user schema manager, in KB.	KB		`USERSTORE_SCHEMAMGR_KB`
	`MEMORYCLERK_SOSMEMMANAGER`	Memory used by the operating system memory manager, in KB.	KB		`MEMORYCLERK_SOSMEMMANAGER`
	`CACHESTORE_SQLCP_VMCommitted_KB`	Virtual memory used by the plan cache for SQL plans.	KB		`CACHESTORE_SQLCP_VMCommitted_KB`
	`CACHESTORE_PHDR_VMCommitted_KB`	Virtual memory used by the temporary memory cache for algebrizer trees.	KB		`CACHESTORE_PHDR_VMCommitted_KB`
	`CACHESTORE_OBJCP_VMCommitted_KB`	Virtual memory used by the plan cache for object plans.	KB		`CACHESTORE_OBJCP_VMCommitted_KB`
	`MEMORYCLERK_SOSNODE_VMCommitted_KB`	Virtual memory used by SOSNODE, a component of SQLOS.	KB		`MEMORYCLERK_SOSNODE_VMCommitted_KB`
	`MEMORYCLERK_SQLCLR_VMCommitted_KB`	Virtual memory used by SQLCLR.	KB		`MEMORYCLERK_SQLCLR_VMCommitted_KB`
	`MEMORYCLERK_SQLSTORENG_VMCommitted_KB`	Virtual memory used by storage engine components.	KB		`MEMORYCLERK_SQLSTORENG_VMCommitted_KB`
	`USERSTORE_SCHEMAMGR_VMCommitted_KB`	Virtual memory used by different types of metadata for database objects.	KB		`USERSTORE_SCHEMAMGR_VMCommitted_KB`
	`MEMORYCLERK_SOSMEMMANAGER_VMCommitted_KB`	Virtual memory used by SOSMEMMANAGER, a component of SQLOS.	KB		`MEMORYCLERK_SOSMEMMANAGER_VMCommitted_KB`
Backup Performance	`Backup_per_Restore_Throughput_per_sec`	Bytes processed per second by backup or restore operations (throughput).	Count/S	`SQLServer_BackupPerf`	`Backup_per_Restore_Throughput_per_sec`
Memory Usage	`Lock_Memory`	Memory used by lock structures, in KB.	KB	`SQLServer_MemUsage`	`Lock_Memory_KB`
	`Connection_Memory`	Memory used by connections, in KB.	KB		`Connection_Memory_KB`
	`Database_Cache_Memory`	Memory used by the database buffer pool, in KB.	KB		`Database_Cache_Memory_KB`
	`Free_Memory`	Available memory, in KB.	KB		`Free_Memory_KB`
	`Optimizer_Memory`	Memory used by the query optimizer, in KB.	KB		`Optimizer_Memory_KB`
	`Total_Server_Memory`	Total memory currently used by SQL Server, in KB.	KB		`Total_Server_Memory_KB`
	`SQL_Cache_Memory`	Memory used by the SQL plan cache, in KB.	KB		`SQL_Cache_Memory_KB`
	`Stolen_Server_Memory`	Memory used for other purposes, in KB.	KB		`Stolen_Server_Memory_KB`
AlwaysOn Availability Group Performance	`Bytes_Received_from_Replica_per_sec`	Bytes received from the replica per second.	B/S	`SQLServer_AGPerf`	`Bytes_Received_from_Replica_per_sec`
	`ag_redo_finish_time`	Timestamp at which the replica finished the redo operation.	S		`ag_redo_finish_time`
	`Bytes_Sent_to_Replica_per_sec`	Bytes sent to the replica per second.	B/S		`Bytes_Sent_to_Replica_per_sec`
	`Flow_Control_Time_ms_per_sec`	Flow control duration per second, in milliseconds.	MS/S		`Flow_Control_Time_ms_per_sec`
	`Flow_Control_per_sec`	Flow control events triggered per second.	Count/S		`Flow_Control_per_sec`
SQL Compilation Rate	`safe_autoparams_per_sec`	Safe auto-parameterization attempts per second.	Count/S	`SQLServer_SQLCompilations`	`Safe_AutoParams_per_sec`
	`failed_autoparams_per_sec`	Failed auto-parameterization attempts per second.	Count/S		`Failed_AutoParams_per_sec`
	`forced_parameterizations_per_sec`	Successful forced parameterizations per second.	Count/S		`Forced_Parameterizations_per_sec`
	`unsafe_autoparams_per_sec`	Unsafe auto-parameterization attempts per second.	Count/S		`Unsafe_AutoParams_per_sec`
	`autoparam_attempts_per_sec`	Auto-parameterization attempts per second.	Count/S		`AutoParam_Attempts_per_sec`
Mirroring Synchronization Performance (high-availability series only)	`Redo_Bytes_Remaining`	Number of log bytes that the replica still needs to redo.	B	`SQLServer_MirrorPerf`	`Redo_Bytes_Remaining`
	`Redone_Bytes_per_sec`	Number of log bytes redone by the replica per second.	B/S	`SQLServer_MirrorPerf`	`Redone_Bytes_per_sec`
Log Growth	`Log_Shrinks`	Number of transaction log shrinks.	Count	`SQLServer_LogGrowth`	`Log_Shrinks`
	`Log_Truncations`	Number of transaction log truncations.	Count		`Log_Truncations`
	`Log_Growths`	Number of automatic transaction log growths.	Count		`Log_Growths`
Version Store Rate	`Version_Cleanup_rate_KB_per_s`	Size of the row version store cleaned up per second, in KB.	KB/S	`SQLServer_OptimizeConcurrent`	`Version_Cleanup_rate_KB_per_s`
Version Store Rate	`Version_Generation_rate_KB_per_s`	Size of the row version store generated per second, in KB.	KB/S	`SQLServer_OptimizeConcurrent`	`Version_Generation_rate_KB_per_s`
Log Performance	`Log_Bytes_Flushed_per_sec`	Log bytes written to disk per second (physical transaction log writes).	B/S	`SQLServer_LogPerf`	`Log_Bytes_Flushed_per_sec`
	`Log_Bytes_Received_per_sec`	Log bytes received per second (transaction log generation rate).	B/S		`Log_Bytes_Received_per_sec`
	`Log_Cache_Reads_per_sec`	Reads from the log cache per second, which do not require a read from disk.	Count/S		`Log_Cache_Reads_per_sec`
	`Log_buffer_waits`	Number of waits for the log buffer. A high value indicates heavy log buffer contention. Increase the log buffer size or optimize transactions.	B		`Log_buffer_waits`
	`Log_Flushes_per_sec`	Log flushes to disk per second. A high value indicates frequent transactions. Consider optimizing batch operations.	Count/S		`Log_Flushes_per_sec`
	`Log_Pool_Requests_per_sec`	Log buffer requests per second. Use this metric to monitor log buffer pressure.	Count/S		`Log_Pool_Requests_per_sec`
Lock Wait Times	`lock_requests_per_sec`	Total lock requests received by SQL Server per second.	Count/S	`SQLServer_LockWaits`	`Lock_Requests_per_sec`
	`lock_wait_time_ms`	Average lock wait time.	MS		`Lock_Wait_Time_ms`
	`lock_waits_per_sec`	Lock requests per second for which the caller waited.	Count/S		`sqlserver_lockwaits`
	`table_lock_escalations_per_sec`	Times per second that locks on a table were escalated to the TABLE or HoBT granularity.	Count/S		`Table_Lock_Escalations_per_sec`
	`average_latch_wait_time`	Average wait time for latch requests.	MS		`Average_Latch_Wait_Time`
	`average_lock_wait_time`	Average wait time for lock requests.	MS		`Average_Lock_Wait_Time`
	`total_latch_wait_time_ms`	Total lock wait time in the last second.	MS		`Total_Latch_Wait_Time_ms`
	`latchwaits`	Latch requests not granted immediately per second.	Count/S		`sqlserver_latchwaits`
	`lock_waits`	Statistics about processes waiting for a lock.	Count		`Lock_waits`
Page Performance	`Page_lookups_per_sec`	Number of buffer pool page lookups per second.	Count/S	`SQLServer_PagePerf`	`Page_lookups_per_sec`
	`Pages_compressed_per_sec`	Data pages compressed per second.	Count/S		`Pages_compressed_per_sec`
	`Page_IO_latch_waits`	Number of waits to acquire a page I/O latch.	Count		`Page_IO_latch_waits`
	`sqlserver_pagesplits`	Page splits per second.	Count/S		`sqlserver_pagesplits`
	`Readahead_pages_per_sec`	Pages read ahead per second.	Count/S		`Readahead_pages_per_sec`
	`Background_writer_pages_per_sec`	Pages written to disk per second by the background writer process.	Count/S		`Background_writer_pages_per_sec`
	`Page_latch_waits`	Total number of waits to acquire a page latch.	Count		`Page_latch_waits`

PostgreSQL

Note

ApsaraDB RDS for PostgreSQL offers enhanced monitoring to provide more granular metrics in the console. This table maps the values of the Key parameter for the DescribeDBInstancePerformance operation to their corresponding metrics in enhanced monitoring.

`Key` value	Metric and description	Enhanced monitoring metric
MemoryUsage	Memory usage. Unit: %.	os.mem_usage.total.avg
CpuUsage	CPU utilization. Unit: %.	os.cpu_usage.total.avg
PgSQL_SpaceUsage	Instance space usage. Unit: byte.	os.fs_size.wal_dir.avg + os.fs_size.base_dir.avg (Unit: MB)
PgSQL_IOPS	IOPS (I/O operations per second). Unit: count/s.	(os.iops.data.avg+os.iops.wal.avg) / os.iops.total.avg * 100
PgSQL_Session	Total current connections. Unit: count.	db.connections.total.avg
PolarDBConnections	mean_active_session: The number of active connections. mean_idle_connection: Number of idle connections. mean_total_session: The total number of connections. mean_waiting_connection: Number of waiting connections.	db.connections.active.avg db.connections.idle.avg db.connections.total.avg db.connections.waiting.avg
PolarDBRowDML	mean_tup_returned_delta: The number of rows returned by sequential scans per second. mean_tup_fetched_delta: The number of rows returned by index scans per second. mean_tup_inserted_delta: The number of rows inserted per second. mean_tup_updated_delta: The number of rows updated per second. mean_tup_deleted_delta: The number of rows deleted per second.	db.sql.tup_returned.avg db.sql.tup_fetched.avg db.sql.tup_inserted.avg db.sql.tup_updated.avg db.sql.tup_deleted.avg
PolarDBQPSTPS	mean_commits_delta: The number of transactions committed per second. mean_rollbacks_delta: The number of transactions rolled back per second. mean_deadlocks_delta: The number of deadlocks per second. mean_tps: The number of transactions per second.	db.transactions.xact_commit.avg db.transactions.xact_rollback.avg No deadlock metric is available. db.transactions.xact_commit.avg+db.transactions.xact_rollback.avg
PolarDBSwellTime	Minimum age of garbage, in seconds, before it can be collected (swell point).	db.swell.swell_time.avg
PolarDBCPU	CPU utilization. Unit: %.	os.cpu_usage.sys.avg os.cpu_usage.user.avg os.cpu_usage.total.avg
PolarDBMemory	Memory usage. Unit: %.	os.mem_usage.total.avg
PolarDBReplication	mean_replay_latency_in_mb: Synchronization latency on the standby database. Unit: MB. mean_send_latency_in_mb: Sending latency on the primary database. Unit: MB. mean_logical_rep_latency_in_mb: Logical replication latency. Unit: MB.	/
PolarDBLongSQL	mean_one_second_executing_sqls: Number of SQL statements running for more than 1 second. mean_three_seconds_executing_sqls: Number of SQL statements running for more than 3 seconds. mean_five_seconds_executing_sqls: Number of SQL statements running for more than 5 seconds.	db.slow_sql.one_second.avg db.slow_sql.three_seconds.avg db.slow_sql.five_seconds.avg
PolarDBLongIdleTransaction	mean_one_second_idle_transactions: Number of transactions idle for more than 1 second. mean_three_seconds_idle_transactions: Number of transactions idle for more than 3 seconds. mean_five_seconds_idle_transactions: Number of transactions idle for more than 5 seconds.	db.long_transactions.idle_one_second.avg db.long_transactions.idle_three_seconds.avg db.long_transactions.idle_five_seconds.avg
PolarDBLongTransaction	mean_one_second_transactions: Number of transactions running for more than 1 second. mean_three_seconds_transactions: Number of transactions running for more than 3 seconds.	db.long_transactions.active_one_second.avg db.long_transactions.active_three_seconds.avg
PolarDBLongTwoPCTransaction	mean_one_second_two_pc_transactions: Number of two-phase commit (2PC) transactions running for more than 1 second. mean_three_seconds_two_pc_transactions: Number of two-phase commit (2PC) transactions running for more than 3 seconds. mean_five_seconds_two_pc_transactions: Number of two-phase commit (2PC) transactions running for more than 5 seconds.	db.long_transactions.two_pc_one_second.avg db.long_transactions.two_pc_three_seconds.avg db.long_transactions.two_pc_five_seconds.avg
PolarDBLocalIOSTAT	mean_local_iops_read: Read IOPS on the data disk. mean_local_iops_write: Write IOPS on the data disk.	os.iops.read.avg os.iops.write.avg
PolarDBLocalDiskUsage	mean_local_pg_wal_dir_size: WAL space usage. Unit: MB. mean_local_pg_log_dir_size: Log space usage. Unit: MB. mean_local_base_dir_size: Data space usage. Unit: MB.	os.fs_size.wal_dir.avg os.fs_size.log_dir.avg os.fs_size.base_dir.avg

MySQL and MariaDB

SQL Server

Basic metrics

Advanced metrics

PostgreSQL

Related documentation