Knowledge Base

This guide shows you how to collect and draw query traces with self-managed ClickHouse using either built-in methods or using Grafana. This is particularly useful when you're working with complex queries and need to understand the internal execution mechanics beyond what EXPLAIN provides.

This covers an example of how you can use terraform to create/delete clusters using the API

This article explains how to recover data when using replicated tables in atomic databases in ClickHouse and disks/storage on one of the replica is lost/currupted.

A HAR (HTTP Archive) file captures the network activity in your browser. It can help our support team diagnose slow page loads, failed requests, or other network issues.

Troubleshooting memory limit exceeded errors for a query

Discusses the differences between OPTIMIZE FINAL and FINAL, and when to use and avoid them.

Learn how to set up a custom DNS alias for your instance using a reverse proxy

Setup steps to expose a private MSK via MSK multi-VPC connectivity to ClickPipes.

Learn how to remove the default user when running ClickHouse Server.

Learn why the ClickHouse developers chose to set a verbose logging level by default.