queryinsights.long_running_queries (Transact-SQL)

Applies to: SQL analytics endpoint and Warehouse in Microsoft Fabric

The queryinsights.long_running_queries in Microsoft Fabric provides information about SQL query execution times.

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.
median_total_elapsed_time_ms	int	Median query execution time (ms) across runs.
number_of_runs	int	Total number of times the query was executed.
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.

Permissions

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