system.asynchronous_metric_log

Contains the historical values for system.asynchronous_metrics, which are saved once per minute. Enabled by default.

Columns:

  • event_date (Date) — Event date.
  • event_time (DateTime) — Event time.
  • event_time_microseconds (DateTime64) — Event time with microseconds resolution.
  • name (String) — Metric name.
  • value (Float64) — Metric value.

Example

  1. SELECT * FROM system.asynchronous_metric_log LIMIT 10
  1. ┌─event_date─┬──────────event_time─┬────event_time_microseconds─┬─name─────────────────────────────────────┬─────value─┐
  2. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 CPUFrequencyMHz_0 2120.9
  3. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 jemalloc.arenas.all.pmuzzy 743
  4. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 jemalloc.arenas.all.pdirty 26288
  5. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 jemalloc.background_thread.run_intervals 0
  6. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 jemalloc.background_thread.num_runs 0
  7. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 jemalloc.retained 60694528
  8. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 jemalloc.mapped 303161344
  9. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 jemalloc.resident 260931584
  10. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 jemalloc.metadata 12079488
  11. 2020-09-05 2020-09-05 15:56:30 2020-09-05 15:56:30.025227 jemalloc.allocated 133756128
  12. └────────────┴─────────────────────┴────────────────────────────┴──────────────────────────────────────────┴───────────┘

See Also

  • system.asynchronous_metrics — Contains metrics, calculated periodically in the background.
  • system.metric_log — Contains history of metrics values from tables system.metrics and system.events, periodically flushed to disk.