Skip to main content


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

Viewing column BLOB size

Updated on August 25, 2021

You can view the size of columns that use a binary large object (BLOB) on your internal PegaRULES and PegaDATA databases on Pega Cloud using Schema Tools.

Before you begin: You need the PegaRULES:DatabaseAdministrator role to access Schema Tools. For more information, see Harnesses form - Completing the Design tab.Note: Pega Platform uses Query Runner, Query Inspector, and Schema Tools for Pega Cloud clients to interface with their database. These database tools are not available for on-premises clients.

This operation might be time consuming and should not be performed during peak production hours. The operation continues in the background if you leave the Schema Tools landing page. The retrieved values are displayed the next time you view the column details.

  1. In the header of Dev Studio, click ConfigureSystemDatabaseSchema Tools.
  2. Expand the database schema tree and select the column you want to view.
  3. Click Get BLOB sizes to get initial sizing of BLOB columns.
  4. Click Refresh BLOB sizes to refresh sizing of BLOB columns after initial sizing.
What to do next:

Related articles

Adding and deleting database indexesDefragmenting tablesUpdating statisticsViewing the history of Schema Tools actionsViewing database schema using Schema ToolsViewing general database information

Tags

Pega Platform 8.5 System Administration

Have a question? Get answers now.

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

Visit the Support Center

Did you find this content helpful?

Yes
No

Want to help us improve this content?
Suggest an edit

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