RESHARDING_EVENTS

Monitors historic and ongoing resharding operations.

Monitors historic and ongoing resharding operations.

Column Name Data Type Description
EVENT_TIME_STAMP TIMESTAMP Date and time of the resharding event.
NODE_NAME VARCHAR Node name for which resharding information is listed.
SESSION_ID VARCHAR Unique numeric ID assigned by the Vertica catalog that identifies the session for which resharding information is captured. This identifier is unique within the cluster at any point in time but can be reused when the session closes.
USER_ID INTEGER Numeric ID of the user who ran the resharding operation.
USER_NAME VARCHAR Name of the user who ran the resharding operation.
TRANSACTION_ID INTEGER Numeric ID of the specified rehsarding transaction within the session.
RUNNING_STATUS VARCHAR

Current status of the resharding operation, one of the following strings:

  • START: The resharding operation has begun on all nodes.

  • RUNNING: The shard named OLD_SHARD_NAME is currently being resharded on the node.

  • RESHARDED: The resharding operation on the node is complete for the shard named OLD_SHARD_NAME.

  • ABORT: The resharding operation was aborted on all nodes.

  • COMPLETE: The resharding operation has completed for all nodes in the database.

OLD_SHARD_NAME VARCHAR Name of the shard to which the node was subscribed previous to the resharding operation. You can query the SHARDS system table for information about the new shard configuration.
OLD_SHARD_OID INTEGER Numeric ID of the shard to which the node was subscribed previous to the resharding operation.
OLD_SHARD_LOWER_BOUND INTEGER Lower bound of the shard to which the node was subscribed prior to the resharding operation. This value is set only if the resharding operation is complete for the shard specified by OLD_SHARD_OID.
OLD_SHARD_UPPER_BOUND INTEGER Upper bound of the shard to which the node was subscribed prior to the resharding operation. This value is set only if the resharding operation is complete for the shard specified by OLD_SHARD_OID.
CATALOG_SIZE INTEGER Catalog size (in bytes) on the node for the shard specified by OLD_SHARD_NAME. This value is provided only when the RUNNING_STATUS of the node is RUNNING or RESHARDED.

Privileges

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.

See also