Monitoring Elastic Cluster Rebalancing

Vertica includes system tables that can be used to monitor the rebalance status of an elastic cluster and gain general insight to the status of elastic cluster on your nodes.

In each table, separated_percent and transferred_percent can be used to determine overall progress.

Historical Rebalance Information

Historical information about work completed is retained, so use the predicate "where is_latest" to restrict the output to only the most recent or current rebalance activity. The historical data may include information about dropped projections or tables. If a table or projection has been dropped and information about the anchor table is not available, then NULL is displayed for the table_id and "<unknown>" is displayed for the table_name. Information on dropped tables is still useful, for example, in providing justification for the duration of a task.