Subject Re: [firebird-support] Re: How much percentage of a database space is a table contents taking.
Author Helen Borrie
Monday, November 30, 2015, 7:40:50 PM, Thomas Steinmaurer wrote:

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

Unfortunately, that information is absent from gstat -h, hence my
advice to use isql SHOW DATABASE. I can't think why it is missing -
even in Fb 3 where gstat -h output has actually been updated to
display the new header info in ODS 12 databases.

not quite
> So, basically, with gstat you get ^ everything you need:

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Programs64\Firebird_2_5\bin>gstat -h xxyyzz

Database "h:\databases\xxyyzz.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 1428
Page size 8192
ODS version 11.2
Oldest transaction 1093
Oldest active 1094
Oldest snapshot 1094
Next transaction 1107
Bumped transaction 1
Sequence number 0
Next attachment ID 128
Implementation ID 26
Shadow count 0
Page buffers 4092
Next header page 0
Database dialect 3
Creation date Oct 3, 2015 20:35:11
Attributes force write

Variable header data:
Sweep interval: 20000