sqlite3_analyzer1
Sqlite3 database space usage analyzis tool
Usage
sqlite3_analyzer [--pageinfo]
[--stats]
[--tclsh]
[--version]
database.sqlite
Overview
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