You are here: Pega 7 Platform Database > Database tables and columns > Table types > Log tables

Log tables

The following Pega 7 Platform database tables can store instances of Log- classes. The key to these instances contains a date and time in UTC format.

Table

Description

pr_changelog Holds instances of the concrete classes derived from Log-System-. They record schema changes made using the Property Optimization tool and the Modify Schema tab.
pr_perf_stats Holds instances of the Log-Usage class.
pr_daily_usagepr_hourly_usagepr_license_parameters
pr_usage_summary
Supports the License Compliance facility. Select Designer Studio> System > License to report on the pr_usage_summary table.
pr_log_reportstats Holds instances of the Log-ReportStatistics class, containing statistics about each execution of a report definition.
pr4_log_rule_usage Holds statistics collected during system shutdown about cumulative rule execution statistics. Associated with the Log-RuleUsage class.
pr4_log_rule_usage_details

Corresponds to the Log-RuleUsage-Details class. Holds a daily snapshot of the system cache, that the system can scan at the next system startup to pre-populate the system cache.

pr_log_dataaccessaudit Corresponds to the Log-DataAccessAudit class. When configured in harnesses and flow actions, holds the details for each operator's use of those rules.
pr_log Holds instances of concrete classes derived from the Log- base class, other than those in the above tables.
pr_log_cluster Holds instances of the concrete classes derived from Log-Cluster-.

The Pega-RULES agent normally runs the standard Code-.SystemCleaner activity once each day for housekeeping tasks, including purging older records (instances) from certain log tables. In addition, the License Compliance facility includes built-in daily and end-of-period purging of Log- classes.