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 지원팀에 문의하세요.