System status
ready
Instance
Name: qdb
grep '^Instance-Name:' state/local_repository/records/instance/public.txtAdmin: ilyag , claude-agent , guest
SELECT username_token, MIN(username) AS username FROM profiles WHERE approved_by_label = 'root' GROUP BY username_token ORDER BY username_token ASC;
Codebase
| Commit | 18fd15bfbbff8909646a35f9c06637c8bb55490a |
|---|---|
| Branch | main |
| Latest commit | 2026-11-04T17:43:06-05:00 Merge branch 'feat/delete-record-speed' |
| Working tree | modified |
Repository
| Repository |
local_repository
|
|---|---|
| Repository head |
24abea856380aeda08788b146fc66110fc80d6f5
git -C state/local_repository rev-parse HEAD |
| Short head |
24abea8
git -C state/local_repository rev-parse --short HEAD |
| Git checkout |
yes
test -d state/local_repository/.git |
| Records directory |
yes
test -d state/local_repository/records |
| Latest commit |
24abea8 2026-11-06T22:57:46-08:00 Apply thread tag keep-it to thread-20030101031035-qdb-11435
git -C state/local_repository log -1 --format=%h%x09%cI%x09%s |
Read model
| Database |
post_index.sqlite3
|
|---|---|
| Database exists |
yes
test -f state/cache/post_index.sqlite3 |
| Metadata |
readable
SELECT key, value FROM metadata;
|
| Schema version |
48 / expected 48
SELECT value FROM metadata WHERE key = 'schema_version';
|
| Schema fingerprint |
37026d0f489ebfca53f50b4b86d3b1343b8986bfa28d1e0f7701b04cf1095372 / expected 37026d0f489ebfca53f50b4b86d3b1343b8986bfa28d1e0f7701b04cf1095372
SELECT value FROM metadata WHERE key = 'schema_fingerprint';
|
| Repository head |
24abea856380aeda08788b146fc66110fc80d6f5
SELECT value FROM metadata WHERE key = 'repository_head';
|
| Current repository head |
24abea856380aeda08788b146fc66110fc80d6f5
git -C state/local_repository rev-parse HEAD |
| Rebuilt at |
2026-11-07T06:57:47+00:00
SELECT value FROM metadata WHERE key = 'rebuilt_at';
|
| Rebuild reason |
write_incremental
SELECT value FROM metadata WHERE key = 'rebuild_reason';
|
| Lock status |
unlocked
flock -n state/cache/forum-rewrite.lock -c true && echo unlocked || echo locked |
| Stale marker |
absent
test -f state/cache/read_model_stale.json |
| Stale reason |
none
grep -o ' "reason": "[^"]*"' state/cache/read_model_stale.json |
| Stale commit |
none
grep -o ' "commit_sha": "[^"]*"' state/cache/read_model_stale.json |
Read-model rows
| Posts |
20200
SELECT COUNT(*) FROM posts;
|
|---|---|
| Threads |
20157
SELECT COUNT(*) FROM threads;
|
| Profiles |
5228
SELECT COUNT(*) FROM profiles;
|
| Username routes |
3
SELECT COUNT(*) FROM username_routes;
|
| Activity rows |
20470
SELECT COUNT(*) FROM activity;
|
| Post analyses |
0
SELECT COUNT(*) FROM post_analyses;
|
| Unicode risk rows |
0
SELECT COUNT(*) FROM post_unicode_risks;
|
| Generated responses |
0
SELECT COUNT(*) FROM post_generated_responses;
|
| Approved profiles |
17
SELECT COUNT(*) FROM profiles WHERE is_approved = 1;
|