30.3.5 Exporting Query Information

To get the text and details of the queries displayed on the Query Analyzer page, click one of the icons to the right of the Browse Queries label in the separator bar. The query information is exported as comma-separated data in a .csv file, with fields corresponding to the columns shown in the Monitor UI, and the time of the export encoded in the filename in UTC format. The icon representing a single page exports the query information for the currently displayed page only. The icon representing a stack of pages exports the query information for all available pages of query information.

Within the Query Analyzer pop-up, you can also export information about each data group as a .csv text file or a .png image file, using icons next to the labels on the left side. The output file is named according to the pattern Statement_Report_Summary_%server/group%_%creationtimestamp%.csv. The data exported by these icons includes:

  • Execution Time: Count

  • Executions: Exec Time, Max Exec Time, Min Exec Time, Average Exec Time

  • Rows: Rows, Max Rows, Min Rows, Average Rows

  • Kilobytes: Bytes, Max Bytes, Average Bytes


Microsoft Excel users on Windows users can import the .csv file as a spreadsheet. If the file contains English text, typically you can double-click it to open in Excel. If the file contains localized Japanese text, you must use the File > Open menu choice within Excel to open the file.

In the Safari browser, exported files containing localized data might contain %NN character sequences in their names, due to browser issues with UTF-8 and Base64 encodings.