TS (129)
    Primary pointer page: 206, Index root page: 207
    Total formats: 1, used formats: 1
    Average record length: 9.00, total records: 94879506
    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: 6.00, compression ratio: 0.67
    Pointer pages: 1298, data page slots: 1171352
    Data pages: 1171352, average fill: 52%
    Primary pages: 1171352, full pages: 1171351, swept pages: 0
    Fill distribution:
	 0 - 19% = 0
	20 - 39% = 0
	40 - 59% = 1171352
	60 - 79% = 0
	80 - 99% = 0

Database "/var/db/fb30/ts.fdb"
Database header page information:
        Flags                   0
        Generation              548
        System Change Number    0
        Page size               8192
        ODS version             12.0
        Oldest transaction      534
        Oldest active           535
        Oldest snapshot         535
        Next transaction        536
        Sequence number         0
        Next attachment ID      10
        Implementation          HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
        Shadow count            0
        Page buffers            0
        Next header page        0
        Database dialect        3
        Creation date           Jan 16, 2014 14:11:55
        Attributes

    Variable header data:
        Sweep interval:         0
        *END*


Database file sequence:
File /var/db/fb30/ts.fdb is the only file

Analyzing database pages ...
TS (128)
    Primary pointer page: 156, Index root page: 161
    Total formats: 1, used formats: 1
    Average record length: 9.00, total records: 94879506
    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: 8.00, compression ratio: 0.89
    Pointer pages: 357, data page slots: 582088
    Data pages: 582088, average fill: 52%
    Primary pages: 582088, secondary pages: 0, swept pages: 0
    Empty pages: 5, full pages: 582082
    Fill distribution:
         0 - 19% = 5
        20 - 39% = 0
        40 - 59% = 582083
        60 - 79% = 0
        80 - 99% = 0

create or alter view vmon as
select
      current_time dts
      -- mon$attachments:
      ,cast(row_number()over(order by mon$attachment_id) as char(3)) rn
      ,a.mon$remote_address remote_IP
      ,a.mon$attachment_id attach_id
      ,a.mon$user mon_user
      ,a.mon$stat_id       stat_id
      ,a.mon$server_pid    server_PID
      ,a.mon$remote_pid    remote_PID
      -- mon$memory_usage:
      ,u.mon$memory_used used_memory
      ,u.mon$memory_allocated alloc_by_OS
      -- mon$io_stats:
      ,i.mon$page_reads reads
      ,i.mon$page_writes writes
      ,i.mon$page_fetches fetches
      ,i.mon$page_marks marks
      -- mon$record_stats:
      ,r.mon$record_seq_reads seq_reads
      ,r.mon$record_idx_reads idx_reads
      ,r.mon$record_inserts ins_cnt
      ,r.mon$record_updates upd_cnt
      ,r.mon$record_deletes del_cnt
      ,r.mon$record_backouts bk_outs
      ,r.mon$record_purges purges
      ,r.mon$record_expunges expunges
      -- aux info:
      ,right(a.mon$remote_process,30) remote_process
      -- mon$statements:
      --,left(cast(s.mon$sql_text as varchar(32760)),50) sql_txt
    from mon$attachments a
    --left join mon$statements s on a.mon$attachment_id = s.mon$attachment_id
    left join mon$memory_usage u on a.mon$stat_id=u.mon$stat_id
    left join mon$io_stats i on a.mon$stat_id=i.mon$stat_id
    left join mon$record_stats r on a.mon$stat_id=r.mon$stat_id
    where
    --a.mon$state=1 and
    a.mon$attachment_id<>current_connection
;

Database header page information:
        Flags                   0
        Generation              125
        System Change Number    0
        Page size               8192
        ODS version             12.0
        Oldest transaction      93
        Oldest active           94
        Oldest snapshot         94
        Next transaction        95
        Sequence number         0
        Next attachment ID      28
        Implementation          HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
        Shadow count            0
        Page buffers            0
        Next header page        0
        Database dialect        3
        Creation date           Jan 16, 2014 14:11:55
        Attributes

    Variable header data:
        Sweep interval:         0
        *END*


Database file sequence:
File /var/db/fb30/ts.fdb is the only file

Analyzing database pages ...
TS (128)
    Primary pointer page: 156, Index root page: 161
    Total formats: 1, used formats: 1
    Average record length: 9.00, total records: 94879926
    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: 8.00, compression ratio: 0.89
    Pointer pages: 357, data page slots:  582088 
    Data pages: 582088, average fill: 52%
    Primary pages: 582088, secondary pages: 0, swept pages: 0
    Empty pages: 2, full pages: 582085
    Fill distribution:
         0 - 19% = 2
        20 - 39% = 1
        40 - 59% = 582085
        60 - 79% = 0
        80 - 99% = 0

    Index TS_X (0)
        Root page: 7314, depth: 3,  leaf buckets: 105200, nodes: 94879926 
        Average node length: 5.76, total dup: 94814391, max dup: 1447
        Average key length: 2.00, compression ratio: 1.84
        Average prefix length: 3.68, average data length: 0.00
        Clustering factor: 94879926, ratio: 1.00
        Fill distribution:
             0 - 19% = 153
            20 - 39% = 19
            40 - 59% = 65789
            60 - 79% = 13364
            80 - 99% = 25875

2014-01-20T21:02:06.8210 (20813:0x7f6a9044f1e0) EXECUTE_STATEMENT_FINISH
        ts (ATT_30, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
        /opt/fb30/bin/isql:23111
                (TRA_97, CONCURRENCY | WAIT | READ_WRITE)

Statement 56:
-------------------------------------------------------------------------
insert into ts select mod(gen_id(g,1), 65535) from rdb$types rows 100
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (RDB$TYPES NATURAL)
0 records fetched
      3 ms, 466 read(s), 1363 fetch(es), 303 mark(s)

Table                             Natural     Index    Update    Insert  
xpunge
*************************************************************************
******
RDB$TYPES                             100                                

TS                                                                  100  


2014-01-20T21:02:06.8220 (20813:0x7f6a9044f1e0) COMMIT_TRANSACTION
        ts (ATT_30, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
        /opt/fb30/bin/isql:23111
                (TRA_97, CONCURRENCY | WAIT | READ_WRITE)
      0 ms, 1 read(s), 105 write(s), 1 fetch(es), 1 mark(s)

Analyzing database pages ...
TS (128)
    Primary pointer page: 156, Index root page: 161
    Total formats: 1, used formats: 1
    Average record length: 9.00, total records: 94880026
    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: 8.00, compression ratio: 0.89
    Pointer pages: 357, data page slots:  582088 
    Data pages: 582088, average fill: 52%
    Primary pages: 582088, secondary pages: 0, swept pages: 0
    Empty pages: 1, full pages: 582086
    Fill distribution:
         0 - 19% = 2
        20 - 39% = 0
        40 - 59% = 582086
        60 - 79% = 0
        80 - 99% = 0

    Index TS_X (0)
        Root page: 7314, depth: 3,  leaf buckets: 105200, nodes: 94880026 
        Average node length: 5.76, total dup: 94814491, max dup: 1447
        Average key length: 2.00, compression ratio: 1.84
        Average prefix length: 3.68, average data length: 0.00
        Clustering factor: 94880026, ratio: 1.00
        Fill distribution:
             0 - 19% = 153
            20 - 39% = 19
            40 - 59% = 65789
            60 - 79% = 13364
            80 - 99% = 25875

SQL> show sequ;
Generator G, current value is 94879506
Generator GDETL, current value is 100000
Generator GMAIN, current value is 1000
SQL> set stat on; insert into ts select gen_id(g,1) from rdb$types rows 100; commit;
Current memory = 144739120
Delta memory = 287456
Max memory = 144811720
Elapsed time= 0.00 sec
Cpu = 0.00 sec
Buffers = 16384
Reads = 388
Writes = 0
Fetches = 1553
Current memory = 144703496
Delta memory = -35624
Max memory = 144811720
Elapsed time= 0.00 sec
Cpu = 0.00 sec
Buffers = 16384
Reads = 2
Writes = 7
Fetches = 2
SQL>
SQL> set stat on; insert into ts select gen_id(g,1) from rdb$types rows 100; commit;
Current memory = 144737920
Delta memory = 23336
Max memory = 144811720
Elapsed time= 0.00 sec
Cpu = 0.00 sec
Buffers = 16384
Reads = 1
 Writes = 0 
Fetches = 1011
Current memory = 144703496
Delta memory = -34424
Max memory = 144811720
Elapsed time= 0.00 sec
Cpu = 0.00 sec
Buffers = 16384
Reads = 2
 Writes = 7 
Fetches = 2
SQL> set stat on; insert into ts select gen_id(g,1) from rdb$types rows 100; commit;
Current memory = 144737920
Delta memory = 23336
Max memory = 144811720
Elapsed time= 0.00 sec
Cpu = 0.00 sec
Buffers = 16384
Reads = 0
Writes = 0
Fetches = 1006
Current memory = 144703496
Delta memory = -34424
Max memory = 144811720
Elapsed time= 0.00 sec
Cpu = 0.00 sec
Buffers = 16384
Reads = 2
 Writes = 5 
Fetches = 2

insert into ts select gen_id(g,1) from rdb$types rows 100
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (RDB$TYPES NATURAL)
0 records fetched
      2 ms, 365 read(s), 1363 fetch(es), 303 mark(s)

Table                             Natural     Index    Update    Insert   
xpunge
**************************************************************************
******
RDB$TYPES                             100                                 

TS                                                                  100   


2014-01-21T00:50:14.7260 (26903:0x7f38483bacc8) COMMIT_TRANSACTION
        ts (ATT_18, SYSDBA:NONE, NONE, TCPv4:127.0.0.1)
        /opt/fb30/bin/isql:27485
                (TRA_28, CONCURRENCY | WAIT | READ_WRITE)
      0 ms, 1 read(s),  6 write(s) , 1 fetch(es), 1 mark(s)