Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.03.2024 10: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 15804572 kB
MemAvailable 30296736 kB
Buffers 0 kB
Cached 15956204 kB
SwapCached 2568 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-19 10:07:50
DTS_END                         2024-03-19 10:07:50.8500
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/53586
TRN_ID                          170608
ATT_ID                          494
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: 8911.51 23405 891151
customer order: creation 175.13 422 17513
customer order: refuse 14.83 390 1483
order to supplier: creation 46.47 1352 4647
order to supplier: removal 3.44 92796 344
invoice (draft): creation 47.43 3419 4743
invoice (draft): removal 46.11 713 4611
invoice accept: apply 42.34 23079 4234
invoice accept: cancel 42.02 810 4202
customer reserve: creation 4090.96 220 409096
customer reserve: removal 4108.89 63 410889
realization accept: apply 85.91 197 8591
realization accept: cancel 75.98 134 7598
payment from customer: creation 61.78 115 6178
payment from customer: removal 5.96 109 596
payment to supplier: creation 49.96 144 4996
payment to supplier: removal 3.55 105 355
service: total inventory turnovers 3.44 4261 344
service: total monetary turnovers 6.34 584 634
service: aggregate perf. data 0.94 12901 94
service: refresh index statistics 0.03 326289 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 19-03-2024 10:10:09 to 19-03-2024 10:10:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4612
TEST_TIME 2 5086
TEST_TIME 3 5168
TEST_TIME 4 4775
TEST_TIME 5 4941
TEST_TIME 6 5600
TEST_TIME 7 5929
TEST_TIME 8 5915
TEST_TIME 9 6569
TEST_TIME 10 6920
TEST_TIME 11 7312
TEST_TIME 12 7480
TEST_TIME 13 7538
TEST_TIME 14 7966
TEST_TIME 15 7949
TEST_TIME 16 7967
TEST_TIME 17 7997
TEST_TIME 18 7866
TEST_TIME 19 7965
TEST_TIME 20 7993
TEST_TIME 21 8075
TEST_TIME 22 8036
TEST_TIME 23 8299
TEST_TIME 24 8441
TEST_TIME 25 9244
TEST_TIME 26 9555
TEST_TIME 27 9336
TEST_TIME 28 9539
TEST_TIME 29 9491
TEST_TIME 30 9531
TEST_TIME 31 9325
TEST_TIME 32 9177
TEST_TIME 33 9040
TEST_TIME 34 8946
TEST_TIME 35 9115
TEST_TIME 36 8985
TEST_TIME 37 8963
TEST_TIME 38 8851
TEST_TIME 39 8728
TEST_TIME 40 8723
TEST_TIME 41 8752
TEST_TIME 42 8675
TEST_TIME 43 8720
TEST_TIME 44 8660
TEST_TIME 45 8506
TEST_TIME 46 8631
TEST_TIME 47 8547
TEST_TIME 48 8618
TEST_TIME 49 8664
TEST_TIME 50 8621
TEST_TIME 51 8753
TEST_TIME 52 8724
TEST_TIME 53 8834
TEST_TIME 54 8822
TEST_TIME 55 8800
TEST_TIME 56 8922
TEST_TIME 57 8951
TEST_TIME 58 8897
TEST_TIME 59 9098
TEST_TIME 60 9129
TEST_TIME 61 8988
TEST_TIME 62 8893
TEST_TIME 63 8829
TEST_TIME 64 8865
TEST_TIME 65 8836
TEST_TIME 66 8790
TEST_TIME 67 8783
TEST_TIME 68 8714
TEST_TIME 69 8689
TEST_TIME 70 8642
TEST_TIME 71 8723
TEST_TIME 72 8737
TEST_TIME 73 8714
TEST_TIME 74 8693
TEST_TIME 75 8715
TEST_TIME 76 8958
TEST_TIME 77 9038
TEST_TIME 78 9016
TEST_TIME 79 9025
TEST_TIME 80 9062
TEST_TIME 81 8975
TEST_TIME 82 8925
TEST_TIME 83 8884
TEST_TIME 84 8831
TEST_TIME 85 8820
TEST_TIME 86 8783
TEST_TIME 87 8820
TEST_TIME 88 8819
TEST_TIME 89 8801
TEST_TIME 90 8857
TEST_TIME 91 8917
TEST_TIME 92 8922
TEST_TIME 93 8916
TEST_TIME 94 8986
TEST_TIME 95 8979
TEST_TIME 96 9022
TEST_TIME 97 9048
TEST_TIME 98 9052
TEST_TIME 99 8975
TEST_TIME 100 8920

Performance per minute, chart


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

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 1263322 1263322 0 0.00 0 22117 8 0 0
doc_list_biud 1263322 1263322 0 0.00 0 63863 26 0 0
sp_add_invoice_to_stock 4317 4234 83 1.92 34 209208 23079 0 83
sp_cancel_adding_invoice 4202 4202 0 0.00 5 49467 810 0 0
sp_cancel_client_order 1483 1483 0 0.00 4 10279 390 0 0
sp_cancel_customer_reserve 410889 410889 0 0.00 0 21726 64 0 0
sp_cancel_pay_from_customer 596 596 0 0.00 2 10115 110 0 0
sp_cancel_pay_to_supplier 355 355 0 0.00 2 6994 105 0 0
sp_cancel_supplier_invoice 4618 4611 7 0.15 1 63872 714 0 7
sp_cancel_supplier_order 344 344 0 0.00 6 789710 92796 0 0
sp_cancel_write_off 7598 7598 0 0.00 1 12171 135 0 0
sp_client_order 17513 17513 0 0.00 3 24289 423 0 0
sp_customer_reserve 409096 409096 0 0.00 0 71709 221 0 0
sp_fill_shopping_cart 26889 26889 0 0.00 1 20672 43 0 0
sp_fill_shopping_cart_clo_res 409092 409092 0 0.00 0 23834 19 0 0
sp_get_clo_for_invoice 4227 4227 0 0.00 0 42418 464 0 0
sp_kill_cost_storno 12751 12751 0 0.00 0 8139 64 0 0
sp_kill_qstorno_ret_qs2qd 834331 834331 0 0.00 0 63862 34 0 0
sp_kill_qty_storno 441945 441945 0 0.00 0 63863 73 0 0
sp_lock_selected_doc 17727 17727 0 0.00 0 8123 6 0 0
sp_make_cost_storno 23992 23992 0 0.00 0 19781 65 0 0
sp_multiply_rows_for_pdistr 23992 23992 0 0.00 0 9089 33 0 0
sp_multiply_rows_for_qdistr 17513 17513 0 0.00 0 24262 219 0 0
sp_pay_from_customer 6178 6178 0 0.00 3 21847 116 0 0
sp_pay_to_supplier 4996 4996 0 0.00 4 15195 145 0 0
sp_payment_common 11174 11174 0 0.00 1 10860 21 0 0
sp_qd_handle_on_cancel_clo 1483 1483 0 0.00 0 10270 352 0 0
sp_qd_handle_on_invoice_upd_sts 8429 8429 0 0.00 0 30317 289 0 0
sp_qd_handle_on_reserve_upd_sts 8591 8591 0 0.00 0 13755 54 0 0
sp_reserve_write_off 8591 8591 0 0.00 6 20422 198 0 0
sp_supplier_invoice 4743 4743 0 0.00 5 97560 3419 0 0
sp_supplier_order 4647 4647 0 0.00 5 38021 1353 0 0
srv_aggregate_perf_data 94 94 0 0.00 1966 123805 12902 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1156 179535 46034 0 0
srv_find_qd_qs_mism 846578 846578 0 0.00 0 22115 7 0 0
srv_make_invnt_saldo 344 344 0 0.00 45 79891 4261 0 0
srv_make_money_saldo 634 634 0 0.00 1 11622 584 0 0
srv_recalc_idx_stat 3 3 0 0.00 237988 398413 326289 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4236 4236 0 0.00 0 8100 183 0 0
t$perf-norm:sp_cancel_adding_invoice 348 348 0 0.00 0 1791 91 0 0
t$perf-norm:sp_cancel_client_order 1483 1483 0 0.00 0 2588 14 0 0
t$perf-norm:sp_cancel_customer_reserve 585 585 0 0.00 0 427 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 596 596 0 0.00 0 655 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 355 355 0 0.00 0 209 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 349 349 0 0.00 0 780 14 0 0
t$perf-norm:sp_cancel_supplier_order 344 344 0 0.00 0 24878 1448 0 0
t$perf-norm:sp_cancel_write_off 851 851 0 0.00 0 1373 5 0 0
t$perf-norm:sp_client_order 17513 17513 0 0.00 0 4392 14 0 0
t$perf-norm:sp_customer_reserve 810 810 0 0.00 0 7610 14 0 0
t$perf-norm:sp_pay_from_customer 6178 6178 0 0.00 0 12275 12 0 0
t$perf-norm:sp_pay_to_supplier 4996 4996 0 0.00 0 7127 8 0 0
t$perf-norm:sp_reserve_write_off 8591 8591 0 0.00 0 12216 11 0 0
t$perf-norm:sp_supplier_invoice 4743 4743 0 0.00 0 4933 15 0 0
t$perf-norm:sp_supplier_order 4647 4647 0 0.00 0 2035 12 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 266 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 103 2 0 0
t$perf-norm:srv_make_invnt_saldo 344 344 0 0.00 0 565 11 0 0
t$perf-norm:srv_make_money_saldo 634 634 0 0.00 0 867 8 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 8616 8450 166 1.92 0 17145 25 0 166
v_all_customers 32296 32296 0 0.00 0 43 1 0 0
v_all_suppliers 26460 26460 0 0.00 0 19 1 0 0
v_all_wares 35026 35026 0 0.00 0 31 1 0 0
v_cancel_adding_invoice 696 696 0 0.00 0 396 8 0 0
v_cancel_client_order 2966 2966 0 0.00 0 8404 9 0 0
v_cancel_customer_prepayment 1192 1192 0 0.00 0 10104 13 0 0
v_cancel_customer_reserve 1170 1170 0 0.00 0 9922 13 0 0
v_cancel_payment_to_supplier 710 710 0 0.00 0 1638 7 0 0
v_cancel_supplier_invoice 712 698 14 1.96 0 21529 43 0 14
v_cancel_supplier_order 688 688 0 0.00 0 8404 33 0 0
v_cancel_write_off 1702 1702 0 0.00 0 3463 15 0 0
v_max_id_clo_ord 4646 4646 0 0.00 0 708 1 0 0
v_max_id_clo_res 810 810 0 0.00 0 2454 19 0 0
v_max_id_ord_sup 4730 4730 0 0.00 0 7328 6 0 0
v_max_non_paid_invoice 1142 1142 0 0.00 0 344 2 0 0
v_max_non_paid_realizn 3103 3103 0 0.00 0 3779 4 0 0
v_min_id_clo_ord 4646 4646 0 0.00 0 6610 8 0 0
v_min_id_clo_res 810 810 0 0.00 0 2096 8 0 0
v_min_id_ord_sup 4730 4730 0 0.00 0 6349 8 0 0
v_min_non_paid_invoice 4996 4996 0 0.00 0 5909 11 0 0
v_min_non_paid_realizn 6178 6178 0 0.00 0 9074 17 0 0
v_our_firm 8880 8880 0 0.00 0 23 1 0 0
v_reserve_write_off 17182 17182 0 0.00 0 20162 8 0 0
x_lock_depdocs_on_canc_invoice 8464 8464 0 0.00 0 14196 116 0 0
x_lock_depdocs_on_canc_sup_ord 344 344 0 0.00 0 3123 312 0 0
x_make_qstorno_1000_1200 4647 4647 0 0.00 1 38009 1275 0 0
x_make_qstorno_1200_2000 4743 4743 0 0.00 2 97442 3255 0 0
x_make_qstorno_2100_3300 409096 409096 0 0.00 0 71661 199 0 0

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

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
08:07:54 1342 8192000000 8964415280 9030561792 62798064 0.760 12 10 23 0 65726944 438768 2490112
08:08:58 30985 8192000000 9720465776 10020728832 801234640 8.909 100 91 182 0 830894688 8040320 21619728
08:10:37 14352 8192000000 9765265520 10076520448 839950976 9.299 100 90 180 0 873110096 12156128 21002992
08:12:00 15758 8192000000 9798758656 10118066176 866485504 9.565 100 90 180 0 906226576 19726976 20014096
08:13:23 11126 8192000000 9842529072 10176086016 894025328 9.839 100 83 166 1 954608080 42685216 17897536
08:14:36 7201 8192000000 9887424528 10228518912 929333456 10.188 100 78 156 0 998289504 52752064 16203984
08:15:46 3807 8192000000 9950549904 10302619648 972858416 10.615 100 81 161 0 1059660144 70799920 16001808
08:16:53 2071 8192000000 9976307120 10337538048 1000137664 10.880 100 82 164 1 1092459344 76861072 15460608
08:17:57 3152 8192000000 9979643648 10349932544 1026975552 11.139 100 77 152 1 1096409968 53967360 15467056
08:19:03 1275 8192000000 10038584624 10411773952 1052814448 11.388 100 94 187 1 1151233280 79624560 18794272
08:20:06 1185 8192000000 10022327712 10402177024 1062423520 11.480 100 78 155 1 1134186560 57333616 14429424
08:21:09 2319 8192000000 10030450528 10411761664 1069021552 11.543 100 79 157 0 1136528816 51944144 15563120
08:22:12 9915 8192000000 9982215168 10385141760 1075285408 11.603 100 23 46 1 1103905168 23919600 4700160
08:23:25 10053 8192000000 10006218960 10410008576 1082815824 11.674 100 35 68 0 1108804208 19075104 6913280
08:24:37 7156 8192000000 9998250928 10396712960 1088033504 11.724 100 38 76 1 1111495856 15595360 7866992
08:25:46 14154 8192000000 9988227120 10401943552 1094965136 11.790 100 38 75 0 1124115312 22156928 6993248
08:27:01 23778 8192000000 9997517792 10418728960 1093642992 11.777 100 21 40 0 1119147248 21639040 3865216
08:28:30 4345 8192000000 10014308096 10423402496 1103338016 11.869 100 35 70 0 1123643872 12356304 7949552
08:29:41 33342 8192000000 10063181952 10464972800 1095070272 11.791 99 51 102 0 1166452928 61376608 10006048
08:31:25 36042 8192000000 10130410016 10539192320 1109502384 11.928 100 47 94 0 1227302272 108151680 9648208
08:33:10 11499 8192000000 10115815424 10535321600 1097574112 11.815 98 46 92 1 1215527584 108732176 9221296
08:34:30 14391 8192000000 10084252656 10481459200 1075849168 11.608 97 47 93 1 1191509120 106228192 9431760
08:35:48 26242 8192000000 10083483936 10512109568 1069274688 11.545 97 45 90 1 1193897328 115145808 9476832
08:37:18 4949 8192000000 10074383888 10471272448 1047316016 11.335 96 49 94 1 1152689360 96098112 9275232
08:38:28 9210 8192000000 10047473920 10451013632 1052465328 11.384 98 54 106 1 1148077648 84622640 10989680
08:39:41 4870 8192000000 10059586464 10447388672 1072642448 11.577 100 68 130 2 1161134800 75466224 13026128
08:40:53 5567 8192000000 10081471200 10498252800 1072155872 11.573 100 58 114 0 1182606928 98293184 12157872
08:42:03 4276 8192000000 10114343968 10502922240 1077527792 11.624 100 67 132 1 1208574832 117673856 13373184
08:43:11 5355 8192000000 10113550400 10511888384 1081297760 11.660 99 49 97 1 1221760096 130550912 9911424
08:44:21 11357 8192000000 10097896720 10513154048 1084021312 11.686 99 36 72 0 1193357296 101255872 8080112
08:45:37 1156 8192000000 10171258384 10563661824 1110977728 11.942 100 79 156 1 1268957616 141029008 16950880
08:46:45 4595 8192000000 10233718432 10632728576 1120839104 12.035 100 72 142 0 1334384592 198280720 15264768
08:47:52 7384 8192000000 10248033600 10648465408 1134738752 12.166 100 68 134 0 1349118064 199595632 14783680
08:49:02 4438 8192000000 10307681552 10706591744 1141846944 12.233 100 65 129 2 1396368096 240381968 14139184
08:50:10 8917 8192000000 10352618208 10766983168 1145442112 12.267 100 54 106 0 1451671600 293688496 12540992
08:51:25 13034 8192000000 10337040016 10788442112 1149739936 12.307 100 30 61 0 1442253840 285036960 7476944
08:53:35 28904 8192000000 10140279728 10569383936 1138786128 12.204 100 31 60 2 1240036464 93976928 7273408
08:55:08 51264 8192000000 10087681696 10523254784 1124252928 12.067 99 52 102 0 1273965792 138464144 11248720
08:57:07 9998 8192000000 10117163728 10543800320 1141572768 12.230 100 41 82 0 1214582592 65082384 7927440
08:58:19 44422 8192000000 10109295680 10559209472 1146110544 12.273 100 13 26 0 1220034432 71186688 2737200
09:00:10 179534 8192000000 10080488304 10549186560 1148345136 12.294 100 19 38 0 1243946864 91721264 3880464
09:04:24 37715 8192000000 10070687232 10519842816 1120142608 12.028 97 41 82 0 1147908768 19065984 8700176
09:06:14 64379 8192000000 10122251456 10559541248 1158698832 12.391 100 35 68 0 1207799104 42139344 6960928
09:08:27 50795 8192000000 10115706576 10566627328 1139602448 12.212 98 18 34 0 1242691280 99317344 3771488
09:10:24 46770 8192000000 10110527168 10562752512 1143821504 12.251 99 8 16 0 1210290832 64944336 1524992
09:12:12 84798 8192000000 10169854240 10633801728 1142720368 12.241 99 16 32 1 1257103152 110954480 3428304
09:14:44 73912 8192000000 10099422560 10561470464 1129197008 12.114 98 22 44 0 1182172192 48622192 4352992
09:17:01 35982 8192000000 10104347808 10544607232 1137281872 12.190 98 24 47 0 1197655664 55743904 4629888
09:18:39 93217 8192000000 10112589440 10552266752 1084849408 11.694 94 17 34 0 1147354528 59544912 2960208
09:21:14 50718 8192000000 10078784128 10508783616 1084926496 11.694 95 21 43 0 1106631664 18073632 3631536
09:23:05 118543 8192000000 10050442624 10479661056 1071142848 11.563 94 12 21 0 1119457264 46273312 2041104
09:26:05 61291 8192000000 10080603776 10590330880 1057133568 11.429 94 21 42 0 1184735936 123290320 4312048
09:28:07 88672 8192000000 10005070960 10431258624 1031723728 11.185 93 37 74 1 1072298032 32655152 7919152
09:30:38 37528 8192000000 10060355760 10498351104 1085784464 11.703 99 37 74 0 1143753168 50808656 7160048
09:32:30 96838 8192000000 10009961888 10445283328 993124832 10.812 91 7 14 0 1023268704 28866064 1277808
09:35:07 40988 8192000000 10010866128 10450857984 1082861152 11.675 100 24 47 0 1119082528 31259920 4961456
09:36:48 31925 8192000000 10031514304 10444255232 1065878128 11.513 97 35 69 0 1106049440 33046416 7124896
09:38:24 67780 8192000000 10047028416 10507399168 1095198208 11.792 100 21 42 0 1153182480 53837184 4147088
09:40:34 48919 8192000000 10112212560 10550054912 1091012160 11.752 98 29 58 0 1201803120 104648224 6142736
09:42:43 79112 8192000000 10116167008 10654072832 1123411840 12.059 100 20 40 0 1280616304 152565664 4638800
09:45:04 62202 8192000000 10054083632 10482380800 1103408288 11.870 99 35 72 1 1146747328 35874512 7464528
09:47:17 109164 8192000000 10051543136 10485497856 1119732176 12.024 100 31 62 0 1189485680 63186672 6566832
09:50:07 85398 8192000000 10070545168 10529284096 1120685056 12.033 99 12 22 1 1158802128 36038384 2078688
09:53:38 68582 8192000000 10075160704 10534715392 1113791504 11.968 98 24 48 0 1168744304 50097088 4855712
09:55:58 77670 8192000000 10120986352 10609344512 1099837392 11.836 96 23 46 0 1206463072 102008624 4617056
09:58:24 42476 8192000000 10058786800 10485743616 1127611360 12.099 100 27 52 0 1156768416 23943792 5213264
10:00:07 115388 8192000000 10046793280 10503864320 1067005264 11.523 94 8 16 0 1115910080 47268848 1635968
10:03:06 34503 8192000000 10079662112 10536812544 1105766752 11.892 98 30 60 0 1173825056 62282736 5775568
10:04:41 79748 8192000000 10080562064 10586767360 1116960960 11.998 100 27 54 0 1192252224 69691728 5599536
10:07:34 29630 8192000000 9367546336 9681453056 482268672 5.559 45 22 44 1 521314544 34389200 4656672

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-03-2024 10:10:23 to 19-03-2024 10:10:37.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 83 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

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

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          169859
MON$OLDEST_ACTIVE               171270
MON$OLDEST_SNAPSHOT             171270
MON$NEXT_TRANSACTION            171270
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                       1910112
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             687
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Tue Mar 19 10:10:41 2024 
 
Database header page information: 
    Flags            0 
    Generation        89677 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    169859 
    Oldest active        171270 
    Oldest snapshot        171270 
    Next transaction    171271 
    Sequence number        0 
    Next attachment ID    687 
    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.68, total records: 7731628 
    Average version length: 48.16, total versions: 42529, 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: 89120 
    Data pages: 89120, average fill: 69% 
    Primary pages: 89119, secondary pages: 1, swept pages: 48388 
    Empty pages: 10, full pages: 59477 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 66 
    40 - 59% = 1981 
    60 - 79% = 87015 
    80 - 99% = 27 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23107, nodes: 7731628 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1681399, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 298 
        20 - 39% = 1815 
        40 - 59% = 3952 
        60 - 79% = 2327 
        80 - 99% = 14715 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13438, nodes: 7731628 
    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: 1506068, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1634 
        40 - 59% = 1894 
        60 - 79% = 1077 
        80 - 99% = 8833 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8296, nodes: 7731628 
    Average node length: 6.62, total dup: 5779862, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1499281, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 979 
        40 - 59% = 1319 
        60 - 79% = 901 
        80 - 99% = 4975 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.96, total records: 2242132 
    Average version length: 58.90, total versions: 22475, 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: 28864 
    Data pages: 28864, average fill: 71% 
    Primary pages: 28862, secondary pages: 2, swept pages: 15684 
    Empty pages: 4, full pages: 14236 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 17 
    40 - 59% = 497 
    60 - 79% = 28301 
    80 - 99% = 42 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4533, nodes: 2242132 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 684538, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 949 
        40 - 59% = 783 
        60 - 79% = 698 
        80 - 99% = 2103 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2435, nodes: 2242976 
    Average node length: 4.97, total dup: 2242077, max dup: 17575 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1268728, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 229 
        40 - 59% = 1386 
        60 - 79% = 565 
        80 - 99% = 250 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1783, nodes: 2242132 
    Average node length: 4.97, total dup: 2242082, max dup: 130156 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1069463, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 620 
        60 - 79% = 50 
        80 - 99% = 1108 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4336, nodes: 2242132 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 684538, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 615 
        40 - 59% = 593 
        60 - 79% = 797 
        80 - 99% = 2237 
 
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.32, total records: 400 
    Average version length: 26.34, total versions: 3801, max versions: 10 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 63% 
    Primary pages: 12, secondary pages: 28, swept pages: 0 
    Empty pages: 5, full pages: 26 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 25 
 
    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: 11.08, total records: 105654 
    Average version length: 68.28, total versions: 101950, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.94 
    Pointer pages: 7, data page slots: 3288 
    Data pages: 1968, average fill: 73% 
    Primary pages: 1967, secondary pages: 1, swept pages: 105 
    Empty pages: 228, full pages: 1362 
    Fill distribution: 
     0 - 19% = 279 
    20 - 39% = 77 
    40 - 59% = 116 
    60 - 79% = 220 
    80 - 99% = 1276 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701130, depth: 3, leaf buckets: 384, nodes: 105654 
    Average node length: 13.35, total dup: 7011, max dup: 2 
    Average key length: 10.77, compression ratio: 2.51 
    Average prefix length: 19.16, average data length: 7.84 
    Clustering factor: 78654, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 93 
        40 - 59% = 264 
        60 - 79% = 18 
        80 - 99% = 6 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 380, max versions: 13 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 16 
    Data pages: 16, average fill: 9% 
    Primary pages: 8, secondary pages: 8, swept pages: 0 
    Empty pages: 7, full pages: 1 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 9.53, total records: 2055 
    Average version length: 43.46, total versions: 2023, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 6.08 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 68% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 5, full pages: 18 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 17 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92770, depth: 2, leaf buckets: 3, nodes: 2055 
    Average node length: 4.19, total dup: 1957, max dup: 200 
    Average key length: 2.50, compression ratio: 7.59 
    Average prefix length: 18.54, average data length: 0.46 
    Clustering factor: 1120, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.66, total records: 70 
    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: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.87, total records: 790251 
    Average version length: 37.95, total versions: 19152, 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: 8448 
    Data pages: 8448, average fill: 64% 
    Primary pages: 8445, secondary pages: 3, swept pages: 3642 
    Empty pages: 6, full pages: 4050 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 36 
    40 - 59% = 1033 
    60 - 79% = 7317 
    80 - 99% = 41 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 864, nodes: 781697 
    Average node length: 4.88, total dup: 781648, max dup: 143147 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88479, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 153 
        40 - 59% = 466 
        60 - 79% = 157 
        80 - 99% = 86 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 870, nodes: 781697 
    Average node length: 5.89, total dup: 695688, max dup: 53 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 155520, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 398 
        60 - 79% = 114 
        80 - 99% = 330 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 910, nodes: 781697 
    Average node length: 5.89, total dup: 695688, max dup: 53 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157383, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 82 
        40 - 59% = 414 
        60 - 79% = 108 
        80 - 99% = 305 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1124, nodes: 781697 
    Average node length: 5.97, total dup: 695688, max dup: 53 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 149959, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 250 
        40 - 59% = 605 
        60 - 79% = 187 
        80 - 99% = 82 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5416 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.83, total fragments: 35, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 75, secondary pages: 13, swept pages: 61 
    Empty pages: 3, full pages: 66 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 5, nodes: 5416 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.02 
    Average prefix length: 34.34, average data length: 1.54 
    Clustering factor: 5190, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5416 
    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: 159, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 77847 
    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: 816 
    Data pages: 816, average fill: 66% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 809 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 809 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 40417, depth: 2, leaf buckets: 99, nodes: 77847 
    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: 3060, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.90, total records: 175433 
    Average version length: 149.92, total versions: 1553, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 7, data page slots: 5560 
    Data pages: 4368, average fill: 83% 
    Primary pages: 4365, secondary pages: 3, swept pages: 6 
    Empty pages: 47, full pages: 4299 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4299 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 149.39, total records: 159835 
    Average version length: 150.47, total versions: 1823, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 8, data page slots: 6328 
    Data pages: 4000, average fill: 82% 
    Primary pages: 3998, secondary pages: 2, swept pages: 5 
    Empty pages: 68, full pages: 3915 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3914 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.48, total records: 139210 
    Average version length: 149.41, total versions: 2431, 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: 6, data page slots: 4128 
    Data pages: 3456, average fill: 83% 
    Primary pages: 3454, secondary pages: 2, swept pages: 5 
    Empty pages: 34, full pages: 3410 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3411 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.84, total records: 144499 
    Average version length: 152.49, total versions: 4582, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 8, data page slots: 5008 
    Data pages: 3648, average fill: 82% 
    Primary pages: 3646, secondary pages: 2, swept pages: 3 
    Empty pages: 81, full pages: 3540 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 13 
    80 - 99% = 3538 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 149.90, total records: 154187 
    Average version length: 147.53, total versions: 1400, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 6, data page slots: 4400 
    Data pages: 3824, average fill: 83% 
    Primary pages: 3822, secondary pages: 2, swept pages: 1 
    Empty pages: 31, full pages: 3782 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3781 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 147.91, total records: 150167 
    Average version length: 151.52, total versions: 3594, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 7, data page slots: 4520 
    Data pages: 3776, average fill: 82% 
    Primary pages: 3774, secondary pages: 2, swept pages: 1 
    Empty pages: 71, full pages: 3679 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 11 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3680 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.15, total records: 151411 
    Average version length: 150.28, total versions: 1973, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 4512 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3766, secondary pages: 2, swept pages: 1 
    Empty pages: 47, full pages: 3709 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3709 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 148.53, total records: 150341 
    Average version length: 151.57, total versions: 2645, 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: 6, data page slots: 5368 
    Data pages: 3792, average fill: 82% 
    Primary pages: 3790, secondary pages: 2, swept pages: 3 
    Empty pages: 85, full pages: 3680 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 11 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 3679 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 149.92, total records: 143690 
    Average version length: 142.75, total versions: 967, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 5, data page slots: 4392 
    Data pages: 3560, average fill: 83% 
    Primary pages: 3557, secondary pages: 3, swept pages: 1 
    Empty pages: 29, full pages: 3519 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 3519 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 149.02, total records: 151359 
    Average version length: 152.35, total versions: 2278, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 6, data page slots: 4384 
    Data pages: 3792, average fill: 82% 
    Primary pages: 3790, secondary pages: 2, swept pages: 1 
    Empty pages: 65, full pages: 3709 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 3709 
 
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.23, total records: 2091777 
    Average version length: 52.83, total versions: 24795, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25776 
    Data pages: 25776, average fill: 70% 
    Primary pages: 25763, secondary pages: 13, swept pages: 11894 
    Empty pages: 182, full pages: 21820 
    Fill distribution: 
     0 - 19% = 365 
    20 - 39% = 328 
    40 - 59% = 877 
    60 - 79% = 23968 
    80 - 99% = 238 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2572, nodes: 2091777 
    Average node length: 5.44, total dup: 1951191, max dup: 1406 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181962, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 285 
        40 - 59% = 1705 
        60 - 79% = 285 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2760, nodes: 2091777 
    Average node length: 5.69, total dup: 1877356, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374476, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2437 
        60 - 79% = 293 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2103, nodes: 2091777 
    Average node length: 4.96, total dup: 2091677, max dup: 28192 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179872, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 202 
        40 - 59% = 1064 
        60 - 79% = 397 
        80 - 99% = 439 
 
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: 46.06, total records: 125631 
    Average version length: 69.16, total versions: 48300, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.74 
    Pointer pages: 3, data page slots: 4576 
    Data pages: 3360, average fill: 45% 
    Primary pages: 3359, secondary pages: 1, swept pages: 787 
    Empty pages: 791, full pages: 962 
    Fill distribution: 
     0 - 19% = 1106 
    20 - 39% = 244 
    40 - 59% = 504 
    60 - 79% = 1007 
    80 - 99% = 499 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106493, depth: 3, leaf buckets: 220, nodes: 125631 
    Average node length: 6.49, total dup: 109276, max dup: 14 
    Average key length: 3.99, compression ratio: 10.54 
    Average prefix length: 40.14, average data length: 1.86 
    Clustering factor: 22049, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 84 
        40 - 59% = 97 
        60 - 79% = 39 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.07, total records: 6780532 
    Average version length: 68.76, total versions: 214334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 65, data page slots: 104472 
    Data pages: 104448, average fill: 69% 
    Primary pages: 104447, secondary pages: 1, swept pages: 52006 
    Empty pages: 17, full pages: 42215 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 373 
    40 - 59% = 9392 
    60 - 79% = 94092 
    80 - 99% = 561 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10708, nodes: 6780532 
    Average node length: 6.52, total dup: 5863462, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1602432, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1893 
        40 - 59% = 6312 
        60 - 79% = 2196 
        80 - 99% = 294 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8318, nodes: 6780532 
    Average node length: 5.41, total dup: 6502791, max dup: 155 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1415610, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1441 
        40 - 59% = 4365 
        60 - 79% = 1426 
        80 - 99% = 1077 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8346, nodes: 6780532 
    Average node length: 5.41, total dup: 6502791, max dup: 155 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1417851, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1523 
        40 - 59% = 4300 
        60 - 79% = 1386 
        80 - 99% = 1127 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.85, total records: 11774369 
    Average version length: 68.73, total versions: 215377, 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: 106, data page slots: 172344 
    Data pages: 172344, average fill: 73% 
    Primary pages: 172343, secondary pages: 1, swept pages: 93244 
    Empty pages: 1, full pages: 126846 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 405 
    40 - 59% = 5670 
    60 - 79% = 164965 
    80 - 99% = 1284 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18389, nodes: 11772966 
    Average node length: 6.61, total dup: 10261581, max dup: 49 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2417756, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2543 
        40 - 59% = 11207 
        60 - 79% = 4029 
        80 - 99% = 586 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 54.11, total records: 1423425 
    Average version length: 68.97, total versions: 213023, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.33 
    Pointer pages: 26, data page slots: 41488 
    Data pages: 30136, average fill: 49% 
    Primary pages: 30046, secondary pages: 90, swept pages: 13252 
    Empty pages: 4562, full pages: 14563 
    Fill distribution: 
     0 - 19% = 7040 
    20 - 39% = 4268 
    40 - 59% = 3415 
    60 - 79% = 12564 
    80 - 99% = 2849 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1940, nodes: 1280613 
    Average node length: 5.52, total dup: 1228727, max dup: 49 
    Average key length: 2.57, compression ratio: 16.33 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 89967, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 726 
        40 - 59% = 892 
        60 - 79% = 298 
        80 - 99% = 15 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 49.69, total records: 909996 
    Average version length: 68.99, total versions: 83288, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.54 
    Pointer pages: 22, data page slots: 34784 
    Data pages: 29728, average fill: 30% 
    Primary pages: 29727, secondary pages: 1, swept pages: 12174 
    Empty pages: 7050, full pages: 1268 
    Fill distribution: 
     0 - 19% = 11658 
    20 - 39% = 6346 
    40 - 59% = 8185 
    60 - 79% = 3502 
    80 - 99% = 37 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1171, nodes: 700416 
    Average node length: 5.94, total dup: 645988, max dup: 49 
    Average key length: 3.01, compression ratio: 13.95 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 99381, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 459 
        40 - 59% = 578 
        60 - 79% = 129 
        80 - 99% = 5 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.31, total records: 9111502 
    Average version length: 68.94, total versions: 235133, 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: 89, data page slots: 144224 
    Data pages: 144200, average fill: 68% 
    Primary pages: 144183, secondary pages: 17, swept pages: 79881 
    Empty pages: 213, full pages: 59654 
    Fill distribution: 
     0 - 19% = 703 
    20 - 39% = 3541 
    40 - 59% = 21639 
    60 - 79% = 116783 
    80 - 99% = 1534 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13499, nodes: 9107292 
    Average node length: 6.69, total dup: 7551805, max dup: 17 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2074753, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1149 
        40 - 59% = 7302 
        60 - 79% = 4562 
        80 - 99% = 486 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21114664 
    Average version length: 82.50, total versions: 4766, 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: 319360 
    Data pages: 319360, average fill: 81% 
    Primary pages: 319356, secondary pages: 4, swept pages: 13388 
    Empty pages: 39, full pages: 318287 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 74 
    40 - 59% = 192 
    60 - 79% = 48698 
    80 - 99% = 270315 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19380, nodes: 21114664 
    Average node length: 5.72, total dup: 20634401, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278783, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 0 
        40 - 59% = 8170 
        60 - 79% = 552 
        80 - 99% = 10648 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17140, nodes: 21114664 
    Average node length: 6.31, total dup: 18555763, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916625, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 4 
        40 - 59% = 751 
        60 - 79% = 301 
        80 - 99% = 16078 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21108, nodes: 21114664 
    Average node length: 6.35, total dup: 18474312, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3572163, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8349 
        60 - 79% = 604 
        80 - 99% = 12149 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16061, nodes: 21114664 
    Average node length: 5.56, total dup: 21114564, max dup: 228390 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945454, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2896 
        60 - 79% = 334 
        80 - 99% = 12825 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.57, total records: 9568383 
    Average version length: 82.51, total versions: 239900, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 104, data page slots: 168816 
    Data pages: 168800, average fill: 70% 
    Primary pages: 168776, secondary pages: 24, swept pages: 95753 
    Empty pages: 360, full pages: 89529 
    Fill distribution: 
     0 - 19% = 935 
    20 - 39% = 3908 
    40 - 59% = 23606 
    60 - 79% = 121509 
    80 - 99% = 18842 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11338, nodes: 9568383 
    Average node length: 5.38, total dup: 9259665, max dup: 204 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2199038, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 55 
        40 - 59% = 8401 
        60 - 79% = 2802 
        80 - 99% = 80 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13405, nodes: 9568383 
    Average node length: 6.25, total dup: 7929693, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1561284, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 4078 
        40 - 59% = 4087 
        60 - 79% = 2656 
        80 - 99% = 2462 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12657, nodes: 9568383 
    Average node length: 6.00, total dup: 8296644, max dup: 38 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2380996, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 68 
        40 - 59% = 9447 
        60 - 79% = 3065 
        80 - 99% = 76 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9991, nodes: 9568383 
    Average node length: 5.15, total dup: 9568283, max dup: 138011 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1576684, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1225 
        40 - 59% = 4770 
        60 - 79% = 1841 
        80 - 99% = 2122 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.82, total records: 11357639 
    Average version length: 82.41, total versions: 229996, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 118, data page slots: 192224 
    Data pages: 190936, average fill: 73% 
    Primary pages: 190780, secondary pages: 156, swept pages: 67099 
    Empty pages: 2235, full pages: 148479 
    Fill distribution: 
     0 - 19% = 3831 
    20 - 39% = 5974 
    40 - 59% = 14778 
    60 - 79% = 100281 
    80 - 99% = 66072 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13117, nodes: 11357639 
    Average node length: 5.31, total dup: 11247741, max dup: 684 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2381938, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 101 
        40 - 59% = 8894 
        60 - 79% = 3980 
        80 - 99% = 141 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10426, nodes: 11357639 
    Average node length: 5.51, total dup: 10862619, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 733290, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 152 
        20 - 39% = 828 
        40 - 59% = 2529 
        60 - 79% = 1713 
        80 - 99% = 5204 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15013, nodes: 11357639 
    Average node length: 6.04, total dup: 9911030, max dup: 78 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2398253, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 127 
        40 - 59% = 10488 
        60 - 79% = 4223 
        80 - 99% = 173 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10777, nodes: 11357639 
    Average node length: 5.24, total dup: 11357539, max dup: 167081 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 720985, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 829 
        40 - 59% = 4711 
        60 - 79% = 1501 
        80 - 99% = 3648 
 
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: 78.07, total records: 10080685 
    Average version length: 82.84, total versions: 637760, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 106, data page slots: 171424 
    Data pages: 171416, average fill: 73% 
    Primary pages: 171394, secondary pages: 22, swept pages: 62467 
    Empty pages: 213, full pages: 114959 
    Fill distribution: 
     0 - 19% = 633 
    20 - 39% = 2394 
    40 - 59% = 14465 
    60 - 79% = 122979 
    80 - 99% = 30945 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12117, nodes: 10080685 
    Average node length: 5.19, total dup: 10051340, max dup: 2357 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2103782, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1348 
        40 - 59% = 8228 
        60 - 79% = 1884 
        80 - 99% = 626 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13733, nodes: 10080685 
    Average node length: 6.26, total dup: 8357765, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1609769, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 186 
        20 - 39% = 3495 
        40 - 59% = 4658 
        60 - 79% = 2571 
        80 - 99% = 2823 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12749, nodes: 10080685 
    Average node length: 5.44, total dup: 9632060, max dup: 97 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2239379, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1325 
        40 - 59% = 9088 
        60 - 79% = 1687 
        80 - 99% = 619 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10432, nodes: 10080685 
    Average node length: 5.16, total dup: 10080585, max dup: 146236 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1685056, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1104 
        40 - 59% = 5234 
        60 - 79% = 1784 
        80 - 99% = 2269 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.12, total records: 581095 
    Average version length: 68.80, total versions: 10329, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 76% 
    Primary pages: 8064, secondary pages: 0, swept pages: 2586 
    Empty pages: 6, full pages: 7663 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 3 
    40 - 59% = 62 
    60 - 79% = 7809 
    80 - 99% = 184 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 51098, depth: 3, leaf buckets: 733, nodes: 581095 
    Average node length: 5.95, total dup: 494753, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102257, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 514 
        60 - 79% = 96 
        80 - 99% = 99 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 39716, depth: 3, leaf buckets: 750, nodes: 581095 
    Average node length: 6.15, total dup: 476553, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102306, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 526 
        60 - 79% = 89 
        80 - 99% = 113 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 555, nodes: 581095 
    Average node length: 4.86, total dup: 580995, max dup: 9870 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90803, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 307 
        60 - 79% = 66 
        80 - 99% = 151 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar 19 10:11:05 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7731628 42529 1 0.0000 0.0000
DOC_LIST 2242132 22475 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3801 10 900.0000 0.0000
INVNT_TURNOVER_LOG 105654 101950 1 0.0000 0.0000
MONEY_SALDO 49 380 13 700.0000 0.0000
MONEY_TURNOVER_LOG 2055 2023 1 0.0000 0.0000
PDISTR 790251 19152 2 0.0000 0.0000
PERF_SPLIT_0 175433 1553 1 0.0000 0.0000
PERF_SPLIT_1 159835 1823 1 0.0000 0.0000
PERF_SPLIT_2 139210 2431 1 0.0000 0.0000
PERF_SPLIT_3 144499 4582 1 0.0000 0.0000
PERF_SPLIT_4 154187 1400 1 0.0000 0.0000
PERF_SPLIT_5 150167 3594 1 0.0000 0.0000
PERF_SPLIT_6 151411 1973 1 0.0000 0.0000
PERF_SPLIT_7 150341 2645 1 0.0000 0.0000
PERF_SPLIT_8 143690 967 1 0.0000 0.0000
PERF_SPLIT_9 151359 2278 1 0.0000 0.0000
PSTORNED 2091777 24795 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 125631 48300 1 0.0000 0.0000
XQD_1000_3300 6780532 214334 1 0.0000 0.0000
XQD_1200_2000 11774369 215377 1 0.0000 0.0000
XQD_2000_3300 1423425 213023 1 0.0000 0.0000
XQD_2100_3300 909996 83288 1 0.0000 0.0000
XQD_3300_3400 9111502 235133 1 0.0000 0.0000
XQS_1000_1200 21114664 4766 1 0.0000 0.0000
XQS_1000_3300 9568383 239900 1 0.0000 0.0000
XQS_1200_2000 11357639 229996 1 0.0000 0.0000
XQS_2100_3300 10080685 637760 1 0.0000 0.0000
XQS_3300_3400 581095 10329 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 ---
:111: 
:112: mscs-test-161.budzdorov.ru    Tue Mar 19 10:08:23 2024
:113:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:114: 
--- end of diff output ---

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

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