Skip to main content
Skip to main content
Edit this page

system.dimensional_metrics

Querying in ClickHouse Cloud

The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the clusterAllReplicas function. See here for further details.

Description​

This table contains dimensional metrics that can be calculated instantly and exported in the Prometheus format. It is always up to date.

Columns​

Example​

You can use a query like this to export all the dimensional metrics in the Prometheus format.

SELECT
  metric AS name,
  toFloat64(value) AS value,
  description AS help,
  labels,
  'gauge' AS type
FROM system.dimensional_metrics
FORMAT Prometheus

Metric descriptions​

merge_failures​

Number of all failed merges since startup.

startup_scripts_failure_reason​

Indicates startup scripts failures by error type. Set to 1 when a startup script fails, labelled with the error name.

merge_tree_parts​

Number of merge tree data parts, labelled by part state, part type, and whether it is a projection part.

filesystem_cache_evictions_total​

Number of file segments evicted from a filesystem cache, labelled by cache name. Disabled by default; enable with expose_prometheus_eviction_metrics.

filesystem_cache_evicted_bytes_total​

Total bytes of file segments evicted from a filesystem cache, labelled by cache name. Disabled by default; enable with expose_prometheus_eviction_metrics.

filesystem_cache_evictions_by_user_total​

Number of file segments evicted from a filesystem cache, labelled by cache name and user id. Disabled by default; enable with expose_prometheus_eviction_metrics and expose_prometheus_eviction_metrics_per_user.

filesystem_cache_evicted_bytes_by_user_total​

Total bytes of file segments evicted from a filesystem cache, labelled by cache name and user id. Disabled by default; enable with expose_prometheus_eviction_metrics and expose_prometheus_eviction_metrics_per_user.

See also​