PROJECTION_CHECKPOINT_EPOCHS
Provides details on checkpoint epochs, applies only to Enterprise Mode.
Column Name | Data Type | Description |
---|---|---|
NODE_ID | INTEGER |
Unique numeric identifier of this projection's node. |
NODE_NAME | VARCHAR |
Name of this projection's node. |
PROJECTION_SCHEMA_ID | INTEGER |
Unique numeric identifier of the projection schema. |
PROJECTION_SCHEMA | VARCHAR |
Name of the projection schema. |
PROJECTION_ID | INTEGER |
Unique numeric identifier of this projection. |
PROJECTION_NAME | VARCHAR |
Name of this projection. |
IS_UP_TO_DATE | BOOLEAN |
Specifies whether the projection is up to date and available to participate in query execution. |
CHECKPOINT_EPOCH | INTEGER |
Checkpoint epoch of the projection on the corresponding node. Data up to and including this epoch is in persistent storage, and can be recovered in the event of node failure. |
WOULD_RECOVER | BOOLEAN |
Determines whether data up to and including
See also: GET_LAST_GOOD_EPOCH |
IS_BEHIND_AHM | BOOLEAN |
Specifies whether See also: GET_AHM_EPOCH |
Privileges
Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.
Examples
=> SELECT node_name, projection_schema, projection_name, is_up_to_date, checkpoint_epoch FROM projection_checkpoint_epochs WHERE projection_name ilike 't1_b%' ORDER BY projection_name, node_name; node_name | projection_schema | projection_name | is_up_to_date | checkpoint_epoch ------------------+-------------------+-----------------+---------------+------------------ v_vmart_node0001 | public | t1_b1 | t | 965 v_vmart_node0002 | public | t1_b1 | t | 965 v_vmart_node0003 | public | t1_b1 | t | 965 v_vmart_node0001 | public | t1_b0 | t | 965 v_vmart_node0002 | public | t1_b0 | t | 965 v_vmart_node0003 | public | t1_b0 | t | 965 (6 rows) dbadmin=> INSERT INTO t1 VALUES (100, 101, 102); OUTPUT -------- 1 (1 row) dbadmin=> COMMIT; COMMIT dbadmin=> SELECT node_name, projection_schema, projection_name, is_up_to_date, checkpoint_epoch FROM projection_checkpoint_epochs WHERE projection_name ILIKE 't1_b%' ORDER BY projection_name, node_name; node_name | projection_schema | projection_name | is_up_to_date | checkpoint_epoch ------------------+-------------------+-----------------+---------------+------------------ v_vmart_node0001 | public | t1_b1 | t | 966 v_vmart_node0002 | public | t1_b1 | t | 966 v_vmart_node0003 | public | t1_b1 | t | 966 v_vmart_node0001 | public | t1_b0 | t | 966 v_vmart_node0002 | public | t1_b0 | t | 966 v_vmart_node0003 | public | t1_b0 | t | 966 (6 rows)