概要

Azure Database for PostgreSQL は、サービスとして、エンタープライズ対応のフルマネージド型コミュニティ PostgreSQL データベースを提供します。

Azure DB for PostgreSQL からメトリクスを取得すると、以下のことができます。

  • PostgreSQL データベースのパフォーマンスを視覚化できます。
  • PostgreSQL データベースのパフォーマンスをアプリケーションと関連付けることができます。

セットアップ

インストール

Microsoft Azure インテグレーションをまだセットアップしていない場合は、最初にセットアップします。これ以外に必要なインストール手順はありません。

収集データ

メトリクス

azure.dbforpostgresql_flexibleservers.active_connections
(gauge)
Active Connections
Shown as connection
azure.dbforpostgresql_flexibleservers.backup_storage_used
(gauge)
Backup Storage used
Shown as byte
azure.dbforpostgresql_flexibleservers.connections_failed
(count)
Failed Connections
Shown as connection
azure.dbforpostgresql_flexibleservers.core_count
(gauge)
Core count
azure.dbforpostgresql_flexibleservers.count
(gauge)
The count of Azure DB for PostgreSQL flexible servers resources
azure.dbforpostgresql_flexibleservers.cpu_credits_consumed
(gauge)
Number of CPU credits consumed by the database server
azure.dbforpostgresql_flexibleservers.cpu_credits_remaining
(gauge)
Number of CPU credits available to the database server
azure.dbforpostgresql_flexibleservers.cpu_percent
(gauge)
CPU percent
Shown as percent
azure.dbforpostgresql_flexibleservers.disk_queue_depth
(gauge)
Number of outstanding I/O operations to the disk
azure.dbforpostgresql_flexibleservers.iops
(count)
IO Operations per second
Shown as operation
azure.dbforpostgresql_flexibleservers.maximum_used_transactionids
(gauge)
Maximum used transaction IDs
azure.dbforpostgresql_flexibleservers.memory_percent
(gauge)
Memory percent
Shown as percent
azure.dbforpostgresql_flexibleservers.network_bytes_egress
(count)
Network Out across active connections
Shown as byte
azure.dbforpostgresql_flexibleservers.network_bytes_ingress
(count)
Network In across active connections
Shown as byte
azure.dbforpostgresql_flexibleservers.read_iops
(count)
Read IO Operations per second
Shown as operation
azure.dbforpostgresql_flexibleservers.read_throughput
(count)
Bytes read per second from the disk
Shown as byte
azure.dbforpostgresql_flexibleservers.storage_free
(gauge)
Storage free
Shown as byte
azure.dbforpostgresql_flexibleservers.storage_percent
(gauge)
Storage percent
Shown as percent
azure.dbforpostgresql_flexibleservers.storage_used
(gauge)
Storage used
Shown as byte
azure.dbforpostgresql_flexibleservers.txlogs_storage_used
(gauge)
Transaction log storage used
Shown as byte
azure.dbforpostgresql_flexibleservers.write_iops
(count)
Write IO Operations per second
Shown as operation
azure.dbforpostgresql_flexibleservers.write_throughput
(count)
Bytes written per second from the disk
Shown as byte
azure.dbforpostgresql_servergroups.count
(gauge)
The count of Azure DB for PostgreSQL server groups resources
azure.dbforpostgresql_servers.active_connections
(gauge)
Active Connections
Shown as connection
azure.dbforpostgresql_servers.backup_storage_used
(gauge)
Backup Storage used
Shown as byte
azure.dbforpostgresql_servers.connections_failed
(count)
Failed Connections
Shown as connection
azure.dbforpostgresql_servers.core_count
(gauge)
Core count
azure.dbforpostgresql_servers.count
(gauge)
The count of Azure DB for PostgreSQL resources
azure.dbforpostgresql_servers.cpu_percent
(gauge)
CPU percent
Shown as percent
azure.dbforpostgresql_servers.cpu_percent.max
(gauge)
Maximum CPU percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.io_consumption_percent
(gauge)
IO percent
Shown as percent
azure.dbforpostgresql_servers.io_consumption_percent.max
(gauge)
Maximum IO percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.memory_percent
(gauge)
Memory percent
Shown as percent
azure.dbforpostgresql_servers.memory_percent.max
(gauge)
Maximum Memory percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.network_bytes_egress
(count)
Network Out across active connections
Shown as byte
azure.dbforpostgresql_servers.network_bytes_ingress
(count)
Network In across active connections
Shown as byte
azure.dbforpostgresql_servers.pg_replica_log_delay_in_bytes
(gauge)
Lag in bytes of the most lagging replica
Shown as byte
azure.dbforpostgresql_servers.pg_replica_log_delay_in_seconds
(gauge)
Replica lag in seconds
Shown as second
azure.dbforpostgresql_servers.serverlog_storage_limit
(gauge)
Server Log storage limit
Shown as byte
azure.dbforpostgresql_servers.serverlog_storage_percent
(gauge)
Server Log storage percent
Shown as percent
azure.dbforpostgresql_servers.serverlog_storage_percent.max
(gauge)
Maximum Server Log storage percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.serverlog_storage_usage
(gauge)
Server Log storage used
Shown as byte
azure.dbforpostgresql_servers.storage_limit
(gauge)
Storage limit
Shown as byte
azure.dbforpostgresql_servers.storage_percent
(gauge)
Storage percent
Shown as percent
azure.dbforpostgresql_servers.storage_percent.max
(gauge)
Maximum Storage percent (Max Aggregated)
Shown as percent
azure.dbforpostgresql_servers.storage_used
(gauge)
Storage used
Shown as byte
azure.dbforpostgresql_serversv2.active_connections
(gauge)
Active Connections
Shown as connection
azure.dbforpostgresql_serversv2.count
(gauge)
The count of Azure DB for PostgreSQL resources
azure.dbforpostgresql_serversv2.cpu_percent
(gauge)
CPU percent
Shown as percent
azure.dbforpostgresql_serversv2.iops
(count)
IO Operations per second
Shown as operation
azure.dbforpostgresql_serversv2.memory_percent
(gauge)
Memory percent
Shown as percent
azure.dbforpostgresql_serversv2.network_bytes_egress
(count)
Network Out across active connections
Shown as byte
azure.dbforpostgresql_serversv2.network_bytes_ingress
(count)
Network In across active connections
Shown as byte
azure.dbforpostgresql_serversv2.storage_percent
(gauge)
Storage percent
Shown as percent
azure.dbforpostgresql_serversv2.storage_used
(gauge)
Storage used
Shown as byte
azure.dbforpostgresql_flexibleservers.longest_query_time_sec
(gauge)
Age in seconds of the longest query that is currently running.
Shown as second
azure.dbforpostgresql_flexibleservers.longest_transaction_time_sec
(gauge)
Age in seconds of the longest transaction (including idle transactions).
Shown as second
azure.dbforpostgresql_flexibleservers.oldest_backend_time_sec
(gauge)
Age in seconds of the oldest backend (irrespective of the state).
Shown as second
azure.dbforpostgresql_flexibleservers.oldest_backend_xmin
(gauge)
Actual value of the oldest xmin.
azure.dbforpostgresql_flexibleservers.oldest_backend_xmin_age
(gauge)
Age in units of the oldest xmin. It indicated how many transactions passed since oldest xmin.
azure.dbforpostgresql_flexibleservers.sessions_by_state
(gauge)
Overall state of the backends.
azure.dbforpostgresql_flexibleservers.sessions_by_wait_event_type
(gauge)
Sessions by the type of event for which the backend is waiting.
azure.dbforpostgresql_flexibleservers.analyze_count_user_tables
(gauge)
Number of times user only tables have been manually analyzed in this database.
azure.dbforpostgresql_flexibleservers.autoanalyze_count_user_tables
(gauge)
Number of times user only tables have been analyzed by the autovacuum daemon in this database.
azure.dbforpostgresql_flexibleservers.autovacuum_count_user_tables
(gauge)
Number of times user only tables have been vacuumed by the autovacuum daemon in this database.
azure.dbforpostgresql_flexibleservers.bloat_percent
(gauge)
Estimated bloat percentage for user only tables in this database.
Shown as percent
azure.dbforpostgresql_flexibleservers.n_dead_tup_user_tables
(gauge)
Estimated number of dead rows for user only tables in this database.
azure.dbforpostgresql_flexibleservers.n_live_tup_user_tables
(gauge)
Estimated number of live rows for user only tables in this database.
azure.dbforpostgresql_flexibleservers.n_mod_since_analyze_user_tables
(gauge)
Estimated number of rows modified since user only tables were last analyzed.
azure.dbforpostgresql_flexibleservers.tables_analyzed_user_tables
(gauge)
Number of user only tables that have been analyzed in this database.
azure.dbforpostgresql_flexibleservers.tables_autoanalyzed_user_tables
(gauge)
Number of user only tables that have been analyzed by the autovacuum daemon in this database.
azure.dbforpostgresql_flexibleservers.tables_autovacuumed_user_tables
(gauge)
Number of user only tables that have been vacuumed by the autovacuum daemon in this database.
azure.dbforpostgresql_flexibleservers.tables_counter_user_tables
(gauge)
Number of user only tables in this database.
azure.dbforpostgresql_flexibleservers.tables_vacuumed_user_tables
(gauge)
Number of user only tables that have been vacuumed in this database.
azure.dbforpostgresql_flexibleservers.vacuum_count_user_tables
(gauge)
Number of times user only tables have been manually vacuumed in this database (not counting VACUUM FULL).
azure.dbforpostgresql_flexibleservers.is_db_alive
(gauge)
Indicates if the database is up or not.
azure.dbforpostgresql_flexibleservers.blks_hit
(count)
Number of times disk blocks were found already in the buffer cache, so that a read was not necessary.
azure.dbforpostgresql_flexibleservers.blks_read
(count)
Number of disk blocks read in this database.
azure.dbforpostgresql_flexibleservers.database_size_bytes
(gauge)
Total database size.
Shown as byte
azure.dbforpostgresql_flexibleservers.deadlocks
(count)
Number of deadlocks detected in this database.
azure.dbforpostgresql_flexibleservers.numbackends
(gauge)
Number of backends connected to this database.
azure.dbforpostgresql_flexibleservers.temp_bytes
(count)
Total amount of data written to temporary files by queries in this database.
Shown as byte
azure.dbforpostgresql_flexibleservers.temp_files
(count)
Number of temporary files created by queries in this database.
azure.dbforpostgresql_flexibleservers.tps
(gauge)
Number of transactions executed within a second.
azure.dbforpostgresql_flexibleservers.tup_deleted
(count)
Number of rows deleted by queries in this database.
azure.dbforpostgresql_flexibleservers.tup_fetched
(count)
Number of rows fetched by queries in this database.
azure.dbforpostgresql_flexibleservers.tup_inserted
(count)
Number of rows inserted by queries in this database.
azure.dbforpostgresql_flexibleservers.tup_returned
(count)
Number of rows returned by queries in this database.
azure.dbforpostgresql_flexibleservers.tup_updated
(count)
Number of rows updated by queries in this database.
azure.dbforpostgresql_flexibleservers.xact_commit
(count)
Number of transactions in this database that have been committed.
azure.dbforpostgresql_flexibleservers.xact_rollback
(count)
Number of transactions in this database that have been rolled back.
azure.dbforpostgresql_flexibleservers.xact_total
(count)
Number of total transactions executed in this database.
azure.dbforpostgresql_flexibleservers.logical_replication_delay_in_bytes
(gauge)
Maximum lag across all logical replication slots.
Shown as byte
azure.dbforpostgresql_flexibleservers.client_connections_active
(gauge)
Connections from clients which are associated with a postgresql connection.
azure.dbforpostgresql_flexibleservers.client_connections_waiting
(gauge)
Connections from clients that are waiting for a postgresql connection to service them.
azure.dbforpostgresql_flexibleservers.num_pools
(gauge)
Total number of connection pools.
azure.dbforpostgresql_flexibleservers.server_connections_active
(gauge)
Connections to postgresql that are in use by a client connection.
azure.dbforpostgresql_flexibleservers.server_connections_idle
(gauge)
Connections to postgresql that are idle, ready to service a new client connection.
azure.dbforpostgresql_flexibleservers.total_pooled_connections
(gauge)
Current number of pooled connections.
azure.dbforpostgresql_flexibleservers.physical_replication_delay_in_bytes
(gauge)
Maximum lag across all asynchronous physical replication slots.
Shown as byte
azure.dbforpostgresql_flexibleservers.physical_replication_delay_in_seconds
(gauge)
Read replica lag in seconds.
Shown as second
azure.dbforpostgresql_flexibleservers.disk_bandwidth_consumed_percentage
(gauge)
Percentage of disk bandwidth consumed per minute.
Shown as percent
azure.dbforpostgresql_flexibleservers.disk_iops_consumed_percentage
(gauge)
Percentage of disk i/os consumed per minute.
Shown as percent
azure.dbforpostgresql_flexibleservers.platform_cpu_percent
(gauge)
CPU percent from platform.
Shown as percent
azure.dbforpostgresql_flexibleservers.postmaster_process_cpu_usage_percent
(gauge)
CPU usage of postmaster process. Not applicable for burstable SKU.
Shown as percent
azure.dbforpostgresql_flexibleservers.connections_succeeded
(count)
Succeeded connections.
azure.dbforpostgresql_flexibleservers.max_connections
(gauge)
Max connections.
azure.dbforpostgresql_flexibleservers.maximum_used_transaction_i_ds
(gauge)
Maximum used transaction ids.
azure.dbforpostgresql_flexibleservers.tcp_connection_backlog
(gauge)
Number of pending TCP connections waiting to be processed by the server. Applicable for 8vcore and above.

イベント

Azure DB for PostgreSQL インテグレーションには、イベントは含まれません。

サービスチェック

Azure DB for PostgreSQL インテグレーションには、サービスのチェック機能は含まれません。

トラブルシューティング

ご不明な点は、Datadog のサポートチームまでお問合せください。