See if systemcleaner agent is running properly. you can truncate data of these tables

Kindly go through Pega Help here to understand these tables usages and about retention of data in perf table:

https://community1.pega.com/sites/pdn.pega.com/files/help_v719/procomhelpmain.htm#howto/howto2/logusagetable.htm

thank you. Yes, system cleaner agent is taking very long time. question is can i truncate table without impact?

You can truncate older data, say all data before a week or so

ok. so in worst scenario I can truncate all 4 table without having any impact to running app.

Hi,

The best option is to use the Purge Agents which will remove unnecessary data from the database. You can look at other options :

• Purge/Archive of old work objects:  https://pdn.pega.com/sites/pdn.pega.com/files/help_v72/procomhelpmain.htm#tools/purgearchive/aboutpurgearchivewizard.htm
• Review System Cleaner to see how big the table has grown:  https://pdn.pega.com/support-articles/system-cleaner-not-cleaning-perf-stats-table

General Database information can be found here:

• https://pdn.pega.com/performance-guidance-production-applications-database

In case of the emergency situation where the system is not responding you can

1. take a snapshot of the DB
2. run below queries

   #Rules Schema 
   
   TRUNCATE TABLE pegarules.pr_assembledclasses; 
   
   TRUNCATE TABLE pegarules.pr_sys_cache_entry; 
   
   TRUNCATE TABLE pegarules.pr_sys_cache_impl; 
   
   TRUNCATE TABLE pegarules.pr_sys_class_ancestors; 
   
   TRUNCATE TABLE pegarules.pr_sys_ruleset_index; 
   
   TRUNCATE TABLE pegarules.pr4_rule_sysgen; 
   
   TRUNCATE TABLE pegarules.pr_sys_app_hierarchy_flat; 
   
   TRUNCATE TABLE pegarules.pr_sys_app_ruleset_index; 
   
   TRUNCATE TABLE pegarules.pr_sys_rule_impl; 
   
   TRUNCATE TABLE pegarules.pr_sys_appcache_dep; 
   
   TRUNCATE TABLE pegarules.pr_sys_appcache_entry; 
   
   TRUNCATE TABLE pegarules.pr_sys_appcache_shortcut; 

   
   

   #Data Schema 
   
   TRUNCATE TABLE pegadata.pr_sys_statusnodes; 
   
   TRUNCATE TABLE pegadata.pr_sys_locks; 
   
   TRUNCATE TABLE pegadata.pr_sys_updatescache; 
   
   TRUNCATE TABLE pegadata.prpc_ignite_server_addr; 
   
   TRUNCATE TABLE pegadata.pr_sys_queue_ftsindexer; 

1. clear the cache on the application server and restart the docker.

Thanks,

Lukasz