duyetduyet
198

Clickhouse Monitoring

screenshot of Clickhouse Monitoring

Simple ClickHouse UI that relies on system tables to help monitor and provide overview of your cluster

GithubDemo

Overview:

The ClickHouse Monitoring Dashboard is a simple Next.js dashboard designed to monitor and provide an overview of your ClickHouse cluster using system.* tables.

Features:

  • Query monitor: Provides details on current queries, query history, resources (memory, parts read, file_open), most expensive queries, most used tables or columns.
  • Cluster monitor: Displays total memory/CPU usage, distributed queue, global settings, mergetree settings, metrics, and more.
  • Tables and parts information: Shows size, row count, compression, part size, and column level details.
  • Useful tools: Includes Zookeeper data exploration, query EXPLAIN, and ability to kill queries.
  • Visualization metric charts: Displays metric charts for queries and resource usage, number of merges/mutation, merge performance, query performance, etc.

Summary:

The ClickHouse Monitoring Dashboard is a valuable tool for monitoring and managing a ClickHouse cluster efficiently. With features like query monitoring, cluster monitoring, tables and parts information, useful tools, and visualization metric charts, it provides a comprehensive overview of the ClickHouse environment. Users can also explore Zookeeper data, analyze query performance, and contribute to the project through feedback and contributions.