Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.03.2024 07:08
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 15465456 kB
MemAvailable 30207740 kB
Buffers 0 kB
Cached 16226688 kB
SwapCached 2456 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 4.0.5
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
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-28 07:07:51
DTS_END                         2024-03-28 07:07:51.5200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/35620
TRN_ID                          173000
ATT_ID                          577
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: 9338.50 22237 933850
customer order: creation 177.24 436 17724
customer order: refuse 15.04 383 1504
order to supplier: creation 46.77 1328 4677
order to supplier: removal 3.73 96027 373
invoice (draft): creation 46.53 3121 4653
invoice (draft): removal 51.22 681 5122
invoice accept: apply 42.18 21326 4218
invoice accept: cancel 46.20 819 4620
customer reserve: creation 4048.60 205 404860
customer reserve: removal 4555.19 63 455519
realization accept: apply 85.22 221 8522
realization accept: cancel 89.53 129 8953
payment from customer: creation 59.84 132 5984
payment from customer: removal 5.98 99 598
payment to supplier: creation 50.23 138 5023
payment to supplier: removal 3.69 89 369
service: total inventory turnovers 4.05 3920 405
service: total monetary turnovers 6.36 566 636
service: aggregate perf. data 0.87 19317 87
service: refresh index statistics 0.03 295734 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-03-2024 07:08:49 to 28-03-2024 07:08:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2407
TEST_TIME 2 4274
TEST_TIME 3 3968
TEST_TIME 4 3891
TEST_TIME 5 3919
TEST_TIME 6 4314
TEST_TIME 7 4304
TEST_TIME 8 4263
TEST_TIME 9 4386
TEST_TIME 10 5073
TEST_TIME 11 5409
TEST_TIME 12 5771
TEST_TIME 13 6070
TEST_TIME 14 6275
TEST_TIME 15 6466
TEST_TIME 16 6608
TEST_TIME 17 6657
TEST_TIME 18 6825
TEST_TIME 19 7083
TEST_TIME 20 7385
TEST_TIME 21 7630
TEST_TIME 22 7645
TEST_TIME 23 8090
TEST_TIME 24 8063
TEST_TIME 25 8020
TEST_TIME 26 8755
TEST_TIME 27 9145
TEST_TIME 28 9516
TEST_TIME 29 9513
TEST_TIME 30 9561
TEST_TIME 31 9551
TEST_TIME 32 9655
TEST_TIME 33 9500
TEST_TIME 34 9412
TEST_TIME 35 9643
TEST_TIME 36 9768
TEST_TIME 37 9642
TEST_TIME 38 9469
TEST_TIME 39 9395
TEST_TIME 40 9370
TEST_TIME 41 9264
TEST_TIME 42 9247
TEST_TIME 43 9214
TEST_TIME 44 9229
TEST_TIME 45 9271
TEST_TIME 46 9309
TEST_TIME 47 9223
TEST_TIME 48 9240
TEST_TIME 49 9101
TEST_TIME 50 9082
TEST_TIME 51 9099
TEST_TIME 52 9151
TEST_TIME 53 9158
TEST_TIME 54 9129
TEST_TIME 55 9115
TEST_TIME 56 9125
TEST_TIME 57 9136
TEST_TIME 58 9244
TEST_TIME 59 9270
TEST_TIME 60 9312
TEST_TIME 61 9378
TEST_TIME 62 9367
TEST_TIME 63 9431
TEST_TIME 64 9459
TEST_TIME 65 9500
TEST_TIME 66 9387
TEST_TIME 67 9333
TEST_TIME 68 9376
TEST_TIME 69 9339
TEST_TIME 70 9278
TEST_TIME 71 9256
TEST_TIME 72 9211
TEST_TIME 73 9167
TEST_TIME 74 9188
TEST_TIME 75 9165
TEST_TIME 76 9226
TEST_TIME 77 9259
TEST_TIME 78 9273
TEST_TIME 79 9404
TEST_TIME 80 9387
TEST_TIME 81 9430
TEST_TIME 82 9434
TEST_TIME 83 9397
TEST_TIME 84 9447
TEST_TIME 85 9434
TEST_TIME 86 9615
TEST_TIME 87 9518
TEST_TIME 88 9425
TEST_TIME 89 9374
TEST_TIME 90 9379
TEST_TIME 91 9320
TEST_TIME 92 9274
TEST_TIME 93 9269
TEST_TIME 94 9245
TEST_TIME 95 9240
TEST_TIME 96 9264
TEST_TIME 97 9231
TEST_TIME 98 9340
TEST_TIME 99 9319
TEST_TIME 100 9345

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-03-2024 07:08:53 to 28-03-2024 07:08:56.

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 1306416 1306416 0 0.00 0 25841 7 0 0
doc_list_biud 1306416 1306416 0 0.00 0 33232 27 0 0
sp_add_invoice_to_stock 4333 4218 115 2.65 52 252292 21327 0 115
sp_cancel_adding_invoice 4620 4620 0 0.00 4 64884 819 0 0
sp_cancel_client_order 1504 1504 0 0.00 3 12737 383 0 0
sp_cancel_customer_reserve 455519 455519 0 0.00 0 29768 64 0 0
sp_cancel_pay_from_customer 598 598 0 0.00 2 8493 99 0 0
sp_cancel_pay_to_supplier 369 369 0 0.00 2 1877 90 0 0
sp_cancel_supplier_invoice 5133 5122 11 0.21 1 33244 681 0 11
sp_cancel_supplier_order 373 373 0 0.00 8 1001568 96028 0 0
sp_cancel_write_off 8953 8953 0 0.00 1 11906 130 0 0
sp_client_order 17724 17724 0 0.00 3 50836 436 0 0
sp_customer_reserve 404860 404860 0 0.00 0 69598 206 0 0
sp_fill_shopping_cart 27046 27046 0 0.00 1 19234 40 0 0
sp_fill_shopping_cart_clo_res 404850 404850 0 0.00 0 15274 17 0 0
sp_get_clo_for_invoice 4206 4206 0 0.00 0 24458 388 0 0
sp_kill_cost_storno 14540 14540 0 0.00 0 7010 70 0 0
sp_kill_qstorno_ret_qs2qd 925486 925486 0 0.00 0 33230 34 0 0
sp_kill_qty_storno 488819 488819 0 0.00 0 33232 72 0 0
sp_lock_selected_doc 17726 17726 0 0.00 0 6771 4 0 0
sp_make_cost_storno 23735 23735 0 0.00 0 15425 69 0 0
sp_multiply_rows_for_pdistr 23735 23735 0 0.00 0 17993 36 0 0
sp_multiply_rows_for_qdistr 17724 17724 0 0.00 0 50827 236 0 0
sp_pay_from_customer 5984 5984 0 0.00 4 15621 132 0 0
sp_pay_to_supplier 5023 5023 0 0.00 4 18027 139 0 0
sp_payment_common 11007 11007 0 0.00 1 7628 21 0 0
sp_qd_handle_on_cancel_clo 1504 1504 0 0.00 0 12724 350 0 0
sp_qd_handle_on_invoice_upd_sts 8826 8826 0 0.00 0 27281 308 0 0
sp_qd_handle_on_reserve_upd_sts 8522 8522 0 0.00 0 26510 69 0 0
sp_reserve_write_off 8522 8522 0 0.00 6 26634 221 0 0
sp_supplier_invoice 4653 4653 0 0.00 5 90724 3121 0 0
sp_supplier_order 4677 4677 0 0.00 5 33398 1328 0 0
srv_aggregate_perf_data 87 87 0 0.00 2229 199781 19317 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1281 114318 39004 0 0
srv_find_qd_qs_mism 891639 891639 0 0.00 0 25838 6 0 0
srv_make_invnt_saldo 405 405 0 0.00 60 87303 3921 0 0
srv_make_money_saldo 636 636 0 0.00 1 10258 567 0 0
srv_recalc_idx_stat 3 3 0 0.00 232868 420235 295735 0 0
t$perf-abend:sp_add_invoice_to_stock 115 115 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4218 4218 0 0.00 0 14968 177 0 0
t$perf-norm:sp_cancel_adding_invoice 372 372 0 0.00 0 9753 139 0 0
t$perf-norm:sp_cancel_client_order 1504 1504 0 0.00 0 6188 16 0 0
t$perf-norm:sp_cancel_customer_reserve 592 592 0 0.00 0 2047 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 598 598 0 0.00 0 1259 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 369 369 0 0.00 0 343 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 327 327 0 0.00 0 754 18 0 0
t$perf-norm:sp_cancel_supplier_order 373 373 0 0.00 0 28379 1603 0 0
t$perf-norm:sp_cancel_write_off 863 863 0 0.00 0 832 5 0 0
t$perf-norm:sp_client_order 17724 17724 0 0.00 0 19801 19 0 0
t$perf-norm:sp_customer_reserve 859 859 0 0.00 0 340 4 0 0
t$perf-norm:sp_pay_from_customer 5984 5984 0 0.00 0 20312 15 0 0
t$perf-norm:sp_pay_to_supplier 5023 5023 0 0.00 0 6934 9 0 0
t$perf-norm:sp_reserve_write_off 8522 8522 0 0.00 0 23237 11 0 0
t$perf-norm:sp_supplier_invoice 4653 4653 0 0.00 0 22697 31 0 0
t$perf-norm:sp_supplier_order 4677 4677 0 0.00 0 11194 18 0 0
t$perf-norm:srv_aggregate_perf_data 87 87 0 0.00 0 273 15 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 611 11 0 0
t$perf-norm:srv_make_invnt_saldo 405 405 0 0.00 0 633 9 0 0
t$perf-norm:srv_make_money_saldo 636 636 0 0.00 0 296 5 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 10 6 0 0
v_add_invoice_to_stock 8642 8412 230 2.66 0 3967 17 0 230
v_all_customers 32680 32680 0 0.00 0 91 1 0 0
v_all_suppliers 26670 26670 0 0.00 0 24 1 0 0
v_all_wares 35446 35446 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 744 744 0 0.00 0 5495 14 0 0
v_cancel_client_order 3008 3008 0 0.00 0 8379 10 0 0
v_cancel_customer_prepayment 1196 1196 0 0.00 0 8487 16 0 0
v_cancel_customer_reserve 1184 1184 0 0.00 0 2393 8 0 0
v_cancel_payment_to_supplier 738 738 0 0.00 0 699 7 0 0
v_cancel_supplier_invoice 676 654 22 3.25 0 1376 16 0 22
v_cancel_supplier_order 746 746 0 0.00 0 582 4 0 0
v_cancel_write_off 1726 1726 0 0.00 0 321 12 0 0
v_max_id_clo_ord 4677 4677 0 0.00 0 937 1 0 0
v_max_id_clo_res 859 859 0 0.00 0 7559 28 0 0
v_max_id_ord_sup 4646 4646 0 0.00 0 7045 4 0 0
v_max_non_paid_invoice 1011 1011 0 0.00 0 172 2 0 0
v_max_non_paid_realizn 2907 2907 0 0.00 0 2055 4 0 0
v_min_id_clo_ord 4677 4677 0 0.00 0 2994 7 0 0
v_min_id_clo_res 859 859 0 0.00 0 4047 8 0 0
v_min_id_ord_sup 4646 4646 0 0.00 0 4480 8 0 0
v_min_non_paid_invoice 5023 5023 0 0.00 0 7625 13 0 0
v_min_non_paid_realizn 5984 5984 0 0.00 0 7131 18 0 0
v_our_firm 8920 8920 0 0.00 0 145 1 0 0
v_reserve_write_off 17044 17044 0 0.00 0 12781 7 0 0
x_lock_depdocs_on_canc_invoice 9415 9415 0 0.00 0 11671 125 0 0
x_lock_depdocs_on_canc_sup_ord 373 373 0 0.00 0 10707 358 0 0
x_make_qstorno_1000_1200 4677 4677 0 0.00 1 33392 1245 0 0
x_make_qstorno_1200_2000 4653 4653 0 0.00 2 88558 2974 0 0
x_make_qstorno_2100_3300 404860 404860 0 0.00 0 69594 186 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-03-2024 07:08:57 to 28-03-2024 07:09:01.

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
05:07:55 1104 8192000000 8944590656 9006309376 17001040 0.207 4 2 4 0 17414240 156336 256864
05:08:58 35748 8192000000 9716739248 10015875072 785962320 8.754 100 86 172 0 814932240 7681392 21288528
05:10:36 22212 8192000000 9755318304 10061926400 826419216 9.163 100 93 186 0 859915840 11889488 21607136
05:12:23 14276 8192000000 9792131856 10109923328 856330976 9.463 100 82 164 1 897846992 23056928 18459088
05:13:41 10063 8192000000 9842395680 10168610816 889886864 9.798 100 83 166 0 949463168 41733616 17842688
05:15:01 6316 8192000000 9906529872 10249953280 937341504 10.267 100 74 148 1 1015321552 62286096 15693952
05:16:10 3714 8192000000 9945672256 10298363904 976531984 10.650 100 90 179 1 1055059792 60969552 17558256
05:17:15 2603 8192000000 9978419392 10340761600 1009636144 10.972 100 83 163 1 1090188400 64699248 15853008
05:18:19 3317 8192000000 10007470496 10379091968 1029142176 11.160 100 79 156 2 1125189888 81612272 14435440
05:19:25 1605 8192000000 10026721696 10398531584 1052867952 11.388 100 89 180 0 1142997840 71511664 18618224
05:20:29 5678 8192000000 9984325840 10368110592 1056054944 11.419 100 65 129 1 1098539136 29628256 12855936
05:21:36 5053 8192000000 10021907504 10417168384 1062956160 11.485 100 46 92 0 1151307920 79714336 8637424
05:22:44 5347 8192000000 10008267664 10404274176 1071546960 11.567 100 33 66 1 1129374992 51327376 6500656
05:23:50 7580 8192000000 9989828016 10386087936 1079768816 11.645 100 40 80 0 1113950240 26643152 7538272
05:24:59 42504 8192000000 9996603872 10394697728 1083439056 11.680 100 56 109 2 1107659360 12422864 11797440
05:26:44 4540 8192000000 10014555280 10420768768 1087887632 11.723 100 33 64 0 1126164352 32197824 6078896
05:27:51 7806 8192000000 10005354080 10408013824 1084646944 11.692 100 43 85 1 1109165104 15337264 9180896
05:29:06 12446 8192000000 10053415872 10451816448 1100458944 11.842 100 62 124 0 1158450048 45806816 12184288
05:30:22 59887 8192000000 10041064272 10444513280 1068129200 11.534 97 46 91 0 1128392640 51115296 9148144
05:32:32 16077 8192000000 10075471312 10485940224 1102016144 11.857 100 41 80 0 1196558304 86355184 8186976
05:33:59 40598 8192000000 10091173792 10502406144 1109665168 11.929 100 37 72 1 1193763920 76701776 7396976
05:35:47 15880 8192000000 10131345872 10536714240 1088960272 11.733 97 46 90 1 1212349568 113217184 10172112
05:37:11 15313 8192000000 10162492528 10571259904 1111123520 11.943 100 41 82 0 1268602656 148138624 9340512
05:38:33 19741 8192000000 10119381904 10516344832 1066031936 11.514 97 43 86 0 1208766720 134063120 8671664
05:39:58 2967 8192000000 10066127696 10452135936 1037053168 11.236 97 54 107 1 1160838896 112257184 11528544
05:41:06 2653 8192000000 10128833344 10506326016 1076272640 11.612 100 81 162 0 1227934480 134716688 16945152
05:42:15 5297 8192000000 10166873696 10572693504 1093490432 11.776 100 68 132 2 1273483808 165374160 14619216
05:43:27 2402 8192000000 10190372304 10578362368 1099003104 11.828 100 65 130 0 1288553520 175835152 13715264
05:44:34 3557 8192000000 10281582832 10669543424 1116219824 11.991 100 74 144 1 1380288032 248096736 15971472
05:45:43 2166 8192000000 10280440304 10674728960 1120665744 12.033 100 83 164 1 1381349280 241971776 18711760
05:46:57 3025 8192000000 10302902352 10707439616 1129614720 12.118 100 71 142 0 1395908816 250376144 15917952
05:48:04 8182 8192000000 10326141632 10735280128 1135940112 12.177 100 58 116 0 1425762928 276178272 13644544
05:49:23 11931 8192000000 10342464784 10764447744 1135227904 12.171 100 37 74 0 1447133200 302658352 9246944
05:51:04 30856 8192000000 10302052080 10752081920 1129293696 12.115 100 28 56 0 1404013936 267802992 6917248
05:53:00 22010 8192000000 10271740608 10772520960 1117148832 12.000 99 24 48 0 1379782944 256544144 6089968
05:54:26 26085 8192000000 10158336512 10674294784 1109586256 11.929 100 12 24 0 1303213248 190744064 2882928
05:55:53 36244 8192000000 10096001392 10586558464 1099310176 11.831 98 13 26 0 1191850400 90077712 2462512
05:58:33 11405 8192000000 10118093184 10552352768 1128614480 12.108 100 41 82 0 1187964832 51225168 8125184
05:59:58 60203 8192000000 10075474448 10503663616 1124577056 12.070 100 14 28 0 1156737392 29342512 2817824
06:02:06 94409 8192000000 10082092240 10563297280 1148860096 12.299 100 19 37 0 1220509056 67902880 3746080
06:05:01 78009 8192000000 10104281200 10544648192 1140666672 12.222 100 39 75 2 1173514528 24912784 7935072
06:07:28 15344 8192000000 10112726944 10545950720 1150281936 12.312 100 52 104 0 1206418240 45457312 10678992
06:08:48 34581 8192000000 10080413152 10533634048 1141389088 12.229 99 18 36 0 1176021840 31209616 3423136
06:10:23 1279 8192000000 10111024928 10536308736 1153637712 12.344 100 76 149 2 1202114096 33316320 15160064
06:11:30 36182 8192000000 10139708768 10647003136 1162637376 12.428 100 42 80 0 1287639616 116302576 8699664
06:13:12 14736 8192000000 10083730304 10548711424 1162565344 12.427 100 12 23 0 1198009552 33759168 1685040
06:14:38 79973 8192000000 10115644032 10598256640 1142631344 12.240 98 22 44 0 1197888096 50708016 4548736
06:17:35 77243 8192000000 10114092032 10619146240 1127638336 12.099 98 22 44 0 1251378192 118596208 5143648
06:19:54 24184 8192000000 10076212576 10525319168 1112929728 11.960 98 36 72 1 1158507424 38084160 7493536
06:21:19 45647 8192000000 10072328160 10544451584 1130954752 12.130 100 10 20 0 1175003424 42622544 1426128
06:23:05 35051 8192000000 10072716688 10512310272 1081271104 11.660 95 43 86 1 1156661808 66317936 9072768
06:24:41 46705 8192000000 10086285024 10587697152 1076290304 11.612 96 24 48 0 1181426224 99816000 5319920
06:26:28 48706 8192000000 10089563728 10533122048 1072558928 11.577 97 31 62 0 1135029632 56446512 6024192
06:28:41 108123 8192000000 10025153600 10496933888 1013641808 11.011 92 17 32 0 1071501488 54720576 3139104
06:31:35 43911 8192000000 10095914800 10530492416 1073584560 11.586 98 50 98 0 1142096240 59504304 9007376
06:33:20 104897 8192000000 10020315344 10494230528 1051968240 11.380 97 34 68 2 1086183824 26370528 7845056
06:37:09 30788 8192000000 10030605904 10471821312 1085814736 11.703 99 10 20 0 1137107600 49309216 1983648
06:38:42 46033 8192000000 10050221040 10515476480 1104914880 11.884 100 6 12 0 1155271456 49047408 1309168
06:40:28 60063 8192000000 10039892992 10520989696 1095970416 11.799 99 10 20 0 1168217152 70593104 1653632
06:42:29 73174 8192000000 10080835136 10523889664 1117835552 12.007 100 21 42 0 1166651296 44910448 3905296
06:44:48 44246 8192000000 10127727376 10563751936 1136065008 12.178 100 29 58 0 1237122672 94730528 6327136
06:46:43 79912 8192000000 10070521520 10523328512 1106348000 11.898 98 23 43 1 1138031488 27425328 4258160
06:49:04 70142 8192000000 10070010576 10524446720 1123200976 12.057 99 27 54 0 1174283744 46126192 4956576
06:51:14 35191 8192000000 10094513536 10543742976 1137371328 12.191 100 40 80 0 1211738624 66835664 7531632
06:52:53 114318 8192000000 10092770832 10609807360 1153559616 12.343 100 18 36 0 1208364064 51381008 3423440
06:55:49 17342 8192000000 10082933104 10515013632 1139858752 12.214 98 50 98 1 1164049488 14426544 9764192
06:57:06 49596 8192000000 10096277104 10586787840 1153927184 12.346 100 9 18 0 1215724384 60092976 1704224
06:59:12 73855 8192000000 10072226176 10566012928 1148269152 12.293 100 9 18 0 1190493968 40447728 1777088
07:01:33 57056 8192000000 10111580256 10571837440 1121804144 12.044 97 24 49 0 1165719760 38927536 4988080
07:03:41 66879 8192000000 10140520544 10605240320 1131089904 12.132 98 12 24 0 1226615744 92787872 2737968
07:06:00 15066 8192000000 10079657024 10508578816 1144872640 12.261 100 46 89 1 1169885136 16556112 8456384
07:07:15 44761 8192000000 9330755184 9682624512 445512448 5.157 39 7 12 0 469686256 22932672 1241136

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 28-03-2024 07:09:03 to 28-03-2024 07:09:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 115 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-03-2024 07:09:18 to 28-03-2024 07:09:20.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          173603
MON$OLDEST_ACTIVE               173604
MON$OLDEST_SNAPSHOT             173604
MON$NEXT_TRANSACTION            173604
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-30 07:30:08.6030 GMT
MON$PAGES                       1934432
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             685
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.5.3082 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.5.3082 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.5.3082 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.5.3082 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Thu Mar 28 07:09:21 2024 
 
Database header page information: 
    Flags            0 
    Generation        90921 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    173603 
    Oldest active        173604 
    Oldest snapshot        173604 
    Next transaction    173605 
    Sequence number        0 
    Next attachment ID    685 
    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 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    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: 1504333, 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: 1504335, 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: 1504334, 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: 1504332, 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: 1504331, 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: 532, Index root page: 533 
    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: 1504264, 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: 1504266, 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: 1504265, 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: 1504263, 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: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.22, total records: 7760398 
    Average version length: 48.16, total versions: 134076, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.36 
    Pointer pages: 55, data page slots: 88912 
    Data pages: 88912, average fill: 70% 
    Primary pages: 88911, secondary pages: 1, swept pages: 32122 
    Empty pages: 7, full pages: 73737 
    Fill distribution: 
     0 - 19% = 16 
    20 - 39% = 55 
    40 - 59% = 1012 
    60 - 79% = 87762 
    80 - 99% = 67 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23210, nodes: 7760398 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.10, average data length: 12.90 
    Clustering factor: 1694946, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 316 
        20 - 39% = 1615 
        40 - 59% = 4232 
        60 - 79% = 2440 
        80 - 99% = 14607 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13522, nodes: 7760398 
    Average node length: 11.20, total dup: 0, max dup: 0 
    Average key length: 8.21, compression ratio: 1.10 
    Average prefix length: 3.79, average data length: 5.21 
    Clustering factor: 1518899, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1451 
        40 - 59% = 2168 
        60 - 79% = 1138 
        80 - 99% = 8765 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8308, nodes: 7760398 
    Average node length: 6.61, total dup: 5807274, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1512029, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 119 
        20 - 39% = 870 
        40 - 59% = 1466 
        60 - 79% = 913 
        80 - 99% = 4940 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 55.91, total records: 2244247 
    Average version length: 58.86, total versions: 70322, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.50 
    Pointer pages: 18, data page slots: 28536 
    Data pages: 28536, average fill: 73% 
    Primary pages: 28534, secondary pages: 2, swept pages: 7652 
    Empty pages: 1, full pages: 22395 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 61 
    40 - 59% = 470 
    60 - 79% = 27868 
    80 - 99% = 128 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4541, nodes: 2244247 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 686467, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 863 
        40 - 59% = 892 
        60 - 79% = 715 
        80 - 99% = 2071 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2409, nodes: 2245830 
    Average node length: 4.97, total dup: 2244931, max dup: 20318 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1276100, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 191 
        40 - 59% = 1384 
        60 - 79% = 580 
        80 - 99% = 253 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1762, nodes: 2244247 
    Average node length: 4.97, total dup: 2244197, max dup: 130306 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1063221, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 606 
        60 - 79% = 52 
        80 - 99% = 1098 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4339, nodes: 2244247 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 686467, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 102 
        20 - 39% = 575 
        40 - 59% = 636 
        60 - 79% = 813 
        80 - 99% = 2213 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    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: 1504337, 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: 1504338, 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: 1504336, 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: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, 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.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, 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: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.34, total records: 400 
    Average version length: 26.13, total versions: 2439, max versions: 8 
    Average fragment length: 2.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 57% 
    Primary pages: 7, secondary pages: 25, swept pages: 0 
    Empty pages: 4, full pages: 15 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 15 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, 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: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 21.27, total records: 123936 
    Average version length: 68.30, total versions: 98288, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.14 
    Pointer pages: 7, data page slots: 3744 
    Data pages: 2192, average fill: 74% 
    Primary pages: 2191, secondary pages: 1, swept pages: 0 
    Empty pages: 281, full pages: 1674 
    Fill distribution: 
     0 - 19% = 330 
    20 - 39% = 58 
    40 - 59% = 52 
    60 - 79% = 292 
    80 - 99% = 1460 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1700381, depth: 3, leaf buckets: 339, nodes: 123936 
    Average node length: 13.46, total dup: 9359, max dup: 2 
    Average key length: 10.61, compression ratio: 2.54 
    Average prefix length: 19.31, average data length: 7.69 
    Clustering factor: 89436, ratio: 0.72 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 195 
        60 - 79% = 78 
        80 - 99% = 60 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 191, max versions: 6 
    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: 1 
    Data pages: 1, average fill: 82% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, 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: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 16.26, total records: 1043 
    Average version length: 43.19, total versions: 834, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 3.57 
    Pointer pages: 1, data page slots: 40 
    Data pages: 32, average fill: 35% 
    Primary pages: 31, secondary pages: 1, swept pages: 5 
    Empty pages: 8, full pages: 4 
    Fill distribution: 
     0 - 19% = 14 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 8 
    80 - 99% = 2 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91353, depth: 2, leaf buckets: 1, nodes: 1043 
    Average node length: 4.49, total dup: 945, max dup: 135 
    Average key length: 2.98, compression ratio: 6.38 
    Average prefix length: 18.12, average data length: 0.88 
    Clustering factor: 575, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.69, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 51% 
    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 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    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: 1504251, 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: 1504249, 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: 1504248, 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: 1504250, 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: 1504247, 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: 550, Index root page: 551 
    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: 1504246, 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: 1504244, 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: 1504243, 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: 1504245, 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: 1504242, 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: 496, Index root page: 497 
    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: 1544827, 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: 1544826, 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: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.73, total records: 871320 
    Average version length: 37.89, total versions: 39609, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8848 
    Data pages: 8848, average fill: 67% 
    Primary pages: 8847, secondary pages: 1, swept pages: 1092 
    Empty pages: 2, full pages: 8736 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 6 
    40 - 59% = 20 
    60 - 79% = 8717 
    80 - 99% = 103 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 890, nodes: 845491 
    Average node length: 4.89, total dup: 845442, max dup: 149561 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 94985, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 119 
        40 - 59% = 441 
        60 - 79% = 217 
        80 - 99% = 113 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 1019, nodes: 845491 
    Average node length: 5.90, total dup: 752378, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 169613, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 31 
        40 - 59% = 633 
        60 - 79% = 112 
        80 - 99% = 238 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 1048, nodes: 845491 
    Average node length: 5.90, total dup: 752378, max dup: 42 
    Average key length: 3.02, compression ratio: 7.27 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 171509, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 69 
        40 - 59% = 638 
        60 - 79% = 128 
        80 - 99% = 212 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1173, nodes: 845491 
    Average node length: 5.98, total dup: 752378, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 163578, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 211 
        40 - 59% = 644 
        60 - 79% = 223 
        80 - 99% = 93 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5468 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.25, total fragments: 28, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 120 
    Data pages: 93, average fill: 58% 
    Primary pages: 82, secondary pages: 11, swept pages: 48 
    Empty pages: 12, full pages: 52 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5468 
    Average node length: 5.52, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.45, average data length: 1.54 
    Clustering factor: 5139, ratio: 0.94 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 0 
        80 - 99% = 2 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504255, depth: 2, leaf buckets: 10, nodes: 5468 
    Average node length: 11.16, 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: 167, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 6 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.04, total records: 78650 
    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: 824 
    Data pages: 824, average fill: 65% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 816 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 816 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 38564, depth: 2, leaf buckets: 100, nodes: 78650 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 2870, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 98 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    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: 1504261, 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: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.06, total records: 71 
    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.23 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    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: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 134.59, total records: 198877 
    Average version length: 154.89, total versions: 23195, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.60 
    Pointer pages: 7, data page slots: 5888 
    Data pages: 5008, average fill: 83% 
    Primary pages: 5005, secondary pages: 3, swept pages: 8 
    Empty pages: 99, full pages: 4882 
    Fill distribution: 
     0 - 19% = 99 
    20 - 39% = 11 
    40 - 59% = 6 
    60 - 79% = 13 
    80 - 99% = 4879 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 148.04, total records: 129983 
    Average version length: 151.44, total versions: 2591, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 4088 
    Data pages: 3264, average fill: 82% 
    Primary pages: 3262, secondary pages: 2, swept pages: 1 
    Empty pages: 66, full pages: 3181 
    Fill distribution: 
     0 - 19% = 68 
    20 - 39% = 8 
    40 - 59% = 4 
    60 - 79% = 3 
    80 - 99% = 3181 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 140.83, total records: 158254 
    Average version length: 154.78, total versions: 11656, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.04 
    Pointer pages: 7, data page slots: 4528 
    Data pages: 3992, average fill: 83% 
    Primary pages: 3989, secondary pages: 3, swept pages: 5 
    Empty pages: 81, full pages: 3880 
    Fill distribution: 
     0 - 19% = 86 
    20 - 39% = 9 
    40 - 59% = 5 
    60 - 79% = 12 
    80 - 99% = 3880 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 140.68, total records: 150490 
    Average version length: 154.47, total versions: 10726, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.06 
    Pointer pages: 7, data page slots: 5448 
    Data pages: 3800, average fill: 82% 
    Primary pages: 3798, secondary pages: 2, swept pages: 2 
    Empty pages: 87, full pages: 3678 
    Fill distribution: 
     0 - 19% = 90 
    20 - 39% = 14 
    40 - 59% = 4 
    60 - 79% = 13 
    80 - 99% = 3679 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 148.20, total records: 154110 
    Average version length: 152.17, total versions: 3183, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 6, data page slots: 4008 
    Data pages: 3824, average fill: 83% 
    Primary pages: 3823, secondary pages: 1, swept pages: 3 
    Empty pages: 32, full pages: 3779 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 6 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3780 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 145.57, total records: 150670 
    Average version length: 153.83, total versions: 5645, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.65 
    Pointer pages: 7, data page slots: 4880 
    Data pages: 3744, average fill: 83% 
    Primary pages: 3742, secondary pages: 2, swept pages: 5 
    Empty pages: 40, full pages: 3693 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 7 
    40 - 59% = 0 
    60 - 79% = 4 
    80 - 99% = 3691 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 621, Index root page: 622 
    Total formats: 1, used formats: 1 
    Average record length: 147.98, total records: 173277 
    Average version length: 152.96, total versions: 4292, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.46 
    Pointer pages: 7, data page slots: 6624 
    Data pages: 4352, average fill: 82% 
    Primary pages: 4349, secondary pages: 3, swept pages: 3 
    Empty pages: 75, full pages: 4257 
    Fill distribution: 
     0 - 19% = 78 
    20 - 39% = 8 
    40 - 59% = 5 
    60 - 79% = 3 
    80 - 99% = 4258 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 626, Index root page: 627 
    Total formats: 1, used formats: 1 
    Average record length: 147.73, total records: 155562 
    Average version length: 153.01, total versions: 3518, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.48 
    Pointer pages: 8, data page slots: 4680 
    Data pages: 3904, average fill: 82% 
    Primary pages: 3902, secondary pages: 2, swept pages: 1 
    Empty pages: 80, full pages: 3810 
    Fill distribution: 
     0 - 19% = 81 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 3811 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 628, Index root page: 629 
    Total formats: 1, used formats: 1 
    Average record length: 146.92, total records: 163691 
    Average version length: 153.09, total versions: 4971, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.54 
    Pointer pages: 7, data page slots: 5632 
    Data pages: 4080, average fill: 83% 
    Primary pages: 4078, secondary pages: 2, swept pages: 3 
    Empty pages: 47, full pages: 4013 
    Fill distribution: 
     0 - 19% = 48 
    20 - 39% = 7 
    40 - 59% = 6 
    60 - 79% = 4 
    80 - 99% = 4015 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 630, Index root page: 631 
    Total formats: 1, used formats: 1 
    Average record length: 131.09, total records: 177927 
    Average version length: 154.85, total versions: 24687, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.94 
    Pointer pages: 5, data page slots: 5560 
    Data pages: 4496, average fill: 83% 
    Primary pages: 4494, secondary pages: 2, swept pages: 4 
    Empty pages: 111, full pages: 4359 
    Fill distribution: 
     0 - 19% = 117 
    20 - 39% = 8 
    40 - 59% = 7 
    60 - 79% = 6 
    80 - 99% = 4358 
 
PHRASES (143) 
    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 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, 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: 1510375, 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: 1510374, 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: 1510373, 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: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.51, total records: 2082561 
    Average version length: 52.89, total versions: 58946, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.36 
    Pointer pages: 16, data page slots: 25752 
    Data pages: 25752, average fill: 70% 
    Primary pages: 25732, secondary pages: 20, swept pages: 10545 
    Empty pages: 237, full pages: 22048 
    Fill distribution: 
     0 - 19% = 414 
    20 - 39% = 323 
    40 - 59% = 913 
    60 - 79% = 23492 
    80 - 99% = 610 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2558, nodes: 2082561 
    Average node length: 5.44, total dup: 1943140, max dup: 1535 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 181045, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 302 
        40 - 59% = 1659 
        60 - 79% = 289 
        80 - 99% = 305 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2753, nodes: 2082561 
    Average node length: 5.69, total dup: 1868965, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 373459, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 6 
        40 - 59% = 2436 
        60 - 79% = 282 
        80 - 99% = 28 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2098, nodes: 2082561 
    Average node length: 4.96, total dup: 2082461, max dup: 28824 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179055, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 204 
        40 - 59% = 1066 
        60 - 79% = 385 
        80 - 99% = 442 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    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: 1504339, 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: 498, Index root page: 499 
    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: 1544825, 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: 1544824, 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: 528, Index root page: 529 
    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: 1504327, 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: 1504328, 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: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, 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: 1 
    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: 1544931, 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: 1544828, 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: 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 TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, 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: 488, Index root page: 489 
    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: 1544829, 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: 490, Index root page: 491 
    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: 492, Index root page: 493 
    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: 546, Index root page: 547 
    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: 544, Index root page: 545 
    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: 1504252, 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: 486, Index root page: 487 
    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: 484, Index root page: 485 
    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: 1544831, 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: 1544830, 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: 480, Index root page: 481 
    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: 1544833, 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: 557, Index root page: 558 
    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: 1504237, 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: 538, Index root page: 539 
    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: 508, Index root page: 509 
    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: 1552183, 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: 1510377, 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: 1510382, 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: 1510380, 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: 526, Index root page: 527 
    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: 1504329, 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: 1504330, 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: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 40.36, total records: 168491 
    Average version length: 69.18, total versions: 80750, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.12 
    Pointer pages: 3, data page slots: 4448 
    Data pages: 3328, average fill: 62% 
    Primary pages: 3327, secondary pages: 1, swept pages: 344 
    Empty pages: 493, full pages: 2210 
    Fill distribution: 
     0 - 19% = 641 
    20 - 39% = 146 
    40 - 59% = 159 
    60 - 79% = 1060 
    80 - 99% = 1322 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103244, depth: 3, leaf buckets: 250, nodes: 168491 
    Average node length: 6.48, total dup: 146753, max dup: 29 
    Average key length: 3.91, compression ratio: 10.75 
    Average prefix length: 40.22, average data length: 1.78 
    Clustering factor: 29292, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 31 
        40 - 59% = 132 
        60 - 79% = 69 
        80 - 99% = 16 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.35, total records: 7475421 
    Average version length: 68.75, total versions: 574304, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 66, data page slots: 107664 
    Data pages: 107664, average fill: 75% 
    Primary pages: 107664, secondary pages: 0, swept pages: 8680 
    Empty pages: 5, full pages: 103604 
    Fill distribution: 
     0 - 19% = 17 
    20 - 39% = 102 
    40 - 59% = 753 
    60 - 79% = 103384 
    80 - 99% = 3408 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10850, nodes: 7475421 
    Average node length: 6.51, total dup: 6464382, max dup: 35 
    Average key length: 3.52, compression ratio: 11.93 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1777255, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1210 
        40 - 59% = 5719 
        60 - 79% = 3290 
        80 - 99% = 624 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8824, nodes: 7475421 
    Average node length: 5.39, total dup: 7184501, max dup: 153 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1566111, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 965 
        40 - 59% = 5038 
        60 - 79% = 1684 
        80 - 99% = 1131 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8913, nodes: 7475421 
    Average node length: 5.39, total dup: 7184501, max dup: 153 
    Average key length: 2.40, compression ratio: 7.09 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1568423, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 11 
        20 - 39% = 1015 
        40 - 59% = 5088 
        60 - 79% = 1703 
        80 - 99% = 1096 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.99, total records: 12391105 
    Average version length: 68.70, total versions: 401410, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 109, data page slots: 176336 
    Data pages: 176336, average fill: 75% 
    Primary pages: 176335, secondary pages: 1, swept pages: 50532 
    Empty pages: 5, full pages: 175478 
    Fill distribution: 
     0 - 19% = 11 
    20 - 39% = 51 
    40 - 59% = 252 
    60 - 79% = 172444 
    80 - 99% = 3578 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18474, nodes: 12386670 
    Average node length: 6.63, total dup: 10793480, max dup: 74 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2523307, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 31 
        20 - 39% = 1787 
        40 - 59% = 10563 
        60 - 79% = 5145 
        80 - 99% = 948 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 40.65, total records: 1850935 
    Average version length: 69.07, total versions: 487025, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.10 
    Pointer pages: 29, data page slots: 45432 
    Data pages: 29208, average fill: 63% 
    Primary pages: 29144, secondary pages: 64, swept pages: 3267 
    Empty pages: 1183, full pages: 24219 
    Fill distribution: 
     0 - 19% = 1998 
    20 - 39% = 4821 
    40 - 59% = 2585 
    60 - 79% = 13165 
    80 - 99% = 6639 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1859, nodes: 1461220 
    Average node length: 5.52, total dup: 1402209, max dup: 49 
    Average key length: 2.56, compression ratio: 16.40 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 102945, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 12 
        20 - 39% = 336 
        40 - 59% = 867 
        60 - 79% = 523 
        80 - 99% = 121 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 30.99, total records: 1694508 
    Average version length: 69.03, total versions: 192324, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 4.07 
    Pointer pages: 22, data page slots: 35672 
    Data pages: 27968, average fill: 44% 
    Primary pages: 27968, secondary pages: 0, swept pages: 5544 
    Empty pages: 5908, full pages: 15632 
    Fill distribution: 
     0 - 19% = 8303 
    20 - 39% = 2343 
    40 - 59% = 5245 
    60 - 79% = 11282 
    80 - 99% = 795 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1188, nodes: 813176 
    Average node length: 5.97, total dup: 747333, max dup: 85 
    Average key length: 3.03, compression ratio: 13.85 
    Average prefix length: 41.05, average data length: 0.95 
    Clustering factor: 123100, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 279 
        40 - 59% = 585 
        60 - 79% = 283 
        80 - 99% = 39 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 64.38, total records: 9268237 
    Average version length: 68.98, total versions: 691978, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 90, data page slots: 146672 
    Data pages: 146640, average fill: 68% 
    Primary pages: 146617, secondary pages: 23, swept pages: 32075 
    Empty pages: 321, full pages: 93586 
    Fill distribution: 
     0 - 19% = 1225 
    20 - 39% = 7074 
    40 - 59% = 20992 
    60 - 79% = 111909 
    80 - 99% = 5440 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13427, nodes: 9261416 
    Average node length: 6.69, total dup: 7682219, max dup: 25 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2111198, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1195 
        40 - 59% = 6680 
        60 - 79% = 4720 
        80 - 99% = 831 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.48, total records: 21150562 
    Average version length: 82.92, total versions: 16963, 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: 319824 
    Data pages: 319824, average fill: 81% 
    Primary pages: 319818, secondary pages: 6, swept pages: 12300 
    Empty pages: 47, full pages: 318977 
    Fill distribution: 
     0 - 19% = 73 
    20 - 39% = 35 
    40 - 59% = 87 
    60 - 79% = 48630 
    80 - 99% = 270999 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19560, nodes: 21150562 
    Average node length: 5.72, total dup: 20669801, max dup: 140 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3285752, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 0 
        40 - 59% = 8505 
        60 - 79% = 525 
        80 - 99% = 10523 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17164, nodes: 21150562 
    Average node length: 6.31, total dup: 18588065, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 918231, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 772 
        60 - 79% = 273 
        80 - 99% = 16117 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21367, nodes: 21150562 
    Average node length: 6.35, total dup: 18506305, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3578902, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 0 
        40 - 59% = 8825 
        60 - 79% = 606 
        80 - 99% = 11932 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16051, nodes: 21150562 
    Average node length: 5.56, total dup: 21150462, max dup: 231301 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 947025, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 10 
        40 - 59% = 2827 
        60 - 79% = 342 
        80 - 99% = 12871 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 77.30, total records: 9692741 
    Average version length: 82.63, total versions: 674585, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.63 
    Pointer pages: 107, data page slots: 174504 
    Data pages: 174464, average fill: 69% 
    Primary pages: 174428, secondary pages: 36, swept pages: 52343 
    Empty pages: 687, full pages: 106125 
    Fill distribution: 
     0 - 19% = 2060 
    20 - 39% = 9059 
    40 - 59% = 26908 
    60 - 79% = 109462 
    80 - 99% = 26975 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11350, nodes: 9692741 
    Average node length: 5.38, total dup: 9384716, max dup: 250 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2199048, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 66 
        40 - 59% = 8091 
        60 - 79% = 3124 
        80 - 99% = 67 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13595, nodes: 9692741 
    Average node length: 6.25, total dup: 8035049, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1554978, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 142 
        20 - 39% = 3824 
        40 - 59% = 4628 
        60 - 79% = 2681 
        80 - 99% = 2320 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12662, nodes: 9692741 
    Average node length: 5.99, total dup: 8415298, max dup: 51 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2390828, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 72 
        40 - 59% = 9072 
        60 - 79% = 3418 
        80 - 99% = 99 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10206, nodes: 9692741 
    Average node length: 5.15, total dup: 9692641, max dup: 162881 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1590043, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 47 
        20 - 39% = 1264 
        40 - 59% = 5129 
        60 - 79% = 1723 
        80 - 99% = 2043 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.08, total records: 11217438 
    Average version length: 82.54, total versions: 491945, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 119, data page slots: 193744 
    Data pages: 192112, average fill: 72% 
    Primary pages: 191929, secondary pages: 183, swept pages: 62124 
    Empty pages: 3229, full pages: 145211 
    Fill distribution: 
     0 - 19% = 5323 
    20 - 39% = 7167 
    40 - 59% = 17160 
    60 - 79% = 95395 
    80 - 99% = 67067 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13106, nodes: 11217438 
    Average node length: 5.30, total dup: 11108035, max dup: 642 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2352559, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 123 
        40 - 59% = 9361 
        60 - 79% = 3502 
        80 - 99% = 120 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10346, nodes: 11217438 
    Average node length: 5.50, total dup: 10727540, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 726252, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 172 
        20 - 39% = 835 
        40 - 59% = 2541 
        60 - 79% = 1756 
        80 - 99% = 5042 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14993, nodes: 11217438 
    Average node length: 6.03, total dup: 9787486, max dup: 71 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2368819, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 169 
        40 - 59% = 10941 
        60 - 79% = 3747 
        80 - 99% = 135 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10677, nodes: 11217438 
    Average node length: 5.22, total dup: 11217338, max dup: 198846 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 714976, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 78 
        20 - 39% = 833 
        40 - 59% = 4731 
        60 - 79% = 1484 
        80 - 99% = 3551 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    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: 1361775, 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: 1361777, 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: 1361776, 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: 1361774, 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: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 78.11, total records: 9741764 
    Average version length: 82.93, total versions: 611318, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.61 
    Pointer pages: 110, data page slots: 179048 
    Data pages: 178992, average fill: 68% 
    Primary pages: 178959, secondary pages: 33, swept pages: 64041 
    Empty pages: 919, full pages: 102658 
    Fill distribution: 
     0 - 19% = 2817 
    20 - 39% = 11288 
    40 - 59% = 30105 
    60 - 79% = 109613 
    80 - 99% = 25169 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11727, nodes: 9741764 
    Average node length: 5.19, total dup: 9712938, max dup: 1708 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2024748, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 28 
        20 - 39% = 1440 
        40 - 59% = 7705 
        60 - 79% = 1947 
        80 - 99% = 607 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13650, nodes: 9741764 
    Average node length: 6.26, total dup: 8076588, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1524168, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 183 
        20 - 39% = 3785 
        40 - 59% = 4606 
        60 - 79% = 2690 
        80 - 99% = 2386 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12313, nodes: 9741764 
    Average node length: 5.45, total dup: 9307397, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2155128, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1404 
        40 - 59% = 8533 
        60 - 79% = 1729 
        80 - 99% = 625 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10270, nodes: 9741764 
    Average node length: 5.17, total dup: 9741664, max dup: 164948 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1614907, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 46 
        20 - 39% = 1245 
        40 - 59% = 5221 
        60 - 79% = 1690 
        80 - 99% = 2068 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.40, total records: 568333 
    Average version length: 68.79, total versions: 7325, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8056 
    Data pages: 8056, average fill: 74% 
    Primary pages: 8055, secondary pages: 1, swept pages: 3560 
    Empty pages: 4, full pages: 6615 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 28 
    40 - 59% = 273 
    60 - 79% = 7652 
    80 - 99% = 97 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43864, depth: 3, leaf buckets: 725, nodes: 568333 
    Average node length: 5.95, total dup: 483700, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 99981, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 34 
        40 - 59% = 493 
        60 - 79% = 102 
        80 - 99% = 94 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 34653, depth: 3, leaf buckets: 750, nodes: 568333 
    Average node length: 6.15, total dup: 465952, max dup: 19 
    Average key length: 3.30, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 100031, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 35 
        40 - 59% = 519 
        60 - 79% = 99 
        80 - 99% = 96 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 562, nodes: 568333 
    Average node length: 4.86, total dup: 568233, max dup: 9538 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88888, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 40 
        40 - 59% = 306 
        60 - 79% = 96 
        80 - 99% = 119 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    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: 563, Index root page: 564 
    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: 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 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    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: 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 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    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: 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 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    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: 1504235, 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: 1504236, 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: 571, Index root page: 572 
    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: 1504232, 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: 1504231, 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: 1504234, 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: 1504233, 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: 561, Index root page: 562 
    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: 559, Index root page: 560 
    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: 512, Index root page: 513 
    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: 1510372, 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 Thu Mar 28 07:09:45 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7760398 134076 1 0.0000 0.0000
DOC_LIST 2244247 70322 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 2439 8 600.0000 0.0000
INVNT_TURNOVER_LOG 123936 98288 1 0.0000 0.0000
MONEY_SALDO 49 191 6 300.0000 0.0000
MONEY_TURNOVER_LOG 1043 834 1 0.0000 0.0000
PDISTR 871320 39609 2 0.0000 0.0000
PERF_SPLIT_0 198877 23195 1 0.0000 0.0000
PERF_SPLIT_1 129983 2591 1 0.0000 0.0000
PERF_SPLIT_2 158254 11656 1 0.0000 0.0000
PERF_SPLIT_3 150490 10726 1 0.0000 0.0000
PERF_SPLIT_4 154110 3183 1 0.0000 0.0000
PERF_SPLIT_5 150670 5645 1 0.0000 0.0000
PERF_SPLIT_6 173277 4292 1 0.0000 0.0000
PERF_SPLIT_7 155562 3518 1 0.0000 0.0000
PERF_SPLIT_8 163691 4971 1 0.0000 0.0000
PERF_SPLIT_9 177927 24687 1 0.0000 0.0000
PSTORNED 2082561 58946 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 168491 80750 1 0.0000 0.0000
XQD_1000_3300 7475421 574304 1 0.0000 0.0000
XQD_1200_2000 12391105 401410 1 0.0000 0.0000
XQD_2000_3300 1850935 487025 1 0.0000 0.0000
XQD_2100_3300 1694508 192324 1 0.0000 0.0000
XQD_3300_3400 9268237 691978 1 0.0000 0.0000
XQS_1000_1200 21150562 16963 1 0.0000 0.0000
XQS_1000_3300 9692741 674585 1 0.0000 0.0000
XQS_1200_2000 11217438 491945 1 0.0000 0.0000
XQS_2100_3300 9741764 611318 1 0.0000 0.0000
XQS_3300_3400 568333 7325 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 ---
:106: 
:107: mscs-test-161.budzdorov.ru    Thu Mar 28 07:08:05 2024
:108:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:109: 
--- end of diff output ---

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

28.03.24 07:09:57. There are 3 logs in /var/tmp/logs-oltp40 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-28 07:09:59 No severe PSQL-related problems occured
28.03.24 07:10:01. End of report.