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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-29 19:10:12
DTS_END                         2024-02-29 19:09:43.5200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33634
TRN_ID                          173546
ATT_ID                          274
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: 9364.20 18196 936420
customer order: creation 182.22 397 18222
customer order: refuse 15.99 366 1599
order to supplier: creation 48.52 1279 4852
order to supplier: removal 3.67 93319 367
invoice (draft): creation 48.43 3055 4843
invoice (draft): removal 49.34 824 4934
invoice accept: apply 44.87 21098 4487
invoice accept: cancel 43.97 876 4397
customer reserve: creation 4308.99 202 430899
customer reserve: removal 4309.52 63 430952
realization accept: apply 86.99 167 8699
realization accept: cancel 85.72 130 8572
payment from customer: creation 63.34 110 6334
payment from customer: removal 6.18 76 618
payment to supplier: creation 50.41 153 5041
payment to supplier: removal 3.16 70 316
service: total inventory turnovers 5.02 1114 502
service: total monetary turnovers 6.95 27 695
service: aggregate perf. data 0.88 20143 88
service: refresh index statistics 0.03 220442 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-02-2024 19:10:40 to 29-02-2024 19:10:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1225
TEST_TIME 2 3932
TEST_TIME 3 3819
TEST_TIME 4 5013
TEST_TIME 5 5576
TEST_TIME 6 5520
TEST_TIME 7 5778
TEST_TIME 8 5837
TEST_TIME 9 5886
TEST_TIME 10 6408
TEST_TIME 11 6466
TEST_TIME 12 6624
TEST_TIME 13 6450
TEST_TIME 14 6607
TEST_TIME 15 6634
TEST_TIME 16 6772
TEST_TIME 17 7069
TEST_TIME 18 7116
TEST_TIME 19 7064
TEST_TIME 20 7404
TEST_TIME 21 7473
TEST_TIME 22 7582
TEST_TIME 23 7734
TEST_TIME 24 7692
TEST_TIME 25 7655
TEST_TIME 26 8118
TEST_TIME 27 9112
TEST_TIME 28 9182
TEST_TIME 29 9120
TEST_TIME 30 8988
TEST_TIME 31 9040
TEST_TIME 32 8873
TEST_TIME 33 8718
TEST_TIME 34 8976
TEST_TIME 35 8818
TEST_TIME 36 8798
TEST_TIME 37 8762
TEST_TIME 38 8863
TEST_TIME 39 8873
TEST_TIME 40 8850
TEST_TIME 41 8908
TEST_TIME 42 8815
TEST_TIME 43 8781
TEST_TIME 44 8869
TEST_TIME 45 9120
TEST_TIME 46 9063
TEST_TIME 47 9088
TEST_TIME 48 9058
TEST_TIME 49 9025
TEST_TIME 50 9085
TEST_TIME 51 9080
TEST_TIME 52 9253
TEST_TIME 53 9270
TEST_TIME 54 9308
TEST_TIME 55 9316
TEST_TIME 56 9269
TEST_TIME 57 9327
TEST_TIME 58 9192
TEST_TIME 59 9238
TEST_TIME 60 9132
TEST_TIME 61 9104
TEST_TIME 62 9169
TEST_TIME 63 9118
TEST_TIME 64 9050
TEST_TIME 65 9002
TEST_TIME 66 8905
TEST_TIME 67 8993
TEST_TIME 68 9044
TEST_TIME 69 9031
TEST_TIME 70 9032
TEST_TIME 71 9078
TEST_TIME 72 9162
TEST_TIME 73 9087
TEST_TIME 74 9223
TEST_TIME 75 9276
TEST_TIME 76 9360
TEST_TIME 77 9361
TEST_TIME 78 9357
TEST_TIME 79 9442
TEST_TIME 80 9415
TEST_TIME 81 9368
TEST_TIME 82 9326
TEST_TIME 83 9252
TEST_TIME 84 9241
TEST_TIME 85 9279
TEST_TIME 86 9232
TEST_TIME 87 9208
TEST_TIME 88 9184
TEST_TIME 89 9201
TEST_TIME 90 9174
TEST_TIME 91 9161
TEST_TIME 92 9204
TEST_TIME 93 9233
TEST_TIME 94 9270
TEST_TIME 95 9306
TEST_TIME 96 9317
TEST_TIME 97 9352
TEST_TIME 98 9370
TEST_TIME 99 9377
TEST_TIME 100 9367

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-02-2024 19:10:44 to 29-02-2024 19:10:47.

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 1330389 1330389 0 0.00 0 15655 7 0 0
doc_list_biud 1330386 1330386 0 0.00 0 54194 26 0 0
sp_add_invoice_to_stock 4585 4487 98 2.13 38 180096 21098 0 98
sp_cancel_adding_invoice 4397 4397 0 0.00 5 74438 877 0 0
sp_cancel_client_order 1599 1599 0 0.00 3 10986 367 0 0
sp_cancel_customer_reserve 430952 430952 0 0.00 0 54197 63 0 0
sp_cancel_pay_from_customer 618 618 0 0.00 3 4021 76 0 0
sp_cancel_pay_to_supplier 316 316 0 0.00 3 1521 70 0 0
sp_cancel_supplier_invoice 4943 4934 9 0.18 2 44575 825 0 9
sp_cancel_supplier_order 367 367 0 0.00 7 923606 93319 0 0
sp_cancel_write_off 8572 8572 0 0.00 1 11373 130 0 0
sp_client_order 18222 18222 0 0.00 3 42037 398 0 0
sp_customer_reserve 430899 430899 0 0.00 0 53523 202 0 0
sp_fill_shopping_cart 27904 27904 0 0.00 1 18580 31 0 0
sp_fill_shopping_cart_clo_res 430887 430887 0 0.00 0 10674 14 0 0
sp_get_clo_for_invoice 4474 4474 0 0.00 0 29684 289 0 0
sp_kill_cost_storno 13903 13903 0 0.00 0 5813 57 0 0
sp_kill_qstorno_ret_qs2qd 875777 875777 0 0.00 0 54186 34 0 0
sp_kill_qty_storno 463993 463993 0 0.00 0 54193 75 0 0
sp_lock_selected_doc 18259 18259 0 0.00 0 7085 5 0 0
sp_make_cost_storno 24548 24548 0 0.00 0 12937 56 0 0
sp_multiply_rows_for_pdistr 24547 24547 0 0.00 0 10089 25 0 0
sp_multiply_rows_for_qdistr 18222 18222 0 0.00 0 10720 164 0 0
sp_pay_from_customer 6334 6334 0 0.00 4 37987 110 0 0
sp_pay_to_supplier 5041 5041 0 0.00 4 38387 153 0 0
sp_payment_common 11373 11373 0 0.00 2 17139 27 0 0
sp_qd_handle_on_cancel_clo 1599 1599 0 0.00 0 10976 345 0 0
sp_qd_handle_on_invoice_upd_sts 8871 8871 0 0.00 0 47297 365 0 0
sp_qd_handle_on_reserve_upd_sts 8698 8698 0 0.00 0 15580 59 0 0
sp_reserve_write_off 8699 8699 0 0.00 6 15606 168 0 0
sp_supplier_invoice 4843 4843 0 0.00 6 70454 3056 0 0
sp_supplier_order 4852 4852 0 0.00 5 62035 1279 0 0
srv_aggregate_perf_data 88 88 0 0.00 1606 165659 20143 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1859 137859 38557 0 0
srv_find_qd_qs_mism 891045 891045 0 0.00 0 15654 7 0 0
srv_make_invnt_saldo 502 502 0 0.00 46 40800 1114 0 0
srv_make_money_saldo 695 695 0 0.00 1 881 27 0 0
srv_recalc_idx_stat 3 3 0 0.00 153663 314671 220442 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4487 4487 0 0.00 0 10947 179 0 0
t$perf-norm:sp_cancel_adding_invoice 339 339 0 0.00 0 1882 91 0 0
t$perf-norm:sp_cancel_client_order 1599 1599 0 0.00 0 3773 14 0 0
t$perf-norm:sp_cancel_customer_reserve 621 621 0 0.00 0 2107 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 618 618 0 0.00 0 1477 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 316 316 0 0.00 0 512 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 373 373 0 0.00 0 865 14 0 0
t$perf-norm:sp_cancel_supplier_order 367 367 0 0.00 0 20166 1465 0 0
t$perf-norm:sp_cancel_write_off 858 858 0 0.00 0 2205 11 0 0
t$perf-norm:sp_client_order 18222 18222 0 0.00 0 6731 15 0 0
t$perf-norm:sp_customer_reserve 887 887 0 0.00 0 5493 15 0 0
t$perf-norm:sp_pay_from_customer 6334 6334 0 0.00 0 7083 10 0 0
t$perf-norm:sp_pay_to_supplier 5041 5041 0 0.00 0 4204 10 0 0
t$perf-norm:sp_reserve_write_off 8699 8699 0 0.00 0 8872 15 0 0
t$perf-norm:sp_supplier_invoice 4843 4843 0 0.00 0 8207 18 0 0
t$perf-norm:sp_supplier_order 4852 4852 0 0.00 0 4658 18 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 208 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 43 2 0 0
t$perf-norm:srv_make_invnt_saldo 502 502 0 0.00 0 1226 24 0 0
t$perf-norm:srv_make_money_saldo 695 695 0 0.00 0 6404 34 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 2 2 0 0
v_add_invoice_to_stock 9136 8940 196 2.14 0 6809 18 0 196
v_all_customers 33918 33918 0 0.00 0 139 1 0 0
v_all_suppliers 27294 27294 0 0.00 0 18 1 0 0
v_all_wares 36444 36444 0 0.00 0 78 1 0 0
v_cancel_adding_invoice 678 678 0 0.00 0 1078 7 0 0
v_cancel_client_order 3198 3198 0 0.00 0 2224 4 0 0
v_cancel_customer_prepayment 1236 1236 0 0.00 0 3963 10 0 0
v_cancel_customer_reserve 1242 1242 0 0.00 0 3494 9 0 0
v_cancel_payment_to_supplier 632 632 0 0.00 0 1108 6 0 0
v_cancel_supplier_invoice 764 746 18 2.35 0 6529 23 0 18
v_cancel_supplier_order 734 734 0 0.00 0 507 3 0 0
v_cancel_write_off 1716 1716 0 0.00 0 6198 21 0 0
v_max_id_clo_ord 4844 4844 0 0.00 0 363 1 0 0
v_max_id_clo_res 887 887 0 0.00 0 8174 38 0 0
v_max_id_ord_sup 4836 4836 0 0.00 0 3573 5 0 0
v_max_non_paid_invoice 1073 1073 0 0.00 0 236 2 0 0
v_max_non_paid_realizn 3061 3061 0 0.00 0 6380 8 0 0
v_min_id_clo_ord 4844 4844 0 0.00 0 6029 6 0 0
v_min_id_clo_res 887 887 0 0.00 0 5527 8 0 0
v_min_id_ord_sup 4836 4836 0 0.00 0 2252 3 0 0
v_min_non_paid_invoice 5040 5040 0 0.00 0 9222 18 0 0
v_min_non_paid_realizn 6332 6332 0 0.00 0 17134 20 0 0
v_our_firm 9070 9070 0 0.00 0 89 1 0 0
v_reserve_write_off 17396 17396 0 0.00 0 3397 5 0 0
x_lock_depdocs_on_canc_invoice 8958 8958 0 0.00 0 10930 133 0 0
x_lock_depdocs_on_canc_sup_ord 367 367 0 0.00 0 2536 289 0 0
x_make_qstorno_1000_1200 4852 4852 0 0.00 2 61963 1205 0 0
x_make_qstorno_1200_2000 4843 4843 0 0.00 3 70441 2947 0 0
x_make_qstorno_2100_3300 430899 430899 0 0.00 0 53521 185 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-02-2024 19:10:48 to 29-02-2024 19:10:52.

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
17:09:46 4 8192000000 8805299744 8818819072 10772464 0.131 3 3 4 0 10956368 76800 107104
17:10:47 39407 8192000000 9893285408 10198802432 973188032 10.618 100 88 174 1 1001833632 5776048 22869552
17:12:30 18190 8192000000 9952456304 10275901440 1036635936 11.232 100 88 176 1 1066086000 7125088 22324976
17:13:54 15010 8192000000 9983777568 10314362880 1068864960 11.541 100 86 172 0 1099608208 9053168 21690080
17:15:11 13098 8192000000 10032149440 10373873664 1112585936 11.957 100 81 162 0 1142551632 10508432 19457264
17:16:34 7157 8192000000 10073508048 10427998208 1155353584 12.360 100 81 162 0 1186961008 13123376 18484048
17:17:48 4011 8192000000 10118759232 10483826688 1206087648 12.833 100 78 153 0 1237087904 13947472 17052784
17:18:54 1665 8192000000 10150391520 10522574848 1238395632 13.131 100 83 166 1 1270197856 13618112 18184112
17:19:57 1579 8192000000 10182800528 10563579904 1269086368 13.413 100 84 165 1 1299064480 12472896 17505216
17:21:01 713 8192000000 10212577216 10597015552 1301778432 13.711 100 87 174 1 1333144496 12514144 18851920
17:22:03 15120 8192000000 10214794960 10616672256 1309946784 13.786 100 66 132 0 1337048176 12959808 14141584
17:23:21 3765 8192000000 10219055920 10628935680 1322845488 13.902 100 47 93 0 1342303296 9537952 9919856
17:24:26 49141 8192000000 10231661328 10643128320 1334491936 14.008 100 36 71 1 1348466992 5326224 8648832
17:26:17 5256 8192000000 10228359712 10650189824 1342339040 14.078 100 38 74 0 1358969184 7488592 9141552
17:27:23 6092 8192000000 10235536912 10654470144 1347234016 14.123 100 22 42 1 1357419424 5927504 4257904
17:28:35 43626 8192000000 10243039744 10661347328 1338114352 14.040 99 34 66 1 1351973504 4832688 9026464
17:30:25 51076 8192000000 10259946576 10675851264 1354330688 14.186 100 43 86 1 1372365632 8619888 9415056
17:32:33 37685 8192000000 10262684928 10678730752 1358035424 14.220 100 48 96 0 1383003408 14213056 10754928
17:34:21 7828 8192000000 10281955552 10695962624 1366838592 14.299 100 58 117 0 1398503552 18139520 13525440
17:35:35 5632 8192000000 10269072624 10680291328 1355119696 14.194 100 50 98 0 1380995808 14314416 11561696
17:36:45 6121 8192000000 10254301344 10664599552 1327515776 13.945 98 54 108 0 1354481552 14750160 12215616
17:37:56 5068 8192000000 10254370704 10663079936 1325271648 13.924 99 54 108 1 1356660672 18210400 13178624
17:39:07 28326 8192000000 10267809056 10681454592 1342479568 14.080 99 46 92 1 1369462320 16524688 10458064
17:40:52 6037 8192000000 10258514656 10664218624 1325185712 13.924 98 51 102 1 1353476976 15617200 12674064
17:42:03 8880 8192000000 10251885088 10657980416 1332882384 13.993 100 48 96 2 1366898528 22715232 11300912
17:43:16 4626 8192000000 10281640528 10687897600 1349278112 14.141 100 54 109 0 1387541936 25364784 12899040
17:44:25 7879 8192000000 10282489344 10690220032 1352833248 14.173 100 56 112 0 1394189696 27824928 13531520
17:45:36 3131 8192000000 10307654848 10705113088 1364643392 14.279 100 76 151 0 1409137376 26570832 17923152
17:46:44 6242 8192000000 10288403344 10699481088 1356872576 14.209 99 67 131 0 1398397584 25704656 15820352
17:47:56 6310 8192000000 10294032000 10704429056 1369932448 14.326 100 56 112 0 1407549552 24139200 13477904
17:49:08 1858 8192000000 10338603152 10746454016 1390333136 14.509 100 84 168 1 1442813728 32250976 20229616
17:50:13 10840 8192000000 10343854480 10756124672 1400693776 14.601 100 69 139 0 1446072032 27209392 18168864
17:51:29 14439 8192000000 10333769632 10761068544 1397100448 14.569 100 56 113 0 1443029312 32051264 13877600
17:52:52 13062 8192000000 10344295408 10773889024 1409703488 14.681 100 29 58 1 1452142608 34875936 7563184
17:54:09 8799 8192000000 10328409440 10765074432 1392995040 14.533 100 30 60 1 1439346912 37752656 8599216
17:55:56 35653 8192000000 10315203408 10770157568 1385402688 14.465 100 24 47 0 1433165168 41451296 6311184
17:57:33 28612 8192000000 10298538320 10732351488 1381627472 14.431 100 36 72 1 1397679568 7193952 8858144
17:59:16 67854 8192000000 10300645760 10751811584 1386517744 14.475 100 44 88 0 1405833984 9027920 10288320
18:01:32 137859 8192000000 10314492832 10779090944 1385162960 14.463 99 29 58 0 1404658192 13140544 6354688
18:04:53 23744 8192000000 10313135856 10761678848 1390862096 14.514 99 30 61 0 1406786736 9168544 6756096
18:06:34 20318 8192000000 10344714656 10788253696 1421812096 14.789 100 44 89 0 1445180448 12742976 10625376
18:07:59 19014 8192000000 10332470784 10793271296 1419341072 14.767 100 15 30 0 1439008048 15734128 3932848
18:09:22 15106 8192000000 10343547792 10796257280 1426011920 14.826 100 36 72 1 1448429824 13242192 9175712
18:11:16 45482 8192000000 10341648336 10805878784 1436335696 14.917 100 23 46 0 1458238304 16335984 5566624
18:13:08 8735 8192000000 10344703504 10810486784 1435135568 14.907 100 24 48 0 1456575408 16280912 5158928
18:14:18 51582 8192000000 10336256272 10798063616 1425188512 14.819 100 14 28 0 1449396368 20409584 3798272
18:16:13 27670 8192000000 10335380880 10790191104 1420246848 14.775 100 37 74 0 1439189472 10335952 8606672
18:17:44 26851 8192000000 10305107232 10753081344 1358246752 14.222 96 34 68 1 1375139104 9153904 7738448
18:19:16 32534 8192000000 10317400944 10771046400 1393323056 14.536 99 20 40 1 1410838400 12799072 4716272
18:20:49 51438 8192000000 10292197904 10745008128 1355151456 14.194 97 21 42 0 1373530768 13408368 4970944
18:22:51 85694 8192000000 10268525584 10717491200 1296530464 13.664 94 15 30 0 1317423744 17234512 3658768
18:25:18 47021 8192000000 10271448288 10699833344 1311487264 13.800 96 36 72 0 1329366048 9396304 8482480
18:27:06 127847 8192000000 10250755088 10704748544 1313494512 13.818 97 30 61 0 1333913280 13312496 7106272
18:30:26 12231 8192000000 10244732560 10677780480 1328069328 13.950 98 38 76 0 1345823232 9532032 8221872
18:32:05 32187 8192000000 10211354480 10658635776 1313023792 13.813 99 13 26 0 1322452560 6812000 2616768
18:33:37 64681 8192000000 10242181312 10687057920 1316944640 13.849 98 14 28 0 1329041984 8828880 3268464
18:35:44 65859 8192000000 10243266384 10695401472 1319557472 13.873 98 16 32 0 1334039392 10778320 3703600
18:38:54 43085 8192000000 10252745104 10699386880 1291084400 13.614 95 10 20 0 1302352176 9181856 2085920
18:40:38 78995 8192000000 10281010944 10736377856 1368471088 14.313 100 22 44 1 1394534688 20907472 5156128
18:43:29 128714 8192000000 10273556304 10736640000 1287876416 13.585 94 11 22 0 1305112384 14808464 2427504
18:46:45 83495 8192000000 10291832832 10738491392 1345763152 14.109 98 23 46 1 1366855840 16143856 4948832
18:49:10 49657 8192000000 10311580384 10749169664 1380248544 14.419 100 26 52 0 1396525856 10505376 5771936
18:51:01 88784 8192000000 10292243360 10742517760 1375010800 14.372 99 26 52 0 1389155296 8094064 6050432
18:54:11 38189 8192000000 10283749728 10746888192 1396281664 14.562 100 30 59 1 1410094176 7627440 6185072
18:55:54 38610 8192000000 10296753936 10760212480 1405338992 14.643 100 6 12 0 1413105600 6473600 1293008
18:57:34 60837 8192000000 10298671920 10755375104 1393675712 14.539 99 15 30 0 1405347072 8379872 3291488
18:59:39 14982 8192000000 10294067472 10745724928 1371230128 14.338 98 26 51 0 1383245296 5972544 6042624
19:00:59 52109 8192000000 10280481792 10741944320 1352083616 14.166 97 17 34 0 1365046016 9122544 3839856
19:02:52 74570 8192000000 10298662608 10758111232 1388683792 14.494 100 22 45 0 1405459280 11973920 4801568
19:05:08 36282 8192000000 10298790992 10738987008 1350500608 14.152 97 37 74 1 1367101248 8586048 8014592
19:06:45 64360 8192000000 10283135200 10733043712 1333412592 13.998 96 12 24 0 1346255904 10028272 2815040
19:08:50 44654 8192000000 10293974416 10747252736 1375267504 14.374 100 25 50 0 1396587232 16249232 5070496

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 29-02-2024 19:10:54 to 29-02-2024 19:11:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-02-2024 19:11:09 to 29-02-2024 19:11:11.

Content of mon$database and FB version 


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


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Feb 29 19:11:12 2024 
 
Database header page information: 
    Flags            0 
    Generation        97645 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    183567 
    Oldest active        183568 
    Oldest snapshot        183568 
    Next transaction    183569 
    Sequence number        0 
    Next attachment ID    706 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.08, total records: 7837690 
    Average version length: 48.15, total versions: 133208, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86552 
    Data pages: 86552, average fill: 72% 
    Primary pages: 86552, secondary pages: 0, swept pages: 11757 
    Empty pages: 1, full pages: 79881 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 63 
    40 - 59% = 1569 
    60 - 79% = 84864 
    80 - 99% = 51 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23383, nodes: 7837690 
    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: 1775109, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 325 
        20 - 39% = 1505 
        40 - 59% = 4395 
        60 - 79% = 2282 
        80 - 99% = 14876 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13588, nodes: 7837690 
    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: 1596644, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1399 
        40 - 59% = 2214 
        60 - 79% = 1097 
        80 - 99% = 8878 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8380, nodes: 7837690 
    Average node length: 6.64, total dup: 5834628, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1589606, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 818 
        40 - 59% = 1512 
        60 - 79% = 889 
        80 - 99% = 5039 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.70, total records: 2293026 
    Average version length: 34.49, total versions: 140193, max versions: 3 
    Average fragment length: 6.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28240 
    Data pages: 28240, average fill: 76% 
    Primary pages: 28235, secondary pages: 5, swept pages: 6583 
    Empty pages: 3, full pages: 24804 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 52 
    40 - 59% = 610 
    60 - 79% = 25565 
    80 - 99% = 1997 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4611, nodes: 2293026 
    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: 719771, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 876 
        40 - 59% = 924 
        60 - 79% = 673 
        80 - 99% = 2138 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2538, nodes: 2296102 
    Average node length: 4.97, total dup: 2295203, max dup: 18912 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1270372, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 251 
        40 - 59% = 1519 
        60 - 79% = 556 
        80 - 99% = 210 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2041, nodes: 2293026 
    Average node length: 4.97, total dup: 2292976, max dup: 130331 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1066930, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 4 
        40 - 59% = 1156 
        60 - 79% = 64 
        80 - 99% = 812 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4398, nodes: 2293026 
    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: 719771, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 571 
        40 - 59% = 669 
        60 - 79% = 769 
        80 - 99% = 2292 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.23, total records: 400 
    Average version length: 23.14, total versions: 236454, max versions: 619 
    Average fragment length: 2.00, total fragments: 58, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1328, average fill: 89% 
    Primary pages: 14, secondary pages: 1314, swept pages: 0 
    Empty pages: 7, full pages: 1320 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1319 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 16.44, total records: 68460 
    Average version length: 68.29, total versions: 51981, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.35 
    Pointer pages: 7, data page slots: 2496 
    Data pages: 1176, average fill: 71% 
    Primary pages: 1175, secondary pages: 1, swept pages: 0 
    Empty pages: 49, full pages: 764 
    Fill distribution: 
     0 - 19% = 112 
    20 - 39% = 68 
    40 - 59% = 109 
    60 - 79% = 263 
    80 - 99% = 624 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1690410, depth: 3, leaf buckets: 230, nodes: 68460 
    Average node length: 13.20, total dup: 4572, max dup: 2 
    Average key length: 10.76, compression ratio: 2.51 
    Average prefix length: 19.17, average data length: 7.83 
    Clustering factor: 50119, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 67 
        40 - 59% = 126 
        60 - 79% = 32 
        80 - 99% = 5 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 19199, max versions: 978 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 86% 
    Primary pages: 3, secondary pages: 69, swept pages: 0 
    Empty pages: 2, full pages: 69 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 14 
    80 - 99% = 55 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 6.18, total records: 1092 
    Average version length: 43.37, total versions: 940, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 9.39 
    Pointer pages: 1, data page slots: 24 
    Data pages: 20, average fill: 52% 
    Primary pages: 20, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 7 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 8 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 89432, depth: 2, leaf buckets: 2, nodes: 1092 
    Average node length: 4.56, total dup: 994, max dup: 131 
    Average key length: 2.95, compression ratio: 6.44 
    Average prefix length: 18.14, average data length: 0.86 
    Clustering factor: 586, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.04, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.64, total records: 810882 
    Average version length: 25.32, total versions: 87228, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 5, data page slots: 8112 
    Data pages: 8112, average fill: 70% 
    Primary pages: 8087, secondary pages: 25, swept pages: 956 
    Empty pages: 52, full pages: 7182 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 92 
    40 - 59% = 198 
    60 - 79% = 7386 
    80 - 99% = 331 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 887, nodes: 810882 
    Average node length: 4.87, total dup: 810833, max dup: 148507 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90961, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 108 
        40 - 59% = 504 
        60 - 79% = 218 
        80 - 99% = 57 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 983, nodes: 810882 
    Average node length: 5.88, total dup: 721739, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161061, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 122 
        40 - 59% = 482 
        60 - 79% = 138 
        80 - 99% = 241 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1021, nodes: 810882 
    Average node length: 5.88, total dup: 721739, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163129, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 202 
        40 - 59% = 448 
        60 - 79% = 127 
        80 - 99% = 244 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1147, nodes: 810882 
    Average node length: 5.96, total dup: 721739, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155900, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 245 
        40 - 59% = 612 
        60 - 79% = 194 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5451 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.04, total fragments: 74, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 74, secondary pages: 22, swept pages: 54 
    Empty pages: 12, full pages: 61 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5451 
    Average node length: 5.46, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.39, average data length: 1.54 
    Clustering factor: 5157, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5451 
    Average node length: 11.09, 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: 130, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.19, total records: 79985 
    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.22 
    Pointer pages: 1, data page slots: 776 
    Data pages: 776, average fill: 71% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 771 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 771 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32396, depth: 2, leaf buckets: 101, nodes: 79985 
    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: 3191, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.71, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.27 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 148.17, total records: 151453 
    Average version length: 152.75, total versions: 2876, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 6, data page slots: 4016 
    Data pages: 3640, average fill: 86% 
    Primary pages: 3640, secondary pages: 0, swept pages: 3 
    Empty pages: 43, full pages: 3581 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3581 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 138.11, total records: 162813 
    Average version length: 154.66, total versions: 13812, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.28 
    Pointer pages: 6, data page slots: 5560 
    Data pages: 3936, average fill: 86% 
    Primary pages: 3936, secondary pages: 0, swept pages: 2 
    Empty pages: 61, full pages: 3852 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 3852 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.20, total records: 156220 
    Average version length: 153.23, total versions: 4123, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 6, data page slots: 7000 
    Data pages: 3808, average fill: 85% 
    Primary pages: 3808, secondary pages: 0, swept pages: 5 
    Empty pages: 89, full pages: 3694 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 3695 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.81, total records: 155212 
    Average version length: 152.68, total versions: 4658, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 6, data page slots: 4984 
    Data pages: 3736, average fill: 86% 
    Primary pages: 3735, secondary pages: 1, swept pages: 2 
    Empty pages: 40, full pages: 3679 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 3679 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 135.56, total records: 153641 
    Average version length: 154.65, total versions: 15936, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.51 
    Pointer pages: 7, data page slots: 4904 
    Data pages: 3744, average fill: 86% 
    Primary pages: 3743, secondary pages: 1, swept pages: 1 
    Empty pages: 75, full pages: 3641 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 3642 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.66, total records: 145249 
    Average version length: 152.81, total versions: 2996, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 8, data page slots: 3936 
    Data pages: 3496, average fill: 86% 
    Primary pages: 3496, secondary pages: 0, swept pages: 2 
    Empty pages: 51, full pages: 3430 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 7 
    80 - 99% = 3431 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.03, total records: 169824 
    Average version length: 152.48, total versions: 2798, 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: 4656 
    Data pages: 4112, average fill: 85% 
    Primary pages: 4112, secondary pages: 0, swept pages: 1 
    Empty pages: 64, full pages: 4027 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 4027 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 144.83, total records: 151436 
    Average version length: 153.56, total versions: 6268, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 6, data page slots: 5240 
    Data pages: 3656, average fill: 86% 
    Primary pages: 3656, secondary pages: 0, swept pages: 2 
    Empty pages: 53, full pages: 3582 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 3584 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 142.10, total records: 164203 
    Average version length: 154.90, total versions: 10074, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 8, data page slots: 4488 
    Data pages: 3928, average fill: 87% 
    Primary pages: 3928, secondary pages: 0, swept pages: 3 
    Empty pages: 17, full pages: 3900 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3900 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.13, total records: 164670 
    Average version length: 152.89, total versions: 3516, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 6, data page slots: 4752 
    Data pages: 3968, average fill: 86% 
    Primary pages: 3968, secondary pages: 0, swept pages: 2 
    Empty pages: 46, full pages: 3898 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 3900 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.30, total records: 2128754 
    Average version length: 52.95, total versions: 58660, 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: 25512 
    Data pages: 25504, average fill: 72% 
    Primary pages: 25504, secondary pages: 0, swept pages: 8631 
    Empty pages: 282, full pages: 22632 
    Fill distribution: 
     0 - 19% = 511 
    20 - 39% = 355 
    40 - 59% = 752 
    60 - 79% = 23337 
    80 - 99% = 549 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2592, nodes: 2128754 
    Average node length: 5.44, total dup: 1988235, max dup: 1208 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 184250, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 270 
        40 - 59% = 1684 
        60 - 79% = 330 
        80 - 99% = 304 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2128754 
    Average node length: 5.69, total dup: 1911548, max dup: 68 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 380794, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2354 
        60 - 79% = 366 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2158, nodes: 2128754 
    Average node length: 4.96, total dup: 2128654, max dup: 27608 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181449, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 175 
        40 - 59% = 1154 
        60 - 79% = 408 
        80 - 99% = 418 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.99, total records: 168275 
    Average version length: 69.19, total versions: 78355, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.41 
    Pointer pages: 3, data page slots: 4232 
    Data pages: 3384, average fill: 58% 
    Primary pages: 3384, secondary pages: 0, swept pages: 521 
    Empty pages: 729, full pages: 2196 
    Fill distribution: 
     0 - 19% = 940 
    20 - 39% = 60 
    40 - 59% = 50 
    60 - 79% = 848 
    80 - 99% = 1486 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1552259, depth: 3, leaf buckets: 248, nodes: 168275 
    Average node length: 6.47, total dup: 146268, max dup: 14 
    Average key length: 3.92, compression ratio: 10.70 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 28806, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 24 
        40 - 59% = 146 
        60 - 79% = 65 
        80 - 99% = 12 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.19, total records: 7113003 
    Average version length: 68.82, total versions: 594980, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.99 
    Pointer pages: 63, data page slots: 102040 
    Data pages: 102040, average fill: 75% 
    Primary pages: 102040, secondary pages: 0, swept pages: 12669 
    Empty pages: 19, full pages: 85573 
    Fill distribution: 
     0 - 19% = 268 
    20 - 39% = 1351 
    40 - 59% = 5755 
    60 - 79% = 82855 
    80 - 99% = 11811 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10691, nodes: 7113003 
    Average node length: 6.51, total dup: 6153650, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1583463, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1510 
        40 - 59% = 5889 
        60 - 79% = 2825 
        80 - 99% = 459 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8628, nodes: 7113003 
    Average node length: 5.40, total dup: 6828919, max dup: 175 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1383142, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1238 
        40 - 59% = 4896 
        60 - 79% = 1446 
        80 - 99% = 1038 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8665, nodes: 7113003 
    Average node length: 5.40, total dup: 6828919, max dup: 175 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1385779, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1297 
        40 - 59% = 4828 
        60 - 79% = 1487 
        80 - 99% = 1046 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.25, total records: 12222361 
    Average version length: 68.74, total versions: 479465, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 103, data page slots: 167288 
    Data pages: 167288, average fill: 78% 
    Primary pages: 167288, secondary pages: 0, swept pages: 57456 
    Empty pages: 10, full pages: 166951 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 12 
    40 - 59% = 65 
    60 - 79% = 154866 
    80 - 99% = 12332 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18445, nodes: 12222361 
    Average node length: 6.59, total dup: 10653324, max dup: 78 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2396408, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1814 
        40 - 59% = 11126 
        60 - 79% = 4806 
        80 - 99% = 675 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 31.48, total records: 1892598 
    Average version length: 69.11, total versions: 1031170, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.00 
    Pointer pages: 26, data page slots: 41008 
    Data pages: 27024, average fill: 82% 
    Primary pages: 27024, secondary pages: 0, swept pages: 1558 
    Empty pages: 628, full pages: 25198 
    Fill distribution: 
     0 - 19% = 896 
    20 - 39% = 348 
    40 - 59% = 300 
    60 - 79% = 7853 
    80 - 99% = 17627 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2146, nodes: 1892598 
    Average node length: 5.51, total dup: 1816873, max dup: 99 
    Average key length: 2.54, compression ratio: 16.53 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 126203, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 127 
        40 - 59% = 988 
        60 - 79% = 703 
        80 - 99% = 316 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 36.38, total records: 1124462 
    Average version length: 69.13, total versions: 531694, 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: 20, data page slots: 31664 
    Data pages: 26984, average fill: 49% 
    Primary pages: 26984, secondary pages: 0, swept pages: 4040 
    Empty pages: 5017, full pages: 13286 
    Fill distribution: 
     0 - 19% = 9718 
    20 - 39% = 1865 
    40 - 59% = 992 
    60 - 79% = 5800 
    80 - 99% = 8609 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1523, nodes: 1124462 
    Average node length: 5.76, total dup: 1052776, max dup: 99 
    Average key length: 2.83, compression ratio: 14.85 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 144387, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 292 
        40 - 59% = 757 
        60 - 79% = 391 
        80 - 99% = 80 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.22, total records: 9608352 
    Average version length: 68.96, total versions: 652425, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 88, data page slots: 142040 
    Data pages: 142024, average fill: 72% 
    Primary pages: 142023, secondary pages: 1, swept pages: 31329 
    Empty pages: 247, full pages: 107281 
    Fill distribution: 
     0 - 19% = 697 
    20 - 39% = 4042 
    40 - 59% = 16487 
    60 - 79% = 105006 
    80 - 99% = 15792 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13487, nodes: 9608352 
    Average node length: 6.67, total dup: 7971853, max dup: 27 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2099623, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 821 
        40 - 59% = 6367 
        60 - 79% = 5431 
        80 - 99% = 867 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21158209 
    Average version length: 82.92, total versions: 20997, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318832 
    Data pages: 318832, average fill: 81% 
    Primary pages: 318832, secondary pages: 0, swept pages: 12536 
    Empty pages: 23, full pages: 318357 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 17 
    40 - 59% = 71 
    60 - 79% = 27321 
    80 - 99% = 291389 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19298, nodes: 21158209 
    Average node length: 5.72, total dup: 20677126, max dup: 140 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3283368, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1 
        40 - 59% = 7927 
        60 - 79% = 591 
        80 - 99% = 10768 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17191, nodes: 21158209 
    Average node length: 6.31, total dup: 18594475, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916429, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 812 
        60 - 79% = 272 
        80 - 99% = 16103 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21074, nodes: 21158209 
    Average node length: 6.35, total dup: 18513051, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577582, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 8225 
        60 - 79% = 613 
        80 - 99% = 12233 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16107, nodes: 21158209 
    Average node length: 5.56, total dup: 21158109, max dup: 230818 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945048, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2870 
        60 - 79% = 408 
        80 - 99% = 12817 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.09, total records: 10055228 
    Average version length: 82.62, total versions: 650454, 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: 104, data page slots: 168864 
    Data pages: 168824, average fill: 74% 
    Primary pages: 168824, secondary pages: 0, swept pages: 50412 
    Empty pages: 275, full pages: 118142 
    Fill distribution: 
     0 - 19% = 899 
    20 - 39% = 4420 
    40 - 59% = 18858 
    60 - 79% = 61490 
    80 - 99% = 83157 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11367, nodes: 10055228 
    Average node length: 5.35, total dup: 9743940, max dup: 203 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2224073, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 23 
        40 - 59% = 7256 
        60 - 79% = 3928 
        80 - 99% = 158 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13831, nodes: 10055228 
    Average node length: 6.22, total dup: 8337312, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1564986, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 3932 
        40 - 59% = 4532 
        60 - 79% = 2562 
        80 - 99% = 2693 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12689, nodes: 10055228 
    Average node length: 5.96, total dup: 8738857, max dup: 53 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2427357, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 8184 
        60 - 79% = 4275 
        80 - 99% = 197 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10367, nodes: 10055228 
    Average node length: 5.13, total dup: 10055128, max dup: 150684 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1585118, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1113 
        40 - 59% = 5211 
        60 - 79% = 1781 
        80 - 99% = 2221 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.59, total records: 11494339 
    Average version length: 82.56, total versions: 518537, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 118, data page slots: 192568 
    Data pages: 191264, average fill: 74% 
    Primary pages: 191264, secondary pages: 0, swept pages: 60886 
    Empty pages: 2980, full pages: 149395 
    Fill distribution: 
     0 - 19% = 4950 
    20 - 39% = 6572 
    40 - 59% = 15587 
    60 - 79% = 39095 
    80 - 99% = 125060 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13124, nodes: 11494339 
    Average node length: 5.30, total dup: 11384398, max dup: 643 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2395927, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 56 
        40 - 59% = 8836 
        60 - 79% = 4076 
        80 - 99% = 156 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10506, nodes: 11494339 
    Average node length: 5.49, total dup: 10993808, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 718751, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 135 
        20 - 39% = 808 
        40 - 59% = 2572 
        60 - 79% = 1774 
        80 - 99% = 5217 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15018, nodes: 11494339 
    Average node length: 6.02, total dup: 10036313, max dup: 82 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2412431, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 67 
        40 - 59% = 10395 
        60 - 79% = 4384 
        80 - 99% = 169 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10824, nodes: 11494339 
    Average node length: 5.22, total dup: 11494239, max dup: 184390 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 707057, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 831 
        40 - 59% = 4665 
        60 - 79% = 1490 
        80 - 99% = 3737 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 77.58, total records: 10155287 
    Average version length: 82.91, total versions: 633681, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 107, data page slots: 173040 
    Data pages: 172984, average fill: 73% 
    Primary pages: 172984, secondary pages: 0, swept pages: 54364 
    Empty pages: 289, full pages: 114707 
    Fill distribution: 
     0 - 19% = 953 
    20 - 39% = 4905 
    40 - 59% = 22209 
    60 - 79% = 65432 
    80 - 99% = 79485 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12153, nodes: 10155287 
    Average node length: 5.17, total dup: 10126113, max dup: 2176 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2039697, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1424 
        40 - 59% = 8069 
        60 - 79% = 1976 
        80 - 99% = 651 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13997, nodes: 10155287 
    Average node length: 6.24, total dup: 8419644, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1516603, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 195 
        20 - 39% = 3978 
        40 - 59% = 4444 
        60 - 79% = 2590 
        80 - 99% = 2790 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12747, nodes: 10155287 
    Average node length: 5.43, total dup: 9705996, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2174466, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1303 
        40 - 59% = 9029 
        60 - 79% = 1783 
        80 - 99% = 603 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10563, nodes: 10155287 
    Average node length: 5.15, total dup: 10155187, max dup: 152349 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1603765, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1208 
        40 - 59% = 5355 
        60 - 79% = 1694 
        80 - 99% = 2259 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.16, total records: 574143 
    Average version length: 68.80, total versions: 8464, 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: 7992 
    Data pages: 7992, average fill: 75% 
    Primary pages: 7992, secondary pages: 0, swept pages: 3563 
    Empty pages: 2, full pages: 6739 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 33 
    40 - 59% = 263 
    60 - 79% = 7541 
    80 - 99% = 151 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 35473, depth: 3, leaf buckets: 744, nodes: 574143 
    Average node length: 5.95, total dup: 488929, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100026, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 526 
        60 - 79% = 98 
        80 - 99% = 84 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 24627, depth: 3, leaf buckets: 775, nodes: 574143 
    Average node length: 6.15, total dup: 470907, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100083, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 544 
        60 - 79% = 114 
        80 - 99% = 81 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 581, nodes: 574143 
    Average node length: 4.86, total dup: 574043, max dup: 9533 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88924, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 22 
        40 - 59% = 366 
        60 - 79% = 91 
        80 - 99% = 101 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Feb 29 19:11:36 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7837690 133208 1 0.0000 0.0000
DOC_LIST 2293026 140193 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 236454 619 59100.0000 0.0000
INVNT_TURNOVER_LOG 68460 51981 1 0.0000 0.0000
MONEY_SALDO 49 19199 978 39100.0000 0.0000
MONEY_TURNOVER_LOG 1092 940 1 0.0000 0.0000
PDISTR 810882 87228 5 0.0000 0.0000
PERF_SPLIT_0 151453 2876 1 0.0000 0.0000
PERF_SPLIT_1 162813 13812 1 0.0000 0.0000
PERF_SPLIT_2 156220 4123 1 0.0000 0.0000
PERF_SPLIT_3 155212 4658 1 0.0000 0.0000
PERF_SPLIT_4 153641 15936 1 0.0000 0.0000
PERF_SPLIT_5 145249 2996 1 0.0000 0.0000
PERF_SPLIT_6 169824 2798 1 0.0000 0.0000
PERF_SPLIT_7 151436 6268 1 0.0000 0.0000
PERF_SPLIT_8 164203 10074 1 0.0000 0.0000
PERF_SPLIT_9 164670 3516 1 0.0000 0.0000
PSTORNED 2128754 58660 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 168275 78355 1 0.0000 0.0000
XQD_1000_3300 7113003 594980 1 0.0000 0.0000
XQD_1200_2000 12222361 479465 1 0.0000 0.0000
XQD_2000_3300 1892598 1031170 1 0.0000 0.0000
XQD_2100_3300 1124462 531694 1 0.0000 0.0000
XQD_3300_3400 9608352 652425 1 0.0000 0.0000
XQS_1000_1200 21158209 20997 1 0.0000 0.0000
XQS_1000_3300 10055228 650454 1 0.0000 0.0000
XQS_1200_2000 11494339 518537 1 0.0000 0.0000
XQS_2100_3300 10155287 633681 1 0.0000 0.0000
XQS_3300_3400 574143 8464 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 ---
--- end of diff output ---

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

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