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	DatabaseName	PT1M	Yes
Database	Disk Blocks Read Number of disk blocks read in this database	blks_read	Count	Total	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	<none>	PT1M	Yes
Traffic	Succeeded Connections Succeeded Connections	connections_succeeded	Count	Total	<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 (Preview) 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	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	<none>	PT1M	Yes
Traffic	Network In Network In across active connections	network_bytes_ingress	Bytes	Total	<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	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
Database	Temporary Files Size Total amount of data written to temporary files by queries in this database	temp_bytes	Bytes	Total	DatabaseName	PT1M	Yes
Database	Temporary Files Number of temporary files created by queries in this database	temp_files	Count	Total	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	DatabaseName	PT1M	Yes
Database	Tuples Deleted Number of rows deleted by queries in this database	tup_deleted	Count	Total	DatabaseName	PT1M	Yes
Database	Tuples Fetched Number of rows fetched by queries in this database	tup_fetched	Count	Total	DatabaseName	PT1M	Yes
Database	Tuples Inserted Number of rows inserted by queries in this database	tup_inserted	Count	Total	DatabaseName	PT1M	Yes
Database	Tuples Returned Number of rows returned by queries in this database	tup_returned	Count	Total	DatabaseName	PT1M	Yes
Database	Tuples Updated Number of rows updated by queries in this database	tup_updated	Count	Total	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	DatabaseName	PT1M	Yes
Database	Transactions Rolled Back Number of transactions in this database that have been rolled back	xact_rollback	Count	Total	DatabaseName	PT1M	Yes
Database	Total Transactions Number of total transactions executed in this database	xact_total	Count	Total	DatabaseName	PT1M	Yes