The page has been translated by Gen AI.

ServiceWatch metric

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

Reference

Refer to the ServiceWatch guide for how to view metrics in ServiceWatch.

Basic Metrics

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

The indicators whose names are shown in bold below are the key indicators selected from the basic indicators provided by EPAS(DBaaS). The main 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 capacity (bytes/second) of block device	Total Average Maximum Minimum
Disk	Disk Read Bytes	Bytes/Second	Read throughput (bytes/second) from block device	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 spent processing I/O operations.	Total Average Maximum Minimum
Memory	Memory Usage	Percent	Memory usage	Total Average Maximum Minimum
Memory	Swap Out Bytes	Bytes/Second	Amount of data transferred from memory to swap area (bytes/second)	Total Average Maximum Minimum
Memory	Swap Used Bytes	Bytes	Size of the currently used swap space	Total Average Maximum Minimum
Memory	Swap Cached Usage	Percent	Cached swap usage rate	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 into 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	Transmitted capacity (bytes/second) on the network interface	Total Average Maximum Minimum
Network	TCP Connections	Count/Second	Total number of TCP connections currently established correctly	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

EPAS(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	A lock that applies both shared and row‑exclusive modes simultaneously	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 that no replication is configured	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 the number of waiting sessions.	Total Average Maximum Minimum
Sessions	Idle sessions	Count	Number of sessions that are maintaining only the 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 in use in the entire connection pool	Total Average Maximum Minimum
State	Instance state	None	DB operational 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. EPAS (DBaaS) basic metrics

Monitoring metrics

How-to guides