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 7 Platform to facilitate advanced database administration tasks for Pega Cloud 2.1 customers. These tuning and maintenance tasks were previously performed outside of the Pega 7 Platform. The landing pages are also available to on-premises customers who use a Postgres database.
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 Generate explain plan.. Enter the SQL statement, and click
Output created by clicking Generate explain plan
For more information, see Query Inspector.