Format of query results


When you run a query, the Performance Analysis page displays the following information:

  • Query Summary section with the main information about the query and its progress
  • Results of the query aggregated according to various metrics

Tip

While a query is in progress, you can click Display Sample Data on the shortcut menu. A secondary browser window or tab displays sample data in HTML format, as shown in the following figure, giving you an idea of the results.

Sample query data

ss_sample_Data_table.png

Query summary

The following figure shows an example of the Query Summary section for a query in progress:

Query in progress

ss_query_summary_in_progress.png

The Query Summary section provides the following information:

  • Filter used to run a query, consisting of the record type, the sector of the monitored traffic (Watchpoint name), and the time range
    Example: [Page] query on [all traffic] over [Last 7 days]
  • In Progress — Percentage of data that the system has searched, compared to the total amount of data
  • Pages Scanned — Number of pages or objects that the system has scanned
  • Pages Found — Number of detected pages or objects that meet the query criteria
  • Sessions — Number of user sessions that contain the detected pages or objects
  • Progress bar — Amount of data that the system has searched, compared to the total quantity of found records (corresponds to the In progress percentage)

As shown in the following figure, you can view additional information about the query by clicking the Details button. Click Details again to hide the details.

Query Summary section with details

ss_query_summary_details.png

This section shows the following details about the query:

  • Issued on — Date and time of query creation
  • Time Range — Time interval for which the query is searching records
  • Watchpoint — Name of the traffic segment that the query scans (if applicable)
  • Filter — Filter expression used to search through the data (if applicable)

Aggregated results

You use query parameters to narrow down the number of detected sessions. Excluding the latency metrics, parameters display only the most frequent values. All the remaining values are aggregated into others. The following sections contain the aggregated results for the query:

Application aggregation

The following figure is a sample of the Application pane:

Application pane

ss_query_aggregated_results_1.png

The Application pane displays the following information about the application parameters:

User aggregation

The following figure is a sample of the User pane:

User pane

ss_query_aggregated_results_2.png

The User pane displays the following information about the user parameters:

Infrastructure aggregation

The following figure is an example of the Infrastructure pane:

Infrastructure pane

ss_query_aggregated_results_3.png

The Infrastructure pane displays the following information about the infrastructure parameters:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*