Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.04.2024 16: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 15483788 kB
MemAvailable 30030976 kB
Buffers 0 kB
Cached 16237968 kB
SwapCached 2740 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-14 16:09:50
DTS_END                         2024-04-14 16:09:50.9410
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35920
TRN_ID                          175967
ATT_ID                          573
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: 9138.82 17371 913882
customer order: creation 180.52 366 18052
customer order: refuse 15.19 342 1519
order to supplier: creation 47.66 1318 4766
order to supplier: removal 3.44 104245 344
invoice (draft): creation 47.73 3013 4773
invoice (draft): removal 49.55 857 4955
invoice accept: apply 42.73 19484 4273
invoice accept: cancel 44.01 909 4401
customer reserve: creation 4113.62 186 411362
customer reserve: removal 4297.60 66 429760
realization accept: apply 86.01 203 8601
realization accept: cancel 77.62 145 7762
payment from customer: creation 60.66 118 6066
payment from customer: removal 5.78 85 578
payment to supplier: creation 50.76 130 5076
payment to supplier: removal 3.50 98 350
service: total inventory turnovers 4.92 1113 492
service: total monetary turnovers 6.55 45 655
service: aggregate perf. data 0.94 17690 94
service: refresh index statistics 0.03 197007 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-04-2024 16:11:18 to 14-04-2024 16:11:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1971
TEST_TIME 2 2788
TEST_TIME 3 3300
TEST_TIME 4 3370
TEST_TIME 5 4435
TEST_TIME 6 4042
TEST_TIME 7 4524
TEST_TIME 8 4860
TEST_TIME 9 5567
TEST_TIME 10 5793
TEST_TIME 11 5899
TEST_TIME 12 6201
TEST_TIME 13 6300
TEST_TIME 14 6467
TEST_TIME 15 6405
TEST_TIME 16 6418
TEST_TIME 17 6397
TEST_TIME 18 6596
TEST_TIME 19 6821
TEST_TIME 20 7011
TEST_TIME 21 7426
TEST_TIME 22 7410
TEST_TIME 23 7599
TEST_TIME 24 7467
TEST_TIME 25 7811
TEST_TIME 26 7955
TEST_TIME 27 7932
TEST_TIME 28 8482
TEST_TIME 29 9523
TEST_TIME 30 9505
TEST_TIME 31 9323
TEST_TIME 32 9256
TEST_TIME 33 9471
TEST_TIME 34 9348
TEST_TIME 35 9301
TEST_TIME 36 9428
TEST_TIME 37 9534
TEST_TIME 38 9426
TEST_TIME 39 9304
TEST_TIME 40 9237
TEST_TIME 41 9351
TEST_TIME 42 9228
TEST_TIME 43 9170
TEST_TIME 44 9134
TEST_TIME 45 9127
TEST_TIME 46 9130
TEST_TIME 47 9245
TEST_TIME 48 9254
TEST_TIME 49 9166
TEST_TIME 50 9029
TEST_TIME 51 9124
TEST_TIME 52 9110
TEST_TIME 53 9037
TEST_TIME 54 9007
TEST_TIME 55 8988
TEST_TIME 56 8956
TEST_TIME 57 8925
TEST_TIME 58 8974
TEST_TIME 59 8929
TEST_TIME 60 9001
TEST_TIME 61 9030
TEST_TIME 62 9065
TEST_TIME 63 9101
TEST_TIME 64 9066
TEST_TIME 65 9095
TEST_TIME 66 9126
TEST_TIME 67 9257
TEST_TIME 68 9351
TEST_TIME 69 9322
TEST_TIME 70 9385
TEST_TIME 71 9323
TEST_TIME 72 9244
TEST_TIME 73 9175
TEST_TIME 74 9153
TEST_TIME 75 9097
TEST_TIME 76 9087
TEST_TIME 77 9045
TEST_TIME 78 9119
TEST_TIME 79 9130
TEST_TIME 80 9106
TEST_TIME 81 9189
TEST_TIME 82 9180
TEST_TIME 83 9207
TEST_TIME 84 9241
TEST_TIME 85 9346
TEST_TIME 86 9331
TEST_TIME 87 9355
TEST_TIME 88 9421
TEST_TIME 89 9462
TEST_TIME 90 9443
TEST_TIME 91 9348
TEST_TIME 92 9303
TEST_TIME 93 9271
TEST_TIME 94 9273
TEST_TIME 95 9240
TEST_TIME 96 9171
TEST_TIME 97 9151
TEST_TIME 98 9134
TEST_TIME 99 9192
TEST_TIME 100 9146

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-04-2024 16:11:22 to 14-04-2024 16:11:25.

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 1290308 1290308 0 0.00 0 25514 7 0 0
doc_list_biud 1290306 1290306 0 0.00 0 30278 28 0 0
sp_add_invoice_to_stock 4416 4273 143 3.23 49 218261 19484 0 143
sp_cancel_adding_invoice 4401 4401 0 0.00 4 67110 910 0 0
sp_cancel_client_order 1519 1519 0 0.00 4 9074 343 0 0
sp_cancel_customer_reserve 429760 429760 0 0.00 0 30059 66 0 0
sp_cancel_pay_from_customer 578 578 0 0.00 3 10086 86 0 0
sp_cancel_pay_to_supplier 350 350 0 0.00 3 4252 98 0 0
sp_cancel_supplier_invoice 4968 4955 13 0.26 2 19905 858 0 13
sp_cancel_supplier_order 344 344 0 0.00 6 899909 104245 0 0
sp_cancel_write_off 7762 7762 0 0.00 1 12757 145 0 0
sp_client_order 18052 18052 0 0.00 3 29761 367 0 0
sp_customer_reserve 411362 411362 0 0.00 0 132734 186 0 0
sp_fill_shopping_cart 27586 27586 0 0.00 1 20910 39 0 0
sp_fill_shopping_cart_clo_res 411349 411349 0 0.00 0 29741 15 0 0
sp_get_clo_for_invoice 4260 4260 0 0.00 0 24166 290 0 0
sp_kill_cost_storno 13091 13091 0 0.00 0 10906 67 0 0
sp_kill_qstorno_ret_qs2qd 872581 872581 0 0.00 0 30049 36 0 0
sp_kill_qty_storno 461601 461601 0 0.00 0 30277 78 0 0
sp_lock_selected_doc 17744 17744 0 0.00 0 8339 5 0 0
sp_make_cost_storno 24003 24003 0 0.00 0 25442 60 0 0
sp_multiply_rows_for_pdistr 24001 24001 0 0.00 0 11980 28 0 0
sp_multiply_rows_for_qdistr 18052 18052 0 0.00 0 19216 164 0 0
sp_pay_from_customer 6066 6066 0 0.00 4 12167 119 0 0
sp_pay_to_supplier 5076 5076 0 0.00 5 25634 130 0 0
sp_payment_common 11141 11141 0 0.00 1 12157 27 0 0
sp_qd_handle_on_cancel_clo 1519 1519 0 0.00 0 8142 310 0 0
sp_qd_handle_on_invoice_upd_sts 8660 8660 0 0.00 0 30276 341 0 0
sp_qd_handle_on_reserve_upd_sts 8601 8601 0 0.00 0 17106 71 0 0
sp_reserve_write_off 8601 8601 0 0.00 7 17331 203 0 0
sp_supplier_invoice 4773 4773 0 0.00 6 110238 3013 0 0
sp_supplier_order 4766 4766 0 0.00 5 32664 1318 0 0
srv_aggregate_perf_data 94 94 0 0.00 1699 249608 17691 0 0
srv_fill_mon_cache_memory 56 56 0 0.00 1337 114656 38203 0 0
srv_find_qd_qs_mism 869923 869923 0 0.00 0 20113 6 0 0
srv_make_invnt_saldo 492 492 0 0.00 38 56595 1114 0 0
srv_make_money_saldo 655 655 0 0.00 0 10418 45 0 0
srv_recalc_idx_stat 3 3 0 0.00 154606 224557 197007 0 0
t$perf-abend:sp_add_invoice_to_stock 143 143 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4273 4273 0 0.00 0 8752 160 0 0
t$perf-norm:sp_cancel_adding_invoice 347 347 0 0.00 0 3379 86 0 0
t$perf-norm:sp_cancel_client_order 1519 1519 0 0.00 0 1433 10 0 0
t$perf-norm:sp_cancel_customer_reserve 618 618 0 0.00 0 914 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 578 578 0 0.00 0 1405 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 350 350 0 0.00 0 1184 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 341 341 0 0.00 0 2964 23 0 0
t$perf-norm:sp_cancel_supplier_order 344 344 0 0.00 0 21627 1648 0 0
t$perf-norm:sp_cancel_write_off 788 788 0 0.00 0 4635 24 0 0
t$perf-norm:sp_client_order 18052 18052 0 0.00 0 14411 16 0 0
t$perf-norm:sp_customer_reserve 866 866 0 0.00 0 3118 12 0 0
t$perf-norm:sp_pay_from_customer 6066 6066 0 0.00 0 3816 11 0 0
t$perf-norm:sp_pay_to_supplier 5076 5076 0 0.00 0 4394 9 0 0
t$perf-norm:sp_reserve_write_off 8601 8601 0 0.00 0 18638 12 0 0
t$perf-norm:sp_supplier_invoice 4773 4773 0 0.00 0 17102 27 0 0
t$perf-norm:sp_supplier_order 4766 4766 0 0.00 0 4534 18 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 220 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 56 56 0 0.00 0 252 7 0 0
t$perf-norm:srv_make_invnt_saldo 492 492 0 0.00 0 1246 24 0 0
t$perf-norm:srv_make_money_saldo 655 655 0 0.00 0 2693 23 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 13 6 0 0
v_add_invoice_to_stock 8802 8516 286 3.24 0 5561 19 0 286
v_all_customers 33362 33362 0 0.00 0 32 1 0 0
v_all_suppliers 27020 27020 0 0.00 0 46 1 0 0
v_all_wares 36104 36104 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 694 694 0 0.00 0 3341 20 0 0
v_cancel_client_order 3038 3038 0 0.00 0 8986 11 0 0
v_cancel_customer_prepayment 1156 1156 0 0.00 0 9943 18 0 0
v_cancel_customer_reserve 1236 1236 0 0.00 0 1747 6 0 0
v_cancel_payment_to_supplier 700 700 0 0.00 0 2320 12 0 0
v_cancel_supplier_invoice 708 682 26 3.67 0 892 13 0 26
v_cancel_supplier_order 688 688 0 0.00 0 536 3 0 0
v_cancel_write_off 1576 1576 0 0.00 0 12665 21 0 0
v_max_id_clo_ord 4765 4765 0 0.00 0 2514 3 0 0
v_max_id_clo_res 866 866 0 0.00 0 3673 26 0 0
v_max_id_ord_sup 4769 4769 0 0.00 0 3811 5 0 0
v_max_non_paid_invoice 1100 1100 0 0.00 0 1257 6 0 0
v_max_non_paid_realizn 3009 3009 0 0.00 0 6111 6 0 0
v_min_id_clo_ord 4765 4765 0 0.00 0 3750 11 0 0
v_min_id_clo_res 866 866 0 0.00 0 6710 13 0 0
v_min_id_ord_sup 4769 4769 0 0.00 0 11691 9 0 0
v_min_non_paid_invoice 5076 5076 0 0.00 0 8836 17 0 0
v_min_non_paid_realizn 6065 6065 0 0.00 0 8896 21 0 0
v_our_firm 8854 8854 0 0.00 0 17 1 0 0
v_reserve_write_off 17202 17202 0 0.00 0 10856 10 0 0
x_lock_depdocs_on_canc_invoice 9015 9015 0 0.00 0 11922 134 0 0
x_lock_depdocs_on_canc_sup_ord 344 344 0 0.00 0 2692 285 0 0
x_make_qstorno_1000_1200 4766 4766 0 0.00 2 32653 1228 0 0
x_make_qstorno_1200_2000 4773 4773 0 0.00 3 110227 2879 0 0
x_make_qstorno_2100_3300 411362 411362 0 0.00 0 132732 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-04-2024 16:11:26 to 14-04-2024 16:11:30.

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
14:09:54 2 8192000000 8797116944 8807743488 3953616 0.048 1 1 2 0 4051888 55488 42784
14:10:55 22761 8192000000 9908692432 10217861120 993053648 10.811 100 93 184 0 1021893984 5577152 23263184
14:12:20 20681 8192000000 9945073040 10265468928 1026104320 11.131 100 88 176 1 1057908432 8498784 23305328
14:13:43 13502 8192000000 9971769104 10298851328 1051085600 11.371 100 88 176 0 1083027008 9780176 22161232
14:15:00 11707 8192000000 10006399280 10347655168 1097544096 11.814 100 82 163 0 1127541056 10090448 19906512
14:16:16 8070 8192000000 10053999440 10411118592 1144289104 12.256 100 79 158 0 1174324672 11151216 18884352
14:17:28 3071 8192000000 10113471712 10477633536 1199485568 12.772 100 77 154 2 1229744176 13165328 17093280
14:18:37 2090 8192000000 10148816480 10527285248 1239191344 13.139 100 81 162 0 1271201296 12493984 19515968
14:19:41 1141 8192000000 10181767968 10563915776 1269448560 13.417 100 89 174 0 1302604368 12844160 20311648
14:20:45 848 8192000000 10207371600 10592432128 1291915648 13.622 100 91 180 1 1325493376 13506320 20071408
14:21:47 853 8192000000 10210223136 10598928384 1299841424 13.694 100 77 155 1 1329103600 11556720 17705456
14:22:50 24516 8192000000 10192056368 10604761088 1305584912 13.746 100 26 53 1 1317551440 5525024 6441504
14:24:15 6612 8192000000 10202160976 10619236352 1318631776 13.864 100 21 42 0 1328762096 5544640 4585680
14:25:26 12089 8192000000 10203627264 10622824448 1319700704 13.874 100 12 24 0 1327776528 5230176 2845648
14:26:41 74976 8192000000 10209829312 10636111872 1325703392 13.928 100 33 65 0 1338481232 4631296 8146544
14:28:58 4300 8192000000 10220752784 10640519168 1318847456 13.866 99 36 71 0 1332936720 6141680 7947584
14:30:10 46460 8192000000 10214410160 10624614400 1294152848 13.642 98 37 72 0 1308984752 6471168 8360736
14:32:07 29466 8192000000 10245791520 10650808320 1321072000 13.886 99 53 105 0 1348786592 15595760 12118832
14:33:48 60073 8192000000 10222591328 10652377088 1327924928 13.948 100 31 62 0 1347219280 11731488 7562864
14:35:55 40121 8192000000 10211250864 10635980800 1287217104 13.579 97 33 65 0 1309003296 13864752 7921440
14:38:01 11723 8192000000 10234550992 10637135872 1293854096 13.639 98 53 104 1 1320906048 15131088 11920864
14:39:19 9948 8192000000 10244802656 10652590080 1313008544 13.813 99 60 118 1 1345516576 18993312 13514720
14:40:48 14396 8192000000 10240294176 10644795392 1321612928 13.891 100 53 106 1 1349297328 15605712 12078688
14:42:09 7373 8192000000 10259463520 10658693120 1313894976 13.821 99 67 132 0 1354094448 25441984 14757488
14:43:23 6295 8192000000 10271419600 10681331712 1340736720 14.064 100 46 93 0 1375718560 23820976 11160864
14:44:35 2976 8192000000 10272948384 10674864128 1335222080 14.014 100 58 116 0 1377710480 28054208 14434192
14:45:43 4661 8192000000 10280270560 10676682752 1335036608 14.013 99 69 133 2 1379158000 28397328 15724064
14:46:52 4880 8192000000 10312663040 10710986752 1361966000 14.255 100 87 167 2 1419415408 36522160 20927248
14:48:06 1890 8192000000 10338092208 10733015040 1370644304 14.333 100 89 178 0 1437945056 45377264 21923488
14:49:11 3222 8192000000 10338825424 10746646528 1380629776 14.422 100 73 144 0 1444910976 46584080 17697120
14:50:20 1336 8192000000 10356831456 10761883648 1387376624 14.482 100 90 180 2 1460722112 50741728 22603760
14:51:27 5274 8192000000 10342956336 10768613376 1390339664 14.509 100 42 78 1 1444265056 43622880 10302512
14:52:36 7121 8192000000 10350627904 10778320896 1405463216 14.644 100 43 84 0 1461198240 44108608 11626416
14:53:49 8726 8192000000 10355488912 10783186944 1408577760 14.671 100 39 78 0 1467326272 48225328 10523184
14:55:15 21873 8192000000 10333328352 10771787776 1386570224 14.475 100 30 60 0 1443918384 48741712 8606448
14:56:39 33390 8192000000 10327732704 10773147648 1374780272 14.370 100 20 40 0 1438513408 56749504 6983632
14:58:19 19849 8192000000 10294443568 10752716800 1373166256 14.355 99 25 50 0 1403660048 24427632 6066160
15:00:19 36037 8192000000 10303897344 10744741888 1392213104 14.526 100 28 57 0 1405511968 8005408 5293456
15:01:56 42556 8192000000 10300453456 10755170304 1389880864 14.505 100 14 28 0 1405314160 12005472 3427824
15:03:45 37486 8192000000 10310529792 10748678144 1377832032 14.397 99 40 79 0 1399404880 12889776 8683072
15:05:26 46895 8192000000 10313774752 10777964544 1397611344 14.574 100 5 10 0 1416500224 18264800 624080
15:07:21 114656 8192000000 10320467072 10768433152 1405715328 14.646 100 39 77 0 1422850896 7996160 9139408
15:10:21 31574 8192000000 10315182592 10769764352 1398066816 14.578 99 45 84 1 1421938096 14747136 9124144
15:11:56 15220 8192000000 10300645808 10753376256 1388004800 14.488 99 25 50 0 1402675808 9252256 5418752
15:13:14 30136 8192000000 10342518144 10794426368 1424802496 14.815 100 22 44 0 1442566528 12424592 5339440
15:14:49 57895 8192000000 10313439024 10765606912 1384136128 14.454 97 19 39 0 1404137296 15327120 4674048
15:16:52 97566 8192000000 10290935984 10748510208 1341871280 14.074 95 16 32 0 1362878384 17744016 3263088
15:19:56 81065 8192000000 10253227248 10711908352 1283548208 13.545 93 13 26 0 1303137040 16796688 2792144
15:22:17 32294 8192000000 10236762032 10675183616 1283724640 13.547 94 35 71 1 1298210736 6146064 8340032
15:23:54 68051 8192000000 10266939600 10723012608 1362006832 14.255 100 17 34 0 1378814336 13115120 3692384
15:26:11 48790 8192000000 10251103824 10702319616 1306017328 13.750 95 16 32 0 1322248656 12749424 3481904
15:28:01 19313 8192000000 10262619984 10713362432 1347948160 14.129 99 38 76 1 1367107280 10513744 8645376
15:29:22 17682 8192000000 10240279888 10684608512 1319158384 13.869 98 21 42 0 1336364448 12426912 4779152
15:30:41 37425 8192000000 10267065760 10705010688 1330349136 13.970 98 39 78 1 1347397728 9070944 7977648
15:32:19 31118 8192000000 10243791904 10687983616 1316895984 13.849 98 28 56 0 1333006032 9834512 6275536
15:34:06 51020 8192000000 10268401280 10701336576 1347292112 14.123 100 49 98 1 1375323536 17818480 10212944
15:36:05 72215 8192000000 10261929088 10716889088 1314969456 13.831 97 23 46 0 1338102288 18214464 4918368
15:38:22 46754 8192000000 10256602096 10690306048 1299000192 13.686 96 24 49 0 1318585824 14147872 5437760
15:40:11 109031 8192000000 10269645264 10713542656 1361630000 14.252 100 26 51 1 1378053984 11221744 5202240
15:44:01 78402 8192000000 10275564656 10732564480 1384227216 14.454 100 19 38 0 1398496560 9655232 4614112
15:46:25 46939 8192000000 10290558768 10741538816 1376511600 14.385 99 24 48 0 1393356800 11105952 5739248
15:48:16 37307 8192000000 10283169760 10743971840 1383617920 14.449 100 29 58 0 1403274016 12617648 7038448
15:49:53 38990 8192000000 10301863888 10749628416 1387048032 14.480 100 24 48 0 1403777216 10444976 6284208
15:51:35 56649 8192000000 10308630544 10767761408 1400204464 14.597 100 26 52 0 1418780992 12711808 5864720
15:53:41 32121 8192000000 10311048640 10764632064 1400741840 14.602 100 27 54 0 1418604480 11830736 6031904
15:55:15 43214 8192000000 10315621488 10767036416 1393404640 14.536 99 16 32 0 1404632720 7869072 3359008
15:57:25 68418 8192000000 10326914848 10797432832 1396329680 14.562 99 7 14 0 1415010208 16948576 1731952
15:59:49 89880 8192000000 10301336720 10752233472 1374887536 14.371 98 24 49 0 1391105120 10441120 5776464
16:02:25 21880 8192000000 10294605536 10754555904 1380083424 14.417 99 20 36 2 1393470944 9206432 4181088
16:03:49 51513 8192000000 10257464592 10717392896 1331292464 13.979 97 17 35 0 1344517776 9326480 3898832
16:05:44 28972 8192000000 10263206752 10727903232 1366961424 14.300 100 6 10 0 1383881072 15624048 1295600
16:07:44 79168 8192000000 10245670304 10697945088 1304341792 13.735 96 16 32 0 1318454992 10261888 3851312

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 14-04-2024 16:11:32 to 14-04-2024 16:11:46.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 143 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-04-2024 16:11:47 to 14-04-2024 16:11:49.

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          174721
MON$OLDEST_ACTIVE               176677
MON$OLDEST_SNAPSHOT             176677
MON$NEXT_TRANSACTION            176677
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                       1908256
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 Sun Apr 14 16:11:50 2024 
 
Database header page information: 
    Flags            0 
    Generation        91938 
    System Change Number    0 
    Page size        8192 
    ODS version        12.0 
    Oldest transaction    174721 
    Oldest active        176677 
    Oldest snapshot        176677 
    Next transaction    176678 
    Sequence number        0 
    Next attachment ID    716 
    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.49, total records: 7770046 
    Average version length: 48.17, total versions: 65898, 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: 87104 
    Data pages: 87104, average fill: 71% 
    Primary pages: 87104, secondary pages: 0, swept pages: 24133 
    Empty pages: 1, full pages: 61632 
    Fill distribution: 
     0 - 19% = 21 
    20 - 39% = 217 
    40 - 59% = 2733 
    60 - 79% = 84109 
    80 - 99% = 24 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510614, depth: 3, leaf buckets: 23384, nodes: 7770046 
    Average node length: 18.89, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.09, average data length: 12.91 
    Clustering factor: 1717061, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 379 
        20 - 39% = 1763 
        40 - 59% = 4234 
        60 - 79% = 2369 
        80 - 99% = 14639 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528118, depth: 3, leaf buckets: 13579, nodes: 7770046 
    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: 1539490, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1594 
        40 - 59% = 2102 
        60 - 79% = 1084 
        80 - 99% = 8799 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546711, depth: 3, leaf buckets: 8368, nodes: 7770046 
    Average node length: 6.62, total dup: 5806223, max dup: 49 
    Average key length: 3.63, compression ratio: 2.48 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1532445, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 143 
        20 - 39% = 966 
        40 - 59% = 1377 
        60 - 79% = 918 
        80 - 99% = 4964 
 
DOC_LIST (138) 
    Primary pointer page: 472, Index root page: 473 
    Total formats: 1, used formats: 1 
    Average record length: 56.57, total records: 2254754 
    Average version length: 34.78, total versions: 68780, max versions: 3 
    Average fragment length: 8.00, total fragments: 1, max fragments: 1 
    Average unpacked length: 84.00, compression ratio: 1.48 
    Pointer pages: 18, data page slots: 28448 
    Data pages: 28448, average fill: 73% 
    Primary pages: 28442, secondary pages: 6, swept pages: 12568 
    Empty pages: 3, full pages: 20589 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 111 
    40 - 59% = 1582 
    60 - 79% = 26233 
    80 - 99% = 502 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541130, depth: 3, leaf buckets: 4584, nodes: 2254754 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 694020, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 953 
        40 - 59% = 846 
        60 - 79% = 711 
        80 - 99% = 2074 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544376, depth: 3, leaf buckets: 2529, nodes: 2257013 
    Average node length: 4.97, total dup: 2256115, max dup: 18566 
    Average key length: 2.01, compression ratio: 4.47 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1247978, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 239 
        40 - 59% = 1567 
        60 - 79% = 547 
        80 - 99% = 173 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545909, depth: 3, leaf buckets: 2115, nodes: 2254754 
    Average node length: 4.97, total dup: 2254704, max dup: 130355 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1062218, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 107 
        40 - 59% = 1200 
        60 - 79% = 41 
        80 - 99% = 763 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538187, depth: 3, leaf buckets: 4338, nodes: 2254754 
    Average node length: 11.40, total dup: 0, max dup: 0 
    Average key length: 8.44, compression ratio: 1.07 
    Average prefix length: 3.56, average data length: 5.44 
    Clustering factor: 694020, ratio: 0.31 
    Fill distribution: 
         0 - 19% = 96 
        20 - 39% = 589 
        40 - 59% = 599 
        60 - 79% = 802 
        80 - 99% = 2252 
 
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.44, total records: 400 
    Average version length: 22.84, total versions: 241865, max versions: 631 
    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: 1336 
    Data pages: 1336, average fill: 90% 
    Primary pages: 12, secondary pages: 1324, swept pages: 0 
    Empty pages: 5, full pages: 1330 
    Fill distribution: 
     0 - 19% = 6 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1330 
 
    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: 1.09, total records: 108614 
    Average version length: 68.29, total versions: 106881, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 80.67 
    Pointer pages: 7, data page slots: 2064 
    Data pages: 1960, average fill: 70% 
    Primary pages: 1959, secondary pages: 1, swept pages: 0 
    Empty pages: 154, full pages: 1258 
    Fill distribution: 
     0 - 19% = 230 
    20 - 39% = 188 
    40 - 59% = 166 
    60 - 79% = 193 
    80 - 99% = 1183 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1705929, depth: 3, leaf buckets: 370, nodes: 108614 
    Average node length: 13.15, total dup: 7313, max dup: 2 
    Average key length: 10.66, compression ratio: 2.53 
    Average prefix length: 19.27, average data length: 7.73 
    Clustering factor: 78963, ratio: 0.73 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 52 
        40 - 59% = 275 
        60 - 79% = 40 
        80 - 99% = 2 
 
MONEY_SALDO (141) 
    Primary pointer page: 478, Index root page: 479 
    Total formats: 1, used formats: 1 
    Average record length: 15.18, total records: 49 
    Average version length: 9.00, total versions: 17839, max versions: 944 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.11 
    Pointer pages: 1, data page slots: 64 
    Data pages: 64, average fill: 89% 
    Primary pages: 1, secondary pages: 63, swept pages: 0 
    Empty pages: 0, full pages: 63 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 7 
    80 - 99% = 56 
 
    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: 2.17, total records: 1702 
    Average version length: 43.26, total versions: 1613, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 26.71 
    Pointer pages: 1, data page slots: 32 
    Data pages: 31, average fill: 55% 
    Primary pages: 30, secondary pages: 1, swept pages: 0 
    Empty pages: 0, full pages: 11 
    Fill distribution: 
     0 - 19% = 8 
    20 - 39% = 2 
    40 - 59% = 7 
    60 - 79% = 4 
    80 - 99% = 10 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 91217, depth: 2, leaf buckets: 3, nodes: 1702 
    Average node length: 4.53, total dup: 1604, max dup: 146 
    Average key length: 2.61, compression ratio: 7.28 
    Average prefix length: 18.45, average data length: 0.55 
    Clustering factor: 931, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 2, used formats: 1 
    Average record length: 97.15, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 112.00, compression ratio: 1.15 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 50% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504215, depth: 1, leaf buckets: 1, nodes: 72 
    Average node length: 11.69, total dup: 0, max dup: 0 
    Average key length: 10.68, compression ratio: 0.84 
    Average prefix length: 1.31, average data length: 7.69 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 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.31, total records: 794161 
    Average version length: 26.12, total versions: 56280, max versions: 4 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.49 
    Pointer pages: 5, data page slots: 8048 
    Data pages: 8040, average fill: 69% 
    Primary pages: 8010, secondary pages: 30, swept pages: 1799 
    Empty pages: 93, full pages: 6644 
    Fill distribution: 
     0 - 19% = 193 
    20 - 39% = 115 
    40 - 59% = 259 
    60 - 79% = 7292 
    80 - 99% = 181 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509308, depth: 2, leaf buckets: 879, nodes: 794161 
    Average node length: 4.87, total dup: 794112, max dup: 145328 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 89238, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 134 
        40 - 59% = 482 
        60 - 79% = 198 
        80 - 99% = 62 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508613, depth: 3, leaf buckets: 961, nodes: 794161 
    Average node length: 5.88, total dup: 707127, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159605, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 127 
        40 - 59% = 444 
        60 - 79% = 129 
        80 - 99% = 261 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509187, depth: 3, leaf buckets: 996, nodes: 794161 
    Average node length: 5.88, total dup: 707127, max dup: 42 
    Average key length: 3.02, compression ratio: 7.29 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161518, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 199 
        40 - 59% = 421 
        60 - 79% = 112 
        80 - 99% = 262 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510178, depth: 3, leaf buckets: 1133, nodes: 794161 
    Average node length: 5.96, total dup: 707127, max dup: 42 
    Average key length: 3.10, compression ratio: 5.49 
    Average prefix length: 16.01, average data length: 0.99 
    Clustering factor: 154675, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 249 
        40 - 59% = 598 
        60 - 79% = 201 
        80 - 99% = 83 
 
PERF_AGG (158) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 62.77, total records: 5468 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 2.63, total fragments: 75, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 96 
    Data pages: 96, average fill: 57% 
    Primary pages: 76, secondary pages: 20, swept pages: 60 
    Empty pages: 11, full pages: 61 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 0 
    40 - 59% = 4 
    60 - 79% = 68 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504238, depth: 2, leaf buckets: 6, nodes: 5468 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.57, compression ratio: 10.08 
    Average prefix length: 34.46, average data length: 1.54 
    Clustering factor: 5162, ratio: 0.94 
    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: 5468 
    Average node length: 11.12, total dup: 0, max dup: 0 
    Average key length: 9.21, compression ratio: 0.98 
    Average prefix length: 2.79, average data length: 6.21 
    Clustering factor: 147, 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.09, total records: 81150 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 784 
    Data pages: 784, average fill: 71% 
    Primary pages: 784, secondary pages: 0, swept pages: 0 
    Empty pages: 1, full pages: 781 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 781 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 35713, depth: 2, leaf buckets: 105, nodes: 81150 
    Average node length: 10.16, total dup: 0, max dup: 0 
    Average key length: 8.17, compression ratio: 1.10 
    Average prefix length: 3.83, average data length: 5.17 
    Clustering factor: 2994, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 101 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504239, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 1, used formats: 1 
    Average record length: 111.12, total records: 72 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 57% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 1 
    Average record length: 150.53, total records: 174736 
    Average version length: 142.96, total versions: 592, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.27 
    Pointer pages: 7, data page slots: 5312 
    Data pages: 4176, average fill: 86% 
    Primary pages: 4176, secondary pages: 0, swept pages: 5 
    Empty pages: 28, full pages: 4135 
    Fill distribution: 
     0 - 19% = 33 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4134 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 576, Index root page: 577 
    Total formats: 1, used formats: 1 
    Average record length: 150.21, total records: 161465 
    Average version length: 147.78, total versions: 740, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.29 
    Pointer pages: 7, data page slots: 4848 
    Data pages: 3856, average fill: 86% 
    Primary pages: 3856, secondary pages: 0, swept pages: 4 
    Empty pages: 25, full pages: 3815 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 3 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 3816 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 578, Index root page: 579 
    Total formats: 1, used formats: 1 
    Average record length: 148.21, total records: 169615 
    Average version length: 153.07, total versions: 3257, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.44 
    Pointer pages: 7, data page slots: 4584 
    Data pages: 4072, average fill: 86% 
    Primary pages: 4071, secondary pages: 1, swept pages: 5 
    Empty pages: 42, full pages: 4018 
    Fill distribution: 
     0 - 19% = 50 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 3 
    80 - 99% = 4017 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 580, Index root page: 581 
    Total formats: 1, used formats: 1 
    Average record length: 130.65, total records: 170066 
    Average version length: 154.45, total versions: 22661, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 12.98 
    Pointer pages: 6, data page slots: 4976 
    Data pages: 4064, average fill: 87% 
    Primary pages: 4064, secondary pages: 0, swept pages: 1 
    Empty pages: 21, full pages: 4031 
    Fill distribution: 
     0 - 19% = 24 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 4031 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 582, Index root page: 583 
    Total formats: 1, used formats: 1 
    Average record length: 150.73, total records: 155651 
    Average version length: 140.59, total versions: 448, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 8, data page slots: 4816 
    Data pages: 3768, average fill: 85% 
    Primary pages: 3767, secondary pages: 1, swept pages: 1 
    Empty pages: 67, full pages: 3686 
    Fill distribution: 
     0 - 19% = 75 
    20 - 39% = 6 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 3687 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 584, Index root page: 585 
    Total formats: 1, used formats: 1 
    Average record length: 149.81, total records: 166686 
    Average version length: 149.26, total versions: 1296, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.32 
    Pointer pages: 7, data page slots: 5656 
    Data pages: 4008, average fill: 86% 
    Primary pages: 4008, secondary pages: 0, swept pages: 3 
    Empty pages: 48, full pages: 3945 
    Fill distribution: 
     0 - 19% = 56 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 2 
    80 - 99% = 3944 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 586, Index root page: 587 
    Total formats: 1, used formats: 1 
    Average record length: 150.91, total records: 168344 
    Average version length: 143.94, total versions: 263, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.24 
    Pointer pages: 7, data page slots: 4480 
    Data pages: 4024, average fill: 86% 
    Primary pages: 4024, secondary pages: 0, swept pages: 9 
    Empty pages: 27, full pages: 3988 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 4 
    80 - 99% = 3986 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 588, Index root page: 589 
    Total formats: 1, used formats: 1 
    Average record length: 150.72, total records: 172554 
    Average version length: 143.19, total versions: 381, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.25 
    Pointer pages: 8, data page slots: 5312 
    Data pages: 4136, average fill: 86% 
    Primary pages: 4136, secondary pages: 0, swept pages: 2 
    Empty pages: 41, full pages: 4084 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 2 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 4084 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 590, Index root page: 591 
    Total formats: 1, used formats: 1 
    Average record length: 149.75, total records: 175344 
    Average version length: 149.89, total versions: 1505, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 7, data page slots: 5552 
    Data pages: 4208, average fill: 86% 
    Primary pages: 4207, secondary pages: 1, swept pages: 2 
    Empty pages: 44, full pages: 4148 
    Fill distribution: 
     0 - 19% = 47 
    20 - 39% = 4 
    40 - 59% = 6 
    60 - 79% = 3 
    80 - 99% = 4148 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 149.66, total records: 162738 
    Average version length: 150.49, total versions: 1213, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.33 
    Pointer pages: 6, data page slots: 4392 
    Data pages: 3896, average fill: 86% 
    Primary pages: 3896, secondary pages: 0, swept pages: 5 
    Empty pages: 40, full pages: 3847 
    Fill distribution: 
     0 - 19% = 43 
    20 - 39% = 3 
    40 - 59% = 1 
    60 - 79% = 2 
    80 - 99% = 3847 
 
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.97, total records: 2105438 
    Average version length: 52.92, total versions: 31153, 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: 25480 
    Data pages: 25480, average fill: 71% 
    Primary pages: 25480, secondary pages: 0, swept pages: 11477 
    Empty pages: 258, full pages: 20424 
    Fill distribution: 
     0 - 19% = 498 
    20 - 39% = 373 
    40 - 59% = 1046 
    60 - 79% = 23296 
    80 - 99% = 267 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506186, depth: 3, leaf buckets: 2583, nodes: 2105438 
    Average node length: 5.44, total dup: 1964814, max dup: 1623 
    Average key length: 2.49, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 182040, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 292 
        40 - 59% = 1684 
        60 - 79% = 311 
        80 - 99% = 290 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504819, depth: 3, leaf buckets: 2765, nodes: 2105438 
    Average node length: 5.69, total dup: 1889614, max dup: 72 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.36, average data length: 0.64 
    Clustering factor: 376123, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 7 
        40 - 59% = 2423 
        60 - 79% = 314 
        80 - 99% = 20 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1507996, depth: 3, leaf buckets: 2169, nodes: 2105438 
    Average node length: 4.96, total dup: 2105338, max dup: 27636 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 179914, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 173 
        40 - 59% = 1233 
        60 - 79% = 378 
        80 - 99% = 380 
 
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: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 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: 37.99, total records: 149598 
    Average version length: 69.18, total versions: 67508, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.32 
    Pointer pages: 3, data page slots: 3976 
    Data pages: 2920, average fill: 60% 
    Primary pages: 2920, secondary pages: 0, swept pages: 369 
    Empty pages: 415, full pages: 1696 
    Fill distribution: 
     0 - 19% = 571 
    20 - 39% = 225 
    40 - 59% = 270 
    60 - 79% = 491 
    80 - 99% = 1363 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 102457, depth: 3, leaf buckets: 229, nodes: 149598 
    Average node length: 6.43, total dup: 130066, max dup: 14 
    Average key length: 3.96, compression ratio: 10.61 
    Average prefix length: 40.17, average data length: 1.83 
    Clustering factor: 25481, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 37 
        40 - 59% = 121 
        60 - 79% = 63 
        80 - 99% = 7 
 
XQD_1000_3300 (178) 
    Primary pointer page: 553, Index root page: 554 
    Total formats: 1, used formats: 1 
    Average record length: 65.83, total records: 6922726 
    Average version length: 68.78, total versions: 312664, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.91 
    Pointer pages: 62, data page slots: 100816 
    Data pages: 100816, average fill: 73% 
    Primary pages: 100816, secondary pages: 0, swept pages: 35166 
    Empty pages: 5, full pages: 71489 
    Fill distribution: 
     0 - 19% = 45 
    20 - 39% = 731 
    40 - 59% = 7046 
    60 - 79% = 89000 
    80 - 99% = 3994 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480454, depth: 3, leaf buckets: 10596, nodes: 6922726 
    Average node length: 6.51, total dup: 5987229, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1543850, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 6 
        20 - 39% = 1756 
        40 - 59% = 5790 
        60 - 79% = 2619 
        80 - 99% = 425 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486068, depth: 3, leaf buckets: 8377, nodes: 6922726 
    Average node length: 5.40, total dup: 6643851, max dup: 137 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1349317, ratio: 0.19 
    Fill distribution: 
         0 - 19% = 8 
        20 - 39% = 1196 
        40 - 59% = 4614 
        60 - 79% = 1617 
        80 - 99% = 942 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490608, depth: 3, leaf buckets: 8431, nodes: 6922726 
    Average node length: 5.40, total dup: 6643851, max dup: 137 
    Average key length: 2.41, compression ratio: 7.05 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1351979, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1262 
        40 - 59% = 4555 
        60 - 79% = 1645 
        80 - 99% = 962 
 
XQD_1200_2000 (177) 
    Primary pointer page: 551, Index root page: 552 
    Total formats: 1, used formats: 1 
    Average record length: 67.38, total records: 11881256 
    Average version length: 68.71, total versions: 271351, 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: 103, data page slots: 166752 
    Data pages: 166752, average fill: 76% 
    Primary pages: 166752, secondary pages: 0, swept pages: 87166 
    Empty pages: 7, full pages: 146029 
    Fill distribution: 
     0 - 19% = 31 
    20 - 39% = 503 
    40 - 59% = 4612 
    60 - 79% = 157461 
    80 - 99% = 4145 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495028, depth: 3, leaf buckets: 18282, nodes: 11881256 
    Average node length: 6.57, total dup: 10359376, max dup: 55 
    Average key length: 3.42, compression ratio: 12.27 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2353282, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 15 
        20 - 39% = 2862 
        40 - 59% = 10290 
        60 - 79% = 4293 
        80 - 99% = 822 
 
XQD_2000_3300 (179) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 1, used formats: 1 
    Average record length: 49.60, total records: 1501003 
    Average version length: 69.10, total versions: 424293, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 2.54 
    Pointer pages: 28, data page slots: 44976 
    Data pages: 28296, average fill: 60% 
    Primary pages: 28296, secondary pages: 0, swept pages: 9313 
    Empty pages: 3301, full pages: 16866 
    Fill distribution: 
     0 - 19% = 5313 
    20 - 39% = 2282 
    40 - 59% = 2231 
    60 - 79% = 11909 
    80 - 99% = 6561 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479712, depth: 3, leaf buckets: 2253, nodes: 1501003 
    Average node length: 5.52, total dup: 1440352, max dup: 99 
    Average key length: 2.57, compression ratio: 16.36 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 98672, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 830 
        40 - 59% = 1060 
        60 - 79% = 313 
        80 - 99% = 41 
 
XQD_2100_3300 (180) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 1 
    Average record length: 41.06, total records: 1023397 
    Average version length: 69.14, total versions: 414589, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.07 
    Pointer pages: 21, data page slots: 33008 
    Data pages: 25440, average fill: 47% 
    Primary pages: 25440, secondary pages: 0, swept pages: 6161 
    Empty pages: 4821, full pages: 10635 
    Fill distribution: 
     0 - 19% = 8268 
    20 - 39% = 3540 
    40 - 59% = 2361 
    60 - 79% = 2821 
    80 - 99% = 8450 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479207, depth: 3, leaf buckets: 1483, nodes: 1023397 
    Average node length: 5.80, total dup: 954175, max dup: 99 
    Average key length: 2.88, compression ratio: 14.59 
    Average prefix length: 41.19, average data length: 0.81 
    Clustering factor: 138665, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 425 
        40 - 59% = 687 
        60 - 79% = 310 
        80 - 99% = 60 
 
XQD_3300_3400 (181) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 1 
    Average record length: 66.63, total records: 9174923 
    Average version length: 68.99, total versions: 301651, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.89 
    Pointer pages: 89, data page slots: 145232 
    Data pages: 145160, average fill: 67% 
    Primary pages: 145160, secondary pages: 0, swept pages: 71120 
    Empty pages: 393, full pages: 74426 
    Fill distribution: 
     0 - 19% = 1296 
    20 - 39% = 7830 
    40 - 59% = 25088 
    60 - 79% = 106784 
    80 - 99% = 4162 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472590, depth: 3, leaf buckets: 13494, nodes: 9174923 
    Average node length: 6.69, total dup: 7609746, max dup: 21 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 1948900, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1207 
        40 - 59% = 7062 
        60 - 79% = 4602 
        80 - 99% = 622 
 
XQS_1000_1200 (182) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 1 
    Average record length: 82.50, total records: 21171273 
    Average version length: 82.93, total versions: 9000, 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: 319024 
    Data pages: 319024, average fill: 81% 
    Primary pages: 319024, secondary pages: 0, swept pages: 13128 
    Empty pages: 25, full pages: 318623 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 12 
    40 - 59% = 31 
    60 - 79% = 27694 
    80 - 99% = 291250 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426716, depth: 3, leaf buckets: 19487, nodes: 21171273 
    Average node length: 5.72, total dup: 20689758, max dup: 128 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3284435, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 0 
        40 - 59% = 8307 
        60 - 79% = 568 
        80 - 99% = 10610 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1456980, depth: 3, leaf buckets: 17207, nodes: 21171273 
    Average node length: 6.31, total dup: 18605083, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 916161, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 4 
        40 - 59% = 797 
        60 - 79% = 296 
        80 - 99% = 16103 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441073, depth: 3, leaf buckets: 21246, nodes: 21171273 
    Average node length: 6.35, total dup: 18524088, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3579375, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 1 
        40 - 59% = 8515 
        60 - 79% = 632 
        80 - 99% = 12093 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413348, depth: 3, leaf buckets: 16155, nodes: 21171273 
    Average node length: 5.56, total dup: 21171173, max dup: 230662 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944963, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 9 
        40 - 59% = 2933 
        60 - 79% = 427 
        80 - 99% = 12785 
 
XQS_1000_3300 (184) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 1 
    Average record length: 79.87, total records: 9628265 
    Average version length: 82.59, total versions: 298075, 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: 172984 
    Data pages: 172952, average fill: 69% 
    Primary pages: 172952, secondary pages: 0, swept pages: 93499 
    Empty pages: 928, full pages: 93974 
    Fill distribution: 
     0 - 19% = 2466 
    20 - 39% = 9494 
    40 - 59% = 29544 
    60 - 79% = 76044 
    80 - 99% = 55404 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367502, depth: 3, leaf buckets: 11383, nodes: 9628265 
    Average node length: 5.38, total dup: 9320470, max dup: 176 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2108798, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 71 
        40 - 59% = 8402 
        60 - 79% = 2843 
        80 - 99% = 66 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379261, depth: 3, leaf buckets: 13524, nodes: 9628265 
    Average node length: 6.25, total dup: 7980759, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1442198, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 150 
        20 - 39% = 3975 
        40 - 59% = 4406 
        60 - 79% = 2467 
        80 - 99% = 2526 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373059, depth: 3, leaf buckets: 12713, nodes: 9628265 
    Average node length: 6.00, total dup: 8351544, max dup: 36 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2297188, ratio: 0.24 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 90 
        40 - 59% = 9368 
        60 - 79% = 3170 
        80 - 99% = 85 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362767, depth: 3, leaf buckets: 10123, nodes: 9628265 
    Average node length: 5.15, total dup: 9628165, max dup: 151890 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1494653, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 43 
        20 - 39% = 1276 
        40 - 59% = 5045 
        60 - 79% = 1697 
        80 - 99% = 2062 
 
XQS_1200_2000 (183) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 1 
    Average record length: 80.66, total records: 11357594 
    Average version length: 82.51, total versions: 226652, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.56 
    Pointer pages: 119, data page slots: 193448 
    Data pages: 191888, average fill: 73% 
    Primary pages: 191888, secondary pages: 0, swept pages: 75728 
    Empty pages: 3185, full pages: 142997 
    Fill distribution: 
     0 - 19% = 5479 
    20 - 39% = 7929 
    40 - 59% = 17909 
    60 - 79% = 43471 
    80 - 99% = 117100 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392101, depth: 3, leaf buckets: 13143, nodes: 11357594 
    Average node length: 5.30, total dup: 11247704, max dup: 652 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2366692, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 168 
        40 - 59% = 9030 
        60 - 79% = 3768 
        80 - 99% = 175 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406110, depth: 3, leaf buckets: 10563, nodes: 11357594 
    Average node length: 5.50, total dup: 10862473, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 714126, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 166 
        20 - 39% = 895 
        40 - 59% = 2627 
        60 - 79% = 1873 
        80 - 99% = 5002 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398638, depth: 3, leaf buckets: 15026, nodes: 11357594 
    Average node length: 6.03, total dup: 9910543, max dup: 76 
    Average key length: 2.81, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2383238, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 195 
        40 - 59% = 10516 
        60 - 79% = 4112 
        80 - 99% = 201 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386211, depth: 3, leaf buckets: 10903, nodes: 11357594 
    Average node length: 5.23, total dup: 11357494, max dup: 191323 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 703165, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 85 
        20 - 39% = 828 
        40 - 59% = 4992 
        60 - 79% = 1565 
        80 - 99% = 3433 
 
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: 80.10, total records: 9756064 
    Average version length: 82.93, total versions: 310640, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.57 
    Pointer pages: 108, data page slots: 175784 
    Data pages: 175688, average fill: 69% 
    Primary pages: 175688, secondary pages: 0, swept pages: 94726 
    Empty pages: 962, full pages: 95011 
    Fill distribution: 
     0 - 19% = 2507 
    20 - 39% = 9398 
    40 - 59% = 29992 
    60 - 79% = 78125 
    80 - 99% = 55666 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344686, depth: 3, leaf buckets: 11897, nodes: 9756064 
    Average node length: 5.19, total dup: 9727144, max dup: 2146 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 1924504, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 22 
        20 - 39% = 1584 
        40 - 59% = 7861 
        60 - 79% = 1889 
        80 - 99% = 541 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355717, depth: 3, leaf buckets: 13608, nodes: 9756064 
    Average node length: 6.26, total dup: 8085897, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1421514, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 182 
        20 - 39% = 3886 
        40 - 59% = 4396 
        60 - 79% = 2477 
        80 - 99% = 2667 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350049, depth: 3, leaf buckets: 12544, nodes: 9756064 
    Average node length: 5.44, total dup: 9317894, max dup: 99 
    Average key length: 2.29, compression ratio: 3.93 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2058408, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 27 
        20 - 39% = 1535 
        40 - 59% = 8808 
        60 - 79% = 1653 
        80 - 99% = 521 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 985805, depth: 3, leaf buckets: 10299, nodes: 9756064 
    Average node length: 5.16, total dup: 9755964, max dup: 153724 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1523178, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 41 
        20 - 39% = 1319 
        40 - 59% = 5187 
        60 - 79% = 1678 
        80 - 99% = 2074 
 
XQS_3300_3400 (187) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 1 
    Average record length: 67.61, total records: 576898 
    Average version length: 68.80, total versions: 4746, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.86 
    Pointer pages: 5, data page slots: 8016 
    Data pages: 8016, average fill: 75% 
    Primary pages: 8016, secondary pages: 0, swept pages: 4015 
    Empty pages: 4, full pages: 6761 
    Fill distribution: 
     0 - 19% = 7 
    20 - 39% = 35 
    40 - 59% = 208 
    60 - 79% = 7695 
    80 - 99% = 71 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 45862, depth: 3, leaf buckets: 741, nodes: 576898 
    Average node length: 5.95, total dup: 491060, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 100610, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 29 
        40 - 59% = 514 
        60 - 79% = 109 
        80 - 99% = 88 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 31227, depth: 3, leaf buckets: 764, nodes: 576898 
    Average node length: 6.15, total dup: 473025, max dup: 27 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.88, average data length: 1.12 
    Clustering factor: 100661, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 30 
        40 - 59% = 544 
        60 - 79% = 96 
        80 - 99% = 94 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 375548, depth: 2, leaf buckets: 587, nodes: 576898 
    Average node length: 4.86, total dup: 576798, max dup: 9658 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 89263, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 38 
        40 - 59% = 349 
        60 - 79% = 99 
        80 - 99% = 101 
 
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 Sun Apr 14 16:12:14 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7770046 65898 1 0.0000 0.0000
DOC_LIST 2254754 68780 3 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 241865 631 60400.0000 0.0000
INVNT_TURNOVER_LOG 108614 106881 1 0.0000 0.0000
MONEY_SALDO 49 17839 944 36400.0000 0.0000
MONEY_TURNOVER_LOG 1702 1613 1 0.0000 0.0000
PDISTR 794161 56280 4 0.0000 0.0000
PERF_SPLIT_0 174736 592 1 0.0000 0.0000
PERF_SPLIT_1 161465 740 1 0.0000 0.0000
PERF_SPLIT_2 169615 3257 1 0.0000 0.0000
PERF_SPLIT_3 170066 22661 1 0.0000 0.0000
PERF_SPLIT_4 155651 448 1 0.0000 0.0000
PERF_SPLIT_5 166686 1296 1 0.0000 0.0000
PERF_SPLIT_6 168344 263 1 0.0000 0.0000
PERF_SPLIT_7 172554 381 1 0.0000 0.0000
PERF_SPLIT_8 175344 1505 1 0.0000 0.0000
PERF_SPLIT_9 162738 1213 1 0.0000 0.0000
PSTORNED 2105438 31153 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 149598 67508 1 0.0000 0.0000
XQD_1000_3300 6922726 312664 1 0.0000 0.0000
XQD_1200_2000 11881256 271351 1 0.0000 0.0000
XQD_2000_3300 1501003 424293 1 0.0000 0.0000
XQD_2100_3300 1023397 414589 1 0.0000 0.0000
XQD_3300_3400 9174923 301651 1 0.0000 0.0000
XQS_1000_1200 21171273 9000 1 0.0000 0.0000
XQS_1000_3300 9628265 298075 1 0.0000 0.0000
XQS_1200_2000 11357594 226652 1 0.0000 0.0000
XQS_2100_3300 9756064 310640 1 0.0000 0.0000
XQS_3300_3400 576898 4746 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 ---
:1194: 
:1195: mscs-test-161.budzdorov.ru    Sun Apr 14 16:09:53 2024
:1196:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1197: 
:1198: 
:1199: mscs-test-161.budzdorov.ru    Sun Apr 14 16:09:59 2024
:1200:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1201: 
--- end of diff output ---

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

14.04.24 16:12:25. 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-14 16:12:28 No severe PSQL-related problems occured
14.04.24 16:12:29. End of report.