Azure Database for PostgreSQL (Single Server, Hyperscale)

On the Azure Database for PostgreSQL (Single Server, Hyperscale) overview pages you get insights into various aspects of database performance, including CPU and memory usage, active connections, storage space, and much more.

Prerequisites

  • Dynatrace version 1.196+
  • Environment ActiveGate version 1.195+

Enable monitoring

To enable monitoring for Azure Database for PostgreSQL (Single Server, Hyperscale), you first need to set up integration with Azure Monitor.
Optionally, for OneAgent integration, see how database activity is monitored.

Add the service to monitoring

In order to view the service metrics, you must add the service to monitoring in your Dynatrace environment.

Configure service metrics

Once you add a service, Dynatrace starts automatically collecting a suite of metrics for this particular service. These are recommended metrics.

Recommended metrics:

  • Are enabled by default
  • Can't be disabled
  • Can have recommended dimensions (enabled by default, can't be disabled)
  • Can have optional dimensions (disabled by default, can be enabled).

Apart from the recommended metrics, most services have the possibility of enabling optional metrics.

Optional metrics:

  • Can be added and configured manually

View service metrics

Once you add the service to monitoring, you can view the service metrics in your Dynatrace environment either on your dashboard page or on the custom device overview page.

Import preset dashboards

Dynatrace provides preset Azure dashboards that you can import from GitHub to your environment's Dashboards page.
Note: To save a preset dashboard locally, create a new JSON file on your local machine and copy-paste the content of the JSON file from GitHub into the new file.
Once you save a preset dashboard locally, there are two ways to import it.

postgres-dash hyper

Set up a management zone

To import a dashboard for Azure Database for PostgreSQL, you need to set up a management zone to limit the entities displayed on the dashboard to those relevant to this service.

When you create a management zone for this dashboard:

  1. Create a rule that identifies services based on a common property:
    • Service topology: Opaque service
    • Service type: Database
  2. Add a condition for the database name to contain the postgres string (case sensitive.)

Note: You can see whether a dashboard requires a management zone in the rules setup.

After you create the management zone, assign it to your dashboard (from the dashboard, select Edit > Settings > Default management zone). For more information, see Dashboard timeframe and management zone.

Available metrics

Azure Database for PostgreSQL (Single Server)

Name Description Unit Recommended
active_connections The number of active connections to the server Count ✔️
backup_storage_used The amount of backup storage used. This metric represents the sum of storage consumed by all the full database backups, differential backups, and log backups retained based on the backup retention period set for the server. Bytes
cpu_percent The percentage of CPU in use Percent ✔️
connections_failed The number of established connections that failed Count ✔️
io_consumption_percent The percentage of IO in use Percent ✔️
pg_replica_log_delay_in_bytes Lag in bytes of the most lagging replica Bytes
memory_percent The percentage of memory in use Percent ✔️
network_bytes_ingress Network in across active connections Bytes ✔️
network_bytes_egress Network out across active connections Bytes ✔️
pg_replica_log_delay_in_seconds The time since the last replayed transaction. This metric is available for replica servers only. Seconds ✔️
serverlog_storage_limit The maximum server log storage for this server Bytes
serverlog_storage_percent The percentage of server log storage used out of the server's maximum server log storage Percent ✔️
serverlog_storage_usage The amount of server log storage in use Bytes
storage_limit The maximum storage for this server Bytes
storage_percent The percentage of storage used out of the server's maximum Percent ✔️
storage_used The amount of storage in use. The storage used by the service may include the database files, transaction logs, and the server logs. Bytes

Azure Database for PostgreSQL Hyperscale

Name Description Unit Recommended
active_connections The number of active connections to the server Count ✔️
cpu_percent The percentage of CPU in use Percent ✔️
iops The number of requests that your application is sending to the storage disks in one second Count ✔️
memory_percent The percentage of memory in use Percent ✔️
network_bytes_egress Network out across active connections Byte ✔️
network_bytes_ingress Network in across active connections Byte ✔️
storage_percent The percentage of storage used out of the server's maximum Percent ✔️
storage_used The amount of storage in use. The storage used by the service may include the database files, transaction logs, and the server logs. Byte