HorizonDBServerLogs

PostgreSQL server logs 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
BackendType string Type of current backend. Available for PostgreSQL 14 and later.
_BilledSize real The record size in bytes
Column string Name of the column (if applicable).
Constraint string Name of the constraint (if applicable).
Context string Error context (if applicable).
Datatype string Name of the datatype (if applicable).
Detail string Detail log message (if applicable).
DetailLog string Extended detail log message (if applicable).
ErrorLevel string Logging level, example: LOG, ERROR, NOTICE.
Hint string Message hint (if applicable).
_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.
Message string Primary log message.
Node string Logical name of the node.
Pool string Name of the pool containing the node.
ProcessId int Process identifier (PID) of the backend that generates the event.
Query string Internal query that led to the error (if applicable).
_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.
Schema string Name of the schema (if applicable).
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
SqlErrorCode string PostgreSQL Error code that follows the SQL standard's conventions for SQLSTATE codes.
Statement string Query string (if applicable).
_SubscriptionId string A unique identifier for the subscription that the record is associated with
Table string Name of the table (if applicable).
TenantId string The Log Analytics workspace ID
TimeGenerated datetime Timestamp (UTC) of when the event is generated.
Type string The name of the table