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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-20 10:07:50
DTS_END                         2024-03-20 10:07:50.1210
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/39040
TRN_ID                          160113
ATT_ID                          486
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: 8806.52 19951 880652
customer order: creation 165.00 479 16500
customer order: refuse 14.59 341 1459
order to supplier: creation 44.88 1289 4488
order to supplier: removal 3.46 84793 346
invoice (draft): creation 44.19 3174 4419
invoice (draft): removal 49.11 672 4911
invoice accept: apply 39.87 21833 3987
invoice accept: cancel 44.53 828 4453
customer reserve: creation 3785.79 214 378579
customer reserve: removal 4334.05 54 433405
realization accept: apply 80.24 185 8024
realization accept: cancel 79.63 132 7963
payment from customer: creation 54.88 108 5488
payment from customer: removal 5.77 58 577
payment to supplier: creation 47.25 119 4725
payment to supplier: removal 3.11 102 311
service: total inventory turnovers 3.95 3630 395
service: total monetary turnovers 5.41 516 541
service: aggregate perf. data 0.78 20365 78
service: refresh index statistics 0.03 260130 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-03-2024 10:08:51 to 20-03-2024 10:08:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2892
TEST_TIME 2 2956
TEST_TIME 3 3992
TEST_TIME 4 4756
TEST_TIME 5 4536
TEST_TIME 6 5030
TEST_TIME 7 4748
TEST_TIME 8 4710
TEST_TIME 9 5251
TEST_TIME 10 5148
TEST_TIME 11 5801
TEST_TIME 12 5969
TEST_TIME 13 6131
TEST_TIME 14 6412
TEST_TIME 15 6974
TEST_TIME 16 7336
TEST_TIME 17 7826
TEST_TIME 18 7899
TEST_TIME 19 8121
TEST_TIME 20 8333
TEST_TIME 21 8744
TEST_TIME 22 8758
TEST_TIME 23 9142
TEST_TIME 24 9137
TEST_TIME 25 9096
TEST_TIME 26 8761
TEST_TIME 27 8775
TEST_TIME 28 8572
TEST_TIME 29 8409
TEST_TIME 30 8336
TEST_TIME 31 8192
TEST_TIME 32 8114
TEST_TIME 33 8062
TEST_TIME 34 8108
TEST_TIME 35 8053
TEST_TIME 36 8004
TEST_TIME 37 8131
TEST_TIME 38 8365
TEST_TIME 39 8443
TEST_TIME 40 8522
TEST_TIME 41 8662
TEST_TIME 42 8646
TEST_TIME 43 8808
TEST_TIME 44 8739
TEST_TIME 45 8772
TEST_TIME 46 8836
TEST_TIME 47 8740
TEST_TIME 48 8623
TEST_TIME 49 8540
TEST_TIME 50 8557
TEST_TIME 51 8515
TEST_TIME 52 8444
TEST_TIME 53 8444
TEST_TIME 54 8412
TEST_TIME 55 8413
TEST_TIME 56 8587
TEST_TIME 57 8535
TEST_TIME 58 8739
TEST_TIME 59 8738
TEST_TIME 60 8837
TEST_TIME 61 8830
TEST_TIME 62 8875
TEST_TIME 63 8822
TEST_TIME 64 8722
TEST_TIME 65 8642
TEST_TIME 66 8653
TEST_TIME 67 8749
TEST_TIME 68 8677
TEST_TIME 69 8609
TEST_TIME 70 8578
TEST_TIME 71 8570
TEST_TIME 72 8643
TEST_TIME 73 8618
TEST_TIME 74 8588
TEST_TIME 75 8591
TEST_TIME 76 8680
TEST_TIME 77 8656
TEST_TIME 78 8703
TEST_TIME 79 8729
TEST_TIME 80 8845
TEST_TIME 81 8809
TEST_TIME 82 8843
TEST_TIME 83 8848
TEST_TIME 84 8937
TEST_TIME 85 8983
TEST_TIME 86 8949
TEST_TIME 87 8872
TEST_TIME 88 8830
TEST_TIME 89 8813
TEST_TIME 90 8775
TEST_TIME 91 8696
TEST_TIME 92 8709
TEST_TIME 93 8759
TEST_TIME 94 8767
TEST_TIME 95 8759
TEST_TIME 96 8740
TEST_TIME 97 8754
TEST_TIME 98 8774
TEST_TIME 99 8833
TEST_TIME 100 8812

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-03-2024 10:08:55 to 20-03-2024 10:08:58.

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 1227777 1227777 0 0.00 0 32349 7 0 0
doc_list_biud 1227777 1227777 0 0.00 0 58360 24 0 0
sp_add_invoice_to_stock 4093 3987 106 2.58 38 346675 21834 0 106
sp_cancel_adding_invoice 4453 4453 0 0.00 4 82080 829 0 0
sp_cancel_client_order 1459 1459 0 0.00 3 8735 341 0 0
sp_cancel_customer_reserve 433405 433405 0 0.00 0 58361 55 0 0
sp_cancel_pay_from_customer 577 577 0 0.00 2 1838 58 0 0
sp_cancel_pay_to_supplier 311 311 0 0.00 2 6916 102 0 0
sp_cancel_supplier_invoice 4917 4911 6 0.12 2 27936 673 0 6
sp_cancel_supplier_order 346 346 0 0.00 8 717003 84794 0 0
sp_cancel_write_off 7963 7963 0 0.00 1 31365 133 0 0
sp_client_order 16500 16500 0 0.00 3 21290 480 0 0
sp_customer_reserve 378579 378579 0 0.00 0 91306 214 0 0
sp_fill_shopping_cart 25402 25402 0 0.00 1 19709 40 0 0
sp_fill_shopping_cart_clo_res 378563 378563 0 0.00 0 21155 19 0 0
sp_get_clo_for_invoice 3971 3971 0 0.00 0 14573 402 0 0
sp_kill_cost_storno 13304 13304 0 0.00 0 30179 73 0 0
sp_kill_qstorno_ret_qs2qd 880030 880030 0 0.00 0 58325 30 0 0
sp_kill_qty_storno 464532 464532 0 0.00 0 58360 64 0 0
sp_lock_selected_doc 16783 16783 0 0.00 0 4998 4 0 0
sp_make_cost_storno 22208 22208 0 0.00 0 26783 65 0 0
sp_multiply_rows_for_pdistr 22208 22208 0 0.00 0 7165 31 0 0
sp_multiply_rows_for_qdistr 16500 16500 0 0.00 0 20642 275 0 0
sp_pay_from_customer 5488 5488 0 0.00 4 11122 108 0 0
sp_pay_to_supplier 4725 4725 0 0.00 5 12479 119 0 0
sp_payment_common 10213 10213 0 0.00 1 7701 18 0 0
sp_qd_handle_on_cancel_clo 1459 1459 0 0.00 0 8728 320 0 0
sp_qd_handle_on_invoice_upd_sts 8424 8424 0 0.00 0 29709 270 0 0
sp_qd_handle_on_reserve_upd_sts 8024 8024 0 0.00 0 20259 61 0 0
sp_reserve_write_off 8024 8024 0 0.00 6 20279 185 0 0
sp_supplier_invoice 4419 4419 0 0.00 5 99106 3175 0 0
sp_supplier_order 4488 4488 0 0.00 4 30902 1290 0 0
srv_aggregate_perf_data 78 78 0 0.00 1702 444944 20365 0 0
srv_fill_mon_cache_memory 53 53 0 0.00 1394 143588 42591 0 0
srv_find_qd_qs_mism 840611 840611 0 0.00 0 32348 6 0 0
srv_make_invnt_saldo 395 395 0 0.00 25 94302 3631 0 0
srv_make_money_saldo 541 541 0 0.00 0 10854 517 0 0
srv_recalc_idx_stat 3 3 0 0.00 246674 280256 260130 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 3987 3987 0 0.00 0 16641 182 0 0
t$perf-norm:sp_cancel_adding_invoice 345 345 0 0.00 0 3719 84 0 0
t$perf-norm:sp_cancel_client_order 1459 1459 0 0.00 0 3308 13 0 0
t$perf-norm:sp_cancel_customer_reserve 563 563 0 0.00 0 3689 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 577 577 0 0.00 0 1273 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 311 311 0 0.00 0 900 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 348 348 0 0.00 0 1143 11 0 0
t$perf-norm:sp_cancel_supplier_order 346 346 0 0.00 0 17971 1590 0 0
t$perf-norm:sp_cancel_write_off 839 839 0 0.00 0 1256 8 0 0
t$perf-norm:sp_client_order 16500 16500 0 0.00 0 10579 15 0 0
t$perf-norm:sp_customer_reserve 792 792 0 0.00 0 11555 19 0 0
t$perf-norm:sp_pay_from_customer 5488 5488 0 0.00 0 5456 10 0 0
t$perf-norm:sp_pay_to_supplier 4725 4725 0 0.00 0 17867 11 0 0
t$perf-norm:sp_reserve_write_off 8024 8024 0 0.00 0 8450 14 0 0
t$perf-norm:sp_supplier_invoice 4419 4419 0 0.00 0 13880 14 0 0
t$perf-norm:sp_supplier_order 4488 4488 0 0.00 0 7379 12 0 0
t$perf-norm:srv_aggregate_perf_data 78 78 0 0.00 0 595 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 53 53 0 0.00 0 421 12 0 0
t$perf-norm:srv_make_invnt_saldo 395 395 0 0.00 0 691 7 0 0
t$perf-norm:srv_make_money_saldo 541 541 0 0.00 0 5582 22 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 8154 7942 212 2.59 0 4822 15 0 212
v_all_customers 30074 30074 0 0.00 0 45 0 0 0
v_all_suppliers 25264 25264 0 0.00 0 170 1 0 0
v_all_wares 33000 33000 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 690 690 0 0.00 0 2134 13 0 0
v_cancel_client_order 2918 2918 0 0.00 0 2151 5 0 0
v_cancel_customer_prepayment 1154 1154 0 0.00 0 1828 5 0 0
v_cancel_customer_reserve 1126 1126 0 0.00 0 4372 9 0 0
v_cancel_payment_to_supplier 622 622 0 0.00 0 2916 14 0 0
v_cancel_supplier_invoice 708 696 12 1.69 0 656 12 0 12
v_cancel_supplier_order 692 692 0 0.00 0 220 2 0 0
v_cancel_write_off 1678 1678 0 0.00 0 1607 13 0 0
v_max_id_clo_ord 4488 4488 0 0.00 0 395 1 0 0
v_max_id_clo_res 792 792 0 0.00 0 1799 7 0 0
v_max_id_ord_sup 4414 4414 0 0.00 0 4932 3 0 0
v_max_non_paid_invoice 995 995 0 0.00 0 73 2 0 0
v_max_non_paid_realizn 2783 2783 0 0.00 0 1507 3 0 0
v_min_id_clo_ord 4488 4488 0 0.00 0 9950 7 0 0
v_min_id_clo_res 792 792 0 0.00 0 1104 4 0 0
v_min_id_ord_sup 4414 4414 0 0.00 0 3380 4 0 0
v_min_non_paid_invoice 4725 4725 0 0.00 0 7697 11 0 0
v_min_non_paid_realizn 5488 5488 0 0.00 0 5882 14 0 0
v_our_firm 8336 8336 0 0.00 0 13 1 0 0
v_reserve_write_off 16048 16048 0 0.00 0 4945 5 0 0
x_lock_depdocs_on_canc_invoice 9016 9016 0 0.00 0 10872 114 0 0
x_lock_depdocs_on_canc_sup_ord 346 346 0 0.00 0 18123 322 0 0
x_make_qstorno_1000_1200 4488 4488 0 0.00 1 27915 1209 0 0
x_make_qstorno_1200_2000 4419 4419 0 0.00 2 99086 3027 0 0
x_make_qstorno_2100_3300 378579 378579 0 0.00 0 91306 193 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-03-2024 10:08:59 to 20-03-2024 10:09:03.

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
08:07:54 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
08:08:55 27023 8192000000 9703297552 10001399808 783317776 8.727 100 92 184 0 813716624 7178112 23220736
08:10:23 16127 8192000000 9742616688 10046820352 820722992 9.106 100 89 178 0 852730224 11255056 20752176
08:11:43 17939 8192000000 9771445216 10084691968 843751312 9.337 100 88 176 0 879303024 15230272 20321440
08:13:12 10283 8192000000 9816073328 10144436224 887715552 9.776 100 74 148 0 932772400 29479712 15577136
08:14:26 7135 8192000000 9881417088 10219716608 930525856 10.200 100 83 162 1 992226736 44768320 16932560
08:15:40 5283 8192000000 9944170736 10291589120 964375040 10.532 100 90 179 0 1053379280 71649408 17354832
08:16:49 2813 8192000000 9972677360 10329788416 991226016 10.793 100 86 170 1 1083452944 75970736 16256192
08:17:54 3156 8192000000 9978791504 10347253760 1012816368 11.003 100 76 153 0 1093454928 65772688 14865872
08:19:00 2414 8192000000 9986798672 10356809728 1028286352 11.152 100 87 171 0 1105415968 60678544 16451072
08:20:04 1867 8192000000 10015431424 10389721088 1049110608 11.352 100 92 184 0 1132685744 64783664 18791472
08:21:09 1571 8192000000 10061009264 10442850304 1056506336 11.423 100 84 165 1 1171348384 99324064 15517984
08:22:14 2364 8192000000 10020014832 10399457280 1065737024 11.511 100 78 154 0 1131673568 50828944 15107600
08:23:18 6007 8192000000 9989341184 10380881920 1065374432 11.508 100 31 64 0 1099210576 26842240 6993904
08:24:25 7950 8192000000 9984040944 10398756864 1071973152 11.571 100 25 47 1 1104454432 27588128 4893152
08:25:37 8654 8192000000 9992623536 10398691328 1081225696 11.659 100 13 26 0 1116501648 32640192 2635760
08:26:47 37096 8192000000 9996801200 10399764480 1085729840 11.702 100 44 87 0 1113504832 18170720 9604272
08:28:27 1467 8192000000 10035381248 10431787008 1095367584 11.794 100 64 128 0 1141251984 32587360 13297040
08:29:34 31740 8192000000 10078693984 10478628864 1105118672 11.886 100 59 113 1 1182550160 66682064 10749424
08:31:31 25151 8192000000 10074202080 10481885184 1104149792 11.877 99 45 90 0 1182563424 68679024 9734608
08:33:03 15708 8192000000 10100582272 10517032960 1123236192 12.058 100 38 76 0 1221489920 90911664 7342064
08:34:23 26978 8192000000 10121307232 10535239680 1111286656 11.945 98 31 62 1 1212194736 94463328 6444752
08:35:55 18834 8192000000 10178542496 10584072192 1122761808 12.053 100 53 104 3 1275745232 142238912 10744512
08:37:17 11880 8192000000 10166837648 10569592832 1106208368 11.897 98 54 108 0 1256031552 138709952 11113232
08:38:45 14947 8192000000 10124385824 10545782784 1083294080 11.679 97 45 90 0 1231403936 138469136 9640720
08:40:06 16205 8192000000 10146443600 10550697984 1086162576 11.706 99 52 104 1 1246991216 149693392 11135248
08:41:26 2487 8192000000 10190638048 10589741056 1097887872 11.818 100 61 119 1 1295340032 184219920 13232240
08:42:34 5335 8192000000 10203541504 10611781632 1093261920 11.774 100 63 122 0 1322112688 215506768 13344000
08:43:45 1393 8192000000 10179266448 10592477184 1098449456 11.823 100 74 142 0 1280937360 166856672 15631232
08:44:50 7320 8192000000 10164902896 10571022336 1097846976 11.817 100 53 105 1 1271121360 162460960 10813424
08:46:02 18366 8192000000 10163766256 10594193408 1099652000 11.834 100 28 53 1 1275575088 169888048 6035040
08:47:26 36129 8192000000 10148145136 10566828032 1073724048 11.588 98 20 40 0 1233442480 155271440 4446992
08:49:06 23273 8192000000 10105591296 10548822016 1085711472 11.702 99 23 45 0 1219840736 129259824 4869440
08:50:34 13518 8192000000 10069832512 10495332352 1101383456 11.851 100 22 44 0 1193275424 87572224 4319744
08:51:51 143588 8192000000 10043809936 10479747072 1065050256 11.505 97 30 61 0 1128940384 57419776 6470352
08:55:18 69748 8192000000 10027384224 10453676032 1080453408 11.652 98 38 74 0 1116032576 27412208 8166960
08:57:40 47238 8192000000 10038349472 10471124992 1081705184 11.664 98 16 32 0 1126570064 41951600 2913280
08:59:33 46641 8192000000 10059397280 10505859072 1108995632 11.923 100 18 36 0 1174191088 61437600 3757856
09:01:33 50040 8192000000 10090096640 10543448064 1094844512 11.789 98 21 42 0 1169947248 70751152 4351584
09:03:45 28356 8192000000 10155549680 10589040640 1124708176 12.071 100 28 54 1 1243555040 112937984 5908880
09:05:18 45396 8192000000 10087186816 10562195456 1118069648 12.009 99 10 20 0 1222951488 102546000 2335840
09:07:13 55855 8192000000 10115624432 10575134720 1140909456 12.224 100 14 28 0 1210381248 66363648 3108144
09:09:23 35254 8192000000 10124145456 10585325568 1137899600 12.196 99 42 84 0 1178726240 32362624 8464016
09:10:58 40534 8192000000 10067029648 10493460480 1133916800 12.158 99 24 46 0 1161842496 23148944 4776752
09:12:39 24930 8192000000 10081001488 10526478336 1123939408 12.064 98 43 86 0 1180372256 47844720 8588128
09:14:15 93116 8192000000 10076977632 10501681152 1130590624 12.127 99 36 72 0 1179090000 41420064 7079312
09:16:57 135781 8192000000 10067164192 10527260672 1086018160 11.705 95 25 50 0 1154984656 63745008 5221488
09:20:15 41483 8192000000 10121267104 10588930048 1132559856 12.145 99 22 44 0 1224828864 87296432 4972576
09:22:24 42201 8192000000 10165621616 10611245056 1099169520 11.830 96 23 47 0 1239248160 135050640 5028000
09:24:07 62569 8192000000 10110023088 10563837952 1086239312 11.707 96 15 30 0 1211798880 122408464 3151104
09:26:10 32776 8192000000 10099751312 10526666752 1103566848 11.871 98 35 72 0 1160771472 49213104 7991520
09:27:55 32778 8192000000 10072629632 10504974336 1070324944 11.555 96 20 40 0 1113943584 39754688 3863952
09:29:33 34701 8192000000 10040559952 10492727296 1028962704 11.158 94 27 54 0 1089462080 55490672 5008704
09:31:12 22535 8192000000 10113623488 10525155328 1092366528 11.765 100 51 102 1 1199600032 97275120 9958384
09:33:13 23323 8192000000 10141577904 10556461056 1081508592 11.662 99 53 104 0 1219168128 127892416 9767120
09:34:40 49160 8192000000 10018872240 10507272192 1095410048 11.794 100 11 22 0 1153195344 55397392 2387904
09:36:29 35934 8192000000 10025762448 10463002624 1083163456 11.678 99 14 28 0 1115981936 29814240 3004240
09:38:05 87464 8192000000 10042151728 10576117760 1067990464 11.533 97 15 30 0 1185083008 114006400 3086144
09:40:43 61531 8192000000 10044564624 10473824256 1082400224 11.670 98 25 49 0 1109096832 21807712 4888896
09:42:46 49561 8192000000 10045949936 10517372928 1091123728 11.753 98 26 52 1 1146147056 49728496 5294832
09:44:48 48424 8192000000 10115647616 10572865536 1105050480 11.886 100 26 52 0 1195155632 84928832 5176320
09:46:36 59067 8192000000 10063132224 10592010240 1102630848 11.863 99 10 20 0 1171020416 66485632 1903936
09:48:48 36631 8192000000 10088286224 10553200640 1116110384 11.990 100 34 68 0 1176201392 53797840 6293168
09:50:25 22400 8192000000 10133703184 10570588160 1124290656 12.068 100 48 96 0 1215496064 82029712 9175696
09:51:53 132381 8192000000 10077878304 10555469824 1117037776 11.999 99 16 32 0 1176414416 56445360 2931280
09:55:24 66617 8192000000 10107439008 10563805184 1133055552 12.150 100 22 44 0 1181764880 44000000 4709328
09:58:47 77114 8192000000 10128977360 10619834368 1138903872 12.205 100 24 48 0 1223901088 80257904 4739312
10:01:49 42958 8192000000 10062379088 10498211840 1096500384 11.804 97 23 45 2 1121895744 20758320 4637040
10:03:37 43351 8192000000 10088143968 10532106240 1112279776 11.954 98 21 42 0 1164702560 48325040 4097744
10:05:30 65125 8192000000 10142869184 10606108672 1123229328 12.057 98 24 48 1 1195839376 67676432 4933616

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 20-03-2024 10:09:05 to 20-03-2024 10:09:19.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 106 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

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          160112
MON$OLDEST_ACTIVE               161191
MON$OLDEST_SNAPSHOT             161191
MON$NEXT_TRANSACTION            161191
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                       1891072
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             669
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3080 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3080 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3080 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3080 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 Mar 20 10:09:23 2024 
 
Database header page information: 
    Flags            0 
    Generation        84149 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    160112 
    Oldest active        161191 
    Oldest snapshot        161191 
    Next transaction    161192 
    Sequence number        0 
    Next attachment ID    669 
    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.20, total records: 7711467 
    Average version length: 48.16, total versions: 136853, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 88600 
    Data pages: 88600, average fill: 70% 
    Primary pages: 88599, secondary pages: 1, swept pages: 30479 
    Empty pages: 1, full pages: 70659 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 57 
    40 - 59% = 2015 
    60 - 79% = 86430 
    80 - 99% = 85 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 22797, nodes: 7711467 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1662939, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 303 
        20 - 39% = 1651 
        40 - 59% = 3764 
        60 - 79% = 2240 
        80 - 99% = 14839 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13254, nodes: 7711467 
    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: 1488192, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1444 
        40 - 59% = 1863 
        60 - 79% = 1052 
        80 - 99% = 8895 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8141, nodes: 7711467 
    Average node length: 6.61, total dup: 5772572, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1481085, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 105 
        20 - 39% = 871 
        40 - 59% = 1280 
        60 - 79% = 860 
        80 - 99% = 5025 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.87, total records: 2229072 
    Average version length: 58.88, total versions: 71370, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28480 
    Data pages: 28480, average fill: 72% 
    Primary pages: 28478, secondary pages: 2, swept pages: 7232 
    Empty pages: 2, full pages: 20100 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 28 
    40 - 59% = 491 
    60 - 79% = 27767 
    80 - 99% = 188 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4420, nodes: 2229072 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678039, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 840 
        40 - 59% = 746 
        60 - 79% = 679 
        80 - 99% = 2155 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2424, nodes: 2230524 
    Average node length: 4.97, total dup: 2229625, max dup: 18693 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1257746, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 213 
        40 - 59% = 1425 
        60 - 79% = 528 
        80 - 99% = 255 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1766, nodes: 2229072 
    Average node length: 4.97, total dup: 2229022, max dup: 129861 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1058376, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 7 
        40 - 59% = 616 
        60 - 79% = 41 
        80 - 99% = 1100 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4232, nodes: 2229072 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678039, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 83 
        20 - 39% = 553 
        40 - 59% = 567 
        60 - 79% = 758 
        80 - 99% = 2271 
 
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.31, total records: 400 
    Average version length: 28.36, total versions: 1755, max versions: 5 
    Average fragment length: 2.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 61% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 3, full pages: 12 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 12 
 
    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: 17.44, total records: 115193 
    Average version length: 68.29, total versions: 98797, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 5.04 
    Pointer pages: 6, data page slots: 2328 
    Data pages: 1872, average fill: 82% 
    Primary pages: 1871, secondary pages: 1, swept pages: 0 
    Empty pages: 54, full pages: 1537 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 100 
    40 - 59% = 90 
    60 - 79% = 141 
    80 - 99% = 1444 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1691894, depth: 3, leaf buckets: 327, nodes: 115193 
    Average node length: 13.10, total dup: 8798, max dup: 2 
    Average key length: 10.59, compression ratio: 2.55 
    Average prefix length: 19.33, average data length: 7.67 
    Clustering factor: 84865, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 217 
        60 - 79% = 73 
        80 - 99% = 34 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 142, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 65% 
    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: 16.20, total records: 1709 
    Average version length: 43.39, total versions: 1367, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.58 
    Pointer pages: 1, data page slots: 48 
    Data pages: 40, average fill: 44% 
    Primary pages: 39, secondary pages: 1, swept pages: 6 
    Empty pages: 14, full pages: 16 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 5 
    40 - 59% = 0 
    60 - 79% = 6 
    80 - 99% = 13 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93361, depth: 2, leaf buckets: 3, nodes: 1709 
    Average node length: 4.22, total dup: 1613, max dup: 195 
    Average key length: 2.60, compression ratio: 7.30 
    Average prefix length: 18.45, average data length: 0.55 
    Clustering factor: 880, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.60, total records: 70 
    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: 49% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 70 
    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: 36.02, total records: 847190 
    Average version length: 37.91, total versions: 34040, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8648 
    Data pages: 8648, average fill: 67% 
    Primary pages: 8646, secondary pages: 2, swept pages: 1132 
    Empty pages: 8, full pages: 8434 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 8 
    40 - 59% = 33 
    60 - 79% = 8523 
    80 - 99% = 70 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 912, nodes: 826542 
    Average node length: 4.88, total dup: 826493, max dup: 158444 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91665, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 146 
        40 - 59% = 504 
        60 - 79% = 185 
        80 - 99% = 77 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 940, nodes: 826542 
    Average node length: 5.90, total dup: 735451, max dup: 43 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165884, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 539 
        60 - 79% = 77 
        80 - 99% = 307 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 972, nodes: 826542 
    Average node length: 5.90, total dup: 735451, max dup: 43 
    Average key length: 3.02, compression ratio: 7.27 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 167715, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 62 
        40 - 59% = 530 
        60 - 79% = 86 
        80 - 99% = 293 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1146, nodes: 826542 
    Average node length: 5.98, total dup: 735451, max dup: 43 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 159603, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 212 
        40 - 59% = 594 
        60 - 79% = 230 
        80 - 99% = 102 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.70, total records: 5420 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.94, total fragments: 16, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 61% 
    Primary pages: 75, secondary pages: 13, swept pages: 49 
    Empty pages: 8, full pages: 50 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 71 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5420 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.04 
    Average prefix length: 34.36, average data length: 1.54 
    Clustering factor: 5140, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        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: 5420 
    Average node length: 11.11, 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: 168, 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.10, total records: 73309 
    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: 768 
    Data pages: 768, average fill: 66% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 5, full pages: 762 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 762 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34448, depth: 2, leaf buckets: 93, nodes: 73309 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2863, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 92 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 139.97, total records: 164394 
    Average version length: 155.05, total versions: 13132, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.12 
    Pointer pages: 5, data page slots: 4592 
    Data pages: 4096, average fill: 84% 
    Primary pages: 4094, secondary pages: 2, swept pages: 1 
    Empty pages: 34, full pages: 4034 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 3 
    40 - 59% = 19 
    60 - 79% = 3 
    80 - 99% = 4034 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 145.04, total records: 142354 
    Average version length: 154.53, total versions: 6434, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 5, data page slots: 4448 
    Data pages: 3576, average fill: 83% 
    Primary pages: 3574, secondary pages: 2, swept pages: 2 
    Empty pages: 60, full pages: 3499 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3498 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.24, total records: 132306 
    Average version length: 148.71, total versions: 946, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 3808 
    Data pages: 3312, average fill: 82% 
    Primary pages: 3309, secondary pages: 3, swept pages: 2 
    Empty pages: 52, full pages: 3247 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3248 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.90, total records: 139663 
    Average version length: 150.66, total versions: 1251, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 7, data page slots: 5664 
    Data pages: 3480, average fill: 83% 
    Primary pages: 3478, secondary pages: 2, swept pages: 3 
    Empty pages: 40, full pages: 3423 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3424 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 131.01, total records: 169256 
    Average version length: 155.20, total versions: 24029, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.95 
    Pointer pages: 5, data page slots: 4856 
    Data pages: 4240, average fill: 84% 
    Primary pages: 4238, secondary pages: 2, swept pages: 2 
    Empty pages: 59, full pages: 4158 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 5 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4158 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 149.22, total records: 146781 
    Average version length: 151.47, total versions: 1800, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 6, data page slots: 5312 
    Data pages: 3656, average fill: 83% 
    Primary pages: 3652, secondary pages: 4, swept pages: 1 
    Empty pages: 48, full pages: 3592 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3593 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 148.58, total records: 139095 
    Average version length: 152.60, total versions: 2380, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 3672 
    Data pages: 3464, average fill: 83% 
    Primary pages: 3462, secondary pages: 2, swept pages: 6 
    Empty pages: 41, full pages: 3408 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 7 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3408 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 127.38, total records: 163241 
    Average version length: 154.94, total versions: 27397, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.31 
    Pointer pages: 5, data page slots: 7224 
    Data pages: 4144, average fill: 84% 
    Primary pages: 4142, secondary pages: 2, swept pages: 2 
    Empty pages: 103, full pages: 4007 
    Fill distribution: 
     0 - 19% = 105 
    20 - 39% = 13 
    40 - 59% = 12 
    60 - 79% = 7 
    80 - 99% = 4007 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 137.39, total records: 159089 
    Average version length: 154.47, total versions: 15389, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.34 
    Pointer pages: 7, data page slots: 5560 
    Data pages: 4024, average fill: 83% 
    Primary pages: 4021, secondary pages: 3, swept pages: 8 
    Empty pages: 93, full pages: 3897 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 8 
    40 - 59% = 14 
    60 - 79% = 9 
    80 - 99% = 3894 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 147.05, total records: 155602 
    Average version length: 153.39, total versions: 4656, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.53 
    Pointer pages: 6, data page slots: 5104 
    Data pages: 3920, average fill: 82% 
    Primary pages: 3917, secondary pages: 3, swept pages: 6 
    Empty pages: 79, full pages: 3810 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 13 
    80 - 99% = 3809 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.49, total records: 2085419 
    Average version length: 52.96, total versions: 59693, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25480 
    Data pages: 25480, average fill: 71% 
    Primary pages: 25464, secondary pages: 16, swept pages: 10375 
    Empty pages: 100, full pages: 21825 
    Fill distribution: 
     0 - 19% = 222 
    20 - 39% = 239 
    40 - 59% = 796 
    60 - 79% = 23618 
    80 - 99% = 605 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2550, nodes: 2085419 
    Average node length: 5.44, total dup: 1945845, max dup: 1692 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181175, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 276 
        40 - 59% = 1679 
        60 - 79% = 279 
        80 - 99% = 311 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2755, nodes: 2085419 
    Average node length: 5.69, total dup: 1871819, max dup: 74 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372812, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 2464 
        60 - 79% = 257 
        80 - 99% = 24 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2094, nodes: 2085419 
    Average node length: 4.96, total dup: 2085319, max dup: 27665 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 178849, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 196 
        40 - 59% = 1092 
        60 - 79% = 360 
        80 - 99% = 446 
 
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: 38.38, total records: 143884 
    Average version length: 69.17, total versions: 73667, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.28 
    Pointer pages: 3, data page slots: 3728 
    Data pages: 3112, average fill: 57% 
    Primary pages: 3111, secondary pages: 1, swept pages: 399 
    Empty pages: 540, full pages: 1895 
    Fill distribution: 
     0 - 19% = 839 
    20 - 39% = 145 
    40 - 59% = 104 
    60 - 79% = 774 
    80 - 99% = 1250 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1553931, depth: 3, leaf buckets: 240, nodes: 143884 
    Average node length: 6.43, total dup: 125325, max dup: 14 
    Average key length: 3.94, compression ratio: 10.67 
    Average prefix length: 40.19, average data length: 1.81 
    Clustering factor: 25083, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 67 
        40 - 59% = 125 
        60 - 79% = 42 
        80 - 99% = 4 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.67, total records: 7550743 
    Average version length: 68.75, total versions: 538133, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 67, data page slots: 109104 
    Data pages: 109104, average fill: 75% 
    Primary pages: 109103, secondary pages: 1, swept pages: 9013 
    Empty pages: 15, full pages: 104046 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 337 
    40 - 59% = 1344 
    60 - 79% = 104128 
    80 - 99% = 3217 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10809, nodes: 7550743 
    Average node length: 6.51, total dup: 6531613, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1772517, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1074 
        40 - 59% = 5635 
        60 - 79% = 3410 
        80 - 99% = 684 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8521, nodes: 7550743 
    Average node length: 5.38, total dup: 7260400, max dup: 177 
    Average key length: 2.39, compression ratio: 7.11 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1556781, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 701 
        40 - 59% = 4540 
        60 - 79% = 1928 
        80 - 99% = 1349 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8567, nodes: 7550743 
    Average node length: 5.38, total dup: 7260400, max dup: 177 
    Average key length: 2.39, compression ratio: 7.11 
    Average prefix length: 16.65, average data length: 0.35 
    Clustering factor: 1559054, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 726 
        40 - 59% = 4550 
        60 - 79% = 1940 
        80 - 99% = 1343 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 67.07, total records: 12367361 
    Average version length: 68.69, total versions: 382968, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 108, data page slots: 175792 
    Data pages: 175792, average fill: 75% 
    Primary pages: 175791, secondary pages: 1, swept pages: 49452 
    Empty pages: 0, full pages: 175580 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 17 
    60 - 79% = 172397 
    80 - 99% = 3376 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18449, nodes: 12362711 
    Average node length: 6.63, total dup: 10775511, max dup: 61 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2517814, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1800 
        40 - 59% = 10523 
        60 - 79% = 5243 
        80 - 99% = 859 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 41.32, total records: 1874976 
    Average version length: 69.05, total versions: 473877, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.05 
    Pointer pages: 23, data page slots: 36632 
    Data pages: 30248, average fill: 61% 
    Primary pages: 30131, secondary pages: 117, swept pages: 3619 
    Empty pages: 1491, full pages: 25124 
    Fill distribution: 
     0 - 19% = 2682 
    20 - 39% = 4846 
    40 - 59% = 2868 
    60 - 79% = 13557 
    80 - 99% = 6295 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1877, nodes: 1481690 
    Average node length: 5.53, total dup: 1421080, max dup: 49 
    Average key length: 2.57, compression ratio: 16.36 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 103398, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 320 
        40 - 59% = 894 
        60 - 79% = 530 
        80 - 99% = 128 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 34.90, total records: 1621141 
    Average version length: 69.04, total versions: 212204, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.61 
    Pointer pages: 19, data page slots: 30136 
    Data pages: 26736, average fill: 48% 
    Primary pages: 26736, secondary pages: 0, swept pages: 3413 
    Empty pages: 3297, full pages: 16349 
    Fill distribution: 
     0 - 19% = 5263 
    20 - 39% = 3002 
    40 - 59% = 6826 
    60 - 79% = 10945 
    80 - 99% = 700 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1274, nodes: 912000 
    Average node length: 5.99, total dup: 836859, max dup: 89 
    Average key length: 3.05, compression ratio: 13.78 
    Average prefix length: 41.03, average data length: 0.97 
    Clustering factor: 140700, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 250 
        40 - 59% = 587 
        60 - 79% = 376 
        80 - 99% = 60 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.39, total records: 9064422 
    Average version length: 68.95, total versions: 672880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 88, data page slots: 142184 
    Data pages: 142176, average fill: 69% 
    Primary pages: 142161, secondary pages: 15, swept pages: 30642 
    Empty pages: 237, full pages: 79913 
    Fill distribution: 
     0 - 19% = 725 
    20 - 39% = 4193 
    40 - 59% = 19766 
    60 - 79% = 112538 
    80 - 99% = 4954 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13439, nodes: 9057098 
    Average node length: 6.68, total dup: 7511706, max dup: 21 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2048085, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1299 
        40 - 59% = 7165 
        60 - 79% = 4476 
        80 - 99% = 498 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21078854 
    Average version length: 82.95, total versions: 16842, 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: 318640 
    Data pages: 318640, average fill: 81% 
    Primary pages: 318635, secondary pages: 5, swept pages: 11633 
    Empty pages: 43, full pages: 317930 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 39 
    40 - 59% = 88 
    60 - 79% = 46840 
    80 - 99% = 271600 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19217, nodes: 21078854 
    Average node length: 5.72, total dup: 20599691, max dup: 151 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3271833, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 7933 
        60 - 79% = 530 
        80 - 99% = 10747 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17075, nodes: 21078854 
    Average node length: 6.31, total dup: 18524178, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 913460, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 3 
        40 - 59% = 717 
        60 - 79% = 262 
        80 - 99% = 16085 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 20983, nodes: 21078854 
    Average node length: 6.34, total dup: 18443700, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3565044, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1 
        40 - 59% = 8209 
        60 - 79% = 564 
        80 - 99% = 12203 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16035, nodes: 21078854 
    Average node length: 5.56, total dup: 21078754, max dup: 229071 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942293, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 10 
        40 - 59% = 2892 
        60 - 79% = 347 
        80 - 99% = 12786 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 76.84, total records: 9558367 
    Average version length: 82.59, total versions: 722725, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 102, data page slots: 166392 
    Data pages: 166368, average fill: 72% 
    Primary pages: 166340, secondary pages: 28, swept pages: 45686 
    Empty pages: 391, full pages: 101374 
    Fill distribution: 
     0 - 19% = 964 
    20 - 39% = 3893 
    40 - 59% = 19661 
    60 - 79% = 111923 
    80 - 99% = 29927 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11307, nodes: 9558367 
    Average node length: 5.35, total dup: 9252592, max dup: 178 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2182742, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 62 
        40 - 59% = 8597 
        60 - 79% = 2592 
        80 - 99% = 54 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 12904, nodes: 9558367 
    Average node length: 6.22, total dup: 7922214, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1538997, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 113 
        20 - 39% = 3516 
        40 - 59% = 3971 
        60 - 79% = 2591 
        80 - 99% = 2713 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12624, nodes: 9558367 
    Average node length: 5.97, total dup: 8297687, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2373646, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 78 
        40 - 59% = 9621 
        60 - 79% = 2861 
        80 - 99% = 63 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9740, nodes: 9558367 
    Average node length: 5.12, total dup: 9558267, max dup: 154208 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1559716, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1082 
        40 - 59% = 4603 
        60 - 79% = 1789 
        80 - 99% = 2229 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.63, total records: 11214672 
    Average version length: 82.55, total versions: 558571, max versions: 1 
    Average fragment length: 73.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 116, data page slots: 187816 
    Data pages: 186536, average fill: 74% 
    Primary pages: 186399, secondary pages: 137, swept pages: 50952 
    Empty pages: 2080, full pages: 152508 
    Fill distribution: 
     0 - 19% = 3500 
    20 - 39% = 5181 
    40 - 59% = 12049 
    60 - 79% = 92911 
    80 - 99% = 72895 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13121, nodes: 11214672 
    Average node length: 5.30, total dup: 11105416, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2354083, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 116 
        40 - 59% = 9582 
        60 - 79% = 3298 
        80 - 99% = 125 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10184, nodes: 11214672 
    Average node length: 5.49, total dup: 10723998, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 726233, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 163 
        20 - 39% = 746 
        40 - 59% = 2383 
        60 - 79% = 1718 
        80 - 99% = 5174 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15005, nodes: 11214672 
    Average node length: 6.02, total dup: 9786478, max dup: 69 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2370491, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 158 
        40 - 59% = 11095 
        60 - 79% = 3605 
        80 - 99% = 144 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10513, nodes: 11214672 
    Average node length: 5.22, total dup: 11214572, max dup: 194780 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 713445, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 86 
        20 - 39% = 779 
        40 - 59% = 4519 
        60 - 79% = 1457 
        80 - 99% = 3672 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 77.45, total records: 9637720 
    Average version length: 82.89, total versions: 689228, 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: 102, data page slots: 166440 
    Data pages: 166424, average fill: 72% 
    Primary pages: 166401, secondary pages: 23, swept pages: 44489 
    Empty pages: 272, full pages: 102800 
    Fill distribution: 
     0 - 19% = 656 
    20 - 39% = 2791 
    40 - 59% = 16986 
    60 - 79% = 118258 
    80 - 99% = 27733 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11640, nodes: 9637720 
    Average node length: 5.16, total dup: 9609021, max dup: 1735 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2012131, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1428 
        40 - 59% = 7864 
        60 - 79% = 1750 
        80 - 99% = 564 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 12994, nodes: 9637720 
    Average node length: 6.23, total dup: 7987995, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1540929, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 3509 
        40 - 59% = 3960 
        60 - 79% = 2537 
        80 - 99% = 2822 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12279, nodes: 9637720 
    Average node length: 5.42, total dup: 9205861, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2143453, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1354 
        40 - 59% = 8848 
        60 - 79% = 1516 
        80 - 99% = 536 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 9978, nodes: 9637720 
    Average node length: 5.13, total dup: 9637620, max dup: 156036 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 1604259, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1183 
        40 - 59% = 4804 
        60 - 79% = 1796 
        80 - 99% = 2148 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.21, total records: 573456 
    Average version length: 68.79, total versions: 9182, 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: 5, data page slots: 8016 
    Data pages: 8016, average fill: 75% 
    Primary pages: 8016, secondary pages: 0, swept pages: 3028 
    Empty pages: 7, full pages: 7086 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 4 
    40 - 59% = 120 
    60 - 79% = 7726 
    80 - 99% = 159 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 46989, depth: 3, leaf buckets: 720, nodes: 573456 
    Average node length: 5.94, total dup: 488469, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100805, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 490 
        60 - 79% = 96 
        80 - 99% = 104 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31992, depth: 3, leaf buckets: 745, nodes: 573456 
    Average node length: 6.15, total dup: 470467, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100855, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 28 
        40 - 59% = 508 
        60 - 79% = 98 
        80 - 99% = 109 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 569, nodes: 573456 
    Average node length: 4.86, total dup: 573356, max dup: 9760 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89577, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 334 
        60 - 79% = 67 
        80 - 99% = 129 
 
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 Mar 20 10:09:47 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7711467 136853 1 0.0000 0.0000
DOC_LIST 2229072 71370 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1755 5 400.0000 0.0000
INVNT_TURNOVER_LOG 115193 98797 1 0.0000 0.0000
MONEY_SALDO 49 142 4 200.0000 0.0000
MONEY_TURNOVER_LOG 1709 1367 1 0.0000 0.0000
PDISTR 847190 34040 2 0.0000 0.0000
PERF_SPLIT_0 164394 13132 1 0.0000 0.0000
PERF_SPLIT_1 142354 6434 1 0.0000 0.0000
PERF_SPLIT_2 132306 946 1 0.0000 0.0000
PERF_SPLIT_3 139663 1251 1 0.0000 0.0000
PERF_SPLIT_4 169256 24029 1 0.0000 0.0000
PERF_SPLIT_5 146781 1800 1 0.0000 0.0000
PERF_SPLIT_6 139095 2380 1 0.0000 0.0000
PERF_SPLIT_7 163241 27397 1 0.0000 0.0000
PERF_SPLIT_8 159089 15389 1 0.0000 0.0000
PERF_SPLIT_9 155602 4656 1 0.0000 0.0000
PSTORNED 2085419 59693 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 143884 73667 1 0.0000 0.0000
XQD_1000_3300 7550743 538133 1 0.0000 0.0000
XQD_1200_2000 12367361 382968 1 0.0000 0.0000
XQD_2000_3300 1874976 473877 1 0.0000 0.0000
XQD_2100_3300 1621141 212204 1 0.0000 0.0000
XQD_3300_3400 9064422 672880 1 0.0000 0.0000
XQS_1000_1200 21078854 16842 1 0.0000 0.0000
XQS_1000_3300 9558367 722725 1 0.0000 0.0000
XQS_1200_2000 11214672 558571 1 0.0000 0.0000
XQS_2100_3300 9637720 689228 1 0.0000 0.0000
XQS_3300_3400 573456 9182 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 ---
:159: 
:160: mscs-test-161.budzdorov.ru    Wed Mar 20 10:07:55 2024
:161:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:162: 
--- end of diff output ---

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

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