queryinsights.exec_requests_history (Transact-SQL)

Applies to: SQL analytics endpoint and Warehouse in Microsoft Fabric

The queryinsights.exec_requests_history in Microsoft Fabric provides information about each completed SQL request.

Column name Data type Description
distributed_statement_id uniqueidentifier Unique ID for each query.
start_time datetime2 Time when the query started running.
command varchar(8000) Complete text of the executed query.
login_name varchar(128) Name of the user or system that sent the query.
row_count bigint Number of rows retrieved by the query.
total_elapsed_time_ms int Total time (ms) taken by the query to finish.
status varchar(30) Query status: Succeeded, Failed, or Cancelled
session_id smallint ID linking the query to a specific user session.
connection_id uniqueidentifier Identification number for the query's connection. Nullable.
batch_id uniqueidentifier ID for grouped queries (if applicable). Nullable.
root_batch_id uniqueidentifier ID for the main group of queries (if nested). Nullable.
query_hash varchar(200) Binary hash value calculated on the query and used to identify queries with similar logic. You can use the query hash to correlate between Query Insight views. For more information, see Query Insights - Aggregation.
label varchar(8000) Optional label string associated with some SELECT query statements.

Permissions

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

Next step