culiops/culiops-skills / skills/sre-investigate
sre-investigate
Unverifiedanalytics/sql/alb/summary.sql
View on GitHub-- One-row overview of the ALB dataset: window, requests, clients, bytes, status classes, 5xx with no target response (timeouts and refused connections included) and p95 target time over requests that have one. If sampled: requests, sent_bytes, status_*, no_target_5xx and no_target_time_requests scale by the factor; distinct_clients are lower bounds; p95_target_seconds does not scale.
SELECT min(ts) AS first_ts, max(ts) AS last_ts, count(*) AS requests, count(DISTINCT client_ip) AS distinct_clients,
sum(sent_bytes) AS sent_bytes,
count(*) FILTER (WHERE elb_status_code BETWEEN 200 AND 299) AS status_2xx,
count(*) FILTER (WHERE elb_status_code BETWEEN 300 AND 399) AS status_3xx,
count(*) FILTER (WHERE elb_status_code BETWEEN 400 AND 499) AS status_4xx,
count(*) FILTER (WHERE elb_status_code BETWEEN 500 AND 599) AS status_5xx,
count(*) FILTER (WHERE elb_status_code BETWEEN 500 AND 599 AND target_status_code IS NULL) AS no_target_5xx,
count(*) FILTER (WHERE target_processing_time IS NULL OR target_processing_time < 0) AS no_target_time_requests,
round(quantile_cont(target_processing_time, 0.95) FILTER (WHERE target_processing_time >= 0), 3) AS p95_target_seconds
FROM logs
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 |