Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.03.2024 10: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 15680928 kB
MemAvailable 30308916 kB
Buffers 0 kB
Cached 16075488 kB
SwapCached 2604 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-03-24 10:07:50
DTS_END                         2024-03-24 10:07:50.5080
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/38644
TRN_ID                          180728
ATT_ID                          595
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: 9373.27 17424 937327
customer order: creation 191.63 373 19163
customer order: refuse 16.09 361 1609
order to supplier: creation 51.01 1224 5101
order to supplier: removal 3.60 87798 360
invoice (draft): creation 51.35 3097 5135
invoice (draft): removal 46.96 711 4696
invoice accept: apply 46.40 19442 4640
invoice accept: cancel 42.55 903 4255
customer reserve: creation 4434.87 187 443487
customer reserve: removal 4178.30 61 417830
realization accept: apply 93.63 190 9363
realization accept: cancel 74.73 126 7473
payment from customer: creation 65.76 106 6576
payment from customer: removal 6.04 74 604
payment to supplier: creation 54.81 117 5481
payment to supplier: removal 3.91 82 391
service: total inventory turnovers 4.22 3559 422
service: total monetary turnovers 6.55 617 655
service: aggregate perf. data 0.82 17467 82
service: refresh index statistics 0.04 211978 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 24-03-2024 10:10:07 to 24-03-2024 10:10:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1069
TEST_TIME 2 1742
TEST_TIME 3 2862
TEST_TIME 4 4086
TEST_TIME 5 4277
TEST_TIME 6 5129
TEST_TIME 7 5292
TEST_TIME 8 5286
TEST_TIME 9 5477
TEST_TIME 10 5811
TEST_TIME 11 5771
TEST_TIME 12 5907
TEST_TIME 13 6432
TEST_TIME 14 6691
TEST_TIME 15 6666
TEST_TIME 16 6799
TEST_TIME 17 7355
TEST_TIME 18 7353
TEST_TIME 19 7538
TEST_TIME 20 7923
TEST_TIME 21 8104
TEST_TIME 22 8348
TEST_TIME 23 8723
TEST_TIME 24 9721
TEST_TIME 25 9999
TEST_TIME 26 9921
TEST_TIME 27 9752
TEST_TIME 28 9618
TEST_TIME 29 9723
TEST_TIME 30 9732
TEST_TIME 31 9548
TEST_TIME 32 9271
TEST_TIME 33 9421
TEST_TIME 34 9287
TEST_TIME 35 9338
TEST_TIME 36 9355
TEST_TIME 37 9334
TEST_TIME 38 9244
TEST_TIME 39 9369
TEST_TIME 40 9277
TEST_TIME 41 9199
TEST_TIME 42 9174
TEST_TIME 43 9169
TEST_TIME 44 9155
TEST_TIME 45 9181
TEST_TIME 46 9243
TEST_TIME 47 9298
TEST_TIME 48 9267
TEST_TIME 49 9389
TEST_TIME 50 9389
TEST_TIME 51 9383
TEST_TIME 52 9467
TEST_TIME 53 9555
TEST_TIME 54 9492
TEST_TIME 55 9637
TEST_TIME 56 9634
TEST_TIME 57 9634
TEST_TIME 58 9475
TEST_TIME 59 9437
TEST_TIME 60 9364
TEST_TIME 61 9340
TEST_TIME 62 9377
TEST_TIME 63 9303
TEST_TIME 64 9261
TEST_TIME 65 9292
TEST_TIME 66 9384
TEST_TIME 67 9318
TEST_TIME 68 9385
TEST_TIME 69 9369
TEST_TIME 70 9398
TEST_TIME 71 9486
TEST_TIME 72 9483
TEST_TIME 73 9512
TEST_TIME 74 9543
TEST_TIME 75 9596
TEST_TIME 76 9643
TEST_TIME 77 9640
TEST_TIME 78 9533
TEST_TIME 79 9531
TEST_TIME 80 9494
TEST_TIME 81 9486
TEST_TIME 82 9405
TEST_TIME 83 9396
TEST_TIME 84 9389
TEST_TIME 85 9361
TEST_TIME 86 9362
TEST_TIME 87 9399
TEST_TIME 88 9372
TEST_TIME 89 9383
TEST_TIME 90 9412
TEST_TIME 91 9475
TEST_TIME 92 9485
TEST_TIME 93 9549
TEST_TIME 94 9558
TEST_TIME 95 9555
TEST_TIME 96 9492
TEST_TIME 97 9472
TEST_TIME 98 9414
TEST_TIME 99 9391
TEST_TIME 100 9373

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-03-2024 10:10:11 to 24-03-2024 10:10:14.

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 1343568 1343568 0 0.00 0 20288 7 0 0
doc_list_biud 1343558 1343558 0 0.00 0 29849 24 0 0
sp_add_invoice_to_stock 4739 4640 99 2.08 35 164859 19442 0 99
sp_cancel_adding_invoice 4255 4255 0 0.00 5 58845 903 0 0
sp_cancel_client_order 1609 1609 0 0.00 4 23640 361 0 0
sp_cancel_customer_reserve 417830 417830 0 0.00 0 29556 62 0 0
sp_cancel_pay_from_customer 604 604 0 0.00 3 3289 75 0 0
sp_cancel_pay_to_supplier 391 391 0 0.00 2 5426 83 0 0
sp_cancel_supplier_invoice 4704 4696 8 0.17 1 13367 712 0 8
sp_cancel_supplier_order 360 360 0 0.00 5 1023615 87798 0 0
sp_cancel_write_off 7473 7473 0 0.00 1 7227 127 0 0
sp_client_order 19163 19163 0 0.00 3 16965 373 0 0
sp_customer_reserve 443487 443487 0 0.00 0 49126 187 0 0
sp_fill_shopping_cart 29363 29363 0 0.00 1 12273 36 0 0
sp_fill_shopping_cart_clo_res 443486 443486 0 0.00 0 22637 16 0 0
sp_get_clo_for_invoice 4639 4639 0 0.00 0 33830 403 0 0
sp_kill_cost_storno 12723 12723 0 0.00 0 8415 62 0 0
sp_kill_qstorno_ret_qs2qd 848189 848189 0 0.00 0 29550 33 0 0
sp_kill_qty_storno 450219 450219 0 0.00 0 29849 71 0 0
sp_lock_selected_doc 19208 19208 0 0.00 0 10758 6 0 0
sp_make_cost_storno 26059 26059 0 0.00 0 16850 63 0 0
sp_multiply_rows_for_pdistr 26049 26049 0 0.00 0 8292 28 0 0
sp_multiply_rows_for_qdistr 19163 19163 0 0.00 0 12830 199 0 0
sp_pay_from_customer 6576 6576 0 0.00 3 14217 107 0 0
sp_pay_to_supplier 5481 5481 0 0.00 3 19398 117 0 0
sp_payment_common 12053 12053 0 0.00 1 8070 15 0 0
sp_qd_handle_on_cancel_clo 1609 1609 0 0.00 0 23632 340 0 0
sp_qd_handle_on_invoice_upd_sts 8891 8891 0 0.00 0 29849 303 0 0
sp_qd_handle_on_reserve_upd_sts 9360 9360 0 0.00 0 25598 64 0 0
sp_reserve_write_off 9363 9363 0 0.00 6 27443 190 0 0
sp_supplier_invoice 5135 5135 0 0.00 5 92548 3098 0 0
sp_supplier_order 5101 5101 0 0.00 4 49286 1225 0 0
srv_aggregate_perf_data 82 82 0 0.00 1884 224192 17468 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 953 125439 40017 0 0
srv_find_qd_qs_mism 890379 890379 0 0.00 0 15746 7 0 0
srv_make_invnt_saldo 422 422 0 0.00 35 94206 3560 0 0
srv_make_money_saldo 655 655 0 0.00 0 13761 617 0 0
srv_recalc_idx_stat 4 4 0 0.00 166885 292331 211978 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4640 4640 0 0.00 0 7802 159 0 0
t$perf-norm:sp_cancel_adding_invoice 360 360 0 0.00 0 7741 112 0 0
t$perf-norm:sp_cancel_client_order 1609 1609 0 0.00 0 4140 15 0 0
t$perf-norm:sp_cancel_customer_reserve 592 592 0 0.00 0 823 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 604 604 0 0.00 0 1119 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 391 391 0 0.00 0 1082 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 357 357 0 0.00 0 3577 17 0 0
t$perf-norm:sp_cancel_supplier_order 360 360 0 0.00 0 34933 1425 0 0
t$perf-norm:sp_cancel_write_off 939 939 0 0.00 0 3995 9 0 0
t$perf-norm:sp_client_order 19163 19163 0 0.00 0 11026 15 0 0
t$perf-norm:sp_customer_reserve 939 939 0 0.00 0 2231 7 0 0
t$perf-norm:sp_pay_from_customer 6576 6576 0 0.00 0 3351 7 0 0
t$perf-norm:sp_pay_to_supplier 5481 5481 0 0.00 0 4873 11 0 0
t$perf-norm:sp_reserve_write_off 9363 9363 0 0.00 0 6649 13 0 0
t$perf-norm:sp_supplier_invoice 5135 5135 0 0.00 0 6390 20 0 0
t$perf-norm:sp_supplier_order 5101 5101 0 0.00 0 2555 13 0 0
t$perf-norm:srv_aggregate_perf_data 82 82 0 0.00 0 37 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 1937 45 0 0
t$perf-norm:srv_make_invnt_saldo 422 422 0 0.00 0 917 6 0 0
t$perf-norm:srv_make_money_saldo 655 655 0 0.00 0 841 5 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 13 6 0 0
v_add_invoice_to_stock 9470 9272 198 2.09 0 5363 17 0 198
v_all_customers 35414 35414 0 0.00 0 114 1 0 0
v_all_suppliers 28870 28870 0 0.00 0 40 1 0 0
v_all_wares 38326 38326 0 0.00 0 79 1 0 0
v_cancel_adding_invoice 720 720 0 0.00 0 3048 15 0 0
v_cancel_client_order 3218 3218 0 0.00 0 2226 4 0 0
v_cancel_customer_prepayment 1208 1208 0 0.00 0 2115 7 0 0
v_cancel_customer_reserve 1184 1184 0 0.00 0 48 3 0 0
v_cancel_payment_to_supplier 782 782 0 0.00 0 2209 8 0 0
v_cancel_supplier_invoice 730 714 16 2.19 0 3607 20 0 16
v_cancel_supplier_order 720 720 0 0.00 0 247 2 0 0
v_cancel_write_off 1878 1878 0 0.00 0 1553 12 0 0
v_max_id_clo_ord 5095 5095 0 0.00 0 1266 1 0 0
v_max_id_clo_res 939 939 0 0.00 0 3797 10 0 0
v_max_id_ord_sup 5105 5105 0 0.00 0 2757 3 0 0
v_max_non_paid_invoice 1244 1244 0 0.00 0 231 2 0 0
v_max_non_paid_realizn 3282 3282 0 0.00 0 456 2 0 0
v_min_id_clo_ord 5095 5095 0 0.00 0 5339 7 0 0
v_min_id_clo_res 939 939 0 0.00 0 6913 19 0 0
v_min_id_ord_sup 5105 5105 0 0.00 0 7172 9 0 0
v_min_non_paid_invoice 5479 5479 0 0.00 0 7370 9 0 0
v_min_non_paid_realizn 6574 6574 0 0.00 0 8067 12 0 0
v_our_firm 9496 9496 0 0.00 0 35 1 0 0
v_reserve_write_off 18720 18720 0 0.00 0 5344 7 0 0
x_lock_depdocs_on_canc_invoice 8594 8594 0 0.00 0 24804 109 0 0
x_lock_depdocs_on_canc_sup_ord 360 360 0 0.00 0 10429 276 0 0
x_make_qstorno_1000_1200 5101 5101 0 0.00 1 49275 1150 0 0
x_make_qstorno_1200_2000 5135 5135 0 0.00 2 91657 2960 0 0
x_make_qstorno_2100_3300 443487 443487 0 0.00 0 44946 168 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 24-03-2024 10:10:15 to 24-03-2024 10:10:20.

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
08:07:54 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
08:08:55 30623 8192000000 9716318176 10014318592 794664832 8.842 100 88 176 0 823040416 7865280 20510304
08:10:29 12876 8192000000 9752017872 10057240576 830997184 9.209 100 94 188 0 864817008 12656992 21162832
08:11:51 12153 8192000000 9778570624 10096852992 849509472 9.395 100 77 154 0 883758368 17300928 16947968
08:13:13 15230 8192000000 9834066864 10165260288 889801120 9.797 100 75 148 1 943017440 37130352 16085968
08:14:34 6249 8192000000 9885439440 10225647616 923729104 10.133 100 77 150 0 1002312720 63054016 15529600
08:15:44 3858 8192000000 9910750288 10263130112 967474832 10.562 100 72 144 1 1020783552 39014720 14294000
08:16:50 3684 8192000000 9971819088 10334498816 998412128 10.863 100 67 131 1 1086271840 75277152 12582560
08:17:54 3279 8192000000 9988315920 10356699136 1027104192 11.141 100 77 153 0 1101173376 59094768 14974416
08:19:00 1122 8192000000 9993620928 10367037440 1039714368 11.262 100 84 166 1 1113137056 57151008 16271680
08:20:05 16202 8192000000 10027694144 10399342592 1049302256 11.354 100 80 159 0 1140666064 76328032 15035776
08:21:22 3580 8192000000 10009199072 10398748672 1057489408 11.432 100 55 108 0 1122511392 54524912 10497072
08:22:28 3675 8192000000 9986744992 10375245824 1060711056 11.463 100 48 94 2 1104038896 33554192 9773648
08:23:34 12301 8192000000 9979103920 10369957888 1063919632 11.494 100 53 106 0 1089123232 13821280 11382320
08:24:48 5310 8192000000 9996727104 10395037696 1072362224 11.575 100 41 81 1 1101831920 21025120 8444576
08:25:55 4683 8192000000 9998116352 10398314496 1079304576 11.641 100 37 74 0 1110802256 24460960 7036720
08:27:01 5635 8192000000 10008698592 10400112640 1071205600 11.564 99 53 105 0 1110816176 29499136 10111440
08:28:07 80199 8192000000 10022753808 10426798080 1078918016 11.637 99 40 80 1 1109536320 23109328 7508976
08:30:32 16379 8192000000 10074680752 10479525888 1093023440 11.771 99 53 106 0 1182370560 78617216 10729904
08:31:50 19715 8192000000 10084526864 10487828480 1094329200 11.784 99 47 94 0 1192405056 88183808 9892048
08:33:17 14029 8192000000 10136500688 10565234688 1115402608 11.984 100 42 84 1 1237966448 114142464 8421376
08:34:39 27920 8192000000 10102951600 10511978496 1116680688 11.996 99 32 65 0 1209178304 85670048 6827568
08:36:09 33478 8192000000 10137084688 10552115200 1110803616 11.940 99 36 70 0 1247238384 128775584 7659184
08:37:56 4873 8192000000 10111200768 10509131776 1084620032 11.691 97 44 85 0 1193287968 99983872 8684064
08:39:04 10988 8192000000 10155133680 10558603264 1099138496 11.829 99 44 88 0 1252121168 143160160 9822512
08:40:20 6919 8192000000 10167417888 10557906944 1085596000 11.701 99 66 132 1 1265258224 166083584 13578640
08:41:36 1694 8192000000 10172009184 10546065408 1078753312 11.636 99 79 152 1 1265111744 170167872 16190560
08:42:43 2571 8192000000 10209161456 10604056576 1099762192 11.835 100 59 114 2 1316469648 204497904 12209552
08:43:51 1951 8192000000 10277523344 10674798592 1112097776 11.952 100 83 162 1 1378866384 248572768 18195840
08:45:01 2601 8192000000 10272316240 10666954752 1110667456 11.939 100 76 146 2 1378838144 252642064 15528624
08:46:06 13224 8192000000 10306886688 10707353600 1115852224 11.988 100 58 112 0 1409063040 280624496 12586320
08:47:29 951 8192000000 10324277872 10717491200 1122680592 12.052 100 92 184 1 1422648512 279664304 20303616
08:48:35 8073 8192000000 10296657376 10748133376 1136163104 12.179 100 50 100 0 1427276336 279929136 11184096
08:49:52 15606 8192000000 10300893744 10754646016 1119593488 12.023 100 33 66 0 1410097056 282400272 8103296
08:51:30 37201 8192000000 10106004432 10619252736 1111105792 11.943 100 15 30 0 1219317680 105118768 3093120
08:53:56 26750 8192000000 10041470384 10462277632 1093366080 11.775 98 30 61 0 1119728880 19130624 7232176
08:55:26 18745 8192000000 10057044528 10477989888 1117204080 12.001 100 31 63 0 1167645328 43703840 6737408
08:56:51 43169 8192000000 10067877632 10526887936 1126311904 12.087 100 14 28 0 1161291200 32160480 2818816
08:58:36 98477 8192000000 10107232208 10566565888 1133589360 12.155 100 30 58 1 1206185344 66326672 6269312
09:01:25 27158 8192000000 10052407088 10508820480 1135081312 12.169 100 33 66 0 1168871664 26943872 6846480
09:02:53 24228 8192000000 10095181584 10519289856 1138853456 12.205 100 39 78 0 1180063296 33191200 8018640
09:04:18 37288 8192000000 10094866560 10560065536 1142397392 12.238 100 14 27 0 1204771872 59795360 2579120
09:06:04 24242 8192000000 10085258624 10567151616 1128771840 12.110 99 20 39 0 1184606416 52044272 3790304
09:07:31 25159 8192000000 10106845856 10561818624 1131992000 12.140 99 8 16 0 1200752656 67179808 1580848
09:08:57 21599 8192000000 10109850560 10582548480 1141265184 12.227 100 28 57 0 1194579376 47931744 5382448
09:10:37 62658 8192000000 10063417168 10524164096 1114546848 11.975 98 9 18 0 1152672928 36834496 1291584
09:12:45 63702 8192000000 10079630976 10527727616 1118127856 12.009 98 13 26 0 1159022944 38452864 2442224
09:14:49 18459 8192000000 10069054176 10496458752 1113825744 11.969 98 52 105 1 1139958576 15535040 10597792
09:16:09 7130 8192000000 10099753232 10518294528 1112094720 11.952 99 74 148 1 1185573824 58845344 14633760
09:17:21 27911 8192000000 10040244160 10473189376 1076070848 11.610 97 36 72 0 1107139648 24233984 6834816
09:18:51 49389 8192000000 10035270448 10484846592 1053405840 11.393 96 20 39 0 1101822320 44701024 3715456
09:20:41 34177 8192000000 10034586224 10449813504 1101435680 11.851 100 23 45 0 1136981328 31473216 4072432
09:22:19 98416 8192000000 10051744496 10497122304 992669888 10.807 90 12 24 1 1054525488 59081200 2774400
09:24:57 78605 8192000000 10003170128 10428628992 1049652912 11.357 97 22 42 0 1074032928 20263184 4116832
09:27:21 19013 8192000000 10048805552 10459250688 1076007552 11.609 99 52 103 0 1132293248 46302672 9983024
09:28:41 56808 8192000000 10044301200 10518249472 1066317808 11.517 98 19 38 0 1148698688 78063168 4317712
09:30:38 47085 8192000000 10036617664 10471567360 1083546576 11.681 99 11 22 0 1130322160 44648688 2126896
09:32:27 83822 8192000000 10038258400 10544914432 1092275552 11.764 99 16 31 0 1184378976 88624720 3478704
09:34:52 37759 8192000000 10074017792 10528731136 1106604928 11.900 99 41 82 0 1181110016 65302832 9202256
09:36:34 57251 8192000000 10089344592 10563891200 1126496976 12.088 100 21 42 0 1195410736 64419120 4494640
09:38:40 72698 8192000000 10058970848 10506600448 1112571712 11.957 98 16 32 0 1174130944 58567136 2992096
09:40:58 75141 8192000000 10119741296 10587324416 1109388432 11.927 97 27 54 0 1170769072 56423312 4957328
09:43:14 68027 8192000000 10126897648 10568888320 1143424000 12.248 100 21 42 0 1187750528 40077648 4248880
09:45:27 125439 8192000000 10089736416 10542428160 1135608672 12.174 99 29 58 0 1183934976 42545616 5780688
09:48:33 61423 8192000000 10083791184 10543091712 1124106208 12.066 98 17 34 0 1171886176 44534416 3245552
09:50:35 66004 8192000000 10077107664 10552889344 1146645760 12.278 100 17 34 0 1208770768 58521600 3603408
09:52:46 49221 8192000000 10091798496 10535690240 1150105568 12.310 100 13 26 0 1186261248 33409232 2746448
09:54:40 32556 8192000000 10088526944 10552934400 1128430544 12.107 98 19 39 0 1171716720 38988752 4297424
09:56:16 34754 8192000000 10111422240 10543210496 1114013536 11.970 97 36 72 1 1179299680 57416784 7869360
09:57:54 86654 8192000000 10088692992 10586415104 1106723840 11.901 97 15 30 0 1208313776 98614608 2975328
10:00:24 55847 8192000000 10069073104 10545344512 1061490720 11.471 94 15 30 0 1119169456 54767808 2910928
10:02:25 34430 8192000000 10029498128 10454540288 1082475904 11.671 97 32 64 0 1110551344 21435584 6639856
10:04:06 84156 8192000000 10068955248 10521518080 1090319152 11.746 98 38 74 0 1154519552 56633888 7566512
10:06:42 47238 8192000000 10062900736 10537938944 1092117584 11.763 98 10 20 0 1165927584 71614224 2195776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-03-2024 10:10:37 to 24-03-2024 10:10:39.

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          178937
MON$OLDEST_ACTIVE               180855
MON$OLDEST_SNAPSHOT             180855
MON$NEXT_TRANSACTION            180855
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                       1925792
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             710
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3081 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3081 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3081 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3081 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 Sun Mar 24 10:10:40 2024 
 
Database header page information: 
    Flags            0 
    Generation        94941 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    178937 
    Oldest active        180855 
    Oldest snapshot        180855 
    Next transaction    180856 
    Sequence number        0 
    Next attachment ID    710 
    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.76, total records: 7779023 
    Average version length: 48.16, total versions: 26484, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89584 
    Data pages: 89584, average fill: 69% 
    Primary pages: 89583, secondary pages: 1, swept pages: 52049 
    Empty pages: 6, full pages: 62293 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 61 
    40 - 59% = 2024 
    60 - 79% = 87446 
    80 - 99% = 39 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23611, nodes: 7779023 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1687497, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 403 
        20 - 39% = 2000 
        40 - 59% = 4252 
        60 - 79% = 2362 
        80 - 99% = 14594 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13673, nodes: 7779023 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1511509, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1801 
        40 - 59% = 1976 
        60 - 79% = 1122 
        80 - 99% = 8774 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8451, nodes: 7779023 
    Average node length: 6.63, total dup: 5804120, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1504535, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 130 
        20 - 39% = 1065 
        40 - 59% = 1404 
        60 - 79% = 929 
        80 - 99% = 4923 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.18, total records: 2266704 
    Average version length: 58.81, total versions: 13388, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 29216 
    Data pages: 29216, average fill: 71% 
    Primary pages: 29214, secondary pages: 2, swept pages: 16082 
    Empty pages: 1, full pages: 15705 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 34 
    40 - 59% = 729 
    60 - 79% = 28407 
    80 - 99% = 40 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4637, nodes: 2266704 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 688251, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 996 
        40 - 59% = 849 
        60 - 79% = 725 
        80 - 99% = 2067 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2448, nodes: 2267404 
    Average node length: 4.97, total dup: 2266505, max dup: 19324 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1271139, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 214 
        40 - 59% = 1407 
        60 - 79% = 563 
        80 - 99% = 259 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1835, nodes: 2266704 
    Average node length: 4.97, total dup: 2266654, max dup: 130525 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1081866, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 694 
        60 - 79% = 38 
        80 - 99% = 1092 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4455, nodes: 2266704 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 688251, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 666 
        40 - 59% = 631 
        60 - 79% = 790 
        80 - 99% = 2240 
 
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.28, total records: 400 
    Average version length: 23.12, total versions: 399, max versions: 4 
    Average fragment length: 2.00, total fragments: 9, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 29% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 11, full pages: 6 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 6 
 
    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: 18.64, total records: 70248 
    Average version length: 68.27, total versions: 58833, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.72 
    Pointer pages: 6, data page slots: 2560 
    Data pages: 1232, average fill: 75% 
    Primary pages: 1231, secondary pages: 1, swept pages: 6 
    Empty pages: 58, full pages: 883 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 65 
    40 - 59% = 109 
    60 - 79% = 226 
    80 - 99% = 746 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700356, depth: 3, leaf buckets: 208, nodes: 70248 
    Average node length: 13.25, total dup: 3543, max dup: 2 
    Average key length: 10.85, compression ratio: 2.49 
    Average prefix length: 19.10, average data length: 7.90 
    Clustering factor: 53523, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 129 
        60 - 79% = 61 
        80 - 99% = 8 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 9, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 23% 
    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 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: 12.54, total records: 1154 
    Average version length: 43.11, total versions: 1040, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.62 
    Pointer pages: 1, data page slots: 24 
    Data pages: 20, average fill: 61% 
    Primary pages: 19, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 7 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93043, depth: 2, leaf buckets: 3, nodes: 1154 
    Average node length: 4.70, total dup: 1056, max dup: 133 
    Average key length: 2.90, compression ratio: 6.55 
    Average prefix length: 18.18, average data length: 0.82 
    Clustering factor: 656, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        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.42, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.92, total records: 751000 
    Average version length: 37.90, total versions: 17398, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8296 
    Data pages: 8288, average fill: 62% 
    Primary pages: 8285, secondary pages: 3, swept pages: 3923 
    Empty pages: 54, full pages: 3647 
    Fill distribution: 
     0 - 19% = 141 
    20 - 39% = 129 
    40 - 59% = 1366 
    60 - 79% = 6615 
    80 - 99% = 37 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 823, nodes: 744265 
    Average node length: 4.87, total dup: 744216, max dup: 130156 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 86391, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 139 
        40 - 59% = 451 
        60 - 79% = 159 
        80 - 99% = 74 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 924, nodes: 744265 
    Average node length: 5.88, total dup: 662502, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 149922, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 108 
        40 - 59% = 441 
        60 - 79% = 164 
        80 - 99% = 208 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 927, nodes: 744265 
    Average node length: 5.88, total dup: 662502, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 151687, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 155 
        40 - 59% = 392 
        60 - 79% = 153 
        80 - 99% = 227 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1078, nodes: 744265 
    Average node length: 5.97, total dup: 662502, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 144904, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 278 
        40 - 59% = 532 
        60 - 79% = 181 
        80 - 99% = 85 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.91, total records: 5495 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.91, total fragments: 22, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 88 
    Data pages: 86, average fill: 63% 
    Primary pages: 74, secondary pages: 12, swept pages: 64 
    Empty pages: 6, full pages: 69 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5495 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.09 
    Average prefix length: 34.57, average data length: 1.54 
    Clustering factor: 5183, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 2 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5495 
    Average node length: 11.16, 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: 158, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 6 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.11, total records: 82753 
    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: 864 
    Data pages: 864, average fill: 66% 
    Primary pages: 864, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 859 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 859 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36013, depth: 2, leaf buckets: 105, nodes: 82753 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3174, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 103 
 
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.08, 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: 132.63, total records: 172059 
    Average version length: 154.05, total versions: 22365, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.79 
    Pointer pages: 5, data page slots: 4776 
    Data pages: 4280, average fill: 85% 
    Primary pages: 4278, secondary pages: 2, swept pages: 14 
    Empty pages: 37, full pages: 4223 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4223 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 132.17, total records: 173969 
    Average version length: 154.32, total versions: 23475, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.83 
    Pointer pages: 6, data page slots: 5600 
    Data pages: 4368, average fill: 84% 
    Primary pages: 4366, secondary pages: 2, swept pages: 30 
    Empty pages: 71, full pages: 4275 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 4 
    40 - 59% = 10 
    60 - 79% = 4 
    80 - 99% = 4276 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 139.71, total records: 165973 
    Average version length: 152.47, total versions: 13507, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.14 
    Pointer pages: 9, data page slots: 5112 
    Data pages: 4128, average fill: 84% 
    Primary pages: 4125, secondary pages: 3, swept pages: 11 
    Empty pages: 34, full pages: 4075 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4075 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 137.33, total records: 158867 
    Average version length: 153.14, total versions: 15054, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.35 
    Pointer pages: 5, data page slots: 4800 
    Data pages: 3960, average fill: 84% 
    Primary pages: 3958, secondary pages: 2, swept pages: 10 
    Empty pages: 34, full pages: 3870 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 6 
    40 - 59% = 36 
    60 - 79% = 10 
    80 - 99% = 3870 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.06, total records: 181466 
    Average version length: 152.69, total versions: 11953, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 7, data page slots: 6088 
    Data pages: 4520, average fill: 84% 
    Primary pages: 4518, secondary pages: 2, swept pages: 13 
    Empty pages: 45, full pages: 4457 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4457 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 140.59, total records: 166357 
    Average version length: 151.41, total versions: 12585, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.06 
    Pointer pages: 6, data page slots: 5632 
    Data pages: 4168, average fill: 83% 
    Primary pages: 4167, secondary pages: 1, swept pages: 18 
    Empty pages: 66, full pages: 4079 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4080 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 134.36, total records: 174249 
    Average version length: 153.42, total versions: 20556, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.62 
    Pointer pages: 5, data page slots: 5056 
    Data pages: 4336, average fill: 84% 
    Primary pages: 4334, secondary pages: 2, swept pages: 9 
    Empty pages: 40, full pages: 4278 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 4280 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 131.96, total records: 169772 
    Average version length: 153.89, total versions: 22915, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.85 
    Pointer pages: 7, data page slots: 5240 
    Data pages: 4256, average fill: 84% 
    Primary pages: 4254, secondary pages: 2, swept pages: 26 
    Empty pages: 66, full pages: 4166 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 4167 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 139.83, total records: 173436 
    Average version length: 151.92, total versions: 14089, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.13 
    Pointer pages: 7, data page slots: 6144 
    Data pages: 4368, average fill: 83% 
    Primary pages: 4366, secondary pages: 2, swept pages: 27 
    Empty pages: 84, full pages: 4254 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 15 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4255 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 132.49, total records: 173385 
    Average version length: 154.08, total versions: 22572, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.80 
    Pointer pages: 6, data page slots: 5296 
    Data pages: 4320, average fill: 84% 
    Primary pages: 4319, secondary pages: 1, swept pages: 8 
    Empty pages: 39, full pages: 4241 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 6 
    40 - 59% = 22 
    60 - 79% = 10 
    80 - 99% = 4242 
 
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.54, total records: 2119219 
    Average version length: 52.89, total versions: 10303, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.33 
    Pointer pages: 16, data page slots: 25912 
    Data pages: 25912, average fill: 70% 
    Primary pages: 25899, secondary pages: 13, swept pages: 12568 
    Empty pages: 99, full pages: 21959 
    Fill distribution: 
     0 - 19% = 193 
    20 - 39% = 224 
    40 - 59% = 880 
    60 - 79% = 24527 
    80 - 99% = 88 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2620, nodes: 2119219 
    Average node length: 5.44, total dup: 1978024, max dup: 1566 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183593, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 305 
        40 - 59% = 1705 
        60 - 79% = 309 
        80 - 99% = 294 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2765, nodes: 2119219 
    Average node length: 5.69, total dup: 1902072, max dup: 63 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 378957, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2319 
        60 - 79% = 414 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2111, nodes: 2119219 
    Average node length: 4.96, total dup: 2119119, max dup: 28393 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181357, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 174 
        40 - 59% = 1077 
        60 - 79% = 404 
        80 - 99% = 452 
 
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: 49.69, total records: 128025 
    Average version length: 69.15, total versions: 41538, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.54 
    Pointer pages: 3, data page slots: 4200 
    Data pages: 3120, average fill: 49% 
    Primary pages: 3119, secondary pages: 1, swept pages: 547 
    Empty pages: 482, full pages: 929 
    Fill distribution: 
     0 - 19% = 691 
    20 - 39% = 384 
    40 - 59% = 716 
    60 - 79% = 878 
    80 - 99% = 451 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103393, depth: 3, leaf buckets: 221, nodes: 128025 
    Average node length: 6.44, total dup: 111389, max dup: 14 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 22666, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 70 
        40 - 59% = 120 
        60 - 79% = 30 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.30, total records: 6576560 
    Average version length: 68.72, total versions: 180161, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 63, data page slots: 102592 
    Data pages: 102592, average fill: 69% 
    Primary pages: 102591, secondary pages: 1, swept pages: 52389 
    Empty pages: 69, full pages: 39672 
    Fill distribution: 
     0 - 19% = 447 
    20 - 39% = 1039 
    40 - 59% = 11083 
    60 - 79% = 89663 
    80 - 99% = 360 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10583, nodes: 6576560 
    Average node length: 6.52, total dup: 5687656, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1545994, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 2300 
        40 - 59% = 5848 
        60 - 79% = 2145 
        80 - 99% = 278 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8314, nodes: 6576560 
    Average node length: 5.41, total dup: 6303878, max dup: 134 
    Average key length: 2.42, compression ratio: 7.02 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1364007, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1591 
        40 - 59% = 4499 
        60 - 79% = 1417 
        80 - 99% = 800 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8360, nodes: 6576560 
    Average node length: 5.41, total dup: 6303878, max dup: 134 
    Average key length: 2.42, compression ratio: 7.02 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1366361, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1707 
        40 - 59% = 4392 
        60 - 79% = 1437 
        80 - 99% = 817 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.28, total records: 11632640 
    Average version length: 68.75, total versions: 127904, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 106, data page slots: 171704 
    Data pages: 171704, average fill: 72% 
    Primary pages: 171703, secondary pages: 1, swept pages: 103661 
    Empty pages: 11, full pages: 118988 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 680 
    40 - 59% = 8095 
    60 - 79% = 162366 
    80 - 99% = 492 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18269, nodes: 11631885 
    Average node length: 6.60, total dup: 10143311, max dup: 53 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2408197, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 2874 
        40 - 59% = 10869 
        60 - 79% = 3831 
        80 - 99% = 679 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 57.48, total records: 1198821 
    Average version length: 69.11, total versions: 165565, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.19 
    Pointer pages: 27, data page slots: 42384 
    Data pages: 26928, average fill: 48% 
    Primary pages: 26863, secondary pages: 65, swept pages: 13406 
    Empty pages: 4577, full pages: 11771 
    Fill distribution: 
     0 - 19% = 7018 
    20 - 39% = 3444 
    40 - 59% = 3055 
    60 - 79% = 11378 
    80 - 99% = 2033 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1755, nodes: 1131605 
    Average node length: 5.54, total dup: 1085714, max dup: 49 
    Average key length: 2.58, compression ratio: 16.26 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 78777, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 670 
        40 - 59% = 844 
        60 - 79% = 221 
        80 - 99% = 9 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 50.85, total records: 880626 
    Average version length: 69.00, total versions: 96616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.48 
    Pointer pages: 22, data page slots: 34240 
    Data pages: 27520, average fill: 32% 
    Primary pages: 27520, secondary pages: 0, swept pages: 11420 
    Empty pages: 4874, full pages: 2529 
    Fill distribution: 
     0 - 19% = 9520 
    20 - 39% = 6461 
    40 - 59% = 7801 
    60 - 79% = 3711 
    80 - 99% = 27 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1175, nodes: 710670 
    Average node length: 5.90, total dup: 657770, max dup: 52 
    Average key length: 2.97, compression ratio: 14.15 
    Average prefix length: 41.11, average data length: 0.89 
    Clustering factor: 95561, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 479 
        40 - 59% = 534 
        60 - 79% = 157 
        80 - 99% = 4 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.96, total records: 9240780 
    Average version length: 68.97, total versions: 141989, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 89, data page slots: 144384 
    Data pages: 144384, average fill: 68% 
    Primary pages: 144370, secondary pages: 14, swept pages: 84552 
    Empty pages: 261, full pages: 62747 
    Fill distribution: 
     0 - 19% = 797 
    20 - 39% = 2529 
    40 - 59% = 18428 
    60 - 79% = 121921 
    80 - 99% = 709 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13527, nodes: 9239441 
    Average node length: 6.68, total dup: 7662588, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2123725, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1235 
        40 - 59% = 6964 
        60 - 79% = 4675 
        80 - 99% = 653 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.53, total records: 21178317 
    Average version length: 82.95, total versions: 3526, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320400 
    Data pages: 320400, average fill: 81% 
    Primary pages: 320394, secondary pages: 6, swept pages: 14479 
    Empty pages: 32, full pages: 319144 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 65 
    40 - 59% = 182 
    60 - 79% = 50484 
    80 - 99% = 269610 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19582, nodes: 21178317 
    Average node length: 5.72, total dup: 20696409, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288166, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8453 
        60 - 79% = 579 
        80 - 99% = 10542 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17231, nodes: 21178317 
    Average node length: 6.31, total dup: 18611080, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918314, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 5 
        40 - 59% = 822 
        60 - 79% = 279 
        80 - 99% = 16122 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21377, nodes: 21178317 
    Average node length: 6.35, total dup: 18529931, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582340, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 8765 
        60 - 79% = 600 
        80 - 99% = 12011 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16069, nodes: 21178317 
    Average node length: 5.56, total dup: 21178217, max dup: 230890 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947284, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 6 
        40 - 59% = 2772 
        60 - 79% = 379 
        80 - 99% = 12910 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 81.44, total records: 9685524 
    Average version length: 82.60, total versions: 129905, 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: 106, data page slots: 172624 
    Data pages: 172600, average fill: 69% 
    Primary pages: 172571, secondary pages: 29, swept pages: 108840 
    Empty pages: 628, full pages: 90657 
    Fill distribution: 
     0 - 19% = 1982 
    20 - 39% = 6164 
    40 - 59% = 22703 
    60 - 79% = 126004 
    80 - 99% = 15747 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11383, nodes: 9685524 
    Average node length: 5.38, total dup: 9375324, max dup: 178 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2221196, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 71 
        40 - 59% = 8193 
        60 - 79% = 3015 
        80 - 99% = 103 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13760, nodes: 9685524 
    Average node length: 6.25, total dup: 8028067, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1572839, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 4233 
        40 - 59% = 4497 
        60 - 79% = 2495 
        80 - 99% = 2406 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12705, nodes: 9685524 
    Average node length: 6.00, total dup: 8398331, max dup: 33 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2403265, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 69 
        40 - 59% = 9234 
        60 - 79% = 3274 
        80 - 99% = 125 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10242, nodes: 9685524 
    Average node length: 5.15, total dup: 9685424, max dup: 154818 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1601747, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1312 
        40 - 59% = 5059 
        60 - 79% = 1791 
        80 - 99% = 2045 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.54, total records: 11372070 
    Average version length: 82.60, total versions: 119263, 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: 119, data page slots: 193576 
    Data pages: 192104, average fill: 72% 
    Primary pages: 191993, secondary pages: 111, swept pages: 71315 
    Empty pages: 2601, full pages: 148424 
    Fill distribution: 
     0 - 19% = 4290 
    20 - 39% = 6194 
    40 - 59% = 15693 
    60 - 79% = 104803 
    80 - 99% = 61124 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13133, nodes: 11372070 
    Average node length: 5.32, total dup: 11261965, max dup: 626 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2378937, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 123 
        40 - 59% = 8869 
        60 - 79% = 3953 
        80 - 99% = 187 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10575, nodes: 11372070 
    Average node length: 5.52, total dup: 10876411, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 724163, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 152 
        20 - 39% = 920 
        40 - 59% = 2569 
        60 - 79% = 1879 
        80 - 99% = 5055 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15018, nodes: 11372070 
    Average node length: 6.05, total dup: 9921923, max dup: 73 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2395437, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 146 
        40 - 59% = 10374 
        60 - 79% = 4280 
        80 - 99% = 217 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10967, nodes: 11372070 
    Average node length: 5.24, total dup: 11371970, max dup: 184004 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 712086, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 886 
        40 - 59% = 4936 
        60 - 79% = 1511 
        80 - 99% = 3531 
 
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.84, total records: 9791998 
    Average version length: 82.90, total versions: 119285, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.54 
    Pointer pages: 109, data page slots: 177576 
    Data pages: 177528, average fill: 68% 
    Primary pages: 177502, secondary pages: 26, swept pages: 118581 
    Empty pages: 638, full pages: 86891 
    Fill distribution: 
     0 - 19% = 2121 
    20 - 39% = 7462 
    40 - 59% = 27266 
    60 - 79% = 125757 
    80 - 99% = 14922 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11979, nodes: 9791998 
    Average node length: 5.20, total dup: 9763193, max dup: 1999 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2003604, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1627 
        40 - 59% = 7918 
        60 - 79% = 1824 
        80 - 99% = 578 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13930, nodes: 9791998 
    Average node length: 6.27, total dup: 8116106, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1517825, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 4305 
        40 - 59% = 4434 
        60 - 79% = 2499 
        80 - 99% = 2514 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12614, nodes: 9791998 
    Average node length: 5.45, total dup: 9352441, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2135877, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1562 
        40 - 59% = 8813 
        60 - 79% = 1634 
        80 - 99% = 578 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10427, nodes: 9791998 
    Average node length: 5.17, total dup: 9791898, max dup: 157041 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1602208, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1424 
        40 - 59% = 5173 
        60 - 79% = 1709 
        80 - 99% = 2078 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.99, total records: 577100 
    Average version length: 68.77, total versions: 1839, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 5, data page slots: 8120 
    Data pages: 8120, average fill: 74% 
    Primary pages: 8120, secondary pages: 0, swept pages: 4343 
    Empty pages: 2, full pages: 6708 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 6 
    40 - 59% = 155 
    60 - 79% = 7945 
    80 - 99% = 12 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37139, depth: 3, leaf buckets: 743, nodes: 577100 
    Average node length: 5.95, total dup: 491135, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 101606, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 34 
        40 - 59% = 531 
        60 - 79% = 89 
        80 - 99% = 89 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29306, depth: 3, leaf buckets: 758, nodes: 577100 
    Average node length: 6.15, total dup: 473233, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101644, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 527 
        60 - 79% = 93 
        80 - 99% = 105 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 560, nodes: 577100 
    Average node length: 4.86, total dup: 577000, max dup: 9252 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90386, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 323 
        60 - 79% = 67 
        80 - 99% = 139 
 
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 Sun Mar 24 10:11:03 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7779023 26484 1 0.0000 0.0000
DOC_LIST 2266704 13388 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 399 4 0.0000 0.0000
INVNT_TURNOVER_LOG 70248 58833 1 0.0000 0.0000
MONEY_SALDO 49 9 1 0.0000 0.0000
MONEY_TURNOVER_LOG 1154 1040 1 0.0000 0.0000
PDISTR 751000 17398 2 0.0000 0.0000
PERF_SPLIT_0 172059 22365 1 0.0000 0.0000
PERF_SPLIT_1 173969 23475 1 0.0000 0.0000
PERF_SPLIT_2 165973 13507 1 0.0000 0.0000
PERF_SPLIT_3 158867 15054 1 0.0000 0.0000
PERF_SPLIT_4 181466 11953 1 0.0000 0.0000
PERF_SPLIT_5 166357 12585 1 0.0000 0.0000
PERF_SPLIT_6 174249 20556 1 0.0000 0.0000
PERF_SPLIT_7 169772 22915 1 0.0000 0.0000
PERF_SPLIT_8 173436 14089 1 0.0000 0.0000
PERF_SPLIT_9 173385 22572 1 0.0000 0.0000
PSTORNED 2119219 10303 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 128025 41538 1 0.0000 0.0000
XQD_1000_3300 6576560 180161 1 0.0000 0.0000
XQD_1200_2000 11632640 127904 1 0.0000 0.0000
XQD_2000_3300 1198821 165565 1 0.0000 0.0000
XQD_2100_3300 880626 96616 1 0.0000 0.0000
XQD_3300_3400 9240780 141989 1 0.0000 0.0000
XQS_1000_1200 21178317 3526 1 0.0000 0.0000
XQS_1000_3300 9685524 129905 1 0.0000 0.0000
XQS_1200_2000 11372070 119263 1 0.0000 0.0000
XQS_2100_3300 9791998 119285 1 0.0000 0.0000
XQS_3300_3400 577100 1839 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 ---
:55: 
:56: mscs-test-161.budzdorov.ru    Sun Mar 24 10:08:19 2024
:57:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:58: 
:59: 
:60: mscs-test-161.budzdorov.ru    Sun Mar 24 10:08:20 2024
:61:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:62: 
:63: 
:64: mscs-test-161.budzdorov.ru    Sun Mar 24 10:08:20 2024
:65:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:66: 
:67: 
:68: mscs-test-161.budzdorov.ru    Sun Mar 24 10:08:20 2024
:69:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:70: 
--- end of diff output ---

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

24.03.24 10:11:16. 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-03-24 10:11:18 No severe PSQL-related problems occured
24.03.24 10:11:20. End of report.