Edit

Troubleshooting guides for Azure Database for PostgreSQL - Flexible Server

  • Article

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'll be 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:

  • High CPU Usage,
  • High Memory Usage,
  • High IOPS Usage,
  • High Temporary Files,
  • Autovacuum Monitoring,
  • Autovacuum Blockers.

Screenshot of multiple Troubleshooting Guides combined.

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:

  • High CPU Usage

    • CPU Utilization
    • Workload Details
    • Transaction Trends and Counts
    • Long Running Transactions
    • Top CPU Consuming queries
    • Total User Only Connections

  • High Memory Usage

    • Memory Utilization
    • Workload Details
    • Long Running Sessions
    • Top Queries by Data Usage
    • Total User only Connections
    • Guidelines for configuring parameters

  • High IOPS Usage

    • IOPS Usage
    • Workload Details
    • Session Details
    • Top Queries by IOPS
    • IO Wait Events
    • Checkpoint Details
    • Storage Usage

  • High Temporary Files

    • Storage Utilization
    • Temporary Files Generated
    • Workload Details
    • Top Queries by Temporary Files

  • Autovacuum Monitoring

    • Bloat Ratio
    • Tuple Counts
    • Tables Vacuumed & Analyzed Execution Counts
    • Autovacuum Workers Execution Counts

  • Autovacuum Blockers

    • Emergency AV and Wraparound
    • Autovacuum Blockers

Before using any troubleshooting guide, it is essential to ensure that all prerequisites are in place. For a detailed list of prerequisites, please refer to the Use Troubleshooting Guides article.

Limitations

  • Troubleshooting Guides are not available for read replicas.
  • Please be aware that enabling Query Store on the Burstable pricing tier can lead to a negative impact on performance. As a result, it is generally not recommended to use Query Store with this particular pricing tier.

Next steps