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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-07 01:09:45
DTS_END                         2024-03-07 01:09:45.1380
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36922
TRN_ID                          178149
ATT_ID                          612
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: 9148.29 20031 914829
customer order: creation 176.10 333 17610
customer order: refuse 14.78 365 1478
order to supplier: creation 46.45 1233 4645
order to supplier: removal 3.59 98754 359
invoice (draft): creation 45.49 3558 4549
invoice (draft): removal 50.78 777 5078
invoice accept: apply 41.60 19542 4160
invoice accept: cancel 45.29 800 4529
customer reserve: creation 3966.79 189 396679
customer reserve: removal 4462.34 63 446234
realization accept: apply 84.36 182 8436
realization accept: cancel 78.54 122 7854
payment from customer: creation 60.30 98 6030
payment from customer: removal 5.39 75 539
payment to supplier: creation 50.18 126 5018
payment to supplier: removal 3.84 75 384
service: total inventory turnovers 4.92 1068 492
service: total monetary turnovers 6.57 54 657
service: aggregate perf. data 0.95 18146 95
service: refresh index statistics 0.03 255067 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-03-2024 01:11:05 to 07-03-2024 01:11:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 579
TEST_TIME 2 702
TEST_TIME 3 1723
TEST_TIME 4 2436
TEST_TIME 5 3312
TEST_TIME 6 3809
TEST_TIME 7 4065
TEST_TIME 8 4427
TEST_TIME 9 4543
TEST_TIME 10 4533
TEST_TIME 11 4464
TEST_TIME 12 4592
TEST_TIME 13 5066
TEST_TIME 14 5317
TEST_TIME 15 5744
TEST_TIME 16 5913
TEST_TIME 17 6099
TEST_TIME 18 6461
TEST_TIME 19 6577
TEST_TIME 20 6864
TEST_TIME 21 7053
TEST_TIME 22 7583
TEST_TIME 23 7718
TEST_TIME 24 7749
TEST_TIME 25 7722
TEST_TIME 26 8626
TEST_TIME 27 9571
TEST_TIME 28 9346
TEST_TIME 29 9080
TEST_TIME 30 9145
TEST_TIME 31 9121
TEST_TIME 32 8986
TEST_TIME 33 8805
TEST_TIME 34 8783
TEST_TIME 35 8690
TEST_TIME 36 8684
TEST_TIME 37 8544
TEST_TIME 38 8482
TEST_TIME 39 8643
TEST_TIME 40 8725
TEST_TIME 41 8663
TEST_TIME 42 8704
TEST_TIME 43 8701
TEST_TIME 44 8810
TEST_TIME 45 8753
TEST_TIME 46 8903
TEST_TIME 47 8854
TEST_TIME 48 8832
TEST_TIME 49 8878
TEST_TIME 50 8850
TEST_TIME 51 8923
TEST_TIME 52 8979
TEST_TIME 53 9101
TEST_TIME 54 9063
TEST_TIME 55 9182
TEST_TIME 56 9169
TEST_TIME 57 9138
TEST_TIME 58 9113
TEST_TIME 59 9023
TEST_TIME 60 8990
TEST_TIME 61 8955
TEST_TIME 62 9065
TEST_TIME 63 9048
TEST_TIME 64 8974
TEST_TIME 65 8978
TEST_TIME 66 8938
TEST_TIME 67 8908
TEST_TIME 68 8949
TEST_TIME 69 8994
TEST_TIME 70 8955
TEST_TIME 71 8973
TEST_TIME 72 8987
TEST_TIME 73 9041
TEST_TIME 74 9132
TEST_TIME 75 9140
TEST_TIME 76 9157
TEST_TIME 77 9197
TEST_TIME 78 9250
TEST_TIME 79 9204
TEST_TIME 80 9281
TEST_TIME 81 9282
TEST_TIME 82 9363
TEST_TIME 83 9326
TEST_TIME 84 9237
TEST_TIME 85 9229
TEST_TIME 86 9191
TEST_TIME 87 9188
TEST_TIME 88 9170
TEST_TIME 89 9122
TEST_TIME 90 9109
TEST_TIME 91 9083
TEST_TIME 92 9023
TEST_TIME 93 9051
TEST_TIME 94 9108
TEST_TIME 95 9123
TEST_TIME 96 9112
TEST_TIME 97 9105
TEST_TIME 98 9153
TEST_TIME 99 9165
TEST_TIME 100 9150

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-03-2024 01:11:09 to 07-03-2024 01:11:12.

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 1277717 1277717 0 0.00 0 31063 7 0 0
doc_list_biud 1277696 1277696 0 0.00 0 30926 28 0 0
sp_add_invoice_to_stock 4255 4160 95 2.23 40 170170 19543 0 95
sp_cancel_adding_invoice 4529 4529 0 0.00 4 59582 801 0 0
sp_cancel_client_order 1478 1478 0 0.00 4 10796 366 0 0
sp_cancel_customer_reserve 446234 446234 0 0.00 1 26824 64 0 0
sp_cancel_pay_from_customer 539 539 0 0.00 2 3726 76 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 3 3260 76 0 0
sp_cancel_supplier_invoice 5090 5078 12 0.23 1 31038 778 0 12
sp_cancel_supplier_order 359 359 0 0.00 4 853462 98755 0 0
sp_cancel_write_off 7854 7854 0 0.00 1 10599 123 0 0
sp_client_order 17610 17610 0 0.00 3 26838 333 0 0
sp_customer_reserve 396679 396679 0 0.00 0 37420 190 0 0
sp_fill_shopping_cart 26803 26803 0 0.00 1 17273 37 0 0
sp_fill_shopping_cart_clo_res 396679 396679 0 0.00 0 19102 15 0 0
sp_get_clo_for_invoice 4159 4159 0 0.00 0 24513 313 0 0
sp_kill_cost_storno 13306 13306 0 0.00 0 11338 57 0 0
sp_kill_qstorno_ret_qs2qd 905759 905759 0 0.00 0 30925 34 0 0
sp_kill_qty_storno 478115 478115 0 0.00 0 30926 73 0 0
sp_lock_selected_doc 17464 17464 0 0.00 0 7186 6 0 0
sp_make_cost_storno 23643 23643 0 0.00 0 30696 68 0 0
sp_multiply_rows_for_pdistr 23623 23623 0 0.00 0 7557 23 0 0
sp_multiply_rows_for_qdistr 17610 17610 0 0.00 0 26821 157 0 0
sp_pay_from_customer 6030 6030 0 0.00 4 11241 98 0 0
sp_pay_to_supplier 5018 5018 0 0.00 5 16604 127 0 0
sp_payment_common 11039 11039 0 0.00 1 8273 26 0 0
sp_qd_handle_on_cancel_clo 1478 1478 0 0.00 0 10782 335 0 0
sp_qd_handle_on_invoice_upd_sts 8683 8683 0 0.00 0 12254 297 0 0
sp_qd_handle_on_reserve_upd_sts 8429 8429 0 0.00 0 20439 63 0 0
sp_reserve_write_off 8436 8436 0 0.00 6 25032 182 0 0
sp_supplier_invoice 4549 4549 0 0.00 7 95999 3558 0 0
sp_supplier_order 4645 4645 0 0.00 5 67146 1234 0 0
srv_aggregate_perf_data 95 95 0 0.00 2239 218594 18146 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1824 146402 41318 0 0
srv_find_qd_qs_mism 871925 871925 0 0.00 0 13712 6 0 0
srv_make_invnt_saldo 492 492 0 0.00 26 66638 1068 0 0
srv_make_money_saldo 657 657 0 0.00 1 15007 54 0 0
srv_recalc_idx_stat 3 3 0 0.00 117914 419581 255067 0 0
t$perf-abend:sp_add_invoice_to_stock 95 95 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4160 4160 0 0.00 0 22089 161 0 0
t$perf-norm:sp_cancel_adding_invoice 336 336 0 0.00 0 4847 127 0 0
t$perf-norm:sp_cancel_client_order 1478 1478 0 0.00 0 11472 24 0 0
t$perf-norm:sp_cancel_customer_reserve 591 591 0 0.00 0 698 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 539 539 0 0.00 0 1928 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 477 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 353 353 0 0.00 0 311 7 0 0
t$perf-norm:sp_cancel_supplier_order 359 359 0 0.00 0 37619 1929 0 0
t$perf-norm:sp_cancel_write_off 841 841 0 0.00 0 1828 6 0 0
t$perf-norm:sp_client_order 17610 17610 0 0.00 0 17576 18 0 0
t$perf-norm:sp_customer_reserve 795 795 0 0.00 0 1653 6 0 0
t$perf-norm:sp_pay_from_customer 6030 6030 0 0.00 0 21507 18 0 0
t$perf-norm:sp_pay_to_supplier 5018 5018 0 0.00 0 21469 15 0 0
t$perf-norm:sp_reserve_write_off 8436 8436 0 0.00 0 21503 19 0 0
t$perf-norm:sp_supplier_invoice 4549 4549 0 0.00 0 4173 19 0 0
t$perf-norm:sp_supplier_order 4645 4645 0 0.00 0 8777 17 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 694 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 61 2 0 0
t$perf-norm:srv_make_invnt_saldo 492 492 0 0.00 0 784 21 0 0
t$perf-norm:srv_make_money_saldo 657 657 0 0.00 0 9269 39 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 11 4 0 0
v_add_invoice_to_stock 8498 8308 190 2.23 0 6360 18 0 190
v_all_customers 32638 32638 0 0.00 0 164 1 0 0
v_all_suppliers 26210 26210 0 0.00 0 24 1 0 0
v_all_wares 35220 35220 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 672 672 0 0.00 0 233 6 0 0
v_cancel_client_order 2956 2956 0 0.00 0 1054 3 0 0
v_cancel_customer_prepayment 1078 1078 0 0.00 0 303 3 0 0
v_cancel_customer_reserve 1182 1182 0 0.00 0 1015 5 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 423 3 0 0
v_cancel_supplier_invoice 730 706 24 3.28 0 3670 23 0 24
v_cancel_supplier_order 718 718 0 0.00 0 2658 10 0 0
v_cancel_write_off 1682 1682 0 0.00 0 3309 13 0 0
v_max_id_clo_ord 4645 4645 0 0.00 0 681 1 0 0
v_max_id_clo_res 795 795 0 0.00 0 1255 14 0 0
v_max_id_ord_sup 4548 4548 0 0.00 0 7057 5 0 0
v_max_non_paid_invoice 1100 1100 0 0.00 0 310 2 0 0
v_max_non_paid_realizn 2975 2975 0 0.00 0 3085 4 0 0
v_min_id_clo_ord 4645 4645 0 0.00 0 17265 15 0 0
v_min_id_clo_res 795 795 0 0.00 0 441 2 0 0
v_min_id_ord_sup 4548 4548 0 0.00 0 7040 10 0 0
v_min_non_paid_invoice 5012 5012 0 0.00 0 6742 20 0 0
v_min_non_paid_realizn 6027 6027 0 0.00 0 5185 18 0 0
v_our_firm 8686 8686 0 0.00 0 16 1 0 0
v_reserve_write_off 16858 16858 0 0.00 0 4763 4 0 0
x_lock_depdocs_on_canc_invoice 9254 9254 0 0.00 0 11986 129 0 0
x_lock_depdocs_on_canc_sup_ord 359 359 0 0.00 0 3516 292 0 0
x_make_qstorno_1000_1200 4645 4645 0 0.00 1 67117 1150 0 0
x_make_qstorno_1200_2000 4549 4549 0 0.00 4 95707 3423 0 0
x_make_qstorno_2100_3300 396679 396679 0 0.00 0 35847 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-03-2024 01:11:13 to 07-03-2024 01:11:17.

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
23:09:49 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:49 25459 8192000000 9886084416 10194415616 970063376 10.587 100 89 179 0 998751248 5497648 23190224
23:12:24 5438 8192000000 9928455584 10247720960 1014164736 11.016 100 85 170 0 1044057296 8121744 21770816
23:13:34 1543 8192000000 9963327440 10291011584 1048039600 11.342 100 89 178 0 1080332592 9528416 22764576
23:14:52 11203 8192000000 10008812752 10351259648 1092113952 11.763 100 79 156 5 1121954928 10795648 19045328
23:16:22 7156 8192000000 10071992976 10425614336 1152217104 12.330 100 77 155 0 1182345760 12075792 18052864
23:17:32 4598 8192000000 10113640320 10482577408 1201073936 12.786 100 79 156 0 1230400176 11902784 17423456
23:18:41 1898 8192000000 10155619024 10531172352 1248984944 13.229 100 86 170 2 1280591584 13813632 17793008
23:19:45 1932 8192000000 10188036432 10573283328 1277775888 13.493 100 80 157 1 1308979408 13739648 17463872
23:20:48 1819 8192000000 10223648448 10613338112 1306495856 13.754 100 77 154 1 1337091536 12956256 17639424
23:21:52 9993 8192000000 10197156272 10609819648 1311176832 13.797 100 22 44 0 1321953184 5610480 5165872
23:23:04 11329 8192000000 10206002784 10623397888 1321330960 13.889 100 16 32 1 1330072320 5208432 3532928
23:24:15 8036 8192000000 10214032864 10632859648 1326000016 13.931 100 25 50 0 1337996880 6734800 5262064
23:25:24 65049 8192000000 10229734272 10650406912 1334596336 14.009 100 26 52 0 1346793744 5889136 6308272
23:27:29 5128 8192000000 10221415328 10641416192 1319085488 13.868 99 33 66 0 1333825408 7296832 7443088
23:28:38 8237 8192000000 10208289920 10623979520 1295711776 13.656 98 29 56 1 1308686576 6528736 6446064
23:29:47 146402 8192000000 10211899824 10622193664 1304765696 13.739 100 33 66 1 1317921840 5460960 7695184
23:33:19 24476 8192000000 10232584336 10633445376 1298626320 13.683 98 56 111 2 1326193616 15359616 12207680
23:34:47 5030 8192000000 10229154112 10630041600 1310517888 13.791 100 56 110 1 1340561808 17445104 12598816
23:36:01 9496 8192000000 10215405632 10615558144 1288350992 13.589 99 44 88 0 1316190176 17818288 10020896
23:37:15 32134 8192000000 10215565184 10615660544 1289063776 13.596 99 40 80 0 1316756784 18496528 9196480
23:38:55 8074 8192000000 10205230832 10601435136 1281426944 13.526 99 45 88 0 1310902352 18948976 10526432
23:40:13 9655 8192000000 10261603200 10660126720 1323590256 13.909 99 59 117 0 1359616624 22307616 13718752
23:41:28 7486 8192000000 10277205952 10676224000 1342854416 14.083 100 64 121 3 1388277728 30434192 14989120
23:42:39 13948 8192000000 10264930144 10671050752 1333257936 13.997 99 48 96 0 1376766560 31636944 11871680
23:43:57 3023 8192000000 10285507792 10681610240 1345952064 14.111 100 76 148 0 1395336272 31418656 17965552
23:45:05 17150 8192000000 10292961888 10702049280 1345060864 14.103 99 46 89 1 1386375376 29731552 11582960
23:46:30 1821 8192000000 10328058032 10726969344 1374693536 14.369 100 92 180 0 1432964336 35752896 22517904
23:47:38 2724 8192000000 10333400192 10742513664 1389356400 14.500 100 71 140 0 1439168672 32846560 16965712
23:48:58 3262 8192000000 10353189776 10761560064 1397408448 14.572 100 73 144 1 1452180240 36289024 18482768
23:50:05 10245 8192000000 10338402384 10757926912 1396506064 14.564 100 58 116 0 1447877888 36679824 14692000
23:51:22 9172 8192000000 10350870688 10775801856 1404710544 14.637 100 44 88 0 1458977232 42316080 11950608
23:52:35 17146 8192000000 10344247872 10780999680 1408343440 14.669 100 26 53 0 1446021088 30558544 7119104
23:53:57 18571 8192000000 10340213088 10776641536 1399477296 14.590 99 27 54 0 1443871456 36916656 7477504
23:55:39 32153 8192000000 10316307344 10770915328 1389226912 14.499 100 19 38 1 1433663680 39134256 5302512
23:57:13 78281 8192000000 10310763344 10748973056 1380248272 14.419 99 28 55 0 1399036560 12478272 6310016
23:59:38 66157 8192000000 10302216192 10749116416 1390825088 14.513 100 26 53 0 1405610992 9182480 5603424
00:01:44 133407 8192000000 10325132368 10775580672 1402907664 14.621 100 22 44 0 1417694800 10070528 4716608
00:05:01 42546 8192000000 10322823280 10783715328 1416449408 14.741 100 20 40 0 1436098848 14428928 5220512
00:07:27 16541 8192000000 10323582752 10775248896 1401091664 14.605 99 28 56 1 1426425936 18423904 6910368
00:09:01 19293 8192000000 10323832016 10761924608 1393392080 14.536 99 36 72 1 1418220752 15983888 8844784
00:10:22 45508 8192000000 10314090096 10770673664 1401266960 14.606 100 8 16 0 1419486080 16610304 1608816
00:12:10 49884 8192000000 10300190800 10756354048 1377648288 14.396 98 16 32 1 1390338160 9241888 3447984
00:14:05 36821 8192000000 10290922944 10741862400 1362115072 14.256 97 19 38 1 1376648784 9967760 4565952
00:15:43 66102 8192000000 10295044848 10744791040 1359476288 14.233 97 22 44 0 1372274272 8521264 4276720
00:17:56 19085 8192000000 10298929856 10737201152 1362099456 14.256 98 30 59 0 1378126608 9906656 6120496
00:19:21 62136 8192000000 10283170496 10730311680 1346422208 14.115 98 21 42 0 1367869344 17096176 4350960
00:21:38 84779 8192000000 10280690848 10739163136 1330049728 13.968 96 19 38 0 1349295552 15615776 3630048
00:24:03 61060 8192000000 10285744128 10741215232 1343900416 14.093 97 20 40 1 1362561504 14338352 4322736
00:26:04 57900 8192000000 10270815392 10704322560 1309781232 13.784 96 22 44 0 1333763920 18867840 5114848
00:28:11 61478 8192000000 10266785760 10710757376 1341987120 14.075 99 20 38 0 1356277392 9929456 4360816
00:30:13 4112 8192000000 10244048656 10677559296 1310031600 13.786 97 30 59 0 1331158416 14328912 6797904
00:31:20 26090 8192000000 10256825968 10696278016 1331832704 13.984 99 24 44 0 1350716432 13459696 5424032
00:32:47 45268 8192000000 10252179824 10707144704 1348291248 14.132 100 7 14 0 1361703696 11696496 1715952
00:34:38 38438 8192000000 10260938576 10706124800 1356743008 14.208 99 13 26 0 1377168752 17132768 3292976
00:36:19 109592 8192000000 10246547184 10704015360 1269311920 13.415 93 13 26 0 1284631504 11851424 3468160
00:39:09 50186 8192000000 10284789728 10725539840 1358961120 14.228 99 31 61 2 1378520032 13338320 6220592
00:41:05 37305 8192000000 10292117120 10734317568 1364337952 14.276 99 33 66 0 1383188384 11636432 7214000
00:42:43 52397 8192000000 10297195296 10749796352 1386265936 14.473 100 15 30 0 1405636800 15890512 3480352
00:44:36 27634 8192000000 10299911424 10729541632 1360766912 14.244 98 29 57 0 1374814960 7973760 6074288
00:46:04 20738 8192000000 10316640112 10749399040 1395474016 14.555 100 35 70 0 1413662720 10864544 7324160
00:47:34 74832 8192000000 10303330768 10744197120 1372064352 14.346 99 20 40 0 1390086256 13682160 4339744
00:49:49 72858 8192000000 10316393280 10769117184 1405488096 14.644 100 16 32 0 1420911120 11522624 3900400
00:52:03 115450 8192000000 10303068096 10748981248 1386484048 14.474 99 22 44 0 1402481696 10658448 5339200
00:55:05 64858 8192000000 10303100640 10760634368 1406089552 14.649 100 16 32 0 1419091536 9410240 3591744
00:57:11 17028 8192000000 10305294496 10750455808 1386772608 14.477 99 22 41 0 1398774016 7511168 4490240
00:58:32 25091 8192000000 10272720064 10727899136 1371098480 14.337 99 10 20 1 1381081200 7653184 2329536
00:59:58 57028 8192000000 10278641168 10732847104 1371372272 14.339 99 16 32 0 1388391568 13133200 3886096
01:02:03 59341 8192000000 10285206032 10747559936 1362492544 14.260 99 18 36 0 1388283328 21106736 4684048
01:04:22 68779 8192000000 10267746368 10717380608 1311280464 13.798 95 12 24 0 1326469776 12376496 2812816
01:06:35 12749 8192000000 10275846704 10708426752 1348626544 14.135 99 62 123 2 1372303424 10534432 13142448
01:07:48 60982 8192000000 10276404176 10712653824 1291072064 13.614 95 26 52 1 1309928720 13245536 5611120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 07-03-2024 01:11:19 to 07-03-2024 01:11:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 95 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-03-2024 01:11:34 to 07-03-2024 01:11:36.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Mar  7 01:11:37 2024 
 
Database header page information: 
    Flags            0 
    Generation        93434 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    177975 
    Oldest active        179460 
    Oldest snapshot        179460 
    Next transaction    179461 
    Sequence number        0 
    Next attachment ID    724 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.16, total records: 7795901 
    Average version length: 48.16, total versions: 118670, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86680 
    Data pages: 86680, average fill: 72% 
    Primary pages: 86680, secondary pages: 0, swept pages: 13404 
    Empty pages: 6, full pages: 72862 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 154 
    40 - 59% = 1588 
    60 - 79% = 84892 
    80 - 99% = 19 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23397, nodes: 7795901 
    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: 1734736, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 353 
        20 - 39% = 1789 
        40 - 59% = 4213 
        60 - 79% = 2382 
        80 - 99% = 14660 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13575, nodes: 7795901 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1556525, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1511 
        40 - 59% = 2143 
        60 - 79% = 1117 
        80 - 99% = 8804 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8375, nodes: 7795901 
    Average node length: 6.62, total dup: 5826597, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1549309, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 932 
        40 - 59% = 1434 
        60 - 79% = 912 
        80 - 99% = 4966 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.89, total records: 2259614 
    Average version length: 34.52, total versions: 118971, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28272 
    Data pages: 28272, average fill: 74% 
    Primary pages: 28266, secondary pages: 6, swept pages: 7594 
    Empty pages: 5, full pages: 22436 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 104 
    40 - 59% = 1203 
    60 - 79% = 25851 
    80 - 99% = 1091 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4577, nodes: 2259614 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 696441, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 903 
        40 - 59% = 887 
        60 - 79% = 699 
        80 - 99% = 2087 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2514, nodes: 2262531 
    Average node length: 4.97, total dup: 2261632, max dup: 21342 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1252174, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 228 
        40 - 59% = 1548 
        60 - 79% = 547 
        80 - 99% = 190 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2014, nodes: 2259614 
    Average node length: 4.97, total dup: 2259564, max dup: 130519 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1059270, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 60 
        40 - 59% = 1056 
        60 - 79% = 59 
        80 - 99% = 835 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4348, nodes: 2259614 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 696441, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 564 
        40 - 59% = 586 
        60 - 79% = 820 
        80 - 99% = 2259 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.29, total records: 400 
    Average version length: 23.11, total versions: 242690, max versions: 629 
    Average fragment length: 2.00, total fragments: 58, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1352 
    Data pages: 1352, average fill: 90% 
    Primary pages: 11, secondary pages: 1341, swept pages: 0 
    Empty pages: 4, full pages: 1347 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1347 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 9.12, total records: 70327 
    Average version length: 68.28, total versions: 60937, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 9.65 
    Pointer pages: 6, data page slots: 1800 
    Data pages: 1536, average fill: 58% 
    Primary pages: 1534, secondary pages: 2, swept pages: 0 
    Empty pages: 119, full pages: 618 
    Fill distribution: 
     0 - 19% = 244 
    20 - 39% = 202 
    40 - 59% = 312 
    60 - 79% = 246 
    80 - 99% = 532 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1389047, depth: 3, leaf buckets: 254, nodes: 70327 
    Average node length: 13.04, total dup: 4455, max dup: 2 
    Average key length: 10.81, compression ratio: 2.50 
    Average prefix length: 19.13, average data length: 7.87 
    Clustering factor: 54058, ratio: 0.77 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 100 
        40 - 59% = 132 
        60 - 79% = 21 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18492, max versions: 971 
    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: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 6.05, total records: 1825 
    Average version length: 42.98, total versions: 1579, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 9.59 
    Pointer pages: 1, data page slots: 32 
    Data pages: 30, average fill: 57% 
    Primary pages: 29, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 17 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 15 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89038, depth: 2, leaf buckets: 3, nodes: 1825 
    Average node length: 4.22, total dup: 1727, max dup: 182 
    Average key length: 2.58, compression ratio: 7.37 
    Average prefix length: 18.47, average data length: 0.53 
    Clustering factor: 952, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.06, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.79, total records: 816594 
    Average version length: 25.62, total versions: 81024, max versions: 4 
    Average fragment length: 30.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 7984 
    Data pages: 7976, average fill: 72% 
    Primary pages: 7959, secondary pages: 17, swept pages: 898 
    Empty pages: 17, full pages: 7402 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 22 
    40 - 59% = 48 
    60 - 79% = 7526 
    80 - 99% = 355 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 883, nodes: 816594 
    Average node length: 4.87, total dup: 816545, max dup: 146638 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90410, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 118 
        40 - 59% = 478 
        60 - 79% = 202 
        80 - 99% = 83 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 909, nodes: 816594 
    Average node length: 5.88, total dup: 727257, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162942, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 77 
        40 - 59% = 362 
        60 - 79% = 140 
        80 - 99% = 329 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 955, nodes: 816594 
    Average node length: 5.88, total dup: 727257, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164956, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 186 
        40 - 59% = 319 
        60 - 79% = 107 
        80 - 99% = 342 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1135, nodes: 816594 
    Average node length: 5.96, total dup: 727257, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157968, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 228 
        40 - 59% = 586 
        60 - 79% = 214 
        80 - 99% = 105 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.75, total records: 5467 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.57, total fragments: 93, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 120 
    Data pages: 120, average fill: 45% 
    Primary pages: 99, secondary pages: 21, swept pages: 50 
    Empty pages: 30, full pages: 62 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5467 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5205, 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: 1504233, depth: 2, leaf buckets: 10, nodes: 5467 
    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: 152, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.14, total records: 81945 
    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: 792 
    Data pages: 792, average fill: 71% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 790 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 790 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 40565, depth: 2, leaf buckets: 105, nodes: 81945 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3401, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 103 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 135.68, total records: 196870 
    Average version length: 153.56, total versions: 19769, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.50 
    Pointer pages: 7, data page slots: 7424 
    Data pages: 4760, average fill: 86% 
    Primary pages: 4760, secondary pages: 0, swept pages: 1 
    Empty pages: 76, full pages: 4650 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 8 
    40 - 59% = 11 
    60 - 79% = 10 
    80 - 99% = 4651 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 144.49, total records: 199332 
    Average version length: 151.70, total versions: 9218, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.74 
    Pointer pages: 6, data page slots: 5600 
    Data pages: 4864, average fill: 85% 
    Primary pages: 4864, secondary pages: 0, swept pages: 1 
    Empty pages: 85, full pages: 4690 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 5 
    40 - 59% = 68 
    60 - 79% = 11 
    80 - 99% = 4690 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 130.73, total records: 180225 
    Average version length: 153.72, total versions: 23957, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.97 
    Pointer pages: 6, data page slots: 5280 
    Data pages: 4416, average fill: 85% 
    Primary pages: 4416, secondary pages: 0, swept pages: 3 
    Empty pages: 122, full pages: 4253 
    Fill distribution: 
     0 - 19% = 125 
    20 - 39% = 10 
    40 - 59% = 15 
    60 - 79% = 13 
    80 - 99% = 4253 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 143.99, total records: 173119 
    Average version length: 150.55, total versions: 7727, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.78 
    Pointer pages: 7, data page slots: 6048 
    Data pages: 4232, average fill: 84% 
    Primary pages: 4231, secondary pages: 1, swept pages: 1 
    Empty pages: 118, full pages: 4077 
    Fill distribution: 
     0 - 19% = 121 
    20 - 39% = 16 
    40 - 59% = 7 
    60 - 79% = 10 
    80 - 99% = 4078 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 134.85, total records: 191629 
    Average version length: 152.86, total versions: 20394, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.58 
    Pointer pages: 7, data page slots: 5664 
    Data pages: 4680, average fill: 85% 
    Primary pages: 4680, secondary pages: 0, swept pages: 1 
    Empty pages: 109, full pages: 4512 
    Fill distribution: 
     0 - 19% = 115 
    20 - 39% = 6 
    40 - 59% = 32 
    60 - 79% = 16 
    80 - 99% = 4511 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 140.28, total records: 207146 
    Average version length: 152.19, total versions: 14725, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.09 
    Pointer pages: 6, data page slots: 5504 
    Data pages: 4992, average fill: 86% 
    Primary pages: 4991, secondary pages: 1, swept pages: 3 
    Empty pages: 68, full pages: 4895 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 10 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 4895 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 135.62, total records: 171781 
    Average version length: 153.91, total versions: 17046, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.51 
    Pointer pages: 7, data page slots: 5464 
    Data pages: 4200, average fill: 85% 
    Primary pages: 4200, secondary pages: 0, swept pages: 2 
    Empty pages: 108, full pages: 4047 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 11 
    40 - 59% = 20 
    60 - 79% = 10 
    80 - 99% = 4046 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 144.13, total records: 181468 
    Average version length: 150.57, total versions: 8078, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 6, data page slots: 6440 
    Data pages: 4440, average fill: 84% 
    Primary pages: 4440, secondary pages: 0, swept pages: 1 
    Empty pages: 122, full pages: 4276 
    Fill distribution: 
     0 - 19% = 125 
    20 - 39% = 17 
    40 - 59% = 17 
    60 - 79% = 5 
    80 - 99% = 4276 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 127.60, total records: 204854 
    Average version length: 154.26, total versions: 31432, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.29 
    Pointer pages: 8, data page slots: 7016 
    Data pages: 5024, average fill: 85% 
    Primary pages: 5024, secondary pages: 0, swept pages: 1 
    Empty pages: 141, full pages: 4840 
    Fill distribution: 
     0 - 19% = 146 
    20 - 39% = 9 
    40 - 59% = 12 
    60 - 79% = 18 
    80 - 99% = 4839 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 137.19, total records: 214902 
    Average version length: 153.51, total versions: 20047, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.36 
    Pointer pages: 9, data page slots: 7032 
    Data pages: 5272, average fill: 85% 
    Primary pages: 5272, secondary pages: 0, swept pages: 1 
    Empty pages: 144, full pages: 5089 
    Fill distribution: 
     0 - 19% = 149 
    20 - 39% = 11 
    40 - 59% = 16 
    60 - 79% = 6 
    80 - 99% = 5090 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.30, total records: 2126359 
    Average version length: 52.94, total versions: 58431, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25552 
    Data pages: 25552, average fill: 72% 
    Primary pages: 25552, secondary pages: 0, swept pages: 9188 
    Empty pages: 276, full pages: 21896 
    Fill distribution: 
     0 - 19% = 507 
    20 - 39% = 354 
    40 - 59% = 852 
    60 - 79% = 23293 
    80 - 99% = 546 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2622, nodes: 2126359 
    Average node length: 5.44, total dup: 1984474, max dup: 2047 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183956, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 284 
        40 - 59% = 1749 
        60 - 79% = 298 
        80 - 99% = 285 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2762, nodes: 2126359 
    Average node length: 5.69, total dup: 1909001, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 379909, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 2380 
        60 - 79% = 346 
        80 - 99% = 32 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2174, nodes: 2126359 
    Average node length: 4.96, total dup: 2126259, max dup: 28332 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181605, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 184 
        40 - 59% = 1167 
        60 - 79% = 423 
        80 - 99% = 397 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 38.13, total records: 164419 
    Average version length: 69.18, total versions: 73835, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.30 
    Pointer pages: 3, data page slots: 4016 
    Data pages: 2928, average fill: 65% 
    Primary pages: 2928, secondary pages: 0, swept pages: 399 
    Empty pages: 477, full pages: 2237 
    Fill distribution: 
     0 - 19% = 603 
    20 - 39% = 9 
    40 - 59% = 12 
    60 - 79% = 813 
    80 - 99% = 1491 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101174, depth: 3, leaf buckets: 215, nodes: 164419 
    Average node length: 6.44, total dup: 143269, max dup: 14 
    Average key length: 3.91, compression ratio: 10.74 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 27964, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 99 
        60 - 79% = 71 
        80 - 99% = 33 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.03, total records: 7267130 
    Average version length: 68.80, total versions: 520281, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 64, data page slots: 103632 
    Data pages: 103632, average fill: 75% 
    Primary pages: 103632, secondary pages: 0, swept pages: 17927 
    Empty pages: 17, full pages: 87941 
    Fill distribution: 
     0 - 19% = 211 
    20 - 39% = 1070 
    40 - 59% = 5040 
    60 - 79% = 87156 
    80 - 99% = 10155 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10752, nodes: 7267130 
    Average node length: 6.50, total dup: 6289172, max dup: 29 
    Average key length: 3.51, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1617053, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1416 
        40 - 59% = 5822 
        60 - 79% = 2927 
        80 - 99% = 579 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8568, nodes: 7267130 
    Average node length: 5.39, total dup: 6983659, max dup: 163 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1410091, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 980 
        40 - 59% = 4762 
        60 - 79% = 1746 
        80 - 99% = 1073 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8593, nodes: 7267130 
    Average node length: 5.39, total dup: 6983659, max dup: 163 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1412716, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 987 
        40 - 59% = 4741 
        60 - 79% = 1765 
        80 - 99% = 1092 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.42, total records: 12282160 
    Average version length: 68.74, total versions: 451880, 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: 104, data page slots: 169560 
    Data pages: 169560, average fill: 77% 
    Primary pages: 169560, secondary pages: 0, swept pages: 64911 
    Empty pages: 12, full pages: 164254 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 426 
    40 - 59% = 1895 
    60 - 79% = 157021 
    80 - 99% = 10153 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18509, nodes: 12282160 
    Average node length: 6.59, total dup: 10708824, max dup: 73 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2408238, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1935 
        40 - 59% = 10987 
        60 - 79% = 4837 
        80 - 99% = 721 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 37.83, total records: 1772073 
    Average version length: 69.12, total versions: 802575, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.33 
    Pointer pages: 25, data page slots: 40344 
    Data pages: 28952, average fill: 71% 
    Primary pages: 28952, secondary pages: 0, swept pages: 4462 
    Empty pages: 2239, full pages: 22462 
    Fill distribution: 
     0 - 19% = 3569 
    20 - 39% = 1176 
    40 - 59% = 965 
    60 - 79% = 10138 
    80 - 99% = 13104 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2105, nodes: 1772073 
    Average node length: 5.51, total dup: 1700157, max dup: 97 
    Average key length: 2.55, compression ratio: 16.46 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 118145, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 210 
        40 - 59% = 1033 
        60 - 79% = 630 
        80 - 99% = 226 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.26, total records: 1134778 
    Average version length: 69.14, total versions: 505709, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.29 
    Pointer pages: 21, data page slots: 34152 
    Data pages: 26472, average fill: 50% 
    Primary pages: 26472, secondary pages: 0, swept pages: 5861 
    Empty pages: 5902, full pages: 13421 
    Fill distribution: 
     0 - 19% = 8858 
    20 - 39% = 1857 
    40 - 59% = 1141 
    60 - 79% = 6228 
    80 - 99% = 8388 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1553, nodes: 1134778 
    Average node length: 5.78, total dup: 1060005, max dup: 99 
    Average key length: 2.85, compression ratio: 14.73 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 153302, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 288 
        40 - 59% = 802 
        60 - 79% = 393 
        80 - 99% = 68 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.82, total records: 9296098 
    Average version length: 69.00, total versions: 550531, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 88, data page slots: 142144 
    Data pages: 142120, average fill: 70% 
    Primary pages: 142120, secondary pages: 0, swept pages: 43719 
    Empty pages: 350, full pages: 89543 
    Fill distribution: 
     0 - 19% = 1202 
    20 - 39% = 5875 
    40 - 59% = 19245 
    60 - 79% = 105197 
    80 - 99% = 10601 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13512, nodes: 9296098 
    Average node length: 6.67, total dup: 7712980, max dup: 29 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2011070, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1105 
        40 - 59% = 6966 
        60 - 79% = 4809 
        80 - 99% = 632 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21190738 
    Average version length: 82.96, total versions: 16297, 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: 319184 
    Data pages: 319184, average fill: 81% 
    Primary pages: 319184, secondary pages: 0, swept pages: 11274 
    Empty pages: 5, full pages: 319178 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 26671 
    80 - 99% = 292508 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19567, nodes: 21190738 
    Average node length: 5.72, total dup: 20708933, max dup: 130 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286746, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 0 
        40 - 59% = 8440 
        60 - 79% = 566 
        80 - 99% = 10552 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17208, nodes: 21190738 
    Average node length: 6.31, total dup: 18621583, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916593, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 5 
        40 - 59% = 780 
        60 - 79% = 283 
        80 - 99% = 16136 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21356, nodes: 21190738 
    Average node length: 6.35, total dup: 18541423, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582289, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 8730 
        60 - 79% = 626 
        80 - 99% = 11997 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16194, nodes: 21190738 
    Average node length: 5.56, total dup: 21190638, max dup: 231850 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945423, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2978 
        60 - 79% = 452 
        80 - 99% = 12756 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.74, total records: 9760383 
    Average version length: 82.62, total versions: 554228, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 102, data page slots: 166424 
    Data pages: 166392, average fill: 73% 
    Primary pages: 166392, secondary pages: 0, swept pages: 57825 
    Empty pages: 472, full pages: 110452 
    Fill distribution: 
     0 - 19% = 1319 
    20 - 39% = 5327 
    40 - 59% = 20093 
    60 - 79% = 65781 
    80 - 99% = 73872 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11356, nodes: 9760383 
    Average node length: 5.35, total dup: 9452154, max dup: 204 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2134637, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 50 
        40 - 59% = 8191 
        60 - 79% = 3021 
        80 - 99% = 87 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13437, nodes: 9760383 
    Average node length: 6.22, total dup: 8092870, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1478880, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 3675 
        40 - 59% = 4464 
        60 - 79% = 2602 
        80 - 99% = 2548 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12678, nodes: 9760383 
    Average node length: 5.97, total dup: 8475242, max dup: 43 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2332861, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 70 
        40 - 59% = 9153 
        60 - 79% = 3323 
        80 - 99% = 131 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10137, nodes: 9760383 
    Average node length: 5.12, total dup: 9760283, max dup: 164010 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1506622, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1257 
        40 - 59% = 4946 
        60 - 79% = 1771 
        80 - 99% = 2127 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.18, total records: 11349812 
    Average version length: 82.54, total versions: 430527, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 191728 
    Data pages: 190096, average fill: 73% 
    Primary pages: 190096, secondary pages: 0, swept pages: 66324 
    Empty pages: 2956, full pages: 145361 
    Fill distribution: 
     0 - 19% = 4903 
    20 - 39% = 7228 
    40 - 59% = 16780 
    60 - 79% = 40654 
    80 - 99% = 120531 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13130, nodes: 11349812 
    Average node length: 5.29, total dup: 11240281, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2360286, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 79 
        40 - 59% = 9272 
        60 - 79% = 3638 
        80 - 99% = 137 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10440, nodes: 11349812 
    Average node length: 5.49, total dup: 10853936, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 705060, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 165 
        20 - 39% = 837 
        40 - 59% = 2568 
        60 - 79% = 1770 
        80 - 99% = 5100 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15011, nodes: 11349812 
    Average node length: 6.01, total dup: 9907303, max dup: 66 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2376771, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 102 
        40 - 59% = 10855 
        60 - 79% = 3898 
        80 - 99% = 155 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10756, nodes: 11349812 
    Average node length: 5.21, total dup: 11349712, max dup: 199845 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 694405, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 861 
        40 - 59% = 4712 
        60 - 79% = 1502 
        80 - 99% = 3587 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.20, total records: 9861574 
    Average version length: 82.96, total versions: 540856, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 105, data page slots: 170032 
    Data pages: 169992, average fill: 72% 
    Primary pages: 169992, secondary pages: 0, swept pages: 63772 
    Empty pages: 476, full pages: 105846 
    Fill distribution: 
     0 - 19% = 1370 
    20 - 39% = 5441 
    40 - 59% = 20989 
    60 - 79% = 74762 
    80 - 99% = 67430 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11884, nodes: 9861574 
    Average node length: 5.16, total dup: 9832468, max dup: 2300 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1953843, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1471 
        40 - 59% = 7970 
        60 - 79% = 1827 
        80 - 99% = 581 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13590, nodes: 9861574 
    Average node length: 6.23, total dup: 8176754, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1444507, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 180 
        20 - 39% = 3726 
        40 - 59% = 4481 
        60 - 79% = 2577 
        80 - 99% = 2626 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12498, nodes: 9861574 
    Average node length: 5.42, total dup: 9421533, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2088538, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1447 
        40 - 59% = 8759 
        60 - 79% = 1653 
        80 - 99% = 600 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10229, nodes: 9861574 
    Average node length: 5.13, total dup: 9861474, max dup: 169158 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1530164, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1237 
        40 - 59% = 4980 
        60 - 79% = 1791 
        80 - 99% = 2175 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.25, total records: 583109 
    Average version length: 68.84, total versions: 7958, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 76% 
    Primary pages: 8000, secondary pages: 0, swept pages: 3291 
    Empty pages: 4, full pages: 7250 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 9 
    40 - 59% = 100 
    60 - 79% = 7743 
    80 - 99% = 144 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41464, depth: 3, leaf buckets: 740, nodes: 583109 
    Average node length: 5.94, total dup: 496769, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101524, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 510 
        60 - 79% = 105 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36858, depth: 3, leaf buckets: 766, nodes: 583109 
    Average node length: 6.15, total dup: 478328, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101586, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 534 
        60 - 79% = 100 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 595, nodes: 583109 
    Average node length: 4.86, total dup: 583009, max dup: 9469 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90027, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 380 
        60 - 79% = 81 
        80 - 99% = 103 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Mar  7 01:12:00 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7795901 118670 1 0.0000 0.0000
DOC_LIST 2259614 118971 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 242690 629 60600.0000 0.0000
INVNT_TURNOVER_LOG 70327 60937 1 0.0000 0.0000
MONEY_SALDO 49 18492 971 37700.0000 0.0000
MONEY_TURNOVER_LOG 1825 1579 1 0.0000 0.0000
PDISTR 816594 81024 4 0.0000 0.0000
PERF_SPLIT_0 196870 19769 1 0.0000 0.0000
PERF_SPLIT_1 199332 9218 1 0.0000 0.0000
PERF_SPLIT_2 180225 23957 1 0.0000 0.0000
PERF_SPLIT_3 173119 7727 1 0.0000 0.0000
PERF_SPLIT_4 191629 20394 1 0.0000 0.0000
PERF_SPLIT_5 207146 14725 1 0.0000 0.0000
PERF_SPLIT_6 171781 17046 1 0.0000 0.0000
PERF_SPLIT_7 181468 8078 1 0.0000 0.0000
PERF_SPLIT_8 204854 31432 1 0.0000 0.0000
PERF_SPLIT_9 214902 20047 1 0.0000 0.0000
PSTORNED 2126359 58431 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 164419 73835 1 0.0000 0.0000
XQD_1000_3300 7267130 520281 1 0.0000 0.0000
XQD_1200_2000 12282160 451880 1 0.0000 0.0000
XQD_2000_3300 1772073 802575 1 0.0000 0.0000
XQD_2100_3300 1134778 505709 1 0.0000 0.0000
XQD_3300_3400 9296098 550531 1 0.0000 0.0000
XQS_1000_1200 21190738 16297 1 0.0000 0.0000
XQS_1000_3300 9760383 554228 1 0.0000 0.0000
XQS_1200_2000 11349812 430527 1 0.0000 0.0000
XQS_2100_3300 9861574 540856 1 0.0000 0.0000
XQS_3300_3400 583109 7958 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 ---
:37: 
:38: mscs-test-161.budzdorov.ru    Thu Mar  7 01:09:59 2024
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:40: 
:41: 
:42: mscs-test-161.budzdorov.ru    Thu Mar  7 01:09:59 2024
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
--- end of diff output ---

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

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