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 - Metrics export using data collection rules and 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: Activity
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Oldest Query The age in seconds of the longest query that is currently running |
longest_query_time_sec |
Seconds | Maximum | <none> | PT1M | Yes |
| Oldest Transaction The age in seconds of the longest transaction (including idle transactions) |
longest_transaction_time_sec |
Seconds | Maximum | <none> | PT1M | Yes |
| Oldest Backend The age in seconds of the oldest backend (irrespective of the state) |
oldest_backend_time_sec |
Seconds | Maximum | <none> | PT1M | Yes |
| Oldest xmin The actual value of the oldest xmin. |
oldest_backend_xmin |
Count | Maximum | <none> | PT1M | Yes |
| 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 |
| Sessions by State Overall state of the backends |
sessions_by_state |
Count | Maximum, Minimum, Average | State |
PT1M | Yes |
| 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 |
Category: Autovacuum
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| 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 |
| 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 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 |
| Bloat Percent (Preview) Estimated bloat percentage for user only tables in this database |
bloat_percent |
Percent | Maximum | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
Category: Availability
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Database Is Alive Indicates if the database is up or not |
is_db_alive |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Category: Database
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| 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 |
| Disk Blocks Read Number of disk blocks read in this database |
blks_read |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Database Size Total database size |
database_size_bytes |
Bytes | Average, Maximum, Minimum | DatabaseName |
PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Deadlocks Number of deadlocks detected in this database |
deadlocks |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Backends Number of backends connected to this database |
numbackends |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| Temporary Files Size Total amount of data written to temporary files by queries in this database |
temp_bytes |
Bytes | Total (Sum) | DatabaseName |
PT1M | Yes |
| Temporary Files Number of temporary files created by queries in this database |
temp_files |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Transactions per second (Preview) Number of transactions executed within a second |
tps |
Count | Minimum, Maximum, Total (Sum) | DatabaseName |
PT1M | Yes |
| Tuples Deleted Number of rows deleted by queries in this database |
tup_deleted |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Tuples Fetched Number of rows fetched by queries in this database |
tup_fetched |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Tuples Inserted Number of rows inserted by queries in this database |
tup_inserted |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Tuples Returned Number of rows returned by queries in this database |
tup_returned |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Tuples Updated Number of rows updated by queries in this database |
tup_updated |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Transactions Committed Number of transactions in this database that have been committed |
xact_commit |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Transactions Rolled Back Number of transactions in this database that have been rolled back |
xact_rollback |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
| Total Transactions Number of total transactions executed in this database |
xact_total |
Count | Total (Sum) | DatabaseName |
PT1M | Yes |
Category: Errors
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Failed Connections Failed Connections |
connections_failed |
Count | Total (Sum) | <none> | PT1M | Yes |
Category: Logical Replication
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Max Logical Replication Lag Maximum lag across all logical replication slots |
logical_replication_delay_in_bytes |
Bytes | Maximum, Minimum, Average | <none> | PT1M | Yes |
Category: PgBouncer metrics
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Active client connections Connections from clients which are associated with a PostgreSQL connection |
client_connections_active |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| 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 |
| Number of connection pools Total number of connection pools |
num_pools |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| Active server connections Connections to PostgreSQL that are in use by a client connection |
server_connections_active |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
| 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 |
| Total pooled connections Current number of pooled connections |
total_pooled_connections |
Count | Maximum, Minimum, Average | DatabaseName |
PT1M | Yes |
Category: Replication
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Max Physical Replication Lag Maximum lag across all asynchronous physical replication slots |
physical_replication_delay_in_bytes |
Bytes | Maximum, Minimum, Average | <none> | PT1M | Yes |
| Read Replica Lag Read Replica lag in seconds |
physical_replication_delay_in_seconds |
Seconds | Maximum, Minimum, Average | <none> | PT1M | Yes |
Category: Saturation
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Backup Storage Used Backup Storage Used |
backup_storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| CPU Credits Consumed Total number of credits consumed by the database server |
cpu_credits_consumed |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| CPU Credits Remaining Total number of credits available to burst |
cpu_credits_remaining |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| CPU percent CPU percent |
cpu_percent |
Percent | Average, Maximum, Minimum | ServerName |
PT1M | Yes |
| Disk Bandwidth Consumed Percentage Percentage of disk bandwidth consumed per minute |
disk_bandwidth_consumed_percentage |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Disk IOPS Consumed Percentage Percentage of disk I/Os consumed per minute |
disk_iops_consumed_percentage |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Disk Queue Depth Number of outstanding I/O operations to the data disk |
disk_queue_depth |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| IOPS IO Operations per second |
iops |
Count | Average, Maximum, Minimum | ServerName |
PT1M | Yes |
| Memory percent Memory percent |
memory_percent |
Percent | Average, Maximum, Minimum | ServerName |
PT1M | Yes |
| CPU percent from platform (Preview) CPU percent from platform |
platform_cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| 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 |
| Read IOPS Number of data disk I/O read operations per second |
read_iops |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Read Throughput Bytes/Sec Bytes read per second from the data disk during monitoring period |
read_throughput |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Storage Free Storage Free |
storage_free |
Bytes | Average, Maximum, Minimum | ServerName |
PT1M | Yes |
| Storage percent Storage percent |
storage_percent |
Percent | Average, Maximum, Minimum | ServerName |
PT1M | Yes |
| Storage used Storage used |
storage_used |
Bytes | Average, Maximum, Minimum | ServerName |
PT1M | Yes |
| Transaction Log Storage Used Transaction Log Storage Used |
txlogs_storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Write IOPS Number of data disk I/O write operations per second |
write_iops |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Write Throughput Bytes/Sec Bytes written per second to the data disk during monitoring period |
write_throughput |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Category: Traffic
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Active Connections Active Connections |
active_connections |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Succeeded Connections Succeeded Connections |
connections_succeeded |
Count | Total (Sum) | <none> | PT1M | Yes |
| Max Connections Max connections |
max_connections |
Count | Maximum | <none> | PT30M, PT1H, PT6H, PT12H, P1D | Yes |
| Maximum Used Transaction IDs Maximum Used Transaction IDs |
maximum_used_transactionIDs |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Network Out Network Out across active connections |
network_bytes_egress |
Bytes | Total (Sum) | ServerName |
PT1M | Yes |
| Network In Network In across active connections |
network_bytes_ingress |
Bytes | Total (Sum) | ServerName |
PT1M | Yes |
| 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 |