The page has been translated by Gen AI.

ServiceWatch metric

Vertica sends metrics to ServiceWatch. The metrics provided by basic monitoring are data collected at 1‑minute intervals.

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

Basic Metrics

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

The indicators whose names are shown in bold below are the key indicators selected from the basic indicators provided by Vertica(DBaaS). The key metrics are used to build service dashboards that are automatically created 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 itemsunitDetailed descriptionmeaningful statistics
CPUCPU UsagePercentCPU usage
  • Total
  • Average
  • Maximum
  • Minimum
DiskDisk UsagePercentDisk usage
  • Total
  • Average
  • Maximum
  • Minimum
DiskDisk Write BytesBytes/SecondWrite capacity (bytes/second) of block device
  • Total
  • Average
  • Maximum
  • Minimum
DiskDisk Read BytesBytes/SecondRead throughput (bytes/second) from block device
  • Total
  • Average
  • Maximum
  • Minimum
DiskDisk Write RequestsCount/SecondNumber of write requests on block device (requests per second)
  • Total
  • Average
  • Maximum
  • Minimum
DiskDisk Read RequestsCount/SecondNumber of read requests on block device (requests per second)
  • Total
  • Average
  • Maximum
  • Minimum
DiskAverage Disk I/O Queue SizeNoneAverage queue length of requests issued to the block device
  • Total
  • Average
  • Maximum
  • Minimum
DiskDisk I/O UtilizationPercentThe proportion of time the block device actually spent processing I/O operations.
  • Total
  • Average
  • Maximum
  • Minimum
MemoryMemory UsagePercentMemory usage
  • Total
  • Average
  • Maximum
  • Minimum
MemorySwap Out BytesBytes/SecondAmount of data transferred from memory to swap area (bytes/second)
  • Total
  • Average
  • Maximum
  • Minimum
MemorySwap Used BytesBytesSize of the currently used swap space
  • Total
  • Average
  • Maximum
  • Minimum
MemorySwap Cached UsagePercentCached swap usage rate
  • Total
  • Average
  • Maximum
  • Minimum
MemorySwap Total BytesBytesTotal swap space size configured on the system
  • Total
  • Average
  • Maximum
  • Minimum
MemorySwap In BytesBytes/SecondAmount read from swap area into memory (bytes/second)
  • Total
  • Average
  • Maximum
  • Minimum
MemorySwap UsagePercentCurrent usage ratio relative to total swap space
  • Total
  • Average
  • Maximum
  • Minimum
MemorySwap Cached BytesBytesSize of pages that have been restored to memory but still have a copy in the swap area
  • Total
  • Average
  • Maximum
  • Minimum
MemorySwap Free BytesBytesSize of swap space that remains unused
  • Total
  • Average
  • Maximum
  • Minimum
NetworkNetwork In BytesBytes/SecondReceived capacity (bytes/second) on the network interface
  • Total
  • Average
  • Maximum
  • Minimum
NetworkNetwork Out BytesBytes/SecondTransmitted capacity (bytes/second) on the network interface
  • Total
  • Average
  • Maximum
  • Minimum
NetworkTCP ConnectionsCount/SecondTotal number of TCP connections currently established correctly
  • Total
  • Average
  • Maximum
  • Minimum
NetworkNetwork In PacketsCountNumber of packets received on the network interface
  • Total
  • Average
  • Maximum
  • Minimum
NetworkNetwork Out PacketsCountNumber of packets transmitted on the network interface
  • Total
  • Average
  • Maximum
  • Minimum
NetworkNetwork In DroppedCountNumber of packet drops received on the network interface
  • Total
  • Average
  • Maximum
  • Minimum
NetworkNetwork Out DroppedCountNumber of packet drops transmitted from the network interface
  • Total
  • Average
  • Maximum
  • Minimum
NetworkNetwork In ErrorsCountNumber of packet errors received on the network interface
  • Total
  • Average
  • Maximum
  • Minimum
NetworkNetwork Out ErrorsCountNumber of packet errors transmitted from the network interface
  • Total
  • Average
  • Maximum
  • Minimum
OSOS UptimeSecondsTime elapsed (seconds) since the system was last booted
  • Total
  • Average
  • Maximum
  • Minimum
Table. OS basic metrics

Vertica(DBaaS) Basic Metrics

Classification
Performance itemsunitDetailed descriptionmeaningful statistics
Locks & LatchesActive locksCountNumber of Active Locks
  • Total
  • Average
  • Maximum
  • Minimum
SessionsActive sessionsCountNumber of active sessions
  • Total
  • Average
  • Maximum
  • Minimum
StateInstance stateNoneDB operational status
  • up: 1
  • down: 0
  • Total
  • Average
  • Maximum
  • Minimum
TablespaceData Tablespace UsedGigabytesData / Temp Tablespace usage
  • Total
  • Average
  • Maximum
  • Minimum
TablespaceCatalog Tablespace UsedGigabytesCatalog Tablespace usage
  • Total
  • Average
  • Maximum
  • Minimum
Table. Vertica (DBaaS) basic metrics
Monitoring metrics
How-to guides