PROJECTION_CHECKPOINT_EPOCHS

Provides details on checkpoint epochs.

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 CHECKPOINT_EPOCH can be used to recover from an unclean shutdown:

  • tCHECKPOINT_EPOCH is less than or equal to the cluster's Last Good Epoch, so data up to and including this epoch can be used during recovery.
  • fVertica must use Last Good Epoch to recover data for this projection.

See also:GET_LAST_GOOD_EPOCH

IS_BEHIND_AHM BOOLEAN

Specifies whether CHECKPOINT_EPOCH is less than the AHM (ancient history mark). If set to t (true), data for this projection cannot rolled back.

See also: GET_AHM_EPOCH

Privileges

No explicit privileges are required. You only see the records for tables that you have privileges to view.

Examples

=> SELECT epoch FROM t;
 epoch
-------
    52
    52
    53
(3 rows)

=> SELECT node_name, projection_schema, projection_name, is_up_to_date, checkpoint_epoch
FROM projection_checkpoint_epochs;
node_name           | projection_schema |  projection_name | is_up_to_date | checkpoint_epoch
--------------------+-------------------+------------------+---------------+------------------
v_vmart_node0001    | public            | t_super          | t             | 51
v_vmart_node0001    | public            | p_super          | t             | 51
(2 rows)
=> SELECT DO_TM_TASK('moveout','');
                                 do_tm_task
--------------------------------------------------------------------------
 Task: moveout
(Table: public.t) (Projection: public.t_super)
(Table: public.p) (Projection: public.p_super)
(1 row)
=> SELECT node_name, projection_schema, projection_name, is_up_to_date, checkpoint_epoch
FROM projection_checkpoint_epochs;
node_name           | projection_schema | projection_name | is_up_to_date | checkpoint_epoch
--------------------+-------------------+-----------------+---------------+------------------
v_vmart_node0001    | public            | t_super         | t             | 53
v_vmart_node0001    | public            | p_super         | t             | 53
(2 rows)