Azure Database for PostgreSQL - Flexible Server is a fully managed PostgreSQL database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability. Develop applications with Azure Database for PostgreSQL leveraging the open-source tools and platform of your choice.
Use OpsRamp Azure Public Cloud Integration to discover and collect metrics against Azure PostgreSQL Flexible Server.
Setup
To set up the Azure integration and discover the PostgreSQL Flexible Server resources, do the following:
Create an Azure Integration if not available in your installed integrations. For more information on how to install the Azure Integration, refer to Azure Resources.
Create a discovery profile. For more information on how to create a discovery profile, refer to Create Discovery Profile.
Select
PostgreSQL Flexible Serverunder the Filter Criteria in the Edit Discovery Profile page.Save the discovery profile to make them available in the list of Discovery Profiles.
Scan to discover the resources at any time independent of the predefined schedule.
Once the scan is completed, you can view the PostgreSQL Flexible Server resources under Infrastructure > Resources > Microsoft Azure category.
Create a template with collector type Azure and applicable for PostgreSQL Flexible Server. See Create a Template for more information on how to create a template.
Refer to Assign a Template on how to assign a template to a resource.
Click the Metrics tab to view the monitoring data of PostgreSQL Flexible Server as shown below:
Event support
OpsRamp supports Azure events for Azure PostgreSQL Flexible Server. Configure Azure Events in OpsRamp Azure integration discovery profile.
See Process Azure Events for more information on how to configure Azure events.
Supported metrics
| OpsRamp Metric | Azure Metric | Metric Display Name | Unit | Description | Aggregation Type |
|---|---|---|---|---|---|
| azure_dbforpostgresql_flexibleservers_active_connections | active_connections | Active Connections | Count | Active connections which are associated with a PostgreSQL. | Average |
| azure_dbforpostgresql_flexibleservers_backup_storage_used | backup_storage_used | Backup Storage Used | Bytes | Shows the amount of backup storage is used. | Average |
| azure_dbforpostgresql_flexibleservers_connections_failed | connections_failed | Failed Connections | Count | Shows the number of failed connections. | Total |
| azure_dbforpostgresql_flexibleservers_connections_succeeded | connections_succeeded | Succeeded Connections | Count | Shows the number of succeeded connections. | Total |
| azure_dbforpostgresql_flexibleservers_cpu_credits_consumed | cpu_credits_consumed | CPU Credits Consumed | Count | Total number of credits consumed by the database server. | Average |
| azure_dbforpostgresql_flexibleservers_cpu_credits_remaining | cpu_credits_remaining | CPU Credits Remaining | Count | Total number of credits available to burst. | Average |
| azure_dbforpostgresql_flexibleservers_cpu_percent | cpu_percent | CPU percent | Present | Shows the CPU percentage. | Average |
| azure_dbforpostgresql_flexibleservers_disk_queue_depth | disk_queue_depth | Disk Queue Depth | Count | Number of outstanding I/O operations to the data disk. | Average |
| azure_dbforpostgresql_flexibleservers_iops | iops | IOPS | Count | Shows the IO operations per second. | Average |
| azure_dbforpostgresql_flexibleservers_maximum_used_transactionIDs | maximum_used_transactionIDs | Maximum Used Transaction IDs | Count | Shows the maximum uised transaction IDs. | Average |
| azure_dbforpostgresql_flexibleservers_memory_percent | memory_percent | Memory percent | Percent | Shows the memory percentage. | Average |
| azure_dbforpostgresql_flexibleservers_network_bytes_egress | network_bytes_egress | Network Out | Bytes | Network out across active connections. | Total |
| azure_dbforpostgresql_flexibleservers_network_bytes_ingress | network_bytes_ingress | Network In | Bytes | Network in across active connections. | Total |
| azure_dbforpostgresql_flexibleservers_read_iops | read_iops | Read IOPS | Count | Number of data disk I/O read operations per second. | Average |
| azure_dbforpostgresql_flexibleservers_read_throughput | read_throughput | Read Throughput Bytes/Sec | Count | Bytes read per second from the data disk during monitoring period. | Average |
| azure_dbforpostgresql_flexibleservers_storage_free | storage_free | Storage Free | Bytes | Shows the amount free storage is left. | Average |
| azure_dbforpostgresql_flexibleservers_storage_percent | storage_percent | Storage percent | Percent | Shows the storage percentage. | Average |
| azure_dbforpostgresql_flexibleservers_storage_used | storage_used | Storage used | Bytes | Shows the used storage data. | Average |
| azure_dbforpostgresql_flexibleservers_txlogs_storage_used | txlogs_storage_used | Transaction Log Storage Used | Bytes | Shows the used transaction log storage. | Average |
| azure_dbforpostgresql_flexibleservers_write_iops | write_iops | Write IOPS | Count | Number of data disk I/O write operations per second. | Average |
| azure_dbforpostgresql_flexibleservers_write_throughput | write_throughput | Write Throughput Bytes/Sec | Bytes | Bytes written per second to the data disk during monitoring period. | Average |
| azure_dbforpostgresql_flexibleservers_is_db_alive | is_db_alive | Database Is Alive | Count | Indicates if the database is up and running or not. | Average |
| azure_dbforpostgresql_flexibleservers_analyze_count_user_tables | analyze_count_user_tables | Analyze Counter User Tables | Count | Number of times user only tables have been manually analyzed in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_autovacuum_count_user_tables | autovacuum_count_user_tables | AutoVacuum Counter User Tables | Count | Number of times user only tables have been vacuumed by the autovacuum daemon in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_blks_hit | blks_hit | Disk Blocks Hit | Count | Number of times disk blocks were found already in the buffer cache, so that a read was not necessary. | Total |
| azure_dbforpostgresql_flexibleservers_blks_read | blks_read | Disk Blocks Read | Count | Number of disk blocks read in this database. | Total |
| azure_dbforpostgresql_flexibleservers_bloat_percent | bloat_percent | Bloat Percent | Percent | Estimated bloat percentage for user only tables in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_client_connections_active | client_connections_active | Active client connections | Count | Connections from clients which are associated with a PostgreSQL connection. | Maximum |
| azure_dbforpostgresql_flexibleservers_client_connections_waiting | client_connections_waiting | Waiting client connections | Count | Connections from clients that are waiting for a PostgreSQL connection to service them. | Maximum |
| azure_dbforpostgresql_flexibleservers_deadlocks | deadlocks | Deadlocks | Count | Number of deadlocks detected in this database. | Total |
| azure_dbforpostgresql_flexibleservers_disk_bandwidth_consumed_percentage | disk_bandwidth_consumed_percentage | Disk Bandwidth Consumed Percentage | Percent | Percentage of disk bandwidth consumed per minute. | Average |
| azure_dbforpostgresql_flexibleservers_disk_iops_consumed_percentage | disk_iops_consumed_percentage | Disk IOPS Consumed Percentage | Percent | Percentage of disk I/Os consumed per minute. | Average |
| azure_dbforpostgresql_flexibleservers_logical_replication_delay_in_bytes | logical_replication_delay_in_bytes | Max Logical Replication Lag | Bytes | Maximum lag across all logical replication slots. | Maximum |
| azure_dbforpostgresql_flexibleservers_longest_query_time_sec | longest_query_time_sec | Oldest Query | Seconds | The age in seconds of the longest query that is currently running. | Maximum |
| azure_dbforpostgresql_flexibleservers_longest_transaction_time_sec | longest_transaction_time_sec | Oldest Transaction | Seconds | The age in seconds of the longest transaction (including idle transactions). | Maximum |
| azure_dbforpostgresql_flexibleservers_n_dead_tup_user_tables | n_dead_tup_user_tables | Estimated Dead Rows User Tables | Count | Estimated number of dead rows for user only tables in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_n_live_tup_user_tables | n_live_tup_user_tables | Estimated Live Rows User Tables | Count | Estimated number of live rows for user only tables in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_n_mod_since_analyze_user_tables | n_mod_since_analyze_user_tables | Estimated Modifications User Tables | Count | Maximum Estimated number of rows modified since user only tables were last analyzed. | Maximum |
| azure_dbforpostgresql_flexibleservers_num_pools | num_pools | Number of connection pools | Count | Total number of connection pools. | Maximum |
| azure_dbforpostgresql_flexibleservers_numbackends | numbackends | Backends | Count | Number of backends connected to this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_oldest_backend_time_sec | oldest_backend_time_sec | Oldest Backend | Seconds | The age in seconds of the oldest backend (irrespective of the state). | Maximum |
| azure_dbforpostgresql_flexibleservers_oldest_backend_xmin | oldest_backend_xmin | Oldest xmin | Count | The actual value of the oldest xmin. | Maximum |
| azure_dbforpostgresql_flexibleservers_oldest_backend_xmin_age | oldest_backend_xmin_age | Oldest xmin Age | Count | Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin. | Maximum |
| azure_dbforpostgresql_flexibleservers_physical_replication_delay_in_bytes | physical_replication_delay_in_bytes | Max Physical Replication Lag | Bytes | Maximum lag across all asynchronous physical replication slots. | Maximum |
| azure_dbforpostgresql_flexibleservers_physical_replication_delay_in_seconds | physical_replication_delay_in_seconds | Read Replica Lag | Seconds | Lag across all asynchronous physical replication slots in seconds. | Maximum |
| azure_dbforpostgresql_flexibleservers_server_connections_activey | server_connections_active | Active server connections | Count | Connections to PostgreSQL that are in use by a client connection. | Maximum |
| azure_dbforpostgresql_flexibleservers_server_connections_idle | server_connections_idle | Idle server connections | Count | Connections to PostgreSQL that are idle, ready to service a new client connection. | Maximum |
| azure_dbforpostgresql_flexibleservers_sessions_by_state | sessions_by_state | Sessions by State | Count | Overall state of the backends. | Maximum |
| azure_dbforpostgresql_flexibleservers_sessions_by_wait_event_type | sessions_by_wait_event_type | Sessions by WaitEventType | Count | Sessions by the type of event for which the backend is waiting. | Maximum |
| azure_dbforpostgresql_flexibleservers_tables_analyzed_user_tables | tables_analyzed_user_tables | User Tables Analyzed | Count | Number of user only tables that have been analyzed in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_tables_autoanalyzed_user_tables | tables_autoanalyzed_user_tables | User Tables AutoAnalyzed | Count | Number of user only tables that have been analyzed by the autovacuum daemon in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_tables_autovacuumed_user_tables | tables_autovacuumed_user_tables | User Tables AutoVacuumed | Count | Number of user only tables that have been vacuumed by the autovacuum daemon in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_tables_counter_user_tables | tables_counter_user_tables | User Tables Counter | Count | Number of user only tables in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_tables_vacuumed_user_tables | tables_vacuumed_user_tables | User Tables Vacuumed | Count | Number of user only tables that have been vacuumed in this database. | Maximum |
| azure_dbforpostgresql_flexibleservers_temp_bytes | temp_bytes | Temporary Files Size | Bytes | Total amount of data written to temporary files by queries in this database. | Total |
| azure_dbforpostgresql_flexibleservers_temp_files | temp_files | Temporary Files | Count | Number of temporary files created by queries in this database. | Total |
| azure_dbforpostgresql_flexibleservers_total_pooled_connections | total_pooled_connections | Total pooled connections | Count | Current number of pooled connections. | Maximum |
| azure_dbforpostgresql_flexibleservers_tps | tps | Transactions per second | Count | Number of transactions executed within a second. | Maximum |
| azure_dbforpostgresql_flexibleservers_tup_deleted | tup_deleted | Tuples Deleted | Count | Number of rows deleted by queries in this database. | Total |
| azure_dbforpostgresql_flexibleservers_tup_fetched | tup_fetched | Tuples Fetched | Count | Number of rows fetched by queries in this database. | Total |
| azure_dbforpostgresql_flexibleservers_tup_inserted | tup_inserted | Tuples Inserted | Count | Number of rows inserted by queries in this database. | Total |
| azure_dbforpostgresql_flexibleservers_tup_returned | tup_returned | Tuples Returned | Count | Number of rows returned by queries in this database. | Total |
| azure_dbforpostgresql_flexibleservers_tup_updated | tup_updated | Tuples Updated | Count | Number of rows updated by queries in this database. | Total |
| azure_dbforpostgresql_flexibleservers_vacuum_count_user_tables | vacuum_count_user_tables | Vacuum Counter User Tables | Count | Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL). | Maximum |
| azure_dbforpostgresql_flexibleservers_xact_commit | xact_commit | Transactions Committed | Count | Number of transactions in this database that have been committed. | Total |
| azure_dbforpostgresql_flexibleservers_xact_rollback | xact_rollback | Transactions Rolled Back | Count | Number of transactions in this database that have been rolled back. | Total |
| azure_dbforpostgresql_flexibleservers_xact_total | xact_total | Total Transactions | Count | Number of total transactions executed in this database. | Total |
| azure_dbforpostgresql_flexibleservers_max_connections | max_connections | Max Connections | Count | Shows you the maximum number of connections. | Maximum |