Skip to main content
LinkedIn
Copied!

Table of Contents

Viewing database trace results in Excel

Version:

Only available versions of this content are shown in the dropdown

The Database Trace tool produces a text file containing the SQL statements, rule cache hit statistics, timings, and other data that reflect your requestor session's interactions with the Pega Platform database or other relational databases. You can export this file to Microsoft Excel to view the results.

Run the database tracer. For more information, see Starting a database trace.
  1. Click the Click to Stop icon (red square) to end tracing and close the text file.

  2. Click the Download this file icon to save the text file on your workstation or a shared drive.

  3. Open a new Excel worksheet.

  4. Within Excel, click File Open . Ensure that the file type is set to "Text Files" and then navigate to the saved text file. Excel automatically determines that the file is delimited; respond to prompts by selecting the "tab" delimiter type and desired column format. Results from the text file are formatted and imported to the worksheet.

Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community 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
Contact us