1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
.Dd 2018-07-22
.Dt SQLITE3_ANALYZER 1
.Os "Debian GNU/Linux"
.Sh NAME
.Nm sqlite3_analyzer
.Nd SQLite3 database space usage analyzis tool
.Sh SYNOPSIS
.Nm
.Op Fl -pageinfo
.Op Fl -stats
.Op Fl -tclsh
.Op Fl -version
.Ar database.sqlite
.Sh DESCRIPTION
.Nm
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.
.Pp
.Sh OPTIONS
.Bl -tag -width indent
.It Fl -pageinfo
Show how each page of the database-file is used
.It Fl -stats
Output SQL text that creates a new database containing
statistics about the database that was analyzed
.It Fl -tclsh
Run the built-in TCL interpreter interactively (for debugging)
.It Fl -version
Show the version number of SQLite
.El
.Sh AUTHOR
.Nm
has been written by
.An D. Richard Hipp Aq drh@hwaci.com .
.Pp
This manual page was written by
.An Yuriy M. Kaminskiy Aq yumkam+debian@gmail.com
for the Debian GNU/Linux system.
|
