LinkedIn
Copied!

Table of Contents

Viewing general database information

Version:

Only available versions of this content are shown in the dropdown

Access the System Database landing page by clicking Configure System Database . 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?

Have a question? Get answers now.

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