GSTAT: values 'leaf buckets' and 'nodes' remained non-zero in index statistics 
after transaction rollback and re-connect and fetching all records from (now 
empty) table
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: CORE-4778
                 URL: http://tracker.firebirdsql.org/browse/CORE-4778
             Project: Firebird Core
          Issue Type: Bug
            Reporter: Pavel Zotov


Test (file name = `idx_gstat.sql`):
====

shell del C:\MIX\firebird\QA\fbt-repo\tmp\gstat_idx_test.fdb 2>nul;

create database 
'localhost/3333:C:\MIX\firebird\QA\fbt-repo\tmp\gstat_idx_test.fdb';
commit;

recreate table t1 ( bx varchar(250) );

create index t1_idx on t1(bx);
commit;

set term ^;
execute block as
    declare n int = 5000;
begin
    while (n>0) do insert into t1(bx) values( rpad( 'QWERTY', 250, 
uuid_to_char(gen_uuid()) ) ) returning :n-1 into n;
end
^
set term ;^

rollback;

connect 'localhost/3333:C:\MIX\firebird\QA\fbt-repo\tmp\gstat_idx_test.fdb';

out nul;
select count(*) cnt_idx from t1 where bx>='';
commit;
select * from t1 where bx>='' order by bx;
commit;
out;


Run:
====

step-1: isql -q -i idx_gstat.sql

step-1: gstat.exe -r 
localhost/3333:C:\MIX\firebird\QA\fbt-repo\tmp\GSTAT_IDX_TEST.FDB >gstat_r.txt

In the log of gstat one may see:
==============

T1 (128)
    Primary pointer page: 211, Index root page: 212
    Total formats: 1, used formats: 0
    Average record length: 0.00, total records: 0
    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: 0.00, compression ratio: 0.00
    Pointer pages: 1, data page slots: 0
    Data pages: 0, average fill: 0%
    Primary pages: 0, secondary pages: 0, swept pages: 0
    Empty pages: 0, full pages: 0
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 0

    Index T1_IDX (0)
        Root page: 227, depth: 2, leaf buckets: 3, nodes: 16 
<<<<<<<<<<<<<<<<<<<  ?? <<<<<<<<<<<<<<<
        Average node length: 249.13, total dup: 0, max dup: 0
        Average key length: 247.00, compression ratio: 1.01
        Average prefix length: 6.88, average data length: 243.13
        Clustering factor: 16, ratio: 1.00
        Fill distribution:
             0 - 19% = 1
            20 - 39% = 1
            40 - 59% = 0
            60 - 79% = 1
            80 - 99% = 0

Why values 'leaf buckets' and 'nodes' remained non-zero ?

-- 
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

        

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to