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.
Remaining transactions and multixact idenfiers for each database 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 |
|---|---|---|
| AutovacuumFreezeMaxAge | int | Value of the parameter autovacuum_freeze_max_age at collection time. |
| AutovacuumMultixactFreezeMaxAge | int | Value of the parameter autovacuum_multixact_freeze_max_age at collection time. |
| _BilledSize | real | The record size in bytes |
| ConnectionsLimit | int | Maximum number of concurrent connections that can be made to this database, -1 means no limit. |
| Database | string | Name of the database. |
| _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. |
| MinMultixactId | long | All multixact identifier before this one have been replaced with a transaction identifier in this database. |
| MinMultixactIdAge | long | Age in transactions of multixact identifier in this database. |
| Node | string | Logical name of the node. |
| Pool | string | Name of the pool containing the node. |
| RemainingMultixactIds | long | Remaining multixact identifiers in this database. |
| RemainingMultixactIdsTillEmergencyAV | long | Remaining multixact identifiers in this database until emergency autovacuum is triggered. |
| RemainingMultixactIdsTillWraparound | long | Remaining multixact identifiers in this database until wraparound protection is triggered. |
| RemainingTransactionIds | long | Remaining transaction identifiers in this database. |
| RemainingTransactionIdsTillEmergencyAV | long | Remaining transaction identifiers in this database until emergency autovacuum is triggered. |
| RemainingTransactionIdsTillWraparound | long | Remaining transaction identifiers in this database until wraparound protection is triggered. |
| _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 |
| _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. |
| TransactionIdFrozen | long | All transaction identifiers before this one has been replaced with a permanent ('frozen') transaction identifier in this database. |
| TransactionIdFrozenAge | long | Age in transactions of TransactionIdFrozen in this database. |
| Type | string | The name of the table |
| UserId | int | Identifier (OID) of the user that executed the statement. |
| VacuumFreezeMinAge | int | Value of the parameter vacuum_freeze_min_age at collection time. |
| VacuumMultixactFreezeMinAge | int | Value of the parameter vacuum_multixact_freeze_min_age at collection time. |