All skills
optimizing-clickhouse-and-hogql-queries
Diagnose a slow HogQL or ClickHouse query and rewrite it to run faster.
- Part of PostHog/posthog
- 148 installs
- Data · Analytics
When to use it
You have a slow insight, query runner, or hand-written ClickHouse query and need to find why it's slow and fix it.
For example
You say
My HogQL insight over events is timing out. Here's the query — help me optimize it.
You get
- Printed ClickHouse SQL
- Rewritten HogQL query
- Explanation of the fix
How it works
- Works from the generated ClickHouse SQL rather than the HogQL, then translates fixes back.
- Flags common smells like FROM ... FINAL, JSONExtract on properties, and self-joins.
More Analytics skills
See all- accelerated-computing-cudf3.2kGuides GPU DataFrame work with cuDF, including pandas acceleration, joins, groupby, file I/O and multi-GPU jobs.
- cudf-query-engine-builder15Builds a first single-GPU cuDF path inside a query engine, covering C++ or Java implementation and buffer ownership.
- lance-user-guide7Shows how to read and write Lance datasets and build vector or scalar indexes, including filter and performance tips.
- data_analysis4Runs auditable math and descriptive statistics on data you have already confirmed.
Also in this pack
- react-doctor511Diagnoses and fixes React codebase health issues, including performance problems, security gaps and code quality.
- hogli267Explains the PostHog developer CLI and repo tooling for running, building, testing, and linting.
- clickhouse-migrations266Writes and modifies ClickHouse database migrations following project rules.
- survey-sdk-audit255Audits survey SDK features and version requirements, then implements survey changes across backend, UI, and SDKs.