Search
PostHog · Query optimization
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU). | PostHog/ | 40k | — | ~5.1k | Automated safety check: Pass | Unknown | today |
| 2 | Pull and interpret production experiment query-performance data from the staff-only /api/debugchqueries endpoints backing the /experiments/staff scene: slowest experiment queries, precompute… | PostHog/ | 40k | — | ~3.7k | Automated safety check: Pass | Unknown | today |
| 3 | Determine which PostHog team owns a file, directory, or code path, or enumerate all code a team owns (via distributed owners.yaml, products//product.yaml, and .github/CODEOWNERS). | PostHog/ | 40k | — | ~1.5k | Automated safety check: Pass | Unknown | today |
| 4 | Explore and diagnose a PostHog endpoint's execution logs — error messages, failed runs, cache misses, slow runs, or unexpected row counts during endpoint invocations. | PostHog/ | 40k | — | ~1.7k | Automated safety check: Pass | Unknown | today |
| 5 | Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT). | PostHog/ | 40k | — | ~2.5k | Automated safety check: Notes | Unknown | today |
| 6 | Runs read-only production database analysis through PostHog's internal Metabase instances. | PostHog/ | 40k | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 7 | Profiles slow PostHog API endpoints when the main cost is in Postgres or Python. | PostHog/ | 40k | — | ~1k | Automated safety check: Pass | Unknown | today |
