重要前提
安装AI Skills的关键前提是:必须科学上网,且开启TUN模式,这一点至关重要,直接决定安装能否顺利完成,在此郑重提醒三遍:科学上网,科学上网,科学上网。查看完整安装教程 →
altinity-expert-clickhouse-metrics by altinity/skills
npx skills add https://github.com/altinity/skills --skill altinity-expert-clickhouse-metrics实时监控 ClickHouse 指标、事件和异步指标。
运行文件 checks.sql 中的所有查询并分析结果。
system.metrics - 当前仪表值system.events - 自重启以来的累积计数器system.asynchronous_metrics - 系统级指标system.metric_log - 历史指标system.asynchronous_metric_log - 历史异步指标-- 按模式查找指标
select * from system.metrics where metric like '%pattern%'
select * from system.asynchronous_metrics where metric like '%pattern%'
select * from system.events where event like '%pattern%'
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
| 发现 | 加载模块 | 原因 |
|---|---|---|
| 内存指标高 | altinity-expert-clickhouse-memory | 内存分析 |
| 副本延迟高 | altinity-expert-clickhouse-replication | 复制问题 |
| 分区数量高 | altinity-expert-clickhouse-merges | 合并积压 |
| 平均负载高 | altinity-expert-clickhouse-reporting | 查询分析 |
| 连接数高 | altinity-expert-clickhouse-reporting | 连接分析 |
| 指标 | 警告 | 严重 |
|---|---|---|
ReadonlyReplica | - | > 0 |
Query | > 最大值的 75% | > 最大值的 90% |
MemoryResident | > 80% RAM | > 90% RAM |
MaxPartCountForPartition | > parts_to_delay | > parts_to_throw |
ReplicasMaxAbsoluteDelay | > 5 分钟 | > 1 小时 |
LoadAverage1 | > CPU 核心数 | > 2 倍 CPU 核心数 |
启用后,ClickHouse 会在 :9363/metrics 以 Prometheus 格式公开指标。
每周安装次数
43
代码仓库
GitHub 星标数
5
首次出现
2026 年 1 月 24 日
安全审计
安装于
codex41
claude-code37
opencode19
gemini-cli18
github-copilot17
kimi-cli15
Real-time monitoring of ClickHouse metrics, events, and asynchronous metrics.
Run all queries from the file checks.sql and analyze the results.
system.metrics - Current gauge valuessystem.events - Cumulative counters since restartsystem.asynchronous_metrics - System-level metricssystem.metric_log - Historical metricssystem.asynchronous_metric_log - Historical async metrics-- Find metrics by pattern
select * from system.metrics where metric like '%pattern%'
select * from system.asynchronous_metrics where metric like '%pattern%'
select * from system.events where event like '%pattern%'
| Finding | Load Module | Reason |
|---|---|---|
| High memory metrics | altinity-expert-clickhouse-memory | Memory analysis |
| High replica delay | altinity-expert-clickhouse-replication | Replication issues |
| High parts count | altinity-expert-clickhouse-merges | Merge backlog |
| High load average | altinity-expert-clickhouse-reporting | Query analysis |
| High connections | altinity-expert-clickhouse-reporting |
| Metric | Warning | Critical |
|---|---|---|
ReadonlyReplica | - | > 0 |
Query | > 75% max | > 90% max |
MemoryResident | > 80% RAM | > 90% RAM |
MaxPartCountForPartition | > parts_to_delay | > parts_to_throw |
ReplicasMaxAbsoluteDelay | > 5 min | > 1 hour |
ClickHouse exposes metrics at :9363/metrics in Prometheus format when enabled.
Weekly Installs
43
Repository
GitHub Stars
5
First Seen
Jan 24, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
codex41
claude-code37
opencode19
gemini-cli18
github-copilot17
kimi-cli15
Azure 升级评估与自动化工具 - 轻松迁移 Functions 计划、托管层级和 SKU
127,000 周安装
| Connection analysis |
LoadAverage1 | > CPU count | > 2x CPU count |