Question
SunLife
CA
Last activity: 3 Feb 2026 15:51 EST
Daily Usage Table size and sql performance
The table pr_daily_usage is growing quite large , and the sql running in the db is consuming a lot of resources. What dss setting can be set to control the retention period of this table? What job does the purging of this table?
Accepted Solution
Updated: 3 Feb 2026 15:51 EST
Pegasystems Inc.
CA
HCA Healthcare
US
Set the DSS in Pega-Engine named prconfig/usage/retentionperiod/default to the number of days you want to keep rows in pr_daily_usage. This value is read into pxProcess.pxLogUsageRetentionPeriod, which drives how old usage rows are eligible for deletion. The actual purge is done by the daily housekeeping run of the Pega-RULES agent, which executes Code-.SystemCleaner and removes old log/usage data based on that retention.
SunLife
CA
@Sairohith looking at the systemcleaner and usageleaner activities, I don't see any cleaning up of the "Log-License-Usage-Daily" class.
Accepted Solution
Updated: 3 Feb 2026 15:51 EST
Pegasystems Inc.
CA
Default Retention: 12 months.
You can override retention defaults for usage-related logs using the DSS prconfig/usage/retentionperiod/default or by adding a prconfig.xml entry.
Note: similar table pr_perf_stats (Log-Usage) is controlled by the DSS pxLogUsageRetentionPeriod, which defaults to 30 days.
@GiuseppeD6582
Default Retention: 12 months.
You can override retention defaults for usage-related logs using the DSS prconfig/usage/retentionperiod/default or by adding a prconfig.xml entry.
Note: similar table pr_perf_stats (Log-Usage) is controlled by the DSS pxLogUsageRetentionPeriod, which defaults to 30 days.