We are excited to announce the release of new features aimed at enhancing the troubleshooting experience in Azure PostgreSQL Flexible Server. These features provide detailed insights and metrics, enabling you to optimize your database performance effectively.
Here are the use cases where these features can be used:
One of the significant enhancements is the addition of table-level autovacuum details. This feature allows you to:
Furthermore, we now display the configuration of some important parameters which control autovacuum. We validate some of those parameters and warn you if we consider that the existing configuration might cause issues with the correct functioning of autovacuum. We have also added a new Enhanced metrics tab which displays the Maximum number of Transaction IDs in use and the Oldest backend XMin metrics to provide a comprehensive view of autovacuum health.
To help you manage high CPU usage, we have introduced several new features:
For troubleshooting high memory usage, we have added validation for memory parameters where it can show you an insight when you change these parameters higher than defaults.
We have also introduced an insight for long (>24hrs) idle sessions that might consume server resources.
We believe these new features will significantly enhance your ability to troubleshoot and optimize your Azure PostgreSQL Flexible Server. We look forward to your feedback!
To learn more about the troubleshooting guides, visit our documentation below:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.