TABLE_RECOVERY_STATUS

Provides node recovery information during a Recovery By Table.

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

Examples

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