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 and system.events.