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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-06 04:07:48
DTS_END                         2024-04-06 04:07:48.7540
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(68:17)
IP                              ::1/45910
TRN_ID                          166638
ATT_ID                          547
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: 8761.13 19422 876113
customer order: creation 168.84 400 16884
customer order: refuse 14.41 380 1441
order to supplier: creation 45.42 1313 4542
order to supplier: removal 3.51 75880 351
invoice (draft): creation 46.15 3704 4615
invoice (draft): removal 45.87 690 4587
invoice accept: apply 41.10 22136 4110
invoice accept: cancel 41.51 969 4151
customer reserve: creation 3951.43 213 395143
customer reserve: removal 4117.43 52 411743
realization accept: apply 81.50 203 8150
realization accept: cancel 75.66 127 7566
payment from customer: creation 59.33 135 5933
payment from customer: removal 5.78 80 578
payment to supplier: creation 48.85 152 4885
payment to supplier: removal 3.39 81 339
service: total inventory turnovers 3.96 3584 396
service: total monetary turnovers 5.89 531 589
service: aggregate perf. data 1.06 9662 106
service: refresh index statistics 0.04 268140 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-04-2024 04:09:20 to 06-04-2024 04:09:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 605
TEST_TIME 2 1867
TEST_TIME 3 3570
TEST_TIME 4 3529
TEST_TIME 5 4039
TEST_TIME 6 4437
TEST_TIME 7 5456
TEST_TIME 8 6912
TEST_TIME 9 7059
TEST_TIME 10 6933
TEST_TIME 11 6961
TEST_TIME 12 6851
TEST_TIME 13 6726
TEST_TIME 14 6912
TEST_TIME 15 6840
TEST_TIME 16 6922
TEST_TIME 17 6910
TEST_TIME 18 6910
TEST_TIME 19 6915
TEST_TIME 20 7277
TEST_TIME 21 7238
TEST_TIME 22 7242
TEST_TIME 23 7394
TEST_TIME 24 7674
TEST_TIME 25 7904
TEST_TIME 26 7964
TEST_TIME 27 8753
TEST_TIME 28 8870
TEST_TIME 29 8707
TEST_TIME 30 8484
TEST_TIME 31 8241
TEST_TIME 32 8452
TEST_TIME 33 8369
TEST_TIME 34 8463
TEST_TIME 35 8365
TEST_TIME 36 8313
TEST_TIME 37 8411
TEST_TIME 38 8570
TEST_TIME 39 8511
TEST_TIME 40 8551
TEST_TIME 41 8550
TEST_TIME 42 8666
TEST_TIME 43 8760
TEST_TIME 44 8841
TEST_TIME 45 8966
TEST_TIME 46 8950
TEST_TIME 47 9120
TEST_TIME 48 9159
TEST_TIME 49 9195
TEST_TIME 50 9024
TEST_TIME 51 8953
TEST_TIME 52 8931
TEST_TIME 53 8805
TEST_TIME 54 8791
TEST_TIME 55 8808
TEST_TIME 56 8736
TEST_TIME 57 8715
TEST_TIME 58 8768
TEST_TIME 59 8708
TEST_TIME 60 8646
TEST_TIME 61 8669
TEST_TIME 62 8623
TEST_TIME 63 8825
TEST_TIME 64 8776
TEST_TIME 65 8813
TEST_TIME 66 8775
TEST_TIME 67 8809
TEST_TIME 68 8839
TEST_TIME 69 8835
TEST_TIME 70 8816
TEST_TIME 71 8793
TEST_TIME 72 8848
TEST_TIME 73 8889
TEST_TIME 74 8854
TEST_TIME 75 8745
TEST_TIME 76 8709
TEST_TIME 77 8717
TEST_TIME 78 8659
TEST_TIME 79 8667
TEST_TIME 80 8656
TEST_TIME 81 8676
TEST_TIME 82 8718
TEST_TIME 83 8773
TEST_TIME 84 8753
TEST_TIME 85 8854
TEST_TIME 86 8815
TEST_TIME 87 8841
TEST_TIME 88 8873
TEST_TIME 89 8874
TEST_TIME 90 8868
TEST_TIME 91 8929
TEST_TIME 92 8889
TEST_TIME 93 8855
TEST_TIME 94 8837
TEST_TIME 95 8816
TEST_TIME 96 8770
TEST_TIME 97 8711
TEST_TIME 98 8672
TEST_TIME 99 8713
TEST_TIME 100 8761

Performance per minute, chart


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

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 1236052 1236052 0 0.00 0 37767 8 0 0
doc_list_biud 1236048 1236048 0 0.00 0 44156 22 0 0
sp_add_invoice_to_stock 4205 4110 95 2.25 35 257190 22137 0 95
sp_cancel_adding_invoice 4151 4151 0 0.00 5 70223 970 0 0
sp_cancel_client_order 1441 1441 0 0.00 4 8132 380 0 0
sp_cancel_customer_reserve 411743 411743 0 0.00 0 44158 52 0 0
sp_cancel_pay_from_customer 578 578 0 0.00 3 5973 81 0 0
sp_cancel_pay_to_supplier 339 339 0 0.00 2 1967 81 0 0
sp_cancel_supplier_invoice 4591 4587 4 0.08 2 41456 691 0 4
sp_cancel_supplier_order 351 351 0 0.00 5 664550 75880 0 0
sp_cancel_write_off 7566 7566 0 0.00 1 10834 128 0 0
sp_client_order 16884 16884 0 0.00 3 80622 400 0 0
sp_customer_reserve 395143 395143 0 0.00 0 56440 213 0 0
sp_fill_shopping_cart 26017 26017 0 0.00 1 18775 41 0 0
sp_fill_shopping_cart_clo_res 395141 395141 0 0.00 0 24003 16 0 0
sp_get_clo_for_invoice 4108 4108 0 0.00 0 34718 417 0 0
sp_kill_cost_storno 12634 12634 0 0.00 0 16253 67 0 0
sp_kill_qstorno_ret_qs2qd 835990 835990 0 0.00 0 41450 28 0 0
sp_kill_qty_storno 442096 442096 0 0.00 0 44155 62 0 0
sp_lock_selected_doc 17062 17062 0 0.00 0 9888 4 0 0
sp_make_cost_storno 23076 23076 0 0.00 0 10311 66 0 0
sp_multiply_rows_for_pdistr 23072 23072 0 0.00 0 10169 37 0 0
sp_multiply_rows_for_qdistr 16884 16884 0 0.00 0 80610 200 0 0
sp_pay_from_customer 5933 5933 0 0.00 3 9360 136 0 0
sp_pay_to_supplier 4885 4885 0 0.00 4 10183 152 0 0
sp_payment_common 10815 10815 0 0.00 1 8689 31 0 0
sp_qd_handle_on_cancel_clo 1441 1441 0 0.00 0 8126 344 0 0
sp_qd_handle_on_invoice_upd_sts 8259 8259 0 0.00 0 25814 303 0 0
sp_qd_handle_on_reserve_upd_sts 8149 8149 0 0.00 0 17628 58 0 0
sp_reserve_write_off 8150 8150 0 0.00 6 18572 203 0 0
sp_supplier_invoice 4615 4615 0 0.00 5 89962 3704 0 0
sp_supplier_order 4542 4542 0 0.00 4 43116 1314 0 0
srv_aggregate_perf_data 106 106 0 0.00 1583 83965 9662 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1190 120771 42320 0 0
srv_find_qd_qs_mism 833216 833216 0 0.00 0 37767 7 0 0
srv_make_invnt_saldo 396 396 0 0.00 42 131735 3584 0 0
srv_make_money_saldo 589 589 0 0.00 1 12437 532 0 0
srv_recalc_idx_stat 4 4 0 0.00 176535 376378 268141 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 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4110 4110 0 0.00 0 17201 169 0 0
t$perf-norm:sp_cancel_adding_invoice 362 362 0 0.00 0 3706 106 0 0
t$perf-norm:sp_cancel_client_order 1441 1441 0 0.00 0 4135 17 0 0
t$perf-norm:sp_cancel_customer_reserve 586 586 0 0.00 0 2561 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 578 578 0 0.00 0 789 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 339 339 0 0.00 0 2969 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 307 307 0 0.00 0 631 15 0 0
t$perf-norm:sp_cancel_supplier_order 351 351 0 0.00 0 26337 1183 0 0
t$perf-norm:sp_cancel_write_off 841 841 0 0.00 0 5054 21 0 0
t$perf-norm:sp_client_order 16884 16884 0 0.00 0 5765 16 0 0
t$perf-norm:sp_customer_reserve 812 812 0 0.00 0 4738 10 0 0
t$perf-norm:sp_pay_from_customer 5933 5933 0 0.00 0 7191 10 0 0
t$perf-norm:sp_pay_to_supplier 4885 4885 0 0.00 0 9081 13 0 0
t$perf-norm:sp_reserve_write_off 8150 8150 0 0.00 0 12347 13 0 0
t$perf-norm:sp_supplier_invoice 4615 4615 0 0.00 0 2544 14 0 0
t$perf-norm:sp_supplier_order 4542 4542 0 0.00 0 1694 13 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 1208 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 747 14 0 0
t$perf-norm:srv_make_invnt_saldo 396 396 0 0.00 0 684 8 0 0
t$perf-norm:srv_make_money_saldo 589 589 0 0.00 0 1643 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 13 6 0 0
v_add_invoice_to_stock 8406 8216 190 2.26 0 3389 16 0 190
v_all_customers 31406 31406 0 0.00 0 36 0 0 0
v_all_suppliers 26074 26074 0 0.00 0 25 1 0 0
v_all_wares 33768 33768 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 724 724 0 0.00 0 3999 22 0 0
v_cancel_client_order 2882 2882 0 0.00 0 5285 11 0 0
v_cancel_customer_prepayment 1156 1156 0 0.00 0 3376 11 0 0
v_cancel_customer_reserve 1172 1172 0 0.00 0 1314 5 0 0
v_cancel_payment_to_supplier 678 678 0 0.00 0 1917 13 0 0
v_cancel_supplier_invoice 622 614 8 1.28 0 1497 18 0 8
v_cancel_supplier_order 702 702 0 0.00 0 3047 10 0 0
v_cancel_write_off 1682 1682 0 0.00 0 4851 19 0 0
v_max_id_clo_ord 4540 4540 0 0.00 0 297 1 0 0
v_max_id_clo_res 812 812 0 0.00 0 1665 8 0 0
v_max_id_ord_sup 4593 4593 0 0.00 0 3678 3 0 0
v_max_non_paid_invoice 981 981 0 0.00 0 391 3 0 0
v_max_non_paid_realizn 2816 2816 0 0.00 0 4680 6 0 0
v_min_id_clo_ord 4540 4540 0 0.00 0 1443 5 0 0
v_min_id_clo_res 812 812 0 0.00 0 2925 7 0 0
v_min_id_ord_sup 4593 4593 0 0.00 0 3917 6 0 0
v_min_non_paid_invoice 4885 4885 0 0.00 0 8678 21 0 0
v_min_non_paid_realizn 5930 5930 0 0.00 0 8684 25 0 0
v_our_firm 8590 8590 0 0.00 0 19 1 0 0
v_reserve_write_off 16298 16298 0 0.00 0 6332 7 0 0
x_lock_depdocs_on_canc_invoice 8431 8431 0 0.00 0 20693 132 0 0
x_lock_depdocs_on_canc_sup_ord 351 351 0 0.00 0 14023 385 0 0
x_make_qstorno_1000_1200 4542 4542 0 0.00 1 42885 1242 0 0
x_make_qstorno_1200_2000 4615 4615 0 0.00 2 88920 3527 0 0
x_make_qstorno_2100_3300 395143 395143 0 0.00 0 56439 195 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-04-2024 04:09:28 to 06-04-2024 04:09:32.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
02:07:52 1 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
02:08:54 31199 8192000000 9715014240 10013409280 787801984 8.773 100 84 168 0 815568096 7250864 20515248
02:10:29 15882 8192000000 9755241088 10059788288 830533952 9.205 100 93 186 0 864013104 11796288 21682864
02:11:50 10406 8192000000 9778315952 10092916736 848588304 9.386 100 85 170 0 888442416 20093984 19760128
02:13:07 14726 8192000000 9831339584 10162130944 890286240 9.802 100 76 152 0 941552352 34513552 16752560
02:14:26 7182 8192000000 9895411456 10238570496 934766928 10.242 100 82 164 0 1000924400 48933232 17224240
02:15:36 7193 8192000000 9941336224 10293678080 974251696 10.628 100 80 159 0 1049247360 59489520 15506144
02:16:46 4047 8192000000 9969607888 10329600000 1000172656 10.880 100 82 164 0 1086334944 70532736 15629552
02:17:53 2499 8192000000 9994655024 10358390784 1019787600 11.070 100 88 175 0 1117249040 80472720 16988720
02:18:57 2057 8192000000 10006712768 10377383936 1042313232 11.287 100 84 165 0 1120995648 62992032 15690384
02:20:00 1266 8192000000 10038954944 10414960640 1060234416 11.459 100 93 185 0 1150918640 73268992 17415232
02:21:02 3658 8192000000 10009636912 10408939520 1062716304 11.482 100 62 121 0 1146572352 71856064 11999984
02:22:08 4215 8192000000 10005331712 10404196352 1067708624 11.530 100 45 88 1 1121701264 44958976 9033664
02:23:14 43535 8192000000 9981810112 10387996672 1073586816 11.586 100 45 88 0 1105449040 22992560 8869664
02:24:59 5397 8192000000 10001932928 10405965824 1078586192 11.634 100 35 71 0 1122293376 35688976 8018208
02:26:07 7631 8192000000 10012404896 10416177152 1081921504 11.666 100 38 79 1 1114445872 23873424 8650944
02:27:21 85399 8192000000 10002455808 10407211008 1089295744 11.736 100 37 74 1 1109203696 11127424 8780528
02:29:50 25786 8192000000 10066619376 10474094592 1097332160 11.812 100 53 106 1 1166963760 58837200 10794400
02:31:20 20443 8192000000 10074191984 10484355072 1110594624 11.938 100 46 92 1 1183937472 64083312 9259536
02:32:44 17884 8192000000 10113235632 10520948736 1101451872 11.851 98 57 114 1 1206430400 93584352 11394176
02:34:06 22702 8192000000 10130024944 10545291264 1108057920 11.914 100 49 98 0 1230395040 112479216 9857904
02:35:35 2341 8192000000 10055529680 10452078592 1093203824 11.773 100 67 134 1 1158012016 50558368 14249824
02:36:43 8707 8192000000 10048179968 10446753792 1086838800 11.713 100 55 110 2 1157210064 60158000 10213264
02:37:58 3931 8192000000 10069361472 10461859840 1085913664 11.704 99 59 114 2 1167603376 71129728 10559984
02:39:05 13216 8192000000 10029459872 10418974720 1049030624 11.351 99 46 92 0 1142701952 85270128 8401200
02:40:24 37431 8192000000 10055134064 10459054080 1067755104 11.531 100 43 85 0 1172302784 95207456 9340224
02:42:09 21766 8192000000 10058357584 10465890304 1089573312 11.739 100 31 62 0 1168271584 72212432 6485840
02:43:37 14384 8192000000 10077194064 10497540096 1080518912 11.652 100 45 89 2 1198701024 109313424 8868688
02:44:59 3788 8192000000 10100841600 10490236928 1080515856 11.652 100 56 111 0 1198740352 107191232 11033264
02:46:08 3392 8192000000 10173803264 10562093056 1107806608 11.912 100 73 142 3 1270715984 148121888 14787488
02:47:18 4254 8192000000 10166506656 10585464832 1097081664 11.810 99 75 148 1 1291018624 176878128 17058832
02:48:28 1181 8192000000 10190721712 10584821760 1125457936 12.079 100 82 165 1 1291542352 147004560 19079856
02:49:31 37806 8192000000 10206083536 10620788736 1112437776 11.955 99 42 79 3 1306470256 184555424 9477056
02:51:25 24159 8192000000 10189482416 10612809728 1116594080 11.995 100 24 46 0 1294898944 172879568 5425296
02:52:57 22752 8192000000 10207232768 10635857920 1125182064 12.076 100 24 48 0 1305795920 175232192 5381664
02:54:27 19130 8192000000 10117098848 10649817088 1116134176 11.990 100 23 44 0 1307580064 186159760 5286128
02:55:49 37948 8192000000 10082382512 10500386816 1116283184 11.992 100 30 63 0 1155145568 32192592 6669792
02:57:31 120770 8192000000 10097447520 10549620736 1126046112 12.084 100 43 86 2 1243187360 108660256 8480992
03:00:35 6654 8192000000 10092999680 10522591232 1136594016 12.183 100 58 115 1 1199288800 50378960 12315824
03:01:45 42926 8192000000 10104622912 10548019200 1140667488 12.222 100 20 40 0 1196956224 51790000 4498736
03:04:30 38081 8192000000 10116151328 10623541248 1138686784 12.203 100 12 24 0 1257428000 115946496 2794720
03:06:14 21063 8192000000 10062728912 10492665856 1129202736 12.114 99 44 87 1 1165748784 26655360 9890688
03:07:38 20836 8192000000 10077125568 10534195200 1127344752 12.096 99 29 56 0 1173519104 40488848 5685504
03:09:00 50427 8192000000 10097195120 10592788480 1133791600 12.157 99 20 40 0 1219689904 81674960 4223344
03:10:53 71249 8192000000 10112763760 10564677632 1160481216 12.408 100 15 30 0 1216524816 53180928 2862672
03:13:10 44584 8192000000 10109002960 10554707968 1122211072 12.048 97 13 26 1 1142881728 18155776 2514880
03:16:05 56705 8192000000 10039180512 10501709824 1083722368 11.683 95 15 30 1 1146164144 59972256 2469520
03:18:04 95597 8192000000 10084634896 10534924288 1107296496 11.907 97 26 50 0 1160090256 47656912 5136848
03:20:45 69199 8192000000 10086541744 10545876992 1115095344 11.981 98 17 34 0 1171625312 52851552 3678416
03:22:58 53929 8192000000 10085908016 10518937600 1099352880 11.832 98 15 30 0 1157230304 54533824 3343600
03:25:00 24534 8192000000 10079256464 10507788288 1082676864 11.673 97 39 75 1 1147520800 57320368 7523568
03:26:31 40947 8192000000 10068140288 10508124160 1087033136 11.714 98 24 48 0 1165564384 73429152 5102096
03:28:20 69871 8192000000 10077390880 10576240640 1074948128 11.599 98 13 26 0 1211571728 133785424 2838176
03:30:47 39294 8192000000 10018600608 10450636800 1045457104 11.317 95 17 33 1 1068398496 19504736 3436656
03:32:26 22278 8192000000 10046160480 10490449920 1078750720 11.636 99 35 70 0 1146540848 60950528 6839600
03:33:52 19211 8192000000 10068025280 10478522368 1061445712 11.470 97 53 106 0 1132448896 60163568 10839616
03:35:17 15454 8192000000 10077847264 10497040384 1094892624 11.789 100 59 115 1 1190673776 84480944 11300208
03:36:35 61764 8192000000 9999575568 10426712064 1023603040 11.107 94 23 46 1 1044150992 15959712 4588240
03:38:45 48491 8192000000 10061448992 10492248064 1074587456 11.596 99 38 76 0 1150409728 68925104 6897168
03:40:35 65947 8192000000 10069501392 10493321216 1104323824 11.879 100 20 41 0 1151013440 42655136 4034480
03:42:44 47821 8192000000 10087449696 10512818176 1122464864 12.050 100 49 98 1 1200408704 67555968 10387872
03:44:41 53067 8192000000 10085843328 10525134848 1124161504 12.066 100 21 42 0 1197056656 68605280 4289872
03:46:39 57969 8192000000 10091671120 10553143296 1130776688 12.129 100 13 24 0 1198520576 65094496 2649392
03:48:58 47378 8192000000 10063848384 10515587072 1118949680 12.017 99 18 36 0 1179652768 56769696 3933392
03:50:45 104022 8192000000 10093579312 10541039616 1138281984 12.199 100 16 32 0 1188870352 47484688 3103680
03:53:32 116135 8192000000 10083336384 10521337856 1133978672 12.159 99 19 38 1 1160796688 23286784 3531232
03:57:28 86054 8192000000 10095990368 10582839296 1106041808 11.895 96 13 26 1 1206003520 97237872 2723840
03:59:55 99011 8192000000 10091914336 10557485056 1119509232 12.022 98 32 64 0 1155504288 29803312 6191744
04:02:36 41109 8192000000 10040909760 10507374592 1121606464 12.042 98 17 33 1 1158730352 33469216 3654672
04:04:23 70915 8192000000 10079203312 10542592000 1140697376 12.222 100 11 22 0 1203418608 60406304 2314928
04:06:35 75869 8192000000 10097527120 10611146752 1113018416 11.961 97 18 36 0 1184225488 67353952 3853120

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 06-04-2024 04:09:34 to 06-04-2024 04:09:48.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-04-2024 04:09:49 to 06-04-2024 04:09:51.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sat Apr  6 04:09:52 2024 
 
Database header page information: 
    Flags            0 
    Generation        87128 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    166505 
    Oldest active        166998 
    Oldest snapshot        166998 
    Next transaction    166999 
    Sequence number        0 
    Next attachment ID    675 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.56, total records: 7740635 
    Average version length: 48.16, total versions: 66717, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 89080 
    Data pages: 89080, average fill: 69% 
    Primary pages: 89078, secondary pages: 2, swept pages: 40565 
    Empty pages: 12, full pages: 68282 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 45 
    40 - 59% = 2744 
    60 - 79% = 86230 
    80 - 99% = 44 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23027, nodes: 7740635 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1664818, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 339 
        20 - 39% = 1737 
        40 - 59% = 3864 
        60 - 79% = 2228 
        80 - 99% = 14859 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13379, nodes: 7740635 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1490075, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1481 
        40 - 59% = 1961 
        60 - 79% = 1054 
        80 - 99% = 8883 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8213, nodes: 7740635 
    Average node length: 6.62, total dup: 5788030, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1483071, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 897 
        40 - 59% = 1317 
        60 - 79% = 867 
        80 - 99% = 5032 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.67, total records: 2242982 
    Average version length: 58.85, total versions: 35931, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28752 
    Data pages: 28752, average fill: 72% 
    Primary pages: 28751, secondary pages: 1, swept pages: 10944 
    Empty pages: 2, full pages: 17856 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 25 
    40 - 59% = 508 
    60 - 79% = 28122 
    80 - 99% = 92 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4491, nodes: 2242982 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 682742, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 853 
        40 - 59% = 834 
        60 - 79% = 681 
        80 - 99% = 2123 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2424, nodes: 2244060 
    Average node length: 4.97, total dup: 2243161, max dup: 17885 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1254354, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 225 
        40 - 59% = 1393 
        60 - 79% = 519 
        80 - 99% = 283 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1783, nodes: 2242982 
    Average node length: 4.97, total dup: 2242932, max dup: 129997 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1067565, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 633 
        60 - 79% = 45 
        80 - 99% = 1100 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4297, nodes: 2242982 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 682742, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 537 
        40 - 59% = 602 
        60 - 79% = 769 
        80 - 99% = 2281 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.34, total records: 400 
    Average version length: 28.11, total versions: 1735, max versions: 7 
    Average fragment length: 2.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 62% 
    Primary pages: 8, secondary pages: 16, swept pages: 0 
    Empty pages: 1, full pages: 11 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 27.53, total records: 88118 
    Average version length: 68.28, total versions: 60594, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.20 
    Pointer pages: 7, data page slots: 3744 
    Data pages: 2224, average fill: 51% 
    Primary pages: 2223, secondary pages: 1, swept pages: 0 
    Empty pages: 675, full pages: 1106 
    Fill distribution: 
     0 - 19% = 783 
    20 - 39% = 144 
    40 - 59% = 107 
    60 - 79% = 346 
    80 - 99% = 844 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701804, depth: 3, leaf buckets: 290, nodes: 88118 
    Average node length: 13.08, total dup: 6400, max dup: 2 
    Average key length: 10.59, compression ratio: 2.55 
    Average prefix length: 19.33, average data length: 7.67 
    Clustering factor: 62617, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 104 
        40 - 59% = 108 
        60 - 79% = 73 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 143, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 68% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 18.44, total records: 1490 
    Average version length: 43.19, total versions: 1097, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.15 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 47% 
    Primary pages: 30, secondary pages: 2, swept pages: 7 
    Empty pages: 8, full pages: 13 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92282, depth: 2, leaf buckets: 2, nodes: 1490 
    Average node length: 4.36, total dup: 1392, max dup: 157 
    Average key length: 2.70, compression ratio: 7.04 
    Average prefix length: 18.37, average data length: 0.63 
    Clustering factor: 794, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.62, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.41, total records: 809500 
    Average version length: 37.92, total versions: 27129, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8456 
    Data pages: 8456, average fill: 65% 
    Primary pages: 8454, secondary pages: 2, swept pages: 1672 
    Empty pages: 15, full pages: 7026 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 68 
    40 - 59% = 402 
    60 - 79% = 7904 
    80 - 99% = 52 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 852, nodes: 795268 
    Average node length: 4.88, total dup: 795219, max dup: 146530 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91543, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 123 
        40 - 59% = 444 
        60 - 79% = 179 
        80 - 99% = 106 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 891, nodes: 795268 
    Average node length: 5.89, total dup: 707793, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160917, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 446 
        60 - 79% = 116 
        80 - 99% = 305 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 928, nodes: 795268 
    Average node length: 5.89, total dup: 707793, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162778, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 61 
        40 - 59% = 469 
        60 - 79% = 109 
        80 - 99% = 289 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1122, nodes: 795268 
    Average node length: 5.97, total dup: 707793, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155167, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 227 
        40 - 59% = 599 
        60 - 79% = 208 
        80 - 99% = 87 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.94, total records: 5481 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.09, total fragments: 23, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 83, secondary pages: 13, swept pages: 66 
    Empty pages: 11, full pages: 55 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5481 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.09 
    Average prefix length: 34.52, average data length: 1.54 
    Clustering factor: 5228, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5481 
    Average node length: 11.16, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 159, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 75931 
    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: 66% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 789 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 789 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33411, depth: 2, leaf buckets: 96, nodes: 75931 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3145, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 95 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 120.28, total records: 190904 
    Average version length: 154.32, total versions: 41379, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.10 
    Pointer pages: 6, data page slots: 5368 
    Data pages: 4808, average fill: 85% 
    Primary pages: 4805, secondary pages: 3, swept pages: 1 
    Empty pages: 93, full pages: 4690 
    Fill distribution: 
     0 - 19% = 95 
    20 - 39% = 10 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4692 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 144.17, total records: 142415 
    Average version length: 150.29, total versions: 6944, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.76 
    Pointer pages: 6, data page slots: 5256 
    Data pages: 3624, average fill: 81% 
    Primary pages: 3622, secondary pages: 2, swept pages: 4 
    Empty pages: 111, full pages: 3482 
    Fill distribution: 
     0 - 19% = 113 
    20 - 39% = 10 
    40 - 59% = 14 
    60 - 79% = 5 
    80 - 99% = 3482 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 130.62, total records: 171800 
    Average version length: 153.68, total versions: 24567, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.98 
    Pointer pages: 5, data page slots: 4952 
    Data pages: 4328, average fill: 84% 
    Primary pages: 4326, secondary pages: 2, swept pages: 1 
    Empty pages: 94, full pages: 4214 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4212 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 134.71, total records: 177659 
    Average version length: 153.55, total versions: 20553, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.59 
    Pointer pages: 6, data page slots: 5256 
    Data pages: 4440, average fill: 84% 
    Primary pages: 4437, secondary pages: 3, swept pages: 1 
    Empty pages: 65, full pages: 4359 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4358 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 114.47, total records: 199797 
    Average version length: 154.62, total versions: 51378, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.82 
    Pointer pages: 6, data page slots: 6024 
    Data pages: 5008, average fill: 86% 
    Primary pages: 5005, secondary pages: 3, swept pages: 1 
    Empty pages: 71, full pages: 4910 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 10 
    40 - 59% = 6 
    60 - 79% = 10 
    80 - 99% = 4909 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 140.99, total records: 159018 
    Average version length: 151.70, total versions: 11116, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.03 
    Pointer pages: 7, data page slots: 5848 
    Data pages: 4048, average fill: 82% 
    Primary pages: 4046, secondary pages: 2, swept pages: 4 
    Empty pages: 132, full pages: 3889 
    Fill distribution: 
     0 - 19% = 134 
    20 - 39% = 8 
    40 - 59% = 11 
    60 - 79% = 5 
    80 - 99% = 3890 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 141.13, total records: 171286 
    Average version length: 152.51, total versions: 12141, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.02 
    Pointer pages: 6, data page slots: 5544 
    Data pages: 4272, average fill: 84% 
    Primary pages: 4270, secondary pages: 2, swept pages: 1 
    Empty pages: 43, full pages: 4194 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 10 
    40 - 59% = 13 
    60 - 79% = 8 
    80 - 99% = 4194 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 138.93, total records: 172173 
    Average version length: 153.39, total versions: 14654, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.21 
    Pointer pages: 5, data page slots: 4936 
    Data pages: 4312, average fill: 83% 
    Primary pages: 4310, secondary pages: 2, swept pages: 1 
    Empty pages: 69, full pages: 4219 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 13 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4218 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 141.20, total records: 164284 
    Average version length: 152.47, total versions: 11509, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.01 
    Pointer pages: 5, data page slots: 4832 
    Data pages: 4128, average fill: 83% 
    Primary pages: 4125, secondary pages: 3, swept pages: 1 
    Empty pages: 77, full pages: 4025 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 11 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 4025 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 139.56, total records: 174821 
    Average version length: 152.19, total versions: 14376, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.15 
    Pointer pages: 6, data page slots: 6544 
    Data pages: 4416, average fill: 83% 
    Primary pages: 4414, secondary pages: 2, swept pages: 1 
    Empty pages: 99, full pages: 4284 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 11 
    40 - 59% = 7 
    60 - 79% = 10 
    80 - 99% = 4283 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.15, total records: 2086967 
    Average version length: 52.99, total versions: 28268, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25616 
    Data pages: 25616, average fill: 70% 
    Primary pages: 25603, secondary pages: 13, swept pages: 11539 
    Empty pages: 141, full pages: 21665 
    Fill distribution: 
     0 - 19% = 264 
    20 - 39% = 277 
    40 - 59% = 958 
    60 - 79% = 23850 
    80 - 99% = 267 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2577, nodes: 2086967 
    Average node length: 5.44, total dup: 1947102, max dup: 1405 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181228, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 275 
        40 - 59% = 1715 
        60 - 79% = 288 
        80 - 99% = 292 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2752, nodes: 2086967 
    Average node length: 5.69, total dup: 1873044, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 373637, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2429 
        60 - 79% = 291 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2100, nodes: 2086967 
    Average node length: 4.96, total dup: 2086867, max dup: 26706 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179134, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 206 
        40 - 59% = 1060 
        60 - 79% = 383 
        80 - 99% = 449 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 44.38, total records: 139777 
    Average version length: 69.17, total versions: 57678, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.84 
    Pointer pages: 3, data page slots: 3752 
    Data pages: 2888, average fill: 58% 
    Primary pages: 2888, secondary pages: 0, swept pages: 318 
    Empty pages: 449, full pages: 1638 
    Fill distribution: 
     0 - 19% = 596 
    20 - 39% = 157 
    40 - 59% = 281 
    60 - 79% = 932 
    80 - 99% = 922 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101566, depth: 3, leaf buckets: 221, nodes: 139777 
    Average node length: 6.43, total dup: 121626, max dup: 14 
    Average key length: 3.96, compression ratio: 10.59 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 24643, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 44 
        40 - 59% = 113 
        60 - 79% = 54 
        80 - 99% = 8 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.93, total records: 6943238 
    Average version length: 68.80, total versions: 352280, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 64, data page slots: 104080 
    Data pages: 104080, average fill: 72% 
    Primary pages: 104078, secondary pages: 2, swept pages: 21774 
    Empty pages: 11, full pages: 72621 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 608 
    40 - 59% = 6819 
    60 - 79% = 95444 
    80 - 99% = 1133 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10608, nodes: 6943238 
    Average node length: 6.52, total dup: 6002135, max dup: 29 
    Average key length: 3.53, compression ratio: 11.90 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1614152, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1655 
        40 - 59% = 5955 
        60 - 79% = 2500 
        80 - 99% = 489 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8198, nodes: 6943238 
    Average node length: 5.40, total dup: 6661476, max dup: 164 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1435967, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1042 
        40 - 59% = 4392 
        60 - 79% = 1509 
        80 - 99% = 1246 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8301, nodes: 6943238 
    Average node length: 5.40, total dup: 6661476, max dup: 164 
    Average key length: 2.41, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1438274, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1149 
        40 - 59% = 4423 
        60 - 79% = 1498 
        80 - 99% = 1226 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.57, total records: 11891142 
    Average version length: 68.81, total versions: 273530, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 106, data page slots: 171696 
    Data pages: 171696, average fill: 74% 
    Primary pages: 171696, secondary pages: 0, swept pages: 63291 
    Empty pages: 4, full pages: 156312 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 517 
    40 - 59% = 3831 
    60 - 79% = 165752 
    80 - 99% = 1552 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18268, nodes: 11888828 
    Average node length: 6.60, total dup: 10361948, max dup: 57 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2447314, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 2309 
        40 - 59% = 10934 
        60 - 79% = 4185 
        80 - 99% = 805 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 49.52, total records: 1571303 
    Average version length: 69.06, total versions: 307066, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.54 
    Pointer pages: 24, data page slots: 38072 
    Data pages: 29832, average fill: 54% 
    Primary pages: 29757, secondary pages: 75, swept pages: 9250 
    Empty pages: 2963, full pages: 18041 
    Fill distribution: 
     0 - 19% = 5109 
    20 - 39% = 4258 
    40 - 59% = 3481 
    60 - 79% = 12868 
    80 - 99% = 4116 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1901, nodes: 1366237 
    Average node length: 5.52, total dup: 1310905, max dup: 49 
    Average key length: 2.57, compression ratio: 16.37 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 98771, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 529 
        40 - 59% = 896 
        60 - 79% = 431 
        80 - 99% = 41 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 39.68, total records: 1140463 
    Average version length: 69.03, total versions: 142073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.18 
    Pointer pages: 17, data page slots: 26568 
    Data pages: 25096, average fill: 39% 
    Primary pages: 25096, secondary pages: 0, swept pages: 4569 
    Empty pages: 3860, full pages: 9597 
    Fill distribution: 
     0 - 19% = 6522 
    20 - 39% = 4667 
    40 - 59% = 7838 
    60 - 79% = 5916 
    80 - 99% = 153 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1120, nodes: 725385 
    Average node length: 5.97, total dup: 666941, max dup: 70 
    Average key length: 3.04, compression ratio: 13.83 
    Average prefix length: 41.04, average data length: 0.96 
    Clustering factor: 105760, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 342 
        40 - 59% = 550 
        60 - 79% = 214 
        80 - 99% = 14 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.29, total records: 9235919 
    Average version length: 68.92, total versions: 396043, 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: 87, data page slots: 141576 
    Data pages: 141544, average fill: 70% 
    Primary pages: 141534, secondary pages: 10, swept pages: 49864 
    Empty pages: 194, full pages: 74748 
    Fill distribution: 
     0 - 19% = 475 
    20 - 39% = 1719 
    40 - 59% = 13591 
    60 - 79% = 123151 
    80 - 99% = 2608 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13473, nodes: 9231962 
    Average node length: 6.67, total dup: 7655459, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2110286, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1195 
        40 - 59% = 6919 
        60 - 79% = 4703 
        80 - 99% = 655 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21095105 
    Average version length: 82.94, total versions: 7283, 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: 318944 
    Data pages: 318944, average fill: 81% 
    Primary pages: 318940, secondary pages: 4, swept pages: 12637 
    Empty pages: 38, full pages: 318091 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 41 
    40 - 59% = 115 
    60 - 79% = 47958 
    80 - 99% = 270782 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19238, nodes: 21095105 
    Average node length: 5.72, total dup: 20615501, max dup: 137 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3273615, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 7930 
        60 - 79% = 567 
        80 - 99% = 10736 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17102, nodes: 21095105 
    Average node length: 6.31, total dup: 18538430, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913103, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 717 
        60 - 79% = 301 
        80 - 99% = 16080 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21028, nodes: 21095105 
    Average node length: 6.34, total dup: 18457308, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3567200, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 8227 
        60 - 79% = 614 
        80 - 99% = 12185 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16151, nodes: 21095105 
    Average node length: 5.56, total dup: 21095005, max dup: 228892 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941851, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 3112 
        60 - 79% = 330 
        80 - 99% = 12700 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.77, total records: 9634681 
    Average version length: 82.61, total versions: 346425, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 103, data page slots: 166592 
    Data pages: 166560, average fill: 71% 
    Primary pages: 166537, secondary pages: 23, swept pages: 70665 
    Empty pages: 403, full pages: 103267 
    Fill distribution: 
     0 - 19% = 1174 
    20 - 39% = 3977 
    40 - 59% = 16340 
    60 - 79% = 124041 
    80 - 99% = 21028 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11326, nodes: 9634681 
    Average node length: 5.36, total dup: 9326404, max dup: 175 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2207419, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 55 
        40 - 59% = 8359 
        60 - 79% = 2819 
        80 - 99% = 90 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13099, nodes: 9634681 
    Average node length: 6.23, total dup: 7985420, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1551812, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 3458 
        40 - 59% = 4205 
        60 - 79% = 2711 
        80 - 99% = 2600 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12644, nodes: 9634681 
    Average node length: 5.98, total dup: 8355125, max dup: 41 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2399500, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 67 
        40 - 59% = 9379 
        60 - 79% = 3095 
        80 - 99% = 103 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10243, nodes: 9634681 
    Average node length: 5.13, total dup: 9634581, max dup: 152051 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1568292, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1378 
        40 - 59% = 5046 
        60 - 79% = 1860 
        80 - 99% = 1912 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.33, total records: 11350419 
    Average version length: 82.61, total versions: 304267, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 118, data page slots: 192416 
    Data pages: 190912, average fill: 73% 
    Primary pages: 190792, secondary pages: 120, swept pages: 64680 
    Empty pages: 2184, full pages: 149648 
    Fill distribution: 
     0 - 19% = 3748 
    20 - 39% = 6169 
    40 - 59% = 15264 
    60 - 79% = 98479 
    80 - 99% = 67252 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13110, nodes: 11350419 
    Average node length: 5.32, total dup: 11240580, max dup: 672 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2379311, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 83 
        40 - 59% = 9023 
        60 - 79% = 3882 
        80 - 99% = 120 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10436, nodes: 11350419 
    Average node length: 5.51, total dup: 10855168, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 728048, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 824 
        40 - 59% = 2523 
        60 - 79% = 1784 
        80 - 99% = 5149 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14993, nodes: 11350419 
    Average node length: 6.04, total dup: 9902887, max dup: 66 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2395761, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 136 
        40 - 59% = 10457 
        60 - 79% = 4246 
        80 - 99% = 149 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10822, nodes: 11350419 
    Average node length: 5.24, total dup: 11350319, max dup: 182042 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 716207, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 843 
        40 - 59% = 4729 
        60 - 79% = 1561 
        80 - 99% = 3598 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.47, total records: 9701227 
    Average version length: 82.85, total versions: 297558, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 104, data page slots: 169656 
    Data pages: 169632, average fill: 71% 
    Primary pages: 169611, secondary pages: 21, swept pages: 79577 
    Empty pages: 536, full pages: 98799 
    Fill distribution: 
     0 - 19% = 1435 
    20 - 39% = 4312 
    40 - 59% = 18633 
    60 - 79% = 125515 
    80 - 99% = 19737 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11751, nodes: 9701227 
    Average node length: 5.17, total dup: 9672589, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2001676, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1466 
        40 - 59% = 7899 
        60 - 79% = 1781 
        80 - 99% = 582 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13199, nodes: 9701227 
    Average node length: 6.24, total dup: 8041078, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1516994, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 165 
        20 - 39% = 3519 
        40 - 59% = 4131 
        60 - 79% = 2696 
        80 - 99% = 2688 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12395, nodes: 9701227 
    Average node length: 5.43, total dup: 9265227, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2135457, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1383 
        40 - 59% = 8904 
        60 - 79% = 1510 
        80 - 99% = 573 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10145, nodes: 9701227 
    Average node length: 5.14, total dup: 9701127, max dup: 154030 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1583024, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 53 
        20 - 39% = 1262 
        40 - 59% = 4914 
        60 - 79% = 1795 
        80 - 99% = 2121 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.74, total records: 571785 
    Average version length: 68.84, total versions: 4035, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 75% 
    Primary pages: 8016, secondary pages: 0, swept pages: 3580 
    Empty pages: 3, full pages: 6912 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 6 
    40 - 59% = 148 
    60 - 79% = 7795 
    80 - 99% = 64 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37633, depth: 3, leaf buckets: 735, nodes: 571785 
    Average node length: 5.95, total dup: 486721, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100715, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 540 
        60 - 79% = 84 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30770, depth: 3, leaf buckets: 758, nodes: 571785 
    Average node length: 6.15, total dup: 468927, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100764, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 545 
        60 - 79% = 75 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 557, nodes: 571785 
    Average node length: 4.86, total dup: 571685, max dup: 8794 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89412, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 318 
        60 - 79% = 77 
        80 - 99% = 129 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Apr  6 04:10:16 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7740635 66717 1 0.0000 0.0000
DOC_LIST 2242982 35931 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1735 7 400.0000 0.0000
INVNT_TURNOVER_LOG 88118 60594 1 0.0000 0.0000
MONEY_SALDO 49 143 4 200.0000 0.0000
MONEY_TURNOVER_LOG 1490 1097 1 0.0000 0.0000
PDISTR 809500 27129 2 0.0000 0.0000
PERF_SPLIT_0 190904 41379 1 0.0000 0.0000
PERF_SPLIT_1 142415 6944 1 0.0000 0.0000
PERF_SPLIT_2 171800 24567 1 0.0000 0.0000
PERF_SPLIT_3 177659 20553 1 0.0000 0.0000
PERF_SPLIT_4 199797 51378 1 0.0000 0.0000
PERF_SPLIT_5 159018 11116 1 0.0000 0.0000
PERF_SPLIT_6 171286 12141 1 0.0000 0.0000
PERF_SPLIT_7 172173 14654 1 0.0000 0.0000
PERF_SPLIT_8 164284 11509 1 0.0000 0.0000
PERF_SPLIT_9 174821 14376 1 0.0000 0.0000
PSTORNED 2086967 28268 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 139777 57678 1 0.0000 0.0000
XQD_1000_3300 6943238 352280 1 0.0000 0.0000
XQD_1200_2000 11891142 273530 1 0.0000 0.0000
XQD_2000_3300 1571303 307066 1 0.0000 0.0000
XQD_2100_3300 1140463 142073 1 0.0000 0.0000
XQD_3300_3400 9235919 396043 1 0.0000 0.0000
XQS_1000_1200 21095105 7283 1 0.0000 0.0000
XQS_1000_3300 9634681 346425 1 0.0000 0.0000
XQS_1200_2000 11350419 304267 1 0.0000 0.0000
XQS_2100_3300 9701227 297558 1 0.0000 0.0000
XQS_3300_3400 571785 4035 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 ---
:185: 
:186: mscs-test-161.budzdorov.ru    Sat Apr  6 04:07:55 2024
:187:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:188: 
:189: 
:190: mscs-test-161.budzdorov.ru    Sat Apr  6 04:07:57 2024
:191:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:192: 
:193: 
:194: mscs-test-161.budzdorov.ru    Sat Apr  6 04:08:01 2024
:195:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:196: 
:197: 
:198: mscs-test-161.budzdorov.ru    Sat Apr  6 04:08:12 2024
:199:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:200: 
--- end of diff output ---

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

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