The Azure Database for PostgreSQL – Flexible Server integration collects platform metrics and diagnostic logs from your PostgreSQL Flexible Server instances. Once enabled, the SigNoz agent discovers PostgreSQL Flexible Server resources in your monitored resource groups and configures telemetry collection.
This integration collects platform metrics for the Microsoft.DBforPostgreSQL/flexibleServers resource type.
Getting started
Connect your Azure subscription first. See Azure One-Click Integrations for setup instructions.
Once connected:
- In SigNoz, navigate to Integrations > Microsoft Azure.
- Select PostgreSQL - Flexible Server from the left panel.
- Toggle Log Collection and Metric Collection on.
The agent deploys the necessary Event Hubs and diagnostic settings in the background. Data starts flowing within a few minutes. Navigate to Dashboards and open the Azure Database for PostgreSQL - Flexible Server Overview dashboard to confirm metrics are appearing.
What's collected
Logs
| Name | Path | Type |
|---|---|---|
| Resource ID | resources.azure.resource.id | string |
Key metrics
The table below lists representative metrics; see the Data Collected tab in the integration for the complete list.
| Metric name | Unit | Type |
|---|---|---|
azure_cpu_percent_average | Percent | Gauge |
azure_memory_percent_average | Percent | Gauge |
azure_storage_percent_average | Percent | Gauge |
azure_storage_used_average | Bytes | Gauge |
azure_storage_free_average | Bytes | Gauge |
azure_iops_average | Count | Gauge |
azure_read_iops_average | Count | Gauge |
azure_write_iops_average | Count | Gauge |
azure_disk_iops_consumed_percentage_average | Percent | Gauge |
azure_disk_queue_depth_average | Count | Gauge |
azure_active_connections_average | Count | Gauge |
azure_connections_succeeded_total | Count | Sum |
azure_connections_failed_total | Count | Sum |
azure_max_connections_average | Count | Gauge |
azure_deadlocks_total | Count | Sum |
azure_tps_average | Count | Gauge |
azure_xact_commit_total | Count | Sum |
azure_xact_rollback_total | Count | Sum |
azure_is_db_alive_average | Count | Gauge |
azure_database_size_bytes_average | Bytes | Gauge |
azure_backup_storage_used_average | Bytes | Gauge |
azure_physical_replication_delay_in_bytes_average | Bytes | Gauge |
azure_logical_replication_delay_in_bytes_average | Bytes | Gauge |
Dashboards
The integration includes a pre-built PostgreSQL Flexible Server dashboard. Pre-built dashboards are locked and cannot be edited. To customize, use Export JSON from the dashboard menu and import it as a new dashboard.
Key panels include:
- CPU, memory, and storage percentage; storage used and free
- IOPS (read/write), disk IOPS consumed percentage, and disk queue depth
- Active connections, succeeded and failed connections, and max connections
- Transactions per second, committed and rolled-back transactions, and deadlocks
- Tuples returned, fetched, inserted, updated, and deleted
- Replication lag (physical and logical) and read replica lag
- PgBouncer connection pools, active/idle server connections, and waiting client connections
Next steps
- Create alerts to get notified on connection saturation, replication lag, or storage exhaustion
- Build custom dashboards to correlate database metrics with application performance
Get Help
If you need help with the steps in this topic, please reach out to us on SigNoz Community Slack. If you are a SigNoz Cloud user, please use in product chat support located at the bottom right corner of your SigNoz instance or contact us at cloud-support@signoz.io.
