queryinsights.frequently_run_queries (Transact-SQL)

Applies to: SQL analytics endpoint and Warehouse in Microsoft Fabric

The queryinsights.frequently_run_queries in Microsoft Fabric provides information about frequently run queries in Fabric Data Warehousing.

Column name	Data type	Description
last_run_start_time	datetime2	Time of the most recent query execution.
last_run_command	varchar(8000)	Text of the last query execution.
number_of_runs	int	Total number of times the query was executed.
avg_total_elapsed_time_ms	int	Average query execution time (ms) across all runs.
last_run_total_elapsed_time_ms	int	Time taken by the last execution (ms).
last_dist_statement_id	uniqueidentifier	ID linking the query to `queryinsights.exec_requests_history`.
last_run_session_id	smallint	User session ID for the last execution.
min_run_total_elapsed_time_ms	int	Shortest query execution time (ms).
max_run_total_elapsed_time_ms	int	Longest query execution time (ms).
number_of_successful_runs	int	Number of successful query executions.
number_of_failed_runs	int	Number of failed query executions.
number_of_cancelled_runs	int	Number of canceled query executions.

Permissions

You should have access to a SQL analytics endpoint or Warehouse within a Premium capacity workspace with Contributor or above permissions.