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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-02-17 04:07:49
DTS_END                         2024-02-17 04:07:49.7360
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/45418
TRN_ID                          173199
ATT_ID                          494
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: 9283.50 22253 928350
customer order: creation 177.21 383 17721
customer order: refuse 14.78 380 1478
order to supplier: creation 48.21 1285 4821
order to supplier: removal 3.50 81421 350
invoice (draft): creation 46.69 3081 4669
invoice (draft): removal 49.16 731 4916
invoice accept: apply 44.29 20583 4429
invoice accept: cancel 44.67 857 4467
customer reserve: creation 4136.05 203 413605
customer reserve: removal 4420.95 51 442095
realization accept: apply 88.60 190 8860
realization accept: cancel 76.62 140 7662
payment from customer: creation 60.89 121 6089
payment from customer: removal 5.92 110 592
payment to supplier: creation 51.40 175 5140
payment to supplier: removal 3.53 69 353
service: total inventory turnovers 3.76 3980 376
service: total monetary turnovers 6.23 617 623
service: aggregate perf. data 1.01 16232 101
service: refresh index statistics 0.03 314453 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 17-02-2024 04:09:15 to 17-02-2024 04:09:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8029
TEST_TIME 2 6740
TEST_TIME 3 5807
TEST_TIME 4 6903
TEST_TIME 5 7499
TEST_TIME 6 7229
TEST_TIME 7 7557
TEST_TIME 8 7069
TEST_TIME 9 6865
TEST_TIME 10 6717
TEST_TIME 11 6686
TEST_TIME 12 6575
TEST_TIME 13 6437
TEST_TIME 14 6642
TEST_TIME 15 6808
TEST_TIME 16 6776
TEST_TIME 17 6803
TEST_TIME 18 7107
TEST_TIME 19 7133
TEST_TIME 20 7071
TEST_TIME 21 7554
TEST_TIME 22 7812
TEST_TIME 23 7949
TEST_TIME 24 8113
TEST_TIME 25 9098
TEST_TIME 26 9167
TEST_TIME 27 9089
TEST_TIME 28 9461
TEST_TIME 29 9292
TEST_TIME 30 9287
TEST_TIME 31 9253
TEST_TIME 32 9214
TEST_TIME 33 9424
TEST_TIME 34 9668
TEST_TIME 35 9609
TEST_TIME 36 9519
TEST_TIME 37 9342
TEST_TIME 38 9364
TEST_TIME 39 9136
TEST_TIME 40 9233
TEST_TIME 41 9395
TEST_TIME 42 9341
TEST_TIME 43 9247
TEST_TIME 44 9223
TEST_TIME 45 9169
TEST_TIME 46 9292
TEST_TIME 47 9255
TEST_TIME 48 9248
TEST_TIME 49 9262
TEST_TIME 50 9499
TEST_TIME 51 9485
TEST_TIME 52 9469
TEST_TIME 53 9673
TEST_TIME 54 9567
TEST_TIME 55 9547
TEST_TIME 56 9718
TEST_TIME 57 9726
TEST_TIME 58 9641
TEST_TIME 59 9537
TEST_TIME 60 9417
TEST_TIME 61 9466
TEST_TIME 62 9412
TEST_TIME 63 9311
TEST_TIME 64 9273
TEST_TIME 65 9279
TEST_TIME 66 9321
TEST_TIME 67 9300
TEST_TIME 68 9267
TEST_TIME 69 9223
TEST_TIME 70 9260
TEST_TIME 71 9244
TEST_TIME 72 9250
TEST_TIME 73 9238
TEST_TIME 74 9289
TEST_TIME 75 9271
TEST_TIME 76 9309
TEST_TIME 77 9320
TEST_TIME 78 9337
TEST_TIME 79 9325
TEST_TIME 80 9258
TEST_TIME 81 9248
TEST_TIME 82 9185
TEST_TIME 83 9150
TEST_TIME 84 9097
TEST_TIME 85 9108
TEST_TIME 86 9116
TEST_TIME 87 9135
TEST_TIME 88 9253
TEST_TIME 89 9199
TEST_TIME 90 9250
TEST_TIME 91 9251
TEST_TIME 92 9305
TEST_TIME 93 9315
TEST_TIME 94 9366
TEST_TIME 95 9350
TEST_TIME 96 9395
TEST_TIME 97 9462
TEST_TIME 98 9436
TEST_TIME 99 9365
TEST_TIME 100 9305

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-02-2024 04:09:19 to 17-02-2024 04:09:22.

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 1306109 1306109 0 0.00 0 24655 8 0 0
doc_list_biud 1306109 1306109 0 0.00 0 79958 22 0 0
sp_add_invoice_to_stock 4553 4429 124 2.72 35 199093 20583 0 124
sp_cancel_adding_invoice 4467 4467 0 0.00 4 48596 857 0 0
sp_cancel_client_order 1478 1478 0 0.00 4 11353 381 0 0
sp_cancel_customer_reserve 442095 442095 0 0.00 0 33851 51 0 0
sp_cancel_pay_from_customer 592 592 0 0.00 2 9796 111 0 0
sp_cancel_pay_to_supplier 353 353 0 0.00 2 4101 69 0 0
sp_cancel_supplier_invoice 4930 4916 14 0.28 2 79961 731 0 14
sp_cancel_supplier_order 350 350 0 0.00 5 1068776 81422 0 0
sp_cancel_write_off 7662 7662 0 0.00 1 13610 140 0 0
sp_client_order 17721 17721 0 0.00 3 53550 383 0 0
sp_customer_reserve 413605 413605 0 0.00 0 42180 204 0 0
sp_fill_shopping_cart 27192 27192 0 0.00 1 10486 35 0 0
sp_fill_shopping_cart_clo_res 413577 413577 0 0.00 0 18792 16 0 0
sp_get_clo_for_invoice 4401 4401 0 0.00 0 14971 304 0 0
sp_kill_cost_storno 13074 13074 0 0.00 0 13686 66 0 0
sp_kill_qstorno_ret_qs2qd 897118 897118 0 0.00 0 79957 28 0 0
sp_kill_qty_storno 474229 474229 0 0.00 0 79958 61 0 0
sp_lock_selected_doc 18173 18173 0 0.00 0 8287 6 0 0
sp_make_cost_storno 24490 24490 0 0.00 0 11820 68 0 0
sp_multiply_rows_for_pdistr 24490 24490 0 0.00 0 8678 35 0 0
sp_multiply_rows_for_qdistr 17721 17721 0 0.00 0 53537 203 0 0
sp_pay_from_customer 6089 6089 0 0.00 3 11470 121 0 0
sp_pay_to_supplier 5140 5140 0 0.00 4 12179 175 0 0
sp_payment_common 11229 11229 0 0.00 1 10813 26 0 0
sp_qd_handle_on_cancel_clo 1478 1478 0 0.00 0 11347 345 0 0
sp_qd_handle_on_invoice_upd_sts 8868 8868 0 0.00 0 29222 296 0 0
sp_qd_handle_on_reserve_upd_sts 8860 8860 0 0.00 0 8698 48 0 0
sp_reserve_write_off 8860 8860 0 0.00 6 18573 190 0 0
sp_supplier_invoice 4669 4669 0 0.00 5 100886 3081 0 0
sp_supplier_order 4821 4821 0 0.00 4 31033 1285 0 0
srv_aggregate_perf_data 101 101 0 0.00 1702 220888 16233 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1951 130267 40357 0 0
srv_find_qd_qs_mism 884105 884105 0 0.00 0 24653 7 0 0
srv_make_invnt_saldo 376 376 0 0.00 63 98026 3981 0 0
srv_make_money_saldo 623 623 0 0.00 1 16595 617 0 0
srv_recalc_idx_stat 3 3 0 0.00 216193 411835 314453 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4429 4429 0 0.00 0 25923 158 0 0
t$perf-norm:sp_cancel_adding_invoice 364 364 0 0.00 0 7010 118 0 0
t$perf-norm:sp_cancel_client_order 1478 1478 0 0.00 0 5867 16 0 0
t$perf-norm:sp_cancel_customer_reserve 567 567 0 0.00 0 5376 31 0 0
t$perf-norm:sp_cancel_pay_from_customer 592 592 0 0.00 0 1423 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 353 353 0 0.00 0 1914 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 340 340 0 0.00 0 523 13 0 0
t$perf-norm:sp_cancel_supplier_order 350 350 0 0.00 0 18622 1281 0 0
t$perf-norm:sp_cancel_write_off 868 868 0 0.00 0 552 3 0 0
t$perf-norm:sp_client_order 17721 17721 0 0.00 0 12017 18 0 0
t$perf-norm:sp_customer_reserve 876 876 0 0.00 0 3641 11 0 0
t$perf-norm:sp_pay_from_customer 6089 6089 0 0.00 0 2963 7 0 0
t$perf-norm:sp_pay_to_supplier 5140 5140 0 0.00 0 7631 12 0 0
t$perf-norm:sp_reserve_write_off 8860 8860 0 0.00 0 5917 9 0 0
t$perf-norm:sp_supplier_invoice 4669 4669 0 0.00 0 5846 15 0 0
t$perf-norm:sp_supplier_order 4821 4821 0 0.00 0 4079 14 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 166 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 339 7 0 0
t$perf-norm:srv_make_invnt_saldo 376 376 0 0.00 0 363 6 0 0
t$perf-norm:srv_make_money_saldo 623 623 0 0.00 0 3956 14 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 9050 8802 248 2.74 0 9768 19 0 248
v_all_customers 32472 32472 0 0.00 0 300 0 0 0
v_all_suppliers 26728 26728 0 0.00 0 17 1 0 0
v_all_wares 35442 35442 0 0.00 0 88 1 0 0
v_cancel_adding_invoice 728 728 0 0.00 0 2563 14 0 0
v_cancel_client_order 2956 2956 0 0.00 0 2768 5 0 0
v_cancel_customer_prepayment 1184 1184 0 0.00 0 9698 21 0 0
v_cancel_customer_reserve 1134 1134 0 0.00 0 1175 5 0 0
v_cancel_payment_to_supplier 706 706 0 0.00 0 877 4 0 0
v_cancel_supplier_invoice 708 680 28 3.95 0 1788 16 0 28
v_cancel_supplier_order 700 700 0 0.00 0 1810 8 0 0
v_cancel_write_off 1736 1736 0 0.00 0 9720 33 0 0
v_max_id_clo_ord 4813 4813 0 0.00 0 703 1 0 0
v_max_id_clo_res 876 876 0 0.00 0 4819 28 0 0
v_max_id_ord_sup 4657 4657 0 0.00 0 3955 4 0 0
v_max_non_paid_invoice 1246 1246 0 0.00 0 6630 9 0 0
v_max_non_paid_realizn 3126 3126 0 0.00 0 6741 6 0 0
v_min_id_clo_ord 4813 4813 0 0.00 0 5019 9 0 0
v_min_id_clo_res 876 876 0 0.00 0 1001 4 0 0
v_min_id_ord_sup 4657 4657 0 0.00 0 5969 12 0 0
v_min_non_paid_invoice 5140 5140 0 0.00 0 7841 18 0 0
v_min_non_paid_realizn 6089 6089 0 0.00 0 6747 18 0 0
v_our_firm 8896 8896 0 0.00 0 13 1 0 0
v_reserve_write_off 17720 17720 0 0.00 0 9779 11 0 0
x_lock_depdocs_on_canc_invoice 9043 9043 0 0.00 0 16786 114 0 0
x_lock_depdocs_on_canc_sup_ord 350 350 0 0.00 0 5860 258 0 0
x_make_qstorno_1000_1200 4821 4821 0 0.00 1 31016 1205 0 0
x_make_qstorno_1200_2000 4669 4669 0 0.00 2 95640 2957 0 0
x_make_qstorno_2100_3300 413605 413605 0 0.00 0 39913 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-02-2024 04:09:23 to 17-02-2024 04:09:27.

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
02:07:53 1 8192000000 8797256176 8807895040 3187328 0.038 1 1 2 0 3284944 61840 35776
02:08:54 32872 8192000000 9714938176 10007228416 790558256 8.801 100 89 178 0 819712944 7365200 21789488
02:10:28 17029 8192000000 9741609104 10044841984 814963440 9.048 100 85 170 0 846874736 11221632 20689664
02:11:52 25430 8192000000 9788182944 10101592064 851036064 9.410 100 86 172 1 889384032 17974384 20373584
02:13:19 10816 8192000000 9848275936 10177400832 903679888 9.935 100 79 158 0 950024672 28502816 17841968
02:14:35 5965 8192000000 9904388784 10242592768 945132704 10.343 100 79 157 0 1014508928 52998944 16377280
02:15:45 4029 8192000000 9955657664 10308657152 985943536 10.742 100 83 166 0 1070112640 67514080 16655024
02:16:54 3102 8192000000 10001031232 10361159680 1009457280 10.970 100 80 159 0 1120475648 95132016 15886352
02:18:00 1649 8192000000 10011611264 10378285056 1035277024 11.219 100 80 157 3 1121660560 70617760 15765776
02:19:03 1155 8192000000 10032045744 10404003840 1058928816 11.446 100 89 177 1 1147483664 71417136 17137712
02:20:05 1815 8192000000 10068850176 10451439616 1073749616 11.588 100 80 159 0 1186960640 97551504 15659520
02:21:08 33745 8192000000 9987851472 10391101440 1078987520 11.638 100 41 82 0 1125831088 38088528 8755040
02:22:46 5793 8192000000 10006908992 10406432768 1084095056 11.686 100 30 60 0 1115944416 25480528 6368832
02:23:54 4845 8192000000 10007871312 10403201024 1090440880 11.747 100 41 83 2 1115436704 16017232 8978592
02:24:59 10899 8192000000 10022104752 10439499776 1098296736 11.821 100 34 68 0 1145274992 40187040 6791216
02:26:16 22192 8192000000 10026130656 10417704960 1102022528 11.857 100 61 120 2 1128829840 13183216 13624096
02:27:39 5507 8192000000 10018557632 10427678720 1101749888 11.854 100 51 102 2 1132239024 19732176 10756960
02:28:50 2136 8192000000 10059864624 10464280576 1115263312 11.982 100 64 125 3 1174838304 46039184 13535808
02:30:05 13033 8192000000 10065733328 10469421056 1104089392 11.876 99 45 89 1 1180722864 67738176 8895296
02:31:22 9718 8192000000 10061125264 10483179520 1105810896 11.893 99 32 64 0 1170181840 57362976 7007968
02:32:37 6798 8192000000 10048883760 10451931136 1103648368 11.872 100 55 109 1 1167466912 53216048 10602496
02:33:47 26019 8192000000 10096824496 10506522624 1103668016 11.872 99 55 110 0 1191309840 76758624 10883200
02:35:21 5511 8192000000 10065445200 10459869184 1093610864 11.777 100 67 131 1 1174971696 67894352 13466480
02:36:29 25439 8192000000 10094894624 10493435904 1098935136 11.828 99 51 102 1 1182047184 72841440 10270608
02:37:58 18629 8192000000 10096732432 10514477056 1092859056 11.770 99 33 67 0 1221829152 122586544 6383552
02:39:22 7611 8192000000 10100423792 10503901184 1077883088 11.627 97 32 63 0 1195458128 110958064 6616976
02:40:34 12785 8192000000 10119770672 10515501056 1073076736 11.581 98 42 84 0 1208751792 125772400 9902656
02:41:55 20022 8192000000 10157288304 10556186624 1092230768 11.764 100 48 95 0 1260632336 157337680 11063888
02:43:25 54955 8192000000 10202489776 10610933760 1103994656 11.876 100 49 99 0 1293518464 178714512 10809296
02:45:27 4772 8192000000 10229843168 10630299648 1109619984 11.929 100 69 136 1 1341632688 216748496 15264208
02:46:40 5063 8192000000 10217348496 10621517824 1109644784 11.929 100 64 126 0 1321922384 196573088 15704512
02:47:49 1949 8192000000 10282500944 10676420608 1120692192 12.034 100 85 167 1 1383106496 242872688 19541616
02:48:53 11595 8192000000 10233250784 10646343680 1118156048 12.010 100 41 80 0 1341168400 213483328 9529024
02:50:26 24470 8192000000 10223536288 10659794944 1117083648 11.999 100 25 48 0 1323138768 200458704 5596416
02:51:59 5085 8192000000 10190100112 10611331072 1127861024 12.101 100 35 69 0 1295706496 158827088 9018384
02:53:08 35788 8192000000 10101377360 10542702592 1136903920 12.186 100 15 30 0 1197196848 57104192 3188736
02:54:45 2654 8192000000 10120843712 10534780928 1148692048 12.297 100 65 127 0 1217492608 54471648 14328912
02:55:50 55585 8192000000 10085246416 10533224448 1132275728 12.143 99 6 12 0 1181737136 48213712 1247696
02:57:47 14340 8192000000 10099098416 10550358016 1142355120 12.238 100 37 70 0 1195100592 45526896 7218576
02:59:07 48723 8192000000 10164590624 10620276736 1158914512 12.393 100 16 32 0 1265502992 102897232 3691248
03:01:07 70357 8192000000 10095711520 10598772736 1140514336 12.220 99 3 7 0 1195150688 54154512 481840
03:03:22 130266 8192000000 10147532816 10591916032 1170178880 12.499 100 38 75 0 1231884288 53485888 8219520
03:06:34 37609 8192000000 10157838848 10599006208 1163913696 12.440 99 42 84 0 1252611392 79068752 9628944
03:08:13 20842 8192000000 10192722176 10641723392 1180043120 12.591 100 52 104 0 1274754400 83835824 10875456
03:09:43 18850 8192000000 10116450944 10625204224 1173475360 12.529 100 8 14 0 1230704624 56084800 1144464
03:11:03 22696 8192000000 10094547104 10570022912 1159249600 12.396 100 13 26 1 1202788912 40616096 2923216
03:12:27 65047 8192000000 10125249392 10587226112 1141660816 12.231 98 22 44 0 1229185632 82998064 4526752
03:14:43 23773 8192000000 10120888464 10554789888 1117342496 12.002 98 35 70 0 1194067440 69281296 7443648
03:16:09 42275 8192000000 10133034608 10604609536 1137529248 12.192 100 15 31 0 1240702816 99477120 3696448
03:17:56 40230 8192000000 10053921008 10499645440 1082070064 11.667 96 30 60 0 1149026128 60097840 6858224
03:19:42 41108 8192000000 10072828432 10556252160 1098613456 11.824 99 31 62 0 1196233280 91272288 6347536
03:21:25 43111 8192000000 10091079536 10503692288 1096842784 11.808 98 42 82 0 1162090880 56603248 8644848
03:23:14 40673 8192000000 10079770112 10511077376 1087513488 11.719 98 20 40 0 1176707616 85429184 3764944
03:25:00 108395 8192000000 10027194272 10454142976 1073189760 11.583 97 21 38 3 1109582112 32575920 3816432
03:28:24 32750 8192000000 10045316816 10470920192 1093722176 11.778 100 27 54 0 1147312464 48136144 5454144
03:30:02 47946 8192000000 10069944992 10515021824 1089484160 11.738 99 10 19 0 1156921680 65336448 2101072
03:31:50 37914 8192000000 10095705280 10537676800 1080910528 11.656 98 27 53 0 1172884464 85227440 6746496
03:33:31 59005 8192000000 10066898848 10532511744 1099186224 11.830 99 13 24 1 1155003520 53964096 1853200
03:35:30 95861 8192000000 10095103440 10567143424 1130874240 12.130 100 29 58 0 1180349584 43554160 5921184
03:38:28 73793 8192000000 10091563680 10551951360 1116206528 11.991 98 22 44 0 1148658112 28687968 3763616
03:41:16 45989 8192000000 10061097760 10523369472 1119442336 12.022 98 13 26 0 1164662416 42897936 2322144
03:43:05 17840 8192000000 10103564768 10517762048 1118271776 12.011 99 46 90 0 1189940288 62866656 8801856
03:44:24 30548 8192000000 10069871120 10499641344 1133449600 12.154 100 34 68 0 1165450080 24884608 7115872
03:45:55 45286 8192000000 10118980464 10557374464 1140292496 12.218 100 31 62 0 1221754352 75392192 6069664
03:47:41 108418 8192000000 10089368624 10550386688 1149707952 12.307 100 24 49 0 1191168720 36203040 5257728
03:50:30 99802 8192000000 10163730400 10619830272 1160326960 12.406 100 19 38 1 1245967072 80833680 4806432
03:53:10 78833 8192000000 10148563184 10646614016 1150188624 12.311 99 14 28 0 1230934416 77517856 3227936
03:55:29 65840 8192000000 10101239888 10568237056 1142039840 12.235 98 21 41 1 1261009344 114614592 4354912
03:57:35 62773 8192000000 10117889600 10620293120 1138717472 12.203 98 9 18 0 1221695280 80866784 2111024
03:59:41 50149 8192000000 10125378944 10578931712 1149484272 12.305 100 24 48 0 1195896752 41234704 5177776
04:02:05 31854 8192000000 10094930640 10544209920 1127201584 12.095 98 21 42 0 1178866816 47370528 4294704
04:04:23 75186 8192000000 10092103920 10567933952 1091425696 11.756 95 15 30 0 1135734960 41317472 2991792
04:06:40 82215 8192000000 9158590128 9408299008 315136432 3.704 29 11 22 0 325501360 8454880 1910048

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 17-02-2024 04:09:29 to 17-02-2024 04:09:43.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-02-2024 04:09:44 to 17-02-2024 04:09:46.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          172272
MON$OLDEST_ACTIVE               173581
MON$OLDEST_SNAPSHOT             173581
MON$NEXT_TRANSACTION            173581
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1927584
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             689
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Sat Feb 17 04:09:47 2024 
 
Database header page information: 
    Flags            0 
    Generation        90591 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    172272 
    Oldest active        173581 
    Oldest snapshot        173581 
    Next transaction    173582 
    Sequence number        0 
    Next attachment ID    689 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.66, total records: 7694067 
    Average version length: 48.16, total versions: 46116, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 55, data page slots: 89216 
    Data pages: 89216, average fill: 69% 
    Primary pages: 89215, secondary pages: 1, swept pages: 49158 
    Empty pages: 2, full pages: 54644 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 73 
    40 - 59% = 3887 
    60 - 79% = 85206 
    80 - 99% = 27 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23201, nodes: 7694067 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1661152, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 354 
        20 - 39% = 2155 
        40 - 59% = 3738 
        60 - 79% = 2436 
        80 - 99% = 14518 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13438, nodes: 7694067 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1485562, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1781 
        40 - 59% = 1739 
        60 - 79% = 1158 
        80 - 99% = 8760 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8295, nodes: 7694067 
    Average node length: 6.61, total dup: 5764111, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1478636, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 116 
        20 - 39% = 1117 
        40 - 59% = 1199 
        60 - 79% = 960 
        80 - 99% = 4903 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.88, total records: 2221195 
    Average version length: 58.86, total versions: 25157, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28992 
    Data pages: 28992, average fill: 70% 
    Primary pages: 28991, secondary pages: 1, swept pages: 17978 
    Empty pages: 1, full pages: 12350 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 65 
    40 - 59% = 1050 
    60 - 79% = 27826 
    80 - 99% = 44 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4528, nodes: 2221195 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 669292, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1008 
        40 - 59% = 727 
        60 - 79% = 767 
        80 - 99% = 2026 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2422, nodes: 2221912 
    Average node length: 4.97, total dup: 2221014, max dup: 19302 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1253515, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 243 
        40 - 59% = 1393 
        60 - 79% = 528 
        80 - 99% = 255 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1799, nodes: 2221195 
    Average node length: 4.97, total dup: 2221145, max dup: 130136 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1066859, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 17 
        40 - 59% = 635 
        60 - 79% = 50 
        80 - 99% = 1097 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4322, nodes: 2221195 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 669292, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 74 
        20 - 39% = 674 
        40 - 59% = 547 
        60 - 79% = 873 
        80 - 99% = 2154 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.37, total records: 400 
    Average version length: 18.96, total versions: 2742, max versions: 8 
    Average fragment length: 2.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 54% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 4, full pages: 14 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 14 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 14.08, total records: 94477 
    Average version length: 68.29, total versions: 86380, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.25 
    Pointer pages: 6, data page slots: 4152 
    Data pages: 2040, average fill: 63% 
    Primary pages: 2039, secondary pages: 1, swept pages: 214 
    Empty pages: 344, full pages: 1114 
    Fill distribution: 
     0 - 19% = 416 
    20 - 39% = 188 
    40 - 59% = 181 
    60 - 79% = 228 
    80 - 99% = 1027 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1708913, depth: 3, leaf buckets: 401, nodes: 94477 
    Average node length: 13.27, total dup: 7830, max dup: 2 
    Average key length: 10.64, compression ratio: 2.54 
    Average prefix length: 19.27, average data length: 7.73 
    Clustering factor: 67501, ratio: 0.71 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 237 
        40 - 59% = 163 
        60 - 79% = 1 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 171, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 75% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.85, total records: 1753 
    Average version length: 43.62, total versions: 1557, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.51 
    Pointer pages: 1, data page slots: 40 
    Data pages: 39, average fill: 47% 
    Primary pages: 38, secondary pages: 1, swept pages: 9 
    Empty pages: 11, full pages: 15 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 5 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 14 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 97650, depth: 2, leaf buckets: 3, nodes: 1753 
    Average node length: 4.23, total dup: 1656, max dup: 193 
    Average key length: 2.59, compression ratio: 7.33 
    Average prefix length: 18.46, average data length: 0.54 
    Clustering factor: 946, ratio: 0.54 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 3 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.67, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 37.13, total records: 797592 
    Average version length: 37.93, total versions: 14330, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.45 
    Pointer pages: 6, data page slots: 8608 
    Data pages: 8608, average fill: 63% 
    Primary pages: 8606, secondary pages: 2, swept pages: 4611 
    Empty pages: 12, full pages: 3614 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 42 
    40 - 59% = 1335 
    60 - 79% = 7182 
    80 - 99% = 24 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 879, nodes: 791400 
    Average node length: 4.88, total dup: 791351, max dup: 153824 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89720, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 157 
        40 - 59% = 470 
        60 - 79% = 167 
        80 - 99% = 84 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 912, nodes: 791400 
    Average node length: 5.89, total dup: 704499, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 158221, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 39 
        40 - 59% = 464 
        60 - 79% = 104 
        80 - 99% = 304 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 947, nodes: 791400 
    Average node length: 5.90, total dup: 704499, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160029, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 95 
        40 - 59% = 462 
        60 - 79% = 108 
        80 - 99% = 281 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1130, nodes: 791400 
    Average node length: 5.98, total dup: 704499, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 152263, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 261 
        40 - 59% = 570 
        60 - 79% = 209 
        80 - 99% = 88 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5477 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 4.17, total fragments: 23, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 82, secondary pages: 14, swept pages: 66 
    Empty pages: 14, full pages: 51 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 72 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5477 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.07 
    Average prefix length: 34.47, average data length: 1.54 
    Clustering factor: 5247, ratio: 0.96 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5477 
    Average node length: 11.13, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 158, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.05, total records: 78548 
    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: 816 
    Data pages: 816, average fill: 66% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 815 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 815 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35586, depth: 2, leaf buckets: 101, nodes: 78548 
    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: 3153, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.15, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.20, total records: 161980 
    Average version length: 148.76, total versions: 2199, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 5240 
    Data pages: 4064, average fill: 82% 
    Primary pages: 4061, secondary pages: 3, swept pages: 14 
    Empty pages: 73, full pages: 3966 
    Fill distribution: 
     0 - 19% = 79 
    20 - 39% = 7 
    40 - 59% = 7 
    60 - 79% = 8 
    80 - 99% = 3963 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.17, total records: 143355 
    Average version length: 144.76, total versions: 1046, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 6, data page slots: 3944 
    Data pages: 3584, average fill: 82% 
    Primary pages: 3582, secondary pages: 2, swept pages: 5 
    Empty pages: 49, full pages: 3510 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 3509 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 133.71, total records: 181343 
    Average version length: 154.61, total versions: 22123, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.68 
    Pointer pages: 7, data page slots: 6736 
    Data pages: 4592, average fill: 83% 
    Primary pages: 4591, secondary pages: 1, swept pages: 8 
    Empty pages: 122, full pages: 4442 
    Fill distribution: 
     0 - 19% = 124 
    20 - 39% = 15 
    40 - 59% = 5 
    60 - 79% = 8 
    80 - 99% = 4440 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 148.32, total records: 147543 
    Average version length: 151.68, total versions: 2762, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.43 
    Pointer pages: 7, data page slots: 4744 
    Data pages: 3704, average fill: 82% 
    Primary pages: 3702, secondary pages: 2, swept pages: 5 
    Empty pages: 68, full pages: 3611 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 6 
    40 - 59% = 9 
    60 - 79% = 5 
    80 - 99% = 3609 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 146.43, total records: 141784 
    Average version length: 151.85, total versions: 4356, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 7, data page slots: 4968 
    Data pages: 3536, average fill: 83% 
    Primary pages: 3533, secondary pages: 3, swept pages: 5 
    Empty pages: 47, full pages: 3462 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 4 
    40 - 59% = 11 
    60 - 79% = 6 
    80 - 99% = 3462 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 148.81, total records: 157288 
    Average version length: 151.62, total versions: 2481, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 5416 
    Data pages: 3928, average fill: 83% 
    Primary pages: 3926, secondary pages: 2, swept pages: 3 
    Empty pages: 57, full pages: 3851 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 3 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 3852 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 144.33, total records: 155479 
    Average version length: 154.03, total versions: 7393, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.75 
    Pointer pages: 8, data page slots: 4744 
    Data pages: 3944, average fill: 82% 
    Primary pages: 3942, secondary pages: 2, swept pages: 7 
    Empty pages: 104, full pages: 3808 
    Fill distribution: 
     0 - 19% = 111 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 9 
    80 - 99% = 3806 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 149.26, total records: 156580 
    Average version length: 150.46, total versions: 2281, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.36 
    Pointer pages: 6, data page slots: 5216 
    Data pages: 3952, average fill: 82% 
    Primary pages: 3949, secondary pages: 3, swept pages: 6 
    Empty pages: 80, full pages: 3838 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 12 
    40 - 59% = 3 
    60 - 79% = 10 
    80 - 99% = 3836 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 149.17, total records: 160446 
    Average version length: 150.67, total versions: 2496, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 5, data page slots: 4912 
    Data pages: 4032, average fill: 82% 
    Primary pages: 4030, secondary pages: 2, swept pages: 7 
    Empty pages: 70, full pages: 3938 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3938 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 149.11, total records: 159313 
    Average version length: 151.53, total versions: 2508, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 7, data page slots: 4960 
    Data pages: 4000, average fill: 82% 
    Primary pages: 3999, secondary pages: 1, swept pages: 2 
    Empty pages: 69, full pages: 3908 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 4 
    80 - 99% = 3909 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 52.25, total records: 2078980 
    Average version length: 52.83, total versions: 23849, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25840 
    Data pages: 25840, average fill: 69% 
    Primary pages: 25825, secondary pages: 15, swept pages: 12886 
    Empty pages: 193, full pages: 20851 
    Fill distribution: 
     0 - 19% = 390 
    20 - 39% = 406 
    40 - 59% = 1266 
    60 - 79% = 23539 
    80 - 99% = 239 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2590, nodes: 2078980 
    Average node length: 5.45, total dup: 1938683, max dup: 1624 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180909, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 307 
        40 - 59% = 1709 
        60 - 79% = 306 
        80 - 99% = 265 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2759, nodes: 2078980 
    Average node length: 5.70, total dup: 1865386, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372197, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2461 
        60 - 79% = 271 
        80 - 99% = 19 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2129, nodes: 2078980 
    Average node length: 4.96, total dup: 2078880, max dup: 28164 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 179031, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 220 
        40 - 59% = 1135 
        60 - 79% = 354 
        80 - 99% = 420 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 53.74, total records: 108659 
    Average version length: 69.19, total versions: 27926, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.34 
    Pointer pages: 3, data page slots: 4176 
    Data pages: 3080, average fill: 42% 
    Primary pages: 3079, secondary pages: 1, swept pages: 807 
    Empty pages: 528, full pages: 358 
    Fill distribution: 
     0 - 19% = 751 
    20 - 39% = 498 
    40 - 59% = 971 
    60 - 79% = 737 
    80 - 99% = 123 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1558490, depth: 3, leaf buckets: 215, nodes: 108659 
    Average node length: 6.57, total dup: 94548, max dup: 14 
    Average key length: 4.01, compression ratio: 10.46 
    Average prefix length: 40.11, average data length: 1.89 
    Clustering factor: 18942, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 113 
        40 - 59% = 86 
        60 - 79% = 16 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 67.47, total records: 6949672 
    Average version length: 68.69, total versions: 172938, 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: 66, data page slots: 106504 
    Data pages: 106504, average fill: 70% 
    Primary pages: 106503, secondary pages: 1, swept pages: 61207 
    Empty pages: 27, full pages: 45849 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 482 
    40 - 59% = 8729 
    60 - 79% = 96569 
    80 - 99% = 635 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10693, nodes: 6949672 
    Average node length: 6.51, total dup: 6010445, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1606822, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 14 
        20 - 39% = 1763 
        40 - 59% = 5992 
        60 - 79% = 2433 
        80 - 99% = 491 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8522, nodes: 6949672 
    Average node length: 5.40, total dup: 6672568, max dup: 153 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1420383, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1193 
        40 - 59% = 4985 
        60 - 79% = 1408 
        80 - 99% = 926 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8555, nodes: 6949672 
    Average node length: 5.40, total dup: 6672568, max dup: 153 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1422652, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1260 
        40 - 59% = 4888 
        60 - 79% = 1471 
        80 - 99% = 927 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 68.18, total records: 12015546 
    Average version length: 68.71, total versions: 153290, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 108, data page slots: 175624 
    Data pages: 175624, average fill: 73% 
    Primary pages: 175623, secondary pages: 1, swept pages: 98418 
    Empty pages: 6, full pages: 131407 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 388 
    40 - 59% = 5679 
    60 - 79% = 168578 
    80 - 99% = 952 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18408, nodes: 12014033 
    Average node length: 6.62, total dup: 10471842, max dup: 70 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2456860, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 2228 
        40 - 59% = 10930 
        60 - 79% = 4402 
        80 - 99% = 819 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 52.86, total records: 1223168 
    Average version length: 69.06, total versions: 167914, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.38 
    Pointer pages: 27, data page slots: 42088 
    Data pages: 28672, average fill: 44% 
    Primary pages: 28608, secondary pages: 64, swept pages: 14929 
    Empty pages: 5277, full pages: 12110 
    Fill distribution: 
     0 - 19% = 8327 
    20 - 39% = 5061 
    40 - 59% = 3142 
    60 - 79% = 9990 
    80 - 99% = 2152 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1717, nodes: 1059745 
    Average node length: 5.56, total dup: 1016457, max dup: 49 
    Average key length: 2.59, compression ratio: 16.23 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 74632, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 787 
        40 - 59% = 745 
        60 - 79% = 171 
        80 - 99% = 8 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 54.75, total records: 915615 
    Average version length: 69.03, total versions: 63421, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.30 
    Pointer pages: 19, data page slots: 29888 
    Data pages: 26120, average fill: 36% 
    Primary pages: 26120, secondary pages: 0, swept pages: 12303 
    Empty pages: 2863, full pages: 1436 
    Fill distribution: 
     0 - 19% = 5854 
    20 - 39% = 8054 
    40 - 59% = 9317 
    60 - 79% = 2887 
    80 - 99% = 8 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1236, nodes: 761383 
    Average node length: 5.91, total dup: 704350, max dup: 50 
    Average key length: 2.97, compression ratio: 14.15 
    Average prefix length: 41.11, average data length: 0.89 
    Clustering factor: 110493, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 449 
        40 - 59% = 633 
        60 - 79% = 149 
        80 - 99% = 5 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 67.85, total records: 8826141 
    Average version length: 68.92, total versions: 152543, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 90, data page slots: 146856 
    Data pages: 146816, average fill: 64% 
    Primary pages: 146793, secondary pages: 23, swept pages: 101227 
    Empty pages: 511, full pages: 43152 
    Fill distribution: 
     0 - 19% = 1678 
    20 - 39% = 7040 
    40 - 59% = 30662 
    60 - 79% = 106741 
    80 - 99% = 695 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13462, nodes: 8824945 
    Average node length: 6.70, total dup: 7318802, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2001798, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1793 
        40 - 59% = 7049 
        60 - 79% = 4165 
        80 - 99% = 454 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21122640 
    Average version length: 82.84, total versions: 4695, 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: 319472 
    Data pages: 319472, average fill: 81% 
    Primary pages: 319467, secondary pages: 5, swept pages: 13449 
    Empty pages: 44, full pages: 318311 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 59 
    40 - 59% = 179 
    60 - 79% = 48743 
    80 - 99% = 270425 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19358, nodes: 21122640 
    Average node length: 5.72, total dup: 20642357, max dup: 136 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280156, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 8132 
        60 - 79% = 520 
        80 - 99% = 10700 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17161, nodes: 21122640 
    Average node length: 6.31, total dup: 18561759, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 917879, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 7 
        40 - 59% = 774 
        60 - 79% = 297 
        80 - 99% = 16080 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21198, nodes: 21122640 
    Average node length: 6.35, total dup: 18481438, max dup: 25 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3574121, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8490 
        60 - 79% = 625 
        80 - 99% = 12075 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16193, nodes: 21122640 
    Average node length: 5.56, total dup: 21122540, max dup: 229395 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 946612, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 21 
        40 - 59% = 3121 
        60 - 79% = 355 
        80 - 99% = 12695 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 74.73, total records: 10194933 
    Average version length: 82.61, total versions: 1066293, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.69 
    Pointer pages: 107, data page slots: 173448 
    Data pages: 173416, average fill: 74% 
    Primary pages: 173387, secondary pages: 29, swept pages: 33744 
    Empty pages: 447, full pages: 131841 
    Fill distribution: 
     0 - 19% = 1376 
    20 - 39% = 4642 
    40 - 59% = 15204 
    60 - 79% = 106170 
    80 - 99% = 46024 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11386, nodes: 10194933 
    Average node length: 5.36, total dup: 9883051, max dup: 286 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2311754, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 29 
        40 - 59% = 6633 
        60 - 79% = 4535 
        80 - 99% = 187 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13657, nodes: 10194933 
    Average node length: 6.24, total dup: 8455381, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1625982, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 3473 
        40 - 59% = 4476 
        60 - 79% = 2627 
        80 - 99% = 2955 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12713, nodes: 10194933 
    Average node length: 5.97, total dup: 8872180, max dup: 44 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2514277, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 35 
        40 - 59% = 7578 
        60 - 79% = 4885 
        80 - 99% = 212 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10448, nodes: 10194933 
    Average node length: 5.14, total dup: 10194833, max dup: 156554 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1657818, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1048 
        40 - 59% = 5242 
        60 - 79% = 1815 
        80 - 99% = 2302 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 77.14, total records: 11655259 
    Average version length: 82.51, total versions: 821232, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 119, data page slots: 193840 
    Data pages: 192568, average fill: 75% 
    Primary pages: 192414, secondary pages: 154, swept pages: 43283 
    Empty pages: 1827, full pages: 159759 
    Fill distribution: 
     0 - 19% = 3068 
    20 - 39% = 4710 
    40 - 59% = 12114 
    60 - 79% = 88908 
    80 - 99% = 83768 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13141, nodes: 11655259 
    Average node length: 5.31, total dup: 11545217, max dup: 696 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2446163, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 36 
        40 - 59% = 8433 
        60 - 79% = 4393 
        80 - 99% = 277 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10507, nodes: 11655259 
    Average node length: 5.51, total dup: 11147457, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 754152, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 127 
        20 - 39% = 732 
        40 - 59% = 2458 
        60 - 79% = 1748 
        80 - 99% = 5442 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15035, nodes: 11655259 
    Average node length: 6.03, total dup: 10182104, max dup: 76 
    Average key length: 2.80, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2462779, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 43 
        40 - 59% = 9865 
        60 - 79% = 4830 
        80 - 99% = 295 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10934, nodes: 11655259 
    Average node length: 5.23, total dup: 11655159, max dup: 195604 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 741379, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 91 
        20 - 39% = 729 
        40 - 59% = 4823 
        60 - 79% = 1459 
        80 - 99% = 3832 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 75.15, total records: 10303790 
    Average version length: 82.89, total versions: 1059556, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.68 
    Pointer pages: 109, data page slots: 176568 
    Data pages: 176552, average fill: 73% 
    Primary pages: 176525, secondary pages: 27, swept pages: 35332 
    Empty pages: 428, full pages: 130840 
    Fill distribution: 
     0 - 19% = 1318 
    20 - 39% = 4927 
    40 - 59% = 16849 
    60 - 79% = 108057 
    80 - 99% = 45401 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12223, nodes: 10303790 
    Average node length: 5.18, total dup: 10274185, max dup: 1696 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2123273, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1325 
        40 - 59% = 8080 
        60 - 79% = 2127 
        80 - 99% = 662 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13816, nodes: 10303790 
    Average node length: 6.25, total dup: 8544762, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1597099, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 199 
        20 - 39% = 3482 
        40 - 59% = 4435 
        60 - 79% = 2619 
        80 - 99% = 3081 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12883, nodes: 10303790 
    Average node length: 5.44, total dup: 9850473, max dup: 108 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2263352, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1239 
        40 - 59% = 9168 
        60 - 79% = 1808 
        80 - 99% = 637 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10615, nodes: 10303790 
    Average node length: 5.16, total dup: 10303690, max dup: 158695 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1684244, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1163 
        40 - 59% = 5300 
        60 - 79% = 1759 
        80 - 99% = 2345 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 66.75, total records: 585901 
    Average version length: 68.76, total versions: 14069, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8104 
    Data pages: 8104, average fill: 76% 
    Primary pages: 8104, secondary pages: 0, swept pages: 2353 
    Empty pages: 7, full pages: 7850 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 1 
    40 - 59% = 16 
    60 - 79% = 7835 
    80 - 99% = 245 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45648, depth: 3, leaf buckets: 743, nodes: 585901 
    Average node length: 5.95, total dup: 499064, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102773, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 16 
        40 - 59% = 527 
        60 - 79% = 111 
        80 - 99% = 89 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 38302, depth: 3, leaf buckets: 761, nodes: 585901 
    Average node length: 6.15, total dup: 480580, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102831, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 26 
        40 - 59% = 530 
        60 - 79% = 109 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 562, nodes: 585901 
    Average node length: 4.86, total dup: 585801, max dup: 10027 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 91324, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 31 
        40 - 59% = 308 
        60 - 79% = 66 
        80 - 99% = 155 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Sat Feb 17 04:10:11 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7694067 46116 1 0.0000 0.0000
DOC_LIST 2221195 25157 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2742 8 600.0000 0.0000
INVNT_TURNOVER_LOG 94477 86380 1 0.0000 0.0000
MONEY_SALDO 49 171 6 300.0000 0.0000
MONEY_TURNOVER_LOG 1753 1557 1 0.0000 0.0000
PDISTR 797592 14330 2 0.0000 0.0000
PERF_SPLIT_0 161980 2199 1 0.0000 0.0000
PERF_SPLIT_1 143355 1046 1 0.0000 0.0000
PERF_SPLIT_2 181343 22123 1 0.0000 0.0000
PERF_SPLIT_3 147543 2762 1 0.0000 0.0000
PERF_SPLIT_4 141784 4356 1 0.0000 0.0000
PERF_SPLIT_5 157288 2481 1 0.0000 0.0000
PERF_SPLIT_6 155479 7393 1 0.0000 0.0000
PERF_SPLIT_7 156580 2281 1 0.0000 0.0000
PERF_SPLIT_8 160446 2496 1 0.0000 0.0000
PERF_SPLIT_9 159313 2508 1 0.0000 0.0000
PSTORNED 2078980 23849 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 108659 27926 1 0.0000 0.0000
XQD_1000_3300 6949672 172938 1 0.0000 0.0000
XQD_1200_2000 12015546 153290 1 0.0000 0.0000
XQD_2000_3300 1223168 167914 1 0.0000 0.0000
XQD_2100_3300 915615 63421 1 0.0000 0.0000
XQD_3300_3400 8826141 152543 1 0.0000 0.0000
XQS_1000_1200 21122640 4695 1 0.0000 0.0000
XQS_1000_3300 10194933 1066293 1 0.0000 0.0000
XQS_1200_2000 11655259 821232 1 0.0000 0.0000
XQS_2100_3300 10303790 1059556 1 0.0000 0.0000
XQS_3300_3400 585901 14069 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 ---
:93: 
:94: mscs-test-161.budzdorov.ru    Sat Feb 17 04:08:04 2024
:95:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:96: 
--- end of diff output ---

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

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