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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-02 10:07:51
DTS_END                         2024-04-02 10:07:51.3230
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/50828
TRN_ID                          180356
ATT_ID                          608
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: 9768.47 22285 976847
customer order: creation 184.39 408 18439
customer order: refuse 16.24 354 1624
order to supplier: creation 49.30 1292 4930
order to supplier: removal 3.58 93323 358
invoice (draft): creation 48.36 2907 4836
invoice (draft): removal 51.42 665 5142
invoice accept: apply 45.97 20707 4597
invoice accept: cancel 47.15 862 4715
customer reserve: creation 4397.40 199 439740
customer reserve: removal 4618.96 59 461896
realization accept: apply 91.42 192 9142
realization accept: cancel 76.54 131 7654
payment from customer: creation 62.60 117 6260
payment from customer: removal 6.40 91 640
payment to supplier: creation 53.03 143 5303
payment to supplier: removal 3.62 50 362
service: total inventory turnovers 3.85 3811 385
service: total monetary turnovers 7.23 519 723
service: aggregate perf. data 0.98 17153 98
service: refresh index statistics 0.03 302718 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-04-2024 10:08:34 to 02-04-2024 10:08:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4663
TEST_TIME 2 3318
TEST_TIME 3 3460
TEST_TIME 4 3745
TEST_TIME 5 4606
TEST_TIME 6 4623
TEST_TIME 7 5463
TEST_TIME 8 5872
TEST_TIME 9 6216
TEST_TIME 10 6361
TEST_TIME 11 6526
TEST_TIME 12 6716
TEST_TIME 13 6839
TEST_TIME 14 6912
TEST_TIME 15 7022
TEST_TIME 16 7055
TEST_TIME 17 7362
TEST_TIME 18 7703
TEST_TIME 19 7727
TEST_TIME 20 7989
TEST_TIME 21 8410
TEST_TIME 22 8601
TEST_TIME 23 8796
TEST_TIME 24 9514
TEST_TIME 25 10059
TEST_TIME 26 9927
TEST_TIME 27 10579
TEST_TIME 28 10419
TEST_TIME 29 10210
TEST_TIME 30 10066
TEST_TIME 31 10217
TEST_TIME 32 10265
TEST_TIME 33 10263
TEST_TIME 34 10306
TEST_TIME 35 10361
TEST_TIME 36 10481
TEST_TIME 37 10382
TEST_TIME 38 10269
TEST_TIME 39 10117
TEST_TIME 40 10074
TEST_TIME 41 9969
TEST_TIME 42 9933
TEST_TIME 43 9933
TEST_TIME 44 9906
TEST_TIME 45 10018
TEST_TIME 46 9967
TEST_TIME 47 9878
TEST_TIME 48 9845
TEST_TIME 49 9780
TEST_TIME 50 9793
TEST_TIME 51 9800
TEST_TIME 52 9975
TEST_TIME 53 9960
TEST_TIME 54 9914
TEST_TIME 55 9929
TEST_TIME 56 10008
TEST_TIME 57 9985
TEST_TIME 58 10075
TEST_TIME 59 10106
TEST_TIME 60 10163
TEST_TIME 61 10220
TEST_TIME 62 10104
TEST_TIME 63 10008
TEST_TIME 64 10023
TEST_TIME 65 9957
TEST_TIME 66 9901
TEST_TIME 67 9901
TEST_TIME 68 9864
TEST_TIME 69 9827
TEST_TIME 70 9737
TEST_TIME 71 9630
TEST_TIME 72 9636
TEST_TIME 73 9623
TEST_TIME 74 9576
TEST_TIME 75 9646
TEST_TIME 76 9737
TEST_TIME 77 9751
TEST_TIME 78 9755
TEST_TIME 79 9776
TEST_TIME 80 9742
TEST_TIME 81 9782
TEST_TIME 82 9850
TEST_TIME 83 9849
TEST_TIME 84 9866
TEST_TIME 85 9881
TEST_TIME 86 9786
TEST_TIME 87 9722
TEST_TIME 88 9707
TEST_TIME 89 9651
TEST_TIME 90 9652
TEST_TIME 91 9612
TEST_TIME 92 9599
TEST_TIME 93 9675
TEST_TIME 94 9679
TEST_TIME 95 9683
TEST_TIME 96 9677
TEST_TIME 97 9768
TEST_TIME 98 9764
TEST_TIME 99 9732
TEST_TIME 100 9773

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 02-04-2024 10:08:37 to 02-04-2024 10:08:41.

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 1377713 1377713 0 0.00 0 18241 8 0 0
doc_list_biud 1377710 1377710 0 0.00 0 88198 25 0 0
sp_add_invoice_to_stock 4722 4597 125 2.64 38 209403 20708 0 125
sp_cancel_adding_invoice 4715 4715 0 0.00 4 47700 863 0 0
sp_cancel_client_order 1624 1624 0 0.00 4 9880 355 0 0
sp_cancel_customer_reserve 461896 461896 0 0.00 0 22332 59 0 0
sp_cancel_pay_from_customer 640 640 0 0.00 2 6508 91 0 0
sp_cancel_pay_to_supplier 362 362 0 0.00 3 746 51 0 0
sp_cancel_supplier_invoice 5150 5142 8 0.15 1 88210 665 0 8
sp_cancel_supplier_order 358 358 0 0.00 13 1166000 93324 0 0
sp_cancel_write_off 7654 7654 0 0.00 1 8067 131 0 0
sp_client_order 18439 18439 0 0.00 3 25936 408 0 0
sp_customer_reserve 439740 439740 0 0.00 0 104602 199 0 0
sp_fill_shopping_cart 28198 28198 0 0.00 1 12306 37 0 0
sp_fill_shopping_cart_clo_res 439738 439738 0 0.00 0 22507 19 0 0
sp_get_clo_for_invoice 4593 4593 0 0.00 0 30868 382 0 0
sp_kill_cost_storno 13371 13371 0 0.00 0 12252 65 0 0
sp_kill_qstorno_ret_qs2qd 936946 936946 0 0.00 0 88195 31 0 0
sp_kill_qty_storno 495120 495120 0 0.00 0 88197 68 0 0
sp_lock_selected_doc 19021 19021 0 0.00 0 7430 5 0 0
sp_make_cost_storno 25297 25297 0 0.00 0 18144 70 0 0
sp_multiply_rows_for_pdistr 25297 25297 0 0.00 0 11855 32 0 0
sp_multiply_rows_for_qdistr 18439 18439 0 0.00 0 23986 222 0 0
sp_pay_from_customer 6260 6260 0 0.00 3 13843 117 0 0
sp_pay_to_supplier 5303 5303 0 0.00 4 13429 143 0 0
sp_payment_common 11563 11563 0 0.00 1 11373 24 0 0
sp_qd_handle_on_cancel_clo 1624 1624 0 0.00 0 9870 327 0 0
sp_qd_handle_on_invoice_upd_sts 9307 9307 0 0.00 0 32058 308 0 0
sp_qd_handle_on_reserve_upd_sts 9139 9139 0 0.00 0 22630 57 0 0
sp_reserve_write_off 9142 9142 0 0.00 6 22672 192 0 0
sp_supplier_invoice 4836 4836 0 0.00 6 61912 2908 0 0
sp_supplier_order 4930 4930 0 0.00 5 32480 1293 0 0
srv_aggregate_perf_data 99 98 1 1.01 1589 360655 17153 0 1
srv_fill_mon_cache_memory 57 57 0 0.00 972 109175 39896 0 0
srv_find_qd_qs_mism 930135 930135 0 0.00 0 11465 7 0 0
srv_make_invnt_saldo 385 385 0 0.00 30 110487 3811 0 0
srv_make_money_saldo 723 723 0 0.00 0 12608 520 0 0
srv_recalc_idx_stat 3 3 0 0.00 206379 442424 302718 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 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 4598 4598 0 0.00 0 23024 179 0 0
t$perf-norm:sp_cancel_adding_invoice 373 373 0 0.00 0 2046 87 0 0
t$perf-norm:sp_cancel_client_order 1624 1624 0 0.00 0 872 8 0 0
t$perf-norm:sp_cancel_customer_reserve 658 658 0 0.00 0 1668 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 640 640 0 0.00 0 407 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 362 362 0 0.00 0 699 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 351 351 0 0.00 0 5018 23 0 0
t$perf-norm:sp_cancel_supplier_order 358 358 0 0.00 0 25152 1567 0 0
t$perf-norm:sp_cancel_write_off 925 925 0 0.00 0 2968 8 0 0
t$perf-norm:sp_client_order 18439 18439 0 0.00 0 8428 19 0 0
t$perf-norm:sp_customer_reserve 861 861 0 0.00 0 1471 12 0 0
t$perf-norm:sp_pay_from_customer 6260 6260 0 0.00 0 5745 10 0 0
t$perf-norm:sp_pay_to_supplier 5303 5303 0 0.00 0 4758 9 0 0
t$perf-norm:sp_reserve_write_off 9142 9142 0 0.00 0 8443 10 0 0
t$perf-norm:sp_supplier_invoice 4836 4836 0 0.00 0 3175 16 0 0
t$perf-norm:sp_supplier_order 4930 4930 0 0.00 0 2594 14 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 1050 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 911 17 0 0
t$perf-norm:srv_make_invnt_saldo 385 385 0 0.00 0 2663 20 0 0
t$perf-norm:srv_make_money_saldo 723 723 0 0.00 0 563 5 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 9434 9184 250 2.64 0 6144 19 0 250
v_all_customers 33836 33836 0 0.00 0 36 1 0 0
v_all_suppliers 27724 27724 0 0.00 0 22 1 0 0
v_all_wares 36874 36874 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 746 746 0 0.00 0 1193 12 0 0
v_cancel_client_order 3248 3248 0 0.00 0 1614 6 0 0
v_cancel_customer_prepayment 1280 1280 0 0.00 0 2199 7 0 0
v_cancel_customer_reserve 1316 1316 0 0.00 0 351 4 0 0
v_cancel_payment_to_supplier 724 724 0 0.00 0 640 4 0 0
v_cancel_supplier_invoice 718 702 16 2.22 0 6614 23 0 16
v_cancel_supplier_order 716 716 0 0.00 0 1248 7 0 0
v_cancel_write_off 1850 1850 0 0.00 0 996 13 0 0
v_max_id_clo_ord 4928 4928 0 0.00 0 1536 2 0 0
v_max_id_clo_res 861 861 0 0.00 0 2696 14 0 0
v_max_id_ord_sup 4833 4833 0 0.00 0 9015 6 0 0
v_max_non_paid_invoice 1202 1202 0 0.00 0 377 2 0 0
v_max_non_paid_realizn 3247 3247 0 0.00 0 951 4 0 0
v_min_id_clo_ord 4928 4928 0 0.00 0 4147 8 0 0
v_min_id_clo_res 861 861 0 0.00 0 3743 13 0 0
v_min_id_ord_sup 4833 4833 0 0.00 0 7689 7 0 0
v_min_non_paid_invoice 5303 5303 0 0.00 0 10141 20 0 0
v_min_non_paid_realizn 6260 6260 0 0.00 0 11366 18 0 0
v_our_firm 9064 9064 0 0.00 0 19 1 0 0
v_reserve_write_off 18276 18276 0 0.00 0 3184 6 0 0
x_lock_depdocs_on_canc_invoice 9506 9506 0 0.00 0 23728 128 0 0
x_lock_depdocs_on_canc_sup_ord 358 358 0 0.00 0 6659 304 0 0
x_make_qstorno_1000_1200 4930 4930 0 0.00 2 32453 1214 0 0
x_make_qstorno_1200_2000 4836 4836 0 0.00 3 61905 2778 0 0
x_make_qstorno_2100_3300 439740 439740 0 0.00 0 104600 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-04-2024 10:08:42 to 02-04-2024 10:08:46.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:55 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
08:08:56 36959 8192000000 9713669808 10012409856 785913104 8.753 100 87 174 0 814014368 7662448 20438816
08:10:42 16782 8192000000 9750296720 10058366976 827176832 9.171 100 87 174 0 859048384 11893392 19978160
08:12:04 15613 8192000000 9777935584 10095165440 850480752 9.405 100 82 161 0 886455536 17900720 18074064
08:13:35 15182 8192000000 9864305408 10196279296 906437504 9.962 100 84 164 0 973398384 49837280 17123600
08:14:53 5642 8192000000 9898300832 10240122880 934164352 10.236 100 91 180 0 1007710800 55381600 18164848
08:16:02 3025 8192000000 9937203696 10290479104 969070928 10.578 100 79 159 0 1053956544 68913744 15971872
08:17:07 2606 8192000000 9968349600 10327654400 997321616 10.853 100 86 170 0 1086741040 72433584 16985840
08:18:12 1262 8192000000 10006988352 10374160384 1021194960 11.084 100 80 160 1 1124292480 87070240 16027280
08:19:15 1376 8192000000 10015406848 10384576512 1049025088 11.351 100 89 177 0 1123725664 57274336 17426240
08:20:17 23933 8192000000 9973675616 10365300736 1056372080 11.422 100 41 78 1 1105668352 40710352 8585920
08:21:42 5906 8192000000 9993404016 10388230144 1063004768 11.485 100 40 80 0 1110228032 38945024 8278240
08:22:48 3472 8192000000 9992144224 10386718720 1076577824 11.615 100 54 107 0 1111156336 24006560 10571952
08:23:52 47430 8192000000 9974755408 10380677120 1077048016 11.619 100 33 62 0 1108721248 24888528 6784704
08:25:54 3159 8192000000 9997066304 10398216192 1080665872 11.654 100 50 99 0 1113803024 23674976 9462176
08:26:58 6946 8192000000 10010948976 10411728896 1086224960 11.707 100 44 89 1 1116016512 19421712 10369840
08:28:07 7933 8192000000 10003423872 10408329216 1092438944 11.766 100 40 79 0 1114547792 14062080 8046768
08:29:26 61930 8192000000 10061810576 10461478912 1094744896 11.788 100 54 108 0 1159963600 54731840 10486864
08:31:35 48818 8192000000 10076887520 10501820416 1075265600 11.602 97 42 84 0 1169343392 85765200 8312592
08:33:27 3838 8192000000 10114405952 10510958592 1109595424 11.929 100 66 131 1 1225233216 102434128 13203664
08:34:41 9081 8192000000 10101913120 10507399168 1092904752 11.770 98 45 89 0 1196341952 93965360 9471840
08:35:55 19756 8192000000 10132703232 10541133824 1078544688 11.634 98 51 100 0 1215500672 126153232 10802752
08:37:20 1106 8192000000 10126444576 10516172800 1086465440 11.709 100 61 117 0 1228887184 130809696 11612048
08:38:26 20616 8192000000 10102409216 10503712768 1072911376 11.580 97 38 73 0 1196485696 115895040 7679280
08:39:51 1725 8192000000 10170560720 10557718528 1102649392 11.863 100 76 149 1 1273485472 155714544 15121536
08:40:58 5135 8192000000 10203061552 10591338496 1094186448 11.782 99 82 162 1 1300881696 189511312 17183936
08:42:05 1692 8192000000 10256701520 10646044672 1125662880 12.080 100 85 169 1 1359217216 215703504 17850832
08:43:10 970 8192000000 10273188768 10656944128 1102905440 11.865 100 88 177 0 1367951488 246010784 19035264
08:44:16 1475 8192000000 10330921056 10721247232 1114885200 11.979 100 73 142 0 1430594064 299828704 15880160
08:45:23 1237 8192000000 10327162368 10755026944 1124717552 12.072 100 81 160 1 1429608784 286877616 18013616
08:46:31 2555 8192000000 10373808816 10767822848 1144902544 12.262 100 93 182 0 1471909456 306411056 20595856
08:47:39 2386 8192000000 10386890304 10794745856 1144181312 12.255 100 80 157 0 1485197520 323776992 17239216
08:48:46 6972 8192000000 10381657344 10797101056 1159291664 12.397 100 55 107 0 1475942656 304605856 12045136
08:50:00 20310 8192000000 10383994272 10846842880 1142161312 12.236 100 28 54 0 1492550192 343356720 7032160
08:51:23 19712 8192000000 10312245264 10865504256 1138327504 12.200 100 19 38 0 1410215712 267057584 4830624
08:52:45 18213 8192000000 10219029024 10682593280 1126595120 12.089 100 16 32 0 1325818096 195489472 3733504
08:54:05 47977 8192000000 10056498848 10550620160 1109775280 11.930 99 12 24 0 1229367936 116957984 2634672
08:55:59 28199 8192000000 10080200928 10513498112 1131033664 12.131 100 42 84 1 1162313632 23310304 7969664
08:57:34 37208 8192000000 10122289184 10563215360 1134254352 12.161 100 32 65 0 1216409648 76132208 6023088
08:59:20 109098 8192000000 10093623936 10600820736 1118669504 12.014 99 14 28 0 1171881136 50824768 2386864
09:02:45 109174 8192000000 10100465392 10563817472 1131223536 12.133 99 10 20 0 1171135344 38297664 1614144
09:05:42 96941 8192000000 10099401056 10540097536 1144104912 12.254 100 31 60 0 1212538864 62275600 6158352
09:08:26 83433 8192000000 10079493264 10514243584 1129510176 12.117 98 18 33 1 1181421536 48798080 3113280
09:10:52 36084 8192000000 10137288480 10565836800 1152709488 12.335 100 35 70 0 1232059664 72159728 7190448
09:12:39 39565 8192000000 10054679840 10495606784 1116188352 11.991 98 17 34 1 1143631152 24061888 3380912
09:14:22 96826 8192000000 10091992032 10571419648 1082116224 11.668 95 11 22 0 1121305792 37093200 2096368
09:17:02 47763 8192000000 10073615808 10510290944 1095793328 11.798 97 15 28 2 1155707008 56867824 3045856
09:19:00 81548 8192000000 10052426736 10493939712 1093943936 11.780 98 8 14 0 1145549136 50267120 1338080
09:21:21 10535 8192000000 10064896064 10487726080 1113148240 11.962 100 54 106 0 1166891648 43637744 10105664
09:22:39 42225 8192000000 10072416000 10537398272 1103207712 11.868 99 29 59 0 1168935360 60191712 5535936
09:24:22 76254 8192000000 10091487808 10535997440 1092594944 11.767 98 27 53 0 1162373840 64696640 5082256
09:26:44 94080 8192000000 10063175408 10525057024 1057347904 11.431 95 12 24 0 1103333936 43320896 2665136
09:29:28 79648 8192000000 10057942176 10501046272 1088763104 11.731 99 25 48 0 1138136544 44528912 4844528
09:31:55 38150 8192000000 10035908080 10512429056 1086367584 11.708 99 18 36 0 1136768480 47061696 3339200
09:33:35 13615 8192000000 10056793664 10475585536 1097978976 11.818 100 61 119 1 1144710992 34828656 11903360
09:34:56 52443 8192000000 10035012032 10480017408 1073878608 11.589 97 21 43 0 1110878544 33239024 3760912
09:36:54 31598 8192000000 10042941936 10493665280 1095334752 11.793 99 15 30 0 1145291552 47352368 2604432
09:38:26 34744 8192000000 10061357552 10503503872 1097701200 11.816 99 30 60 0 1147535760 44049216 5785344
09:40:02 44038 8192000000 10028463280 10474004480 1104762960 11.883 99 9 18 0 1138276816 32013664 1500192
09:41:50 44765 8192000000 10106825728 10556784640 1110000032 11.932 99 27 54 0 1200559648 85005520 5554096
09:43:35 48644 8192000000 10074607008 10498662400 1105711232 11.892 99 27 52 0 1162869856 51810592 5348032
09:45:24 12176 8192000000 10082582192 10503823360 1120791392 12.034 100 46 92 0 1172597280 43168880 8637008
09:46:39 24833 8192000000 10076012048 10527404032 1124270368 12.067 100 23 46 0 1193697008 64777488 4649152
09:48:04 60122 8192000000 10121265456 10602639360 1116736000 11.996 99 29 58 0 1203586176 81276800 5573376
09:50:15 35458 8192000000 10074277392 10529595392 1105570432 11.890 98 32 64 0 1157217680 45946032 5701216
09:51:51 63259 8192000000 10083384656 10522968064 1106783104 11.902 98 22 44 0 1164818672 54008896 4026672
09:53:55 65236 8192000000 10070287904 10519666688 1101627504 11.853 98 24 48 0 1171046160 64731040 4687616
09:56:01 26732 8192000000 10069679616 10556174336 1122071968 12.047 100 10 20 0 1174627376 50190416 2364992
09:57:32 40768 8192000000 10062940480 10523095040 1104020368 11.876 98 11 22 0 1147290672 41005856 2264448
09:59:20 92761 8192000000 10099966896 10598760448 1106002784 11.895 98 33 66 1 1197937520 85095360 6839376
10:02:10 58378 8192000000 10077108192 10525618176 1071168048 11.563 95 13 26 0 1134119312 60193216 2758048
10:04:15 78710 8192000000 10084808240 10589405184 1099090400 11.829 99 12 24 0 1170606352 69367360 2148592
10:06:35 35575 8192000000 10090496560 10513416192 1054981616 11.408 95 34 68 1 1112483904 51583152 5919136

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 125 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

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          177270
MON$OLDEST_ACTIVE               180479
MON$OLDEST_SNAPSHOT             180479
MON$NEXT_TRANSACTION            180479
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                       1941472
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             708
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Tue Apr  2 10:09:06 2024 
 
Database header page information: 
    Flags            0 
    Generation        94183 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    177270 
    Oldest active        180479 
    Oldest snapshot        180479 
    Next transaction    180480 
    Sequence number        0 
    Next attachment ID    708 
    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.10, total records: 7838283 
    Average version length: 48.16, total versions: 160756, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 89432 
    Data pages: 89432, average fill: 70% 
    Primary pages: 89430, secondary pages: 2, swept pages: 27318 
    Empty pages: 7, full pages: 79128 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 31 
    40 - 59% = 886 
    60 - 79% = 88392 
    80 - 99% = 105 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23552, nodes: 7838283 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1704781, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 347 
        20 - 39% = 1697 
        40 - 59% = 4404 
        60 - 79% = 2342 
        80 - 99% = 14762 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13653, nodes: 7838283 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1529112, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1478 
        40 - 59% = 2240 
        60 - 79% = 1088 
        80 - 99% = 8847 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8488, nodes: 7838283 
    Average node length: 6.64, total dup: 5833531, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1521954, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 164 
        20 - 39% = 916 
        40 - 59% = 1524 
        60 - 79% = 889 
        80 - 99% = 4995 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.68, total records: 2296081 
    Average version length: 58.87, total versions: 84558, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28904 
    Data pages: 28904, average fill: 74% 
    Primary pages: 28902, secondary pages: 2, swept pages: 7154 
    Empty pages: 0, full pages: 25603 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 36 
    40 - 59% = 204 
    60 - 79% = 28456 
    80 - 99% = 198 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4664, nodes: 2296081 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 692339, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 929 
        40 - 59% = 942 
        60 - 79% = 668 
        80 - 99% = 2125 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2437, nodes: 2297919 
    Average node length: 4.97, total dup: 2297020, max dup: 20129 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1290465, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 179 
        40 - 59% = 1380 
        60 - 79% = 599 
        80 - 99% = 278 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1796, nodes: 2296081 
    Average node length: 4.97, total dup: 2296031, max dup: 130367 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1081917, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 644 
        60 - 79% = 54 
        80 - 99% = 1095 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4459, nodes: 2296081 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 692339, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 114 
        20 - 39% = 605 
        40 - 59% = 692 
        60 - 79% = 754 
        80 - 99% = 2294 
 
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.35, total records: 400 
    Average version length: 28.79, total versions: 1952, max versions: 5 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 67% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 1, full pages: 14 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 22.22, total records: 135966 
    Average version length: 68.29, total versions: 105649, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.96 
    Pointer pages: 8, data page slots: 3256 
    Data pages: 2504, average fill: 71% 
    Primary pages: 2503, secondary pages: 1, swept pages: 0 
    Empty pages: 310, full pages: 1745 
    Fill distribution: 
     0 - 19% = 360 
    20 - 39% = 102 
    40 - 59% = 124 
    60 - 79% = 484 
    80 - 99% = 1434 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1711504, depth: 3, leaf buckets: 404, nodes: 135966 
    Average node length: 13.14, total dup: 11487, max dup: 2 
    Average key length: 10.53, compression ratio: 2.56 
    Average prefix length: 19.38, average data length: 7.62 
    Clustering factor: 97570, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 18 
        40 - 59% = 278 
        60 - 79% = 103 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 389, max versions: 14 
    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: 16 
    Data pages: 16, average fill: 9% 
    Primary pages: 5, secondary pages: 11, swept pages: 0 
    Empty pages: 4, full pages: 1 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.79, total records: 2421 
    Average version length: 43.49, total versions: 2169, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.53 
    Pointer pages: 1, data page slots: 120 
    Data pages: 32, average fill: 79% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 1, full pages: 27 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 6 
    80 - 99% = 21 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91633, depth: 2, leaf buckets: 6, nodes: 2421 
    Average node length: 4.17, total dup: 2323, max dup: 257 
    Average key length: 2.46, compression ratio: 7.72 
    Average prefix length: 18.58, average data length: 0.42 
    Clustering factor: 1274, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 3 
        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.74, total records: 73 
    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: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    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: 35.74, total records: 818787 
    Average version length: 37.91, total versions: 38506, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8368 
    Data pages: 8360, average fill: 67% 
    Primary pages: 8357, secondary pages: 3, swept pages: 890 
    Empty pages: 18, full pages: 8194 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 16 
    40 - 59% = 21 
    60 - 79% = 8224 
    80 - 99% = 73 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 854, nodes: 796208 
    Average node length: 4.88, total dup: 796159, max dup: 144518 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90343, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 119 
        40 - 59% = 475 
        60 - 79% = 149 
        80 - 99% = 110 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 937, nodes: 796208 
    Average node length: 5.89, total dup: 708974, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159933, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 54 
        40 - 59% = 496 
        60 - 79% = 85 
        80 - 99% = 300 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 958, nodes: 796208 
    Average node length: 5.89, total dup: 708974, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161790, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 111 
        40 - 59% = 474 
        60 - 79% = 78 
        80 - 99% = 295 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1115, nodes: 796208 
    Average node length: 5.97, total dup: 708974, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154217, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 230 
        40 - 59% = 591 
        60 - 79% = 195 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5463 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.05, total fragments: 39, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 78, secondary pages: 18, swept pages: 51 
    Empty pages: 14, full pages: 54 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5463 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.43, average data length: 1.55 
    Clustering factor: 5224, ratio: 0.96 
    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: 5463 
    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: 158, 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.06, total records: 81974 
    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: 856 
    Data pages: 856, average fill: 66% 
    Primary pages: 856, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 851 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 851 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34576, depth: 2, leaf buckets: 104, nodes: 81974 
    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: 3010, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 103 
 
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.06, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.23 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 150.65, total records: 156516 
    Average version length: 138.99, total versions: 208, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 7, data page slots: 4280 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3870, secondary pages: 2, swept pages: 6 
    Empty pages: 30, full pages: 3832 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3832 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 148.87, total records: 143696 
    Average version length: 153.30, total versions: 2233, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 5872 
    Data pages: 3600, average fill: 82% 
    Primary pages: 3597, secondary pages: 3, swept pages: 3 
    Empty pages: 59, full pages: 3522 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 3522 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 133.99, total records: 202311 
    Average version length: 155.08, total versions: 24423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.66 
    Pointer pages: 8, data page slots: 7600 
    Data pages: 5128, average fill: 83% 
    Primary pages: 5127, secondary pages: 1, swept pages: 4 
    Empty pages: 126, full pages: 4955 
    Fill distribution: 
     0 - 19% = 130 
    20 - 39% = 12 
    40 - 59% = 20 
    60 - 79% = 10 
    80 - 99% = 4956 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.93, total records: 179573 
    Average version length: 152.21, total versions: 1980, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 8, data page slots: 5000 
    Data pages: 4448, average fill: 83% 
    Primary pages: 4445, secondary pages: 3, swept pages: 2 
    Empty pages: 22, full pages: 4415 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4415 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 119.38, total records: 209030 
    Average version length: 154.85, total versions: 46809, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.21 
    Pointer pages: 7, data page slots: 7248 
    Data pages: 5248, average fill: 85% 
    Primary pages: 5245, secondary pages: 3, swept pages: 5 
    Empty pages: 74, full pages: 5141 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 11 
    40 - 59% = 8 
    60 - 79% = 9 
    80 - 99% = 5140 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.23, total records: 163033 
    Average version length: 151.67, total versions: 1012, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 5112 
    Data pages: 4072, average fill: 82% 
    Primary pages: 4069, secondary pages: 3, swept pages: 1 
    Empty pages: 57, full pages: 3995 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3995 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 148.63, total records: 152125 
    Average version length: 152.87, total versions: 2559, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 7, data page slots: 5008 
    Data pages: 3800, average fill: 83% 
    Primary pages: 3797, secondary pages: 3, swept pages: 5 
    Empty pages: 55, full pages: 3726 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 3726 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 149.78, total records: 166595 
    Average version length: 152.97, total versions: 1667, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 6, data page slots: 5520 
    Data pages: 4176, average fill: 82% 
    Primary pages: 4173, secondary pages: 3, swept pages: 2 
    Empty pages: 75, full pages: 4086 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 4087 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 151.30, total records: 170073 
    Average version length: 137.54, total versions: 112, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.21 
    Pointer pages: 9, data page slots: 4768 
    Data pages: 4216, average fill: 83% 
    Primary pages: 4214, secondary pages: 2, swept pages: 3 
    Empty pages: 28, full pages: 4181 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4180 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 149.08, total records: 155660 
    Average version length: 152.39, total versions: 2295, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 6560 
    Data pages: 3896, average fill: 82% 
    Primary pages: 3895, secondary pages: 1, swept pages: 3 
    Empty pages: 62, full pages: 3815 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3814 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.35, total records: 2147034 
    Average version length: 52.96, total versions: 68387, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25952 
    Data pages: 25952, average fill: 72% 
    Primary pages: 25938, secondary pages: 14, swept pages: 8982 
    Empty pages: 54, full pages: 23955 
    Fill distribution: 
     0 - 19% = 123 
    20 - 39% = 162 
    40 - 59% = 491 
    60 - 79% = 24458 
    80 - 99% = 718 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2619, nodes: 2147034 
    Average node length: 5.44, total dup: 2004479, max dup: 1837 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185096, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 268 
        40 - 59% = 1737 
        60 - 79% = 308 
        80 - 99% = 302 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2147034 
    Average node length: 5.69, total dup: 1927935, max dup: 70 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 383374, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 2290 
        60 - 79% = 431 
        80 - 99% = 35 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2102, nodes: 2147034 
    Average node length: 4.96, total dup: 2146934, max dup: 28260 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182909, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 140 
        40 - 59% = 1072 
        60 - 79% = 396 
        80 - 99% = 491 
 
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: 38.86, total records: 155972 
    Average version length: 69.15, total versions: 78653, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 3, data page slots: 4712 
    Data pages: 3206, average fill: 60% 
    Primary pages: 3206, secondary pages: 0, swept pages: 479 
    Empty pages: 646, full pages: 2229 
    Fill distribution: 
     0 - 19% = 833 
    20 - 39% = 75 
    40 - 59% = 37 
    60 - 79% = 818 
    80 - 99% = 1443 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105879, depth: 3, leaf buckets: 224, nodes: 155972 
    Average node length: 6.46, total dup: 135790, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27279, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 105 
        60 - 79% = 68 
        80 - 99% = 19 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.63, total records: 7240332 
    Average version length: 68.82, total versions: 523014, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 66, data page slots: 106448 
    Data pages: 106448, average fill: 73% 
    Primary pages: 106448, secondary pages: 0, swept pages: 9939 
    Empty pages: 320, full pages: 100138 
    Fill distribution: 
     0 - 19% = 1324 
    20 - 39% = 1529 
    40 - 59% = 1609 
    60 - 79% = 99024 
    80 - 99% = 2962 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10682, nodes: 7240332 
    Average node length: 6.50, total dup: 6266561, max dup: 29 
    Average key length: 3.51, compression ratio: 11.96 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1705054, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1520 
        40 - 59% = 5542 
        60 - 79% = 2966 
        80 - 99% = 649 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8660, nodes: 7240332 
    Average node length: 5.39, total dup: 6955675, max dup: 167 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1498214, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1151 
        40 - 59% = 4797 
        60 - 79% = 1595 
        80 - 99% = 1108 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8730, nodes: 7240332 
    Average node length: 5.39, total dup: 6955675, max dup: 167 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1500575, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1247 
        40 - 59% = 4785 
        60 - 79% = 1584 
        80 - 99% = 1107 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.83, total records: 12295318 
    Average version length: 68.74, total versions: 429811, 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: 108, data page slots: 174864 
    Data pages: 174864, average fill: 75% 
    Primary pages: 174863, secondary pages: 1, swept pages: 46336 
    Empty pages: 1, full pages: 174721 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 13 
    60 - 79% = 171048 
    80 - 99% = 3799 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18417, nodes: 12289646 
    Average node length: 6.62, total dup: 10714659, max dup: 57 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2515802, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2054 
        40 - 59% = 10420 
        60 - 79% = 4976 
        80 - 99% = 942 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 36.47, total records: 1993148 
    Average version length: 69.11, total versions: 566233, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.46 
    Pointer pages: 31, data page slots: 48984 
    Data pages: 28200, average fill: 68% 
    Primary pages: 28035, secondary pages: 165, swept pages: 566 
    Empty pages: 5, full pages: 28059 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 5397 
    40 - 59% = 2253 
    60 - 79% = 12077 
    80 - 99% = 8407 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1841, nodes: 1476139 
    Average node length: 5.52, total dup: 1416455, max dup: 49 
    Average key length: 2.56, compression ratio: 16.40 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 100548, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 271 
        40 - 59% = 892 
        60 - 79% = 516 
        80 - 99% = 154 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 33.17, total records: 1587915 
    Average version length: 69.02, total versions: 188046, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.80 
    Pointer pages: 24, data page slots: 38136 
    Data pages: 29688, average fill: 40% 
    Primary pages: 29688, secondary pages: 0, swept pages: 6629 
    Empty pages: 6501, full pages: 17344 
    Fill distribution: 
     0 - 19% = 9415 
    20 - 39% = 3029 
    40 - 59% = 7108 
    60 - 79% = 9526 
    80 - 99% = 610 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1166, nodes: 827421 
    Average node length: 5.96, total dup: 760841, max dup: 79 
    Average key length: 3.03, compression ratio: 13.88 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 122551, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 234 
        40 - 59% = 554 
        60 - 79% = 332 
        80 - 99% = 45 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.08, total records: 9528865 
    Average version length: 68.97, total versions: 757757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 92, data page slots: 149432 
    Data pages: 149392, average fill: 69% 
    Primary pages: 149370, secondary pages: 22, swept pages: 30123 
    Empty pages: 468, full pages: 105799 
    Fill distribution: 
     0 - 19% = 1465 
    20 - 39% = 7149 
    40 - 59% = 19612 
    60 - 79% = 114162 
    80 - 99% = 7004 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13492, nodes: 9520657 
    Average node length: 6.70, total dup: 7898739, max dup: 14 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2131658, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1003 
        40 - 59% = 6331 
        60 - 79% = 5170 
        80 - 99% = 985 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21188465 
    Average version length: 82.96, total versions: 21108, 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: 197, data page slots: 320240 
    Data pages: 320240, average fill: 81% 
    Primary pages: 320237, secondary pages: 3, swept pages: 11895 
    Empty pages: 0, full pages: 320238 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 49179 
    80 - 99% = 271060 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19656, nodes: 21188465 
    Average node length: 5.72, total dup: 20706825, max dup: 144 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3291930, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8618 
        60 - 79% = 568 
        80 - 99% = 10463 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17221, nodes: 21188465 
    Average node length: 6.31, total dup: 18622017, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919652, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 3 
        40 - 59% = 815 
        60 - 79% = 275 
        80 - 99% = 16124 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21483, nodes: 21188465 
    Average node length: 6.35, total dup: 18539734, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3585568, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 8964 
        60 - 79% = 645 
        80 - 99% = 11866 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16152, nodes: 21188465 
    Average node length: 5.56, total dup: 21188365, max dup: 230079 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948434, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 16 
        40 - 59% = 2917 
        60 - 79% = 406 
        80 - 99% = 12811 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.52, total records: 10029010 
    Average version length: 82.64, total versions: 805036, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 109, data page slots: 176696 
    Data pages: 176648, average fill: 71% 
    Primary pages: 176610, secondary pages: 38, swept pages: 47278 
    Empty pages: 606, full pages: 117193 
    Fill distribution: 
     0 - 19% = 1731 
    20 - 39% = 7322 
    40 - 59% = 23352 
    60 - 79% = 111242 
    80 - 99% = 33001 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11400, nodes: 10029010 
    Average node length: 5.38, total dup: 9716868, max dup: 201 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2236683, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 85 
        40 - 59% = 7055 
        60 - 79% = 4153 
        80 - 99% = 105 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13925, nodes: 10029010 
    Average node length: 6.25, total dup: 8314327, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1564443, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 138 
        20 - 39% = 3806 
        40 - 59% = 4777 
        60 - 79% = 2636 
        80 - 99% = 2568 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12720, nodes: 10029010 
    Average node length: 5.99, total dup: 8714866, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2437627, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 88 
        40 - 59% = 8005 
        60 - 79% = 4463 
        80 - 99% = 163 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10486, nodes: 10029010 
    Average node length: 5.15, total dup: 10028910, max dup: 161084 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1601849, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1162 
        40 - 59% = 5426 
        60 - 79% = 1767 
        80 - 99% = 2092 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.39, total records: 11501862 
    Average version length: 82.57, total versions: 613165, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 120, data page slots: 195040 
    Data pages: 193624, average fill: 73% 
    Primary pages: 193450, secondary pages: 174, swept pages: 53668 
    Empty pages: 2714, full pages: 155288 
    Fill distribution: 
     0 - 19% = 4456 
    20 - 39% = 6132 
    40 - 59% = 14889 
    60 - 79% = 95595 
    80 - 99% = 72552 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13112, nodes: 11501862 
    Average node length: 5.30, total dup: 11391630, max dup: 638 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2409109, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 103 
        40 - 59% = 8580 
        60 - 79% = 4277 
        80 - 99% = 149 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10593, nodes: 11501862 
    Average node length: 5.50, total dup: 11001032, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 736240, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 152 
        20 - 39% = 871 
        40 - 59% = 2591 
        60 - 79% = 1815 
        80 - 99% = 5164 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14990, nodes: 11501862 
    Average node length: 6.02, total dup: 10042876, max dup: 70 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2425622, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 118 
        40 - 59% = 10049 
        60 - 79% = 4640 
        80 - 99% = 181 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10990, nodes: 11501862 
    Average node length: 5.22, total dup: 11501762, max dup: 190124 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 725191, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 839 
        40 - 59% = 4983 
        60 - 79% = 1512 
        80 - 99% = 3562 
 
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: 77.07, total records: 10116750 
    Average version length: 82.92, total versions: 777333, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 111, data page slots: 180608 
    Data pages: 180544, average fill: 70% 
    Primary pages: 180510, secondary pages: 34, swept pages: 50506 
    Empty pages: 660, full pages: 117314 
    Fill distribution: 
     0 - 19% = 1982 
    20 - 39% = 8734 
    40 - 59% = 26164 
    60 - 79% = 111866 
    80 - 99% = 31798 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12141, nodes: 10116750 
    Average node length: 5.20, total dup: 10087249, max dup: 2064 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2047870, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1419 
        40 - 59% = 8022 
        60 - 79% = 2010 
        80 - 99% = 649 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 14069, nodes: 10116750 
    Average node length: 6.27, total dup: 8386813, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1528303, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 199 
        20 - 39% = 3856 
        40 - 59% = 4695 
        60 - 79% = 2604 
        80 - 99% = 2715 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12782, nodes: 10116750 
    Average node length: 5.45, total dup: 9668067, max dup: 103 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2183530, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1369 
        40 - 59% = 8988 
        60 - 79% = 1807 
        80 - 99% = 596 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10639, nodes: 10116750 
    Average node length: 5.17, total dup: 10116650, max dup: 162747 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1622775, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1191 
        40 - 59% = 5561 
        60 - 79% = 1712 
        80 - 99% = 2128 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.17, total records: 586538 
    Average version length: 68.82, total versions: 10021, 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: 5, data page slots: 8120 
    Data pages: 8120, average fill: 76% 
    Primary pages: 8119, secondary pages: 1, swept pages: 2588 
    Empty pages: 0, full pages: 7889 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 6 
    40 - 59% = 35 
    60 - 79% = 7899 
    80 - 99% = 179 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 32244, depth: 3, leaf buckets: 744, nodes: 586538 
    Average node length: 5.95, total dup: 499614, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 103041, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 521 
        60 - 79% = 105 
        80 - 99% = 90 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26914, depth: 3, leaf buckets: 765, nodes: 586538 
    Average node length: 6.15, total dup: 481266, max dup: 29 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 103100, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 539 
        60 - 79% = 105 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 559, nodes: 586538 
    Average node length: 4.86, total dup: 586438, max dup: 9896 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 91622, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 315 
        60 - 79% = 69 
        80 - 99% = 147 
 
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 Tue Apr  2 10:09:30 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7838283 160756 1 0.0000 0.0000
DOC_LIST 2296081 84558 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1952 5 400.0000 0.0000
INVNT_TURNOVER_LOG 135966 105649 1 0.0000 0.0000
MONEY_SALDO 49 389 14 700.0000 0.0000
MONEY_TURNOVER_LOG 2421 2169 1 0.0000 0.0000
PDISTR 818787 38506 3 0.0000 0.0000
PERF_SPLIT_0 156516 208 1 0.0000 0.0000
PERF_SPLIT_1 143696 2233 1 0.0000 0.0000
PERF_SPLIT_2 202311 24423 1 0.0000 0.0000
PERF_SPLIT_3 179573 1980 1 0.0000 0.0000
PERF_SPLIT_4 209030 46809 1 0.0000 0.0000
PERF_SPLIT_5 163033 1012 1 0.0000 0.0000
PERF_SPLIT_6 152125 2559 1 0.0000 0.0000
PERF_SPLIT_7 166595 1667 1 0.0000 0.0000
PERF_SPLIT_8 170073 112 1 0.0000 0.0000
PERF_SPLIT_9 155660 2295 1 0.0000 0.0000
PSTORNED 2147034 68387 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 155972 78653 1 0.0000 0.0000
XQD_1000_3300 7240332 523014 1 0.0000 0.0000
XQD_1200_2000 12295318 429811 1 0.0000 0.0000
XQD_2000_3300 1993148 566233 1 0.0000 0.0000
XQD_2100_3300 1587915 188046 1 0.0000 0.0000
XQD_3300_3400 9528865 757757 1 0.0000 0.0000
XQS_1000_1200 21188465 21108 1 0.0000 0.0000
XQS_1000_3300 10029010 805036 1 0.0000 0.0000
XQS_1200_2000 11501862 613165 1 0.0000 0.0000
XQS_2100_3300 10116750 777333 1 0.0000 0.0000
XQS_3300_3400 586538 10021 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 ---
:47: 
:48: mscs-test-161.budzdorov.ru    Tue Apr  2 10:07:58 2024
:49:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:50: 
:51: 
:52: mscs-test-161.budzdorov.ru    Tue Apr  2 10:07:59 2024
:53:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:54: 
--- end of diff output ---

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

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