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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15603156 kB
MemAvailable 30245768 kB
Buffers 0 kB
Cached 16123736 kB
SwapCached 2472 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-25 10:07:48
DTS_END                         2024-02-25 10:07:48.8690
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/46322
TRN_ID                          177580
ATT_ID                          569
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: 9443.63 16488 944363
customer order: creation 189.57 365 18957
customer order: refuse 16.84 345 1684
order to supplier: creation 49.84 1267 4984
order to supplier: removal 3.36 79983 336
invoice (draft): creation 49.86 3342 4986
invoice (draft): removal 48.11 647 4811
invoice accept: apply 45.02 20356 4502
invoice accept: cancel 43.77 784 4377
customer reserve: creation 4352.91 194 435291
customer reserve: removal 4341.04 49 434104
realization accept: apply 89.84 197 8984
realization accept: cancel 73.96 120 7396
payment from customer: creation 65.35 110 6535
payment from customer: removal 6.62 100 662
payment to supplier: creation 52.71 134 5271
payment to supplier: removal 3.62 79 362
service: total inventory turnovers 3.69 4274 369
service: total monetary turnovers 6.40 582 640
service: aggregate perf. data 1.08 12076 108
service: refresh index statistics 0.04 204754 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 25-02-2024 10:08:54 to 25-02-2024 10:08:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2312
TEST_TIME 2 3112
TEST_TIME 3 4623
TEST_TIME 4 5241
TEST_TIME 5 5888
TEST_TIME 6 6032
TEST_TIME 7 6558
TEST_TIME 8 6502
TEST_TIME 9 6647
TEST_TIME 10 7073
TEST_TIME 11 7293
TEST_TIME 12 7758
TEST_TIME 13 7809
TEST_TIME 14 7745
TEST_TIME 15 8219
TEST_TIME 16 8257
TEST_TIME 17 8154
TEST_TIME 18 8066
TEST_TIME 19 8280
TEST_TIME 20 8459
TEST_TIME 21 8790
TEST_TIME 22 8783
TEST_TIME 23 9155
TEST_TIME 24 9266
TEST_TIME 25 9144
TEST_TIME 26 9017
TEST_TIME 27 9252
TEST_TIME 28 9364
TEST_TIME 29 9193
TEST_TIME 30 9555
TEST_TIME 31 9515
TEST_TIME 32 9499
TEST_TIME 33 9621
TEST_TIME 34 9675
TEST_TIME 35 9716
TEST_TIME 36 9694
TEST_TIME 37 9801
TEST_TIME 38 9691
TEST_TIME 39 9500
TEST_TIME 40 9407
TEST_TIME 41 9489
TEST_TIME 42 9335
TEST_TIME 43 9345
TEST_TIME 44 9267
TEST_TIME 45 9481
TEST_TIME 46 9456
TEST_TIME 47 9318
TEST_TIME 48 9296
TEST_TIME 49 9282
TEST_TIME 50 9395
TEST_TIME 51 9485
TEST_TIME 52 9539
TEST_TIME 53 9722
TEST_TIME 54 9664
TEST_TIME 55 9713
TEST_TIME 56 9734
TEST_TIME 57 9724
TEST_TIME 58 9810
TEST_TIME 59 9826
TEST_TIME 60 9735
TEST_TIME 61 9631
TEST_TIME 62 9683
TEST_TIME 63 9609
TEST_TIME 64 9630
TEST_TIME 65 9565
TEST_TIME 66 9492
TEST_TIME 67 9508
TEST_TIME 68 9381
TEST_TIME 69 9395
TEST_TIME 70 9415
TEST_TIME 71 9427
TEST_TIME 72 9381
TEST_TIME 73 9412
TEST_TIME 74 9408
TEST_TIME 75 9501
TEST_TIME 76 9562
TEST_TIME 77 9509
TEST_TIME 78 9513
TEST_TIME 79 9565
TEST_TIME 80 9567
TEST_TIME 81 9621
TEST_TIME 82 9605
TEST_TIME 83 9733
TEST_TIME 84 9660
TEST_TIME 85 9574
TEST_TIME 86 9500
TEST_TIME 87 9489
TEST_TIME 88 9455
TEST_TIME 89 9464
TEST_TIME 90 9435
TEST_TIME 91 9390
TEST_TIME 92 9371
TEST_TIME 93 9373
TEST_TIME 94 9390
TEST_TIME 95 9417
TEST_TIME 96 9427
TEST_TIME 97 9396
TEST_TIME 98 9474
TEST_TIME 99 9473
TEST_TIME 100 9449

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-02-2024 10:08:57 to 25-02-2024 10:09:00.

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 1341096 1341096 0 0.00 0 22740 8 0 0
doc_list_biud 1341095 1341095 0 0.00 0 56900 21 0 0
sp_add_invoice_to_stock 4620 4502 118 2.55 24 173241 20356 0 118
sp_cancel_adding_invoice 4377 4377 0 0.00 4 57745 785 0 0
sp_cancel_client_order 1684 1684 0 0.00 4 7640 345 0 0
sp_cancel_customer_reserve 434104 434104 0 0.00 0 56902 50 0 0
sp_cancel_pay_from_customer 662 662 0 0.00 2 7856 101 0 0
sp_cancel_pay_to_supplier 362 362 0 0.00 2 5164 80 0 0
sp_cancel_supplier_invoice 4823 4811 12 0.24 2 37834 647 0 12
sp_cancel_supplier_order 336 336 0 0.00 5 760964 79983 0 0
sp_cancel_write_off 7396 7396 0 0.00 1 22743 120 0 0
sp_client_order 18957 18957 0 0.00 3 63698 365 0 0
sp_customer_reserve 435291 435291 0 0.00 0 49682 195 0 0
sp_fill_shopping_cart 28912 28912 0 0.00 1 19469 37 0 0
sp_fill_shopping_cart_clo_res 435283 435283 0 0.00 0 17059 14 0 0
sp_get_clo_for_invoice 4493 4493 0 0.00 0 26428 309 0 0
sp_kill_cost_storno 12797 12797 0 0.00 0 12483 63 0 0
sp_kill_qstorno_ret_qs2qd 880751 880751 0 0.00 0 56896 27 0 0
sp_kill_qty_storno 466184 466184 0 0.00 0 56900 59 0 0
sp_lock_selected_doc 18757 18757 0 0.00 0 6881 5 0 0
sp_make_cost_storno 25283 25283 0 0.00 0 12788 63 0 0
sp_multiply_rows_for_pdistr 25283 25283 0 0.00 0 10427 34 0 0
sp_multiply_rows_for_qdistr 18957 18957 0 0.00 0 63690 159 0 0
sp_pay_from_customer 6535 6535 0 0.00 3 20760 111 0 0
sp_pay_to_supplier 5271 5271 0 0.00 5 17843 135 0 0
sp_payment_common 11806 11806 0 0.00 1 9333 17 0 0
sp_qd_handle_on_cancel_clo 1684 1684 0 0.00 0 7631 316 0 0
sp_qd_handle_on_invoice_upd_sts 8870 8870 0 0.00 0 25704 293 0 0
sp_qd_handle_on_reserve_upd_sts 8983 8983 0 0.00 0 20493 59 0 0
sp_reserve_write_off 8984 8984 0 0.00 6 20506 197 0 0
sp_supplier_invoice 4986 4986 0 0.00 5 95657 3342 0 0
sp_supplier_order 4984 4984 0 0.00 4 52152 1267 0 0
srv_aggregate_perf_data 108 108 0 0.00 1705 83865 12076 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1564 118518 42534 0 0
srv_find_qd_qs_mism 897233 897233 0 0.00 0 22736 7 0 0
srv_make_invnt_saldo 369 369 0 0.00 46 90434 4274 0 0
srv_make_money_saldo 640 640 0 0.00 1 21260 582 0 0
srv_recalc_idx_stat 4 4 0 0.00 76373 480209 204755 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4502 4502 0 0.00 0 16137 178 0 0
t$perf-norm:sp_cancel_adding_invoice 370 370 0 0.00 0 9290 93 0 0
t$perf-norm:sp_cancel_client_order 1684 1684 0 0.00 0 5043 16 0 0
t$perf-norm:sp_cancel_customer_reserve 588 588 0 0.00 0 2047 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 662 662 0 0.00 0 763 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 362 362 0 0.00 0 320 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 370 370 0 0.00 0 834 18 0 0
t$perf-norm:sp_cancel_supplier_order 336 336 0 0.00 0 30147 1604 0 0
t$perf-norm:sp_cancel_write_off 909 909 0 0.00 0 1666 6 0 0
t$perf-norm:sp_client_order 18957 18957 0 0.00 0 3933 16 0 0
t$perf-norm:sp_customer_reserve 955 955 0 0.00 0 678 5 0 0
t$perf-norm:sp_pay_from_customer 6535 6535 0 0.00 0 13730 11 0 0
t$perf-norm:sp_pay_to_supplier 5271 5271 0 0.00 0 4022 7 0 0
t$perf-norm:sp_reserve_write_off 8984 8984 0 0.00 0 5893 13 0 0
t$perf-norm:sp_supplier_invoice 4986 4986 0 0.00 0 3908 17 0 0
t$perf-norm:sp_supplier_order 4984 4984 0 0.00 0 4391 17 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 619 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 288 9 0 0
t$perf-norm:srv_make_invnt_saldo 369 369 0 0.00 0 551 6 0 0
t$perf-norm:srv_make_money_saldo 640 640 0 0.00 0 1243 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 225 77 0 0
v_add_invoice_to_stock 9222 8986 236 2.55 0 20454 20 0 236
v_all_customers 35522 35522 0 0.00 0 30 1 0 0
v_all_suppliers 28098 28098 0 0.00 0 134 1 0 0
v_all_wares 37914 37914 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 740 740 0 0.00 0 2580 10 0 0
v_cancel_client_order 3368 3368 0 0.00 0 2588 7 0 0
v_cancel_customer_prepayment 1324 1324 0 0.00 0 7833 18 0 0
v_cancel_customer_reserve 1176 1176 0 0.00 0 5230 10 0 0
v_cancel_payment_to_supplier 724 724 0 0.00 0 1358 6 0 0
v_cancel_supplier_invoice 764 740 24 3.14 0 20709 51 0 24
v_cancel_supplier_order 672 672 0 0.00 0 5003 14 0 0
v_cancel_write_off 1818 1818 0 0.00 0 4224 15 0 0
v_max_id_clo_ord 4984 4984 0 0.00 0 5954 3 0 0
v_max_id_clo_res 955 955 0 0.00 0 4519 9 0 0
v_max_id_ord_sup 4971 4971 0 0.00 0 3844 6 0 0
v_max_non_paid_invoice 1177 1177 0 0.00 0 832 3 0 0
v_max_non_paid_realizn 3079 3079 0 0.00 0 6657 5 0 0
v_min_id_clo_ord 4984 4984 0 0.00 0 1920 4 0 0
v_min_id_clo_res 955 955 0 0.00 0 1147 7 0 0
v_min_id_ord_sup 4971 4971 0 0.00 0 5351 6 0 0
v_min_non_paid_invoice 5271 5271 0 0.00 0 3900 8 0 0
v_min_non_paid_realizn 6535 6535 0 0.00 0 8902 14 0 0
v_our_firm 9304 9304 0 0.00 0 18 1 0 0
v_reserve_write_off 17966 17966 0 0.00 0 5231 7 0 0
x_lock_depdocs_on_canc_invoice 8818 8818 0 0.00 0 13932 107 0 0
x_lock_depdocs_on_canc_sup_ord 336 336 0 0.00 0 3911 267 0 0
x_make_qstorno_1000_1200 4984 4984 0 0.00 1 51979 1183 0 0
x_make_qstorno_1200_2000 4986 4986 0 0.00 2 95577 3202 0 0
x_make_qstorno_2100_3300 435291 435291 0 0.00 0 49648 178 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 25-02-2024 10:09:01 to 25-02-2024 10:09:06.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
08:07:52 1 8192000000 8796669328 8807108608 3187328 0.038 1 1 2 0 3284944 61840 35776
08:08:53 24627 8192000000 9690505392 9982476288 772610544 8.618 100 84 168 0 800313216 7570016 20132656
08:10:22 31425 8192000000 9742963568 10046976000 819161616 9.090 100 90 180 0 851941728 10957424 21822688
08:12:01 18208 8192000000 9782212112 10096824320 853779824 9.438 100 91 182 0 893142208 18484384 20878000
08:13:27 14569 8192000000 9854424832 10181365760 905721648 9.955 100 80 160 0 957304784 33996352 17586784
08:14:51 5450 8192000000 9901143120 10246234112 945328048 10.345 100 78 154 0 1016578320 55023552 16226720
08:15:59 4448 8192000000 9933425936 10290311168 976362416 10.649 100 73 145 0 1047234896 55972640 14899840
08:17:06 2470 8192000000 9960078368 10317582336 999715536 10.876 100 81 162 0 1076464464 60584576 16164352
08:18:10 1822 8192000000 10004981904 10370953216 1023255552 11.103 100 90 181 1 1125103584 83652560 18195472
08:19:14 1086 8192000000 10031012992 10399932416 1048311168 11.344 100 86 170 0 1140421936 74685280 17425488
08:20:18 27279 8192000000 10028775360 10409672704 1054905888 11.408 100 64 126 0 1145314240 78458192 11950160
08:21:46 4652 8192000000 10021998384 10420510720 1060273600 11.459 100 40 78 0 1139631168 71439472 7918096
08:22:52 42316 8192000000 9988217584 10384216064 1070759024 11.559 100 35 71 0 1095459248 16904368 7795856
08:24:35 7827 8192000000 9980156048 10387406848 1078055520 11.629 100 20 41 0 1109517792 27185328 4276944
08:25:43 11061 8192000000 9990808752 10405199872 1085703488 11.702 100 38 76 0 1113000544 18734496 8562560
08:26:55 5382 8192000000 10006701664 10405265408 1092251376 11.764 100 45 89 1 1134395584 32037152 10107056
08:28:03 25417 8192000000 10008574640 10411388928 1097273376 11.812 100 50 98 1 1125724784 17387088 11064320
08:29:36 14913 8192000000 10054830304 10452897792 1099717856 11.835 100 49 97 0 1156706512 47141536 9847120
08:30:53 15006 8192000000 10084120352 10495987712 1119725200 12.024 100 40 80 0 1207013520 79287216 8001104
08:32:14 11940 8192000000 10130239616 10526416896 1125334832 12.077 100 60 117 1 1237643568 100930000 11378736
08:33:29 36484 8192000000 10110301424 10535247872 1093855504 11.779 97 37 74 0 1223989568 122225104 7908960
08:35:07 16002 8192000000 10100663296 10511179776 1115923152 11.988 100 47 94 0 1220804672 94899456 9982064
08:36:27 6110 8192000000 10124258656 10520219648 1092472224 11.766 99 61 121 0 1225031360 119898768 12660368
08:37:38 21859 8192000000 10112415216 10506100736 1062809616 11.483 96 48 94 0 1185692032 113512368 9370048
08:39:05 2012 8192000000 10119997248 10510471168 1067308752 11.526 98 63 123 0 1211344288 131629392 12406144
08:40:10 16480 8192000000 10139415904 10529214464 1082969936 11.676 100 67 133 0 1241430528 144374880 14085712
08:41:31 7486 8192000000 10150144208 10541871104 1090516640 11.748 100 61 118 0 1255130336 150882160 13731536
08:42:43 4722 8192000000 10168799408 10564661248 1092902656 11.770 99 50 100 0 1266667744 163020848 10744240
08:43:58 7335 8192000000 10149506864 10541096960 1085965936 11.704 99 55 107 0 1247689136 150391968 11331232
08:45:12 2626 8192000000 10173860656 10574159872 1109983504 11.932 100 46 87 2 1283450432 163403632 10063296
08:46:19 2834 8192000000 10162337248 10559807488 1094697072 11.787 98 71 137 0 1261496720 151643408 15156240
08:47:27 1560 8192000000 10253543408 10651471872 1131859488 12.139 100 81 162 0 1353000592 202958240 18182864
08:48:33 10949 8192000000 10230785216 10642731008 1135186944 12.170 100 49 96 1 1334484848 188507248 10790656
08:50:05 2884 8192000000 10229413872 10655313920 1150502528 12.314 100 56 111 1 1346092000 182837424 12752048
08:51:11 11297 8192000000 10180075520 10676473856 1149263328 12.303 100 23 46 0 1318303264 163934464 5105472
08:52:26 40791 8192000000 10148473040 10582814720 1132668416 12.147 99 27 55 1 1249002736 110729936 5604384
08:54:14 19306 8192000000 10136009744 10572406784 1139628192 12.212 100 28 58 0 1263788096 117897600 6262304
08:55:37 40980 8192000000 10088688160 10507251712 1118134960 12.009 98 33 64 0 1175281952 49491248 7655744
08:57:31 63613 8192000000 10084277904 10522542080 1139926240 12.215 100 13 25 0 1192290272 49371616 2992416
08:59:43 11133 8192000000 10107335744 10538577920 1138029520 12.197 100 55 107 1 1194093136 44595088 11468528
09:01:24 116101 8192000000 10082939968 10549706752 1138663712 12.203 99 13 26 0 1179132640 37642160 2826768
09:04:22 44868 8192000000 10074359456 10502348800 1144159280 12.255 99 24 46 1 1166836416 17846528 4830608
09:06:13 111059 8192000000 10129868112 10566012928 1157533472 12.380 100 36 73 0 1218601536 53489744 7578320
09:09:09 93852 8192000000 10135597040 10581413888 1134427136 12.163 97 21 42 0 1220744928 81915648 4402144
09:11:44 15745 8192000000 10205207216 10649346048 1164130640 12.442 100 60 117 0 1291458912 115185264 12143008
09:13:08 73005 8192000000 10077517072 10517872640 1118177904 12.010 96 16 30 0 1165688464 44341392 3169168
09:16:02 46529 8192000000 10151069088 10584109056 1111331296 11.945 97 27 53 0 1198006688 80815776 5859616
09:17:49 69638 8192000000 10125855056 10563297280 1121070832 12.037 98 21 42 0 1227008368 101394912 4542624
09:20:07 56909 8192000000 10076577104 10522726400 1132400320 12.144 99 17 34 1 1189301712 53409264 3492128
09:22:07 35000 8192000000 10060171680 10503127040 1089753808 11.740 98 38 74 0 1146242832 49071328 7417696
09:23:43 116933 8192000000 10042642992 10528518144 1040107904 11.266 93 13 26 1 1099037504 56083120 2846480
09:26:43 70938 8192000000 10067017760 10494496768 1067191872 11.525 96 43 86 1 1110624224 34065152 9367200
09:28:54 74905 8192000000 10063762208 10560450560 1096494576 11.804 99 25 48 0 1167589360 65696944 5397840
09:31:11 31249 8192000000 10038945648 10498445312 1074731744 11.597 97 20 40 0 1120726208 41844112 4150352
09:32:43 83321 8192000000 10042440608 10520125440 1099265504 11.831 99 14 28 0 1143191024 41219120 2706400
09:35:09 54014 8192000000 10068201616 10541592576 1086964048 11.714 98 15 29 1 1158822272 68459328 3398896
09:37:03 56577 8192000000 10027347648 10492444672 1060197232 11.458 96 8 16 0 1097093216 35578080 1317904
09:39:11 18714 8192000000 10067960016 10497036288 1116280480 11.992 100 39 76 1 1164028768 39552064 8196224
09:40:30 16486 8192000000 10064012960 10491285504 1098187600 11.820 98 34 68 0 1148431424 43834272 6409552
09:41:47 42528 8192000000 10086829072 10584440832 1133108512 12.151 100 19 38 0 1237459760 100284880 4066368
09:43:39 50366 8192000000 10070002768 10512191488 1141365264 12.228 100 21 43 0 1195496560 50069408 4061888
09:45:32 70697 8192000000 10112509632 10562215936 1154353248 12.350 100 22 44 0 1214862640 56296448 4212944
09:47:44 12088 8192000000 10120934080 10548850688 1159079792 12.395 100 54 108 1 1203186336 33555184 10551360
09:48:57 68682 8192000000 10152617280 10670866432 1139549680 12.211 97 17 34 0 1219347808 76080160 3717968
09:51:14 118518 8192000000 10080662560 10540572672 1158883776 12.393 100 20 40 0 1194214400 31299024 4031600
09:54:13 5076 8192000000 10110868944 10564702208 1157530272 12.380 99 32 63 0 1205491328 41889616 6071440
09:55:21 69257 8192000000 10112074400 10614345728 1147829152 12.289 99 13 27 0 1249144224 98156400 3158672
09:57:36 55293 8192000000 10096830848 10567708672 1125848256 12.082 97 17 34 0 1192649744 63173744 3627744
09:59:34 97613 8192000000 10078276976 10517762048 1086324864 11.708 95 13 26 0 1185048304 95790560 2932880
10:02:14 92362 8192000000 10053518624 10523058176 1104058608 11.876 98 21 42 0 1152158016 43671680 4427728
10:04:54 77057 8192000000 10073473056 10545541120 1080738624 11.655 96 27 54 0 1161989600 75580176 5670800
10:07:11 42694 8192000000 9818923040 10234052608 859048976 9.491 76 18 36 0 896616656 33741664 3826016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 25-02-2024 10:09:08 to 25-02-2024 10:09:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 118 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

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

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          176667
MON$OLDEST_ACTIVE               177748
MON$OLDEST_SNAPSHOT             177748
MON$NEXT_TRANSACTION            177748
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                       1929120
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             706
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3061 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3061 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3061 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3061 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 Sun Feb 25 10:09:25 2024 
 
Database header page information: 
    Flags            0 
    Generation        93403 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    176667 
    Oldest active        177748 
    Oldest snapshot        177748 
    Next transaction    177749 
    Sequence number        0 
    Next attachment ID    706 
    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.14, total records: 7849488 
    Average version length: 48.16, total versions: 152238, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 56, data page slots: 89904 
    Data pages: 89904, average fill: 70% 
    Primary pages: 89903, secondary pages: 1, swept pages: 29015 
    Empty pages: 1, full pages: 76896 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 69 
    40 - 59% = 1663 
    60 - 79% = 88051 
    80 - 99% = 110 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23413, nodes: 7849488 
    Average node length: 18.93, total dup: 0, max dup: 0 
    Average key length: 15.94, compression ratio: 1.69 
    Average prefix length: 14.06, average data length: 12.94 
    Clustering factor: 1700355, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 373 
        20 - 39% = 1515 
        40 - 59% = 4274 
        60 - 79% = 2227 
        80 - 99% = 15024 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13588, nodes: 7849488 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1525061, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1407 
        40 - 59% = 2222 
        60 - 79% = 980 
        80 - 99% = 8979 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8403, nodes: 7849488 
    Average node length: 6.64, total dup: 5840104, max dup: 49 
    Average key length: 3.65, compression ratio: 2.47 
    Average prefix length: 7.60, average data length: 1.40 
    Clustering factor: 1518126, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 134 
        20 - 39% = 859 
        40 - 59% = 1495 
        60 - 79% = 815 
        80 - 99% = 5100 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.78, total records: 2300833 
    Average version length: 58.86, total versions: 79885, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.51 
    Pointer pages: 18, data page slots: 29040 
    Data pages: 29040, average fill: 73% 
    Primary pages: 29038, secondary pages: 2, swept pages: 6619 
    Empty pages: 1, full pages: 23414 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 11 
    40 - 59% = 147 
    60 - 79% = 28692 
    80 - 99% = 182 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4604, nodes: 2300833 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 693101, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 871 
        40 - 59% = 885 
        60 - 79% = 623 
        80 - 99% = 2225 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2441, nodes: 2302512 
    Average node length: 4.97, total dup: 2301613, max dup: 18651 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1285715, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 184 
        40 - 59% = 1365 
        60 - 79% = 592 
        80 - 99% = 297 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1805, nodes: 2300833 
    Average node length: 4.97, total dup: 2300783, max dup: 130415 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1086623, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 643 
        60 - 79% = 49 
        80 - 99% = 1107 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4407, nodes: 2300833 
    Average node length: 11.39, total dup: 0, max dup: 0 
    Average key length: 8.43, compression ratio: 1.07 
    Average prefix length: 3.57, average data length: 5.43 
    Clustering factor: 693101, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 527 
        40 - 59% = 627 
        60 - 79% = 753 
        80 - 99% = 2368 
 
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.38, total records: 400 
    Average version length: 30.81, total versions: 1107, max versions: 3 
    Average fragment length: 2.00, total fragments: 5, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 48% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 7, full pages: 10 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 10 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 18.70, total records: 93265 
    Average version length: 68.29, total versions: 78013, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.71 
    Pointer pages: 7, data page slots: 2600 
    Data pages: 1736, average fill: 71% 
    Primary pages: 1735, secondary pages: 1, swept pages: 0 
    Empty pages: 105, full pages: 1075 
    Fill distribution: 
     0 - 19% = 152 
    20 - 39% = 150 
    40 - 59% = 191 
    60 - 79% = 322 
    80 - 99% = 921 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1687745, depth: 3, leaf buckets: 361, nodes: 93265 
    Average node length: 13.38, total dup: 6263, max dup: 2 
    Average key length: 10.76, compression ratio: 2.51 
    Average prefix length: 19.16, average data length: 7.84 
    Clustering factor: 69761, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 162 
        40 - 59% = 161 
        60 - 79% = 35 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 181, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 77% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 12.05, total records: 1496 
    Average version length: 43.40, total versions: 1367, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.81 
    Pointer pages: 1, data page slots: 64 
    Data pages: 32, average fill: 49% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 8, full pages: 13 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 12 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 94700, depth: 2, leaf buckets: 3, nodes: 1496 
    Average node length: 4.36, total dup: 1399, max dup: 185 
    Average key length: 2.70, compression ratio: 7.03 
    Average prefix length: 18.36, average data length: 0.64 
    Clustering factor: 805, 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.68, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.57, total records: 818476 
    Average version length: 37.92, total versions: 41276, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 6, data page slots: 8352 
    Data pages: 8352, average fill: 67% 
    Primary pages: 8351, secondary pages: 1, swept pages: 872 
    Empty pages: 19, full pages: 8082 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 10 
    40 - 59% = 30 
    60 - 79% = 8184 
    80 - 99% = 96 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 840, nodes: 793432 
    Average node length: 4.88, total dup: 793383, max dup: 151683 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91267, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 115 
        40 - 59% = 451 
        60 - 79% = 166 
        80 - 99% = 107 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 869, nodes: 793432 
    Average node length: 5.89, total dup: 706093, max dup: 47 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160562, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 29 
        40 - 59% = 377 
        60 - 79% = 139 
        80 - 99% = 322 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 895, nodes: 793432 
    Average node length: 5.89, total dup: 706093, max dup: 47 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162428, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 75 
        40 - 59% = 369 
        60 - 79% = 125 
        80 - 99% = 326 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1122, nodes: 793432 
    Average node length: 5.97, total dup: 706093, max dup: 47 
    Average key length: 3.11, compression ratio: 5.47 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 155055, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 212 
        40 - 59% = 627 
        60 - 79% = 187 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.93, total records: 5508 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.77, total fragments: 31, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.02 
    Pointer pages: 1, data page slots: 88 
    Data pages: 88, average fill: 62% 
    Primary pages: 75, secondary pages: 13, swept pages: 46 
    Empty pages: 4, full pages: 52 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 74 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5508 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.11 
    Average prefix length: 34.57, average data length: 1.54 
    Clustering factor: 5207, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5508 
    Average node length: 11.11, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 155, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.09, total records: 81280 
    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: 848 
    Data pages: 848, average fill: 66% 
    Primary pages: 848, secondary pages: 0, swept pages: 0 
    Empty pages: 3, full pages: 844 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 844 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 37406, depth: 2, leaf buckets: 104, nodes: 81280 
    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: 3515, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 102 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.17, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.21 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 144.32, total records: 153079 
    Average version length: 153.69, total versions: 7213, 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: 6, data page slots: 4352 
    Data pages: 3792, average fill: 84% 
    Primary pages: 3789, secondary pages: 3, swept pages: 1 
    Empty pages: 27, full pages: 3754 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3754 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 150.38, total records: 135874 
    Average version length: 141.56, total versions: 660, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.28 
    Pointer pages: 6, data page slots: 4144 
    Data pages: 3392, average fill: 82% 
    Primary pages: 3390, secondary pages: 2, swept pages: 1 
    Empty pages: 50, full pages: 3331 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 3332 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 149.05, total records: 163619 
    Average version length: 149.43, total versions: 2495, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 7, data page slots: 4616 
    Data pages: 4080, average fill: 83% 
    Primary pages: 4078, secondary pages: 2, swept pages: 2 
    Empty pages: 52, full pages: 4014 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 3 
    80 - 99% = 4013 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 148.73, total records: 153596 
    Average version length: 149.89, total versions: 2697, 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: 4960 
    Data pages: 3816, average fill: 83% 
    Primary pages: 3813, secondary pages: 3, swept pages: 3 
    Empty pages: 32, full pages: 3766 
    Fill distribution: 
     0 - 19% = 38 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 5 
    80 - 99% = 3767 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 142.67, total records: 154867 
    Average version length: 154.32, total versions: 9261, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.89 
    Pointer pages: 7, data page slots: 4720 
    Data pages: 3920, average fill: 82% 
    Primary pages: 3918, secondary pages: 2, swept pages: 4 
    Empty pages: 87, full pages: 3784 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 18 
    40 - 59% = 20 
    60 - 79% = 7 
    80 - 99% = 3786 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 147.99, total records: 143724 
    Average version length: 150.99, total versions: 2906, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 4624 
    Data pages: 3552, average fill: 83% 
    Primary pages: 3549, secondary pages: 3, swept pages: 1 
    Empty pages: 22, full pages: 3521 
    Fill distribution: 
     0 - 19% = 26 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3522 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 149.51, total records: 151836 
    Average version length: 146.46, total versions: 1555, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 7, data page slots: 4536 
    Data pages: 3768, average fill: 83% 
    Primary pages: 3766, secondary pages: 2, swept pages: 1 
    Empty pages: 37, full pages: 3718 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3718 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 148.22, total records: 140730 
    Average version length: 151.19, total versions: 2431, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 4392 
    Data pages: 3512, average fill: 82% 
    Primary pages: 3510, secondary pages: 2, swept pages: 1 
    Empty pages: 53, full pages: 3439 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 6 
    40 - 59% = 6 
    60 - 79% = 1 
    80 - 99% = 3440 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 142.74, total records: 161323 
    Average version length: 154.28, total versions: 9545, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 6, data page slots: 4872 
    Data pages: 4016, average fill: 84% 
    Primary pages: 4013, secondary pages: 3, swept pages: 3 
    Empty pages: 42, full pages: 3958 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3959 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 137.18, total records: 179667 
    Average version length: 154.77, total versions: 17803, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.36 
    Pointer pages: 8, data page slots: 5568 
    Data pages: 4488, average fill: 84% 
    Primary pages: 4485, secondary pages: 3, swept pages: 4 
    Empty pages: 54, full pages: 4414 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 4415 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.34, total records: 2150044 
    Average version length: 52.96, total versions: 69423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 26056 
    Data pages: 26048, average fill: 71% 
    Primary pages: 26037, secondary pages: 11, swept pages: 9162 
    Empty pages: 89, full pages: 23712 
    Fill distribution: 
     0 - 19% = 195 
    20 - 39% = 161 
    40 - 59% = 559 
    60 - 79% = 24360 
    80 - 99% = 773 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2651, nodes: 2150044 
    Average node length: 5.44, total dup: 2007567, max dup: 1791 
    Average key length: 2.48, compression ratio: 3.63 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184506, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 257 
        40 - 59% = 1831 
        60 - 79% = 283 
        80 - 99% = 277 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2760, nodes: 2150044 
    Average node length: 5.69, total dup: 1930598, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 382846, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 4 
        40 - 59% = 2251 
        60 - 79% = 476 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2142, nodes: 2150044 
    Average node length: 4.96, total dup: 2149944, max dup: 27329 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182495, ratio: 0.08 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 184 
        40 - 59% = 1095 
        60 - 79% = 386 
        80 - 99% = 477 
 
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.60, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 40.52, total records: 162971 
    Average version length: 69.18, total versions: 77661, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.11 
    Pointer pages: 3, data page slots: 4640 
    Data pages: 3272, average fill: 61% 
    Primary pages: 3272, secondary pages: 0, swept pages: 522 
    Empty pages: 645, full pages: 2341 
    Fill distribution: 
     0 - 19% = 807 
    20 - 39% = 51 
    40 - 59% = 50 
    60 - 79% = 950 
    80 - 99% = 1414 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104680, depth: 3, leaf buckets: 230, nodes: 162971 
    Average node length: 6.47, total dup: 141830, max dup: 14 
    Average key length: 3.92, compression ratio: 10.72 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 28720, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 30 
        40 - 59% = 107 
        60 - 79% = 62 
        80 - 99% = 29 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 63.99, total records: 7273271 
    Average version length: 68.80, total versions: 603501, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.97 
    Pointer pages: 65, data page slots: 104504 
    Data pages: 104504, average fill: 75% 
    Primary pages: 104503, secondary pages: 1, swept pages: 6967 
    Empty pages: 26, full pages: 102395 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 88 
    40 - 59% = 401 
    60 - 79% = 99619 
    80 - 99% = 4346 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10699, nodes: 7273271 
    Average node length: 6.51, total dup: 6292920, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1685204, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1462 
        40 - 59% = 5589 
        60 - 79% = 2975 
        80 - 99% = 667 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8484, nodes: 7273271 
    Average node length: 5.39, total dup: 6986911, max dup: 204 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1476737, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 907 
        40 - 59% = 4743 
        60 - 79% = 1569 
        80 - 99% = 1253 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8556, nodes: 7273271 
    Average node length: 5.39, total dup: 6986911, max dup: 204 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1479082, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 981 
        40 - 59% = 4699 
        60 - 79% = 1658 
        80 - 99% = 1210 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.74, total records: 12128968 
    Average version length: 68.76, total versions: 443857, 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: 106, data page slots: 172568 
    Data pages: 172568, average fill: 75% 
    Primary pages: 172567, secondary pages: 1, swept pages: 45399 
    Empty pages: 1, full pages: 172475 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 7 
    60 - 79% = 168752 
    80 - 99% = 3807 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18352, nodes: 12124216 
    Average node length: 6.61, total dup: 10565625, max dup: 60 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2478377, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1953 
        40 - 59% = 10846 
        60 - 79% = 4733 
        80 - 99% = 800 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 38.75, total records: 1964935 
    Average version length: 69.08, total versions: 498328, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.25 
    Pointer pages: 28, data page slots: 44840 
    Data pages: 29486, average fill: 64% 
    Primary pages: 29418, secondary pages: 68, swept pages: 2132 
    Empty pages: 1018, full pages: 26646 
    Fill distribution: 
     0 - 19% = 1595 
    20 - 39% = 4988 
    40 - 59% = 2770 
    60 - 79% = 12981 
    80 - 99% = 7152 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1866, nodes: 1470331 
    Average node length: 5.52, total dup: 1410720, max dup: 95 
    Average key length: 2.56, compression ratio: 16.39 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 104609, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 309 
        40 - 59% = 929 
        60 - 79% = 488 
        80 - 99% = 132 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 33.11, total records: 1751955 
    Average version length: 69.04, total versions: 198988, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.81 
    Pointer pages: 21, data page slots: 33752 
    Data pages: 29008, average fill: 45% 
    Primary pages: 29007, secondary pages: 1, swept pages: 4704 
    Empty pages: 4816, full pages: 16059 
    Fill distribution: 
     0 - 19% = 7278 
    20 - 39% = 2986 
    40 - 59% = 6584 
    60 - 79% = 11471 
    80 - 99% = 689 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1269, nodes: 902771 
    Average node length: 5.96, total dup: 830173, max dup: 99 
    Average key length: 3.02, compression ratio: 13.91 
    Average prefix length: 41.06, average data length: 0.94 
    Clustering factor: 133293, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 238 
        40 - 59% = 647 
        60 - 79% = 330 
        80 - 99% = 54 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.15, total records: 9575192 
    Average version length: 68.97, total versions: 749507, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 91, data page slots: 147984 
    Data pages: 147968, average fill: 70% 
    Primary pages: 147953, secondary pages: 15, swept pages: 29622 
    Empty pages: 289, full pages: 96453 
    Fill distribution: 
     0 - 19% = 951 
    20 - 39% = 4314 
    40 - 59% = 17052 
    60 - 79% = 118995 
    80 - 99% = 6656 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13557, nodes: 9566616 
    Average node length: 6.70, total dup: 7936540, max dup: 14 
    Average key length: 3.66, compression ratio: 11.47 
    Average prefix length: 40.51, average data length: 1.49 
    Clustering factor: 2157524, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 917 
        40 - 59% = 6510 
        60 - 79% = 5218 
        80 - 99% = 910 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21177814 
    Average version length: 82.95, total versions: 17344, 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: 197, data page slots: 320096 
    Data pages: 320096, average fill: 81% 
    Primary pages: 320092, secondary pages: 4, swept pages: 12705 
    Empty pages: 1, full pages: 320091 
    Fill distribution: 
     0 - 19% = 3 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 49736 
    80 - 99% = 270356 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19366, nodes: 21177814 
    Average node length: 5.72, total dup: 20696199, max dup: 179 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3287024, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8071 
        60 - 79% = 537 
        80 - 99% = 10754 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17220, nodes: 21177814 
    Average node length: 6.31, total dup: 18609961, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918662, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 6 
        40 - 59% = 835 
        60 - 79% = 243 
        80 - 99% = 16132 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21160, nodes: 21177814 
    Average node length: 6.35, total dup: 18530033, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3582247, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8323 
        60 - 79% = 655 
        80 - 99% = 12178 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16212, nodes: 21177814 
    Average node length: 5.56, total dup: 21177714, max dup: 230388 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947519, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 3101 
        60 - 79% = 358 
        80 - 99% = 12745 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 77.00, total records: 10010523 
    Average version length: 82.63, total versions: 738270, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.64 
    Pointer pages: 108, data page slots: 175296 
    Data pages: 175232, average fill: 71% 
    Primary pages: 175204, secondary pages: 28, swept pages: 49402 
    Empty pages: 498, full pages: 114291 
    Fill distribution: 
     0 - 19% = 1473 
    20 - 39% = 6164 
    40 - 59% = 21838 
    60 - 79% = 114231 
    80 - 99% = 31526 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11399, nodes: 10010523 
    Average node length: 5.37, total dup: 9698378, max dup: 236 
    Average key length: 2.23, compression ratio: 4.04 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2265264, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 48 
        40 - 59% = 7272 
        60 - 79% = 3913 
        80 - 99% = 163 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13768, nodes: 10010523 
    Average node length: 6.25, total dup: 8299587, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1587925, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 144 
        20 - 39% = 3831 
        40 - 59% = 4421 
        60 - 79% = 2703 
        80 - 99% = 2669 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12742, nodes: 10010523 
    Average node length: 5.99, total dup: 8696913, max dup: 44 
    Average key length: 2.84, compression ratio: 3.17 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2461766, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 71 
        40 - 59% = 8177 
        60 - 79% = 4331 
        80 - 99% = 161 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10396, nodes: 10010523 
    Average node length: 5.15, total dup: 10010423, max dup: 155124 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1621498, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1129 
        40 - 59% = 5275 
        60 - 79% = 1785 
        80 - 99% = 2168 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 78.64, total records: 11650022 
    Average version length: 82.53, total versions: 583320, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 120, data page slots: 195736 
    Data pages: 194360, average fill: 74% 
    Primary pages: 194229, secondary pages: 131, swept pages: 54627 
    Empty pages: 2035, full pages: 155953 
    Fill distribution: 
     0 - 19% = 3391 
    20 - 39% = 5545 
    40 - 59% = 14385 
    60 - 79% = 94956 
    80 - 99% = 76083 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13132, nodes: 11650022 
    Average node length: 5.32, total dup: 11539478, max dup: 664 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2441168, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 57 
        40 - 59% = 8151 
        60 - 79% = 4681 
        80 - 99% = 242 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10651, nodes: 11650022 
    Average node length: 5.51, total dup: 11142587, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 746279, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 836 
        40 - 59% = 2590 
        60 - 79% = 1773 
        80 - 99% = 5326 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 15011, nodes: 11650022 
    Average node length: 6.04, total dup: 10175624, max dup: 72 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2457700, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 57 
        40 - 59% = 9694 
        60 - 79% = 4971 
        80 - 99% = 286 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 11057, nodes: 11650022 
    Average node length: 5.24, total dup: 11649922, max dup: 206877 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 734237, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 773 
        40 - 59% = 4972 
        60 - 79% = 1536 
        80 - 99% = 3691 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 77.57, total records: 10098127 
    Average version length: 82.92, total versions: 707211, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 110, data page slots: 178408 
    Data pages: 178352, average fill: 71% 
    Primary pages: 178327, secondary pages: 25, swept pages: 54036 
    Empty pages: 472, full pages: 113181 
    Fill distribution: 
     0 - 19% = 1487 
    20 - 39% = 6621 
    40 - 59% = 24249 
    60 - 79% = 115393 
    80 - 99% = 30602 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 12087, nodes: 10098127 
    Average node length: 5.19, total dup: 10068872, max dup: 2004 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2055058, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1376 
        40 - 59% = 8025 
        60 - 79% = 2007 
        80 - 99% = 650 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13868, nodes: 10098127 
    Average node length: 6.26, total dup: 8372298, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1542289, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 190 
        20 - 39% = 3855 
        40 - 59% = 4320 
        60 - 79% = 2691 
        80 - 99% = 2812 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12742, nodes: 10098127 
    Average node length: 5.45, total dup: 9649605, max dup: 99 
    Average key length: 2.28, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2192832, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1280 
        40 - 59% = 9071 
        60 - 79% = 1714 
        80 - 99% = 648 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10544, nodes: 10098127 
    Average node length: 5.16, total dup: 10098027, max dup: 156052 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1631500, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1199 
        40 - 59% = 5368 
        60 - 79% = 1743 
        80 - 99% = 2200 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.18, total records: 583658 
    Average version length: 68.80, total versions: 9851, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 5, data page slots: 8104 
    Data pages: 8104, average fill: 76% 
    Primary pages: 8103, secondary pages: 1, swept pages: 2705 
    Empty pages: 0, full pages: 7559 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 4 
    40 - 59% = 52 
    60 - 79% = 7878 
    80 - 99% = 169 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 52731, depth: 3, leaf buckets: 745, nodes: 583658 
    Average node length: 5.95, total dup: 496869, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102515, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 540 
        60 - 79% = 98 
        80 - 99% = 85 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 38578, depth: 3, leaf buckets: 767, nodes: 583658 
    Average node length: 6.15, total dup: 478683, max dup: 21 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102559, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 24 
        40 - 59% = 545 
        60 - 79% = 105 
        80 - 99% = 93 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 557, nodes: 583658 
    Average node length: 4.86, total dup: 583558, max dup: 9614 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 91046, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 322 
        60 - 79% = 53 
        80 - 99% = 151 
 
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 Sun Feb 25 10:09:49 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7849488 152238 1 0.0000 0.0000
DOC_LIST 2300833 79885 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1107 3 200.0000 0.0000
INVNT_TURNOVER_LOG 93265 78013 1 0.0000 0.0000
MONEY_SALDO 49 181 6 300.0000 0.0000
MONEY_TURNOVER_LOG 1496 1367 1 0.0000 0.0000
PDISTR 818476 41276 3 0.0000 0.0000
PERF_SPLIT_0 153079 7213 1 0.0000 0.0000
PERF_SPLIT_1 135874 660 1 0.0000 0.0000
PERF_SPLIT_2 163619 2495 1 0.0000 0.0000
PERF_SPLIT_3 153596 2697 1 0.0000 0.0000
PERF_SPLIT_4 154867 9261 1 0.0000 0.0000
PERF_SPLIT_5 143724 2906 1 0.0000 0.0000
PERF_SPLIT_6 151836 1555 1 0.0000 0.0000
PERF_SPLIT_7 140730 2431 1 0.0000 0.0000
PERF_SPLIT_8 161323 9545 1 0.0000 0.0000
PERF_SPLIT_9 179667 17803 1 0.0000 0.0000
PSTORNED 2150044 69423 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 162971 77661 1 0.0000 0.0000
XQD_1000_3300 7273271 603501 1 0.0000 0.0000
XQD_1200_2000 12128968 443857 1 0.0000 0.0000
XQD_2000_3300 1964935 498328 1 0.0000 0.0000
XQD_2100_3300 1751955 198988 1 0.0000 0.0000
XQD_3300_3400 9575192 749507 1 0.0000 0.0000
XQS_1000_1200 21177814 17344 1 0.0000 0.0000
XQS_1000_3300 10010523 738270 1 0.0000 0.0000
XQS_1200_2000 11650022 583320 1 0.0000 0.0000
XQS_2100_3300 10098127 707211 1 0.0000 0.0000
XQS_3300_3400 583658 9851 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 ---
:307: 
:308: mscs-test-161.budzdorov.ru    Sun Feb 25 10:07:59 2024
:309:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:310: 
--- end of diff output ---

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

25.02.24 10:10:01. 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-25 10:10:04 No severe PSQL-related problems occured
25.02.24 10:10:05. End of report.