Contents

/* The total size of all tables and indexes. */
SELECT 'pages' AS name,      MAX(pageno) as value FROM dbstat
UNION ALL SELECT 'cells',    SUM(ncell)    FROM dbstat
UNION ALL SELECT 'payload_size',  SUM(payload)  FROM dbstat
UNION ALL SELECT 'unused_size',   SUM(unused)   FROM dbstat
UNION ALL SELECT 'vacuum_size',   SUM(pgsize) - SUM(payload) - SUM(unused) FROM dbstat
UNION ALL SELECT 'page_size',     SUM(pgsize)   FROM dbstat

UNION ALL SELECT 'pages: leaf', COUNT(*)
    FROM dbstat WHERE pagetype = 'leaf'
UNION ALL SELECT 'pages: internal', COUNT(*)
    FROM dbstat WHERE pagetype = 'internal'
UNION ALL SELECT 'pages: overflow', COUNT(*)
    FROM dbstat WHERE pagetype = 'overflow'
UNION ALL SELECT 'pages: table', COUNT(*)
    FROM dbstat WHERE name IN (SELECT name FROM sqlite_schema WHERE type='table')
UNION ALL SELECT 'pages: index', COUNT(*)
    FROM dbstat WHERE name IN (SELECT name FROM sqlite_schema WHERE type='index')

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
rails-sqlite-extras-0.1.2	lib/rails_sqlite_extras/queries/total_size.sql
rails-sqlite-extras-0.1.1	lib/rails_sqlite_extras/queries/total_size.sql
rails-sqlite-extras-0.1.0	lib/rails_sqlite_extras/queries/total_size.sql
rails-sqlite-extras-0.0.2	lib/rails_sqlite_extras/queries/total_size.sql