The page has been translated by Gen AI.

ServiceWatch metric

PostgreSQL (DBaaS) sends metrics to ServiceWatch. The metrics provided by basic monitoring are data collected at 1‑minute intervals.

Reference

For instructions on how to view metrics in ServiceWatch, refer to the ServiceWatch guide.

Basic Metrics

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

The indicators whose names are displayed in bold below are the key indicators selected from the basic metrics provided by PostgreSQL(DBaaS). Key metrics are used to configure service dashboards that are automatically built for each service in ServiceWatch.

Each metric provides guidance in the user guide on which statistical values are meaningful when viewing that metric, and among the meaningful statistics, the values shown in bold are the primary statistics. In the service dashboard, you can view key metrics through primary statistical values.

OS Basic Metrics

Classification	Performance items	unit	Detailed description	meaningful statistics
CPU	CPU Usage	Percent	CPU usage	Total Average Maximum Minimum
Disk	Disk Usage	Percent	Disk usage	Total Average Maximum Minimum
Disk	Disk Write Bytes	Bytes/Second	Write throughput on block device (bytes/second)	Total Average Maximum Minimum
Disk	Disk Read Bytes	Bytes/Second	Read throughput from block device (bytes/second)	Total Average Maximum Minimum
Disk	Disk Write Requests	Count/Second	Number of write requests on block device (requests per second)	Total Average Maximum Minimum
Disk	Disk Read Requests	Count/Second	Number of read requests on block device (requests per second)	Total Average Maximum Minimum
Disk	Average Disk I/O Queue Size	None	Average queue length of requests issued to the block device	Total Average Maximum Minimum
Disk	Disk I/O Utilization	Percent	The proportion of time the block device actually performed I/O operations	Total Average Maximum Minimum
Memory	Memory Usage	Percent	Memory usage	Total Average Maximum Minimum
Memory	Swap Out Bytes	Bytes/Second	Data transferred from memory to swap area (bytes/second)	Total Average Maximum Minimum
Memory	Swap Used Bytes	Bytes	Current swap space size	Total Average Maximum Minimum
Memory	Swap Cached Usage	Percent	Cache swap utilization	Total Average Maximum Minimum
Memory	Swap Total Bytes	Bytes	Total swap space size configured on the system	Total Average Maximum Minimum
Memory	Swap In Bytes	Bytes/Second	Amount read from swap area to memory (bytes/second)	Total Average Maximum Minimum
Memory	Swap Usage	Percent	Current usage ratio relative to total swap space	Total Average Maximum Minimum
Memory	Swap Cached Bytes	Bytes	Size of pages that have been restored to memory but still have a copy in the swap area	Total Average Maximum Minimum
Memory	Swap Free Bytes	Bytes	Size of swap space that remains unused	Total Average Maximum Minimum
Network	Network In Bytes	Bytes/Second	Received capacity (bytes/second) on the network interface	Total Average Maximum Minimum
Network	Network Out Bytes	Bytes/Second	네트워크 인터페이스에서 송신된 용량(바이트/초)	Total Average Maximum Minimum
Network	TCP Connections	Count/Second	Total number of properly 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 packet drops received on the network interface	Total Average Maximum Minimum
Network	Network Out Dropped	Count	Number of packet drops transmitted from 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 packet errors transmitted from the network interface	Total Average Maximum Minimum
OS	OS Uptime	Seconds	Time elapsed (seconds) since the system was last booted	Total Average Maximum Minimum

Table. OS basic metrics

PostgreSQL(DBaaS) basic metrics

Classification	Performance items	unit	Detailed description	meaningful statistics
Frozenxid	DB age max	None	The point in time when the oldest transaction started (time)	Total Average Maximum Minimum
Locks	Active locks (total)	Count	Total of all currently active locks	Total Average Maximum Minimum
Locks	Exclusive locks	Count	Number of exclusive locks that other sessions cannot access at all	Total Average Maximum Minimum
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 lock, used in SELECT … FOR UPDATE, etc.	Total Average Maximum Minimum
Locks	Share locks	Count	Shared lock on the entire object, used for read‑only transactions	Total Average Maximum Minimum
Locks	Share row exclusive locks	Count	Lock that applies both shared and row‑exclusive.	Total Average Maximum Minimum
Locks	Share update exclusive locks	Count	Shared update-only lock, used for rapidly changing data	Total Average Maximum Minimum
Locks	Wait Locks (long)	Count	Number of lock requests waiting for a long time	Total Average Maximum Minimum
Locks	Wait Locks (total)	Count	Number of all pending lock requests	Total Average Maximum Minimum
Replication	Apply Lag Time	Seconds	Replication latency (Primary → Standby)	Total Average Maximum Minimum
Replication	Check no Replication	Count	Indicator confirming the absence of replication settings	Total Average Maximum Minimum
Replication	Check replication	Count	Metric to verify that the replication status is normal	Total Average Maximum Minimum
Sessions	Active sessions	Count	Number of sessions currently connected to the database and active	Total Average Maximum Minimum
Sessions	Idle in transaction sessions	Count	Transaction started, but currently there are waiting sessions	Total Average Maximum Minimum
Sessions	Idle sessions	Count	Number of sessions that are maintaining a connection without 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, etc.	Total Average Maximum Minimum
Sessions	Connection usage	Percent	Allowed limit ratio relative to the current number of connections	Total Average Maximum Minimum
Sessions	Connection usage (Total)	Count	Number of connections currently in use in the entire connection pool	Total Average Maximum Minimum
State	Instance state	None	DB operation status up: 1 down: 0	Total Average Maximum Minimum
Tablespace	Tablespace Used	Megabytes	Current tablespace capacity in use	Total Average Maximum Minimum
Tablespace	Tablespace Total Used	Megabytes	Usage ratio (%) of total 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