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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-18 19:09:34
DTS_END                         2024-02-18 19:09:34.0160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53130
TRN_ID                          172059
ATT_ID                          576
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: 9123.99 23623 912399
customer order: creation 166.20 353 16620
customer order: refuse 15.10 396 1510
order to supplier: creation 45.61 1230 4561
order to supplier: removal 3.46 107960 346
invoice (draft): creation 45.38 3388 4538
invoice (draft): removal 51.05 964 5105
invoice accept: apply 41.63 20562 4163
invoice accept: cancel 46.08 871 4608
customer reserve: creation 3953.47 199 395347
customer reserve: removal 4464.44 64 446444
realization accept: apply 81.36 193 8136
realization accept: cancel 82.52 122 8252
payment from customer: creation 57.79 113 5779
payment from customer: removal 5.64 61 564
payment to supplier: creation 48.62 142 4862
payment to supplier: removal 3.48 77 348
service: total inventory turnovers 4.84 1185 484
service: total monetary turnovers 6.47 41 647
service: aggregate perf. data 0.82 22641 82
service: refresh index statistics 0.03 311903 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-02-2024 19:10:58 to 18-02-2024 19:11:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1677
TEST_TIME 2 1623
TEST_TIME 3 4095
TEST_TIME 4 4006
TEST_TIME 5 4475
TEST_TIME 6 4698
TEST_TIME 7 4674
TEST_TIME 8 4491
TEST_TIME 9 4420
TEST_TIME 10 4640
TEST_TIME 11 4831
TEST_TIME 12 5338
TEST_TIME 13 5407
TEST_TIME 14 5530
TEST_TIME 15 6067
TEST_TIME 16 6198
TEST_TIME 17 6450
TEST_TIME 18 6416
TEST_TIME 19 6675
TEST_TIME 20 6699
TEST_TIME 21 7044
TEST_TIME 22 7512
TEST_TIME 23 7599
TEST_TIME 24 7873
TEST_TIME 25 7931
TEST_TIME 26 7985
TEST_TIME 27 8722
TEST_TIME 28 9316
TEST_TIME 29 9389
TEST_TIME 30 9173
TEST_TIME 31 9446
TEST_TIME 32 9428
TEST_TIME 33 9374
TEST_TIME 34 9344
TEST_TIME 35 9245
TEST_TIME 36 9213
TEST_TIME 37 9081
TEST_TIME 38 9148
TEST_TIME 39 9027
TEST_TIME 40 8965
TEST_TIME 41 8939
TEST_TIME 42 9056
TEST_TIME 43 9025
TEST_TIME 44 8897
TEST_TIME 45 8927
TEST_TIME 46 8893
TEST_TIME 47 9051
TEST_TIME 48 9082
TEST_TIME 49 8997
TEST_TIME 50 8872
TEST_TIME 51 8855
TEST_TIME 52 8845
TEST_TIME 53 8807
TEST_TIME 54 8733
TEST_TIME 55 8711
TEST_TIME 56 8812
TEST_TIME 57 8823
TEST_TIME 58 8833
TEST_TIME 59 8824
TEST_TIME 60 8990
TEST_TIME 61 8984
TEST_TIME 62 9000
TEST_TIME 63 9019
TEST_TIME 64 9102
TEST_TIME 65 9100
TEST_TIME 66 9172
TEST_TIME 67 9198
TEST_TIME 68 9230
TEST_TIME 69 9108
TEST_TIME 70 9154
TEST_TIME 71 9082
TEST_TIME 72 9040
TEST_TIME 73 9050
TEST_TIME 74 9010
TEST_TIME 75 8999
TEST_TIME 76 8954
TEST_TIME 77 8963
TEST_TIME 78 8998
TEST_TIME 79 8991
TEST_TIME 80 9070
TEST_TIME 81 9171
TEST_TIME 82 9153
TEST_TIME 83 9159
TEST_TIME 84 9194
TEST_TIME 85 9148
TEST_TIME 86 9218
TEST_TIME 87 9282
TEST_TIME 88 9350
TEST_TIME 89 9347
TEST_TIME 90 9277
TEST_TIME 91 9266
TEST_TIME 92 9238
TEST_TIME 93 9202
TEST_TIME 94 9181
TEST_TIME 95 9141
TEST_TIME 96 9158
TEST_TIME 97 9105
TEST_TIME 98 9188
TEST_TIME 99 9176
TEST_TIME 100 9136

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-02-2024 19:11:02 to 18-02-2024 19:11:05.

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 1273825 1273825 0 0.00 0 21699 7 0 0
doc_list_biud 1273793 1273793 0 0.00 0 41460 29 0 0
sp_add_invoice_to_stock 4242 4163 79 1.86 29 170775 20562 0 79
sp_cancel_adding_invoice 4608 4608 0 0.00 4 70460 872 0 0
sp_cancel_client_order 1510 1510 0 0.00 5 27337 396 0 0
sp_cancel_customer_reserve 446444 446444 0 0.00 0 41472 65 0 0
sp_cancel_pay_from_customer 564 564 0 0.00 3 2449 61 0 0
sp_cancel_pay_to_supplier 348 348 0 0.00 3 2961 78 0 0
sp_cancel_supplier_invoice 5108 5105 3 0.05 1 37061 964 0 3
sp_cancel_supplier_order 346 346 0 0.00 11 1119065 107961 0 0
sp_cancel_write_off 8252 8252 0 0.00 1 17743 122 0 0
sp_client_order 16620 16620 0 0.00 3 50913 353 0 0
sp_customer_reserve 395347 395347 0 0.00 0 51893 200 0 0
sp_fill_shopping_cart 25703 25703 0 0.00 1 31363 41 0 0
sp_fill_shopping_cart_clo_res 395333 395333 0 0.00 0 22295 16 0 0
sp_get_clo_for_invoice 4149 4149 0 0.00 0 44778 356 0 0
sp_kill_cost_storno 13772 13772 0 0.00 0 7230 62 0 0
sp_kill_qstorno_ret_qs2qd 906591 906591 0 0.00 0 41448 36 0 0
sp_kill_qty_storno 478550 478550 0 0.00 0 41459 77 0 0
sp_lock_selected_doc 17172 17172 0 0.00 0 6373 4 0 0
sp_make_cost_storno 22926 22926 0 0.00 0 21689 61 0 0
sp_multiply_rows_for_pdistr 22926 22926 0 0.00 0 7021 28 0 0
sp_multiply_rows_for_qdistr 16620 16620 0 0.00 0 50905 164 0 0
sp_pay_from_customer 5779 5779 0 0.00 4 16245 114 0 0
sp_pay_to_supplier 4862 4862 0 0.00 4 14746 142 0 0
sp_payment_common 10634 10634 0 0.00 2 8502 27 0 0
sp_qd_handle_on_cancel_clo 1510 1510 0 0.00 0 27331 355 0 0
sp_qd_handle_on_invoice_upd_sts 8757 8757 0 0.00 0 22405 336 0 0
sp_qd_handle_on_reserve_upd_sts 8136 8136 0 0.00 0 15170 63 0 0
sp_reserve_write_off 8136 8136 0 0.00 7 15658 194 0 0
sp_supplier_invoice 4538 4538 0 0.00 6 84980 3389 0 0
sp_supplier_order 4561 4561 0 0.00 5 40946 1231 0 0
srv_aggregate_perf_data 82 82 0 0.00 2277 398139 22641 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 2049 109396 43608 0 0
srv_find_qd_qs_mism 870413 870413 0 0.00 0 12016 6 0 0
srv_make_invnt_saldo 484 484 0 0.00 60 95629 1186 0 0
srv_make_money_saldo 647 647 0 0.00 0 5183 42 0 0
srv_recalc_idx_stat 3 3 0 0.00 141850 458647 311903 0 0
t$perf-abend:sp_add_invoice_to_stock 79 79 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4164 4164 0 0.00 0 8705 192 0 0
t$perf-norm:sp_cancel_adding_invoice 332 332 0 0.00 0 3096 97 0 0
t$perf-norm:sp_cancel_client_order 1510 1510 0 0.00 0 2979 10 0 0
t$perf-norm:sp_cancel_customer_reserve 558 558 0 0.00 0 4024 24 0 0
t$perf-norm:sp_cancel_pay_from_customer 564 564 0 0.00 0 2210 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 348 348 0 0.00 0 349 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 325 325 0 0.00 0 5046 38 0 0
t$perf-norm:sp_cancel_supplier_order 346 346 0 0.00 0 30002 1805 0 0
t$perf-norm:sp_cancel_write_off 904 904 0 0.00 0 4799 14 0 0
t$perf-norm:sp_client_order 16620 16620 0 0.00 0 6119 16 0 0
t$perf-norm:sp_customer_reserve 816 816 0 0.00 0 1089 7 0 0
t$perf-norm:sp_pay_from_customer 5779 5779 0 0.00 0 4555 9 0 0
t$perf-norm:sp_pay_to_supplier 4862 4862 0 0.00 0 4581 9 0 0
t$perf-norm:sp_reserve_write_off 8136 8136 0 0.00 0 4825 12 0 0
t$perf-norm:sp_supplier_invoice 4538 4538 0 0.00 0 2757 16 0 0
t$perf-norm:sp_supplier_order 4561 4561 0 0.00 0 11076 18 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 231 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 922 19 0 0
t$perf-norm:srv_make_invnt_saldo 484 484 0 0.00 0 543 21 0 0
t$perf-norm:srv_make_money_saldo 647 647 0 0.00 0 4551 32 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 16 9 0 0
v_add_invoice_to_stock 8455 8297 158 1.86 0 4868 19 0 158
v_all_customers 30914 30914 0 0.00 0 22 1 0 0
v_all_suppliers 25808 25808 0 0.00 0 26 1 0 0
v_all_wares 33218 33218 0 0.00 0 36 1 0 0
v_cancel_adding_invoice 664 664 0 0.00 0 1059 11 0 0
v_cancel_client_order 3020 3020 0 0.00 0 4707 8 0 0
v_cancel_customer_prepayment 1128 1128 0 0.00 0 934 5 0 0
v_cancel_customer_reserve 1116 1116 0 0.00 0 683 5 0 0
v_cancel_payment_to_supplier 696 696 0 0.00 0 2225 11 0 0
v_cancel_supplier_invoice 656 650 6 0.91 0 3848 24 0 6
v_cancel_supplier_order 692 692 0 0.00 0 1864 6 0 0
v_cancel_write_off 1808 1808 0 0.00 0 3959 15 0 0
v_max_id_clo_ord 4557 4557 0 0.00 0 684 1 0 0
v_max_id_clo_res 816 816 0 0.00 0 7245 22 0 0
v_max_id_ord_sup 4537 4537 0 0.00 0 3877 6 0 0
v_max_non_paid_invoice 1049 1049 0 0.00 0 171 2 0 0
v_max_non_paid_realizn 2866 2866 0 0.00 0 2089 4 0 0
v_min_id_clo_ord 4557 4557 0 0.00 0 2231 7 0 0
v_min_id_clo_res 816 816 0 0.00 0 2656 8 0 0
v_min_id_ord_sup 4537 4537 0 0.00 0 8396 7 0 0
v_min_non_paid_invoice 4859 4859 0 0.00 0 8500 24 0 0
v_min_non_paid_realizn 5775 5775 0 0.00 0 7545 19 0 0
v_our_firm 8122 8122 0 0.00 0 18 1 0 0
v_reserve_write_off 16271 16271 0 0.00 0 5399 8 0 0
x_lock_depdocs_on_canc_invoice 9388 9388 0 0.00 0 19152 139 0 0
x_lock_depdocs_on_canc_sup_ord 346 346 0 0.00 0 10923 372 0 0
x_make_qstorno_1000_1200 4561 4561 0 0.00 1 40940 1156 0 0
x_make_qstorno_1200_2000 4538 4538 0 0.00 3 78567 3234 0 0
x_make_qstorno_2100_3300 395347 395347 0 0.00 0 46269 180 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-02-2024 19:11:06 to 18-02-2024 19:11:10.

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
17:09:37 4 8192000000 8801910512 8814104576 7934208 0.096 2 2 3 0 8075296 66144 74944
17:10:40 34009 8192000000 9911674880 10225258496 991445296 10.796 100 89 178 0 1020668080 6140656 23082128
17:12:20 13915 8192000000 9949148464 10271907840 1031304720 11.181 100 88 176 0 1062596816 8699984 22592112
17:13:46 12133 8192000000 9979433008 10313052160 1062040528 11.476 100 84 168 0 1093110304 9888192 21181584
17:15:06 9725 8192000000 10031322384 10377748480 1118913344 12.017 100 76 149 0 1146557616 9512128 18132144
17:16:25 3651 8192000000 10079868064 10439127040 1172211488 12.517 100 86 170 0 1202825152 10868432 19745232
17:17:32 3072 8192000000 10115892352 10486566912 1206835088 12.840 100 67 134 0 1233968784 12456896 14676800
17:18:37 4374 8192000000 10152353040 10532941824 1247731616 13.217 100 68 133 1 1274101248 11937312 14432320
17:19:44 1187 8192000000 10194888688 10575495168 1279033440 13.504 100 86 165 2 1309786896 12023568 18729888
17:20:49 1443 8192000000 10205787904 10594181120 1299393776 13.690 100 73 143 0 1326108032 10559760 16154496
17:21:52 6387 8192000000 10194109024 10603905024 1306172944 13.751 100 31 63 1 1320612656 7468912 6970800
17:23:00 5793 8192000000 10199068624 10613288960 1315471456 13.836 100 39 77 0 1331726208 7348464 8906288
17:24:08 11446 8192000000 10199596736 10618847232 1321332496 13.889 100 25 50 0 1333470368 5677296 6460576
17:25:24 23005 8192000000 10231347168 10637635584 1327574512 13.945 100 48 95 1 1345251056 7082800 10593744
17:26:47 6682 8192000000 10231010976 10645749760 1333635744 14.000 100 29 56 0 1346807088 6751568 6419776
17:27:55 9134 8192000000 10227858272 10651172864 1342279296 14.078 100 26 52 2 1353892144 5545120 6067728
17:29:06 10760 8192000000 10215741776 10636414976 1306677696 13.756 98 7 14 0 1313771120 4921968 2171456
17:30:25 93434 8192000000 10236530224 10653396992 1323089040 13.905 99 55 106 0 1344882032 10318736 11474256
17:33:00 20250 8192000000 10231096096 10641686528 1297352944 13.671 98 33 64 1 1319087472 14493568 7240960
17:34:45 10755 8192000000 10213342448 10607689728 1278816016 13.502 97 59 118 0 1310424448 18565360 13043072
17:36:01 22448 8192000000 10232908144 10640371712 1298088016 13.678 98 39 78 2 1325123872 18146384 8889472
17:37:34 24787 8192000000 10235361520 10642489344 1314929312 13.831 99 31 62 0 1341011456 18036112 8046032
17:39:06 42029 8192000000 10248200432 10653065216 1316859152 13.848 99 48 96 0 1351047760 22890416 11298192
17:40:54 24816 8192000000 10267354448 10671026176 1327466000 13.944 99 45 90 0 1368182528 29595056 11121472
17:42:27 7416 8192000000 10248509568 10651459584 1315020800 13.832 99 53 104 1 1357327520 29088480 13218240
17:43:40 3237 8192000000 10287065312 10688815104 1344877488 14.101 100 66 129 0 1393712528 33859344 14975696
17:44:47 2758 8192000000 10305735024 10714525696 1363931312 14.273 100 55 110 1 1409357056 32002096 13423648
17:45:53 3187 8192000000 10301344032 10711527424 1365003680 14.282 100 59 114 0 1410877104 31564816 14308608
17:47:03 2049 8192000000 10323026208 10726563840 1375129184 14.373 100 83 162 0 1428861008 33218592 20513232
17:48:11 5188 8192000000 10338793664 10743951360 1381877568 14.433 100 71 142 1 1440431120 40847952 17705600
17:49:31 3524 8192000000 10353791584 10761183232 1392194832 14.525 100 76 150 1 1454106912 43526464 18385616
17:50:39 2218 8192000000 10362121232 10770145280 1401896864 14.612 100 82 162 0 1463942528 41193952 20851712
17:51:48 25670 8192000000 10334591600 10759061504 1388956448 14.497 99 35 70 0 1436624528 37857968 9810112
17:53:19 17051 8192000000 10353416784 10782957568 1409506304 14.680 100 35 70 0 1464266576 44288992 10471280
17:54:42 28491 8192000000 10343410816 10778161152 1398792880 14.584 100 22 44 0 1446653760 41121776 6739104
17:56:15 16437 8192000000 10338121680 10784686080 1396944080 14.568 100 25 48 0 1450617920 46220512 7453328
17:57:37 17074 8192000000 10325840720 10761367552 1387221008 14.481 99 38 77 2 1421282352 24813968 9247376
17:59:00 59803 8192000000 10317511776 10763124736 1405528432 14.644 100 35 65 1 1427964896 14832736 7603728
18:01:32 15438 8192000000 10315549312 10760380416 1405791312 14.647 100 46 86 1 1422621760 7341408 9489040
18:02:54 55239 8192000000 10321609120 10771001344 1408915968 14.674 100 34 69 1 1425468640 8088096 8464576
18:04:53 45525 8192000000 10310429056 10770276352 1399288272 14.589 99 19 37 0 1414667248 10606224 4772752
18:06:47 76865 8192000000 10305531552 10768969728 1409854816 14.683 100 19 38 0 1425861488 11608448 4398224
18:09:07 73727 8192000000 10300805296 10749468672 1352664320 14.171 96 41 81 0 1370931552 8961616 9305616
18:11:25 86524 8192000000 10288706432 10744451072 1343605856 14.090 96 17 34 0 1363935024 15961568 4367600
18:15:25 36276 8192000000 10319512208 10776682496 1398918688 14.585 99 47 94 1 1426840672 16465248 11456736
18:17:08 50260 8192000000 10276335072 10742677504 1366233776 14.293 98 9 18 0 1378220000 9916144 2070080
18:18:59 71533 8192000000 10292180800 10750779392 1373431312 14.358 98 26 48 0 1389319792 9885184 6003296
18:21:22 68424 8192000000 10266246608 10726514688 1349812576 14.146 97 10 20 1 1363791696 11764880 2214240
18:23:35 67115 8192000000 10282149920 10728542208 1322485360 13.899 96 15 30 0 1341045424 15397808 3162256
18:25:50 60457 8192000000 10272946176 10725437440 1330612608 13.973 97 18 36 1 1349100336 14691168 3796560
18:27:55 30993 8192000000 10276215696 10709946368 1338985024 14.048 98 37 73 0 1360230480 13001008 8244448
18:29:27 53275 8192000000 10270803152 10724732928 1356402208 14.205 99 18 36 0 1377288432 16992928 3893296
18:31:22 30427 8192000000 10253302912 10689486848 1267281984 13.397 93 29 59 1 1285321552 11605024 6434544
18:32:56 70948 8192000000 10250542768 10691956736 1288559264 13.591 95 30 60 0 1312112288 17201072 6351952
18:35:07 79314 8192000000 10255448240 10706825216 1290474848 13.609 95 23 46 0 1309973728 14682032 4816848
18:37:30 97922 8192000000 10276713280 10719272960 1362195360 14.257 100 23 46 0 1383712528 16007008 5510160
18:40:11 47087 8192000000 10279131328 10730881024 1376433632 14.385 100 16 32 1 1388819888 9151504 3234752
18:41:59 30583 8192000000 10283826064 10731757568 1377591680 14.395 100 33 66 0 1396696144 11917504 7186960
18:43:33 40486 8192000000 10281159168 10736492544 1387269264 14.481 100 12 25 1 1396814640 6633648 2911728
18:45:19 40444 8192000000 10274109280 10724999168 1365579728 14.287 99 20 40 0 1379670400 9586112 4504560
18:47:00 65256 8192000000 10288810496 10743566336 1370156032 14.328 99 12 24 0 1388636400 15521104 2959264
18:49:08 71760 8192000000 10308257552 10770591744 1399551168 14.591 100 16 32 0 1421020416 17537488 3931760
18:51:25 69677 8192000000 10315661600 10762928128 1401363488 14.607 100 20 40 0 1422295872 16746160 4186224
18:53:38 27548 8192000000 10320875728 10762760192 1392872592 14.531 99 26 52 0 1407415488 8914848 5628048
18:55:08 49258 8192000000 10308370160 10754088960 1380725456 14.423 99 30 60 1 1401814272 14342928 6745888
18:57:01 62014 8192000000 10298862464 10764259328 1356607280 14.207 98 7 14 0 1379607728 21536448 1464000
18:59:04 109396 8192000000 10291401520 10746691584 1377548672 14.395 99 26 52 0 1395416720 11678256 6189792
19:01:59 45427 8192000000 10280667088 10728558592 1350912192 14.156 97 21 42 1 1368445008 12388688 5144128
19:03:46 69104 8192000000 10282342528 10743857152 1375087488 14.373 99 10 20 0 1395797632 18401344 2308800
19:05:57 80594 8192000000 10289843200 10741551104 1370499184 14.332 99 22 45 0 1394198960 18292832 5406944
19:08:28 43133 8192000000 10278479936 10720997376 1333797632 14.001 97 15 28 1 1355714320 18714240 3202448

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 18-02-2024 19:11:12 to 18-02-2024 19:11:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 79 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-02-2024 19:11:26 to 18-02-2024 19:11:28.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          172058
MON$OLDEST_ACTIVE               173763
MON$OLDEST_SNAPSHOT             173763
MON$NEXT_TRANSACTION            173763
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1905248
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Sun Feb 18 19:11:29 2024 
 
Database header page information: 
    Flags            0 
    Generation        90700 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    172058 
    Oldest active        173763 
    Oldest snapshot        173763 
    Next transaction    173764 
    Sequence number        0 
    Next attachment ID    709 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.26, total records: 7752817 
    Average version length: 48.16, total versions: 102658, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86768 
    Data pages: 86768, average fill: 71% 
    Primary pages: 86768, secondary pages: 0, swept pages: 20690 
    Empty pages: 2, full pages: 60468 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 187 
    40 - 59% = 2210 
    60 - 79% = 84319 
    80 - 99% = 28 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23299, nodes: 7752817 
    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: 1710193, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 346 
        20 - 39% = 1802 
        40 - 59% = 4137 
        60 - 79% = 2315 
        80 - 99% = 14699 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13517, nodes: 7752817 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1533326, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1638 
        40 - 59% = 1974 
        60 - 79% = 1051 
        80 - 99% = 8852 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8358, nodes: 7752817 
    Average node length: 6.62, total dup: 5796324, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1526371, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 992 
        40 - 59% = 1370 
        60 - 79% = 871 
        80 - 99% = 4989 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.06, total records: 2247087 
    Average version length: 34.68, total versions: 107582, max versions: 3 
    Average fragment length: 5.67, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28368 
    Data pages: 28368, average fill: 74% 
    Primary pages: 28362, secondary pages: 6, swept pages: 9621 
    Empty pages: 7, full pages: 20717 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 110 
    40 - 59% = 1450 
    60 - 79% = 25919 
    80 - 99% = 862 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4559, nodes: 2247087 
    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: 697641, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 933 
        40 - 59% = 839 
        60 - 79% = 688 
        80 - 99% = 2099 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2511, nodes: 2250065 
    Average node length: 4.97, total dup: 2249166, max dup: 17638 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1244471, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 269 
        40 - 59% = 1512 
        60 - 79% = 519 
        80 - 99% = 210 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2023, nodes: 2247087 
    Average node length: 4.97, total dup: 2247037, max dup: 130186 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1058611, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 49 
        40 - 59% = 1090 
        60 - 79% = 49 
        80 - 99% = 833 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4331, nodes: 2247087 
    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: 697641, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 579 
        40 - 59% = 589 
        60 - 79% = 798 
        80 - 99% = 2264 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.62, total records: 400 
    Average version length: 22.75, total versions: 235658, max versions: 615 
    Average fragment length: 2.05, total fragments: 39, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1296 
    Data pages: 1296, average fill: 90% 
    Primary pages: 14, secondary pages: 1282, swept pages: 0 
    Empty pages: 7, full pages: 1288 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1288 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 4.91, total records: 158317 
    Average version length: 68.29, total versions: 146936, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 17.92 
    Pointer pages: 7, data page slots: 3064 
    Data pages: 2608, average fill: 76% 
    Primary pages: 2607, secondary pages: 1, swept pages: 0 
    Empty pages: 203, full pages: 1994 
    Fill distribution: 
     0 - 19% = 277 
    20 - 39% = 131 
    40 - 59% = 113 
    60 - 79% = 203 
    80 - 99% = 1884 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708118, depth: 3, leaf buckets: 427, nodes: 158317 
    Average node length: 13.35, total dup: 11383, max dup: 2 
    Average key length: 10.60, compression ratio: 2.55 
    Average prefix length: 19.32, average data length: 7.68 
    Clustering factor: 113905, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 149 
        60 - 79% = 247 
        80 - 99% = 14 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 17365, max versions: 958 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 87% 
    Primary pages: 3, secondary pages: 61, swept pages: 0 
    Empty pages: 2, full pages: 61 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 59 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 1.40, total records: 2606 
    Average version length: 43.61, total versions: 2524, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 41.30 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 63% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 19 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 23 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90687, depth: 2, leaf buckets: 4, nodes: 2606 
    Average node length: 4.07, total dup: 2508, max dup: 301 
    Average key length: 2.40, compression ratio: 7.92 
    Average prefix length: 18.64, average data length: 0.36 
    Clustering factor: 1334, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.15, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.88, total records: 822427 
    Average version length: 25.87, total versions: 75948, max versions: 4 
    Average fragment length: 28.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8232 
    Data pages: 8224, average fill: 70% 
    Primary pages: 8204, secondary pages: 20, swept pages: 1397 
    Empty pages: 74, full pages: 7384 
    Fill distribution: 
     0 - 19% = 156 
    20 - 39% = 105 
    40 - 59% = 123 
    60 - 79% = 7550 
    80 - 99% = 290 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 908, nodes: 822427 
    Average node length: 4.87, total dup: 822378, max dup: 152919 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89740, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 107 
        40 - 59% = 536 
        60 - 79% = 204 
        80 - 99% = 58 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 971, nodes: 822427 
    Average node length: 5.88, total dup: 732048, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161739, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 82 
        40 - 59% = 483 
        60 - 79% = 123 
        80 - 99% = 279 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1003, nodes: 822427 
    Average node length: 5.88, total dup: 732048, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163717, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 186 
        40 - 59% = 423 
        60 - 79% = 99 
        80 - 99% = 293 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1155, nodes: 822427 
    Average node length: 5.96, total dup: 732048, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156527, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 211 
        40 - 59% = 655 
        60 - 79% = 200 
        80 - 99% = 89 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5412 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.70, total fragments: 67, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 77, secondary pages: 19, swept pages: 50 
    Empty pages: 16, full pages: 65 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5412 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.02 
    Average prefix length: 34.32, average data length: 1.54 
    Clustering factor: 5010, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5412 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 151, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.17, total records: 79033 
    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: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 762 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 762 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34645, depth: 2, leaf buckets: 101, nodes: 79033 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3194, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 148.95, total records: 171254 
    Average version length: 151.36, total versions: 1975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 5576 
    Data pages: 4128, average fill: 85% 
    Primary pages: 4127, secondary pages: 1, swept pages: 6 
    Empty pages: 64, full pages: 4039 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 10 
    80 - 99% = 4035 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 125.66, total records: 185226 
    Average version length: 154.82, total versions: 30571, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.50 
    Pointer pages: 7, data page slots: 6000 
    Data pages: 4464, average fill: 87% 
    Primary pages: 4464, secondary pages: 0, swept pages: 6 
    Empty pages: 57, full pages: 4386 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 4385 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 150.32, total records: 175762 
    Average version length: 140.83, total versions: 797, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 7, data page slots: 4776 
    Data pages: 4208, average fill: 86% 
    Primary pages: 4208, secondary pages: 0, swept pages: 2 
    Empty pages: 36, full pages: 4157 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4156 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 150.39, total records: 167278 
    Average version length: 139.88, total versions: 600, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 7, data page slots: 4408 
    Data pages: 3976, average fill: 87% 
    Primary pages: 3976, secondary pages: 0, swept pages: 3 
    Empty pages: 11, full pages: 3954 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3954 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 147.39, total records: 170104 
    Average version length: 151.83, total versions: 4189, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 6, data page slots: 5360 
    Data pages: 4112, average fill: 85% 
    Primary pages: 4112, secondary pages: 0, swept pages: 5 
    Empty pages: 68, full pages: 4022 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 5 
    40 - 59% = 11 
    60 - 79% = 6 
    80 - 99% = 4020 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 149.44, total records: 170230 
    Average version length: 148.43, total versions: 1517, 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: 6, data page slots: 5280 
    Data pages: 4064, average fill: 86% 
    Primary pages: 4064, secondary pages: 0, swept pages: 2 
    Empty pages: 28, full pages: 4020 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4020 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 133.16, total records: 204971 
    Average version length: 154.94, total versions: 24431, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.74 
    Pointer pages: 7, data page slots: 6216 
    Data pages: 4936, average fill: 87% 
    Primary pages: 4936, secondary pages: 0, swept pages: 2 
    Empty pages: 50, full pages: 4863 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 6 
    40 - 59% = 10 
    60 - 79% = 6 
    80 - 99% = 4862 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 142.16, total records: 186832 
    Average version length: 154.07, total versions: 11134, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 8, data page slots: 5000 
    Data pages: 4480, average fill: 86% 
    Primary pages: 4480, secondary pages: 0, swept pages: 5 
    Empty pages: 40, full pages: 4429 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4428 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 132.03, total records: 198528 
    Average version length: 154.53, total versions: 24746, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.85 
    Pointer pages: 7, data page slots: 6496 
    Data pages: 4800, average fill: 86% 
    Primary pages: 4800, secondary pages: 0, swept pages: 2 
    Empty pages: 76, full pages: 4703 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4703 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.95, total records: 180359 
    Average version length: 152.47, total versions: 4942, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 7, data page slots: 5952 
    Data pages: 4416, average fill: 84% 
    Primary pages: 4416, secondary pages: 0, swept pages: 3 
    Empty pages: 120, full pages: 4261 
    Fill distribution: 
     0 - 19% = 124 
    20 - 39% = 13 
    40 - 59% = 8 
    60 - 79% = 12 
    80 - 99% = 4259 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.62, total records: 2097459 
    Average version length: 52.91, total versions: 44903, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25568 
    Data pages: 25568, average fill: 71% 
    Primary pages: 25568, secondary pages: 0, swept pages: 10959 
    Empty pages: 268, full pages: 20154 
    Fill distribution: 
     0 - 19% = 557 
    20 - 39% = 454 
    40 - 59% = 1251 
    60 - 79% = 22906 
    80 - 99% = 400 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2598, nodes: 2097459 
    Average node length: 5.44, total dup: 1957350, max dup: 1396 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181244, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 284 
        40 - 59% = 1762 
        60 - 79% = 269 
        80 - 99% = 280 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2754, nodes: 2097459 
    Average node length: 5.69, total dup: 1882491, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 374526, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2446 
        60 - 79% = 271 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2134, nodes: 2097459 
    Average node length: 4.96, total dup: 2097359, max dup: 27377 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179033, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 212 
        40 - 59% = 1120 
        60 - 79% = 363 
        80 - 99% = 433 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 34.93, total records: 159475 
    Average version length: 69.17, total versions: 79022, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.61 
    Pointer pages: 3, data page slots: 4096 
    Data pages: 3032, average fill: 62% 
    Primary pages: 3032, secondary pages: 0, swept pages: 393 
    Empty pages: 513, full pages: 2038 
    Fill distribution: 
     0 - 19% = 653 
    20 - 39% = 116 
    40 - 59% = 139 
    60 - 79% = 598 
    80 - 99% = 1526 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 100021, depth: 3, leaf buckets: 230, nodes: 159475 
    Average node length: 6.45, total dup: 138776, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 26926, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 23 
        40 - 59% = 118 
        60 - 79% = 66 
        80 - 99% = 21 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.74, total records: 7200214 
    Average version length: 68.75, total versions: 440167, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 63, data page slots: 102040 
    Data pages: 102040, average fill: 75% 
    Primary pages: 102040, secondary pages: 0, swept pages: 23945 
    Empty pages: 5, full pages: 85572 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 411 
    40 - 59% = 3580 
    60 - 79% = 90106 
    80 - 99% = 7879 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10736, nodes: 7200214 
    Average node length: 6.51, total dup: 6225159, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1604028, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1410 
        40 - 59% = 5845 
        60 - 79% = 3046 
        80 - 99% = 429 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8662, nodes: 7200214 
    Average node length: 5.39, total dup: 6915111, max dup: 176 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1400367, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1024 
        40 - 59% = 5083 
        60 - 79% = 1571 
        80 - 99% = 974 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8756, nodes: 7200214 
    Average node length: 5.39, total dup: 6915111, max dup: 176 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1402973, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1127 
        40 - 59% = 5093 
        60 - 79% = 1570 
        80 - 99% = 961 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.16, total records: 12160546 
    Average version length: 68.72, total versions: 314829, 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: 104, data page slots: 168888 
    Data pages: 168888, average fill: 76% 
    Primary pages: 168888, secondary pages: 0, swept pages: 80258 
    Empty pages: 5, full pages: 157590 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 350 
    40 - 59% = 2865 
    60 - 79% = 159946 
    80 - 99% = 5691 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18431, nodes: 12160546 
    Average node length: 6.59, total dup: 10595539, max dup: 73 
    Average key length: 3.43, compression ratio: 12.24 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2390813, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 2026 
        40 - 59% = 10930 
        60 - 79% = 4760 
        80 - 99% = 682 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 41.68, total records: 1593967 
    Average version length: 69.09, total versions: 633227, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.02 
    Pointer pages: 27, data page slots: 43104 
    Data pages: 28320, average fill: 65% 
    Primary pages: 28320, secondary pages: 0, swept pages: 7780 
    Empty pages: 2769, full pages: 18216 
    Fill distribution: 
     0 - 19% = 4281 
    20 - 39% = 1852 
    40 - 59% = 1995 
    60 - 79% = 10854 
    80 - 99% = 9338 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2238, nodes: 1593967 
    Average node length: 5.51, total dup: 1529668, max dup: 49 
    Average key length: 2.56, compression ratio: 16.40 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 104903, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 608 
        40 - 59% = 1150 
        60 - 79% = 410 
        80 - 99% = 62 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.22, total records: 1241220 
    Average version length: 69.09, total versions: 607751, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.58 
    Pointer pages: 23, data page slots: 37016 
    Data pages: 28464, average fill: 51% 
    Primary pages: 28464, secondary pages: 0, swept pages: 6512 
    Empty pages: 6479, full pages: 14345 
    Fill distribution: 
     0 - 19% = 9302 
    20 - 39% = 2140 
    40 - 59% = 1760 
    60 - 79% = 3182 
    80 - 99% = 12080 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1622, nodes: 1241220 
    Average node length: 5.80, total dup: 1157441, max dup: 99 
    Average key length: 2.86, compression ratio: 14.67 
    Average prefix length: 41.20, average data length: 0.80 
    Clustering factor: 169001, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 257 
        40 - 59% = 791 
        60 - 79% = 422 
        80 - 99% = 146 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.34, total records: 9160150 
    Average version length: 68.96, total versions: 472251, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 89, data page slots: 144096 
    Data pages: 144056, average fill: 68% 
    Primary pages: 144056, secondary pages: 0, swept pages: 60145 
    Empty pages: 441, full pages: 72597 
    Fill distribution: 
     0 - 19% = 1394 
    20 - 39% = 5968 
    40 - 59% = 24016 
    60 - 79% = 106366 
    80 - 99% = 6312 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13509, nodes: 9160150 
    Average node length: 6.68, total dup: 7597273, max dup: 29 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1959065, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1260 
        40 - 59% = 7005 
        60 - 79% = 4729 
        80 - 99% = 513 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21128529 
    Average version length: 82.78, total versions: 9597, 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: 318552 
    Data pages: 318552, average fill: 81% 
    Primary pages: 318552, secondary pages: 0, swept pages: 13094 
    Empty pages: 43, full pages: 317412 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 58 
    40 - 59% = 132 
    60 - 79% = 27858 
    80 - 99% = 290430 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19404, nodes: 21128529 
    Average node length: 5.72, total dup: 20647968, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276688, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8233 
        60 - 79% = 528 
        80 - 99% = 10636 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17154, nodes: 21128529 
    Average node length: 6.31, total dup: 18567043, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 912452, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 5 
        40 - 59% = 778 
        60 - 79% = 277 
        80 - 99% = 16090 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21180, nodes: 21128529 
    Average node length: 6.35, total dup: 18486635, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571057, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8476 
        60 - 79% = 597 
        80 - 99% = 12102 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16016, nodes: 21128529 
    Average node length: 5.56, total dup: 21128429, max dup: 229257 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941306, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 9 
        40 - 59% = 2743 
        60 - 79% = 391 
        80 - 99% = 12871 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.84, total records: 9555673 
    Average version length: 82.59, total versions: 413564, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 104, data page slots: 168848 
    Data pages: 168808, average fill: 70% 
    Primary pages: 168808, secondary pages: 0, swept pages: 79846 
    Empty pages: 544, full pages: 93215 
    Fill distribution: 
     0 - 19% = 1610 
    20 - 39% = 7144 
    40 - 59% = 26231 
    60 - 79% = 77777 
    80 - 99% = 56046 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11331, nodes: 9555673 
    Average node length: 5.36, total dup: 9247912, max dup: 208 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2098272, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 70 
        40 - 59% = 8551 
        60 - 79% = 2649 
        80 - 99% = 55 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13417, nodes: 9555673 
    Average node length: 6.23, total dup: 7921599, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1449022, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 118 
        20 - 39% = 4038 
        40 - 59% = 4303 
        60 - 79% = 2603 
        80 - 99% = 2355 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12644, nodes: 9555673 
    Average node length: 5.98, total dup: 8286779, max dup: 36 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2287491, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 65 
        40 - 59% = 9658 
        60 - 79% = 2845 
        80 - 99% = 75 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10015, nodes: 9555673 
    Average node length: 5.13, total dup: 9555573, max dup: 152509 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1488080, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1292 
        40 - 59% = 4903 
        60 - 79% = 1738 
        80 - 99% = 2042 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.70, total records: 11203115 
    Average version length: 82.53, total versions: 353410, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 117, data page slots: 189936 
    Data pages: 188456, average fill: 73% 
    Primary pages: 188456, secondary pages: 0, swept pages: 70879 
    Empty pages: 3009, full pages: 141403 
    Fill distribution: 
     0 - 19% = 4999 
    20 - 39% = 7143 
    40 - 59% = 17251 
    60 - 79% = 43948 
    80 - 99% = 115115 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13117, nodes: 11203115 
    Average node length: 5.29, total dup: 11093390, max dup: 642 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2335248, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 90 
        40 - 59% = 9538 
        60 - 79% = 3402 
        80 - 99% = 87 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10367, nodes: 11203115 
    Average node length: 5.49, total dup: 10713202, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 705182, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 886 
        40 - 59% = 2551 
        60 - 79% = 1841 
        80 - 99% = 4948 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15003, nodes: 11203115 
    Average node length: 6.02, total dup: 9770540, max dup: 66 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2351633, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 106 
        40 - 59% = 11011 
        60 - 79% = 3762 
        80 - 99% = 121 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10705, nodes: 11203115 
    Average node length: 5.21, total dup: 11203015, max dup: 184966 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 694052, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 899 
        40 - 59% = 4701 
        60 - 79% = 1509 
        80 - 99% = 3495 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.18, total records: 9670655 
    Average version length: 82.93, total versions: 415159, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 106, data page slots: 171616 
    Data pages: 171560, average fill: 70% 
    Primary pages: 171560, secondary pages: 0, swept pages: 81771 
    Empty pages: 587, full pages: 94443 
    Fill distribution: 
     0 - 19% = 1677 
    20 - 39% = 7314 
    40 - 59% = 26822 
    60 - 79% = 80119 
    80 - 99% = 55628 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11742, nodes: 9670655 
    Average node length: 5.17, total dup: 9642006, max dup: 1605 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1922890, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1587 
        40 - 59% = 7705 
        60 - 79% = 1845 
        80 - 99% = 576 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13559, nodes: 9670655 
    Average node length: 6.24, total dup: 8016464, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1427608, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 192 
        20 - 39% = 3998 
        40 - 59% = 4268 
        60 - 79% = 2615 
        80 - 99% = 2486 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12397, nodes: 9670655 
    Average node length: 5.43, total dup: 9235828, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2054671, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1552 
        40 - 59% = 8634 
        60 - 79% = 1653 
        80 - 99% = 529 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10170, nodes: 9670655 
    Average node length: 5.14, total dup: 9670555, max dup: 154297 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1518529, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1327 
        40 - 59% = 4962 
        60 - 79% = 1778 
        80 - 99% = 2059 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 573215 
    Average version length: 68.72, total versions: 5618, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7944 
    Data pages: 7944, average fill: 76% 
    Primary pages: 7944, secondary pages: 0, swept pages: 3820 
    Empty pages: 0, full pages: 6694 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 19 
    40 - 59% = 167 
    60 - 79% = 7658 
    80 - 99% = 96 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42103, depth: 3, leaf buckets: 736, nodes: 573215 
    Average node length: 5.94, total dup: 488198, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99889, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 527 
        60 - 79% = 86 
        80 - 99% = 92 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30923, depth: 3, leaf buckets: 748, nodes: 573215 
    Average node length: 6.15, total dup: 470287, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99945, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 512 
        60 - 79% = 97 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 571, nodes: 573215 
    Average node length: 4.86, total dup: 573115, max dup: 9712 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88756, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 331 
        60 - 79% = 99 
        80 - 99% = 111 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Feb 18 19:11:53 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7752817 102658 1 0.0000 0.0000
DOC_LIST 2247087 107582 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 235658 615 58900.0000 0.0000
INVNT_TURNOVER_LOG 158317 146936 1 0.0000 0.0000
MONEY_SALDO 49 17365 958 35400.0000 0.0000
MONEY_TURNOVER_LOG 2606 2524 1 0.0000 0.0000
PDISTR 822427 75948 4 0.0000 0.0000
PERF_SPLIT_0 171254 1975 1 0.0000 0.0000
PERF_SPLIT_1 185226 30571 1 0.0000 0.0000
PERF_SPLIT_2 175762 797 1 0.0000 0.0000
PERF_SPLIT_3 167278 600 1 0.0000 0.0000
PERF_SPLIT_4 170104 4189 1 0.0000 0.0000
PERF_SPLIT_5 170230 1517 1 0.0000 0.0000
PERF_SPLIT_6 204971 24431 1 0.0000 0.0000
PERF_SPLIT_7 186832 11134 1 0.0000 0.0000
PERF_SPLIT_8 198528 24746 1 0.0000 0.0000
PERF_SPLIT_9 180359 4942 1 0.0000 0.0000
PSTORNED 2097459 44903 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 159475 79022 1 0.0000 0.0000
XQD_1000_3300 7200214 440167 1 0.0000 0.0000
XQD_1200_2000 12160546 314829 1 0.0000 0.0000
XQD_2000_3300 1593967 633227 1 0.0000 0.0000
XQD_2100_3300 1241220 607751 1 0.0000 0.0000
XQD_3300_3400 9160150 472251 1 0.0000 0.0000
XQS_1000_1200 21128529 9597 1 0.0000 0.0000
XQS_1000_3300 9555673 413564 1 0.0000 0.0000
XQS_1200_2000 11203115 353410 1 0.0000 0.0000
XQS_2100_3300 9670655 415159 1 0.0000 0.0000
XQS_3300_3400 573215 5618 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 ---
:773: 
:774: mscs-test-161.budzdorov.ru    Sun Feb 18 19:09:34 2024
:775:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:776: 
:777: 
:778: mscs-test-161.budzdorov.ru    Sun Feb 18 19:09:35 2024
:779:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:780: 
:781: 
:782: mscs-test-161.budzdorov.ru    Sun Feb 18 19:09:37 2024
:783:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:784: 
--- end of diff output ---

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

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