Clearing PROJECTION_REFRESHES History

Information about a refresh operation—whether successful or unsuccessful—is maintained in system table PROJECTION_REFRESHES until the function CLEAR_PROJECTION_REFRESHES executes or the storage quota for the table is exceeded. The table's IS_EXECUTING column returns a boolean value that indicates whether the refresh is running now (t) or occurred earlier (f).

To immediately purge this information, use the CLEAR_PROJECTION_REFRESHES() function:

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

Note: Only the rows where the PROJECTION_REFRESHES.IS_EXECUTING column equals false are cleared.