Database "C:\KOVSOFT\BASA5\MA5.FDB"
Gstat execution time Tue Feb  6 13:54:59 2024

Database header page information:
        Flags                   0
        Generation              2000
        System Change Number    0
        Page size               16384
        ODS version             13.1
        Oldest transaction      2045
        Oldest active           2046
        Oldest snapshot         2046
        Next transaction        2046
        Sequence number         0
        Next attachment ID      42
        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 4, 2024 18:12:28
        Attributes              force write

    Variable header data:
        Database GUID:  {3E334F4D-660C-4C1B-AC34-9F764706CD60}
        Sweep interval:         20000
        *END*


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

Analyzing database pages ...
TURIST_LIST_DETAL (132)
    Primary pointer page: 196, Index root page: 197
    Total formats: 2, used formats: 1
    Average record length: 112.60, 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: 2.70
    Pointer pages: 57, data page slots: 185064
    Data pages: 185064, average fill: 81%
    Primary pages: 185064, secondary pages: 0, swept pages: 0
    Empty pages: 5, full pages: 185057
    Fill distribution:
         0 - 19% = 5
        20 - 39% = 1
        40 - 59% = 0
        60 - 79% = 3028
        80 - 99% = 182030

    Index FK_TURIST_LIST_DETAL_1 (6)
        Root page: 648726, depth: 3, leaf buckets: 6589, nodes: 18971605
        Average node length: 5.63, 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: 193824, ratio: 0.01
        Fill distribution:
             0 - 19% = 1
            20 - 39% = 0
            40 - 59% = 0
            60 - 79% = 0
            80 - 99% = 6588

    Index FK_TURIST_LIST_DETAL_2 (5)
        Root page: 642528, depth: 3, leaf buckets: 6579, nodes: 18971605
        Average node length: 5.62, 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: 502109, ratio: 0.03
        Fill distribution:
             0 - 19% = 1
            20 - 39% = 0
            40 - 59% = 0
            60 - 79% = 0
            80 - 99% = 6578

    Index FK_TURIST_LIST_DETAL_3 (4)
        Root page: 636004, depth: 3, leaf buckets: 6582, nodes: 18971605
        Average node length: 5.62, 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: 191150, ratio: 0.01
        Fill distribution:
             0 - 19% = 1
            20 - 39% = 0
            40 - 59% = 0
            60 - 79% = 0
            80 - 99% = 6581

    Index PK_TURIST_LIST_DETAL (0)
        Root page: 582191, depth: 3, leaf buckets: 13682, nodes: 18971605
        Average node length: 11.67, 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: 193444, ratio: 0.01
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 1
            40 - 59% = 0
            60 - 79% = 0
            80 - 99% = 13681

    Index TURIST_LIST_DETAL_IDX1 (3)
        Root page: 608862, depth: 3, leaf buckets: 7958, nodes: 18971605
        Average node length: 6.78, 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: 8573712, ratio: 0.45
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 0
            40 - 59% = 1
            60 - 79% = 0
            80 - 99% = 7957

    Index TURIST_LIST_DETAL_IDX_DATE_IN (1)
        Root page: 596640, depth: 3, leaf buckets: 6579, nodes: 18971605
        Average node length: 5.62, 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: 448070, ratio: 0.02
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 0
            40 - 59% = 0
            60 - 79% = 1
            80 - 99% = 6578

    Index TURIST_LIST_DETAL_IDX_DATE_OUT (2)
        Root page: 603225, depth: 3, leaf buckets: 6579, nodes: 18971605
        Average node length: 5.62, 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: 1920575, ratio: 0.10
        Fill distribution:
             0 - 19% = 0
            20 - 39% = 0
            40 - 59% = 0
            60 - 79% = 0
            80 - 99% = 6579

Gstat completion time Tue Feb  6 13:55:07 2024