Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.03.2024 16: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 15597288 kB
MemAvailable 30275636 kB
Buffers 0 kB
Cached 16128096 kB
SwapCached 2568 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-18 16:09:46
DTS_END                         2024-03-18 16:09:46.6260
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/56860
TRN_ID                          183224
ATT_ID                          600
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: 9456.99 17622 945699
customer order: creation 186.03 370 18603
customer order: refuse 15.54 356 1554
order to supplier: creation 47.91 1231 4791
order to supplier: removal 3.56 94119 356
invoice (draft): creation 49.55 3056 4955
invoice (draft): removal 50.87 785 5087
invoice accept: apply 44.53 20796 4453
invoice accept: cancel 45.90 793 4590
customer reserve: creation 4248.93 202 424893
customer reserve: removal 4454.45 57 445445
realization accept: apply 91.00 177 9100
realization accept: cancel 78.90 137 7890
payment from customer: creation 64.00 148 6400
payment from customer: removal 6.25 82 625
payment to supplier: creation 52.01 161 5201
payment to supplier: removal 3.71 107 371
service: total inventory turnovers 5.40 1052 540
service: total monetary turnovers 7.47 35 747
service: aggregate perf. data 0.95 18495 95
service: refresh index statistics 0.03 210288 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 18-03-2024 16:10:40 to 18-03-2024 16:10:43.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1978
TEST_TIME 2 2584
TEST_TIME 3 3635
TEST_TIME 4 3779
TEST_TIME 5 4008
TEST_TIME 6 4072
TEST_TIME 7 4497
TEST_TIME 8 4315
TEST_TIME 9 4554
TEST_TIME 10 4631
TEST_TIME 11 5118
TEST_TIME 12 5456
TEST_TIME 13 5958
TEST_TIME 14 6373
TEST_TIME 15 6653
TEST_TIME 16 6771
TEST_TIME 17 6801
TEST_TIME 18 6877
TEST_TIME 19 6907
TEST_TIME 20 7325
TEST_TIME 21 7385
TEST_TIME 22 7667
TEST_TIME 23 7988
TEST_TIME 24 7916
TEST_TIME 25 7764
TEST_TIME 26 8466
TEST_TIME 27 8975
TEST_TIME 28 9449
TEST_TIME 29 9414
TEST_TIME 30 9333
TEST_TIME 31 9114
TEST_TIME 32 9439
TEST_TIME 33 9669
TEST_TIME 34 9562
TEST_TIME 35 9514
TEST_TIME 36 9424
TEST_TIME 37 9401
TEST_TIME 38 9551
TEST_TIME 39 9524
TEST_TIME 40 9545
TEST_TIME 41 9655
TEST_TIME 42 9591
TEST_TIME 43 9630
TEST_TIME 44 9706
TEST_TIME 45 9732
TEST_TIME 46 9579
TEST_TIME 47 9466
TEST_TIME 48 9367
TEST_TIME 49 9377
TEST_TIME 50 9450
TEST_TIME 51 9401
TEST_TIME 52 9423
TEST_TIME 53 9333
TEST_TIME 54 9341
TEST_TIME 55 9503
TEST_TIME 56 9496
TEST_TIME 57 9426
TEST_TIME 58 9405
TEST_TIME 59 9288
TEST_TIME 60 9259
TEST_TIME 61 9258
TEST_TIME 62 9214
TEST_TIME 63 9211
TEST_TIME 64 9124
TEST_TIME 65 9076
TEST_TIME 66 9124
TEST_TIME 67 9173
TEST_TIME 68 9137
TEST_TIME 69 9172
TEST_TIME 70 9297
TEST_TIME 71 9308
TEST_TIME 72 9356
TEST_TIME 73 9403
TEST_TIME 74 9421
TEST_TIME 75 9426
TEST_TIME 76 9504
TEST_TIME 77 9535
TEST_TIME 78 9544
TEST_TIME 79 9609
TEST_TIME 80 9619
TEST_TIME 81 9515
TEST_TIME 82 9455
TEST_TIME 83 9462
TEST_TIME 84 9423
TEST_TIME 85 9487
TEST_TIME 86 9448
TEST_TIME 87 9402
TEST_TIME 88 9354
TEST_TIME 89 9335
TEST_TIME 90 9369
TEST_TIME 91 9342
TEST_TIME 92 9341
TEST_TIME 93 9388
TEST_TIME 94 9400
TEST_TIME 95 9375
TEST_TIME 96 9392
TEST_TIME 97 9400
TEST_TIME 98 9390
TEST_TIME 99 9442
TEST_TIME 100 9462

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-03-2024 16:10:44 to 18-03-2024 16:10:47.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1333684 1333684 0 0.00 0 22152 8 0 0
doc_list_biud 1333682 1333682 0 0.00 0 20426 25 0 0
sp_add_invoice_to_stock 4561 4453 108 2.36 50 212276 20797 0 108
sp_cancel_adding_invoice 4590 4590 0 0.00 4 70012 793 0 0
sp_cancel_client_order 1554 1554 0 0.00 4 12037 356 0 0
sp_cancel_customer_reserve 445445 445445 0 0.00 0 20427 58 0 0
sp_cancel_pay_from_customer 625 625 0 0.00 2 3794 83 0 0
sp_cancel_pay_to_supplier 371 371 0 0.00 2 6480 108 0 0
sp_cancel_supplier_invoice 5093 5087 6 0.11 2 13392 785 0 6
sp_cancel_supplier_order 356 356 0 0.00 6 989320 94120 0 0
sp_cancel_write_off 7890 7890 0 0.00 1 11930 137 0 0
sp_client_order 18603 18603 0 0.00 3 63329 370 0 0
sp_customer_reserve 424893 424893 0 0.00 0 88578 202 0 0
sp_fill_shopping_cart 28347 28347 0 0.00 1 15682 36 0 0
sp_fill_shopping_cart_clo_res 424889 424889 0 0.00 0 29916 15 0 0
sp_get_clo_for_invoice 4449 4449 0 0.00 0 22762 242 0 0
sp_kill_cost_storno 13476 13476 0 0.00 0 9191 67 0 0
sp_kill_qstorno_ret_qs2qd 904223 904223 0 0.00 0 20415 31 0 0
sp_kill_qty_storno 478471 478471 0 0.00 0 20425 68 0 0
sp_lock_selected_doc 18637 18637 0 0.00 0 7584 6 0 0
sp_make_cost_storno 25150 25150 0 0.00 0 22151 66 0 0
sp_multiply_rows_for_pdistr 25150 25150 0 0.00 0 11142 31 0 0
sp_multiply_rows_for_qdistr 18603 18603 0 0.00 0 15201 135 0 0
sp_pay_from_customer 6400 6400 0 0.00 4 11104 148 0 0
sp_pay_to_supplier 5201 5201 0 0.00 4 22157 162 0 0
sp_payment_common 11601 11601 0 0.00 1 8174 35 0 0
sp_qd_handle_on_cancel_clo 1554 1554 0 0.00 0 12030 323 0 0
sp_qd_handle_on_invoice_upd_sts 9039 9039 0 0.00 0 17557 324 0 0
sp_qd_handle_on_reserve_upd_sts 9100 9100 0 0.00 0 10778 46 0 0
sp_reserve_write_off 9100 9100 0 0.00 6 12899 177 0 0
sp_supplier_invoice 4955 4955 0 0.00 6 97864 3056 0 0
sp_supplier_order 4791 4791 0 0.00 6 47464 1231 0 0
srv_aggregate_perf_data 95 95 0 0.00 2356 196065 18495 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1109 188793 41485 0 0
srv_find_qd_qs_mism 899780 899780 0 0.00 0 12098 7 0 0
srv_make_invnt_saldo 540 540 0 0.00 27 119507 1053 0 0
srv_make_money_saldo 747 747 0 0.00 0 3087 35 0 0
srv_recalc_idx_stat 3 3 0 0.00 164303 267314 210288 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4455 4455 0 0.00 0 13809 180 0 0
t$perf-norm:sp_cancel_adding_invoice 330 330 0 0.00 0 2117 93 0 0
t$perf-norm:sp_cancel_client_order 1554 1554 0 0.00 0 2622 16 0 0
t$perf-norm:sp_cancel_customer_reserve 635 635 0 0.00 0 4813 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 625 625 0 0.00 0 7795 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 371 371 0 0.00 0 344 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 335 335 0 0.00 0 627 15 0 0
t$perf-norm:sp_cancel_supplier_order 356 356 0 0.00 0 28259 1817 0 0
t$perf-norm:sp_cancel_write_off 882 882 0 0.00 0 1440 6 0 0
t$perf-norm:sp_client_order 18603 18603 0 0.00 0 13845 18 0 0
t$perf-norm:sp_customer_reserve 896 896 0 0.00 0 3204 8 0 0
t$perf-norm:sp_pay_from_customer 6400 6400 0 0.00 0 5669 11 0 0
t$perf-norm:sp_pay_to_supplier 5201 5201 0 0.00 0 14410 14 0 0
t$perf-norm:sp_reserve_write_off 9100 9100 0 0.00 0 9108 11 0 0
t$perf-norm:sp_supplier_invoice 4955 4955 0 0.00 0 5455 18 0 0
t$perf-norm:sp_supplier_order 4791 4791 0 0.00 0 5531 18 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 203 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 7 1 0 0
t$perf-norm:srv_make_invnt_saldo 540 540 0 0.00 0 1180 28 0 0
t$perf-norm:srv_make_money_saldo 747 747 0 0.00 0 1763 20 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 34 12 0 0
v_add_invoice_to_stock 9114 8898 216 2.36 0 6853 18 0 216
v_all_customers 34010 34010 0 0.00 0 19 1 0 0
v_all_suppliers 27492 27492 0 0.00 0 27 1 0 0
v_all_wares 37204 37204 0 0.00 0 99 1 0 0
v_cancel_adding_invoice 660 660 0 0.00 0 6779 17 0 0
v_cancel_client_order 3108 3108 0 0.00 0 6749 8 0 0
v_cancel_customer_prepayment 1250 1250 0 0.00 0 1914 6 0 0
v_cancel_customer_reserve 1270 1270 0 0.00 0 6001 16 0 0
v_cancel_payment_to_supplier 742 742 0 0.00 0 5039 12 0 0
v_cancel_supplier_invoice 682 670 12 1.75 0 1454 19 0 12
v_cancel_supplier_order 712 712 0 0.00 0 800 4 0 0
v_cancel_write_off 1764 1764 0 0.00 0 6888 27 0 0
v_max_id_clo_ord 4791 4791 0 0.00 0 2524 2 0 0
v_max_id_clo_res 896 896 0 0.00 0 2851 14 0 0
v_max_id_ord_sup 4954 4954 0 0.00 0 7246 4 0 0
v_max_non_paid_invoice 1200 1200 0 0.00 0 760 4 0 0
v_max_non_paid_realizn 3283 3283 0 0.00 0 1930 6 0 0
v_min_id_clo_ord 4791 4791 0 0.00 0 4393 12 0 0
v_min_id_clo_res 896 896 0 0.00 0 5944 10 0 0
v_min_id_ord_sup 4954 4954 0 0.00 0 6528 6 0 0
v_min_non_paid_invoice 5201 5201 0 0.00 0 7292 25 0 0
v_min_non_paid_realizn 6400 6400 0 0.00 0 7729 26 0 0
v_our_firm 9428 9428 0 0.00 0 21 1 0 0
v_reserve_write_off 18200 18200 0 0.00 0 6988 7 0 0
x_lock_depdocs_on_canc_invoice 9342 9342 0 0.00 0 23274 136 0 0
x_lock_depdocs_on_canc_sup_ord 356 356 0 0.00 0 3781 322 0 0
x_make_qstorno_1000_1200 4791 4791 0 0.00 1 47454 1146 0 0
x_make_qstorno_1200_2000 4955 4955 0 0.00 3 91897 2934 0 0
x_make_qstorno_2100_3300 424893 424893 0 0.00 0 88576 184 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 18-03-2024 16:10:48 to 18-03-2024 16:10:53.

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
14:09:50 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:51 24802 8192000000 9900008816 10211614720 982109024 10.705 100 86 172 0 1011155536 5924000 23122512
14:12:19 18814 8192000000 9948854272 10271404032 1031579168 11.184 100 86 172 0 1060974576 7695472 21699936
14:13:42 20995 8192000000 9975992672 10307731456 1059085168 11.448 100 89 178 0 1090699312 9324640 22289504
14:15:09 7402 8192000000 10013817584 10359201792 1105439008 11.889 100 74 148 0 1132817216 10016448 17361760
14:16:19 8794 8192000000 10067844544 10423255040 1155624800 12.362 100 75 149 0 1183811136 11045792 17140544
14:17:29 3798 8192000000 10111139856 10470547456 1192426688 12.706 100 83 166 0 1225225984 14484272 18315024
14:18:34 2478 8192000000 10140867392 10516099072 1229707504 13.051 100 72 144 0 1257800176 11970304 16122368
14:19:39 1638 8192000000 10181017968 10556645376 1263583648 13.363 100 91 184 1 1297566096 14219856 19762592
14:20:41 910 8192000000 10207039104 10592063488 1291918096 13.622 100 92 183 1 1325222736 12854768 20449872
14:21:44 36804 8192000000 10182942784 10595094528 1301744960 13.711 100 37 74 2 1316597952 6935600 7917392
14:23:34 6484 8192000000 10197413984 10611892224 1313440384 13.817 100 23 45 0 1324353728 5529168 5384176
14:24:45 15092 8192000000 10206196160 10625335296 1320740944 13.883 100 15 28 0 1328930608 5102496 3087168
14:26:03 8871 8192000000 10211859312 10633883648 1327957872 13.949 100 24 46 0 1338899680 5813520 5128288
14:27:17 30242 8192000000 10219847088 10639953920 1323569968 13.909 99 18 35 0 1332643488 5743424 3330096
14:28:50 6022 8192000000 10224559904 10645987328 1334532480 14.008 100 27 54 0 1347374704 6980336 5861888
14:30:00 21514 8192000000 10218519760 10629103616 1317337504 13.853 100 35 69 2 1331602288 5501808 8762976
14:31:28 7372 8192000000 10231626176 10634309632 1313447248 13.817 99 45 87 1 1332462592 9085872 9929472
14:32:40 79409 8192000000 10237667056 10653216768 1326990832 13.940 99 44 88 0 1350383248 13185488 10206928
14:35:23 39723 8192000000 10249514544 10662002688 1320551616 13.882 98 40 80 1 1347249984 17718240 8980128
14:37:09 10885 8192000000 10253910160 10663206912 1339925712 14.057 100 46 92 0 1366851232 16166176 10759344
14:38:27 19396 8192000000 10233790048 10644332544 1317817568 13.857 100 46 91 1 1349516672 20886960 10812144
14:39:49 21174 8192000000 10215104512 10621751296 1280351440 13.516 98 43 86 0 1315213936 24581056 10281440
14:41:14 4205 8192000000 10217773920 10612609024 1288504848 13.591 100 51 99 0 1324457728 24024592 11928288
14:42:21 9453 8192000000 10250650336 10642202624 1310599216 13.792 100 64 127 1 1350739616 25710768 14429632
14:43:35 1104 8192000000 10257202320 10643439616 1318838768 13.866 99 80 158 1 1362832320 25022656 18970896
14:44:42 4580 8192000000 10278446272 10683359232 1347208352 14.122 100 65 125 1 1388493824 25819504 15465968
14:46:00 2761 8192000000 10315345792 10715963392 1369741920 14.325 100 85 167 0 1420067328 29875584 20449824
14:47:09 9049 8192000000 10320960592 10726240256 1375797552 14.379 100 63 126 1 1425553648 34488112 15267984
14:48:23 6093 8192000000 10327965712 10736369664 1382047648 14.435 100 62 124 0 1433404624 36021984 15334992
14:49:35 1857 8192000000 10340927616 10749739008 1395278384 14.553 100 72 146 0 1448496320 35397568 17820368
14:50:44 14127 8192000000 10336026848 10765537280 1399352800 14.589 100 41 83 0 1450984192 40351184 11280208
14:52:04 10366 8192000000 10339512672 10763313152 1396973792 14.568 100 38 72 1 1444592976 37554608 10064576
14:53:18 22941 8192000000 10330613552 10765103104 1391554464 14.520 99 34 68 0 1434766432 34214464 8997504
14:54:45 20475 8192000000 10335227744 10772594688 1382883472 14.442 100 23 46 1 1444507808 54376944 7247392
14:56:15 2006 8192000000 10357438224 10774994944 1397376800 14.572 100 83 161 1 1455004608 38763312 18864496
14:57:19 4097 8192000000 10340371360 10768932864 1405543952 14.644 100 62 123 0 1444312352 23971472 14796928
14:58:27 22995 8192000000 10308251568 10759766016 1398533248 14.582 100 13 26 0 1417314176 15302272 3478656
14:59:53 46284 8192000000 10313455440 10766725120 1401090736 14.605 100 11 22 0 1421753280 17766208 2896336
15:01:42 42029 8192000000 10325870512 10789298176 1407949024 14.666 100 12 24 0 1438519184 27551664 3018496
15:03:35 81295 8192000000 10305436128 10756886528 1380394032 14.420 98 27 55 0 1394412096 8332928 5685136
15:05:58 59813 8192000000 10330794320 10780393472 1407817312 14.665 100 33 67 0 1432733216 17405632 7510272
15:07:59 188793 8192000000 10316558784 10769113088 1354960240 14.192 96 4 8 0 1378874192 22708672 1205280
15:12:08 46438 8192000000 10292297712 10746101760 1352448768 14.170 96 16 31 0 1367296544 11557696 3290080
15:13:57 108609 8192000000 10309208160 10741993472 1342688064 14.082 96 44 82 0 1364478880 12048256 9742560
15:16:49 95238 8192000000 10310929440 10755923968 1371971088 14.345 99 35 68 0 1394189984 14042112 8176784
15:19:33 60109 8192000000 10278683152 10711203840 1321488800 13.890 97 38 76 1 1341955760 12156432 8310528
15:21:41 22599 8192000000 10240200864 10673815552 1294667600 13.647 96 34 67 0 1314158480 11329728 8161152
15:23:10 52543 8192000000 10246106000 10693902336 1320798656 13.884 99 32 61 0 1349489152 21654128 7036368
15:25:20 34105 8192000000 10240478544 10697306112 1327518368 13.945 99 13 21 0 1347962288 17662944 2780976
15:26:56 123877 8192000000 10229478448 10670514176 1269271808 13.415 94 21 43 0 1282818608 8251408 5295392
15:30:32 44097 8192000000 10251094128 10689560576 1316029184 13.841 98 35 67 0 1330949872 7741360 7179328
15:32:16 16799 8192000000 10248601104 10696163328 1336657568 14.027 99 22 44 0 1348248240 6534608 5056064
15:33:36 105930 8192000000 10261984528 10722533376 1355076528 14.193 100 16 32 0 1374356672 15707104 3573040
15:36:23 41452 8192000000 10256582224 10710372352 1327921792 13.948 98 14 28 0 1341365424 10485984 2957648
15:38:08 12721 8192000000 10278155488 10717503488 1355988512 14.201 100 40 80 0 1380392400 15527792 8876096
15:39:23 36336 8192000000 10266664704 10717892608 1351320656 14.159 99 16 32 0 1367961360 12997312 3643392
15:41:00 44391 8192000000 10275104608 10715484160 1354733792 14.190 99 31 61 0 1370835312 9818144 6283376
15:42:45 47276 8192000000 10295050000 10739720192 1370064864 14.328 99 36 70 2 1388231328 9402528 8763936
15:44:34 33588 8192000000 10304692448 10762948608 1393807696 14.540 100 32 64 0 1414656304 13544016 7304592
15:46:09 92266 8192000000 10307658464 10765590528 1377036448 14.390 98 16 32 0 1395554912 15180272 3338192
15:48:44 60311 8192000000 10301275024 10761129984 1370928800 14.335 98 11 22 0 1387638864 14110144 2599920
15:50:56 66863 8192000000 10305728192 10750750720 1368882912 14.317 98 31 62 0 1385362816 9826416 6653488
15:53:03 48134 8192000000 10294960304 10752983040 1368173840 14.311 98 22 44 0 1390298016 17003616 5120560
15:54:55 51901 8192000000 10283620928 10745290752 1380846304 14.424 99 13 24 0 1390894592 7332432 2715856
15:56:47 69386 8192000000 10278301936 10738073600 1359958752 14.237 98 10 20 0 1370941216 8578880 2403584
15:58:57 61990 8192000000 10266613136 10738544640 1357796912 14.218 99 3 6 0 1368165424 9857664 510848
16:00:59 45945 8192000000 10272305808 10726440960 1335437536 14.016 97 30 61 0 1350261280 8009472 6814272
16:02:47 55103 8192000000 10274122288 10722287616 1333874400 14.002 97 21 42 1 1347753072 9473712 4404960
16:04:43 9996 8192000000 10281570704 10718601216 1353079072 14.175 99 45 90 0 1371608672 8612704 9916896
16:05:56 62477 8192000000 10254619728 10694582272 1255140176 13.285 93 37 74 0 1275309840 12794720 7374944
16:07:59 10104 8192000000 10277546048 10712879104 1342287456 14.078 99 43 86 0 1372797088 21131712 9377920
16:09:10 50195 8192000000 9248342336 9517371392 401550592 4.672 30 4 8 0 407051664 4692160 808912

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 18-03-2024 16:10:55 to 18-03-2024 16:11:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          183531
MON$OLDEST_ACTIVE               183532
MON$OLDEST_SNAPSHOT             183532
MON$NEXT_TRANSACTION            183532
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                       1928160
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.33736 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33736 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33736 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33736 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 Mon Mar 18 16:11:12 2024 
 
Database header page information: 
    Flags            0 
    Generation        95484 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    183531 
    Oldest active        183532 
    Oldest snapshot        183532 
    Next transaction    183533 
    Sequence number        0 
    Next attachment ID    735 
    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.16, total records: 7829675 
    Average version length: 48.16, total versions: 120191, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 87728 
    Data pages: 87728, average fill: 71% 
    Primary pages: 87728, secondary pages: 0, swept pages: 12470 
    Empty pages: 3, full pages: 79344 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 337 
    40 - 59% = 5093 
    60 - 79% = 82197 
    80 - 99% = 53 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23618, nodes: 7829675 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1729633, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 375 
        20 - 39% = 1717 
        40 - 59% = 4464 
        60 - 79% = 2373 
        80 - 99% = 14689 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13679, nodes: 7829675 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1551943, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1503 
        40 - 59% = 2277 
        60 - 79% = 1067 
        80 - 99% = 8832 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8450, nodes: 7829675 
    Average node length: 6.63, total dup: 5837851, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1544959, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 924 
        40 - 59% = 1547 
        60 - 79% = 892 
        80 - 99% = 4967 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.93, total records: 2282962 
    Average version length: 34.66, total versions: 121465, max versions: 3 
    Average fragment length: 4.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28848 
    Data pages: 28848, average fill: 74% 
    Primary pages: 28839, secondary pages: 9, swept pages: 7751 
    Empty pages: 0, full pages: 23691 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 224 
    40 - 59% = 2342 
    60 - 79% = 24809 
    80 - 99% = 1441 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4633, nodes: 2282962 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 687341, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 897 
        40 - 59% = 928 
        60 - 79% = 701 
        80 - 99% = 2107 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2536, nodes: 2286407 
    Average node length: 4.97, total dup: 2285508, max dup: 20308 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1260520, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 256 
        40 - 59% = 1510 
        60 - 79% = 577 
        80 - 99% = 193 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2121, nodes: 2282962 
    Average node length: 4.97, total dup: 2282912, max dup: 130663 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074012, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 123 
        40 - 59% = 1154 
        60 - 79% = 67 
        80 - 99% = 771 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4412, nodes: 2282962 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 687341, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 106 
        20 - 39% = 584 
        40 - 59% = 660 
        60 - 79% = 788 
        80 - 99% = 2274 
 
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.19, total records: 400 
    Average version length: 22.85, total versions: 260968, max versions: 684 
    Average fragment length: 2.00, total fragments: 60, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1440 
    Data pages: 1440, average fill: 90% 
    Primary pages: 13, secondary pages: 1427, swept pages: 0 
    Empty pages: 6, full pages: 1433 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1432 
 
    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: 11.40, total records: 124713 
    Average version length: 68.27, total versions: 103909, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.72 
    Pointer pages: 7, data page slots: 2192 
    Data pages: 2008, average fill: 76% 
    Primary pages: 2007, secondary pages: 1, swept pages: 0 
    Empty pages: 175, full pages: 1539 
    Fill distribution: 
     0 - 19% = 224 
    20 - 39% = 52 
    40 - 59% = 94 
    60 - 79% = 206 
    80 - 99% = 1432 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705834, depth: 3, leaf buckets: 345, nodes: 124713 
    Average node length: 13.19, total dup: 6570, max dup: 2 
    Average key length: 10.79, compression ratio: 2.50 
    Average prefix length: 19.16, average data length: 7.84 
    Clustering factor: 98143, ratio: 0.79 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 228 
        60 - 79% = 61 
        80 - 99% = 52 
 
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: 18314, max versions: 1021 
    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: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 58 
 
    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: 2.76, total records: 2542 
    Average version length: 43.14, total versions: 2386, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 21.02 
    Pointer pages: 1, data page slots: 40 
    Data pages: 30, average fill: 80% 
    Primary pages: 29, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 23 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 20 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92451, depth: 2, leaf buckets: 3, nodes: 2542 
    Average node length: 4.25, total dup: 2444, max dup: 217 
    Average key length: 2.42, compression ratio: 7.86 
    Average prefix length: 18.62, average data length: 0.38 
    Clustering factor: 1314, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 1 
        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.00, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 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: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.18, total records: 811044 
    Average version length: 25.50, total versions: 104252, max versions: 4 
    Average fragment length: 29.50, total fragments: 4, max fragments: 1 
    Average unpacked length: 54.00, compression ratio: 1.54 
    Pointer pages: 6, data page slots: 8272 
    Data pages: 8264, average fill: 70% 
    Primary pages: 8236, secondary pages: 28, swept pages: 1018 
    Empty pages: 131, full pages: 7366 
    Fill distribution: 
     0 - 19% = 224 
    20 - 39% = 184 
    40 - 59% = 192 
    60 - 79% = 7157 
    80 - 99% = 507 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 898, nodes: 811044 
    Average node length: 4.87, total dup: 810995, max dup: 153471 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90684, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 139 
        40 - 59% = 490 
        60 - 79% = 197 
        80 - 99% = 69 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 964, nodes: 811044 
    Average node length: 5.87, total dup: 722368, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162704, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 109 
        40 - 59% = 457 
        60 - 79% = 102 
        80 - 99% = 294 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1035, nodes: 811044 
    Average node length: 5.88, total dup: 722368, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164683, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 227 
        40 - 59% = 451 
        60 - 79% = 84 
        80 - 99% = 273 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1148, nodes: 811044 
    Average node length: 5.96, total dup: 722368, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157671, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 244 
        40 - 59% = 626 
        60 - 79% = 182 
        80 - 99% = 94 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5434 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.91, total fragments: 67, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 75, secondary pages: 21, swept pages: 47 
    Empty pages: 14, full pages: 61 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5434 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.38, average data length: 1.55 
    Clustering factor: 5137, 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: 5434 
    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: 149, 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.10, total records: 83967 
    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: 816 
    Data pages: 816, average fill: 71% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 808 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 808 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33016, depth: 2, leaf buckets: 107, nodes: 83967 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3323, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 105 
 
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: 145.51, total records: 170683 
    Average version length: 153.51, total versions: 5842, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 6, data page slots: 4864 
    Data pages: 4112, average fill: 86% 
    Primary pages: 4112, secondary pages: 0, swept pages: 1 
    Empty pages: 68, full pages: 4029 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4029 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.65, total records: 162668 
    Average version length: 153.72, total versions: 5672, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 8, data page slots: 5088 
    Data pages: 3944, average fill: 85% 
    Primary pages: 3943, secondary pages: 1, swept pages: 1 
    Empty pages: 79, full pages: 3841 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 3842 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 147.93, total records: 168098 
    Average version length: 152.44, total versions: 3375, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 5720 
    Data pages: 4040, average fill: 86% 
    Primary pages: 4040, secondary pages: 0, swept pages: 1 
    Empty pages: 51, full pages: 3971 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 3971 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 149.18, total records: 165410 
    Average version length: 150.27, total versions: 1773, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 8, data page slots: 4712 
    Data pages: 3944, average fill: 86% 
    Primary pages: 3943, secondary pages: 1, swept pages: 1 
    Empty pages: 26, full pages: 3908 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 3910 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 142.11, total records: 169904 
    Average version length: 154.13, total versions: 9881, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 7, data page slots: 5232 
    Data pages: 4104, average fill: 86% 
    Primary pages: 4104, secondary pages: 0, swept pages: 7 
    Empty pages: 68, full pages: 4018 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 4017 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 146.64, total records: 189270 
    Average version length: 153.25, total versions: 5481, 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: 5744 
    Data pages: 4552, average fill: 86% 
    Primary pages: 4551, secondary pages: 1, swept pages: 1 
    Empty pages: 58, full pages: 4474 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4475 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 120.73, total records: 232003 
    Average version length: 155.03, total versions: 46709, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.05 
    Pointer pages: 8, data page slots: 6304 
    Data pages: 5608, average fill: 87% 
    Primary pages: 5608, secondary pages: 0, swept pages: 3 
    Empty pages: 65, full pages: 5517 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 5517 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 144.38, total records: 180839 
    Average version length: 153.54, total versions: 7897, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 8, data page slots: 5712 
    Data pages: 4376, average fill: 85% 
    Primary pages: 4376, secondary pages: 0, swept pages: 2 
    Empty pages: 83, full pages: 4274 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 4274 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 146.84, total records: 171484 
    Average version length: 153.34, total versions: 4586, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 6, data page slots: 5088 
    Data pages: 4160, average fill: 85% 
    Primary pages: 4160, secondary pages: 0, swept pages: 3 
    Empty pages: 86, full pages: 4050 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4050 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 145.78, total records: 174257 
    Average version length: 153.24, total versions: 5625, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 8, data page slots: 5440 
    Data pages: 4184, average fill: 86% 
    Primary pages: 4184, secondary pages: 0, swept pages: 4 
    Empty pages: 53, full pages: 4114 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4115 
 
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.25, total records: 2148281 
    Average version length: 52.95, total versions: 60791, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25776 
    Data pages: 25776, average fill: 72% 
    Primary pages: 25776, secondary pages: 0, swept pages: 8510 
    Empty pages: 295, full pages: 22651 
    Fill distribution: 
     0 - 19% = 531 
    20 - 39% = 362 
    40 - 59% = 797 
    60 - 79% = 23511 
    80 - 99% = 575 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2620, nodes: 2148281 
    Average node length: 5.44, total dup: 2005926, max dup: 1555 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184898, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 278 
        40 - 59% = 1711 
        60 - 79% = 311 
        80 - 99% = 312 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2148281 
    Average node length: 5.69, total dup: 1929396, max dup: 72 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 383143, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2313 
        60 - 79% = 413 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2163, nodes: 2148281 
    Average node length: 4.96, total dup: 2148181, max dup: 28112 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182547, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 157 
        40 - 59% = 1172 
        60 - 79% = 412 
        80 - 99% = 420 
 
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: 32.99, total records: 181037 
    Average version length: 69.18, total versions: 94756, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.82 
    Pointer pages: 3, data page slots: 4480 
    Data pages: 3296, average fill: 64% 
    Primary pages: 3296, secondary pages: 0, swept pages: 380 
    Empty pages: 566, full pages: 2468 
    Fill distribution: 
     0 - 19% = 704 
    20 - 39% = 15 
    40 - 59% = 16 
    60 - 79% = 929 
    80 - 99% = 1632 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103238, depth: 3, leaf buckets: 236, nodes: 181037 
    Average node length: 6.47, total dup: 157789, max dup: 27 
    Average key length: 3.89, compression ratio: 10.80 
    Average prefix length: 40.24, average data length: 1.76 
    Clustering factor: 30609, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 103 
        60 - 79% = 83 
        80 - 99% = 38 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 62.42, total records: 7301292 
    Average version length: 68.81, total versions: 693128, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.02 
    Pointer pages: 65, data page slots: 104976 
    Data pages: 104976, average fill: 75% 
    Primary pages: 104976, secondary pages: 0, swept pages: 14270 
    Empty pages: 162, full pages: 95145 
    Fill distribution: 
     0 - 19% = 1541 
    20 - 39% = 3003 
    40 - 59% = 3291 
    60 - 79% = 79237 
    80 - 99% = 17904 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10768, nodes: 7301292 
    Average node length: 6.50, total dup: 6320167, max dup: 29 
    Average key length: 3.51, compression ratio: 11.96 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1601853, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1412 
        40 - 59% = 5842 
        60 - 79% = 2866 
        80 - 99% = 639 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8596, nodes: 7301292 
    Average node length: 5.39, total dup: 7015098, max dup: 201 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1389779, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1042 
        40 - 59% = 4708 
        60 - 79% = 1720 
        80 - 99% = 1117 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8697, nodes: 7301292 
    Average node length: 5.39, total dup: 7015098, max dup: 201 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1392316, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1130 
        40 - 59% = 4722 
        60 - 79% = 1744 
        80 - 99% = 1088 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 65.84, total records: 12256064 
    Average version length: 68.75, total versions: 554654, 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: 103, data page slots: 167776 
    Data pages: 167776, average fill: 78% 
    Primary pages: 167776, secondary pages: 0, swept pages: 54797 
    Empty pages: 3, full pages: 167620 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 7 
    60 - 79% = 153468 
    80 - 99% = 14297 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18376, nodes: 12256064 
    Average node length: 6.59, total dup: 10685087, max dup: 80 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2406037, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 2092 
        40 - 59% = 10583 
        60 - 79% = 4705 
        80 - 99% = 967 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 34.50, total records: 2041909 
    Average version length: 69.12, total versions: 1023155, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.65 
    Pointer pages: 32, data page slots: 50080 
    Data pages: 29880, average fill: 79% 
    Primary pages: 29880, secondary pages: 0, swept pages: 2195 
    Empty pages: 968, full pages: 27042 
    Fill distribution: 
     0 - 19% = 1578 
    20 - 39% = 511 
    40 - 59% = 323 
    60 - 79% = 9934 
    80 - 99% = 17534 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2281, nodes: 2041909 
    Average node length: 5.51, total dup: 1959623, max dup: 99 
    Average key length: 2.54, compression ratio: 16.54 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 137966, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 142 
        40 - 59% = 972 
        60 - 79% = 773 
        80 - 99% = 378 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.07, total records: 1130756 
    Average version length: 69.14, total versions: 556210, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.59 
    Pointer pages: 23, data page slots: 36360 
    Data pages: 28568, average fill: 46% 
    Primary pages: 28568, secondary pages: 0, swept pages: 6561 
    Empty pages: 7476, full pages: 13807 
    Fill distribution: 
     0 - 19% = 11164 
    20 - 39% = 1953 
    40 - 59% = 1000 
    60 - 79% = 4870 
    80 - 99% = 9581 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1507, nodes: 1130756 
    Average node length: 5.78, total dup: 1056556, max dup: 105 
    Average key length: 2.85, compression ratio: 14.73 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 147603, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 257 
        40 - 59% = 751 
        60 - 79% = 386 
        80 - 99% = 110 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.40, total records: 9510332 
    Average version length: 68.97, total versions: 620906, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 91, data page slots: 148184 
    Data pages: 148184, average fill: 69% 
    Primary pages: 148183, secondary pages: 1, swept pages: 43813 
    Empty pages: 781, full pages: 99244 
    Fill distribution: 
     0 - 19% = 2218 
    20 - 39% = 8680 
    40 - 59% = 25134 
    60 - 79% = 98499 
    80 - 99% = 13653 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13505, nodes: 9510332 
    Average node length: 6.70, total dup: 7891051, max dup: 29 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2069225, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1053 
        40 - 59% = 6370 
        60 - 79% = 5151 
        80 - 99% = 929 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.45, total records: 21203365 
    Average version length: 82.94, total versions: 22171, 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: 319384 
    Data pages: 319384, average fill: 81% 
    Primary pages: 319384, secondary pages: 0, swept pages: 11494 
    Empty pages: 1, full pages: 319382 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 26896 
    80 - 99% = 292486 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19630, nodes: 21203365 
    Average node length: 5.72, total dup: 20721017, max dup: 148 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288753, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8580 
        60 - 79% = 547 
        80 - 99% = 10499 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17230, nodes: 21203365 
    Average node length: 6.31, total dup: 18633685, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914948, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 822 
        60 - 79% = 260 
        80 - 99% = 16145 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21359, nodes: 21203365 
    Average node length: 6.35, total dup: 18552479, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3583985, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 3 
        40 - 59% = 8716 
        60 - 79% = 613 
        80 - 99% = 12021 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16257, nodes: 21203365 
    Average node length: 5.56, total dup: 21203265, max dup: 230583 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944008, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 3106 
        60 - 79% = 433 
        80 - 99% = 12709 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.17, total records: 9986685 
    Average version length: 82.62, total versions: 635910, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 108, data page slots: 175512 
    Data pages: 175488, average fill: 70% 
    Primary pages: 175488, secondary pages: 0, swept pages: 59076 
    Empty pages: 936, full pages: 114318 
    Fill distribution: 
     0 - 19% = 2482 
    20 - 39% = 9407 
    40 - 59% = 29128 
    60 - 79% = 50962 
    80 - 99% = 83509 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11397, nodes: 9986685 
    Average node length: 5.38, total dup: 9676756, max dup: 231 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2194084, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 76 
        40 - 59% = 7215 
        60 - 79% = 3980 
        80 - 99% = 125 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13895, nodes: 9986685 
    Average node length: 6.26, total dup: 8280826, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1514160, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 3812 
        40 - 59% = 4794 
        60 - 79% = 2526 
        80 - 99% = 2623 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12723, nodes: 9986685 
    Average node length: 5.99, total dup: 8683872, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2396415, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 81 
        40 - 59% = 8129 
        60 - 79% = 4368 
        80 - 99% = 142 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10273, nodes: 9986685 
    Average node length: 5.16, total dup: 9986585, max dup: 155681 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1553473, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1116 
        40 - 59% = 5104 
        60 - 79% = 1751 
        80 - 99% = 2270 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.76, total records: 11557144 
    Average version length: 82.57, total versions: 497521, 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: 120, data page slots: 194232 
    Data pages: 193008, average fill: 74% 
    Primary pages: 193008, secondary pages: 0, swept pages: 62828 
    Empty pages: 3419, full pages: 150780 
    Fill distribution: 
     0 - 19% = 5587 
    20 - 39% = 7031 
    40 - 59% = 15522 
    60 - 79% = 38700 
    80 - 99% = 126168 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13136, nodes: 11557144 
    Average node length: 5.31, total dup: 11446952, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2399014, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 117 
        40 - 59% = 8496 
        60 - 79% = 4261 
        80 - 99% = 260 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10695, nodes: 11557144 
    Average node length: 5.51, total dup: 11053450, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 715555, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 176 
        20 - 39% = 807 
        40 - 59% = 2725 
        60 - 79% = 1831 
        80 - 99% = 5156 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15035, nodes: 11557144 
    Average node length: 6.03, total dup: 10095048, max dup: 67 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2415681, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 137 
        40 - 59% = 10008 
        60 - 79% = 4596 
        80 - 99% = 287 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11041, nodes: 11557144 
    Average node length: 5.23, total dup: 11557044, max dup: 204760 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 704694, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 81 
        20 - 39% = 811 
        40 - 59% = 5088 
        60 - 79% = 1483 
        80 - 99% = 3578 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 77.45, total records: 10112905 
    Average version length: 82.94, total versions: 646582, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 111, data page slots: 180024 
    Data pages: 179992, average fill: 70% 
    Primary pages: 179992, secondary pages: 0, swept pages: 63110 
    Empty pages: 968, full pages: 113229 
    Fill distribution: 
     0 - 19% = 2757 
    20 - 39% = 10247 
    40 - 59% = 31688 
    60 - 79% = 53648 
    80 - 99% = 81652 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12094, nodes: 10112905 
    Average node length: 5.21, total dup: 10083383, max dup: 2374 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2003186, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1418 
        40 - 59% = 7849 
        60 - 79% = 2137 
        80 - 99% = 657 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14001, nodes: 10112905 
    Average node length: 6.28, total dup: 8384510, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1483547, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 194 
        20 - 39% = 3713 
        40 - 59% = 4764 
        60 - 79% = 2522 
        80 - 99% = 2808 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12724, nodes: 10112905 
    Average node length: 5.46, total dup: 9665537, max dup: 108 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2142332, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1374 
        40 - 59% = 8811 
        60 - 79% = 1849 
        80 - 99% = 663 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10491, nodes: 10112905 
    Average node length: 5.18, total dup: 10112805, max dup: 158717 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1574781, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1179 
        40 - 59% = 5318 
        60 - 79% = 1687 
        80 - 99% = 2269 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.22, total records: 585112 
    Average version length: 68.84, total versions: 8215, 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: 8088 
    Data pages: 8088, average fill: 76% 
    Primary pages: 8088, secondary pages: 0, swept pages: 3117 
    Empty pages: 3, full pages: 7132 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 24 
    40 - 59% = 233 
    60 - 79% = 7693 
    80 - 99% = 134 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37319, depth: 3, leaf buckets: 737, nodes: 585112 
    Average node length: 5.95, total dup: 498333, max dup: 99 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101550, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 20 
        40 - 59% = 500 
        60 - 79% = 121 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32197, depth: 3, leaf buckets: 766, nodes: 585112 
    Average node length: 6.15, total dup: 479963, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101615, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 21 
        40 - 59% = 530 
        60 - 79% = 116 
        80 - 99% = 97 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 589, nodes: 585112 
    Average node length: 4.86, total dup: 585012, max dup: 10150 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90078, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 356 
        60 - 79% = 85 
        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 Mon Mar 18 16:11:37 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7829675 120191 1 0.0000 0.0000
DOC_LIST 2282962 121465 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 260968 684 65200.0000 0.0000
INVNT_TURNOVER_LOG 124713 103909 1 0.0000 0.0000
MONEY_SALDO 49 18314 1021 37300.0000 0.0000
MONEY_TURNOVER_LOG 2542 2386 1 0.0000 0.0000
PDISTR 811044 104252 4 0.0000 0.0000
PERF_SPLIT_0 170683 5842 1 0.0000 0.0000
PERF_SPLIT_1 162668 5672 1 0.0000 0.0000
PERF_SPLIT_2 168098 3375 1 0.0000 0.0000
PERF_SPLIT_3 165410 1773 1 0.0000 0.0000
PERF_SPLIT_4 169904 9881 1 0.0000 0.0000
PERF_SPLIT_5 189270 5481 1 0.0000 0.0000
PERF_SPLIT_6 232003 46709 1 0.0000 0.0000
PERF_SPLIT_7 180839 7897 1 0.0000 0.0000
PERF_SPLIT_8 171484 4586 1 0.0000 0.0000
PERF_SPLIT_9 174257 5625 1 0.0000 0.0000
PSTORNED 2148281 60791 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 181037 94756 1 0.0000 0.0000
XQD_1000_3300 7301292 693128 1 0.0000 0.0000
XQD_1200_2000 12256064 554654 1 0.0000 0.0000
XQD_2000_3300 2041909 1023155 1 0.0000 0.0000
XQD_2100_3300 1130756 556210 1 0.0000 0.0000
XQD_3300_3400 9510332 620906 1 0.0000 0.0000
XQS_1000_1200 21203365 22171 1 0.0000 0.0000
XQS_1000_3300 9986685 635910 1 0.0000 0.0000
XQS_1200_2000 11557144 497521 1 0.0000 0.0000
XQS_2100_3300 10112905 646582 1 0.0000 0.0000
XQS_3300_3400 585112 8215 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 ---
:118: 
:119: mscs-test-161.budzdorov.ru    Mon Mar 18 16:10:05 2024
:120:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:121: 
--- end of diff output ---

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

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