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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-21 19:09:37
DTS_END                         2024-02-21 19:09:37.1970
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37940
TRN_ID                          171406
ATT_ID                          573
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: 9061.11 23542 906111
customer order: creation 169.02 382 16902
customer order: refuse 14.69 366 1469
order to supplier: creation 45.08 1274 4508
order to supplier: removal 3.31 108527 331
invoice (draft): creation 45.38 3169 4538
invoice (draft): removal 50.40 836 5040
invoice accept: apply 41.64 21529 4164
invoice accept: cancel 44.99 824 4499
customer reserve: creation 3957.74 209 395774
customer reserve: removal 4402.85 64 440285
realization accept: apply 82.27 172 8227
realization accept: cancel 74.80 116 7480
payment from customer: creation 58.84 131 5884
payment from customer: removal 5.70 63 570
payment to supplier: creation 48.71 152 4871
payment to supplier: removal 3.49 69 349
service: total inventory turnovers 4.67 1182 467
service: total monetary turnovers 6.61 29 661
service: aggregate perf. data 0.89 22460 89
service: refresh index statistics 0.03 309286 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 21-02-2024 19:10:42 to 21-02-2024 19:10:45.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3569
TEST_TIME 2 3699
TEST_TIME 3 4635
TEST_TIME 4 4425
TEST_TIME 5 4935
TEST_TIME 6 4597
TEST_TIME 7 5237
TEST_TIME 8 5477
TEST_TIME 9 5273
TEST_TIME 10 5605
TEST_TIME 11 6141
TEST_TIME 12 6504
TEST_TIME 13 6409
TEST_TIME 14 6547
TEST_TIME 15 6526
TEST_TIME 16 6506
TEST_TIME 17 6741
TEST_TIME 18 7466
TEST_TIME 19 7670
TEST_TIME 20 7474
TEST_TIME 21 7785
TEST_TIME 22 7662
TEST_TIME 23 7915
TEST_TIME 24 7877
TEST_TIME 25 8183
TEST_TIME 26 8270
TEST_TIME 27 8445
TEST_TIME 28 8564
TEST_TIME 29 8915
TEST_TIME 30 9485
TEST_TIME 31 9247
TEST_TIME 32 9462
TEST_TIME 33 9261
TEST_TIME 34 9188
TEST_TIME 35 9276
TEST_TIME 36 9267
TEST_TIME 37 9136
TEST_TIME 38 9110
TEST_TIME 39 9064
TEST_TIME 40 8969
TEST_TIME 41 8978
TEST_TIME 42 9167
TEST_TIME 43 9117
TEST_TIME 44 9133
TEST_TIME 45 9092
TEST_TIME 46 8999
TEST_TIME 47 8876
TEST_TIME 48 8747
TEST_TIME 49 8747
TEST_TIME 50 8732
TEST_TIME 51 8711
TEST_TIME 52 8714
TEST_TIME 53 8689
TEST_TIME 54 8705
TEST_TIME 55 8740
TEST_TIME 56 8731
TEST_TIME 57 8733
TEST_TIME 58 8744
TEST_TIME 59 8902
TEST_TIME 60 8860
TEST_TIME 61 8996
TEST_TIME 62 8964
TEST_TIME 63 8983
TEST_TIME 64 9050
TEST_TIME 65 9053
TEST_TIME 66 9092
TEST_TIME 67 8972
TEST_TIME 68 8977
TEST_TIME 69 8916
TEST_TIME 70 8907
TEST_TIME 71 8931
TEST_TIME 72 8852
TEST_TIME 73 8781
TEST_TIME 74 8796
TEST_TIME 75 8784
TEST_TIME 76 8836
TEST_TIME 77 8887
TEST_TIME 78 8978
TEST_TIME 79 9042
TEST_TIME 80 9085
TEST_TIME 81 9049
TEST_TIME 82 9018
TEST_TIME 83 9079
TEST_TIME 84 9112
TEST_TIME 85 9159
TEST_TIME 86 9192
TEST_TIME 87 9200
TEST_TIME 88 9176
TEST_TIME 89 9120
TEST_TIME 90 9075
TEST_TIME 91 9070
TEST_TIME 92 9069
TEST_TIME 93 8999
TEST_TIME 94 9002
TEST_TIME 95 8999
TEST_TIME 96 9080
TEST_TIME 97 9056
TEST_TIME 98 9072
TEST_TIME 99 9105
TEST_TIME 100 9065

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-02-2024 19:10:46 to 21-02-2024 19:10:49.

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 1267947 1267947 0 0.00 0 26047 7 0 0
doc_list_biud 1267944 1267944 0 0.00 0 30449 28 0 0
sp_add_invoice_to_stock 4252 4164 88 2.06 21 226832 21529 0 88
sp_cancel_adding_invoice 4499 4499 0 0.00 3 58316 824 0 0
sp_cancel_client_order 1469 1469 0 0.00 5 7928 366 0 0
sp_cancel_customer_reserve 440285 440285 0 0.00 0 23479 65 0 0
sp_cancel_pay_from_customer 570 570 0 0.00 2 1523 63 0 0
sp_cancel_pay_to_supplier 349 349 0 0.00 3 1801 69 0 0
sp_cancel_supplier_invoice 5047 5040 7 0.13 1 25207 837 0 7
sp_cancel_supplier_order 331 331 0 0.00 8 778500 108528 0 0
sp_cancel_write_off 7480 7480 0 0.00 1 8891 117 0 0
sp_client_order 16902 16902 0 0.00 3 24712 382 0 0
sp_customer_reserve 395774 395774 0 0.00 0 52098 209 0 0
sp_fill_shopping_cart 25942 25942 0 0.00 1 9135 38 0 0
sp_fill_shopping_cart_clo_res 395763 395763 0 0.00 0 20336 14 0 0
sp_get_clo_for_invoice 4153 4153 0 0.00 0 14434 317 0 0
sp_kill_cost_storno 12898 12898 0 0.00 0 21074 67 0 0
sp_kill_qstorno_ret_qs2qd 893421 893421 0 0.00 0 25182 35 0 0
sp_kill_qty_storno 471484 471484 0 0.00 0 30447 75 0 0
sp_lock_selected_doc 17160 17160 0 0.00 0 7185 5 0 0
sp_make_cost_storno 23135 23135 0 0.00 0 26020 57 0 0
sp_multiply_rows_for_pdistr 23135 23135 0 0.00 0 6470 29 0 0
sp_multiply_rows_for_qdistr 16902 16902 0 0.00 0 10296 172 0 0
sp_pay_from_customer 5884 5884 0 0.00 4 17239 132 0 0
sp_pay_to_supplier 4871 4871 0 0.00 5 17353 153 0 0
sp_payment_common 10755 10755 0 0.00 1 7694 30 0 0
sp_qd_handle_on_cancel_clo 1469 1469 0 0.00 0 7920 332 0 0
sp_qd_handle_on_invoice_upd_sts 8652 8652 0 0.00 0 30443 327 0 0
sp_qd_handle_on_reserve_upd_sts 8227 8227 0 0.00 0 7981 52 0 0
sp_reserve_write_off 8227 8227 0 0.00 6 26054 172 0 0
sp_supplier_invoice 4538 4538 0 0.00 6 74287 3170 0 0
sp_supplier_order 4508 4508 0 0.00 5 65815 1275 0 0
srv_aggregate_perf_data 89 89 0 0.00 1594 245227 22460 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 2920 111155 39896 0 0
srv_find_qd_qs_mism 863884 863884 0 0.00 0 11553 6 0 0
srv_make_invnt_saldo 467 467 0 0.00 45 88665 1183 0 0
srv_make_money_saldo 661 661 0 0.00 1 1204 29 0 0
srv_recalc_idx_stat 3 3 0 0.00 255314 375639 309287 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4164 4164 0 0.00 0 11293 202 0 0
t$perf-norm:sp_cancel_adding_invoice 318 318 0 0.00 0 3019 97 0 0
t$perf-norm:sp_cancel_client_order 1469 1469 0 0.00 0 870 8 0 0
t$perf-norm:sp_cancel_customer_reserve 575 575 0 0.00 0 1457 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 570 570 0 0.00 0 2077 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 349 349 0 0.00 0 318 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 320 320 0 0.00 0 855 16 0 0
t$perf-norm:sp_cancel_supplier_order 331 331 0 0.00 0 37518 1977 0 0
t$perf-norm:sp_cancel_write_off 849 849 0 0.00 0 2438 11 0 0
t$perf-norm:sp_client_order 16902 16902 0 0.00 0 8579 17 0 0
t$perf-norm:sp_customer_reserve 804 804 0 0.00 0 478 4 0 0
t$perf-norm:sp_pay_from_customer 5884 5884 0 0.00 0 8683 9 0 0
t$perf-norm:sp_pay_to_supplier 4871 4871 0 0.00 0 5530 10 0 0
t$perf-norm:sp_reserve_write_off 8227 8227 0 0.00 0 26915 17 0 0
t$perf-norm:sp_supplier_invoice 4538 4538 0 0.00 0 10398 19 0 0
t$perf-norm:sp_supplier_order 4508 4508 0 0.00 0 5361 16 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 208 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 424 19 0 0
t$perf-norm:srv_make_invnt_saldo 467 467 0 0.00 0 677 19 0 0
t$perf-norm:srv_make_money_saldo 661 661 0 0.00 0 8686 32 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 8 5 0 0
v_add_invoice_to_stock 8480 8304 176 2.07 0 6084 24 0 176
v_all_customers 31284 31284 0 0.00 0 64 1 0 0
v_all_suppliers 25496 25496 0 0.00 0 62 1 0 0
v_all_wares 33802 33802 0 0.00 0 90 1 0 0
v_cancel_adding_invoice 636 636 0 0.00 0 987 9 0 0
v_cancel_client_order 2938 2938 0 0.00 0 4680 7 0 0
v_cancel_customer_prepayment 1140 1140 0 0.00 0 1037 5 0 0
v_cancel_customer_reserve 1150 1150 0 0.00 0 9829 16 0 0
v_cancel_payment_to_supplier 698 698 0 0.00 0 967 7 0 0
v_cancel_supplier_invoice 654 640 14 2.14 0 4118 22 0 14
v_cancel_supplier_order 662 662 0 0.00 0 4795 13 0 0
v_cancel_write_off 1698 1698 0 0.00 0 8367 26 0 0
v_max_id_clo_ord 4508 4508 0 0.00 0 563 1 0 0
v_max_id_clo_res 804 804 0 0.00 0 4520 12 0 0
v_max_id_ord_sup 4533 4533 0 0.00 0 2822 3 0 0
v_max_non_paid_invoice 1164 1164 0 0.00 0 40 2 0 0
v_max_non_paid_realizn 2903 2903 0 0.00 0 4743 8 0 0
v_min_id_clo_ord 4508 4508 0 0.00 0 3990 6 0 0
v_min_id_clo_res 804 804 0 0.00 0 5767 27 0 0
v_min_id_ord_sup 4533 4533 0 0.00 0 2170 3 0 0
v_min_non_paid_invoice 4871 4871 0 0.00 0 7682 24 0 0
v_min_non_paid_realizn 5884 5884 0 0.00 0 6877 21 0 0
v_our_firm 8480 8480 0 0.00 0 27 1 0 0
v_reserve_write_off 16454 16454 0 0.00 0 8347 9 0 0
x_lock_depdocs_on_canc_invoice 9219 9219 0 0.00 0 15663 130 0 0
x_lock_depdocs_on_canc_sup_ord 331 331 0 0.00 0 3665 355 0 0
x_make_qstorno_1000_1200 4508 4508 0 0.00 1 65789 1201 0 0
x_make_qstorno_1200_2000 4538 4538 0 0.00 3 74279 3024 0 0
x_make_qstorno_2100_3300 395774 395774 0 0.00 0 52070 192 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-02-2024 19:10:50 to 21-02-2024 19:10:54.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:41 4 8192000000 8799615728 8811282432 5842960 0.071 3 1 2 0 5943888 58144 42784
17:10:42 28069 8192000000 9893764992 10202357760 970533504 10.592 100 90 180 0 1000053216 6129792 23389920
17:12:18 17056 8192000000 9941785312 10261479424 1020472352 11.077 100 92 184 0 1052689056 8677984 23538720
17:13:43 18867 8192000000 9970246944 10298335232 1046917936 11.331 100 87 174 0 1077538064 9689552 20930576
17:15:07 9785 8192000000 10010758608 10355339264 1092221888 11.764 100 76 148 1 1120575184 10579088 17774208
17:16:24 7683 8192000000 10068842576 10427211776 1156537936 12.371 100 78 156 0 1186519040 12154624 17826480
17:17:34 5034 8192000000 10109222704 10475253760 1201663072 12.792 100 80 160 0 1233119120 13640720 17815328
17:18:41 1577 8192000000 10138777648 10509443072 1226819728 13.025 100 81 162 0 1258153056 13720432 17612896
17:19:46 4220 8192000000 10171588592 10549022720 1254702880 13.281 100 80 160 0 1285163024 13779088 16681056
17:20:52 1225 8192000000 10199947520 10581487616 1291030768 13.614 100 86 171 0 1322133120 11690144 19412208
17:21:54 46787 8192000000 10192212032 10597531648 1296186752 13.661 100 52 99 2 1314988816 6154128 12647936
17:23:42 12175 8192000000 10182702944 10598432768 1300233392 13.697 100 18 35 0 1309615200 5600768 3781040
17:24:57 10050 8192000000 10193638704 10612170752 1312825200 13.812 100 13 26 0 1321329152 5907264 2596688
17:26:12 8973 8192000000 10203330304 10623774720 1321554576 13.891 100 14 28 1 1330192992 5592800 3045616
17:27:25 9625 8192000000 10209968240 10631041024 1316789392 13.848 99 15 31 0 1325983344 5597360 3596592
17:28:35 43280 8192000000 10214264864 10629709824 1323326352 13.907 100 49 95 1 1339538576 5175104 11037120
17:30:35 33146 8192000000 10228604160 10636685312 1324544752 13.918 100 51 100 0 1344986432 9540608 10901072
17:32:19 4012 8192000000 10240655904 10649681920 1337980496 14.039 100 52 101 2 1359286288 10197664 11108128
17:33:28 7909 8192000000 10254833744 10659246080 1331786016 13.983 99 70 138 1 1360558720 13727088 15045616
17:34:42 9449 8192000000 10251600128 10660511744 1334214144 14.005 99 48 97 0 1360034240 14478656 11341440
17:35:56 22836 8192000000 10241823552 10655670272 1314880976 13.830 98 34 68 0 1340150512 16935232 8334304
17:37:43 32665 8192000000 10227829744 10641444864 1307645280 13.765 98 26 50 0 1327397600 13964400 5787920
17:39:21 6204 8192000000 10249100896 10654642176 1324329056 13.916 99 51 102 0 1356900016 20990032 11580928
17:40:32 5650 8192000000 10242543488 10646380544 1295433424 13.654 97 51 102 0 1328869360 21203296 12232640
17:41:43 9409 8192000000 10243123392 10641338368 1304287696 13.734 99 60 117 0 1346789712 29383024 13118992
17:43:01 17203 8192000000 10229167472 10629906432 1305478688 13.745 99 52 101 2 1342116976 24568832 12069456
17:44:24 7836 8192000000 10261519424 10670977024 1328045920 13.949 99 56 112 0 1364807728 23216272 13545536
17:45:36 3247 8192000000 10260797760 10655567872 1322454768 13.899 100 76 150 3 1369060256 27676432 18929056
17:46:44 3812 8192000000 10291873792 10690736128 1346955488 14.120 100 76 149 0 1398231568 33067744 18208336
17:47:53 2917 8192000000 10282477648 10685292544 1345475056 14.107 100 62 120 1 1385753808 25185184 15093568
17:49:00 10736 8192000000 10297564112 10716577792 1372486048 14.349 100 40 77 1 1407364448 25063744 9814656
17:50:15 5356 8192000000 10326539360 10732548096 1380473536 14.421 100 62 124 0 1431307728 35493088 15341104
17:51:25 8367 8192000000 10342417936 10758868992 1394728256 14.548 100 54 107 0 1447972656 39796784 13447616
17:52:40 14867 8192000000 10342964272 10770231296 1409501872 14.680 100 42 84 0 1457910160 37526016 10882272
17:54:11 29010 8192000000 10351354016 10787074048 1406873792 14.656 100 25 50 0 1450336400 35942944 7519664
17:55:45 16840 8192000000 10332301040 10780401664 1403353872 14.625 100 21 42 0 1446228656 36768976 6105808
17:57:06 24807 8192000000 10332747872 10780065792 1386956064 14.479 100 18 36 0 1438995920 46430640 5609216
17:58:38 10952 8192000000 10337098656 10782887936 1393585008 14.538 100 35 70 0 1446028272 43309024 9134240
18:00:06 48736 8192000000 10325833024 10760056832 1389040656 14.497 99 47 93 3 1414123120 14998160 10084304
18:02:01 103895 8192000000 10294947344 10748952576 1380890224 14.425 99 26 51 1 1393521056 7307024 5323808
18:05:03 81910 8192000000 10304680640 10758291456 1383905920 14.451 99 20 35 1 1402054992 13775696 4373376
18:07:34 88520 8192000000 10330110176 10780557312 1413913952 14.719 100 22 44 1 1439019792 19359952 5745888
18:10:06 4662 8192000000 10338206864 10779791360 1419988560 14.773 100 57 109 1 1446467104 13492528 12986016
18:11:11 53593 8192000000 10321046288 10791190528 1412594080 14.707 100 13 26 0 1434240624 18785040 2861504
18:13:10 6799 8192000000 10316084128 10766577664 1412439456 14.706 100 36 72 1 1434407792 13783152 8185184
18:14:27 22586 8192000000 10288053696 10749046784 1396253888 14.562 100 3 6 0 1403810592 7202624 354080
18:15:51 51692 8192000000 10298524528 10761191424 1407222144 14.659 100 12 24 1 1416424656 6473200 2729312
18:18:12 56901 8192000000 10303221568 10774343680 1398582432 14.582 99 14 29 0 1414994992 13384624 3027936
18:20:12 43247 8192000000 10298511680 10766974976 1403625680 14.627 100 14 28 0 1416374000 9605776 3142544
18:22:35 61300 8192000000 10274658192 10733326336 1350822368 14.155 96 18 34 1 1371359440 16798080 3738992
18:24:37 47589 8192000000 10278235472 10734555136 1375243376 14.374 99 16 32 0 1389457680 10562496 3651808
18:26:35 30035 8192000000 10282159376 10719760384 1339010336 14.048 98 33 66 1 1359293744 12886848 7396560
18:28:08 38848 8192000000 10262435696 10716033024 1299873728 13.694 95 23 44 0 1322041392 16972800 5194864
18:29:56 64572 8192000000 10241979968 10689126400 1277314768 13.488 95 21 42 0 1295504320 13409056 4780496
18:32:02 26686 8192000000 10239263472 10669023232 1302945760 13.722 98 33 67 0 1321718752 11635088 7137904
18:33:56 60373 8192000000 10246684400 10681040896 1308455136 13.772 97 12 24 0 1319746048 8763088 2527824
18:36:03 86053 8192000000 10225462592 10660208640 1294789696 13.648 97 35 69 1 1313479232 10706752 7982784
18:38:29 57097 8192000000 10254390448 10684772352 1339212672 14.050 100 29 58 0 1355433904 9730896 6490336
18:40:31 51314 8192000000 10265557552 10714587136 1366892736 14.299 100 9 18 0 1380173264 11587792 1692736
18:42:24 63764 8192000000 10285095248 10733731840 1352641728 14.171 98 16 32 0 1370912528 14375872 3894928
18:44:42 56854 8192000000 10304591312 10753818624 1393220000 14.535 100 27 53 0 1421255136 21678192 6356944
18:46:41 53382 8192000000 10302389120 10755674112 1392499152 14.528 99 23 46 0 1409783888 11852144 5432592
18:48:35 49830 8192000000 10299291216 10743066624 1356897392 14.209 97 22 44 0 1370270080 8605296 4767392
18:50:26 33812 8192000000 10326264384 10763120640 1383506288 14.448 99 38 76 2 1405334096 13420032 8407776
18:52:01 63810 8192000000 10325433616 10768461824 1392472080 14.528 99 38 77 0 1418457344 17649376 8335888
18:54:06 111154 8192000000 10334649200 10788507648 1414319744 14.722 100 8 17 0 1429246048 13168432 1757872
18:57:04 94817 8192000000 10326769152 10778710016 1414352288 14.723 100 21 43 0 1430809200 11784896 4672016
18:59:39 40242 8192000000 10300466032 10746998784 1386295792 14.473 98 28 56 0 1403960912 11905008 5760112
19:01:20 61924 8192000000 10317526560 10781032448 1407432832 14.661 99 13 26 0 1427190384 16397584 3359968
19:03:27 31707 8192000000 10327401824 10790502400 1423683440 14.805 100 21 42 1 1443679168 14709376 5286352
19:05:15 107585 8192000000 10322169136 10798706688 1391164096 14.516 98 11 22 0 1413843472 19924288 2755088
19:08:07 91567 8192000000 9262792560 9528610816 147892240 1.773 11 3 6 0 149448224 950720 605264

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 21-02-2024 19:10:56 to 21-02-2024 19:11:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 88 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

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

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          170654
MON$OLDEST_ACTIVE               171699
MON$OLDEST_SNAPSHOT             171699
MON$NEXT_TRANSACTION            171699
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                       1890944
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Wed Feb 21 19:11:14 2024 
 
Database header page information: 
    Flags            0 
    Generation        89589 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    170654 
    Oldest active        171699 
    Oldest snapshot        171699 
    Next transaction    171700 
    Sequence number        0 
    Next attachment ID    700 
    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.19, total records: 7747944 
    Average version length: 48.16, total versions: 113498, 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: 86744 
    Data pages: 86744, average fill: 71% 
    Primary pages: 86744, secondary pages: 0, swept pages: 17498 
    Empty pages: 4, full pages: 63449 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 253 
    40 - 59% = 2322 
    60 - 79% = 84107 
    80 - 99% = 33 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23128, nodes: 7747944 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1721079, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 346 
        20 - 39% = 1722 
        40 - 59% = 3977 
        60 - 79% = 2352 
        80 - 99% = 14731 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13438, nodes: 7747944 
    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: 1544495, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1543 
        40 - 59% = 1952 
        60 - 79% = 1089 
        80 - 99% = 8854 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8266, nodes: 7747944 
    Average node length: 6.62, total dup: 5793453, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1537484, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 120 
        20 - 39% = 919 
        40 - 59% = 1328 
        60 - 79% = 912 
        80 - 99% = 4987 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.95, total records: 2243364 
    Average version length: 34.63, total versions: 115949, max versions: 3 
    Average fragment length: 6.40, total fragments: 5, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28544 
    Data pages: 28544, average fill: 73% 
    Primary pages: 28536, secondary pages: 8, swept pages: 9354 
    Empty pages: 8, full pages: 20573 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 148 
    40 - 59% = 2155 
    60 - 79% = 25128 
    80 - 99% = 1082 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4519, nodes: 2243364 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 695308, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 906 
        40 - 59% = 798 
        60 - 79% = 715 
        80 - 99% = 2100 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2517, nodes: 2246319 
    Average node length: 4.97, total dup: 2245420, max dup: 21129 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1242575, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 277 
        40 - 59% = 1528 
        60 - 79% = 528 
        80 - 99% = 182 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2042, nodes: 2243364 
    Average node length: 4.97, total dup: 2243314, max dup: 130093 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1060609, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 114 
        40 - 59% = 1039 
        60 - 79% = 44 
        80 - 99% = 839 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4308, nodes: 2243364 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 695308, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 82 
        20 - 39% = 584 
        40 - 59% = 588 
        60 - 79% = 836 
        80 - 99% = 2218 
 
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.06, total records: 400 
    Average version length: 23.20, total versions: 228242, max versions: 591 
    Average fragment length: 2.00, total fragments: 67, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1424 
    Data pages: 1288, average fill: 89% 
    Primary pages: 10, secondary pages: 1278, swept pages: 0 
    Empty pages: 3, full pages: 1284 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1283 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 7.34, total records: 183185 
    Average version length: 68.30, total versions: 163506, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 11.99 
    Pointer pages: 7, data page slots: 3136 
    Data pages: 2816, average fill: 80% 
    Primary pages: 2815, secondary pages: 1, swept pages: 0 
    Empty pages: 204, full pages: 2419 
    Fill distribution: 
     0 - 19% = 252 
    20 - 39% = 39 
    40 - 59% = 58 
    60 - 79% = 202 
    80 - 99% = 2265 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1701773, depth: 3, leaf buckets: 414, nodes: 183185 
    Average node length: 13.02, total dup: 15684, max dup: 3 
    Average key length: 10.45, compression ratio: 2.58 
    Average prefix length: 19.46, average data length: 7.54 
    Clustering factor: 130647, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 54 
        60 - 79% = 272 
        80 - 99% = 86 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 16891, max versions: 956 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 85% 
    Primary pages: 4, secondary pages: 60, swept pages: 0 
    Empty pages: 3, full pages: 60 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 59 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 1.91, total records: 2901 
    Average version length: 43.62, total versions: 2778, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 30.42 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 26 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 24 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92502, depth: 2, leaf buckets: 4, nodes: 2901 
    Average node length: 4.07, total dup: 2803, max dup: 315 
    Average key length: 2.37, compression ratio: 8.02 
    Average prefix length: 18.66, average data length: 0.34 
    Clustering factor: 1482, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, 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: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    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.60, total records: 825756 
    Average version length: 25.66, total versions: 88502, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 6, data page slots: 8256 
    Data pages: 8256, average fill: 70% 
    Primary pages: 8227, secondary pages: 29, swept pages: 1354 
    Empty pages: 81, full pages: 7746 
    Fill distribution: 
     0 - 19% = 162 
    20 - 39% = 105 
    40 - 59% = 134 
    60 - 79% = 7424 
    80 - 99% = 431 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 895, nodes: 825756 
    Average node length: 4.87, total dup: 825707, max dup: 154612 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89579, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 103 
        40 - 59% = 516 
        60 - 79% = 206 
        80 - 99% = 70 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 953, nodes: 825756 
    Average node length: 5.88, total dup: 735416, max dup: 46 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161201, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 103 
        40 - 59% = 419 
        60 - 79% = 122 
        80 - 99% = 307 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1012, nodes: 825756 
    Average node length: 5.88, total dup: 735416, max dup: 46 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163177, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 202 
        40 - 59% = 411 
        60 - 79% = 83 
        80 - 99% = 315 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1152, nodes: 825756 
    Average node length: 5.96, total dup: 735416, max dup: 46 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155764, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 225 
        40 - 59% = 612 
        60 - 79% = 226 
        80 - 99% = 88 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5423 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.91, total fragments: 90, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 176 
    Data pages: 160, average fill: 34% 
    Primary pages: 131, secondary pages: 29, swept pages: 52 
    Empty pages: 65, full pages: 63 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 65 
    80 - 99% = 2 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5423 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.36, average data length: 1.55 
    Clustering factor: 5136, 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: 5423 
    Average node length: 11.13, 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: 156, 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.18, total records: 77966 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 752 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 752 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38895, depth: 2, leaf buckets: 100, nodes: 77966 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2997, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.62, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 139.11, total records: 174128 
    Average version length: 155.29, total versions: 13679, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.19 
    Pointer pages: 6, data page slots: 5864 
    Data pages: 4264, average fill: 85% 
    Primary pages: 4264, secondary pages: 0, swept pages: 3 
    Empty pages: 114, full pages: 4119 
    Fill distribution: 
     0 - 19% = 119 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 13 
    80 - 99% = 4119 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 149.72, total records: 153769 
    Average version length: 150.84, total versions: 1205, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 6, data page slots: 4440 
    Data pages: 3696, average fill: 86% 
    Primary pages: 3696, secondary pages: 0, swept pages: 2 
    Empty pages: 47, full pages: 3633 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3634 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 150.28, total records: 160663 
    Average version length: 149.49, total versions: 868, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 4600 
    Data pages: 3864, average fill: 86% 
    Primary pages: 3864, secondary pages: 0, swept pages: 2 
    Empty pages: 46, full pages: 3803 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3803 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 148.86, total records: 155795 
    Average version length: 150.95, total versions: 2091, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 5144 
    Data pages: 3736, average fill: 86% 
    Primary pages: 3735, secondary pages: 1, swept pages: 4 
    Empty pages: 44, full pages: 3684 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3684 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 149.45, total records: 143719 
    Average version length: 149.15, total versions: 1428, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 8, data page slots: 5416 
    Data pages: 3456, average fill: 86% 
    Primary pages: 3456, secondary pages: 0, swept pages: 1 
    Empty pages: 44, full pages: 3400 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3400 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 126.89, total records: 190005 
    Average version length: 154.94, total versions: 30209, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.37 
    Pointer pages: 7, data page slots: 6336 
    Data pages: 4616, average fill: 86% 
    Primary pages: 4616, secondary pages: 0, swept pages: 8 
    Empty pages: 85, full pages: 4502 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 13 
    80 - 99% = 4501 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.96, total records: 156970 
    Average version length: 151.30, total versions: 2045, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 7, data page slots: 4528 
    Data pages: 3768, average fill: 86% 
    Primary pages: 3768, secondary pages: 0, swept pages: 3 
    Empty pages: 43, full pages: 3712 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 3712 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.58, total records: 169362 
    Average version length: 153.14, total versions: 2811, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 7, data page slots: 4896 
    Data pages: 4064, average fill: 86% 
    Primary pages: 4063, secondary pages: 1, swept pages: 2 
    Empty pages: 41, full pages: 4011 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 4011 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.97, total records: 169693 
    Average version length: 150.32, total versions: 1160, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 7, data page slots: 5464 
    Data pages: 4080, average fill: 86% 
    Primary pages: 4080, secondary pages: 0, swept pages: 7 
    Empty pages: 52, full pages: 4014 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4014 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.94, total records: 155847 
    Average version length: 150.81, total versions: 892, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 8, data page slots: 4080 
    Data pages: 3736, average fill: 86% 
    Primary pages: 3735, secondary pages: 1, swept pages: 1 
    Empty pages: 41, full pages: 3683 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 0 
    80 - 99% = 3684 
 
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.39, total records: 2111615 
    Average version length: 52.96, total versions: 54479, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25544 
    Data pages: 25544, average fill: 71% 
    Primary pages: 25544, secondary pages: 0, swept pages: 10445 
    Empty pages: 236, full pages: 21085 
    Fill distribution: 
     0 - 19% = 489 
    20 - 39% = 462 
    40 - 59% = 1034 
    60 - 79% = 23047 
    80 - 99% = 512 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2604, nodes: 2111615 
    Average node length: 5.44, total dup: 1970748, max dup: 1592 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182561, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 295 
        40 - 59% = 1722 
        60 - 79% = 286 
        80 - 99% = 295 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2768, nodes: 2111615 
    Average node length: 5.69, total dup: 1895558, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377338, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2434 
        60 - 79% = 310 
        80 - 99% = 21 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2139, nodes: 2111615 
    Average node length: 4.96, total dup: 2111515, max dup: 28795 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 180239, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 219 
        40 - 59% = 1104 
        60 - 79% = 371 
        80 - 99% = 445 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 34.10, total records: 147089 
    Average version length: 69.18, total versions: 74609, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.70 
    Pointer pages: 3, data page slots: 4056 
    Data pages: 3176, average fill: 54% 
    Primary pages: 3176, secondary pages: 0, swept pages: 587 
    Empty pages: 728, full pages: 1878 
    Fill distribution: 
     0 - 19% = 982 
    20 - 39% = 146 
    40 - 59% = 105 
    60 - 79% = 516 
    80 - 99% = 1427 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105511, depth: 3, leaf buckets: 214, nodes: 147089 
    Average node length: 6.42, total dup: 128022, max dup: 14 
    Average key length: 3.95, compression ratio: 10.63 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 24625, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 109 
        60 - 79% = 64 
        80 - 99% = 11 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.68, total records: 7268438 
    Average version length: 68.76, total versions: 450966, 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: 63, data page slots: 101904 
    Data pages: 101904, average fill: 76% 
    Primary pages: 101904, secondary pages: 0, swept pages: 21058 
    Empty pages: 1, full pages: 90955 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 320 
    40 - 59% = 2793 
    60 - 79% = 89507 
    80 - 99% = 9244 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10770, nodes: 7268438 
    Average node length: 6.51, total dup: 6288627, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1623646, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1352 
        40 - 59% = 5883 
        60 - 79% = 3030 
        80 - 99% = 498 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8613, nodes: 7268438 
    Average node length: 5.39, total dup: 6985658, max dup: 178 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1415679, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 965 
        40 - 59% = 4934 
        60 - 79% = 1591 
        80 - 99% = 1118 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8647, nodes: 7268438 
    Average node length: 5.39, total dup: 6985658, max dup: 178 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1418120, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 991 
        40 - 59% = 4891 
        60 - 79% = 1647 
        80 - 99% = 1111 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.94, total records: 12226502 
    Average version length: 68.72, total versions: 356806, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 104, data page slots: 168856 
    Data pages: 168856, average fill: 77% 
    Primary pages: 168856, secondary pages: 0, swept pages: 72167 
    Empty pages: 9, full pages: 161783 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 204 
    40 - 59% = 1837 
    60 - 79% = 159424 
    80 - 99% = 7359 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18466, nodes: 12226502 
    Average node length: 6.59, total dup: 10657778, max dup: 77 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2395041, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 2115 
        40 - 59% = 10745 
        60 - 79% = 4900 
        80 - 99% = 681 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 40.24, total records: 1639954 
    Average version length: 69.11, total versions: 685541, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.13 
    Pointer pages: 26, data page slots: 40712 
    Data pages: 27663, average fill: 68% 
    Primary pages: 27663, secondary pages: 0, swept pages: 5607 
    Empty pages: 2178, full pages: 19988 
    Fill distribution: 
     0 - 19% = 3648 
    20 - 39% = 1489 
    40 - 59% = 1470 
    60 - 79% = 10225 
    80 - 99% = 10831 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2132, nodes: 1639954 
    Average node length: 5.51, total dup: 1573904, max dup: 99 
    Average key length: 2.56, compression ratio: 16.43 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 109327, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 453 
        40 - 59% = 993 
        60 - 79% = 513 
        80 - 99% = 158 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 34.61, total records: 1345461 
    Average version length: 69.13, total versions: 670686, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.64 
    Pointer pages: 22, data page slots: 34552 
    Data pages: 27360, average fill: 57% 
    Primary pages: 27360, secondary pages: 0, swept pages: 5610 
    Empty pages: 5471, full pages: 17311 
    Fill distribution: 
     0 - 19% = 7930 
    20 - 39% = 1100 
    40 - 59% = 622 
    60 - 79% = 3722 
    80 - 99% = 13986 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1682, nodes: 1345461 
    Average node length: 5.76, total dup: 1259324, max dup: 127 
    Average key length: 2.82, compression ratio: 14.90 
    Average prefix length: 41.24, average data length: 0.76 
    Clustering factor: 180540, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 235 
        40 - 59% = 748 
        60 - 79% = 482 
        80 - 99% = 209 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.70, total records: 9180185 
    Average version length: 68.98, total versions: 557960, 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: 87, data page slots: 141984 
    Data pages: 141936, average fill: 69% 
    Primary pages: 141936, secondary pages: 0, swept pages: 49106 
    Empty pages: 353, full pages: 78665 
    Fill distribution: 
     0 - 19% = 1068 
    20 - 39% = 5140 
    40 - 59% = 20991 
    60 - 79% = 106327 
    80 - 99% = 8410 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13503, nodes: 9180185 
    Average node length: 6.67, total dup: 7616455, max dup: 23 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1969240, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1248 
        40 - 59% = 7114 
        60 - 79% = 4560 
        80 - 99% = 580 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21131147 
    Average version length: 82.84, total versions: 12931, 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: 318472 
    Data pages: 318472, average fill: 81% 
    Primary pages: 318472, secondary pages: 0, swept pages: 12421 
    Empty pages: 25, full pages: 317762 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 37 
    40 - 59% = 111 
    60 - 79% = 27322 
    80 - 99% = 290964 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19377, nodes: 21131147 
    Average node length: 5.72, total dup: 20650791, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277223, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8178 
        60 - 79% = 522 
        80 - 99% = 10670 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17143, nodes: 21131147 
    Average node length: 6.31, total dup: 18570306, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 912977, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 788 
        60 - 79% = 238 
        80 - 99% = 16113 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21127, nodes: 21131147 
    Average node length: 6.35, total dup: 18489283, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571763, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2 
        40 - 59% = 8378 
        60 - 79% = 579 
        80 - 99% = 12161 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16052, nodes: 21131147 
    Average node length: 5.56, total dup: 21131047, max dup: 232083 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941818, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 7 
        40 - 59% = 2814 
        60 - 79% = 399 
        80 - 99% = 12830 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.61, total records: 9641059 
    Average version length: 82.61, total versions: 561280, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 104, data page slots: 168104 
    Data pages: 168064, average fill: 71% 
    Primary pages: 168064, secondary pages: 0, swept pages: 65494 
    Empty pages: 548, full pages: 99718 
    Fill distribution: 
     0 - 19% = 1577 
    20 - 39% = 6411 
    40 - 59% = 23485 
    60 - 79% = 73400 
    80 - 99% = 63191 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11350, nodes: 9641059 
    Average node length: 5.35, total dup: 9334265, max dup: 195 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2123498, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 56 
        40 - 59% = 8484 
        60 - 79% = 2715 
        80 - 99% = 92 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13225, nodes: 9641059 
    Average node length: 6.22, total dup: 7993484, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1466998, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 157 
        20 - 39% = 3693 
        40 - 59% = 4126 
        60 - 79% = 2689 
        80 - 99% = 2560 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12678, nodes: 9641059 
    Average node length: 5.97, total dup: 8367454, max dup: 43 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2316626, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 74 
        40 - 59% = 9462 
        60 - 79% = 3034 
        80 - 99% = 107 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9999, nodes: 9641059 
    Average node length: 5.12, total dup: 9640959, max dup: 165513 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1494443, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1273 
        40 - 59% = 4823 
        60 - 79% = 1711 
        80 - 99% = 2146 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.32, total records: 11229514 
    Average version length: 82.51, total versions: 406307, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 117, data page slots: 190160 
    Data pages: 188864, average fill: 73% 
    Primary pages: 188864, secondary pages: 0, swept pages: 68667 
    Empty pages: 2867, full pages: 141559 
    Fill distribution: 
     0 - 19% = 4953 
    20 - 39% = 7210 
    40 - 59% = 17530 
    60 - 79% = 42676 
    80 - 99% = 116495 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13135, nodes: 11229514 
    Average node length: 5.29, total dup: 11119969, max dup: 651 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2339317, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 143 
        40 - 59% = 9413 
        60 - 79% = 3415 
        80 - 99% = 163 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10292, nodes: 11229514 
    Average node length: 5.49, total dup: 10739073, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 708495, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 865 
        40 - 59% = 2404 
        60 - 79% = 1779 
        80 - 99% = 5097 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15015, nodes: 11229514 
    Average node length: 6.02, total dup: 9796547, max dup: 76 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2355732, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 185 
        40 - 59% = 10905 
        60 - 79% = 3725 
        80 - 99% = 198 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10625, nodes: 11229514 
    Average node length: 5.21, total dup: 11229414, max dup: 220162 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 697282, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 81 
        20 - 39% = 838 
        40 - 59% = 4681 
        60 - 79% = 1451 
        80 - 99% = 3574 
 
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: 77.98, total records: 9753826 
    Average version length: 82.93, total versions: 559807, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 105, data page slots: 169856 
    Data pages: 169792, average fill: 71% 
    Primary pages: 169792, secondary pages: 0, swept pages: 68526 
    Empty pages: 626, full pages: 103934 
    Fill distribution: 
     0 - 19% = 1731 
    20 - 39% = 6234 
    40 - 59% = 22595 
    60 - 79% = 74814 
    80 - 99% = 64418 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11770, nodes: 9753826 
    Average node length: 5.16, total dup: 9724504, max dup: 1578 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1935264, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1464 
        40 - 59% = 7904 
        60 - 79% = 1796 
        80 - 99% = 570 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13270, nodes: 9753826 
    Average node length: 6.23, total dup: 8086317, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1449768, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 169 
        20 - 39% = 3658 
        40 - 59% = 4048 
        60 - 79% = 2682 
        80 - 99% = 2713 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12436, nodes: 9753826 
    Average node length: 5.41, total dup: 9315947, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2070155, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1487 
        40 - 59% = 8753 
        60 - 79% = 1631 
        80 - 99% = 540 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10106, nodes: 9753826 
    Average node length: 5.13, total dup: 9753726, max dup: 167871 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1521209, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1225 
        40 - 59% = 5001 
        60 - 79% = 1699 
        80 - 99% = 2142 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.42, total records: 578214 
    Average version length: 68.83, total versions: 6420, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7976, average fill: 76% 
    Primary pages: 7976, secondary pages: 0, swept pages: 3899 
    Empty pages: 0, full pages: 6907 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 14 
    40 - 59% = 114 
    60 - 79% = 7724 
    80 - 99% = 124 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46524, depth: 3, leaf buckets: 739, nodes: 578214 
    Average node length: 5.95, total dup: 492424, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100541, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 18 
        40 - 59% = 528 
        60 - 79% = 111 
        80 - 99% = 82 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36372, depth: 3, leaf buckets: 766, nodes: 578214 
    Average node length: 6.15, total dup: 474295, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100590, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 540 
        60 - 79% = 102 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 575, nodes: 578214 
    Average node length: 4.86, total dup: 578114, max dup: 9511 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89141, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 347 
        60 - 79% = 81 
        80 - 99% = 115 
 
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 Wed Feb 21 19:11:38 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7747944 113498 1 0.0000 0.0000
DOC_LIST 2243364 115949 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 228242 591 57000.0000 0.0000
INVNT_TURNOVER_LOG 183185 163506 1 0.0000 0.0000
MONEY_SALDO 49 16891 956 34400.0000 0.0000
MONEY_TURNOVER_LOG 2901 2778 1 0.0000 0.0000
PDISTR 825756 88502 6 0.0000 0.0000
PERF_SPLIT_0 174128 13679 1 0.0000 0.0000
PERF_SPLIT_1 153769 1205 1 0.0000 0.0000
PERF_SPLIT_2 160663 868 1 0.0000 0.0000
PERF_SPLIT_3 155795 2091 1 0.0000 0.0000
PERF_SPLIT_4 143719 1428 1 0.0000 0.0000
PERF_SPLIT_5 190005 30209 1 0.0000 0.0000
PERF_SPLIT_6 156970 2045 1 0.0000 0.0000
PERF_SPLIT_7 169362 2811 1 0.0000 0.0000
PERF_SPLIT_8 169693 1160 1 0.0000 0.0000
PERF_SPLIT_9 155847 892 1 0.0000 0.0000
PSTORNED 2111615 54479 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 147089 74609 1 0.0000 0.0000
XQD_1000_3300 7268438 450966 1 0.0000 0.0000
XQD_1200_2000 12226502 356806 1 0.0000 0.0000
XQD_2000_3300 1639954 685541 1 0.0000 0.0000
XQD_2100_3300 1345461 670686 1 0.0000 0.0000
XQD_3300_3400 9180185 557960 1 0.0000 0.0000
XQS_1000_1200 21131147 12931 1 0.0000 0.0000
XQS_1000_3300 9641059 561280 1 0.0000 0.0000
XQS_1200_2000 11229514 406307 1 0.0000 0.0000
XQS_2100_3300 9753826 559807 1 0.0000 0.0000
XQS_3300_3400 578214 6420 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 ---
:925: 
:926: mscs-test-161.budzdorov.ru    Wed Feb 21 19:09:42 2024
:927:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:928: 
:929: 
:930: mscs-test-161.budzdorov.ru    Wed Feb 21 19:09:42 2024
:931:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:932: 
--- end of diff output ---

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

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