Clearing projection refresh history

To immediately purge this information, call CLEAR_PROJECTION_REFRESHES:.

The PROJECTION_REFRESHES system table records information about successful and unsuccessful refresh operations. This table normally retains data for a projection until replaced by a new refresh of that projection, but you can also purge the table.

To immediately purge data for all completed refreshes, call CLEAR_PROJECTION_REFRESHES:

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

This function does not clear data for refreshes that are currently in progress.