Cleaning collected Performance Analytics data

Performance Analytics scores and snapshots may grow over time and should be routinely cleaned to ensure optimal performance and accurate data.

Performance Analytics uses a scheduled job to remove old scores and snapshots.

The Clean PA collections scheduled job is active by default. The job deletes records according to best practices, so there is no impact on performance. By default, the job runs daily so it only has to delete a small amount of data.
Note: The table attributes nibble_size and nibble_sleep affect the behavior of the collection cleaner job if these attributes are defined for the Scores or Snapshots tables.

This scheduled job also deletes any Score [pa_scores], Score Level 1 [pa_scores_l1], Score Level 2 [pa_scores_l2], or Snapshots [pa_snapshots] records that do not have an associated indicator or breakdown. For example, if a user deletes an indicator, the scheduled job cleans up any scores or snapshots that were associated with the deleted indicator.