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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15353324 kB
MemAvailable 29993448 kB
Buffers 0 kB
Cached 16337552 kB
SwapCached 2760 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-04-15 22:09:44
DTS_END                         2024-04-15 22:09:44.2680
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53414
TRN_ID                          180710
ATT_ID                          622
EXC_UNIT                        2

Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 100 minutes: 9227.65 23060 922765
customer order: creation 178.15 390 17815
customer order: refuse 15.22 336 1522
order to supplier: creation 49.11 1296 4911
order to supplier: removal 3.26 101471 326
invoice (draft): creation 48.19 3179 4819
invoice (draft): removal 49.51 879 4951
invoice accept: apply 42.99 18810 4299
invoice accept: cancel 44.96 810 4496
customer reserve: creation 4096.82 182 409682
customer reserve: removal 4393.88 59 439388
realization accept: apply 88.18 181 8818
realization accept: cancel 83.55 113 8355
payment from customer: creation 61.61 127 6161
payment from customer: removal 5.99 105 599
payment to supplier: creation 50.34 133 5034
payment to supplier: removal 3.25 95 325
service: total inventory turnovers 4.65 1072 465
service: total monetary turnovers 7.00 22 700
service: aggregate perf. data 0.96 12936 96
service: refresh index statistics 0.03 318997 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-04-2024 22:10:24 to 15-04-2024 22:10:26.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2797
TEST_TIME 2 3591
TEST_TIME 3 3080
TEST_TIME 4 3484
TEST_TIME 5 3604
TEST_TIME 6 3875
TEST_TIME 7 4403
TEST_TIME 8 4423
TEST_TIME 9 4642
TEST_TIME 10 4525
TEST_TIME 11 4730
TEST_TIME 12 5037
TEST_TIME 13 5326
TEST_TIME 14 5588
TEST_TIME 15 5927
TEST_TIME 16 5869
TEST_TIME 17 6133
TEST_TIME 18 6217
TEST_TIME 19 6331
TEST_TIME 20 6481
TEST_TIME 21 6478
TEST_TIME 22 6877
TEST_TIME 23 7067
TEST_TIME 24 7036
TEST_TIME 25 7616
TEST_TIME 26 8185
TEST_TIME 27 8506
TEST_TIME 28 8494
TEST_TIME 29 8854
TEST_TIME 30 9095
TEST_TIME 31 9020
TEST_TIME 32 8957
TEST_TIME 33 9030
TEST_TIME 34 8997
TEST_TIME 35 9037
TEST_TIME 36 9091
TEST_TIME 37 9016
TEST_TIME 38 9068
TEST_TIME 39 9103
TEST_TIME 40 9383
TEST_TIME 41 9344
TEST_TIME 42 9412
TEST_TIME 43 9532
TEST_TIME 44 9355
TEST_TIME 45 9228
TEST_TIME 46 9199
TEST_TIME 47 9148
TEST_TIME 48 9060
TEST_TIME 49 9089
TEST_TIME 50 9123
TEST_TIME 51 9200
TEST_TIME 52 9330
TEST_TIME 53 9325
TEST_TIME 54 9296
TEST_TIME 55 9300
TEST_TIME 56 9159
TEST_TIME 57 9100
TEST_TIME 58 9187
TEST_TIME 59 9185
TEST_TIME 60 9110
TEST_TIME 61 9054
TEST_TIME 62 8971
TEST_TIME 63 9006
TEST_TIME 64 8967
TEST_TIME 65 8947
TEST_TIME 66 8963
TEST_TIME 67 8983
TEST_TIME 68 9002
TEST_TIME 69 8992
TEST_TIME 70 9062
TEST_TIME 71 9078
TEST_TIME 72 9161
TEST_TIME 73 9212
TEST_TIME 74 9248
TEST_TIME 75 9176
TEST_TIME 76 9337
TEST_TIME 77 9324
TEST_TIME 78 9272
TEST_TIME 79 9392
TEST_TIME 80 9361
TEST_TIME 81 9272
TEST_TIME 82 9226
TEST_TIME 83 9181
TEST_TIME 84 9158
TEST_TIME 85 9138
TEST_TIME 86 9110
TEST_TIME 87 9123
TEST_TIME 88 9105
TEST_TIME 89 9127
TEST_TIME 90 9105
TEST_TIME 91 9162
TEST_TIME 92 9135
TEST_TIME 93 9181
TEST_TIME 94 9163
TEST_TIME 95 9223
TEST_TIME 96 9260
TEST_TIME 97 9247
TEST_TIME 98 9211
TEST_TIME 99 9296
TEST_TIME 100 9234

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-04-2024 22:10:28 to 15-04-2024 22:10:31.

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 1297124 1297124 0 0.00 0 17557 6 0 0
doc_list_biud 1297123 1297123 0 0.00 0 24819 26 0 0
sp_add_invoice_to_stock 4421 4299 122 2.75 20 213212 18811 0 122
sp_cancel_adding_invoice 4496 4496 0 0.00 4 51352 810 0 0
sp_cancel_client_order 1522 1522 0 0.00 4 14440 336 0 0
sp_cancel_customer_reserve 439388 439388 0 0.00 0 22063 59 0 0
sp_cancel_pay_from_customer 599 599 0 0.00 2 6793 106 0 0
sp_cancel_pay_to_supplier 325 325 0 0.00 3 7463 96 0 0
sp_cancel_supplier_invoice 4961 4951 10 0.20 1 18079 880 0 10
sp_cancel_supplier_order 326 326 0 0.00 8 931002 101471 0 0
sp_cancel_write_off 8355 8355 0 0.00 1 9245 113 0 0
sp_client_order 17815 17815 0 0.00 3 19845 391 0 0
sp_customer_reserve 409682 409682 0 0.00 0 109415 182 0 0
sp_fill_shopping_cart 27537 27537 0 0.00 1 18318 35 0 0
sp_fill_shopping_cart_clo_res 409674 409674 0 0.00 0 19101 15 0 0
sp_get_clo_for_invoice 4290 4290 0 0.00 0 21452 292 0 0
sp_kill_cost_storno 13775 13775 0 0.00 0 8357 58 0 0
sp_kill_qstorno_ret_qs2qd 892408 892408 0 0.00 0 22024 33 0 0
sp_kill_qty_storno 472146 472146 0 0.00 0 24817 70 0 0
sp_lock_selected_doc 18025 18025 0 0.00 0 6600 3 0 0
sp_make_cost_storno 24303 24303 0 0.00 0 17554 58 0 0
sp_multiply_rows_for_pdistr 24303 24303 0 0.00 0 8264 29 0 0
sp_multiply_rows_for_qdistr 17814 17814 0 0.00 0 16116 176 0 0
sp_pay_from_customer 6161 6161 0 0.00 4 16499 128 0 0
sp_pay_to_supplier 5034 5034 0 0.00 5 17882 134 0 0
sp_payment_common 11195 11195 0 0.00 1 10664 33 0 0
sp_qd_handle_on_cancel_clo 1522 1522 0 0.00 0 13398 312 0 0
sp_qd_handle_on_invoice_upd_sts 8786 8786 0 0.00 0 24815 306 0 0
sp_qd_handle_on_reserve_upd_sts 8818 8818 0 0.00 0 11586 57 0 0
sp_reserve_write_off 8818 8818 0 0.00 6 14802 181 0 0
sp_supplier_invoice 4819 4819 0 0.00 6 148479 3180 0 0
sp_supplier_order 4911 4911 0 0.00 5 34961 1296 0 0
srv_aggregate_perf_data 97 96 1 1.03 1902 123445 12936 0 1
srv_fill_mon_cache_memory 55 55 0 0.00 1028 113948 41606 0 0
srv_find_qd_qs_mism 878581 878581 0 0.00 0 14619 5 0 0
srv_make_invnt_saldo 465 465 0 0.00 45 27832 1073 0 0
srv_make_money_saldo 700 700 0 0.00 0 434 22 0 0
srv_recalc_idx_stat 3 3 0 0.00 203539 487699 318998 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4299 4299 0 0.00 0 19792 197 0 0
t$perf-norm:sp_cancel_adding_invoice 372 372 0 0.00 0 7086 146 0 0
t$perf-norm:sp_cancel_client_order 1522 1522 0 0.00 0 9085 20 0 0
t$perf-norm:sp_cancel_customer_reserve 596 596 0 0.00 0 701 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 599 599 0 0.00 0 294 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 325 325 0 0.00 0 609 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 346 346 0 0.00 0 3046 36 0 0
t$perf-norm:sp_cancel_supplier_order 326 326 0 0.00 0 17848 1720 0 0
t$perf-norm:sp_cancel_write_off 831 831 0 0.00 0 3403 7 0 0
t$perf-norm:sp_client_order 17815 17815 0 0.00 0 25562 22 0 0
t$perf-norm:sp_customer_reserve 865 865 0 0.00 0 12301 24 0 0
t$perf-norm:sp_pay_from_customer 6161 6161 0 0.00 0 16001 14 0 0
t$perf-norm:sp_pay_to_supplier 5034 5034 0 0.00 0 3723 9 0 0
t$perf-norm:sp_reserve_write_off 8818 8818 0 0.00 0 20453 16 0 0
t$perf-norm:sp_supplier_invoice 4819 4819 0 0.00 0 2937 14 0 0
t$perf-norm:sp_supplier_order 4911 4911 0 0.00 0 13076 23 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 1525 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 53 3 0 0
t$perf-norm:srv_make_invnt_saldo 465 465 0 0.00 0 1984 29 0 0
t$perf-norm:srv_make_money_saldo 700 700 0 0.00 0 1533 16 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 8823 8579 244 2.76 0 14125 28 0 244
v_all_customers 32900 32900 0 0.00 0 36 1 0 0
v_all_suppliers 27028 27028 0 0.00 0 36 1 0 0
v_all_wares 35624 35624 0 0.00 0 152 1 0 0
v_cancel_adding_invoice 744 744 0 0.00 0 5558 21 0 0
v_cancel_client_order 3044 3044 0 0.00 0 2483 6 0 0
v_cancel_customer_prepayment 1198 1198 0 0.00 0 5517 17 0 0
v_cancel_customer_reserve 1192 1192 0 0.00 0 2080 5 0 0
v_cancel_payment_to_supplier 650 650 0 0.00 0 1532 5 0 0
v_cancel_supplier_invoice 712 692 20 2.80 0 1050 13 0 20
v_cancel_supplier_order 652 652 0 0.00 0 2097 7 0 0
v_cancel_write_off 1662 1662 0 0.00 0 4508 18 0 0
v_max_id_clo_ord 4910 4910 0 0.00 0 668 1 0 0
v_max_id_clo_res 865 865 0 0.00 0 2906 17 0 0
v_max_id_ord_sup 4813 4813 0 0.00 0 5321 4 0 0
v_max_non_paid_invoice 1243 1243 0 0.00 0 1809 4 0 0
v_max_non_paid_realizn 3131 3131 0 0.00 0 1685 5 0 0
v_min_id_clo_ord 4910 4910 0 0.00 0 3687 5 0 0
v_min_id_clo_res 865 865 0 0.00 0 950 4 0 0
v_min_id_ord_sup 4813 4813 0 0.00 0 2278 4 0 0
v_min_non_paid_invoice 5034 5034 0 0.00 0 6131 19 0 0
v_min_non_paid_realizn 6161 6161 0 0.00 0 10662 32 0 0
v_our_firm 8784 8784 0 0.00 0 16 1 0 0
v_reserve_write_off 17636 17636 0 0.00 0 14051 12 0 0
x_lock_depdocs_on_canc_invoice 9101 9101 0 0.00 0 12766 125 0 0
x_lock_depdocs_on_canc_sup_ord 326 326 0 0.00 0 3356 292 0 0
x_make_qstorno_1000_1200 4911 4911 0 0.00 1 34831 1226 0 0
x_make_qstorno_1200_2000 4819 4819 0 0.00 2 148449 3052 0 0
x_make_qstorno_2100_3300 409682 409682 0 0.00 0 109376 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-04-2024 22:10:32 to 15-04-2024 22:10:36.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
20:09:48 2 8192000000 8798901904 8810303488 5283728 0.064 3 1 2 0 5383216 56704 42784
20:10:49 28275 8192000000 9875296944 10186387456 949503024 10.386 100 84 168 0 977751280 5763024 22485232
20:12:25 23675 8192000000 9932432448 10252296192 1002285664 10.901 100 91 182 0 1034919840 8790272 23843904
20:13:54 12468 8192000000 9957306336 10285035520 1032766416 11.195 100 87 174 0 1064855040 10030880 22057744
20:15:11 11108 8192000000 10028447376 10376396800 1103402736 11.870 100 77 152 0 1131666080 10374624 17888720
20:16:27 8068 8192000000 10083254640 10440437760 1157054336 12.376 100 79 157 0 1187745872 12281328 18410208
20:17:39 2462 8192000000 10111162752 10477879296 1189656128 12.680 100 83 165 1 1222022736 14691392 17675216
20:18:43 1344 8192000000 10143504176 10517352448 1226925984 13.026 100 86 172 1 1257325776 11993264 18406528
20:19:47 1402 8192000000 10185469152 10566893568 1265654400 13.382 100 88 173 0 1297530176 12791600 19084176
20:20:51 982 8192000000 10215635504 10598621184 1285046192 13.559 100 91 180 1 1319272992 14120992 20105808
20:21:52 6176 8192000000 10216445376 10608951296 1294439328 13.645 100 66 131 1 1320133600 10849248 14845024
20:22:59 7965 8192000000 10198323888 10613604352 1301733920 13.711 100 27 53 0 1314351216 6593360 6023936
20:24:08 9135 8192000000 10202334976 10621816832 1305817360 13.748 100 10 21 0 1313204896 5292272 2095264
20:25:18 14259 8192000000 10210306752 10630148096 1314630384 13.828 100 33 66 2 1328411616 5381472 8399760
20:26:57 8775 8192000000 10216434848 10639310848 1316446208 13.845 100 19 38 0 1327162096 6183344 4532544
20:28:07 7666 8192000000 10221464176 10648629248 1323637200 13.910 100 13 26 0 1331910192 5314528 2958464
20:29:15 8514 8192000000 10213518640 10634870784 1303646992 13.728 99 29 58 0 1315884720 5614304 6623424
20:30:31 8656 8192000000 10231822768 10639511552 1303715728 13.729 99 49 98 0 1322431632 7531136 11184768
20:31:44 113947 8192000000 10222546672 10630565888 1298585824 13.682 99 59 118 0 1323482560 10826256 14070480
20:34:45 30644 8192000000 10227193328 10642407424 1276592848 13.482 97 24 48 0 1297773328 15640560 5539920
20:36:48 5365 8192000000 10225362048 10629742592 1296747872 13.666 100 46 91 0 1320508720 12291136 11469712
20:38:01 10899 8192000000 10195355904 10593013760 1271936224 13.439 98 46 91 0 1296642160 14236208 10469728
20:39:36 9218 8192000000 10220116800 10609922048 1292951040 13.631 100 66 127 1 1326141392 18370128 14820224
20:40:51 17425 8192000000 10211967440 10617163776 1281029216 13.522 98 36 68 1 1311821008 22500048 8291744
20:42:15 4501 8192000000 10232099760 10629140480 1305920336 13.749 99 71 135 1 1347806160 24234768 17651056
20:43:34 4333 8192000000 10285467136 10683723776 1347045200 14.121 100 68 132 2 1393088704 30023968 16019536
20:44:44 1746 8192000000 10296887664 10699169792 1356238032 14.204 100 71 140 2 1404154448 31334064 16582352
20:45:50 14978 8192000000 10312792256 10720182272 1368876720 14.317 100 58 116 0 1420031696 36772016 14382960
20:47:30 1026 8192000000 10281190000 10680664064 1334409424 14.007 99 67 132 0 1386263008 34999824 16853760
20:48:35 4391 8192000000 10316841872 10717687808 1368934640 14.318 100 76 148 0 1424444384 37970448 17539296
20:49:43 17102 8192000000 10312970112 10736140288 1372824480 14.352 100 33 63 0 1422885712 41223312 8837920
20:51:19 20021 8192000000 10319246048 10752303104 1384695456 14.459 100 31 62 0 1436993344 43638752 8659136
20:52:43 38376 8192000000 10319433376 10749169664 1374533760 14.368 100 24 48 0 1424937552 43199664 7204128
20:54:32 9001 8192000000 10331357552 10762731520 1368933712 14.317 99 34 68 0 1424208960 46194944 9080304
20:55:45 21504 8192000000 10303808032 10742210560 1378713808 14.405 100 22 44 0 1420157296 35208176 6235312
20:57:09 11245 8192000000 10307021664 10744774656 1384488608 14.457 100 24 49 0 1416480112 26207504 5784000
20:58:22 16903 8192000000 10289240320 10740387840 1379130896 14.409 100 22 44 0 1402426096 17865728 5429472
20:59:55 48324 8192000000 10287818448 10735730688 1369752608 14.325 99 11 20 2 1380454816 8801824 1900384
21:01:55 29147 8192000000 10291643168 10738970624 1390336880 14.509 100 34 66 0 1404995024 7177920 7480224
21:03:25 33315 8192000000 10294504064 10747543552 1391921952 14.523 100 45 88 0 1411103232 8892128 10289152
21:05:07 63896 8192000000 10302320448 10758975488 1388358912 14.491 99 18 36 0 1405840880 13422896 4059072
21:07:12 52607 8192000000 10318794192 10768896000 1389639872 14.503 99 15 30 0 1405801632 12825648 3336112
21:09:05 106207 8192000000 10310435824 10763878400 1351291696 14.159 96 6 12 0 1372404896 20240752 872448
21:11:53 101371 8192000000 10297509120 10753220608 1330877648 13.975 95 6 12 0 1347807440 16200480 729312
21:15:11 18167 8192000000 10325490688 10759643136 1389454224 14.501 99 66 127 0 1419888704 16056928 14377552
21:16:40 30244 8192000000 10290091824 10738909184 1372767312 14.352 99 10 20 0 1390790336 15654016 2369008
21:18:13 9835 8192000000 10294895840 10734469120 1365456656 14.286 99 46 90 0 1389974608 14647680 9870272
21:19:24 49430 8192000000 10262391088 10715635712 1298320080 13.680 95 20 40 0 1324536592 21125584 5090928
21:21:30 74655 8192000000 10263898368 10711396352 1301130448 13.706 95 22 38 1 1324970112 19133984 4705680
21:24:04 99310 8192000000 10226996256 10658553856 1234628768 13.097 92 17 34 1 1253616384 15070448 3917168
21:26:48 56864 8192000000 10240108192 10695798784 1328709488 13.955 100 17 33 0 1352184160 19964240 3510432
21:29:13 40241 8192000000 10245000896 10688065536 1330134048 13.968 99 12 24 0 1339917008 7059600 2723360
21:30:53 60611 8192000000 10240487344 10692833280 1331578256 13.981 99 17 34 0 1345839440 10471680 3789504
21:33:19 20862 8192000000 10272821920 10711744512 1360484736 14.242 100 54 105 2 1380642736 7856880 12301120
21:34:40 48422 8192000000 10252733328 10707197952 1313641280 13.819 97 7 14 0 1322443616 7378240 1424096
21:36:30 74238 8192000000 10238794784 10680324096 1293388144 13.635 96 14 28 0 1304325488 7953856 2983488
21:38:45 13260 8192000000 10280207232 10714021888 1354273392 14.186 99 42 85 0 1372554384 8509632 9771360
21:39:59 63207 8192000000 10299354976 10744651776 1369322480 14.321 99 21 43 0 1390707552 16953824 4431248
21:42:06 75865 8192000000 10300903184 10763268096 1367048992 14.301 98 15 30 0 1384267424 13812016 3406416
21:44:24 15544 8192000000 10317924832 10754486272 1382116704 14.435 99 53 105 0 1405935680 11852864 11966112
21:45:40 80825 8192000000 10322270640 10758946816 1353926944 14.183 97 22 45 0 1369271328 10615616 4728768
21:48:01 106524 8192000000 10287658832 10736910336 1348159808 14.131 97 18 36 0 1368854464 16450816 4243840
21:50:48 82996 8192000000 10301648176 10751021056 1367160928 14.302 98 21 42 0 1378171200 6862448 4147824
21:53:20 15734 8192000000 10289698432 10729996288 1372205760 14.347 99 37 74 0 1394390496 13874080 8310656
21:54:38 64684 8192000000 10286642144 10749210624 1382210176 14.436 99 15 28 0 1402408768 16820128 3378464
21:56:43 48505 8192000000 10302101456 10749177856 1370703584 14.333 99 21 42 0 1391414944 15693056 5018304
21:58:36 72520 8192000000 10288356384 10748948480 1368447536 14.313 99 7 14 0 1379122752 8999056 1676160
22:00:56 51322 8192000000 10284432288 10735804416 1358635392 14.225 98 16 32 1 1374204256 11877184 3691680
22:02:48 53205 8192000000 10291986144 10742951936 1359633424 14.234 98 16 32 0 1378663424 15749552 3280448
22:04:44 55261 8192000000 10267705184 10720874496 1340847344 14.065 98 25 49 0 1357166224 10010816 6308064
22:06:45 69870 8192000000 10279826384 10723479552 1330422656 13.971 97 21 42 0 1349345776 14374048 4549072
22:09:03 39930 8192000000 10256989664 10686730240 1268389600 13.407 93 36 68 0 1287770688 12627360 6753728

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 15-04-2024 22:10:38 to 15-04-2024 22:10:52.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 122 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-04-2024 22:10:53 to 15-04-2024 22:10:55.

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          179291
MON$OLDEST_ACTIVE               181398
MON$OLDEST_SNAPSHOT             181398
MON$NEXT_TRANSACTION            181398
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                       1922912
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Mon Apr 15 22:10:56 2024 
 
Database header page information: 
    Flags            0 
    Generation        94315 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    179291 
    Oldest active        181398 
    Oldest snapshot        181398 
    Next transaction    181399 
    Sequence number        0 
    Next attachment ID    729 
    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: 46.78, total records: 7877414 
    Average version length: 48.16, total versions: 183639, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.37 
    Pointer pages: 54, data page slots: 87864 
    Data pages: 87864, average fill: 72% 
    Primary pages: 87864, secondary pages: 0, swept pages: 11102 
    Empty pages: 0, full pages: 78724 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 254 
    40 - 59% = 3600 
    60 - 79% = 83917 
    80 - 99% = 76 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23442, nodes: 7877414 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1724642, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 351 
        20 - 39% = 1393 
        40 - 59% = 4463 
        60 - 79% = 2139 
        80 - 99% = 15096 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13628, nodes: 7877414 
    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: 1547954, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1305 
        40 - 59% = 2371 
        60 - 79% = 948 
        80 - 99% = 9004 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8404, nodes: 7877414 
    Average node length: 6.64, total dup: 5861353, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1540899, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 732 
        40 - 59% = 1564 
        60 - 79% = 778 
        80 - 99% = 5170 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.20, total records: 2305667 
    Average version length: 34.44, total versions: 180772, max versions: 3 
    Average fragment length: 4.67, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.52 
    Pointer pages: 18, data page slots: 28984 
    Data pages: 28984, average fill: 74% 
    Primary pages: 28976, secondary pages: 8, swept pages: 6706 
    Empty pages: 6, full pages: 24084 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 194 
    40 - 59% = 1741 
    60 - 79% = 24366 
    80 - 99% = 2654 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4607, nodes: 2305667 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 686631, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 791 
        40 - 59% = 1000 
        60 - 79% = 602 
        80 - 99% = 2214 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2556, nodes: 2308976 
    Average node length: 4.97, total dup: 2308077, max dup: 21056 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1250418, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 227 
        40 - 59% = 1587 
        60 - 79% = 528 
        80 - 99% = 213 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2104, nodes: 2305667 
    Average node length: 4.97, total dup: 2305617, max dup: 130405 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1082491, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 44 
        40 - 59% = 1206 
        60 - 79% = 43 
        80 - 99% = 811 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4384, nodes: 2305667 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 686631, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 454 
        40 - 59% = 694 
        60 - 79% = 706 
        80 - 99% = 2399 
 
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.45, total records: 400 
    Average version length: 23.02, total versions: 230572, max versions: 605 
    Average fragment length: 2.00, total fragments: 47, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1328 
    Data pages: 1328, average fill: 86% 
    Primary pages: 54, secondary pages: 1274, swept pages: 0 
    Empty pages: 47, full pages: 1274 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1274 
 
    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: 4.66, total records: 68226 
    Average version length: 68.29, total versions: 63570, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 18.88 
    Pointer pages: 6, data page slots: 3176 
    Data pages: 1384, average fill: 62% 
    Primary pages: 1383, secondary pages: 1, swept pages: 0 
    Empty pages: 176, full pages: 660 
    Fill distribution: 
     0 - 19% = 237 
    20 - 39% = 136 
    40 - 59% = 176 
    60 - 79% = 189 
    80 - 99% = 646 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708943, depth: 3, leaf buckets: 328, nodes: 68226 
    Average node length: 13.42, total dup: 4552, max dup: 1 
    Average key length: 10.77, compression ratio: 2.51 
    Average prefix length: 19.16, average data length: 7.84 
    Clustering factor: 49233, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 249 
        40 - 59% = 74 
        60 - 79% = 4 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18315, max versions: 995 
    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: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 9 
    80 - 99% = 57 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.17, total records: 1008 
    Average version length: 43.06, total versions: 957, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 26.77 
    Pointer pages: 1, data page slots: 40 
    Data pages: 29, average fill: 34% 
    Primary pages: 28, secondary pages: 1, swept pages: 0 
    Empty pages: 8, full pages: 5 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 2 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88474, depth: 2, leaf buckets: 2, nodes: 1008 
    Average node length: 4.54, total dup: 911, max dup: 102 
    Average key length: 3.03, compression ratio: 6.28 
    Average prefix length: 18.07, average data length: 0.93 
    Clustering factor: 585, ratio: 0.58 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 96.99, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.52, total records: 810952 
    Average version length: 25.11, total versions: 93322, max versions: 4 
    Average fragment length: 28.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 5, data page slots: 7904 
    Data pages: 7904, average fill: 72% 
    Primary pages: 7884, secondary pages: 20, swept pages: 611 
    Empty pages: 0, full pages: 7245 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 5 
    40 - 59% = 27 
    60 - 79% = 7458 
    80 - 99% = 412 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 882, nodes: 810952 
    Average node length: 4.87, total dup: 810903, max dup: 140526 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 92109, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 102 
        40 - 59% = 513 
        60 - 79% = 204 
        80 - 99% = 60 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 929, nodes: 810952 
    Average node length: 5.88, total dup: 721904, max dup: 50 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164074, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 94 
        40 - 59% = 381 
        60 - 79% = 169 
        80 - 99% = 282 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 972, nodes: 810952 
    Average node length: 5.88, total dup: 721904, max dup: 50 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165954, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 193 
        40 - 59% = 347 
        60 - 79% = 146 
        80 - 99% = 286 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1121, nodes: 810952 
    Average node length: 5.96, total dup: 721904, max dup: 50 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158932, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 223 
        40 - 59% = 585 
        60 - 79% = 210 
        80 - 99% = 102 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.82, total records: 5470 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.29, total fragments: 55, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 72, secondary pages: 16, swept pages: 45 
    Empty pages: 3, full pages: 63 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5470 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.01 
    Average prefix length: 34.43, average data length: 1.56 
    Clustering factor: 5098, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5470 
    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: 147, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 82364 
    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: 800 
    Data pages: 800, average fill: 71% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 793 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 793 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36197, depth: 2, leaf buckets: 104, nodes: 82364 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3252, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 103 
 
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.08, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 136.82, total records: 184990 
    Average version length: 154.87, total versions: 17288, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.40 
    Pointer pages: 6, data page slots: 5296 
    Data pages: 4464, average fill: 86% 
    Primary pages: 4464, secondary pages: 0, swept pages: 6 
    Empty pages: 67, full pages: 4382 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4384 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 146.71, total records: 177222 
    Average version length: 151.75, total versions: 4898, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 7, data page slots: 4856 
    Data pages: 4256, average fill: 86% 
    Primary pages: 4256, secondary pages: 0, swept pages: 3 
    Empty pages: 48, full pages: 4182 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 8 
    40 - 59% = 8 
    60 - 79% = 8 
    80 - 99% = 4182 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 132.28, total records: 199029 
    Average version length: 154.17, total versions: 24651, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.82 
    Pointer pages: 6, data page slots: 5848 
    Data pages: 4800, average fill: 87% 
    Primary pages: 4800, secondary pages: 0, swept pages: 1 
    Empty pages: 63, full pages: 4718 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 11 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4718 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.92, total records: 182104 
    Average version length: 150.57, total versions: 3676, 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: 5384 
    Data pages: 4416, average fill: 85% 
    Primary pages: 4416, secondary pages: 0, swept pages: 2 
    Empty pages: 86, full pages: 4299 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 6 
    40 - 59% = 10 
    60 - 79% = 6 
    80 - 99% = 4300 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 142.39, total records: 171643 
    Average version length: 153.67, total versions: 9771, 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: 7, data page slots: 5016 
    Data pages: 4144, average fill: 86% 
    Primary pages: 4144, secondary pages: 0, swept pages: 1 
    Empty pages: 66, full pages: 4062 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 4064 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 148.90, total records: 182098 
    Average version length: 150.51, total versions: 2610, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 8, data page slots: 5048 
    Data pages: 4384, average fill: 86% 
    Primary pages: 4383, secondary pages: 1, swept pages: 3 
    Empty pages: 63, full pages: 4307 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4308 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 142.21, total records: 196732 
    Average version length: 153.93, total versions: 11539, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 6, data page slots: 5264 
    Data pages: 4744, average fill: 86% 
    Primary pages: 4744, secondary pages: 0, swept pages: 5 
    Empty pages: 63, full pages: 4653 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 14 
    80 - 99% = 4649 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.15, total records: 156386 
    Average version length: 149.42, total versions: 2640, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 5, data page slots: 4296 
    Data pages: 3744, average fill: 86% 
    Primary pages: 3744, secondary pages: 0, swept pages: 2 
    Empty pages: 41, full pages: 3691 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3691 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 148.80, total records: 176735 
    Average version length: 149.62, total versions: 2654, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 5256 
    Data pages: 4280, average fill: 85% 
    Primary pages: 4280, secondary pages: 0, swept pages: 3 
    Empty pages: 78, full pages: 4177 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 4 
    80 - 99% = 4177 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 147.34, total records: 161251 
    Average version length: 151.50, total versions: 3585, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 6, data page slots: 4984 
    Data pages: 3888, average fill: 85% 
    Primary pages: 3888, secondary pages: 0, swept pages: 2 
    Empty pages: 67, full pages: 3806 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3807 
 
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: 50.72, total records: 2160008 
    Average version length: 52.92, total versions: 82965, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.38 
    Pointer pages: 16, data page slots: 25776 
    Data pages: 25776, average fill: 72% 
    Primary pages: 25776, secondary pages: 0, swept pages: 8299 
    Empty pages: 228, full pages: 22589 
    Fill distribution: 
     0 - 19% = 414 
    20 - 39% = 317 
    40 - 59% = 765 
    60 - 79% = 23465 
    80 - 99% = 815 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2639, nodes: 2160008 
    Average node length: 5.44, total dup: 2017602, max dup: 1466 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 185065, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 283 
        40 - 59% = 1745 
        60 - 79% = 305 
        80 - 99% = 303 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2768, nodes: 2160008 
    Average node length: 5.69, total dup: 1940099, max dup: 90 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 384421, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2268 
        60 - 79% = 457 
        80 - 99% = 35 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2223, nodes: 2160008 
    Average node length: 4.96, total dup: 2159908, max dup: 28792 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 182740, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 155 
        40 - 59% = 1297 
        60 - 79% = 396 
        80 - 99% = 373 
 
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: 36.67, total records: 150076 
    Average version length: 69.19, total versions: 70588, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.44 
    Pointer pages: 3, data page slots: 3816 
    Data pages: 2599, average fill: 67% 
    Primary pages: 2599, secondary pages: 0, swept pages: 241 
    Empty pages: 346, full pages: 1991 
    Fill distribution: 
     0 - 19% = 433 
    20 - 39% = 17 
    40 - 59% = 47 
    60 - 79% = 772 
    80 - 99% = 1330 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 106215, depth: 3, leaf buckets: 200, nodes: 150076 
    Average node length: 6.42, total dup: 130743, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 25865, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 10 
        40 - 59% = 99 
        60 - 79% = 56 
        80 - 99% = 33 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 62.88, total records: 7340325 
    Average version length: 68.77, total versions: 646676, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.00 
    Pointer pages: 62, data page slots: 100664 
    Data pages: 100664, average fill: 78% 
    Primary pages: 100664, secondary pages: 0, swept pages: 10208 
    Empty pages: 2, full pages: 100097 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 20 
    60 - 79% = 82671 
    80 - 99% = 17970 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10619, nodes: 7340325 
    Average node length: 6.50, total dup: 6355389, max dup: 44 
    Average key length: 3.51, compression ratio: 11.97 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1621245, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1156 
        40 - 59% = 5696 
        60 - 79% = 3057 
        80 - 99% = 700 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8584, nodes: 7340325 
    Average node length: 5.39, total dup: 7055675, max dup: 183 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1405315, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 830 
        40 - 59% = 4853 
        60 - 79% = 1847 
        80 - 99% = 1047 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8628, nodes: 7340325 
    Average node length: 5.39, total dup: 7055675, max dup: 183 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1407930, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 920 
        40 - 59% = 4767 
        60 - 79% = 1878 
        80 - 99% = 1056 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.25, total records: 12093039 
    Average version length: 68.76, total versions: 474433, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 102, data page slots: 165512 
    Data pages: 165512, average fill: 78% 
    Primary pages: 165512, secondary pages: 0, swept pages: 55668 
    Empty pages: 3, full pages: 165314 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 13 
    60 - 79% = 153481 
    80 - 99% = 12014 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18325, nodes: 12093039 
    Average node length: 6.58, total dup: 10540792, max dup: 71 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2391048, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 21 
        20 - 39% = 2224 
        40 - 59% = 10762 
        60 - 79% = 4548 
        80 - 99% = 770 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 32.83, total records: 2247778 
    Average version length: 69.11, total versions: 1180402, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.84 
    Pointer pages: 31, data page slots: 48720 
    Data pages: 31152, average fill: 84% 
    Primary pages: 31152, secondary pages: 0, swept pages: 1304 
    Empty pages: 282, full pages: 30381 
    Fill distribution: 
     0 - 19% = 363 
    20 - 39% = 216 
    40 - 59% = 145 
    60 - 79% = 9530 
    80 - 99% = 20898 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2557, nodes: 2247778 
    Average node length: 5.50, total dup: 2157302, max dup: 99 
    Average key length: 2.53, compression ratio: 16.58 
    Average prefix length: 41.51, average data length: 0.49 
    Clustering factor: 153830, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 128 
        40 - 59% = 1197 
        60 - 79% = 882 
        80 - 99% = 328 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.51, total records: 1284236 
    Average version length: 69.14, total versions: 586223, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.36 
    Pointer pages: 20, data page slots: 32440 
    Data pages: 28080, average fill: 53% 
    Primary pages: 28080, secondary pages: 0, swept pages: 5249 
    Empty pages: 5767, full pages: 14020 
    Fill distribution: 
     0 - 19% = 8178 
    20 - 39% = 947 
    40 - 59% = 1773 
    60 - 79% = 8856 
    80 - 99% = 8326 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1682, nodes: 1284236 
    Average node length: 5.77, total dup: 1201007, max dup: 99 
    Average key length: 2.83, compression ratio: 14.85 
    Average prefix length: 41.24, average data length: 0.76 
    Clustering factor: 176570, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 271 
        40 - 59% = 786 
        60 - 79% = 508 
        80 - 99% = 115 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 62.22, total records: 9737469 
    Average version length: 68.97, total versions: 942743, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.03 
    Pointer pages: 92, data page slots: 149600 
    Data pages: 149600, average fill: 70% 
    Primary pages: 149600, secondary pages: 0, swept pages: 36264 
    Empty pages: 765, full pages: 100343 
    Fill distribution: 
     0 - 19% = 2157 
    20 - 39% = 6683 
    40 - 59% = 21817 
    60 - 79% = 97448 
    80 - 99% = 21495 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13593, nodes: 9737469 
    Average node length: 6.70, total dup: 8081789, max dup: 29 
    Average key length: 3.66, compression ratio: 11.49 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2040200, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 834 
        40 - 59% = 6206 
        60 - 79% = 5434 
        80 - 99% = 1114 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.45, total records: 21197802 
    Average version length: 82.92, total versions: 24234, 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: 319288 
    Data pages: 319288, average fill: 81% 
    Primary pages: 319288, secondary pages: 0, swept pages: 10607 
    Empty pages: 7, full pages: 319280 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 26461 
    80 - 99% = 292819 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19450, nodes: 21197802 
    Average node length: 5.72, total dup: 20716032, max dup: 171 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3286397, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 0 
        40 - 59% = 8212 
        60 - 79% = 573 
        80 - 99% = 10662 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17210, nodes: 21197802 
    Average node length: 6.31, total dup: 18626903, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915841, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 7 
        40 - 59% = 786 
        60 - 79% = 261 
        80 - 99% = 16153 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21225, nodes: 21197802 
    Average node length: 6.35, total dup: 18548036, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582955, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 8475 
        60 - 79% = 603 
        80 - 99% = 12145 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16307, nodes: 21197802 
    Average node length: 5.56, total dup: 21197702, max dup: 231589 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944914, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 13 
        40 - 59% = 3237 
        60 - 79% = 392 
        80 - 99% = 12663 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 75.00, total records: 10167923 
    Average version length: 82.62, total versions: 914815, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.68 
    Pointer pages: 107, data page slots: 174592 
    Data pages: 174544, average fill: 72% 
    Primary pages: 174544, secondary pages: 0, swept pages: 49164 
    Empty pages: 868, full pages: 118891 
    Fill distribution: 
     0 - 19% = 2188 
    20 - 39% = 6574 
    40 - 59% = 23093 
    60 - 79% = 56159 
    80 - 99% = 86530 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11442, nodes: 10167923 
    Average node length: 5.38, total dup: 9856258, max dup: 203 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2192698, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 68 
        40 - 59% = 6740 
        60 - 79% = 4449 
        80 - 99% = 184 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13776, nodes: 10167923 
    Average node length: 6.25, total dup: 8433957, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1489793, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 151 
        20 - 39% = 3514 
        40 - 59% = 4675 
        60 - 79% = 2516 
        80 - 99% = 2920 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12753, nodes: 10167923 
    Average node length: 5.99, total dup: 8848757, max dup: 44 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2404868, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 68 
        40 - 59% = 7697 
        60 - 79% = 4762 
        80 - 99% = 226 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10469, nodes: 10167923 
    Average node length: 5.16, total dup: 10167823, max dup: 180050 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1537438, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1040 
        40 - 59% = 5463 
        60 - 79% = 1646 
        80 - 99% = 2288 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 77.57, total records: 11811889 
    Average version length: 82.54, total versions: 679947, 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: 120, data page slots: 195640 
    Data pages: 194328, average fill: 75% 
    Primary pages: 194328, secondary pages: 0, swept pages: 54555 
    Empty pages: 2890, full pages: 156054 
    Fill distribution: 
     0 - 19% = 4526 
    20 - 39% = 5627 
    40 - 59% = 13859 
    60 - 79% = 38324 
    80 - 99% = 131992 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13160, nodes: 11811889 
    Average node length: 5.31, total dup: 11701573, max dup: 701 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2457579, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 50 
        40 - 59% = 8078 
        60 - 79% = 4631 
        80 - 99% = 400 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10806, nodes: 11811889 
    Average node length: 5.51, total dup: 11298298, max dup: 49 
    Average key length: 2.28, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 737055, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 759 
        40 - 59% = 2693 
        60 - 79% = 1855 
        80 - 99% = 5360 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15072, nodes: 11811889 
    Average node length: 6.03, total dup: 10325057, max dup: 72 
    Average key length: 2.79, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2474262, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 59 
        40 - 59% = 9558 
        60 - 79% = 5017 
        80 - 99% = 434 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11206, nodes: 11811889 
    Average node length: 5.24, total dup: 11811789, max dup: 210327 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 725098, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 79 
        20 - 39% = 706 
        40 - 59% = 5220 
        60 - 79% = 1477 
        80 - 99% = 3724 
 
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: 75.42, total records: 10274240 
    Average version length: 82.92, total versions: 907687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 110, data page slots: 178328 
    Data pages: 178288, average fill: 72% 
    Primary pages: 178288, secondary pages: 0, swept pages: 52598 
    Empty pages: 867, full pages: 117095 
    Fill distribution: 
     0 - 19% = 2361 
    20 - 39% = 7176 
    40 - 59% = 24435 
    60 - 79% = 60409 
    80 - 99% = 83907 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12223, nodes: 10274240 
    Average node length: 5.21, total dup: 10244434, max dup: 2419 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1993187, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1338 
        40 - 59% = 8039 
        60 - 79% = 2095 
        80 - 99% = 718 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13889, nodes: 10274240 
    Average node length: 6.27, total dup: 8521461, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1449571, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 197 
        20 - 39% = 3446 
        40 - 59% = 4618 
        60 - 79% = 2559 
        80 - 99% = 3069 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12914, nodes: 10274240 
    Average node length: 5.46, total dup: 9821203, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2135964, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 18 
        20 - 39% = 1329 
        40 - 59% = 9041 
        60 - 79% = 1900 
        80 - 99% = 626 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10651, nodes: 10274240 
    Average node length: 5.18, total dup: 10274140, max dup: 182304 
    Average key length: 2.00, compression ratio: 1.22 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1546926, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1139 
        40 - 59% = 5561 
        60 - 79% = 1593 
        80 - 99% = 2316 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.76, total records: 583939 
    Average version length: 68.75, total versions: 12112, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 76% 
    Primary pages: 8064, secondary pages: 0, swept pages: 3293 
    Empty pages: 1, full pages: 7051 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 19 
    40 - 59% = 159 
    60 - 79% = 7644 
    80 - 99% = 239 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 44893, depth: 3, leaf buckets: 753, nodes: 583939 
    Average node length: 5.95, total dup: 497391, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101448, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 532 
        60 - 79% = 108 
        80 - 99% = 82 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 35195, depth: 3, leaf buckets: 766, nodes: 583939 
    Average node length: 6.15, total dup: 479080, max dup: 27 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101496, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 27 
        40 - 59% = 527 
        60 - 79% = 112 
        80 - 99% = 99 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 590, nodes: 583939 
    Average node length: 4.86, total dup: 583839, max dup: 10191 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90142, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 363 
        60 - 79% = 91 
        80 - 99% = 104 
 
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 Mon Apr 15 22:11:21 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7877414 183639 1 0.0000 0.0000
DOC_LIST 2305667 180772 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 230572 605 57600.0000 0.0000
INVNT_TURNOVER_LOG 68226 63570 1 0.0000 0.0000
MONEY_SALDO 49 18315 995 37300.0000 0.0000
MONEY_TURNOVER_LOG 1008 957 1 0.0000 0.0000
PDISTR 810952 93322 4 0.0000 0.0000
PERF_SPLIT_0 184990 17288 1 0.0000 0.0000
PERF_SPLIT_1 177222 4898 1 0.0000 0.0000
PERF_SPLIT_2 199029 24651 1 0.0000 0.0000
PERF_SPLIT_3 182104 3676 1 0.0000 0.0000
PERF_SPLIT_4 171643 9771 1 0.0000 0.0000
PERF_SPLIT_5 182098 2610 1 0.0000 0.0000
PERF_SPLIT_6 196732 11539 1 0.0000 0.0000
PERF_SPLIT_7 156386 2640 1 0.0000 0.0000
PERF_SPLIT_8 176735 2654 1 0.0000 0.0000
PERF_SPLIT_9 161251 3585 1 0.0000 0.0000
PSTORNED 2160008 82965 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 150076 70588 1 0.0000 0.0000
XQD_1000_3300 7340325 646676 1 0.0000 0.0000
XQD_1200_2000 12093039 474433 1 0.0000 0.0000
XQD_2000_3300 2247778 1180402 1 0.0000 0.0000
XQD_2100_3300 1284236 586223 1 0.0000 0.0000
XQD_3300_3400 9737469 942743 1 0.0000 0.0000
XQS_1000_1200 21197802 24234 1 0.0000 0.0000
XQS_1000_3300 10167923 914815 1 0.0000 0.0000
XQS_1200_2000 11811889 679947 1 0.0000 0.0000
XQS_2100_3300 10274240 907687 1 0.0000 0.0000
XQS_3300_3400 583939 12112 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 ---
:1276: 
:1277: mscs-test-161.budzdorov.ru    Mon Apr 15 22:09:47 2024
:1278:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1279: 
--- end of diff output ---

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

15.04.24 22:11:33. 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-04-15 22:11:36 No severe PSQL-related problems occured
15.04.24 22:11:37. End of report.