PROJECTION_RECOVERIES

Retains history about projection recoveries.

Retains history about projection recoveries. Because Vertica adds an entry per recovery plan, a projection/node pair might appear multiple times in the output.

Column Name Data Type Description
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

Privileges

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.

See also

RECOVERY_STATUS