CockroachDB

Prometheus Metrics

CockroachDB is a distributed SQL database designed for cloud-native applications with built-in resilience and horizontal scalability.

Prometheus Metrics

CockroachDB exposes Prometheus metrics by default at http://localhost:8080/_status/vars – no additional service-side configuration is required.

Glouton Configuration

Linux

sudo tee /etc/glouton/conf.d/99-cockroachdb.conf > /dev/null << 'EOF'
metric:
  prometheus:
    targets:
      - url: "http://localhost:8080/_status/vars"
        name: "cockroachdb"
        allow_metrics:
          - "sys_cpu_combined_percent_normalized"
          - "sys_rss"
          - "sql_query_count"
          - "sql_conns"
          - "liveness_livenodes"
          - "capacity_used"
EOF

Windows

Create or edit C:\ProgramData\glouton\conf.d\99-cockroachdb.conf:

metric:
  prometheus:
    targets:
      - url: "http://localhost:8080/_status/vars"
        name: "cockroachdb"
        allow_metrics:
          - "sys_cpu_combined_percent_normalized"
          - "sys_rss"
          - "sql_query_count"
          - "sql_conns"
          - "liveness_livenodes"
          - "capacity_used"

Glouton automatically detects configuration changes.

Customize collected metrics

The metrics below are our recommended defaults. You can adjust the allow_metrics list to include any metric from CockroachDB’s monitoring documentation, or use deny_metrics to exclude specific ones. See Metrics Filtering for details.

Metric	Description
sys_cpu_combined_percent_normalized	Combined CPU usage percentage normalized across all cores
sys_rss	Resident set size (RSS) memory usage of the CockroachDB process in bytes
sql_query_count	Total number of SQL queries executed
sql_conns	Number of currently active SQL connections
liveness_livenodes	Number of live nodes in the cluster
capacity_used	Amount of disk storage capacity currently in use in bytes