Codex 越用越卡？先查 logs_2.sqlite 有没有高频写盘

帮我检测 ~/.codex/logs_2.sqlite 是否因 TRACE 日志持续高频写盘？

要求：
1. 不打印日志正文，不上传 sqlite 文件。
2. 只看主库体积、WAL 体积、最近 60 秒 TRACE 数量。
3. 做一个 30 秒静默窗口：记录起点，等待 30 秒，记录终点。
4. 输出新增行数、TRACE 行数、每秒新增行数和 WAL 变化。
5. 如果确认 TRACE 级日志持续高频写盘，给我关闭 Codex trace 级日志的处理方案。

param(
    [int]$WaitSeconds = 30,
    [string]$CodexDir = "$env:USERPROFILE\.codex"
)

$ErrorActionPreference = "Stop"

$db = Join-Path $CodexDir "logs_2.sqlite"
$wal = Join-Path $CodexDir "logs_2.sqlite-wal"

if (-not (Test-Path -LiteralPath $db)) {
    throw "Cannot find $db"
}

$py = @'
import os
import sqlite3
import sys
import time
from collections import defaultdict

db = sys.argv[1]
wal = sys.argv[2]
wait_seconds = int(sys.argv[3])

def file_size(path):
    try:
        return os.path.getsize(path)
    except FileNotFoundError:
        return 0

def mib(n):
    return f"{n / 1024 / 1024:.3f} MiB"

def connect_ro(path):
    uri = "file:" + os.path.abspath(path).replace("\\", "/") + "?mode=ro"
    con = sqlite3.connect(uri, uri=True, timeout=5)
    con.execute("PRAGMA query_only=ON")
    return con

def snapshot():
    con = connect_ro(db)
    try:
        count, max_id = con.execute("SELECT COUNT(*), COALESCE(MAX(id), 0) FROM logs").fetchone()
        return {"count": count, "max_id": max_id, "wal_bytes": file_size(wal)}
    finally:
        con.close()

def rows_after(max_id):
    con = connect_ro(db)
    try:
        cur = con.execute("SELECT * FROM logs WHERE id > ? ORDER BY id ASC", (max_id,))
        names = [desc[0] for desc in cur.description]
        level_i = names.index("level") if "level" in names else None
        by_level = defaultdict(int)
        total_rows = 0
        for row in cur:
            total_rows += 1
            level = str(row[level_i]) if level_i is not None and row[level_i] is not None else "(unknown)"
            by_level[level] += 1
        return total_rows, by_level
    finally:
        con.close()

print("Codex log quiet-window check")
print("Database:", db)
print("DB size:", mib(file_size(db)))
print("WAL size:", mib(file_size(wal)))
print()

before = snapshot()
print(f"before_count|{before['count']}|before_max_id|{before['max_id']}|before_wal_bytes|{before['wal_bytes']}")
print(f"waiting_seconds|{wait_seconds}")
sys.stdout.flush()
time.sleep(wait_seconds)

after = snapshot()
new_rows, by_level = rows_after(before["max_id"])
rows_per_second = new_rows / max(wait_seconds, 1)

print(f"after_count|{after['count']}|after_max_id|{after['max_id']}|after_wal_bytes|{after['wal_bytes']}")
print(f"new_visible_rows_after_before_max_id|{new_rows}")
print(f"rows_per_second|{rows_per_second:.2f}")
print()
print("levels_added")
for level, count in sorted(by_level.items(), key=lambda kv: (-kv[1], kv[0])):
    print(f"{level}|{count}")

print()
print("Privacy note: this script prints aggregate counts only. It does not print log bodies.")
'@

$tmp = New-TemporaryFile
try {
    Set-Content -LiteralPath $tmp -Value $py -Encoding UTF8
    python $tmp $db $wal $WaitSeconds
}
finally {
    Remove-Item -LiteralPath $tmp -Force -ErrorAction SilentlyContinue
}