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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15740948 kB
MemAvailable 30279644 kB
Buffers 0 kB
Cached 16022712 kB
SwapCached 2472 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-19 13:07:49
DTS_END                         2024-02-19 13:07:49.1990
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/49900
TRN_ID                          170067
ATT_ID                          547
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: 9389.56 20089 938956
customer order: creation 178.89 372 17889
customer order: refuse 14.44 350 1444
order to supplier: creation 46.22 1313 4622
order to supplier: removal 3.63 84943 363
invoice (draft): creation 46.29 3242 4629
invoice (draft): removal 50.11 699 5011
invoice accept: apply 42.86 21038 4286
invoice accept: cancel 45.31 831 4531
customer reserve: creation 4178.33 200 417833
customer reserve: removal 4493.68 55 449368
realization accept: apply 86.07 188 8607
realization accept: cancel 73.58 133 7358
payment from customer: creation 60.02 136 6002
payment from customer: removal 5.86 75 586
payment to supplier: creation 49.16 133 4916
payment to supplier: removal 3.72 84 372
service: total inventory turnovers 4.20 3416 420
service: total monetary turnovers 6.29 519 629
service: aggregate perf. data 0.87 19334 87
service: refresh index statistics 0.03 264709 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-02-2024 13:10:12 to 19-02-2024 13:10:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3241
TEST_TIME 2 5273
TEST_TIME 3 4868
TEST_TIME 4 5679
TEST_TIME 5 5127
TEST_TIME 6 5729
TEST_TIME 7 5426
TEST_TIME 8 5480
TEST_TIME 9 5359
TEST_TIME 10 5747
TEST_TIME 11 6018
TEST_TIME 12 6041
TEST_TIME 13 6325
TEST_TIME 14 6967
TEST_TIME 15 7100
TEST_TIME 16 7119
TEST_TIME 17 7137
TEST_TIME 18 7454
TEST_TIME 19 7589
TEST_TIME 20 7640
TEST_TIME 21 7996
TEST_TIME 22 8478
TEST_TIME 23 8858
TEST_TIME 24 9431
TEST_TIME 25 9958
TEST_TIME 26 9749
TEST_TIME 27 9742
TEST_TIME 28 9521
TEST_TIME 29 9421
TEST_TIME 30 9479
TEST_TIME 31 9940
TEST_TIME 32 9840
TEST_TIME 33 9635
TEST_TIME 34 9434
TEST_TIME 35 9447
TEST_TIME 36 9458
TEST_TIME 37 9462
TEST_TIME 38 9416
TEST_TIME 39 9362
TEST_TIME 40 9294
TEST_TIME 41 9277
TEST_TIME 42 9300
TEST_TIME 43 9330
TEST_TIME 44 9434
TEST_TIME 45 9454
TEST_TIME 46 9434
TEST_TIME 47 9387
TEST_TIME 48 9568
TEST_TIME 49 9618
TEST_TIME 50 9624
TEST_TIME 51 9647
TEST_TIME 52 9649
TEST_TIME 53 9763
TEST_TIME 54 9677
TEST_TIME 55 9915
TEST_TIME 56 9819
TEST_TIME 57 9661
TEST_TIME 58 9620
TEST_TIME 59 9581
TEST_TIME 60 9515
TEST_TIME 61 9588
TEST_TIME 62 9540
TEST_TIME 63 9477
TEST_TIME 64 9445
TEST_TIME 65 9421
TEST_TIME 66 9428
TEST_TIME 67 9413
TEST_TIME 68 9438
TEST_TIME 69 9408
TEST_TIME 70 9459
TEST_TIME 71 9466
TEST_TIME 72 9427
TEST_TIME 73 9557
TEST_TIME 74 9617
TEST_TIME 75 9610
TEST_TIME 76 9579
TEST_TIME 77 9672
TEST_TIME 78 9694
TEST_TIME 79 9610
TEST_TIME 80 9539
TEST_TIME 81 9509
TEST_TIME 82 9508
TEST_TIME 83 9416
TEST_TIME 84 9431
TEST_TIME 85 9437
TEST_TIME 86 9408
TEST_TIME 87 9453
TEST_TIME 88 9430
TEST_TIME 89 9417
TEST_TIME 90 9415
TEST_TIME 91 9427
TEST_TIME 92 9489
TEST_TIME 93 9552
TEST_TIME 94 9534
TEST_TIME 95 9547
TEST_TIME 96 9598
TEST_TIME 97 9508
TEST_TIME 98 9430
TEST_TIME 99 9438
TEST_TIME 100 9392

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1320811 1320811 0 0.00 0 26842 7 0 0
doc_list_biud 1320779 1320779 0 0.00 0 62664 24 0 0
sp_add_invoice_to_stock 4404 4286 118 2.67 45 171615 21038 0 118
sp_cancel_adding_invoice 4531 4531 0 0.00 3 75974 832 0 0
sp_cancel_client_order 1444 1444 0 0.00 4 9312 350 0 0
sp_cancel_customer_reserve 449368 449368 0 0.00 0 41367 55 0 0
sp_cancel_pay_from_customer 586 586 0 0.00 2 2537 75 0 0
sp_cancel_pay_to_supplier 372 372 0 0.00 2 5343 84 0 0
sp_cancel_supplier_invoice 5024 5011 13 0.25 1 62680 699 0 13
sp_cancel_supplier_order 363 363 0 0.00 8 880237 84944 0 0
sp_cancel_write_off 7358 7358 0 0.00 1 8483 134 0 0
sp_client_order 17889 17889 0 0.00 3 55433 373 0 0
sp_customer_reserve 417833 417833 0 0.00 0 77428 200 0 0
sp_fill_shopping_cart 27118 27118 0 0.00 1 17294 35 0 0
sp_fill_shopping_cart_clo_res 417818 417818 0 0.00 0 16739 15 0 0
sp_get_clo_for_invoice 4271 4271 0 0.00 0 25246 338 0 0
sp_kill_cost_storno 12847 12847 0 0.00 0 8478 68 0 0
sp_kill_qstorno_ret_qs2qd 911468 911468 0 0.00 0 62660 30 0 0
sp_kill_qty_storno 480951 480951 0 0.00 0 62663 64 0 0
sp_lock_selected_doc 17810 17810 0 0.00 0 7925 5 0 0
sp_make_cost_storno 23796 23796 0 0.00 0 25555 63 0 0
sp_multiply_rows_for_pdistr 23794 23794 0 0.00 0 11432 30 0 0
sp_multiply_rows_for_qdistr 17889 17889 0 0.00 0 55424 179 0 0
sp_pay_from_customer 6002 6002 0 0.00 4 22450 137 0 0
sp_pay_to_supplier 4916 4916 0 0.00 4 23163 134 0 0
sp_payment_common 10910 10910 0 0.00 1 5275 20 0 0
sp_qd_handle_on_cancel_clo 1444 1444 0 0.00 0 9305 321 0 0
sp_qd_handle_on_invoice_upd_sts 8801 8801 0 0.00 0 23684 291 0 0
sp_qd_handle_on_reserve_upd_sts 8606 8606 0 0.00 0 14163 52 0 0
sp_reserve_write_off 8607 8607 0 0.00 6 22411 188 0 0
sp_supplier_invoice 4629 4629 0 0.00 5 90533 3243 0 0
sp_supplier_order 4622 4622 0 0.00 4 77657 1313 0 0
srv_aggregate_perf_data 87 87 0 0.00 1774 222365 19335 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1509 130729 40986 0 0
srv_find_qd_qs_mism 894950 894950 0 0.00 0 26840 7 0 0
srv_make_invnt_saldo 420 420 0 0.00 46 114537 3416 0 0
srv_make_money_saldo 629 629 0 0.00 0 18523 519 0 0
srv_recalc_idx_stat 3 3 0 0.00 209777 351176 264709 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4286 4286 0 0.00 0 12153 180 0 0
t$perf-norm:sp_cancel_adding_invoice 361 361 0 0.00 0 5668 120 0 0
t$perf-norm:sp_cancel_client_order 1444 1444 0 0.00 0 2326 10 0 0
t$perf-norm:sp_cancel_customer_reserve 622 622 0 0.00 0 1131 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 586 586 0 0.00 0 2096 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 372 372 0 0.00 0 1869 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 338 338 0 0.00 0 612 15 0 0
t$perf-norm:sp_cancel_supplier_order 363 363 0 0.00 0 26927 1661 0 0
t$perf-norm:sp_cancel_write_off 849 849 0 0.00 0 2328 8 0 0
t$perf-norm:sp_client_order 17889 17889 0 0.00 0 6184 15 0 0
t$perf-norm:sp_customer_reserve 879 879 0 0.00 0 760 4 0 0
t$perf-norm:sp_pay_from_customer 6002 6002 0 0.00 0 9709 10 0 0
t$perf-norm:sp_pay_to_supplier 4916 4916 0 0.00 0 3843 11 0 0
t$perf-norm:sp_reserve_write_off 8607 8607 0 0.00 0 5746 12 0 0
t$perf-norm:sp_supplier_invoice 4629 4629 0 0.00 0 2819 16 0 0
t$perf-norm:sp_supplier_order 4622 4622 0 0.00 0 6268 14 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 632 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 368 12 0 0
t$perf-norm:srv_make_invnt_saldo 420 420 0 0.00 0 2658 12 0 0
t$perf-norm:srv_make_money_saldo 629 629 0 0.00 0 2225 9 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 8774 8538 236 2.68 0 7373 18 0 236
v_all_customers 33000 33000 0 0.00 0 15 1 0 0
v_all_suppliers 26188 26188 0 0.00 0 73 1 0 0
v_all_wares 35764 35764 0 0.00 0 39 1 0 0
v_cancel_adding_invoice 722 722 0 0.00 0 520 7 0 0
v_cancel_client_order 2888 2888 0 0.00 0 7372 6 0 0
v_cancel_customer_prepayment 1172 1172 0 0.00 0 1677 7 0 0
v_cancel_customer_reserve 1244 1244 0 0.00 0 4085 10 0 0
v_cancel_payment_to_supplier 744 744 0 0.00 0 5338 16 0 0
v_cancel_supplier_invoice 702 676 26 3.70 0 175 10 0 26
v_cancel_supplier_order 726 726 0 0.00 0 1897 7 0 0
v_cancel_write_off 1698 1698 0 0.00 0 1729 12 0 0
v_max_id_clo_ord 4619 4619 0 0.00 0 211 1 0 0
v_max_id_clo_res 879 879 0 0.00 0 712 5 0 0
v_max_id_ord_sup 4617 4617 0 0.00 0 2106 2 0 0
v_max_non_paid_invoice 1056 1056 0 0.00 0 238 2 0 0
v_max_non_paid_realizn 2903 2903 0 0.00 0 809 3 0 0
v_min_id_clo_ord 4619 4619 0 0.00 0 2321 7 0 0
v_min_id_clo_res 879 879 0 0.00 0 7432 23 0 0
v_min_id_ord_sup 4617 4617 0 0.00 0 6053 13 0 0
v_min_non_paid_invoice 4914 4914 0 0.00 0 3261 10 0 0
v_min_non_paid_realizn 5996 5996 0 0.00 0 5270 17 0 0
v_our_firm 8950 8950 0 0.00 0 55 1 0 0
v_reserve_write_off 17212 17212 0 0.00 0 7367 7 0 0
x_lock_depdocs_on_canc_invoice 9204 9204 0 0.00 0 13391 99 0 0
x_lock_depdocs_on_canc_sup_ord 363 363 0 0.00 0 6774 326 0 0
x_make_qstorno_1000_1200 4622 4622 0 0.00 1 75715 1245 0 0
x_make_qstorno_1200_2000 4629 4629 0 0.00 2 90199 3100 0 0
x_make_qstorno_2100_3300 417833 417833 0 0.00 0 77426 183 0 0

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

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
11:07:52 2 8192000000 8796669328 8807108608 3187328 0.038 1 1 2 0 3284944 61840 35776
11:08:53 42701 8192000000 9720675984 10021814272 788970736 8.784 100 85 170 0 817534624 7502432 21061456
11:10:42 21382 8192000000 9760257264 10066599936 832689248 9.226 100 93 185 0 866785184 12203472 21892464
11:12:10 12384 8192000000 9786958416 10102460416 854429728 9.444 100 80 160 0 892674592 19688224 18556640
11:13:31 12406 8192000000 9850385744 10180603904 901738784 9.916 100 77 152 1 957332080 39095264 16498032
11:14:52 4361 8192000000 9904290320 10243112960 942705552 10.320 100 81 162 0 1012070832 52286128 17079152
11:16:01 5787 8192000000 9963012080 10324291584 983269424 10.716 100 71 142 0 1077845344 80191184 14384736
11:17:09 1949 8192000000 9976080416 10335866880 1008937424 10.965 100 88 173 0 1090609984 63941296 17731264
11:18:12 4806 8192000000 10014134352 10383364096 1034591872 11.213 100 72 142 0 1127247824 78665920 13990032
11:19:20 1067 8192000000 10044698144 10415808512 1057409680 11.432 100 92 183 0 1156691232 81111632 18169920
11:20:22 8659 8192000000 10016190288 10410156032 1062460336 11.480 100 65 124 0 1133562752 58280528 12821888
11:21:34 1238 8192000000 10037938832 10417672192 1071198768 11.564 100 79 156 1 1145512528 57654224 16659536
11:22:35 17482 8192000000 9981597024 10381271040 1075686576 11.606 100 45 91 0 1116869584 32016896 9166112
11:23:59 3850 8192000000 10003027968 10403590144 1083505344 11.681 100 49 97 0 1128010144 33495536 11009264
11:25:06 8320 8192000000 10005878928 10416189440 1087825296 11.722 100 32 66 0 1121645904 26601488 7219120
11:26:19 7518 8192000000 10007972528 10414809088 1091118880 11.753 100 24 47 1 1122563744 26744944 4699920
11:27:30 47999 8192000000 10021296112 10419982336 1089116992 11.734 99 49 98 0 1115477792 16498992 9861808
11:29:26 3855 8192000000 10095232880 10492981248 1110384320 11.936 100 65 130 0 1199786176 76530208 12871648
11:30:36 19866 8192000000 10101161056 10508582912 1120200896 12.029 100 52 104 0 1200543216 69755136 10587184
11:32:14 89909 8192000000 10122059472 10580533248 1125456448 12.079 100 31 62 0 1209044496 77026528 6561520
11:35:04 19217 8192000000 10134036112 10547965952 1125609088 12.080 99 33 66 0 1234874032 102092640 7172304
11:36:27 20714 8192000000 10165793152 10574831616 1113146848 11.962 98 43 86 0 1264400512 141357296 9896368
11:38:02 7316 8192000000 10150944224 10555379712 1101131968 11.848 97 41 79 1 1264205296 154533056 8540272
11:39:22 7644 8192000000 10186050912 10584465408 1093222240 11.773 98 66 131 1 1288481600 180611040 14648320
11:40:36 2478 8192000000 10204428832 10599399424 1095692976 11.797 100 76 149 1 1302572016 190282160 16596880
11:41:45 7831 8192000000 10178065280 10601558016 1097952848 11.818 99 57 113 0 1275720352 165241440 12526064
11:43:04 3278 8192000000 10185713152 10584424448 1114545968 11.975 100 56 111 0 1284431824 157986896 11898960
11:44:20 1507 8192000000 10249514560 10644635648 1120480528 12.032 100 71 139 2 1352496368 217451024 14564816
11:45:24 2035 8192000000 10292976464 10679459840 1122696048 12.052 100 91 181 0 1389378928 246975232 19707648
11:46:30 4967 8192000000 10291689392 10720645120 1130748464 12.128 100 53 102 0 1400726256 258014768 11963024
11:47:45 4192 8192000000 10307746592 10714628096 1122095088 12.047 100 47 94 2 1410630512 276313184 12222240
11:48:52 10048 8192000000 10322394432 10787004416 1140021248 12.216 100 43 84 0 1447128400 296749200 10357952
11:50:10 22857 8192000000 10232943568 10692722688 1130523488 12.126 100 22 44 0 1344902896 208922704 5456704
11:51:53 22019 8192000000 10148825504 10683850752 1110674848 11.939 100 14 27 0 1284013616 169982400 3356368
11:53:18 17519 8192000000 10043646720 10455040000 1113391360 11.965 99 54 106 0 1152788016 27085600 12311056
11:54:38 62960 8192000000 10108919056 10527264768 1126864464 12.092 100 37 76 1 1170527536 35651520 8011552
11:56:44 54163 8192000000 10179246640 10655662080 1119969648 12.027 99 22 42 0 1267887632 143096608 4821376
11:58:45 130729 8192000000 10066543856 10503020544 1126159872 12.085 99 29 56 1 1157781392 26245360 5376160
12:01:58 28498 8192000000 10096155120 10532397056 1138919248 12.205 100 39 78 1 1193469408 46422528 8127632
12:03:29 35735 8192000000 10087532128 10512601088 1114049184 11.971 98 38 77 0 1158093888 36325936 7718768
12:05:11 78064 8192000000 10115302960 10562940928 1144677872 12.260 99 24 48 0 1222446656 72708688 5060096
12:07:31 64637 8192000000 10154879168 10615754752 1135464064 12.173 98 25 50 0 1259441712 118424880 5552768
12:09:36 33991 8192000000 10138212496 10624122880 1151724160 12.326 100 14 28 0 1238221424 83250304 3246960
12:11:19 46073 8192000000 10075554880 10560446464 1137531472 12.192 99 9 18 0 1196008256 56888832 1587952
12:13:14 14644 8192000000 10092039408 10521755648 1149090464 12.301 100 57 109 0 1184359456 23097344 12171648
12:14:29 12581 8192000000 10131384240 10567983104 1151683168 12.325 99 51 102 0 1204808608 42879232 10246208
12:15:45 55074 8192000000 10091039584 10595213312 1127030976 12.093 98 17 34 0 1172670848 42342880 3296992
12:17:43 68422 8192000000 10093106224 10563686400 1114963568 11.979 97 19 38 0 1151342448 32290928 4087952
12:19:59 51933 8192000000 10073265920 10531274752 1098359536 11.822 96 20 38 0 1174094512 72018000 3716976
12:21:52 19230 8192000000 10145398896 10596806656 1119383520 12.021 99 47 94 1 1227169664 97878448 9907696
12:24:46 29736 8192000000 10067322448 10497675264 1082349888 11.670 97 48 91 0 1136431328 43291312 10790128
12:26:53 5252 8192000000 10037758848 10487525376 1089341104 11.736 99 29 58 0 1131979152 36897456 5740592
12:28:02 80104 8192000000 10033067904 10526306304 1078935712 11.637 97 12 24 0 1135111072 53753376 2421984
12:30:22 45891 8192000000 10027418832 10496323584 1096597520 11.805 99 14 28 0 1149384688 49811696 2975472
12:32:14 55528 8192000000 10044261472 10513178624 1102196944 11.858 99 12 24 0 1166388416 61717520 2473952
12:34:10 18382 8192000000 10022783936 10454560768 1090376576 11.746 98 50 100 1 1120688880 19610848 10701456
12:35:33 37622 8192000000 10059374272 10491092992 1078523952 11.633 97 26 52 0 1119411216 35496720 5390544
12:37:21 40268 8192000000 10079710416 10547220480 1096921216 11.808 98 25 50 0 1167352496 65693824 4737456
12:39:10 19376 8192000000 10096355328 10520977408 1112663328 11.958 99 35 70 0 1160344480 41019392 6661760
12:40:30 67384 8192000000 10049639744 10528161792 1080311056 11.650 97 14 28 1 1168026416 85267328 2448032
12:42:38 22623 8192000000 10077902480 10502443008 1105007440 11.885 99 38 76 0 1167529408 54912480 7609488
12:44:06 74682 8192000000 10089319632 10533093376 1126378880 12.087 100 32 64 1 1170683568 37982752 6321936
12:46:23 102003 8192000000 10066261536 10511081472 1117031072 11.999 99 17 35 0 1163907072 43381024 3494976
12:49:06 56710 8192000000 10056901072 10547118080 1138147136 12.198 100 7 14 0 1186310992 46824224 1339632
12:51:03 52360 8192000000 10070406928 10554413056 1115185200 11.981 98 11 22 0 1185940192 68512960 2242032
12:53:06 100624 8192000000 10095784256 10569039872 1122256544 12.048 98 18 34 0 1182193872 56126720 3810608
12:55:47 54125 8192000000 10078323888 10533093376 1146761088 12.279 100 17 34 0 1165141472 14888368 3492016
12:57:42 76742 8192000000 10157734896 10636247040 1137715744 12.194 99 20 40 2 1234481648 93026544 3739360
12:59:59 72077 8192000000 10068352528 10544873472 1119602448 12.023 98 14 29 0 1179019408 56796528 2620432
13:02:14 33758 8192000000 10076804288 10533330944 1107155728 11.905 98 30 60 0 1175766928 62825056 5786144
13:03:57 124089 8192000000 10061341328 10501234688 1103000080 11.866 98 25 50 0 1153604544 45459520 5144944
13:07:05 53849 8192000000 9833110736 10265915392 927525936 10.170 83 9 18 0 953072176 24060704 1485536

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 19-02-2024 13:10:25 to 19-02-2024 13:10:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 118 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          169276
MON$OLDEST_ACTIVE               170208
MON$OLDEST_SNAPSHOT             170208
MON$NEXT_TRANSACTION            170208
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                       1917472
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             688
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 Mon Feb 19 13:10:43 2024 
 
Database header page information: 
    Flags            0 
    Generation        88739 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    169276 
    Oldest active        170208 
    Oldest snapshot        170208 
    Next transaction    170209 
    Sequence number        0 
    Next attachment ID    688 
    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.76, total records: 7666921 
    Average version length: 48.18, total versions: 25372, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88616 
    Data pages: 88616, average fill: 69% 
    Primary pages: 88615, secondary pages: 1, swept pages: 53166 
    Empty pages: 5, full pages: 58407 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 75 
    40 - 59% = 2738 
    60 - 79% = 85780 
    80 - 99% = 8 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23181, nodes: 7666921 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1665690, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 330 
        20 - 39% = 2166 
        40 - 59% = 3879 
        60 - 79% = 2539 
        80 - 99% = 14267 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13471, nodes: 7666921 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1489013, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1787 
        40 - 59% = 1855 
        60 - 79% = 1240 
        80 - 99% = 8589 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8290, nodes: 7666921 
    Average node length: 6.60, total dup: 5758397, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1482249, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 124 
        20 - 39% = 1093 
        40 - 59% = 1261 
        60 - 79% = 1023 
        80 - 99% = 4789 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.15, total records: 2198710 
    Average version length: 58.83, total versions: 12569, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28480 
    Data pages: 28480, average fill: 71% 
    Primary pages: 28480, secondary pages: 0, swept pages: 16422 
    Empty pages: 4, full pages: 13849 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 29 
    40 - 59% = 680 
    60 - 79% = 27724 
    80 - 99% = 39 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4522, nodes: 2198710 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 675410, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 957 
        40 - 59% = 836 
        60 - 79% = 771 
        80 - 99% = 1958 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2425, nodes: 2199272 
    Average node length: 4.97, total dup: 2198374, max dup: 19596 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1253685, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 269 
        40 - 59% = 1399 
        60 - 79% = 521 
        80 - 99% = 234 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1762, nodes: 2198710 
    Average node length: 4.97, total dup: 2198660, max dup: 130153 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1052187, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 611 
        60 - 79% = 48 
        80 - 99% = 1099 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4308, nodes: 2198710 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 675410, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 81 
        20 - 39% = 633 
        40 - 59% = 626 
        60 - 79% = 893 
        80 - 99% = 2075 
 
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.30, total records: 400 
    Average version length: 26.98, total versions: 1493, max versions: 4 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 54% 
    Primary pages: 9, secondary pages: 15, swept pages: 0 
    Empty pages: 7, full pages: 12 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 13 
 
    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: 15.26, total records: 75228 
    Average version length: 68.30, total versions: 67289, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.77 
    Pointer pages: 6, data page slots: 3344 
    Data pages: 1664, average fill: 61% 
    Primary pages: 1663, secondary pages: 1, swept pages: 60 
    Empty pages: 230, full pages: 849 
    Fill distribution: 
     0 - 19% = 324 
    20 - 39% = 145 
    40 - 59% = 215 
    60 - 79% = 244 
    80 - 99% = 736 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694929, depth: 3, leaf buckets: 342, nodes: 75228 
    Average node length: 13.48, total dup: 4919, max dup: 2 
    Average key length: 10.78, compression ratio: 2.51 
    Average prefix length: 19.15, average data length: 7.85 
    Clustering factor: 53403, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 255 
        40 - 59% = 75 
        60 - 79% = 7 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 123, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 61% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.64, total records: 1076 
    Average version length: 43.69, total versions: 997, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.98 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 37% 
    Primary pages: 31, secondary pages: 1, swept pages: 8 
    Empty pages: 10, full pages: 8 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 7 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92719, depth: 2, leaf buckets: 2, nodes: 1076 
    Average node length: 4.38, total dup: 982, max dup: 146 
    Average key length: 2.94, compression ratio: 6.47 
    Average prefix length: 18.15, average data length: 0.85 
    Clustering factor: 587, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        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.62, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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: 36.92, total records: 798795 
    Average version length: 37.93, total versions: 17983, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8600 
    Data pages: 8600, average fill: 64% 
    Primary pages: 8599, secondary pages: 1, swept pages: 3624 
    Empty pages: 15, full pages: 4075 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 72 
    40 - 59% = 1180 
    60 - 79% = 7289 
    80 - 99% = 31 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 898, nodes: 791010 
    Average node length: 4.88, total dup: 790961, max dup: 152663 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89248, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 181 
        40 - 59% = 481 
        60 - 79% = 157 
        80 - 99% = 77 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 934, nodes: 791010 
    Average node length: 5.88, total dup: 704482, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158304, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 59 
        40 - 59% = 501 
        60 - 79% = 67 
        80 - 99% = 306 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 969, nodes: 791010 
    Average node length: 5.89, total dup: 704482, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160187, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 119 
        40 - 59% = 498 
        60 - 79% = 60 
        80 - 99% = 292 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1158, nodes: 791010 
    Average node length: 5.97, total dup: 704482, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152582, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 259 
        40 - 59% = 658 
        60 - 79% = 167 
        80 - 99% = 71 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5479 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.00, total fragments: 24, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 84, average fill: 64% 
    Primary pages: 75, secondary pages: 9, swept pages: 59 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5479 
    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.54 
    Clustering factor: 5209, ratio: 0.95 
    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: 5479 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 164, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.16, total records: 77475 
    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: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 805 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 805 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36744, depth: 2, leaf buckets: 99, nodes: 77475 
    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: 2960, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 97 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.58, 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.29 
    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: 140.05, total records: 161866 
    Average version length: 154.11, total versions: 12612, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.11 
    Pointer pages: 6, data page slots: 4696 
    Data pages: 4072, average fill: 83% 
    Primary pages: 4071, secondary pages: 1, swept pages: 2 
    Empty pages: 79, full pages: 3969 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 13 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3969 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 134.56, total records: 142103 
    Average version length: 154.81, total versions: 16546, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.60 
    Pointer pages: 7, data page slots: 4656 
    Data pages: 3592, average fill: 83% 
    Primary pages: 3589, secondary pages: 3, swept pages: 34 
    Empty pages: 82, full pages: 3485 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 10 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3487 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 145.71, total records: 150482 
    Average version length: 152.38, total versions: 5715, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 5, data page slots: 4360 
    Data pages: 3760, average fill: 83% 
    Primary pages: 3758, secondary pages: 2, swept pages: 8 
    Empty pages: 51, full pages: 3691 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3690 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 145.94, total records: 155505 
    Average version length: 152.03, total versions: 5813, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 7, data page slots: 5328 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3870, secondary pages: 2, swept pages: 2 
    Empty pages: 38, full pages: 3818 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3817 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 148.57, total records: 163778 
    Average version length: 151.39, total versions: 2989, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 7, data page slots: 6648 
    Data pages: 4088, average fill: 83% 
    Primary pages: 4086, secondary pages: 2, swept pages: 13 
    Empty pages: 58, full pages: 4010 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4010 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 145.66, total records: 152389 
    Average version length: 152.28, total versions: 5760, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 6, data page slots: 5112 
    Data pages: 3824, average fill: 82% 
    Primary pages: 3823, secondary pages: 1, swept pages: 8 
    Empty pages: 65, full pages: 3731 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 17 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3731 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 148.40, total records: 157938 
    Average version length: 150.76, total versions: 3134, 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: 6, data page slots: 5344 
    Data pages: 3952, average fill: 83% 
    Primary pages: 3951, secondary pages: 1, swept pages: 29 
    Empty pages: 58, full pages: 3869 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 7 
    40 - 59% = 8 
    60 - 79% = 4 
    80 - 99% = 3870 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 139.25, total records: 150757 
    Average version length: 153.29, total versions: 12541, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.18 
    Pointer pages: 7, data page slots: 4696 
    Data pages: 3776, average fill: 83% 
    Primary pages: 3774, secondary pages: 2, swept pages: 12 
    Empty pages: 63, full pages: 3696 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3696 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 147.39, total records: 156970 
    Average version length: 150.85, total versions: 4356, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 6, data page slots: 4824 
    Data pages: 3920, average fill: 83% 
    Primary pages: 3919, secondary pages: 1, swept pages: 17 
    Empty pages: 54, full pages: 3852 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 2 
    80 - 99% = 3852 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 145.51, total records: 143340 
    Average version length: 151.94, total versions: 5254, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 5, data page slots: 4808 
    Data pages: 3592, average fill: 82% 
    Primary pages: 3591, secondary pages: 1, swept pages: 26 
    Empty pages: 61, full pages: 3503 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 11 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 3502 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.49, total records: 2065590 
    Average version length: 52.84, total versions: 12029, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25672 
    Data pages: 25672, average fill: 69% 
    Primary pages: 25657, secondary pages: 15, swept pages: 12855 
    Empty pages: 182, full pages: 20586 
    Fill distribution: 
     0 - 19% = 365 
    20 - 39% = 411 
    40 - 59% = 1240 
    60 - 79% = 23556 
    80 - 99% = 100 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2534, nodes: 2065590 
    Average node length: 5.45, total dup: 1925880, max dup: 2081 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 179671, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 297 
        40 - 59% = 1618 
        60 - 79% = 317 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2751, nodes: 2065590 
    Average node length: 5.69, total dup: 1853565, max dup: 69 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370022, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2535 
        60 - 79% = 186 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2092, nodes: 2065590 
    Average node length: 4.96, total dup: 2065490, max dup: 28193 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 177751, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 201 
        40 - 59% = 1065 
        60 - 79% = 397 
        80 - 99% = 429 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 50.13, total records: 135938 
    Average version length: 69.18, total versions: 43092, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.51 
    Pointer pages: 3, data page slots: 3840 
    Data pages: 2968, average fill: 54% 
    Primary pages: 2968, secondary pages: 0, swept pages: 307 
    Empty pages: 252, full pages: 940 
    Fill distribution: 
     0 - 19% = 357 
    20 - 39% = 378 
    40 - 59% = 817 
    60 - 79% = 1041 
    80 - 99% = 375 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555707, depth: 3, leaf buckets: 241, nodes: 135938 
    Average node length: 6.54, total dup: 118214, max dup: 14 
    Average key length: 3.96, compression ratio: 10.60 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 24293, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 76 
        40 - 59% = 133 
        60 - 79% = 31 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.22, total records: 6992214 
    Average version length: 68.77, total versions: 201228, 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: 66, data page slots: 107216 
    Data pages: 107216, average fill: 70% 
    Primary pages: 107215, secondary pages: 1, swept pages: 53579 
    Empty pages: 6, full pages: 46893 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 458 
    40 - 59% = 9197 
    60 - 79% = 97256 
    80 - 99% = 263 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10717, nodes: 6992214 
    Average node length: 6.51, total dup: 6046574, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1628650, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1634 
        40 - 59% = 6101 
        60 - 79% = 2632 
        80 - 99% = 347 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8766, nodes: 6992214 
    Average node length: 5.40, total dup: 6712857, max dup: 148 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1441229, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1412 
        40 - 59% = 5138 
        60 - 79% = 1338 
        80 - 99% = 868 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8786, nodes: 6992214 
    Average node length: 5.40, total dup: 6712857, max dup: 148 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1443660, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1414 
        40 - 59% = 5104 
        60 - 79% = 1389 
        80 - 99% = 875 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.25, total records: 12087399 
    Average version length: 68.70, total versions: 139877, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 109, data page slots: 177280 
    Data pages: 177280, average fill: 72% 
    Primary pages: 177280, secondary pages: 0, swept pages: 105078 
    Empty pages: 8, full pages: 129146 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 554 
    40 - 59% = 7004 
    60 - 79% = 169071 
    80 - 99% = 605 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18508, nodes: 12086558 
    Average node length: 6.62, total dup: 10537255, max dup: 51 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2455099, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 2233 
        40 - 59% = 10938 
        60 - 79% = 4602 
        80 - 99% = 709 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 56.68, total records: 1154438 
    Average version length: 69.03, total versions: 166789, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.22 
    Pointer pages: 26, data page slots: 41744 
    Data pages: 26808, average fill: 46% 
    Primary pages: 26725, secondary pages: 83, swept pages: 13620 
    Empty pages: 4913, full pages: 11285 
    Fill distribution: 
     0 - 19% = 7638 
    20 - 39% = 3374 
    40 - 59% = 2981 
    60 - 79% = 10888 
    80 - 99% = 1927 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1718, nodes: 1081962 
    Average node length: 5.55, total dup: 1037745, max dup: 49 
    Average key length: 2.59, compression ratio: 16.22 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 74939, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 735 
        40 - 59% = 769 
        60 - 79% = 194 
        80 - 99% = 14 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 49.30, total records: 884342 
    Average version length: 69.05, total versions: 90164, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.56 
    Pointer pages: 20, data page slots: 31616 
    Data pages: 25424, average fill: 34% 
    Primary pages: 25423, secondary pages: 1, swept pages: 9611 
    Empty pages: 4517, full pages: 2764 
    Fill distribution: 
     0 - 19% = 7554 
    20 - 39% = 6119 
    40 - 59% = 8278 
    60 - 79% = 3446 
    80 - 99% = 27 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1124, nodes: 683985 
    Average node length: 5.94, total dup: 630655, max dup: 49 
    Average key length: 3.01, compression ratio: 13.94 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 97175, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 440 
        40 - 59% = 534 
        60 - 79% = 136 
        80 - 99% = 14 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.65, total records: 8846875 
    Average version length: 69.00, total versions: 183975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 88, data page slots: 142448 
    Data pages: 142440, average fill: 66% 
    Primary pages: 142421, secondary pages: 19, swept pages: 84610 
    Empty pages: 314, full pages: 55099 
    Fill distribution: 
     0 - 19% = 1273 
    20 - 39% = 5817 
    40 - 59% = 21325 
    60 - 79% = 113372 
    80 - 99% = 653 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13448, nodes: 8845137 
    Average node length: 6.68, total dup: 7332903, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2028336, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1534 
        40 - 59% = 7444 
        60 - 79% = 4093 
        80 - 99% = 376 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21119246 
    Average version length: 82.84, total versions: 2718, 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: 319424 
    Data pages: 319424, average fill: 81% 
    Primary pages: 319419, secondary pages: 5, swept pages: 13151 
    Empty pages: 59, full pages: 318368 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 59 
    40 - 59% = 154 
    60 - 79% = 48618 
    80 - 99% = 270496 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19336, nodes: 21119246 
    Average node length: 5.72, total dup: 20638850, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280757, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8080 
        60 - 79% = 563 
        80 - 99% = 10687 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17139, nodes: 21119246 
    Average node length: 6.31, total dup: 18560749, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916484, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 752 
        60 - 79% = 282 
        80 - 99% = 16096 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21098, nodes: 21119246 
    Average node length: 6.35, total dup: 18478253, max dup: 25 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573323, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8320 
        60 - 79% = 604 
        80 - 99% = 12170 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16069, nodes: 21119246 
    Average node length: 5.56, total dup: 21119146, max dup: 230590 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945265, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2877 
        60 - 79% = 355 
        80 - 99% = 12830 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.12, total records: 9285790 
    Average version length: 82.64, total versions: 164049, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 105, data page slots: 170432 
    Data pages: 170416, average fill: 67% 
    Primary pages: 170384, secondary pages: 32, swept pages: 109591 
    Empty pages: 746, full pages: 80870 
    Fill distribution: 
     0 - 19% = 2478 
    20 - 39% = 9297 
    40 - 59% = 26721 
    60 - 79% = 118301 
    80 - 99% = 13619 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11318, nodes: 9285790 
    Average node length: 5.36, total dup: 8981249, max dup: 145 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2122218, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 85 
        40 - 59% = 9316 
        60 - 79% = 1880 
        80 - 99% = 36 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13104, nodes: 9285790 
    Average node length: 6.22, total dup: 7694023, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1490340, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 3851 
        40 - 59% = 4335 
        60 - 79% = 2606 
        80 - 99% = 2193 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12636, nodes: 9285790 
    Average node length: 5.98, total dup: 8043716, max dup: 32 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2300299, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 102 
        40 - 59% = 10410 
        60 - 79% = 2086 
        80 - 99% = 35 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9987, nodes: 9285790 
    Average node length: 5.12, total dup: 9285690, max dup: 156549 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1512357, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1534 
        40 - 59% = 4866 
        60 - 79% = 1751 
        80 - 99% = 1794 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.54, total records: 10853847 
    Average version length: 82.59, total versions: 110256, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 118, data page slots: 191544 
    Data pages: 189856, average fill: 70% 
    Primary pages: 189727, secondary pages: 129, swept pages: 81272 
    Empty pages: 3557, full pages: 134709 
    Fill distribution: 
     0 - 19% = 6186 
    20 - 39% = 9220 
    40 - 59% = 20559 
    60 - 79% = 97663 
    80 - 99% = 56228 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13101, nodes: 10853847 
    Average node length: 5.29, total dup: 10745514, max dup: 646 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2265288, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 192 
        40 - 59% = 10328 
        60 - 79% = 2518 
        80 - 99% = 62 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10108, nodes: 10853847 
    Average node length: 5.49, total dup: 10378340, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 687750, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 189 
        20 - 39% = 871 
        40 - 59% = 2477 
        60 - 79% = 1816 
        80 - 99% = 4755 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14989, nodes: 10853847 
    Average node length: 6.02, total dup: 9460368, max dup: 70 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2281571, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 235 
        40 - 59% = 11939 
        60 - 79% = 2749 
        80 - 99% = 64 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10405, nodes: 10853847 
    Average node length: 5.21, total dup: 10853747, max dup: 200486 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 676914, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 945 
        40 - 59% = 4425 
        60 - 79% = 1551 
        80 - 99% = 3384 
 
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: 81.89, total records: 9342555 
    Average version length: 82.96, total versions: 107958, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 108, data page slots: 175232 
    Data pages: 175176, average fill: 66% 
    Primary pages: 175143, secondary pages: 33, swept pages: 122974 
    Empty pages: 805, full pages: 78454 
    Fill distribution: 
     0 - 19% = 2730 
    20 - 39% = 12143 
    40 - 59% = 31274 
    60 - 79% = 115867 
    80 - 99% = 13162 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11426, nodes: 9342555 
    Average node length: 5.17, total dup: 9314377, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1915135, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1606 
        40 - 59% = 7535 
        60 - 79% = 1727 
        80 - 99% = 527 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13217, nodes: 9342555 
    Average node length: 6.24, total dup: 7741705, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 1450883, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 159 
        20 - 39% = 3872 
        40 - 59% = 4318 
        60 - 79% = 2576 
        80 - 99% = 2292 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12118, nodes: 9342555 
    Average node length: 5.43, total dup: 8919445, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 2042449, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1609 
        40 - 59% = 8415 
        60 - 79% = 1556 
        80 - 99% = 507 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10038, nodes: 9342555 
    Average node length: 5.14, total dup: 9342455, max dup: 158668 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1531124, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1438 
        40 - 59% = 5026 
        60 - 79% = 1684 
        80 - 99% = 1846 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 68.00, total records: 575138 
    Average version length: 68.87, total versions: 1703, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8088 
    Data pages: 8088, average fill: 74% 
    Primary pages: 8088, secondary pages: 0, swept pages: 4139 
    Empty pages: 3, full pages: 6616 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 8 
    40 - 59% = 147 
    60 - 79% = 7904 
    80 - 99% = 25 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45964, depth: 3, leaf buckets: 731, nodes: 575138 
    Average node length: 5.95, total dup: 489792, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100706, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 526 
        60 - 79% = 91 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34567, depth: 3, leaf buckets: 755, nodes: 575138 
    Average node length: 6.15, total dup: 471770, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100755, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 27 
        40 - 59% = 532 
        60 - 79% = 92 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 557, nodes: 575138 
    Average node length: 4.86, total dup: 575038, max dup: 9743 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89542, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 319 
        60 - 79% = 64 
        80 - 99% = 145 
 
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 Mon Feb 19 13:11:06 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7666921 25372 1 0.0000 0.0000
DOC_LIST 2198710 12569 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1493 4 300.0000 0.0000
INVNT_TURNOVER_LOG 75228 67289 1 0.0000 0.0000
MONEY_SALDO 49 123 4 200.0000 0.0000
MONEY_TURNOVER_LOG 1076 997 1 0.0000 0.0000
PDISTR 798795 17983 2 0.0000 0.0000
PERF_SPLIT_0 161866 12612 1 0.0000 0.0000
PERF_SPLIT_1 142103 16546 1 0.0000 0.0000
PERF_SPLIT_2 150482 5715 1 0.0000 0.0000
PERF_SPLIT_3 155505 5813 1 0.0000 0.0000
PERF_SPLIT_4 163778 2989 1 0.0000 0.0000
PERF_SPLIT_5 152389 5760 1 0.0000 0.0000
PERF_SPLIT_6 157938 3134 1 0.0000 0.0000
PERF_SPLIT_7 150757 12541 1 0.0000 0.0000
PERF_SPLIT_8 156970 4356 1 0.0000 0.0000
PERF_SPLIT_9 143340 5254 1 0.0000 0.0000
PSTORNED 2065590 12029 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 135938 43092 1 0.0000 0.0000
XQD_1000_3300 6992214 201228 1 0.0000 0.0000
XQD_1200_2000 12087399 139877 1 0.0000 0.0000
XQD_2000_3300 1154438 166789 1 0.0000 0.0000
XQD_2100_3300 884342 90164 1 0.0000 0.0000
XQD_3300_3400 8846875 183975 1 0.0000 0.0000
XQS_1000_1200 21119246 2718 1 0.0000 0.0000
XQS_1000_3300 9285790 164049 1 0.0000 0.0000
XQS_1200_2000 10853847 110256 1 0.0000 0.0000
XQS_2100_3300 9342555 107958 1 0.0000 0.0000
XQS_3300_3400 575138 1703 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 ---
:36: 
:37: mscs-test-161.budzdorov.ru    Mon Feb 19 13:08:26 2024
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Mon Feb 19 13:08:26 2024
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:43: 
--- end of diff output ---

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

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