culiops/culiops-skills / skills/sre-investigate
sre-investigate
Unverifiedanalytics/sql/alb/lb_vs_target_status.sql
View on GitHub-- 5xx split by whether a target answered: no_target_response (target_status_code is -: the LB answered itself, or the target timed out, refused or closed the connection, or none was healthy) vs target_responded; error_reason is the LB's logged reason. If sampled: requests scale by the factor.
SELECT elb_status_code,
CASE WHEN target_status_code IS NULL THEN 'no_target_response' ELSE 'target_responded' END AS origin,
coalesce(error_reason, '-') AS error_reason,
count(*) AS requests
FROM logs
WHERE elb_status_code BETWEEN 500 AND 599
GROUP BY ALL
ORDER BY elb_status_code, origin, error_reason
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 |