RESOURCE_POOL_MOVE

Displays the cascade event information on each node.

Column Name Data Type Description
NODE_NAME

VARCHAR

Node name for which information is listed.

MOVE_TIMESTAMP

TIMESTAMPZ

Time when the query attempted to move to the target pool.

SESSION_ID

VARCHAR

Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused when the session closes.

USER_ID

INTEGER

Identifies the query event user.

USER_NAME

VARCHAR

Name of the user for which Vertica lists query information at the time it records the session.

TRANSACTION_ID

INTEGER

Transaction identifier for the request.

STATEMENT_ID	

INTEGER

Unique numeric ID for the statement.

SOURCE_POOL_NAME

VARCHAR

Name of the resource pool where the query was executing when Vertica attempted the move.

TARGET_POOL_NAME

VARCHAR

Name of resource pool where the query attempted to move.

MOVE_CAUSE

VARCHAR

Denotes why the query attempted to move.

Valid values:

  • MOVE RESOURCE POOL COMMAND
  • RUNTIMECAP EXCEEDED
SOURCE_CAP

INTEGER

Effective RUNTIMECAP value for the source pool. The value represents the lowest of these three values:

  • session RUNTIMECAP
  • user RUNTIMECAP
  • source pool RUNTIMECAP
TARGET_CAP

INTEGER

Effective RUNTIMECAP value for the target pool. The value represents the lowest of these three values:

  • session RUNTIMECAP
  • user RUNTIMECAP
  • target pool RUNTIMECAP
SUCCESS

BOOLEAN

True, if the query successfully moved to the target pool.

RESULT_REASON	

VARCHAR

States reason for success or failure of the move.