Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.02.2024 04: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 15616440 kB
MemAvailable 30244212 kB
Buffers 20 kB
Cached 16046624 kB
SwapCached 2400 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-22 04:07:47
DTS_END                         2024-02-22 04:07:47.2030
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/58092
TRN_ID                          178799
ATT_ID                          593
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: 9461.72 20952 946172
customer order: creation 186.13 379 18613
customer order: refuse 16.41 362 1641
order to supplier: creation 49.91 1261 4991
order to supplier: removal 3.62 94284 362
invoice (draft): creation 48.94 2950 4894
invoice (draft): removal 50.49 714 5049
invoice accept: apply 44.63 19498 4463
invoice accept: cancel 45.49 804 4549
customer reserve: creation 4252.28 188 425228
customer reserve: removal 4455.99 62 445599
realization accept: apply 92.33 208 9233
realization accept: cancel 78.77 139 7877
payment from customer: creation 61.49 141 6149
payment from customer: removal 6.28 96 628
payment to supplier: creation 53.25 167 5325
payment to supplier: removal 3.65 83 365
service: total inventory turnovers 4.09 3519 409
service: total monetary turnovers 7.08 584 708
service: aggregate perf. data 0.86 18463 86
service: refresh index statistics 0.03 275147 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 22-02-2024 04:08:35 to 22-02-2024 04:08:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3529
TEST_TIME 2 4032
TEST_TIME 3 3853
TEST_TIME 4 3623
TEST_TIME 5 4079
TEST_TIME 6 4970
TEST_TIME 7 4911
TEST_TIME 8 5275
TEST_TIME 9 5356
TEST_TIME 10 5904
TEST_TIME 11 5771
TEST_TIME 12 5996
TEST_TIME 13 6089
TEST_TIME 14 6425
TEST_TIME 15 6606
TEST_TIME 16 6860
TEST_TIME 17 6975
TEST_TIME 18 7471
TEST_TIME 19 7570
TEST_TIME 20 7647
TEST_TIME 21 8189
TEST_TIME 22 8464
TEST_TIME 23 8272
TEST_TIME 24 8559
TEST_TIME 25 9002
TEST_TIME 26 9780
TEST_TIME 27 10183
TEST_TIME 28 10048
TEST_TIME 29 10001
TEST_TIME 30 9833
TEST_TIME 31 9890
TEST_TIME 32 9795
TEST_TIME 33 9798
TEST_TIME 34 9550
TEST_TIME 35 9548
TEST_TIME 36 9406
TEST_TIME 37 9346
TEST_TIME 38 9317
TEST_TIME 39 9304
TEST_TIME 40 9353
TEST_TIME 41 9439
TEST_TIME 42 9396
TEST_TIME 43 9276
TEST_TIME 44 9241
TEST_TIME 45 9238
TEST_TIME 46 9366
TEST_TIME 47 9377
TEST_TIME 48 9381
TEST_TIME 49 9461
TEST_TIME 50 9553
TEST_TIME 51 9462
TEST_TIME 52 9579
TEST_TIME 53 9653
TEST_TIME 54 9653
TEST_TIME 55 9755
TEST_TIME 56 9743
TEST_TIME 57 9878
TEST_TIME 58 9746
TEST_TIME 59 9657
TEST_TIME 60 9564
TEST_TIME 61 9522
TEST_TIME 62 9616
TEST_TIME 63 9574
TEST_TIME 64 9519
TEST_TIME 65 9499
TEST_TIME 66 9414
TEST_TIME 67 9334
TEST_TIME 68 9377
TEST_TIME 69 9331
TEST_TIME 70 9374
TEST_TIME 71 9376
TEST_TIME 72 9409
TEST_TIME 73 9410
TEST_TIME 74 9469
TEST_TIME 75 9419
TEST_TIME 76 9500
TEST_TIME 77 9502
TEST_TIME 78 9556
TEST_TIME 79 9595
TEST_TIME 80 9622
TEST_TIME 81 9634
TEST_TIME 82 9555
TEST_TIME 83 9477
TEST_TIME 84 9495
TEST_TIME 85 9457
TEST_TIME 86 9409
TEST_TIME 87 9357
TEST_TIME 88 9289
TEST_TIME 89 9235
TEST_TIME 90 9258
TEST_TIME 91 9262
TEST_TIME 92 9246
TEST_TIME 93 9290
TEST_TIME 94 9307
TEST_TIME 95 9277
TEST_TIME 96 9362
TEST_TIME 97 9396
TEST_TIME 98 9392
TEST_TIME 99 9377
TEST_TIME 100 9467

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-02-2024 04:08:39 to 22-02-2024 04:08:42.

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 1334342 1334342 0 0.00 0 38111 8 0 0
doc_list_biud 1334341 1334341 0 0.00 0 32410 26 0 0
sp_add_invoice_to_stock 4591 4463 128 2.78 43 168607 19498 0 128
sp_cancel_adding_invoice 4549 4549 0 0.00 4 68298 804 0 0
sp_cancel_client_order 1641 1641 0 0.00 4 9736 363 0 0
sp_cancel_customer_reserve 445599 445599 0 0.00 0 23517 62 0 0
sp_cancel_pay_from_customer 628 628 0 0.00 2 13559 97 0 0
sp_cancel_pay_to_supplier 365 365 0 0.00 2 4429 84 0 0
sp_cancel_supplier_invoice 5064 5049 15 0.29 1 32417 715 0 15
sp_cancel_supplier_order 362 362 0 0.00 6 1007105 94285 0 0
sp_cancel_write_off 7877 7877 0 0.00 1 9037 140 0 0
sp_client_order 18613 18613 0 0.00 3 19312 380 0 0
sp_customer_reserve 425228 425228 0 0.00 0 104192 189 0 0
sp_fill_shopping_cart 28491 28491 0 0.00 1 15474 37 0 0
sp_fill_shopping_cart_clo_res 425220 425220 0 0.00 0 15478 16 0 0
sp_get_clo_for_invoice 4455 4455 0 0.00 0 37898 355 0 0
sp_kill_cost_storno 13419 13419 0 0.00 0 13150 69 0 0
sp_kill_qstorno_ret_qs2qd 904486 904486 0 0.00 0 32407 33 0 0
sp_kill_qty_storno 478765 478765 0 0.00 0 32410 71 0 0
sp_lock_selected_doc 19014 19014 0 0.00 0 8308 4 0 0
sp_make_cost_storno 25162 25162 0 0.00 0 37447 73 0 0
sp_multiply_rows_for_pdistr 25162 25162 0 0.00 0 24931 37 0 0
sp_multiply_rows_for_qdistr 18613 18613 0 0.00 0 14807 195 0 0
sp_pay_from_customer 6149 6149 0 0.00 4 27319 141 0 0
sp_pay_to_supplier 5325 5325 0 0.00 4 34515 167 0 0
sp_payment_common 11474 11474 0 0.00 1 24926 37 0 0
sp_qd_handle_on_cancel_clo 1641 1641 0 0.00 0 9705 328 0 0
sp_qd_handle_on_invoice_upd_sts 9004 9004 0 0.00 0 17849 296 0 0
sp_qd_handle_on_reserve_upd_sts 9233 9233 0 0.00 0 13284 60 0 0
sp_reserve_write_off 9233 9233 0 0.00 5 29666 209 0 0
sp_supplier_invoice 4894 4894 0 0.00 6 74214 2950 0 0
sp_supplier_order 4991 4991 0 0.00 4 31930 1261 0 0
srv_aggregate_perf_data 86 86 0 0.00 1772 257275 18464 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1773 138986 41860 0 0
srv_find_qd_qs_mism 900326 900326 0 0.00 0 12551 7 0 0
srv_make_invnt_saldo 409 409 0 0.00 52 101841 3520 0 0
srv_make_money_saldo 708 708 0 0.00 1 17210 584 0 0
srv_recalc_idx_stat 3 3 0 0.00 198693 329831 275147 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4463 4463 0 0.00 0 7408 153 0 0
t$perf-norm:sp_cancel_adding_invoice 370 370 0 0.00 0 2998 81 0 0
t$perf-norm:sp_cancel_client_order 1641 1641 0 0.00 0 2894 10 0 0
t$perf-norm:sp_cancel_customer_reserve 629 629 0 0.00 0 2266 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 628 628 0 0.00 0 679 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 365 365 0 0.00 0 849 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 359 359 0 0.00 0 2997 38 0 0
t$perf-norm:sp_cancel_supplier_order 362 362 0 0.00 0 19904 1512 0 0
t$perf-norm:sp_cancel_write_off 972 972 0 0.00 0 1234 8 0 0
t$perf-norm:sp_client_order 18613 18613 0 0.00 0 5480 14 0 0
t$perf-norm:sp_customer_reserve 891 891 0 0.00 0 987 4 0 0
t$perf-norm:sp_pay_from_customer 6149 6149 0 0.00 0 3093 6 0 0
t$perf-norm:sp_pay_to_supplier 5325 5325 0 0.00 0 2871 7 0 0
t$perf-norm:sp_reserve_write_off 9233 9233 0 0.00 0 7694 11 0 0
t$perf-norm:sp_supplier_invoice 4894 4894 0 0.00 0 4007 15 0 0
t$perf-norm:sp_supplier_order 4991 4991 0 0.00 0 5568 14 0 0
t$perf-norm:srv_aggregate_perf_data 86 86 0 0.00 0 129 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 2 0 0 0
t$perf-norm:srv_make_invnt_saldo 409 409 0 0.00 0 4434 24 0 0
t$perf-norm:srv_make_money_saldo 708 708 0 0.00 0 705 6 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 9 4 0 0
v_add_invoice_to_stock 9166 8910 256 2.79 0 8068 19 0 256
v_all_customers 33712 33712 0 0.00 0 94 1 0 0
v_all_suppliers 28274 28274 0 0.00 0 128 1 0 0
v_all_wares 37226 37226 0 0.00 0 232 1 0 0
v_cancel_adding_invoice 740 740 0 0.00 0 1944 12 0 0
v_cancel_client_order 3282 3282 0 0.00 0 9056 11 0 0
v_cancel_customer_prepayment 1256 1256 0 0.00 0 1390 7 0 0
v_cancel_customer_reserve 1258 1258 0 0.00 0 4104 10 0 0
v_cancel_payment_to_supplier 730 730 0 0.00 0 4396 12 0 0
v_cancel_supplier_invoice 748 718 30 4.01 0 2988 22 0 30
v_cancel_supplier_order 724 724 0 0.00 0 4486 22 0 0
v_cancel_write_off 1944 1944 0 0.00 0 7611 27 0 0
v_max_id_clo_ord 4990 4990 0 0.00 0 1645 2 0 0
v_max_id_clo_res 891 891 0 0.00 0 1855 12 0 0
v_max_id_ord_sup 4888 4888 0 0.00 0 3731 5 0 0
v_max_non_paid_invoice 1066 1066 0 0.00 0 81 2 0 0
v_max_non_paid_realizn 3282 3282 0 0.00 0 5014 4 0 0
v_min_id_clo_ord 4990 4990 0 0.00 0 12420 8 0 0
v_min_id_clo_res 891 891 0 0.00 0 3274 12 0 0
v_min_id_ord_sup 4888 4888 0 0.00 0 6185 4 0 0
v_min_non_paid_invoice 5325 5325 0 0.00 0 24916 32 0 0
v_min_non_paid_realizn 6149 6149 0 0.00 0 24878 28 0 0
v_our_firm 9248 9248 0 0.00 0 20 1 0 0
v_reserve_write_off 18466 18466 0 0.00 0 6806 8 0 0
x_lock_depdocs_on_canc_invoice 9239 9239 0 0.00 0 10775 105 0 0
x_lock_depdocs_on_canc_sup_ord 362 362 0 0.00 0 2719 296 0 0
x_make_qstorno_1000_1200 4991 4991 0 0.00 1 31925 1183 0 0
x_make_qstorno_1200_2000 4894 4894 0 0.00 2 67328 2814 0 0
x_make_qstorno_2100_3300 425228 425228 0 0.00 0 104191 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-02-2024 04:08:43 to 22-02-2024 04:08:47.

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
02:07:51 1 8192000000 8796669328 8807108608 3187328 0.038 1 1 2 0 3284944 61840 35776
02:08:52 12665 8192000000 9713296784 10010558464 797144368 8.867 100 87 175 0 825720864 7683680 20892816
02:10:12 17024 8192000000 9761595136 10072195072 838808944 9.288 100 90 180 0 871383232 10795136 21779152
02:11:35 15536 8192000000 9799268176 10115362816 867894608 9.579 100 85 170 0 904788128 17612672 19280848
02:12:57 15165 8192000000 9843357968 10173046784 895366208 9.852 100 85 170 0 950706896 36388720 18951968
02:14:17 7654 8192000000 9909021952 10248343552 944873296 10.341 100 77 154 0 1017987152 57118320 15995536
02:15:29 6281 8192000000 9957949696 10308268032 969680160 10.584 100 84 167 1 1060744496 73678960 17385376
02:16:37 3721 8192000000 9971192288 10327490560 998779552 10.867 100 80 160 2 1083339984 68873632 15686800
02:17:43 1336 8192000000 9999842016 10361524224 1024324032 11.114 100 87 173 0 1111224128 69619104 17280992
02:18:47 1533 8192000000 10012877568 10383163392 1050102336 11.362 100 85 169 1 1120273680 52753760 17417584
02:19:50 1376 8192000000 10039953520 10420903936 1068275888 11.536 100 73 147 0 1155312048 72779008 14257152
02:20:54 34616 8192000000 10001960720 10414637056 1073667632 11.587 100 51 101 0 1160670656 77016416 9986608
02:22:33 4803 8192000000 10029221056 10427351040 1082184336 11.668 100 43 85 1 1144409648 53461680 8763632
02:23:40 6321 8192000000 10012306064 10417627136 1091137600 11.753 100 41 82 0 1115994832 15561968 9295264
02:24:51 21293 8192000000 10032014176 10442633216 1093228208 11.773 100 38 76 0 1123713200 22468352 8016640
02:26:15 4288 8192000000 10019381056 10421624832 1099943712 11.837 100 42 82 0 1129544320 21051408 8549200
02:27:20 7107 8192000000 10021178960 10434347008 1090154880 11.744 99 29 58 0 1122138736 25697008 6286848
02:28:37 13066 8192000000 10040011696 10444656640 1105836416 11.893 100 57 111 0 1151031936 34374032 10821488
02:29:57 56207 8192000000 10035858368 10435899392 1067453824 11.528 96 47 92 0 1132772544 55126352 10192368
02:32:10 5089 8192000000 10079564640 10486493184 1105586960 11.891 100 48 96 1 1191952208 76740416 9624832
02:33:21 11798 8192000000 10069487440 10475642880 1114708144 11.977 100 48 96 0 1184063440 59425904 9929392
02:34:35 12280 8192000000 10098337584 10498248704 1108376768 11.917 100 58 111 0 1213354224 93487888 11489568
02:35:50 17792 8192000000 10120242960 10528333824 1120187936 12.029 100 43 84 0 1225390896 95850000 9352960
02:37:13 12458 8192000000 10114149040 10539360256 1103951552 11.875 98 52 103 0 1226605264 111487696 11166016
02:38:32 22391 8192000000 10148134640 10549436416 1101942800 11.856 100 53 103 0 1243848272 131033120 10872352
02:39:58 4890 8192000000 10148023840 10537230336 1087449056 11.718 98 62 114 1 1247982224 147941088 12592080
02:41:06 1772 8192000000 10210643856 10599505920 1119771488 12.025 100 76 151 1 1309122352 173445168 15905696
02:42:12 8845 8192000000 10218787152 10613321728 1099538592 11.833 98 60 120 0 1303229600 190197024 13493984
02:43:27 3376 8192000000 10259338896 10668761088 1125366512 12.078 100 67 134 0 1364364448 223389264 15608672
02:44:36 2317 8192000000 10306621296 10690265088 1125237712 12.076 100 84 168 0 1404093472 259248112 19607648
02:45:42 10426 8192000000 10316622240 10748776448 1137021360 12.188 100 43 85 0 1417874064 270470304 10382400
02:47:03 2720 8192000000 10371136624 10772725760 1161570576 12.418 100 76 150 1 1466618880 287123728 17924576
02:48:10 5185 8192000000 10389422608 10813005824 1171722400 12.513 100 57 114 1 1484640656 298725072 14193184
02:49:21 27441 8192000000 10333965216 10761207808 1161013152 12.413 99 39 78 0 1434240368 263905152 9322064
02:50:51 8889 8192000000 10384814496 10821070848 1162862080 12.430 100 36 72 2 1487702832 316052112 8788640
02:52:06 19146 8192000000 10288065648 10832859136 1147841440 12.289 100 16 32 0 1442723312 290551184 4330688
02:53:52 138986 8192000000 10083285920 10547372032 1112808496 11.959 97 8 16 0 1187940368 73977296 1154576
02:57:20 53796 8192000000 10110307616 10548080640 1143849312 12.252 99 45 89 1 1193813504 40544752 9419440
02:59:20 62645 8192000000 10079587248 10529374208 1119127312 12.019 97 32 63 1 1153498448 27886720 6484416
03:01:29 71833 8192000000 10076219792 10541674496 1148641728 12.297 100 40 78 1 1184876432 27715344 8519360
03:03:44 65059 8192000000 10087351280 10519814144 1140852768 12.224 99 23 46 0 1189275616 44017712 4405136
03:05:53 57811 8192000000 10159645200 10619035648 1149582592 12.306 99 36 72 1 1224597760 67361152 7654016
03:07:53 107920 8192000000 10089185776 10550677504 1129518144 12.117 97 20 41 0 1163177152 29234736 4424272
03:10:42 75844 8192000000 10106613872 10588971008 1151967968 12.328 100 16 30 0 1216727232 61694848 3064416
03:12:59 67211 8192000000 10083539200 10562998272 1101728144 11.854 96 12 24 0 1156486064 52430128 2327792
03:15:06 23076 8192000000 10040444480 10487189504 1096923264 11.808 97 30 59 0 1140062768 37219680 5919824
03:16:33 47519 8192000000 10064734480 10519924736 1061056704 11.467 95 22 44 0 1118877936 53125952 4695280
03:18:20 15228 8192000000 10054777872 10476822528 1085288016 11.698 97 46 87 2 1129116496 35154592 8673888
03:19:39 68580 8192000000 10051563952 10535813120 1082803440 11.674 98 16 32 0 1164411040 78587232 3020368
03:21:51 41435 8192000000 10065715024 10573848576 1095439264 11.794 99 23 46 0 1166569216 66066576 5063376
03:23:34 76102 8192000000 10084807744 10590515200 1108266432 11.916 100 10 19 0 1186589904 76730208 1593264
03:25:53 82470 8192000000 10046027264 10475311104 1044645584 11.309 94 24 48 0 1070877680 21185424 5046672
03:28:16 27371 8192000000 10085720576 10514882560 1097134432 11.810 100 42 84 1 1177552592 71673312 8744848
03:29:54 39463 8192000000 10042993552 10488664064 1090609488 11.748 99 20 40 0 1144608448 49955120 4043840
03:32:14 42918 8192000000 10013609152 10467876864 1064377888 11.498 97 16 32 1 1097638768 30249552 3011328
03:33:59 41039 8192000000 10021080208 10454425600 1078646544 11.635 98 17 34 0 1115068336 33348160 3073632
03:35:42 61378 8192000000 10016962048 10448027648 1072273632 11.574 97 9 18 0 1130341040 56411776 1655632
03:37:48 51811 8192000000 10056287552 10500464640 1089716928 11.740 97 25 52 0 1141690592 46643648 5330016
03:39:41 57923 8192000000 10103985776 10559537152 1140249632 12.218 100 8 16 0 1206000560 64014144 1736784
03:41:39 36796 8192000000 10079980800 10507333632 1133275744 12.152 99 37 74 0 1165056208 23523664 8256800
03:43:18 51078 8192000000 10123374784 10604658688 1139850704 12.214 99 20 40 1 1210672480 66765520 4056256
03:45:10 53102 8192000000 10072682928 10529820672 1128397360 12.106 98 16 32 0 1172599808 41000864 3201584
03:47:03 55913 8192000000 10075275744 10527666176 1112706224 11.958 96 13 26 0 1150204384 35184688 2313472
03:48:59 104732 8192000000 10116370032 10577661952 1149473280 12.305 100 24 48 0 1200479264 46371040 4634944
03:52:00 19193 8192000000 10087040768 10573164544 1139271152 12.209 99 16 32 0 1173624096 31643120 2709824
03:53:32 49682 8192000000 10072236736 10527031296 1136400944 12.182 99 14 28 0 1183275536 43989584 2885008
03:55:28 36804 8192000000 10060589072 10526650368 1149522032 12.305 100 10 20 0 1171458352 19095200 2841120
03:57:11 61017 8192000000 10065587264 10563182592 1118004880 12.008 97 6 12 0 1154271712 34677424 1589408
03:59:22 47279 8192000000 10103159120 10547511296 1103954096 11.875 96 20 40 1 1189166608 80879616 4332896
04:01:13 62802 8192000000 10065763648 10498523136 1051759936 11.378 93 29 58 0 1111199056 53247280 6191840
04:03:23 60351 8192000000 10072627888 10567143424 1099013968 11.828 99 16 33 0 1164127648 61510192 3603488
04:05:31 44697 8192000000 10100546176 10560266240 1125201008 12.076 100 25 50 0 1183935136 53619520 5114608
04:07:18 37167 8192000000 9510908768 9924112384 591268048 6.731 53 11 22 0 678726112 85447168 2010896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 22-02-2024 04:08:49 to 22-02-2024 04:09:03.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 128 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-02-2024 04:09:04 to 22-02-2024 04:09:06.

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          177820
MON$OLDEST_ACTIVE               180214
MON$OLDEST_SNAPSHOT             180214
MON$NEXT_TRANSACTION            180214
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                       1923232
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             708
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3061 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3061 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3061 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 Thu Feb 22 04:09:07 2024 
 
Database header page information: 
    Flags            0 
    Generation        94167 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    177820 
    Oldest active        180214 
    Oldest snapshot        180214 
    Next transaction    180215 
    Sequence number        0 
    Next attachment ID    708 
    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.10, total records: 7832563 
    Average version length: 48.15, total versions: 160693, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 89336 
    Data pages: 89336, average fill: 70% 
    Primary pages: 89334, secondary pages: 2, swept pages: 27011 
    Empty pages: 3, full pages: 82000 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 37 
    40 - 59% = 852 
    60 - 79% = 88305 
    80 - 99% = 117 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23434, nodes: 7832563 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1706663, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 359 
        20 - 39% = 1564 
        40 - 59% = 4412 
        60 - 79% = 2193 
        80 - 99% = 14906 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13586, nodes: 7832563 
    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: 1530463, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1396 
        40 - 59% = 2249 
        60 - 79% = 999 
        80 - 99% = 8941 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8417, nodes: 7832563 
    Average node length: 6.63, total dup: 5835455, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1523485, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 145 
        20 - 39% = 858 
        40 - 59% = 1543 
        60 - 79% = 816 
        80 - 99% = 5055 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.72, total records: 2287751 
    Average version length: 58.87, total versions: 82531, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 28696 
    Data pages: 28696, average fill: 74% 
    Primary pages: 28695, secondary pages: 1, swept pages: 6590 
    Empty pages: 6, full pages: 27067 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 0 
    40 - 59% = 19 
    60 - 79% = 28486 
    80 - 99% = 181 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4584, nodes: 2287751 
    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: 692656, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 789 
        40 - 59% = 981 
        60 - 79% = 661 
        80 - 99% = 2151 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2422, nodes: 2289733 
    Average node length: 4.97, total dup: 2288834, max dup: 21385 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1284100, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 173 
        40 - 59% = 1382 
        60 - 79% = 552 
        80 - 99% = 314 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1776, nodes: 2287751 
    Average node length: 4.97, total dup: 2287701, max dup: 130442 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1076218, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 624 
        60 - 79% = 46 
        80 - 99% = 1106 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4394, nodes: 2287751 
    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: 692656, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 118 
        20 - 39% = 538 
        40 - 59% = 690 
        60 - 79% = 693 
        80 - 99% = 2355 
 
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.36, total records: 400 
    Average version length: 24.54, total versions: 3282, max versions: 10 
    Average fragment length: 2.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 68% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 1, full pages: 18 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 19 
 
    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: 22.37, total records: 166000 
    Average version length: 68.29, total versions: 128568, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.93 
    Pointer pages: 7, data page slots: 3720 
    Data pages: 2704, average fill: 80% 
    Primary pages: 2703, secondary pages: 1, swept pages: 0 
    Empty pages: 162, full pages: 2242 
    Fill distribution: 
     0 - 19% = 197 
    20 - 39% = 86 
    40 - 59% = 100 
    60 - 79% = 451 
    80 - 99% = 1870 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1703821, depth: 3, leaf buckets: 420, nodes: 166000 
    Average node length: 13.28, total dup: 14421, max dup: 3 
    Average key length: 10.53, compression ratio: 2.57 
    Average prefix length: 19.38, average data length: 7.62 
    Clustering factor: 120283, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 126 
        60 - 79% = 236 
        80 - 99% = 46 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 282, max versions: 11 
    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: 8 
    Data pages: 8, average fill: 14% 
    Primary pages: 1, secondary pages: 7, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 7 
    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: 15.41, total records: 2764 
    Average version length: 43.54, total versions: 2275, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.76 
    Pointer pages: 1, data page slots: 48 
    Data pages: 48, average fill: 58% 
    Primary pages: 47, secondary pages: 1, swept pages: 0 
    Empty pages: 13, full pages: 28 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 26 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 97364, depth: 2, leaf buckets: 5, nodes: 2764 
    Average node length: 4.11, total dup: 2666, max dup: 324 
    Average key length: 2.40, compression ratio: 7.93 
    Average prefix length: 18.64, average data length: 0.36 
    Clustering factor: 1381, ratio: 0.50 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        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.62, total records: 73 
    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% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    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: 35.26, total records: 822149 
    Average version length: 37.90, total versions: 49778, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.53 
    Pointer pages: 6, data page slots: 8336 
    Data pages: 8336, average fill: 68% 
    Primary pages: 8333, secondary pages: 3, swept pages: 681 
    Empty pages: 5, full pages: 8243 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 8192 
    80 - 99% = 135 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 845, nodes: 796470 
    Average node length: 4.88, total dup: 796421, max dup: 149771 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89853, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 120 
        40 - 59% = 429 
        60 - 79% = 181 
        80 - 99% = 111 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 922, nodes: 796470 
    Average node length: 5.89, total dup: 709012, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159767, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 493 
        60 - 79% = 89 
        80 - 99% = 300 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 953, nodes: 796470 
    Average node length: 5.89, total dup: 709012, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161587, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 98 
        40 - 59% = 477 
        60 - 79% = 89 
        80 - 99% = 289 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1142, nodes: 796470 
    Average node length: 5.97, total dup: 709012, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154169, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 251 
        40 - 59% = 609 
        60 - 79% = 197 
        80 - 99% = 83 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.80, total records: 5508 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.95, total fragments: 37, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 83, secondary pages: 13, swept pages: 48 
    Empty pages: 14, full pages: 52 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 1 
    40 - 59% = 4 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5508 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.09 
    Average prefix length: 34.53, average data length: 1.54 
    Clustering factor: 5276, ratio: 0.96 
    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: 5508 
    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: 165, 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.05, total records: 81899 
    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: 856 
    Data pages: 856, average fill: 66% 
    Primary pages: 856, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 850 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 850 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35913, depth: 2, leaf buckets: 105, nodes: 81899 
    Average node length: 10.15, total dup: 0, max dup: 0 
    Average key length: 8.16, compression ratio: 1.10 
    Average prefix length: 3.84, average data length: 5.16 
    Clustering factor: 3167, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        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: 111.07, 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.22 
    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: 145.17, total records: 169580 
    Average version length: 152.96, total versions: 6871, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.68 
    Pointer pages: 6, data page slots: 4520 
    Data pages: 4208, average fill: 83% 
    Primary pages: 4205, secondary pages: 3, swept pages: 1 
    Empty pages: 43, full pages: 4149 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4150 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 140.62, total records: 133480 
    Average version length: 154.13, total versions: 9592, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.06 
    Pointer pages: 6, data page slots: 3856 
    Data pages: 3320, average fill: 84% 
    Primary pages: 3318, secondary pages: 2, swept pages: 2 
    Empty pages: 36, full pages: 3270 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3270 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 136.69, total records: 187269 
    Average version length: 154.56, total versions: 19298, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.41 
    Pointer pages: 7, data page slots: 6032 
    Data pages: 4656, average fill: 84% 
    Primary pages: 4654, secondary pages: 2, swept pages: 3 
    Empty pages: 35, full pages: 4606 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4606 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 145.09, total records: 159504 
    Average version length: 153.38, total versions: 6553, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 7, data page slots: 4648 
    Data pages: 4000, average fill: 83% 
    Primary pages: 3998, secondary pages: 2, swept pages: 7 
    Empty pages: 74, full pages: 3900 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 12 
    80 - 99% = 3899 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 102.41, total records: 236830 
    Average version length: 155.02, total versions: 81179, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 16.56 
    Pointer pages: 6, data page slots: 6784 
    Data pages: 5912, average fill: 87% 
    Primary pages: 5910, secondary pages: 2, swept pages: 1 
    Empty pages: 51, full pages: 5842 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 6 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 5843 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 122.76, total records: 198531 
    Average version length: 154.58, total versions: 39698, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.82 
    Pointer pages: 7, data page slots: 6072 
    Data pages: 4952, average fill: 85% 
    Primary pages: 4949, secondary pages: 3, swept pages: 4 
    Empty pages: 51, full pages: 4885 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 4885 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 149.48, total records: 163632 
    Average version length: 147.71, total versions: 1976, 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: 4888 
    Data pages: 4080, average fill: 83% 
    Primary pages: 4078, secondary pages: 2, swept pages: 3 
    Empty pages: 50, full pages: 4010 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 4011 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.71, total records: 154870 
    Average version length: 152.67, total versions: 4589, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 6, data page slots: 5880 
    Data pages: 3856, average fill: 83% 
    Primary pages: 3854, secondary pages: 2, swept pages: 1 
    Empty pages: 49, full pages: 3793 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 3794 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 147.29, total records: 161446 
    Average version length: 152.32, total versions: 4541, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.51 
    Pointer pages: 7, data page slots: 4880 
    Data pages: 4000, average fill: 84% 
    Primary pages: 3998, secondary pages: 2, swept pages: 1 
    Empty pages: 26, full pages: 3962 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3962 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 142.41, total records: 157697 
    Average version length: 153.29, total versions: 9505, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.91 
    Pointer pages: 6, data page slots: 5232 
    Data pages: 3952, average fill: 83% 
    Primary pages: 3949, secondary pages: 3, swept pages: 3 
    Empty pages: 63, full pages: 3858 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 11 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 3859 
 
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: 51.28, total records: 2158147 
    Average version length: 52.97, total versions: 72440, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25888 
    Data pages: 25888, average fill: 72% 
    Primary pages: 25877, secondary pages: 11, swept pages: 8216 
    Empty pages: 49, full pages: 24765 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 79 
    40 - 59% = 261 
    60 - 79% = 24661 
    80 - 99% = 797 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2628, nodes: 2158147 
    Average node length: 5.44, total dup: 2015591, max dup: 1454 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.59, average data length: 0.41 
    Clustering factor: 186045, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 242 
        40 - 59% = 1774 
        60 - 79% = 309 
        80 - 99% = 296 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2762, nodes: 2158147 
    Average node length: 5.69, total dup: 1938302, max dup: 69 
    Average key length: 2.73, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 385273, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 4 
        40 - 59% = 2282 
        60 - 79% = 439 
        80 - 99% = 35 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2143, nodes: 2158147 
    Average node length: 4.96, total dup: 2158047, max dup: 28796 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 183592, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 176 
        40 - 59% = 1082 
        60 - 79% = 412 
        80 - 99% = 469 
 
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: 1 
    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: 37.41, total records: 175820 
    Average version length: 69.20, total versions: 92895, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.37 
    Pointer pages: 3, data page slots: 4280 
    Data pages: 3176, average fill: 68% 
    Primary pages: 3175, secondary pages: 1, swept pages: 270 
    Empty pages: 381, full pages: 2390 
    Fill distribution: 
     0 - 19% = 477 
    20 - 39% = 16 
    40 - 59% = 76 
    60 - 79% = 1062 
    80 - 99% = 1545 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1554055, depth: 3, leaf buckets: 246, nodes: 175820 
    Average node length: 6.48, total dup: 153211, max dup: 25 
    Average key length: 3.89, compression ratio: 10.78 
    Average prefix length: 40.23, average data length: 1.77 
    Clustering factor: 29962, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 14 
        40 - 59% = 131 
        60 - 79% = 79 
        80 - 99% = 21 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.40, total records: 7333103 
    Average version length: 68.79, total versions: 557637, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 65, data page slots: 105384 
    Data pages: 105384, average fill: 75% 
    Primary pages: 105384, secondary pages: 0, swept pages: 6844 
    Empty pages: 0, full pages: 103242 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 251 
    40 - 59% = 697 
    60 - 79% = 100832 
    80 - 99% = 3566 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10768, nodes: 7333103 
    Average node length: 6.50, total dup: 6348525, max dup: 32 
    Average key length: 3.51, compression ratio: 11.96 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1738993, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1396 
        40 - 59% = 5822 
        60 - 79% = 2844 
        80 - 99% = 697 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8756, nodes: 7333103 
    Average node length: 5.39, total dup: 7048720, max dup: 196 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1526048, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1110 
        40 - 59% = 4885 
        60 - 79% = 1638 
        80 - 99% = 1113 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8809, nodes: 7333103 
    Average node length: 5.39, total dup: 7048720, max dup: 196 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1528404, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1127 
        40 - 59% = 4918 
        60 - 79% = 1656 
        80 - 99% = 1103 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.68, total records: 12305983 
    Average version length: 68.75, total versions: 461628, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 108, data page slots: 174984 
    Data pages: 174984, average fill: 75% 
    Primary pages: 174983, secondary pages: 1, swept pages: 44326 
    Empty pages: 5, full pages: 174651 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 13 
    60 - 79% = 170646 
    80 - 99% = 4318 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18450, nodes: 12299885 
    Average node length: 6.62, total dup: 10725101, max dup: 67 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.71, average data length: 1.29 
    Clustering factor: 2517913, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1987 
        40 - 59% = 10664 
        60 - 79% = 4815 
        80 - 99% = 959 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 37.04, total records: 2008366 
    Average version length: 69.10, total versions: 586076, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.40 
    Pointer pages: 28, data page slots: 43864 
    Data pages: 28496, average fill: 69% 
    Primary pages: 28432, secondary pages: 64, swept pages: 626 
    Empty pages: 18, full pages: 28402 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 4845 
    40 - 59% = 2391 
    60 - 79% = 12477 
    80 - 99% = 8705 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1875, nodes: 1522313 
    Average node length: 5.52, total dup: 1460936, max dup: 49 
    Average key length: 2.56, compression ratio: 16.43 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 107316, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 234 
        40 - 59% = 943 
        60 - 79% = 536 
        80 - 99% = 156 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 33.02, total records: 1721253 
    Average version length: 69.02, total versions: 178862, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.82 
    Pointer pages: 22, data page slots: 35496 
    Data pages: 28096, average fill: 45% 
    Primary pages: 28096, secondary pages: 0, swept pages: 4130 
    Empty pages: 4825, full pages: 18803 
    Fill distribution: 
     0 - 19% = 6350 
    20 - 39% = 3176 
    40 - 59% = 7819 
    60 - 79% = 10222 
    80 - 99% = 529 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1196, nodes: 867640 
    Average node length: 5.96, total dup: 797909, max dup: 85 
    Average key length: 3.02, compression ratio: 13.90 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 128054, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 209 
        40 - 59% = 575 
        60 - 79% = 350 
        80 - 99% = 61 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 63.73, total records: 9530780 
    Average version length: 68.98, total versions: 811278, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.98 
    Pointer pages: 89, data page slots: 145216 
    Data pages: 145176, average fill: 71% 
    Primary pages: 145149, secondary pages: 27, swept pages: 24704 
    Empty pages: 351, full pages: 102168 
    Fill distribution: 
     0 - 19% = 921 
    20 - 39% = 3155 
    40 - 59% = 13177 
    60 - 79% = 120417 
    80 - 99% = 7506 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13467, nodes: 9519437 
    Average node length: 6.69, total dup: 7895463, max dup: 14 
    Average key length: 3.67, compression ratio: 11.46 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2142928, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 901 
        40 - 59% = 6469 
        60 - 79% = 5182 
        80 - 99% = 913 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.45, total records: 21190007 
    Average version length: 82.88, total versions: 25940, 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: 320240 
    Data pages: 320240, average fill: 81% 
    Primary pages: 320236, secondary pages: 4, swept pages: 11501 
    Empty pages: 1, full pages: 320237 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 48934 
    80 - 99% = 271303 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19611, nodes: 21190007 
    Average node length: 5.72, total dup: 20708304, max dup: 139 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3290740, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 4 
        40 - 59% = 8520 
        60 - 79% = 570 
        80 - 99% = 10511 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17211, nodes: 21190007 
    Average node length: 6.31, total dup: 18621545, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 920331, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 2 
        40 - 59% = 771 
        60 - 79% = 304 
        80 - 99% = 16127 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21388, nodes: 21190007 
    Average node length: 6.35, total dup: 18541057, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3585349, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 3 
        40 - 59% = 8796 
        60 - 79% = 595 
        80 - 99% = 11986 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16159, nodes: 21190007 
    Average node length: 5.56, total dup: 21189907, max dup: 232208 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 949039, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2958 
        60 - 79% = 393 
        80 - 99% = 12799 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.58, total records: 9959438 
    Average version length: 82.61, total versions: 791778, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 106, data page slots: 172352 
    Data pages: 172320, average fill: 72% 
    Primary pages: 172284, secondary pages: 36, swept pages: 43689 
    Empty pages: 604, full pages: 122676 
    Fill distribution: 
     0 - 19% = 1724 
    20 - 39% = 5944 
    40 - 59% = 17933 
    60 - 79% = 113552 
    80 - 99% = 33167 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11363, nodes: 9959438 
    Average node length: 5.36, total dup: 9649227, max dup: 196 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2241705, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 7436 
        60 - 79% = 3763 
        80 - 99% = 124 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13605, nodes: 9959438 
    Average node length: 6.23, total dup: 8256163, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1574164, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 3539 
        40 - 59% = 4724 
        60 - 79% = 2522 
        80 - 99% = 2694 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12687, nodes: 9959438 
    Average node length: 5.98, total dup: 8652553, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2440942, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 52 
        40 - 59% = 8412 
        60 - 79% = 4061 
        80 - 99% = 161 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10282, nodes: 9959438 
    Average node length: 5.14, total dup: 9959338, max dup: 168665 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1600401, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1104 
        40 - 59% = 5144 
        60 - 79% = 1778 
        80 - 99% = 2219 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.18, total records: 11558802 
    Average version length: 82.55, total versions: 650506, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 119, data page slots: 193304 
    Data pages: 191888, average fill: 75% 
    Primary pages: 191779, secondary pages: 109, swept pages: 49456 
    Empty pages: 2014, full pages: 158586 
    Fill distribution: 
     0 - 19% = 3417 
    20 - 39% = 5140 
    40 - 59% = 12653 
    60 - 79% = 95251 
    80 - 99% = 75427 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13135, nodes: 11558802 
    Average node length: 5.30, total dup: 11449085, max dup: 674 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2419508, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 70 
        40 - 59% = 8570 
        60 - 79% = 4313 
        80 - 99% = 179 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10535, nodes: 11558802 
    Average node length: 5.50, total dup: 11054999, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 740235, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 160 
        20 - 39% = 799 
        40 - 59% = 2509 
        60 - 79% = 1745 
        80 - 99% = 5322 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15021, nodes: 11558802 
    Average node length: 6.03, total dup: 10096699, max dup: 76 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2436167, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 92 
        40 - 59% = 10081 
        60 - 79% = 4610 
        80 - 99% = 236 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 11008, nodes: 11558802 
    Average node length: 5.23, total dup: 11558702, max dup: 220375 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 728051, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 758 
        40 - 59% = 5061 
        60 - 79% = 1488 
        80 - 99% = 3613 
 
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: 77.17, total records: 10041972 
    Average version length: 82.92, total versions: 758691, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 108, data page slots: 176232 
    Data pages: 176168, average fill: 71% 
    Primary pages: 176139, secondary pages: 29, swept pages: 48320 
    Empty pages: 682, full pages: 118668 
    Fill distribution: 
     0 - 19% = 1868 
    20 - 39% = 6753 
    40 - 59% = 20978 
    60 - 79% = 114950 
    80 - 99% = 31619 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12037, nodes: 10041972 
    Average node length: 5.18, total dup: 10012768, max dup: 1675 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2042134, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1362 
        40 - 59% = 8121 
        60 - 79% = 1922 
        80 - 99% = 603 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13719, nodes: 10041972 
    Average node length: 6.25, total dup: 8324362, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1529512, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 3562 
        40 - 59% = 4636 
        60 - 79% = 2500 
        80 - 99% = 2843 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12709, nodes: 10041972 
    Average node length: 5.43, total dup: 9595365, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2179093, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 33 
        20 - 39% = 1376 
        40 - 59% = 9016 
        60 - 79% = 1692 
        80 - 99% = 592 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10436, nodes: 10041972 
    Average node length: 5.15, total dup: 10041872, max dup: 170849 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1615651, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1161 
        40 - 59% = 5210 
        60 - 79% = 1826 
        80 - 99% = 2197 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.04, total records: 586429 
    Average version length: 68.77, total versions: 11307, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8120 
    Data pages: 8120, average fill: 76% 
    Primary pages: 8120, secondary pages: 0, swept pages: 2636 
    Empty pages: 1, full pages: 7823 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 2 
    40 - 59% = 29 
    60 - 79% = 7872 
    80 - 99% = 216 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 35699, depth: 3, leaf buckets: 745, nodes: 586429 
    Average node length: 5.95, total dup: 499578, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102981, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 35 
        40 - 59% = 504 
        60 - 79% = 117 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28804, depth: 3, leaf buckets: 763, nodes: 586429 
    Average node length: 6.15, total dup: 481162, max dup: 29 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 103027, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 525 
        60 - 79% = 102 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 554, nodes: 586429 
    Average node length: 4.86, total dup: 586329, max dup: 9275 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 91488, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 308 
        60 - 79% = 68 
        80 - 99% = 156 
 
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 Thu Feb 22 04:09:31 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7832563 160693 1 0.0000 0.0000
DOC_LIST 2287751 82531 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 3282 10 800.0000 0.0000
INVNT_TURNOVER_LOG 166000 128568 1 0.0000 0.0000
MONEY_SALDO 49 282 11 500.0000 0.0000
MONEY_TURNOVER_LOG 2764 2275 1 0.0000 0.0000
PDISTR 822149 49778 3 0.0000 0.0000
PERF_SPLIT_0 169580 6871 1 0.0000 0.0000
PERF_SPLIT_1 133480 9592 1 0.0000 0.0000
PERF_SPLIT_2 187269 19298 1 0.0000 0.0000
PERF_SPLIT_3 159504 6553 1 0.0000 0.0000
PERF_SPLIT_4 236830 81179 1 0.0000 0.0000
PERF_SPLIT_5 198531 39698 1 0.0000 0.0000
PERF_SPLIT_6 163632 1976 1 0.0000 0.0000
PERF_SPLIT_7 154870 4589 1 0.0000 0.0000
PERF_SPLIT_8 161446 4541 1 0.0000 0.0000
PERF_SPLIT_9 157697 9505 1 0.0000 0.0000
PSTORNED 2158147 72440 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 175820 92895 1 0.0000 0.0000
XQD_1000_3300 7333103 557637 1 0.0000 0.0000
XQD_1200_2000 12305983 461628 1 0.0000 0.0000
XQD_2000_3300 2008366 586076 1 0.0000 0.0000
XQD_2100_3300 1721253 178862 1 0.0000 0.0000
XQD_3300_3400 9530780 811278 1 0.0000 0.0000
XQS_1000_1200 21190007 25940 1 0.0000 0.0000
XQS_1000_3300 9959438 791778 1 0.0000 0.0000
XQS_1200_2000 11558802 650506 1 0.0000 0.0000
XQS_2100_3300 10041972 758691 1 0.0000 0.0000
XQS_3300_3400 586429 11307 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 ---
:145: 
:146: mscs-test-161.budzdorov.ru    Thu Feb 22 04:08:04 2024
:147:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:148: 
--- end of diff output ---

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

22.02.24 04:09:43. 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-22 04:09:45 No severe PSQL-related problems occured
22.02.24 04:09:47. End of report.