culiops/culiops-skills / skills/sre-investigate
sre-investigate
Unverifiedanalytics/sql/cloudfront/by_object.sql
View on GitHub-- Requests, bytes and edge result for one object path; required param: object (exact URI path, e.g. /api/orders), a missing param is an error. If sampled: requests and bytes scale by the factor.
WITH p AS (
SELECT CASE WHEN getvariable('object') IS NULL THEN error('param object is required') ELSE getvariable('object') END AS object
)
SELECT cs_uri_stem, sc_status, x_edge_result_type, count(*) AS requests, sum(sc_bytes) AS bytes
FROM logs, p
WHERE cs_uri_stem = p.object
GROUP BY ALL
ORDER BY requests DESC, sc_status, x_edge_result_type
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 |