Database "C:\KOVSOFT\BASA5\MA4.FDB"
Gstat execution time Tue Feb  6 13:51:57 2024

Database header page information:
        Flags                   0
        Generation              1677
        System Change Number    0
        Page size               16384
        ODS version             13.0
        Oldest transaction      1660
        Oldest active           1661
        Oldest snapshot         1661
        Next transaction        1661
        Sequence number         0
        Next attachment ID      34
        Implementation          HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
        Shadow count            0
        Page buffers            50000
        Next header page        0
        Database dialect        3
        Creation date           Feb 5, 2024 17:04:52
        Attributes              force write

    Variable header data:
        Database GUID:  {900216C3-8B2C-4757-964A-46CD9AFF2243}
        Sweep interval:         20000
        *END*


Database file sequence:
File C:\KOVSOFT\BASA5\MA4.FDB is the only file

Analyzing database pages ...
TURIST_LIST_DETAL (132)
    Primary pointer page: 191, Index root page: 192
    Total formats: 2, used formats: 1
    Average record length: 97.75, total records: 18971605
    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: 304.00, compression ratio: 3.11
    Pointer pages: 52, data page slots: 167728
    Data pages: 167728, average fill: 79%
    Primary pages: 167728, secondary pages: 0, swept pages: 0
    Empty pages: 3, full pages: 167724
    Fill distribution:
         0 - 19% = 3
        20 - 39% = 0
        40 - 59% = 1
        60 - 79% = 147305
        80 - 99% = 20419

    Index FK_TURIST_LIST_DETAL_1 (6)
        Root page: 605497, depth: 3, leaf buckets: 6543, nodes: 18971605
        Average node length: 5.59, total dup: 18962763, max dup: 146447
        Average key length: 2.01, compression ratio: 4.49
        Average prefix length: 8.99, average data length: 0.01
        Clustering factor: 169076, ratio: 0.01
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 0
            40 - 59% = 1
            60 - 79% = 0
            80 - 99% = 6542

    Index FK_TURIST_LIST_DETAL_2 (5)
        Root page: 599352, depth: 3, leaf buckets: 6533, nodes: 18971605
        Average node length: 5.58, total dup: 18971551, max dup: 12443789
        Average key length: 2.00, compression ratio: 1.50
        Average prefix length: 3.00, average data length: 0.00
        Clustering factor: 459961, ratio: 0.02
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 0
            40 - 59% = 1
            60 - 79% = 0
            80 - 99% = 6532

    Index FK_TURIST_LIST_DETAL_3 (4)
        Root page: 592879, depth: 3, leaf buckets: 6536, nodes: 18971605
        Average node length: 5.58, total dup: 18971584, max dup: 10044101
        Average key length: 2.00, compression ratio: 4.49
        Average prefix length: 9.00, average data length: 0.00
        Clustering factor: 172029, ratio: 0.01
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 0
            40 - 59% = 1
            60 - 79% = 0
            80 - 99% = 6535

    Index PK_TURIST_LIST_DETAL (0)
        Root page: 539299, depth: 3, leaf buckets: 13636, nodes: 18971605
        Average node length: 11.63, total dup: 0, max dup: 0
        Average key length: 8.05, compression ratio: 1.12
        Average prefix length: 3.95, average data length: 5.05
        Clustering factor: 169038, ratio: 0.01
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 0
            40 - 59% = 1
            60 - 79% = 0
            80 - 99% = 13635

    Index TURIST_LIST_DETAL_IDX1 (3)
        Root page: 565842, depth: 3, leaf buckets: 7912, nodes: 18971605
        Average node length: 6.74, total dup: 12643564, max dup: 120290
        Average key length: 3.16, compression ratio: 4.19
        Average prefix length: 12.27, average data length: 0.94
        Clustering factor: 8551390, ratio: 0.45
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 0
            40 - 59% = 0
            60 - 79% = 0
            80 - 99% = 7912

    Index TURIST_LIST_DETAL_IDX_DATE_IN (1)
        Root page: 553704, depth: 3, leaf buckets: 6534, nodes: 18971605
        Average node length: 5.58, total dup: 18969731, max dup: 120275
        Average key length: 2.00, compression ratio: 2.00
        Average prefix length: 3.99, average data length: 0.00
        Clustering factor: 413885, ratio: 0.02
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 1
            40 - 59% = 0
            60 - 79% = 0
            80 - 99% = 6533

    Index TURIST_LIST_DETAL_IDX_DATE_OUT (2)
        Root page: 560244, depth: 3, leaf buckets: 6534, nodes: 18971605
        Average node length: 5.58, total dup: 18969693, max dup: 120275
        Average key length: 2.00, compression ratio: 2.00
        Average prefix length: 3.99, average data length: 0.00
        Clustering factor: 1788664, ratio: 0.09
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 1
            40 - 59% = 0
            60 - 79% = 0
            80 - 99% = 6533

Gstat completion time Tue Feb  6 13:52:05 2024