Re: [firebird-support] How much percentage of a database space is a table contents taking.

 

rgilland1966@gmail.com [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.

__._,_.___

---

Posted by: "Thomas Steinmaurer" <ts@iblogmanager.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___