Table of Contents

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 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.

Suggest Edit

88% found this useful

Have a question? Get answers now.

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