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

altinity-expert-clickhouse-logs

Analyze ClickHouse system log tables for TTL, disk usage, and freshness.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyze ClickHouse system log tables to identify TTL gaps, disk usage risk, data freshness issues, and cleanup readiness, enabling proactive maintenance and RCA.

Core Features & Use Cases

  • TTL configuration audit for system_log tables and validation of TTL settings
  • Disk usage and growth monitoring to prevent storage exhaustion on system logs
  • Freshness checks to detect stalled or stale data across log tables
  • Retention planning and remediation guidance to align with governance requirements

Quick Start

Run the quick diagnostics to assess TTL configuration, log table sizes, freshness, and cleanup readiness.

Frequently Asked Questions about altinity-expert-clickhouse-logs

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

FAQPage Schema
How do I check ClickHouse system log table TTL configurations?▼

Audit ClickHouse system log table TTL configurations by extracting retention settings from system.tables. This validates TTL rules across system_log tables to identify configuration gaps and ensure proper data lifecycle management.

What causes ClickHouse system logs to consume excessive disk space?▼

ClickHouse system logs consume excessive disk space when TTL configurations are missing or improperly set, causing unbounded growth. Monitoring system.parts identifies storage risks and prevents disk exhaustion across log tables.

How do I detect stale or stalled data in ClickHouse log tables?▼

Detect stale data in ClickHouse log tables by running freshness checks against system tables. This identifies system_log tables where data ingestion has stalled, enabling proactive operational diagnostics and maintenance.

Can I audit ClickHouse system log retention settings for multiple tables at once?▼

Yes, you can audit ClickHouse system log retention across multiple tables simultaneously. Diagnostics evaluate TTL configurations, disk usage, and freshness across all system_log tables to produce comprehensive retention remediation guidance.

What is the best way to plan ClickHouse log retention and cleanup?▼

Plan ClickHouse log retention by analyzing TTL configurations, disk usage, and data freshness across system_log tables. This approach generates actionable remediation guidance to align storage cleanup with governance requirements and mitigate disk risks.

Related Skills

Explore More Data & Analytics Skills→
ntk148vntk148v
42

altinity-expert-clickhouse-storage

Diagnose storage and IO bottlenecks in ClickHouse using SQL queries on system tables.

Community
Intermediate
AltinityAltinity
16

altinity-expert-clickhouse-logs

Detect TTL misconfigurations and disk pressure in ClickHouse system log tables.

Official
Intermediate
chmonitorchmonitor
255

storage-optimization

Tune compression codecs, TTL policies, and tiered storage for ClickHouse clusters.

Official
Intermediate
chmonitorchmonitor
255

system-tables-reference

Reference verified column names and tool mappings for ClickHouse system tables.

Official
Intermediate