HorizonDBTransactionsStats

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.