Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.02.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 15875672 kB
MemAvailable 30262336 kB
Buffers 0 kB
Cached 15858712 kB
SwapCached 2432 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-02-23 16:09:43
DTS_END                         2024-02-23 16:09:43.0380
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35632
TRN_ID                          178688
ATT_ID                          565
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: 9280.91 20597 928091
customer order: creation 176.79 361 17679
customer order: refuse 15.24 387 1524
order to supplier: creation 47.69 1262 4769
order to supplier: removal 3.59 98802 359
invoice (draft): creation 47.51 3311 4751
invoice (draft): removal 48.96 855 4896
invoice accept: apply 42.47 20073 4247
invoice accept: cancel 44.24 879 4424
customer reserve: creation 4159.51 188 415951
customer reserve: removal 4394.90 64 439490
realization accept: apply 88.18 176 8818
realization accept: cancel 75.89 126 7589
payment from customer: creation 62.10 119 6210
payment from customer: removal 6.52 73 652
payment to supplier: creation 51.50 115 5150
payment to supplier: removal 3.61 90 361
service: total inventory turnovers 4.92 1186 492
service: total monetary turnovers 6.40 31 640
service: aggregate perf. data 0.86 20804 86
service: refresh index statistics 0.03 263034 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-02-2024 16:10:40 to 23-02-2024 16:10:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6852
TEST_TIME 2 6746
TEST_TIME 3 6319
TEST_TIME 4 5941
TEST_TIME 5 5856
TEST_TIME 6 5774
TEST_TIME 7 5449
TEST_TIME 8 5394
TEST_TIME 9 5216
TEST_TIME 10 5842
TEST_TIME 11 5774
TEST_TIME 12 5882
TEST_TIME 13 5851
TEST_TIME 14 6097
TEST_TIME 15 6271
TEST_TIME 16 7124
TEST_TIME 17 7383
TEST_TIME 18 7742
TEST_TIME 19 7795
TEST_TIME 20 7938
TEST_TIME 21 8043
TEST_TIME 22 8047
TEST_TIME 23 8235
TEST_TIME 24 8203
TEST_TIME 25 8510
TEST_TIME 26 9247
TEST_TIME 27 9996
TEST_TIME 28 9701
TEST_TIME 29 9888
TEST_TIME 30 9659
TEST_TIME 31 9610
TEST_TIME 32 9635
TEST_TIME 33 9521
TEST_TIME 34 9422
TEST_TIME 35 9290
TEST_TIME 36 9413
TEST_TIME 37 9281
TEST_TIME 38 9290
TEST_TIME 39 9284
TEST_TIME 40 9124
TEST_TIME 41 9191
TEST_TIME 42 9002
TEST_TIME 43 9012
TEST_TIME 44 9111
TEST_TIME 45 9077
TEST_TIME 46 9058
TEST_TIME 47 9046
TEST_TIME 48 9106
TEST_TIME 49 9092
TEST_TIME 50 9116
TEST_TIME 51 9145
TEST_TIME 52 9225
TEST_TIME 53 9185
TEST_TIME 54 9209
TEST_TIME 55 9244
TEST_TIME 56 9253
TEST_TIME 57 9264
TEST_TIME 58 9301
TEST_TIME 59 9435
TEST_TIME 60 9441
TEST_TIME 61 9300
TEST_TIME 62 9373
TEST_TIME 63 9291
TEST_TIME 64 9319
TEST_TIME 65 9268
TEST_TIME 66 9212
TEST_TIME 67 9152
TEST_TIME 68 9056
TEST_TIME 69 9098
TEST_TIME 70 9080
TEST_TIME 71 9084
TEST_TIME 72 9131
TEST_TIME 73 9140
TEST_TIME 74 9170
TEST_TIME 75 9268
TEST_TIME 76 9211
TEST_TIME 77 9329
TEST_TIME 78 9465
TEST_TIME 79 9445
TEST_TIME 80 9401
TEST_TIME 81 9476
TEST_TIME 82 9548
TEST_TIME 83 9507
TEST_TIME 84 9414
TEST_TIME 85 9412
TEST_TIME 86 9390
TEST_TIME 87 9371
TEST_TIME 88 9342
TEST_TIME 89 9309
TEST_TIME 90 9306
TEST_TIME 91 9264
TEST_TIME 92 9250
TEST_TIME 93 9217
TEST_TIME 94 9250
TEST_TIME 95 9262
TEST_TIME 96 9238
TEST_TIME 97 9300
TEST_TIME 98 9301
TEST_TIME 99 9311
TEST_TIME 100 9289

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-02-2024 16:10:43 to 23-02-2024 16:10:47.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1307732 1307732 0 0.00 0 18558 6 0 0
doc_list_biud 1307727 1307727 0 0.00 0 64606 27 0 0
sp_add_invoice_to_stock 4360 4247 113 2.59 41 170154 20073 0 113
sp_cancel_adding_invoice 4424 4424 0 0.00 4 102894 880 0 0
sp_cancel_client_order 1524 1524 0 0.00 5 16810 388 0 0
sp_cancel_customer_reserve 439490 439490 0 0.00 0 59464 64 0 0
sp_cancel_pay_from_customer 652 652 0 0.00 3 3381 73 0 0
sp_cancel_pay_to_supplier 361 361 0 0.00 3 4639 91 0 0
sp_cancel_supplier_invoice 4910 4896 14 0.28 2 64707 856 0 14
sp_cancel_supplier_order 359 359 0 0.00 10 845478 98802 0 0
sp_cancel_write_off 7589 7589 0 0.00 1 11800 126 0 0
sp_client_order 17679 17679 0 0.00 3 16465 361 0 0
sp_customer_reserve 415951 415951 0 0.00 0 50855 189 0 0
sp_fill_shopping_cart 27192 27192 0 0.00 1 14934 35 0 0
sp_fill_shopping_cart_clo_res 415942 415942 0 0.00 0 13015 17 0 0
sp_get_clo_for_invoice 4237 4237 0 0.00 0 20821 297 0 0
sp_kill_cost_storno 13026 13026 0 0.00 0 7014 60 0 0
sp_kill_qstorno_ret_qs2qd 891824 891824 0 0.00 0 64572 35 0 0
sp_kill_qty_storno 471334 471334 0 0.00 0 64606 75 0 0
sp_lock_selected_doc 18144 18144 0 0.00 0 6763 6 0 0
sp_make_cost_storno 24415 24415 0 0.00 0 17856 56 0 0
sp_multiply_rows_for_pdistr 24411 24411 0 0.00 0 6399 29 0 0
sp_multiply_rows_for_qdistr 17679 17679 0 0.00 0 16188 183 0 0
sp_pay_from_customer 6210 6210 0 0.00 4 16814 119 0 0
sp_pay_to_supplier 5150 5150 0 0.00 5 9026 115 0 0
sp_payment_common 11358 11358 0 0.00 1 10399 28 0 0
sp_qd_handle_on_cancel_clo 1524 1524 0 0.00 0 16801 365 0 0
sp_qd_handle_on_invoice_upd_sts 8661 8661 0 0.00 0 22744 332 0 0
sp_qd_handle_on_reserve_upd_sts 8815 8815 0 0.00 0 13996 60 0 0
sp_reserve_write_off 8818 8818 0 0.00 7 14073 177 0 0
sp_supplier_invoice 4751 4751 0 0.00 5 86870 3311 0 0
sp_supplier_order 4769 4769 0 0.00 5 61863 1262 0 0
srv_aggregate_perf_data 86 86 0 0.00 1713 342166 20805 0 0
srv_fill_mon_cache_memory 59 59 0 0.00 1089 112465 35129 0 0
srv_find_qd_qs_mism 883350 883350 0 0.00 0 9192 6 0 0
srv_make_invnt_saldo 492 492 0 0.00 59 29337 1186 0 0
srv_make_money_saldo 640 640 0 0.00 0 5572 32 0 0
srv_recalc_idx_stat 3 3 0 0.00 159759 430715 263034 0 0
t$perf-abend:sp_add_invoice_to_stock 113 113 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4248 4248 0 0.00 0 8750 181 0 0
t$perf-norm:sp_cancel_adding_invoice 355 355 0 0.00 0 4185 128 0 0
t$perf-norm:sp_cancel_client_order 1524 1524 0 0.00 0 3233 13 0 0
t$perf-norm:sp_cancel_customer_reserve 598 598 0 0.00 0 1142 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 652 652 0 0.00 0 1077 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 361 361 0 0.00 0 78 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 366 366 0 0.00 0 457 12 0 0
t$perf-norm:sp_cancel_supplier_order 359 359 0 0.00 0 24201 1662 0 0
t$perf-norm:sp_cancel_write_off 878 878 0 0.00 0 3181 11 0 0
t$perf-norm:sp_client_order 17679 17679 0 0.00 0 2667 13 0 0
t$perf-norm:sp_customer_reserve 908 908 0 0.00 0 2761 8 0 0
t$perf-norm:sp_pay_from_customer 6210 6210 0 0.00 0 4852 9 0 0
t$perf-norm:sp_pay_to_supplier 5150 5150 0 0.00 0 5252 8 0 0
t$perf-norm:sp_reserve_write_off 8818 8818 0 0.00 0 5499 9 0 0
t$perf-norm:sp_supplier_invoice 4751 4751 0 0.00 0 5134 19 0 0
t$perf-norm:sp_supplier_order 4769 4769 0 0.00 0 5557 17 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 720 25 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 3040 53 0 0
t$perf-norm:srv_make_invnt_saldo 492 492 0 0.00 0 696 22 0 0
t$perf-norm:srv_make_money_saldo 640 640 0 0.00 0 3845 23 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 10 5 0 0
v_add_invoice_to_stock 8698 8472 226 2.59 0 6569 19 0 226
v_all_customers 32870 32870 0 0.00 0 23 1 0 0
v_all_suppliers 27392 27392 0 0.00 0 22 1 0 0
v_all_wares 35358 35358 0 0.00 0 68 1 0 0
v_cancel_adding_invoice 710 710 0 0.00 0 489 7 0 0
v_cancel_client_order 3048 3048 0 0.00 0 2735 5 0 0
v_cancel_customer_prepayment 1304 1304 0 0.00 0 3362 8 0 0
v_cancel_customer_reserve 1196 1196 0 0.00 0 2671 6 0 0
v_cancel_payment_to_supplier 722 722 0 0.00 0 2836 9 0 0
v_cancel_supplier_invoice 760 732 28 3.68 0 1406 16 0 28
v_cancel_supplier_order 718 718 0 0.00 0 521 4 0 0
v_cancel_write_off 1756 1756 0 0.00 0 2870 15 0 0
v_max_id_clo_ord 4767 4767 0 0.00 0 4199 3 0 0
v_max_id_clo_res 908 908 0 0.00 0 3008 10 0 0
v_max_id_ord_sup 4746 4746 0 0.00 0 4630 4 0 0
v_max_non_paid_invoice 967 967 0 0.00 0 414 3 0 0
v_max_non_paid_realizn 3096 3096 0 0.00 0 4033 6 0 0
v_min_id_clo_ord 4767 4767 0 0.00 0 3685 10 0 0
v_min_id_clo_res 908 908 0 0.00 0 3841 13 0 0
v_min_id_ord_sup 4746 4746 0 0.00 0 3956 5 0 0
v_min_non_paid_invoice 5150 5150 0 0.00 0 6109 18 0 0
v_min_non_paid_realizn 6208 6208 0 0.00 0 7459 21 0 0
v_our_firm 8712 8712 0 0.00 0 17 1 0 0
v_reserve_write_off 17630 17630 0 0.00 0 3367 5 0 0
x_lock_depdocs_on_canc_invoice 8954 8954 0 0.00 0 10540 128 0 0
x_lock_depdocs_on_canc_sup_ord 359 359 0 0.00 0 2738 291 0 0
x_make_qstorno_1000_1200 4769 4769 0 0.00 1 61852 1184 0 0
x_make_qstorno_1200_2000 4751 4751 0 0.00 3 85385 3188 0 0
x_make_qstorno_2100_3300 415951 415951 0 0.00 0 42340 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-02-2024 16:10:48 to 23-02-2024 16:10:52.

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 21 8192000000 8823885024 8844128256 22962816 0.279 7 5 6 0 23235088 100800 171472
14:10:48 19270 8192000000 9921353072 10232651776 1004601152 10.923 100 92 184 0 1034078112 6151536 23325424
14:12:15 20799 8192000000 9953837808 10274627584 1032992240 11.197 100 90 178 0 1064014816 8536960 22485616
14:13:44 18936 8192000000 9986834464 10319933440 1074733168 11.597 100 86 172 0 1106777968 10105696 21939104
14:15:10 10253 8192000000 10031332400 10375966720 1112403888 11.955 100 81 162 0 1143273664 11439920 19429856
14:16:24 4852 8192000000 10065703808 10422038528 1157876752 12.383 100 75 151 0 1186511232 10968864 17665616
14:17:31 4857 8192000000 10109699712 10481672192 1210831936 12.877 100 74 143 0 1237624768 11327616 15465216
14:18:39 1402 8192000000 10159127936 10530131968 1248883808 13.228 100 87 171 1 1280038848 12760944 18394096
14:19:44 1075 8192000000 10179781728 10558509056 1268289408 13.406 100 84 164 2 1298528368 11193344 19045616
14:20:45 803 8192000000 10214804800 10599571456 1300702848 13.702 100 79 158 1 1332194240 13600528 17890864
14:21:48 3967 8192000000 10211012656 10612801536 1313100704 13.814 100 42 80 0 1336205936 13780384 9324848
14:22:53 3136 8192000000 10209723760 10621530112 1320898704 13.885 100 39 78 1 1338237680 8773520 8565456
14:24:01 69008 8192000000 10225523184 10642206720 1331509536 13.981 100 32 64 2 1344452096 5437024 7505536
14:26:13 6911 8192000000 10230367088 10653356032 1340093056 14.058 100 19 37 2 1349886448 5094064 4699328
14:27:23 6712 8192000000 10236886416 10661683200 1346300768 14.114 100 21 41 0 1356692880 5898688 4493424
14:28:32 52318 8192000000 10217778928 10642386944 1305332928 13.744 97 59 118 0 1325626784 7004144 13289712
14:30:37 6118 8192000000 10250226912 10650173440 1336627600 14.027 100 73 143 0 1364678192 12654768 15395824
14:31:48 9963 8192000000 10241151504 10646646784 1314184800 13.824 98 59 114 1 1339717152 12771984 12760368
14:33:04 35696 8192000000 10237219952 10647851008 1312303248 13.807 98 42 84 1 1334531440 12467680 9760512
14:34:46 20293 8192000000 10211313632 10618093568 1274171248 13.460 95 38 75 0 1295022512 11680928 9170336
14:36:13 19844 8192000000 10244800864 10651119616 1322623232 13.900 99 37 72 0 1348240752 15998176 9619344
14:37:41 21675 8192000000 10217280032 10619764736 1268482496 13.408 96 40 79 0 1299839248 21188800 10167952
14:39:11 10329 8192000000 10246029280 10655674368 1329293952 13.961 100 34 68 0 1361218384 23104832 8819600
14:40:23 3133 8192000000 10268935824 10667847680 1339192720 14.050 100 60 119 0 1376661088 23497584 13970784
14:41:32 7475 8192000000 10256711664 10657501184 1329230416 13.960 100 55 109 0 1367016480 25204688 12581376
14:42:46 6566 8192000000 10274532944 10678145024 1339018784 14.049 100 59 115 0 1386405888 31841040 15546064
14:44:00 1598 8192000000 10277935104 10672082944 1326600800 13.936 99 75 146 0 1381104464 36585168 17918496
14:45:08 1360 8192000000 10309047568 10707595264 1349358240 14.142 100 78 154 0 1414249904 45681504 19210160
14:46:14 1086 8192000000 10313525728 10714456064 1359498464 14.233 100 88 169 1 1417729952 37370896 20860592
14:47:20 3873 8192000000 10325931472 10741420032 1376351136 14.384 100 64 128 1 1430546048 38284896 15910016
14:48:31 5401 8192000000 10328645904 10745335808 1382691824 14.441 100 60 116 2 1434270320 36776272 14802224
14:49:47 20448 8192000000 10329603888 10761486336 1395433872 14.554 100 39 77 1 1442125056 36611936 10079248
14:51:10 12483 8192000000 10337275584 10769924096 1402265280 14.615 100 35 72 2 1444372224 33143312 8963632
14:52:55 16503 8192000000 10338969008 10776842240 1400142144 14.596 100 27 54 0 1448308384 40601392 7564848
14:54:41 19400 8192000000 10331996992 10768855040 1376663552 14.387 99 21 42 0 1429838368 46742592 6432224
14:56:03 31469 8192000000 10323893072 10766725120 1377411984 14.393 99 26 52 1 1421995232 38303024 6280224
14:57:37 47944 8192000000 10308407488 10748379136 1386668288 14.476 100 36 72 0 1409006848 13948592 8389968
14:59:33 1486 8192000000 10324089408 10751889408 1393600192 14.538 100 82 167 1 1423461520 9419712 20441616
15:00:43 36352 8192000000 10317130432 10760896512 1403492480 14.626 100 38 76 0 1426520640 14540384 8487776
15:02:21 47470 8192000000 10303320304 10762100736 1406629728 14.654 100 12 24 0 1418659792 9176176 2853888
15:04:10 28858 8192000000 10306111728 10760093696 1388202544 14.490 98 14 29 0 1404513456 12635792 3675120
15:06:01 32519 8192000000 10307616000 10768990208 1395531360 14.555 99 11 22 0 1415031760 16706144 2794256
15:07:44 42873 8192000000 10310180336 10773901312 1408150432 14.668 100 7 14 0 1425313808 15027808 2135568
15:09:28 99930 8192000000 10299105552 10764570624 1402550464 14.618 99 25 49 1 1414529328 6566480 5412384
15:12:13 13065 8192000000 10307783824 10759122944 1405097472 14.640 100 42 83 0 1426084384 11849568 9137344
15:13:28 54284 8192000000 10289913376 10756292608 1389265936 14.499 99 11 22 0 1402965792 11172384 2527472
15:15:23 32513 8192000000 10270727120 10727014400 1333866768 14.002 95 18 36 2 1344197360 6520560 3810032
15:17:03 51010 8192000000 10272754400 10730086400 1351096912 14.157 98 36 72 2 1368379568 9219920 8062736
15:19:01 38338 8192000000 10274914048 10721165312 1337704608 14.037 97 43 87 1 1358233536 11144480 9384448
15:20:43 92083 8192000000 10271193312 10721415168 1316169792 13.842 96 9 18 0 1327751328 9493728 2087808
15:23:16 22934 8192000000 10270876688 10700951552 1297852672 13.676 95 30 58 0 1312129888 7360624 6916592
15:24:42 34065 8192000000 10258879120 10698100736 1283673888 13.547 94 24 47 0 1297168560 8805424 4689248
15:26:17 67303 8192000000 10272263536 10723049472 1340910544 14.066 98 14 28 0 1360546528 16277312 3358672
15:28:34 39575 8192000000 10252179360 10688847872 1281474432 13.526 95 11 22 0 1301012336 17157808 2380096
15:30:18 50339 8192000000 10250864112 10681761792 1328932176 13.958 99 39 75 2 1345312032 8305408 8074448
15:32:34 48519 8192000000 10245232560 10687270912 1339438688 14.052 99 14 27 0 1355593104 13109712 3044704
15:34:30 37982 8192000000 10237839552 10685104128 1326199728 13.933 98 14 28 0 1336981312 7298992 3482592
15:36:26 48508 8192000000 10249963520 10697273344 1355418864 14.196 100 8 16 0 1366902896 9789840 1694192
15:38:19 48992 8192000000 10251165664 10712276992 1353626848 14.180 100 19 38 0 1372744576 14556416 4561312
15:40:14 50011 8192000000 10260336736 10711252992 1342880880 14.083 98 25 50 0 1356003680 8121200 5001600
15:42:06 29351 8192000000 10303917648 10744229888 1389371808 14.500 100 31 60 1 1406241312 9470304 7399200
15:43:36 39476 8192000000 10299359616 10759069696 1381352992 14.429 99 37 74 1 1404781648 15258400 8170256
15:45:23 48282 8192000000 10325113824 10768953344 1392773456 14.531 99 25 50 0 1413900448 15276480 5850512
15:47:19 112458 8192000000 10317544400 10756694016 1396952192 14.568 100 12 24 1 1427200656 27538048 2710416
15:50:12 65588 8192000000 10337000192 10803564544 1420661776 14.779 100 19 37 0 1447275264 22786240 3827248
15:52:18 25573 8192000000 10342547536 10782740480 1405698848 14.646 99 36 73 1 1421966176 7481232 8786096
15:53:44 60044 8192000000 10333474448 10790727680 1427734128 14.841 100 40 79 1 1448636992 11637568 9265296
15:55:53 46504 8192000000 10326141088 10796146688 1413811008 14.718 99 14 26 1 1432122752 15434560 2877184
15:57:46 43266 8192000000 10310546672 10777993216 1415958256 14.737 100 10 19 0 1429041568 11217760 1865552
15:59:29 41190 8192000000 10304392912 10779443200 1405984976 14.648 99 8 16 0 1416045072 8434128 1625968
16:01:15 63731 8192000000 10302156576 10776424448 1401765072 14.611 99 11 22 0 1412917680 8848704 2303904
16:03:20 43570 8192000000 10296010544 10759143424 1380108080 14.418 98 10 20 0 1393335600 10871552 2355968
16:05:06 40788 8192000000 10300744016 10750713856 1377695520 14.396 99 23 46 0 1396308512 13486416 5126576
16:06:52 56016 8192000000 10274459232 10728157184 1296011168 13.659 93 14 27 0 1312180896 12977984 3191744
16:08:59 34955 8192000000 10276422496 10720886784 1329454848 13.962 97 25 50 0 1346805440 12070320 5280272

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 23-02-2024 16:10:54 to 23-02-2024 16:11:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 113 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          177569
MON$OLDEST_ACTIVE               179024
MON$OLDEST_SNAPSHOT             179024
MON$NEXT_TRANSACTION            179024
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                       1898080
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.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 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 Fri Feb 23 16:11:12 2024 
 
Database header page information: 
    Flags            0 
    Generation        93170 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    177569 
    Oldest active        179024 
    Oldest snapshot        179024 
    Next transaction    179025 
    Sequence number        0 
    Next attachment ID    720 
    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.24, total records: 7789431 
    Average version length: 48.16, total versions: 106709, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86680 
    Data pages: 86680, average fill: 72% 
    Primary pages: 86680, secondary pages: 0, swept pages: 14385 
    Empty pages: 2, full pages: 73130 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 206 
    40 - 59% = 2124 
    60 - 79% = 84289 
    80 - 99% = 27 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23361, nodes: 7789431 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1726041, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 360 
        20 - 39% = 1599 
        40 - 59% = 4298 
        60 - 79% = 2429 
        80 - 99% = 14675 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13575, nodes: 7789431 
    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: 1548099, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1498 
        40 - 59% = 2135 
        60 - 79% = 1152 
        80 - 99% = 8790 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8373, nodes: 7789431 
    Average node length: 6.62, total dup: 5815006, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1541280, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 867 
        40 - 59% = 1475 
        60 - 79% = 941 
        80 - 99% = 4954 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.13, total records: 2264895 
    Average version length: 34.69, total versions: 103676, max versions: 3 
    Average fragment length: 8.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28312 
    Data pages: 28312, average fill: 74% 
    Primary pages: 28305, secondary pages: 7, swept pages: 8869 
    Empty pages: 7, full pages: 23246 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 154 
    40 - 59% = 1331 
    60 - 79% = 25793 
    80 - 99% = 1010 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4591, nodes: 2264895 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 704281, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 864 
        40 - 59% = 926 
        60 - 79% = 735 
        80 - 99% = 2066 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2523, nodes: 2267791 
    Average node length: 4.97, total dup: 2266892, max dup: 18639 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1250900, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 238 
        40 - 59% = 1536 
        60 - 79% = 548 
        80 - 99% = 199 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2008, nodes: 2264895 
    Average node length: 4.97, total dup: 2264845, max dup: 130294 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061589, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 61 
        40 - 59% = 1029 
        60 - 79% = 65 
        80 - 99% = 847 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4357, nodes: 2264895 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 704281, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 514 
        40 - 59% = 680 
        60 - 79% = 820 
        80 - 99% = 2243 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.21, total records: 400 
    Average version length: 22.84, total versions: 238663, max versions: 623 
    Average fragment length: 2.00, total fragments: 61, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1400 
    Data pages: 1320, average fill: 90% 
    Primary pages: 7, secondary pages: 1313, swept pages: 0 
    Empty pages: 0, full pages: 1319 
    Fill distribution: 
     0 - 19% = 0 
    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: 4.23, total records: 55638 
    Average version length: 68.28, total versions: 52191, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 20.81 
    Pointer pages: 7, data page slots: 1480 
    Data pages: 1136, average fill: 62% 
    Primary pages: 1135, secondary pages: 1, swept pages: 0 
    Empty pages: 125, full pages: 563 
    Fill distribution: 
     0 - 19% = 189 
    20 - 39% = 97 
    40 - 59% = 160 
    60 - 79% = 212 
    80 - 99% = 478 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704363, depth: 3, leaf buckets: 209, nodes: 55638 
    Average node length: 13.29, total dup: 3335, max dup: 2 
    Average key length: 10.88, compression ratio: 2.48 
    Average prefix length: 19.06, average data length: 7.94 
    Clustering factor: 42274, ratio: 0.76 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 78 
        40 - 59% = 107 
        60 - 79% = 24 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 17496, max versions: 932 
    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: 88% 
    Primary pages: 3, secondary pages: 61, swept pages: 0 
    Empty pages: 2, full pages: 61 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 60 
 
    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.40, total records: 1154 
    Average version length: 43.20, total versions: 1066, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 17.08 
    Pointer pages: 1, data page slots: 32 
    Data pages: 28, average fill: 41% 
    Primary pages: 27, secondary pages: 1, swept pages: 2 
    Empty pages: 7, full pages: 6 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91578, depth: 2, leaf buckets: 2, nodes: 1154 
    Average node length: 4.60, total dup: 1056, max dup: 114 
    Average key length: 2.90, compression ratio: 6.56 
    Average prefix length: 18.19, average data length: 0.81 
    Clustering factor: 657, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        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.99, 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.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 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.92, total records: 796718 
    Average version length: 25.34, total versions: 75028, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 8096 
    Data pages: 8088, average fill: 69% 
    Primary pages: 8058, secondary pages: 30, swept pages: 1283 
    Empty pages: 79, full pages: 6846 
    Fill distribution: 
     0 - 19% = 159 
    20 - 39% = 171 
    40 - 59% = 266 
    60 - 79% = 7213 
    80 - 99% = 279 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 890, nodes: 796718 
    Average node length: 4.87, total dup: 796669, max dup: 145609 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87915, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 147 
        40 - 59% = 503 
        60 - 79% = 175 
        80 - 99% = 65 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 934, nodes: 796718 
    Average node length: 5.88, total dup: 709155, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158521, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 82 
        40 - 59% = 438 
        60 - 79% = 127 
        80 - 99% = 285 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 977, nodes: 796718 
    Average node length: 5.88, total dup: 709155, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160543, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 195 
        40 - 59% = 390 
        60 - 79% = 98 
        80 - 99% = 294 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1143, nodes: 796718 
    Average node length: 5.96, total dup: 709155, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153506, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 273 
        40 - 59% = 587 
        60 - 79% = 182 
        80 - 99% = 98 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.87, total records: 5507 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.64, total fragments: 56, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 77, secondary pages: 19, swept pages: 53 
    Empty pages: 13, full pages: 64 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5507 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.11 
    Average prefix length: 34.53, average data length: 1.54 
    Clustering factor: 5253, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5507 
    Average node length: 11.12, 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: 152, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        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.17, total records: 81276 
    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: 792 
    Data pages: 792, average fill: 71% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 784 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 784 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35439, depth: 2, leaf buckets: 104, nodes: 81276 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3107, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.10, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 143.25, total records: 171738 
    Average version length: 153.45, total versions: 8652, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.84 
    Pointer pages: 8, data page slots: 4608 
    Data pages: 4128, average fill: 86% 
    Primary pages: 4128, secondary pages: 0, swept pages: 2 
    Empty pages: 51, full pages: 4061 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 4060 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 144.37, total records: 167827 
    Average version length: 152.88, total versions: 7206, 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: 6040 
    Data pages: 4056, average fill: 85% 
    Primary pages: 4055, secondary pages: 1, swept pages: 9 
    Empty pages: 68, full pages: 3958 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 9 
    40 - 59% = 12 
    60 - 79% = 10 
    80 - 99% = 3956 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.16, total records: 171612 
    Average version length: 151.93, total versions: 5446, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 6, data page slots: 5944 
    Data pages: 4160, average fill: 85% 
    Primary pages: 4159, secondary pages: 1, swept pages: 1 
    Empty pages: 85, full pages: 4055 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 4056 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.61, total records: 180547 
    Average version length: 153.10, total versions: 4298, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 7, data page slots: 5616 
    Data pages: 4352, average fill: 86% 
    Primary pages: 4351, secondary pages: 1, swept pages: 1 
    Empty pages: 56, full pages: 4273 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 10 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 4273 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 145.83, total records: 166245 
    Average version length: 153.03, total versions: 5845, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 5, data page slots: 4832 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4007, secondary pages: 1, swept pages: 4 
    Empty pages: 56, full pages: 3931 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 12 
    80 - 99% = 3930 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 142.31, total records: 159160 
    Average version length: 153.06, total versions: 8679, 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: 6008 
    Data pages: 3784, average fill: 87% 
    Primary pages: 3783, secondary pages: 1, swept pages: 5 
    Empty pages: 14, full pages: 3756 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 2 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 3754 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 123.17, total records: 192706 
    Average version length: 154.83, total versions: 35360, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.77 
    Pointer pages: 7, data page slots: 6016 
    Data pages: 4704, average fill: 86% 
    Primary pages: 4704, secondary pages: 0, swept pages: 4 
    Empty pages: 96, full pages: 4564 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 10 
    40 - 59% = 21 
    60 - 79% = 14 
    80 - 99% = 4558 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 142.62, total records: 165627 
    Average version length: 153.78, total versions: 9140, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 8, data page slots: 6032 
    Data pages: 4056, average fill: 85% 
    Primary pages: 4056, secondary pages: 0, swept pages: 1 
    Empty pages: 77, full pages: 3871 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 12 
    40 - 59% = 75 
    60 - 79% = 18 
    80 - 99% = 3871 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 145.48, total records: 188796 
    Average version length: 152.94, total versions: 7343, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 6, data page slots: 4832 
    Data pages: 4528, average fill: 86% 
    Primary pages: 4528, secondary pages: 0, swept pages: 3 
    Empty pages: 39, full pages: 4475 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4475 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 141.83, total records: 170815 
    Average version length: 153.73, total versions: 10330, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.96 
    Pointer pages: 7, data page slots: 5504 
    Data pages: 4128, average fill: 86% 
    Primary pages: 4128, secondary pages: 0, swept pages: 4 
    Empty pages: 68, full pages: 4043 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 4040 
 
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.53, total records: 2131035 
    Average version length: 52.92, total versions: 49497, 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: 25544 
    Data pages: 25544, average fill: 72% 
    Primary pages: 25544, secondary pages: 0, swept pages: 9330 
    Empty pages: 214, full pages: 22002 
    Fill distribution: 
     0 - 19% = 437 
    20 - 39% = 369 
    40 - 59% = 848 
    60 - 79% = 23461 
    80 - 99% = 429 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2597, nodes: 2131035 
    Average node length: 5.44, total dup: 1988988, max dup: 1552 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184404, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 275 
        40 - 59% = 1715 
        60 - 79% = 302 
        80 - 99% = 302 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2754, nodes: 2131035 
    Average node length: 5.69, total dup: 1913739, max dup: 72 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 380892, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 2327 
        60 - 79% = 404 
        80 - 99% = 21 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2165, nodes: 2131035 
    Average node length: 4.96, total dup: 2130935, max dup: 27833 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181673, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 175 
        40 - 59% = 1186 
        60 - 79% = 386 
        80 - 99% = 418 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 38.77, total records: 152503 
    Average version length: 69.18, total versions: 67067, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.25 
    Pointer pages: 3, data page slots: 4104 
    Data pages: 3032, average fill: 58% 
    Primary pages: 3032, secondary pages: 0, swept pages: 372 
    Empty pages: 500, full pages: 1940 
    Fill distribution: 
     0 - 19% = 745 
    20 - 39% = 150 
    40 - 59% = 81 
    60 - 79% = 868 
    80 - 99% = 1188 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 328606, depth: 3, leaf buckets: 222, nodes: 152503 
    Average node length: 6.44, total dup: 132682, max dup: 14 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 25884, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 115 
        60 - 79% = 64 
        80 - 99% = 14 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.13, total records: 7196836 
    Average version length: 68.80, total versions: 504889, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 63, data page slots: 102248 
    Data pages: 102248, average fill: 75% 
    Primary pages: 102248, secondary pages: 0, swept pages: 18890 
    Empty pages: 7, full pages: 86316 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 516 
    40 - 59% = 4818 
    60 - 79% = 87153 
    80 - 99% = 9714 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10688, nodes: 7196836 
    Average node length: 6.51, total dup: 6224041, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1603174, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 1499 
        40 - 59% = 5754 
        60 - 79% = 2757 
        80 - 99% = 663 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8524, nodes: 7196836 
    Average node length: 5.40, total dup: 6909846, max dup: 162 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1391321, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1038 
        40 - 59% = 4683 
        60 - 79% = 1571 
        80 - 99% = 1222 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8576, nodes: 7196836 
    Average node length: 5.40, total dup: 6909846, max dup: 162 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1393878, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1153 
        40 - 59% = 4574 
        60 - 79% = 1612 
        80 - 99% = 1233 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.56, total records: 12119881 
    Average version length: 68.76, total versions: 420945, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 104, data page slots: 168152 
    Data pages: 168152, average fill: 77% 
    Primary pages: 168152, secondary pages: 0, swept pages: 66719 
    Empty pages: 8, full pages: 158808 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 555 
    40 - 59% = 2899 
    60 - 79% = 155814 
    80 - 99% = 8817 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18381, nodes: 12119881 
    Average node length: 6.58, total dup: 10561459, max dup: 63 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2383039, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 2190 
        40 - 59% = 10847 
        60 - 79% = 4508 
        80 - 99% = 817 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 39.80, total records: 1861337 
    Average version length: 69.13, total versions: 789948, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.17 
    Pointer pages: 26, data page slots: 41744 
    Data pages: 29496, average fill: 73% 
    Primary pages: 29495, secondary pages: 1, swept pages: 3904 
    Empty pages: 1585, full pages: 23566 
    Fill distribution: 
     0 - 19% = 2767 
    20 - 39% = 1217 
    40 - 59% = 1125 
    60 - 79% = 11031 
    80 - 99% = 13356 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2271, nodes: 1861337 
    Average node length: 5.51, total dup: 1786140, max dup: 99 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 127669, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 292 
        40 - 59% = 1120 
        60 - 79% = 660 
        80 - 99% = 193 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.16, total records: 1086720 
    Average version length: 69.14, total versions: 486020, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.30 
    Pointer pages: 22, data page slots: 34488 
    Data pages: 26312, average fill: 48% 
    Primary pages: 26312, secondary pages: 0, swept pages: 4895 
    Empty pages: 4758, full pages: 11740 
    Fill distribution: 
     0 - 19% = 8598 
    20 - 39% = 2825 
    40 - 59% = 1682 
    60 - 79% = 5505 
    80 - 99% = 7702 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1514, nodes: 1086720 
    Average node length: 5.79, total dup: 1013964, max dup: 99 
    Average key length: 2.86, compression ratio: 14.66 
    Average prefix length: 41.20, average data length: 0.80 
    Clustering factor: 148449, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 357 
        40 - 59% = 715 
        60 - 79% = 357 
        80 - 99% = 82 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.08, total records: 9292790 
    Average version length: 68.96, total versions: 514977, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 88, data page slots: 143288 
    Data pages: 143264, average fill: 69% 
    Primary pages: 143264, secondary pages: 0, swept pages: 47061 
    Empty pages: 407, full pages: 89197 
    Fill distribution: 
     0 - 19% = 1444 
    20 - 39% = 6397 
    40 - 59% = 21817 
    60 - 79% = 103744 
    80 - 99% = 9862 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13461, nodes: 9292790 
    Average node length: 6.68, total dup: 7705555, max dup: 19 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1968404, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1274 
        40 - 59% = 6612 
        60 - 79% = 4773 
        80 - 99% = 800 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21159969 
    Average version length: 82.92, total versions: 16472, 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: 318728 
    Data pages: 318728, average fill: 81% 
    Primary pages: 318728, secondary pages: 0, swept pages: 11703 
    Empty pages: 0, full pages: 318727 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 26866 
    80 - 99% = 291862 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19260, nodes: 21159969 
    Average node length: 5.72, total dup: 20678728, max dup: 156 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281814, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 7876 
        60 - 79% = 559 
        80 - 99% = 10819 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17174, nodes: 21159969 
    Average node length: 6.31, total dup: 18595007, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914309, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 786 
        60 - 79% = 257 
        80 - 99% = 16127 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21027, nodes: 21159969 
    Average node length: 6.35, total dup: 18514565, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3576585, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 8130 
        60 - 79% = 624 
        80 - 99% = 12273 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16190, nodes: 21159969 
    Average node length: 5.56, total dup: 21159869, max dup: 228480 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943178, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 3011 
        60 - 79% = 449 
        80 - 99% = 12717 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.32, total records: 9721888 
    Average version length: 82.62, total versions: 482489, 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: 103, data page slots: 167408 
    Data pages: 167336, average fill: 72% 
    Primary pages: 167336, secondary pages: 0, swept pages: 62548 
    Empty pages: 454, full pages: 106877 
    Fill distribution: 
     0 - 19% = 1470 
    20 - 39% = 6182 
    40 - 59% = 22672 
    60 - 79% = 64492 
    80 - 99% = 72520 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11325, nodes: 9721888 
    Average node length: 5.35, total dup: 9411358, max dup: 289 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2114260, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 86 
        40 - 59% = 7999 
        60 - 79% = 3149 
        80 - 99% = 89 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13458, nodes: 9721888 
    Average node length: 6.22, total dup: 8057794, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1451116, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 3749 
        40 - 59% = 4530 
        60 - 79% = 2719 
        80 - 99% = 2333 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12648, nodes: 9721888 
    Average node length: 5.96, total dup: 8437817, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2312111, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 101 
        40 - 59% = 8979 
        60 - 79% = 3458 
        80 - 99% = 103 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10088, nodes: 9721888 
    Average node length: 5.12, total dup: 9721788, max dup: 132819 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1485919, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1197 
        40 - 59% = 5051 
        60 - 79% = 1670 
        80 - 99% = 2134 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.57, total records: 11403506 
    Average version length: 82.62, total versions: 377908, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 117, data page slots: 190560 
    Data pages: 188920, average fill: 74% 
    Primary pages: 188920, secondary pages: 0, swept pages: 63801 
    Empty pages: 2768, full pages: 148633 
    Fill distribution: 
     0 - 19% = 4450 
    20 - 39% = 6289 
    40 - 59% = 14946 
    60 - 79% = 40081 
    80 - 99% = 123154 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13100, nodes: 11403506 
    Average node length: 5.29, total dup: 11293346, max dup: 669 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2381393, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 151 
        40 - 59% = 8709 
        60 - 79% = 4087 
        80 - 99% = 152 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10520, nodes: 11403506 
    Average node length: 5.49, total dup: 10906740, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 716961, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 872 
        40 - 59% = 2619 
        60 - 79% = 1804 
        80 - 99% = 5069 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14982, nodes: 11403506 
    Average node length: 6.01, total dup: 9954443, max dup: 74 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2397950, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 210 
        40 - 59% = 10158 
        60 - 79% = 4446 
        80 - 99% = 166 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10851, nodes: 11403506 
    Average node length: 5.21, total dup: 11403406, max dup: 178742 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 705554, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 836 
        40 - 59% = 4829 
        60 - 79% = 1551 
        80 - 99% = 3544 
 
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.60, total records: 9846076 
    Average version length: 82.89, total versions: 492567, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 106, data page slots: 171664 
    Data pages: 171584, average fill: 71% 
    Primary pages: 171584, secondary pages: 0, swept pages: 66095 
    Empty pages: 628, full pages: 106690 
    Fill distribution: 
     0 - 19% = 1982 
    20 - 39% = 6947 
    40 - 59% = 24345 
    60 - 79% = 67593 
    80 - 99% = 70717 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11803, nodes: 9846076 
    Average node length: 5.16, total dup: 9817378, max dup: 2247 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1925757, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1396 
        40 - 59% = 7887 
        60 - 79% = 1850 
        80 - 99% = 627 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13604, nodes: 9846076 
    Average node length: 6.23, total dup: 8160253, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1418428, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 209 
        20 - 39% = 3730 
        40 - 59% = 4441 
        60 - 79% = 2719 
        80 - 99% = 2505 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12405, nodes: 9846076 
    Average node length: 5.42, total dup: 9407243, max dup: 101 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2061412, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1296 
        40 - 59% = 8766 
        60 - 79% = 1736 
        80 - 99% = 584 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10189, nodes: 9846076 
    Average node length: 5.13, total dup: 9845976, max dup: 134356 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1507069, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1166 
        40 - 59% = 5057 
        60 - 79% = 1717 
        80 - 99% = 2213 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.28, total records: 583378 
    Average version length: 68.77, total versions: 7682, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7984 
    Data pages: 7984, average fill: 76% 
    Primary pages: 7984, secondary pages: 0, swept pages: 3340 
    Empty pages: 7, full pages: 7344 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 10 
    40 - 59% = 69 
    60 - 79% = 7755 
    80 - 99% = 143 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37969, depth: 3, leaf buckets: 738, nodes: 583378 
    Average node length: 5.95, total dup: 496804, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101768, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 536 
        60 - 79% = 86 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 30076, depth: 3, leaf buckets: 763, nodes: 583378 
    Average node length: 6.15, total dup: 478529, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101831, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 548 
        60 - 79% = 97 
        80 - 99% = 97 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 576, nodes: 583378 
    Average node length: 4.86, total dup: 583278, max dup: 9812 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90251, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 20 
        40 - 59% = 351 
        60 - 79% = 84 
        80 - 99% = 120 
 
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 Fri Feb 23 16:11:36 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7789431 106709 1 0.0000 0.0000
DOC_LIST 2264895 103676 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 238663 623 59600.0000 0.0000
INVNT_TURNOVER_LOG 55638 52191 1 0.0000 0.0000
MONEY_SALDO 49 17496 932 35700.0000 0.0000
MONEY_TURNOVER_LOG 1154 1066 1 0.0000 0.0000
PDISTR 796718 75028 5 0.0000 0.0000
PERF_SPLIT_0 171738 8652 1 0.0000 0.0000
PERF_SPLIT_1 167827 7206 1 0.0000 0.0000
PERF_SPLIT_2 171612 5446 1 0.0000 0.0000
PERF_SPLIT_3 180547 4298 1 0.0000 0.0000
PERF_SPLIT_4 166245 5845 1 0.0000 0.0000
PERF_SPLIT_5 159160 8679 1 0.0000 0.0000
PERF_SPLIT_6 192706 35360 1 0.0000 0.0000
PERF_SPLIT_7 165627 9140 1 0.0000 0.0000
PERF_SPLIT_8 188796 7343 1 0.0000 0.0000
PERF_SPLIT_9 170815 10330 1 0.0000 0.0000
PSTORNED 2131035 49497 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 152503 67067 1 0.0000 0.0000
XQD_1000_3300 7196836 504889 1 0.0000 0.0000
XQD_1200_2000 12119881 420945 1 0.0000 0.0000
XQD_2000_3300 1861337 789948 1 0.0000 0.0000
XQD_2100_3300 1086720 486020 1 0.0000 0.0000
XQD_3300_3400 9292790 514977 1 0.0000 0.0000
XQS_1000_1200 21159969 16472 1 0.0000 0.0000
XQS_1000_3300 9721888 482489 1 0.0000 0.0000
XQS_1200_2000 11403506 377908 1 0.0000 0.0000
XQS_2100_3300 9846076 492567 1 0.0000 0.0000
XQS_3300_3400 583378 7682 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 ---
:1032: 
:1033: mscs-test-161.budzdorov.ru    Fri Feb 23 16:09:50 2024
:1034:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1035: 
:1036: 
:1037: mscs-test-161.budzdorov.ru    Fri Feb 23 16:09:51 2024
:1038:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1039: 
--- end of diff output ---

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

23.02.24 16:11:47. 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-02-23 16:11:50 No severe PSQL-related problems occured
23.02.24 16:11:51. End of report.