Azure Advisor for PostgreSQL

APPLIES TO: Azure Database for PostgreSQL - Single Server


Azure Database for PostgreSQL - Single Server is on the retirement path. We strongly recommend that you upgrade to Azure Database for PostgreSQL - Flexible Server. For more information about migrating to Azure Database for PostgreSQL - Flexible Server, see What's happening to Azure Database for PostgreSQL Single Server?.

Learn about how Azure Advisor is applied to Azure Database for PostgreSQL and get answers to common questions.

What is Azure Advisor for PostgreSQL?

The Azure Advisor system uses telemetry to issue performance and reliability recommendations for your PostgreSQL database. Advisor recommendations are split among our PostgreSQL database offerings:

  • Azure Database for PostgreSQL - Single Server
  • Azure Database for PostgreSQL - Flexible Server

Some recommendations are common to multiple product offerings, while other recommendations are based on product-specific optimizations.

Where can I view my recommendations?

Recommendations are available from the Overview navigation sidebar in the Azure portal. A preview appears as a banner notification, and details can be viewed in the Notifications section located just below the resource usage graphs.

Screenshot of the Azure portal showing an Azure Advisor recommendation.

Recommendation types

Azure Database for PostgreSQL prioritizes the following types of recommendations:

  • Performance: To improve the speed of your PostgreSQL server. This includes CPU usage, memory pressure, connection pooling, disk utilization, and product-specific server parameters. For more information, see Advisor Performance recommendations.
  • Reliability: To ensure and improve the continuity of your business-critical databases. This includes storage limits, and connection limits. For more information, see Advisor Reliability recommendations.
  • Cost: To optimize and reduce your overall Azure spending. This includes server right-sizing recommendations. For more information, see Advisor Cost recommendations.

Understanding your recommendations

  • Daily schedule: For Azure PostgreSQL databases, we check server telemetry and issue recommendations on a daily schedule. If you make a change to your server configuration, existing recommendations remain visible until we re-examine telemetry on the following day.
  • Performance history: Some of our recommendations are based on performance history. These recommendations only appear after a server has been operating with the same configuration for seven days. This allows us to detect patterns of heavy usage (for example, high CPU activity or high connection volume) over a sustained time period. If you provision a new server or change to a new vCore configuration, these recommendations are paused temporarily. This prevents legacy telemetry from triggering recommendations on a newly reconfigured server. However, this also means that performance history-based recommendations may not be identified immediately.

Next steps

For more information, see Azure Advisor Overview.