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. The time is shown in the time zone configured in the Console.
  • Time Range — Time interval for which the query is searching records. The time is shown in the time zone configured in the Console.
  • 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 can scroll through the list of the aggregated query results, or you can filter the results by clicking the Latencies, Application, User, and Infrastructure buttons. As shown in the following example, clicking the User button displays only the user metrics.

pae_improvements-4crop.png

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. For information about the metrics and attributes displayed in the aggregated query results, see Performance-metrics.

 

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