PROJECTION_REFRESHES
System table PROJECTION_REFRESHES
records information about refresh operations, successful and unsuccessful. PROJECTION_REFRESHES
retains refresh data until one of the following events occurs:
CLEAR_PROJECTION_REFRESHES
is called.- The table's storage quota is exceeded.
Tables and projections can be dropped while a query runs against them. The query continues to run, even after the drop occurs. Only when the query finishes does it notice the drop, which might cause a rollback. The same is true for refresh queries. Thus, PROJECTION_REFRESHES
might report that a projection failed to be refreshed before the refresh query completes. In this case, the REFRESH_DURATION_SEC
column continues to increase until the refresh query completes.
Column Name | Data Type | Description |
---|---|---|
NODE_NAME
|
VARCHAR |
Node where the refresh was initiated. |
PROJECTION_SCHEMA
|
VARCHAR |
Name of the projection schema. |
PROJECTION_ID
|
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies the projection. |
PROJECTION_NAME
|
VARCHAR |
Name of the refreshed projection. |
ANCHOR_TABLE_NAME
|
VARCHAR |
Name of the projection's anchor table. |
REFRESH_STATUS
|
VARCHAR |
Status of refresh operations for this projection, one of the following:
|
REFRESH_PHASE
|
VARCHAR |
Indicates how far the refresh has progressed:
The LOCKS system table is useful for determining if a refresh is blocked on a table lock. To determine if a refresh has been blocked, locate the term "refresh" in the transaction description. A refresh has been blocked when the scope for the refresh is REQUESTED and other transactions acquired a lock on the table. This field is NULL until the projection starts to refresh and is NULL after the refresh completes. |
REFRESH_METHOD
|
VARCHAR |
Method used to refresh the projection:
|
REFRESH_FAILURE_COUNT
|
INTEGER |
Number of times a refresh failed for the projection. |
SESSION_ID
|
VARCHAR |
Unique numeric ID assigned by the Vertica catalog, which identifies the refresh session. |
REFRESH_START
|
TIMESTAMPTZ |
Time the projection refresh started. |
REFRESH_DURATION_SEC
|
INTERVAL SECOND (0) |
How many seconds the projection refresh ran. |
IS_EXECUTING
|
BOOLEAN |
Differentiates active and completed refresh operations. |
RUNTIME_PRIORITY
|
VARCHAR |
Determines how many run-time resources (CPU, I/O bandwidth) the Resource Manager should dedicate to running queries in the resource pool, one of the following:
|
TRANSACTION_ID
|
INTEGER |
Identifier for the transaction within the session, if any; otherwise NULL. The |
Privileges
Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.