TABLE_RECOVERIES

Provides detailed information about recovered and recovering tables during a recovery by table.

Column Name Data Type Description
NODE_NAME

VARCHAR

Name of the node that is performing the recovery.

STATUS

VARCHAR

The status of the table. Tables can have the following status:
  • recovered - The table is fully recovered
  • recovering - The table is in the process of recovery
  • error_retry - Vertica has attempted to recover the table, but the recovery failed.

Tables that have not yet begun the recovery process do not have a status.

TABLE_NAME
VARCHAR The name of the table being recovered.
TABLE_OID
INTEGER The object ID of the table being recovered.
START_TIME
TIMESTAMPZ The date and time that the table began recovery.
END_TIME
TIMESTAMPZ The date and time that the table completed recovery.
PHASE
VARCHAR

The phase of the recovery.

RECOVER_PRIORITY
INTEGER The recovery priority of the table being recovered.
THREAD_ID
VARCHAR The ID of the thread that performed the recovery.

Privileges

None