NODE_NAME

VARCHAR

Name of the node that is recovering or has recovered the corresponding projection.

PROJECTION_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the projection.

PROJECTION_NAME

VARCHAR

Name of the projection that is being or has been recovered on the corresponding node.

TRANSACTION_ID

INTEGER

Identifier for the transaction within the session, if any. TRANSACTION_ID initializes as NO_TRANSACTION with a value of 0. Vertica will ignore the recovery query and keep (0) if there's no action to take (no data in the table, etc). When no recovery transaction starts, ignored value appears in this table's STATUS column.

STATEMENT_ID

INTEGER

Unique numeric ID for the currently-running statement. NULL indicates that no statement is currently being processed. The combination of TRANSACTION_ID, STATEMENT_ID uniquely identifies a statement within a session.

METHOD

VARCHAR

Recovery method that Vertica chooses. Possible values are:

• incremental
• incremental-replay-delete
• split
• recovery-by-container

STATUS

VARCHAR

Current projection-recovery status on the corresponding node. STATUS can be "queued," which indicates a brief period between the time the query is prepared and when it runs. Possible values are:

• queued
• running
• finished
• ignored
• error-retry
• error-fatal

PROGRESS

INTEGER

An estimate (value in the range [0,100]) of percent complete for the recovery task described by this information.

Note: The actual amount of time it takes to complete a recovery task depends on a number of factors, including concurrent workloads and characteristics of the data; therefore, accuracy of this estimate can vary.

The PROGRESS column value is NULL after the task completes.

DETAIL

VARCHAR

More detailed information about PROGRESS. The values returned for this column depend on the type of recovery plan:

• General recovery plans – value displays the estimated progress, as a percent, of the three primary parts of the plan: Scan, Sort, and Write.
• Recovery-by-container plans – value begins with CopyStorage: and is followed by the number of bytes copied over the total number of bytes to copy.
• Replay delete plans – value begins with Delete: and is followed by the number of deletes replayed over an estimate of the total number of deletes to replay.

The DETAIL column value becomes NULL after the recovery plan completes.

START_TIME

TIMESTAMPTZ

Time the recovery task described by this information started.

END_TIME

TIMESTAMPTZ

Time the recovery task described by this information ended.

RUNTIME_PRIORITY

VARCHAR

Determines the amount of runtime resources (CPU, I/O bandwidth) the Resource Manager should dedicate to running queries in the resource pool. Valid values are:

• HIGH
• MEDIUM
• LOW