Skip to main content

The Database Trace

The Database Trace produces a text file containing the SQL statements, rule cache hit statistics, timings, and other data that reflect the interactions of your requestor session with the Pega Platform™ database or other relational databases. A basic familiarity of SQL Operations, (for example read, write, and insert), and BLOB is useful to interpret the output.

The Database Trace is available on the Performance landing page in Dev Studio (Configure > System > Performance > Database Trace) or from the Performance tool in the toolbar.

In the center of the following image, slide the vertical line to compare the Performance landing page and the Performance tool in the toolbar:

Operating the Database Trace tool can adversely affect performance by producing a large volume output. Use the tool for short periods, in non-production environments appropriate for debugging.

Check your knowledge with the following interaction:

Configure the Trace settings

Click Trace Options to open the settings window. The settings window lists all possible events to trace. If an event is inapplicable to a situation, remove it from the list to streamline the results. You also have the option to generate a stack trace. Generating the stack trace is an expensive process and should only be used when required.

Database Trace options

Generate Trace

In the following image, click the + icons to learn more about generating a database trace from the Performance landing page:

Note: For more information on how to start a database trace, see Performing a database trace.

Download data and interpret readings

If database operations, such as queries or commits, take a long time to process, the DB Trace can help determine the source of the performance issue. For example, if you have a query that is taking a long time to process, you can review the Database Trace details in a spreadsheet to investigate the operations that took the most time. 

Downloaded data contains a sequential progression of trace events. In the following image, click the + icons to learn more about some of the important fields in the trace. Some spreadsheet columns are hidden in order to showcase the most useful fields:

Note: For more information on how to view database trace results, see Viewing database trace results in Excel.

Check your knowledge with the following interaction:

This Topic is available in the following Module:

If you are having problems with your training, please review the Pega Academy Support FAQs.

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 Academy has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice