This topic describes the performance metric of PolarDB clusters that are monitored.

Performance metrics of PolarDB for PostgreSQL and PolarDB for PostgreSQL(Compatible with Oracle) clusters

Performance metricMetricData typeUnitDescription
PolarDBConnectionsmean_total_sessiondoubleN/AThe number of current connections.
mean_active_sessiondoubleN/AThe number of active connections.
mean_waiting_connectiondoubleN/AThe number of pending connections.
mean_idle_connectiondoubleN/AThe number of idle connections.
PolarDBRowDMLmean_tup_returned_deltadoubleN/AThe number of rows returned per second in the full table scan result.
mean_tup_fetched_deltadoubleN/AThe number of rows returned per second in the index scan and secondary index result.
mean_tup_inserted_deltadoubleN/AThe number of rows inserted per second.
mean_tup_updated_deltadoubleN/AThe number of rows updated per second.
mean_tup_deleted_deltadoubleN/AThe number of rows deleted per second
PolarDBTransactionmean_active_transactionsdoubleN/AThe number of transactions in the active state.
mean_waiting_transactionsdoubleN/AThe number of pending transactions.
mean_idle_transactionsdoubleN/AThe number of idle transactions.
mean_two_pc_transactionsdoubleN/AThe number of XA transactions.
PolarDBQPSTPSmean_tpsdoubleN/AThe number of transactions per second.
mean_commits_deltadoubleN/AThe number of transactions committed per second.
mean_rollbacks_deltadoubleN/AThe number of transactions rolled back per second.
mean_deadlocks_deltadoubleN/AThe number of deadlocks per second.
PolarDBBuffermean_blks_read_deltadoubleN/AThe number of block reads per second.
mean_blks_hit_deltadoubleN/AThe number of block hits per second.
mean_hit_ratiodoublePercentageThe block hit ratio.
mean_buffers_cleandoubleN/AThe cumulative number of buffers written by the background writer during checkpoints.
mean_buffers_backenddoubleN/AThe cumulative number of buffers written by a backend.
mean_buffers_backend_fsyncdoubleN/AThe cumulative number of backend fsync calls.
mean_buffers_allocdoubleN/AThe cumulative number of allocated buffers.
PolarDBVacuummean_db_agedoublexidsThe difference between the current transaction ID and the earliest transaction ID that cannot be recycled.
PolarDBTempmean_temp_filesdoubleN/AThe number of temporary files generated per second.
mean_temp_bytesdoubleBytesThe amount of temporary file data generated per second.
PolarDBCPUcpu_ratiodoublePercentageThe CPU utilization.
cpu_user_ratiodoublePercentageThe CPU utilization in the user state.
cpu_sys_ratiodoublePercentageThe CPU utilization in the system state.
PolarDBMemorymem_ratiodoublePercentageThe memory usage.
PolarDBDiskUsagemean_ins_total_sizedoubleMBThe used PolarStore space of the instance.
mean_data_sizedoubleMBThe used PolarStore space of user data.
mean_wal_sizedoubleMBThe used PolarStore space of Write-Ahead Logging (WAL) logs.
mean_tmp_sizedoubleMBThe used temporary space.
mean_log_sizedoubleMBThe used space of local logs.
PolarDBIOSTATmean_iops_rdoubleN/AThe read IOPS.
mean_iops_wdoubleN/AThe write IOPS.
mean_iopsdoubleN/AThe total IOPS.
mean_io_throughput_rdoubleMBThe read I/O throughput.
mean_io_throughput_wdoubleMBThe write I/O throughput.
mean_io_throughputdoubleMBThe total I/O throughput.

Performance metrics of PolarProxy

Performance metricMetricData typeUnitDescription
PolarProxy_CpuUsagedocker_container_cpudoublePercentageThe CPU utilization on PolarProxy.
PolarProxy_Cpsservice_connections_psdoubleN/AThe number of new connections per second on PolarProxy.
PolarProxy_CurrentConnsservice_current_connectionsdoubleN/AThe number of current connections on PolarProxy.
PolarProxy_UpFlowsservice_upstream_netflowdoubleKB/sThe amount of inbound network traffic per second on PolarProxy.
PolarProxy_DownFlowsservice_downstream_netflowdoubleKB/sThe amount of outbound network traffic per second on PolarProxy.
PolarProxy_Qpsservice_queriesdoubleN/AThe number of requests per second on PolarProxy.