Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.03.2024 13:09
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 15688060 kB
MemAvailable 30309576 kB
Buffers 0 kB
Cached 16064500 kB
SwapCached 2712 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 4.0.5
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-17 13:07:51
DTS_END                         2024-03-17 13:07:51.3370
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/56104
TRN_ID                          183248
ATT_ID                          622
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: 9440.05 17722 944005
customer order: creation 188.31 386 18831
customer order: refuse 15.40 376 1540
order to supplier: creation 49.96 1225 4996
order to supplier: removal 3.59 78940 359
invoice (draft): creation 50.41 3242 5041
invoice (draft): removal 49.08 685 4908
invoice accept: apply 45.45 21487 4545
invoice accept: cancel 45.10 940 4510
customer reserve: creation 4273.72 211 427372
customer reserve: removal 4403.58 51 440358
realization accept: apply 90.37 218 9037
realization accept: cancel 83.87 122 8387
payment from customer: creation 64.81 146 6481
payment from customer: removal 6.01 85 601
payment to supplier: creation 54.09 139 5409
payment to supplier: removal 3.84 88 384
service: total inventory turnovers 4.73 3318 473
service: total monetary turnovers 6.68 525 668
service: aggregate perf. data 1.02 13611 102
service: refresh index statistics 0.03 228644 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-03-2024 13:09:45 to 17-03-2024 13:09:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2410
TEST_TIME 2 3709
TEST_TIME 3 3676
TEST_TIME 4 4479
TEST_TIME 5 4942
TEST_TIME 6 5418
TEST_TIME 7 6033
TEST_TIME 8 6284
TEST_TIME 9 6422
TEST_TIME 10 6363
TEST_TIME 11 7293
TEST_TIME 12 7236
TEST_TIME 13 7279
TEST_TIME 14 7377
TEST_TIME 15 7643
TEST_TIME 16 7688
TEST_TIME 17 7742
TEST_TIME 18 8189
TEST_TIME 19 8504
TEST_TIME 20 8592
TEST_TIME 21 8313
TEST_TIME 22 8697
TEST_TIME 23 8781
TEST_TIME 24 8691
TEST_TIME 25 9492
TEST_TIME 26 9351
TEST_TIME 27 9564
TEST_TIME 28 9486
TEST_TIME 29 9492
TEST_TIME 30 9392
TEST_TIME 31 9645
TEST_TIME 32 9626
TEST_TIME 33 9598
TEST_TIME 34 9731
TEST_TIME 35 9743
TEST_TIME 36 9600
TEST_TIME 37 9427
TEST_TIME 38 9456
TEST_TIME 39 9427
TEST_TIME 40 9302
TEST_TIME 41 9353
TEST_TIME 42 9396
TEST_TIME 43 9306
TEST_TIME 44 9221
TEST_TIME 45 9104
TEST_TIME 46 9032
TEST_TIME 47 8978
TEST_TIME 48 9226
TEST_TIME 49 9424
TEST_TIME 50 9353
TEST_TIME 51 9417
TEST_TIME 52 9560
TEST_TIME 53 9549
TEST_TIME 54 9507
TEST_TIME 55 9571
TEST_TIME 56 9659
TEST_TIME 57 9685
TEST_TIME 58 9714
TEST_TIME 59 9608
TEST_TIME 60 9573
TEST_TIME 61 9460
TEST_TIME 62 9435
TEST_TIME 63 9454
TEST_TIME 64 9408
TEST_TIME 65 9340
TEST_TIME 66 9275
TEST_TIME 67 9302
TEST_TIME 68 9255
TEST_TIME 69 9325
TEST_TIME 70 9337
TEST_TIME 71 9333
TEST_TIME 72 9382
TEST_TIME 73 9377
TEST_TIME 74 9402
TEST_TIME 75 9413
TEST_TIME 76 9492
TEST_TIME 77 9514
TEST_TIME 78 9554
TEST_TIME 79 9562
TEST_TIME 80 9646
TEST_TIME 81 9597
TEST_TIME 82 9498
TEST_TIME 83 9484
TEST_TIME 84 9413
TEST_TIME 85 9448
TEST_TIME 86 9397
TEST_TIME 87 9401
TEST_TIME 88 9391
TEST_TIME 89 9386
TEST_TIME 90 9403
TEST_TIME 91 9456
TEST_TIME 92 9517
TEST_TIME 93 9463
TEST_TIME 94 9526
TEST_TIME 95 9526
TEST_TIME 96 9528
TEST_TIME 97 9497
TEST_TIME 98 9514
TEST_TIME 99 9432
TEST_TIME 100 9442

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-03-2024 13:09:49 to 17-03-2024 13:09:52.

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 1335228 1335228 0 0.00 0 19045 8 0 0
doc_list_biud 1335228 1335228 0 0.00 0 64659 22 0 0
sp_add_invoice_to_stock 4661 4545 116 2.48 25 231331 21487 0 116
sp_cancel_adding_invoice 4510 4510 0 0.00 3 70271 940 0 0
sp_cancel_client_order 1540 1540 0 0.00 4 7872 376 0 0
sp_cancel_customer_reserve 440358 440358 0 0.00 0 64660 52 0 0
sp_cancel_pay_from_customer 601 601 0 0.00 2 10272 85 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 2 3565 88 0 0
sp_cancel_supplier_invoice 4916 4908 8 0.16 1 24494 685 0 8
sp_cancel_supplier_order 359 359 0 0.00 5 697571 78940 0 0
sp_cancel_write_off 8387 8387 0 0.00 1 10506 123 0 0
sp_client_order 18831 18831 0 0.00 3 18992 387 0 0
sp_customer_reserve 427372 427372 0 0.00 0 68908 211 0 0
sp_fill_shopping_cart 28863 28863 0 0.00 1 12182 35 0 0
sp_fill_shopping_cart_clo_res 427367 427367 0 0.00 0 20554 17 0 0
sp_get_clo_for_invoice 4540 4540 0 0.00 0 50346 353 0 0
sp_kill_cost_storno 13882 13882 0 0.00 0 10502 69 0 0
sp_kill_qstorno_ret_qs2qd 894370 894370 0 0.00 0 64657 28 0 0
sp_kill_qty_storno 473639 473639 0 0.00 0 64659 61 0 0
sp_lock_selected_doc 18770 18770 0 0.00 0 10239 8 0 0
sp_make_cost_storno 25467 25467 0 0.00 0 19009 69 0 0
sp_multiply_rows_for_pdistr 25467 25467 0 0.00 0 10199 37 0 0
sp_multiply_rows_for_qdistr 18831 18831 0 0.00 0 18974 189 0 0
sp_pay_from_customer 6481 6481 0 0.00 4 19891 146 0 0
sp_pay_to_supplier 5409 5409 0 0.00 4 12015 140 0 0
sp_payment_common 11890 11890 0 0.00 1 13699 33 0 0
sp_qd_handle_on_cancel_clo 1540 1540 0 0.00 0 7864 345 0 0
sp_qd_handle_on_invoice_upd_sts 9050 9050 0 0.00 0 24889 310 0 0
sp_qd_handle_on_reserve_upd_sts 9037 9037 0 0.00 0 21864 67 0 0
sp_reserve_write_off 9037 9037 0 0.00 6 21884 219 0 0
sp_supplier_invoice 5041 5041 0 0.00 4 86558 3242 0 0
sp_supplier_order 4996 4996 0 0.00 4 32883 1225 0 0
srv_aggregate_perf_data 102 102 0 0.00 2066 377124 13612 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1318 126939 40838 0 0
srv_find_qd_qs_mism 898000 898000 0 0.00 0 12367 8 0 0
srv_make_invnt_saldo 473 473 0 0.00 50 82405 3319 0 0
srv_make_money_saldo 668 668 0 0.00 1 15673 526 0 0
srv_recalc_idx_stat 3 3 0 0.00 127415 368613 228644 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4545 4545 0 0.00 0 6032 157 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 0 2504 99 0 0
t$perf-norm:sp_cancel_client_order 1540 1540 0 0.00 0 7858 15 0 0
t$perf-norm:sp_cancel_customer_reserve 609 609 0 0.00 0 2550 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 601 601 0 0.00 0 3466 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 2463 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 321 321 0 0.00 0 905 15 0 0
t$perf-norm:sp_cancel_supplier_order 359 359 0 0.00 0 29825 1554 0 0
t$perf-norm:sp_cancel_write_off 975 975 0 0.00 0 6905 13 0 0
t$perf-norm:sp_client_order 18831 18831 0 0.00 0 11153 15 0 0
t$perf-norm:sp_customer_reserve 923 923 0 0.00 0 4592 16 0 0
t$perf-norm:sp_pay_from_customer 6481 6481 0 0.00 0 7287 9 0 0
t$perf-norm:sp_pay_to_supplier 5409 5409 0 0.00 0 3566 9 0 0
t$perf-norm:sp_reserve_write_off 9038 9038 0 0.00 0 9355 9 0 0
t$perf-norm:sp_supplier_invoice 5041 5041 0 0.00 0 3841 16 0 0
t$perf-norm:sp_supplier_order 4996 4996 0 0.00 0 5916 14 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 178 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 80 2 0 0
t$perf-norm:srv_make_invnt_saldo 473 473 0 0.00 0 1737 7 0 0
t$perf-norm:srv_make_money_saldo 668 668 0 0.00 0 485 4 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 3 3 0 0
v_add_invoice_to_stock 9312 9080 232 2.49 0 5668 18 0 232
v_all_customers 35176 35176 0 0.00 0 68 1 0 0
v_all_suppliers 28488 28488 0 0.00 0 34 1 0 0
v_all_wares 37662 37662 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 1357 9 0 0
v_cancel_client_order 3080 3080 0 0.00 0 1268 4 0 0
v_cancel_customer_prepayment 1202 1202 0 0.00 0 1233 5 0 0
v_cancel_customer_reserve 1218 1218 0 0.00 0 2169 7 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 2541 8 0 0
v_cancel_supplier_invoice 658 642 16 2.43 0 1371 17 0 16
v_cancel_supplier_order 718 718 0 0.00 0 1786 12 0 0
v_cancel_write_off 1950 1950 0 0.00 0 1776 15 0 0
v_max_id_clo_ord 4994 4994 0 0.00 0 785 1 0 0
v_max_id_clo_res 923 923 0 0.00 0 2836 11 0 0
v_max_id_ord_sup 5038 5038 0 0.00 0 5070 4 0 0
v_max_non_paid_invoice 1197 1197 0 0.00 0 761 2 0 0
v_max_non_paid_realizn 3058 3058 0 0.00 0 10580 7 0 0
v_min_id_clo_ord 4994 4994 0 0.00 0 10314 10 0 0
v_min_id_clo_res 923 923 0 0.00 0 7540 17 0 0
v_min_id_ord_sup 5038 5038 0 0.00 0 2723 3 0 0
v_min_non_paid_invoice 5409 5409 0 0.00 0 11898 22 0 0
v_min_non_paid_realizn 6481 6481 0 0.00 0 8307 26 0 0
v_our_firm 9332 9332 0 0.00 0 75 1 0 0
v_reserve_write_off 18074 18074 0 0.00 0 3005 6 0 0
x_lock_depdocs_on_canc_invoice 9097 9097 0 0.00 0 15456 119 0 0
x_lock_depdocs_on_canc_sup_ord 359 359 0 0.00 0 9467 340 0 0
x_make_qstorno_1000_1200 4996 4996 0 0.00 1 32842 1148 0 0
x_make_qstorno_1200_2000 5041 5041 0 0.00 2 86493 3120 0 0
x_make_qstorno_2100_3300 427372 427372 0 0.00 0 68883 192 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-03-2024 13:09:53 to 17-03-2024 13:09:57.

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
11:07:55 6 8192000000 8803588880 8816746496 8444656 0.102 3 2 3 0 8639088 125040 69392
11:08:56 42476 8192000000 9729267104 10031292416 807587904 8.973 100 94 188 0 837091328 8368432 21134992
11:10:44 11063 8192000000 9757580560 10066313216 833121392 9.231 100 92 184 0 866571440 12237376 21212672
11:11:58 16606 8192000000 9785898640 10102804480 856050384 9.461 100 90 180 0 895827520 19840800 19936336
11:13:18 11369 8192000000 9830504432 10164297728 890792096 9.807 100 76 152 0 942074960 34749504 16533360
11:14:33 4600 8192000000 9896591296 10238111744 924183168 10.137 100 80 160 0 1007518336 66610032 16725136
11:15:39 3708 8192000000 9930254576 10282450944 961429072 10.503 100 73 146 0 1050055408 74370784 14255552
11:16:46 2113 8192000000 9980053920 10339614720 996871376 10.848 100 85 166 1 1088624656 75589936 16163344
11:17:50 2052 8192000000 9992097248 10362085376 1023792864 11.109 100 78 152 0 1111944208 73350160 14801184
11:18:53 937 8192000000 10008941280 10379845632 1043719856 11.300 100 91 181 1 1121624944 59114192 18790896
11:19:55 46965 8192000000 10001031424 10396684288 1058561216 11.443 100 58 114 0 1127231696 56712752 11957728
11:21:44 7151 8192000000 9982797792 10381946880 1065118016 11.505 100 24 45 0 1096325584 26888928 4318640
11:22:52 8175 8192000000 10000559520 10397429760 1074408784 11.594 100 28 55 0 1118411776 38340656 5662336
11:24:01 59787 8192000000 9994034048 10416795648 1079085264 11.639 100 34 68 0 1114774672 28717264 6972144
11:26:01 4880 8192000000 10012074384 10410704896 1090152032 11.744 100 48 98 2 1122350080 21718192 10479856
11:27:09 5408 8192000000 9998287168 10402299904 1082207792 11.669 99 35 68 0 1101223728 11904032 7111904
11:28:21 30227 8192000000 10021328704 10411339776 1065898608 11.513 97 46 93 1 1104779152 29302496 9578048
11:29:54 21284 8192000000 10018101136 10424561664 1086538272 11.710 99 31 62 1 1145225008 52139696 6547040
11:31:18 21128 8192000000 10052526736 10457837568 1082069824 11.667 98 36 72 0 1174432032 84978736 7383472
11:32:48 8484 8192000000 10065663600 10473844736 1073483616 11.585 99 45 91 1 1177841504 94647136 9710752
11:34:00 4733 8192000000 10083761408 10478481408 1073032016 11.581 99 63 126 0 1180436816 94756128 12648672
11:35:08 1546 8192000000 10080646208 10462035968 1068096480 11.534 100 76 150 1 1186599264 103175952 15326832
11:36:12 46172 8192000000 10064840528 10463719424 1034180432 11.209 97 35 68 1 1145631376 104255872 7195072
11:38:03 9192 8192000000 10085187600 10471059456 1052065712 11.380 98 55 108 0 1177242304 113506192 11670400
11:39:14 3134 8192000000 10088640480 10480582656 1087050608 11.715 100 67 129 0 1194698560 94502880 13145072
11:40:21 4723 8192000000 10105161856 10490425344 1076253616 11.612 98 60 119 1 1207150272 118896720 11999936
11:41:31 1313 8192000000 10191998512 10577453056 1112476016 11.956 100 83 161 0 1290356848 161134512 16746320
11:42:36 5460 8192000000 10221586320 10628935680 1117775568 12.006 100 77 151 0 1322707904 188611248 16321088
11:43:47 3688 8192000000 10244785152 10642251776 1128392528 12.106 100 77 151 0 1341322368 197197040 15732800
11:44:53 5754 8192000000 10280559696 10694062080 1128838592 12.110 100 76 152 0 1395833760 250579376 16415792
11:46:03 3514 8192000000 10254681472 10672398336 1137191584 12.189 100 71 137 1 1353501344 201264080 15045680
11:47:10 4551 8192000000 10254705424 10669305856 1141337328 12.228 100 52 103 0 1354693408 201871056 11485024
11:48:25 34959 8192000000 10296146896 10725318656 1141126896 12.226 100 58 115 0 1379664816 225110960 13426960
11:50:27 19326 8192000000 10209202704 10681905152 1134810752 12.167 99 20 40 0 1327409120 187950160 4648208
11:52:13 126938 8192000000 10086844688 10627153920 1115221152 11.982 99 10 20 0 1251349904 133679712 2449040
11:55:21 59388 8192000000 10098580656 10547458048 1134714240 12.166 100 12 24 0 1192018112 54829536 2474336
11:57:23 10783 8192000000 10107281312 10531500032 1139174288 12.208 100 50 102 0 1200357424 49874256 11308880
11:58:38 113112 8192000000 10115038944 10583633920 1134011744 12.159 99 6 12 0 1191417680 56166336 1239600
12:01:33 33609 8192000000 10113093840 10564939776 1139643456 12.212 99 11 22 0 1184958176 43083952 2230768
12:03:22 112369 8192000000 10101690752 10563792896 1155108624 12.357 100 23 46 1 1213564224 52974800 5480800
12:06:26 34795 8192000000 10070066352 10532528128 1143608112 12.249 100 20 39 1 1178690464 31271680 3810672
12:08:03 19634 8192000000 10132583600 10579406848 1144812624 12.261 99 46 93 0 1226269664 72495952 8961088
12:09:24 10612 8192000000 10097723808 10539319296 1125312288 12.077 99 36 69 0 1202882256 70816304 6753664
12:10:39 37573 8192000000 10119388640 10569662464 1121030112 12.037 98 19 38 1 1188027152 62832816 4164224
12:12:17 81802 8192000000 10156301392 10609582080 1126330720 12.087 99 22 44 0 1234495328 103516864 4647744
12:14:40 59250 8192000000 10104941120 10556129280 1067111328 11.524 94 11 22 0 1224432000 154624496 2696176
12:17:21 19391 8192000000 10083835280 10500739072 1084388112 11.689 97 50 100 0 1143353632 48315232 10650288
12:18:41 32371 8192000000 10076881824 10532745216 1089607536 11.739 98 33 66 0 1180791552 84430000 6754016
12:20:21 47356 8192000000 10036523616 10464145408 1080854064 11.656 98 31 62 0 1114543504 27053216 6636224
12:22:11 17678 8192000000 10080619776 10494906368 1100114848 11.839 100 51 102 0 1166764112 57118096 9531168
12:23:30 75061 8192000000 10071176944 10519871488 1050564656 11.366 95 15 30 0 1101957632 48607136 2785840
12:25:46 82206 8192000000 10046259632 10477961216 1100773648 11.845 100 37 74 0 1158899728 50848880 7277200
12:28:12 49721 8192000000 10030880784 10483154944 1075521728 11.605 98 25 50 1 1121096128 40653840 4920560
12:30:03 37605 8192000000 10002362208 10483486720 1084943728 11.695 99 16 32 1 1124263216 36288064 3031424
12:31:53 35997 8192000000 10031750592 10495250432 1096734752 11.807 100 12 24 0 1146653376 47252384 2666240
12:33:39 50836 8192000000 10054088592 10521944064 1091999792 11.762 100 17 34 0 1159714576 63911344 3803440
12:35:31 52988 8192000000 10040330544 10483318784 1111279728 11.945 100 23 46 0 1176949408 60788960 4880720
12:37:27 42054 8192000000 10051846432 10473709568 1117303792 12.002 99 25 50 0 1153673440 32084432 4285216
12:39:14 38656 8192000000 10076924880 10520875008 1129271840 12.114 100 44 88 2 1192631952 54214144 9145968
12:40:57 13871 8192000000 10085019024 10515824640 1114627840 11.976 98 33 66 0 1165746192 45045920 6072432
12:42:16 21450 8192000000 10084740272 10515955712 1125744608 12.081 99 37 74 0 1160414784 27641104 7029072
12:43:41 50805 8192000000 10111773248 10557104128 1132971456 12.149 99 31 62 0 1194756864 55708176 6077232
12:45:38 37128 8192000000 10104700816 10542383104 1130779408 12.129 98 32 64 0 1189106608 51713712 6613488
12:47:16 92659 8192000000 10107182032 10653732864 1142152160 12.236 99 13 26 1 1248516416 102871648 3492608
12:50:38 78537 8192000000 10095552752 10574745600 1141082352 12.226 99 11 22 0 1213374592 69890896 2401344
12:53:01 39809 8192000000 10065170448 10525020160 1112316128 11.954 97 10 21 1 1151662960 37463904 1882928
12:54:58 65009 8192000000 10102710912 10568237056 1097872640 11.817 96 20 40 0 1170232256 68136848 4222768
12:57:20 74174 8192000000 10095661568 10567159808 1120353936 12.030 98 15 30 0 1193006656 69085776 3566944
12:59:35 72943 8192000000 10087922768 10520690688 1096860944 11.808 96 19 38 2 1140667680 39878912 3927824
13:01:48 90367 8192000000 10040711232 10500276224 1063210736 11.487 94 11 22 0 1116396080 51154512 2030832
13:04:27 26001 8192000000 10073898800 10481770496 1079383120 11.642 98 52 104 1 1132952752 43903856 9665776
13:06:01 113197 8192000000 9701268528 10122571776 801353120 8.910 73 23 46 0 850398480 44395792 4649568

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 17-03-2024 13:09:59 to 17-03-2024 13:10:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 116 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-03-2024 13:10:14 to 17-03-2024 13:10:16.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          182773
MON$OLDEST_ACTIVE               183492
MON$OLDEST_SNAPSHOT             183492
MON$NEXT_TRANSACTION            183492
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-30 07:30:08.6030 GMT
MON$PAGES                       1922720
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             722
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3080 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3080 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3080 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3080 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sun Mar 17 13:10:17 2024 
 
Database header page information: 
    Flags            0 
    Generation        96020 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    182773 
    Oldest active        183492 
    Oldest snapshot        183492 
    Next transaction    183493 
    Sequence number        0 
    Next attachment ID    722 
    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 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    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: 1504333, 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: 1504335, 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: 1504334, 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: 1504332, 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: 1504331, 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: 532, Index root page: 533 
    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: 1504264, 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: 1504266, 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: 1504265, 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: 1504263, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.69, total records: 7750495 
    Average version length: 48.17, total versions: 39862, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 56, data page slots: 89952 
    Data pages: 89952, average fill: 69% 
    Primary pages: 89951, secondary pages: 1, swept pages: 51208 
    Empty pages: 4, full pages: 56778 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 183 
    40 - 59% = 3974 
    60 - 79% = 85760 
    80 - 99% = 17 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23405, nodes: 7750495 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1684182, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 339 
        20 - 39% = 1955 
        40 - 59% = 4045 
        60 - 79% = 2575 
        80 - 99% = 14491 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13561, nodes: 7750495 
    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: 1507765, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1635 
        40 - 59% = 1993 
        60 - 79% = 1156 
        80 - 99% = 8777 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8370, nodes: 7750495 
    Average node length: 6.61, total dup: 5798944, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1501001, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 1023 
        40 - 59% = 1353 
        60 - 79% = 998 
        80 - 99% = 4888 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.01, total records: 2242984 
    Average version length: 58.87, total versions: 20246, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 29088 
    Data pages: 29088, average fill: 71% 
    Primary pages: 29088, secondary pages: 0, swept pages: 17648 
    Empty pages: 3, full pages: 13267 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 39 
    40 - 59% = 704 
    60 - 79% = 28298 
    80 - 99% = 39 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4608, nodes: 2242984 
    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: 679564, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1002 
        40 - 59% = 812 
        60 - 79% = 780 
        80 - 99% = 2014 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2422, nodes: 2243900 
    Average node length: 4.97, total dup: 2243001, max dup: 18735 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1275339, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 206 
        40 - 59% = 1403 
        60 - 79% = 570 
        80 - 99% = 239 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1815, nodes: 2242984 
    Average node length: 4.97, total dup: 2242934, max dup: 130493 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074135, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 660 
        60 - 79% = 48 
        80 - 99% = 1101 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4407, nodes: 2242984 
    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: 679564, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 109 
        20 - 39% = 656 
        40 - 59% = 605 
        60 - 79% = 885 
        80 - 99% = 2152 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    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: 1504337, 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: 1504338, 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: 1504336, 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: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, 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.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, 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: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.36, total records: 400 
    Average version length: 23.77, total versions: 1292, max versions: 11 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 30% 
    Primary pages: 7, secondary pages: 33, swept pages: 0 
    Empty pages: 9, full pages: 10 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 9 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, 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: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 30.43, total records: 87835 
    Average version length: 68.28, total versions: 56100, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 2.89 
    Pointer pages: 7, data page slots: 2928 
    Data pages: 1312, average fill: 84% 
    Primary pages: 1311, secondary pages: 1, swept pages: 10 
    Empty pages: 19, full pages: 1256 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 16 
    40 - 59% = 13 
    60 - 79% = 385 
    80 - 99% = 872 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1711609, depth: 3, leaf buckets: 210, nodes: 87835 
    Average node length: 13.06, total dup: 6203, max dup: 2 
    Average key length: 10.69, compression ratio: 2.52 
    Average prefix length: 19.23, average data length: 7.77 
    Clustering factor: 64549, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 83 
        60 - 79% = 76 
        80 - 99% = 51 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 271, max versions: 11 
    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: 8 
    Data pages: 8, average fill: 14% 
    Primary pages: 1, secondary pages: 7, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, 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: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 22.75, total records: 1571 
    Average version length: 42.89, total versions: 960, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 2.55 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 47% 
    Primary pages: 31, secondary pages: 1, swept pages: 11 
    Empty pages: 11, full pages: 16 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93384, depth: 2, leaf buckets: 3, nodes: 1571 
    Average node length: 4.21, total dup: 1473, max dup: 178 
    Average key length: 2.66, compression ratio: 7.14 
    Average prefix length: 18.40, average data length: 0.60 
    Clustering factor: 820, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.61, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    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 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    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: 1504251, 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: 1504249, 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: 1504248, 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: 1504250, 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: 1504247, 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: 550, Index root page: 551 
    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: 1504246, 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: 1504244, 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: 1504243, 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: 1504245, 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: 1504242, 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: 496, Index root page: 497 
    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: 1544827, 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: 1544826, 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: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.94, total records: 791061 
    Average version length: 37.87, total versions: 19071, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8456 
    Data pages: 8456, average fill: 64% 
    Primary pages: 8455, secondary pages: 1, swept pages: 3400 
    Empty pages: 20, full pages: 4841 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 42 
    40 - 59% = 870 
    60 - 79% = 7470 
    80 - 99% = 36 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 850, nodes: 784516 
    Average node length: 4.88, total dup: 784467, max dup: 144496 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91576, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 118 
        40 - 59% = 456 
        60 - 79% = 180 
        80 - 99% = 94 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 918, nodes: 784516 
    Average node length: 5.88, total dup: 698418, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160040, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 51 
        40 - 59% = 470 
        60 - 79% = 116 
        80 - 99% = 280 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 954, nodes: 784516 
    Average node length: 5.88, total dup: 698418, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161957, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 103 
        40 - 59% = 475 
        60 - 79% = 107 
        80 - 99% = 269 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1124, nodes: 784516 
    Average node length: 5.97, total dup: 698418, max dup: 43 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154676, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 231 
        40 - 59% = 620 
        60 - 79% = 179 
        80 - 99% = 88 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5440 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.62, total fragments: 16, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 87, average fill: 62% 
    Primary pages: 78, secondary pages: 9, swept pages: 58 
    Empty pages: 6, full pages: 70 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5440 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.39, average data length: 1.55 
    Clustering factor: 5159, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5440 
    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: 174, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.06, total records: 83425 
    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: 872 
    Data pages: 872, average fill: 66% 
    Primary pages: 872, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 866 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 866 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 39998, depth: 2, leaf buckets: 108, nodes: 83425 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3319, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 104 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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: 1504261, 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: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.04, 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: 1691.00, compression ratio: 15.23 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 144.59, total records: 183539 
    Average version length: 151.79, total versions: 8559, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 6, data page slots: 6736 
    Data pages: 4744, average fill: 80% 
    Primary pages: 4742, secondary pages: 2, swept pages: 4 
    Empty pages: 199, full pages: 4484 
    Fill distribution: 
     0 - 19% = 206 
    20 - 39% = 28 
    40 - 59% = 11 
    60 - 79% = 15 
    80 - 99% = 4484 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 135.11, total records: 165007 
    Average version length: 154.12, total versions: 18507, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.55 
    Pointer pages: 6, data page slots: 5080 
    Data pages: 4176, average fill: 83% 
    Primary pages: 4174, secondary pages: 2, swept pages: 1 
    Empty pages: 108, full pages: 4044 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 10 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 4045 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 127.30, total records: 211440 
    Average version length: 154.46, total versions: 35552, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.32 
    Pointer pages: 6, data page slots: 6256 
    Data pages: 5296, average fill: 85% 
    Primary pages: 5295, secondary pages: 1, swept pages: 1 
    Empty pages: 72, full pages: 5195 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 7 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 5195 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 121.89, total records: 203490 
    Average version length: 154.31, total versions: 41710, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.91 
    Pointer pages: 8, data page slots: 5536 
    Data pages: 5112, average fill: 85% 
    Primary pages: 5111, secondary pages: 1, swept pages: 5 
    Empty pages: 86, full pages: 4986 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 11 
    40 - 59% = 8 
    60 - 79% = 20 
    80 - 99% = 4987 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.54, total records: 173995 
    Average version length: 152.72, total versions: 10476, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.90 
    Pointer pages: 6, data page slots: 5136 
    Data pages: 4392, average fill: 82% 
    Primary pages: 4390, secondary pages: 2, swept pages: 2 
    Empty pages: 101, full pages: 4257 
    Fill distribution: 
     0 - 19% = 102 
    20 - 39% = 12 
    40 - 59% = 11 
    60 - 79% = 10 
    80 - 99% = 4257 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 142.47, total records: 183197 
    Average version length: 152.75, total versions: 11102, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.90 
    Pointer pages: 7, data page slots: 5768 
    Data pages: 4584, average fill: 83% 
    Primary pages: 4581, secondary pages: 3, swept pages: 5 
    Empty pages: 70, full pages: 4478 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 8 
    40 - 59% = 12 
    60 - 79% = 14 
    80 - 99% = 4478 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 142.39, total records: 174659 
    Average version length: 152.82, total versions: 10886, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 8, data page slots: 5528 
    Data pages: 4360, average fill: 83% 
    Primary pages: 4358, secondary pages: 2, swept pages: 1 
    Empty pages: 56, full pages: 4281 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 4281 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 128.62, total records: 188784 
    Average version length: 154.14, total versions: 29847, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.19 
    Pointer pages: 6, data page slots: 6664 
    Data pages: 4752, average fill: 84% 
    Primary pages: 4750, secondary pages: 2, swept pages: 3 
    Empty pages: 86, full pages: 4627 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 12 
    40 - 59% = 14 
    60 - 79% = 11 
    80 - 99% = 4626 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 127.05, total records: 179073 
    Average version length: 154.48, total versions: 30063, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.35 
    Pointer pages: 6, data page slots: 6416 
    Data pages: 4528, average fill: 84% 
    Primary pages: 4524, secondary pages: 4, swept pages: 2 
    Empty pages: 102, full pages: 4383 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 12 
    40 - 59% = 13 
    60 - 79% = 15 
    80 - 99% = 4383 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 145.18, total records: 147437 
    Average version length: 151.27, total versions: 5636, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 6, data page slots: 4272 
    Data pages: 3704, average fill: 82% 
    Primary pages: 3702, secondary pages: 2, swept pages: 1 
    Empty pages: 76, full pages: 3598 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 9 
    40 - 59% = 8 
    60 - 79% = 10 
    80 - 99% = 3597 
 
PHRASES (143) 
    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 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, 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: 1510375, 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: 1510374, 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: 1510373, 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: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.34, total records: 2094393 
    Average version length: 53.02, total versions: 19721, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25808 
    Data pages: 25808, average fill: 70% 
    Primary pages: 25796, secondary pages: 12, swept pages: 12684 
    Empty pages: 106, full pages: 21333 
    Fill distribution: 
     0 - 19% = 259 
    20 - 39% = 309 
    40 - 59% = 1068 
    60 - 79% = 23978 
    80 - 99% = 194 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2596, nodes: 2094393 
    Average node length: 5.44, total dup: 1954298, max dup: 1572 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182156, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 310 
        40 - 59% = 1704 
        60 - 79% = 301 
        80 - 99% = 278 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2766, nodes: 2094393 
    Average node length: 5.69, total dup: 1879472, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375221, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2461 
        60 - 79% = 273 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2128, nodes: 2094393 
    Average node length: 4.96, total dup: 2094293, max dup: 27934 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 180189, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 200 
        40 - 59% = 1089 
        60 - 79% = 415 
        80 - 99% = 421 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    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: 1504339, 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: 498, Index root page: 499 
    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: 1544825, 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: 1544824, 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: 528, Index root page: 529 
    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: 1504327, 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: 1504328, 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: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, 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: 1544931, 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: 1544828, 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: 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 TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, 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: 488, Index root page: 489 
    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: 1544829, 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: 490, Index root page: 491 
    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: 492, Index root page: 493 
    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: 546, Index root page: 547 
    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: 544, Index root page: 545 
    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: 1504252, 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: 486, Index root page: 487 
    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: 484, Index root page: 485 
    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: 1544831, 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: 1544830, 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: 480, Index root page: 481 
    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: 1544833, 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: 557, Index root page: 558 
    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: 1504237, 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: 538, Index root page: 539 
    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: 508, Index root page: 509 
    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: 1552183, 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: 1510377, 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: 1510382, 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: 1510380, 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: 526, Index root page: 527 
    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: 1504329, 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: 1504330, 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: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 50.24, total records: 117334 
    Average version length: 69.16, total versions: 37032, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.51 
    Pointer pages: 3, data page slots: 4152 
    Data pages: 3128, average fill: 45% 
    Primary pages: 3128, secondary pages: 0, swept pages: 583 
    Empty pages: 485, full pages: 428 
    Fill distribution: 
     0 - 19% = 698 
    20 - 39% = 434 
    40 - 59% = 886 
    60 - 79% = 965 
    80 - 99% = 145 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554407, depth: 3, leaf buckets: 230, nodes: 117334 
    Average node length: 6.53, total dup: 102109, max dup: 14 
    Average key length: 3.98, compression ratio: 10.55 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 21835, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 109 
        40 - 59% = 104 
        60 - 79% = 14 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.70, total records: 6784863 
    Average version length: 68.79, total versions: 143809, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 64, data page slots: 103848 
    Data pages: 103848, average fill: 70% 
    Primary pages: 103847, secondary pages: 1, swept pages: 55591 
    Empty pages: 8, full pages: 48858 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 487 
    40 - 59% = 9136 
    60 - 79% = 93922 
    80 - 99% = 281 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10605, nodes: 6784863 
    Average node length: 6.51, total dup: 5867615, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1586420, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1920 
        40 - 59% = 6024 
        60 - 79% = 2270 
        80 - 99% = 384 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8430, nodes: 6784863 
    Average node length: 5.41, total dup: 6508639, max dup: 159 
    Average key length: 2.42, compression ratio: 7.04 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1408699, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 1426 
        40 - 59% = 4682 
        60 - 79% = 1393 
        80 - 99% = 916 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8480, nodes: 6784863 
    Average node length: 5.41, total dup: 6508639, max dup: 159 
    Average key length: 2.42, compression ratio: 7.04 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1410910, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1466 
        40 - 59% = 4697 
        60 - 79% = 1418 
        80 - 99% = 893 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.08, total records: 11745821 
    Average version length: 68.77, total versions: 171319, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 106, data page slots: 171824 
    Data pages: 171824, average fill: 73% 
    Primary pages: 171823, secondary pages: 1, swept pages: 90232 
    Empty pages: 7, full pages: 131100 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 389 
    40 - 59% = 5788 
    60 - 79% = 164671 
    80 - 99% = 950 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18304, nodes: 11744505 
    Average node length: 6.60, total dup: 10237722, max dup: 49 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2435086, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 2725 
        40 - 59% = 10749 
        60 - 79% = 4091 
        80 - 99% = 713 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 56.10, total records: 1365767 
    Average version length: 69.04, total versions: 162987, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.25 
    Pointer pages: 27, data page slots: 43128 
    Data pages: 29224, average fill: 49% 
    Primary pages: 29152, secondary pages: 72, swept pages: 14396 
    Empty pages: 4192, full pages: 13632 
    Fill distribution: 
     0 - 19% = 6757 
    20 - 39% = 4425 
    40 - 59% = 3592 
    60 - 79% = 12276 
    80 - 99% = 2174 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1909, nodes: 1232067 
    Average node length: 5.54, total dup: 1181692, max dup: 49 
    Average key length: 2.58, compression ratio: 16.30 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 89024, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 736 
        40 - 59% = 903 
        60 - 79% = 248 
        80 - 99% = 11 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 53.43, total records: 935055 
    Average version length: 69.03, total versions: 61399, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.36 
    Pointer pages: 20, data page slots: 31144 
    Data pages: 25496, average fill: 36% 
    Primary pages: 25496, secondary pages: 0, swept pages: 11423 
    Empty pages: 3755, full pages: 1352 
    Fill distribution: 
     0 - 19% = 6478 
    20 - 39% = 6128 
    40 - 59% = 9093 
    60 - 79% = 3786 
    80 - 99% = 11 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1192, nodes: 753604 
    Average node length: 5.91, total dup: 696316, max dup: 54 
    Average key length: 2.98, compression ratio: 14.11 
    Average prefix length: 41.10, average data length: 0.90 
    Clustering factor: 105924, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 410 
        40 - 59% = 581 
        60 - 79% = 195 
        80 - 99% = 6 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.54, total records: 9069031 
    Average version length: 68.97, total versions: 203969, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 90, data page slots: 146832 
    Data pages: 146816, average fill: 66% 
    Primary pages: 146795, secondary pages: 21, swept pages: 87966 
    Empty pages: 454, full pages: 53515 
    Fill distribution: 
     0 - 19% = 1450 
    20 - 39% = 5471 
    40 - 59% = 24433 
    60 - 79% = 114358 
    80 - 99% = 1104 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13504, nodes: 9066781 
    Average node length: 6.69, total dup: 7520348, max dup: 15 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2111701, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1439 
        40 - 59% = 7013 
        60 - 79% = 4437 
        80 - 99% = 614 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21192905 
    Average version length: 83.00, total versions: 5328, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 197, data page slots: 320616 
    Data pages: 320616, average fill: 81% 
    Primary pages: 320611, secondary pages: 5, swept pages: 14272 
    Empty pages: 54, full pages: 319409 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 43 
    40 - 59% = 154 
    60 - 79% = 50434 
    80 - 99% = 269903 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19337, nodes: 21192905 
    Average node length: 5.72, total dup: 20710831, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3289861, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 7988 
        60 - 79% = 534 
        80 - 99% = 10808 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17259, nodes: 21192905 
    Average node length: 6.31, total dup: 18624303, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919176, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 4 
        40 - 59% = 850 
        60 - 79% = 303 
        80 - 99% = 16097 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21130, nodes: 21192905 
    Average node length: 6.35, total dup: 18542991, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3584655, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8271 
        60 - 79% = 610 
        80 - 99% = 12245 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16226, nodes: 21192905 
    Average node length: 5.56, total dup: 21192805, max dup: 229501 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948134, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 3083 
        60 - 79% = 374 
        80 - 99% = 12759 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 77.96, total records: 9920739 
    Average version length: 82.58, total versions: 602839, 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: 107, data page slots: 173536 
    Data pages: 173528, average fill: 71% 
    Primary pages: 173498, secondary pages: 30, swept pages: 72308 
    Empty pages: 467, full pages: 107559 
    Fill distribution: 
     0 - 19% = 1374 
    20 - 39% = 5073 
    40 - 59% = 21022 
    60 - 79% = 118597 
    80 - 99% = 27462 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11394, nodes: 9920739 
    Average node length: 5.37, total dup: 9608551, max dup: 184 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2305072, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 45 
        40 - 59% = 7579 
        60 - 79% = 3598 
        80 - 99% = 171 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13766, nodes: 9920739 
    Average node length: 6.24, total dup: 8226513, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1645410, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 3877 
        40 - 59% = 4528 
        60 - 79% = 2727 
        80 - 99% = 2505 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12717, nodes: 9920739 
    Average node length: 5.99, total dup: 8615478, max dup: 44 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2494574, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 47 
        40 - 59% = 8549 
        60 - 79% = 3897 
        80 - 99% = 222 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10364, nodes: 9920739 
    Average node length: 5.15, total dup: 9920639, max dup: 149258 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1671811, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1215 
        40 - 59% = 5247 
        60 - 79% = 1736 
        80 - 99% = 2134 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 81.22, total records: 11363431 
    Average version length: 82.57, total versions: 169539, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 119, data page slots: 193808 
    Data pages: 192456, average fill: 72% 
    Primary pages: 192350, secondary pages: 106, swept pages: 72243 
    Empty pages: 2245, full pages: 146760 
    Fill distribution: 
     0 - 19% = 3923 
    20 - 39% = 6498 
    40 - 59% = 16542 
    60 - 79% = 104917 
    80 - 99% = 60576 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13161, nodes: 11363431 
    Average node length: 5.32, total dup: 11252859, max dup: 639 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2392853, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 165 
        40 - 59% = 8890 
        60 - 79% = 3849 
        80 - 99% = 256 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10613, nodes: 11363431 
    Average node length: 5.51, total dup: 10867314, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 747098, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 886 
        40 - 59% = 2657 
        60 - 79% = 1905 
        80 - 99% = 4992 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15048, nodes: 11363431 
    Average node length: 6.04, total dup: 9912730, max dup: 65 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2409209, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 203 
        40 - 59% = 10343 
        60 - 79% = 4207 
        80 - 99% = 293 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10991, nodes: 11363431 
    Average node length: 5.24, total dup: 11363331, max dup: 201211 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 734363, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 902 
        40 - 59% = 4954 
        60 - 79% = 1608 
        80 - 99% = 3432 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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: 1361775, 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: 1361777, 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: 1361776, 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: 1361774, 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: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 75.83, total records: 10408074 
    Average version length: 82.91, total versions: 975467, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.66 
    Pointer pages: 109, data page slots: 177288 
    Data pages: 177272, average fill: 74% 
    Primary pages: 177241, secondary pages: 31, swept pages: 35673 
    Empty pages: 502, full pages: 139121 
    Fill distribution: 
     0 - 19% = 1404 
    20 - 39% = 4768 
    40 - 59% = 16575 
    60 - 79% = 111858 
    80 - 99% = 42667 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12308, nodes: 10408074 
    Average node length: 5.19, total dup: 10378556, max dup: 2446 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2204510, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1286 
        40 - 59% = 8169 
        60 - 79% = 2097 
        80 - 99% = 729 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13927, nodes: 10408074 
    Average node length: 6.25, total dup: 8632531, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1674820, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 3449 
        40 - 59% = 4498 
        60 - 79% = 2761 
        80 - 99% = 3041 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12945, nodes: 10408074 
    Average node length: 5.44, total dup: 9951095, max dup: 109 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2343187, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1219 
        40 - 59% = 9128 
        60 - 79% = 1917 
        80 - 99% = 653 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10750, nodes: 10408074 
    Average node length: 5.16, total dup: 10407974, max dup: 159213 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1753915, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1021 
        40 - 59% = 5617 
        60 - 79% = 1795 
        80 - 99% = 2279 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.73, total records: 584031 
    Average version length: 68.77, total versions: 14236, 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: 8088 
    Data pages: 8088, average fill: 76% 
    Primary pages: 8088, secondary pages: 0, swept pages: 2359 
    Empty pages: 6, full pages: 7861 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 23 
    60 - 79% = 7832 
    80 - 99% = 227 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 48065, depth: 3, leaf buckets: 742, nodes: 584031 
    Average node length: 5.95, total dup: 497315, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102703, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 531 
        60 - 79% = 106 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36656, depth: 3, leaf buckets: 769, nodes: 584031 
    Average node length: 6.15, total dup: 479079, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102756, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 546 
        60 - 79% = 102 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 560, nodes: 584031 
    Average node length: 4.86, total dup: 583931, max dup: 9793 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 91297, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 314 
        60 - 79% = 69 
        80 - 99% = 148 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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: 563, Index root page: 564 
    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: 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 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    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: 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 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    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: 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 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    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: 1504235, 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: 1504236, 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: 571, Index root page: 572 
    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: 1504232, 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: 1504231, 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: 1504234, 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: 1504233, 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: 561, Index root page: 562 
    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: 559, Index root page: 560 
    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: 512, Index root page: 513 
    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: 1510372, 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 Sun Mar 17 13:10:41 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7750495 39862 1 0.0000 0.0000
DOC_LIST 2242984 20246 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1292 11 300.0000 0.0000
INVNT_TURNOVER_LOG 87835 56100 1 0.0000 0.0000
MONEY_SALDO 49 271 11 500.0000 0.0000
MONEY_TURNOVER_LOG 1571 960 1 0.0000 0.0000
PDISTR 791061 19071 2 0.0000 0.0000
PERF_SPLIT_0 183539 8559 1 0.0000 0.0000
PERF_SPLIT_1 165007 18507 1 0.0000 0.0000
PERF_SPLIT_2 211440 35552 1 0.0000 0.0000
PERF_SPLIT_3 203490 41710 1 0.0000 0.0000
PERF_SPLIT_4 173995 10476 1 0.0000 0.0000
PERF_SPLIT_5 183197 11102 1 0.0000 0.0000
PERF_SPLIT_6 174659 10886 1 0.0000 0.0000
PERF_SPLIT_7 188784 29847 1 0.0000 0.0000
PERF_SPLIT_8 179073 30063 1 0.0000 0.0000
PERF_SPLIT_9 147437 5636 1 0.0000 0.0000
PSTORNED 2094393 19721 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 117334 37032 1 0.0000 0.0000
XQD_1000_3300 6784863 143809 1 0.0000 0.0000
XQD_1200_2000 11745821 171319 1 0.0000 0.0000
XQD_2000_3300 1365767 162987 1 0.0000 0.0000
XQD_2100_3300 935055 61399 1 0.0000 0.0000
XQD_3300_3400 9069031 203969 1 0.0000 0.0000
XQS_1000_1200 21192905 5328 1 0.0000 0.0000
XQS_1000_3300 9920739 602839 1 0.0000 0.0000
XQS_1200_2000 11363431 169539 1 0.0000 0.0000
XQS_2100_3300 10408074 975467 1 0.0000 0.0000
XQS_3300_3400 584031 14236 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 ---
:36: 
:37: mscs-test-161.budzdorov.ru    Sun Mar 17 13:08:14 2024
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Sun Mar 17 13:08:15 2024
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:43: 
--- end of diff output ---

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

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