Subject Firebird 3 - gstat output about blobs
Author liviuslivius
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