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