Introducing new troubleshooting guides features

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:

[HEADING=1]Enhancements to autovacuum monitoring:[/HEADING]

One of the significant enhancements is the addition of table-level autovacuum details. This feature allows you to:

• Monitor the number of times autovacuum ran.
  
• Check the number of dead tuples cleaned or not removed.
  
• Track the time taken to run the autovacuum.
  

Autovacuum per table

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.

Autovacuum configuration

Enhance metrics

[HEADING=1]Enhancements to the CPU troubleshooting guide:[/HEADING]

To help you manage high CPU usage, we have introduced several new features:

• Parameter check for excessive logging that might impact the CPU usage and overall server performance.
  Potential excessive logging insight
  
• New "Top queries by total duration" tab which displays Query Store queries with total time.
  Top queries by total time
  
• New insight card showing sessions whose state is idle and have an open transaction.
  Idle in transaction session insight
  
• New tab to showcase PgBouncer metrics and best practices:
  PgBouncer metrics
   
   
  PgBouncer recommendations
   
   
   
  
• A new tab to display the locking information: In this section, you can get the overview of locks in your server.
  
  • You can get the count of sessions involved in Locks.
    Locking and blocking
     
     
    Sessions count with lock wait event
    
  • You can monitor the acquired locks duration during the specified time.
    Duration of acquired locks
    

  [*]You can also get insights on blocking session where sessions are still waiting for lock acquisition.

  Blocking information

[HEADING=1]Enhancements to the memory troubleshooting guide:[/HEADING]

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.

Memory parameter check insight

We have also introduced an insight for long (>24hrs) idle sessions that might consume server resources.

Long idle session insight

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!

[HEADING=2]Getting started:[/HEADING]

To learn more about the troubleshooting guides, visit our documentation below:

• What are the troubleshooting guides in Azure Database for PostgreSQL Flexible Server
  
• How to use the troubleshooting guides for Azure Database for PostgreSQL Flexible Server
  

Continue reading...