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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15508556 kB
MemAvailable 30276352 kB
Buffers 0 kB
Cached 16239332 kB
SwapCached 2584 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-20 19:09:47
DTS_END                         2024-03-20 19:09:47.1600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58026
TRN_ID                          174795
ATT_ID                          597
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: 9356.47 21851 935647
customer order: creation 174.55 391 17455
customer order: refuse 15.18 404 1518
order to supplier: creation 46.85 1373 4685
order to supplier: removal 3.81 113162 381
invoice (draft): creation 47.04 3474 4704
invoice (draft): removal 52.01 873 5201
invoice accept: apply 41.98 21650 4198
invoice accept: cancel 46.83 973 4683
customer reserve: creation 4031.24 207 403124
customer reserve: removal 4596.28 74 459628
realization accept: apply 87.16 204 8716
realization accept: cancel 83.26 144 8326
payment from customer: creation 59.88 129 5988
payment from customer: removal 5.13 87 513
payment to supplier: creation 49.03 154 4903
payment to supplier: removal 3.51 153 351
service: total inventory turnovers 4.83 1331 483
service: total monetary turnovers 7.00 41 700
service: aggregate perf. data 0.87 21860 87
service: refresh index statistics 0.03 270343 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-03-2024 19:11:12 to 20-03-2024 19:11:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1897
TEST_TIME 2 2896
TEST_TIME 3 3997
TEST_TIME 4 3367
TEST_TIME 5 3709
TEST_TIME 6 3598
TEST_TIME 7 4155
TEST_TIME 8 4483
TEST_TIME 9 5165
TEST_TIME 10 5268
TEST_TIME 11 5508
TEST_TIME 12 5653
TEST_TIME 13 6138
TEST_TIME 14 6103
TEST_TIME 15 6036
TEST_TIME 16 6234
TEST_TIME 17 6256
TEST_TIME 18 6199
TEST_TIME 19 6497
TEST_TIME 20 6606
TEST_TIME 21 6660
TEST_TIME 22 6999
TEST_TIME 23 6911
TEST_TIME 24 6957
TEST_TIME 25 7091
TEST_TIME 26 7028
TEST_TIME 27 7416
TEST_TIME 28 7469
TEST_TIME 29 8247
TEST_TIME 30 8510
TEST_TIME 31 9033
TEST_TIME 32 9168
TEST_TIME 33 9709
TEST_TIME 34 9718
TEST_TIME 35 9832
TEST_TIME 36 9687
TEST_TIME 37 9615
TEST_TIME 38 9693
TEST_TIME 39 9614
TEST_TIME 40 9706
TEST_TIME 41 9735
TEST_TIME 42 9660
TEST_TIME 43 9515
TEST_TIME 44 9418
TEST_TIME 45 9434
TEST_TIME 46 9439
TEST_TIME 47 9297
TEST_TIME 48 9308
TEST_TIME 49 9349
TEST_TIME 50 9310
TEST_TIME 51 9323
TEST_TIME 52 9352
TEST_TIME 53 9296
TEST_TIME 54 9220
TEST_TIME 55 9204
TEST_TIME 56 9237
TEST_TIME 57 9186
TEST_TIME 58 9213
TEST_TIME 59 9196
TEST_TIME 60 9155
TEST_TIME 61 9074
TEST_TIME 62 9026
TEST_TIME 63 9071
TEST_TIME 64 9003
TEST_TIME 65 9072
TEST_TIME 66 9115
TEST_TIME 67 9157
TEST_TIME 68 9150
TEST_TIME 69 9169
TEST_TIME 70 9280
TEST_TIME 71 9283
TEST_TIME 72 9336
TEST_TIME 73 9413
TEST_TIME 74 9472
TEST_TIME 75 9494
TEST_TIME 76 9503
TEST_TIME 77 9457
TEST_TIME 78 9420
TEST_TIME 79 9342
TEST_TIME 80 9355
TEST_TIME 81 9374
TEST_TIME 82 9291
TEST_TIME 83 9277
TEST_TIME 84 9287
TEST_TIME 85 9282
TEST_TIME 86 9298
TEST_TIME 87 9271
TEST_TIME 88 9287
TEST_TIME 89 9377
TEST_TIME 90 9417
TEST_TIME 91 9400
TEST_TIME 92 9394
TEST_TIME 93 9392
TEST_TIME 94 9417
TEST_TIME 95 9410
TEST_TIME 96 9494
TEST_TIME 97 9506
TEST_TIME 98 9422
TEST_TIME 99 9408
TEST_TIME 100 9363

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-03-2024 19:11:16 to 20-03-2024 19:11:19.

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 1305791 1305791 0 0.00 0 17854 7 0 0
doc_list_biud 1305791 1305791 0 0.00 0 37864 32 0 0
sp_add_invoice_to_stock 4301 4198 103 2.39 28 215173 21651 0 103
sp_cancel_adding_invoice 4683 4683 0 0.00 3 84727 973 0 0
sp_cancel_client_order 1518 1518 0 0.00 4 11745 405 0 0
sp_cancel_customer_reserve 459628 459628 0 0.00 0 27283 75 0 0
sp_cancel_pay_from_customer 513 513 0 0.00 2 8559 87 0 0
sp_cancel_pay_to_supplier 351 351 0 0.00 3 8031 153 0 0
sp_cancel_supplier_invoice 5208 5201 7 0.13 2 22462 874 0 7
sp_cancel_supplier_order 381 381 0 0.00 7 1236126 113163 0 0
sp_cancel_write_off 8326 8326 0 0.00 1 13680 144 0 0
sp_client_order 17455 17455 0 0.00 3 27119 392 0 0
sp_customer_reserve 403124 403124 0 0.00 0 92312 208 0 0
sp_fill_shopping_cart 26843 26843 0 0.00 1 15946 37 0 0
sp_fill_shopping_cart_clo_res 403111 403111 0 0.00 0 18164 15 0 0
sp_get_clo_for_invoice 4185 4185 0 0.00 0 19155 259 0 0
sp_kill_cost_storno 13873 13873 0 0.00 0 7432 76 0 0
sp_kill_qstorno_ret_qs2qd 933164 933164 0 0.00 0 27255 40 0 0
sp_kill_qty_storno 492638 492638 0 0.00 0 37863 85 0 0
sp_lock_selected_doc 17784 17784 0 0.00 0 7843 6 0 0
sp_make_cost_storno 23792 23792 0 0.00 0 13352 71 0 0
sp_multiply_rows_for_pdistr 23792 23792 0 0.00 0 7910 35 0 0
sp_multiply_rows_for_qdistr 17455 17455 0 0.00 0 14038 160 0 0
sp_pay_from_customer 5988 5988 0 0.00 4 13415 129 0 0
sp_pay_to_supplier 4903 4903 0 0.00 5 15276 154 0 0
sp_payment_common 10891 10891 0 0.00 2 13410 34 0 0
sp_qd_handle_on_cancel_clo 1518 1518 0 0.00 0 11738 365 0 0
sp_qd_handle_on_invoice_upd_sts 8868 8868 0 0.00 0 37861 365 0 0
sp_qd_handle_on_reserve_upd_sts 8716 8716 0 0.00 0 18426 67 0 0
sp_reserve_write_off 8716 8716 0 0.00 6 18535 204 0 0
sp_supplier_invoice 4704 4704 0 0.00 7 115405 3474 0 0
sp_supplier_order 4685 4685 0 0.00 4 29577 1373 0 0
srv_aggregate_perf_data 88 87 1 1.13 1820 336157 21860 0 1
srv_fill_mon_cache_memory 58 58 0 0.00 2450 151705 34888 0 0
srv_find_qd_qs_mism 893344 893344 0 0.00 0 17853 6 0 0
srv_make_invnt_saldo 483 483 0 0.00 49 145697 1331 0 0
srv_make_money_saldo 700 700 0 0.00 0 5113 42 0 0
srv_recalc_idx_stat 3 3 0 0.00 219922 322145 270344 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 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 4198 4198 0 0.00 0 7896 204 0 0
t$perf-norm:sp_cancel_adding_invoice 350 350 0 0.00 0 2433 102 0 0
t$perf-norm:sp_cancel_client_order 1518 1518 0 0.00 0 1629 12 0 0
t$perf-norm:sp_cancel_customer_reserve 578 578 0 0.00 0 751 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 513 513 0 0.00 0 872 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 351 351 0 0.00 0 944 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 305 305 0 0.00 0 1908 21 0 0
t$perf-norm:sp_cancel_supplier_order 381 381 0 0.00 0 28020 1993 0 0
t$perf-norm:sp_cancel_write_off 887 887 0 0.00 0 5528 13 0 0
t$perf-norm:sp_client_order 17457 17457 0 0.00 0 6247 18 0 0
t$perf-norm:sp_customer_reserve 843 843 0 0.00 0 4207 12 0 0
t$perf-norm:sp_pay_from_customer 5988 5988 0 0.00 0 6155 11 0 0
t$perf-norm:sp_pay_to_supplier 4903 4903 0 0.00 0 3058 9 0 0
t$perf-norm:sp_reserve_write_off 8716 8716 0 0.00 0 6228 13 0 0
t$perf-norm:sp_supplier_invoice 4704 4704 0 0.00 0 8599 22 0 0
t$perf-norm:sp_supplier_order 4685 4685 0 0.00 0 7760 19 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 364 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 58 58 0 0.00 0 480 14 0 0
t$perf-norm:srv_make_invnt_saldo 483 483 0 0.00 0 1766 31 0 0
t$perf-norm:srv_make_money_saldo 700 700 0 0.00 0 816 17 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 8576 8370 206 2.40 0 8021 18 0 206
v_all_customers 32454 32454 0 0.00 0 32 1 0 0
v_all_suppliers 26390 26390 0 0.00 0 19 1 0 0
v_all_wares 34908 34908 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 700 700 0 0.00 0 890 8 0 0
v_cancel_client_order 3036 3036 0 0.00 0 3453 5 0 0
v_cancel_customer_prepayment 1026 1026 0 0.00 0 1282 6 0 0
v_cancel_customer_reserve 1156 1156 0 0.00 0 193 3 0 0
v_cancel_payment_to_supplier 702 702 0 0.00 0 1454 7 0 0
v_cancel_supplier_invoice 624 610 14 2.24 0 511 12 0 14
v_cancel_supplier_order 762 762 0 0.00 0 1182 6 0 0
v_cancel_write_off 1774 1774 0 0.00 0 3570 16 0 0
v_max_id_clo_ord 4685 4685 0 0.00 0 1737 2 0 0
v_max_id_clo_res 843 843 0 0.00 0 3581 15 0 0
v_max_id_ord_sup 4704 4704 0 0.00 0 6768 4 0 0
v_max_non_paid_invoice 1097 1097 0 0.00 0 485 4 0 0
v_max_non_paid_realizn 2828 2828 0 0.00 0 3100 5 0 0
v_min_id_clo_ord 4685 4685 0 0.00 0 5559 9 0 0
v_min_id_clo_res 843 843 0 0.00 0 3550 16 0 0
v_min_id_ord_sup 4704 4704 0 0.00 0 7668 5 0 0
v_min_non_paid_invoice 4903 4903 0 0.00 0 9203 22 0 0
v_min_non_paid_realizn 5988 5988 0 0.00 0 13402 29 0 0
v_our_firm 8774 8774 0 0.00 0 15 1 0 0
v_reserve_write_off 17432 17432 0 0.00 0 2150 5 0 0
x_lock_depdocs_on_canc_invoice 9579 9579 0 0.00 0 22113 150 0 0
x_lock_depdocs_on_canc_sup_ord 381 381 0 0.00 0 8431 369 0 0
x_make_qstorno_1000_1200 4685 4685 0 0.00 1 29569 1287 0 0
x_make_qstorno_1200_2000 4704 4704 0 0.00 4 115376 3347 0 0
x_make_qstorno_2100_3300 403124 403124 0 0.00 0 92309 190 0 0

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

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:51 1 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
17:10:51 43383 8192000000 9890591696 10199846912 967929264 10.566 100 91 182 0 997508064 5460032 24118768
17:12:38 18558 8192000000 9954587664 10274873344 1030538384 11.174 100 91 182 0 1062378096 8325024 23514688
17:13:58 7715 8192000000 9981178960 10312138752 1065892592 11.513 100 88 176 0 1097308880 9494320 21921968
17:15:14 8191 8192000000 10027783376 10374602752 1118267456 12.011 100 85 170 0 1149052528 9966064 20819008
17:16:25 5877 8192000000 10067703344 10422890496 1156252592 12.368 100 77 154 0 1184902864 11121312 17528960
17:17:33 5814 8192000000 10104688992 10472316928 1193636224 12.717 100 77 152 0 1223379488 13116528 16626736
17:18:42 3672 8192000000 10153044256 10527449088 1240229632 13.148 100 82 164 0 1271297136 12813216 18254288
17:19:47 1273 8192000000 10185681600 10565554176 1268844880 13.411 100 82 164 0 1300440800 13429520 18166400
17:20:51 1098 8192000000 10208428848 10590269440 1289374592 13.599 100 91 186 0 1322379264 13058368 19946304
17:21:55 2457 8192000000 10209208336 10598076416 1298746976 13.684 100 74 150 1 1327448688 11915472 16786240
17:22:59 4896 8192000000 10183923632 10599796736 1304206176 13.733 100 34 69 0 1317869072 5254624 8408272
17:24:07 4642 8192000000 10205270544 10614546432 1317502368 13.854 100 31 62 0 1331487376 7547072 6437936
17:25:13 12513 8192000000 10199167920 10619592704 1318397776 13.862 100 11 22 0 1326025664 5334368 2293520
17:26:26 6177 8192000000 10215187408 10632732672 1327940432 13.949 100 34 67 1 1340898384 5333424 7624528
17:27:33 28571 8192000000 10229678432 10648199168 1331247600 13.978 100 47 94 0 1348932240 6542688 11141952
17:29:11 5308 8192000000 10215544368 10637139968 1324563760 13.918 100 21 42 0 1335306832 5889456 4853616
17:30:22 4390 8192000000 10233236336 10639122432 1315535520 13.836 99 55 105 0 1335259248 7579424 12144304
17:31:40 14880 8192000000 10238440208 10637811712 1317339408 13.853 99 60 120 0 1343968032 13294800 13333824
17:32:58 78359 8192000000 10220301648 10642489344 1304259808 13.734 97 34 66 0 1324854080 13029104 7565168
17:35:45 21283 8192000000 10238521872 10648907776 1315755584 13.838 98 45 83 1 1340513856 15019584 9738688
17:37:10 35342 8192000000 10260968800 10673827840 1341654672 14.072 100 37 74 0 1366195248 15754000 8786576
17:38:49 12528 8192000000 10235974624 10635886592 1287412736 13.581 95 52 104 1 1316882672 17088240 12381696
17:40:09 17138 8192000000 10244095792 10647965696 1307109712 13.760 98 49 92 1 1336927440 18562864 11254864
17:41:34 13433 8192000000 10248918896 10655260672 1309095680 13.778 98 50 99 1 1346216096 25164736 11955680
17:42:52 5864 8192000000 10260191056 10663149568 1323558960 13.909 99 62 122 3 1358936768 21173360 14204448
17:44:06 8942 8192000000 10274935072 10679644160 1344989312 14.102 100 59 115 0 1381903568 23159552 13754704
17:45:19 3952 8192000000 10293986624 10694942720 1353076640 14.175 100 58 114 0 1396904000 29879792 13947568
17:46:33 4183 8192000000 10293154288 10698547200 1356494608 14.206 100 57 114 0 1399252352 28809232 13948512
17:47:44 8445 8192000000 10332069120 10738438144 1382057168 14.435 100 66 132 1 1436563392 37967424 16538800
17:48:57 2447 8192000000 10345661712 10752167936 1392907088 14.532 100 77 154 4 1449794208 37698624 19188496
17:50:04 3539 8192000000 10342374576 10752208896 1392954336 14.532 100 68 136 1 1448587232 37815136 17817760
17:51:14 2885 8192000000 10358279712 10773295104 1404416800 14.634 100 62 124 0 1464086448 43285392 16384256
17:52:21 5110 8192000000 10369117216 10782793728 1417985360 14.755 100 60 115 0 1470337744 37620976 14731408
17:53:32 2936 8192000000 10394218512 10803372032 1424491568 14.813 100 77 153 1 1494930880 51085616 19353696
17:54:42 11823 8192000000 10382104496 10808643584 1418431264 14.759 100 39 78 0 1486054448 56494960 11128224
17:56:05 18465 8192000000 10391667200 10816139264 1419060384 14.764 100 54 106 1 1495747984 62509344 14178256
17:57:43 15423 8192000000 10378496112 10816319488 1403003344 14.622 100 31 62 0 1481626944 69126512 9497088
17:59:28 9114 8192000000 10358025456 10803879936 1404492320 14.635 100 35 68 0 1467178976 53177520 9509136
18:01:32 24453 8192000000 10340659120 10797756416 1402112960 14.614 100 20 39 0 1438320624 31389376 4818288
18:03:06 65659 8192000000 10316921104 10777063424 1392301696 14.526 99 16 32 0 1411301280 15508672 3490912
18:05:18 45822 8192000000 10325546288 10767769600 1388609824 14.493 99 39 75 1 1405617120 8077248 8930048
18:07:10 53688 8192000000 10308937712 10758746112 1385013824 14.461 99 31 63 0 1404025296 12225040 6786432
18:09:05 69238 8192000000 10329040368 10774712320 1403626688 14.627 100 12 24 1 1416163376 10181312 2355376
18:11:18 56389 8192000000 10320286720 10769010688 1391986288 14.524 99 28 56 0 1407269792 9272896 6010608
18:13:17 56994 8192000000 10306585568 10762280960 1380220752 14.419 98 26 52 0 1394875936 8663488 5991696
18:15:22 82448 8192000000 10302259200 10745446400 1325552496 13.927 95 16 32 0 1339963584 10945392 3465696
18:17:55 21566 8192000000 10301485088 10747387904 1386145088 14.471 100 42 84 1 1408515376 12657680 9712608
18:19:19 19546 8192000000 10294064496 10741600256 1352621824 14.171 97 46 90 0 1374238176 11464512 10151840
18:20:41 18079 8192000000 10281732768 10738630656 1367586352 14.305 99 14 28 0 1380454864 9684000 3184512
18:22:06 17415 8192000000 10252237008 10695520256 1340944592 14.066 97 28 56 0 1354641712 7367008 6330112
18:23:25 94961 8192000000 10282729936 10737049600 1328747936 13.956 96 21 42 0 1343220672 9438336 5034400
18:26:01 86592 8192000000 10287493632 10751172608 1367582256 14.305 99 24 48 0 1390664032 17163168 5918608
18:28:51 10619 8192000000 10264014368 10715607040 1338430512 14.043 98 28 54 1 1353787696 10159248 5197936
18:30:02 33124 8192000000 10272586176 10722930688 1368409904 14.313 100 22 44 0 1383064560 10063008 4591648
18:31:36 37431 8192000000 10259464832 10721701888 1355436896 14.196 99 16 32 0 1369002320 9796768 3768656
18:33:19 38191 8192000000 10239490720 10686496768 1313017504 13.813 98 12 25 0 1328601392 13125504 2458384
18:34:57 14951 8192000000 10228749312 10660233216 1265778000 13.383 95 48 95 0 1285772064 9505200 10488864
18:36:19 19346 8192000000 10260422256 10704416768 1334951360 14.012 99 40 80 0 1357914336 13847056 9115920
18:37:42 37788 8192000000 10269387120 10721009664 1342320272 14.078 99 24 48 0 1361931600 14093648 5517680
18:39:23 50239 8192000000 10267675296 10716995584 1341292064 14.069 98 13 26 0 1352308288 8325552 2690672
18:41:13 46792 8192000000 10279821360 10734383104 1357738064 14.217 98 18 34 1 1374963408 13302048 3923296
18:43:52 41913 8192000000 10296730448 10737954816 1369400880 14.322 99 22 42 0 1387121920 13318880 4402160
18:45:36 48882 8192000000 10295160976 10739183616 1356354592 14.205 98 37 74 0 1379704128 15559968 7789568
18:47:25 37036 8192000000 10292585216 10744213504 1378894672 14.407 100 26 52 0 1395474512 10823184 5756656
18:49:03 11473 8192000000 10290387536 10732593152 1369538000 14.323 99 44 88 1 1390346416 10500928 10307488
18:50:16 55165 8192000000 10297421920 10768048128 1380167888 14.418 99 10 20 0 1397595728 15143008 2284832
18:52:12 45282 8192000000 10306049872 10763272192 1397419616 14.572 100 14 26 2 1412417536 11444336 3553584
18:54:06 69651 8192000000 10294576160 10763276288 1374551184 14.368 98 10 20 1 1386854240 10225088 2077968
18:56:28 48360 8192000000 10305593152 10763055104 1363574128 14.269 97 30 60 0 1383042224 12501104 6966992
18:58:16 151704 8192000000 10292544384 10757955584 1327358352 13.943 95 9 18 0 1347622016 17993200 2270464
19:01:48 35131 8192000000 10299438528 10763120640 1390265280 14.508 99 23 46 0 1404254912 9324448 4665184
19:03:25 28300 8192000000 10294923632 10757095424 1388911200 14.496 100 22 45 0 1404494160 10628176 4954784
19:05:07 54081 8192000000 10315295472 10773721088 1402892752 14.621 100 10 20 3 1417579344 12613648 2072944
19:07:02 94617 8192000000 10290006448 10756165632 1379808736 14.415 99 16 32 0 1397024464 13867168 3348560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 103 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-03-2024 19:11:41 to 20-03-2024 19:11:43.

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          174221
MON$OLDEST_ACTIVE               174974
MON$OLDEST_SNAPSHOT             174974
MON$NEXT_TRANSACTION            174974
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                       1938272
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Wed Mar 20 19:11:44 2024 
 
Database header page information: 
    Flags            0 
    Generation        91181 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    174221 
    Oldest active        174974 
    Oldest snapshot        174974 
    Next transaction    174975 
    Sequence number        0 
    Next attachment ID    704 
    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.67, total records: 7671560 
    Average version length: 48.17, total versions: 35544, 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: 87496 
    Data pages: 87496, average fill: 70% 
    Primary pages: 87496, secondary pages: 0, swept pages: 43532 
    Empty pages: 2, full pages: 49114 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 582 
    40 - 59% = 5694 
    60 - 79% = 81154 
    80 - 99% = 21 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23266, nodes: 7671560 
    Average node length: 18.85, total dup: 0, max dup: 0 
    Average key length: 15.86, compression ratio: 1.70 
    Average prefix length: 14.13, average data length: 12.87 
    Clustering factor: 1659698, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 313 
        20 - 39% = 2333 
        40 - 59% = 3833 
        60 - 79% = 2441 
        80 - 99% = 14346 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13524, nodes: 7671560 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.78, average data length: 5.22 
    Clustering factor: 1482928, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1915 
        40 - 59% = 1800 
        60 - 79% = 1148 
        80 - 99% = 8661 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8361, nodes: 7671560 
    Average node length: 6.60, total dup: 5762609, max dup: 49 
    Average key length: 3.61, compression ratio: 2.49 
    Average prefix length: 7.64, average data length: 1.36 
    Clustering factor: 1475982, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 140 
        20 - 39% = 1182 
        40 - 59% = 1256 
        60 - 79% = 978 
        80 - 99% = 4805 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.93, total records: 2199965 
    Average version length: 34.72, total versions: 37555, max versions: 3 
    Average fragment length: 8.00, total fragments: 2, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28600 
    Data pages: 28600, average fill: 71% 
    Primary pages: 28593, secondary pages: 7, swept pages: 18436 
    Empty pages: 6, full pages: 16262 
    Fill distribution: 
     0 - 19% = 54 
    20 - 39% = 286 
    40 - 59% = 3043 
    60 - 79% = 24957 
    80 - 99% = 260 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4541, nodes: 2199965 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 662984, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1020 
        40 - 59% = 787 
        60 - 79% = 774 
        80 - 99% = 1960 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2503, nodes: 2201637 
    Average node length: 4.97, total dup: 2200738, max dup: 20547 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1233793, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 300 
        40 - 59% = 1529 
        60 - 79% = 496 
        80 - 99% = 176 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2069, nodes: 2199965 
    Average node length: 4.97, total dup: 2199915, max dup: 130294 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1050119, ratio: 0.48 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 270 
        40 - 59% = 932 
        60 - 79% = 58 
        80 - 99% = 802 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4353, nodes: 2199965 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.06 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 662984, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 109 
        20 - 39% = 685 
        40 - 59% = 600 
        60 - 79% = 860 
        80 - 99% = 2099 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.67, total records: 400 
    Average version length: 22.81, total versions: 236822, max versions: 622 
    Average fragment length: 2.00, total fragments: 35, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1296 
    Data pages: 1296, average fill: 90% 
    Primary pages: 8, secondary pages: 1288, swept pages: 0 
    Empty pages: 1, full pages: 1294 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 1291 
 
    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: 20.83, total records: 69104 
    Average version length: 68.28, total versions: 48029, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.22 
    Pointer pages: 8, data page slots: 1920 
    Data pages: 1184, average fill: 71% 
    Primary pages: 1183, secondary pages: 1, swept pages: 18 
    Empty pages: 69, full pages: 770 
    Fill distribution: 
     0 - 19% = 111 
    20 - 39% = 77 
    40 - 59% = 108 
    60 - 79% = 258 
    80 - 99% = 630 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1702454, depth: 3, leaf buckets: 222, nodes: 69104 
    Average node length: 12.82, total dup: 4835, max dup: 2 
    Average key length: 10.70, compression ratio: 2.52 
    Average prefix length: 19.23, average data length: 7.77 
    Clustering factor: 50521, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 72 
        40 - 59% = 109 
        60 - 79% = 30 
        80 - 99% = 10 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.20, total records: 49 
    Average version length: 9.00, total versions: 18313, max versions: 1004 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 82% 
    Primary pages: 8, secondary pages: 64, swept pages: 0 
    Empty pages: 7, full pages: 64 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 60 
 
    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: 4.53, total records: 1168 
    Average version length: 43.25, total versions: 1051, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 12.80 
    Pointer pages: 1, data page slots: 32 
    Data pages: 29, average fill: 39% 
    Primary pages: 28, secondary pages: 1, swept pages: 6 
    Empty pages: 12, full pages: 8 
    Fill distribution: 
     0 - 19% = 13 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 8 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93730, depth: 2, leaf buckets: 3, nodes: 1168 
    Average node length: 4.48, total dup: 1071, max dup: 127 
    Average key length: 2.90, compression ratio: 6.54 
    Average prefix length: 18.18, average data length: 0.82 
    Clustering factor: 613, ratio: 0.52 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.08, total records: 75 
    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: 52% 
    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: 75 
    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.90, total records: 813800 
    Average version length: 25.91, total versions: 36644, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.46 
    Pointer pages: 6, data page slots: 8624 
    Data pages: 8616, average fill: 65% 
    Primary pages: 8578, secondary pages: 38, swept pages: 4263 
    Empty pages: 160, full pages: 4721 
    Fill distribution: 
     0 - 19% = 344 
    20 - 39% = 209 
    40 - 59% = 557 
    60 - 79% = 7382 
    80 - 99% = 124 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 930, nodes: 813800 
    Average node length: 4.87, total dup: 813751, max dup: 160844 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 88493, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 166 
        40 - 59% = 532 
        60 - 79% = 185 
        80 - 99% = 45 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1074, nodes: 813800 
    Average node length: 5.88, total dup: 724589, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 160350, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 127 
        40 - 59% = 654 
        60 - 79% = 93 
        80 - 99% = 196 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1112, nodes: 813800 
    Average node length: 5.88, total dup: 724589, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 162375, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 243 
        40 - 59% = 594 
        60 - 79% = 76 
        80 - 99% = 199 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1177, nodes: 813800 
    Average node length: 5.96, total dup: 724589, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154704, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 245 
        40 - 59% = 667 
        60 - 79% = 201 
        80 - 99% = 64 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.79, total records: 5433 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.65, total fragments: 86, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 75, secondary pages: 21, swept pages: 60 
    Empty pages: 12, full pages: 64 
    Fill distribution: 
     0 - 19% = 26 
    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: 5433 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.59, compression ratio: 10.01 
    Average prefix length: 34.36, average data length: 1.55 
    Clustering factor: 5137, 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: 5433 
    Average node length: 11.14, 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: 144, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.10, total records: 80179 
    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: 784 
    Data pages: 784, average fill: 70% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 10, full pages: 772 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 772 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 33812, depth: 2, leaf buckets: 104, nodes: 80179 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 2995, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 0 
        80 - 99% = 100 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 133.30, total records: 176846 
    Average version length: 154.03, total versions: 20421, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.72 
    Pointer pages: 7, data page slots: 5080 
    Data pages: 4280, average fill: 86% 
    Primary pages: 4280, secondary pages: 0, swept pages: 1 
    Empty pages: 71, full pages: 4176 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 10 
    40 - 59% = 12 
    60 - 79% = 8 
    80 - 99% = 4176 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 148.80, total records: 177686 
    Average version length: 148.65, total versions: 2727, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.40 
    Pointer pages: 7, data page slots: 5496 
    Data pages: 4296, average fill: 85% 
    Primary pages: 4295, secondary pages: 1, swept pages: 9 
    Empty pages: 64, full pages: 4198 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 7 
    40 - 59% = 9 
    60 - 79% = 8 
    80 - 99% = 4199 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 141.65, total records: 178375 
    Average version length: 153.49, total versions: 11155, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.97 
    Pointer pages: 7, data page slots: 5000 
    Data pages: 4312, average fill: 86% 
    Primary pages: 4311, secondary pages: 1, swept pages: 1 
    Empty pages: 70, full pages: 4218 
    Fill distribution: 
     0 - 19% = 71 
    20 - 39% = 6 
    40 - 59% = 10 
    60 - 79% = 7 
    80 - 99% = 4218 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 142.18, total records: 171841 
    Average version length: 152.50, total versions: 10162, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.93 
    Pointer pages: 8, data page slots: 7848 
    Data pages: 4200, average fill: 85% 
    Primary pages: 4200, secondary pages: 0, swept pages: 2 
    Empty pages: 86, full pages: 4032 
    Fill distribution: 
     0 - 19% = 88 
    20 - 39% = 13 
    40 - 59% = 49 
    60 - 79% = 19 
    80 - 99% = 4031 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 143.52, total records: 149710 
    Average version length: 151.99, total versions: 7129, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.82 
    Pointer pages: 7, data page slots: 5192 
    Data pages: 3648, average fill: 85% 
    Primary pages: 3647, secondary pages: 1, swept pages: 2 
    Empty pages: 92, full pages: 3527 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 8 
    40 - 59% = 10 
    60 - 79% = 8 
    80 - 99% = 3528 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 134.84, total records: 189739 
    Average version length: 154.27, total versions: 20058, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.58 
    Pointer pages: 7, data page slots: 5392 
    Data pages: 4608, average fill: 86% 
    Primary pages: 4607, secondary pages: 1, swept pages: 2 
    Empty pages: 90, full pages: 4485 
    Fill distribution: 
     0 - 19% = 95 
    20 - 39% = 12 
    40 - 59% = 6 
    60 - 79% = 9 
    80 - 99% = 4486 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 132.82, total records: 186800 
    Average version length: 153.61, total versions: 22468, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.77 
    Pointer pages: 7, data page slots: 5608 
    Data pages: 4528, average fill: 86% 
    Primary pages: 4528, secondary pages: 0, swept pages: 3 
    Empty pages: 82, full pages: 4423 
    Fill distribution: 
     0 - 19% = 84 
    20 - 39% = 11 
    40 - 59% = 5 
    60 - 79% = 7 
    80 - 99% = 4421 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 136.26, total records: 191522 
    Average version length: 154.05, total versions: 18856, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.45 
    Pointer pages: 7, data page slots: 5160 
    Data pages: 4616, average fill: 86% 
    Primary pages: 4615, secondary pages: 1, swept pages: 4 
    Empty pages: 56, full pages: 4543 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 4 
    80 - 99% = 4541 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 131.25, total records: 186625 
    Average version length: 153.92, total versions: 24417, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.92 
    Pointer pages: 6, data page slots: 6464 
    Data pages: 4504, average fill: 87% 
    Primary pages: 4504, secondary pages: 0, swept pages: 5 
    Empty pages: 63, full pages: 4421 
    Fill distribution: 
     0 - 19% = 67 
    20 - 39% = 5 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 4420 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 143.77, total records: 168326 
    Average version length: 152.21, total versions: 8050, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.80 
    Pointer pages: 7, data page slots: 5640 
    Data pages: 4080, average fill: 85% 
    Primary pages: 4080, secondary pages: 0, swept pages: 2 
    Empty pages: 73, full pages: 3970 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 12 
    40 - 59% = 12 
    60 - 79% = 10 
    80 - 99% = 3971 
 
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.34, total records: 2056090 
    Average version length: 52.99, total versions: 15718, 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: 25632 
    Data pages: 25616, average fill: 69% 
    Primary pages: 25616, secondary pages: 0, swept pages: 13485 
    Empty pages: 410, full pages: 18749 
    Fill distribution: 
     0 - 19% = 808 
    20 - 39% = 649 
    40 - 59% = 1569 
    60 - 79% = 22468 
    80 - 99% = 122 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2584, nodes: 2056090 
    Average node length: 5.45, total dup: 1916892, max dup: 1416 
    Average key length: 2.49, compression ratio: 3.61 
    Average prefix length: 8.57, average data length: 0.43 
    Clustering factor: 178968, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 356 
        40 - 59% = 1685 
        60 - 79% = 279 
        80 - 99% = 264 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2756, nodes: 2056090 
    Average node length: 5.70, total dup: 1844772, max dup: 62 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 368258, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 8 
        40 - 59% = 2521 
        60 - 79% = 205 
        80 - 99% = 22 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2065, nodes: 2056090 
    Average node length: 4.96, total dup: 2055990, max dup: 27018 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177011, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 178 
        40 - 59% = 1076 
        60 - 79% = 380 
        80 - 99% = 430 
 
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: 49.52, total records: 119922 
    Average version length: 69.16, total versions: 34145, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.54 
    Pointer pages: 3, data page slots: 4440 
    Data pages: 3096, average fill: 45% 
    Primary pages: 3096, secondary pages: 0, swept pages: 700 
    Empty pages: 563, full pages: 692 
    Fill distribution: 
     0 - 19% = 796 
    20 - 39% = 440 
    40 - 59% = 754 
    60 - 79% = 682 
    80 - 99% = 424 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 1557999, depth: 3, leaf buckets: 220, nodes: 119922 
    Average node length: 6.50, total dup: 104398, max dup: 14 
    Average key length: 3.98, compression ratio: 10.56 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 20489, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 79 
        40 - 59% = 120 
        60 - 79% = 20 
        80 - 99% = 1 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 67.24, total records: 7059257 
    Average version length: 68.78, total versions: 175754, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 65, data page slots: 105728 
    Data pages: 105728, average fill: 71% 
    Primary pages: 105728, secondary pages: 0, swept pages: 63434 
    Empty pages: 73, full pages: 63022 
    Fill distribution: 
     0 - 19% = 889 
    20 - 39% = 2221 
    40 - 59% = 7495 
    60 - 79% = 93293 
    80 - 99% = 1830 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10722, nodes: 7059257 
    Average node length: 6.51, total dup: 6107049, max dup: 29 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1572007, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1792 
        40 - 59% = 5662 
        60 - 79% = 2809 
        80 - 99% = 453 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8807, nodes: 7059257 
    Average node length: 5.40, total dup: 6779073, max dup: 145 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1367159, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1242 
        40 - 59% = 5359 
        60 - 79% = 1362 
        80 - 99% = 838 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8878, nodes: 7059257 
    Average node length: 5.40, total dup: 6779073, max dup: 145 
    Average key length: 2.41, compression ratio: 7.07 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1369719, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1285 
        40 - 59% = 5407 
        60 - 79% = 1405 
        80 - 99% = 773 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 68.18, total records: 12027067 
    Average version length: 68.75, total versions: 135104, 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: 105, data page slots: 169904 
    Data pages: 169904, average fill: 75% 
    Primary pages: 169904, secondary pages: 0, swept pages: 115453 
    Empty pages: 6, full pages: 136251 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 273 
    40 - 59% = 4454 
    60 - 79% = 162958 
    80 - 99% = 2207 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18459, nodes: 12027067 
    Average node length: 6.59, total dup: 10487407, max dup: 66 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2366443, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 17 
        20 - 39% = 2476 
        40 - 59% = 10722 
        60 - 79% = 4588 
        80 - 99% = 656 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 54.04, total records: 1311707 
    Average version length: 69.09, total versions: 286620, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.33 
    Pointer pages: 32, data page slots: 49672 
    Data pages: 27679, average fill: 53% 
    Primary pages: 27678, secondary pages: 1, swept pages: 14514 
    Empty pages: 4473, full pages: 13026 
    Fill distribution: 
     0 - 19% = 6700 
    20 - 39% = 2819 
    40 - 59% = 2769 
    60 - 79% = 11086 
    80 - 99% = 4305 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2173, nodes: 1311707 
    Average node length: 5.54, total dup: 1258433, max dup: 95 
    Average key length: 2.58, compression ratio: 16.29 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 87803, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1085 
        40 - 59% = 889 
        60 - 79% = 177 
        80 - 99% = 14 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 54.41, total records: 819407 
    Average version length: 69.14, total versions: 173441, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.32 
    Pointer pages: 26, data page slots: 40744 
    Data pages: 29456, average fill: 32% 
    Primary pages: 29456, secondary pages: 0, swept pages: 14680 
    Empty pages: 8096, full pages: 3072 
    Fill distribution: 
     0 - 19% = 12717 
    20 - 39% = 4634 
    40 - 59% = 5841 
    60 - 79% = 4744 
    80 - 99% = 1520 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1454, nodes: 819407 
    Average node length: 5.86, total dup: 760582, max dup: 97 
    Average key length: 2.94, compression ratio: 14.28 
    Average prefix length: 41.13, average data length: 0.87 
    Clustering factor: 116795, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 777 
        40 - 59% = 568 
        60 - 79% = 99 
        80 - 99% = 9 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.69, total records: 8733002 
    Average version length: 68.99, total versions: 151441, 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: 91, data page slots: 147936 
    Data pages: 147896, average fill: 63% 
    Primary pages: 147896, secondary pages: 0, swept pages: 109279 
    Empty pages: 849, full pages: 55983 
    Fill distribution: 
     0 - 19% = 2744 
    20 - 39% = 13583 
    40 - 59% = 33135 
    60 - 79% = 96802 
    80 - 99% = 1632 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13484, nodes: 8733002 
    Average node length: 6.71, total dup: 7241891, max dup: 17 
    Average key length: 3.68, compression ratio: 11.43 
    Average prefix length: 40.49, average data length: 1.51 
    Clustering factor: 1851694, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1907 
        40 - 59% = 7210 
        60 - 79% = 3878 
        80 - 99% = 486 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21142684 
    Average version length: 82.92, total versions: 5675, 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: 318856 
    Data pages: 318856, average fill: 81% 
    Primary pages: 318856, secondary pages: 0, swept pages: 14100 
    Empty pages: 67, full pages: 317485 
    Fill distribution: 
     0 - 19% = 107 
    20 - 39% = 65 
    40 - 59% = 190 
    60 - 79% = 28231 
    80 - 99% = 290263 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19725, nodes: 21142684 
    Average node length: 5.72, total dup: 20661931, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3280604, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8845 
        60 - 79% = 524 
        80 - 99% = 10350 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17175, nodes: 21142684 
    Average node length: 6.31, total dup: 18580043, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915242, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 2 
        40 - 59% = 778 
        60 - 79% = 300 
        80 - 99% = 16093 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21510, nodes: 21142684 
    Average node length: 6.35, total dup: 18498911, max dup: 27 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3574888, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 9089 
        60 - 79% = 619 
        80 - 99% = 11799 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16089, nodes: 21142684 
    Average node length: 5.56, total dup: 21142584, max dup: 227401 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 943949, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 15 
        40 - 59% = 2818 
        60 - 79% = 449 
        80 - 99% = 12806 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 74.14, total records: 10042883 
    Average version length: 82.64, total versions: 1006179, 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: 176264 
    Data pages: 176240, average fill: 71% 
    Primary pages: 176240, secondary pages: 0, swept pages: 46654 
    Empty pages: 787, full pages: 113354 
    Fill distribution: 
     0 - 19% = 2204 
    20 - 39% = 9251 
    40 - 59% = 28942 
    60 - 79% = 47660 
    80 - 99% = 88183 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11383, nodes: 10042883 
    Average node length: 5.39, total dup: 9734043, max dup: 267 
    Average key length: 2.22, compression ratio: 4.05 
    Average prefix length: 8.81, average data length: 0.19 
    Clustering factor: 2173086, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 73 
        40 - 59% = 6748 
        60 - 79% = 4457 
        80 - 99% = 104 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13856, nodes: 10042883 
    Average node length: 6.26, total dup: 8329125, max dup: 14 
    Average key length: 3.10, compression ratio: 2.91 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1494616, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 153 
        20 - 39% = 3613 
        40 - 59% = 4862 
        60 - 79% = 2561 
        80 - 99% = 2667 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12694, nodes: 10042883 
    Average node length: 6.00, total dup: 8740816, max dup: 59 
    Average key length: 2.83, compression ratio: 3.18 
    Average prefix length: 8.30, average data length: 0.70 
    Clustering factor: 2382138, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 72 
        40 - 59% = 7791 
        60 - 79% = 4695 
        80 - 99% = 132 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10352, nodes: 10042883 
    Average node length: 5.17, total dup: 10042783, max dup: 161307 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1555173, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1101 
        40 - 59% = 5226 
        60 - 79% = 1626 
        80 - 99% = 2361 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 81.51, total records: 10925396 
    Average version length: 82.68, total versions: 103486, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 120, data page slots: 195344 
    Data pages: 193328, average fill: 69% 
    Primary pages: 193328, secondary pages: 0, swept pages: 93314 
    Empty pages: 4407, full pages: 127787 
    Fill distribution: 
     0 - 19% = 7951 
    20 - 39% = 11864 
    40 - 59% = 24171 
    60 - 79% = 46770 
    80 - 99% = 102572 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13113, nodes: 10925396 
    Average node length: 5.31, total dup: 10816799, max dup: 614 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2276466, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 176 
        40 - 59% = 10128 
        60 - 79% = 2737 
        80 - 99% = 71 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10260, nodes: 10925396 
    Average node length: 5.50, total dup: 10447376, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 689020, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 159 
        20 - 39% = 936 
        40 - 59% = 2562 
        60 - 79% = 1849 
        80 - 99% = 4754 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 14996, nodes: 10925396 
    Average node length: 6.04, total dup: 9523796, max dup: 58 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2292796, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 208 
        40 - 59% = 11710 
        60 - 79% = 2986 
        80 - 99% = 88 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10510, nodes: 10925396 
    Average node length: 5.23, total dup: 10925296, max dup: 197418 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.43, average data length: 0.00 
    Clustering factor: 678698, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 937 
        40 - 59% = 4628 
        60 - 79% = 1424 
        80 - 99% = 3419 
 
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: 74.56, total records: 10153573 
    Average version length: 82.95, total versions: 1002716, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.69 
    Pointer pages: 111, data page slots: 180760 
    Data pages: 180728, average fill: 70% 
    Primary pages: 180728, secondary pages: 0, swept pages: 49469 
    Empty pages: 784, full pages: 111172 
    Fill distribution: 
     0 - 19% = 2271 
    20 - 39% = 10235 
    40 - 59% = 32381 
    60 - 79% = 50131 
    80 - 99% = 85710 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 12090, nodes: 10153573 
    Average node length: 5.22, total dup: 10124252, max dup: 1776 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2015976, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1352 
        40 - 59% = 7870 
        60 - 79% = 2159 
        80 - 99% = 677 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13971, nodes: 10153573 
    Average node length: 6.28, total dup: 8419914, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1454050, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 193 
        20 - 39% = 3565 
        40 - 59% = 4827 
        60 - 79% = 2554 
        80 - 99% = 2832 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12688, nodes: 10153573 
    Average node length: 5.47, total dup: 9708576, max dup: 120 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2151020, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 1238 
        40 - 59% = 8843 
        60 - 79% = 1950 
        80 - 99% = 627 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10449, nodes: 10153573 
    Average node length: 5.19, total dup: 10153473, max dup: 162830 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1571343, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 34 
        20 - 39% = 1056 
        40 - 59% = 5351 
        60 - 79% = 1639 
        80 - 99% = 2369 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 66.47, total records: 583884 
    Average version length: 68.79, total versions: 14588, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.90 
    Pointer pages: 5, data page slots: 8088 
    Data pages: 8088, average fill: 76% 
    Primary pages: 8088, secondary pages: 0, swept pages: 2714 
    Empty pages: 7, full pages: 7136 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 37 
    40 - 59% = 260 
    60 - 79% = 7479 
    80 - 99% = 303 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 39082, depth: 3, leaf buckets: 748, nodes: 583884 
    Average node length: 5.95, total dup: 497258, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 101275, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 29 
        40 - 59% = 535 
        60 - 79% = 97 
        80 - 99% = 87 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31644, depth: 3, leaf buckets: 771, nodes: 583884 
    Average node length: 6.15, total dup: 478890, max dup: 29 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101330, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 25 
        40 - 59% = 552 
        60 - 79% = 99 
        80 - 99% = 95 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 574, nodes: 583884 
    Average node length: 4.86, total dup: 583784, max dup: 9774 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89982, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 348 
        60 - 79% = 87 
        80 - 99% = 119 
 
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 Wed Mar 20 19:12:08 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7671560 35544 1 0.0000 0.0000
DOC_LIST 2199965 37555 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 236822 622 59200.0000 0.0000
INVNT_TURNOVER_LOG 69104 48029 1 0.0000 0.0000
MONEY_SALDO 49 18313 1004 37300.0000 0.0000
MONEY_TURNOVER_LOG 1168 1051 1 0.0000 0.0000
PDISTR 813800 36644 4 0.0000 0.0000
PERF_SPLIT_0 176846 20421 1 0.0000 0.0000
PERF_SPLIT_1 177686 2727 1 0.0000 0.0000
PERF_SPLIT_2 178375 11155 1 0.0000 0.0000
PERF_SPLIT_3 171841 10162 1 0.0000 0.0000
PERF_SPLIT_4 149710 7129 1 0.0000 0.0000
PERF_SPLIT_5 189739 20058 1 0.0000 0.0000
PERF_SPLIT_6 186800 22468 1 0.0000 0.0000
PERF_SPLIT_7 191522 18856 1 0.0000 0.0000
PERF_SPLIT_8 186625 24417 1 0.0000 0.0000
PERF_SPLIT_9 168326 8050 1 0.0000 0.0000
PSTORNED 2056090 15718 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 119922 34145 1 0.0000 0.0000
XQD_1000_3300 7059257 175754 1 0.0000 0.0000
XQD_1200_2000 12027067 135104 1 0.0000 0.0000
XQD_2000_3300 1311707 286620 1 0.0000 0.0000
XQD_2100_3300 819407 173441 1 0.0000 0.0000
XQD_3300_3400 8733002 151441 1 0.0000 0.0000
XQS_1000_1200 21142684 5675 1 0.0000 0.0000
XQS_1000_3300 10042883 1006179 1 0.0000 0.0000
XQS_1200_2000 10925396 103486 1 0.0000 0.0000
XQS_2100_3300 10153573 1002716 1 0.0000 0.0000
XQS_3300_3400 583884 14588 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 ---
:19: 
:20: mscs-test-161.budzdorov.ru    Wed Mar 20 19:09:57 2024
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Wed Mar 20 19:09:57 2024
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
:27: 
:28: mscs-test-161.budzdorov.ru    Wed Mar 20 19:09:58 2024
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
--- end of diff output ---

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

20.03.24 19:12:20. 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-20 19:12:22 No severe PSQL-related problems occured
20.03.24 19:12:24. End of report.