Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.03.2024 10:09
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database Statistics, full
  3. Record versions statistics    as table    as chart
  4. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  5. New in firebird.log while test was run
  6. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15654396 kB
MemAvailable 30255908 kB
Buffers 0 kB
Cached 16077224 kB
SwapCached 2592 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


SERVER_MODE                     SuperServer 4.0.5
DB_NAME                         /home/bases/oltp40-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings 

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-21 10:07:52
DTS_END                         2024-03-21 10:07:52.0970
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/53404
TRN_ID                          174536
ATT_ID                          595
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9328.65 20878 932865
customer order: creation 180.11 450 18011
customer order: refuse 15.61 316 1561
order to supplier: creation 47.81 1287 4781
order to supplier: removal 3.58 81458 358
invoice (draft): creation 50.01 2939 5001
invoice (draft): removal 47.66 666 4766
invoice accept: apply 44.64 20105 4464
invoice accept: cancel 42.87 819 4287
customer reserve: creation 4348.79 191 434879
customer reserve: removal 4250.92 55 425092
realization accept: apply 87.22 182 8722
realization accept: cancel 71.62 128 7162
payment from customer: creation 64.32 113 6432
payment from customer: removal 6.43 94 643
payment to supplier: creation 52.14 137 5214
payment to supplier: removal 3.40 93 340
service: total inventory turnovers 4.28 3510 428
service: total monetary turnovers 6.33 534 633
service: aggregate perf. data 0.88 21383 88
service: refresh index statistics 0.03 283105 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-03-2024 10:09:26 to 21-03-2024 10:09:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2733
TEST_TIME 2 3283
TEST_TIME 3 4259
TEST_TIME 4 4087
TEST_TIME 5 5173
TEST_TIME 6 4831
TEST_TIME 7 5107
TEST_TIME 8 5116
TEST_TIME 9 5694
TEST_TIME 10 5801
TEST_TIME 11 6001
TEST_TIME 12 6257
TEST_TIME 13 6611
TEST_TIME 14 7227
TEST_TIME 15 7238
TEST_TIME 16 7406
TEST_TIME 17 7405
TEST_TIME 18 7674
TEST_TIME 19 7786
TEST_TIME 20 8010
TEST_TIME 21 8458
TEST_TIME 22 8800
TEST_TIME 23 9092
TEST_TIME 24 9613
TEST_TIME 25 9638
TEST_TIME 26 9724
TEST_TIME 27 9712
TEST_TIME 28 9763
TEST_TIME 29 9802
TEST_TIME 30 9754
TEST_TIME 31 10008
TEST_TIME 32 9997
TEST_TIME 33 9941
TEST_TIME 34 10002
TEST_TIME 35 10127
TEST_TIME 36 10221
TEST_TIME 37 10139
TEST_TIME 38 9911
TEST_TIME 39 9817
TEST_TIME 40 9691
TEST_TIME 41 9585
TEST_TIME 42 9581
TEST_TIME 43 9527
TEST_TIME 44 9644
TEST_TIME 45 9618
TEST_TIME 46 9715
TEST_TIME 47 9677
TEST_TIME 48 9584
TEST_TIME 49 9529
TEST_TIME 50 9392
TEST_TIME 51 9328
TEST_TIME 52 9390
TEST_TIME 53 9357
TEST_TIME 54 9348
TEST_TIME 55 9299
TEST_TIME 56 9307
TEST_TIME 57 9328
TEST_TIME 58 9672
TEST_TIME 59 9609
TEST_TIME 60 9612
TEST_TIME 61 9721
TEST_TIME 62 9674
TEST_TIME 63 9718
TEST_TIME 64 9781
TEST_TIME 65 9731
TEST_TIME 66 9746
TEST_TIME 67 9784
TEST_TIME 68 9677
TEST_TIME 69 9570
TEST_TIME 70 9605
TEST_TIME 71 9593
TEST_TIME 72 9505
TEST_TIME 73 9459
TEST_TIME 74 9462
TEST_TIME 75 9400
TEST_TIME 76 9365
TEST_TIME 77 9393
TEST_TIME 78 9393
TEST_TIME 79 9390
TEST_TIME 80 9374
TEST_TIME 81 9408
TEST_TIME 82 9465
TEST_TIME 83 9513
TEST_TIME 84 9577
TEST_TIME 85 9564
TEST_TIME 86 9560
TEST_TIME 87 9537
TEST_TIME 88 9663
TEST_TIME 89 9560
TEST_TIME 90 9515
TEST_TIME 91 9471
TEST_TIME 92 9427
TEST_TIME 93 9387
TEST_TIME 94 9423
TEST_TIME 95 9362
TEST_TIME 96 9355
TEST_TIME 97 9425
TEST_TIME 98 9394
TEST_TIME 99 9371
TEST_TIME 100 9338

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-03-2024 10:09:30 to 21-03-2024 10:09:33.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1327242 1327242 0 0.00 0 10876 7 0 0
doc_list_biud 1327240 1327240 0 0.00 0 30652 22 0 0
sp_add_invoice_to_stock 4567 4464 103 2.25 20 182093 20105 0 103
sp_cancel_adding_invoice 4287 4287 0 0.00 2 61077 820 0 0
sp_cancel_client_order 1561 1561 0 0.00 4 4968 316 0 0
sp_cancel_customer_reserve 425092 425092 0 0.00 0 22673 55 0 0
sp_cancel_pay_from_customer 643 643 0 0.00 2 4509 94 0 0
sp_cancel_pay_to_supplier 340 340 0 0.00 2 4047 93 0 0
sp_cancel_supplier_invoice 4772 4766 6 0.12 1 20683 667 0 6
sp_cancel_supplier_order 358 358 0 0.00 7 984708 81459 0 0
sp_cancel_write_off 7162 7162 0 0.00 1 8802 128 0 0
sp_client_order 18011 18011 0 0.00 3 17954 451 0 0
sp_customer_reserve 434879 434879 0 0.00 0 52345 191 0 0
sp_fill_shopping_cart 27777 27777 0 0.00 1 18699 36 0 0
sp_fill_shopping_cart_clo_res 434867 434867 0 0.00 0 17781 13 0 0
sp_get_clo_for_invoice 4448 4448 0 0.00 0 19327 327 0 0
sp_kill_cost_storno 12432 12432 0 0.00 0 7552 66 0 0
sp_kill_qstorno_ret_qs2qd 862470 862470 0 0.00 0 22642 30 0 0
sp_kill_qty_storno 456394 456394 0 0.00 0 30652 64 0 0
sp_lock_selected_doc 18283 18283 0 0.00 0 8989 5 0 0
sp_make_cost_storno 24814 24814 0 0.00 0 10369 55 0 0
sp_multiply_rows_for_pdistr 24814 24814 0 0.00 0 7700 31 0 0
sp_multiply_rows_for_qdistr 18009 18009 0 0.00 0 17944 209 0 0
sp_pay_from_customer 6432 6432 0 0.00 3 10941 114 0 0
sp_pay_to_supplier 5214 5214 0 0.00 4 16205 137 0 0
sp_payment_common 11646 11646 0 0.00 1 7229 23 0 0
sp_qd_handle_on_cancel_clo 1561 1561 0 0.00 0 3289 293 0 0
sp_qd_handle_on_invoice_upd_sts 8733 8733 0 0.00 0 30652 287 0 0
sp_qd_handle_on_reserve_upd_sts 8722 8722 0 0.00 0 12630 58 0 0
sp_reserve_write_off 8722 8722 0 0.00 5 16830 182 0 0
sp_supplier_invoice 5001 5001 0 0.00 6 83976 2940 0 0
sp_supplier_order 4781 4781 0 0.00 4 44753 1287 0 0
srv_aggregate_perf_data 88 88 0 0.00 1735 528825 21384 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1673 109224 38733 0 0
srv_find_qd_qs_mism 885514 885514 0 0.00 0 10876 7 0 0
srv_make_invnt_saldo 428 428 0 0.00 30 108132 3510 0 0
srv_make_money_saldo 633 633 0 0.00 0 16202 535 0 0
srv_recalc_idx_stat 3 3 0 0.00 214954 408472 283105 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4464 4464 0 0.00 0 20237 177 0 0
t$perf-norm:sp_cancel_adding_invoice 375 375 0 0.00 0 4500 109 0 0
t$perf-norm:sp_cancel_client_order 1561 1561 0 0.00 0 2602 14 0 0
t$perf-norm:sp_cancel_customer_reserve 577 577 0 0.00 0 622 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 643 643 0 0.00 0 797 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 340 340 0 0.00 0 506 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 1020 17 0 0
t$perf-norm:sp_cancel_supplier_order 358 358 0 0.00 0 24308 1538 0 0
t$perf-norm:sp_cancel_write_off 887 887 0 0.00 0 3847 16 0 0
t$perf-norm:sp_client_order 18011 18011 0 0.00 0 16177 15 0 0
t$perf-norm:sp_customer_reserve 845 845 0 0.00 0 2369 8 0 0
t$perf-norm:sp_pay_from_customer 6432 6432 0 0.00 0 5959 7 0 0
t$perf-norm:sp_pay_to_supplier 5214 5214 0 0.00 0 12513 13 0 0
t$perf-norm:sp_reserve_write_off 8722 8722 0 0.00 0 4747 11 0 0
t$perf-norm:sp_supplier_invoice 5001 5001 0 0.00 0 2647 12 0 0
t$perf-norm:sp_supplier_order 4781 4781 0 0.00 0 4617 15 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 183 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 605 11 0 0
t$perf-norm:srv_make_invnt_saldo 428 428 0 0.00 0 1227 9 0 0
t$perf-norm:srv_make_money_saldo 633 633 0 0.00 0 454 3 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 18 8 0 0
v_add_invoice_to_stock 9098 8892 206 2.26 0 5014 16 0 206
v_all_customers 33892 33892 0 0.00 0 101 1 0 0
v_all_suppliers 27946 27946 0 0.00 0 101 1 0 0
v_all_wares 36014 36014 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 750 750 0 0.00 0 2072 9 0 0
v_cancel_client_order 3122 3122 0 0.00 0 804 3 0 0
v_cancel_customer_prepayment 1286 1286 0 0.00 0 4494 13 0 0
v_cancel_customer_reserve 1154 1154 0 0.00 0 881 5 0 0
v_cancel_payment_to_supplier 680 680 0 0.00 0 3976 16 0 0
v_cancel_supplier_invoice 760 748 12 1.57 0 1156 13 0 12
v_cancel_supplier_order 716 716 0 0.00 0 510 5 0 0
v_cancel_write_off 1774 1774 0 0.00 0 4950 23 0 0
v_max_id_clo_ord 4779 4779 0 0.00 0 174 1 0 0
v_max_id_clo_res 845 845 0 0.00 0 2756 14 0 0
v_max_id_ord_sup 4991 4991 0 0.00 0 2884 2 0 0
v_max_non_paid_invoice 1011 1011 0 0.00 0 1103 4 0 0
v_max_non_paid_realizn 3071 3071 0 0.00 0 3543 4 0 0
v_min_id_clo_ord 4779 4779 0 0.00 0 3604 8 0 0
v_min_id_clo_res 845 845 0 0.00 0 339 3 0 0
v_min_id_ord_sup 4991 4991 0 0.00 0 3260 5 0 0
v_min_non_paid_invoice 5214 5214 0 0.00 0 7221 15 0 0
v_min_non_paid_realizn 6432 6432 0 0.00 0 6971 18 0 0
v_our_firm 8844 8844 0 0.00 0 19 1 0 0
v_reserve_write_off 17444 17444 0 0.00 0 4494 7 0 0
x_lock_depdocs_on_canc_invoice 8679 8679 0 0.00 0 12277 125 0 0
x_lock_depdocs_on_canc_sup_ord 358 358 0 0.00 0 9867 347 0 0
x_make_qstorno_1000_1200 4781 4781 0 0.00 1 44720 1209 0 0
x_make_qstorno_1200_2000 5001 5001 0 0.00 3 83968 2813 0 0
x_make_qstorno_2100_3300 434879 434879 0 0.00 0 44253 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-03-2024 10:09:34 to 21-03-2024 10:09:38.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:56 12 8192000000 8806648752 8820744192 10761328 0.131 4 3 4 0 10952880 104608 86944
08:08:56 27645 8192000000 9715349584 10015174656 792202928 8.817 100 97 194 0 822835584 7608816 23023840
08:10:34 32659 8192000000 9768272000 10081275904 840536576 9.305 100 84 168 0 871407248 11508496 19362176
08:12:16 15468 8192000000 9800457104 10122244096 873192912 9.632 100 82 164 1 910609280 19003792 18412576
08:13:37 13835 8192000000 9866214528 10207346688 922935472 10.125 100 83 166 0 980865232 39801616 18128144
08:14:54 9562 8192000000 9903739264 10249773056 949736816 10.389 100 77 152 1 1010115424 44676480 15702128
08:16:07 4750 8192000000 9925800336 10282475520 974277408 10.628 100 76 152 1 1041410976 52257200 14876368
08:17:14 3025 8192000000 9983495744 10343235584 1000857488 10.887 100 87 172 0 1092943712 75154480 16931744
08:18:21 1759 8192000000 10002124560 10368688128 1025995856 11.130 100 86 169 0 1117211808 74622528 16593424
08:19:24 1264 8192000000 10005284736 10380132352 1049084208 11.352 100 86 171 1 1118565552 52728176 16753168
08:20:27 1272 8192000000 10032741456 10413039616 1058642448 11.443 100 85 174 0 1144790800 69600592 16547760
08:21:29 15129 8192000000 9983680832 10371661824 1063966624 11.494 100 53 107 1 1095959424 20492624 11500176
08:22:45 5316 8192000000 9982116512 10382823424 1068061232 11.534 100 43 85 1 1093790160 16381744 9347184
08:23:51 2528 8192000000 10012815904 10416611328 1074189456 11.592 100 40 80 0 1130205600 47832944 8183200
08:24:55 4483 8192000000 9997807744 10395914240 1080166608 11.649 100 36 72 0 1103426304 15639792 7619904
08:25:59 45214 8192000000 10006605056 10406760448 1084668336 11.692 100 48 96 0 1113998864 19229248 10101280
08:27:45 6043 8192000000 9997599696 10403676160 1082690592 11.673 100 45 89 1 1105789264 13604096 9494576
08:28:57 33522 8192000000 10063240512 10465878016 1067173280 11.525 98 46 92 0 1132524992 56400272 8951440
08:30:37 21977 8192000000 10066759424 10470264832 1087614496 11.720 99 45 90 1 1167155568 70670976 8870096
08:32:01 19784 8192000000 10085523616 10506006528 1108937760 11.922 100 33 66 0 1201738208 86135520 6664928
08:33:23 39623 8192000000 10100957568 10508062720 1123024016 12.056 100 45 89 0 1201238080 69126336 9087728
08:35:09 9770 8192000000 10145493632 10542415872 1101433456 11.851 97 58 116 0 1238643248 125738384 11471408
08:36:23 5998 8192000000 10168898272 10571329536 1106592032 11.900 98 60 118 0 1267127088 148399984 12135072
08:37:35 8756 8192000000 10178706080 10585182208 1116366560 11.993 99 45 88 0 1283896400 158437136 9092704
08:38:51 13164 8192000000 10182306912 10578059264 1084884208 11.694 97 59 117 0 1265977232 168728768 12364256
08:40:07 7992 8192000000 10195638816 10592563200 1095314080 11.793 100 68 136 2 1299727808 189207856 15205872
08:41:30 7155 8192000000 10144261776 10555772928 1088723872 11.731 100 63 126 0 1264969248 163016272 13229104
08:42:49 6872 8192000000 10198162960 10596765696 1094891904 11.789 100 71 140 2 1299573520 189591888 15089728
08:44:03 8050 8192000000 10170780160 10572423168 1078001856 11.628 99 51 102 0 1259889936 171024192 10863888
08:45:17 3256 8192000000 10215447760 10626244608 1095775744 11.798 100 69 139 0 1315963376 205139152 15048480
08:46:24 3200 8192000000 10235979744 10627874816 1101033680 11.847 100 69 137 3 1334732800 218960880 14738240
08:47:33 1671 8192000000 10265212928 10659643392 1097254576 11.812 99 88 175 2 1354554960 238440672 18859712
08:48:38 11270 8192000000 10260096928 10675392512 1116755552 11.996 100 50 100 0 1352119584 224631792 10732240
08:49:54 18649 8192000000 10248799216 10707955712 1122542240 12.051 100 24 48 0 1358901152 231038144 5320768
08:51:14 50915 8192000000 10094585840 10539638784 1082191056 11.668 97 27 52 1 1255963616 168132320 5640240
08:53:07 20375 8192000000 10045098576 10503446528 1103711664 11.873 99 12 24 0 1156367184 50505072 2150448
08:54:29 65048 8192000000 10060262448 10511708160 1114480432 11.975 100 12 23 1 1171954992 54841392 2633168
08:56:37 84107 8192000000 10131997488 10606673920 1109579776 11.928 99 25 51 0 1179452640 64777632 5095232
09:00:29 13010 8192000000 10073375552 10496864256 1132934416 12.149 100 48 87 2 1170845088 28140064 9770608
09:01:49 34319 8192000000 10080730304 10549915648 1127443104 12.097 99 13 27 0 1210072816 79890352 2739360
09:03:24 109224 8192000000 10070845088 10523058176 1142938032 12.243 100 14 28 0 1183672864 38008960 2725872
09:06:13 58009 8192000000 10088574688 10513547264 1125986688 12.084 98 45 91 0 1159321904 23078800 10256416
09:08:19 20700 8192000000 10106973376 10549497856 1140121184 12.217 100 31 61 0 1212830848 67330000 5379664
09:09:49 25150 8192000000 10132622512 10580426752 1145557968 12.268 99 26 52 0 1225282864 74502176 5222720
09:11:18 28328 8192000000 10117868224 10604453888 1151847072 12.327 100 19 38 0 1239577952 83514736 4216144
09:12:52 38731 8192000000 10067371584 10548670464 1140917808 12.224 99 8 14 1 1197766528 55322416 1526304
09:14:34 24936 8192000000 10059401632 10513088512 1111106608 11.943 97 11 21 0 1136222592 23261968 1854016
09:16:06 42902 8192000000 10055268032 10505355264 1122030080 12.046 99 22 43 0 1158385760 31377424 4978256
09:17:49 79989 8192000000 10086358496 10564100096 1123940576 12.064 99 14 28 0 1188564528 62275168 2348784
09:20:16 40052 8192000000 10066231296 10523418624 1092545680 11.767 97 24 48 0 1149871152 52549504 4775968
09:21:57 56329 8192000000 10101671264 10548948992 1093004944 11.771 97 22 43 0 1142305104 44694928 4605232
09:23:54 61402 8192000000 10170732848 10616107008 1124443824 12.069 99 14 28 0 1262853632 134933296 3476512
09:26:25 14277 8192000000 10021693568 10443235328 1053799584 11.397 96 44 87 0 1085809792 23352784 8657424
09:27:40 26358 8192000000 10085287168 10514427904 1096206736 11.802 100 36 72 1 1168737680 65697856 6833088
09:29:12 46700 8192000000 10063506016 10492936192 1055985200 11.418 96 26 52 1 1107739536 46566880 5187456
09:30:59 56960 8192000000 10052584912 10485198848 1086509248 11.709 99 20 40 0 1149006544 58468512 4028784
09:32:56 27431 8192000000 10092684192 10519863296 1054337504 11.402 95 29 59 1 1136668256 76662752 5668000
09:34:24 82392 8192000000 10054083200 10497327104 1096454432 11.804 100 13 26 1 1147745664 48710320 2580912
09:36:58 3332 8192000000 10071732400 10495094784 1091093680 11.753 99 42 85 0 1165994800 66611216 8289904
09:38:02 59795 8192000000 10031720944 10510938112 1105948288 11.894 100 14 28 0 1159584960 50518256 3118416
09:40:51 49525 8192000000 10046098528 10520674304 1096249392 11.802 99 15 30 0 1148653536 49080752 3323392
09:42:47 55089 8192000000 10030484096 10504241152 1098028176 11.819 99 15 30 0 1133107824 31869920 3209728
09:44:42 64457 8192000000 10063684736 10522079232 1110287152 11.935 99 26 48 1 1145957232 30432736 5237344
09:46:48 37428 8192000000 10091255600 10535550976 1124914272 12.073 100 30 61 0 1162636976 31387456 6335248
09:48:26 32192 8192000000 10108977984 10553307136 1121482192 12.041 99 43 83 0 1184042800 55015248 7545360
09:49:59 64216 8192000000 10077818768 10553163776 1138774400 12.204 100 17 32 0 1192538592 51111920 2652272
09:52:13 93890 8192000000 10066812048 10514468864 1119857856 12.026 98 18 34 0 1163972016 40993008 3121152
09:54:50 104862 8192000000 10087012720 10610356224 1139219376 12.208 99 19 38 0 1246072176 102944480 3908320
09:57:53 42841 8192000000 10104986144 10564853760 1154611840 12.353 100 31 62 0 1199333952 38506416 6215696
09:59:38 45750 8192000000 10077875568 10549927936 1120269632 12.030 98 7 12 0 1178751888 57313344 1168912
10:01:36 59919 8192000000 10061135456 10501697536 1109695344 11.930 98 7 14 0 1157054496 46065280 1293872
10:03:38 70932 8192000000 10068733536 10535194624 1097786704 11.817 97 17 34 0 1183844320 82707136 3350480
10:05:49 56428 8192000000 10107403152 10549432320 1092658784 11.768 96 33 66 0 1135944736 37022976 6262976

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 21-03-2024 10:09:40 to 21-03-2024 10:09:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 103 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-03-2024 10:09:55 to 21-03-2024 10:09:57.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          172784
MON$OLDEST_ACTIVE               174669
MON$OLDEST_SNAPSHOT             174669
MON$NEXT_TRANSACTION            174669
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1919520
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             695
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3080 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3080 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3080 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3080 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Mar 21 10:09:58 2024 
 
Database header page information: 
    Flags            0 
    Generation        91217 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    172784 
    Oldest active        174669 
    Oldest snapshot        174669 
    Next transaction    174670 
    Sequence number        0 
    Next attachment ID    695 
    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        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    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: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    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: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.49, total records: 7785652 
    Average version length: 48.16, total versions: 80180, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88704 
    Data pages: 88704, average fill: 70% 
    Primary pages: 88702, secondary pages: 2, swept pages: 31154 
    Empty pages: 7, full pages: 79399 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 16 
    40 - 59% = 584 
    60 - 79% = 88065 
    80 - 99% = 26 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23343, nodes: 7785652 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1714008, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 360 
        20 - 39% = 1633 
        40 - 59% = 4269 
        60 - 79% = 2418 
        80 - 99% = 14663 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13551, nodes: 7785652 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1537559, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1493 
        40 - 59% = 2149 
        60 - 79% = 1053 
        80 - 99% = 8856 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8362, nodes: 7785652 
    Average node length: 6.62, total dup: 5811750, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1530484, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 130 
        20 - 39% = 879 
        40 - 59% = 1460 
        60 - 79% = 929 
        80 - 99% = 4964 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.59, total records: 2264963 
    Average version length: 58.89, total versions: 40712, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28672 
    Data pages: 28672, average fill: 73% 
    Primary pages: 28669, secondary pages: 3, swept pages: 7968 
    Empty pages: 3, full pages: 22009 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 21 
    40 - 59% = 254 
    60 - 79% = 28327 
    80 - 99% = 62 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4590, nodes: 2264963 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 687738, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 881 
        40 - 59% = 906 
        60 - 79% = 730 
        80 - 99% = 2073 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2430, nodes: 2266408 
    Average node length: 4.97, total dup: 2265509, max dup: 18421 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1279065, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 174 
        40 - 59% = 1401 
        60 - 79% = 604 
        80 - 99% = 249 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1793, nodes: 2264963 
    Average node length: 4.97, total dup: 2264913, max dup: 130133 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1070509, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 654 
        60 - 79% = 45 
        80 - 99% = 1086 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4387, nodes: 2264963 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 687738, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 562 
        40 - 59% = 671 
        60 - 79% = 816 
        80 - 99% = 2230 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    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: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.27, total records: 400 
    Average version length: 23.80, total versions: 2811, max versions: 8 
    Average fragment length: 2.00, total fragments: 8, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 79% 
    Primary pages: 9, secondary pages: 15, swept pages: 0 
    Empty pages: 2, full pages: 20 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 20 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 17.69, total records: 72817 
    Average version length: 68.30, total versions: 62138, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.97 
    Pointer pages: 6, data page slots: 2520 
    Data pages: 1512, average fill: 65% 
    Primary pages: 1511, secondary pages: 1, swept pages: 0 
    Empty pages: 132, full pages: 883 
    Fill distribution: 
     0 - 19% = 266 
    20 - 39% = 161 
    40 - 59% = 131 
    60 - 79% = 167 
    80 - 99% = 787 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1696806, depth: 3, leaf buckets: 270, nodes: 72817 
    Average node length: 13.46, total dup: 4955, max dup: 2 
    Average key length: 10.73, compression ratio: 2.52 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 53838, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 116 
        40 - 59% = 116 
        60 - 79% = 38 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 188, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 79% 
    Primary pages: 1, 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% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.09, total records: 1333 
    Average version length: 43.55, total versions: 1215, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.80 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 45% 
    Primary pages: 30, secondary pages: 2, swept pages: 0 
    Empty pages: 4, full pages: 10 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 2 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91524, depth: 2, leaf buckets: 3, nodes: 1333 
    Average node length: 4.43, total dup: 1236, max dup: 158 
    Average key length: 2.79, compression ratio: 6.82 
    Average prefix length: 18.28, average data length: 0.72 
    Clustering factor: 702, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.68, total records: 73 
    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: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, 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 MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    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: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    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: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.90, total records: 801479 
    Average version length: 37.90, total versions: 36407, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8376 
    Data pages: 8376, average fill: 66% 
    Primary pages: 8375, secondary pages: 1, swept pages: 1122 
    Empty pages: 18, full pages: 6952 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 97 
    40 - 59% = 398 
    60 - 79% = 7762 
    80 - 99% = 77 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 856, nodes: 782669 
    Average node length: 4.88, total dup: 782620, max dup: 141509 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90737, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 141 
        40 - 59% = 440 
        60 - 79% = 185 
        80 - 99% = 87 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 961, nodes: 782669 
    Average node length: 5.89, total dup: 696808, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158313, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 95 
        40 - 59% = 511 
        60 - 79% = 105 
        80 - 99% = 248 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 998, nodes: 782669 
    Average node length: 5.89, total dup: 696808, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160167, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 139 
        40 - 59% = 522 
        60 - 79% = 100 
        80 - 99% = 236 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1122, nodes: 782669 
    Average node length: 5.97, total dup: 696808, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153178, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 265 
        40 - 59% = 586 
        60 - 79% = 178 
        80 - 99% = 91 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.68, total records: 5427 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.13, total fragments: 46, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.05 
    Pointer pages: 1, data page slots: 136 
    Data pages: 95, average fill: 56% 
    Primary pages: 76, secondary pages: 19, swept pages: 55 
    Empty pages: 13, full pages: 57 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5427 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.02 
    Average prefix length: 34.35, average data length: 1.55 
    Clustering factor: 5168, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5427 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 164, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 79446 
    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: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 832 
    Data pages: 832, average fill: 66% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 825 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 825 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 31082, depth: 2, leaf buckets: 103, nodes: 79446 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3033, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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 PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.49, total records: 71 
    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: 1691.00, compression ratio: 15.30 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.20, total records: 165208 
    Average version length: 151.74, total versions: 2622, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 4472 
    Data pages: 4128, average fill: 83% 
    Primary pages: 4127, secondary pages: 1, swept pages: 2 
    Empty pages: 52, full pages: 4058 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4058 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 148.17, total records: 134052 
    Average version length: 151.61, total versions: 2617, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 4328 
    Data pages: 3344, average fill: 83% 
    Primary pages: 3341, secondary pages: 3, swept pages: 4 
    Empty pages: 42, full pages: 3278 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 3278 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 143.97, total records: 143559 
    Average version length: 153.11, total versions: 7126, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 7, data page slots: 6888 
    Data pages: 3704, average fill: 80% 
    Primary pages: 3702, secondary pages: 2, swept pages: 8 
    Empty pages: 149, full pages: 3501 
    Fill distribution: 
     0 - 19% = 152 
    20 - 39% = 21 
    40 - 59% = 11 
    60 - 79% = 21 
    80 - 99% = 3499 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.88, total records: 143943 
    Average version length: 153.32, total versions: 4099, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 7, data page slots: 5096 
    Data pages: 3656, average fill: 81% 
    Primary pages: 3654, secondary pages: 2, swept pages: 1 
    Empty pages: 109, full pages: 3518 
    Fill distribution: 
     0 - 19% = 110 
    20 - 39% = 11 
    40 - 59% = 9 
    60 - 79% = 8 
    80 - 99% = 3518 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.81, total records: 160965 
    Average version length: 148.31, total versions: 767, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 8, data page slots: 4272 
    Data pages: 4000, average fill: 83% 
    Primary pages: 3999, secondary pages: 1, swept pages: 3 
    Empty pages: 32, full pages: 3953 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3953 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 139.41, total records: 163504 
    Average version length: 154.64, total versions: 13542, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.17 
    Pointer pages: 6, data page slots: 4544 
    Data pages: 4120, average fill: 83% 
    Primary pages: 4118, secondary pages: 2, swept pages: 3 
    Empty pages: 85, full pages: 4013 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 11 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4013 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 146.85, total records: 149376 
    Average version length: 152.60, total versions: 4370, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 8, data page slots: 4984 
    Data pages: 3784, average fill: 82% 
    Primary pages: 3783, secondary pages: 1, swept pages: 4 
    Empty pages: 96, full pages: 3655 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 9 
    40 - 59% = 9 
    60 - 79% = 6 
    80 - 99% = 3655 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 149.17, total records: 144352 
    Average version length: 151.99, total versions: 2025, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 5248 
    Data pages: 3600, average fill: 83% 
    Primary pages: 3599, secondary pages: 1, swept pages: 3 
    Empty pages: 42, full pages: 3534 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 10 
    80 - 99% = 3534 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 148.59, total records: 146750 
    Average version length: 152.05, total versions: 2436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 5040 
    Data pages: 3664, average fill: 83% 
    Primary pages: 3662, secondary pages: 2, swept pages: 7 
    Empty pages: 53, full pages: 3588 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 3588 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 147.17, total records: 140977 
    Average version length: 153.06, total versions: 3547, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 5, data page slots: 4936 
    Data pages: 3512, average fill: 83% 
    Primary pages: 3511, secondary pages: 1, swept pages: 1 
    Empty pages: 49, full pages: 3448 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 3448 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    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 PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.91, total records: 2126108 
    Average version length: 52.80, total versions: 40826, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25768 
    Data pages: 25768, average fill: 71% 
    Primary pages: 25755, secondary pages: 13, swept pages: 9615 
    Empty pages: 95, full pages: 23784 
    Fill distribution: 
     0 - 19% = 199 
    20 - 39% = 161 
    40 - 59% = 497 
    60 - 79% = 24476 
    80 - 99% = 435 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2611, nodes: 2126108 
    Average node length: 5.44, total dup: 1984441, max dup: 1406 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183876, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 300 
        40 - 59% = 1713 
        60 - 79% = 285 
        80 - 99% = 310 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2126108 
    Average node length: 5.69, total dup: 1909045, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 379960, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 2369 
        60 - 79% = 363 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2111, nodes: 2126108 
    Average node length: 4.96, total dup: 2126008, max dup: 28339 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181278, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 189 
        40 - 59% = 1054 
        60 - 79% = 402 
        80 - 99% = 465 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    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: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    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: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    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: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    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 TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, 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 TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    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 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    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 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    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 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    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 TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    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 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    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 TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    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 TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    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 RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    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 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    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: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    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: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 42.39, total records: 154152 
    Average version length: 69.18, total versions: 68689, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.97 
    Pointer pages: 3, data page slots: 4160 
    Data pages: 2960, average fill: 63% 
    Primary pages: 2960, secondary pages: 0, swept pages: 356 
    Empty pages: 502, full pages: 2150 
    Fill distribution: 
     0 - 19% = 626 
    20 - 39% = 40 
    40 - 59% = 60 
    60 - 79% = 957 
    80 - 99% = 1277 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 326557, depth: 3, leaf buckets: 216, nodes: 154152 
    Average node length: 6.46, total dup: 134100, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 27257, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 17 
        40 - 59% = 115 
        60 - 79% = 58 
        80 - 99% = 24 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.08, total records: 6985412 
    Average version length: 68.80, total versions: 451113, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 65, data page slots: 105176 
    Data pages: 105176, average fill: 72% 
    Primary pages: 105176, secondary pages: 0, swept pages: 11447 
    Empty pages: 113, full pages: 79248 
    Fill distribution: 
     0 - 19% = 867 
    20 - 39% = 1374 
    40 - 59% = 5618 
    60 - 79% = 95767 
    80 - 99% = 1550 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10653, nodes: 6985412 
    Average node length: 6.51, total dup: 6044327, max dup: 36 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1644827, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1689 
        40 - 59% = 5914 
        60 - 79% = 2582 
        80 - 99% = 465 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8446, nodes: 6985412 
    Average node length: 5.40, total dup: 6705455, max dup: 171 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1450564, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1251 
        40 - 59% = 4615 
        60 - 79% = 1526 
        80 - 99% = 1048 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8517, nodes: 6985412 
    Average node length: 5.40, total dup: 6705455, max dup: 171 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1452801, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1358 
        40 - 59% = 4575 
        60 - 79% = 1556 
        80 - 99% = 1022 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.05, total records: 11897787 
    Average version length: 68.73, total versions: 373308, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 106, data page slots: 171792 
    Data pages: 171792, average fill: 74% 
    Primary pages: 171791, secondary pages: 1, swept pages: 54810 
    Empty pages: 5, full pages: 156667 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 466 
    40 - 59% = 3816 
    60 - 79% = 165137 
    80 - 99% = 2336 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18339, nodes: 11895034 
    Average node length: 6.59, total dup: 10370593, max dup: 61 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2461067, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 2518 
        40 - 59% = 10843 
        60 - 79% = 4204 
        80 - 99% = 755 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 46.66, total records: 1763102 
    Average version length: 69.09, total versions: 395423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.70 
    Pointer pages: 30, data page slots: 46896 
    Data pages: 29021, average fill: 62% 
    Primary pages: 28935, secondary pages: 86, swept pages: 5167 
    Empty pages: 1702, full pages: 21962 
    Fill distribution: 
     0 - 19% = 2810 
    20 - 39% = 3645 
    40 - 59% = 2576 
    60 - 79% = 14346 
    80 - 99% = 5644 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1939, nodes: 1498967 
    Average node length: 5.53, total dup: 1438313, max dup: 49 
    Average key length: 2.56, compression ratio: 16.41 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 102751, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 370 
        40 - 59% = 955 
        60 - 79% = 487 
        80 - 99% = 120 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 35.87, total records: 1298138 
    Average version length: 69.02, total versions: 159590, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.51 
    Pointer pages: 22, data page slots: 34928 
    Data pages: 26752, average fill: 39% 
    Primary pages: 26751, secondary pages: 1, swept pages: 5430 
    Empty pages: 5899, full pages: 12071 
    Fill distribution: 
     0 - 19% = 8829 
    20 - 39% = 3399 
    40 - 59% = 5921 
    60 - 79% = 8196 
    80 - 99% = 407 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1143, nodes: 740837 
    Average node length: 5.96, total dup: 680972, max dup: 70 
    Average key length: 3.03, compression ratio: 13.85 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 108466, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 345 
        40 - 59% = 567 
        60 - 79% = 216 
        80 - 99% = 15 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.74, total records: 9410929 
    Average version length: 68.91, total versions: 489017, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 90, data page slots: 146688 
    Data pages: 146640, average fill: 69% 
    Primary pages: 146623, secondary pages: 17, swept pages: 36460 
    Empty pages: 391, full pages: 89090 
    Fill distribution: 
     0 - 19% = 1012 
    20 - 39% = 4956 
    40 - 59% = 18280 
    60 - 79% = 118697 
    80 - 99% = 3695 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13484, nodes: 9404674 
    Average node length: 6.70, total dup: 7799007, max dup: 15 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2126194, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1099 
        40 - 59% = 6554 
        60 - 79% = 4924 
        80 - 99% = 904 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21129637 
    Average version length: 83.00, total versions: 13397, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319352 
    Data pages: 319352, average fill: 81% 
    Primary pages: 319348, secondary pages: 4, swept pages: 12358 
    Empty pages: 16, full pages: 319227 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 3 
    40 - 59% = 8 
    60 - 79% = 48649 
    80 - 99% = 270670 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19253, nodes: 21129637 
    Average node length: 5.72, total dup: 20649061, max dup: 130 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281683, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 7936 
        60 - 79% = 509 
        80 - 99% = 10804 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17147, nodes: 21129637 
    Average node length: 6.31, total dup: 18567840, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917999, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 4 
        40 - 59% = 740 
        60 - 79% = 284 
        80 - 99% = 16116 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21014, nodes: 21129637 
    Average node length: 6.35, total dup: 18487733, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575168, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 4 
        40 - 59% = 8141 
        60 - 79% = 596 
        80 - 99% = 12265 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16096, nodes: 21129637 
    Average node length: 5.56, total dup: 21129537, max dup: 228720 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946752, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 8 
        40 - 59% = 2939 
        60 - 79% = 344 
        80 - 99% = 12803 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.01, total records: 9829221 
    Average version length: 82.61, total versions: 455395, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 107, data page slots: 174280 
    Data pages: 174224, average fill: 70% 
    Primary pages: 174190, secondary pages: 34, swept pages: 58855 
    Empty pages: 532, full pages: 104716 
    Fill distribution: 
     0 - 19% = 1430 
    20 - 39% = 6865 
    40 - 59% = 24604 
    60 - 79% = 119328 
    80 - 99% = 21997 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11349, nodes: 9829221 
    Average node length: 5.38, total dup: 9518863, max dup: 186 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2219205, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 58 
        40 - 59% = 7659 
        60 - 79% = 3499 
        80 - 99% = 130 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13703, nodes: 9829221 
    Average node length: 6.25, total dup: 8146726, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1557349, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 3931 
        40 - 59% = 4474 
        60 - 79% = 2640 
        80 - 99% = 2519 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12670, nodes: 9829221 
    Average node length: 5.99, total dup: 8531848, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2411892, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 56 
        40 - 59% = 8618 
        60 - 79% = 3853 
        80 - 99% = 142 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10293, nodes: 9829221 
    Average node length: 5.15, total dup: 9829121, max dup: 157942 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1595007, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1171 
        40 - 59% = 5248 
        60 - 79% = 1718 
        80 - 99% = 2111 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.34, total records: 11481970 
    Average version length: 82.53, total versions: 307239, max versions: 1 
    Average fragment length: 73.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 120, data page slots: 194800 
    Data pages: 193400, average fill: 73% 
    Primary pages: 193268, secondary pages: 132, swept pages: 61041 
    Empty pages: 2643, full pages: 154219 
    Fill distribution: 
     0 - 19% = 4351 
    20 - 39% = 6411 
    40 - 59% = 14831 
    60 - 79% = 102147 
    80 - 99% = 65660 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13116, nodes: 11481970 
    Average node length: 5.30, total dup: 11371790, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2414452, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 107 
        40 - 59% = 8670 
        60 - 79% = 4167 
        80 - 99% = 171 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10509, nodes: 11481970 
    Average node length: 5.50, total dup: 10980936, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 744418, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 771 
        40 - 59% = 2554 
        60 - 79% = 1848 
        80 - 99% = 5176 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14991, nodes: 11481970 
    Average node length: 6.03, total dup: 10023649, max dup: 64 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2430976, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 140 
        40 - 59% = 10076 
        60 - 79% = 4554 
        80 - 99% = 220 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10914, nodes: 11481970 
    Average node length: 5.23, total dup: 11481870, max dup: 192773 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 732137, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 762 
        40 - 59% = 4971 
        60 - 79% = 1460 
        80 - 99% = 3627 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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 XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 79.61, total records: 9909792 
    Average version length: 82.85, total versions: 419852, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 110, data page slots: 178152 
    Data pages: 178072, average fill: 69% 
    Primary pages: 178046, secondary pages: 26, swept pages: 64024 
    Empty pages: 581, full pages: 103049 
    Fill distribution: 
     0 - 19% = 1664 
    20 - 39% = 8150 
    40 - 59% = 27693 
    60 - 79% = 119286 
    80 - 99% = 21279 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11953, nodes: 9909792 
    Average node length: 5.19, total dup: 9880513, max dup: 1553 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2034805, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1398 
        40 - 59% = 7984 
        60 - 79% = 1954 
        80 - 99% = 594 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13838, nodes: 9909792 
    Average node length: 6.26, total dup: 8213802, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1525695, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 193 
        20 - 39% = 3938 
        40 - 59% = 4495 
        60 - 79% = 2621 
        80 - 99% = 2591 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12586, nodes: 9909792 
    Average node length: 5.45, total dup: 9465985, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2168967, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1444 
        40 - 59% = 8761 
        60 - 79% = 1749 
        80 - 99% = 603 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10429, nodes: 9909792 
    Average node length: 5.16, total dup: 9909692, max dup: 160068 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1620806, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1214 
        40 - 59% = 5349 
        60 - 79% = 1742 
        80 - 99% = 2083 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.53, total records: 580592 
    Average version length: 68.78, total versions: 6309, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8048 
    Data pages: 8048, average fill: 76% 
    Primary pages: 8048, secondary pages: 0, swept pages: 2728 
    Empty pages: 2, full pages: 7621 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 2 
    40 - 59% = 33 
    60 - 79% = 7926 
    80 - 99% = 85 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 33506, depth: 3, leaf buckets: 736, nodes: 580592 
    Average node length: 5.95, total dup: 494304, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102201, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 24 
        40 - 59% = 520 
        60 - 79% = 95 
        80 - 99% = 96 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26414, depth: 3, leaf buckets: 755, nodes: 580592 
    Average node length: 6.15, total dup: 476213, max dup: 19 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102249, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 18 
        40 - 59% = 541 
        60 - 79% = 96 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 554, nodes: 580592 
    Average node length: 4.86, total dup: 580492, max dup: 9752 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90753, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 321 
        60 - 79% = 63 
        80 - 99% = 148 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    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 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    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 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    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 ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    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 ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    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 ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    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 ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    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 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    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 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    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: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Mar 21 10:10:22 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7785652 80180 1 0.0000 0.0000
DOC_LIST 2264963 40712 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2811 8 700.0000 0.0000
INVNT_TURNOVER_LOG 72817 62138 1 0.0000 0.0000
MONEY_SALDO 49 188 6 300.0000 0.0000
MONEY_TURNOVER_LOG 1333 1215 1 0.0000 0.0000
PDISTR 801479 36407 2 0.0000 0.0000
PERF_SPLIT_0 165208 2622 1 0.0000 0.0000
PERF_SPLIT_1 134052 2617 1 0.0000 0.0000
PERF_SPLIT_2 143559 7126 1 0.0000 0.0000
PERF_SPLIT_3 143943 4099 1 0.0000 0.0000
PERF_SPLIT_4 160965 767 1 0.0000 0.0000
PERF_SPLIT_5 163504 13542 1 0.0000 0.0000
PERF_SPLIT_6 149376 4370 1 0.0000 0.0000
PERF_SPLIT_7 144352 2025 1 0.0000 0.0000
PERF_SPLIT_8 146750 2436 1 0.0000 0.0000
PERF_SPLIT_9 140977 3547 1 0.0000 0.0000
PSTORNED 2126108 40826 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 154152 68689 1 0.0000 0.0000
XQD_1000_3300 6985412 451113 1 0.0000 0.0000
XQD_1200_2000 11897787 373308 1 0.0000 0.0000
XQD_2000_3300 1763102 395423 1 0.0000 0.0000
XQD_2100_3300 1298138 159590 1 0.0000 0.0000
XQD_3300_3400 9410929 489017 1 0.0000 0.0000
XQS_1000_1200 21129637 13397 1 0.0000 0.0000
XQS_1000_3300 9829221 455395 1 0.0000 0.0000
XQS_1200_2000 11481970 307239 1 0.0000 0.0000
XQS_2100_3300 9909792 419852 1 0.0000 0.0000
XQS_3300_3400 580592 6309 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test 

--- start of diff output ---
--- end of diff output ---

 Final processing ISQL logs in /var/tmp/logs-oltp40 according to config parameter 'remove_isql_logs'  

21.03.24 10:10:34. There are 3 logs in /var/tmp/logs-oltp40 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
            0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
    335544321 'string truncation'. Attempt to assign too long text into string variable.
    335544347 'not_valid'. Validation error for column.
    335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
    335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
    335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
    335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
    335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2024-03-21 10:10:37 No severe PSQL-related problems occured
21.03.24 10:10:38. End of report.