Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.03.2024 19:11
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 15681392 kB
MemAvailable 30313376 kB
Buffers 0 kB
Cached 16077096 kB
SwapCached 2320 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-11 19:09:39
DTS_END                         2024-03-11 19:09:39.4670
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/45604
TRN_ID                          184016
ATT_ID                          522
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: 9213.20 21605 921320
customer order: creation 191.06 330 19106
customer order: refuse 17.08 373 1708
order to supplier: creation 49.83 1314 4983
order to supplier: removal 3.27 89937 327
invoice (draft): creation 49.94 3310 4994
invoice (draft): removal 46.97 788 4697
invoice accept: apply 46.55 21518 4655
invoice accept: cancel 41.42 904 4142
customer reserve: creation 4386.08 210 438608
customer reserve: removal 4071.14 56 407114
realization accept: apply 92.28 169 9228
realization accept: cancel 73.86 137 7386
payment from customer: creation 66.05 109 6605
payment from customer: removal 7.03 67 703
payment to supplier: creation 54.28 126 5428
payment to supplier: removal 3.67 91 367
service: total inventory turnovers 5.39 1002 539
service: total monetary turnovers 6.44 57 644
service: aggregate perf. data 0.83 16184 83
service: refresh index statistics 0.03 295414 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-03-2024 19:11:26 to 11-03-2024 19:11:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1233
TEST_TIME 2 3234
TEST_TIME 3 3372
TEST_TIME 4 4153
TEST_TIME 5 4010
TEST_TIME 6 4639
TEST_TIME 7 4806
TEST_TIME 8 5159
TEST_TIME 9 5348
TEST_TIME 10 6164
TEST_TIME 11 6074
TEST_TIME 12 6429
TEST_TIME 13 6763
TEST_TIME 14 6846
TEST_TIME 15 6756
TEST_TIME 16 7182
TEST_TIME 17 7099
TEST_TIME 18 7264
TEST_TIME 19 7390
TEST_TIME 20 7534
TEST_TIME 21 7638
TEST_TIME 22 7928
TEST_TIME 23 8333
TEST_TIME 24 8139
TEST_TIME 25 8056
TEST_TIME 26 8182
TEST_TIME 27 8318
TEST_TIME 28 8498
TEST_TIME 29 8719
TEST_TIME 30 8818
TEST_TIME 31 9282
TEST_TIME 32 9368
TEST_TIME 33 9273
TEST_TIME 34 9346
TEST_TIME 35 9157
TEST_TIME 36 9065
TEST_TIME 37 9278
TEST_TIME 38 9315
TEST_TIME 39 9227
TEST_TIME 40 9276
TEST_TIME 41 9283
TEST_TIME 42 9370
TEST_TIME 43 9404
TEST_TIME 44 9565
TEST_TIME 45 9407
TEST_TIME 46 9276
TEST_TIME 47 9227
TEST_TIME 48 9163
TEST_TIME 49 9142
TEST_TIME 50 9159
TEST_TIME 51 9151
TEST_TIME 52 9215
TEST_TIME 53 9291
TEST_TIME 54 9224
TEST_TIME 55 9215
TEST_TIME 56 9232
TEST_TIME 57 9177
TEST_TIME 58 9089
TEST_TIME 59 9053
TEST_TIME 60 9017
TEST_TIME 61 9034
TEST_TIME 62 9048
TEST_TIME 63 9041
TEST_TIME 64 9156
TEST_TIME 65 9179
TEST_TIME 66 9177
TEST_TIME 67 9203
TEST_TIME 68 9253
TEST_TIME 69 9225
TEST_TIME 70 9313
TEST_TIME 71 9316
TEST_TIME 72 9324
TEST_TIME 73 9430
TEST_TIME 74 9472
TEST_TIME 75 9405
TEST_TIME 76 9332
TEST_TIME 77 9317
TEST_TIME 78 9280
TEST_TIME 79 9249
TEST_TIME 80 9177
TEST_TIME 81 9125
TEST_TIME 82 9101
TEST_TIME 83 9080
TEST_TIME 84 9001
TEST_TIME 85 8998
TEST_TIME 86 9055
TEST_TIME 87 9109
TEST_TIME 88 9141
TEST_TIME 89 9162
TEST_TIME 90 9106
TEST_TIME 91 9204
TEST_TIME 92 9234
TEST_TIME 93 9253
TEST_TIME 94 9261
TEST_TIME 95 9285
TEST_TIME 96 9296
TEST_TIME 97 9319
TEST_TIME 98 9306
TEST_TIME 99 9243
TEST_TIME 100 9214

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 11-03-2024 19:11:29 to 11-03-2024 19:11:33.

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 1321070 1321070 0 0.00 0 13091 7 0 0
doc_list_biud 1321070 1321070 0 0.00 0 25963 23 0 0
sp_add_invoice_to_stock 4773 4655 118 2.47 33 167117 21518 0 118
sp_cancel_adding_invoice 4142 4142 0 0.00 4 55799 905 0 0
sp_cancel_client_order 1708 1708 0 0.00 4 9267 373 0 0
sp_cancel_customer_reserve 407114 407114 0 0.00 1 25975 56 0 0
sp_cancel_pay_from_customer 703 703 0 0.00 2 1710 68 0 0
sp_cancel_pay_to_supplier 367 367 0 0.00 2 4646 91 0 0
sp_cancel_supplier_invoice 4703 4697 6 0.12 1 22680 788 0 6
sp_cancel_supplier_order 327 327 0 0.00 7 832908 89937 0 0
sp_cancel_write_off 7386 7386 0 0.00 1 10394 138 0 0
sp_client_order 19106 19106 0 0.00 3 21167 331 0 0
sp_customer_reserve 438608 438608 0 0.00 0 77137 211 0 0
sp_fill_shopping_cart 29068 29068 0 0.00 1 33159 37 0 0
sp_fill_shopping_cart_clo_res 438606 438606 0 0.00 0 11687 12 0 0
sp_get_clo_for_invoice 4653 4653 0 0.00 0 26602 313 0 0
sp_kill_cost_storno 12598 12598 0 0.00 0 6477 62 0 0
sp_kill_qstorno_ret_qs2qd 826638 826638 0 0.00 0 25937 31 0 0
sp_kill_qty_storno 439255 439255 0 0.00 0 25959 68 0 0
sp_lock_selected_doc 19326 19326 0 0.00 0 7205 4 0 0
sp_make_cost_storno 25914 25914 0 0.00 0 11119 51 0 0
sp_multiply_rows_for_pdistr 25914 25914 0 0.00 0 11024 27 0 0
sp_multiply_rows_for_qdistr 19106 19106 0 0.00 0 21154 138 0 0
sp_pay_from_customer 6605 6605 0 0.00 4 11055 109 0 0
sp_pay_to_supplier 5428 5428 0 0.00 4 10450 126 0 0
sp_payment_common 12033 12033 0 0.00 2 6307 22 0 0
sp_qd_handle_on_cancel_clo 1708 1708 0 0.00 0 9259 352 0 0
sp_qd_handle_on_invoice_upd_sts 8795 8795 0 0.00 0 20681 339 0 0
sp_qd_handle_on_reserve_upd_sts 9228 9228 0 0.00 0 23400 61 0 0
sp_reserve_write_off 9228 9228 0 0.00 6 23543 170 0 0
sp_supplier_invoice 4994 4994 0 0.00 6 70732 3311 0 0
sp_supplier_order 4983 4983 0 0.00 5 37304 1315 0 0
srv_aggregate_perf_data 84 83 1 1.19 2381 174733 16185 0 1
srv_fill_mon_cache_memory 60 60 0 0.00 2123 133333 35052 0 0
srv_find_qd_qs_mism 873619 873619 0 0.00 0 13091 7 0 0
srv_make_invnt_saldo 539 539 0 0.00 44 24703 1003 0 0
srv_make_money_saldo 644 644 0 0.00 1 14449 57 0 0
srv_recalc_idx_stat 3 3 0 0.00 110426 388063 295415 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4655 4655 0 0.00 0 17017 204 0 0
t$perf-norm:sp_cancel_adding_invoice 361 361 0 0.00 0 8020 109 0 0
t$perf-norm:sp_cancel_client_order 1708 1708 0 0.00 0 4015 19 0 0
t$perf-norm:sp_cancel_customer_reserve 618 618 0 0.00 0 3374 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 703 703 0 0.00 0 1325 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 367 367 0 0.00 0 338 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 394 394 0 0.00 0 6395 25 0 0
t$perf-norm:sp_cancel_supplier_order 327 327 0 0.00 0 27638 1930 0 0
t$perf-norm:sp_cancel_write_off 967 967 0 0.00 0 3625 14 0 0
t$perf-norm:sp_client_order 19106 19106 0 0.00 0 6296 20 0 0
t$perf-norm:sp_customer_reserve 960 960 0 0.00 0 6946 26 0 0
t$perf-norm:sp_pay_from_customer 6605 6605 0 0.00 0 6942 13 0 0
t$perf-norm:sp_pay_to_supplier 5428 5428 0 0.00 0 6179 15 0 0
t$perf-norm:sp_reserve_write_off 9228 9228 0 0.00 0 8696 12 0 0
t$perf-norm:sp_supplier_invoice 4994 4994 0 0.00 0 5793 23 0 0
t$perf-norm:sp_supplier_order 4983 4983 0 0.00 0 2589 17 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 1343 34 0 0
t$perf-norm:srv_fill_mon_cache_memory 60 60 0 0.00 0 8 1 0 0
t$perf-norm:srv_make_invnt_saldo 539 539 0 0.00 0 3498 48 0 0
t$perf-norm:srv_make_money_saldo 644 644 0 0.00 0 6107 40 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 11 4 0 0
v_add_invoice_to_stock 9542 9306 236 2.47 0 2578 15 0 236
v_all_customers 35070 35070 0 0.00 0 56 1 0 0
v_all_suppliers 28158 28158 0 0.00 0 30 1 0 0
v_all_wares 38212 38212 0 0.00 0 189 1 0 0
v_cancel_adding_invoice 722 722 0 0.00 0 532 7 0 0
v_cancel_client_order 3416 3416 0 0.00 0 2587 5 0 0
v_cancel_customer_prepayment 1406 1406 0 0.00 0 1687 5 0 0
v_cancel_customer_reserve 1236 1236 0 0.00 0 3058 10 0 0
v_cancel_payment_to_supplier 734 734 0 0.00 0 3054 11 0 0
v_cancel_supplier_invoice 800 788 12 1.50 0 727 13 0 12
v_cancel_supplier_order 654 654 0 0.00 0 2407 7 0 0
v_cancel_write_off 1934 1934 0 0.00 0 3778 17 0 0
v_max_id_clo_ord 4983 4983 0 0.00 0 643 1 0 0
v_max_id_clo_res 960 960 0 0.00 0 1706 9 0 0
v_max_id_ord_sup 4978 4978 0 0.00 0 3813 4 0 0
v_max_non_paid_invoice 1310 1310 0 0.00 0 1005 3 0 0
v_max_non_paid_realizn 3434 3434 0 0.00 0 2334 5 0 0
v_min_id_clo_ord 4983 4983 0 0.00 0 5679 7 0 0
v_min_id_clo_res 960 960 0 0.00 0 4676 10 0 0
v_min_id_ord_sup 4978 4978 0 0.00 0 7930 9 0 0
v_min_non_paid_invoice 5428 5428 0 0.00 0 6301 15 0 0
v_min_non_paid_realizn 6605 6605 0 0.00 0 6300 16 0 0
v_our_firm 9484 9484 0 0.00 0 24 1 0 0
v_reserve_write_off 18456 18456 0 0.00 0 3709 6 0 0
x_lock_depdocs_on_canc_invoice 8445 8445 0 0.00 0 16852 134 0 0
x_lock_depdocs_on_canc_sup_ord 327 327 0 0.00 0 26973 390 0 0
x_make_qstorno_1000_1200 4983 4983 0 0.00 2 37279 1225 0 0
x_make_qstorno_1200_2000 4994 4994 0 0.00 3 59086 3176 0 0
x_make_qstorno_2100_3300 438608 438608 0 0.00 0 77134 195 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-03-2024 19:11:34 to 11-03-2024 19:11:38.

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
17:09:43 2 8192000000 8799247728 8810889216 5600496 0.068 3 1 2 0 5701424 58144 42784
17:10:45 28538 8192000000 9890918512 10198941696 968515552 10.572 100 89 178 0 996680928 5248752 22916624
17:12:17 19638 8192000000 9937938688 10257326080 1019409056 11.066 100 86 172 0 1048827648 7240880 22177712
17:13:40 15490 8192000000 9968796144 10297298944 1045653744 11.319 100 83 166 0 1074950080 8544640 20751696
17:15:04 14852 8192000000 10027304400 10371096576 1111701216 11.949 100 80 158 0 1139449584 9665984 18082384
17:16:23 5696 8192000000 10073913712 10427711488 1161017648 12.413 100 85 170 0 1193779600 13624608 19137344
17:17:35 4771 8192000000 10112312976 10481057792 1203949760 12.813 100 71 142 0 1231407280 11482560 15974960
17:18:41 2735 8192000000 10154080528 10525945856 1243155584 13.175 100 84 166 1 1274818240 13627904 18034752
17:19:45 2598 8192000000 10174319600 10559311872 1268153792 13.405 100 79 159 0 1298074208 11888320 18032096
17:20:49 793 8192000000 10215209488 10598473728 1293976880 13.640 100 89 176 0 1326325760 12415920 19932960
17:21:53 9777 8192000000 10204762512 10597634048 1299599184 13.692 100 63 126 1 1323426032 9456048 14370800
17:23:03 5018 8192000000 10198382512 10604048384 1305811936 13.748 100 37 75 0 1321584464 7572112 8200416
17:24:10 3114 8192000000 10198756336 10610413568 1315271840 13.834 100 49 97 0 1333178768 6534240 11372688
17:25:15 4528 8192000000 10207802448 10622877696 1320535120 13.882 100 25 48 0 1331874400 5858272 5481008
17:26:23 45950 8192000000 10242139696 10643345408 1329315008 13.961 100 56 112 0 1348804704 4991120 14498576
17:28:10 5040 8192000000 10234231296 10649513984 1335087728 14.013 100 29 56 2 1348842896 7929296 5825872
17:29:18 58178 8192000000 10227918576 10638241792 1308171408 13.769 98 36 70 0 1321210048 4695232 8343408
17:31:24 11140 8192000000 10243832896 10652827648 1329599664 13.964 99 55 109 0 1351363568 9579280 12184624
17:32:42 16414 8192000000 10256530016 10668797952 1353841184 14.182 100 50 100 1 1375759360 11015168 10903008
17:34:16 5990 8192000000 10265326368 10673487872 1355384560 14.196 100 61 122 0 1382895440 13281232 14229648
17:35:25 30091 8192000000 10262293008 10682875904 1336242752 14.024 98 42 82 0 1360775776 15723408 8809616
17:36:58 9585 8192000000 10279894816 10691125248 1359200448 14.230 100 58 116 0 1389427488 17496080 12730960
17:38:11 9310 8192000000 10254442304 10659131392 1324073264 13.914 99 51 101 0 1354056864 17973152 12010448
17:39:25 4575 8192000000 10229572928 10628530176 1308074368 13.769 100 59 118 1 1338890832 17340896 13475568
17:40:33 12816 8192000000 10241238576 10644570112 1320779216 13.884 100 58 114 1 1354426944 20728720 12919008
17:41:53 4271 8192000000 10242042016 10646040576 1318575152 13.864 100 51 103 1 1351601456 20991808 12034496
17:43:03 9562 8192000000 10230431792 10632011776 1302518528 13.718 99 51 102 1 1337023984 22205488 12299968
17:44:25 6905 8192000000 10276466608 10676973568 1337437776 14.034 100 70 138 3 1383292144 28783248 17071120
17:45:40 4542 8192000000 10300576112 10700259328 1353730592 14.181 100 77 149 1 1403203328 31703376 17769360
17:47:00 4281 8192000000 10300173280 10708164608 1358501280 14.224 100 64 127 0 1401265104 28018800 14745024
17:48:09 2302 8192000000 10309516736 10712997888 1367117344 14.301 100 81 160 3 1416239376 29766464 19355568
17:49:17 2349 8192000000 10327636384 10731233280 1374576416 14.368 100 90 178 0 1426909568 31645968 20687184
17:50:23 6525 8192000000 10306653328 10727493632 1371011072 14.336 100 51 102 1 1417280736 32894608 13375056
17:51:39 2120 8192000000 10333745056 10745438208 1382650512 14.440 100 78 154 2 1432760304 31552240 18557552
17:52:43 10637 8192000000 10314880976 10745102336 1390821056 14.513 100 36 72 0 1424421392 24811856 8788480
17:54:02 5179 8192000000 10325655696 10755727360 1395108656 14.551 100 43 85 0 1436449328 30688336 10652336
17:55:13 13033 8192000000 10336165632 10767921152 1393973952 14.541 100 29 58 0 1437234496 35502176 7758368
17:56:38 16645 8192000000 10339517008 10762219520 1394077792 14.542 100 69 137 1 1437542160 26661008 16803360
17:57:58 29269 8192000000 10310844208 10754002944 1389482656 14.501 100 24 48 1 1419234736 23043728 6708352
17:59:31 21298 8192000000 10305337680 10751807488 1384574992 14.457 100 15 30 0 1411353216 22775888 4002336
18:00:54 60474 8192000000 10303202688 10758131712 1391569440 14.520 100 15 30 0 1411239520 16229216 3440864
18:03:00 40725 8192000000 10303305200 10759417856 1398863248 14.585 100 11 22 1 1411402672 9948928 2590496
18:04:41 16736 8192000000 10319096560 10752962560 1388471088 14.492 99 56 110 1 1410524064 8979376 13073600
18:06:08 100903 8192000000 10315147664 10768125952 1403532992 14.626 100 10 20 0 1424817936 18831840 2453104
18:08:50 11324 8192000000 10312515440 10752102400 1383385840 14.447 99 33 63 0 1398043328 7276512 7380976
18:10:03 49182 8192000000 10311127680 10756313088 1391452336 14.519 99 15 28 1 1403244816 8714320 3078160
18:11:53 35899 8192000000 10295292816 10736963584 1293979120 13.640 92 19 38 0 1313045984 15001280 4065584
18:13:31 63707 8192000000 10272803600 10727587840 1333435200 13.998 97 8 13 1 1353435888 19141584 859104
18:16:18 33629 8192000000 10271259616 10699583488 1335530432 14.017 98 47 90 0 1356260400 10772848 9957120
18:17:55 53121 8192000000 10278113200 10724159488 1373494656 14.358 100 29 55 0 1388267600 8992784 5780160
18:19:51 18168 8192000000 10274147296 10715516928 1349192272 14.140 98 17 34 0 1362002944 8688704 4121968
18:21:10 15802 8192000000 10269556928 10723532800 1358932368 14.228 99 41 82 0 1380893280 12901984 9058928
18:22:32 46967 8192000000 10245119296 10681565184 1269071600 13.413 93 12 24 0 1287691296 15830608 2789088
18:24:27 25393 8192000000 10245882224 10689454080 1333183504 13.996 99 22 44 1 1349343104 11291472 4868128
18:25:53 11627 8192000000 10224902944 10660233216 1282611216 13.537 96 14 28 2 1295755664 10113536 3030912
18:27:07 91356 8192000000 10236033456 10683641856 1338143776 14.041 100 19 38 0 1352873552 10621792 4107984
18:29:42 70639 8192000000 10261252960 10708721664 1326577472 13.936 98 8 16 0 1340006576 11609776 1819328
18:31:53 31895 8192000000 10241535664 10691661824 1333306016 13.997 99 15 30 0 1348300480 11515312 3479152
18:33:26 23791 8192000000 10237671216 10686226432 1325418736 13.926 99 26 50 1 1345737984 14664768 5654480
18:34:57 39174 8192000000 10248193312 10685001728 1306112336 13.751 97 23 46 1 1320806304 10089936 4604032
18:36:37 66781 8192000000 10257158880 10703261696 1346851056 14.119 100 25 50 0 1365422048 13207680 5363312
18:38:46 15178 8192000000 10271602352 10698760192 1354443104 14.187 100 46 92 0 1374520912 10253760 9824048
18:40:04 77587 8192000000 10284649792 10729218048 1376934640 14.389 100 16 32 0 1389445376 9135392 3375344
18:42:30 133333 8192000000 10295647248 10748416000 1360802352 14.245 98 13 26 0 1379474496 16177136 2495008
18:46:38 24760 8192000000 10270666576 10723856384 1357213360 14.212 98 20 40 0 1373299776 11644624 4441792
18:48:07 102830 8192000000 10267118560 10725978112 1354928960 14.192 98 8 16 0 1372324848 15749120 1646768
18:50:58 29282 8192000000 10281828544 10740330496 1383106624 14.444 100 18 36 0 1396924720 10071920 3746176
18:52:31 42449 8192000000 10273059408 10723586048 1353211200 14.176 98 11 22 0 1365827152 10116256 2499696
18:54:13 89648 8192000000 10289333888 10741379072 1365782752 14.289 99 17 34 0 1383432432 13788160 3861520
18:57:01 38468 8192000000 10281775792 10737012736 1381466816 14.430 100 19 38 2 1395396480 9963632 3966032
18:58:47 45675 8192000000 10292157792 10734391296 1358812080 14.227 98 19 36 0 1375992032 12829856 4350096
19:00:42 90343 8192000000 10269103152 10735362048 1330906320 13.975 97 12 24 0 1355957936 22230032 2821584
19:03:19 73408 8192000000 10274893312 10729426944 1321717744 13.892 96 13 26 0 1339948144 15425072 2805328
19:05:37 79697 8192000000 10270697712 10721771520 1310502144 13.791 95 20 40 0 1325667936 10905600 4260192
19:07:58 16454 8192000000 10273229120 10703269888 1351111504 14.157 100 37 74 1 1370584224 11307712 8165008
19:09:17 39665 8192000000 9084854288 9307381760 252531376 2.990 19 5 10 0 256589552 3297648 760528

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 11-03-2024 19:11:40 to 11-03-2024 19:11:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 118 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 11-03-2024 19:11:55 to 11-03-2024 19:11:57.

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          184071
MON$OLDEST_ACTIVE               184749
MON$OLDEST_SNAPSHOT             184749
MON$NEXT_TRANSACTION            184749
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                       1928288
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Mon Mar 11 19:11:58 2024 
 
Database header page information: 
    Flags            0 
    Generation        96863 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    184071 
    Oldest active        184749 
    Oldest snapshot        184749 
    Next transaction    184750 
    Sequence number        0 
    Next attachment ID    732 
    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.71, total records: 7796288 
    Average version length: 48.17, total versions: 30806, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87856 
    Data pages: 87856, average fill: 71% 
    Primary pages: 87856, secondary pages: 0, swept pages: 42903 
    Empty pages: 6, full pages: 50403 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 171 
    40 - 59% = 2816 
    60 - 79% = 84827 
    80 - 99% = 12 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23459, nodes: 7796288 
    Average node length: 18.91, total dup: 0, max dup: 0 
    Average key length: 15.92, compression ratio: 1.70 
    Average prefix length: 14.07, average data length: 12.93 
    Clustering factor: 1730606, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 307 
        20 - 39% = 1918 
        40 - 59% = 4186 
        60 - 79% = 2277 
        80 - 99% = 14771 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13619, nodes: 7796288 
    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: 1552872, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1694 
        40 - 59% = 1997 
        60 - 79% = 1042 
        80 - 99% = 8886 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8407, nodes: 7796288 
    Average node length: 6.63, total dup: 5811579, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.61, average data length: 1.39 
    Clustering factor: 1546040, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 110 
        20 - 39% = 1017 
        40 - 59% = 1398 
        60 - 79% = 874 
        80 - 99% = 5008 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 57.11, total records: 2275594 
    Average version length: 35.08, total versions: 28671, max versions: 3 
    Average fragment length: 6.00, total fragments: 4, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28928 
    Data pages: 28928, average fill: 72% 
    Primary pages: 28922, secondary pages: 6, swept pages: 19847 
    Empty pages: 3, full pages: 16817 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 65 
    40 - 59% = 1502 
    60 - 79% = 27148 
    80 - 99% = 189 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4635, nodes: 2275594 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 693008, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 994 
        40 - 59% = 833 
        60 - 79% = 685 
        80 - 99% = 2123 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2574, nodes: 2277355 
    Average node length: 4.97, total dup: 2276456, max dup: 20879 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1268165, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 301 
        40 - 59% = 1563 
        60 - 79% = 530 
        80 - 99% = 180 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2100, nodes: 2275594 
    Average node length: 4.97, total dup: 2275544, max dup: 130621 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1076794, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 82 
        40 - 59% = 1156 
        60 - 79% = 42 
        80 - 99% = 816 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4449, nodes: 2275594 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 693008, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 117 
        20 - 39% = 666 
        40 - 59% = 627 
        60 - 79% = 756 
        80 - 99% = 2283 
 
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: 81.88, total records: 400 
    Average version length: 22.83, total versions: 250707, max versions: 655 
    Average fragment length: 2.00, total fragments: 81, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.27 
    Pointer pages: 1, data page slots: 1408 
    Data pages: 1408, average fill: 88% 
    Primary pages: 13, secondary pages: 1395, swept pages: 0 
    Empty pages: 6, full pages: 1401 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 1399 
 
    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: 12.99, total records: 63488 
    Average version length: 68.27, total versions: 51416, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 6.77 
    Pointer pages: 6, data page slots: 3616 
    Data pages: 1440, average fill: 55% 
    Primary pages: 1438, secondary pages: 2, swept pages: 14 
    Empty pages: 215, full pages: 516 
    Fill distribution: 
     0 - 19% = 267 
    20 - 39% = 220 
    40 - 59% = 229 
    60 - 79% = 291 
    80 - 99% = 433 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700960, depth: 3, leaf buckets: 311, nodes: 63488 
    Average node length: 13.75, total dup: 3251, max dup: 2 
    Average key length: 11.01, compression ratio: 2.45 
    Average prefix length: 18.93, average data length: 8.07 
    Clustering factor: 49113, ratio: 0.77 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 227 
        40 - 59% = 72 
        60 - 79% = 9 
        80 - 99% = 1 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.31, total records: 49 
    Average version length: 9.00, total versions: 18833, max versions: 949 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.09 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 84% 
    Primary pages: 5, secondary pages: 67, swept pages: 0 
    Empty pages: 4, full pages: 67 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 13 
    80 - 99% = 55 
 
    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: 3.37, total records: 2103 
    Average version length: 43.17, total versions: 1945, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 17.22 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 63% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 3, full pages: 16 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 16 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 95495, depth: 2, leaf buckets: 3, nodes: 2103 
    Average node length: 4.06, total dup: 2005, max dup: 213 
    Average key length: 2.49, compression ratio: 7.64 
    Average prefix length: 18.56, average data length: 0.44 
    Clustering factor: 1092, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        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.11, total records: 76 
    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: 53% 
    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% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 76 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.41, total records: 756486 
    Average version length: 25.60, total versions: 52294, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.48 
    Pointer pages: 6, data page slots: 8288 
    Data pages: 8272, average fill: 64% 
    Primary pages: 8226, secondary pages: 46, swept pages: 3680 
    Empty pages: 140, full pages: 3857 
    Fill distribution: 
     0 - 19% = 355 
    20 - 39% = 372 
    40 - 59% = 720 
    60 - 79% = 6645 
    80 - 99% = 180 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 882, nodes: 756486 
    Average node length: 4.86, total dup: 756437, max dup: 137734 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 86320, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 186 
        40 - 59% = 499 
        60 - 79% = 156 
        80 - 99% = 39 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 931, nodes: 756486 
    Average node length: 5.87, total dup: 673447, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 150945, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 159 
        40 - 59% = 370 
        60 - 79% = 150 
        80 - 99% = 249 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 975, nodes: 756486 
    Average node length: 5.87, total dup: 673447, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 152800, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 235 
        40 - 59% = 359 
        60 - 79% = 151 
        80 - 99% = 230 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1121, nodes: 756486 
    Average node length: 5.95, total dup: 673447, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 146149, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 281 
        40 - 59% = 613 
        60 - 79% = 164 
        80 - 99% = 61 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.87, total records: 5457 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.31, total fragments: 72, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 95, average fill: 57% 
    Primary pages: 74, secondary pages: 21, swept pages: 59 
    Empty pages: 13, full pages: 67 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5457 
    Average node length: 5.50, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.03 
    Average prefix length: 34.40, average data length: 1.55 
    Clustering factor: 5201, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5457 
    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: 143, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 6 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.12, total records: 84320 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 816 
    Data pages: 816, average fill: 71% 
    Primary pages: 816, secondary pages: 0, swept pages: 0 
    Empty pages: 4, full pages: 811 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 812 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 30626, depth: 2, leaf buckets: 108, nodes: 84320 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 3762, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 106 
 
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.11, 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: 135.56, total records: 172483 
    Average version length: 152.16, total versions: 17722, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.51 
    Pointer pages: 7, data page slots: 5936 
    Data pages: 4208, average fill: 85% 
    Primary pages: 4208, secondary pages: 0, swept pages: 5 
    Empty pages: 100, full pages: 4078 
    Fill distribution: 
     0 - 19% = 103 
    20 - 39% = 14 
    40 - 59% = 5 
    60 - 79% = 10 
    80 - 99% = 4076 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 138.35, total records: 170801 
    Average version length: 151.16, total versions: 14344, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.26 
    Pointer pages: 6, data page slots: 4776 
    Data pages: 4104, average fill: 86% 
    Primary pages: 4103, secondary pages: 1, swept pages: 3 
    Empty pages: 47, full pages: 4037 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 4 
    40 - 59% = 5 
    60 - 79% = 11 
    80 - 99% = 4036 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 130.15, total records: 170384 
    Average version length: 152.92, total versions: 23470, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.03 
    Pointer pages: 7, data page slots: 5696 
    Data pages: 4096, average fill: 87% 
    Primary pages: 4096, secondary pages: 0, swept pages: 1 
    Empty pages: 44, full pages: 4031 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 5 
    40 - 59% = 6 
    60 - 79% = 8 
    80 - 99% = 4030 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 135.32, total records: 176834 
    Average version length: 151.75, total versions: 18413, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.53 
    Pointer pages: 6, data page slots: 6040 
    Data pages: 4304, average fill: 85% 
    Primary pages: 4304, secondary pages: 0, swept pages: 1 
    Empty pages: 97, full pages: 4179 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 9 
    40 - 59% = 13 
    60 - 79% = 5 
    80 - 99% = 4178 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 120.83, total records: 189862 
    Average version length: 153.62, total versions: 37967, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.04 
    Pointer pages: 7, data page slots: 6488 
    Data pages: 4648, average fill: 86% 
    Primary pages: 4648, secondary pages: 0, swept pages: 6 
    Empty pages: 120, full pages: 4497 
    Fill distribution: 
     0 - 19% = 123 
    20 - 39% = 11 
    40 - 59% = 6 
    60 - 79% = 12 
    80 - 99% = 4496 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 132.10, total records: 199269 
    Average version length: 152.85, total versions: 25470, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.84 
    Pointer pages: 7, data page slots: 6144 
    Data pages: 4816, average fill: 87% 
    Primary pages: 4816, secondary pages: 0, swept pages: 3 
    Empty pages: 65, full pages: 4722 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 6 
    40 - 59% = 10 
    60 - 79% = 11 
    80 - 99% = 4722 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 135.71, total records: 171347 
    Average version length: 151.91, total versions: 17201, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.50 
    Pointer pages: 7, data page slots: 5840 
    Data pages: 4208, average fill: 85% 
    Primary pages: 4207, secondary pages: 1, swept pages: 3 
    Empty pages: 125, full pages: 4038 
    Fill distribution: 
     0 - 19% = 127 
    20 - 39% = 20 
    40 - 59% = 10 
    60 - 79% = 15 
    80 - 99% = 4036 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 137.95, total records: 173347 
    Average version length: 151.81, total versions: 15120, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.29 
    Pointer pages: 8, data page slots: 6536 
    Data pages: 4200, average fill: 86% 
    Primary pages: 4200, secondary pages: 0, swept pages: 1 
    Empty pages: 71, full pages: 4096 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 12 
    40 - 59% = 10 
    60 - 79% = 8 
    80 - 99% = 4096 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 139.15, total records: 174587 
    Average version length: 150.99, total versions: 13657, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.19 
    Pointer pages: 6, data page slots: 4872 
    Data pages: 4232, average fill: 86% 
    Primary pages: 4232, secondary pages: 0, swept pages: 1 
    Empty pages: 81, full pages: 4121 
    Fill distribution: 
     0 - 19% = 82 
    20 - 39% = 14 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4121 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 118.42, total records: 188756 
    Average version length: 154.32, total versions: 40702, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 14.32 
    Pointer pages: 7, data page slots: 6584 
    Data pages: 4648, average fill: 86% 
    Primary pages: 4648, secondary pages: 0, swept pages: 1 
    Empty pages: 135, full pages: 4473 
    Fill distribution: 
     0 - 19% = 138 
    20 - 39% = 16 
    40 - 59% = 10 
    60 - 79% = 12 
    80 - 99% = 4472 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 52.32, total records: 2128413 
    Average version length: 53.05, total versions: 17446, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25840 
    Data pages: 25840, average fill: 71% 
    Primary pages: 25840, secondary pages: 0, swept pages: 12375 
    Empty pages: 230, full pages: 20458 
    Fill distribution: 
     0 - 19% = 484 
    20 - 39% = 455 
    40 - 59% = 1201 
    60 - 79% = 23564 
    80 - 99% = 136 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2609, nodes: 2128413 
    Average node length: 5.44, total dup: 1986390, max dup: 1863 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 183430, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 292 
        40 - 59% = 1714 
        60 - 79% = 303 
        80 - 99% = 297 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2767, nodes: 2128413 
    Average node length: 5.69, total dup: 1910518, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 379566, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 2360 
        60 - 79% = 380 
        80 - 99% = 23 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2236, nodes: 2128413 
    Average node length: 4.96, total dup: 2128313, max dup: 28456 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 181518, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 236 
        40 - 59% = 1271 
        60 - 79% = 356 
        80 - 99% = 368 
 
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: 44.67, total records: 125272 
    Average version length: 69.17, total versions: 44427, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.82 
    Pointer pages: 3, data page slots: 4480 
    Data pages: 2895, average fill: 51% 
    Primary pages: 2895, secondary pages: 0, swept pages: 394 
    Empty pages: 387, full pages: 595 
    Fill distribution: 
     0 - 19% = 515 
    20 - 39% = 246 
    40 - 59% = 860 
    60 - 79% = 981 
    80 - 99% = 293 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 101326, depth: 3, leaf buckets: 240, nodes: 125272 
    Average node length: 6.53, total dup: 108909, max dup: 14 
    Average key length: 4.00, compression ratio: 10.51 
    Average prefix length: 40.13, average data length: 1.87 
    Clustering factor: 22029, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 118 
        40 - 59% = 87 
        60 - 79% = 32 
        80 - 99% = 2 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.93, total records: 6572307 
    Average version length: 68.83, total versions: 193794, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 61, data page slots: 99320 
    Data pages: 99320, average fill: 71% 
    Primary pages: 99320, secondary pages: 0, swept pages: 56672 
    Empty pages: 107, full pages: 53752 
    Fill distribution: 
     0 - 19% = 644 
    20 - 39% = 1439 
    40 - 59% = 9000 
    60 - 79% = 86003 
    80 - 99% = 2234 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10539, nodes: 6572307 
    Average node length: 6.52, total dup: 5682875, max dup: 29 
    Average key length: 3.53, compression ratio: 11.90 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1440214, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2255 
        40 - 59% = 5897 
        60 - 79% = 2041 
        80 - 99% = 338 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8348, nodes: 6572307 
    Average node length: 5.41, total dup: 6298817, max dup: 160 
    Average key length: 2.42, compression ratio: 7.01 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1260886, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1539 
        40 - 59% = 4628 
        60 - 79% = 1379 
        80 - 99% = 794 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8430, nodes: 6572307 
    Average node length: 5.41, total dup: 6298817, max dup: 160 
    Average key length: 2.42, compression ratio: 7.01 
    Average prefix length: 16.62, average data length: 0.38 
    Clustering factor: 1263511, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1621 
        40 - 59% = 4652 
        60 - 79% = 1413 
        80 - 99% = 737 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.81, total records: 11630279 
    Average version length: 68.80, total versions: 193678, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 101, data page slots: 164480 
    Data pages: 164480, average fill: 75% 
    Primary pages: 164480, secondary pages: 0, swept pages: 102874 
    Empty pages: 4, full pages: 132399 
    Fill distribution: 
     0 - 19% = 15 
    20 - 39% = 274 
    40 - 59% = 4645 
    60 - 79% = 156150 
    80 - 99% = 3396 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18270, nodes: 11630279 
    Average node length: 6.57, total dup: 10138048, max dup: 50 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2306191, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 2831 
        40 - 59% = 11037 
        60 - 79% = 3732 
        80 - 99% = 632 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 51.61, total records: 1302817 
    Average version length: 69.06, total versions: 330652, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.44 
    Pointer pages: 30, data page slots: 47216 
    Data pages: 29896, average fill: 49% 
    Primary pages: 29896, secondary pages: 0, swept pages: 15356 
    Empty pages: 6017, full pages: 12829 
    Fill distribution: 
     0 - 19% = 8488 
    20 - 39% = 3177 
    40 - 59% = 3202 
    60 - 79% = 10279 
    80 - 99% = 4750 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2274, nodes: 1302817 
    Average node length: 5.55, total dup: 1249282, max dup: 99 
    Average key length: 2.59, compression ratio: 16.22 
    Average prefix length: 41.45, average data length: 0.55 
    Clustering factor: 88123, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1263 
        40 - 59% = 871 
        60 - 79% = 125 
        80 - 99% = 7 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 56.63, total records: 815229 
    Average version length: 69.13, total versions: 146412, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.22 
    Pointer pages: 19, data page slots: 30904 
    Data pages: 24943, average fill: 37% 
    Primary pages: 24943, secondary pages: 0, swept pages: 12079 
    Empty pages: 4186, full pages: 1808 
    Fill distribution: 
     0 - 19% = 7333 
    20 - 39% = 5081 
    40 - 59% = 6870 
    60 - 79% = 5194 
    80 - 99% = 465 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1467, nodes: 815229 
    Average node length: 5.85, total dup: 757778, max dup: 99 
    Average key length: 2.92, compression ratio: 14.38 
    Average prefix length: 41.15, average data length: 0.85 
    Clustering factor: 111873, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 767 
        40 - 59% = 583 
        60 - 79% = 109 
        80 - 99% = 5 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 68.00, total records: 9247487 
    Average version length: 69.02, total versions: 120149, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 91, data page slots: 147928 
    Data pages: 147904, average fill: 67% 
    Primary pages: 147904, secondary pages: 0, swept pages: 109295 
    Empty pages: 362, full pages: 63267 
    Fill distribution: 
     0 - 19% = 1193 
    20 - 39% = 6470 
    40 - 59% = 28833 
    60 - 79% = 109887 
    80 - 99% = 1521 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13561, nodes: 9247487 
    Average node length: 6.71, total dup: 7669080, max dup: 14 
    Average key length: 3.67, compression ratio: 11.44 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2009476, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1124 
        40 - 59% = 7016 
        60 - 79% = 4806 
        80 - 99% = 614 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.45, total records: 21219092 
    Average version length: 83.01, total versions: 23075, 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: 319696 
    Data pages: 319696, average fill: 81% 
    Primary pages: 319696, secondary pages: 0, swept pages: 12243 
    Empty pages: 3, full pages: 319426 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 9 
    40 - 59% = 54 
    60 - 79% = 27273 
    80 - 99% = 292351 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19500, nodes: 21219092 
    Average node length: 5.72, total dup: 20736762, max dup: 170 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3294858, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8267 
        60 - 79% = 585 
        80 - 99% = 10644 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17260, nodes: 21219092 
    Average node length: 6.31, total dup: 18648387, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 920395, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 3 
        40 - 59% = 825 
        60 - 79% = 312 
        80 - 99% = 16117 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21284, nodes: 21219092 
    Average node length: 6.35, total dup: 18566524, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3589465, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1 
        40 - 59% = 8517 
        60 - 79% = 638 
        80 - 99% = 12125 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16266, nodes: 21219092 
    Average node length: 5.56, total dup: 21218992, max dup: 229748 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 948956, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 5 
        40 - 59% = 3128 
        60 - 79% = 410 
        80 - 99% = 12723 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 74.27, total records: 10639016 
    Average version length: 82.64, total versions: 1053531, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.70 
    Pointer pages: 109, data page slots: 176432 
    Data pages: 176400, average fill: 75% 
    Primary pages: 176400, secondary pages: 0, swept pages: 34892 
    Empty pages: 401, full pages: 135224 
    Fill distribution: 
     0 - 19% = 945 
    20 - 39% = 3961 
    40 - 59% = 19151 
    60 - 79% = 51865 
    80 - 99% = 100478 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11479, nodes: 10639016 
    Average node length: 5.38, total dup: 10322111, max dup: 222 
    Average key length: 2.22, compression ratio: 4.06 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2351184, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 27 
        40 - 59% = 5268 
        60 - 79% = 5804 
        80 - 99% = 377 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 14144, nodes: 10639016 
    Average node length: 6.26, total dup: 8821751, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1650856, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 126 
        20 - 39% = 3570 
        40 - 59% = 4631 
        60 - 79% = 2420 
        80 - 99% = 3397 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12815, nodes: 10639016 
    Average node length: 5.99, total dup: 9271659, max dup: 48 
    Average key length: 2.82, compression ratio: 3.19 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2566713, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 33 
        40 - 59% = 6108 
        60 - 79% = 6250 
        80 - 99% = 423 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10841, nodes: 10639016 
    Average node length: 5.17, total dup: 10638916, max dup: 169748 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1701749, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 988 
        40 - 59% = 5597 
        60 - 79% = 1748 
        80 - 99% = 2481 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 77.12, total records: 12111466 
    Average version length: 82.56, total versions: 764741, 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: 122, data page slots: 197728 
    Data pages: 196928, average fill: 76% 
    Primary pages: 196928, secondary pages: 0, swept pages: 48638 
    Empty pages: 2395, full pages: 163033 
    Fill distribution: 
     0 - 19% = 3858 
    20 - 39% = 4695 
    40 - 59% = 12697 
    60 - 79% = 36974 
    80 - 99% = 138704 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13174, nodes: 12111466 
    Average node length: 5.32, total dup: 12000027, max dup: 692 
    Average key length: 2.08, compression ratio: 4.34 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2535842, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 19 
        40 - 59% = 7140 
        60 - 79% = 5513 
        80 - 99% = 500 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10952, nodes: 12111466 
    Average node length: 5.52, total dup: 11585480, max dup: 49 
    Average key length: 2.27, compression ratio: 3.96 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 775612, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 148 
        20 - 39% = 753 
        40 - 59% = 2644 
        60 - 79% = 1744 
        80 - 99% = 5663 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15070, nodes: 12111466 
    Average node length: 6.04, total dup: 10592321, max dup: 73 
    Average key length: 2.79, compression ratio: 3.22 
    Average prefix length: 8.33, average data length: 0.67 
    Clustering factor: 2552769, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 26 
        40 - 59% = 8574 
        60 - 79% = 5920 
        80 - 99% = 545 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 11371, nodes: 12111466 
    Average node length: 5.25, total dup: 12111366, max dup: 215687 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.40, average data length: 0.00 
    Clustering factor: 763372, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 71 
        20 - 39% = 685 
        40 - 59% = 5245 
        60 - 79% = 1430 
        80 - 99% = 3940 
 
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: 75.13, total records: 10689658 
    Average version length: 82.91, total versions: 983915, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.68 
    Pointer pages: 112, data page slots: 181936 
    Data pages: 181936, average fill: 73% 
    Primary pages: 181936, secondary pages: 0, swept pages: 44304 
    Empty pages: 545, full pages: 126107 
    Fill distribution: 
     0 - 19% = 1425 
    20 - 39% = 5267 
    40 - 59% = 24286 
    60 - 79% = 57535 
    80 - 99% = 93423 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12677, nodes: 10689658 
    Average node length: 5.22, total dup: 10659534, max dup: 2158 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2140381, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 26 
        20 - 39% = 1165 
        40 - 59% = 8588 
        60 - 79% = 2194 
        80 - 99% = 704 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 14294, nodes: 10689658 
    Average node length: 6.29, total dup: 8865594, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1574971, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 178 
        20 - 39% = 3496 
        40 - 59% = 4811 
        60 - 79% = 2333 
        80 - 99% = 3476 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 13288, nodes: 10689658 
    Average node length: 5.47, total dup: 10222514, max dup: 115 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2281530, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 19 
        20 - 39% = 1094 
        40 - 59% = 9526 
        60 - 79% = 1934 
        80 - 99% = 715 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10992, nodes: 10689658 
    Average node length: 5.20, total dup: 10689558, max dup: 172189 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1685633, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1058 
        40 - 59% = 5805 
        60 - 79% = 1608 
        80 - 99% = 2483 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.58, total records: 592311 
    Average version length: 68.82, total versions: 13906, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 5, data page slots: 8120 
    Data pages: 8120, average fill: 77% 
    Primary pages: 8120, secondary pages: 0, swept pages: 2534 
    Empty pages: 4, full pages: 7451 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 11 
    40 - 59% = 153 
    60 - 79% = 7666 
    80 - 99% = 285 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 34227, depth: 3, leaf buckets: 756, nodes: 592311 
    Average node length: 5.95, total dup: 504614, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 102521, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 22 
        40 - 59% = 539 
        60 - 79% = 108 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 26164, depth: 3, leaf buckets: 775, nodes: 592311 
    Average node length: 6.15, total dup: 485950, max dup: 25 
    Average key length: 3.29, compression ratio: 2.74 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 102588, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 23 
        40 - 59% = 542 
        60 - 79% = 115 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 576, nodes: 592311 
    Average node length: 4.86, total dup: 592211, max dup: 10218 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90858, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 16 
        40 - 59% = 337 
        60 - 79% = 89 
        80 - 99% = 134 
 
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 Mon Mar 11 19:12:23 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7796288 30806 1 0.0000 0.0000
DOC_LIST 2275594 28671 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 250707 655 62600.0000 0.0000
INVNT_TURNOVER_LOG 63488 51416 1 0.0000 0.0000
MONEY_SALDO 49 18833 949 38400.0000 0.0000
MONEY_TURNOVER_LOG 2103 1945 1 0.0000 0.0000
PDISTR 756486 52294 4 0.0000 0.0000
PERF_SPLIT_0 172483 17722 1 0.0000 0.0000
PERF_SPLIT_1 170801 14344 1 0.0000 0.0000
PERF_SPLIT_2 170384 23470 1 0.0000 0.0000
PERF_SPLIT_3 176834 18413 1 0.0000 0.0000
PERF_SPLIT_4 189862 37967 1 0.0000 0.0000
PERF_SPLIT_5 199269 25470 1 0.0000 0.0000
PERF_SPLIT_6 171347 17201 1 0.0000 0.0000
PERF_SPLIT_7 173347 15120 1 0.0000 0.0000
PERF_SPLIT_8 174587 13657 1 0.0000 0.0000
PERF_SPLIT_9 188756 40702 1 0.0000 0.0000
PSTORNED 2128413 17446 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 125272 44427 1 0.0000 0.0000
XQD_1000_3300 6572307 193794 1 0.0000 0.0000
XQD_1200_2000 11630279 193678 1 0.0000 0.0000
XQD_2000_3300 1302817 330652 1 0.0000 0.0000
XQD_2100_3300 815229 146412 1 0.0000 0.0000
XQD_3300_3400 9247487 120149 1 0.0000 0.0000
XQS_1000_1200 21219092 23075 1 0.0000 0.0000
XQS_1000_3300 10639016 1053531 1 0.0000 0.0000
XQS_1200_2000 12111466 764741 1 0.0000 0.0000
XQS_2100_3300 10689658 983915 1 0.0000 0.0000
XQS_3300_3400 592311 13906 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 ---
:171: 
:172: mscs-test-161.budzdorov.ru    Mon Mar 11 19:09:58 2024
:173:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:174: 
:175: 
:176: mscs-test-161.budzdorov.ru    Mon Mar 11 19:10:11 2024
:177:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:178: 
--- end of diff output ---

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

11.03.24 19:12:34. 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-11 19:12:37 No severe PSQL-related problems occured
11.03.24 19:12:38. End of report.