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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15443792 kB
MemAvailable 30231380 kB
Buffers 0 kB
Cached 16275336 kB
SwapCached 2328 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-10 01:09:37
DTS_END                         2024-03-10 01:09:37.2160
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/49618
TRN_ID                          171561
ATT_ID                          547
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: 9494.94 21780 949494
customer order: creation 167.79 353 16779
customer order: refuse 14.71 360 1471
order to supplier: creation 45.12 1493 4512
order to supplier: removal 3.63 100323 363
invoice (draft): creation 46.09 3204 4609
invoice (draft): removal 52.17 804 5217
invoice accept: apply 42.35 20389 4235
invoice accept: cancel 47.71 861 4771
customer reserve: creation 4098.16 194 409816
customer reserve: removal 4681.71 61 468171
realization accept: apply 82.49 205 8249
realization accept: cancel 84.33 139 8433
payment from customer: creation 58.92 128 5892
payment from customer: removal 5.82 80 582
payment to supplier: creation 48.85 152 4885
payment to supplier: removal 3.33 108 333
service: total inventory turnovers 4.45 1402 445
service: total monetary turnovers 6.52 38 652
service: aggregate perf. data 0.76 24593 76
service: refresh index statistics 0.03 280721 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 10-03-2024 01:10:20 to 10-03-2024 01:10:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6947
TEST_TIME 2 5731
TEST_TIME 3 5797
TEST_TIME 4 5381
TEST_TIME 5 4813
TEST_TIME 6 4783
TEST_TIME 7 4678
TEST_TIME 8 4818
TEST_TIME 9 5111
TEST_TIME 10 5392
TEST_TIME 11 5432
TEST_TIME 12 5422
TEST_TIME 13 6133
TEST_TIME 14 6214
TEST_TIME 15 6141
TEST_TIME 16 6046
TEST_TIME 17 6373
TEST_TIME 18 6588
TEST_TIME 19 6628
TEST_TIME 20 6680
TEST_TIME 21 6939
TEST_TIME 22 7169
TEST_TIME 23 7253
TEST_TIME 24 7461
TEST_TIME 25 7747
TEST_TIME 26 8019
TEST_TIME 27 8060
TEST_TIME 28 8622
TEST_TIME 29 8643
TEST_TIME 30 8684
TEST_TIME 31 8756
TEST_TIME 32 8799
TEST_TIME 33 8813
TEST_TIME 34 9283
TEST_TIME 35 9672
TEST_TIME 36 9530
TEST_TIME 37 9433
TEST_TIME 38 9408
TEST_TIME 39 9533
TEST_TIME 40 9457
TEST_TIME 41 9471
TEST_TIME 42 9567
TEST_TIME 43 9615
TEST_TIME 44 9716
TEST_TIME 45 9698
TEST_TIME 46 9591
TEST_TIME 47 9434
TEST_TIME 48 9422
TEST_TIME 49 9450
TEST_TIME 50 9392
TEST_TIME 51 9317
TEST_TIME 52 9373
TEST_TIME 53 9281
TEST_TIME 54 9208
TEST_TIME 55 9331
TEST_TIME 56 9364
TEST_TIME 57 9288
TEST_TIME 58 9211
TEST_TIME 59 9172
TEST_TIME 60 9176
TEST_TIME 61 9385
TEST_TIME 62 9440
TEST_TIME 63 9395
TEST_TIME 64 9426
TEST_TIME 65 9438
TEST_TIME 66 9496
TEST_TIME 67 9483
TEST_TIME 68 9498
TEST_TIME 69 9555
TEST_TIME 70 9560
TEST_TIME 71 9582
TEST_TIME 72 9640
TEST_TIME 73 9747
TEST_TIME 74 9865
TEST_TIME 75 9787
TEST_TIME 76 9712
TEST_TIME 77 9606
TEST_TIME 78 9577
TEST_TIME 79 9642
TEST_TIME 80 9581
TEST_TIME 81 9505
TEST_TIME 82 9489
TEST_TIME 83 9497
TEST_TIME 84 9421
TEST_TIME 85 9345
TEST_TIME 86 9439
TEST_TIME 87 9391
TEST_TIME 88 9362
TEST_TIME 89 9358
TEST_TIME 90 9365
TEST_TIME 91 9353
TEST_TIME 92 9370
TEST_TIME 93 9332
TEST_TIME 94 9334
TEST_TIME 95 9409
TEST_TIME 96 9447
TEST_TIME 97 9554
TEST_TIME 98 9508
TEST_TIME 99 9550
TEST_TIME 100 9504

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-03-2024 01:10:24 to 10-03-2024 01:10:27.

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 1324313 1324313 0 0.00 0 44860 7 0 0
doc_list_biud 1324313 1324313 0 0.00 0 24902 27 0 0
sp_add_invoice_to_stock 4338 4235 103 2.37 41 204612 20390 0 103
sp_cancel_adding_invoice 4771 4771 0 0.00 5 85584 862 0 0
sp_cancel_client_order 1471 1471 0 0.00 4 13922 360 0 0
sp_cancel_customer_reserve 468171 468171 0 0.00 0 23142 61 0 0
sp_cancel_pay_from_customer 582 582 0 0.00 3 4424 81 0 0
sp_cancel_pay_to_supplier 333 333 0 0.00 3 5949 108 0 0
sp_cancel_supplier_invoice 5227 5217 10 0.19 2 25000 805 0 10
sp_cancel_supplier_order 363 363 0 0.00 7 997195 100323 0 0
sp_cancel_write_off 8433 8433 0 0.00 1 13237 140 0 0
sp_client_order 16779 16779 0 0.00 3 16482 354 0 0
sp_customer_reserve 409816 409816 0 0.00 0 84042 195 0 0
sp_fill_shopping_cart 25888 25888 0 0.00 1 15784 39 0 0
sp_fill_shopping_cart_clo_res 409796 409796 0 0.00 0 22089 13 0 0
sp_get_clo_for_invoice 4215 4215 0 0.00 0 22945 266 0 0
sp_kill_cost_storno 14119 14119 0 0.00 0 15990 66 0 0
sp_kill_qstorno_ret_qs2qd 950355 950355 0 0.00 0 24896 33 0 0
sp_kill_qty_storno 500890 500890 0 0.00 0 24900 71 0 0
sp_lock_selected_doc 17318 17318 0 0.00 0 6397 4 0 0
sp_make_cost_storno 23241 23241 0 0.00 0 44755 64 0 0
sp_multiply_rows_for_pdistr 23241 23241 0 0.00 0 12218 31 0 0
sp_multiply_rows_for_qdistr 16779 16779 0 0.00 0 13230 157 0 0
sp_pay_from_customer 5892 5892 0 0.00 4 23730 128 0 0
sp_pay_to_supplier 4885 4885 0 0.00 4 20758 153 0 0
sp_payment_common 10777 10777 0 0.00 2 18053 34 0 0
sp_qd_handle_on_cancel_clo 1471 1471 0 0.00 0 13909 336 0 0
sp_qd_handle_on_invoice_upd_sts 8986 8986 0 0.00 0 16708 329 0 0
sp_qd_handle_on_reserve_upd_sts 8249 8249 0 0.00 0 23013 71 0 0
sp_reserve_write_off 8249 8249 0 0.00 6 23050 205 0 0
sp_supplier_invoice 4609 4609 0 0.00 7 75978 3204 0 0
sp_supplier_order 4512 4512 0 0.00 4 45649 1494 0 0
srv_aggregate_perf_data 76 76 0 0.00 1993 219577 24594 0 0
srv_fill_mon_cache_memory 55 55 0 0.00 2232 121967 37362 0 0
srv_find_qd_qs_mism 906767 906767 0 0.00 0 25285 6 0 0
srv_make_invnt_saldo 445 445 0 0.00 49 87986 1403 0 0
srv_make_money_saldo 652 652 0 0.00 1 5332 39 0 0
srv_recalc_idx_stat 3 3 0 0.00 196945 338498 280721 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4236 4236 0 0.00 0 11720 209 0 0
t$perf-norm:sp_cancel_adding_invoice 369 369 0 0.00 0 4320 97 0 0
t$perf-norm:sp_cancel_client_order 1471 1471 0 0.00 0 971 12 0 0
t$perf-norm:sp_cancel_customer_reserve 585 585 0 0.00 0 3799 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 582 582 0 0.00 0 645 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 333 333 0 0.00 0 335 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 356 356 0 0.00 0 784 16 0 0
t$perf-norm:sp_cancel_supplier_order 363 363 0 0.00 0 25314 1884 0 0
t$perf-norm:sp_cancel_write_off 800 800 0 0.00 0 2976 9 0 0
t$perf-norm:sp_client_order 16779 16779 0 0.00 0 10122 19 0 0
t$perf-norm:sp_customer_reserve 789 789 0 0.00 0 1076 8 0 0
t$perf-norm:sp_pay_from_customer 5892 5892 0 0.00 0 7545 16 0 0
t$perf-norm:sp_pay_to_supplier 4885 4885 0 0.00 0 3726 12 0 0
t$perf-norm:sp_reserve_write_off 8249 8249 0 0.00 0 8285 13 0 0
t$perf-norm:sp_supplier_invoice 4609 4609 0 0.00 0 7272 17 0 0
t$perf-norm:sp_supplier_order 4512 4512 0 0.00 0 4112 18 0 0
t$perf-norm:srv_aggregate_perf_data 76 76 0 0.00 0 595 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 55 55 0 0.00 0 5974 110 0 0
t$perf-norm:srv_make_invnt_saldo 445 445 0 0.00 0 1170 21 0 0
t$perf-norm:srv_make_money_saldo 652 652 0 0.00 0 3259 27 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 3 15 7 0 0
v_add_invoice_to_stock 8626 8420 206 2.38 0 4218 15 0 206
v_all_customers 31332 31332 0 0.00 0 21 1 0 0
v_all_suppliers 25770 25770 0 0.00 0 25 1 0 0
v_all_wares 33554 33554 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 738 738 0 0.00 0 4241 15 0 0
v_cancel_client_order 2942 2942 0 0.00 0 2301 5 0 0
v_cancel_customer_prepayment 1164 1164 0 0.00 0 3177 9 0 0
v_cancel_customer_reserve 1170 1170 0 0.00 0 1874 6 0 0
v_cancel_payment_to_supplier 666 666 0 0.00 0 1589 12 0 0
v_cancel_supplier_invoice 732 712 20 2.73 0 1632 17 0 20
v_cancel_supplier_order 726 726 0 0.00 0 1443 6 0 0
v_cancel_write_off 1600 1600 0 0.00 0 4238 16 0 0
v_max_id_clo_ord 4507 4507 0 0.00 0 10902 6 0 0
v_max_id_clo_res 788 788 0 0.00 0 1635 14 0 0
v_max_id_ord_sup 4604 4604 0 0.00 0 5469 7 0 0
v_max_non_paid_invoice 1111 1111 0 0.00 0 381 3 0 0
v_max_non_paid_realizn 2862 2862 0 0.00 0 4489 8 0 0
v_min_id_clo_ord 4507 4507 0 0.00 0 5664 14 0 0
v_min_id_clo_res 788 788 0 0.00 0 8461 19 0 0
v_min_id_ord_sup 4604 4604 0 0.00 0 10155 9 0 0
v_min_non_paid_invoice 4885 4885 0 0.00 0 9532 24 0 0
v_min_non_paid_realizn 5892 5892 0 0.00 0 12231 27 0 0
v_our_firm 8282 8282 0 0.00 0 16 1 0 0
v_reserve_write_off 16498 16498 0 0.00 0 6587 7 0 0
x_lock_depdocs_on_canc_invoice 9632 9632 0 0.00 0 34642 150 0 0
x_lock_depdocs_on_canc_sup_ord 363 363 0 0.00 0 7251 350 0 0
x_make_qstorno_1000_1200 4512 4512 0 0.00 1 45635 1395 0 0
x_make_qstorno_1200_2000 4609 4609 0 0.00 3 75942 3077 0 0
x_make_qstorno_2100_3300 409816 409816 0 0.00 0 84041 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-03-2024 01:10:28 to 10-03-2024 01:10:32.

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
23:09:41 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
23:10:43 32607 8192000000 9882475376 10189053952 961621808 10.505 100 89 178 0 991545888 5923056 24001024
23:12:21 22045 8192000000 9928490976 10243915776 1008785392 10.964 100 88 176 0 1039574416 7684704 23104320
23:13:50 14100 8192000000 9962028448 10292781056 1045867072 11.321 100 83 166 0 1075673488 8725904 21080512
23:15:14 12247 8192000000 10022827216 10370965504 1110277936 11.935 100 83 165 0 1140701712 10343728 20080048
23:16:32 7487 8192000000 10078809328 10438643712 1170307344 12.500 100 76 152 0 1199715824 11991024 17417456
23:17:47 2706 8192000000 10124909744 10495434752 1213492896 12.901 100 77 154 0 1243720784 13055152 17172736
23:18:54 2472 8192000000 10147729440 10523656192 1241930832 13.164 100 77 154 0 1271974320 13049808 16993680
23:19:58 2224 8192000000 10174841568 10561101824 1267537920 13.399 100 72 144 1 1296067040 12667856 15861264
23:21:02 1693 8192000000 10210210048 10591678464 1290307200 13.607 100 85 168 2 1321934960 13463648 18164112
23:22:05 6352 8192000000 10207421584 10602553344 1302032464 13.714 100 63 125 0 1323688832 7247728 14408640
23:23:14 22831 8192000000 10198044544 10609303552 1308763136 13.775 100 30 60 0 1322707456 7270144 6674176
23:24:43 5756 8192000000 10206019680 10623303680 1321435744 13.890 100 29 57 0 1333441424 5962992 6042688
23:25:52 5318 8192000000 10212199392 10633187328 1329265888 13.961 100 29 58 0 1342337472 6628176 6443408
23:26:57 5772 8192000000 10212487024 10634248192 1330381856 13.971 100 18 35 0 1340481648 6469248 3630544
23:28:08 9987 8192000000 10242502416 10650443776 1336881232 14.029 100 58 116 0 1361993712 12023296 13089184
23:29:18 5835 8192000000 10215583984 10634162176 1316886848 13.849 99 27 51 1 1328458160 5566464 6004848
23:30:32 2232 8192000000 10245277952 10653675520 1334928608 14.012 100 52 104 0 1359739008 13019952 11790448
23:31:37 11745 8192000000 10235366896 10641571840 1326284240 13.934 100 51 100 2 1347692928 10478560 10930128
23:32:52 75914 8192000000 10224119136 10641702912 1296969264 13.668 97 46 88 0 1316216672 8772544 10474864
23:35:28 14672 8192000000 10243935344 10649870336 1330270576 13.970 100 55 110 0 1355934496 12893968 12769952
23:36:45 23948 8192000000 10244313472 10650275840 1312091312 13.805 99 46 92 0 1337579888 15036944 10451632
23:38:20 19543 8192000000 10240717488 10647887872 1301633472 13.710 98 50 99 0 1333509664 20538576 11337616
23:39:53 3159 8192000000 10250831360 10655248384 1331546928 13.981 100 59 116 1 1365342336 20540944 13254464
23:41:02 10669 8192000000 10259520288 10666999808 1338406560 14.043 100 46 92 0 1369466304 19851920 11207824
23:42:21 4674 8192000000 10248479968 10648813568 1301600480 13.710 98 54 108 1 1336100752 22107184 12393088
23:43:35 16562 8192000000 10248168912 10656006144 1318183584 13.860 99 57 114 1 1353637744 22038608 13415552
23:45:02 13481 8192000000 10258427424 10670538752 1332528928 13.990 100 39 77 0 1364132272 22015760 9587584
23:46:30 4772 8192000000 10317768336 10719027200 1372127328 14.346 100 77 154 0 1419343488 28299120 18917040
23:47:40 6481 8192000000 10305355568 10709938176 1365159152 14.284 100 66 132 0 1407594240 26881424 15553664
23:48:51 8147 8192000000 10297626736 10706354176 1358375440 14.223 99 55 110 1 1400002352 27257360 14369552
23:50:07 8233 8192000000 10336539200 10743013376 1392294976 14.526 100 71 142 2 1441596880 32580400 16721504
23:51:20 5107 8192000000 10310955360 10736541696 1388586160 14.493 100 33 67 2 1424537792 26812288 9139344
23:52:35 9207 8192000000 10319101920 10750664704 1391778464 14.522 100 37 74 1 1433054000 31216944 10058592
23:54:01 8302 8192000000 10326183152 10752614400 1388236304 14.490 100 48 97 1 1432258000 31289760 12731936
23:55:13 15242 8192000000 10319744144 10759278592 1388433008 14.492 100 27 54 0 1429687616 33860256 7394352
23:56:31 11991 8192000000 10330294992 10758393856 1392141952 14.525 100 31 62 1 1433785216 32291920 9351344
23:58:07 19807 8192000000 10326378624 10759426048 1397759440 14.575 100 38 76 0 1432180480 24511264 9909776
23:59:46 17243 8192000000 10332670128 10769104896 1407384080 14.661 100 39 76 1 1437750208 20870560 9495568
00:01:07 15766 8192000000 10342142176 10781454336 1416014448 14.737 100 22 44 1 1447575104 25594720 5965936
00:03:48 35722 8192000000 10320679440 10779742208 1403659024 14.628 100 12 24 0 1430770720 24130240 2981456
00:06:44 39237 8192000000 10327813744 10780393472 1415268272 14.731 100 16 32 0 1432226432 13618512 3339648
00:08:41 103951 8192000000 10318831264 10768621568 1371143232 14.337 97 13 26 0 1385289136 11984448 2161456
00:11:29 121967 8192000000 10316226496 10768437248 1344137952 14.095 95 3 6 0 1355297216 10847232 312032
00:14:50 52977 8192000000 10310517056 10756206592 1395296064 14.553 99 15 30 1 1414763888 16360000 3107824
00:16:43 79370 8192000000 10290272992 10728087552 1283581680 13.546 91 39 78 2 1302732704 10557504 8593520
00:19:06 12839 8192000000 10287077968 10721820672 1360938912 14.246 98 42 82 1 1377864704 7524912 9400880
00:20:25 53075 8192000000 10280507216 10711470080 1290661472 13.610 93 50 96 1 1312324512 10823136 10839904
00:22:20 39837 8192000000 10291063904 10725724160 1357470464 14.215 99 38 76 1 1379058944 12530352 9058128
00:24:08 14439 8192000000 10293919104 10738532352 1373700080 14.360 100 42 84 0 1402480960 18845632 9935248
00:25:26 90902 8192000000 10282657552 10727112704 1343913616 14.093 97 15 28 0 1359483008 12114384 3455008
00:27:58 110165 8192000000 10273384352 10727514112 1353617536 14.180 98 14 26 0 1370371328 13583920 3169872
00:31:45 34086 8192000000 10254989424 10700038144 1317155088 13.851 97 13 26 0 1328284528 8495232 2634208
00:33:37 28719 8192000000 10262767552 10698375168 1317332656 13.853 97 35 70 0 1334115728 9241840 7541232
00:35:06 44793 8192000000 10249288608 10701320192 1334561360 14.008 99 24 48 0 1353636448 13727200 5347888
00:36:51 46399 8192000000 10263516384 10714173440 1342319808 14.078 99 30 60 0 1363279376 14333920 6625648
00:38:42 34346 8192000000 10270558944 10705264640 1346303312 14.114 99 36 70 1 1362138576 8118752 7716512
00:40:21 26037 8192000000 10296471536 10731954176 1371932288 14.344 100 36 72 0 1400426320 19962128 8531904
00:41:48 93346 8192000000 10308581024 10754568192 1380777056 14.423 100 15 30 0 1397043504 13289664 2976784
00:44:22 93328 8192000000 10300418112 10744713216 1366376160 14.295 98 24 48 1 1383952400 12048368 5527872
00:47:10 8321 8192000000 10294438496 10739695616 1383535024 14.448 100 35 71 0 1400807072 9434304 7837744
00:48:18 32677 8192000000 10289564848 10754424832 1377651264 14.396 99 24 48 1 1400631664 17213904 5766496
00:49:54 23545 8192000000 10289573696 10758651904 1391942688 14.523 100 5 10 0 1405194496 12436480 815328
00:51:27 37871 8192000000 10309355200 10751254528 1383474752 14.448 99 35 70 0 1401604736 9667376 8462608
00:53:14 69929 8192000000 10295553904 10758754304 1385237648 14.463 99 20 39 0 1405115728 15329216 4548864
00:55:24 51134 8192000000 10300888336 10746806272 1372225808 14.347 98 31 60 0 1385132976 6369264 6537904
00:57:24 78965 8192000000 10285855728 10752860160 1393634064 14.538 100 12 24 0 1410665792 13829808 3201920
00:59:53 57535 8192000000 10293442384 10756780032 1384718784 14.459 99 13 27 0 1396877376 9319728 2838864
01:01:51 18593 8192000000 10307231888 10749984768 1384793568 14.459 99 36 72 1 1403857696 10829312 8234816
01:03:17 58151 8192000000 10316676240 10776166400 1387818576 14.486 99 22 44 0 1408735456 15910144 5006736
01:05:16 58749 8192000000 10297259808 10748801024 1353891200 14.182 97 20 38 0 1375140384 17113536 4135648
01:07:42 76918 8192000000 10287001008 10743148544 1321283040 13.888 95 27 54 0 1340780240 13389040 6108160

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 10-03-2024 01:10:34 to 10-03-2024 01:10:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 103 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-03-2024 01:10:49 to 10-03-2024 01:10:51.

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          169851
MON$OLDEST_ACTIVE               171912
MON$OLDEST_SNAPSHOT             171912
MON$NEXT_TRANSACTION            171912
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                       1944480
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.33735 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33735 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33735 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33735 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 Sun Mar 10 01:10:52 2024 
 
Database header page information: 
    Flags            0 
    Generation        89508 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    169851 
    Oldest active        171912 
    Oldest snapshot        171912 
    Next transaction    171913 
    Sequence number        0 
    Next attachment ID    701 
    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: 46.92, total records: 7775697 
    Average version length: 48.16, total versions: 157416, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 54, data page slots: 87824 
    Data pages: 87824, average fill: 71% 
    Primary pages: 87824, secondary pages: 0, swept pages: 12437 
    Empty pages: 3, full pages: 72743 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 512 
    40 - 59% = 5456 
    60 - 79% = 81770 
    80 - 99% = 38 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23295, nodes: 7775697 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1706384, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 298 
        20 - 39% = 1771 
        40 - 59% = 4130 
        60 - 79% = 2443 
        80 - 99% = 14653 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13543, nodes: 7775697 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1530429, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1555 
        40 - 59% = 2051 
        60 - 79% = 1112 
        80 - 99% = 8825 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8357, nodes: 7775697 
    Average node length: 6.62, total dup: 5810379, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1523467, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 937 
        40 - 59% = 1383 
        60 - 79% = 945 
        80 - 99% = 4953 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.32, total records: 2254143 
    Average version length: 34.52, total versions: 162129, max versions: 4 
    Average fragment length: 4.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.52 
    Pointer pages: 18, data page slots: 28856 
    Data pages: 28856, average fill: 73% 
    Primary pages: 28847, secondary pages: 9, swept pages: 7357 
    Empty pages: 11, full pages: 21667 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 233 
    40 - 59% = 2601 
    60 - 79% = 24230 
    80 - 99% = 1753 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4553, nodes: 2254143 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 680022, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 874 
        40 - 59% = 874 
        60 - 79% = 755 
        80 - 99% = 2050 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2545, nodes: 2257708 
    Average node length: 4.97, total dup: 2256809, max dup: 18178 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1245647, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 272 
        40 - 59% = 1577 
        60 - 79% = 505 
        80 - 99% = 188 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2073, nodes: 2254143 
    Average node length: 4.97, total dup: 2254093, max dup: 129951 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1068022, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 131 
        40 - 59% = 1060 
        60 - 79% = 81 
        80 - 99% = 796 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4335, nodes: 2254143 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 680022, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 100 
        20 - 39% = 565 
        40 - 59% = 605 
        60 - 79% = 818 
        80 - 99% = 2247 
 
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.58, total records: 400 
    Average version length: 23.35, total versions: 228225, max versions: 592 
    Average fragment length: 2.00, total fragments: 37, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1280 
    Data pages: 1280, average fill: 90% 
    Primary pages: 8, secondary pages: 1272, swept pages: 0 
    Empty pages: 1, full pages: 1278 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1279 
 
    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: 24.73, total records: 85147 
    Average version length: 68.29, total versions: 54312, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 3.56 
    Pointer pages: 7, data page slots: 4304 
    Data pages: 2264, average fill: 45% 
    Primary pages: 2263, secondary pages: 1, swept pages: 0 
    Empty pages: 626, full pages: 887 
    Fill distribution: 
     0 - 19% = 852 
    20 - 39% = 233 
    40 - 59% = 189 
    60 - 79% = 314 
    80 - 99% = 676 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700969, depth: 3, leaf buckets: 396, nodes: 85148 
    Average node length: 13.53, total dup: 4902, max dup: 1 
    Average key length: 10.84, compression ratio: 2.49 
    Average prefix length: 19.10, average data length: 7.90 
    Clustering factor: 62885, ratio: 0.74 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 313 
        40 - 59% = 80 
        60 - 79% = 2 
        80 - 99% = 0 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.29, total records: 49 
    Average version length: 9.00, total versions: 17526, max versions: 947 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 88% 
    Primary pages: 3, secondary pages: 61, swept pages: 0 
    Empty pages: 2, full pages: 61 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 58 
 
    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.64, total records: 1225 
    Average version length: 43.30, total versions: 1151, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 21.95 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 31% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 12, full pages: 5 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 5 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 90732, depth: 2, leaf buckets: 1, nodes: 1225 
    Average node length: 4.50, total dup: 1127, max dup: 122 
    Average key length: 2.83, compression ratio: 6.71 
    Average prefix length: 18.25, average data length: 0.75 
    Clustering factor: 717, ratio: 0.59 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        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.00, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    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: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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: 35.61, total records: 842292 
    Average version length: 25.31, total versions: 91721, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.52 
    Pointer pages: 6, data page slots: 8296 
    Data pages: 8296, average fill: 72% 
    Primary pages: 8275, secondary pages: 21, swept pages: 809 
    Empty pages: 48, full pages: 7698 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 41 
    40 - 59% = 76 
    60 - 79% = 7700 
    80 - 99% = 403 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 903, nodes: 842292 
    Average node length: 4.88, total dup: 842243, max dup: 149024 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91659, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 94 
        40 - 59% = 525 
        60 - 79% = 201 
        80 - 99% = 83 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 997, nodes: 842292 
    Average node length: 5.89, total dup: 749775, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166445, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 79 
        40 - 59% = 508 
        60 - 79% = 144 
        80 - 99% = 264 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1051, nodes: 842292 
    Average node length: 5.89, total dup: 749775, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 168377, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 197 
        40 - 59% = 475 
        60 - 79% = 113 
        80 - 99% = 265 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1165, nodes: 842292 
    Average node length: 5.97, total dup: 749775, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 161003, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 227 
        40 - 59% = 608 
        60 - 79% = 225 
        80 - 99% = 103 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.85, total records: 5443 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.03, total fragments: 73, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 78, secondary pages: 17, swept pages: 45 
    Empty pages: 10, full pages: 65 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 67 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5443 
    Average node length: 5.48, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.04 
    Average prefix length: 34.41, average data length: 1.55 
    Clustering factor: 5073, ratio: 0.93 
    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: 5443 
    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: 142, 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.10, total records: 77916 
    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: 752 
    Data pages: 752, average fill: 71% 
    Primary pages: 752, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 750 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 750 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 36764, depth: 2, leaf buckets: 99, nodes: 77916 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.80, average data length: 5.20 
    Clustering factor: 3156, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 98 
 
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.12, 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.22 
    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: 139.15, total records: 184362 
    Average version length: 153.80, total versions: 14404, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.19 
    Pointer pages: 7, data page slots: 5856 
    Data pages: 4464, average fill: 86% 
    Primary pages: 4464, secondary pages: 0, swept pages: 6 
    Empty pages: 74, full pages: 4360 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 9 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 4360 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 145.11, total records: 178517 
    Average version length: 152.60, total versions: 7237, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.69 
    Pointer pages: 6, data page slots: 5920 
    Data pages: 4320, average fill: 85% 
    Primary pages: 4319, secondary pages: 1, swept pages: 6 
    Empty pages: 69, full pages: 4224 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 4222 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 146.39, total records: 160398 
    Average version length: 149.94, total versions: 4815, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.59 
    Pointer pages: 9, data page slots: 5400 
    Data pages: 3896, average fill: 85% 
    Primary pages: 3896, secondary pages: 0, swept pages: 4 
    Empty pages: 77, full pages: 3781 
    Fill distribution: 
     0 - 19% = 83 
    20 - 39% = 11 
    40 - 59% = 14 
    60 - 79% = 7 
    80 - 99% = 3781 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 142.83, total records: 154846 
    Average version length: 152.23, total versions: 8122, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.87 
    Pointer pages: 9, data page slots: 4832 
    Data pages: 3760, average fill: 85% 
    Primary pages: 3759, secondary pages: 1, swept pages: 3 
    Empty pages: 84, full pages: 3656 
    Fill distribution: 
     0 - 19% = 87 
    20 - 39% = 10 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3656 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 141.03, total records: 150736 
    Average version length: 152.99, total versions: 9966, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.03 
    Pointer pages: 8, data page slots: 5064 
    Data pages: 3696, average fill: 85% 
    Primary pages: 3696, secondary pages: 0, swept pages: 2 
    Empty pages: 106, full pages: 3557 
    Fill distribution: 
     0 - 19% = 108 
    20 - 39% = 15 
    40 - 59% = 7 
    60 - 79% = 9 
    80 - 99% = 3557 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 115.59, total records: 201221 
    Average version length: 154.80, total versions: 47232, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.67 
    Pointer pages: 7, data page slots: 6272 
    Data pages: 4928, average fill: 86% 
    Primary pages: 4928, secondary pages: 0, swept pages: 3 
    Empty pages: 117, full pages: 4782 
    Fill distribution: 
     0 - 19% = 123 
    20 - 39% = 13 
    40 - 59% = 8 
    60 - 79% = 2 
    80 - 99% = 4782 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 143.10, total records: 157886 
    Average version length: 153.01, total versions: 8135, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.85 
    Pointer pages: 7, data page slots: 6352 
    Data pages: 3864, average fill: 84% 
    Primary pages: 3864, secondary pages: 0, swept pages: 4 
    Empty pages: 98, full pages: 3713 
    Fill distribution: 
     0 - 19% = 103 
    20 - 39% = 4 
    40 - 59% = 38 
    60 - 79% = 7 
    80 - 99% = 3712 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 148.04, total records: 176242 
    Average version length: 149.21, total versions: 3646, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 5664 
    Data pages: 4232, average fill: 86% 
    Primary pages: 4232, secondary pages: 0, swept pages: 3 
    Empty pages: 46, full pages: 4170 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 9 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 4171 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 142.13, total records: 168341 
    Average version length: 152.95, total versions: 9734, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 6, data page slots: 4240 
    Data pages: 4032, average fill: 86% 
    Primary pages: 4032, secondary pages: 0, swept pages: 5 
    Empty pages: 40, full pages: 3983 
    Fill distribution: 
     0 - 19% = 44 
    20 - 39% = 1 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3981 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 141.99, total records: 186364 
    Average version length: 153.30, total versions: 11121, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.94 
    Pointer pages: 7, data page slots: 5848 
    Data pages: 4504, average fill: 86% 
    Primary pages: 4503, secondary pages: 1, swept pages: 1 
    Empty pages: 72, full pages: 4406 
    Fill distribution: 
     0 - 19% = 77 
    20 - 39% = 8 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4406 
 
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: 50.92, total records: 2112450 
    Average version length: 52.88, total versions: 73055, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.37 
    Pointer pages: 16, data page slots: 25672 
    Data pages: 25672, average fill: 71% 
    Primary pages: 25672, secondary pages: 0, swept pages: 9208 
    Empty pages: 297, full pages: 21242 
    Fill distribution: 
     0 - 19% = 616 
    20 - 39% = 468 
    40 - 59% = 1027 
    60 - 79% = 22903 
    80 - 99% = 658 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2597, nodes: 2112450 
    Average node length: 5.44, total dup: 1971768, max dup: 1746 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182088, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 287 
        40 - 59% = 1695 
        60 - 79% = 302 
        80 - 99% = 305 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2753, nodes: 2112450 
    Average node length: 5.69, total dup: 1896280, max dup: 65 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 377039, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2364 
        60 - 79% = 355 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2163, nodes: 2112450 
    Average node length: 4.96, total dup: 2112350, max dup: 27830 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179720, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 220 
        40 - 59% = 1130 
        60 - 79% = 397 
        80 - 99% = 416 
 
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: 35.17, total records: 163085 
    Average version length: 69.18, total versions: 80249, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.58 
    Pointer pages: 3, data page slots: 4192 
    Data pages: 3240, average fill: 59% 
    Primary pages: 3240, secondary pages: 0, swept pages: 467 
    Empty pages: 694, full pages: 2076 
    Fill distribution: 
     0 - 19% = 850 
    20 - 39% = 29 
    40 - 59% = 93 
    60 - 79% = 870 
    80 - 99% = 1398 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104590, depth: 3, leaf buckets: 222, nodes: 163085 
    Average node length: 6.44, total dup: 142200, max dup: 14 
    Average key length: 3.90, compression ratio: 10.76 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 27342, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 21 
        40 - 59% = 102 
        60 - 79% = 67 
        80 - 99% = 32 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 62.89, total records: 7536388 
    Average version length: 68.75, total versions: 662933, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.00 
    Pointer pages: 64, data page slots: 103872 
    Data pages: 103872, average fill: 78% 
    Primary pages: 103872, secondary pages: 0, swept pages: 11743 
    Empty pages: 7, full pages: 102158 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 197 
    40 - 59% = 446 
    60 - 79% = 85559 
    80 - 99% = 17610 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10891, nodes: 7536388 
    Average node length: 6.51, total dup: 6520317, max dup: 42 
    Average key length: 3.52, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1659209, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1177 
        40 - 59% = 5782 
        60 - 79% = 3207 
        80 - 99% = 719 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8843, nodes: 7536388 
    Average node length: 5.39, total dup: 7245267, max dup: 162 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1439969, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1005 
        40 - 59% = 4892 
        60 - 79% = 1761 
        80 - 99% = 1178 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8884, nodes: 7536388 
    Average node length: 5.39, total dup: 7245267, max dup: 162 
    Average key length: 2.39, compression ratio: 7.10 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1442474, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1073 
        40 - 59% = 4809 
        60 - 79% = 1774 
        80 - 99% = 1222 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.24, total records: 12492615 
    Average version length: 68.69, total versions: 491483, 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: 105, data page slots: 170968 
    Data pages: 170968, average fill: 78% 
    Primary pages: 170968, secondary pages: 0, swept pages: 59365 
    Empty pages: 7, full pages: 170912 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 2 
    40 - 59% = 4 
    60 - 79% = 158183 
    80 - 99% = 12772 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18564, nodes: 12492615 
    Average node length: 6.61, total dup: 10885259, max dup: 69 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2423506, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 16 
        20 - 39% = 1816 
        40 - 59% = 10491 
        60 - 79% = 5340 
        80 - 99% = 901 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 32.31, total records: 2007646 
    Average version length: 69.12, total versions: 1069389, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.90 
    Pointer pages: 30, data page slots: 47776 
    Data pages: 30800, average fill: 76% 
    Primary pages: 30799, secondary pages: 1, swept pages: 3264 
    Empty pages: 1744, full pages: 26395 
    Fill distribution: 
     0 - 19% = 2578 
    20 - 39% = 818 
    40 - 59% = 613 
    60 - 79% = 9304 
    80 - 99% = 17487 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2328, nodes: 2007646 
    Average node length: 5.51, total dup: 1926444, max dup: 99 
    Average key length: 2.54, compression ratio: 16.52 
    Average prefix length: 41.50, average data length: 0.50 
    Clustering factor: 135308, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 183 
        40 - 59% = 1092 
        60 - 79% = 729 
        80 - 99% = 305 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 33.40, total records: 1232954 
    Average version length: 69.14, total versions: 636181, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.77 
    Pointer pages: 22, data page slots: 35688 
    Data pages: 29112, average fill: 50% 
    Primary pages: 29112, secondary pages: 0, swept pages: 5959 
    Empty pages: 6932, full pages: 13594 
    Fill distribution: 
     0 - 19% = 9694 
    20 - 39% = 1336 
    40 - 59% = 1873 
    60 - 79% = 7380 
    80 - 99% = 8829 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1624, nodes: 1232954 
    Average node length: 5.79, total dup: 1151365, max dup: 99 
    Average key length: 2.85, compression ratio: 14.73 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 167806, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 261 
        40 - 59% = 773 
        60 - 79% = 478 
        80 - 99% = 110 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 62.98, total records: 9383260 
    Average version length: 68.98, total versions: 805691, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.00 
    Pointer pages: 92, data page slots: 149984 
    Data pages: 149976, average fill: 67% 
    Primary pages: 149976, secondary pages: 0, swept pages: 42092 
    Empty pages: 756, full pages: 93328 
    Fill distribution: 
     0 - 19% = 2444 
    20 - 39% = 11429 
    40 - 59% = 27949 
    60 - 79% = 90745 
    80 - 99% = 17409 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13549, nodes: 9383260 
    Average node length: 6.72, total dup: 7782739, max dup: 29 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1988229, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1075 
        40 - 59% = 6645 
        60 - 79% = 5083 
        80 - 99% = 743 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.46, total records: 21121543 
    Average version length: 82.86, total versions: 19672, 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: 195, data page slots: 318176 
    Data pages: 318176, average fill: 81% 
    Primary pages: 318176, secondary pages: 0, swept pages: 11146 
    Empty pages: 13, full pages: 317988 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 4 
    40 - 59% = 22 
    60 - 79% = 26649 
    80 - 99% = 291486 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19594, nodes: 21121543 
    Average node length: 5.72, total dup: 20641279, max dup: 161 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277546, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8630 
        60 - 79% = 540 
        80 - 99% = 10416 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17149, nodes: 21121543 
    Average node length: 6.31, total dup: 18561106, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914478, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 5 
        40 - 59% = 784 
        60 - 79% = 275 
        80 - 99% = 16080 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21405, nodes: 21121543 
    Average node length: 6.35, total dup: 18481086, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3571420, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 0 
        40 - 59% = 8983 
        60 - 79% = 571 
        80 - 99% = 11846 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16087, nodes: 21121543 
    Average node length: 5.56, total dup: 21121443, max dup: 229294 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943049, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 13 
        40 - 59% = 2886 
        60 - 79% = 404 
        80 - 99% = 12783 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 76.42, total records: 9736656 
    Average version length: 82.61, total versions: 708429, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 109, data page slots: 177376 
    Data pages: 177344, average fill: 68% 
    Primary pages: 177344, secondary pages: 0, swept pages: 60768 
    Empty pages: 928, full pages: 102096 
    Fill distribution: 
     0 - 19% = 2913 
    20 - 39% = 13255 
    40 - 59% = 34578 
    60 - 79% = 51803 
    80 - 99% = 74795 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11411, nodes: 9736656 
    Average node length: 5.40, total dup: 9428431, max dup: 198 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2091295, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 104 
        40 - 59% = 7965 
        60 - 79% = 3265 
        80 - 99% = 72 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13592, nodes: 9736656 
    Average node length: 6.27, total dup: 8073923, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1425915, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 3748 
        40 - 59% = 4629 
        60 - 79% = 2633 
        80 - 99% = 2451 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12742, nodes: 9736656 
    Average node length: 6.01, total dup: 8455264, max dup: 44 
    Average key length: 2.84, compression ratio: 3.16 
    Average prefix length: 8.29, average data length: 0.71 
    Clustering factor: 2290312, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 132 
        40 - 59% = 8926 
        60 - 79% = 3591 
        80 - 99% = 91 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10175, nodes: 9736656 
    Average node length: 5.17, total dup: 9736556, max dup: 148232 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1475055, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 37 
        20 - 39% = 1271 
        40 - 59% = 5050 
        60 - 79% = 1598 
        80 - 99% = 2219 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.30, total records: 11221031 
    Average version length: 82.50, total versions: 543971, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 120, data page slots: 194864 
    Data pages: 193376, average fill: 71% 
    Primary pages: 193376, secondary pages: 0, swept pages: 70391 
    Empty pages: 3731, full pages: 137446 
    Fill distribution: 
     0 - 19% = 6641 
    20 - 39% = 9645 
    40 - 59% = 20737 
    60 - 79% = 41439 
    80 - 99% = 114914 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13121, nodes: 11221031 
    Average node length: 5.32, total dup: 11111531, max dup: 614 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2326324, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 144 
        40 - 59% = 9351 
        60 - 79% = 3493 
        80 - 99% = 133 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10397, nodes: 11221031 
    Average node length: 5.51, total dup: 10731391, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 691127, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 877 
        40 - 59% = 2542 
        60 - 79% = 1775 
        80 - 99% = 5056 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15005, nodes: 11221031 
    Average node length: 6.04, total dup: 9792545, max dup: 80 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2342899, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 165 
        40 - 59% = 10871 
        60 - 79% = 3785 
        80 - 99% = 182 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10600, nodes: 11221031 
    Average node length: 5.24, total dup: 11220931, max dup: 177449 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 680519, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 95 
        20 - 39% = 843 
        40 - 59% = 4517 
        60 - 79% = 1486 
        80 - 99% = 3659 
 
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: 76.58, total records: 9877103 
    Average version length: 82.92, total versions: 735073, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.65 
    Pointer pages: 112, data page slots: 181720 
    Data pages: 181672, average fill: 68% 
    Primary pages: 181672, secondary pages: 0, swept pages: 63105 
    Empty pages: 966, full pages: 101123 
    Fill distribution: 
     0 - 19% = 3030 
    20 - 39% = 13716 
    40 - 59% = 37128 
    60 - 79% = 53925 
    80 - 99% = 73873 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11944, nodes: 9877103 
    Average node length: 5.22, total dup: 9848079, max dup: 1581 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1917736, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1520 
        40 - 59% = 7779 
        60 - 79% = 2012 
        80 - 99% = 609 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13811, nodes: 9877103 
    Average node length: 6.29, total dup: 8189105, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1392273, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 177 
        20 - 39% = 3775 
        40 - 59% = 4651 
        60 - 79% = 2651 
        80 - 99% = 2557 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12573, nodes: 9877103 
    Average node length: 5.47, total dup: 9437748, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2052939, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1447 
        40 - 59% = 8750 
        60 - 79% = 1776 
        80 - 99% = 572 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10412, nodes: 9877103 
    Average node length: 5.19, total dup: 9877003, max dup: 150196 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1493975, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 48 
        20 - 39% = 1300 
        40 - 59% = 5255 
        60 - 79% = 1611 
        80 - 99% = 2198 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.76, total records: 576290 
    Average version length: 68.87, total versions: 11829, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 75% 
    Primary pages: 8064, secondary pages: 0, swept pages: 3135 
    Empty pages: 5, full pages: 6672 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 57 
    40 - 59% = 314 
    60 - 79% = 7504 
    80 - 99% = 182 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 42758, depth: 3, leaf buckets: 741, nodes: 576290 
    Average node length: 5.95, total dup: 490642, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100014, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 35 
        40 - 59% = 524 
        60 - 79% = 96 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 36452, depth: 3, leaf buckets: 760, nodes: 576290 
    Average node length: 6.15, total dup: 472657, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100077, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 31 
        40 - 59% = 527 
        60 - 79% = 105 
        80 - 99% = 97 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 580, nodes: 576290 
    Average node length: 4.86, total dup: 576190, max dup: 9927 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 88831, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 30 
        40 - 59% = 350 
        60 - 79% = 87 
        80 - 99% = 112 
 
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 Sun Mar 10 01:11:16 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7775697 157416 1 0.0000 0.0000
DOC_LIST 2254143 162129 4 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 228225 592 57000.0000 0.0000
INVNT_TURNOVER_LOG 85147 54312 1 0.0000 0.0000
MONEY_SALDO 49 17526 947 35700.0000 0.0000
MONEY_TURNOVER_LOG 1225 1151 1 0.0000 0.0000
PDISTR 842292 91721 4 0.0000 0.0000
PERF_SPLIT_0 184362 14404 1 0.0000 0.0000
PERF_SPLIT_1 178517 7237 1 0.0000 0.0000
PERF_SPLIT_2 160398 4815 1 0.0000 0.0000
PERF_SPLIT_3 154846 8122 1 0.0000 0.0000
PERF_SPLIT_4 150736 9966 1 0.0000 0.0000
PERF_SPLIT_5 201221 47232 1 0.0000 0.0000
PERF_SPLIT_6 157886 8135 1 0.0000 0.0000
PERF_SPLIT_7 176242 3646 1 0.0000 0.0000
PERF_SPLIT_8 168341 9734 1 0.0000 0.0000
PERF_SPLIT_9 186364 11121 1 0.0000 0.0000
PSTORNED 2112450 73055 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 163085 80249 1 0.0000 0.0000
XQD_1000_3300 7536388 662933 1 0.0000 0.0000
XQD_1200_2000 12492615 491483 1 0.0000 0.0000
XQD_2000_3300 2007646 1069389 1 0.0000 0.0000
XQD_2100_3300 1232954 636181 1 0.0000 0.0000
XQD_3300_3400 9383260 805691 1 0.0000 0.0000
XQS_1000_1200 21121543 19672 1 0.0000 0.0000
XQS_1000_3300 9736656 708429 1 0.0000 0.0000
XQS_1200_2000 11221031 543971 1 0.0000 0.0000
XQS_2100_3300 9877103 735073 1 0.0000 0.0000
XQS_3300_3400 576290 11829 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 ---
:53: 
:54: mscs-test-161.budzdorov.ru    Sun Mar 10 01:09:41 2024
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
:57: 
:58: mscs-test-161.budzdorov.ru    Sun Mar 10 01:09:44 2024
:59:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:60: 
:61: 
:62: mscs-test-161.budzdorov.ru    Sun Mar 10 01:09:44 2024
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
:65: 
:66: mscs-test-161.budzdorov.ru    Sun Mar 10 01:09:44 2024
:67:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:68: 
--- end of diff output ---

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

10.03.24 01:11:28. 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-10 01:11:30 No severe PSQL-related problems occured
10.03.24 01:11:32. End of report.