514-perf-optimize

ClickHouse query profiling in a MooseStack deployment identifies slow queries and bottlenecks by analyzing production metadata and query logs. It maps findings to code and uses benchmarking to propose and validate candidate optimizations.

Benchmarking ClickHouse query optimizations requires establishing baseline metrics before running experiments. The workflow captures BASELINE_METRICS and BENCHMARK_QUERIES, then compares experimental results against the baseline to validate performance improvements.

Profiling a Moose deployment requires access to production metadata, query logs, and the Moose workspace to accurately identify bottlenecks. These inputs allow the optimization workflow to map performance findings directly to code.

Shipping a PR directly after benchmarking ClickHouse changes is supported by the workflow. It outputs a PR-ready summary after completing the COMPARE stage, which validates experimental benchmark results against established baseline metrics.

The ClickHouse optimization workflow maps findings to code during the PROPOSE stage after profiling bottlenecks. It proposes candidate optimizations based on identified slow queries, then benchmarks these code changes before generating a PR-ready summary.