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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-25 04:07:50
DTS_END                         2024-03-25 04:07:50.9070
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/48582
TRN_ID                          164049
ATT_ID                          495
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: 8949.64 19239 894964
customer order: creation 166.48 411 16648
customer order: refuse 14.40 363 1440
order to supplier: creation 43.94 1363 4394
order to supplier: removal 3.50 108816 350
invoice (draft): creation 44.98 3287 4498
invoice (draft): removal 50.19 776 5019
invoice accept: apply 40.61 21191 4061
invoice accept: cancel 45.51 762 4551
customer reserve: creation 3841.00 206 384100
customer reserve: removal 4408.99 69 440899
realization accept: apply 80.86 190 8086
realization accept: cancel 84.16 135 8416
payment from customer: creation 58.56 117 5856
payment from customer: removal 5.61 108 561
payment to supplier: creation 46.80 173 4680
payment to supplier: removal 3.38 161 338
service: total inventory turnovers 3.86 3597 386
service: total monetary turnovers 5.99 581 599
service: aggregate perf. data 0.79 15295 79
service: refresh index statistics 0.03 227186 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-03-2024 04:09:02 to 25-03-2024 04:09:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5749
TEST_TIME 2 4557
TEST_TIME 3 4732
TEST_TIME 4 4460
TEST_TIME 5 4153
TEST_TIME 6 4674
TEST_TIME 7 4753
TEST_TIME 8 5082
TEST_TIME 9 5382
TEST_TIME 10 5472
TEST_TIME 11 5767
TEST_TIME 12 5947
TEST_TIME 13 6027
TEST_TIME 14 6195
TEST_TIME 15 6281
TEST_TIME 16 6454
TEST_TIME 17 6747
TEST_TIME 18 6883
TEST_TIME 19 7463
TEST_TIME 20 7836
TEST_TIME 21 8417
TEST_TIME 22 8511
TEST_TIME 23 8850
TEST_TIME 24 9439
TEST_TIME 25 9934
TEST_TIME 26 10204
TEST_TIME 27 10304
TEST_TIME 28 9948
TEST_TIME 29 9706
TEST_TIME 30 9559
TEST_TIME 31 9591
TEST_TIME 32 9411
TEST_TIME 33 9286
TEST_TIME 34 9250
TEST_TIME 35 9220
TEST_TIME 36 9301
TEST_TIME 37 9225
TEST_TIME 38 9041
TEST_TIME 39 8821
TEST_TIME 40 9003
TEST_TIME 41 9082
TEST_TIME 42 9025
TEST_TIME 43 9061
TEST_TIME 44 9139
TEST_TIME 45 9139
TEST_TIME 46 9091
TEST_TIME 47 9069
TEST_TIME 48 9339
TEST_TIME 49 9286
TEST_TIME 50 9393
TEST_TIME 51 9469
TEST_TIME 52 9505
TEST_TIME 53 9469
TEST_TIME 54 9343
TEST_TIME 55 9207
TEST_TIME 56 9294
TEST_TIME 57 9198
TEST_TIME 58 9111
TEST_TIME 59 9088
TEST_TIME 60 9008
TEST_TIME 61 8984
TEST_TIME 62 8997
TEST_TIME 63 9006
TEST_TIME 64 9024
TEST_TIME 65 9040
TEST_TIME 66 9025
TEST_TIME 67 9094
TEST_TIME 68 9110
TEST_TIME 69 9193
TEST_TIME 70 9159
TEST_TIME 71 9271
TEST_TIME 72 9202
TEST_TIME 73 9243
TEST_TIME 74 9173
TEST_TIME 75 9109
TEST_TIME 76 9041
TEST_TIME 77 9044
TEST_TIME 78 8984
TEST_TIME 79 8945
TEST_TIME 80 8944
TEST_TIME 81 8940
TEST_TIME 82 8954
TEST_TIME 83 8963
TEST_TIME 84 8975
TEST_TIME 85 9008
TEST_TIME 86 9090
TEST_TIME 87 9071
TEST_TIME 88 9036
TEST_TIME 89 9149
TEST_TIME 90 9140
TEST_TIME 91 9163
TEST_TIME 92 9170
TEST_TIME 93 9112
TEST_TIME 94 9045
TEST_TIME 95 9059
TEST_TIME 96 9014
TEST_TIME 97 8961
TEST_TIME 98 8964
TEST_TIME 99 8965
TEST_TIME 100 8970

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-03-2024 04:09:06 to 25-03-2024 04:09:09.

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 1246534 1246534 0 0.00 0 20447 7 0 0
doc_list_biud 1246534 1246534 0 0.00 0 52365 30 0 0
sp_add_invoice_to_stock 4150 4061 89 2.14 29 211502 21192 0 89
sp_cancel_adding_invoice 4551 4551 0 0.00 5 61194 763 0 0
sp_cancel_client_order 1440 1440 0 0.00 4 9099 364 0 0
sp_cancel_customer_reserve 440899 440899 0 0.00 0 52376 70 0 0
sp_cancel_pay_from_customer 561 561 0 0.00 2 6572 108 0 0
sp_cancel_pay_to_supplier 338 338 0 0.00 3 14668 162 0 0
sp_cancel_supplier_invoice 5024 5019 5 0.09 2 28588 777 0 5
sp_cancel_supplier_order 350 350 0 0.00 16 1047726 108816 0 0
sp_cancel_write_off 8416 8416 0 0.00 1 14402 136 0 0
sp_client_order 16648 16648 0 0.00 3 33123 411 0 0
sp_customer_reserve 384100 384100 0 0.00 0 53922 206 0 0
sp_fill_shopping_cart 25531 25531 0 0.00 1 20261 42 0 0
sp_fill_shopping_cart_clo_res 384084 384084 0 0.00 0 20001 19 0 0
sp_get_clo_for_invoice 4042 4042 0 0.00 0 26246 410 0 0
sp_kill_cost_storno 13866 13866 0 0.00 0 14664 78 0 0
sp_kill_qstorno_ret_qs2qd 895583 895583 0 0.00 0 52341 37 0 0
sp_kill_qty_storno 472803 472803 0 0.00 0 52364 78 0 0
sp_lock_selected_doc 16825 16825 0 0.00 0 9496 6 0 0
sp_make_cost_storno 22664 22664 0 0.00 0 18410 63 0 0
sp_multiply_rows_for_pdistr 22664 22664 0 0.00 0 12364 37 0 0
sp_multiply_rows_for_qdistr 16648 16648 0 0.00 0 33109 222 0 0
sp_pay_from_customer 5856 5856 0 0.00 4 14254 117 0 0
sp_pay_to_supplier 4680 4680 0 0.00 4 22047 173 0 0
sp_payment_common 10536 10536 0 0.00 1 9857 22 0 0
sp_qd_handle_on_cancel_clo 1440 1440 0 0.00 0 9054 333 0 0
sp_qd_handle_on_invoice_upd_sts 8593 8593 0 0.00 0 21111 321 0 0
sp_qd_handle_on_reserve_upd_sts 8086 8086 0 0.00 0 19436 62 0 0
sp_reserve_write_off 8086 8086 0 0.00 6 19647 190 0 0
sp_supplier_invoice 4498 4498 0 0.00 5 92693 3288 0 0
sp_supplier_order 4394 4394 0 0.00 5 48095 1363 0 0
srv_aggregate_perf_data 80 79 1 1.25 1423 120886 15295 0 1
srv_fill_mon_cache_memory 55 55 0 0.00 1296 119382 40328 0 0
srv_find_qd_qs_mism 853960 853960 0 0.00 0 20447 6 0 0
srv_make_invnt_saldo 386 386 0 0.00 57 115427 3597 0 0
srv_make_money_saldo 599 599 0 0.00 1 11396 582 0 0
srv_recalc_idx_stat 3 3 0 0.00 128999 277524 227186 0 0
t$perf-abend:sp_add_invoice_to_stock 89 89 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4061 4061 0 0.00 0 16844 180 0 0
t$perf-norm:sp_cancel_adding_invoice 329 329 0 0.00 1 2212 87 0 0
t$perf-norm:sp_cancel_client_order 1440 1440 0 0.00 0 4546 13 0 0
t$perf-norm:sp_cancel_customer_reserve 558 558 0 0.00 0 8193 24 0 0
t$perf-norm:sp_cancel_pay_from_customer 561 561 0 0.00 0 183 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 338 338 0 0.00 0 344 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 326 326 0 0.00 0 3080 27 0 0
t$perf-norm:sp_cancel_supplier_order 350 350 0 0.00 0 34108 1723 0 0
t$perf-norm:sp_cancel_write_off 796 796 0 0.00 0 3266 19 0 0
t$perf-norm:sp_client_order 16648 16648 0 0.00 0 8150 17 0 0
t$perf-norm:sp_customer_reserve 834 834 0 0.00 0 5036 16 0 0
t$perf-norm:sp_pay_from_customer 5856 5856 0 0.00 0 12530 14 0 0
t$perf-norm:sp_pay_to_supplier 4680 4680 0 0.00 0 9974 14 0 0
t$perf-norm:sp_reserve_write_off 8086 8086 0 0.00 0 16553 14 0 0
t$perf-norm:sp_supplier_invoice 4498 4498 0 0.00 0 10325 19 0 0
t$perf-norm:sp_supplier_order 4394 4394 0 0.00 0 8159 21 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 390 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 67 2 0 0
t$perf-norm:srv_make_invnt_saldo 386 386 0 0.00 0 492 8 0 0
t$perf-norm:srv_make_money_saldo 599 599 0 0.00 0 1581 8 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8260 8082 178 2.15 0 10505 16 0 178
v_all_customers 31114 31114 0 0.00 0 21 1 0 0
v_all_suppliers 25152 25152 0 0.00 0 20 1 0 0
v_all_wares 33292 33292 0 0.00 0 81 1 0 0
v_cancel_adding_invoice 658 658 0 0.00 0 499 7 0 0
v_cancel_client_order 2880 2880 0 0.00 0 3849 6 0 0
v_cancel_customer_prepayment 1122 1122 0 0.00 0 3104 10 0 0
v_cancel_customer_reserve 1116 1116 0 0.00 0 3107 11 0 0
v_cancel_payment_to_supplier 676 676 0 0.00 0 3836 18 0 0
v_cancel_supplier_invoice 662 652 10 1.51 0 129 10 0 10
v_cancel_supplier_order 700 700 0 0.00 0 1040 5 0 0
v_cancel_write_off 1592 1592 0 0.00 0 9688 24 0 0
v_max_id_clo_ord 4393 4393 0 0.00 0 243 1 0 0
v_max_id_clo_res 834 834 0 0.00 0 1323 10 0 0
v_max_id_ord_sup 4492 4492 0 0.00 0 3465 4 0 0
v_max_non_paid_invoice 989 989 0 0.00 0 37 2 0 0
v_max_non_paid_realizn 2807 2807 0 0.00 0 1663 4 0 0
v_min_id_clo_ord 4393 4393 0 0.00 0 2358 5 0 0
v_min_id_clo_res 834 834 0 0.00 0 5715 12 0 0
v_min_id_ord_sup 4492 4492 0 0.00 0 4953 11 0 0
v_min_non_paid_invoice 4680 4680 0 0.00 0 5643 14 0 0
v_min_non_paid_realizn 5856 5856 0 0.00 0 9853 17 0 0
v_our_firm 8276 8276 0 0.00 0 22 1 0 0
v_reserve_write_off 16172 16172 0 0.00 0 12880 8 0 0
x_lock_depdocs_on_canc_invoice 9244 9244 0 0.00 0 13748 122 0 0
x_lock_depdocs_on_canc_sup_ord 350 350 0 0.00 0 9261 398 0 0
x_make_qstorno_1000_1200 4394 4394 0 0.00 1 48085 1292 0 0
x_make_qstorno_1200_2000 4498 4498 0 0.00 2 81884 3118 0 0
x_make_qstorno_2100_3300 384100 384100 0 0.00 0 53899 185 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 25-03-2024 04:09:10 to 25-03-2024 04:09:15.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
02:07:54 3 8192000000 8800613392 8812486656 6271968 0.076 2 2 3 0 6412784 79456 61360
02:08:55 16421 8192000000 9699616144 9996812288 776908880 8.662 100 86 172 0 805970816 7273472 21788464
02:10:17 11970 8192000000 9738722928 10043805696 815545152 9.054 100 92 184 0 847465936 10435696 21485088
02:11:35 25369 8192000000 9784612000 10099466240 855975680 9.460 100 85 170 0 891232448 16033744 19223024
02:13:03 12305 8192000000 9830829440 10162806784 890196720 9.801 100 77 154 0 943112880 36576592 16339568
02:14:21 11733 8192000000 9879058704 10221445120 926064240 10.156 100 82 164 0 992884928 48918480 17902208
02:15:35 5627 8192000000 9939683856 10290917376 964516336 10.533 100 78 154 0 1045901056 65791696 15593024
02:16:46 3619 8192000000 9978086656 10335608832 997871744 10.858 100 84 167 0 1088987648 74673264 16442640
02:17:51 2062 8192000000 9998149296 10366038016 1024828144 11.119 100 84 163 1 1111476688 70379312 16269232
02:18:55 3728 8192000000 10023515312 10395484160 1035733376 11.224 100 84 167 0 1134177280 82881808 15562096
02:20:01 1153 8192000000 10050306688 10427269120 1060912992 11.465 100 91 176 0 1154050848 75894848 17243008
02:21:04 26686 8192000000 10019879360 10404048896 1071432528 11.566 100 56 110 0 1132475472 50334176 10708768
02:22:32 11445 8192000000 9987988880 10390663168 1075586928 11.605 100 24 48 0 1095858624 14975824 5295872
02:23:45 6385 8192000000 9984693392 10401062912 1082942048 11.675 100 26 53 0 1114422624 26260000 5220576
02:24:53 7912 8192000000 9990872912 10405580800 1087096128 11.715 100 27 54 0 1117030816 24533296 5401392
02:26:02 6872 8192000000 9989359360 10386022400 1083049296 11.677 99 33 62 0 1102356784 12064976 7242512
02:27:09 19872 8192000000 10023083920 10423312384 1094749600 11.788 100 64 123 1 1129113936 20475424 13888912
02:28:35 10307 8192000000 10041708768 10445492224 1111459520 11.946 100 54 103 2 1153654048 31887152 10307376
02:29:57 23584 8192000000 10092334192 10498211840 1099497536 11.833 98 47 91 1 1179144592 70365792 9281264
02:31:28 34110 8192000000 10106899056 10512412672 1121883936 12.045 99 46 91 0 1199509888 67900944 9725008
02:33:03 27116 8192000000 10141197152 10555125760 1134015152 12.159 100 41 82 0 1273201152 130828928 8357072
02:34:45 15214 8192000000 10167439328 10585673728 1132700640 12.147 100 38 76 0 1282038496 141192544 8145312
02:36:08 6255 8192000000 10154979968 10565672960 1123741856 12.062 100 43 86 0 1271699056 138502752 9454448
02:37:21 37100 8192000000 10154324208 10559496192 1072231232 11.573 96 36 72 0 1252569792 172308352 8030208
02:39:02 8391 8192000000 10207471904 10607550464 1124170400 12.066 100 55 106 0 1302464528 167545168 10748960
02:40:21 1599 8192000000 10267775888 10666033152 1134432096 12.163 100 68 131 0 1365224080 217073632 13718352
02:41:29 1292 8192000000 10266241376 10655780864 1124140688 12.066 99 78 153 1 1367292544 226516400 16635456
02:42:35 2769 8192000000 10330903104 10736193536 1134003104 12.159 100 60 119 0 1437110016 289753648 13353264
02:43:40 2269 8192000000 10368803136 10773491712 1137643056 12.193 100 65 127 0 1472313920 320150416 14520448
02:44:47 1887 8192000000 10429533984 10828038144 1143631856 12.250 100 85 168 0 1532109952 369476336 19001760
02:45:53 1425 8192000000 10471161024 10884136960 1151680032 12.325 100 88 175 0 1565921696 393877120 20364544
02:46:58 3134 8192000000 10434616544 10845638656 1156956864 12.375 100 78 151 1 1528867392 354293888 17616640
02:48:07 13973 8192000000 10401299008 10837585920 1165173376 12.452 100 57 114 0 1516355248 337857408 13324464
02:49:33 12031 8192000000 10361995264 10802741248 1158627456 12.390 100 41 82 0 1460883808 291829840 10426512
02:50:52 24673 8192000000 10286402992 10811584512 1143911872 12.252 100 21 42 0 1459320992 309911072 5498048
02:52:19 35968 8192000000 10124302608 10655723520 1113670368 11.967 99 9 18 0 1243777312 128101200 2005744
02:53:57 85668 8192000000 10026726240 10462887936 1082317856 11.670 97 35 68 1 1159639184 70579120 6742208
02:56:40 47389 8192000000 10087740912 10512662528 1110930512 11.941 99 54 104 1 1157134416 35666224 10537680
02:58:31 44103 8192000000 10039348096 10478866432 1111625568 11.948 99 20 42 0 1146078912 29597040 4856304
03:01:16 44728 8192000000 10102647376 10552766464 1129695696 12.118 100 14 28 0 1213860992 81229376 2935920
03:03:06 29953 8192000000 10074863936 10520395776 1133891536 12.158 100 17 34 0 1182234096 44762656 3579904
03:04:38 78262 8192000000 10132971408 10607312896 1143602448 12.249 100 13 26 0 1223804240 77329504 2872288
03:07:21 62242 8192000000 10086134896 10656890880 1142667120 12.241 100 5 10 0 1237225040 93577120 980800
03:09:43 50568 8192000000 10108034112 10563829760 1145096752 12.263 100 29 58 0 1187210944 36814416 5299776
03:12:09 38105 8192000000 10106510800 10547744768 1149001248 12.300 100 33 63 0 1210584576 54970208 6613120
03:13:52 58338 8192000000 10155584768 10602754048 1142908752 12.243 99 29 58 0 1223128432 74316032 5903648
03:15:50 86419 8192000000 10151896352 10606071808 1117456352 12.003 97 21 42 0 1200674256 78841648 4376256
03:18:21 59631 8192000000 10078593392 10579902464 1084313728 11.689 95 25 50 0 1157236640 67543728 5379184
03:20:25 59200 8192000000 10048168688 10478559232 1077219872 11.621 95 36 71 0 1103384816 18661184 7503760
03:22:25 73154 8192000000 10088998176 10544365568 1095254016 11.793 97 30 60 0 1178820176 77356416 6209744
03:24:56 54889 8192000000 10057918080 10502479872 1118123312 12.009 100 12 24 0 1157883312 37297696 2462304
03:27:52 39483 8192000000 10021934608 10474430464 1069500576 11.547 98 12 24 0 1108857600 36964064 2392960
03:29:44 77749 8192000000 10018261936 10451513344 1052774592 11.387 96 15 30 1 1091181216 35492864 2913760
03:32:02 80881 8192000000 10000661904 10458112000 1011514672 10.990 92 13 26 0 1064068320 50030784 2522864
03:34:29 50855 8192000000 10029857248 10458988544 1042134928 11.285 96 19 38 0 1106228272 60457952 3635392
03:36:20 46805 8192000000 10024708080 10458849280 1047754048 11.339 96 17 34 0 1080127184 29096384 3276752
03:38:08 30688 8192000000 10077581888 10508197888 1071379392 11.565 98 47 92 1 1165248944 85239872 8629680
03:39:40 23811 8192000000 10056843920 10466373632 1098794928 11.826 100 46 92 0 1140167280 33021328 8351024
03:41:07 119381 8192000000 10062800640 10511757312 1095054160 11.791 99 25 50 0 1144274272 43494832 5725280
03:44:43 51340 8192000000 10028973840 10470092800 1086422592 11.709 98 12 24 1 1131233824 42505168 2306064
03:46:37 59609 8192000000 10068871184 10541842432 1114375168 11.974 100 13 26 1 1196406400 79474736 2556496
03:48:37 25806 8192000000 10092784976 10522324992 1109337440 11.926 99 43 79 1 1169202016 51371184 8493392
03:50:28 34489 8192000000 10110514704 10560942080 1123210576 12.057 100 18 36 0 1219618768 92481664 3926528
03:52:03 61875 8192000000 10107662656 10561167360 1114427552 11.974 99 30 60 1 1184726432 63793744 6505136
03:54:06 44421 8192000000 10060683472 10485657600 1119292464 12.020 99 34 66 0 1147767888 22058416 6417008
03:55:51 15263 8192000000 10100486576 10542383104 1122102368 12.047 99 48 95 0 1203553712 70136416 11314928
03:57:20 69718 8192000000 10074107648 10513739776 1104560880 11.881 97 32 65 0 1146634480 35327376 6746224
03:59:30 54410 8192000000 10069219584 10572988416 1130407392 12.125 100 8 14 0 1184476160 52518640 1550128
04:01:36 26710 8192000000 10073238144 10509803520 1124355536 12.068 100 40 80 0 1169785664 37855184 7574944
04:03:03 68440 8192000000 10038827968 10490720256 1094425744 11.785 97 10 20 1 1122284304 25839488 2019072
04:05:14 40341 8192000000 10060953952 10541907968 1125821600 12.082 100 9 18 0 1169453440 41478976 2152864
04:06:56 60169 8192000000 9651426816 10052481024 751576752 8.403 66 15 30 0 802106800 47655664 2874384

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 25-03-2024 04:09:17 to 25-03-2024 04:09:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 89 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-03-2024 04:09:32 to 25-03-2024 04:09:34.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Mon Mar 25 04:09:35 2024 
 
Database header page information: 
    Flags            0 
    Generation        85773 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    163282 
    Oldest active        164289 
    Oldest snapshot        164289 
    Next transaction    164290 
    Sequence number        0 
    Next attachment ID    672 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.59, total records: 7649550 
    Average version length: 48.16, total versions: 58315, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87968 
    Data pages: 87968, average fill: 69% 
    Primary pages: 87967, secondary pages: 1, swept pages: 43053 
    Empty pages: 6, full pages: 64947 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 41 
    40 - 59% = 1459 
    60 - 79% = 86412 
    80 - 99% = 43 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 22826, nodes: 7649550 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.14, average data length: 12.86 
    Clustering factor: 1646779, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 288 
        20 - 39% = 1763 
        40 - 59% = 3802 
        60 - 79% = 2595 
        80 - 99% = 14378 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13297, nodes: 7649550 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1470898, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1551 
        40 - 59% = 1882 
        60 - 79% = 1164 
        80 - 99% = 8700 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8148, nodes: 7649550 
    Average node length: 6.59, total dup: 5751314, max dup: 49 
    Average key length: 3.61, compression ratio: 2.50 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1463885, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 920 
        40 - 59% = 1265 
        60 - 79% = 1008 
        80 - 99% = 4851 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.73, total records: 2186967 
    Average version length: 58.85, total versions: 30992, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28264 
    Data pages: 28264, average fill: 71% 
    Primary pages: 28262, secondary pages: 2, swept pages: 11582 
    Empty pages: 0, full pages: 18605 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 92 
    40 - 59% = 1280 
    60 - 79% = 26832 
    80 - 99% = 39 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4434, nodes: 2186967 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 666987, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 869 
        40 - 59% = 792 
        60 - 79% = 769 
        80 - 99% = 2003 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2377, nodes: 2188134 
    Average node length: 4.97, total dup: 2187235, max dup: 18331 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1241040, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 214 
        40 - 59% = 1401 
        60 - 79% = 514 
        80 - 99% = 247 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1750, nodes: 2186967 
    Average node length: 4.97, total dup: 2186917, max dup: 129878 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1043909, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 612 
        60 - 79% = 54 
        80 - 99% = 1078 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4238, nodes: 2186967 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 666987, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 82 
        20 - 39% = 532 
        40 - 59% = 632 
        60 - 79% = 883 
        80 - 99% = 2109 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.29, total records: 400 
    Average version length: 22.80, total versions: 2133, max versions: 6 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 64% 
    Primary pages: 11, secondary pages: 13, swept pages: 0 
    Empty pages: 5, full pages: 15 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 15 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 21.39, total records: 67066 
    Average version length: 68.28, total versions: 53061, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.11 
    Pointer pages: 7, data page slots: 2432 
    Data pages: 1592, average fill: 56% 
    Primary pages: 1591, secondary pages: 1, swept pages: 0 
    Empty pages: 334, full pages: 772 
    Fill distribution: 
     0 - 19% = 444 
    20 - 39% = 147 
    40 - 59% = 142 
    60 - 79% = 196 
    80 - 99% = 663 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1694010, depth: 3, leaf buckets: 326, nodes: 67066 
    Average node length: 13.63, total dup: 4107, max dup: 1 
    Average key length: 10.74, compression ratio: 2.51 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 47708, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 259 
        40 - 59% = 57 
        60 - 79% = 8 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 159, max versions: 6 
    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: 1 
    Data pages: 1, average fill: 70% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 16.19, total records: 2157 
    Average version length: 43.10, total versions: 1713, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.58 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 67% 
    Primary pages: 31, secondary pages: 1, swept pages: 4 
    Empty pages: 4, full pages: 22 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 17 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92131, depth: 2, leaf buckets: 4, nodes: 2157 
    Average node length: 4.13, total dup: 2059, max dup: 240 
    Average key length: 2.49, compression ratio: 7.63 
    Average prefix length: 18.55, average data length: 0.45 
    Clustering factor: 1121, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.53, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.29, total records: 857432 
    Average version length: 37.93, total versions: 30336, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8896 
    Data pages: 8896, average fill: 66% 
    Primary pages: 8891, secondary pages: 5, swept pages: 1935 
    Empty pages: 21, full pages: 7553 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 32 
    40 - 59% = 293 
    60 - 79% = 8466 
    80 - 99% = 71 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 907, nodes: 841246 
    Average node length: 4.89, total dup: 841197, max dup: 165593 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92759, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 134 
        40 - 59% = 485 
        60 - 79% = 181 
        80 - 99% = 105 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1031, nodes: 841246 
    Average node length: 5.89, total dup: 749113, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 167262, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 28 
        40 - 59% = 689 
        60 - 79% = 66 
        80 - 99% = 246 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1064, nodes: 841246 
    Average node length: 5.89, total dup: 749113, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 169215, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 61 
        40 - 59% = 714 
        60 - 79% = 65 
        80 - 99% = 223 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1180, nodes: 841246 
    Average node length: 5.97, total dup: 749113, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 161319, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 230 
        40 - 59% = 622 
        60 - 79% = 232 
        80 - 99% = 95 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5428 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.36, total fragments: 11, 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: 82, secondary pages: 14, swept pages: 54 
    Empty pages: 15, full pages: 55 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5428 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.02 
    Average prefix length: 34.36, average data length: 1.55 
    Clustering factor: 5021, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5428 
    Average node length: 11.10, 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: 170, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 6 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 74638 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 784 
    Data pages: 784, average fill: 65% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 776 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 776 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36425, depth: 2, leaf buckets: 96, nodes: 74638 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 2714, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 94 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.51, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.30 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 148.48, total records: 152362 
    Average version length: 150.52, total versions: 2905, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 8, data page slots: 5216 
    Data pages: 3784, average fill: 83% 
    Primary pages: 3783, secondary pages: 1, swept pages: 5 
    Empty pages: 28, full pages: 3729 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3730 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 127.10, total records: 155664 
    Average version length: 154.54, total versions: 26073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.34 
    Pointer pages: 6, data page slots: 4432 
    Data pages: 3872, average fill: 85% 
    Primary pages: 3869, secondary pages: 3, swept pages: 3 
    Empty pages: 36, full pages: 3821 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3821 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.60, total records: 143727 
    Average version length: 149.62, total versions: 2265, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 4608 
    Data pages: 3568, average fill: 83% 
    Primary pages: 3564, secondary pages: 4, swept pages: 6 
    Empty pages: 34, full pages: 3516 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 8 
    40 - 59% = 1 
    60 - 79% = 7 
    80 - 99% = 3515 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.23, total records: 141173 
    Average version length: 152.11, total versions: 4669, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 7, data page slots: 4312 
    Data pages: 3528, average fill: 83% 
    Primary pages: 3524, secondary pages: 4, swept pages: 2 
    Empty pages: 54, full pages: 3457 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3456 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 147.44, total records: 144853 
    Average version length: 151.63, total versions: 3587, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5208 
    Data pages: 3672, average fill: 81% 
    Primary pages: 3669, secondary pages: 3, swept pages: 3 
    Empty pages: 103, full pages: 3542 
    Fill distribution: 
     0 - 19% = 107 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 10 
    80 - 99% = 3541 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 147.76, total records: 155967 
    Average version length: 151.65, total versions: 3803, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 8, data page slots: 4888 
    Data pages: 3888, average fill: 83% 
    Primary pages: 3885, secondary pages: 3, swept pages: 3 
    Empty pages: 43, full pages: 3824 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 3823 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 144.61, total records: 149880 
    Average version length: 152.32, total versions: 6616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 5, data page slots: 4128 
    Data pages: 3720, average fill: 83% 
    Primary pages: 3717, secondary pages: 3, swept pages: 12 
    Empty pages: 32, full pages: 3657 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 18 
    60 - 79% = 6 
    80 - 99% = 3656 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 121.06, total records: 200679 
    Average version length: 154.69, total versions: 42642, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.01 
    Pointer pages: 6, data page slots: 6440 
    Data pages: 5040, average fill: 85% 
    Primary pages: 5038, secondary pages: 2, swept pages: 16 
    Empty pages: 71, full pages: 4924 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 12 
    40 - 59% = 15 
    60 - 79% = 20 
    80 - 99% = 4921 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 144.29, total records: 141021 
    Average version length: 151.99, total versions: 6365, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 7, data page slots: 5328 
    Data pages: 3512, average fill: 83% 
    Primary pages: 3510, secondary pages: 2, swept pages: 7 
    Empty pages: 48, full pages: 3447 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3448 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 143.86, total records: 140316 
    Average version length: 152.77, total versions: 6814, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.79 
    Pointer pages: 7, data page slots: 4248 
    Data pages: 3488, average fill: 83% 
    Primary pages: 3485, secondary pages: 3, swept pages: 3 
    Empty pages: 42, full pages: 3435 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3435 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.11, total records: 2042491 
    Average version length: 52.93, total versions: 29721, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25296 
    Data pages: 25296, average fill: 70% 
    Primary pages: 25271, secondary pages: 25, swept pages: 11964 
    Empty pages: 191, full pages: 21017 
    Fill distribution: 
     0 - 19% = 359 
    20 - 39% = 340 
    40 - 59% = 1063 
    60 - 79% = 23291 
    80 - 99% = 243 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2528, nodes: 2042491 
    Average node length: 5.45, total dup: 1904258, max dup: 1543 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 178921, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 300 
        40 - 59% = 1646 
        60 - 79% = 274 
        80 - 99% = 301 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2747, nodes: 2042491 
    Average node length: 5.70, total dup: 1832680, max dup: 75 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 366930, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2540 
        60 - 79% = 174 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2042, nodes: 2042491 
    Average node length: 4.96, total dup: 2042391, max dup: 27091 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 176707, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 182 
        40 - 59% = 1034 
        60 - 79% = 374 
        80 - 99% = 450 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 42.10, total records: 146973 
    Average version length: 69.19, total versions: 66210, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.99 
    Pointer pages: 3, data page slots: 3952 
    Data pages: 3216, average fill: 55% 
    Primary pages: 3215, secondary pages: 1, swept pages: 450 
    Empty pages: 604, full pages: 1725 
    Fill distribution: 
     0 - 19% = 801 
    20 - 39% = 176 
    40 - 59% = 283 
    60 - 79% = 886 
    80 - 99% = 1070 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 367378, depth: 3, leaf buckets: 227, nodes: 146973 
    Average node length: 6.44, total dup: 127877, max dup: 27 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 26248, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 45 
        40 - 59% = 115 
        60 - 79% = 56 
        80 - 99% = 11 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.84, total records: 7329261 
    Average version length: 68.75, total versions: 379285, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 68, data page slots: 110904 
    Data pages: 110904, average fill: 71% 
    Primary pages: 110902, secondary pages: 2, swept pages: 29257 
    Empty pages: 1, full pages: 63213 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 573 
    40 - 59% = 7374 
    60 - 79% = 101688 
    80 - 99% = 1225 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10861, nodes: 7329261 
    Average node length: 6.51, total dup: 6339986, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1719071, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1419 
        40 - 59% = 5821 
        60 - 79% = 3126 
        80 - 99% = 488 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8937, nodes: 7329261 
    Average node length: 5.39, total dup: 7042866, max dup: 167 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1515589, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1235 
        40 - 59% = 5174 
        60 - 79% = 1561 
        80 - 99% = 962 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8981, nodes: 7329261 
    Average node length: 5.39, total dup: 7042866, max dup: 167 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1518014, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1234 
        40 - 59% = 5208 
        60 - 79% = 1582 
        80 - 99% = 946 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.46, total records: 12263532 
    Average version length: 68.68, total versions: 299892, 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: 109, data page slots: 177584 
    Data pages: 177584, average fill: 73% 
    Primary pages: 177584, secondary pages: 0, swept pages: 68914 
    Empty pages: 8, full pages: 153923 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 400 
    40 - 59% = 4712 
    60 - 79% = 170578 
    80 - 99% = 1865 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18564, nodes: 12261473 
    Average node length: 6.62, total dup: 10687903, max dup: 54 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2491683, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 2063 
        40 - 59% = 10844 
        60 - 79% = 4800 
        80 - 99% = 838 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 49.89, total records: 1564349 
    Average version length: 69.02, total versions: 298848, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.53 
    Pointer pages: 26, data page slots: 41128 
    Data pages: 29487, average fill: 55% 
    Primary pages: 29396, secondary pages: 91, swept pages: 8689 
    Empty pages: 2835, full pages: 17428 
    Fill distribution: 
     0 - 19% = 5099 
    20 - 39% = 3914 
    40 - 59% = 3116 
    60 - 79% = 13583 
    80 - 99% = 3775 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1858, nodes: 1362554 
    Average node length: 5.52, total dup: 1307183, max dup: 49 
    Average key length: 2.57, compression ratio: 16.35 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 96184, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 465 
        40 - 59% = 911 
        60 - 79% = 400 
        80 - 99% = 73 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 38.66, total records: 1197588 
    Average version length: 69.03, total versions: 170493, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.26 
    Pointer pages: 23, data page slots: 36088 
    Data pages: 30856, average fill: 34% 
    Primary pages: 30855, secondary pages: 1, swept pages: 7806 
    Empty pages: 7538, full pages: 9341 
    Fill distribution: 
     0 - 19% = 11613 
    20 - 39% = 4959 
    40 - 59% = 7815 
    60 - 79% = 6234 
    80 - 99% = 235 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1199, nodes: 762405 
    Average node length: 5.92, total dup: 703781, max dup: 71 
    Average key length: 2.98, compression ratio: 14.07 
    Average prefix length: 41.09, average data length: 0.91 
    Clustering factor: 112216, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 413 
        40 - 59% = 571 
        60 - 79% = 204 
        80 - 99% = 10 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.71, total records: 8785133 
    Average version length: 68.99, total versions: 316835, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 86, data page slots: 140032 
    Data pages: 140008, average fill: 67% 
    Primary pages: 139989, secondary pages: 19, swept pages: 61430 
    Empty pages: 359, full pages: 64170 
    Fill distribution: 
     0 - 19% = 1164 
    20 - 39% = 5097 
    40 - 59% = 20307 
    60 - 79% = 111616 
    80 - 99% = 1824 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13365, nodes: 8781866 
    Average node length: 6.66, total dup: 7282466, max dup: 29 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1964196, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1626 
        40 - 59% = 7362 
        60 - 79% = 3975 
        80 - 99% = 402 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21076800 
    Average version length: 82.96, total versions: 9421, 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: 318624 
    Data pages: 318624, average fill: 81% 
    Primary pages: 318620, secondary pages: 4, swept pages: 12148 
    Empty pages: 20, full pages: 317827 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 37 
    40 - 59% = 87 
    60 - 79% = 47406 
    80 - 99% = 271050 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19205, nodes: 21076800 
    Average node length: 5.72, total dup: 20597473, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3273311, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 7905 
        60 - 79% = 525 
        80 - 99% = 10767 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17088, nodes: 21076800 
    Average node length: 6.31, total dup: 18522360, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914377, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 755 
        60 - 79% = 244 
        80 - 99% = 16084 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20991, nodes: 21076800 
    Average node length: 6.34, total dup: 18441197, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3565970, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 8185 
        60 - 79% = 596 
        80 - 99% = 12202 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16020, nodes: 21076800 
    Average node length: 5.56, total dup: 21076700, max dup: 229201 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942955, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 14 
        40 - 59% = 2843 
        60 - 79% = 355 
        80 - 99% = 12807 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.41, total records: 9162629 
    Average version length: 82.63, total versions: 248999, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 101, data page slots: 164680 
    Data pages: 164632, average fill: 69% 
    Primary pages: 164606, secondary pages: 26, swept pages: 87539 
    Empty pages: 599, full pages: 89014 
    Fill distribution: 
     0 - 19% = 1910 
    20 - 39% = 6963 
    40 - 59% = 24465 
    60 - 79% = 115131 
    80 - 99% = 16163 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11276, nodes: 9162629 
    Average node length: 5.34, total dup: 8860497, max dup: 164 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2075470, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 97 
        40 - 59% = 9665 
        60 - 79% = 1482 
        80 - 99% = 28 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 12791, nodes: 9162629 
    Average node length: 6.21, total dup: 7593847, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1452135, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 3636 
        40 - 59% = 4250 
        60 - 79% = 2689 
        80 - 99% = 2111 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12587, nodes: 9162629 
    Average node length: 5.96, total dup: 7939135, max dup: 34 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2255153, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 132 
        40 - 59% = 10706 
        60 - 79% = 1712 
        80 - 99% = 36 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9568, nodes: 9162629 
    Average node length: 5.11, total dup: 9162529, max dup: 139600 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1469402, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1229 
        40 - 59% = 4598 
        60 - 79% = 1760 
        80 - 99% = 1930 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.66, total records: 10922721 
    Average version length: 82.61, total versions: 241757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 115, data page slots: 187528 
    Data pages: 186120, average fill: 72% 
    Primary pages: 186017, secondary pages: 103, swept pages: 67610 
    Empty pages: 2711, full pages: 142243 
    Fill distribution: 
     0 - 19% = 4632 
    20 - 39% = 6917 
    40 - 59% = 16225 
    60 - 79% = 98733 
    80 - 99% = 59613 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13106, nodes: 10922721 
    Average node length: 5.28, total dup: 10813910, max dup: 664 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2291606, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 243 
        40 - 59% = 10186 
        60 - 79% = 2600 
        80 - 99% = 77 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10085, nodes: 10922721 
    Average node length: 5.48, total dup: 10444243, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 705683, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 170 
        20 - 39% = 841 
        40 - 59% = 2396 
        60 - 79% = 1887 
        80 - 99% = 4791 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14991, nodes: 10922721 
    Average node length: 6.01, total dup: 9522738, max dup: 60 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2307804, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 294 
        40 - 59% = 11777 
        60 - 79% = 2815 
        80 - 99% = 104 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10392, nodes: 10922721 
    Average node length: 5.20, total dup: 10922621, max dup: 187690 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 693317, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 838 
        40 - 59% = 4536 
        60 - 79% = 1517 
        80 - 99% = 3404 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.78, total records: 9271058 
    Average version length: 82.93, total versions: 245712, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 104, data page slots: 169376 
    Data pages: 169320, average fill: 68% 
    Primary pages: 169289, secondary pages: 31, swept pages: 92520 
    Empty pages: 657, full pages: 86549 
    Fill distribution: 
     0 - 19% = 2088 
    20 - 39% = 8659 
    40 - 59% = 27658 
    60 - 79% = 115088 
    80 - 99% = 15827 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11290, nodes: 9271058 
    Average node length: 5.15, total dup: 9243135, max dup: 1878 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1867734, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1534 
        40 - 59% = 7517 
        60 - 79% = 1659 
        80 - 99% = 545 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 12895, nodes: 9271058 
    Average node length: 6.23, total dup: 7683617, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1408999, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 3596 
        40 - 59% = 4199 
        60 - 79% = 2669 
        80 - 99% = 2275 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 11896, nodes: 9271058 
    Average node length: 5.41, total dup: 8851487, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1997047, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1493 
        40 - 59% = 8347 
        60 - 79% = 1509 
        80 - 99% = 521 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9698, nodes: 9271058 
    Average node length: 5.13, total dup: 9270958, max dup: 140738 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1477581, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 52 
        20 - 39% = 1235 
        40 - 59% = 4688 
        60 - 79% = 1738 
        80 - 99% = 1985 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.76, total records: 564096 
    Average version length: 68.84, total versions: 3781, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 7936 
    Data pages: 7936, average fill: 74% 
    Primary pages: 7936, secondary pages: 0, swept pages: 3841 
    Empty pages: 7, full pages: 6755 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 9 
    40 - 59% = 157 
    60 - 79% = 7721 
    80 - 99% = 42 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 51679, depth: 3, leaf buckets: 719, nodes: 564096 
    Average node length: 5.95, total dup: 480077, max dup: 82 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99767, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 26 
        40 - 59% = 515 
        60 - 79% = 77 
        80 - 99% = 100 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 41667, depth: 3, leaf buckets: 754, nodes: 564096 
    Average node length: 6.15, total dup: 462557, max dup: 27 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 99818, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 542 
        60 - 79% = 73 
        80 - 99% = 98 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 544, nodes: 564096 
    Average node length: 4.85, total dup: 563996, max dup: 9554 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88613, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 294 
        60 - 79% = 104 
        80 - 99% = 124 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Mon Mar 25 04:09:58 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7649550 58315 1 0.0000 0.0000
DOC_LIST 2186967 30992 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2133 6 500.0000 0.0000
INVNT_TURNOVER_LOG 67066 53061 1 0.0000 0.0000
MONEY_SALDO 49 159 6 300.0000 0.0000
MONEY_TURNOVER_LOG 2157 1713 1 0.0000 0.0000
PDISTR 857432 30336 3 0.0000 0.0000
PERF_SPLIT_0 152362 2905 1 0.0000 0.0000
PERF_SPLIT_1 155664 26073 1 0.0000 0.0000
PERF_SPLIT_2 143727 2265 1 0.0000 0.0000
PERF_SPLIT_3 141173 4669 1 0.0000 0.0000
PERF_SPLIT_4 144853 3587 1 0.0000 0.0000
PERF_SPLIT_5 155967 3803 1 0.0000 0.0000
PERF_SPLIT_6 149880 6616 1 0.0000 0.0000
PERF_SPLIT_7 200679 42642 1 0.0000 0.0000
PERF_SPLIT_8 141021 6365 1 0.0000 0.0000
PERF_SPLIT_9 140316 6814 1 0.0000 0.0000
PSTORNED 2042491 29721 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 146973 66210 1 0.0000 0.0000
XQD_1000_3300 7329261 379285 1 0.0000 0.0000
XQD_1200_2000 12263532 299892 1 0.0000 0.0000
XQD_2000_3300 1564349 298848 1 0.0000 0.0000
XQD_2100_3300 1197588 170493 1 0.0000 0.0000
XQD_3300_3400 8785133 316835 1 0.0000 0.0000
XQS_1000_1200 21076800 9421 1 0.0000 0.0000
XQS_1000_3300 9162629 248999 1 0.0000 0.0000
XQS_1200_2000 10922721 241757 1 0.0000 0.0000
XQS_2100_3300 9271058 245712 1 0.0000 0.0000
XQS_3300_3400 564096 3781 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 ---
:93: 
:94: mscs-test-161.budzdorov.ru    Mon Mar 25 04:07:59 2024
:95:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:96: 
--- end of diff output ---

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

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