--- title: Azure DB for PostgreSQL description: Track key Azure DB for PostgreSQL metrics. breadcrumbs: Docs > Integrations > Azure DB for PostgreSQL --- # Azure DB for PostgreSQL ## 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. | ### 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/).