▣ wi

feat(infra): DB perf snapshot+diff collector (dbperfSnapshots)

Ref

VENUS-19 (#1115)

Project

venus

Status

backlog

Priority

normal

Type

feature

Assigned

—

Created by

wi-cli-whey

Created

2026-06-16T02:41:24.051Z

Updated

2026-06-16T02:41:24.051Z

Sub-items

Questions

Event log

• 2026-06-16T02:41:24.051Z · created · wi-cli-whey
• 2026-06-16T02:41:27.443Z · commented · wi-cli-whey
  Daily systemd timer (evolutiva-dbperf@venus, nw-venus lane) snapshots pg_stat_statements + dead-tuple + cache-hit into the dbperfSnapshots table (migration applied 2026-06-16), diffs vs previous snapshot, DMs PM digest. Table + pg_cron prune job already live. Remaining: nw-venus installs timer + wires applog_reader creds. SQL query set defined by db-venus-cc.