Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.04.2024 13:08
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 15335616 kB
MemAvailable 30090088 kB
Buffers 0 kB
Cached 16374340 kB
SwapCached 2508 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-04-09 13:07:50
DTS_END                         2024-04-09 13:07:50.0980
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/36394
TRN_ID                          174660
ATT_ID                          571
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: 9579.68 20393 957968
customer order: creation 184.89 426 18489
customer order: refuse 15.75 427 1575
order to supplier: creation 48.86 1335 4886
order to supplier: removal 3.53 110383 353
invoice (draft): creation 49.51 3667 4951
invoice (draft): removal 51.10 735 5110
invoice accept: apply 43.82 21331 4382
invoice accept: cancel 45.92 851 4592
customer reserve: creation 4318.68 199 431868
customer reserve: removal 4507.98 71 450798
realization accept: apply 89.63 216 8963
realization accept: cancel 81.71 143 8171
payment from customer: creation 64.38 139 6438
payment from customer: removal 6.25 86 625
payment to supplier: creation 52.81 160 5281
payment to supplier: removal 3.79 90 379
service: total inventory turnovers 3.83 4273 383
service: total monetary turnovers 6.37 637 637
service: aggregate perf. data 0.83 18364 83
service: refresh index statistics 0.04 244322 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-04-2024 13:08:48 to 09-04-2024 13:08:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6201
TEST_TIME 2 3849
TEST_TIME 3 3692
TEST_TIME 4 4474
TEST_TIME 5 4708
TEST_TIME 6 4935
TEST_TIME 7 5126
TEST_TIME 8 5391
TEST_TIME 9 5253
TEST_TIME 10 5387
TEST_TIME 11 5796
TEST_TIME 12 6162
TEST_TIME 13 6499
TEST_TIME 14 6458
TEST_TIME 15 6574
TEST_TIME 16 6566
TEST_TIME 17 6955
TEST_TIME 18 7169
TEST_TIME 19 7232
TEST_TIME 20 7206
TEST_TIME 21 7306
TEST_TIME 22 7380
TEST_TIME 23 7442
TEST_TIME 24 7912
TEST_TIME 25 8228
TEST_TIME 26 8805
TEST_TIME 27 9498
TEST_TIME 28 9899
TEST_TIME 29 10471
TEST_TIME 30 10494
TEST_TIME 31 10216
TEST_TIME 32 10149
TEST_TIME 33 10191
TEST_TIME 34 10044
TEST_TIME 35 9989
TEST_TIME 36 9949
TEST_TIME 37 9850
TEST_TIME 38 9855
TEST_TIME 39 9764
TEST_TIME 40 9697
TEST_TIME 41 9795
TEST_TIME 42 9918
TEST_TIME 43 9925
TEST_TIME 44 9944
TEST_TIME 45 9860
TEST_TIME 46 9717
TEST_TIME 47 9716
TEST_TIME 48 9707
TEST_TIME 49 9651
TEST_TIME 50 9748
TEST_TIME 51 9706
TEST_TIME 52 9682
TEST_TIME 53 9708
TEST_TIME 54 9853
TEST_TIME 55 9949
TEST_TIME 56 9984
TEST_TIME 57 9996
TEST_TIME 58 10051
TEST_TIME 59 9963
TEST_TIME 60 10043
TEST_TIME 61 10164
TEST_TIME 62 10099
TEST_TIME 63 9953
TEST_TIME 64 9843
TEST_TIME 65 9793
TEST_TIME 66 9818
TEST_TIME 67 9793
TEST_TIME 68 9723
TEST_TIME 69 9676
TEST_TIME 70 9592
TEST_TIME 71 9620
TEST_TIME 72 9618
TEST_TIME 73 9566
TEST_TIME 74 9631
TEST_TIME 75 9624
TEST_TIME 76 9605
TEST_TIME 77 9717
TEST_TIME 78 9684
TEST_TIME 79 9829
TEST_TIME 80 9839
TEST_TIME 81 9881
TEST_TIME 82 9896
TEST_TIME 83 9880
TEST_TIME 84 9945
TEST_TIME 85 9835
TEST_TIME 86 9784
TEST_TIME 87 9754
TEST_TIME 88 9742
TEST_TIME 89 9695
TEST_TIME 90 9649
TEST_TIME 91 9567
TEST_TIME 92 9557
TEST_TIME 93 9592
TEST_TIME 94 9557
TEST_TIME 95 9566
TEST_TIME 96 9604
TEST_TIME 97 9591
TEST_TIME 98 9619
TEST_TIME 99 9629
TEST_TIME 100 9590

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-04-2024 13:08:52 to 09-04-2024 13:08:55.

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 1352681 1352681 0 0.00 0 20368 8 0 0
doc_list_biud 1352680 1352680 0 0.00 0 44511 29 0 0
sp_add_invoice_to_stock 4517 4382 135 2.98 45 184073 21332 0 135
sp_cancel_adding_invoice 4592 4592 0 0.00 4 67762 852 0 0
sp_cancel_client_order 1575 1575 0 0.00 4 18257 428 0 0
sp_cancel_customer_reserve 450798 450798 0 0.00 0 42537 71 0 0
sp_cancel_pay_from_customer 625 625 0 0.00 3 6713 87 0 0
sp_cancel_pay_to_supplier 379 379 0 0.00 2 3746 91 0 0
sp_cancel_supplier_invoice 5118 5110 8 0.15 1 25278 735 0 8
sp_cancel_supplier_order 353 353 0 0.00 12 1167865 110384 0 0
sp_cancel_write_off 8171 8171 0 0.00 1 10518 144 0 0
sp_client_order 18489 18489 0 0.00 3 31392 426 0 0
sp_customer_reserve 431868 431868 0 0.00 0 46035 200 0 0
sp_fill_shopping_cart 28309 28309 0 0.00 1 22698 41 0 0
sp_fill_shopping_cart_clo_res 431856 431856 0 0.00 0 22218 18 0 0
sp_get_clo_for_invoice 4369 4369 0 0.00 0 30917 354 0 0
sp_kill_cost_storno 13767 13767 0 0.00 0 7403 68 0 0
sp_kill_qstorno_ret_qs2qd 915230 915230 0 0.00 0 44509 37 0 0
sp_kill_qty_storno 483931 483931 0 0.00 0 44511 80 0 0
sp_lock_selected_doc 18563 18563 0 0.00 0 8135 5 0 0
sp_make_cost_storno 25051 25051 0 0.00 0 14195 83 0 0
sp_multiply_rows_for_pdistr 25051 25051 0 0.00 0 12389 37 0 0
sp_multiply_rows_for_qdistr 18489 18489 0 0.00 0 19629 205 0 0
sp_pay_from_customer 6438 6438 0 0.00 3 19988 140 0 0
sp_pay_to_supplier 5281 5281 0 0.00 4 15532 161 0 0
sp_payment_common 11719 11719 0 0.00 1 12162 27 0 0
sp_qd_handle_on_cancel_clo 1575 1575 0 0.00 0 18251 387 0 0
sp_qd_handle_on_invoice_upd_sts 8961 8961 0 0.00 0 32542 311 0 0
sp_qd_handle_on_reserve_upd_sts 8963 8963 0 0.00 0 27232 57 0 0
sp_reserve_write_off 8963 8963 0 0.00 5 27417 217 0 0
sp_supplier_invoice 4951 4951 0 0.00 7 98928 3667 0 0
sp_supplier_order 4886 4886 0 0.00 4 32240 1335 0 0
srv_aggregate_perf_data 83 83 0 0.00 2250 203662 18364 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1276 110547 36984 0 0
srv_find_qd_qs_mism 911958 911958 0 0.00 0 20366 7 0 0
srv_make_invnt_saldo 383 383 0 0.00 34 94294 4273 0 0
srv_make_money_saldo 637 637 0 0.00 1 10869 638 0 0
srv_recalc_idx_stat 4 4 0 0.00 153324 367992 244323 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4382 4382 0 0.00 0 8358 199 0 0
t$perf-norm:sp_cancel_adding_invoice 371 371 0 0.00 0 4246 90 0 0
t$perf-norm:sp_cancel_client_order 1575 1575 0 0.00 0 1938 16 0 0
t$perf-norm:sp_cancel_customer_reserve 618 618 0 0.00 0 1435 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 625 625 0 0.00 0 605 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 379 379 0 0.00 0 1319 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 375 375 0 0.00 0 4234 23 0 0
t$perf-norm:sp_cancel_supplier_order 353 353 0 0.00 0 21628 1697 0 0
t$perf-norm:sp_cancel_write_off 937 937 0 0.00 0 1248 5 0 0
t$perf-norm:sp_client_order 18489 18489 0 0.00 0 16753 19 0 0
t$perf-norm:sp_customer_reserve 873 873 0 0.00 0 9699 19 0 0
t$perf-norm:sp_pay_from_customer 6438 6438 0 0.00 0 14368 10 0 0
t$perf-norm:sp_pay_to_supplier 5281 5281 0 0.00 0 4943 9 0 0
t$perf-norm:sp_reserve_write_off 8963 8963 0 0.00 0 16758 12 0 0
t$perf-norm:sp_supplier_invoice 4951 4951 0 0.00 0 5551 17 0 0
t$perf-norm:sp_supplier_order 4886 4886 0 0.00 0 6352 20 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 1062 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 53 2 0 0
t$perf-norm:srv_make_invnt_saldo 383 383 0 0.00 0 816 11 0 0
t$perf-norm:srv_make_money_saldo 637 637 0 0.00 0 578 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 17 9 0 0
v_add_invoice_to_stock 9003 8734 269 2.98 0 5653 17 0 269
v_all_customers 34300 34300 0 0.00 0 88 1 0 0
v_all_suppliers 28154 28154 0 0.00 0 97 1 0 0
v_all_wares 36972 36972 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 742 742 0 0.00 0 652 9 0 0
v_cancel_client_order 3150 3150 0 0.00 0 5691 8 0 0
v_cancel_customer_prepayment 1250 1250 0 0.00 0 1469 6 0 0
v_cancel_customer_reserve 1236 1236 0 0.00 0 1906 6 0 0
v_cancel_payment_to_supplier 758 758 0 0.00 0 2000 9 0 0
v_cancel_supplier_invoice 766 750 16 2.08 0 546 14 0 16
v_cancel_supplier_order 706 706 0 0.00 0 722 5 0 0
v_cancel_write_off 1874 1874 0 0.00 0 2706 14 0 0
v_max_id_clo_ord 4882 4882 0 0.00 0 1527 2 0 0
v_max_id_clo_res 873 873 0 0.00 0 3422 16 0 0
v_max_id_ord_sup 4941 4941 0 0.00 0 4640 8 0 0
v_max_non_paid_invoice 1027 1027 0 0.00 0 31 2 0 0
v_max_non_paid_realizn 3183 3183 0 0.00 0 1343 4 0 0
v_min_id_clo_ord 4882 4882 0 0.00 0 11787 12 0 0
v_min_id_clo_res 873 873 0 0.00 0 8027 45 0 0
v_min_id_ord_sup 4941 4941 0 0.00 0 7157 6 0 0
v_min_non_paid_invoice 5281 5281 0 0.00 0 6688 17 0 0
v_min_non_paid_realizn 6438 6438 0 0.00 0 8028 22 0 0
v_our_firm 9182 9182 0 0.00 0 20 1 0 0
v_reserve_write_off 17926 17926 0 0.00 0 2674 6 0 0
x_lock_depdocs_on_canc_invoice 9327 9327 0 0.00 0 12492 127 0 0
x_lock_depdocs_on_canc_sup_ord 353 353 0 0.00 0 9255 336 0 0
x_make_qstorno_1000_1200 4886 4886 0 0.00 1 32229 1243 0 0
x_make_qstorno_1200_2000 4951 4951 0 0.00 4 98544 3522 0 0
x_make_qstorno_2100_3300 431868 431868 0 0.00 0 46034 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-04-2024 13:08:56 to 09-04-2024 13:09:00.

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:54 14 8192000000 8820376112 8840216576 21202768 0.258 7 6 7 0 21574624 208112 163744
11:08:55 35974 8192000000 9720732896 10021191680 796990784 8.866 100 92 182 1 826166416 7799728 21375904
11:10:41 21309 8192000000 9754623008 10063495168 827389264 9.173 100 91 182 0 862407376 13761456 21256656
11:12:06 15696 8192000000 9785922160 10104373248 852787808 9.428 100 84 168 0 892016352 20202688 19025856
11:13:28 13093 8192000000 9831570672 10166575104 884222944 9.742 100 63 126 1 945809056 48356304 13229808
11:14:55 6893 8192000000 9881662624 10224500736 928529872 10.180 100 75 150 0 993581008 49551024 15500112
11:16:05 4189 8192000000 9920011648 10272485376 972409040 10.610 100 76 149 1 1033907072 46594624 14903408
11:17:12 1509 8192000000 10003557584 10361176064 1003470736 10.912 100 85 170 0 1113362048 93901856 15989456
11:18:15 2780 8192000000 10001127776 10367311872 1023295616 11.104 100 84 167 0 1112672240 74234896 15141728
11:19:21 2110 8192000000 10010581776 10383773696 1050579296 11.366 100 86 169 0 1118120384 50606144 16934944
11:20:24 27654 8192000000 10006998224 10393915392 1061400112 11.470 100 61 122 0 1133979392 60272912 12306368
11:21:53 2875 8192000000 9997540560 10392674304 1067053552 11.524 100 58 113 0 1107525472 28908448 11563472
11:22:58 4419 8192000000 9997178720 10402713600 1075125104 11.601 100 28 54 1 1110486112 29581552 5779456
11:24:06 9436 8192000000 9987639840 10404790272 1082916720 11.675 100 24 48 1 1108705312 20716080 5072512
11:25:16 24850 8192000000 10004689584 10403254272 1091648480 11.758 100 45 89 0 1109136512 8527952 8960080
11:26:43 5694 8192000000 10013787296 10414309376 1091267440 11.755 100 31 58 0 1130554512 32570000 6717072
11:27:50 5877 8192000000 9997465824 10399948800 1063859184 11.493 98 37 73 0 1093089216 21698560 7531472
11:29:04 110547 8192000000 10073448576 10498187264 1106208544 11.897 100 38 76 0 1170797872 56779968 7809360
11:31:58 25920 8192000000 10063066432 10478809088 1097079680 11.810 98 33 66 0 1163053616 59023568 6950368
11:33:30 25756 8192000000 10082664336 10504187904 1081321616 11.660 97 35 70 0 1166955760 78591424 7042720
11:35:01 19742 8192000000 10104153824 10513563648 1108127264 11.915 99 42 84 0 1209400320 92122992 9150064
11:36:33 32049 8192000000 10139150048 10555682816 1114298960 11.973 100 42 83 0 1235309088 111751120 9259008
11:38:18 6814 8192000000 10177983888 10575626240 1112046080 11.952 100 62 118 1 1283811360 158838368 12926912
11:39:30 3442 8192000000 10139983712 10532421632 1065608528 11.510 97 57 113 1 1226399264 149077936 11712800
11:40:38 8763 8192000000 10149579152 10549956608 1072633520 11.577 100 48 94 0 1260616464 177484592 10498352
11:41:53 7247 8192000000 10215359120 10603642880 1092477120 11.766 100 71 137 0 1315077568 208755952 13844496
11:43:05 2779 8192000000 10236632112 10626924544 1107612608 11.910 100 86 168 1 1339531264 213375568 18543088
11:44:15 3540 8192000000 10283145584 10696007680 1112055136 11.952 100 71 142 0 1381544944 254574064 14915744
11:45:27 1274 8192000000 10290476416 10694131712 1128553328 12.108 99 86 167 1 1388105504 241741632 17810544
11:46:35 1741 8192000000 10348088816 10744242176 1148187776 12.292 100 82 163 0 1439798096 273823632 17786688
11:47:43 1686 8192000000 10428107136 10822156288 1158755504 12.392 100 89 174 2 1525163840 347263376 19144960
11:48:48 3774 8192000000 10469628432 10876788736 1165199136 12.452 100 72 144 0 1568911200 387433616 16278448
11:50:01 13652 8192000000 10476108624 10883002368 1147228112 12.283 99 54 107 0 1578857056 418068624 13560320
11:51:20 5150 8192000000 10519630880 10939985920 1151691808 12.325 100 48 92 1 1624359552 460848224 11819520
11:52:35 10335 8192000000 10457969792 10902708224 1150861680 12.318 100 31 62 1 1560817376 401968896 7986800
11:54:14 15310 8192000000 10326859680 10833350656 1136190272 12.180 100 25 50 0 1472397856 329829312 6378272
11:55:40 23593 8192000000 10160994704 10709401600 1126472864 12.088 100 18 36 0 1314541424 183868288 4200272
11:57:07 84751 8192000000 10053108656 10489413632 1124488192 12.069 100 19 38 1 1158991216 31016464 3486560
11:59:38 46990 8192000000 10072780624 10527080448 1135348896 12.172 100 20 40 1 1193917568 54720144 3848528
12:01:27 62073 8192000000 10069049408 10528047104 1138824816 12.204 100 40 79 0 1176669968 29175088 8670064
12:03:33 75832 8192000000 10093580048 10545274880 1129217328 12.114 98 26 51 1 1212141568 77456384 5467856
12:05:55 12505 8192000000 10105662368 10547220480 1149759984 12.307 100 27 54 0 1213551904 58030032 5761888
12:07:09 13587 8192000000 10156087632 10590453760 1170148192 12.498 100 38 74 0 1259823200 81345712 8329296
12:08:24 41533 8192000000 10195617328 10681622528 1157326448 12.378 99 25 50 0 1312968432 150280112 5361872
12:11:17 7178 8192000000 10099346944 10574606336 1153196368 12.339 100 13 24 0 1206141280 50952432 1992480
12:12:26 54095 8192000000 10083658576 10525970432 1127484144 12.098 98 14 28 0 1179674912 49213088 2977680
12:15:34 35483 8192000000 10060896384 10524766208 1104555680 11.881 97 21 40 0 1139968832 31423136 3990016
12:17:10 45887 8192000000 10066096272 10537463808 1087798960 11.722 97 28 56 0 1164314640 70919824 5595856
12:19:17 49414 8192000000 10104046512 10591526912 1099787536 11.836 98 26 52 0 1210622992 105696208 5139248
12:21:12 32081 8192000000 10086625680 10563383296 1096550688 11.805 99 39 77 0 1190990128 86565440 7874000
12:22:57 68963 8192000000 10057677568 10525577216 1088534944 11.729 98 15 30 0 1139739920 48203568 3001408
12:25:07 44935 8192000000 10049475360 10491977728 1087571968 11.720 98 22 44 0 1139030928 47205856 4253104
12:26:55 24844 8192000000 10072637024 10531069952 1098861728 11.827 99 36 72 0 1181696528 76025712 6809088
12:28:26 96925 8192000000 10021649104 10495549440 1085128256 11.696 98 14 28 0 1137296208 49490816 2677136
12:31:03 64654 8192000000 10036651728 10499760128 1097883600 11.818 100 20 40 1 1158196592 56301648 4011344
12:33:10 24293 8192000000 10041118240 10472140800 1094710592 11.787 99 32 62 1 1125096224 24225200 6160432
12:34:36 43413 8192000000 10034050560 10501021696 1102536240 11.862 100 6 12 0 1148053184 44554224 962720
12:36:50 61922 8192000000 10057992992 10509090816 1103193136 11.868 100 17 34 0 1172440160 65785648 3461376
12:38:55 49168 8192000000 10026721328 10474835968 1056665904 11.425 96 27 54 0 1102458320 40358432 5433984
12:40:45 48520 8192000000 10098792624 10562785280 1103316336 11.869 100 37 74 0 1189148160 78273776 7558048
12:43:16 36818 8192000000 10121952736 10558513152 1121646192 12.043 99 33 66 0 1192818016 64880784 6291040
12:44:54 83348 8192000000 10127562512 10618568704 1116668128 11.996 99 24 48 0 1188179344 67182992 4328224
12:47:23 61371 8192000000 10100350752 10594779136 1125917088 12.083 99 31 63 0 1193875424 62178864 5779472
12:49:32 39071 8192000000 10074842992 10531966976 1103338752 11.869 97 26 52 0 1147564288 39304224 4921312
12:51:12 94090 8192000000 10054886720 10496802816 1136207392 12.180 100 22 45 1 1211911920 70719264 4985264
12:53:54 27889 8192000000 10101605792 10551771136 1137674736 12.194 100 36 71 0 1203211280 59184352 6352192
12:55:23 37721 8192000000 10043675968 10511736832 1123654976 12.062 99 9 18 0 1145796096 20365584 1775536
12:57:01 63164 8192000000 10057599216 10497662976 1116369040 11.993 99 16 31 0 1158108368 38631520 3107808
12:59:05 84377 8192000000 10081355344 10566311936 1114697328 11.977 98 12 24 1 1203740432 86512672 2530432
13:01:49 37739 8192000000 10063898192 10507976704 1073043904 11.581 95 28 56 1 1133185712 54460640 5681168
13:03:27 54005 8192000000 10064842640 10515513344 1082591136 11.672 96 32 64 2 1132535008 42898464 7045408
13:05:24 34999 8192000000 10046239488 10495037440 1093279280 11.774 99 27 54 0 1150889024 52251856 5357888
13:07:00 35376 8192000000 10070352368 10509541376 1064071664 11.495 96 39 78 0 1122757104 51476528 7208912

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 09-04-2024 13:09:02 to 09-04-2024 13:09:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 135 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-04-2024 13:09:17 to 09-04-2024 13:09:19.

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          172725
MON$OLDEST_ACTIVE               177388
MON$OLDEST_SNAPSHOT             177388
MON$NEXT_TRANSACTION            177388
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                       1934944
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             709
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3083 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3083 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3083 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 Tue Apr  9 13:09:20 2024 
 
Database header page information: 
    Flags            0 
    Generation        92875 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    172725 
    Oldest active        177388 
    Oldest snapshot        177388 
    Next transaction    177389 
    Sequence number        0 
    Next attachment ID    709 
    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.42, total records: 7779636 
    Average version length: 48.16, total versions: 95733, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88744 
    Data pages: 88744, average fill: 70% 
    Primary pages: 88743, secondary pages: 1, swept pages: 31055 
    Empty pages: 6, full pages: 82505 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 81 
    40 - 59% = 902 
    60 - 79% = 87705 
    80 - 99% = 42 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23527, nodes: 7779636 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1717620, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 364 
        20 - 39% = 1820 
        40 - 59% = 4391 
        60 - 79% = 2458 
        80 - 99% = 14494 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13627, nodes: 7779636 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1540389, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1549 
        40 - 59% = 2182 
        60 - 79% = 1142 
        80 - 99% = 8754 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8466, nodes: 7779636 
    Average node length: 6.62, total dup: 5817669, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1533425, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 164 
        20 - 39% = 966 
        40 - 59% = 1491 
        60 - 79% = 955 
        80 - 99% = 4890 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.42, total records: 2253500 
    Average version length: 58.91, total versions: 48290, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28576 
    Data pages: 28576, average fill: 73% 
    Primary pages: 28574, secondary pages: 2, swept pages: 7861 
    Empty pages: 4, full pages: 24751 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 11 
    40 - 59% = 505 
    60 - 79% = 27994 
    80 - 99% = 59 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4616, nodes: 2253500 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 695774, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 956 
        40 - 59% = 876 
        60 - 79% = 765 
        80 - 99% = 2019 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2422, nodes: 2255336 
    Average node length: 4.97, total dup: 2254437, max dup: 16981 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1280472, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 195 
        40 - 59% = 1393 
        60 - 79% = 569 
        80 - 99% = 262 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1759, nodes: 2253500 
    Average node length: 4.97, total dup: 2253450, max dup: 130388 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1066055, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 594 
        60 - 79% = 43 
        80 - 99% = 1116 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4419, nodes: 2253500 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 695774, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 609 
        40 - 59% = 666 
        60 - 79% = 858 
        80 - 99% = 2166 
 
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.20, total records: 400 
    Average version length: 23.53, total versions: 6181, max versions: 17 
    Average fragment length: 2.00, total fragments: 11, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 50% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 0, full pages: 35 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 30 
 
    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: 9.94, total records: 105234 
    Average version length: 68.28, total versions: 103562, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.85 
    Pointer pages: 8, data page slots: 3560 
    Data pages: 2376, average fill: 61% 
    Primary pages: 2375, secondary pages: 1, swept pages: 0 
    Empty pages: 472, full pages: 1260 
    Fill distribution: 
     0 - 19% = 592 
    20 - 39% = 129 
    40 - 59% = 189 
    60 - 79% = 288 
    80 - 99% = 1178 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703625, depth: 3, leaf buckets: 381, nodes: 105234 
    Average node length: 13.50, total dup: 6769, max dup: 2 
    Average key length: 10.74, compression ratio: 2.51 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 79898, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 88 
        40 - 59% = 266 
        60 - 79% = 23 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 384, max versions: 13 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 16 
    Data pages: 16, average fill: 9% 
    Primary pages: 4, secondary pages: 12, swept pages: 0 
    Empty pages: 7, full pages: 1 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    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.20, total records: 2276 
    Average version length: 43.44, total versions: 2131, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.18 
    Pointer pages: 1, data page slots: 40 
    Data pages: 36, average fill: 67% 
    Primary pages: 35, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 23 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 21 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92179, depth: 2, leaf buckets: 2, nodes: 2276 
    Average node length: 4.30, total dup: 2178, max dup: 228 
    Average key length: 2.46, compression ratio: 7.74 
    Average prefix length: 18.59, average data length: 0.41 
    Clustering factor: 1238, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        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.59, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.68, total records: 830984 
    Average version length: 37.90, total versions: 40952, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8496 
    Data pages: 8496, average fill: 67% 
    Primary pages: 8494, secondary pages: 2, swept pages: 1019 
    Empty pages: 19, full pages: 8242 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 27 
    40 - 59% = 36 
    60 - 79% = 8309 
    80 - 99% = 97 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 851, nodes: 808348 
    Average node length: 4.88, total dup: 808299, max dup: 150404 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90382, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 123 
        40 - 59% = 440 
        60 - 79% = 171 
        80 - 99% = 116 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 968, nodes: 808348 
    Average node length: 5.89, total dup: 719420, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159611, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 71 
        40 - 59% = 538 
        60 - 79% = 80 
        80 - 99% = 277 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 989, nodes: 808348 
    Average node length: 5.89, total dup: 719420, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161638, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 109 
        40 - 59% = 534 
        60 - 79% = 74 
        80 - 99% = 272 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1145, nodes: 808348 
    Average node length: 5.97, total dup: 719420, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153935, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 249 
        40 - 59% = 592 
        60 - 79% = 200 
        80 - 99% = 96 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 63.00, total records: 5540 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.85, total fragments: 27, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 79, secondary pages: 17, swept pages: 55 
    Empty pages: 14, full pages: 60 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5540 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.13 
    Average prefix length: 34.65, average data length: 1.54 
    Clustering factor: 5244, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 2 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5540 
    Average node length: 11.12, 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: 171, 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.03, total records: 80801 
    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: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 838 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 838 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37974, depth: 2, leaf buckets: 102, nodes: 80801 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3162, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 102 
 
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.07, 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.22 
    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: 148.37, total records: 186793 
    Average version length: 152.92, total versions: 4067, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 8, data page slots: 6048 
    Data pages: 4672, average fill: 83% 
    Primary pages: 4668, secondary pages: 4, swept pages: 3 
    Empty pages: 65, full pages: 4590 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 4590 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 149.75, total records: 157057 
    Average version length: 151.73, total versions: 1646, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 8, data page slots: 4320 
    Data pages: 3920, average fill: 83% 
    Primary pages: 3917, secondary pages: 3, swept pages: 5 
    Empty pages: 51, full pages: 3850 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 3851 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.59, total records: 160683 
    Average version length: 151.40, total versions: 1877, 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: 7, data page slots: 5688 
    Data pages: 4072, average fill: 81% 
    Primary pages: 4069, secondary pages: 3, swept pages: 9 
    Empty pages: 101, full pages: 3936 
    Fill distribution: 
     0 - 19% = 110 
    20 - 39% = 12 
    40 - 59% = 10 
    60 - 79% = 5 
    80 - 99% = 3935 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 150.86, total records: 150130 
    Average version length: 137.62, total versions: 206, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 8, data page slots: 4272 
    Data pages: 3720, average fill: 83% 
    Primary pages: 3719, secondary pages: 1, swept pages: 1 
    Empty pages: 30, full pages: 3681 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 3681 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 149.27, total records: 137533 
    Average version length: 150.77, total versions: 1678, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 8, data page slots: 4760 
    Data pages: 3464, average fill: 82% 
    Primary pages: 3462, secondary pages: 2, swept pages: 4 
    Empty pages: 76, full pages: 3368 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3369 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.19, total records: 146393 
    Average version length: 150.74, total versions: 830, 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: 5, data page slots: 4808 
    Data pages: 3624, average fill: 83% 
    Primary pages: 3621, secondary pages: 3, swept pages: 5 
    Empty pages: 25, full pages: 3581 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3583 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.81, total records: 149379 
    Average version length: 150.56, total versions: 1259, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 7, data page slots: 4384 
    Data pages: 3712, average fill: 83% 
    Primary pages: 3709, secondary pages: 3, swept pages: 2 
    Empty pages: 38, full pages: 3660 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3661 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 150.53, total records: 153944 
    Average version length: 151.90, total versions: 873, 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: 7, data page slots: 4928 
    Data pages: 3816, average fill: 83% 
    Primary pages: 3814, secondary pages: 2, swept pages: 4 
    Empty pages: 24, full pages: 3782 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 0 
    80 - 99% = 3783 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 147.91, total records: 152949 
    Average version length: 153.76, total versions: 3322, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 6, data page slots: 4768 
    Data pages: 3784, average fill: 83% 
    Primary pages: 3782, secondary pages: 2, swept pages: 5 
    Empty pages: 23, full pages: 3752 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3752 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 132.28, total records: 165313 
    Average version length: 154.92, total versions: 21712, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.82 
    Pointer pages: 9, data page slots: 6464 
    Data pages: 4160, average fill: 84% 
    Primary pages: 4157, secondary pages: 3, swept pages: 2 
    Empty pages: 84, full pages: 4053 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 4053 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.74, total records: 2115893 
    Average version length: 52.89, total versions: 48843, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25728 
    Data pages: 25728, average fill: 71% 
    Primary pages: 25716, secondary pages: 12, swept pages: 9613 
    Empty pages: 121, full pages: 23752 
    Fill distribution: 
     0 - 19% = 242 
    20 - 39% = 195 
    40 - 59% = 514 
    60 - 79% = 24276 
    80 - 99% = 501 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2598, nodes: 2115893 
    Average node length: 5.44, total dup: 1975171, max dup: 1425 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183921, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 308 
        40 - 59% = 1679 
        60 - 79% = 298 
        80 - 99% = 305 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2748, nodes: 2115893 
    Average node length: 5.69, total dup: 1899600, max dup: 68 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 379140, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2367 
        60 - 79% = 339 
        80 - 99% = 33 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2154, nodes: 2115893 
    Average node length: 4.96, total dup: 2115793, max dup: 26399 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181545, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 193 
        40 - 59% = 1158 
        60 - 79% = 368 
        80 - 99% = 434 
 
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: 37.42, total records: 171055 
    Average version length: 69.17, total versions: 90351, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.37 
    Pointer pages: 3, data page slots: 4496 
    Data pages: 3360, average fill: 63% 
    Primary pages: 3360, secondary pages: 0, swept pages: 448 
    Empty pages: 664, full pages: 2497 
    Fill distribution: 
     0 - 19% = 808 
    20 - 39% = 24 
    40 - 59% = 16 
    60 - 79% = 824 
    80 - 99% = 1688 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1553460, depth: 3, leaf buckets: 228, nodes: 171055 
    Average node length: 6.46, total dup: 149240, max dup: 14 
    Average key length: 3.88, compression ratio: 10.81 
    Average prefix length: 40.24, average data length: 1.76 
    Clustering factor: 29355, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 14 
        40 - 59% = 95 
        60 - 79% = 92 
        80 - 99% = 27 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.57, total records: 7176844 
    Average version length: 68.79, total versions: 524237, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 66, data page slots: 107456 
    Data pages: 107456, average fill: 72% 
    Primary pages: 107455, secondary pages: 1, swept pages: 11298 
    Empty pages: 7, full pages: 84477 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 1056 
    40 - 59% = 7758 
    60 - 79% = 96628 
    80 - 99% = 1945 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10759, nodes: 7176844 
    Average node length: 6.51, total dup: 6210412, max dup: 43 
    Average key length: 3.52, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1705323, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1651 
        40 - 59% = 5803 
        60 - 79% = 2663 
        80 - 99% = 638 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8616, nodes: 7176844 
    Average node length: 5.40, total dup: 6890954, max dup: 165 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1501045, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1314 
        40 - 59% = 4561 
        60 - 79% = 1662 
        80 - 99% = 1075 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8666, nodes: 7176844 
    Average node length: 5.40, total dup: 6890954, max dup: 165 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1503334, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1294 
        40 - 59% = 4611 
        60 - 79% = 1652 
        80 - 99% = 1108 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.72, total records: 12236263 
    Average version length: 68.73, total versions: 451235, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 108, data page slots: 176080 
    Data pages: 176080, average fill: 74% 
    Primary pages: 176079, secondary pages: 1, swept pages: 50134 
    Empty pages: 4, full pages: 165607 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 528 
    40 - 59% = 3310 
    60 - 79% = 168587 
    80 - 99% = 3604 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18462, nodes: 12233213 
    Average node length: 6.61, total dup: 10666063, max dup: 77 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2498815, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 2038 
        40 - 59% = 10659 
        60 - 79% = 4823 
        80 - 99% = 901 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 43.64, total records: 1783786 
    Average version length: 69.10, total versions: 484176, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.89 
    Pointer pages: 29, data page slots: 46256 
    Data pages: 28815, average fill: 64% 
    Primary pages: 28756, secondary pages: 59, swept pages: 2624 
    Empty pages: 1187, full pages: 23521 
    Fill distribution: 
     0 - 19% = 2675 
    20 - 39% = 3626 
    40 - 59% = 2033 
    60 - 79% = 13220 
    80 - 99% = 7261 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1853, nodes: 1511104 
    Average node length: 5.51, total dup: 1450364, max dup: 49 
    Average key length: 2.56, compression ratio: 16.43 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 105867, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 261 
        40 - 59% = 862 
        60 - 79% = 559 
        80 - 99% = 160 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 34.23, total records: 1281771 
    Average version length: 69.05, total versions: 161810, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.68 
    Pointer pages: 25, data page slots: 39488 
    Data pages: 29416, average fill: 34% 
    Primary pages: 29414, secondary pages: 2, swept pages: 6776 
    Empty pages: 7563, full pages: 12209 
    Fill distribution: 
     0 - 19% = 12169 
    20 - 39% = 3762 
    40 - 59% = 5294 
    60 - 79% = 7729 
    80 - 99% = 462 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1100, nodes: 700466 
    Average node length: 5.95, total dup: 644788, max dup: 91 
    Average key length: 3.02, compression ratio: 13.89 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 100766, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 367 
        40 - 59% = 514 
        60 - 79% = 203 
        80 - 99% = 16 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.72, total records: 9315822 
    Average version length: 68.98, total versions: 486742, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 90, data page slots: 146096 
    Data pages: 146096, average fill: 69% 
    Primary pages: 146077, secondary pages: 19, swept pages: 37497 
    Empty pages: 286, full pages: 94047 
    Fill distribution: 
     0 - 19% = 1128 
    20 - 39% = 6368 
    40 - 59% = 18987 
    60 - 79% = 116437 
    80 - 99% = 3176 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13489, nodes: 9307208 
    Average node length: 6.69, total dup: 7721596, max dup: 25 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2135016, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1283 
        40 - 59% = 6603 
        60 - 79% = 4790 
        80 - 99% = 810 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21171094 
    Average version length: 82.86, total versions: 16396, 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: 197, data page slots: 319976 
    Data pages: 319976, average fill: 81% 
    Primary pages: 319970, secondary pages: 6, swept pages: 11913 
    Empty pages: 6, full pages: 319963 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 49141 
    80 - 99% = 270822 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19565, nodes: 21171094 
    Average node length: 5.72, total dup: 20689703, max dup: 133 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3289233, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8476 
        60 - 79% = 549 
        80 - 99% = 10532 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17222, nodes: 21171094 
    Average node length: 6.31, total dup: 18605790, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 920175, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 831 
        60 - 79% = 299 
        80 - 99% = 16087 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21288, nodes: 21171094 
    Average node length: 6.35, total dup: 18524341, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3583104, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 8622 
        60 - 79% = 621 
        80 - 99% = 12042 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16118, nodes: 21171094 
    Average node length: 5.56, total dup: 21170994, max dup: 231404 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948753, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 7 
        40 - 59% = 2876 
        60 - 79% = 403 
        80 - 99% = 12830 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 78.60, total records: 9783054 
    Average version length: 82.61, total versions: 509027, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 107, data page slots: 174576 
    Data pages: 174536, average fill: 70% 
    Primary pages: 174495, secondary pages: 41, swept pages: 57399 
    Empty pages: 414, full pages: 114239 
    Fill distribution: 
     0 - 19% = 1614 
    20 - 39% = 9792 
    40 - 59% = 25565 
    60 - 79% = 113474 
    80 - 99% = 24091 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11327, nodes: 9783054 
    Average node length: 5.37, total dup: 9473944, max dup: 191 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2235784, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 66 
        40 - 59% = 7679 
        60 - 79% = 3502 
        80 - 99% = 79 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13828, nodes: 9783054 
    Average node length: 6.24, total dup: 8112174, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1589679, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 3912 
        40 - 59% = 4810 
        60 - 79% = 2727 
        80 - 99% = 2244 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12654, nodes: 9783054 
    Average node length: 5.99, total dup: 8495779, max dup: 44 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2424983, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 87 
        40 - 59% = 8702 
        60 - 79% = 3781 
        80 - 99% = 83 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10338, nodes: 9783054 
    Average node length: 5.14, total dup: 9782954, max dup: 140313 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1622282, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 55 
        20 - 39% = 1279 
        40 - 59% = 5149 
        60 - 79% = 1861 
        80 - 99% = 1994 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.05, total records: 11301074 
    Average version length: 82.52, total versions: 347003, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 120, data page slots: 195832 
    Data pages: 194120, average fill: 72% 
    Primary pages: 193958, secondary pages: 162, swept pages: 65124 
    Empty pages: 3239, full pages: 147293 
    Fill distribution: 
     0 - 19% = 5561 
    20 - 39% = 8079 
    40 - 59% = 17520 
    60 - 79% = 98611 
    80 - 99% = 64349 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13101, nodes: 11301074 
    Average node length: 5.30, total dup: 11191246, max dup: 681 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2374554, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 127 
        40 - 59% = 9061 
        60 - 79% = 3812 
        80 - 99% = 100 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10515, nodes: 11301074 
    Average node length: 5.50, total dup: 10808073, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 732482, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 181 
        20 - 39% = 857 
        40 - 59% = 2635 
        60 - 79% = 1841 
        80 - 99% = 5001 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14989, nodes: 11301074 
    Average node length: 6.03, total dup: 9860990, max dup: 68 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2390879, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 154 
        40 - 59% = 10544 
        60 - 79% = 4168 
        80 - 99% = 119 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10850, nodes: 11301074 
    Average node length: 5.22, total dup: 11300974, max dup: 165220 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 720798, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 111 
        20 - 39% = 852 
        40 - 59% = 4875 
        60 - 79% = 1549 
        80 - 99% = 3463 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 79.41, total records: 9833150 
    Average version length: 82.93, total versions: 444663, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 109, data page slots: 177688 
    Data pages: 177632, average fill: 69% 
    Primary pages: 177594, secondary pages: 38, swept pages: 66209 
    Empty pages: 469, full pages: 105581 
    Fill distribution: 
     0 - 19% = 1684 
    20 - 39% = 9719 
    40 - 59% = 28468 
    60 - 79% = 115971 
    80 - 99% = 21790 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11786, nodes: 9833150 
    Average node length: 5.18, total dup: 9804597, max dup: 1881 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2047308, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1426 
        40 - 59% = 7684 
        60 - 79% = 1996 
        80 - 99% = 651 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13967, nodes: 9833150 
    Average node length: 6.25, total dup: 8153084, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1545530, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 182 
        20 - 39% = 4031 
        40 - 59% = 4754 
        60 - 79% = 2711 
        80 - 99% = 2289 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12446, nodes: 9833150 
    Average node length: 5.44, total dup: 9395954, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2178271, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1417 
        40 - 59% = 8643 
        60 - 79% = 1776 
        80 - 99% = 586 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10401, nodes: 9833150 
    Average node length: 5.16, total dup: 9833050, max dup: 141747 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1629336, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1292 
        40 - 59% = 5160 
        60 - 79% = 1888 
        80 - 99% = 2012 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.23, total records: 577271 
    Average version length: 68.84, total versions: 9250, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8072 
    Data pages: 8072, average fill: 75% 
    Primary pages: 8071, secondary pages: 1, swept pages: 2998 
    Empty pages: 2, full pages: 7218 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 11 
    40 - 59% = 112 
    60 - 79% = 7813 
    80 - 99% = 132 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44436, depth: 3, leaf buckets: 740, nodes: 577271 
    Average node length: 5.95, total dup: 491285, max dup: 84 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 101817, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 20 
        40 - 59% = 543 
        60 - 79% = 85 
        80 - 99% = 91 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 38393, depth: 3, leaf buckets: 761, nodes: 577271 
    Average node length: 6.15, total dup: 473585, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101867, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 544 
        60 - 79% = 86 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 547, nodes: 577271 
    Average node length: 4.86, total dup: 577171, max dup: 9506 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90608, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 298 
        60 - 79% = 76 
        80 - 99% = 147 
 
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 Tue Apr  9 13:09:44 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7779636 95733 1 0.0000 0.0000
DOC_LIST 2253500 48290 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 6181 17 1500.0000 0.0000
INVNT_TURNOVER_LOG 105234 103562 1 0.0000 0.0000
MONEY_SALDO 49 384 13 700.0000 0.0000
MONEY_TURNOVER_LOG 2276 2131 1 0.0000 0.0000
PDISTR 830984 40952 2 0.0000 0.0000
PERF_SPLIT_0 186793 4067 1 0.0000 0.0000
PERF_SPLIT_1 157057 1646 1 0.0000 0.0000
PERF_SPLIT_2 160683 1877 1 0.0000 0.0000
PERF_SPLIT_3 150130 206 1 0.0000 0.0000
PERF_SPLIT_4 137533 1678 1 0.0000 0.0000
PERF_SPLIT_5 146393 830 1 0.0000 0.0000
PERF_SPLIT_6 149379 1259 1 0.0000 0.0000
PERF_SPLIT_7 153944 873 1 0.0000 0.0000
PERF_SPLIT_8 152949 3322 1 0.0000 0.0000
PERF_SPLIT_9 165313 21712 1 0.0000 0.0000
PSTORNED 2115893 48843 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 171055 90351 1 0.0000 0.0000
XQD_1000_3300 7176844 524237 1 0.0000 0.0000
XQD_1200_2000 12236263 451235 1 0.0000 0.0000
XQD_2000_3300 1783786 484176 1 0.0000 0.0000
XQD_2100_3300 1281771 161810 1 0.0000 0.0000
XQD_3300_3400 9315822 486742 1 0.0000 0.0000
XQS_1000_1200 21171094 16396 1 0.0000 0.0000
XQS_1000_3300 9783054 509027 1 0.0000 0.0000
XQS_1200_2000 11301074 347003 1 0.0000 0.0000
XQS_2100_3300 9833150 444663 1 0.0000 0.0000
XQS_3300_3400 577271 9250 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 ---
:348: 
:349: mscs-test-161.budzdorov.ru    Tue Apr  9 13:07:55 2024
:350:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:351: 
--- end of diff output ---

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

09.04.24 13:09:56. 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-04-09 13:09:59 No severe PSQL-related problems occured
09.04.24 13:10:00. End of report.