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	ServerName	PT1M	Yes
Oldest Transaction The age in seconds of the longest transaction (including idle transactions)	longest_transaction_time_sec	Seconds	Maximum	ServerName	PT1M	Yes
Oldest Backend The age in seconds of the oldest backend (irrespective of the state)	oldest_backend_time_sec	Seconds	Maximum	ServerName	PT1M	Yes
Oldest xmin The actual value of the oldest xmin.	oldest_backend_xmin	Count	Maximum	ServerName	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	ServerName	PT1M	Yes
Sessions by State Overall state of the backends	sessions_by_state	Count	Maximum, Minimum, Average	State, ServerName	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, ServerName	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, ServerName	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, ServerName	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, ServerName	PT30M, PT1H, PT6H, PT12H, P1D	Yes
Bloat Percent (Preview) Estimated bloat percentage for user only tables in this database	bloat_percent	Percent	Maximum	DatabaseName, ServerName	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, ServerName	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, ServerName	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, ServerName	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, ServerName	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, ServerName	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, ServerName	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, ServerName	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, ServerName	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, ServerName	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	ServerName	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, ServerName	PT1M	Yes
Disk Blocks Read Number of disk blocks read in this database	blks_read	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Database Size Total database size	database_size_bytes	Bytes	Average, Maximum, Minimum	DatabaseName, ServerName	PT30M, PT1H, PT6H, PT12H, P1D	Yes
Deadlocks Number of deadlocks detected in this database	deadlocks	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Backends Number of backends connected to this database	numbackends	Count	Maximum, Minimum, Average	DatabaseName, ServerName	PT1M	Yes
Temporary Files Size Total amount of data written to temporary files by queries in this database	temp_bytes	Bytes	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Temporary Files Number of temporary files created by queries in this database	temp_files	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Transactions per second (Preview) Number of transactions executed within a second	tps	Count	Minimum, Maximum, Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Tuples Deleted Number of rows deleted by queries in this database	tup_deleted	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Tuples Fetched Number of rows fetched by queries in this database	tup_fetched	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Tuples Inserted Number of rows inserted by queries in this database	tup_inserted	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Tuples Returned Number of rows returned by queries in this database	tup_returned	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Tuples Updated Number of rows updated by queries in this database	tup_updated	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Transactions Committed Number of transactions in this database that have been committed	xact_commit	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Transactions Rolled Back Number of transactions in this database that have been rolled back	xact_rollback	Count	Total (Sum)	DatabaseName, ServerName	PT1M	Yes
Total Transactions Number of total transactions executed in this database	xact_total	Count	Total (Sum)	DatabaseName, ServerName	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)	ServerName	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	ServerName	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, ServerName	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, ServerName	PT1M	Yes
Number of connection pools Total number of connection pools	num_pools	Count	Maximum, Minimum, Average	DatabaseName, ServerName	PT1M	Yes
Active server connections Connections to PostgreSQL that are in use by a client connection	server_connections_active	Count	Maximum, Minimum, Average	DatabaseName, ServerName	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, ServerName	PT1M	Yes
Total pooled connections Current number of pooled connections	total_pooled_connections	Count	Maximum, Minimum, Average	DatabaseName, ServerName	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	ServerName	PT1M	Yes
Read Replica Lag Read Replica lag in seconds	physical_replication_delay_in_seconds	Seconds	Maximum, Minimum, Average	ServerName	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	LogicalServerName	PT1M	Yes
CPU Credits Consumed Total number of credits consumed by the database server	cpu_credits_consumed	Count	Average, Maximum, Minimum	LogicalServerName	PT1M	Yes
CPU Credits Remaining Total number of credits available to burst	cpu_credits_remaining	Count	Average, Maximum, Minimum	LogicalServerName	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	LogicalServerName	PT1M	Yes
Disk IOPS Consumed Percentage Percentage of disk I/Os consumed per minute	disk_iops_consumed_percentage	Percent	Average, Maximum, Minimum	LogicalServerName	PT1M	Yes
Disk Queue Depth Number of outstanding I/O operations to the data disk	disk_queue_depth	Count	Average, Maximum, Minimum	LogicalServerName	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	LogicalServerName	PT1M	Yes
Postmaster Process cpu usage CPU usage 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	LogicalServerName	PT1M	Yes
Read Throughput Bytes/Sec Bytes read per second from the data disk during monitoring period	read_throughput	Count	Average, Maximum, Minimum	LogicalServerName	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	ServerName	PT1M	Yes
Write IOPS Number of data disk I/O write operations per second	write_iops	Count	Average, Maximum, Minimum	LogicalServerName	PT1M	Yes
Write Throughput Bytes/Sec Bytes written per second to the data disk during monitoring period	write_throughput	Count	Average, Maximum, Minimum	LogicalServerName	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	ServerName	PT1M	Yes
Succeeded Connections Succeeded Connections	connections_succeeded	Count	Total (Sum)	ServerName	PT1M	Yes
Max Connections Max connections	max_connections	Count	Maximum	ServerName	PT30M, PT1H, PT6H, PT12H, P1D	Yes
Maximum Used Transaction IDs Maximum Used Transaction IDs	maximum_used_transactionIDs	Count	Average, Maximum, Minimum	ServerName	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 Number of pending TCP connections waiting to be processed by the server. Applicable for 8vcore and above	tcp_connection_backlog	Count	Maximum, Minimum, Average	<none>	PT1M	No

Next steps

• Read about metrics in Azure Monitor
• Metrics export using data collection rules
• Create alerts on metrics
• Export metrics to storage, Event Hub, or Log Analytics