Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.04.2024 16:10
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 15579328 kB
MemAvailable 30149304 kB
Buffers 0 kB
Cached 16147084 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 3.0.12
DB_NAME                         /home/bases/oltp30-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/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/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=3333
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/oltp30-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-oltp30
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-04 16:09:44
DTS_END                         2024-04-04 16:09:44.6500
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38748
TRN_ID                          176108
ATT_ID                          605
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: 9206.14 22266 920614
customer order: creation 176.89 375 17689
customer order: refuse 15.08 439 1508
order to supplier: creation 46.55 1253 4655
order to supplier: removal 3.30 105529 330
invoice (draft): creation 46.85 3361 4685
invoice (draft): removal 49.93 785 4993
invoice accept: apply 42.68 21832 4268
invoice accept: cancel 45.49 880 4549
customer reserve: creation 4040.33 213 404033
customer reserve: removal 4433.01 61 443301
realization accept: apply 85.51 218 8551
realization accept: cancel 88.93 125 8893
payment from customer: creation 59.33 116 5933
payment from customer: removal 5.86 81 586
payment to supplier: creation 51.15 139 5115
payment to supplier: removal 3.24 101 324
service: total inventory turnovers 4.74 1362 474
service: total monetary turnovers 6.41 56 641
service: aggregate perf. data 0.83 24628 83
service: refresh index statistics 0.03 283756 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-04-2024 16:10:53 to 04-04-2024 16:10:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3090
TEST_TIME 2 2935
TEST_TIME 3 3535
TEST_TIME 4 4545
TEST_TIME 5 4938
TEST_TIME 6 5240
TEST_TIME 7 5458
TEST_TIME 8 5235
TEST_TIME 9 5154
TEST_TIME 10 5435
TEST_TIME 11 5341
TEST_TIME 12 5444
TEST_TIME 13 5574
TEST_TIME 14 5537
TEST_TIME 15 5981
TEST_TIME 16 6326
TEST_TIME 17 6624
TEST_TIME 18 7001
TEST_TIME 19 7056
TEST_TIME 20 7256
TEST_TIME 21 7576
TEST_TIME 22 7778
TEST_TIME 23 7848
TEST_TIME 24 7919
TEST_TIME 25 7999
TEST_TIME 26 8089
TEST_TIME 27 8467
TEST_TIME 28 8499
TEST_TIME 29 9498
TEST_TIME 30 9305
TEST_TIME 31 9146
TEST_TIME 32 9143
TEST_TIME 33 9048
TEST_TIME 34 9173
TEST_TIME 35 9099
TEST_TIME 36 8967
TEST_TIME 37 8915
TEST_TIME 38 8948
TEST_TIME 39 8943
TEST_TIME 40 8977
TEST_TIME 41 9001
TEST_TIME 42 9068
TEST_TIME 43 9011
TEST_TIME 44 9047
TEST_TIME 45 8959
TEST_TIME 46 9243
TEST_TIME 47 9101
TEST_TIME 48 9083
TEST_TIME 49 9011
TEST_TIME 50 9249
TEST_TIME 51 9396
TEST_TIME 52 9405
TEST_TIME 53 9385
TEST_TIME 54 9485
TEST_TIME 55 9486
TEST_TIME 56 9488
TEST_TIME 57 9689
TEST_TIME 58 9587
TEST_TIME 59 9476
TEST_TIME 60 9420
TEST_TIME 61 9373
TEST_TIME 62 9301
TEST_TIME 63 9252
TEST_TIME 64 9265
TEST_TIME 65 9320
TEST_TIME 66 9360
TEST_TIME 67 9364
TEST_TIME 68 9298
TEST_TIME 69 9277
TEST_TIME 70 9323
TEST_TIME 71 9375
TEST_TIME 72 9400
TEST_TIME 73 9413
TEST_TIME 74 9402
TEST_TIME 75 9400
TEST_TIME 76 9427
TEST_TIME 77 9477
TEST_TIME 78 9428
TEST_TIME 79 9440
TEST_TIME 80 9491
TEST_TIME 81 9493
TEST_TIME 82 9462
TEST_TIME 83 9582
TEST_TIME 84 9472
TEST_TIME 85 9445
TEST_TIME 86 9457
TEST_TIME 87 9432
TEST_TIME 88 9389
TEST_TIME 89 9344
TEST_TIME 90 9319
TEST_TIME 91 9268
TEST_TIME 92 9209
TEST_TIME 93 9195
TEST_TIME 94 9163
TEST_TIME 95 9161
TEST_TIME 96 9197
TEST_TIME 97 9164
TEST_TIME 98 9149
TEST_TIME 99 9243
TEST_TIME 100 9210

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-04-2024 16:10:56 to 04-04-2024 16:10:59.

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 1289897 1289897 0 0.00 0 26315 7 0 0
doc_list_biud 1289893 1289893 0 0.00 0 63278 27 0 0
sp_add_invoice_to_stock 4353 4268 85 1.95 26 183268 21833 0 85
sp_cancel_adding_invoice 4549 4549 0 0.00 4 61273 880 0 0
sp_cancel_client_order 1508 1508 0 0.00 4 33382 440 0 0
sp_cancel_customer_reserve 443301 443301 0 0.00 1 63280 62 0 0
sp_cancel_pay_from_customer 586 586 0 0.00 3 6241 82 0 0
sp_cancel_pay_to_supplier 324 324 0 0.00 3 4513 102 0 0
sp_cancel_supplier_invoice 5005 4993 12 0.23 1 14619 785 0 12
sp_cancel_supplier_order 330 330 0 0.00 6 895191 105530 0 0
sp_cancel_write_off 8893 8893 0 0.00 1 10285 125 0 0
sp_client_order 17689 17689 0 0.00 3 28469 376 0 0
sp_customer_reserve 404033 404033 0 0.00 0 82941 213 0 0
sp_fill_shopping_cart 27018 27018 0 0.00 1 12243 35 0 0
sp_fill_shopping_cart_clo_res 404024 404024 0 0.00 0 19518 16 0 0
sp_get_clo_for_invoice 4258 4258 0 0.00 0 32798 295 0 0
sp_kill_cost_storno 14352 14352 0 0.00 0 8642 65 0 0
sp_kill_qstorno_ret_qs2qd 900818 900818 0 0.00 0 61998 34 0 0
sp_kill_qty_storno 476382 476382 0 0.00 0 63277 73 0 0
sp_lock_selected_doc 17624 17624 0 0.00 0 7115 5 0 0
sp_make_cost_storno 23856 23856 0 0.00 0 26302 67 0 0
sp_multiply_rows_for_pdistr 23855 23855 0 0.00 0 8350 32 0 0
sp_multiply_rows_for_qdistr 17689 17689 0 0.00 0 28441 168 0 0
sp_pay_from_customer 5933 5933 0 0.00 4 9364 116 0 0
sp_pay_to_supplier 5115 5115 0 0.00 4 12831 140 0 0
sp_payment_common 11047 11047 0 0.00 2 7921 25 0 0
sp_qd_handle_on_cancel_clo 1508 1508 0 0.00 0 33377 415 0 0
sp_qd_handle_on_invoice_upd_sts 8806 8806 0 0.00 0 34620 354 0 0
sp_qd_handle_on_reserve_upd_sts 8551 8551 0 0.00 0 32003 77 0 0
sp_reserve_write_off 8551 8551 0 0.00 6 32026 218 0 0
sp_supplier_invoice 4685 4685 0 0.00 6 103053 3362 0 0
sp_supplier_order 4655 4655 0 0.00 6 26727 1253 0 0
srv_aggregate_perf_data 83 83 0 0.00 1757 545797 24629 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1116 205533 41386 0 0
srv_find_qd_qs_mism 877168 877168 0 0.00 0 20536 7 0 0
srv_make_invnt_saldo 474 474 0 0.00 30 64185 1363 0 0
srv_make_money_saldo 641 641 0 0.00 1 6788 57 0 0
srv_recalc_idx_stat 3 3 0 0.00 197731 393007 283756 0 0
t$perf-abend:sp_add_invoice_to_stock 85 85 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4268 4268 0 0.00 0 8418 218 0 0
t$perf-norm:sp_cancel_adding_invoice 336 336 0 0.00 0 8827 133 0 0
t$perf-norm:sp_cancel_client_order 1508 1508 0 0.00 0 6246 20 0 0
t$perf-norm:sp_cancel_customer_reserve 543 543 0 0.00 0 4752 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 586 586 0 0.00 0 1764 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 324 324 0 0.00 0 5911 33 0 0
t$perf-norm:sp_cancel_supplier_invoice 336 336 0 0.00 0 3330 30 0 0
t$perf-norm:sp_cancel_supplier_order 330 330 0 0.00 0 23674 1718 0 0
t$perf-norm:sp_cancel_write_off 854 854 0 0.00 0 1698 10 0 0
t$perf-norm:sp_client_order 17690 17690 0 0.00 0 14228 21 0 0
t$perf-norm:sp_customer_reserve 852 852 0 0.00 0 730 5 0 0
t$perf-norm:sp_pay_from_customer 5933 5933 0 0.00 0 4734 11 0 0
t$perf-norm:sp_pay_to_supplier 5115 5115 0 0.00 0 5085 9 0 0
t$perf-norm:sp_reserve_write_off 8551 8551 0 0.00 0 4733 11 0 0
t$perf-norm:sp_supplier_invoice 4685 4685 0 0.00 0 6909 25 0 0
t$perf-norm:sp_supplier_order 4655 4655 0 0.00 0 7411 22 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 102 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 12 1 0 0
t$perf-norm:srv_make_invnt_saldo 474 474 0 0.00 0 1635 37 0 0
t$perf-norm:srv_make_money_saldo 641 641 0 0.00 0 1397 20 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 44 20 0 0
v_add_invoice_to_stock 8684 8514 170 1.95 0 7914 19 0 170
v_all_customers 32924 32924 0 0.00 0 46 1 0 0
v_all_suppliers 26624 26624 0 0.00 0 96 1 0 0
v_all_wares 35376 35376 0 0.00 0 44 1 0 0
v_cancel_adding_invoice 672 672 0 0.00 0 617 7 0 0
v_cancel_client_order 3016 3016 0 0.00 0 4455 6 0 0
v_cancel_customer_prepayment 1172 1172 0 0.00 0 6236 13 0 0
v_cancel_customer_reserve 1086 1086 0 0.00 0 4485 10 0 0
v_cancel_payment_to_supplier 648 648 0 0.00 0 4484 13 0 0
v_cancel_supplier_invoice 696 672 24 3.44 0 763 13 0 24
v_cancel_supplier_order 660 660 0 0.00 0 533 5 0 0
v_cancel_write_off 1708 1708 0 0.00 0 1735 14 0 0
v_max_id_clo_ord 4653 4653 0 0.00 0 88 1 0 0
v_max_id_clo_res 852 852 0 0.00 0 3097 16 0 0
v_max_id_ord_sup 4674 4674 0 0.00 0 2291 2 0 0
v_max_non_paid_invoice 1129 1129 0 0.00 0 709 3 0 0
v_max_non_paid_realizn 2835 2835 0 0.00 0 2203 5 0 0
v_min_id_clo_ord 4653 4653 0 0.00 0 11715 11 0 0
v_min_id_clo_res 852 852 0 0.00 0 720 3 0 0
v_min_id_ord_sup 4674 4674 0 0.00 0 6122 4 0 0
v_min_non_paid_invoice 5114 5114 0 0.00 0 7917 16 0 0
v_min_non_paid_realizn 5933 5933 0 0.00 0 6211 20 0 0
v_our_firm 8648 8648 0 0.00 0 22 1 0 0
v_reserve_write_off 17098 17098 0 0.00 0 12808 9 0 0
x_lock_depdocs_on_canc_invoice 9206 9206 0 0.00 0 24607 145 0 0
x_lock_depdocs_on_canc_sup_ord 330 330 0 0.00 0 6021 378 0 0
x_make_qstorno_1000_1200 4655 4655 0 0.00 1 26717 1169 0 0
x_make_qstorno_1200_2000 4685 4685 0 0.00 3 102717 3242 0 0
x_make_qstorno_2100_3300 404032 404032 0 0.00 0 82923 193 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 04-04-2024 16:11:00 to 04-04-2024 16:11:05.

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
14:09:48 7 8192000000 8798878432 8810168320 5304288 0.064 2 1 2 0 5403888 56816 42784
14:10:49 50871 8192000000 9920802720 10233131008 985244208 10.735 100 86 172 0 1013882208 5846832 22791168
14:12:48 15731 8192000000 9956012880 10279944192 1034581856 11.213 100 88 176 0 1065680736 8758416 22340464
14:14:09 7266 8192000000 9994796160 10331119616 1078484128 11.633 100 84 168 0 1109645344 10267184 20894032
14:15:21 8951 8192000000 10041900720 10390151168 1125252928 12.077 100 89 177 0 1159214048 12711168 21249952
14:16:44 3837 8192000000 10080478800 10440155136 1164019024 12.441 100 85 169 0 1197492496 13849936 19623536
14:17:52 2193 8192000000 10130346192 10498289664 1217685856 12.940 100 83 164 1 1249102944 13518096 17898992
14:18:56 4030 8192000000 10150397936 10528894976 1244528096 13.188 100 74 148 0 1273312912 12643600 16141216
14:20:01 905 8192000000 10194251968 10576113664 1281366944 13.525 100 91 181 1 1313186464 11335200 20484320
14:21:04 1831 8192000000 10216570208 10602729472 1299344976 13.689 100 81 163 1 1330189056 12817056 18027024
14:22:08 7419 8192000000 10216606000 10609192960 1304748992 13.738 100 69 140 1 1332043600 11966160 15328448
14:23:16 7595 8192000000 10208781440 10622152704 1316510896 13.845 100 30 61 0 1330826064 7673664 6641504
14:24:27 13872 8192000000 10203693376 10622906368 1321184864 13.887 100 15 30 0 1330355264 5738384 3432016
14:25:41 9447 8192000000 10206759984 10631172096 1328411376 13.953 100 11 22 1 1336069872 5601184 2057312
14:26:55 21751 8192000000 10240920624 10647871488 1333344256 13.997 100 58 119 0 1353074032 6518944 13210832
14:28:18 5810 8192000000 10228717328 10652360704 1339488576 14.053 100 26 52 1 1351019280 5948432 5582272
14:29:25 7471 8192000000 10212055072 10639122432 1321783344 13.893 99 21 42 0 1332605440 6061200 4760896
14:30:36 32029 8192000000 10224573424 10632564736 1292149984 13.624 96 51 98 1 1311590144 7949472 11490688
14:32:10 58137 8192000000 10212129968 10630836224 1275248096 13.470 96 52 104 2 1299178864 12327744 11603024
14:34:15 18661 8192000000 10227224128 10638151680 1305076496 13.741 98 46 89 0 1324742288 9418384 10247408
14:35:40 26707 8192000000 10234198976 10646130688 1304382784 13.735 98 55 110 1 1329673632 12603456 12687392
14:37:10 10460 8192000000 10218694416 10617634816 1298741536 13.684 99 57 114 0 1323634112 11986896 12905680
14:38:24 8239 8192000000 10225403344 10626273280 1310160672 13.788 100 61 124 0 1337178912 12979088 14039152
14:39:40 42799 8192000000 10172591360 10570375168 1217798592 12.941 92 35 70 1 1242158336 16290256 8069488
14:41:27 10102 8192000000 10224735936 10625064960 1307804672 13.766 100 53 106 0 1334203760 13750288 12648800
14:42:41 28226 8192000000 10263611600 10663510016 1328336176 13.952 99 56 112 0 1359938512 18534688 13067648
14:44:20 3312 8192000000 10271395376 10678677504 1339760416 14.055 99 55 108 0 1376619984 23002736 13856832
14:45:27 1549 8192000000 10283137344 10681438208 1339902688 14.057 99 81 159 2 1385050144 26818960 18328496
14:46:33 1113 8192000000 10307295264 10715676672 1368834096 14.317 100 71 138 2 1415639936 29297136 17508704
14:47:40 2918 8192000000 10320666832 10725605376 1372881120 14.353 100 79 156 1 1420877168 30058512 17937536
14:48:55 5024 8192000000 10326237456 10739687424 1386114544 14.471 100 70 142 1 1431296048 27798976 17382528
14:50:09 2699 8192000000 10324424848 10737520640 1382809056 14.442 100 69 138 0 1432552944 31940672 17803216
14:51:18 10224 8192000000 10323012176 10753937408 1397410544 14.572 100 42 80 1 1435635136 28067968 10156624
14:52:38 16060 8192000000 10335709296 10764345344 1399041424 14.586 100 46 91 1 1442750304 31825456 11883424
14:53:57 20713 8192000000 10322005984 10760101888 1397642576 14.574 100 25 50 0 1436536848 32170128 6724144
14:55:23 11961 8192000000 10338760256 10770956288 1399659584 14.592 100 46 92 1 1446249472 34996960 11592928
14:57:14 36035 8192000000 10328496656 10769993728 1390864512 14.514 100 23 46 0 1440720384 43372912 6482960
14:58:57 26761 8192000000 10312094496 10746408960 1401775808 14.611 100 38 74 2 1416931440 5692944 9462688
15:00:26 44858 8192000000 10304416624 10750087168 1394035120 14.542 100 45 90 0 1416645312 12180416 10429776
15:02:13 102069 8192000000 10299639440 10752700416 1400637744 14.601 100 26 53 0 1417479888 10578720 6263424
15:05:14 42077 8192000000 10297929104 10744172544 1396943456 14.568 100 24 46 0 1410416560 7933392 5539712
15:07:00 20184 8192000000 10318092128 10761297920 1406633376 14.654 100 33 64 0 1424782688 10764720 7384592
15:08:34 10433 8192000000 10293915792 10733039616 1380792576 14.424 99 42 87 1 1401709056 10569248 10347232
15:09:48 40700 8192000000 10293139472 10735874048 1358230832 14.221 97 25 50 1 1375313952 11749776 5333344
15:11:31 28889 8192000000 10297924528 10743640064 1379765808 14.414 99 38 76 1 1401467408 13045296 8656304
15:13:11 73179 8192000000 10261417360 10708262912 1330923296 13.975 97 19 38 0 1350308656 14903952 4481408
15:15:25 43312 8192000000 10256265184 10704302080 1324175088 13.914 97 9 18 0 1339579744 13527920 1876736
15:17:09 38002 8192000000 10295463136 10737795072 1375765840 14.379 100 28 56 0 1401376912 19112864 6498208
15:18:49 35082 8192000000 10278286496 10720137216 1357291264 14.213 99 34 68 0 1393621872 28278480 8052128
15:20:46 45412 8192000000 10269716768 10709929984 1347549648 14.125 99 18 36 0 1367731104 15604608 4576848
15:22:37 53638 8192000000 10264078528 10717360128 1333033952 13.995 98 15 28 0 1351453616 15103920 3315744
15:24:35 13592 8192000000 10265196640 10691981312 1326805792 13.938 98 44 86 0 1359196304 23561120 8829392
15:25:50 32069 8192000000 10277184304 10721271808 1359422256 14.232 100 25 49 1 1387168672 22053456 5692960
15:27:29 45849 8192000000 10261445456 10698084352 1349543504 14.143 100 45 89 3 1369623488 9677776 10402208
15:29:34 72768 8192000000 10253590080 10689650688 1336713728 14.028 98 31 60 0 1353730848 10565968 6451152
15:32:13 43140 8192000000 10280326048 10718457856 1351228000 14.159 99 38 76 0 1377598352 17893520 8476832
15:34:33 34421 8192000000 10275551216 10715615232 1337211456 14.032 98 15 30 0 1358954320 18275568 3467296
15:36:13 72909 8192000000 10273296496 10725310464 1363546352 14.269 99 19 38 0 1384536080 16494864 4494864
15:38:39 67742 8192000000 10271341248 10719485952 1340806464 14.065 98 10 19 0 1361428864 18564128 2058272
15:40:47 54984 8192000000 10290564320 10733694976 1335155888 14.014 96 23 43 0 1350493872 10491040 4846944
15:42:56 34239 8192000000 10296628448 10737602560 1382360512 14.438 100 21 42 1 1394584224 8142592 4081120
15:44:32 52096 8192000000 10319603168 10769838080 1401940704 14.612 100 28 56 0 1422325600 14048000 6336896
15:46:39 53598 8192000000 10321058160 10761986048 1387891200 14.487 99 22 42 1 1401087008 7899552 5296256
15:48:34 40449 8192000000 10331848464 10761269248 1377782400 14.397 98 35 68 0 1398628816 13179328 7667088
15:50:16 90500 8192000000 10313358544 10760474624 1332072992 13.986 95 7 14 0 1346128336 12740336 1315008
15:52:48 205533 8192000000 10307522400 10763980800 1386050032 14.471 99 17 34 2 1417185552 26898448 4237072
15:57:43 69679 8192000000 10289352688 10745606144 1394329552 14.544 100 11 22 0 1404675312 7776000 2569760
15:59:53 40977 8192000000 10293421392 10738049024 1368902576 14.317 98 20 38 1 1382934832 9413520 4618736
16:01:45 74760 8192000000 10266795824 10720735232 1345132160 14.104 97 9 18 0 1356923232 10000000 1791072
16:04:00 76509 8192000000 10273727248 10729537536 1339919616 14.057 97 18 36 0 1356293072 12113536 4259920
16:06:17 69740 8192000000 10246119216 10688081920 1282077216 13.532 93 13 26 0 1297995440 12901888 3016336
16:08:32 78891 8192000000 9328242208 9609883648 463275968 5.352 34 3 6 0 472819712 8637696 906048

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 04-04-2024 16:11:07 to 04-04-2024 16:11:20.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 85 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-04-2024 16:11:21 to 04-04-2024 16:11:23.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          177056
MON$OLDEST_ACTIVE               177057
MON$OLDEST_SNAPSHOT             177057
MON$NEXT_TRANSACTION            177057
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-03 16:41:55.3470
MON$PAGES                       1914336
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.12.33740 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33740 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Apr  4 16:11:24 2024 
 
Database header page information: 
    Flags            0 
    Generation        92362 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    177056 
    Oldest active        177057 
    Oldest snapshot        177057 
    Next transaction    177058 
    Sequence number        0 
    Next attachment ID    716 
    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 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    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: 1504311, 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: 1504313, 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: 1504312, 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: 1504310, 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: 1504309, 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: 504, Index root page: 505 
    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: 1504242, 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: 1504244, 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: 1504243, 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: 1504241, 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: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.25, total records: 7776981 
    Average version length: 48.16, total versions: 104616, 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: 54, data page slots: 86840 
    Data pages: 86840, average fill: 72% 
    Primary pages: 86840, secondary pages: 0, swept pages: 16845 
    Empty pages: 2, full pages: 65773 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 137 
    40 - 59% = 1474 
    60 - 79% = 85203 
    80 - 99% = 16 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23337, nodes: 7776981 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1737362, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 342 
        20 - 39% = 1772 
        40 - 59% = 4182 
        60 - 79% = 2289 
        80 - 99% = 14752 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13544, nodes: 7776981 
    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: 1559444, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1564 
        40 - 59% = 2073 
        60 - 79% = 1014 
        80 - 99% = 8893 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8361, nodes: 7776981 
    Average node length: 6.62, total dup: 5812428, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1552469, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 952 
        40 - 59% = 1411 
        60 - 79% = 864 
        80 - 99% = 5007 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.12, total records: 2255924 
    Average version length: 34.88, total versions: 103878, max versions: 3 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28408 
    Data pages: 28408, average fill: 74% 
    Primary pages: 28404, secondary pages: 4, swept pages: 8460 
    Empty pages: 4, full pages: 20555 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 67 
    40 - 59% = 1230 
    60 - 79% = 26241 
    80 - 99% = 859 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4578, nodes: 2255924 
    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: 695820, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 912 
        40 - 59% = 850 
        60 - 79% = 730 
        80 - 99% = 2086 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2520, nodes: 2259137 
    Average node length: 4.97, total dup: 2258238, max dup: 20427 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1256320, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 264 
        40 - 59% = 1519 
        60 - 79% = 529 
        80 - 99% = 207 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2088, nodes: 2255924 
    Average node length: 4.97, total dup: 2255874, max dup: 130295 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062392, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 94 
        40 - 59% = 1157 
        60 - 79% = 47 
        80 - 99% = 785 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4394, nodes: 2255924 
    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: 695820, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 604 
        40 - 59% = 638 
        60 - 79% = 807 
        80 - 99% = 2232 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    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: 1504315, 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: 1504316, 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: 1504314, 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: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, 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.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, 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: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.53, total records: 400 
    Average version length: 23.02, total versions: 238458, max versions: 616 
    Average fragment length: 2.00, total fragments: 43, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1328, average fill: 90% 
    Primary pages: 11, secondary pages: 1317, swept pages: 0 
    Empty pages: 4, full pages: 1323 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1323 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 14.82, total records: 139538 
    Average version length: 68.28, total versions: 109273, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.94 
    Pointer pages: 6, data page slots: 2816 
    Data pages: 2224, average fill: 76% 
    Primary pages: 2223, secondary pages: 1, swept pages: 0 
    Empty pages: 82, full pages: 1728 
    Fill distribution: 
     0 - 19% = 163 
    20 - 39% = 114 
    40 - 59% = 150 
    60 - 79% = 378 
    80 - 99% = 1419 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1710700, depth: 3, leaf buckets: 398, nodes: 139538 
    Average node length: 13.19, total dup: 10502, max dup: 2 
    Average key length: 10.63, compression ratio: 2.54 
    Average prefix length: 19.29, average data length: 7.71 
    Clustering factor: 100318, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 250 
        60 - 79% = 129 
        80 - 99% = 11 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 17257, max versions: 940 
    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: 64 
    Data pages: 64, average fill: 87% 
    Primary pages: 3, secondary pages: 61, swept pages: 0 
    Empty pages: 2, full pages: 61 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 10 
    80 - 99% = 52 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, 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: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 10.60, total records: 2928 
    Average version length: 43.50, total versions: 2230, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.47 
    Pointer pages: 1, data page slots: 40 
    Data pages: 39, average fill: 68% 
    Primary pages: 37, secondary pages: 2, swept pages: 0 
    Empty pages: 6, full pages: 27 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 26 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88856, depth: 2, leaf buckets: 4, nodes: 2928 
    Average node length: 4.09, total dup: 2830, max dup: 281 
    Average key length: 2.36, compression ratio: 8.05 
    Average prefix length: 18.67, average data length: 0.33 
    Clustering factor: 1470, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    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: 520, Index root page: 521 
    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: 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 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, 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: 1504226, 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: 1504228, 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: 1504225, 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: 522, Index root page: 523 
    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: 1504224, 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: 1504222, 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: 1504221, 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: 1504223, 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: 1504220, 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: 468, Index root page: 469 
    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: 1544805, 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: 1544804, 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: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.80, total records: 827241 
    Average version length: 25.56, total versions: 81822, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8032, average fill: 72% 
    Primary pages: 8018, secondary pages: 14, swept pages: 1034 
    Empty pages: 7, full pages: 7841 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 10 
    40 - 59% = 14 
    60 - 79% = 7652 
    80 - 99% = 344 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 874, nodes: 827241 
    Average node length: 4.87, total dup: 827192, max dup: 147262 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91325, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 84 
        40 - 59% = 492 
        60 - 79% = 203 
        80 - 99% = 92 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 963, nodes: 827241 
    Average node length: 5.89, total dup: 736152, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163668, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 101 
        40 - 59% = 438 
        60 - 79% = 139 
        80 - 99% = 282 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1014, nodes: 827241 
    Average node length: 5.89, total dup: 736152, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165655, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 205 
        40 - 59% = 409 
        60 - 79% = 115 
        80 - 99% = 284 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1136, nodes: 827241 
    Average node length: 5.97, total dup: 736152, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158392, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 210 
        40 - 59% = 590 
        60 - 79% = 237 
        80 - 99% = 98 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5444 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.78, total fragments: 78, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 77, secondary pages: 19, swept pages: 49 
    Empty pages: 12, full pages: 66 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5444 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.40, average data length: 1.54 
    Clustering factor: 5106, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5444 
    Average node length: 11.11, 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: 157, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 80805 
    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: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 778 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 778 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35756, depth: 2, leaf buckets: 103, nodes: 80805 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3328, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    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: 1504239, 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: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    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.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 147.85, total records: 170169 
    Average version length: 152.87, total versions: 3352, 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: 4496 
    Data pages: 4072, average fill: 86% 
    Primary pages: 4072, secondary pages: 0, swept pages: 5 
    Empty pages: 36, full pages: 4026 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4025 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 126.48, total records: 204782 
    Average version length: 155.26, total versions: 33341, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.41 
    Pointer pages: 7, data page slots: 7144 
    Data pages: 4968, average fill: 87% 
    Primary pages: 4968, secondary pages: 0, swept pages: 5 
    Empty pages: 74, full pages: 4859 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 10 
    40 - 59% = 12 
    60 - 79% = 8 
    80 - 99% = 4859 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 150.01, total records: 169379 
    Average version length: 151.81, total versions: 1236, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 6, data page slots: 4176 
    Data pages: 4064, average fill: 86% 
    Primary pages: 4064, secondary pages: 0, swept pages: 1 
    Empty pages: 41, full pages: 4010 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4010 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 135.75, total records: 193811 
    Average version length: 154.78, total versions: 19640, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.49 
    Pointer pages: 7, data page slots: 5056 
    Data pages: 4640, average fill: 87% 
    Primary pages: 4640, secondary pages: 0, swept pages: 6 
    Empty pages: 29, full pages: 4598 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 9 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 4597 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 136.79, total records: 155624 
    Average version length: 154.91, total versions: 14491, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.40 
    Pointer pages: 7, data page slots: 4096 
    Data pages: 3736, average fill: 87% 
    Primary pages: 3736, secondary pages: 0, swept pages: 1 
    Empty pages: 37, full pages: 3687 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3687 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 150.28, total records: 182324 
    Average version length: 150.86, total versions: 1025, 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: 6, data page slots: 5296 
    Data pages: 4344, average fill: 86% 
    Primary pages: 4343, secondary pages: 1, swept pages: 2 
    Empty pages: 18, full pages: 4319 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 4320 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.09, total records: 172351 
    Average version length: 152.46, total versions: 2103, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 4144 
    Data pages: 4112, average fill: 86% 
    Primary pages: 4112, secondary pages: 0, swept pages: 3 
    Empty pages: 25, full pages: 4078 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 4078 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 150.22, total records: 178709 
    Average version length: 150.21, total versions: 1088, 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: 7, data page slots: 4640 
    Data pages: 4272, average fill: 86% 
    Primary pages: 4272, secondary pages: 0, swept pages: 3 
    Empty pages: 30, full pages: 4229 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4230 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.73, total records: 165369 
    Average version length: 151.28, total versions: 1110, 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: 6, data page slots: 4904 
    Data pages: 3960, average fill: 86% 
    Primary pages: 3960, secondary pages: 0, swept pages: 4 
    Empty pages: 39, full pages: 3907 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3908 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 131.69, total records: 197733 
    Average version length: 154.09, total versions: 25420, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.88 
    Pointer pages: 7, data page slots: 6928 
    Data pages: 4808, average fill: 86% 
    Primary pages: 4807, secondary pages: 1, swept pages: 5 
    Empty pages: 97, full pages: 4684 
    Fill distribution: 
     0 - 19% = 102 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 4684 
 
PHRASES (143) 
    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 PHRASES_ID_DESC (3) 
    Root page: 1510354, 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: 1510353, 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: 1510352, 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: 1510351, 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: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.57, total records: 2104448 
    Average version length: 52.91, total versions: 46958, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25664 
    Data pages: 25656, average fill: 71% 
    Primary pages: 25656, secondary pages: 0, swept pages: 10852 
    Empty pages: 295, full pages: 20443 
    Fill distribution: 
     0 - 19% = 573 
    20 - 39% = 486 
    40 - 59% = 1230 
    60 - 79% = 22995 
    80 - 99% = 372 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2604, nodes: 2104448 
    Average node length: 5.44, total dup: 1964499, max dup: 1395 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181833, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 290 
        40 - 59% = 1749 
        60 - 79% = 270 
        80 - 99% = 291 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2762, nodes: 2104448 
    Average node length: 5.69, total dup: 1888583, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376039, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2421 
        60 - 79% = 303 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2179, nodes: 2104448 
    Average node length: 4.96, total dup: 2104348, max dup: 27927 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179429, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 238 
        40 - 59% = 1164 
        60 - 79% = 406 
        80 - 99% = 370 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    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: 1504317, 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: 470, Index root page: 471 
    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: 1544803, 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: 1544802, 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: 500, Index root page: 501 
    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: 1504305, 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: 1504306, 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: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, 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: 525, 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: 1544806, 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: 454, Index root page: 455 
    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: 1544810, 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: 460, Index root page: 461 
    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: 1544807, 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: 462, Index root page: 463 
    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: 464, Index root page: 465 
    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: 518, Index root page: 519 
    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: 516, Index root page: 517 
    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: 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 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    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: 456, Index root page: 457 
    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: 1544809, 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: 1544808, 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: 452, Index root page: 453 
    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: 1544811, 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: 528, Index root page: 529 
    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: 1504214, 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: 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 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    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: 1552159, 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: 1510355, 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: 1510360, 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: 1510358, 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: 498, Index root page: 499 
    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: 1504307, 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: 1504308, 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: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 35.91, total records: 157651 
    Average version length: 69.15, total versions: 75868, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.51 
    Pointer pages: 3, data page slots: 4272 
    Data pages: 3448, average fill: 53% 
    Primary pages: 3448, secondary pages: 0, swept pages: 582 
    Empty pages: 821, full pages: 1996 
    Fill distribution: 
     0 - 19% = 1079 
    20 - 39% = 158 
    40 - 59% = 100 
    60 - 79% = 730 
    80 - 99% = 1381 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 98502, depth: 3, leaf buckets: 231, nodes: 157651 
    Average node length: 6.46, total dup: 137094, max dup: 14 
    Average key length: 3.94, compression ratio: 10.66 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26966, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 113 
        60 - 79% = 64 
        80 - 99% = 18 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.00, total records: 7293467 
    Average version length: 68.78, total versions: 526035, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 63, data page slots: 102544 
    Data pages: 102544, average fill: 76% 
    Primary pages: 102544, secondary pages: 0, swept pages: 18181 
    Empty pages: 9, full pages: 91137 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 506 
    40 - 59% = 3240 
    60 - 79% = 87243 
    80 - 99% = 11485 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10713, nodes: 7293467 
    Average node length: 6.51, total dup: 6307167, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1599681, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1376 
        40 - 59% = 5719 
        60 - 79% = 2932 
        80 - 99% = 679 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8549, nodes: 7293467 
    Average node length: 5.39, total dup: 7007214, max dup: 151 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1393122, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 979 
        40 - 59% = 4692 
        60 - 79% = 1680 
        80 - 99% = 1193 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8622, nodes: 7293467 
    Average node length: 5.39, total dup: 7007214, max dup: 151 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1395661, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1057 
        40 - 59% = 4659 
        60 - 79% = 1701 
        80 - 99% = 1194 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.77, total records: 12124260 
    Average version length: 68.72, total versions: 384256, 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: 103, data page slots: 167056 
    Data pages: 167056, average fill: 77% 
    Primary pages: 167056, secondary pages: 0, swept pages: 67744 
    Empty pages: 3, full pages: 162430 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 252 
    40 - 59% = 1438 
    60 - 79% = 156746 
    80 - 99% = 8582 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18358, nodes: 12124260 
    Average node length: 6.58, total dup: 10566888, max dup: 77 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2375111, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2155 
        40 - 59% = 10776 
        60 - 79% = 4592 
        80 - 99% = 810 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.12, total records: 1735485 
    Average version length: 69.11, total versions: 728653, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.14 
    Pointer pages: 25, data page slots: 39984 
    Data pages: 29584, average fill: 68% 
    Primary pages: 29583, secondary pages: 1, swept pages: 6301 
    Empty pages: 2102, full pages: 20353 
    Fill distribution: 
     0 - 19% = 3809 
    20 - 39% = 1903 
    40 - 59% = 1783 
    60 - 79% = 10375 
    80 - 99% = 11714 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2204, nodes: 1735485 
    Average node length: 5.51, total dup: 1665243, max dup: 99 
    Average key length: 2.55, compression ratio: 16.45 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 119497, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 404 
        40 - 59% = 1050 
        60 - 79% = 568 
        80 - 99% = 170 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.26, total records: 1308372 
    Average version length: 69.12, total versions: 602079, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.38 
    Pointer pages: 20, data page slots: 32568 
    Data pages: 27632, average fill: 55% 
    Primary pages: 27632, secondary pages: 0, swept pages: 5292 
    Empty pages: 4944, full pages: 15508 
    Fill distribution: 
     0 - 19% = 7689 
    20 - 39% = 1678 
    40 - 59% = 1331 
    60 - 79% = 6121 
    80 - 99% = 10813 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1729, nodes: 1308372 
    Average node length: 5.80, total dup: 1219911, max dup: 99 
    Average key length: 2.86, compression ratio: 14.69 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 178698, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 248 
        40 - 59% = 870 
        60 - 79% = 489 
        80 - 99% = 114 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.41, total records: 9334011 
    Average version length: 68.95, total versions: 607054, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 89, data page slots: 144160 
    Data pages: 144144, average fill: 69% 
    Primary pages: 144144, secondary pages: 0, swept pages: 44061 
    Empty pages: 266, full pages: 84179 
    Fill distribution: 
     0 - 19% = 980 
    20 - 39% = 5457 
    40 - 59% = 22024 
    60 - 79% = 106109 
    80 - 99% = 9574 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13485, nodes: 9334011 
    Average node length: 6.68, total dup: 7744511, max dup: 19 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2006661, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1279 
        40 - 59% = 6542 
        60 - 79% = 4799 
        80 - 99% = 865 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21177914 
    Average version length: 82.78, total versions: 13862, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319096 
    Data pages: 319096, average fill: 81% 
    Primary pages: 319096, secondary pages: 0, swept pages: 12309 
    Empty pages: 11, full pages: 318710 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 14 
    40 - 59% = 57 
    60 - 79% = 27211 
    80 - 99% = 291791 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19279, nodes: 21177914 
    Average node length: 5.72, total dup: 20696256, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285493, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 3 
        40 - 59% = 7881 
        60 - 79% = 559 
        80 - 99% = 10829 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17208, nodes: 21177914 
    Average node length: 6.31, total dup: 18611543, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916362, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 5 
        40 - 59% = 819 
        60 - 79% = 256 
        80 - 99% = 16124 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21067, nodes: 21177914 
    Average node length: 6.35, total dup: 18530001, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3580450, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 8182 
        60 - 79% = 607 
        80 - 99% = 12276 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16141, nodes: 21177914 
    Average node length: 5.56, total dup: 21177814, max dup: 232688 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944974, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 11 
        40 - 59% = 2914 
        60 - 79% = 415 
        80 - 99% = 12801 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.62, total records: 9743052 
    Average version length: 82.59, total versions: 566986, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 106, data page slots: 172080 
    Data pages: 172056, average fill: 70% 
    Primary pages: 172056, secondary pages: 0, swept pages: 64699 
    Empty pages: 301, full pages: 96865 
    Fill distribution: 
     0 - 19% = 1138 
    20 - 39% = 7332 
    40 - 59% = 29259 
    60 - 79% = 70953 
    80 - 99% = 63374 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11424, nodes: 9743052 
    Average node length: 5.37, total dup: 9433151, max dup: 205 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2120191, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 96 
        40 - 59% = 8163 
        60 - 79% = 3072 
        80 - 99% = 91 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13634, nodes: 9743052 
    Average node length: 6.24, total dup: 8080117, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1461059, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 4036 
        40 - 59% = 4352 
        60 - 79% = 2674 
        80 - 99% = 2436 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12755, nodes: 9743052 
    Average node length: 5.99, total dup: 8457109, max dup: 37 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2314451, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 107 
        40 - 59% = 9102 
        60 - 79% = 3433 
        80 - 99% = 112 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10223, nodes: 9743052 
    Average node length: 5.14, total dup: 9742952, max dup: 162117 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1502363, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1241 
        40 - 59% = 5246 
        60 - 79% = 1601 
        80 - 99% = 2095 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.37, total records: 11410010 
    Average version length: 82.51, total versions: 406786, 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: 119, data page slots: 194144 
    Data pages: 192920, average fill: 73% 
    Primary pages: 192920, secondary pages: 0, swept pages: 72079 
    Empty pages: 2888, full pages: 141751 
    Fill distribution: 
     0 - 19% = 5113 
    20 - 39% = 7576 
    40 - 59% = 18927 
    60 - 79% = 44607 
    80 - 99% = 116697 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13163, nodes: 11410010 
    Average node length: 5.31, total dup: 11299797, max dup: 638 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2385312, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 101 
        40 - 59% = 8934 
        60 - 79% = 3916 
        80 - 99% = 211 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10559, nodes: 11410010 
    Average node length: 5.51, total dup: 10912196, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 728454, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 153 
        20 - 39% = 841 
        40 - 59% = 2613 
        60 - 79% = 1891 
        80 - 99% = 5061 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15054, nodes: 11410010 
    Average node length: 6.04, total dup: 9955136, max dup: 77 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2401774, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 130 
        40 - 59% = 10438 
        60 - 79% = 4230 
        80 - 99% = 254 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10861, nodes: 11410010 
    Average node length: 5.23, total dup: 11409910, max dup: 195817 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 716804, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 841 
        40 - 59% = 4847 
        60 - 79% = 1443 
        80 - 99% = 3633 
 
XQS_2000_3300 (185) 
    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 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, 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: 1361755, 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: 1361754, 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: 1361752, 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: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 77.65, total records: 9898526 
    Average version length: 82.90, total versions: 608427, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 108, data page slots: 175632 
    Data pages: 175568, average fill: 70% 
    Primary pages: 175568, secondary pages: 0, swept pages: 64545 
    Empty pages: 446, full pages: 99305 
    Fill distribution: 
     0 - 19% = 1369 
    20 - 39% = 7474 
    40 - 59% = 29988 
    60 - 79% = 71885 
    80 - 99% = 64852 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11911, nodes: 9898526 
    Average node length: 5.19, total dup: 9869506, max dup: 1675 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1942579, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1473 
        40 - 59% = 7830 
        60 - 79% = 1901 
        80 - 99% = 671 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13805, nodes: 9898526 
    Average node length: 6.26, total dup: 8207540, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1434590, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 190 
        20 - 39% = 3940 
        40 - 59% = 4457 
        60 - 79% = 2574 
        80 - 99% = 2644 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12592, nodes: 9898526 
    Average node length: 5.44, total dup: 9455933, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2077758, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1433 
        40 - 59% = 8823 
        60 - 79% = 1719 
        80 - 99% = 581 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10426, nodes: 9898526 
    Average node length: 5.16, total dup: 9898426, max dup: 163821 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1528482, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1303 
        40 - 59% = 5376 
        60 - 79% = 1587 
        80 - 99% = 2118 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.81, total records: 574586 
    Average version length: 68.71, total versions: 11444, 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: 5, data page slots: 8024 
    Data pages: 8024, average fill: 75% 
    Primary pages: 8024, secondary pages: 0, swept pages: 3632 
    Empty pages: 1, full pages: 6567 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 23 
    40 - 59% = 301 
    60 - 79% = 7479 
    80 - 99% = 219 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44317, depth: 3, leaf buckets: 748, nodes: 574586 
    Average node length: 5.95, total dup: 489185, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99898, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 43 
        40 - 59% = 530 
        60 - 79% = 90 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29580, depth: 3, leaf buckets: 770, nodes: 574586 
    Average node length: 6.15, total dup: 471215, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99957, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 548 
        60 - 79% = 90 
        80 - 99% = 92 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 577, nodes: 574586 
    Average node length: 4.86, total dup: 574486, max dup: 9007 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88733, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 332 
        60 - 79% = 101 
        80 - 99% = 109 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    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: 535, Index root page: 536 
    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: 539, Index root page: 540 
    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: 545, Index root page: 546 
    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: 1504207, 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: 547, Index root page: 548 
    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: 1504206, 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: 541, Index root page: 542 
    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: 1504212, 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: 1504213, 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: 543, Index root page: 544 
    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: 1504209, 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: 1504208, 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: 1504211, 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: 1504210, 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: 533, Index root page: 534 
    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: 531, Index root page: 532 
    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: 484, Index root page: 485 
    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: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Apr  4 16:11:50 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7776981 104616 1 0.0000 0.0000
DOC_LIST 2255924 103878 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 238458 616 59600.0000 0.0000
INVNT_TURNOVER_LOG 139538 109273 1 0.0000 0.0000
MONEY_SALDO 49 17257 940 35200.0000 0.0000
MONEY_TURNOVER_LOG 2928 2230 1 0.0000 0.0000
PDISTR 827241 81822 5 0.0000 0.0000
PERF_SPLIT_0 170169 3352 1 0.0000 0.0000
PERF_SPLIT_1 204782 33341 1 0.0000 0.0000
PERF_SPLIT_2 169379 1236 1 0.0000 0.0000
PERF_SPLIT_3 193811 19640 1 0.0000 0.0000
PERF_SPLIT_4 155624 14491 1 0.0000 0.0000
PERF_SPLIT_5 182324 1025 1 0.0000 0.0000
PERF_SPLIT_6 172351 2103 1 0.0000 0.0000
PERF_SPLIT_7 178709 1088 1 0.0000 0.0000
PERF_SPLIT_8 165369 1110 1 0.0000 0.0000
PERF_SPLIT_9 197733 25420 1 0.0000 0.0000
PSTORNED 2104448 46958 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 157651 75868 1 0.0000 0.0000
XQD_1000_3300 7293467 526035 1 0.0000 0.0000
XQD_1200_2000 12124260 384256 1 0.0000 0.0000
XQD_2000_3300 1735485 728653 1 0.0000 0.0000
XQD_2100_3300 1308372 602079 1 0.0000 0.0000
XQD_3300_3400 9334011 607054 1 0.0000 0.0000
XQS_1000_1200 21177914 13862 1 0.0000 0.0000
XQS_1000_3300 9743052 566986 1 0.0000 0.0000
XQS_1200_2000 11410010 406786 1 0.0000 0.0000
XQS_2100_3300 9898526 608427 1 0.0000 0.0000
XQS_3300_3400 574586 11444 1 0.0000 0.0000

Record versions statistics, chart

Total records and versions, chart

Ratios versions / total_records and max_versions / total_versions

Database validation 


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

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

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

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

04.04.24 16:12:02. There are 3 logs in /var/tmp/logs-oltp30 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-04 16:12:04 No severe PSQL-related problems occured
04.04.24 16:12:05. End of report.