Subject | Re: [firebird-support] How much percentage of a database space is a table contents taking. |
---|---|
Author | Alan J Davies |
Post date | 2015-11-27T00:22:52Z |
Hi Robert, you need to click on the second tab of the results - Tables.
The first tab - Text - does only show what you have here.
TableName Size Usage%
CUSTOMER 11,960,320 0.295
PARAMFIL 16,384 0.000
POSTCODES 3,903,012,864 96.335
POSTCODE_MISSING 16,384 3.000
Alan J Davies
Aldis
The first tab - Text - does only show what you have here.
TableName Size Usage%
CUSTOMER 11,960,320 0.295
PARAMFIL 16,384 0.000
POSTCODES 3,903,012,864 96.335
POSTCODE_MISSING 16,384 3.000
Alan J Davies
Aldis
On 26/11/2015 23:24, rgilland1966@... [firebird-support] wrote:
> 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
>
>