Promhub Logo Prom hub

ClickHouse
30,092

Created 4/6/2021
Updated 4/15/2021
Revision 4
Categories
Databases
Grafana Version >=7.5.2
Datasources
Prometheus

ClickHouse

ClickHouse overview dashboard for internal exporter. You can contribute here

Requirements (tested, but may work on older versions too)

  1. Grafana - 7 and up
  2. ClickHouse - 21.3.4.25-lts and up
  3. Prometheus
  4. ClickHouse internal exporter (how to)

Features

  1. Info for: Queries (plus Select/Insert details), IO, Replicas, Merges, Zookeeper, Cache, Parts, Distributed tables, Background task pools
  2. Show both trends and peaks (configurable)
  3. max_over_time + PromQL subqueries to get all peaks
  4. $__rate_interval to correct rate calc between points
  5. Max data points set to 200 for all graph panel
  6. Table with overall info for selected instances
  7. Annotation for restart event
Get Dashboard✕
Download
Copy to Clipboard
Dashboard screenshot 1
Source Grafana.com

Used Metrics 13

  • ClickHouseMetrics_VersionInteger

  • ClickHouseMetrics_Revision

  • ClickHouseAsyncMetrics_NumberOfTables

  • ClickHouseAsyncMetrics_Uptime

  • ClickHouseAsyncMetrics_NumberOfDatabases

  • ClickHouseMetrics_MemoryTracking

  • ClickHouseMetrics_TCPConnection

  • ClickHouseMetrics_HTTPConnection

  • ClickHouseProfileEvents_ReadBackoff

  • __rate_interval:

  • peaks

  • trends

  • ClickHouseProfileEvents_SlowRead