altinity-expert-clickhouse-part-log
Part Log Based Diagnostics
Run all queries from checks.sql (cluster-wide) and interpret the top offenders by rate (events/min), volume (rows/bytes), and errors.
Notes:
- Default timeframes are relative (e.g., last 1h/6h/24h). Only switch to an explicit time range when the user provides one in the prompt.
- Replace
{cluster}with your ClickHouse cluster name (DataGrip). - Keep queries time-bounded (
event_time > now() - INTERVAL ...) and useLIMIT. - If a query fails due to schema differences, run
DESCRIBE TABLE system.part_logand drop only missing fields.
Cross-module triggers:
- High
NewPartrate / micro-batches → loadaltinity-expert-clickhouse-ingestion+altinity-expert-clickhouse-merges - High
MutatePartrate → loadaltinity-expert-clickhouse-mutations - Many
DownloadPart→ loadaltinity-expert-clickhouse-replication - Merge saturation / slow merges → load
altinity-expert-clickhouse-merges+altinity-expert-clickhouse-storage
More from altinity/skills
altinity-expert-clickhouse-schema
Analyze ClickHouse table structure, partitioning, ORDER BY keys, materialized views, and identify schema design anti-patterns. Use for table design issues and optimization.
64altinity-expert-clickhouse-logs
Analyze ClickHouse system log table health including TTL configuration, disk usage, freshness, and cleanup. Use for system log issues and TTL configuration.
57altinity-expert-clickhouse-ingestion
Diagnose ClickHouse INSERT performance, batch sizing, part creation patterns, and ingestion bottlenecks. Use for slow inserts and data pipeline issues.
56altinity-expert-clickhouse-overview
Runs a quick overview of Clickhouse server health.
53altinity-expert-clickhouse-mutations
Track and diagnose ClickHouse ALTER UPDATE, ALTER DELETE, and other mutation operations. Use for stuck mutations and mutation performance issues.
53altinity-expert-clickhouse-reporting
Diagnose ClickHouse SELECT query performance, analyze query patterns, identify slow queries, and find optimization opportunities. Use for query latency and timeout issues.
53