The Database Tracer gadget 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.
-
Click the red square to end tracing and close the text file.
-
Click the download icon to save the text file on your workstation or a shared
drive.
-
Open a new Excel worksheet.
-
Within Excel, click
. 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.