CATALOG_TRUNCATION_STATUS
Indicates how up to date the catalog is on communal storage. It is completely up to date when the current catalog version is the same as the catalog truncation version.
The catalog truncation version (CTV) is the version that a Vertica cluster revives to after a crash, shutdown, or hibernation. There is only one CTV for all nodes in a cluster.
| Column Name | Data Type | Description |
|---|---|---|
|
CURRENT_CATALOG_VERSION |
INTEGER |
The version number of the catalog currently on the cluster. |
|
TRUNCATION_CATALOG_VERSION |
INTEGER |
The version number as of the last time the catalog was synced on communal storage. |
Example
=> SELECT * FROM CATALOG_TRUNCATION_STATUS; -[ RECORD 1 ]--------------+---- current_catalog_version | 773 truncation_catalog_version | 0
