Scroll to navigation

SQLITE3_ANALYZER(1) General Commands Manual SQLITE3_ANALYZER(1)

NAME

sqlite3_analyzerSQLite3 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

Show how each page of the database-file is used
Output SQL text that creates a new database containing statistics about the database that was analyzed
Run the built-in TCL interpreter interactively (for debugging)
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