Supported logs for Microsoft.DBforPostgreSQL/flexibleServers
The following table lists the types of logs available for the Microsoft.DBforPostgreSQL/flexibleServers resource type.
For a list of supported metrics, see Supported metrics - Microsoft.DBforPostgreSQL/flexibleServers
| Category | Category display name | Log table | Supports basic log plan | Supports ingestion-time transformation | Example queries | Costs to export |
|---|---|---|---|---|---|---|
PostgreSQLFlexDatabaseXacts |
PostgreSQL remaining transactions | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | Yes |
PostgreSQLFlexQueryStoreRuntime |
PostgreSQL Query Store Runtime | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | Yes |
PostgreSQLFlexQueryStoreWaitStats |
PostgreSQL Query Store Wait Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | Yes |
PostgreSQLFlexSessions |
PostgreSQL Sessions data | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | Yes |
PostgreSQLFlexTableStats |
PostgreSQL Autovacuum and schema statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | Yes |
PostgreSQLLogs |
PostgreSQL Server Logs | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Next Steps
- Learn more about resource logs
- Stream resource logs to Event Hubs
- Change resource log diagnostic settings using the Azure Monitor REST API
- Analyze logs from Azure storage with Log Analytics
- Optimize log queries in Azure Monitor
- Aggregate data in a Log Analytics workspace by using summary rules (Preview)