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.
Session's data collected from PostgreSQL pg_stat_activity system view of an Azure HorizonDB replica. Contains one row per connection referred here as a backend and the data is collected at an interval of 5-minutes.
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 |
|---|---|---|
| Application | string | Name of the application that is connected to the backend that generates the event. |
| BackendStartTime | datetime | Time when the backend that generates the event starts. For client backends, this is the time the client connected to the replica. |
| BackendType | string | Type of backend that generates the event. |
| _BilledSize | real | The record size in bytes |
| ClientIp | string | IP address of the client connected to the backend that generates the event. If this field is empty, it indicates that the client is connected via a Unix socket on the server compute or that it corresponds to an internal process such as autovacuum. The last octet of the IP is obfuscated. |
| CollectionTime | datetime | The collection time indicating the time when the information was collected. |
| Database | string | Name of the database the backend that generfates the event is connected to. |
| DatabaseId | int | Identifier (OID) of the database the backend that generates the event is connected to. |
| _IsBillable | string | Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account |
| Location | string | Location of Azure HorizonDB replica. |
| Node | string | Logical name of the node. |
| OldestTransactionId | long | Oldest transaction identifier that the backend that generates this event is able to see. |
| Pool | string | Name of the pool containing the node. |
| ProcessId | int | Process ID (PID) of this backend. |
| QueryStartTime | datetime | Time when the active query starts. If state is not active, this represents the time when last executed query started. |
| _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. |
| 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 |
| State | string | State, at collection time, of the backend that generates the event. |
| StateChangeTime | datetime | Time when the state was last changed. |
| _SubscriptionId | string | A unique identifier for the subscription that the record is associated with |
| TenantId | string | The Log Analytics workspace ID |
| TimeGenerated | datetime | Timestamp (UTC) of when the event is generated. |
| TransactionId | long | Top-level transaction identifier of this backend, if any. |
| TransactionStartTime | datetime | Time when the backend that generates the event starts current transaction. If there's no active transaction, this is set to an empy value. |
| Type | string | The name of the table |
| UserId | int | Identifier (OID) of the user that executed the statement. |
| WaitEvent | string | Name of event for which the backend is waiting. If it isn't waiting, this is set to an empty string. |
| WaitEventType | string | Type of event for which the backend is waiting. If it isn't waiting, this is set to an empty string. |