Skip to main content

Using the Queries Page

The Queries page displays queries that have run on your deployed models, including those run by users accessing models from BI tools, and those run by the system (for example, when building aggregates). To access the Queries page, open the main navigation in Design Center and click Queries.

The Queries page.

The table displays all queries that have run recently on the catalogs and models that you have permission to view. It also displays high-level details about each query, including:

  • Its status (Successful, Failed, and so on).
  • The name of the model and catalog it ran on.
  • Its start time and duration.
  • The user who initiated the query.
  • Any optimizations defined for the query.
  • The specific model attributes and metrics the query ran on.

Canceling queries​

You can cancel a running query by hovering over it in the list and clicking the Cancel button that appears.

Filtering queries​

You can filter the queries displayed in the list using the fields above the table. For example, you can filter by queries run in a specific timeframe, or run by a particular user.

Viewing query details​

You can click on a query in the table to open the query details panel, which displays additional information about it.

The query details panel.

The panel shows a full breakdown of the specific optimizations configured for the query, as well as the attributes and metrics it ran on. It also displays a detailed timeline of the query run.

For queries that resulted in aggregates, the query details panel contains a Show Aggregates link:

The query details panel, with the Show Aggregates link highlighted.

You can click the link to open the Aggregates panel at the bottom of the page, which displays details about the aggregate definitions and instances, much like the Aggregates page.

The Aggregates panel.

You can also click on the inbound and outbound phases in the timeline to view the full SQL for that phase. For outbound queries, you can toggle between the SQL and Aggregate Analysis tabs:

The query details panel, with an outbound query selected and the SQL and Aggregate Analysis tabs highlighted.

  • The SQL tab displays the full SQL for that phase. You can also click the Show query plan icon to view the phase's full query plan.
  • The Aggregate Analysis tab displays the candidate aggregates approved for the query, as well as generation and rejection reports. This information can help you determine why your query did or did not result in an aggregate.
Note

You can enable/disable aggregate analysis reports using the aggregates.prediction.reports.storePredictorData global setting. For more information, see Aggregate Settings.

Configuring the query display​

The Queries page may become unresponsive when large queries are returned. To prevent this, you can use the following global settings to limit the number of characters displayed for inbound and outbound queries:

  • QUERY.CHARACTERLIMIT.DISPLAYINBOUND (100,000 by default)
  • QUERY.CHARACTERLIMIT.DISPLAYOUTBOUND (50,000 by default)

If a query exceeds one of these limits, a truncated version of the query appears in the details panel. The full query can be displayed in a separate tab if needed.