netdata/health/health.d/cockroachdb.conf

# Availability

template: cockroachdb_last_collected_secs
      on: cockroachdb.live_nodes
    calc: $now - $last_collected_t
   units: seconds ago
   every: 10s
    warn: $this > (($status >= $WARNING)  ? ($update_every) : ( 5 * $update_every))
    crit: $this > (($status == $CRITICAL) ? ($update_every) : (60 * $update_every))
   delay: down 5m multiplier 1.5 max 1h
    info: number of seconds since the last successful data collection
      to: dba

# Capacity

template: cockroachdb_used_storage_capacity
      on: cockroachdb.storage_used_capacity_percentage
    calc: $capacity_used_percent
   units: %
   every: 10s
    warn: $this > (($status >= $WARNING)  ? (80) : (85))
    crit: $this > (($status == $CRITICAL) ? (85) : (95))
   delay: down 15m multiplier 1.5 max 1h
    info: entire disk usage percentage
      to: dba

template: cockroachdb_used_usable_storage_capacity
      on: cockroachdb.storage_used_capacity_percentage
    calc: $capacity_usable_used_percent
   units: %
   every: 10s
    warn: $this > (($status >= $WARNING)  ? (80) : (85))
    crit: $this > (($status == $CRITICAL) ? (85) : (95))
   delay: down 15m multiplier 1.5 max 1h
    info: usable space usage percentage
      to: dba

# Replication

template: cockroachdb_unavailable_ranges
      on: cockroachdb.ranges_replication_problem
    calc: $ranges_unavailable
   units: num
   every: 10s
    warn: $this > 0
   delay: down 15m multiplier 1.5 max 1h
    info: number of ranges with fewer live replicas than the replication target
      to: dba

template: cockroachdb_replicas_leaders_not_leaseholders
      on: cockroachdb.replicas_leaders
    calc: $replicas_leaders_not_leaseholders
   units: num
   every: 10s
    warn: $this > 0
   delay: down 15m multiplier 1.5 max 1h
    info: number of replicas that are Raft leaders whose range lease is held by another store
      to: dba

# FD

template: cockroachdb_open_file_descriptors_limit
      on: cockroachdb.process_file_descriptors
    calc: $sys_fd_open/$sys_fd_softlimit * 100
   units: %
   every: 10s
    warn: $this > 80
   delay: down 15m multiplier 1.5 max 1h
    info: open file descriptors usage percentage
      to: dba

# SQL

template: cockroachdb_sql_active_connections
      on: cockroachdb.sql_connections
    calc: $sql_conns
   units: active connections
   every: 10s
    info: number of active SQL connections
      to: dba

template: cockroachdb_sql_executed_statements_total_last_5m
      on: cockroachdb.sql_statements_total
  lookup: sum -5m absolute of sql_query_count
   units: statements
   every: 10s
   warn: $this == 0 AND $cockroachdb_sql_active_connections != 0
   delay: down 15m up 30s multiplier 1.5 max 1h
    info: number of executed SQL statements in the last 5 minutes
      to: dba