Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.02.2024 07:08
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 15679068 kB
MemAvailable 30267808 kB
Buffers 0 kB
Cached 16046712 kB
SwapCached 2680 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 4.0.5
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-17 07:07:47
DTS_END                         2024-02-17 07:07:47.6580
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/47580
TRN_ID                          180354
ATT_ID                          591
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: 9206.44 24141 920644
customer order: creation 180.21 385 18021
customer order: refuse 16.02 383 1602
order to supplier: creation 48.25 1361 4825
order to supplier: removal 3.38 91135 338
invoice (draft): creation 48.02 3341 4802
invoice (draft): removal 50.23 765 5023
invoice accept: apply 43.37 20481 4337
invoice accept: cancel 45.10 794 4510
customer reserve: creation 4120.93 197 412093
customer reserve: removal 4344.20 56 434420
realization accept: apply 89.45 221 8945
realization accept: cancel 82.66 123 8266
payment from customer: creation 62.04 140 6204
payment from customer: removal 6.09 63 609
payment to supplier: creation 51.33 158 5133
payment to supplier: removal 3.77 148 377
service: total inventory turnovers 3.85 3832 385
service: total monetary turnovers 6.61 584 661
service: aggregate perf. data 0.90 16173 90
service: refresh index statistics 0.03 342473 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-02-2024 07:08:52 to 17-02-2024 07:08:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3040
TEST_TIME 2 2479
TEST_TIME 3 3202
TEST_TIME 4 4704
TEST_TIME 5 4654
TEST_TIME 6 4543
TEST_TIME 7 4514
TEST_TIME 8 5191
TEST_TIME 9 5863
TEST_TIME 10 5878
TEST_TIME 11 5982
TEST_TIME 12 6254
TEST_TIME 13 6630
TEST_TIME 14 7338
TEST_TIME 15 7600
TEST_TIME 16 7861
TEST_TIME 17 8024
TEST_TIME 18 8435
TEST_TIME 19 8518
TEST_TIME 20 8984
TEST_TIME 21 9263
TEST_TIME 22 9391
TEST_TIME 23 9941
TEST_TIME 24 10407
TEST_TIME 25 10383
TEST_TIME 26 10043
TEST_TIME 27 9730
TEST_TIME 28 9515
TEST_TIME 29 9453
TEST_TIME 30 9462
TEST_TIME 31 9451
TEST_TIME 32 9308
TEST_TIME 33 9233
TEST_TIME 34 9108
TEST_TIME 35 9121
TEST_TIME 36 9045
TEST_TIME 37 8933
TEST_TIME 38 9047
TEST_TIME 39 9199
TEST_TIME 40 9455
TEST_TIME 41 9442
TEST_TIME 42 9480
TEST_TIME 43 9625
TEST_TIME 44 9579
TEST_TIME 45 9504
TEST_TIME 46 9784
TEST_TIME 47 9762
TEST_TIME 48 9726
TEST_TIME 49 9678
TEST_TIME 50 9727
TEST_TIME 51 9556
TEST_TIME 52 9459
TEST_TIME 53 9433
TEST_TIME 54 9430
TEST_TIME 55 9425
TEST_TIME 56 9367
TEST_TIME 57 9298
TEST_TIME 58 9180
TEST_TIME 59 9153
TEST_TIME 60 9144
TEST_TIME 61 9265
TEST_TIME 62 9262
TEST_TIME 63 9245
TEST_TIME 64 9271
TEST_TIME 65 9270
TEST_TIME 66 9382
TEST_TIME 67 9349
TEST_TIME 68 9379
TEST_TIME 69 9531
TEST_TIME 70 9483
TEST_TIME 71 9619
TEST_TIME 72 9576
TEST_TIME 73 9447
TEST_TIME 74 9421
TEST_TIME 75 9392
TEST_TIME 76 9306
TEST_TIME 77 9432
TEST_TIME 78 9388
TEST_TIME 79 9346
TEST_TIME 80 9313
TEST_TIME 81 9375
TEST_TIME 82 9484
TEST_TIME 83 9513
TEST_TIME 84 9495
TEST_TIME 85 9493
TEST_TIME 86 9505
TEST_TIME 87 9518
TEST_TIME 88 9545
TEST_TIME 89 9492
TEST_TIME 90 9398
TEST_TIME 91 9395
TEST_TIME 92 9377
TEST_TIME 93 9335
TEST_TIME 94 9296
TEST_TIME 95 9226
TEST_TIME 96 9208
TEST_TIME 97 9187
TEST_TIME 98 9225
TEST_TIME 99 9256
TEST_TIME 100 9207

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-02-2024 07:08:56 to 17-02-2024 07:08:59.

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 1297434 1297434 0 0.00 0 24266 7 0 0
doc_list_biud 1297434 1297434 0 0.00 0 59778 24 0 0
sp_add_invoice_to_stock 4492 4337 155 3.45 32 180270 20481 0 155
sp_cancel_adding_invoice 4510 4510 0 0.00 4 59211 794 0 0
sp_cancel_client_order 1602 1602 0 0.00 4 22066 383 0 0
sp_cancel_customer_reserve 434420 434420 0 0.00 0 42652 56 0 0
sp_cancel_pay_from_customer 609 609 0 0.00 2 2048 63 0 0
sp_cancel_pay_to_supplier 377 377 0 0.00 2 18710 149 0 0
sp_cancel_supplier_invoice 5042 5023 19 0.37 1 59839 765 0 19
sp_cancel_supplier_order 338 338 0 0.00 7 880902 91135 0 0
sp_cancel_write_off 8266 8266 0 0.00 1 12866 123 0 0
sp_client_order 18021 18021 0 0.00 3 41027 386 0 0
sp_customer_reserve 412093 412093 0 0.00 0 80192 198 0 0
sp_fill_shopping_cart 27646 27646 0 0.00 1 22688 40 0 0
sp_fill_shopping_cart_clo_res 412092 412092 0 0.00 0 16447 15 0 0
sp_get_clo_for_invoice 4336 4336 0 0.00 0 24430 363 0 0
sp_kill_cost_storno 13762 13762 0 0.00 0 19666 64 0 0
sp_kill_qstorno_ret_qs2qd 882467 882467 0 0.00 0 59776 31 0 0
sp_kill_qty_storno 467440 467440 0 0.00 0 59777 67 0 0
sp_lock_selected_doc 18474 18474 0 0.00 0 9811 5 0 0
sp_make_cost_storno 24618 24618 0 0.00 0 17963 68 0 0
sp_multiply_rows_for_pdistr 24618 24618 0 0.00 0 14287 39 0 0
sp_multiply_rows_for_qdistr 18021 18021 0 0.00 0 22522 188 0 0
sp_pay_from_customer 6204 6204 0 0.00 4 11948 141 0 0
sp_pay_to_supplier 5133 5133 0 0.00 4 14314 159 0 0
sp_payment_common 11337 11337 0 0.00 1 10109 31 0 0
sp_qd_handle_on_cancel_clo 1602 1602 0 0.00 0 22061 333 0 0
sp_qd_handle_on_invoice_upd_sts 8846 8846 0 0.00 0 59237 312 0 0
sp_qd_handle_on_reserve_upd_sts 8945 8945 0 0.00 0 36297 62 0 0
sp_reserve_write_off 8945 8945 0 0.00 5 36308 221 0 0
sp_supplier_invoice 4802 4802 0 0.00 6 83826 3341 0 0
sp_supplier_order 4825 4825 0 0.00 5 69720 1362 0 0
srv_aggregate_perf_data 90 90 0 0.00 1718 211669 16174 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1251 113242 41651 0 0
srv_find_qd_qs_mism 876277 876277 0 0.00 0 17660 6 0 0
srv_make_invnt_saldo 385 385 0 0.00 48 95602 3832 0 0
srv_make_money_saldo 661 661 0 0.00 1 14404 584 0 0
srv_recalc_idx_stat 3 3 0 0.00 253959 452382 342473 0 0
t$perf-abend:sp_add_invoice_to_stock 155 155 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 19 19 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4337 4337 0 0.00 0 17188 193 0 0
t$perf-norm:sp_cancel_adding_invoice 347 347 0 0.00 0 3937 87 0 0
t$perf-norm:sp_cancel_client_order 1602 1602 0 0.00 0 1478 9 0 0
t$perf-norm:sp_cancel_customer_reserve 639 639 0 0.00 0 2200 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 609 609 0 0.00 0 12130 25 0 0
t$perf-norm:sp_cancel_pay_to_supplier 377 377 0 0.00 0 2050 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 392 392 0 0.00 0 2920 22 0 0
t$perf-norm:sp_cancel_supplier_order 338 338 0 0.00 0 20553 1730 0 0
t$perf-norm:sp_cancel_write_off 889 889 0 0.00 0 17896 25 0 0
t$perf-norm:sp_client_order 18021 18021 0 0.00 0 12873 15 0 0
t$perf-norm:sp_customer_reserve 906 906 0 0.00 0 3444 8 0 0
t$perf-norm:sp_pay_from_customer 6204 6204 0 0.00 0 7105 8 0 0
t$perf-norm:sp_pay_to_supplier 5133 5133 0 0.00 0 18087 13 0 0
t$perf-norm:sp_reserve_write_off 8945 8945 0 0.00 0 8971 10 0 0
t$perf-norm:sp_supplier_invoice 4802 4802 0 0.00 0 3009 17 0 0
t$perf-norm:sp_supplier_order 4825 4825 0 0.00 0 5327 14 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 766 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 28 1 0 0
t$perf-norm:srv_make_invnt_saldo 385 385 0 0.00 0 312 8 0 0
t$perf-norm:srv_make_money_saldo 661 661 0 0.00 0 261 4 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 5 0 0
v_add_invoice_to_stock 8982 8672 310 3.45 0 6972 22 0 310
v_all_customers 33028 33028 0 0.00 0 29 1 0 0
v_all_suppliers 27080 27080 0 0.00 0 30 1 0 0
v_all_wares 36042 36042 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 694 694 0 0.00 0 3343 12 0 0
v_cancel_client_order 3204 3204 0 0.00 0 8312 14 0 0
v_cancel_customer_prepayment 1218 1218 0 0.00 0 248 3 0 0
v_cancel_customer_reserve 1278 1278 0 0.00 0 914 5 0 0
v_cancel_payment_to_supplier 754 754 0 0.00 0 3488 15 0 0
v_cancel_supplier_invoice 822 784 38 4.62 0 5755 24 0 38
v_cancel_supplier_order 676 676 0 0.00 0 5235 27 0 0
v_cancel_write_off 1778 1778 0 0.00 0 2947 14 0 0
v_max_id_clo_ord 4824 4824 0 0.00 0 310 1 0 0
v_max_id_clo_res 906 906 0 0.00 0 1151 6 0 0
v_max_id_ord_sup 4801 4801 0 0.00 0 6102 6 0 0
v_max_non_paid_invoice 1218 1218 0 0.00 0 268 2 0 0
v_max_non_paid_realizn 3209 3209 0 0.00 0 2366 4 0 0
v_min_id_clo_ord 4824 4824 0 0.00 0 20761 18 0 0
v_min_id_clo_res 906 906 0 0.00 0 3096 13 0 0
v_min_id_ord_sup 4801 4801 0 0.00 0 5609 6 0 0
v_min_non_paid_invoice 5133 5133 0 0.00 0 8932 22 0 0
v_min_non_paid_realizn 6204 6204 0 0.00 0 10105 26 0 0
v_our_firm 9004 9004 0 0.00 0 28 1 0 0
v_reserve_write_off 17890 17890 0 0.00 0 8326 10 0 0
x_lock_depdocs_on_canc_invoice 9141 9141 0 0.00 0 24766 130 0 0
x_lock_depdocs_on_canc_sup_ord 338 338 0 0.00 0 3039 331 0 0
x_make_qstorno_1000_1200 4825 4825 0 0.00 1 62316 1265 0 0
x_make_qstorno_1200_2000 4802 4802 0 0.00 2 83773 3211 0 0
x_make_qstorno_2100_3300 412093 412093 0 0.00 0 80191 180 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-02-2024 07:09:00 to 17-02-2024 07:09:04.

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
05:07:51 3 8192000000 8801587472 8813862912 6898208 0.084 3 1 2 0 6999328 65344 35776
05:08:52 37630 8192000000 9736215296 10039001088 809859280 8.996 100 89 178 0 839099904 7708448 21532176
05:10:36 17973 8192000000 9769415312 10079023104 840331440 9.303 100 91 182 0 875829184 13861488 21636256
05:12:06 17253 8192000000 9816561376 10134568960 871499296 9.615 100 90 181 0 915901632 23998848 20403488
05:13:30 13527 8192000000 9859690688 10193776640 905104288 9.949 100 74 148 0 969548656 48586560 15857808
05:14:47 10742 8192000000 9920200832 10265071616 953356384 10.424 100 78 156 0 1033462912 64384320 15722208
05:16:01 3709 8192000000 9950819472 10306433024 989298224 10.775 100 74 149 0 1073723680 69773520 14651936
05:17:07 1776 8192000000 10000448432 10361958400 1010094032 10.976 100 80 158 0 1108108144 82854048 15160064
05:18:10 1084 8192000000 10008515680 10380087296 1037481664 11.240 100 80 157 0 1121219216 68143184 15594368
05:19:12 1022 8192000000 10041183600 10417205248 1065577904 11.510 100 90 180 1 1152134944 68122800 18434240
05:20:14 27997 8192000000 10040906816 10434895872 1081223488 11.659 100 58 114 2 1154686992 61506832 11956672
05:21:46 5774 8192000000 10011061376 10415575040 1083865792 11.684 100 28 57 0 1131550352 41582304 6102256
05:22:54 6679 8192000000 10012142448 10420473856 1090267488 11.745 100 32 64 0 1127422224 30655904 6498832
05:24:01 16115 8192000000 10016192480 10413973504 1093202144 11.773 100 25 50 0 1123742128 24431264 6108720
05:25:17 17671 8192000000 10024011872 10424401920 1096684368 11.806 100 51 103 0 1134259008 26553344 11021296
05:26:36 8184 8192000000 10017822576 10438828032 1092846560 11.770 100 40 78 0 1127640416 26753104 8040752
05:27:47 11714 8192000000 9998146736 10399383552 1085677392 11.702 100 44 88 0 1108600672 12424080 10499200
05:29:01 86076 8192000000 10041683728 10451615744 1087807968 11.722 99 36 72 1 1137332032 41547600 7976464
05:31:29 8373 8192000000 10097920960 10499870720 1096373856 11.803 99 55 110 1 1203105536 95594640 11137040
05:32:43 20084 8192000000 10121585168 10527137792 1108241408 11.916 100 53 106 0 1230246496 110928896 11076192
05:34:17 17982 8192000000 10165884400 10567503872 1095501920 11.795 98 55 108 0 1249796288 142572256 11722112
05:35:41 2584 8192000000 10151112544 10556289024 1097619728 11.815 99 45 84 0 1252940048 146445952 8874368
05:36:56 13435 8192000000 10112549648 10508644352 1078484320 11.633 98 42 84 1 1219006000 131164192 9357488
05:38:24 29234 8192000000 10159663328 10569404416 1105331248 11.888 100 44 88 0 1269612000 154481296 9799456
05:39:57 1728 8192000000 10211268080 10601644032 1112220240 11.953 100 87 175 0 1311083376 179554256 19308880
05:41:01 3373 8192000000 10185043904 10608947200 1099459664 11.833 99 65 127 1 1296206448 183136800 13609984
05:42:09 3380 8192000000 10223973136 10610683904 1106012144 11.895 99 75 149 1 1312386144 190698624 15675376
05:43:18 3283 8192000000 10249369440 10643189760 1119197600 12.019 100 72 144 0 1342924400 207514992 16211808
05:44:26 2382 8192000000 10285851696 10697641984 1146247264 12.274 100 68 136 1 1383790608 223079504 14463840
05:45:33 1524 8192000000 10320240112 10741264384 1156490480 12.370 100 92 180 1 1407166352 231225504 19450368
05:46:42 1248 8192000000 10320415424 10732052480 1161842960 12.421 100 88 174 4 1415461888 234899280 18719648
05:47:48 8599 8192000000 10291632816 10756259840 1162979696 12.431 100 38 75 0 1393960384 222187472 8793216
05:49:00 10951 8192000000 10291893392 10726166528 1178569152 12.577 100 38 74 0 1386887856 200066704 8252000
05:50:14 2976 8192000000 10323806464 10746634240 1177561552 12.567 100 58 114 0 1414587600 224312240 12713808
05:51:25 40957 8192000000 10103779200 10652803072 1155969632 12.365 99 9 18 0 1263903776 105960480 1973664
05:53:07 113242 8192000000 10082664608 10530508800 1161356032 12.416 100 35 68 1 1194246560 25799488 7091040
05:56:06 5340 8192000000 10120427232 10550689792 1166055296 12.460 100 55 110 2 1216198048 38851648 11291104
05:57:20 17868 8192000000 10099856400 10553417728 1151141440 12.320 99 27 52 1 1204342352 48122304 5078608
05:58:43 49352 8192000000 10111954208 10586320896 1166450080 12.464 100 16 32 0 1227366704 56792848 4123776
06:00:43 19775 8192000000 10162187696 10604056576 1167117456 12.470 100 26 52 0 1258843120 86485648 5240016
06:02:04 80352 8192000000 10192731024 10678206464 1163007520 12.431 100 13 25 0 1273079056 107094160 2977376
06:04:33 42086 8192000000 10188870688 10651648000 1167252464 12.471 100 24 48 1 1287598576 114862272 5483840
06:06:52 60154 8192000000 10130992736 10647113728 1158763632 12.392 100 16 32 0 1273997264 111593504 3640128
06:09:00 56015 8192000000 10132752320 10587418624 1125442864 12.078 96 26 50 1 1187358288 56900032 5015392
06:11:17 34173 8192000000 10074118336 10507628544 1111795280 11.949 96 16 32 2 1133992896 19179760 3017856
06:12:52 38324 8192000000 10150086944 10612961280 1126955936 12.093 99 24 48 0 1217128544 84945120 5227488
06:14:31 41831 8192000000 10041541264 10470346752 1059405712 11.451 94 25 50 2 1091628640 26960032 5262896
06:16:16 57442 8192000000 10073394560 10542047232 1106641424 11.901 99 27 54 0 1173985376 62206704 5137248
06:19:48 82258 8192000000 10047693120 10481889280 1077575648 11.624 97 29 58 0 1121440000 37768768 6095584
06:22:14 102842 8192000000 10026850576 10488414208 1050048400 11.361 94 10 20 0 1085103232 33153264 1901568
06:24:57 51256 8192000000 10058725936 10495004672 1085665856 11.701 97 24 48 0 1135817424 45171296 4980272
06:26:50 71463 8192000000 10072229488 10516070400 1068539440 11.538 97 14 28 0 1178490496 106973792 2977264
06:29:01 39677 8192000000 10012465584 10447548416 1030502912 11.173 94 22 44 1 1065496688 29835168 5158608
06:30:43 25101 8192000000 10090948800 10522480640 1108610080 11.919 100 23 47 0 1178814272 65166912 5037280
06:32:09 67828 8192000000 10099899936 10547871744 1110064720 11.933 100 23 46 2 1191762448 76735824 4961904
06:34:17 69940 8192000000 10122726592 10562457600 1118675008 12.014 100 28 56 0 1219822192 95425520 5721664
06:36:29 53050 8192000000 10071875904 10533961728 1126966272 12.093 100 18 35 1 1199749952 69684176 3099504
06:38:22 38104 8192000000 10101711328 10567106560 1146640272 12.278 100 12 24 0 1205322400 56430256 2251872
06:40:04 106909 8192000000 10108963520 10584559616 1144295840 12.256 100 25 50 0 1210277968 61007728 4974400
06:43:14 53528 8192000000 10154744384 10600935424 1155356912 12.360 100 12 22 0 1239830464 82252400 2221152
06:45:08 61108 8192000000 10095455680 10534903808 1153082384 12.338 100 22 44 1 1200160992 42573088 4505520
06:47:09 45365 8192000000 10142855840 10575077376 1136767568 12.185 98 32 63 0 1218628704 74961776 6899360
06:48:55 62621 8192000000 10095494704 10623381504 1142909744 12.243 100 15 30 0 1243366192 97496272 2960176
06:50:58 76246 8192000000 10105935824 10565173248 1116055408 11.990 97 20 40 0 1143142752 22536512 4550832
06:53:16 38349 8192000000 10106773776 10541379584 1144051904 12.254 100 25 50 0 1180775264 31975600 4747760
06:54:58 24712 8192000000 10113430304 10552967168 1140418464 12.219 99 39 77 1 1194350688 46624912 7307312
06:56:27 102369 8192000000 10071083552 10514972672 1122051680 12.046 98 18 36 0 1162486832 36983200 3451952
06:59:10 37123 8192000000 10063906960 10535452672 1135041152 12.169 99 8 14 0 1165655488 29824720 789616
07:00:49 50617 8192000000 10043893632 10498097152 1095359744 11.794 97 8 16 0 1120635088 24092704 1182640
07:02:40 52876 8192000000 10073694016 10539048960 1096847536 11.808 97 15 30 0 1136159296 36253200 3058560
07:04:40 95733 8192000000 10066258896 10508619776 1075035008 11.600 95 11 22 0 1159454512 82158704 2260800
07:07:19 37485 8192000000 9098560080 9348083712 240834672 2.855 22 9 18 0 275998896 33297776 1866448

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 17-02-2024 07:09:06 to 17-02-2024 07:09:20.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 155 v_add_invoice_to_stock 335544517
except 19 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-02-2024 07:09:21 to 17-02-2024 07:09:23.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          180650
MON$OLDEST_ACTIVE               180651
MON$OLDEST_SNAPSHOT             180651
MON$NEXT_TRANSACTION            180651
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-30 07:30:08.6030 GMT
MON$PAGES                       1921632
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             710
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3059 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3059 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3059 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3059 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sat Feb 17 07:09:24 2024 
 
Database header page information: 
    Flags            0 
    Generation        94928 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    180650 
    Oldest active        180651 
    Oldest snapshot        180651 
    Next transaction    180652 
    Sequence number        0 
    Next attachment ID    710 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    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: 1504333, 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: 1504335, 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: 1504334, 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: 1504332, 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: 1504331, 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: 532, Index root page: 533 
    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: 1504264, 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: 1504266, 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: 1504265, 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: 1504263, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.54, total records: 7760106 
    Average version length: 48.15, total versions: 69665, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 89360 
    Data pages: 89360, average fill: 69% 
    Primary pages: 89359, secondary pages: 1, swept pages: 38685 
    Empty pages: 4, full pages: 69760 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 53 
    40 - 59% = 2287 
    60 - 79% = 86981 
    80 - 99% = 27 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23255, nodes: 7760106 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.90, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1678557, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 331 
        20 - 39% = 1842 
        40 - 59% = 4002 
        60 - 79% = 2303 
        80 - 99% = 14777 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13513, nodes: 7760106 
    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: 1502728, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1606 
        40 - 59% = 1974 
        60 - 79% = 1038 
        80 - 99% = 8895 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8334, nodes: 7760106 
    Average node length: 6.62, total dup: 5803127, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1495729, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 118 
        20 - 39% = 989 
        40 - 59% = 1337 
        60 - 79% = 902 
        80 - 99% = 4988 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.66, total records: 2248107 
    Average version length: 58.88, total versions: 36591, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 29088 
    Data pages: 29080, average fill: 71% 
    Primary pages: 29078, secondary pages: 2, swept pages: 10177 
    Empty pages: 21, full pages: 18287 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 83 
    40 - 59% = 1137 
    60 - 79% = 27735 
    80 - 99% = 87 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4554, nodes: 2248107 
    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: 678294, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 977 
        40 - 59% = 774 
        60 - 79% = 710 
        80 - 99% = 2093 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2445, nodes: 2249489 
    Average node length: 4.97, total dup: 2248590, max dup: 19110 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1266579, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 220 
        40 - 59% = 1440 
        60 - 79% = 526 
        80 - 99% = 257 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1804, nodes: 2248107 
    Average node length: 4.97, total dup: 2248057, max dup: 130429 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074034, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 650 
        60 - 79% = 55 
        80 - 99% = 1097 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4374, nodes: 2248107 
    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: 678294, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 90 
        20 - 39% = 679 
        40 - 59% = 580 
        60 - 79% = 803 
        80 - 99% = 2222 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    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: 1504337, 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: 1504338, 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: 1504336, 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: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, 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.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, 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: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.38, total records: 400 
    Average version length: 26.83, total versions: 2303, max versions: 6 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 72% 
    Primary pages: 8, secondary pages: 16, swept pages: 0 
    Empty pages: 1, full pages: 17 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 17 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, 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: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 11.35, total records: 74968 
    Average version length: 68.28, total versions: 71989, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 7.75 
    Pointer pages: 7, data page slots: 3088 
    Data pages: 1696, average fill: 61% 
    Primary pages: 1695, secondary pages: 1, swept pages: 0 
    Empty pages: 311, full pages: 879 
    Fill distribution: 
     0 - 19% = 395 
    20 - 39% = 144 
    40 - 59% = 174 
    60 - 79% = 148 
    80 - 99% = 835 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1712861, depth: 3, leaf buckets: 302, nodes: 74968 
    Average node length: 13.45, total dup: 5743, max dup: 1 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.28, average data length: 7.72 
    Clustering factor: 52159, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 188 
        40 - 59% = 75 
        60 - 79% = 38 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 238, max versions: 10 
    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: 6 
    Data pages: 6, average fill: 16% 
    Primary pages: 1, secondary pages: 5, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, 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: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 11.88, total records: 1571 
    Average version length: 43.65, total versions: 1435, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.88 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 52% 
    Primary pages: 31, secondary pages: 1, swept pages: 3 
    Empty pages: 6, full pages: 13 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 6 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90549, depth: 2, leaf buckets: 3, nodes: 1571 
    Average node length: 4.31, total dup: 1473, max dup: 160 
    Average key length: 2.66, compression ratio: 7.14 
    Average prefix length: 18.40, average data length: 0.60 
    Clustering factor: 872, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.71, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    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: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    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: 1504251, 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: 1504249, 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: 1504248, 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: 1504250, 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: 1504247, 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: 550, Index root page: 551 
    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: 1504246, 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: 1504244, 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: 1504243, 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: 1504245, 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: 1504242, 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: 496, Index root page: 497 
    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: 1544827, 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: 1544826, 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: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.12, total records: 816869 
    Average version length: 37.92, total versions: 31198, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8496 
    Data pages: 8496, average fill: 66% 
    Primary pages: 8493, secondary pages: 3, swept pages: 1539 
    Empty pages: 20, full pages: 7240 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 57 
    40 - 59% = 364 
    60 - 79% = 7977 
    80 - 99% = 64 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 852, nodes: 797958 
    Average node length: 4.88, total dup: 797909, max dup: 148422 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90189, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 125 
        40 - 59% = 458 
        60 - 79% = 169 
        80 - 99% = 100 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 874, nodes: 797958 
    Average node length: 5.89, total dup: 709944, max dup: 48 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159041, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 28 
        40 - 59% = 393 
        60 - 79% = 114 
        80 - 99% = 338 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 907, nodes: 797958 
    Average node length: 5.89, total dup: 709944, max dup: 48 
    Average key length: 3.02, compression ratio: 7.27 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160986, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 74 
        40 - 59% = 394 
        60 - 79% = 113 
        80 - 99% = 325 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1136, nodes: 797958 
    Average node length: 5.98, total dup: 709944, max dup: 48 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 153558, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 253 
        40 - 59% = 586 
        60 - 79% = 207 
        80 - 99% = 88 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.74, total records: 5537 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.06, total fragments: 48, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 128 
    Data pages: 119, average fill: 46% 
    Primary pages: 102, secondary pages: 17, swept pages: 51 
    Empty pages: 29, full pages: 53 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5537 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.12 
    Average prefix length: 34.60, average data length: 1.54 
    Clustering factor: 5227, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5537 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 179, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.07, total records: 81424 
    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: 848 
    Data pages: 848, average fill: 66% 
    Primary pages: 848, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 845 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 845 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35778, depth: 2, leaf buckets: 104, nodes: 81424 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3024, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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: 1504261, 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: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.51, total records: 71 
    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.30 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    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: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.57, total records: 158841 
    Average version length: 152.79, total versions: 1640, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 6, data page slots: 4376 
    Data pages: 3984, average fill: 82% 
    Primary pages: 3982, secondary pages: 2, swept pages: 1 
    Empty pages: 50, full pages: 3877 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 27 
    40 - 59% = 27 
    60 - 79% = 1 
    80 - 99% = 3877 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.98, total records: 160069 
    Average version length: 138.91, total versions: 188, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 6, data page slots: 4688 
    Data pages: 3952, average fill: 83% 
    Primary pages: 3951, secondary pages: 1, swept pages: 3 
    Empty pages: 17, full pages: 3929 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3929 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.87, total records: 163893 
    Average version length: 140.50, total versions: 118, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 7, data page slots: 4792 
    Data pages: 4072, average fill: 83% 
    Primary pages: 4070, secondary pages: 2, swept pages: 1 
    Empty pages: 47, full pages: 4016 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 4016 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 148.42, total records: 159774 
    Average version length: 153.20, total versions: 2946, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 8, data page slots: 4888 
    Data pages: 3968, average fill: 83% 
    Primary pages: 3965, secondary pages: 3, swept pages: 3 
    Empty pages: 37, full pages: 3917 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 3918 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 150.69, total records: 168973 
    Average version length: 152.22, total versions: 509, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 9, data page slots: 4320 
    Data pages: 4192, average fill: 83% 
    Primary pages: 4191, secondary pages: 1, swept pages: 2 
    Empty pages: 32, full pages: 4142 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 3 
    40 - 59% = 13 
    60 - 79% = 2 
    80 - 99% = 4141 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 150.85, total records: 161945 
    Average version length: 137.55, total versions: 84, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 7, data page slots: 4336 
    Data pages: 4016, average fill: 83% 
    Primary pages: 4014, secondary pages: 2, swept pages: 1 
    Empty pages: 42, full pages: 3966 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3966 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 151.11, total records: 166249 
    Average version length: 138.59, total versions: 129, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.22 
    Pointer pages: 9, data page slots: 4264 
    Data pages: 4112, average fill: 83% 
    Primary pages: 4110, secondary pages: 2, swept pages: 1 
    Empty pages: 23, full pages: 4081 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 4081 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 150.16, total records: 151891 
    Average version length: 152.79, total versions: 881, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 4008 
    Data pages: 3760, average fill: 83% 
    Primary pages: 3758, secondary pages: 2, swept pages: 1 
    Empty pages: 31, full pages: 3722 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3722 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.24, total records: 161421 
    Average version length: 151.87, total versions: 831, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 5200 
    Data pages: 4000, average fill: 83% 
    Primary pages: 3998, secondary pages: 2, swept pages: 4 
    Empty pages: 33, full pages: 3956 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3957 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 149.39, total records: 161878 
    Average version length: 154.01, total versions: 1733, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 4840 
    Data pages: 4024, average fill: 83% 
    Primary pages: 4023, secondary pages: 1, swept pages: 1 
    Empty pages: 46, full pages: 3968 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3969 
 
PHRASES (143) 
    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 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, 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: 1510375, 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: 1510374, 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: 1510373, 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: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.09, total records: 2099921 
    Average version length: 52.92, total versions: 31491, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25776 
    Data pages: 25776, average fill: 70% 
    Primary pages: 25763, secondary pages: 13, swept pages: 11648 
    Empty pages: 104, full pages: 21737 
    Fill distribution: 
     0 - 19% = 236 
    20 - 39% = 293 
    40 - 59% = 959 
    60 - 79% = 23993 
    80 - 99% = 295 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2578, nodes: 2099921 
    Average node length: 5.44, total dup: 1959239, max dup: 2065 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182562, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 282 
        40 - 59% = 1692 
        60 - 79% = 288 
        80 - 99% = 311 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2756, nodes: 2099921 
    Average node length: 5.69, total dup: 1884505, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376068, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2389 
        60 - 79% = 334 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2114, nodes: 2099921 
    Average node length: 4.96, total dup: 2099821, max dup: 27814 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 180550, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 212 
        40 - 59% = 1060 
        60 - 79% = 391 
        80 - 99% = 451 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    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: 1504339, 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: 498, Index root page: 499 
    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: 1544825, 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: 1544824, 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: 528, Index root page: 529 
    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: 1504327, 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: 1504328, 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: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, 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: 1544931, 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: 1544828, 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: 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 TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, 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: 488, Index root page: 489 
    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: 1544829, 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: 490, Index root page: 491 
    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: 492, Index root page: 493 
    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: 546, Index root page: 547 
    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: 544, Index root page: 545 
    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: 1504252, 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: 486, Index root page: 487 
    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: 484, Index root page: 485 
    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: 1544831, 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: 1544830, 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: 480, Index root page: 481 
    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: 1544833, 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: 557, Index root page: 558 
    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: 1504237, 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: 538, Index root page: 539 
    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: 508, Index root page: 509 
    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: 1552183, 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: 1510377, 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: 1510382, 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: 1510380, 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: 526, Index root page: 527 
    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: 1504329, 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: 1504330, 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: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 40.15, total records: 154539 
    Average version length: 69.16, total versions: 74583, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.14 
    Pointer pages: 3, data page slots: 4632 
    Data pages: 3383, average fill: 56% 
    Primary pages: 3383, secondary pages: 0, swept pages: 463 
    Empty pages: 631, full pages: 1934 
    Fill distribution: 
     0 - 19% = 889 
    20 - 39% = 182 
    40 - 59% = 200 
    60 - 79% = 830 
    80 - 99% = 1282 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105888, depth: 3, leaf buckets: 235, nodes: 154539 
    Average node length: 6.45, total dup: 134525, max dup: 14 
    Average key length: 3.93, compression ratio: 10.69 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 27079, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 46 
        40 - 59% = 114 
        60 - 79% = 57 
        80 - 99% = 17 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.24, total records: 7080021 
    Average version length: 68.77, total versions: 438782, 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: 66, data page slots: 106944 
    Data pages: 106944, average fill: 71% 
    Primary pages: 106943, secondary pages: 1, swept pages: 19281 
    Empty pages: 31, full pages: 74390 
    Fill distribution: 
     0 - 19% = 185 
    20 - 39% = 1023 
    40 - 59% = 8130 
    60 - 79% = 96150 
    80 - 99% = 1456 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10697, nodes: 7080021 
    Average node length: 6.52, total dup: 6120898, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1656756, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1502 
        40 - 59% = 5991 
        60 - 79% = 2769 
        80 - 99% = 428 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8423, nodes: 7080021 
    Average node length: 5.40, total dup: 6796158, max dup: 159 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1461027, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1141 
        40 - 59% = 4603 
        60 - 79% = 1478 
        80 - 99% = 1195 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8456, nodes: 7080021 
    Average node length: 5.40, total dup: 6796158, max dup: 159 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1463383, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1199 
        40 - 59% = 4534 
        60 - 79% = 1537 
        80 - 99% = 1183 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.22, total records: 12063240 
    Average version length: 68.71, total versions: 345079, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 107, data page slots: 174472 
    Data pages: 174472, average fill: 74% 
    Primary pages: 174471, secondary pages: 1, swept pages: 59016 
    Empty pages: 3, full pages: 157786 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 555 
    40 - 59% = 4186 
    60 - 79% = 167478 
    80 - 99% = 2202 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18371, nodes: 12061123 
    Average node length: 6.61, total dup: 10511016, max dup: 79 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2476187, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2144 
        40 - 59% = 10937 
        60 - 79% = 4448 
        80 - 99% = 819 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 47.30, total records: 1551565 
    Average version length: 69.08, total versions: 366607, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.66 
    Pointer pages: 26, data page slots: 41232 
    Data pages: 29438, average fill: 55% 
    Primary pages: 29373, secondary pages: 65, swept pages: 7262 
    Empty pages: 2699, full pages: 17927 
    Fill distribution: 
     0 - 19% = 5061 
    20 - 39% = 4051 
    40 - 59% = 3180 
    60 - 79% = 12603 
    80 - 99% = 4543 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1835, nodes: 1354352 
    Average node length: 5.52, total dup: 1299057, max dup: 49 
    Average key length: 2.57, compression ratio: 16.34 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 97166, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 459 
        40 - 59% = 892 
        60 - 79% = 388 
        80 - 99% = 88 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 38.04, total records: 1294035 
    Average version length: 69.05, total versions: 178564, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.31 
    Pointer pages: 22, data page slots: 34416 
    Data pages: 31248, average fill: 35% 
    Primary pages: 31246, secondary pages: 2, swept pages: 7394 
    Empty pages: 6255, full pages: 11264 
    Fill distribution: 
     0 - 19% = 11391 
    20 - 39% = 5520 
    40 - 59% = 6321 
    60 - 79% = 7576 
    80 - 99% = 440 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1263, nodes: 804632 
    Average node length: 5.92, total dup: 742476, max dup: 73 
    Average key length: 2.99, compression ratio: 14.04 
    Average prefix length: 41.09, average data length: 0.91 
    Clustering factor: 113090, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 441 
        40 - 59% = 587 
        60 - 79% = 224 
        80 - 99% = 11 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.45, total records: 9215900 
    Average version length: 68.90, total versions: 370702, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 90, data page slots: 145360 
    Data pages: 145360, average fill: 68% 
    Primary pages: 145349, secondary pages: 11, swept pages: 51906 
    Empty pages: 254, full pages: 74443 
    Fill distribution: 
     0 - 19% = 719 
    20 - 39% = 3881 
    40 - 59% = 22410 
    60 - 79% = 116100 
    80 - 99% = 2250 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13506, nodes: 9210067 
    Average node length: 6.69, total dup: 7640270, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2080269, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1251 
        40 - 59% = 6910 
        60 - 79% = 4681 
        80 - 99% = 663 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21168090 
    Average version length: 82.77, total versions: 9970, 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: 197, data page slots: 319992 
    Data pages: 319992, average fill: 81% 
    Primary pages: 319988, secondary pages: 4, swept pages: 12939 
    Empty pages: 9, full pages: 319830 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 5 
    40 - 59% = 10 
    60 - 79% = 49808 
    80 - 99% = 270153 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19271, nodes: 21168090 
    Average node length: 5.72, total dup: 20686613, max dup: 138 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3288656, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 7875 
        60 - 79% = 564 
        80 - 99% = 10826 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17219, nodes: 21168090 
    Average node length: 6.31, total dup: 18602925, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 919963, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 3 
        40 - 59% = 821 
        60 - 79% = 284 
        80 - 99% = 16102 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21105, nodes: 21168090 
    Average node length: 6.35, total dup: 18521506, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582388, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8245 
        60 - 79% = 616 
        80 - 99% = 12240 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16272, nodes: 21168090 
    Average node length: 5.56, total dup: 21167990, max dup: 230442 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948686, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 3207 
        60 - 79% = 379 
        80 - 99% = 12677 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.36, total records: 9697757 
    Average version length: 82.60, total versions: 404145, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 105, data page slots: 170240 
    Data pages: 170224, average fill: 71% 
    Primary pages: 170201, secondary pages: 23, swept pages: 69639 
    Empty pages: 436, full pages: 100404 
    Fill distribution: 
     0 - 19% = 1008 
    20 - 39% = 4364 
    40 - 59% = 23406 
    60 - 79% = 119836 
    80 - 99% = 21610 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11376, nodes: 9697757 
    Average node length: 5.37, total dup: 9388675, max dup: 177 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2222497, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 66 
        40 - 59% = 8235 
        60 - 79% = 2992 
        80 - 99% = 80 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13460, nodes: 9697757 
    Average node length: 6.24, total dup: 8039594, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1576185, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 112 
        20 - 39% = 3923 
        40 - 59% = 4209 
        60 - 79% = 2720 
        80 - 99% = 2496 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12711, nodes: 9697757 
    Average node length: 5.98, total dup: 8417225, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2410060, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 83 
        40 - 59% = 9294 
        60 - 79% = 3226 
        80 - 99% = 105 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9950, nodes: 9697757 
    Average node length: 5.14, total dup: 9697657, max dup: 158997 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1599121, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1135 
        40 - 59% = 4661 
        60 - 79% = 1875 
        80 - 99% = 2233 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.44, total records: 11311060 
    Average version length: 82.54, total versions: 287645, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 119, data page slots: 194080 
    Data pages: 192896, average fill: 72% 
    Primary pages: 192763, secondary pages: 133, swept pages: 68890 
    Empty pages: 2129, full pages: 145496 
    Fill distribution: 
     0 - 19% = 4015 
    20 - 39% = 7452 
    40 - 59% = 18533 
    60 - 79% = 98484 
    80 - 99% = 64412 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13149, nodes: 11311060 
    Average node length: 5.31, total dup: 11200997, max dup: 684 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2380230, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 158 
        40 - 59% = 9097 
        60 - 79% = 3675 
        80 - 99% = 218 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10482, nodes: 11311060 
    Average node length: 5.51, total dup: 10816474, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 742767, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 167 
        20 - 39% = 882 
        40 - 59% = 2523 
        60 - 79% = 1844 
        80 - 99% = 5066 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15035, nodes: 11311060 
    Average node length: 6.04, total dup: 9867647, max dup: 66 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2396506, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 203 
        40 - 59% = 10579 
        60 - 79% = 3964 
        80 - 99% = 285 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10825, nodes: 11311060 
    Average node length: 5.23, total dup: 11310960, max dup: 216725 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 731132, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 87 
        20 - 39% = 830 
        40 - 59% = 4862 
        60 - 79% = 1511 
        80 - 99% = 3535 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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: 1361775, 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: 1361777, 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: 1361776, 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: 1361774, 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: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.08, total records: 9762223 
    Average version length: 82.82, total versions: 352621, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 106, data page slots: 171928 
    Data pages: 171904, average fill: 70% 
    Primary pages: 171882, secondary pages: 22, swept pages: 75419 
    Empty pages: 334, full pages: 97253 
    Fill distribution: 
     0 - 19% = 848 
    20 - 39% = 4124 
    40 - 59% = 23763 
    60 - 79% = 123522 
    80 - 99% = 19647 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11811, nodes: 9762223 
    Average node length: 5.18, total dup: 9733320, max dup: 1554 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2036850, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1470 
        40 - 59% = 7877 
        60 - 79% = 1860 
        80 - 99% = 575 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13571, nodes: 9762223 
    Average node length: 6.25, total dup: 8092672, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1558310, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 188 
        20 - 39% = 3937 
        40 - 59% = 4131 
        60 - 79% = 2762 
        80 - 99% = 2553 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12467, nodes: 9762223 
    Average node length: 5.44, total dup: 9323774, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2167826, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1433 
        40 - 59% = 8831 
        60 - 79% = 1629 
        80 - 99% = 550 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10138, nodes: 9762223 
    Average node length: 5.15, total dup: 9762123, max dup: 160885 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1635515, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1201 
        40 - 59% = 4845 
        60 - 79% = 1865 
        80 - 99% = 2183 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.57, total records: 576098 
    Average version length: 68.71, total versions: 5861, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8096 
    Data pages: 8096, average fill: 75% 
    Primary pages: 8096, secondary pages: 0, swept pages: 3785 
    Empty pages: 1, full pages: 6844 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 5 
    40 - 59% = 148 
    60 - 79% = 7848 
    80 - 99% = 94 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42996, depth: 3, leaf buckets: 748, nodes: 576098 
    Average node length: 5.95, total dup: 490429, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101482, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 544 
        60 - 79% = 95 
        80 - 99% = 79 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36007, depth: 3, leaf buckets: 766, nodes: 576098 
    Average node length: 6.15, total dup: 472490, max dup: 23 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101532, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 34 
        40 - 59% = 549 
        60 - 79% = 90 
        80 - 99% = 92 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 578, nodes: 576098 
    Average node length: 4.86, total dup: 575998, max dup: 9269 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90295, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 357 
        60 - 79% = 61 
        80 - 99% = 123 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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: 563, Index root page: 564 
    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: 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 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    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: 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 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    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: 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 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    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: 1504235, 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: 1504236, 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: 571, Index root page: 572 
    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: 1504232, 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: 1504231, 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: 1504234, 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: 1504233, 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: 561, Index root page: 562 
    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: 559, Index root page: 560 
    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: 512, Index root page: 513 
    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: 1510372, 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 Sat Feb 17 07:09:48 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7760106 69665 1 0.0000 0.0000
DOC_LIST 2248107 36591 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2303 6 500.0000 0.0000
INVNT_TURNOVER_LOG 74968 71989 1 0.0000 0.0000
MONEY_SALDO 49 238 10 400.0000 0.0000
MONEY_TURNOVER_LOG 1571 1435 1 0.0000 0.0000
PDISTR 816869 31198 3 0.0000 0.0000
PERF_SPLIT_0 158841 1640 1 0.0000 0.0000
PERF_SPLIT_1 160069 188 1 0.0000 0.0000
PERF_SPLIT_2 163893 118 1 0.0000 0.0000
PERF_SPLIT_3 159774 2946 1 0.0000 0.0000
PERF_SPLIT_4 168973 509 1 0.0000 0.0000
PERF_SPLIT_5 161945 84 1 0.0000 0.0000
PERF_SPLIT_6 166249 129 1 0.0000 0.0000
PERF_SPLIT_7 151891 881 1 0.0000 0.0000
PERF_SPLIT_8 161421 831 1 0.0000 0.0000
PERF_SPLIT_9 161878 1733 1 0.0000 0.0000
PSTORNED 2099921 31491 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 154539 74583 1 0.0000 0.0000
XQD_1000_3300 7080021 438782 1 0.0000 0.0000
XQD_1200_2000 12063240 345079 1 0.0000 0.0000
XQD_2000_3300 1551565 366607 1 0.0000 0.0000
XQD_2100_3300 1294035 178564 1 0.0000 0.0000
XQD_3300_3400 9215900 370702 1 0.0000 0.0000
XQS_1000_1200 21168090 9970 1 0.0000 0.0000
XQS_1000_3300 9697757 404145 1 0.0000 0.0000
XQS_1200_2000 11311060 287645 1 0.0000 0.0000
XQS_2100_3300 9762223 352621 1 0.0000 0.0000
XQS_3300_3400 576098 5861 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 ---
:102: 
:103: mscs-test-161.budzdorov.ru    Sat Feb 17 07:07:59 2024
:104:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:105: 
:106: 
:107: mscs-test-161.budzdorov.ru    Sat Feb 17 07:08:04 2024
:108:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:109: 
--- end of diff output ---

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

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