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:

  1. 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.

  2. Create a discovery profile. For more information on how to create a discovery profile, refer to Create Discovery Profile.

  3. Select PostgreSQL Flexible Server under the Filter Criteria in the Edit Discovery Profile page.

  4. Save the discovery profile to make them available in the list of Discovery Profiles.

  5. Scan to discover the resources at any time independent of the predefined schedule.

  6. Once the scan is completed, you can view the PostgreSQL Flexible Server resources under Infrastructure > Resources > Microsoft Azure category.

  7. 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.

  8. Refer to Assign a Template on how to assign a template to a resource.

  9. 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

x
OpsRamp MetricAzure MetricMetric Display NameUnitDescriptionAggregation Type
azure_dbforpostgresql_flexibleservers_active_connectionsactive_connectionsActive ConnectionsCountActive connections which are associated with a PostgreSQL.Average
azure_dbforpostgresql_flexibleservers_backup_storage_usedbackup_storage_usedBackup Storage UsedBytesShows the amount of backup storage is used.Average
azure_dbforpostgresql_flexibleservers_connections_failedconnections_failedFailed ConnectionsCountShows the number of failed connections.Total
azure_dbforpostgresql_flexibleservers_connections_succeededconnections_succeededSucceeded ConnectionsCountShows the number of succeeded connections.Total
azure_dbforpostgresql_flexibleservers_cpu_credits_consumedcpu_credits_consumedCPU Credits ConsumedCountTotal number of credits consumed by the database server.Average
azure_dbforpostgresql_flexibleservers_cpu_credits_remainingcpu_credits_remainingCPU Credits RemainingCountTotal number of credits available to burst.Average
azure_dbforpostgresql_flexibleservers_cpu_percentcpu_percentCPU percentPresentShows the CPU percentage.Average
azure_dbforpostgresql_flexibleservers_disk_queue_depthdisk_queue_depthDisk Queue DepthCountNumber of outstanding I/O operations to the data disk.Average
azure_dbforpostgresql_flexibleservers_iopsiopsIOPSCountShows the IO operations per second.Average
azure_dbforpostgresql_flexibleservers_maximum_used_transactionIDsmaximum_used_transactionIDsMaximum Used Transaction IDsCountShows the maximum uised transaction IDs.Average
azure_dbforpostgresql_flexibleservers_memory_percentmemory_percentMemory percentPercentShows the memory percentage.Average
azure_dbforpostgresql_flexibleservers_network_bytes_egressnetwork_bytes_egressNetwork OutBytesNetwork out across active connections.Total
azure_dbforpostgresql_flexibleservers_network_bytes_ingressnetwork_bytes_ingressNetwork InBytesNetwork in across active connections.Total
azure_dbforpostgresql_flexibleservers_read_iopsread_iopsRead IOPSCountNumber of data disk I/O read operations per second.Average
azure_dbforpostgresql_flexibleservers_read_throughputread_throughputRead Throughput Bytes/SecCountBytes read per second from the data disk during monitoring period.Average
azure_dbforpostgresql_flexibleservers_storage_freestorage_freeStorage FreeBytesShows the amount free storage is left.Average
azure_dbforpostgresql_flexibleservers_storage_percentstorage_percentStorage percentPercentShows the storage percentage.Average
azure_dbforpostgresql_flexibleservers_storage_usedstorage_usedStorage usedBytesShows the used storage data.Average
azure_dbforpostgresql_flexibleservers_txlogs_storage_usedtxlogs_storage_usedTransaction Log Storage UsedBytesShows the used transaction log storage.Average
azure_dbforpostgresql_flexibleservers_write_iopswrite_iopsWrite IOPSCountNumber of data disk I/O write operations per second.Average
azure_dbforpostgresql_flexibleservers_write_throughputwrite_throughputWrite Throughput Bytes/SecBytesBytes written per second to the data disk during monitoring period.Average
azure_dbforpostgresql_flexibleservers_is_db_aliveis_db_aliveDatabase Is AliveCountIndicates if the database is up and running or not.Average
azure_dbforpostgresql_flexibleservers_analyze_count_user_tablesanalyze_count_user_tablesAnalyze Counter User TablesCountNumber of times user only tables have been manually analyzed in this database.Maximum
azure_dbforpostgresql_flexibleservers_autovacuum_count_user_tablesautovacuum_count_user_tablesAutoVacuum Counter User TablesCountNumber of times user only tables have been vacuumed by the autovacuum daemon in this database.Maximum
azure_dbforpostgresql_flexibleservers_blks_hitblks_hitDisk Blocks HitCountNumber of times disk blocks were found already in the buffer cache, so that a read was not necessary.Total
azure_dbforpostgresql_flexibleservers_blks_readblks_readDisk Blocks ReadCountNumber of disk blocks read in this database.Total
azure_dbforpostgresql_flexibleservers_bloat_percentbloat_percentBloat PercentPercentEstimated bloat percentage for user only tables in this database.Maximum
azure_dbforpostgresql_flexibleservers_client_connections_activeclient_connections_activeActive client connectionsCountConnections from clients which are associated with a PostgreSQL connection.Maximum
azure_dbforpostgresql_flexibleservers_client_connections_waitingclient_connections_waitingWaiting client connectionsCountConnections from clients that are waiting for a PostgreSQL connection to service them.Maximum
azure_dbforpostgresql_flexibleservers_deadlocksdeadlocksDeadlocksCountNumber of deadlocks detected in this database.Total
azure_dbforpostgresql_flexibleservers_disk_bandwidth_consumed_percentagedisk_bandwidth_consumed_percentageDisk Bandwidth Consumed PercentagePercentPercentage of disk bandwidth consumed per minute.Average
azure_dbforpostgresql_flexibleservers_disk_iops_consumed_percentagedisk_iops_consumed_percentageDisk IOPS Consumed PercentagePercentPercentage of disk I/Os consumed per minute.Average
azure_dbforpostgresql_flexibleservers_logical_replication_delay_in_byteslogical_replication_delay_in_bytesMax Logical Replication LagBytesMaximum lag across all logical replication slots.Maximum
azure_dbforpostgresql_flexibleservers_longest_query_time_seclongest_query_time_secOldest QuerySecondsThe age in seconds of the longest query that is currently running.Maximum
azure_dbforpostgresql_flexibleservers_longest_transaction_time_seclongest_transaction_time_secOldest TransactionSecondsThe age in seconds of the longest transaction (including idle transactions).Maximum
azure_dbforpostgresql_flexibleservers_n_dead_tup_user_tablesn_dead_tup_user_tablesEstimated Dead Rows User TablesCountEstimated number of dead rows for user only tables in this database.Maximum
azure_dbforpostgresql_flexibleservers_n_live_tup_user_tablesn_live_tup_user_tablesEstimated Live Rows User TablesCountEstimated number of live rows for user only tables in this database.Maximum
azure_dbforpostgresql_flexibleservers_n_mod_since_analyze_user_tablesn_mod_since_analyze_user_tablesEstimated Modifications User TablesCountMaximum Estimated number of rows modified since user only tables were last analyzed.Maximum
azure_dbforpostgresql_flexibleservers_num_poolsnum_poolsNumber of connection poolsCountTotal number of connection pools.Maximum
azure_dbforpostgresql_flexibleservers_numbackendsnumbackendsBackendsCountNumber of backends connected to this database.Maximum
azure_dbforpostgresql_flexibleservers_oldest_backend_time_secoldest_backend_time_secOldest BackendSecondsThe age in seconds of the oldest backend (irrespective of the state).Maximum
azure_dbforpostgresql_flexibleservers_oldest_backend_xminoldest_backend_xminOldest xminCountThe actual value of the oldest xmin.Maximum
azure_dbforpostgresql_flexibleservers_oldest_backend_xmin_ageoldest_backend_xmin_ageOldest xmin AgeCountAge in units of the oldest xmin. It indicated how many transactions passed since oldest xmin.Maximum
azure_dbforpostgresql_flexibleservers_physical_replication_delay_in_bytesphysical_replication_delay_in_bytesMax Physical Replication LagBytesMaximum lag across all asynchronous physical replication slots.Maximum
azure_dbforpostgresql_flexibleservers_physical_replication_delay_in_secondsphysical_replication_delay_in_secondsRead Replica LagSecondsLag across all asynchronous physical replication slots in seconds.Maximum
azure_dbforpostgresql_flexibleservers_server_connections_activeyserver_connections_activeActive server connectionsCountConnections to PostgreSQL that are in use by a client connection.Maximum
azure_dbforpostgresql_flexibleservers_server_connections_idleserver_connections_idleIdle server connectionsCountConnections to PostgreSQL that are idle, ready to service a new client connection.Maximum
azure_dbforpostgresql_flexibleservers_sessions_by_statesessions_by_stateSessions by StateCountOverall state of the backends.Maximum
azure_dbforpostgresql_flexibleservers_sessions_by_wait_event_typesessions_by_wait_event_typeSessions by WaitEventTypeCountSessions by the type of event for which the backend is waiting.Maximum
azure_dbforpostgresql_flexibleservers_tables_analyzed_user_tablestables_analyzed_user_tablesUser Tables AnalyzedCountNumber of user only tables that have been analyzed in this database.Maximum
azure_dbforpostgresql_flexibleservers_tables_autoanalyzed_user_tablestables_autoanalyzed_user_tablesUser Tables AutoAnalyzedCountNumber of user only tables that have been analyzed by the autovacuum daemon in this database.Maximum
azure_dbforpostgresql_flexibleservers_tables_autovacuumed_user_tablestables_autovacuumed_user_tablesUser Tables AutoVacuumedCountNumber of user only tables that have been vacuumed by the autovacuum daemon in this database.Maximum
azure_dbforpostgresql_flexibleservers_tables_counter_user_tablestables_counter_user_tablesUser Tables CounterCountNumber of user only tables in this database.Maximum
azure_dbforpostgresql_flexibleservers_tables_vacuumed_user_tablestables_vacuumed_user_tablesUser Tables VacuumedCountNumber of user only tables that have been vacuumed in this database.Maximum
azure_dbforpostgresql_flexibleservers_temp_bytestemp_bytesTemporary Files SizeBytesTotal amount of data written to temporary files by queries in this database.Total
azure_dbforpostgresql_flexibleservers_temp_filestemp_filesTemporary FilesCountNumber of temporary files created by queries in this database.Total
azure_dbforpostgresql_flexibleservers_total_pooled_connectionstotal_pooled_connectionsTotal pooled connectionsCountCurrent number of pooled connections.Maximum
azure_dbforpostgresql_flexibleservers_tpstpsTransactions per secondCountNumber of transactions executed within a second.Maximum
azure_dbforpostgresql_flexibleservers_tup_deletedtup_deletedTuples DeletedCountNumber of rows deleted by queries in this database.Total
azure_dbforpostgresql_flexibleservers_tup_fetchedtup_fetchedTuples FetchedCountNumber of rows fetched by queries in this database.Total
azure_dbforpostgresql_flexibleservers_tup_insertedtup_insertedTuples InsertedCountNumber of rows inserted by queries in this database.Total
azure_dbforpostgresql_flexibleservers_tup_returnedtup_returnedTuples ReturnedCountNumber of rows returned by queries in this database.Total
azure_dbforpostgresql_flexibleservers_tup_updatedtup_updatedTuples UpdatedCountNumber of rows updated by queries in this database.Total
azure_dbforpostgresql_flexibleservers_vacuum_count_user_tablesvacuum_count_user_tablesVacuum Counter User TablesCountNumber of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL).Maximum
azure_dbforpostgresql_flexibleservers_xact_commitxact_commitTransactions CommittedCountNumber of transactions in this database that have been committed.Total
azure_dbforpostgresql_flexibleservers_xact_rollbackxact_rollbackTransactions Rolled BackCountNumber of transactions in this database that have been rolled back.Total
azure_dbforpostgresql_flexibleservers_xact_totalxact_totalTotal TransactionsCountNumber of total transactions executed in this database.Total
azure_dbforpostgresql_flexibleservers_max_connectionsmax_connectionsMax ConnectionsCountShows you the maximum number of connections.Maximum

External reference

Azure PostgreSQL Flexible Server