What's new

AdGuardHome Open AdGuard Home stats file

  • SNBForums Code of Conduct

    SNBForums is a community for everyone, no matter what their level of experience.

    Please be tolerant and patient of others, especially newcomers. We are all here to share and learn!

    The rules are simple: Be patient, be nice, be helpful or be gone!


Regular Contributor
AdGuard Home has a stats.db file located at:
# ls -lah /opt/etc/AdGuardHome/data/stats.db
-rw-r--r--    1 root   root        4.0M Mar 10 21:00 /opt/etc/AdGuardHome/data/stats.db

Initially I thought it was SQLite file, but when I tried to open it, SQLite says the file is not a database.
# sqlite3 /opt/etc/AdGuardHome/data/stats.db
SQLite version 3.40.0 2022-11-16 12:10:08
Enter ".help" for usage hints.
sqlite> .dbinfo
sqlite> .databases
main: /tmp/mnt/entware/entware/etc/AdGuardHome/data/stats.db r/w
sqlite> .dbinfo
error: file is not a database

The same happens for the sessions.db file.

How can I open these .db files?

Latest threads

Sign Up For SNBForums Daily Digest

Get an update of what's new every day delivered to your mailbox. Sign up here!