Transaction Log

Transaction logging provides a list of all transactional queries run by users in the analytics tools against data sources. The transaction logs do NOT include any queries run against the repository.

Transaction logging is enabled by default. To change the log settings, go to Logs > Log Settings.

Benchmark Log

If enabled, the transaction log viewer will also show a deeper analysis of query performance known as the Benchmark Log.

Note: The Benchmark is disabled by default. To enable this feature, go to Logs > Log Settings.

Warning: Benchmark logging can significantly slow the performance of the platform. It should be turned on for diagnostics only and then turned off.

Transaction Log Details

The transaction log page is broken into 2 panels.

Top Panel

Filter by Last

Include only those events that were logged within a selected time period (red box, above)

  • Select a to include events logged between now and that selected time (between 1 minute and 12 months ago).
  • Select All to include events logged at any time.
  • Select Custom to include events within a custom period. Start and End Date fields let you supply the details of your custom time period.

Start Time Filter

The Start Time Filter (blue box above) allows users to show rows equal to, before, after, or between selected date and time values

Clear Logs

Selecting the clear logs button (green box above) will 'purge' (permanently delete) all of the logs of this type.remove the logs from the displayed transaction logs.

Export

Selecting the export button will download a CSV file detailing all the logs displayed.

Displayed Columns

The panel displays high level stats on the transaction and query.

  • Start Time: the start time of the query.
  • Post Query: the time Pyramid spent processing the query result in milliseconds.
  • Engine: the total time needed to submit the query and process it before returning it to the client (Connection + Query + Post) in milliseconds.
  • Query: the time it took for the data source to execute and return the query in milliseconds.
  • Average Connection: the time it took to establish a connection in milliseconds.
  • Result size: the number of cells (rows x columns) in the query result.
  • Number of Queries: the total number of queries run.

Additional columns display details of the query

  • Model Name
  • Database Name
  • Server Name
  • Database Type
  • User Name
  • Maximum Connection
  • Minimum Connection
  • Security
  • Request ID
  • Runtime Engine
  • Windows Connector
  • Client

Column View

The Column View (yellow box above) enables users to select the required columns to be displayed

Sort and Filter

Most column headers include options to sort and filter the results:

  • Hover over a column header to sort the results by ascending or descending order.
  • Hover over a column heading to open the filter options. Filtering allows you to limit the results shown in the column by value. Click the filter icon associated with your column, specify the details of your filter, and click apply. Which details you see depends on the data type of the value in the selected column:
  • If the column contains a date / time; you can select from the options:
    • Equals - Return logs with the selected date and time.
    • Before - Return logs up to the selected date and time.
    • After - Return logs after the selected date and time.
    • Between - Return logs within a particular date and time window. In this case, you need to specify the start and end date for your filter.
  • If the column contains a number you can select from the options: Equals, Not Equals, Greater than, Greater than or Equals, Less than, Less than or equals, and specify a comparison value.
  • If the column contains a string you can select from the options: Equals, Does Not Equal, Start with, End with, Contain, Does not contain, and specify a comparison value.

Pagination

Where multiple pages of logs are returned by the query, users can go to a specific page, or move to the next or previous page using the pagination functions at the bottom of the screen.

Bottom Panel

The bottom panel is broken into 2 sections: basic transactional details and the more advanced benchmark details. Double-click a row in the top panel to open the message associated with that logged event in the bottom panel.

Transaction Data

The transaction panel displays more details for the selected transaction log in 3 sections.

  • Detailed information in a portrait landscape (red box)
  • The raw SQL or MDX query run against the data source (green box)
  • A breakdown of how each component of the query performed (blue box).
Previous and Next Log

Users can traverse to view the details of the previous or next log by clicking on the previous and next buttons (yellow box)

Benchmark

The benchmark logs are an extension of the transaction logs - providing deeper analysis of the query transactions for optimization purposes. The panel shows specifics for any selected transaction, showing each stage in the query pipeline. This will not be available if benchmark logging is disabled.

  • The graphic on the left is used to summarize the times and give a bird's eye view of the pipeline. It is very useful in diagnosing performance issues and separating out Pyramid processing from database processing from network latency.
    • Pyramid Time represents the time allotted to Pyramid processing on the server (pre and post) and the Pyramid web client
    • Network represents the time taken to send and receive data across the network between the client and server
    • Query Time represents the time taken to connect to a data source, submit the request, for the data source to process the request and return a response to Pyramid.
    • The rows and columns provide metrics on the size of the result.
  • The grid on the right highlights each stage and the time taken to resolve each element in the pipeline from client to server, to database and back to client.
    It is beyond the scope of this help article to explain each item. These details are for Pyramid engineers when trying to diagnose performance issues for a customer.

If benchmark logging is enabled, the benchmark summary graphic is also available from the "App Tab" in the full client interface.