Skip to main content


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

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Schema Tools and Query Inspector landing pages for tuning and maintaining databases in the Pega Cloud

Updated on September 10, 2021

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 Designer Studio > System > Database > Schema Tools.

Schema Tools table information

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

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

Change database column length

You can add an index to a table to facilitate search by expanding the index node and clicking Add index.

Schema Tools add index to table

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 Designer Studio > System > Database > Query Inspector. Enter the SQL statement, and click Generate explain plan.

Explain plan displayed in the Query Inspector

Output created by clicking Generate explain plan

For more information, see Query Inspector.

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