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