Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.03.2024 01: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 15832904 kB
MemAvailable 30251848 kB
Buffers 0 kB
Cached 15901732 kB
SwapCached 2580 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-21 01:09:46
DTS_END                         2024-03-21 01:09:46.4680
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33296
TRN_ID                          181121
ATT_ID                          609
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: 9108.78 18578 910878
customer order: creation 184.70 344 18470
customer order: refuse 16.52 378 1652
order to supplier: creation 48.86 1364 4886
order to supplier: removal 3.40 98586 340
invoice (draft): creation 50.01 3377 5001
invoice (draft): removal 47.21 928 4721
invoice accept: apply 45.10 20878 4510
invoice accept: cancel 42.19 910 4219
customer reserve: creation 4215.19 206 421519
customer reserve: removal 4152.97 64 415297
realization accept: apply 89.53 192 8953
realization accept: cancel 73.61 133 7361
payment from customer: creation 62.85 137 6285
payment from customer: removal 6.51 73 651
payment to supplier: creation 53.48 138 5348
payment to supplier: removal 3.25 109 325
service: total inventory turnovers 5.42 1002 542
service: total monetary turnovers 7.11 34 711
service: aggregate perf. data 0.84 19005 84
service: refresh index statistics 0.03 223696 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 21-03-2024 01:10:47 to 21-03-2024 01:10:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2989
TEST_TIME 2 3258
TEST_TIME 3 3198
TEST_TIME 4 4576
TEST_TIME 5 4004
TEST_TIME 6 3955
TEST_TIME 7 4221
TEST_TIME 8 4118
TEST_TIME 9 4620
TEST_TIME 10 5126
TEST_TIME 11 5056
TEST_TIME 12 5445
TEST_TIME 13 5466
TEST_TIME 14 5421
TEST_TIME 15 5693
TEST_TIME 16 5851
TEST_TIME 17 6023
TEST_TIME 18 6262
TEST_TIME 19 6744
TEST_TIME 20 6826
TEST_TIME 21 6906
TEST_TIME 22 7491
TEST_TIME 23 7373
TEST_TIME 24 7447
TEST_TIME 25 7608
TEST_TIME 26 8086
TEST_TIME 27 8604
TEST_TIME 28 9114
TEST_TIME 29 9097
TEST_TIME 30 9184
TEST_TIME 31 9111
TEST_TIME 32 9157
TEST_TIME 33 9074
TEST_TIME 34 8856
TEST_TIME 35 8900
TEST_TIME 36 8903
TEST_TIME 37 8732
TEST_TIME 38 8796
TEST_TIME 39 8784
TEST_TIME 40 8865
TEST_TIME 41 8870
TEST_TIME 42 8803
TEST_TIME 43 8776
TEST_TIME 44 8894
TEST_TIME 45 8771
TEST_TIME 46 8658
TEST_TIME 47 8666
TEST_TIME 48 8822
TEST_TIME 49 8839
TEST_TIME 50 8878
TEST_TIME 51 8853
TEST_TIME 52 8850
TEST_TIME 53 9036
TEST_TIME 54 9049
TEST_TIME 55 9075
TEST_TIME 56 9072
TEST_TIME 57 9150
TEST_TIME 58 9212
TEST_TIME 59 9229
TEST_TIME 60 9223
TEST_TIME 61 9166
TEST_TIME 62 9184
TEST_TIME 63 9126
TEST_TIME 64 9100
TEST_TIME 65 9118
TEST_TIME 66 9081
TEST_TIME 67 9071
TEST_TIME 68 9072
TEST_TIME 69 8987
TEST_TIME 70 8900
TEST_TIME 71 8977
TEST_TIME 72 8957
TEST_TIME 73 8960
TEST_TIME 74 8985
TEST_TIME 75 9050
TEST_TIME 76 9056
TEST_TIME 77 9062
TEST_TIME 78 9106
TEST_TIME 79 9132
TEST_TIME 80 9159
TEST_TIME 81 9213
TEST_TIME 82 9184
TEST_TIME 83 9188
TEST_TIME 84 9336
TEST_TIME 85 9306
TEST_TIME 86 9275
TEST_TIME 87 9202
TEST_TIME 88 9172
TEST_TIME 89 9131
TEST_TIME 90 9138
TEST_TIME 91 9106
TEST_TIME 92 9078
TEST_TIME 93 9051
TEST_TIME 94 9014
TEST_TIME 95 9032
TEST_TIME 96 9045
TEST_TIME 97 9052
TEST_TIME 98 9090
TEST_TIME 99 9084
TEST_TIME 100 9123

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-03-2024 01:10:51 to 21-03-2024 01:10:54.

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 1296388 1296388 0 0.00 0 28204 7 0 0
doc_list_biud 1296378 1296378 0 0.00 0 43542 27 0 0
sp_add_invoice_to_stock 4622 4510 112 2.42 39 246183 20879 0 112
sp_cancel_adding_invoice 4219 4219 0 0.00 4 64182 911 0 0
sp_cancel_client_order 1652 1652 0 0.00 4 9305 378 0 0
sp_cancel_customer_reserve 415297 415297 0 0.00 0 24285 64 0 0
sp_cancel_pay_from_customer 651 651 0 0.00 2 3170 74 0 0
sp_cancel_pay_to_supplier 325 325 0 0.00 3 11508 110 0 0
sp_cancel_supplier_invoice 4732 4721 11 0.23 2 43547 928 0 11
sp_cancel_supplier_order 340 340 0 0.00 6 919569 98587 0 0
sp_cancel_write_off 7361 7361 0 0.00 1 8825 133 0 0
sp_client_order 18470 18470 0 0.00 3 29233 344 0 0
sp_customer_reserve 421519 421519 0 0.00 0 124926 206 0 0
sp_fill_shopping_cart 28353 28353 0 0.00 1 12696 43 0 0
sp_fill_shopping_cart_clo_res 421505 421505 0 0.00 0 19051 16 0 0
sp_get_clo_for_invoice 4488 4488 0 0.00 0 25447 284 0 0
sp_kill_cost_storno 12556 12556 0 0.00 0 15682 66 0 0
sp_kill_qstorno_ret_qs2qd 843016 843016 0 0.00 0 43540 35 0 0
sp_kill_qty_storno 447029 447029 0 0.00 0 43542 76 0 0
sp_lock_selected_doc 18584 18584 0 0.00 0 6678 7 0 0
sp_make_cost_storno 25074 25074 0 0.00 0 14486 62 0 0
sp_multiply_rows_for_pdistr 25071 25071 0 0.00 0 28194 32 0 0
sp_multiply_rows_for_qdistr 18469 18469 0 0.00 0 18281 154 0 0
sp_pay_from_customer 6285 6285 0 0.00 4 28208 138 0 0
sp_pay_to_supplier 5348 5348 0 0.00 4 13693 138 0 0
sp_payment_common 11632 11632 0 0.00 1 13165 33 0 0
sp_qd_handle_on_cancel_clo 1652 1652 0 0.00 0 9295 356 0 0
sp_qd_handle_on_invoice_upd_sts 8705 8705 0 0.00 0 23094 330 0 0
sp_qd_handle_on_reserve_upd_sts 8953 8953 0 0.00 0 30498 71 0 0
sp_reserve_write_off 8953 8953 0 0.00 6 30518 192 0 0
sp_supplier_invoice 5001 5001 0 0.00 6 84466 3377 0 0
sp_supplier_order 4886 4886 0 0.00 4 35857 1365 0 0
srv_aggregate_perf_data 85 84 1 1.17 1707 325378 19006 0 1
srv_fill_mon_cache_memory 59 59 0 0.00 785 110218 34733 0 0
srv_find_qd_qs_mism 865410 865410 0 0.00 0 14786 7 0 0
srv_make_invnt_saldo 542 542 0 0.00 29 50555 1002 0 0
srv_make_money_saldo 711 711 0 0.00 1 3601 35 0 0
srv_recalc_idx_stat 3 3 0 0.00 126002 312888 223697 0 0
t$perf-abend:sp_add_invoice_to_stock 112 112 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4512 4512 0 0.00 0 7206 174 0 0
t$perf-norm:sp_cancel_adding_invoice 368 368 0 0.00 0 7037 116 0 0
t$perf-norm:sp_cancel_client_order 1652 1652 0 0.00 0 9166 21 0 0
t$perf-norm:sp_cancel_customer_reserve 589 589 0 0.00 0 1670 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 651 651 0 0.00 0 2216 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 325 325 0 0.00 0 1110 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 328 328 0 0.00 0 513 13 0 0
t$perf-norm:sp_cancel_supplier_order 340 340 0 0.00 0 24870 1599 0 0
t$perf-norm:sp_cancel_write_off 892 892 0 0.00 0 5974 13 0 0
t$perf-norm:sp_client_order 18470 18470 0 0.00 0 8103 16 0 0
t$perf-norm:sp_customer_reserve 877 877 0 0.00 0 3094 12 0 0
t$perf-norm:sp_pay_from_customer 6285 6285 0 0.00 0 5023 11 0 0
t$perf-norm:sp_pay_to_supplier 5348 5348 0 0.00 0 5840 14 0 0
t$perf-norm:sp_reserve_write_off 8953 8953 0 0.00 0 29702 16 0 0
t$perf-norm:sp_supplier_invoice 5001 5001 0 0.00 0 6203 27 0 0
t$perf-norm:sp_supplier_order 4886 4886 0 0.00 0 5008 17 0 0
t$perf-norm:srv_aggregate_perf_data 84 84 0 0.00 0 502 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 50 2 0 0
t$perf-norm:srv_make_invnt_saldo 542 542 0 0.00 0 2191 30 0 0
t$perf-norm:srv_make_money_saldo 711 711 0 0.00 0 2215 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 9196 8972 224 2.43 0 5789 19 0 224
v_all_customers 33708 33708 0 0.00 0 36 1 0 0
v_all_suppliers 27728 27728 0 0.00 0 22 1 0 0
v_all_wares 36938 36938 0 0.00 0 132 1 0 0
v_cancel_adding_invoice 736 736 0 0.00 0 379 7 0 0
v_cancel_client_order 3304 3304 0 0.00 0 2790 5 0 0
v_cancel_customer_prepayment 1302 1302 0 0.00 0 3000 8 0 0
v_cancel_customer_reserve 1178 1178 0 0.00 0 5296 9 0 0
v_cancel_payment_to_supplier 650 650 0 0.00 0 730 5 0 0
v_cancel_supplier_invoice 678 656 22 3.24 0 1129 15 0 22
v_cancel_supplier_order 680 680 0 0.00 0 2676 11 0 0
v_cancel_write_off 1784 1784 0 0.00 0 4334 18 0 0
v_max_id_clo_ord 4885 4885 0 0.00 0 3665 3 0 0
v_max_id_clo_res 877 877 0 0.00 0 2657 7 0 0
v_max_id_ord_sup 4999 4999 0 0.00 0 4851 3 0 0
v_max_non_paid_invoice 1367 1367 0 0.00 0 5387 15 0 0
v_max_non_paid_realizn 3246 3246 0 0.00 0 1780 6 0 0
v_min_id_clo_ord 4885 4885 0 0.00 0 1621 8 0 0
v_min_id_clo_res 877 877 0 0.00 0 6466 11 0 0
v_min_id_ord_sup 4999 4999 0 0.00 0 10538 12 0 0
v_min_non_paid_invoice 5347 5347 0 0.00 0 10986 17 0 0
v_min_non_paid_realizn 6285 6285 0 0.00 0 12848 28 0 0
v_our_firm 9308 9308 0 0.00 0 20 1 0 0
v_reserve_write_off 17906 17906 0 0.00 0 4378 6 0 0
x_lock_depdocs_on_canc_invoice 8612 8612 0 0.00 0 10986 135 0 0
x_lock_depdocs_on_canc_sup_ord 340 340 0 0.00 0 11368 334 0 0
x_make_qstorno_1000_1200 4886 4886 0 0.00 2 35822 1277 0 0
x_make_qstorno_1200_2000 5001 5001 0 0.00 3 84268 3215 0 0
x_make_qstorno_2100_3300 421519 421519 0 0.00 0 124925 187 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 21-03-2024 01:10:55 to 21-03-2024 01:11:00.

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
23:09:50 3 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:50 29215 8192000000 9897909824 10206621696 987457216 10.757 100 91 182 0 1016965184 5619008 23888960
23:12:30 28978 8192000000 9943854176 10266615808 1025338752 11.124 100 89 178 0 1056887248 8639264 22909232
23:14:06 17855 8192000000 9973850288 10305687552 1053838016 11.397 100 86 172 0 1085473200 10101648 21533536
23:15:27 8029 8192000000 10006518096 10351353856 1099357552 11.832 100 78 156 0 1129117904 10757856 19002496
23:16:39 5065 8192000000 10066878544 10420854784 1153303952 12.340 100 86 172 0 1185789840 11817936 20667952
23:17:46 3814 8192000000 10111164544 10481455104 1205768160 12.830 100 67 131 0 1230994160 10575312 14650688
23:18:52 3485 8192000000 10150098384 10525741056 1240451888 13.150 100 79 155 1 1270881712 13260144 17169680
23:19:57 1801 8192000000 10183599600 10564698112 1271802544 13.438 100 80 158 1 1302186480 12898896 17485040
23:21:01 1092 8192000000 10202350720 10583810048 1288780832 13.593 100 88 173 0 1320113584 12014928 19317824
23:22:06 1362 8192000000 10218518912 10605625344 1305403488 13.744 100 92 185 1 1339378496 13127424 20847584
23:23:09 3637 8192000000 10189254480 10602409984 1307617072 13.764 100 30 60 1 1321108640 6987168 6504400
23:24:15 10393 8192000000 10201420864 10614259712 1316404528 13.844 100 22 42 0 1327498608 6461552 4632528
23:25:30 7455 8192000000 10199700144 10618802176 1319957888 13.876 100 16 32 1 1328947776 5468128 3521760
23:26:42 44979 8192000000 10231459504 10636464128 1324046512 13.913 100 35 71 0 1337875360 5893216 7935632
23:28:28 6971 8192000000 10211845776 10633084928 1313543968 13.818 99 19 38 0 1324614064 6344304 4725792
23:29:36 7858 8192000000 10218002736 10634711040 1314605808 13.828 99 23 46 0 1325707856 5802160 5299888
23:30:53 6867 8192000000 10242730560 10650480640 1333739872 14.001 100 56 109 1 1355438784 9860896 11838016
23:32:18 73633 8192000000 10214163936 10632069120 1305368512 13.744 99 38 74 0 1323423008 10133952 7920544
23:34:40 16784 8192000000 10216420592 10624471040 1285526544 13.563 97 35 70 1 1304977552 10884368 8566640
23:36:26 21149 8192000000 10255354560 10664472576 1331741120 13.983 99 48 96 1 1357345296 14155744 11448432
23:37:53 5305 8192000000 10251518112 10652299264 1328332720 13.952 99 64 125 0 1361364272 18950544 14081008
23:39:16 15199 8192000000 10245908208 10656669696 1318301648 13.861 98 40 79 1 1344878224 17999872 8576704
23:40:36 16262 8192000000 10250324416 10654658560 1321134960 13.887 99 61 120 1 1356135872 20733184 14267728
23:41:55 2821 8192000000 10257569504 10653872128 1322801056 13.902 100 68 135 0 1363365904 24724000 15840848
23:43:05 7157 8192000000 10268991696 10669776896 1328987152 13.958 99 72 139 2 1371030288 25652912 16390224
23:44:44 5173 8192000000 10299446944 10697289728 1344707120 14.100 99 74 144 0 1397864480 35328032 17829328
23:45:59 1066 8192000000 10296706368 10689380352 1337979312 14.039 100 86 172 2 1396802720 38111040 20712368
23:47:04 4913 8192000000 10317934848 10717597696 1362554064 14.260 100 73 146 1 1421557488 40727712 18275712
23:48:12 1882 8192000000 10324374912 10729586688 1368845584 14.317 100 70 138 4 1429209136 43447936 16915616
23:49:18 785 8192000000 10318004896 10725154816 1366857776 14.299 100 83 166 3 1423755024 37155856 19741392
23:50:33 5192 8192000000 10327460544 10734874624 1376519968 14.385 100 74 147 0 1431695872 36818368 18357536
23:51:41 22764 8192000000 10305354544 10738671616 1378864272 14.406 100 26 50 0 1417284432 31595472 6824688
23:53:09 24719 8192000000 10311922672 10735640576 1361426784 14.250 99 26 48 0 1406509824 38204080 6878960
23:54:44 1468 8192000000 10328374928 10750099456 1377858288 14.397 100 65 131 2 1430430832 34899280 17673264
23:55:49 18091 8192000000 10307842688 10752733184 1371886608 14.344 100 17 34 0 1413052336 36314688 4851040
23:57:11 36118 8192000000 10273126304 10734571520 1360885520 14.245 100 10 20 0 1389426960 26199088 2342352
23:58:50 61583 8192000000 10284803232 10733641728 1348274208 14.132 98 10 20 0 1363460256 13166880 2019168
00:00:53 38571 8192000000 10275891680 10722611200 1358542208 14.224 99 13 26 1 1371805504 10294384 2968912
00:02:32 34493 8192000000 10290739488 10733412352 1381269376 14.428 100 22 38 1 1396457088 9941616 5246096
00:04:07 64209 8192000000 10283317184 10732908544 1368435392 14.313 99 37 73 1 1383854560 6749488 8669680
00:06:23 28799 8192000000 10301501520 10747125760 1394574416 14.547 100 32 62 1 1407775648 6035504 7165728
00:07:55 8142 8192000000 10312462544 10751320064 1399652080 14.592 100 40 80 1 1416349664 8165728 8531856
00:09:04 10797 8192000000 10323922640 10761158656 1410440688 14.688 100 55 107 1 1431739472 9343248 11955536
00:10:16 110218 8192000000 10289731696 10741063680 1334261056 14.006 94 21 40 1 1349089808 10270512 4558240
00:13:41 3726 8192000000 10299260960 10738790400 1383622128 14.449 100 33 63 4 1404708688 14526624 6559936
00:14:47 47914 8192000000 10307084960 10751291392 1395220496 14.552 100 39 78 0 1413910800 9722000 8968304
00:16:48 37654 8192000000 10267024352 10734346240 1346663264 14.117 97 11 23 0 1366007952 16168480 3176208
00:18:34 22290 8192000000 10257365504 10710216704 1324984016 13.922 96 19 38 0 1337172976 7624496 4564464
00:20:00 29141 8192000000 10262177536 10699661312 1330112528 13.968 98 24 49 1 1346769328 11236768 5420032
00:21:32 27618 8192000000 10270205104 10703470592 1333612080 14.000 98 31 62 0 1354343504 13863936 6867488
00:23:03 99294 8192000000 10233396432 10678083584 1210957968 12.878 89 19 38 1 1229488640 14232944 4297728
00:25:43 38106 8192000000 10236784560 10665697280 1298830608 13.685 96 32 64 0 1321251072 15137792 7282672
00:27:32 12252 8192000000 10263479072 10696605696 1342635104 14.081 100 40 78 0 1363623264 12062064 8926096
00:28:44 28688 8192000000 10253094640 10686263296 1319509744 13.872 98 26 52 0 1339024304 13717168 5797392
00:30:14 99173 8192000000 10238855392 10683510784 1332225984 13.987 99 31 63 1 1348611136 8493600 7891552
00:32:57 37936 8192000000 10263676688 10705244160 1351143408 14.158 100 33 66 0 1371907184 13038688 7725088
00:34:39 8413 8192000000 10252060256 10685480960 1328190960 13.951 99 44 86 0 1351973408 14273408 9509040
00:35:57 16498 8192000000 10243451776 10685431808 1336925824 14.030 99 24 47 0 1349254704 7451216 4877664
00:37:20 66813 8192000000 10248407360 10697093120 1340350928 14.061 99 16 32 1 1352546688 8427248 3768512
00:39:47 52059 8192000000 10261629200 10722353152 1351266016 14.159 99 8 16 0 1366630512 13883792 1480704
00:41:40 68561 8192000000 10289752672 10746396672 1387929216 14.487 100 19 38 0 1404516864 12567024 4020624
00:43:49 22070 8192000000 10289710704 10740297728 1374969280 14.372 99 33 66 0 1392362144 9805088 7587776
00:45:17 39901 8192000000 10305187984 10755010560 1391907088 14.523 100 35 69 0 1410020016 10362928 7750000
00:47:00 64344 8192000000 10311163552 10770272256 1404503440 14.635 100 27 55 0 1423814432 13069264 6241728
00:49:11 74845 8192000000 10327580608 10785738752 1410445392 14.688 100 26 52 0 1431137328 14482912 6209024
00:51:26 40398 8192000000 10314173504 10771288064 1394789872 14.549 99 24 46 0 1411371024 11615504 4965648
00:53:14 54788 8192000000 10303577104 10774556672 1371495904 14.340 97 10 20 0 1386162704 12566528 2100272
00:55:09 43546 8192000000 10292460160 10749890560 1370646432 14.333 98 29 54 0 1390835328 14251728 5937168
00:57:08 68544 8192000000 10286242464 10744709120 1368059344 14.310 98 23 46 0 1386658992 13527888 5071760
00:59:17 37283 8192000000 10258210192 10724700160 1359341440 14.231 99 3 6 0 1369837392 9947152 548800
01:00:55 31289 8192000000 10263297312 10722000896 1370899648 14.335 100 16 32 0 1382987968 8183696 3904624
01:02:26 50624 8192000000 10259323552 10711588864 1333219024 13.996 98 21 41 0 1349465008 11329008 4916976
01:04:31 75520 8192000000 10262824560 10731827200 1332446320 13.989 98 14 28 0 1352364528 16808784 3109424
01:06:59 53930 8192000000 10264168928 10716680192 1325140480 13.923 97 13 26 0 1342437696 14250912 3046304
01:08:58 51749 8192000000 9320897792 9602109440 472555024 5.453 35 5 10 0 480096912 6281936 1259952

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 21-03-2024 01:11:01 to 21-03-2024 01:11:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 112 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-03-2024 01:11:17 to 21-03-2024 01:11:19.

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          181861
MON$OLDEST_ACTIVE               181862
MON$OLDEST_SNAPSHOT             181862
MON$NEXT_TRANSACTION            181862
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                       1899232
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 21 01:11:20 2024 
 
Database header page information: 
    Flags            0 
    Generation        94816 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    181861 
    Oldest active        181862 
    Oldest snapshot        181862 
    Next transaction    181863 
    Sequence number        0 
    Next attachment ID    730 
    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.08, total records: 7859277 
    Average version length: 48.17, total versions: 133173, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 87144 
    Data pages: 87144, average fill: 72% 
    Primary pages: 87144, secondary pages: 0, swept pages: 14078 
    Empty pages: 0, full pages: 68607 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 14 
    40 - 59% = 471 
    60 - 79% = 86615 
    80 - 99% = 42 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23533, nodes: 7859277 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.05, average data length: 12.95 
    Clustering factor: 1758278, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 390 
        20 - 39% = 1547 
        40 - 59% = 4453 
        60 - 79% = 2138 
        80 - 99% = 15005 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13626, nodes: 7859277 
    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: 1580458, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1487 
        40 - 59% = 2174 
        60 - 79% = 964 
        80 - 99% = 9001 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8402, nodes: 7859277 
    Average node length: 6.64, total dup: 5844388, max dup: 49 
    Average key length: 3.65, compression ratio: 2.46 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1573592, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 807 
        40 - 59% = 1521 
        60 - 79% = 805 
        80 - 99% = 5129 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.79, total records: 2305211 
    Average version length: 34.66, total versions: 130752, max versions: 3 
    Average fragment length: 5.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28424 
    Data pages: 28424, average fill: 75% 
    Primary pages: 28421, secondary pages: 3, swept pages: 7952 
    Empty pages: 2, full pages: 22876 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 11 
    40 - 59% = 238 
    60 - 79% = 26863 
    80 - 99% = 1309 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4611, nodes: 2305211 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 717963, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 882 
        40 - 59% = 885 
        60 - 79% = 652 
        80 - 99% = 2192 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2541, nodes: 2308540 
    Average node length: 4.97, total dup: 2307641, max dup: 21529 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1271311, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 221 
        40 - 59% = 1513 
        60 - 79% = 601 
        80 - 99% = 204 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2061, nodes: 2305211 
    Average node length: 4.97, total dup: 2305161, max dup: 130580 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074255, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 20 
        40 - 59% = 1174 
        60 - 79% = 41 
        80 - 99% = 823 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4420, nodes: 2305211 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 717963, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 539 
        40 - 59% = 672 
        60 - 79% = 751 
        80 - 99% = 2338 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.33, total records: 400 
    Average version length: 22.54, total versions: 255885, max versions: 669 
    Average fragment length: 2.00, total fragments: 54, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 2, data page slots: 1432 
    Data pages: 1432, average fill: 88% 
    Primary pages: 34, secondary pages: 1398, swept pages: 0 
    Empty pages: 27, full pages: 1401 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 1399 
 
    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: 5.58, total records: 146442 
    Average version length: 68.30, total versions: 134476, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 15.76 
    Pointer pages: 6, data page slots: 3048 
    Data pages: 2424, average fill: 75% 
    Primary pages: 2423, secondary pages: 1, swept pages: 0 
    Empty pages: 173, full pages: 1792 
    Fill distribution: 
     0 - 19% = 219 
    20 - 39% = 112 
    40 - 59% = 163 
    60 - 79% = 316 
    80 - 99% = 1614 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1699929, depth: 3, leaf buckets: 405, nodes: 146442 
    Average node length: 13.08, total dup: 12405, max dup: 3 
    Average key length: 10.56, compression ratio: 2.56 
    Average prefix length: 19.35, average data length: 7.65 
    Clustering factor: 106584, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 218 
        60 - 79% = 175 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 19629, max versions: 1006 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 87% 
    Primary pages: 3, secondary pages: 69, swept pages: 0 
    Empty pages: 2, full pages: 69 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 64 
 
    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: 5.11, total records: 2359 
    Average version length: 43.95, total versions: 2091, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 11.36 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 57% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 19 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 17 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90321, depth: 2, leaf buckets: 3, nodes: 2359 
    Average node length: 4.12, total dup: 2261, max dup: 276 
    Average key length: 2.44, compression ratio: 7.79 
    Average prefix length: 18.60, average data length: 0.40 
    Clustering factor: 1180, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        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.08, total records: 76 
    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: 53% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 76 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.73, total records: 786943 
    Average version length: 25.59, total versions: 79272, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 7992, average fill: 69% 
    Primary pages: 7960, secondary pages: 32, swept pages: 1309 
    Empty pages: 120, full pages: 7167 
    Fill distribution: 
     0 - 19% = 227 
    20 - 39% = 168 
    40 - 59% = 142 
    60 - 79% = 7139 
    80 - 99% = 316 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 861, nodes: 786943 
    Average node length: 4.87, total dup: 786894, max dup: 143399 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89001, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 116 
        40 - 59% = 477 
        60 - 79% = 204 
        80 - 99% = 63 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 866, nodes: 786943 
    Average node length: 5.87, total dup: 700493, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157797, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 108 
        40 - 59% = 262 
        60 - 79% = 151 
        80 - 99% = 341 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 901, nodes: 786943 
    Average node length: 5.88, total dup: 700493, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159756, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 197 
        40 - 59% = 218 
        60 - 79% = 138 
        80 - 99% = 348 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1120, nodes: 786943 
    Average node length: 5.96, total dup: 700493, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152993, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 265 
        40 - 59% = 573 
        60 - 79% = 182 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.84, total records: 5481 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.58, total fragments: 84, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 128 
    Data pages: 88, average fill: 62% 
    Primary pages: 71, secondary pages: 17, swept pages: 50 
    Empty pages: 3, full pages: 65 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5481 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.46, average data length: 1.55 
    Clustering factor: 5203, ratio: 0.95 
    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: 5481 
    Average node length: 11.10, 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: 149, 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.08, total records: 83488 
    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: 808 
    Data pages: 808, average fill: 71% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 803 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 803 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34604, depth: 2, leaf buckets: 106, nodes: 83488 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3313, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 105 
 
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: 141.30, total records: 150087 
    Average version length: 152.77, total versions: 9340, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 6, data page slots: 4208 
    Data pages: 3608, average fill: 86% 
    Primary pages: 3608, secondary pages: 0, swept pages: 5 
    Empty pages: 50, full pages: 3547 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3545 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 125.10, total records: 198117 
    Average version length: 154.53, total versions: 33918, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.56 
    Pointer pages: 6, data page slots: 5760 
    Data pages: 4760, average fill: 87% 
    Primary pages: 4759, secondary pages: 1, swept pages: 3 
    Empty pages: 42, full pages: 4705 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4706 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 125.60, total records: 189604 
    Average version length: 154.48, total versions: 31870, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.50 
    Pointer pages: 6, data page slots: 5976 
    Data pages: 4544, average fill: 88% 
    Primary pages: 4543, secondary pages: 1, swept pages: 1 
    Empty pages: 32, full pages: 4502 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4503 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.83, total records: 185417 
    Average version length: 150.44, total versions: 4348, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 6, data page slots: 4872 
    Data pages: 4464, average fill: 86% 
    Primary pages: 4464, secondary pages: 0, swept pages: 13 
    Empty pages: 56, full pages: 4395 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4394 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 145.30, total records: 155433 
    Average version length: 151.77, total versions: 5792, 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: 6, data page slots: 5024 
    Data pages: 3752, average fill: 86% 
    Primary pages: 3752, secondary pages: 0, swept pages: 9 
    Empty pages: 63, full pages: 3672 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 9 
    80 - 99% = 3669 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 126.42, total records: 209095 
    Average version length: 154.63, total versions: 34065, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.42 
    Pointer pages: 7, data page slots: 6048 
    Data pages: 5008, average fill: 88% 
    Primary pages: 5008, secondary pages: 0, swept pages: 6 
    Empty pages: 29, full pages: 4967 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4966 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 146.31, total records: 157906 
    Average version length: 151.37, total versions: 4830, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 6, data page slots: 4480 
    Data pages: 3760, average fill: 87% 
    Primary pages: 3760, secondary pages: 0, swept pages: 6 
    Empty pages: 16, full pages: 3737 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3736 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 136.43, total records: 178917 
    Average version length: 154.54, total versions: 17121, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.43 
    Pointer pages: 6, data page slots: 5664 
    Data pages: 4296, average fill: 87% 
    Primary pages: 4296, secondary pages: 0, swept pages: 4 
    Empty pages: 45, full pages: 4239 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 5 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4239 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 128.11, total records: 191293 
    Average version length: 154.46, total versions: 28890, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.24 
    Pointer pages: 7, data page slots: 5832 
    Data pages: 4608, average fill: 87% 
    Primary pages: 4608, secondary pages: 0, swept pages: 3 
    Empty pages: 52, full pages: 4540 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4540 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 145.39, total records: 156956 
    Average version length: 151.40, total versions: 5386, 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: 6, data page slots: 4864 
    Data pages: 3752, average fill: 86% 
    Primary pages: 3751, secondary pages: 1, swept pages: 6 
    Empty pages: 33, full pages: 3705 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3703 
 
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.48, total records: 2149359 
    Average version length: 52.97, total versions: 51749, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25584 
    Data pages: 25584, average fill: 72% 
    Primary pages: 25584, secondary pages: 0, swept pages: 8950 
    Empty pages: 200, full pages: 22468 
    Fill distribution: 
     0 - 19% = 363 
    20 - 39% = 303 
    40 - 59% = 727 
    60 - 79% = 23726 
    80 - 99% = 465 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2603, nodes: 2149359 
    Average node length: 5.44, total dup: 2006317, max dup: 1290 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185694, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 225 
        40 - 59% = 1758 
        60 - 79% = 312 
        80 - 99% = 305 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2767, nodes: 2149359 
    Average node length: 5.69, total dup: 1929737, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 383835, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 2330 
        60 - 79% = 409 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2222, nodes: 2149359 
    Average node length: 4.96, total dup: 2149259, max dup: 29006 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 183264, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 187 
        40 - 59% = 1250 
        60 - 79% = 407 
        80 - 99% = 378 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 37.48, total records: 147912 
    Average version length: 69.19, total versions: 67828, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.36 
    Pointer pages: 3, data page slots: 4016 
    Data pages: 2704, average fill: 64% 
    Primary pages: 2704, secondary pages: 0, swept pages: 305 
    Empty pages: 407, full pages: 1902 
    Fill distribution: 
     0 - 19% = 546 
    20 - 39% = 65 
    40 - 59% = 66 
    60 - 79% = 686 
    80 - 99% = 1341 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105527, depth: 3, leaf buckets: 215, nodes: 147912 
    Average node length: 6.43, total dup: 128811, max dup: 14 
    Average key length: 3.94, compression ratio: 10.66 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25079, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 107 
        60 - 79% = 58 
        80 - 99% = 17 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.55, total records: 7011227 
    Average version length: 68.75, total versions: 447617, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 60, data page slots: 97808 
    Data pages: 97808, average fill: 77% 
    Primary pages: 97808, secondary pages: 0, swept pages: 17655 
    Empty pages: 86, full pages: 90844 
    Fill distribution: 
     0 - 19% = 391 
    20 - 39% = 506 
    40 - 59% = 1497 
    60 - 79% = 84852 
    80 - 99% = 10562 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10579, nodes: 7011227 
    Average node length: 6.51, total dup: 6066445, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1558924, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1574 
        40 - 59% = 5847 
        60 - 79% = 2646 
        80 - 99% = 504 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8383, nodes: 7011227 
    Average node length: 5.39, total dup: 6733909, max dup: 157 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1348910, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1070 
        40 - 59% = 4724 
        60 - 79% = 1585 
        80 - 99% = 998 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8464, nodes: 7011227 
    Average node length: 5.39, total dup: 6733909, max dup: 157 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1351408, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1167 
        40 - 59% = 4724 
        60 - 79% = 1565 
        80 - 99% = 1001 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.77, total records: 11858956 
    Average version length: 68.79, total versions: 375460, 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: 100, data page slots: 162824 
    Data pages: 162824, average fill: 77% 
    Primary pages: 162824, secondary pages: 0, swept pages: 64199 
    Empty pages: 5, full pages: 160490 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 73 
    40 - 59% = 593 
    60 - 79% = 153489 
    80 - 99% = 8659 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18230, nodes: 11858956 
    Average node length: 6.56, total dup: 10338759, max dup: 78 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2360967, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 2614 
        40 - 59% = 10741 
        60 - 79% = 4005 
        80 - 99% = 842 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 39.32, total records: 1828650 
    Average version length: 69.14, total versions: 788698, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.20 
    Pointer pages: 26, data page slots: 41768 
    Data pages: 28885, average fill: 73% 
    Primary pages: 28885, secondary pages: 0, swept pages: 5160 
    Empty pages: 1695, full pages: 22787 
    Fill distribution: 
     0 - 19% = 2606 
    20 - 39% = 1100 
    40 - 59% = 1307 
    60 - 79% = 10422 
    80 - 99% = 13450 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2310, nodes: 1828650 
    Average node length: 5.51, total dup: 1754739, max dup: 99 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 123981, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 398 
        40 - 59% = 1124 
        60 - 79% = 598 
        80 - 99% = 179 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.51, total records: 1357661 
    Average version length: 69.13, total versions: 619910, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.36 
    Pointer pages: 21, data page slots: 33072 
    Data pages: 25536, average fill: 61% 
    Primary pages: 25536, secondary pages: 0, swept pages: 4552 
    Empty pages: 4621, full pages: 17491 
    Fill distribution: 
     0 - 19% = 5977 
    20 - 39% = 573 
    40 - 59% = 529 
    60 - 79% = 5994 
    80 - 99% = 12463 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1635, nodes: 1357661 
    Average node length: 5.78, total dup: 1268292, max dup: 100 
    Average key length: 2.84, compression ratio: 14.81 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 189565, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 168 
        40 - 59% = 670 
        60 - 79% = 560 
        80 - 99% = 231 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.42, total records: 9539380 
    Average version length: 68.96, total versions: 619880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 88, data page slots: 143560 
    Data pages: 143544, average fill: 71% 
    Primary pages: 143544, secondary pages: 0, swept pages: 43986 
    Empty pages: 216, full pages: 88396 
    Fill distribution: 
     0 - 19% = 697 
    20 - 39% = 3309 
    40 - 59% = 16944 
    60 - 79% = 111753 
    80 - 99% = 10841 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13558, nodes: 9539380 
    Average node length: 6.68, total dup: 7913692, max dup: 25 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2051133, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1036 
        40 - 59% = 6457 
        60 - 79% = 5175 
        80 - 99% = 888 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21190101 
    Average version length: 82.94, total versions: 16492, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319216 
    Data pages: 319216, average fill: 81% 
    Primary pages: 319216, secondary pages: 0, swept pages: 12791 
    Empty pages: 0, full pages: 319133 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 27373 
    80 - 99% = 291836 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19473, nodes: 21190101 
    Average node length: 5.72, total dup: 20708226, max dup: 131 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288374, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8241 
        60 - 79% = 577 
        80 - 99% = 10648 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17250, nodes: 21190101 
    Average node length: 6.31, total dup: 18620327, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917883, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 3 
        40 - 59% = 839 
        60 - 79% = 305 
        80 - 99% = 16098 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21259, nodes: 21190101 
    Average node length: 6.35, total dup: 18540377, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3583656, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8532 
        60 - 79% = 596 
        80 - 99% = 12124 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16257, nodes: 21190101 
    Average node length: 5.56, total dup: 21190001, max dup: 233735 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946675, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 3099 
        60 - 79% = 452 
        80 - 99% = 12697 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.11, total records: 9893750 
    Average version length: 82.60, total versions: 517498, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 105, data page slots: 171360 
    Data pages: 171328, average fill: 71% 
    Primary pages: 171328, secondary pages: 0, swept pages: 68828 
    Empty pages: 370, full pages: 101673 
    Fill distribution: 
     0 - 19% = 1185 
    20 - 39% = 5366 
    40 - 59% = 24248 
    60 - 79% = 76603 
    80 - 99% = 63926 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11394, nodes: 9893750 
    Average node length: 5.37, total dup: 9582698, max dup: 199 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2166092, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 38 
        40 - 59% = 7745 
        60 - 79% = 3447 
        80 - 99% = 157 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13860, nodes: 9893750 
    Average node length: 6.24, total dup: 8202325, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1494245, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 4361 
        40 - 59% = 4232 
        60 - 79% = 2480 
        80 - 99% = 2660 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12723, nodes: 9893750 
    Average node length: 5.98, total dup: 8588524, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2359243, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 35 
        40 - 59% = 8690 
        60 - 79% = 3806 
        80 - 99% = 188 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10231, nodes: 9893750 
    Average node length: 5.14, total dup: 9893650, max dup: 162672 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1537121, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1164 
        40 - 59% = 5107 
        60 - 79% = 1678 
        80 - 99% = 2243 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.60, total records: 11660574 
    Average version length: 82.52, total versions: 385660, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 120, data page slots: 194384 
    Data pages: 193080, average fill: 74% 
    Primary pages: 193080, secondary pages: 0, swept pages: 66973 
    Empty pages: 2421, full pages: 150024 
    Fill distribution: 
     0 - 19% = 4073 
    20 - 39% = 6180 
    40 - 59% = 16103 
    60 - 79% = 42407 
    80 - 99% = 124317 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13169, nodes: 11660574 
    Average node length: 5.31, total dup: 11550085, max dup: 696 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2430971, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 78 
        40 - 59% = 8415 
        60 - 79% = 4363 
        80 - 99% = 309 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10691, nodes: 11660574 
    Average node length: 5.50, total dup: 11153100, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 736895, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 835 
        40 - 59% = 2594 
        60 - 79% = 1844 
        80 - 99% = 5262 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15057, nodes: 11660574 
    Average node length: 6.03, total dup: 10182808, max dup: 62 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2447482, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 111 
        40 - 59% = 9794 
        60 - 79% = 4779 
        80 - 99% = 368 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11123, nodes: 11660574 
    Average node length: 5.23, total dup: 11660474, max dup: 213268 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 724982, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 808 
        40 - 59% = 5111 
        60 - 79% = 1459 
        80 - 99% = 3643 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.33, total records: 10031712 
    Average version length: 82.89, total versions: 534501, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 108, data page slots: 175232 
    Data pages: 175200, average fill: 71% 
    Primary pages: 175200, secondary pages: 0, swept pages: 70863 
    Empty pages: 396, full pages: 101668 
    Fill distribution: 
     0 - 19% = 1221 
    20 - 39% = 5882 
    40 - 59% = 26493 
    60 - 79% = 77609 
    80 - 99% = 63995 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12078, nodes: 10031712 
    Average node length: 5.18, total dup: 10002390, max dup: 2421 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1971172, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1398 
        40 - 59% = 8137 
        60 - 79% = 1882 
        80 - 99% = 622 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13974, nodes: 10031712 
    Average node length: 6.25, total dup: 8316396, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1460812, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 185 
        20 - 39% = 4316 
        40 - 59% = 4145 
        60 - 79% = 2494 
        80 - 99% = 2834 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12744, nodes: 10031712 
    Average node length: 5.44, total dup: 9583981, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2108676, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1353 
        40 - 59% = 9115 
        60 - 79% = 1662 
        80 - 99% = 592 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10449, nodes: 10031712 
    Average node length: 5.16, total dup: 10031612, max dup: 166186 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1559178, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1246 
        40 - 59% = 5275 
        60 - 79% = 1680 
        80 - 99% = 2207 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.19, total records: 586213 
    Average version length: 68.83, total versions: 8502, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 77% 
    Primary pages: 8016, secondary pages: 0, swept pages: 3283 
    Empty pages: 1, full pages: 7386 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 8 
    40 - 59% = 68 
    60 - 79% = 7765 
    80 - 99% = 174 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41987, depth: 3, leaf buckets: 752, nodes: 586213 
    Average node length: 5.95, total dup: 499164, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102195, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 529 
        60 - 79% = 113 
        80 - 99% = 80 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32994, depth: 3, leaf buckets: 764, nodes: 586213 
    Average node length: 6.15, total dup: 480817, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102247, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 522 
        60 - 79% = 107 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 587, nodes: 586213 
    Average node length: 4.86, total dup: 586113, max dup: 9745 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90639, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 363 
        60 - 79% = 87 
        80 - 99% = 114 
 
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 21 01:11:44 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7859277 133173 1 0.0000 0.0000
DOC_LIST 2305211 130752 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 255885 669 63900.0000 0.0000
INVNT_TURNOVER_LOG 146442 134476 1 0.0000 0.0000
MONEY_SALDO 49 19629 1006 40000.0000 0.0000
MONEY_TURNOVER_LOG 2359 2091 1 0.0000 0.0000
PDISTR 786943 79272 4 0.0000 0.0000
PERF_SPLIT_0 150087 9340 1 0.0000 0.0000
PERF_SPLIT_1 198117 33918 1 0.0000 0.0000
PERF_SPLIT_2 189604 31870 1 0.0000 0.0000
PERF_SPLIT_3 185417 4348 1 0.0000 0.0000
PERF_SPLIT_4 155433 5792 1 0.0000 0.0000
PERF_SPLIT_5 209095 34065 1 0.0000 0.0000
PERF_SPLIT_6 157906 4830 1 0.0000 0.0000
PERF_SPLIT_7 178917 17121 1 0.0000 0.0000
PERF_SPLIT_8 191293 28890 1 0.0000 0.0000
PERF_SPLIT_9 156956 5386 1 0.0000 0.0000
PSTORNED 2149359 51749 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 147912 67828 1 0.0000 0.0000
XQD_1000_3300 7011227 447617 1 0.0000 0.0000
XQD_1200_2000 11858956 375460 1 0.0000 0.0000
XQD_2000_3300 1828650 788698 1 0.0000 0.0000
XQD_2100_3300 1357661 619910 1 0.0000 0.0000
XQD_3300_3400 9539380 619880 1 0.0000 0.0000
XQS_1000_1200 21190101 16492 1 0.0000 0.0000
XQS_1000_3300 9893750 517498 1 0.0000 0.0000
XQS_1200_2000 11660574 385660 1 0.0000 0.0000
XQS_2100_3300 10031712 534501 1 0.0000 0.0000
XQS_3300_3400 586213 8502 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 ---
:49: 
:50: mscs-test-161.budzdorov.ru    Thu Mar 21 01:09:52 2024
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
:53: 
:54: mscs-test-161.budzdorov.ru    Thu Mar 21 01:09:52 2024
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
:57: 
:58: mscs-test-161.budzdorov.ru    Thu Mar 21 01:09:57 2024
:59:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:60: 
:61: 
:62: mscs-test-161.budzdorov.ru    Thu Mar 21 01:09:57 2024
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
--- end of diff output ---

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

21.03.24 01:11:55. 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-21 01:11:58 No severe PSQL-related problems occured
21.03.24 01:11:59. End of report.