Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.03.2024 07:15
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 15666968 kB
MemAvailable 30281476 kB
Buffers 0 kB
Cached 16080944 kB
SwapCached 2704 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-03-14 07:14:11
DTS_END                         2024-03-14 07:14:11.7470
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/38942
TRN_ID                          169712
ATT_ID                          511
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: 9269.97 21970 926997
customer order: creation 171.34 479 17134
customer order: refuse 14.69 376 1469
order to supplier: creation 45.99 1261 4599
order to supplier: removal 4.02 76204 402
invoice (draft): creation 46.56 3437 4656
invoice (draft): removal 53.03 616 5303
invoice accept: apply 41.28 18094 4128
invoice accept: cancel 46.77 634 4677
customer reserve: creation 3963.07 173 396307
customer reserve: removal 4597.74 54 459774
realization accept: apply 82.55 199 8255
realization accept: cancel 76.26 125 7626
payment from customer: creation 58.83 141 5883
payment from customer: removal 5.91 101 591
payment to supplier: creation 48.17 133 4817
payment to supplier: removal 3.27 93 327
service: total inventory turnovers 3.84 3484 384
service: total monetary turnovers 5.58 432 558
service: aggregate perf. data 1.03 15479 103
service: refresh index statistics 0.04 317883 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-03-2024 07:15:40 to 14-03-2024 07:15:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5521
TEST_TIME 2 3567
TEST_TIME 3 4354
TEST_TIME 4 4056
TEST_TIME 5 3835
TEST_TIME 6 4065
TEST_TIME 7 4686
TEST_TIME 8 4616
TEST_TIME 9 5077
TEST_TIME 10 4872
TEST_TIME 11 4999
TEST_TIME 12 4997
TEST_TIME 13 5607
TEST_TIME 14 6319
TEST_TIME 15 6407
TEST_TIME 16 7269
TEST_TIME 17 7681
TEST_TIME 18 7952
TEST_TIME 19 8128
TEST_TIME 20 8542
TEST_TIME 21 8718
TEST_TIME 22 8963
TEST_TIME 23 9607
TEST_TIME 24 9535
TEST_TIME 25 9556
TEST_TIME 26 9801
TEST_TIME 27 9576
TEST_TIME 28 9909
TEST_TIME 29 9855
TEST_TIME 30 9854
TEST_TIME 31 9574
TEST_TIME 32 9559
TEST_TIME 33 9306
TEST_TIME 34 9340
TEST_TIME 35 9243
TEST_TIME 36 9232
TEST_TIME 37 9117
TEST_TIME 38 9062
TEST_TIME 39 9175
TEST_TIME 40 9323
TEST_TIME 41 9282
TEST_TIME 42 9281
TEST_TIME 43 9265
TEST_TIME 44 9270
TEST_TIME 45 9397
TEST_TIME 46 9464
TEST_TIME 47 9476
TEST_TIME 48 9543
TEST_TIME 49 9575
TEST_TIME 50 9733
TEST_TIME 51 9765
TEST_TIME 52 9735
TEST_TIME 53 9581
TEST_TIME 54 9474
TEST_TIME 55 9416
TEST_TIME 56 9400
TEST_TIME 57 9401
TEST_TIME 58 9324
TEST_TIME 59 9247
TEST_TIME 60 9173
TEST_TIME 61 9123
TEST_TIME 62 9212
TEST_TIME 63 9293
TEST_TIME 64 9327
TEST_TIME 65 9388
TEST_TIME 66 9421
TEST_TIME 67 9488
TEST_TIME 68 9546
TEST_TIME 69 9527
TEST_TIME 70 9598
TEST_TIME 71 9570
TEST_TIME 72 9587
TEST_TIME 73 9504
TEST_TIME 74 9418
TEST_TIME 75 9421
TEST_TIME 76 9371
TEST_TIME 77 9325
TEST_TIME 78 9317
TEST_TIME 79 9361
TEST_TIME 80 9357
TEST_TIME 81 9343
TEST_TIME 82 9350
TEST_TIME 83 9355
TEST_TIME 84 9427
TEST_TIME 85 9511
TEST_TIME 86 9513
TEST_TIME 87 9525
TEST_TIME 88 9567
TEST_TIME 89 9585
TEST_TIME 90 9605
TEST_TIME 91 9553
TEST_TIME 92 9479
TEST_TIME 93 9480
TEST_TIME 94 9444
TEST_TIME 95 9377
TEST_TIME 96 9305
TEST_TIME 97 9359
TEST_TIME 98 9334
TEST_TIME 99 9323
TEST_TIME 100 9275

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-03-2024 07:15:44 to 14-03-2024 07:15:47.

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 1291362 1291362 0 0.00 0 36776 6 0 0
doc_list_biud 1291355 1291355 0 0.00 0 63281 24 0 0
sp_add_invoice_to_stock 4255 4128 127 2.98 24 213286 18095 0 127
sp_cancel_adding_invoice 4677 4677 0 0.00 5 37805 634 0 0
sp_cancel_client_order 1469 1469 0 0.00 3 16333 377 0 0
sp_cancel_customer_reserve 459774 459774 0 0.00 0 26538 54 0 0
sp_cancel_pay_from_customer 591 591 0 0.00 2 6814 101 0 0
sp_cancel_pay_to_supplier 327 327 0 0.00 3 6418 94 0 0
sp_cancel_supplier_invoice 5315 5303 12 0.22 2 63309 616 0 12
sp_cancel_supplier_order 402 402 0 0.00 6 941167 76205 0 0
sp_cancel_write_off 7626 7626 0 0.00 1 9811 125 0 0
sp_client_order 17134 17134 0 0.00 3 32631 479 0 0
sp_customer_reserve 396307 396307 0 0.00 0 51009 174 0 0
sp_fill_shopping_cart 26380 26380 0 0.00 1 12594 36 0 0
sp_fill_shopping_cart_clo_res 396300 396300 0 0.00 0 12891 15 0 0
sp_get_clo_for_invoice 4119 4119 0 0.00 0 15289 318 0 0
sp_kill_cost_storno 13221 13221 0 0.00 0 9279 65 0 0
sp_kill_qstorno_ret_qs2qd 932879 932879 0 0.00 0 63277 29 0 0
sp_kill_qty_storno 491625 491625 0 0.00 0 63280 63 0 0
sp_lock_selected_doc 17181 17181 0 0.00 0 9794 6 0 0
sp_make_cost_storno 23074 23074 0 0.00 0 36770 64 0 0
sp_multiply_rows_for_pdistr 23074 23074 0 0.00 0 15576 35 0 0
sp_multiply_rows_for_qdistr 17134 17134 0 0.00 0 15475 233 0 0
sp_pay_from_customer 5883 5883 0 0.00 4 36781 141 0 0
sp_pay_to_supplier 4817 4817 0 0.00 4 27518 133 0 0
sp_payment_common 10699 10699 0 0.00 1 14996 27 0 0
sp_qd_handle_on_cancel_clo 1469 1469 0 0.00 0 16322 348 0 0
sp_qd_handle_on_invoice_upd_sts 8796 8796 0 0.00 0 37419 270 0 0
sp_qd_handle_on_reserve_upd_sts 8255 8255 0 0.00 0 20113 60 0 0
sp_reserve_write_off 8255 8255 0 0.00 6 20146 200 0 0
sp_supplier_invoice 4656 4656 0 0.00 5 95656 3438 0 0
sp_supplier_order 4599 4599 0 0.00 5 83252 1262 0 0
srv_aggregate_perf_data 103 103 0 0.00 1719 371846 15480 0 0
srv_fill_mon_cache_memory 52 52 0 0.00 947 134433 48516 0 0
srv_find_qd_qs_mism 885689 885689 0 0.00 0 28852 5 0 0
srv_make_invnt_saldo 384 384 0 0.00 57 95930 3484 0 0
srv_make_money_saldo 558 558 0 0.00 1 11219 432 0 0
srv_recalc_idx_stat 4 4 0 0.00 177535 418865 317884 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4128 4128 0 0.00 0 8223 146 0 0
t$perf-norm:sp_cancel_adding_invoice 295 295 0 0.00 0 3897 90 0 0
t$perf-norm:sp_cancel_client_order 1469 1469 0 0.00 0 12431 29 0 0
t$perf-norm:sp_cancel_customer_reserve 584 584 0 0.00 0 561 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 591 591 0 0.00 0 453 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 327 327 0 0.00 0 244 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 363 363 0 0.00 0 6929 29 0 0
t$perf-norm:sp_cancel_supplier_order 402 402 0 0.00 0 14689 1267 0 0
t$perf-norm:sp_cancel_write_off 777 777 0 0.00 0 4293 12 0 0
t$perf-norm:sp_client_order 17134 17134 0 0.00 0 10501 17 0 0
t$perf-norm:sp_customer_reserve 785 785 0 0.00 0 180 2 0 0
t$perf-norm:sp_pay_from_customer 5883 5883 0 0.00 0 8561 14 0 0
t$perf-norm:sp_pay_to_supplier 4817 4817 0 0.00 0 7437 12 0 0
t$perf-norm:sp_reserve_write_off 8255 8255 0 0.00 0 12446 12 0 0
t$perf-norm:sp_supplier_invoice 4656 4656 0 0.00 0 5878 14 0 0
t$perf-norm:sp_supplier_order 4599 4599 0 0.00 0 6945 13 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 549 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 52 52 0 0.00 0 354 7 0 0
t$perf-norm:srv_make_invnt_saldo 384 384 0 0.00 0 967 9 0 0
t$perf-norm:srv_make_money_saldo 558 558 0 0.00 0 452 5 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 6 0 0
v_add_invoice_to_stock 8491 8237 254 2.99 0 10405 23 0 254
v_all_customers 31782 31782 0 0.00 0 26 0 0 0
v_all_suppliers 26240 26240 0 0.00 0 22 1 0 0
v_all_wares 34266 34266 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 590 590 0 0.00 0 2133 11 0 0
v_cancel_client_order 2938 2938 0 0.00 0 3809 4 0 0
v_cancel_customer_prepayment 1182 1182 0 0.00 0 827 4 0 0
v_cancel_customer_reserve 1168 1168 0 0.00 0 6429 10 0 0
v_cancel_payment_to_supplier 654 654 0 0.00 0 6400 21 0 0
v_cancel_supplier_invoice 750 726 24 3.20 0 6427 24 0 24
v_cancel_supplier_order 804 804 0 0.00 0 509 3 0 0
v_cancel_write_off 1554 1554 0 0.00 0 6417 18 0 0
v_max_id_clo_ord 4598 4598 0 0.00 0 1989 2 0 0
v_max_id_clo_res 785 785 0 0.00 0 6628 20 0 0
v_max_id_ord_sup 4649 4649 0 0.00 0 5274 6 0 0
v_max_non_paid_invoice 943 943 0 0.00 0 22 1 0 0
v_max_non_paid_realizn 2806 2806 0 0.00 0 911 2 0 0
v_min_id_clo_ord 4598 4598 0 0.00 0 10487 11 0 0
v_min_id_clo_res 785 785 0 0.00 0 9470 36 0 0
v_min_id_ord_sup 4649 4649 0 0.00 0 7533 10 0 0
v_min_non_paid_invoice 4816 4816 0 0.00 0 14991 15 0 0
v_min_non_paid_realizn 5883 5883 0 0.00 0 14986 27 0 0
v_our_firm 8638 8638 0 0.00 0 22 1 0 0
v_reserve_write_off 16508 16508 0 0.00 0 14914 10 0 0
x_lock_depdocs_on_canc_invoice 9617 9617 0 0.00 0 13138 98 0 0
x_lock_depdocs_on_canc_sup_ord 402 402 0 0.00 0 4473 275 0 0
x_make_qstorno_1000_1200 4599 4599 0 0.00 1 83245 1188 0 0
x_make_qstorno_1200_2000 4656 4656 0 0.00 3 95648 3311 0 0
x_make_qstorno_2100_3300 396307 396307 0 0.00 0 49013 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-03-2024 07:15:48 to 14-03-2024 07:15:52.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
05:14:15 2 8192000000 8799548016 8811106304 5404944 0.065 2 2 2 0 5509056 68336 35776
05:15:16 25344 8192000000 9694082608 9989001216 771931536 8.611 100 90 180 0 802400544 7870896 22598112
05:17:00 16158 8192000000 9749603584 10059325440 827321312 9.172 100 86 172 0 858563488 11408816 19833360
05:18:26 12916 8192000000 9778587056 10097889280 856430960 9.464 100 86 172 0 893768864 17703936 19633968
05:19:42 19271 8192000000 9853262528 10184679424 908384080 9.981 100 79 158 0 956149360 31358064 16407216
05:21:07 6937 8192000000 9890144160 10234613760 936267424 10.256 100 83 166 0 1007013328 53347104 17398800
05:22:18 4926 8192000000 9949350464 10301612032 972512224 10.611 100 78 154 0 1066069344 78107424 15449696
05:23:25 2878 8192000000 9969282560 10328109056 999152864 10.870 100 86 170 0 1082272112 66688720 16430528
05:24:32 1321 8192000000 9994190880 10360221696 1021129328 11.083 100 93 183 0 1110451712 71296592 18025792
05:25:35 1019 8192000000 10034567216 10405777408 1042935984 11.293 100 86 172 1 1141260768 81933056 16391728
05:26:36 40785 8192000000 9988325248 10370871296 1055609168 11.414 100 58 118 1 1113759504 45154656 12995680
05:28:19 3546 8192000000 10008730032 10407055360 1072730960 11.578 100 45 85 1 1121040272 40046032 8263280
05:29:24 6714 8192000000 9996232624 10388418560 1079701744 11.645 100 45 91 1 1112605472 23409504 9494224
05:30:34 48120 8192000000 9997985040 10398384128 1088315008 11.727 100 36 72 1 1122298128 25927920 8055200
05:32:36 5848 8192000000 10026350720 10429648896 1091994944 11.762 100 49 95 0 1134689648 32876704 9818000
05:33:43 5625 8192000000 10010613312 10414665728 1101129104 11.848 100 31 63 0 1124243536 16208240 6906192
05:34:56 23549 8192000000 10027133136 10427170816 1099886384 11.837 100 44 88 0 1134614768 25574880 9153504
05:36:22 85258 8192000000 10060573888 10470453248 1100882464 11.846 99 41 81 1 1175270624 65417360 8970800
05:39:01 25682 8192000000 10069016800 10483007488 1117595008 12.004 100 32 64 1 1193111296 69353952 6162336
05:40:33 9712 8192000000 10127046176 10528370688 1133875808 12.158 100 51 102 0 1227979744 84139104 9964832
05:41:51 39552 8192000000 10169977200 10583875584 1133660400 12.156 100 40 81 0 1267938304 125657936 8619968
05:43:34 22076 8192000000 10156797184 10578829312 1120042256 12.027 98 28 53 0 1244529952 118653536 5834160
05:45:03 27503 8192000000 10172394704 10578751488 1099232128 11.830 98 31 62 0 1262007920 155855840 6919952
05:46:36 8524 8192000000 10232241424 10630647808 1121251392 12.039 99 68 136 1 1337846064 201936080 14658592
05:47:48 2283 8192000000 10230569952 10629320704 1118159568 12.010 100 82 160 1 1330105920 194273168 17673184
05:48:53 947 8192000000 10149412144 10529357824 1060806048 11.464 97 76 138 3 1242131248 165140912 16184288
05:50:00 1939 8192000000 10211396192 10608455680 1087513088 11.719 99 70 140 0 1309337808 206749520 15075200
05:51:12 3804 8192000000 10148458432 10565636096 1102440384 11.861 100 46 86 0 1258065360 146928272 8696704
05:52:24 2939 8192000000 10162988528 10576535552 1117505952 12.003 100 70 140 1 1265615088 133965504 14143632
05:53:31 14039 8192000000 10207395824 10635878400 1122892592 12.054 100 33 66 0 1301065984 170621456 7551936
05:54:49 16459 8192000000 10197512016 10645835776 1135560528 12.174 100 45 88 0 1301672576 155480176 10631872
05:56:57 26621 8192000000 10132696752 10608005120 1110623056 11.938 100 13 25 0 1273777984 159774224 3380704
05:58:48 12842 8192000000 10083281216 10502057984 1130192592 12.123 100 44 87 1 1177412880 37842368 9377920
06:00:06 64871 8192000000 10032948320 10476969984 1104453424 11.880 99 13 24 0 1164244768 57183360 2607984
06:02:16 42163 8192000000 10056108304 10538803200 1125677184 12.081 100 16 32 0 1211013648 82275104 3061360
06:03:59 125145 8192000000 10080406576 10520723456 1132439824 12.144 100 16 34 0 1184475312 48434368 3601120
06:07:13 49742 8192000000 10099095040 10527780864 1136176784 12.180 100 35 71 0 1197070256 53520592 7372880
06:09:03 32446 8192000000 10126508112 10567819264 1147724016 12.288 100 27 53 0 1205888912 52580912 5583984
06:10:42 61095 8192000000 10151931104 10597736448 1155939696 12.365 100 17 34 0 1250403104 90630608 3832800
06:13:22 20842 8192000000 10196986592 10676826112 1147464112 12.286 99 17 34 0 1292697184 141368608 3864464
06:15:09 22885 8192000000 10080116048 10521411584 1125757264 12.081 98 32 63 0 1173260320 40745952 6757104
06:16:41 56193 8192000000 10090795984 10527838208 1150176928 12.311 100 34 67 0 1190177072 32554720 7445424
06:18:39 91054 8192000000 10123859504 10640474112 1151240160 12.321 100 9 16 0 1222849712 70106736 1502816
06:21:12 70665 8192000000 10133523168 10611163136 1143663152 12.250 99 9 18 0 1207200864 61987552 1550160
06:23:24 102321 8192000000 10078544704 10577395712 1067930864 11.532 93 11 22 0 1111458960 41864160 1663936
06:26:06 55277 8192000000 10057178624 10482556928 1055198336 11.411 93 36 71 1 1079885312 17501904 7185072
06:28:03 92978 8192000000 10083817808 10536964096 1116348944 11.992 100 44 86 0 1195912880 71484016 8079920
06:30:40 56738 8192000000 10033605504 10515120128 1100936880 11.847 98 15 30 0 1157284496 52915376 3432240
06:32:38 55154 8192000000 10037861856 10475991040 1076787216 11.617 96 16 31 0 1109517120 29677520 3052384
06:34:48 65171 8192000000 10122023168 10571776000 1060319568 11.460 95 10 20 0 1138407056 75878208 2209280
06:36:57 67296 8192000000 10041156288 10472759296 1038715520 11.252 95 25 50 1 1148170400 104196688 5258192
06:39:11 37819 8192000000 10032225616 10452865024 1076862160 11.618 98 31 62 0 1110795648 27845504 6087984
06:40:52 36501 8192000000 10073370768 10513154048 1073798880 11.588 98 27 54 0 1128131904 49424160 4908864
06:42:34 57161 8192000000 10057504384 10523922432 1062016736 11.476 97 24 48 0 1140130752 73375680 4738336
06:44:36 42113 8192000000 10035312992 10494377984 1084135168 11.687 99 31 62 0 1164240000 74194832 5910000
06:46:43 134432 8192000000 10047888848 10472710144 1106196576 11.896 99 41 82 0 1149403584 34991696 8215312
06:50:00 47591 8192000000 10045852608 10538233856 1112350416 11.955 100 6 12 0 1157755584 43865344 1539824
06:51:52 31375 8192000000 10061026384 10508615680 1126718080 12.090 100 9 18 0 1155469136 27172704 1578352
06:53:23 77574 8192000000 10062724048 10513948672 1135011088 12.169 100 20 40 0 1159632832 20365424 4256320
06:55:41 16612 8192000000 10078781008 10509344768 1130388320 12.125 99 44 87 0 1173423600 33686560 9348720
06:56:58 85917 8192000000 10111567680 10592202752 1117351360 12.002 98 23 46 0 1193984096 72100672 4532064
06:59:29 50680 8192000000 10093355104 10578690048 1140702912 12.222 100 27 54 0 1188972032 42327184 5941936
07:01:27 51784 8192000000 10147187232 10619097088 1147829392 12.289 100 23 46 0 1226432656 73871152 4732112
07:03:20 112461 8192000000 10084828240 10523475968 1113654224 11.967 97 14 29 0 1153572528 37517008 2401296
07:06:13 91616 8192000000 10113815600 10552303616 1141206816 12.227 100 34 68 0 1226809744 78482592 7120336
07:08:47 90857 8192000000 10094343024 10545442816 1108213984 11.916 97 16 32 0 1190141040 78531120 3395936
07:11:25 53218 8192000000 10077635008 10570526720 1136163824 12.179 100 14 26 0 1187607232 48669632 2773776
07:13:20 49255 8192000000 10098460768 10564980736 1108825024 11.921 98 22 44 0 1186223760 72934736 4464000

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 14-03-2024 07:15:54 to 14-03-2024 07:16:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 127 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-03-2024 07:16:09 to 14-03-2024 07:16:11.

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          167349
MON$OLDEST_ACTIVE               170680
MON$OLDEST_SNAPSHOT             170680
MON$NEXT_TRANSACTION            170680
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                       1921312
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             685
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3077 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3077 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3077 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3077 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 Mar 14 07:16:12 2024 
 
Database header page information: 
    Flags            0 
    Generation        88999 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    167349 
    Oldest active        170680 
    Oldest snapshot        170680 
    Next transaction    170681 
    Sequence number        0 
    Next attachment ID    685 
    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.45, total records: 7684962 
    Average version length: 48.17, total versions: 86306, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 55, data page slots: 88328 
    Data pages: 88328, average fill: 70% 
    Primary pages: 88328, secondary pages: 0, swept pages: 36438 
    Empty pages: 6, full pages: 67423 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 40 
    40 - 59% = 1312 
    60 - 79% = 86924 
    80 - 99% = 42 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23118, nodes: 7684962 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1651321, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 317 
        20 - 39% = 1984 
        40 - 59% = 3918 
        60 - 79% = 2591 
        80 - 99% = 14308 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13450, nodes: 7684962 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1475797, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1642 
        40 - 59% = 1952 
        60 - 79% = 1216 
        80 - 99% = 8639 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8285, nodes: 7684962 
    Average node length: 6.60, total dup: 5768464, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1468875, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 990 
        40 - 59% = 1318 
        60 - 79% = 1049 
        80 - 99% = 4789 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.43, total records: 2207947 
    Average version length: 58.84, total versions: 45060, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28464 
    Data pages: 28464, average fill: 72% 
    Primary pages: 28462, secondary pages: 2, swept pages: 9953 
    Empty pages: 10, full pages: 18730 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 69 
    40 - 59% = 983 
    60 - 79% = 27321 
    80 - 99% = 67 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4488, nodes: 2207947 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 671108, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 886 
        40 - 59% = 839 
        60 - 79% = 796 
        80 - 99% = 1967 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2388, nodes: 2209115 
    Average node length: 4.97, total dup: 2208216, max dup: 20506 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1246956, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 205 
        40 - 59% = 1386 
        60 - 79% = 562 
        80 - 99% = 233 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1767, nodes: 2207947 
    Average node length: 4.97, total dup: 2207897, max dup: 130093 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1052931, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 16 
        40 - 59% = 616 
        60 - 79% = 52 
        80 - 99% = 1082 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4280, nodes: 2207947 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 671108, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 585 
        40 - 59% = 599 
        60 - 79% = 888 
        80 - 99% = 2120 
 
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.30, total records: 400 
    Average version length: 27.37, total versions: 1897, max versions: 5 
    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: 24 
    Data pages: 24, average fill: 64% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 2, full pages: 13 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 14 
 
    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: 14.67, total records: 118859 
    Average version length: 68.29, total versions: 107490, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.00 
    Pointer pages: 6, data page slots: 4168 
    Data pages: 2336, average fill: 69% 
    Primary pages: 2335, secondary pages: 1, swept pages: 0 
    Empty pages: 271, full pages: 1526 
    Fill distribution: 
     0 - 19% = 387 
    20 - 39% = 125 
    40 - 59% = 174 
    60 - 79% = 324 
    80 - 99% = 1326 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1699685, depth: 3, leaf buckets: 405, nodes: 118859 
    Average node length: 13.18, total dup: 8054, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.29, average data length: 7.71 
    Clustering factor: 85579, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 43 
        40 - 59% = 320 
        60 - 79% = 38 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.14, total records: 49 
    Average version length: 9.00, total versions: 192, max versions: 5 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 81% 
    Primary pages: 1, 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% = 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: 12.26, total records: 1960 
    Average version length: 43.52, total versions: 1776, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.73 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 64% 
    Primary pages: 31, secondary pages: 1, swept pages: 3 
    Empty pages: 6, full pages: 21 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 19 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94188, depth: 2, leaf buckets: 2, nodes: 1960 
    Average node length: 4.18, total dup: 1862, max dup: 245 
    Average key length: 2.53, compression ratio: 7.51 
    Average prefix length: 18.52, average data length: 0.48 
    Clustering factor: 1016, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        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.65, total records: 68 
    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: 48% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 68 
    Average node length: 11.71, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.29, average data length: 7.71 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.32, total records: 828940 
    Average version length: 37.92, total versions: 29024, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 6, data page slots: 8728 
    Data pages: 8728, average fill: 65% 
    Primary pages: 8725, secondary pages: 3, swept pages: 1962 
    Empty pages: 30, full pages: 6411 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 67 
    40 - 59% = 568 
    60 - 79% = 7971 
    80 - 99% = 56 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 879, nodes: 812963 
    Average node length: 4.88, total dup: 812914, max dup: 145477 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91990, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 123 
        40 - 59% = 484 
        60 - 79% = 167 
        80 - 99% = 105 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 963, nodes: 812963 
    Average node length: 5.89, total dup: 723881, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163282, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 38 
        40 - 59% = 566 
        60 - 79% = 69 
        80 - 99% = 288 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 991, nodes: 812963 
    Average node length: 5.89, total dup: 723881, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165164, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 80 
        40 - 59% = 564 
        60 - 79% = 73 
        80 - 99% = 273 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1141, nodes: 812963 
    Average node length: 5.97, total dup: 723881, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 157794, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 211 
        40 - 59% = 625 
        60 - 79% = 220 
        80 - 99% = 81 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.92, total records: 5520 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.65, total fragments: 17, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 96 
    Data pages: 94, average fill: 58% 
    Primary pages: 81, secondary pages: 13, swept pages: 56 
    Empty pages: 13, full pages: 58 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5520 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.10 
    Average prefix length: 34.64, average data length: 1.54 
    Clustering factor: 5255, ratio: 0.95 
    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: 5520 
    Average node length: 11.14, 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.14, total records: 76748 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 800 
    Data pages: 800, average fill: 66% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 798 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 798 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34591, depth: 2, leaf buckets: 98, nodes: 76748 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2754, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 96 
 
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.15, 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.21 
    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: 126.54, total records: 177193 
    Average version length: 154.55, total versions: 30347, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.40 
    Pointer pages: 6, data page slots: 5328 
    Data pages: 4384, average fill: 86% 
    Primary pages: 4382, secondary pages: 2, swept pages: 1 
    Empty pages: 20, full pages: 4353 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 4352 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 141.30, total records: 138684 
    Average version length: 153.17, total versions: 9353, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 5, data page slots: 5704 
    Data pages: 3472, average fill: 83% 
    Primary pages: 3470, secondary pages: 2, swept pages: 3 
    Empty pages: 55, full pages: 3394 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 4 
    80 - 99% = 3394 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 146.71, total records: 168404 
    Average version length: 151.86, total versions: 5368, 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: 6000 
    Data pages: 4208, average fill: 83% 
    Primary pages: 4206, secondary pages: 2, swept pages: 2 
    Empty pages: 63, full pages: 4128 
    Fill distribution: 
     0 - 19% = 69 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4129 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.27, total records: 156648 
    Average version length: 149.34, total versions: 2273, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 7, data page slots: 4432 
    Data pages: 3880, average fill: 83% 
    Primary pages: 3879, secondary pages: 1, swept pages: 4 
    Empty pages: 22, full pages: 3848 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3848 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 145.45, total records: 173405 
    Average version length: 152.61, total versions: 7210, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.66 
    Pointer pages: 6, data page slots: 6616 
    Data pages: 4320, average fill: 83% 
    Primary pages: 4317, secondary pages: 3, swept pages: 5 
    Empty pages: 43, full pages: 4256 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 6 
    80 - 99% = 4256 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 142.70, total records: 150709 
    Average version length: 152.83, total versions: 8545, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 7, data page slots: 5376 
    Data pages: 3744, average fill: 83% 
    Primary pages: 3743, secondary pages: 1, swept pages: 3 
    Empty pages: 38, full pages: 3687 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 5 
    40 - 59% = 7 
    60 - 79% = 1 
    80 - 99% = 3688 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 148.53, total records: 164977 
    Average version length: 150.36, total versions: 3035, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.42 
    Pointer pages: 7, data page slots: 5336 
    Data pages: 4144, average fill: 82% 
    Primary pages: 4142, secondary pages: 2, swept pages: 4 
    Empty pages: 62, full pages: 4027 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 11 
    40 - 59% = 34 
    60 - 79% = 4 
    80 - 99% = 4027 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 148.08, total records: 159225 
    Average version length: 151.66, total versions: 3396, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.45 
    Pointer pages: 7, data page slots: 4504 
    Data pages: 3936, average fill: 84% 
    Primary pages: 3934, secondary pages: 2, swept pages: 1 
    Empty pages: 21, full pages: 3905 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 3906 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 148.27, total records: 173533 
    Average version length: 151.98, total versions: 3640, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 6248 
    Data pages: 4328, average fill: 83% 
    Primary pages: 4326, secondary pages: 2, swept pages: 3 
    Empty pages: 55, full pages: 4257 
    Fill distribution: 
     0 - 19% = 57 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 7 
    80 - 99% = 4256 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 145.62, total records: 150195 
    Average version length: 152.88, total versions: 5741, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 5, data page slots: 5120 
    Data pages: 3760, average fill: 83% 
    Primary pages: 3756, secondary pages: 4, swept pages: 1 
    Empty pages: 55, full pages: 3682 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 12 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3682 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.13, total records: 2073936 
    Average version length: 53.00, total versions: 29126, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25592 
    Data pages: 25576, average fill: 70% 
    Primary pages: 25562, secondary pages: 14, swept pages: 11680 
    Empty pages: 167, full pages: 21545 
    Fill distribution: 
     0 - 19% = 334 
    20 - 39% = 318 
    40 - 59% = 992 
    60 - 79% = 23676 
    80 - 99% = 256 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2555, nodes: 2073936 
    Average node length: 5.44, total dup: 1934541, max dup: 1458 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180613, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 330 
        40 - 59% = 1630 
        60 - 79% = 269 
        80 - 99% = 319 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2752, nodes: 2073936 
    Average node length: 5.70, total dup: 1860959, max dup: 69 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371688, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 2500 
        60 - 79% = 230 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2075, nodes: 2073936 
    Average node length: 4.96, total dup: 2073836, max dup: 28614 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178482, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 208 
        40 - 59% = 1021 
        60 - 79% = 383 
        80 - 99% = 459 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 43.70, total records: 147733 
    Average version length: 69.18, total versions: 62623, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.88 
    Pointer pages: 3, data page slots: 3616 
    Data pages: 3096, average fill: 58% 
    Primary pages: 3096, secondary pages: 0, swept pages: 215 
    Empty pages: 233, full pages: 1471 
    Fill distribution: 
     0 - 19% = 393 
    20 - 39% = 461 
    40 - 59% = 517 
    60 - 79% = 817 
    80 - 99% = 908 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105255, depth: 3, leaf buckets: 241, nodes: 147733 
    Average node length: 6.45, total dup: 128482, max dup: 14 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 25291, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 63 
        40 - 59% = 127 
        60 - 79% = 41 
        80 - 99% = 8 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 65.80, total records: 7346997 
    Average version length: 68.75, total versions: 386653, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 69, data page slots: 111384 
    Data pages: 111384, average fill: 71% 
    Primary pages: 111383, secondary pages: 1, swept pages: 26695 
    Empty pages: 2, full pages: 66512 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 677 
    40 - 59% = 8344 
    60 - 79% = 100972 
    80 - 99% = 1298 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10780, nodes: 7346997 
    Average node length: 6.51, total dup: 6354754, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1716357, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1323 
        40 - 59% = 5683 
        60 - 79% = 3136 
        80 - 99% = 631 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8840, nodes: 7346997 
    Average node length: 5.39, total dup: 7060187, max dup: 165 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1513215, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1065 
        40 - 59% = 5197 
        60 - 79% = 1544 
        80 - 99% = 1028 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8893, nodes: 7346997 
    Average node length: 5.39, total dup: 7060187, max dup: 165 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1515527, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1064 
        40 - 59% = 5246 
        60 - 79% = 1567 
        80 - 99% = 1008 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.62, total records: 12330303 
    Average version length: 68.71, total versions: 270641, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 110, data page slots: 178552 
    Data pages: 178552, average fill: 73% 
    Primary pages: 178550, secondary pages: 2, swept pages: 68070 
    Empty pages: 12, full pages: 157721 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 570 
    40 - 59% = 4693 
    60 - 79% = 171513 
    80 - 99% = 1713 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18465, nodes: 12327876 
    Average node length: 6.63, total dup: 10744594, max dup: 61 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2510046, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1882 
        40 - 59% = 10549 
        60 - 79% = 5059 
        80 - 99% = 946 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 47.13, total records: 1516916 
    Average version length: 69.06, total versions: 335533, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.67 
    Pointer pages: 27, data page slots: 42952 
    Data pages: 28744, average fill: 54% 
    Primary pages: 28664, secondary pages: 80, swept pages: 7930 
    Empty pages: 3344, full pages: 17945 
    Fill distribution: 
     0 - 19% = 5053 
    20 - 39% = 4238 
    40 - 59% = 2967 
    60 - 79% = 12229 
    80 - 99% = 4257 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1860, nodes: 1297316 
    Average node length: 5.53, total dup: 1244684, max dup: 49 
    Average key length: 2.57, compression ratio: 16.32 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 88520, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 574 
        40 - 59% = 891 
        60 - 79% = 349 
        80 - 99% = 38 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 37.11, total records: 1310792 
    Average version length: 69.05, total versions: 178253, 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: 19, data page slots: 29992 
    Data pages: 25904, average fill: 42% 
    Primary pages: 25903, secondary pages: 1, swept pages: 4237 
    Empty pages: 3539, full pages: 10290 
    Fill distribution: 
     0 - 19% = 5813 
    20 - 39% = 4710 
    40 - 59% = 7493 
    60 - 79% = 7490 
    80 - 99% = 398 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1213, nodes: 792080 
    Average node length: 5.95, total dup: 729713, max dup: 69 
    Average key length: 3.01, compression ratio: 13.97 
    Average prefix length: 41.07, average data length: 0.93 
    Clustering factor: 119264, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 350 
        40 - 59% = 610 
        60 - 79% = 239 
        80 - 99% = 14 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.88, total records: 8918517 
    Average version length: 68.96, total versions: 445299, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 88, data page slots: 143168 
    Data pages: 143120, average fill: 67% 
    Primary pages: 143102, secondary pages: 18, swept pages: 48697 
    Empty pages: 373, full pages: 68166 
    Fill distribution: 
     0 - 19% = 1468 
    20 - 39% = 6319 
    40 - 59% = 20581 
    60 - 79% = 112503 
    80 - 99% = 2249 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13434, nodes: 8914376 
    Average node length: 6.68, total dup: 7392162, max dup: 19 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1981816, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1587 
        40 - 59% = 7211 
        60 - 79% = 4068 
        80 - 99% = 563 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21110646 
    Average version length: 82.83, total versions: 13808, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 319208 
    Data pages: 319208, average fill: 81% 
    Primary pages: 319201, secondary pages: 7, swept pages: 12468 
    Empty pages: 45, full pages: 318351 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 42 
    40 - 59% = 119 
    60 - 79% = 48005 
    80 - 99% = 270965 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19576, nodes: 21110646 
    Average node length: 5.72, total dup: 20630548, max dup: 147 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277994, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 0 
        40 - 59% = 8590 
        60 - 79% = 543 
        80 - 99% = 10435 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17112, nodes: 21110646 
    Average node length: 6.31, total dup: 18552030, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915609, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 724 
        60 - 79% = 277 
        80 - 99% = 16107 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21347, nodes: 21110646 
    Average node length: 6.35, total dup: 18471614, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571260, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8853 
        60 - 79% = 590 
        80 - 99% = 11896 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16050, nodes: 21110646 
    Average node length: 5.56, total dup: 21110546, max dup: 232041 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944377, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 13 
        40 - 59% = 2869 
        60 - 79% = 330 
        80 - 99% = 12838 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 79.71, total records: 9266547 
    Average version length: 82.62, total versions: 339809, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 104, data page slots: 169488 
    Data pages: 169424, average fill: 68% 
    Primary pages: 169390, secondary pages: 34, swept pages: 79649 
    Empty pages: 604, full pages: 90020 
    Fill distribution: 
     0 - 19% = 2207 
    20 - 39% = 9914 
    40 - 59% = 27454 
    60 - 79% = 112121 
    80 - 99% = 17728 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11310, nodes: 9266547 
    Average node length: 5.36, total dup: 8963110, max dup: 193 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2062118, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 110 
        40 - 59% = 9331 
        60 - 79% = 1842 
        80 - 99% = 23 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 12987, nodes: 9266547 
    Average node length: 6.22, total dup: 7681087, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1422400, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 121 
        20 - 39% = 3798 
        40 - 59% = 4282 
        60 - 79% = 2476 
        80 - 99% = 2310 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12613, nodes: 9266547 
    Average node length: 5.98, total dup: 8031988, max dup: 44 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2245583, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 128 
        40 - 59% = 10338 
        60 - 79% = 2112 
        80 - 99% = 33 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9814, nodes: 9266547 
    Average node length: 5.12, total dup: 9266447, max dup: 155846 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1450630, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 52 
        20 - 39% = 1411 
        40 - 59% = 4692 
        60 - 79% = 1718 
        80 - 99% = 1941 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 80.31, total records: 10906987 
    Average version length: 82.61, total versions: 293626, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 118, data page slots: 192520 
    Data pages: 190792, average fill: 70% 
    Primary pages: 190647, secondary pages: 145, swept pages: 74143 
    Empty pages: 3804, full pages: 137451 
    Fill distribution: 
     0 - 19% = 6603 
    20 - 39% = 9317 
    40 - 59% = 19377 
    60 - 79% = 96506 
    80 - 99% = 58989 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13114, nodes: 10906987 
    Average node length: 5.29, total dup: 10798373, max dup: 639 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2282675, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 205 
        40 - 59% = 10190 
        60 - 79% = 2660 
        80 - 99% = 58 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10182, nodes: 10906987 
    Average node length: 5.49, total dup: 10429066, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 698074, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 181 
        20 - 39% = 920 
        40 - 59% = 2444 
        60 - 79% = 1871 
        80 - 99% = 4766 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14993, nodes: 10906987 
    Average node length: 6.02, total dup: 9508861, max dup: 67 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2298906, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 266 
        40 - 59% = 11758 
        60 - 79% = 2883 
        80 - 99% = 85 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10430, nodes: 10906987 
    Average node length: 5.21, total dup: 10906887, max dup: 193642 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 687224, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 896 
        40 - 59% = 4480 
        60 - 79% = 1558 
        80 - 99% = 3395 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 80.11, total records: 9371209 
    Average version length: 82.91, total versions: 333458, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 107, data page slots: 174192 
    Data pages: 174088, average fill: 67% 
    Primary pages: 174059, secondary pages: 29, swept pages: 83985 
    Empty pages: 889, full pages: 90204 
    Fill distribution: 
     0 - 19% = 2827 
    20 - 39% = 11977 
    40 - 59% = 29553 
    60 - 79% = 112546 
    80 - 99% = 17185 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11380, nodes: 9371209 
    Average node length: 5.17, total dup: 9343015, max dup: 2122 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1864935, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1558 
        40 - 59% = 7484 
        60 - 79% = 1714 
        80 - 99% = 589 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13146, nodes: 9371209 
    Average node length: 6.24, total dup: 7767526, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1391506, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 167 
        20 - 39% = 3836 
        40 - 59% = 4228 
        60 - 79% = 2514 
        80 - 99% = 2401 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12003, nodes: 9371209 
    Average node length: 5.43, total dup: 8948736, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 1996546, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1551 
        40 - 59% = 8225 
        60 - 79% = 1649 
        80 - 99% = 547 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10011, nodes: 9371209 
    Average node length: 5.14, total dup: 9371109, max dup: 158034 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1470776, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1512 
        40 - 59% = 4883 
        60 - 79% = 1637 
        80 - 99% = 1947 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.74, total records: 572775 
    Average version length: 68.80, total versions: 4101, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8000 
    Data pages: 8000, average fill: 75% 
    Primary pages: 8000, secondary pages: 0, swept pages: 3499 
    Empty pages: 1, full pages: 7073 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 3 
    40 - 59% = 84 
    60 - 79% = 7854 
    80 - 99% = 58 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 32647, depth: 3, leaf buckets: 726, nodes: 572775 
    Average node length: 5.95, total dup: 487612, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100811, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 503 
        60 - 79% = 95 
        80 - 99% = 99 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 25406, depth: 3, leaf buckets: 753, nodes: 572775 
    Average node length: 6.15, total dup: 469763, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100863, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 524 
        60 - 79% = 96 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 566, nodes: 572775 
    Average node length: 4.86, total dup: 572675, max dup: 9654 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89667, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 32 
        40 - 59% = 329 
        60 - 79% = 81 
        80 - 99% = 123 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Mar 14 07:16:35 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7684962 86306 1 0.0000 0.0000
DOC_LIST 2207947 45060 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1897 5 400.0000 0.0000
INVNT_TURNOVER_LOG 118859 107490 1 0.0000 0.0000
MONEY_SALDO 49 192 5 300.0000 0.0000
MONEY_TURNOVER_LOG 1960 1776 1 0.0000 0.0000
PDISTR 828940 29024 2 0.0000 0.0000
PERF_SPLIT_0 177193 30347 1 0.0000 0.0000
PERF_SPLIT_1 138684 9353 1 0.0000 0.0000
PERF_SPLIT_2 168404 5368 1 0.0000 0.0000
PERF_SPLIT_3 156648 2273 1 0.0000 0.0000
PERF_SPLIT_4 173405 7210 1 0.0000 0.0000
PERF_SPLIT_5 150709 8545 1 0.0000 0.0000
PERF_SPLIT_6 164977 3035 1 0.0000 0.0000
PERF_SPLIT_7 159225 3396 1 0.0000 0.0000
PERF_SPLIT_8 173533 3640 1 0.0000 0.0000
PERF_SPLIT_9 150195 5741 1 0.0000 0.0000
PSTORNED 2073936 29126 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 147733 62623 1 0.0000 0.0000
XQD_1000_3300 7346997 386653 1 0.0000 0.0000
XQD_1200_2000 12330303 270641 1 0.0000 0.0000
XQD_2000_3300 1516916 335533 1 0.0000 0.0000
XQD_2100_3300 1310792 178253 1 0.0000 0.0000
XQD_3300_3400 8918517 445299 1 0.0000 0.0000
XQS_1000_1200 21110646 13808 1 0.0000 0.0000
XQS_1000_3300 9266547 339809 1 0.0000 0.0000
XQS_1200_2000 10906987 293626 1 0.0000 0.0000
XQS_2100_3300 9371209 333458 1 0.0000 0.0000
XQS_3300_3400 572775 4101 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Thu Mar 14 07:14:21 2024
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Thu Mar 14 07:14:22 2024
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Thu Mar 14 07:14:23 2024
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:17: 
--- end of diff output ---

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

14.03.24 07:16:47. 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-03-14 07:16:49 No severe PSQL-related problems occured
14.03.24 07:16:51. End of report.