Debugging a 5xx Spike in Nginx Access Logs with ClickHouse and Logchef

Logchef Team7 min read

Query nginx access logs in ClickHouse when 5xx errors spike: live-tail the burst, narrow with LogchefQL, then pivot to SQL to find the bad host and endpoint.

clickhousenginxobservabilitylogsincident-response
Read post
7 min read

OpenTelemetry Logs in ClickHouse, Made Actually Queryable with Logchef

Exporting OTel logs to ClickHouse solves storage, not search. Logchef adds a query UI, field explorer, and alerting over your existing otel_logs table.

opentelemetryclickhouseobservability
8 min read

Self-Hosted Log Analytics: Pairing ClickHouse with Logchef Instead of a SaaS Log Bill

ClickHouse wins on log cost and speed. Logchef adds the query UI, RBAC, and alerting to run it self-hosted. An honest tradeoff breakdown.

clickhouseobservabilityself-hosted