Don't confuse Log-Usage data, which covers system and requestor performance of all types. with Log-RuleUsage data, which cover only rules assembly rules — rules of those rule types that the system converts to Java code.Instances of the Log-Usage class, which (in the initial PegaRULES database schema) are stored in the pr_perf_stats table, support system-performance and usage reporting.
The instances in this class provide a cumulative history of past system usage across all nodes and all requestor types. Analyses of this data can provide valuable insights about the patterns and sources of processing demand, and can be helpful in performance tuning.
Don't confuse Log-Usage data, which covers system and requestor performance of all types. with Log-RuleUsage data, which cover only rules assembly rules — rules of those rule types that the system converts to Java code.
Don't confuse Log-Usage reporting — which provides comprehensive coverage of system activity — with the reports provided by the License Compliance facility, which focus on specific metrics and uses a separate data-collection mechanism.
The key (pzInsKey column) of the pr_perf_stats table — the key of each Log-Usage instance — is concatenated from the values of four properties:
The first character of the requestor ID identifies a requestor type:
APP requestor types)BATCH requestor type)BROWSER requestor type)PORTLET requestor type)Record types
The pxSnapshotType column identifies an important value needed to interpret the other values in a record. This column has one of six values:
INTERVAL — Records cumulative usage statistics for a requestor as of the end of an interval (typically a clock hour).PASSIVATED — Records passivation of a requestor, such as occurs when a session times out. The PersistRequestor entry in the prconfig.xml file or Dynamic System Setting controls passivation.TERMINATED — Records log-out, forced timeout, or other termination of a requestor.PALCLEAR — Records that a requestor cleared PAL statistics. MERGED_AGENTS — Records details from multiple agent requestors
For agents and daemons, the pyProcLabel property identifies the agent, the index of the row on the Rule-Agent-Queue form, and the activity. The subscript is zero-based; for example, the value:
Pega-ProCom:2:Assign-Corr.SendCorr
in a log identifies processing by the Assign-Corr.SendCorr activity listed the second row of Agent Queue form for the Pega-RULES agent.
For daemons such as the master agent, the pyProcLabel column is blank.
When the system adds to this class
A daemon known as the Usage Daemon commits instances of the Log-Usage class to the database table.
The Usage Daemon saves an instance of the Log-Usage class when a requestor terminates, passivates, activates, and at regular hourly intervals. To minimize the performance effect of new instances, the daemon's write operations are deferred and then committed as a group.
By default, INTERVAL operations record a snapshot at 59 minutes after each hour. For example, if an Operator signs on at 11:15 AM and signs off at 11:56 AM, no INTERVAL instances for that requestor are logged.
By default, this daemon wakes every 300 seconds, so the contents of the table may be stale or incomplete by as much as five minutes.
In a multinode cluster, the Usage Daemons on each node operate independently, so the presence of records in the database table with a recent pxSnapShotTime from one node does not imply that no more records with a similar or earlier pxSnapShotTime value will arrive.
Because agents are requestors, this daemon adds instances to the Log-Usage class for agents even when the system has no interactive users. This behavior is expected.
Some service requestors end a few seconds or less after they start; typically no INTERVAL instances appear for such requestors. If a service uses pooled requestors, INTERVAL instances may appear for those requestors in the pool once each hour.
Reporting
To facilitate reporting, all properties of the Log-Usage class are exposed as columns of the pr_perf_stats table; this table does not contain a Storage Stream column.
These standard reports are available:
> System >Assembly> > Assembly Compilation Summary to run the Assembly Compilation Summary. This report is produced by the summary view report Log-Usage.pzAssemblyCompilationSummary. This report shows the number and time of assemblies and compilations, broken out by node. > System >Performance > Active RuleSet lists to run the basic performance data broken out by RuleSet list. Click a RuleSet list hash code to see the RuleSets and versions that are contained in that hash.> System > Performance > My Performance Details to see interaction end data for your Operator ID for the past week (both user and time range are configurable). The list is sorted by requestorID, and you can drill down into interval/passivation/termination records. You can then drill down further to get full details (similar to the Performance details screen).Except for the properties in the following table, the names and meanings of statistical properties in the Log-Usage class is identical to the names and meanings of those in the Code-Pega-PAL class, which supports the Performance tool. For a listing and brief descriptions of those properties, see Performance tool — Full details display.
For technical reasons, Log-Usage properties listed in the following table have a shorter name from the corresponding Code-Pega-PAL properties.
Code-Pega-PAL Property |
Log-Usage Property |
| pxDeclarativeRulesInvokedBackgroundCount | pxDeclRulesInvokedBckGrdCnt |
| pxDeclarativeRulesInvokedElapsed | pxDeclRulesInvokedElapsed |
| pxDeclarativeRulesLookupElapsed | pxDeclRulesLookupElapsed |
| pxListRowWithFilteredStreamCount | pxListRowWithFilteredStrmCnt |
| pxListRowWithUnfilteredStreamCount | pxListRowWithUnfilteredStrmCnt |
| pxListWithUnfilteredStreamCount | pxListWithUnfilteredStrmCnt |
| pxSavedClipboardAfterInteractionCount | pxSavedCbAfterIntCount |
| pxSavedClipboardAfterInteractionCPU | pxSavedCbAfterIntCPU |
| pxSavedClipboardAfterInteractionElapsed | pxSavedCbAfterIntElapsed |
| pxSavedContextAfterInteractionCount | pxSavedCxtAfterIntCount |
| pxSavedContextAfterInteractionCPU | pxSavedCxtAfterIntCPU |
| pxSavedContextAfterInteractionElapsed | pxSavedCxtAfterIntElapsed |
To improve access, the PegaRULES database indexes are defined for the pr_perf_stats table. You can access this table using the pxUserIdentifier, pxSnapshotTime, pxRequestorType, pxSnapShotType, or pxSystemNodeID property values.
Reporting with the System Management Application
Use the System Management application to report on aggregate system usage based on Log-Usage data, as follows:
> System > Operations > System Management App. You may be prompted for authentication credentials.Trimming the pr_perf_stats table
In a production setting, the pr_perf_stats table can grow to contain millions of rows. By default, the system automatically purges records older than 30 days. If you do not need older rows for performance analysis, debugging, or other reporting, you can purge them by date (known as trimming) without affecting other system capabilities.
Once each day, the Pega-RULES agent starts a stored procedure that purges older rows of this table, passing the value of the pxProcess property as the number of days to retain. To set a retention period longer or shorter than the 30 days, add or revise the following element to your prconfig.xml file and restart the system:
<env name="usage/retentionperiod " value="nnn" />
where nnn is the number of days to retain.
As an alternative to the prconfig.xml file, you can use Dynamic System Settings to configure your application.
See How to create or update a prconfig setting.
Optionally, you can disable this facility through the Dynamic System Settings data instance Pega-RULES.
usage/usagetrackingenabled.
In releases before V5.2, instances of the Log-Usage class were stored in the pr4_log_usage table. The pr4_log_usage database table is not used in Version 5.2 or later. A separate table, pr4_log_rule_usage, supports the Log-RuleUsage class.
SysAdmin category
