9 # Get the name of the database to analyze
39    name clob,        -- Name of a table or index in the database file
40    tblname clob,     -- Name of associated table
42    nentry int,       -- Number of entries in the BTree
43    payload int,      -- Total amount of data stored in this table or index
45    n_ovfl int,       -- Number of entries that overflow
46    pri_pages int,    -- Number of primary pages used
47    ovfl_pages int,   -- Number of overflow pages used
48    pri_unused int,   -- Number of unused bytes on primary pages
49    ovfl_unused int   -- Number of unused bytes on overflow pages
111 # Generate a single line of output in the statistics section of the
139 # Generate a subreport that covers some subset of the database.
164   statline "Percentage of total database" \
166   statline "Number of entries" $nentry
168   statline "Bytes of storage consumed" $storage
169   statline "Bytes of payload" $payload [percent $payload $storage]
170   statline "Bytes of data" $data [percent $data $storage]
172   statline "Bytes of key" $key [percent $key $storage]
197 puts "*** As of [clock format [clock seconds] -format {%Y-%b-%d %H:%M:%S}]"
215 statline {Number of tables in the database} $ntable
220 statline {Number of indices} $nindex
221 statline {Number of named indices} $manindex [percent $manindex $nindex]
228 statline "Size of the file in bytes" $fsize
229 statline "Bytes of payload stored" $total_payload \
231 statline "Bytes of user data stored" $bytes_data \
261     subreport "Indices of table $name" "tblname='$qn' AND is_index"
272 Number of pages in the whole file
274     The number of 1024-byte pages that go into forming the complete database
278     The number of pages that store data, either as primary B*Tree pages or
280     the total number of pages in the file.
284     The number of pages that are not currently in use but are reserved for
285     future use.  The percentage at the right is the number of freelist pages
286     divided by the total number of pages in the file.
290     The number of pages of header overhead in the database.  This value is
291     always 1.  The percentage at the right is the number of header pages
292     divided by the total number of pages in the file.
294 Number of tables in the database
296     The number of tables in the database, including the SQLITE_MASTER table
299 Number of indices
301     The total number of indices in the database.
303 Number of named indices
305     The number of indices created using an explicit CREATE INDEX statement.
309     The number of indices used to implement PRIMARY KEY or UNIQUE constraints
312 Size of the file in bytes
314     The total amount of disk space used by the entire database files.
316 Bytes of payload stored
318     The total number of bytes of payload stored in the database.  Payload
319     includes both key and data.  The content of the SQLITE_MASTER table is
323 Bytes of user data stored
325     The total number of bytes of data stored in the database, not counting
330 Percentage of total database
332     The amount of the complete database file that is devoted to storing
335 Number of entries
337     The total number of B*Tree key/value pairs stored under this category.
339 Bytes of storage consumed
341     The total amount of disk space required to store all B*Tree entries
342     under this category.  The is the total number of pages used times
345 Bytes of payload
347     The amount of payload stored under this category.  Payload is the sum
348     of keys and data.  Each table entry has 4 bytes of key and an arbitrary
349     amount of data.  Each index entry has 4 or more bytes of key and no
350     data.  The percentage at the right is the bytes of payload divided by
351     the bytes of storage consumed.
353 Bytes of data
355     The amount of data stored under this category.  The data space reported
358     of data divided by bytes of storage consumed.
360 Bytes of key
362     The sum of the sizes of all keys under this category.  The percentage at
363     the right is the bytes of key divided by the bytes of storage consumed.
367     The average amount of payload on each entry.  This is just the bytes of
368     payload divided by the number of entries.
372     The average amount of free space remaining on all pages under this
373     category on a per-entry basis.  This is the number of unused bytes on
374     all pages divided by the number of entries.
378     The largest payload size of any entry.
382     Up to 236 bytes of payload for each entry are stored directly in the
384     of overflow pages.  This is the number of entries that exceed 236 bytes
385     in size.  The value to the right is the number of entries that overflow
386     divided by the total number of entries.
390     This is the number of 1024 byte pages used to hold all information in
391     the current category.  This is the sum of primary and overflow pages.
395     This is the number of primary B*Tree pages used.
399     The total number of overflow pages used for this category.
403     The total number of bytes of unused space on all primary pages.  The
404     percentage at the right is the number of unused bytes divided by the
405     total number of bytes on primary pages.
409     The total number of bytes of unused space on all overflow pages.  The
410     percentage at the right is the number of unused bytes divided by the
411     total number of bytes on overflow pages.
415     The total number of bytes of unused space on all primary and overflow 
416     pages.  The percentage at the right is the number of unused bytes 
417     divided by the total number of bytes.
423 puts "The entire text of this report can be sourced into any SQL database"
424 puts "engine for further analysis.  All of the text above is an SQL comment."

Indexes created Tue Jul 24 14:28:13 CEST 2018