system.asynchronous_metrics

Contains metrics that are calculated periodically in the background. For example, the amount of RAM in use.

Columns:

  • metric (String) — Metric name.
  • value (Float64) — Metric value.

Example

  1. SELECT * FROM system.asynchronous_metrics LIMIT 10
  1. ┌─metric──────────────────────────────────┬──────value─┐
  2. │ jemalloc.background_thread.run_interval │          0 │
  3. │ jemalloc.background_thread.num_runs     │          0 │
  4. │ jemalloc.background_thread.num_threads  │          0 │
  5. │ jemalloc.retained                       │  422551552 │
  6. │ jemalloc.mapped                         │ 1682989056 │
  7. │ jemalloc.resident                       │ 1656446976 │
  8. │ jemalloc.metadata_thp                   │          0 │
  9. │ jemalloc.metadata                       │   10226856 │
  10. │ UncompressedCacheCells                  │          0 │
  11. │ MarkCacheFiles                          │          0 │
  12. └─────────────────────────────────────────┴────────────┘

See Also

  • Monitoring — Base concepts of ClickHouse monitoring.
  • system.metrics — Contains instantly calculated metrics.
  • system.events — Contains a number of events that have occurred.
  • system.metric_log — Contains a history of metrics values from tables system.metrics и system.events.

Original article