Observability and Monitoring Enhancements for Azure Database for PostgreSQL Flexible Server

 

Several observability and monitoring enhancements have recently been introduced for Azure Database for PostgreSQL Flexible Server, providing developers with powerful tools to optimize app query performance, troubleshoot issues, and integrate database monitoring data into their workflows. This comprehensive list includes:

• Enhanced Metrics (preview) - Azure Database for PostgreSQL Flexible Server now provides more than 40 enhanced metrics including performance, database saturation, replication etc., allowing users to monitor and diagnose issues with their databases. For details, refer Enhanced metrics for Azure Postgres Flexible Server
• Autovacuum monitoring metrics (preview) Added new metrics to monitor the autovacuum performance and identify and vacuuming issues in the database. For details, refer Monitoring Autovacuum in Azure PostgreSQL Flexible Server
• PgBouncer monitoring metrics (preview) Added new metrics to monitor connection pooling performance in Azure Database for PostgreSQL Flexible Server. In addition, customers can also login to PgBouncer admin console and run SHOW commands to get detailed statistics. For details, refer Monitoring PgBouncer in Azure PostgreSQL Flexible Server
• Query Performance Insight (preview) This feature provides a graphical representation of database performance metrics, making it easier to identify performance issues. For details, refer Query Performance Insight - Start monitoring in minutes
• Query Store (generally available) This feature provides insights into query performance and allows users to identify and troubleshoot performance issues. For details, refer Query Store Overview
• Log Analytics Integration (generally available) Users can now export logs to Azure Log Analytics, making it easier to analyze and troubleshoot issues across multiple databases. For details, refer Configure and Access Logs
• Azure Monitor workbooks (generally available) Azure Database for PostgreSQL Flexible Server now integrates with Azure Monitor workbooks, which allow users to create visual reports and analyze data within the Azure portal for enhanced metrics, autovaccum metrics etc. For details, refer Monitor workbooks for Azure Database for PostgreSQL Flexible Server
  
  

Overall, these enhancements make it easier for users to monitor and troubleshoot Azure Database for PostgreSQL Flexible Server, improving its performance and reliability. For more information, please refer to the provided links for each feature.