PostgreSQL Flexible Server metrics
Azure PostgreSQL Flexible Server is a fully managed database service designed to provide more granular control and flexibility over database management functions and configuration settings. Use the Azure Resource Manager to gather metrics for this resource, then ensure your cloud platform is configured in SolarWinds Observability SaaS to collect this resource type's data. See Add an Azure cloud account.
Depending on the subscription pricing tier of your Azure account or its resources, additional metrics may be available for this entity. To collect additional Azure metrics, select the premium pricing tier when configuring your Azure namespaces.
Many of the collected metrics from PostgreSQL Flexible Server entities are displayed as widgets in SolarWinds Observability explorers; additional metrics may be collected and available in the Metrics Explorer. You can also create an alert for when an entity's metric value moves out of a specific range. See Entities in SolarWinds Observability SaaS for information about entity types in SolarWinds Observability SaaS.
The following table lists azure.postgresql.flexible in the search box.
| Metric | Units | Description |
|---|---|---|
sw.metrics.healthscore | Percent (%) | Health score. A health score provides real-time insight into the overall health and performance of your monitored entities. The health score is calculated based on anomalies detected for the entity, alerts triggered for the entity's metrics, and the status of the entity. The health score is displayed as a single numerical value that ranges from a Good (70-100) to Moderate (40-69) to Bad (0-39) distinction. To view the health score for PostgreSQL Flexible Server entities in the Metrics Explorer, filter the |
azure.postgresql.flexible.active_connections | Count | Active Connections. |
azure.postgresql.flexible.backup_storage_used | bytes | Backup Storage Used. |
azure.postgresql.flexible.client_connections_active | Count | Connections from clients which are associated with a PostgreSQL connection. |
azure.postgresql.flexible.connections_failed | Count | Failed Connections. |
azure.postgresql.flexible.connections_succeeded | Count | Succeeded Connections. |
azure.postgresql.flexible.cpu_percent | Percent (%) | CPU percent. |
azure.postgresql.flexible.cpu_credits_consumed | Count | Total number of credits consumed by the database server. |
azure.postgresql.flexible.disk_queue_depth | Count | Number of outstanding I/O operations to the data disk. |
azure.postgresql.flexible.iops | Count | IO Operations per second. |
azure.postgresql.flexible.is_db_alive | Count | Indicates if the database is up or not. |
azure.postgresql.flexible.memory_percent | Percent (%) | Memory percent. |
azure.postgresql.flexible.maximum_used_transactionIDs | Count | Maximum Used Transaction IDs. |
azure.postgresql.flexible.network_bytes_egress | bytes | Network Out across active connections. |
azure.postgresql.flexible.network_bytes_ingress | bytes | Network In across active connections. |
azure.postgresql.flexible.read_iops | Count | Number of data disk I/O read operations per second. |
azure.postgresql.flexible.read_throughput | Count | bytes read per second from the data disk during monitoring period. |
azure.postgresql.flexible.server_connections_active | Count | Connections to PostgreSQL that are in use by a client connection. |
azure.postgresql.flexible.storage_free | bytes | Storage Free. |
azure.postgresql.flexible.storage_percent | Percent (%) | Storage percent. |
azure.postgresql.flexible.storage_used | bytes | Storage used. |
azure.postgresql.flexible.write_iops | Count | Number of data disk I/O write operations per second. |
azure.postgresql.flexible.write_throughput | Count | bytes written per second to the data disk during monitoring period. |
azure.postgresql.flexible.xact_total | Count | Number of total transactions executed in this database. |
azure.postgresql.flexible.analyze_count_user_tables | Count | Number of times user only tables have been manually analyzed in this database. |
azure.postgresql.flexible.autoanalyze_count_user_tables | Count | Number of times user only tables have been analyzed by the autovacuum daemon in this database. |
azure.postgresql.flexible.autovacuum_count_user_tables | Count | Number of times user only tables have been vacuumed by the autovacuum daemon in this database. |
azure.postgresql.flexible.blks_hit | Count | Number of times disk blocks were found already in the buffer cache, so that a read was not necessary. |
azure.postgresql.flexible.blks_read | Count | Number of disk blocks read in this database. |
azure.postgresql.flexible.bloat_percent | Percent (%) | Estimated bloat percentage for user only tables in this database. |
azure.postgresql.flexible.client_connections_waiting | Count | Connections from clients that are waiting for a PostgreSQL connection to service them. |
azure.postgresql.flexible.cpu_credits_remaining | Count | Total number of credits available to burst. |
azure.postgresql.flexible.deadlocks | Count | Number of deadlocks detected in this database. |
azure.postgresql.flexible.disk_bandwidth_consumed_percentage | Percent (%) | Percentage of disk bandwidth consumed per minute. |
azure.postgresql.flexible.disk_iops_consumed_percentage | Percent (%) | Percentage of disk I/Os consumed per minute. |
azure.postgresql.flexible.logical_replication_delay_in_bytes | bytes | Maximum lag across all logical replication slots. |
azure.postgresql.flexible.longest_query_time_sec | seconds (s) | The age in seconds of the longest query that is currently running. |
azure.postgresql.flexible.longest_transaction_time_sec | seconds (s) | The age in seconds of the longest transaction (including idle transactions). |
azure.postgresql.flexible.max_connections | Count | Max connections. |
azure.postgresql.flexible.n_dead_tup_user_tables | Count | Estimated number of dead rows for user only tables in this database. |
azure.postgresql.flexible.n_live_tup_user_tables | Count | Estimated number of live rows for user only tables in this database. |
azure.postgresql.flexible.n_mod_since_analyze_user_tables | Count | Estimated number of rows modified since user only tables were last analyzed. |
azure.postgresql.flexible.num_pools | Count | Total number of connection pools. |
azure.postgresql.flexible.numbackends | Count | Number of backends connected to this database. |
azure.postgresql.flexible.oldest_backend_time_sec | seconds (s) | The age in seconds of the oldest backend (irrespective of the state). |
azure.postgresql.flexible.oldest_backend_xmin | Count | The actual value of the oldest xmin. |
azure.postgresql.flexible.oldest_backend_xmin_age | Count | Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin. |
azure.postgresql.flexible.physical_replication_delay_in_bytes | bytes | Maximum lag across all asynchronous physical replication slots. |
azure.postgresql.flexible.physical_replication_delay_in_seconds | seconds (s) | Read Replica lag in seconds. |
azure.postgresql.flexible.server_connections_idle | Count | Connections to PostgreSQL that are idle, ready to service a new client connection. |
azure.postgresql.flexible.sessions_by_state | Count | Overall state of the backends. |
azure.postgresql.flexible.sessions_by_wait_event_type | Count | Sessions by the type of event for which the backend is waiting. |
azure.postgresql.flexible.tables_analyzed_user_tables | Count | Number of user only tables that have been analyzed in this database. |
azure.postgresql.flexible.tables_autoanalyzed_user_tables | Count | Number of user only tables that have been analyzed by the autovacuum daemon in this database. |
azure.postgresql.flexible.tables_autovacuumed_user_tables | Count | Number of user only tables that have been vacuumed by the autovacuum daemon in this database. |
azure.postgresql.flexible.tables_counter_user_tables | Count | Number of user only tables in this database. |
azure.postgresql.flexible.tables_vacuumed_user_tables | Count | Number of user only tables that have been vacuumed in this database. |
azure.postgresql.flexible.temp_bytes | bytes | Total amount of data written to temporary files by queries in this database. |
azure.postgresql.flexible.temp_files | Count | Number of temporary files created by queries in this database. |
azure.postgresql.flexible.total_pooled_connections | Count | Current number of pooled connections. |
azure.postgresql.flexible.tps | Count | Number of transactions executed within a second. |
azure.postgresql.flexible.tup_deleted | Count | Number of rows deleted by queries in this database. |
azure.postgresql.flexible.tup_fetched | Count | Number of rows fetched by queries in this database. |
azure.postgresql.flexible.tup_inserted | Count | Number of rows inserted by queries in this database. |
azure.postgresql.flexible.tup_returned | Count | Number of rows returned by queries in this database. |
azure.postgresql.flexible.tup_updated | Count | Number of rows updated by queries in this database. |
azure.postgresql.flexible.txlogs_storage_used | bytes | Transaction Log Storage Used. |
azure.postgresql.flexible.vacuum_count_user_tables | Count | Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL). |
azure.postgresql.flexible.xact_commit | Count | Number of transactions in this database that have been committed. |
azure.postgresql.flexible.xact_rollback | Count | Number of transactions in this database that have been rolled back. |