ClickHouse

ClickHouse is an open-source, high-performance analytics database designed for real-time data analysis on large datasets.

It uses a columnar storage format, allowing it to read only the data needed for each query. This makes it significantly faster than traditional row-based databases for analytics and reporting.

Observability with Pulse

Pulse provides ClickHouse observability by providing a unified platform to monitor query performance, system health, resource utilization across clusters, etc.

This capability enables you to:

• Monitor ClickHouse component health (Keeper, Server, Web Server) in real time.
• Analyze logs to troubleshoot issues and correlate events.
• Track query performance and resource usage with visual insights.
• Trace query spans (individual query operations) in the Trace Timeline to visualize execution flow
• Detect and fix bottlenecks using Pulse custom alerts and charts.
• Build custom dashboards and visualizations for continuous observability and optimization.

Before You Begin

To view ClickHouse data in the Pulse UI, make sure you:

• Configure your Hadoop cluster to send metrics and query data to Pulse.
• Configure Pulse to process and display the collected ClickHouse metrics.

For detailed setup instructions, see the following pages:

• Configure ODP ClickHouse
• Configure Pulse to Monitor ClickHouse

Explore in Detail

• Monitor ClickHouse Health and Logs

• Monitor ClickHouse with Pulse Alerts

• Visualize ClickHouse Operational Metrics

  • Visualize Query Metrics
  • Visualize Performance Metrics
  • Visualize Network Metrics

• Monitor ClickHouse Queries

• Analyze ClickHouse Query Details

• Create Custom Visualization