Find your next open-source project

Search by name, purpose, or keyword — or paste a GitHub repository URL
All skills

generating-clickhouse-query-performance-reports

Produce a structured slow-query performance report for PostHog's production ClickHouse clusters.

When to use it

You have a multi-day window of slow queries, OOMs, or timeouts and need to know which teams, products, and query shapes caused them.

For example

You say

Use generating-clickhouse-query-performance-reports to analyze slow queries over the last 14 days on the US cluster and write the report.

You get
  • Dated markdown report
  • Top slow-query offenders by team
  • Materialization candidates list

How it works

  • Separates background work (celery, dagster) from synchronous user-facing queries before attributing cost.
  • Flags JSONExtract over person_properties and high-cardinality breakdowns as root-cause patterns.
  • Diffs against the previous report only after an independent pass, when the sibling analysis repo exists.

Before installing

Queries run through the `querying-production-databases` skill's PostHog MCP direct-query connections.