Troubleshooting guides for Azure Database for PostgreSQL - Flexible Server

APPLIES TO: Azure Database for PostgreSQL - Flexible Server

The troubleshooting guides for Azure Database for PostgreSQL flexible server are designed to help you quickly identify and resolve common challenges you may encounter while using Azure Database for PostgreSQL flexible server. Integrated directly into the Azure portal, the troubleshooting guides provide actionable insights, recommendations, and data visualizations to assist you in diagnosing and addressing issues related to common performance problems. With these guides at your disposal, you are better equipped to optimize your Azure Database for PostgreSQL flexible server experience and ensure a smoother, more efficient database operation.

Overview

The troubleshooting guides available in Azure Database for PostgreSQL flexible server provide you with the necessary tools to analyze and troubleshoot prevalent performance issues, including:

• CPU
• Memory
• IOPS
• Temporary files
• Autovacuum monitoring
• Autovacuum blockers

Each guide is packed with multiple charts, guidelines, recommendations tailored to the specific problem you may encounter, which can help expedite the troubleshooting process. The troubleshooting guides are directly integrated into the Azure portal and your Azure Database for PostgreSQL flexible server instance, making them convenient and easy to use.

The troubleshooting guides consist of the following components:

• CPU

  • CPU
  • Workload
  • Transactions
  • Long running transactions
  • Queries
  • User connections
  • Locking and blocking

• Memory

  • Memory
  • Workload
  • Sessions
  • Queries
  • User connections
  • Memory parameters

• IOPS

  • IOPS
  • Workload
  • Sessions
  • Queries
  • Waits
  • Checkpoints
  • Storage

• Temporary files

  • Storage
  • Temporary files
  • Workload
  • Queries

• Autovacuum monitoring

  • Bloat
  • Tuples
  • Vacuum and analyze
  • Autovacuum workers
  • Autovacuum per table
  • Enhanced metrics

• Autovacuum blockers

  • Emergency autovacuum and wraparound
  • Autovacuum blockers

Before using any troubleshooting guide, it's essential to ensure that all prerequisites are in place. For a detailed list of prerequisites refer to the article Use troubleshooting guides.

Limitations

• Troubleshooting guides aren't available for read replicas.
• Be aware that enabling Query Store on the Burstable pricing tier can lead to a negative impact on performance. As a result, it's not recommended to use Query Store with this particular pricing tier.

Next steps

• Learn more about How to use troubleshooting guides.
• Learn more about Troubleshoot high CPU utilization.
• Learn more about High memory utilization.
• Learn more about Troubleshoot high IOPS utilization.
• Learn more about Autovacuum Tuning.