Supported metrics for Microsoft.DBforPostgreSQL/flexibleServers
The following table lists the metrics available for the Microsoft.DBforPostgreSQL/flexibleServers resource type.
Table headings
Metric - The metric display name as it appears in the Azure portal.
Name in Rest API - Metric name as referred to in the REST API.
Unit - Unit of measure.
Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, Count.
Dimensions - Dimensions available for the metric.
Time Grains - Intervals at which the metric is sampled. For example, PT1M indicates that the metric is sampled every minute, PT30M every 30 minutes, PT1H every hour, and so on.
DS Export- Whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.
For information on exporting metrics, see Create diagnostic settings in Azure Monitor.
For information on metric retention, see Azure Monitor Metrics overview.
For a list of supported logs, see Supported log categories - Microsoft.DBforPostgreSQL/flexibleServers
| Category | Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Traffic | Active Connections Active Connections |
active_connections |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Autovacuum | Analyze Counter User Tables Number of times user only tables have been manually analyzed in this database |
analyze_count_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Autovacuum | AutoAnalyze Counter User Tables Number of times user only tables have been analyzed by the autovacuum daemon in this database |
autoanalyze_count_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Autovacuum | AutoVacuum Counter User Tables Number of times user only tables have been vacuumed by the autovacuum daemon in this database |
autovacuum_count_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Saturation | Backup Storage Used Backup Storage Used |
backup_storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Database | Disk Blocks Hit Number of times disk blocks were found already in the buffer cache, so that a read was not necessary |
blks_hit |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Database | Disk Blocks Read Number of disk blocks read in this database |
blks_read |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Autovacuum | Bloat Percent (Preview) Estimated bloat percentage for user only tables in this database |
bloat_percent |
Percent | Maximum | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| PgBouncer metrics | Active client connections Connections from clients which are associated with a PostgreSQL connection |
client_connections_active |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| PgBouncer metrics | Waiting client connections Connections from clients that are waiting for a PostgreSQL connection to service them |
client_connections_waiting |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| Errors | Failed Connections Failed Connections |
connections_failed |
Count | Total (Sum) | <none> | PT1M | Yes |
| Traffic | Succeeded Connections Succeeded Connections |
connections_succeeded |
Count | Total (Sum) | <none> | PT1M | Yes |
| Saturation | CPU Credits Consumed Total number of credits consumed by the database server |
cpu_credits_consumed |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | CPU Credits Remaining Total number of credits available to burst |
cpu_credits_remaining |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | CPU percent CPU percent |
cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Database | Database Size Total database size |
database_size_bytes |
Bytes | Average, Maximum, Minimum | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Database | Deadlocks Number of deadlocks detected in this database |
deadlocks |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Saturation | Disk Bandwidth Consumed Percentage Percentage of disk bandwidth consumed per minute |
disk_bandwidth_consumed_percentage |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | Disk IOPS Consumed Percentage Percentage of disk I/Os consumed per minute |
disk_iops_consumed_percentage |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | Disk Queue Depth Number of outstanding I/O operations to the data disk |
disk_queue_depth |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | IOPS IO Operations per second |
iops |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Availability | Database Is Alive Indicates if the database is up or not |
is_db_alive |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Logical Replication | Max Logical Replication Lag Maximum lag across all logical replication slots |
logical_replication_delay_in_bytes |
Bytes | Maximum, Minimum, Average | <none> | PT1M | Yes |
| Activity | Oldest Query The age in seconds of the longest query that is currently running |
longest_query_time_sec |
Seconds | Maximum | <none> | PT1M | Yes |
| Activity | Oldest Transaction The age in seconds of the longest transaction (including idle transactions) |
longest_transaction_time_sec |
Seconds | Maximum | <none> | PT1M | Yes |
| Traffic | Max Connections Max connections |
max_connections |
Count | Maximum | <none> | PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Traffic | Maximum Used Transaction IDs Maximum Used Transaction IDs |
maximum_used_transactionIDs |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | Memory percent Memory percent |
memory_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Autovacuum | Estimated Dead Rows User Tables Estimated number of dead rows for user only tables in this database |
n_dead_tup_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Autovacuum | Estimated Live Rows User Tables Estimated number of live rows for user only tables in this database |
n_live_tup_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Autovacuum | Estimated Modifications User Tables Estimated number of rows modified since user only tables were last analyzed |
n_mod_since_analyze_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Traffic | Network Out Network Out across active connections |
network_bytes_egress |
Bytes | Total (Sum) | <none> | PT1M | Yes |
| Traffic | Network In Network In across active connections |
network_bytes_ingress |
Bytes | Total (Sum) | <none> | PT1M | Yes |
| PgBouncer metrics | Number of connection pools Total number of connection pools |
num_pools |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| Database | Backends Number of backends connected to this database |
numbackends |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| Activity | Oldest Backend The age in seconds of the oldest backend (irrespective of the state) |
oldest_backend_time_sec |
Seconds | Maximum | <none> | PT1M | Yes |
| Activity | Oldest xmin The actual value of the oldest xmin. |
oldest_backend_xmin |
Count | Maximum | <none> | PT1M | Yes |
| Activity | Oldest xmin Age Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin |
oldest_backend_xmin_age |
Count | Maximum | <none> | PT1M | Yes |
| Replication | Max Physical Replication Lag Maximum lag across all asynchronous physical replication slots |
physical_replication_delay_in_bytes |
Bytes | Maximum, Minimum, Average | <none> | PT1M | Yes |
| Replication | Read Replica Lag Read Replica lag in seconds |
physical_replication_delay_in_seconds |
Seconds | Maximum, Minimum, Average | <none> | PT1M | Yes |
| Saturation | CPU percent from platform (Preview) CPU percent from platform |
platform_cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | Postmaster Process cpu usage (Preview) CPU utilization of Postmaster process. Not applicable for Burstable SKU |
postmaster_process_cpu_usage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | No |
| Saturation | Read IOPS Number of data disk I/O read operations per second |
read_iops |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | Read Throughput Bytes/Sec Bytes read per second from the data disk during monitoring period |
read_throughput |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| PgBouncer metrics | Active server connections Connections to PostgreSQL that are in use by a client connection |
server_connections_active |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| PgBouncer metrics | Idle server connections Connections to PostgreSQL that are idle, ready to service a new client connection |
server_connections_idle |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| Activity | Sessions by State Overall state of the backends |
sessions_by_state |
Count | Maximum, Minimum, Average | State |
PT1M | Yes |
| Activity | Sessions by WaitEventType Sessions by the type of event for which the backend is waiting |
sessions_by_wait_event_type |
Count | Maximum, Minimum, Average | WaitEventType |
PT1M | Yes |
| Saturation | Storage Free Storage Free |
storage_free |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | Storage percent Storage percent |
storage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | Storage used Storage used |
storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Autovacuum | User Tables Analyzed Number of user only tables that have been analyzed in this database |
tables_analyzed_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Autovacuum | User Tables AutoAnalyzed Number of user only tables that have been analyzed by the autovacuum daemon in this database |
tables_autoanalyzed_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Autovacuum | User Tables AutoVacuumed Number of user only tables that have been vacuumed by the autovacuum daemon in this database |
tables_autovacuumed_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Autovacuum | User Tables Counter Number of user only tables in this database |
tables_counter_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Autovacuum | User Tables Vacuumed Number of user only tables that have been vacuumed in this database |
tables_vacuumed_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Traffic | TCP Connection Backlog (Preview) Number of pending connections that exceed the PostgreSQL server's capacity. Applicable for 8vcore and above |
tcp_connection_backlog |
Count | Maximum, Minimum, Average | <none> | PT1M | No |
| Database | Temporary Files Size Total amount of data written to temporary files by queries in this database |
temp_bytes |
Bytes | Total (Sum) | DatabaseName |
PT1M | Yes |
| Database | Temporary Files Number of temporary files created by queries in this database |
temp_files |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| PgBouncer metrics | Total pooled connections Current number of pooled connections |
total_pooled_connections |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| Database | Transactions per second (Preview) Number of transactions executed within a second |
tps |
Count | Minimum, Maximum, Total (Sum) | DatabaseName |
PT1M | Yes |
| Database | Tuples Deleted Number of rows deleted by queries in this database |
tup_deleted |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Database | Tuples Fetched Number of rows fetched by queries in this database |
tup_fetched |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Database | Tuples Inserted Number of rows inserted by queries in this database |
tup_inserted |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Database | Tuples Returned Number of rows returned by queries in this database |
tup_returned |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Database | Tuples Updated Number of rows updated by queries in this database |
tup_updated |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Saturation | Transaction Log Storage Used Transaction Log Storage Used |
txlogs_storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Autovacuum | Vacuum Counter User Tables Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL) |
vacuum_count_user_tables |
Count | Maximum, Minimum, Average | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Saturation | Write IOPS Number of data disk I/O write operations per second |
write_iops |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Saturation | Write Throughput Bytes/Sec Bytes written per second to the data disk during monitoring period |
write_throughput |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Database | Transactions Committed Number of transactions in this database that have been committed |
xact_commit |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Database | Transactions Rolled Back Number of transactions in this database that have been rolled back |
xact_rollback |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Database | Total Transactions Number of total transactions executed in this database |
xact_total |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |