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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15860424 kB
MemAvailable 30276784 kB
Buffers 0 kB
Cached 15904296 kB
SwapCached 2476 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-26 22:09:40
DTS_END                         2024-03-26 22:09:40.2010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57668
TRN_ID                          173201
ATT_ID                          486
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: 8930.68 24333 893068
customer order: creation 171.00 393 17100
customer order: refuse 14.74 383 1474
order to supplier: creation 44.05 1449 4405
order to supplier: removal 3.48 107599 348
invoice (draft): creation 46.08 3595 4608
invoice (draft): removal 48.96 971 4896
invoice accept: apply 41.38 20887 4138
invoice accept: cancel 44.19 889 4419
customer reserve: creation 3929.33 202 392933
customer reserve: removal 4302.34 68 430234
realization accept: apply 82.92 203 8292
realization accept: cancel 71.80 143 7180
payment from customer: creation 60.21 108 6021
payment from customer: removal 5.86 98 586
payment to supplier: creation 48.71 169 4871
payment to supplier: removal 3.45 80 345
service: total inventory turnovers 4.58 1434 458
service: total monetary turnovers 6.87 25 687
service: aggregate perf. data 0.70 29910 70
service: refresh index statistics 0.03 318060 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 26-03-2024 22:11:21 to 26-03-2024 22:11:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4768
TEST_TIME 2 3109
TEST_TIME 3 4502
TEST_TIME 4 4788
TEST_TIME 5 4819
TEST_TIME 6 4841
TEST_TIME 7 4949
TEST_TIME 8 4976
TEST_TIME 9 4819
TEST_TIME 10 4873
TEST_TIME 11 5228
TEST_TIME 12 5361
TEST_TIME 13 5944
TEST_TIME 14 6192
TEST_TIME 15 6208
TEST_TIME 16 6425
TEST_TIME 17 6673
TEST_TIME 18 6557
TEST_TIME 19 6646
TEST_TIME 20 6695
TEST_TIME 21 6862
TEST_TIME 22 7039
TEST_TIME 23 7219
TEST_TIME 24 7501
TEST_TIME 25 7505
TEST_TIME 26 8123
TEST_TIME 27 8767
TEST_TIME 28 9314
TEST_TIME 29 9307
TEST_TIME 30 9152
TEST_TIME 31 9375
TEST_TIME 32 9237
TEST_TIME 33 9141
TEST_TIME 34 8959
TEST_TIME 35 9008
TEST_TIME 36 9117
TEST_TIME 37 8895
TEST_TIME 38 8859
TEST_TIME 39 8816
TEST_TIME 40 8828
TEST_TIME 41 8769
TEST_TIME 42 8761
TEST_TIME 43 8697
TEST_TIME 44 8655
TEST_TIME 45 8671
TEST_TIME 46 8757
TEST_TIME 47 8724
TEST_TIME 48 8749
TEST_TIME 49 8844
TEST_TIME 50 8691
TEST_TIME 51 8552
TEST_TIME 52 8711
TEST_TIME 53 8733
TEST_TIME 54 8731
TEST_TIME 55 8676
TEST_TIME 56 8691
TEST_TIME 57 8763
TEST_TIME 58 8896
TEST_TIME 59 8940
TEST_TIME 60 8865
TEST_TIME 61 8888
TEST_TIME 62 8997
TEST_TIME 63 8928
TEST_TIME 64 9002
TEST_TIME 65 9108
TEST_TIME 66 9152
TEST_TIME 67 9186
TEST_TIME 68 9072
TEST_TIME 69 9034
TEST_TIME 70 8949
TEST_TIME 71 8904
TEST_TIME 72 8888
TEST_TIME 73 8925
TEST_TIME 74 8927
TEST_TIME 75 8894
TEST_TIME 76 8862
TEST_TIME 77 8889
TEST_TIME 78 8912
TEST_TIME 79 8874
TEST_TIME 80 8927
TEST_TIME 81 8905
TEST_TIME 82 8924
TEST_TIME 83 9005
TEST_TIME 84 9031
TEST_TIME 85 9081
TEST_TIME 86 9078
TEST_TIME 87 9091
TEST_TIME 88 9078
TEST_TIME 89 9112
TEST_TIME 90 9161
TEST_TIME 91 9118
TEST_TIME 92 9096
TEST_TIME 93 9061
TEST_TIME 94 9064
TEST_TIME 95 9015
TEST_TIME 96 8971
TEST_TIME 97 8974
TEST_TIME 98 8929
TEST_TIME 99 8987
TEST_TIME 100 8936

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-03-2024 22:11:25 to 26-03-2024 22:11:28.

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 1251497 1251497 0 0.00 0 19099 7 0 0
doc_list_biud 1251496 1251496 0 0.00 0 29110 30 0 0
sp_add_invoice_to_stock 4240 4138 102 2.40 46 177005 20887 0 102
sp_cancel_adding_invoice 4419 4419 0 0.00 4 68626 890 0 0
sp_cancel_client_order 1474 1474 0 0.00 4 11197 384 0 0
sp_cancel_customer_reserve 430234 430234 0 0.00 0 29112 68 0 0
sp_cancel_pay_from_customer 586 586 0 0.00 3 7544 98 0 0
sp_cancel_pay_to_supplier 345 345 0 0.00 3 3025 81 0 0
sp_cancel_supplier_invoice 4910 4896 14 0.28 2 25628 972 0 14
sp_cancel_supplier_order 348 348 0 0.00 6 1079506 107599 0 0
sp_cancel_write_off 7180 7180 0 0.00 1 9312 143 0 0
sp_client_order 17100 17100 0 0.00 3 23583 394 0 0
sp_customer_reserve 392933 392933 0 0.00 0 109181 203 0 0
sp_fill_shopping_cart 26099 26099 0 0.00 1 13807 46 0 0
sp_fill_shopping_cart_clo_res 392923 392923 0 0.00 0 23860 17 0 0
sp_get_clo_for_invoice 4127 4127 0 0.00 0 27329 375 0 0
sp_kill_cost_storno 12530 12530 0 0.00 0 8190 67 0 0
sp_kill_qstorno_ret_qs2qd 872892 872892 0 0.00 0 29102 38 0 0
sp_kill_qty_storno 460970 460970 0 0.00 0 29109 81 0 0
sp_lock_selected_doc 17234 17234 0 0.00 0 5710 4 0 0
sp_make_cost_storno 23311 23311 0 0.00 0 19096 63 0 0
sp_multiply_rows_for_pdistr 23310 23310 0 0.00 0 17594 32 0 0
sp_multiply_rows_for_qdistr 17100 17100 0 0.00 0 23562 153 0 0
sp_pay_from_customer 6021 6021 0 0.00 4 12314 108 0 0
sp_pay_to_supplier 4871 4871 0 0.00 5 17619 169 0 0
sp_payment_common 10891 10891 0 0.00 1 11426 29 0 0
sp_qd_handle_on_cancel_clo 1474 1474 0 0.00 0 11177 356 0 0
sp_qd_handle_on_invoice_upd_sts 8546 8546 0 0.00 0 26236 365 0 0
sp_qd_handle_on_reserve_upd_sts 8292 8292 0 0.00 0 17838 77 0 0
sp_reserve_write_off 8292 8292 0 0.00 6 17980 204 0 0
sp_supplier_invoice 4608 4608 0 0.00 8 79700 3596 0 0
sp_supplier_order 4405 4405 0 0.00 5 48941 1450 0 0
srv_aggregate_perf_data 70 70 0 0.00 1839 707917 29911 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1839 107534 35826 0 0
srv_find_qd_qs_mism 850333 850333 0 0.00 0 10787 6 0 0
srv_make_invnt_saldo 458 458 0 0.00 39 119512 1435 0 0
srv_make_money_saldo 687 687 0 0.00 1 969 26 0 0
srv_recalc_idx_stat 3 3 0 0.00 247795 362412 318060 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4138 4138 0 0.00 0 11038 195 0 0
t$perf-norm:sp_cancel_adding_invoice 364 364 0 0.00 0 6434 137 0 0
t$perf-norm:sp_cancel_client_order 1474 1474 0 0.00 0 2287 13 0 0
t$perf-norm:sp_cancel_customer_reserve 562 562 0 0.00 0 3920 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 586 586 0 0.00 0 4530 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 345 345 0 0.00 0 3756 19 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 5340 28 0 0
t$perf-norm:sp_cancel_supplier_order 348 348 0 0.00 0 29598 1765 0 0
t$perf-norm:sp_cancel_write_off 804 804 0 0.00 0 2243 8 0 0
t$perf-norm:sp_client_order 17100 17100 0 0.00 0 8320 17 0 0
t$perf-norm:sp_customer_reserve 794 794 0 0.00 0 2345 7 0 0
t$perf-norm:sp_pay_from_customer 6021 6021 0 0.00 0 5916 10 0 0
t$perf-norm:sp_pay_to_supplier 4871 4871 0 0.00 0 8636 12 0 0
t$perf-norm:sp_reserve_write_off 8292 8292 0 0.00 0 5414 10 0 0
t$perf-norm:sp_supplier_invoice 4608 4608 0 0.00 0 7694 22 0 0
t$perf-norm:sp_supplier_order 4405 4405 0 0.00 0 2543 16 0 0
t$perf-norm:srv_aggregate_perf_data 70 70 0 0.00 0 450 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 50 1 0 0
t$perf-norm:srv_make_invnt_saldo 458 458 0 0.00 0 693 20 0 0
t$perf-norm:srv_make_money_saldo 687 687 0 0.00 0 1187 15 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 552 185 0 0
v_add_invoice_to_stock 8458 8254 204 2.41 0 7751 19 0 204
v_all_customers 31996 31996 0 0.00 0 15 1 0 0
v_all_suppliers 25646 25646 0 0.00 0 23 1 0 0
v_all_wares 34194 34194 0 0.00 0 32 1 0 0
v_cancel_adding_invoice 728 728 0 0.00 0 1166 8 0 0
v_cancel_client_order 2948 2948 0 0.00 0 1649 7 0 0
v_cancel_customer_prepayment 1172 1172 0 0.00 0 2235 10 0 0
v_cancel_customer_reserve 1124 1124 0 0.00 0 2032 6 0 0
v_cancel_payment_to_supplier 690 690 0 0.00 0 2979 11 0 0
v_cancel_supplier_invoice 692 664 28 4.04 0 2165 18 0 28
v_cancel_supplier_order 696 696 0 0.00 0 1959 16 0 0
v_cancel_write_off 1608 1608 0 0.00 0 2493 14 0 0
v_max_id_clo_ord 4404 4404 0 0.00 0 3156 2 0 0
v_max_id_clo_res 794 794 0 0.00 0 1994 17 0 0
v_max_id_ord_sup 4598 4598 0 0.00 0 6034 5 0 0
v_max_non_paid_invoice 1049 1049 0 0.00 0 1765 4 0 0
v_max_non_paid_realizn 2881 2881 0 0.00 0 1162 3 0 0
v_min_id_clo_ord 4404 4404 0 0.00 0 7955 12 0 0
v_min_id_clo_res 794 794 0 0.00 0 9656 59 0 0
v_min_id_ord_sup 4598 4598 0 0.00 0 6955 8 0 0
v_min_non_paid_invoice 4870 4870 0 0.00 0 6494 25 0 0
v_min_non_paid_realizn 6021 6021 0 0.00 0 7949 20 0 0
v_our_firm 8478 8478 0 0.00 0 21 1 0 0
v_reserve_write_off 16584 16584 0 0.00 0 3739 7 0 0
x_lock_depdocs_on_canc_invoice 8983 8983 0 0.00 0 13928 134 0 0
x_lock_depdocs_on_canc_sup_ord 348 348 0 0.00 0 4177 349 0 0
x_make_qstorno_1000_1200 4405 4405 0 0.00 1 48909 1363 0 0
x_make_qstorno_1200_2000 4608 4608 0 0.00 3 79577 3418 0 0
x_make_qstorno_2100_3300 392933 392933 0 0.00 0 109178 183 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-03-2024 22:11:29 to 26-03-2024 22:11:33.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
20:09:44 4 8192000000 8804708832 8818036736 10254576 0.125 3 2 3 0 10397040 67504 74960
20:10:45 26985 8192000000 9901910784 10208903168 972530736 10.611 100 88 174 0 1001379360 5661936 23186688
20:12:20 17863 8192000000 9949496272 10271858688 1031801600 11.186 100 91 182 0 1062936288 7915568 23219120
20:13:49 11926 8192000000 9978116928 10309451776 1065322960 11.507 100 85 170 1 1096144000 9628336 21192704
20:15:12 9778 8192000000 10038593824 10382098432 1122121824 12.047 100 86 172 0 1153314064 10763424 20428816
20:16:25 6580 8192000000 10073152048 10426802176 1158737216 12.391 100 84 166 0 1189659488 12592544 18329728
20:17:36 3049 8192000000 10113615456 10482180096 1202943600 12.804 100 81 158 0 1233304544 12890272 17470672
20:18:42 2045 8192000000 10145020160 10515562496 1229995312 13.054 100 85 168 2 1262506944 14432640 18078992
20:19:46 1528 8192000000 10176131696 10555875328 1264374528 13.370 100 86 171 3 1296209648 12887664 18947456
20:20:48 2833 8192000000 10210569392 10592550912 1295506864 13.654 100 93 187 1 1329028320 13087424 20434032
20:21:52 4746 8192000000 10205623168 10601496576 1300880800 13.703 100 63 125 1 1323345568 7455680 15009088
20:22:57 4732 8192000000 10202684800 10611974144 1310148512 13.787 100 32 63 0 1324442224 7375120 6918592
20:24:04 6327 8192000000 10209054304 10619097088 1316350096 13.844 100 24 47 1 1326574192 5633888 4590208
20:25:12 10420 8192000000 10207242432 10627223552 1324129728 13.914 100 15 31 1 1333414192 5512144 3772320
20:26:24 59416 8192000000 10224268016 10645336064 1327740080 13.947 100 18 36 0 1336280192 5003008 3537104
20:28:24 4369 8192000000 10232236928 10650103808 1334489696 14.008 100 42 85 0 1351009392 6516272 10003424
20:29:29 4473 8192000000 10222179040 10631204864 1308568720 13.773 98 25 48 0 1320490256 5477088 6444448
20:30:43 2841 8192000000 10230657552 10630238208 1321312848 13.889 100 59 119 1 1344113216 9477104 13323264
20:31:51 39833 8192000000 10200894160 10610814976 1291468000 13.618 97 42 84 0 1313506176 12322480 9715696
20:33:36 16461 8192000000 10242715168 10649780224 1330690400 13.973 100 55 110 0 1355876480 12805968 12380112
20:34:55 8504 8192000000 10235859760 10631475200 1298895952 13.685 98 60 118 1 1327710112 14515504 14298656
20:36:11 12210 8192000000 10221141840 10624069632 1283667408 13.546 97 53 106 0 1311550016 15761872 12120736
20:37:37 20370 8192000000 10229242144 10638630912 1312804480 13.812 99 36 72 0 1338222976 16776912 8641584
20:39:15 32943 8192000000 10220149040 10621607936 1271912624 13.439 96 43 84 0 1305148448 23246848 9988976
20:40:51 10271 8192000000 10231117392 10634092544 1306793968 13.757 100 57 114 0 1347734048 26474768 14465312
20:42:07 8709 8192000000 10242671328 10646642688 1300727856 13.702 98 53 105 0 1343942080 29635360 13578864
20:43:23 4593 8192000000 10251812512 10652745728 1326461504 13.935 99 52 102 1 1360346352 21746208 12138640
20:44:39 4074 8192000000 10283062608 10681442304 1347967408 14.129 100 70 138 0 1389904608 24595568 17341632
20:45:52 9784 8192000000 10308683328 10719342592 1369576016 14.323 100 50 100 0 1412194608 30386544 12232048
20:47:17 4999 8192000000 10316707808 10726973440 1364934544 14.282 99 58 116 0 1409820736 30769664 14116528
20:48:26 2553 8192000000 10340474128 10751283200 1395074720 14.551 100 75 148 1 1446116960 32981776 18060464
20:49:36 3118 8192000000 10362470512 10766180352 1404782016 14.638 100 74 148 2 1459154128 35997264 18374848
20:50:42 11669 8192000000 10355887632 10774532096 1409261632 14.677 100 45 90 0 1458794928 37438528 12094768
20:51:58 25500 8192000000 10348998320 10776158208 1407226528 14.659 100 30 58 0 1455690144 40399936 8063680
20:53:29 24695 8192000000 10338407968 10773307392 1401146000 14.605 100 34 68 0 1452461120 41780832 9534288
20:55:25 18302 8192000000 10343541616 10779570176 1385153856 14.463 100 24 46 2 1446053024 54132320 6766848
20:56:54 1838 8192000000 10372506112 10790400000 1403225456 14.624 100 86 170 0 1463283856 40170800 19887600
20:57:58 25344 8192000000 10323956880 10777403392 1408286224 14.669 100 18 36 0 1431827440 19167984 4373232
20:59:44 19556 8192000000 10310514592 10763354112 1399959712 14.595 100 21 39 1 1419713280 15309520 4444048
21:01:12 25799 8192000000 10310276976 10757115904 1401763072 14.611 100 13 26 0 1418758688 14108880 2886736
21:02:46 39290 8192000000 10308827600 10754801664 1391899440 14.523 99 15 30 1 1409584832 14479168 3206224
21:04:32 26201 8192000000 10322500368 10772684800 1406304128 14.651 100 25 51 2 1437018176 25275072 5438976
21:06:00 78402 8192000000 10317438784 10766012416 1410597872 14.689 100 39 79 0 1426555856 6198704 9759280
21:08:53 21745 8192000000 10328122592 10773917696 1420469344 14.777 100 34 68 0 1434206464 6639984 7097136
21:10:16 45268 8192000000 10319769984 10775560192 1411218736 14.695 99 44 88 1 1430247792 8878944 10150112
21:12:08 83365 8192000000 10335612560 10788044800 1420597216 14.778 99 16 30 0 1435128224 11062528 3468480
21:14:48 28706 8192000000 10299725504 10745544704 1376675136 14.387 98 29 58 1 1396481552 12708160 7098256
21:16:20 10830 8192000000 10282315984 10716696576 1356591856 14.207 98 41 80 1 1380098176 12885856 10620464
21:17:44 84958 8192000000 10293954304 10745618432 1361664528 14.252 98 24 48 0 1383864704 16181248 6018928
21:20:10 47759 8192000000 10260979184 10705330176 1345344000 14.106 97 13 27 1 1362517248 13999776 3173472
21:22:00 85656 8192000000 10247387104 10706849792 1295262800 13.652 94 7 14 0 1309919136 13189200 1467136
21:24:28 27129 8192000000 10244433264 10683699200 1319520960 13.872 97 21 42 0 1337905200 13400544 4983696
21:26:04 67188 8192000000 10259511440 10700079104 1332189952 13.987 98 18 35 0 1349813904 13544240 4079712
21:28:18 83781 8192000000 10278970624 10706161664 1342776400 14.082 99 35 68 0 1361790304 11282160 7731744
21:30:42 25306 8192000000 10262494096 10695622656 1336833808 14.029 99 31 63 0 1359210816 15443248 6933760
21:32:11 23134 8192000000 10269312016 10696400896 1317686608 13.856 97 39 73 0 1334690288 8924832 8078848
21:33:40 57568 8192000000 10256315312 10704220160 1343721536 14.091 100 13 26 0 1362523312 15924480 2877296
21:35:42 98162 8192000000 10259853792 10713042944 1310918224 13.794 97 17 34 0 1335760384 20979744 3862416
21:38:22 71591 8192000000 10258170384 10691465216 1340579744 14.063 99 20 40 1 1352272304 6875600 4816960
21:40:34 15361 8192000000 10273251760 10710454272 1359631504 14.234 99 34 67 2 1375466112 8653664 7180944
21:41:52 37704 8192000000 10266499664 10716450816 1342974832 14.084 98 30 60 0 1362603424 12896112 6732480
21:43:40 51684 8192000000 10265724752 10719264768 1371012464 14.336 100 13 26 0 1382511024 8689008 2809552
21:45:36 58035 8192000000 10272138544 10736320512 1377096240 14.391 100 21 42 0 1393426272 11155456 5174576
21:47:49 17024 8192000000 10288917696 10736635904 1380513648 14.421 100 16 32 0 1391157360 6076336 4567376
21:49:07 20958 8192000000 10295796832 10741710848 1382807216 14.442 100 42 82 0 1402725616 10268384 9650016
21:50:34 51729 8192000000 10301872224 10760728576 1393738432 14.539 100 20 40 1 1413179152 15091872 4348848
21:52:29 64638 8192000000 10294855312 10755850240 1371500144 14.340 98 12 24 0 1386327136 12026336 2800656
21:54:34 55219 8192000000 10295972752 10748452864 1365912688 14.290 98 29 58 0 1386456256 14360432 6183136
21:56:34 52670 8192000000 10296715696 10747936768 1374922400 14.371 99 31 62 0 1391692400 10206528 6563472
21:58:35 26902 8192000000 10315780400 10768539648 1385386688 14.465 99 28 56 0 1406242448 15177808 5677952
22:00:09 107532 8192000000 10273270016 10721705984 1354585472 14.189 97 27 54 1 1375000704 13815216 6600016
22:02:57 13275 8192000000 10272547760 10717306880 1339845104 14.056 98 39 78 0 1360137840 12219968 8072768
22:04:15 42937 8192000000 10270637424 10732630016 1367395680 14.304 99 12 24 0 1380728224 10165776 3166768
22:05:58 52518 8192000000 10265347520 10723471360 1329584448 13.963 96 16 32 0 1345221872 11873536 3763888
22:07:54 69582 8192000000 10243225232 10704179200 1304450672 13.736 96 12 24 0 1323548864 15797600 3300592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 26-03-2024 22:11:35 to 26-03-2024 22:11:49.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 102 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-03-2024 22:11:50 to 26-03-2024 22:11:52.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          171408
MON$OLDEST_ACTIVE               173358
MON$OLDEST_SNAPSHOT             173358
MON$NEXT_TRANSACTION            173358
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1897824
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Tue Mar 26 22:11:53 2024 
 
Database header page information: 
    Flags            0 
    Generation        90361 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    171408 
    Oldest active        173358 
    Oldest snapshot        173358 
    Next transaction    173359 
    Sequence number        0 
    Next attachment ID    710 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.55, total records: 7718254 
    Average version length: 48.16, total versions: 54582, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86592 
    Data pages: 86592, average fill: 71% 
    Primary pages: 86592, secondary pages: 0, swept pages: 28239 
    Empty pages: 7, full pages: 58170 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 197 
    40 - 59% = 1922 
    60 - 79% = 84427 
    80 - 99% = 5 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23121, nodes: 7718254 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1707533, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 302 
        20 - 39% = 1924 
        40 - 59% = 3894 
        60 - 79% = 2422 
        80 - 99% = 14579 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13440, nodes: 7718254 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1530532, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1660 
        40 - 59% = 1845 
        60 - 79% = 1182 
        80 - 99% = 8753 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8294, nodes: 7718254 
    Average node length: 6.61, total dup: 5779935, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1523476, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 1054 
        40 - 59% = 1243 
        60 - 79% = 972 
        80 - 99% = 4904 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.71, total records: 2228780 
    Average version length: 34.77, total versions: 56399, max versions: 3 
    Average fragment length: 9.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28512 
    Data pages: 28512, average fill: 72% 
    Primary pages: 28504, secondary pages: 8, swept pages: 13823 
    Empty pages: 6, full pages: 18684 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 167 
    40 - 59% = 2157 
    60 - 79% = 25745 
    80 - 99% = 408 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4520, nodes: 2228780 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 694140, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 959 
        40 - 59% = 764 
        60 - 79% = 728 
        80 - 99% = 2069 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2527, nodes: 2230810 
    Average node length: 4.97, total dup: 2229911, max dup: 18852 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1234361, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 308 
        40 - 59% = 1525 
        60 - 79% = 515 
        80 - 99% = 177 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 1999, nodes: 2228780 
    Average node length: 4.97, total dup: 2228730, max dup: 130184 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056797, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 91 
        40 - 59% = 988 
        60 - 79% = 36 
        80 - 99% = 880 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4334, nodes: 2228780 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 694140, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 618 
        40 - 59% = 531 
        60 - 79% = 859 
        80 - 99% = 2199 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.44, total records: 400 
    Average version length: 23.13, total versions: 235311, max versions: 618 
    Average fragment length: 2.04, total fragments: 48, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1296 
    Data pages: 1296, average fill: 91% 
    Primary pages: 8, secondary pages: 1288, swept pages: 0 
    Empty pages: 1, full pages: 1294 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1294 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 8.48, total records: 102756 
    Average version length: 68.28, total versions: 90005, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 10.38 
    Pointer pages: 7, data page slots: 2040 
    Data pages: 1816, average fill: 70% 
    Primary pages: 1815, secondary pages: 1, swept pages: 0 
    Empty pages: 179, full pages: 1220 
    Fill distribution: 
     0 - 19% = 239 
    20 - 39% = 104 
    40 - 59% = 136 
    60 - 79% = 273 
    80 - 99% = 1064 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1706850, depth: 3, leaf buckets: 336, nodes: 102756 
    Average node length: 13.08, total dup: 7491, max dup: 2 
    Average key length: 10.60, compression ratio: 2.55 
    Average prefix length: 19.33, average data length: 7.67 
    Clustering factor: 74362, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 73 
        40 - 59% = 197 
        60 - 79% = 59 
        80 - 99% = 6 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 18123, max versions: 966 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 81% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 57 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 5.14, total records: 1657 
    Average version length: 43.08, total versions: 1466, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 11.28 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 50% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 7, full pages: 11 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90491, depth: 2, leaf buckets: 2, nodes: 1657 
    Average node length: 4.40, total dup: 1559, max dup: 161 
    Average key length: 2.63, compression ratio: 7.23 
    Average prefix length: 18.43, average data length: 0.57 
    Clustering factor: 849, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.92, total records: 75 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.16 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 75 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.38, total records: 790551 
    Average version length: 25.62, total versions: 55469, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 5, data page slots: 8112 
    Data pages: 8112, average fill: 68% 
    Primary pages: 8084, secondary pages: 28, swept pages: 2162 
    Empty pages: 58, full pages: 6226 
    Fill distribution: 
     0 - 19% = 164 
    20 - 39% = 222 
    40 - 59% = 389 
    60 - 79% = 7134 
    80 - 99% = 203 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 889, nodes: 790551 
    Average node length: 4.87, total dup: 790502, max dup: 149439 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 87010, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 146 
        40 - 59% = 517 
        60 - 79% = 165 
        80 - 99% = 60 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 916, nodes: 790551 
    Average node length: 5.87, total dup: 704072, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 156327, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 103 
        40 - 59% = 380 
        60 - 79% = 117 
        80 - 99% = 313 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 956, nodes: 790551 
    Average node length: 5.87, total dup: 704072, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158255, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 202 
        40 - 59% = 340 
        60 - 79% = 99 
        80 - 99% = 315 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1132, nodes: 790551 
    Average node length: 5.95, total dup: 704072, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 150899, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 264 
        40 - 59% = 592 
        60 - 79% = 191 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.84, total records: 5455 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.26, total fragments: 53, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 72, secondary pages: 16, swept pages: 55 
    Empty pages: 6, full pages: 66 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5455 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.44, average data length: 1.54 
    Clustering factor: 5103, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5455 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 142, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 79178 
    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: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 763 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 763 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35806, depth: 2, leaf buckets: 101, nodes: 79178 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3281, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.11, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 146.45, total records: 162735 
    Average version length: 152.76, total versions: 4666, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 4560 
    Data pages: 3936, average fill: 85% 
    Primary pages: 3936, secondary pages: 0, swept pages: 1 
    Empty pages: 77, full pages: 3839 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3839 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.72, total records: 179067 
    Average version length: 136.58, total versions: 322, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 7, data page slots: 4880 
    Data pages: 4328, average fill: 85% 
    Primary pages: 4328, secondary pages: 0, swept pages: 3 
    Empty pages: 75, full pages: 4235 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 8 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4234 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 142.71, total records: 172721 
    Average version length: 154.52, total versions: 9407, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 6, data page slots: 5400 
    Data pages: 4168, average fill: 86% 
    Primary pages: 4168, secondary pages: 0, swept pages: 1 
    Empty pages: 65, full pages: 4088 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 4089 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.46, total records: 164080 
    Average version length: 152.00, total versions: 3753, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 4440 
    Data pages: 3936, average fill: 86% 
    Primary pages: 3935, secondary pages: 1, swept pages: 6 
    Empty pages: 41, full pages: 3878 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 3877 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 123.42, total records: 179413 
    Average version length: 154.76, total versions: 32618, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.74 
    Pointer pages: 7, data page slots: 5144 
    Data pages: 4368, average fill: 86% 
    Primary pages: 4367, secondary pages: 1, swept pages: 3 
    Empty pages: 87, full pages: 4251 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 7 
    40 - 59% = 10 
    60 - 79% = 6 
    80 - 99% = 4253 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.48, total records: 184782 
    Average version length: 151.00, total versions: 3338, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 8, data page slots: 5992 
    Data pages: 4432, average fill: 86% 
    Primary pages: 4432, secondary pages: 0, swept pages: 3 
    Empty pages: 35, full pages: 4375 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 4374 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 145.95, total records: 165258 
    Average version length: 152.13, total versions: 5483, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 7, data page slots: 5016 
    Data pages: 3976, average fill: 86% 
    Primary pages: 3976, secondary pages: 0, swept pages: 2 
    Empty pages: 48, full pages: 3902 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 3901 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 149.60, total records: 168281 
    Average version length: 149.85, total versions: 1449, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 7, data page slots: 4616 
    Data pages: 4040, average fill: 86% 
    Primary pages: 4040, secondary pages: 0, swept pages: 5 
    Empty pages: 47, full pages: 3978 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3977 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 140.77, total records: 168076 
    Average version length: 154.90, total versions: 10883, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.05 
    Pointer pages: 7, data page slots: 5432 
    Data pages: 4024, average fill: 86% 
    Primary pages: 4024, secondary pages: 0, swept pages: 3 
    Empty pages: 39, full pages: 3971 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 3971 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 129.89, total records: 197725 
    Average version length: 154.81, total versions: 27607, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.06 
    Pointer pages: 9, data page slots: 5560 
    Data pages: 4768, average fill: 87% 
    Primary pages: 4768, secondary pages: 0, swept pages: 5 
    Empty pages: 60, full pages: 4689 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 9 
    80 - 99% = 4688 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 52.05, total records: 2103497 
    Average version length: 52.99, total versions: 27689, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25568 
    Data pages: 25568, average fill: 71% 
    Primary pages: 25568, secondary pages: 0, swept pages: 11587 
    Empty pages: 271, full pages: 20375 
    Fill distribution: 
     0 - 19% = 507 
    20 - 39% = 469 
    40 - 59% = 1205 
    60 - 79% = 23155 
    80 - 99% = 232 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2588, nodes: 2103497 
    Average node length: 5.44, total dup: 1962596, max dup: 1312 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181850, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 273 
        40 - 59% = 1731 
        60 - 79% = 282 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2759, nodes: 2103497 
    Average node length: 5.69, total dup: 1887978, max dup: 71 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375834, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 2415 
        60 - 79% = 311 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2154, nodes: 2103497 
    Average node length: 4.96, total dup: 2103397, max dup: 28164 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179677, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 194 
        40 - 59% = 1191 
        60 - 79% = 365 
        80 - 99% = 403 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 47.30, total records: 143780 
    Average version length: 69.16, total versions: 45549, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.66 
    Pointer pages: 3, data page slots: 4336 
    Data pages: 3432, average fill: 48% 
    Primary pages: 3432, secondary pages: 0, swept pages: 776 
    Empty pages: 789, full pages: 1506 
    Fill distribution: 
     0 - 19% = 1098 
    20 - 39% = 315 
    40 - 59% = 323 
    60 - 79% = 695 
    80 - 99% = 1001 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 99790, depth: 3, leaf buckets: 247, nodes: 143780 
    Average node length: 6.41, total dup: 124994, max dup: 14 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 24654, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 86 
        40 - 59% = 119 
        60 - 79% = 37 
        80 - 99% = 4 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.12, total records: 7003691 
    Average version length: 68.79, total versions: 288456, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 64, data page slots: 103112 
    Data pages: 103112, average fill: 73% 
    Primary pages: 103112, secondary pages: 0, swept pages: 39281 
    Empty pages: 46, full pages: 67584 
    Fill distribution: 
     0 - 19% = 195 
    20 - 39% = 871 
    40 - 59% = 8145 
    60 - 79% = 90708 
    80 - 99% = 3193 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10693, nodes: 7003691 
    Average node length: 6.51, total dup: 6056335, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1553932, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1675 
        40 - 59% = 6004 
        60 - 79% = 2632 
        80 - 99% = 377 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8549, nodes: 7003691 
    Average node length: 5.40, total dup: 6723067, max dup: 161 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1361268, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1276 
        40 - 59% = 4832 
        60 - 79% = 1400 
        80 - 99% = 1031 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8623, nodes: 7003691 
    Average node length: 5.40, total dup: 6723067, max dup: 161 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1363881, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1368 
        40 - 59% = 4848 
        60 - 79% = 1387 
        80 - 99% = 1012 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.64, total records: 11954843 
    Average version length: 68.71, total versions: 228048, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 104, data page slots: 168936 
    Data pages: 168936, average fill: 75% 
    Primary pages: 168936, secondary pages: 0, swept pages: 95450 
    Empty pages: 5, full pages: 140501 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 519 
    40 - 59% = 5762 
    60 - 79% = 159470 
    80 - 99% = 3133 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18410, nodes: 11954843 
    Average node length: 6.58, total dup: 10422144, max dup: 49 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2354648, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2379 
        40 - 59% = 11104 
        60 - 79% = 4248 
        80 - 99% = 656 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 49.06, total records: 1448052 
    Average version length: 69.07, total versions: 420854, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.57 
    Pointer pages: 27, data page slots: 41880 
    Data pages: 29752, average fill: 55% 
    Primary pages: 29751, secondary pages: 1, swept pages: 12583 
    Empty pages: 4588, full pages: 15285 
    Fill distribution: 
     0 - 19% = 6813 
    20 - 39% = 2898 
    40 - 59% = 2768 
    60 - 79% = 11101 
    80 - 99% = 6172 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2245, nodes: 1448052 
    Average node length: 5.53, total dup: 1389069, max dup: 99 
    Average key length: 2.58, compression ratio: 16.31 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 96926, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 958 
        40 - 59% = 984 
        60 - 79% = 258 
        80 - 99% = 38 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 42.47, total records: 1011013 
    Average version length: 69.14, total versions: 388878, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.97 
    Pointer pages: 22, data page slots: 34976 
    Data pages: 28656, average fill: 41% 
    Primary pages: 28656, secondary pages: 0, swept pages: 9289 
    Empty pages: 7149, full pages: 9443 
    Fill distribution: 
     0 - 19% = 11200 
    20 - 39% = 3639 
    40 - 59% = 2958 
    60 - 79% = 3831 
    80 - 99% = 7028 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1510, nodes: 1011013 
    Average node length: 5.80, total dup: 942942, max dup: 99 
    Average key length: 2.88, compression ratio: 14.60 
    Average prefix length: 41.19, average data length: 0.81 
    Clustering factor: 135940, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 472 
        40 - 59% = 720 
        60 - 79% = 274 
        80 - 99% = 42 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.68, total records: 9031990 
    Average version length: 68.94, total versions: 290579, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 88, data page slots: 143520 
    Data pages: 143496, average fill: 67% 
    Primary pages: 143496, secondary pages: 0, swept pages: 71159 
    Empty pages: 383, full pages: 72977 
    Fill distribution: 
     0 - 19% = 1473 
    20 - 39% = 7681 
    40 - 59% = 25709 
    60 - 79% = 105052 
    80 - 99% = 3581 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13499, nodes: 9031990 
    Average node length: 6.68, total dup: 7491028, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1916793, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1424 
        40 - 59% = 7180 
        60 - 79% = 4372 
        80 - 99% = 521 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.51, total records: 21123502 
    Average version length: 83.00, total versions: 7068, 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: 318472 
    Data pages: 318472, average fill: 81% 
    Primary pages: 318472, secondary pages: 0, swept pages: 12755 
    Empty pages: 51, full pages: 317332 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 53 
    40 - 59% = 145 
    60 - 79% = 27699 
    80 - 99% = 290494 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19347, nodes: 21123502 
    Average node length: 5.72, total dup: 20642851, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277592, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8123 
        60 - 79% = 519 
        80 - 99% = 10701 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17137, nodes: 21123502 
    Average node length: 6.31, total dup: 18564097, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913808, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 762 
        60 - 79% = 280 
        80 - 99% = 16091 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21132, nodes: 21123502 
    Average node length: 6.35, total dup: 18481934, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571321, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 8400 
        60 - 79% = 592 
        80 - 99% = 12135 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 15994, nodes: 21123502 
    Average node length: 5.56, total dup: 21123402, max dup: 226421 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942573, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 2726 
        60 - 79% = 357 
        80 - 99% = 12898 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.86, total records: 9496473 
    Average version length: 82.62, total versions: 294348, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 105, data page slots: 170432 
    Data pages: 170400, average fill: 69% 
    Primary pages: 170400, secondary pages: 0, swept pages: 91020 
    Empty pages: 1013, full pages: 94113 
    Fill distribution: 
     0 - 19% = 2695 
    20 - 39% = 9233 
    40 - 59% = 28481 
    60 - 79% = 73711 
    80 - 99% = 56280 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11372, nodes: 9496473 
    Average node length: 5.37, total dup: 9189826, max dup: 195 
    Average key length: 2.24, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2065935, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 104 
        40 - 59% = 8766 
        60 - 79% = 2460 
        80 - 99% = 40 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13193, nodes: 9496473 
    Average node length: 6.24, total dup: 7870944, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1413536, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 3881 
        40 - 59% = 4125 
        60 - 79% = 2567 
        80 - 99% = 2495 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12707, nodes: 9496473 
    Average node length: 5.99, total dup: 8234297, max dup: 44 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2255807, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 131 
        40 - 59% = 9798 
        60 - 79% = 2719 
        80 - 99% = 57 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9978, nodes: 9496473 
    Average node length: 5.14, total dup: 9496373, max dup: 154363 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1445057, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1341 
        40 - 59% = 4883 
        60 - 79% = 1656 
        80 - 99% = 2064 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.67, total records: 11186329 
    Average version length: 82.59, total versions: 221685, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 118, data page slots: 191560 
    Data pages: 190032, average fill: 72% 
    Primary pages: 190032, secondary pages: 0, swept pages: 77881 
    Empty pages: 3346, full pages: 138818 
    Fill distribution: 
     0 - 19% = 5507 
    20 - 39% = 7940 
    40 - 59% = 18802 
    60 - 79% = 45710 
    80 - 99% = 112073 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13126, nodes: 11186329 
    Average node length: 5.29, total dup: 11076551, max dup: 616 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2334478, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 124 
        40 - 59% = 9654 
        60 - 79% = 3236 
        80 - 99% = 111 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10354, nodes: 11186329 
    Average node length: 5.49, total dup: 10697582, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 706114, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 880 
        40 - 59% = 2543 
        60 - 79% = 1818 
        80 - 99% = 4963 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15014, nodes: 11186329 
    Average node length: 6.02, total dup: 9756109, max dup: 64 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2350791, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 144 
        40 - 59% = 11268 
        60 - 79% = 3467 
        80 - 99% = 133 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10651, nodes: 11186329 
    Average node length: 5.21, total dup: 11186229, max dup: 186941 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 694784, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 903 
        40 - 59% = 4667 
        60 - 79% = 1454 
        80 - 99% = 3536 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 80.32, total records: 9595501 
    Average version length: 82.90, total versions: 280190, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 103, data page slots: 168040 
    Data pages: 168016, average fill: 71% 
    Primary pages: 168016, secondary pages: 0, swept pages: 91091 
    Empty pages: 463, full pages: 92502 
    Fill distribution: 
     0 - 19% = 1136 
    20 - 39% = 4913 
    40 - 59% = 24676 
    60 - 79% = 84373 
    80 - 99% = 52918 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11775, nodes: 9595501 
    Average node length: 5.19, total dup: 9566284, max dup: 2107 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1890028, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1566 
        40 - 59% = 7950 
        60 - 79% = 1686 
        80 - 99% = 542 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13347, nodes: 9595501 
    Average node length: 6.26, total dup: 7952838, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1410099, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 3935 
        40 - 59% = 4037 
        60 - 79% = 2654 
        80 - 99% = 2572 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12405, nodes: 9595501 
    Average node length: 5.45, total dup: 9161971, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2022896, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1524 
        40 - 59% = 8804 
        60 - 79% = 1524 
        80 - 99% = 520 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 9970, nodes: 9595501 
    Average node length: 5.16, total dup: 9595401, max dup: 156018 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1488628, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1245 
        40 - 59% = 4690 
        60 - 79% = 1830 
        80 - 99% = 2169 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.67, total records: 578141 
    Average version length: 68.79, total versions: 4241, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 75% 
    Primary pages: 8016, secondary pages: 0, swept pages: 4111 
    Empty pages: 2, full pages: 6728 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 7 
    40 - 59% = 176 
    60 - 79% = 7760 
    80 - 99% = 71 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46562, depth: 3, leaf buckets: 741, nodes: 578141 
    Average node length: 5.95, total dup: 492110, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100617, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 530 
        60 - 79% = 103 
        80 - 99% = 83 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36746, depth: 3, leaf buckets: 760, nodes: 578141 
    Average node length: 6.15, total dup: 474286, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100664, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 23 
        40 - 59% = 540 
        60 - 79% = 99 
        80 - 99% = 97 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 582, nodes: 578141 
    Average node length: 4.86, total dup: 578041, max dup: 9220 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89358, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 356 
        60 - 79% = 84 
        80 - 99% = 112 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar 26 22:12:18 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7718254 54582 1 0.0000 0.0000
DOC_LIST 2228780 56399 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 235311 618 58800.0000 0.0000
INVNT_TURNOVER_LOG 102756 90005 1 0.0000 0.0000
MONEY_SALDO 49 18123 966 36900.0000 0.0000
MONEY_TURNOVER_LOG 1657 1466 1 0.0000 0.0000
PDISTR 790551 55469 4 0.0000 0.0000
PERF_SPLIT_0 162735 4666 1 0.0000 0.0000
PERF_SPLIT_1 179067 322 1 0.0000 0.0000
PERF_SPLIT_2 172721 9407 1 0.0000 0.0000
PERF_SPLIT_3 164080 3753 1 0.0000 0.0000
PERF_SPLIT_4 179413 32618 1 0.0000 0.0000
PERF_SPLIT_5 184782 3338 1 0.0000 0.0000
PERF_SPLIT_6 165258 5483 1 0.0000 0.0000
PERF_SPLIT_7 168281 1449 1 0.0000 0.0000
PERF_SPLIT_8 168076 10883 1 0.0000 0.0000
PERF_SPLIT_9 197725 27607 1 0.0000 0.0000
PSTORNED 2103497 27689 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 143780 45549 1 0.0000 0.0000
XQD_1000_3300 7003691 288456 1 0.0000 0.0000
XQD_1200_2000 11954843 228048 1 0.0000 0.0000
XQD_2000_3300 1448052 420854 1 0.0000 0.0000
XQD_2100_3300 1011013 388878 1 0.0000 0.0000
XQD_3300_3400 9031990 290579 1 0.0000 0.0000
XQS_1000_1200 21123502 7068 1 0.0000 0.0000
XQS_1000_3300 9496473 294348 1 0.0000 0.0000
XQS_1200_2000 11186329 221685 1 0.0000 0.0000
XQS_2100_3300 9595501 280190 1 0.0000 0.0000
XQS_3300_3400 578141 4241 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 ---
:400: 
:401: mscs-test-161.budzdorov.ru    Tue Mar 26 22:09:42 2024
:402:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:403: 
:404: 
:405: mscs-test-161.budzdorov.ru    Tue Mar 26 22:09:47 2024
:406:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:407: 
:408: 
:409: mscs-test-161.budzdorov.ru    Tue Mar 26 22:09:50 2024
:410:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:411: 
--- end of diff output ---

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

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