dbstat

vb dbstat [OPTIONS]

Description

Shows statistics and global information about the repository and/or verify the integrity of a repository.

Options

-b, --brief

Only show essential elements

--db-check

Run PRAGMA quick_check on the repository database

--db-verify

Run a full verification of the repository integrity. This involves decoding and reparsing all artifacts and can take significant time.

--omit-version-info

Omit the SQLite and VisionByte version information

Examples

• Init and open a repository

$ vb init dbstat_repo.vbyte
project-id: 0ed7e825f130e5094c969896eb7533364acd1fa3
server-id:  27281cfbaf7d3217af1546a80bd4fc969c778c55
admin-user: ubuntu (initial remote-access password is "ey3uwYcdhS")
$ vb open -f dbstat_repo.vbyte
project-name: <unnamed>
repository:   /tmp/sphinx_tests/6bd2a3e9/dbstat_repo/dbstat_repo.vbyte
local-root:   /tmp/sphinx_tests/6bd2a3e9/dbstat_repo/
config-db:    /tmp/sphinx_tests/6bd2a3e9/.visionbyte
project-code: 0ed7e825f130e5094c969896eb7533364acd1fa3
checkout:     2bd28ee1925eaa13bf83598ee3b0f1385a84c64a 2026-03-31 13:00:12 UTC
tags:         trunk
comment:      initial empty check-in (user: ubuntu)
check-ins:    1

• Add a couple of check-ins so the repository has content

$ vb sys echo "alpha" > alpha.txt
$ vb add alpha.txt
ADDED  alpha.txt
$ vb ci -m "add alpha"
Committed version: b0e40b0c8b3df4dff65fe6a12eb75a18952afb61a0ab3957afaf11d052360ad2

$ vb sys echo "beta" > beta.txt
$ vb add beta.txt
ADDED  beta.txt
$ vb ci -m "add beta"
Committed version: be74346f212befbf23349b11b7b21346d75575278a8f5a45d9cc989bf29c253b

• Show brief database statistics for the repository

$ vb dbstat --brief
repository-size:   217,088 bytes
project-age:       0 days or approximately 0.00 years.
schema-version:    2015-01-24
vb-version:        2026-03-31 12:55:15 [1ba1bfbc9f] [2026.2.26] (gcc-13.3.0)
sqlite-version:    2025-06-06 14:52:32 [b77dc5e0f5] (3.50.1)
database-stats:    53 pages, 4096 bytes/pg, 0 free pages, UTF-8, delete mode