ClickHouse overview

Dashboard

ClickHouse Database dashboard based on Prometheus
Last updated: a year ago

Downloads: 146

  • b72aca48abd043be98d3caf2d3311479.png
    b72aca48abd043be98d3caf2d3311479.png
  • c5b5ca2b8a51406eb021939804fab736.png
    c5b5ca2b8a51406eb021939804fab736.png

ClickHouse is a modern and free analytic DBMS for big data. ClickHouse manages extremely large volumes of data in a stable and sustainable manner. It currently powers Yandex.Metrica, world’s second largest web analytics platform, with over 13 trillion database records and over 20 billion events a day, generating customized reports on-the-fly, directly from non-aggregated data. It is available at https://clickhouse.yandex/

Dashboard allow to monitor:

  • total qps based on query execution
  • cache hits/miss rate graph
  • number of active connections
  • bytes merged/allocated rate

The author assumes that the metrics are scraped from various hosts and databases. That's why there are placed two templates: $host and $db. Remember to adjust templates for your needs at "/dashboard/db/<your-dashboard>?editview=templating". Graphs would change accordingly to selected value.

Metrics based on system ClickHouse tables: events and metrics.

Requirements: Dashboard is based on the https://github.com/roistat/go-clickhouse metrics

Dependencies: