Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.04.2024 01: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 15409396 kB
MemAvailable 30089260 kB
Buffers 0 kB
Cached 16329012 kB
SwapCached 2488 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-04-11 01:09:41
DTS_END                         2024-04-11 01:09:41.9620
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42158
TRN_ID                          184789
ATT_ID                          531
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: 9285.62 23930 928562
customer order: creation 189.65 397 18965
customer order: refuse 15.78 379 1578
order to supplier: creation 49.77 1376 4977
order to supplier: removal 3.43 110398 343
invoice (draft): creation 49.67 3130 4967
invoice (draft): removal 48.75 987 4875
invoice accept: apply 45.28 21653 4528
invoice accept: cancel 43.62 994 4362
customer reserve: creation 4292.00 211 429200
customer reserve: removal 4236.50 70 423650
realization accept: apply 91.27 199 9127
realization accept: cancel 76.33 135 7633
payment from customer: creation 66.08 132 6608
payment from customer: removal 5.94 112 594
payment to supplier: creation 54.03 146 5403
payment to supplier: removal 3.60 118 360
service: total inventory turnovers 5.37 1016 537
service: total monetary turnovers 7.46 38 746
service: aggregate perf. data 1.06 17768 106
service: refresh index statistics 0.03 319338 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5220
TEST_TIME 2 3870
TEST_TIME 3 3169
TEST_TIME 4 3887
TEST_TIME 5 4165
TEST_TIME 6 4964
TEST_TIME 7 4951
TEST_TIME 8 4823
TEST_TIME 9 4749
TEST_TIME 10 4959
TEST_TIME 11 4995
TEST_TIME 12 5248
TEST_TIME 13 5673
TEST_TIME 14 5793
TEST_TIME 15 6211
TEST_TIME 16 6681
TEST_TIME 17 6950
TEST_TIME 18 7030
TEST_TIME 19 7104
TEST_TIME 20 7022
TEST_TIME 21 7258
TEST_TIME 22 7868
TEST_TIME 23 8076
TEST_TIME 24 8160
TEST_TIME 25 8318
TEST_TIME 26 8226
TEST_TIME 27 8985
TEST_TIME 28 9277
TEST_TIME 29 10032
TEST_TIME 30 10090
TEST_TIME 31 9849
TEST_TIME 32 9829
TEST_TIME 33 9709
TEST_TIME 34 9821
TEST_TIME 35 9855
TEST_TIME 36 9927
TEST_TIME 37 9794
TEST_TIME 38 9707
TEST_TIME 39 9797
TEST_TIME 40 9615
TEST_TIME 41 9551
TEST_TIME 42 9517
TEST_TIME 43 9536
TEST_TIME 44 9495
TEST_TIME 45 9694
TEST_TIME 46 9712
TEST_TIME 47 9653
TEST_TIME 48 9606
TEST_TIME 49 9654
TEST_TIME 50 9504
TEST_TIME 51 9594
TEST_TIME 52 9492
TEST_TIME 53 9459
TEST_TIME 54 9460
TEST_TIME 55 9452
TEST_TIME 56 9392
TEST_TIME 57 9464
TEST_TIME 58 9491
TEST_TIME 59 9451
TEST_TIME 60 9411
TEST_TIME 61 9463
TEST_TIME 62 9487
TEST_TIME 63 9565
TEST_TIME 64 9579
TEST_TIME 65 9552
TEST_TIME 66 9570
TEST_TIME 67 9645
TEST_TIME 68 9705
TEST_TIME 69 9672
TEST_TIME 70 9564
TEST_TIME 71 9535
TEST_TIME 72 9458
TEST_TIME 73 9420
TEST_TIME 74 9460
TEST_TIME 75 9447
TEST_TIME 76 9396
TEST_TIME 77 9371
TEST_TIME 78 9389
TEST_TIME 79 9431
TEST_TIME 80 9398
TEST_TIME 81 9492
TEST_TIME 82 9488
TEST_TIME 83 9473
TEST_TIME 84 9479
TEST_TIME 85 9510
TEST_TIME 86 9579
TEST_TIME 87 9557
TEST_TIME 88 9578
TEST_TIME 89 9552
TEST_TIME 90 9498
TEST_TIME 91 9426
TEST_TIME 92 9424
TEST_TIME 93 9404
TEST_TIME 94 9325
TEST_TIME 95 9324
TEST_TIME 96 9313
TEST_TIME 97 9325
TEST_TIME 98 9373
TEST_TIME 99 9335
TEST_TIME 100 9298

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 11-04-2024 01:11:06 to 11-04-2024 01:11:10.

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 1320058 1320058 0 0.00 0 28755 8 0 0
doc_list_biud 1320057 1320057 0 0.00 0 31020 29 0 0
sp_add_invoice_to_stock 4600 4528 72 1.56 36 202030 21654 0 72
sp_cancel_adding_invoice 4362 4362 0 0.00 5 70396 995 0 0
sp_cancel_client_order 1578 1578 0 0.00 4 9574 379 0 0
sp_cancel_customer_reserve 423650 423650 0 0.00 0 24043 71 0 0
sp_cancel_pay_from_customer 594 594 0 0.00 3 14277 112 0 0
sp_cancel_pay_to_supplier 360 360 0 0.00 3 13245 119 0 0
sp_cancel_supplier_invoice 4885 4875 10 0.20 2 29152 988 0 10
sp_cancel_supplier_order 343 343 0 0.00 9 1388660 110398 0 0
sp_cancel_write_off 7633 7633 0 0.00 1 20094 136 0 0
sp_client_order 18965 18965 0 0.00 3 28749 398 0 0
sp_customer_reserve 429200 429200 0 0.00 0 102872 211 0 0
sp_fill_shopping_cart 28906 28906 0 0.00 1 12351 39 0 0
sp_fill_shopping_cart_clo_res 429189 429189 0 0.00 0 18450 17 0 0
sp_get_clo_for_invoice 4515 4515 0 0.00 0 36699 327 0 0
sp_kill_cost_storno 12949 12949 0 0.00 0 14273 66 0 0
sp_kill_qstorno_ret_qs2qd 860151 860151 0 0.00 0 29142 39 0 0
sp_kill_qty_storno 456083 456083 0 0.00 0 31019 84 0 0
sp_lock_selected_doc 18863 18863 0 0.00 0 6954 5 0 0
sp_make_cost_storno 25653 25653 0 0.00 0 27225 59 0 0
sp_multiply_rows_for_pdistr 25653 25653 0 0.00 0 15146 30 0 0
sp_multiply_rows_for_qdistr 18965 18965 0 0.00 0 15567 186 0 0
sp_pay_from_customer 6608 6608 0 0.00 4 26956 133 0 0
sp_pay_to_supplier 5403 5403 0 0.00 4 27250 147 0 0
sp_payment_common 12011 12011 0 0.00 2 13171 26 0 0
sp_qd_handle_on_cancel_clo 1578 1578 0 0.00 0 9566 355 0 0
sp_qd_handle_on_invoice_upd_sts 8877 8877 0 0.00 0 31018 357 0 0
sp_qd_handle_on_reserve_upd_sts 9127 9127 0 0.00 0 28731 72 0 0
sp_reserve_write_off 9127 9127 0 0.00 6 29112 200 0 0
sp_supplier_invoice 4967 4967 0 0.00 6 94859 3130 0 0
sp_supplier_order 4977 4977 0 0.00 5 34933 1376 0 0
srv_aggregate_perf_data 107 106 1 0.93 1914 220735 17769 0 1
srv_fill_mon_cache_memory 58 58 0 0.00 1673 136006 36887 0 0
srv_find_qd_qs_mism 881591 881591 0 0.00 0 10432 7 0 0
srv_make_invnt_saldo 537 537 0 0.00 36 46316 1017 0 0
srv_make_money_saldo 746 746 0 0.00 1 8660 38 0 0
srv_recalc_idx_stat 3 3 0 0.00 271406 346235 319338 0 0
t$perf-abend:sp_add_invoice_to_stock 72 72 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4529 4529 0 0.00 0 30950 220 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 0 12156 119 0 0
t$perf-norm:sp_cancel_client_order 1578 1578 0 0.00 0 13866 19 0 0
t$perf-norm:sp_cancel_customer_reserve 632 632 0 0.00 0 1091 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 594 594 0 0.00 0 4974 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 360 360 0 0.00 0 224 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 3126 34 0 0
t$perf-norm:sp_cancel_supplier_order 343 343 0 0.00 0 26010 1873 0 0
t$perf-norm:sp_cancel_write_off 906 906 0 0.00 0 1073 5 0 0
t$perf-norm:sp_client_order 18965 18965 0 0.00 0 26276 21 0 0
t$perf-norm:sp_customer_reserve 911 911 0 0.00 0 1385 8 0 0
t$perf-norm:sp_pay_from_customer 6608 6608 0 0.00 0 5964 11 0 0
t$perf-norm:sp_pay_to_supplier 5403 5403 0 0.00 0 15156 20 0 0
t$perf-norm:sp_reserve_write_off 9127 9127 0 0.00 0 19686 14 0 0
t$perf-norm:sp_supplier_invoice 4967 4967 0 0.00 0 3778 18 0 0
t$perf-norm:sp_supplier_order 4977 4977 0 0.00 0 2717 14 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 445 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 210 6 0 0
t$perf-norm:srv_make_invnt_saldo 537 537 0 0.00 0 2106 35 0 0
t$perf-norm:srv_make_money_saldo 746 746 0 0.00 0 1238 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 9174 9030 144 1.56 0 12359 17 0 144
v_all_customers 35180 35180 0 0.00 0 16 1 0 0
v_all_suppliers 28148 28148 0 0.00 0 23 1 0 0
v_all_wares 37928 37928 0 0.00 0 37 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 966 9 0 0
v_cancel_client_order 3156 3156 0 0.00 0 2222 6 0 0
v_cancel_customer_prepayment 1188 1188 0 0.00 0 5535 11 0 0
v_cancel_customer_reserve 1264 1264 0 0.00 0 9240 22 0 0
v_cancel_payment_to_supplier 720 720 0 0.00 0 12388 27 0 0
v_cancel_supplier_invoice 852 832 20 2.34 0 4680 26 0 20
v_cancel_supplier_order 686 686 0 0.00 0 10819 31 0 0
v_cancel_write_off 1812 1812 0 0.00 0 12408 22 0 0
v_max_id_clo_ord 4977 4977 0 0.00 0 836 2 0 0
v_max_id_clo_res 911 911 0 0.00 0 4538 19 0 0
v_max_id_ord_sup 4965 4965 0 0.00 0 3626 5 0 0
v_max_non_paid_invoice 1271 1271 0 0.00 0 589 3 0 0
v_max_non_paid_realizn 3170 3170 0 0.00 0 1294 4 0 0
v_min_id_clo_ord 4977 4977 0 0.00 0 4335 9 0 0
v_min_id_clo_res 911 911 0 0.00 0 3652 9 0 0
v_min_id_ord_sup 4965 4965 0 0.00 0 6703 12 0 0
v_min_non_paid_invoice 5403 5403 0 0.00 0 13164 18 0 0
v_min_non_paid_realizn 6608 6608 0 0.00 0 13163 19 0 0
v_our_firm 9624 9624 0 0.00 0 17 1 0 0
v_reserve_write_off 18254 18254 0 0.00 0 11977 10 0 0
x_lock_depdocs_on_canc_invoice 8821 8821 0 0.00 0 48944 154 0 0
x_lock_depdocs_on_canc_sup_ord 343 343 0 0.00 0 5904 362 0 0
x_make_qstorno_1000_1200 4977 4977 0 0.00 2 34915 1288 0 0
x_make_qstorno_1200_2000 4967 4967 0 0.00 3 90787 2990 0 0
x_make_qstorno_2100_3300 429200 429200 0 0.00 0 102870 191 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-04-2024 01:11:11 to 11-04-2024 01:11:15.

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
23:09:46 8 8192000000 8802520960 8815218688 7995568 0.097 4 1 2 0 8097824 59472 42784
23:10:46 23676 8192000000 9913178096 10223702016 990234480 10.784 100 84 166 1 1017014512 5583824 21196208
23:12:12 21156 8192000000 9948417872 10272772096 1031496896 11.183 100 91 181 0 1063342976 8384656 23461424
23:13:35 14562 8192000000 9977871792 10306494464 1061900736 11.475 100 89 178 0 1094286656 9826432 22559488
23:14:54 9034 8192000000 10012332336 10352082944 1096691392 11.806 100 71 142 0 1124496128 10505888 17298848
23:16:06 9182 8192000000 10050094928 10404491264 1140448960 12.220 100 76 152 0 1170209936 11977968 17783008
23:17:19 5657 8192000000 10103404464 10470178816 1197854304 12.756 100 73 144 0 1225783504 11743296 16185904
23:18:26 1478 8192000000 10148663152 10522476544 1249009776 13.229 100 81 161 1 1278927680 12392400 17525504
23:19:29 2799 8192000000 10184922928 10561908736 1266300880 13.388 100 85 168 0 1299579376 15297552 17980944
23:20:33 1628 8192000000 10210284096 10597605376 1297314656 13.671 100 83 167 2 1327768608 12143680 18310272
23:21:36 31445 8192000000 10184041168 10601914368 1306252576 13.752 100 38 76 0 1322151008 7166128 8732304
23:23:09 14138 8192000000 10197587584 10616602624 1316730464 13.847 100 22 42 1 1328127344 7074560 4322320
23:24:24 13074 8192000000 10212664000 10632097792 1325911440 13.930 100 22 43 2 1341193168 9800960 5480768
23:25:37 54847 8192000000 10225577600 10643488768 1330580992 13.972 100 33 65 0 1342839120 5148928 7109200
23:27:37 10174 8192000000 10223923408 10647445504 1332972224 13.994 100 26 52 0 1344639968 6803712 4864032
23:28:50 4964 8192000000 10205348576 10620776448 1304913616 13.740 98 28 57 0 1316881456 4991008 6976832
23:30:00 7871 8192000000 10225766560 10628784128 1316874496 13.848 100 48 97 2 1333860016 5869904 11115616
23:31:10 105243 8192000000 10204663008 10605662208 1266708288 13.391 96 52 102 2 1286860416 8337248 11814880
23:34:00 17399 8192000000 10208167712 10613534720 1284883200 13.558 98 43 84 1 1306155744 11811760 9460784
23:35:24 8104 8192000000 10214126432 10619154432 1296746304 13.666 99 50 95 1 1323206096 15679792 10780000
23:36:37 23581 8192000000 10214070384 10617901056 1306475264 13.754 100 38 74 0 1334066448 18578640 9012544
23:38:06 11977 8192000000 10245805904 10643640320 1307330800 13.762 98 50 97 0 1337274416 18470944 11472672
23:39:22 15433 8192000000 10242281952 10648162304 1330039488 13.968 100 43 86 1 1360465984 20135360 10291136
23:40:42 8665 8192000000 10257677552 10654949376 1307085136 13.760 97 57 111 0 1346323776 25579056 13659584
23:41:54 8302 8192000000 10265313472 10662064128 1321151584 13.887 99 68 132 1 1364113136 27322368 15639184
23:43:05 2899 8192000000 10271887264 10659569664 1327519216 13.945 100 76 152 0 1377204240 32247776 17437248
23:44:13 1947 8192000000 10289628816 10684563456 1340473312 14.062 100 85 167 1 1394323072 34300752 19549008
23:45:21 4677 8192000000 10313373184 10712887296 1362792320 14.262 100 77 149 1 1415768560 34998768 17977472
23:46:29 2243 8192000000 10300913904 10702434304 1365324816 14.285 99 76 143 0 1410236944 27800400 17111728
23:47:39 1666 8192000000 10333848000 10737885184 1386907248 14.478 100 77 153 1 1436727984 31376688 18444048
23:48:44 10473 8192000000 10328445472 10743123968 1391375120 14.518 100 52 103 0 1436567808 32212928 12979760
23:50:06 1777 8192000000 10357319824 10766340096 1397701824 14.575 100 75 145 0 1457436000 41592128 18142048
23:51:21 14859 8192000000 10344367968 10775887872 1402274816 14.615 100 36 72 0 1452733184 40382016 10076352
23:52:41 6981 8192000000 10365471152 10790936576 1411429216 14.697 100 48 95 0 1465303696 40891840 12982640
23:53:54 21018 8192000000 10341923904 10777714688 1393879344 14.540 99 28 56 0 1444769712 42614944 8275424
23:55:57 9579 8192000000 10364889632 10797469696 1407122960 14.658 100 34 66 1 1471257440 54884704 9249776
23:57:12 12094 8192000000 10339229504 10780188672 1396903632 14.567 100 22 45 0 1444519024 41836272 5779120
23:58:27 75960 8192000000 10297471872 10748366848 1392748784 14.530 100 12 24 0 1418959408 23514896 2695728
00:01:32 8600 8192000000 10330826384 10771644416 1411601760 14.698 100 34 64 1 1437450352 18494752 7353840
00:02:50 75688 8192000000 10314993776 10764161024 1362781040 14.262 97 36 72 0 1403031392 29815296 10435056
00:05:07 136006 8192000000 10308953856 10758377472 1401876640 14.612 100 27 52 0 1421255472 13462512 5916320
00:08:28 20204 8192000000 10302845728 10755788800 1393198432 14.534 100 31 62 0 1411490688 11007376 7284880
00:09:56 29042 8192000000 10315519216 10767515648 1412115760 14.703 100 21 42 0 1425389152 8733168 4540224
00:11:26 28675 8192000000 10314923024 10762924032 1397976160 14.577 99 25 50 0 1416781936 12905024 5900752
00:12:59 17510 8192000000 10322129216 10762645504 1402565152 14.618 100 60 120 3 1432713664 16664800 13483712
00:14:32 87603 8192000000 10292887488 10740092928 1348877648 14.137 97 23 46 0 1371822144 17693312 5251184
00:17:53 43284 8192000000 10271078720 10715353088 1342507808 14.080 98 25 50 0 1364196800 15455488 6233504
00:19:39 82018 8192000000 10251456208 10716835840 1325242032 13.924 97 29 58 1 1347901184 15645088 7014064
00:22:14 73222 8192000000 10258789072 10725163008 1349085264 14.139 99 8 17 1 1367620304 16442592 2092448
00:24:28 46022 8192000000 10254618032 10711420928 1359978576 14.237 100 14 28 0 1372585312 9676224 2930512
00:26:15 44939 8192000000 10265266800 10716573696 1344372032 14.097 99 25 50 0 1363125408 13123376 5630000
00:28:00 39770 8192000000 10269212816 10711724032 1324612400 13.918 97 26 51 0 1338460016 8434320 5413296
00:29:41 19277 8192000000 10264157984 10696355840 1322149280 13.896 97 39 78 0 1341097696 10705184 8243232
00:31:03 38645 8192000000 10250367056 10695094272 1314252208 13.825 98 15 28 0 1333799088 16098992 3447888
00:32:48 56766 8192000000 10278485568 10719637504 1348337328 14.133 100 18 36 0 1362257920 9573600 4346992
00:34:46 25095 8192000000 10271980496 10709852160 1354988496 14.192 100 34 68 0 1373331968 11018336 7325136
00:36:14 30188 8192000000 10271320480 10718855168 1359449872 14.232 100 19 36 1 1378375552 14281584 4644096
00:37:51 49924 8192000000 10287460272 10727178240 1370422560 14.331 100 40 80 3 1390675040 11648992 8603488
00:39:43 60211 8192000000 10290495424 10724888576 1363062480 14.265 99 36 72 0 1380832816 9094928 8675408
00:41:56 6492 8192000000 10292161984 10735898624 1384316192 14.455 100 35 68 0 1400517904 9097296 7104416
00:43:05 52551 8192000000 10284225792 10745786368 1390833760 14.513 100 32 64 0 1409573280 11511888 7227632
00:44:58 22179 8192000000 10282550768 10739187712 1384733296 14.459 100 7 14 1 1393308208 6839680 1735232
00:46:21 28562 8192000000 10291472656 10747523072 1381768512 14.432 99 20 39 1 1395508496 9106224 4633760
00:47:58 61736 8192000000 10308349760 10760155136 1393977776 14.541 100 18 36 0 1410392064 12073184 4341104
00:50:06 71359 8192000000 10294540016 10746978304 1349301616 14.141 96 23 46 0 1366170320 11681024 5187680
00:52:20 33266 8192000000 10293470064 10726645760 1353234800 14.177 97 35 67 0 1368768560 8662848 6870912
00:53:57 45179 8192000000 10279647200 10729132032 1335543696 14.017 97 28 56 0 1358862560 16704240 6614624
00:55:51 41987 8192000000 10291632032 10730754048 1341900736 14.075 97 26 52 0 1356616944 8957760 5758448
00:57:36 24500 8192000000 10290156336 10717716480 1331850592 13.984 97 23 46 0 1343933728 7183104 4900032
00:59:02 120962 8192000000 10254708784 10693652480 1318744336 13.865 97 17 35 2 1329608384 7123152 3740896
01:02:06 63022 8192000000 10258790912 10718851072 1358548960 14.224 99 20 40 1 1371155040 8289264 4316816
01:04:10 68549 8192000000 10271951472 10740711424 1360729376 14.244 99 16 32 0 1381494128 17944448 2820304
01:06:28 67932 8192000000 10276448496 10723078144 1330640448 13.973 97 28 56 0 1345217120 8423392 6153280
01:08:47 45432 8192000000 10269632656 10716954624 1334233296 14.005 98 29 58 0 1355282768 14145696 6903776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 11-04-2024 01:11:17 to 11-04-2024 01:11:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 72 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          184788
MON$OLDEST_ACTIVE               188096
MON$OLDEST_SNAPSHOT             188096
MON$NEXT_TRANSACTION            188096
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                       1925984
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Apr 11 01:11:35 2024 
 
Database header page information: 
    Flags            0 
    Generation        97924 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    184788 
    Oldest active        188096 
    Oldest snapshot        188096 
    Next transaction    188097 
    Sequence number        0 
    Next attachment ID    740 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.45, total records: 7831528 
    Average version length: 48.16, total versions: 72667, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87280 
    Data pages: 87280, average fill: 72% 
    Primary pages: 87280, secondary pages: 0, swept pages: 18628 
    Empty pages: 4, full pages: 68266 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 140 
    40 - 59% = 2341 
    60 - 79% = 84751 
    80 - 99% = 27 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23700, nodes: 7831528 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.69 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1745807, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 371 
        20 - 39% = 1787 
        40 - 59% = 4430 
        60 - 79% = 2466 
        80 - 99% = 14646 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13718, nodes: 7831528 
    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: 1567795, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1588 
        40 - 59% = 2186 
        60 - 79% = 1124 
        80 - 99% = 8819 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8492, nodes: 7831528 
    Average node length: 6.63, total dup: 5833487, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1560628, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 133 
        20 - 39% = 955 
        40 - 59% = 1527 
        60 - 79% = 930 
        80 - 99% = 4947 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.55, total records: 2290883 
    Average version length: 34.64, total versions: 70402, max versions: 3 
    Average fragment length: 3.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28600 
    Data pages: 28600, average fill: 74% 
    Primary pages: 28592, secondary pages: 8, swept pages: 9621 
    Empty pages: 6, full pages: 22992 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 123 
    40 - 59% = 1338 
    60 - 79% = 26617 
    80 - 99% = 503 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4675, nodes: 2290883 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 711747, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 924 
        40 - 59% = 943 
        60 - 79% = 741 
        80 - 99% = 2067 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2545, nodes: 2293239 
    Average node length: 4.97, total dup: 2292340, max dup: 17647 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1265139, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 247 
        40 - 59% = 1522 
        60 - 79% = 587 
        80 - 99% = 186 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2098, nodes: 2290883 
    Average node length: 4.97, total dup: 2290833, max dup: 130849 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1073096, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 45 
        40 - 59% = 1208 
        60 - 79% = 49 
        80 - 99% = 790 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4514, nodes: 2290883 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 711747, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 572 
        40 - 59% = 725 
        60 - 79% = 854 
        80 - 99% = 2206 
 
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.47, total records: 400 
    Average version length: 22.52, total versions: 257604, max versions: 673 
    Average fragment length: 2.00, total fragments: 45, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1400 
    Data pages: 1400, average fill: 90% 
    Primary pages: 8, secondary pages: 1392, swept pages: 0 
    Empty pages: 1, full pages: 1398 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1399 
 
    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: 5.06, total records: 81498 
    Average version length: 68.28, total versions: 75459, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 17.38 
    Pointer pages: 7, data page slots: 2368 
    Data pages: 1496, average fill: 68% 
    Primary pages: 1494, secondary pages: 2, swept pages: 0 
    Empty pages: 155, full pages: 974 
    Fill distribution: 
     0 - 19% = 223 
    20 - 39% = 88 
    40 - 59% = 115 
    60 - 79% = 241 
    80 - 99% = 829 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1715626, depth: 3, leaf buckets: 275, nodes: 81498 
    Average node length: 13.11, total dup: 4818, max dup: 2 
    Average key length: 10.79, compression ratio: 2.50 
    Average prefix length: 19.15, average data length: 7.85 
    Clustering factor: 61993, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 103 
        40 - 59% = 105 
        60 - 79% = 66 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 19189, max versions: 1040 
    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: 85% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 65 
 
    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: 3.47, total records: 1399 
    Average version length: 43.27, total versions: 1288, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 16.73 
    Pointer pages: 1, data page slots: 24 
    Data pages: 22, average fill: 61% 
    Primary pages: 22, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 12 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92931, depth: 2, leaf buckets: 2, nodes: 1399 
    Average node length: 4.28, total dup: 1301, max dup: 131 
    Average key length: 2.73, compression ratio: 6.96 
    Average prefix length: 18.34, average data length: 0.66 
    Clustering factor: 758, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.04, total records: 74 
    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: 52% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.16, total records: 760651 
    Average version length: 25.47, total versions: 61956, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8240 
    Data pages: 8232, average fill: 65% 
    Primary pages: 8191, secondary pages: 41, swept pages: 2273 
    Empty pages: 171, full pages: 5577 
    Fill distribution: 
     0 - 19% = 395 
    20 - 39% = 404 
    40 - 59% = 595 
    60 - 79% = 6659 
    80 - 99% = 179 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 888, nodes: 760651 
    Average node length: 4.86, total dup: 760602, max dup: 133110 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 86976, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 181 
        40 - 59% = 509 
        60 - 79% = 162 
        80 - 99% = 36 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 930, nodes: 760651 
    Average node length: 5.87, total dup: 677262, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 152632, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 157 
        40 - 59% = 364 
        60 - 79% = 169 
        80 - 99% = 239 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 987, nodes: 760651 
    Average node length: 5.87, total dup: 677262, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 154567, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 249 
        40 - 59% = 372 
        60 - 79% = 147 
        80 - 99% = 219 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1110, nodes: 760651 
    Average node length: 5.95, total dup: 677262, max dup: 43 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 147821, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 280 
        40 - 59% = 569 
        60 - 79% = 175 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.82, total records: 5422 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.42, total fragments: 81, 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: 74, secondary pages: 22, swept pages: 49 
    Empty pages: 7, full pages: 66 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 5, nodes: 5422 
    Average node length: 5.46, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.00 
    Average prefix length: 34.35, average data length: 1.55 
    Clustering factor: 5174, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5422 
    Average node length: 11.08, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 142, 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.14, total records: 85719 
    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: 832 
    Data pages: 832, average fill: 71% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 826 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 826 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35682, depth: 2, leaf buckets: 110, nodes: 85719 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3359, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 107 
 
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.22, 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.20 
    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: 149.30, total records: 179760 
    Average version length: 150.67, total versions: 1853, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 6, data page slots: 5408 
    Data pages: 4312, average fill: 86% 
    Primary pages: 4312, secondary pages: 0, swept pages: 2 
    Empty pages: 49, full pages: 4246 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4246 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 148.17, total records: 175882 
    Average version length: 153.38, total versions: 3352, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 8, data page slots: 5288 
    Data pages: 4232, average fill: 86% 
    Primary pages: 4231, secondary pages: 1, swept pages: 2 
    Empty pages: 54, full pages: 4162 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4162 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.06, total records: 185739 
    Average version length: 152.81, total versions: 3684, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 6680 
    Data pages: 4464, average fill: 86% 
    Primary pages: 4464, secondary pages: 0, swept pages: 7 
    Empty pages: 54, full pages: 4394 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4393 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.29, total records: 169775 
    Average version length: 152.98, total versions: 5230, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 7, data page slots: 4960 
    Data pages: 4112, average fill: 85% 
    Primary pages: 4112, secondary pages: 0, swept pages: 6 
    Empty pages: 62, full pages: 3995 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 8 
    40 - 59% = 37 
    60 - 79% = 7 
    80 - 99% = 3994 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 148.34, total records: 170421 
    Average version length: 152.08, total versions: 3023, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 6, data page slots: 5424 
    Data pages: 4112, average fill: 85% 
    Primary pages: 4112, secondary pages: 0, swept pages: 1 
    Empty pages: 63, full pages: 4027 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 4028 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.75, total records: 181287 
    Average version length: 153.19, total versions: 3824, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 7, data page slots: 5424 
    Data pages: 4344, average fill: 86% 
    Primary pages: 4344, secondary pages: 0, swept pages: 5 
    Empty pages: 37, full pages: 4281 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 3 
    40 - 59% = 16 
    60 - 79% = 5 
    80 - 99% = 4280 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.44, total records: 173216 
    Average version length: 152.36, total versions: 3788, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 6, data page slots: 4984 
    Data pages: 4200, average fill: 85% 
    Primary pages: 4199, secondary pages: 1, swept pages: 11 
    Empty pages: 90, full pages: 4089 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 13 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 4088 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 150.06, total records: 188747 
    Average version length: 150.30, total versions: 1360, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 9, data page slots: 4752 
    Data pages: 4488, average fill: 87% 
    Primary pages: 4488, secondary pages: 0, swept pages: 4 
    Empty pages: 12, full pages: 4471 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4471 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 146.58, total records: 176204 
    Average version length: 152.55, total versions: 5117, 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: 5552 
    Data pages: 4240, average fill: 86% 
    Primary pages: 4240, secondary pages: 0, swept pages: 4 
    Empty pages: 61, full pages: 4166 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 4167 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 140.93, total records: 185696 
    Average version length: 154.86, total versions: 12277, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.03 
    Pointer pages: 6, data page slots: 6080 
    Data pages: 4528, average fill: 85% 
    Primary pages: 4528, secondary pages: 0, swept pages: 11 
    Empty pages: 104, full pages: 4389 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 14 
    40 - 59% = 8 
    60 - 79% = 9 
    80 - 99% = 4388 
 
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: 52.00, total records: 2152141 
    Average version length: 52.91, total versions: 30699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25704 
    Data pages: 25696, average fill: 72% 
    Primary pages: 25696, secondary pages: 0, swept pages: 9869 
    Empty pages: 238, full pages: 22323 
    Fill distribution: 
     0 - 19% = 429 
    20 - 39% = 310 
    40 - 59% = 739 
    60 - 79% = 23960 
    80 - 99% = 258 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2644, nodes: 2152141 
    Average node length: 5.44, total dup: 2009771, max dup: 1723 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185183, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 287 
        40 - 59% = 1753 
        60 - 79% = 298 
        80 - 99% = 304 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2768, nodes: 2152141 
    Average node length: 5.69, total dup: 1932230, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 383822, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2290 
        60 - 79% = 443 
        80 - 99% = 32 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2183, nodes: 2152141 
    Average node length: 4.96, total dup: 2152041, max dup: 28543 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182924, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 139 
        40 - 59% = 1215 
        60 - 79% = 430 
        80 - 99% = 396 
 
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: 38.08, total records: 147323 
    Average version length: 69.19, total versions: 66285, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.31 
    Pointer pages: 3, data page slots: 4568 
    Data pages: 3496, average fill: 49% 
    Primary pages: 3495, secondary pages: 1, swept pages: 571 
    Empty pages: 691, full pages: 1782 
    Fill distribution: 
     0 - 19% = 1175 
    20 - 39% = 343 
    40 - 59% = 129 
    60 - 79% = 605 
    80 - 99% = 1244 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104750, depth: 3, leaf buckets: 232, nodes: 147323 
    Average node length: 6.42, total dup: 128104, max dup: 14 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 25537, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 55 
        40 - 59% = 114 
        60 - 79% = 54 
        80 - 99% = 9 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.23, total records: 6795176 
    Average version length: 68.82, total versions: 367882, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 63, data page slots: 101680 
    Data pages: 101680, average fill: 72% 
    Primary pages: 101680, secondary pages: 0, swept pages: 27331 
    Empty pages: 118, full pages: 69410 
    Fill distribution: 
     0 - 19% = 1038 
    20 - 39% = 2747 
    40 - 59% = 8762 
    60 - 79% = 84287 
    80 - 99% = 4846 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10667, nodes: 6795176 
    Average node length: 6.51, total dup: 5877582, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1542361, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 2279 
        40 - 59% = 5590 
        60 - 79% = 2310 
        80 - 99% = 478 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8301, nodes: 6795176 
    Average node length: 5.41, total dup: 6517955, max dup: 171 
    Average key length: 2.42, compression ratio: 7.04 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1339407, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1174 
        40 - 59% = 4571 
        60 - 79% = 1638 
        80 - 99% = 908 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8371, nodes: 6795176 
    Average node length: 5.41, total dup: 6517955, max dup: 171 
    Average key length: 2.42, compression ratio: 7.04 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1341966, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1223 
        40 - 59% = 4621 
        60 - 79% = 1652 
        80 - 99% = 866 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.04, total records: 11895803 
    Average version length: 68.79, total versions: 331290, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 103, data page slots: 166992 
    Data pages: 166992, average fill: 76% 
    Primary pages: 166992, secondary pages: 0, swept pages: 79724 
    Empty pages: 3, full pages: 145551 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 444 
    40 - 59% = 4722 
    60 - 79% = 156630 
    80 - 99% = 5176 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18419, nodes: 11895803 
    Average node length: 6.57, total dup: 10373625, max dup: 65 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.71, average data length: 1.29 
    Clustering factor: 2372676, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 2877 
        40 - 59% = 10634 
        60 - 79% = 4035 
        80 - 99% = 849 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 44.13, total records: 1560447 
    Average version length: 69.13, total versions: 564679, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.85 
    Pointer pages: 30, data page slots: 46576 
    Data pages: 27056, average fill: 66% 
    Primary pages: 27056, secondary pages: 0, swept pages: 7029 
    Empty pages: 2305, full pages: 18239 
    Fill distribution: 
     0 - 19% = 3790 
    20 - 39% = 1738 
    40 - 59% = 1697 
    60 - 79% = 10889 
    80 - 99% = 8942 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2051, nodes: 1560447 
    Average node length: 5.51, total dup: 1497639, max dup: 99 
    Average key length: 2.56, compression ratio: 16.43 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 103213, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 415 
        40 - 59% = 1034 
        60 - 79% = 457 
        80 - 99% = 129 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 39.83, total records: 1000198 
    Average version length: 69.15, total versions: 423207, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.16 
    Pointer pages: 24, data page slots: 38176 
    Data pages: 29616, average fill: 39% 
    Primary pages: 29616, secondary pages: 0, swept pages: 9175 
    Empty pages: 9149, full pages: 10130 
    Fill distribution: 
     0 - 19% = 13153 
    20 - 39% = 2590 
    40 - 59% = 2113 
    60 - 79% = 4738 
    80 - 99% = 7022 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1360, nodes: 1000198 
    Average node length: 5.79, total dup: 933147, max dup: 97 
    Average key length: 2.87, compression ratio: 14.64 
    Average prefix length: 41.20, average data length: 0.80 
    Clustering factor: 132533, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 261 
        40 - 59% = 686 
        60 - 79% = 330 
        80 - 99% = 80 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.29, total records: 9447748 
    Average version length: 69.01, total versions: 357368, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 90, data page slots: 146568 
    Data pages: 146552, average fill: 69% 
    Primary pages: 146551, secondary pages: 1, swept pages: 56668 
    Empty pages: 465, full pages: 90580 
    Fill distribution: 
     0 - 19% = 1553 
    20 - 39% = 7656 
    40 - 59% = 22761 
    60 - 79% = 108525 
    80 - 99% = 6057 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13551, nodes: 9447748 
    Average node length: 6.69, total dup: 7840341, max dup: 29 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2037186, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1256 
        40 - 59% = 6346 
        60 - 79% = 5005 
        80 - 99% = 944 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21237192 
    Average version length: 82.93, total versions: 11853, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 319992 
    Data pages: 319992, average fill: 81% 
    Primary pages: 319992, secondary pages: 0, swept pages: 12922 
    Empty pages: 11, full pages: 319684 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 17 
    40 - 59% = 34 
    60 - 79% = 27556 
    80 - 99% = 292363 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19527, nodes: 21237192 
    Average node length: 5.72, total dup: 20754176, max dup: 127 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3296744, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8275 
        60 - 79% = 557 
        80 - 99% = 10689 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17308, nodes: 21237192 
    Average node length: 6.31, total dup: 18664608, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918483, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 879 
        60 - 79% = 334 
        80 - 99% = 16089 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21345, nodes: 21237192 
    Average node length: 6.35, total dup: 18581559, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3591348, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 8589 
        60 - 79% = 681 
        80 - 99% = 12074 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16308, nodes: 21237192 
    Average node length: 5.56, total dup: 21237092, max dup: 230051 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947277, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 13 
        40 - 59% = 3144 
        60 - 79% = 434 
        80 - 99% = 12716 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.39, total records: 9918007 
    Average version length: 82.66, total versions: 365153, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 108, data page slots: 174832 
    Data pages: 174792, average fill: 70% 
    Primary pages: 174792, secondary pages: 0, swept pages: 77618 
    Empty pages: 913, full pages: 106444 
    Fill distribution: 
     0 - 19% = 2473 
    20 - 39% = 8603 
    40 - 59% = 27496 
    60 - 79% = 68392 
    80 - 99% = 67828 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11423, nodes: 9918007 
    Average node length: 5.38, total dup: 9604568, max dup: 210 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2190937, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 105 
        40 - 59% = 7515 
        60 - 79% = 3673 
        80 - 99% = 126 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13978, nodes: 9918007 
    Average node length: 6.25, total dup: 8224744, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1519144, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 154 
        20 - 39% = 4075 
        40 - 59% = 4610 
        60 - 79% = 2714 
        80 - 99% = 2425 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12747, nodes: 9918007 
    Average node length: 6.00, total dup: 8610195, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2383274, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 119 
        40 - 59% = 8421 
        60 - 79% = 4052 
        80 - 99% = 152 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10317, nodes: 9918007 
    Average node length: 5.15, total dup: 9917907, max dup: 142225 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1565682, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1171 
        40 - 59% = 5219 
        60 - 79% = 1734 
        80 - 99% = 2151 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.40, total records: 11507954 
    Average version length: 82.58, total versions: 266554, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 120, data page slots: 194744 
    Data pages: 193232, average fill: 73% 
    Primary pages: 193232, secondary pages: 0, swept pages: 69709 
    Empty pages: 3358, full pages: 148471 
    Fill distribution: 
     0 - 19% = 5678 
    20 - 39% = 7527 
    40 - 59% = 16457 
    60 - 79% = 42044 
    80 - 99% = 121526 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13120, nodes: 11507954 
    Average node length: 5.30, total dup: 11397250, max dup: 704 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2405831, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 151 
        40 - 59% = 8527 
        60 - 79% = 4185 
        80 - 99% = 257 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10715, nodes: 11507954 
    Average node length: 5.50, total dup: 11006645, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 734231, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 882 
        40 - 59% = 2763 
        60 - 79% = 1904 
        80 - 99% = 5021 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15017, nodes: 11507954 
    Average node length: 6.03, total dup: 10045128, max dup: 84 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2422376, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 181 
        40 - 59% = 10042 
        60 - 79% = 4480 
        80 - 99% = 311 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11044, nodes: 11507954 
    Average node length: 5.23, total dup: 11507854, max dup: 180697 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 722224, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 107 
        20 - 39% = 846 
        40 - 59% = 5062 
        60 - 79% = 1476 
        80 - 99% = 3553 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.60, total records: 10050580 
    Average version length: 82.94, total versions: 381939, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 110, data page slots: 178568 
    Data pages: 178504, average fill: 70% 
    Primary pages: 178504, secondary pages: 0, swept pages: 80445 
    Empty pages: 889, full pages: 106363 
    Fill distribution: 
     0 - 19% = 2568 
    20 - 39% = 9190 
    40 - 59% = 28619 
    60 - 79% = 70930 
    80 - 99% = 67197 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12162, nodes: 10050580 
    Average node length: 5.20, total dup: 10021278, max dup: 1547 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2000460, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1555 
        40 - 59% = 8013 
        60 - 79% = 1964 
        80 - 99% = 598 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14144, nodes: 10050580 
    Average node length: 6.26, total dup: 8333913, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1485979, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 204 
        20 - 39% = 4061 
        40 - 59% = 4652 
        60 - 79% = 2663 
        80 - 99% = 2564 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12774, nodes: 10050580 
    Average node length: 5.45, total dup: 9601868, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2137038, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 1459 
        40 - 59% = 8950 
        60 - 79% = 1737 
        80 - 99% = 607 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10583, nodes: 10050580 
    Average node length: 5.17, total dup: 10050480, max dup: 144173 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1588820, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1216 
        40 - 59% = 5554 
        60 - 79% = 1660 
        80 - 99% = 2119 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.54, total records: 583755 
    Average version length: 68.82, total versions: 5494, 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: 8064 
    Data pages: 8064, average fill: 76% 
    Primary pages: 8064, secondary pages: 0, swept pages: 3639 
    Empty pages: 2, full pages: 7103 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 26 
    40 - 59% = 195 
    60 - 79% = 7748 
    80 - 99% = 91 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41070, depth: 3, leaf buckets: 751, nodes: 583755 
    Average node length: 5.95, total dup: 497094, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101456, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 538 
        60 - 79% = 95 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31079, depth: 3, leaf buckets: 773, nodes: 583755 
    Average node length: 6.15, total dup: 478791, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101512, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 548 
        60 - 79% = 106 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 573, nodes: 583755 
    Average node length: 4.86, total dup: 583655, max dup: 9539 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90161, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 18 
        40 - 59% = 335 
        60 - 79% = 97 
        80 - 99% = 122 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Apr 11 01:11:59 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7831528 72667 1 0.0000 0.0000
DOC_LIST 2290883 70402 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 257604 673 64400.0000 0.0000
INVNT_TURNOVER_LOG 81498 75459 1 0.0000 0.0000
MONEY_SALDO 49 19189 1040 39100.0000 0.0000
MONEY_TURNOVER_LOG 1399 1288 1 0.0000 0.0000
PDISTR 760651 61956 4 0.0000 0.0000
PERF_SPLIT_0 179760 1853 1 0.0000 0.0000
PERF_SPLIT_1 175882 3352 1 0.0000 0.0000
PERF_SPLIT_2 185739 3684 1 0.0000 0.0000
PERF_SPLIT_3 169775 5230 1 0.0000 0.0000
PERF_SPLIT_4 170421 3023 1 0.0000 0.0000
PERF_SPLIT_5 181287 3824 1 0.0000 0.0000
PERF_SPLIT_6 173216 3788 1 0.0000 0.0000
PERF_SPLIT_7 188747 1360 1 0.0000 0.0000
PERF_SPLIT_8 176204 5117 1 0.0000 0.0000
PERF_SPLIT_9 185696 12277 1 0.0000 0.0000
PSTORNED 2152141 30699 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 147323 66285 1 0.0000 0.0000
XQD_1000_3300 6795176 367882 1 0.0000 0.0000
XQD_1200_2000 11895803 331290 1 0.0000 0.0000
XQD_2000_3300 1560447 564679 1 0.0000 0.0000
XQD_2100_3300 1000198 423207 1 0.0000 0.0000
XQD_3300_3400 9447748 357368 1 0.0000 0.0000
XQS_1000_1200 21237192 11853 1 0.0000 0.0000
XQS_1000_3300 9918007 365153 1 0.0000 0.0000
XQS_1200_2000 11507954 266554 1 0.0000 0.0000
XQS_2100_3300 10050580 381939 1 0.0000 0.0000
XQS_3300_3400 583755 5494 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 ---
:1061: 
:1062: mscs-test-161.budzdorov.ru    Thu Apr 11 01:09:46 2024
:1063:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1064: 
:1065: 
:1066: mscs-test-161.budzdorov.ru    Thu Apr 11 01:10:01 2024
:1067:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1068: 
--- end of diff output ---

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

11.04.24 01:12:10. 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-04-11 01:12:13 No severe PSQL-related problems occured
11.04.24 01:12:14. End of report.