title | description | ms.service | ms.subservice | ms.topic | ms.author | ms.date |
---|---|---|---|---|---|---|
Query Performance Insights |
High level spec doc |
postgresql |
flexible-server |
conceptual |
varundhawan |
1/3/2023 |
title | description | ms.service | ms.subservice | ms.topic | ms.author | ms.date |
---|---|---|---|---|---|---|
Azure Database for PostgreSQL Flexible Server - DB-is-Alive metric (Preview) |
Metrics to monitor database availability |
postgresql |
flexible-server |
conceptual |
varun.dhawan |
1/1/2023 |
title | description | ms.service | ms.subservice | ms.topic | ms.author | ms.date |
---|---|---|---|---|---|---|
Azure Database for PostgreSQL Flexible Server - Autovacuum metrics (Preview) |
Metrics to monitor Auto Vacuum |
postgresql |
flexible-server |
conceptual |
varun.dhawan |
12/01/2022 |
title | description | ms.service | ms.subservice | ms.topic | ms.author | ms.date |
---|---|---|---|---|---|---|
Azure Database for PostgreSQL Flexible Server - PgBouncer metrics (Preview) |
Metrics to monitor PgBouncer |
postgresql |
flexible-server |
conceptual |
varun.dhawan |
11/01/2022 |
// Find Errors
// Search for errors in the last 6 hours.
// To create an alert for this query, click '+ New alert rule'
// Blog - https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/how-do-i-check-logs-for-azure-database-for-postgresql/ba-p/3618983
AzureDiagnostics
PgBouncer is an open-source, lightweight, single-binary connection pooler for PostgreSQL. It can pool connections to one or more databases (on possibly different servers) and serve clients over TCP and Unix domain sockets. The primary benefit of PgBouncer is to improve idle connections and short-lived connections at the database server.
When enabled, PgBouncer runs on port 6432 on your database server. You can change your application’s database connection configuration to use the same host name, but change the port to 6432 to start using PgBouncer.
title | description | ms.service | ms.subservice | ms.topic | ms.author | ms.date |
---|---|---|---|---|---|---|
Azure Database for PostgreSQL Flexible Server Enhanced metrics - Preview |
List of new metrics |
postgresql |
flexible-server |
conceptual |
varun.dhawan |
10/13/2022 |