extentions of GSTAT output in 3.0
---------------------------------
Key: CORE-3514
URL: http://tracker.firebirdsql.org/browse/CORE-3514
Project: Firebird Core
Issue Type: New Feature
Components: GSTAT
Affects Versions: 3.0 Alpha 1, 3.0 Beta 1, 3.0.0
Reporter: kdv
I ask to extend GSTAT output with the information, already provided by
InterBase XE gstat.
These options are:
for tables:
now
Average record length: 67.06, total records: 31
nice to implement
Average record length: 67.06, total records: 31, max record length: 83
i.e. add maximal record length detected (rounded up integer)
and information about Blobs in tables (don't exist now at all), like this:
JOB (129)
Primary pointer page: 382, Index root page: 383
Average record length: 67.06, total records: 31, max record length: 83
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 4, data page slots: 4, average fill: 65%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3
80 - 99% = 0
Blob pointer page: 446
Average blob length: 129.95, total blobs: 39, max blob length: 273
Average segment length: 44.81, total segments: 114, max segment length: 85
Blob pages: 7, blob page slots: 7, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 6
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Discover what all the cheering's about.
Get your free trial download today.
http://p.sf.net/sfu/quest-dev2dev2
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
