Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.02.2024 19: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 15856328 kB
MemAvailable 30266228 kB
Buffers 0 kB
Cached 15879908 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 19:09:39
DTS_END                         2024-02-23 19:09:39.3680
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(131:22) ==> SP_CANCEL_ADDING_INVOICE(33:5) ==> SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37174
TRN_ID                          171668
ATT_ID                          519
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: 9155.81 20746 915581
customer order: creation 174.40 356 17440
customer order: refuse 14.85 351 1485
order to supplier: creation 45.61 1276 4561
order to supplier: removal 3.31 118171 331
invoice (draft): creation 45.29 3097 4529
invoice (draft): removal 48.38 857 4838
invoice accept: apply 42.27 21216 4227
invoice accept: cancel 44.28 882 4428
customer reserve: creation 4020.79 205 402079
customer reserve: removal 4422.14 70 442214
realization accept: apply 84.05 230 8405
realization accept: cancel 78.39 122 7839
payment from customer: creation 59.94 153 5994
payment from customer: removal 6.08 81 608
payment to supplier: creation 49.71 176 4971
payment to supplier: removal 3.69 107 369
service: total inventory turnovers 4.97 964 497
service: total monetary turnovers 6.74 29 674
service: aggregate perf. data 0.89 19011 89
service: refresh index statistics 0.03 247558 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 23-02-2024 19:10:58 to 23-02-2024 19:11:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3442
TEST_TIME 2 3659
TEST_TIME 3 3502
TEST_TIME 4 2991
TEST_TIME 5 4072
TEST_TIME 6 4621
TEST_TIME 7 5567
TEST_TIME 8 5564
TEST_TIME 9 5666
TEST_TIME 10 6422
TEST_TIME 11 6192
TEST_TIME 12 6253
TEST_TIME 13 6179
TEST_TIME 14 6213
TEST_TIME 15 6137
TEST_TIME 16 6378
TEST_TIME 17 6500
TEST_TIME 18 6824
TEST_TIME 19 6976
TEST_TIME 20 7299
TEST_TIME 21 7561
TEST_TIME 22 7588
TEST_TIME 23 7342
TEST_TIME 24 7490
TEST_TIME 25 7435
TEST_TIME 26 7438
TEST_TIME 27 7526
TEST_TIME 28 7496
TEST_TIME 29 8124
TEST_TIME 30 9014
TEST_TIME 31 9281
TEST_TIME 32 9297
TEST_TIME 33 9465
TEST_TIME 34 9439
TEST_TIME 35 9284
TEST_TIME 36 9237
TEST_TIME 37 9100
TEST_TIME 38 9101
TEST_TIME 39 9096
TEST_TIME 40 8991
TEST_TIME 41 9032
TEST_TIME 42 8973
TEST_TIME 43 8984
TEST_TIME 44 8960
TEST_TIME 45 8874
TEST_TIME 46 8814
TEST_TIME 47 9082
TEST_TIME 48 9005
TEST_TIME 49 9202
TEST_TIME 50 9228
TEST_TIME 51 9162
TEST_TIME 52 9192
TEST_TIME 53 9206
TEST_TIME 54 9196
TEST_TIME 55 9258
TEST_TIME 56 9309
TEST_TIME 57 9306
TEST_TIME 58 9390
TEST_TIME 59 9377
TEST_TIME 60 9451
TEST_TIME 61 9336
TEST_TIME 62 9242
TEST_TIME 63 9228
TEST_TIME 64 9235
TEST_TIME 65 9197
TEST_TIME 66 9241
TEST_TIME 67 9169
TEST_TIME 68 9116
TEST_TIME 69 9050
TEST_TIME 70 9038
TEST_TIME 71 9044
TEST_TIME 72 9055
TEST_TIME 73 9105
TEST_TIME 74 9118
TEST_TIME 75 9133
TEST_TIME 76 9136
TEST_TIME 77 9261
TEST_TIME 78 9268
TEST_TIME 79 9237
TEST_TIME 80 9426
TEST_TIME 81 9394
TEST_TIME 82 9457
TEST_TIME 83 9456
TEST_TIME 84 9439
TEST_TIME 85 9437
TEST_TIME 86 9338
TEST_TIME 87 9323
TEST_TIME 88 9333
TEST_TIME 89 9281
TEST_TIME 90 9231
TEST_TIME 91 9257
TEST_TIME 92 9226
TEST_TIME 93 9167
TEST_TIME 94 9118
TEST_TIME 95 9106
TEST_TIME 96 9127
TEST_TIME 97 9199
TEST_TIME 98 9159
TEST_TIME 99 9179
TEST_TIME 100 9159

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-02-2024 19:11:02 to 23-02-2024 19:11:05.

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 1284438 1284438 0 0.00 0 28670 8 0 0
doc_list_biud 1284436 1284436 0 0.00 0 28266 30 0 0
sp_add_invoice_to_stock 4359 4227 132 3.02 52 217907 21217 0 132
sp_cancel_adding_invoice 4428 4428 0 0.00 5 55577 883 0 0
sp_cancel_client_order 1485 1485 0 0.00 4 8447 352 0 0
sp_cancel_customer_reserve 442214 442214 0 0.00 0 28269 71 0 0
sp_cancel_pay_from_customer 608 608 0 0.00 3 4824 81 0 0
sp_cancel_pay_to_supplier 369 369 0 0.00 3 10541 107 0 0
sp_cancel_supplier_invoice 4846 4838 8 0.16 2 19620 858 0 8
sp_cancel_supplier_order 331 331 0 0.00 10 911259 118171 0 0
sp_cancel_write_off 7839 7839 0 0.00 1 11492 123 0 0
sp_client_order 17440 17440 0 0.00 3 23228 357 0 0
sp_customer_reserve 402079 402079 0 0.00 0 52369 206 0 0
sp_fill_shopping_cart 26524 26524 0 0.00 1 12524 34 0 0
sp_fill_shopping_cart_clo_res 402077 402077 0 0.00 0 12392 16 0 0
sp_get_clo_for_invoice 4225 4225 0 0.00 0 24052 283 0 0
sp_kill_cost_storno 13244 13244 0 0.00 0 10522 65 0 0
sp_kill_qstorno_ret_qs2qd 897436 897436 0 0.00 0 28262 38 0 0
sp_kill_qty_storno 473764 473764 0 0.00 0 28266 81 0 0
sp_lock_selected_doc 17495 17495 0 0.00 0 8471 6 0 0
sp_make_cost_storno 23595 23595 0 0.00 0 28659 92 0 0
sp_multiply_rows_for_pdistr 23594 23594 0 0.00 0 12561 37 0 0
sp_multiply_rows_for_qdistr 17440 17440 0 0.00 0 11466 158 0 0
sp_pay_from_customer 5994 5994 0 0.00 4 21432 154 0 0
sp_pay_to_supplier 4971 4971 0 0.00 5 23070 176 0 0
sp_payment_common 10964 10964 0 0.00 1 13481 48 0 0
sp_qd_handle_on_cancel_clo 1485 1485 0 0.00 0 8440 323 0 0
sp_qd_handle_on_invoice_upd_sts 8653 8653 0 0.00 0 14939 335 0 0
sp_qd_handle_on_reserve_upd_sts 8404 8404 0 0.00 0 12295 68 0 0
sp_reserve_write_off 8405 8405 0 0.00 5 28064 230 0 0
sp_supplier_invoice 4529 4529 0 0.00 5 83117 3098 0 0
sp_supplier_order 4561 4561 0 0.00 5 38258 1277 0 0
srv_aggregate_perf_data 89 89 0 0.00 1350 176867 19011 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 736 122428 37572 0 0
srv_find_qd_qs_mism 873132 873132 0 0.00 0 12327 6 0 0
srv_make_invnt_saldo 497 497 0 0.00 36 34357 965 0 0
srv_make_money_saldo 674 674 0 0.00 1 4199 29 0 0
srv_recalc_idx_stat 3 3 0 0.00 193662 314297 247558 0 0
t$perf-abend:sp_add_invoice_to_stock 132 132 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4228 4228 0 0.00 0 10057 188 0 0
t$perf-norm:sp_cancel_adding_invoice 323 323 0 0.00 0 2954 107 0 0
t$perf-norm:sp_cancel_client_order 1485 1485 0 0.00 0 5645 17 0 0
t$perf-norm:sp_cancel_customer_reserve 571 571 0 0.00 0 7472 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 608 608 0 0.00 0 728 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 369 369 0 0.00 0 346 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 315 315 0 0.00 0 866 17 0 0
t$perf-norm:sp_cancel_supplier_order 331 331 0 0.00 0 28091 2034 0 0
t$perf-norm:sp_cancel_write_off 864 864 0 0.00 0 3652 15 0 0
t$perf-norm:sp_client_order 17440 17440 0 0.00 0 12674 17 0 0
t$perf-norm:sp_customer_reserve 867 867 0 0.00 0 1097 6 0 0
t$perf-norm:sp_pay_from_customer 5994 5994 0 0.00 0 7056 11 0 0
t$perf-norm:sp_pay_to_supplier 4971 4971 0 0.00 0 8150 12 0 0
t$perf-norm:sp_reserve_write_off 8405 8405 0 0.00 0 6879 13 0 0
t$perf-norm:sp_supplier_invoice 4530 4530 0 0.00 0 5058 19 0 0
t$perf-norm:sp_supplier_order 4561 4561 0 0.00 0 10479 16 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 1059 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 678 13 0 0
t$perf-norm:srv_make_invnt_saldo 497 497 0 0.00 0 5563 49 0 0
t$perf-norm:srv_make_money_saldo 674 674 0 0.00 0 1068 17 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 6 0 0
v_add_invoice_to_stock 8714 8450 264 3.02 0 4433 20 0 264
v_all_customers 31878 31878 0 0.00 0 21 1 0 0
v_all_suppliers 25842 25842 0 0.00 0 20 1 0 0
v_all_wares 34874 34874 0 0.00 0 37 1 0 0
v_cancel_adding_invoice 646 646 0 0.00 0 207 5 0 0
v_cancel_client_order 2970 2970 0 0.00 0 1797 5 0 0
v_cancel_customer_prepayment 1216 1216 0 0.00 0 1177 4 0 0
v_cancel_customer_reserve 1142 1142 0 0.00 0 2023 7 0 0
v_cancel_payment_to_supplier 738 738 0 0.00 0 1540 5 0 0
v_cancel_supplier_invoice 646 630 16 2.47 0 740 16 0 16
v_cancel_supplier_order 662 662 0 0.00 0 1617 9 0 0
v_cancel_write_off 1728 1728 0 0.00 0 3969 14 0 0
v_max_id_clo_ord 4560 4560 0 0.00 0 990 2 0 0
v_max_id_clo_res 867 867 0 0.00 0 3328 16 0 0
v_max_id_ord_sup 4527 4527 0 0.00 0 7192 7 0 0
v_max_non_paid_invoice 1136 1136 0 0.00 0 524 4 0 0
v_max_non_paid_realizn 3087 3087 0 0.00 0 2032 4 0 0
v_min_id_clo_ord 4560 4560 0 0.00 0 10003 10 0 0
v_min_id_clo_res 867 867 0 0.00 0 444 3 0 0
v_min_id_ord_sup 4527 4527 0 0.00 0 8070 15 0 0
v_min_non_paid_invoice 4970 4970 0 0.00 0 12103 39 0 0
v_min_non_paid_realizn 5994 5994 0 0.00 0 13465 37 0 0
v_our_firm 8810 8810 0 0.00 0 17 1 0 0
v_reserve_write_off 16808 16808 0 0.00 0 3745 6 0 0
x_lock_depdocs_on_canc_invoice 8951 8951 0 0.00 0 12978 149 0 0
x_lock_depdocs_on_canc_sup_ord 331 331 0 0.00 0 11807 361 0 0
x_make_qstorno_1000_1200 4561 4561 0 0.00 1 38248 1196 0 0
x_make_qstorno_1200_2000 4529 4529 0 0.00 2 83108 2981 0 0
x_make_qstorno_2100_3300 402079 402079 0 0.00 0 49267 186 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 23-02-2024 19:11:06 to 23-02-2024 19:11:11.

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
17:09:43 1 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:44 34185 8192000000 9886998256 10194149376 966480512 10.552 100 92 184 0 996318640 5661120 24177008
17:12:24 22874 8192000000 9938989120 10258915328 1024436224 11.115 100 90 180 0 1055477392 7896192 23144976
17:13:49 15093 8192000000 9965259408 10294951936 1051578080 11.376 100 86 172 0 1082115424 9345424 21191920
17:15:09 11488 8192000000 10033447536 10378883072 1110078224 11.933 100 78 153 0 1137850880 9849184 17923472
17:16:25 6937 8192000000 10081647600 10440572928 1168079696 12.479 100 84 168 0 1202762496 15919936 18762864
17:17:36 3872 8192000000 10129614304 10498658304 1216036560 12.925 100 86 168 0 1247564432 13210960 18316912
17:18:44 2977 8192000000 10155342656 10532003840 1241667008 13.162 100 88 172 1 1274666832 14686480 18313344
17:19:49 2000 8192000000 10189287168 10572173312 1276557728 13.482 100 78 156 2 1305750320 12206016 16986576
17:20:54 1342 8192000000 10211845856 10596106240 1299612032 13.692 100 92 179 0 1332562432 12877360 20073040
17:21:56 10845 8192000000 10206305344 10603585536 1303268496 13.725 100 64 127 1 1325512688 7128064 15116128
17:23:09 7834 8192000000 10204737152 10615533568 1314221168 13.824 100 31 62 0 1328770672 8147680 6401824
17:24:18 6381 8192000000 10223268400 10627420160 1324000256 13.913 100 32 65 1 1336623632 5234512 7388864
17:25:26 14802 8192000000 10210283776 10631114752 1328366032 13.952 100 25 49 0 1339829504 5348928 6114544
17:26:43 3730 8192000000 10239567424 10645753856 1329507696 13.963 100 58 114 1 1348785856 6308288 12969872
17:27:47 3085 8192000000 10230172992 10651533312 1334285968 14.006 100 37 73 1 1353596032 11147376 8162688
17:28:51 8009 8192000000 10215948736 10634256384 1326481840 13.935 100 33 66 0 1339747024 5558416 7706768
17:30:11 7389 8192000000 10227176000 10641981440 1333039232 13.995 100 48 96 1 1351394624 6614016 11741376
17:31:26 41157 8192000000 10255259024 10668756992 1347483104 14.125 100 40 78 0 1364090256 7701280 8905872
17:33:31 28569 8192000000 10231090720 10637971456 1310308960 13.789 99 46 87 1 1333366752 13290688 9767104
17:35:05 10092 8192000000 10222501952 10625933312 1286128320 13.569 97 54 107 0 1308951856 10982352 11841184
17:36:21 16130 8192000000 10219775120 10627465216 1273354800 13.452 96 49 98 0 1297854992 13319712 11180480
17:37:41 8376 8192000000 10210917216 10612428800 1290971520 13.613 99 47 95 1 1315671936 13876272 10824144
17:38:55 18931 8192000000 10216426592 10619662336 1293049536 13.632 99 40 80 0 1316633104 14206528 9377040
17:40:21 34029 8192000000 10215643552 10621411328 1304705328 13.738 100 40 81 0 1325775712 11776464 9293920
17:42:00 2524 8192000000 10228112224 10629681152 1315988464 13.840 100 61 122 0 1342284720 11608752 14687504
17:43:08 4706 8192000000 10240194016 10644230144 1313616640 13.819 98 52 104 1 1342893248 16987808 12288800
17:44:18 8562 8192000000 10268343088 10673037312 1341205680 14.068 100 65 127 1 1375883936 19792480 14885776
17:45:35 2282 8192000000 10290629600 10693836800 1357408240 14.214 100 67 134 1 1397707952 24388288 15911424
17:46:44 6705 8192000000 10304183504 10705272832 1362285200 14.258 100 61 121 0 1406594608 29261984 15047424
17:47:56 2310 8192000000 10332256304 10736566272 1379481024 14.412 100 77 146 1 1435698816 37381840 18835952
17:49:02 733 8192000000 10345056480 10750255104 1391560960 14.520 100 84 163 1 1448290976 37552912 19177104
17:50:08 1598 8192000000 10349031200 10761850880 1400248736 14.597 100 63 126 2 1455781808 39465040 16068032
17:51:12 13678 8192000000 10344398032 10769948672 1404348976 14.634 100 41 80 2 1454009456 38787168 10873312
17:52:28 36407 8192000000 10354840336 10775949312 1386315056 14.473 98 47 94 0 1440905392 42445984 12144352
17:54:11 7726 8192000000 10354289120 10782793728 1409868016 14.683 100 36 71 1 1461706208 42767808 9070384
17:55:26 5986 8192000000 10353689072 10776838144 1408386672 14.670 100 48 96 0 1470027200 49262832 12377696
17:56:40 10615 8192000000 10357662496 10800328704 1412287824 14.704 100 37 74 0 1476298160 53688208 10322128
17:58:18 29173 8192000000 10335561216 10789441536 1395859536 14.558 100 24 46 0 1457071504 53910688 7301280
18:00:36 85273 8192000000 10310405504 10748432384 1371065312 14.337 99 15 31 0 1396806240 22012832 3728096
18:03:16 32923 8192000000 10293961744 10742050816 1389961936 14.506 100 17 34 0 1402390768 8678736 3750096
18:05:03 19548 8192000000 10320766128 10753994752 1397976160 14.577 100 56 112 0 1421898336 11437168 12485008
18:06:25 75780 8192000000 10318053792 10768478208 1402061088 14.613 100 43 86 0 1420816608 9268096 9487424
18:10:20 14319 8192000000 10326910912 10772811776 1403111792 14.623 99 53 106 0 1431697408 15598144 12987472
18:11:56 5379 8192000000 10344062528 10785775616 1424847264 14.816 100 52 104 0 1451286656 14243120 12196272
18:13:04 55509 8192000000 10329333392 10784948224 1406516656 14.653 99 16 32 0 1427994272 17245248 4232368
18:15:07 29144 8192000000 10318542640 10774433792 1398965088 14.586 99 26 52 0 1427122864 20841968 7315808
18:16:42 38662 8192000000 10300354512 10761142272 1383755888 14.450 99 10 20 0 1403246352 16834624 2655840
18:18:21 51207 8192000000 10298233120 10759225344 1388067840 14.489 99 26 52 0 1402921680 9048496 5805344
18:20:22 17912 8192000000 10315160528 10758701056 1386993344 14.479 99 46 93 0 1405107344 7823760 10290240
18:22:01 9315 8192000000 10254570000 10693967872 1314339888 13.825 97 36 71 0 1333427872 10743248 8344736
18:23:14 77960 8192000000 10272373168 10722439168 1292406272 13.626 94 24 48 0 1309912224 12307568 5198384
18:25:32 119504 8192000000 10252300528 10699874304 1270438016 13.426 94 13 24 1 1283248688 10424288 2386384
18:28:42 39605 8192000000 10273519008 10715676672 1349610480 14.144 100 26 52 0 1367709968 12524160 5575328
18:30:22 105435 8192000000 10255204464 10703147008 1347143424 14.122 100 33 66 1 1365710064 10271392 8295248
18:33:08 57505 8192000000 10255952544 10703867904 1331352640 13.979 98 14 28 0 1344617456 9902432 3362384
18:35:06 65954 8192000000 10240406544 10702385152 1321363936 13.889 98 7 14 0 1338329376 15291168 1674272
18:37:40 74366 8192000000 10232386400 10678837248 1318166224 13.860 98 20 40 0 1333103360 9967328 4969808
18:39:54 47066 8192000000 10245795408 10698702848 1346254400 14.114 100 4 6 0 1355352864 8736096 362368
18:41:43 72626 8192000000 10287635520 10740400128 1381752400 14.432 100 16 32 0 1399140144 13586224 3801520
18:43:55 50209 8192000000 10310486304 10757746688 1380930720 14.425 99 20 40 0 1400214032 14082864 5200448
18:45:53 44605 8192000000 10301394368 10765123584 1391385008 14.518 100 12 25 0 1410910320 16449440 3075872
18:47:38 10210 8192000000 10315292800 10747576320 1391379296 14.518 100 50 101 0 1413766336 9982464 12404576
18:48:51 63645 8192000000 10307499648 10772254720 1373443312 14.358 98 24 48 0 1400372240 21599088 5329840
18:50:55 42928 8192000000 10305674400 10762260480 1385466224 14.465 99 24 48 0 1400998816 10289488 5243104
18:52:42 39553 8192000000 10317926992 10757550080 1383545488 14.448 99 36 71 0 1400386672 8966848 7874336
18:54:23 122428 8192000000 10318480864 10767409152 1386434624 14.474 99 26 52 0 1404244080 12128128 5681328
18:57:31 32795 8192000000 10302192256 10769014784 1395232432 14.553 99 11 22 0 1410527600 12968784 2326384
18:59:05 64793 8192000000 10284109968 10750107648 1372733072 14.352 98 10 20 0 1388049424 13140784 2175568
19:01:26 45022 8192000000 10275240672 10737106944 1367760656 14.307 98 7 14 0 1375063936 5480992 1822288
19:03:27 93288 8192000000 10292718336 10759929856 1368912976 14.317 98 9 18 0 1385060016 14119872 2027168
19:06:01 50282 8192000000 10294907936 10760638464 1365585264 14.287 98 20 40 0 1383035072 12622592 4827216
19:07:51 51572 8192000000 10293576080 10745937920 1333192064 13.996 95 18 36 0 1350379216 12835296 4351856

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 19:11:13 to 23-02-2024 19:11:27.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:03, from 23-02-2024 19:11:27 to 23-02-2024 19:11:30.

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          171667
MON$OLDEST_ACTIVE               175108
MON$OLDEST_SNAPSHOT             175108
MON$NEXT_TRANSACTION            175108
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                       1900576
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 19:11:31 2024 
 
Database header page information: 
    Flags            0 
    Generation        91494 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    171667 
    Oldest active        175108 
    Oldest snapshot        175108 
    Next transaction    175109 
    Sequence number        0 
    Next attachment ID    710 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 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.43, total records: 7743250 
    Average version length: 48.16, total versions: 74112, 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: 86752 
    Data pages: 86752, average fill: 71% 
    Primary pages: 86752, secondary pages: 0, swept pages: 19102 
    Empty pages: 7, full pages: 65185 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 169 
    40 - 59% = 2868 
    60 - 79% = 83674 
    80 - 99% = 25 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23380, nodes: 7743250 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1719312, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 334 
        20 - 39% = 2075 
        40 - 59% = 4076 
        60 - 79% = 2305 
        80 - 99% = 14590 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13554, nodes: 7743250 
    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: 1541678, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1734 
        40 - 59% = 1944 
        60 - 79% = 1086 
        80 - 99% = 8790 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8376, nodes: 7743250 
    Average node length: 6.61, total dup: 5793770, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1534776, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 1102 
        40 - 59% = 1305 
        60 - 79% = 881 
        80 - 99% = 4956 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.41, total records: 2240870 
    Average version length: 34.62, total versions: 80343, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28360 
    Data pages: 28360, average fill: 73% 
    Primary pages: 28354, secondary pages: 6, swept pages: 10461 
    Empty pages: 10, full pages: 20273 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 103 
    40 - 59% = 1779 
    60 - 79% = 25875 
    80 - 99% = 582 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4564, nodes: 2240870 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 694467, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 979 
        40 - 59% = 786 
        60 - 79% = 722 
        80 - 99% = 2077 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2512, nodes: 2243187 
    Average node length: 4.97, total dup: 2242288, max dup: 21145 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1245239, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 247 
        40 - 59% = 1541 
        60 - 79% = 540 
        80 - 99% = 181 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2059, nodes: 2240870 
    Average node length: 4.97, total dup: 2240820, max dup: 130377 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056692, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 145 
        40 - 59% = 1059 
        60 - 79% = 51 
        80 - 99% = 802 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4380, nodes: 2240870 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 694467, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 661 
        40 - 59% = 593 
        60 - 79% = 796 
        80 - 99% = 2220 
 
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.46, total records: 400 
    Average version length: 22.85, total versions: 240265, max versions: 631 
    Average fragment length: 2.00, total fragments: 46, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1328, average fill: 90% 
    Primary pages: 14, secondary pages: 1314, swept pages: 0 
    Empty pages: 7, full pages: 1320 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 1318 
 
    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: 7.85, total records: 103691 
    Average version length: 68.29, total versions: 91779, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 11.21 
    Pointer pages: 6, data page slots: 2488 
    Data pages: 1816, average fill: 71% 
    Primary pages: 1815, secondary pages: 1, swept pages: 0 
    Empty pages: 127, full pages: 1245 
    Fill distribution: 
     0 - 19% = 202 
    20 - 39% = 132 
    40 - 59% = 137 
    60 - 79% = 260 
    80 - 99% = 1085 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704655, depth: 3, leaf buckets: 314, nodes: 103691 
    Average node length: 12.97, total dup: 8132, max dup: 1 
    Average key length: 10.56, compression ratio: 2.56 
    Average prefix length: 19.36, average data length: 7.64 
    Clustering factor: 72435, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 188 
        60 - 79% = 81 
        80 - 99% = 11 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 17791, max versions: 961 
    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: 89% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    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: 2.48, total records: 1683 
    Average version length: 43.34, total versions: 1590, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 23.37 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 51% 
    Primary pages: 30, secondary pages: 2, swept pages: 7 
    Empty pages: 8, full pages: 12 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90983, depth: 2, leaf buckets: 3, nodes: 1683 
    Average node length: 4.18, total dup: 1585, max dup: 205 
    Average key length: 2.63, compression ratio: 7.23 
    Average prefix length: 18.43, average data length: 0.57 
    Clustering factor: 883, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        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.96, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    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: 36.10, total records: 806766 
    Average version length: 25.54, total versions: 68468, max versions: 4 
    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: 8000 
    Data pages: 7976, average fill: 71% 
    Primary pages: 7961, secondary pages: 15, swept pages: 1369 
    Empty pages: 36, full pages: 7368 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 69 
    40 - 59% = 138 
    60 - 79% = 7401 
    80 - 99% = 288 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 889, nodes: 806766 
    Average node length: 4.87, total dup: 806717, max dup: 157576 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89632, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 116 
        40 - 59% = 501 
        60 - 79% = 224 
        80 - 99% = 46 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 907, nodes: 806766 
    Average node length: 5.88, total dup: 718222, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161488, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 84 
        40 - 59% = 380 
        60 - 79% = 96 
        80 - 99% = 346 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 960, nodes: 806766 
    Average node length: 5.88, total dup: 718222, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163395, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 187 
        40 - 59% = 353 
        60 - 79% = 79 
        80 - 99% = 341 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1141, nodes: 806766 
    Average node length: 5.96, total dup: 718222, max dup: 43 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156023, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 232 
        40 - 59% = 609 
        60 - 79% = 213 
        80 - 99% = 84 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.85, total records: 5477 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.39, total fragments: 76, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 112 
    Data pages: 103, average fill: 53% 
    Primary pages: 84, secondary pages: 19, swept pages: 54 
    Empty pages: 23, full pages: 64 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5477 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.07 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5259, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5477 
    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: 141, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 79997 
    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: 776 
    Data pages: 776, average fill: 71% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 771 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 771 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 32295, depth: 2, leaf buckets: 101, nodes: 79997 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3355, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        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.68, 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.14 
    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: 146.52, total records: 173054 
    Average version length: 152.04, total versions: 5084, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 6, data page slots: 5584 
    Data pages: 4240, average fill: 84% 
    Primary pages: 4240, secondary pages: 0, swept pages: 1 
    Empty pages: 118, full pages: 4079 
    Fill distribution: 
     0 - 19% = 124 
    20 - 39% = 12 
    40 - 59% = 10 
    60 - 79% = 14 
    80 - 99% = 4080 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 148.16, total records: 170145 
    Average version length: 150.92, total versions: 3143, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 5, data page slots: 4784 
    Data pages: 4088, average fill: 86% 
    Primary pages: 4088, secondary pages: 0, swept pages: 1 
    Empty pages: 47, full pages: 4020 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 14 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4021 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 136.10, total records: 184657 
    Average version length: 154.38, total versions: 18147, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.46 
    Pointer pages: 6, data page slots: 5560 
    Data pages: 4480, average fill: 86% 
    Primary pages: 4480, secondary pages: 0, swept pages: 2 
    Empty pages: 86, full pages: 4370 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 10 
    80 - 99% = 4370 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 144.89, total records: 177916 
    Average version length: 152.67, total versions: 7244, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 7, data page slots: 6176 
    Data pages: 4384, average fill: 84% 
    Primary pages: 4384, secondary pages: 0, swept pages: 4 
    Empty pages: 133, full pages: 4188 
    Fill distribution: 
     0 - 19% = 135 
    20 - 39% = 17 
    40 - 59% = 37 
    60 - 79% = 8 
    80 - 99% = 4187 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 130.59, total records: 181658 
    Average version length: 154.86, total versions: 24658, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.99 
    Pointer pages: 6, data page slots: 5640 
    Data pages: 4384, average fill: 87% 
    Primary pages: 4384, secondary pages: 0, swept pages: 2 
    Empty pages: 53, full pages: 4312 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4310 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 143.22, total records: 183552 
    Average version length: 153.26, total versions: 9589, 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: 4640 
    Data pages: 4432, average fill: 86% 
    Primary pages: 4432, secondary pages: 0, swept pages: 3 
    Empty pages: 65, full pages: 4343 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4343 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.29, total records: 157487 
    Average version length: 151.28, total versions: 3855, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 8, data page slots: 4776 
    Data pages: 3816, average fill: 85% 
    Primary pages: 3816, secondary pages: 0, swept pages: 1 
    Empty pages: 72, full pages: 3720 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 10 
    40 - 59% = 11 
    60 - 79% = 2 
    80 - 99% = 3720 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 147.30, total records: 179165 
    Average version length: 152.46, total versions: 4559, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 8, data page slots: 5704 
    Data pages: 4376, average fill: 85% 
    Primary pages: 4376, secondary pages: 0, swept pages: 6 
    Empty pages: 111, full pages: 4234 
    Fill distribution: 
     0 - 19% = 114 
    20 - 39% = 11 
    40 - 59% = 7 
    60 - 79% = 13 
    80 - 99% = 4231 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.09, total records: 166452 
    Average version length: 150.49, total versions: 3048, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 6, data page slots: 5144 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4008, secondary pages: 0, swept pages: 3 
    Empty pages: 57, full pages: 3933 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3933 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 148.76, total records: 168614 
    Average version length: 150.75, total versions: 2658, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 6, data page slots: 4968 
    Data pages: 4104, average fill: 85% 
    Primary pages: 4104, secondary pages: 0, swept pages: 3 
    Empty pages: 92, full pages: 3987 
    Fill distribution: 
     0 - 19% = 95 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 3987 
 
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.84, total records: 2100146 
    Average version length: 52.97, total versions: 36110, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25432 
    Data pages: 25424, average fill: 71% 
    Primary pages: 25424, secondary pages: 0, swept pages: 10848 
    Empty pages: 268, full pages: 20944 
    Fill distribution: 
     0 - 19% = 508 
    20 - 39% = 439 
    40 - 59% = 1089 
    60 - 79% = 23054 
    80 - 99% = 334 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2562, nodes: 2100146 
    Average node length: 5.44, total dup: 1959641, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183110, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 271 
        40 - 59% = 1672 
        60 - 79% = 303 
        80 - 99% = 312 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2755, nodes: 2100146 
    Average node length: 5.69, total dup: 1884617, max dup: 65 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376465, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2417 
        60 - 79% = 306 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2183, nodes: 2100146 
    Average node length: 4.96, total dup: 2100046, max dup: 28875 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180632, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 216 
        40 - 59% = 1202 
        60 - 79% = 375 
        80 - 99% = 387 
 
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: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 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.92, total records: 149495 
    Average version length: 69.17, total versions: 65436, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 3, data page slots: 3816 
    Data pages: 2904, average fill: 60% 
    Primary pages: 2904, secondary pages: 0, swept pages: 425 
    Empty pages: 485, full pages: 1949 
    Fill distribution: 
     0 - 19% = 725 
    20 - 39% = 123 
    40 - 59% = 48 
    60 - 79% = 631 
    80 - 99% = 1377 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 100245, depth: 3, leaf buckets: 224, nodes: 149495 
    Average node length: 6.43, total dup: 130062, max dup: 14 
    Average key length: 3.94, compression ratio: 10.65 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 25415, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 36 
        40 - 59% = 117 
        60 - 79% = 62 
        80 - 99% = 9 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.30, total records: 7074002 
    Average version length: 68.79, total versions: 376251, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 63, data page slots: 102296 
    Data pages: 102296, average fill: 74% 
    Primary pages: 102296, secondary pages: 0, swept pages: 25671 
    Empty pages: 11, full pages: 78225 
    Fill distribution: 
     0 - 19% = 96 
    20 - 39% = 861 
    40 - 59% = 6831 
    60 - 79% = 89006 
    80 - 99% = 5502 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10718, nodes: 7074002 
    Average node length: 6.51, total dup: 6116622, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1588232, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1565 
        40 - 59% = 6060 
        60 - 79% = 2628 
        80 - 99% = 455 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8579, nodes: 7074002 
    Average node length: 5.40, total dup: 6791849, max dup: 174 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1385344, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1269 
        40 - 59% = 4790 
        60 - 79% = 1406 
        80 - 99% = 1106 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8622, nodes: 7074002 
    Average node length: 5.40, total dup: 6791849, max dup: 174 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1387880, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1301 
        40 - 59% = 4761 
        60 - 79% = 1441 
        80 - 99% = 1113 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.10, total records: 12177336 
    Average version length: 68.72, total versions: 328395, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 104, data page slots: 169256 
    Data pages: 169256, average fill: 76% 
    Primary pages: 169256, secondary pages: 0, swept pages: 76522 
    Empty pages: 5, full pages: 158472 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 612 
    40 - 59% = 3262 
    60 - 79% = 159121 
    80 - 99% = 6202 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18414, nodes: 12177336 
    Average node length: 6.58, total dup: 10612850, max dup: 65 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2401565, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1952 
        40 - 59% = 10943 
        60 - 79% = 4773 
        80 - 99% = 715 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 43.07, total records: 1502373 
    Average version length: 69.13, total versions: 566844, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.93 
    Pointer pages: 26, data page slots: 41144 
    Data pages: 24368, average fill: 70% 
    Primary pages: 24368, secondary pages: 0, swept pages: 4534 
    Empty pages: 1838, full pages: 19174 
    Fill distribution: 
     0 - 19% = 2957 
    20 - 39% = 953 
    40 - 59% = 736 
    60 - 79% = 10199 
    80 - 99% = 9523 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 1920, nodes: 1502373 
    Average node length: 5.52, total dup: 1441514, max dup: 99 
    Average key length: 2.56, compression ratio: 16.39 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 97436, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 323 
        40 - 59% = 968 
        60 - 79% = 482 
        80 - 99% = 134 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.28, total records: 1105064 
    Average version length: 69.14, total versions: 508098, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.38 
    Pointer pages: 22, data page slots: 35448 
    Data pages: 29176, average fill: 44% 
    Primary pages: 29176, secondary pages: 0, swept pages: 7476 
    Empty pages: 7472, full pages: 12771 
    Fill distribution: 
     0 - 19% = 12148 
    20 - 39% = 2163 
    40 - 59% = 1186 
    60 - 79% = 4163 
    80 - 99% = 9516 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1530, nodes: 1105064 
    Average node length: 5.76, total dup: 1034059, max dup: 99 
    Average key length: 2.83, compression ratio: 14.82 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 144187, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 354 
        40 - 59% = 748 
        60 - 79% = 338 
        80 - 99% = 85 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.11, total records: 9141320 
    Average version length: 68.96, total versions: 370499, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 88, data page slots: 143272 
    Data pages: 143248, average fill: 68% 
    Primary pages: 143248, secondary pages: 0, swept pages: 53593 
    Empty pages: 209, full pages: 79993 
    Fill distribution: 
     0 - 19% = 983 
    20 - 39% = 7995 
    40 - 59% = 23298 
    60 - 79% = 105640 
    80 - 99% = 5332 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13493, nodes: 9141320 
    Average node length: 6.68, total dup: 7585057, max dup: 27 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1962461, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1246 
        40 - 59% = 7092 
        60 - 79% = 4637 
        80 - 99% = 517 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21159190 
    Average version length: 82.99, total versions: 11814, 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: 318984 
    Data pages: 318984, average fill: 81% 
    Primary pages: 318984, secondary pages: 0, swept pages: 12928 
    Empty pages: 44, full pages: 317929 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 47 
    40 - 59% = 128 
    60 - 79% = 27715 
    80 - 99% = 291027 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19476, nodes: 21159190 
    Average node length: 5.72, total dup: 20677959, max dup: 157 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3284102, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8309 
        60 - 79% = 556 
        80 - 99% = 10604 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17169, nodes: 21159190 
    Average node length: 6.31, total dup: 18594764, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916907, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 3 
        40 - 59% = 749 
        60 - 79% = 280 
        80 - 99% = 16133 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21224, nodes: 21159190 
    Average node length: 6.35, total dup: 18513506, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578434, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 2 
        40 - 59% = 8509 
        60 - 79% = 628 
        80 - 99% = 12081 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16100, nodes: 21159190 
    Average node length: 5.56, total dup: 21159090, max dup: 232590 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 945567, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2902 
        60 - 79% = 361 
        80 - 99% = 12828 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.13, total records: 9611556 
    Average version length: 82.63, total versions: 383246, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 106, data page slots: 171752 
    Data pages: 171736, average fill: 69% 
    Primary pages: 171736, secondary pages: 0, swept pages: 71655 
    Empty pages: 752, full pages: 96922 
    Fill distribution: 
     0 - 19% = 2201 
    20 - 39% = 9612 
    40 - 59% = 28666 
    60 - 79% = 69967 
    80 - 99% = 61290 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11366, nodes: 9611556 
    Average node length: 5.37, total dup: 9303360, max dup: 221 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2092708, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 84 
        40 - 59% = 8407 
        60 - 79% = 2796 
        80 - 99% = 73 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13555, nodes: 9611556 
    Average node length: 6.24, total dup: 7969700, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1439491, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 4099 
        40 - 59% = 4287 
        60 - 79% = 2667 
        80 - 99% = 2360 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12677, nodes: 9611556 
    Average node length: 5.99, total dup: 8336973, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2282491, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 86 
        40 - 59% = 9446 
        60 - 79% = 3052 
        80 - 99% = 91 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10091, nodes: 9611556 
    Average node length: 5.14, total dup: 9611456, max dup: 166339 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1479465, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 50 
        20 - 39% = 1297 
        40 - 59% = 4972 
        60 - 79% = 1717 
        80 - 99% = 2055 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.03, total records: 11182555 
    Average version length: 82.59, total versions: 307537, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 116, data page slots: 187904 
    Data pages: 186632, average fill: 73% 
    Primary pages: 186632, secondary pages: 0, swept pages: 67679 
    Empty pages: 2502, full pages: 142474 
    Fill distribution: 
     0 - 19% = 4344 
    20 - 39% = 6651 
    40 - 59% = 16456 
    60 - 79% = 41973 
    80 - 99% = 117208 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13113, nodes: 11182555 
    Average node length: 5.28, total dup: 11073292, max dup: 674 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2330500, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 99 
        40 - 59% = 9771 
        60 - 79% = 3126 
        80 - 99% = 115 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10315, nodes: 11182555 
    Average node length: 5.48, total dup: 10694184, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 703287, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 878 
        40 - 59% = 2491 
        60 - 79% = 1823 
        80 - 99% = 4967 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15000, nodes: 11182555 
    Average node length: 6.01, total dup: 9756460, max dup: 70 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2346906, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 138 
        40 - 59% = 11290 
        60 - 79% = 3441 
        80 - 99% = 128 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10619, nodes: 11182555 
    Average node length: 5.21, total dup: 11182455, max dup: 201949 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 692264, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 855 
        40 - 59% = 4630 
        60 - 79% = 1513 
        80 - 99% = 3522 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 79.47, total records: 9727285 
    Average version length: 82.90, total versions: 384762, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 107, data page slots: 174096 
    Data pages: 174024, average fill: 69% 
    Primary pages: 174024, secondary pages: 0, swept pages: 74028 
    Empty pages: 641, full pages: 97574 
    Fill distribution: 
     0 - 19% = 2064 
    20 - 39% = 9455 
    40 - 59% = 28765 
    60 - 79% = 73199 
    80 - 99% = 60541 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11740, nodes: 9727285 
    Average node length: 5.18, total dup: 9698473, max dup: 1514 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1912626, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1457 
        40 - 59% = 7746 
        60 - 79% = 1873 
        80 - 99% = 624 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13692, nodes: 9727285 
    Average node length: 6.25, total dup: 8065513, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1419067, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 183 
        20 - 39% = 4079 
        40 - 59% = 4300 
        60 - 79% = 2635 
        80 - 99% = 2495 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12418, nodes: 9727285 
    Average node length: 5.43, total dup: 9291487, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2045808, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1509 
        40 - 59% = 8667 
        60 - 79% = 1633 
        80 - 99% = 579 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10332, nodes: 9727285 
    Average node length: 5.15, total dup: 9727185, max dup: 168772 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1505037, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1420 
        40 - 59% = 5181 
        60 - 79% = 1680 
        80 - 99% = 2006 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.62, total records: 576406 
    Average version length: 68.72, total versions: 4704, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 7992 
    Data pages: 7992, average fill: 75% 
    Primary pages: 7992, secondary pages: 0, swept pages: 3965 
    Empty pages: 0, full pages: 6728 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 10 
    40 - 59% = 182 
    60 - 79% = 7738 
    80 - 99% = 59 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 36250, depth: 3, leaf buckets: 744, nodes: 576406 
    Average node length: 5.95, total dup: 490842, max dup: 87 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100383, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 16 
        40 - 59% = 553 
        60 - 79% = 90 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 27724, depth: 3, leaf buckets: 769, nodes: 576406 
    Average node length: 6.15, total dup: 472758, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100451, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 567 
        60 - 79% = 94 
        80 - 99% = 87 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 583, nodes: 576406 
    Average node length: 4.86, total dup: 576306, max dup: 9251 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89159, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 42 
        40 - 59% = 344 
        60 - 79% = 86 
        80 - 99% = 110 
 
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 19:11:54 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7743250 74112 1 0.0000 0.0000
DOC_LIST 2240870 80343 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 240265 631 60000.0000 0.0000
INVNT_TURNOVER_LOG 103691 91779 1 0.0000 0.0000
MONEY_SALDO 49 17791 961 36300.0000 0.0000
MONEY_TURNOVER_LOG 1683 1590 1 0.0000 0.0000
PDISTR 806766 68468 4 0.0000 0.0000
PERF_SPLIT_0 173054 5084 1 0.0000 0.0000
PERF_SPLIT_1 170145 3143 1 0.0000 0.0000
PERF_SPLIT_2 184657 18147 1 0.0000 0.0000
PERF_SPLIT_3 177916 7244 1 0.0000 0.0000
PERF_SPLIT_4 181658 24658 1 0.0000 0.0000
PERF_SPLIT_5 183552 9589 1 0.0000 0.0000
PERF_SPLIT_6 157487 3855 1 0.0000 0.0000
PERF_SPLIT_7 179165 4559 1 0.0000 0.0000
PERF_SPLIT_8 166452 3048 1 0.0000 0.0000
PERF_SPLIT_9 168614 2658 1 0.0000 0.0000
PSTORNED 2100146 36110 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 149495 65436 1 0.0000 0.0000
XQD_1000_3300 7074002 376251 1 0.0000 0.0000
XQD_1200_2000 12177336 328395 1 0.0000 0.0000
XQD_2000_3300 1502373 566844 1 0.0000 0.0000
XQD_2100_3300 1105064 508098 1 0.0000 0.0000
XQD_3300_3400 9141320 370499 1 0.0000 0.0000
XQS_1000_1200 21159190 11814 1 0.0000 0.0000
XQS_1000_3300 9611556 383246 1 0.0000 0.0000
XQS_1200_2000 11182555 307537 1 0.0000 0.0000
XQS_2100_3300 9727285 384762 1 0.0000 0.0000
XQS_3300_3400 576406 4704 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 ---
:1045: 
:1046: mscs-test-161.budzdorov.ru    Fri Feb 23 19:09:40 2024
:1047:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1048: 
:1049: 
:1050: mscs-test-161.budzdorov.ru    Fri Feb 23 19:09:48 2024
:1051:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1052: 
:1053: 
:1054: mscs-test-161.budzdorov.ru    Fri Feb 23 19:09:50 2024
:1055:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1056: 
--- end of diff output ---

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

23.02.24 19:12:06. 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 19:12:09 No severe PSQL-related problems occured
23.02.24 19:12:10. End of report.