Analyzing queries

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

From the semantic model view, you can view a historical query analysis to aid you in optimizing your semantic model design. The results are displayed in a different browser tab.

The Cumulative Query Analysis dashboard shows performance statistics, user data, performance trends, response time trends, and mostly used dimensions and measures. You can drill down for more details on a specific query from the list of top slow-running queries, which is displayed in a separate dashboard tab. All of this data helps you tune the semantic model performance. You can right-click the different cards in these dashboards to view additional details or drill up or down.

Cumulative Query Analysis dashboard

To analyze queries created using a semantic model, perform the following steps.

From the Toolbox, click Semantic Models.
Select a semantic model from the list.
Click the Actions menu (...) above the Properties pane, and then click Analyze Queries.
The results are displayed in a separate browser tab.

The Cumulative Query Analysis dashboard

Total query count, Average response time, Minimum response time, Maximum response time, Total users, Tracking queries by users, Response time range, Query usage and response time trend, Dimensions used in visualizations and filters, Dimensions used as root, Measures used in visualization and filters, Not used in dimensions and filters, Slowest running queries, and query strings. You can click any slow query to see the query string used.

To analyze a single query, perform the following steps:

From the Toolbox, click Semantic Models.
Select a semantic model from the list.
Click the Actions menu (...) and click Analyze Queries.
The results are displayed in the Cumulative Query Analysis dashboard and shown in a separate browser tab.
Scroll down if needed, then right-click a query in the Slowest running queries card and choose Actions, then Analyze Query to see additional details in a separate browser tab.
Scroll down if needed to view the Single Query Analysis dashboard.

Cumulative Query Analysis dashboard detail showing option to view details of a single query

The Single Query Analysis dashboard

Query details, query string, fields used, query identifier, query source, query language, query engine, status, semantic model name, user name, subquery count, compressed and uncompressed response size in bytes, response time, subquery execution time, query engine execution time, per query statistics, query engine state while executing a query, and time brake up.

To view additional details, right-click an item and click Show Data > Detailed View or Detailed View with all columns. The information displays in a separate browser tab.
From the Activity Monitor, you can also view details of a particular query in the Live Query Analysis dashboard. See Running and completed processes.

Query analysis configurable settings

If you are the Kyvos administrator, you can fine-tune the query analysis dashboard options by setting the following system-level properties in systemconfig.json:

"queryinfo_time_threshold" : "5" The Query Engine-related analysis shows queries that took more than five seconds to execute.
"queryinfo_subquery_limit" : "10" By default, 10 Top slow-running query details are available for analysis.

Configure database name

In an Azure-based deployment, you can provide a mechanism to configure the database name for tables used in the semantic model Query Analyzer feature. It appends "CLUSTER_NAME" to the default DB name in an Azure-based deployment.

"CLUSTER_NAME" is defined in the olapengine.prop file and it's unique for each Kyvos deployment.

Related topic

Running and completed processes