Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.02.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 15610196 kB
MemAvailable 30281860 kB
Buffers 0 kB
Cached 16144056 kB
SwapCached 2440 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-02-24 13:07:49
DTS_END                         2024-02-24 13:07:49.2440
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/34094
TRN_ID                          172736
ATT_ID                          522
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: 9456.52 21562 945652
customer order: creation 176.40 372 17640
customer order: refuse 14.39 397 1439
order to supplier: creation 48.01 1427 4801
order to supplier: removal 3.58 96136 358
invoice (draft): creation 46.24 3213 4624
invoice (draft): removal 50.36 670 5036
invoice accept: apply 42.81 21957 4281
invoice accept: cancel 46.26 775 4626
customer reserve: creation 4184.63 207 418463
customer reserve: removal 4547.47 61 454747
realization accept: apply 85.80 197 8580
realization accept: cancel 80.47 133 8047
payment from customer: creation 60.29 113 6029
payment from customer: removal 5.98 66 598
payment to supplier: creation 48.78 147 4878
payment to supplier: removal 3.30 83 330
service: total inventory turnovers 3.87 4358 387
service: total monetary turnovers 6.80 588 680
service: aggregate perf. data 1.04 14031 104
service: refresh index statistics 0.04 286302 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4833
TEST_TIME 2 2991
TEST_TIME 3 3540
TEST_TIME 4 3759
TEST_TIME 5 4008
TEST_TIME 6 4963
TEST_TIME 7 5113
TEST_TIME 8 5312
TEST_TIME 9 5435
TEST_TIME 10 5762
TEST_TIME 11 6076
TEST_TIME 12 6444
TEST_TIME 13 6758
TEST_TIME 14 6964
TEST_TIME 15 7091
TEST_TIME 16 7653
TEST_TIME 17 7749
TEST_TIME 18 7993
TEST_TIME 19 8132
TEST_TIME 20 8150
TEST_TIME 21 8751
TEST_TIME 22 8808
TEST_TIME 23 9125
TEST_TIME 24 9523
TEST_TIME 25 9756
TEST_TIME 26 10212
TEST_TIME 27 10101
TEST_TIME 28 10052
TEST_TIME 29 10097
TEST_TIME 30 10133
TEST_TIME 31 9927
TEST_TIME 32 9683
TEST_TIME 33 9693
TEST_TIME 34 9703
TEST_TIME 35 9586
TEST_TIME 36 9622
TEST_TIME 37 9533
TEST_TIME 38 9679
TEST_TIME 39 9612
TEST_TIME 40 9507
TEST_TIME 41 9347
TEST_TIME 42 9215
TEST_TIME 43 9291
TEST_TIME 44 9625
TEST_TIME 45 9833
TEST_TIME 46 9804
TEST_TIME 47 9844
TEST_TIME 48 9852
TEST_TIME 49 9883
TEST_TIME 50 9841
TEST_TIME 51 9922
TEST_TIME 52 9907
TEST_TIME 53 9998
TEST_TIME 54 10001
TEST_TIME 55 10041
TEST_TIME 56 10034
TEST_TIME 57 9889
TEST_TIME 58 9816
TEST_TIME 59 9794
TEST_TIME 60 9701
TEST_TIME 61 9654
TEST_TIME 62 9573
TEST_TIME 63 9626
TEST_TIME 64 9716
TEST_TIME 65 9605
TEST_TIME 66 9601
TEST_TIME 67 9612
TEST_TIME 68 9705
TEST_TIME 69 9693
TEST_TIME 70 9743
TEST_TIME 71 9749
TEST_TIME 72 9823
TEST_TIME 73 9783
TEST_TIME 74 9836
TEST_TIME 75 9835
TEST_TIME 76 9838
TEST_TIME 77 9889
TEST_TIME 78 9881
TEST_TIME 79 9773
TEST_TIME 80 9710
TEST_TIME 81 9662
TEST_TIME 82 9621
TEST_TIME 83 9540
TEST_TIME 84 9541
TEST_TIME 85 9487
TEST_TIME 86 9443
TEST_TIME 87 9432
TEST_TIME 88 9420
TEST_TIME 89 9423
TEST_TIME 90 9393
TEST_TIME 91 9387
TEST_TIME 92 9362
TEST_TIME 93 9389
TEST_TIME 94 9403
TEST_TIME 95 9450
TEST_TIME 96 9460
TEST_TIME 97 9495
TEST_TIME 98 9466
TEST_TIME 99 9525
TEST_TIME 100 9465
TEST_TIME 101 9371

Performance per minute, chart


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

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 1326515 1326515 0 0.00 0 18534 7 0 0
doc_list_biud 1326515 1326515 0 0.00 0 65046 26 0 0
sp_add_invoice_to_stock 4448 4281 167 3.75 35 189705 21957 0 167
sp_cancel_adding_invoice 4626 4626 0 0.00 5 43465 775 0 0
sp_cancel_client_order 1439 1439 0 0.00 3 15631 398 0 0
sp_cancel_customer_reserve 454747 454747 0 0.00 0 65048 61 0 0
sp_cancel_pay_from_customer 598 598 0 0.00 2 2832 67 0 0
sp_cancel_pay_to_supplier 330 330 0 0.00 2 3604 83 0 0
sp_cancel_supplier_invoice 5051 5036 15 0.29 1 11331 671 0 15
sp_cancel_supplier_order 358 358 0 0.00 11 1031876 96136 0 0
sp_cancel_write_off 8047 8047 0 0.00 1 13512 133 0 0
sp_client_order 17640 17640 0 0.00 3 30059 372 0 0
sp_customer_reserve 418463 418463 0 0.00 0 59777 208 0 0
sp_fill_shopping_cart 27065 27065 0 0.00 1 19042 38 0 0
sp_fill_shopping_cart_clo_res 418452 418452 0 0.00 0 15491 16 0 0
sp_get_clo_for_invoice 4270 4270 0 0.00 0 24900 304 0 0
sp_kill_cost_storno 13601 13601 0 0.00 0 6652 65 0 0
sp_kill_qstorno_ret_qs2qd 922935 922935 0 0.00 0 65040 32 0 0
sp_kill_qty_storno 487103 487103 0 0.00 0 65046 70 0 0
sp_lock_selected_doc 17672 17672 0 0.00 0 6746 5 0 0
sp_make_cost_storno 23757 23757 0 0.00 0 16282 64 0 0
sp_multiply_rows_for_pdistr 23757 23757 0 0.00 0 6603 31 0 0
sp_multiply_rows_for_qdistr 17640 17640 0 0.00 0 14427 173 0 0
sp_pay_from_customer 6029 6029 0 0.00 4 11818 114 0 0
sp_pay_to_supplier 4878 4878 0 0.00 4 13199 148 0 0
sp_payment_common 10907 10907 0 0.00 1 7936 19 0 0
sp_qd_handle_on_cancel_clo 1439 1439 0 0.00 0 15626 372 0 0
sp_qd_handle_on_invoice_upd_sts 8896 8896 0 0.00 0 17710 311 0 0
sp_qd_handle_on_reserve_upd_sts 8580 8580 0 0.00 0 13540 61 0 0
sp_reserve_write_off 8580 8580 0 0.00 6 16380 197 0 0
sp_supplier_invoice 4624 4624 0 0.00 6 105525 3213 0 0
sp_supplier_order 4801 4801 0 0.00 4 65737 1428 0 0
srv_aggregate_perf_data 104 104 0 0.00 1727 112212 14032 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 955 132644 43230 0 0
srv_find_qd_qs_mism 900897 900897 0 0.00 0 18531 7 0 0
srv_make_invnt_saldo 387 387 0 0.00 36 77380 4358 0 0
srv_make_money_saldo 680 680 0 0.00 1 14419 589 0 0
srv_recalc_idx_stat 4 4 0 0.00 121433 414369 286303 0 0
t$perf-abend:sp_add_invoice_to_stock 167 167 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4281 4281 0 0.00 1 5917 186 0 0
t$perf-norm:sp_cancel_adding_invoice 343 343 0 0.00 0 3644 78 0 0
t$perf-norm:sp_cancel_client_order 1439 1439 0 0.00 0 1425 12 0 0
t$perf-norm:sp_cancel_customer_reserve 565 565 0 0.00 0 1316 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 598 598 0 0.00 0 851 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 330 330 0 0.00 0 404 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 301 301 0 0.00 0 751 13 0 0
t$perf-norm:sp_cancel_supplier_order 358 358 0 0.00 0 41695 1629 0 0
t$perf-norm:sp_cancel_write_off 889 889 0 0.00 0 2273 8 0 0
t$perf-norm:sp_client_order 17640 17640 0 0.00 0 17946 17 0 0
t$perf-norm:sp_customer_reserve 820 820 0 0.00 0 3192 9 0 0
t$perf-norm:sp_pay_from_customer 6029 6029 0 0.00 0 6701 10 0 0
t$perf-norm:sp_pay_to_supplier 4878 4878 0 0.00 0 8795 13 0 0
t$perf-norm:sp_reserve_write_off 8580 8580 0 0.00 0 8034 14 0 0
t$perf-norm:sp_supplier_invoice 4624 4624 0 0.00 0 5218 16 0 0
t$perf-norm:sp_supplier_order 4801 4801 0 0.00 0 2699 14 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 356 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 52 2 0 0
t$perf-norm:srv_make_invnt_saldo 387 387 0 0.00 0 1027 14 0 0
t$perf-norm:srv_make_money_saldo 680 680 0 0.00 0 2169 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8874 8540 334 3.76 0 3603 18 0 334
v_all_customers 32006 32006 0 0.00 0 20 1 0 0
v_all_suppliers 26682 26682 0 0.00 0 35 1 0 0
v_all_wares 35280 35280 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 686 686 0 0.00 0 917 9 0 0
v_cancel_client_order 2878 2878 0 0.00 0 2100 5 0 0
v_cancel_customer_prepayment 1196 1196 0 0.00 0 2783 8 0 0
v_cancel_customer_reserve 1130 1130 0 0.00 0 1003 5 0 0
v_cancel_payment_to_supplier 660 660 0 0.00 0 3587 17 0 0
v_cancel_supplier_invoice 632 602 30 4.74 0 4086 31 0 30
v_cancel_supplier_order 716 716 0 0.00 0 662 5 0 0
v_cancel_write_off 1778 1778 0 0.00 0 698 12 0 0
v_max_id_clo_ord 4801 4801 0 0.00 0 562 2 0 0
v_max_id_clo_res 820 820 0 0.00 0 6715 16 0 0
v_max_id_ord_sup 4623 4623 0 0.00 0 3734 3 0 0
v_max_non_paid_invoice 961 961 0 0.00 0 150 2 0 0
v_max_non_paid_realizn 3090 3090 0 0.00 0 1809 5 0 0
v_min_id_clo_ord 4801 4801 0 0.00 0 2254 6 0 0
v_min_id_clo_res 820 820 0 0.00 0 1355 6 0 0
v_min_id_ord_sup 4623 4623 0 0.00 0 6533 7 0 0
v_min_non_paid_invoice 4878 4878 0 0.00 0 4501 14 0 0
v_min_non_paid_realizn 6029 6029 0 0.00 0 4426 11 0 0
v_our_firm 9152 9152 0 0.00 0 19 1 0 0
v_reserve_write_off 17158 17158 0 0.00 0 12992 8 0 0
x_lock_depdocs_on_canc_invoice 9361 9361 0 0.00 0 18761 119 0 0
x_lock_depdocs_on_canc_sup_ord 358 358 0 0.00 0 17421 447 0 0
x_make_qstorno_1000_1200 4801 4801 0 0.00 1 65714 1342 0 0
x_make_qstorno_1200_2000 4624 4624 0 0.00 2 105456 3075 0 0
x_make_qstorno_2100_3300 418463 418463 0 0.00 0 53151 189 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-02-2024 13:10:05 to 24-02-2024 13:10:09.

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:53 1266 8192000000 8956796672 9019297792 16213824 0.197 6 3 6 0 16637488 136800 286864
11:08:57 39596 8192000000 9737125408 10035761152 802142544 8.918 100 92 182 0 831613696 8016960 21454192
11:10:43 23814 8192000000 9777520528 10088493056 841010640 9.310 100 88 177 0 874011904 12637168 20364096
11:12:08 14787 8192000000 9802676784 10123739136 863591472 9.536 100 85 169 0 903292320 20724144 18976704
11:13:27 5809 8192000000 9850168368 10180087808 900372192 9.902 100 77 154 0 950211680 32930816 16908672
11:14:36 5908 8192000000 9914332224 10254340096 934348208 10.237 100 84 168 0 1014467648 62791696 17327744
11:15:45 4779 8192000000 9946498416 10298810368 968365824 10.571 100 75 151 0 1050267200 66645056 15256320
11:16:51 3278 8192000000 9983016160 10345144320 994690416 10.827 100 78 156 0 1096448656 86578336 15179904
11:17:57 1774 8192000000 10005192080 10372304896 1018325136 11.056 100 78 154 1 1109096176 75610880 15160160
11:19:01 1822 8192000000 10025274208 10395860992 1042084960 11.285 100 86 170 0 1127461936 68398240 16978736
11:20:05 3280 8192000000 10054995808 10432241664 1058213472 11.439 100 80 159 0 1156328592 81867120 16248000
11:21:09 4262 8192000000 9999525488 10391986176 1057861760 11.436 100 54 108 0 1114425280 45449296 11114224
11:22:15 3184 8192000000 10003109232 10398666752 1067495440 11.528 100 52 103 0 1109469824 31238832 10735552
11:23:20 7718 8192000000 9992249040 10385338368 1075948864 11.609 100 30 60 0 1092900672 10326400 6625408
11:24:29 39004 8192000000 10022843120 10423418880 1081386160 11.661 100 45 90 2 1105778512 14776256 9616096
11:26:10 2870 8192000000 10023544080 10432462848 1087945808 11.723 100 43 87 1 1128888432 31731520 9211104
11:27:14 8558 8192000000 10029635472 10439217152 1088858832 11.732 100 39 77 1 1116992944 19878208 8255904
11:28:27 107661 8192000000 10076579712 10484654080 1093603504 11.777 100 51 102 0 1166555216 62052064 10899648
11:31:37 39715 8192000000 10068056960 10476376064 1079745600 11.645 98 35 70 1 1145895040 59011248 7138192
11:33:21 8300 8192000000 10075138352 10477412352 1092000000 11.762 99 43 86 0 1165052000 63675856 9376144
11:34:37 9786 8192000000 10102828736 10500218880 1082332416 11.670 98 58 113 0 1178729280 84270624 12126240
11:35:50 9377 8192000000 10112386000 10510811136 1106119552 11.896 100 48 96 0 1208664400 92394768 10150080
11:37:03 5763 8192000000 10134198896 10522288128 1075515504 11.605 97 61 121 0 1213824928 125917072 12392352
11:38:13 14013 8192000000 10142176144 10531938304 1067948224 11.532 98 60 120 0 1219688720 138821824 12918672
11:39:31 3144 8192000000 10160295808 10549182464 1085018096 11.695 99 70 139 1 1257559072 157954080 14586896
11:40:36 20372 8192000000 10169069792 10566299648 1067545680 11.529 99 63 124 0 1259962464 178872352 13544432
11:42:13 9287 8192000000 10187970976 10582523904 1077831840 11.627 99 68 134 1 1278515040 186147840 14535360
11:43:28 952 8192000000 10233235808 10614788096 1092277920 11.764 99 89 176 0 1326848400 214905072 19665408
11:44:36 2579 8192000000 10226324176 10616762368 1108111952 11.915 100 87 175 1 1328302784 200783616 19407216
11:45:45 4527 8192000000 10249452752 10641559552 1098144112 11.820 98 70 140 0 1337521776 223408784 15968880
11:46:56 1761 8192000000 10305664672 10703261696 1132173616 12.142 100 80 158 0 1401637600 252375008 17088976
11:48:04 5057 8192000000 10300181552 10766336000 1127687648 12.100 99 60 120 0 1421193056 278987488 14517920
11:49:16 9125 8192000000 10319810064 10742476800 1146515840 12.277 100 62 122 0 1418680848 258201488 13963520
11:50:51 7616 8192000000 10238473520 10704969728 1136935088 12.187 100 31 60 0 1353575808 208996192 7644528
11:52:04 16758 8192000000 10197329248 10687762432 1129182720 12.114 100 19 38 0 1311179952 177646544 4350688
11:53:27 49727 8192000000 10105893856 10534010880 1108684160 11.920 98 16 32 0 1184264064 72573936 3005968
11:55:19 47200 8192000000 10103608256 10536820736 1127777488 12.100 100 27 54 1 1194247424 60687008 5782928
11:57:15 43483 8192000000 10099280368 10567458816 1137198528 12.189 100 29 58 0 1210965104 68183664 5582912
11:59:15 61664 8192000000 10095183296 10555916288 1143360416 12.247 100 37 74 0 1197318752 46215792 7742544
12:01:42 66618 8192000000 10105716400 10549571584 1140934544 12.224 99 18 36 0 1211203888 66352672 3916672
12:03:50 8861 8192000000 10111025632 10550861824 1155026944 12.357 100 43 80 0 1208451216 45168960 8255312
12:05:00 35541 8192000000 10131209824 10629857280 1158433360 12.389 100 24 46 2 1273667984 109537312 5697312
12:06:47 14946 8192000000 10120452096 10569904128 1167430896 12.473 100 24 48 0 1229245024 56574992 5239136
12:08:03 101245 8192000000 10272108672 10718457856 1164701632 12.447 98 27 55 0 1310233728 139449008 6083088
12:10:46 44980 8192000000 10233584784 10785722368 1170663120 12.503 100 17 34 0 1399926752 224826848 4436784
12:12:32 46697 8192000000 10083270080 10543296512 1108092864 11.914 95 28 52 0 1154826816 41316256 5417696
12:14:23 39169 8192000000 10109584944 10582769664 1149291408 12.303 99 18 36 0 1209312544 56528128 3493008
12:16:04 60520 8192000000 10089556688 10552860672 1127610048 12.099 97 12 21 0 1177994336 48428640 1955648
12:18:05 67616 8192000000 10084608816 10535895040 1103009936 11.866 96 19 38 0 1172331424 65234688 4086800
12:20:14 30749 8192000000 10119246048 10607185920 1126728528 12.091 99 17 33 0 1219021264 89152432 3140304
12:21:46 24564 8192000000 10084448720 10520260608 1108141104 11.915 98 30 60 0 1152285232 38606624 5537504
12:23:15 132644 8192000000 10020465424 10439462912 1034338832 11.210 92 32 64 0 1070324336 29037952 6947552
12:26:38 60719 8192000000 10101933696 10559303680 1125738064 12.081 100 20 39 0 1208835120 79098400 3998656
12:29:16 16882 8192000000 10170068416 10597101568 1140882960 12.224 100 41 82 0 1268942496 119109856 8949680
12:30:38 72495 8192000000 10125228544 10648178688 1115393824 11.983 99 21 42 0 1226297728 105846224 5057680
12:32:57 70193 8192000000 10091513632 10564452352 1092556080 11.767 98 11 22 0 1166843744 71681376 2606288
12:35:15 38641 8192000000 10048207360 10485157888 1084802416 11.693 97 20 40 1 1131362608 42571312 3988880
12:37:00 93995 8192000000 10069758320 10539565056 1122989408 12.055 100 22 44 1 1199921024 71641664 5289952
12:39:37 66657 8192000000 10068924624 10539216896 1100736736 11.845 98 15 30 0 1142699504 39125536 2837232
12:41:45 33138 8192000000 10075958672 10525831168 1123308864 12.058 100 27 54 0 1178402512 49946528 5147120
12:43:21 115623 8192000000 10082684912 10552492032 1135993536 12.178 99 6 12 0 1215755760 78686144 1076080
12:46:31 92235 8192000000 10066668736 10525483008 1144222800 12.255 100 21 42 1 1178488320 30054816 4210704
12:49:11 46700 8192000000 10077163456 10538639360 1143897088 12.252 99 7 14 0 1181748144 36169696 1681360
12:51:01 34832 8192000000 10077400928 10551955456 1158309456 12.387 100 8 16 0 1201981168 42140608 1531104
12:52:37 91110 8192000000 10121352656 10586796032 1158275888 12.387 100 28 57 0 1218640704 54665888 5698928
12:55:14 64073 8192000000 10083475920 10534084608 1120917840 12.036 97 8 16 0 1144079712 21660896 1500976
12:57:20 30995 8192000000 10090669872 10532417536 1155911488 12.365 100 31 61 0 1208249904 46426688 5911728
12:58:53 19638 8192000000 10103822128 10539507712 1161826336 12.420 100 39 76 0 1211054080 41589392 7638352
13:00:18 61663 8192000000 10125656320 10577408000 1120633968 12.033 96 27 54 2 1189903424 64062016 5207440
13:02:21 58662 8192000000 10111738880 10564919296 1121987312 12.046 97 18 36 0 1200037344 74048944 4001088
13:04:23 62193 8192000000 10108090400 10544631808 1118182464 12.010 97 18 34 0 1162212896 40843888 3186544
13:06:29 95115 8192000000 9934818656 10379673600 941274736 10.305 82 23 46 0 984618160 38969120 4374304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 167 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-02-2024 13:10:26 to 24-02-2024 13:10:28.

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          170709
MON$OLDEST_ACTIVE               172874
MON$OLDEST_SNAPSHOT             172874
MON$NEXT_TRANSACTION            172874
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                       1934944
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             691
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3061 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3061 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3061 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 Sat Feb 24 13:10:29 2024 
 
Database header page information: 
    Flags            0 
    Generation        90479 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    170709 
    Oldest active        172874 
    Oldest snapshot        172874 
    Next transaction    172875 
    Sequence number        0 
    Next attachment ID    691 
    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: 7679794 
    Average version length: 48.16, total versions: 39307, 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: 55, data page slots: 88728 
    Data pages: 88728, average fill: 69% 
    Primary pages: 88727, secondary pages: 1, swept pages: 49210 
    Empty pages: 6, full pages: 59977 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 167 
    40 - 59% = 2477 
    60 - 79% = 86045 
    80 - 99% = 15 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23279, nodes: 7679794 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1665933, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 296 
        20 - 39% = 2238 
        40 - 59% = 3900 
        60 - 79% = 2622 
        80 - 99% = 14223 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13513, nodes: 7679794 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1489877, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1815 
        40 - 59% = 1813 
        60 - 79% = 1247 
        80 - 99% = 8637 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8337, nodes: 7679794 
    Average node length: 6.60, total dup: 5760607, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1482993, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 111 
        20 - 39% = 1163 
        40 - 59% = 1247 
        60 - 79% = 1032 
        80 - 99% = 4784 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.98, total records: 2210205 
    Average version length: 58.88, total versions: 20327, 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: 28880 
    Data pages: 28880, average fill: 70% 
    Primary pages: 28878, secondary pages: 2, swept pages: 17509 
    Empty pages: 6, full pages: 13814 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 67 
    40 - 59% = 1731 
    60 - 79% = 27042 
    80 - 99% = 27 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4575, nodes: 2210205 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 663239, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1077 
        40 - 59% = 733 
        60 - 79% = 833 
        80 - 99% = 1932 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2438, nodes: 2210975 
    Average node length: 4.97, total dup: 2210076, max dup: 18560 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1261106, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 251 
        40 - 59% = 1441 
        60 - 79% = 527 
        80 - 99% = 219 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1787, nodes: 2210205 
    Average node length: 4.97, total dup: 2210155, max dup: 130352 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1061979, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 635 
        60 - 79% = 50 
        80 - 99% = 1097 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4373, nodes: 2210205 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 663239, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 89 
        20 - 39% = 701 
        40 - 59% = 607 
        60 - 79% = 911 
        80 - 99% = 2065 
 
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.30, total records: 400 
    Average version length: 25.61, total versions: 2892, max versions: 9 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 84% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 1, full pages: 21 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 20 
 
    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: 19.74, total records: 92450 
    Average version length: 68.28, total versions: 75715, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.46 
    Pointer pages: 8, data page slots: 2216 
    Data pages: 1816, average fill: 67% 
    Primary pages: 1815, secondary pages: 1, swept pages: 230 
    Empty pages: 265, full pages: 1142 
    Fill distribution: 
     0 - 19% = 337 
    20 - 39% = 66 
    40 - 59% = 116 
    60 - 79% = 327 
    80 - 99% = 970 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703658, depth: 3, leaf buckets: 308, nodes: 92450 
    Average node length: 13.33, total dup: 6298, max dup: 1 
    Average key length: 10.75, compression ratio: 2.51 
    Average prefix length: 19.18, average data length: 7.82 
    Clustering factor: 69450, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 104 
        40 - 59% = 122 
        60 - 79% = 65 
        80 - 99% = 16 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 235, 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: 12% 
    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% = 1 
    80 - 99% = 0 
 
    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: 20.76, total records: 1781 
    Average version length: 43.42, total versions: 1185, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 2.79 
    Pointer pages: 1, data page slots: 112 
    Data pages: 29, average fill: 60% 
    Primary pages: 28, secondary pages: 1, swept pages: 3 
    Empty pages: 4, full pages: 16 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94116, depth: 2, leaf buckets: 4, nodes: 1781 
    Average node length: 4.35, total dup: 1683, max dup: 189 
    Average key length: 2.60, compression ratio: 7.30 
    Average prefix length: 18.45, average data length: 0.55 
    Clustering factor: 928, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 1 
        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.65, 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.92, total records: 812410 
    Average version length: 37.93, total versions: 19814, 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: 8728 
    Data pages: 8728, average fill: 64% 
    Primary pages: 8727, secondary pages: 1, swept pages: 4142 
    Empty pages: 9, full pages: 4021 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 45 
    40 - 59% = 1155 
    60 - 79% = 7452 
    80 - 99% = 53 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 890, nodes: 805055 
    Average node length: 4.89, total dup: 805006, max dup: 159206 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89633, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 157 
        40 - 59% = 467 
        60 - 79% = 180 
        80 - 99% = 85 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 945, nodes: 805055 
    Average node length: 5.89, total dup: 716806, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159850, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 37 
        40 - 59% = 535 
        60 - 79% = 74 
        80 - 99% = 298 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 989, nodes: 805055 
    Average node length: 5.89, total dup: 716806, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161730, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 108 
        40 - 59% = 531 
        60 - 79% = 73 
        80 - 99% = 277 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1143, nodes: 805055 
    Average node length: 5.97, total dup: 716806, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154037, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 241 
        40 - 59% = 605 
        60 - 79% = 216 
        80 - 99% = 79 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 63.02, total records: 5565 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.33, total fragments: 21, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.01 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 77, secondary pages: 19, swept pages: 63 
    Empty pages: 13, full pages: 71 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5565 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.14 
    Average prefix length: 34.71, average data length: 1.54 
    Clustering factor: 5280, 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: 5565 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 160, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        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: 78644 
    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: 824 
    Data pages: 824, average fill: 65% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 816 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 816 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36516, depth: 2, leaf buckets: 100, nodes: 78644 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3147, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 98 
 
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: 110.54, 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.30 
    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: 149.90, total records: 189680 
    Average version length: 150.70, total versions: 1772, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 8, data page slots: 5256 
    Data pages: 4696, average fill: 83% 
    Primary pages: 4694, secondary pages: 2, swept pages: 3 
    Empty pages: 29, full pages: 4656 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4655 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 151.04, total records: 155831 
    Average version length: 137.55, total versions: 227, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 7, data page slots: 4168 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3870, secondary pages: 2, swept pages: 4 
    Empty pages: 36, full pages: 3824 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3823 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 146.09, total records: 154693 
    Average version length: 153.27, total versions: 5147, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 7, data page slots: 4912 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3870, secondary pages: 2, swept pages: 1 
    Empty pages: 68, full pages: 3786 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 10 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3786 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 136.33, total records: 163963 
    Average version length: 154.84, total versions: 17138, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.44 
    Pointer pages: 8, data page slots: 6424 
    Data pages: 4152, average fill: 83% 
    Primary pages: 4150, secondary pages: 2, swept pages: 3 
    Empty pages: 101, full pages: 4021 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 10 
    80 - 99% = 4022 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 142.89, total records: 151226 
    Average version length: 154.13, total versions: 8734, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.87 
    Pointer pages: 7, data page slots: 4976 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3766, secondary pages: 2, swept pages: 2 
    Empty pages: 44, full pages: 3710 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3711 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 149.17, total records: 139416 
    Average version length: 152.47, total versions: 1504, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 8, data page slots: 4912 
    Data pages: 3472, average fill: 83% 
    Primary pages: 3470, secondary pages: 2, swept pages: 2 
    Empty pages: 47, full pages: 3409 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3410 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 149.60, total records: 157282 
    Average version length: 150.76, total versions: 1664, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 8, data page slots: 4800 
    Data pages: 3928, average fill: 83% 
    Primary pages: 3927, secondary pages: 1, swept pages: 6 
    Empty pages: 54, full pages: 3852 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 3851 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 145.20, total records: 164401 
    Average version length: 153.60, total versions: 7098, 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: 7, data page slots: 5840 
    Data pages: 4152, average fill: 82% 
    Primary pages: 4150, secondary pages: 2, swept pages: 5 
    Empty pages: 89, full pages: 4030 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 11 
    40 - 59% = 8 
    60 - 79% = 11 
    80 - 99% = 4029 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 127.30, total records: 184238 
    Average version length: 154.61, total versions: 30654, 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: 5736 
    Data pages: 4584, average fill: 85% 
    Primary pages: 4582, secondary pages: 2, swept pages: 3 
    Empty pages: 48, full pages: 4525 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4526 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 145.54, total records: 165966 
    Average version length: 152.95, total versions: 6829, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 9, data page slots: 5064 
    Data pages: 4144, average fill: 83% 
    Primary pages: 4142, secondary pages: 2, swept pages: 1 
    Empty pages: 51, full pages: 4077 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 4077 
 
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.35, total records: 2056507 
    Average version length: 52.79, total versions: 18270, 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: 25904 
    Data pages: 25888, average fill: 68% 
    Primary pages: 25873, secondary pages: 15, swept pages: 13100 
    Empty pages: 300, full pages: 20804 
    Fill distribution: 
     0 - 19% = 611 
    20 - 39% = 497 
    40 - 59% = 1343 
    60 - 79% = 23257 
    80 - 99% = 180 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2570, nodes: 2056507 
    Average node length: 5.45, total dup: 1917090, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 179910, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 322 
        40 - 59% = 1688 
        60 - 79% = 278 
        80 - 99% = 276 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2056507 
    Average node length: 5.70, total dup: 1845107, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 369009, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 4 
        40 - 59% = 2518 
        60 - 79% = 216 
        80 - 99% = 19 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2114, nodes: 2056507 
    Average node length: 4.96, total dup: 2056407, max dup: 27408 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 178026, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 232 
        40 - 59% = 1110 
        60 - 79% = 354 
        80 - 99% = 415 
 
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: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 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: 49.46, total records: 109784 
    Average version length: 69.16, total versions: 36039, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.55 
    Pointer pages: 3, data page slots: 4496 
    Data pages: 3048, average fill: 43% 
    Primary pages: 3048, secondary pages: 0, swept pages: 679 
    Empty pages: 590, full pages: 369 
    Fill distribution: 
     0 - 19% = 825 
    20 - 39% = 315 
    40 - 59% = 829 
    60 - 79% = 932 
    80 - 99% = 147 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1553830, depth: 3, leaf buckets: 216, nodes: 109784 
    Average node length: 6.54, total dup: 95542, max dup: 14 
    Average key length: 4.01, compression ratio: 10.48 
    Average prefix length: 40.12, average data length: 1.88 
    Clustering factor: 19648, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 116 
        40 - 59% = 81 
        60 - 79% = 18 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.52, total records: 6977603 
    Average version length: 68.80, total versions: 168592, 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: 67, data page slots: 109056 
    Data pages: 109056, average fill: 68% 
    Primary pages: 109054, secondary pages: 2, swept pages: 60687 
    Empty pages: 85, full pages: 42869 
    Fill distribution: 
     0 - 19% = 607 
    20 - 39% = 1590 
    40 - 59% = 11022 
    60 - 79% = 95462 
    80 - 99% = 375 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10786, nodes: 6977603 
    Average node length: 6.51, total dup: 6035861, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1641145, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 2012 
        40 - 59% = 5754 
        60 - 79% = 2611 
        80 - 99% = 399 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8597, nodes: 6977603 
    Average node length: 5.40, total dup: 6698588, max dup: 152 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1443813, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1435 
        40 - 59% = 4653 
        60 - 79% = 1595 
        80 - 99% = 908 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8675, nodes: 6977603 
    Average node length: 5.40, total dup: 6698588, max dup: 152 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1446138, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1542 
        40 - 59% = 4606 
        60 - 79% = 1608 
        80 - 99% = 910 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.17, total records: 12025427 
    Average version length: 68.74, total versions: 156858, 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: 109, data page slots: 176496 
    Data pages: 176496, average fill: 72% 
    Primary pages: 176495, secondary pages: 1, swept pages: 105503 
    Empty pages: 2, full pages: 125915 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 481 
    40 - 59% = 6524 
    60 - 79% = 168574 
    80 - 99% = 893 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18407, nodes: 12024291 
    Average node length: 6.62, total dup: 10481436, max dup: 56 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2459239, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 2604 
        40 - 59% = 10367 
        60 - 79% = 4423 
        80 - 99% = 982 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 54.57, total records: 1296620 
    Average version length: 69.04, total versions: 189841, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.31 
    Pointer pages: 28, data page slots: 44448 
    Data pages: 27894, average fill: 49% 
    Primary pages: 27825, secondary pages: 69, swept pages: 12777 
    Empty pages: 4474, full pages: 12877 
    Fill distribution: 
     0 - 19% = 6799 
    20 - 39% = 3761 
    40 - 59% = 3360 
    60 - 79% = 11586 
    80 - 99% = 2388 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1864, nodes: 1172081 
    Average node length: 5.55, total dup: 1124661, max dup: 49 
    Average key length: 2.58, compression ratio: 16.26 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 83311, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 819 
        40 - 59% = 796 
        60 - 79% = 227 
        80 - 99% = 13 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 53.28, total records: 875383 
    Average version length: 69.03, total versions: 69412, 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: 22, data page slots: 35008 
    Data pages: 30320, average fill: 29% 
    Primary pages: 30319, secondary pages: 1, swept pages: 15421 
    Empty pages: 6373, full pages: 793 
    Fill distribution: 
     0 - 19% = 12069 
    20 - 39% = 7007 
    40 - 59% = 8051 
    60 - 79% = 3178 
    80 - 99% = 15 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1236, nodes: 715082 
    Average node length: 5.92, total dup: 661154, max dup: 56 
    Average key length: 2.98, compression ratio: 14.09 
    Average prefix length: 41.09, average data length: 0.91 
    Clustering factor: 102050, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 572 
        40 - 59% = 546 
        60 - 79% = 111 
        80 - 99% = 7 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.98, total records: 8918294 
    Average version length: 68.96, total versions: 281435, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 90, data page slots: 145384 
    Data pages: 145368, average fill: 66% 
    Primary pages: 145346, secondary pages: 22, swept pages: 76720 
    Empty pages: 351, full pages: 57553 
    Fill distribution: 
     0 - 19% = 1042 
    20 - 39% = 5535 
    40 - 59% = 29421 
    60 - 79% = 108144 
    80 - 99% = 1226 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13451, nodes: 8915288 
    Average node length: 6.69, total dup: 7392685, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2041319, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1696 
        40 - 59% = 6999 
        60 - 79% = 4171 
        80 - 99% = 581 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.45, total records: 21149137 
    Average version length: 82.86, total versions: 26817, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319536 
    Data pages: 319536, average fill: 81% 
    Primary pages: 319531, secondary pages: 5, swept pages: 9982 
    Empty pages: 3, full pages: 319528 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 46931 
    80 - 99% = 272599 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19573, nodes: 21149137 
    Average node length: 5.72, total dup: 20668182, max dup: 191 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3283795, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 8549 
        60 - 79% = 536 
        80 - 99% = 10479 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17174, nodes: 21149137 
    Average node length: 6.31, total dup: 18584643, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918068, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 3 
        40 - 59% = 804 
        60 - 79% = 259 
        80 - 99% = 16104 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21405, nodes: 21149137 
    Average node length: 6.35, total dup: 18505283, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578594, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8906 
        60 - 79% = 621 
        80 - 99% = 11873 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16035, nodes: 21149137 
    Average node length: 5.56, total dup: 21149037, max dup: 228745 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946778, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2797 
        60 - 79% = 361 
        80 - 99% = 12869 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.18, total records: 9931837 
    Average version length: 82.60, total versions: 842660, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 106, data page slots: 172696 
    Data pages: 172688, average fill: 72% 
    Primary pages: 172648, secondary pages: 40, swept pages: 38834 
    Empty pages: 462, full pages: 124455 
    Fill distribution: 
     0 - 19% = 1476 
    20 - 39% = 6178 
    40 - 59% = 21326 
    60 - 79% = 108871 
    80 - 99% = 34837 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11361, nodes: 9931837 
    Average node length: 5.36, total dup: 9621458, max dup: 216 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2273126, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 77 
        40 - 59% = 7345 
        60 - 79% = 3812 
        80 - 99% = 126 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13845, nodes: 9931837 
    Average node length: 6.23, total dup: 8232378, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1619853, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 136 
        20 - 39% = 4047 
        40 - 59% = 4478 
        60 - 79% = 2755 
        80 - 99% = 2429 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12686, nodes: 9931837 
    Average node length: 5.97, total dup: 8634103, max dup: 50 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2468980, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 89 
        40 - 59% = 8313 
        60 - 79% = 4132 
        80 - 99% = 149 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10318, nodes: 9931837 
    Average node length: 5.14, total dup: 9931737, max dup: 143003 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1648636, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1177 
        40 - 59% = 5165 
        60 - 79% = 1780 
        80 - 99% = 2159 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.23, total records: 11466821 
    Average version length: 82.54, total versions: 636871, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 120, data page slots: 195112 
    Data pages: 193688, average fill: 73% 
    Primary pages: 193560, secondary pages: 128, swept pages: 52180 
    Empty pages: 2901, full pages: 155844 
    Fill distribution: 
     0 - 19% = 4918 
    20 - 39% = 6667 
    40 - 59% = 14476 
    60 - 79% = 94399 
    80 - 99% = 73228 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13124, nodes: 11466821 
    Average node length: 5.30, total dup: 11356472, max dup: 682 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2397637, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 134 
        40 - 59% = 8599 
        60 - 79% = 4201 
        80 - 99% = 189 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10508, nodes: 11466821 
    Average node length: 5.50, total dup: 10967483, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 730060, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 801 
        40 - 59% = 2568 
        60 - 79% = 1795 
        80 - 99% = 5195 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15010, nodes: 11466821 
    Average node length: 6.03, total dup: 10011787, max dup: 76 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2414076, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 169 
        40 - 59% = 10093 
        60 - 79% = 4528 
        80 - 99% = 216 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10762, nodes: 11466821 
    Average node length: 5.23, total dup: 11466721, max dup: 169477 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 718562, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 78 
        20 - 39% = 772 
        40 - 59% = 4758 
        60 - 79% = 1430 
        80 - 99% = 3724 
 
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: 76.84, total records: 10001438 
    Average version length: 82.92, total versions: 799398, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 109, data page slots: 176992 
    Data pages: 176936, average fill: 71% 
    Primary pages: 176905, secondary pages: 31, swept pages: 42372 
    Empty pages: 532, full pages: 124456 
    Fill distribution: 
     0 - 19% = 1675 
    20 - 39% = 8249 
    40 - 59% = 25507 
    60 - 79% = 107083 
    80 - 99% = 34422 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11999, nodes: 10001438 
    Average node length: 5.18, total dup: 9972362, max dup: 1792 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2082325, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1452 
        40 - 59% = 7935 
        60 - 79% = 1938 
        80 - 99% = 645 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13949, nodes: 10001438 
    Average node length: 6.25, total dup: 8289901, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1581807, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 171 
        20 - 39% = 4075 
        40 - 59% = 4439 
        60 - 79% = 2698 
        80 - 99% = 2566 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12619, nodes: 10001438 
    Average node length: 5.44, total dup: 9557660, max dup: 104 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2216374, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1430 
        40 - 59% = 8792 
        60 - 79% = 1747 
        80 - 99% = 621 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10396, nodes: 10001438 
    Average node length: 5.15, total dup: 10001338, max dup: 144306 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1656828, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1202 
        40 - 59% = 5170 
        60 - 79% = 1762 
        80 - 99% = 2216 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.06, total records: 579024 
    Average version length: 68.78, total versions: 10837, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 75% 
    Primary pages: 8063, secondary pages: 1, swept pages: 2526 
    Empty pages: 6, full pages: 7723 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 26 
    40 - 59% = 79 
    60 - 79% = 7769 
    80 - 99% = 182 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46141, depth: 3, leaf buckets: 741, nodes: 579024 
    Average node length: 5.95, total dup: 492841, max dup: 85 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 101998, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 526 
        60 - 79% = 103 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34956, depth: 3, leaf buckets: 767, nodes: 579024 
    Average node length: 6.15, total dup: 474810, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102042, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 559 
        60 - 79% = 97 
        80 - 99% = 87 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 553, nodes: 579024 
    Average node length: 4.86, total dup: 578924, max dup: 9738 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90620, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 25 
        40 - 59% = 302 
        60 - 79% = 86 
        80 - 99% = 139 
 
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 Sat Feb 24 13:10:52 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7679794 39307 1 0.0000 0.0000
DOC_LIST 2210205 20327 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2892 9 700.0000 0.0000
INVNT_TURNOVER_LOG 92450 75715 1 0.0000 0.0000
MONEY_SALDO 49 235 11 400.0000 0.0000
MONEY_TURNOVER_LOG 1781 1185 1 0.0000 0.0000
PDISTR 812410 19814 2 0.0000 0.0000
PERF_SPLIT_0 189680 1772 1 0.0000 0.0000
PERF_SPLIT_1 155831 227 1 0.0000 0.0000
PERF_SPLIT_2 154693 5147 1 0.0000 0.0000
PERF_SPLIT_3 163963 17138 1 0.0000 0.0000
PERF_SPLIT_4 151226 8734 1 0.0000 0.0000
PERF_SPLIT_5 139416 1504 1 0.0000 0.0000
PERF_SPLIT_6 157282 1664 1 0.0000 0.0000
PERF_SPLIT_7 164401 7098 1 0.0000 0.0000
PERF_SPLIT_8 184238 30654 1 0.0000 0.0000
PERF_SPLIT_9 165966 6829 1 0.0000 0.0000
PSTORNED 2056507 18270 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 109784 36039 1 0.0000 0.0000
XQD_1000_3300 6977603 168592 1 0.0000 0.0000
XQD_1200_2000 12025427 156858 1 0.0000 0.0000
XQD_2000_3300 1296620 189841 1 0.0000 0.0000
XQD_2100_3300 875383 69412 1 0.0000 0.0000
XQD_3300_3400 8918294 281435 1 0.0000 0.0000
XQS_1000_1200 21149137 26817 1 0.0000 0.0000
XQS_1000_3300 9931837 842660 1 0.0000 0.0000
XQS_1200_2000 11466821 636871 1 0.0000 0.0000
XQS_2100_3300 10001438 799398 1 0.0000 0.0000
XQS_3300_3400 579024 10837 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 ---
:280: 
:281: mscs-test-161.budzdorov.ru    Sat Feb 24 13:08:16 2024
:282:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:283: 
--- end of diff output ---

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

24.02.24 13:11:04. 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-02-24 13:11:07 No severe PSQL-related problems occured
24.02.24 13:11:08. End of report.