Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for tool/spaceanal.tcl
2024-09-13
| ||
16:10 | [1f83962090] part of check-in [94ceac9884] Close the db as sqlite3_analyzer exits. (See forum post, "sqlite3_analyzer not closing WAL-mode db cleanly" .) (check-in: [94ceac9884] user: larrybr branch: trunk, size: 31021) | |
2024-06-18
| ||
12:19 | [3568b2b15b] part of check-in [4152894433] Update sqlite3_analyzer to report on the number of WITHOUT ROWID tables and to provide separate aggregate statistics for WITHOUT and WITH ROWID tables. (check-in: [4152894433] user: drh branch: trunk, size: 30818) | |
2023-10-14
| ||
10:54 | [70c87c04cf] part of check-in [26a909cdd3] Bug fix in sqlite3_analyzer: for databases larger than 1GiB, take into account the lock-byte page when calculating the number of freelist pages. (check-in: [26a909cdd3] user: drh branch: trunk, size: 30373) | |
2021-07-15
| ||
16:39 | [1b5be34c62] part of check-in [3beb77d6a7] Change references to the schema table in sqlite3_analyzer to the new SQLITE_SCHEMA name. (check-in: [3beb77d6a7] user: drh branch: trunk, size: 30307) | |
2020-06-19
| ||
13:33 | [a95036b366] part of check-in [9536fa0ae0] Further refactoring of the schema table name. (check-in: [9536fa0ae0] user: drh branch: trunk, size: 30307) | |
2020-04-22
| ||
13:49 | [c161d83882] part of check-in [8789368b91] 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: [8789368b91] user: drh branch: trunk, size: 30307) | |
2017-10-31
| ||
14:56 | [4bfd19aad7] part of check-in [bb39744f4b] 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: [bb39744f4b] user: drh branch: trunk, size: 30216) | |
2017-06-15
| ||
16:45 | [f40dc82b4d] part of check-in [ca1ff70780] Fix typo and improve the wording of the description of "Metadata" in the output of the sqlite3_analyzer tool. (check-in: [ca1ff70780] user: drh branch: trunk, size: 29766) | |
00:52 | [a91e09e9e3] part of check-in [43ad41efa9] 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: [43ad41efa9] user: drh branch: trunk, size: 29703) | |
2016-10-12
| ||
18:26 | [ab7d9bf680] part of check-in [e87d02d289] Add to sqlite3_analyzer command-line options --version and --tclsh, and also the undocumented --debug option. (check-in: [e87d02d289] user: drh branch: trunk, size: 28864) | |
2016-05-06
| ||
15:16 | [85d90e6674] part of check-in [dc37750d4e] 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: [dc37750d4e] user: dan branch: trunk, size: 27711) | |
2015-09-08
| ||
17:31 | [93c1fdc973] part of check-in [33a14e7be1] Fix the help message that sqlite3_analyzer.exe generates for invalid arguments. (check-in: [33a14e7be1] user: drh branch: trunk, size: 27565) | |
2015-08-04
| ||
19:06 | [63a415385a] part of check-in [783f78e397] Improve the usage comment on sqlite3_analyzer: show the available switches. (check-in: [783f78e397] user: drh branch: trunk, size: 27121) | |
14:18 | [ac584838dc] part of check-in [cd99777001] 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: [cd99777001] user: drh branch: trunk, size: 27096) | |
2015-05-11
| ||
17:46 | [713c587a05] part of check-in [85a4a46c3b] Test cases for sqlite3_analyzer and sqldiff. Fix a problem with sqlite3_analyzer related to the renaming of the initialization routine. (check-in: [85a4a46c3b] user: drh branch: trunk, size: 27317) | |
2015-02-09
| ||
17:46 | [d5a09620c6] part of check-in [937e0fe700] Fix WITHOUT ROWID table handing in sqlite3_analyzer. (check-in: [937e0fe700] user: dan branch: trunk, size: 27341) | |
2013-11-02
| ||
11:43 | [8e50b217c5] part of check-in [ac711459ff] Import the sqlite3_analyzer fixes from trunk. (check-in: [ac711459ff] user: drh branch: omit-rowid, size: 26820) | |
11:34 | [81fad69052] part of check-in [42a11e7464] 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: [42a11e7464] user: drh branch: trunk, size: 26822) | |
2013-11-01
| ||
20:30 | [0002397210] part of check-in [f9769d701c] 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: [f9769d701c] user: drh branch: omit-rowid, size: 26818) | |
2013-09-28
| ||
12:40 | [d8c11da184] part of check-in [3e5c7771fa] 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: [3e5c7771fa] user: drh branch: trunk, size: 26820) | |
2013-07-17
| ||
18:12 | [f87fc8e459] part of check-in [3b4096cc8a] Enhance the sqlite3_analyzer tool to give reports on the sizes of individual indices. (check-in: [3b4096cc8a] user: drh branch: trunk, size: 26574) | |
2012-10-10
| ||
10:52 | [76f583a246] part of check-in [6dc987d32b] Add support for URI filenames in sqlite3_analyzer. (check-in: [6dc987d32b] user: drh branch: trunk, size: 26090) | |
2012-04-06
| ||
00:09 | [e422730006] part of check-in [1bfc30cb0f] Update sqlite3_analyzer to correctly find all database files when the multiplexor is being used. (check-in: [1bfc30cb0f] user: drh branch: trunk, size: 25910) | |
2011-10-10
| ||
16:06 | [15f6cd939b] part of check-in [e5169f9a5b] Enhance sqlite3_analyzer so that it is able to deal with multiplexed databases that have 8+3 filenames. (check-in: [e5169f9a5b] user: drh branch: trunk, size: 25946) | |
2011-10-05
| ||
19:46 | [2dc915c213] part of check-in [baa80c7bc3] Add the --pageinfo and --stats options to the sqlite3_analyzer utility. (check-in: [baa80c7bc3] user: drh branch: trunk, size: 25333) | |
18:18 | [7ba8b9784f] part of check-in [fa5ed53296] Update the sqlite3_analyzer utility program to provide more details about the compression performance of ZIPVFS database files. (check-in: [fa5ed53296] user: drh branch: trunk, size: 23688) | |
2011-09-28
| ||
00:50 | [58d3573847] part of check-in [19b8eaaf70] 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: [19b8eaaf70] user: drh branch: trunk, size: 22173) | |
2011-09-27
| ||
13:40 | [7591cccc63] part of check-in [8c846311a0] Changes to sqlite3_analyzer to try to avoid integer overflow problems when linking against older versions of TCL. (check-in: [8c846311a0] user: drh branch: trunk, size: 21810) | |
2011-09-26
| ||
19:32 | [a7ffc29ba8] part of check-in [d82cffab6a] Changes to the analyzer script to make it work with zipvfs databases. (check-in: [d82cffab6a] user: dan branch: trunk, size: 21788) | |
2011-09-21
| ||
20:10 | [537f35d9e4] part of check-in [3a261f383f] Minor tweaks to the TCL code for sqlite3_analyzer. (check-in: [3a261f383f] user: drh branch: trunk, size: 21481) | |
2011-09-15
| ||
00:40 | [fe02dede3d] part of check-in [3fc566ac5d] Cleanup/fix error handling when no arguments are supplied to the SQLite analyzer. (check-in: [3fc566ac5d] user: mistachkin branch: trunk, size: 21465) | |
2011-08-31
| ||
17:46 | [1ee4df4e19] part of check-in [df55006665] 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: [df55006665] user: drh branch: trunk, size: 21348) | |
2010-07-12
| ||
08:39 | [b91879d52b] part of check-in [86159cb3f0] Changes so that the space-analyzer script works with 3.7.0. (check-in: [86159cb3f0] user: dan branch: trunk, size: 21357) | |
2007-12-04
| ||
13:41 | [b87db46ae2] part of check-in [7c2cf45428] Fix a bug in the TCL code for sqlite3_analyzer. (CVS 4590) (check-in: [7c2cf45428] user: drh branch: trunk, size: 30555) | |
2007-02-13
| ||
01:41 | [f60a242a99] part of check-in [31e5073c58] Explanation of the "fragmentation" line is added to the help message at the end of the output of sqlite3_analyzer. (CVS 3636) (check-in: [31e5073c58] user: drh branch: trunk, size: 30481) | |
01:38 | [5c7b01742b] part of check-in [82aed271a4] Additional fixes to the new fragmentation feature of sqlite3_analyzer. (CVS 3635) (check-in: [82aed271a4] user: drh branch: trunk, size: 30155) | |
2007-02-10
| ||
19:22 | [2614b0c929] part of check-in [bd6bc3b8f0] Changes to support fragmentation analysis in sqlite3_analyzer. (CVS 3634) (check-in: [bd6bc3b8f0] user: drh branch: trunk, size: 30192) | |
2006-10-03
| ||
12:08 | [f4ca4843c1] part of check-in [e774adce8e] Fix sqlite3_analyzer so that it works when compiled against Tcl8.5. (CVS 3458) (check-in: [e774adce8e] user: drh branch: trunk, size: 28936) | |
12:04 | [347bb735f9] part of check-in [47c8567fcb] Fix sqlite3_analyzer so that it works on databases containing virtual tables. (CVS 3457) (check-in: [47c8567fcb] user: drh branch: trunk, size: 28924) | |
2006-02-09
| ||
02:41 | [9e134a2644] part of check-in [8b3068aca7] Use 64-bit integers in sqlite3_analyzer. Ticket #1666. (CVS 3059) (check-in: [8b3068aca7] user: drh branch: trunk, size: 28906) | |
2006-01-24
| ||
02:19 | [ceaee5ce87] part of check-in [388b926228] Sqlite3_analyzer reports an error if it runs into trouble. (CVS 3021) (check-in: [388b926228] user: drh branch: trunk, size: 28690) | |
2005-03-29
| ||
13:18 | [5b47b70b9a] part of check-in [d89aaba5b0] Fix minor display bugs in sqlite3_analyzer. (CVS 2431) (check-in: [d89aaba5b0] user: drh branch: trunk, size: 28615) | |
2005-02-01
| ||
10:36 | [184f5e590c] part of check-in [52e473b946] Space analyzer: Format integer results as integers. Also fix the calculation of average-fanout. (CVS 2304) (check-in: [52e473b946] user: danielk1977 branch: trunk, size: 28610) | |
2004-11-09
| ||
07:42 | [102d6dcb9d] part of check-in [63f2ee22e2] Refactor the space-analysis script for readability. (CVS 2081) (check-in: [63f2ee22e2] user: danielk1977 branch: trunk, size: 28088) | |
2004-11-08
| ||
16:15 | [a1ba7f0576] part of check-in [1cb8086612] Update the space-analyzer tool to support auto-vacuum databases. (CVS 2080) (check-in: [1cb8086612] user: danielk1977 branch: trunk, size: 21186) | |
2004-07-23
| ||
00:01 | Added: [c8c39c466f] part of check-in [7c7f698b2e] First cut at a analysis tool for version 3.0 databases. (CVS 1862) (check-in: [7c7f698b2e] user: drh branch: trunk, size: 18347) | |
2004-06-19
| ||
11:57 | Added: [fec9907072] part of check-in [06bf4c7e41] Add the source code to the sqlite_analyzer utility. (CVS 1637) (check-in: [06bf4c7e41] user: drh branch: version_2, size: 15334) | |