CATALOG_SYNC_STATE

Indicates the last time a node on an Eon Mode database synchronized its catalog to communal storage.

Column Name Data Type Description 
NODE_NAME

VARCHAR

 The node name for which information is listed.

SYNC_CATALOG_VERSION

INTEGER

 The version number of the catalog being synchronized. 
SYNC_TRAILING_INTERVAL

INTEGER

 The difference between the global catalog version and the synchronized catalog version for a node.

LAST_SYNC_AT

TIMESTAMPTZ

 The date and time the last time the catalog was synchronized.

Example

=> SELECT * FROM CATALOG_SYNC_STATE;
-[ RECORD 1 ]----------+------------------------------
node_name              | v_verticadb_node0002
sync_catalog_version   | 773
sync_trailing_interval | 0
last_sync_at           | 2018-02-07 16:18:32.968146+00