REPLICATION_STATUS

Monitors the status of server-based data replication.

Shows the status of current and past server-based replication of data from another Eon Mode database to this database. Each row records node-specific information about a given replication. For more information about server-based replication, see Server-based replication.

Note

If you replicate data between the main cluster and a sandboxed cluster, the SENT_BYTES and TOTAL_BYTES_TO_SEND columns will both have a value of zero. Because the clusters use the same communal storage location, no data is actually copied between the two clusters.

Column name	Data type	Description
NODE_NAME	VARCHAR(128)	The name of the node participating in the replication.
TRANSACTION_ID	INT	The transaction in which the replication took place.
STATUS	VARCHAR(8192)	The state of the replication. Values include: `abort`: The replication did not complete successfully. `completed`: The replication has completed. `data transferring`: the node is actively copying shards from the source database's communal storage.
SENT_BYTES	INT	The number of bytes that the node has retrieved from the source database's communal storage.
TOTAL_BYTES_TO_SEND	INT	The total number of bytes the node has to retrieve from the source database's communal storage for this replication.
START_TIME	TIMESTAMPTZ	The start time of the replication.
END_TIME	TIMESTAMPTZ	The time at which the node finished transferring data for the replication.

Example

=> SELECT node_name, status, transaction_id FROM REPLICATION_STATUS 
   ORDER BY start_time ASC;
       node_name       |      status       |  transaction_id   
-----------------------+-------------------+-------------------
 v_target_db_node0001  | completed         | 45035996273706044
 v_target_db_node0002  | completed         | 45035996273706044
 v_target_db_node0003  | completed         | 45035996273706044
 v_target_db_node0001  | completed         | 45035996273706070
 v_target_db_node0002  | completed         | 45035996273706070
 v_target_db_node0003  | completed         | 45035996273706070
 v_target_db_node0002  | data transferring | 45035996273706136
 v_target_db_node0003  | data transferring | 45035996273706136
 v_target_db_node0001  | data transferring | 45035996273706136
(9 rows)