Executive Summary
Pega Cloud has identified issues related to the increasing size of the Performance Statistics (pr_perf_stats) table. To mitigate the risk of out-of-the-box cleanup activity failure, we recommend that clients implement the proactive measures outlined below to ensure ongoing table maintenance and hygiene.
Problem Statement:
Database growth related to the increasing size of the pr_perf_stats table.
Analysis and Root Cause:
The root cause of pr_perf_stats table growth is typically attributed to a high volume of API calls.
Immediate action to be taken:
- Create or update the following Dynamic System Setting (DSS):
Setting Purpose: PRCONFIG/SERVICE/SNAPSHOT/MERGER/IDENTIFIER
Owning Ruleset: Pega Engine
Value: False - Restart the environment.
This setting will work on Pega Platform 24.1.4+, 24.2.3+ or 25.1.1+ release. If you are not yet on these versions, it can still be created and will start taking effect after updating. After these steps have been taken, the number of inserts into the pr_perf_stats table will be reduced for APP requestors.
Additional steps to consider:
- If you are on Pega Platform ’25 release and are not using this data for APP requestors, you can further reduce the amount of data being saved to this table by creating or updating the following DSS:
Setting Purpose: PRCONFIG/USAGE/APPREQUESTORUSAGETRACKINGENABLED
Owning Ruleset: Pega Engine
Value: False - Restart the environment.
After these steps have been taken, APP requestors will no longer cause inserts into this table.
If you have any questions or concerns, please raise a Support ticket with Global Client Support in My Support Portal for assistance.