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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-23 22:09:42
DTS_END                         2024-03-23 22:09:42.2280
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45098
TRN_ID                          177921
ATT_ID                          612
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9145.69 17648 914569
customer order: creation 182.37 367 18237
customer order: refuse 14.95 385 1495
order to supplier: creation 47.81 1256 4781
order to supplier: removal 3.57 97648 357
invoice (draft): creation 47.47 3021 4747
invoice (draft): removal 49.91 871 4991
invoice accept: apply 43.24 20244 4324
invoice accept: cancel 44.21 921 4421
customer reserve: creation 4036.49 198 403649
customer reserve: removal 4371.26 62 437126
realization accept: apply 88.62 194 8862
realization accept: cancel 79.47 127 7947
payment from customer: creation 61.94 135 6194
payment from customer: removal 5.84 108 584
payment to supplier: creation 52.13 168 5213
payment to supplier: removal 3.84 70 384
service: total inventory turnovers 4.92 1204 492
service: total monetary turnovers 6.60 56 660
service: aggregate perf. data 1.02 17166 102
service: refresh index statistics 0.03 208759 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-03-2024 22:10:40 to 23-03-2024 22:10:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2688
TEST_TIME 2 3020
TEST_TIME 3 4212
TEST_TIME 4 4272
TEST_TIME 5 4620
TEST_TIME 6 4581
TEST_TIME 7 4827
TEST_TIME 8 5268
TEST_TIME 9 5331
TEST_TIME 10 5595
TEST_TIME 11 5602
TEST_TIME 12 5745
TEST_TIME 13 5758
TEST_TIME 14 6377
TEST_TIME 15 6352
TEST_TIME 16 6409
TEST_TIME 17 6477
TEST_TIME 18 6790
TEST_TIME 19 7081
TEST_TIME 20 7306
TEST_TIME 21 7672
TEST_TIME 22 8003
TEST_TIME 23 8013
TEST_TIME 24 8186
TEST_TIME 25 8568
TEST_TIME 26 9122
TEST_TIME 27 8796
TEST_TIME 28 9008
TEST_TIME 29 8940
TEST_TIME 30 8891
TEST_TIME 31 8892
TEST_TIME 32 8796
TEST_TIME 33 9031
TEST_TIME 34 8965
TEST_TIME 35 9024
TEST_TIME 36 9044
TEST_TIME 37 8958
TEST_TIME 38 8933
TEST_TIME 39 8944
TEST_TIME 40 8985
TEST_TIME 41 9019
TEST_TIME 42 9018
TEST_TIME 43 9103
TEST_TIME 44 9180
TEST_TIME 45 9115
TEST_TIME 46 9195
TEST_TIME 47 9259
TEST_TIME 48 9148
TEST_TIME 49 9008
TEST_TIME 50 8953
TEST_TIME 51 8964
TEST_TIME 52 8860
TEST_TIME 53 8840
TEST_TIME 54 8878
TEST_TIME 55 8828
TEST_TIME 56 8926
TEST_TIME 57 8928
TEST_TIME 58 8871
TEST_TIME 59 8797
TEST_TIME 60 8704
TEST_TIME 61 8801
TEST_TIME 62 8796
TEST_TIME 63 8748
TEST_TIME 64 8788
TEST_TIME 65 8786
TEST_TIME 66 8800
TEST_TIME 67 8818
TEST_TIME 68 8834
TEST_TIME 69 8849
TEST_TIME 70 8899
TEST_TIME 71 8967
TEST_TIME 72 8964
TEST_TIME 73 8975
TEST_TIME 74 8979
TEST_TIME 75 9026
TEST_TIME 76 9075
TEST_TIME 77 9179
TEST_TIME 78 9176
TEST_TIME 79 9205
TEST_TIME 80 9129
TEST_TIME 81 9077
TEST_TIME 82 9068
TEST_TIME 83 9068
TEST_TIME 84 9027
TEST_TIME 85 9075
TEST_TIME 86 9077
TEST_TIME 87 9062
TEST_TIME 88 9060
TEST_TIME 89 8998
TEST_TIME 90 8961
TEST_TIME 91 8950
TEST_TIME 92 8924
TEST_TIME 93 8892
TEST_TIME 94 8938
TEST_TIME 95 8997
TEST_TIME 96 9022
TEST_TIME 97 9038
TEST_TIME 98 9101
TEST_TIME 99 9070
TEST_TIME 100 9151

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-03-2024 22:10:44 to 23-03-2024 22: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 1284944 1284944 0 0.00 0 27729 8 0 0
doc_list_biud 1284944 1284944 0 0.00 0 34300 28 0 0
sp_add_invoice_to_stock 4395 4324 71 1.61 38 157854 20245 0 71
sp_cancel_adding_invoice 4421 4421 0 0.00 5 84237 921 0 0
sp_cancel_client_order 1495 1495 0 0.00 4 12905 386 0 0
sp_cancel_customer_reserve 437126 437126 0 0.00 0 34304 63 0 0
sp_cancel_pay_from_customer 584 584 0 0.00 2 12465 109 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 3 5983 70 0 0
sp_cancel_supplier_invoice 4999 4991 8 0.16 1 15441 872 0 8
sp_cancel_supplier_order 357 357 0 0.00 9 794079 97649 0 0
sp_cancel_write_off 7947 7947 0 0.00 1 8786 128 0 0
sp_client_order 18237 18237 0 0.00 3 15518 368 0 0
sp_customer_reserve 403649 403649 0 0.00 0 96642 199 0 0
sp_fill_shopping_cart 27756 27756 0 0.00 1 10585 35 0 0
sp_fill_shopping_cart_clo_res 403643 403643 0 0.00 0 14679 15 0 0
sp_get_clo_for_invoice 4317 4317 0 0.00 0 30560 296 0 0
sp_kill_cost_storno 13336 13336 0 0.00 0 27718 69 0 0
sp_kill_qstorno_ret_qs2qd 887547 887547 0 0.00 0 33616 34 0 0
sp_kill_qty_storno 469515 469515 0 0.00 0 34299 75 0 0
sp_lock_selected_doc 18165 18165 0 0.00 0 7204 5 0 0
sp_make_cost_storno 24585 24585 0 0.00 0 15530 69 0 0
sp_multiply_rows_for_pdistr 24585 24585 0 0.00 0 12469 34 0 0
sp_multiply_rows_for_qdistr 18237 18237 0 0.00 0 9824 170 0 0
sp_pay_from_customer 6194 6194 0 0.00 4 15560 136 0 0
sp_pay_to_supplier 5213 5213 0 0.00 5 26932 169 0 0
sp_payment_common 11407 11407 0 0.00 1 26791 47 0 0
sp_qd_handle_on_cancel_clo 1495 1495 0 0.00 0 12899 355 0 0
sp_qd_handle_on_invoice_upd_sts 8737 8737 0 0.00 0 33186 364 0 0
sp_qd_handle_on_reserve_upd_sts 8862 8862 0 0.00 0 12551 62 0 0
sp_reserve_write_off 8862 8862 0 0.00 5 16859 195 0 0
sp_supplier_invoice 4747 4747 0 0.00 6 58320 3022 0 0
sp_supplier_order 4781 4781 0 0.00 4 39421 1256 0 0
srv_aggregate_perf_data 102 102 0 0.00 1221 363854 17166 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1407 110645 41973 0 0
srv_find_qd_qs_mism 871048 871048 0 0.00 0 13467 6 0 0
srv_make_invnt_saldo 492 492 0 0.00 59 65537 1205 0 0
srv_make_money_saldo 660 660 0 0.00 1 13235 57 0 0
srv_recalc_idx_stat 3 3 0 0.00 114611 396826 208759 0 0
t$perf-abend:sp_add_invoice_to_stock 71 71 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4325 4325 0 0.00 0 27782 184 0 0
t$perf-norm:sp_cancel_adding_invoice 350 350 0 0.00 0 4044 108 0 0
t$perf-norm:sp_cancel_client_order 1495 1495 0 0.00 0 3166 14 0 0
t$perf-norm:sp_cancel_customer_reserve 597 597 0 0.00 0 6753 51 0 0
t$perf-norm:sp_cancel_pay_from_customer 584 584 0 0.00 0 12570 27 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 3926 18 0 0
t$perf-norm:sp_cancel_supplier_invoice 367 367 0 0.00 0 12109 62 0 0
t$perf-norm:sp_cancel_supplier_order 357 357 0 0.00 0 36557 2199 0 0
t$perf-norm:sp_cancel_write_off 853 853 0 0.00 0 722 4 0 0
t$perf-norm:sp_client_order 18237 18237 0 0.00 0 12498 17 0 0
t$perf-norm:sp_customer_reserve 881 881 0 0.00 0 905 6 0 0
t$perf-norm:sp_pay_from_customer 6194 6194 0 0.00 0 4628 7 0 0
t$perf-norm:sp_pay_to_supplier 5213 5213 0 0.00 0 15465 14 0 0
t$perf-norm:sp_reserve_write_off 8862 8862 0 0.00 0 5536 11 0 0
t$perf-norm:sp_supplier_invoice 4747 4747 0 0.00 0 14725 25 0 0
t$perf-norm:sp_supplier_order 4781 4781 0 0.00 0 12917 19 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 317 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 232 7 0 0
t$perf-norm:srv_make_invnt_saldo 492 492 0 0.00 0 1762 24 0 0
t$perf-norm:srv_make_money_saldo 660 660 0 0.00 0 973 15 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 17 7 0 0
v_add_invoice_to_stock 8774 8632 142 1.61 0 7123 15 0 142
v_all_customers 33608 33608 0 0.00 0 96 1 0 0
v_all_suppliers 27020 27020 0 0.00 0 28 1 0 0
v_all_wares 36474 36474 0 0.00 0 65 1 0 0
v_cancel_adding_invoice 700 700 0 0.00 0 1567 12 0 0
v_cancel_client_order 2990 2990 0 0.00 0 1602 5 0 0
v_cancel_customer_prepayment 1168 1168 0 0.00 0 4552 9 0 0
v_cancel_customer_reserve 1194 1194 0 0.00 0 594 3 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 218 3 0 0
v_cancel_supplier_invoice 750 734 16 2.13 0 1305 13 0 16
v_cancel_supplier_order 714 714 0 0.00 0 356 2 0 0
v_cancel_write_off 1706 1706 0 0.00 0 1693 13 0 0
v_max_id_clo_ord 4781 4781 0 0.00 0 949 2 0 0
v_max_id_clo_res 881 881 0 0.00 0 2757 16 0 0
v_max_id_ord_sup 4737 4737 0 0.00 0 6800 6 0 0
v_max_non_paid_invoice 1221 1221 0 0.00 0 26780 32 0 0
v_max_non_paid_realizn 3111 3111 0 0.00 0 4874 7 0 0
v_min_id_clo_ord 4781 4781 0 0.00 0 5435 7 0 0
v_min_id_clo_res 881 881 0 0.00 0 7957 12 0 0
v_min_id_ord_sup 4737 4737 0 0.00 0 7887 5 0 0
v_min_non_paid_invoice 5213 5213 0 0.00 0 10729 38 0 0
v_min_non_paid_realizn 6194 6194 0 0.00 0 11718 33 0 0
v_our_firm 9032 9032 0 0.00 0 13 1 0 0
v_reserve_write_off 17724 17724 0 0.00 0 1862 4 0 0
x_lock_depdocs_on_canc_invoice 9045 9045 0 0.00 0 14494 133 0 0
x_lock_depdocs_on_canc_sup_ord 357 357 0 0.00 0 7618 347 0 0
x_make_qstorno_1000_1200 4781 4781 0 0.00 1 34915 1175 0 0
x_make_qstorno_1200_2000 4747 4747 0 0.00 2 58311 2893 0 0
x_make_qstorno_2100_3300 403649 403649 0 0.00 0 96638 181 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-03-2024 22:10:48 to 23-03-2024 22: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
20:09:46 8 8192000000 8802194384 8814821376 7825728 0.095 4 1 2 0 7927984 59472 42784
20:10:46 27682 8192000000 9911120672 10220363776 980634224 10.690 100 87 173 0 1008033792 5516736 21882832
20:12:18 19889 8192000000 9959099232 10283155456 1040455280 11.269 100 88 176 0 1070546688 8016912 22074496
20:13:42 10824 8192000000 9982921760 10315067392 1068110176 11.534 100 82 164 0 1097724656 9159072 20455408
20:14:58 13905 8192000000 10025834960 10369101824 1113121152 11.962 100 85 169 0 1143210128 10438592 19650384
20:16:16 5352 8192000000 10066974992 10426413056 1158109280 12.386 100 73 145 1 1185932656 10963232 16860144
20:17:24 3656 8192000000 10113511104 10479194112 1203889200 12.812 100 81 162 1 1234553040 12406640 18257200
20:18:29 3678 8192000000 10150722768 10523418624 1238847488 13.136 100 82 162 0 1269890720 13295072 17748160
20:19:34 1671 8192000000 10178367056 10558205952 1263496752 13.362 100 82 162 1 1294542992 13106592 17939648
20:20:37 1881 8192000000 10195977360 10583617536 1289294192 13.598 100 89 178 1 1321896384 13528896 19073296
20:21:40 1448 8192000000 10207218704 10602373120 1300701648 13.702 100 68 134 1 1325531520 10081088 14748784
20:22:43 4662 8192000000 10200105728 10607140864 1305205776 13.743 100 40 80 0 1323493264 9335920 8951568
20:23:49 24247 8192000000 10198004032 10609696768 1306924080 13.758 100 42 83 0 1323861056 7512448 9424528
20:25:18 4524 8192000000 10209434576 10619760640 1312780320 13.811 100 49 99 1 1331722016 7869440 11072256
20:26:25 10349 8192000000 10207148672 10624954368 1317995840 13.859 100 27 56 0 1330441840 6188336 6257664
20:27:37 55263 8192000000 10223897568 10643439616 1328840928 13.957 100 31 60 0 1341512928 5404320 7267680
20:29:33 5347 8192000000 10217805296 10633859072 1324332528 13.916 100 30 60 2 1337279216 6191344 6755344
20:30:51 26373 8192000000 10235636144 10647609344 1324898784 13.921 100 48 96 0 1346147920 10238192 11010944
20:32:23 20275 8192000000 10208592160 10611142656 1282802256 13.539 97 47 93 0 1306853168 12801200 11249712
20:33:53 39492 8192000000 10234189536 10649788416 1332706352 13.992 100 40 80 0 1355970448 13251664 10012432
20:35:41 31893 8192000000 10212415888 10621202432 1262841280 13.356 95 37 74 0 1284228784 12036816 9350688
20:37:23 20852 8192000000 10244946096 10654724096 1306516720 13.754 98 45 89 0 1332022096 15633712 9871664
20:38:48 17703 8192000000 10257057344 10663247872 1339148816 14.050 100 47 94 1 1368587472 18016064 11422592
20:40:18 5234 8192000000 10234954656 10638082048 1316753952 13.847 100 44 87 0 1342789632 15870576 10165104
20:41:29 2484 8192000000 10260413744 10657472512 1329797184 13.965 100 72 143 1 1371923328 25026992 17099152
20:42:36 7459 8192000000 10277596576 10681581568 1346153904 14.113 100 60 120 1 1386125856 26095040 13876912
20:43:50 7891 8192000000 10271619808 10680725504 1351117328 14.158 100 54 108 0 1383474576 19058576 13298672
20:45:10 6635 8192000000 10310640480 10713268224 1370314656 14.330 100 74 146 2 1410801520 22372464 18114400
20:46:20 7088 8192000000 10308636000 10716127232 1374017008 14.363 100 63 126 1 1415766816 26099616 15650192
20:47:34 1403 8192000000 10315138736 10714222592 1371687424 14.342 100 90 178 0 1420893824 27019728 22186672
20:48:39 1628 8192000000 10312116576 10720055296 1370295520 14.330 100 75 144 2 1416493504 27648000 18549984
20:49:47 10415 8192000000 10314590320 10717519872 1370381888 14.330 100 75 149 2 1422606272 33712832 18511552
20:51:00 16892 8192000000 10292758640 10722037760 1370731184 14.334 100 25 50 0 1403410784 25823664 6855936
20:52:39 6846 8192000000 10288724096 10714062848 1369086608 14.319 100 39 78 0 1400769536 21082400 10600528
20:53:50 15782 8192000000 10300993856 10726748160 1372747632 14.352 100 33 64 0 1407459344 26102448 8609264
20:55:24 15787 8192000000 10310307136 10751057920 1393589808 14.538 100 33 67 0 1420760032 18830560 8339664
20:57:47 43171 8192000000 10320023136 10759897088 1394279296 14.544 100 29 57 1 1419708064 18523920 6904848
20:59:33 61959 8192000000 10308824016 10752409600 1400532512 14.600 100 22 45 0 1420974976 14888384 5554080
21:02:14 25784 8192000000 10311472048 10759299072 1399952800 14.595 100 24 48 0 1424411488 17927328 6531360
21:04:00 57022 8192000000 10310408368 10764193792 1395217008 14.552 99 29 57 0 1410602016 8890960 6494048
21:05:58 52458 8192000000 10309024752 10757976064 1394620544 14.547 99 29 53 1 1416221616 14924720 6676352
21:07:52 37250 8192000000 10303639072 10759630848 1402015808 14.613 100 16 32 0 1413934704 8656320 3262576
21:09:31 103068 8192000000 10309937376 10763632640 1344097760 14.094 95 6 12 0 1356247504 11112448 1037296
21:12:15 97898 8192000000 10320303008 10777526272 1373108944 14.355 97 11 22 0 1391014320 15750144 2155232
21:14:53 96653 8192000000 10321680496 10771570688 1333650064 14.000 94 9 18 0 1351992416 16456800 1885552
21:17:37 72493 8192000000 10306602992 10751889408 1390285728 14.508 99 17 33 0 1401071232 7643584 3141920
21:19:51 9439 8192000000 10300713008 10720567296 1356267632 14.204 98 72 142 2 1380376832 9428832 14680368
21:21:03 76444 8192000000 10268541360 10700947456 1257855072 13.310 91 44 87 1 1275222992 7188512 10179408
21:23:30 74631 8192000000 10269653120 10724667392 1360317264 14.240 99 22 44 0 1376378848 11235712 4825872
21:25:47 110645 8192000000 10260435248 10697441280 1259796208 13.328 92 15 30 0 1272795120 9749728 3249184
21:28:41 69108 8192000000 10251128416 10694983680 1335613376 14.018 99 16 32 1 1351086512 11887568 3585568
21:31:14 22957 8192000000 10243156208 10676060160 1321720128 13.892 99 36 73 1 1341062320 11414304 7927888
21:32:38 55514 8192000000 10236886544 10693627904 1328829104 13.957 99 15 30 0 1341844096 9351552 3663440
21:34:59 55628 8192000000 10260500960 10699395072 1316442704 13.844 97 14 28 0 1328939200 9515200 2981296
21:36:56 33408 8192000000 10249088736 10688458752 1321461296 13.890 98 19 38 0 1333775344 7849248 4464800
21:38:31 39211 8192000000 10277037664 10707165184 1325989008 13.931 97 32 64 0 1343676112 10745200 6941904
21:40:13 61467 8192000000 10265276368 10706702336 1329905008 13.966 97 15 30 0 1342329088 9454640 2969440
21:42:20 33693 8192000000 10295087152 10735755264 1378091136 14.399 100 30 59 0 1393435952 9198096 6146720
21:43:55 17895 8192000000 10299517088 10743848960 1385173088 14.463 100 34 68 0 1402740336 10381664 7185584
21:45:23 73434 8192000000 10305700048 10754781184 1354653984 14.189 97 17 32 0 1372688128 13850240 4183904
21:47:43 45508 8192000000 10302810640 10746847232 1389232832 14.499 100 21 42 0 1404370688 10527104 4610752
21:49:32 79814 8192000000 10303625984 10748506112 1394944480 14.550 100 39 78 1 1415067872 11015728 9107664
21:51:52 49793 8192000000 10304482416 10761342976 1385791696 14.468 99 26 52 0 1404001216 12778352 5431168
21:54:04 64759 8192000000 10298907680 10760609792 1386169440 14.472 99 22 44 0 1405215952 13319920 5726592
21:56:10 75048 8192000000 10287691616 10744455168 1357913408 14.219 97 15 30 0 1371948128 10752576 3282144
21:58:38 47853 8192000000 10278490864 10715291648 1352562528 14.171 97 36 74 2 1367002384 6562128 7877728
22:00:27 53409 8192000000 10273049952 10725928960 1348829392 14.137 97 18 36 0 1363160400 9985824 4345184
22:02:26 53575 8192000000 10302609344 10756497408 1386423024 14.474 100 16 32 0 1399872464 9671840 3777600
22:04:24 50511 8192000000 10281806064 10733420544 1349473200 14.143 98 20 40 0 1363401984 9413312 4515472
22:06:21 63672 8192000000 10276854368 10732728320 1323118928 13.905 96 14 28 0 1335452320 9322352 3011040
22:08:26 39115 8192000000 10299714384 10741170176 1360140896 14.239 98 44 88 0 1386170320 16699984 9329440

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 23-03-2024 22:10:54 to 23-03-2024 22:11:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 71 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-03-2024 22:11:09 to 23-03-2024 22: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          175841
MON$OLDEST_ACTIVE               178051
MON$OLDEST_SNAPSHOT             178051
MON$NEXT_TRANSACTION            178051
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                       1912288
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.33740 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33740 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33740 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 Sat Mar 23 22:11:12 2024 
 
Database header page information: 
    Flags            0 
    Generation        92836 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    175841 
    Oldest active        178051 
    Oldest snapshot        178051 
    Next transaction    178052 
    Sequence number        0 
    Next attachment ID    715 
    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: 46.88, total records: 7834388 
    Average version length: 48.16, total versions: 164930, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.37 
    Pointer pages: 54, data page slots: 87592 
    Data pages: 87592, average fill: 72% 
    Primary pages: 87592, secondary pages: 0, swept pages: 12664 
    Empty pages: 7, full pages: 71305 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 170 
    40 - 59% = 2760 
    60 - 79% = 84582 
    80 - 99% = 55 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23322, nodes: 7834388 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1736240, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 351 
        20 - 39% = 1507 
        40 - 59% = 4283 
        60 - 79% = 2160 
        80 - 99% = 15021 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13546, nodes: 7834388 
    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: 1559367, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1399 
        40 - 59% = 2203 
        60 - 79% = 920 
        80 - 99% = 9024 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8358, nodes: 7834388 
    Average node length: 6.64, total dup: 5833920, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1552302, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 137 
        20 - 39% = 825 
        40 - 59% = 1489 
        60 - 79% = 809 
        80 - 99% = 5098 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.32, total records: 2289207 
    Average version length: 34.51, total versions: 169226, max versions: 4 
    Average fragment length: 8.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.52 
    Pointer pages: 18, data page slots: 28856 
    Data pages: 28856, average fill: 74% 
    Primary pages: 28848, secondary pages: 8, swept pages: 6989 
    Empty pages: 5, full pages: 22499 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 94 
    40 - 59% = 1751 
    60 - 79% = 25023 
    80 - 99% = 1973 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4578, nodes: 2289207 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 698949, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 835 
        40 - 59% = 909 
        60 - 79% = 652 
        80 - 99% = 2181 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2538, nodes: 2292684 
    Average node length: 4.97, total dup: 2291785, max dup: 18689 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1258383, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 228 
        40 - 59% = 1561 
        60 - 79% = 526 
        80 - 99% = 219 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1988, nodes: 2289207 
    Average node length: 4.97, total dup: 2289157, max dup: 130510 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1077710, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 81 
        40 - 59% = 941 
        60 - 79% = 45 
        80 - 99% = 920 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4362, nodes: 2289207 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 698949, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 111 
        20 - 39% = 541 
        40 - 59% = 614 
        60 - 79% = 733 
        80 - 99% = 2363 
 
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.08, total records: 400 
    Average version length: 23.23, total versions: 237416, max versions: 615 
    Average fragment length: 2.03, total fragments: 65, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1352 
    Data pages: 1352, average fill: 88% 
    Primary pages: 8, secondary pages: 1344, swept pages: 0 
    Empty pages: 1, full pages: 1350 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1348 
 
    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: 6.99, total records: 120930 
    Average version length: 68.30, total versions: 108552, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 12.59 
    Pointer pages: 7, data page slots: 2904 
    Data pages: 2560, average fill: 59% 
    Primary pages: 2558, secondary pages: 2, swept pages: 0 
    Empty pages: 434, full pages: 1285 
    Fill distribution: 
     0 - 19% = 558 
    20 - 39% = 245 
    40 - 59% = 245 
    60 - 79% = 370 
    80 - 99% = 1142 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1698294, depth: 3, leaf buckets: 398, nodes: 120930 
    Average node length: 13.24, total dup: 9847, max dup: 1 
    Average key length: 10.63, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 86286, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 44 
        40 - 59% = 305 
        60 - 79% = 48 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18817, max versions: 946 
    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: 84% 
    Primary pages: 5, secondary pages: 67, swept pages: 0 
    Empty pages: 4, full pages: 67 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 11 
    80 - 99% = 57 
 
    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.79, total records: 1798 
    Average version length: 43.72, total versions: 1525, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 8.54 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 54% 
    Primary pages: 30, secondary pages: 2, swept pages: 0 
    Empty pages: 7, full pages: 15 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88485, depth: 2, leaf buckets: 5, nodes: 1798 
    Average node length: 4.16, total dup: 1700, max dup: 282 
    Average key length: 2.59, compression ratio: 7.34 
    Average prefix length: 18.46, average data length: 0.54 
    Clustering factor: 871, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        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: 96.99, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 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: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.72, total records: 806739 
    Average version length: 25.39, total versions: 84007, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 8120 
    Data pages: 8120, average fill: 70% 
    Primary pages: 8080, secondary pages: 40, swept pages: 1044 
    Empty pages: 110, full pages: 7524 
    Fill distribution: 
     0 - 19% = 211 
    20 - 39% = 107 
    40 - 59% = 90 
    60 - 79% = 7366 
    80 - 99% = 346 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 896, nodes: 806739 
    Average node length: 4.87, total dup: 806690, max dup: 149499 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90029, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 132 
        40 - 59% = 501 
        60 - 79% = 210 
        80 - 99% = 53 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 959, nodes: 806739 
    Average node length: 5.88, total dup: 718250, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161396, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 103 
        40 - 59% = 453 
        60 - 79% = 133 
        80 - 99% = 269 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 993, nodes: 806739 
    Average node length: 5.88, total dup: 718250, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163401, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 200 
        40 - 59% = 393 
        60 - 79% = 118 
        80 - 99% = 282 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1141, nodes: 806739 
    Average node length: 5.96, total dup: 718250, max dup: 43 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156165, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 252 
        40 - 59% = 570 
        60 - 79% = 224 
        80 - 99% = 89 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5411 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.03, total fragments: 68, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 112 
    Data pages: 96, average fill: 56% 
    Primary pages: 77, secondary pages: 19, swept pages: 51 
    Empty pages: 13, full pages: 64 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5411 
    Average node length: 5.45, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.01 
    Average prefix length: 34.33, average data length: 1.55 
    Clustering factor: 5071, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5411 
    Average node length: 11.08, 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: 153, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.11, total records: 81602 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 792 
    Data pages: 792, average fill: 71% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 786 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 786 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33890, depth: 2, leaf buckets: 105, nodes: 81602 
    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: 3222, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        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.69, 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.28 
    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: 147.43, total records: 165626 
    Average version length: 153.20, total versions: 3748, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 6, data page slots: 4840 
    Data pages: 3976, average fill: 86% 
    Primary pages: 3976, secondary pages: 0, swept pages: 7 
    Empty pages: 43, full pages: 3914 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3913 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 126.91, total records: 190286 
    Average version length: 154.97, total versions: 30246, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.36 
    Pointer pages: 6, data page slots: 5424 
    Data pages: 4608, average fill: 87% 
    Primary pages: 4607, secondary pages: 1, swept pages: 1 
    Empty pages: 56, full pages: 4494 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 4 
    40 - 59% = 44 
    60 - 79% = 7 
    80 - 99% = 4494 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.56, total records: 172460 
    Average version length: 153.01, total versions: 4211, 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: 6, data page slots: 5488 
    Data pages: 4168, average fill: 85% 
    Primary pages: 4168, secondary pages: 0, swept pages: 1 
    Empty pages: 66, full pages: 4084 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 10 
    80 - 99% = 4082 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 126.49, total records: 221150 
    Average version length: 155.19, total versions: 36245, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.41 
    Pointer pages: 7, data page slots: 6624 
    Data pages: 5344, average fill: 87% 
    Primary pages: 5344, secondary pages: 0, swept pages: 6 
    Empty pages: 64, full pages: 5259 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 3 
    80 - 99% = 5259 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 135.06, total records: 161269 
    Average version length: 154.73, total versions: 17186, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.56 
    Pointer pages: 7, data page slots: 4736 
    Data pages: 3904, average fill: 86% 
    Primary pages: 3904, secondary pages: 0, swept pages: 1 
    Empty pages: 58, full pages: 3826 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3824 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 145.85, total records: 155789 
    Average version length: 153.75, total versions: 4895, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 6, data page slots: 5688 
    Data pages: 3752, average fill: 86% 
    Primary pages: 3752, secondary pages: 0, swept pages: 2 
    Empty pages: 60, full pages: 3679 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3679 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 149.98, total records: 167568 
    Average version length: 149.60, total versions: 1385, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 8, data page slots: 4944 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4008, secondary pages: 0, swept pages: 2 
    Empty pages: 29, full pages: 3966 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 7 
    80 - 99% = 3966 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 145.94, total records: 172816 
    Average version length: 153.11, total versions: 5790, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 7, data page slots: 5264 
    Data pages: 4128, average fill: 86% 
    Primary pages: 4128, secondary pages: 0, swept pages: 1 
    Empty pages: 27, full pages: 4090 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4090 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 134.71, total records: 182811 
    Average version length: 154.85, total versions: 19661, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.59 
    Pointer pages: 7, data page slots: 5480 
    Data pages: 4432, average fill: 86% 
    Primary pages: 4431, secondary pages: 1, swept pages: 5 
    Empty pages: 82, full pages: 4333 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4332 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.74, total records: 165455 
    Average version length: 153.10, total versions: 3544, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 6, data page slots: 4384 
    Data pages: 3968, average fill: 86% 
    Primary pages: 3967, secondary pages: 1, swept pages: 6 
    Empty pages: 40, full pages: 3917 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3917 
 
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: 50.72, total records: 2156584 
    Average version length: 52.90, total versions: 82930, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.38 
    Pointer pages: 16, data page slots: 25568 
    Data pages: 25568, average fill: 73% 
    Primary pages: 25568, secondary pages: 0, swept pages: 8478 
    Empty pages: 156, full pages: 22525 
    Fill distribution: 
     0 - 19% = 292 
    20 - 39% = 262 
    40 - 59% = 686 
    60 - 79% = 23513 
    80 - 99% = 815 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2610, nodes: 2156584 
    Average node length: 5.44, total dup: 2014051, max dup: 1657 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185500, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 274 
        40 - 59% = 1715 
        60 - 79% = 297 
        80 - 99% = 322 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2763, nodes: 2156584 
    Average node length: 5.69, total dup: 1936949, max dup: 71 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 384363, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2276 
        60 - 79% = 443 
        80 - 99% = 34 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2203, nodes: 2156584 
    Average node length: 4.96, total dup: 2156484, max dup: 28046 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182861, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 184 
        40 - 59% = 1239 
        60 - 79% = 369 
        80 - 99% = 410 
 
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.94, total records: 158556 
    Average version length: 69.20, total versions: 73947, 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: 4480 
    Data pages: 3384, average fill: 55% 
    Primary pages: 3384, secondary pages: 0, swept pages: 529 
    Empty pages: 816, full pages: 2024 
    Fill distribution: 
     0 - 19% = 1057 
    20 - 39% = 68 
    40 - 59% = 83 
    60 - 79% = 824 
    80 - 99% = 1352 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103141, depth: 3, leaf buckets: 235, nodes: 158556 
    Average node length: 6.44, total dup: 137977, max dup: 14 
    Average key length: 3.92, compression ratio: 10.70 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27330, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 43 
        40 - 59% = 106 
        60 - 79% = 68 
        80 - 99% = 17 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.21, total records: 7261111 
    Average version length: 68.80, total versions: 499845, 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: 63, data page slots: 101192 
    Data pages: 101192, average fill: 77% 
    Primary pages: 101192, secondary pages: 0, swept pages: 15264 
    Empty pages: 183, full pages: 97393 
    Fill distribution: 
     0 - 19% = 743 
    20 - 39% = 1020 
    40 - 59% = 990 
    60 - 79% = 85052 
    80 - 99% = 13387 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10674, nodes: 7261111 
    Average node length: 6.51, total dup: 6281039, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1611083, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1216 
        40 - 59% = 5914 
        60 - 79% = 2987 
        80 - 99% = 549 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8487, nodes: 7261111 
    Average node length: 5.39, total dup: 6974662, max dup: 165 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1404165, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 972 
        40 - 59% = 4640 
        60 - 79% = 1580 
        80 - 99% = 1286 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8556, nodes: 7261111 
    Average node length: 5.39, total dup: 6974662, max dup: 165 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1406678, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1078 
        40 - 59% = 4618 
        60 - 79% = 1562 
        80 - 99% = 1291 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.64, total records: 12212124 
    Average version length: 68.75, total versions: 410115, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 103, data page slots: 167144 
    Data pages: 167144, average fill: 78% 
    Primary pages: 167144, secondary pages: 0, swept pages: 62096 
    Empty pages: 5, full pages: 167030 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 7 
    60 - 79% = 156841 
    80 - 99% = 10291 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18345, nodes: 12212124 
    Average node length: 6.58, total dup: 10646405, max dup: 63 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2401398, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1933 
        40 - 59% = 10888 
        60 - 79% = 4634 
        80 - 99% = 863 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 33.33, total records: 1970740 
    Average version length: 69.12, total versions: 1021034, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.78 
    Pointer pages: 27, data page slots: 43808 
    Data pages: 29928, average fill: 77% 
    Primary pages: 29927, secondary pages: 1, swept pages: 3348 
    Empty pages: 1220, full pages: 25208 
    Fill distribution: 
     0 - 19% = 2117 
    20 - 39% = 795 
    40 - 59% = 817 
    60 - 79% = 9357 
    80 - 99% = 16842 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2269, nodes: 1970740 
    Average node length: 5.51, total dup: 1890978, max dup: 99 
    Average key length: 2.54, compression ratio: 16.50 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 130103, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 190 
        40 - 59% = 1028 
        60 - 79% = 736 
        80 - 99% = 306 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 34.82, total records: 1383201 
    Average version length: 69.14, total versions: 685321, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.62 
    Pointer pages: 22, data page slots: 34952 
    Data pages: 27408, average fill: 59% 
    Primary pages: 27407, secondary pages: 1, swept pages: 5349 
    Empty pages: 5254, full pages: 17190 
    Fill distribution: 
     0 - 19% = 7079 
    20 - 39% = 668 
    40 - 59% = 740 
    60 - 79% = 7033 
    80 - 99% = 11888 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1666, nodes: 1383201 
    Average node length: 5.78, total dup: 1292654, max dup: 110 
    Average key length: 2.83, compression ratio: 14.83 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 189041, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 102 
        40 - 59% = 786 
        60 - 79% = 555 
        80 - 99% = 217 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 63.19, total records: 9503598 
    Average version length: 68.95, total versions: 786809, 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: 90, data page slots: 146392 
    Data pages: 146368, average fill: 70% 
    Primary pages: 146368, secondary pages: 0, swept pages: 35598 
    Empty pages: 418, full pages: 90116 
    Fill distribution: 
     0 - 19% = 1166 
    20 - 39% = 5589 
    40 - 59% = 23481 
    60 - 79% = 101114 
    80 - 99% = 15018 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13557, nodes: 9503598 
    Average node length: 6.70, total dup: 7884269, max dup: 29 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2063499, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 945 
        40 - 59% = 6576 
        60 - 79% = 5253 
        80 - 99% = 782 
 
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: 21179891 
    Average version length: 82.97, total versions: 19740, 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: 319216 
    Data pages: 319216, average fill: 81% 
    Primary pages: 319216, secondary pages: 0, swept pages: 12041 
    Empty pages: 40, full pages: 318448 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 32 
    40 - 59% = 90 
    60 - 79% = 27198 
    80 - 99% = 291837 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19525, nodes: 21179891 
    Average node length: 5.72, total dup: 20698163, max dup: 177 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285529, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8390 
        60 - 79% = 559 
        80 - 99% = 10572 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17183, nodes: 21179891 
    Average node length: 6.31, total dup: 18613213, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915582, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 750 
        60 - 79% = 286 
        80 - 99% = 16142 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21338, nodes: 21179891 
    Average node length: 6.35, total dup: 18532094, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3580463, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2 
        40 - 59% = 8689 
        60 - 79% = 636 
        80 - 99% = 12003 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16043, nodes: 21179891 
    Average node length: 5.56, total dup: 21179791, max dup: 230182 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944533, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 7 
        40 - 59% = 2758 
        60 - 79% = 356 
        80 - 99% = 12919 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 75.66, total records: 9992306 
    Average version length: 82.60, total versions: 818592, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 107, data page slots: 173736 
    Data pages: 173720, average fill: 71% 
    Primary pages: 173720, secondary pages: 0, swept pages: 50614 
    Empty pages: 743, full pages: 109581 
    Fill distribution: 
     0 - 19% = 1862 
    20 - 39% = 6696 
    40 - 59% = 25850 
    60 - 79% = 63216 
    80 - 99% = 76096 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11399, nodes: 9992306 
    Average node length: 5.38, total dup: 9680973, max dup: 198 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2204856, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 60 
        40 - 59% = 7274 
        60 - 79% = 3931 
        80 - 99% = 133 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13677, nodes: 9992306 
    Average node length: 6.26, total dup: 8284049, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1529551, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 3663 
        40 - 59% = 4520 
        60 - 79% = 2562 
        80 - 99% = 2793 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12725, nodes: 9992306 
    Average node length: 6.00, total dup: 8681520, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2403965, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 60 
        40 - 59% = 8249 
        60 - 79% = 4240 
        80 - 99% = 175 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10368, nodes: 9992306 
    Average node length: 5.16, total dup: 9992206, max dup: 159728 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1572319, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1153 
        40 - 59% = 5194 
        60 - 79% = 1699 
        80 - 99% = 2280 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 77.75, total records: 11575483 
    Average version length: 82.50, total versions: 639749, 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: 117, data page slots: 190520 
    Data pages: 189648, average fill: 75% 
    Primary pages: 189648, secondary pages: 0, swept pages: 55571 
    Empty pages: 1895, full pages: 151649 
    Fill distribution: 
     0 - 19% = 3258 
    20 - 39% = 5327 
    40 - 59% = 14311 
    60 - 79% = 39812 
    80 - 99% = 126940 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13134, nodes: 11575483 
    Average node length: 5.30, total dup: 11465187, max dup: 660 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2416058, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 77 
        40 - 59% = 8436 
        60 - 79% = 4426 
        80 - 99% = 192 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10574, nodes: 11575483 
    Average node length: 5.50, total dup: 11071111, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 728802, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 123 
        20 - 39% = 804 
        40 - 59% = 2622 
        60 - 79% = 1799 
        80 - 99% = 5226 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15021, nodes: 11575483 
    Average node length: 6.02, total dup: 10109273, max dup: 77 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2432696, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 99 
        40 - 59% = 9930 
        60 - 79% = 4785 
        80 - 99% = 201 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10996, nodes: 11575483 
    Average node length: 5.23, total dup: 11575383, max dup: 197905 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 716390, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 93 
        20 - 39% = 798 
        40 - 59% = 4950 
        60 - 79% = 1478 
        80 - 99% = 3677 
 
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: 75.64, total records: 10159853 
    Average version length: 82.90, total versions: 871705, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 109, data page slots: 176464 
    Data pages: 176432, average fill: 72% 
    Primary pages: 176432, secondary pages: 0, swept pages: 48660 
    Empty pages: 574, full pages: 109326 
    Fill distribution: 
     0 - 19% = 1450 
    20 - 39% = 5628 
    40 - 59% = 25173 
    60 - 79% = 70767 
    80 - 99% = 73414 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12237, nodes: 10159853 
    Average node length: 5.20, total dup: 10130128, max dup: 1689 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2047888, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1408 
        40 - 59% = 8276 
        60 - 79% = 1942 
        80 - 99% = 591 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13868, nodes: 10159853 
    Average node length: 6.27, total dup: 8421951, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1520543, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 205 
        20 - 39% = 3618 
        40 - 59% = 4547 
        60 - 79% = 2560 
        80 - 99% = 2938 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12868, nodes: 10159853 
    Average node length: 5.45, total dup: 9708184, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2184289, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1373 
        40 - 59% = 9127 
        60 - 79% = 1756 
        80 - 99% = 586 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10603, nodes: 10159853 
    Average node length: 5.17, total dup: 10159753, max dup: 162022 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1617298, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1233 
        40 - 59% = 5319 
        60 - 79% = 1752 
        80 - 99% = 2264 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.80, total records: 583140 
    Average version length: 68.80, total versions: 11781, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 76% 
    Primary pages: 8064, secondary pages: 0, swept pages: 3250 
    Empty pages: 5, full pages: 7031 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 25 
    40 - 59% = 162 
    60 - 79% = 7664 
    80 - 99% = 206 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40002, depth: 3, leaf buckets: 743, nodes: 583140 
    Average node length: 5.95, total dup: 496476, max dup: 84 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101411, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 515 
        60 - 79% = 101 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26459, depth: 3, leaf buckets: 765, nodes: 583140 
    Average node length: 6.15, total dup: 478349, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101470, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 531 
        60 - 79% = 102 
        80 - 99% = 101 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 590, nodes: 583140 
    Average node length: 4.86, total dup: 583040, max dup: 9936 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89969, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 24 
        40 - 59% = 373 
        60 - 79% = 83 
        80 - 99% = 109 
 
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 Sat Mar 23 22: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 7834388 164930 1 0.0000 0.0000
DOC_LIST 2289207 169226 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 237416 615 59300.0000 0.0000
INVNT_TURNOVER_LOG 120930 108552 1 0.0000 0.0000
MONEY_SALDO 49 18817 946 38400.0000 0.0000
MONEY_TURNOVER_LOG 1798 1525 1 0.0000 0.0000
PDISTR 806739 84007 5 0.0000 0.0000
PERF_SPLIT_0 165626 3748 1 0.0000 0.0000
PERF_SPLIT_1 190286 30246 1 0.0000 0.0000
PERF_SPLIT_2 172460 4211 1 0.0000 0.0000
PERF_SPLIT_3 221150 36245 1 0.0000 0.0000
PERF_SPLIT_4 161269 17186 1 0.0000 0.0000
PERF_SPLIT_5 155789 4895 1 0.0000 0.0000
PERF_SPLIT_6 167568 1385 1 0.0000 0.0000
PERF_SPLIT_7 172816 5790 1 0.0000 0.0000
PERF_SPLIT_8 182811 19661 1 0.0000 0.0000
PERF_SPLIT_9 165455 3544 1 0.0000 0.0000
PSTORNED 2156584 82930 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 158556 73947 1 0.0000 0.0000
XQD_1000_3300 7261111 499845 1 0.0000 0.0000
XQD_1200_2000 12212124 410115 1 0.0000 0.0000
XQD_2000_3300 1970740 1021034 1 0.0000 0.0000
XQD_2100_3300 1383201 685321 1 0.0000 0.0000
XQD_3300_3400 9503598 786809 1 0.0000 0.0000
XQS_1000_1200 21179891 19740 1 0.0000 0.0000
XQS_1000_3300 9992306 818592 1 0.0000 0.0000
XQS_1200_2000 11575483 639749 1 0.0000 0.0000
XQS_2100_3300 10159853 871705 1 0.0000 0.0000
XQS_3300_3400 583140 11781 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 ---
:188: 
:189: mscs-test-161.budzdorov.ru    Sat Mar 23 22:09:44 2024
:190:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:191: 
:192: 
:193: mscs-test-161.budzdorov.ru    Sat Mar 23 22:09:44 2024
:194:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:195: 
:196: 
:197: mscs-test-161.budzdorov.ru    Sat Mar 23 22:09:54 2024
:198:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:199: 
:200: 
:201: mscs-test-161.budzdorov.ru    Sat Mar 23 22:09:54 2024
:202:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:203: 
--- end of diff output ---

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

23.03.24 22: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-03-23 22:11:50 No severe PSQL-related problems occured
23.03.24 22:11:52. End of report.