Statistics and Metrics Reference

-- View overall query statistics
CALL db.stats.queries();

-- Statistics by query type
CALL db.stats.queries.by_type();

-- View slow queries (> threshold)
CALL db.stats.slow_queries(100);  -- threshold in ms

-- Configure slow query threshold
CALL db.config.set('query.slow_threshold_ms', 100);

{
  "timestamp": "2026-01-28T10:30:00Z",
  "query": "MATCH (p:Person)-[:KNOWS*5]->(f) RETURN f",
  "duration_ms": 1523,
  "rows_returned": 10000,
  "db_hits": 500000,
  "user": "alice",
  "client_ip": "192.168.1.100"
}

-- View cached query plans
CALL db.stats.query_plans();

-- Overall storage statistics
CALL db.stats.storage();

-- Graph element counts
CALL db.stats.graph();

-- Statistics per label
CALL db.stats.labels();

-- Statistics per relationship type
CALL db.stats.relationship_types();

-- All index statistics
CALL db.stats.indexes();

-- Index usage metrics
CALL db.stats.index_usage();

-- Check index health
CALL db.stats.index_health('index_name');

-- Update statistics for all indexes
CALL db.stats.update();

-- Update statistics for specific label
CALL db.stats.update('Person');

-- Update specific index statistics
CALL db.index.analyze('person_email_idx');

-- View histograms for a property
CALL db.stats.histogram('Person', 'age');

-- Estimate predicate selectivity
CALL db.stats.selectivity('Person', 'age > 30');

statistics:
  auto_update: true
  update_threshold: 10000      # Update after N modifications
  sample_size: 1000            # Rows sampled for histograms
  histogram_buckets: 100       # Number of histogram buckets
  update_interval: 3600        # Auto-update interval (seconds)

-- Transaction statistics
CALL db.stats.transactions();

-- Current lock information
CALL db.stats.locks();

-- Connection statistics
CALL db.stats.connections();

-- Statistics per connected client
CALL db.stats.clients();

-- System resource metrics
CALL db.stats.system();

-- Disk I/O statistics
CALL db.stats.io();

-- Buffer pool metrics
CALL db.stats.buffer_pool();

curl http://localhost:3141/metrics

# HELP geode_queries_total Total queries executed
# TYPE geode_queries_total counter
geode_queries_total{status="success"} 1234567
geode_queries_total{status="error"} 123

# HELP geode_query_duration_seconds Query execution time
# TYPE geode_query_duration_seconds histogram
geode_query_duration_seconds_bucket{le="0.001"} 10000
geode_query_duration_seconds_bucket{le="0.01"} 50000
geode_query_duration_seconds_bucket{le="0.1"} 100000
geode_query_duration_seconds_bucket{le="1.0"} 120000
geode_query_duration_seconds_bucket{le="+Inf"} 123456
geode_query_duration_seconds_sum 12345.67
geode_query_duration_seconds_count 123456

# HELP geode_connections_active Active client connections
# TYPE geode_connections_active gauge
geode_connections_active 42

# HELP geode_storage_bytes Storage size in bytes
# TYPE geode_storage_bytes gauge
geode_storage_bytes{type="data"} 1073741824
geode_storage_bytes{type="index"} 268435456
geode_storage_bytes{type="wal"} 134217728

# HELP geode_nodes_total Total nodes in database
# TYPE geode_nodes_total gauge
geode_nodes_total 1000000

# HELP geode_relationships_total Total relationships
# TYPE geode_relationships_total gauge
geode_relationships_total 5000000

# prometheus.yml
scrape_configs:
  - job_name: 'geode'
    static_configs:
      - targets: ['geode-server:3141']
    metrics_path: '/metrics'
    scrape_interval: 15s

# Alert rules for Geode
groups:
  - name: geode_alerts
    rules:
      # High query latency
      - alert: GeodeHighQueryLatency
        expr: histogram_quantile(0.95, geode_query_duration_seconds_bucket) > 1
        for: 5m
        labels:
          severity: warning
        annotations:
          summary: "High query latency detected"

      # Connection pool exhaustion
      - alert: GeodeConnectionPoolLow
        expr: geode_connections_active / geode_connections_max > 0.9
        for: 5m
        labels:
          severity: critical
        annotations:
          summary: "Connection pool nearly exhausted"

      # Storage space
      - alert: GeodeStorageHigh
        expr: geode_storage_bytes{type="data"} > 100e9
        for: 1h
        labels:
          severity: warning
        annotations:
          summary: "Database storage exceeds 100GB"

      # Buffer pool hit rate
      - alert: GeodeLowCacheHitRate
        expr: geode_buffer_pool_hit_ratio < 0.9
        for: 10m
        labels:
          severity: warning
        annotations:
          summary: "Buffer pool hit rate below 90%"

{
  "dashboard": {
    "title": "Geode Database",
    "panels": [
      {
        "title": "Query Rate",
        "type": "graph",
        "targets": [
          {
            "expr": "rate(geode_queries_total[5m])",
            "legendFormat": "{{status}}"
          }
        ]
      },
      {
        "title": "Query Latency (p95)",
        "type": "graph",
        "targets": [
          {
            "expr": "histogram_quantile(0.95, rate(geode_query_duration_seconds_bucket[5m]))"
          }
        ]
      }
    ]
  }
}