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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-29 22:09:43
DTS_END                         2024-03-29 22:09:43.6230
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(57:17)
IP                              ::1/43070
TRN_ID                          172450
ATT_ID                          512
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: 9438.95 22884 943895
customer order: creation 173.04 384 17304
customer order: refuse 15.25 400 1525
order to supplier: creation 46.00 1373 4600
order to supplier: removal 3.39 117558 339
invoice (draft): creation 45.67 3619 4567
invoice (draft): removal 51.31 896 5131
invoice accept: apply 42.11 21669 4211
invoice accept: cancel 47.23 942 4723
customer reserve: creation 4056.08 207 405608
customer reserve: removal 4658.94 67 465894
realization accept: apply 83.83 219 8383
realization accept: cancel 85.76 129 8576
payment from customer: creation 60.10 121 6010
payment from customer: removal 5.64 94 564
payment to supplier: creation 49.66 142 4966
payment to supplier: removal 3.38 53 338
service: total inventory turnovers 4.05 1682 405
service: total monetary turnovers 6.70 49 670
service: aggregate perf. data 0.78 24547 78
service: refresh index statistics 0.03 283529 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 29-03-2024 22:11:31 to 29-03-2024 22:11:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4384
TEST_TIME 2 3744
TEST_TIME 3 5004
TEST_TIME 4 4375
TEST_TIME 5 4083
TEST_TIME 6 4162
TEST_TIME 7 4839
TEST_TIME 8 5168
TEST_TIME 9 5423
TEST_TIME 10 5310
TEST_TIME 11 5638
TEST_TIME 12 5759
TEST_TIME 13 5675
TEST_TIME 14 5691
TEST_TIME 15 5905
TEST_TIME 16 5999
TEST_TIME 17 5925
TEST_TIME 18 6083
TEST_TIME 19 6019
TEST_TIME 20 6250
TEST_TIME 21 6435
TEST_TIME 22 6588
TEST_TIME 23 6676
TEST_TIME 24 7380
TEST_TIME 25 7627
TEST_TIME 26 8032
TEST_TIME 27 8085
TEST_TIME 28 8472
TEST_TIME 29 8978
TEST_TIME 30 9316
TEST_TIME 31 9285
TEST_TIME 32 9352
TEST_TIME 33 9363
TEST_TIME 34 9240
TEST_TIME 35 9341
TEST_TIME 36 9296
TEST_TIME 37 9364
TEST_TIME 38 9363
TEST_TIME 39 9261
TEST_TIME 40 9240
TEST_TIME 41 9316
TEST_TIME 42 9607
TEST_TIME 43 9519
TEST_TIME 44 9340
TEST_TIME 45 9311
TEST_TIME 46 9388
TEST_TIME 47 9282
TEST_TIME 48 9254
TEST_TIME 49 9284
TEST_TIME 50 9334
TEST_TIME 51 9352
TEST_TIME 52 9243
TEST_TIME 53 9220
TEST_TIME 54 9266
TEST_TIME 55 9314
TEST_TIME 56 9257
TEST_TIME 57 9146
TEST_TIME 58 9049
TEST_TIME 59 9113
TEST_TIME 60 9115
TEST_TIME 61 9171
TEST_TIME 62 9148
TEST_TIME 63 9176
TEST_TIME 64 9200
TEST_TIME 65 9258
TEST_TIME 66 9230
TEST_TIME 67 9349
TEST_TIME 68 9375
TEST_TIME 69 9462
TEST_TIME 70 9450
TEST_TIME 71 9475
TEST_TIME 72 9563
TEST_TIME 73 9524
TEST_TIME 74 9454
TEST_TIME 75 9406
TEST_TIME 76 9439
TEST_TIME 77 9375
TEST_TIME 78 9403
TEST_TIME 79 9369
TEST_TIME 80 9330
TEST_TIME 81 9276
TEST_TIME 82 9200
TEST_TIME 83 9177
TEST_TIME 84 9157
TEST_TIME 85 9271
TEST_TIME 86 9285
TEST_TIME 87 9302
TEST_TIME 88 9357
TEST_TIME 89 9388
TEST_TIME 90 9449
TEST_TIME 91 9455
TEST_TIME 92 9419
TEST_TIME 93 9485
TEST_TIME 94 9544
TEST_TIME 95 9566
TEST_TIME 96 9551
TEST_TIME 97 9601
TEST_TIME 98 9563
TEST_TIME 99 9513
TEST_TIME 100 9456

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 29-03-2024 22:11:34 to 29-03-2024 22:11:38.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1314368 1314368 0 0.00 0 23255 7 0 0
doc_list_biud 1314367 1314367 0 0.00 0 58000 30 0 0
sp_add_invoice_to_stock 4338 4211 127 2.92 30 311387 21670 0 127
sp_cancel_adding_invoice 4723 4723 0 0.00 4 81952 942 0 0
sp_cancel_client_order 1525 1525 0 0.00 4 10019 401 0 0
sp_cancel_customer_reserve 465894 465894 0 0.00 1 58001 67 0 0
sp_cancel_pay_from_customer 564 564 0 0.00 3 3117 95 0 0
sp_cancel_pay_to_supplier 338 338 0 0.00 2 1783 53 0 0
sp_cancel_supplier_invoice 5140 5131 9 0.17 1 29555 897 0 9
sp_cancel_supplier_order 339 339 0 0.00 9 1054596 117559 0 0
sp_cancel_write_off 8576 8576 0 0.00 1 13525 130 0 0
sp_client_order 17304 17304 0 0.00 3 31197 385 0 0
sp_customer_reserve 405608 405608 0 0.00 0 56110 207 0 0
sp_fill_shopping_cart 26471 26471 0 0.00 1 10366 36 0 0
sp_fill_shopping_cart_clo_res 405590 405590 0 0.00 0 19848 14 0 0
sp_get_clo_for_invoice 4189 4189 0 0.00 0 18047 275 0 0
sp_kill_cost_storno 14201 14201 0 0.00 0 10986 67 0 0
sp_kill_qstorno_ret_qs2qd 945834 945834 0 0.00 0 57998 36 0 0
sp_kill_qty_storno 498760 498760 0 0.00 0 58000 78 0 0
sp_lock_selected_doc 17446 17446 0 0.00 0 7476 5 0 0
sp_make_cost_storno 23548 23548 0 0.00 0 23232 66 0 0
sp_multiply_rows_for_pdistr 23548 23548 0 0.00 0 5767 33 0 0
sp_multiply_rows_for_qdistr 17304 17304 0 0.00 0 15358 160 0 0
sp_pay_from_customer 6010 6010 0 0.00 4 26010 121 0 0
sp_pay_to_supplier 4966 4966 0 0.00 4 23260 142 0 0
sp_payment_common 10976 10976 0 0.00 2 10876 30 0 0
sp_qd_handle_on_cancel_clo 1525 1525 0 0.00 0 10006 366 0 0
sp_qd_handle_on_invoice_upd_sts 8912 8912 0 0.00 0 18540 368 0 0
sp_qd_handle_on_reserve_upd_sts 8383 8383 0 0.00 0 15839 64 0 0
sp_reserve_write_off 8383 8383 0 0.00 6 29617 220 0 0
sp_supplier_invoice 4567 4567 0 0.00 6 99489 3620 0 0
sp_supplier_order 4600 4600 0 0.00 5 32897 1374 0 0
srv_aggregate_perf_data 78 78 0 0.00 1900 496553 24548 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 942 115474 35570 0 0
srv_find_qd_qs_mism 900631 900631 0 0.00 0 17730 6 0 0
srv_make_invnt_saldo 405 405 0 0.00 49 152788 1682 0 0
srv_make_money_saldo 670 670 0 0.00 1 11882 50 0 0
srv_recalc_idx_stat 3 3 0 0.00 163475 475008 283529 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4211 4211 0 0.00 0 8289 200 0 0
t$perf-norm:sp_cancel_adding_invoice 386 386 0 0.00 0 1943 82 0 0
t$perf-norm:sp_cancel_client_order 1525 1525 0 0.00 0 2204 19 0 0
t$perf-norm:sp_cancel_customer_reserve 587 587 0 0.00 0 1287 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 564 564 0 0.00 0 2065 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 338 338 0 0.00 0 506 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 332 332 0 0.00 0 2287 23 0 0
t$perf-norm:sp_cancel_supplier_order 339 339 0 0.00 0 24647 2051 0 0
t$perf-norm:sp_cancel_write_off 803 803 0 0.00 0 2949 9 0 0
t$perf-norm:sp_client_order 17304 17304 0 0.00 0 9232 18 0 0
t$perf-norm:sp_customer_reserve 757 757 0 0.00 0 3196 14 0 0
t$perf-norm:sp_pay_from_customer 6010 6010 0 0.00 0 2896 10 0 0
t$perf-norm:sp_pay_to_supplier 4966 4966 0 0.00 0 8994 14 0 0
t$perf-norm:sp_reserve_write_off 8383 8383 0 0.00 0 10901 13 0 0
t$perf-norm:sp_supplier_invoice 4567 4567 0 0.00 0 3894 19 0 0
t$perf-norm:sp_supplier_order 4600 4600 0 0.00 0 7029 18 0 0
t$perf-norm:srv_aggregate_perf_data 78 78 0 0.00 0 263 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 229 10 0 0
t$perf-norm:srv_make_invnt_saldo 405 405 0 0.00 0 1835 38 0 0
t$perf-norm:srv_make_money_saldo 670 670 0 0.00 0 1010 17 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 11 5 0 0
v_add_invoice_to_stock 8632 8378 254 2.94 0 9351 21 0 254
v_all_customers 32214 32214 0 0.00 0 14 1 0 0
v_all_suppliers 26130 26130 0 0.00 0 27 1 0 0
v_all_wares 34608 34608 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 772 772 0 0.00 0 2291 9 0 0
v_cancel_client_order 3050 3050 0 0.00 0 7168 8 0 0
v_cancel_customer_prepayment 1128 1128 0 0.00 0 1208 4 0 0
v_cancel_customer_reserve 1174 1174 0 0.00 0 1723 5 0 0
v_cancel_payment_to_supplier 676 676 0 0.00 0 1725 5 0 0
v_cancel_supplier_invoice 682 664 18 2.63 0 3873 22 0 18
v_cancel_supplier_order 678 678 0 0.00 0 2042 8 0 0
v_cancel_write_off 1606 1606 0 0.00 0 7229 24 0 0
v_max_id_clo_ord 4600 4600 0 0.00 0 468 1 0 0
v_max_id_clo_res 757 757 0 0.00 0 3662 13 0 0
v_max_id_ord_sup 4567 4567 0 0.00 0 4088 3 0 0
v_max_non_paid_invoice 1068 1068 0 0.00 0 4954 10 0 0
v_max_non_paid_realizn 2875 2875 0 0.00 0 3296 7 0 0
v_min_id_clo_ord 4600 4600 0 0.00 0 3952 11 0 0
v_min_id_clo_res 757 757 0 0.00 0 9192 24 0 0
v_min_id_ord_sup 4567 4567 0 0.00 0 4867 7 0 0
v_min_non_paid_invoice 4966 4966 0 0.00 0 5487 21 0 0
v_min_non_paid_realizn 6010 6010 0 0.00 0 10873 23 0 0
v_our_firm 8664 8664 0 0.00 0 17 1 0 0
v_reserve_write_off 16766 16766 0 0.00 0 29367 12 0 0
x_lock_depdocs_on_canc_invoice 9522 9522 0 0.00 0 22605 136 0 0
x_lock_depdocs_on_canc_sup_ord 339 339 0 0.00 0 6434 355 0 0
x_make_qstorno_1000_1200 4600 4600 0 0.00 2 32892 1289 0 0
x_make_qstorno_1200_2000 4567 4567 0 0.00 3 99430 3491 0 0
x_make_qstorno_2100_3300 405608 405608 0 0.00 0 50289 190 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-03-2024 22:11:39 to 29-03-2024 22:11:43.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
20:09:47 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
20:10:48 27975 8192000000 9900058816 10212405248 984926896 10.732 100 80 160 0 1011018432 5509920 20581616
20:12:21 18579 8192000000 9951532256 10275614720 1036604576 11.232 100 87 174 0 1066942112 8339440 21998096
20:13:49 15760 8192000000 9991512592 10325491712 1075750464 11.607 100 87 174 0 1107337168 10340080 21246624
20:15:11 7246 8192000000 10026442864 10369871872 1110967792 11.942 100 83 166 1 1142368144 11631296 19769056
20:16:20 7066 8192000000 10062348512 10418286592 1148772000 12.298 100 75 150 0 1179334176 12936176 17626000
20:17:31 4978 8192000000 10104062736 10470481920 1197175040 12.750 100 77 154 0 1226266384 12056912 17034432
20:18:38 2517 8192000000 10150684592 10526294016 1243796256 13.181 100 84 168 0 1275438672 13095536 18546880
20:19:42 795 8192000000 10186871232 10568167424 1276070432 13.477 100 84 168 0 1307673072 13399552 18203088
20:20:44 1066 8192000000 10207765904 10594234368 1300377552 13.699 100 92 183 1 1332840592 11937184 20525856
20:21:46 8998 8192000000 10196314400 10603864064 1307399184 13.762 100 35 71 0 1322741648 7153040 8189424
20:22:57 64363 8192000000 10207473968 10623737856 1314840512 13.830 100 38 75 0 1330330448 6244912 9245024
20:25:02 7311 8192000000 10208520976 10632384512 1324627952 13.919 100 23 44 0 1335850624 6256592 4966080
20:26:13 7072 8192000000 10223289312 10642051072 1329791760 13.965 100 31 64 2 1342807024 6006288 7008976
20:27:22 51916 8192000000 10233195504 10644201472 1330040016 13.968 100 44 90 0 1346511424 6000288 10471120
20:29:14 4671 8192000000 10223119712 10640637952 1318668992 13.865 99 34 68 1 1333330128 7042192 7618944
20:30:27 3995 8192000000 10246264704 10655502336 1339238416 14.051 100 50 97 0 1361940080 11614576 11087088
20:31:35 2640 8192000000 10243711920 10644979712 1328621808 13.955 100 70 137 2 1356950656 13298192 15030656
20:32:44 35334 8192000000 10209162784 10609278976 1271033728 13.431 96 44 88 1 1292807776 11838432 9935616
20:34:28 5849 8192000000 10244415824 10655928320 1332958544 13.994 100 46 90 0 1360821008 17097584 10764880
20:35:40 22250 8192000000 10198326512 10598350848 1235103968 13.101 94 41 82 0 1259411664 14678160 9629536
20:37:43 13085 8192000000 10219301648 10623094784 1301616592 13.710 99 40 80 0 1328720224 17595264 9508368
20:39:06 14237 8192000000 10242643824 10646036480 1318709792 13.865 100 58 116 0 1353639952 21995008 12935152
20:40:25 12850 8192000000 10253119216 10659569664 1331071680 13.977 100 54 108 0 1367244048 22753920 13418448
20:41:55 8946 8192000000 10237443536 10638712832 1318210256 13.861 100 49 98 2 1347774336 17906272 11657808
20:43:09 8954 8192000000 10256724464 10656579584 1326981728 13.940 100 62 124 1 1364919696 22644336 15293632
20:44:24 5723 8192000000 10281634496 10676314112 1341965168 14.075 100 76 146 2 1385112976 25623152 17524656
20:45:34 8977 8192000000 10281193648 10685100032 1346473648 14.116 100 58 116 0 1387644144 26437456 14733040
20:46:50 1579 8192000000 10322846608 10723229696 1372733952 14.352 100 77 151 0 1424271632 32487040 19050640
20:48:00 3195 8192000000 10334177808 10734665728 1383098176 14.444 100 78 155 1 1436908832 35188160 18622496
20:49:08 940 8192000000 10348703472 10752954368 1395732752 14.557 100 77 151 1 1454955136 40191248 19031136
20:50:12 1470 8192000000 10357697888 10766553088 1403097008 14.623 100 71 140 2 1463150368 41845248 18208112
20:51:22 6113 8192000000 10364830400 10775916544 1404067984 14.631 100 74 148 0 1470616848 47262912 19285952
20:52:35 4408 8192000000 10371334688 10786603008 1409030800 14.675 100 69 138 0 1477174400 49367168 18776432
20:53:47 6115 8192000000 10351075696 10777792512 1408863584 14.674 100 55 111 2 1462219792 38164656 15191552
20:55:09 11919 8192000000 10346668960 10790887424 1407133376 14.658 100 30 60 0 1454053328 38259392 8660560
20:56:31 38524 8192000000 10343940000 10783051776 1390820784 14.513 100 29 58 0 1440051856 41043936 8187136
20:58:13 3973 8192000000 10325051312 10765778944 1393157056 14.534 100 37 74 0 1431769344 29558832 9053456
20:59:21 21602 8192000000 10299318400 10750541824 1390950320 14.514 100 18 37 0 1414317232 18933456 4433456
21:00:46 44479 8192000000 10305187936 10742194176 1388248752 14.490 100 22 44 0 1405998288 12383456 5366080
21:02:31 87947 8192000000 10304557392 10750869504 1382179136 14.436 99 26 52 0 1396197392 8854272 5163984
21:05:13 97589 8192000000 10302226144 10765742080 1383239872 14.446 99 12 24 1 1397576384 11682528 2653984
21:07:51 23188 8192000000 10314326496 10760052736 1386360032 14.473 99 33 64 0 1407227616 13473136 7394448
21:09:17 24237 8192000000 10333636048 10783186944 1411268256 14.695 100 21 42 0 1438577264 22695504 4613504
21:10:43 36760 8192000000 10324057760 10800349184 1412372944 14.705 100 9 18 0 1439852224 25282208 2197072
21:12:23 115473 8192000000 10317790224 10767458304 1371725088 14.342 97 21 42 0 1387146512 10492016 4929408
21:15:29 36877 8192000000 10309771200 10775334912 1406309200 14.651 100 28 54 2 1426282960 13583568 6390192
21:17:16 42810 8192000000 10301379936 10746249216 1360876736 14.245 97 34 67 0 1378909632 10673360 7359536
21:19:00 9441 8192000000 10274345808 10721251328 1366759920 14.298 99 37 75 0 1385018416 9358768 8899728
21:20:10 73446 8192000000 10264664464 10713669632 1332017008 13.985 96 24 48 0 1348808368 10623152 6168208
21:22:26 31745 8192000000 10255144944 10704621568 1354233712 14.186 100 14 28 0 1368948448 11607360 3107376
21:23:58 34521 8192000000 10249153232 10691039232 1315597792 13.837 98 18 37 0 1331122816 11408448 4116576
21:25:34 64672 8192000000 10245808992 10692608000 1345359584 14.106 100 12 24 0 1357731808 9371808 3000416
21:27:40 14936 8192000000 10257234688 10696503296 1349154288 14.140 100 40 81 0 1373106784 14569808 9382688
21:30:01 56931 8192000000 10239561088 10696962048 1323837104 13.911 98 6 12 0 1336449200 11371760 1240336
21:32:01 20216 8192000000 10244800592 10680115200 1322641696 13.901 99 37 74 0 1344472192 13325152 8505344
21:34:20 45602 8192000000 10256600736 10694447104 1325484688 13.926 99 21 39 0 1340576224 11294752 3796784
21:36:29 62008 8192000000 10278940176 10724986880 1357690832 14.217 100 9 18 0 1377224000 17538720 1994448
21:38:32 65725 8192000000 10275857776 10712145920 1323544688 13.909 97 12 24 0 1338589120 12758560 2285872
21:40:44 37508 8192000000 10295993072 10740793344 1370871600 14.335 99 19 38 0 1386793552 12052144 3869808
21:42:26 38494 8192000000 10284695904 10715959296 1341400944 14.070 97 40 77 2 1358886384 8541488 8943952
21:44:06 51291 8192000000 10292370384 10745679872 1384957744 14.461 100 49 95 1 1415115280 18727040 11430496
21:47:36 69739 8192000000 10284562736 10745262080 1365635152 14.288 98 15 29 0 1377044576 8411824 2997600
21:49:48 56148 8192000000 10312670800 10768527360 1410741984 14.691 100 20 41 0 1427676640 11855296 5079360
21:51:44 72944 8192000000 10317934416 10776576000 1398562368 14.582 99 12 24 0 1421756384 20222944 2971072
21:54:00 53651 8192000000 10315345296 10771820544 1401406928 14.608 99 22 44 1 1431805936 24889824 5509184
21:55:55 40596 8192000000 10310082432 10766725120 1384220384 14.454 98 15 30 0 1404126528 16279008 3627136
21:57:51 53212 8192000000 10325106272 10772430848 1398329792 14.580 99 14 28 0 1414435360 12738448 3367120
21:59:58 61293 8192000000 10308865088 10764668928 1381917568 14.434 98 22 42 0 1395763872 9122144 4724160
22:02:04 31310 8192000000 10303841376 10751197184 1377976672 14.398 99 29 58 0 1394101504 9887536 6237296
22:03:37 77057 8192000000 10301508096 10749251584 1320958544 13.885 95 21 42 1 1336888176 11629936 4299696
22:05:55 53027 8192000000 10283382144 10745413632 1352888608 14.173 98 23 46 0 1379183616 21299008 4996000
22:07:51 99903 8192000000 10273852816 10720198656 1334062272 14.004 97 29 57 0 1350901664 10597984 6241408

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 29-03-2024 22:11:45 to 29-03-2024 22:11:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 127 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          172360
MON$OLDEST_ACTIVE               174059
MON$OLDEST_SNAPSHOT             174059
MON$NEXT_TRANSACTION            174059
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1934560
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Fri Mar 29 22:12:03 2024 
 
Database header page information: 
    Flags            0 
    Generation        90649 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    172360 
    Oldest active        174059 
    Oldest snapshot        174059 
    Next transaction    174060 
    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 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.58, total records: 7695457 
    Average version length: 48.16, total versions: 49496, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87752 
    Data pages: 87752, average fill: 70% 
    Primary pages: 87752, secondary pages: 0, swept pages: 38282 
    Empty pages: 4, full pages: 50546 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 602 
    40 - 59% = 5540 
    60 - 79% = 81550 
    80 - 99% = 8 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23345, nodes: 7695457 
    Average node length: 18.86, total dup: 0, max dup: 0 
    Average key length: 15.87, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1669536, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 343 
        20 - 39% = 2140 
        40 - 59% = 4052 
        60 - 79% = 2518 
        80 - 99% = 14292 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13525, nodes: 7695457 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1492660, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1750 
        40 - 59% = 1948 
        60 - 79% = 1199 
        80 - 99% = 8628 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8354, nodes: 7695457 
    Average node length: 6.60, total dup: 5776743, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1485768, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 1089 
        40 - 59% = 1315 
        60 - 79% = 1034 
        80 - 99% = 4784 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.70, total records: 2209304 
    Average version length: 34.70, total versions: 55110, max versions: 3 
    Average fragment length: 6.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28864 
    Data pages: 28864, average fill: 71% 
    Primary pages: 28857, secondary pages: 7, swept pages: 16223 
    Empty pages: 7, full pages: 16214 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 307 
    40 - 59% = 3121 
    60 - 79% = 24986 
    80 - 99% = 392 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4561, nodes: 2209304 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 667716, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1007 
        40 - 59% = 809 
        60 - 79% = 796 
        80 - 99% = 1949 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2524, nodes: 2211219 
    Average node length: 4.97, total dup: 2210320, max dup: 21055 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1232926, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 327 
        40 - 59% = 1515 
        60 - 79% = 500 
        80 - 99% = 181 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2039, nodes: 2209304 
    Average node length: 4.97, total dup: 2209254, max dup: 130277 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1058021, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 257 
        40 - 59% = 876 
        60 - 79% = 57 
        80 - 99% = 847 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4363, nodes: 2209304 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 667716, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 106 
        20 - 39% = 641 
        40 - 59% = 636 
        60 - 79% = 881 
        80 - 99% = 2099 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.57, total records: 400 
    Average version length: 24.13, total versions: 208049, max versions: 543 
    Average fragment length: 2.00, total fragments: 37, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 2, data page slots: 1192 
    Data pages: 1192, average fill: 89% 
    Primary pages: 12, secondary pages: 1180, swept pages: 0 
    Empty pages: 5, full pages: 1186 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 1185 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 7.72, total records: 81642 
    Average version length: 68.31, total versions: 72411, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 1984 
    Data pages: 1488, average fill: 68% 
    Primary pages: 1487, secondary pages: 1, swept pages: 2 
    Empty pages: 180, full pages: 981 
    Fill distribution: 
     0 - 19% = 213 
    20 - 39% = 95 
    40 - 59% = 100 
    60 - 79% = 245 
    80 - 99% = 835 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705146, depth: 3, leaf buckets: 315, nodes: 81642 
    Average node length: 13.41, total dup: 6605, max dup: 1 
    Average key length: 10.62, compression ratio: 2.54 
    Average prefix length: 19.29, average data length: 7.71 
    Clustering factor: 59222, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 166 
        40 - 59% = 99 
        60 - 79% = 49 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18453, max versions: 988 
    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: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 62 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 2.67, total records: 1375 
    Average version length: 43.86, total versions: 1291, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 21.75 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 42% 
    Primary pages: 30, secondary pages: 2, swept pages: 7 
    Empty pages: 12, full pages: 11 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 9 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 88457, depth: 2, leaf buckets: 2, nodes: 1375 
    Average node length: 4.17, total dup: 1277, max dup: 173 
    Average key length: 2.76, compression ratio: 6.89 
    Average prefix length: 18.31, average data length: 0.69 
    Clustering factor: 710, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.29, total records: 73 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.76, total records: 812069 
    Average version length: 25.72, total versions: 42328, max versions: 6 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8168 
    Data pages: 8168, average fill: 69% 
    Primary pages: 8151, secondary pages: 17, swept pages: 3286 
    Empty pages: 7, full pages: 4622 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 45 
    40 - 59% = 439 
    60 - 79% = 7543 
    80 - 99% = 122 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 911, nodes: 812069 
    Average node length: 4.87, total dup: 812020, max dup: 147149 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90430, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 153 
        40 - 59% = 518 
        60 - 79% = 173 
        80 - 99% = 66 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 990, nodes: 812069 
    Average node length: 5.88, total dup: 723030, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161591, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 101 
        40 - 59% = 507 
        60 - 79% = 127 
        80 - 99% = 252 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1029, nodes: 812069 
    Average node length: 5.88, total dup: 723030, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163484, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 213 
        40 - 59% = 457 
        60 - 79% = 94 
        80 - 99% = 265 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1167, nodes: 812069 
    Average node length: 5.96, total dup: 723030, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 156334, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 250 
        40 - 59% = 632 
        60 - 79% = 211 
        80 - 99% = 70 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.86, total records: 5466 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.75, total fragments: 76, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 128 
    Data pages: 120, average fill: 45% 
    Primary pages: 99, secondary pages: 21, swept pages: 56 
    Empty pages: 36, full pages: 67 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5466 
    Average node length: 5.47, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.07 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5033, ratio: 0.92 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5466 
    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: 145, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.13, total records: 79533 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 766 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 766 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34757, depth: 2, leaf buckets: 102, nodes: 79533 
    Average node length: 10.19, total dup: 0, max dup: 0 
    Average key length: 8.20, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3205, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 3 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 138.28, total records: 184755 
    Average version length: 152.28, total versions: 15444, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.27 
    Pointer pages: 6, data page slots: 5488 
    Data pages: 4464, average fill: 86% 
    Primary pages: 4463, secondary pages: 1, swept pages: 6 
    Empty pages: 66, full pages: 4359 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 12 
    40 - 59% = 10 
    60 - 79% = 14 
    80 - 99% = 4357 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 137.23, total records: 187745 
    Average version length: 152.61, total versions: 16871, 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: 7, data page slots: 7368 
    Data pages: 4528, average fill: 86% 
    Primary pages: 4528, secondary pages: 0, swept pages: 2 
    Empty pages: 68, full pages: 4435 
    Fill distribution: 
     0 - 19% = 70 
    20 - 39% = 13 
    40 - 59% = 8 
    60 - 79% = 2 
    80 - 99% = 4435 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 119.17, total records: 199158 
    Average version length: 154.09, total versions: 41857, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.23 
    Pointer pages: 7, data page slots: 6344 
    Data pages: 4880, average fill: 86% 
    Primary pages: 4879, secondary pages: 1, swept pages: 7 
    Empty pages: 130, full pages: 4722 
    Fill distribution: 
     0 - 19% = 132 
    20 - 39% = 14 
    40 - 59% = 8 
    60 - 79% = 5 
    80 - 99% = 4721 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 125.69, total records: 209080 
    Average version length: 154.08, total versions: 35283, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.49 
    Pointer pages: 7, data page slots: 6792 
    Data pages: 5016, average fill: 88% 
    Primary pages: 5015, secondary pages: 1, swept pages: 4 
    Empty pages: 37, full pages: 4967 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 2 
    80 - 99% = 4966 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 132.06, total records: 172843 
    Average version length: 152.95, total versions: 21535, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.84 
    Pointer pages: 7, data page slots: 8192 
    Data pages: 4152, average fill: 87% 
    Primary pages: 4152, secondary pages: 0, swept pages: 8 
    Empty pages: 42, full pages: 4086 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 4085 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 139.90, total records: 181979 
    Average version length: 151.79, total versions: 13384, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.12 
    Pointer pages: 8, data page slots: 6576 
    Data pages: 4416, average fill: 85% 
    Primary pages: 4416, secondary pages: 0, swept pages: 2 
    Empty pages: 90, full pages: 4304 
    Fill distribution: 
     0 - 19% = 92 
    20 - 39% = 13 
    40 - 59% = 4 
    60 - 79% = 5 
    80 - 99% = 4302 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 135.24, total records: 190682 
    Average version length: 152.76, total versions: 19779, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.54 
    Pointer pages: 7, data page slots: 7248 
    Data pages: 4544, average fill: 87% 
    Primary pages: 4543, secondary pages: 1, swept pages: 8 
    Empty pages: 16, full pages: 4505 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 2 
    40 - 59% = 8 
    60 - 79% = 11 
    80 - 99% = 4506 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 125.31, total records: 199203 
    Average version length: 153.76, total versions: 33864, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.53 
    Pointer pages: 7, data page slots: 8952 
    Data pages: 4808, average fill: 87% 
    Primary pages: 4808, secondary pages: 0, swept pages: 4 
    Empty pages: 65, full pages: 4718 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 8 
    40 - 59% = 9 
    60 - 79% = 9 
    80 - 99% = 4717 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 115.86, total records: 237308 
    Average version length: 154.43, total versions: 55700, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.64 
    Pointer pages: 7, data page slots: 7888 
    Data pages: 5848, average fill: 86% 
    Primary pages: 5848, secondary pages: 0, swept pages: 11 
    Empty pages: 156, full pages: 5629 
    Fill distribution: 
     0 - 19% = 160 
    20 - 39% = 22 
    40 - 59% = 20 
    60 - 79% = 17 
    80 - 99% = 5629 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 118.82, total records: 216801 
    Average version length: 154.12, total versions: 46411, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.27 
    Pointer pages: 9, data page slots: 5856 
    Data pages: 5264, average fill: 87% 
    Primary pages: 5264, secondary pages: 0, swept pages: 8 
    Empty pages: 87, full pages: 5144 
    Fill distribution: 
     0 - 19% = 91 
    20 - 39% = 9 
    40 - 59% = 7 
    60 - 79% = 12 
    80 - 99% = 5145 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 52.00, total records: 2074039 
    Average version length: 52.93, total versions: 29374, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25632 
    Data pages: 25624, average fill: 70% 
    Primary pages: 25624, secondary pages: 0, swept pages: 12975 
    Empty pages: 371, full pages: 19165 
    Fill distribution: 
     0 - 19% = 694 
    20 - 39% = 553 
    40 - 59% = 1517 
    60 - 79% = 22619 
    80 - 99% = 241 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2582, nodes: 2074039 
    Average node length: 5.44, total dup: 1935018, max dup: 1381 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179731, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 353 
        40 - 59% = 1651 
        60 - 79% = 286 
        80 - 99% = 287 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2757, nodes: 2074039 
    Average node length: 5.70, total dup: 1860947, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 370921, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 2462 
        60 - 79% = 259 
        80 - 99% = 25 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2173, nodes: 2074039 
    Average node length: 4.96, total dup: 2073939, max dup: 28944 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177503, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 230 
        40 - 59% = 1222 
        60 - 79% = 355 
        80 - 99% = 365 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 46.63, total records: 116054 
    Average version length: 69.19, total versions: 37880, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.70 
    Pointer pages: 3, data page slots: 4224 
    Data pages: 3104, average fill: 44% 
    Primary pages: 3104, secondary pages: 0, swept pages: 608 
    Empty pages: 605, full pages: 545 
    Fill distribution: 
     0 - 19% = 831 
    20 - 39% = 390 
    40 - 59% = 839 
    60 - 79% = 717 
    80 - 99% = 327 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 99738, depth: 3, leaf buckets: 219, nodes: 116054 
    Average node length: 6.54, total dup: 100796, max dup: 14 
    Average key length: 4.00, compression ratio: 10.49 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 20233, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 91 
        40 - 59% = 110 
        60 - 79% = 17 
        80 - 99% = 0 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.96, total records: 7012321 
    Average version length: 68.80, total versions: 203797, 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: 65, data page slots: 104584 
    Data pages: 104584, average fill: 72% 
    Primary pages: 104584, secondary pages: 0, swept pages: 59970 
    Empty pages: 19, full pages: 56596 
    Fill distribution: 
     0 - 19% = 65 
    20 - 39% = 542 
    40 - 59% = 8579 
    60 - 79% = 93250 
    80 - 99% = 2148 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10818, nodes: 7012321 
    Average node length: 6.51, total dup: 6063985, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1553021, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1795 
        40 - 59% = 6127 
        60 - 79% = 2444 
        80 - 99% = 443 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8791, nodes: 7012321 
    Average node length: 5.40, total dup: 6733093, max dup: 137 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1368695, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1411 
        40 - 59% = 5201 
        60 - 79% = 1270 
        80 - 99% = 898 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8857, nodes: 7012321 
    Average node length: 5.40, total dup: 6733093, max dup: 137 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1371086, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1469 
        40 - 59% = 5242 
        60 - 79% = 1281 
        80 - 99% = 859 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.88, total records: 12124707 
    Average version length: 68.69, total versions: 188118, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 105, data page slots: 171208 
    Data pages: 171208, average fill: 75% 
    Primary pages: 171208, secondary pages: 0, swept pages: 107259 
    Empty pages: 0, full pages: 140526 
    Fill distribution: 
     0 - 19% = 23 
    20 - 39% = 402 
    40 - 59% = 5158 
    60 - 79% = 162608 
    80 - 99% = 3017 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18487, nodes: 12124707 
    Average node length: 6.60, total dup: 10568693, max dup: 63 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2371625, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 2115 
        40 - 59% = 11040 
        60 - 79% = 4575 
        80 - 99% = 726 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 49.80, total records: 1331113 
    Average version length: 69.12, total versions: 372394, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.53 
    Pointer pages: 30, data page slots: 46888 
    Data pages: 28952, average fill: 52% 
    Primary pages: 28952, secondary pages: 0, swept pages: 13966 
    Empty pages: 5093, full pages: 14068 
    Fill distribution: 
     0 - 19% = 7985 
    20 - 39% = 2716 
    40 - 59% = 2432 
    60 - 79% = 10163 
    80 - 99% = 5656 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2193, nodes: 1331113 
    Average node length: 5.53, total dup: 1276664, max dup: 57 
    Average key length: 2.58, compression ratio: 16.27 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 89539, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1090 
        40 - 59% = 884 
        60 - 79% = 183 
        80 - 99% = 25 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 48.39, total records: 861045 
    Average version length: 69.15, total versions: 257225, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.60 
    Pointer pages: 21, data page slots: 33920 
    Data pages: 26848, average fill: 37% 
    Primary pages: 26848, secondary pages: 0, swept pages: 9827 
    Empty pages: 5275, full pages: 3229 
    Fill distribution: 
     0 - 19% = 8810 
    20 - 39% = 4803 
    40 - 59% = 6550 
    60 - 79% = 4953 
    80 - 99% = 1732 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1518, nodes: 861045 
    Average node length: 5.80, total dup: 803042, max dup: 95 
    Average key length: 2.89, compression ratio: 14.56 
    Average prefix length: 41.18, average data length: 0.82 
    Clustering factor: 117350, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 794 
        40 - 59% = 595 
        60 - 79% = 112 
        80 - 99% = 13 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.22, total records: 8875653 
    Average version length: 68.96, total versions: 215363, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 91, data page slots: 148088 
    Data pages: 148032, average fill: 64% 
    Primary pages: 148031, secondary pages: 1, swept pages: 96356 
    Empty pages: 862, full pages: 60444 
    Fill distribution: 
     0 - 19% = 2670 
    20 - 39% = 11695 
    40 - 59% = 31593 
    60 - 79% = 99250 
    80 - 99% = 2824 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13500, nodes: 8875653 
    Average node length: 6.71, total dup: 7362916, max dup: 23 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1888035, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1643 
        40 - 59% = 7149 
        60 - 79% = 4275 
        80 - 99% = 430 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21151889 
    Average version length: 82.79, total versions: 4835, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318952 
    Data pages: 318952, average fill: 81% 
    Primary pages: 318952, secondary pages: 0, swept pages: 14032 
    Empty pages: 52, full pages: 317607 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 45 
    40 - 59% = 190 
    60 - 79% = 28241 
    80 - 99% = 290402 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19602, nodes: 21151889 
    Average node length: 5.72, total dup: 20670978, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3281580, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8579 
        60 - 79% = 534 
        80 - 99% = 10484 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17184, nodes: 21151889 
    Average node length: 6.31, total dup: 18588267, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915348, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 6 
        40 - 59% = 777 
        60 - 79% = 294 
        80 - 99% = 16104 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21387, nodes: 21151889 
    Average node length: 6.35, total dup: 18507036, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3576045, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 4 
        40 - 59% = 8827 
        60 - 79% = 603 
        80 - 99% = 11949 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16173, nodes: 21151889 
    Average node length: 5.56, total dup: 21151789, max dup: 232050 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944152, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 8 
        40 - 59% = 2999 
        60 - 79% = 432 
        80 - 99% = 12732 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 73.13, total records: 10269199 
    Average version length: 82.61, total versions: 1156243, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.72 
    Pointer pages: 108, data page slots: 176104 
    Data pages: 176072, average fill: 73% 
    Primary pages: 176072, secondary pages: 0, swept pages: 36478 
    Empty pages: 815, full pages: 122343 
    Fill distribution: 
     0 - 19% = 2185 
    20 - 39% = 6798 
    40 - 59% = 23844 
    60 - 79% = 49260 
    80 - 99% = 93985 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11432, nodes: 10269199 
    Average node length: 5.39, total dup: 9957895, max dup: 280 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2213954, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 56 
        40 - 59% = 6140 
        60 - 79% = 5058 
        80 - 99% = 175 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 14045, nodes: 10269199 
    Average node length: 6.26, total dup: 8518161, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1526052, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 168 
        20 - 39% = 3539 
        40 - 59% = 4975 
        60 - 79% = 2519 
        80 - 99% = 2844 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12763, nodes: 10269199 
    Average node length: 5.99, total dup: 8946130, max dup: 69 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2428164, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 55 
        40 - 59% = 7174 
        60 - 79% = 5329 
        80 - 99% = 203 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10526, nodes: 10269199 
    Average node length: 5.17, total dup: 10269099, max dup: 166233 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1580609, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1058 
        40 - 59% = 5358 
        60 - 79% = 1679 
        80 - 99% = 2393 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.56, total records: 11302201 
    Average version length: 82.42, total versions: 513568, 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: 119, data page slots: 194032 
    Data pages: 192728, average fill: 72% 
    Primary pages: 192728, secondary pages: 0, swept pages: 72832 
    Empty pages: 3184, full pages: 137556 
    Fill distribution: 
     0 - 19% = 5495 
    20 - 39% = 8060 
    40 - 59% = 19577 
    60 - 79% = 47631 
    80 - 99% = 111965 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13136, nodes: 11302201 
    Average node length: 5.32, total dup: 11192836, max dup: 631 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2353199, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 92 
        40 - 59% = 9232 
        60 - 79% = 3676 
        80 - 99% = 136 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10487, nodes: 11302201 
    Average node length: 5.51, total dup: 10808583, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 710535, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 162 
        20 - 39% = 841 
        40 - 59% = 2583 
        60 - 79% = 1846 
        80 - 99% = 5055 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15024, nodes: 11302201 
    Average node length: 6.04, total dup: 9865361, max dup: 71 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2369581, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 108 
        40 - 59% = 10830 
        60 - 79% = 3910 
        80 - 99% = 170 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10852, nodes: 11302201 
    Average node length: 5.24, total dup: 11302101, max dup: 215669 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 700153, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 72 
        20 - 39% = 883 
        40 - 59% = 4933 
        60 - 79% = 1458 
        80 - 99% = 3506 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 73.83, total records: 10338883 
    Average version length: 82.90, total versions: 1112789, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.71 
    Pointer pages: 110, data page slots: 179496 
    Data pages: 179424, average fill: 72% 
    Primary pages: 179424, secondary pages: 0, swept pages: 39985 
    Empty pages: 794, full pages: 120761 
    Fill distribution: 
     0 - 19% = 2165 
    20 - 39% = 7801 
    40 - 59% = 26512 
    60 - 79% = 51451 
    80 - 99% = 91495 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12230, nodes: 10338883 
    Average node length: 5.21, total dup: 10309300, max dup: 2096 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2057821, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 20 
        20 - 39% = 1302 
        40 - 59% = 7993 
        60 - 79% = 2206 
        80 - 99% = 709 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14101, nodes: 10338883 
    Average node length: 6.28, total dup: 8574988, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1493929, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 180 
        20 - 39% = 3522 
        40 - 59% = 4939 
        60 - 79% = 2500 
        80 - 99% = 2960 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12889, nodes: 10338883 
    Average node length: 5.46, total dup: 9886833, max dup: 108 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2195523, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 1301 
        40 - 59% = 8917 
        60 - 79% = 1962 
        80 - 99% = 686 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10695, nodes: 10338883 
    Average node length: 5.18, total dup: 10338783, max dup: 170382 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1605734, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1143 
        40 - 59% = 5478 
        60 - 79% = 1654 
        80 - 99% = 2373 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.29, total records: 581770 
    Average version length: 68.80, total versions: 15966, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 5, data page slots: 8040 
    Data pages: 8040, average fill: 76% 
    Primary pages: 8040, secondary pages: 0, swept pages: 2746 
    Empty pages: 1, full pages: 7078 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 23 
    40 - 59% = 227 
    60 - 79% = 7476 
    80 - 99% = 312 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 35053, depth: 3, leaf buckets: 740, nodes: 581770 
    Average node length: 5.95, total dup: 495540, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100898, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 520 
        60 - 79% = 95 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 18668, depth: 3, leaf buckets: 755, nodes: 581770 
    Average node length: 6.15, total dup: 477314, max dup: 27 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100948, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 525 
        60 - 79% = 88 
        80 - 99% = 112 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 588, nodes: 581770 
    Average node length: 4.86, total dup: 581670, max dup: 9456 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89567, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 28 
        40 - 59% = 363 
        60 - 79% = 99 
        80 - 99% = 98 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar 29 22:12:26 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7695457 49496 1 0.0000 0.0000
DOC_LIST 2209304 55110 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 208049 543 52000.0000 0.0000
INVNT_TURNOVER_LOG 81642 72411 1 0.0000 0.0000
MONEY_SALDO 49 18453 988 37600.0000 0.0000
MONEY_TURNOVER_LOG 1375 1291 1 0.0000 0.0000
PDISTR 812069 42328 6 0.0000 0.0000
PERF_SPLIT_0 184755 15444 1 0.0000 0.0000
PERF_SPLIT_1 187745 16871 1 0.0000 0.0000
PERF_SPLIT_2 199158 41857 1 0.0000 0.0000
PERF_SPLIT_3 209080 35283 1 0.0000 0.0000
PERF_SPLIT_4 172843 21535 1 0.0000 0.0000
PERF_SPLIT_5 181979 13384 1 0.0000 0.0000
PERF_SPLIT_6 190682 19779 1 0.0000 0.0000
PERF_SPLIT_7 199203 33864 1 0.0000 0.0000
PERF_SPLIT_8 237308 55700 1 0.0000 0.0000
PERF_SPLIT_9 216801 46411 1 0.0000 0.0000
PSTORNED 2074039 29374 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 116054 37880 1 0.0000 0.0000
XQD_1000_3300 7012321 203797 1 0.0000 0.0000
XQD_1200_2000 12124707 188118 1 0.0000 0.0000
XQD_2000_3300 1331113 372394 1 0.0000 0.0000
XQD_2100_3300 861045 257225 1 0.0000 0.0000
XQD_3300_3400 8875653 215363 1 0.0000 0.0000
XQS_1000_1200 21151889 4835 1 0.0000 0.0000
XQS_1000_3300 10269199 1156243 1 0.0000 0.0000
XQS_1200_2000 11302201 513568 1 0.0000 0.0000
XQS_2100_3300 10338883 1112789 1 0.0000 0.0000
XQS_3300_3400 581770 15966 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 ---
:536: 
:537: mscs-test-161.budzdorov.ru    Fri Mar 29 22:09:44 2024
:538:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:539: 
:540: 
:541: mscs-test-161.budzdorov.ru    Fri Mar 29 22:09:46 2024
:542:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:543: 
:544: 
:545: mscs-test-161.budzdorov.ru    Fri Mar 29 22:09:46 2024
:546:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:547: 
--- end of diff output ---

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

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