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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15896532 kB
MemAvailable 30301640 kB
Buffers 0 kB
Cached 15861372 kB
SwapCached 2404 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 3.0.12
DB_NAME                         /home/bases/oltp30-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/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/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=3333
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/oltp30-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-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-22 22:09:42
DTS_END                         2024-02-22 22:09:42.9510
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/53414
TRN_ID                          179029
ATT_ID                          544
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: 9171.94 20630 917194
customer order: creation 180.58 369 18058
customer order: refuse 15.53 395 1553
order to supplier: creation 47.50 1262 4750
order to supplier: removal 3.67 90807 367
invoice (draft): creation 47.83 3515 4783
invoice (draft): removal 48.21 829 4821
invoice accept: apply 43.80 21086 4380
invoice accept: cancel 43.87 998 4387
customer reserve: creation 4157.78 204 415778
customer reserve: removal 4280.10 62 428010
realization accept: apply 87.95 210 8795
realization accept: cancel 77.10 135 7710
payment from customer: creation 62.60 125 6260
payment from customer: removal 5.82 96 582
payment to supplier: creation 52.41 168 5241
payment to supplier: removal 3.95 92 395
service: total inventory turnovers 5.27 960 527
service: total monetary turnovers 7.04 26 704
service: aggregate perf. data 0.90 15818 90
service: refresh index statistics 0.03 275441 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-02-2024 22:11:10 to 22-02-2024 22:11:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2291
TEST_TIME 2 3205
TEST_TIME 3 3407
TEST_TIME 4 3105
TEST_TIME 5 3458
TEST_TIME 6 4242
TEST_TIME 7 4284
TEST_TIME 8 5144
TEST_TIME 9 5465
TEST_TIME 10 5400
TEST_TIME 11 5273
TEST_TIME 12 5370
TEST_TIME 13 5557
TEST_TIME 14 5483
TEST_TIME 15 5736
TEST_TIME 16 5891
TEST_TIME 17 6162
TEST_TIME 18 6383
TEST_TIME 19 6623
TEST_TIME 20 6587
TEST_TIME 21 6607
TEST_TIME 22 6922
TEST_TIME 23 7038
TEST_TIME 24 7150
TEST_TIME 25 7072
TEST_TIME 26 7418
TEST_TIME 27 7922
TEST_TIME 28 8053
TEST_TIME 29 8841
TEST_TIME 30 9021
TEST_TIME 31 9041
TEST_TIME 32 8878
TEST_TIME 33 8774
TEST_TIME 34 9280
TEST_TIME 35 9303
TEST_TIME 36 9063
TEST_TIME 37 9047
TEST_TIME 38 9013
TEST_TIME 39 8894
TEST_TIME 40 8971
TEST_TIME 41 8937
TEST_TIME 42 8848
TEST_TIME 43 9019
TEST_TIME 44 9008
TEST_TIME 45 8927
TEST_TIME 46 8924
TEST_TIME 47 9001
TEST_TIME 48 8922
TEST_TIME 49 8897
TEST_TIME 50 8833
TEST_TIME 51 8786
TEST_TIME 52 8812
TEST_TIME 53 8779
TEST_TIME 54 8755
TEST_TIME 55 8785
TEST_TIME 56 8800
TEST_TIME 57 8751
TEST_TIME 58 8993
TEST_TIME 59 9069
TEST_TIME 60 9071
TEST_TIME 61 9026
TEST_TIME 62 9155
TEST_TIME 63 9180
TEST_TIME 64 9259
TEST_TIME 65 9317
TEST_TIME 66 9277
TEST_TIME 67 9167
TEST_TIME 68 9106
TEST_TIME 69 9117
TEST_TIME 70 9070
TEST_TIME 71 9019
TEST_TIME 72 8957
TEST_TIME 73 9083
TEST_TIME 74 9082
TEST_TIME 75 9053
TEST_TIME 76 9054
TEST_TIME 77 9053
TEST_TIME 78 9082
TEST_TIME 79 9095
TEST_TIME 80 9149
TEST_TIME 81 9186
TEST_TIME 82 9193
TEST_TIME 83 9285
TEST_TIME 84 9318
TEST_TIME 85 9368
TEST_TIME 86 9396
TEST_TIME 87 9444
TEST_TIME 88 9344
TEST_TIME 89 9296
TEST_TIME 90 9298
TEST_TIME 91 9257
TEST_TIME 92 9273
TEST_TIME 93 9201
TEST_TIME 94 9223
TEST_TIME 95 9252
TEST_TIME 96 9226
TEST_TIME 97 9226
TEST_TIME 98 9230
TEST_TIME 99 9189
TEST_TIME 100 9172

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 22-02-2024 22:11:13 to 22-02-2024 22:11:17.

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 1296931 1296931 0 0.00 0 24121 8 0 0
doc_list_biud 1296931 1296931 0 0.00 0 27670 26 0 0
sp_add_invoice_to_stock 4534 4380 154 3.39 45 206038 21087 0 154
sp_cancel_adding_invoice 4387 4387 0 0.00 5 64613 999 0 0
sp_cancel_client_order 1553 1553 0 0.00 4 9171 396 0 0
sp_cancel_customer_reserve 428010 428010 0 0.00 0 27672 62 0 0
sp_cancel_pay_from_customer 582 582 0 0.00 3 3315 97 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 2 15444 92 0 0
sp_cancel_supplier_invoice 4837 4821 16 0.33 2 16615 829 0 16
sp_cancel_supplier_order 367 367 0 0.00 8 1001316 90807 0 0
sp_cancel_write_off 7710 7710 0 0.00 1 21467 136 0 0
sp_client_order 18058 18058 0 0.00 3 27654 370 0 0
sp_customer_reserve 415778 415778 0 0.00 0 42570 205 0 0
sp_fill_shopping_cart 27591 27591 0 0.00 1 13027 36 0 0
sp_fill_shopping_cart_clo_res 415778 415778 0 0.00 0 15955 16 0 0
sp_get_clo_for_invoice 4380 4380 0 0.00 0 18954 323 0 0
sp_kill_cost_storno 13074 13074 0 0.00 0 21351 70 0 0
sp_kill_qstorno_ret_qs2qd 868918 868918 0 0.00 0 27666 34 0 0
sp_kill_qty_storno 460023 460023 0 0.00 0 27670 73 0 0
sp_lock_selected_doc 18270 18270 0 0.00 0 7902 4 0 0
sp_make_cost_storno 24676 24676 0 0.00 0 24093 68 0 0
sp_multiply_rows_for_pdistr 24676 24676 0 0.00 0 20588 40 0 0
sp_multiply_rows_for_qdistr 18058 18058 0 0.00 0 27649 155 0 0
sp_pay_from_customer 6260 6260 0 0.00 4 19490 125 0 0
sp_pay_to_supplier 5241 5241 0 0.00 4 21708 168 0 0
sp_payment_common 11501 11501 0 0.00 2 21215 38 0 0
sp_qd_handle_on_cancel_clo 1553 1553 0 0.00 0 9162 369 0 0
sp_qd_handle_on_invoice_upd_sts 8767 8767 0 0.00 0 20640 330 0 0
sp_qd_handle_on_reserve_upd_sts 8795 8795 0 0.00 0 16452 61 0 0
sp_reserve_write_off 8795 8795 0 0.00 6 22751 211 0 0
sp_supplier_invoice 4783 4783 0 0.00 5 85807 3516 0 0
sp_supplier_order 4750 4750 0 0.00 5 31569 1263 0 0
srv_aggregate_perf_data 90 90 0 0.00 1700 230770 15819 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 993 148040 37666 0 0
srv_find_qd_qs_mism 872238 872238 0 0.00 0 19831 7 0 0
srv_make_invnt_saldo 527 527 0 0.00 52 23187 961 0 0
srv_make_money_saldo 704 704 0 0.00 1 1130 27 0 0
srv_recalc_idx_stat 3 3 0 0.00 228985 312129 275442 0 0
t$perf-abend:sp_add_invoice_to_stock 154 154 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4380 4380 0 0.00 0 13545 213 0 0
t$perf-norm:sp_cancel_adding_invoice 364 364 0 0.00 0 2889 98 0 0
t$perf-norm:sp_cancel_client_order 1553 1553 0 0.00 0 2532 13 0 0
t$perf-norm:sp_cancel_customer_reserve 583 583 0 0.00 0 1719 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 582 582 0 0.00 0 534 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 604 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 360 360 0 0.00 0 3672 25 0 0
t$perf-norm:sp_cancel_supplier_order 367 367 0 0.00 0 25658 1389 0 0
t$perf-norm:sp_cancel_write_off 891 891 0 0.00 0 418 4 0 0
t$perf-norm:sp_client_order 18058 18058 0 0.00 0 5633 15 0 0
t$perf-norm:sp_customer_reserve 883 883 0 0.00 0 2586 12 0 0
t$perf-norm:sp_pay_from_customer 6260 6260 0 0.00 0 4764 9 0 0
t$perf-norm:sp_pay_to_supplier 5241 5241 0 0.00 0 4114 8 0 0
t$perf-norm:sp_reserve_write_off 8795 8795 0 0.00 0 4685 10 0 0
t$perf-norm:sp_supplier_invoice 4783 4783 0 0.00 0 5171 19 0 0
t$perf-norm:sp_supplier_order 4750 4750 0 0.00 0 2863 17 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 911 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 127 3 0 0
t$perf-norm:srv_make_invnt_saldo 527 527 0 0.00 0 1559 30 0 0
t$perf-norm:srv_make_money_saldo 704 704 0 0.00 0 1494 22 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 9068 8760 308 3.39 0 5911 19 0 308
v_all_customers 33392 33392 0 0.00 0 21 1 0 0
v_all_suppliers 27174 27174 0 0.00 0 93 1 0 0
v_all_wares 36116 36116 0 0.00 0 69 1 0 0
v_cancel_adding_invoice 728 728 0 0.00 0 982 7 0 0
v_cancel_client_order 3106 3106 0 0.00 0 2103 5 0 0
v_cancel_customer_prepayment 1164 1164 0 0.00 0 3305 7 0 0
v_cancel_customer_reserve 1166 1166 0 0.00 0 3974 15 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 282 3 0 0
v_cancel_supplier_invoice 752 720 32 4.25 0 1589 19 0 32
v_cancel_supplier_order 734 734 0 0.00 0 988 9 0 0
v_cancel_write_off 1782 1782 0 0.00 0 2433 15 0 0
v_max_id_clo_ord 4750 4750 0 0.00 0 1085 2 0 0
v_max_id_clo_res 883 883 0 0.00 0 930 7 0 0
v_max_id_ord_sup 4782 4782 0 0.00 0 5059 5 0 0
v_max_non_paid_invoice 1186 1186 0 0.00 0 495 3 0 0
v_max_non_paid_realizn 3081 3081 0 0.00 0 2697 5 0 0
v_min_id_clo_ord 4750 4750 0 0.00 0 3190 10 0 0
v_min_id_clo_res 883 883 0 0.00 0 3892 14 0 0
v_min_id_ord_sup 4782 4782 0 0.00 0 2002 4 0 0
v_min_non_paid_invoice 5241 5241 0 0.00 0 21199 34 0 0
v_min_non_paid_realizn 6260 6260 0 0.00 0 18617 29 0 0
v_our_firm 9082 9082 0 0.00 0 15 1 0 0
v_reserve_write_off 17590 17590 0 0.00 0 3968 7 0 0
x_lock_depdocs_on_canc_invoice 8848 8848 0 0.00 0 11595 140 0 0
x_lock_depdocs_on_canc_sup_ord 367 367 0 0.00 0 9845 293 0 0
x_make_qstorno_1000_1200 4750 4750 0 0.00 1 31563 1176 0 0
x_make_qstorno_1200_2000 4783 4783 0 0.00 2 85690 3391 0 0
x_make_qstorno_2100_3300 415778 415778 0 0.00 0 42563 185 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-02-2024 22:11:18 to 22-02-2024 22:11:22.

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
20:09:46 2 8192000000 8797116768 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:47 24117 8192000000 9905286640 10218332160 986236336 10.745 100 87 174 0 1015624192 6157968 23229888
20:12:18 13165 8192000000 9955443168 10280497152 1040637008 11.271 100 89 178 1 1071841504 8258224 22946272
20:13:44 18551 8192000000 9988624272 10322530304 1074220624 11.592 100 85 170 0 1106076352 10698416 21157312
20:15:21 12540 8192000000 10031545456 10378637312 1117451536 12.003 100 83 166 0 1148586528 11547312 19587680
20:16:37 7213 8192000000 10074812720 10432831488 1163271792 12.434 100 74 148 1 1192402400 11878688 17251920
20:17:46 3521 8192000000 10123352960 10487922688 1208172032 12.852 100 86 170 0 1241385088 14463568 18749488
20:18:51 2242 8192000000 10140932816 10508939264 1226311072 13.020 100 91 181 1 1259986304 14433760 19241472
20:19:55 1844 8192000000 10175508768 10551103488 1265028608 13.376 100 83 164 1 1296794288 13713200 18052480
20:20:59 887 8192000000 10202325264 10585780224 1286376064 13.571 100 83 165 0 1316364944 12001712 17987168
20:22:01 7779 8192000000 10208717968 10597425152 1294043840 13.641 100 67 132 0 1319295328 10652272 14599216
20:23:11 6345 8192000000 10190306768 10602721280 1305360416 13.744 100 21 40 1 1315936208 6542832 4032960
20:24:18 12430 8192000000 10207835248 10617315328 1311716320 13.802 100 26 52 1 1329464880 11886480 5862080
20:25:31 11789 8192000000 10212357648 10628591616 1322929040 13.903 100 33 66 1 1336345328 5519248 7897040
20:26:46 31346 8192000000 10213175728 10634895360 1327062704 13.941 100 20 40 0 1337799824 6060496 4676624
20:28:18 6610 8192000000 10214131296 10634264576 1325050848 13.922 100 28 55 1 1342610192 11440192 6119152
20:29:25 11630 8192000000 10221414432 10642554880 1318522848 13.863 99 17 34 0 1327848176 5548112 3777216
20:30:51 39042 8192000000 10217361984 10624172032 1298263504 13.679 97 44 88 0 1317515488 8127296 11124688
20:32:36 71725 8192000000 10244367296 10658398208 1316038368 13.841 98 52 105 0 1338671152 10557664 12075120
20:35:24 36071 8192000000 10243307264 10673627136 1348547760 14.134 100 33 66 0 1367849184 11426912 7874512
20:37:05 31034 8192000000 10259958240 10666655744 1321947136 13.894 99 59 118 0 1351492720 15339168 14206416
20:38:40 7740 8192000000 10217366512 10619871232 1298526496 13.682 98 54 106 1 1323211424 12976448 11708480
20:40:02 40467 8192000000 10209546656 10615492608 1280554400 13.518 97 27 55 1 1300236656 13303872 6378384
20:41:50 993 8192000000 10255696096 10654769152 1330585808 13.972 100 65 127 3 1362567392 17579488 14402096
20:42:57 9862 8192000000 10243600800 10650230784 1316888544 13.849 99 44 87 0 1348036944 21265104 9883296
20:44:13 6547 8192000000 10257590896 10660528128 1328610464 13.955 100 55 108 0 1367131392 25474032 13046896
20:45:26 5338 8192000000 10255424160 10650386432 1319663408 13.874 100 66 131 1 1362451232 26360928 16426896
20:46:35 2782 8192000000 10263845984 10658160640 1315560288 13.836 98 75 147 1 1362836288 29945296 17330704
20:47:45 3458 8192000000 10294224880 10696241152 1352922736 14.174 100 66 132 1 1399596320 30887888 15785696
20:48:56 1980 8192000000 10316936752 10719854592 1370896384 14.335 100 84 164 1 1421108208 30844000 19367824
20:50:05 3536 8192000000 10341928256 10749222912 1385206320 14.463 100 84 164 1 1446188432 40338416 20643696
20:51:21 1357 8192000000 10359972400 10768846848 1401411760 14.608 100 76 152 2 1459816944 40371536 18033648
20:52:32 39477 8192000000 10331173712 10757709824 1389918304 14.505 99 35 69 0 1433857968 34446512 9493152
20:54:21 11999 8192000000 10335255104 10770108416 1398579568 14.582 100 31 62 0 1446657584 39764432 8313584
20:55:43 5590 8192000000 10336273776 10766819328 1395716304 14.557 100 46 91 0 1449477040 42077632 11683104
20:56:50 55400 8192000000 10330842160 10773483520 1388046464 14.488 100 18 36 0 1440111856 47402512 4662880
20:58:47 11403 8192000000 10313357344 10740060160 1392434704 14.528 100 44 81 0 1407568176 5893280 9240192
21:00:00 54277 8192000000 10310314000 10760667136 1385592752 14.467 99 19 38 1 1403124048 13141856 4389440
21:01:56 32861 8192000000 10345506560 10784423936 1415896624 14.736 100 49 98 1 1442980384 14960384 12123376
21:03:32 28256 8192000000 10320989056 10784440320 1406272080 14.651 100 17 31 1 1433619536 23858336 3489120
21:05:01 74821 8192000000 10316202416 10767179776 1408096720 14.667 100 40 77 1 1423834400 6729776 9007904
21:07:18 67717 8192000000 10301645360 10753138688 1393831888 14.540 99 22 43 1 1406445152 7693328 4919936
21:09:38 11155 8192000000 10316714592 10765873152 1411248048 14.695 100 25 50 1 1423280880 7089072 4943760
21:10:55 37967 8192000000 10331463696 10780811264 1411631664 14.698 99 47 92 0 1435122528 12505424 10985440
21:13:01 32512 8192000000 10316418752 10781523968 1422303376 14.793 100 11 22 0 1438093120 13479072 2310672
21:15:18 30647 8192000000 10297725872 10752536576 1372487824 14.349 98 30 60 1 1396466592 16222304 7756464
21:16:55 60521 8192000000 10303444880 10747101184 1365682480 14.288 98 21 42 0 1382359904 11779552 4897872
21:18:56 23542 8192000000 10290831600 10738634752 1352781072 14.172 97 27 54 1 1371064496 12161200 6122224
21:20:22 62602 8192000000 10230394112 10677067776 1299949184 13.695 94 12 24 1 1310840032 8179808 2711040
21:22:57 25337 8192000000 10264178256 10718932992 1344464992 14.098 98 20 38 0 1357290912 8481232 4344688
21:24:25 40130 8192000000 10263479232 10709065728 1340404720 14.061 99 34 68 0 1364756512 16488960 7862832
21:26:07 41203 8192000000 10247196784 10681675776 1294539200 13.646 96 26 52 0 1318013808 17564944 5909664
21:27:55 35452 8192000000 10241173456 10682712064 1304292272 13.734 97 26 52 0 1322176112 12238704 5645136
21:29:33 5714 8192000000 10261995808 10691661824 1341658688 14.072 100 42 80 1 1363803712 13697072 8447952
21:30:41 3350 8192000000 10270765472 10686902272 1338157696 14.041 100 73 145 2 1369289552 15075984 16055872
21:31:47 47291 8192000000 10248302000 10684817408 1289239680 13.597 96 14 27 0 1300868672 9257456 2371536
21:33:40 54922 8192000000 10254025744 10699272192 1334701424 14.010 99 19 38 0 1352639104 13380528 4557152
21:36:30 65385 8192000000 10261548208 10702094336 1336015552 14.021 99 40 79 0 1352611920 7577296 9019072
21:38:57 29488 8192000000 10260822304 10702163968 1339359872 14.052 98 20 40 0 1352862224 8343968 5158384
21:40:28 22993 8192000000 10272490528 10724978688 1376151568 14.382 100 18 36 0 1393153328 13351296 3650464
21:41:55 57958 8192000000 10290424944 10760761344 1387042656 14.479 100 11 22 0 1407085808 17611824 2431328
21:43:56 34934 8192000000 10293553728 10742276096 1379958352 14.416 99 15 30 0 1392739600 9607936 3173312
21:45:32 55770 8192000000 10296863584 10753728512 1366842208 14.299 98 28 56 1 1390489200 17344928 6302064
21:47:28 30437 8192000000 10291981088 10741862400 1377883408 14.398 99 27 54 0 1395531232 10355216 7292608
21:49:07 55643 8192000000 10310765168 10759606272 1397502272 14.573 100 19 39 0 1413173184 11049488 4621424
21:51:05 53864 8192000000 10324737360 10764238848 1386686752 14.476 99 32 63 0 1406593360 12941776 6964832
21:53:00 148040 8192000000 10298258688 10753568768 1337756784 14.037 95 13 26 0 1358895376 18225472 2913120
21:56:30 57371 8192000000 10276630304 10743558144 1361370704 14.250 99 3 6 0 1381874816 20204688 299424
21:58:28 73347 8192000000 10292552272 10747502592 1369575584 14.323 99 26 52 0 1391318704 16508336 5234784
22:00:42 67830 8192000000 10286731552 10747580416 1364031216 14.274 98 23 46 1 1385646160 16474704 5140240
22:02:51 84552 8192000000 10278496128 10737115136 1371674592 14.342 99 14 29 0 1392014544 17019120 3320832
22:05:19 73305 8192000000 10275653776 10733289472 1356022384 14.202 98 18 36 0 1368894976 8930400 3942192
22:07:33 37623 8192000000 10257454400 10707988480 1345539984 14.107 99 19 39 0 1358281488 8438720 4302784
22:09:10 42301 8192000000 9172723792 9417060352 334576960 3.923 25 9 18 0 342768960 6225984 1966016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 22-02-2024 22:11:24 to 22-02-2024 22:11:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 154 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-02-2024 22:11:39 to 22-02-2024 22:11:41.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          179310
MON$OLDEST_ACTIVE               179311
MON$OLDEST_SNAPSHOT             179311
MON$NEXT_TRANSACTION            179311
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-03 16:41:55.3470
MON$PAGES                       1903008
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.12.33731 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33731 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33731 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Feb 22 22:11:42 2024 
 
Database header page information: 
    Flags            0 
    Generation        93518 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    179310 
    Oldest active        179311 
    Oldest snapshot        179311 
    Next transaction    179312 
    Sequence number        0 
    Next attachment ID    724 
    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 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    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: 1504311, 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: 1504313, 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: 1504312, 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: 1504310, 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: 1504309, 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: 504, Index root page: 505 
    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: 1504242, 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: 1504244, 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: 1504243, 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: 1504241, 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: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.27, total records: 7807725 
    Average version length: 48.16, total versions: 101717, 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: 87040 
    Data pages: 87040, average fill: 72% 
    Primary pages: 87040, secondary pages: 0, swept pages: 17409 
    Empty pages: 2, full pages: 64627 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 88 
    40 - 59% = 1093 
    60 - 79% = 85793 
    80 - 99% = 43 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23415, nodes: 7807725 
    Average node length: 18.92, total dup: 0, max dup: 0 
    Average key length: 15.93, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1738727, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 334 
        20 - 39% = 1708 
        40 - 59% = 4319 
        60 - 79% = 2228 
        80 - 99% = 14826 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13592, nodes: 7807725 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1561511, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1569 
        40 - 59% = 2122 
        60 - 79% = 1017 
        80 - 99% = 8882 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8363, nodes: 7807725 
    Average node length: 6.63, total dup: 5817750, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1554323, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 104 
        20 - 39% = 927 
        40 - 59% = 1448 
        60 - 79% = 843 
        80 - 99% = 5041 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.15, total records: 2280809 
    Average version length: 34.50, total versions: 103847, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28488 
    Data pages: 28488, average fill: 74% 
    Primary pages: 28483, secondary pages: 5, swept pages: 8818 
    Empty pages: 6, full pages: 21308 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 46 
    40 - 59% = 745 
    60 - 79% = 26801 
    80 - 99% = 884 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4603, nodes: 2280809 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 709720, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 896 
        40 - 59% = 898 
        60 - 79% = 692 
        80 - 99% = 2117 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2548, nodes: 2283170 
    Average node length: 4.97, total dup: 2282271, max dup: 20286 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1257553, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 257 
        40 - 59% = 1539 
        60 - 79% = 557 
        80 - 99% = 192 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2069, nodes: 2280809 
    Average node length: 4.97, total dup: 2280759, max dup: 130416 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1069429, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 45 
        40 - 59% = 1170 
        60 - 79% = 41 
        80 - 99% = 811 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4377, nodes: 2280809 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 709720, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 574 
        40 - 59% = 634 
        60 - 79% = 772 
        80 - 99% = 2297 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    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: 1504315, 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: 1504316, 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: 1504314, 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: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, 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.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, 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: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.10, total records: 400 
    Average version length: 22.70, total versions: 255798, max versions: 668 
    Average fragment length: 2.00, total fragments: 65, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1408 
    Data pages: 1408, average fill: 90% 
    Primary pages: 11, secondary pages: 1397, swept pages: 0 
    Empty pages: 4, full pages: 1403 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 1402 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 13.02, total records: 65739 
    Average version length: 68.28, total versions: 53213, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.76 
    Pointer pages: 6, data page slots: 2384 
    Data pages: 1408, average fill: 58% 
    Primary pages: 1407, secondary pages: 1, swept pages: 2 
    Empty pages: 200, full pages: 733 
    Fill distribution: 
     0 - 19% = 343 
    20 - 39% = 143 
    40 - 59% = 117 
    60 - 79% = 173 
    80 - 99% = 632 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705237, depth: 3, leaf buckets: 238, nodes: 65739 
    Average node length: 13.20, total dup: 3642, max dup: 2 
    Average key length: 10.85, compression ratio: 2.49 
    Average prefix length: 19.09, average data length: 7.91 
    Clustering factor: 49176, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 102 
        40 - 59% = 108 
        60 - 79% = 24 
        80 - 99% = 4 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.31, total records: 49 
    Average version length: 9.00, total versions: 18563, max versions: 982 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 7, secondary pages: 65, swept pages: 0 
    Empty pages: 6, full pages: 65 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 60 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, 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: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.76, total records: 1071 
    Average version length: 42.92, total versions: 982, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 15.44 
    Pointer pages: 1, data page slots: 32 
    Data pages: 31, average fill: 34% 
    Primary pages: 30, secondary pages: 1, swept pages: 0 
    Empty pages: 15, full pages: 7 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 8 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 96119, depth: 2, leaf buckets: 2, nodes: 1071 
    Average node length: 4.33, total dup: 974, max dup: 121 
    Average key length: 2.96, compression ratio: 6.41 
    Average prefix length: 18.12, average data length: 0.88 
    Clustering factor: 566, ratio: 0.53 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 74 
    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: 52% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    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: 520, Index root page: 521 
    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: 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 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, 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: 1504226, 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: 1504228, 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: 1504225, 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: 522, Index root page: 523 
    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: 1504224, 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: 1504222, 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: 1504221, 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: 1504223, 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: 1504220, 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: 468, Index root page: 469 
    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: 1544805, 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: 1544804, 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: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.12, total records: 781584 
    Average version length: 25.42, total versions: 65489, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 7808 
    Data pages: 7800, average fill: 70% 
    Primary pages: 7778, secondary pages: 22, swept pages: 1227 
    Empty pages: 38, full pages: 6816 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 117 
    40 - 59% = 160 
    60 - 79% = 7222 
    80 - 99% = 219 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 859, nodes: 781584 
    Average node length: 4.87, total dup: 781535, max dup: 143358 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88584, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 115 
        40 - 59% = 488 
        60 - 79% = 210 
        80 - 99% = 46 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 891, nodes: 781584 
    Average node length: 5.87, total dup: 695833, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 157309, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 104 
        40 - 59% = 324 
        60 - 79% = 153 
        80 - 99% = 308 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 933, nodes: 781584 
    Average node length: 5.87, total dup: 695833, max dup: 44 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159268, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 205 
        40 - 59% = 288 
        60 - 79% = 134 
        80 - 99% = 306 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1103, nodes: 781584 
    Average node length: 5.96, total dup: 695833, max dup: 44 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152394, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 258 
        40 - 59% = 549 
        60 - 79% = 200 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.85, total records: 5530 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.06, total fragments: 66, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 104 
    Data pages: 104, average fill: 53% 
    Primary pages: 86, secondary pages: 18, swept pages: 53 
    Empty pages: 19, full pages: 65 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 0 
    40 - 59% = 2 
    60 - 79% = 69 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5530 
    Average node length: 5.45, total dup: 0, max dup: 0 
    Average key length: 3.56, compression ratio: 10.13 
    Average prefix length: 34.57, average data length: 1.53 
    Clustering factor: 5266, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5530 
    Average node length: 11.10, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 140, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 82065 
    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: 792 
    Data pages: 792, average fill: 71% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 790 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 790 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36477, depth: 2, leaf buckets: 107, nodes: 82065 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3614, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    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: 1504239, 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: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 110.62, 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: 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: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 148.24, total records: 168154 
    Average version length: 148.10, total versions: 2924, 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: 6008 
    Data pages: 4040, average fill: 86% 
    Primary pages: 4040, secondary pages: 0, swept pages: 1 
    Empty pages: 50, full pages: 3969 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 9 
    40 - 59% = 2 
    60 - 79% = 7 
    80 - 99% = 3970 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 133.14, total records: 201784 
    Average version length: 154.32, total versions: 24080, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.74 
    Pointer pages: 6, data page slots: 6216 
    Data pages: 4896, average fill: 86% 
    Primary pages: 4896, secondary pages: 0, swept pages: 2 
    Empty pages: 90, full pages: 4785 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 6 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 4785 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 137.99, total records: 201221 
    Average version length: 154.58, total versions: 17816, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.29 
    Pointer pages: 7, data page slots: 6064 
    Data pages: 4872, average fill: 86% 
    Primary pages: 4872, secondary pages: 0, swept pages: 1 
    Empty pages: 73, full pages: 4771 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 7 
    40 - 59% = 8 
    60 - 79% = 12 
    80 - 99% = 4770 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 144.91, total records: 159332 
    Average version length: 151.54, total versions: 6060, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.70 
    Pointer pages: 7, data page slots: 5288 
    Data pages: 3864, average fill: 85% 
    Primary pages: 3864, secondary pages: 0, swept pages: 4 
    Empty pages: 85, full pages: 3756 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 8 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 3756 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 143.21, total records: 141127 
    Average version length: 151.10, total versions: 6898, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.84 
    Pointer pages: 6, data page slots: 4408 
    Data pages: 3408, average fill: 85% 
    Primary pages: 3407, secondary pages: 1, swept pages: 1 
    Empty pages: 60, full pages: 3323 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 12 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3323 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 145.91, total records: 172211 
    Average version length: 150.54, total versions: 6007, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.62 
    Pointer pages: 5, data page slots: 5096 
    Data pages: 4152, average fill: 86% 
    Primary pages: 4152, secondary pages: 0, swept pages: 1 
    Empty pages: 57, full pages: 4070 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 10 
    80 - 99% = 4069 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 142.76, total records: 187671 
    Average version length: 152.80, total versions: 10431, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 8, data page slots: 5176 
    Data pages: 4528, average fill: 86% 
    Primary pages: 4528, secondary pages: 0, swept pages: 1 
    Empty pages: 62, full pages: 4438 
    Fill distribution: 
     0 - 19% = 64 
    20 - 39% = 12 
    40 - 59% = 5 
    60 - 79% = 9 
    80 - 99% = 4438 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 146.72, total records: 177285 
    Average version length: 151.48, total versions: 4969, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.56 
    Pointer pages: 5, data page slots: 4832 
    Data pages: 4280, average fill: 85% 
    Primary pages: 4280, secondary pages: 0, swept pages: 1 
    Empty pages: 69, full pages: 4192 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4192 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 144.84, total records: 167578 
    Average version length: 152.54, total versions: 6750, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.71 
    Pointer pages: 6, data page slots: 5792 
    Data pages: 4080, average fill: 85% 
    Primary pages: 4080, secondary pages: 0, swept pages: 1 
    Empty pages: 94, full pages: 3955 
    Fill distribution: 
     0 - 19% = 97 
    20 - 39% = 10 
    40 - 59% = 10 
    60 - 79% = 9 
    80 - 99% = 3954 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 140.12, total records: 188787 
    Average version length: 153.88, total versions: 13873, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.10 
    Pointer pages: 7, data page slots: 5576 
    Data pages: 4592, average fill: 85% 
    Primary pages: 4592, secondary pages: 0, swept pages: 1 
    Empty pages: 91, full pages: 4468 
    Fill distribution: 
     0 - 19% = 93 
    20 - 39% = 14 
    40 - 59% = 7 
    60 - 79% = 9 
    80 - 99% = 4469 
 
PHRASES (143) 
    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 PHRASES_ID_DESC (3) 
    Root page: 1510354, 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: 1510353, 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: 1510352, 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: 1510351, 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: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.67, total records: 2135986 
    Average version length: 52.88, total versions: 43607, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25440 
    Data pages: 25424, average fill: 72% 
    Primary pages: 25424, secondary pages: 0, swept pages: 9863 
    Empty pages: 139, full pages: 21639 
    Fill distribution: 
     0 - 19% = 280 
    20 - 39% = 284 
    40 - 59% = 824 
    60 - 79% = 23643 
    80 - 99% = 393 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2625, nodes: 2135986 
    Average node length: 5.44, total dup: 1993996, max dup: 1673 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184431, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 245 
        40 - 59% = 1773 
        60 - 79% = 326 
        80 - 99% = 268 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2767, nodes: 2135986 
    Average node length: 5.69, total dup: 1917432, max dup: 72 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 381477, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 2329 
        60 - 79% = 404 
        80 - 99% = 29 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2214, nodes: 2135986 
    Average node length: 4.96, total dup: 2135886, max dup: 28027 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181956, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 200 
        40 - 59% = 1235 
        60 - 79% = 401 
        80 - 99% = 374 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    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: 1504317, 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: 470, Index root page: 471 
    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: 1544803, 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: 1544802, 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: 500, Index root page: 501 
    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: 1504305, 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: 1504306, 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: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, 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: 525, 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: 1544806, 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: 454, Index root page: 455 
    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: 1544810, 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: 460, Index root page: 461 
    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: 1544807, 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: 462, Index root page: 463 
    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: 464, Index root page: 465 
    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: 518, Index root page: 519 
    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: 516, Index root page: 517 
    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: 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 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    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: 456, Index root page: 457 
    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: 1544809, 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: 1544808, 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: 452, Index root page: 453 
    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: 1544811, 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: 528, Index root page: 529 
    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: 1504214, 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: 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 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    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: 1552159, 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: 1510355, 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: 1510360, 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: 1510358, 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: 498, Index root page: 499 
    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: 1504307, 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: 1504308, 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: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 40.33, total records: 136235 
    Average version length: 69.17, total versions: 56867, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 3, data page slots: 3976 
    Data pages: 2775, average fill: 57% 
    Primary pages: 2775, secondary pages: 0, swept pages: 306 
    Empty pages: 417, full pages: 1559 
    Fill distribution: 
     0 - 19% = 605 
    20 - 39% = 231 
    40 - 59% = 236 
    60 - 79% = 654 
    80 - 99% = 1049 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102759, depth: 3, leaf buckets: 230, nodes: 136235 
    Average node length: 6.40, total dup: 118524, max dup: 14 
    Average key length: 3.97, compression ratio: 10.58 
    Average prefix length: 40.16, average data length: 1.84 
    Clustering factor: 23519, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 74 
        40 - 59% = 104 
        60 - 79% = 42 
        80 - 99% = 7 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.57, total records: 7055382 
    Average version length: 68.81, total versions: 448941, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 62, data page slots: 99800 
    Data pages: 99800, average fill: 76% 
    Primary pages: 99800, secondary pages: 0, swept pages: 20227 
    Empty pages: 7, full pages: 86663 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 510 
    40 - 59% = 3687 
    60 - 79% = 87422 
    80 - 99% = 8142 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10648, nodes: 7055382 
    Average node length: 6.51, total dup: 6101944, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1567442, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1516 
        40 - 59% = 6002 
        60 - 79% = 2601 
        80 - 99% = 521 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8457, nodes: 7055382 
    Average node length: 5.40, total dup: 6774744, max dup: 167 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1362614, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1097 
        40 - 59% = 4745 
        60 - 79% = 1585 
        80 - 99% = 1024 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8502, nodes: 7055382 
    Average node length: 5.40, total dup: 6774744, max dup: 167 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1365260, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1136 
        40 - 59% = 4742 
        60 - 79% = 1569 
        80 - 99% = 1050 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.98, total records: 12015459 
    Average version length: 68.73, total versions: 343285, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 103, data page slots: 166904 
    Data pages: 166904, average fill: 76% 
    Primary pages: 166904, secondary pages: 0, swept pages: 76187 
    Empty pages: 4, full pages: 155970 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 372 
    40 - 59% = 2903 
    60 - 79% = 157140 
    80 - 99% = 6459 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18341, nodes: 12015459 
    Average node length: 6.57, total dup: 10473483, max dup: 59 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2372829, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2132 
        40 - 59% = 11121 
        60 - 79% = 4420 
        80 - 99% = 645 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 39.81, total records: 1583351 
    Average version length: 69.13, total versions: 671836, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.16 
    Pointer pages: 26, data page slots: 40624 
    Data pages: 28030, average fill: 65% 
    Primary pages: 28030, secondary pages: 0, swept pages: 6964 
    Empty pages: 2698, full pages: 19020 
    Fill distribution: 
     0 - 19% = 4565 
    20 - 39% = 1618 
    40 - 59% = 1603 
    60 - 79% = 9770 
    80 - 99% = 10474 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2207, nodes: 1583351 
    Average node length: 5.52, total dup: 1518831, max dup: 93 
    Average key length: 2.56, compression ratio: 16.38 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 105403, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 629 
        40 - 59% = 1102 
        60 - 79% = 398 
        80 - 99% = 75 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 40.16, total records: 1219820 
    Average version length: 69.13, total versions: 510125, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.14 
    Pointer pages: 19, data page slots: 30608 
    Data pages: 24936, average fill: 57% 
    Primary pages: 24936, secondary pages: 0, swept pages: 3935 
    Empty pages: 3610, full pages: 13737 
    Fill distribution: 
     0 - 19% = 5652 
    20 - 39% = 1920 
    40 - 59% = 1968 
    60 - 79% = 6667 
    80 - 99% = 8729 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1649, nodes: 1219820 
    Average node length: 5.80, total dup: 1137916, max dup: 99 
    Average key length: 2.86, compression ratio: 14.69 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 167676, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 284 
        40 - 59% = 849 
        60 - 79% = 424 
        80 - 99% = 91 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.04, total records: 9407591 
    Average version length: 68.97, total versions: 526731, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 89, data page slots: 143736 
    Data pages: 143712, average fill: 70% 
    Primary pages: 143712, secondary pages: 0, swept pages: 47416 
    Empty pages: 266, full pages: 82509 
    Fill distribution: 
     0 - 19% = 863 
    20 - 39% = 4095 
    40 - 59% = 18542 
    60 - 79% = 113194 
    80 - 99% = 7018 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13491, nodes: 9407591 
    Average node length: 6.68, total dup: 7803164, max dup: 27 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2036436, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1040 
        40 - 59% = 6665 
        60 - 79% = 5007 
        80 - 99% = 778 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21180771 
    Average version length: 82.84, total versions: 12018, 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: 319264 
    Data pages: 319264, average fill: 81% 
    Primary pages: 319264, secondary pages: 0, swept pages: 13238 
    Empty pages: 22, full pages: 318416 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 44 
    40 - 59% = 117 
    60 - 79% = 27787 
    80 - 99% = 291272 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19376, nodes: 21180771 
    Average node length: 5.72, total dup: 20699230, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285371, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8052 
        60 - 79% = 579 
        80 - 99% = 10738 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17226, nodes: 21180771 
    Average node length: 6.31, total dup: 18613530, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915131, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 10 
        40 - 59% = 816 
        60 - 79% = 283 
        80 - 99% = 16111 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21198, nodes: 21180771 
    Average node length: 6.35, total dup: 18532973, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3580071, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8408 
        60 - 79% = 632 
        80 - 99% = 12152 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16179, nodes: 21180771 
    Average node length: 5.56, total dup: 21180671, max dup: 230224 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943838, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 2978 
        60 - 79% = 420 
        80 - 99% = 12768 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 78.55, total records: 9799538 
    Average version length: 82.61, total versions: 459961, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 105, data page slots: 171240 
    Data pages: 171216, average fill: 71% 
    Primary pages: 171216, secondary pages: 0, swept pages: 69575 
    Empty pages: 330, full pages: 99517 
    Fill distribution: 
     0 - 19% = 1199 
    20 - 39% = 6336 
    40 - 59% = 26351 
    60 - 79% = 75578 
    80 - 99% = 61752 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11425, nodes: 9799538 
    Average node length: 5.37, total dup: 9489714, max dup: 174 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2153718, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 56 
        40 - 59% = 8067 
        60 - 79% = 3183 
        80 - 99% = 114 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13704, nodes: 9799538 
    Average node length: 6.24, total dup: 8124627, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1485741, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 130 
        20 - 39% = 4077 
        40 - 59% = 4440 
        60 - 79% = 2499 
        80 - 99% = 2558 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12749, nodes: 9799538 
    Average node length: 5.98, total dup: 8504761, max dup: 38 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2344485, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 69 
        40 - 59% = 9046 
        60 - 79% = 3484 
        80 - 99% = 148 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10315, nodes: 9799538 
    Average node length: 5.14, total dup: 9799438, max dup: 154399 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1532960, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1305 
        40 - 59% = 5198 
        60 - 79% = 1642 
        80 - 99% = 2128 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.00, total records: 11397282 
    Average version length: 82.46, total versions: 319700, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 118, data page slots: 191968 
    Data pages: 190720, average fill: 73% 
    Primary pages: 190720, secondary pages: 0, swept pages: 68960 
    Empty pages: 2817, full pages: 144504 
    Fill distribution: 
     0 - 19% = 4663 
    20 - 39% = 6827 
    40 - 59% = 17114 
    60 - 79% = 43473 
    80 - 99% = 118643 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13135, nodes: 11397282 
    Average node length: 5.30, total dup: 11287668, max dup: 671 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2371057, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 73 
        40 - 59% = 9136 
        60 - 79% = 3782 
        80 - 99% = 144 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10437, nodes: 11397282 
    Average node length: 5.49, total dup: 10900390, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 712200, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 164 
        20 - 39% = 833 
        40 - 59% = 2493 
        60 - 79% = 1770 
        80 - 99% = 5177 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15017, nodes: 11397282 
    Average node length: 6.02, total dup: 9946777, max dup: 80 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2387616, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 89 
        40 - 59% = 10612 
        60 - 79% = 4153 
        80 - 99% = 163 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10825, nodes: 11397282 
    Average node length: 5.22, total dup: 11397182, max dup: 191980 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 701022, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 83 
        20 - 39% = 822 
        40 - 59% = 4831 
        60 - 79% = 1514 
        80 - 99% = 3575 
 
XQS_2000_3300 (185) 
    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 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, 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: 1361755, 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: 1361754, 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: 1361752, 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: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 78.87, total records: 9920520 
    Average version length: 82.90, total versions: 464148, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 108, data page slots: 174704 
    Data pages: 174664, average fill: 70% 
    Primary pages: 174664, secondary pages: 0, swept pages: 72148 
    Empty pages: 428, full pages: 100206 
    Fill distribution: 
     0 - 19% = 1366 
    20 - 39% = 6834 
    40 - 59% = 27541 
    60 - 79% = 77456 
    80 - 99% = 61467 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11991, nodes: 9920520 
    Average node length: 5.18, total dup: 9891596, max dup: 1682 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1975002, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1465 
        40 - 59% = 8001 
        60 - 79% = 1880 
        80 - 99% = 609 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13804, nodes: 9920520 
    Average node length: 6.25, total dup: 8224388, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1468214, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 184 
        20 - 39% = 4041 
        40 - 59% = 4362 
        60 - 79% = 2501 
        80 - 99% = 2716 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12593, nodes: 9920520 
    Average node length: 5.43, total dup: 9477224, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2109937, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 18 
        20 - 39% = 1349 
        40 - 59% = 8954 
        60 - 79% = 1718 
        80 - 99% = 554 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10501, nodes: 9920520 
    Average node length: 5.15, total dup: 9920420, max dup: 157243 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 1566038, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1321 
        40 - 59% = 5403 
        60 - 79% = 1693 
        80 - 99% = 2056 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.41, total records: 582072 
    Average version length: 68.72, total versions: 6560, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8024 
    Data pages: 8024, average fill: 76% 
    Primary pages: 8024, secondary pages: 0, swept pages: 3499 
    Empty pages: 6, full pages: 7098 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 21 
    40 - 59% = 134 
    60 - 79% = 7745 
    80 - 99% = 117 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 38236, depth: 3, leaf buckets: 756, nodes: 582072 
    Average node length: 5.95, total dup: 495789, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101222, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 20 
        40 - 59% = 561 
        60 - 79% = 99 
        80 - 99% = 75 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 27897, depth: 3, leaf buckets: 771, nodes: 582072 
    Average node length: 6.15, total dup: 477391, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101281, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 33 
        40 - 59% = 544 
        60 - 79% = 92 
        80 - 99% = 100 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 573, nodes: 582072 
    Average node length: 4.86, total dup: 581972, max dup: 9725 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89814, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 333 
        60 - 79% = 83 
        80 - 99% = 127 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    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: 535, Index root page: 536 
    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: 539, Index root page: 540 
    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: 545, Index root page: 546 
    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: 1504207, 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: 547, Index root page: 548 
    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: 1504206, 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: 541, Index root page: 542 
    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: 1504212, 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: 1504213, 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: 543, Index root page: 544 
    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: 1504209, 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: 1504208, 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: 1504211, 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: 1504210, 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: 533, Index root page: 534 
    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: 531, Index root page: 532 
    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: 484, Index root page: 485 
    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: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Thu Feb 22 22:12:06 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7807725 101717 1 0.0000 0.0000
DOC_LIST 2280809 103847 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 255798 668 63900.0000 0.0000
INVNT_TURNOVER_LOG 65739 53213 1 0.0000 0.0000
MONEY_SALDO 49 18563 982 37800.0000 0.0000
MONEY_TURNOVER_LOG 1071 982 1 0.0000 0.0000
PDISTR 781584 65489 4 0.0000 0.0000
PERF_SPLIT_0 168154 2924 1 0.0000 0.0000
PERF_SPLIT_1 201784 24080 1 0.0000 0.0000
PERF_SPLIT_2 201221 17816 1 0.0000 0.0000
PERF_SPLIT_3 159332 6060 1 0.0000 0.0000
PERF_SPLIT_4 141127 6898 1 0.0000 0.0000
PERF_SPLIT_5 172211 6007 1 0.0000 0.0000
PERF_SPLIT_6 187671 10431 1 0.0000 0.0000
PERF_SPLIT_7 177285 4969 1 0.0000 0.0000
PERF_SPLIT_8 167578 6750 1 0.0000 0.0000
PERF_SPLIT_9 188787 13873 1 0.0000 0.0000
PSTORNED 2135986 43607 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 136235 56867 1 0.0000 0.0000
XQD_1000_3300 7055382 448941 1 0.0000 0.0000
XQD_1200_2000 12015459 343285 1 0.0000 0.0000
XQD_2000_3300 1583351 671836 1 0.0000 0.0000
XQD_2100_3300 1219820 510125 1 0.0000 0.0000
XQD_3300_3400 9407591 526731 1 0.0000 0.0000
XQS_1000_1200 21180771 12018 1 0.0000 0.0000
XQS_1000_3300 9799538 459961 1 0.0000 0.0000
XQS_1200_2000 11397282 319700 1 0.0000 0.0000
XQS_2100_3300 9920520 464148 1 0.0000 0.0000
XQS_3300_3400 582072 6560 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 ---
:1002: 
:1003: mscs-test-161.budzdorov.ru    Thu Feb 22 22:10:04 2024
:1004:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1005: 
:1006: 
:1007: mscs-test-161.budzdorov.ru    Thu Feb 22 22:10:05 2024
:1008:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1009: 
:1010: 
:1011: mscs-test-161.budzdorov.ru    Thu Feb 22 22:10:05 2024
:1012:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1013: 
--- end of diff output ---

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

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