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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15781544 kB
MemAvailable 30235540 kB
Buffers 0 kB
Cached 15958328 kB
SwapCached 2472 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-02-20 19:09:34
DTS_END                         2024-02-20 19:09:34.7800
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/52128
TRN_ID                          172454
ATT_ID                          519
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: 9037.49 24303 903749
customer order: creation 168.26 387 16826
customer order: refuse 14.43 433 1443
order to supplier: creation 45.80 1408 4580
order to supplier: removal 3.44 106251 344
invoice (draft): creation 45.94 3197 4594
invoice (draft): removal 50.30 831 5030
invoice accept: apply 41.21 19847 4121
invoice accept: cancel 45.87 869 4587
customer reserve: creation 3844.17 193 384417
customer reserve: removal 4486.06 63 448606
realization accept: apply 83.22 217 8322
realization accept: cancel 79.33 123 7933
payment from customer: creation 59.34 130 5934
payment from customer: removal 6.11 146 611
payment to supplier: creation 48.89 152 4889
payment to supplier: removal 3.48 138 348
service: total inventory turnovers 4.24 1070 424
service: total monetary turnovers 6.58 30 658
service: aggregate perf. data 0.79 22475 79
service: refresh index statistics 0.03 328107 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-02-2024 19:10:54 to 20-02-2024 19:10:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4467
TEST_TIME 2 5564
TEST_TIME 3 4707
TEST_TIME 4 4139
TEST_TIME 5 4489
TEST_TIME 6 4418
TEST_TIME 7 4934
TEST_TIME 8 4883
TEST_TIME 9 4832
TEST_TIME 10 5334
TEST_TIME 11 5338
TEST_TIME 12 5391
TEST_TIME 13 5797
TEST_TIME 14 5804
TEST_TIME 15 6067
TEST_TIME 16 6042
TEST_TIME 17 6163
TEST_TIME 18 6285
TEST_TIME 19 6436
TEST_TIME 20 6872
TEST_TIME 21 6895
TEST_TIME 22 7263
TEST_TIME 23 7496
TEST_TIME 24 7481
TEST_TIME 25 7776
TEST_TIME 26 7900
TEST_TIME 27 7979
TEST_TIME 28 8838
TEST_TIME 29 9161
TEST_TIME 30 9487
TEST_TIME 31 9603
TEST_TIME 32 9779
TEST_TIME 33 9659
TEST_TIME 34 9775
TEST_TIME 35 9612
TEST_TIME 36 9502
TEST_TIME 37 9336
TEST_TIME 38 9302
TEST_TIME 39 9476
TEST_TIME 40 9387
TEST_TIME 41 9261
TEST_TIME 42 9250
TEST_TIME 43 9164
TEST_TIME 44 9048
TEST_TIME 45 9063
TEST_TIME 46 8957
TEST_TIME 47 8948
TEST_TIME 48 8919
TEST_TIME 49 8827
TEST_TIME 50 8842
TEST_TIME 51 8756
TEST_TIME 52 8703
TEST_TIME 53 8797
TEST_TIME 54 8739
TEST_TIME 55 8766
TEST_TIME 56 8855
TEST_TIME 57 8785
TEST_TIME 58 8890
TEST_TIME 59 8948
TEST_TIME 60 8984
TEST_TIME 61 8963
TEST_TIME 62 8953
TEST_TIME 63 8960
TEST_TIME 64 9040
TEST_TIME 65 9109
TEST_TIME 66 9196
TEST_TIME 67 9064
TEST_TIME 68 9034
TEST_TIME 69 8969
TEST_TIME 70 8982
TEST_TIME 71 8963
TEST_TIME 72 8898
TEST_TIME 73 8945
TEST_TIME 74 8942
TEST_TIME 75 8893
TEST_TIME 76 8872
TEST_TIME 77 8904
TEST_TIME 78 9063
TEST_TIME 79 9065
TEST_TIME 80 9043
TEST_TIME 81 9074
TEST_TIME 82 9040
TEST_TIME 83 9008
TEST_TIME 84 9148
TEST_TIME 85 9143
TEST_TIME 86 9237
TEST_TIME 87 9363
TEST_TIME 88 9306
TEST_TIME 89 9257
TEST_TIME 90 9227
TEST_TIME 91 9182
TEST_TIME 92 9151
TEST_TIME 93 9177
TEST_TIME 94 9165
TEST_TIME 95 9124
TEST_TIME 96 9103
TEST_TIME 97 9077
TEST_TIME 98 9085
TEST_TIME 99 9103
TEST_TIME 100 9050

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-02-2024 19:10:58 to 20-02-2024 19:11:01.

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 1255185 1255185 0 0.00 0 38316 7 0 0
doc_list_biud 1255182 1255182 0 0.00 0 29541 29 0 0
sp_add_invoice_to_stock 4250 4121 129 3.03 51 203873 19848 0 129
sp_cancel_adding_invoice 4587 4587 0 0.00 4 45979 869 0 0
sp_cancel_client_order 1443 1443 0 0.00 4 14453 433 0 0
sp_cancel_customer_reserve 448606 448606 0 0.00 0 29543 64 0 0
sp_cancel_pay_from_customer 611 611 0 0.00 3 13091 146 0 0
sp_cancel_pay_to_supplier 348 348 0 0.00 2 14252 138 0 0
sp_cancel_supplier_invoice 5040 5030 10 0.19 1 24929 831 0 10
sp_cancel_supplier_order 344 344 0 0.00 8 936182 106252 0 0
sp_cancel_write_off 7933 7933 0 0.00 1 13280 123 0 0
sp_client_order 16826 16826 0 0.00 3 31639 387 0 0
sp_customer_reserve 384417 384417 0 0.00 0 46610 194 0 0
sp_fill_shopping_cart 26000 26000 0 0.00 1 13639 40 0 0
sp_fill_shopping_cart_clo_res 384407 384407 0 0.00 0 27248 16 0 0
sp_get_clo_for_invoice 4105 4105 0 0.00 0 26394 384 0 0
sp_kill_cost_storno 13479 13479 0 0.00 0 14242 73 0 0
sp_kill_qstorno_ret_qs2qd 910519 910519 0 0.00 0 29535 35 0 0
sp_kill_qty_storno 480369 480369 0 0.00 0 29541 75 0 0
sp_lock_selected_doc 17196 17196 0 0.00 0 6506 4 0 0
sp_make_cost_storno 23250 23250 0 0.00 0 37998 79 0 0
sp_multiply_rows_for_pdistr 23249 23249 0 0.00 0 13111 32 0 0
sp_multiply_rows_for_qdistr 16826 16826 0 0.00 0 11111 156 0 0
sp_pay_from_customer 5934 5934 0 0.00 4 16925 130 0 0
sp_pay_to_supplier 4889 4889 0 0.00 5 17114 152 0 0
sp_payment_common 10823 10823 0 0.00 1 13499 38 0 0
sp_qd_handle_on_cancel_clo 1443 1443 0 0.00 0 14447 380 0 0
sp_qd_handle_on_invoice_upd_sts 8691 8691 0 0.00 0 22837 358 0 0
sp_qd_handle_on_reserve_upd_sts 8322 8322 0 0.00 0 12286 59 0 0
sp_reserve_write_off 8322 8322 0 0.00 6 16988 217 0 0
sp_supplier_invoice 4594 4594 0 0.00 8 69954 3197 0 0
sp_supplier_order 4580 4580 0 0.00 5 43352 1409 0 0
srv_aggregate_perf_data 79 79 0 0.00 1727 282837 22476 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 2578 112969 39998 0 0
srv_find_qd_qs_mism 861889 861889 0 0.00 0 12912 6 0 0
srv_make_invnt_saldo 424 424 0 0.00 30 30140 1071 0 0
srv_make_money_saldo 658 658 0 0.00 1 1241 31 0 0
srv_recalc_idx_stat 3 3 0 0.00 307845 341588 328108 0 0
t$perf-abend:sp_add_invoice_to_stock 129 129 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-norm:sp_add_invoice_to_stock 4123 4123 0 0.00 0 12764 198 0 0
t$perf-norm:sp_cancel_adding_invoice 323 323 0 0.00 0 9958 119 0 0
t$perf-norm:sp_cancel_client_order 1443 1443 0 0.00 0 6624 19 0 0
t$perf-norm:sp_cancel_customer_reserve 552 552 0 0.00 0 829 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 611 611 0 0.00 0 184 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 348 348 0 0.00 0 3879 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 321 321 0 0.00 0 4122 31 0 0
t$perf-norm:sp_cancel_supplier_order 344 344 0 0.00 0 24306 1955 0 0
t$perf-norm:sp_cancel_write_off 828 828 0 0.00 0 3979 22 0 0
t$perf-norm:sp_client_order 16826 16826 0 0.00 0 17036 19 0 0
t$perf-norm:sp_customer_reserve 824 824 0 0.00 0 2953 7 0 0
t$perf-norm:sp_pay_from_customer 5934 5934 0 0.00 0 17266 12 0 0
t$perf-norm:sp_pay_to_supplier 4889 4889 0 0.00 0 6380 12 0 0
t$perf-norm:sp_reserve_write_off 8322 8322 0 0.00 0 6918 11 0 0
t$perf-norm:sp_supplier_invoice 4594 4594 0 0.00 0 12071 21 0 0
t$perf-norm:sp_supplier_order 4580 4580 0 0.00 0 3019 14 0 0
t$perf-norm:srv_aggregate_perf_data 79 79 0 0.00 0 135 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 722 17 0 0
t$perf-norm:srv_make_invnt_saldo 424 424 0 0.00 0 2063 31 0 0
t$perf-norm:srv_make_money_saldo 658 658 0 0.00 0 3823 31 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 11 5 0 0
v_add_invoice_to_stock 8466 8208 258 3.04 0 14084 24 0 258
v_all_customers 31356 31356 0 0.00 0 17 1 0 0
v_all_suppliers 26072 26072 0 0.00 0 20 1 0 0
v_all_wares 33652 33652 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 646 646 0 0.00 0 3681 14 0 0
v_cancel_client_order 2886 2886 0 0.00 0 13242 19 0 0
v_cancel_customer_prepayment 1222 1222 0 0.00 0 3160 10 0 0
v_cancel_customer_reserve 1104 1104 0 0.00 0 3157 11 0 0
v_cancel_payment_to_supplier 696 696 0 0.00 0 1583 7 0 0
v_cancel_supplier_invoice 662 642 20 3.02 0 3137 20 0 20
v_cancel_supplier_order 688 688 0 0.00 0 2173 14 0 0
v_cancel_write_off 1656 1656 0 0.00 0 1482 14 0 0
v_max_id_clo_ord 4580 4580 0 0.00 0 539 1 0 0
v_max_id_clo_res 824 824 0 0.00 0 2094 17 0 0
v_max_id_ord_sup 4594 4594 0 0.00 0 2230 3 0 0
v_max_non_paid_invoice 1027 1027 0 0.00 0 776 4 0 0
v_max_non_paid_realizn 2833 2833 0 0.00 0 6773 7 0 0
v_min_id_clo_ord 4580 4580 0 0.00 0 8105 11 0 0
v_min_id_clo_res 824 824 0 0.00 0 6367 11 0 0
v_min_id_ord_sup 4594 4594 0 0.00 0 7044 7 0 0
v_min_non_paid_invoice 4889 4889 0 0.00 0 13494 31 0 0
v_min_non_paid_realizn 5934 5934 0 0.00 0 13312 30 0 0
v_our_firm 8498 8498 0 0.00 0 20 1 0 0
v_reserve_write_off 16644 16644 0 0.00 0 11967 11 0 0
x_lock_depdocs_on_canc_invoice 9296 9296 0 0.00 0 17229 144 0 0
x_lock_depdocs_on_canc_sup_ord 344 344 0 0.00 0 19926 404 0 0
x_make_qstorno_1000_1200 4580 4580 0 0.00 1 43343 1319 0 0
x_make_qstorno_1200_2000 4594 4594 0 0.00 3 57982 3057 0 0
x_make_qstorno_2100_3300 384417 384417 0 0.00 0 46609 175 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-02-2024 19:11:02 to 20-02-2024 19:11:06.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:38 7 8192000000 8809906224 8825049088 14313488 0.174 5 1 2 0 14458208 70192 74528
17:10:39 19999 8192000000 9899177440 10208796672 983081728 10.714 100 87 174 0 1010991648 5397088 22512832
17:12:03 9236 8192000000 9927680608 10252623872 1019655536 11.069 100 82 165 0 1048375680 7455456 21264688
17:13:17 13782 8192000000 9972924976 10301181952 1057724144 11.435 100 88 176 0 1088722832 8663216 22335472
17:14:38 12893 8192000000 10015358384 10357604352 1106327600 11.898 100 82 164 0 1135954384 9746400 19880384
17:15:55 9407 8192000000 10060467216 10415423488 1153922832 12.346 100 76 152 0 1183044352 11435248 17686272
17:17:12 5296 8192000000 10104497488 10467999744 1191512672 12.697 100 80 158 1 1222809424 13421520 17875232
17:18:23 2825 8192000000 10132897184 10508181504 1223519024 12.994 100 79 156 1 1253307632 12261216 17527392
17:19:27 3353 8192000000 10160138144 10546966528 1252453248 13.261 100 68 136 0 1279401200 10813824 16134128
17:20:33 1333 8192000000 10209902016 10592264192 1285682528 13.565 100 87 176 1 1317718448 13270176 18765744
17:21:37 30139 8192000000 10198044816 10592501760 1294614400 13.646 100 58 118 1 1317231552 9604288 13012864
17:23:09 6189 8192000000 10195023872 10602586112 1304732336 13.738 100 31 62 0 1319034304 7408912 6893056
17:24:17 7955 8192000000 10205891728 10614280192 1319260800 13.870 100 28 56 1 1335525888 10059152 6205936
17:25:27 13993 8192000000 10211375808 10622586880 1322262688 13.897 100 17 35 0 1331393744 5426560 3704496
17:26:42 22368 8192000000 10211140208 10635898880 1327583328 13.945 100 16 32 0 1336556336 5421424 3551584
17:28:05 4197 8192000000 10229541264 10646765568 1333589184 14.000 100 31 63 0 1346743856 5977008 7177664
17:29:10 6401 8192000000 10208709888 10631614464 1306153872 13.751 98 8 16 0 1313715456 5637040 1924544
17:30:23 14768 8192000000 10234908352 10646614016 1332178720 13.987 100 40 79 0 1353150736 12007520 8964496
17:31:56 91693 8192000000 10241020592 10658910208 1304379808 13.735 96 36 72 0 1321895856 9474912 8041136
17:34:43 32945 8192000000 10207619744 10619637760 1269407696 13.416 95 30 60 1 1288271744 11693008 7171040
17:36:37 35618 8192000000 10224141360 10637279232 1300356208 13.698 98 38 75 0 1322797488 14008688 8432592
17:38:22 5158 8192000000 10246529328 10646835200 1301162576 13.706 97 48 96 0 1331807584 19529008 11116000
17:39:37 41565 8192000000 10223813664 10624417792 1261385776 13.343 94 34 69 0 1288013280 18677488 7950016
17:41:22 12971 8192000000 10242710976 10651156480 1292345088 13.626 97 43 86 0 1328776576 25400704 11030784
17:42:38 8256 8192000000 10257027872 10655985664 1299094624 13.687 97 58 114 0 1336686192 24123696 13467872
17:43:52 2896 8192000000 10257780304 10661457920 1321647888 13.892 99 55 107 0 1367099392 31913120 13538384
17:45:07 3337 8192000000 10261926304 10665836544 1332059456 13.986 100 57 114 2 1376473328 30186992 14226880
17:46:16 6276 8192000000 10282775344 10689851392 1340738304 14.064 100 58 116 0 1393145984 37310192 15097488
17:47:29 5290 8192000000 10325237808 10729463808 1373098416 14.355 100 76 149 0 1436152880 44883104 18171360
17:48:38 6376 8192000000 10338601088 10742317056 1378994336 14.408 100 77 153 1 1444507680 46968992 18544352
17:49:47 11616 8192000000 10329486336 10750386176 1387772896 14.486 100 37 72 0 1439463344 42724848 8965600
17:51:02 4506 8192000000 10361972976 10779242496 1395040896 14.551 100 64 123 0 1464942496 53625264 16276336
17:52:23 17274 8192000000 10346375904 10778951680 1403477648 14.626 100 35 69 1 1461283072 48734432 9070992
17:53:53 8884 8192000000 10366103952 10798260224 1408163568 14.668 100 34 68 0 1475037872 57368912 9505392
17:55:32 7323 8192000000 10371612160 10802491392 1409409568 14.679 100 42 82 0 1478826944 57712112 11705264
17:56:51 13314 8192000000 10371146400 10809069568 1403111792 14.623 100 31 62 0 1475680640 63709632 8859216
17:58:06 22834 8192000000 10335403488 10781974528 1397482368 14.573 100 26 52 2 1450452816 45513360 7457088
17:59:32 2577 8192000000 10351102480 10773782528 1401072160 14.605 100 67 127 0 1445082576 28156336 15854080
18:00:38 26239 8192000000 10332628240 10780073984 1410646368 14.690 100 20 40 0 1437214880 21445968 5122544
18:02:47 92450 8192000000 10303384576 10761490432 1400750080 14.602 100 25 50 0 1424725072 18107056 5867936
18:05:21 30638 8192000000 10313683296 10769203200 1409035616 14.675 100 18 36 0 1423663536 10669584 3958336
18:07:15 40036 8192000000 10325269232 10787233792 1418478544 14.759 100 22 44 1 1441748000 18173760 5095696
18:08:56 32431 8192000000 10317602752 10776485888 1412811456 14.709 100 11 22 0 1425981328 11204528 1965344
18:10:29 9824 8192000000 10304140192 10756087808 1403272768 14.624 100 56 112 0 1425252288 9159520 12820000
18:11:59 54872 8192000000 10295589008 10755563520 1376860896 14.388 98 10 20 0 1389831920 11153104 1817920
18:13:55 92281 8192000000 10299682304 10755084288 1398504000 14.582 100 33 67 0 1414930160 8604592 7821568
18:16:31 35436 8192000000 10281872048 10747445248 1381045328 14.426 99 11 22 0 1396739552 13472400 2221824
18:18:08 57934 8192000000 10289816080 10755616768 1386128256 14.471 99 8 16 1 1397515632 9666480 1720896
18:20:30 43112 8192000000 10268045504 10730983424 1333055728 13.995 96 14 29 0 1346367184 9873760 3437696
18:22:14 61126 8192000000 10261134720 10715086848 1332265472 13.988 97 14 28 0 1345486912 9505664 3715776
18:24:17 45439 8192000000 10257084352 10707001344 1324630640 13.919 97 22 44 0 1337654624 8432128 4591856
18:26:16 33002 8192000000 10242404016 10675650560 1284012320 13.550 94 32 64 0 1300505152 9566960 6925872
18:27:52 83183 8192000000 10237560400 10674696192 1244362608 13.186 93 10 20 0 1259452400 12944736 2145056
18:30:16 44534 8192000000 10242083184 10680348672 1295113888 13.651 97 38 76 1 1317041904 12929344 8998672
18:32:11 39839 8192000000 10259926624 10688798720 1290550592 13.609 96 37 74 0 1320188448 21679312 7958544
18:33:51 35710 8192000000 10251955488 10692435968 1335638496 14.018 100 18 36 0 1358747280 18752992 4355792
18:36:00 112969 8192000000 10224051232 10665766912 1301195680 13.706 98 21 40 0 1322203472 16604944 4402848
18:39:20 54163 8192000000 10230074784 10682040320 1334937920 14.012 100 16 32 0 1350587440 12069856 3579664
18:41:15 52472 8192000000 10255591360 10697994240 1357245152 14.213 100 17 34 1 1371151776 10037072 3869552
18:43:08 40852 8192000000 10267544912 10712301568 1350381184 14.151 99 16 32 0 1368320368 14803360 3135824
18:44:57 57670 8192000000 10301060256 10738745344 1378898448 14.407 100 27 54 0 1409452464 24420400 6133616
18:46:56 74931 8192000000 10285431792 10751819776 1376530448 14.386 100 11 22 0 1393074416 14071104 2472864
18:49:11 58450 8192000000 10314668192 10750922752 1391979456 14.524 100 31 63 2 1408441760 8847984 7614320
18:51:14 29096 8192000000 10304489728 10745028608 1390289200 14.508 100 30 61 0 1406690016 9976752 6424064
18:52:45 81130 8192000000 10308481600 10765164544 1404656192 14.636 100 29 58 0 1432229552 20939376 6633984
18:55:07 36076 8192000000 10338734448 10787258368 1404957744 14.639 100 39 78 0 1434653136 20810816 8884576
18:57:00 67677 8192000000 10305764400 10755952640 1390117856 14.507 99 18 36 0 1405872000 11715312 4038832
18:59:08 109999 8192000000 10314185840 10754269184 1376522896 14.385 98 21 42 0 1390694160 9650688 4520576
19:02:00 43051 8192000000 10294236320 10753462272 1377253376 14.392 98 28 56 0 1395624528 11918608 6452544
19:04:40 65898 8192000000 10276641520 10728890368 1344283120 14.096 97 15 30 0 1355748800 7493968 3971712
19:06:46 71924 8192000000 10276464576 10737782784 1368969888 14.318 99 17 34 0 1385155280 12159680 4025712
19:09:07 29859 8192000000 9490317408 9854865408 591234672 6.731 43 19 38 0 598596560 3586448 3775440

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 20-02-2024 19:11:08 to 20-02-2024 19:11:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 129 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 20-02-2024 19:11:23 to 20-02-2024 19:11:25.

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          172958
MON$OLDEST_ACTIVE               172959
MON$OLDEST_SNAPSHOT             172959
MON$NEXT_TRANSACTION            172959
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                       1905248
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.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Tue Feb 20 19:11:26 2024 
 
Database header page information: 
    Flags            0 
    Generation        90512 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    172958 
    Oldest active        172959 
    Oldest snapshot        172959 
    Next transaction    172960 
    Sequence number        0 
    Next attachment ID    707 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.33, total records: 7702634 
    Average version length: 48.17, total versions: 90605, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 86672 
    Data pages: 86672, average fill: 71% 
    Primary pages: 86672, secondary pages: 0, swept pages: 21374 
    Empty pages: 5, full pages: 62383 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 238 
    40 - 59% = 3696 
    60 - 79% = 82694 
    80 - 99% = 21 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23093, nodes: 7702634 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1694406, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 344 
        20 - 39% = 1896 
        40 - 59% = 3802 
        60 - 79% = 2536 
        80 - 99% = 14515 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13410, nodes: 7702634 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1517395, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1649 
        40 - 59% = 1846 
        60 - 79% = 1159 
        80 - 99% = 8755 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8249, nodes: 7702634 
    Average node length: 6.61, total dup: 5773638, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1510282, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 1000 
        40 - 59% = 1246 
        60 - 79% = 1009 
        80 - 99% = 4877 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.21, total records: 2219134 
    Average version length: 34.53, total versions: 93443, max versions: 3 
    Average fragment length: 7.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28648 
    Data pages: 28648, average fill: 72% 
    Primary pages: 28639, secondary pages: 9, swept pages: 11791 
    Empty pages: 9, full pages: 19138 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 234 
    40 - 59% = 2907 
    60 - 79% = 24806 
    80 - 99% = 668 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4499, nodes: 2219134 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 679844, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 910 
        40 - 59% = 802 
        60 - 79% = 763 
        80 - 99% = 2024 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2518, nodes: 2221428 
    Average node length: 4.97, total dup: 2220529, max dup: 19246 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1230575, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 284 
        40 - 59% = 1564 
        60 - 79% = 491 
        80 - 99% = 178 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2040, nodes: 2219134 
    Average node length: 4.97, total dup: 2219084, max dup: 130225 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056674, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 169 
        40 - 59% = 979 
        60 - 79% = 97 
        80 - 99% = 791 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4298, nodes: 2219134 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 679844, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 87 
        20 - 39% = 611 
        40 - 59% = 575 
        60 - 79% = 860 
        80 - 99% = 2165 
 
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.53, total records: 400 
    Average version length: 23.17, total versions: 215817, max versions: 562 
    Average fragment length: 2.00, total fragments: 41, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1200 
    Data pages: 1200, average fill: 90% 
    Primary pages: 12, secondary pages: 1188, swept pages: 0 
    Empty pages: 5, full pages: 1194 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1193 
 
    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: 3.82, total records: 64993 
    Average version length: 68.30, total versions: 61357, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 23.04 
    Pointer pages: 7, data page slots: 3616 
    Data pages: 1304, average fill: 63% 
    Primary pages: 1303, secondary pages: 1, swept pages: 0 
    Empty pages: 164, full pages: 714 
    Fill distribution: 
     0 - 19% = 241 
    20 - 39% = 123 
    40 - 59% = 134 
    60 - 79% = 146 
    80 - 99% = 660 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700593, depth: 3, leaf buckets: 296, nodes: 64993 
    Average node length: 13.23, total dup: 5062, max dup: 1 
    Average key length: 10.70, compression ratio: 2.52 
    Average prefix length: 19.22, average data length: 7.78 
    Clustering factor: 46863, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 203 
        40 - 59% = 79 
        60 - 79% = 13 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18194, max versions: 958 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 91% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.35, total records: 1118 
    Average version length: 43.63, total versions: 1030, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 17.29 
    Pointer pages: 1, data page slots: 24 
    Data pages: 23, average fill: 48% 
    Primary pages: 22, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 5 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 5 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90523, depth: 2, leaf buckets: 4, nodes: 1118 
    Average node length: 4.68, total dup: 1020, max dup: 119 
    Average key length: 2.95, compression ratio: 6.45 
    Average prefix length: 18.14, average data length: 0.86 
    Clustering factor: 589, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        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: 97.00, 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: 36.35, total records: 833125 
    Average version length: 25.47, total versions: 60256, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8472 
    Data pages: 8472, average fill: 68% 
    Primary pages: 8429, secondary pages: 43, swept pages: 2154 
    Empty pages: 102, full pages: 7042 
    Fill distribution: 
     0 - 19% = 202 
    20 - 39% = 159 
    40 - 59% = 321 
    60 - 79% = 7571 
    80 - 99% = 219 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 927, nodes: 833125 
    Average node length: 4.87, total dup: 833076, max dup: 161402 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90463, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 150 
        40 - 59% = 516 
        60 - 79% = 193 
        80 - 99% = 66 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1023, nodes: 833125 
    Average node length: 5.88, total dup: 742092, max dup: 42 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163914, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 121 
        40 - 59% = 533 
        60 - 79% = 90 
        80 - 99% = 273 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1063, nodes: 833125 
    Average node length: 5.88, total dup: 742092, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165929, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 211 
        40 - 59% = 512 
        60 - 79% = 74 
        80 - 99% = 266 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1184, nodes: 833125 
    Average node length: 5.96, total dup: 742092, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158226, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 266 
        40 - 59% = 616 
        60 - 79% = 210 
        80 - 99% = 90 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5455 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.81, total fragments: 53, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 112 
    Data pages: 95, average fill: 57% 
    Primary pages: 80, secondary pages: 15, swept pages: 51 
    Empty pages: 16, full pages: 64 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5455 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.03 
    Average prefix length: 34.43, average data length: 1.55 
    Clustering factor: 5104, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5455 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 143, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 78432 
    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: 760 
    Data pages: 760, average fill: 71% 
    Primary pages: 760, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 755 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 756 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 29370, depth: 2, leaf buckets: 99, nodes: 78432 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3333, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, 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: 149.88, total records: 168903 
    Average version length: 149.95, total versions: 1536, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 8, data page slots: 4408 
    Data pages: 4048, average fill: 86% 
    Primary pages: 4048, secondary pages: 0, swept pages: 3 
    Empty pages: 35, full pages: 4004 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 4004 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.21, total records: 162897 
    Average version length: 149.70, total versions: 848, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 5048 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3919, secondary pages: 1, swept pages: 4 
    Empty pages: 53, full pages: 3854 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3854 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.41, total records: 170627 
    Average version length: 152.23, total versions: 2893, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 6, data page slots: 5496 
    Data pages: 4080, average fill: 86% 
    Primary pages: 4079, secondary pages: 1, swept pages: 3 
    Empty pages: 34, full pages: 4035 
    Fill distribution: 
     0 - 19% = 36 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 4036 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 147.25, total records: 161002 
    Average version length: 152.57, total versions: 3818, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.52 
    Pointer pages: 6, data page slots: 5608 
    Data pages: 3872, average fill: 86% 
    Primary pages: 3871, secondary pages: 1, swept pages: 2 
    Empty pages: 50, full pages: 3802 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 3803 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 132.73, total records: 183312 
    Average version length: 154.74, total versions: 22662, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.78 
    Pointer pages: 8, data page slots: 6480 
    Data pages: 4488, average fill: 85% 
    Primary pages: 4487, secondary pages: 1, swept pages: 6 
    Empty pages: 111, full pages: 4352 
    Fill distribution: 
     0 - 19% = 112 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 14 
    80 - 99% = 4349 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 150.77, total records: 160288 
    Average version length: 139.10, total versions: 210, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 6, data page slots: 4232 
    Data pages: 3824, average fill: 86% 
    Primary pages: 3824, secondary pages: 0, swept pages: 5 
    Empty pages: 23, full pages: 3794 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3791 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 148.60, total records: 163517 
    Average version length: 152.48, total versions: 2498, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 6064 
    Data pages: 3984, average fill: 85% 
    Primary pages: 3984, secondary pages: 0, swept pages: 2 
    Empty pages: 99, full pages: 3858 
    Fill distribution: 
     0 - 19% = 101 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 3860 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 150.27, total records: 163547 
    Average version length: 148.93, total versions: 711, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 8, data page slots: 4376 
    Data pages: 3936, average fill: 85% 
    Primary pages: 3936, secondary pages: 0, swept pages: 6 
    Empty pages: 55, full pages: 3864 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3865 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.28, total records: 172752 
    Average version length: 151.85, total versions: 2059, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 9, data page slots: 4752 
    Data pages: 4136, average fill: 86% 
    Primary pages: 4136, secondary pages: 0, swept pages: 5 
    Empty pages: 34, full pages: 4090 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4090 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.43, total records: 157364 
    Average version length: 149.00, total versions: 1393, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 8, data page slots: 5264 
    Data pages: 3752, average fill: 86% 
    Primary pages: 3752, secondary pages: 0, swept pages: 5 
    Empty pages: 23, full pages: 3717 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3718 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.75, total records: 2074087 
    Average version length: 52.96, total versions: 39586, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25504 
    Data pages: 25504, average fill: 70% 
    Primary pages: 25504, secondary pages: 0, swept pages: 11529 
    Empty pages: 386, full pages: 19655 
    Fill distribution: 
     0 - 19% = 676 
    20 - 39% = 527 
    40 - 59% = 1312 
    60 - 79% = 22671 
    80 - 99% = 318 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2566, nodes: 2074087 
    Average node length: 5.45, total dup: 1933942, max dup: 1564 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180232, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 301 
        40 - 59% = 1682 
        60 - 79% = 297 
        80 - 99% = 284 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2753, nodes: 2074087 
    Average node length: 5.69, total dup: 1861253, max dup: 65 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371469, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 3 
        40 - 59% = 2456 
        60 - 79% = 270 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2118, nodes: 2074087 
    Average node length: 4.96, total dup: 2073987, max dup: 27497 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 178272, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 174 
        40 - 59% = 1181 
        60 - 79% = 357 
        80 - 99% = 402 
 
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: 41.61, total records: 133129 
    Average version length: 69.16, total versions: 53107, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.03 
    Pointer pages: 3, data page slots: 4352 
    Data pages: 3056, average fill: 50% 
    Primary pages: 3056, secondary pages: 0, swept pages: 564 
    Empty pages: 653, full pages: 1573 
    Fill distribution: 
     0 - 19% = 983 
    20 - 39% = 262 
    40 - 59% = 137 
    60 - 79% = 578 
    80 - 99% = 1096 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102001, depth: 3, leaf buckets: 209, nodes: 133129 
    Average node length: 6.37, total dup: 115936, max dup: 15 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 22483, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 54 
        40 - 59% = 95 
        60 - 79% = 52 
        80 - 99% = 8 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.02, total records: 7251464 
    Average version length: 68.75, total versions: 308063, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 65, data page slots: 104688 
    Data pages: 104688, average fill: 74% 
    Primary pages: 104688, secondary pages: 0, swept pages: 35864 
    Empty pages: 14, full pages: 79651 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 729 
    40 - 59% = 6779 
    60 - 79% = 92660 
    80 - 99% = 4434 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10736, nodes: 7251464 
    Average node length: 6.51, total dup: 6271573, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1619030, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1451 
        40 - 59% = 5698 
        60 - 79% = 2977 
        80 - 99% = 603 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8606, nodes: 7251464 
    Average node length: 5.39, total dup: 6965782, max dup: 200 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1411307, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 990 
        40 - 59% = 4823 
        60 - 79% = 1743 
        80 - 99% = 1041 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8664, nodes: 7251464 
    Average node length: 5.39, total dup: 6965782, max dup: 200 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1413764, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1069 
        40 - 59% = 4825 
        60 - 79% = 1720 
        80 - 99% = 1046 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.53, total records: 12183886 
    Average version length: 68.72, total versions: 250831, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 105, data page slots: 170024 
    Data pages: 170024, average fill: 76% 
    Primary pages: 170024, secondary pages: 0, swept pages: 85258 
    Empty pages: 4, full pages: 154592 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 566 
    40 - 59% = 4004 
    60 - 79% = 161226 
    80 - 99% = 4202 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18428, nodes: 12183886 
    Average node length: 6.59, total dup: 10618971, max dup: 75 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2385543, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2223 
        40 - 59% = 10665 
        60 - 79% = 4652 
        80 - 99% = 865 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 45.53, total records: 1546680 
    Average version length: 69.09, total versions: 528394, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.77 
    Pointer pages: 27, data page slots: 42912 
    Data pages: 28845, average fill: 61% 
    Primary pages: 28845, secondary pages: 0, swept pages: 9110 
    Empty pages: 3453, full pages: 17821 
    Fill distribution: 
     0 - 19% = 5486 
    20 - 39% = 2081 
    40 - 59% = 1828 
    60 - 79% = 11272 
    80 - 99% = 8178 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2248, nodes: 1546680 
    Average node length: 5.53, total dup: 1483523, max dup: 99 
    Average key length: 2.57, compression ratio: 16.36 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 103378, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 724 
        40 - 59% = 1123 
        60 - 79% = 330 
        80 - 99% = 61 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 43.14, total records: 1079601 
    Average version length: 69.15, total versions: 404860, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.92 
    Pointer pages: 24, data page slots: 38192 
    Data pages: 28992, average fill: 43% 
    Primary pages: 28992, secondary pages: 0, swept pages: 7761 
    Empty pages: 6124, full pages: 9745 
    Fill distribution: 
     0 - 19% = 10163 
    20 - 39% = 4042 
    40 - 59% = 3020 
    60 - 79% = 5126 
    80 - 99% = 6641 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1619, nodes: 1079601 
    Average node length: 5.81, total dup: 1005495, max dup: 99 
    Average key length: 2.89, compression ratio: 14.55 
    Average prefix length: 41.18, average data length: 0.82 
    Clustering factor: 151488, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 522 
        40 - 59% = 748 
        60 - 79% = 309 
        80 - 99% = 39 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.69, total records: 8911126 
    Average version length: 68.98, total versions: 414596, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 88, data page slots: 142872 
    Data pages: 142840, average fill: 67% 
    Primary pages: 142839, secondary pages: 1, swept pages: 69021 
    Empty pages: 432, full pages: 66948 
    Fill distribution: 
     0 - 19% = 1463 
    20 - 39% = 7509 
    40 - 59% = 27164 
    60 - 79% = 101048 
    80 - 99% = 5656 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13458, nodes: 8911126 
    Average node length: 6.68, total dup: 7391424, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1896366, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1546 
        40 - 59% = 7259 
        60 - 79% = 4174 
        80 - 99% = 477 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21128398 
    Average version length: 83.02, total versions: 11228, 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: 318528 
    Data pages: 318528, average fill: 81% 
    Primary pages: 318528, secondary pages: 0, swept pages: 12878 
    Empty pages: 37, full pages: 317462 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 50 
    40 - 59% = 152 
    60 - 79% = 27673 
    80 - 99% = 290591 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19618, nodes: 21128398 
    Average node length: 5.72, total dup: 20648025, max dup: 129 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277388, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8675 
        60 - 79% = 513 
        80 - 99% = 10425 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17159, nodes: 21128398 
    Average node length: 6.31, total dup: 18566891, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914320, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 794 
        60 - 79% = 273 
        80 - 99% = 16087 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21374, nodes: 21128398 
    Average node length: 6.35, total dup: 18486868, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571972, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 8879 
        60 - 79% = 610 
        80 - 99% = 11884 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16072, nodes: 21128398 
    Average node length: 5.56, total dup: 21128298, max dup: 229717 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943056, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 9 
        40 - 59% = 2888 
        60 - 79% = 359 
        80 - 99% = 12816 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.77, total records: 9365490 
    Average version length: 82.64, total versions: 412681, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 103, data page slots: 167760 
    Data pages: 167704, average fill: 69% 
    Primary pages: 167704, secondary pages: 0, swept pages: 85749 
    Empty pages: 461, full pages: 87843 
    Fill distribution: 
     0 - 19% = 1575 
    20 - 39% = 8089 
    40 - 59% = 29085 
    60 - 79% = 76737 
    80 - 99% = 52218 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11323, nodes: 9365490 
    Average node length: 5.36, total dup: 9059106, max dup: 187 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2052241, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 110 
        40 - 59% = 8974 
        60 - 79% = 2198 
        80 - 99% = 39 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13061, nodes: 9365490 
    Average node length: 6.22, total dup: 7763517, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1408979, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 97 
        20 - 39% = 3956 
        40 - 59% = 4030 
        60 - 79% = 2643 
        80 - 99% = 2335 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12638, nodes: 9365490 
    Average node length: 5.98, total dup: 8119048, max dup: 39 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2236774, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 126 
        40 - 59% = 10059 
        60 - 79% = 2400 
        80 - 99% = 50 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9821, nodes: 9365490 
    Average node length: 5.12, total dup: 9365390, max dup: 149430 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1446966, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1283 
        40 - 59% = 4802 
        60 - 79% = 1683 
        80 - 99% = 2005 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.96, total records: 11073052 
    Average version length: 82.55, total versions: 314384, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 118, data page slots: 190992 
    Data pages: 189768, average fill: 72% 
    Primary pages: 189768, secondary pages: 0, swept pages: 77101 
    Empty pages: 3553, full pages: 136131 
    Fill distribution: 
     0 - 19% = 6124 
    20 - 39% = 8757 
    40 - 59% = 19567 
    60 - 79% = 44614 
    80 - 99% = 110706 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13113, nodes: 11073052 
    Average node length: 5.30, total dup: 10963466, max dup: 636 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2304174, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 226 
        40 - 59% = 9594 
        60 - 79% = 3156 
        80 - 99% = 134 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10283, nodes: 11073052 
    Average node length: 5.49, total dup: 10588806, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 693386, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 901 
        40 - 59% = 2496 
        60 - 79% = 1821 
        80 - 99% = 4905 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14991, nodes: 11073052 
    Average node length: 6.03, total dup: 9656016, max dup: 81 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2320519, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 278 
        40 - 59% = 11091 
        60 - 79% = 3469 
        80 - 99% = 151 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10554, nodes: 11073052 
    Average node length: 5.22, total dup: 11072952, max dup: 171758 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 682885, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 93 
        20 - 39% = 871 
        40 - 59% = 4668 
        60 - 79% = 1446 
        80 - 99% = 3476 
 
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: 79.42, total records: 9443916 
    Average version length: 82.94, total versions: 378275, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 105, data page slots: 171264 
    Data pages: 171216, average fill: 68% 
    Primary pages: 171216, secondary pages: 0, swept pages: 94583 
    Empty pages: 643, full pages: 85508 
    Fill distribution: 
     0 - 19% = 2041 
    20 - 39% = 8803 
    40 - 59% = 30649 
    60 - 79% = 80170 
    80 - 99% = 49553 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11566, nodes: 9443916 
    Average node length: 5.17, total dup: 9414871, max dup: 2084 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1852367, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1578 
        40 - 59% = 7757 
        60 - 79% = 1704 
        80 - 99% = 495 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13162, nodes: 9443916 
    Average node length: 6.24, total dup: 7828087, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1375883, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 175 
        20 - 39% = 3942 
        40 - 59% = 3947 
        60 - 79% = 2645 
        80 - 99% = 2453 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12186, nodes: 9443916 
    Average node length: 5.42, total dup: 9016036, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1983336, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1535 
        40 - 59% = 8588 
        60 - 79% = 1511 
        80 - 99% = 515 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 9980, nodes: 9443916 
    Average node length: 5.14, total dup: 9443816, max dup: 141403 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1463280, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1372 
        40 - 59% = 4878 
        60 - 79% = 1693 
        80 - 99% = 1999 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.47, total records: 575000 
    Average version length: 68.77, total versions: 5889, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7968 
    Data pages: 7968, average fill: 76% 
    Primary pages: 7968, secondary pages: 0, swept pages: 3941 
    Empty pages: 7, full pages: 6769 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 15 
    40 - 59% = 182 
    60 - 79% = 7667 
    80 - 99% = 96 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 34961, depth: 3, leaf buckets: 742, nodes: 575000 
    Average node length: 5.95, total dup: 489576, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100187, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 535 
        60 - 79% = 95 
        80 - 99% = 84 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28049, depth: 3, leaf buckets: 771, nodes: 575000 
    Average node length: 6.15, total dup: 471502, max dup: 19 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100241, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 565 
        60 - 79% = 89 
        80 - 99% = 86 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 572, nodes: 575000 
    Average node length: 4.86, total dup: 574900, max dup: 9805 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88925, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 345 
        60 - 79% = 87 
        80 - 99% = 110 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Feb 20 19:11:50 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7702634 90605 1 0.0000 0.0000
DOC_LIST 2219134 93443 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 215817 562 53900.0000 0.0000
INVNT_TURNOVER_LOG 64993 61357 1 0.0000 0.0000
MONEY_SALDO 49 18194 958 37100.0000 0.0000
MONEY_TURNOVER_LOG 1118 1030 1 0.0000 0.0000
PDISTR 833125 60256 4 0.0000 0.0000
PERF_SPLIT_0 168903 1536 1 0.0000 0.0000
PERF_SPLIT_1 162897 848 1 0.0000 0.0000
PERF_SPLIT_2 170627 2893 1 0.0000 0.0000
PERF_SPLIT_3 161002 3818 1 0.0000 0.0000
PERF_SPLIT_4 183312 22662 1 0.0000 0.0000
PERF_SPLIT_5 160288 210 1 0.0000 0.0000
PERF_SPLIT_6 163517 2498 1 0.0000 0.0000
PERF_SPLIT_7 163547 711 1 0.0000 0.0000
PERF_SPLIT_8 172752 2059 1 0.0000 0.0000
PERF_SPLIT_9 157364 1393 1 0.0000 0.0000
PSTORNED 2074087 39586 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 133129 53107 1 0.0000 0.0000
XQD_1000_3300 7251464 308063 1 0.0000 0.0000
XQD_1200_2000 12183886 250831 1 0.0000 0.0000
XQD_2000_3300 1546680 528394 1 0.0000 0.0000
XQD_2100_3300 1079601 404860 1 0.0000 0.0000
XQD_3300_3400 8911126 414596 1 0.0000 0.0000
XQS_1000_1200 21128398 11228 1 0.0000 0.0000
XQS_1000_3300 9365490 412681 1 0.0000 0.0000
XQS_1200_2000 11073052 314384 1 0.0000 0.0000
XQS_2100_3300 9443916 378275 1 0.0000 0.0000
XQS_3300_3400 575000 5889 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 ---
:877: 
:878: mscs-test-161.budzdorov.ru    Tue Feb 20 19:09:38 2024
:879:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:880: 
:881: 
:882: mscs-test-161.budzdorov.ru    Tue Feb 20 19:09:38 2024
:883:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:884: 
:885: 
:886: mscs-test-161.budzdorov.ru    Tue Feb 20 19:09:39 2024
:887:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:888: 
--- end of diff output ---

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

20.02.24 19:12:01. 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-02-20 19:12:04 No severe PSQL-related problems occured
20.02.24 19:12:05. End of report.