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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15447272 kB
MemAvailable 30204304 kB
Buffers 0 kB
Cached 16303656 kB
SwapCached 2512 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-04-03 13:07:51
DTS_END                         2024-04-03 13:07:51.5480
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/37844
TRN_ID                          170489
ATT_ID                          559
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: 9593.63 19759 959363
customer order: creation 176.25 435 17625
customer order: refuse 15.06 415 1506
order to supplier: creation 46.23 1365 4623
order to supplier: removal 3.79 94817 379
invoice (draft): creation 46.66 3158 4666
invoice (draft): removal 55.75 708 5575
invoice accept: apply 41.56 21186 4156
invoice accept: cancel 50.58 795 5058
customer reserve: creation 3920.53 207 392053
customer reserve: removal 4935.36 58 493536
realization accept: apply 84.75 205 8475
realization accept: cancel 88.75 123 8875
payment from customer: creation 59.49 137 5949
payment from customer: removal 5.55 110 555
payment to supplier: creation 48.74 182 4874
payment to supplier: removal 3.84 105 384
service: total inventory turnovers 3.80 4549 380
service: total monetary turnovers 6.01 634 601
service: aggregate perf. data 0.90 15144 90
service: refresh index statistics 0.03 250840 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 03-04-2024 13:10:31 to 03-04-2024 13:10:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5045
TEST_TIME 2 3632
TEST_TIME 3 3862
TEST_TIME 4 4714
TEST_TIME 5 4711
TEST_TIME 6 4648
TEST_TIME 7 5153
TEST_TIME 8 5553
TEST_TIME 9 5814
TEST_TIME 10 5843
TEST_TIME 11 5919
TEST_TIME 12 5971
TEST_TIME 13 6215
TEST_TIME 14 6695
TEST_TIME 15 7010
TEST_TIME 16 7360
TEST_TIME 17 7453
TEST_TIME 18 7803
TEST_TIME 19 8056
TEST_TIME 20 8097
TEST_TIME 21 8458
TEST_TIME 22 8744
TEST_TIME 23 9278
TEST_TIME 24 9568
TEST_TIME 25 9637
TEST_TIME 26 10200
TEST_TIME 27 10333
TEST_TIME 28 10156
TEST_TIME 29 10208
TEST_TIME 30 10167
TEST_TIME 31 9942
TEST_TIME 32 9742
TEST_TIME 33 9691
TEST_TIME 34 9622
TEST_TIME 35 9614
TEST_TIME 36 9610
TEST_TIME 37 9618
TEST_TIME 38 9519
TEST_TIME 39 9526
TEST_TIME 40 9407
TEST_TIME 41 9293
TEST_TIME 42 9255
TEST_TIME 43 9352
TEST_TIME 44 9325
TEST_TIME 45 9702
TEST_TIME 46 9675
TEST_TIME 47 9750
TEST_TIME 48 9738
TEST_TIME 49 9647
TEST_TIME 50 9799
TEST_TIME 51 9860
TEST_TIME 52 9988
TEST_TIME 53 10019
TEST_TIME 54 9959
TEST_TIME 55 9958
TEST_TIME 56 10106
TEST_TIME 57 9943
TEST_TIME 58 9819
TEST_TIME 59 9742
TEST_TIME 60 9738
TEST_TIME 61 9735
TEST_TIME 62 9669
TEST_TIME 63 9619
TEST_TIME 64 9534
TEST_TIME 65 9499
TEST_TIME 66 9506
TEST_TIME 67 9462
TEST_TIME 68 9545
TEST_TIME 69 9557
TEST_TIME 70 9530
TEST_TIME 71 9663
TEST_TIME 72 9641
TEST_TIME 73 9665
TEST_TIME 74 9699
TEST_TIME 75 9709
TEST_TIME 76 9752
TEST_TIME 77 9778
TEST_TIME 78 9792
TEST_TIME 79 9797
TEST_TIME 80 9857
TEST_TIME 81 9812
TEST_TIME 82 9706
TEST_TIME 83 9643
TEST_TIME 84 9662
TEST_TIME 85 9608
TEST_TIME 86 9537
TEST_TIME 87 9475
TEST_TIME 88 9412
TEST_TIME 89 9524
TEST_TIME 90 9517
TEST_TIME 91 9518
TEST_TIME 92 9509
TEST_TIME 93 9512
TEST_TIME 94 9535
TEST_TIME 95 9527
TEST_TIME 96 9578
TEST_TIME 97 9571
TEST_TIME 98 9590
TEST_TIME 99 9611
TEST_TIME 100 9611

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1318348 1318348 0 0.00 0 27158 8 0 0
doc_list_biud 1318345 1318345 0 0.00 0 31396 27 0 0
sp_add_invoice_to_stock 4272 4156 116 2.71 42 201577 21186 0 116
sp_cancel_adding_invoice 5058 5058 0 0.00 4 95688 795 0 0
sp_cancel_client_order 1506 1506 0 0.00 4 16575 415 0 0
sp_cancel_customer_reserve 493536 493536 0 0.00 0 31398 59 0 0
sp_cancel_pay_from_customer 555 555 0 0.00 2 8127 110 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 3 4458 105 0 0
sp_cancel_supplier_invoice 5589 5575 14 0.25 1 28251 709 0 14
sp_cancel_supplier_order 379 379 0 0.00 7 981889 94818 0 0
sp_cancel_write_off 8875 8875 0 0.00 1 10077 123 0 0
sp_client_order 17625 17625 0 0.00 3 27603 435 0 0
sp_customer_reserve 392053 392053 0 0.00 0 60543 208 0 0
sp_fill_shopping_cart 26897 26897 0 0.00 1 11775 34 0 0
sp_fill_shopping_cart_clo_res 392032 392032 0 0.00 0 28551 17 0 0
sp_get_clo_for_invoice 4133 4133 0 0.00 0 28545 333 0 0
sp_kill_cost_storno 14872 14872 0 0.00 0 27142 72 0 0
sp_kill_qstorno_ret_qs2qd 1001901 1001901 0 0.00 0 31386 31 0 0
sp_kill_qty_storno 527537 527537 0 0.00 0 31395 67 0 0
sp_lock_selected_doc 17457 17457 0 0.00 0 7844 6 0 0
sp_make_cost_storno 23431 23431 0 0.00 0 16404 71 0 0
sp_multiply_rows_for_pdistr 23431 23431 0 0.00 0 12029 38 0 0
sp_multiply_rows_for_qdistr 17625 17625 0 0.00 0 25904 231 0 0
sp_pay_from_customer 5949 5949 0 0.00 3 16372 138 0 0
sp_pay_to_supplier 4874 4874 0 0.00 4 15462 182 0 0
sp_payment_common 10823 10823 0 0.00 1 15018 37 0 0
sp_qd_handle_on_cancel_clo 1506 1506 0 0.00 0 16570 399 0 0
sp_qd_handle_on_invoice_upd_sts 9191 9191 0 0.00 0 18412 291 0 0
sp_qd_handle_on_reserve_upd_sts 8475 8475 0 0.00 0 15864 59 0 0
sp_reserve_write_off 8475 8475 0 0.00 6 18671 205 0 0
sp_supplier_invoice 4666 4666 0 0.00 6 93344 3158 0 0
sp_supplier_order 4623 4623 0 0.00 5 30122 1366 0 0
srv_aggregate_perf_data 90 90 0 0.00 1822 113505 15144 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 1272 110776 40079 0 0
srv_find_qd_qs_mism 917077 917077 0 0.00 0 19786 6 0 0
srv_make_invnt_saldo 380 380 0 0.00 77 94790 4549 0 0
srv_make_money_saldo 601 601 0 0.00 1 25786 634 0 0
srv_recalc_idx_stat 3 3 0 0.00 165347 406678 250840 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4156 4156 0 0.00 0 12942 218 0 0
t$perf-norm:sp_cancel_adding_invoice 361 361 0 0.00 0 4629 99 0 0
t$perf-norm:sp_cancel_client_order 1506 1506 0 0.00 0 4569 16 0 0
t$perf-norm:sp_cancel_customer_reserve 567 567 0 0.00 0 1722 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 555 555 0 0.00 0 731 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 1005 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 295 295 0 0.00 0 1349 16 0 0
t$perf-norm:sp_cancel_supplier_order 379 379 0 0.00 0 33012 1606 0 0
t$perf-norm:sp_cancel_write_off 802 802 0 0.00 0 575 4 0 0
t$perf-norm:sp_client_order 17625 17625 0 0.00 0 7708 19 0 0
t$perf-norm:sp_customer_reserve 799 799 0 0.00 0 471 4 0 0
t$perf-norm:sp_pay_from_customer 5949 5949 0 0.00 0 5179 7 0 0
t$perf-norm:sp_pay_to_supplier 4874 4874 0 0.00 0 11375 18 0 0
t$perf-norm:sp_reserve_write_off 8475 8475 0 0.00 0 5181 11 0 0
t$perf-norm:sp_supplier_invoice 4666 4666 0 0.00 0 3842 15 0 0
t$perf-norm:sp_supplier_order 4623 4623 0 0.00 0 7100 17 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 1118 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 12 1 0 0
t$perf-norm:srv_make_invnt_saldo 380 380 0 0.00 0 2126 19 0 0
t$perf-norm:srv_make_money_saldo 601 601 0 0.00 0 3793 14 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 13 7 0 0
v_add_invoice_to_stock 8498 8266 232 2.73 0 5845 21 0 232
v_all_customers 32584 32584 0 0.00 0 52 1 0 0
v_all_suppliers 26262 26262 0 0.00 0 21 1 0 0
v_all_wares 35250 35250 0 0.00 0 111 1 0 0
v_cancel_adding_invoice 722 722 0 0.00 0 1576 11 0 0
v_cancel_client_order 3012 3012 0 0.00 0 451 3 0 0
v_cancel_customer_prepayment 1110 1110 0 0.00 0 3325 14 0 0
v_cancel_customer_reserve 1134 1134 0 0.00 0 5360 14 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 3779 12 0 0
v_cancel_supplier_invoice 618 590 28 4.53 0 1269 16 0 28
v_cancel_supplier_order 758 758 0 0.00 0 232 3 0 0
v_cancel_write_off 1604 1604 0 0.00 0 4313 23 0 0
v_max_id_clo_ord 4617 4617 0 0.00 0 539 1 0 0
v_max_id_clo_res 799 799 0 0.00 0 3333 16 0 0
v_max_id_ord_sup 4654 4654 0 0.00 0 6296 4 0 0
v_max_non_paid_invoice 1014 1014 0 0.00 0 2995 6 0 0
v_max_non_paid_realizn 2914 2914 0 0.00 0 9414 6 0 0
v_min_id_clo_ord 4617 4617 0 0.00 0 6726 7 0 0
v_min_id_clo_res 799 799 0 0.00 0 1738 5 0 0
v_min_id_ord_sup 4654 4654 0 0.00 0 5542 6 0 0
v_min_non_paid_invoice 4874 4874 0 0.00 0 11108 28 0 0
v_min_non_paid_realizn 5949 5949 0 0.00 0 11683 29 0 0
v_our_firm 8736 8736 0 0.00 0 19 1 0 0
v_reserve_write_off 16950 16950 0 0.00 0 4914 8 0 0
x_lock_depdocs_on_canc_invoice 10338 10338 0 0.00 0 31133 120 0 0
x_lock_depdocs_on_canc_sup_ord 379 379 0 0.00 0 2989 323 0 0
x_make_qstorno_1000_1200 4623 4623 0 0.00 1 30114 1289 0 0
x_make_qstorno_1200_2000 4666 4666 0 0.00 3 93152 3037 0 0
x_make_qstorno_2100_3300 392053 392053 0 0.00 0 60542 188 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 03-04-2024 13:10:39 to 03-04-2024 13:10:44.

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
11:07:55 1148 8192000000 8943217488 9002852352 10157632 0.123 3 1 2 0 10291920 98512 35776
11:08:57 30370 8192000000 9712739216 10014945280 791307440 8.808 100 87 174 0 819487040 7430384 20749216
11:10:33 19727 8192000000 9752966256 10060021760 824524592 9.144 100 91 182 0 858348000 12697664 21125744
11:11:56 19583 8192000000 9768867232 10086281216 841240064 9.312 100 88 174 0 882281328 21281792 19759472
11:13:29 9316 8192000000 9837554048 10168307712 898173376 9.880 100 79 158 0 949542592 34022128 17347088
11:14:41 9630 8192000000 9891382000 10237173760 934486288 10.239 100 78 154 0 1010157216 60386704 15284224
11:15:52 6213 8192000000 9939234720 10294591488 974472496 10.630 100 71 143 1 1053897056 65559232 13865328
11:16:59 2193 8192000000 9968461120 10332209152 1006247488 10.939 100 80 158 0 1087617792 65732112 15638192
11:18:03 1850 8192000000 10016968496 10381733888 1024160960 11.112 100 94 188 0 1126532272 84167936 18203376
11:19:07 3839 8192000000 9997776304 10374701056 1040270400 11.267 100 80 160 0 1118068688 62332992 15465296
11:20:14 1465 8192000000 10042884624 10419683328 1060162928 11.458 100 85 168 3 1152199696 75646144 16390624
11:21:16 9163 8192000000 9993752960 10388586496 1062884544 11.484 100 59 119 0 1117957920 43139808 11933568
11:22:26 5172 8192000000 9999716752 10390827008 1066921152 11.523 100 39 75 0 1107070304 32690384 7458768
11:23:34 5026 8192000000 9982159216 10379534336 1071199344 11.564 100 41 77 0 1095476128 16173888 8102896
11:24:40 3869 8192000000 9993508352 10395598848 1077987936 11.628 100 36 71 0 1114363696 28964032 7411728
11:25:50 66307 8192000000 10001733056 10418356224 1072351440 11.575 99 28 56 0 1095677760 17845568 5480752
11:28:00 27130 8192000000 10009427056 10418221056 1093153040 11.773 100 38 76 0 1143167248 42147184 7867024
11:29:37 54818 8192000000 10066294864 10468524032 1073473920 11.585 97 57 114 1 1148686176 63278256 11934000
11:31:48 6809 8192000000 10068770688 10475343872 1096501184 11.804 100 37 73 0 1182336560 78076784 7758592
11:33:02 42635 8192000000 10086469904 10492391424 1094469424 11.785 98 41 79 1 1177929472 74948096 8511952
11:34:48 9385 8192000000 10112106096 10541670400 1099544384 11.833 98 47 90 0 1210584112 101166384 9873344
11:35:59 12484 8192000000 10147724896 10551873536 1112188176 11.953 99 51 102 0 1243851728 121154928 10508624
11:37:20 11911 8192000000 10118925120 10527744000 1082846272 11.675 97 42 85 0 1208580640 117034272 8700096
11:38:35 7056 8192000000 10167313792 10575306752 1102770960 11.864 99 60 113 2 1269076256 154138512 12166784
11:39:45 3370 8192000000 10226178784 10611867648 1116867424 11.997 100 88 175 0 1325004208 189899008 18237776
11:40:51 5453 8192000000 10236885024 10630148096 1104044000 11.876 100 75 148 0 1339334192 219782880 15507312
11:42:01 9088 8192000000 10209013712 10612195328 1075233296 11.602 99 62 122 0 1304058416 215364096 13461024
11:43:16 6448 8192000000 10223253024 10650214400 1110212288 11.934 100 64 125 1 1336912560 213382720 13317552
11:44:27 1271 8192000000 10283230800 10670055424 1128785040 12.110 100 88 173 2 1377477040 230209344 18482656
11:45:36 2533 8192000000 10340429328 10739515392 1136548528 12.183 100 77 153 0 1439501216 285995056 16957632
11:46:43 2472 8192000000 10314992256 10715348992 1139033664 12.206 100 84 165 0 1415432304 257805440 18593200
11:47:50 1382 8192000000 10328359776 10736545792 1139537712 12.211 100 56 109 2 1432055568 279664720 12853136
11:48:55 4227 8192000000 10327699168 10765287424 1136831472 12.186 99 53 106 1 1412437584 263740528 11865584
11:50:02 8156 8192000000 10274936896 10714894336 1138386608 12.200 100 38 76 0 1373832112 226700512 8744992
11:51:13 20510 8192000000 10211692752 10703069184 1132760416 12.147 100 18 36 0 1330917776 193782448 4374912
11:52:40 48838 8192000000 10126128576 10662080512 1114298224 11.973 100 15 30 0 1233377872 115883360 3196288
11:54:31 45035 8192000000 10063242160 10497286144 1133971648 12.159 100 15 30 1 1186212992 49341632 2899712
11:56:18 90317 8192000000 10057219072 10526646272 1125032720 12.075 99 8 16 1 1176632688 50087824 1512144
11:58:50 62580 8192000000 10113745104 10554130432 1129994928 12.121 100 44 85 3 1235019776 95243280 9781568
12:01:02 61592 8192000000 10064761632 10492940288 1115612272 11.986 98 48 94 1 1154072464 28586144 9874048
12:03:09 23442 8192000000 10087614144 10532040704 1143797792 12.251 100 44 86 0 1203218368 49793504 9627072
12:04:35 17460 8192000000 10121178416 10575159296 1150574656 12.315 100 33 67 0 1223977552 66910272 6492624
12:05:56 30762 8192000000 10168407792 10607771648 1151796576 12.326 99 30 59 0 1249717504 91003120 6917808
12:07:31 110776 8192000000 10250231136 10708373504 1168542000 12.483 100 27 54 1 1328203792 153756640 5905152
12:11:00 13909 8192000000 10184422384 10665775104 1162179120 12.424 100 41 82 1 1324466400 153277232 9010048
12:12:14 53820 8192000000 10092160704 10568802304 1139545264 12.211 99 15 30 0 1177512208 35396320 2570624
12:14:09 60933 8192000000 10089257408 10556137472 1149292000 12.303 100 10 20 0 1206227600 55308464 1627136
12:16:13 8985 8192000000 10081565040 10506932224 1113965296 11.970 97 59 116 0 1167875984 42379168 11531520
12:17:24 79250 8192000000 10097973088 10624950272 1081990608 11.666 95 12 24 0 1164564080 80112624 2460848
12:19:45 80418 8192000000 10053713472 10571264000 1067794816 11.531 95 8 14 0 1129712096 60666144 1251136
12:22:13 41863 8192000000 10101200064 10554642432 1083628528 11.682 98 18 37 0 1155361520 68231632 3501360
12:24:05 92704 8192000000 10034415424 10453958656 1103856240 11.874 100 23 46 1 1139004416 30491872 4656304
12:26:45 29802 8192000000 10067395280 10498256896 1096854960 11.808 100 35 71 0 1166142800 62016352 7271488
12:28:24 36105 8192000000 10001088016 10441633792 1070313760 11.555 97 27 50 1 1105094864 29592128 5188976
12:30:04 42407 8192000000 10066823104 10511060992 1101663760 11.853 99 19 39 0 1144169728 37939648 4566320
12:31:47 62676 8192000000 10108653536 10571030528 1102203664 11.859 99 20 40 1 1224267248 117274768 4788816
12:35:17 48860 8192000000 10041415984 10490273792 1081117984 11.658 98 17 34 0 1133039968 48001040 3920944
12:37:07 50383 8192000000 10084456848 10519658496 1082578448 11.672 97 21 42 1 1154682928 67836336 4268144
12:39:05 51518 8192000000 10055411984 10480103424 1106205792 11.896 99 17 34 0 1128262688 19222928 2833968
12:40:59 28786 8192000000 10082864576 10524938240 1123202736 12.057 100 32 64 0 1189656432 60323520 6130176
12:42:28 38235 8192000000 10069311840 10501967872 1084006672 11.686 97 31 62 0 1130347184 40650288 5690224
12:44:08 64953 8192000000 10063221584 10528858112 1110325408 11.935 99 15 30 0 1150701136 37660768 2714960
12:46:17 62507 8192000000 10104292048 10559545344 1113073744 11.962 98 33 66 0 1179540240 59801728 6664768
12:48:23 81295 8192000000 10070634240 10496937984 1128379040 12.106 100 45 91 1 1167265824 30115696 8771088
12:50:58 21298 8192000000 10085635312 10522038272 1116749392 11.996 99 24 47 0 1183870000 62497328 4623280
12:52:22 22098 8192000000 10085619504 10554347520 1133698832 12.156 100 8 16 0 1184211760 48719520 1793408
12:55:00 88665 8192000000 10163055456 10647961600 1140858320 12.224 99 14 28 0 1287062464 142972896 3231248
12:58:04 96199 8192000000 10111481856 10562187264 1115093776 11.981 97 11 22 0 1159608400 42254640 2259984
13:00:42 53080 8192000000 10084988352 10531430400 1101963120 11.856 97 21 42 0 1176411920 70139600 4309200
13:02:51 61816 8192000000 10083647248 10574688256 1120845040 12.035 99 21 42 0 1188020608 62928224 4247344
13:04:57 103702 8192000000 10068849216 10567532544 1087914784 11.723 96 19 36 0 1153128864 61588160 3625920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 03-04-2024 13:10:46 to 03-04-2024 13:10:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 116 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

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

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          168929
MON$OLDEST_ACTIVE               170599
MON$OLDEST_SNAPSHOT             170599
MON$NEXT_TRANSACTION            170599
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                       1934368
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             687
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3083 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3083 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3083 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3083 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 Wed Apr  3 13:11:04 2024 
 
Database header page information: 
    Flags            0 
    Generation        89282 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    168929 
    Oldest active        170599 
    Oldest snapshot        170599 
    Next transaction    170600 
    Sequence number        0 
    Next attachment ID    687 
    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.71, total records: 7574943 
    Average version length: 48.15, total versions: 34292, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 88384 
    Data pages: 88384, average fill: 68% 
    Primary pages: 88383, secondary pages: 1, swept pages: 54604 
    Empty pages: 9, full pages: 51853 
    Fill distribution: 
     0 - 19% = 72 
    20 - 39% = 370 
    40 - 59% = 4020 
    60 - 79% = 83913 
    80 - 99% = 9 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23041, nodes: 7574943 
    Average node length: 18.81, total dup: 0, max dup: 0 
    Average key length: 15.82, compression ratio: 1.71 
    Average prefix length: 14.18, average data length: 12.82 
    Clustering factor: 1634061, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 280 
        20 - 39% = 2327 
        40 - 59% = 3793 
        60 - 79% = 2835 
        80 - 99% = 13806 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13398, nodes: 7574943 
    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: 1457066, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1893 
        40 - 59% = 1721 
        60 - 79% = 1372 
        80 - 99% = 8410 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8240, nodes: 7574943 
    Average node length: 6.57, total dup: 5719658, max dup: 49 
    Average key length: 3.59, compression ratio: 2.51 
    Average prefix length: 7.66, average data length: 1.34 
    Clustering factor: 1450288, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 1184 
        40 - 59% = 1208 
        60 - 79% = 1142 
        80 - 99% = 4605 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 57.01, total records: 2145110 
    Average version length: 58.90, total versions: 16287, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28560 
    Data pages: 28560, average fill: 69% 
    Primary pages: 28558, secondary pages: 2, swept pages: 19209 
    Empty pages: 5, full pages: 11628 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 108 
    40 - 59% = 2870 
    60 - 79% = 25534 
    80 - 99% = 30 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4486, nodes: 2145110 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 654637, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1047 
        40 - 59% = 749 
        60 - 79% = 871 
        80 - 99% = 1817 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2388, nodes: 2145642 
    Average node length: 4.97, total dup: 2144745, max dup: 17815 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1239213, ratio: 0.58 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 249 
        40 - 59% = 1449 
        60 - 79% = 492 
        80 - 99% = 196 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1780, nodes: 2145110 
    Average node length: 4.97, total dup: 2145060, max dup: 130100 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1040315, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 624 
        60 - 79% = 50 
        80 - 99% = 1075 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4293, nodes: 2145110 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 654637, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 89 
        20 - 39% = 686 
        40 - 59% = 620 
        60 - 79% = 965 
        80 - 99% = 1933 
 
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: 30.31, total versions: 1550, max versions: 4 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 58% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 7, full pages: 14 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    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: 18.48, total records: 91610 
    Average version length: 68.30, total versions: 76966, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.76 
    Pointer pages: 8, data page slots: 3400 
    Data pages: 1760, average fill: 69% 
    Primary pages: 1759, secondary pages: 1, swept pages: 224 
    Empty pages: 229, full pages: 1152 
    Fill distribution: 
     0 - 19% = 277 
    20 - 39% = 97 
    40 - 59% = 115 
    60 - 79% = 275 
    80 - 99% = 996 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1702463, depth: 3, leaf buckets: 389, nodes: 91610 
    Average node length: 13.27, total dup: 7215, max dup: 2 
    Average key length: 10.68, compression ratio: 2.53 
    Average prefix length: 19.24, average data length: 7.76 
    Clustering factor: 66563, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 235 
        40 - 59% = 142 
        60 - 79% = 9 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 179, max versions: 7 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 77% 
    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% = 1 
    80 - 99% = 0 
 
    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.09, total records: 1769 
    Average version length: 43.88, total versions: 1616, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.80 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 58% 
    Primary pages: 31, secondary pages: 1, swept pages: 6 
    Empty pages: 9, full pages: 18 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 17 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 95413, depth: 2, leaf buckets: 4, nodes: 1769 
    Average node length: 4.13, total dup: 1671, max dup: 180 
    Average key length: 2.59, compression ratio: 7.35 
    Average prefix length: 18.47, average data length: 0.53 
    Clustering factor: 915, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.66, 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: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    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: 37.25, total records: 848898 
    Average version length: 37.92, total versions: 12112, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.45 
    Pointer pages: 6, data page slots: 9184 
    Data pages: 9184, average fill: 63% 
    Primary pages: 9183, secondary pages: 1, swept pages: 5410 
    Empty pages: 18, full pages: 4068 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 71 
    40 - 59% = 1329 
    60 - 79% = 7723 
    80 - 99% = 18 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 908, nodes: 842923 
    Average node length: 4.89, total dup: 842874, max dup: 165296 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91574, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 118 
        40 - 59% = 498 
        60 - 79% = 181 
        80 - 99% = 108 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1038, nodes: 842923 
    Average node length: 5.90, total dup: 750542, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164822, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 35 
        40 - 59% = 694 
        60 - 79% = 60 
        80 - 99% = 247 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1069, nodes: 842923 
    Average node length: 5.90, total dup: 750542, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166683, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 66 
        40 - 59% = 705 
        60 - 79% = 68 
        80 - 99% = 229 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1183, nodes: 842923 
    Average node length: 5.98, total dup: 750542, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158574, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 223 
        40 - 59% = 648 
        60 - 79% = 211 
        80 - 99% = 97 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.81, total records: 5453 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.41, total fragments: 27, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 104 
    Data pages: 104, average fill: 52% 
    Primary pages: 83, secondary pages: 21, swept pages: 66 
    Empty pages: 19, full pages: 51 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 7, nodes: 5453 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.60, compression ratio: 10.00 
    Average prefix length: 34.43, average data length: 1.56 
    Clustering factor: 5066, ratio: 0.93 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5453 
    Average node length: 11.10, 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: 147, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.09, total records: 77457 
    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: 808 
    Data pages: 808, average fill: 66% 
    Primary pages: 808, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 804 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 805 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 40162, depth: 2, leaf buckets: 99, nodes: 77457 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 2800, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.63, 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.28 
    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: 151.09, total records: 178669 
    Average version length: 147.78, total versions: 231, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 9, data page slots: 4808 
    Data pages: 4440, average fill: 83% 
    Primary pages: 4437, secondary pages: 3, swept pages: 8 
    Empty pages: 27, full pages: 4376 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 16 
    40 - 59% = 11 
    60 - 79% = 6 
    80 - 99% = 4374 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.92, total records: 140995 
    Average version length: 138.64, total versions: 157, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 8, data page slots: 4336 
    Data pages: 3504, average fill: 83% 
    Primary pages: 3502, secondary pages: 2, swept pages: 7 
    Empty pages: 34, full pages: 3455 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3455 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 138.80, total records: 153058 
    Average version length: 154.11, total versions: 13419, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.22 
    Pointer pages: 8, data page slots: 4688 
    Data pages: 3864, average fill: 83% 
    Primary pages: 3862, secondary pages: 2, swept pages: 6 
    Empty pages: 79, full pages: 3756 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 13 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 3756 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 151.09, total records: 164218 
    Average version length: 146.24, total versions: 235, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.23 
    Pointer pages: 7, data page slots: 5608 
    Data pages: 4096, average fill: 83% 
    Primary pages: 4094, secondary pages: 2, swept pages: 5 
    Empty pages: 49, full pages: 4031 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 4031 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.45, total records: 150848 
    Average version length: 150.96, total versions: 357, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 8, data page slots: 4776 
    Data pages: 3760, average fill: 82% 
    Primary pages: 3758, secondary pages: 2, swept pages: 2 
    Empty pages: 56, full pages: 3689 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3690 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 141.83, total records: 165254 
    Average version length: 154.90, total versions: 10634, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.96 
    Pointer pages: 8, data page slots: 6080 
    Data pages: 4176, average fill: 82% 
    Primary pages: 4174, secondary pages: 2, swept pages: 2 
    Empty pages: 100, full pages: 4049 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 12 
    40 - 59% = 3 
    60 - 79% = 11 
    80 - 99% = 4046 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 151.11, total records: 157842 
    Average version length: 141.60, total versions: 68, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.22 
    Pointer pages: 7, data page slots: 4208 
    Data pages: 3936, average fill: 83% 
    Primary pages: 3934, secondary pages: 2, swept pages: 6 
    Empty pages: 49, full pages: 3872 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 1 
    80 - 99% = 3872 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 149.46, total records: 147366 
    Average version length: 152.24, total versions: 1739, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 7, data page slots: 5048 
    Data pages: 3712, average fill: 82% 
    Primary pages: 3711, secondary pages: 1, swept pages: 8 
    Empty pages: 77, full pages: 3606 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 12 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 3604 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 139.84, total records: 176276 
    Average version length: 155.00, total versions: 14605, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.13 
    Pointer pages: 8, data page slots: 5248 
    Data pages: 4408, average fill: 84% 
    Primary pages: 4405, secondary pages: 3, swept pages: 6 
    Empty pages: 45, full pages: 4335 
    Fill distribution: 
     0 - 19% = 51 
    20 - 39% = 7 
    40 - 59% = 9 
    60 - 79% = 5 
    80 - 99% = 4336 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 150.35, total records: 172302 
    Average version length: 152.72, total versions: 1234, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 8, data page slots: 4616 
    Data pages: 4280, average fill: 83% 
    Primary pages: 4277, secondary pages: 3, swept pages: 7 
    Empty pages: 29, full pages: 4223 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 3 
    40 - 59% = 12 
    60 - 79% = 7 
    80 - 99% = 4224 
 
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.32, total records: 2015582 
    Average version length: 52.98, total versions: 19594, 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: 25680 
    Data pages: 25672, average fill: 68% 
    Primary pages: 25645, secondary pages: 27, swept pages: 14384 
    Empty pages: 305, full pages: 18766 
    Fill distribution: 
     0 - 19% = 622 
    20 - 39% = 590 
    40 - 59% = 1805 
    60 - 79% = 22496 
    80 - 99% = 159 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2538, nodes: 2015582 
    Average node length: 5.45, total dup: 1877794, max dup: 1260 
    Average key length: 2.50, compression ratio: 3.60 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 176913, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 354 
        40 - 59% = 1622 
        60 - 79% = 295 
        80 - 99% = 262 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2752, nodes: 2015582 
    Average node length: 5.70, total dup: 1807494, max dup: 67 
    Average key length: 2.75, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 362012, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2572 
        60 - 79% = 153 
        80 - 99% = 19 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2041, nodes: 2015582 
    Average node length: 4.96, total dup: 2015482, max dup: 26588 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 175204, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 223 
        40 - 59% = 997 
        60 - 79% = 405 
        80 - 99% = 414 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 54.65, total records: 115306 
    Average version length: 69.16, total versions: 27908, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.31 
    Pointer pages: 3, data page slots: 4568 
    Data pages: 3096, average fill: 44% 
    Primary pages: 3096, secondary pages: 0, swept pages: 845 
    Empty pages: 454, full pages: 309 
    Fill distribution: 
     0 - 19% = 637 
    20 - 39% = 459 
    40 - 59% = 1057 
    60 - 79% = 866 
    80 - 99% = 77 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1556857, depth: 3, leaf buckets: 233, nodes: 115306 
    Average node length: 6.61, total dup: 100227, max dup: 14 
    Average key length: 4.01, compression ratio: 10.47 
    Average prefix length: 40.12, average data length: 1.88 
    Clustering factor: 20271, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 118 
        40 - 59% = 101 
        60 - 79% = 13 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.95, total records: 7413800 
    Average version length: 68.75, total versions: 123052, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 70, data page slots: 113656 
    Data pages: 113656, average fill: 69% 
    Primary pages: 113655, secondary pages: 1, swept pages: 74946 
    Empty pages: 10, full pages: 49089 
    Fill distribution: 
     0 - 19% = 116 
    20 - 39% = 748 
    40 - 59% = 9544 
    60 - 79% = 102871 
    80 - 99% = 377 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10948, nodes: 7413800 
    Average node length: 6.51, total dup: 6414375, max dup: 29 
    Average key length: 3.52, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1718489, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 1450 
        40 - 59% = 5781 
        60 - 79% = 3079 
        80 - 99% = 626 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8864, nodes: 7413800 
    Average node length: 5.39, total dup: 7127165, max dup: 129 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1507737, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1157 
        40 - 59% = 4851 
        60 - 79% = 1807 
        80 - 99% = 1042 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8987, nodes: 7413800 
    Average node length: 5.39, total dup: 7127165, max dup: 129 
    Average key length: 2.40, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1510169, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1286 
        40 - 59% = 4907 
        60 - 79% = 1818 
        80 - 99% = 971 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.32, total records: 12415660 
    Average version length: 68.66, total versions: 127275, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.84 
    Pointer pages: 112, data page slots: 181656 
    Data pages: 181656, average fill: 72% 
    Primary pages: 181655, secondary pages: 1, swept pages: 109216 
    Empty pages: 4, full pages: 134169 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 483 
    40 - 59% = 6284 
    60 - 79% = 174080 
    80 - 99% = 762 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18661, nodes: 12414431 
    Average node length: 6.64, total dup: 10823157, max dup: 60 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2498828, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1942 
        40 - 59% = 10611 
        60 - 79% = 5195 
        80 - 99% = 884 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 58.26, total records: 1177406 
    Average version length: 69.02, total versions: 116014, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.16 
    Pointer pages: 28, data page slots: 44592 
    Data pages: 27640, average fill: 45% 
    Primary pages: 27566, secondary pages: 74, swept pages: 15972 
    Empty pages: 4916, full pages: 10737 
    Fill distribution: 
     0 - 19% = 7939 
    20 - 39% = 4153 
    40 - 59% = 3226 
    60 - 79% = 10837 
    80 - 99% = 1485 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1709, nodes: 1080619 
    Average node length: 5.55, total dup: 1036684, max dup: 49 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 76251, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 729 
        40 - 59% = 751 
        60 - 79% = 218 
        80 - 99% = 6 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 56.19, total records: 904051 
    Average version length: 69.02, total versions: 49104, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.24 
    Pointer pages: 22, data page slots: 35744 
    Data pages: 30104, average fill: 31% 
    Primary pages: 30104, secondary pages: 0, swept pages: 16424 
    Empty pages: 6400, full pages: 678 
    Fill distribution: 
     0 - 19% = 10858 
    20 - 39% = 6983 
    40 - 59% = 8999 
    60 - 79% = 3249 
    80 - 99% = 15 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1257, nodes: 760103 
    Average node length: 5.97, total dup: 699196, max dup: 56 
    Average key length: 3.03, compression ratio: 13.86 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 116762, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 480 
        40 - 59% = 593 
        60 - 79% = 178 
        80 - 99% = 4 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.49, total records: 8355240 
    Average version length: 68.98, total versions: 191264, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 89, data page slots: 144384 
    Data pages: 144296, average fill: 62% 
    Primary pages: 144275, secondary pages: 21, swept pages: 94618 
    Empty pages: 706, full pages: 38788 
    Fill distribution: 
     0 - 19% = 2342 
    20 - 39% = 10752 
    40 - 59% = 35335 
    60 - 79% = 95071 
    80 - 99% = 796 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13309, nodes: 8352308 
    Average node length: 6.69, total dup: 6926382, max dup: 14 
    Average key length: 3.68, compression ratio: 11.42 
    Average prefix length: 40.49, average data length: 1.51 
    Clustering factor: 1907755, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2437 
        40 - 59% = 7174 
        60 - 79% = 3336 
        80 - 99% = 361 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21114275 
    Average version length: 82.85, total versions: 4755, 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: 319384 
    Data pages: 319384, average fill: 81% 
    Primary pages: 319379, secondary pages: 5, swept pages: 13737 
    Empty pages: 36, full pages: 318209 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 69 
    40 - 59% = 195 
    60 - 79% = 49006 
    80 - 99% = 270035 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19482, nodes: 21114275 
    Average node length: 5.72, total dup: 20634031, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3278403, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8396 
        60 - 79% = 518 
        80 - 99% = 10560 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17142, nodes: 21114275 
    Average node length: 6.31, total dup: 18554920, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915962, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 5 
        40 - 59% = 758 
        60 - 79% = 292 
        80 - 99% = 16083 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21242, nodes: 21114275 
    Average node length: 6.35, total dup: 18473795, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3572002, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 8621 
        60 - 79% = 579 
        80 - 99% = 12041 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16063, nodes: 21114275 
    Average node length: 5.56, total dup: 21114175, max dup: 231311 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944757, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 14 
        40 - 59% = 2839 
        60 - 79% = 386 
        80 - 99% = 12823 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 74.59, total records: 9635286 
    Average version length: 82.62, total versions: 1023626, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.69 
    Pointer pages: 106, data page slots: 171936 
    Data pages: 171864, average fill: 71% 
    Primary pages: 171822, secondary pages: 42, swept pages: 38444 
    Empty pages: 818, full pages: 114467 
    Fill distribution: 
     0 - 19% = 1962 
    20 - 39% = 8393 
    40 - 59% = 25940 
    60 - 79% = 95900 
    80 - 99% = 39669 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11337, nodes: 9635286 
    Average node length: 5.36, total dup: 9329893, max dup: 274 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2196000, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 98 
        40 - 59% = 8278 
        60 - 79% = 2897 
        80 - 99% = 64 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13428, nodes: 9635286 
    Average node length: 6.23, total dup: 7992293, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1562053, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 3778 
        40 - 59% = 4523 
        60 - 79% = 2730 
        80 - 99% = 2287 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12660, nodes: 9635286 
    Average node length: 5.97, total dup: 8374432, max dup: 55 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2388331, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 123 
        40 - 59% = 9303 
        60 - 79% = 3173 
        80 - 99% = 59 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10016, nodes: 9635286 
    Average node length: 5.13, total dup: 9635186, max dup: 156637 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1588509, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1120 
        40 - 59% = 5066 
        60 - 79% = 1749 
        80 - 99% = 2044 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 77.49, total records: 11125027 
    Average version length: 82.53, total versions: 726915, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 119, data page slots: 193168 
    Data pages: 191624, average fill: 72% 
    Primary pages: 191460, secondary pages: 164, swept pages: 58802 
    Empty pages: 3328, full pages: 144425 
    Fill distribution: 
     0 - 19% = 5657 
    20 - 39% = 7936 
    40 - 59% = 17244 
    60 - 79% = 90870 
    80 - 99% = 69917 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13113, nodes: 11125027 
    Average node length: 5.30, total dup: 11016145, max dup: 641 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2327230, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 170 
        40 - 59% = 9659 
        60 - 79% = 3177 
        80 - 99% = 107 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10288, nodes: 11125027 
    Average node length: 5.49, total dup: 10637927, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 710664, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 168 
        20 - 39% = 855 
        40 - 59% = 2504 
        60 - 79% = 1815 
        80 - 99% = 4946 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14995, nodes: 11125027 
    Average node length: 6.02, total dup: 9708159, max dup: 76 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2343636, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 226 
        40 - 59% = 11157 
        60 - 79% = 3494 
        80 - 99% = 116 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10519, nodes: 11125027 
    Average node length: 5.22, total dup: 11124927, max dup: 185291 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 699526, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 82 
        20 - 39% = 841 
        40 - 59% = 4594 
        60 - 79% = 1441 
        80 - 99% = 3561 
 
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: 75.25, total records: 9704912 
    Average version length: 82.93, total versions: 982404, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 108, data page slots: 175616 
    Data pages: 175496, average fill: 70% 
    Primary pages: 175457, secondary pages: 39, swept pages: 44291 
    Empty pages: 1065, full pages: 117863 
    Fill distribution: 
     0 - 19% = 2946 
    20 - 39% = 10206 
    40 - 59% = 27416 
    60 - 79% = 95718 
    80 - 99% = 39210 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11598, nodes: 9704912 
    Average node length: 5.18, total dup: 9676487, max dup: 1654 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2028313, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1448 
        40 - 59% = 7494 
        60 - 79% = 2013 
        80 - 99% = 612 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13601, nodes: 9704912 
    Average node length: 6.24, total dup: 8049938, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1534807, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 3834 
        40 - 59% = 4570 
        60 - 79% = 2652 
        80 - 99% = 2373 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12226, nodes: 9704912 
    Average node length: 5.43, total dup: 9275178, max dup: 106 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2157925, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1395 
        40 - 59% = 8404 
        60 - 79% = 1815 
        80 - 99% = 582 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10095, nodes: 9704912 
    Average node length: 5.15, total dup: 9704812, max dup: 157826 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1610204, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 50 
        20 - 39% = 1208 
        40 - 59% = 5017 
        60 - 79% = 1684 
        80 - 99% = 2136 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.82, total records: 574476 
    Average version length: 68.79, total versions: 13012, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8056 
    Data pages: 8056, average fill: 75% 
    Primary pages: 8056, secondary pages: 0, swept pages: 2772 
    Empty pages: 2, full pages: 7051 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 12 
    40 - 59% = 152 
    60 - 79% = 7689 
    80 - 99% = 200 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 53301, depth: 3, leaf buckets: 743, nodes: 574476 
    Average node length: 5.95, total dup: 489099, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101085, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 535 
        60 - 79% = 89 
        80 - 99% = 84 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 38669, depth: 3, leaf buckets: 765, nodes: 574476 
    Average node length: 6.15, total dup: 471110, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101141, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 32 
        40 - 59% = 545 
        60 - 79% = 98 
        80 - 99% = 90 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 567, nodes: 574476 
    Average node length: 4.86, total dup: 574376, max dup: 9545 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 89845, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 330 
        60 - 79% = 78 
        80 - 99% = 126 
 
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 Wed Apr  3 13:11:27 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7574943 34292 1 0.0000 0.0000
DOC_LIST 2145110 16287 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1550 4 300.0000 0.0000
INVNT_TURNOVER_LOG 91610 76966 1 0.0000 0.0000
MONEY_SALDO 49 179 7 300.0000 0.0000
MONEY_TURNOVER_LOG 1769 1616 1 0.0000 0.0000
PDISTR 848898 12112 2 0.0000 0.0000
PERF_SPLIT_0 178669 231 1 0.0000 0.0000
PERF_SPLIT_1 140995 157 1 0.0000 0.0000
PERF_SPLIT_2 153058 13419 1 0.0000 0.0000
PERF_SPLIT_3 164218 235 1 0.0000 0.0000
PERF_SPLIT_4 150848 357 1 0.0000 0.0000
PERF_SPLIT_5 165254 10634 1 0.0000 0.0000
PERF_SPLIT_6 157842 68 1 0.0000 0.0000
PERF_SPLIT_7 147366 1739 1 0.0000 0.0000
PERF_SPLIT_8 176276 14605 1 0.0000 0.0000
PERF_SPLIT_9 172302 1234 1 0.0000 0.0000
PSTORNED 2015582 19594 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 115306 27908 1 0.0000 0.0000
XQD_1000_3300 7413800 123052 1 0.0000 0.0000
XQD_1200_2000 12415660 127275 1 0.0000 0.0000
XQD_2000_3300 1177406 116014 1 0.0000 0.0000
XQD_2100_3300 904051 49104 1 0.0000 0.0000
XQD_3300_3400 8355240 191264 1 0.0000 0.0000
XQS_1000_1200 21114275 4755 1 0.0000 0.0000
XQS_1000_3300 9635286 1023626 1 0.0000 0.0000
XQS_1200_2000 11125027 726915 1 0.0000 0.0000
XQS_2100_3300 9704912 982404 1 0.0000 0.0000
XQS_3300_3400 574476 13012 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 ---
:100: 
:101: mscs-test-161.budzdorov.ru    Wed Apr  3 13:08:40 2024
:102:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:103: 
:104: 
:105: mscs-test-161.budzdorov.ru    Wed Apr  3 13:08:43 2024
:106:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:107: 
--- end of diff output ---

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

03.04.24 13:11:38. 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-04-03 13:11:41 No severe PSQL-related problems occured
03.04.24 13:11:42. End of report.