---
name: "sqlite3_analyzer"
section: "1"
platform: "linux"
package: "sqlite3-tools"
version: "3.46.1-7+deb13u2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/sqlite3_analyzer"
---

# sqlite3\_analyzer(1)

SQLite3 database space usage analyzis tool

## 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.