Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.03.2024 13: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 15459728 kB
MemAvailable 30276364 kB
Buffers 0 kB
Cached 16285820 kB
SwapCached 2596 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 13:07:48
DTS_END                         2024-03-21 13:07:48.6640
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/54608
TRN_ID                          175235
ATT_ID                          493
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: 9398.73 21639 939873
customer order: creation 179.42 402 17942
customer order: refuse 15.83 372 1583
order to supplier: creation 47.48 1367 4748
order to supplier: removal 3.44 99042 344
invoice (draft): creation 48.01 3097 4801
invoice (draft): removal 50.65 684 5065
invoice accept: apply 42.63 20791 4263
invoice accept: cancel 46.59 836 4659
customer reserve: creation 4099.66 200 409966
customer reserve: removal 4552.61 61 455261
realization accept: apply 88.89 221 8889
realization accept: cancel 90.36 128 9036
payment from customer: creation 61.92 120 6192
payment from customer: removal 5.98 83 598
payment to supplier: creation 51.03 163 5103
payment to supplier: removal 3.27 53 327
service: total inventory turnovers 3.87 4136 387
service: total monetary turnovers 6.07 570 607
service: aggregate perf. data 0.98 15530 98
service: refresh index statistics 0.04 284925 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-03-2024 13:10:11 to 21-03-2024 13:10:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2424
TEST_TIME 2 1950
TEST_TIME 3 2772
TEST_TIME 4 3509
TEST_TIME 5 3865
TEST_TIME 6 4053
TEST_TIME 7 4568
TEST_TIME 8 4665
TEST_TIME 9 5077
TEST_TIME 10 5086
TEST_TIME 11 5656
TEST_TIME 12 5918
TEST_TIME 13 6214
TEST_TIME 14 6444
TEST_TIME 15 7068
TEST_TIME 16 7308
TEST_TIME 17 7491
TEST_TIME 18 7513
TEST_TIME 19 7805
TEST_TIME 20 8592
TEST_TIME 21 8540
TEST_TIME 22 8621
TEST_TIME 23 9236
TEST_TIME 24 9343
TEST_TIME 25 9617
TEST_TIME 26 10415
TEST_TIME 27 10328
TEST_TIME 28 10488
TEST_TIME 29 10268
TEST_TIME 30 10158
TEST_TIME 31 10260
TEST_TIME 32 10339
TEST_TIME 33 10362
TEST_TIME 34 10221
TEST_TIME 35 10137
TEST_TIME 36 9980
TEST_TIME 37 9908
TEST_TIME 38 9885
TEST_TIME 39 9840
TEST_TIME 40 9662
TEST_TIME 41 9722
TEST_TIME 42 10002
TEST_TIME 43 9929
TEST_TIME 44 9934
TEST_TIME 45 9816
TEST_TIME 46 9913
TEST_TIME 47 9933
TEST_TIME 48 9911
TEST_TIME 49 9911
TEST_TIME 50 9977
TEST_TIME 51 9963
TEST_TIME 52 10000
TEST_TIME 53 10032
TEST_TIME 54 10058
TEST_TIME 55 10147
TEST_TIME 56 10076
TEST_TIME 57 10187
TEST_TIME 58 10052
TEST_TIME 59 9992
TEST_TIME 60 9898
TEST_TIME 61 9863
TEST_TIME 62 9835
TEST_TIME 63 9755
TEST_TIME 64 9661
TEST_TIME 65 9758
TEST_TIME 66 9712
TEST_TIME 67 9690
TEST_TIME 68 9696
TEST_TIME 69 9711
TEST_TIME 70 9768
TEST_TIME 71 9756
TEST_TIME 72 9848
TEST_TIME 73 9882
TEST_TIME 74 9897
TEST_TIME 75 9905
TEST_TIME 76 9886
TEST_TIME 77 9811
TEST_TIME 78 9722
TEST_TIME 79 9656
TEST_TIME 80 9595
TEST_TIME 81 9501
TEST_TIME 82 9518
TEST_TIME 83 9593
TEST_TIME 84 9555
TEST_TIME 85 9587
TEST_TIME 86 9594
TEST_TIME 87 9592
TEST_TIME 88 9612
TEST_TIME 89 9567
TEST_TIME 90 9642
TEST_TIME 91 9613
TEST_TIME 92 9650
TEST_TIME 93 9649
TEST_TIME 94 9685
TEST_TIME 95 9672
TEST_TIME 96 9589
TEST_TIME 97 9518
TEST_TIME 98 9505
TEST_TIME 99 9474
TEST_TIME 100 9403

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-03-2024 13:10:15 to 21-03-2024 13:10:18.

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 1315066 1315066 0 0.00 0 25515 8 0 0
doc_list_biud 1315063 1315063 0 0.00 0 31351 26 0 0
sp_add_invoice_to_stock 4414 4263 151 3.42 28 196704 20791 0 151
sp_cancel_adding_invoice 4659 4659 0 0.00 4 71609 837 0 0
sp_cancel_client_order 1583 1583 0 0.00 4 10947 373 0 0
sp_cancel_customer_reserve 455261 455261 0 0.00 0 23595 61 0 0
sp_cancel_pay_from_customer 598 598 0 0.00 2 5607 84 0 0
sp_cancel_pay_to_supplier 327 327 0 0.00 3 2639 53 0 0
sp_cancel_supplier_invoice 5075 5065 10 0.19 1 31368 684 0 10
sp_cancel_supplier_order 344 344 0 0.00 12 954054 99042 0 0
sp_cancel_write_off 9036 9036 0 0.00 1 23343 128 0 0
sp_client_order 17942 17942 0 0.00 3 23575 403 0 0
sp_customer_reserve 409966 409966 0 0.00 0 121945 200 0 0
sp_fill_shopping_cart 27488 27488 0 0.00 1 17485 34 0 0
sp_fill_shopping_cart_clo_res 409961 409961 0 0.00 0 20669 14 0 0
sp_get_clo_for_invoice 4257 4257 0 0.00 0 28215 323 0 0
sp_kill_cost_storno 14620 14620 0 0.00 0 7056 67 0 0
sp_kill_qstorno_ret_qs2qd 924967 924967 0 0.00 0 31348 33 0 0
sp_kill_qty_storno 489091 489091 0 0.00 0 31351 70 0 0
sp_lock_selected_doc 18202 18202 0 0.00 0 6243 5 0 0
sp_make_cost_storno 24441 24441 0 0.00 0 25503 74 0 0
sp_multiply_rows_for_pdistr 24440 24440 0 0.00 0 10834 37 0 0
sp_multiply_rows_for_qdistr 17942 17942 0 0.00 0 14132 206 0 0
sp_pay_from_customer 6192 6192 0 0.00 4 13547 120 0 0
sp_pay_to_supplier 5103 5103 0 0.00 4 14749 164 0 0
sp_payment_common 11295 11295 0 0.00 1 12747 34 0 0
sp_qd_handle_on_cancel_clo 1583 1583 0 0.00 0 10940 338 0 0
sp_qd_handle_on_invoice_upd_sts 8915 8915 0 0.00 0 21263 294 0 0
sp_qd_handle_on_reserve_upd_sts 8887 8887 0 0.00 0 22068 59 0 0
sp_reserve_write_off 8889 8889 0 0.00 6 25626 222 0 0
sp_supplier_invoice 4801 4801 0 0.00 6 92934 3097 0 0
sp_supplier_order 4748 4748 0 0.00 5 58261 1367 0 0
srv_aggregate_perf_data 98 98 0 0.00 2015 191760 15531 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1255 148900 44933 0 0
srv_find_qd_qs_mism 895969 895969 0 0.00 0 15395 7 0 0
srv_make_invnt_saldo 387 387 0 0.00 27 136793 4136 0 0
srv_make_money_saldo 607 607 0 0.00 1 17088 570 0 0
srv_recalc_idx_stat 4 4 0 0.00 144617 481139 284926 0 0
t$perf-abend:sp_add_invoice_to_stock 151 151 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4263 4263 0 0.00 0 8206 169 0 0
t$perf-norm:sp_cancel_adding_invoice 397 397 0 0.00 0 11307 115 0 0
t$perf-norm:sp_cancel_client_order 1583 1583 0 0.00 0 2577 14 0 0
t$perf-norm:sp_cancel_customer_reserve 624 624 0 0.00 0 1158 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 598 598 0 0.00 0 723 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 327 327 0 0.00 0 1217 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 341 341 0 0.00 0 2570 28 0 0
t$perf-norm:sp_cancel_supplier_order 344 344 0 0.00 0 35087 1717 0 0
t$perf-norm:sp_cancel_write_off 846 846 0 0.00 0 771 3 0 0
t$perf-norm:sp_client_order 17942 17942 0 0.00 0 8970 15 0 0
t$perf-norm:sp_customer_reserve 889 889 0 0.00 0 1837 6 0 0
t$perf-norm:sp_pay_from_customer 6192 6192 0 0.00 0 10789 10 0 0
t$perf-norm:sp_pay_to_supplier 5103 5103 0 0.00 0 13636 15 0 0
t$perf-norm:sp_reserve_write_off 8889 8889 0 0.00 0 4269 11 0 0
t$perf-norm:sp_supplier_invoice 4801 4801 0 0.00 0 4277 18 0 0
t$perf-norm:sp_supplier_order 4748 4748 0 0.00 0 5775 15 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 308 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 46 2 0 0
t$perf-norm:srv_make_invnt_saldo 387 387 0 0.00 0 831 10 0 0
t$perf-norm:srv_make_money_saldo 607 607 0 0.00 0 944 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 8814 8512 302 3.42 0 6134 15 0 302
v_all_customers 33174 33174 0 0.00 0 25 1 0 0
v_all_suppliers 27346 27346 0 0.00 0 92 1 0 0
v_all_wares 35884 35884 0 0.00 0 70 1 0 0
v_cancel_adding_invoice 794 794 0 0.00 0 6129 16 0 0
v_cancel_client_order 3166 3166 0 0.00 0 5441 8 0 0
v_cancel_customer_prepayment 1196 1196 0 0.00 0 5592 9 0 0
v_cancel_customer_reserve 1248 1248 0 0.00 0 3731 8 0 0
v_cancel_payment_to_supplier 654 654 0 0.00 0 1675 6 0 0
v_cancel_supplier_invoice 702 682 20 2.84 0 2846 18 0 20
v_cancel_supplier_order 688 688 0 0.00 0 556 4 0 0
v_cancel_write_off 1692 1692 0 0.00 0 3922 15 0 0
v_max_id_clo_ord 4745 4745 0 0.00 0 706 1 0 0
v_max_id_clo_res 889 889 0 0.00 0 7873 17 0 0
v_max_id_ord_sup 4801 4801 0 0.00 0 4628 6 0 0
v_max_non_paid_invoice 976 976 0 0.00 0 2888 8 0 0
v_max_non_paid_realizn 3094 3094 0 0.00 0 4310 4 0 0
v_min_id_clo_ord 4745 4745 0 0.00 0 1098 5 0 0
v_min_id_clo_res 889 889 0 0.00 0 3389 7 0 0
v_min_id_ord_sup 4801 4801 0 0.00 0 11030 6 0 0
v_min_non_paid_invoice 5103 5103 0 0.00 0 10659 36 0 0
v_min_non_paid_realizn 6192 6192 0 0.00 0 10638 22 0 0
v_our_firm 8906 8906 0 0.00 0 29 1 0 0
v_reserve_write_off 17772 17772 0 0.00 0 6290 7 0 0
x_lock_depdocs_on_canc_invoice 9383 9383 0 0.00 0 16819 118 0 0
x_lock_depdocs_on_canc_sup_ord 344 344 0 0.00 0 9034 325 0 0
x_make_qstorno_1000_1200 4748 4748 0 0.00 1 58252 1294 0 0
x_make_qstorno_1200_2000 4801 4801 0 0.00 2 91591 2973 0 0
x_make_qstorno_2100_3300 409966 409966 0 0.00 0 121944 184 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-03-2024 13:10:19 to 21-03-2024 13:10:23.

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
11:07:52 16 8192000000 8808273872 8823304192 12117552 0.147 4 4 5 0 12393424 163328 112544
11:08:53 29096 8192000000 9709728544 10004422656 783791968 8.732 100 92 184 0 813898928 7640112 22466848
11:10:28 16904 8192000000 9739265472 10043318272 815222576 9.050 100 94 188 0 849894336 11974880 22696880
11:11:56 13642 8192000000 9768089744 10079662080 834126528 9.241 100 85 170 1 874883824 20882896 19874400
11:13:24 7366 8192000000 9826812096 10156183552 888005584 9.779 100 69 138 0 936255520 33315120 14934816
11:14:35 10080 8192000000 9898587408 10240561152 931650032 10.211 100 71 143 0 1005295888 58915312 14730544
11:15:48 4823 8192000000 9933408560 10285305856 961882032 10.507 100 84 167 0 1044115712 65794464 16439216
11:16:55 2461 8192000000 9951199136 10309324800 993401088 10.814 100 80 160 0 1065671808 56199952 16070768
11:18:00 1882 8192000000 10003715088 10369441792 1013307648 11.007 100 91 182 0 1111133984 80330304 17496032
11:19:06 1741 8192000000 10038342608 10408050688 1039974768 11.264 100 89 178 1 1152596512 95900368 16721376
11:20:09 21821 8192000000 9995540336 10381029376 1061041632 11.466 100 59 114 1 1104289952 31787456 11460864
11:21:32 5121 8192000000 10007218144 10399191040 1070726320 11.559 100 41 81 0 1125043312 46758448 7558544
11:22:38 5866 8192000000 10011731104 10402390016 1075099184 11.601 100 47 94 0 1125472608 40419728 9953696
11:23:46 4793 8192000000 9995376544 10397278208 1083796048 11.684 100 40 76 1 1118811488 26789488 8225952
11:24:54 4465 8192000000 9999590288 10398388224 1084892496 11.694 100 51 101 0 1105881072 9530720 11457856
11:26:00 4733 8192000000 10017694320 10429259776 1088651600 11.730 100 37 70 0 1129289872 33649728 6988544
11:27:05 6243 8192000000 10023147680 10421825536 1081045632 11.657 99 29 55 0 1120013424 33602528 5365264
11:28:20 17399 8192000000 10010309248 10410139648 1087499248 11.719 100 39 79 0 1114749920 18926960 8323712
11:29:44 44292 8192000000 10041678544 10442993664 1087942864 11.723 99 49 97 0 1143187600 45308480 9936256
11:31:31 14586 8192000000 10068649248 10464350208 1084287248 11.688 98 51 102 0 1163302032 69096400 9918384
11:32:50 21506 8192000000 10087190432 10497376256 1104175616 11.877 99 37 74 0 1198817760 86735296 7906848
11:34:25 16302 8192000000 10112000912 10512076800 1093550480 11.776 98 50 100 0 1209272464 104329632 11392352
11:35:44 24102 8192000000 10134261296 10557255680 1077942224 11.628 97 44 88 1 1233643616 146244160 9457232
11:37:12 36592 8192000000 10156846960 10557833216 1043160656 11.295 95 44 88 0 1210267264 157656720 9449888
11:38:54 1254 8192000000 10196269680 10595336192 1093176032 11.773 100 78 156 3 1304296704 194535296 16585376
11:40:01 10188 8192000000 10185087360 10573930496 1080890000 11.656 99 64 128 0 1277110144 182718800 13501344
11:41:14 8493 8192000000 10214475200 10618765312 1107797552 11.912 100 50 100 0 1323065600 204097856 11170192
11:42:26 6149 8192000000 10208245088 10619150336 1109427552 11.927 100 47 91 0 1308259376 188261136 10570688
11:43:37 2944 8192000000 10275781280 10666541056 1116362320 11.993 100 86 173 0 1368328912 234019760 17946832
11:44:44 3396 8192000000 10274392768 10673983488 1108939872 11.922 100 69 138 1 1372760448 249816560 14004016
11:45:54 6068 8192000000 10302840928 10735575040 1123147312 12.057 100 61 120 0 1404995648 268087328 13761008
11:47:03 3009 8192000000 10292266992 10752212992 1141772128 12.232 100 74 147 0 1389153072 231208672 16172272
11:48:11 23833 8192000000 10301890256 10726129664 1132835344 12.148 99 32 63 0 1371855072 231705984 7313744
11:49:44 2793 8192000000 10366312208 10787643392 1151954448 12.328 100 55 110 0 1463883680 299727456 12201776
11:50:55 12047 8192000000 10294137184 10719621120 1141429472 12.229 99 30 60 1 1386771600 238068176 7273952
11:52:08 34271 8192000000 10255938720 10736730112 1138308160 12.200 100 20 40 0 1365184688 222467856 4408672
11:54:45 54570 8192000000 10081134176 10573946880 1123446736 12.060 100 18 36 0 1176685808 50229296 3009776
11:56:41 38573 8192000000 10076053088 10518122496 1125343392 12.077 99 20 40 0 1183830608 54359040 4128176
11:58:23 27324 8192000000 10097116064 10567778304 1121987616 12.046 99 22 43 0 1184642240 58820368 3834256
11:59:51 69533 8192000000 10059327936 10486562816 1122201232 12.048 99 23 44 1 1165908368 39449936 4257200
12:02:02 64626 8192000000 10053131504 10492907520 1138470112 12.201 100 22 42 0 1178809136 35848064 4490960
12:04:17 106108 8192000000 10122396960 10574835712 1130942032 12.130 98 30 60 1 1180493696 43473312 6078352
12:07:05 28699 8192000000 10188272256 10621153280 1159077856 12.395 100 47 94 1 1282279232 112706416 10494960
12:08:38 64177 8192000000 10133353312 10655293440 1119448736 12.022 97 21 42 0 1286835648 162278800 5108112
12:11:28 89738 8192000000 10112820864 10576666624 1136527152 12.183 100 18 36 0 1220305504 79915616 3862736
12:14:07 42687 8192000000 10099025696 10533048320 1111886416 11.950 98 35 68 0 1175936688 57014848 7035424
12:15:54 71417 8192000000 10060318656 10491207680 1039694816 11.262 92 24 48 0 1095270608 50819680 4756112
12:18:06 87977 8192000000 10061579664 10514145280 1066695888 11.521 96 13 26 1 1126134992 56232560 3206544
12:20:34 21318 8192000000 10083338416 10509840384 1102761152 11.864 99 37 73 0 1166791296 56990528 7039616
12:21:56 76801 8192000000 10025841680 10460385280 1053265648 11.392 96 16 32 0 1097562000 41365344 2931008
12:24:14 106822 8192000000 10044801312 10477182976 1079340224 11.641 98 28 56 0 1139077568 53649568 6087776
12:27:01 54029 8192000000 10055105040 10486816768 1102551440 11.862 99 35 70 1 1140771840 31715792 6504608
12:28:56 55978 8192000000 10045573184 10509082624 1109915840 11.932 100 14 28 0 1185120064 72458928 2745296
12:30:52 46711 8192000000 10065583040 10505879552 1094767904 11.788 98 16 33 1 1163001984 65160720 3073360
12:32:39 40584 8192000000 10066049184 10518720512 1093520624 11.776 98 15 30 0 1146082832 49371312 3190896
12:34:21 19803 8192000000 10074053968 10525765632 1109328256 11.926 99 44 88 0 1173207888 54848048 9031584
12:35:46 82194 8192000000 10079231680 10511335424 1070574464 11.558 95 12 24 0 1153532432 80637248 2320720
12:38:12 60540 8192000000 10088915424 10581155840 1121643584 12.043 100 21 42 0 1200523120 74761728 4117808
12:40:18 60195 8192000000 10076770288 10580439040 1111520144 11.947 99 22 45 0 1191403360 75832992 4050224
12:42:19 29732 8192000000 10080387376 10523480064 1120923568 12.036 99 28 56 1 1163759392 37571744 5264080
12:43:52 148900 8192000000 10076194192 10512396288 1131610704 12.137 100 29 56 1 1174232336 36999568 5622064
12:47:29 75133 8192000000 10130461712 10584788992 1127466352 12.097 99 12 24 0 1222902272 92499840 2936080
12:50:53 50281 8192000000 10056498240 10535309312 1120161280 12.029 99 12 22 0 1183553008 61060704 2331024
12:52:47 37900 8192000000 10068242064 10513784832 1124268720 12.067 99 18 36 0 1161109920 33141632 3699568
12:54:35 38106 8192000000 10094949184 10528251904 1137617456 12.193 100 34 68 0 1174379504 29344848 7417200
12:56:25 22294 8192000000 10080203152 10510872576 1119709616 12.024 99 42 84 0 1159559936 31187888 8662432
12:57:48 30843 8192000000 10066012624 10504388608 1131823904 12.139 100 22 44 1 1155826400 19869824 4132672
12:59:19 56880 8192000000 10077587248 10531033088 1096353024 11.803 97 16 32 0 1154905056 55271392 3280640
13:01:16 52537 8192000000 10067018800 10531774464 1098472016 11.823 97 14 28 0 1146167616 45031008 2664592
13:03:09 123411 8192000000 10044190480 10485665792 1081693936 11.664 96 36 72 0 1126816368 37958336 7164096
13:06:13 100651 8192000000 9938072816 10371559424 994877184 10.829 88 11 22 0 1052787200 55656032 2253984

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 13:10:25 to 21-03-2024 13:10:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 151 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-03-2024 13:10:40 to 21-03-2024 13:10:42.

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          176900
MON$OLDEST_ACTIVE               176901
MON$OLDEST_SNAPSHOT             176901
MON$NEXT_TRANSACTION            176901
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                       1941984
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             694
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 13:10:43 2024 
 
Database header page information: 
    Flags            0 
    Generation        92535 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    176900 
    Oldest active        176901 
    Oldest snapshot        176901 
    Next transaction    176902 
    Sequence number        0 
    Next attachment ID    694 
    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.82, total records: 7660087 
    Average version length: 48.16, total versions: 14753, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88672 
    Data pages: 88672, average fill: 69% 
    Primary pages: 88672, secondary pages: 0, swept pages: 55610 
    Empty pages: 5, full pages: 59771 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 79 
    40 - 59% = 2986 
    60 - 79% = 85593 
    80 - 99% = 6 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23311, nodes: 7660087 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1662431, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 352 
        20 - 39% = 2253 
        40 - 59% = 3858 
        60 - 79% = 2775 
        80 - 99% = 14073 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13511, nodes: 7660087 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1485740, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1832 
        40 - 59% = 1816 
        60 - 79% = 1313 
        80 - 99% = 8550 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8316, nodes: 7660087 
    Average node length: 6.60, total dup: 5756185, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1478800, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 106 
        20 - 39% = 1130 
        40 - 59% = 1252 
        60 - 79% = 1125 
        80 - 99% = 4703 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.26, total records: 2194659 
    Average version length: 58.98, total versions: 7334, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28648 
    Data pages: 28648, average fill: 70% 
    Primary pages: 28646, secondary pages: 2, swept pages: 18087 
    Empty pages: 4, full pages: 15180 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 80 
    40 - 59% = 1618 
    60 - 79% = 26909 
    80 - 99% = 24 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4544, nodes: 2194659 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 673909, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1013 
        40 - 59% = 766 
        60 - 79% = 899 
        80 - 99% = 1866 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2419, nodes: 2195313 
    Average node length: 4.97, total dup: 2194415, max dup: 17482 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1253234, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 266 
        40 - 59% = 1406 
        60 - 79% = 527 
        80 - 99% = 217 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1777, nodes: 2194659 
    Average node length: 4.97, total dup: 2194609, max dup: 130263 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1053479, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 624 
        60 - 79% = 45 
        80 - 99% = 1096 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4348, nodes: 2194659 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 673909, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 685 
        40 - 59% = 594 
        60 - 79% = 950 
        80 - 99% = 2025 
 
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.28, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.00, total fragments: 6, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 22% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 12, full pages: 6 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 5 
 
    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.86, total records: 49191 
    Average version length: 68.26, total versions: 41837, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.93 
    Pointer pages: 8, data page slots: 3824 
    Data pages: 1328, average fill: 50% 
    Primary pages: 1327, secondary pages: 1, swept pages: 165 
    Empty pages: 295, full pages: 552 
    Fill distribution: 
     0 - 19% = 471 
    20 - 39% = 124 
    40 - 59% = 102 
    60 - 79% = 147 
    80 - 99% = 484 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705929, depth: 3, leaf buckets: 186, nodes: 49191 
    Average node length: 13.62, total dup: 1007, max dup: 2 
    Average key length: 11.10, compression ratio: 2.43 
    Average prefix length: 18.88, average data length: 8.12 
    Clustering factor: 38787, ratio: 0.79 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 75 
        40 - 59% = 77 
        60 - 79% = 27 
        80 - 99% = 7 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    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: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 19% 
    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_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: 11.47, total records: 1005 
    Average version length: 42.72, total versions: 933, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.06 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 34% 
    Primary pages: 31, secondary pages: 1, swept pages: 3 
    Empty pages: 11, full pages: 4 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94982, depth: 2, leaf buckets: 1, nodes: 1005 
    Average node length: 4.67, total dup: 907, max dup: 96 
    Average key length: 3.01, compression ratio: 6.30 
    Average prefix length: 18.08, average data length: 0.92 
    Clustering factor: 628, ratio: 0.62 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        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.69, 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: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    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: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    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: 37.04, total records: 813386 
    Average version length: 37.93, total versions: 15034, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8848 
    Data pages: 8848, average fill: 63% 
    Primary pages: 8847, secondary pages: 1, swept pages: 4349 
    Empty pages: 23, full pages: 4023 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 91 
    40 - 59% = 1522 
    60 - 79% = 7167 
    80 - 99% = 25 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 883, nodes: 805471 
    Average node length: 4.88, total dup: 805422, max dup: 153663 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90285, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 130 
        40 - 59% = 483 
        60 - 79% = 193 
        80 - 99% = 77 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1010, nodes: 805471 
    Average node length: 5.89, total dup: 716986, max dup: 40 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160054, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 60 
        40 - 59% = 636 
        60 - 79% = 86 
        80 - 99% = 227 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1029, nodes: 805471 
    Average node length: 5.89, total dup: 716986, max dup: 40 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161861, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 94 
        40 - 59% = 624 
        60 - 79% = 90 
        80 - 99% = 221 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1134, nodes: 805471 
    Average node length: 5.97, total dup: 716986, max dup: 40 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154342, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 223 
        40 - 59% = 606 
        60 - 79% = 213 
        80 - 99% = 91 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.95, total records: 5531 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.38, total fragments: 21, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 58% 
    Primary pages: 81, secondary pages: 14, swept pages: 63 
    Empty pages: 10, full pages: 68 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5531 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.09 
    Average prefix length: 34.64, average data length: 1.55 
    Clustering factor: 5277, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        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: 5531 
    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% = 1 
        20 - 39% = 2 
        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.08, total records: 80005 
    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: 0, full pages: 831 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 831 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 39117, depth: 2, leaf buckets: 101, nodes: 80005 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3125, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 101 
 
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: 111.17, 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.21 
    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: 150.66, total records: 157430 
    Average version length: 147.89, total versions: 524, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 7, data page slots: 4072 
    Data pages: 3880, average fill: 84% 
    Primary pages: 3879, secondary pages: 1, swept pages: 9 
    Empty pages: 7, full pages: 3861 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3863 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 149.56, total records: 136157 
    Average version length: 150.94, total versions: 1313, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 8, data page slots: 5152 
    Data pages: 3376, average fill: 83% 
    Primary pages: 3374, secondary pages: 2, swept pages: 1 
    Empty pages: 29, full pages: 3335 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3336 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 147.44, total records: 150879 
    Average version length: 152.53, total versions: 3584, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5328 
    Data pages: 3736, average fill: 83% 
    Primary pages: 3735, secondary pages: 1, swept pages: 6 
    Empty pages: 28, full pages: 3690 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 3 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 3690 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 151.21, total records: 161158 
    Average version length: 139.65, total versions: 182, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.22 
    Pointer pages: 7, data page slots: 4704 
    Data pages: 3992, average fill: 83% 
    Primary pages: 3990, secondary pages: 2, swept pages: 10 
    Empty pages: 23, full pages: 3960 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3960 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.28, total records: 176543 
    Average version length: 152.61, total versions: 1658, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 9, data page slots: 6008 
    Data pages: 4400, average fill: 83% 
    Primary pages: 4397, secondary pages: 3, swept pages: 16 
    Empty pages: 44, full pages: 4337 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4340 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.70, total records: 159349 
    Average version length: 145.64, total versions: 333, 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: 7, data page slots: 5664 
    Data pages: 3992, average fill: 82% 
    Primary pages: 3989, secondary pages: 3, swept pages: 21 
    Empty pages: 73, full pages: 3900 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 3900 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 146.42, total records: 171729 
    Average version length: 154.20, total versions: 5692, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 5304 
    Data pages: 4296, average fill: 83% 
    Primary pages: 4293, secondary pages: 3, swept pages: 52 
    Empty pages: 66, full pages: 4210 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4210 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 150.49, total records: 164357 
    Average version length: 147.82, total versions: 855, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 8, data page slots: 4392 
    Data pages: 4096, average fill: 83% 
    Primary pages: 4094, secondary pages: 2, swept pages: 17 
    Empty pages: 47, full pages: 4032 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 4032 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 147.45, total records: 149289 
    Average version length: 152.97, total versions: 3629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 4672 
    Data pages: 3712, average fill: 83% 
    Primary pages: 3710, secondary pages: 2, swept pages: 9 
    Empty pages: 38, full pages: 3651 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 3650 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 150.49, total records: 176821 
    Average version length: 152.32, total versions: 1058, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 8, data page slots: 5016 
    Data pages: 4392, average fill: 83% 
    Primary pages: 4390, secondary pages: 2, swept pages: 11 
    Empty pages: 37, full pages: 4341 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4341 
 
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: 52.52, total records: 2052213 
    Average version length: 52.83, total versions: 10578, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25880 
    Data pages: 25872, average fill: 68% 
    Primary pages: 25854, secondary pages: 18, swept pages: 13945 
    Empty pages: 271, full pages: 20193 
    Fill distribution: 
     0 - 19% = 550 
    20 - 39% = 510 
    40 - 59% = 1474 
    60 - 79% = 23264 
    80 - 99% = 74 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2569, nodes: 2052213 
    Average node length: 5.45, total dup: 1913714, max dup: 1471 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179244, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 342 
        40 - 59% = 1655 
        60 - 79% = 301 
        80 - 99% = 269 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2755, nodes: 2052213 
    Average node length: 5.70, total dup: 1841082, max dup: 65 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 367779, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2506 
        60 - 79% = 218 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2134, nodes: 2052213 
    Average node length: 4.96, total dup: 2052113, max dup: 27045 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177173, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 227 
        40 - 59% = 1124 
        60 - 79% = 425 
        80 - 99% = 356 
 
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: 50.00, total records: 118720 
    Average version length: 69.18, total versions: 37902, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.52 
    Pointer pages: 3, data page slots: 4352 
    Data pages: 3472, average fill: 41% 
    Primary pages: 3472, secondary pages: 0, swept pages: 818 
    Empty pages: 656, full pages: 716 
    Fill distribution: 
     0 - 19% = 1051 
    20 - 39% = 603 
    40 - 59% = 717 
    60 - 79% = 770 
    80 - 99% = 331 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1556837, depth: 3, leaf buckets: 228, nodes: 118720 
    Average node length: 6.52, total dup: 103167, max dup: 14 
    Average key length: 4.00, compression ratio: 10.49 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 21061, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 111 
        40 - 59% = 96 
        60 - 79% = 21 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.21, total records: 7025720 
    Average version length: 68.71, total versions: 203902, 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: 68, data page slots: 110224 
    Data pages: 110224, average fill: 68% 
    Primary pages: 110223, secondary pages: 1, swept pages: 55514 
    Empty pages: 14, full pages: 37035 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 1087 
    40 - 59% = 13527 
    60 - 79% = 94979 
    80 - 99% = 530 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10848, nodes: 7025720 
    Average node length: 6.51, total dup: 6075857, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1652142, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1847 
        40 - 59% = 6035 
        60 - 79% = 2607 
        80 - 99% = 356 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8759, nodes: 7025720 
    Average node length: 5.40, total dup: 6744370, max dup: 143 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1456175, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1366 
        40 - 59% = 5106 
        60 - 79% = 1380 
        80 - 99% = 893 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8829, nodes: 7025720 
    Average node length: 5.40, total dup: 6744370, max dup: 143 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1458498, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1491 
        40 - 59% = 5047 
        60 - 79% = 1411 
        80 - 99% = 873 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.11, total records: 12034184 
    Average version length: 68.72, total versions: 168775, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 109, data page slots: 177824 
    Data pages: 177824, average fill: 72% 
    Primary pages: 177822, secondary pages: 2, swept pages: 105731 
    Empty pages: 7, full pages: 122017 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 901 
    40 - 59% = 8541 
    60 - 79% = 167542 
    80 - 99% = 765 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18515, nodes: 12033736 
    Average node length: 6.62, total dup: 10490158, max dup: 57 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2459241, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2384 
        40 - 59% = 10770 
        60 - 79% = 4665 
        80 - 99% = 673 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 59.66, total records: 1226723 
    Average version length: 69.04, total versions: 173622, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.11 
    Pointer pages: 30, data page slots: 47040 
    Data pages: 28560, average fill: 48% 
    Primary pages: 28477, secondary pages: 83, swept pages: 15319 
    Empty pages: 4944, full pages: 11545 
    Fill distribution: 
     0 - 19% = 7771 
    20 - 39% = 3426 
    40 - 59% = 3266 
    60 - 79% = 11944 
    80 - 99% = 2153 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1852, nodes: 1206532 
    Average node length: 5.54, total dup: 1157805, max dup: 49 
    Average key length: 2.58, compression ratio: 16.31 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 83861, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 714 
        40 - 59% = 849 
        60 - 79% = 240 
        80 - 99% = 33 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 50.94, total records: 872236 
    Average version length: 69.05, total versions: 100461, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.47 
    Pointer pages: 23, data page slots: 37296 
    Data pages: 29632, average fill: 30% 
    Primary pages: 29632, secondary pages: 0, swept pages: 12340 
    Empty pages: 6828, full pages: 2442 
    Fill distribution: 
     0 - 19% = 11518 
    20 - 39% = 6574 
    40 - 59% = 7897 
    60 - 79% = 3598 
    80 - 99% = 45 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1201, nodes: 710050 
    Average node length: 5.93, total dup: 654864, max dup: 83 
    Average key length: 3.00, compression ratio: 13.99 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 102406, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 525 
        40 - 59% = 517 
        60 - 79% = 152 
        80 - 99% = 7 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 68.26, total records: 8739802 
    Average version length: 69.00, total versions: 90511, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 91, data page slots: 147096 
    Data pages: 147056, average fill: 63% 
    Primary pages: 147034, secondary pages: 22, swept pages: 97207 
    Empty pages: 529, full pages: 50437 
    Fill distribution: 
     0 - 19% = 2015 
    20 - 39% = 11459 
    40 - 59% = 28994 
    60 - 79% = 104213 
    80 - 99% = 375 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13425, nodes: 8737750 
    Average node length: 6.70, total dup: 7247723, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1986959, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1771 
        40 - 59% = 7262 
        60 - 79% = 3948 
        80 - 99% = 441 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21142875 
    Average version length: 83.03, total versions: 3290, 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: 319856 
    Data pages: 319856, average fill: 81% 
    Primary pages: 319850, secondary pages: 6, swept pages: 14868 
    Empty pages: 60, full pages: 318622 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 41 
    40 - 59% = 140 
    60 - 79% = 50120 
    80 - 99% = 269464 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19425, nodes: 21142875 
    Average node length: 5.72, total dup: 20662062, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3284628, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8225 
        60 - 79% = 547 
        80 - 99% = 10647 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17182, nodes: 21142875 
    Average node length: 6.31, total dup: 18580879, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918241, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 6 
        40 - 59% = 791 
        60 - 79% = 294 
        80 - 99% = 16089 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21222, nodes: 21142875 
    Average node length: 6.35, total dup: 18498847, max dup: 25 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577909, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8515 
        60 - 79% = 627 
        80 - 99% = 12073 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16090, nodes: 21142875 
    Average node length: 5.56, total dup: 21142775, max dup: 230595 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946962, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2885 
        60 - 79% = 353 
        80 - 99% = 12840 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.55, total records: 9207832 
    Average version length: 82.64, total versions: 107975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 108, data page slots: 175408 
    Data pages: 175304, average fill: 65% 
    Primary pages: 175259, secondary pages: 45, swept pages: 117374 
    Empty pages: 1160, full pages: 78251 
    Fill distribution: 
     0 - 19% = 3544 
    20 - 39% = 14555 
    40 - 59% = 33950 
    60 - 79% = 109808 
    80 - 99% = 13447 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11350, nodes: 9207832 
    Average node length: 5.39, total dup: 8902953, max dup: 176 
    Average key length: 2.24, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2086267, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 192 
        40 - 59% = 9299 
        60 - 79% = 1826 
        80 - 99% = 31 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13273, nodes: 9207832 
    Average node length: 6.25, total dup: 7633661, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1458283, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 4201 
        40 - 59% = 4271 
        60 - 79% = 2736 
        80 - 99% = 1949 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12683, nodes: 9207832 
    Average node length: 6.00, total dup: 7977280, max dup: 35 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2258690, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 259 
        40 - 59% = 10274 
        60 - 79% = 2116 
        80 - 99% = 30 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9824, nodes: 9207832 
    Average node length: 5.15, total dup: 9207732, max dup: 150051 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1504080, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 54 
        20 - 39% = 1430 
        40 - 59% = 4742 
        60 - 79% = 1721 
        80 - 99% = 1877 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 82.00, total records: 10898245 
    Average version length: 82.59, total versions: 43379, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 119, data page slots: 194152 
    Data pages: 192224, average fill: 69% 
    Primary pages: 192059, secondary pages: 165, swept pages: 85805 
    Empty pages: 4028, full pages: 134308 
    Fill distribution: 
     0 - 19% = 6889 
    20 - 39% = 9846 
    40 - 59% = 21937 
    60 - 79% = 100079 
    80 - 99% = 53473 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13110, nodes: 10898245 
    Average node length: 5.30, total dup: 10789038, max dup: 627 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2282257, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 283 
        40 - 59% = 9904 
        60 - 79% = 2841 
        80 - 99% = 82 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10246, nodes: 10898245 
    Average node length: 5.49, total dup: 10421820, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 701125, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 154 
        20 - 39% = 970 
        40 - 59% = 2569 
        60 - 79% = 1834 
        80 - 99% = 4719 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14997, nodes: 10898245 
    Average node length: 6.03, total dup: 9497477, max dup: 61 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.31, average data length: 0.69 
    Clustering factor: 2298482, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 327 
        40 - 59% = 11484 
        60 - 79% = 3096 
        80 - 99% = 87 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10522, nodes: 10898245 
    Average node length: 5.22, total dup: 10898145, max dup: 185965 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 689628, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 886 
        40 - 59% = 4713 
        60 - 79% = 1547 
        80 - 99% = 3268 
 
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: 82.09, total records: 9293592 
    Average version length: 82.88, total versions: 81225, 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: 109, data page slots: 177672 
    Data pages: 177616, average fill: 65% 
    Primary pages: 177577, secondary pages: 39, swept pages: 124118 
    Empty pages: 1083, full pages: 76650 
    Fill distribution: 
     0 - 19% = 3426 
    20 - 39% = 14659 
    40 - 59% = 34965 
    60 - 79% = 111632 
    80 - 99% = 12934 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11448, nodes: 9293592 
    Average node length: 5.18, total dup: 9265364, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1911941, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1713 
        40 - 59% = 7499 
        60 - 79% = 1639 
        80 - 99% = 566 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13403, nodes: 9293592 
    Average node length: 6.26, total dup: 7703846, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1449385, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 196 
        20 - 39% = 4184 
        40 - 59% = 4233 
        60 - 79% = 2722 
        80 - 99% = 2068 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12088, nodes: 9293592 
    Average node length: 5.44, total dup: 8871561, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 2037059, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1601 
        40 - 59% = 8440 
        60 - 79% = 1532 
        80 - 99% = 486 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9983, nodes: 9293592 
    Average node length: 5.15, total dup: 9293492, max dup: 152584 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1543364, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 56 
        20 - 39% = 1382 
        40 - 59% = 5058 
        60 - 79% = 1651 
        80 - 99% = 1836 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.99, total records: 566779 
    Average version length: 68.83, total versions: 1651, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8048 
    Data pages: 8048, average fill: 74% 
    Primary pages: 8048, secondary pages: 0, swept pages: 4578 
    Empty pages: 3, full pages: 6249 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 20 
    40 - 59% = 230 
    60 - 79% = 7789 
    80 - 99% = 4 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41364, depth: 3, leaf buckets: 739, nodes: 566779 
    Average node length: 5.95, total dup: 482538, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99896, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 532 
        60 - 79% = 97 
        80 - 99% = 78 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36501, depth: 3, leaf buckets: 760, nodes: 566779 
    Average node length: 6.15, total dup: 464804, max dup: 14 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99943, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 537 
        60 - 79% = 92 
        80 - 99% = 90 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 575, nodes: 566779 
    Average node length: 4.86, total dup: 566679, max dup: 9411 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88897, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 45 
        40 - 59% = 340 
        60 - 79% = 70 
        80 - 99% = 120 
 
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 13:11:06 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7660087 14753 1 0.0000 0.0000
DOC_LIST 2194659 7334 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_TURNOVER_LOG 49191 41837 1 0.0000 0.0000
MONEY_TURNOVER_LOG 1005 933 1 0.0000 0.0000
PDISTR 813386 15034 2 0.0000 0.0000
PERF_SPLIT_0 157430 524 1 0.0000 0.0000
PERF_SPLIT_1 136157 1313 1 0.0000 0.0000
PERF_SPLIT_2 150879 3584 1 0.0000 0.0000
PERF_SPLIT_3 161158 182 1 0.0000 0.0000
PERF_SPLIT_4 176543 1658 1 0.0000 0.0000
PERF_SPLIT_5 159349 333 1 0.0000 0.0000
PERF_SPLIT_6 171729 5692 1 0.0000 0.0000
PERF_SPLIT_7 164357 855 1 0.0000 0.0000
PERF_SPLIT_8 149289 3629 1 0.0000 0.0000
PERF_SPLIT_9 176821 1058 1 0.0000 0.0000
PSTORNED 2052213 10578 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 118720 37902 1 0.0000 0.0000
XQD_1000_3300 7025720 203902 1 0.0000 0.0000
XQD_1200_2000 12034184 168775 1 0.0000 0.0000
XQD_2000_3300 1226723 173622 1 0.0000 0.0000
XQD_2100_3300 872236 100461 1 0.0000 0.0000
XQD_3300_3400 8739802 90511 1 0.0000 0.0000
XQS_1000_1200 21142875 3290 1 0.0000 0.0000
XQS_1000_3300 9207832 107975 1 0.0000 0.0000
XQS_1200_2000 10898245 43379 1 0.0000 0.0000
XQS_2100_3300 9293592 81225 1 0.0000 0.0000
XQS_3300_3400 566779 1651 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 13:11:18. 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 13:11:20 No severe PSQL-related problems occured
21.03.24 13:11:21. End of report.