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

Server and database settinfs 


SERVER_MODE                     SuperServer 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-17 19:09:43
DTS_END                         2024-03-17 19:09:43.3360
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44450
TRN_ID                          174267
ATT_ID                          549
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: 9178.57 25089 917857
customer order: creation 173.41 395 17341
customer order: refuse 14.68 387 1468
order to supplier: creation 45.91 1327 4591
order to supplier: removal 3.61 109030 361
invoice (draft): creation 46.08 3607 4608
invoice (draft): removal 50.61 831 5061
invoice accept: apply 40.78 22328 4078
invoice accept: cancel 45.14 881 4514
customer reserve: creation 4002.96 210 400296
customer reserve: removal 4466.60 69 446660
realization accept: apply 83.35 200 8335
realization accept: cancel 73.16 134 7316
payment from customer: creation 60.22 117 6022
payment from customer: removal 5.77 102 577
payment to supplier: creation 49.79 137 4979
payment to supplier: removal 3.29 97 329
service: total inventory turnovers 4.98 935 498
service: total monetary turnovers 7.24 30 724
service: aggregate perf. data 0.96 18114 96
service: refresh index statistics 0.03 342856 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-03-2024 19:10:42 to 17-03-2024 19:10:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4199
TEST_TIME 2 4889
TEST_TIME 3 4442
TEST_TIME 4 4309
TEST_TIME 5 4290
TEST_TIME 6 4415
TEST_TIME 7 4383
TEST_TIME 8 4671
TEST_TIME 9 4526
TEST_TIME 10 4784
TEST_TIME 11 5050
TEST_TIME 12 5253
TEST_TIME 13 5600
TEST_TIME 14 5498
TEST_TIME 15 5781
TEST_TIME 16 5830
TEST_TIME 17 6201
TEST_TIME 18 6282
TEST_TIME 19 6375
TEST_TIME 20 6776
TEST_TIME 21 7038
TEST_TIME 22 7271
TEST_TIME 23 8045
TEST_TIME 24 8058
TEST_TIME 25 8053
TEST_TIME 26 8296
TEST_TIME 27 8768
TEST_TIME 28 8837
TEST_TIME 29 9497
TEST_TIME 30 9341
TEST_TIME 31 9393
TEST_TIME 32 9204
TEST_TIME 33 9128
TEST_TIME 34 8999
TEST_TIME 35 9064
TEST_TIME 36 9032
TEST_TIME 37 8857
TEST_TIME 38 8817
TEST_TIME 39 8833
TEST_TIME 40 8759
TEST_TIME 41 8824
TEST_TIME 42 8864
TEST_TIME 43 8833
TEST_TIME 44 8931
TEST_TIME 45 8877
TEST_TIME 46 8914
TEST_TIME 47 8948
TEST_TIME 48 8946
TEST_TIME 49 9080
TEST_TIME 50 9072
TEST_TIME 51 9140
TEST_TIME 52 9073
TEST_TIME 53 9186
TEST_TIME 54 9239
TEST_TIME 55 9169
TEST_TIME 56 9209
TEST_TIME 57 9306
TEST_TIME 58 9261
TEST_TIME 59 9204
TEST_TIME 60 9165
TEST_TIME 61 9079
TEST_TIME 62 9064
TEST_TIME 63 9106
TEST_TIME 64 9060
TEST_TIME 65 9000
TEST_TIME 66 8972
TEST_TIME 67 8987
TEST_TIME 68 8909
TEST_TIME 69 8955
TEST_TIME 70 8997
TEST_TIME 71 8979
TEST_TIME 72 8974
TEST_TIME 73 8995
TEST_TIME 74 9014
TEST_TIME 75 9153
TEST_TIME 76 9091
TEST_TIME 77 9172
TEST_TIME 78 9197
TEST_TIME 79 9184
TEST_TIME 80 9245
TEST_TIME 81 9275
TEST_TIME 82 9284
TEST_TIME 83 9307
TEST_TIME 84 9266
TEST_TIME 85 9200
TEST_TIME 86 9196
TEST_TIME 87 9187
TEST_TIME 88 9161
TEST_TIME 89 9196
TEST_TIME 90 9220
TEST_TIME 91 9180
TEST_TIME 92 9154
TEST_TIME 93 9081
TEST_TIME 94 9092
TEST_TIME 95 9114
TEST_TIME 96 9101
TEST_TIME 97 9158
TEST_TIME 98 9159
TEST_TIME 99 9193
TEST_TIME 100 9190

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-03-2024 19:10:46 to 17-03-2024 19:10:49.

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 1283474 1283474 0 0.00 0 22947 7 0 0
doc_list_biud 1283465 1283465 0 0.00 0 85541 30 0 0
sp_add_invoice_to_stock 4195 4078 117 2.78 27 201682 22329 0 117
sp_cancel_adding_invoice 4514 4514 0 0.00 4 45882 882 0 0
sp_cancel_client_order 1468 1468 0 0.00 4 7312 388 0 0
sp_cancel_customer_reserve 446660 446660 0 0.00 0 25721 70 0 0
sp_cancel_pay_from_customer 577 577 0 0.00 3 9068 103 0 0
sp_cancel_pay_to_supplier 329 329 0 0.00 2 3632 97 0 0
sp_cancel_supplier_invoice 5075 5061 14 0.27 1 85576 832 0 14
sp_cancel_supplier_order 361 361 0 0.00 8 1108231 109030 0 0
sp_cancel_write_off 7316 7316 0 0.00 1 22949 134 0 0
sp_client_order 17341 17341 0 0.00 3 36202 396 0 0
sp_customer_reserve 400296 400296 0 0.00 0 35929 210 0 0
sp_fill_shopping_cart 26530 26530 0 0.00 1 16709 41 0 0
sp_fill_shopping_cart_clo_res 400281 400281 0 0.00 0 17208 16 0 0
sp_get_clo_for_invoice 4063 4063 0 0.00 0 18187 275 0 0
sp_kill_cost_storno 12736 12736 0 0.00 0 22946 75 0 0
sp_kill_qstorno_ret_qs2qd 906058 906058 0 0.00 0 85533 37 0 0
sp_kill_qty_storno 477778 477778 0 0.00 0 85539 80 0 0
sp_lock_selected_doc 17287 17287 0 0.00 0 7136 7 0 0
sp_make_cost_storno 23399 23399 0 0.00 0 13825 68 0 0
sp_multiply_rows_for_pdistr 23399 23399 0 0.00 0 9591 33 0 0
sp_multiply_rows_for_qdistr 17340 17340 0 0.00 0 36192 177 0 0
sp_pay_from_customer 6022 6022 0 0.00 4 12248 117 0 0
sp_pay_to_supplier 4979 4979 0 0.00 5 11295 138 0 0
sp_payment_common 11001 11001 0 0.00 1 10254 22 0 0
sp_qd_handle_on_cancel_clo 1468 1468 0 0.00 0 7267 354 0 0
sp_qd_handle_on_invoice_upd_sts 8577 8577 0 0.00 0 18523 350 0 0
sp_qd_handle_on_reserve_upd_sts 8335 8335 0 0.00 0 16623 57 0 0
sp_reserve_write_off 8335 8335 0 0.00 6 18738 201 0 0
sp_supplier_invoice 4608 4608 0 0.00 6 82924 3607 0 0
sp_supplier_order 4591 4591 0 0.00 5 25174 1328 0 0
srv_aggregate_perf_data 96 96 0 0.00 1913 316917 18114 0 0
srv_fill_mon_cache_memory 58 58 0 0.00 1311 114897 36238 0 0
srv_find_qd_qs_mism 874680 874680 0 0.00 0 14090 6 0 0
srv_make_invnt_saldo 498 498 0 0.00 32 29955 935 0 0
srv_make_money_saldo 724 724 0 0.00 1 937 30 0 0
srv_recalc_idx_stat 3 3 0 0.00 285076 385029 342857 0 0
t$perf-abend:sp_add_invoice_to_stock 117 117 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 4080 4080 0 0.00 0 12750 217 0 0
t$perf-norm:sp_cancel_adding_invoice 332 332 0 0.00 1 4910 125 0 0
t$perf-norm:sp_cancel_client_order 1468 1468 0 0.00 0 1528 12 0 0
t$perf-norm:sp_cancel_customer_reserve 566 566 0 0.00 0 2460 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 577 577 0 0.00 0 1449 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 329 329 0 0.00 0 3263 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 371 371 0 0.00 0 3063 22 0 0
t$perf-norm:sp_cancel_supplier_order 361 361 0 0.00 0 29582 1763 0 0
t$perf-norm:sp_cancel_write_off 885 885 0 0.00 0 1170 5 0 0
t$perf-norm:sp_client_order 17342 17342 0 0.00 0 4325 18 0 0
t$perf-norm:sp_customer_reserve 823 823 0 0.00 0 1614 7 0 0
t$perf-norm:sp_pay_from_customer 6022 6022 0 0.00 0 9103 13 0 0
t$perf-norm:sp_pay_to_supplier 4979 4979 0 0.00 0 5452 14 0 0
t$perf-norm:sp_reserve_write_off 8335 8335 0 0.00 0 14926 14 0 0
t$perf-norm:sp_supplier_invoice 4608 4608 0 0.00 0 5383 18 0 0
t$perf-norm:sp_supplier_order 4591 4591 0 0.00 0 7973 23 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 658 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 288 6 0 0
t$perf-norm:srv_make_invnt_saldo 498 498 0 0.00 0 1877 44 0 0
t$perf-norm:srv_make_money_saldo 724 724 0 0.00 0 970 20 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 23 9 0 0
v_add_invoice_to_stock 8360 8126 234 2.79 0 5393 20 0 234
v_all_customers 32514 32514 0 0.00 0 21 1 0 0
v_all_suppliers 26486 26486 0 0.00 0 20 1 0 0
v_all_wares 34678 34678 0 0.00 0 28 1 0 0
v_cancel_adding_invoice 664 664 0 0.00 0 1552 11 0 0
v_cancel_client_order 2936 2936 0 0.00 0 2815 6 0 0
v_cancel_customer_prepayment 1154 1154 0 0.00 0 1060 6 0 0
v_cancel_customer_reserve 1132 1132 0 0.00 0 1504 6 0 0
v_cancel_payment_to_supplier 658 658 0 0.00 0 3621 15 0 0
v_cancel_supplier_invoice 770 742 28 3.63 0 10931 35 0 28
v_cancel_supplier_order 722 722 0 0.00 0 2488 10 0 0
v_cancel_write_off 1770 1770 0 0.00 0 4068 17 0 0
v_max_id_clo_ord 4589 4589 0 0.00 0 1007 2 0 0
v_max_id_clo_res 823 823 0 0.00 0 3992 12 0 0
v_max_id_ord_sup 4602 4602 0 0.00 0 6795 7 0 0
v_max_non_paid_invoice 927 927 0 0.00 0 577 4 0 0
v_max_non_paid_realizn 2889 2889 0 0.00 0 5170 6 0 0
v_min_id_clo_ord 4589 4589 0 0.00 0 12070 14 0 0
v_min_id_clo_res 823 823 0 0.00 0 796 3 0 0
v_min_id_ord_sup 4602 4602 0 0.00 0 5551 14 0 0
v_min_non_paid_invoice 4979 4979 0 0.00 0 4163 11 0 0
v_min_non_paid_realizn 6022 6022 0 0.00 0 6513 19 0 0
v_our_firm 8430 8430 0 0.00 0 29 1 0 0
v_reserve_write_off 16670 16670 0 0.00 0 7962 8 0 0
x_lock_depdocs_on_canc_invoice 9204 9204 0 0.00 0 13285 149 0 0
x_lock_depdocs_on_canc_sup_ord 361 361 0 0.00 0 7360 386 0 0
x_make_qstorno_1000_1200 4591 4591 0 0.00 2 25160 1240 0 0
x_make_qstorno_1200_2000 4608 4608 0 0.00 3 82909 3453 0 0
x_make_qstorno_2100_3300 400296 400296 0 0.00 0 30172 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-03-2024 19:10:50 to 17-03-2024 19:10:54.

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
17:09:47 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:48 51559 8192000000 9927819616 10240954368 996424432 10.844 100 91 181 0 1024784528 5551520 22808576
17:12:48 22232 8192000000 9954076112 10278305792 1037883392 11.244 100 88 176 0 1069357904 9243568 22230944
17:14:23 12801 8192000000 9990766352 10328023040 1074574224 11.596 100 84 166 0 1105409536 10044256 20791056
17:15:48 12161 8192000000 10051836768 10403315712 1137719472 12.194 100 78 156 0 1167663408 11185232 18758704
17:17:05 8330 8192000000 10095201808 10454020096 1181344592 12.603 100 83 166 0 1213459408 13499424 18615392
17:18:17 2922 8192000000 10125914320 10501509120 1220845616 12.969 100 74 148 0 1249529872 12409376 16274880
17:19:23 1515 8192000000 10167169936 10546294784 1256201968 13.295 100 91 181 1 1290704176 14125600 20376608
17:20:26 1278 8192000000 10197983552 10581848064 1284161552 13.551 100 85 170 0 1317004768 14146624 18696592
17:21:29 952 8192000000 10220520704 10608635904 1303825648 13.730 100 86 172 1 1335563856 12871056 18867152
17:22:31 31415 8192000000 10197029776 10609500160 1308638864 13.774 100 36 70 0 1323036064 5995216 8401984
17:24:10 8331 8192000000 10206088368 10623434752 1319288288 13.870 100 20 38 1 1329357392 6163920 3905184
17:25:21 5813 8192000000 10215644048 10640494592 1333887584 14.002 100 12 22 1 1342656576 6010624 2758368
17:26:27 10481 8192000000 10222177696 10646716416 1339437792 14.052 100 14 29 0 1348390384 5981760 2970832
17:27:38 34893 8192000000 10234195136 10659995648 1330495536 13.972 99 32 64 0 1343445424 5585984 7363904
17:29:16 6104 8192000000 10237698464 10661797888 1344642240 14.099 100 35 70 0 1360963344 8444592 7876512
17:30:30 10233 8192000000 10250518784 10662510592 1335175088 14.014 99 49 97 1 1356236080 9489072 11571920
17:31:45 32271 8192000000 10238422656 10654240768 1317188112 13.851 98 43 86 0 1336521360 9142496 10190752
17:33:25 16060 8192000000 10234998896 10653806592 1309247072 13.779 97 42 82 1 1327874864 8944848 9682944
17:35:29 14267 8192000000 10256678480 10667974656 1334241024 14.005 98 44 89 0 1356248768 11700160 10307584
17:36:51 19512 8192000000 10270915952 10684276736 1331010192 13.976 98 40 79 0 1357610656 17390192 9210272
17:38:16 11478 8192000000 10268382000 10675945472 1339260224 14.051 99 55 110 0 1370139744 18007808 12871712
17:39:45 18455 8192000000 10249049568 10658611200 1315852048 13.839 98 40 78 2 1348051728 22757504 9442176
17:41:15 11783 8192000000 10258284832 10668953600 1330200480 13.969 99 36 73 0 1363706896 23990096 9516320
17:42:33 3795 8192000000 10274642704 10677063680 1341274160 14.069 100 56 110 0 1380910704 26257056 13379488
17:43:42 4870 8192000000 10271326608 10671030272 1329692416 13.964 99 65 129 0 1372027520 27109008 15226096
17:44:57 1578 8192000000 10292509792 10687860736 1347406032 14.124 100 82 158 0 1395476016 29149936 18920048
17:46:04 2692 8192000000 10307900720 10711560192 1361756288 14.253 100 72 143 1 1412835536 33373856 17705392
17:47:13 1311 8192000000 10303629920 10702069760 1354601216 14.189 100 77 154 0 1406690160 33323296 18765648
17:48:22 10406 8192000000 10313557760 10718883840 1365431904 14.286 100 68 136 0 1418177296 35817456 16927936
17:49:36 3431 8192000000 10330246704 10738728960 1372887088 14.353 100 73 147 1 1433096816 41100688 19109040
17:50:50 2963 8192000000 10343522752 10751549440 1381944304 14.434 100 77 153 0 1441276016 39847008 19484704
17:51:58 18025 8192000000 10339743008 10768777216 1390731136 14.512 100 40 76 0 1446373712 44592304 11050272
17:53:20 15874 8192000000 10322871520 10756169728 1376657344 14.387 99 25 50 0 1421763408 38164512 6941552
17:54:50 6734 8192000000 10329704592 10757046272 1391554416 14.520 100 44 89 0 1436889376 34356688 10978272
17:56:03 26581 8192000000 10323090320 10768805888 1386496672 14.475 100 25 50 0 1427945328 34296128 7152528
17:57:41 46551 8192000000 10298277024 10773848064 1369919936 14.326 99 11 22 0 1408273792 35304992 3048864
17:59:30 18765 8192000000 10312415392 10742276096 1390043008 14.506 100 63 124 0 1411593232 7427888 14122336
18:00:50 49556 8192000000 10313058560 10752278528 1392362480 14.527 100 32 62 0 1406796720 8050992 6383248
18:02:40 94173 8192000000 10297388960 10748702720 1382717360 14.441 99 33 66 1 1398803072 8366864 7718848
18:05:25 42575 8192000000 10295715312 10756501504 1397937040 14.577 100 8 16 0 1410536736 10691296 1908400
18:07:13 4451 8192000000 10320268944 10767224832 1406885280 14.656 100 62 124 0 1431434480 10212416 14336784
18:08:20 16693 8192000000 10323640800 10770841600 1409486064 14.679 100 31 62 0 1432751248 15594704 7670480
18:09:38 32165 8192000000 10310536976 10767589376 1402321280 14.616 99 22 44 0 1430530336 22527920 5681136
18:11:34 34429 8192000000 10324218960 10790604800 1413623744 14.716 100 19 38 0 1443904944 25964576 4316624
18:13:09 38655 8192000000 10316927760 10775060480 1402750080 14.619 100 19 38 0 1430429184 22746208 4932896
18:15:33 36228 8192000000 10308424112 10753163264 1359164352 14.230 97 28 55 1 1376313648 10712672 6436624
18:17:14 81398 8192000000 10290307312 10744901632 1326676576 13.937 95 16 32 1 1344189888 13606176 3907136
18:20:00 10301 8192000000 10288515456 10725765120 1358448336 14.223 99 58 116 3 1381197600 8633008 14116256
18:21:20 67263 8192000000 10267674128 10726793216 1333933120 14.003 98 15 30 1 1349629488 11972736 3723632
18:23:28 50191 8192000000 10267934352 10702340096 1316100720 13.841 97 32 60 0 1334852304 11000192 7751392
18:25:21 35661 8192000000 10261823616 10707316736 1323731424 13.910 98 23 45 0 1348266656 19238544 5296688
18:26:57 43706 8192000000 10234749216 10665594880 1263213120 13.359 95 27 54 1 1284211216 15302480 5695616
18:28:41 63449 8192000000 10223187488 10650284032 1284751408 13.556 98 43 86 1 1304738320 10697968 9288944
18:31:03 16531 8192000000 10245582704 10664288256 1316046224 13.841 99 64 128 0 1341221344 11383552 13791568
18:32:21 7750 8192000000 10238396736 10668609536 1324931648 13.921 100 42 82 0 1344660896 10272960 9456288
18:33:32 53131 8192000000 10211192016 10643566592 1298794192 13.684 98 32 63 2 1320540496 15056592 6689712
18:35:29 67841 8192000000 10252259216 10699571200 1342323888 14.078 100 28 56 1 1361362176 12633664 6404624
18:37:41 47213 8192000000 10260461536 10696617984 1326861088 13.939 99 21 42 1 1347075344 14562144 5652112
18:39:28 58072 8192000000 10265377680 10722811904 1355951536 14.201 100 11 22 0 1368772384 10582512 2238336
18:41:34 33766 8192000000 10270413408 10715897856 1360875632 14.245 100 18 36 0 1375657952 10697728 4084592
18:43:29 33656 8192000000 10292732368 10731868160 1376319232 14.384 100 33 66 0 1396587728 13082912 7185584
18:45:04 33442 8192000000 10313100336 10743087104 1386669328 14.476 100 41 77 0 1407211232 11593472 8948432
18:46:41 74154 8192000000 10305706192 10758447104 1366885056 14.299 98 14 28 0 1387834656 17752864 3196736
18:48:56 114897 8192000000 10313018192 10765234176 1384254928 14.455 99 20 38 0 1404474592 16273280 3946384
18:51:54 73176 8192000000 10317316752 10772467712 1404412256 14.634 100 28 54 0 1420333360 9825120 6095984
18:54:14 111619 8192000000 10323071040 10781786112 1381770128 14.432 98 19 38 0 1401889552 15682256 4437168
18:57:08 20399 8192000000 10308057904 10771255296 1401379696 14.607 100 19 38 0 1420112256 14633008 4099552
18:58:31 60544 8192000000 10305554016 10778882048 1408209312 14.668 100 18 36 0 1423296480 11359936 3727232
19:00:32 57492 8192000000 10293494272 10753658880 1378588800 14.404 98 10 20 0 1388275200 7321296 2365104
19:02:31 70999 8192000000 10295216352 10761060352 1390636448 14.512 99 13 26 0 1404914880 11108784 3169648
19:04:44 59560 8192000000 10287958512 10744209408 1350022592 14.148 97 16 33 0 1366691472 12627312 4041568
19:06:45 86149 8192000000 10284902272 10730967040 1319551440 13.873 95 14 28 0 1340987792 18451680 2984672
19:09:25 22792 8192000000 8983705792 9155141632 155267008 1.860 12 2 4 0 156820784 1300560 253216

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 17-03-2024 19:10:56 to 17-03-2024 19:11:10.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 117 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 17-03-2024 19:11:11 to 17-03-2024 19:11:13.

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          174644
MON$OLDEST_ACTIVE               174645
MON$OLDEST_SNAPSHOT             174645
MON$NEXT_TRANSACTION            174645
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                       1910432
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.33736 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33736 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33736 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33736 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 Sun Mar 17 19:11:14 2024 
 
Database header page information: 
    Flags            0 
    Generation        91146 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    174644 
    Oldest active        174645 
    Oldest snapshot        174645 
    Next transaction    174646 
    Sequence number        0 
    Next attachment ID    705 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.26, total records: 7750090 
    Average version length: 48.15, total versions: 101651, 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: 86760 
    Data pages: 86760, average fill: 71% 
    Primary pages: 86760, secondary pages: 0, swept pages: 16813 
    Empty pages: 7, full pages: 67168 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 205 
    40 - 59% = 2501 
    60 - 79% = 83984 
    80 - 99% = 37 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23310, nodes: 7750090 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1721992, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 334 
        20 - 39% = 1831 
        40 - 59% = 4202 
        60 - 79% = 2379 
        80 - 99% = 14564 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13535, nodes: 7750090 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1544314, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1601 
        40 - 59% = 2064 
        60 - 79% = 1099 
        80 - 99% = 8770 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8372, nodes: 7750090 
    Average node length: 6.62, total dup: 5795206, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1537241, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 146 
        20 - 39% = 990 
        40 - 59% = 1386 
        60 - 79% = 928 
        80 - 99% = 4922 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.06, total records: 2245397 
    Average version length: 34.66, total versions: 107116, max versions: 3 
    Average fragment length: 6.40, total fragments: 5, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28264 
    Data pages: 28264, average fill: 74% 
    Primary pages: 28258, secondary pages: 6, swept pages: 9314 
    Empty pages: 8, full pages: 21038 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 88 
    40 - 59% = 1451 
    60 - 79% = 25663 
    80 - 99% = 1040 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4560, nodes: 2245397 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 695022, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 933 
        40 - 59% = 856 
        60 - 79% = 712 
        80 - 99% = 2059 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2501, nodes: 2248272 
    Average node length: 4.97, total dup: 2247373, max dup: 17880 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1253655, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 283 
        40 - 59% = 1473 
        60 - 79% = 534 
        80 - 99% = 210 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2025, nodes: 2245397 
    Average node length: 4.97, total dup: 2245347, max dup: 130100 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056405, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 83 
        40 - 59% = 1061 
        60 - 79% = 55 
        80 - 99% = 824 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4356, nodes: 2245397 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 695022, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 613 
        40 - 59% = 617 
        60 - 79% = 815 
        80 - 99% = 2201 
 
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.32, total records: 400 
    Average version length: 22.89, total versions: 236415, max versions: 623 
    Average fragment length: 2.00, total fragments: 52, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1312 
    Data pages: 1312, average fill: 90% 
    Primary pages: 8, secondary pages: 1304, swept pages: 0 
    Empty pages: 1, full pages: 1310 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1310 
 
    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: 9.02, total records: 149532 
    Average version length: 68.29, total versions: 129779, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 9.75 
    Pointer pages: 7, data page slots: 2416 
    Data pages: 2080, average fill: 88% 
    Primary pages: 2079, secondary pages: 1, swept pages: 0 
    Empty pages: 15, full pages: 2018 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 14 
    40 - 59% = 17 
    60 - 79% = 197 
    80 - 99% = 1832 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705415, depth: 3, leaf buckets: 398, nodes: 149532 
    Average node length: 13.16, total dup: 11393, max dup: 3 
    Average key length: 10.55, compression ratio: 2.56 
    Average prefix length: 19.37, average data length: 7.63 
    Clustering factor: 106373, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 183 
        60 - 79% = 198 
        80 - 99% = 14 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 17854, max versions: 984 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 90% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 60 
 
    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.34, total records: 1514 
    Average version length: 43.54, total versions: 1332, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 10.86 
    Pointer pages: 1, data page slots: 40 
    Data pages: 29, average fill: 51% 
    Primary pages: 28, secondary pages: 1, swept pages: 1 
    Empty pages: 4, full pages: 11 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92887, depth: 2, leaf buckets: 2, nodes: 1514 
    Average node length: 4.54, total dup: 1416, max dup: 180 
    Average key length: 2.69, compression ratio: 7.07 
    Average prefix length: 18.38, average data length: 0.62 
    Clustering factor: 808, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        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: 97.07, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.80, total records: 812222 
    Average version length: 25.49, total versions: 79854, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 5, data page slots: 8128 
    Data pages: 8120, average fill: 70% 
    Primary pages: 8094, secondary pages: 26, swept pages: 1345 
    Empty pages: 87, full pages: 7528 
    Fill distribution: 
     0 - 19% = 167 
    20 - 39% = 92 
    40 - 59% = 116 
    60 - 79% = 7375 
    80 - 99% = 370 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 887, nodes: 812222 
    Average node length: 4.87, total dup: 812173, max dup: 146195 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90164, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 110 
        40 - 59% = 518 
        60 - 79% = 183 
        80 - 99% = 75 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 917, nodes: 812222 
    Average node length: 5.88, total dup: 723234, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161042, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 89 
        40 - 59% = 382 
        60 - 79% = 107 
        80 - 99% = 335 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 962, nodes: 812222 
    Average node length: 5.88, total dup: 723234, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163081, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 196 
        40 - 59% = 338 
        60 - 79% = 94 
        80 - 99% = 334 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1132, nodes: 812222 
    Average node length: 5.96, total dup: 723234, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155822, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 214 
        40 - 59% = 622 
        60 - 79% = 196 
        80 - 99% = 98 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.82, total records: 5475 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.93, total fragments: 98, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 136 
    Data pages: 112, average fill: 49% 
    Primary pages: 92, secondary pages: 20, swept pages: 51 
    Empty pages: 26, full pages: 64 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 67 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5475 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.07 
    Average prefix length: 34.47, average data length: 1.54 
    Clustering factor: 5219, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5475 
    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: 143, 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.11, total records: 79258 
    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% = 4 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 763 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34789, depth: 2, leaf buckets: 103, nodes: 79258 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3103, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 142.44, total records: 177253 
    Average version length: 153.73, total versions: 10130, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 5, data page slots: 5312 
    Data pages: 4240, average fill: 87% 
    Primary pages: 4240, secondary pages: 0, swept pages: 1 
    Empty pages: 29, full pages: 4199 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4199 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.98, total records: 161203 
    Average version length: 152.89, total versions: 5360, 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: 8, data page slots: 5840 
    Data pages: 3848, average fill: 86% 
    Primary pages: 3847, secondary pages: 1, swept pages: 5 
    Empty pages: 22, full pages: 3813 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3813 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 141.15, total records: 174862 
    Average version length: 154.56, total versions: 11572, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.02 
    Pointer pages: 6, data page slots: 4744 
    Data pages: 4184, average fill: 87% 
    Primary pages: 4183, secondary pages: 1, swept pages: 1 
    Empty pages: 27, full pages: 4148 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4149 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 140.26, total records: 177243 
    Average version length: 154.39, total versions: 12735, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.09 
    Pointer pages: 6, data page slots: 4832 
    Data pages: 4240, average fill: 87% 
    Primary pages: 4240, secondary pages: 0, swept pages: 5 
    Empty pages: 26, full pages: 4204 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 4204 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 132.75, total records: 187353 
    Average version length: 154.47, total versions: 23064, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.78 
    Pointer pages: 6, data page slots: 5120 
    Data pages: 4496, average fill: 87% 
    Primary pages: 4496, secondary pages: 0, swept pages: 6 
    Empty pages: 31, full pages: 4455 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 4455 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 147.91, total records: 160637 
    Average version length: 150.04, total versions: 2905, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.47 
    Pointer pages: 7, data page slots: 5288 
    Data pages: 3840, average fill: 86% 
    Primary pages: 3839, secondary pages: 1, swept pages: 7 
    Empty pages: 38, full pages: 3789 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 3789 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 142.67, total records: 173626 
    Average version length: 153.62, total versions: 9617, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 7, data page slots: 5304 
    Data pages: 4160, average fill: 86% 
    Primary pages: 4160, secondary pages: 0, swept pages: 7 
    Empty pages: 37, full pages: 4110 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 4109 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 145.90, total records: 175557 
    Average version length: 152.35, total versions: 6014, 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: 5104 
    Data pages: 4200, average fill: 86% 
    Primary pages: 4200, secondary pages: 0, swept pages: 3 
    Empty pages: 32, full pages: 4157 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 1 
    40 - 59% = 5 
    60 - 79% = 1 
    80 - 99% = 4157 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 147.93, total records: 159698 
    Average version length: 151.57, total versions: 3144, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 4280 
    Data pages: 3824, average fill: 86% 
    Primary pages: 3824, secondary pages: 0, swept pages: 7 
    Empty pages: 34, full pages: 3777 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3777 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 146.00, total records: 187318 
    Average version length: 152.18, total versions: 6563, 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: 4992 
    Data pages: 4512, average fill: 86% 
    Primary pages: 4512, secondary pages: 0, swept pages: 4 
    Empty pages: 58, full pages: 4441 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4440 
 
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: 51.52, total records: 2116090 
    Average version length: 52.88, total versions: 49382, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25560 
    Data pages: 25560, average fill: 71% 
    Primary pages: 25560, secondary pages: 0, swept pages: 9946 
    Empty pages: 274, full pages: 21384 
    Fill distribution: 
     0 - 19% = 521 
    20 - 39% = 433 
    40 - 59% = 968 
    60 - 79% = 23197 
    80 - 99% = 441 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2612, nodes: 2116090 
    Average node length: 5.44, total dup: 1974884, max dup: 2063 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182850, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 303 
        40 - 59% = 1723 
        60 - 79% = 295 
        80 - 99% = 288 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2116090 
    Average node length: 5.69, total dup: 1899958, max dup: 67 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 378170, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 2413 
        60 - 79% = 320 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2152, nodes: 2116090 
    Average node length: 4.96, total dup: 2115990, max dup: 27208 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180416, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 185 
        40 - 59% = 1169 
        60 - 79% = 373 
        80 - 99% = 421 
 
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: 37.60, total records: 158402 
    Average version length: 69.15, total versions: 72356, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.35 
    Pointer pages: 3, data page slots: 4040 
    Data pages: 3016, average fill: 61% 
    Primary pages: 3016, secondary pages: 0, swept pages: 383 
    Empty pages: 522, full pages: 2094 
    Fill distribution: 
     0 - 19% = 711 
    20 - 39% = 103 
    40 - 59% = 49 
    60 - 79% = 649 
    80 - 99% = 1504 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555601, depth: 3, leaf buckets: 229, nodes: 158402 
    Average node length: 6.43, total dup: 138011, max dup: 14 
    Average key length: 3.92, compression ratio: 10.71 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 27064, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 119 
        60 - 79% = 59 
        80 - 99% = 21 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.05, total records: 7316012 
    Average version length: 68.77, total versions: 520786, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 64, data page slots: 103928 
    Data pages: 103928, average fill: 75% 
    Primary pages: 103928, secondary pages: 0, swept pages: 19674 
    Empty pages: 16, full pages: 89240 
    Fill distribution: 
     0 - 19% = 120 
    20 - 39% = 874 
    40 - 59% = 4882 
    60 - 79% = 87699 
    80 - 99% = 10353 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10664, nodes: 7316012 
    Average node length: 6.51, total dup: 6327405, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1631607, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1323 
        40 - 59% = 5631 
        60 - 79% = 2929 
        80 - 99% = 775 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8570, nodes: 7316012 
    Average node length: 5.39, total dup: 7027058, max dup: 160 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1419331, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 986 
        40 - 59% = 4668 
        60 - 79% = 1703 
        80 - 99% = 1205 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8637, nodes: 7316012 
    Average node length: 5.39, total dup: 7027058, max dup: 160 
    Average key length: 2.40, compression ratio: 7.07 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1421766, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1037 
        40 - 59% = 4731 
        60 - 79% = 1654 
        80 - 99% = 1208 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.76, total records: 12256130 
    Average version length: 68.70, total versions: 388952, 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: 104, data page slots: 168520 
    Data pages: 168520, average fill: 77% 
    Primary pages: 168520, secondary pages: 0, swept pages: 67962 
    Empty pages: 1, full pages: 165366 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 202 
    40 - 59% = 998 
    60 - 79% = 158322 
    80 - 99% = 8972 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18339, nodes: 12256130 
    Average node length: 6.59, total dup: 10680260, max dup: 61 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2400077, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 2065 
        40 - 59% = 10510 
        60 - 79% = 4716 
        80 - 99% = 1027 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 39.24, total records: 1768283 
    Average version length: 69.11, total versions: 764740, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.21 
    Pointer pages: 27, data page slots: 43160 
    Data pages: 29384, average fill: 69% 
    Primary pages: 29384, secondary pages: 0, swept pages: 5620 
    Empty pages: 2087, full pages: 21732 
    Fill distribution: 
     0 - 19% = 3701 
    20 - 39% = 1472 
    40 - 59% = 1304 
    60 - 79% = 10196 
    80 - 99% = 12711 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2225, nodes: 1768283 
    Average node length: 5.50, total dup: 1697541, max dup: 99 
    Average key length: 2.55, compression ratio: 16.50 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 120402, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 376 
        40 - 59% = 1101 
        60 - 79% = 556 
        80 - 99% = 183 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 35.38, total records: 1160452 
    Average version length: 69.13, total versions: 565542, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.56 
    Pointer pages: 21, data page slots: 34064 
    Data pages: 28568, average fill: 48% 
    Primary pages: 28568, secondary pages: 0, swept pages: 6615 
    Empty pages: 6727, full pages: 13615 
    Fill distribution: 
     0 - 19% = 10702 
    20 - 39% = 1889 
    40 - 59% = 1065 
    60 - 79% = 5267 
    80 - 99% = 9645 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1596, nodes: 1160452 
    Average node length: 5.78, total dup: 1083940, max dup: 113 
    Average key length: 2.85, compression ratio: 14.74 
    Average prefix length: 41.22, average data length: 0.78 
    Clustering factor: 158626, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 349 
        40 - 59% = 764 
        60 - 79% = 380 
        80 - 99% = 98 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.81, total records: 9211783 
    Average version length: 68.96, total versions: 545837, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 89, data page slots: 143976 
    Data pages: 143960, average fill: 69% 
    Primary pages: 143960, secondary pages: 0, swept pages: 50005 
    Empty pages: 334, full pages: 79089 
    Fill distribution: 
     0 - 19% = 1148 
    20 - 39% = 6365 
    40 - 59% = 24006 
    60 - 79% = 103678 
    80 - 99% = 8763 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13484, nodes: 9211783 
    Average node length: 6.68, total dup: 7640328, max dup: 29 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1982536, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1305 
        40 - 59% = 6814 
        60 - 79% = 4629 
        80 - 99% = 736 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21140940 
    Average version length: 82.95, total versions: 13598, 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: 318704 
    Data pages: 318704, average fill: 81% 
    Primary pages: 318704, secondary pages: 0, swept pages: 12381 
    Empty pages: 40, full pages: 317674 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 55 
    40 - 59% = 162 
    60 - 79% = 27395 
    80 - 99% = 291022 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19313, nodes: 21140940 
    Average node length: 5.72, total dup: 20660206, max dup: 140 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279604, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 8026 
        60 - 79% = 533 
        80 - 99% = 10749 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17179, nodes: 21140940 
    Average node length: 6.31, total dup: 18578864, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914158, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 5 
        40 - 59% = 829 
        60 - 79% = 251 
        80 - 99% = 16092 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21110, nodes: 21140940 
    Average node length: 6.35, total dup: 18497759, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573630, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8313 
        60 - 79% = 619 
        80 - 99% = 12174 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16001, nodes: 21140940 
    Average node length: 5.56, total dup: 21140840, max dup: 230057 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943008, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 9 
        40 - 59% = 2710 
        60 - 79% = 368 
        80 - 99% = 12911 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.57, total records: 9693810 
    Average version length: 82.62, total versions: 569108, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 105, data page slots: 171136 
    Data pages: 171080, average fill: 70% 
    Primary pages: 171080, secondary pages: 0, swept pages: 62164 
    Empty pages: 617, full pages: 101165 
    Fill distribution: 
     0 - 19% = 1777 
    20 - 39% = 8212 
    40 - 59% = 27194 
    60 - 79% = 68104 
    80 - 99% = 65793 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11374, nodes: 9693810 
    Average node length: 5.36, total dup: 9384849, max dup: 206 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2149435, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 143 
        40 - 59% = 8109 
        60 - 79% = 3066 
        80 - 99% = 52 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13597, nodes: 9693810 
    Average node length: 6.23, total dup: 8035178, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1494209, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 163 
        20 - 39% = 4049 
        40 - 59% = 4329 
        60 - 79% = 2605 
        80 - 99% = 2451 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12691, nodes: 9693810 
    Average node length: 5.98, total dup: 8414908, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2339657, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 151 
        40 - 59% = 9101 
        60 - 79% = 3375 
        80 - 99% = 62 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10207, nodes: 9693810 
    Average node length: 5.13, total dup: 9693710, max dup: 148697 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1535143, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1302 
        40 - 59% = 5121 
        60 - 79% = 1713 
        80 - 99% = 2034 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.27, total records: 11249200 
    Average version length: 82.54, total versions: 412349, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 119, data page slots: 193424 
    Data pages: 191896, average fill: 72% 
    Primary pages: 191896, secondary pages: 0, swept pages: 73239 
    Empty pages: 3245, full pages: 138545 
    Fill distribution: 
     0 - 19% = 5565 
    20 - 39% = 8471 
    40 - 59% = 19976 
    60 - 79% = 43846 
    80 - 99% = 114038 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13110, nodes: 11249200 
    Average node length: 5.30, total dup: 11139483, max dup: 634 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2344611, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 124 
        40 - 59% = 9235 
        60 - 79% = 3641 
        80 - 99% = 110 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10417, nodes: 11249200 
    Average node length: 5.50, total dup: 10758969, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 708155, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 161 
        20 - 39% = 855 
        40 - 59% = 2532 
        60 - 79% = 1894 
        80 - 99% = 4975 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14999, nodes: 11249200 
    Average node length: 6.03, total dup: 9814854, max dup: 70 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2361007, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 170 
        40 - 59% = 10799 
        60 - 79% = 3906 
        80 - 99% = 123 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10757, nodes: 11249200 
    Average node length: 5.22, total dup: 11249100, max dup: 178632 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 697656, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 83 
        20 - 39% = 889 
        40 - 59% = 4800 
        60 - 79% = 1496 
        80 - 99% = 3489 
 
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: 78.21, total records: 9772371 
    Average version length: 82.89, total versions: 533973, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 108, data page slots: 174824 
    Data pages: 174768, average fill: 69% 
    Primary pages: 174768, secondary pages: 0, swept pages: 69473 
    Empty pages: 781, full pages: 98290 
    Fill distribution: 
     0 - 19% = 2201 
    20 - 39% = 8797 
    40 - 59% = 29506 
    60 - 79% = 71145 
    80 - 99% = 63119 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11827, nodes: 9772371 
    Average node length: 5.18, total dup: 9743669, max dup: 2136 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1966769, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1517 
        40 - 59% = 7882 
        60 - 79% = 1832 
        80 - 99% = 568 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13687, nodes: 9772371 
    Average node length: 6.25, total dup: 8099847, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1463716, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 183 
        20 - 39% = 4089 
        40 - 59% = 4303 
        60 - 79% = 2577 
        80 - 99% = 2535 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12465, nodes: 9772371 
    Average node length: 5.43, total dup: 9336417, max dup: 101 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2099447, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1526 
        40 - 59% = 8754 
        60 - 79% = 1559 
        80 - 99% = 594 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10264, nodes: 9772371 
    Average node length: 5.15, total dup: 9772271, max dup: 148593 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1563284, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1292 
        40 - 59% = 5097 
        60 - 79% = 1723 
        80 - 99% = 2109 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.37, total records: 579312 
    Average version length: 68.80, total versions: 6860, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7992 
    Data pages: 7992, average fill: 76% 
    Primary pages: 7992, secondary pages: 0, swept pages: 3544 
    Empty pages: 3, full pages: 7057 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 17 
    40 - 59% = 168 
    60 - 79% = 7686 
    80 - 99% = 117 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 37902, depth: 3, leaf buckets: 743, nodes: 579312 
    Average node length: 5.95, total dup: 493115, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100878, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 536 
        60 - 79% = 97 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31171, depth: 3, leaf buckets: 772, nodes: 579312 
    Average node length: 6.15, total dup: 475108, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100920, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 562 
        60 - 79% = 98 
        80 - 99% = 87 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 571, nodes: 579312 
    Average node length: 4.86, total dup: 579212, max dup: 9720 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89644, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 333 
        60 - 79% = 90 
        80 - 99% = 122 
 
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 Sun Mar 17 19:11:38 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7750090 101651 1 0.0000 0.0000
DOC_LIST 2245397 107116 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 236415 623 59100.0000 0.0000
INVNT_TURNOVER_LOG 149532 129779 1 0.0000 0.0000
MONEY_SALDO 49 17854 984 36400.0000 0.0000
MONEY_TURNOVER_LOG 1514 1332 1 0.0000 0.0000
PDISTR 812222 79854 5 0.0000 0.0000
PERF_SPLIT_0 177253 10130 1 0.0000 0.0000
PERF_SPLIT_1 161203 5360 1 0.0000 0.0000
PERF_SPLIT_2 174862 11572 1 0.0000 0.0000
PERF_SPLIT_3 177243 12735 1 0.0000 0.0000
PERF_SPLIT_4 187353 23064 1 0.0000 0.0000
PERF_SPLIT_5 160637 2905 1 0.0000 0.0000
PERF_SPLIT_6 173626 9617 1 0.0000 0.0000
PERF_SPLIT_7 175557 6014 1 0.0000 0.0000
PERF_SPLIT_8 159698 3144 1 0.0000 0.0000
PERF_SPLIT_9 187318 6563 1 0.0000 0.0000
PSTORNED 2116090 49382 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 158402 72356 1 0.0000 0.0000
XQD_1000_3300 7316012 520786 1 0.0000 0.0000
XQD_1200_2000 12256130 388952 1 0.0000 0.0000
XQD_2000_3300 1768283 764740 1 0.0000 0.0000
XQD_2100_3300 1160452 565542 1 0.0000 0.0000
XQD_3300_3400 9211783 545837 1 0.0000 0.0000
XQS_1000_1200 21140940 13598 1 0.0000 0.0000
XQS_1000_3300 9693810 569108 1 0.0000 0.0000
XQS_1200_2000 11249200 412349 1 0.0000 0.0000
XQS_2100_3300 9772371 533973 1 0.0000 0.0000
XQS_3300_3400 579312 6860 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 ---
--- end of diff output ---

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

17.03.24 19:11:50. 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-17 19:11:53 No severe PSQL-related problems occured
17.03.24 19:11:54. End of report.