Man page - sqlite3_analyzer(1)

Packages contains this manual

Package:  sqlite3-tools
apt-get install sqlite3-tools

Manuals in package:
• sqlite3_analyzer(1)
• sqldiff(1)
Documentations in package:
• sqlite3-tools

Manual

---

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. Debian GNU/Linux 2018-07-22 SQLITE3_ANALYZER (1)

---