Microsoft.DBforPostgreSQL/flexibleServers
8 diagnostic categories routing into 4 Log Analytics tables.
Source: Microsoft Learn
Diagnostic categories
-
PostgreSQLFlexDatabaseXacts
PostgreSQL remaining transactions
Cost to export- Routes to
- AzureDiagnostics
-
PostgreSQLFlexPGBouncer
PostgreSQL PgBouncer Logs
Cost to export- Routes to
- AzureDiagnostics
- Per-category table
- PGSQLPgBouncer
-
PostgreSQLFlexQueryStoreRuntime
PostgreSQL Query Store Runtime
Cost to export- Routes to
- AzureDiagnostics
- Per-category table
- PGSQLQueryStoreRuntime
-
PostgreSQLFlexQueryStoreWaitStats
PostgreSQL Query Store Wait Statistics
Cost to export- Routes to
- AzureDiagnostics
-
PostgreSQLFlexSessions
PostgreSQL Sessions data
Cost to export- Routes to
- AzureDiagnostics
-
PostgreSQLFlexTableStats
PostgreSQL Autovacuum and schema statistics
Cost to export- Routes to
- AzureDiagnostics
-
PostgreSQLLogs
PostgreSQL Server Logs
- Routes to
- AzureDiagnostics
-
PostgreSQLQueryStoreSqlText
PostgreSQL Query Store SQL Text
Cost to export- Routes to
- AzureDiagnostics
- Per-category table
- PGSQLQueryStoreQueryText
Destination tables
-
AzureDiagnostics
PIIStores resource logs for Azure services that use Azure Diagnostics mode. Resource logs describe the internal operation of Azure resources.
174 columns in this table.
-
PGSQLPgBouncer
PgBouncer logs of an Azure Database for PostgreSQL Flexible Server.
11 columns in this table.
-
PGSQLQueryStoreQueryText
The query text captured by Query Store in Azure Database for PostgreSQL Flexible Server.
13 columns in this table.
-
PGSQLQueryStoreRuntime
Query Store runtime statistics related to query execution information of an Azure Database for PostgreSQL Flexible Server.
42 columns in this table.