NAME¶

sqlite3_analyzer — SQLite3 database space usage analyzis tool

SYNOPSIS¶

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.