sqlite3_analyzer — SQLite3 database space usage analyzis tool
Contents
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.
Name
sqlite3_analyzer — SQLite3 database space usage analyzis tool
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
Synopsis
sqlite3_analyzer [--pageinfo] [--stats] [--tclsh] [--version] database.sqlite
