Vertica Analytics Platform Version 9.2.x Documentation

SYSTEM

Monitors the overall state of the database.

Column Name Data Type Description
CURRENT_EPOCH INTEGER

The current epoch number.

AHM_EPOCH INTEGER

The AHM epoch number.

LAST_GOOD_EPOCH INTEGER

The smallest (min) of all the checkpoint epochs on the cluster.

REFRESH_EPOCH INTEGER

Deprecated, always set to -1.

DESIGNED_FAULT_TOLERANCE INTEGER

The designed or intended K-safety level.

NODE_COUNT INTEGER

The number of nodes in the cluster.

NODE_DOWN_COUNT INTEGER

The number of nodes in the cluster that are currently down.

CURRENT_FAULT_TOLERANCE INTEGER

The number of node failures the cluster can tolerate before it shuts down automatically.

This is the current K-safety level.

CATALOG_REVISION_NUMBER INTEGER

The catalog version number.

WOS_USED_BYTES INTEGER

The WOS size in bytes (cluster-wide).

WOS_ROW_COUNT INTEGER

The number of rows in WOS (cluster-wide).

ROS_USED_BYTES INTEGER

The ROS size in bytes (cluster-wide).

ROS_ROW_COUNT INTEGER

The number of rows in ROS (cluster-wide).

TOTAL_USED_BYTES INTEGER

The total storage in bytes (WOS + ROS) (cluster-wide).

TOTAL_ROW_COUNT INTEGER

The total number of rows (WOS + ROS) (cluster-wide).