Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.03.2024 16:10
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database Statistics, full
  3. Record versions statistics    as table    as chart
  4. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  5. New in firebird.log while test was run
  6. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16009936 kB
MemAvailable 30285408 kB
Buffers 0 kB
Cached 15735144 kB
SwapCached 2204 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


SERVER_MODE                     SuperServer 3.0.12
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings 

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-05 16:09:43
DTS_END                         2024-03-05 16:09:43.1420
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/46006
TRN_ID                          171411
ATT_ID                          596
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: 8924.62 21820 892462
customer order: creation 167.21 358 16721
customer order: refuse 14.72 374 1472
order to supplier: creation 45.12 1386 4512
order to supplier: removal 3.29 101771 329
invoice (draft): creation 45.61 3573 4561
invoice (draft): removal 47.37 798 4737
invoice accept: apply 41.91 21738 4191
invoice accept: cancel 43.15 1004 4315
customer reserve: creation 4068.76 205 406876
customer reserve: removal 4152.23 65 415223
realization accept: apply 81.01 247 8101
realization accept: cancel 87.30 115 8730
payment from customer: creation 58.57 176 5857
payment from customer: removal 5.32 136 532
payment to supplier: creation 47.97 222 4797
payment to supplier: removal 3.37 123 337
service: total inventory turnovers 4.60 1099 460
service: total monetary turnovers 6.31 27 631
service: aggregate perf. data 0.77 21344 77
service: refresh index statistics 0.03 281634 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 05-03-2024 16:10:51 to 05-03-2024 16:10:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4916
TEST_TIME 2 4005
TEST_TIME 3 3500
TEST_TIME 4 4642
TEST_TIME 5 4966
TEST_TIME 6 5359
TEST_TIME 7 5502
TEST_TIME 8 5251
TEST_TIME 9 5372
TEST_TIME 10 5337
TEST_TIME 11 5295
TEST_TIME 12 5610
TEST_TIME 13 5501
TEST_TIME 14 5783
TEST_TIME 15 6008
TEST_TIME 16 5923
TEST_TIME 17 5948
TEST_TIME 18 5844
TEST_TIME 19 5906
TEST_TIME 20 5935
TEST_TIME 21 6530
TEST_TIME 22 6901
TEST_TIME 23 7070
TEST_TIME 24 7221
TEST_TIME 25 7507
TEST_TIME 26 7551
TEST_TIME 27 7829
TEST_TIME 28 8206
TEST_TIME 29 8350
TEST_TIME 30 8823
TEST_TIME 31 8809
TEST_TIME 32 8727
TEST_TIME 33 8794
TEST_TIME 34 8647
TEST_TIME 35 8704
TEST_TIME 36 8601
TEST_TIME 37 8585
TEST_TIME 38 8597
TEST_TIME 39 8506
TEST_TIME 40 8534
TEST_TIME 41 8457
TEST_TIME 42 8296
TEST_TIME 43 8219
TEST_TIME 44 8309
TEST_TIME 45 8286
TEST_TIME 46 8222
TEST_TIME 47 8140
TEST_TIME 48 8259
TEST_TIME 49 8291
TEST_TIME 50 8234
TEST_TIME 51 8268
TEST_TIME 52 8259
TEST_TIME 53 8349
TEST_TIME 54 8400
TEST_TIME 55 8425
TEST_TIME 56 8403
TEST_TIME 57 8575
TEST_TIME 58 8538
TEST_TIME 59 8558
TEST_TIME 60 8651
TEST_TIME 61 8814
TEST_TIME 62 8806
TEST_TIME 63 8777
TEST_TIME 64 8715
TEST_TIME 65 8666
TEST_TIME 66 8609
TEST_TIME 67 8636
TEST_TIME 68 8662
TEST_TIME 69 8635
TEST_TIME 70 8546
TEST_TIME 71 8494
TEST_TIME 72 8737
TEST_TIME 73 8762
TEST_TIME 74 8752
TEST_TIME 75 8870
TEST_TIME 76 8860
TEST_TIME 77 8924
TEST_TIME 78 8951
TEST_TIME 79 9011
TEST_TIME 80 8992
TEST_TIME 81 9084
TEST_TIME 82 9052
TEST_TIME 83 9053
TEST_TIME 84 9075
TEST_TIME 85 9069
TEST_TIME 86 9026
TEST_TIME 87 8963
TEST_TIME 88 8988
TEST_TIME 89 8958
TEST_TIME 90 8960
TEST_TIME 91 8930
TEST_TIME 92 8884
TEST_TIME 93 8856
TEST_TIME 94 8772
TEST_TIME 95 8863
TEST_TIME 96 8901
TEST_TIME 97 8921
TEST_TIME 98 8923
TEST_TIME 99 8959
TEST_TIME 100 8934

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-03-2024 16:10:55 to 05-03-2024 16:10:58.

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 1261711 1261711 0 0.00 0 40893 8 0 0
doc_list_biud 1261711 1261711 0 0.00 0 61439 27 0 0
sp_add_invoice_to_stock 4272 4191 81 1.89 29 199387 21738 0 81
sp_cancel_adding_invoice 4315 4315 0 0.00 4 65056 1005 0 0
sp_cancel_client_order 1472 1472 0 0.00 4 11678 374 0 0
sp_cancel_customer_reserve 415223 415223 0 0.00 0 25000 65 0 0
sp_cancel_pay_from_customer 532 532 0 0.00 3 21556 137 0 0
sp_cancel_pay_to_supplier 337 337 0 0.00 3 18517 123 0 0
sp_cancel_supplier_invoice 4742 4737 5 0.10 2 61447 799 0 5
sp_cancel_supplier_order 329 329 0 0.00 7 912549 101771 0 0
sp_cancel_write_off 8730 8730 0 0.00 1 26101 115 0 0
sp_client_order 16721 16721 0 0.00 3 16155 359 0 0
sp_customer_reserve 406876 406876 0 0.00 0 53356 206 0 0
sp_fill_shopping_cart 25790 25790 0 0.00 1 12165 40 0 0
sp_fill_shopping_cart_clo_res 406864 406864 0 0.00 0 39658 17 0 0
sp_get_clo_for_invoice 4179 4179 0 0.00 0 46594 321 0 0
sp_kill_cost_storno 13914 13914 0 0.00 0 26012 66 0 0
sp_kill_qstorno_ret_qs2qd 844242 844242 0 0.00 0 61433 35 0 0
sp_kill_qty_storno 447086 447086 0 0.00 0 61436 76 0 0
sp_lock_selected_doc 16990 16990 0 0.00 0 8105 6 0 0
sp_make_cost_storno 22934 22934 0 0.00 0 40340 93 0 0
sp_multiply_rows_for_pdistr 22934 22934 0 0.00 0 26318 45 0 0
sp_multiply_rows_for_qdistr 16721 16721 0 0.00 0 13729 164 0 0
sp_pay_from_customer 5857 5857 0 0.00 4 41171 177 0 0
sp_pay_to_supplier 4797 4797 0 0.00 5 41461 222 0 0
sp_payment_common 10654 10654 0 0.00 1 27206 59 0 0
sp_qd_handle_on_cancel_clo 1472 1472 0 0.00 0 11665 350 0 0
sp_qd_handle_on_invoice_upd_sts 8494 8494 0 0.00 0 27755 330 0 0
sp_qd_handle_on_reserve_upd_sts 8101 8101 0 0.00 0 24003 68 0 0
sp_reserve_write_off 8101 8101 0 0.00 6 40232 248 0 0
sp_supplier_invoice 4561 4561 0 0.00 5 75939 3573 0 0
sp_supplier_order 4512 4512 0 0.00 5 27872 1387 0 0
srv_aggregate_perf_data 78 77 1 1.28 1291 367241 21345 0 1
srv_fill_mon_cache_memory 59 59 0 0.00 1747 104758 34754 0 0
srv_find_qd_qs_mism 848644 848644 0 0.00 0 23994 7 0 0
srv_make_invnt_saldo 460 460 0 0.00 79 70058 1100 0 0
srv_make_money_saldo 631 631 0 0.00 1 1837 28 0 0
srv_recalc_idx_stat 3 3 0 0.00 189877 377029 281635 0 0
t$perf-abend:sp_add_invoice_to_stock 81 81 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4193 4193 0 0.00 0 9719 159 0 0
t$perf-norm:sp_cancel_adding_invoice 353 353 0 0.00 0 5634 115 0 0
t$perf-norm:sp_cancel_client_order 1472 1472 0 0.00 0 1433 11 0 0
t$perf-norm:sp_cancel_customer_reserve 505 505 0 0.00 0 1418 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 532 532 0 0.00 0 2445 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 337 337 0 0.00 0 908 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 312 312 0 0.00 0 837 17 0 0
t$perf-norm:sp_cancel_supplier_order 329 329 0 0.00 0 18322 1498 0 0
t$perf-norm:sp_cancel_write_off 871 871 0 0.00 0 1505 7 0 0
t$perf-norm:sp_client_order 16721 16721 0 0.00 0 13635 16 0 0
t$perf-norm:sp_customer_reserve 793 793 0 0.00 0 183 3 0 0
t$perf-norm:sp_pay_from_customer 5857 5857 0 0.00 0 7660 11 0 0
t$perf-norm:sp_pay_to_supplier 4797 4797 0 0.00 0 7677 12 0 0
t$perf-norm:sp_reserve_write_off 8101 8101 0 0.00 0 2935 9 0 0
t$perf-norm:sp_supplier_invoice 4561 4561 0 0.00 0 2642 14 0 0
t$perf-norm:sp_supplier_order 4513 4513 0 0.00 0 6676 16 0 0
t$perf-norm:srv_aggregate_perf_data 77 77 0 0.00 0 947 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 18 1 0 0
t$perf-norm:srv_make_invnt_saldo 460 460 0 0.00 0 877 18 0 0
t$perf-norm:srv_make_money_saldo 631 631 0 0.00 0 2553 19 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 8518 8356 162 1.90 0 7142 19 0 162
v_all_customers 31508 31508 0 0.00 0 16 0 0 0
v_all_suppliers 25456 25456 0 0.00 0 20 1 0 0
v_all_wares 33442 33442 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 706 706 0 0.00 0 1528 10 0 0
v_cancel_client_order 2944 2944 0 0.00 0 2999 5 0 0
v_cancel_customer_prepayment 1064 1064 0 0.00 0 605 5 0 0
v_cancel_customer_reserve 1010 1010 0 0.00 0 5968 12 0 0
v_cancel_payment_to_supplier 674 674 0 0.00 0 857 5 0 0
v_cancel_supplier_invoice 634 624 10 1.57 0 5967 28 0 10
v_cancel_supplier_order 658 658 0 0.00 0 5931 16 0 0
v_cancel_write_off 1742 1742 0 0.00 0 4027 18 0 0
v_max_id_clo_ord 4508 4508 0 0.00 0 527 2 0 0
v_max_id_clo_res 793 793 0 0.00 0 5970 35 0 0
v_max_id_ord_sup 4561 4561 0 0.00 0 5700 5 0 0
v_max_non_paid_invoice 1138 1138 0 0.00 0 331 2 0 0
v_max_non_paid_realizn 2718 2718 0 0.00 0 1850 5 0 0
v_min_id_clo_ord 4508 4508 0 0.00 0 4701 9 0 0
v_min_id_clo_res 793 793 0 0.00 0 2020 6 0 0
v_min_id_ord_sup 4561 4561 0 0.00 0 5830 7 0 0
v_min_non_paid_invoice 4797 4797 0 0.00 0 25590 47 0 0
v_min_non_paid_realizn 5857 5857 0 0.00 0 27202 52 0 0
v_our_firm 8212 8212 0 0.00 0 18 1 0 0
v_reserve_write_off 16202 16202 0 0.00 0 5257 6 0 0
x_lock_depdocs_on_canc_invoice 8740 8740 0 0.00 0 18624 145 0 0
x_lock_depdocs_on_canc_sup_ord 329 329 0 0.00 0 5984 320 0 0
x_make_qstorno_1000_1200 4512 4512 0 0.00 1 27863 1309 0 0
x_make_qstorno_1200_2000 4561 4561 0 0.00 2 75913 3418 0 0
x_make_qstorno_2100_3300 406876 406876 0 0.00 0 39541 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-03-2024 16:10:59 to 05-03-2024 16:11:03.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:09:47 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:47 34255 8192000000 9891651344 10198360064 974976304 10.635 100 87 174 0 1003966960 5786208 23204448
14:12:28 15484 8192000000 9926647120 10243764224 1008278976 10.959 100 89 178 0 1039827568 8231904 23316688
14:13:51 10140 8192000000 9952348624 10276315136 1037324960 11.239 100 86 172 0 1068251600 9190464 21736176
14:15:08 6816 8192000000 10005433072 10345517056 1090739616 11.750 100 86 169 0 1121985056 10602480 20642960
14:16:18 3993 8192000000 10045730848 10397294592 1133822816 12.157 100 79 157 0 1164143552 12197088 18123648
14:17:25 4754 8192000000 10093453344 10454970368 1177486496 12.567 100 76 148 2 1207122160 12441568 17194096
14:18:32 3250 8192000000 10132000544 10504650752 1224534752 13.004 100 77 150 2 1252913472 11804480 16574240
14:19:36 1832 8192000000 10175071760 10548559872 1256876288 13.301 100 94 187 0 1292516896 14801296 20839312
14:20:40 1622 8192000000 10200954496 10582106112 1284079200 13.550 100 87 172 0 1317506352 14355856 19071296
14:21:42 17450 8192000000 10174936160 10584432640 1288829936 13.594 100 28 56 0 1305494528 10280048 6384544
14:23:01 6348 8192000000 10188814864 10600140800 1301602496 13.710 100 26 54 0 1313158080 6042560 5513024
14:24:10 7255 8192000000 10203238544 10616229888 1315209632 13.833 100 24 49 0 1326861584 6813776 4838176
14:25:23 66719 8192000000 10223071824 10636165120 1325820848 13.929 100 36 73 1 1339493296 4955536 8716912
14:27:31 3809 8192000000 10233865184 10649370624 1334650848 14.009 100 35 69 0 1350274400 7539872 8083680
14:28:37 8935 8192000000 10224463264 10646061056 1326001152 13.931 99 18 36 1 1335838288 5763344 4073792
14:29:47 24157 8192000000 10229488576 10636820480 1326229136 13.933 100 32 64 0 1338934256 5605296 7099824
14:31:15 13050 8192000000 10236222320 10643324928 1318120208 13.860 99 48 94 0 1341745760 12265360 11360192
14:32:35 34796 8192000000 10226465616 10639372288 1302347424 13.717 98 41 82 0 1323139856 10301472 10490960
14:34:28 27690 8192000000 10219966688 10623254528 1295871136 13.658 98 50 101 0 1316491072 9381424 11238512
14:36:00 16423 8192000000 10230282304 10631315456 1293268128 13.634 98 58 116 0 1318611344 12289600 13053616
14:37:23 42473 8192000000 10231089872 10632261632 1297394656 13.672 98 55 110 1 1323353984 13249168 12710160
14:39:14 37514 8192000000 10197942240 10608910336 1259519072 13.326 96 23 46 0 1276323584 11028960 5775552
14:40:54 1746 8192000000 10201991568 10601971712 1286652720 13.574 99 39 77 0 1308470224 13149648 8667856
14:42:01 22181 8192000000 10245945520 10640879616 1312690112 13.810 99 59 117 0 1344058768 17709840 13658816
14:43:33 12499 8192000000 10243129424 10644074496 1311019456 13.795 99 45 88 0 1343101248 21349136 10732656
14:44:52 3409 8192000000 10266254848 10668195840 1341668848 14.072 100 56 111 0 1376397568 21102176 13626544
14:46:00 11166 8192000000 10279265488 10684641280 1350239488 14.150 100 62 123 0 1389420016 23755520 15425008
14:47:21 7242 8192000000 10275118144 10680688640 1348036464 14.130 100 60 119 2 1386933968 24193344 14704160
14:48:39 2330 8192000000 10300061776 10704592896 1351898448 14.165 99 69 136 0 1400931408 31946464 17086496
14:49:50 8700 8192000000 10314867984 10720456704 1362459328 14.259 100 71 138 0 1420505520 40602544 17443648
14:51:04 7597 8192000000 10308718448 10726055936 1372031936 14.345 100 52 103 0 1417395360 32828864 12534560
14:52:23 6925 8192000000 10331110288 10747539456 1389853776 14.505 100 59 118 0 1438423520 33191536 15378208
14:53:33 14766 8192000000 10321786864 10750836736 1390524496 14.511 100 29 58 0 1429449760 30974480 7950784
14:54:51 10514 8192000000 10327779184 10765205504 1397119568 14.569 100 25 50 0 1436075056 32538688 6416800
14:56:05 19303 8192000000 10321886224 10762190848 1389786400 14.504 100 28 54 0 1436611584 39236848 7588336
14:57:30 15644 8192000000 10315575552 10760224768 1386529088 14.475 100 25 50 0 1423458816 30339440 6590288
14:58:52 17982 8192000000 10313973536 10751533056 1380743936 14.423 100 25 49 0 1412130144 25476384 5909824
15:00:15 29302 8192000000 10310555664 10750042112 1392824048 14.531 100 35 70 0 1413953408 12891424 8237936
15:01:45 42686 8192000000 10311990384 10759065600 1396249760 14.562 100 30 60 0 1417914016 14531072 7133184
15:03:30 2953 8192000000 10315913024 10752294912 1399703680 14.592 100 57 114 1 1420876320 7521072 13651568
15:04:41 55891 8192000000 10296422624 10749177856 1386231840 14.472 99 23 45 0 1398217200 7212704 4772656
15:06:39 46761 8192000000 10300529536 10758434816 1404840896 14.638 100 14 29 0 1417096544 9001456 3254192
15:08:28 45929 8192000000 10298865536 10754252800 1392623344 14.529 99 17 35 2 1405055040 8216464 4215232
15:10:28 74248 8192000000 10327191936 10773356544 1411833280 14.700 100 33 66 2 1425637264 6086528 7717456
15:12:50 56721 8192000000 10312821312 10778394624 1414966592 14.728 100 20 40 0 1435230144 15597632 4665920
15:14:48 30152 8192000000 10298302480 10751021056 1369972608 14.327 97 33 65 0 1384606864 7606624 7027632
15:16:19 27953 8192000000 10287855664 10739912704 1389045888 14.497 99 35 70 0 1407116640 9346128 8724624
15:18:24 63368 8192000000 10277353472 10732703744 1327443072 13.944 95 12 24 0 1337739840 7122560 3174208
15:20:29 29521 8192000000 10255229712 10690965504 1297702944 13.674 94 31 62 0 1314037392 9559888 6774560
15:22:03 33302 8192000000 10271154464 10717499392 1364604576 14.279 100 30 60 0 1385043152 13672000 6766576
15:23:41 6728 8192000000 10261822816 10682744832 1344025328 14.094 99 47 93 2 1362084304 7295776 10763200
15:24:49 32125 8192000000 10261803120 10700722176 1344819120 14.101 99 25 50 0 1361816960 11708688 5289152
15:26:25 57831 8192000000 10270961920 10723467264 1354299488 14.186 99 21 40 1 1369920976 11272144 4349344
15:28:27 58538 8192000000 10270076448 10710200320 1321841440 13.893 97 24 47 0 1348262016 21324688 5095888
15:30:26 37414 8192000000 10245253552 10677399552 1286146672 13.569 96 27 54 0 1303167456 10548000 6472784
15:32:16 104757 8192000000 10204699024 10642489344 1267614464 13.400 96 27 54 0 1283714464 9391520 6708480
15:35:01 38577 8192000000 10233780480 10657574912 1311174720 13.797 99 35 70 0 1333370656 14129152 8066784
15:36:41 28592 8192000000 10217151664 10656239616 1282004880 13.531 96 28 56 0 1303478336 14734976 6738480
15:38:15 52484 8192000000 10240711184 10685177856 1329823984 13.966 99 11 22 0 1345852176 13543136 2485056
15:40:23 74403 8192000000 10252965088 10708303872 1331695168 13.982 99 15 30 0 1364993424 29324592 3973664
15:44:04 41850 8192000000 10272099152 10732687360 1369475008 14.322 100 19 38 0 1386809536 13071088 4263440
15:46:01 29791 8192000000 10273994944 10712707072 1333767216 14.001 97 22 42 0 1351828304 13383312 4677776
15:47:32 26563 8192000000 10285830448 10721005568 1372380064 14.348 100 38 75 1 1390691904 10992080 7319760
15:49:02 62452 8192000000 10297051040 10744791040 1375677136 14.378 99 23 44 0 1393444352 12544800 5222416
15:51:05 49652 8192000000 10304683680 10746142720 1392134496 14.525 100 30 60 0 1408372976 9496720 6741760
15:52:58 51563 8192000000 10311080688 10754207744 1393120800 14.534 100 23 46 0 1412078656 14026064 4931792
15:54:49 69661 8192000000 10309940064 10766569472 1406233600 14.650 100 24 48 0 1429348880 17802864 5312416
15:57:33 59553 8192000000 10317325920 10770960384 1412094320 14.703 100 22 44 0 1430458304 13007664 5356320
15:59:33 16315 8192000000 10300085776 10756673536 1403252640 14.624 100 18 36 0 1416293264 9186912 3853712
16:00:52 59936 8192000000 10308393536 10761306112 1408434896 14.670 100 9 18 0 1422272640 11701760 2135984
16:02:54 60291 8192000000 10307576512 10757382144 1399732400 14.593 100 11 22 0 1418107776 15675344 2700032
16:05:26 58646 8192000000 10310385312 10754605056 1374174288 14.364 98 15 30 0 1389115104 11990976 2949840
16:07:30 35772 8192000000 10282075488 10719371264 1327764192 13.947 95 16 32 0 1338259616 7079792 3415632
16:09:07 40047 8192000000 9581317408 9904300032 706926880 7.943 51 20 40 0 717638720 6833152 3878688

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          170175
MON$OLDEST_ACTIVE               171652
MON$OLDEST_SNAPSHOT             171652
MON$NEXT_TRANSACTION            171652
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1884992
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Tue Mar  5 16:11:23 2024 
 
Database header page information: 
    Flags            0 
    Generation        89218 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    170175 
    Oldest active        171652 
    Oldest snapshot        171652 
    Next transaction    171653 
    Sequence number        0 
    Next attachment ID    699 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.16, total records: 7827937 
    Average version length: 48.16, total versions: 120071, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86824 
    Data pages: 86824, average fill: 72% 
    Primary pages: 86824, secondary pages: 0, swept pages: 14617 
    Empty pages: 6, full pages: 68950 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 18 
    40 - 59% = 609 
    60 - 79% = 86155 
    80 - 99% = 36 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23406, nodes: 7827937 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1757431, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 393 
        20 - 39% = 1488 
        40 - 59% = 4322 
        60 - 79% = 2187 
        80 - 99% = 15016 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13539, nodes: 7827937 
    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: 1580163, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1434 
        40 - 59% = 2118 
        60 - 79% = 994 
        80 - 99% = 8993 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8393, nodes: 7827937 
    Average node length: 6.64, total dup: 5822984, max dup: 49 
    Average key length: 3.65, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1573212, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 818 
        40 - 59% = 1519 
        60 - 79% = 803 
        80 - 99% = 5106 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.95, total records: 2295802 
    Average version length: 34.74, total versions: 120253, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28616 
    Data pages: 28616, average fill: 75% 
    Primary pages: 28612, secondary pages: 4, swept pages: 7991 
    Empty pages: 3, full pages: 22144 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 52 
    40 - 59% = 752 
    60 - 79% = 26578 
    80 - 99% = 1228 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4599, nodes: 2295802 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 715844, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 874 
        40 - 59% = 882 
        60 - 79% = 638 
        80 - 99% = 2205 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2548, nodes: 2298994 
    Average node length: 4.97, total dup: 2298095, max dup: 19091 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1254132, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 223 
        40 - 59% = 1579 
        60 - 79% = 551 
        80 - 99% = 194 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2076, nodes: 2295802 
    Average node length: 4.97, total dup: 2295752, max dup: 130078 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1075670, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 42 
        40 - 59% = 1160 
        60 - 79% = 52 
        80 - 99% = 817 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4396, nodes: 2295802 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 715844, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 511 
        40 - 59% = 675 
        60 - 79% = 725 
        80 - 99% = 2369 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 81.91, total records: 400 
    Average version length: 23.32, total versions: 230589, max versions: 599 
    Average fragment length: 2.03, total fragments: 78, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1328, average fill: 88% 
    Primary pages: 14, secondary pages: 1314, swept pages: 0 
    Empty pages: 7, full pages: 1320 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1319 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 15.39, total records: 86464 
    Average version length: 68.29, total versions: 66983, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.72 
    Pointer pages: 6, data page slots: 3112 
    Data pages: 1984, average fill: 54% 
    Primary pages: 1983, secondary pages: 1, swept pages: 0 
    Empty pages: 320, full pages: 816 
    Fill distribution: 
     0 - 19% = 475 
    20 - 39% = 217 
    40 - 59% = 289 
    60 - 79% = 311 
    80 - 99% = 692 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1718041, depth: 3, leaf buckets: 389, nodes: 86465 
    Average node length: 13.50, total dup: 7196, max dup: 2 
    Average key length: 10.59, compression ratio: 2.55 
    Average prefix length: 19.32, average data length: 7.68 
    Clustering factor: 62481, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 275 
        40 - 59% = 107 
        60 - 79% = 6 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 17390, max versions: 896 
    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: 64 
    Data pages: 64, average fill: 87% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 55 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.69, total records: 1371 
    Average version length: 43.78, total versions: 1256, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 15.73 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 42% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 10 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90793, depth: 2, leaf buckets: 2, nodes: 1371 
    Average node length: 4.47, total dup: 1274, max dup: 142 
    Average key length: 2.74, compression ratio: 6.93 
    Average prefix length: 18.33, average data length: 0.67 
    Clustering factor: 744, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.85, total records: 75 
    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.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.65, total records: 814449 
    Average version length: 25.17, total versions: 87912, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 7936 
    Data pages: 7936, average fill: 72% 
    Primary pages: 7916, secondary pages: 20, swept pages: 897 
    Empty pages: 19, full pages: 7540 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 8 
    40 - 59% = 13 
    60 - 79% = 7489 
    80 - 99% = 400 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 880, nodes: 814449 
    Average node length: 4.87, total dup: 814400, max dup: 142703 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92104, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 93 
        40 - 59% = 501 
        60 - 79% = 231 
        80 - 99% = 55 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 938, nodes: 814449 
    Average node length: 5.88, total dup: 724710, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163528, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 86 
        40 - 59% = 408 
        60 - 79% = 169 
        80 - 99% = 274 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 984, nodes: 814449 
    Average node length: 5.89, total dup: 724710, max dup: 42 
    Average key length: 3.02, compression ratio: 7.27 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165526, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 193 
        40 - 59% = 379 
        60 - 79% = 133 
        80 - 99% = 279 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1156, nodes: 814449 
    Average node length: 5.97, total dup: 724710, max dup: 42 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 158420, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 261 
        40 - 59% = 587 
        60 - 79% = 218 
        80 - 99% = 89 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.75, total records: 5419 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.11, total fragments: 85, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 72, secondary pages: 16, swept pages: 51 
    Empty pages: 7, full pages: 63 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5419 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 9.98 
    Average prefix length: 34.32, average data length: 1.56 
    Clustering factor: 5043, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5419 
    Average node length: 11.09, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 150, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.14, total records: 78559 
    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: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 757 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 757 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35023, depth: 2, leaf buckets: 100, nodes: 78559 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3104, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.57, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 129.64, total records: 192305 
    Average version length: 154.32, total versions: 26929, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.08 
    Pointer pages: 7, data page slots: 6976 
    Data pages: 4632, average fill: 87% 
    Primary pages: 4631, secondary pages: 1, swept pages: 4 
    Empty pages: 59, full pages: 4551 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 4552 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 138.64, total records: 183169 
    Average version length: 153.49, total versions: 14842, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.23 
    Pointer pages: 6, data page slots: 6016 
    Data pages: 4432, average fill: 86% 
    Primary pages: 4432, secondary pages: 0, swept pages: 2 
    Empty pages: 77, full pages: 4332 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4331 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 141.14, total records: 200643 
    Average version length: 152.98, total versions: 13339, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.02 
    Pointer pages: 6, data page slots: 5984 
    Data pages: 4824, average fill: 86% 
    Primary pages: 4824, secondary pages: 0, swept pages: 3 
    Empty pages: 53, full pages: 4752 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 4752 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 145.40, total records: 182736 
    Average version length: 152.62, total versions: 6876, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 5, data page slots: 6280 
    Data pages: 4416, average fill: 86% 
    Primary pages: 4416, secondary pages: 0, swept pages: 4 
    Empty pages: 70, full pages: 4322 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 4321 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 117.52, total records: 190261 
    Average version length: 154.58, total versions: 41970, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.43 
    Pointer pages: 5, data page slots: 4968 
    Data pages: 4584, average fill: 88% 
    Primary pages: 4584, secondary pages: 0, swept pages: 4 
    Empty pages: 50, full pages: 4515 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 10 
    80 - 99% = 4513 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 144.04, total records: 184848 
    Average version length: 152.47, total versions: 8523, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 6, data page slots: 5712 
    Data pages: 4456, average fill: 86% 
    Primary pages: 4456, secondary pages: 0, swept pages: 1 
    Empty pages: 63, full pages: 4369 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 10 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4370 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 142.27, total records: 188215 
    Average version length: 152.97, total versions: 11046, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.92 
    Pointer pages: 7, data page slots: 6512 
    Data pages: 4640, average fill: 84% 
    Primary pages: 4640, secondary pages: 0, swept pages: 3 
    Empty pages: 156, full pages: 4446 
    Fill distribution: 
     0 - 19% = 161 
    20 - 39% = 4 
    40 - 59% = 20 
    60 - 79% = 10 
    80 - 99% = 4445 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 143.86, total records: 169791 
    Average version length: 152.35, total versions: 7755, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.79 
    Pointer pages: 7, data page slots: 5944 
    Data pages: 4136, average fill: 85% 
    Primary pages: 4136, secondary pages: 0, swept pages: 6 
    Empty pages: 100, full pages: 4002 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 15 
    40 - 59% = 10 
    60 - 79% = 10 
    80 - 99% = 4000 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.32, total records: 182879 
    Average version length: 152.38, total versions: 8104, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 7, data page slots: 5440 
    Data pages: 4376, average fill: 86% 
    Primary pages: 4375, secondary pages: 1, swept pages: 1 
    Empty pages: 32, full pages: 4324 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 4325 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 139.71, total records: 192450 
    Average version length: 153.81, total versions: 14516, 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: 7, data page slots: 6168 
    Data pages: 4656, average fill: 86% 
    Primary pages: 4656, secondary pages: 0, swept pages: 5 
    Empty pages: 74, full pages: 4557 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 13 
    40 - 59% = 9 
    60 - 79% = 2 
    80 - 99% = 4557 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.31, total records: 2124809 
    Average version length: 52.91, total versions: 58092, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25504 
    Data pages: 25496, average fill: 72% 
    Primary pages: 25496, secondary pages: 0, swept pages: 9687 
    Empty pages: 210, full pages: 21257 
    Fill distribution: 
     0 - 19% = 389 
    20 - 39% = 343 
    40 - 59% = 916 
    60 - 79% = 23315 
    80 - 99% = 533 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2600, nodes: 2124809 
    Average node length: 5.44, total dup: 1984528, max dup: 2014 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182938, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 246 
        40 - 59% = 1745 
        60 - 79% = 300 
        80 - 99% = 303 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2755, nodes: 2124809 
    Average node length: 5.69, total dup: 1907440, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 379109, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2318 
        60 - 79% = 398 
        80 - 99% = 34 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2179, nodes: 2124809 
    Average node length: 4.96, total dup: 2124709, max dup: 28690 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180441, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 203 
        40 - 59% = 1193 
        60 - 79% = 366 
        80 - 99% = 414 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 37.95, total records: 148987 
    Average version length: 69.19, total versions: 67311, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.32 
    Pointer pages: 3, data page slots: 3736 
    Data pages: 2776, average fill: 62% 
    Primary pages: 2776, secondary pages: 0, swept pages: 359 
    Empty pages: 468, full pages: 1893 
    Fill distribution: 
     0 - 19% = 594 
    20 - 39% = 49 
    40 - 59% = 75 
    60 - 79% = 768 
    80 - 99% = 1290 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105625, depth: 3, leaf buckets: 210, nodes: 148987 
    Average node length: 6.41, total dup: 129781, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25556, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 100 
        60 - 79% = 69 
        80 - 99% = 17 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.92, total records: 7011518 
    Average version length: 68.79, total versions: 512606, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 61, data page slots: 98800 
    Data pages: 98800, average fill: 76% 
    Primary pages: 98800, secondary pages: 0, swept pages: 16132 
    Empty pages: 9, full pages: 86080 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 427 
    40 - 59% = 3087 
    60 - 79% = 84584 
    80 - 99% = 10641 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10584, nodes: 7011518 
    Average node length: 6.51, total dup: 6065091, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1552531, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1709 
        40 - 59% = 5701 
        60 - 79% = 2583 
        80 - 99% = 584 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8193, nodes: 7011518 
    Average node length: 5.40, total dup: 6730351, max dup: 212 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1349758, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 920 
        40 - 59% = 4407 
        60 - 79% = 1658 
        80 - 99% = 1199 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8279, nodes: 7011518 
    Average node length: 5.40, total dup: 6730351, max dup: 212 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1352281, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1075 
        40 - 59% = 4345 
        60 - 79% = 1644 
        80 - 99% = 1210 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.49, total records: 11936735 
    Average version length: 68.74, total versions: 427059, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 101, data page slots: 163784 
    Data pages: 163784, average fill: 77% 
    Primary pages: 163784, secondary pages: 0, swept pages: 61994 
    Empty pages: 7, full pages: 162352 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 65 
    40 - 59% = 424 
    60 - 79% = 153161 
    80 - 99% = 10124 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18185, nodes: 11936735 
    Average node length: 6.57, total dup: 10403994, max dup: 59 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2360062, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 2380 
        40 - 59% = 10780 
        60 - 79% = 4102 
        80 - 99% = 897 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 37.59, total records: 1759604 
    Average version length: 69.11, total versions: 803046, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.35 
    Pointer pages: 23, data page slots: 37304 
    Data pages: 28903, average fill: 71% 
    Primary pages: 28903, secondary pages: 0, swept pages: 5105 
    Empty pages: 1966, full pages: 21572 
    Fill distribution: 
     0 - 19% = 3129 
    20 - 39% = 1520 
    40 - 59% = 1520 
    60 - 79% = 10242 
    80 - 99% = 12492 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2191, nodes: 1759604 
    Average node length: 5.51, total dup: 1688261, max dup: 99 
    Average key length: 2.55, compression ratio: 16.45 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 116778, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 325 
        40 - 59% = 1094 
        60 - 79% = 568 
        80 - 99% = 194 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.86, total records: 1286189 
    Average version length: 69.11, total versions: 580580, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.33 
    Pointer pages: 20, data page slots: 32208 
    Data pages: 27248, average fill: 55% 
    Primary pages: 27248, secondary pages: 0, swept pages: 4769 
    Empty pages: 4642, full pages: 14181 
    Fill distribution: 
     0 - 19% = 7295 
    20 - 39% = 1407 
    40 - 59% = 1721 
    60 - 79% = 7764 
    80 - 99% = 9061 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1746, nodes: 1286189 
    Average node length: 5.78, total dup: 1201944, max dup: 95 
    Average key length: 2.84, compression ratio: 14.81 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 174702, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 326 
        40 - 59% = 893 
        60 - 79% = 417 
        80 - 99% = 107 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.51, total records: 9566959 
    Average version length: 68.99, total versions: 607788, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 88, data page slots: 142728 
    Data pages: 142720, average fill: 72% 
    Primary pages: 142720, secondary pages: 0, swept pages: 43227 
    Empty pages: 176, full pages: 91790 
    Fill distribution: 
     0 - 19% = 580 
    20 - 39% = 2699 
    40 - 59% = 15343 
    60 - 79% = 112897 
    80 - 99% = 11201 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13524, nodes: 9566959 
    Average node length: 6.67, total dup: 7936875, max dup: 21 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2061286, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 904 
        40 - 59% = 6482 
        60 - 79% = 5209 
        80 - 99% = 924 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21132867 
    Average version length: 82.96, total versions: 14910, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318544 
    Data pages: 318544, average fill: 81% 
    Primary pages: 318544, secondary pages: 0, swept pages: 12063 
    Empty pages: 45, full pages: 317655 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 43 
    40 - 59% = 129 
    60 - 79% = 27281 
    80 - 99% = 291025 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19230, nodes: 21132867 
    Average node length: 5.72, total dup: 20652336, max dup: 139 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3276401, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 7886 
        60 - 79% = 511 
        80 - 99% = 10826 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17152, nodes: 21132867 
    Average node length: 6.31, total dup: 18570984, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 912360, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 787 
        60 - 79% = 261 
        80 - 99% = 16099 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 20989, nodes: 21132867 
    Average node length: 6.35, total dup: 18490723, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571290, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8115 
        60 - 79% = 572 
        80 - 99% = 12294 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16058, nodes: 21132867 
    Average node length: 5.56, total dup: 21132767, max dup: 232049 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941206, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2840 
        60 - 79% = 365 
        80 - 99% = 12841 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.75, total records: 9972918 
    Average version length: 82.65, total versions: 564849, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 102, data page slots: 165912 
    Data pages: 165904, average fill: 74% 
    Primary pages: 165904, secondary pages: 0, swept pages: 59474 
    Empty pages: 141, full pages: 109814 
    Fill distribution: 
     0 - 19% = 375 
    20 - 39% = 1944 
    40 - 59% = 13978 
    60 - 79% = 80918 
    80 - 99% = 68689 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11398, nodes: 9972918 
    Average node length: 5.37, total dup: 9660534, max dup: 185 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2219128, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 31 
        40 - 59% = 7432 
        60 - 79% = 3763 
        80 - 99% = 170 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13722, nodes: 9972918 
    Average node length: 6.24, total dup: 8269372, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1546188, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 3843 
        40 - 59% = 4353 
        60 - 79% = 2762 
        80 - 99% = 2615 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12729, nodes: 9972918 
    Average node length: 5.98, total dup: 8660471, max dup: 44 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2417489, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 49 
        40 - 59% = 8337 
        60 - 79% = 4135 
        80 - 99% = 206 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10381, nodes: 9972918 
    Average node length: 5.14, total dup: 9972818, max dup: 152140 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1563852, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1210 
        40 - 59% = 5123 
        60 - 79% = 1838 
        80 - 99% = 2168 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.25, total records: 11616252 
    Average version length: 82.54, total versions: 432503, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 118, data page slots: 191488 
    Data pages: 190448, average fill: 75% 
    Primary pages: 190448, secondary pages: 0, swept pages: 62672 
    Empty pages: 1911, full pages: 151467 
    Fill distribution: 
     0 - 19% = 3388 
    20 - 39% = 5603 
    40 - 59% = 13839 
    60 - 79% = 41619 
    80 - 99% = 125999 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13160, nodes: 11616252 
    Average node length: 5.32, total dup: 11505781, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2412929, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 91 
        40 - 59% = 8280 
        60 - 79% = 4521 
        80 - 99% = 268 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10578, nodes: 11616252 
    Average node length: 5.52, total dup: 11110693, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 718876, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 134 
        20 - 39% = 754 
        40 - 59% = 2512 
        60 - 79% = 1842 
        80 - 99% = 5336 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15051, nodes: 11616252 
    Average node length: 6.04, total dup: 10141613, max dup: 64 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2429487, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 139 
        40 - 59% = 9654 
        60 - 79% = 4940 
        80 - 99% = 315 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10919, nodes: 11616252 
    Average node length: 5.24, total dup: 11616152, max dup: 199997 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 707004, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 72 
        20 - 39% = 758 
        40 - 59% = 4823 
        60 - 79% = 1436 
        80 - 99% = 3830 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.28, total records: 10063682 
    Average version length: 82.95, total versions: 542100, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 105, data page slots: 169808 
    Data pages: 169792, average fill: 73% 
    Primary pages: 169792, secondary pages: 0, swept pages: 65311 
    Empty pages: 334, full pages: 108496 
    Fill distribution: 
     0 - 19% = 831 
    20 - 39% = 2770 
    40 - 59% = 16055 
    60 - 79% = 84160 
    80 - 99% = 65976 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12150, nodes: 10063682 
    Average node length: 5.19, total dup: 10034545, max dup: 1539 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2001797, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1448 
        40 - 59% = 8157 
        60 - 79% = 1880 
        80 - 99% = 633 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13837, nodes: 10063682 
    Average node length: 6.26, total dup: 8344577, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1504980, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 188 
        20 - 39% = 3807 
        40 - 59% = 4341 
        60 - 79% = 2784 
        80 - 99% = 2717 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12805, nodes: 10063682 
    Average node length: 5.44, total dup: 9616239, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2142015, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1423 
        40 - 59% = 9061 
        60 - 79% = 1721 
        80 - 99% = 569 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10484, nodes: 10063682 
    Average node length: 5.16, total dup: 10063582, max dup: 154379 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1581524, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1195 
        40 - 59% = 5180 
        60 - 79% = 1843 
        80 - 99% = 2226 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.92, total records: 572833 
    Average version length: 68.85, total versions: 10422, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 7960 
    Data pages: 7960, average fill: 75% 
    Primary pages: 7960, secondary pages: 0, swept pages: 3518 
    Empty pages: 2, full pages: 6647 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 24 
    40 - 59% = 184 
    60 - 79% = 7558 
    80 - 99% = 190 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39202, depth: 3, leaf buckets: 735, nodes: 572833 
    Average node length: 5.95, total dup: 487658, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99995, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 523 
        60 - 79% = 94 
        80 - 99% = 89 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28207, depth: 3, leaf buckets: 752, nodes: 572833 
    Average node length: 6.15, total dup: 469886, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100060, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 523 
        60 - 79% = 98 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 581, nodes: 572833 
    Average node length: 4.86, total dup: 572733, max dup: 9245 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88741, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 39 
        40 - 59% = 338 
        60 - 79% = 98 
        80 - 99% = 105 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar  5 16:11:47 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7827937 120071 1 0.0000 0.0000
DOC_LIST 2295802 120253 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 230589 599 57600.0000 0.0000
INVNT_TURNOVER_LOG 86464 66983 1 0.0000 0.0000
MONEY_SALDO 49 17390 896 35400.0000 0.0000
MONEY_TURNOVER_LOG 1371 1256 1 0.0000 0.0000
PDISTR 814449 87912 5 0.0000 0.0000
PERF_SPLIT_0 192305 26929 1 0.0000 0.0000
PERF_SPLIT_1 183169 14842 1 0.0000 0.0000
PERF_SPLIT_2 200643 13339 1 0.0000 0.0000
PERF_SPLIT_3 182736 6876 1 0.0000 0.0000
PERF_SPLIT_4 190261 41970 1 0.0000 0.0000
PERF_SPLIT_5 184848 8523 1 0.0000 0.0000
PERF_SPLIT_6 188215 11046 1 0.0000 0.0000
PERF_SPLIT_7 169791 7755 1 0.0000 0.0000
PERF_SPLIT_8 182879 8104 1 0.0000 0.0000
PERF_SPLIT_9 192450 14516 1 0.0000 0.0000
PSTORNED 2124809 58092 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 148987 67311 1 0.0000 0.0000
XQD_1000_3300 7011518 512606 1 0.0000 0.0000
XQD_1200_2000 11936735 427059 1 0.0000 0.0000
XQD_2000_3300 1759604 803046 1 0.0000 0.0000
XQD_2100_3300 1286189 580580 1 0.0000 0.0000
XQD_3300_3400 9566959 607788 1 0.0000 0.0000
XQS_1000_1200 21132867 14910 1 0.0000 0.0000
XQS_1000_3300 9972918 564849 1 0.0000 0.0000
XQS_1200_2000 11616252 432503 1 0.0000 0.0000
XQS_2100_3300 10063682 542100 1 0.0000 0.0000
XQS_3300_3400 572833 10422 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 ---
:214: 
:215: mscs-test-161.budzdorov.ru    Tue Mar  5 16:09:52 2024
:216:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:217: 
:218: 
:219: mscs-test-161.budzdorov.ru    Tue Mar  5 16:09:53 2024
:220:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:221: 
:222: 
:223: mscs-test-161.budzdorov.ru    Tue Mar  5 16:09:53 2024
:224:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:225: 
--- end of diff output ---

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

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