Schema Tools and Query Inspector landing pages for tuning and maintaining databases in the Pega Cloud
Two landing pages have been added to the System Database landing page in the Pega Platform™ to facilitate advanced database administration tasks for Pega Cloud 2.1 customers. While uou cannot perform these tuning, maintenance, query, insert, and indexing tasks directly on your Pega VPC database, Schema Tools provide the same functionality as accessing your database directly from your an on-premises server.
Schema Tools are also available to on-premises customers who use a Postgres database. For more information, see
To access and use these landing pages, you must have the new PegaRULES:DatabaseAdministrator role assigned to your profile. The individual features that you can access are determined by the privileges that are assigned to you.
Schema Tools landing page
From the Schema Tools landing page, you can view the PegaRULES and PegaDATA database schemas, increase the size of a column, add a composite or function index, update database statistics for a table, and defragment a table. Drill down into PegaRULES or PegaDATA to view the tables, columns, indexes, and views in either schema.
Access the Schema Tools landing page by clicking .
Schema Tools table information
The length of any text field can be increased if the length of the data stored in the field increases.
Schema Tools column length
You can select the column to view the current length and click Edit to change the length.
Change database column length
You can add an index to a table to facilitate search by expanding the index node and clicking Add index.
Add index to table
For more information, see Schema Tools.
Query Inspector landing page
From the Query Inspector landing page, you can tune your SQL queries to make them run more efficiently. You can enter an SQL query and generate an explain plan that details how the query is executed to help tune the query. Access the Query Inspector by clicking . Enter the SQL statement, and click Generate explain plan.
Output created by clicking Generate explain plan
For more information, see Query Inspector.