TABLE_RECOVERY_STATUS
Provides node recovery information during a Recovery By Table.
| Column Name | Data Type | Description |
|---|---|---|
NODE_NAME |
VARCHAR |
Name of the node that is performing the recovery. |
NODE_RECOVERY_START_TIME |
TIMESTAMPZ | The timestamp for when the node began recovering. |
RECOVER_EPOCH |
INTEGER | The epoch that the recovery operation is trying to recover to. |
RECOVERING_TABLE_NAME |
VARCHAR | The name of the table currently recovering. |
TABLES_REMAIN |
INTEGER | The total number of tables on the node. |
IS_RUNNING |
BOOLEAN |
Indicates if the recovery process is still running. |
Privileges
None
Example
=> SELECT * FROM TABLE_RECOVERY_STATUS;
-[ RECORD 1 ]------------+-----------------
node_name | v_vmart_node0001
node_recovery_start_time |
recover_epoch |
recovering_table_name |
tables_remain | 0
is_running | f
-[ RECORD 2 ]------------+-----------------
node_name | v_vmart_node0002
node_recovery_start_time |
recover_epoch |
recovering_table_name |
tables_remain | 0
is_running | f
-[ RECORD 3 ]------------+-----------------
node_name | v_vmart_node0003
node_recovery_start_time | 2017-12-13 08:47:28.282377-05
recover_epoch | 23
recovering_table_name | user_table
tables_remain | 5
is_running | y