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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-23 04:07:47
DTS_END                         2024-02-23 04:07:47.4540
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/43776
TRN_ID                          174559
ATT_ID                          577
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: 9249.90 17803 924990
customer order: creation 184.86 420 18486
customer order: refuse 16.11 360 1611
order to supplier: creation 48.74 1268 4874
order to supplier: removal 3.55 93647 355
invoice (draft): creation 49.17 2917 4917
invoice (draft): removal 49.65 787 4965
invoice accept: apply 44.89 19750 4489
invoice accept: cancel 43.72 875 4372
customer reserve: creation 4240.29 193 424029
customer reserve: removal 4259.66 63 425966
realization accept: apply 90.52 210 9052
realization accept: cancel 80.22 132 8022
payment from customer: creation 64.64 99 6464
payment from customer: removal 6.24 77 624
payment to supplier: creation 52.03 139 5203
payment to supplier: removal 3.86 73 386
service: total inventory turnovers 3.76 3982 376
service: total monetary turnovers 7.02 523 702
service: aggregate perf. data 0.94 16846 94
service: refresh index statistics 0.03 213705 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-02-2024 04:08:45 to 23-02-2024 04:08:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3433
TEST_TIME 2 3142
TEST_TIME 3 4101
TEST_TIME 4 4549
TEST_TIME 5 4345
TEST_TIME 6 4354
TEST_TIME 7 4494
TEST_TIME 8 4549
TEST_TIME 9 5276
TEST_TIME 10 5279
TEST_TIME 11 6035
TEST_TIME 12 6343
TEST_TIME 13 6830
TEST_TIME 14 7041
TEST_TIME 15 7300
TEST_TIME 16 7326
TEST_TIME 17 7308
TEST_TIME 18 7415
TEST_TIME 19 7596
TEST_TIME 20 7733
TEST_TIME 21 7791
TEST_TIME 22 7767
TEST_TIME 23 8690
TEST_TIME 24 8576
TEST_TIME 25 8722
TEST_TIME 26 9789
TEST_TIME 27 9894
TEST_TIME 28 9983
TEST_TIME 29 9812
TEST_TIME 30 9732
TEST_TIME 31 9772
TEST_TIME 32 9870
TEST_TIME 33 9840
TEST_TIME 34 9941
TEST_TIME 35 9813
TEST_TIME 36 9776
TEST_TIME 37 9996
TEST_TIME 38 9996
TEST_TIME 39 9752
TEST_TIME 40 9703
TEST_TIME 41 9681
TEST_TIME 42 9551
TEST_TIME 43 9608
TEST_TIME 44 9508
TEST_TIME 45 9676
TEST_TIME 46 9648
TEST_TIME 47 9571
TEST_TIME 48 9508
TEST_TIME 49 9515
TEST_TIME 50 9498
TEST_TIME 51 9504
TEST_TIME 52 9497
TEST_TIME 53 9446
TEST_TIME 54 9341
TEST_TIME 55 9274
TEST_TIME 56 9254
TEST_TIME 57 9226
TEST_TIME 58 9262
TEST_TIME 59 9303
TEST_TIME 60 9316
TEST_TIME 61 9422
TEST_TIME 62 9373
TEST_TIME 63 9442
TEST_TIME 64 9481
TEST_TIME 65 9572
TEST_TIME 66 9570
TEST_TIME 67 9628
TEST_TIME 68 9640
TEST_TIME 69 9526
TEST_TIME 70 9434
TEST_TIME 71 9418
TEST_TIME 72 9408
TEST_TIME 73 9332
TEST_TIME 74 9300
TEST_TIME 75 9258
TEST_TIME 76 9323
TEST_TIME 77 9293
TEST_TIME 78 9301
TEST_TIME 79 9321
TEST_TIME 80 9341
TEST_TIME 81 9346
TEST_TIME 82 9353
TEST_TIME 83 9355
TEST_TIME 84 9344
TEST_TIME 85 9388
TEST_TIME 86 9408
TEST_TIME 87 9427
TEST_TIME 88 9427
TEST_TIME 89 9331
TEST_TIME 90 9285
TEST_TIME 91 9297
TEST_TIME 92 9238
TEST_TIME 93 9176
TEST_TIME 94 9168
TEST_TIME 95 9160
TEST_TIME 96 9216
TEST_TIME 97 9265
TEST_TIME 98 9264
TEST_TIME 99 9246
TEST_TIME 100 9256

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-02-2024 04:08:48 to 23-02-2024 04:08:52.

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 1312908 1312908 0 0.00 0 18430 7 0 0
doc_list_biud 1312906 1312906 0 0.00 0 33560 26 0 0
sp_add_invoice_to_stock 4616 4489 127 2.75 21 243905 19750 0 127
sp_cancel_adding_invoice 4372 4372 0 0.00 4 61254 876 0 0
sp_cancel_client_order 1611 1611 0 0.00 4 7974 360 0 0
sp_cancel_customer_reserve 425966 425966 0 0.00 0 31603 63 0 0
sp_cancel_pay_from_customer 624 624 0 0.00 2 5087 77 0 0
sp_cancel_pay_to_supplier 386 386 0 0.00 2 7048 74 0 0
sp_cancel_supplier_invoice 4977 4965 12 0.24 2 26185 788 0 12
sp_cancel_supplier_order 355 355 0 0.00 4 1006307 93648 0 0
sp_cancel_write_off 8022 8022 0 0.00 1 10840 132 0 0
sp_client_order 18486 18486 0 0.00 3 37697 421 0 0
sp_customer_reserve 424029 424029 0 0.00 0 171285 193 0 0
sp_fill_shopping_cart 28256 28256 0 0.00 1 16687 37 0 0
sp_fill_shopping_cart_clo_res 424022 424022 0 0.00 0 18375 18 0 0
sp_get_clo_for_invoice 4482 4482 0 0.00 0 23299 387 0 0
sp_kill_cost_storno 13404 13404 0 0.00 0 6039 65 0 0
sp_kill_qstorno_ret_qs2qd 865274 865274 0 0.00 0 31576 34 0 0
sp_kill_qty_storno 458823 458823 0 0.00 0 33560 73 0 0
sp_lock_selected_doc 18840 18840 0 0.00 0 7974 5 0 0
sp_make_cost_storno 25201 25201 0 0.00 0 12819 64 0 0
sp_multiply_rows_for_pdistr 25199 25199 0 0.00 0 5883 31 0 0
sp_multiply_rows_for_qdistr 18486 18486 0 0.00 0 16299 246 0 0
sp_pay_from_customer 6464 6464 0 0.00 4 13555 100 0 0
sp_pay_to_supplier 5203 5203 0 0.00 4 12584 140 0 0
sp_payment_common 11667 11667 0 0.00 1 6499 17 0 0
sp_qd_handle_on_cancel_clo 1611 1611 0 0.00 0 7642 323 0 0
sp_qd_handle_on_invoice_upd_sts 8853 8853 0 0.00 0 33560 295 0 0
sp_qd_handle_on_reserve_upd_sts 9051 9051 0 0.00 0 21448 70 0 0
sp_reserve_write_off 9052 9052 0 0.00 6 21740 210 0 0
sp_supplier_invoice 4917 4917 0 0.00 5 92347 2917 0 0
sp_supplier_order 4874 4874 0 0.00 4 24295 1268 0 0
srv_aggregate_perf_data 95 94 1 1.05 1628 166936 16847 0 1
srv_fill_mon_cache_memory 55 55 0 0.00 1071 200882 41895 0 0
srv_find_qd_qs_mism 879535 879535 0 0.00 0 18430 7 0 0
srv_make_invnt_saldo 376 376 0 0.00 45 103096 3983 0 0
srv_make_money_saldo 702 702 0 0.00 1 15177 523 0 0
srv_recalc_idx_stat 3 3 0 0.00 151627 253101 213705 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 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-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4489 4489 0 0.00 0 7526 162 0 0
t$perf-norm:sp_cancel_adding_invoice 389 389 0 0.00 0 2016 81 0 0
t$perf-norm:sp_cancel_client_order 1611 1611 0 0.00 0 2732 15 0 0
t$perf-norm:sp_cancel_customer_reserve 622 622 0 0.00 0 2776 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 624 624 0 0.00 0 4924 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 386 386 0 0.00 0 342 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 365 365 0 0.00 0 2616 25 0 0
t$perf-norm:sp_cancel_supplier_order 355 355 0 0.00 0 22217 1625 0 0
t$perf-norm:sp_cancel_write_off 958 958 0 0.00 0 1010 5 0 0
t$perf-norm:sp_client_order 18486 18486 0 0.00 0 10621 16 0 0
t$perf-norm:sp_customer_reserve 886 886 0 0.00 0 5031 17 0 0
t$perf-norm:sp_pay_from_customer 6464 6464 0 0.00 0 23461 12 0 0
t$perf-norm:sp_pay_to_supplier 5203 5203 0 0.00 0 7607 10 0 0
t$perf-norm:sp_reserve_write_off 9052 9052 0 0.00 0 5351 12 0 0
t$perf-norm:sp_supplier_invoice 4917 4917 0 0.00 0 5561 19 0 0
t$perf-norm:sp_supplier_order 4874 4874 0 0.00 0 6534 15 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 834 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 248 6 0 0
t$perf-norm:srv_make_invnt_saldo 376 376 0 0.00 0 469 10 0 0
t$perf-norm:srv_make_money_saldo 702 702 0 0.00 0 939 8 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 9212 8958 254 2.75 0 11250 18 0 254
v_all_customers 34310 34310 0 0.00 0 20 1 0 0
v_all_suppliers 27666 27666 0 0.00 0 19 1 0 0
v_all_wares 36972 36972 0 0.00 0 111 1 0 0
v_cancel_adding_invoice 778 778 0 0.00 0 2216 10 0 0
v_cancel_client_order 3222 3222 0 0.00 0 7769 10 0 0
v_cancel_customer_prepayment 1248 1248 0 0.00 0 1948 8 0 0
v_cancel_customer_reserve 1244 1244 0 0.00 0 2537 7 0 0
v_cancel_payment_to_supplier 772 772 0 0.00 0 3702 8 0 0
v_cancel_supplier_invoice 754 730 24 3.18 0 5309 31 0 24
v_cancel_supplier_order 710 710 0 0.00 0 670 4 0 0
v_cancel_write_off 1916 1916 0 0.00 0 1908 13 0 0
v_max_id_clo_ord 4867 4867 0 0.00 0 2638 3 0 0
v_max_id_clo_res 886 886 0 0.00 0 934 7 0 0
v_max_id_ord_sup 4901 4901 0 0.00 0 1925 3 0 0
v_max_non_paid_invoice 1138 1138 0 0.00 0 71 2 0 0
v_max_non_paid_realizn 3152 3152 0 0.00 0 1917 3 0 0
v_min_id_clo_ord 4867 4867 0 0.00 0 6619 16 0 0
v_min_id_clo_res 886 886 0 0.00 0 11219 27 0 0
v_min_id_ord_sup 4901 4901 0 0.00 0 8629 8 0 0
v_min_non_paid_invoice 5203 5203 0 0.00 0 4953 12 0 0
v_min_non_paid_realizn 6464 6464 0 0.00 0 4066 12 0 0
v_our_firm 9286 9286 0 0.00 0 20 1 0 0
v_reserve_write_off 18102 18102 0 0.00 0 14075 11 0 0
x_lock_depdocs_on_canc_invoice 8972 8972 0 0.00 0 22842 136 0 0
x_lock_depdocs_on_canc_sup_ord 355 355 0 0.00 0 12027 348 0 0
x_make_qstorno_1000_1200 4874 4874 0 0.00 1 22841 1180 0 0
x_make_qstorno_1200_2000 4917 4917 0 0.00 2 92307 2794 0 0
x_make_qstorno_2100_3300 424029 424029 0 0.00 0 171283 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-02-2024 04:08:53 to 23-02-2024 04:08:57.

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
02:07:51 970 8192000000 8959646880 9024540672 18255696 0.222 5 3 6 0 18947056 154400 536960
02:08:53 15694 8192000000 9703525296 9994878976 782687152 8.721 100 85 170 0 811150176 7489760 20973264
02:10:12 30193 8192000000 9758418080 10061819904 827694816 9.176 100 91 182 0 860807648 11081808 22031024
02:11:55 23229 8192000000 9786724560 10102362112 853697696 9.437 100 86 172 0 892288240 18415680 20174864
02:13:25 11641 8192000000 9833688176 10160062464 886619520 9.766 100 79 158 0 941707040 37434992 17652528
02:14:39 8530 8192000000 9906270864 10246483968 938260416 10.276 100 79 158 0 1016037888 61297216 16480256
02:15:50 2961 8192000000 9946890240 10297991168 980186336 10.686 100 79 158 1 1057622128 61282384 16153408
02:16:54 2836 8192000000 9978142016 10338856960 1012716720 11.002 100 69 136 0 1091289264 64896464 13676080
02:17:59 1846 8192000000 10013432752 10380460032 1035598240 11.222 100 83 166 0 1125961760 74069808 16293712
02:19:02 1360 8192000000 10038831088 10409799680 1053689568 11.396 100 91 183 1 1149960176 78212768 18057840
02:20:05 2577 8192000000 10032293824 10407591936 1060983136 11.466 100 81 159 1 1138405616 60657584 16764896
02:21:08 30258 8192000000 9995563440 10379075584 1066694768 11.521 100 43 87 0 1102932880 26441120 9796992
02:22:39 6021 8192000000 9989142480 10391150592 1075339296 11.603 100 30 60 0 1111961056 30906928 5714832
02:23:48 5615 8192000000 10012300192 10404712448 1080845136 11.656 100 39 76 0 1110715440 21400528 8469776
02:24:55 3399 8192000000 10008578256 10409684992 1087893728 11.723 100 42 79 1 1122069584 25589152 8586704
02:26:02 41943 8192000000 10004987424 10414325760 1089997952 11.743 100 43 84 0 1117510912 18805184 8707776
02:27:50 6606 8192000000 9999824672 10404233216 1090173440 11.744 100 25 51 0 1112081232 16505888 5401904
02:29:05 59677 8192000000 10077026480 10487984128 1093682800 11.778 99 42 84 0 1170439040 67831408 8924832
02:31:09 10216 8192000000 10077370272 10487746560 1124472048 12.069 100 46 92 0 1194776896 60226640 10078208
02:32:28 66314 8192000000 10128173248 10548625408 1123827728 12.063 99 38 76 0 1232042400 99853968 8360704
02:34:45 34808 8192000000 10163736208 10569900032 1123728944 12.062 99 39 78 0 1257179344 124839376 8611024
02:36:25 13337 8192000000 10164227376 10571010048 1089218080 11.735 97 45 86 0 1249098544 150218256 9662208
02:37:52 11488 8192000000 10135935808 10562981888 1105440608 11.889 100 53 107 1 1247459184 130824272 11194304
02:39:06 8992 8192000000 10132585088 10531872768 1094330416 11.784 99 67 131 1 1239145600 130540384 14274800
02:40:28 1743 8192000000 10110697376 10512408576 1073379760 11.584 99 85 170 0 1207285392 114742848 19162784
02:41:34 3387 8192000000 10130421920 10518650880 1079526224 11.643 99 71 141 1 1227524000 133552608 14445168
02:42:41 1069 8192000000 10167541296 10549092352 1091616720 11.758 99 92 182 2 1264249824 153638352 18994752
02:43:47 3722 8192000000 10209911664 10599424000 1113616144 11.967 100 86 169 0 1309852880 176256832 19979904
02:44:54 3728 8192000000 10276265344 10670354432 1125196240 12.076 100 81 162 1 1371015840 228102192 17717408
02:46:05 1932 8192000000 10324965264 10716786688 1140156608 12.217 100 81 159 0 1419933936 262124592 17652736
02:47:09 2245 8192000000 10366291712 10765524992 1143085728 12.245 99 74 148 0 1458568944 298606432 16876784
02:48:21 2641 8192000000 10368725232 10786308096 1140537424 12.221 99 66 130 0 1466027280 309777648 15712208
02:49:27 5429 8192000000 10409232688 10829144064 1144340784 12.256 100 46 91 0 1516698016 360957792 11399440
02:50:47 20363 8192000000 10335525344 10793857024 1131315632 12.134 99 25 50 0 1450574864 312565184 6694048
02:52:11 24909 8192000000 10310197040 10806874112 1123274928 12.058 100 23 46 1 1409818464 280492976 6050560
02:53:53 30749 8192000000 10100105664 10535608320 1122697040 12.052 100 16 32 0 1187201776 61354400 3150336
02:55:25 91887 8192000000 10051301440 10485628928 1114650176 11.976 99 27 52 1 1150959152 30748240 5560736
02:57:59 26150 8192000000 10117740096 10591072256 1135157408 12.170 100 13 26 0 1212280016 74025984 3096624
02:59:53 90048 8192000000 10098161936 10551029760 1141190832 12.227 100 20 38 0 1186343904 41355744 3797328
03:02:25 29369 8192000000 10091139568 10514636800 1146558480 12.277 100 30 58 0 1181850832 29128240 6164112
03:03:58 105145 8192000000 10079822896 10586849280 1128243056 12.105 98 6 13 0 1207673392 77844960 1585376
03:07:27 34950 8192000000 10113284464 10539220992 1152854400 12.336 99 47 92 1 1191516784 29031936 9630448
03:09:06 32967 8192000000 10111585408 10575073280 1168422096 12.482 100 12 24 0 1218375008 47806816 2146096
03:10:41 29635 8192000000 10117520352 10556366848 1129280144 12.115 97 31 60 0 1204907744 69978272 5649328
03:12:16 17411 8192000000 10112434320 10590158848 1132979536 12.149 98 28 54 0 1229353280 90935680 5438064
03:13:44 200882 8192000000 10116965152 10595672064 1114903360 11.979 96 12 24 0 1168175616 50829888 2442368
03:18:32 71200 8192000000 10055664352 10548002816 1126564784 12.089 99 12 24 0 1165525520 36650368 2310368
03:20:43 63521 8192000000 10053793168 10517696512 1132381920 12.144 99 14 28 0 1161199744 25962944 2854880
03:23:03 58207 8192000000 10041256880 10481487872 1073874160 11.589 95 15 30 0 1097551792 20791776 2885856
03:25:02 71227 8192000000 10086540944 10540138496 1093389424 11.775 97 20 40 0 1138199632 41008288 3801920
03:27:14 49238 8192000000 10111416048 10568343552 1098666576 11.825 98 34 68 0 1192607216 86516928 7423712
03:29:04 15709 8192000000 10046399424 10464878592 1106746736 11.902 100 29 58 0 1139195744 26669168 5779840
03:30:22 24581 8192000000 10062150496 10501058560 1086096016 11.706 98 33 67 0 1146296384 53704192 6496176
03:31:50 48085 8192000000 10053739120 10557480960 1093210224 11.773 99 28 54 0 1174758032 76275168 5272640
03:33:48 51467 8192000000 10048666160 10530660352 1065801824 11.512 96 7 14 0 1125960768 58757952 1400992
03:35:43 100989 8192000000 10032091200 10467667968 1092507344 11.766 98 33 66 2 1127229744 27286880 7435520
03:38:56 19453 8192000000 10058322592 10512449536 1123146640 12.057 100 25 50 0 1175144928 47518672 4479616
03:40:16 39334 8192000000 10077808464 10551476224 1124039136 12.065 99 8 16 0 1181824272 56288448 1496688
03:41:56 51403 8192000000 10108609744 10556657664 1145549712 12.268 100 16 32 0 1215522320 66736448 3236160
03:43:50 53721 8192000000 10107754240 10538414080 1115924128 11.988 98 21 42 0 1160092576 39854736 4313712
03:46:29 58985 8192000000 10076636288 10512670720 1121908160 12.045 99 20 40 0 1174019632 48122832 3988640
03:49:08 68241 8192000000 10077263680 10517106688 1120099408 12.028 98 21 42 0 1184702384 60311136 4291840
03:51:22 12938 8192000000 10080834016 10516795392 1115813152 11.987 98 41 82 1 1157050224 33178736 8058336
03:52:39 55102 8192000000 10116122960 10593112064 1133769216 12.157 99 32 64 1 1205328000 65434080 6124704
03:54:41 16655 8192000000 10114920064 10566045696 1139068800 12.207 100 34 68 0 1209455664 63630544 6756320
03:55:59 128754 8192000000 10100551232 10550939648 1145499696 12.267 100 20 40 0 1170451904 21270912 3681296
03:59:11 52311 8192000000 10068284512 10532687872 1109612624 11.929 97 12 24 0 1159264432 46888368 2763440
04:01:03 83430 8192000000 10130315840 10598002688 1109894496 11.931 97 19 38 0 1217042288 102802032 4345760
04:03:32 59082 8192000000 10029281456 10499452928 1060448352 11.461 94 9 18 0 1117928320 55682800 1797168
04:05:34 50088 8192000000 10072343824 10513788928 1097763616 11.816 98 24 48 0 1166006560 63263152 4979792
04:07:26 28668 8192000000 9059882032 9304473600 209780400 2.496 19 7 14 0 239593968 28097744 1715824

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 23-02-2024 04:08:59 to 23-02-2024 04:09:12.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 127 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 23-02-2024 04:09:13 to 23-02-2024 04:09:15.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Fri Feb 23 04:09:17 2024 
 
Database header page information: 
    Flags            0 
    Generation        92772 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    177530 
    Oldest active        177531 
    Oldest snapshot        177531 
    Next transaction    177532 
    Sequence number        0 
    Next attachment ID    704 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.43, total records: 7791705 
    Average version length: 48.17, total versions: 93874, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 89136 
    Data pages: 89136, average fill: 70% 
    Primary pages: 89135, secondary pages: 1, swept pages: 32947 
    Empty pages: 2, full pages: 77010 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 38 
    40 - 59% = 1349 
    60 - 79% = 87699 
    80 - 99% = 40 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23304, nodes: 7791705 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1703010, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 318 
        20 - 39% = 1562 
        40 - 59% = 4370 
        60 - 79% = 2359 
        80 - 99% = 14695 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13548, nodes: 7791705 
    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: 1526807, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1449 
        40 - 59% = 2190 
        60 - 79% = 1075 
        80 - 99% = 8834 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8366, nodes: 7791705 
    Average node length: 6.63, total dup: 5814652, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1519732, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 845 
        40 - 59% = 1485 
        60 - 79% = 898 
        80 - 99% = 4993 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.44, total records: 2267716 
    Average version length: 58.87, total versions: 47882, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28640 
    Data pages: 28640, average fill: 73% 
    Primary pages: 28638, secondary pages: 2, swept pages: 8339 
    Empty pages: 1, full pages: 24231 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 27 
    40 - 59% = 189 
    60 - 79% = 28318 
    80 - 99% = 101 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4576, nodes: 2267716 
    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: 686567, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 841 
        40 - 59% = 945 
        60 - 79% = 716 
        80 - 99% = 2074 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2444, nodes: 2269433 
    Average node length: 4.97, total dup: 2268534, max dup: 18606 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1275111, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 217 
        40 - 59% = 1400 
        60 - 79% = 577 
        80 - 99% = 248 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1783, nodes: 2267716 
    Average node length: 4.97, total dup: 2267666, max dup: 130359 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1071117, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 638 
        60 - 79% = 37 
        80 - 99% = 1098 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4358, nodes: 2267716 
    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: 686567, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 511 
        40 - 59% = 702 
        60 - 79% = 807 
        80 - 99% = 2242 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.23, total records: 400 
    Average version length: 28.32, total versions: 2658, max versions: 7 
    Average fragment length: 2.00, total fragments: 9, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 62% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 7, full pages: 19 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 19 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 14.88, total records: 71600 
    Average version length: 68.28, total versions: 64506, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.92 
    Pointer pages: 7, data page slots: 2904 
    Data pages: 2168, average fill: 45% 
    Primary pages: 2167, secondary pages: 1, swept pages: 0 
    Empty pages: 501, full pages: 670 
    Fill distribution: 
     0 - 19% = 687 
    20 - 39% = 333 
    40 - 59% = 284 
    60 - 79% = 336 
    80 - 99% = 528 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1773059, depth: 3, leaf buckets: 349, nodes: 71600 
    Average node length: 13.30, total dup: 4464, max dup: 2 
    Average key length: 10.77, compression ratio: 2.51 
    Average prefix length: 19.16, average data length: 7.84 
    Clustering factor: 52163, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 293 
        40 - 59% = 50 
        60 - 79% = 6 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 239, max versions: 8 
    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: 3 
    Data pages: 3, average fill: 32% 
    Primary pages: 1, secondary pages: 2, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.82, total records: 1424 
    Average version length: 43.39, total versions: 1271, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.52 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 49% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 7 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92179, depth: 2, leaf buckets: 3, nodes: 1424 
    Average node length: 4.43, total dup: 1326, max dup: 138 
    Average key length: 2.74, compression ratio: 6.93 
    Average prefix length: 18.33, average data length: 0.67 
    Clustering factor: 828, ratio: 0.58 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.75, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.78, total records: 820563 
    Average version length: 37.89, total versions: 39652, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8440 
    Data pages: 8440, average fill: 67% 
    Primary pages: 8439, secondary pages: 1, swept pages: 1103 
    Empty pages: 17, full pages: 7952 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 31 
    40 - 59% = 97 
    60 - 79% = 8159 
    80 - 99% = 108 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 870, nodes: 800076 
    Average node length: 4.88, total dup: 800027, max dup: 150303 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92046, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 143 
        40 - 59% = 454 
        60 - 79% = 174 
        80 - 99% = 98 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 949, nodes: 800076 
    Average node length: 5.89, total dup: 712388, max dup: 46 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162369, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 53 
        40 - 59% = 528 
        60 - 79% = 83 
        80 - 99% = 285 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 996, nodes: 800076 
    Average node length: 5.89, total dup: 712388, max dup: 46 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164290, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 109 
        40 - 59% = 556 
        60 - 79% = 75 
        80 - 99% = 256 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1139, nodes: 800076 
    Average node length: 5.97, total dup: 712388, max dup: 46 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157141, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 280 
        40 - 59% = 552 
        60 - 79% = 206 
        80 - 99% = 99 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5487 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.88, total fragments: 32, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 58% 
    Primary pages: 82, secondary pages: 12, swept pages: 57 
    Empty pages: 10, full pages: 59 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5487 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.47, average data length: 1.55 
    Clustering factor: 5178, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5487 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 161, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.07, total records: 80794 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 840 
    Data pages: 840, average fill: 66% 
    Primary pages: 840, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 839 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 839 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37442, depth: 2, leaf buckets: 103, nodes: 80794 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 2961, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.15, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 141.85, total records: 174967 
    Average version length: 153.81, total versions: 11236, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.96 
    Pointer pages: 7, data page slots: 4968 
    Data pages: 4352, average fill: 84% 
    Primary pages: 4349, secondary pages: 3, swept pages: 1 
    Empty pages: 48, full pages: 4292 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4292 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 144.04, total records: 150828 
    Average version length: 152.72, total versions: 7268, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 6, data page slots: 4864 
    Data pages: 3736, average fill: 84% 
    Primary pages: 3733, secondary pages: 3, swept pages: 3 
    Empty pages: 23, full pages: 3695 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3695 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 141.53, total records: 147103 
    Average version length: 154.26, total versions: 10020, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.98 
    Pointer pages: 8, data page slots: 4800 
    Data pages: 3656, average fill: 84% 
    Primary pages: 3653, secondary pages: 3, swept pages: 3 
    Empty pages: 28, full pages: 3610 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 3608 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 144.55, total records: 131785 
    Average version length: 152.33, total versions: 5988, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 6, data page slots: 3976 
    Data pages: 3264, average fill: 84% 
    Primary pages: 3261, secondary pages: 3, swept pages: 1 
    Empty pages: 24, full pages: 3232 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3232 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 141.67, total records: 166651 
    Average version length: 152.58, total versions: 10999, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 7, data page slots: 4704 
    Data pages: 4120, average fill: 84% 
    Primary pages: 4116, secondary pages: 4, swept pages: 4 
    Empty pages: 19, full pages: 4087 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 4088 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 145.56, total records: 153775 
    Average version length: 152.29, total versions: 5921, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 7, data page slots: 4184 
    Data pages: 3808, average fill: 84% 
    Primary pages: 3806, secondary pages: 2, swept pages: 8 
    Empty pages: 23, full pages: 3768 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3768 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 142.46, total records: 176244 
    Average version length: 153.95, total versions: 10885, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 7, data page slots: 6288 
    Data pages: 4384, average fill: 84% 
    Primary pages: 4381, secondary pages: 3, swept pages: 4 
    Empty pages: 42, full pages: 4330 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4330 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 145.27, total records: 148967 
    Average version length: 151.24, total versions: 5861, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 7, data page slots: 6648 
    Data pages: 3736, average fill: 82% 
    Primary pages: 3734, secondary pages: 2, swept pages: 1 
    Empty pages: 67, full pages: 3643 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 7 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 3643 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 130.62, total records: 189242 
    Average version length: 154.62, total versions: 27637, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.98 
    Pointer pages: 6, data page slots: 5320 
    Data pages: 4688, average fill: 85% 
    Primary pages: 4687, secondary pages: 1, swept pages: 3 
    Empty pages: 19, full pages: 4661 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 0 
    80 - 99% = 4661 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 148.32, total records: 153702 
    Average version length: 149.47, total versions: 2900, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 4504 
    Data pages: 3784, average fill: 84% 
    Primary pages: 3781, secondary pages: 3, swept pages: 2 
    Empty pages: 8, full pages: 3767 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3766 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.87, total records: 2115243 
    Average version length: 52.90, total versions: 42258, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25800 
    Data pages: 25800, average fill: 71% 
    Primary pages: 25785, secondary pages: 15, swept pages: 10339 
    Empty pages: 113, full pages: 22977 
    Fill distribution: 
     0 - 19% = 212 
    20 - 39% = 236 
    40 - 59% = 702 
    60 - 79% = 24221 
    80 - 99% = 429 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2592, nodes: 2115243 
    Average node length: 5.44, total dup: 1974071, max dup: 1570 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183053, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 295 
        40 - 59% = 1685 
        60 - 79% = 307 
        80 - 99% = 302 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2115243 
    Average node length: 5.69, total dup: 1899044, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 378098, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2392 
        60 - 79% = 343 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2132, nodes: 2115243 
    Average node length: 4.96, total dup: 2115143, max dup: 28052 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 180806, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 160 
        40 - 59% = 1147 
        60 - 79% = 406 
        80 - 99% = 418 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 38.89, total records: 163663 
    Average version length: 69.18, total versions: 82445, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 3, data page slots: 4304 
    Data pages: 3032, average fill: 66% 
    Primary pages: 3032, secondary pages: 0, swept pages: 211 
    Empty pages: 309, full pages: 2192 
    Fill distribution: 
     0 - 19% = 434 
    20 - 39% = 147 
    40 - 59% = 152 
    60 - 79% = 877 
    80 - 99% = 1422 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554362, depth: 3, leaf buckets: 244, nodes: 163663 
    Average node length: 6.48, total dup: 142514, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27999, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 32 
        40 - 59% = 129 
        60 - 79% = 68 
        80 - 99% = 13 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.78, total records: 7059657 
    Average version length: 68.80, total versions: 491979, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 66, data page slots: 106736 
    Data pages: 106736, average fill: 71% 
    Primary pages: 106735, secondary pages: 1, swept pages: 13298 
    Empty pages: 281, full pages: 85320 
    Fill distribution: 
     0 - 19% = 1488 
    20 - 39% = 2238 
    40 - 59% = 5284 
    60 - 79% = 95849 
    80 - 99% = 1877 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10694, nodes: 7059657 
    Average node length: 6.50, total dup: 6111098, max dup: 29 
    Average key length: 3.51, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1679250, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1800 
        40 - 59% = 5712 
        60 - 79% = 2572 
        80 - 99% = 604 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8495, nodes: 7059657 
    Average node length: 5.39, total dup: 6780544, max dup: 201 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1474085, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1113 
        40 - 59% = 4810 
        60 - 79% = 1597 
        80 - 99% = 969 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8533, nodes: 7059657 
    Average node length: 5.39, total dup: 6780544, max dup: 201 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1476440, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1141 
        40 - 59% = 4776 
        60 - 79% = 1631 
        80 - 99% = 978 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.10, total records: 12052393 
    Average version length: 68.73, total versions: 369619, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 107, data page slots: 173712 
    Data pages: 173712, average fill: 74% 
    Primary pages: 173711, secondary pages: 1, swept pages: 54653 
    Empty pages: 6, full pages: 160852 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 436 
    40 - 59% = 3600 
    60 - 79% = 167188 
    80 - 99% = 2460 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18479, nodes: 12049411 
    Average node length: 6.60, total dup: 10507567, max dup: 75 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2485448, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 2498 
        40 - 59% = 10690 
        60 - 79% = 4473 
        80 - 99% = 790 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 43.30, total records: 1671204 
    Average version length: 69.10, total versions: 426476, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.91 
    Pointer pages: 30, data page slots: 46024 
    Data pages: 27552, average fill: 62% 
    Primary pages: 27475, secondary pages: 77, swept pages: 4215 
    Empty pages: 1565, full pages: 21161 
    Fill distribution: 
     0 - 19% = 2762 
    20 - 39% = 3789 
    40 - 59% = 2516 
    60 - 79% = 12453 
    80 - 99% = 6032 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1817, nodes: 1379353 
    Average node length: 5.51, total dup: 1323726, max dup: 74 
    Average key length: 2.56, compression ratio: 16.38 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 97170, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 390 
        40 - 59% = 857 
        60 - 79% = 455 
        80 - 99% = 99 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 36.59, total records: 1345593 
    Average version length: 69.02, total versions: 170212, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.44 
    Pointer pages: 22, data page slots: 35096 
    Data pages: 27984, average fill: 39% 
    Primary pages: 27983, secondary pages: 1, swept pages: 6304 
    Empty pages: 6458, full pages: 14424 
    Fill distribution: 
     0 - 19% = 9597 
    20 - 39% = 2744 
    40 - 59% = 6378 
    60 - 79% = 8808 
    80 - 99% = 457 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1146, nodes: 788684 
    Average node length: 5.90, total dup: 729264, max dup: 65 
    Average key length: 2.96, compression ratio: 14.18 
    Average prefix length: 41.11, average data length: 0.89 
    Clustering factor: 113102, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 275 
        40 - 59% = 578 
        60 - 79% = 268 
        80 - 99% = 24 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.77, total records: 9389780 
    Average version length: 69.00, total versions: 482901, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 90, data page slots: 146512 
    Data pages: 146496, average fill: 69% 
    Primary pages: 146477, secondary pages: 19, swept pages: 41000 
    Empty pages: 471, full pages: 93599 
    Fill distribution: 
     0 - 19% = 1460 
    20 - 39% = 5349 
    40 - 59% = 17945 
    60 - 79% = 118114 
    80 - 99% = 3628 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13480, nodes: 9383222 
    Average node length: 6.69, total dup: 7786785, max dup: 14 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2097117, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1103 
        40 - 59% = 6622 
        60 - 79% = 4879 
        80 - 99% = 875 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21158911 
    Average version length: 82.94, total versions: 15958, 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: 319784 
    Data pages: 319784, average fill: 81% 
    Primary pages: 319778, secondary pages: 6, swept pages: 11990 
    Empty pages: 7, full pages: 319772 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 48991 
    80 - 99% = 270781 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19369, nodes: 21158911 
    Average node length: 5.72, total dup: 20677742, max dup: 132 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285546, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8104 
        60 - 79% = 525 
        80 - 99% = 10733 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17187, nodes: 21158911 
    Average node length: 6.31, total dup: 18594568, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917425, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 6 
        40 - 59% = 789 
        60 - 79% = 283 
        80 - 99% = 16107 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21126, nodes: 21158911 
    Average node length: 6.35, total dup: 18513529, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579406, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8293 
        60 - 79% = 615 
        80 - 99% = 12210 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16231, nodes: 21158911 
    Average node length: 5.56, total dup: 21158811, max dup: 227895 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946308, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 3152 
        60 - 79% = 377 
        80 - 99% = 12694 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.11, total records: 9796057 
    Average version length: 82.62, total versions: 440722, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 107, data page slots: 174272 
    Data pages: 174256, average fill: 70% 
    Primary pages: 174222, secondary pages: 34, swept pages: 66066 
    Empty pages: 616, full pages: 105815 
    Fill distribution: 
     0 - 19% = 1881 
    20 - 39% = 7508 
    40 - 59% = 25443 
    60 - 79% = 116371 
    80 - 99% = 23053 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11363, nodes: 9796057 
    Average node length: 5.37, total dup: 9488025, max dup: 212 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2204635, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 47 
        40 - 59% = 7919 
        60 - 79% = 3281 
        80 - 99% = 113 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13586, nodes: 9796057 
    Average node length: 6.24, total dup: 8124855, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1540199, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 3715 
        40 - 59% = 4636 
        60 - 79% = 2589 
        80 - 99% = 2514 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12686, nodes: 9796057 
    Average node length: 5.99, total dup: 8504947, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2394162, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 62 
        40 - 59% = 8894 
        60 - 79% = 3581 
        80 - 99% = 147 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10212, nodes: 9796057 
    Average node length: 5.15, total dup: 9795957, max dup: 159609 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1582568, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1185 
        40 - 59% = 5218 
        60 - 79% = 1658 
        80 - 99% = 2121 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.02, total records: 11397906 
    Average version length: 82.52, total versions: 354663, max versions: 1 
    Average fragment length: 75.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 120, data page slots: 194736 
    Data pages: 193224, average fill: 73% 
    Primary pages: 193077, secondary pages: 147, swept pages: 62036 
    Empty pages: 2636, full pages: 150136 
    Fill distribution: 
     0 - 19% = 4423 
    20 - 39% = 7010 
    40 - 59% = 16539 
    60 - 79% = 97576 
    80 - 99% = 67676 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13122, nodes: 11397906 
    Average node length: 5.30, total dup: 11288475, max dup: 629 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2391650, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 107 
        40 - 59% = 8887 
        60 - 79% = 3986 
        80 - 99% = 142 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10557, nodes: 11397906 
    Average node length: 5.50, total dup: 10900473, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 738665, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 152 
        20 - 39% = 916 
        40 - 59% = 2604 
        60 - 79% = 1826 
        80 - 99% = 5059 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15007, nodes: 11397906 
    Average node length: 6.02, total dup: 9950546, max dup: 81 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2408159, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 145 
        40 - 59% = 10419 
        60 - 79% = 4271 
        80 - 99% = 171 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10872, nodes: 11397906 
    Average node length: 5.22, total dup: 11397806, max dup: 194139 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 726976, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 820 
        40 - 59% = 4932 
        60 - 79% = 1476 
        80 - 99% = 3553 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 79.37, total records: 9924073 
    Average version length: 82.95, total versions: 452179, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 109, data page slots: 177704 
    Data pages: 177664, average fill: 69% 
    Primary pages: 177636, secondary pages: 28, swept pages: 67969 
    Empty pages: 628, full pages: 105770 
    Fill distribution: 
     0 - 19% = 1974 
    20 - 39% = 7827 
    40 - 59% = 26767 
    60 - 79% = 117644 
    80 - 99% = 23452 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11975, nodes: 9924073 
    Average node length: 5.19, total dup: 9894894, max dup: 1811 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2032516, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1493 
        40 - 59% = 7942 
        60 - 79% = 1886 
        80 - 99% = 624 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13713, nodes: 9924073 
    Average node length: 6.26, total dup: 8230285, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1525247, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 168 
        20 - 39% = 3687 
        40 - 59% = 4588 
        60 - 79% = 2626 
        80 - 99% = 2644 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12526, nodes: 9924073 
    Average node length: 5.44, total dup: 9480881, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2167449, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1326 
        40 - 59% = 8815 
        60 - 79% = 1740 
        80 - 99% = 623 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10357, nodes: 9924073 
    Average node length: 5.16, total dup: 9923973, max dup: 161869 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1621724, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1160 
        40 - 59% = 5330 
        60 - 79% = 1695 
        80 - 99% = 2141 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.38, total records: 579353 
    Average version length: 68.80, total versions: 7780, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 75% 
    Primary pages: 8064, secondary pages: 0, swept pages: 2965 
    Empty pages: 2, full pages: 7406 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 3 
    40 - 59% = 71 
    60 - 79% = 7877 
    80 - 99% = 110 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 47817, depth: 3, leaf buckets: 740, nodes: 579353 
    Average node length: 5.95, total dup: 493424, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101865, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 518 
        60 - 79% = 93 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 37471, depth: 3, leaf buckets: 760, nodes: 579353 
    Average node length: 6.15, total dup: 475195, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101922, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 533 
        60 - 79% = 96 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 564, nodes: 579353 
    Average node length: 4.86, total dup: 579253, max dup: 9350 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 90626, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 22 
        40 - 59% = 334 
        60 - 79% = 69 
        80 - 99% = 138 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Feb 23 04:09:40 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7791705 93874 1 0.0000 0.0000
DOC_LIST 2267716 47882 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2658 7 600.0000 0.0000
INVNT_TURNOVER_LOG 71600 64506 1 0.0000 0.0000
MONEY_SALDO 49 239 8 400.0000 0.0000
MONEY_TURNOVER_LOG 1424 1271 1 0.0000 0.0000
PDISTR 820563 39652 3 0.0000 0.0000
PERF_SPLIT_0 174967 11236 1 0.0000 0.0000
PERF_SPLIT_1 150828 7268 1 0.0000 0.0000
PERF_SPLIT_2 147103 10020 1 0.0000 0.0000
PERF_SPLIT_3 131785 5988 1 0.0000 0.0000
PERF_SPLIT_4 166651 10999 1 0.0000 0.0000
PERF_SPLIT_5 153775 5921 1 0.0000 0.0000
PERF_SPLIT_6 176244 10885 1 0.0000 0.0000
PERF_SPLIT_7 148967 5861 1 0.0000 0.0000
PERF_SPLIT_8 189242 27637 1 0.0000 0.0000
PERF_SPLIT_9 153702 2900 1 0.0000 0.0000
PSTORNED 2115243 42258 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 163663 82445 1 0.0000 0.0000
XQD_1000_3300 7059657 491979 1 0.0000 0.0000
XQD_1200_2000 12052393 369619 1 0.0000 0.0000
XQD_2000_3300 1671204 426476 1 0.0000 0.0000
XQD_2100_3300 1345593 170212 1 0.0000 0.0000
XQD_3300_3400 9389780 482901 1 0.0000 0.0000
XQS_1000_1200 21158911 15958 1 0.0000 0.0000
XQS_1000_3300 9796057 440722 1 0.0000 0.0000
XQS_1200_2000 11397906 354663 1 0.0000 0.0000
XQS_2100_3300 9924073 452179 1 0.0000 0.0000
XQS_3300_3400 579353 7780 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 ---
:169: 
:170: mscs-test-161.budzdorov.ru    Fri Feb 23 04:07:57 2024
:171:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:172: 
:173: 
:174: mscs-test-161.budzdorov.ru    Fri Feb 23 04:07:59 2024
:175:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:176: 
--- end of diff output ---

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

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