Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.03.2024 04:09
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 15837568 kB
MemAvailable 30264604 kB
Buffers 20 kB
Cached 15870176 kB
SwapCached 2276 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-13 04:07:52
DTS_END                         2024-03-13 04:07:52.4790
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/51620
TRN_ID                          164625
ATT_ID                          491
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: 8958.56 23233 895856
customer order: creation 167.18 436 16718
customer order: refuse 15.07 410 1507
order to supplier: creation 44.94 1301 4494
order to supplier: removal 3.56 76775 356
invoice (draft): creation 46.47 3388 4647
invoice (draft): removal 47.96 664 4796
invoice accept: apply 41.57 21948 4157
invoice accept: cancel 43.43 783 4343
customer reserve: creation 4023.90 209 402390
customer reserve: removal 4244.34 50 424434
realization accept: apply 80.81 190 8081
realization accept: cancel 73.62 128 7362
payment from customer: creation 58.66 122 5866
payment from customer: removal 5.70 59 570
payment to supplier: creation 47.75 138 4775
payment to supplier: removal 3.21 61 321
service: total inventory turnovers 3.81 4034 381
service: total monetary turnovers 5.75 614 575
service: aggregate perf. data 0.80 18856 80
service: refresh index statistics 0.03 334488 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 13-03-2024 04:09:59 to 13-03-2024 04:10:02.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4017
TEST_TIME 2 4603
TEST_TIME 3 4971
TEST_TIME 4 4724
TEST_TIME 5 4818
TEST_TIME 6 4960
TEST_TIME 7 4991
TEST_TIME 8 5230
TEST_TIME 9 5401
TEST_TIME 10 5471
TEST_TIME 11 6038
TEST_TIME 12 6113
TEST_TIME 13 6447
TEST_TIME 14 6752
TEST_TIME 15 7012
TEST_TIME 16 7080
TEST_TIME 17 7642
TEST_TIME 18 7786
TEST_TIME 19 7871
TEST_TIME 20 7994
TEST_TIME 21 8058
TEST_TIME 22 7962
TEST_TIME 23 8567
TEST_TIME 24 8778
TEST_TIME 25 9040
TEST_TIME 26 9349
TEST_TIME 27 9140
TEST_TIME 28 9086
TEST_TIME 29 8926
TEST_TIME 30 8771
TEST_TIME 31 8902
TEST_TIME 32 8804
TEST_TIME 33 9047
TEST_TIME 34 8894
TEST_TIME 35 8822
TEST_TIME 36 8771
TEST_TIME 37 8688
TEST_TIME 38 8743
TEST_TIME 39 8768
TEST_TIME 40 8672
TEST_TIME 41 8630
TEST_TIME 42 8635
TEST_TIME 43 8623
TEST_TIME 44 8682
TEST_TIME 45 8668
TEST_TIME 46 8628
TEST_TIME 47 8697
TEST_TIME 48 9033
TEST_TIME 49 8970
TEST_TIME 50 9124
TEST_TIME 51 9057
TEST_TIME 52 9115
TEST_TIME 53 9136
TEST_TIME 54 9291
TEST_TIME 55 9282
TEST_TIME 56 9280
TEST_TIME 57 9129
TEST_TIME 58 9051
TEST_TIME 59 8985
TEST_TIME 60 9004
TEST_TIME 61 9031
TEST_TIME 62 8993
TEST_TIME 63 8978
TEST_TIME 64 8929
TEST_TIME 65 8889
TEST_TIME 66 8874
TEST_TIME 67 8977
TEST_TIME 68 8969
TEST_TIME 69 8962
TEST_TIME 70 9105
TEST_TIME 71 9088
TEST_TIME 72 9111
TEST_TIME 73 9100
TEST_TIME 74 9176
TEST_TIME 75 9172
TEST_TIME 76 9144
TEST_TIME 77 9122
TEST_TIME 78 9023
TEST_TIME 79 8969
TEST_TIME 80 8987
TEST_TIME 81 8976
TEST_TIME 82 8949
TEST_TIME 83 8939
TEST_TIME 84 8917
TEST_TIME 85 8940
TEST_TIME 86 8960
TEST_TIME 87 8953
TEST_TIME 88 8982
TEST_TIME 89 9052
TEST_TIME 90 9002
TEST_TIME 91 9104
TEST_TIME 92 9100
TEST_TIME 93 9164
TEST_TIME 94 9092
TEST_TIME 95 9046
TEST_TIME 96 9021
TEST_TIME 97 9002
TEST_TIME 98 8999
TEST_TIME 99 8974
TEST_TIME 100 8963

Performance per minute, chart


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

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 1263666 1263666 0 0.00 0 20260 7 0 0
doc_list_biud 1263666 1263666 0 0.00 0 74265 22 0 0
sp_add_invoice_to_stock 4230 4157 73 1.72 36 309330 21949 0 73
sp_cancel_adding_invoice 4343 4343 0 0.00 3 62806 784 0 0
sp_cancel_client_order 1507 1507 0 0.00 4 24499 411 0 0
sp_cancel_customer_reserve 424434 424434 0 0.00 0 74266 51 0 0
sp_cancel_pay_from_customer 570 570 0 0.00 2 1742 60 0 0
sp_cancel_pay_to_supplier 321 321 0 0.00 3 982 62 0 0
sp_cancel_supplier_invoice 4803 4796 7 0.14 1 41608 664 0 7
sp_cancel_supplier_order 356 356 0 0.00 5 761951 76775 0 0
sp_cancel_write_off 7362 7362 0 0.00 1 20362 128 0 0
sp_client_order 16718 16718 0 0.00 3 30627 437 0 0
sp_customer_reserve 402390 402390 0 0.00 0 104168 210 0 0
sp_fill_shopping_cart 25841 25841 0 0.00 1 28148 38 0 0
sp_fill_shopping_cart_clo_res 402377 402377 0 0.00 0 23099 18 0 0
sp_get_clo_for_invoice 4144 4144 0 0.00 0 31622 432 0 0
sp_kill_cost_storno 12596 12596 0 0.00 0 9261 66 0 0
sp_kill_qstorno_ret_qs2qd 861382 861382 0 0.00 0 74263 28 0 0
sp_kill_qty_storno 455023 455023 0 0.00 0 74265 60 0 0
sp_lock_selected_doc 17026 17026 0 0.00 0 6163 5 0 0
sp_make_cost_storno 22866 22866 0 0.00 0 15595 65 0 0
sp_multiply_rows_for_pdistr 22866 22866 0 0.00 0 7219 30 0 0
sp_multiply_rows_for_qdistr 16718 16718 0 0.00 0 30620 209 0 0
sp_pay_from_customer 5866 5866 0 0.00 4 12407 122 0 0
sp_pay_to_supplier 4775 4775 0 0.00 4 12504 138 0 0
sp_payment_common 10641 10641 0 0.00 1 6445 21 0 0
sp_qd_handle_on_cancel_clo 1507 1507 0 0.00 0 24492 379 0 0
sp_qd_handle_on_invoice_upd_sts 8487 8487 0 0.00 0 21887 282 0 0
sp_qd_handle_on_reserve_upd_sts 8081 8081 0 0.00 0 12445 51 0 0
sp_reserve_write_off 8081 8081 0 0.00 6 12805 190 0 0
sp_supplier_invoice 4647 4647 0 0.00 4 86197 3389 0 0
sp_supplier_order 4494 4494 0 0.00 4 36986 1301 0 0
srv_aggregate_perf_data 81 80 1 1.23 1411 288059 18856 0 1
srv_fill_mon_cache_memory 54 54 0 0.00 2282 110659 46035 0 0
srv_find_qd_qs_mism 853591 853591 0 0.00 0 20260 6 0 0
srv_make_invnt_saldo 381 381 0 0.00 50 90852 4034 0 0
srv_make_money_saldo 575 575 0 0.00 0 13978 615 0 0
srv_recalc_idx_stat 3 3 0 0.00 293612 387605 334488 0 0
t$perf-abend:sp_add_invoice_to_stock 73 73 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4157 4157 0 0.00 0 8308 179 0 0
t$perf-norm:sp_cancel_adding_invoice 329 329 0 0.00 0 4648 110 0 0
t$perf-norm:sp_cancel_client_order 1507 1507 0 0.00 0 9388 23 0 0
t$perf-norm:sp_cancel_customer_reserve 572 572 0 0.00 0 2142 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 570 570 0 0.00 0 792 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 321 321 0 0.00 0 662 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 349 349 0 0.00 0 503 11 0 0
t$perf-norm:sp_cancel_supplier_order 356 356 0 0.00 0 25528 1654 0 0
t$perf-norm:sp_cancel_write_off 798 798 0 0.00 0 2026 6 0 0
t$perf-norm:sp_client_order 16718 16718 0 0.00 0 5494 15 0 0
t$perf-norm:sp_customer_reserve 839 839 0 0.00 0 1355 5 0 0
t$perf-norm:sp_pay_from_customer 5866 5866 0 0.00 0 4910 11 0 0
t$perf-norm:sp_pay_to_supplier 4775 4775 0 0.00 0 13344 12 0 0
t$perf-norm:sp_reserve_write_off 8081 8081 0 0.00 0 6241 10 0 0
t$perf-norm:sp_supplier_invoice 4647 4647 0 0.00 0 5329 16 0 0
t$perf-norm:sp_supplier_order 4494 4494 0 0.00 0 5799 12 0 0
t$perf-norm:srv_aggregate_perf_data 80 80 0 0.00 0 2419 32 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 15 1 0 0
t$perf-norm:srv_make_invnt_saldo 381 381 0 0.00 0 1181 16 0 0
t$perf-norm:srv_make_money_saldo 575 575 0 0.00 0 1212 5 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 31 12 0 0
v_add_invoice_to_stock 8432 8286 146 1.73 0 4807 17 0 146
v_all_customers 31264 31264 0 0.00 0 39 0 0 0
v_all_suppliers 25852 25852 0 0.00 0 25 1 0 0
v_all_wares 33436 33436 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 658 658 0 0.00 0 3044 19 0 0
v_cancel_client_order 3014 3014 0 0.00 0 2304 6 0 0
v_cancel_customer_prepayment 1140 1140 0 0.00 0 971 4 0 0
v_cancel_customer_reserve 1144 1144 0 0.00 0 1114 4 0 0
v_cancel_payment_to_supplier 642 642 0 0.00 0 637 4 0 0
v_cancel_supplier_invoice 712 698 14 1.96 0 1265 12 0 14
v_cancel_supplier_order 712 712 0 0.00 0 2869 11 0 0
v_cancel_write_off 1596 1596 0 0.00 0 1983 13 0 0
v_max_id_clo_ord 4494 4494 0 0.00 0 149 1 0 0
v_max_id_clo_res 839 839 0 0.00 0 3221 12 0 0
v_max_id_ord_sup 4627 4627 0 0.00 0 4792 6 0 0
v_max_non_paid_invoice 970 970 0 0.00 0 269 2 0 0
v_max_non_paid_realizn 2800 2800 0 0.00 0 513 2 0 0
v_min_id_clo_ord 4494 4494 0 0.00 0 2458 5 0 0
v_min_id_clo_res 839 839 0 0.00 0 2558 7 0 0
v_min_id_ord_sup 4627 4627 0 0.00 0 9880 13 0 0
v_min_non_paid_invoice 4775 4775 0 0.00 0 6442 19 0 0
v_min_non_paid_realizn 5866 5866 0 0.00 0 5760 14 0 0
v_our_firm 8304 8304 0 0.00 0 20 1 0 0
v_reserve_write_off 16162 16162 0 0.00 0 3727 8 0 0
x_lock_depdocs_on_canc_invoice 8790 8790 0 0.00 0 19550 108 0 0
x_lock_depdocs_on_canc_sup_ord 356 356 0 0.00 0 5426 307 0 0
x_make_qstorno_1000_1200 4494 4494 0 0.00 1 36955 1235 0 0
x_make_qstorno_1200_2000 4647 4647 0 0.00 2 86178 3233 0 0
x_make_qstorno_2100_3300 402390 402390 0 0.00 0 104167 189 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-03-2024 04:10:08 to 13-03-2024 04:10:12.

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:56 5 8192000000 8806508192 8821014528 10413888 0.126 4 2 2 0 10678368 173920 90560
02:08:57 41785 8192000000 9723494864 10024054784 804997344 8.947 100 88 176 0 833788000 7653328 21137328
02:10:43 23652 8192000000 9755229552 10062786560 831985696 9.219 100 90 180 0 866260832 12686368 21588768
02:12:11 16689 8192000000 9790184816 10103836672 856052304 9.461 100 87 172 0 897117760 21086240 19979216
02:13:29 13736 8192000000 9842285360 10174644224 894158864 9.840 100 77 152 1 948205504 37306000 16740640
02:14:47 5524 8192000000 9896168448 10240299008 936308640 10.257 100 77 154 0 1009964560 57311136 16344784
02:15:58 8216 8192000000 9942606592 10302627840 979603152 10.680 100 66 131 1 1055314048 62801312 12909584
02:17:10 3101 8192000000 9994595040 10357809152 1013478432 11.009 100 82 162 0 1107480352 78241936 15759984
02:18:16 1438 8192000000 10009382416 10381410304 1034361776 11.210 100 81 159 1 1133398400 83365568 15671056
02:19:19 1056 8192000000 10033484688 10403037184 1053828304 11.397 100 90 175 2 1137841184 65958592 18054288
02:20:23 12788 8192000000 9996687696 10381320192 1060592368 11.462 100 48 96 0 1104103840 33065424 10446048
02:21:37 5294 8192000000 10013037696 10406649856 1074162400 11.592 100 45 90 1 1132825360 49744912 8918048
02:22:43 22690 8192000000 9984369152 10382499840 1074336528 11.593 100 41 82 0 1102905136 19249824 9318784
02:24:06 5541 8192000000 9990799136 10391781376 1086553056 11.710 100 39 78 0 1114843024 20284512 8005456
02:25:14 4041 8192000000 10007559184 10417291264 1093431568 11.775 100 45 91 1 1122416784 18040272 10944944
02:26:20 3968 8192000000 10005178864 10408202240 1098684752 11.825 100 40 81 0 1122313904 14418688 9210464
02:27:24 58270 8192000000 10022427264 10432278528 1097462864 11.814 100 41 80 0 1121704464 14852224 9389376
02:29:26 26520 8192000000 10086660800 10497490944 1113596656 11.966 100 63 126 0 1195969040 69697184 12675200
02:30:59 28239 8192000000 10075256448 10483867648 1109322560 11.926 98 48 94 0 1159315568 40504800 9488208
02:32:31 49448 8192000000 10131481408 10542501888 1131263552 12.133 100 45 90 0 1246658752 106095072 9300128
02:34:25 22445 8192000000 10135135664 10548756480 1104626064 11.882 98 34 68 0 1229955136 117988528 7340544
02:35:56 27906 8192000000 10168568144 10582945792 1114244144 11.973 99 43 84 1 1265681600 142239808 9197648
02:37:26 9394 8192000000 10163011856 10584031232 1118387664 12.012 99 38 72 1 1265211744 138589104 8234976
02:38:42 23638 8192000000 10157792784 10567421952 1074191008 11.592 96 39 77 0 1241317792 158860880 8265904
02:40:19 3000 8192000000 10183089808 10582134784 1111564032 11.947 99 65 130 0 1282030192 156240528 14225632
02:41:30 9822 8192000000 10137791328 10555076608 1074511232 11.595 97 57 113 1 1245083808 157888976 12683600
02:42:45 5839 8192000000 10117591712 10535395328 1074703488 11.597 99 29 58 0 1217150640 135724432 6722720
02:44:03 2281 8192000000 10176513056 10575470592 1101278560 11.850 100 82 159 2 1276861472 158316432 17266480
02:45:15 4466 8192000000 10198729968 10599845888 1115081712 11.981 100 64 128 1 1299655136 171493936 13079488
02:46:27 2381 8192000000 10173165168 10568843264 1101379840 11.851 100 61 121 1 1275685696 161074064 13231792
02:47:35 12262 8192000000 10186843920 10609487872 1129794080 12.119 100 50 99 0 1302259008 161531504 10933424
02:49:00 22969 8192000000 10206077232 10625978368 1112608560 11.957 99 19 39 0 1304105824 186818608 4678656
02:50:29 17362 8192000000 10178182928 10662670336 1124451024 12.069 100 31 62 0 1323541328 191429136 7661168
02:51:50 19049 8192000000 10138299104 10583195648 1127206864 12.095 100 36 72 0 1239949472 105020608 7722000
02:53:12 46852 8192000000 10081628160 10528428032 1110679584 11.939 99 16 32 0 1174525264 60570224 3275456
02:55:00 77851 8192000000 10115061840 10565218304 1111875600 11.950 98 25 50 1 1219471424 101429872 6165952
02:57:19 45967 8192000000 10088956672 10564743168 1113612096 11.967 99 23 46 0 1215533536 96639120 5282320
02:59:06 39018 8192000000 10102216912 10538835968 1126900080 12.092 100 34 68 0 1206523472 72220592 7402800
03:00:53 52291 8192000000 10084328304 10548862976 1139444528 12.210 100 14 28 0 1201738016 59291280 3002208
03:02:56 90377 8192000000 10125535200 10576216064 1147788160 12.289 100 15 30 0 1233890432 82658080 3444192
03:05:26 73288 8192000000 10082463024 10573905920 1148865792 12.299 100 25 50 0 1222075248 67960336 5249120
03:07:42 64152 8192000000 10127956544 10595901440 1158695712 12.391 100 24 46 2 1220238480 56637120 4905648
03:09:56 68882 8192000000 10090202608 10540498944 1151826080 12.327 99 15 30 0 1176730944 22199264 2705600
03:12:42 38031 8192000000 10140417536 10591002624 1167384144 12.472 100 24 48 0 1224886512 52424160 5078208
03:14:32 54409 8192000000 10149987504 10707066880 1158792688 12.392 99 13 26 0 1258377216 96714976 2869552
03:16:31 57130 8192000000 10102820672 10614738944 1158098448 12.385 99 11 22 0 1221511728 61079904 2333376
03:18:29 25667 8192000000 10117098384 10553995264 1153866560 12.346 99 43 86 0 1192037360 29189952 8980848
03:20:00 40644 8192000000 10108539696 10569453568 1151473616 12.323 99 18 36 0 1209639104 54144544 4020944
03:21:41 77013 8192000000 10098686704 10564022272 1106240656 11.897 95 18 35 2 1166779504 56377136 4161712
03:23:59 77786 8192000000 10072370864 10511339520 1120304448 12.030 98 41 82 0 1141526800 12224896 8997456
03:26:20 24594 8192000000 10099017520 10529296384 1135023776 12.169 100 40 78 2 1200196992 57744176 7429040
03:27:46 13718 8192000000 10082083216 10526908416 1116934144 11.998 99 41 82 2 1197456688 72327504 8195040
03:29:01 58290 8192000000 10064484064 10521419776 1119570464 12.023 99 10 20 0 1160897328 39254176 2072688
03:31:15 51207 8192000000 10052794896 10497298432 1117437952 12.003 100 12 20 1 1151027104 30757296 2831856
03:33:08 65745 8192000000 10021078864 10502746112 1018078288 11.053 92 27 54 0 1084416480 60479328 5858864
03:35:19 18914 8192000000 10052898912 10474635264 1082227968 11.669 99 61 118 1 1142131712 46816784 13086960
03:36:45 106523 8192000000 10066101968 10504380416 1095004704 11.790 99 14 28 1 1154915648 57154784 2756160
03:39:31 78646 8192000000 10071470640 10504343552 1063937504 11.494 95 6 12 0 1090982656 26050320 994832
03:41:51 85583 8192000000 10064848560 10509524992 1076115472 11.610 96 17 34 0 1108804800 29605712 3083616
03:44:17 24737 8192000000 10083275984 10495254528 1083004704 11.676 97 49 97 0 1142702912 50074848 9623360
03:45:48 45630 8192000000 10108386592 10516488192 1103426608 11.870 99 68 134 1 1187342512 70722944 13192960
03:47:36 56753 8192000000 10045514016 10523639808 1121320768 12.039 100 12 24 0 1171014000 47579088 2114144
03:50:09 21517 8192000000 10069789808 10496049152 1131481120 12.135 100 53 106 0 1166624064 23796032 11346912
03:51:41 90123 8192000000 10097587872 10551476224 1139982208 12.215 100 22 43 0 1232049392 87423264 4643920
03:54:14 45238 8192000000 10120808224 10568716288 1142369264 12.238 99 23 44 0 1205390032 58760960 4259808
03:56:01 88706 8192000000 10097312384 10543091712 1140512880 12.220 99 8 16 0 1179864352 37808944 1542528
03:58:33 109178 8192000000 10098062032 10592624640 1157770864 12.382 100 18 36 0 1200243968 39097296 3375808
04:01:22 110659 8192000000 10073327104 10538237952 1128535264 12.108 98 16 32 1 1165332304 33572032 3225008
04:04:15 18331 8192000000 10084205712 10523623424 1123105088 12.056 98 31 63 1 1173521168 44091424 6324656
04:05:38 97126 8192000000 10127003216 10612670464 1150971120 12.319 100 15 29 0 1224316064 70344544 3000400

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 13-03-2024 04:10:14 to 13-03-2024 04:10:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 73 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-03-2024 04:10:29 to 13-03-2024 04:10:31.

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          163439
MON$OLDEST_ACTIVE               165831
MON$OLDEST_SNAPSHOT             165831
MON$NEXT_TRANSACTION            165831
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                       1899808
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             671
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Wed Mar 13 04:10:32 2024 
 
Database header page information: 
    Flags            0 
    Generation        86923 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    163439 
    Oldest active        165831 
    Oldest snapshot        165831 
    Next transaction    165832 
    Sequence number        0 
    Next attachment ID    671 
    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.63, total records: 7699890 
    Average version length: 48.16, total versions: 51005, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88992 
    Data pages: 88992, average fill: 69% 
    Primary pages: 88991, secondary pages: 1, swept pages: 46450 
    Empty pages: 1, full pages: 62280 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 89 
    40 - 59% = 2998 
    60 - 79% = 85873 
    80 - 99% = 12 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23023, nodes: 7699890 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1650953, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 304 
        20 - 39% = 1785 
        40 - 59% = 3935 
        60 - 79% = 2525 
        80 - 99% = 14474 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13392, nodes: 7699890 
    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: 1475585, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1571 
        40 - 59% = 1920 
        60 - 79% = 1183 
        80 - 99% = 8718 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8243, nodes: 7699890 
    Average node length: 6.61, total dup: 5766830, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1468771, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 952 
        40 - 59% = 1310 
        60 - 79% = 972 
        80 - 99% = 4889 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.84, total records: 2222491 
    Average version length: 58.88, total versions: 27347, 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: 28640 
    Data pages: 28640, average fill: 71% 
    Primary pages: 28638, secondary pages: 2, swept pages: 14145 
    Empty pages: 7, full pages: 16862 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 18 
    40 - 59% = 648 
    60 - 79% = 27921 
    80 - 99% = 43 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4495, nodes: 2222491 
    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: 679905, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 887 
        40 - 59% = 826 
        60 - 79% = 748 
        80 - 99% = 2034 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2416, nodes: 2223301 
    Average node length: 4.97, total dup: 2222402, max dup: 18228 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1249468, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 214 
        40 - 59% = 1412 
        60 - 79% = 549 
        80 - 99% = 240 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1778, nodes: 2222491 
    Average node length: 4.97, total dup: 2222441, max dup: 129888 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1060667, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 640 
        60 - 79% = 32 
        80 - 99% = 1102 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4289, nodes: 2222491 
    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: 679905, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 579 
        40 - 59% = 597 
        60 - 79% = 835 
        80 - 99% = 2179 
 
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: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 15, average fill: 34% 
    Primary pages: 7, secondary pages: 8, swept pages: 0 
    Empty pages: 6, full pages: 6 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 6 
 
    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: 18.30, total records: 108548 
    Average version length: 68.28, total versions: 91533, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.81 
    Pointer pages: 7, data page slots: 3360 
    Data pages: 1864, average fill: 77% 
    Primary pages: 1863, secondary pages: 1, swept pages: 44 
    Empty pages: 59, full pages: 1400 
    Fill distribution: 
     0 - 19% = 144 
    20 - 39% = 121 
    40 - 59% = 131 
    60 - 79% = 219 
    80 - 99% = 1249 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1877502, depth: 3, leaf buckets: 346, nodes: 108548 
    Average node length: 13.48, total dup: 7592, max dup: 2 
    Average key length: 10.66, compression ratio: 2.53 
    Average prefix length: 19.27, average data length: 7.73 
    Clustering factor: 76340, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 246 
        60 - 79% = 51 
        80 - 99% = 18 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    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: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 19% 
    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_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: 17.95, total records: 1933 
    Average version length: 43.30, total versions: 1445, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.23 
    Pointer pages: 1, data page slots: 48 
    Data pages: 32, average fill: 60% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 3, full pages: 18 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 15 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 95811, depth: 2, leaf buckets: 4, nodes: 1933 
    Average node length: 4.15, total dup: 1835, max dup: 222 
    Average key length: 2.55, compression ratio: 7.46 
    Average prefix length: 18.50, average data length: 0.50 
    Clustering factor: 1044, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.59, total records: 70 
    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: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    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.71, total records: 807518 
    Average version length: 37.91, total versions: 21070, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8544 
    Data pages: 8544, average fill: 64% 
    Primary pages: 8543, secondary pages: 1, swept pages: 2790 
    Empty pages: 12, full pages: 5699 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 52 
    40 - 59% = 760 
    60 - 79% = 7672 
    80 - 99% = 32 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 869, nodes: 796366 
    Average node length: 4.88, total dup: 796317, max dup: 149096 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89999, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 135 
        40 - 59% = 474 
        60 - 79% = 160 
        80 - 99% = 99 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 920, nodes: 796366 
    Average node length: 5.88, total dup: 709267, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159512, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 34 
        40 - 59% = 492 
        60 - 79% = 78 
        80 - 99% = 315 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 966, nodes: 796366 
    Average node length: 5.89, total dup: 709267, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161419, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 101 
        40 - 59% = 505 
        60 - 79% = 72 
        80 - 99% = 288 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1143, nodes: 796366 
    Average node length: 5.97, total dup: 709267, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153756, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 242 
        40 - 59% = 630 
        60 - 79% = 191 
        80 - 99% = 77 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.67, total records: 5422 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.48, total fragments: 21, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.05 
    Pointer pages: 1, data page slots: 96 
    Data pages: 88, average fill: 61% 
    Primary pages: 78, secondary pages: 10, swept pages: 59 
    Empty pages: 6, full pages: 55 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5422 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.60, compression ratio: 9.97 
    Average prefix length: 34.34, average data length: 1.56 
    Clustering factor: 5111, ratio: 0.94 
    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: 5422 
    Average node length: 11.10, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 159, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.17, total records: 75255 
    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: 65% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 783 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 783 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37589, depth: 2, leaf buckets: 96, nodes: 75255 
    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: 3123, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        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: 140.10, total records: 165643 
    Average version length: 154.49, total versions: 12882, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.11 
    Pointer pages: 6, data page slots: 5264 
    Data pages: 4152, average fill: 83% 
    Primary pages: 4150, secondary pages: 2, swept pages: 9 
    Empty pages: 66, full pages: 4063 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 4064 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 130.08, total records: 152083 
    Average version length: 154.69, total versions: 22230, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.04 
    Pointer pages: 6, data page slots: 4896 
    Data pages: 3824, average fill: 84% 
    Primary pages: 3821, secondary pages: 3, swept pages: 16 
    Empty pages: 76, full pages: 3731 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3732 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 129.42, total records: 190932 
    Average version length: 154.60, total versions: 29288, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.10 
    Pointer pages: 6, data page slots: 5976 
    Data pages: 4760, average fill: 85% 
    Primary pages: 4758, secondary pages: 2, swept pages: 4 
    Empty pages: 44, full pages: 4696 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4697 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.14, total records: 140882 
    Average version length: 150.68, total versions: 1664, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 5, data page slots: 4712 
    Data pages: 3512, average fill: 83% 
    Primary pages: 3509, secondary pages: 3, swept pages: 2 
    Empty pages: 38, full pages: 3448 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 9 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3448 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 147.62, total records: 149307 
    Average version length: 152.59, total versions: 3315, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 5680 
    Data pages: 3736, average fill: 82% 
    Primary pages: 3734, secondary pages: 2, swept pages: 7 
    Empty pages: 67, full pages: 3654 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3657 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 136.92, total records: 156860 
    Average version length: 154.68, total versions: 15361, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.39 
    Pointer pages: 7, data page slots: 5064 
    Data pages: 3952, average fill: 83% 
    Primary pages: 3950, secondary pages: 2, swept pages: 9 
    Empty pages: 83, full pages: 3832 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 10 
    40 - 59% = 12 
    60 - 79% = 10 
    80 - 99% = 3831 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 142.68, total records: 150153 
    Average version length: 153.57, total versions: 8773, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 6, data page slots: 5000 
    Data pages: 3760, average fill: 83% 
    Primary pages: 3757, secondary pages: 3, swept pages: 1 
    Empty pages: 60, full pages: 3677 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 3678 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 147.27, total records: 143198 
    Average version length: 151.32, total versions: 4039, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 7, data page slots: 5048 
    Data pages: 3632, average fill: 82% 
    Primary pages: 3629, secondary pages: 3, swept pages: 34 
    Empty pages: 94, full pages: 3503 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 15 
    80 - 99% = 3503 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 147.84, total records: 159813 
    Average version length: 151.43, total versions: 3732, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 5, data page slots: 5320 
    Data pages: 4032, average fill: 82% 
    Primary pages: 4031, secondary pages: 1, swept pages: 11 
    Empty pages: 88, full pages: 3911 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 12 
    40 - 59% = 7 
    60 - 79% = 11 
    80 - 99% = 3909 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 146.50, total records: 156539 
    Average version length: 152.44, total versions: 5003, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 5208 
    Data pages: 3944, average fill: 82% 
    Primary pages: 3942, secondary pages: 2, swept pages: 10 
    Empty pages: 81, full pages: 3830 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 10 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 3831 
 
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.22, total records: 2073290 
    Average version length: 52.87, total versions: 24924, 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: 25664 
    Data pages: 25664, average fill: 70% 
    Primary pages: 25651, secondary pages: 13, swept pages: 12926 
    Empty pages: 152, full pages: 20562 
    Fill distribution: 
     0 - 19% = 318 
    20 - 39% = 352 
    40 - 59% = 1243 
    60 - 79% = 23514 
    80 - 99% = 237 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2549, nodes: 2073290 
    Average node length: 5.45, total dup: 1933579, max dup: 1690 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179662, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 302 
        40 - 59% = 1657 
        60 - 79% = 274 
        80 - 99% = 313 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2754, nodes: 2073290 
    Average node length: 5.69, total dup: 1860730, max dup: 63 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370718, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2486 
        60 - 79% = 239 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2075, nodes: 2073290 
    Average node length: 4.96, total dup: 2073190, max dup: 27591 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177756, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 211 
        40 - 59% = 1041 
        60 - 79% = 371 
        80 - 99% = 451 
 
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: 48.05, total records: 132435 
    Average version length: 69.17, total versions: 46548, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.62 
    Pointer pages: 3, data page slots: 3784 
    Data pages: 2784, average fill: 57% 
    Primary pages: 2783, secondary pages: 1, swept pages: 249 
    Empty pages: 195, full pages: 1114 
    Fill distribution: 
     0 - 19% = 328 
    20 - 39% = 378 
    40 - 59% = 592 
    60 - 79% = 937 
    80 - 99% = 549 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103586, depth: 3, leaf buckets: 230, nodes: 132435 
    Average node length: 6.43, total dup: 115126, max dup: 14 
    Average key length: 3.98, compression ratio: 10.55 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 23566, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 69 
        40 - 59% = 130 
        60 - 79% = 30 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.69, total records: 6944793 
    Average version length: 68.77, total versions: 262056, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 67, data page slots: 108312 
    Data pages: 108312, average fill: 69% 
    Primary pages: 108311, secondary pages: 1, swept pages: 43560 
    Empty pages: 35, full pages: 47804 
    Fill distribution: 
     0 - 19% = 189 
    20 - 39% = 1194 
    40 - 59% = 13203 
    60 - 79% = 93120 
    80 - 99% = 606 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10760, nodes: 6944793 
    Average node length: 6.51, total dup: 6006839, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1616087, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1898 
        40 - 59% = 6001 
        60 - 79% = 2480 
        80 - 99% = 375 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8594, nodes: 6944793 
    Average node length: 5.40, total dup: 6665627, max dup: 146 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1427374, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1283 
        40 - 59% = 4854 
        60 - 79% = 1648 
        80 - 99% = 798 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8625, nodes: 6944793 
    Average node length: 5.40, total dup: 6665627, max dup: 146 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1429737, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1331 
        40 - 59% = 4855 
        60 - 79% = 1583 
        80 - 99% = 844 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.87, total records: 11966650 
    Average version length: 68.70, total versions: 213259, 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: 108, data page slots: 175616 
    Data pages: 175616, average fill: 72% 
    Primary pages: 175615, secondary pages: 1, swept pages: 88902 
    Empty pages: 4, full pages: 136572 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 938 
    40 - 59% = 7859 
    60 - 79% = 165729 
    80 - 99% = 1019 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18424, nodes: 11965215 
    Average node length: 6.61, total dup: 10431657, max dup: 75 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2441043, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 2488 
        40 - 59% = 10795 
        60 - 79% = 4409 
        80 - 99% = 718 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 54.25, total records: 1346311 
    Average version length: 69.00, total versions: 216826, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.32 
    Pointer pages: 25, data page slots: 39064 
    Data pages: 29776, average fill: 48% 
    Primary pages: 29694, secondary pages: 82, swept pages: 13236 
    Empty pages: 5320, full pages: 14236 
    Fill distribution: 
     0 - 19% = 7835 
    20 - 39% = 3959 
    40 - 59% = 3353 
    60 - 79% = 11851 
    80 - 99% = 2778 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1926, nodes: 1229973 
    Average node length: 5.53, total dup: 1179833, max dup: 49 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 85969, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 802 
        40 - 59% = 878 
        60 - 79% = 228 
        80 - 99% = 11 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 44.06, total records: 992401 
    Average version length: 69.03, total versions: 118975, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.86 
    Pointer pages: 19, data page slots: 30776 
    Data pages: 27720, average fill: 33% 
    Primary pages: 27719, secondary pages: 1, swept pages: 8535 
    Empty pages: 4945, full pages: 5344 
    Fill distribution: 
     0 - 19% = 9443 
    20 - 39% = 6188 
    40 - 59% = 7738 
    60 - 79% = 4276 
    80 - 99% = 75 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1112, nodes: 698842 
    Average node length: 5.91, total dup: 646036, max dup: 69 
    Average key length: 2.98, compression ratio: 14.11 
    Average prefix length: 41.10, average data length: 0.90 
    Clustering factor: 97421, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 382 
        40 - 59% = 545 
        60 - 79% = 171 
        80 - 99% = 12 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.16, total records: 8998122 
    Average version length: 68.93, total versions: 256708, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 87, data page slots: 141712 
    Data pages: 141664, average fill: 68% 
    Primary pages: 141651, secondary pages: 13, swept pages: 71888 
    Empty pages: 304, full pages: 63247 
    Fill distribution: 
     0 - 19% = 861 
    20 - 39% = 3054 
    40 - 59% = 19699 
    60 - 79% = 116677 
    80 - 99% = 1373 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13450, nodes: 8994417 
    Average node length: 6.68, total dup: 7456947, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2012290, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1487 
        40 - 59% = 7062 
        60 - 79% = 4427 
        80 - 99% = 473 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21086828 
    Average version length: 82.71, total versions: 12718, 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: 318928 
    Data pages: 318928, average fill: 81% 
    Primary pages: 318922, secondary pages: 6, swept pages: 13383 
    Empty pages: 41, full pages: 317454 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 62 
    40 - 59% = 212 
    60 - 79% = 47617 
    80 - 99% = 270963 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19288, nodes: 21086828 
    Average node length: 5.72, total dup: 20607364, max dup: 140 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3272752, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 8072 
        60 - 79% = 529 
        80 - 99% = 10686 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17067, nodes: 21086828 
    Average node length: 6.31, total dup: 18531720, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913722, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 684 
        60 - 79% = 261 
        80 - 99% = 16117 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21077, nodes: 21086828 
    Average node length: 6.34, total dup: 18450577, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3565942, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8346 
        60 - 79% = 588 
        80 - 99% = 12139 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15926, nodes: 21086828 
    Average node length: 5.56, total dup: 21086728, max dup: 230818 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942571, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 8 
        40 - 59% = 2667 
        60 - 79% = 325 
        80 - 99% = 12924 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 80.45, total records: 9444347 
    Average version length: 82.56, total versions: 251423, 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: 102, data page slots: 166432 
    Data pages: 166360, average fill: 70% 
    Primary pages: 166332, secondary pages: 28, swept pages: 91089 
    Empty pages: 606, full pages: 91937 
    Fill distribution: 
     0 - 19% = 1496 
    20 - 39% = 4348 
    40 - 59% = 21095 
    60 - 79% = 120740 
    80 - 99% = 18681 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11308, nodes: 9444347 
    Average node length: 5.37, total dup: 9138350, max dup: 164 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2163077, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 58 
        40 - 59% = 8851 
        60 - 79% = 2336 
        80 - 99% = 60 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13154, nodes: 9444347 
    Average node length: 6.24, total dup: 7825348, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1520914, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 3714 
        40 - 59% = 4343 
        60 - 79% = 2641 
        80 - 99% = 2334 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12621, nodes: 9444347 
    Average node length: 5.99, total dup: 8188548, max dup: 38 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2344146, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 76 
        40 - 59% = 9862 
        60 - 79% = 2624 
        80 - 99% = 58 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9852, nodes: 9444347 
    Average node length: 5.14, total dup: 9444247, max dup: 145902 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1549567, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1194 
        40 - 59% = 4726 
        60 - 79% = 1837 
        80 - 99% = 2046 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.59, total records: 11160228 
    Average version length: 82.50, total versions: 260381, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 117, data page slots: 189400 
    Data pages: 188120, average fill: 73% 
    Primary pages: 187992, secondary pages: 128, swept pages: 66698 
    Empty pages: 2182, full pages: 145564 
    Fill distribution: 
     0 - 19% = 3823 
    20 - 39% = 6078 
    40 - 59% = 15193 
    60 - 79% = 98638 
    80 - 99% = 64388 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13122, nodes: 11160228 
    Average node length: 5.31, total dup: 11051306, max dup: 640 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2332604, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 127 
        40 - 59% = 9495 
        60 - 79% = 3398 
        80 - 99% = 102 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10327, nodes: 11160228 
    Average node length: 5.50, total dup: 10672073, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 708098, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 843 
        40 - 59% = 2536 
        60 - 79% = 1862 
        80 - 99% = 4936 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15003, nodes: 11160228 
    Average node length: 6.03, total dup: 9736390, max dup: 76 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2348935, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 173 
        40 - 59% = 10996 
        60 - 79% = 3723 
        80 - 99% = 111 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10577, nodes: 11160228 
    Average node length: 5.23, total dup: 11160128, max dup: 183542 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 696738, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 825 
        40 - 59% = 4511 
        60 - 79% = 1538 
        80 - 99% = 3604 
 
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: 81.14, total records: 9512484 
    Average version length: 82.86, total versions: 205651, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 105, data page slots: 169832 
    Data pages: 169784, average fill: 69% 
    Primary pages: 169757, secondary pages: 27, swept pages: 101033 
    Empty pages: 643, full pages: 86836 
    Fill distribution: 
     0 - 19% = 1651 
    20 - 39% = 4867 
    40 - 59% = 23266 
    60 - 79% = 123735 
    80 - 99% = 16265 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11614, nodes: 9512484 
    Average node length: 5.18, total dup: 9483847, max dup: 1961 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1972658, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1590 
        40 - 59% = 7691 
        60 - 79% = 1747 
        80 - 99% = 552 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13217, nodes: 9512484 
    Average node length: 6.25, total dup: 7882410, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1500921, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 181 
        20 - 39% = 3718 
        40 - 59% = 4197 
        60 - 79% = 2642 
        80 - 99% = 2479 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12223, nodes: 9512484 
    Average node length: 5.44, total dup: 9082018, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 2101909, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1500 
        40 - 59% = 8542 
        60 - 79% = 1597 
        80 - 99% = 555 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10050, nodes: 9512484 
    Average node length: 5.15, total dup: 9512384, max dup: 147343 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1584324, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1337 
        40 - 59% = 4829 
        60 - 79% = 1810 
        80 - 99% = 2026 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.79, total records: 572745 
    Average version length: 68.93, total versions: 3621, 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: 8080 
    Data pages: 8080, average fill: 74% 
    Primary pages: 8080, secondary pages: 0, swept pages: 4334 
    Empty pages: 4, full pages: 6474 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 12 
    40 - 59% = 192 
    60 - 79% = 7820 
    80 - 99% = 49 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45895, depth: 3, leaf buckets: 728, nodes: 572745 
    Average node length: 5.95, total dup: 487583, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100320, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 523 
        60 - 79% = 87 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33257, depth: 3, leaf buckets: 752, nodes: 572745 
    Average node length: 6.15, total dup: 469745, max dup: 15 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100367, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 532 
        60 - 79% = 82 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 546, nodes: 572745 
    Average node length: 4.86, total dup: 572645, max dup: 8794 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89237, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 34 
        40 - 59% = 296 
        60 - 79% = 60 
        80 - 99% = 153 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Wed Mar 13 04:10:55 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7699890 51005 1 0.0000 0.0000
DOC_LIST 2222491 27347 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_TURNOVER_LOG 108548 91533 1 0.0000 0.0000
MONEY_TURNOVER_LOG 1933 1445 1 0.0000 0.0000
PDISTR 807518 21070 3 0.0000 0.0000
PERF_SPLIT_0 165643 12882 1 0.0000 0.0000
PERF_SPLIT_1 152083 22230 1 0.0000 0.0000
PERF_SPLIT_2 190932 29288 1 0.0000 0.0000
PERF_SPLIT_3 140882 1664 1 0.0000 0.0000
PERF_SPLIT_4 149307 3315 1 0.0000 0.0000
PERF_SPLIT_5 156860 15361 1 0.0000 0.0000
PERF_SPLIT_6 150153 8773 1 0.0000 0.0000
PERF_SPLIT_7 143198 4039 1 0.0000 0.0000
PERF_SPLIT_8 159813 3732 1 0.0000 0.0000
PERF_SPLIT_9 156539 5003 1 0.0000 0.0000
PSTORNED 2073290 24924 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 132435 46548 1 0.0000 0.0000
XQD_1000_3300 6944793 262056 1 0.0000 0.0000
XQD_1200_2000 11966650 213259 1 0.0000 0.0000
XQD_2000_3300 1346311 216826 1 0.0000 0.0000
XQD_2100_3300 992401 118975 1 0.0000 0.0000
XQD_3300_3400 8998122 256708 1 0.0000 0.0000
XQS_1000_1200 21086828 12718 1 0.0000 0.0000
XQS_1000_3300 9444347 251423 1 0.0000 0.0000
XQS_1200_2000 11160228 260381 1 0.0000 0.0000
XQS_2100_3300 9512484 205651 1 0.0000 0.0000
XQS_3300_3400 572745 3621 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 ---
:29: 
:30: mscs-test-161.budzdorov.ru    Wed Mar 13 04:07:55 2024
:31:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:32: 
:33: 
:34: mscs-test-161.budzdorov.ru    Wed Mar 13 04:08:04 2024
:35:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:36: 
:37: 
:38: mscs-test-161.budzdorov.ru    Wed Mar 13 04:08:06 2024
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:40: 
:41: 
:42: mscs-test-161.budzdorov.ru    Wed Mar 13 04:08:11 2024
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:44: 
--- end of diff output ---

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

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