Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.04.2024 10: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 15570756 kB
MemAvailable 30088728 kB
Buffers 0 kB
Cached 16163332 kB
SwapCached 2488 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-04-10 10:07:51
DTS_END                         2024-04-10 10:07:51.2610
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/48384
TRN_ID                          168404
ATT_ID                          510
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: 9115.55 14381 911555
customer order: creation 175.20 396 17520
customer order: refuse 15.26 384 1526
order to supplier: creation 45.19 1284 4519
order to supplier: removal 3.66 88590 366
invoice (draft): creation 46.12 3310 4612
invoice (draft): removal 48.61 688 4861
invoice accept: apply 42.31 21006 4231
invoice accept: cancel 44.37 812 4437
customer reserve: creation 4102.00 199 410200
customer reserve: removal 4303.53 59 430353
realization accept: apply 82.84 207 8284
realization accept: cancel 79.69 136 7969
payment from customer: creation 60.01 136 6001
payment from customer: removal 5.61 112 561
payment to supplier: creation 47.26 160 4726
payment to supplier: removal 3.47 96 347
service: total inventory turnovers 3.52 4148 352
service: total monetary turnovers 5.91 603 591
service: aggregate perf. data 0.95 15516 95
service: refresh index statistics 0.04 149785 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-04-2024 10:09:15 to 10-04-2024 10:09:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3403
TEST_TIME 2 3236
TEST_TIME 3 4132
TEST_TIME 4 4524
TEST_TIME 5 4380
TEST_TIME 6 3933
TEST_TIME 7 4374
TEST_TIME 8 4780
TEST_TIME 9 5154
TEST_TIME 10 6146
TEST_TIME 11 6229
TEST_TIME 12 6544
TEST_TIME 13 6581
TEST_TIME 14 6675
TEST_TIME 15 6938
TEST_TIME 16 7300
TEST_TIME 17 7968
TEST_TIME 18 7977
TEST_TIME 19 7941
TEST_TIME 20 7973
TEST_TIME 21 8024
TEST_TIME 22 8044
TEST_TIME 23 8693
TEST_TIME 24 9065
TEST_TIME 25 9615
TEST_TIME 26 10023
TEST_TIME 27 9918
TEST_TIME 28 9899
TEST_TIME 29 9753
TEST_TIME 30 9602
TEST_TIME 31 9422
TEST_TIME 32 9279
TEST_TIME 33 9206
TEST_TIME 34 9285
TEST_TIME 35 9203
TEST_TIME 36 9183
TEST_TIME 37 9076
TEST_TIME 38 9069
TEST_TIME 39 8981
TEST_TIME 40 8977
TEST_TIME 41 8868
TEST_TIME 42 8788
TEST_TIME 43 8915
TEST_TIME 44 9071
TEST_TIME 45 9108
TEST_TIME 46 9128
TEST_TIME 47 9166
TEST_TIME 48 9202
TEST_TIME 49 9261
TEST_TIME 50 9390
TEST_TIME 51 9418
TEST_TIME 52 9573
TEST_TIME 53 9585
TEST_TIME 54 9622
TEST_TIME 55 9615
TEST_TIME 56 9530
TEST_TIME 57 9440
TEST_TIME 58 9383
TEST_TIME 59 9374
TEST_TIME 60 9327
TEST_TIME 61 9281
TEST_TIME 62 9250
TEST_TIME 63 9180
TEST_TIME 64 9131
TEST_TIME 65 9158
TEST_TIME 66 9153
TEST_TIME 67 9171
TEST_TIME 68 9146
TEST_TIME 69 9190
TEST_TIME 70 9216
TEST_TIME 71 9254
TEST_TIME 72 9288
TEST_TIME 73 9353
TEST_TIME 74 9330
TEST_TIME 75 9316
TEST_TIME 76 9233
TEST_TIME 77 9174
TEST_TIME 78 9131
TEST_TIME 79 9087
TEST_TIME 80 9135
TEST_TIME 81 9126
TEST_TIME 82 9103
TEST_TIME 83 9098
TEST_TIME 84 9073
TEST_TIME 85 9092
TEST_TIME 86 9232
TEST_TIME 87 9222
TEST_TIME 88 9282
TEST_TIME 89 9310
TEST_TIME 90 9324
TEST_TIME 91 9290
TEST_TIME 92 9317
TEST_TIME 93 9226
TEST_TIME 94 9223
TEST_TIME 95 9169
TEST_TIME 96 9120
TEST_TIME 97 9142
TEST_TIME 98 9133
TEST_TIME 99 9127
TEST_TIME 100 9128

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-04-2024 10:09:19 to 10-04-2024 10:09:22.

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 1285119 1285119 0 0.00 0 33864 8 0 0
doc_list_biud 1285118 1285118 0 0.00 0 33854 25 0 0
sp_add_invoice_to_stock 4389 4231 158 3.59 28 188562 21006 0 158
sp_cancel_adding_invoice 4437 4437 0 0.00 4 58841 812 0 0
sp_cancel_client_order 1526 1526 0 0.00 3 15703 384 0 0
sp_cancel_customer_reserve 430353 430353 0 0.00 0 33855 60 0 0
sp_cancel_pay_from_customer 561 561 0 0.00 3 9117 112 0 0
sp_cancel_pay_to_supplier 347 347 0 0.00 3 4083 96 0 0
sp_cancel_supplier_invoice 4868 4861 7 0.14 1 28773 689 0 7
sp_cancel_supplier_order 366 366 0 0.00 6 803954 88590 0 0
sp_cancel_write_off 7969 7969 0 0.00 1 13764 137 0 0
sp_client_order 17520 17520 0 0.00 3 23688 397 0 0
sp_customer_reserve 410200 410200 0 0.00 0 88775 200 0 0
sp_fill_shopping_cart 26647 26647 0 0.00 1 19173 39 0 0
sp_fill_shopping_cart_clo_res 410188 410188 0 0.00 0 28540 20 0 0
sp_get_clo_for_invoice 4219 4219 0 0.00 0 17947 363 0 0
sp_kill_cost_storno 13314 13314 0 0.00 0 9712 68 0 0
sp_kill_qstorno_ret_qs2qd 873902 873902 0 0.00 0 33850 32 0 0
sp_kill_qty_storno 462014 462014 0 0.00 0 33853 69 0 0
sp_lock_selected_doc 17306 17306 0 0.00 0 9113 5 0 0
sp_make_cost_storno 23230 23230 0 0.00 0 30344 76 0 0
sp_multiply_rows_for_pdistr 23230 23230 0 0.00 0 9057 35 0 0
sp_multiply_rows_for_qdistr 17520 17520 0 0.00 0 23607 201 0 0
sp_pay_from_customer 6001 6001 0 0.00 3 12380 137 0 0
sp_pay_to_supplier 4726 4726 0 0.00 4 16107 161 0 0
sp_payment_common 10727 10727 0 0.00 1 11184 30 0 0
sp_qd_handle_on_cancel_clo 1526 1526 0 0.00 0 15685 353 0 0
sp_qd_handle_on_invoice_upd_sts 8655 8655 0 0.00 0 24480 322 0 0
sp_qd_handle_on_reserve_upd_sts 8284 8284 0 0.00 0 9301 51 0 0
sp_reserve_write_off 8284 8284 0 0.00 6 14171 207 0 0
sp_supplier_invoice 4612 4612 0 0.00 6 105890 3310 0 0
sp_supplier_order 4519 4519 0 0.00 4 41214 1285 0 0
srv_aggregate_perf_data 95 95 0 0.00 1602 254521 15516 0 0
srv_fill_mon_cache_memory 52 52 0 0.00 1407 142249 47537 0 0
srv_find_qd_qs_mism 867751 867751 0 0.00 0 24808 7 0 0
srv_make_invnt_saldo 352 352 0 0.00 41 91313 4148 0 0
srv_make_money_saldo 591 591 0 0.00 1 11675 604 0 0
srv_recalc_idx_stat 4 4 0 0.00 76020 294559 149786 0 0
t$perf-abend:sp_add_invoice_to_stock 158 158 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4232 4232 0 0.00 0 11030 177 0 0
t$perf-norm:sp_cancel_adding_invoice 336 336 0 0.00 0 5747 99 0 0
t$perf-norm:sp_cancel_client_order 1526 1526 0 0.00 0 5510 20 0 0
t$perf-norm:sp_cancel_customer_reserve 532 532 0 0.00 0 2319 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 561 561 0 0.00 0 1690 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 347 347 0 0.00 0 122 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 314 314 0 0.00 0 11399 55 0 0
t$perf-norm:sp_cancel_supplier_order 366 366 0 0.00 0 24016 1512 0 0
t$perf-norm:sp_cancel_write_off 822 822 0 0.00 0 913 6 0 0
t$perf-norm:sp_client_order 17520 17520 0 0.00 0 14966 14 0 0
t$perf-norm:sp_customer_reserve 802 802 0 0.00 0 2766 9 0 0
t$perf-norm:sp_pay_from_customer 6002 6002 0 0.00 0 22223 12 0 0
t$perf-norm:sp_pay_to_supplier 4726 4726 0 0.00 0 3031 8 0 0
t$perf-norm:sp_reserve_write_off 8284 8284 0 0.00 0 19619 15 0 0
t$perf-norm:sp_supplier_invoice 4612 4612 0 0.00 0 2689 12 0 0
t$perf-norm:sp_supplier_order 4519 4519 0 0.00 0 10402 17 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 241 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 52 52 0 0.00 0 7231 160 0 0
t$perf-norm:srv_make_invnt_saldo 352 352 0 0.00 0 3532 16 0 0
t$perf-norm:srv_make_money_saldo 591 591 0 0.00 0 5325 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 8752 8436 316 3.61 0 6522 23 0 316
v_all_customers 32338 32338 0 0.00 0 21 1 0 0
v_all_suppliers 25426 25426 0 0.00 0 29 1 0 0
v_all_wares 35040 35040 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 672 672 0 0.00 0 1900 10 0 0
v_cancel_client_order 3052 3052 0 0.00 0 6001 6 0 0
v_cancel_customer_prepayment 1122 1122 0 0.00 0 5820 8 0 0
v_cancel_customer_reserve 1064 1064 0 0.00 0 1292 7 0 0
v_cancel_payment_to_supplier 694 694 0 0.00 0 4059 11 0 0
v_cancel_supplier_invoice 642 628 14 2.18 0 969 15 0 14
v_cancel_supplier_order 732 732 0 0.00 0 3390 15 0 0
v_cancel_write_off 1644 1644 0 0.00 0 7854 29 0 0
v_max_id_clo_ord 4517 4517 0 0.00 0 123 1 0 0
v_max_id_clo_res 802 802 0 0.00 0 6921 24 0 0
v_max_id_ord_sup 4610 4610 0 0.00 0 4485 6 0 0
v_max_non_paid_invoice 1140 1140 0 0.00 0 137 2 0 0
v_max_non_paid_realizn 2964 2964 0 0.00 0 3949 4 0 0
v_min_id_clo_ord 4517 4517 0 0.00 0 3580 8 0 0
v_min_id_clo_res 802 802 0 0.00 0 294 2 0 0
v_min_id_ord_sup 4610 4610 0 0.00 0 7051 10 0 0
v_min_non_paid_invoice 4726 4726 0 0.00 0 9321 23 0 0
v_min_non_paid_realizn 6001 6001 0 0.00 0 11178 25 0 0
v_our_firm 8776 8776 0 0.00 0 24 1 0 0
v_reserve_write_off 16568 16568 0 0.00 0 4759 7 0 0
x_lock_depdocs_on_canc_invoice 8984 8984 0 0.00 0 17764 137 0 0
x_lock_depdocs_on_canc_sup_ord 366 366 0 0.00 0 16805 357 0 0
x_make_qstorno_1000_1200 4519 4519 0 0.00 1 41192 1209 0 0
x_make_qstorno_1200_2000 4612 4612 0 0.00 3 97957 3161 0 0
x_make_qstorno_2100_3300 410200 410200 0 0.00 0 88775 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-04-2024 10:09:23 to 10-04-2024 10:09:27.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:55 13 8192000000 8814627232 8832151552 16469424 0.200 6 5 6 0 16765968 158416 138128
08:08:56 37693 8192000000 9719400752 10016829440 787815328 8.773 100 88 176 0 816415392 7464192 21135872
08:10:36 16233 8192000000 9749444400 10054995968 823330688 9.132 100 89 178 0 855508432 11188896 20988848
08:12:04 13936 8192000000 9769986576 10087268352 844057584 9.340 100 84 169 0 882890560 19359584 19473392
08:13:23 6908 8192000000 9825957984 10153865216 885872848 9.758 100 83 165 0 936086992 32342064 17872080
08:14:38 7724 8192000000 9903634112 10244390912 940229792 10.295 100 85 170 0 1021861088 64249360 17381936
08:15:48 5219 8192000000 9961370576 10311503872 970959856 10.596 100 82 163 1 1072410656 85332688 16118112
08:16:59 2460 8192000000 9964316752 10325237760 1000717008 10.885 100 79 158 0 1081082112 64361680 16003424
08:18:03 2662 8192000000 10024749856 10389782528 1025614192 11.126 100 90 177 0 1134204304 91471088 17119024
08:19:07 967 8192000000 10018258384 10391179264 1039134144 11.256 100 96 189 0 1131667360 73409456 19123760
08:20:10 45470 8192000000 9962871392 10355228672 1055696944 11.415 100 56 113 0 1099883344 31331296 12855104
08:21:56 5134 8192000000 9986106896 10379509760 1068657728 11.539 100 40 78 1 1102707040 25953952 8095360
08:23:03 7587 8192000000 9978432624 10379247616 1075498016 11.605 100 27 54 2 1104723936 23331680 5894240
08:24:11 4555 8192000000 10004629888 10406821888 1084974688 11.695 100 52 103 1 1118370528 23247248 10148592
08:25:21 63397 8192000000 10008107824 10413940736 1093825248 11.779 100 48 96 0 1128038192 24012544 10200400
08:27:28 4517 8192000000 10009132960 10415788032 1095971856 11.799 100 35 70 1 1122440192 19124800 7343536
08:28:38 11961 8192000000 10041667952 10447007744 1111133968 11.943 100 50 98 1 1144633408 24002864 9496576
08:29:56 53537 8192000000 10096604016 10503680000 1117939872 12.008 100 45 90 0 1204236400 77426672 8869856
08:31:52 75104 8192000000 10126736224 10563256320 1122264736 12.048 99 33 66 1 1243483776 114644512 6574528
08:34:16 20405 8192000000 10142480496 10554499072 1115196304 11.982 98 38 75 1 1247190320 124235792 7758224
08:35:38 7915 8192000000 10153666128 10563506176 1114986288 11.980 99 43 86 0 1268633952 144950144 8697520
08:36:52 8578 8192000000 10143461664 10573733888 1099588336 11.834 98 48 93 0 1246377840 137025520 9763984
08:38:05 13214 8192000000 10094436208 10502402048 1082640304 11.673 100 46 92 1 1207454320 115778176 9035840
08:39:26 2802 8192000000 10146052960 10533171200 1087504400 11.719 100 79 155 2 1240861104 137532528 15824176
08:40:33 10561 8192000000 10155425360 10548989952 1078436192 11.633 100 65 128 0 1256558736 164539728 13582816
08:41:48 3639 8192000000 10182085072 10568839168 1079428608 11.642 100 63 125 0 1280783584 187724752 13630224
08:42:57 5695 8192000000 10199435104 10602319872 1064989072 11.504 98 70 136 2 1296157872 216856864 14311936
08:44:08 1407 8192000000 10227708160 10638467072 1112600656 11.957 100 91 179 2 1323566880 191765280 19200944
08:45:16 8020 8192000000 10224428704 10618970112 1120993552 12.036 100 70 136 0 1321977360 186155856 14827952
08:46:26 8013 8192000000 10269718080 10666921984 1112659520 11.958 99 65 126 1 1352512336 226185696 13667120
08:47:39 5166 8192000000 10325207168 10730360832 1127720128 12.100 100 62 125 1 1429260224 287637776 13902320
08:49:04 11229 8192000000 10321455248 10751393792 1124986752 12.074 100 26 49 0 1419759504 288545680 6227072
08:50:28 16546 8192000000 10264996384 10722762752 1109215504 11.925 100 24 46 0 1367924480 253151456 5557520
08:51:57 43145 8192000000 10127087072 10670559232 1093781776 11.779 99 15 30 0 1292126624 194783712 3561136
08:53:53 55464 8192000000 10062123120 10500775936 1096730224 11.807 99 7 14 0 1167049936 68822848 1496864
08:55:50 17419 8192000000 10061154912 10482425856 1108994080 11.923 100 48 90 3 1157703664 40080768 8628816
08:57:08 84894 8192000000 10079868160 10548740096 1114874864 11.979 100 50 98 1 1190629440 65265088 10489488
08:59:35 51704 8192000000 10082787072 10524872704 1119132144 12.019 100 36 72 0 1186688240 60649168 6906928
09:01:32 28763 8192000000 10042146960 10481762304 1118030432 12.008 100 28 56 0 1143543376 20110224 5402720
09:03:02 90215 8192000000 10087999200 10531024896 1131880096 12.139 100 26 51 0 1182231728 44860112 5491520
09:05:37 28885 8192000000 10082193408 10535297024 1131717776 12.138 100 6 12 0 1200279552 67159328 1402448
09:07:09 86630 8192000000 10096562240 10543026176 1119714272 12.024 98 26 49 0 1179709456 54440944 5554240
09:09:38 83241 8192000000 10103274016 10620186624 1134733856 12.166 99 11 22 0 1233307312 96397152 2176304
09:12:01 46314 8192000000 10102895584 10571304960 1158852160 12.393 100 19 38 0 1211654880 49114736 3687984
09:13:50 52032 8192000000 10113748624 10574323712 1153575648 12.343 100 26 52 0 1212977840 54712720 4689472
09:15:45 54302 8192000000 10126675504 10593284096 1133542416 12.155 98 27 54 0 1189547040 50230288 5774336
09:18:23 91214 8192000000 10130098944 10637742080 1112903840 11.960 97 20 40 1 1217714080 100699168 4111072
09:21:00 91718 8192000000 10061322272 10543714304 1015265856 11.026 89 10 20 0 1054300528 37309536 1725136
09:23:32 113639 8192000000 10065274336 10511773696 1075971296 11.609 96 27 54 0 1153860432 72257216 5631920
09:27:08 43845 8192000000 10036938448 10488561664 1096028240 11.800 98 26 52 0 1137413184 36301984 5082960
09:29:21 50368 8192000000 10014762416 10440511488 1059295760 11.450 96 21 40 0 1096446800 32982736 4168304
09:31:11 58202 8192000000 10042337520 10501165056 1113670880 11.967 100 12 24 0 1162524032 46257360 2595792
09:33:16 30455 8192000000 10050335936 10496516096 1085293376 11.698 99 39 76 0 1137140480 44690288 7156816
09:34:58 16304 8192000000 10041566752 10470785024 1088605088 11.729 99 56 113 1 1126151648 26450464 11096096
09:36:22 47177 8192000000 10042092992 10480836608 1037092672 11.237 95 37 72 0 1082293504 38202800 6998032
09:38:09 55869 8192000000 10057538944 10473508864 1096722016 11.807 100 22 42 0 1161586400 60816080 4048304
09:40:07 107434 8192000000 10068339904 10514477056 1100361584 11.841 98 25 50 0 1161997792 57074496 4561712
09:42:58 111915 8192000000 10072737152 10523832320 1123326944 12.058 100 29 58 0 1185810480 56932320 5551216
09:45:52 76749 8192000000 10068888176 10540843008 1119863744 12.026 99 12 24 0 1187237792 64894336 2479712
09:48:10 42234 8192000000 10045757232 10490216448 1095197344 11.792 97 16 32 0 1117436096 19148480 3090272
09:49:53 56323 8192000000 10130622288 10569277440 1138139072 12.198 100 28 56 0 1198774544 54802256 5833216
09:52:20 142249 8192000000 10078737296 10564513792 1126103392 12.085 99 20 41 0 1248074768 117378096 4593280
09:55:48 59465 8192000000 10081962288 10574196736 1133268368 12.152 99 6 12 0 1191978272 57371712 1338192
09:57:53 46579 8192000000 10076581312 10502152192 1119630176 12.023 98 26 52 1 1152484640 27157856 5696608
09:59:42 113800 8192000000 10093979904 10532569088 1130700128 12.128 99 24 48 0 1194927488 59234448 4992912
10:02:39 33477 8192000000 10086405680 10558955520 1124654800 12.071 98 15 25 1 1178795296 51418448 2722048
10:04:13 53697 8192000000 10073320400 10573172736 1110679808 11.939 97 8 16 0 1180932672 68637296 1615568
10:06:14 42355 8192000000 10068632704 10506162176 1090927040 11.751 96 24 46 1 1138202816 42089616 5186160

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 10-04-2024 10:09:29 to 10-04-2024 10:09:42.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:03, from 10-04-2024 10:09:43 to 10-04-2024 10:09:46.

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          165356
MON$OLDEST_ACTIVE               168517
MON$OLDEST_SNAPSHOT             168517
MON$NEXT_TRANSACTION            168517
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                       1905376
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             681
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3083 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3083 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3083 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 Wed Apr 10 10:09:47 2024 
 
Database header page information: 
    Flags            0 
    Generation        87941 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    165356 
    Oldest active        168517 
    Oldest snapshot        168517 
    Next transaction    168518 
    Sequence number        0 
    Next attachment ID    681 
    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.53, total records: 7730086 
    Average version length: 48.15, total versions: 71149, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88976 
    Data pages: 88976, average fill: 69% 
    Primary pages: 88976, secondary pages: 0, swept pages: 39107 
    Empty pages: 7, full pages: 66098 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 55 
    40 - 59% = 1884 
    60 - 79% = 86997 
    80 - 99% = 27 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23180, nodes: 7730086 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1666023, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 311 
        20 - 39% = 1825 
        40 - 59% = 4037 
        60 - 79% = 2467 
        80 - 99% = 14540 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13457, nodes: 7730086 
    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: 1490718, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1562 
        40 - 59% = 1980 
        60 - 79% = 1180 
        80 - 99% = 8734 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8279, nodes: 7730086 
    Average node length: 6.62, total dup: 5778869, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1483608, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 972 
        40 - 59% = 1323 
        60 - 79% = 975 
        80 - 99% = 4902 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.62, total records: 2241695 
    Average version length: 58.90, total versions: 38341, 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: 28664 
    Data pages: 28664, average fill: 72% 
    Primary pages: 28662, secondary pages: 2, swept pages: 9331 
    Empty pages: 0, full pages: 17592 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 36 
    40 - 59% = 409 
    60 - 79% = 28125 
    80 - 99% = 86 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4543, nodes: 2241695 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 686117, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 926 
        40 - 59% = 819 
        60 - 79% = 748 
        80 - 99% = 2050 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2435, nodes: 2242927 
    Average node length: 4.97, total dup: 2242028, max dup: 20592 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259269, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 211 
        40 - 59% = 1442 
        60 - 79% = 523 
        80 - 99% = 257 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1790, nodes: 2241695 
    Average node length: 4.97, total dup: 2241645, max dup: 130142 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1065388, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 658 
        60 - 79% = 35 
        80 - 99% = 1089 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4330, nodes: 2241695 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 686117, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 575 
        40 - 59% = 595 
        60 - 79% = 856 
        80 - 99% = 2199 
 
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.38, total records: 400 
    Average version length: 24.55, total versions: 2843, max versions: 8 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 61% 
    Primary pages: 11, secondary pages: 21, swept pages: 0 
    Empty pages: 4, full pages: 18 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 16 
 
    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: 19.64, total records: 101781 
    Average version length: 68.29, total versions: 83518, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.48 
    Pointer pages: 7, data page slots: 3064 
    Data pages: 2088, average fill: 65% 
    Primary pages: 2087, secondary pages: 1, swept pages: 0 
    Empty pages: 177, full pages: 1228 
    Fill distribution: 
     0 - 19% = 358 
    20 - 39% = 231 
    40 - 59% = 157 
    60 - 79% = 294 
    80 - 99% = 1048 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1697841, depth: 3, leaf buckets: 310, nodes: 101781 
    Average node length: 13.04, total dup: 7845, max dup: 3 
    Average key length: 10.55, compression ratio: 2.56 
    Average prefix length: 19.37, average data length: 7.63 
    Clustering factor: 72142, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 49 
        40 - 59% = 166 
        60 - 79% = 74 
        80 - 99% = 19 
 
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: 228, 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: 3 
    Data pages: 3, average fill: 31% 
    Primary pages: 1, secondary pages: 2, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.06, total records: 2072 
    Average version length: 43.51, total versions: 1895, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.81 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 68% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 2, full pages: 18 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 8 
    60 - 79% = 1 
    80 - 99% = 18 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88003, depth: 2, leaf buckets: 4, nodes: 2072 
    Average node length: 4.22, total dup: 1974, max dup: 193 
    Average key length: 2.52, compression ratio: 7.55 
    Average prefix length: 18.53, average data length: 0.47 
    Clustering factor: 1129, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        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.71, total records: 68 
    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: 48% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 68 
    Average node length: 11.71, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.29, average data length: 7.71 
    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.23, total records: 806232 
    Average version length: 37.89, total versions: 32406, 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: 8376 
    Data pages: 8376, average fill: 66% 
    Primary pages: 8375, secondary pages: 1, swept pages: 1394 
    Empty pages: 35, full pages: 7639 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 40 
    40 - 59% = 180 
    60 - 79% = 8023 
    80 - 99% = 76 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 836, nodes: 792781 
    Average node length: 4.88, total dup: 792732, max dup: 145376 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90354, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 112 
        40 - 59% = 433 
        60 - 79% = 174 
        80 - 99% = 115 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 950, nodes: 792781 
    Average node length: 5.89, total dup: 705792, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160101, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 558 
        60 - 79% = 90 
        80 - 99% = 262 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 971, nodes: 792781 
    Average node length: 5.89, total dup: 705792, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162021, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 89 
        40 - 59% = 536 
        60 - 79% = 78 
        80 - 99% = 268 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1129, nodes: 792781 
    Average node length: 5.97, total dup: 705792, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154477, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 236 
        40 - 59% = 606 
        60 - 79% = 201 
        80 - 99% = 83 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.86, total records: 5530 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.27, total fragments: 48, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 78, secondary pages: 10, swept pages: 57 
    Empty pages: 3, full pages: 60 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5530 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.13 
    Average prefix length: 34.62, average data length: 1.54 
    Clustering factor: 5274, ratio: 0.95 
    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: 5530 
    Average node length: 11.12, 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: 157, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.07, total records: 76823 
    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: 800 
    Data pages: 800, average fill: 66% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 798 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 798 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37209, depth: 2, leaf buckets: 98, nodes: 76823 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2759, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 96 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.04, 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.23 
    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: 144.88, total records: 192861 
    Average version length: 151.52, total versions: 8552, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 7, data page slots: 7424 
    Data pages: 4856, average fill: 82% 
    Primary pages: 4854, secondary pages: 2, swept pages: 1 
    Empty pages: 98, full pages: 4717 
    Fill distribution: 
     0 - 19% = 102 
    20 - 39% = 11 
    40 - 59% = 10 
    60 - 79% = 14 
    80 - 99% = 4719 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 132.46, total records: 151981 
    Average version length: 153.95, total versions: 19737, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.80 
    Pointer pages: 6, data page slots: 5584 
    Data pages: 3904, average fill: 82% 
    Primary pages: 3902, secondary pages: 2, swept pages: 1 
    Empty pages: 143, full pages: 3713 
    Fill distribution: 
     0 - 19% = 143 
    20 - 39% = 23 
    40 - 59% = 14 
    60 - 79% = 10 
    80 - 99% = 3714 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 144.36, total records: 128379 
    Average version length: 149.48, total versions: 5946, 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: 6, data page slots: 4328 
    Data pages: 3264, average fill: 81% 
    Primary pages: 3262, secondary pages: 2, swept pages: 6 
    Empty pages: 103, full pages: 3140 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 3139 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.95, total records: 165486 
    Average version length: 149.77, total versions: 4969, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 6, data page slots: 5704 
    Data pages: 4168, average fill: 82% 
    Primary pages: 4166, secondary pages: 2, swept pages: 2 
    Empty pages: 85, full pages: 4052 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 12 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4053 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.98, total records: 162338 
    Average version length: 152.82, total versions: 9385, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.86 
    Pointer pages: 8, data page slots: 6608 
    Data pages: 4192, average fill: 81% 
    Primary pages: 4190, secondary pages: 2, swept pages: 1 
    Empty pages: 180, full pages: 3966 
    Fill distribution: 
     0 - 19% = 184 
    20 - 39% = 15 
    40 - 59% = 9 
    60 - 79% = 18 
    80 - 99% = 3966 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 142.64, total records: 161331 
    Average version length: 152.27, total versions: 9530, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 7, data page slots: 5248 
    Data pages: 4104, average fill: 82% 
    Primary pages: 4100, secondary pages: 4, swept pages: 6 
    Empty pages: 126, full pages: 3945 
    Fill distribution: 
     0 - 19% = 129 
    20 - 39% = 11 
    40 - 59% = 6 
    60 - 79% = 13 
    80 - 99% = 3945 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 143.24, total records: 156104 
    Average version length: 151.46, total versions: 8457, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.84 
    Pointer pages: 7, data page slots: 5440 
    Data pages: 3936, average fill: 82% 
    Primary pages: 3934, secondary pages: 2, swept pages: 6 
    Empty pages: 93, full pages: 3804 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 20 
    80 - 99% = 3805 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 120.66, total records: 199399 
    Average version length: 154.64, total versions: 42751, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.06 
    Pointer pages: 6, data page slots: 6352 
    Data pages: 5072, average fill: 84% 
    Primary pages: 5068, secondary pages: 4, swept pages: 6 
    Empty pages: 133, full pages: 4893 
    Fill distribution: 
     0 - 19% = 135 
    20 - 39% = 18 
    40 - 59% = 13 
    60 - 79% = 13 
    80 - 99% = 4893 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 138.34, total records: 171674 
    Average version length: 153.27, total versions: 15457, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.26 
    Pointer pages: 6, data page slots: 7384 
    Data pages: 4392, average fill: 82% 
    Primary pages: 4389, secondary pages: 3, swept pages: 5 
    Empty pages: 149, full pages: 4198 
    Fill distribution: 
     0 - 19% = 152 
    20 - 39% = 14 
    40 - 59% = 15 
    60 - 79% = 14 
    80 - 99% = 4197 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 144.33, total records: 168730 
    Average version length: 151.77, total versions: 8248, 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: 6, data page slots: 7008 
    Data pages: 4272, average fill: 82% 
    Primary pages: 4270, secondary pages: 2, swept pages: 2 
    Empty pages: 105, full pages: 4134 
    Fill distribution: 
     0 - 19% = 107 
    20 - 39% = 17 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4134 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.93, total records: 2105357 
    Average version length: 52.92, total versions: 39113, max versions: 1 
    Average fragment length: 44.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25624 
    Data pages: 25616, average fill: 71% 
    Primary pages: 25602, secondary pages: 14, swept pages: 10348 
    Empty pages: 92, full pages: 22931 
    Fill distribution: 
     0 - 19% = 198 
    20 - 39% = 216 
    40 - 59% = 641 
    60 - 79% = 24170 
    80 - 99% = 391 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2587, nodes: 2105357 
    Average node length: 5.44, total dup: 1965237, max dup: 1211 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182451, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 288 
        40 - 59% = 1685 
        60 - 79% = 326 
        80 - 99% = 282 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2757, nodes: 2105357 
    Average node length: 5.69, total dup: 1889849, max dup: 65 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376515, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2397 
        60 - 79% = 326 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2102, nodes: 2105357 
    Average node length: 4.96, total dup: 2105257, max dup: 28798 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180437, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 192 
        40 - 59% = 1047 
        60 - 79% = 403 
        80 - 99% = 459 
 
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: 45.16, total records: 152550 
    Average version length: 69.18, total versions: 60945, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.79 
    Pointer pages: 3, data page slots: 4296 
    Data pages: 3256, average fill: 56% 
    Primary pages: 3256, secondary pages: 0, swept pages: 480 
    Empty pages: 574, full pages: 1737 
    Fill distribution: 
     0 - 19% = 766 
    20 - 39% = 180 
    40 - 59% = 290 
    60 - 79% = 1035 
    80 - 99% = 985 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554928, depth: 3, leaf buckets: 225, nodes: 152550 
    Average node length: 6.44, total dup: 132900, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 26073, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 113 
        60 - 79% = 67 
        80 - 99% = 9 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.93, total records: 7048371 
    Average version length: 68.74, total versions: 355877, 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: 65, data page slots: 105144 
    Data pages: 105144, average fill: 72% 
    Primary pages: 105143, secondary pages: 1, swept pages: 19493 
    Empty pages: 53, full pages: 73449 
    Fill distribution: 
     0 - 19% = 248 
    20 - 39% = 481 
    40 - 59% = 4971 
    60 - 79% = 98297 
    80 - 99% = 1147 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10720, nodes: 7048371 
    Average node length: 6.51, total dup: 6097405, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1667249, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1650 
        40 - 59% = 5981 
        60 - 79% = 2642 
        80 - 99% = 441 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8507, nodes: 7048371 
    Average node length: 5.40, total dup: 6768546, max dup: 184 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1468731, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1205 
        40 - 59% = 4588 
        60 - 79% = 1689 
        80 - 99% = 1014 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8539, nodes: 7048371 
    Average node length: 5.40, total dup: 6768546, max dup: 184 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1471004, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1231 
        40 - 59% = 4606 
        60 - 79% = 1661 
        80 - 99% = 1029 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.57, total records: 12051278 
    Average version length: 68.73, total versions: 276283, 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: 107, data page slots: 174000 
    Data pages: 174000, average fill: 74% 
    Primary pages: 174000, secondary pages: 0, swept pages: 66255 
    Empty pages: 0, full pages: 155039 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 313 
    40 - 59% = 3788 
    60 - 79% = 168177 
    80 - 99% = 1704 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18318, nodes: 12048732 
    Average node length: 6.61, total dup: 10506772, max dup: 66 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.71, average data length: 1.29 
    Clustering factor: 2491021, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2468 
        40 - 59% = 10269 
        60 - 79% = 4664 
        80 - 99% = 894 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 47.57, total records: 1495693 
    Average version length: 69.06, total versions: 302172, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.65 
    Pointer pages: 26, data page slots: 41984 
    Data pages: 27504, average fill: 55% 
    Primary pages: 27441, secondary pages: 63, swept pages: 7195 
    Empty pages: 2577, full pages: 18018 
    Fill distribution: 
     0 - 19% = 4412 
    20 - 39% = 4424 
    40 - 59% = 2470 
    60 - 79% = 12217 
    80 - 99% = 3981 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1725, nodes: 1261489 
    Average node length: 5.52, total dup: 1210419, max dup: 49 
    Average key length: 2.57, compression ratio: 16.34 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 88564, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 447 
        40 - 59% = 834 
        60 - 79% = 370 
        80 - 99% = 66 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 39.96, total records: 1219035 
    Average version length: 69.05, total versions: 156046, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.15 
    Pointer pages: 22, data page slots: 34792 
    Data pages: 28952, average fill: 36% 
    Primary pages: 28951, secondary pages: 1, swept pages: 6323 
    Empty pages: 6155, full pages: 8809 
    Fill distribution: 
     0 - 19% = 9415 
    20 - 39% = 4783 
    40 - 59% = 7901 
    60 - 79% = 6605 
    80 - 99% = 248 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1262, nodes: 784928 
    Average node length: 5.92, total dup: 724918, max dup: 63 
    Average key length: 2.98, compression ratio: 14.08 
    Average prefix length: 41.09, average data length: 0.91 
    Clustering factor: 115256, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 454 
        40 - 59% = 601 
        60 - 79% = 201 
        80 - 99% = 5 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.45, total records: 9126660 
    Average version length: 68.96, total versions: 365029, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 89, data page slots: 143672 
    Data pages: 143648, average fill: 68% 
    Primary pages: 143627, secondary pages: 21, swept pages: 51078 
    Empty pages: 316, full pages: 73332 
    Fill distribution: 
     0 - 19% = 1031 
    20 - 39% = 4952 
    40 - 59% = 18330 
    60 - 79% = 117042 
    80 - 99% = 2293 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13443, nodes: 9120329 
    Average node length: 6.68, total dup: 7564576, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2038252, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1285 
        40 - 59% = 6943 
        60 - 79% = 4622 
        80 - 99% = 592 
 
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: 21114660 
    Average version length: 83.06, total versions: 10528, 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: 319264 
    Data pages: 319264, average fill: 81% 
    Primary pages: 319258, secondary pages: 6, swept pages: 12871 
    Empty pages: 23, full pages: 318613 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 47 
    40 - 59% = 120 
    60 - 79% = 48753 
    80 - 99% = 270296 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19355, nodes: 21114660 
    Average node length: 5.72, total dup: 20634415, max dup: 136 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280244, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8141 
        60 - 79% = 531 
        80 - 99% = 10676 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17161, nodes: 21114660 
    Average node length: 6.31, total dup: 18556717, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917516, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 802 
        60 - 79% = 298 
        80 - 99% = 16056 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21113, nodes: 21114660 
    Average node length: 6.35, total dup: 18474826, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573120, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 8357 
        60 - 79% = 595 
        80 - 99% = 12158 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16062, nodes: 21114660 
    Average node length: 5.56, total dup: 21114560, max dup: 230570 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946081, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 6 
        40 - 59% = 2883 
        60 - 79% = 340 
        80 - 99% = 12831 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.76, total records: 9552108 
    Average version length: 82.62, total versions: 344747, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 104, data page slots: 169168 
    Data pages: 169120, average fill: 70% 
    Primary pages: 169084, secondary pages: 36, swept pages: 74905 
    Empty pages: 593, full pages: 99699 
    Fill distribution: 
     0 - 19% = 1741 
    20 - 39% = 6682 
    40 - 59% = 21624 
    60 - 79% = 119542 
    80 - 99% = 19531 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11336, nodes: 9552108 
    Average node length: 5.35, total dup: 9244822, max dup: 171 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2159807, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 75 
        40 - 59% = 8688 
        60 - 79% = 2524 
        80 - 99% = 44 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13346, nodes: 9552108 
    Average node length: 6.22, total dup: 7918093, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1513635, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 3992 
        40 - 59% = 4230 
        60 - 79% = 2643 
        80 - 99% = 2352 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12649, nodes: 9552108 
    Average node length: 5.97, total dup: 8285295, max dup: 36 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2345328, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 95 
        40 - 59% = 9683 
        60 - 79% = 2809 
        80 - 99% = 62 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9922, nodes: 9552108 
    Average node length: 5.12, total dup: 9552008, max dup: 162057 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1538851, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1265 
        40 - 59% = 4816 
        60 - 79% = 1712 
        80 - 99% = 2097 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.98, total records: 11265795 
    Average version length: 82.61, total versions: 355252, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 118, data page slots: 191600 
    Data pages: 189880, average fill: 73% 
    Primary pages: 189761, secondary pages: 119, swept pages: 63363 
    Empty pages: 2272, full pages: 147883 
    Fill distribution: 
     0 - 19% = 3906 
    20 - 39% = 6030 
    40 - 59% = 15642 
    60 - 79% = 98055 
    80 - 99% = 66247 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13115, nodes: 11265795 
    Average node length: 5.30, total dup: 11156157, max dup: 637 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2359604, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 158 
        40 - 59% = 9225 
        60 - 79% = 3592 
        80 - 99% = 139 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10369, nodes: 11265795 
    Average node length: 5.50, total dup: 10774328, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 725914, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 829 
        40 - 59% = 2543 
        60 - 79% = 1795 
        80 - 99% = 5056 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15004, nodes: 11265795 
    Average node length: 6.03, total dup: 9831892, max dup: 69 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2376058, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 197 
        40 - 59% = 10765 
        60 - 79% = 3872 
        80 - 99% = 167 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10699, nodes: 11265795 
    Average node length: 5.22, total dup: 11265695, max dup: 200027 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 714401, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 109 
        20 - 39% = 766 
        40 - 59% = 4777 
        60 - 79% = 1496 
        80 - 99% = 3551 
 
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.27, total records: 9644222 
    Average version length: 82.94, total versions: 321878, 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: 107, data page slots: 174136 
    Data pages: 174056, average fill: 69% 
    Primary pages: 174034, secondary pages: 22, swept pages: 80396 
    Empty pages: 566, full pages: 98114 
    Fill distribution: 
     0 - 19% = 1938 
    20 - 39% = 8757 
    40 - 59% = 26301 
    60 - 79% = 118696 
    80 - 99% = 18364 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11730, nodes: 9644222 
    Average node length: 5.17, total dup: 9615812, max dup: 1525 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1948947, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1531 
        40 - 59% = 7910 
        60 - 79% = 1701 
        80 - 99% = 564 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13505, nodes: 9644222 
    Average node length: 6.24, total dup: 7994801, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1470021, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 4038 
        40 - 59% = 4225 
        60 - 79% = 2626 
        80 - 99% = 2461 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12365, nodes: 9644222 
    Average node length: 5.42, total dup: 9211577, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2081586, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 1498 
        40 - 59% = 8744 
        60 - 79% = 1566 
        80 - 99% = 541 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10064, nodes: 9644222 
    Average node length: 5.14, total dup: 9644122, max dup: 164678 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1556918, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1195 
        40 - 59% = 5041 
        60 - 79% = 1680 
        80 - 99% = 2103 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.57, total records: 572828 
    Average version length: 68.82, total versions: 5784, 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: 8000 
    Data pages: 8000, average fill: 75% 
    Primary pages: 8000, secondary pages: 0, swept pages: 3252 
    Empty pages: 0, full pages: 7150 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 5 
    40 - 59% = 85 
    60 - 79% = 7816 
    80 - 99% = 94 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41249, depth: 3, leaf buckets: 737, nodes: 572828 
    Average node length: 5.95, total dup: 487625, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 101190, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 526 
        60 - 79% = 91 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29046, depth: 3, leaf buckets: 751, nodes: 572828 
    Average node length: 6.15, total dup: 469799, max dup: 17 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101226, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 522 
        60 - 79% = 103 
        80 - 99% = 98 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 567, nodes: 572828 
    Average node length: 4.86, total dup: 572728, max dup: 9463 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89882, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 336 
        60 - 79% = 81 
        80 - 99% = 118 
 
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 Wed Apr 10 10:10:10 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7730086 71149 1 0.0000 0.0000
DOC_LIST 2241695 38341 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2843 8 700.0000 0.0000
INVNT_TURNOVER_LOG 101781 83518 1 0.0000 0.0000
MONEY_SALDO 49 228 6 400.0000 0.0000
MONEY_TURNOVER_LOG 2072 1895 1 0.0000 0.0000
PDISTR 806232 32406 3 0.0000 0.0000
PERF_SPLIT_0 192861 8552 1 0.0000 0.0000
PERF_SPLIT_1 151981 19737 1 0.0000 0.0000
PERF_SPLIT_2 128379 5946 1 0.0000 0.0000
PERF_SPLIT_3 165486 4969 1 0.0000 0.0000
PERF_SPLIT_4 162338 9385 1 0.0000 0.0000
PERF_SPLIT_5 161331 9530 1 0.0000 0.0000
PERF_SPLIT_6 156104 8457 1 0.0000 0.0000
PERF_SPLIT_7 199399 42751 1 0.0000 0.0000
PERF_SPLIT_8 171674 15457 1 0.0000 0.0000
PERF_SPLIT_9 168730 8248 1 0.0000 0.0000
PSTORNED 2105357 39113 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 152550 60945 1 0.0000 0.0000
XQD_1000_3300 7048371 355877 1 0.0000 0.0000
XQD_1200_2000 12051278 276283 1 0.0000 0.0000
XQD_2000_3300 1495693 302172 1 0.0000 0.0000
XQD_2100_3300 1219035 156046 1 0.0000 0.0000
XQD_3300_3400 9126660 365029 1 0.0000 0.0000
XQS_1000_1200 21114660 10528 1 0.0000 0.0000
XQS_1000_3300 9552108 344747 1 0.0000 0.0000
XQS_1200_2000 11265795 355252 1 0.0000 0.0000
XQS_2100_3300 9644222 321878 1 0.0000 0.0000
XQS_3300_3400 572828 5784 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 ---
:375: 
:376: mscs-test-161.budzdorov.ru    Wed Apr 10 10:07:55 2024
:377:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:378: 
:379: 
:380: mscs-test-161.budzdorov.ru    Wed Apr 10 10:07:57 2024
:381:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:382: 
:383: 
:384: mscs-test-161.budzdorov.ru    Wed Apr 10 10:07:59 2024
:385:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:386: 
:387: 
:388: mscs-test-161.budzdorov.ru    Wed Apr 10 10:08:08 2024
:389:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:390: 
:391: 
:392: mscs-test-161.budzdorov.ru    Wed Apr 10 10:08:09 2024
:393:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:394: 
:395: 
:396: mscs-test-161.budzdorov.ru    Wed Apr 10 10:08:09 2024
:397:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:398: 
--- end of diff output ---

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

10.04.24 10:10:22. 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-04-10 10:10:25 No severe PSQL-related problems occured
10.04.24 10:10:26. End of report.