libsqlite/tool/spaceanal.tcl

114 proc statline {title value {extra {}}} {
164   statline "Percentage of total database" \
166   statline "Number of entries" $nentry
168   statline "Bytes of storage consumed" $storage
169   statline "Bytes of payload" $payload [percent $payload $storage]
170   statline "Bytes of data" $data [percent $data $storage]
172   statline "Bytes of key" $key [percent $key $storage]
174   statline "Average payload per entry" $avgpay
176   statline "Average unused bytes per entry" $avgunused
177   statline "Average fanout" \
179   statline "Maximum payload per entry" $mx_payload
180   statline "Entries that use overflow" $n_ovfl [percent $n_ovfl $nentry]
181   statline "Total pages used" [set allpgs [expr {$pri_pages+$ovfl_pages}]]
182   statline "Primary pages used" $pri_pages ;# [percent $pri_pages $allpgs]
183   statline "Overflow pages used" $ovfl_pages ;# [percent $ovfl_pages $allpgs]
184   statline "Unused bytes on primary pages" $pri_unused \
186   statline "Unused bytes on overflow pages" $ovfl_unused \
189   statline "Unused bytes on all pages" $allunused \
204 statline {Pages in the whole file (measured)} $file_pgcnt
206 statline {Pages in the whole file (calculated)} $file_pgcnt2
207 statline {Pages that store data} $usedcnt [percent $usedcnt $file_pgcnt]
208 statline {Pages on the freelist (per header)}\
210 statline {Pages on the freelist (calculated)}\
212 statline {Header pages} 1 [percent 1 $file_pgcnt]
215 statline {Number of tables in the database} $ntable
220 statline {Number of indices} $nindex
221 statline {Number of named indices} $manindex [percent $manindex $nindex]
222 statline {Automatically generated indices} $autoindex \
228 statline "Size of the file in bytes" $fsize
229 statline "Bytes of payload stored" $total_payload \
231 statline "Bytes of user data stored" $bytes_data \
241   statline [string toupper $tblname] $size [percent $size $file_pgcnt]