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:
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 | |
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