File: //opt/netdata/etc/netdata/orig/go.d/azure_monitor.profiles/default/postgres_flexible.yaml
---
display_name: Azure PostgreSQL Flexible Server
resource_type: Microsoft.DBforPostgreSQL/flexibleServers
metrics:
- id: cpu_percent
azure_name: cpu_percent
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: memory_percent
azure_name: memory_percent
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: is_db_alive
azure_name: is_db_alive
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: iops
azure_name: iops
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: read_iops
azure_name: read_iops
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: write_iops
azure_name: write_iops
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: read_throughput
azure_name: read_throughput
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: write_throughput
azure_name: write_throughput
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: disk_bandwidth_consumed_percentage
azure_name: disk_bandwidth_consumed_percentage
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: disk_iops_consumed_percentage
azure_name: disk_iops_consumed_percentage
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: disk_queue_depth
azure_name: disk_queue_depth
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: blks_hit
azure_name: blks_hit
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: blks_read
azure_name: blks_read
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: active_connections
azure_name: active_connections
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: connections_succeeded
azure_name: connections_succeeded
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: connections_failed
azure_name: connections_failed
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: tps
azure_name: tps
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: xact_commit
azure_name: xact_commit
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: xact_rollback
azure_name: xact_rollback
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: deadlocks
azure_name: deadlocks
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: tup_returned
azure_name: tup_returned
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: tup_fetched
azure_name: tup_fetched
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: tup_inserted
azure_name: tup_inserted
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: tup_updated
azure_name: tup_updated
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: tup_deleted
azure_name: tup_deleted
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: temp_files
azure_name: temp_files
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: temp_bytes
azure_name: temp_bytes
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: longest_query_time_sec
azure_name: longest_query_time_sec
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: longest_transaction_time_sec
azure_name: longest_transaction_time_sec
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: maximum_used_transaction_ids
azure_name: maximum_used_transactionIDs
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: oldest_backend_xmin_age
azure_name: oldest_backend_xmin_age
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: network_bytes_egress
azure_name: network_bytes_egress
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: network_bytes_ingress
azure_name: network_bytes_ingress
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: storage_used
azure_name: storage_used
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: storage_free
azure_name: storage_free
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: storage_percent
azure_name: storage_percent
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: txlogs_storage_used
azure_name: txlogs_storage_used
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: database_size_bytes
azure_name: database_size_bytes
time_grain: PT30M
series:
- aggregation: average
kind: gauge
- id: backup_storage_used
azure_name: backup_storage_used
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: oldest_backend_xmin
azure_name: oldest_backend_xmin
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: sessions_by_state
azure_name: sessions_by_state
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: sessions_by_wait_event_type
azure_name: sessions_by_wait_event_type
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: analyze_count_user_tables
azure_name: analyze_count_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: autoanalyze_count_user_tables
azure_name: autoanalyze_count_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: autovacuum_count_user_tables
azure_name: autovacuum_count_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: bloat_percent
azure_name: bloat_percent
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: n_dead_tup_user_tables
azure_name: n_dead_tup_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: n_live_tup_user_tables
azure_name: n_live_tup_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: n_mod_since_analyze_user_tables
azure_name: n_mod_since_analyze_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: tables_analyzed_user_tables
azure_name: tables_analyzed_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: tables_autoanalyzed_user_tables
azure_name: tables_autoanalyzed_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: tables_autovacuumed_user_tables
azure_name: tables_autovacuumed_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: tables_counter_user_tables
azure_name: tables_counter_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: tables_vacuumed_user_tables
azure_name: tables_vacuumed_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: vacuum_count_user_tables
azure_name: vacuum_count_user_tables
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: numbackends
azure_name: numbackends
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: xact_total
azure_name: xact_total
time_grain: PT1M
series:
- aggregation: total
kind: counter
- id: client_connections_active
azure_name: client_connections_active
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: client_connections_waiting
azure_name: client_connections_waiting
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: num_pools
azure_name: num_pools
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: server_connections_active
azure_name: server_connections_active
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: server_connections_idle
azure_name: server_connections_idle
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: total_pooled_connections
azure_name: total_pooled_connections
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: cpu_credits_consumed
azure_name: cpu_credits_consumed
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: cpu_credits_remaining
azure_name: cpu_credits_remaining
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: postmaster_process_cpu_usage_percent
azure_name: postmaster_process_cpu_usage_percent
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: max_connections
azure_name: max_connections
time_grain: PT30M
series:
- aggregation: maximum
kind: gauge
- id: tcp_connection_backlog
azure_name: tcp_connection_backlog
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: physical_replication_delay_in_seconds
azure_name: physical_replication_delay_in_seconds
time_grain: PT1M
series:
- aggregation: average
kind: gauge
- id: physical_replication_delay_in_bytes
azure_name: physical_replication_delay_in_bytes
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
- id: logical_replication_delay_in_bytes
azure_name: logical_replication_delay_in_bytes
time_grain: PT1M
series:
- aggregation: maximum
kind: gauge
template:
family: Azure PostgreSQL Flexible Server
context_namespace: postgres_flexible
chart_defaults:
label_promotion:
- resource_name
- resource_group
- region
- resource_type
- profile
instances:
by_labels:
- resource_uid
charts:
- id: am_azure_postgres_flexible__cpu
title: Azure PostgreSQL Flexible Server CPU Utilization
context: cpu
family: Utilization
type: line
units: percentage
algorithm: absolute
dimensions:
- selector: cpu_percent_average
name: average
- id: am_azure_postgres_flexible__memory
title: Azure PostgreSQL Flexible Server Memory Utilization
context: memory
family: Utilization
type: line
units: percentage
algorithm: absolute
dimensions:
- selector: memory_percent_average
name: average
- id: am_azure_postgres_flexible__availability
title: Azure PostgreSQL Flexible Server Database Alive
context: availability
family: Availability
type: line
units: state
algorithm: absolute
dimensions:
- selector: is_db_alive_maximum
name: maximum
- id: am_azure_postgres_flexible__iops
title: Azure PostgreSQL Flexible Server IOPS
context: iops
family: IO
type: line
units: operations/s
algorithm: absolute
dimensions:
- selector: iops_average
name: total
- selector: read_iops_average
name: read
- selector: write_iops_average
name: write
- id: am_azure_postgres_flexible__disk_throughput
title: Azure PostgreSQL Flexible Server Disk Throughput
context: disk_throughput
family: IO
type: line
units: bytes/s
algorithm: absolute
dimensions:
- selector: read_throughput_average
name: read
- selector: write_throughput_average
name: write
- id: am_azure_postgres_flexible__disk_saturation
title: Azure PostgreSQL Flexible Server Disk Saturation
context: disk_saturation
family: IO
type: line
units: percentage
algorithm: absolute
dimensions:
- selector: disk_bandwidth_consumed_percentage_average
name: bandwidth
- selector: disk_iops_consumed_percentage_average
name: iops
- id: am_azure_postgres_flexible__disk_queue_depth
title: Azure PostgreSQL Flexible Server Disk Queue Depth
context: disk_queue_depth
family: IO
type: line
units: operations
algorithm: absolute
dimensions:
- selector: disk_queue_depth_average
name: average
- id: am_azure_postgres_flexible__buffer_cache
title: Azure PostgreSQL Flexible Server Buffer Cache
context: buffer_cache
family: Performance
type: line
units: blocks/s
algorithm: incremental
dimensions:
- selector: blks_hit_total
name: hits
- selector: blks_read_total
name: reads
- id: am_azure_postgres_flexible__active_connections
title: Azure PostgreSQL Flexible Server Active Connections
context: active_connections
family: Connections
type: line
units: connections
algorithm: absolute
dimensions:
- selector: active_connections_average
name: average
- id: am_azure_postgres_flexible__connection_rate
title: Azure PostgreSQL Flexible Server Connection Rate
context: connection_rate
family: Connections
type: line
units: connections/s
algorithm: incremental
dimensions:
- selector: connections_succeeded_total
name: succeeded
- selector: connections_failed_total
name: failed
- id: am_azure_postgres_flexible__transactions
title: Azure PostgreSQL Flexible Server Transactions
context: transactions
family: Throughput
type: line
units: transactions/s
algorithm: incremental
dimensions:
- selector: xact_commit_total
name: committed
- selector: xact_rollback_total
name: rolled_back
- id: am_azure_postgres_flexible__transaction_rate
title: Azure PostgreSQL Flexible Server Transaction Rate
context: transaction_rate
family: Throughput
type: line
units: transactions/s
algorithm: incremental
dimensions:
- selector: tps_total
name: total
- selector: xact_total_total
name: xact_total
- id: am_azure_postgres_flexible__deadlocks
title: Azure PostgreSQL Flexible Server Deadlocks
context: deadlocks
family: Contention
type: line
units: deadlocks/s
algorithm: incremental
dimensions:
- selector: deadlocks_total
name: total
- id: am_azure_postgres_flexible__tuple_reads
title: Azure PostgreSQL Flexible Server Tuple Reads
context: tuple_reads
family: Throughput
type: line
units: tuples/s
algorithm: incremental
dimensions:
- selector: tup_returned_total
name: returned
- selector: tup_fetched_total
name: fetched
- id: am_azure_postgres_flexible__tuple_writes
title: Azure PostgreSQL Flexible Server Tuple Writes
context: tuple_writes
family: Throughput
type: line
units: tuples/s
algorithm: incremental
dimensions:
- selector: tup_inserted_total
name: inserted
- selector: tup_updated_total
name: updated
- selector: tup_deleted_total
name: deleted
- id: am_azure_postgres_flexible__temp_files
title: Azure PostgreSQL Flexible Server Temp Files Created
context: temp_files
family: Performance
type: line
units: files/s
algorithm: incremental
dimensions:
- selector: temp_files_total
name: total
- id: am_azure_postgres_flexible__temp_bytes
title: Azure PostgreSQL Flexible Server Temp Bytes Written
context: temp_bytes
family: Performance
type: line
units: bytes/s
algorithm: incremental
dimensions:
- selector: temp_bytes_total
name: total
- id: am_azure_postgres_flexible__long_running
title: Azure PostgreSQL Flexible Server Long Running Operations
context: long_running
family: Activity
type: line
units: seconds
algorithm: absolute
dimensions:
- selector: longest_query_time_sec_maximum
name: query
- selector: longest_transaction_time_sec_maximum
name: transaction
- id: am_azure_postgres_flexible__xid_usage
title: Azure PostgreSQL Flexible Server Transaction ID Usage
context: xid_usage
family: Safety
type: line
units: transactions
algorithm: absolute
dimensions:
- selector: maximum_used_transaction_ids_average
name: max_used
- selector: oldest_backend_xmin_maximum
name: oldest_xmin
- id: am_azure_postgres_flexible__xmin_age
title: Azure PostgreSQL Flexible Server Backend XID Age
context: xmin_age
family: Safety
type: line
units: transactions
algorithm: absolute
dimensions:
- selector: oldest_backend_xmin_age_maximum
name: maximum
- id: am_azure_postgres_flexible__network
title: Azure PostgreSQL Flexible Server Network Traffic
context: network
family: Network
type: line
units: bytes/s
algorithm: incremental
dimensions:
- selector: network_bytes_ingress_total
name: in
- selector: network_bytes_egress_total
name: out
- id: am_azure_postgres_flexible__storage
title: Azure PostgreSQL Flexible Server Storage
context: storage
family: Capacity
type: line
units: bytes
algorithm: absolute
dimensions:
- selector: storage_used_average
name: used
- selector: storage_free_average
name: free
- id: am_azure_postgres_flexible__storage_utilization
title: Azure PostgreSQL Flexible Server Storage Utilization
context: storage_utilization
family: Capacity
type: line
units: percentage
algorithm: absolute
dimensions:
- selector: storage_percent_average
name: average
- id: am_azure_postgres_flexible__wal_storage
title: Azure PostgreSQL Flexible Server WAL Storage
context: wal_storage
family: Capacity
type: line
units: bytes
algorithm: absolute
dimensions:
- selector: txlogs_storage_used_average
name: used
- id: am_azure_postgres_flexible__database_size
title: Azure PostgreSQL Flexible Server Database Size
context: database_size
family: Capacity
type: line
units: bytes
algorithm: absolute
dimensions:
- selector: database_size_bytes_average
name: average
- id: am_azure_postgres_flexible__backup_storage
title: Azure PostgreSQL Flexible Server Backup Storage
context: backup_storage
family: Capacity
type: line
units: bytes
algorithm: absolute
dimensions:
- selector: backup_storage_used_average
name: used
- id: am_azure_postgres_flexible__replication_lag_time
title: Azure PostgreSQL Flexible Server Replication Lag
context: replication_lag_time
family: Replication
type: line
units: seconds
algorithm: absolute
dimensions:
- selector: physical_replication_delay_in_seconds_average
name: average
- id: am_azure_postgres_flexible__replication_lag_bytes
title: Azure PostgreSQL Flexible Server Replication Lag Bytes
context: replication_lag_bytes
family: Replication
type: line
units: bytes
algorithm: absolute
dimensions:
- selector: physical_replication_delay_in_bytes_maximum
name: physical
- selector: logical_replication_delay_in_bytes_maximum
name: logical
- id: am_azure_postgres_flexible__sessions_by_state
title: Azure PostgreSQL Flexible Server Sessions by State
context: sessions_by_state
family: Activity
type: line
units: sessions
algorithm: absolute
dimensions:
- selector: sessions_by_state_maximum
name: maximum
- id: am_azure_postgres_flexible__sessions_by_wait_event_type
title: Azure PostgreSQL Flexible Server Sessions by Wait Event Type
context: sessions_by_wait_event_type
family: Activity
type: line
units: sessions
algorithm: absolute
dimensions:
- selector: sessions_by_wait_event_type_maximum
name: maximum
- id: am_azure_postgres_flexible__autovacuum_operations
title: Azure PostgreSQL Flexible Server Autovacuum Operations
context: autovacuum_operations
family: Autovacuum
type: line
units: operations
algorithm: absolute
dimensions:
- selector: vacuum_count_user_tables_maximum
name: vacuum
- selector: autovacuum_count_user_tables_maximum
name: autovacuum
- selector: analyze_count_user_tables_maximum
name: analyze
- selector: autoanalyze_count_user_tables_maximum
name: autoanalyze
- id: am_azure_postgres_flexible__autovacuum_table_coverage
title: Azure PostgreSQL Flexible Server Autovacuum Table Coverage
context: autovacuum_table_coverage
family: Autovacuum
type: line
units: tables
algorithm: absolute
dimensions:
- selector: tables_vacuumed_user_tables_maximum
name: vacuumed
- selector: tables_autovacuumed_user_tables_maximum
name: autovacuumed
- selector: tables_analyzed_user_tables_maximum
name: analyzed
- selector: tables_autoanalyzed_user_tables_maximum
name: autoanalyzed
- selector: tables_counter_user_tables_maximum
name: total
- id: am_azure_postgres_flexible__tuple_liveness
title: Azure PostgreSQL Flexible Server Tuple Liveness
context: tuple_liveness
family: Autovacuum
type: line
units: tuples
algorithm: absolute
dimensions:
- selector: n_live_tup_user_tables_maximum
name: live
- selector: n_dead_tup_user_tables_maximum
name: dead
- selector: n_mod_since_analyze_user_tables_maximum
name: modified_since_analyze
- id: am_azure_postgres_flexible__bloat
title: Azure PostgreSQL Flexible Server Table Bloat
context: bloat
family: Autovacuum
type: line
units: percentage
algorithm: absolute
dimensions:
- selector: bloat_percent_maximum
name: maximum
- id: am_azure_postgres_flexible__backend_count
title: Azure PostgreSQL Flexible Server Backend Count
context: backend_count
family: Connections
type: line
units: connections
algorithm: absolute
dimensions:
- selector: numbackends_maximum
name: maximum
- id: am_azure_postgres_flexible__pgbouncer_client_connections
title: Azure PostgreSQL Flexible Server PgBouncer Client Connections
context: pgbouncer_client_connections
family: PgBouncer
type: line
units: connections
algorithm: absolute
dimensions:
- selector: client_connections_active_maximum
name: active
- selector: client_connections_waiting_maximum
name: waiting
- id: am_azure_postgres_flexible__pgbouncer_server_connections
title: Azure PostgreSQL Flexible Server PgBouncer Server Connections
context: pgbouncer_server_connections
family: PgBouncer
type: line
units: connections
algorithm: absolute
dimensions:
- selector: server_connections_active_maximum
name: active
- selector: server_connections_idle_maximum
name: idle
- id: am_azure_postgres_flexible__pgbouncer_pool_count
title: Azure PostgreSQL Flexible Server PgBouncer Pool Count
context: pgbouncer_pool_count
family: PgBouncer
type: line
units: pools
algorithm: absolute
dimensions:
- selector: num_pools_maximum
name: pools
- id: am_azure_postgres_flexible__pgbouncer_pooled_connections
title: Azure PostgreSQL Flexible Server PgBouncer Pooled Connections
context: pgbouncer_pooled_connections
family: PgBouncer
type: line
units: connections
algorithm: absolute
dimensions:
- selector: total_pooled_connections_maximum
name: pooled_connections
- id: am_azure_postgres_flexible__cpu_credits
title: Azure PostgreSQL Flexible Server CPU Credits
context: cpu_credits
family: Saturation
type: line
units: credits
algorithm: absolute
dimensions:
- selector: cpu_credits_consumed_average
name: consumed
- selector: cpu_credits_remaining_average
name: remaining
- id: am_azure_postgres_flexible__postmaster_cpu
title: Azure PostgreSQL Flexible Server Postmaster CPU Usage
context: postmaster_cpu
family: Saturation
type: line
units: percentage
algorithm: absolute
dimensions:
- selector: postmaster_process_cpu_usage_percent_average
name: average
- id: am_azure_postgres_flexible__max_connections
title: Azure PostgreSQL Flexible Server Max Connections
context: max_connections
family: Connections
type: line
units: connections
algorithm: absolute
dimensions:
- selector: max_connections_maximum
name: maximum
- id: am_azure_postgres_flexible__tcp_connection_backlog
title: Azure PostgreSQL Flexible Server TCP Connection Backlog
context: tcp_connection_backlog
family: Connections
type: line
units: connections
algorithm: absolute
dimensions:
- selector: tcp_connection_backlog_maximum
name: maximum