← back to Wallco Ai

data/yolo-overnight/slow-queries-20260525-1150.md

24 lines

# Slow Query Check — 2026-05-25 11:50 PT

## Result: SKIPPED — pg_stat_statements not enabled

### Diagnostics
- DB: `dw_unified` on `127.0.0.1:5432`, user `dw_admin`
- `SELECT ... FROM pg_stat_statements` → `ERROR: relation "pg_stat_statements" does not exist`
- `pg_extension` shows no `pg_stat_statements` row (extension not installed in this DB)
- `SHOW shared_preload_libraries` → permission denied (not superuser); cannot confirm load list directly, but extension is absent regardless

### Conclusion
`pg_stat_statements` is not available on this cluster. Per overnight instructions, slow-query check is skipped.

### To enable later (requires superuser + restart)
1. As `postgres` superuser: `ALTER SYSTEM SET shared_preload_libraries = 'pg_stat_statements';`
2. Restart PostgreSQL: `sudo systemctl restart postgresql`
3. In `dw_unified`: `CREATE EXTENSION pg_stat_statements;`
4. Re-run the slow-query query after workload accumulates.

### No action taken
- No DB writes
- No PM2 restarts
- No git changes