Subject | Firebird 3 - gstat output about blobs |
---|---|
Author | liviuslivius |
Post date | 2019-04-23T12:38:55Z |
Hi
can someone describe me the maining about "Blobs" output of gstat and levels
Blobs: 100212, total length: 6378829, blob pages: 0
Level 0: 100212, Level 1: 0, Level 2: 0
below is full sample
Z_COMPARE (383)
Primary pointer page: 901, Index root page: 902
Total formats: 1, used formats: 1
Average record length: 64.60, total records: 136628
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 82.00, compression ratio: 1.27
Pointer pages: 1, data page slots: 1496
Data pages: 1496, average fill: 86%
Primary pages: 885, secondary pages: 611, swept pages: 0
Empty pages: 6, full pages: 1488
Blobs: 100212, total length: 6378829, blob pages: 0
Level 0: 100212, Level 1: 0, Level 2: 0
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 2
60 - 79% = 878
80 - 99% = 610
What this output about blobs mean
records are 136628 blobs are 10021, is this mean that some blobs are null?
blob pages: 0 - what this mean? Blob is stored in the same page as other fields?
What about levels 0, 1, 2
regards,
Karol Bieniaszewski