Subject Re: [firebird-support] How to determine size of database structures?
Author Alexey Kovyazin
Post date 2015-05-14T15:53:12Z
Hi Bruce,

DBInfo from IBSurgeon Free Tools (http://ib-aid.com/en/ibsurgeon-free-tools/) will give you database pages statistics.

Regards,
Alexey Kovyazin
IBSurgeon



 

Hi guys.

I know that I need to use gstat, and I know that I have detailed description about it here: Gstat Examples And Interpretation

 


However, the description does not say how to determine how much space on hard drive is taken by tables and indices. Somewhere I've read that to calculate size of a table I need to multiply the DB page size with data pages reported by gstat for each table. Is that a correct method?

Could you tell me how to calculate how much space is taken by indicies based on gstat output file?

Regards.