SQLite: dbstat (eponymous virtual table)

select
   name,
   sum(pgsize)  / 1024.0 / 1024.0 mb
from
   dbstat
group by
   name
order by
   sum(pgsize) desc;

select
   name,
   path,
   pageno,
   pagetype,
   ncell,
   payload,
   unused,
   mx_payload,
   pgoffset,
   pgsize
from
   dbstat
order by
   pageno limit 50;