Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.03.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 15691600 kB
MemAvailable 30231000 kB
Buffers 0 kB
Cached 16036984 kB
SwapCached 2452 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-28 19:09:42
DTS_END                         2024-03-28 19:09:42.3920
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55564
TRN_ID                          185736
ATT_ID                          535
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: 9178.12 18026 917812
customer order: creation 190.17 339 19017
customer order: refuse 15.99 374 1599
order to supplier: creation 50.06 1231 5006
order to supplier: removal 3.53 87199 353
invoice (draft): creation 50.83 2946 5083
invoice (draft): removal 47.21 771 4721
invoice accept: apply 45.27 19657 4527
invoice accept: cancel 43.11 889 4311
customer reserve: creation 4281.38 191 428138
customer reserve: removal 4136.61 58 413661
realization accept: apply 91.35 204 9135
realization accept: cancel 80.15 131 8015
payment from customer: creation 64.72 120 6472
payment from customer: removal 6.42 85 642
payment to supplier: creation 53.60 152 5360
payment to supplier: removal 4.15 65 415
service: total inventory turnovers 5.33 1060 533
service: total monetary turnovers 7.16 28 716
service: aggregate perf. data 1.05 14623 105
service: refresh index statistics 0.03 230390 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 28-03-2024 19:10:56 to 28-03-2024 19:10:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2798
TEST_TIME 2 4224
TEST_TIME 3 2908
TEST_TIME 4 3290
TEST_TIME 5 4268
TEST_TIME 6 4395
TEST_TIME 7 4306
TEST_TIME 8 4590
TEST_TIME 9 4623
TEST_TIME 10 4476
TEST_TIME 11 4712
TEST_TIME 12 4911
TEST_TIME 13 5644
TEST_TIME 14 6285
TEST_TIME 15 6261
TEST_TIME 16 6776
TEST_TIME 17 7026
TEST_TIME 18 7107
TEST_TIME 19 7333
TEST_TIME 20 7492
TEST_TIME 21 7613
TEST_TIME 22 8097
TEST_TIME 23 8206
TEST_TIME 24 8474
TEST_TIME 25 8397
TEST_TIME 26 8616
TEST_TIME 27 8739
TEST_TIME 28 9318
TEST_TIME 29 9374
TEST_TIME 30 9351
TEST_TIME 31 9212
TEST_TIME 32 9174
TEST_TIME 33 9226
TEST_TIME 34 9130
TEST_TIME 35 9352
TEST_TIME 36 9427
TEST_TIME 37 9434
TEST_TIME 38 9394
TEST_TIME 39 9283
TEST_TIME 40 9189
TEST_TIME 41 9269
TEST_TIME 42 9266
TEST_TIME 43 9132
TEST_TIME 44 9189
TEST_TIME 45 9140
TEST_TIME 46 9159
TEST_TIME 47 9170
TEST_TIME 48 9093
TEST_TIME 49 9056
TEST_TIME 50 9269
TEST_TIME 51 9198
TEST_TIME 52 9116
TEST_TIME 53 9235
TEST_TIME 54 9204
TEST_TIME 55 9079
TEST_TIME 56 9014
TEST_TIME 57 8923
TEST_TIME 58 9029
TEST_TIME 59 8984
TEST_TIME 60 8993
TEST_TIME 61 9077
TEST_TIME 62 9115
TEST_TIME 63 9152
TEST_TIME 64 9223
TEST_TIME 65 9223
TEST_TIME 66 9223
TEST_TIME 67 9205
TEST_TIME 68 9325
TEST_TIME 69 9356
TEST_TIME 70 9405
TEST_TIME 71 9395
TEST_TIME 72 9273
TEST_TIME 73 9189
TEST_TIME 74 9131
TEST_TIME 75 9090
TEST_TIME 76 9170
TEST_TIME 77 9138
TEST_TIME 78 9126
TEST_TIME 79 9109
TEST_TIME 80 9137
TEST_TIME 81 9117
TEST_TIME 82 9215
TEST_TIME 83 9204
TEST_TIME 84 9184
TEST_TIME 85 9209
TEST_TIME 86 9195
TEST_TIME 87 9264
TEST_TIME 88 9287
TEST_TIME 89 9324
TEST_TIME 90 9395
TEST_TIME 91 9314
TEST_TIME 92 9248
TEST_TIME 93 9220
TEST_TIME 94 9253
TEST_TIME 95 9207
TEST_TIME 96 9176
TEST_TIME 97 9187
TEST_TIME 98 9180
TEST_TIME 99 9205
TEST_TIME 100 9185

Performance per minute, chart


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

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 1310326 1310326 0 0.00 0 20320 7 0 0
doc_list_biud 1310325 1310325 0 0.00 0 57959 24 0 0
sp_add_invoice_to_stock 4601 4527 74 1.60 45 207737 19657 0 74
sp_cancel_adding_invoice 4311 4311 0 0.00 4 62300 890 0 0
sp_cancel_client_order 1599 1599 0 0.00 4 18037 375 0 0
sp_cancel_customer_reserve 413661 413661 0 0.00 0 24063 59 0 0
sp_cancel_pay_from_customer 642 642 0 0.00 3 8003 85 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 2 1951 66 0 0
sp_cancel_supplier_invoice 4727 4721 6 0.12 2 58002 772 0 6
sp_cancel_supplier_order 353 353 0 0.00 4 990864 87199 0 0
sp_cancel_write_off 8015 8015 0 0.00 1 11107 132 0 0
sp_client_order 19017 19017 0 0.00 3 18493 339 0 0
sp_customer_reserve 428138 428138 0 0.00 0 161155 192 0 0
sp_fill_shopping_cart 29106 29106 0 0.00 1 8322 33 0 0
sp_fill_shopping_cart_clo_res 428132 428132 0 0.00 0 25218 14 0 0
sp_get_clo_for_invoice 4520 4520 0 0.00 0 44569 295 0 0
sp_kill_cost_storno 13383 13383 0 0.00 0 18904 64 0 0
sp_kill_qstorno_ret_qs2qd 840411 840411 0 0.00 0 57958 32 0 0
sp_kill_qty_storno 446315 446315 0 0.00 0 57959 69 0 0
sp_lock_selected_doc 18945 18945 0 0.00 0 8286 5 0 0
sp_make_cost_storno 25487 25487 0 0.00 0 19410 66 0 0
sp_multiply_rows_for_pdistr 25487 25487 0 0.00 0 17431 33 0 0
sp_multiply_rows_for_qdistr 19017 19017 0 0.00 0 14847 156 0 0
sp_pay_from_customer 6472 6472 0 0.00 4 14706 120 0 0
sp_pay_to_supplier 5360 5360 0 0.00 4 19759 153 0 0
sp_payment_common 11832 11832 0 0.00 2 14700 37 0 0
sp_qd_handle_on_cancel_clo 1599 1599 0 0.00 0 15645 346 0 0
sp_qd_handle_on_invoice_upd_sts 8831 8831 0 0.00 0 27176 313 0 0
sp_qd_handle_on_reserve_upd_sts 9135 9135 0 0.00 0 25479 66 0 0
sp_reserve_write_off 9135 9135 0 0.00 6 25513 204 0 0
sp_supplier_invoice 5083 5083 0 0.00 5 96137 2946 0 0
sp_supplier_order 5006 5006 0 0.00 6 32018 1231 0 0
srv_aggregate_perf_data 105 105 0 0.00 1545 140209 14623 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1508 186853 42342 0 0
srv_find_qd_qs_mism 871878 871878 0 0.00 0 20319 7 0 0
srv_make_invnt_saldo 533 533 0 0.00 29 34543 1060 0 0
srv_make_money_saldo 716 716 0 0.00 1 1384 29 0 0
srv_recalc_idx_stat 3 3 0 0.00 187831 276756 230391 0 0
t$perf-abend:sp_add_invoice_to_stock 74 74 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4528 4528 0 0.00 0 11703 187 0 0
t$perf-norm:sp_cancel_adding_invoice 390 390 0 0.00 0 3156 81 0 0
t$perf-norm:sp_cancel_client_order 1599 1599 0 0.00 0 3620 16 0 0
t$perf-norm:sp_cancel_customer_reserve 659 659 0 0.00 0 779 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 642 642 0 0.00 0 222 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 4974 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 316 316 0 0.00 0 729 8 0 0
t$perf-norm:sp_cancel_supplier_order 353 353 0 0.00 0 15677 1427 0 0
t$perf-norm:sp_cancel_write_off 916 916 0 0.00 0 4251 14 0 0
t$perf-norm:sp_client_order 19017 19017 0 0.00 0 13063 18 0 0
t$perf-norm:sp_customer_reserve 886 886 0 0.00 0 723 5 0 0
t$perf-norm:sp_pay_from_customer 6472 6472 0 0.00 0 6248 8 0 0
t$perf-norm:sp_pay_to_supplier 5360 5360 0 0.00 0 5369 10 0 0
t$perf-norm:sp_reserve_write_off 9135 9135 0 0.00 0 4892 12 0 0
t$perf-norm:sp_supplier_invoice 5083 5083 0 0.00 0 7360 18 0 0
t$perf-norm:sp_supplier_order 5006 5006 0 0.00 0 13023 21 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 702 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 1566 32 0 0
t$perf-norm:srv_make_invnt_saldo 533 533 0 0.00 0 721 22 0 0
t$perf-norm:srv_make_money_saldo 716 716 0 0.00 0 1486 18 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 15 8 0 0
v_add_invoice_to_stock 9186 9038 148 1.61 0 9743 15 0 148
v_all_customers 34606 34606 0 0.00 0 84 1 0 0
v_all_suppliers 28334 28334 0 0.00 0 100 1 0 0
v_all_wares 38034 38034 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 780 780 0 0.00 0 85 5 0 0
v_cancel_client_order 3198 3198 0 0.00 0 2983 6 0 0
v_cancel_customer_prepayment 1284 1284 0 0.00 0 3940 9 0 0
v_cancel_customer_reserve 1318 1318 0 0.00 0 2368 10 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 1929 6 0 0
v_cancel_supplier_invoice 644 632 12 1.86 0 1932 14 0 12
v_cancel_supplier_order 706 706 0 0.00 0 2252 8 0 0
v_cancel_write_off 1832 1832 0 0.00 0 3384 18 0 0
v_max_id_clo_ord 5006 5006 0 0.00 0 8311 6 0 0
v_max_id_clo_res 886 886 0 0.00 0 2031 15 0 0
v_max_id_ord_sup 5083 5083 0 0.00 0 2176 2 0 0
v_max_non_paid_invoice 1282 1282 0 0.00 0 222 3 0 0
v_max_non_paid_realizn 3339 3339 0 0.00 0 1400 4 0 0
v_min_id_clo_ord 5006 5006 0 0.00 0 4185 11 0 0
v_min_id_clo_res 886 886 0 0.00 0 5310 12 0 0
v_min_id_ord_sup 5083 5083 0 0.00 0 4580 5 0 0
v_min_non_paid_invoice 5360 5360 0 0.00 0 11633 34 0 0
v_min_non_paid_realizn 6472 6472 0 0.00 0 14696 26 0 0
v_our_firm 9694 9694 0 0.00 0 15 1 0 0
v_reserve_write_off 18270 18270 0 0.00 0 5302 6 0 0
x_lock_depdocs_on_canc_invoice 8716 8716 0 0.00 0 21022 144 0 0
x_lock_depdocs_on_canc_sup_ord 353 353 0 0.00 0 12137 348 0 0
x_make_qstorno_1000_1200 5006 5006 0 0.00 1 32010 1138 0 0
x_make_qstorno_1200_2000 5083 5083 0 0.00 2 95310 2844 0 0
x_make_qstorno_2100_3300 428138 428138 0 0.00 0 161153 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-03-2024 19:11:04 to 28-03-2024 19:11:08.

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:46 3 8192000000 8801912368 8814235648 7935696 0.096 2 2 3 0 8076800 66144 74960
17:10:46 43118 8192000000 9909719520 10221461504 987208080 10.754 100 84 168 1 1014255968 5680992 21366896
17:12:32 23152 8192000000 9956440112 10279919616 1038321872 11.249 100 85 170 0 1067678400 8046400 21310128
17:13:59 18669 8192000000 9993450640 10325872640 1076838112 11.617 100 89 176 0 1108161568 9823360 21500096
17:15:29 6351 8192000000 10022220272 10370056192 1115260688 11.982 100 76 150 1 1142881968 9385440 18235840
17:16:41 4901 8192000000 10084131408 10442915840 1168355936 12.481 100 77 154 0 1197297936 11230256 17711744
17:17:48 4815 8192000000 10114236336 10484867072 1204558992 12.819 100 75 148 0 1233415952 12655872 16201088
17:18:56 1652 8192000000 10150725600 10527113216 1241114016 13.156 100 78 153 0 1269531040 11548256 16868768
17:20:00 1260 8192000000 10192599536 10572550144 1273659984 13.455 100 85 171 1 1309391520 17444528 18287008
17:21:03 935 8192000000 10209373632 10593554432 1293261024 13.634 100 89 178 0 1326031104 13004464 19765616
17:22:06 8626 8192000000 10194223248 10599866368 1303363472 13.726 100 37 73 2 1317917008 6153584 8399952
17:23:16 8400 8192000000 10200780528 10616020992 1319139664 13.869 100 25 50 0 1331180160 6759264 5281232
17:24:25 3896 8192000000 10217743776 10631475200 1324330896 13.916 100 30 60 1 1337279408 6391520 6556992
17:25:32 15428 8192000000 10222064848 10640797696 1335040336 14.013 100 31 62 3 1349042432 6373184 7628912
17:27:05 6026 8192000000 10228321648 10650075136 1337314672 14.033 100 23 47 0 1347667808 5281296 5071840
17:28:11 9509 8192000000 10226974912 10653593600 1341393968 14.070 100 31 64 0 1354520224 5399776 7726480
17:29:24 8719 8192000000 10186662320 10594811904 1272623344 13.446 96 18 36 0 1282766320 6385808 3757168
17:30:43 21010 8192000000 10215853152 10617466880 1297427216 13.672 99 43 85 0 1315152096 7756448 9968432
17:32:07 79420 8192000000 10221336320 10636640256 1303174272 13.724 98 39 77 0 1320223264 8593392 8455600
17:34:41 18267 8192000000 10219349072 10633093120 1318411552 13.862 100 40 80 1 1336820560 9180112 9228896
17:36:04 13667 8192000000 10209954928 10620153856 1289026928 13.595 97 40 78 1 1309850928 11872736 8951264
17:37:37 9514 8192000000 10257807904 10659569664 1337232576 14.032 100 58 116 0 1368960560 17775200 13952784
17:38:49 13122 8192000000 10252683472 10658463744 1329458288 13.962 99 54 108 0 1358684096 16777808 12448000
17:40:05 25757 8192000000 10258737456 10669105152 1325819136 13.929 98 43 86 0 1354910096 18433504 10657456
17:41:36 2645 8192000000 10254051712 10657357824 1332938736 13.994 100 65 122 1 1369123760 20800944 15384080
17:42:42 13055 8192000000 10252747584 10665279488 1337198816 14.032 100 35 70 0 1366597872 19998288 9400768
17:44:01 5969 8192000000 10256022704 10655797248 1333121104 13.995 100 66 125 0 1364671488 17494464 14055920
17:45:16 1506 8192000000 10274088720 10675900416 1329412768 13.962 99 79 157 0 1375101200 26534192 19154240
17:46:26 2262 8192000000 10292604832 10696761344 1359044208 14.229 100 74 148 0 1399675184 23275776 17355200
17:47:34 2326 8192000000 10301301840 10709532672 1362608928 14.261 100 67 134 1 1407187040 28016896 16561216
17:48:44 2429 8192000000 10311599760 10717433856 1371691760 14.342 100 74 143 0 1414116096 25218656 17205680
17:49:52 8260 8192000000 10316695792 10733400064 1377617568 14.395 100 62 123 1 1424084240 31339728 15126944
17:51:06 7279 8192000000 10337417488 10751737856 1388876896 14.496 100 66 131 0 1439110160 34281344 15951920
17:52:16 11156 8192000000 10323864864 10743734272 1388001440 14.488 100 59 112 0 1425037648 23343936 13692272
17:53:40 30699 8192000000 10303181312 10738356224 1386648528 14.476 100 26 52 2 1415912384 22541520 6722336
17:55:15 22765 8192000000 10310198800 10747387904 1389323888 14.500 100 26 52 0 1421466176 25267472 6874816
17:57:13 16404 8192000000 10304055536 10753949696 1384809920 14.460 100 16 32 0 1414302032 25177808 4314304
17:58:36 49208 8192000000 10296066480 10737139712 1384206160 14.454 100 15 32 0 1396906960 9674096 3026704
18:00:26 88056 8192000000 10299700512 10744483840 1374231360 14.365 99 23 48 0 1388500928 8683440 5586128
18:02:57 46093 8192000000 10313698592 10766131200 1389901072 14.505 99 8 16 1 1406572896 14969712 1702112
18:04:45 103698 8192000000 10289555888 10745307136 1344416384 14.097 96 6 12 0 1363939616 17987040 1536192
18:07:30 35925 8192000000 10304817296 10746454016 1380090448 14.417 99 16 32 0 1395611328 11722368 3798512
18:09:17 96288 8192000000 10302164128 10750345216 1348362368 14.133 96 24 46 0 1363746624 10171344 5212912
18:11:55 141342 8192000000 10274485200 10715410432 1239837872 13.145 88 28 56 1 1253752528 7811696 6102960
18:15:17 38673 8192000000 10284993040 10728210432 1343839920 14.092 96 30 60 1 1364983952 13418576 7725456
18:17:03 43803 8192000000 10278522160 10716651520 1353778352 14.181 98 35 67 1 1374207504 12320688 8108464
18:18:47 48494 8192000000 10289150992 10723479552 1357941312 14.219 99 28 56 1 1384061600 18549760 7570528
18:20:36 100218 8192000000 10267161664 10722897920 1329103280 13.959 96 24 48 0 1347226416 11762688 6360448
18:24:00 54782 8192000000 10259229008 10702077952 1351752176 14.163 99 31 61 1 1367527440 8662112 7113152
18:25:55 55882 8192000000 10252469488 10707001344 1336098064 14.022 98 7 13 0 1347906464 10393808 1414592
18:27:57 25271 8192000000 10270365200 10716024832 1342392912 14.079 98 33 67 0 1357858464 8017712 7447840
18:29:25 34421 8192000000 10246270736 10687385600 1327554784 13.945 99 30 60 0 1349011872 14953536 6503552
18:31:02 22298 8192000000 10271258128 10705879040 1351523584 14.161 100 50 100 0 1372772976 10246384 11003008
18:32:25 14511 8192000000 10252491936 10690576384 1331138480 13.977 99 47 94 0 1356107408 14649872 10319056
18:33:48 24334 8192000000 10241593904 10675990528 1279087536 13.505 95 25 50 0 1292419328 8306064 5025728
18:35:21 38801 8192000000 10264272480 10706464768 1340961760 14.066 99 30 60 0 1358004576 10875984 6166832
18:37:08 57155 8192000000 10268897168 10716471296 1338315504 14.042 99 21 42 2 1359864848 16653920 4895424
18:39:24 186853 8192000000 10274373888 10721591296 1367077920 14.301 99 13 26 0 1385682272 16306896 2297456
18:43:32 75030 8192000000 10273470272 10734850048 1370883120 14.335 99 7 14 0 1383859392 11631792 1344480
18:46:49 40082 8192000000 10286001648 10740039680 1390002864 14.506 100 27 54 0 1403156640 7203600 5950176
18:48:39 35301 8192000000 10310342896 10770579456 1405594176 14.645 100 26 50 1 1424486736 13186752 5705808
18:50:14 48842 8192000000 10298707072 10745556992 1362566272 14.260 97 26 51 0 1376280400 8537520 5176608
18:52:11 99520 8192000000 10292628480 10738970624 1349937440 14.147 97 10 20 0 1360394688 8110704 2346544
18:54:51 53144 8192000000 10297570592 10734178304 1333972432 14.003 96 30 60 0 1350870992 10522624 6375936
18:56:45 77927 8192000000 10278889856 10711302144 1307605712 13.764 95 13 26 0 1319026368 8514592 2906064
18:59:11 60476 8192000000 10262402656 10717290496 1348422288 14.133 99 15 30 0 1366620304 14229584 3968432
19:01:32 56044 8192000000 10272214080 10713403392 1318167008 13.860 96 37 72 0 1335362240 9350112 7845120
19:04:04 49811 8192000000 10246995472 10701008896 1323222672 13.906 96 16 31 0 1337592096 10929872 3439552
19:05:54 31722 8192000000 10247173696 10709090304 1343587808 14.090 99 12 24 0 1359563936 12861968 3114160
19:08:00 35115 8192000000 10233963664 10683764736 1314988528 13.831 98 17 32 0 1329057616 10196528 3872560
19:09:36 9763 8192000000 9090463440 9312595968 259366080 3.068 19 5 10 0 262110560 1682736 1061744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 74 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

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          186297
MON$OLDEST_ACTIVE               186298
MON$OLDEST_SNAPSHOT             186298
MON$NEXT_TRANSACTION            186298
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                       1912224
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.33740 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33740 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33740 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33740 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 Thu Mar 28 19:11:28 2024 
 
Database header page information: 
    Flags            0 
    Generation        97313 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    186297 
    Oldest active        186298 
    Oldest snapshot        186298 
    Next transaction    186299 
    Sequence number        0 
    Next attachment ID    737 
    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.53, total records: 7834740 
    Average version length: 48.16, total versions: 59983, 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: 87344 
    Data pages: 87344, average fill: 72% 
    Primary pages: 87344, secondary pages: 0, swept pages: 25437 
    Empty pages: 2, full pages: 63854 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 142 
    40 - 59% = 1381 
    60 - 79% = 85790 
    80 - 99% = 15 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23508, nodes: 7834740 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1735991, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 330 
        20 - 39% = 1833 
        40 - 59% = 4195 
        60 - 79% = 2260 
        80 - 99% = 14890 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13683, nodes: 7834740 
    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: 1558292, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1638 
        40 - 59% = 2124 
        60 - 79% = 1003 
        80 - 99% = 8917 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8440, nodes: 7834740 
    Average node length: 6.63, total dup: 5840812, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1551089, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 141 
        20 - 39% = 986 
        40 - 59% = 1402 
        60 - 79% = 858 
        80 - 99% = 5053 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.73, total records: 2283274 
    Average version length: 35.02, total versions: 58551, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28680 
    Data pages: 28680, average fill: 73% 
    Primary pages: 28675, secondary pages: 5, swept pages: 13113 
    Empty pages: 2, full pages: 21489 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 113 
    40 - 59% = 1538 
    60 - 79% = 26552 
    80 - 99% = 461 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4634, nodes: 2283274 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 697933, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 961 
        40 - 59% = 866 
        60 - 79% = 683 
        80 - 99% = 2124 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2529, nodes: 2285757 
    Average node length: 4.97, total dup: 2284858, max dup: 18984 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1259663, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 240 
        40 - 59% = 1540 
        60 - 79% = 532 
        80 - 99% = 217 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2058, nodes: 2283274 
    Average node length: 4.97, total dup: 2283224, max dup: 130901 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1073748, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 61 
        40 - 59% = 1105 
        60 - 79% = 47 
        80 - 99% = 837 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4410, nodes: 2283274 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 697933, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 103 
        20 - 39% = 614 
        40 - 59% = 607 
        60 - 79% = 800 
        80 - 99% = 2286 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 81.97, total records: 400 
    Average version length: 23.05, total versions: 248771, max versions: 645 
    Average fragment length: 2.00, total fragments: 73, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1400 
    Data pages: 1400, average fill: 89% 
    Primary pages: 7, secondary pages: 1393, swept pages: 0 
    Empty pages: 0, full pages: 1399 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1398 
 
    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: 2.17, total records: 79457 
    Average version length: 68.28, total versions: 76934, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 40.57 
    Pointer pages: 6, data page slots: 2072 
    Data pages: 1928, average fill: 53% 
    Primary pages: 1927, secondary pages: 1, swept pages: 0 
    Empty pages: 269, full pages: 773 
    Fill distribution: 
     0 - 19% = 492 
    20 - 39% = 260 
    40 - 59% = 273 
    60 - 79% = 206 
    80 - 99% = 697 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708230, depth: 3, leaf buckets: 350, nodes: 79457 
    Average node length: 13.31, total dup: 5461, max dup: 2 
    Average key length: 10.69, compression ratio: 2.53 
    Average prefix length: 19.24, average data length: 7.76 
    Clustering factor: 56932, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 253 
        40 - 59% = 93 
        60 - 79% = 4 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 18900, max versions: 1000 
    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: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 5, secondary pages: 67, swept pages: 0 
    Empty pages: 4, full pages: 67 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 61 
 
    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: 1.01, total records: 1671 
    Average version length: 43.32, total versions: 1632, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 57.55 
    Pointer pages: 1, data page slots: 32 
    Data pages: 30, average fill: 55% 
    Primary pages: 28, secondary pages: 2, swept pages: 0 
    Empty pages: 1, full pages: 13 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 8 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 86581, depth: 2, leaf buckets: 2, nodes: 1671 
    Average node length: 4.32, total dup: 1573, max dup: 155 
    Average key length: 2.62, compression ratio: 7.25 
    Average prefix length: 18.44, average data length: 0.56 
    Clustering factor: 891, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        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: 97.06, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    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: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    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.04, total records: 779918 
    Average version length: 25.84, total versions: 66419, 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: 8032 
    Data pages: 8024, average fill: 68% 
    Primary pages: 7993, secondary pages: 31, swept pages: 1921 
    Empty pages: 116, full pages: 6044 
    Fill distribution: 
     0 - 19% = 202 
    20 - 39% = 186 
    40 - 59% = 359 
    60 - 79% = 7020 
    80 - 99% = 257 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 871, nodes: 779918 
    Average node length: 4.86, total dup: 779869, max dup: 138022 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88109, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 133 
        40 - 59% = 487 
        60 - 79% = 202 
        80 - 99% = 49 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 893, nodes: 779918 
    Average node length: 5.87, total dup: 694604, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156237, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 105 
        40 - 59% = 346 
        60 - 79% = 150 
        80 - 99% = 291 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 935, nodes: 779918 
    Average node length: 5.87, total dup: 694604, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158257, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 191 
        40 - 59% = 315 
        60 - 79% = 149 
        80 - 99% = 280 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1111, nodes: 779918 
    Average node length: 5.95, total dup: 694604, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 151624, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 265 
        40 - 59% = 561 
        60 - 79% = 207 
        80 - 99% = 77 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.74, total records: 5428 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.00, total fragments: 90, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 74, secondary pages: 22, swept pages: 56 
    Empty pages: 6, full pages: 63 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5428 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.05 
    Average prefix length: 34.36, average data length: 1.54 
    Clustering factor: 5262, ratio: 0.97 
    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: 5428 
    Average node length: 11.11, 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: 144, 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.11, total records: 85692 
    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: 832 
    Data pages: 832, average fill: 71% 
    Primary pages: 832, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 825 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 825 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 31317, depth: 2, leaf buckets: 109, nodes: 85692 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3582, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 107 
 
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.22, 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.20 
    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.15, total records: 157718 
    Average version length: 150.09, total versions: 4751, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 5, data page slots: 4120 
    Data pages: 3760, average fill: 86% 
    Primary pages: 3760, secondary pages: 0, swept pages: 4 
    Empty pages: 24, full pages: 3725 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3725 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 144.76, total records: 163512 
    Average version length: 151.10, total versions: 6591, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.72 
    Pointer pages: 6, data page slots: 5136 
    Data pages: 3912, average fill: 86% 
    Primary pages: 3911, secondary pages: 1, swept pages: 12 
    Empty pages: 29, full pages: 3861 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3861 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 124.87, total records: 211708 
    Average version length: 154.56, total versions: 36551, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.58 
    Pointer pages: 6, data page slots: 5856 
    Data pages: 5080, average fill: 87% 
    Primary pages: 5080, secondary pages: 0, swept pages: 4 
    Empty pages: 42, full pages: 5029 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 5030 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 145.33, total records: 174561 
    Average version length: 151.65, total versions: 6403, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 5, data page slots: 4912 
    Data pages: 4152, average fill: 87% 
    Primary pages: 4152, secondary pages: 0, swept pages: 2 
    Empty pages: 15, full pages: 4130 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4129 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 142.00, total records: 162930 
    Average version length: 151.95, total versions: 9544, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 6, data page slots: 4256 
    Data pages: 3880, average fill: 87% 
    Primary pages: 3880, secondary pages: 0, swept pages: 1 
    Empty pages: 20, full pages: 3853 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3854 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 146.15, total records: 173331 
    Average version length: 150.44, total versions: 5295, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.60 
    Pointer pages: 8, data page slots: 5272 
    Data pages: 4152, average fill: 86% 
    Primary pages: 4152, secondary pages: 0, swept pages: 1 
    Empty pages: 45, full pages: 4095 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4096 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 133.16, total records: 187044 
    Average version length: 154.26, total versions: 21893, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.74 
    Pointer pages: 6, data page slots: 5256 
    Data pages: 4472, average fill: 87% 
    Primary pages: 4471, secondary pages: 1, swept pages: 1 
    Empty pages: 28, full pages: 4433 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 4433 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 138.35, total records: 169309 
    Average version length: 152.41, total versions: 13946, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.26 
    Pointer pages: 6, data page slots: 4768 
    Data pages: 4064, average fill: 86% 
    Primary pages: 4064, secondary pages: 0, swept pages: 1 
    Empty pages: 48, full pages: 4003 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4002 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 141.42, total records: 180804 
    Average version length: 153.09, total versions: 11301, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.99 
    Pointer pages: 6, data page slots: 5192 
    Data pages: 4312, average fill: 87% 
    Primary pages: 4312, secondary pages: 0, swept pages: 4 
    Empty pages: 23, full pages: 4278 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 4278 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 144.61, total records: 189406 
    Average version length: 152.52, total versions: 8128, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 7, data page slots: 7224 
    Data pages: 4528, average fill: 86% 
    Primary pages: 4528, secondary pages: 0, swept pages: 3 
    Empty pages: 34, full pages: 4485 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 4485 
 
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.97, total records: 2130716 
    Average version length: 52.88, total versions: 31635, 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: 25720 
    Data pages: 25720, average fill: 71% 
    Primary pages: 25720, secondary pages: 0, swept pages: 11318 
    Empty pages: 212, full pages: 20857 
    Fill distribution: 
     0 - 19% = 420 
    20 - 39% = 417 
    40 - 59% = 1076 
    60 - 79% = 23544 
    80 - 99% = 263 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2622, nodes: 2130716 
    Average node length: 5.44, total dup: 1988886, max dup: 1530 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183414, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 282 
        40 - 59% = 1735 
        60 - 79% = 315 
        80 - 99% = 285 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2760, nodes: 2130716 
    Average node length: 5.69, total dup: 1912712, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 380371, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 7 
        40 - 59% = 2340 
        60 - 79% = 382 
        80 - 99% = 31 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2235, nodes: 2130716 
    Average node length: 4.96, total dup: 2130616, max dup: 27245 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181594, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 212 
        40 - 59% = 1279 
        60 - 79% = 396 
        80 - 99% = 346 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 39.83, total records: 148268 
    Average version length: 69.15, total versions: 62970, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.16 
    Pointer pages: 3, data page slots: 4296 
    Data pages: 3088, average fill: 56% 
    Primary pages: 3088, secondary pages: 0, swept pages: 480 
    Empty pages: 514, full pages: 1728 
    Fill distribution: 
     0 - 19% = 744 
    20 - 39% = 280 
    40 - 59% = 244 
    60 - 79% = 519 
    80 - 99% = 1301 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 96443, depth: 3, leaf buckets: 216, nodes: 148268 
    Average node length: 6.41, total dup: 129118, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 24832, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 110 
        60 - 79% = 59 
        80 - 99% = 16 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.47, total records: 6751550 
    Average version length: 68.83, total versions: 342215, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 61, data page slots: 99488 
    Data pages: 99488, average fill: 73% 
    Primary pages: 99488, secondary pages: 0, swept pages: 34974 
    Empty pages: 9, full pages: 64827 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 774 
    40 - 59% = 8448 
    60 - 79% = 85888 
    80 - 99% = 4302 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10606, nodes: 6751550 
    Average node length: 6.51, total dup: 5839716, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1496181, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1992 
        40 - 59% = 5975 
        60 - 79% = 2289 
        80 - 99% = 339 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8382, nodes: 6751550 
    Average node length: 5.41, total dup: 6475827, max dup: 160 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1306081, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1366 
        40 - 59% = 4635 
        60 - 79% = 1513 
        80 - 99% = 859 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8442, nodes: 6751550 
    Average node length: 5.41, total dup: 6475827, max dup: 160 
    Average key length: 2.42, compression ratio: 7.03 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1308671, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1444 
        40 - 59% = 4642 
        60 - 79% = 1475 
        80 - 99% = 870 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.27, total records: 11656171 
    Average version length: 68.79, total versions: 285693, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 101, data page slots: 164336 
    Data pages: 164336, average fill: 75% 
    Primary pages: 164336, secondary pages: 0, swept pages: 86816 
    Empty pages: 5, full pages: 139503 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 506 
    40 - 59% = 5409 
    60 - 79% = 154232 
    80 - 99% = 4145 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18276, nodes: 11656171 
    Average node length: 6.56, total dup: 10162495, max dup: 55 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2324928, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 2745 
        40 - 59% = 11206 
        60 - 79% = 3770 
        80 - 99% = 536 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 48.81, total records: 1619229 
    Average version length: 69.10, total versions: 476399, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.58 
    Pointer pages: 30, data page slots: 46624 
    Data pages: 30424, average fill: 60% 
    Primary pages: 30424, secondary pages: 0, swept pages: 9967 
    Empty pages: 3115, full pages: 18046 
    Fill distribution: 
     0 - 19% = 5470 
    20 - 39% = 2783 
    40 - 59% = 2345 
    60 - 79% = 12308 
    80 - 99% = 7518 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2359, nodes: 1619229 
    Average node length: 5.51, total dup: 1553405, max dup: 99 
    Average key length: 2.56, compression ratio: 16.40 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 112022, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 785 
        40 - 59% = 1154 
        60 - 79% = 352 
        80 - 99% = 60 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 40.01, total records: 1042017 
    Average version length: 69.13, total versions: 437917, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.15 
    Pointer pages: 20, data page slots: 32456 
    Data pages: 26120, average fill: 46% 
    Primary pages: 26120, secondary pages: 0, swept pages: 7383 
    Empty pages: 5646, full pages: 11107 
    Fill distribution: 
     0 - 19% = 9051 
    20 - 39% = 3215 
    40 - 59% = 2014 
    60 - 79% = 2936 
    80 - 99% = 8904 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1434, nodes: 1042017 
    Average node length: 5.77, total dup: 974549, max dup: 149 
    Average key length: 2.84, compression ratio: 14.77 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 132252, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 326 
        40 - 59% = 692 
        60 - 79% = 326 
        80 - 99% = 88 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.82, total records: 9401045 
    Average version length: 68.92, total versions: 284271, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 91, data page slots: 146888 
    Data pages: 146864, average fill: 68% 
    Primary pages: 146864, secondary pages: 0, swept pages: 75912 
    Empty pages: 367, full pages: 81169 
    Fill distribution: 
     0 - 19% = 1359 
    20 - 39% = 7179 
    40 - 59% = 23598 
    60 - 79% = 110024 
    80 - 99% = 4704 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13541, nodes: 9401045 
    Average node length: 6.69, total dup: 7796844, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2018587, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1068 
        40 - 59% = 6629 
        60 - 79% = 5119 
        80 - 99% = 723 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21237048 
    Average version length: 82.82, total versions: 9334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320160 
    Data pages: 320160, average fill: 81% 
    Primary pages: 320160, secondary pages: 0, swept pages: 13758 
    Empty pages: 48, full pages: 319299 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 53 
    40 - 59% = 121 
    60 - 79% = 28015 
    80 - 99% = 291898 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19409, nodes: 21237048 
    Average node length: 5.72, total dup: 20754164, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3295841, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8029 
        60 - 79% = 596 
        80 - 99% = 10778 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17296, nodes: 21237048 
    Average node length: 6.31, total dup: 18663781, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919556, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 866 
        60 - 79% = 291 
        80 - 99% = 16134 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21179, nodes: 21237048 
    Average node length: 6.35, total dup: 18581603, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3591136, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 2 
        40 - 59% = 8242 
        60 - 79% = 652 
        80 - 99% = 12274 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16332, nodes: 21237048 
    Average node length: 5.56, total dup: 21236948, max dup: 228905 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948468, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 3216 
        60 - 79% = 418 
        80 - 99% = 12688 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 80.04, total records: 9861368 
    Average version length: 82.55, total versions: 287023, 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: 107, data page slots: 173616 
    Data pages: 173592, average fill: 70% 
    Primary pages: 173592, secondary pages: 0, swept pages: 93055 
    Empty pages: 455, full pages: 102344 
    Fill distribution: 
     0 - 19% = 1730 
    20 - 39% = 8583 
    40 - 59% = 26898 
    60 - 79% = 72413 
    80 - 99% = 63968 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11422, nodes: 9861368 
    Average node length: 5.37, total dup: 9550138, max dup: 181 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2174007, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 69 
        40 - 59% = 7827 
        60 - 79% = 3413 
        80 - 99% = 112 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13648, nodes: 9861368 
    Average node length: 6.24, total dup: 8173384, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1495005, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 137 
        20 - 39% = 4001 
        40 - 59% = 4191 
        60 - 79% = 2645 
        80 - 99% = 2674 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12754, nodes: 9861368 
    Average node length: 5.99, total dup: 8558440, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2367340, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 68 
        40 - 59% = 8849 
        60 - 79% = 3710 
        80 - 99% = 126 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10316, nodes: 9861368 
    Average node length: 5.14, total dup: 9861268, max dup: 150743 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1544395, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1276 
        40 - 59% = 5101 
        60 - 79% = 1761 
        80 - 99% = 2145 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.73, total records: 11665279 
    Average version length: 82.56, total versions: 225816, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 120, data page slots: 194360 
    Data pages: 193000, average fill: 74% 
    Primary pages: 193000, secondary pages: 0, swept pages: 70203 
    Empty pages: 2251, full pages: 149861 
    Fill distribution: 
     0 - 19% = 3904 
    20 - 39% = 6031 
    40 - 59% = 16105 
    60 - 79% = 43729 
    80 - 99% = 123231 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13176, nodes: 11665279 
    Average node length: 5.31, total dup: 11554616, max dup: 636 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2434991, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 42 
        40 - 59% = 8507 
        60 - 79% = 4316 
        80 - 99% = 311 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10747, nodes: 11665279 
    Average node length: 5.51, total dup: 11157232, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 739074, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 831 
        40 - 59% = 2655 
        60 - 79% = 1859 
        80 - 99% = 5246 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15058, nodes: 11665279 
    Average node length: 6.03, total dup: 10186438, max dup: 72 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2451646, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 55 
        40 - 59% = 10002 
        60 - 79% = 4621 
        80 - 99% = 379 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11187, nodes: 11665279 
    Average node length: 5.24, total dup: 11665179, max dup: 194628 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 726662, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 111 
        20 - 39% = 798 
        40 - 59% = 5124 
        60 - 79% = 1587 
        80 - 99% = 3567 
 
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: 80.39, total records: 9977203 
    Average version length: 82.87, total versions: 284670, 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: 109, data page slots: 177056 
    Data pages: 177048, average fill: 70% 
    Primary pages: 177048, secondary pages: 0, swept pages: 96160 
    Empty pages: 603, full pages: 103153 
    Fill distribution: 
     0 - 19% = 1981 
    20 - 39% = 9085 
    40 - 59% = 28504 
    60 - 79% = 74577 
    80 - 99% = 62901 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12133, nodes: 9977203 
    Average node length: 5.19, total dup: 9947902, max dup: 2551 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1984125, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1546 
        40 - 59% = 8103 
        60 - 79% = 1840 
        80 - 99% = 606 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13778, nodes: 9977203 
    Average node length: 6.26, total dup: 8269241, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1465643, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 3957 
        40 - 59% = 4205 
        60 - 79% = 2616 
        80 - 99% = 2822 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12717, nodes: 9977203 
    Average node length: 5.44, total dup: 9530817, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2120810, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1433 
        40 - 59% = 8995 
        60 - 79% = 1659 
        80 - 99% = 599 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10532, nodes: 9977203 
    Average node length: 5.16, total dup: 9977103, max dup: 152340 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1572502, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1315 
        40 - 59% = 5323 
        60 - 79% = 1758 
        80 - 99% = 2097 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 581534 
    Average version length: 68.78, total versions: 5775, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8096 
    Data pages: 8096, average fill: 75% 
    Primary pages: 8096, secondary pages: 0, swept pages: 4083 
    Empty pages: 5, full pages: 6773 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 23 
    40 - 59% = 258 
    60 - 79% = 7710 
    80 - 99% = 95 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37521, depth: 3, leaf buckets: 746, nodes: 581534 
    Average node length: 5.95, total dup: 495130, max dup: 89 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101068, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 521 
        60 - 79% = 109 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31841, depth: 3, leaf buckets: 764, nodes: 581534 
    Average node length: 6.15, total dup: 477061, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101122, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 536 
        60 - 79% = 110 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 585, nodes: 581534 
    Average node length: 4.86, total dup: 581434, max dup: 9882 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89891, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 357 
        60 - 79% = 95 
        80 - 99% = 109 
 
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 Thu Mar 28 19:11:52 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7834740 59983 1 0.0000 0.0000
DOC_LIST 2283274 58551 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 248771 645 62100.0000 0.0000
INVNT_TURNOVER_LOG 79457 76934 1 0.0000 0.0000
MONEY_SALDO 49 18900 1000 38500.0000 0.0000
MONEY_TURNOVER_LOG 1671 1632 1 0.0000 0.0000
PDISTR 779918 66419 4 0.0000 0.0000
PERF_SPLIT_0 157718 4751 1 0.0000 0.0000
PERF_SPLIT_1 163512 6591 1 0.0000 0.0000
PERF_SPLIT_2 211708 36551 1 0.0000 0.0000
PERF_SPLIT_3 174561 6403 1 0.0000 0.0000
PERF_SPLIT_4 162930 9544 1 0.0000 0.0000
PERF_SPLIT_5 173331 5295 1 0.0000 0.0000
PERF_SPLIT_6 187044 21893 1 0.0000 0.0000
PERF_SPLIT_7 169309 13946 1 0.0000 0.0000
PERF_SPLIT_8 180804 11301 1 0.0000 0.0000
PERF_SPLIT_9 189406 8128 1 0.0000 0.0000
PSTORNED 2130716 31635 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 148268 62970 1 0.0000 0.0000
XQD_1000_3300 6751550 342215 1 0.0000 0.0000
XQD_1200_2000 11656171 285693 1 0.0000 0.0000
XQD_2000_3300 1619229 476399 1 0.0000 0.0000
XQD_2100_3300 1042017 437917 1 0.0000 0.0000
XQD_3300_3400 9401045 284271 1 0.0000 0.0000
XQS_1000_1200 21237048 9334 1 0.0000 0.0000
XQS_1000_3300 9861368 287023 1 0.0000 0.0000
XQS_1200_2000 11665279 225816 1 0.0000 0.0000
XQS_2100_3300 9977203 284670 1 0.0000 0.0000
XQS_3300_3400 581534 5775 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 ---
:479: 
:480: mscs-test-161.budzdorov.ru    Thu Mar 28 19:09:47 2024
:481:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:482: 
:483: 
:484: mscs-test-161.budzdorov.ru    Thu Mar 28 19:09:47 2024
:485:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:486: 
--- end of diff output ---

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

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