The page has been translated by Gen AI.

ServiceWatch metrics

PostgreSQL (DBaaS) sends metrics to ServiceWatch. The metrics provided by basic monitoring are collected at a 1-minute interval.

Reference

To view metrics in ServiceWatch, refer to the ServiceWatch guide.

Basic Metrics

The following are the default metrics for the PostgreSQL(DBaaS) namespace.

The metrics whose names are shown in bold below are the key metrics selected from the default metrics provided by PostgreSQL(DBaaS). Key metrics are used to build service-specific dashboards that are automatically created in ServiceWatch.

Each metric specifies which statistical values are meaningful when querying that metric, as described in the user guide. Among the meaningful statistics, the values displayed in bold are the primary statistics. You can view key metrics through key statistics on the service dashboard.

OS Basic Metrics

Category	Performance Item	Unit	Detailed Description	Meaningful Statistics
CPU	CPU Usage	Percent	CPU Usage	Total Average Max Min
Disk	Disk Usage	Percent	Disk Usage	Total Average Max Min
Disk	Disk Write Bytes	Bytes/Second	Write throughput (bytes/second) for block devices	Total Average Maximum Minimum
Disk	Disk Read Bytes	Bytes/Second	Read volume from block devices (bytes/second)	Total Average Maximum Minimum
Disk	Disk Write Requests	Count/Second	Number of write requests per second (requests/second) on a block device	Total Average Maximum Minimum
Disk	Disk Read Requests	Count/Second	Number of read requests on the block device (requests/second)	Total Average Maximum Minimum
Disk	Average Disk I/O Queue Size	ERROR	Average queue length of requests issued to a block device	Total Average Maximum Minimum
Disk	Disk I/O Utilization	Percent	The percentage of time the block device actually processed I/O operations	Total Average Maximum Minimum
Memory	Memory Usage	Percent	Memory Usage	Total Average Max Min
Memory	Swap Out Bytes	Bytes/Second	Amount of capacity swapped out from memory to the swap area (bytes/second)	Total Average Maximum Minimum
Memory	Swap Used Bytes	Bytes	Size of the swap space currently in use	Total Average Maximum Minimum
Memory	Swap Cached Usage	Percent	Cached swap usage	Total Average Maximum Minimum
Memory	Swap Total Bytes	Bytes	The total size of the swap space configured on the system	Total Average Maximum Minimum
Memory	Swap In Bytes	Bytes/Second	Amount of data read from the swap area into memory (bytes/second)	Total Average Maximum Minimum
Memory	Swap Usage	Percent	Percentage of current usage relative to total swap space	Total Average Maximum Minimum
Memory	Swap Cached Bytes	Bytes	The size of a page that has been restored to memory but still has a copy remaining in the swap area	Total Average Maximum Minimum
Memory	Swap Free Bytes	Bytes	The size of the remaining unused swap space	Total Average Maximum Minimum
Network	Network In Bytes	Bytes/Second	Received capacity (bytes per second) on the network interface	Total Average Maximum Minimum
Network	Network Out Bytes	Bytes/Second	Transmitted capacity (bytes per second) on the network interface	Total Average Maximum Minimum
Network	TCP Connections	Count/Second	The total number of currently established TCP connections	Total Average Maximum Minimum
Network	Network In Packets	Count	Number of packets received on the network interface	Total Average Maximum Minimum
Network	Network Out Packets	Count	Number of packets transmitted on the network interface	Total Average Maximum Minimum
Network	Network In Dropped	Count	Number of dropped packets received on the network interface	Total Average Maximum Minimum
Network	Network Out Dropped	Count	Number of dropped packets transmitted on the network interface	Total Average Maximum Minimum
Network	Network In Errors	Count	Number of packet errors received on the network interface	Total Average Maximum Minimum
Network	Network Out Errors	Count	Number of transmitted packet errors on the network interface	Total Average Maximum Minimum
OS	OS Uptime	Seconds	The number of seconds elapsed since the system last booted	Total Average Maximum Minimum

Table. OS baseline metrics

PostgreSQL (DBaaS) Basic Metrics

Category	Performance Item	Unit	Detailed Description	Meaningful Statistics
Frozenxid	DB age max	ERROR	The time when the oldest transaction started	Total Average Max Min
Locks	Active locks (total)	Count	The total of all currently active locks	Total Average Maximum Minimum
Locks	Exclusive locks	Count	Number of exclusive locks that other sessions cannot access	Total Average Max Min
Locks	Row exclusive locks	Count	Row-level exclusive lock, used during DML (INSERT/UPDATE/DELETE)	Total Average Maximum Minimum
Locks	Row share locks	Count	Row-level shared locks, used in SELECT … FOR UPDATE, etc.	Total Average Maximum Minimum
Locks	Share locks	Count	Shared lock on the entire object, used in read-only transactions	Total Average Maximum Minimum
Locks	Share row exclusive locks	Count	Locks that apply both shared and exclusive modes simultaneously	Total Average Maximum Minimum
Locks	Share update exclusive locks	Count	Lock for shared updates only, used for rapidly changing data	Total Average Maximum Minimum
Locks	Wait Locks (long)	Count	Number of lock requests pending for a long time	Total Average Maximum Minimum
Locks	Wait Locks (total)	Count	The number of all lock requests currently pending	Total Average Maximum Minimum
Replication	Apply Lag Time	Seconds	Replication latency (Primary → Standby)	Total Average Maximum Minimum
Replication	Check no Replication	Count	Indicators for confirming the absence of replication settings	Total Average Maximum Minimum
Replication	Check replication	Count	Metrics for verifying that the replication status is normal	Total Average Maximum Minimum
Sessions	Active sessions	Count	The number of sessions currently connected to and working on the database	Total Average Max Min
Sessions	Idle in transaction sessions	Count	The number of sessions currently waiting after a transaction has been started	Total Average Maximum Minimum
Sessions	Idle sessions	Count	The number of sessions that are connected but not performing any work	Total Average Maximum Minimum
Sessions	Total sessions	Count	Total number of sessions connected to the database (active + idle)	Total Average Maximum Minimum
Sessions	Waiting session	Count	Number of sessions waiting for locks, resources, and so on	Total Average Maximum Minimum
Sessions	Connection usage	Percent	Ratio of current connections to the allowed limit	Total Average Maximum Minimum
Sessions	Connection usage (Total)	Count	Number of connections in use in the entire connection pool	Total Average Max Min
State	Instance state	ERROR	DB Operational Status up: 1 down: 0	Total Average Maximum Minimum
Tablespace	Tablespace Used	Megabytes	Current tablespace usage	Total Average Maximum Minimum
Tablespace	Tablespace Total Used	Megabytes	Used size of the entire tablespace	Total Average Maximum Minimum
Transactions	Transaction Time max	Seconds	Duration of the longest-running transaction	Total Average Maximum Minimum
Transactions	Transaction Time max total	Count	Number of long transactions	Total Average Maximum Minimum

Table. PostgreSQL (DBaaS) basic metrics

Monitoring metrics

How-to guides