skills.rest
ntk148v
ntk148vCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

altinity-expert-clickhouse-metrics

Query ClickHouse system tables to surface real-time and historical performance metrics.

42|7|Updated Dec 26, 2025
Search Tags:#performance#monitoring#dashboards#metrics#real-time#diagnostics#clickhouse
One-click install
npx skills add https://github.com/ntk148v/clicklens --skill altinity-expert-clickhouse-metrics
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: altinity-expert-clickhouse-metrics
Source: https://github.com/ntk148v/clicklens/tree/main/.agent/skills/altinity-expert-clickhouse-metrics
Command: npx skills add https://github.com/ntk148v/clicklens --skill altinity-expert-clickhouse-metrics

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

DBAs and operators need a reliable, real-time view into ClickHouse performance metrics to detect saturation, bottlenecks, and resource contention.

Core Features & Use Cases

  • Real-time health metrics: queries, memory, connections, disk I/O, and replication delays
  • Historical insights: trend analysis from system.metric_log and system.asynchronous_metric_log
  • Threshold-driven alerts: predefined thresholds to surface critical issues

Quick Start

Run the real-time health checks against your ClickHouse cluster to surface current performance metrics.

Frequently Asked Questions about altinity-expert-clickhouse-metrics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I monitor ClickHouse performance metrics for real-time bottlenecks?▼

Monitor ClickHouse performance metrics by querying system.metrics, system.asynchronous_metrics, and system.events to detect real-time saturation, memory usage, and connection bottlenecks across clusters.

What is the best way to check ClickHouse replication delay and disk I/O?▼

Check ClickHouse replication delay and disk I/O by querying real-time health metrics from system tables. This surfaces resource contention and performance issues using predefined thresholds and historical trend analysis.

Can I use this for historical trend analysis of ClickHouse query performance?▼

Yes, you can analyze historical ClickHouse query performance trends using system.metric_log and system.asynchronous_metric_log. This allows DBAs to review past load, memory usage, and replication delays to identify long-term issues.

Does this approach surface threshold-driven alerts for ClickHouse memory usage?▼

Yes, this approach surfaces threshold-driven alerts for ClickHouse memory usage by querying system.metrics and system.events. It uses predefined thresholds to highlight critical resource saturation and connection bottlenecks.

How do I diagnose ClickHouse saturation across clusters as an SRE?▼

Diagnose ClickHouse saturation across clusters by querying system.asynchronous_metrics and metric logs to evaluate load, connections, and query performance. This provides SREs with real-time dashboards and historical insights to pinpoint bottlenecks.

Related Skills

Explore More Data & Analytics Skills→
celticht32celticht32
4

couchbase-capella

Provision Couchbase Capella clusters with credentials, CIDRs, and private networking.

Community
Advanced
wojonswojons
4

observability-logging

Integrate logs with metrics, traces, alerts, and dashboards for system observability.

Community
Advanced
ShunmeiChoShunmeiCho
1

clickhouse-io

Provide ClickHouse database design, query optimization, and data ingestion patterns.

Community
Intermediate
duyetduyet

clickhouse-monitoring

Monitor ClickHouse clusters through the ClickHouse Monitor dashboard.

Community
Advanced