Monitor Azure Database for PostgreSQL flexible server by using Azure Monitor workbooks

APPLIES TO: Azure Database for PostgreSQL flexible server

Azure Database for PostgreSQL Flexible Server is integrated with Azure Monitor workbooks. Workbooks give you a flexible canvas for analyzing data and creating rich visual reports within the Azure portal. Workbooks allow you to tap into multiple data sources across Azure and combine them into unified interactive experiences. Workbook templates serve as curated reports designed for flexible reuse by various users and teams.

When you open a template, you create a transient workbook which is populated with the contents of the template. With this integration, the server links to workbooks and a few sample templates, which can help you monitor the service at scale. You can edit these templates, customize them to your requirements, and pin them to the dashboard to create a focused and organized view of Azure resources.

In this article, you learn about the various workbook templates available for your Azure Database for PostgreSQL flexible server instance.

Azure Database for PostgreSQL Flexible Server has two available templates:

• Overview: Displays an instance summary and top-level metrics to help you visualize and understand the resource utilization on your server. This template displays the following views:

  • Server details
    • Server summary
    • Database availability
    • Database summary
  • Connection metrics
  • Performance metrics
  • Storage metrics

• Enhanced metrics: Displays a summary of enhanced metrics for Azure Database for PostgreSQL Flexible Server, with more fine-grained database monitoring. To enable these metrics, enable the server parameters metrics.collector_database_activity and metrics.autovacuum_diagnostics. These parameters are dynamic and don't require a server restart. For more information, see enhanced metrics and autovacuum metrics. This template displays the following views:

  • Activity
  • Database
  • Autovacuum
  • Replication

You can also edit and customize these templates according to your requirements. For more information, see Azure Workbooks.

Using the Azure portal.

1. Select your Azure Database for PostgreSQL flexible server instance.

2. In the resource menu, under Monitoring, select Workbooks.

   

3. Select the Overview or the Enhanced Metrics template.

   

• Access control in Azure workbooks
• Visualization options in Azure workbooks
• Enhanced metrics
• Autovacuum metrics