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.