Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Viewing general database information

Updated on July 8, 2022

Access the System Database landing page by clicking ConfigureSystemDatabase. The following tabs are available:

  • Schema Change Tracking – View consolidated information about changes to database schema on this system.
  • Optimize Schema – View possible database optimizations that could improve system performance, database size, or other resource use. You must have the ViewAndOptimizeSchema privilege to view this page.
  • Modify Schema – View and manually modify the database schema by using the Modify Schema Wizard.
  • Schema Tools – Perform advanced database tuning and maintenance for Pega Cloud applications running on Postgres.
  • Query Inspector – Generate explain plans for Pega Cloud applications running on Postgres.
  • Query Runner – Test SELECT statements for Pega Cloud applications running on Postgres.
  • Column Population Jobs – Cancel and view the status of property optimization jobs running in the background. These jobs are created by the Property Optimizer tool, which populates newly exposed database table columns with data values from the BLOB column. You must have the SchemaPropertyOptimization privilege to access this page.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us