Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.04.2024 10:09
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 15536376 kB
MemAvailable 30075772 kB
Buffers 0 kB
Cached 16207220 kB
SwapCached 2760 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-04-12 10:07:52
DTS_END                         2024-04-12 10:07:52.5830
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/47774
TRN_ID                          168756
ATT_ID                          527
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: 9300.09 25634 930009
customer order: creation 173.05 412 17305
customer order: refuse 14.00 380 1400
order to supplier: creation 46.90 1410 4690
order to supplier: removal 3.80 93108 380
invoice (draft): creation 46.31 3154 4631
invoice (draft): removal 53.04 687 5304
invoice accept: apply 40.58 19036 4058
invoice accept: cancel 48.11 787 4811
customer reserve: creation 3866.73 183 386673
customer reserve: removal 4709.68 60 470968
realization accept: apply 84.15 197 8415
realization accept: cancel 84.41 116 8441
payment from customer: creation 60.70 141 6070
payment from customer: removal 5.55 91 555
payment to supplier: creation 49.45 178 4945
payment to supplier: removal 3.00 70 300
service: total inventory turnovers 3.83 3534 383
service: total monetary turnovers 6.03 579 603
service: aggregate perf. data 0.74 21487 74
service: refresh index statistics 0.03 367063 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-04-2024 10:09:31 to 12-04-2024 10:09:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2895
TEST_TIME 2 2805
TEST_TIME 3 4344
TEST_TIME 4 3893
TEST_TIME 5 3939
TEST_TIME 6 4197
TEST_TIME 7 4504
TEST_TIME 8 4573
TEST_TIME 9 4758
TEST_TIME 10 4830
TEST_TIME 11 5261
TEST_TIME 12 5316
TEST_TIME 13 5607
TEST_TIME 14 5958
TEST_TIME 15 6111
TEST_TIME 16 6677
TEST_TIME 17 7494
TEST_TIME 18 7722
TEST_TIME 19 8010
TEST_TIME 20 8686
TEST_TIME 21 8988
TEST_TIME 22 8828
TEST_TIME 23 9035
TEST_TIME 24 9250
TEST_TIME 25 9381
TEST_TIME 26 9052
TEST_TIME 27 9295
TEST_TIME 28 9692
TEST_TIME 29 9478
TEST_TIME 30 9385
TEST_TIME 31 9440
TEST_TIME 32 9345
TEST_TIME 33 9189
TEST_TIME 34 9199
TEST_TIME 35 9004
TEST_TIME 36 8963
TEST_TIME 37 8868
TEST_TIME 38 8686
TEST_TIME 39 8665
TEST_TIME 40 8618
TEST_TIME 41 8624
TEST_TIME 42 8518
TEST_TIME 43 8522
TEST_TIME 44 8703
TEST_TIME 45 8907
TEST_TIME 46 8841
TEST_TIME 47 8887
TEST_TIME 48 8922
TEST_TIME 49 8923
TEST_TIME 50 9026
TEST_TIME 51 9070
TEST_TIME 52 9025
TEST_TIME 53 9132
TEST_TIME 54 9124
TEST_TIME 55 9196
TEST_TIME 56 9310
TEST_TIME 57 9256
TEST_TIME 58 9293
TEST_TIME 59 9151
TEST_TIME 60 9144
TEST_TIME 61 9129
TEST_TIME 62 9050
TEST_TIME 63 9023
TEST_TIME 64 9084
TEST_TIME 65 9075
TEST_TIME 66 9016
TEST_TIME 67 8975
TEST_TIME 68 8937
TEST_TIME 69 8948
TEST_TIME 70 9039
TEST_TIME 71 9029
TEST_TIME 72 9064
TEST_TIME 73 9057
TEST_TIME 74 9104
TEST_TIME 75 9086
TEST_TIME 76 9106
TEST_TIME 77 9141
TEST_TIME 78 9132
TEST_TIME 79 9266
TEST_TIME 80 9265
TEST_TIME 81 9245
TEST_TIME 82 9155
TEST_TIME 83 9103
TEST_TIME 84 9085
TEST_TIME 85 9069
TEST_TIME 86 9062
TEST_TIME 87 9025
TEST_TIME 88 9079
TEST_TIME 89 9128
TEST_TIME 90 9087
TEST_TIME 91 9131
TEST_TIME 92 9175
TEST_TIME 93 9155
TEST_TIME 94 9202
TEST_TIME 95 9262
TEST_TIME 96 9239
TEST_TIME 97 9401
TEST_TIME 98 9429
TEST_TIME 99 9379
TEST_TIME 100 9303

Performance per minute, chart


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

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1286740 1286740 0 0.00 0 20518 7 0 0
doc_list_biud 1286740 1286740 0 0.00 0 45857 28 0 0
sp_add_invoice_to_stock 4132 4058 74 1.79 49 149491 19037 0 74
sp_cancel_adding_invoice 4811 4811 0 0.00 5 69067 788 0 0
sp_cancel_client_order 1400 1400 0 0.00 4 13010 380 0 0
sp_cancel_customer_reserve 470968 470968 0 0.00 0 45374 61 0 0
sp_cancel_pay_from_customer 555 555 0 0.00 2 2570 91 0 0
sp_cancel_pay_to_supplier 300 300 0 0.00 3 3671 71 0 0
sp_cancel_supplier_invoice 5312 5304 8 0.15 1 17201 687 0 8
sp_cancel_supplier_order 380 380 0 0.00 5 1021602 93108 0 0
sp_cancel_write_off 8441 8441 0 0.00 1 16885 117 0 0
sp_client_order 17305 17305 0 0.00 3 50922 412 0 0
sp_customer_reserve 386673 386673 0 0.00 0 53078 184 0 0
sp_fill_shopping_cart 26624 26624 0 0.00 1 19627 38 0 0
sp_fill_shopping_cart_clo_res 386668 386668 0 0.00 0 19197 15 0 0
sp_get_clo_for_invoice 4051 4051 0 0.00 0 19072 346 0 0
sp_kill_cost_storno 14107 14107 0 0.00 0 16807 69 0 0
sp_kill_qstorno_ret_qs2qd 956061 956061 0 0.00 0 45021 32 0 0
sp_kill_qty_storno 503770 503770 0 0.00 0 45857 70 0 0
sp_lock_selected_doc 17214 17214 0 0.00 0 10334 7 0 0
sp_make_cost_storno 23481 23481 0 0.00 0 11809 74 0 0
sp_multiply_rows_for_pdistr 23481 23481 0 0.00 0 16949 36 0 0
sp_multiply_rows_for_qdistr 17305 17305 0 0.00 0 50912 210 0 0
sp_pay_from_customer 6070 6070 0 0.00 4 23138 142 0 0
sp_pay_to_supplier 4945 4945 0 0.00 4 20521 178 0 0
sp_payment_common 11015 11015 0 0.00 1 15796 35 0 0
sp_qd_handle_on_cancel_clo 1400 1400 0 0.00 0 13005 344 0 0
sp_qd_handle_on_invoice_upd_sts 8862 8862 0 0.00 0 45857 318 0 0
sp_qd_handle_on_reserve_upd_sts 8415 8415 0 0.00 0 13400 55 0 0
sp_reserve_write_off 8415 8415 0 0.00 6 22160 198 0 0
sp_supplier_invoice 4631 4631 0 0.00 6 83368 3154 0 0
sp_supplier_order 4690 4690 0 0.00 4 48770 1410 0 0
srv_aggregate_perf_data 74 74 0 0.00 1886 275933 21487 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 2615 124066 40085 0 0
srv_find_qd_qs_mism 889322 889322 0 0.00 0 16863 6 0 0
srv_make_invnt_saldo 383 383 0 0.00 40 117627 3535 0 0
srv_make_money_saldo 603 603 0 0.00 1 16284 579 0 0
srv_recalc_idx_stat 3 3 0 0.00 283310 454619 367063 0 0
t$perf-abend:sp_add_invoice_to_stock 74 74 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4058 4058 0 0.00 0 14141 180 0 0
t$perf-norm:sp_cancel_adding_invoice 326 326 0 0.00 0 4725 112 0 0
t$perf-norm:sp_cancel_client_order 1400 1400 0 0.00 0 3197 16 0 0
t$perf-norm:sp_cancel_customer_reserve 608 608 0 0.00 0 9533 32 0 0
t$perf-norm:sp_cancel_pay_from_customer 555 555 0 0.00 0 6040 31 0 0
t$perf-norm:sp_cancel_pay_to_supplier 300 300 0 0.00 0 1598 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 318 318 0 0.00 0 783 15 0 0
t$perf-norm:sp_cancel_supplier_order 380 380 0 0.00 0 26871 1609 0 0
t$perf-norm:sp_cancel_write_off 861 861 0 0.00 0 1906 8 0 0
t$perf-norm:sp_client_order 17305 17305 0 0.00 0 7292 16 0 0
t$perf-norm:sp_customer_reserve 781 781 0 0.00 0 1222 7 0 0
t$perf-norm:sp_pay_from_customer 6070 6070 0 0.00 0 3595 6 0 0
t$perf-norm:sp_pay_to_supplier 4945 4945 0 0.00 0 9252 10 0 0
t$perf-norm:sp_reserve_write_off 8415 8415 0 0.00 0 3713 8 0 0
t$perf-norm:sp_supplier_invoice 4631 4631 0 0.00 0 5817 16 0 0
t$perf-norm:sp_supplier_order 4690 4690 0 0.00 0 6935 15 0 0
t$perf-norm:srv_aggregate_perf_data 74 74 0 0.00 0 152 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 96 4 0 0
t$perf-norm:srv_make_invnt_saldo 383 383 0 0.00 0 978 7 0 0
t$perf-norm:srv_make_money_saldo 603 603 0 0.00 0 5371 13 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 14 6 0 0
v_add_invoice_to_stock 8248 8100 148 1.79 0 8746 18 0 148
v_all_customers 32440 32440 0 0.00 0 16 1 0 0
v_all_suppliers 26558 26558 0 0.00 0 23 1 0 0
v_all_wares 34610 34610 0 0.00 0 85 1 0 0
v_cancel_adding_invoice 652 652 0 0.00 0 7847 23 0 0
v_cancel_client_order 2800 2800 0 0.00 0 2871 5 0 0
v_cancel_customer_prepayment 1110 1110 0 0.00 0 546 4 0 0
v_cancel_customer_reserve 1216 1216 0 0.00 0 2020 7 0 0
v_cancel_payment_to_supplier 600 600 0 0.00 0 1497 7 0 0
v_cancel_supplier_invoice 652 636 16 2.45 0 2283 20 0 16
v_cancel_supplier_order 760 760 0 0.00 0 3321 13 0 0
v_cancel_write_off 1722 1722 0 0.00 0 7152 16 0 0
v_max_id_clo_ord 4690 4690 0 0.00 0 1626 2 0 0
v_max_id_clo_res 781 781 0 0.00 0 9179 26 0 0
v_max_id_ord_sup 4629 4629 0 0.00 0 3476 4 0 0
v_max_non_paid_invoice 985 985 0 0.00 0 1099 4 0 0
v_max_non_paid_realizn 2839 2839 0 0.00 0 6338 7 0 0
v_min_id_clo_ord 4690 4690 0 0.00 0 8203 16 0 0
v_min_id_clo_res 781 781 0 0.00 0 4369 13 0 0
v_min_id_ord_sup 4629 4629 0 0.00 0 9885 7 0 0
v_min_non_paid_invoice 4945 4945 0 0.00 0 10611 29 0 0
v_min_non_paid_realizn 6070 6070 0 0.00 0 11472 28 0 0
v_our_firm 8632 8632 0 0.00 0 16 1 0 0
v_reserve_write_off 16830 16830 0 0.00 0 7544 7 0 0
x_lock_depdocs_on_canc_invoice 9797 9797 0 0.00 0 12820 108 0 0
x_lock_depdocs_on_canc_sup_ord 380 380 0 0.00 0 5321 301 0 0
x_make_qstorno_1000_1200 4690 4690 0 0.00 2 48643 1326 0 0
x_make_qstorno_1200_2000 4631 4631 0 0.00 3 81399 3026 0 0
x_make_qstorno_2100_3300 386673 386673 0 0.00 0 53076 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-04-2024 10:09:39 to 12-04-2024 10:09:43.

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:56 2 8192000000 8796662832 8807108608 3180608 0.038 1 1 2 0 3278224 61840 35776
08:08:57 36924 8192000000 9711513392 10009518080 780472496 8.698 100 90 180 0 809522656 7479184 21570976
08:10:36 17980 8192000000 9762272592 10068602880 826842768 9.167 100 90 180 0 858215248 10566464 20806016
08:12:00 18179 8192000000 9784208416 10100518912 854800048 9.448 100 90 180 0 893812704 18492576 20520080
08:13:22 12725 8192000000 9829362624 10158022656 887810016 9.777 100 83 166 0 946472096 41032256 17629824
08:14:39 5709 8192000000 9887624576 10225680384 933300688 10.227 100 84 167 0 998976112 47831856 17843568
08:15:47 4470 8192000000 9945911088 10296610816 965694640 10.545 100 89 176 0 1054624880 71088448 17841792
08:16:53 2132 8192000000 9952004976 10309042176 994071376 10.821 100 87 174 0 1067815200 56600384 17143440
08:17:58 2250 8192000000 10005464720 10369294336 1016734864 11.040 100 90 178 1 1114443856 80787280 16921712
08:19:03 5953 8192000000 10002694496 10376273920 1034955904 11.216 100 80 160 0 1130394640 79947216 15491520
08:20:11 1253 8192000000 10057788320 10428923904 1058050448 11.438 100 94 187 0 1157905248 81136704 18718096
08:21:14 21330 8192000000 10031802848 10411831296 1062792112 11.483 100 82 162 1 1140457632 61212176 16453344
08:22:37 4449 8192000000 9988925104 10378747904 1066096448 11.515 100 50 102 0 1098850384 22855600 9898336
08:23:45 10498 8192000000 9989865424 10386059264 1073265936 11.583 100 22 44 0 1097909056 20051680 4591440
08:24:58 7774 8192000000 9989609008 10391523328 1086007504 11.705 100 36 68 1 1117562080 24452064 7102512
08:26:07 36415 8192000000 10001865808 10398130176 1084848160 11.694 100 44 88 0 1105015808 11304576 8863072
08:27:44 6033 8192000000 10012965344 10417655808 1077639872 11.625 99 44 89 2 1117593360 30610096 9343392
08:28:58 14412 8192000000 10051585968 10451378176 1099049952 11.829 100 58 116 0 1161935008 50964064 11920992
08:30:19 23495 8192000000 10077090848 10493448192 1112320224 11.954 100 46 90 1 1213156816 91316880 9519712
08:31:53 27223 8192000000 10076267120 10489647104 1086259264 11.707 98 28 54 1 1169124368 77176000 5689104
08:33:31 28237 8192000000 10109421504 10519744512 1093385760 11.775 98 39 78 1 1228783664 126907552 8490352
08:35:03 10875 8192000000 10157906336 10565664768 1129007040 12.112 100 52 102 0 1264522064 124755136 10759888
08:36:21 7339 8192000000 10197429056 10597060608 1121675008 12.043 100 56 113 0 1302692336 169121360 11895968
08:37:32 30214 8192000000 10225067488 10645303296 1122456336 12.050 100 51 100 0 1326673136 193548400 10668400
08:39:19 3721 8192000000 10230989520 10627559424 1118378240 12.012 100 62 123 0 1334625792 203210288 13037264
08:40:27 3839 8192000000 10266693056 10666225664 1120875088 12.035 99 64 123 0 1373930384 240266864 12788432
08:41:42 8699 8192000000 10253496144 10654179328 1073938640 11.590 99 54 108 0 1353137472 266832976 12365856
08:43:01 3229 8192000000 10283527296 10694000640 1090385696 11.746 100 54 108 0 1395535856 293044992 12105168
08:44:10 2615 8192000000 10243943600 10663186432 1086554592 11.710 99 87 174 1 1346262064 240658256 19049216
08:45:20 11036 8192000000 10237747328 10660958208 1082054960 11.667 99 27 54 1 1337680496 248798656 6826880
08:46:46 2823 8192000000 10240428528 10681462784 1090103520 11.744 100 80 160 1 1329922608 221504880 18314208
08:47:53 4749 8192000000 10173403760 10616496128 1106442976 11.899 100 57 110 0 1287190016 168995984 11751056
08:49:01 12790 8192000000 10173955824 10590519296 1114804720 11.978 100 28 54 0 1270340512 149361984 6173808
08:50:16 21737 8192000000 10210298928 10635599872 1117345056 12.002 99 24 49 0 1302316160 179581760 5389344
08:51:41 15532 8192000000 10195314320 10627448832 1129091568 12.113 100 22 42 1 1287938192 153774960 5071664
08:53:16 30086 8192000000 10179497280 10594766848 1134998176 12.168 100 65 125 1 1271548864 123431472 13119216
08:54:49 21956 8192000000 10127791616 10637033472 1121202512 12.038 100 11 22 0 1232416512 108596608 2617392
08:56:13 29173 8192000000 10069500464 10501173248 1128500784 12.107 100 18 35 1 1167825184 36154448 3169952
08:57:44 116168 8192000000 10057004304 10530435072 1120934608 12.036 99 11 22 0 1164816368 41596352 2285408
09:00:41 49256 8192000000 10083456368 10525249536 1124786224 12.072 99 44 85 0 1180122656 46977888 8358544
09:03:29 66134 8192000000 10097077968 10548076544 1140231888 12.218 100 12 24 0 1185690992 43045424 2413680
09:05:37 16496 8192000000 10128880880 10557419520 1159708496 12.401 100 56 112 0 1234204368 62903776 11592096
09:07:00 35065 8192000000 10210461280 10658275328 1165530016 12.455 100 29 58 0 1291134224 119030992 6573216
09:08:54 53470 8192000000 10226227600 10688761856 1146756720 12.279 98 24 48 0 1309914496 157838688 5319088
09:10:48 79313 8192000000 10150547520 10708213760 1141896608 12.233 99 19 38 0 1303873840 157563008 4414224
09:13:37 36408 8192000000 10116230848 10570178560 1155823440 12.364 100 22 45 0 1204659872 44826208 4010224
09:15:55 16345 8192000000 10116799216 10550972416 1149807856 12.308 99 60 112 1 1207100656 45187216 12105584
09:17:15 52303 8192000000 10101644016 10587885568 1155875472 12.365 100 8 16 0 1224179920 66891424 1413024
09:19:07 33637 8192000000 10096508112 10538545152 1146670064 12.278 99 19 38 0 1208285328 58381376 3233888
09:20:42 72872 8192000000 10075686944 10519150592 1067469472 11.528 92 15 30 0 1108574560 38666688 2438400
09:22:59 81405 8192000000 10061013584 10499895296 1104856336 11.884 97 19 38 1 1151930480 43544736 3529408
09:25:24 106659 8192000000 10061274912 10527727616 1122141152 12.047 100 26 52 1 1159014368 30526224 6346992
09:28:31 55286 8192000000 10059742576 10514776064 1082478704 11.671 97 38 76 0 1157573792 67252272 7842816
09:30:36 45587 8192000000 10066356528 10529906688 1083233008 11.678 99 27 55 0 1173194784 84442960 5518816
09:32:29 51466 8192000000 10027168144 10482327552 1064204832 11.497 97 13 26 0 1112801344 45801376 2795136
09:34:22 60779 8192000000 10025821312 10495844352 1087120480 11.715 100 12 24 0 1163809280 73635136 3053664
09:36:40 84117 8192000000 10014097696 10509479936 1035271440 11.219 96 11 22 0 1094829312 57169344 2388528
09:39:06 41986 8192000000 10024538096 10462248960 1030759808 11.176 96 22 44 0 1092576400 57374848 4441744
09:40:48 31155 8192000000 10050407472 10495520768 1071782432 11.569 99 46 90 0 1115859744 35469168 8608144
09:42:21 46609 8192000000 10054167936 10474700800 1081363680 11.660 99 26 52 0 1144735392 58370864 5000848
09:44:14 46423 8192000000 10037629664 10466455552 1079074016 11.639 99 33 63 0 1121234528 36027984 6132528
09:46:03 43697 8192000000 10047253088 10532626432 1106842016 11.903 100 13 26 0 1191573568 82185040 2546512
09:47:49 124066 8192000000 10047215360 10477457408 1116198096 11.991 100 20 40 0 1165921776 45209088 4514592
09:50:53 14009 8192000000 10071370112 10520641536 1125561408 12.079 100 13 26 1 1178966368 51061568 2343392
09:52:10 63748 8192000000 10065170608 10559635456 1118096640 12.009 99 16 32 0 1205929568 84913744 2919184
09:55:08 58879 8192000000 10083564400 10592518144 1119667360 12.024 99 28 56 0 1219261776 93156000 6438416
09:57:09 51103 8192000000 10095214560 10525728768 1127508784 12.098 99 26 52 0 1182705056 50527552 4668720
09:59:02 76837 8192000000 10105157424 10590826496 1109721808 11.930 98 12 24 0 1170068400 58232528 2114064
10:01:26 14015 8192000000 10071184352 10487730176 1124300496 12.068 100 39 79 0 1163769168 31458160 8010512
10:02:40 49900 8192000000 10110896144 10562805760 1134692960 12.166 100 19 38 0 1201044608 62484864 3866784
10:04:32 47821 8192000000 10111086832 10640408576 1130740688 12.128 100 8 16 0 1206156432 73826608 1589136
10:06:20 67855 8192000000 10069087200 10503016448 1123325376 12.058 98 27 55 1 1144353040 16033680 4993984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 12-04-2024 10:09:45 to 12-04-2024 10:09:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 74 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          167176
MON$OLDEST_ACTIVE               168946
MON$OLDEST_SNAPSHOT             168946
MON$NEXT_TRANSACTION            168946
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                       1910944
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             674
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Fri Apr 12 10:10:03 2024 
 
Database header page information: 
    Flags            0 
    Generation        88309 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    167176 
    Oldest active        168946 
    Oldest snapshot        168946 
    Next transaction    168947 
    Sequence number        0 
    Next attachment ID    674 
    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.57, total records: 7617493 
    Average version length: 48.16, total versions: 62055, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 88048 
    Data pages: 88048, average fill: 69% 
    Primary pages: 88047, secondary pages: 1, swept pages: 45474 
    Empty pages: 5, full pages: 57409 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 298 
    40 - 59% = 2126 
    60 - 79% = 85531 
    80 - 99% = 32 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 22964, nodes: 7617493 
    Average node length: 18.83, total dup: 0, max dup: 0 
    Average key length: 15.84, compression ratio: 1.70 
    Average prefix length: 14.16, average data length: 12.84 
    Clustering factor: 1638827, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 305 
        20 - 39% = 2119 
        40 - 59% = 3743 
        60 - 79% = 2685 
        80 - 99% = 14112 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13351, nodes: 7617493 
    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: 1462807, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1704 
        40 - 59% = 1808 
        60 - 79% = 1277 
        80 - 99% = 8561 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8226, nodes: 7617493 
    Average node length: 6.58, total dup: 5739781, max dup: 49 
    Average key length: 3.60, compression ratio: 2.50 
    Average prefix length: 7.65, average data length: 1.35 
    Clustering factor: 1455835, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 1086 
        40 - 59% = 1191 
        60 - 79% = 1078 
        80 - 99% = 4740 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.65, total records: 2168355 
    Average version length: 58.87, total versions: 32860, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28400 
    Data pages: 28400, average fill: 70% 
    Primary pages: 28398, secondary pages: 2, swept pages: 14793 
    Empty pages: 8, full pages: 12994 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 89 
    40 - 59% = 1911 
    60 - 79% = 26323 
    80 - 99% = 60 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4443, nodes: 2168355 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 656873, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 925 
        40 - 59% = 787 
        60 - 79% = 790 
        80 - 99% = 1941 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2397, nodes: 2169039 
    Average node length: 4.97, total dup: 2168140, max dup: 18102 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1236858, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 249 
        40 - 59% = 1411 
        60 - 79% = 527 
        80 - 99% = 208 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1756, nodes: 2168355 
    Average node length: 4.97, total dup: 2168305, max dup: 130068 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1042412, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 583 
        60 - 79% = 63 
        80 - 99% = 1089 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4262, nodes: 2168355 
    Average node length: 11.42, total dup: 0, max dup: 0 
    Average key length: 8.46, compression ratio: 1.06 
    Average prefix length: 3.54, average data length: 5.46 
    Clustering factor: 656873, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 620 
        40 - 59% = 576 
        60 - 79% = 887 
        80 - 99% = 2077 
 
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.20, total records: 400 
    Average version length: 24.22, total versions: 2251, max versions: 7 
    Average fragment length: 2.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 69% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 0, full pages: 14 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 3 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 16 
 
    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: 9.93, total records: 112514 
    Average version length: 68.30, total versions: 110757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 8.87 
    Pointer pages: 7, data page slots: 2440 
    Data pages: 2232, average fill: 69% 
    Primary pages: 2231, secondary pages: 1, swept pages: 219 
    Empty pages: 230, full pages: 1317 
    Fill distribution: 
     0 - 19% = 279 
    20 - 39% = 181 
    40 - 59% = 248 
    60 - 79% = 305 
    80 - 99% = 1219 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1690978, depth: 3, leaf buckets: 379, nodes: 112514 
    Average node length: 13.16, total dup: 9407, max dup: 2 
    Average key length: 10.56, compression ratio: 2.56 
    Average prefix length: 19.35, average data length: 7.65 
    Clustering factor: 80609, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 57 
        40 - 59% = 283 
        60 - 79% = 39 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 214, max versions: 7 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 44% 
    Primary pages: 1, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 9.95, total records: 1732 
    Average version length: 43.61, total versions: 1683, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 5.83 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 59% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 4, full pages: 15 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 15 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94310, depth: 2, leaf buckets: 3, nodes: 1732 
    Average node length: 4.42, total dup: 1634, max dup: 206 
    Average key length: 2.61, compression ratio: 7.28 
    Average prefix length: 18.45, average data length: 0.55 
    Clustering factor: 924, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.78, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 36.98, total records: 836096 
    Average version length: 37.95, total versions: 17524, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8936 
    Data pages: 8936, average fill: 64% 
    Primary pages: 8935, secondary pages: 1, swept pages: 4411 
    Empty pages: 12, full pages: 4111 
    Fill distribution: 
     0 - 19% = 22 
    20 - 39% = 40 
    40 - 59% = 1010 
    60 - 79% = 7836 
    80 - 99% = 28 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 912, nodes: 828026 
    Average node length: 4.89, total dup: 827977, max dup: 156484 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91366, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 160 
        40 - 59% = 489 
        60 - 79% = 168 
        80 - 99% = 94 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 975, nodes: 828026 
    Average node length: 5.90, total dup: 737151, max dup: 43 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163100, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 590 
        60 - 79% = 64 
        80 - 99% = 293 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1032, nodes: 828026 
    Average node length: 5.90, total dup: 737151, max dup: 43 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164959, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 79 
        40 - 59% = 643 
        60 - 79% = 62 
        80 - 99% = 248 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1165, nodes: 828026 
    Average node length: 5.98, total dup: 737151, max dup: 43 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156982, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 199 
        40 - 59% = 670 
        60 - 79% = 219 
        80 - 99% = 75 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5424 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.34, total fragments: 38, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 136 
    Data pages: 112, average fill: 48% 
    Primary pages: 98, secondary pages: 14, swept pages: 65 
    Empty pages: 27, full pages: 69 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5424 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.02 
    Average prefix length: 34.38, average data length: 1.55 
    Clustering factor: 5073, ratio: 0.94 
    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: 5424 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 158, 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.06, total records: 76678 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 800 
    Data pages: 800, average fill: 66% 
    Primary pages: 800, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 796 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 796 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38178, depth: 2, leaf buckets: 97, nodes: 76678 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 2894, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 96 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 110.56, 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.29 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.56, total records: 162327 
    Average version length: 151.29, total versions: 1983, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 6, data page slots: 4696 
    Data pages: 4032, average fill: 83% 
    Primary pages: 4030, secondary pages: 2, swept pages: 6 
    Empty pages: 39, full pages: 3979 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 1 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 3979 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.29, total records: 128349 
    Average version length: 143.16, total versions: 695, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 7, data page slots: 3616 
    Data pages: 3184, average fill: 83% 
    Primary pages: 3181, secondary pages: 3, swept pages: 4 
    Empty pages: 29, full pages: 3144 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 3146 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 150.58, total records: 149334 
    Average version length: 144.95, total versions: 697, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.26 
    Pointer pages: 7, data page slots: 5408 
    Data pages: 3720, average fill: 83% 
    Primary pages: 3718, secondary pages: 2, swept pages: 5 
    Empty pages: 40, full pages: 3662 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 3660 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 147.70, total records: 148561 
    Average version length: 152.86, total versions: 3475, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 8, data page slots: 6056 
    Data pages: 3696, average fill: 83% 
    Primary pages: 3693, secondary pages: 3, swept pages: 3 
    Empty pages: 40, full pages: 3639 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 5 
    80 - 99% = 3638 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 150.47, total records: 147001 
    Average version length: 145.18, total versions: 699, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 6, data page slots: 4208 
    Data pages: 3648, average fill: 83% 
    Primary pages: 3646, secondary pages: 2, swept pages: 3 
    Empty pages: 30, full pages: 3605 
    Fill distribution: 
     0 - 19% = 35 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3605 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 150.01, total records: 150794 
    Average version length: 149.96, total versions: 1195, 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: 5320 
    Data pages: 3736, average fill: 83% 
    Primary pages: 3734, secondary pages: 2, swept pages: 5 
    Empty pages: 28, full pages: 3699 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3698 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 149.31, total records: 150714 
    Average version length: 152.10, total versions: 1832, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 7, data page slots: 4232 
    Data pages: 3752, average fill: 83% 
    Primary pages: 3749, secondary pages: 3, swept pages: 2 
    Empty pages: 48, full pages: 3694 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 6 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3695 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 149.85, total records: 141649 
    Average version length: 149.68, total versions: 1236, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 7, data page slots: 4960 
    Data pages: 3520, average fill: 83% 
    Primary pages: 3518, secondary pages: 2, swept pages: 5 
    Empty pages: 36, full pages: 3471 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3472 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 150.03, total records: 145364 
    Average version length: 150.50, total versions: 1130, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.30 
    Pointer pages: 6, data page slots: 5104 
    Data pages: 3584, average fill: 84% 
    Primary pages: 3582, secondary pages: 2, swept pages: 2 
    Empty pages: 11, full pages: 3568 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3567 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 148.26, total records: 150758 
    Average version length: 152.09, total versions: 3048, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 5672 
    Data pages: 3792, average fill: 82% 
    Primary pages: 3789, secondary pages: 3, swept pages: 3 
    Empty pages: 79, full pages: 3693 
    Fill distribution: 
     0 - 19% = 80 
    20 - 39% = 7 
    40 - 59% = 8 
    60 - 79% = 3 
    80 - 99% = 3694 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.10, total records: 2045947 
    Average version length: 52.94, total versions: 29863, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25432 
    Data pages: 25424, average fill: 69% 
    Primary pages: 25408, secondary pages: 16, swept pages: 12315 
    Empty pages: 198, full pages: 20817 
    Fill distribution: 
     0 - 19% = 413 
    20 - 39% = 385 
    40 - 59% = 1118 
    60 - 79% = 23223 
    80 - 99% = 285 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2546, nodes: 2045947 
    Average node length: 5.45, total dup: 1907593, max dup: 1653 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 179507, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 326 
        40 - 59% = 1645 
        60 - 79% = 267 
        80 - 99% = 299 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2756, nodes: 2045947 
    Average node length: 5.70, total dup: 1835486, max dup: 62 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 367849, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2556 
        60 - 79% = 174 
        80 - 99% = 18 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2056, nodes: 2045947 
    Average node length: 4.96, total dup: 2045847, max dup: 27772 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177325, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 206 
        40 - 59% = 1050 
        60 - 79% = 326 
        80 - 99% = 473 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 49.87, total records: 119118 
    Average version length: 69.17, total versions: 38297, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.53 
    Pointer pages: 3, data page slots: 4328 
    Data pages: 3184, average fill: 45% 
    Primary pages: 3184, secondary pages: 0, swept pages: 771 
    Empty pages: 565, full pages: 482 
    Fill distribution: 
     0 - 19% = 809 
    20 - 39% = 334 
    40 - 59% = 805 
    60 - 79% = 1099 
    80 - 99% = 137 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1555154, depth: 3, leaf buckets: 231, nodes: 119118 
    Average node length: 6.56, total dup: 103474, max dup: 14 
    Average key length: 4.00, compression ratio: 10.50 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 21163, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 106 
        40 - 59% = 105 
        60 - 79% = 16 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.85, total records: 7300796 
    Average version length: 68.72, total versions: 132804, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 69, data page slots: 112520 
    Data pages: 112520, average fill: 69% 
    Primary pages: 112519, secondary pages: 1, swept pages: 73682 
    Empty pages: 7, full pages: 43228 
    Fill distribution: 
     0 - 19% = 95 
    20 - 39% = 665 
    40 - 59% = 10242 
    60 - 79% = 101077 
    80 - 99% = 441 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10952, nodes: 7300796 
    Average node length: 6.51, total dup: 6316241, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1702059, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 1474 
        40 - 59% = 6084 
        60 - 79% = 2877 
        80 - 99% = 502 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 9016, nodes: 7300796 
    Average node length: 5.39, total dup: 7015356, max dup: 144 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1499320, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1185 
        40 - 59% = 5504 
        60 - 79% = 1481 
        80 - 99% = 839 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 9079, nodes: 7300796 
    Average node length: 5.39, total dup: 7015356, max dup: 144 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1501658, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1276 
        40 - 59% = 5457 
        60 - 79% = 1511 
        80 - 99% = 829 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.27, total records: 12332538 
    Average version length: 68.67, total versions: 137761, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 111, data page slots: 180864 
    Data pages: 180864, average fill: 72% 
    Primary pages: 180863, secondary pages: 1, swept pages: 111733 
    Empty pages: 6, full pages: 128775 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 547 
    40 - 59% = 6778 
    60 - 79% = 172734 
    80 - 99% = 768 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18588, nodes: 12331341 
    Average node length: 6.64, total dup: 10750116, max dup: 55 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2480899, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1886 
        40 - 59% = 10870 
        60 - 79% = 4991 
        80 - 99% = 819 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 57.16, total records: 1272585 
    Average version length: 69.00, total versions: 139118, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.20 
    Pointer pages: 26, data page slots: 41112 
    Data pages: 29704, average fill: 45% 
    Primary pages: 29617, secondary pages: 87, swept pages: 15670 
    Empty pages: 5390, full pages: 11919 
    Fill distribution: 
     0 - 19% = 8324 
    20 - 39% = 4629 
    40 - 59% = 3333 
    60 - 79% = 11855 
    80 - 99% = 1563 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1803, nodes: 1158072 
    Average node length: 5.54, total dup: 1111123, max dup: 49 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 82090, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 743 
        40 - 59% = 786 
        60 - 79% = 261 
        80 - 99% = 8 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 60.73, total records: 726259 
    Average version length: 69.04, total versions: 37286, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.07 
    Pointer pages: 23, data page slots: 35984 
    Data pages: 29352, average fill: 27% 
    Primary pages: 29352, secondary pages: 0, swept pages: 19518 
    Empty pages: 6724, full pages: 281 
    Fill distribution: 
     0 - 19% = 11932 
    20 - 39% = 8083 
    40 - 59% = 7385 
    60 - 79% = 1949 
    80 - 99% = 3 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1207, nodes: 663376 
    Average node length: 5.97, total dup: 611123, max dup: 49 
    Average key length: 3.03, compression ratio: 13.84 
    Average prefix length: 41.04, average data length: 0.96 
    Clustering factor: 94864, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 629 
        40 - 59% = 497 
        60 - 79% = 75 
        80 - 99% = 4 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 66.03, total records: 8683707 
    Average version length: 68.76, total versions: 411566, max versions: 1 
    Average fragment length: 60.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 87, data page slots: 140512 
    Data pages: 140504, average fill: 67% 
    Primary pages: 140487, secondary pages: 17, swept pages: 80573 
    Empty pages: 330, full pages: 50260 
    Fill distribution: 
     0 - 19% = 821 
    20 - 39% = 3644 
    40 - 59% = 26926 
    60 - 79% = 105611 
    80 - 99% = 3502 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13386, nodes: 8679048 
    Average node length: 6.67, total dup: 7199686, max dup: 19 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1940711, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1792 
        40 - 59% = 7397 
        60 - 79% = 3878 
        80 - 99% = 318 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.44, total records: 21126198 
    Average version length: 82.99, total versions: 27625, 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: 319176 
    Data pages: 319176, average fill: 81% 
    Primary pages: 319170, secondary pages: 6, swept pages: 9888 
    Empty pages: 0, full pages: 319173 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 46742 
    80 - 99% = 272431 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19585, nodes: 21126198 
    Average node length: 5.72, total dup: 20645956, max dup: 170 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280456, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 0 
        40 - 59% = 8631 
        60 - 79% = 529 
        80 - 99% = 10419 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17109, nodes: 21126198 
    Average node length: 6.31, total dup: 18566798, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915535, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 2 
        40 - 59% = 717 
        60 - 79% = 267 
        80 - 99% = 16120 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21364, nodes: 21126198 
    Average node length: 6.35, total dup: 18485395, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573859, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 0 
        40 - 59% = 8870 
        60 - 79% = 598 
        80 - 99% = 11885 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 15972, nodes: 21126198 
    Average node length: 5.56, total dup: 21126098, max dup: 230044 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944358, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 2705 
        60 - 79% = 351 
        80 - 99% = 12911 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 74.98, total records: 9701362 
    Average version length: 82.60, total versions: 980668, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.68 
    Pointer pages: 102, data page slots: 165304 
    Data pages: 165280, average fill: 74% 
    Primary pages: 165251, secondary pages: 29, swept pages: 31422 
    Empty pages: 533, full pages: 126423 
    Fill distribution: 
     0 - 19% = 1332 
    20 - 39% = 4019 
    40 - 59% = 15861 
    60 - 79% = 102930 
    80 - 99% = 41138 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11288, nodes: 9701362 
    Average node length: 5.35, total dup: 9396480, max dup: 261 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2155008, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 48 
        40 - 59% = 8137 
        60 - 79% = 3032 
        80 - 99% = 70 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13189, nodes: 9701362 
    Average node length: 6.22, total dup: 8045212, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1515079, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 128 
        20 - 39% = 3319 
        40 - 59% = 4561 
        60 - 79% = 2652 
        80 - 99% = 2529 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12600, nodes: 9701362 
    Average node length: 5.96, total dup: 8434462, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2358771, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 52 
        40 - 59% = 9248 
        60 - 79% = 3211 
        80 - 99% = 87 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 9847, nodes: 9701362 
    Average node length: 5.12, total dup: 9701262, max dup: 155373 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1525502, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 44 
        20 - 39% = 1091 
        40 - 59% = 4644 
        60 - 79% = 1784 
        80 - 99% = 2284 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 77.17, total records: 11262056 
    Average version length: 82.52, total versions: 785358, 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: 117, data page slots: 189984 
    Data pages: 188632, average fill: 74% 
    Primary pages: 188483, secondary pages: 149, swept pages: 46882 
    Empty pages: 2399, full pages: 153660 
    Fill distribution: 
     0 - 19% = 3888 
    20 - 39% = 5779 
    40 - 59% = 13149 
    60 - 79% = 91649 
    80 - 99% = 74167 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13097, nodes: 11262056 
    Average node length: 5.29, total dup: 11152860, max dup: 652 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2361708, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 130 
        40 - 59% = 9367 
        60 - 79% = 3503 
        80 - 99% = 95 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10245, nodes: 11262056 
    Average node length: 5.48, total dup: 10770472, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 726135, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 129 
        20 - 39% = 769 
        40 - 59% = 2481 
        60 - 79% = 1788 
        80 - 99% = 5078 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14978, nodes: 11262056 
    Average node length: 6.01, total dup: 9834647, max dup: 82 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2378155, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 159 
        40 - 59% = 10923 
        60 - 79% = 3784 
        80 - 99% = 109 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10582, nodes: 11262056 
    Average node length: 5.21, total dup: 11261956, max dup: 185642 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 713712, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 746 
        40 - 59% = 4639 
        60 - 79% = 1513 
        80 - 99% = 3596 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 75.38, total records: 9809848 
    Average version length: 82.90, total versions: 978194, max versions: 1 
    Average fragment length: 73.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 126.00, compression ratio: 1.67 
    Pointer pages: 104, data page slots: 169288 
    Data pages: 169248, average fill: 73% 
    Primary pages: 169217, secondary pages: 31, swept pages: 34697 
    Empty pages: 644, full pages: 122948 
    Fill distribution: 
     0 - 19% = 1525 
    20 - 39% = 4342 
    40 - 59% = 18225 
    60 - 79% = 105360 
    80 - 99% = 39796 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11674, nodes: 9809848 
    Average node length: 5.17, total dup: 9780992, max dup: 1883 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1987363, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1373 
        40 - 59% = 7659 
        60 - 79% = 2010 
        80 - 99% = 607 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13336, nodes: 9809848 
    Average node length: 6.24, total dup: 8133945, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1484996, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 3359 
        40 - 59% = 4524 
        60 - 79% = 2613 
        80 - 99% = 2674 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12293, nodes: 9809848 
    Average node length: 5.43, total dup: 9375480, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2120802, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 1352 
        40 - 59% = 8550 
        60 - 79% = 1761 
        80 - 99% = 611 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10015, nodes: 9809848 
    Average node length: 5.14, total dup: 9809748, max dup: 155264 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1549099, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1121 
        40 - 59% = 4779 
        60 - 79% = 1742 
        80 - 99% = 2327 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.74, total records: 578132 
    Average version length: 68.81, total versions: 13960, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8024 
    Data pages: 8024, average fill: 76% 
    Primary pages: 8024, secondary pages: 0, swept pages: 2257 
    Empty pages: 7, full pages: 7776 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 5 
    40 - 59% = 54 
    60 - 79% = 7735 
    80 - 99% = 221 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40205, depth: 3, leaf buckets: 728, nodes: 578132 
    Average node length: 5.95, total dup: 492272, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101844, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 506 
        60 - 79% = 87 
        80 - 99% = 105 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31149, depth: 3, leaf buckets: 753, nodes: 578132 
    Average node length: 6.15, total dup: 474206, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101896, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 27 
        40 - 59% = 531 
        60 - 79% = 89 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 556, nodes: 578132 
    Average node length: 4.86, total dup: 578032, max dup: 9448 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 90507, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 310 
        60 - 79% = 75 
        80 - 99% = 139 
 
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 Fri Apr 12 10:10:27 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7617493 62055 1 0.0000 0.0000
DOC_LIST 2168355 32860 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2251 7 500.0000 0.0000
INVNT_TURNOVER_LOG 112514 110757 1 0.0000 0.0000
MONEY_SALDO 49 214 7 400.0000 0.0000
MONEY_TURNOVER_LOG 1732 1683 1 0.0000 0.0000
PDISTR 836096 17524 2 0.0000 0.0000
PERF_SPLIT_0 162327 1983 1 0.0000 0.0000
PERF_SPLIT_1 128349 695 1 0.0000 0.0000
PERF_SPLIT_2 149334 697 1 0.0000 0.0000
PERF_SPLIT_3 148561 3475 1 0.0000 0.0000
PERF_SPLIT_4 147001 699 1 0.0000 0.0000
PERF_SPLIT_5 150794 1195 1 0.0000 0.0000
PERF_SPLIT_6 150714 1832 1 0.0000 0.0000
PERF_SPLIT_7 141649 1236 1 0.0000 0.0000
PERF_SPLIT_8 145364 1130 1 0.0000 0.0000
PERF_SPLIT_9 150758 3048 1 0.0000 0.0000
PSTORNED 2045947 29863 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 119118 38297 1 0.0000 0.0000
XQD_1000_3300 7300796 132804 1 0.0000 0.0000
XQD_1200_2000 12332538 137761 1 0.0000 0.0000
XQD_2000_3300 1272585 139118 1 0.0000 0.0000
XQD_2100_3300 726259 37286 1 0.0000 0.0000
XQD_3300_3400 8683707 411566 1 0.0000 0.0000
XQS_1000_1200 21126198 27625 1 0.0000 0.0000
XQS_1000_3300 9701362 980668 1 0.0000 0.0000
XQS_1200_2000 11262056 785358 1 0.0000 0.0000
XQS_2100_3300 9809848 978194 1 0.0000 0.0000
XQS_3300_3400 578132 13960 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 ---
:487: 
:488: mscs-test-161.budzdorov.ru    Fri Apr 12 10:08:09 2024
:489:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:490: 
:491: 
:492: mscs-test-161.budzdorov.ru    Fri Apr 12 10:08:10 2024
:493:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:494: 
--- end of diff output ---

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

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