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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-08 19:09:39
DTS_END                         2024-03-08 19:09:39.6740
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/60684
TRN_ID                          178549
ATT_ID                          575
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: 9246.07 22830 924607
customer order: creation 181.83 368 18183
customer order: refuse 15.07 385 1507
order to supplier: creation 48.25 1414 4825
order to supplier: removal 3.43 97937 343
invoice (draft): creation 47.77 3464 4777
invoice (draft): removal 48.59 859 4859
invoice accept: apply 43.00 24299 4300
invoice accept: cancel 43.86 1003 4386
customer reserve: creation 4189.08 231 418908
customer reserve: removal 4323.56 61 432356
realization accept: apply 87.71 187 8771
realization accept: cancel 78.47 124 7847
payment from customer: creation 61.60 138 6160
payment from customer: removal 6.20 87 620
payment to supplier: creation 51.62 154 5162
payment to supplier: removal 3.38 92 338
service: total inventory turnovers 4.74 1227 474
service: total monetary turnovers 6.95 32 695
service: aggregate perf. data 0.93 16510 93
service: refresh index statistics 0.03 308033 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-03-2024 19:10:31 to 08-03-2024 19:10:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3326
TEST_TIME 2 3562
TEST_TIME 3 4313
TEST_TIME 4 3782
TEST_TIME 5 4423
TEST_TIME 6 4701
TEST_TIME 7 4979
TEST_TIME 8 5019
TEST_TIME 9 5204
TEST_TIME 10 5161
TEST_TIME 11 5236
TEST_TIME 12 5626
TEST_TIME 13 5865
TEST_TIME 14 5937
TEST_TIME 15 5917
TEST_TIME 16 5980
TEST_TIME 17 6075
TEST_TIME 18 6313
TEST_TIME 19 6455
TEST_TIME 20 6711
TEST_TIME 21 6888
TEST_TIME 22 7510
TEST_TIME 23 7533
TEST_TIME 24 7694
TEST_TIME 25 7778
TEST_TIME 26 7767
TEST_TIME 27 7971
TEST_TIME 28 8079
TEST_TIME 29 8736
TEST_TIME 30 8845
TEST_TIME 31 9098
TEST_TIME 32 8933
TEST_TIME 33 8818
TEST_TIME 34 8749
TEST_TIME 35 8633
TEST_TIME 36 8931
TEST_TIME 37 8756
TEST_TIME 38 8760
TEST_TIME 39 8835
TEST_TIME 40 8756
TEST_TIME 41 8821
TEST_TIME 42 8789
TEST_TIME 43 8820
TEST_TIME 44 8796
TEST_TIME 45 8761
TEST_TIME 46 8866
TEST_TIME 47 8868
TEST_TIME 48 8840
TEST_TIME 49 9079
TEST_TIME 50 9111
TEST_TIME 51 9109
TEST_TIME 52 9090
TEST_TIME 53 9314
TEST_TIME 54 9287
TEST_TIME 55 9207
TEST_TIME 56 9320
TEST_TIME 57 9407
TEST_TIME 58 9375
TEST_TIME 59 9398
TEST_TIME 60 9312
TEST_TIME 61 9218
TEST_TIME 62 9199
TEST_TIME 63 9163
TEST_TIME 64 9190
TEST_TIME 65 9180
TEST_TIME 66 9117
TEST_TIME 67 9094
TEST_TIME 68 9059
TEST_TIME 69 9110
TEST_TIME 70 9030
TEST_TIME 71 9057
TEST_TIME 72 9117
TEST_TIME 73 9085
TEST_TIME 74 9101
TEST_TIME 75 9285
TEST_TIME 76 9226
TEST_TIME 77 9200
TEST_TIME 78 9271
TEST_TIME 79 9251
TEST_TIME 80 9279
TEST_TIME 81 9333
TEST_TIME 82 9316
TEST_TIME 83 9306
TEST_TIME 84 9421
TEST_TIME 85 9327
TEST_TIME 86 9303
TEST_TIME 87 9278
TEST_TIME 88 9249
TEST_TIME 89 9256
TEST_TIME 90 9199
TEST_TIME 91 9168
TEST_TIME 92 9191
TEST_TIME 93 9195
TEST_TIME 94 9179
TEST_TIME 95 9164
TEST_TIME 96 9166
TEST_TIME 97 9217
TEST_TIME 98 9239
TEST_TIME 99 9249
TEST_TIME 100 9255

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-03-2024 19:10:35 to 08-03-2024 19:10:38.

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 1307721 1307721 0 0.00 0 13079 8 0 0
doc_list_biud 1307720 1307720 0 0.00 0 56439 26 0 0
sp_add_invoice_to_stock 4410 4300 110 2.49 47 250516 24300 0 110
sp_cancel_adding_invoice 4386 4386 0 0.00 4 49851 1004 0 0
sp_cancel_client_order 1507 1507 0 0.00 4 10305 386 0 0
sp_cancel_customer_reserve 432356 432356 0 0.00 0 56442 61 0 0
sp_cancel_pay_from_customer 620 620 0 0.00 3 6829 88 0 0
sp_cancel_pay_to_supplier 338 338 0 0.00 2 6650 92 0 0
sp_cancel_supplier_invoice 4870 4859 11 0.22 2 14802 859 0 11
sp_cancel_supplier_order 343 343 0 0.00 10 923873 97937 0 0
sp_cancel_write_off 7847 7847 0 0.00 1 11823 124 0 0
sp_client_order 18183 18183 0 0.00 3 19049 368 0 0
sp_customer_reserve 418908 418908 0 0.00 0 62880 232 0 0
sp_fill_shopping_cart 27781 27781 0 0.00 1 12445 35 0 0
sp_fill_shopping_cart_clo_res 418902 418902 0 0.00 0 20590 14 0 0
sp_get_clo_for_invoice 4290 4290 0 0.00 0 32018 264 0 0
sp_kill_cost_storno 13191 13191 0 0.00 0 7938 62 0 0
sp_kill_qstorno_ret_qs2qd 877761 877761 0 0.00 0 56434 34 0 0
sp_kill_qty_storno 464359 464359 0 0.00 0 56438 73 0 0
sp_lock_selected_doc 18070 18070 0 0.00 0 8449 7 0 0
sp_make_cost_storno 24383 24383 0 0.00 0 12186 62 0 0
sp_multiply_rows_for_pdistr 24382 24382 0 0.00 0 11115 33 0 0
sp_multiply_rows_for_qdistr 18183 18183 0 0.00 0 18117 154 0 0
sp_pay_from_customer 6160 6160 0 0.00 4 13518 138 0 0
sp_pay_to_supplier 5162 5162 0 0.00 5 13694 155 0 0
sp_payment_common 11321 11321 0 0.00 2 9232 28 0 0
sp_qd_handle_on_cancel_clo 1507 1507 0 0.00 0 10290 356 0 0
sp_qd_handle_on_invoice_upd_sts 8676 8676 0 0.00 0 36474 340 0 0
sp_qd_handle_on_reserve_upd_sts 8771 8771 0 0.00 0 19053 61 0 0
sp_reserve_write_off 8771 8771 0 0.00 7 19192 188 0 0
sp_supplier_invoice 4777 4777 0 0.00 8 78555 3464 0 0
sp_supplier_order 4825 4825 0 0.00 5 72675 1415 0 0
srv_aggregate_perf_data 93 93 0 0.00 1274 343400 16511 0 0
srv_fill_mon_cache_memory 62 62 0 0.00 1165 102012 31112 0 0
srv_find_qd_qs_mism 879904 879904 0 0.00 0 11615 8 0 0
srv_make_invnt_saldo 474 474 0 0.00 32 38208 1228 0 0
srv_make_money_saldo 695 695 0 0.00 1 1206 33 0 0
srv_recalc_idx_stat 3 3 0 0.00 210944 364097 308034 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4301 4301 0 0.00 0 11489 217 0 0
t$perf-norm:sp_cancel_adding_invoice 369 369 0 0.00 0 8407 127 0 0
t$perf-norm:sp_cancel_client_order 1507 1507 0 0.00 0 2123 13 0 0
t$perf-norm:sp_cancel_customer_reserve 577 577 0 0.00 0 1518 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 620 620 0 0.00 0 645 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 338 338 0 0.00 0 744 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 336 336 0 0.00 0 666 16 0 0
t$perf-norm:sp_cancel_supplier_order 343 343 0 0.00 0 23134 1733 0 0
t$perf-norm:sp_cancel_write_off 919 919 0 0.00 0 3624 15 0 0
t$perf-norm:sp_client_order 18183 18183 0 0.00 0 3807 15 0 0
t$perf-norm:sp_customer_reserve 830 830 0 0.00 0 2320 11 0 0
t$perf-norm:sp_pay_from_customer 6160 6160 0 0.00 0 2666 8 0 0
t$perf-norm:sp_pay_to_supplier 5162 5162 0 0.00 0 5855 11 0 0
t$perf-norm:sp_reserve_write_off 8771 8771 0 0.00 0 7308 14 0 0
t$perf-norm:sp_supplier_invoice 4777 4777 0 0.00 0 5480 20 0 0
t$perf-norm:sp_supplier_order 4825 4825 0 0.00 0 4326 20 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 270 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 62 62 0 0.00 0 47 2 0 0
t$perf-norm:srv_make_invnt_saldo 474 474 0 0.00 0 876 33 0 0
t$perf-norm:srv_make_money_saldo 695 695 0 0.00 0 1508 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 613 206 0 0
v_add_invoice_to_stock 8798 8578 220 2.50 0 3408 20 0 220
v_all_customers 33348 33348 0 0.00 0 20 1 0 0
v_all_suppliers 27506 27506 0 0.00 0 27 1 0 0
v_all_wares 36362 36362 0 0.00 0 68 1 0 0
v_cancel_adding_invoice 738 738 0 0.00 0 1303 11 0 0
v_cancel_client_order 3014 3014 0 0.00 0 1775 5 0 0
v_cancel_customer_prepayment 1240 1240 0 0.00 0 834 6 0 0
v_cancel_customer_reserve 1154 1154 0 0.00 0 964 5 0 0
v_cancel_payment_to_supplier 676 676 0 0.00 0 1685 9 0 0
v_cancel_supplier_invoice 694 672 22 3.17 0 1760 17 0 22
v_cancel_supplier_order 686 686 0 0.00 0 368 3 0 0
v_cancel_write_off 1838 1838 0 0.00 0 2468 14 0 0
v_max_id_clo_ord 4825 4825 0 0.00 0 1791 2 0 0
v_max_id_clo_res 830 830 0 0.00 0 1905 9 0 0
v_max_id_ord_sup 4775 4775 0 0.00 0 7250 6 0 0
v_max_non_paid_invoice 1008 1008 0 0.00 0 5668 8 0 0
v_max_non_paid_realizn 3222 3222 0 0.00 0 2779 6 0 0
v_min_id_clo_ord 4825 4825 0 0.00 0 6459 14 0 0
v_min_id_clo_res 830 830 0 0.00 0 1112 6 0 0
v_min_id_ord_sup 4775 4775 0 0.00 0 8022 11 0 0
v_min_non_paid_invoice 5161 5161 0 0.00 0 4286 17 0 0
v_min_non_paid_realizn 6160 6160 0 0.00 0 8655 22 0 0
v_our_firm 8890 8890 0 0.00 0 19 1 0 0
v_reserve_write_off 17542 17542 0 0.00 0 3745 7 0 0
x_lock_depdocs_on_canc_invoice 8909 8909 0 0.00 0 21150 148 0 0
x_lock_depdocs_on_canc_sup_ord 343 343 0 0.00 0 7079 333 0 0
x_make_qstorno_1000_1200 4825 4825 0 0.00 1 70719 1325 0 0
x_make_qstorno_1200_2000 4777 4777 0 0.00 4 78532 3345 0 0
x_make_qstorno_2100_3300 418908 418908 0 0.00 0 62878 214 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-03-2024 19:10:39 to 08-03-2024 19:10:43.

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:43 5 8192000000 8806333216 8820199424 11486256 0.140 4 2 3 0 11670640 77680 106704
17:10:44 30707 8192000000 9899878912 10207682560 973579568 10.622 100 91 182 0 1003824512 6134496 24110448
17:12:17 18472 8192000000 9939609696 10261704704 1026262512 11.132 100 91 182 0 1057343008 7568976 23511520
17:13:40 22185 8192000000 9981793344 10310406144 1056659216 11.424 100 84 169 0 1086298560 8685040 20954304
17:15:08 18767 8192000000 10017853456 10364321792 1108917792 11.922 100 74 148 0 1137034256 10935920 17180544
17:16:30 6117 8192000000 10066182672 10419167232 1151713712 12.326 100 74 148 1 1179939600 11348240 16877648
17:17:40 5443 8192000000 10105295344 10473529344 1199166144 12.769 100 74 144 0 1227086400 12116192 15804064
17:18:47 3040 8192000000 10151659488 10524151808 1238027120 13.128 100 76 152 0 1267644928 13335760 16282048
17:19:53 2454 8192000000 10183579680 10563481600 1267689648 13.400 100 86 167 0 1299633008 13659136 18284224
17:20:58 930 8192000000 10202605952 10586415104 1288790240 13.593 100 90 179 0 1323529360 14248112 20491008
17:22:03 6751 8192000000 10201710784 10597818368 1301935872 13.713 100 52 104 0 1323097984 9369968 11792144
17:23:10 6741 8192000000 10194029328 10608566272 1313496944 13.818 100 34 68 0 1327808224 6628288 7682992
17:24:18 8572 8192000000 10213424144 10625208320 1323713616 13.910 100 25 49 0 1335497616 6708096 5075904
17:25:27 4605 8192000000 10222042592 10641240064 1335448816 14.016 100 37 74 1 1350097792 6357776 8291200
17:26:33 55592 8192000000 10234811392 10657357824 1342645600 14.081 100 23 46 1 1357843312 10309680 4888032
17:28:28 3482 8192000000 10244116080 10663718912 1345743520 14.109 100 35 71 2 1360504576 6840208 7920848
17:29:34 15481 8192000000 10239288048 10655367168 1336942448 14.030 100 25 50 0 1352887952 10111888 5833616
17:30:59 6639 8192000000 10254833616 10671316992 1347964192 14.129 100 35 70 1 1364272976 8459168 7849616
17:32:15 58375 8192000000 10266243040 10690080768 1359971024 14.237 100 51 100 0 1383207984 10934752 12302208
17:34:16 13864 8192000000 10233974480 10650173440 1327931248 13.948 98 37 75 0 1345749376 9189520 8628608
17:35:33 25331 8192000000 10243282064 10656841728 1321412848 13.889 99 47 94 0 1342772208 10779664 10579696
17:37:06 4343 8192000000 10242317280 10646585344 1306103296 13.751 98 56 111 1 1332292336 13089120 13099920
17:38:15 6826 8192000000 10223769344 10630426624 1297853456 13.676 98 45 90 0 1325077504 16407088 10816960
17:39:40 6365 8192000000 10205001760 10605342720 1283282800 13.543 98 42 82 1 1308555072 15924528 9347744
17:40:50 24586 8192000000 10184391600 10589040640 1251659808 13.253 96 34 68 0 1276945888 16813792 8472288
17:42:22 10007 8192000000 10222072880 10625728512 1290191616 13.606 98 45 88 0 1315670336 14415040 11063680
17:43:35 4396 8192000000 10256598016 10657566720 1328623472 13.955 100 60 117 0 1363135920 20142448 14370000
17:44:45 5353 8192000000 10254454080 10650460160 1317558976 13.855 98 57 113 0 1352515456 21799856 13156624
17:45:57 2442 8192000000 10257315344 10643677184 1315570496 13.837 99 81 159 1 1359364624 24936736 18857392
17:47:06 2113 8192000000 10293124256 10691592192 1353906288 14.183 100 83 165 1 1402300928 27969504 20425136
17:48:14 1164 8192000000 10295552464 10696073216 1352278064 14.168 100 75 149 1 1399259984 28975344 18006576
17:49:20 4663 8192000000 10317761152 10720555008 1364106992 14.274 100 81 162 1 1420000672 36036720 19856960
17:50:31 5049 8192000000 10328540512 10739056640 1378335280 14.402 100 72 142 1 1435971680 40297872 17338528
17:51:43 9022 8192000000 10306474576 10726039552 1378937776 14.407 100 43 87 0 1412883696 22817504 11128416
17:52:57 6510 8192000000 10319522864 10738872320 1386540000 14.475 100 46 92 0 1421613808 24075248 10998560
17:54:12 17316 8192000000 10305810576 10736496640 1380501488 14.421 99 31 61 1 1408514608 20493392 7519728
17:55:59 26540 8192000000 10316240928 10755760128 1394516768 14.546 100 31 61 2 1433201552 30306416 8378368
17:57:28 24102 8192000000 10321207392 10764832768 1390401952 14.509 100 22 44 0 1431566064 35203056 5961056
17:58:55 34456 8192000000 10315684592 10754793472 1389365360 14.500 100 25 47 2 1415236928 20063120 5808448
18:00:32 48214 8192000000 10323495248 10758361088 1398338432 14.580 100 18 34 2 1412497152 9980176 4178544
18:02:24 47841 8192000000 10348627312 10778628096 1412211568 14.704 100 59 114 1 1440026800 14953392 12861840
18:04:29 62170 8192000000 10321006368 10780426240 1406473712 14.653 100 28 54 0 1431560064 18839984 6246368
18:06:40 15424 8192000000 10304128144 10768093184 1402339904 14.616 100 10 20 0 1418677824 14063648 2274272
18:08:01 5590 8192000000 10322241616 10768453632 1412588032 14.707 100 30 60 0 1430914176 11946160 6379984
18:09:11 22542 8192000000 10326348304 10767003648 1393766816 14.539 99 43 84 0 1420967984 17821392 9379776
18:10:36 24744 8192000000 10303845008 10756931584 1396719104 14.566 100 19 38 0 1420834624 19228000 4887520
18:12:02 38520 8192000000 10270603920 10711638016 1342617040 14.081 96 17 34 0 1368126400 21836448 3672912
18:14:01 34791 8192000000 10275200912 10729263104 1353992512 14.183 98 20 40 0 1379074544 19933040 5148992
18:15:58 28131 8192000000 10300669840 10743521280 1361510144 14.251 97 15 30 0 1378553904 13449424 3594336
18:17:43 36217 8192000000 10317764720 10781491200 1405173264 14.641 100 21 43 0 1432380624 21901696 5305664
18:19:31 71326 8192000000 10279863136 10726780928 1280834848 13.521 92 29 58 0 1302334048 14251200 7248000
18:21:52 56823 8192000000 10280423840 10731040768 1341456464 14.071 98 15 30 0 1364304448 19387920 3460064
18:23:49 21120 8192000000 10276726096 10705321984 1347844960 14.128 99 43 86 0 1367284896 9995104 9444832
18:25:11 48663 8192000000 10248517744 10684203008 1311504608 13.800 98 42 84 0 1336531216 15748848 9277760
18:27:02 71424 8192000000 10257048592 10684551168 1283219712 13.542 95 24 48 0 1306107216 17605072 5282432
18:29:17 100925 8192000000 10265529232 10696601600 1329736032 13.965 98 39 78 0 1348384816 9497840 9150944
18:32:01 24404 8192000000 10242757520 10678247424 1316030064 13.841 97 28 56 0 1331033216 8964352 6038800
18:33:26 9489 8192000000 10265040000 10708156416 1361156032 14.248 100 31 62 0 1376872816 7777200 7939584
18:34:41 69574 8192000000 10269004128 10715430912 1357612256 14.216 99 18 36 0 1373919456 11983648 4323552
18:36:52 49755 8192000000 10251806256 10694127616 1337924656 14.039 98 13 26 0 1353112080 12191984 2995440
18:39:21 60921 8192000000 10277440768 10726342656 1358194816 14.221 99 18 34 1 1375767184 13370832 4201536
18:41:24 66580 8192000000 10282496816 10725113856 1360552960 14.242 99 16 30 1 1371253408 7698064 3002384
18:43:41 39020 8192000000 10300513408 10746413056 1369686816 14.324 98 18 37 0 1386545936 12884384 3974736
18:45:21 27258 8192000000 10308021616 10745782272 1391063936 14.515 100 29 58 0 1409647712 12102480 6481296
18:46:49 27076 8192000000 10319096256 10762035200 1402991776 14.622 100 51 99 1 1428622368 14716480 10914112
18:48:17 7608 8192000000 10329864560 10759823360 1401553616 14.609 100 53 100 1 1421992496 9630256 10808624
18:49:29 16961 8192000000 10327025936 10769342464 1405255856 14.642 100 48 96 1 1432441312 16596912 10588544
18:50:47 45893 8192000000 10312732624 10756706304 1372509856 14.350 98 20 40 0 1386742976 10105312 4127808
18:52:40 29702 8192000000 10322012736 10776682496 1394644096 14.547 99 39 78 0 1421500576 18063632 8792848
18:54:22 102012 8192000000 10283462176 10734202880 1355414128 14.196 97 23 46 0 1369496192 8775216 5306848
18:57:06 10824 8192000000 10298791440 10746355712 1390309232 14.509 100 31 59 1 1406092832 9658016 6125584
18:58:20 50061 8192000000 10297297360 10759872512 1373057216 14.354 98 13 25 0 1390696304 15250656 2388432
19:00:10 41235 8192000000 10299947760 10751377408 1375910256 14.380 98 17 34 0 1390713536 10883936 3919344
19:01:54 40364 8192000000 10289560400 10754093056 1375897168 14.380 99 18 35 0 1391186880 11116144 4173568
19:03:42 39525 8192000000 10292322576 10749845504 1367497424 14.305 98 20 40 0 1383541184 11842912 4200848
19:05:31 24985 8192000000 10271277424 10717929472 1346669264 14.117 98 22 44 0 1363427408 12042048 4716096
19:06:56 33973 8192000000 10249719680 10694299648 1307977920 13.768 97 42 82 2 1335027584 17817088 9232576
19:08:31 62198 8192000000 10260901952 10698555392 1319270544 13.870 97 13 26 0 1334204832 12192144 2742144

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 08-03-2024 19:10:45 to 08-03-2024 19:10:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:03, from 08-03-2024 19:11:00 to 08-03-2024 19:11:03.

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          177264
MON$OLDEST_ACTIVE               179045
MON$OLDEST_SNAPSHOT             179045
MON$NEXT_TRANSACTION            179045
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                       1899680
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.33734 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33734 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33734 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33734 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 Fri Mar  8 19:11:04 2024 
 
Database header page information: 
    Flags            0 
    Generation        93374 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    177264 
    Oldest active        179045 
    Oldest snapshot        179045 
    Next transaction    179046 
    Sequence number        0 
    Next attachment ID    725 
    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.23, total records: 7812910 
    Average version length: 48.16, total versions: 108141, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 86800 
    Data pages: 86800, average fill: 72% 
    Primary pages: 86800, secondary pages: 0, swept pages: 14534 
    Empty pages: 3, full pages: 73143 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 134 
    40 - 59% = 1716 
    60 - 79% = 84905 
    80 - 99% = 17 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23418, nodes: 7812910 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1759446, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 368 
        20 - 39% = 1620 
        40 - 59% = 4359 
        60 - 79% = 2285 
        80 - 99% = 14786 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13587, nodes: 7812910 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1581280, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1458 
        40 - 59% = 2218 
        60 - 79% = 1040 
        80 - 99% = 8870 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8390, nodes: 7812910 
    Average node length: 6.63, total dup: 5830674, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1574274, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 144 
        20 - 39% = 888 
        40 - 59% = 1473 
        60 - 79% = 892 
        80 - 99% = 4993 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.13, total records: 2269623 
    Average version length: 34.80, total versions: 104246, max versions: 3 
    Average fragment length: 6.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28344 
    Data pages: 28344, average fill: 74% 
    Primary pages: 28337, secondary pages: 7, swept pages: 8836 
    Empty pages: 13, full pages: 23701 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 129 
    40 - 59% = 1432 
    60 - 79% = 25538 
    80 - 99% = 1210 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4590, nodes: 2269623 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 708762, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 900 
        40 - 59% = 895 
        60 - 79% = 687 
        80 - 99% = 2108 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2526, nodes: 2272869 
    Average node length: 4.97, total dup: 2271970, max dup: 17843 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1263188, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 265 
        40 - 59% = 1497 
        60 - 79% = 549 
        80 - 99% = 212 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2071, nodes: 2269623 
    Average node length: 4.97, total dup: 2269573, max dup: 130387 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062935, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 80 
        40 - 59% = 1136 
        60 - 79% = 65 
        80 - 99% = 786 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4367, nodes: 2269623 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 708762, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 89 
        20 - 39% = 580 
        40 - 59% = 658 
        60 - 79% = 777 
        80 - 99% = 2263 
 
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.22, total records: 400 
    Average version length: 23.32, total versions: 232873, max versions: 609 
    Average fragment length: 2.03, total fragments: 60, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1312 
    Data pages: 1312, average fill: 89% 
    Primary pages: 10, secondary pages: 1302, swept pages: 0 
    Empty pages: 3, full pages: 1308 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 1307 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 4.11, total records: 94311 
    Average version length: 68.29, total versions: 88632, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 21.40 
    Pointer pages: 7, data page slots: 3232 
    Data pages: 1976, average fill: 60% 
    Primary pages: 1975, secondary pages: 1, swept pages: 0 
    Empty pages: 327, full pages: 1044 
    Fill distribution: 
     0 - 19% = 439 
    20 - 39% = 171 
    40 - 59% = 181 
    60 - 79% = 242 
    80 - 99% = 943 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703681, depth: 3, leaf buckets: 386, nodes: 94311 
    Average node length: 13.46, total dup: 6519, max dup: 1 
    Average key length: 10.74, compression ratio: 2.51 
    Average prefix length: 19.19, average data length: 7.81 
    Clustering factor: 67823, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 193 
        40 - 59% = 176 
        60 - 79% = 14 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18486, max versions: 961 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 62 
 
    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: 1.16, total records: 2017 
    Average version length: 43.60, total versions: 1963, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 49.91 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 62% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 16 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 2 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 15 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91760, depth: 2, leaf buckets: 3, nodes: 2017 
    Average node length: 4.25, total dup: 1919, max dup: 189 
    Average key length: 2.52, compression ratio: 7.53 
    Average prefix length: 18.52, average data length: 0.48 
    Clustering factor: 1032, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.04, total records: 78 
    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: 54% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 78 
    Average node length: 11.67, total dup: 0, max dup: 0 
    Average key length: 10.65, compression ratio: 0.84 
    Average prefix length: 1.33, average data length: 7.67 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 35.51, total records: 809216 
    Average version length: 25.28, total versions: 92269, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 7992, average fill: 72% 
    Primary pages: 7974, secondary pages: 18, swept pages: 903 
    Empty pages: 34, full pages: 7129 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 49 
    40 - 59% = 136 
    60 - 79% = 7356 
    80 - 99% = 399 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 885, nodes: 809216 
    Average node length: 4.87, total dup: 809167, max dup: 154477 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89835, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 133 
        40 - 59% = 465 
        60 - 79% = 217 
        80 - 99% = 68 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 904, nodes: 809216 
    Average node length: 5.87, total dup: 720661, max dup: 44 
    Average key length: 3.01, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160804, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 81 
        40 - 59% = 369 
        60 - 79% = 110 
        80 - 99% = 342 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 964, nodes: 809216 
    Average node length: 5.88, total dup: 720661, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162907, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 187 
        40 - 59% = 364 
        60 - 79% = 92 
        80 - 99% = 321 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1136, nodes: 809216 
    Average node length: 5.96, total dup: 720661, max dup: 44 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 155772, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 217 
        40 - 59% = 620 
        60 - 79% = 195 
        80 - 99% = 100 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.87, total records: 5489 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.60, total fragments: 67, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 78, secondary pages: 18, swept pages: 51 
    Empty pages: 10, full pages: 65 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 68 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5489 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.48, average data length: 1.54 
    Clustering factor: 5265, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5489 
    Average node length: 11.12, 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: 144, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 81500 
    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: 792 
    Data pages: 792, average fill: 71% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 784 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 784 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35875, depth: 2, leaf buckets: 103, nodes: 81500 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3338, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 103 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.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: 144.14, total records: 168951 
    Average version length: 151.56, total versions: 7753, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.77 
    Pointer pages: 7, data page slots: 5112 
    Data pages: 4056, average fill: 86% 
    Primary pages: 4056, secondary pages: 0, swept pages: 8 
    Empty pages: 43, full pages: 3997 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3998 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.30, total records: 178695 
    Average version length: 151.64, total versions: 6904, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.67 
    Pointer pages: 7, data page slots: 5256 
    Data pages: 4280, average fill: 86% 
    Primary pages: 4280, secondary pages: 0, swept pages: 5 
    Empty pages: 36, full pages: 4231 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4231 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 142.47, total records: 158864 
    Average version length: 152.23, total versions: 8616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.90 
    Pointer pages: 7, data page slots: 4320 
    Data pages: 3784, average fill: 87% 
    Primary pages: 3784, secondary pages: 0, swept pages: 1 
    Empty pages: 19, full pages: 3753 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3754 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 119.35, total records: 214404 
    Average version length: 154.68, total versions: 45060, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.21 
    Pointer pages: 6, data page slots: 6416 
    Data pages: 5144, average fill: 88% 
    Primary pages: 5143, secondary pages: 1, swept pages: 1 
    Empty pages: 33, full pages: 5102 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 5102 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 125.02, total records: 177788 
    Average version length: 154.43, total versions: 30576, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.57 
    Pointer pages: 8, data page slots: 5472 
    Data pages: 4264, average fill: 88% 
    Primary pages: 4264, secondary pages: 0, swept pages: 1 
    Empty pages: 31, full pages: 4223 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4222 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 140.78, total records: 167826 
    Average version length: 152.99, total versions: 11289, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.05 
    Pointer pages: 8, data page slots: 4368 
    Data pages: 4000, average fill: 87% 
    Primary pages: 4000, secondary pages: 0, swept pages: 1 
    Empty pages: 17, full pages: 3974 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 3973 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 142.12, total records: 169286 
    Average version length: 152.07, total versions: 9664, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 7, data page slots: 5696 
    Data pages: 4072, average fill: 86% 
    Primary pages: 4072, secondary pages: 0, swept pages: 5 
    Empty pages: 56, full pages: 3995 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 3994 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 143.16, total records: 173468 
    Average version length: 151.26, total versions: 9024, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 6, data page slots: 4720 
    Data pages: 4160, average fill: 86% 
    Primary pages: 4160, secondary pages: 0, swept pages: 5 
    Empty pages: 43, full pages: 4103 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 4102 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 143.64, total records: 164521 
    Average version length: 151.36, total versions: 8001, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.81 
    Pointer pages: 7, data page slots: 4432 
    Data pages: 3936, average fill: 86% 
    Primary pages: 3936, secondary pages: 0, swept pages: 3 
    Empty pages: 31, full pages: 3893 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3894 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 144.36, total records: 147944 
    Average version length: 151.33, total versions: 5803, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 6, data page slots: 5288 
    Data pages: 3520, average fill: 86% 
    Primary pages: 3520, secondary pages: 0, swept pages: 1 
    Empty pages: 26, full pages: 3487 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 0 
    80 - 99% = 3488 
 
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.54, total records: 2124724 
    Average version length: 52.95, total versions: 48572, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25480 
    Data pages: 25472, average fill: 72% 
    Primary pages: 25472, secondary pages: 0, swept pages: 8938 
    Empty pages: 277, full pages: 22387 
    Fill distribution: 
     0 - 19% = 522 
    20 - 39% = 317 
    40 - 59% = 838 
    60 - 79% = 23355 
    80 - 99% = 440 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2597, nodes: 2124724 
    Average node length: 5.44, total dup: 1982975, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184284, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 270 
        40 - 59% = 1694 
        60 - 79% = 321 
        80 - 99% = 308 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2124724 
    Average node length: 5.69, total dup: 1907595, max dup: 72 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 380364, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2382 
        60 - 79% = 343 
        80 - 99% = 27 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2169, nodes: 2124724 
    Average node length: 4.96, total dup: 2124624, max dup: 28202 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181762, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 188 
        40 - 59% = 1182 
        60 - 79% = 392 
        80 - 99% = 404 
 
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: 35.97, total records: 155238 
    Average version length: 69.17, total versions: 74563, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.50 
    Pointer pages: 3, data page slots: 3976 
    Data pages: 2912, average fill: 62% 
    Primary pages: 2912, secondary pages: 0, swept pages: 322 
    Empty pages: 437, full pages: 2025 
    Fill distribution: 
     0 - 19% = 604 
    20 - 39% = 144 
    40 - 59% = 59 
    60 - 79% = 689 
    80 - 99% = 1416 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103451, depth: 3, leaf buckets: 227, nodes: 155238 
    Average node length: 6.45, total dup: 134981, max dup: 14 
    Average key length: 3.95, compression ratio: 10.64 
    Average prefix length: 40.18, average data length: 1.82 
    Clustering factor: 26334, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 115 
        60 - 79% = 62 
        80 - 99% = 19 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 63.50, total records: 7156925 
    Average version length: 68.82, total versions: 567064, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 63, data page slots: 102600 
    Data pages: 102600, average fill: 75% 
    Primary pages: 102600, secondary pages: 0, swept pages: 16901 
    Empty pages: 10, full pages: 83089 
    Fill distribution: 
     0 - 19% = 85 
    20 - 39% = 780 
    40 - 59% = 5926 
    60 - 79% = 85160 
    80 - 99% = 10649 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10676, nodes: 7156925 
    Average node length: 6.51, total dup: 6191079, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1584158, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1516 
        40 - 59% = 5732 
        60 - 79% = 2854 
        80 - 99% = 565 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8480, nodes: 7156925 
    Average node length: 5.40, total dup: 6872635, max dup: 168 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1381002, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1058 
        40 - 59% = 4692 
        60 - 79% = 1579 
        80 - 99% = 1141 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8532, nodes: 7156925 
    Average node length: 5.40, total dup: 6872635, max dup: 168 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1383488, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1084 
        40 - 59% = 4709 
        60 - 79% = 1623 
        80 - 99% = 1111 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.64, total records: 12098520 
    Average version length: 68.74, total versions: 406857, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 103, data page slots: 167288 
    Data pages: 167288, average fill: 77% 
    Primary pages: 167288, secondary pages: 0, swept pages: 65057 
    Empty pages: 8, full pages: 160320 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 413 
    40 - 59% = 2131 
    60 - 79% = 155994 
    80 - 99% = 8693 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18334, nodes: 12098520 
    Average node length: 6.58, total dup: 10544166, max dup: 64 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2386833, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 2268 
        40 - 59% = 10640 
        60 - 79% = 4540 
        80 - 99% = 859 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 38.91, total records: 1831353 
    Average version length: 69.08, total versions: 800596, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.24 
    Pointer pages: 26, data page slots: 41488 
    Data pages: 30280, average fill: 70% 
    Primary pages: 30279, secondary pages: 1, swept pages: 5005 
    Empty pages: 1905, full pages: 21690 
    Fill distribution: 
     0 - 19% = 3325 
    20 - 39% = 1574 
    40 - 59% = 1874 
    60 - 79% = 10469 
    80 - 99% = 13038 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2294, nodes: 1831353 
    Average node length: 5.50, total dup: 1757651, max dup: 99 
    Average key length: 2.55, compression ratio: 16.50 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 129125, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 407 
        40 - 59% = 1111 
        60 - 79% = 561 
        80 - 99% = 208 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 33.31, total records: 1148971 
    Average version length: 69.14, total versions: 594434, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.78 
    Pointer pages: 20, data page slots: 31120 
    Data pages: 26744, average fill: 51% 
    Primary pages: 26744, secondary pages: 0, swept pages: 4850 
    Empty pages: 5106, full pages: 14164 
    Fill distribution: 
     0 - 19% = 9193 
    20 - 39% = 2188 
    40 - 59% = 737 
    60 - 79% = 4095 
    80 - 99% = 10531 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1544, nodes: 1148971 
    Average node length: 5.77, total dup: 1075294, max dup: 101 
    Average key length: 2.83, compression ratio: 14.83 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 149252, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 355 
        40 - 59% = 688 
        60 - 79% = 372 
        80 - 99% = 125 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.21, total records: 9393185 
    Average version length: 68.98, total versions: 503189, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.93 
    Pointer pages: 88, data page slots: 142760 
    Data pages: 142744, average fill: 70% 
    Primary pages: 142744, secondary pages: 0, swept pages: 46091 
    Empty pages: 379, full pages: 95163 
    Fill distribution: 
     0 - 19% = 1149 
    20 - 39% = 5638 
    40 - 59% = 19824 
    60 - 79% = 105890 
    80 - 99% = 10243 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13481, nodes: 9393185 
    Average node length: 6.67, total dup: 7792168, max dup: 21 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2076056, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1027 
        40 - 59% = 6741 
        60 - 79% = 4963 
        80 - 99% = 747 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21179783 
    Average version length: 82.74, total versions: 16173, 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: 319024 
    Data pages: 319024, average fill: 81% 
    Primary pages: 319024, secondary pages: 0, swept pages: 11082 
    Empty pages: 5, full pages: 319016 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 26666 
    80 - 99% = 292351 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19530, nodes: 21179783 
    Average node length: 5.72, total dup: 20698080, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285760, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8393 
        60 - 79% = 555 
        80 - 99% = 10578 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17205, nodes: 21179783 
    Average node length: 6.31, total dup: 18611435, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917689, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 4 
        40 - 59% = 774 
        60 - 79% = 314 
        80 - 99% = 16109 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21310, nodes: 21179783 
    Average node length: 6.35, total dup: 18531677, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3581223, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8644 
        60 - 79% = 619 
        80 - 99% = 12040 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16198, nodes: 21179783 
    Average node length: 5.56, total dup: 21179683, max dup: 231847 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946582, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 3011 
        60 - 79% = 451 
        80 - 99% = 12726 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.12, total records: 9861571 
    Average version length: 82.61, total versions: 514466, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 104, data page slots: 169616 
    Data pages: 169600, average fill: 72% 
    Primary pages: 169600, secondary pages: 0, swept pages: 62935 
    Empty pages: 363, full pages: 110592 
    Fill distribution: 
     0 - 19% = 1302 
    20 - 39% = 6419 
    40 - 59% = 23207 
    60 - 79% = 64322 
    80 - 99% = 74350 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11367, nodes: 9861571 
    Average node length: 5.36, total dup: 9551354, max dup: 253 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2219822, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 68 
        40 - 59% = 7788 
        60 - 79% = 3396 
        80 - 99% = 112 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13610, nodes: 9861571 
    Average node length: 6.23, total dup: 8176008, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1562674, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 133 
        20 - 39% = 3850 
        40 - 59% = 4416 
        60 - 79% = 2664 
        80 - 99% = 2547 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12691, nodes: 9861571 
    Average node length: 5.97, total dup: 8563801, max dup: 53 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2414666, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 92 
        40 - 59% = 8718 
        60 - 79% = 3746 
        80 - 99% = 133 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10403, nodes: 9861571 
    Average node length: 5.13, total dup: 9861471, max dup: 141865 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1588669, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1272 
        40 - 59% = 5341 
        60 - 79% = 1710 
        80 - 99% = 2037 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.54, total records: 11432649 
    Average version length: 82.57, total versions: 383626, 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: 192448 
    Data pages: 191408, average fill: 73% 
    Primary pages: 191408, secondary pages: 0, swept pages: 67735 
    Empty pages: 2797, full pages: 145987 
    Fill distribution: 
     0 - 19% = 4815 
    20 - 39% = 7335 
    40 - 59% = 16776 
    60 - 79% = 41917 
    80 - 99% = 120565 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13133, nodes: 11432649 
    Average node length: 5.30, total dup: 11322246, max dup: 632 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2380793, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 100 
        40 - 59% = 8888 
        60 - 79% = 3968 
        80 - 99% = 174 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10512, nodes: 11432649 
    Average node length: 5.49, total dup: 10934155, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 715317, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 137 
        20 - 39% = 773 
        40 - 59% = 2682 
        60 - 79% = 1858 
        80 - 99% = 5062 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15015, nodes: 11432649 
    Average node length: 6.02, total dup: 9976205, max dup: 63 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2397273, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 126 
        40 - 59% = 10364 
        60 - 79% = 4301 
        80 - 99% = 222 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10919, nodes: 11432649 
    Average node length: 5.22, total dup: 11432549, max dup: 174253 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 703449, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 833 
        40 - 59% = 4938 
        60 - 79% = 1507 
        80 - 99% = 3540 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.63, total records: 9959410 
    Average version length: 82.93, total versions: 495681, 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: 106, data page slots: 172848 
    Data pages: 172832, average fill: 71% 
    Primary pages: 172832, secondary pages: 0, swept pages: 67216 
    Empty pages: 407, full pages: 109374 
    Fill distribution: 
     0 - 19% = 1398 
    20 - 39% = 6746 
    40 - 59% = 24869 
    60 - 79% = 67849 
    80 - 99% = 71970 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11899, nodes: 9959410 
    Average node length: 5.17, total dup: 9930397, max dup: 2287 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2025203, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1358 
        40 - 59% = 7973 
        60 - 79% = 1885 
        80 - 99% = 650 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13740, nodes: 9959410 
    Average node length: 6.24, total dup: 8256731, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1525155, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 196 
        20 - 39% = 3871 
        40 - 59% = 4345 
        60 - 79% = 2639 
        80 - 99% = 2689 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12566, nodes: 9959410 
    Average node length: 5.42, total dup: 9517009, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2159834, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1345 
        40 - 59% = 8893 
        60 - 79% = 1676 
        80 - 99% = 624 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10535, nodes: 9959410 
    Average node length: 5.14, total dup: 9959310, max dup: 143796 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1605539, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1315 
        40 - 59% = 5408 
        60 - 79% = 1706 
        80 - 99% = 2067 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.10, total records: 582955 
    Average version length: 68.76, total versions: 9222, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8024 
    Data pages: 8024, average fill: 76% 
    Primary pages: 8024, secondary pages: 0, swept pages: 3281 
    Empty pages: 4, full pages: 7208 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 16 
    40 - 59% = 153 
    60 - 79% = 7694 
    80 - 99% = 156 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38764, depth: 3, leaf buckets: 742, nodes: 582955 
    Average node length: 5.95, total dup: 496555, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101293, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 526 
        60 - 79% = 96 
        80 - 99% = 93 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 23148, depth: 3, leaf buckets: 762, nodes: 582955 
    Average node length: 6.15, total dup: 478352, max dup: 29 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101360, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 524 
        60 - 79% = 104 
        80 - 99% = 104 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 579, nodes: 582955 
    Average node length: 4.86, total dup: 582855, max dup: 10010 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89923, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 347 
        60 - 79% = 82 
        80 - 99% = 122 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar  8 19:11:27 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7812910 108141 1 0.0000 0.0000
DOC_LIST 2269623 104246 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 232873 609 58200.0000 0.0000
INVNT_TURNOVER_LOG 94311 88632 1 0.0000 0.0000
MONEY_SALDO 49 18486 961 37700.0000 0.0000
MONEY_TURNOVER_LOG 2017 1963 1 0.0000 0.0000
PDISTR 809216 92269 4 0.0000 0.0000
PERF_SPLIT_0 168951 7753 1 0.0000 0.0000
PERF_SPLIT_1 178695 6904 1 0.0000 0.0000
PERF_SPLIT_2 158864 8616 1 0.0000 0.0000
PERF_SPLIT_3 214404 45060 1 0.0000 0.0000
PERF_SPLIT_4 177788 30576 1 0.0000 0.0000
PERF_SPLIT_5 167826 11289 1 0.0000 0.0000
PERF_SPLIT_6 169286 9664 1 0.0000 0.0000
PERF_SPLIT_7 173468 9024 1 0.0000 0.0000
PERF_SPLIT_8 164521 8001 1 0.0000 0.0000
PERF_SPLIT_9 147944 5803 1 0.0000 0.0000
PSTORNED 2124724 48572 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 155238 74563 1 0.0000 0.0000
XQD_1000_3300 7156925 567064 1 0.0000 0.0000
XQD_1200_2000 12098520 406857 1 0.0000 0.0000
XQD_2000_3300 1831353 800596 1 0.0000 0.0000
XQD_2100_3300 1148971 594434 1 0.0000 0.0000
XQD_3300_3400 9393185 503189 1 0.0000 0.0000
XQS_1000_1200 21179783 16173 1 0.0000 0.0000
XQS_1000_3300 9861571 514466 1 0.0000 0.0000
XQS_1200_2000 11432649 383626 1 0.0000 0.0000
XQS_2100_3300 9959410 495681 1 0.0000 0.0000
XQS_3300_3400 582955 9222 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 ---
:139: 
:140: mscs-test-161.budzdorov.ru    Fri Mar  8 19:09:41 2024
:141:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:142: 
:143: 
:144: mscs-test-161.budzdorov.ru    Fri Mar  8 19:09:41 2024
:145:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:146: 
:147: 
:148: mscs-test-161.budzdorov.ru    Fri Mar  8 19:09:45 2024
:149:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:150: 
--- end of diff output ---

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

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