RESOURCE_POOL_MOVE

Displays the cascade event information on each node.

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 TIMESTAMPTZ 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.

See also