Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 03.04.2024 04:09
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 15386624 kB
MemAvailable 30140404 kB
Buffers 20 kB
Cached 16278536 kB
SwapCached 2492 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 4.0.5
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
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-03 04:07:49
DTS_END                         2024-04-03 04:07:48.9950
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/60654
TRN_ID                          166341
ATT_ID                          481
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.13 18134 928513
customer order: creation 170.76 383 17076
customer order: refuse 14.00 379 1400
order to supplier: creation 43.95 1207 4395
order to supplier: removal 3.85 89178 385
invoice (draft): creation 45.17 3052 4517
invoice (draft): removal 53.04 696 5304
invoice accept: apply 39.34 20267 3934
invoice accept: cancel 47.57 856 4757
customer reserve: creation 3880.91 188 388091
customer reserve: removal 4692.63 58 469263
realization accept: apply 81.18 206 8118
realization accept: cancel 87.66 134 8766
payment from customer: creation 57.75 134 5775
payment from customer: removal 6.12 120 612
payment to supplier: creation 47.81 144 4781
payment to supplier: removal 3.66 92 366
service: total inventory turnovers 3.23 4917 323
service: total monetary turnovers 5.50 678 550
service: aggregate perf. data 0.97 16422 97
service: refresh index statistics 0.03 223570 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 03-04-2024 04:09:50 to 03-04-2024 04:09:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2042
TEST_TIME 2 2804
TEST_TIME 3 4171
TEST_TIME 4 3861
TEST_TIME 5 4249
TEST_TIME 6 4256
TEST_TIME 7 4019
TEST_TIME 8 4289
TEST_TIME 9 5039
TEST_TIME 10 5104
TEST_TIME 11 5564
TEST_TIME 12 5479
TEST_TIME 13 6178
TEST_TIME 14 6837
TEST_TIME 15 7177
TEST_TIME 16 7357
TEST_TIME 17 7886
TEST_TIME 18 8425
TEST_TIME 19 8592
TEST_TIME 20 8718
TEST_TIME 21 8645
TEST_TIME 22 8808
TEST_TIME 23 9110
TEST_TIME 24 9543
TEST_TIME 25 9801
TEST_TIME 26 9473
TEST_TIME 27 9653
TEST_TIME 28 9569
TEST_TIME 29 9446
TEST_TIME 30 9788
TEST_TIME 31 9599
TEST_TIME 32 9622
TEST_TIME 33 9478
TEST_TIME 34 9461
TEST_TIME 35 9504
TEST_TIME 36 9608
TEST_TIME 37 9586
TEST_TIME 38 9732
TEST_TIME 39 9720
TEST_TIME 40 9681
TEST_TIME 41 9651
TEST_TIME 42 9751
TEST_TIME 43 9875
TEST_TIME 44 9794
TEST_TIME 45 9761
TEST_TIME 46 9598
TEST_TIME 47 9550
TEST_TIME 48 9585
TEST_TIME 49 9519
TEST_TIME 50 9430
TEST_TIME 51 9430
TEST_TIME 52 9389
TEST_TIME 53 9370
TEST_TIME 54 9415
TEST_TIME 55 9390
TEST_TIME 56 9404
TEST_TIME 57 9294
TEST_TIME 58 9296
TEST_TIME 59 9266
TEST_TIME 60 9220
TEST_TIME 61 9230
TEST_TIME 62 9226
TEST_TIME 63 9183
TEST_TIME 64 9254
TEST_TIME 65 9227
TEST_TIME 66 9349
TEST_TIME 67 9335
TEST_TIME 68 9361
TEST_TIME 69 9416
TEST_TIME 70 9468
TEST_TIME 71 9539
TEST_TIME 72 9564
TEST_TIME 73 9473
TEST_TIME 74 9430
TEST_TIME 75 9354
TEST_TIME 76 9326
TEST_TIME 77 9281
TEST_TIME 78 9270
TEST_TIME 79 9240
TEST_TIME 80 9198
TEST_TIME 81 9150
TEST_TIME 82 9093
TEST_TIME 83 9166
TEST_TIME 84 9148
TEST_TIME 85 9135
TEST_TIME 86 9142
TEST_TIME 87 9173
TEST_TIME 88 9152
TEST_TIME 89 9223
TEST_TIME 90 9282
TEST_TIME 91 9307
TEST_TIME 92 9318
TEST_TIME 93 9334
TEST_TIME 94 9358
TEST_TIME 95 9418
TEST_TIME 96 9403
TEST_TIME 97 9357
TEST_TIME 98 9306
TEST_TIME 99 9297
TEST_TIME 100 9292

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-04-2024 04:09:54 to 03-04-2024 04:09:57.

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 1285089 1285089 0 0.00 0 31479 7 0 0
doc_list_biud 1285089 1285089 0 0.00 0 42571 26 0 0
sp_add_invoice_to_stock 4018 3934 84 2.09 43 195299 20268 0 84
sp_cancel_adding_invoice 4757 4757 0 0.00 4 76003 857 0 0
sp_cancel_client_order 1400 1400 0 0.00 4 8784 380 0 0
sp_cancel_customer_reserve 469263 469263 0 0.00 0 29136 58 0 0
sp_cancel_pay_from_customer 612 612 0 0.00 2 13058 121 0 0
sp_cancel_pay_to_supplier 366 366 0 0.00 2 9242 93 0 0
sp_cancel_supplier_invoice 5309 5304 5 0.09 1 17999 697 0 5
sp_cancel_supplier_order 385 385 0 0.00 6 976873 89178 0 0
sp_cancel_write_off 8766 8766 0 0.00 1 13815 135 0 0
sp_client_order 17076 17076 0 0.00 3 32270 384 0 0
sp_customer_reserve 388091 388091 0 0.00 0 62092 189 0 0
sp_fill_shopping_cart 25974 25974 0 0.00 1 19512 34 0 0
sp_fill_shopping_cart_clo_res 388083 388083 0 0.00 0 21622 16 0 0
sp_get_clo_for_invoice 3924 3924 0 0.00 0 31464 390 0 0
sp_kill_cost_storno 14501 14501 0 0.00 0 9709 72 0 0
sp_kill_qstorno_ret_qs2qd 952981 952981 0 0.00 0 29082 31 0 0
sp_kill_qty_storno 501917 501917 0 0.00 0 42570 67 0 0
sp_lock_selected_doc 16884 16884 0 0.00 0 9534 5 0 0
sp_make_cost_storno 22598 22598 0 0.00 0 31266 67 0 0
sp_multiply_rows_for_pdistr 22598 22598 0 0.00 0 10304 33 0 0
sp_multiply_rows_for_qdistr 17076 17076 0 0.00 0 32041 178 0 0
sp_pay_from_customer 5775 5775 0 0.00 4 30874 134 0 0
sp_pay_to_supplier 4781 4781 0 0.00 4 12550 145 0 0
sp_payment_common 10556 10556 0 0.00 1 6061 21 0 0
sp_qd_handle_on_cancel_clo 1400 1400 0 0.00 0 5337 332 0 0
sp_qd_handle_on_invoice_upd_sts 8681 8681 0 0.00 0 42566 324 0 0
sp_qd_handle_on_reserve_upd_sts 8118 8118 0 0.00 0 16736 64 0 0
sp_reserve_write_off 8118 8118 0 0.00 6 31018 206 0 0
sp_supplier_invoice 4517 4517 0 0.00 6 85478 3052 0 0
sp_supplier_order 4395 4395 0 0.00 4 25361 1207 0 0
srv_aggregate_perf_data 97 97 0 0.00 1673 298786 16422 0 0
srv_fill_mon_cache_memory 51 51 0 0.00 744 122356 48076 0 0
srv_find_qd_qs_mism 887747 887747 0 0.00 0 15676 6 0 0
srv_make_invnt_saldo 323 323 0 0.00 40 110769 4918 0 0
srv_make_money_saldo 550 550 0 0.00 1 13308 679 0 0
srv_recalc_idx_stat 3 3 0 0.00 154111 272799 223571 0 0
t$perf-abend:sp_add_invoice_to_stock 84 84 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 3934 3934 0 0.00 0 31006 200 0 0
t$perf-norm:sp_cancel_adding_invoice 325 325 0 0.00 1 34286 191 0 0
t$perf-norm:sp_cancel_client_order 1400 1400 0 0.00 0 1118 10 0 0
t$perf-norm:sp_cancel_customer_reserve 591 591 0 0.00 0 578 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 612 612 0 0.00 0 2744 23 0 0
t$perf-norm:sp_cancel_pay_to_supplier 366 366 0 0.00 0 886 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 346 346 0 0.00 0 571 12 0 0
t$perf-norm:sp_cancel_supplier_order 385 385 0 0.00 0 47615 1821 0 0
t$perf-norm:sp_cancel_write_off 817 817 0 0.00 0 726 3 0 0
t$perf-norm:sp_client_order 17076 17076 0 0.00 0 24278 19 0 0
t$perf-norm:sp_customer_reserve 805 805 0 0.00 0 855 4 0 0
t$perf-norm:sp_pay_from_customer 5775 5775 0 0.00 0 6059 12 0 0
t$perf-norm:sp_pay_to_supplier 4781 4781 0 0.00 0 6158 12 0 0
t$perf-norm:sp_reserve_write_off 8118 8118 0 0.00 0 4052 10 0 0
t$perf-norm:sp_supplier_invoice 4517 4517 0 0.00 0 6688 17 0 0
t$perf-norm:sp_supplier_order 4395 4395 0 0.00 0 8300 15 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 922 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 51 51 0 0.00 0 2792 57 0 0
t$perf-norm:srv_make_invnt_saldo 323 323 0 0.00 0 3362 21 0 0
t$perf-norm:srv_make_money_saldo 550 550 0 0.00 0 441 3 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 22 9 0 0
v_add_invoice_to_stock 8016 7848 168 2.09 0 11624 24 0 168
v_all_customers 31734 31734 0 0.00 0 20 1 0 0
v_all_suppliers 25306 25306 0 0.00 0 36 1 0 0
v_all_wares 34148 34148 0 0.00 0 30 1 0 0
v_cancel_adding_invoice 650 650 0 0.00 0 4988 15 0 0
v_cancel_client_order 2800 2800 0 0.00 0 8554 15 0 0
v_cancel_customer_prepayment 1224 1224 0 0.00 0 13034 25 0 0
v_cancel_customer_reserve 1182 1182 0 0.00 0 8652 12 0 0
v_cancel_payment_to_supplier 732 732 0 0.00 0 8676 23 0 0
v_cancel_supplier_invoice 702 692 10 1.42 0 641 15 0 10
v_cancel_supplier_order 770 770 0 0.00 0 13062 30 0 0
v_cancel_write_off 1634 1634 0 0.00 0 13725 25 0 0
v_max_id_clo_ord 4390 4390 0 0.00 0 859 1 0 0
v_max_id_clo_res 805 805 0 0.00 0 3196 19 0 0
v_max_id_ord_sup 4509 4509 0 0.00 0 3800 5 0 0
v_max_non_paid_invoice 1027 1027 0 0.00 0 3742 6 0 0
v_max_non_paid_realizn 2731 2731 0 0.00 0 1587 3 0 0
v_min_id_clo_ord 4390 4390 0 0.00 0 1058 4 0 0
v_min_id_clo_res 805 805 0 0.00 0 8162 28 0 0
v_min_id_ord_sup 4509 4509 0 0.00 0 3741 5 0 0
v_min_non_paid_invoice 4781 4781 0 0.00 0 6056 16 0 0
v_min_non_paid_realizn 5775 5775 0 0.00 0 6004 15 0 0
v_our_firm 8502 8502 0 0.00 0 14 1 0 0
v_reserve_write_off 16236 16236 0 0.00 0 13119 11 0 0
x_lock_depdocs_on_canc_invoice 9715 9715 0 0.00 0 12744 130 0 0
x_lock_depdocs_on_canc_sup_ord 385 385 0 0.00 0 8859 323 0 0
x_make_qstorno_1000_1200 4395 4395 0 0.00 1 25332 1143 0 0
x_make_qstorno_1200_2000 4517 4517 0 0.00 3 85155 2923 0 0
x_make_qstorno_2100_3300 388091 388091 0 0.00 0 62091 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-04-2024 04:09:58 to 03-04-2024 04:10:02.

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
02:07:52 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
02:08:53 23904 8192000000 9689712432 9985531904 772290000 8.615 100 89 178 0 801314656 7336608 21688048
02:10:20 13486 8192000000 9726313024 10028515328 804585952 8.943 100 93 186 0 838166096 11126592 22453552
02:11:54 18166 8192000000 9769059232 10085298176 841562544 9.315 100 90 180 0 883911744 21455520 20893680
02:13:14 10561 8192000000 9815230416 10148802560 886880000 9.768 100 74 148 0 932277440 29494560 15902880
02:14:27 6368 8192000000 9899627696 10238599168 930625680 10.201 100 82 161 0 1004044080 57042080 16376320
02:15:38 4168 8192000000 9942582832 10293219328 962839888 10.517 100 81 159 0 1053975200 75802752 15332560
02:16:44 2458 8192000000 9959743504 10321207296 994541104 10.826 100 78 156 0 1078450416 68241152 15668160
02:17:50 2422 8192000000 10008910736 10374926336 1026721104 11.137 100 85 164 0 1119230640 76878592 15630944
02:18:53 2026 8192000000 10016322208 10387980288 1047465488 11.336 100 83 165 1 1134124112 70520992 16137632
02:19:57 2140 8192000000 10039841552 10416758784 1063576112 11.491 100 87 172 0 1150869136 69669088 17623936
02:21:01 12078 8192000000 10012768592 10399981568 1069451440 11.547 100 67 132 1 1125490288 43118816 12920032
02:22:14 5517 8192000000 9988150560 10398859264 1072875264 11.580 100 29 57 0 1107865200 28805440 6184496
02:23:23 4682 8192000000 9989370064 10397450240 1080826000 11.655 100 53 107 0 1117362256 25172064 11364192
02:24:33 8525 8192000000 9991030640 10400714752 1084037152 11.686 100 26 52 1 1111478240 21890944 5550144
02:25:42 41269 8192000000 10001493376 10413232128 1089836928 11.741 100 49 99 1 1114665200 13887872 10940400
02:27:24 3663 8192000000 10012772048 10421587968 1089569776 11.739 100 29 56 0 1126887856 31806288 5511792
02:28:33 31282 8192000000 10035505136 10444058624 1102535136 11.862 100 48 96 0 1140522336 28446816 9540384
02:30:14 5236 8192000000 10089923904 10484318208 1099923088 11.837 99 57 113 0 1177129168 65834656 11371424
02:31:23 118160 8192000000 10185022880 10621820928 1110330464 11.936 99 47 94 1 1263238592 142988544 9919584
02:34:44 13611 8192000000 10191140896 10590728192 1104290064 11.878 99 54 108 1 1292515568 176708864 11516640
02:36:05 13318 8192000000 10246527136 10650947584 1106924144 11.903 98 51 100 1 1334114800 216099024 11091632
02:37:25 13145 8192000000 10221319136 10619092992 1086456944 11.709 97 54 107 2 1311113536 213246672 11409920
02:38:44 26726 8192000000 10219317680 10618945536 1064924016 11.504 94 42 81 1 1263420672 190304400 8192256
02:40:13 6423 8192000000 10223488496 10632208384 1084418768 11.690 99 57 114 0 1339416976 242559568 12438640
02:41:30 1600 8192000000 10275902288 10664038400 1110465792 11.937 99 85 168 2 1369999168 241832896 17700480
02:42:34 6685 8192000000 10251519440 10658795520 1113429408 11.965 99 66 132 0 1350996816 222415712 15151696
02:43:45 737 8192000000 10275833728 10667274240 1111552064 11.947 100 72 142 1 1369289904 242117184 15620656
02:44:53 2297 8192000000 10278202816 10673741824 1137335264 12.190 100 86 171 0 1374137584 218163200 18639120
02:45:57 3565 8192000000 10266981024 10683584512 1134283984 12.162 100 39 78 0 1369091136 225958224 8848928
02:47:05 2563 8192000000 10243119632 10648494080 1132973072 12.149 100 58 114 0 1341129984 195726256 12430656
02:48:11 8857 8192000000 10254008112 10680197120 1137729216 12.194 100 23 46 0 1359694144 216566656 5398272
02:49:25 14709 8192000000 10292247600 10740453376 1128434960 12.107 100 24 48 0 1383309648 249240576 5634112
02:51:10 13267 8192000000 10194948208 10639712256 1103078112 11.867 99 28 55 0 1304824928 195264224 6482592
02:52:27 33241 8192000000 10172119920 10595393536 1126727056 12.090 100 44 87 0 1267200832 130501872 9971904
02:54:05 45839 8192000000 10162539008 10648190976 1136177584 12.180 100 21 42 0 1251412160 110830864 4403712
02:55:53 42660 8192000000 10172245712 10648096768 1123816992 12.063 99 16 30 0 1250464864 123145104 3502768
02:59:05 69437 8192000000 10058622720 10490994688 1107785872 11.911 98 24 46 0 1163377360 50561168 5030320
03:01:19 43676 8192000000 10091063136 10536722432 1129810848 12.120 99 41 80 0 1193801056 56174112 7816096
03:03:03 105980 8192000000 10085576192 10561654784 1127550480 12.098 100 11 22 0 1213254592 83687712 2016400
03:05:50 95790 8192000000 10095398704 10550857728 1128273712 12.105 99 16 32 0 1181349920 49640736 3435472
03:08:30 74596 8192000000 10104663504 10591215616 1125690704 12.081 98 9 18 0 1189640160 62324752 1624704
03:10:46 73601 8192000000 10105151776 10535931904 1151096368 12.320 100 16 32 0 1182006304 27838000 3071936
03:13:08 122356 8192000000 10106457680 10550444032 1148191056 12.293 99 37 75 1 1205901808 49483664 8227088
03:16:14 111910 8192000000 10131045680 10567069696 1121438800 12.041 97 22 41 0 1166806944 41341856 4026288
03:19:12 35960 8192000000 10126382592 10567950336 1116631552 11.995 97 40 79 0 1205348880 81150704 7566624
03:20:50 63802 8192000000 10112859664 10595442688 1099830224 11.836 95 25 50 0 1188221216 82725712 5665280
03:22:55 65166 8192000000 10091208048 10579087360 1120775904 12.034 99 14 28 1 1207006848 83302496 2928448
03:25:29 85508 8192000000 10050195440 10531557376 1123389248 12.059 100 12 24 1 1164593744 38740704 2463792
03:27:58 61293 8192000000 10046011856 10514759680 1039569792 11.261 93 17 34 0 1087660896 44715296 3375808
03:30:08 87672 8192000000 10019391296 10494033920 1040586800 11.270 94 17 32 1 1109676624 66000720 3089104
03:32:36 71149 8192000000 10066947216 10502750208 1051003904 11.370 95 10 19 0 1130786560 78016256 1766400
03:34:49 47915 8192000000 10070539888 10502094848 1047625344 11.338 95 25 49 0 1123599184 71063232 4910608
03:36:45 60152 8192000000 10004352880 10419118080 1032884704 11.196 94 30 56 2 1064644288 25892976 5866608
03:38:54 48010 8192000000 10038584384 10487472128 1079439184 11.642 98 16 32 0 1121463728 39141888 2882656
03:40:45 108354 8192000000 10032666528 10484473856 1093727712 11.778 99 22 40 0 1131211408 33074224 4409472
03:43:37 22294 8192000000 10034286352 10474192896 1107409440 11.908 100 37 74 1 1146210176 30893072 7907664
03:45:03 48511 8192000000 10041790544 10500452352 1101752304 11.854 99 8 16 0 1145583376 42250816 1580256
03:46:52 79542 8192000000 10055609664 10492088320 1103664448 11.872 99 20 40 0 1133806640 25900768 4241424
03:49:13 49380 8192000000 10094776128 10551508992 1104611616 11.881 98 9 18 0 1189128960 82729744 1787600
03:51:04 49566 8192000000 10068703152 10561376256 1107511264 11.909 99 9 18 0 1160157136 50843600 1802272
03:53:06 43664 8192000000 10079876400 10540470272 1119823264 12.025 100 32 64 0 1160206064 34649952 5732848
03:54:54 32947 8192000000 10098184880 10546245632 1118402864 12.012 99 31 62 0 1176058800 51604304 6051632
03:56:55 108682 8192000000 10100184896 10567757824 1129027296 12.112 99 14 28 0 1182480896 50216000 3237600
03:59:43 16597 8192000000 10099402512 10541371392 1141141440 12.226 100 42 84 0 1197545184 48653344 7750400
04:01:02 55104 8192000000 10116734064 10555977728 1153397840 12.341 100 28 55 0 1212473216 53591248 5484128
04:03:42 85355 8192000000 10068812160 10533068800 1124422240 12.069 98 19 38 0 1199333936 71161232 3750464
04:06:26 23929 8192000000 10100711616 10534838272 1126249200 12.086 99 53 106 1 1220337712 84304064 9784448

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 03-04-2024 04:10:04 to 03-04-2024 04:10:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 84 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 03-04-2024 04:10:19 to 03-04-2024 04:10:21.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          165282
MON$OLDEST_ACTIVE               166463
MON$OLDEST_SNAPSHOT             166463
MON$NEXT_TRANSACTION            166463
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-30 07:30:08.6030 GMT
MON$PAGES                       1934944
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             675
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3083 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3083 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Wed Apr  3 04:10:22 2024 
 
Database header page information: 
    Flags            0 
    Generation        86888 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    165282 
    Oldest active        166463 
    Oldest snapshot        166463 
    Next transaction    166464 
    Sequence number        0 
    Next attachment ID    675 
    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 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    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: 1504333, 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: 1504335, 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: 1504334, 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: 1504332, 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: 1504331, 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: 532, Index root page: 533 
    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: 1504264, 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: 1504266, 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: 1504265, 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: 1504263, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.57, total records: 7638401 
    Average version length: 48.16, total versions: 61807, 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: 88072 
    Data pages: 88072, average fill: 69% 
    Primary pages: 88071, secondary pages: 1, swept pages: 43702 
    Empty pages: 9, full pages: 64402 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 161 
    40 - 59% = 1918 
    60 - 79% = 85932 
    80 - 99% = 29 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23022, nodes: 7638401 
    Average node length: 18.83, total dup: 0, max dup: 0 
    Average key length: 15.84, compression ratio: 1.70 
    Average prefix length: 14.16, average data length: 12.84 
    Clustering factor: 1632329, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 324 
        20 - 39% = 2064 
        40 - 59% = 3816 
        60 - 79% = 2592 
        80 - 99% = 14226 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13392, nodes: 7638401 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1456744, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1705 
        40 - 59% = 1878 
        60 - 79% = 1207 
        80 - 99% = 8602 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8239, nodes: 7638401 
    Average node length: 6.58, total dup: 5755289, max dup: 49 
    Average key length: 3.60, compression ratio: 2.50 
    Average prefix length: 7.65, average data length: 1.35 
    Clustering factor: 1449824, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 1082 
        40 - 59% = 1227 
        60 - 79% = 1024 
        80 - 99% = 4779 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.73, total records: 2172290 
    Average version length: 58.82, total versions: 30233, max versions: 2 
    Average fragment length: 4.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28656 
    Data pages: 28656, average fill: 70% 
    Primary pages: 28653, secondary pages: 3, swept pages: 13363 
    Empty pages: 4, full pages: 17133 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 279 
    40 - 59% = 2634 
    60 - 79% = 25648 
    80 - 99% = 66 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4451, nodes: 2172290 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 655563, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 911 
        40 - 59% = 815 
        60 - 79% = 790 
        80 - 99% = 1935 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2410, nodes: 2173295 
    Average node length: 4.97, total dup: 2172396, max dup: 18656 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1235031, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 258 
        40 - 59% = 1429 
        60 - 79% = 530 
        80 - 99% = 192 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1794, nodes: 2172290 
    Average node length: 4.97, total dup: 2172240, max dup: 130009 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1046954, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 172 
        40 - 59% = 514 
        60 - 79% = 34 
        80 - 99% = 1074 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4276, nodes: 2172290 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 655563, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 615 
        40 - 59% = 623 
        60 - 79% = 878 
        80 - 99% = 2061 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    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: 1504337, 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: 1504338, 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: 1504336, 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: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, 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.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, 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: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.31, total records: 400 
    Average version length: 24.41, total versions: 2343, max versions: 6 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 53% 
    Primary pages: 9, secondary pages: 23, swept pages: 0 
    Empty pages: 6, full pages: 14 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 16 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, 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: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 21.86, total records: 67980 
    Average version length: 68.27, total versions: 53244, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.03 
    Pointer pages: 7, data page slots: 3592 
    Data pages: 1424, average fill: 63% 
    Primary pages: 1423, secondary pages: 1, swept pages: 1 
    Empty pages: 179, full pages: 796 
    Fill distribution: 
     0 - 19% = 241 
    20 - 39% = 134 
    40 - 59% = 149 
    60 - 79% = 229 
    80 - 99% = 671 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1697671, depth: 3, leaf buckets: 279, nodes: 67980 
    Average node length: 13.17, total dup: 3502, max dup: 1 
    Average key length: 10.90, compression ratio: 2.48 
    Average prefix length: 19.04, average data length: 7.96 
    Clustering factor: 53348, ratio: 0.78 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 171 
        40 - 59% = 82 
        60 - 79% = 20 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 167, max versions: 8 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 27% 
    Primary pages: 1, secondary pages: 2, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, 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: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 13.48, total records: 925 
    Average version length: 42.94, total versions: 810, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.30 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 31% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 14, full pages: 7 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 6 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93280, depth: 2, leaf buckets: 2, nodes: 925 
    Average node length: 4.37, total dup: 829, max dup: 108 
    Average key length: 3.10, compression ratio: 6.14 
    Average prefix length: 18.01, average data length: 0.99 
    Clustering factor: 542, ratio: 0.59 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.46, total records: 68 
    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: 48% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 68 
    Average node length: 11.71, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.29, average data length: 7.71 
    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: 548, Index root page: 549 
    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: 1504251, 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: 1504249, 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: 1504248, 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: 1504250, 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: 1504247, 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: 550, Index root page: 551 
    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: 1504246, 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: 1504244, 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: 1504243, 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: 1504245, 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: 1504242, 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: 496, Index root page: 497 
    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: 1544827, 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: 1544826, 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: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.67, total records: 859021 
    Average version length: 37.90, total versions: 24621, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 9088 
    Data pages: 9088, average fill: 65% 
    Primary pages: 9087, secondary pages: 1, swept pages: 3165 
    Empty pages: 18, full pages: 5362 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 37 
    40 - 59% = 788 
    60 - 79% = 8178 
    80 - 99% = 58 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 914, nodes: 847769 
    Average node length: 4.89, total dup: 847720, max dup: 166456 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 93109, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 120 
        40 - 59% = 492 
        60 - 79% = 204 
        80 - 99% = 98 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1107, nodes: 847769 
    Average node length: 5.89, total dup: 755396, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.10, average data length: 0.90 
    Clustering factor: 167778, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 35 
        40 - 59% = 832 
        60 - 79% = 71 
        80 - 99% = 167 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1123, nodes: 847769 
    Average node length: 5.89, total dup: 755396, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 169635, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 74 
        40 - 59% = 817 
        60 - 79% = 63 
        80 - 99% = 168 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1176, nodes: 847769 
    Average node length: 5.97, total dup: 755396, max dup: 42 
    Average key length: 3.09, compression ratio: 5.50 
    Average prefix length: 16.02, average data length: 0.98 
    Clustering factor: 161640, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 210 
        40 - 59% = 639 
        60 - 79% = 229 
        80 - 99% = 95 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.73, total records: 5401 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.42, total fragments: 24, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 57% 
    Primary pages: 81, secondary pages: 13, swept pages: 60 
    Empty pages: 14, full pages: 62 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5401 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.31, average data length: 1.55 
    Clustering factor: 5088, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5401 
    Average node length: 11.14, 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: 170, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 75346 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 784 
    Data pages: 784, average fill: 66% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 782 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 783 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36207, depth: 2, leaf buckets: 97, nodes: 75346 
    Average node length: 10.19, total dup: 0, max dup: 0 
    Average key length: 8.20, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 2838, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 94 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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: 1504261, 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: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.07, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 145.85, total records: 159399 
    Average version length: 152.72, total versions: 5695, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 7, data page slots: 4816 
    Data pages: 3968, average fill: 83% 
    Primary pages: 3966, secondary pages: 2, swept pages: 3 
    Empty pages: 45, full pages: 3900 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 10 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 3901 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 143.36, total records: 143255 
    Average version length: 152.92, total versions: 7741, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.83 
    Pointer pages: 6, data page slots: 4696 
    Data pages: 3608, average fill: 82% 
    Primary pages: 3607, secondary pages: 1, swept pages: 3 
    Empty pages: 73, full pages: 3502 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 7 
    40 - 59% = 12 
    60 - 79% = 12 
    80 - 99% = 3501 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 141.15, total records: 167190 
    Average version length: 153.55, total versions: 11792, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.02 
    Pointer pages: 8, data page slots: 5840 
    Data pages: 4192, average fill: 83% 
    Primary pages: 4190, secondary pages: 2, swept pages: 1 
    Empty pages: 66, full pages: 4097 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 12 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 4097 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 128.69, total records: 181881 
    Average version length: 154.95, total versions: 28943, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.18 
    Pointer pages: 8, data page slots: 5040 
    Data pages: 4576, average fill: 84% 
    Primary pages: 4575, secondary pages: 1, swept pages: 2 
    Empty pages: 80, full pages: 4471 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4470 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 145.19, total records: 153535 
    Average version length: 152.55, total versions: 6166, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 6, data page slots: 5040 
    Data pages: 3856, average fill: 82% 
    Primary pages: 3854, secondary pages: 2, swept pages: 1 
    Empty pages: 80, full pages: 3755 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 3754 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 141.47, total records: 175155 
    Average version length: 153.89, total versions: 12238, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.99 
    Pointer pages: 7, data page slots: 5848 
    Data pages: 4416, average fill: 83% 
    Primary pages: 4414, secondary pages: 2, swept pages: 5 
    Empty pages: 87, full pages: 4297 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 14 
    40 - 59% = 9 
    60 - 79% = 8 
    80 - 99% = 4297 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 140.49, total records: 151668 
    Average version length: 153.44, total versions: 10874, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.07 
    Pointer pages: 9, data page slots: 4800 
    Data pages: 3848, average fill: 82% 
    Primary pages: 3846, secondary pages: 2, swept pages: 2 
    Empty pages: 93, full pages: 3682 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 7 
    40 - 59% = 56 
    60 - 79% = 6 
    80 - 99% = 3683 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 142.94, total records: 152400 
    Average version length: 153.22, total versions: 8784, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.86 
    Pointer pages: 8, data page slots: 4664 
    Data pages: 3824, average fill: 83% 
    Primary pages: 3823, secondary pages: 1, swept pages: 4 
    Empty pages: 62, full pages: 3730 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 11 
    40 - 59% = 7 
    60 - 79% = 11 
    80 - 99% = 3730 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 143.06, total records: 170393 
    Average version length: 153.50, total versions: 9866, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 9, data page slots: 5080 
    Data pages: 4256, average fill: 83% 
    Primary pages: 4254, secondary pages: 2, swept pages: 5 
    Empty pages: 54, full pages: 4174 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 17 
    80 - 99% = 4173 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 140.71, total records: 165395 
    Average version length: 154.06, total versions: 12175, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.05 
    Pointer pages: 7, data page slots: 5544 
    Data pages: 4136, average fill: 83% 
    Primary pages: 4134, secondary pages: 2, swept pages: 3 
    Empty pages: 56, full pages: 4059 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 4059 
 
PHRASES (143) 
    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 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, 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: 1510375, 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: 1510374, 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: 1510373, 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: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.09, total records: 2029484 
    Average version length: 52.92, total versions: 30171, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25424 
    Data pages: 25424, average fill: 69% 
    Primary pages: 25409, secondary pages: 15, swept pages: 12363 
    Empty pages: 233, full pages: 20581 
    Fill distribution: 
     0 - 19% = 499 
    20 - 39% = 444 
    40 - 59% = 1270 
    60 - 79% = 22933 
    80 - 99% = 278 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2524, nodes: 2029484 
    Average node length: 5.45, total dup: 1891992, max dup: 1275 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 177402, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 344 
        40 - 59% = 1611 
        60 - 79% = 268 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2747, nodes: 2029484 
    Average node length: 5.70, total dup: 1820810, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 364506, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 11 
        40 - 59% = 2568 
        60 - 79% = 145 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2075, nodes: 2029484 
    Average node length: 4.96, total dup: 2029384, max dup: 27354 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 175576, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 220 
        40 - 59% = 1069 
        60 - 79% = 377 
        80 - 99% = 405 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    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: 1504339, 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: 498, Index root page: 499 
    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: 1544825, 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: 1544824, 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: 528, Index root page: 529 
    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: 1504327, 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: 1504328, 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: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, 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: 1 
    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: 1544931, 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: 1544828, 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: 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 TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, 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: 488, Index root page: 489 
    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: 1544829, 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: 490, Index root page: 491 
    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: 492, Index root page: 493 
    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: 546, Index root page: 547 
    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: 544, Index root page: 545 
    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: 1504252, 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: 486, Index root page: 487 
    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: 484, Index root page: 485 
    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: 1544831, 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: 1544830, 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: 480, Index root page: 481 
    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: 1544833, 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: 557, Index root page: 558 
    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: 1504237, 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: 538, Index root page: 539 
    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: 508, Index root page: 509 
    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: 1552183, 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: 1510377, 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: 1510382, 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: 1510380, 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: 526, Index root page: 527 
    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: 1504329, 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: 1504330, 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: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 45.89, total records: 143962 
    Average version length: 69.18, total versions: 55764, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.75 
    Pointer pages: 3, data page slots: 4192 
    Data pages: 3448, average fill: 50% 
    Primary pages: 3448, secondary pages: 0, swept pages: 550 
    Empty pages: 670, full pages: 1295 
    Fill distribution: 
     0 - 19% = 879 
    20 - 39% = 269 
    40 - 59% = 603 
    60 - 79% = 988 
    80 - 99% = 709 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106279, depth: 3, leaf buckets: 239, nodes: 143962 
    Average node length: 6.51, total dup: 125335, max dup: 14 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 25070, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 54 
        40 - 59% = 144 
        60 - 79% = 37 
        80 - 99% = 4 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 66.54, total records: 7337903 
    Average version length: 68.75, total versions: 295537, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 69, data page slots: 112376 
    Data pages: 112376, average fill: 70% 
    Primary pages: 112375, secondary pages: 1, swept pages: 43655 
    Empty pages: 5, full pages: 52850 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 515 
    40 - 59% = 9704 
    60 - 79% = 101215 
    80 - 99% = 897 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10982, nodes: 7337903 
    Average node length: 6.51, total dup: 6349032, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1690472, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1448 
        40 - 59% = 6079 
        60 - 79% = 2982 
        80 - 99% = 467 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8927, nodes: 7337903 
    Average node length: 5.39, total dup: 7052157, max dup: 128 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1488808, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1154 
        40 - 59% = 5220 
        60 - 79% = 1647 
        80 - 99% = 898 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8957, nodes: 7337903 
    Average node length: 5.39, total dup: 7052157, max dup: 128 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1491334, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1221 
        40 - 59% = 5136 
        60 - 79% = 1675 
        80 - 99% = 919 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.81, total records: 12335873 
    Average version length: 68.67, total versions: 231577, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 111, data page slots: 179656 
    Data pages: 179656, average fill: 73% 
    Primary pages: 179654, secondary pages: 2, swept pages: 85855 
    Empty pages: 4, full pages: 145815 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 479 
    40 - 59% = 5944 
    60 - 79% = 171671 
    80 - 99% = 1517 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18559, nodes: 12333772 
    Average node length: 6.64, total dup: 10750795, max dup: 73 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2488009, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 18 
        20 - 39% = 2073 
        40 - 59% = 10508 
        60 - 79% = 5002 
        80 - 99% = 958 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 50.35, total records: 1495224 
    Average version length: 69.06, total versions: 285282, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.50 
    Pointer pages: 30, data page slots: 47144 
    Data pages: 30312, average fill: 51% 
    Primary pages: 30237, secondary pages: 75, swept pages: 11134 
    Empty pages: 4522, full pages: 16340 
    Fill distribution: 
     0 - 19% = 6726 
    20 - 39% = 4095 
    40 - 59% = 3006 
    60 - 79% = 12836 
    80 - 99% = 3649 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1951, nodes: 1313262 
    Average node length: 5.53, total dup: 1260494, max dup: 49 
    Average key length: 2.57, compression ratio: 16.35 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 90959, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 669 
        40 - 59% = 942 
        60 - 79% = 301 
        80 - 99% = 24 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 45.79, total records: 935503 
    Average version length: 69.03, total versions: 106459, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.75 
    Pointer pages: 23, data page slots: 37200 
    Data pages: 29840, average fill: 30% 
    Primary pages: 29840, secondary pages: 0, swept pages: 10739 
    Empty pages: 7452, full pages: 4425 
    Fill distribution: 
     0 - 19% = 11712 
    20 - 39% = 6611 
    40 - 59% = 7867 
    60 - 79% = 3613 
    80 - 99% = 37 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1159, nodes: 680015 
    Average node length: 5.95, total dup: 626458, max dup: 54 
    Average key length: 3.02, compression ratio: 13.89 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 98063, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 530 
        40 - 59% = 497 
        60 - 79% = 119 
        80 - 99% = 13 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.15, total records: 8645011 
    Average version length: 69.00, total versions: 250324, 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: 91, data page slots: 147096 
    Data pages: 147080, average fill: 63% 
    Primary pages: 147057, secondary pages: 23, swept pages: 82161 
    Empty pages: 738, full pages: 59040 
    Fill distribution: 
     0 - 19% = 2725 
    20 - 39% = 13458 
    40 - 59% = 28865 
    60 - 79% = 100377 
    80 - 99% = 1655 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13403, nodes: 8643441 
    Average node length: 6.70, total dup: 7168848, max dup: 14 
    Average key length: 3.67, compression ratio: 11.43 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1876597, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1910 
        40 - 59% = 7343 
        60 - 79% = 3729 
        80 - 99% = 420 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21090739 
    Average version length: 82.93, total versions: 4699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318928 
    Data pages: 318928, average fill: 81% 
    Primary pages: 318924, secondary pages: 4, swept pages: 12631 
    Empty pages: 42, full pages: 317943 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 72 
    40 - 59% = 138 
    60 - 79% = 47862 
    80 - 99% = 270784 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19551, nodes: 21090739 
    Average node length: 5.72, total dup: 20610907, max dup: 151 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3273570, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8569 
        60 - 79% = 546 
        80 - 99% = 10430 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17089, nodes: 21090739 
    Average node length: 6.31, total dup: 18534545, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913290, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 4 
        40 - 59% = 702 
        60 - 79% = 267 
        80 - 99% = 16112 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21327, nodes: 21090739 
    Average node length: 6.35, total dup: 18453455, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3566929, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8860 
        60 - 79% = 570 
        80 - 99% = 11892 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15966, nodes: 21090739 
    Average node length: 5.56, total dup: 21090639, max dup: 229235 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942075, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2721 
        60 - 79% = 349 
        80 - 99% = 12888 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.54, total records: 8947825 
    Average version length: 82.57, total versions: 104349, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 107, data page slots: 173824 
    Data pages: 173760, average fill: 64% 
    Primary pages: 173718, secondary pages: 42, swept pages: 124645 
    Empty pages: 1271, full pages: 70848 
    Fill distribution: 
     0 - 19% = 4237 
    20 - 39% = 16150 
    40 - 59% = 36299 
    60 - 79% = 103464 
    80 - 99% = 13610 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11314, nodes: 8947825 
    Average node length: 5.38, total dup: 8648441, max dup: 148 
    Average key length: 2.24, compression ratio: 4.01 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 1989456, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 187 
        40 - 59% = 9915 
        60 - 79% = 1191 
        80 - 99% = 16 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 12755, nodes: 8947825 
    Average node length: 6.24, total dup: 7415636, max dup: 14 
    Average key length: 3.11, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1374493, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 3782 
        40 - 59% = 4324 
        60 - 79% = 2552 
        80 - 99% = 2012 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12627, nodes: 8947825 
    Average node length: 6.00, total dup: 7747847, max dup: 29 
    Average key length: 2.86, compression ratio: 3.14 
    Average prefix length: 8.27, average data length: 0.73 
    Clustering factor: 2161815, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 222 
        40 - 59% = 11047 
        60 - 79% = 1343 
        80 - 99% = 13 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9540, nodes: 8947825 
    Average node length: 5.14, total dup: 8947725, max dup: 142386 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1427459, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1429 
        40 - 59% = 4574 
        60 - 79% = 1593 
        80 - 99% = 1899 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.34, total records: 10691959 
    Average version length: 82.52, total versions: 137099, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 117, data page slots: 190184 
    Data pages: 188304, average fill: 70% 
    Primary pages: 188137, secondary pages: 167, swept pages: 82344 
    Empty pages: 3653, full pages: 132039 
    Fill distribution: 
     0 - 19% = 6522 
    20 - 39% = 9941 
    40 - 59% = 20620 
    60 - 79% = 97262 
    80 - 99% = 53959 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13104, nodes: 10691959 
    Average node length: 5.29, total dup: 10583448, max dup: 647 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2239435, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 312 
        40 - 59% = 10472 
        60 - 79% = 2265 
        80 - 99% = 54 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10041, nodes: 10691959 
    Average node length: 5.48, total dup: 10222907, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 689756, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 163 
        20 - 39% = 955 
        40 - 59% = 2451 
        60 - 79% = 1888 
        80 - 99% = 4584 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14981, nodes: 10691959 
    Average node length: 6.02, total dup: 9315398, max dup: 70 
    Average key length: 2.82, compression ratio: 3.20 
    Average prefix length: 8.31, average data length: 0.69 
    Clustering factor: 2255557, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 388 
        40 - 59% = 12083 
        60 - 79% = 2443 
        80 - 99% = 66 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10303, nodes: 10691959 
    Average node length: 5.21, total dup: 10691859, max dup: 180369 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 678975, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 930 
        40 - 59% = 4521 
        60 - 79% = 1513 
        80 - 99% = 3237 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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: 1361775, 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: 1361777, 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: 1361776, 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: 1361774, 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: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 81.08, total records: 9158132 
    Average version length: 83.01, total versions: 204808, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 109, data page slots: 177384 
    Data pages: 177344, average fill: 64% 
    Primary pages: 177310, secondary pages: 34, swept pages: 125150 
    Empty pages: 878, full pages: 72753 
    Fill distribution: 
     0 - 19% = 3451 
    20 - 39% = 16063 
    40 - 59% = 37411 
    60 - 79% = 105696 
    80 - 99% = 14723 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11325, nodes: 9158132 
    Average node length: 5.20, total dup: 9129627, max dup: 1664 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1831793, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1738 
        40 - 59% = 7345 
        60 - 79% = 1670 
        80 - 99% = 539 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13115, nodes: 9158132 
    Average node length: 6.27, total dup: 7591372, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1348187, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 3754 
        40 - 59% = 4539 
        60 - 79% = 2546 
        80 - 99% = 2120 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 11900, nodes: 9158132 
    Average node length: 5.45, total dup: 8742221, max dup: 89 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1956126, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1635 
        40 - 59% = 8230 
        60 - 79% = 1501 
        80 - 99% = 509 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9788, nodes: 9158132 
    Average node length: 5.17, total dup: 9158032, max dup: 145325 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1444863, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1454 
        40 - 59% = 4767 
        60 - 79% = 1612 
        80 - 99% = 1912 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.04, total records: 571015 
    Average version length: 68.78, total versions: 10808, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 75% 
    Primary pages: 8016, secondary pages: 0, swept pages: 2466 
    Empty pages: 7, full pages: 7391 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 33 
    40 - 59% = 200 
    60 - 79% = 7625 
    80 - 99% = 144 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41784, depth: 3, leaf buckets: 730, nodes: 571015 
    Average node length: 5.95, total dup: 486211, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100286, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 523 
        60 - 79% = 88 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32360, depth: 3, leaf buckets: 754, nodes: 571015 
    Average node length: 6.15, total dup: 468332, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100337, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 34 
        40 - 59% = 527 
        60 - 79% = 92 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 566, nodes: 571015 
    Average node length: 4.86, total dup: 570915, max dup: 9363 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89055, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 330 
        60 - 79% = 86 
        80 - 99% = 118 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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: 563, Index root page: 564 
    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: 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 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    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: 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 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    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: 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 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    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: 1504235, 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: 1504236, 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: 571, Index root page: 572 
    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: 1504232, 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: 1504231, 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: 1504234, 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: 1504233, 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: 561, Index root page: 562 
    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: 559, Index root page: 560 
    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: 512, Index root page: 513 
    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: 1510372, 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 Wed Apr  3 04:10:45 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7638401 61807 1 0.0000 0.0000
DOC_LIST 2172290 30233 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2343 6 500.0000 0.0000
INVNT_TURNOVER_LOG 67980 53244 1 0.0000 0.0000
MONEY_SALDO 49 167 8 300.0000 0.0000
MONEY_TURNOVER_LOG 925 810 1 0.0000 0.0000
PDISTR 859021 24621 3 0.0000 0.0000
PERF_SPLIT_0 159399 5695 1 0.0000 0.0000
PERF_SPLIT_1 143255 7741 1 0.0000 0.0000
PERF_SPLIT_2 167190 11792 1 0.0000 0.0000
PERF_SPLIT_3 181881 28943 1 0.0000 0.0000
PERF_SPLIT_4 153535 6166 1 0.0000 0.0000
PERF_SPLIT_5 175155 12238 1 0.0000 0.0000
PERF_SPLIT_6 151668 10874 1 0.0000 0.0000
PERF_SPLIT_7 152400 8784 1 0.0000 0.0000
PERF_SPLIT_8 170393 9866 1 0.0000 0.0000
PERF_SPLIT_9 165395 12175 1 0.0000 0.0000
PSTORNED 2029484 30171 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 143962 55764 1 0.0000 0.0000
XQD_1000_3300 7337903 295537 1 0.0000 0.0000
XQD_1200_2000 12335873 231577 1 0.0000 0.0000
XQD_2000_3300 1495224 285282 1 0.0000 0.0000
XQD_2100_3300 935503 106459 1 0.0000 0.0000
XQD_3300_3400 8645011 250324 1 0.0000 0.0000
XQS_1000_1200 21090739 4699 1 0.0000 0.0000
XQS_1000_3300 8947825 104349 1 0.0000 0.0000
XQS_1200_2000 10691959 137099 1 0.0000 0.0000
XQS_2100_3300 9158132 204808 1 0.0000 0.0000
XQS_3300_3400 571015 10808 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 ---
:65: 
:66: mscs-test-161.budzdorov.ru    Wed Apr  3 04:07:51 2024
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:68: 
:69: 
:70: mscs-test-161.budzdorov.ru    Wed Apr  3 04:08:09 2024
:71:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:72: 
:73: 
:74: mscs-test-161.budzdorov.ru    Wed Apr  3 04:08:09 2024
:75:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:76: 
:77: 
:78: mscs-test-161.budzdorov.ru    Wed Apr  3 04:08:09 2024
:79:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:80: 
--- end of diff output ---

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

03.04.24 04:10:57. There are 3 logs in /var/tmp/logs-oltp40 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-03 04:11:00 No severe PSQL-related problems occured
03.04.24 04:11:01. End of report.