Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.03.2024 10:08
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 15876052 kB
MemAvailable 30250132 kB
Buffers 0 kB
Cached 15816216 kB
SwapCached 2712 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-17 10:07:52
DTS_END                         2024-03-17 10:07:52.9220
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/54220
TRN_ID                          164267
ATT_ID                          563
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: 9027.26 21405 902726
customer order: creation 175.67 470 17567
customer order: refuse 14.21 440 1421
order to supplier: creation 45.05 1392 4505
order to supplier: removal 3.58 105842 358
invoice (draft): creation 46.46 3315 4646
invoice (draft): removal 50.30 823 5030
invoice accept: apply 41.50 21595 4150
invoice accept: cancel 44.73 952 4473
customer reserve: creation 4018.71 204 401871
customer reserve: removal 4304.70 70 430470
realization accept: apply 83.06 218 8306
realization accept: cancel 73.99 148 7399
payment from customer: creation 57.49 109 5749
payment from customer: removal 5.61 98 561
payment to supplier: creation 48.39 131 4839
payment to supplier: removal 3.28 92 328
service: total inventory turnovers 3.60 4581 360
service: total monetary turnovers 5.99 812 599
service: aggregate perf. data 0.91 14379 91
service: refresh index statistics 0.03 272438 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 17-03-2024 10:08:29 to 17-03-2024 10:08:32.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3482
TEST_TIME 2 3916
TEST_TIME 3 3812
TEST_TIME 4 4558
TEST_TIME 5 4595
TEST_TIME 6 4416
TEST_TIME 7 4307
TEST_TIME 8 4266
TEST_TIME 9 4333
TEST_TIME 10 4688
TEST_TIME 11 4863
TEST_TIME 12 5264
TEST_TIME 13 5250
TEST_TIME 14 5374
TEST_TIME 15 5759
TEST_TIME 16 5864
TEST_TIME 17 6017
TEST_TIME 18 6105
TEST_TIME 19 6268
TEST_TIME 20 6356
TEST_TIME 21 6580
TEST_TIME 22 7153
TEST_TIME 23 7719
TEST_TIME 24 7757
TEST_TIME 25 8315
TEST_TIME 26 8760
TEST_TIME 27 8738
TEST_TIME 28 9054
TEST_TIME 29 9294
TEST_TIME 30 9124
TEST_TIME 31 9104
TEST_TIME 32 9111
TEST_TIME 33 8905
TEST_TIME 34 8806
TEST_TIME 35 8787
TEST_TIME 36 8830
TEST_TIME 37 8920
TEST_TIME 38 8908
TEST_TIME 39 8774
TEST_TIME 40 8743
TEST_TIME 41 8828
TEST_TIME 42 8855
TEST_TIME 43 8733
TEST_TIME 44 8743
TEST_TIME 45 8746
TEST_TIME 46 8703
TEST_TIME 47 8758
TEST_TIME 48 8764
TEST_TIME 49 8812
TEST_TIME 50 8947
TEST_TIME 51 8960
TEST_TIME 52 8989
TEST_TIME 53 8944
TEST_TIME 54 9046
TEST_TIME 55 9054
TEST_TIME 56 9071
TEST_TIME 57 9019
TEST_TIME 58 9100
TEST_TIME 59 9024
TEST_TIME 60 8913
TEST_TIME 61 8955
TEST_TIME 62 8886
TEST_TIME 63 8860
TEST_TIME 64 8836
TEST_TIME 65 8948
TEST_TIME 66 8899
TEST_TIME 67 8861
TEST_TIME 68 8845
TEST_TIME 69 8725
TEST_TIME 70 8684
TEST_TIME 71 8738
TEST_TIME 72 8718
TEST_TIME 73 8761
TEST_TIME 74 8821
TEST_TIME 75 8899
TEST_TIME 76 8907
TEST_TIME 77 8886
TEST_TIME 78 8946
TEST_TIME 79 8937
TEST_TIME 80 8978
TEST_TIME 81 9058
TEST_TIME 82 9041
TEST_TIME 83 8961
TEST_TIME 84 8924
TEST_TIME 85 8935
TEST_TIME 86 8887
TEST_TIME 87 8819
TEST_TIME 88 8804
TEST_TIME 89 8809
TEST_TIME 90 8843
TEST_TIME 91 8877
TEST_TIME 92 8865
TEST_TIME 93 8865
TEST_TIME 94 8886
TEST_TIME 95 8916
TEST_TIME 96 8990
TEST_TIME 97 8969
TEST_TIME 98 8976
TEST_TIME 99 8997
TEST_TIME 100 9039

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-03-2024 10:08:33 to 17-03-2024 10:08:36.

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 1269777 1269777 0 0.00 0 24635 7 0 0
doc_list_biud 1269773 1269773 0 0.00 0 27615 30 0 0
sp_add_invoice_to_stock 4284 4150 134 3.12 29 229226 21596 0 134
sp_cancel_adding_invoice 4473 4473 0 0.00 4 77513 953 0 0
sp_cancel_client_order 1421 1421 0 0.00 4 10010 440 0 0
sp_cancel_customer_reserve 430470 430470 0 0.00 0 27617 71 0 0
sp_cancel_pay_from_customer 561 561 0 0.00 2 3830 99 0 0
sp_cancel_pay_to_supplier 328 328 0 0.00 2 2961 92 0 0
sp_cancel_supplier_invoice 5037 5030 7 0.13 1 15487 824 0 7
sp_cancel_supplier_order 358 358 0 0.00 8 1264829 105843 0 0
sp_cancel_write_off 7399 7399 0 0.00 1 8655 149 0 0
sp_client_order 17567 17567 0 0.00 3 31697 470 0 0
sp_customer_reserve 401871 401871 0 0.00 0 44138 205 0 0
sp_fill_shopping_cart 26716 26716 0 0.00 1 14137 38 0 0
sp_fill_shopping_cart_clo_res 401854 401854 0 0.00 0 21047 19 0 0
sp_get_clo_for_invoice 4132 4132 0 0.00 0 21399 365 0 0
sp_kill_cost_storno 12761 12761 0 0.00 0 8102 89 0 0
sp_kill_qstorno_ret_qs2qd 873727 873727 0 0.00 0 27612 38 0 0
sp_kill_qty_storno 461589 461589 0 0.00 0 27615 81 0 0
sp_lock_selected_doc 17115 17115 0 0.00 0 8192 5 0 0
sp_make_cost_storno 23026 23026 0 0.00 0 21707 65 0 0
sp_multiply_rows_for_pdistr 23026 23026 0 0.00 0 9923 37 0 0
sp_multiply_rows_for_qdistr 17567 17567 0 0.00 0 21821 254 0 0
sp_pay_from_customer 5749 5749 0 0.00 4 15979 109 0 0
sp_pay_to_supplier 4839 4839 0 0.00 4 10204 131 0 0
sp_payment_common 10588 10588 0 0.00 1 15973 19 0 0
sp_qd_handle_on_cancel_clo 1421 1421 0 0.00 0 10002 405 0 0
sp_qd_handle_on_invoice_upd_sts 8605 8605 0 0.00 0 24581 331 0 0
sp_qd_handle_on_reserve_upd_sts 8306 8306 0 0.00 0 22926 72 0 0
sp_reserve_write_off 8306 8306 0 0.00 6 27212 218 0 0
sp_supplier_invoice 4646 4646 0 0.00 7 76519 3316 0 0
sp_supplier_order 4505 4505 0 0.00 4 37738 1393 0 0
srv_aggregate_perf_data 91 91 0 0.00 1420 173245 14379 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1910 100206 37386 0 0
srv_find_qd_qs_mism 859949 859949 0 0.00 0 24631 6 0 0
srv_make_invnt_saldo 360 360 0 0.00 42 119110 4582 0 0
srv_make_money_saldo 599 599 0 0.00 1 37916 813 0 0
srv_recalc_idx_stat 3 3 0 0.00 82319 490141 272438 0 0
t$perf-abend:sp_add_invoice_to_stock 134 134 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4150 4150 0 0.00 0 9953 187 0 0
t$perf-norm:sp_cancel_adding_invoice 333 333 0 0.00 0 2399 94 0 0
t$perf-norm:sp_cancel_client_order 1421 1421 0 0.00 0 6100 19 0 0
t$perf-norm:sp_cancel_customer_reserve 528 528 0 0.00 0 2533 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 561 561 0 0.00 0 25395 48 0 0
t$perf-norm:sp_cancel_pay_to_supplier 328 328 0 0.00 0 451 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 349 349 0 0.00 0 432 15 0 0
t$perf-norm:sp_cancel_supplier_order 358 358 0 0.00 0 29653 1873 0 0
t$perf-norm:sp_cancel_write_off 799 799 0 0.00 0 2127 11 0 0
t$perf-norm:sp_client_order 17567 17567 0 0.00 0 7958 19 0 0
t$perf-norm:sp_customer_reserve 859 859 0 0.00 0 1798 9 0 0
t$perf-norm:sp_pay_from_customer 5749 5749 0 0.00 0 5339 8 0 0
t$perf-norm:sp_pay_to_supplier 4839 4839 0 0.00 0 5994 10 0 0
t$perf-norm:sp_reserve_write_off 8306 8306 0 0.00 0 9826 15 0 0
t$perf-norm:sp_supplier_invoice 4646 4646 0 0.00 0 1326 13 0 0
t$perf-norm:sp_supplier_order 4505 4505 0 0.00 0 5590 17 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 249 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 3 0 0 0
t$perf-norm:srv_make_invnt_saldo 360 360 0 0.00 0 559 7 0 0
t$perf-norm:srv_make_money_saldo 599 599 0 0.00 0 770 5 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8532 8264 268 3.14 0 8163 19 0 268
v_all_customers 32360 32360 0 0.00 0 25 1 0 0
v_all_suppliers 25894 25894 0 0.00 0 62 1 0 0
v_all_wares 35132 35132 0 0.00 0 52 1 0 0
v_cancel_adding_invoice 666 666 0 0.00 0 1124 9 0 0
v_cancel_client_order 2842 2842 0 0.00 0 4277 6 0 0
v_cancel_customer_prepayment 1122 1122 0 0.00 0 2566 7 0 0
v_cancel_customer_reserve 1056 1056 0 0.00 0 4137 12 0 0
v_cancel_payment_to_supplier 656 656 0 0.00 0 2540 13 0 0
v_cancel_supplier_invoice 712 698 14 1.96 0 2239 18 0 14
v_cancel_supplier_order 716 716 0 0.00 0 2538 9 0 0
v_cancel_write_off 1598 1598 0 0.00 0 4146 21 0 0
v_max_id_clo_ord 4504 4504 0 0.00 0 3015 2 0 0
v_max_id_clo_res 859 859 0 0.00 0 2430 9 0 0
v_max_id_ord_sup 4645 4645 0 0.00 0 4965 7 0 0
v_max_non_paid_invoice 1041 1041 0 0.00 0 193 2 0 0
v_max_non_paid_realizn 2750 2750 0 0.00 0 3055 4 0 0
v_min_id_clo_ord 4504 4504 0 0.00 0 5231 9 0 0
v_min_id_clo_res 859 859 0 0.00 0 5008 17 0 0
v_min_id_ord_sup 4645 4645 0 0.00 0 5112 8 0 0
v_min_non_paid_invoice 4839 4839 0 0.00 0 9016 11 0 0
v_min_non_paid_realizn 5749 5749 0 0.00 0 15967 16 0 0
v_our_firm 8770 8770 0 0.00 0 22 1 0 0
v_reserve_write_off 16612 16612 0 0.00 0 5388 7 0 0
x_lock_depdocs_on_canc_invoice 9154 9154 0 0.00 0 26686 122 0 0
x_lock_depdocs_on_canc_sup_ord 358 358 0 0.00 0 13280 431 0 0
x_make_qstorno_1000_1200 4505 4505 0 0.00 1 37732 1311 0 0
x_make_qstorno_1200_2000 4646 4646 0 0.00 3 72847 3173 0 0
x_make_qstorno_2100_3300 401870 401870 0 0.00 0 44133 184 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 17-03-2024 10:08:37 to 17-03-2024 10:08:42.

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
08:07:56 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
08:08:57 21722 8192000000 9714723936 10012557312 799492768 8.891 100 93 187 0 828568912 7313344 21762800
08:10:24 29566 8192000000 9754819696 10062929920 830948912 9.209 100 87 174 0 861900208 11271280 19680016
08:12:08 18871 8192000000 9790664272 10107285504 860364064 9.504 100 89 178 0 902026928 21586976 20075888
08:13:38 9953 8192000000 9843758736 10173263872 893789376 9.837 100 80 160 0 953245024 42409168 17046480
08:14:52 7579 8192000000 9881241296 10223120384 930222176 10.197 100 79 158 0 995038688 47580032 17236480
08:16:07 9620 8192000000 9921118800 10269048832 962449696 10.513 100 73 146 0 1034864480 58035472 14379312
08:17:22 3836 8192000000 9962415616 10322243584 994916464 10.829 100 83 167 3 1082888800 71974432 15997904
08:18:28 3110 8192000000 9995236224 10360631296 1017188736 11.045 100 91 177 3 1108887504 74448096 17250672
08:19:34 1900 8192000000 9996999424 10368716800 1028653472 11.155 100 83 162 1 1113672704 69642624 15376608
08:20:38 1455 8192000000 10006141632 10381340672 1050469264 11.365 100 88 172 0 1119956064 52311712 17175088
08:21:41 33100 8192000000 9998494576 10390458368 1060039376 11.457 100 69 139 0 1131604416 57033552 14531488
08:23:15 3087 8192000000 9965400656 10360868864 1064255824 11.497 100 36 68 0 1086326480 15002688 7067968
08:24:19 5142 8192000000 9989988384 10389512192 1070606752 11.558 100 36 73 0 1114988272 37193456 7188064
08:25:26 5265 8192000000 9998636320 10399408128 1077502592 11.624 100 43 83 2 1108646448 22999248 8144608
08:26:34 51933 8192000000 9991335312 10391883776 1082898272 11.675 100 30 60 1 1108645232 19398304 6348656
08:28:34 28412 8192000000 10021536448 10428018688 1096131488 11.801 100 47 94 0 1136630512 31557504 8941520
08:30:08 21454 8192000000 10064913776 10465153024 1103996304 11.876 100 55 110 1 1179960016 65187904 10775808
08:31:38 25920 8192000000 10071514848 10481893376 1120672224 12.033 100 52 103 1 1191095312 60124528 10298560
08:33:08 56308 8192000000 10137778768 10548191232 1136540208 12.183 100 42 84 1 1240914144 95294512 9079424
08:35:10 9809 8192000000 10189560336 10598850560 1144046480 12.254 100 47 94 0 1294730336 140415200 10268656
08:36:29 51170 8192000000 10204229344 10617815040 1117325296 12.002 98 37 74 0 1279678832 154069520 8284016
08:38:50 18992 8192000000 10232069984 10640244736 1139990368 12.215 99 54 106 1 1327668992 175623856 12054768
08:40:14 22055 8192000000 10191682880 10596790272 1083214768 11.678 96 40 80 0 1269784224 177831888 8737568
08:41:40 3684 8192000000 10237853184 10650116096 1119917392 12.026 100 55 108 0 1343935120 211940176 12077552
08:42:48 5431 8192000000 10262360288 10672656384 1129940240 12.121 100 51 102 1 1365786016 224736080 11109696
08:44:06 2660 8192000000 10257665824 10664751104 1108193184 11.915 100 67 132 0 1364491520 242033488 14264848
08:45:17 4808 8192000000 10309853808 10711166976 1119512000 12.022 100 65 130 2 1413975456 280501616 13961840
08:46:30 2893 8192000000 10309493312 10708688896 1102150144 11.858 100 71 142 0 1409182128 291312944 15719040
08:47:41 5720 8192000000 10307466688 10703507456 1083952256 11.685 100 66 129 1 1419091840 319882736 15256848
08:48:50 1909 8192000000 10352951360 10749759488 1101557504 11.852 100 89 179 1 1444795184 323046064 20191616
08:49:59 3365 8192000000 10342928752 10762006528 1110601472 11.938 100 71 141 0 1445726192 319812448 15312272
08:51:06 9969 8192000000 10229913744 10666057728 1105600208 11.891 100 45 90 0 1320517584 204704768 10212608
08:52:21 9876 8192000000 10299928320 10708946944 1119161440 12.019 100 55 110 0 1389029264 257752848 12114976
08:53:33 24061 8192000000 10150074336 10627543040 1112509360 11.956 100 15 30 0 1267385600 151489232 3387008
08:55:00 41250 8192000000 10104585488 10563739648 1101256928 11.850 99 13 26 0 1221584288 117413840 2913520
08:56:47 35865 8192000000 10096522672 10528436224 1115924032 11.988 99 15 30 0 1169840032 49933120 3982880
08:59:08 100206 8192000000 10072006160 10502438912 1105030976 11.885 98 39 75 1 1162137744 49583680 7523088
09:02:10 27251 8192000000 10112628528 10554900480 1118704208 12.015 99 25 50 0 1207985296 84314592 4966496
09:03:41 13034 8192000000 10098942224 10561294336 1114430720 11.974 100 33 66 0 1192721840 71243296 7047824
09:04:56 43514 8192000000 10088391072 10532958208 1114660288 11.977 99 15 30 0 1182043776 64409856 2973632
09:06:42 42263 8192000000 10137848368 10584924160 1129832656 12.120 100 24 48 0 1222547760 87462336 5252768
09:08:34 47913 8192000000 10088451936 10585022464 1126867104 12.092 99 23 46 0 1253214144 121227616 5119424
09:10:23 27941 8192000000 10081662960 10514325504 1136867040 12.186 100 33 65 0 1192165776 48438848 6859888
09:11:52 47199 8192000000 10056000304 10544472064 1130033568 12.122 100 15 28 0 1164696560 31989568 2673424
09:13:44 60773 8192000000 10109305104 10568241152 1142030496 12.235 100 19 38 0 1195737744 50071184 3636064
09:16:02 58309 8192000000 10109430304 10573844480 1121050656 12.037 98 17 34 0 1201694224 77281280 3362288
09:18:00 74556 8192000000 10072804560 10528780288 1127883088 12.101 99 16 32 0 1187793168 56288736 3621344
09:20:20 19413 8192000000 10061994384 10496086016 1136395232 12.182 100 23 46 0 1156830048 16496608 3938208
09:21:42 66858 8192000000 10052252800 10492211200 1075599696 11.606 95 9 18 0 1108149600 31260128 1289776
09:23:55 49035 8192000000 10066359328 10510995456 1058443424 11.442 95 34 68 0 1116729840 51529120 6757296
09:25:46 24623 8192000000 10055678320 10492612608 1085428736 11.699 98 31 59 1 1128487360 37506384 5552240
09:27:13 68246 8192000000 10069995024 10497830912 1096048896 11.800 99 42 82 0 1159988064 54457680 9481488
09:29:23 15861 8192000000 10079677008 10503802880 1096825504 11.808 98 46 93 0 1155238848 48891904 9521440
09:30:40 23070 8192000000 10070213760 10516791296 1107620912 11.910 99 23 45 0 1168199616 55410432 5168272
09:32:05 58320 8192000000 10040107632 10520432640 1097062832 11.810 99 21 42 0 1173160432 71720640 4376960
09:34:05 25725 8192000000 10025263904 10459148288 1077079504 11.620 98 21 38 0 1108785760 27611360 4094896
09:35:31 68437 8192000000 10029780656 10484998144 1065303456 11.507 97 9 18 0 1118842224 51574000 1964768
09:38:02 42897 8192000000 10020780992 10510323712 1089253664 11.736 100 13 26 0 1139488768 47806448 2428656
09:39:45 56663 8192000000 10052076064 10506731520 1078465872 11.633 99 25 50 0 1144548048 60698608 5383568
09:41:47 64004 8192000000 10035698304 10509185024 1077786528 11.626 98 27 54 0 1158331088 75342480 5202080
09:43:52 42278 8192000000 10060733104 10498576384 1087131248 11.715 99 38 75 0 1147336416 53032576 7172592
09:45:36 15502 8192000000 10058700432 10504183808 1104300672 11.878 100 33 66 1 1165425232 54227664 6896896
09:46:55 33093 8192000000 10108167712 10577879040 1103506672 11.871 99 28 54 0 1182859888 74307504 5045712
09:48:32 82795 8192000000 10072516384 10495475712 1103705216 11.873 98 30 60 0 1142772608 33595008 5472384
09:50:55 62200 8192000000 10095563680 10540687360 1119991824 12.027 99 57 112 0 1194081072 62310416 11778832
09:53:06 24619 8192000000 10052769392 10485501952 1110319280 11.935 98 24 48 1 1137163456 21506384 5337792
09:54:33 55078 8192000000 10084895104 10538131456 1111228720 11.944 98 11 22 0 1172403168 58528224 2646224
09:56:28 59504 8192000000 10117640336 10565292032 1135001648 12.168 100 12 24 0 1203844336 66395312 2447376
09:58:28 53844 8192000000 10077223600 10522959872 1131749968 12.138 99 29 58 1 1173617520 36331504 5536048
10:00:24 44891 8192000000 10100853056 10549362688 1137139968 12.189 99 23 46 0 1174563456 32765376 4658112
10:02:13 52888 8192000000 10144007520 10640535552 1135445024 12.173 99 10 20 0 1234422080 97029872 1947184
10:04:32 50811 8192000000 10081826976 10540621824 1113719072 11.968 97 15 30 0 1136339936 19849536 2771328
10:06:26 79132 8192000000 10095314880 10551926784 1071701504 11.568 94 13 26 0 1113407616 39293088 2413024

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 17-03-2024 10:08:44 to 17-03-2024 10:08:58.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-03-2024 10:08:59 to 17-03-2024 10:09:01.

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          163287
MON$OLDEST_ACTIVE               164383
MON$OLDEST_SNAPSHOT             164383
MON$NEXT_TRANSACTION            164383
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                       1896736
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             675
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sun Mar 17 10:09:02 2024 
 
Database header page information: 
    Flags            0 
    Generation        85723 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    163287 
    Oldest active        164383 
    Oldest snapshot        164383 
    Next transaction    164384 
    Sequence number        0 
    Next attachment ID    675 
    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.05, total records: 7780747 
    Average version length: 48.16, total versions: 168640, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 88168 
    Data pages: 88168, average fill: 71% 
    Primary pages: 88167, secondary pages: 1, swept pages: 24921 
    Empty pages: 5, full pages: 87057 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 64 
    60 - 79% = 87988 
    80 - 99% = 108 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 22981, nodes: 7780747 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1696538, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 320 
        20 - 39% = 1259 
        40 - 59% = 4246 
        60 - 79% = 2234 
        80 - 99% = 14922 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13363, nodes: 7780747 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1520787, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1176 
        40 - 59% = 2240 
        60 - 79% = 1027 
        80 - 99% = 8918 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8225, nodes: 7780747 
    Average node length: 6.62, total dup: 5807889, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1514018, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 664 
        40 - 59% = 1493 
        60 - 79% = 846 
        80 - 99% = 5077 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.55, total records: 2261923 
    Average version length: 58.85, total versions: 88783, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28384 
    Data pages: 28384, average fill: 74% 
    Primary pages: 28382, secondary pages: 2, swept pages: 6356 
    Empty pages: 2, full pages: 27421 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 9 
    40 - 59% = 123 
    60 - 79% = 27990 
    80 - 99% = 253 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4464, nodes: 2261923 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 683053, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 644 
        40 - 59% = 990 
        60 - 79% = 670 
        80 - 99% = 2160 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2388, nodes: 2263902 
    Average node length: 4.97, total dup: 2263003, max dup: 20467 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1266349, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 155 
        40 - 59% = 1356 
        60 - 79% = 589 
        80 - 99% = 287 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1737, nodes: 2261923 
    Average node length: 4.97, total dup: 2261873, max dup: 129951 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1064291, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 562 
        60 - 79% = 54 
        80 - 99% = 1117 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4251, nodes: 2261923 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 683053, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 94 
        20 - 39% = 408 
        40 - 59% = 673 
        60 - 79% = 738 
        80 - 99% = 2338 
 
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: 82.84, total records: 400 
    Average version length: 29.43, total versions: 2374, max versions: 6 
    Average fragment length: 2.00, total fragments: 29, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 77% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 3, full pages: 19 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 18 
 
    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: 23.14, total records: 97373 
    Average version length: 68.29, total versions: 74166, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.80 
    Pointer pages: 8, data page slots: 4032 
    Data pages: 1912, average fill: 66% 
    Primary pages: 1911, secondary pages: 1, swept pages: 0 
    Empty pages: 236, full pages: 1159 
    Fill distribution: 
     0 - 19% = 281 
    20 - 39% = 122 
    40 - 59% = 190 
    60 - 79% = 411 
    80 - 99% = 908 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1680805, depth: 3, leaf buckets: 362, nodes: 97373 
    Average node length: 13.27, total dup: 7163, max dup: 2 
    Average key length: 10.67, compression ratio: 2.53 
    Average prefix length: 19.25, average data length: 7.75 
    Clustering factor: 71145, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 137 
        40 - 59% = 185 
        60 - 79% = 37 
        80 - 99% = 2 
 
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: 108, max versions: 3 
    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: 1 
    Data pages: 1, average fill: 58% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    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: 17.78, total records: 1599 
    Average version length: 43.31, total versions: 1200, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.26 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 51% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 6, full pages: 15 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 7 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92799, depth: 2, leaf buckets: 6, nodes: 1599 
    Average node length: 4.25, total dup: 1501, max dup: 174 
    Average key length: 2.68, compression ratio: 7.08 
    Average prefix length: 18.38, average data length: 0.62 
    Clustering factor: 874, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.61, total records: 74 
    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: 52% 
    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: 74 
    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: 35.35, total records: 857076 
    Average version length: 37.83, total versions: 45625, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.53 
    Pointer pages: 6, data page slots: 8728 
    Data pages: 8720, average fill: 67% 
    Primary pages: 8717, secondary pages: 3, swept pages: 956 
    Empty pages: 13, full pages: 8566 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 25 
    40 - 59% = 43 
    60 - 79% = 8508 
    80 - 99% = 104 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 859, nodes: 827524 
    Average node length: 4.88, total dup: 827475, max dup: 161015 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90930, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 109 
        40 - 59% = 432 
        60 - 79% = 193 
        80 - 99% = 125 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1047, nodes: 827524 
    Average node length: 5.89, total dup: 736825, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162925, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 40 
        40 - 59% = 730 
        60 - 79% = 61 
        80 - 99% = 213 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1081, nodes: 827524 
    Average node length: 5.89, total dup: 736825, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164779, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 82 
        40 - 59% = 741 
        60 - 79% = 58 
        80 - 99% = 199 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1156, nodes: 827524 
    Average node length: 5.97, total dup: 736825, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156816, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 207 
        40 - 59% = 649 
        60 - 79% = 206 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5488 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 5.23, total fragments: 13, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 85, average fill: 64% 
    Primary pages: 76, secondary pages: 9, swept pages: 52 
    Empty pages: 3, full pages: 57 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5488 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.04 
    Average prefix length: 34.48, average data length: 1.55 
    Clustering factor: 5277, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5488 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 158, 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.08, total records: 74200 
    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: 776 
    Data pages: 776, average fill: 66% 
    Primary pages: 776, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 771 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 771 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36268, depth: 2, leaf buckets: 96, nodes: 74200 
    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: 2825, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 93 
 
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.51, 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: 148.90, total records: 139975 
    Average version length: 150.36, total versions: 2191, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 6, data page slots: 4624 
    Data pages: 3496, average fill: 83% 
    Primary pages: 3494, secondary pages: 2, swept pages: 2 
    Empty pages: 48, full pages: 3425 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 5 
    80 - 99% = 3427 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 140.67, total records: 138031 
    Average version length: 153.92, total versions: 10236, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.06 
    Pointer pages: 7, data page slots: 6016 
    Data pages: 3456, average fill: 83% 
    Primary pages: 3454, secondary pages: 2, swept pages: 3 
    Empty pages: 45, full pages: 3380 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 15 
    40 - 59% = 7 
    60 - 79% = 7 
    80 - 99% = 3379 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 148.44, total records: 131738 
    Average version length: 151.28, total versions: 2417, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 4096 
    Data pages: 3296, average fill: 82% 
    Primary pages: 3293, secondary pages: 3, swept pages: 3 
    Empty pages: 55, full pages: 3222 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 4 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 3224 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 124.91, total records: 181377 
    Average version length: 154.81, total versions: 33976, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.58 
    Pointer pages: 9, data page slots: 7584 
    Data pages: 4648, average fill: 83% 
    Primary pages: 4645, secondary pages: 3, swept pages: 6 
    Empty pages: 145, full pages: 4454 
    Fill distribution: 
     0 - 19% = 147 
    20 - 39% = 16 
    40 - 59% = 14 
    60 - 79% = 18 
    80 - 99% = 4453 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 123.84, total records: 168361 
    Average version length: 154.82, total versions: 32628, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.70 
    Pointer pages: 6, data page slots: 6464 
    Data pages: 4336, average fill: 83% 
    Primary pages: 4334, secondary pages: 2, swept pages: 12 
    Empty pages: 152, full pages: 4131 
    Fill distribution: 
     0 - 19% = 159 
    20 - 39% = 20 
    40 - 59% = 12 
    60 - 79% = 14 
    80 - 99% = 4131 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.14, total records: 142662 
    Average version length: 147.46, total versions: 1174, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 7, data page slots: 3576 
    Data pages: 3552, average fill: 83% 
    Primary pages: 3549, secondary pages: 3, swept pages: 6 
    Empty pages: 38, full pages: 3500 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3500 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 150.41, total records: 138471 
    Average version length: 143.85, total versions: 734, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 6, data page slots: 4328 
    Data pages: 3496, average fill: 82% 
    Primary pages: 3494, secondary pages: 2, swept pages: 3 
    Empty pages: 82, full pages: 3393 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3393 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 148.65, total records: 128038 
    Average version length: 150.80, total versions: 2021, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 4480 
    Data pages: 3216, average fill: 82% 
    Primary pages: 3214, secondary pages: 2, swept pages: 4 
    Empty pages: 62, full pages: 3128 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 10 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3130 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 145.61, total records: 128592 
    Average version length: 153.24, total versions: 4817, 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: 7, data page slots: 4536 
    Data pages: 3272, average fill: 81% 
    Primary pages: 3270, secondary pages: 2, swept pages: 3 
    Empty pages: 95, full pages: 3143 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 13 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 3143 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 139.52, total records: 132674 
    Average version length: 154.84, total versions: 10466, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.16 
    Pointer pages: 5, data page slots: 5216 
    Data pages: 3384, average fill: 82% 
    Primary pages: 3382, secondary pages: 2, swept pages: 5 
    Empty pages: 102, full pages: 3235 
    Fill distribution: 
     0 - 19% = 110 
    20 - 39% = 17 
    40 - 59% = 14 
    60 - 79% = 9 
    80 - 99% = 3234 
 
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: 51.11, total records: 2113843 
    Average version length: 52.87, total versions: 78590, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25456 
    Data pages: 25456, average fill: 72% 
    Primary pages: 25435, secondary pages: 21, swept pages: 7900 
    Empty pages: 95, full pages: 24343 
    Fill distribution: 
     0 - 19% = 176 
    20 - 39% = 129 
    40 - 59% = 288 
    60 - 79% = 23975 
    80 - 99% = 888 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2562, nodes: 2113843 
    Average node length: 5.44, total dup: 1973011, max dup: 1411 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182820, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 267 
        40 - 59% = 1686 
        60 - 79% = 283 
        80 - 99% = 324 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2756, nodes: 2113843 
    Average node length: 5.69, total dup: 1898461, max dup: 64 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 377902, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2417 
        60 - 79% = 309 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2041, nodes: 2113843 
    Average node length: 4.96, total dup: 2113743, max dup: 28057 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180441, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 112 
        40 - 59% = 1021 
        60 - 79% = 393 
        80 - 99% = 511 
 
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: 40.76, total records: 177627 
    Average version length: 69.17, total versions: 83956, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.09 
    Pointer pages: 3, data page slots: 4312 
    Data pages: 3304, average fill: 65% 
    Primary pages: 3304, secondary pages: 0, swept pages: 348 
    Empty pages: 540, full pages: 2613 
    Fill distribution: 
     0 - 19% = 670 
    20 - 39% = 11 
    40 - 59% = 2 
    60 - 79% = 1022 
    80 - 99% = 1599 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555017, depth: 3, leaf buckets: 243, nodes: 177627 
    Average node length: 6.48, total dup: 154645, max dup: 21 
    Average key length: 3.90, compression ratio: 10.78 
    Average prefix length: 40.23, average data length: 1.77 
    Clustering factor: 31248, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 16 
        40 - 59% = 109 
        60 - 79% = 85 
        80 - 99% = 31 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 63.80, total records: 7469703 
    Average version length: 68.73, total versions: 639568, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 66, data page slots: 106864 
    Data pages: 106864, average fill: 76% 
    Primary pages: 106863, secondary pages: 1, swept pages: 6978 
    Empty pages: 2, full pages: 106603 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 10 
    60 - 79% = 102402 
    80 - 99% = 4449 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10790, nodes: 7469703 
    Average node length: 6.50, total dup: 6464532, max dup: 29 
    Average key length: 3.51, compression ratio: 11.96 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1746580, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1260 
        40 - 59% = 5550 
        60 - 79% = 3249 
        80 - 99% = 725 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8721, nodes: 7469703 
    Average node length: 5.39, total dup: 7180643, max dup: 162 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1537243, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 908 
        40 - 59% = 4802 
        60 - 79% = 1837 
        80 - 99% = 1155 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8758, nodes: 7469703 
    Average node length: 5.39, total dup: 7180643, max dup: 162 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1539658, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 936 
        40 - 59% = 4821 
        60 - 79% = 1871 
        80 - 99% = 1124 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.25, total records: 12476139 
    Average version length: 68.70, total versions: 552763, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 109, data page slots: 177216 
    Data pages: 177216, average fill: 75% 
    Primary pages: 177215, secondary pages: 1, swept pages: 43142 
    Empty pages: 0, full pages: 177134 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 18 
    60 - 79% = 171729 
    80 - 99% = 5467 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18555, nodes: 12470566 
    Average node length: 6.63, total dup: 10872904, max dup: 79 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2520107, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 1916 
        40 - 59% = 10409 
        60 - 79% = 5176 
        80 - 99% = 1035 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 36.90, total records: 2149359 
    Average version length: 69.05, total versions: 635525, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.42 
    Pointer pages: 27, data page slots: 43288 
    Data pages: 30320, average fill: 69% 
    Primary pages: 30238, secondary pages: 82, swept pages: 557 
    Empty pages: 0, full pages: 30239 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 5043 
    40 - 59% = 2335 
    60 - 79% = 13406 
    80 - 99% = 9463 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1875, nodes: 1632328 
    Average node length: 5.51, total dup: 1566908, max dup: 49 
    Average key length: 2.55, compression ratio: 16.48 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 114952, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 144 
        40 - 59% = 862 
        60 - 79% = 600 
        80 - 99% = 260 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 29.43, total records: 1678242 
    Average version length: 69.01, total versions: 191068, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.28 
    Pointer pages: 23, data page slots: 36440 
    Data pages: 30152, average fill: 39% 
    Primary pages: 30151, secondary pages: 1, swept pages: 6989 
    Empty pages: 8141, full pages: 16413 
    Fill distribution: 
     0 - 19% = 11282 
    20 - 39% = 2435 
    40 - 59% = 5046 
    60 - 79% = 10435 
    80 - 99% = 954 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1134, nodes: 762472 
    Average node length: 5.97, total dup: 700969, max dup: 95 
    Average key length: 3.04, compression ratio: 13.84 
    Average prefix length: 41.04, average data length: 0.96 
    Clustering factor: 112850, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 303 
        40 - 59% = 564 
        60 - 79% = 229 
        80 - 99% = 38 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 63.85, total records: 9372294 
    Average version length: 68.97, total versions: 780481, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 87, data page slots: 140640 
    Data pages: 140616, average fill: 72% 
    Primary pages: 140599, secondary pages: 17, swept pages: 20113 
    Empty pages: 71, full pages: 112079 
    Fill distribution: 
     0 - 19% = 404 
    20 - 39% = 2504 
    40 - 59% = 12280 
    60 - 79% = 117412 
    80 - 99% = 8016 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13448, nodes: 9364204 
    Average node length: 6.66, total dup: 7769568, max dup: 27 
    Average key length: 3.66, compression ratio: 11.46 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2118944, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1055 
        40 - 59% = 6696 
        60 - 79% = 4965 
        80 - 99% = 731 
 
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: 21088401 
    Average version length: 83.03, total versions: 24380, 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: 318592 
    Data pages: 318592, average fill: 81% 
    Primary pages: 318587, secondary pages: 5, swept pages: 10313 
    Empty pages: 1, full pages: 318587 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 46561 
    80 - 99% = 272027 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19246, nodes: 21088401 
    Average node length: 5.72, total dup: 20608741, max dup: 160 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3273549, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 3 
        40 - 59% = 7991 
        60 - 79% = 544 
        80 - 99% = 10704 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17086, nodes: 21088401 
    Average node length: 6.31, total dup: 18533040, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913472, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 7 
        40 - 59% = 743 
        60 - 79% = 242 
        80 - 99% = 16091 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20970, nodes: 21088401 
    Average node length: 6.34, total dup: 18452465, max dup: 44 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3566529, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8168 
        60 - 79% = 571 
        80 - 99% = 12226 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15971, nodes: 21088401 
    Average node length: 5.56, total dup: 21088301, max dup: 230659 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942234, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 7 
        40 - 59% = 2745 
        60 - 79% = 355 
        80 - 99% = 12862 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.50, total records: 9828636 
    Average version length: 82.62, total versions: 789782, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 103, data page slots: 166992 
    Data pages: 166976, average fill: 73% 
    Primary pages: 166953, secondary pages: 23, swept pages: 36583 
    Empty pages: 491, full pages: 129579 
    Fill distribution: 
     0 - 19% = 1358 
    20 - 39% = 4556 
    40 - 59% = 14745 
    60 - 79% = 110380 
    80 - 99% = 35937 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11286, nodes: 9828636 
    Average node length: 5.35, total dup: 9520549, max dup: 220 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2241030, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 31 
        40 - 59% = 7640 
        60 - 79% = 3522 
        80 - 99% = 90 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13245, nodes: 9828636 
    Average node length: 6.22, total dup: 8149569, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1588191, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 3231 
        40 - 59% = 4634 
        60 - 79% = 2600 
        80 - 99% = 2654 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12597, nodes: 9828636 
    Average node length: 5.96, total dup: 8542823, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2437339, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 25 
        40 - 59% = 8696 
        60 - 79% = 3774 
        80 - 99% = 100 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10053, nodes: 9828636 
    Average node length: 5.12, total dup: 9828536, max dup: 161550 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1606767, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 49 
        20 - 39% = 1021 
        40 - 59% = 5044 
        60 - 79% = 1738 
        80 - 99% = 2201 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.26, total records: 11342427 
    Average version length: 82.53, total versions: 622123, 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: 117, data page slots: 189808 
    Data pages: 188560, average fill: 74% 
    Primary pages: 188438, secondary pages: 122, swept pages: 47530 
    Empty pages: 2514, full pages: 157084 
    Fill distribution: 
     0 - 19% = 3940 
    20 - 39% = 5006 
    40 - 59% = 11734 
    60 - 79% = 94875 
    80 - 99% = 73005 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13088, nodes: 11342427 
    Average node length: 5.29, total dup: 11233091, max dup: 685 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2379351, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 122 
        40 - 59% = 9132 
        60 - 79% = 3707 
        80 - 99% = 126 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10333, nodes: 11342427 
    Average node length: 5.48, total dup: 10848517, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 731172, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 756 
        40 - 59% = 2561 
        60 - 79% = 1726 
        80 - 99% = 5159 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14963, nodes: 11342427 
    Average node length: 6.01, total dup: 9905648, max dup: 67 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2395744, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 149 
        40 - 59% = 10593 
        60 - 79% = 4050 
        80 - 99% = 169 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10635, nodes: 11342427 
    Average node length: 5.21, total dup: 11342327, max dup: 194963 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 718884, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 108 
        20 - 39% = 713 
        40 - 59% = 4703 
        60 - 79% = 1417 
        80 - 99% = 3694 
 
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: 77.05, total records: 9915166 
    Average version length: 82.92, total versions: 763069, 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: 106, data page slots: 172056 
    Data pages: 171992, average fill: 72% 
    Primary pages: 171956, secondary pages: 36, swept pages: 40433 
    Empty pages: 508, full pages: 129263 
    Fill distribution: 
     0 - 19% = 1510 
    20 - 39% = 7060 
    40 - 59% = 19787 
    60 - 79% = 107979 
    80 - 99% = 35656 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11819, nodes: 9915166 
    Average node length: 5.17, total dup: 9886606, max dup: 1586 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2047772, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 1299 
        40 - 59% = 7951 
        60 - 79% = 1957 
        80 - 99% = 593 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13366, nodes: 9915166 
    Average node length: 6.24, total dup: 8221331, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1548043, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 3205 
        40 - 59% = 4663 
        60 - 79% = 2552 
        80 - 99% = 2780 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12406, nodes: 9915166 
    Average node length: 5.42, total dup: 9476592, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2182859, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1267 
        40 - 59% = 8755 
        60 - 79% = 1762 
        80 - 99% = 599 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10146, nodes: 9915166 
    Average node length: 5.14, total dup: 9915066, max dup: 163848 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1621578, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1056 
        40 - 59% = 5071 
        60 - 79% = 1700 
        80 - 99% = 2287 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.21, total records: 577695 
    Average version length: 68.88, total versions: 9321, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7968 
    Data pages: 7968, average fill: 76% 
    Primary pages: 7968, secondary pages: 0, swept pages: 2323 
    Empty pages: 3, full pages: 7964 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 7808 
    80 - 99% = 156 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46917, depth: 3, leaf buckets: 736, nodes: 577695 
    Average node length: 5.95, total dup: 491915, max dup: 107 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101765, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 535 
        60 - 79% = 81 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34468, depth: 3, leaf buckets: 754, nodes: 577695 
    Average node length: 6.15, total dup: 473798, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101822, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 532 
        60 - 79% = 93 
        80 - 99% = 103 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 544, nodes: 577695 
    Average node length: 4.86, total dup: 577595, max dup: 9459 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90270, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 16 
        40 - 59% = 295 
        60 - 79% = 92 
        80 - 99% = 141 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sun Mar 17 10:09:26 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7780747 168640 1 0.0000 0.0000
DOC_LIST 2261923 88783 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2374 6 500.0000 0.0000
INVNT_TURNOVER_LOG 97373 74166 1 0.0000 0.0000
MONEY_SALDO 49 108 3 200.0000 0.0000
MONEY_TURNOVER_LOG 1599 1200 1 0.0000 0.0000
PDISTR 857076 45625 2 0.0000 0.0000
PERF_SPLIT_0 139975 2191 1 0.0000 0.0000
PERF_SPLIT_1 138031 10236 1 0.0000 0.0000
PERF_SPLIT_2 131738 2417 1 0.0000 0.0000
PERF_SPLIT_3 181377 33976 1 0.0000 0.0000
PERF_SPLIT_4 168361 32628 1 0.0000 0.0000
PERF_SPLIT_5 142662 1174 1 0.0000 0.0000
PERF_SPLIT_6 138471 734 1 0.0000 0.0000
PERF_SPLIT_7 128038 2021 1 0.0000 0.0000
PERF_SPLIT_8 128592 4817 1 0.0000 0.0000
PERF_SPLIT_9 132674 10466 1 0.0000 0.0000
PSTORNED 2113843 78590 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 177627 83956 1 0.0000 0.0000
XQD_1000_3300 7469703 639568 1 0.0000 0.0000
XQD_1200_2000 12476139 552763 1 0.0000 0.0000
XQD_2000_3300 2149359 635525 1 0.0000 0.0000
XQD_2100_3300 1678242 191068 1 0.0000 0.0000
XQD_3300_3400 9372294 780481 1 0.0000 0.0000
XQS_1000_1200 21088401 24380 1 0.0000 0.0000
XQS_1000_3300 9828636 789782 1 0.0000 0.0000
XQS_1200_2000 11342427 622123 1 0.0000 0.0000
XQS_2100_3300 9915166 763069 1 0.0000 0.0000
XQS_3300_3400 577695 9321 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 ---
:23: 
:24: mscs-test-161.budzdorov.ru    Sun Mar 17 10:08:00 2024
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:26: 
:27: 
:28: mscs-test-161.budzdorov.ru    Sun Mar 17 10:08:01 2024
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:30: 
--- end of diff output ---

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

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