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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15648084 kB
MemAvailable 30310144 kB
Buffers 0 kB
Cached 16110204 kB
SwapCached 2204 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 


SERVER_MODE                     SuperServer 3.0.12
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192

Test configuration settings 

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=1
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=100
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=20
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-05 19:09:45
DTS_END                         2024-03-05 19:09:45.2380
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47566
TRN_ID                          178698
ATT_ID                          576
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: 9206.01 22832 920601
customer order: creation 178.40 362 17840
customer order: refuse 15.11 419 1511
order to supplier: creation 46.45 1356 4645
order to supplier: removal 3.48 105471 348
invoice (draft): creation 47.94 3564 4794
invoice (draft): removal 49.29 772 4929
invoice accept: apply 42.99 20802 4299
invoice accept: cancel 44.25 1081 4425
customer reserve: creation 4114.32 198 411432
customer reserve: removal 4353.70 68 435370
realization accept: apply 86.29 204 8629
realization accept: cancel 88.91 139 8891
payment from customer: creation 62.33 106 6233
payment from customer: removal 5.58 76 558
payment to supplier: creation 50.98 145 5098
payment to supplier: removal 3.30 63 330
service: total inventory turnovers 4.83 1158 483
service: total monetary turnovers 6.94 41 694
service: aggregate perf. data 0.89 23229 89
service: refresh index statistics 0.03 297383 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 05-03-2024 19:11:39 to 05-03-2024 19:11:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 271
TEST_TIME 2 1658
TEST_TIME 3 2731
TEST_TIME 4 3647
TEST_TIME 5 4124
TEST_TIME 6 4358
TEST_TIME 7 4614
TEST_TIME 8 4615
TEST_TIME 9 5074
TEST_TIME 10 5562
TEST_TIME 11 5846
TEST_TIME 12 5906
TEST_TIME 13 5919
TEST_TIME 14 6243
TEST_TIME 15 6389
TEST_TIME 16 6716
TEST_TIME 17 7042
TEST_TIME 18 7160
TEST_TIME 19 7638
TEST_TIME 20 7616
TEST_TIME 21 7647
TEST_TIME 22 7772
TEST_TIME 23 8051
TEST_TIME 24 7973
TEST_TIME 25 8246
TEST_TIME 26 8115
TEST_TIME 27 8265
TEST_TIME 28 8340
TEST_TIME 29 8748
TEST_TIME 30 9166
TEST_TIME 31 9506
TEST_TIME 32 9328
TEST_TIME 33 9559
TEST_TIME 34 9517
TEST_TIME 35 9475
TEST_TIME 36 9449
TEST_TIME 37 9432
TEST_TIME 38 9471
TEST_TIME 39 9354
TEST_TIME 40 9168
TEST_TIME 41 9245
TEST_TIME 42 9126
TEST_TIME 43 9000
TEST_TIME 44 8978
TEST_TIME 45 8962
TEST_TIME 46 8940
TEST_TIME 47 9115
TEST_TIME 48 9190
TEST_TIME 49 9192
TEST_TIME 50 9169
TEST_TIME 51 9062
TEST_TIME 52 9096
TEST_TIME 53 9268
TEST_TIME 54 9327
TEST_TIME 55 9231
TEST_TIME 56 9181
TEST_TIME 57 9331
TEST_TIME 58 9357
TEST_TIME 59 9336
TEST_TIME 60 9360
TEST_TIME 61 9392
TEST_TIME 62 9389
TEST_TIME 63 9440
TEST_TIME 64 9428
TEST_TIME 65 9323
TEST_TIME 66 9275
TEST_TIME 67 9279
TEST_TIME 68 9202
TEST_TIME 69 9174
TEST_TIME 70 9245
TEST_TIME 71 9205
TEST_TIME 72 9155
TEST_TIME 73 9112
TEST_TIME 74 9052
TEST_TIME 75 9112
TEST_TIME 76 9059
TEST_TIME 77 9122
TEST_TIME 78 9204
TEST_TIME 79 9211
TEST_TIME 80 9188
TEST_TIME 81 9285
TEST_TIME 82 9267
TEST_TIME 83 9330
TEST_TIME 84 9343
TEST_TIME 85 9499
TEST_TIME 86 9479
TEST_TIME 87 9548
TEST_TIME 88 9517
TEST_TIME 89 9509
TEST_TIME 90 9432
TEST_TIME 91 9392
TEST_TIME 92 9398
TEST_TIME 93 9418
TEST_TIME 94 9396
TEST_TIME 95 9355
TEST_TIME 96 9336
TEST_TIME 97 9319
TEST_TIME 98 9276
TEST_TIME 99 9219
TEST_TIME 100 9206

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-03-2024 19:11:43 to 05-03-2024 19:11:46.

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 1297350 1297350 0 0.00 0 17558 7 0 0
doc_list_biud 1297350 1297350 0 0.00 0 36449 29 0 0
sp_add_invoice_to_stock 4433 4299 134 3.02 37 224058 20803 0 134
sp_cancel_adding_invoice 4425 4425 0 0.00 5 73493 1082 0 0
sp_cancel_client_order 1511 1511 0 0.00 4 11750 419 0 0
sp_cancel_customer_reserve 435370 435370 0 0.00 0 30741 69 0 0
sp_cancel_pay_from_customer 558 558 0 0.00 3 2657 76 0 0
sp_cancel_pay_to_supplier 330 330 0 0.00 3 1860 63 0 0
sp_cancel_supplier_invoice 4936 4929 7 0.14 1 27120 772 0 7
sp_cancel_supplier_order 348 348 0 0.00 8 1068628 105471 0 0
sp_cancel_write_off 8891 8891 0 0.00 1 12645 140 0 0
sp_client_order 17840 17840 0 0.00 3 49866 362 0 0
sp_customer_reserve 411432 411432 0 0.00 0 117212 199 0 0
sp_fill_shopping_cart 27269 27269 0 0.00 1 17483 38 0 0
sp_fill_shopping_cart_clo_res 411429 411429 0 0.00 0 44201 14 0 0
sp_get_clo_for_invoice 4296 4296 0 0.00 0 48084 327 0 0
sp_kill_cost_storno 14204 14204 0 0.00 0 9597 69 0 0
sp_kill_qstorno_ret_qs2qd 884908 884908 0 0.00 0 30262 37 0 0
sp_kill_qty_storno 468399 468399 0 0.00 0 36446 80 0 0
sp_lock_selected_doc 17851 17851 0 0.00 0 5545 3 0 0
sp_make_cost_storno 24256 24256 0 0.00 0 11781 61 0 0
sp_multiply_rows_for_pdistr 24256 24256 0 0.00 0 17149 30 0 0
sp_multiply_rows_for_qdistr 17840 17840 0 0.00 0 49328 152 0 0
sp_pay_from_customer 6233 6233 0 0.00 4 17829 107 0 0
sp_pay_to_supplier 5098 5098 0 0.00 5 16141 146 0 0
sp_payment_common 11331 11331 0 0.00 2 17821 28 0 0
sp_qd_handle_on_cancel_clo 1511 1511 0 0.00 0 11697 386 0 0
sp_qd_handle_on_invoice_upd_sts 8721 8721 0 0.00 0 36441 380 0 0
sp_qd_handle_on_reserve_upd_sts 8629 8629 0 0.00 0 21132 76 0 0
sp_reserve_write_off 8629 8629 0 0.00 6 21186 205 0 0
sp_supplier_invoice 4794 4794 0 0.00 7 90494 3564 0 0
sp_supplier_order 4645 4645 0 0.00 4 41998 1357 0 0
srv_aggregate_perf_data 89 89 0 0.00 1674 468984 23230 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 1190 113969 37961 0 0
srv_find_qd_qs_mism 876769 876769 0 0.00 0 16837 7 0 0
srv_make_invnt_saldo 483 483 0 0.00 24 28652 1159 0 0
srv_make_money_saldo 694 694 0 0.00 1 3530 41 0 0
srv_recalc_idx_stat 3 3 0 0.00 237861 363088 297384 0 0
t$perf-abend:sp_add_invoice_to_stock 134 134 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4299 4299 0 0.00 0 13706 243 0 0
t$perf-norm:sp_cancel_adding_invoice 379 379 0 0.00 0 5047 135 0 0
t$perf-norm:sp_cancel_client_order 1511 1511 0 0.00 0 4501 13 0 0
t$perf-norm:sp_cancel_customer_reserve 567 567 0 0.00 0 2098 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 558 558 0 0.00 0 2484 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 330 330 0 0.00 0 837 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 353 353 0 0.00 0 14145 69 0 0
t$perf-norm:sp_cancel_supplier_order 348 348 0 0.00 0 24242 1673 0 0
t$perf-norm:sp_cancel_write_off 880 880 0 0.00 0 4009 13 0 0
t$perf-norm:sp_client_order 17840 17840 0 0.00 0 12773 19 0 0
t$perf-norm:sp_customer_reserve 888 888 0 0.00 0 5312 17 0 0
t$perf-norm:sp_pay_from_customer 6233 6233 0 0.00 0 6391 13 0 0
t$perf-norm:sp_pay_to_supplier 5098 5098 0 0.00 0 14720 14 0 0
t$perf-norm:sp_reserve_write_off 8629 8629 0 0.00 0 9751 13 0 0
t$perf-norm:sp_supplier_invoice 4794 4794 0 0.00 0 8798 26 0 0
t$perf-norm:sp_supplier_order 4645 4645 0 0.00 0 4230 21 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 613 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 100 4 0 0
t$perf-norm:srv_make_invnt_saldo 483 483 0 0.00 0 1008 30 0 0
t$perf-norm:srv_make_money_saldo 694 694 0 0.00 0 3644 31 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 8860 8592 268 3.02 0 5776 17 0 268
v_all_customers 33436 33436 0 0.00 0 83 1 0 0
v_all_suppliers 26932 26932 0 0.00 0 29 1 0 0
v_all_wares 35680 35680 0 0.00 0 25 1 0 0
v_cancel_adding_invoice 758 758 0 0.00 0 268 7 0 0
v_cancel_client_order 3022 3022 0 0.00 0 3499 7 0 0
v_cancel_customer_prepayment 1116 1116 0 0.00 0 203 3 0 0
v_cancel_customer_reserve 1134 1134 0 0.00 0 3726 10 0 0
v_cancel_payment_to_supplier 660 660 0 0.00 0 1853 6 0 0
v_cancel_supplier_invoice 720 706 14 1.94 0 4821 28 0 14
v_cancel_supplier_order 696 696 0 0.00 0 2889 7 0 0
v_cancel_write_off 1760 1760 0 0.00 0 3619 19 0 0
v_max_id_clo_ord 4642 4642 0 0.00 0 1217 2 0 0
v_max_id_clo_res 888 888 0 0.00 0 6114 24 0 0
v_max_id_ord_sup 4787 4787 0 0.00 0 6475 5 0 0
v_max_non_paid_invoice 1061 1061 0 0.00 0 725 4 0 0
v_max_non_paid_realizn 2903 2903 0 0.00 0 3669 7 0 0
v_min_id_clo_ord 4642 4642 0 0.00 0 4180 8 0 0
v_min_id_clo_res 888 888 0 0.00 0 6700 32 0 0
v_min_id_ord_sup 4787 4787 0 0.00 0 5738 6 0 0
v_min_non_paid_invoice 5098 5098 0 0.00 0 11685 20 0 0
v_min_non_paid_realizn 6233 6233 0 0.00 0 6597 17 0 0
v_our_firm 8904 8904 0 0.00 0 18 1 0 0
v_reserve_write_off 17258 17258 0 0.00 0 4896 8 0 0
x_lock_depdocs_on_canc_invoice 9001 9001 0 0.00 0 29203 157 0 0
x_lock_depdocs_on_canc_sup_ord 348 348 0 0.00 0 5976 388 0 0
x_make_qstorno_1000_1200 4645 4645 0 0.00 1 41965 1272 0 0
x_make_qstorno_1200_2000 4794 4794 0 0.00 4 90275 3427 0 0
x_make_qstorno_2100_3300 411432 411432 0 0.00 0 117211 181 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 05-03-2024 19:11:47 to 05-03-2024 19:11:52.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
17:09:49 4 8192000000 8803632000 8816459776 9382352 0.114 3 1 2 0 9486688 61552 42784
17:10:50 41989 8192000000 9912601520 10224455680 992395056 10.805 100 89 176 0 1021123984 6021984 22706944
17:12:38 11809 8192000000 9944706976 10267582464 1028060912 11.150 100 88 176 0 1059589040 8802608 22725520
17:13:56 11489 8192000000 9980671712 10312900608 1067181712 11.525 100 80 160 0 1096916528 9469152 20265664
17:15:18 8136 8192000000 10021490016 10368737280 1112695024 11.958 100 76 152 0 1140968816 10318928 17954864
17:16:28 7503 8192000000 10074617040 10434707456 1165437936 12.454 100 79 152 0 1194570752 11792512 17340304
17:17:37 3593 8192000000 10118032640 10484883456 1205512656 12.827 100 81 162 0 1237223856 13574480 18136720
17:18:44 2564 8192000000 10144175056 10518986752 1233561856 13.087 100 76 150 0 1263744320 13597920 16584544
17:19:49 1355 8192000000 10180519824 10557792256 1262392096 13.352 100 90 180 0 1296995168 14969296 19633776
17:20:51 35290 8192000000 10190741152 10587258880 1289992800 13.604 100 61 123 1 1313252160 9782848 13476512
17:22:27 3921 8192000000 10197166416 10606751744 1308621808 13.774 100 46 92 3 1325052176 6334272 10096096
17:23:35 4858 8192000000 10202065696 10612875264 1312265520 13.807 100 28 57 1 1325315824 6782576 6267728
17:24:41 11181 8192000000 10225749392 10639167488 1328808816 13.956 100 20 40 1 1339255600 6136016 4310768
17:25:53 27418 8192000000 10227618768 10642374656 1332074848 13.986 100 21 42 0 1342635680 6201440 4359392
17:27:24 6844 8192000000 10221844848 10641620992 1322373248 13.898 99 31 63 0 1335111840 5272448 7466144
17:28:33 5991 8192000000 10221682192 10644353024 1333439712 13.998 100 17 34 0 1342144720 5014864 3690144
17:29:39 113969 8192000000 10221453536 10632712192 1290989376 13.613 97 32 61 0 1303640784 6105040 6546368
17:32:41 9592 8192000000 10259024064 10667548672 1349467344 14.143 100 62 124 0 1375459200 11494416 14497440
17:33:58 9093 8192000000 10213678272 10625593344 1301853920 13.712 98 48 96 1 1324534512 11604896 11075696
17:35:13 18005 8192000000 10211090928 10614177792 1285072992 13.559 97 38 76 1 1306866592 12808192 8985408
17:36:46 26266 8192000000 10228184272 10633412608 1272170512 13.441 95 43 81 1 1297029984 14483168 10376304
17:38:17 13110 8192000000 10234816528 10644054016 1312526448 13.809 99 47 92 0 1342872160 19178064 11167648
17:39:35 17090 8192000000 10227060304 10631516160 1301212032 13.706 98 44 88 0 1329245152 17303280 10729840
17:40:57 4038 8192000000 10240904320 10636296192 1315227552 13.833 100 64 125 0 1346766192 17590944 13947696
17:42:08 17912 8192000000 10268265072 10671677440 1339828848 14.056 100 63 122 0 1374059056 20257632 13972576
17:43:30 4701 8192000000 10238932752 10637815808 1306765600 13.757 99 57 114 2 1343499280 22217424 14516256
17:44:39 5331 8192000000 10282032880 10683351040 1347300464 14.123 100 69 137 2 1386979920 23573744 16105712
17:45:49 1665 8192000000 10295897072 10696540160 1357698112 14.217 100 84 167 0 1406497360 28627472 20171776
17:46:54 6926 8192000000 10289458528 10700701696 1360453872 14.241 100 62 120 1 1399679504 24530976 14694656
17:48:07 1186 8192000000 10335006960 10738253824 1383204880 14.445 100 91 182 0 1436059824 31134016 21720928
17:49:11 2856 8192000000 10316966704 10735124480 1381601152 14.431 100 68 135 1 1424462416 26676592 16184672
17:50:24 2246 8192000000 10352929712 10761351168 1398265920 14.580 100 85 169 0 1453005328 34749296 19990112
17:51:30 1957 8192000000 10355059536 10765979648 1401752288 14.611 100 81 162 0 1455169952 33284064 20133600
17:52:38 13757 8192000000 10349586640 10780827648 1412327696 14.705 100 31 62 0 1452223360 31505536 8390128
17:54:00 5603 8192000000 10366552720 10797125632 1421610544 14.787 100 53 105 1 1476205264 40891552 13703168
17:55:11 40484 8192000000 10361986848 10798395392 1430329552 14.864 100 41 82 0 1474533392 33060320 11143520
17:56:55 25302 8192000000 10347611568 10796302336 1417633920 14.752 100 25 50 0 1459476096 34922192 6919984
17:58:36 18482 8192000000 10345561072 10794278912 1406635632 14.654 100 22 42 0 1450922416 38286560 6000224
18:01:01 42901 8192000000 10336377808 10774237184 1408820240 14.673 100 33 66 2 1425530672 8536736 8173696
18:02:47 77743 8192000000 10321854448 10769661952 1399549136 14.591 99 11 22 0 1413301184 10972016 2780032
18:05:11 60689 8192000000 10313879920 10766905344 1390645296 14.512 99 26 52 0 1406148720 9804176 5699248
18:07:14 95697 8192000000 10309397536 10762407936 1368942080 14.318 97 14 28 0 1383241920 11051952 3247888
18:09:51 51083 8192000000 10289456336 10739597312 1336855520 14.029 95 31 61 0 1358633296 15531936 6245840
18:11:45 52264 8192000000 10311225984 10754756608 1365414592 14.286 97 23 46 0 1388754080 18017232 5322256
18:13:39 28610 8192000000 10321493344 10765012992 1401424640 14.608 100 32 64 0 1428732912 19788352 7519920
18:15:21 49610 8192000000 10310869904 10752327680 1355055072 14.193 98 22 44 0 1383738784 22988080 5695632
18:17:13 31034 8192000000 10283401488 10741641216 1362118992 14.256 99 15 31 0 1386058480 20513760 3425728
18:18:53 104716 8192000000 10274795008 10718785536 1329914128 13.966 96 18 36 0 1353554080 19509456 4130496
18:21:39 45223 8192000000 10277762464 10726084608 1334132304 14.004 97 13 23 1 1355569136 18569024 2867808
18:23:32 42924 8192000000 10270779744 10700169216 1321933264 13.894 98 38 73 0 1339337392 8138080 9266048
18:25:18 14528 8192000000 10284780864 10718322688 1365095792 14.283 100 44 88 0 1385995888 10857424 10042672
18:26:37 57772 8192000000 10232296768 10673729536 1293851184 13.639 96 16 32 0 1311681344 14304176 3525984
18:28:38 20848 8192000000 10244904096 10685779968 1326926080 13.939 99 18 36 0 1340542576 9661184 3955312
18:30:00 49287 8192000000 10258135840 10698256384 1326554528 13.936 98 25 51 2 1349087136 16627712 5904896
18:32:21 27338 8192000000 10287358832 10727129088 1344673744 14.100 98 42 84 0 1367822160 14006976 9141440
18:33:50 43943 8192000000 10276568848 10727067648 1369199744 14.320 100 15 30 0 1384866048 12333744 3332560
18:35:47 29601 8192000000 10269250160 10705227776 1337050080 14.031 98 38 77 0 1353554272 7903824 8600368
18:37:20 40653 8192000000 10276877840 10718584832 1356939040 14.210 99 36 72 0 1373146848 8145952 8061856
18:39:12 40951 8192000000 10276699744 10733854720 1379468352 14.412 100 14 28 0 1391850864 9485760 2896752
18:41:42 46399 8192000000 10283020192 10737704960 1368631552 14.315 98 16 32 0 1377211296 5640224 2939520
18:43:42 58668 8192000000 10310482176 10768183296 1392609696 14.529 99 18 36 0 1410097792 13195648 4292448
18:45:41 80795 8192000000 10308004384 10779664384 1397964720 14.577 99 21 42 1 1416663856 13578592 5120544
18:48:08 33679 8192000000 10332326848 10786115584 1418260368 14.757 100 26 52 0 1435862432 11789248 5812816
18:49:56 41542 8192000000 10329780080 10800951296 1403179792 14.623 99 14 28 0 1434178208 27397456 3600960
18:51:39 91657 8192000000 10334015040 10801614848 1393015808 14.533 98 15 30 0 1418763088 22392112 3355168
18:54:16 97775 8192000000 10323802304 10786025472 1357161504 14.212 96 12 24 0 1375508208 15878848 2467856
18:57:08 60119 8192000000 10308298800 10763931648 1340205488 14.059 95 7 14 1 1357549008 15740896 1602624
18:59:08 86680 8192000000 10295341456 10745892864 1367263264 14.303 98 27 54 0 1381282576 7705968 6313344
19:01:38 25568 8192000000 10287740256 10744799232 1367314400 14.303 98 23 46 1 1384424576 12355488 4754688
19:03:07 46559 8192000000 10274365856 10739191808 1379446736 14.412 100 13 25 0 1393366400 11990864 1928800
19:05:06 41221 8192000000 10252127376 10705694720 1318941712 13.867 96 13 26 0 1328076224 6498304 2636208
19:06:48 42682 8192000000 10242152592 10702708736 1332201776 13.987 98 18 36 0 1344949568 8737600 4010192
19:08:32 43373 8192000000 10252313712 10699657216 1335143472 14.014 98 24 48 0 1351169200 10467808 5557920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 05-03-2024 19:11:53 to 05-03-2024 19:12:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 134 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-03-2024 19:12:08 to 05-03-2024 19:12:10.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          176807
MON$OLDEST_ACTIVE               178981
MON$OLDEST_SNAPSHOT             178981
MON$NEXT_TRANSACTION            178981
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       1928928
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Tue Mar  5 19:12:11 2024 
 
Database header page information: 
    Flags            0 
    Generation        93394 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    176807 
    Oldest active        178981 
    Oldest snapshot        178981 
    Next transaction    178982 
    Sequence number        0 
    Next attachment ID    722 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 3, 2020 16:41:55 
    Attributes        force write 
 
    Variable header data: 
    Sweep interval:        0 
    Unrecognized option 11, length 16 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp30-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504311, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504313, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504312, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504310, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504309, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504241, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 474, Index root page: 475 
    Total formats: 1, used formats: 1 
    Average record length: 47.69, total records: 7732114 
    Average version length: 48.16, total versions: 33619, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.34 
    Pointer pages: 54, data page slots: 87416 
    Data pages: 87416, average fill: 71% 
    Primary pages: 87416, secondary pages: 0, swept pages: 33236 
    Empty pages: 6, full pages: 56663 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 278 
    40 - 59% = 3640 
    60 - 79% = 83450 
    80 - 99% = 1 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23357, nodes: 7732114 
    Average node length: 18.88, total dup: 0, max dup: 0 
    Average key length: 15.89, compression ratio: 1.70 
    Average prefix length: 14.11, average data length: 12.89 
    Clustering factor: 1701813, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 316 
        20 - 39% = 1997 
        40 - 59% = 4103 
        60 - 79% = 2416 
        80 - 99% = 14525 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13569, nodes: 7732114 
    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: 1524949, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1706 
        40 - 59% = 1972 
        60 - 79% = 1136 
        80 - 99% = 8755 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8369, nodes: 7732114 
    Average node length: 6.61, total dup: 5787363, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1518006, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 125 
        20 - 39% = 1062 
        40 - 59% = 1310 
        60 - 79% = 970 
        80 - 99% = 4902 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.97, total records: 2236626 
    Average version length: 34.75, total versions: 36196, max versions: 3 
    Average fragment length: 7.33, total fragments: 3, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.47 
    Pointer pages: 18, data page slots: 28664 
    Data pages: 28664, average fill: 72% 
    Primary pages: 28657, secondary pages: 7, swept pages: 15960 
    Empty pages: 8, full pages: 18309 
    Fill distribution: 
     0 - 19% = 30 
    20 - 39% = 173 
    40 - 59% = 2226 
    60 - 79% = 26023 
    80 - 99% = 212 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4582, nodes: 2236626 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 690252, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 979 
        40 - 59% = 809 
        60 - 79% = 797 
        80 - 99% = 1997 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2541, nodes: 2238196 
    Average node length: 4.97, total dup: 2237299, max dup: 19313 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1240192, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 301 
        40 - 59% = 1554 
        60 - 79% = 519 
        80 - 99% = 164 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2047, nodes: 2236626 
    Average node length: 4.97, total dup: 2236576, max dup: 130383 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062174, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 136 
        40 - 59% = 1022 
        60 - 79% = 49 
        80 - 99% = 837 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4349, nodes: 2236626 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 690252, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 88 
        20 - 39% = 630 
        40 - 59% = 579 
        60 - 79% = 893 
        80 - 99% = 2159 
 
DOC_STATES (149) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504315, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504316, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504314, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 2, used formats: 2 
    Average record length: 54.76, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.94 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 70% 
    Primary pages: 40, secondary pages: 0, swept pages: 0 
    Empty pages: 7, full pages: 32 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 26 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 382, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1515, ratio: 0.69 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 2, used formats: 1 
    Average record length: 82.39, total records: 400 
    Average version length: 22.82, total versions: 240843, max versions: 629 
    Average fragment length: 2.00, total fragments: 52, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1336 
    Data pages: 1336, average fill: 89% 
    Primary pages: 12, secondary pages: 1324, swept pages: 0 
    Empty pages: 5, full pages: 1330 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 1329 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510349, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 9.61, total records: 66231 
    Average version length: 68.27, total versions: 56915, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 9.15 
    Pointer pages: 7, data page slots: 1776 
    Data pages: 1184, average fill: 69% 
    Primary pages: 1183, secondary pages: 1, swept pages: 3 
    Empty pages: 154, full pages: 810 
    Fill distribution: 
     0 - 19% = 207 
    20 - 39% = 37 
    40 - 59% = 68 
    60 - 79% = 155 
    80 - 99% = 717 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1704582, depth: 3, leaf buckets: 189, nodes: 66231 
    Average node length: 13.52, total dup: 2917, max dup: 1 
    Average key length: 10.85, compression ratio: 2.49 
    Average prefix length: 19.10, average data length: 7.90 
    Clustering factor: 48280, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 2 
        40 - 59% = 117 
        60 - 79% = 47 
        80 - 99% = 22 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 18683, max versions: 981 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 72 
    Data pages: 72, average fill: 83% 
    Primary pages: 6, secondary pages: 66, swept pages: 0 
    Empty pages: 5, full pages: 66 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 59 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510361, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 476, Index root page: 477 
    Total formats: 1, used formats: 1 
    Average record length: 3.71, total records: 1472 
    Average version length: 42.87, total versions: 1348, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 15.63 
    Pointer pages: 1, data page slots: 32 
    Data pages: 29, average fill: 48% 
    Primary pages: 29, secondary pages: 0, swept pages: 4 
    Empty pages: 7, full pages: 11 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 3 
    40 - 59% = 5 
    60 - 79% = 0 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91890, depth: 2, leaf buckets: 2, nodes: 1472 
    Average node length: 4.30, total dup: 1374, max dup: 129 
    Average key length: 2.70, compression ratio: 7.03 
    Average prefix length: 18.36, average data length: 0.64 
    Clustering factor: 821, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.04, total records: 73 
    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% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 73 
    Average node length: 11.68, total dup: 0, max dup: 0 
    Average key length: 10.67, compression ratio: 0.84 
    Average prefix length: 1.32, average data length: 7.68 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.76, total records: 804247 
    Average version length: 25.74, total versions: 42234, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.47 
    Pointer pages: 6, data page slots: 8344 
    Data pages: 8344, average fill: 67% 
    Primary pages: 8316, secondary pages: 28, swept pages: 3190 
    Empty pages: 99, full pages: 5161 
    Fill distribution: 
     0 - 19% = 194 
    20 - 39% = 160 
    40 - 59% = 605 
    60 - 79% = 7228 
    80 - 99% = 157 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 918, nodes: 804247 
    Average node length: 4.87, total dup: 804198, max dup: 143089 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89465, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 141 
        40 - 59% = 578 
        60 - 79% = 164 
        80 - 99% = 35 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1032, nodes: 804247 
    Average node length: 5.88, total dup: 715854, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159174, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 131 
        40 - 59% = 570 
        60 - 79% = 137 
        80 - 99% = 190 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1069, nodes: 804247 
    Average node length: 5.88, total dup: 715854, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161207, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 223 
        40 - 59% = 537 
        60 - 79% = 116 
        80 - 99% = 193 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1151, nodes: 804247 
    Average node length: 5.96, total dup: 715854, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154153, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 239 
        40 - 59% = 632 
        60 - 79% = 204 
        80 - 99% = 75 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.83, total records: 5470 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.90, total fragments: 78, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 77, secondary pages: 19, swept pages: 64 
    Empty pages: 9, full pages: 64 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 3 
    60 - 79% = 67 
    80 - 99% = 1 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5470 
    Average node length: 5.45, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.44, average data length: 1.54 
    Clustering factor: 5191, ratio: 0.95 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 4 
        60 - 79% = 1 
        80 - 99% = 1 
 
    Index PK_PERF_AGG (0) 
    Root page: 1504233, depth: 2, leaf buckets: 10, nodes: 5470 
    Average node length: 11.08, 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: 145, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 7 
 
PERF_ESTIMATED (280) 
    Primary pointer page: 1504218, Index root page: 1504219 
    Total formats: 1, used formats: 1 
    Average record length: 39.18, total records: 81422 
    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: 792 
    Data pages: 792, average fill: 71% 
    Primary pages: 792, secondary pages: 0, swept pages: 0 
    Empty pages: 6, full pages: 785 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 785 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35472, depth: 2, leaf buckets: 104, nodes: 81422 
    Average node length: 10.18, total dup: 0, max dup: 0 
    Average key length: 8.19, compression ratio: 1.10 
    Average prefix length: 3.81, average data length: 5.19 
    Clustering factor: 3153, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 2 
        60 - 79% = 1 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 148.26, total records: 161428 
    Average version length: 152.92, total versions: 2712, 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: 7, data page slots: 4224 
    Data pages: 3880, average fill: 86% 
    Primary pages: 3880, secondary pages: 0, swept pages: 1 
    Empty pages: 50, full pages: 3811 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 8 
    40 - 59% = 2 
    60 - 79% = 5 
    80 - 99% = 3812 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 129.58, total records: 184775 
    Average version length: 154.99, total versions: 25773, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.09 
    Pointer pages: 7, data page slots: 5096 
    Data pages: 4440, average fill: 87% 
    Primary pages: 4440, secondary pages: 0, swept pages: 1 
    Empty pages: 47, full pages: 4378 
    Fill distribution: 
     0 - 19% = 52 
    20 - 39% = 1 
    40 - 59% = 7 
    60 - 79% = 1 
    80 - 99% = 4379 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 149.41, total records: 167242 
    Average version length: 152.19, total versions: 1599, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 4920 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4008, secondary pages: 0, swept pages: 1 
    Empty pages: 42, full pages: 3953 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 4 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3953 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 149.92, total records: 163134 
    Average version length: 150.53, total versions: 1013, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 6, data page slots: 4896 
    Data pages: 3920, average fill: 86% 
    Primary pages: 3920, secondary pages: 0, swept pages: 5 
    Empty pages: 52, full pages: 3855 
    Fill distribution: 
     0 - 19% = 55 
    20 - 39% = 4 
    40 - 59% = 4 
    60 - 79% = 2 
    80 - 99% = 3855 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 150.75, total records: 162569 
    Average version length: 150.38, total versions: 735, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 6, data page slots: 4208 
    Data pages: 3912, average fill: 86% 
    Primary pages: 3912, secondary pages: 0, swept pages: 1 
    Empty pages: 45, full pages: 3854 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 5 
    80 - 99% = 3853 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 150.18, total records: 180774 
    Average version length: 152.42, total versions: 1170, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 4872 
    Data pages: 4320, average fill: 86% 
    Primary pages: 4320, secondary pages: 0, swept pages: 3 
    Empty pages: 29, full pages: 4281 
    Fill distribution: 
     0 - 19% = 32 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 4281 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 150.00, total records: 179985 
    Average version length: 153.93, total versions: 1323, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.31 
    Pointer pages: 8, data page slots: 4728 
    Data pages: 4312, average fill: 86% 
    Primary pages: 4312, secondary pages: 0, swept pages: 1 
    Empty pages: 38, full pages: 4261 
    Fill distribution: 
     0 - 19% = 41 
    20 - 39% = 2 
    40 - 59% = 2 
    60 - 79% = 6 
    80 - 99% = 4261 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 150.78, total records: 174118 
    Average version length: 138.74, total versions: 222, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 6, data page slots: 5376 
    Data pages: 4176, average fill: 86% 
    Primary pages: 4176, secondary pages: 0, swept pages: 2 
    Empty pages: 45, full pages: 4121 
    Fill distribution: 
     0 - 19% = 49 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4121 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.02, total records: 175018 
    Average version length: 153.58, total versions: 2488, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.38 
    Pointer pages: 10, data page slots: 4992 
    Data pages: 4224, average fill: 85% 
    Primary pages: 4224, secondary pages: 0, swept pages: 1 
    Empty pages: 64, full pages: 4142 
    Fill distribution: 
     0 - 19% = 66 
    20 - 39% = 3 
    40 - 59% = 6 
    60 - 79% = 7 
    80 - 99% = 4142 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 150.76, total records: 160679 
    Average version length: 141.84, total versions: 203, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 7, data page slots: 4368 
    Data pages: 3848, average fill: 86% 
    Primary pages: 3848, secondary pages: 0, swept pages: 2 
    Empty pages: 38, full pages: 3803 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3803 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 52.38, total records: 2074753 
    Average version length: 52.85, total versions: 14629, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.34 
    Pointer pages: 16, data page slots: 25664 
    Data pages: 25664, average fill: 69% 
    Primary pages: 25664, secondary pages: 0, swept pages: 13186 
    Empty pages: 378, full pages: 19239 
    Fill distribution: 
     0 - 19% = 727 
    20 - 39% = 568 
    40 - 59% = 1528 
    60 - 79% = 22744 
    80 - 99% = 97 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2600, nodes: 2074753 
    Average node length: 5.44, total dup: 1935828, max dup: 1484 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 179786, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 351 
        40 - 59% = 1687 
        60 - 79% = 300 
        80 - 99% = 259 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2763, nodes: 2074753 
    Average node length: 5.70, total dup: 1861155, max dup: 64 
    Average key length: 2.74, compression ratio: 3.28 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 371143, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 11 
        40 - 59% = 2461 
        60 - 79% = 269 
        80 - 99% = 21 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2191, nodes: 2074753 
    Average node length: 4.96, total dup: 2074653, max dup: 27747 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 177913, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 244 
        40 - 59% = 1207 
        60 - 79% = 398 
        80 - 99% = 339 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504317, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 470, Index root page: 471 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544803, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544802, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504305, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504306, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 466, Index root page: 467 
    Total formats: 1, used formats: 1 
    Average record length: 97.63, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 2 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 525, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544806, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 454, Index root page: 455 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544810, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 460, Index root page: 461 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544807, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 462, Index root page: 463 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 464, Index root page: 465 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 458, Index root page: 459 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 456, Index root page: 457 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544809, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544808, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 452, Index root page: 453 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544811, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504214, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552159, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510355, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510360, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510358, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504307, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504308, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 549, Index root page: 550 
    Total formats: 1, used formats: 1 
    Average record length: 46.46, total records: 126007 
    Average version length: 69.17, total versions: 41453, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.71 
    Pointer pages: 3, data page slots: 4552 
    Data pages: 3352, average fill: 43% 
    Primary pages: 3352, secondary pages: 0, swept pages: 842 
    Empty pages: 807, full pages: 1190 
    Fill distribution: 
     0 - 19% = 1218 
    20 - 39% = 392 
    40 - 59% = 286 
    60 - 79% = 661 
    80 - 99% = 795 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 104020, depth: 3, leaf buckets: 226, nodes: 126007 
    Average node length: 6.37, total dup: 109591, max dup: 14 
    Average key length: 3.98, compression ratio: 10.55 
    Average prefix length: 40.15, average data length: 1.85 
    Clustering factor: 21547, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 101 
        40 - 59% = 93 
        60 - 79% = 25 
        80 - 99% = 5 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 66.99, total records: 6814036 
    Average version length: 68.77, total versions: 195650, 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: 64, data page slots: 104368 
    Data pages: 104368, average fill: 70% 
    Primary pages: 104368, secondary pages: 0, swept pages: 57000 
    Empty pages: 19, full pages: 52374 
    Fill distribution: 
     0 - 19% = 121 
    20 - 39% = 1369 
    40 - 59% = 14867 
    60 - 79% = 86541 
    80 - 99% = 1470 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10638, nodes: 6814036 
    Average node length: 6.52, total dup: 5892013, max dup: 29 
    Average key length: 3.53, compression ratio: 11.91 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1507483, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1970 
        40 - 59% = 5895 
        60 - 79% = 2426 
        80 - 99% = 341 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8456, nodes: 6814036 
    Average node length: 5.40, total dup: 6536886, max dup: 128 
    Average key length: 2.42, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1315735, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 10 
        20 - 39% = 1280 
        40 - 59% = 4902 
        60 - 79% = 1385 
        80 - 99% = 879 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8534, nodes: 6814036 
    Average node length: 5.40, total dup: 6536886, max dup: 128 
    Average key length: 2.42, compression ratio: 7.04 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1318314, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1390 
        40 - 59% = 4884 
        60 - 79% = 1387 
        80 - 99% = 865 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.88, total records: 11857471 
    Average version length: 68.72, total versions: 184936, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 104, data page slots: 168160 
    Data pages: 168160, average fill: 75% 
    Primary pages: 168160, secondary pages: 0, swept pages: 101569 
    Empty pages: 8, full pages: 138251 
    Fill distribution: 
     0 - 19% = 61 
    20 - 39% = 756 
    40 - 59% = 6709 
    60 - 79% = 158062 
    80 - 99% = 2572 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18340, nodes: 11857471 
    Average node length: 6.58, total dup: 10332176, max dup: 61 
    Average key length: 3.43, compression ratio: 12.24 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2329073, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 30 
        20 - 39% = 2541 
        40 - 59% = 10877 
        60 - 79% = 4211 
        80 - 99% = 681 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 55.62, total records: 1236635 
    Average version length: 69.09, total versions: 241995, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.27 
    Pointer pages: 29, data page slots: 44752 
    Data pages: 29440, average fill: 47% 
    Primary pages: 29439, secondary pages: 1, swept pages: 15613 
    Empty pages: 5573, full pages: 12250 
    Fill distribution: 
     0 - 19% = 9214 
    20 - 39% = 3522 
    40 - 59% = 2761 
    60 - 79% = 10406 
    80 - 99% = 3537 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2018, nodes: 1236635 
    Average node length: 5.52, total dup: 1186256, max dup: 49 
    Average key length: 2.58, compression ratio: 16.29 
    Average prefix length: 41.46, average data length: 0.54 
    Clustering factor: 85146, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1004 
        40 - 59% = 777 
        60 - 79% = 197 
        80 - 99% = 34 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 53.00, total records: 830233 
    Average version length: 69.15, total versions: 192776, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.38 
    Pointer pages: 22, data page slots: 35056 
    Data pages: 28688, average fill: 33% 
    Primary pages: 28688, secondary pages: 0, swept pages: 14332 
    Empty pages: 5164, full pages: 4061 
    Fill distribution: 
     0 - 19% = 11779 
    20 - 39% = 6231 
    40 - 59% = 4416 
    60 - 79% = 3772 
    80 - 99% = 2490 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1453, nodes: 830233 
    Average node length: 5.79, total dup: 774299, max dup: 97 
    Average key length: 2.88, compression ratio: 14.56 
    Average prefix length: 41.18, average data length: 0.82 
    Clustering factor: 108243, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 781 
        40 - 59% = 527 
        60 - 79% = 123 
        80 - 99% = 18 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 67.94, total records: 8994525 
    Average version length: 68.96, total versions: 125063, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.85 
    Pointer pages: 90, data page slots: 146104 
    Data pages: 146056, average fill: 66% 
    Primary pages: 146056, secondary pages: 0, swept pages: 93041 
    Empty pages: 416, full pages: 65256 
    Fill distribution: 
     0 - 19% = 1543 
    20 - 39% = 9423 
    40 - 59% = 30104 
    60 - 79% = 103343 
    80 - 99% = 1643 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13517, nodes: 8994525 
    Average node length: 6.69, total dup: 7461532, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1905083, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1509 
        40 - 59% = 7202 
        60 - 79% = 4213 
        80 - 99% = 590 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.52, total records: 21167007 
    Average version length: 83.03, total versions: 4868, 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: 319080 
    Data pages: 319080, average fill: 81% 
    Primary pages: 319080, secondary pages: 0, swept pages: 13466 
    Empty pages: 57, full pages: 318274 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 38 
    40 - 59% = 107 
    60 - 79% = 27870 
    80 - 99% = 290990 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19609, nodes: 21167007 
    Average node length: 5.72, total dup: 20685546, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3284761, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 8558 
        60 - 79% = 544 
        80 - 99% = 10498 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17204, nodes: 21167007 
    Average node length: 6.31, total dup: 18601453, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916251, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 6 
        40 - 59% = 790 
        60 - 79% = 287 
        80 - 99% = 16118 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21420, nodes: 21167007 
    Average node length: 6.35, total dup: 18520154, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579366, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1 
        40 - 59% = 8848 
        60 - 79% = 651 
        80 - 99% = 11912 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16147, nodes: 21167007 
    Average node length: 5.56, total dup: 21166907, max dup: 230851 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944909, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 12 
        40 - 59% = 2921 
        60 - 79% = 418 
        80 - 99% = 12795 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 81.15, total records: 9467365 
    Average version length: 82.59, total versions: 145920, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 107, data page slots: 173936 
    Data pages: 173880, average fill: 67% 
    Primary pages: 173880, secondary pages: 0, swept pages: 112145 
    Empty pages: 877, full pages: 84212 
    Fill distribution: 
     0 - 19% = 2500 
    20 - 39% = 10986 
    40 - 59% = 34433 
    60 - 79% = 76336 
    80 - 99% = 49625 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11414, nodes: 9467365 
    Average node length: 5.38, total dup: 9158875, max dup: 179 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.79, average data length: 0.21 
    Clustering factor: 2066034, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 147 
        40 - 59% = 8817 
        60 - 79% = 2402 
        80 - 99% = 48 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13521, nodes: 9467365 
    Average node length: 6.25, total dup: 7848353, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1419266, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 158 
        20 - 39% = 4134 
        40 - 59% = 4383 
        60 - 79% = 2616 
        80 - 99% = 2230 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12743, nodes: 9467365 
    Average node length: 6.00, total dup: 8205688, max dup: 32 
    Average key length: 2.86, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2250255, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 162 
        40 - 59% = 9827 
        60 - 79% = 2696 
        80 - 99% = 56 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10085, nodes: 9467365 
    Average node length: 5.15, total dup: 9467265, max dup: 156590 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1456945, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 51 
        20 - 39% = 1419 
        40 - 59% = 4984 
        60 - 79% = 1650 
        80 - 99% = 1981 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 81.55, total records: 11169862 
    Average version length: 82.59, total versions: 102868, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 120, data page slots: 194408 
    Data pages: 193008, average fill: 71% 
    Primary pages: 193008, secondary pages: 0, swept pages: 89746 
    Empty pages: 3335, full pages: 133367 
    Fill distribution: 
     0 - 19% = 5997 
    20 - 39% = 9574 
    40 - 59% = 22269 
    60 - 79% = 48280 
    80 - 99% = 106888 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13164, nodes: 11169862 
    Average node length: 5.31, total dup: 11059554, max dup: 638 
    Average key length: 2.08, compression ratio: 4.32 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2326498, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 126 
        40 - 59% = 9551 
        60 - 79% = 3348 
        80 - 99% = 137 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10456, nodes: 11169862 
    Average node length: 5.51, total dup: 10681946, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 703331, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 183 
        20 - 39% = 901 
        40 - 59% = 2613 
        60 - 79% = 1840 
        80 - 99% = 4919 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15050, nodes: 11169862 
    Average node length: 6.04, total dup: 9736670, max dup: 68 
    Average key length: 2.81, compression ratio: 3.20 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2342726, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 160 
        40 - 59% = 11027 
        60 - 79% = 3692 
        80 - 99% = 170 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10790, nodes: 11169862 
    Average node length: 5.23, total dup: 11169762, max dup: 188540 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 692267, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 99 
        20 - 39% = 979 
        40 - 59% = 4735 
        60 - 79% = 1568 
        80 - 99% = 3409 
 
XQS_2000_3300 (185) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361753, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361755, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361754, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361752, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 1 
    Average record length: 81.26, total records: 9606221 
    Average version length: 82.89, total versions: 171324, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.55 
    Pointer pages: 109, data page slots: 177696 
    Data pages: 177568, average fill: 67% 
    Primary pages: 177568, secondary pages: 0, swept pages: 114816 
    Empty pages: 887, full pages: 85161 
    Fill distribution: 
     0 - 19% = 2774 
    20 - 39% = 11601 
    40 - 59% = 35281 
    60 - 79% = 79008 
    80 - 99% = 48904 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11809, nodes: 9606221 
    Average node length: 5.19, total dup: 9577400, max dup: 1771 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1857492, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1607 
        40 - 59% = 7856 
        60 - 79% = 1753 
        80 - 99% = 558 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13599, nodes: 9606221 
    Average node length: 6.27, total dup: 7962531, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1377504, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 173 
        20 - 39% = 4093 
        40 - 59% = 4290 
        60 - 79% = 2630 
        80 - 99% = 2413 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12442, nodes: 9606221 
    Average node length: 5.45, total dup: 9171585, max dup: 97 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.75, average data length: 0.25 
    Clustering factor: 1990659, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 40 
        20 - 39% = 1572 
        40 - 59% = 8704 
        60 - 79% = 1614 
        80 - 99% = 512 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10284, nodes: 9606221 
    Average node length: 5.16, total dup: 9606121, max dup: 159702 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1467238, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 45 
        20 - 39% = 1457 
        40 - 59% = 5153 
        60 - 79% = 1638 
        80 - 99% = 1991 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.83, total records: 568195 
    Average version length: 68.86, total versions: 2760, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8064 
    Data pages: 8064, average fill: 74% 
    Primary pages: 8064, secondary pages: 0, swept pages: 4770 
    Empty pages: 5, full pages: 5940 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 48 
    40 - 59% = 430 
    60 - 79% = 7548 
    80 - 99% = 30 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 40055, depth: 3, leaf buckets: 729, nodes: 568195 
    Average node length: 5.95, total dup: 483778, max dup: 83 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 98445, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 40 
        40 - 59% = 504 
        60 - 79% = 90 
        80 - 99% = 95 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32232, depth: 3, leaf buckets: 748, nodes: 568195 
    Average node length: 6.15, total dup: 465895, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 98494, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 516 
        60 - 79% = 92 
        80 - 99% = 102 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 576, nodes: 568195 
    Average node length: 4.86, total dup: 568095, max dup: 9608 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 87551, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 344 
        60 - 79% = 87 
        80 - 99% = 106 
 
ZDOC_DATA (170) 
    Primary pointer page: 537, Index root page: 538 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 535, Index root page: 536 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 539, Index root page: 540 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 545, Index root page: 546 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504207, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 547, Index root page: 548 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504206, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 541, Index root page: 542 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504212, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504213, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 543, Index root page: 544 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504209, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504208, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504211, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504210, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 533, Index root page: 534 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 531, Index root page: 532 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510350, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Tue Mar  5 19:12:35 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7732114 33619 1 0.0000 0.0000
DOC_LIST 2236626 36196 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 240843 629 60200.0000 0.0000
INVNT_TURNOVER_LOG 66231 56915 1 0.0000 0.0000
MONEY_SALDO 49 18683 981 38100.0000 0.0000
MONEY_TURNOVER_LOG 1472 1348 1 0.0000 0.0000
PDISTR 804247 42234 3 0.0000 0.0000
PERF_SPLIT_0 161428 2712 1 0.0000 0.0000
PERF_SPLIT_1 184775 25773 1 0.0000 0.0000
PERF_SPLIT_2 167242 1599 1 0.0000 0.0000
PERF_SPLIT_3 163134 1013 1 0.0000 0.0000
PERF_SPLIT_4 162569 735 1 0.0000 0.0000
PERF_SPLIT_5 180774 1170 1 0.0000 0.0000
PERF_SPLIT_6 179985 1323 1 0.0000 0.0000
PERF_SPLIT_7 174118 222 1 0.0000 0.0000
PERF_SPLIT_8 175018 2488 1 0.0000 0.0000
PERF_SPLIT_9 160679 203 1 0.0000 0.0000
PSTORNED 2074753 14629 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 126007 41453 1 0.0000 0.0000
XQD_1000_3300 6814036 195650 1 0.0000 0.0000
XQD_1200_2000 11857471 184936 1 0.0000 0.0000
XQD_2000_3300 1236635 241995 1 0.0000 0.0000
XQD_2100_3300 830233 192776 1 0.0000 0.0000
XQD_3300_3400 8994525 125063 1 0.0000 0.0000
XQS_1000_1200 21167007 4868 1 0.0000 0.0000
XQS_1000_3300 9467365 145920 1 0.0000 0.0000
XQS_1200_2000 11169862 102868 1 0.0000 0.0000
XQS_2100_3300 9606221 171324 1 0.0000 0.0000
XQS_3300_3400 568195 2760 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 ---
:231: 
:232: mscs-test-161.budzdorov.ru    Tue Mar  5 19:10:02 2024
:233:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:234: 
:235: 
:236: mscs-test-161.budzdorov.ru    Tue Mar  5 19:10:02 2024
:237:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:238: 
:239: 
:240: mscs-test-161.budzdorov.ru    Tue Mar  5 19:10:02 2024
:241:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:242: 
--- end of diff output ---

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

05.03.24 19:12:47. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs'
Following values of gdscode are considered as SEVERE:
            0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised.
    335544321 'string truncation'. Attempt to assign too long text into string variable.
    335544347 'not_valid'. Validation error for column.
    335544349 'no_dup'. Attempt to store duplicate value visible to active transactions.
    335544558 'check_constraint'. Operation violates CHECK constraint on view or table.
    335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint.
    335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist.
    335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2024-03-05 19:12:50 No severe PSQL-related problems occured
05.03.24 19:12:51. End of report.