Subject | How to analyse a db using gstat? |
---|---|
Author | Yusuf Celik |
Post date | 2007-07-10T08:47:27Z |
Hi,
I run gstat on my db and get some results.
Is there a documentation on what all mean?
Such as
LOGS_OK (142)
Primary pointer page: 177, Index root page: 178
Average record length: 267.69, total records: 2477
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 96, data page slots: 96, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 95
Index RDB$PRIMARY22 (0)
Depth: 2, leaf buckets: 13, nodes: 2477
Average data length: 36.89, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 13
The above result scares me what 80 -90% = 95 means?
And also in primary22 80-99% = 13 ?
what it means indexing has no effect or something else?
Thanks in advance
yc
[Non-text portions of this message have been removed]
I run gstat on my db and get some results.
Is there a documentation on what all mean?
Such as
LOGS_OK (142)
Primary pointer page: 177, Index root page: 178
Average record length: 267.69, total records: 2477
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 96, data page slots: 96, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 95
Index RDB$PRIMARY22 (0)
Depth: 2, leaf buckets: 13, nodes: 2477
Average data length: 36.89, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 13
The above result scares me what 80 -90% = 95 means?
And also in primary22 80-99% = 13 ?
what it means indexing has no effect or something else?
Thanks in advance
yc
[Non-text portions of this message have been removed]