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

altinity-expert-clickhouse-storage

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

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Storage and IO bottlenecks in ClickHouse clusters can lead to degraded performance and unexpected outages. This skill provides diagnostics to identify disk space pressure, uneven part distribution, and compression inefficiencies that waste storage and IO. It enables targeted optimization across disks, tables, and parts to restore throughput and reduce costs.

Core Features & Use Cases

  • Disk space audits across disks and databases to surface overutilized paths.
  • Compression and part-size analysis to optimize storage layout and IO throughput.
  • Use Case: When clusters experience disk pressure, run these checks to pinpoint hot tables and suboptimal part configurations.

Quick Start

Run the storage and IO diagnostics against your ClickHouse cluster to surface bottlenecks and actionable optimization opportunities.

Frequently Asked Questions about altinity-expert-clickhouse-storage

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

FAQPage Schema
How do I diagnose ClickHouse storage bottlenecks and high disk usage?▼

Diagnose ClickHouse storage bottlenecks by analyzing disk space pressure, uneven MergeTree part distribution, and compression inefficiencies using SQL queries against system tables like system.disks, system.tables, and system.parts to pinpoint hot tables and suboptimal configurations.

What causes uneven part distribution and degraded IO performance in ClickHouse?▼

Uneven part distribution and degraded IO performance in ClickHouse are caused by suboptimal MergeTree part configurations and compression inefficiencies. Analyzing system.parts and system.columns reveals these storage layout hotspots to restore throughput and reduce costs.

How do I audit ClickHouse disk space across databases and storage policies?▼

Audit ClickHouse disk space by evaluating storage policies and querying system.disks with system.tables to surface overutilized paths and disk pressure across databases, enabling targeted storage optimization.

Can I analyze ClickHouse compression efficiency using system tables?▼

You can analyze ClickHouse compression efficiency by running SQL queries against system.columns and system.parts. This identifies compression waste and part-size inefficiencies affecting IO throughput across MergeTree tables.

What do I need to access before evaluating ClickHouse storage policy performance?▼

Evaluating ClickHouse storage policy performance requires access to system tables including system.disks, system.tables, system.parts, and system.columns to execute diagnostic SQL queries for disk space audits and bottleneck identification.

Related Skills

Explore More Data & Analytics Skills→
AltinityAltinity
16

altinity-expert-clickhouse-storage

Diagnose ClickHouse storage usage, compression efficiency, and part sizes via checks.sql queries.

Official
Intermediate
chmonitorchmonitor
255

storage-optimization

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

Official
Intermediate
dimsourdimsour
2

perf

Identify and resolve performance bottlenecks in .NET applications.

Community
Advanced
ntk148vntk148v
42

altinity-expert-clickhouse-overview

Diagnose ClickHouse deployment health with SQL queries and metric aggregation.

Community
Advanced