Skip to main content

Viewing general database information

Suggest edit
Updated on August 25, 2021

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.
Did you find this content helpful? YesNo

Have a question? Get answers now.

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

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