Clearing Projection Refresh History

System table PROJECTION_REFRESHES records information about refresh operations, successful and unsuccessful. PROJECTION_REFRESHES retains projection refresh data until one of the following events occurs:

  • Another refresh operation starts on a given projection.
  • CLEAR_PROJECTION_REFRESHES is called and clears data on all projections.
  • The table's storage quota is exceeded.

To immediately purge this information, call CLEAR_PROJECTION_REFRESHES:

=> SELECT clear_projection_refreshes(); 
clear_projection_refreshes
----------------------------
 CLEAR
(1 row)

PROJECTION_REFRESHES checks the Boolean column IS_EXECUTING in PROJECTION_REFRESHES to determine whether refresh operations are still running or are complete. The function only removes information for refresh operations that are complete.

See Also

PROJECTION_REFRESHES