culiops/culiops-skills / skills/sre-investigate
sre-investigate
Unverifiedanalytics/sql/cloudfront/cache_results.sql
View on GitHub-- Requests, share and bytes per edge result type (Hit, Miss, RefreshHit, Error, ...; top 50); hit_ratio = Hit / all viewer requests (RefreshHit not counted as a hit). If sampled: requests and bytes scale by the factor; share and hit_ratio do not scale.
-- hit_ratio follows the CloudFront cache statistics report: https://docs.aws.amazon.com/AmazonCloudFront/latest/DeveloperGuide/cache-statistics.html
WITH g AS (
SELECT x_edge_result_type, count(*) AS requests, sum(sc_bytes) AS bytes FROM logs GROUP BY x_edge_result_type
)
SELECT x_edge_result_type, requests, round(requests / sum(requests) OVER (), 4) AS share,
round(coalesce((SELECT sum(requests) FROM g WHERE x_edge_result_type = 'Hit'), 0) / sum(requests) OVER (), 4) AS hit_ratio,
bytes
FROM g
ORDER BY requests DESC, x_edge_result_type
LIMIT 50
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |