- Query optimization techniques and performance tuning
- Monitoring
- Security best practices and compliance features
- Cost optimization and billing
| Page | Description |
|---|---|
| Choosing a Primary Key | How to select primary keys that maximize query performance and minimize storage overhead. |
| Select Data Types | Choose optimal data types to reduce memory usage, improve compression, and accelerate queries. |
| Use Materialized Views | Leverage materialized views to pre-aggregate data and dramatically speed up analytical queries. |
| Minimize and Optimize JOINs | Best practices for using ClickHouse’s JOIN capabilities efficiently. |
| Choosing a Partitioning Key | Select partitioning strategies that enable efficient data pruning and faster query execution. |
| Selecting an Insert Strategy | Optimize data ingestion throughput and reduce resource consumption with proper insert patterns. |
| Data Skipping Indices | Apply secondary indices strategically to skip irrelevant data blocks and accelerate filtered queries. |
| Avoid Mutations | Design schemas and workflows that eliminate costly UPDATE/DELETE operations for better performance. |
| Avoid OPTIMIZE FINAL | Prevent performance bottlenecks by understanding when OPTIMIZE FINAL hurts more than it helps. |
| Use JSON where appropriate | Balance flexibility and performance when working with semi-structured JSON data in ClickHouse. |
Query optimization techniques and performance tuning
| Topic | Description |
|---|---|
| Query optimization guide | Start here for query optimization fundamentals, covering common scenarios and performance techniques to improve query execution speed. |
| Primary indexes advanced guide | Deep dive into ClickHouse’s unique sparse primary indexing system, how it differs from traditional databases, and best practices for optimal indexing strategies. |
| Query parallelism | Learn how ClickHouse parallelizes query execution using processing lanes and max_threads settings, including how to inspect and optimize parallel execution. |
| Partitioning key | Master partition key selection to dramatically improve query performance by enabling efficient data segment pruning and avoiding common partitioning pitfalls. |
| Data skipping indexes | Apply secondary indexes strategically to skip irrelevant data blocks and accelerate filtered queries on non-primary key columns. |
PREWHERE optimization | Understand how PREWHERE automatically reduces I/O by filtering data before reading unnecessary columns, plus how to monitor its effectiveness. |
| Bulk inserts | Maximize ingestion throughput and reduce resource overhead by batching data insertions effectively. |
| Asynchronous inserts | Improve insert performance by leveraging server-side batching to reduce client-side complexity and increase throughput for high-frequency insertions. |
| Avoid mutations | Design append-only workflows that eliminate costly UPDATE and DELETE operations while maintaining data accuracy and performance. |
| Avoid nullable columns | Reduce storage overhead and improve query performance by using default values instead of nullable columns where possible. |
Avoid OPTIMIZE FINAL | Understand when you should and shouldn’t use OPTIMIZE TABLE FINAL |
| Analyzer | Leverage ClickHouse’s new query analyzer to identify performance bottlenecks and optimize query execution plans for better efficiency. |
| Query profiling | Use the sampling query profiler to analyze query execution patterns, identify performance hot spots, and optimize resource usage. |
| Query cache | Accelerate frequently executed SELECT queries by enabling and configuring ClickHouse’s built-in query result caching. |
| Testing hardware | Run ClickHouse performance benchmarks on any server without installation to evaluate hardware capabilities. (Not applicable to ClickHouse Cloud) |
Monitoring
| Page | Description |
|---|---|
| Advanced dashboard | Use the built in advanced dashboard to monitor service health and performance |
| Prometheus integration | Use Prometheus to monitor Cloud services |
| Cloud Monitoring Capabilities | Get an overview of built in monitoring capabilities and integration options |
Security
| Page | Description |
|---|---|
| ClickHouse Cloud Security Features | Details the security options and best practices available for ClickHouse organization and service protection. |
| Cloud access management guides | This section contains step-by-step guides for managing access in ClickHouse Cloud. |
| Setting IP filters | A guide on how to create or modify an IP access list. |
| Private networking | ClickHouse Cloud provides the ability to connect your services to your cloud virtual network. Refer to these guides for set up steps for your provider |
| Data masking | Learn how you can mask data in ClickHouse. |
| Data encryption | Learn how to enable Transparent Data Encryption as well as Customer Managed Encryption Keys. |
| Audit logging | Guides on how to access and review audited events in the ClickHouse Cloud console, as well as sample logs and queries customers can use in developing their BYOC security program |
| HIPAA onboarding | This page describes the process for enabling deployment of HIPAA compliant services in ClickHouse Cloud. |
| PCI onboarding | This page describes the process for enabling deployment of PCI compliant services in ClickHouse Cloud. |
Cost optimization and billing
| Page | Description |
|---|---|
| Data transfer | Understand how ClickHouse Cloud meters data transferred ingress and egress |
| Notifications | Set up notifications for your ClickHouse Cloud service. For example, when credit usage passes a threshold |