Help build the future of open source observability software Open positions

Check out the open source projects we support Downloads

ClickHouse overview

Dashboard

ClickHouse Database dashboard based on Prometheus
Last updated: 6 years ago

Start with Grafana Cloud and the new FREE tier. Includes 10K series Prometheus or Graphite Metrics and 50gb Loki Logs

Downloads: 1265

Reviews: 0

  • 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

Get this dashboard:
869
Dependencies: