Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.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 15752556 kB
MemAvailable 30266868 kB
Buffers 0 kB
Cached 15990608 kB
SwapCached 2264 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-01 22:09:40
DTS_END                         2024-03-01 22:09:40.8570
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50394
TRN_ID                          176964
ATT_ID                          556
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: 9128.51 23193 912851
customer order: creation 177.69 326 17769
customer order: refuse 15.27 347 1527
order to supplier: creation 47.78 1243 4778
order to supplier: removal 3.33 105708 333
invoice (draft): creation 46.80 3387 4680
invoice (draft): removal 49.29 858 4929
invoice accept: apply 42.70 21239 4270
invoice accept: cancel 44.37 936 4437
customer reserve: creation 4040.51 207 404051
customer reserve: removal 4363.67 62 436367
realization accept: apply 87.64 199 8764
realization accept: cancel 75.86 139 7586
payment from customer: creation 60.96 122 6096
payment from customer: removal 5.57 80 557
payment to supplier: creation 51.09 146 5109
payment to supplier: removal 3.67 51 367
service: total inventory turnovers 4.83 1225 483
service: total monetary turnovers 6.61 33 661
service: aggregate perf. data 0.84 23430 84
service: refresh index statistics 0.03 304126 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-03-2024 22:11:05 to 01-03-2024 22:11:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6767
TEST_TIME 2 6399
TEST_TIME 3 5804
TEST_TIME 4 5916
TEST_TIME 5 5976
TEST_TIME 6 5840
TEST_TIME 7 5741
TEST_TIME 8 5621
TEST_TIME 9 5820
TEST_TIME 10 5722
TEST_TIME 11 6201
TEST_TIME 12 6581
TEST_TIME 13 6415
TEST_TIME 14 6700
TEST_TIME 15 6840
TEST_TIME 16 6921
TEST_TIME 17 6861
TEST_TIME 18 7068
TEST_TIME 19 6928
TEST_TIME 20 6917
TEST_TIME 21 7108
TEST_TIME 22 7476
TEST_TIME 23 7932
TEST_TIME 24 7732
TEST_TIME 25 7893
TEST_TIME 26 7986
TEST_TIME 27 8073
TEST_TIME 28 8650
TEST_TIME 29 9711
TEST_TIME 30 9714
TEST_TIME 31 9725
TEST_TIME 32 9765
TEST_TIME 33 9707
TEST_TIME 34 9553
TEST_TIME 35 9532
TEST_TIME 36 9439
TEST_TIME 37 9220
TEST_TIME 38 9389
TEST_TIME 39 9307
TEST_TIME 40 9214
TEST_TIME 41 9104
TEST_TIME 42 9004
TEST_TIME 43 8920
TEST_TIME 44 9009
TEST_TIME 45 9126
TEST_TIME 46 9135
TEST_TIME 47 9130
TEST_TIME 48 9114
TEST_TIME 49 9069
TEST_TIME 50 9085
TEST_TIME 51 9053
TEST_TIME 52 9014
TEST_TIME 53 9078
TEST_TIME 54 9097
TEST_TIME 55 9178
TEST_TIME 56 9175
TEST_TIME 57 9234
TEST_TIME 58 9221
TEST_TIME 59 9180
TEST_TIME 60 9152
TEST_TIME 61 9140
TEST_TIME 62 9149
TEST_TIME 63 9206
TEST_TIME 64 9391
TEST_TIME 65 9302
TEST_TIME 66 9252
TEST_TIME 67 9191
TEST_TIME 68 9142
TEST_TIME 69 9203
TEST_TIME 70 9201
TEST_TIME 71 9156
TEST_TIME 72 9127
TEST_TIME 73 9019
TEST_TIME 74 9027
TEST_TIME 75 9048
TEST_TIME 76 9023
TEST_TIME 77 9001
TEST_TIME 78 9098
TEST_TIME 79 9068
TEST_TIME 80 9131
TEST_TIME 81 9125
TEST_TIME 82 9126
TEST_TIME 83 9181
TEST_TIME 84 9172
TEST_TIME 85 9177
TEST_TIME 86 9350
TEST_TIME 87 9338
TEST_TIME 88 9363
TEST_TIME 89 9311
TEST_TIME 90 9251
TEST_TIME 91 9217
TEST_TIME 92 9222
TEST_TIME 93 9223
TEST_TIME 94 9235
TEST_TIME 95 9207
TEST_TIME 96 9176
TEST_TIME 97 9119
TEST_TIME 98 9116
TEST_TIME 99 9172
TEST_TIME 100 9135

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-03-2024 22:11:09 to 01-03-2024 22:11:12.

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 1282270 1282270 0 0.00 0 31280 8 0 0
doc_list_biud 1282269 1282269 0 0.00 0 57806 27 0 0
sp_add_invoice_to_stock 4351 4270 81 1.86 35 261651 21240 0 81
sp_cancel_adding_invoice 4437 4437 0 0.00 4 60296 937 0 0
sp_cancel_client_order 1527 1527 0 0.00 5 7974 348 0 0
sp_cancel_customer_reserve 436367 436367 0 0.00 0 57808 62 0 0
sp_cancel_pay_from_customer 557 557 0 0.00 2 6677 80 0 0
sp_cancel_pay_to_supplier 367 367 0 0.00 3 940 52 0 0
sp_cancel_supplier_invoice 4933 4929 4 0.08 1 17529 859 0 4
sp_cancel_supplier_order 333 333 0 0.00 8 1023857 105709 0 0
sp_cancel_write_off 7586 7586 0 0.00 1 13376 140 0 0
sp_client_order 17769 17769 0 0.00 3 17326 326 0 0
sp_customer_reserve 404051 404051 0 0.00 0 39698 207 0 0
sp_fill_shopping_cart 27223 27223 0 0.00 1 16079 37 0 0
sp_fill_shopping_cart_clo_res 404042 404042 0 0.00 0 38526 14 0 0
sp_get_clo_for_invoice 4261 4261 0 0.00 0 17831 280 0 0
sp_kill_cost_storno 12947 12947 0 0.00 0 9278 69 0 0
sp_kill_qstorno_ret_qs2qd 885582 885582 0 0.00 0 55077 34 0 0
sp_kill_qty_storno 468204 468204 0 0.00 0 57805 74 0 0
sp_lock_selected_doc 17952 17952 0 0.00 0 8559 6 0 0
sp_make_cost_storno 24230 24230 0 0.00 0 31276 66 0 0
sp_multiply_rows_for_pdistr 24230 24230 0 0.00 0 16217 28 0 0
sp_multiply_rows_for_qdistr 17769 17769 0 0.00 0 9646 126 0 0
sp_pay_from_customer 6096 6096 0 0.00 4 16229 123 0 0
sp_pay_to_supplier 5109 5109 0 0.00 5 25582 147 0 0
sp_payment_common 11205 11205 0 0.00 1 19601 42 0 0
sp_qd_handle_on_cancel_clo 1527 1527 0 0.00 0 7968 324 0 0
sp_qd_handle_on_invoice_upd_sts 8698 8698 0 0.00 0 15420 380 0 0
sp_qd_handle_on_reserve_upd_sts 8764 8764 0 0.00 0 15928 65 0 0
sp_reserve_write_off 8764 8764 0 0.00 6 15949 199 0 0
sp_supplier_invoice 4680 4680 0 0.00 6 91564 3388 0 0
sp_supplier_order 4778 4778 0 0.00 5 24803 1244 0 0
srv_aggregate_perf_data 85 84 1 1.17 1524 384934 23431 0 1
srv_fill_mon_cache_memory 56 56 0 0.00 1444 161643 39638 0 0
srv_find_qd_qs_mism 869177 869177 0 0.00 0 23995 7 0 0
srv_make_invnt_saldo 483 483 0 0.00 44 110793 1225 0 0
srv_make_money_saldo 661 661 0 0.00 1 3608 33 0 0
srv_recalc_idx_stat 3 3 0 0.00 144923 402900 304126 0 0
t$perf-abend:sp_add_invoice_to_stock 81 81 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4271 4271 0 0.00 0 11702 204 0 0
t$perf-norm:sp_cancel_adding_invoice 356 356 0 0.00 0 7700 119 0 0
t$perf-norm:sp_cancel_client_order 1527 1527 0 0.00 0 12324 21 0 0
t$perf-norm:sp_cancel_customer_reserve 588 588 0 0.00 0 7793 40 0 0
t$perf-norm:sp_cancel_pay_from_customer 557 557 0 0.00 0 604 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 367 367 0 0.00 0 4815 19 0 0
t$perf-norm:sp_cancel_supplier_invoice 331 331 0 0.00 0 3974 32 0 0
t$perf-norm:sp_cancel_supplier_order 333 333 0 0.00 0 23169 1931 0 0
t$perf-norm:sp_cancel_write_off 868 868 0 0.00 0 5987 21 0 0
t$perf-norm:sp_client_order 17769 17769 0 0.00 0 11192 20 0 0
t$perf-norm:sp_customer_reserve 839 839 0 0.00 0 3046 14 0 0
t$perf-norm:sp_pay_from_customer 6096 6096 0 0.00 0 3971 8 0 0
t$perf-norm:sp_pay_to_supplier 5109 5109 0 0.00 0 3202 10 0 0
t$perf-norm:sp_reserve_write_off 8764 8764 0 0.00 0 8324 13 0 0
t$perf-norm:sp_supplier_invoice 4680 4680 0 0.00 0 1610 17 0 0
t$perf-norm:sp_supplier_order 4778 4778 0 0.00 0 5051 17 0 0
t$perf-norm:srv_aggregate_perf_data 84 84 0 0.00 0 131 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 522 11 0 0
t$perf-norm:srv_make_invnt_saldo 483 483 0 0.00 0 2581 30 0 0
t$perf-norm:srv_make_money_saldo 661 661 0 0.00 0 3217 26 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 8684 8522 162 1.86 0 6391 17 0 162
v_all_customers 32532 32532 0 0.00 0 24 1 0 0
v_all_suppliers 26716 26716 0 0.00 0 26 1 0 0
v_all_wares 35538 35538 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 712 712 0 0.00 0 266 5 0 0
v_cancel_client_order 3054 3054 0 0.00 0 1314 4 0 0
v_cancel_customer_prepayment 1114 1114 0 0.00 0 2522 9 0 0
v_cancel_customer_reserve 1176 1176 0 0.00 0 780 5 0 0
v_cancel_payment_to_supplier 734 734 0 0.00 0 525 6 0 0
v_cancel_supplier_invoice 670 662 8 1.19 0 2218 18 0 8
v_cancel_supplier_order 666 666 0 0.00 0 2318 11 0 0
v_cancel_write_off 1736 1736 0 0.00 0 4942 18 0 0
v_max_id_clo_ord 4778 4778 0 0.00 0 1003 2 0 0
v_max_id_clo_res 839 839 0 0.00 0 3210 11 0 0
v_max_id_ord_sup 4676 4676 0 0.00 0 2753 4 0 0
v_max_non_paid_invoice 1205 1205 0 0.00 0 1390 4 0 0
v_max_non_paid_realizn 3078 3078 0 0.00 0 546 3 0 0
v_min_id_clo_ord 4778 4778 0 0.00 0 15965 15 0 0
v_min_id_clo_res 839 839 0 0.00 0 4885 9 0 0
v_min_id_ord_sup 4676 4676 0 0.00 0 6540 5 0 0
v_min_non_paid_invoice 5109 5109 0 0.00 0 19598 32 0 0
v_min_non_paid_realizn 6096 6096 0 0.00 0 13400 35 0 0
v_our_firm 9042 9042 0 0.00 0 22 1 0 0
v_reserve_write_off 17528 17528 0 0.00 0 9899 8 0 0
x_lock_depdocs_on_canc_invoice 9035 9035 0 0.00 0 28425 142 0 0
x_lock_depdocs_on_canc_sup_ord 333 333 0 0.00 0 2913 308 0 0
x_make_qstorno_1000_1200 4778 4778 0 0.00 1 24693 1146 0 0
x_make_qstorno_1200_2000 4680 4680 0 0.00 2 91547 3272 0 0
x_make_qstorno_2100_3300 404051 404051 0 0.00 0 39274 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-03-2024 22:11:13 to 01-03-2024 22:11:17.

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:44 11 8192000000 8806770000 8820789248 10734960 0.130 4 2 3 0 10858816 65696 58160
20:10:45 29347 8192000000 9902461792 10213879808 986674496 10.749 100 93 186 0 1016460400 6201504 23584400
20:12:32 21302 8192000000 9940968928 10264489984 1024357312 11.114 100 91 182 0 1056407520 8662544 23387664
20:14:01 12991 8192000000 9984207648 10318389248 1068208768 11.535 100 82 164 0 1098495824 10111472 20175584
20:15:17 13247 8192000000 10026972880 10371248128 1112430464 11.955 100 84 165 1 1143347392 11377312 19539616
20:16:34 5485 8192000000 10069380928 10429194240 1164059824 12.441 100 78 154 0 1193138416 11559232 17519360
20:17:44 3336 8192000000 10123126656 10493390848 1209604880 12.865 100 77 154 0 1240732288 14355728 16771680
20:18:49 2209 8192000000 10155558352 10533097472 1248210464 13.222 100 79 157 0 1277795072 12321520 17263088
20:19:53 949 8192000000 10190541584 10572664832 1279267856 13.506 100 89 178 0 1311477744 12159664 20050224
20:20:56 4005 8192000000 10215522000 10600878080 1298196960 13.679 100 83 163 2 1328495248 12412512 17885776
20:22:03 1234 8192000000 10215919776 10607902720 1307102192 13.760 100 67 133 0 1333476560 11758368 14616000
20:23:05 5606 8192000000 10203088032 10611937280 1312900960 13.812 100 35 70 0 1329355216 8852528 7601728
20:24:12 10971 8192000000 10195707376 10614390784 1316274528 13.843 100 16 30 2 1325302416 5925744 3102144
20:25:26 8160 8192000000 10213259600 10628452352 1327343840 13.943 100 24 49 0 1338807808 6237680 5226288
20:26:35 61684 8192000000 10228947184 10644660224 1335797632 14.020 100 16 32 0 1344517504 4830704 3889168
20:28:38 4584 8192000000 10226203072 10643787776 1328151024 13.950 99 28 54 0 1340225184 6557440 5516720
20:29:44 6039 8192000000 10225680096 10640015360 1313249808 13.816 98 41 80 1 1328391280 6322112 8819360
20:30:58 48069 8192000000 10214462704 10627604480 1288777264 13.593 97 51 102 1 1309611712 9490240 11344208
20:32:55 1835 8192000000 10243998800 10647064576 1329018880 13.958 100 75 148 1 1357444944 12056000 16370064
20:34:02 19590 8192000000 10220495856 10625466368 1305171552 13.742 98 47 92 1 1328509408 13190448 10147408
20:35:27 13261 8192000000 10242352112 10644951040 1328749952 13.956 100 51 101 0 1352535168 12764000 11021216
20:36:44 15287 8192000000 10247540816 10653245440 1333527744 13.999 100 53 105 0 1359734320 14335200 11871376
20:38:08 8135 8192000000 10255598224 10661945344 1329078320 13.959 99 51 104 0 1357835376 16720256 12036800
20:39:22 5142 8192000000 10209666800 10615623680 1288756592 13.593 97 38 76 0 1311820480 13852320 9211568
20:40:31 14249 8192000000 10220035424 10623754240 1269347104 13.416 96 29 58 0 1296393520 19681744 7364672
20:41:51 10285 8192000000 10219298624 10614521856 1293820288 13.639 100 52 103 0 1327108864 20663872 12624704
20:43:08 12041 8192000000 10255238688 10659786752 1325596512 13.927 100 64 126 0 1370976528 30027504 15352512
20:44:31 15875 8192000000 10283153664 10688253952 1351318864 14.159 100 53 106 2 1392913728 28646368 12948496
20:46:10 5802 8192000000 10296847808 10702962688 1364661424 14.279 100 56 109 0 1403443904 24969776 13812704
20:47:27 1663 8192000000 10318334240 10724589568 1379369152 14.411 100 68 133 0 1424665456 29188624 16107680
20:48:36 1443 8192000000 10325997520 10735263744 1383153760 14.445 100 69 136 1 1430702768 31101920 16447088
20:49:41 3791 8192000000 10351336400 10755231744 1393473920 14.537 100 88 175 3 1452146704 37749968 20922816
20:50:50 1523 8192000000 10365486336 10772049920 1399434656 14.590 100 78 152 1 1461663456 43331520 18897280
20:51:59 4063 8192000000 10368373840 10778951680 1408841168 14.674 100 73 143 1 1467922256 41477440 17603648
20:53:06 21124 8192000000 10349113072 10773413888 1395483568 14.555 99 34 68 0 1445221600 40719968 9018064
20:54:35 13871 8192000000 10355908544 10788757504 1413148784 14.712 100 39 76 0 1469418256 44731568 11537904
20:55:51 15808 8192000000 10354612480 10792656896 1409509600 14.680 100 24 48 0 1462670528 46376384 6784544
20:57:19 5493 8192000000 10359467952 10785505280 1394904656 14.550 100 57 112 1 1468307792 57324176 16078960
20:58:31 8207 8192000000 10325570512 10776543232 1396507232 14.564 100 28 56 0 1434916960 31385856 7023872
20:59:45 23164 8192000000 10317696480 10756026368 1394435360 14.545 100 47 91 2 1417304352 11951056 10917936
21:01:12 11430 8192000000 10309445872 10761609216 1399114672 14.587 100 36 72 0 1422609856 14856544 8638640
21:02:34 89492 8192000000 10306405584 10765881344 1393278080 14.535 99 19 36 1 1405591744 7881920 4431744
21:05:12 161642 8192000000 10307190144 10780110848 1391651760 14.521 99 17 34 0 1412472128 16923440 3896928
21:09:03 87541 8192000000 10302566336 10754883584 1352027248 14.166 95 14 28 0 1367835024 12556432 3251344
21:11:34 13893 8192000000 10314123712 10757398528 1388575680 14.493 99 33 64 1 1413660544 17515168 7569696
21:12:55 25499 8192000000 10303184736 10760413184 1378776784 14.406 98 28 56 0 1403017728 17488960 6751984
21:14:29 40248 8192000000 10284250000 10734788608 1352199200 14.167 97 24 47 0 1371198080 13432512 5566368
21:16:52 56476 8192000000 10264636288 10710597632 1323068560 13.904 95 13 26 0 1334965600 9139504 2757536
21:18:50 48805 8192000000 10283304272 10728423424 1339732528 14.055 97 21 42 0 1356795392 12276624 4786240
21:20:49 28272 8192000000 10288847472 10727346176 1347549760 14.125 98 38 74 1 1363943856 8443760 7950336
21:22:18 81247 8192000000 10270322656 10726735872 1299021728 13.686 94 10 20 0 1319525840 18447968 2056144
21:24:42 121215 8192000000 10277896656 10736369664 1333030656 13.995 97 11 22 0 1355834048 20467872 2335520
21:27:46 25596 8192000000 10261524368 10699251712 1321992272 13.895 97 20 40 0 1334218112 7772096 4453744
21:29:24 9804 8192000000 10287979648 10715545600 1349088000 14.139 99 48 96 0 1370869296 11320032 10461264
21:30:34 17472 8192000000 10296748112 10729922560 1369055040 14.319 100 53 106 1 1394172768 13847184 11270544
21:31:53 72744 8192000000 10298645184 10744594432 1349529264 14.143 98 22 43 0 1373221280 18732192 4959824
21:34:11 90297 8192000000 10230700720 10675113984 1310758352 13.793 97 16 32 1 1336142784 22209264 3175168
21:36:42 73331 8192000000 10255498880 10706038784 1323736464 13.911 98 22 44 0 1346104640 17393968 4974208
21:38:56 52478 8192000000 10252434208 10709655552 1347230608 14.123 99 17 34 1 1358857088 8201072 3425408
21:40:52 44443 8192000000 10255817056 10710999040 1352360320 14.169 99 11 22 0 1360621408 6231392 2029696
21:42:39 66648 8192000000 10267370416 10727161856 1359235136 14.230 99 18 36 0 1370350496 7233168 3882192
21:45:34 38566 8192000000 10290742880 10740154368 1380156032 14.418 100 23 46 0 1391715264 6090768 5468464
21:47:14 68136 8192000000 10303811776 10760810496 1391808240 14.522 100 8 16 0 1406160144 12438816 1913088
21:49:24 49697 8192000000 10315818368 10774953984 1402012784 14.613 100 18 36 0 1417804656 11665024 4126848
21:51:21 69329 8192000000 10305414720 10767138816 1364441824 14.277 97 14 28 0 1381824560 14352448 3030288
21:53:33 39699 8192000000 10314076960 10761760768 1362332544 14.258 97 34 68 0 1388477696 18505344 7639808
21:55:17 82862 8192000000 10296954064 10752733184 1370696704 14.333 98 12 24 0 1387209696 13582576 2930416
21:57:41 113217 8192000000 10289177632 10743824384 1343076960 14.085 96 21 42 2 1356940208 9518400 4344848
22:00:50 70472 8192000000 10297010608 10763231232 1396669184 14.565 100 17 33 0 1411734528 10797440 4267904
22:03:02 51974 8192000000 10289539472 10762969088 1387473680 14.483 99 20 36 0 1403756944 12186944 4096320
22:06:02 86726 8192000000 10266969296 10717364224 1315568784 13.837 94 22 44 0 1334711760 13404000 5738976
22:08:29 54606 8192000000 10256586032 10706329600 1340048272 14.058 98 15 30 0 1355611920 12449424 3114224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 01-03-2024 22:11:19 to 01-03-2024 22:11:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 81 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-03-2024 22:11:34 to 01-03-2024 22:11:36.

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          176199
MON$OLDEST_ACTIVE               177698
MON$OLDEST_SNAPSHOT             177698
MON$NEXT_TRANSACTION            177698
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                       1912096
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.33733 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33733 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33733 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33733 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 Fri Mar  1 22:11:37 2024 
 
Database header page information: 
    Flags            0 
    Generation        92871 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    176199 
    Oldest active        177698 
    Oldest snapshot        177698 
    Next transaction    177699 
    Sequence number        0 
    Next attachment ID    716 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.45, total records: 7742937 
    Average version length: 48.16, total versions: 71858, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87200 
    Data pages: 87200, average fill: 71% 
    Primary pages: 87200, secondary pages: 0, swept pages: 25231 
    Empty pages: 8, full pages: 59335 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 256 
    40 - 59% = 3211 
    60 - 79% = 83672 
    80 - 99% = 22 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23201, nodes: 7742937 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1698364, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 270 
        20 - 39% = 1902 
        40 - 59% = 4046 
        60 - 79% = 2346 
        80 - 99% = 14637 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13508, nodes: 7742937 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1521382, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1671 
        40 - 59% = 1943 
        60 - 79% = 1079 
        80 - 99% = 8815 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8326, nodes: 7742937 
    Average node length: 6.62, total dup: 5789941, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1514285, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 1042 
        40 - 59% = 1308 
        60 - 79% = 920 
        80 - 99% = 4943 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.53, total records: 2243565 
    Average version length: 34.77, total versions: 71014, max versions: 3 
    Average fragment length: 3.33, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28552 
    Data pages: 28552, average fill: 73% 
    Primary pages: 28545, secondary pages: 7, swept pages: 12213 
    Empty pages: 12, full pages: 19042 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 141 
    40 - 59% = 1699 
    60 - 79% = 26226 
    80 - 99% = 457 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4559, nodes: 2243565 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 685917, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 991 
        40 - 59% = 783 
        60 - 79% = 683 
        80 - 99% = 2102 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2516, nodes: 2245909 
    Average node length: 4.97, total dup: 2245010, max dup: 19426 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1249406, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 252 
        40 - 59% = 1539 
        60 - 79% = 549 
        80 - 99% = 173 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2039, nodes: 2243565 
    Average node length: 4.97, total dup: 2243515, max dup: 130415 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061932, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 95 
        40 - 59% = 1057 
        60 - 79% = 41 
        80 - 99% = 842 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4370, nodes: 2243565 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 685917, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 109 
        20 - 39% = 660 
        40 - 59% = 572 
        60 - 79% = 790 
        80 - 99% = 2239 
 
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.22, total records: 400 
    Average version length: 22.86, total versions: 237108, max versions: 620 
    Average fragment length: 2.00, total fragments: 61, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1304 
    Data pages: 1304, average fill: 90% 
    Primary pages: 8, secondary pages: 1296, swept pages: 0 
    Empty pages: 1, full pages: 1302 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1302 
 
    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: 3.57, total records: 99716 
    Average version length: 68.29, total versions: 94504, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 24.62 
    Pointer pages: 7, data page slots: 2400 
    Data pages: 2160, average fill: 59% 
    Primary pages: 2159, secondary pages: 1, swept pages: 0 
    Empty pages: 384, full pages: 1110 
    Fill distribution: 
     0 - 19% = 524 
    20 - 39% = 207 
    40 - 59% = 203 
    60 - 79% = 212 
    80 - 99% = 1014 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1709128, depth: 3, leaf buckets: 408, nodes: 99716 
    Average node length: 13.36, total dup: 7262, max dup: 2 
    Average key length: 10.68, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 70101, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 198 
        40 - 59% = 205 
        60 - 79% = 2 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 18490, max versions: 939 
    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: 82% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 61 
 
    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: 1.02, total records: 2264 
    Average version length: 43.52, total versions: 2211, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 56.80 
    Pointer pages: 1, data page slots: 32 
    Data pages: 30, average fill: 73% 
    Primary pages: 29, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 20 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91299, depth: 2, leaf buckets: 3, nodes: 2264 
    Average node length: 4.23, total dup: 2166, max dup: 237 
    Average key length: 2.47, compression ratio: 7.70 
    Average prefix length: 18.58, average data length: 0.42 
    Clustering factor: 1132, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.10, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.10, total records: 802885 
    Average version length: 25.63, total versions: 67454, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8312 
    Data pages: 8288, average fill: 68% 
    Primary pages: 8251, secondary pages: 37, swept pages: 1883 
    Empty pages: 133, full pages: 7007 
    Fill distribution: 
     0 - 19% = 292 
    20 - 39% = 241 
    40 - 59% = 266 
    60 - 79% = 7206 
    80 - 99% = 283 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 909, nodes: 802885 
    Average node length: 4.87, total dup: 802836, max dup: 151634 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87178, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 158 
        40 - 59% = 513 
        60 - 79% = 180 
        80 - 99% = 57 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 910, nodes: 802885 
    Average node length: 5.88, total dup: 714924, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158255, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 95 
        40 - 59% = 349 
        60 - 79% = 134 
        80 - 99% = 329 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 949, nodes: 802885 
    Average node length: 5.88, total dup: 714924, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160174, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 182 
        40 - 59% = 325 
        60 - 79% = 108 
        80 - 99% = 334 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1120, nodes: 802885 
    Average node length: 5.96, total dup: 714924, max dup: 43 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152568, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 227 
        40 - 59% = 583 
        60 - 79% = 201 
        80 - 99% = 108 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5413 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.91, total fragments: 47, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 112 
    Data pages: 104, average fill: 52% 
    Primary pages: 83, secondary pages: 21, swept pages: 55 
    Empty pages: 20, full pages: 62 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5413 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 9.99 
    Average prefix length: 34.31, average data length: 1.56 
    Clustering factor: 5168, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5413 
    Average node length: 11.11, 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: 150, 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: 81029 
    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: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 780 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 780 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38009, depth: 2, leaf buckets: 105, nodes: 81029 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3352, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 1 
        80 - 99% = 100 
 
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: 111.12, 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.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    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: 131.27, total records: 174779 
    Average version length: 154.41, total versions: 22522, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.92 
    Pointer pages: 6, data page slots: 5368 
    Data pages: 4232, average fill: 86% 
    Primary pages: 4232, secondary pages: 0, swept pages: 6 
    Empty pages: 72, full pages: 4135 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 4136 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 129.74, total records: 204780 
    Average version length: 154.66, total versions: 29192, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.07 
    Pointer pages: 7, data page slots: 5544 
    Data pages: 4968, average fill: 86% 
    Primary pages: 4968, secondary pages: 0, swept pages: 2 
    Empty pages: 79, full pages: 4860 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 9 
    40 - 59% = 11 
    60 - 79% = 5 
    80 - 99% = 4861 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.56, total records: 169240 
    Average version length: 149.72, total versions: 4957, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 7, data page slots: 5832 
    Data pages: 4088, average fill: 85% 
    Primary pages: 4088, secondary pages: 0, swept pages: 7 
    Empty pages: 65, full pages: 3999 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 3998 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 145.95, total records: 185939 
    Average version length: 153.37, total versions: 6450, 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: 5800 
    Data pages: 4544, average fill: 85% 
    Primary pages: 4544, secondary pages: 0, swept pages: 2 
    Empty pages: 110, full pages: 4391 
    Fill distribution: 
     0 - 19% = 117 
    20 - 39% = 10 
    40 - 59% = 7 
    60 - 79% = 18 
    80 - 99% = 4392 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.44, total records: 163685 
    Average version length: 148.31, total versions: 1833, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 5408 
    Data pages: 3976, average fill: 85% 
    Primary pages: 3976, secondary pages: 0, swept pages: 1 
    Empty pages: 82, full pages: 3870 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3871 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 130.78, total records: 201127 
    Average version length: 154.62, total versions: 27060, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.97 
    Pointer pages: 7, data page slots: 5200 
    Data pages: 4824, average fill: 87% 
    Primary pages: 4824, secondary pages: 0, swept pages: 1 
    Empty pages: 34, full pages: 4776 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4777 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 124.18, total records: 187494 
    Average version length: 154.52, total versions: 33118, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.66 
    Pointer pages: 8, data page slots: 5528 
    Data pages: 4560, average fill: 86% 
    Primary pages: 4560, secondary pages: 0, swept pages: 1 
    Empty pages: 88, full pages: 4442 
    Fill distribution: 
     0 - 19% = 98 
    20 - 39% = 3 
    40 - 59% = 15 
    60 - 79% = 1 
    80 - 99% = 4443 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 120.83, total records: 189833 
    Average version length: 154.79, total versions: 37623, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.04 
    Pointer pages: 6, data page slots: 5344 
    Data pages: 4560, average fill: 88% 
    Primary pages: 4560, secondary pages: 0, swept pages: 3 
    Empty pages: 39, full pages: 4508 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4506 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.80, total records: 181343 
    Average version length: 150.63, total versions: 4017, 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: 7, data page slots: 5472 
    Data pages: 4360, average fill: 86% 
    Primary pages: 4360, secondary pages: 0, swept pages: 3 
    Empty pages: 48, full pages: 4290 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 4290 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 140.05, total records: 178866 
    Average version length: 153.73, total versions: 12974, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.11 
    Pointer pages: 7, data page slots: 6336 
    Data pages: 4328, average fill: 86% 
    Primary pages: 4327, secondary pages: 1, swept pages: 1 
    Empty pages: 63, full pages: 4224 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 13 
    40 - 59% = 18 
    60 - 79% = 9 
    80 - 99% = 4223 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.86, total records: 2105900 
    Average version length: 52.94, total versions: 35478, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25800 
    Data pages: 25800, average fill: 70% 
    Primary pages: 25800, secondary pages: 0, swept pages: 11570 
    Empty pages: 351, full pages: 20253 
    Fill distribution: 
     0 - 19% = 649 
    20 - 39% = 521 
    40 - 59% = 1302 
    60 - 79% = 23028 
    80 - 99% = 300 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2624, nodes: 2105900 
    Average node length: 5.44, total dup: 1964559, max dup: 1222 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182082, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 302 
        40 - 59% = 1768 
        60 - 79% = 283 
        80 - 99% = 268 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2762, nodes: 2105900 
    Average node length: 5.69, total dup: 1890145, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375859, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2394 
        60 - 79% = 340 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2159, nodes: 2105900 
    Average node length: 4.96, total dup: 2105800, max dup: 27659 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180016, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 197 
        40 - 59% = 1202 
        60 - 79% = 346 
        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: 40.73, total records: 136534 
    Average version length: 69.17, total versions: 56199, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.09 
    Pointer pages: 3, data page slots: 4640 
    Data pages: 3560, average fill: 45% 
    Primary pages: 3560, secondary pages: 0, swept pages: 861 
    Empty pages: 972, full pages: 1542 
    Fill distribution: 
     0 - 19% = 1377 
    20 - 39% = 307 
    40 - 59% = 241 
    60 - 79% = 537 
    80 - 99% = 1098 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 100511, depth: 3, leaf buckets: 210, nodes: 136534 
    Average node length: 6.40, total dup: 118683, max dup: 14 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22736, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 47 
        40 - 59% = 100 
        60 - 79% = 54 
        80 - 99% = 9 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.97, total records: 7043287 
    Average version length: 68.76, total versions: 306237, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 63, data page slots: 101888 
    Data pages: 101888, average fill: 74% 
    Primary pages: 101888, secondary pages: 0, swept pages: 33529 
    Empty pages: 32, full pages: 76573 
    Fill distribution: 
     0 - 19% = 123 
    20 - 39% = 824 
    40 - 59% = 6860 
    60 - 79% = 89756 
    80 - 99% = 4325 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10624, nodes: 7043287 
    Average node length: 6.51, total dup: 6092541, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1565210, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1656 
        40 - 59% = 5756 
        60 - 79% = 2705 
        80 - 99% = 506 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8435, nodes: 7043287 
    Average node length: 5.39, total dup: 6763798, max dup: 134 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1366582, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1213 
        40 - 59% = 4584 
        60 - 79% = 1502 
        80 - 99% = 1133 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8471, nodes: 7043287 
    Average node length: 5.39, total dup: 6763798, max dup: 134 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1369160, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1287 
        40 - 59% = 4545 
        60 - 79% = 1497 
        80 - 99% = 1137 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.57, total records: 12024881 
    Average version length: 68.75, total versions: 243197, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 104, data page slots: 168400 
    Data pages: 168400, average fill: 76% 
    Primary pages: 168400, secondary pages: 0, swept pages: 86576 
    Empty pages: 8, full pages: 150207 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 560 
    40 - 59% = 4706 
    60 - 79% = 159146 
    80 - 99% = 3945 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18326, nodes: 12024881 
    Average node length: 6.58, total dup: 10482624, max dup: 58 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2372004, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 2329 
        40 - 59% = 10738 
        60 - 79% = 4413 
        80 - 99% = 816 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 44.94, total records: 1475324 
    Average version length: 69.10, total versions: 516598, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.80 
    Pointer pages: 27, data page slots: 42800 
    Data pages: 29701, average fill: 57% 
    Primary pages: 29700, secondary pages: 1, swept pages: 10256 
    Empty pages: 4018, full pages: 16390 
    Fill distribution: 
     0 - 19% = 6816 
    20 - 39% = 2677 
    40 - 59% = 2162 
    60 - 79% = 10596 
    80 - 99% = 7450 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2112, nodes: 1475324 
    Average node length: 5.53, total dup: 1415427, max dup: 99 
    Average key length: 2.57, compression ratio: 16.36 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 99080, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 715 
        40 - 59% = 923 
        60 - 79% = 361 
        80 - 99% = 97 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 41.23, total records: 1151200 
    Average version length: 69.14, total versions: 463540, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.06 
    Pointer pages: 23, data page slots: 36192 
    Data pages: 30352, average fill: 44% 
    Primary pages: 30352, secondary pages: 0, swept pages: 9540 
    Empty pages: 7761, full pages: 12521 
    Fill distribution: 
     0 - 19% = 12129 
    20 - 39% = 2780 
    40 - 59% = 1774 
    60 - 79% = 4105 
    80 - 99% = 9564 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1544, nodes: 1151200 
    Average node length: 5.79, total dup: 1074418, max dup: 100 
    Average key length: 2.86, compression ratio: 14.70 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 155814, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 344 
        40 - 59% = 680 
        60 - 79% = 386 
        80 - 99% = 133 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.02, total records: 9111327 
    Average version length: 68.97, total versions: 379731, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 89, data page slots: 144424 
    Data pages: 144400, average fill: 67% 
    Primary pages: 144399, secondary pages: 1, swept pages: 69126 
    Empty pages: 483, full pages: 73173 
    Fill distribution: 
     0 - 19% = 1498 
    20 - 39% = 7167 
    40 - 59% = 25358 
    60 - 79% = 105306 
    80 - 99% = 5071 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13499, nodes: 9111327 
    Average node length: 6.68, total dup: 7558675, max dup: 21 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1950514, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1531 
        40 - 59% = 6836 
        60 - 79% = 4456 
        80 - 99% = 673 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21166108 
    Average version length: 83.03, total versions: 9971, 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: 319088 
    Data pages: 319088, average fill: 81% 
    Primary pages: 319088, secondary pages: 0, swept pages: 12961 
    Empty pages: 51, full pages: 318143 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 45 
    40 - 59% = 128 
    60 - 79% = 27682 
    80 - 99% = 291146 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19377, nodes: 21166108 
    Average node length: 5.72, total dup: 20684774, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281804, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 3 
        40 - 59% = 8093 
        60 - 79% = 563 
        80 - 99% = 10713 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17193, nodes: 21166108 
    Average node length: 6.31, total dup: 18600311, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914294, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 6 
        40 - 59% = 788 
        60 - 79% = 277 
        80 - 99% = 16118 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21150, nodes: 21166108 
    Average node length: 6.35, total dup: 18519524, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3577140, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8337 
        60 - 79% = 644 
        80 - 99% = 12163 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16167, nodes: 21166108 
    Average node length: 5.56, total dup: 21166008, max dup: 229813 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943160, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2960 
        60 - 79% = 437 
        80 - 99% = 12762 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.83, total records: 9609329 
    Average version length: 82.65, total versions: 418047, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 105, data page slots: 170264 
    Data pages: 170216, average fill: 70% 
    Primary pages: 170216, secondary pages: 0, swept pages: 83752 
    Empty pages: 556, full pages: 95478 
    Fill distribution: 
     0 - 19% = 1866 
    20 - 39% = 7659 
    40 - 59% = 26650 
    60 - 79% = 78180 
    80 - 99% = 55861 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11398, nodes: 9609329 
    Average node length: 5.36, total dup: 9300992, max dup: 171 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2103450, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 94 
        40 - 59% = 8563 
        60 - 79% = 2664 
        80 - 99% = 75 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13406, nodes: 9609329 
    Average node length: 6.23, total dup: 7966052, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1448738, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 4022 
        40 - 59% = 4228 
        60 - 79% = 2523 
        80 - 99% = 2517 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12722, nodes: 9609329 
    Average node length: 5.98, total dup: 8335196, max dup: 41 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2294229, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 110 
        40 - 59% = 9559 
        60 - 79% = 2960 
        80 - 99% = 92 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10099, nodes: 9609329 
    Average node length: 5.13, total dup: 9609229, max dup: 157221 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1480020, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1306 
        40 - 59% = 5068 
        60 - 79% = 1658 
        80 - 99% = 2037 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.27, total records: 11229328 
    Average version length: 82.58, total versions: 276324, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 119, data page slots: 194136 
    Data pages: 192192, average fill: 72% 
    Primary pages: 192192, secondary pages: 0, swept pages: 76978 
    Empty pages: 3660, full pages: 138708 
    Fill distribution: 
     0 - 19% = 6314 
    20 - 39% = 8790 
    40 - 59% = 19519 
    60 - 79% = 44102 
    80 - 99% = 113467 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13134, nodes: 11229328 
    Average node length: 5.30, total dup: 11119774, max dup: 677 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2333897, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 147 
        40 - 59% = 9430 
        60 - 79% = 3434 
        80 - 99% = 123 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10390, nodes: 11229328 
    Average node length: 5.50, total dup: 10738968, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 702716, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 892 
        40 - 59% = 2498 
        60 - 79% = 1889 
        80 - 99% = 4964 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15022, nodes: 11229328 
    Average node length: 6.03, total dup: 9798430, max dup: 63 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2350308, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 208 
        40 - 59% = 10865 
        60 - 79% = 3802 
        80 - 99% = 144 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10615, nodes: 11229328 
    Average node length: 5.22, total dup: 11229228, max dup: 203614 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 691785, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 830 
        40 - 59% = 4646 
        60 - 79% = 1439 
        80 - 99% = 3615 
 
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: 79.31, total records: 9708875 
    Average version length: 82.95, total versions: 402257, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 106, data page slots: 172560 
    Data pages: 172504, average fill: 70% 
    Primary pages: 172504, secondary pages: 0, swept pages: 88834 
    Empty pages: 512, full pages: 94356 
    Fill distribution: 
     0 - 19% = 1802 
    20 - 39% = 7334 
    40 - 59% = 27120 
    60 - 79% = 82136 
    80 - 99% = 54112 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11825, nodes: 9708875 
    Average node length: 5.17, total dup: 9679604, max dup: 1528 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1897950, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1583 
        40 - 59% = 7886 
        60 - 79% = 1766 
        80 - 99% = 556 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13477, nodes: 9708875 
    Average node length: 6.24, total dup: 8048389, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1411548, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 3979 
        40 - 59% = 4119 
        60 - 79% = 2546 
        80 - 99% = 2657 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12453, nodes: 9708875 
    Average node length: 5.43, total dup: 9270967, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2031409, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1534 
        40 - 59% = 8763 
        60 - 79% = 1605 
        80 - 99% = 530 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10165, nodes: 9708875 
    Average node length: 5.14, total dup: 9708775, max dup: 159743 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1495259, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1267 
        40 - 59% = 5063 
        60 - 79% = 1736 
        80 - 99% = 2060 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.54, total records: 580428 
    Average version length: 68.85, total versions: 5406, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8040, average fill: 76% 
    Primary pages: 8040, secondary pages: 0, swept pages: 4067 
    Empty pages: 7, full pages: 6829 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 7 
    40 - 59% = 165 
    60 - 79% = 7784 
    80 - 99% = 77 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 50513, depth: 3, leaf buckets: 747, nodes: 580428 
    Average node length: 5.95, total dup: 494166, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101067, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 528 
        60 - 79% = 112 
        80 - 99% = 78 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 39872, depth: 3, leaf buckets: 770, nodes: 580428 
    Average node length: 6.15, total dup: 476125, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101116, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 552 
        60 - 79% = 102 
        80 - 99% = 89 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 588, nodes: 580428 
    Average node length: 4.86, total dup: 580328, max dup: 9819 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89709, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 360 
        60 - 79% = 84 
        80 - 99% = 113 
 
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 Fri Mar  1 22:12:00 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7742937 71858 1 0.0000 0.0000
DOC_LIST 2243565 71014 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 237108 620 59200.0000 0.0000
INVNT_TURNOVER_LOG 99716 94504 1 0.0000 0.0000
MONEY_SALDO 49 18490 939 37700.0000 0.0000
MONEY_TURNOVER_LOG 2264 2211 1 0.0000 0.0000
PDISTR 802885 67454 4 0.0000 0.0000
PERF_SPLIT_0 174779 22522 1 0.0000 0.0000
PERF_SPLIT_1 204780 29192 1 0.0000 0.0000
PERF_SPLIT_2 169240 4957 1 0.0000 0.0000
PERF_SPLIT_3 185939 6450 1 0.0000 0.0000
PERF_SPLIT_4 163685 1833 1 0.0000 0.0000
PERF_SPLIT_5 201127 27060 1 0.0000 0.0000
PERF_SPLIT_6 187494 33118 1 0.0000 0.0000
PERF_SPLIT_7 189833 37623 1 0.0000 0.0000
PERF_SPLIT_8 181343 4017 1 0.0000 0.0000
PERF_SPLIT_9 178866 12974 1 0.0000 0.0000
PSTORNED 2105900 35478 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 136534 56199 1 0.0000 0.0000
XQD_1000_3300 7043287 306237 1 0.0000 0.0000
XQD_1200_2000 12024881 243197 1 0.0000 0.0000
XQD_2000_3300 1475324 516598 1 0.0000 0.0000
XQD_2100_3300 1151200 463540 1 0.0000 0.0000
XQD_3300_3400 9111327 379731 1 0.0000 0.0000
XQS_1000_1200 21166108 9971 1 0.0000 0.0000
XQS_1000_3300 9609329 418047 1 0.0000 0.0000
XQS_1200_2000 11229328 276324 1 0.0000 0.0000
XQS_2100_3300 9708875 402257 1 0.0000 0.0000
XQS_3300_3400 580428 5406 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 ---
:20: 
:21: mscs-test-161.budzdorov.ru    Fri Mar  1 22:09:49 2024
:22:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:23: 
:24: 
:25: mscs-test-161.budzdorov.ru    Fri Mar  1 22:09:51 2024
:26:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:27: 
:28: 
:29: mscs-test-161.budzdorov.ru    Fri Mar  1 22:09:51 2024
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Fri Mar  1 22:09:52 2024
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
--- end of diff output ---

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

01.03.24 22:12:12. 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-01 22:12:15 No severe PSQL-related problems occured
01.03.24 22:12:16. End of report.