@David Yip > If you have the dbstat module enabled (-DSQLITE_ENABLE_DBSTAT_VTAB), you > can query the dbstat virtual table for the number of pages used per table and index, e.g.
Thanks, I did not know about that module, however it is a bit slow, on a 7 GB database I have, it takes almost 5 minutes, and I have larger databases :/ So it's definitely something that would have to run in the background or night. Also, I do not know if it's intentional, but the precompiled sqlite3.dll from www.sqlite.org has the module built-in for Win64, but not for Win32. @D Burgess > download sqlite3_analyzer Thanks, the text output is interesting with built-in documentation. On Mon, Jul 30, 2018 at 9:06 AM, D Burgess <dburges...@gmail.com> wrote: > download sqlite3_analyzer > from > http://www2.sqlite.org/2018/sqlite-tools-linux-x86-3240000.zip > > > > On Mon, Jul 30, 2018 at 4:46 PM, Eric Grange <zar...@gmail.com> wrote: > > Hi, > > > > Is there a quick way (as in speed) to obtain the number of database > blocks > > (or kilobytes) allocated for each table and each index ? > > > > I have been using various manual approaches so far (from using length() > to > > vacuum and drops), but none of them are really fast > > or can practical to automate. > > > > Eric > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > On Mon, Jul 30, 2018 at 4:46 PM, Eric Grange <zar...@gmail.com> wrote: > > Hi, > > > > Is there a quick way (as in speed) to obtain the number of database > blocks > > (or kilobytes) allocated for each table and each index ? > > > > I have been using various manual approaches so far (from using length() > to > > vacuum and drops), but none of them are really fast > > or can practical to automate. > > > > Eric > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > -- > D Burgess > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users