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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15808332 kB
MemAvailable 30257696 kB
Buffers 0 kB
Cached 15935732 kB
SwapCached 2176 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-08 16:09:44
DTS_END                         2024-03-08 16:09:44.6260
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/58976
TRN_ID                          173358
ATT_ID                          579
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: 9359.46 21643 935946
customer order: creation 172.36 375 17236
customer order: refuse 14.88 356 1488
order to supplier: creation 45.73 1348 4573
order to supplier: removal 3.68 101574 368
invoice (draft): creation 46.95 3438 4695
invoice (draft): removal 52.66 713 5266
invoice accept: apply 42.01 19883 4201
invoice accept: cancel 47.35 846 4735
customer reserve: creation 4031.32 190 403132
customer reserve: removal 4608.62 65 460862
realization accept: apply 84.43 215 8443
realization accept: cancel 80.04 131 8004
payment from customer: creation 59.09 135 5909
payment from customer: removal 5.62 77 562
payment to supplier: creation 49.18 172 4918
payment to supplier: removal 3.16 64 316
service: total inventory turnovers 4.70 1138 470
service: total monetary turnovers 6.76 31 676
service: aggregate perf. data 0.89 18714 89
service: refresh index statistics 0.03 283386 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-03-2024 16:10:48 to 08-03-2024 16:10:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4030
TEST_TIME 2 4588
TEST_TIME 3 3699
TEST_TIME 4 3536
TEST_TIME 5 3917
TEST_TIME 6 4748
TEST_TIME 7 4983
TEST_TIME 8 4771
TEST_TIME 9 5123
TEST_TIME 10 4993
TEST_TIME 11 5158
TEST_TIME 12 5074
TEST_TIME 13 5165
TEST_TIME 14 5161
TEST_TIME 15 5448
TEST_TIME 16 5625
TEST_TIME 17 5633
TEST_TIME 18 5883
TEST_TIME 19 6267
TEST_TIME 20 6340
TEST_TIME 21 7122
TEST_TIME 22 7500
TEST_TIME 23 7589
TEST_TIME 24 7937
TEST_TIME 25 8039
TEST_TIME 26 8230
TEST_TIME 27 8654
TEST_TIME 28 9382
TEST_TIME 29 9407
TEST_TIME 30 9422
TEST_TIME 31 9361
TEST_TIME 32 9288
TEST_TIME 33 9279
TEST_TIME 34 9062
TEST_TIME 35 9060
TEST_TIME 36 9199
TEST_TIME 37 9049
TEST_TIME 38 8979
TEST_TIME 39 8926
TEST_TIME 40 9066
TEST_TIME 41 9237
TEST_TIME 42 9107
TEST_TIME 43 9029
TEST_TIME 44 8998
TEST_TIME 45 9001
TEST_TIME 46 9108
TEST_TIME 47 9167
TEST_TIME 48 9098
TEST_TIME 49 9160
TEST_TIME 50 9235
TEST_TIME 51 9316
TEST_TIME 52 9374
TEST_TIME 53 9273
TEST_TIME 54 9274
TEST_TIME 55 9535
TEST_TIME 56 9586
TEST_TIME 57 9570
TEST_TIME 58 9495
TEST_TIME 59 9386
TEST_TIME 60 9396
TEST_TIME 61 9326
TEST_TIME 62 9304
TEST_TIME 63 9304
TEST_TIME 64 9311
TEST_TIME 65 9274
TEST_TIME 66 9260
TEST_TIME 67 9222
TEST_TIME 68 9210
TEST_TIME 69 9143
TEST_TIME 70 9066
TEST_TIME 71 9108
TEST_TIME 72 9138
TEST_TIME 73 9142
TEST_TIME 74 9156
TEST_TIME 75 9177
TEST_TIME 76 9317
TEST_TIME 77 9324
TEST_TIME 78 9318
TEST_TIME 79 9375
TEST_TIME 80 9420
TEST_TIME 81 9498
TEST_TIME 82 9513
TEST_TIME 83 9476
TEST_TIME 84 9506
TEST_TIME 85 9433
TEST_TIME 86 9373
TEST_TIME 87 9365
TEST_TIME 88 9324
TEST_TIME 89 9345
TEST_TIME 90 9292
TEST_TIME 91 9305
TEST_TIME 92 9255
TEST_TIME 93 9268
TEST_TIME 94 9244
TEST_TIME 95 9247
TEST_TIME 96 9301
TEST_TIME 97 9333
TEST_TIME 98 9350
TEST_TIME 99 9364
TEST_TIME 100 9366

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-03-2024 16:10:51 to 08-03-2024 16:10:54.

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 1306181 1306181 0 0.00 0 13107 7 0 0
doc_list_biud 1306180 1306180 0 0.00 0 77029 28 0 0
sp_add_invoice_to_stock 4264 4201 63 1.47 31 158573 19883 0 63
sp_cancel_adding_invoice 4735 4735 0 0.00 4 64205 847 0 0
sp_cancel_client_order 1488 1488 0 0.00 5 12794 357 0 0
sp_cancel_customer_reserve 460862 460862 0 0.00 0 28632 65 0 0
sp_cancel_pay_from_customer 562 562 0 0.00 3 5046 77 0 0
sp_cancel_pay_to_supplier 316 316 0 0.00 3 2588 65 0 0
sp_cancel_supplier_invoice 5272 5266 6 0.11 1 77045 713 0 6
sp_cancel_supplier_order 368 368 0 0.00 11 1030639 101575 0 0
sp_cancel_write_off 8004 8004 0 0.00 1 13143 132 0 0
sp_client_order 17236 17236 0 0.00 3 20951 376 0 0
sp_customer_reserve 403132 403132 0 0.00 0 34458 190 0 0
sp_fill_shopping_cart 26485 26485 0 0.00 1 11088 35 0 0
sp_fill_shopping_cart_clo_res 403124 403124 0 0.00 0 19496 17 0 0
sp_get_clo_for_invoice 4190 4190 0 0.00 0 31830 279 0 0
sp_kill_cost_storno 13617 13617 0 0.00 0 9270 61 0 0
sp_kill_qstorno_ret_qs2qd 935362 935362 0 0.00 0 77020 35 0 0
sp_kill_qty_storno 493354 493354 0 0.00 0 77026 75 0 0
sp_lock_selected_doc 17579 17579 0 0.00 0 9219 7 0 0
sp_make_cost_storno 23458 23458 0 0.00 0 10142 63 0 0
sp_multiply_rows_for_pdistr 23458 23458 0 0.00 0 7160 33 0 0
sp_multiply_rows_for_qdistr 17236 17236 0 0.00 0 11230 175 0 0
sp_pay_from_customer 5909 5909 0 0.00 4 10603 135 0 0
sp_pay_to_supplier 4918 4918 0 0.00 4 21240 173 0 0
sp_payment_common 10827 10827 0 0.00 2 18497 40 0 0
sp_qd_handle_on_cancel_clo 1488 1488 0 0.00 0 12784 332 0 0
sp_qd_handle_on_invoice_upd_sts 8923 8923 0 0.00 0 27612 332 0 0
sp_qd_handle_on_reserve_upd_sts 8443 8443 0 0.00 0 21965 79 0 0
sp_reserve_write_off 8443 8443 0 0.00 6 21980 215 0 0
sp_supplier_invoice 4695 4695 0 0.00 6 90661 3438 0 0
sp_supplier_order 4573 4573 0 0.00 5 42432 1349 0 0
srv_aggregate_perf_data 89 89 0 0.00 1713 185324 18715 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1413 124668 38004 0 0
srv_find_qd_qs_mism 893926 893926 0 0.00 0 13106 6 0 0
srv_make_invnt_saldo 470 470 0 0.00 21 49698 1139 0 0
srv_make_money_saldo 676 676 0 0.00 1 1068 31 0 0
srv_recalc_idx_stat 3 3 0 0.00 239757 346719 283386 0 0
t$perf-abend:sp_add_invoice_to_stock 63 63 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4201 4201 0 0.00 0 36785 258 0 0
t$perf-norm:sp_cancel_adding_invoice 365 365 0 0.00 0 3896 82 0 0
t$perf-norm:sp_cancel_client_order 1488 1488 0 0.00 0 1387 11 0 0
t$perf-norm:sp_cancel_customer_reserve 623 623 0 0.00 0 34196 69 0 0
t$perf-norm:sp_cancel_pay_from_customer 562 562 0 0.00 0 3048 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 316 316 0 0.00 0 5984 30 0 0
t$perf-norm:sp_cancel_supplier_invoice 355 355 0 0.00 0 1249 26 0 0
t$perf-norm:sp_cancel_supplier_order 368 368 0 0.00 0 42132 1707 0 0
t$perf-norm:sp_cancel_write_off 871 871 0 0.00 0 2724 17 0 0
t$perf-norm:sp_client_order 17236 17236 0 0.00 0 8883 16 0 0
t$perf-norm:sp_customer_reserve 857 857 0 0.00 0 816 6 0 0
t$perf-norm:sp_pay_from_customer 5909 5909 0 0.00 0 3816 10 0 0
t$perf-norm:sp_pay_to_supplier 4918 4918 0 0.00 0 35627 21 0 0
t$perf-norm:sp_reserve_write_off 8443 8443 0 0.00 0 5954 12 0 0
t$perf-norm:sp_supplier_invoice 4695 4695 0 0.00 0 22207 22 0 0
t$perf-norm:sp_supplier_order 4573 4573 0 0.00 0 2688 15 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 155 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 1024 24 0 0
t$perf-norm:srv_make_invnt_saldo 470 470 0 0.00 0 4235 35 0 0
t$perf-norm:srv_make_money_saldo 676 676 0 0.00 0 1656 16 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 68 24 0 0
v_add_invoice_to_stock 8502 8376 126 1.48 0 7668 17 0 126
v_all_customers 31768 31768 0 0.00 0 31 1 0 0
v_all_suppliers 26482 26482 0 0.00 0 23 1 0 0
v_all_wares 34469 34469 0 0.00 0 108 1 0 0
v_cancel_adding_invoice 730 730 0 0.00 0 436 5 0 0
v_cancel_client_order 2976 2976 0 0.00 0 1716 5 0 0
v_cancel_customer_prepayment 1124 1124 0 0.00 0 705 5 0 0
v_cancel_customer_reserve 1246 1246 0 0.00 0 3068 11 0 0
v_cancel_payment_to_supplier 632 632 0 0.00 0 2565 8 0 0
v_cancel_supplier_invoice 722 710 12 1.66 0 1849 16 0 12
v_cancel_supplier_order 736 736 0 0.00 0 3826 8 0 0
v_cancel_write_off 1742 1742 0 0.00 0 7728 24 0 0
v_max_id_clo_ord 4565 4565 0 0.00 0 1579 2 0 0
v_max_id_clo_res 857 857 0 0.00 0 3100 16 0 0
v_max_id_ord_sup 4684 4684 0 0.00 0 8310 7 0 0
v_max_non_paid_invoice 926 926 0 0.00 0 2612 12 0 0
v_max_non_paid_realizn 2985 2985 0 0.00 0 3171 10 0 0
v_min_id_clo_ord 4565 4565 0 0.00 0 5451 10 0 0
v_min_id_clo_res 857 857 0 0.00 0 2396 8 0 0
v_min_id_ord_sup 4684 4684 0 0.00 0 7260 6 0 0
v_min_non_paid_invoice 4918 4918 0 0.00 0 18490 29 0 0
v_min_non_paid_realizn 5909 5909 0 0.00 0 7142 31 0 0
v_our_firm 8548 8548 0 0.00 0 25 1 0 0
v_reserve_write_off 16886 16886 0 0.00 0 7695 6 0 0
x_lock_depdocs_on_canc_invoice 9646 9646 0 0.00 0 28227 142 0 0
x_lock_depdocs_on_canc_sup_ord 368 368 0 0.00 0 24926 441 0 0
x_make_qstorno_1000_1200 4573 4573 0 0.00 1 42410 1266 0 0
x_make_qstorno_1200_2000 4695 4695 0 0.00 3 90634 3315 0 0
x_make_qstorno_2100_3300 403132 403132 0 0.00 0 34457 169 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 08-03-2024 16:10:55 to 08-03-2024 16:11:00.

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
14:09:48 9 8192000000 8808989136 8824000512 12926048 0.157 5 2 3 0 13071168 70160 74960
14:10:50 27014 8192000000 9904570704 10214289408 983235168 10.716 100 86 173 0 1011847808 5592944 23019696
14:12:22 28973 8192000000 9952378736 10273181696 1027264240 11.142 100 87 172 0 1056591744 7530896 21796608
14:13:57 15781 8192000000 9982649056 10312224768 1067190736 11.525 100 92 184 1 1099251536 8905680 23155120
14:15:17 9634 8192000000 10020995424 10366734336 1106808768 11.902 100 71 142 0 1133556912 9645968 17102176
14:16:36 6874 8192000000 10063545872 10421116928 1154299424 12.350 100 74 148 0 1182198032 10995696 16902912
14:17:47 3597 8192000000 10105883328 10475839488 1202710832 12.801 100 80 160 0 1232094784 11683200 17700752
14:18:53 1922 8192000000 10157959280 10530951168 1242890656 13.173 100 92 181 0 1277264224 13636208 20737360
14:19:56 1577 8192000000 10184717024 10564648960 1271937632 13.439 100 82 161 1 1301972112 12600480 17434000
14:20:59 1321 8192000000 10208462608 10590769152 1292361088 13.626 100 83 165 0 1323572016 13062816 18148112
14:22:03 4861 8192000000 10209896352 10598182912 1299891024 13.694 100 69 138 0 1325843248 10208000 15744224
14:23:09 5004 8192000000 10206239632 10606071808 1304822272 13.739 100 52 105 0 1326859632 10662096 11375264
14:24:16 7002 8192000000 10190911280 10608349184 1311337760 13.798 100 16 32 0 1321001264 6220144 3443360
14:25:25 17975 8192000000 10197470944 10617565184 1318253072 13.861 100 14 28 1 1327093824 5804032 3036720
14:26:45 54893 8192000000 10220544576 10637905920 1326080208 13.932 100 30 61 1 1338257152 4608672 7568272
14:28:42 4075 8192000000 10220178608 10643845120 1331486480 13.981 100 19 38 0 1340678176 5151296 4040400
14:29:51 18079 8192000000 10227954672 10640859136 1327361872 13.943 100 35 69 0 1341642592 6902752 7377968
14:31:21 23777 8192000000 10226605696 10637709312 1319158800 13.869 99 45 90 0 1341601696 11987280 10455616
14:32:48 86080 8192000000 10237011600 10645573632 1302157024 13.715 97 51 101 0 1327193440 13386656 11649760
14:35:18 14301 8192000000 10221387280 10629681152 1301659920 13.710 98 30 60 0 1322499072 13707968 7131184
14:36:37 14164 8192000000 10237644320 10652180480 1328060080 13.950 100 44 87 0 1356683312 18144144 10479088
14:38:01 31453 8192000000 10239772272 10647474176 1310066256 13.787 99 44 88 0 1335828576 15548144 10214176
14:39:37 16421 8192000000 10257337184 10653536256 1318728592 13.865 99 62 121 0 1350307856 17399376 14179888
14:40:59 6518 8192000000 10268224080 10673463296 1345846112 14.110 100 53 106 1 1377054832 18112992 13095728
14:42:09 7874 8192000000 10237089104 10640977920 1317442528 13.854 98 41 80 1 1351305472 24102176 9760768
14:43:30 6419 8192000000 10262636464 10658639872 1333648576 14.000 100 61 122 0 1373358496 24327936 15381984
14:44:59 2058 8192000000 10274562816 10665295872 1333131472 13.995 100 79 157 1 1380901152 28392192 19377488
14:46:06 2293 8192000000 10300962912 10698051584 1350977200 14.156 100 77 153 1 1404855232 34747920 19130112
14:47:15 1407 8192000000 10309295088 10703400960 1353804576 14.182 100 85 168 0 1415755616 41643152 20307888
14:48:26 1424 8192000000 10337313552 10736128000 1377624992 14.395 100 89 177 0 1444632016 45044592 21962432
14:49:35 2348 8192000000 10362670576 10766524416 1396766768 14.566 100 77 151 0 1466134880 50562336 18805776
14:50:41 9544 8192000000 10337329824 10760884224 1395594224 14.556 100 47 93 1 1451662928 43194992 12873712
14:52:06 13102 8192000000 10331420736 10758553600 1395552768 14.555 100 32 64 0 1444659408 40321120 8785520
14:53:26 12471 8192000000 10335304000 10767015936 1391805456 14.522 100 38 76 0 1442407168 40317104 10284608
14:55:08 25026 8192000000 10313922048 10749587456 1377125088 14.391 100 26 52 0 1420100384 36449344 6525952
14:56:43 25035 8192000000 10302869136 10755735552 1374800224 14.370 100 10 20 0 1417613888 39899824 2913840
14:58:24 26603 8192000000 10276521696 10718986240 1360009312 14.237 99 16 32 0 1374810576 11493296 3307968
14:59:53 37297 8192000000 10293929008 10734723072 1379735520 14.414 100 19 37 1 1391384672 8158448 3490704
15:01:33 58933 8192000000 10320734160 10752458752 1392199472 14.525 100 36 70 0 1409663408 9807392 7656544
15:03:40 73803 8192000000 10311860016 10753609728 1388906576 14.496 100 31 62 0 1408552368 11926960 7718832
15:05:57 54956 8192000000 10318495904 10781200384 1397770192 14.575 100 16 32 0 1418801408 17424384 3606832
15:07:57 25902 8192000000 10334052400 10776002560 1411298144 14.695 100 50 100 1 1440678112 17253056 12126912
15:09:32 46849 8192000000 10313831424 10772320256 1408271008 14.669 100 15 30 0 1425449680 13737968 3440704
15:11:23 30919 8192000000 10313747648 10764779520 1400287952 14.598 99 28 54 0 1414294096 7869104 6137040
15:13:32 59446 8192000000 10307255968 10761142272 1393413376 14.536 99 23 46 0 1409754816 10395152 5946288
15:15:49 90669 8192000000 10307694176 10766446592 1376015600 14.381 98 7 14 0 1387399136 9873824 1509712
15:18:21 41137 8192000000 10316964928 10776158208 1408033536 14.666 100 15 30 0 1424019424 12651520 3334368
15:20:05 49729 8192000000 10271820368 10723889152 1284321920 13.552 92 16 33 0 1299966464 11993024 3651520
15:22:06 91336 8192000000 10293216880 10749227008 1349485984 14.143 98 20 40 0 1373515280 19328240 4701056
15:24:59 26738 8192000000 10279177328 10721419264 1343920160 14.093 98 22 44 0 1358668672 9774368 4974144
15:26:27 61481 8192000000 10266585904 10704048128 1274412848 13.462 93 29 58 0 1294995920 14231408 6351664
15:28:29 59237 8192000000 10262992736 10703044608 1318669664 13.865 97 24 48 0 1331252688 7148928 5434096
15:30:29 51204 8192000000 10261968688 10704646144 1356308208 14.204 100 18 34 0 1367401168 7261920 3831040
15:32:29 9245 8192000000 10273951792 10701664256 1343626512 14.090 99 71 140 1 1373450336 13299840 16523984
15:33:39 52690 8192000000 10238511040 10685460480 1314456080 13.826 98 15 28 1 1327663792 9418208 3789504
15:35:32 35360 8192000000 10233292512 10681942016 1326555136 13.936 99 19 36 0 1343200272 12738048 3907088
15:37:09 33330 8192000000 10218538960 10663542784 1299520800 13.691 97 12 24 0 1307550176 5776448 2252928
15:38:43 55248 8192000000 10211779776 10658086912 1289875664 13.603 97 15 30 0 1302969376 10279056 2814656
15:40:55 31498 8192000000 10233805520 10683969536 1332647136 13.991 100 31 63 1 1345956624 6708144 6601344
15:42:26 38233 8192000000 10270084576 10713051136 1342059040 14.076 98 18 36 0 1354997520 8843856 4094624
15:44:15 13328 8192000000 10280318224 10716413952 1357218096 14.212 99 50 98 1 1380401536 12298816 10884624
15:45:35 60270 8192000000 10281858032 10719645696 1352747776 14.172 99 22 44 0 1371194496 13017456 5429264
15:47:41 81742 8192000000 10296205120 10756214784 1375925536 14.380 99 17 34 0 1395338336 15423968 3988832
15:50:21 124667 8192000000 10295382384 10747449344 1381495168 14.430 99 6 12 0 1395943408 13044704 1403536
15:53:32 65139 8192000000 10307905488 10762539008 1398962608 14.586 100 30 60 0 1420369104 14285680 7120816
15:56:39 36875 8192000000 10313652336 10766782464 1402356720 14.616 100 36 72 0 1421380496 10083440 8940336
15:58:22 64477 8192000000 10289928528 10753359872 1399954784 14.595 100 14 28 1 1412799488 9670432 3174272
16:00:47 32029 8192000000 10284508560 10740400128 1384142896 14.454 99 15 30 1 1395204816 6889152 4172768
16:02:22 53106 8192000000 10280779136 10749296640 1362270656 14.258 97 9 19 0 1375975408 11583040 2121712
16:04:15 73294 8192000000 10292521136 10760364032 1377109728 14.391 98 20 40 0 1396616160 14452496 5053936
16:06:32 29241 8192000000 10273259392 10722619392 1307066800 13.759 94 24 47 1 1318858096 6543856 5247440
16:08:12 32354 8192000000 10248359264 10698784768 1316703344 13.847 97 21 42 0 1329306656 8086944 4516368

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 08-03-2024 16:11:02 to 08-03-2024 16:11:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 63 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-03-2024 16:11:16 to 08-03-2024 16:11:18.

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          171312
MON$OLDEST_ACTIVE               174055
MON$OLDEST_SNAPSHOT             174055
MON$NEXT_TRANSACTION            174055
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                       1903712
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.33734 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.12.33734 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.12.33734 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.12.33734 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Fri Mar  8 16:11:19 2024 
 
Database header page information: 
    Flags            0 
    Generation        90587 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    171312 
    Oldest active        174055 
    Oldest snapshot        174055 
    Next transaction    174056 
    Sequence number        0 
    Next attachment ID    714 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.18, total records: 7745599 
    Average version length: 48.16, total versions: 115580, 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: 86592 
    Data pages: 86592, average fill: 71% 
    Primary pages: 86592, secondary pages: 0, swept pages: 15750 
    Empty pages: 4, full pages: 70931 
    Fill distribution: 
     0 - 19% = 27 
    20 - 39% = 292 
    40 - 59% = 3174 
    60 - 79% = 83061 
    80 - 99% = 38 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23398, nodes: 7745599 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1712618, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 376 
        20 - 39% = 1854 
        40 - 59% = 4252 
        60 - 79% = 2478 
        80 - 99% = 14438 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13564, nodes: 7745599 
    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: 1535443, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1646 
        40 - 59% = 2050 
        60 - 79% = 1138 
        80 - 99% = 8730 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8373, nodes: 7745599 
    Average node length: 6.61, total dup: 5801089, max dup: 49 
    Average key length: 3.62, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1528355, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 1007 
        40 - 59% = 1382 
        60 - 79% = 956 
        80 - 99% = 4888 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 55.98, total records: 2235678 
    Average version length: 34.55, total versions: 112322, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28216 
    Data pages: 28216, average fill: 74% 
    Primary pages: 28212, secondary pages: 4, swept pages: 8822 
    Empty pages: 5, full pages: 23213 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 186 
    40 - 59% = 2250 
    60 - 79% = 24532 
    80 - 99% = 1224 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4566, nodes: 2235678 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 696833, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 926 
        40 - 59% = 889 
        60 - 79% = 742 
        80 - 99% = 2009 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2506, nodes: 2238439 
    Average node length: 4.97, total dup: 2237540, max dup: 18658 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1239513, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 262 
        40 - 59% = 1522 
        60 - 79% = 527 
        80 - 99% = 193 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2033, nodes: 2235678 
    Average node length: 4.97, total dup: 2235628, max dup: 130237 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1051437, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 112 
        40 - 59% = 1041 
        60 - 79% = 105 
        80 - 99% = 769 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4357, nodes: 2235678 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 696833, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 583 
        40 - 59% = 639 
        60 - 79% = 831 
        80 - 99% = 2187 
 
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.50, total records: 400 
    Average version length: 22.93, total versions: 230967, max versions: 608 
    Average fragment length: 2.00, total fragments: 45, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1264 
    Data pages: 1264, average fill: 91% 
    Primary pages: 8, secondary pages: 1256, swept pages: 0 
    Empty pages: 1, full pages: 1262 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 1261 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 13.17, total records: 85933 
    Average version length: 68.28, total versions: 69375, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.68 
    Pointer pages: 7, data page slots: 2136 
    Data pages: 1688, average fill: 63% 
    Primary pages: 1687, secondary pages: 1, swept pages: 0 
    Empty pages: 250, full pages: 1042 
    Fill distribution: 
     0 - 19% = 362 
    20 - 39% = 125 
    40 - 59% = 88 
    60 - 79% = 233 
    80 - 99% = 880 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705227, depth: 3, leaf buckets: 251, nodes: 85933 
    Average node length: 13.10, total dup: 5478, max dup: 2 
    Average key length: 10.77, compression ratio: 2.51 
    Average prefix length: 19.17, average data length: 7.83 
    Clustering factor: 64868, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 116 
        60 - 79% = 91 
        80 - 99% = 7 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.27, total records: 49 
    Average version length: 9.00, total versions: 18110, max versions: 961 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 81% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 6 
    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.88, total records: 1307 
    Average version length: 43.08, total versions: 1224, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 20.12 
    Pointer pages: 1, data page slots: 32 
    Data pages: 21, average fill: 59% 
    Primary pages: 20, secondary pages: 1, swept pages: 0 
    Empty pages: 5, full pages: 11 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 87673, depth: 2, leaf buckets: 2, nodes: 1307 
    Average node length: 4.42, total dup: 1209, max dup: 153 
    Average key length: 2.78, compression ratio: 6.83 
    Average prefix length: 18.29, average data length: 0.71 
    Clustering factor: 662, ratio: 0.51 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.01, 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.90, total records: 820793 
    Average version length: 25.28, total versions: 78137, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 5, data page slots: 8136 
    Data pages: 8136, average fill: 71% 
    Primary pages: 8116, secondary pages: 20, swept pages: 1252 
    Empty pages: 24, full pages: 7318 
    Fill distribution: 
     0 - 19% = 60 
    20 - 39% = 96 
    40 - 59% = 173 
    60 - 79% = 7502 
    80 - 99% = 305 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 911, nodes: 820793 
    Average node length: 4.87, total dup: 820744, max dup: 149865 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90928, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 138 
        40 - 59% = 525 
        60 - 79% = 188 
        80 - 99% = 58 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 977, nodes: 820793 
    Average node length: 5.88, total dup: 731020, max dup: 42 
    Average key length: 3.02, compression ratio: 7.30 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 163877, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 93 
        40 - 59% = 492 
        60 - 79% = 85 
        80 - 99% = 303 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1001, nodes: 820793 
    Average node length: 5.88, total dup: 731020, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 165884, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 198 
        40 - 59% = 429 
        60 - 79% = 51 
        80 - 99% = 323 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1152, nodes: 820793 
    Average node length: 5.96, total dup: 731020, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 158520, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 228 
        40 - 59% = 620 
        60 - 79% = 216 
        80 - 99% = 87 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.76, total records: 5426 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.33, total fragments: 83, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 72, secondary pages: 24, swept pages: 52 
    Empty pages: 13, full pages: 62 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 7, nodes: 5426 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.00 
    Average prefix length: 34.34, average data length: 1.55 
    Clustering factor: 5161, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 1 
        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: 5426 
    Average node length: 11.12, 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: 152, 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.09, total records: 79638 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 767 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 767 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 31514, depth: 2, leaf buckets: 101, nodes: 79638 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3351, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 100 
 
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.32, total records: 190468 
    Average version length: 154.40, total versions: 14731, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.17 
    Pointer pages: 8, data page slots: 5632 
    Data pages: 4560, average fill: 87% 
    Primary pages: 4560, secondary pages: 0, swept pages: 3 
    Empty pages: 34, full pages: 4511 
    Fill distribution: 
     0 - 19% = 34 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 7 
    80 - 99% = 4512 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 146.55, total records: 181913 
    Average version length: 152.74, total versions: 5555, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.57 
    Pointer pages: 6, data page slots: 5912 
    Data pages: 4376, average fill: 86% 
    Primary pages: 4376, secondary pages: 0, swept pages: 2 
    Empty pages: 53, full pages: 4302 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 10 
    80 - 99% = 4303 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 140.79, total records: 165850 
    Average version length: 153.12, total versions: 11148, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.05 
    Pointer pages: 6, data page slots: 4352 
    Data pages: 3960, average fill: 87% 
    Primary pages: 3960, secondary pages: 0, swept pages: 5 
    Empty pages: 22, full pages: 3920 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 3921 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 144.23, total records: 165464 
    Average version length: 152.79, total versions: 7050, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.76 
    Pointer pages: 6, data page slots: 5088 
    Data pages: 3952, average fill: 86% 
    Primary pages: 3952, secondary pages: 0, swept pages: 2 
    Empty pages: 33, full pages: 3908 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 1 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3909 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 145.85, total records: 159841 
    Average version length: 152.68, total versions: 5508, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.63 
    Pointer pages: 7, data page slots: 5112 
    Data pages: 3872, average fill: 85% 
    Primary pages: 3872, secondary pages: 0, swept pages: 5 
    Empty pages: 73, full pages: 3782 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 7 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3781 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 134.30, total records: 178410 
    Average version length: 154.83, total versions: 19740, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.63 
    Pointer pages: 7, data page slots: 5368 
    Data pages: 4360, average fill: 85% 
    Primary pages: 4360, secondary pages: 0, swept pages: 2 
    Empty pages: 104, full pages: 4224 
    Fill distribution: 
     0 - 19% = 106 
    20 - 39% = 15 
    40 - 59% = 6 
    60 - 79% = 12 
    80 - 99% = 4221 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 142.00, total records: 158601 
    Average version length: 154.13, total versions: 9143, 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: 4008 
    Data pages: 3784, average fill: 87% 
    Primary pages: 3784, secondary pages: 0, swept pages: 2 
    Empty pages: 21, full pages: 3749 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 3 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 3750 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 147.45, total records: 192709 
    Average version length: 151.58, total versions: 5007, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.50 
    Pointer pages: 7, data page slots: 5408 
    Data pages: 4648, average fill: 86% 
    Primary pages: 4648, secondary pages: 0, swept pages: 1 
    Empty pages: 65, full pages: 4568 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 4 
    80 - 99% = 4568 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 138.91, total records: 168894 
    Average version length: 154.24, total versions: 13239, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.21 
    Pointer pages: 7, data page slots: 4880 
    Data pages: 4072, average fill: 86% 
    Primary pages: 4072, secondary pages: 0, swept pages: 2 
    Empty pages: 57, full pages: 3988 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 5 
    40 - 59% = 10 
    60 - 79% = 8 
    80 - 99% = 3988 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 138.51, total records: 178731 
    Average version length: 154.35, total versions: 14718, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.24 
    Pointer pages: 7, data page slots: 4776 
    Data pages: 4288, average fill: 87% 
    Primary pages: 4288, secondary pages: 0, swept pages: 2 
    Empty pages: 38, full pages: 4230 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 7 
    40 - 59% = 5 
    60 - 79% = 5 
    80 - 99% = 4230 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.60, total records: 2098774 
    Average version length: 52.94, total versions: 45688, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25408 
    Data pages: 25408, average fill: 71% 
    Primary pages: 25408, secondary pages: 0, swept pages: 10021 
    Empty pages: 280, full pages: 21013 
    Fill distribution: 
     0 - 19% = 542 
    20 - 39% = 419 
    40 - 59% = 1041 
    60 - 79% = 23005 
    80 - 99% = 401 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2542, nodes: 2098774 
    Average node length: 5.44, total dup: 1958445, max dup: 1632 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181967, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 280 
        40 - 59% = 1612 
        60 - 79% = 299 
        80 - 99% = 345 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2758, nodes: 2098774 
    Average node length: 5.69, total dup: 1883902, max dup: 64 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 375600, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2440 
        60 - 79% = 289 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2161, nodes: 2098774 
    Average node length: 4.96, total dup: 2098674, max dup: 27880 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179627, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 183 
        40 - 59% = 1210 
        60 - 79% = 387 
        80 - 99% = 380 
 
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: 38.54, total records: 156561 
    Average version length: 69.19, total versions: 69396, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.27 
    Pointer pages: 3, data page slots: 3896 
    Data pages: 2936, average fill: 62% 
    Primary pages: 2936, secondary pages: 0, swept pages: 312 
    Empty pages: 458, full pages: 1967 
    Fill distribution: 
     0 - 19% = 606 
    20 - 39% = 106 
    40 - 59% = 115 
    60 - 79% = 771 
    80 - 99% = 1338 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 97385, depth: 3, leaf buckets: 215, nodes: 156561 
    Average node length: 6.43, total dup: 136393, max dup: 14 
    Average key length: 3.92, compression ratio: 10.72 
    Average prefix length: 40.21, average data length: 1.79 
    Clustering factor: 26427, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 15 
        40 - 59% = 102 
        60 - 79% = 74 
        80 - 99% = 23 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.64, total records: 7362189 
    Average version length: 68.77, total versions: 460698, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 65, data page slots: 104632 
    Data pages: 104632, average fill: 75% 
    Primary pages: 104632, secondary pages: 0, swept pages: 20844 
    Empty pages: 25, full pages: 90024 
    Fill distribution: 
     0 - 19% = 142 
    20 - 39% = 922 
    40 - 59% = 5169 
    60 - 79% = 89993 
    80 - 99% = 8406 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10814, nodes: 7362189 
    Average node length: 6.50, total dup: 6371760, max dup: 40 
    Average key length: 3.51, compression ratio: 11.95 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1639519, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1323 
        40 - 59% = 5820 
        60 - 79% = 3079 
        80 - 99% = 583 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8836, nodes: 7362189 
    Average node length: 5.39, total dup: 7074008, max dup: 197 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1426510, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1096 
        40 - 59% = 5105 
        60 - 79% = 1583 
        80 - 99% = 1042 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8919, nodes: 7362189 
    Average node length: 5.39, total dup: 7074008, max dup: 197 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1429058, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1143 
        40 - 59% = 5186 
        60 - 79% = 1542 
        80 - 99% = 1039 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 66.75, total records: 12368105 
    Average version length: 68.72, total versions: 394531, 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: 105, data page slots: 170624 
    Data pages: 170624, average fill: 77% 
    Primary pages: 170624, secondary pages: 0, swept pages: 68961 
    Empty pages: 3, full pages: 165240 
    Fill distribution: 
     0 - 19% = 46 
    20 - 39% = 406 
    40 - 59% = 1854 
    60 - 79% = 159548 
    80 - 99% = 8770 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18561, nodes: 12368105 
    Average node length: 6.59, total dup: 10782218, max dup: 67 
    Average key length: 3.42, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2415082, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 1930 
        40 - 59% = 10729 
        60 - 79% = 5141 
        80 - 99% = 742 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 37.73, total records: 1772100 
    Average version length: 69.15, total versions: 805371, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.34 
    Pointer pages: 26, data page slots: 42104 
    Data pages: 26384, average fill: 78% 
    Primary pages: 26383, secondary pages: 1, swept pages: 2661 
    Empty pages: 964, full pages: 23058 
    Fill distribution: 
     0 - 19% = 1556 
    20 - 39% = 626 
    40 - 59% = 643 
    60 - 79% = 9566 
    80 - 99% = 13993 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2110, nodes: 1772100 
    Average node length: 5.51, total dup: 1701083, max dup: 99 
    Average key length: 2.55, compression ratio: 16.50 
    Average prefix length: 41.49, average data length: 0.51 
    Clustering factor: 121464, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 197 
        40 - 59% = 1045 
        60 - 79% = 610 
        80 - 99% = 241 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 37.83, total records: 1162695 
    Average version length: 69.15, total versions: 525461, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.33 
    Pointer pages: 21, data page slots: 33024 
    Data pages: 26800, average fill: 50% 
    Primary pages: 26800, secondary pages: 0, swept pages: 5594 
    Empty pages: 5813, full pages: 13947 
    Fill distribution: 
     0 - 19% = 9146 
    20 - 39% = 1510 
    40 - 59% = 886 
    60 - 79% = 6329 
    80 - 99% = 8929 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1502, nodes: 1162695 
    Average node length: 5.77, total dup: 1087479, max dup: 99 
    Average key length: 2.83, compression ratio: 14.83 
    Average prefix length: 41.23, average data length: 0.77 
    Clustering factor: 157108, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 227 
        40 - 59% = 717 
        60 - 79% = 429 
        80 - 99% = 126 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 64.60, total records: 9128332 
    Average version length: 68.97, total versions: 568981, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.95 
    Pointer pages: 88, data page slots: 142720 
    Data pages: 142656, average fill: 69% 
    Primary pages: 142655, secondary pages: 1, swept pages: 47651 
    Empty pages: 484, full pages: 85070 
    Fill distribution: 
     0 - 19% = 1529 
    20 - 39% = 7532 
    40 - 59% = 23580 
    60 - 79% = 99356 
    80 - 99% = 10659 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13440, nodes: 9128332 
    Average node length: 6.67, total dup: 7572635, max dup: 25 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1938456, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1314 
        40 - 59% = 6994 
        60 - 79% = 4469 
        80 - 99% = 660 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.47, total records: 21149336 
    Average version length: 82.91, total versions: 17539, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.53 
    Pointer pages: 196, data page slots: 318640 
    Data pages: 318640, average fill: 81% 
    Primary pages: 318640, secondary pages: 0, swept pages: 11632 
    Empty pages: 18, full pages: 318369 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 12 
    40 - 59% = 37 
    60 - 79% = 27048 
    80 - 99% = 291514 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19615, nodes: 21149336 
    Average node length: 5.72, total dup: 20668392, max dup: 155 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279993, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 2 
        40 - 59% = 8605 
        60 - 79% = 570 
        80 - 99% = 10432 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17172, nodes: 21149336 
    Average node length: 6.31, total dup: 18585335, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914550, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 5 
        40 - 59% = 776 
        60 - 79% = 274 
        80 - 99% = 16112 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21370, nodes: 21149336 
    Average node length: 6.35, total dup: 18505176, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3575012, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 2 
        40 - 59% = 8815 
        60 - 79% = 624 
        80 - 99% = 11923 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16176, nodes: 21149336 
    Average node length: 5.56, total dup: 21149236, max dup: 229289 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943319, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 3015 
        60 - 79% = 429 
        80 - 99% = 12722 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 77.42, total records: 9597336 
    Average version length: 82.63, total versions: 580059, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 104, data page slots: 169104 
    Data pages: 169048, average fill: 70% 
    Primary pages: 169048, secondary pages: 0, swept pages: 64430 
    Empty pages: 816, full pages: 102730 
    Fill distribution: 
     0 - 19% = 2295 
    20 - 39% = 8155 
    40 - 59% = 26023 
    60 - 79% = 65650 
    80 - 99% = 66925 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11345, nodes: 9597336 
    Average node length: 5.36, total dup: 9290977, max dup: 199 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2087205, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 81 
        40 - 59% = 8495 
        60 - 79% = 2720 
        80 - 99% = 46 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13597, nodes: 9597336 
    Average node length: 6.23, total dup: 7956694, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1438272, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 4187 
        40 - 59% = 4472 
        60 - 79% = 2449 
        80 - 99% = 2350 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12667, nodes: 9597336 
    Average node length: 5.98, total dup: 8328677, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2280137, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 100 
        40 - 59% = 9529 
        60 - 79% = 2966 
        80 - 99% = 70 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10101, nodes: 9597336 
    Average node length: 5.13, total dup: 9597236, max dup: 160368 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1474343, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1326 
        40 - 59% = 5049 
        60 - 79% = 1612 
        80 - 99% = 2067 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 78.84, total records: 11203943 
    Average version length: 82.59, total versions: 470665, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 117, data page slots: 190888 
    Data pages: 189432, average fill: 73% 
    Primary pages: 189432, secondary pages: 0, swept pages: 65314 
    Empty pages: 3374, full pages: 142897 
    Fill distribution: 
     0 - 19% = 5818 
    20 - 39% = 8034 
    40 - 59% = 17244 
    60 - 79% = 38973 
    80 - 99% = 119363 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13100, nodes: 11203943 
    Average node length: 5.29, total dup: 11094689, max dup: 704 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2336585, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 141 
        40 - 59% = 9435 
        60 - 79% = 3414 
        80 - 99% = 110 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10363, nodes: 11203943 
    Average node length: 5.49, total dup: 10714310, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 704467, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 155 
        20 - 39% = 846 
        40 - 59% = 2585 
        60 - 79% = 1792 
        80 - 99% = 4985 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14993, nodes: 11203943 
    Average node length: 6.02, total dup: 9777409, max dup: 73 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2353053, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 160 
        40 - 59% = 11004 
        60 - 79% = 3709 
        80 - 99% = 117 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10725, nodes: 11203943 
    Average node length: 5.21, total dup: 11203843, max dup: 193606 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 692908, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 849 
        40 - 59% = 4777 
        60 - 79% = 1585 
        80 - 99% = 3418 
 
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: 77.81, total records: 9706246 
    Average version length: 82.92, total versions: 576931, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.62 
    Pointer pages: 107, data page slots: 173584 
    Data pages: 173536, average fill: 69% 
    Primary pages: 173536, secondary pages: 0, swept pages: 68408 
    Empty pages: 888, full pages: 99894 
    Fill distribution: 
     0 - 19% = 2594 
    20 - 39% = 9092 
    40 - 59% = 28507 
    60 - 79% = 69319 
    80 - 99% = 64024 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11719, nodes: 9706246 
    Average node length: 5.18, total dup: 9677657, max dup: 1563 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1904088, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 29 
        20 - 39% = 1492 
        40 - 59% = 7732 
        60 - 79% = 1886 
        80 - 99% = 580 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13721, nodes: 9706246 
    Average node length: 6.25, total dup: 8046299, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1396930, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 167 
        20 - 39% = 4150 
        40 - 59% = 4477 
        60 - 79% = 2475 
        80 - 99% = 2452 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12366, nodes: 9706246 
    Average node length: 5.43, total dup: 9272092, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2037064, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 24 
        20 - 39% = 1450 
        40 - 59% = 8704 
        60 - 79% = 1644 
        80 - 99% = 544 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10250, nodes: 9706246 
    Average node length: 5.15, total dup: 9706146, max dup: 159992 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1489120, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1346 
        40 - 59% = 5143 
        60 - 79% = 1641 
        80 - 99% = 2074 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.37, total records: 576719 
    Average version length: 68.80, total versions: 6755, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7976 
    Data pages: 7976, average fill: 76% 
    Primary pages: 7976, secondary pages: 0, swept pages: 3658 
    Empty pages: 4, full pages: 6942 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 21 
    40 - 59% = 189 
    60 - 79% = 7633 
    80 - 99% = 125 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 33395, depth: 3, leaf buckets: 740, nodes: 576719 
    Average node length: 5.95, total dup: 491083, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 100420, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 532 
        60 - 79% = 88 
        80 - 99% = 90 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 28017, depth: 3, leaf buckets: 755, nodes: 576719 
    Average node length: 6.15, total dup: 473129, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 100468, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 531 
        60 - 79% = 85 
        80 - 99% = 109 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 577, nodes: 576719 
    Average node length: 4.86, total dup: 576619, max dup: 9317 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89264, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 38 
        40 - 59% = 332 
        60 - 79% = 101 
        80 - 99% = 105 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Fri Mar  8 16:11:43 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7745599 115580 1 0.0000 0.0000
DOC_LIST 2235678 112322 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 230967 608 57700.0000 0.0000
INVNT_TURNOVER_LOG 85933 69375 1 0.0000 0.0000
MONEY_SALDO 49 18110 961 36900.0000 0.0000
MONEY_TURNOVER_LOG 1307 1224 1 0.0000 0.0000
PDISTR 820793 78137 4 0.0000 0.0000
PERF_SPLIT_0 190468 14731 1 0.0000 0.0000
PERF_SPLIT_1 181913 5555 1 0.0000 0.0000
PERF_SPLIT_2 165850 11148 1 0.0000 0.0000
PERF_SPLIT_3 165464 7050 1 0.0000 0.0000
PERF_SPLIT_4 159841 5508 1 0.0000 0.0000
PERF_SPLIT_5 178410 19740 1 0.0000 0.0000
PERF_SPLIT_6 158601 9143 1 0.0000 0.0000
PERF_SPLIT_7 192709 5007 1 0.0000 0.0000
PERF_SPLIT_8 168894 13239 1 0.0000 0.0000
PERF_SPLIT_9 178731 14718 1 0.0000 0.0000
PSTORNED 2098774 45688 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 156561 69396 1 0.0000 0.0000
XQD_1000_3300 7362189 460698 1 0.0000 0.0000
XQD_1200_2000 12368105 394531 1 0.0000 0.0000
XQD_2000_3300 1772100 805371 1 0.0000 0.0000
XQD_2100_3300 1162695 525461 1 0.0000 0.0000
XQD_3300_3400 9128332 568981 1 0.0000 0.0000
XQS_1000_1200 21149336 17539 1 0.0000 0.0000
XQS_1000_3300 9597336 580059 1 0.0000 0.0000
XQS_1200_2000 11203943 470665 1 0.0000 0.0000
XQS_2100_3300 9706246 576931 1 0.0000 0.0000
XQS_3300_3400 576719 6755 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 ---
:122: 
:123: mscs-test-161.budzdorov.ru    Fri Mar  8 16:09:51 2024
:124:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:125: 
:126: 
:127: mscs-test-161.budzdorov.ru    Fri Mar  8 16:09:58 2024
:128:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:129: 
:130: 
:131: mscs-test-161.budzdorov.ru    Fri Mar  8 16:09:58 2024
:132:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:133: 
--- end of diff output ---

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

08.03.24 16:11:55. 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-08 16:11:58 No severe PSQL-related problems occured
08.03.24 16:11:59. End of report.