Subject Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.
Author Thomas Steinmaurer
rgilland1966@... [firebird-support] schrieb am 30.11.2015 05:10:

> Thanks Helen,
>
> I finally taught myself how to use isql.exe in order to access this
> information.
> What a strange tool.
>
>
> Then I found that both IBOConsole.exe and Upscene's Database Workbench show
> this information in Database Properties. And it is called "Allocated DB Pages"

That information is also available on the database header page, which can be extracted by gstat -h

So, basically, with gstat you get everything you need:

* DB total allocated pages
* Allocated pages per table
* Allocated pages per index (might be important contributors size-wise)


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.