New Schema Tools and Query Inspector landing pages for Pega Cloud
Valid from Pega Version 7.2
Two landing pages have been added for advanced database administration tasks for Pega Cloud customers who use a Pega-hosted instance. These landing pages minimize the operations that need to be performed outside of the Pega 7 Platform. They are available only for customers who use a Postgres database.
From the new Schema Tools landing page, you can view 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.
From the new Query Inspector landing page, you can enter an SQL query and generate an explain plan.
To use these landing pages, you must have the new PegaRULES:DatabaseAdministrator role. You access the landing pages by clicking or by clicking . The individual features that you can access are determined by the privileges that are assigned to you.
For more information, see Schema Tools and Query Inspector landing pages for tuning and maintaining databases in the Pega Cloud.