import SystemTableCloud from '@site/docs/_snippets/_system_table_cloud.md';

dimensional_metrics {#dimensional_metrics}

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

Columns:

• metric (String) — Metric name.
• value (Int64) — Metric value.
• description (String) — Metric description.
• labels (Map(String, String)) — Metric labels.
• name (String) — Alias for metric.

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 {#metric_descriptions}

merge_failures {#merge_failures}

Number of all failed merges since startup.

startup_scripts_failure_reason {#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 {#merge_tree_parts}

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

See Also

• system.asynchronous_metrics — Contains periodically calculated metrics.
• system.events — Contains a number of events that occurred.
• system.metric_log — Contains a history of metrics values from tables system.metrics and system.events.
• Monitoring — Base concepts of ClickHouse monitoring.