--- title: Azure DB for PostgreSQL description: Track key Azure DB for PostgreSQL metrics. breadcrumbs: Docs > Integrations > Azure DB for PostgreSQL --- > For the complete documentation index, see [llms.txt](https://docs.datadoghq.com/llms.txt). # Azure DB for PostgreSQL {% callout %} # Important note for users on the following Datadog sites: us2.ddog-gov.com {% alert level="info" %} To find out if this integration is available in your organization, see your [Datadog Integrations](https://app.datadoghq.com/integrations) page or ask your organization administrator. To initiate an exception request to enable this integration for your organization, email [support@ddog-gov.com](mailto:support@ddog-gov.com). {% /alert %} {% /callout %} ## Overview{% #overview %} Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service. Get metrics from Azure DB for PostgreSQL to: - Visualize the performance of your PostgreSQL databases. - Correlate the performance of your PostgreSQL databases with your applications. ## Setup{% #setup %} ### Installation{% #installation %} If you haven't already, set up the [Microsoft Azure integration](https://docs.datadoghq.com/integrations/azure.md) first. There are no other installation steps that need to be performed. ## Data Collected{% #data-collected %} ### Metrics{% #metrics %} | | | | | **azure.dbforpostgresql_flexibleservers.active_connections**(gauge) | Active Connections*Shown as connection* | | **azure.dbforpostgresql_flexibleservers.backup_storage_used**(gauge) | Backup Storage used*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.connections_failed**(count) | Failed Connections*Shown as connection* | | **azure.dbforpostgresql_flexibleservers.core_count**(gauge) | Core count | | **azure.dbforpostgresql_flexibleservers.count**(gauge) | The count of Azure DB for PostgreSQL flexible servers resources | | **azure.dbforpostgresql_flexibleservers.cpu_credits_consumed**(gauge) | Number of CPU credits consumed by the database server | | **azure.dbforpostgresql_flexibleservers.cpu_credits_remaining**(gauge) | Number of CPU credits available to the database server | | **azure.dbforpostgresql_flexibleservers.cpu_percent**(gauge) | CPU percent*Shown as percent* | | **azure.dbforpostgresql_flexibleservers.disk_queue_depth**(gauge) | Number of outstanding I/O operations to the disk | | **azure.dbforpostgresql_flexibleservers.iops**(count) | IO Operations per second*Shown as operation* | | **azure.dbforpostgresql_flexibleservers.maximum_used_transactionids**(gauge) | Maximum used transaction IDs | | **azure.dbforpostgresql_flexibleservers.memory_percent**(gauge) | Memory percent*Shown as percent* | | **azure.dbforpostgresql_flexibleservers.network_bytes_egress**(count) | Network Out across active connections*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.network_bytes_ingress**(count) | Network In across active connections*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.read_iops**(count) | Read IO Operations per second*Shown as operation* | | **azure.dbforpostgresql_flexibleservers.read_throughput**(count) | Bytes read per second from the disk*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.storage_free**(gauge) | Storage free*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.storage_percent**(gauge) | Storage percent*Shown as percent* | | **azure.dbforpostgresql_flexibleservers.storage_used**(gauge) | Storage used*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.txlogs_storage_used**(gauge) | Transaction log storage used*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.write_iops**(count) | Write IO Operations per second*Shown as operation* | | **azure.dbforpostgresql_flexibleservers.write_throughput**(count) | Bytes written per second from the disk*Shown as byte* | | **azure.dbforpostgresql_servergroups.count**(gauge) | The count of Azure DB for PostgreSQL server groups resources | | **azure.dbforpostgresql_servers.active_connections**(gauge) | Active Connections*Shown as connection* | | **azure.dbforpostgresql_servers.backup_storage_used**(gauge) | Backup Storage used*Shown as byte* | | **azure.dbforpostgresql_servers.connections_failed**(count) | Failed Connections*Shown as connection* | | **azure.dbforpostgresql_servers.core_count**(gauge) | Core count | | **azure.dbforpostgresql_servers.count**(gauge) | The count of Azure DB for PostgreSQL resources | | **azure.dbforpostgresql_servers.cpu_percent**(gauge) | CPU percent*Shown as percent* | | **azure.dbforpostgresql_servers.cpu_percent.max**(gauge) | Maximum CPU percent (Max Aggregated)*Shown as percent* | | **azure.dbforpostgresql_servers.io_consumption_percent**(gauge) | IO percent*Shown as percent* | | **azure.dbforpostgresql_servers.io_consumption_percent.max**(gauge) | Maximum IO percent (Max Aggregated)*Shown as percent* | | **azure.dbforpostgresql_servers.memory_percent**(gauge) | Memory percent*Shown as percent* | | **azure.dbforpostgresql_servers.memory_percent.max**(gauge) | Maximum Memory percent (Max Aggregated)*Shown as percent* | | **azure.dbforpostgresql_servers.network_bytes_egress**(count) | Network Out across active connections*Shown as byte* | | **azure.dbforpostgresql_servers.network_bytes_ingress**(count) | Network In across active connections*Shown as byte* | | **azure.dbforpostgresql_servers.pg_replica_log_delay_in_bytes**(gauge) | Lag in bytes of the most lagging replica*Shown as byte* | | **azure.dbforpostgresql_servers.pg_replica_log_delay_in_seconds**(gauge) | Replica lag in seconds*Shown as second* | | **azure.dbforpostgresql_servers.serverlog_storage_limit**(gauge) | Server Log storage limit*Shown as byte* | | **azure.dbforpostgresql_servers.serverlog_storage_percent**(gauge) | Server Log storage percent*Shown as percent* | | **azure.dbforpostgresql_servers.serverlog_storage_percent.max**(gauge) | Maximum Server Log storage percent (Max Aggregated)*Shown as percent* | | **azure.dbforpostgresql_servers.serverlog_storage_usage**(gauge) | Server Log storage used*Shown as byte* | | **azure.dbforpostgresql_servers.storage_limit**(gauge) | Storage limit*Shown as byte* | | **azure.dbforpostgresql_servers.storage_percent**(gauge) | Storage percent*Shown as percent* | | **azure.dbforpostgresql_servers.storage_percent.max**(gauge) | Maximum Storage percent (Max Aggregated)*Shown as percent* | | **azure.dbforpostgresql_servers.storage_used**(gauge) | Storage used*Shown as byte* | | **azure.dbforpostgresql_serversv2.active_connections**(gauge) | Active Connections*Shown as connection* | | **azure.dbforpostgresql_serversv2.count**(gauge) | The count of Azure DB for PostgreSQL resources | | **azure.dbforpostgresql_serversv2.cpu_percent**(gauge) | CPU percent*Shown as percent* | | **azure.dbforpostgresql_serversv2.iops**(count) | IO Operations per second*Shown as operation* | | **azure.dbforpostgresql_serversv2.memory_percent**(gauge) | Memory percent*Shown as percent* | | **azure.dbforpostgresql_serversv2.network_bytes_egress**(count) | Network Out across active connections*Shown as byte* | | **azure.dbforpostgresql_serversv2.network_bytes_ingress**(count) | Network In across active connections*Shown as byte* | | **azure.dbforpostgresql_serversv2.storage_percent**(gauge) | Storage percent*Shown as percent* | | **azure.dbforpostgresql_serversv2.storage_used**(gauge) | Storage used*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.longest_query_time_sec**(gauge) | Age in seconds of the longest query that is currently running.*Shown as second* | | **azure.dbforpostgresql_flexibleservers.longest_transaction_time_sec**(gauge) | Age in seconds of the longest transaction (including idle transactions).*Shown as second* | | **azure.dbforpostgresql_flexibleservers.oldest_backend_time_sec**(gauge) | Age in seconds of the oldest backend (irrespective of the state).*Shown as second* | | **azure.dbforpostgresql_flexibleservers.oldest_backend_xmin**(gauge) | Actual value of the oldest xmin. | | **azure.dbforpostgresql_flexibleservers.oldest_backend_xmin_age**(gauge) | Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin. | | **azure.dbforpostgresql_flexibleservers.sessions_by_state**(gauge) | Overall state of the backends. | | **azure.dbforpostgresql_flexibleservers.sessions_by_wait_event_type**(gauge) | Sessions by the type of event for which the backend is waiting. | | **azure.dbforpostgresql_flexibleservers.analyze_count_user_tables**(gauge) | Number of times user only tables have been manually analyzed in this database. | | **azure.dbforpostgresql_flexibleservers.autoanalyze_count_user_tables**(gauge) | Number of times user only tables have been analyzed by the autovacuum daemon in this database. | | **azure.dbforpostgresql_flexibleservers.autovacuum_count_user_tables**(gauge) | Number of times user only tables have been vacuumed by the autovacuum daemon in this database. | | **azure.dbforpostgresql_flexibleservers.bloat_percent**(gauge) | Estimated bloat percentage for user only tables in this database.*Shown as percent* | | **azure.dbforpostgresql_flexibleservers.n_dead_tup_user_tables**(gauge) | Estimated number of dead rows for user only tables in this database. | | **azure.dbforpostgresql_flexibleservers.n_live_tup_user_tables**(gauge) | Estimated number of live rows for user only tables in this database. | | **azure.dbforpostgresql_flexibleservers.n_mod_since_analyze_user_tables**(gauge) | Estimated number of rows modified since user only tables were last analyzed. | | **azure.dbforpostgresql_flexibleservers.tables_analyzed_user_tables**(gauge) | Number of user only tables that have been analyzed in this database. | | **azure.dbforpostgresql_flexibleservers.tables_autoanalyzed_user_tables**(gauge) | Number of user only tables that have been analyzed by the autovacuum daemon in this database. | | **azure.dbforpostgresql_flexibleservers.tables_autovacuumed_user_tables**(gauge) | Number of user only tables that have been vacuumed by the autovacuum daemon in this database. | | **azure.dbforpostgresql_flexibleservers.tables_counter_user_tables**(gauge) | Number of user only tables in this database. | | **azure.dbforpostgresql_flexibleservers.tables_vacuumed_user_tables**(gauge) | Number of user only tables that have been vacuumed in this database. | | **azure.dbforpostgresql_flexibleservers.vacuum_count_user_tables**(gauge) | Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL). | | **azure.dbforpostgresql_flexibleservers.is_db_alive**(gauge) | Indicates if the database is up or not. | | **azure.dbforpostgresql_flexibleservers.blks_hit**(count) | Number of times disk blocks were found already in the buffer cache, so that a read was not necessary. | | **azure.dbforpostgresql_flexibleservers.blks_read**(count) | Number of disk blocks read in this database. | | **azure.dbforpostgresql_flexibleservers.database_size_bytes**(gauge) | Total database size.*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.deadlocks**(count) | Number of deadlocks detected in this database. | | **azure.dbforpostgresql_flexibleservers.numbackends**(gauge) | Number of backends connected to this database. | | **azure.dbforpostgresql_flexibleservers.temp_bytes**(count) | Total amount of data written to temporary files by queries in this database.*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.temp_files**(count) | Number of temporary files created by queries in this database. | | **azure.dbforpostgresql_flexibleservers.tps**(gauge) | Number of transactions executed within a second. | | **azure.dbforpostgresql_flexibleservers.tup_deleted**(count) | Number of rows deleted by queries in this database. | | **azure.dbforpostgresql_flexibleservers.tup_fetched**(count) | Number of rows fetched by queries in this database. | | **azure.dbforpostgresql_flexibleservers.tup_inserted**(count) | Number of rows inserted by queries in this database. | | **azure.dbforpostgresql_flexibleservers.tup_returned**(count) | Number of rows returned by queries in this database. | | **azure.dbforpostgresql_flexibleservers.tup_updated**(count) | Number of rows updated by queries in this database. | | **azure.dbforpostgresql_flexibleservers.xact_commit**(count) | Number of transactions in this database that have been committed. | | **azure.dbforpostgresql_flexibleservers.xact_rollback**(count) | Number of transactions in this database that have been rolled back. | | **azure.dbforpostgresql_flexibleservers.xact_total**(count) | Number of total transactions executed in this database. | | **azure.dbforpostgresql_flexibleservers.logical_replication_delay_in_bytes**(gauge) | Maximum lag across all logical replication slots.*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.client_connections_active**(gauge) | Connections from clients which are associated with a postgresql connection. | | **azure.dbforpostgresql_flexibleservers.client_connections_waiting**(gauge) | Connections from clients that are waiting for a postgresql connection to service them. | | **azure.dbforpostgresql_flexibleservers.num_pools**(gauge) | Total number of connection pools. | | **azure.dbforpostgresql_flexibleservers.server_connections_active**(gauge) | Connections to postgresql that are in use by a client connection. | | **azure.dbforpostgresql_flexibleservers.server_connections_idle**(gauge) | Connections to postgresql that are idle, ready to service a new client connection. | | **azure.dbforpostgresql_flexibleservers.total_pooled_connections**(gauge) | Current number of pooled connections. | | **azure.dbforpostgresql_flexibleservers.physical_replication_delay_in_bytes**(gauge) | Maximum lag across all asynchronous physical replication slots.*Shown as byte* | | **azure.dbforpostgresql_flexibleservers.physical_replication_delay_in_seconds**(gauge) | Read replica lag in seconds.*Shown as second* | | **azure.dbforpostgresql_flexibleservers.disk_bandwidth_consumed_percentage**(gauge) | Percentage of disk bandwidth consumed per minute.*Shown as percent* | | **azure.dbforpostgresql_flexibleservers.disk_iops_consumed_percentage**(gauge) | Percentage of disk i/os consumed per minute.*Shown as percent* | | **azure.dbforpostgresql_flexibleservers.platform_cpu_percent**(gauge) | CPU percent from platform.*Shown as percent* | | **azure.dbforpostgresql_flexibleservers.postmaster_process_cpu_usage_percent**(gauge) | CPU usage of postmaster process. Not applicable for burstable SKU.*Shown as percent* | | **azure.dbforpostgresql_flexibleservers.connections_succeeded**(count) | Succeeded connections. | | **azure.dbforpostgresql_flexibleservers.max_connections**(gauge) | Max connections. | | **azure.dbforpostgresql_flexibleservers.maximum_used_transaction_i_ds**(gauge) | Maximum used transaction ids. | | **azure.dbforpostgresql_flexibleservers.tcp_connection_backlog**(gauge) | Number of pending TCP connections waiting to be processed by the server. Applicable for 8vcore and above. | | **azure.dbforpostgresql_flexibleservers.logical_replication_slot_sync_status**(gauge) | Displays status of logical replication slots in HA. | ### Events{% #events %} The Azure DB for PostgreSQL integration does not include any events. ### Service Checks{% #service-checks %} The Azure DB for PostgreSQL integration does not include any service checks. ## Troubleshooting{% #troubleshooting %} Need help? Contact [Datadog support](https://docs.datadoghq.com/help/).