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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15379520 kB
MemAvailable 30039304 kB
Buffers 0 kB
Cached 16315944 kB
SwapCached 2488 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-04-11 19:09:46
DTS_END                         2024-04-11 19:09:46.4560
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52832
TRN_ID                          175155
ATT_ID                          589
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: 9130.01 26405 913001
customer order: creation 169.71 388 16971
customer order: refuse 15.08 391 1508
order to supplier: creation 45.48 1296 4548
order to supplier: removal 3.46 118649 346
invoice (draft): creation 46.24 3471 4624
invoice (draft): removal 50.95 891 5095
invoice accept: apply 40.77 20667 4077
invoice accept: cancel 46.22 1065 4622
customer reserve: creation 3882.24 199 388224
customer reserve: removal 4525.44 73 452544
realization accept: apply 82.16 203 8216
realization accept: cancel 91.11 135 9111
payment from customer: creation 60.45 120 6045
payment from customer: removal 5.41 71 541
payment to supplier: creation 48.73 149 4873
payment to supplier: removal 3.55 89 355
service: total inventory turnovers 5.38 1049 538
service: total monetary turnovers 6.69 38 669
service: aggregate perf. data 0.91 17919 91
service: refresh index statistics 0.03 361244 3

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3840
TEST_TIME 2 3035
TEST_TIME 3 3610
TEST_TIME 4 3646
TEST_TIME 5 3911
TEST_TIME 6 4037
TEST_TIME 7 4171
TEST_TIME 8 4014
TEST_TIME 9 4072
TEST_TIME 10 4176
TEST_TIME 11 4656
TEST_TIME 12 5082
TEST_TIME 13 5274
TEST_TIME 14 5637
TEST_TIME 15 5852
TEST_TIME 16 6111
TEST_TIME 17 6438
TEST_TIME 18 6750
TEST_TIME 19 6786
TEST_TIME 20 6848
TEST_TIME 21 7071
TEST_TIME 22 7475
TEST_TIME 23 7383
TEST_TIME 24 7694
TEST_TIME 25 7848
TEST_TIME 26 8037
TEST_TIME 27 8320
TEST_TIME 28 8534
TEST_TIME 29 9819
TEST_TIME 30 10072
TEST_TIME 31 9961
TEST_TIME 32 9939
TEST_TIME 33 9928
TEST_TIME 34 9805
TEST_TIME 35 9613
TEST_TIME 36 9607
TEST_TIME 37 9526
TEST_TIME 38 9475
TEST_TIME 39 9420
TEST_TIME 40 9384
TEST_TIME 41 9411
TEST_TIME 42 9335
TEST_TIME 43 9263
TEST_TIME 44 9183
TEST_TIME 45 9173
TEST_TIME 46 9155
TEST_TIME 47 9084
TEST_TIME 48 8962
TEST_TIME 49 8919
TEST_TIME 50 9022
TEST_TIME 51 9033
TEST_TIME 52 8936
TEST_TIME 53 9141
TEST_TIME 54 9141
TEST_TIME 55 9115
TEST_TIME 56 9233
TEST_TIME 57 9226
TEST_TIME 58 9280
TEST_TIME 59 9222
TEST_TIME 60 9339
TEST_TIME 61 9308
TEST_TIME 62 9288
TEST_TIME 63 9180
TEST_TIME 64 9167
TEST_TIME 65 9224
TEST_TIME 66 9149
TEST_TIME 67 9126
TEST_TIME 68 9100
TEST_TIME 69 9079
TEST_TIME 70 9036
TEST_TIME 71 8998
TEST_TIME 72 8992
TEST_TIME 73 8967
TEST_TIME 74 8994
TEST_TIME 75 9013
TEST_TIME 76 9062
TEST_TIME 77 9121
TEST_TIME 78 9161
TEST_TIME 79 9238
TEST_TIME 80 9198
TEST_TIME 81 9189
TEST_TIME 82 9250
TEST_TIME 83 9229
TEST_TIME 84 9259
TEST_TIME 85 9308
TEST_TIME 86 9356
TEST_TIME 87 9422
TEST_TIME 88 9373
TEST_TIME 89 9276
TEST_TIME 90 9219
TEST_TIME 91 9255
TEST_TIME 92 9242
TEST_TIME 93 9189
TEST_TIME 94 9178
TEST_TIME 95 9118
TEST_TIME 96 9072
TEST_TIME 97 9121
TEST_TIME 98 9146
TEST_TIME 99 9167
TEST_TIME 100 9130

Performance per minute, chart


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

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 1268757 1268757 0 0.00 0 19398 7 0 0
doc_list_biud 1268757 1268757 0 0.00 0 24449 32 0 0
sp_add_invoice_to_stock 4188 4077 111 2.65 46 220183 20667 0 111
sp_cancel_adding_invoice 4622 4622 0 0.00 5 80466 1065 0 0
sp_cancel_client_order 1508 1508 0 0.00 4 10967 391 0 0
sp_cancel_customer_reserve 452544 452544 0 0.00 0 24453 73 0 0
sp_cancel_pay_from_customer 541 541 0 0.00 3 2222 71 0 0
sp_cancel_pay_to_supplier 355 355 0 0.00 3 2597 90 0 0
sp_cancel_supplier_invoice 5105 5095 10 0.19 2 19339 892 0 10
sp_cancel_supplier_order 346 346 0 0.00 12 1066178 118649 0 0
sp_cancel_write_off 9111 9111 0 0.00 1 10212 135 0 0
sp_client_order 16971 16971 0 0.00 3 68308 389 0 0
sp_customer_reserve 388224 388224 0 0.00 0 31908 199 0 0
sp_fill_shopping_cart 26135 26135 0 0.00 1 24202 38 0 0
sp_fill_shopping_cart_clo_res 388223 388223 0 0.00 0 17173 17 0 0
sp_get_clo_for_invoice 4075 4075 0 0.00 0 32299 365 0 0
sp_kill_cost_storno 14629 14629 0 0.00 0 9405 70 0 0
sp_kill_qstorno_ret_qs2qd 919640 919640 0 0.00 0 19320 39 0 0
sp_kill_qty_storno 485514 485514 0 0.00 0 24448 84 0 0
sp_lock_selected_doc 17120 17120 0 0.00 0 11651 5 0 0
sp_make_cost_storno 23206 23206 0 0.00 0 19322 62 0 0
sp_multiply_rows_for_pdistr 23206 23206 0 0.00 0 7662 32 0 0
sp_multiply_rows_for_qdistr 16971 16971 0 0.00 0 68302 179 0 0
sp_pay_from_customer 6045 6045 0 0.00 4 15166 120 0 0
sp_pay_to_supplier 4873 4873 0 0.00 5 14905 150 0 0
sp_payment_common 10918 10918 0 0.00 2 9966 31 0 0
sp_qd_handle_on_cancel_clo 1508 1508 0 0.00 0 10962 352 0 0
sp_qd_handle_on_invoice_upd_sts 8694 8694 0 0.00 0 18191 366 0 0
sp_qd_handle_on_reserve_upd_sts 8216 8216 0 0.00 0 20315 69 0 0
sp_reserve_write_off 8216 8216 0 0.00 7 21699 204 0 0
sp_supplier_invoice 4624 4624 0 0.00 7 81303 3472 0 0
sp_supplier_order 4548 4548 0 0.00 6 34011 1297 0 0
srv_aggregate_perf_data 92 91 1 1.08 1544 318145 17919 0 1
srv_fill_mon_cache_memory 57 57 0 0.00 1322 137242 37298 0 0
srv_find_qd_qs_mism 871231 871231 0 0.00 0 12955 6 0 0
srv_make_invnt_saldo 538 538 0 0.00 56 43209 1050 0 0
srv_make_money_saldo 669 669 0 0.00 1 5914 39 0 0
srv_recalc_idx_stat 3 3 0 0.00 250766 456066 361244 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4077 4077 0 0.00 0 8635 184 0 0
t$perf-norm:sp_cancel_adding_invoice 358 358 0 0.00 0 2670 127 0 0
t$perf-norm:sp_cancel_client_order 1508 1508 0 0.00 0 1856 14 0 0
t$perf-norm:sp_cancel_customer_reserve 563 563 0 0.00 0 3141 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 541 541 0 0.00 0 957 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 355 355 0 0.00 0 612 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 349 349 0 0.00 0 1452 20 0 0
t$perf-norm:sp_cancel_supplier_order 346 346 0 0.00 0 20492 2056 0 0
t$perf-norm:sp_cancel_write_off 812 812 0 0.00 0 1181 6 0 0
t$perf-norm:sp_client_order 16971 16971 0 0.00 0 10888 18 0 0
t$perf-norm:sp_customer_reserve 834 834 0 0.00 0 962 6 0 0
t$perf-norm:sp_pay_from_customer 6045 6045 0 0.00 0 4798 12 0 0
t$perf-norm:sp_pay_to_supplier 4873 4873 0 0.00 0 13696 14 0 0
t$perf-norm:sp_reserve_write_off 8216 8216 0 0.00 0 11604 12 0 0
t$perf-norm:sp_supplier_invoice 4624 4624 0 0.00 0 5287 20 0 0
t$perf-norm:sp_supplier_order 4548 4548 0 0.00 0 4389 15 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 32 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 17 1 0 0
t$perf-norm:srv_make_invnt_saldo 538 538 0 0.00 0 920 16 0 0
t$perf-norm:srv_make_money_saldo 669 669 0 0.00 0 1259 21 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 8366 8144 222 2.65 0 7018 21 0 222
v_all_customers 32070 32070 0 0.00 0 27 1 0 0
v_all_suppliers 25948 25948 0 0.00 0 22 1 0 0
v_all_wares 33942 33942 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 716 716 0 0.00 0 6976 20 0 0
v_cancel_client_order 3016 3016 0 0.00 0 3219 8 0 0
v_cancel_customer_prepayment 1082 1082 0 0.00 0 1108 5 0 0
v_cancel_customer_reserve 1126 1126 0 0.00 0 3845 11 0 0
v_cancel_payment_to_supplier 710 710 0 0.00 0 2164 17 0 0
v_cancel_supplier_invoice 718 698 20 2.78 0 4013 29 0 20
v_cancel_supplier_order 692 692 0 0.00 0 1568 8 0 0
v_cancel_write_off 1624 1624 0 0.00 0 4428 27 0 0
v_max_id_clo_ord 4548 4548 0 0.00 0 865 1 0 0
v_max_id_clo_res 834 834 0 0.00 0 10326 33 0 0
v_max_id_ord_sup 4616 4616 0 0.00 0 4567 4 0 0
v_max_non_paid_invoice 1063 1063 0 0.00 0 4185 9 0 0
v_max_non_paid_realizn 2771 2771 0 0.00 0 1577 5 0 0
v_min_id_clo_ord 4548 4548 0 0.00 0 2481 7 0 0
v_min_id_clo_res 834 834 0 0.00 0 11650 27 0 0
v_min_id_ord_sup 4616 4616 0 0.00 0 4404 6 0 0
v_min_non_paid_invoice 4873 4873 0 0.00 0 9957 22 0 0
v_min_non_paid_realizn 6045 6045 0 0.00 0 6513 24 0 0
v_our_firm 8420 8420 0 0.00 0 16 1 0 0
v_reserve_write_off 16432 16432 0 0.00 0 4796 8 0 0
x_lock_depdocs_on_canc_invoice 9368 9368 0 0.00 0 15987 145 0 0
x_lock_depdocs_on_canc_sup_ord 346 346 0 0.00 0 5323 373 0 0
x_make_qstorno_1000_1200 4548 4548 0 0.00 2 33993 1212 0 0
x_make_qstorno_1200_2000 4624 4624 0 0.00 3 81296 3340 0 0
x_make_qstorno_2100_3300 388224 388224 0 0.00 0 26662 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-04-2024 19:11:09 to 11-04-2024 19:11:13.

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:50 10 8192000000 8808522384 8823476224 9998272 0.121 6 1 2 0 10103216 62160 42784
17:10:51 15584 8192000000 9903301776 10211926016 992453408 10.805 100 88 176 0 1020849920 5462464 22934048
17:12:14 18103 8192000000 9938629408 10258300928 1018088064 11.054 100 90 180 0 1049074544 7662944 23323536
17:13:44 14641 8192000000 9973662784 10303606784 1058903472 11.446 100 91 183 0 1091572304 9634752 23034080
17:15:03 5032 8192000000 10028894640 10372702208 1113395616 11.965 100 83 166 0 1143954560 11284832 19274112
17:16:12 9891 8192000000 10078929136 10436763648 1164814432 12.448 100 82 162 0 1195356048 12004624 18536992
17:17:26 3297 8192000000 10109793824 10477121536 1199538048 12.772 100 82 164 0 1231513472 13612208 18363216
17:18:32 2565 8192000000 10140935424 10515566592 1232049648 13.073 100 81 161 0 1262362192 12965840 17346704
17:19:37 1523 8192000000 10173806640 10554540032 1257525504 13.307 100 79 157 0 1287440608 12924912 16990192
17:20:39 1514 8192000000 10195612624 10583752704 1287707664 13.583 100 75 151 0 1316477664 12130896 16639104
17:21:42 6029 8192000000 10183950624 10591002624 1292109088 13.623 100 35 70 0 1307266848 7598656 7559104
17:22:50 7533 8192000000 10206196080 10613370880 1307648704 13.765 100 35 70 0 1322464112 7487568 7327840
17:24:00 8830 8192000000 10214877952 10632482816 1324049200 13.913 100 26 53 0 1339748784 10001712 5697872
17:25:11 45247 8192000000 10220241712 10642825216 1330662704 13.973 100 36 72 1 1344534848 5060480 8811664
17:27:01 4498 8192000000 10236465376 10651426816 1338282240 14.042 100 34 68 0 1352132080 6425616 7424224
17:28:07 3677 8192000000 10238673232 10650890240 1322942720 13.903 99 41 83 0 1339717696 7536608 9238368
17:29:13 17957 8192000000 10192916416 10602463232 1256168720 13.295 94 25 46 0 1267117696 5152032 5796944
17:30:37 29088 8192000000 10213755824 10628648960 1311628496 13.801 99 38 73 0 1325432080 5857840 7945744
17:32:16 34464 8192000000 10234968896 10647392256 1311385568 13.799 98 36 72 2 1330165344 10565472 8214304
17:33:56 7528 8192000000 10224281632 10630627328 1314933680 13.831 99 44 86 0 1337345600 11861376 10550544
17:35:12 11592 8192000000 10234073344 10637611008 1319631072 13.873 100 41 82 0 1344031328 14090080 10310176
17:36:32 41570 8192000000 10239813680 10654298112 1312524272 13.809 98 35 70 0 1342272928 21140064 8608592
17:38:24 12045 8192000000 10235020480 10641395712 1310928272 13.794 98 38 75 2 1342411312 21999824 9483216
17:39:48 17203 8192000000 10245856304 10650378240 1312867648 13.812 98 38 76 0 1351677552 29021968 9787936
17:41:11 5783 8192000000 10252102816 10658779136 1315229712 13.833 98 44 88 0 1353386144 27103984 11052448
17:42:21 9796 8192000000 10269124512 10675462144 1332310544 13.988 100 53 103 1 1377635376 32541904 12782928
17:43:33 6341 8192000000 10295143264 10701602816 1354856208 14.191 100 54 104 1 1403218048 34926176 13435664
17:44:45 4936 8192000000 10290727824 10697535488 1348800816 14.137 100 59 118 0 1401349024 37766672 14781536
17:45:56 2742 8192000000 10303630240 10707181568 1354410480 14.187 100 71 142 0 1410038816 38645088 16983248
17:47:04 1319 8192000000 10358709040 10761003008 1395451056 14.554 100 91 181 0 1461241440 44061632 21728752
17:48:13 1422 8192000000 10361709904 10773647360 1402389024 14.616 100 72 141 1 1463023280 43019104 17615152
17:49:19 5741 8192000000 10366262192 10787332096 1411025008 14.693 100 54 108 1 1473625216 49412272 13187936
17:50:44 19133 8192000000 10378827280 10809958400 1420918288 14.781 100 37 74 0 1484633056 53318688 10396080
17:52:17 7550 8192000000 10380188512 10806640640 1420684032 14.779 100 43 85 3 1483681776 52238800 10758944
17:53:29 15311 8192000000 10385333696 10813181952 1423971392 14.808 100 45 88 0 1493031664 56919488 12140784
17:55:00 11639 8192000000 10388212960 10821537792 1419380432 14.767 100 35 70 2 1494425792 64794192 10251168
17:56:13 26531 8192000000 10363349360 10812477440 1406886000 14.656 100 25 50 0 1476152320 61618368 7647952
17:57:55 5268 8192000000 10372454320 10801229824 1391636000 14.520 100 48 97 1 1469853120 64872832 13344288
17:59:03 10970 8192000000 10320992176 10764021760 1403235760 14.624 100 39 78 1 1426945072 14739376 8969936
18:00:25 30092 8192000000 10317610960 10771701760 1407876496 14.665 100 42 83 2 1429628064 11960544 9791024
18:01:57 33363 8192000000 10308376016 10757611520 1389206464 14.499 99 21 42 0 1404397984 9837504 5354016
18:03:35 47905 8192000000 10322225840 10772934656 1415049376 14.729 100 28 56 2 1432539888 10783168 6707344
18:05:33 34216 8192000000 10321866528 10784899072 1416002752 14.737 100 33 64 1 1438125280 14574608 7547920
18:07:09 96704 8192000000 10324449056 10784702464 1402513360 14.617 99 23 45 0 1436048160 28527280 5007520
18:10:41 57808 8192000000 10295122000 10750550016 1379002064 14.408 97 27 54 0 1392622144 7895280 5724800
18:12:40 26017 8192000000 10299869712 10760650752 1405501808 14.644 100 16 32 0 1416322000 7170560 3649632
18:14:08 55805 8192000000 10299915536 10747150336 1359495696 14.233 97 22 44 1 1375577600 10831248 5250656
18:16:05 59390 8192000000 10291981776 10749812736 1373340688 14.357 98 29 58 1 1394257040 14227744 6688608
18:18:13 51547 8192000000 10291596752 10754420736 1364507376 14.278 98 27 55 0 1391816880 20995104 6314400
18:20:48 11988 8192000000 10287871680 10736033792 1364604848 14.279 99 25 50 1 1380623344 10417344 5601152
18:22:08 75303 8192000000 10269886752 10740568064 1347738512 14.127 98 15 30 0 1367155328 16004624 3412192
18:24:31 52616 8192000000 10286878624 10731978752 1345136816 14.104 98 36 72 2 1370724992 16471568 9116608
18:26:30 15243 8192000000 10258140592 10701979648 1340926672 14.066 99 38 75 0 1357965184 8520864 8517648
18:28:32 42375 8192000000 10264942480 10707197952 1324032464 13.913 97 56 110 3 1347546432 10728944 12785024
18:30:21 63374 8192000000 10249940048 10687979520 1281179952 13.524 95 19 38 0 1297139280 11641408 4317920
18:32:28 85894 8192000000 10255523520 10699161600 1329831408 13.966 99 32 64 0 1354589456 18038576 6719472
18:34:58 40659 8192000000 10252292656 10707484672 1338756256 14.046 99 21 42 0 1356803776 13598320 4449200
18:36:41 33332 8192000000 10236601872 10684735488 1330822688 13.975 99 20 40 0 1345350656 10035552 4492416
18:38:29 49646 8192000000 10244861712 10695606272 1345055744 14.103 99 13 26 1 1358073184 10128640 2888800
18:40:19 60551 8192000000 10244536512 10695581696 1345873248 14.110 99 17 34 0 1357087440 7653440 3560752
18:42:23 66293 8192000000 10257597584 10704510976 1310598448 13.792 96 12 24 0 1322945568 9755456 2591664
18:44:45 60862 8192000000 10278645072 10729144320 1373924816 14.362 100 21 40 0 1387587024 9325536 4336672
18:46:47 20092 8192000000 10293177088 10730848256 1365490640 14.287 99 33 63 1 1384502176 11865536 7146000
18:48:07 44119 8192000000 10301486112 10751774720 1390476912 14.510 100 26 52 0 1414802496 18744816 5580768
18:49:56 22848 8192000000 10311156576 10750504960 1397087664 14.569 100 48 96 1 1418285856 10834512 10363680
18:51:21 119519 8192000000 10302533056 10742730752 1341201904 14.068 96 21 42 2 1360430960 14694832 4534224
18:54:21 113094 8192000000 10304903888 10773975040 1359103120 14.229 97 8 16 0 1380325488 19524432 1697936
18:57:14 137241 8192000000 10296754992 10748465152 1383258240 14.446 99 18 36 0 1404666464 17354128 4054096
19:00:32 24052 8192000000 10273733696 10729385984 1344226128 14.095 97 21 42 0 1359185808 10254032 4705648
19:02:03 44090 8192000000 10262625424 10718035968 1352654000 14.171 98 11 23 0 1363472480 8095600 2722880
19:03:51 40991 8192000000 10279593312 10726912000 1345980512 14.111 97 14 28 0 1357876752 8845360 3050880
19:05:42 46858 8192000000 10293073328 10745552896 1382325376 14.437 100 28 56 1 1409573392 20379264 6868752
19:07:29 39271 8192000000 10280952608 10723586048 1340348080 14.061 97 33 66 1 1355078880 7245520 7485280
19:09:16 34798 8192000000 8990918080 9179725824 164037584 1.963 13 2 4 0 165602016 1165648 398784

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 11-04-2024 19:11:15 to 11-04-2024 19:11:29.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 111 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-04-2024 19:11:30 to 11-04-2024 19:11:32.

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          175549
MON$OLDEST_ACTIVE               175550
MON$OLDEST_SNAPSHOT             175550
MON$NEXT_TRANSACTION            175550
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                       1922144
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics 

 
Database "/home/bases/oltp30-etalone.fdb" 
Gstat execution time Thu Apr 11 19:11:33 2024 
 
Database header page information: 
    Flags            0 
    Generation        91264 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    175549 
    Oldest active        175550 
    Oldest snapshot        175550 
    Next transaction    175551 
    Sequence number        0 
    Next attachment ID    711 
    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.39, total records: 7725529 
    Average version length: 48.16, total versions: 80707, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 64.00, compression ratio: 1.35 
    Pointer pages: 54, data page slots: 87128 
    Data pages: 87128, average fill: 71% 
    Primary pages: 87128, secondary pages: 0, swept pages: 21843 
    Empty pages: 3, full pages: 62583 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 315 
    40 - 59% = 4072 
    60 - 79% = 82699 
    80 - 99% = 23 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23311, nodes: 7725529 
    Average node length: 18.87, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 1.70 
    Average prefix length: 14.12, average data length: 12.88 
    Clustering factor: 1689397, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 341 
        20 - 39% = 1994 
        40 - 59% = 4048 
        60 - 79% = 2475 
        80 - 99% = 14453 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13516, nodes: 7725529 
    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: 1512622, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1687 
        40 - 59% = 1960 
        60 - 79% = 1127 
        80 - 99% = 8742 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8353, nodes: 7725529 
    Average node length: 6.61, total dup: 5791346, max dup: 49 
    Average key length: 3.62, compression ratio: 2.49 
    Average prefix length: 7.63, average data length: 1.37 
    Clustering factor: 1505668, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 139 
        20 - 39% = 1046 
        40 - 59% = 1344 
        60 - 79% = 920 
        80 - 99% = 4904 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.38, total records: 2224541 
    Average version length: 34.85, total versions: 80553, max versions: 3 
    Average fragment length: 6.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28568 
    Data pages: 28568, average fill: 72% 
    Primary pages: 28561, secondary pages: 7, swept pages: 11125 
    Empty pages: 7, full pages: 19431 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 207 
    40 - 59% = 2642 
    60 - 79% = 25145 
    80 - 99% = 541 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4553, nodes: 2224541 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678149, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 938 
        40 - 59% = 843 
        60 - 79% = 771 
        80 - 99% = 2001 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2505, nodes: 2227300 
    Average node length: 4.97, total dup: 2226401, max dup: 20474 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1234556, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 294 
        40 - 59% = 1545 
        60 - 79% = 465 
        80 - 99% = 200 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2046, nodes: 2224541 
    Average node length: 4.97, total dup: 2224491, max dup: 130196 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1056341, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 178 
        40 - 59% = 982 
        60 - 79% = 42 
        80 - 99% = 835 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4360, nodes: 2224541 
    Average node length: 11.41, total dup: 0, max dup: 0 
    Average key length: 8.45, compression ratio: 1.07 
    Average prefix length: 3.55, average data length: 5.45 
    Clustering factor: 678149, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 101 
        20 - 39% = 633 
        40 - 59% = 637 
        60 - 79% = 846 
        80 - 99% = 2143 
 
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.42, total records: 400 
    Average version length: 22.66, total versions: 256061, max versions: 671 
    Average fragment length: 2.00, total fragments: 48, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.26 
    Pointer pages: 1, data page slots: 1408 
    Data pages: 1408, average fill: 90% 
    Primary pages: 14, secondary pages: 1394, swept pages: 0 
    Empty pages: 7, full pages: 1400 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 1400 
 
    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: 7.10, total records: 47458 
    Average version length: 68.27, total versions: 42528, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 12.40 
    Pointer pages: 8, data page slots: 1848 
    Data pages: 1144, average fill: 53% 
    Primary pages: 1143, secondary pages: 1, swept pages: 0 
    Empty pages: 165, full pages: 385 
    Fill distribution: 
     0 - 19% = 270 
    20 - 39% = 159 
    40 - 59% = 172 
    60 - 79% = 189 
    80 - 99% = 354 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1709008, depth: 3, leaf buckets: 179, nodes: 47458 
    Average node length: 13.56, total dup: 2754, max dup: 2 
    Average key length: 10.81, compression ratio: 2.50 
    Average prefix length: 19.13, average data length: 7.87 
    Clustering factor: 35631, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 83 
        40 - 59% = 66 
        60 - 79% = 24 
        80 - 99% = 6 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.22, total records: 49 
    Average version length: 9.00, total versions: 18110, max versions: 940 
    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: 64 
    Data pages: 64, average fill: 91% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 4 
    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: 5.58, total records: 1042 
    Average version length: 43.25, total versions: 908, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 10.40 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 32% 
    Primary pages: 31, secondary pages: 1, swept pages: 2 
    Empty pages: 12, full pages: 10 
    Fill distribution: 
     0 - 19% = 18 
    20 - 39% = 4 
    40 - 59% = 0 
    60 - 79% = 2 
    80 - 99% = 8 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 92530, depth: 2, leaf buckets: 1, nodes: 1042 
    Average node length: 4.19, total dup: 944, max dup: 91 
    Average key length: 2.98, compression ratio: 6.38 
    Average prefix length: 18.11, average data length: 0.89 
    Clustering factor: 596, ratio: 0.57 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.20, total records: 74 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 52% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 74 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504227, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504226, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504228, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504225, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504224, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504222, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504221, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504223, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504220, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 468, Index root page: 469 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544805, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544804, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 1, used formats: 1 
    Average record length: 36.11, total records: 830035 
    Average version length: 25.18, total versions: 70991, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.50 
    Pointer pages: 6, data page slots: 8464 
    Data pages: 8456, average fill: 69% 
    Primary pages: 8415, secondary pages: 41, swept pages: 1781 
    Empty pages: 110, full pages: 7127 
    Fill distribution: 
     0 - 19% = 202 
    20 - 39% = 172 
    40 - 59% = 305 
    60 - 79% = 7492 
    80 - 99% = 285 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 917, nodes: 830035 
    Average node length: 4.87, total dup: 829986, max dup: 155504 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 91247, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 125 
        40 - 59% = 523 
        60 - 79% = 215 
        80 - 99% = 54 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 1041, nodes: 830035 
    Average node length: 5.88, total dup: 738811, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 164175, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 130 
        40 - 59% = 567 
        60 - 79% = 113 
        80 - 99% = 228 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 1087, nodes: 830035 
    Average node length: 5.89, total dup: 738811, max dup: 42 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 166270, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 215 
        40 - 59% = 560 
        60 - 79% = 86 
        80 - 99% = 226 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1171, nodes: 830035 
    Average node length: 5.97, total dup: 738811, max dup: 42 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 159097, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 245 
        40 - 59% = 614 
        60 - 79% = 211 
        80 - 99% = 98 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.84, total records: 5462 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.05, total fragments: 74, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.03 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 56% 
    Primary pages: 75, secondary pages: 21, swept pages: 51 
    Empty pages: 9, full pages: 63 
    Fill distribution: 
     0 - 19% = 25 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 70 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5462 
    Average node length: 5.51, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.05 
    Average prefix length: 34.43, average data length: 1.55 
    Clustering factor: 5223, ratio: 0.96 
    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: 5462 
    Average node length: 11.14, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 146, 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: 79474 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 768 
    Data pages: 768, average fill: 71% 
    Primary pages: 768, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 766 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 766 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 34640, depth: 2, leaf buckets: 101, nodes: 79474 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3196, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.22, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.20 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 141.29, total records: 178413 
    Average version length: 151.40, total versions: 11447, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.00 
    Pointer pages: 7, data page slots: 5080 
    Data pages: 4288, average fill: 86% 
    Primary pages: 4288, secondary pages: 0, swept pages: 1 
    Empty pages: 48, full pages: 4215 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 6 
    40 - 59% = 4 
    60 - 79% = 15 
    80 - 99% = 4213 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 138.11, total records: 184001 
    Average version length: 153.01, total versions: 15596, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.28 
    Pointer pages: 8, data page slots: 7544 
    Data pages: 4472, average fill: 85% 
    Primary pages: 4472, secondary pages: 0, swept pages: 1 
    Empty pages: 92, full pages: 4345 
    Fill distribution: 
     0 - 19% = 94 
    20 - 39% = 14 
    40 - 59% = 10 
    60 - 79% = 9 
    80 - 99% = 4345 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 139.41, total records: 184327 
    Average version length: 152.58, total versions: 14142, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.17 
    Pointer pages: 8, data page slots: 8896 
    Data pages: 4512, average fill: 85% 
    Primary pages: 4512, secondary pages: 0, swept pages: 1 
    Empty pages: 126, full pages: 4353 
    Fill distribution: 
     0 - 19% = 128 
    20 - 39% = 8 
    40 - 59% = 12 
    60 - 79% = 12 
    80 - 99% = 4352 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 136.89, total records: 194366 
    Average version length: 152.33, total versions: 18298, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.39 
    Pointer pages: 8, data page slots: 7680 
    Data pages: 4672, average fill: 87% 
    Primary pages: 4672, secondary pages: 0, swept pages: 1 
    Empty pages: 48, full pages: 4596 
    Fill distribution: 
     0 - 19% = 53 
    20 - 39% = 7 
    40 - 59% = 2 
    60 - 79% = 14 
    80 - 99% = 4596 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 135.53, total records: 192761 
    Average version length: 152.89, total versions: 20035, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.51 
    Pointer pages: 7, data page slots: 7208 
    Data pages: 4656, average fill: 86% 
    Primary pages: 4656, secondary pages: 0, swept pages: 2 
    Empty pages: 63, full pages: 4559 
    Fill distribution: 
     0 - 19% = 63 
    20 - 39% = 12 
    40 - 59% = 13 
    60 - 79% = 8 
    80 - 99% = 4560 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 134.39, total records: 188377 
    Average version length: 152.43, total versions: 20604, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.62 
    Pointer pages: 7, data page slots: 8408 
    Data pages: 4600, average fill: 85% 
    Primary pages: 4599, secondary pages: 1, swept pages: 1 
    Empty pages: 120, full pages: 4446 
    Fill distribution: 
     0 - 19% = 122 
    20 - 39% = 9 
    40 - 59% = 10 
    60 - 79% = 12 
    80 - 99% = 4447 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 144.59, total records: 189710 
    Average version length: 150.88, total versions: 8126, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.73 
    Pointer pages: 7, data page slots: 7248 
    Data pages: 4616, average fill: 85% 
    Primary pages: 4616, secondary pages: 0, swept pages: 1 
    Empty pages: 107, full pages: 4483 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 10 
    40 - 59% = 8 
    60 - 79% = 9 
    80 - 99% = 4480 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 140.70, total records: 187424 
    Average version length: 151.24, total versions: 12785, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.05 
    Pointer pages: 8, data page slots: 6712 
    Data pages: 4552, average fill: 85% 
    Primary pages: 4551, secondary pages: 1, swept pages: 1 
    Empty pages: 104, full pages: 4427 
    Fill distribution: 
     0 - 19% = 104 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 7 
    80 - 99% = 4427 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 141.48, total records: 180681 
    Average version length: 150.36, total versions: 11457, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.99 
    Pointer pages: 8, data page slots: 6552 
    Data pages: 4384, average fill: 85% 
    Primary pages: 4384, secondary pages: 0, swept pages: 2 
    Empty pages: 88, full pages: 4265 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 9 
    40 - 59% = 11 
    60 - 79% = 12 
    80 - 99% = 4263 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 129.20, total records: 211100 
    Average version length: 153.80, total versions: 30796, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.13 
    Pointer pages: 6, data page slots: 8112 
    Data pages: 5192, average fill: 85% 
    Primary pages: 5192, secondary pages: 0, swept pages: 2 
    Empty pages: 144, full pages: 4993 
    Fill distribution: 
     0 - 19% = 149 
    20 - 39% = 16 
    40 - 59% = 20 
    60 - 79% = 15 
    80 - 99% = 4992 
 
PHRASES (143) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510354, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510353, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510352, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510351, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 1 
    Average record length: 51.67, total records: 2083577 
    Average version length: 52.91, total versions: 42641, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 70.00, compression ratio: 1.35 
    Pointer pages: 16, data page slots: 25632 
    Data pages: 25632, average fill: 70% 
    Primary pages: 25632, secondary pages: 0, swept pages: 11401 
    Empty pages: 343, full pages: 19761 
    Fill distribution: 
     0 - 19% = 663 
    20 - 39% = 554 
    40 - 59% = 1378 
    60 - 79% = 22721 
    80 - 99% = 316 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2563, nodes: 2083577 
    Average node length: 5.44, total dup: 1944355, max dup: 1496 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 180029, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 319 
        40 - 59% = 1633 
        60 - 79% = 295 
        80 - 99% = 310 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2755, nodes: 2083577 
    Average node length: 5.69, total dup: 1870022, max dup: 70 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 372323, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 12 
        40 - 59% = 2445 
        60 - 79% = 272 
        80 - 99% = 26 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2133, nodes: 2083577 
    Average node length: 4.96, total dup: 2083477, max dup: 28857 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 178189, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 201 
        40 - 59% = 1148 
        60 - 79% = 389 
        80 - 99% = 393 
 
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: 42.33, total records: 138658 
    Average version length: 69.19, total versions: 53859, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.98 
    Pointer pages: 3, data page slots: 4328 
    Data pages: 3184, average fill: 50% 
    Primary pages: 3184, secondary pages: 0, swept pages: 553 
    Empty pages: 586, full pages: 1628 
    Fill distribution: 
     0 - 19% = 1017 
    20 - 39% = 282 
    40 - 59% = 145 
    60 - 79% = 673 
    80 - 99% = 1067 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 105714, depth: 3, leaf buckets: 228, nodes: 138658 
    Average node length: 6.40, total dup: 120665, max dup: 29 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 23398, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 66 
        40 - 59% = 110 
        60 - 79% = 45 
        80 - 99% = 6 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 64.79, total records: 7232697 
    Average version length: 68.76, total versions: 436497, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.94 
    Pointer pages: 65, data page slots: 105472 
    Data pages: 105472, average fill: 73% 
    Primary pages: 105472, secondary pages: 0, swept pages: 28104 
    Empty pages: 13, full pages: 74676 
    Fill distribution: 
     0 - 19% = 100 
    20 - 39% = 766 
    40 - 59% = 7624 
    60 - 79% = 90761 
    80 - 99% = 6221 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10811, nodes: 7232697 
    Average node length: 6.51, total dup: 6257231, max dup: 29 
    Average key length: 3.52, compression ratio: 11.94 
    Average prefix length: 40.62, average data length: 1.38 
    Clustering factor: 1622484, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1486 
        40 - 59% = 5962 
        60 - 79% = 2839 
        80 - 99% = 523 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8717, nodes: 7232697 
    Average node length: 5.39, total dup: 6949035, max dup: 174 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1412412, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1135 
        40 - 59% = 4967 
        60 - 79% = 1552 
        80 - 99% = 1057 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8762, nodes: 7232697 
    Average node length: 5.39, total dup: 6949035, max dup: 174 
    Average key length: 2.40, compression ratio: 7.08 
    Average prefix length: 16.64, average data length: 0.36 
    Clustering factor: 1414914, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 1175 
        40 - 59% = 4994 
        60 - 79% = 1539 
        80 - 99% = 1051 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.11, total records: 12149444 
    Average version length: 68.71, total versions: 323353, 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: 105, data page slots: 170504 
    Data pages: 170504, average fill: 76% 
    Primary pages: 170504, secondary pages: 0, swept pages: 80662 
    Empty pages: 8, full pages: 150778 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 670 
    40 - 59% = 5206 
    60 - 79% = 159207 
    80 - 99% = 5359 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18487, nodes: 12149444 
    Average node length: 6.59, total dup: 10589240, max dup: 57 
    Average key length: 3.43, compression ratio: 12.25 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2390935, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 23 
        20 - 39% = 2356 
        40 - 59% = 10722 
        60 - 79% = 4607 
        80 - 99% = 779 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 43.05, total records: 1658228 
    Average version length: 69.09, total versions: 625898, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.93 
    Pointer pages: 27, data page slots: 43768 
    Data pages: 30888, average fill: 62% 
    Primary pages: 30888, secondary pages: 0, swept pages: 8776 
    Empty pages: 3671, full pages: 19332 
    Fill distribution: 
     0 - 19% = 6009 
    20 - 39% = 2019 
    40 - 59% = 1878 
    60 - 79% = 10996 
    80 - 99% = 9986 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2324, nodes: 1658228 
    Average node length: 5.51, total dup: 1590884, max dup: 99 
    Average key length: 2.56, compression ratio: 16.40 
    Average prefix length: 41.48, average data length: 0.52 
    Clustering factor: 111678, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 684 
        40 - 59% = 1129 
        60 - 79% = 408 
        80 - 99% = 96 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 39.69, total records: 1062180 
    Average version length: 69.13, total versions: 451178, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.17 
    Pointer pages: 25, data page slots: 40144 
    Data pages: 32480, average fill: 38% 
    Primary pages: 32480, secondary pages: 0, swept pages: 9681 
    Empty pages: 8784, full pages: 10847 
    Fill distribution: 
     0 - 19% = 14458 
    20 - 39% = 3929 
    40 - 59% = 2215 
    60 - 79% = 4550 
    80 - 99% = 7328 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1609, nodes: 1062180 
    Average node length: 5.78, total dup: 992411, max dup: 99 
    Average key length: 2.86, compression ratio: 14.71 
    Average prefix length: 41.21, average data length: 0.79 
    Clustering factor: 141850, ratio: 0.13 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 525 
        40 - 59% = 762 
        60 - 79% = 273 
        80 - 99% = 41 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 65.55, total records: 9106187 
    Average version length: 68.95, total versions: 441881, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 89, data page slots: 144928 
    Data pages: 144912, average fill: 67% 
    Primary pages: 144911, secondary pages: 1, swept pages: 58063 
    Empty pages: 537, full pages: 80251 
    Fill distribution: 
     0 - 19% = 1814 
    20 - 39% = 9090 
    40 - 59% = 25637 
    60 - 79% = 101421 
    80 - 99% = 6950 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13442, nodes: 9106187 
    Average node length: 6.69, total dup: 7554383, max dup: 27 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1939572, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1408 
        40 - 59% = 6871 
        60 - 79% = 4519 
        80 - 99% = 644 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21129703 
    Average version length: 82.92, total versions: 11567, 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: 318488 
    Data pages: 318488, average fill: 81% 
    Primary pages: 318488, secondary pages: 0, swept pages: 13169 
    Empty pages: 37, full pages: 317745 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 36 
    40 - 59% = 97 
    60 - 79% = 27760 
    80 - 99% = 290539 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19470, nodes: 21129703 
    Average node length: 5.72, total dup: 20649024, max dup: 165 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3277598, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 1 
        40 - 59% = 8367 
        60 - 79% = 526 
        80 - 99% = 10572 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17150, nodes: 21129703 
    Average node length: 6.31, total dup: 18567658, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 914125, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 5 
        40 - 59% = 767 
        60 - 79% = 272 
        80 - 99% = 16099 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21287, nodes: 21129703 
    Average node length: 6.35, total dup: 18487691, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3572084, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 2 
        40 - 59% = 8680 
        60 - 79% = 614 
        80 - 99% = 11983 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16149, nodes: 21129703 
    Average node length: 5.56, total dup: 21129603, max dup: 228711 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 942971, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 2997 
        60 - 79% = 419 
        80 - 99% = 12724 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.34, total records: 9464845 
    Average version length: 82.59, total versions: 352757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 104, data page slots: 168376 
    Data pages: 168352, average fill: 69% 
    Primary pages: 168352, secondary pages: 0, swept pages: 81974 
    Empty pages: 324, full pages: 94113 
    Fill distribution: 
     0 - 19% = 1444 
    20 - 39% = 9022 
    40 - 59% = 28275 
    60 - 79% = 70637 
    80 - 99% = 58974 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11353, nodes: 9464845 
    Average node length: 5.36, total dup: 9158393, max dup: 190 
    Average key length: 2.24, compression ratio: 4.02 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2064459, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 110 
        40 - 59% = 8892 
        60 - 79% = 2301 
        80 - 99% = 48 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13363, nodes: 9464845 
    Average node length: 6.22, total dup: 7848275, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1421959, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 114 
        20 - 39% = 4017 
        40 - 59% = 4333 
        60 - 79% = 2707 
        80 - 99% = 2192 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12676, nodes: 9464845 
    Average node length: 5.97, total dup: 8207800, max dup: 41 
    Average key length: 2.85, compression ratio: 3.15 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2252709, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 140 
        40 - 59% = 9902 
        60 - 79% = 2575 
        80 - 99% = 58 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 9894, nodes: 9464845 
    Average node length: 5.12, total dup: 9464745, max dup: 155352 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1462338, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 50 
        20 - 39% = 1200 
        40 - 59% = 4959 
        60 - 79% = 1631 
        80 - 99% = 2054 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 79.67, total records: 11227776 
    Average version length: 82.47, total versions: 358450, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 119, data page slots: 193056 
    Data pages: 191696, average fill: 72% 
    Primary pages: 191696, secondary pages: 0, swept pages: 73727 
    Empty pages: 3631, full pages: 140154 
    Fill distribution: 
     0 - 19% = 6179 
    20 - 39% = 8695 
    40 - 59% = 18753 
    60 - 79% = 43885 
    80 - 99% = 114184 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13120, nodes: 11227776 
    Average node length: 5.30, total dup: 11118116, max dup: 652 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2332433, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 130 
        40 - 59% = 9395 
        60 - 79% = 3455 
        80 - 99% = 140 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10448, nodes: 11227776 
    Average node length: 5.50, total dup: 10736504, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 700430, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 149 
        20 - 39% = 884 
        40 - 59% = 2581 
        60 - 79% = 1921 
        80 - 99% = 4913 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15005, nodes: 11227776 
    Average node length: 6.03, total dup: 9796286, max dup: 72 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2348928, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 153 
        40 - 59% = 10897 
        60 - 79% = 3793 
        80 - 99% = 161 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10715, nodes: 11227776 
    Average node length: 5.22, total dup: 11227676, max dup: 198514 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 689707, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 83 
        20 - 39% = 836 
        40 - 59% = 4784 
        60 - 79% = 1553 
        80 - 99% = 3459 
 
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: 79.73, total records: 9574128 
    Average version length: 82.93, total versions: 348134, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.58 
    Pointer pages: 106, data page slots: 172632 
    Data pages: 172616, average fill: 69% 
    Primary pages: 172616, secondary pages: 0, swept pages: 88444 
    Empty pages: 622, full pages: 92188 
    Fill distribution: 
     0 - 19% = 2025 
    20 - 39% = 9865 
    40 - 59% = 29631 
    60 - 79% = 75814 
    80 - 99% = 55281 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11613, nodes: 9574128 
    Average node length: 5.17, total dup: 9545691, max dup: 2277 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1891562, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 35 
        20 - 39% = 1565 
        40 - 59% = 7664 
        60 - 79% = 1759 
        80 - 99% = 590 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13479, nodes: 9574128 
    Average node length: 6.24, total dup: 7938826, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1392465, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 169 
        20 - 39% = 3987 
        40 - 59% = 4312 
        60 - 79% = 2636 
        80 - 99% = 2375 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12219, nodes: 9574128 
    Average node length: 5.43, total dup: 9144407, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2022111, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 32 
        20 - 39% = 1505 
        40 - 59% = 8543 
        60 - 79% = 1553 
        80 - 99% = 586 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10033, nodes: 9574128 
    Average node length: 5.14, total dup: 9574028, max dup: 157971 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1490205, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 42 
        20 - 39% = 1248 
        40 - 59% = 5013 
        60 - 79% = 1655 
        80 - 99% = 2075 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.28, total records: 569022 
    Average version length: 68.89, total versions: 7334, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 7960 
    Data pages: 7960, average fill: 75% 
    Primary pages: 7960, secondary pages: 0, swept pages: 3986 
    Empty pages: 7, full pages: 6483 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 35 
    40 - 59% = 269 
    60 - 79% = 7520 
    80 - 99% = 127 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43551, depth: 3, leaf buckets: 725, nodes: 569022 
    Average node length: 5.94, total dup: 484537, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.06, average data length: 0.94 
    Clustering factor: 99170, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 39 
        40 - 59% = 502 
        60 - 79% = 84 
        80 - 99% = 100 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 33366, depth: 3, leaf buckets: 749, nodes: 569022 
    Average node length: 6.15, total dup: 466670, max dup: 25 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 99226, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 37 
        40 - 59% = 521 
        60 - 79% = 87 
        80 - 99% = 104 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 576, nodes: 569022 
    Average node length: 4.86, total dup: 568922, max dup: 9271 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 88121, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 33 
        40 - 59% = 348 
        60 - 79% = 96 
        80 - 99% = 99 
 
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 Thu Apr 11 19:11:57 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7725529 80707 1 0.0000 0.0000
DOC_LIST 2224541 80553 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 256061 671 64000.0000 0.0000
INVNT_TURNOVER_LOG 47458 42528 1 0.0000 0.0000
MONEY_SALDO 49 18110 940 36900.0000 0.0000
MONEY_TURNOVER_LOG 1042 908 1 0.0000 0.0000
PDISTR 830035 70991 4 0.0000 0.0000
PERF_SPLIT_0 178413 11447 1 0.0000 0.0000
PERF_SPLIT_1 184001 15596 1 0.0000 0.0000
PERF_SPLIT_2 184327 14142 1 0.0000 0.0000
PERF_SPLIT_3 194366 18298 1 0.0000 0.0000
PERF_SPLIT_4 192761 20035 1 0.0000 0.0000
PERF_SPLIT_5 188377 20604 1 0.0000 0.0000
PERF_SPLIT_6 189710 8126 1 0.0000 0.0000
PERF_SPLIT_7 187424 12785 1 0.0000 0.0000
PERF_SPLIT_8 180681 11457 1 0.0000 0.0000
PERF_SPLIT_9 211100 30796 1 0.0000 0.0000
PSTORNED 2083577 42641 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 138658 53859 1 0.0000 0.0000
XQD_1000_3300 7232697 436497 1 0.0000 0.0000
XQD_1200_2000 12149444 323353 1 0.0000 0.0000
XQD_2000_3300 1658228 625898 1 0.0000 0.0000
XQD_2100_3300 1062180 451178 1 0.0000 0.0000
XQD_3300_3400 9106187 441881 1 0.0000 0.0000
XQS_1000_1200 21129703 11567 1 0.0000 0.0000
XQS_1000_3300 9464845 352757 1 0.0000 0.0000
XQS_1200_2000 11227776 358450 1 0.0000 0.0000
XQS_2100_3300 9574128 348134 1 0.0000 0.0000
XQS_3300_3400 569022 7334 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 ---
:1079: 
:1080: mscs-test-161.budzdorov.ru    Thu Apr 11 19:09:55 2024
:1081:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1082: 
--- end of diff output ---

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

11.04.24 19:12:08. 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-04-11 19:12:11 No severe PSQL-related problems occured
11.04.24 19:12:12. End of report.