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:
|
SOURCE_CAP |
INTEGER |
Effective
|
TARGET_CAP |
INTEGER |
Effective
|
SUCCESS |
BOOLEAN |
True, if the query successfully moved to the target pool. |
RESULT_REASON |
VARCHAR |
States reason for success or failure of the move. |