All skills
generating-clickhouse-query-performance-reports
Produce a structured slow-query performance report for PostHog's production ClickHouse clusters.
- Part of PostHog/posthog
- 142 installs
- Developer Tools · Backend
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.
More Backend skills
See all- golang-pro19.8kWrites concurrent Go services with goroutines, channels, gRPC or REST, and profiles performance.
- php-pro16.4kBuilds modern PHP applications with strict typing, Laravel or Symfony, tests and REST or GraphQL APIs.
- cuopt-routing-api-python2.3kBuilds and solves vehicle routing, traveling salesman, and pickup-delivery problems in Python with cuOpt.
- cuopt-server-api-python2.2kStarts the cuOpt REST server and calls its endpoints from Python or curl.
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.