Microsoft Azure DB for PostgreSQL

概要

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.status
(gauge)
Status of Azure DB for PostgreSQL integration (deprecated)
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 DB for PostgreSQL インテグレーションには、イベントは含まれません。

サービスチェック

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

トラブルシューティング

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