table of contents
SQLITE3_ANALYZER(1) | General Commands Manual | SQLITE3_ANALYZER(1) |
NAME¶
sqlite3_analyzer
—
SQLite3 database space usage analyzis
tool
SYNOPSIS¶
sqlite3_analyzer |
[--pageinfo ]
[--stats ]
[--tclsh ]
[--version ]
database.sqlite |
DESCRIPTION¶
sqlite3_analyzer
program analyze
an SQLite database file and output a report detailing size and
storage efficiency information for the database and its constituent
tables and indexes.
OPTIONS¶
--pageinfo
- Show how each page of the database-file is used
--stats
- Output SQL text that creates a new database containing statistics about the database that was analyzed
--tclsh
- Run the built-in TCL interpreter interactively (for debugging)
--version
- Show the version number of SQLite
AUTHOR¶
sqlite3_analyzer
has been
written by D. Richard Hipp
⟨drh@hwaci.com⟩.
This manual page was written by Yuriy M. Kaminskiy ⟨yumkam+debian@gmail.com⟩ for the Debian GNU/Linux system.
2018-07-22 | Debian GNU/Linux |