Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Query store runtime statistics related to query execution information of an Azure HorizonDB replica.
Table attributes
| Attribute | Value |
|---|---|
| Resource types | microsoft.horizondb/clusters |
| Categories | Audit, Azure Resources |
| Solutions | LogManagement |
| Basic table support | Yes |
| Auxiliary / Lake table support | Yes |
| DCR workspace transformation support | No |
| Ingestion API support | No |
| Sample Queries | Yes |
Columns
| Column | Type | Description |
|---|---|---|
| _BilledSize | real | The record size in bytes |
| BlkReadTime | real | Total time the statement spent reading blocks in milliseconds for all calls in this time window. Only available if track_io_timing is enabled, otherwise zero. |
| BlkWriteTime | real | Total time the statement spent writing blocks in milliseconds for all calls in this time window. Only available if track_io_timing is enabled, otherwise zero. |
| Calls | long | Number of times the query executed within this time window. |
| DatabaseId | int | Identifier (OID) of database in which the statement was executed. 0 indicates it is a background worker or a system call. |
| EndTime | datetime | End time corresponding to the time window for this entry. Statistics for queries are aggregated by time window. |
| _IsBillable | string | Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account |
| IsSystemQuery | bool | Boolean value indicating if the query is executed by Azure managed system user. |
| LocalBlksDirtied | long | Total number of local blocks dirtied by the statement for all calls in this time window. |
| LocalBlksHit | long | Total number of local block cache hits by the statement for all calls in this time window. |
| LocalBlksRead | long | Total number of local blocks read by the statement for all calls in this time window. |
| LocalBlksWritten | long | Total number of local blocks written by the statement for all calls in this time window. |
| Location | string | Location of Azure HorizonDB replica. |
| MaxExecDurationMs | real | Maximum query execution duration in milliseconds in this time window. |
| MeanExecDurationMs | real | Mean query execution duration in milliseconds in this time window. |
| MinExecDurationMs | real | Minimum query execution duration in milliseconds in this time window. |
| Node | string | Logical name of the node. |
| ParametersCaptureStatus | string | Indicates the status of capturing parameters of a parameterized query. |
| PlanId | long | Identifier of the plan corresponding to this query. Only available when query store is configured to store query plans, otherwise the field is empty. |
| Pool | string | Name of the pool containing the node. |
| QueryId | string | Identifier of the query. An internal hash code, computed from the statement's parse tree. |
| QueryType | string | Indicates the query type of the statement. Possible values: unknown, select, update, insert, delete, merge, utility, nothing. |
| _ResourceId | string | A unique identifier for the resource that the record is associated with |
| Role | string | Role of the replica. Possible values are Unknown, ReadWrite, and ReadOnly. |
| Rows | long | Total number of rows retrieved or affected by the statement for all calls in this time window. |
| RuntimeStatsEntryId | long | Identifier of the runtime entry. |
| SearchPath | string | Value of search_path set at the time the query was captured. |
| SearchPathCaptureStatus | string | Indicates the status of capturing the search_path. |
| SharedBlksDirtied | long | Total number of shared blocks dirtied by the statement for all calls in this time window. |
| SharedBlksHit | long | Total number of shared block cache hits by the statement for all calls in this time window. |
| SharedBlksRead | long | Total number of shared blocks read by the statement for all calls in this time window. |
| SharedBlksWritten | long | Total number of shared blocks written by the statement for all calls in this time window. |
| SourceSystem | string | The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics |
| StartTime | datetime | Start time corresponding to the time window for this entry. Statistics for queries are aggregated by time window. |
| StdDevExecDurationMs | real | Standard deviation of the query execution duration time in milliseconds in this time window. |
| _SubscriptionId | string | A unique identifier for the subscription that the record is associated with |
| TempBlksRead | long | Total number of temporary file blocks read by the statement for all calls in this time window. |
| TempBlksWritten | long | Total number of temporary file blocks written by the statement for all calls in this time window. |
| TenantId | string | The Log Analytics workspace ID |
| TimeGenerated | datetime | Timestamp (UTC) of when the event is generated. |
| TotalExecDurationMs | real | Total query execution duration in milliseconds for all calls in this time window. |
| Type | string | The name of the table |
| UserId | int | Identifier (OID) of the user that executed the statement. |