Weekly digest — Sowknow
Weekly digest (top 3 · MEASURED — every item links its evidence)
Ranking rule: severity weight (critical 3 /
warning 2 / info 1) + 1 persistent across both latest exams or a standing flag
+ 1 measured worsening trend; ties break actionable-first (a matched KB skill),
then severity, then title. Advice climbs the ladder: digest → proposal →
approve → gated fix. Nothing here was executed.
| Severity | Improvement | Score | KB skill (ladder) | Evidence |
|---|---|---|---|---|
| warning | SSL off while listening on '*' | 3 · persistent | no matching KB skill | {
"listen_addresses": "*",
"port": "5432",
"ssl": "off",
"target_db": "sowknow"
} |
| warning | active connection as superuser 'sowknow' | 3 · persistent | no matching KB skill | {
"is_scanner_role": false,
"target_db": "sowknow",
"usename": "sowknow"
} |
| info | connections 8/100 in use (8%) | 2 · persistent | terminate_idle_connections_bulk propose | {
"current_connections": 8,
"max_connections": 100,
"target_db": "sowknow",
"used_pct": 8.0
} |
Capacity (measured history → days-to-limit)
disk_used_pct
—only 0 measured point(s) — history too thin to forecast
disk_used_pct
—only 0 measured point(s) — history too thin to forecast
inode_used_pct
—only 0 measured point(s) — history too thin to forecast
pg_conn_used_pct
3028.8dto limit 80.0 — now 10.0, +0.02327/day
mem_used_pct
—only 0 measured point(s) — history too thin to forecast
fd_used_pct
—only 0 measured point(s) — history too thin to forecast
replication_lag_seconds
—only 0 measured point(s) — history too thin to forecast
cert_days_remaining
—only 0 measured point(s) — history too thin to forecast
pl_dlq_24h
—no measurable trend in the measured history
pl_stages_stuck
—only 0 measured point(s) — history too thin to forecast
pl_stages_stuck
—only 0 measured point(s) — history too thin to forecast
pl_docs_backlog
—no measurable trend in the measured history
celery_workers
—no measurable trend in the measured history