PROJECTION_CHECKPOINT_EPOCHS

Records when each projection checkpoint epoch changes.

Column Name Data Type Description
NODE_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the node for which information is listed

NODE_NAME

VARCHAR

Node name for which information is listed.

PROJECTION_SCHEMA_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the specific schema that contains the projection.

PROJECTION_SCHEMA

VARCHAR

Schema containing the projection.

PROJECTION_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the projection.

PROJECTION_NAME

VARCHAR

Projection name for which information is listed.

IS_UP_TO_DATE

BOOLEAN

Indicates whether the projection is up to date, where t is true and f is false. Projections must be up to date for queries to use them.

CHECKPOINT_EPOCH

INTEGER

Checkpoint epoch of the projection on the corresponding node. Data up to and including this epoch is in persistent storage. If the node were to fail, without moving more data out of the WOS, data after this epoch would need to be recovered.

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)