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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15852616 kB
MemAvailable 30260096 kB
Buffers 0 kB
Cached 15862292 kB
SwapCached 2720 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-16 16:09:36
DTS_END                         2024-02-16 16:09:36.7180
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/52260
TRN_ID                          181593
ATT_ID                          589
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: 9175.92 16242 917592
customer order: creation 189.35 365 18935
customer order: refuse 15.58 389 1558
order to supplier: creation 50.35 1385 5035
order to supplier: removal 3.60 98799 360
invoice (draft): creation 49.37 3238 4937
invoice (draft): removal 47.48 1001 4748
invoice accept: apply 44.40 23120 4440
invoice accept: cancel 43.07 967 4307
customer reserve: creation 4158.75 229 415875
customer reserve: removal 4264.21 65 426421
realization accept: apply 90.01 187 9001
realization accept: cancel 77.20 130 7720
payment from customer: creation 65.84 100 6584
payment from customer: removal 6.06 81 606
payment to supplier: creation 53.67 137 5367
payment to supplier: removal 3.93 80 393
service: total inventory turnovers 5.43 941 543
service: total monetary turnovers 6.60 38 660
service: aggregate perf. data 0.99 18790 99
service: refresh index statistics 0.03 174788 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-02-2024 16:10:32 to 16-02-2024 16:10:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5088
TEST_TIME 2 5248
TEST_TIME 3 5764
TEST_TIME 4 5644
TEST_TIME 5 5539
TEST_TIME 6 5628
TEST_TIME 7 6339
TEST_TIME 8 6206
TEST_TIME 9 6221
TEST_TIME 10 6356
TEST_TIME 11 6671
TEST_TIME 12 6787
TEST_TIME 13 6646
TEST_TIME 14 6593
TEST_TIME 15 7059
TEST_TIME 16 7040
TEST_TIME 17 7064
TEST_TIME 18 7205
TEST_TIME 19 7437
TEST_TIME 20 7516
TEST_TIME 21 7669
TEST_TIME 22 7641
TEST_TIME 23 7593
TEST_TIME 24 7602
TEST_TIME 25 7742
TEST_TIME 26 7910
TEST_TIME 27 8091
TEST_TIME 28 8207
TEST_TIME 29 9126
TEST_TIME 30 9255
TEST_TIME 31 9315
TEST_TIME 32 9194
TEST_TIME 33 9205
TEST_TIME 34 9058
TEST_TIME 35 9019
TEST_TIME 36 9066
TEST_TIME 37 8929
TEST_TIME 38 8899
TEST_TIME 39 8916
TEST_TIME 40 8935
TEST_TIME 41 8956
TEST_TIME 42 8860
TEST_TIME 43 8769
TEST_TIME 44 8934
TEST_TIME 45 8869
TEST_TIME 46 8846
TEST_TIME 47 9157
TEST_TIME 48 9113
TEST_TIME 49 9132
TEST_TIME 50 9111
TEST_TIME 51 9165
TEST_TIME 52 9218
TEST_TIME 53 9237
TEST_TIME 54 9217
TEST_TIME 55 9248
TEST_TIME 56 9341
TEST_TIME 57 9326
TEST_TIME 58 9341
TEST_TIME 59 9247
TEST_TIME 60 9175
TEST_TIME 61 9210
TEST_TIME 62 9105
TEST_TIME 63 9113
TEST_TIME 64 9125
TEST_TIME 65 9059
TEST_TIME 66 9013
TEST_TIME 67 9018
TEST_TIME 68 9016
TEST_TIME 69 9072
TEST_TIME 70 9094
TEST_TIME 71 9121
TEST_TIME 72 9290
TEST_TIME 73 9321
TEST_TIME 74 9373
TEST_TIME 75 9379
TEST_TIME 76 9342
TEST_TIME 77 9342
TEST_TIME 78 9403
TEST_TIME 79 9439
TEST_TIME 80 9379
TEST_TIME 81 9307
TEST_TIME 82 9306
TEST_TIME 83 9248
TEST_TIME 84 9210
TEST_TIME 85 9270
TEST_TIME 86 9225
TEST_TIME 87 9204
TEST_TIME 88 9212
TEST_TIME 89 9143
TEST_TIME 90 9094
TEST_TIME 91 9084
TEST_TIME 92 9035
TEST_TIME 93 9118
TEST_TIME 94 9085
TEST_TIME 95 9111
TEST_TIME 96 9148
TEST_TIME 97 9175
TEST_TIME 98 9158
TEST_TIME 99 9223
TEST_TIME 100 9191

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-02-2024 16:10:36 to 16-02-2024 16:10:39.

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 1298996 1298996 0 0.00 0 21231 8 0 0
doc_list_biud 1298993 1298993 0 0.00 0 38065 28 0 0
sp_add_invoice_to_stock 4504 4440 64 1.42 54 196035 23121 0 64
sp_cancel_adding_invoice 4307 4307 0 0.00 4 58875 967 0 0
sp_cancel_client_order 1558 1558 0 0.00 4 7694 389 0 0
sp_cancel_customer_reserve 426421 426421 0 0.00 0 38069 66 0 0
sp_cancel_pay_from_customer 606 606 0 0.00 2 6819 82 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 2 2881 80 0 0
sp_cancel_supplier_invoice 4754 4748 6 0.12 1 26915 1001 0 6
sp_cancel_supplier_order 360 360 0 0.00 10 1070621 98800 0 0
sp_cancel_write_off 7720 7720 0 0.00 1 11872 130 0 0
sp_client_order 18935 18935 0 0.00 3 16226 366 0 0
sp_customer_reserve 415875 415875 0 0.00 0 87184 229 0 0
sp_fill_shopping_cart 28900 28900 0 0.00 1 11733 36 0 0
sp_fill_shopping_cart_clo_res 415860 415860 0 0.00 0 12547 15 0 0
sp_get_clo_for_invoice 4422 4422 0 0.00 0 29580 266 0 0
sp_kill_cost_storno 13026 13026 0 0.00 0 9658 61 0 0
sp_kill_qstorno_ret_qs2qd 865670 865670 0 0.00 0 38057 36 0 0
sp_kill_qty_storno 458535 458535 0 0.00 0 38065 78 0 0
sp_lock_selected_doc 18596 18596 0 0.00 0 9458 6 0 0
sp_make_cost_storno 25374 25374 0 0.00 0 21198 54 0 0
sp_multiply_rows_for_pdistr 25372 25372 0 0.00 0 11891 27 0 0
sp_multiply_rows_for_qdistr 18935 18935 0 0.00 0 16213 150 0 0
sp_pay_from_customer 6584 6584 0 0.00 4 12900 101 0 0
sp_pay_to_supplier 5367 5367 0 0.00 4 21235 138 0 0
sp_payment_common 11950 11950 0 0.00 1 7014 23 0 0
sp_qd_handle_on_cancel_clo 1558 1558 0 0.00 0 7684 360 0 0
sp_qd_handle_on_invoice_upd_sts 8728 8728 0 0.00 0 24656 339 0 0
sp_qd_handle_on_reserve_upd_sts 9000 9000 0 0.00 0 16016 71 0 0
sp_reserve_write_off 9001 9001 0 0.00 6 18926 188 0 0
sp_supplier_invoice 4937 4937 0 0.00 7 79417 3238 0 0
sp_supplier_order 5035 5035 0 0.00 4 29038 1385 0 0
srv_aggregate_perf_data 99 99 0 0.00 1857 408397 18791 0 0
srv_fill_mon_cache_memory 61 61 0 0.00 715 134547 32377 0 0
srv_find_qd_qs_mism 872300 872300 0 0.00 0 12231 8 0 0
srv_make_invnt_saldo 543 543 0 0.00 35 19404 941 0 0
srv_make_money_saldo 660 660 0 0.00 1 4506 39 0 0
srv_recalc_idx_stat 3 3 0 0.00 86013 272745 174788 0 0
t$perf-abend:sp_add_invoice_to_stock 64 64 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4440 4440 0 0.00 0 10632 185 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 0 1638 77 0 0
t$perf-norm:sp_cancel_client_order 1558 1558 0 0.00 0 3944 17 0 0
t$perf-norm:sp_cancel_customer_reserve 600 600 0 0.00 0 813 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 606 606 0 0.00 0 1898 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 381 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 347 347 0 0.00 0 1211 17 0 0
t$perf-norm:sp_cancel_supplier_order 360 360 0 0.00 0 26593 1640 0 0
t$perf-norm:sp_cancel_write_off 922 922 0 0.00 0 1766 7 0 0
t$perf-norm:sp_client_order 18935 18935 0 0.00 0 5360 17 0 0
t$perf-norm:sp_customer_reserve 895 895 0 0.00 0 1468 8 0 0
t$perf-norm:sp_pay_from_customer 6584 6584 0 0.00 0 4925 10 0 0
t$perf-norm:sp_pay_to_supplier 5367 5367 0 0.00 0 6909 12 0 0
t$perf-norm:sp_reserve_write_off 9001 9001 0 0.00 0 3930 11 0 0
t$perf-norm:sp_supplier_invoice 4937 4937 0 0.00 0 6135 20 0 0
t$perf-norm:sp_supplier_order 5035 5035 0 0.00 0 5397 20 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 460 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 61 61 0 0.00 0 356 7 0 0
t$perf-norm:srv_make_invnt_saldo 543 543 0 0.00 0 660 23 0 0
t$perf-norm:srv_make_money_saldo 660 660 0 0.00 0 1692 26 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 13 6 0 0
v_add_invoice_to_stock 8966 8838 128 1.42 0 6516 18 0 128
v_all_customers 35156 35156 0 0.00 0 20 1 0 0
v_all_suppliers 28112 28112 0 0.00 0 23 1 0 0
v_all_wares 37870 37870 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 7348 17 0 0
v_cancel_client_order 3116 3116 0 0.00 0 2826 6 0 0
v_cancel_customer_prepayment 1212 1212 0 0.00 0 1095 5 0 0
v_cancel_customer_reserve 1200 1200 0 0.00 0 1326 5 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 373 4 0 0
v_cancel_supplier_invoice 706 694 12 1.69 0 1745 16 0 12
v_cancel_supplier_order 720 720 0 0.00 0 1639 5 0 0
v_cancel_write_off 1844 1844 0 0.00 0 3495 16 0 0
v_max_id_clo_ord 5032 5032 0 0.00 0 305 1 0 0
v_max_id_clo_res 895 895 0 0.00 0 982 13 0 0
v_max_id_ord_sup 4931 4931 0 0.00 0 2951 4 0 0
v_max_non_paid_invoice 1273 1273 0 0.00 0 1528 4 0 0
v_max_non_paid_realizn 3220 3220 0 0.00 0 3302 6 0 0
v_min_id_clo_ord 5032 5032 0 0.00 0 1840 6 0 0
v_min_id_clo_res 895 895 0 0.00 0 6666 16 0 0
v_min_id_ord_sup 4931 4931 0 0.00 0 7078 8 0 0
v_min_non_paid_invoice 5366 5366 0 0.00 0 4211 14 0 0
v_min_non_paid_realizn 6584 6584 0 0.00 0 7011 16 0 0
v_our_firm 9442 9442 0 0.00 0 30 1 0 0
v_reserve_write_off 17998 17998 0 0.00 0 4242 5 0 0
x_lock_depdocs_on_canc_invoice 8708 8708 0 0.00 0 11629 142 0 0
x_lock_depdocs_on_canc_sup_ord 360 360 0 0.00 0 11773 354 0 0
x_make_qstorno_1000_1200 5035 5035 0 0.00 1 29006 1303 0 0
x_make_qstorno_1200_2000 4937 4937 0 0.00 4 79402 3107 0 0
x_make_qstorno_2100_3300 415875 415875 0 0.00 0 87182 211 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-02-2024 16:10:40 to 16-02-2024 16:10:44.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:09:40 1 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:41 30610 8192000000 9900099136 10210492416 986585584 10.748 100 92 184 0 1016368688 6254528 23528576
14:12:24 24373 8192000000 9941334864 10262495232 1022316048 11.094 100 91 182 0 1054774240 9126704 23331488
14:13:55 4492 8192000000 9967699184 10298130432 1053918192 11.398 100 86 172 0 1084967888 9741024 21308672
14:15:07 13012 8192000000 10025819024 10368790528 1106757696 11.902 100 86 172 0 1139581280 12477008 20346576
14:16:24 5126 8192000000 10062055552 10421088256 1152483088 12.333 100 76 152 0 1181781136 11564080 17733968
14:17:32 3364 8192000000 10101225632 10465755136 1190545088 12.688 100 77 148 3 1220733792 13498496 16690208
14:18:37 2553 8192000000 10147363088 10522738688 1238603184 13.133 100 85 165 1 1269759920 12677968 18478768
14:19:42 1335 8192000000 10176936864 10553950208 1261003424 13.339 100 93 182 1 1294822720 14085808 19733488
14:20:45 1055 8192000000 10202083904 10586980352 1286794800 13.575 100 92 182 0 1320283600 12629904 20858896
14:21:48 54307 8192000000 10208127888 10607939584 1304632032 13.737 100 44 90 0 1320859632 5104464 11123136
14:23:43 5395 8192000000 10207395904 10622480384 1314858624 13.830 100 28 58 0 1331429792 10442736 6128432
14:24:50 7126 8192000000 10221348544 10634383360 1320428848 13.881 100 34 68 0 1338455392 10680240 7346304
14:26:00 7156 8192000000 10211403936 10631024640 1326564224 13.936 100 13 26 0 1335583120 6152272 2866624
14:27:08 24300 8192000000 10213378272 10633883648 1328452784 13.953 100 19 39 0 1337721712 5498560 3770368
14:28:33 1536 8192000000 10232199264 10644021248 1317934032 13.858 99 59 119 0 1339514112 7143488 14436592
14:29:35 3430 8192000000 10228637968 10645934080 1331068272 13.977 100 35 72 1 1346932960 6680976 9183712
14:30:44 8081 8192000000 10246103168 10659168256 1342463232 14.080 100 49 98 0 1363168640 9771056 10934352
14:32:01 5759 8192000000 10263571440 10672504832 1341499088 14.071 99 68 134 0 1369412400 13022448 14890864
14:33:12 24163 8192000000 10229267232 10647339008 1295174368 13.651 97 39 76 0 1313121440 9361984 8585088
14:34:41 6619 8192000000 10225740352 10632744960 1304818512 13.739 99 44 85 0 1324921792 10734992 9368288
14:35:55 7076 8192000000 10214703728 10615652352 1287807568 13.584 99 53 106 1 1321644352 20834352 13002432
14:37:06 11402 8192000000 10239992384 10647773184 1325022384 13.922 100 52 101 0 1350843040 14745968 11074688
14:38:19 7119 8192000000 10243362688 10652835840 1319607088 13.873 99 40 80 0 1344156512 14740592 9808832
14:39:32 7923 8192000000 10241556352 10636087296 1317538272 13.854 100 61 120 0 1349253728 18301664 13413792
14:40:43 6446 8192000000 10241806448 10648059904 1319020768 13.868 100 59 117 1 1353315632 20698192 13596672
14:41:54 7737 8192000000 10246908720 10650324992 1312200208 13.806 98 55 110 0 1345459376 20505568 12753600
14:43:07 12026 8192000000 10268247328 10677698560 1336617760 14.027 99 56 110 0 1373890592 24540656 12732176
14:44:27 7602 8192000000 10263007440 10674814976 1337390048 14.034 99 62 120 1 1377010560 25157456 14463056
14:45:39 3830 8192000000 10307829152 10710994944 1364098544 14.274 100 74 144 0 1407744496 26768992 16876960
14:46:51 3736 8192000000 10311232336 10721828864 1373530192 14.359 100 72 144 1 1418436848 27824480 17082176
14:48:00 8083 8192000000 10342427248 10751803392 1397143872 14.570 100 76 151 0 1450170576 34053168 18973536
14:49:19 4339 8192000000 10345470800 10756517888 1400577360 14.600 100 76 146 0 1448219888 29828016 17814512
14:50:27 714 8192000000 10356485408 10775126016 1414225904 14.721 100 67 134 0 1463175952 31698768 17251280
14:51:34 7180 8192000000 10360122976 10775908352 1413935504 14.719 100 69 136 0 1460017024 29399152 16682368
14:52:46 5733 8192000000 10360882096 10780897280 1406692160 14.655 99 60 120 0 1458134832 35822304 15620368
14:53:56 28089 8192000000 10350308368 10786852864 1415405952 14.732 100 37 74 1 1462650224 37270976 9973296
14:55:30 18710 8192000000 10341830864 10779389952 1404657712 14.636 100 37 74 1 1449528096 34788384 10082000
14:56:53 13047 8192000000 10323951984 10764308480 1376300336 14.383 99 22 42 0 1417838864 35010272 6528256
14:58:11 20454 8192000000 10322528624 10769625088 1389504336 14.501 100 30 60 0 1439314784 41593632 8216816
15:00:18 42774 8192000000 10307311984 10761940992 1385340032 14.464 99 9 16 1 1400516352 13303712 1872608
15:02:03 10538 8192000000 10332085888 10769252352 1407256816 14.660 100 53 105 0 1428616480 9259456 12100208
15:03:14 86033 8192000000 10309665008 10761662464 1381005264 14.426 98 32 64 0 1396542384 8162208 7374912
15:05:48 83521 8192000000 10330676160 10767777792 1387755328 14.486 99 61 118 0 1418101120 15628400 14717392
15:08:15 9784 8192000000 10316599072 10766770176 1405249984 14.642 100 36 71 0 1427765104 14479488 8035632
15:09:30 10082 8192000000 10331292368 10772176896 1404206720 14.632 100 57 113 1 1431276496 14972816 12096960
15:10:42 30688 8192000000 10326292352 10774704128 1404772000 14.637 100 30 60 0 1432179792 20478944 6928848
15:12:17 23323 8192000000 10325381152 10778628096 1406861776 14.656 100 18 36 0 1436288304 24572096 4854432
15:13:47 17425 8192000000 10319401264 10775154688 1402780272 14.620 100 28 54 0 1432371888 23442880 6148736
15:15:08 38302 8192000000 10296540976 10741026816 1344563888 14.099 97 21 42 0 1368621472 18492784 5564800
15:17:02 41868 8192000000 10287177840 10718646272 1331525088 13.981 96 33 62 1 1347171216 8283040 7363088
15:18:47 29047 8192000000 10240334960 10662490112 1292945312 13.631 95 53 102 0 1313209040 8796464 11467264
15:20:19 44903 8192000000 10261646272 10695544832 1298359040 13.680 96 29 58 0 1313833152 9364112 6110000
15:22:06 37601 8192000000 10257507200 10697822208 1314981136 13.831 97 24 44 0 1328758720 8946224 4831360
15:23:47 23487 8192000000 10278991344 10714722304 1354429168 14.187 100 44 87 0 1378133952 14556928 9147856
15:25:14 64836 8192000000 10275907776 10724241408 1352748336 14.172 99 17 34 0 1372633808 16025664 3859808
15:27:27 60867 8192000000 10246877056 10698600448 1312312576 13.807 96 15 30 0 1326376816 10786704 3277536
15:29:37 73085 8192000000 10257770768 10714779648 1350584944 14.153 100 16 32 0 1368590416 14531456 3474016
15:31:50 2239 8192000000 10273376480 10706014208 1355675760 14.199 100 51 100 2 1378109008 10662208 11771040
15:32:57 37340 8192000000 10257582912 10706493440 1335480736 14.017 98 32 64 0 1356392224 13746880 7164608
15:34:35 76694 8192000000 10278603744 10726133760 1351233648 14.159 99 10 20 0 1368233504 14722096 2277760
15:37:04 58516 8192000000 10281657424 10736578560 1375691904 14.378 100 10 19 0 1393129968 15025440 2412624
15:39:04 45051 8192000000 10306602528 10741678080 1361359056 14.250 99 29 58 0 1381875408 13988448 6527904
15:40:54 61921 8192000000 10294846672 10770980864 1387269760 14.481 100 14 29 0 1416160576 25489264 3401552
15:42:57 47647 8192000000 10299307696 10756427776 1391361168 14.518 100 8 14 0 1403034848 10090720 1582960
15:45:12 39133 8192000000 10323833824 10770223104 1404335856 14.634 100 39 76 0 1421806592 9107296 8363440
15:46:53 134547 8192000000 10299611760 10759368704 1319397808 13.871 94 7 14 0 1339958320 19141200 1419312
15:50:09 93941 8192000000 10325841008 10775179264 1392550832 14.529 99 53 104 0 1417879408 13806880 11521696
15:52:57 18395 8192000000 10310732336 10764070912 1401061328 14.604 100 25 50 0 1417501184 10497296 5942560
15:54:38 34055 8192000000 10301474816 10767114240 1406433008 14.652 100 13 26 1 1417750944 8379456 2938480
15:56:26 45845 8192000000 10284278640 10742120448 1365943856 14.291 97 12 22 0 1378255808 9912400 2399552
15:58:20 71876 8192000000 10285582896 10743861248 1366590640 14.296 98 19 38 0 1378955920 8220656 4144624
16:00:33 56999 8192000000 10291907872 10750783488 1385031616 14.462 100 11 21 1 1405987200 18463392 2492192
16:02:40 60471 8192000000 10265336928 10720407552 1314627024 13.828 95 21 41 0 1330627520 10774336 5226160
16:04:59 53202 8192000000 10278904144 10721062912 1358205984 14.221 99 29 59 0 1374216080 9195120 6814976
16:06:52 40311 8192000000 10287229696 10721918976 1315563568 13.837 95 34 68 0 1335218624 12300576 7354480
16:08:34 39254 8192000000 10262886288 10716229632 1324579568 13.918 97 23 46 0 1341596416 12001024 5015824

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

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

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          180659
MON$OLDEST_ACTIVE               181717
MON$OLDEST_SNAPSHOT             181717
MON$NEXT_TRANSACTION            181717
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                       1902560
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Fri Feb 16 16:11:05 2024 
 
Database header page information: 
    Flags            0 
    Generation        94931 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    180659 
    Oldest active        181717 
    Oldest snapshot        181717 
    Next transaction    181718 
    Sequence number        0 
    Next attachment ID    729 
    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: 7833085 
    Average version length: 48.16, total versions: 115938, 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: 86864 
    Data pages: 86864, average fill: 72% 
    Primary pages: 86864, secondary pages: 0, swept pages: 13666 
    Empty pages: 0, full pages: 72116 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 56 
    40 - 59% = 869 
    60 - 79% = 85899 
    80 - 99% = 32 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23396, nodes: 7833085 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1771828, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 321 
        20 - 39% = 1603 
        40 - 59% = 4316 
        60 - 79% = 2266 
        80 - 99% = 14890 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13605, nodes: 7833085 
    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: 1593179, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1502 
        40 - 59% = 2163 
        60 - 79% = 967 
        80 - 99% = 8973 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8384, nodes: 7833085 
    Average node length: 6.63, total dup: 5841010, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1585949, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 122 
        20 - 39% = 913 
        40 - 59% = 1435 
        60 - 79% = 882 
        80 - 99% = 5032 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.98, total records: 2282845 
    Average version length: 34.69, total versions: 116924, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28352 
    Data pages: 28352, average fill: 75% 
    Primary pages: 28349, secondary pages: 3, swept pages: 7850 
    Empty pages: 1, full pages: 22848 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 57 
    40 - 59% = 887 
    60 - 79% = 26169 
    80 - 99% = 1230 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4601, nodes: 2282845 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 711077, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 933 
        40 - 59% = 847 
        60 - 79% = 698 
        80 - 99% = 2123 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2545, nodes: 2285975 
    Average node length: 4.97, total dup: 2285076, max dup: 19478 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1277324, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 230 
        40 - 59% = 1557 
        60 - 79% = 572 
        80 - 99% = 184 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2044, nodes: 2282845 
    Average node length: 4.97, total dup: 2282795, max dup: 130647 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1067036, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 35 
        40 - 59% = 1129 
        60 - 79% = 54 
        80 - 99% = 822 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4383, nodes: 2282845 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 711077, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 612 
        40 - 59% = 611 
        60 - 79% = 787 
        80 - 99% = 2287 
 
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.72, total records: 400 
    Average version length: 22.80, total versions: 254447, max versions: 662 
    Average fragment length: 2.00, total fragments: 33, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1408 
    Data pages: 1408, average fill: 90% 
    Primary pages: 10, secondary pages: 1398, swept pages: 0 
    Empty pages: 3, full pages: 1404 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1404 
 
    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: 14.94, total records: 95579 
    Average version length: 68.29, total versions: 74678, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.89 
    Pointer pages: 6, data page slots: 3528 
    Data pages: 2016, average fill: 58% 
    Primary pages: 2015, secondary pages: 1, swept pages: 0 
    Empty pages: 490, full pages: 1152 
    Fill distribution: 
     0 - 19% = 598 
    20 - 39% = 53 
    40 - 59% = 91 
    60 - 79% = 291 
    80 - 99% = 983 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705011, depth: 3, leaf buckets: 268, nodes: 95579 
    Average node length: 13.27, total dup: 6506, max dup: 2 
    Average key length: 10.72, compression ratio: 2.52 
    Average prefix length: 19.20, average data length: 7.80 
    Clustering factor: 72055, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 18 
        40 - 59% = 123 
        60 - 79% = 102 
        80 - 99% = 23 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 17745, max versions: 960 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 2, secondary pages: 62, swept pages: 0 
    Empty pages: 1, full pages: 62 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 57 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.22, total records: 1392 
    Average version length: 43.40, total versions: 1322, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 26.16 
    Pointer pages: 1, data page slots: 40 
    Data pages: 29, average fill: 46% 
    Primary pages: 29, secondary pages: 0, swept pages: 4 
    Empty pages: 10, full pages: 12 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 97334, depth: 2, leaf buckets: 2, nodes: 1392 
    Average node length: 4.37, total dup: 1294, max dup: 169 
    Average key length: 2.75, compression ratio: 6.92 
    Average prefix length: 18.32, average data length: 0.68 
    Clustering factor: 723, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.16, total records: 77 
    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: 54% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 77 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.66, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.88, total records: 802967 
    Average version length: 25.31, total versions: 77815, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7960, average fill: 71% 
    Primary pages: 7940, secondary pages: 20, swept pages: 1059 
    Empty pages: 27, full pages: 7447 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 102 
    40 - 59% = 110 
    60 - 79% = 7302 
    80 - 99% = 355 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 882, nodes: 802967 
    Average node length: 4.87, total dup: 802918, max dup: 140467 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88879, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 108 
        40 - 59% = 508 
        60 - 79% = 206 
        80 - 99% = 59 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 891, nodes: 802967 
    Average node length: 5.88, total dup: 714872, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158233, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 107 
        40 - 59% = 303 
        60 - 79% = 127 
        80 - 99% = 350 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 926, nodes: 802967 
    Average node length: 5.88, total dup: 714872, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160299, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 188 
        40 - 59% = 278 
        60 - 79% = 101 
        80 - 99% = 358 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1130, nodes: 802967 
    Average node length: 5.96, total dup: 714872, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 153451, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 238 
        40 - 59% = 611 
        60 - 79% = 184 
        80 - 99% = 95 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5407 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.91, total fragments: 85, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 76, secondary pages: 20, swept pages: 49 
    Empty pages: 14, full pages: 62 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 67 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5407 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.02 
    Average prefix length: 34.30, average data length: 1.55 
    Clustering factor: 5203, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5407 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 150, 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.12, total records: 83921 
    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: 816 
    Data pages: 816, average fill: 71% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 808 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 808 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 40082, depth: 2, leaf buckets: 108, nodes: 83921 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3575, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 106 
 
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: 120.79, total records: 199852 
    Average version length: 154.94, total versions: 40061, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.04 
    Pointer pages: 6, data page slots: 5424 
    Data pages: 4808, average fill: 88% 
    Primary pages: 4808, secondary pages: 0, swept pages: 3 
    Empty pages: 37, full pages: 4750 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 3 
    40 - 59% = 9 
    60 - 79% = 6 
    80 - 99% = 4749 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.26, total records: 162035 
    Average version length: 153.76, total versions: 6060, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 6, data page slots: 4680 
    Data pages: 3872, average fill: 86% 
    Primary pages: 3872, secondary pages: 0, swept pages: 1 
    Empty pages: 30, full pages: 3837 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 3837 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 140.11, total records: 176139 
    Average version length: 154.66, total versions: 12724, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.11 
    Pointer pages: 7, data page slots: 4880 
    Data pages: 4232, average fill: 86% 
    Primary pages: 4232, secondary pages: 0, swept pages: 4 
    Empty pages: 45, full pages: 4173 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4172 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 146.85, total records: 165499 
    Average version length: 153.14, total versions: 4430, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.55 
    Pointer pages: 6, data page slots: 4944 
    Data pages: 3968, average fill: 86% 
    Primary pages: 3968, secondary pages: 0, swept pages: 1 
    Empty pages: 42, full pages: 3916 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3916 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 147.56, total records: 163304 
    Average version length: 152.95, total versions: 4061, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 6, data page slots: 4392 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3919, secondary pages: 1, swept pages: 5 
    Empty pages: 37, full pages: 3873 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3872 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.47, total records: 159061 
    Average version length: 152.72, total versions: 3475, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 6, data page slots: 4536 
    Data pages: 3808, average fill: 86% 
    Primary pages: 3807, secondary pages: 1, swept pages: 10 
    Empty pages: 36, full pages: 3754 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 9 
    80 - 99% = 3753 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 146.93, total records: 168559 
    Average version length: 152.31, total versions: 4580, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 8, data page slots: 4360 
    Data pages: 4024, average fill: 86% 
    Primary pages: 4024, secondary pages: 0, swept pages: 10 
    Empty pages: 25, full pages: 3988 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 1 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3988 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 147.93, total records: 160530 
    Average version length: 152.37, total versions: 3343, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 6, data page slots: 4056 
    Data pages: 3848, average fill: 86% 
    Primary pages: 3848, secondary pages: 0, swept pages: 5 
    Empty pages: 37, full pages: 3801 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 3800 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.93, total records: 171736 
    Average version length: 153.52, total versions: 7089, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 8, data page slots: 5048 
    Data pages: 4136, average fill: 86% 
    Primary pages: 4136, secondary pages: 0, swept pages: 1 
    Empty pages: 53, full pages: 4063 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 0 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 4065 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.95, total records: 158947 
    Average version length: 152.18, total versions: 3014, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 6, data page slots: 4192 
    Data pages: 3800, average fill: 86% 
    Primary pages: 3800, secondary pages: 0, swept pages: 4 
    Empty pages: 31, full pages: 3757 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3757 
 
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.42, total records: 2134990 
    Average version length: 52.95, total versions: 53724, 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: 25560 
    Data pages: 25560, average fill: 72% 
    Primary pages: 25560, secondary pages: 0, swept pages: 9094 
    Empty pages: 219, full pages: 22085 
    Fill distribution: 
     0 - 19% = 420 
    20 - 39% = 366 
    40 - 59% = 852 
    60 - 79% = 23424 
    80 - 99% = 498 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2623, nodes: 2134990 
    Average node length: 5.44, total dup: 1992524, max dup: 1431 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 185204, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 267 
        40 - 59% = 1766 
        60 - 79% = 303 
        80 - 99% = 283 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2134990 
    Average node length: 5.69, total dup: 1916771, max dup: 67 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 382052, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 2388 
        60 - 79% = 341 
        80 - 99% = 33 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2219, nodes: 2134990 
    Average node length: 4.96, total dup: 2134890, max dup: 27882 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 182581, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 205 
        40 - 59% = 1257 
        60 - 79% = 371 
        80 - 99% = 384 
 
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: 36.09, total records: 148687 
    Average version length: 69.20, total versions: 71182, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.49 
    Pointer pages: 3, data page slots: 4392 
    Data pages: 2944, average fill: 59% 
    Primary pages: 2944, secondary pages: 0, swept pages: 373 
    Empty pages: 545, full pages: 1943 
    Fill distribution: 
     0 - 19% = 743 
    20 - 39% = 120 
    40 - 59% = 50 
    60 - 79% = 694 
    80 - 99% = 1337 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1556160, depth: 3, leaf buckets: 218, nodes: 148687 
    Average node length: 6.42, total dup: 129395, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25550, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 117 
        60 - 79% = 56 
        80 - 99% = 17 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.89, total records: 7154466 
    Average version length: 68.82, total versions: 527042, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 62, data page slots: 100928 
    Data pages: 100928, average fill: 76% 
    Primary pages: 100928, secondary pages: 0, swept pages: 16412 
    Empty pages: 15, full pages: 89745 
    Fill distribution: 
     0 - 19% = 153 
    20 - 39% = 817 
    40 - 59% = 3644 
    60 - 79% = 84623 
    80 - 99% = 11691 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10661, nodes: 7154466 
    Average node length: 6.51, total dup: 6187654, max dup: 44 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1593102, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1468 
        40 - 59% = 5850 
        60 - 79% = 2695 
        80 - 99% = 640 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8622, nodes: 7154466 
    Average node length: 5.39, total dup: 6871302, max dup: 167 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1381378, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1012 
        40 - 59% = 5171 
        60 - 79% = 1441 
        80 - 99% = 989 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8667, nodes: 7154466 
    Average node length: 5.39, total dup: 6871302, max dup: 167 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1383761, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1033 
        40 - 59% = 5184 
        60 - 79% = 1444 
        80 - 99% = 999 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.60, total records: 12028989 
    Average version length: 68.78, total versions: 412747, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 102, data page slots: 165600 
    Data pages: 165600, average fill: 77% 
    Primary pages: 165600, secondary pages: 0, swept pages: 62145 
    Empty pages: 7, full pages: 161509 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 221 
    40 - 59% = 1179 
    60 - 79% = 154796 
    80 - 99% = 9389 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18333, nodes: 12028989 
    Average node length: 6.57, total dup: 10482864, max dup: 70 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2390108, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 2166 
        40 - 59% = 11048 
        60 - 79% = 4330 
        80 - 99% = 762 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 38.55, total records: 1849804 
    Average version length: 69.13, total versions: 818737, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.27 
    Pointer pages: 25, data page slots: 40584 
    Data pages: 28903, average fill: 74% 
    Primary pages: 28903, secondary pages: 0, swept pages: 3491 
    Empty pages: 1655, full pages: 23814 
    Fill distribution: 
     0 - 19% = 2580 
    20 - 39% = 1107 
    40 - 59% = 762 
    60 - 79% = 10069 
    80 - 99% = 14385 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2178, nodes: 1849804 
    Average node length: 5.50, total dup: 1775057, max dup: 99 
    Average key length: 2.55, compression ratio: 16.49 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 127467, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 209 
        40 - 59% = 1052 
        60 - 79% = 629 
        80 - 99% = 275 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 38.85, total records: 1214089 
    Average version length: 69.13, total versions: 530774, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 21, data page slots: 33192 
    Data pages: 28712, average fill: 49% 
    Primary pages: 28712, secondary pages: 0, swept pages: 5515 
    Empty pages: 5664, full pages: 14309 
    Fill distribution: 
     0 - 19% = 10191 
    20 - 39% = 1881 
    40 - 59% = 982 
    60 - 79% = 6536 
    80 - 99% = 9122 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1661, nodes: 1214090 
    Average node length: 5.79, total dup: 1133714, max dup: 105 
    Average key length: 2.85, compression ratio: 14.73 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 161946, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 331 
        40 - 59% = 847 
        60 - 79% = 384 
        80 - 99% = 98 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.69, total records: 9453538 
    Average version length: 68.97, total versions: 576974, 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: 88, data page slots: 143528 
    Data pages: 143520, average fill: 71% 
    Primary pages: 143520, secondary pages: 0, swept pages: 41748 
    Empty pages: 260, full pages: 93894 
    Fill distribution: 
     0 - 19% = 932 
    20 - 39% = 5411 
    40 - 59% = 19721 
    60 - 79% = 106324 
    80 - 99% = 11132 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13493, nodes: 9453538 
    Average node length: 6.68, total dup: 7843469, max dup: 23 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2097185, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1018 
        40 - 59% = 6623 
        60 - 79% = 4949 
        80 - 99% = 901 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21218443 
    Average version length: 82.99, total versions: 15890, 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: 319616 
    Data pages: 319616, average fill: 81% 
    Primary pages: 319616, secondary pages: 0, swept pages: 11699 
    Empty pages: 5, full pages: 319610 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 26950 
    80 - 99% = 292661 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19520, nodes: 21218443 
    Average node length: 5.72, total dup: 20735931, max dup: 167 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3292700, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8306 
        60 - 79% = 565 
        80 - 99% = 10644 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17278, nodes: 21218443 
    Average node length: 6.31, total dup: 18646281, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919617, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 5 
        40 - 59% = 857 
        60 - 79% = 291 
        80 - 99% = 16119 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21289, nodes: 21218443 
    Average node length: 6.35, total dup: 18565639, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3588199, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1 
        40 - 59% = 8509 
        60 - 79% = 647 
        80 - 99% = 12123 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16317, nodes: 21218443 
    Average node length: 5.56, total dup: 21218343, max dup: 228339 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948074, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 3199 
        60 - 79% = 443 
        80 - 99% = 12663 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.43, total records: 9937619 
    Average version length: 82.61, total versions: 600992, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 105, data page slots: 171352 
    Data pages: 171320, average fill: 72% 
    Primary pages: 171320, secondary pages: 0, swept pages: 54666 
    Empty pages: 181, full pages: 108023 
    Fill distribution: 
     0 - 19% = 917 
    20 - 39% = 5804 
    40 - 59% = 25575 
    60 - 79% = 65586 
    80 - 99% = 73438 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11405, nodes: 9937619 
    Average node length: 5.36, total dup: 9627140, max dup: 191 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2224283, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 74 
        40 - 59% = 7545 
        60 - 79% = 3646 
        80 - 99% = 135 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13822, nodes: 9937619 
    Average node length: 6.24, total dup: 8239762, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1564710, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 161 
        20 - 39% = 4112 
        40 - 59% = 4342 
        60 - 79% = 2576 
        80 - 99% = 2631 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12736, nodes: 9937619 
    Average node length: 5.98, total dup: 8631833, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2419004, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 79 
        40 - 59% = 8577 
        60 - 79% = 3923 
        80 - 99% = 153 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10340, nodes: 9937619 
    Average node length: 5.14, total dup: 9937519, max dup: 148243 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1599709, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1231 
        40 - 59% = 5187 
        60 - 79% = 1726 
        80 - 99% = 2162 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.30, total records: 11591331 
    Average version length: 82.55, total versions: 424142, 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: 120, data page slots: 194488 
    Data pages: 193344, average fill: 74% 
    Primary pages: 193344, secondary pages: 0, swept pages: 66822 
    Empty pages: 2797, full pages: 148205 
    Fill distribution: 
     0 - 19% = 4616 
    20 - 39% = 6777 
    40 - 59% = 16719 
    60 - 79% = 42506 
    80 - 99% = 122726 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13157, nodes: 11591331 
    Average node length: 5.31, total dup: 11481191, max dup: 669 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2421203, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 65 
        40 - 59% = 8654 
        60 - 79% = 4153 
        80 - 99% = 285 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10646, nodes: 11591331 
    Average node length: 5.50, total dup: 11086295, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 737665, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 793 
        40 - 59% = 2648 
        60 - 79% = 1868 
        80 - 99% = 5190 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15062, nodes: 11591331 
    Average node length: 6.03, total dup: 10120522, max dup: 66 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2437803, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 84 
        40 - 59% = 10104 
        60 - 79% = 4552 
        80 - 99% = 319 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10932, nodes: 11591331 
    Average node length: 5.23, total dup: 11591231, max dup: 189890 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 725111, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 89 
        20 - 39% = 747 
        40 - 59% = 4946 
        60 - 79% = 1424 
        80 - 99% = 3726 
 
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.68, total records: 10068033 
    Average version length: 82.91, total versions: 615226, 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: 108, data page slots: 174976 
    Data pages: 174936, average fill: 71% 
    Primary pages: 174936, secondary pages: 0, swept pages: 57157 
    Empty pages: 201, full pages: 106581 
    Fill distribution: 
     0 - 19% = 903 
    20 - 39% = 6057 
    40 - 59% = 26931 
    60 - 79% = 69734 
    80 - 99% = 71311 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12093, nodes: 10068033 
    Average node length: 5.18, total dup: 10038843, max dup: 2128 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2049976, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1403 
        40 - 59% = 8090 
        60 - 79% = 1939 
        80 - 99% = 631 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13914, nodes: 10068033 
    Average node length: 6.25, total dup: 8347269, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1533690, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 188 
        20 - 39% = 4036 
        40 - 59% = 4287 
        60 - 79% = 2624 
        80 - 99% = 2779 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12713, nodes: 10068033 
    Average node length: 5.44, total dup: 9621062, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2184128, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1338 
        40 - 59% = 9032 
        60 - 79% = 1713 
        80 - 99% = 606 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10533, nodes: 10068033 
    Average node length: 5.15, total dup: 10067933, max dup: 150960 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1629333, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1358 
        40 - 59% = 5148 
        60 - 79% = 1720 
        80 - 99% = 2256 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.16, total records: 584933 
    Average version length: 68.83, total versions: 8690, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8072 
    Data pages: 8072, average fill: 76% 
    Primary pages: 8072, secondary pages: 0, swept pages: 3432 
    Empty pages: 4, full pages: 7051 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 13 
    40 - 59% = 153 
    60 - 79% = 7750 
    80 - 99% = 151 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41349, depth: 3, leaf buckets: 746, nodes: 584933 
    Average node length: 5.95, total dup: 498145, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101623, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 527 
        60 - 79% = 102 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 29882, depth: 3, leaf buckets: 769, nodes: 584933 
    Average node length: 6.15, total dup: 479836, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101680, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 548 
        60 - 79% = 99 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 578, nodes: 584933 
    Average node length: 4.86, total dup: 584833, max dup: 9960 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90099, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 343 
        60 - 79% = 80 
        80 - 99% = 128 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Feb 16 16:11:29 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7833085 115938 1 0.0000 0.0000
DOC_LIST 2282845 116924 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 254447 662 63600.0000 0.0000
INVNT_TURNOVER_LOG 95579 74678 1 0.0000 0.0000
MONEY_SALDO 49 17745 960 36200.0000 0.0000
MONEY_TURNOVER_LOG 1392 1322 1 0.0000 0.0000
PDISTR 802967 77815 4 0.0000 0.0000
PERF_SPLIT_0 199852 40061 1 0.0000 0.0000
PERF_SPLIT_1 162035 6060 1 0.0000 0.0000
PERF_SPLIT_2 176139 12724 1 0.0000 0.0000
PERF_SPLIT_3 165499 4430 1 0.0000 0.0000
PERF_SPLIT_4 163304 4061 1 0.0000 0.0000
PERF_SPLIT_5 159061 3475 1 0.0000 0.0000
PERF_SPLIT_6 168559 4580 1 0.0000 0.0000
PERF_SPLIT_7 160530 3343 1 0.0000 0.0000
PERF_SPLIT_8 171736 7089 1 0.0000 0.0000
PERF_SPLIT_9 158947 3014 1 0.0000 0.0000
PSTORNED 2134990 53724 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 148687 71182 1 0.0000 0.0000
XQD_1000_3300 7154466 527042 1 0.0000 0.0000
XQD_1200_2000 12028989 412747 1 0.0000 0.0000
XQD_2000_3300 1849804 818737 1 0.0000 0.0000
XQD_2100_3300 1214089 530774 1 0.0000 0.0000
XQD_3300_3400 9453538 576974 1 0.0000 0.0000
XQS_1000_1200 21218443 15890 1 0.0000 0.0000
XQS_1000_3300 9937619 600992 1 0.0000 0.0000
XQS_1200_2000 11591331 424142 1 0.0000 0.0000
XQS_2100_3300 10068033 615226 1 0.0000 0.0000
XQS_3300_3400 584933 8690 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 ---
:644: 
:645: mscs-test-161.budzdorov.ru    Fri Feb 16 16:09:45 2024
:646:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:647: 
:648: 
:649: mscs-test-161.budzdorov.ru    Fri Feb 16 16:09:48 2024
:650:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:651: 
:652: 
:653: mscs-test-161.budzdorov.ru    Fri Feb 16 16:09:49 2024
:654:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:655: 
:656: 
:657: mscs-test-161.budzdorov.ru    Fri Feb 16 16:09:49 2024
:658:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:659: 
:660: 
:661: mscs-test-161.budzdorov.ru    Fri Feb 16 16:09:49 2024
:662:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:663: 
:664: 
:665: mscs-test-161.budzdorov.ru    Fri Feb 16 16:09:49 2024
:666:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:667: 
--- end of diff output ---

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

16.02.24 16:11:41. 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-16 16:11:44 No severe PSQL-related problems occured
16.02.24 16:11:45. End of report.