/ History for tool/spaceanal.tcl
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for tool/spaceanal.tcl

2020-06-19
13:33
[a95036b3] part of check-in [9536fa0a] Further refactoring of the schema table name. (check-in: [9536fa0a] user: drh branch: trunk, size: 30307)
2020-04-22
13:49
[c161d838] part of check-in [8789368b] Fix an off-by-one error in the "calculated" page count output from the sqlite3_analyzer utility for databases that are more than 1GB in size. (check-in: [8789368b] user: drh branch: trunk, size: 30307)
2017-10-31
14:56
[4bfd19aa] part of check-in [bb39744f] Update the built procedures for the sqlite3_analyzer utility to allow it to be linked with an external sqlite3.o library. Automatically detect a missing dbstat extension and report the compile-time error. (check-in: [bb39744f] user: drh branch: trunk, size: 30216)
2017-06-15
16:45
[f40dc82b] part of check-in [ca1ff707] Fix typo and improve the wording of the description of "Metadata" in the output of the sqlite3_analyzer tool. (check-in: [ca1ff707] user: drh branch: trunk, size: 29766)
00:52
[a91e09e9] part of check-in [43ad41ef] Enhance the sqlite3_analyzer.exe utility so that it computes and shows the number of bytes of metadata on btree pages and per table and index entry. (check-in: [43ad41ef] user: drh branch: trunk, size: 29703)
2016-10-12
18:26
[ab7d9bf6] part of check-in [e87d02d2] Add to sqlite3_analyzer command-line options --version and --tclsh, and also the undocumented --debug option. (check-in: [e87d02d2] user: drh branch: trunk, size: 28864)
2016-05-06
15:16
[85d90e66] part of check-in [dc37750d] Fix a bug in sqlite_analyzer causing it report (slightly) incorrect values for the number of entries in indexes or WITHOUT ROWID tables. (check-in: [dc37750d] user: dan branch: trunk, size: 27711)
2015-09-08
17:31
[93c1fdc9] part of check-in [33a14e7b] Fix the help message that sqlite3_analyzer.exe generates for invalid arguments. (check-in: [33a14e7b] user: drh branch: trunk, size: 27565)
2015-08-04
19:06
[63a41538] part of check-in [783f78e3] Improve the usage comment on sqlite3_analyzer: show the available switches. (check-in: [783f78e3] user: drh branch: trunk, size: 27121)
14:18
[ac584838] part of check-in [cd997770] In the sqlite3_analyzer.exe utility, show the depth of each btree and report the average fanout of indexes and WITHOUT ROWID tables. (check-in: [cd997770] user: drh branch: trunk, size: 27096)
2015-05-11
17:46
[713c587a] part of check-in [85a4a46c] Test cases for sqlite3_analyzer and sqldiff. Fix a problem with sqlite3_analyzer related to the renaming of the initialization routine. (check-in: [85a4a46c] user: drh branch: trunk, size: 27317)
2015-02-09
17:46
[d5a09620] part of check-in [937e0fe7] Fix WITHOUT ROWID table handing in sqlite3_analyzer. (check-in: [937e0fe7] user: dan branch: trunk, size: 27341)
2013-11-02
11:43
[8e50b217] part of check-in [ac711459] Import the sqlite3_analyzer fixes from trunk. (check-in: [ac711459] user: drh branch: omit-rowid, size: 26820)
11:34
[81fad690] part of check-in [42a11e74] A pair of sqlite3_analyzer bug fixes: (1) quote strings in the SQL at the end of the output. (2) Fix test_stat.c so that it no longer misses some overflow pages on internal index pages. (check-in: [42a11e74] user: drh branch: trunk, size: 26822)
2013-11-01
20:30
[00023972] part of check-in [f9769d70] Fix sqlite3_analyzer so that it works with WITHOUT ROWID tables. Fix index generation for secondary indices that include fields from the PRIMARY KEY. (check-in: [f9769d70] user: drh branch: omit-rowid, size: 26818)
2013-09-28
12:40
[d8c11da1] part of check-in [3e5c7771] Updates to the sqlite3_analyzer utility: Change the names of some labels, especially change "Fragmentation" to "Non-sequential pages". Revise the computation of non-sequential pages so that it ignores itercalated non-leaf pages (overflow and index pages). (check-in: [3e5c7771] user: drh branch: trunk, size: 26820)
2013-07-17
18:12
[f87fc8e4] part of check-in [3b4096cc] Enhance the sqlite3_analyzer tool to give reports on the sizes of individual indices. (check-in: [3b4096cc] user: drh branch: trunk, size: 26574)
2012-10-10
10:52
[76f583a2] part of check-in [6dc987d3] Add support for URI filenames in sqlite3_analyzer. (check-in: [6dc987d3] user: drh branch: trunk, size: 26090)
2012-04-06
00:09
[e4227300] part of check-in [1bfc30cb] Update sqlite3_analyzer to correctly find all database files when the multiplexor is being used. (check-in: [1bfc30cb] user: drh branch: trunk, size: 25910)
2011-10-10
16:06
[15f6cd93] part of check-in [e5169f9a] Enhance sqlite3_analyzer so that it is able to deal with multiplexed databases that have 8+3 filenames. (check-in: [e5169f9a] user: drh branch: trunk, size: 25946)
2011-10-05
19:46
[2dc915c2] part of check-in [baa80c7b] Add the --pageinfo and --stats options to the sqlite3_analyzer utility. (check-in: [baa80c7b] user: drh branch: trunk, size: 25333)
18:18
[7ba8b978] part of check-in [fa5ed532] Update the sqlite3_analyzer utility program to provide more details about the compression performance of ZIPVFS database files. (check-in: [fa5ed532] user: drh branch: trunk, size: 23688)
2011-09-28
00:50
[58d35738] part of check-in [19b8eaaf] Enhance the stat VFS to report out the total size of all pages used by a table, even if the ZIPVFS compression backend is in play. Update the sqlite3_analyzer logic to use these new outputs. (check-in: [19b8eaaf] user: drh branch: trunk, size: 22173)
2011-09-27
13:40
[7591cccc] part of check-in [8c846311] Changes to sqlite3_analyzer to try to avoid integer overflow problems when linking against older versions of TCL. (check-in: [8c846311] user: drh branch: trunk, size: 21810)
2011-09-26
19:32
[a7ffc29b] part of check-in [d82cffab] Changes to the analyzer script to make it work with zipvfs databases. (check-in: [d82cffab] user: dan branch: trunk, size: 21788)
2011-09-21
20:10
[537f35d9] part of check-in [3a261f38] Minor tweaks to the TCL code for sqlite3_analyzer. (check-in: [3a261f38] user: drh branch: trunk, size: 21481)
2011-09-15
00:40
[fe02dede] part of check-in [3fc566ac] Cleanup/fix error handling when no arguments are supplied to the SQLite analyzer. (check-in: [3fc566ac] user: mistachkin branch: trunk, size: 21465)
2011-08-31
17:46
[1ee4df4e] part of check-in [df550066] Backslash escaping is not working right in tostr.awk on the latest ubuntu. The easiest fix is to simply not use any backslashes in the spaceanal.tcl script. (check-in: [df550066] user: drh branch: trunk, size: 21348)
2010-07-12
08:39
[b91879d5] part of check-in [86159cb3] Changes so that the space-analyzer script works with 3.7.0. (check-in: [86159cb3] user: dan branch: trunk, size: 21357)
2007-12-04
13:41
[b87db46a] part of check-in [7c2cf454] Fix a bug in the TCL code for sqlite3_analyzer. (CVS 4590) (check-in: [7c2cf454] user: drh branch: trunk, size: 30555)
2007-02-13
01:41
[f60a242a] part of check-in [31e5073c] Explanation of the "fragmentation" line is added to the help message at the end of the output of sqlite3_analyzer. (CVS 3636) (check-in: [31e5073c] user: drh branch: trunk, size: 30481)
01:38
[5c7b0174] part of check-in [82aed271] Additional fixes to the new fragmentation feature of sqlite3_analyzer. (CVS 3635) (check-in: [82aed271] user: drh branch: trunk, size: 30155)
2007-02-10
19:22
[2614b0c9] part of check-in [bd6bc3b8] Changes to support fragmentation analysis in sqlite3_analyzer. (CVS 3634) (check-in: [bd6bc3b8] user: drh branch: trunk, size: 30192)
2006-10-03
12:08
[f4ca4843] part of check-in [e774adce] Fix sqlite3_analyzer so that it works when compiled against Tcl8.5. (CVS 3458) (check-in: [e774adce] user: drh branch: trunk, size: 28936)
12:04
[347bb735] part of check-in [47c8567f] Fix sqlite3_analyzer so that it works on databases containing virtual tables. (CVS 3457) (check-in: [47c8567f] user: drh branch: trunk, size: 28924)
2006-02-09
02:41
[9e134a26] part of check-in [8b3068ac] Use 64-bit integers in sqlite3_analyzer. Ticket #1666. (CVS 3059) (check-in: [8b3068ac] user: drh branch: trunk, size: 28906)
2006-01-24
02:19
[ceaee5ce] part of check-in [388b9262] Sqlite3_analyzer reports an error if it runs into trouble. (CVS 3021) (check-in: [388b9262] user: drh branch: trunk, size: 28690)
2005-03-29
13:18
[5b47b70b] part of check-in [d89aaba5] Fix minor display bugs in sqlite3_analyzer. (CVS 2431) (check-in: [d89aaba5] user: drh branch: trunk, size: 28615)
2005-02-01
10:36
[184f5e59] part of check-in [52e473b9] Space analyzer: Format integer results as integers. Also fix the calculation of average-fanout. (CVS 2304) (check-in: [52e473b9] user: danielk1977 branch: trunk, size: 28610)
2004-11-09
07:42
[102d6dcb] part of check-in [63f2ee22] Refactor the space-analysis script for readability. (CVS 2081) (check-in: [63f2ee22] user: danielk1977 branch: trunk, size: 28088)
2004-11-08
16:15
[a1ba7f05] part of check-in [1cb80866] Update the space-analyzer tool to support auto-vacuum databases. (CVS 2080) (check-in: [1cb80866] user: danielk1977 branch: trunk, size: 21186)
2004-07-23
00:01
[c8c39c46] part of check-in [7c7f698b] First cut at a analysis tool for version 3.0 databases. (CVS 1862) (check-in: [7c7f698b] user: drh branch: trunk, size: 18347) Added
2004-06-19
11:57
[fec99070] part of check-in [06bf4c7e] Add the source code to the sqlite_analyzer utility. (CVS 1637) (check-in: [06bf4c7e] user: drh branch: version_2, size: 15334) Added