[email protected] [firebird-support] schrieb am 27.11.2015 00:24: > Hi, > > > this is an output from ibexpert, no usage% column here either: > > > Kind Regards, > > > Robert. > > > Database "OP.FDB" > Database header page information: > Flags 0 > Checksum 12345 > Generation 28674 > Page size 8192 > ODS version 11.2 > Oldest transaction 25549 > Oldest active 28656 > Oldest snapshot 28656 > Next transaction 28657 > Bumped transaction 1 > Sequence number 0 > Next attachment ID 161 > Implementation ID 16 > Shadow count 0 > Page buffers 0 > Next header page 0 > Database dialect 3 > Creation date Nov 15, 2015 8:58:58 > Attributes force write > > > Variable header data: > Sweep interval: 0 > *END* > > > > > Database file sequence: > File OP.FDB is the only file > > > Analyzing database pages ... > AS_AZN_TND_TML (419) > Primary pointer page: 1869, Index root page: 1870 > Average record length: 0.00, total records: 0 > Average version length: 0.00, total versions: 0, max versions: 0 > Data pages: 0, data page slots: 0, average fill: 0% > Fill distribution: > 0 - 19% = 0 > 20 - 39% = 0 > 40 - 59% = 0 > 60 - 79% = 0 > 80 - 99% = 0
Divide the value of "Data pages" in the per table gstat output by the database page size. This will give you an approximate value on space used on disk for the table. Approximate in a way as this does not include BLOB data. AFAIK, with Firebird 3 (ODS12), even BLOB data is counted here or displayed as a separate value. Can't remember exactly. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
