Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.02.2024 22: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 15896932 kB
MemAvailable 30246340 kB
Buffers 0 kB
Cached 15829928 kB
SwapCached 2444 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-24 22:09:44
DTS_END                         2024-02-24 22:09:44.0400
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52874
TRN_ID                          171353
ATT_ID                          599
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: 9334.02 25127 933402
customer order: creation 171.67 344 17167
customer order: refuse 14.94 363 1494
order to supplier: creation 45.25 1309 4525
order to supplier: removal 3.81 102028 381
invoice (draft): creation 44.99 3006 4499
invoice (draft): removal 52.91 789 5291
invoice accept: apply 41.20 20176 4120
invoice accept: cancel 47.61 770 4761
customer reserve: creation 3962.89 193 396289
customer reserve: removal 4651.36 66 465136
realization accept: apply 83.18 191 8318
realization accept: cancel 86.44 130 8644
payment from customer: creation 58.61 121 5861
payment from customer: removal 5.90 89 590
payment to supplier: creation 47.08 143 4708
payment to supplier: removal 3.56 69 356
service: total inventory turnovers 5.09 1056 509
service: total monetary turnovers 6.77 57 677
service: aggregate perf. data 0.73 28729 73
service: refresh index statistics 0.03 342913 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 24-02-2024 22:10:54 to 24-02-2024 22:10:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1887
TEST_TIME 2 2982
TEST_TIME 3 3974
TEST_TIME 4 3752
TEST_TIME 5 3954
TEST_TIME 6 4414
TEST_TIME 7 4459
TEST_TIME 8 4601
TEST_TIME 9 5192
TEST_TIME 10 5042
TEST_TIME 11 4961
TEST_TIME 12 5094
TEST_TIME 13 5209
TEST_TIME 14 5361
TEST_TIME 15 5436
TEST_TIME 16 5582
TEST_TIME 17 5805
TEST_TIME 18 6027
TEST_TIME 19 6089
TEST_TIME 20 6102
TEST_TIME 21 7069
TEST_TIME 22 7275
TEST_TIME 23 7472
TEST_TIME 24 7612
TEST_TIME 25 7817
TEST_TIME 26 9406
TEST_TIME 27 9497
TEST_TIME 28 9249
TEST_TIME 29 9151
TEST_TIME 30 9021
TEST_TIME 31 9107
TEST_TIME 32 9176
TEST_TIME 33 8929
TEST_TIME 34 8807
TEST_TIME 35 8937
TEST_TIME 36 8877
TEST_TIME 37 8830
TEST_TIME 38 8789
TEST_TIME 39 8690
TEST_TIME 40 8646
TEST_TIME 41 8591
TEST_TIME 42 8758
TEST_TIME 43 8717
TEST_TIME 44 8778
TEST_TIME 45 8919
TEST_TIME 46 8854
TEST_TIME 47 8932
TEST_TIME 48 8930
TEST_TIME 49 8988
TEST_TIME 50 9135
TEST_TIME 51 9113
TEST_TIME 52 9138
TEST_TIME 53 9195
TEST_TIME 54 9271
TEST_TIME 55 9238
TEST_TIME 56 9333
TEST_TIME 57 9362
TEST_TIME 58 9328
TEST_TIME 59 9191
TEST_TIME 60 9129
TEST_TIME 61 9067
TEST_TIME 62 9067
TEST_TIME 63 9046
TEST_TIME 64 9057
TEST_TIME 65 9007
TEST_TIME 66 8901
TEST_TIME 67 9024
TEST_TIME 68 9007
TEST_TIME 69 9017
TEST_TIME 70 9044
TEST_TIME 71 9022
TEST_TIME 72 8995
TEST_TIME 73 9186
TEST_TIME 74 9149
TEST_TIME 75 9207
TEST_TIME 76 9248
TEST_TIME 77 9289
TEST_TIME 78 9340
TEST_TIME 79 9350
TEST_TIME 80 9380
TEST_TIME 81 9271
TEST_TIME 82 9275
TEST_TIME 83 9219
TEST_TIME 84 9267
TEST_TIME 85 9253
TEST_TIME 86 9232
TEST_TIME 87 9196
TEST_TIME 88 9141
TEST_TIME 89 9128
TEST_TIME 90 9115
TEST_TIME 91 9206
TEST_TIME 92 9180
TEST_TIME 93 9223
TEST_TIME 94 9225
TEST_TIME 95 9293
TEST_TIME 96 9296
TEST_TIME 97 9310
TEST_TIME 98 9360
TEST_TIME 99 9357
TEST_TIME 100 9336

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-02-2024 22:10:58 to 24-02-2024 22:11:01.

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 1296263 1296263 0 0.00 0 53118 7 0 0
doc_list_biud 1296262 1296262 0 0.00 0 56313 30 0 0
sp_add_invoice_to_stock 4254 4120 134 3.14 39 204066 20176 0 134
sp_cancel_adding_invoice 4761 4761 0 0.00 4 61309 770 0 0
sp_cancel_client_order 1494 1494 0 0.00 4 8649 363 0 0
sp_cancel_customer_reserve 465136 465136 0 0.00 0 35802 66 0 0
sp_cancel_pay_from_customer 590 590 0 0.00 3 4364 89 0 0
sp_cancel_pay_to_supplier 356 356 0 0.00 3 2284 69 0 0
sp_cancel_supplier_invoice 5302 5291 11 0.20 2 56396 790 0 11
sp_cancel_supplier_order 381 381 0 0.00 7 1285527 102029 0 0
sp_cancel_write_off 8644 8644 0 0.00 1 14108 130 0 0
sp_client_order 17167 17167 0 0.00 3 34141 345 0 0
sp_customer_reserve 396289 396289 0 0.00 0 61243 194 0 0
sp_fill_shopping_cart 26176 26176 0 0.00 1 11487 36 0 0
sp_fill_shopping_cart_clo_res 396288 396288 0 0.00 0 28507 17 0 0
sp_get_clo_for_invoice 4117 4117 0 0.00 0 33514 336 0 0
sp_kill_cost_storno 14351 14351 0 0.00 0 35343 67 0 0
sp_kill_qstorno_ret_qs2qd 944588 944588 0 0.00 0 56311 36 0 0
sp_kill_qty_storno 498141 498141 0 0.00 0 56313 76 0 0
sp_lock_selected_doc 17300 17300 0 0.00 0 8763 7 0 0
sp_make_cost_storno 23003 23003 0 0.00 0 53098 66 0 0
sp_multiply_rows_for_pdistr 23003 23003 0 0.00 0 13796 32 0 0
sp_multiply_rows_for_qdistr 17167 17167 0 0.00 0 33930 172 0 0
sp_pay_from_customer 5861 5861 0 0.00 4 18334 122 0 0
sp_pay_to_supplier 4708 4708 0 0.00 4 20837 143 0 0
sp_payment_common 10569 10569 0 0.00 1 18325 30 0 0
sp_qd_handle_on_cancel_clo 1494 1494 0 0.00 0 8636 321 0 0
sp_qd_handle_on_invoice_upd_sts 8877 8877 0 0.00 0 28837 318 0 0
sp_qd_handle_on_reserve_upd_sts 8318 8318 0 0.00 0 12667 72 0 0
sp_reserve_write_off 8318 8318 0 0.00 6 19535 191 0 0
sp_supplier_invoice 4499 4499 0 0.00 7 94784 3007 0 0
sp_supplier_order 4525 4525 0 0.00 5 50224 1309 0 0
srv_aggregate_perf_data 73 73 0 0.00 1517 352554 28729 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 2089 113493 40388 0 0
srv_find_qd_qs_mism 891451 891451 0 0.00 0 13286 6 0 0
srv_make_invnt_saldo 509 509 0 0.00 46 39006 1057 0 0
srv_make_money_saldo 677 677 0 0.00 0 12805 58 0 0
srv_recalc_idx_stat 3 3 0 0.00 289515 371476 342913 0 0
t$perf-abend:sp_add_invoice_to_stock 134 134 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4121 4121 0 0.00 0 11808 172 0 0
t$perf-norm:sp_cancel_adding_invoice 316 316 0 0.00 0 9651 148 0 0
t$perf-norm:sp_cancel_client_order 1494 1494 0 0.00 0 2802 10 0 0
t$perf-norm:sp_cancel_customer_reserve 578 578 0 0.00 0 6890 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 590 590 0 0.00 0 1103 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 356 356 0 0.00 0 498 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 295 295 0 0.00 0 4103 22 0 0
t$perf-norm:sp_cancel_supplier_order 381 381 0 0.00 0 27632 1625 0 0
t$perf-norm:sp_cancel_write_off 856 856 0 0.00 0 5036 12 0 0
t$perf-norm:sp_client_order 17167 17167 0 0.00 0 10007 17 0 0
t$perf-norm:sp_customer_reserve 825 825 0 0.00 0 601 4 0 0
t$perf-norm:sp_pay_from_customer 5861 5861 0 0.00 0 7962 11 0 0
t$perf-norm:sp_pay_to_supplier 4708 4708 0 0.00 0 7471 9 0 0
t$perf-norm:sp_reserve_write_off 8318 8318 0 0.00 0 4929 8 0 0
t$perf-norm:sp_supplier_invoice 4499 4499 0 0.00 0 10156 21 0 0
t$perf-norm:sp_supplier_order 4525 4525 0 0.00 0 3643 16 0 0
t$perf-norm:srv_aggregate_perf_data 73 73 0 0.00 0 561 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 13 1 0 0
t$perf-norm:srv_make_invnt_saldo 509 509 0 0.00 0 720 19 0 0
t$perf-norm:srv_make_money_saldo 677 677 0 0.00 0 1330 18 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 15 6 0 0
v_add_invoice_to_stock 8500 8232 268 3.15 0 7363 17 0 268
v_all_customers 31870 31870 0 0.00 0 51 1 0 0
v_all_suppliers 25302 25302 0 0.00 0 109 1 0 0
v_all_wares 34334 34334 0 0.00 0 69 1 0 0
v_cancel_adding_invoice 632 632 0 0.00 0 179 6 0 0
v_cancel_client_order 2988 2988 0 0.00 0 6184 8 0 0
v_cancel_customer_prepayment 1180 1180 0 0.00 0 3634 9 0 0
v_cancel_customer_reserve 1156 1156 0 0.00 0 6294 13 0 0
v_cancel_payment_to_supplier 712 712 0 0.00 0 2175 8 0 0
v_cancel_supplier_invoice 612 590 22 3.59 0 4077 24 0 22
v_cancel_supplier_order 762 762 0 0.00 0 496 3 0 0
v_cancel_write_off 1712 1712 0 0.00 0 2396 14 0 0
v_max_id_clo_ord 4520 4520 0 0.00 0 1468 1 0 0
v_max_id_clo_res 825 825 0 0.00 0 1434 12 0 0
v_max_id_ord_sup 4489 4489 0 0.00 0 5658 6 0 0
v_max_non_paid_invoice 1066 1066 0 0.00 0 4000 6 0 0
v_max_non_paid_realizn 2835 2835 0 0.00 0 18309 13 0 0
v_min_id_clo_ord 4520 4520 0 0.00 0 6401 6 0 0
v_min_id_clo_res 825 825 0 0.00 0 3668 13 0 0
v_min_id_ord_sup 4489 4489 0 0.00 0 1797 3 0 0
v_min_non_paid_invoice 4708 4708 0 0.00 0 6818 22 0 0
v_min_non_paid_realizn 5861 5861 0 0.00 0 8091 21 0 0
v_our_firm 8516 8516 0 0.00 0 18 1 0 0
v_reserve_write_off 16636 16636 0 0.00 0 4294 6 0 0
x_lock_depdocs_on_canc_invoice 9757 9757 0 0.00 0 11285 119 0 0
x_lock_depdocs_on_canc_sup_ord 381 381 0 0.00 0 2547 325 0 0
x_make_qstorno_1000_1200 4525 4525 0 0.00 2 48110 1230 0 0
x_make_qstorno_1200_2000 4499 4499 0 0.00 3 94151 2880 0 0
x_make_qstorno_2100_3300 396289 396289 0 0.00 0 60978 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-02-2024 22:11:02 to 24-02-2024 22:11:06.

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
20:09:47 2 8192000000 8800107136 8812003328 6201824 0.075 3 1 2 0 6302752 58144 42784
20:10:49 40937 8192000000 9896493552 10210553856 982046512 10.704 100 84 168 1 1009270592 5689712 21534368
20:12:35 13968 8192000000 9949863600 10268352512 1028116560 11.150 100 93 186 0 1060563776 8476192 23971024
20:13:57 15065 8192000000 9966111232 10297487360 1052200800 11.382 100 87 174 0 1084295296 10128544 21965952
20:15:18 8368 8192000000 10015242576 10362372096 1106005584 11.895 100 72 144 0 1134030688 10493968 17531136
20:16:28 6396 8192000000 10084746016 10442010624 1173278448 12.527 100 71 142 0 1200869392 11709728 15881216
20:17:36 3021 8192000000 10129804816 10501431296 1222218368 12.982 100 79 158 0 1253574784 13510816 17845600
20:18:41 2458 8192000000 10161695824 10532519936 1241264128 13.158 100 88 177 2 1275521056 15060896 19196032
20:19:46 1690 8192000000 10183764544 10563596288 1271322128 13.434 100 84 167 1 1303234544 13109920 18802496
20:20:50 1267 8192000000 10211070016 10594533376 1294254112 13.643 100 95 187 3 1328454656 13332960 20867584
20:21:55 4644 8192000000 10213270864 10605318144 1304531840 13.736 100 71 143 0 1333120192 12741024 15847328
20:23:01 4397 8192000000 10223759984 10619396096 1312936912 13.813 100 75 150 0 1342865232 12541376 17386944
20:24:06 2615 8192000000 10217055648 10621493248 1316222576 13.842 100 48 94 1 1335063392 8219536 10621280
20:25:16 5323 8192000000 10218577376 10630426624 1325928688 13.930 100 36 70 2 1339346656 5115184 8302784
20:26:25 8262 8192000000 10216475200 10638659584 1334159504 14.005 100 13 26 0 1342871360 5513344 3198512
20:27:34 62535 8192000000 10232930400 10652962816 1325986144 13.931 99 25 51 1 1341781264 9835936 5959184
20:29:38 6809 8192000000 10224306992 10646200320 1333388992 13.998 100 22 44 0 1343430720 5293040 4748688
20:30:57 18710 8192000000 10253829040 10667249664 1347673552 14.127 100 50 100 1 1370496560 11056384 11766624
20:32:26 10910 8192000000 10249323840 10661539840 1324862000 13.921 98 52 101 0 1349251216 13209920 11179296
20:33:42 99554 8192000000 10257004128 10683871232 1339702288 14.055 99 39 79 0 1364816704 15980080 9134336
20:36:28 31089 8192000000 10247691984 10673586176 1322764080 13.902 98 23 46 0 1343014128 15347024 4903024
20:38:06 4785 8192000000 10274352240 10690732032 1355502688 14.197 100 47 90 1 1381876192 16207072 10166432
20:39:23 14001 8192000000 10242259936 10637815808 1303841456 13.730 99 50 100 0 1337002016 21308896 11851664
20:40:46 10731 8192000000 10255447200 10661572608 1330470800 13.971 99 59 117 0 1365204960 21423072 13311088
20:42:03 3265 8192000000 10255563680 10649980928 1311653712 13.801 97 58 115 0 1350774048 25072096 14048240
20:43:11 5063 8192000000 10285762256 10688589824 1350264304 14.150 100 61 121 3 1393315504 27919120 15132080
20:44:24 2925 8192000000 10312079104 10709102592 1358987648 14.228 100 76 146 2 1413755664 36950096 17817920
20:45:39 6600 8192000000 10327889536 10726096896 1373498032 14.358 100 74 146 0 1429044000 37694480 17851488
20:46:50 2589 8192000000 10345753520 10746904576 1387631184 14.485 100 81 162 1 1449031024 41461824 19938016
20:48:00 2088 8192000000 10364246528 10770407424 1401066512 14.604 100 81 157 0 1467074560 46071936 19936112
20:49:06 5091 8192000000 10369576624 10779553792 1402582848 14.618 100 67 131 0 1474556048 54723152 17250048
20:50:13 8502 8192000000 10358933760 10789670912 1401688752 14.610 100 53 106 0 1473046144 57063472 14293920
20:51:40 15156 8192000000 10331138848 10762100736 1383448624 14.447 99 30 60 0 1431953360 40343952 8160784
20:53:03 34779 8192000000 10307063168 10740961280 1360272096 14.240 99 29 58 0 1416849584 48193456 8384032
20:54:58 26331 8192000000 10309735152 10749919232 1337903136 14.039 98 30 58 0 1400945328 54349344 8692848
20:56:26 52739 8192000000 10260691104 10697334784 1332903248 13.993 98 9 18 0 1352097744 16633680 2560816
20:58:19 26459 8192000000 10264305248 10703712256 1356066016 14.202 99 33 66 0 1372184944 9200816 6918112
20:59:49 55839 8192000000 10287640048 10742468608 1378202816 14.400 100 16 32 0 1393047280 11417872 3426592
21:01:49 98315 8192000000 10296304496 10744786944 1378237392 14.401 99 22 44 0 1395063792 10379152 6447248
21:04:40 38426 8192000000 10282829616 10727960576 1348413952 14.133 97 39 77 0 1364072448 6866896 8791600
21:06:19 38599 8192000000 10295670272 10751180800 1393956384 14.541 100 17 34 0 1409283632 11489120 3838128
21:08:03 26111 8192000000 10312563200 10759643136 1406595312 14.654 100 23 45 0 1421702896 9927952 5179632
21:09:33 22862 8192000000 10329044896 10780803072 1418643664 14.761 100 15 30 0 1435898480 13575360 3679456
21:11:02 47363 8192000000 10319845424 10782035968 1417703120 14.752 100 28 56 0 1441488544 17343984 6441440
21:12:50 40019 8192000000 10319245408 10784768000 1409474128 14.679 100 12 24 0 1430153808 17715584 2964096
21:14:34 58615 8192000000 10309287328 10763198464 1354811680 14.191 96 22 42 0 1376209808 17153168 4244960
21:16:56 50507 8192000000 10316883792 10770423808 1400212640 14.597 100 21 42 0 1416466592 11198496 5055456
21:18:54 45970 8192000000 10286197744 10743181312 1365093392 14.283 97 14 28 0 1381594368 13312176 3188800
21:20:46 25213 8192000000 10309497264 10751557632 1381520128 14.430 99 33 64 2 1396883296 8041984 7321184
21:22:12 113467 8192000000 10284237840 10725556224 1287492480 13.581 93 15 31 0 1303067504 12284400 3290624
21:25:06 49558 8192000000 10277077776 10720247808 1320286688 13.879 96 42 84 0 1344760560 14937440 9536432
21:26:56 35701 8192000000 10261021488 10705371136 1329165712 13.960 97 19 37 1 1343654432 10035936 4452784
21:28:47 84804 8192000000 10239020400 10672951296 1303198240 13.724 96 36 68 0 1318290704 6897696 8194768
21:31:16 23831 8192000000 10251942464 10689888256 1336139872 14.023 99 25 49 0 1353154544 11091824 5922848
21:32:44 32394 8192000000 10241857072 10699927552 1348424512 14.133 100 4 8 0 1362810576 13411664 974400
21:35:06 70813 8192000000 10261798816 10705084416 1355221856 14.194 100 15 31 0 1372498960 13333440 3943664
21:37:30 55732 8192000000 10261664704 10710347776 1357389440 14.214 100 14 28 0 1368748096 8413936 2944720
21:39:31 55942 8192000000 10295803840 10730287104 1334665760 14.009 97 20 40 0 1351688976 12609952 4413264
21:41:33 68178 8192000000 10275972416 10744074240 1344428320 14.097 97 22 44 1 1369499120 20202432 4868368
21:43:51 50287 8192000000 10284148752 10733535232 1349162496 14.140 98 14 28 0 1365815488 13803104 2849888
21:45:43 41198 8192000000 10298446560 10732077056 1358909744 14.228 98 29 58 1 1376752064 11187584 6654736
21:47:25 58381 8192000000 10294993104 10756538368 1389346960 14.500 100 30 61 0 1407275184 11209888 6718336
21:52:00 66411 8192000000 10282901536 10727940096 1340303888 14.060 97 29 58 0 1357953760 11866720 5783152
21:54:07 47453 8192000000 10274543648 10738417664 1374314048 14.366 99 9 18 0 1385031888 8838880 1878960
21:55:54 45102 8192000000 10285931216 10739666944 1389057552 14.497 100 11 22 0 1401003616 9394656 2551408
21:57:40 63467 8192000000 10306602272 10760552448 1396698496 14.566 100 25 50 1 1416949360 14269904 5980960
21:59:49 71239 8192000000 10280192464 10741661696 1337650176 14.036 96 6 11 0 1359417856 20405056 1362624
22:02:05 72154 8192000000 10285172368 10735738880 1344709712 14.100 97 21 42 1 1363474576 13915760 4849104
22:04:22 102805 8192000000 10302462192 10758438912 1345651968 14.108 97 10 20 0 1362356336 14714144 1990224
22:07:18 33730 8192000000 10287432400 10727264256 1341064624 14.067 97 29 56 0 1357187104 10614752 5507728
22:08:54 42493 8192000000 10294318080 10737164288 1326311072 13.934 96 37 74 0 1351718048 17319728 8087248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 24-02-2024 22:11:08 to 24-02-2024 22:11:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 134 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-02-2024 22:11:23 to 24-02-2024 22:11:25.

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          168734
MON$OLDEST_ACTIVE               172324
MON$OLDEST_SNAPSHOT             172324
MON$NEXT_TRANSACTION            172324
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                       1891072
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 Sat Feb 24 22:11:26 2024 
 
Database header page information: 
    Flags            0 
    Generation        89863 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    168734 
    Oldest active        172324 
    Oldest snapshot        172324 
    Next transaction    172325 
    Sequence number        0 
    Next attachment ID    705 
    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: 46.89, total records: 7769638 
    Average version length: 48.16, total versions: 162528, 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: 53, data page slots: 86432 
    Data pages: 86432, average fill: 72% 
    Primary pages: 86432, secondary pages: 0, swept pages: 10414 
    Empty pages: 4, full pages: 78255 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 246 
    40 - 59% = 3069 
    60 - 79% = 83013 
    80 - 99% = 74 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23249, nodes: 7769638 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1733125, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 338 
        20 - 39% = 1541 
        40 - 59% = 4305 
        60 - 79% = 2458 
        80 - 99% = 14607 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13511, nodes: 7769638 
    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: 1554935, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1400 
        40 - 59% = 2210 
        60 - 79% = 1148 
        80 - 99% = 8753 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8335, nodes: 7769638 
    Average node length: 6.62, total dup: 5807756, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1548026, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 809 
        40 - 59% = 1546 
        60 - 79% = 918 
        80 - 99% = 4936 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.30, total records: 2251398 
    Average version length: 34.56, total versions: 166261, max versions: 3 
    Average fragment length: 50.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.52 
    Pointer pages: 18, data page slots: 28104 
    Data pages: 28104, average fill: 75% 
    Primary pages: 28098, secondary pages: 6, swept pages: 6333 
    Empty pages: 0, full pages: 23518 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 141 
    40 - 59% = 1160 
    60 - 79% = 24634 
    80 - 99% = 2153 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4543, nodes: 2251398 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 699092, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 827 
        40 - 59% = 930 
        60 - 79% = 730 
        80 - 99% = 2056 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2508, nodes: 2254950 
    Average node length: 4.97, total dup: 2254051, max dup: 18958 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1244030, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 241 
        40 - 59% = 1516 
        60 - 79% = 556 
        80 - 99% = 194 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1969, nodes: 2251398 
    Average node length: 4.97, total dup: 2251348, max dup: 130187 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1054375, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 29 
        40 - 59% = 1007 
        60 - 79% = 56 
        80 - 99% = 871 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4345, nodes: 2251398 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 699092, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 118 
        20 - 39% = 500 
        40 - 59% = 674 
        60 - 79% = 841 
        80 - 99% = 2212 
 
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.50, total records: 400 
    Average version length: 22.63, total versions: 245883, max versions: 645 
    Average fragment length: 2.07, total fragments: 43, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1384 
    Data pages: 1352, average fill: 90% 
    Primary pages: 7, secondary pages: 1345, swept pages: 0 
    Empty pages: 0, full pages: 1351 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 1348 
 
    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: 11.38, total records: 106113 
    Average version length: 68.30, total versions: 88441, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.74 
    Pointer pages: 6, data page slots: 2856 
    Data pages: 1976, average fill: 66% 
    Primary pages: 1975, secondary pages: 1, swept pages: 0 
    Empty pages: 163, full pages: 1182 
    Fill distribution: 
     0 - 19% = 258 
    20 - 39% = 151 
    40 - 59% = 232 
    60 - 79% = 341 
    80 - 99% = 994 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1702193, depth: 3, leaf buckets: 378, nodes: 106113 
    Average node length: 13.13, total dup: 8771, max dup: 2 
    Average key length: 10.60, compression ratio: 2.55 
    Average prefix length: 19.31, average data length: 7.69 
    Clustering factor: 79510, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 110 
        40 - 59% = 237 
        60 - 79% = 31 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18983, max versions: 988 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 63 
 
    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: 4.06, total records: 1650 
    Average version length: 43.33, total versions: 1502, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 14.29 
    Pointer pages: 1, data page slots: 32 
    Data pages: 30, average fill: 53% 
    Primary pages: 30, secondary pages: 0, swept pages: 1 
    Empty pages: 4, full pages: 12 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91563, depth: 2, leaf buckets: 3, nodes: 1650 
    Average node length: 4.26, total dup: 1552, max dup: 195 
    Average key length: 2.64, compression ratio: 7.19 
    Average prefix length: 18.42, average data length: 0.58 
    Clustering factor: 841, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.96, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.71, total records: 852250 
    Average version length: 25.22, total versions: 89143, 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: 6, data page slots: 8312 
    Data pages: 8312, average fill: 72% 
    Primary pages: 8294, secondary pages: 18, swept pages: 817 
    Empty pages: 12, full pages: 7877 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 9 
    40 - 59% = 33 
    60 - 79% = 7875 
    80 - 99% = 370 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 940, nodes: 852250 
    Average node length: 4.88, total dup: 852201, max dup: 156570 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 93465, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 126 
        40 - 59% = 550 
        60 - 79% = 207 
        80 - 99% = 56 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1026, nodes: 852250 
    Average node length: 5.89, total dup: 758752, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 170100, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 77 
        40 - 59% = 586 
        60 - 79% = 102 
        80 - 99% = 257 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1071, nodes: 852250 
    Average node length: 5.89, total dup: 758752, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 172001, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 191 
        40 - 59% = 542 
        60 - 79% = 87 
        80 - 99% = 250 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1167, nodes: 852250 
    Average node length: 5.97, total dup: 758752, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 164532, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 206 
        40 - 59% = 635 
        60 - 79% = 226 
        80 - 99% = 99 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.75, total records: 5444 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.99, total fragments: 78, 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: 73, secondary pages: 23, swept pages: 49 
    Empty pages: 13, full pages: 62 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 69 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5444 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.01 
    Average prefix length: 34.41, average data length: 1.55 
    Clustering factor: 5082, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5444 
    Average node length: 11.14, 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: 139, 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.10, total records: 78524 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 756 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 756 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35380, depth: 2, leaf buckets: 101, nodes: 78524 
    Average node length: 10.16, 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: 3001, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 131.53, total records: 194658 
    Average version length: 154.93, total versions: 25329, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.89 
    Pointer pages: 6, data page slots: 5616 
    Data pages: 4688, average fill: 87% 
    Primary pages: 4688, secondary pages: 0, swept pages: 3 
    Empty pages: 47, full pages: 4621 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4620 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 137.65, total records: 185030 
    Average version length: 154.71, total versions: 16646, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.32 
    Pointer pages: 6, data page slots: 5936 
    Data pages: 4504, average fill: 86% 
    Primary pages: 4504, secondary pages: 0, swept pages: 1 
    Empty pages: 95, full pages: 4387 
    Fill distribution: 
     0 - 19% = 95 
    20 - 39% = 11 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4387 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 143.42, total records: 168221 
    Average version length: 154.36, total versions: 8435, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.83 
    Pointer pages: 6, data page slots: 5832 
    Data pages: 4088, average fill: 85% 
    Primary pages: 4087, secondary pages: 1, swept pages: 1 
    Empty pages: 83, full pages: 3974 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 11 
    80 - 99% = 3975 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 145.67, total records: 162673 
    Average version length: 152.84, total versions: 5616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.64 
    Pointer pages: 7, data page slots: 4136 
    Data pages: 3888, average fill: 86% 
    Primary pages: 3888, secondary pages: 0, swept pages: 2 
    Empty pages: 28, full pages: 3842 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 6 
    80 - 99% = 3842 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 147.53, total records: 154595 
    Average version length: 152.13, total versions: 3609, 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: 6192 
    Data pages: 3720, average fill: 86% 
    Primary pages: 3720, secondary pages: 0, swept pages: 1 
    Empty pages: 46, full pages: 3651 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 10 
    80 - 99% = 3651 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 150.65, total records: 176870 
    Average version length: 145.03, total versions: 815, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 8, data page slots: 6128 
    Data pages: 4240, average fill: 86% 
    Primary pages: 4239, secondary pages: 1, swept pages: 1 
    Empty pages: 37, full pages: 4191 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4192 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 147.04, total records: 169338 
    Average version length: 151.81, total versions: 4562, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 6344 
    Data pages: 4096, average fill: 85% 
    Primary pages: 4096, secondary pages: 0, swept pages: 2 
    Empty pages: 69, full pages: 4005 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 4004 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 146.50, total records: 166292 
    Average version length: 152.44, total versions: 4913, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 5056 
    Data pages: 4000, average fill: 86% 
    Primary pages: 3999, secondary pages: 1, swept pages: 3 
    Empty pages: 50, full pages: 3934 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 3931 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 137.33, total records: 180893 
    Average version length: 154.34, total versions: 16085, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.35 
    Pointer pages: 5, data page slots: 5912 
    Data pages: 4344, average fill: 86% 
    Primary pages: 4343, secondary pages: 1, swept pages: 3 
    Empty pages: 47, full pages: 4277 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 8 
    80 - 99% = 4277 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 145.13, total records: 173737 
    Average version length: 152.47, total versions: 6821, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 7, data page slots: 5376 
    Data pages: 4160, average fill: 86% 
    Primary pages: 4160, secondary pages: 0, swept pages: 1 
    Empty pages: 35, full pages: 4112 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4111 
 
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: 50.77, total records: 2105287 
    Average version length: 52.86, total versions: 79096, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.38 
    Pointer pages: 16, data page slots: 25424 
    Data pages: 25424, average fill: 72% 
    Primary pages: 25424, secondary pages: 0, swept pages: 8707 
    Empty pages: 284, full pages: 21704 
    Fill distribution: 
     0 - 19% = 540 
    20 - 39% = 436 
    40 - 59% = 954 
    60 - 79% = 22744 
    80 - 99% = 750 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2581, nodes: 2105287 
    Average node length: 5.44, total dup: 1964777, max dup: 1548 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182401, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 316 
        40 - 59% = 1639 
        60 - 79% = 323 
        80 - 99% = 299 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2759, nodes: 2105287 
    Average node length: 5.69, total dup: 1890298, max dup: 66 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 376379, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 2464 
        60 - 79% = 263 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2111, nodes: 2105287 
    Average node length: 4.96, total dup: 2105187, max dup: 28001 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 179679, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 175 
        40 - 59% = 1090 
        60 - 79% = 418 
        80 - 99% = 427 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 36.28, total records: 169963 
    Average version length: 69.18, total versions: 80898, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.47 
    Pointer pages: 3, data page slots: 3752 
    Data pages: 2920, average fill: 68% 
    Primary pages: 2920, secondary pages: 0, swept pages: 256 
    Empty pages: 359, full pages: 2269 
    Fill distribution: 
     0 - 19% = 464 
    20 - 39% = 12 
    40 - 59% = 63 
    60 - 79% = 895 
    80 - 99% = 1486 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103476, depth: 3, leaf buckets: 249, nodes: 169963 
    Average node length: 6.46, total dup: 147960, max dup: 29 
    Average key length: 3.91, compression ratio: 10.74 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 29149, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 132 
        60 - 79% = 62 
        80 - 99% = 18 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.15, total records: 7593696 
    Average version length: 68.75, total versions: 638328, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.00 
    Pointer pages: 65, data page slots: 105304 
    Data pages: 104568, average fill: 78% 
    Primary pages: 104568, secondary pages: 0, swept pages: 12512 
    Empty pages: 107, full pages: 103425 
    Fill distribution: 
     0 - 19% = 152 
    20 - 39% = 107 
    40 - 59% = 224 
    60 - 79% = 87461 
    80 - 99% = 16624 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10996, nodes: 7593696 
    Average node length: 6.50, total dup: 6574560, max dup: 29 
    Average key length: 3.51, compression ratio: 11.97 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1700205, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 1086 
        40 - 59% = 5995 
        60 - 79% = 3287 
        80 - 99% = 613 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 9026, nodes: 7593696 
    Average node length: 5.38, total dup: 7304504, max dup: 201 
    Average key length: 2.39, compression ratio: 7.11 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1476792, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 979 
        40 - 59% = 5317 
        60 - 79% = 1693 
        80 - 99% = 1029 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 9090, nodes: 7593696 
    Average node length: 5.38, total dup: 7304504, max dup: 201 
    Average key length: 2.39, compression ratio: 7.11 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1479462, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1089 
        40 - 59% = 5251 
        60 - 79% = 1692 
        80 - 99% = 1052 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.25, total records: 12604535 
    Average version length: 68.69, total versions: 494211, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 107, data page slots: 172792 
    Data pages: 172568, average fill: 78% 
    Primary pages: 172568, secondary pages: 0, swept pages: 60105 
    Empty pages: 40, full pages: 172357 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 56 
    40 - 59% = 39 
    60 - 79% = 159889 
    80 - 99% = 12530 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18631, nodes: 12604535 
    Average node length: 6.61, total dup: 10989899, max dup: 79 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2449974, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1610 
        40 - 59% = 10764 
        60 - 79% = 5310 
        80 - 99% = 924 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 30.20, total records: 2023220 
    Average version length: 69.11, total versions: 1139461, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.17 
    Pointer pages: 25, data page slots: 40176 
    Data pages: 27888, average fill: 85% 
    Primary pages: 27888, secondary pages: 0, swept pages: 723 
    Empty pages: 181, full pages: 27539 
    Fill distribution: 
     0 - 19% = 255 
    20 - 39% = 58 
    40 - 59% = 29 
    60 - 79% = 7945 
    80 - 99% = 19601 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2294, nodes: 2023220 
    Average node length: 5.50, total dup: 1941709, max dup: 99 
    Average key length: 2.54, compression ratio: 16.53 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 136383, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 135 
        40 - 59% = 1044 
        60 - 79% = 783 
        80 - 99% = 320 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.99, total records: 1217014 
    Average version length: 69.14, total versions: 582460, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.50 
    Pointer pages: 21, data page slots: 34200 
    Data pages: 27520, average fill: 52% 
    Primary pages: 27519, secondary pages: 1, swept pages: 5718 
    Empty pages: 6063, full pages: 13346 
    Fill distribution: 
     0 - 19% = 8477 
    20 - 39% = 1041 
    40 - 59% = 1663 
    60 - 79% = 8421 
    80 - 99% = 7918 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1631, nodes: 1217014 
    Average node length: 5.78, total dup: 1137239, max dup: 99 
    Average key length: 2.84, compression ratio: 14.77 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 166427, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 257 
        40 - 59% = 839 
        60 - 79% = 436 
        80 - 99% = 96 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 62.99, total records: 9300058 
    Average version length: 68.94, total versions: 797089, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.00 
    Pointer pages: 87, data page slots: 141752 
    Data pages: 141712, average fill: 71% 
    Primary pages: 141712, secondary pages: 0, swept pages: 29016 
    Empty pages: 358, full pages: 97642 
    Fill distribution: 
     0 - 19% = 1286 
    20 - 39% = 6387 
    40 - 59% = 19901 
    60 - 79% = 96735 
    80 - 99% = 17403 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13326, nodes: 9300058 
    Average node length: 6.67, total dup: 7717114, max dup: 25 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 1991920, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1093 
        40 - 59% = 6542 
        60 - 79% = 4853 
        80 - 99% = 831 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.44, total records: 21144135 
    Average version length: 82.93, total versions: 25034, 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: 318464 
    Data pages: 318464, average fill: 81% 
    Primary pages: 318464, secondary pages: 0, swept pages: 10557 
    Empty pages: 1, full pages: 318462 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 26459 
    80 - 99% = 292003 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19667, nodes: 21144135 
    Average node length: 5.72, total dup: 20663437, max dup: 165 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279612, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8743 
        60 - 79% = 544 
        80 - 99% = 10373 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17156, nodes: 21144135 
    Average node length: 6.31, total dup: 18582043, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913001, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 5 
        40 - 59% = 768 
        60 - 79% = 274 
        80 - 99% = 16107 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21486, nodes: 21144135 
    Average node length: 6.35, total dup: 18500777, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573808, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 3 
        40 - 59% = 9096 
        60 - 79% = 605 
        80 - 99% = 11780 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16147, nodes: 21144135 
    Average node length: 5.56, total dup: 21144035, max dup: 230453 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 941893, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2954 
        60 - 79% = 446 
        80 - 99% = 12740 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 75.64, total records: 9755367 
    Average version length: 82.61, total versions: 800873, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 102, data page slots: 165408 
    Data pages: 165360, average fill: 73% 
    Primary pages: 165360, secondary pages: 0, swept pages: 40051 
    Empty pages: 577, full pages: 115284 
    Fill distribution: 
     0 - 19% = 1485 
    20 - 39% = 5208 
    40 - 59% = 19458 
    60 - 79% = 58509 
    80 - 99% = 80700 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11317, nodes: 9755367 
    Average node length: 5.34, total dup: 9448177, max dup: 213 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2117552, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 8084 
        60 - 79% = 3096 
        80 - 99% = 98 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13515, nodes: 9755367 
    Average node length: 6.21, total dup: 8089871, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1465065, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 3657 
        40 - 59% = 4755 
        60 - 79% = 2540 
        80 - 99% = 2417 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12652, nodes: 9755367 
    Average node length: 5.95, total dup: 8476843, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2319935, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 66 
        40 - 59% = 9069 
        60 - 79% = 3378 
        80 - 99% = 134 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10104, nodes: 9755367 
    Average node length: 5.12, total dup: 9755267, max dup: 156226 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1474569, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1144 
        40 - 59% = 5118 
        60 - 79% = 1677 
        80 - 99% = 2125 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 77.56, total records: 11229111 
    Average version length: 82.58, total versions: 644212, 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: 118, data page slots: 190904 
    Data pages: 189648, average fill: 73% 
    Primary pages: 189648, secondary pages: 0, swept pages: 61409 
    Empty pages: 3309, full pages: 142382 
    Fill distribution: 
     0 - 19% = 5628 
    20 - 39% = 7742 
    40 - 59% = 17246 
    60 - 79% = 39871 
    80 - 99% = 119161 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13109, nodes: 11229111 
    Average node length: 5.30, total dup: 11120137, max dup: 647 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2334994, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 153 
        40 - 59% = 9337 
        60 - 79% = 3534 
        80 - 99% = 85 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10394, nodes: 11229111 
    Average node length: 5.49, total dup: 10738532, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 700299, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 156 
        20 - 39% = 877 
        40 - 59% = 2584 
        60 - 79% = 1773 
        80 - 99% = 5004 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14992, nodes: 11229111 
    Average node length: 6.02, total dup: 9800887, max dup: 80 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2351593, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 228 
        40 - 59% = 10773 
        60 - 79% = 3873 
        80 - 99% = 116 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10614, nodes: 11229111 
    Average node length: 5.22, total dup: 11229011, max dup: 193948 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 689120, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 84 
        20 - 39% = 793 
        40 - 59% = 4714 
        60 - 79% = 1428 
        80 - 99% = 3595 
 
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: 76.21, total records: 9842431 
    Average version length: 82.90, total versions: 775845, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 103, data page slots: 168000 
    Data pages: 167944, average fill: 73% 
    Primary pages: 167944, secondary pages: 0, swept pages: 43293 
    Empty pages: 368, full pages: 113324 
    Fill distribution: 
     0 - 19% = 1189 
    20 - 39% = 5402 
    40 - 59% = 20535 
    60 - 79% = 63297 
    80 - 99% = 77521 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11690, nodes: 9842431 
    Average node length: 5.15, total dup: 9813904, max dup: 2307 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1946387, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1407 
        40 - 59% = 7640 
        60 - 79% = 2001 
        80 - 99% = 611 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13590, nodes: 9842431 
    Average node length: 6.22, total dup: 8162295, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1456139, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 169 
        20 - 39% = 3685 
        40 - 59% = 4631 
        60 - 79% = 2561 
        80 - 99% = 2544 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12323, nodes: 9842431 
    Average node length: 5.41, total dup: 9406423, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2083034, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1334 
        40 - 59% = 8589 
        60 - 79% = 1733 
        80 - 99% = 642 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10172, nodes: 9842431 
    Average node length: 5.13, total dup: 9842331, max dup: 158292 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1521927, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1124 
        40 - 59% = 5102 
        60 - 79% = 1766 
        80 - 99% = 2144 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.77, total records: 575387 
    Average version length: 68.81, total versions: 11770, 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: 5, data page slots: 7904 
    Data pages: 7904, average fill: 76% 
    Primary pages: 7904, secondary pages: 0, swept pages: 3009 
    Empty pages: 2, full pages: 7176 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 14 
    40 - 59% = 126 
    60 - 79% = 7516 
    80 - 99% = 244 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 41407, depth: 3, leaf buckets: 733, nodes: 575387 
    Average node length: 5.95, total dup: 489928, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100455, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 517 
        60 - 79% = 88 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31233, depth: 3, leaf buckets: 755, nodes: 575387 
    Average node length: 6.15, total dup: 471934, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100521, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 531 
        60 - 79% = 89 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 572, nodes: 575387 
    Average node length: 4.86, total dup: 575287, max dup: 9092 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89048, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 331 
        60 - 79% = 105 
        80 - 99% = 108 
 
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 Sat Feb 24 22:11:50 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7769638 162528 1 0.0000 0.0000
DOC_LIST 2251398 166261 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 245883 645 61400.0000 0.0000
INVNT_TURNOVER_LOG 106113 88441 1 0.0000 0.0000
MONEY_SALDO 49 18983 988 38700.0000 0.0000
MONEY_TURNOVER_LOG 1650 1502 1 0.0000 0.0000
PDISTR 852250 89143 4 0.0000 0.0000
PERF_SPLIT_0 194658 25329 1 0.0000 0.0000
PERF_SPLIT_1 185030 16646 1 0.0000 0.0000
PERF_SPLIT_2 168221 8435 1 0.0000 0.0000
PERF_SPLIT_3 162673 5616 1 0.0000 0.0000
PERF_SPLIT_4 154595 3609 1 0.0000 0.0000
PERF_SPLIT_5 176870 815 1 0.0000 0.0000
PERF_SPLIT_6 169338 4562 1 0.0000 0.0000
PERF_SPLIT_7 166292 4913 1 0.0000 0.0000
PERF_SPLIT_8 180893 16085 1 0.0000 0.0000
PERF_SPLIT_9 173737 6821 1 0.0000 0.0000
PSTORNED 2105287 79096 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 169963 80898 1 0.0000 0.0000
XQD_1000_3300 7593696 638328 1 0.0000 0.0000
XQD_1200_2000 12604535 494211 1 0.0000 0.0000
XQD_2000_3300 2023220 1139461 1 0.0000 0.0000
XQD_2100_3300 1217014 582460 1 0.0000 0.0000
XQD_3300_3400 9300058 797089 1 0.0000 0.0000
XQS_1000_1200 21144135 25034 1 0.0000 0.0000
XQS_1000_3300 9755367 800873 1 0.0000 0.0000
XQS_1200_2000 11229111 644212 1 0.0000 0.0000
XQS_2100_3300 9842431 775845 1 0.0000 0.0000
XQS_3300_3400 575387 11770 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 ---
:1110: 
:1111: mscs-test-161.budzdorov.ru    Sat Feb 24 22:10:03 2024
:1112:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1113: 
--- end of diff output ---

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

24.02.24 22:12:01. 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-24 22:12:04 No severe PSQL-related problems occured
24.02.24 22:12:05. End of report.