Managing Self-managed ClickHouse Observability - ClickHouse Documentation

This page covers self-managed ClickHouse Observability. For the recommended fully managed experience, see the documentation here.

This section describes how to manage Self-managed ClickHouse Observability.

Admin guides

Section	Description
Configuration options	Configuration options available for each component.
Estimating resources	Guidance on sizing compute resources for Self-managed ClickHouse Observability based on ingest volume.
Going to production	Recommended steps and best practices before running the service in production.
Isolating read and write	Separating ingestion and query workloads onto dedicated compute with ClickHouse Cloud warehouses.
Materialized views	A detailed guide to using materialized views to accelerate query performance.
Performance tuning	A comprehensive guide to tuning the service for large-scale workloads.
RBAC	Configure role-based access control to manage team permissions for dashboards, saved searches, and sources.
Managing TTL	Managing data retention with TTL (time-to-live) in the service.

Core ClickHouse concepts

Most management tasks require familiarity with the underlying ClickHouse database. We recommend reviewing the following core ClickHouse concepts outlined below before performing administrative or performance-related operations.

Concept	Description
Tables	How data sources map to underlying ClickHouse tables. ClickHouse tables primarily use the `MergeTree` engine.
Parts	How data is written as immutable parts and merged over time.
Partitions	Logical groupings of table parts that simplify data management, querying, and optimization.
Merges	The background process that combines parts to reduce the number of parts queried and maintain performance.
Granules	The smallest unit of data read and pruned during query execution.
Primary (ordering) keys	How the `ORDER BY` key defines on-disk data layout, compression, and query pruning behavior.

These concepts are fundamental to ClickHouse performance and will help you make informed administrative decisions when managing Self-managed ClickHouse Observability.