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

Hardware and OS info

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

Server and database settinfs 


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

Test configuration settings 

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

Test finish info 


FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2024-03-06 07:07:47
DTS_END                         2024-03-06 07:07:47.1280
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/41254
TRN_ID                          173331
ATT_ID                          581
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: 9146.89 20421 914689
customer order: creation 176.24 397 17624
customer order: refuse 14.96 350 1496
order to supplier: creation 46.52 1182 4652
order to supplier: removal 3.45 82740 345
invoice (draft): creation 47.64 2680 4764
invoice (draft): removal 48.01 684 4801
invoice accept: apply 43.30 21171 4330
invoice accept: cancel 43.20 837 4320
customer reserve: creation 4149.29 205 414929
customer reserve: removal 4277.16 53 427716
realization accept: apply 88.59 178 8859
realization accept: cancel 75.44 118 7544
payment from customer: creation 61.46 131 6146
payment from customer: removal 5.60 73 560
payment to supplier: creation 51.03 140 5103
payment to supplier: removal 3.86 64 386
service: total inventory turnovers 3.95 3790 395
service: total monetary turnovers 6.28 487 628
service: aggregate perf. data 0.88 18267 88
service: refresh index statistics 0.03 274878 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-03-2024 07:08:57 to 06-03-2024 07:08:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2474
TEST_TIME 2 3715
TEST_TIME 3 3909
TEST_TIME 4 4487
TEST_TIME 5 4119
TEST_TIME 6 4704
TEST_TIME 7 5594
TEST_TIME 8 5770
TEST_TIME 9 5856
TEST_TIME 10 6003
TEST_TIME 11 6205
TEST_TIME 12 6788
TEST_TIME 13 7114
TEST_TIME 14 7342
TEST_TIME 15 7448
TEST_TIME 16 7769
TEST_TIME 17 7959
TEST_TIME 18 8295
TEST_TIME 19 8018
TEST_TIME 20 8123
TEST_TIME 21 8350
TEST_TIME 22 8535
TEST_TIME 23 9205
TEST_TIME 24 8871
TEST_TIME 25 8814
TEST_TIME 26 8902
TEST_TIME 27 8970
TEST_TIME 28 8894
TEST_TIME 29 8957
TEST_TIME 30 8847
TEST_TIME 31 8777
TEST_TIME 32 8785
TEST_TIME 33 9087
TEST_TIME 34 9118
TEST_TIME 35 9120
TEST_TIME 36 9320
TEST_TIME 37 9308
TEST_TIME 38 9379
TEST_TIME 39 9441
TEST_TIME 40 9550
TEST_TIME 41 9411
TEST_TIME 42 9257
TEST_TIME 43 9116
TEST_TIME 44 9213
TEST_TIME 45 9105
TEST_TIME 46 9167
TEST_TIME 47 9086
TEST_TIME 48 9048
TEST_TIME 49 9037
TEST_TIME 50 8892
TEST_TIME 51 8909
TEST_TIME 52 8956
TEST_TIME 53 9030
TEST_TIME 54 9056
TEST_TIME 55 9023
TEST_TIME 56 9000
TEST_TIME 57 9139
TEST_TIME 58 9202
TEST_TIME 59 9188
TEST_TIME 60 9224
TEST_TIME 61 9248
TEST_TIME 62 9257
TEST_TIME 63 9220
TEST_TIME 64 9287
TEST_TIME 65 9406
TEST_TIME 66 9318
TEST_TIME 67 9193
TEST_TIME 68 9119
TEST_TIME 69 9100
TEST_TIME 70 9022
TEST_TIME 71 8957
TEST_TIME 72 9108
TEST_TIME 73 9102
TEST_TIME 74 9109
TEST_TIME 75 9076
TEST_TIME 76 9187
TEST_TIME 77 9204
TEST_TIME 78 9180
TEST_TIME 79 9199
TEST_TIME 80 9222
TEST_TIME 81 9231
TEST_TIME 82 9265
TEST_TIME 83 9295
TEST_TIME 84 9391
TEST_TIME 85 9441
TEST_TIME 86 9421
TEST_TIME 87 9346
TEST_TIME 88 9297
TEST_TIME 89 9285
TEST_TIME 90 9246
TEST_TIME 91 9184
TEST_TIME 92 9181
TEST_TIME 93 9174
TEST_TIME 94 9155
TEST_TIME 95 9157
TEST_TIME 96 9161
TEST_TIME 97 9157
TEST_TIME 98 9145
TEST_TIME 99 9155
TEST_TIME 100 9155

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-03-2024 07:09:00 to 06-03-2024 07:09:03.

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 1293390 1293390 0 0.00 0 16091 8 0 0
doc_list_biud 1293384 1293384 0 0.00 0 35127 22 0 0
sp_add_invoice_to_stock 4465 4330 135 3.02 54 218146 21171 0 135
sp_cancel_adding_invoice 4320 4320 0 0.00 4 73605 838 0 0
sp_cancel_client_order 1496 1496 0 0.00 4 10229 351 0 0
sp_cancel_customer_reserve 427716 427716 0 0.00 0 31005 54 0 0
sp_cancel_pay_from_customer 560 560 0 0.00 2 5031 73 0 0
sp_cancel_pay_to_supplier 386 386 0 0.00 2 2052 64 0 0
sp_cancel_supplier_invoice 4811 4801 10 0.20 2 27795 685 0 10
sp_cancel_supplier_order 345 345 0 0.00 7 652779 82741 0 0
sp_cancel_write_off 7544 7544 0 0.00 1 7972 119 0 0
sp_client_order 17624 17624 0 0.00 3 31367 397 0 0
sp_customer_reserve 414929 414929 0 0.00 0 64264 205 0 0
sp_fill_shopping_cart 27035 27035 0 0.00 1 13610 38 0 0
sp_fill_shopping_cart_clo_res 414921 414921 0 0.00 0 16456 17 0 0
sp_get_clo_for_invoice 4320 4320 0 0.00 0 23407 418 0 0
sp_kill_cost_storno 12810 12810 0 0.00 0 7014 66 0 0
sp_kill_qstorno_ret_qs2qd 868122 868122 0 0.00 0 30995 29 0 0
sp_kill_qty_storno 459401 459401 0 0.00 0 35127 63 0 0
sp_lock_selected_doc 18195 18195 0 0.00 0 7371 4 0 0
sp_make_cost_storno 24428 24428 0 0.00 0 15554 62 0 0
sp_multiply_rows_for_pdistr 24428 24428 0 0.00 0 11841 31 0 0
sp_multiply_rows_for_qdistr 17624 17624 0 0.00 0 13538 195 0 0
sp_pay_from_customer 6146 6146 0 0.00 4 15000 132 0 0
sp_pay_to_supplier 5103 5103 0 0.00 4 14690 141 0 0
sp_payment_common 11249 11249 0 0.00 1 9941 26 0 0
sp_qd_handle_on_cancel_clo 1496 1496 0 0.00 0 10220 322 0 0
sp_qd_handle_on_invoice_upd_sts 8640 8640 0 0.00 0 35125 280 0 0
sp_qd_handle_on_reserve_upd_sts 8859 8859 0 0.00 0 12831 48 0 0
sp_reserve_write_off 8859 8859 0 0.00 6 16875 178 0 0
sp_supplier_invoice 4764 4764 0 0.00 5 73258 2680 0 0
sp_supplier_order 4652 4652 0 0.00 4 46758 1182 0 0
srv_aggregate_perf_data 88 88 0 0.00 1361 181408 18268 0 0
srv_fill_mon_cache_memory 54 54 0 0.00 1662 113747 43070 0 0
srv_find_qd_qs_mism 870300 870300 0 0.00 0 16090 7 0 0
srv_make_invnt_saldo 395 395 0 0.00 47 77064 3790 0 0
srv_make_money_saldo 628 628 0 0.00 1 13332 487 0 0
srv_recalc_idx_stat 3 3 0 0.00 196070 412274 274879 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4332 4332 0 0.00 0 22989 172 0 0
t$perf-norm:sp_cancel_adding_invoice 354 354 0 0.00 0 6892 110 0 0
t$perf-norm:sp_cancel_client_order 1496 1496 0 0.00 0 7967 26 0 0
t$perf-norm:sp_cancel_customer_reserve 608 608 0 0.00 0 6339 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 560 560 0 0.00 0 958 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 386 386 0 0.00 0 752 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 361 361 0 0.00 0 3762 20 0 0
t$perf-norm:sp_cancel_supplier_order 345 345 0 0.00 0 23076 1519 0 0
t$perf-norm:sp_cancel_write_off 906 906 0 0.00 0 913 6 0 0
t$perf-norm:sp_client_order 17624 17624 0 0.00 0 20237 18 0 0
t$perf-norm:sp_customer_reserve 917 917 0 0.00 0 832 4 0 0
t$perf-norm:sp_pay_from_customer 6147 6147 0 0.00 0 16805 15 0 0
t$perf-norm:sp_pay_to_supplier 5103 5103 0 0.00 0 5495 9 0 0
t$perf-norm:sp_reserve_write_off 8859 8859 0 0.00 0 7282 12 0 0
t$perf-norm:sp_supplier_invoice 4764 4764 0 0.00 0 11378 17 0 0
t$perf-norm:sp_supplier_order 4652 4652 0 0.00 0 7715 17 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 107 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 54 54 0 0.00 0 1131 24 0 0
t$perf-norm:srv_make_invnt_saldo 395 395 0 0.00 0 767 5 0 0
t$perf-norm:srv_make_money_saldo 628 628 0 0.00 0 788 6 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 2 65 25 0 0
v_add_invoice_to_stock 8910 8640 270 3.03 0 9277 20 0 270
v_all_customers 32818 32818 0 0.00 0 34 1 0 0
v_all_suppliers 26894 26894 0 0.00 0 22 1 0 0
v_all_wares 35246 35246 0 0.00 0 90 1 0 0
v_cancel_adding_invoice 708 708 0 0.00 0 6748 16 0 0
v_cancel_client_order 2992 2992 0 0.00 0 7698 10 0 0
v_cancel_customer_prepayment 1120 1120 0 0.00 0 4712 9 0 0
v_cancel_customer_reserve 1216 1216 0 0.00 0 349 3 0 0
v_cancel_payment_to_supplier 772 772 0 0.00 0 678 3 0 0
v_cancel_supplier_invoice 742 722 20 2.69 0 860 14 0 20
v_cancel_supplier_order 690 690 0 0.00 0 404 5 0 0
v_cancel_write_off 1812 1812 0 0.00 0 7565 17 0 0
v_max_id_clo_ord 4650 4650 0 0.00 0 99 1 0 0
v_max_id_clo_res 917 917 0 0.00 0 4342 13 0 0
v_max_id_ord_sup 4762 4762 0 0.00 0 7027 6 0 0
v_max_non_paid_invoice 1068 1068 0 0.00 0 136 2 0 0
v_max_non_paid_realizn 3031 3031 0 0.00 0 3034 5 0 0
v_min_id_clo_ord 4650 4650 0 0.00 0 6755 8 0 0
v_min_id_clo_res 917 917 0 0.00 0 2587 8 0 0
v_min_id_ord_sup 4762 4762 0 0.00 0 7018 7 0 0
v_min_non_paid_invoice 5103 5103 0 0.00 0 9916 18 0 0
v_min_non_paid_realizn 6146 6146 0 0.00 0 9668 21 0 0
v_our_firm 8658 8658 0 0.00 0 17 1 0 0
v_reserve_write_off 17718 17718 0 0.00 0 7677 7 0 0
x_lock_depdocs_on_canc_invoice 8760 8760 0 0.00 0 14620 143 0 0
x_lock_depdocs_on_canc_sup_ord 345 345 0 0.00 0 3026 293 0 0
x_make_qstorno_1000_1200 4652 4652 0 0.00 1 46739 1112 0 0
x_make_qstorno_1200_2000 4764 4764 0 0.00 3 73247 2535 0 0
x_make_qstorno_2100_3300 414929 414929 0 0.00 0 64250 186 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 06-03-2024 07:09:04 to 06-03-2024 07:09:09.

Memory consumption, metadata cache, attachments activity 

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


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000
measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
05:07:51 1067 8192000000 8956875472 9018716160 12071568 0.147 4 2 5 0 12327840 109872 146400
05:08:53 23523 8192000000 9702069712 9996627968 774527392 8.637 100 86 172 0 802660672 7116480 21016800
05:10:24 30936 8192000000 9759122832 10067734528 823602368 9.135 100 85 170 0 854271696 10350384 20318944
05:12:02 17150 8192000000 9809999232 10126413824 865782384 9.558 100 89 178 0 907118240 21118736 20217120
05:13:21 14096 8192000000 9858176512 10195697664 906679264 9.964 100 78 156 0 963761488 40131872 16950352
05:14:39 6692 8192000000 9900507680 10244927488 949491872 10.386 100 79 158 0 1002638896 36530496 16616528
05:15:53 3812 8192000000 9961240384 10317348864 979039904 10.675 100 88 175 0 1071273328 74516832 17716592
05:16:59 2937 8192000000 9980788592 10344890368 999467968 10.873 100 77 150 1 1086807232 72473216 14866048
05:18:04 2479 8192000000 10002162800 10365501440 1021275584 11.084 100 75 146 2 1100221600 64724320 14221696
05:19:08 1594 8192000000 10036289344 10405212160 1042324608 11.287 100 89 177 0 1141593664 81844016 17425040
05:20:12 1066 8192000000 10045945520 10424836096 1054087056 11.400 100 84 168 0 1150355568 79089408 17179104
05:21:15 1092 8192000000 10066640816 10444902400 1058860896 11.446 100 84 167 0 1173064512 97432400 16771216
05:22:17 3538 8192000000 9996525552 10399256576 1064395552 11.499 100 35 71 1 1107215488 35755248 7064688
05:23:22 5426 8192000000 9997187344 10388135936 1070306032 11.555 100 39 78 0 1094863120 16036992 8520096
05:24:29 4594 8192000000 9996590864 10394783744 1074759056 11.598 100 36 72 0 1098894784 16469696 7666032
05:25:34 62054 8192000000 10009361504 10406711296 1077587568 11.624 100 44 87 1 1104918816 18469632 8861616
05:27:37 2618 8192000000 10025799760 10425675776 1073699056 11.587 99 44 84 3 1127207488 44754864 8753568
05:28:48 32678 8192000000 10051864896 10448482304 1059554864 11.452 97 44 82 1 1116021824 47782288 8684672
05:30:39 16129 8192000000 10118801744 10530181120 1097904768 11.818 100 58 116 0 1205801264 95875712 12020784
05:31:59 94933 8192000000 10163621568 10583986176 1091582944 11.758 98 44 84 2 1211084176 110164352 9336880
05:34:37 19503 8192000000 10093891248 10513539072 1101335168 11.850 99 35 70 1 1195896144 87111952 7449024
05:36:02 16956 8192000000 10105340640 10523377664 1100878128 11.846 99 37 74 1 1194259120 85474960 7906032
05:37:22 16873 8192000000 10178525072 10590842880 1118474752 12.013 100 54 107 0 1274865040 145221216 11169072
05:38:46 6318 8192000000 10163028672 10571206656 1118182992 12.010 100 58 114 1 1267465216 137474256 11807968
05:40:01 1678 8192000000 10130267520 10522107904 1115737648 11.987 100 83 161 2 1241634304 109717440 16179216
05:41:06 19362 8192000000 10140391680 10571849728 1119325376 12.021 100 49 98 0 1248618160 118535456 10757328
05:42:40 5794 8192000000 10117486176 10535854080 1090054720 11.743 98 44 89 0 1206741280 106407312 10279248
05:43:49 2295 8192000000 10093646400 10486108160 1075942144 11.609 99 70 136 1 1194178192 104553808 13682240
05:44:57 1661 8192000000 10173272624 10570457088 1115296192 11.983 100 80 159 0 1273781616 142257040 16228384
05:46:02 7586 8192000000 10178043936 10580262912 1132665952 12.146 100 44 88 0 1273369088 130642432 10060704
05:47:17 2021 8192000000 10232526672 10634330112 1135092752 12.169 100 78 156 2 1328623024 176774240 16756032
05:48:23 9684 8192000000 10223616464 10643902464 1142164480 12.236 100 43 83 0 1335827504 183794240 9868784
05:49:34 11232 8192000000 10209191888 10661990400 1127297728 12.096 99 24 48 0 1315673136 182117744 6257664
05:50:58 50966 8192000000 10135088928 10555752448 1138752496 12.204 100 40 80 0 1238836576 91187792 8896288
05:52:59 74255 8192000000 10071111920 10539466752 1106762048 11.902 98 12 24 0 1165677760 56277616 2638096
05:55:15 55308 8192000000 10071121040 10538246144 1119055760 12.018 99 16 31 2 1195060480 72860256 3144464
05:57:25 39087 8192000000 10107428160 10533982208 1123117312 12.056 98 32 64 0 1180397232 50127104 7152816
05:59:04 57292 8192000000 10149470688 10591764480 1144276288 12.256 100 27 50 1 1246072256 96152176 5643792
06:01:03 67520 8192000000 10099345792 10534481920 1144820976 12.261 100 18 36 0 1177219680 28671344 3727360
06:03:11 39015 8192000000 10094856480 10560024576 1151079600 12.320 100 6 12 0 1188817376 36686688 1051088
06:04:53 13890 8192000000 10102245664 10540122112 1146910544 12.280 100 28 56 0 1193895200 41224768 5759888
06:06:09 61588 8192000000 10094847280 10542579712 1151751680 12.326 100 20 37 0 1190009904 34668624 3589600
06:08:12 93527 8192000000 10105772384 10553618432 1152155072 12.330 100 16 32 0 1210227696 54911024 3161600
06:10:52 43674 8192000000 10089118656 10529767424 1129940368 12.121 97 30 58 0 1201240864 65044864 6255632
06:12:39 27641 8192000000 10127117968 10569068544 1142302816 12.237 99 33 66 0 1199641456 50284000 7054640
06:14:14 40372 8192000000 10090613072 10530963456 1120304432 12.030 97 12 24 0 1177422272 54662464 2455376
06:15:56 73115 8192000000 10121344096 10578022400 1133866144 12.158 98 17 34 0 1196325424 58748224 3711056
06:18:12 97357 8192000000 10101621872 10583236608 1134329136 12.162 98 22 44 0 1244866064 105730288 4806640
06:21:17 62264 8192000000 10077280336 10534027264 1135206640 12.170 99 17 34 0 1178532704 39943408 3382656
06:23:20 10478 8192000000 10102335152 10526908416 1132331680 12.143 100 46 92 1 1199103008 57971216 8800112
06:24:40 47124 8192000000 10049157984 10556514304 1071942608 11.571 95 17 34 0 1166754688 90991616 3820464
06:26:42 39938 8192000000 10028422752 10486255616 1058181808 11.439 96 18 35 0 1101639872 39980544 3477520
06:28:24 32909 8192000000 10055582544 10506354688 1066307104 11.517 97 32 64 0 1127425664 54941888 6176672
06:30:00 46434 8192000000 10054072096 10465267712 1076435040 11.613 98 36 72 0 1129133328 45468816 7229472
06:31:54 77395 8192000000 10066144688 10588389376 1102194864 11.858 99 11 22 0 1170162048 65471904 2495280
06:35:09 21925 8192000000 10052019712 10473873408 1120646144 12.033 100 35 70 1 1151178160 23939872 6592144
06:36:32 40809 8192000000 10134233712 10599747584 1109408720 11.927 98 14 28 0 1238120448 125953968 2757760
06:38:13 83519 8192000000 10126270416 10614767616 1112092496 11.952 99 14 28 0 1252900160 137520560 3287104
06:40:51 40844 8192000000 10070294256 10519203840 1125548768 12.079 100 18 34 0 1173620432 44598688 3472976
06:42:42 45203 8192000000 10162418304 10627162112 1130472944 12.126 99 19 38 0 1213471824 78416432 4582448
06:44:50 29301 8192000000 10072861824 10507583488 1136457888 12.182 100 19 39 0 1161964768 21745376 3761504
06:46:20 51119 8192000000 10119107984 10567479296 1140879712 12.224 100 33 66 0 1201935840 54567376 6488752
06:48:16 57820 8192000000 10113981200 10562793472 1146109760 12.273 100 33 66 1 1207871536 55580704 6181072
06:50:15 68712 8192000000 10127822368 10653147136 1140832576 12.223 100 32 64 0 1209810912 62632416 6345920
06:52:37 113747 8192000000 10087575360 10582917120 1122781936 12.053 98 13 26 0 1181707632 56585872 2339824
06:55:37 30327 8192000000 10092790048 10548760576 1147557792 12.287 100 38 74 0 1184645040 29679488 7407760
06:57:08 67880 8192000000 10140107360 10622500864 1147059552 12.282 99 15 30 0 1243034992 92710656 3264784
06:59:16 92508 8192000000 10119366512 10576343040 1147696704 12.288 99 14 29 0 1239550944 88480208 3374032
07:01:51 93735 8192000000 10079759824 10573455360 1131862624 12.139 98 12 24 0 1172210272 37747776 2599872
07:04:25 23510 8192000000 10081055072 10523922432 1147171440 12.283 100 32 64 0 1172544112 18907840 6464832
07:05:54 48762 8192000000 10094744512 10564648960 1129920896 12.121 99 33 66 0 1207270672 70899552 6450224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:13, from 06-03-2024 07:09:11 to 06-03-2024 07:09:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 135 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-03-2024 07:09:25 to 06-03-2024 07:09:27.

Content of mon$database and FB version 


MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          171384
MON$OLDEST_ACTIVE               173449
MON$OLDEST_SNAPSHOT             173449
MON$NEXT_TRANSACTION            173449
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       1921312
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             689
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

Database statistics 

 
Database "/home/bases/oltp40-etalone.fdb" 
Gstat execution time Wed Mar  6 07:09:28 2024 
 
Database header page information: 
    Flags            0 
    Generation        90620 
    System Change Number    0 
    Page size        8192 
    ODS version        13.0 
    Oldest transaction    171384 
    Oldest active        173449 
    Oldest snapshot        173449 
    Next transaction    173450 
    Sequence number        0 
    Next attachment ID    689 
    Implementation        HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
    Shadow count        0 
    Page buffers        0 
    Next header page    0 
    Database dialect    3 
    Creation date        Apr 30, 2020 7:30:08 
    Attributes        force write 
 
    Variable header data: 
    Database GUID:    {58978C10-B735-40F5-8B7D-F7A1956E782B} 
    Sweep interval:        0 
    *END* 
 
 
Database file sequence: 
File /home/bases/oltp40-etalone.fdb is the only file 
 
Analyzing database pages ... 
AGENTS (150) 
    Primary pointer page: 524, Index root page: 525 
    Total formats: 1, used formats: 1 
    Average record length: 33.60, total records: 50 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 344.00, compression ratio: 10.24 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index AGENTS_ID_DESC (2) 
    Root page: 1504333, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_OUR_FIRM (4) 
    Root page: 1504335, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 48 
    Average key length: 2.04, compression ratio: 0.50 
    Average prefix length: 0.96, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_IS_SUPPLIER (3) 
    Root page: 1504334, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 3.08, total dup: 48, max dup: 44 
    Average key length: 2.04, compression ratio: 0.54 
    Average prefix length: 1.04, average data length: 0.06 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index AGENTS_NAME_UNQ (1) 
    Root page: 1504332, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 17.20, total dup: 0, max dup: 0 
    Average key length: 15.88, compression ratio: 0.92 
    Average prefix length: 1.42, average data length: 13.20 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_AGENTS (0) 
    Root page: 1504331, depth: 1, leaf buckets: 1, nodes: 50 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
BUSINESS_OPS (154) 
    Primary pointer page: 532, Index root page: 533 
    Total formats: 1, used formats: 1 
    Average record length: 108.20, total records: 20 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1235.00, compression ratio: 11.41 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index BO_UNIT_UNQ (1) 
    Root page: 1504264, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 18.25, total dup: 0, max dup: 0 
    Average key length: 17.20, compression ratio: 1.24 
    Average prefix length: 7.05, average data length: 14.25 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_PREDICT_PRIOR (3) 
    Root page: 1504266, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.40, total dup: 0, max dup: 0 
    Average key length: 4.35, compression ratio: 0.67 
    Average prefix length: 1.20, average data length: 1.70 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index BUSINESS_OPS_RND_WGTH (2) 
    Root page: 1504265, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 4.30, total dup: 6, max dup: 3 
    Average key length: 3.25, compression ratio: 0.72 
    Average prefix length: 1.35, average data length: 1.00 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RDB$1 (0) 
    Root page: 1504263, depth: 1, leaf buckets: 1, nodes: 20 
    Average node length: 5.20, total dup: 0, max dup: 0 
    Average key length: 4.15, compression ratio: 0.65 
    Average prefix length: 1.10, average data length: 1.60 
    Clustering factor: 1, ratio: 0.05 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
DOC_DATA (139) 
    Primary pointer page: 502, Index root page: 503 
    Total formats: 1, used formats: 1 
    Average record length: 47.37, total records: 7787219 
    Average version length: 48.16, total versions: 105203, 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: 55, data page slots: 88992 
    Data pages: 88992, average fill: 70% 
    Primary pages: 88991, secondary pages: 1, swept pages: 31679 
    Empty pages: 7, full pages: 76358 
    Fill distribution: 
     0 - 19% = 20 
    20 - 39% = 54 
    40 - 59% = 1138 
    60 - 79% = 87698 
    80 - 99% = 82 
 
    Index DOC_DATA_DOC_WARE_UNQ (0) 
    Root page: 1510636, depth: 3, leaf buckets: 23274, nodes: 7787219 
    Average node length: 18.90, total dup: 0, max dup: 0 
    Average key length: 15.91, compression ratio: 1.70 
    Average prefix length: 14.08, average data length: 12.92 
    Clustering factor: 1708767, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 324 
        20 - 39% = 1677 
        40 - 59% = 4177 
        60 - 79% = 2363 
        80 - 99% = 14733 
 
    Index DOC_DATA_ID_DESC (1) 
    Root page: 1528140, depth: 3, leaf buckets: 13521, nodes: 7787219 
    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: 1533229, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1494 
        40 - 59% = 2079 
        60 - 79% = 1091 
        80 - 99% = 8856 
 
    Index FK_DOC_DATA_DOC_LIST (2) 
    Root page: 1546735, depth: 3, leaf buckets: 8327, nodes: 7787219 
    Average node length: 6.62, total dup: 5812730, max dup: 49 
    Average key length: 3.64, compression ratio: 2.47 
    Average prefix length: 7.62, average data length: 1.38 
    Clustering factor: 1526208, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 132 
        20 - 39% = 895 
        40 - 59% = 1390 
        60 - 79% = 911 
        80 - 99% = 4999 
 
DOC_LIST (138) 
    Primary pointer page: 500, Index root page: 501 
    Total formats: 1, used formats: 1 
    Average record length: 56.31, total records: 2266502 
    Average version length: 58.89, total versions: 53893, max versions: 2 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 84.00, compression ratio: 1.49 
    Pointer pages: 18, data page slots: 28832 
    Data pages: 28832, average fill: 73% 
    Primary pages: 28831, secondary pages: 1, swept pages: 8142 
    Empty pages: 1, full pages: 22854 
    Fill distribution: 
     0 - 19% = 12 
    20 - 39% = 45 
    40 - 59% = 388 
    60 - 79% = 28287 
    80 - 99% = 100 
 
    Index DOC_LIST_ID_DESC (1) 
    Root page: 1541152, depth: 3, leaf buckets: 4564, nodes: 2266502 
    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: 689522, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 909 
        40 - 59% = 839 
        60 - 79% = 712 
        80 - 99% = 2104 
 
    Index DOC_LIST_WORKER_OPTYPE (2) 
    Root page: 1544398, depth: 3, leaf buckets: 2456, nodes: 2268109 
    Average node length: 4.97, total dup: 2267210, max dup: 19848 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1277302, ratio: 0.56 
    Fill distribution: 
         0 - 19% = 3 
        20 - 39% = 205 
        40 - 59% = 1444 
        60 - 79% = 550 
        80 - 99% = 254 
 
    Index FK_DOC_LIST_AGENTS (3) 
    Root page: 1545933, depth: 3, leaf buckets: 1786, nodes: 2266502 
    Average node length: 4.97, total dup: 2266452, max dup: 130109 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 1074387, ratio: 0.47 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 4 
        40 - 59% = 633 
        60 - 79% = 49 
        80 - 99% = 1100 
 
    Index PK_DOC_LIST (0) 
    Root page: 1538209, depth: 3, leaf buckets: 4335, nodes: 2266502 
    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: 689522, ratio: 0.30 
    Fill distribution: 
         0 - 19% = 89 
        20 - 39% = 558 
        40 - 59% = 623 
        60 - 79% = 796 
        80 - 99% = 2269 
 
DOC_STATES (149) 
    Primary pointer page: 522, Index root page: 523 
    Total formats: 1, used formats: 1 
    Average record length: 67.50, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 650.00, compression ratio: 9.63 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index DOC_STATES_MCODE_UNQ (1) 
    Root page: 1504337, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 17.75, total dup: 0, max dup: 0 
    Average key length: 16.50, compression ratio: 1.08 
    Average prefix length: 4.00, average data length: 13.75 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index DOC_STATES_NAME_UNQ (2) 
    Root page: 1504338, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 33.25, total dup: 0, max dup: 0 
    Average key length: 32.00, compression ratio: 0.99 
    Average prefix length: 2.50, average data length: 29.25 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_DOC_STATES (0) 
    Root page: 1504336, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 4.75, total dup: 0, max dup: 0 
    Average key length: 3.50, compression ratio: 0.86 
    Average prefix length: 1.50, average data length: 1.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
FB_ERRORS (155) 
    Primary pointer page: 534, Index root page: 535 
    Total formats: 2, used formats: 2 
    Average record length: 57.88, total records: 2182 
    Average version length: 79.61, total versions: 757, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 270.43, compression ratio: 4.67 
    Pointer pages: 1, data page slots: 40 
    Data pages: 40, average fill: 72% 
    Primary pages: 39, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 34 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 22 
    80 - 99% = 12 
 
    Index FB_ERRORS_GDS_CODE (0) 
    Root page: 398, depth: 2, leaf buckets: 2, nodes: 2182 
    Average node length: 4.40, total dup: 756, max dup: 1 
    Average key length: 2.67, compression ratio: 1.87 
    Average prefix length: 4.33, average data length: 0.67 
    Clustering factor: 1518, ratio: 0.70 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 1 
        80 - 99% = 0 
 
INVNT_SALDO (145) 
    Primary pointer page: 514, Index root page: 515 
    Total formats: 2, used formats: 1 
    Average record length: 83.36, total records: 400 
    Average version length: 28.35, total versions: 1525, max versions: 4 
    Average fragment length: 2.00, total fragments: 3, max fragments: 1 
    Average unpacked length: 104.00, compression ratio: 1.25 
    Pointer pages: 1, data page slots: 24 
    Data pages: 24, average fill: 56% 
    Primary pages: 7, secondary pages: 17, swept pages: 0 
    Empty pages: 3, full pages: 12 
    Fill distribution: 
     0 - 19% = 9 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 13 
 
    Index PK_INVNT_SALDO (0) 
    Root page: 1510371, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 326, ratio: 0.81 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
INVNT_TURNOVER_LOG (153) 
    Primary pointer page: 530, Index root page: 531 
    Total formats: 1, used formats: 1 
    Average record length: 19.67, total records: 110718 
    Average version length: 68.27, total versions: 90791, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 88.00, compression ratio: 4.47 
    Pointer pages: 6, data page slots: 4616 
    Data pages: 1816, average fill: 80% 
    Primary pages: 1815, secondary pages: 1, swept pages: 0 
    Empty pages: 64, full pages: 1448 
    Fill distribution: 
     0 - 19% = 109 
    20 - 39% = 75 
    40 - 59% = 106 
    60 - 79% = 244 
    80 - 99% = 1282 
 
    Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
    Root page: 1699564, depth: 3, leaf buckets: 337, nodes: 110719 
    Average node length: 13.45, total dup: 6299, max dup: 2 
    Average key length: 10.74, compression ratio: 2.51 
    Average prefix length: 19.20, average data length: 7.80 
    Clustering factor: 82844, ratio: 0.75 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 8 
        40 - 59% = 244 
        60 - 79% = 52 
        80 - 99% = 32 
 
MONEY_SALDO (141) 
    Primary pointer page: 506, Index root page: 507 
    Total formats: 1, used formats: 1 
    Average record length: 15.24, total records: 49 
    Average version length: 9.00, total versions: 238, max versions: 8 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 32.00, compression ratio: 2.10 
    Pointer pages: 1, data page slots: 5 
    Data pages: 5, average fill: 19% 
    Primary pages: 1, secondary pages: 4, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 1 
 
    Index PK_MONEY_SALDO (0) 
    Root page: 1510383, depth: 1, leaf buckets: 1, nodes: 49 
    Average node length: 11.82, total dup: 0, max dup: 0 
    Average key length: 10.80, compression ratio: 0.83 
    Average prefix length: 1.18, average data length: 7.82 
    Clustering factor: 1, ratio: 0.02 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MONEY_TURNOVER_LOG (140) 
    Primary pointer page: 504, Index root page: 505 
    Total formats: 1, used formats: 1 
    Average record length: 13.76, total records: 1644 
    Average version length: 43.03, total versions: 1423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 58.00, compression ratio: 4.21 
    Pointer pages: 1, data page slots: 32 
    Data pages: 32, average fill: 54% 
    Primary pages: 31, secondary pages: 1, swept pages: 0 
    Empty pages: 4, full pages: 12 
    Fill distribution: 
     0 - 19% = 10 
    20 - 39% = 2 
    40 - 59% = 3 
    60 - 79% = 6 
    80 - 99% = 11 
 
    Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
    Root page: 93531, depth: 2, leaf buckets: 2, nodes: 1644 
    Average node length: 4.26, total dup: 1546, max dup: 151 
    Average key length: 2.63, compression ratio: 7.22 
    Average prefix length: 18.43, average data length: 0.57 
    Clustering factor: 911, ratio: 0.55 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_CACHE_MEMORY (165) 
    Primary pointer page: 555, Index root page: 556 
    Total formats: 2, used formats: 1 
    Average record length: 97.55, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 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% = 1 
    80 - 99% = 0 
 
    Index PK_MON_CACHE_MEMORY (0) 
    Root page: 1504238, depth: 1, leaf buckets: 1, nodes: 71 
    Average node length: 11.70, total dup: 0, max dup: 0 
    Average key length: 10.69, compression ratio: 0.84 
    Average prefix length: 1.30, average data length: 7.70 
    Clustering factor: 2, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG (162) 
    Primary pointer page: 548, Index root page: 549 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_DTS (4) 
    Root page: 1504251, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_GDSCODE (2) 
    Root page: 1504249, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_ROWSET_DESC (1) 
    Root page: 1504248, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_UNIT (3) 
    Root page: 1504250, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG (0) 
    Root page: 1504247, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
MON_LOG_TABLE_STATS (163) 
    Primary pointer page: 550, Index root page: 551 
    Total formats: 2, used formats: 1 
    Average record length: 67.13, total records: 30 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 611.00, compression ratio: 9.10 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 31% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_DTS (4) 
    Root page: 1504246, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.50, total dup: 23, max dup: 4 
    Average key length: 2.47, compression ratio: 3.24 
    Average prefix length: 7.53, average data length: 0.47 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_GDSCODE (2) 
    Root page: 1504244, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 2.00, total dup: 29, max dup: 29 
    Average key length: 1.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_ROWSET (1) 
    Root page: 1504243, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 3.33, total dup: 29, max dup: 29 
    Average key length: 2.30, compression ratio: 3.91 
    Average prefix length: 8.70, average data length: 0.30 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
    Root page: 1504245, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 12.90, total dup: 0, max dup: 0 
    Average key length: 11.87, compression ratio: 1.42 
    Average prefix length: 7.63, average data length: 9.20 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_MON_LOG_TABLE_STATS (0) 
    Root page: 1504242, depth: 1, leaf buckets: 1, nodes: 30 
    Average node length: 8.37, total dup: 0, max dup: 0 
    Average key length: 7.33, compression ratio: 1.23 
    Average prefix length: 4.63, average data length: 4.37 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
OPTYPES (136) 
    Primary pointer page: 496, Index root page: 497 
    Total formats: 2, used formats: 1 
    Average record length: 67.56, total records: 9 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 386.00, compression ratio: 5.71 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 9% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index OPTYPES_MCODE_UNQ (1) 
    Root page: 1544827, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 8.56, total dup: 0, max dup: 0 
    Average key length: 6.89, compression ratio: 0.73 
    Average prefix length: 0.44, average data length: 4.56 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_OPTYPES (0) 
    Root page: 1544826, depth: 1, leaf buckets: 1, nodes: 9 
    Average node length: 6.11, total dup: 0, max dup: 0 
    Average key length: 5.00, compression ratio: 0.60 
    Average prefix length: 0.89, average data length: 2.11 
    Clustering factor: 1, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PDISTR (146) 
    Primary pointer page: 516, Index root page: 517 
    Total formats: 1, used formats: 1 
    Average record length: 35.69, total records: 809472 
    Average version length: 37.93, total versions: 39858, max versions: 3 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 54.00, compression ratio: 1.51 
    Pointer pages: 6, data page slots: 8456 
    Data pages: 8456, average fill: 65% 
    Primary pages: 8451, secondary pages: 5, swept pages: 1089 
    Empty pages: 50, full pages: 7365 
    Fill distribution: 
     0 - 19% = 89 
    20 - 39% = 69 
    40 - 59% = 353 
    60 - 79% = 7882 
    80 - 99% = 63 
 
    Index PDISTR_AGENT_ID (2) 
    Root page: 1509330, depth: 2, leaf buckets: 847, nodes: 787255 
    Average node length: 4.88, total dup: 787206, max dup: 146287 
    Average key length: 2.01, compression ratio: 4.48 
    Average prefix length: 8.99, average data length: 0.01 
    Clustering factor: 90311, ratio: 0.11 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 125 
        40 - 59% = 461 
        60 - 79% = 162 
        80 - 99% = 99 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_ASC (0) 
    Root page: 1508635, depth: 3, leaf buckets: 887, nodes: 787255 
    Average node length: 5.89, total dup: 700652, max dup: 45 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 159757, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 34 
        40 - 59% = 429 
        60 - 79% = 112 
        80 - 99% = 311 
 
    Index PDISTR_SNDOP_RCVOP_SNDID_DESC (1) 
    Root page: 1509209, depth: 3, leaf buckets: 906, nodes: 787255 
    Average node length: 5.89, total dup: 700652, max dup: 45 
    Average key length: 3.02, compression ratio: 7.28 
    Average prefix length: 21.09, average data length: 0.91 
    Clustering factor: 161697, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 72 
        40 - 59% = 413 
        60 - 79% = 117 
        80 - 99% = 304 
 
    Index PDISTR_WORKER_SND_ID (3) 
    Root page: 1510200, depth: 3, leaf buckets: 1134, nodes: 787255 
    Average node length: 5.97, total dup: 700652, max dup: 45 
    Average key length: 3.10, compression ratio: 5.48 
    Average prefix length: 16.00, average data length: 1.00 
    Clustering factor: 154166, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 261 
        40 - 59% = 603 
        60 - 79% = 180 
        80 - 99% = 88 
 
PERF_AGG (158) 
    Primary pointer page: 540, Index root page: 541 
    Total formats: 1, used formats: 1 
    Average record length: 62.78, total records: 5475 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 3.56, total fragments: 36, max fragments: 1 
    Average unpacked length: 379.00, compression ratio: 6.04 
    Pointer pages: 1, data page slots: 104 
    Data pages: 104, average fill: 52% 
    Primary pages: 81, secondary pages: 23, swept pages: 54 
    Empty pages: 21, full pages: 55 
    Fill distribution: 
     0 - 19% = 29 
    20 - 39% = 1 
    40 - 59% = 1 
    60 - 79% = 73 
    80 - 99% = 0 
 
    Index PERF_AGG_UNQ (1) 
    Root page: 1504260, depth: 2, leaf buckets: 6, nodes: 5475 
    Average node length: 5.49, total dup: 0, max dup: 0 
    Average key length: 3.58, compression ratio: 10.06 
    Average prefix length: 34.46, average data length: 1.54 
    Clustering factor: 5132, 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: 1504255, depth: 2, leaf buckets: 10, nodes: 5475 
    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: 161, 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: 399, Index root page: 434 
    Total formats: 1, used formats: 1 
    Average record length: 39.07, total records: 79049 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 48.00, compression ratio: 1.23 
    Pointer pages: 1, data page slots: 824 
    Data pages: 824, average fill: 66% 
    Primary pages: 824, secondary pages: 0, swept pages: 0 
    Empty pages: 2, full pages: 821 
    Fill distribution: 
     0 - 19% = 2 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 821 
    80 - 99% = 0 
 
    Index PK_PERF_ESTIMATED (0) 
    Root page: 30483, depth: 2, leaf buckets: 101, nodes: 79049 
    Average node length: 10.17, total dup: 0, max dup: 0 
    Average key length: 8.18, compression ratio: 1.10 
    Average prefix length: 3.82, average data length: 5.18 
    Clustering factor: 3350, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 99 
 
PERF_ISQL_STAT (156) 
    Primary pointer page: 536, Index root page: 537 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PERF_ISQL_STAT_TRN (0) 
    Root page: 1504261, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PERF_LOG (159) 
    Primary pointer page: 542, Index root page: 543 
    Total formats: 1, used formats: 1 
    Average record length: 111.08, total records: 71 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1691.00, compression ratio: 15.22 
    Pointer pages: 1, data page slots: 2 
    Data pages: 2, average fill: 56% 
    Primary pages: 2, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 1 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 1 
    40 - 59% = 0 
    60 - 79% = 1 
    80 - 99% = 0 
 
PERF_SPLIT_0 (281) 
    Primary pointer page: 601, Index root page: 602 
    Total formats: 1, used formats: 1 
    Average record length: 149.15, total records: 168281 
    Average version length: 151.15, total versions: 2310, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.37 
    Pointer pages: 5, data page slots: 4624 
    Data pages: 4152, average fill: 84% 
    Primary pages: 4150, secondary pages: 2, swept pages: 6 
    Empty pages: 15, full pages: 4128 
    Fill distribution: 
     0 - 19% = 19 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 3 
    80 - 99% = 4128 
 
PERF_SPLIT_1 (282) 
    Primary pointer page: 603, Index root page: 604 
    Total formats: 1, used formats: 1 
    Average record length: 148.61, total records: 152731 
    Average version length: 151.74, total versions: 2502, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.41 
    Pointer pages: 6, data page slots: 4424 
    Data pages: 3792, average fill: 83% 
    Primary pages: 3790, secondary pages: 2, swept pages: 5 
    Empty pages: 38, full pages: 3743 
    Fill distribution: 
     0 - 19% = 42 
    20 - 39% = 4 
    40 - 59% = 1 
    60 - 79% = 1 
    80 - 99% = 3744 
 
PERF_SPLIT_2 (283) 
    Primary pointer page: 605, Index root page: 606 
    Total formats: 1, used formats: 1 
    Average record length: 123.46, total records: 182540 
    Average version length: 155.00, total versions: 35650, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 13.74 
    Pointer pages: 6, data page slots: 5000 
    Data pages: 4584, average fill: 85% 
    Primary pages: 4582, secondary pages: 2, swept pages: 6 
    Empty pages: 73, full pages: 4491 
    Fill distribution: 
     0 - 19% = 74 
    20 - 39% = 6 
    40 - 59% = 8 
    60 - 79% = 6 
    80 - 99% = 4490 
 
PERF_SPLIT_3 (284) 
    Primary pointer page: 607, Index root page: 608 
    Total formats: 1, used formats: 1 
    Average record length: 146.12, total records: 137119 
    Average version length: 153.04, total versions: 4673, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.61 
    Pointer pages: 6, data page slots: 3544 
    Data pages: 3432, average fill: 83% 
    Primary pages: 3430, secondary pages: 2, swept pages: 4 
    Empty pages: 60, full pages: 3360 
    Fill distribution: 
     0 - 19% = 62 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 2 
    80 - 99% = 3360 
 
PERF_SPLIT_4 (285) 
    Primary pointer page: 609, Index root page: 610 
    Total formats: 1, used formats: 1 
    Average record length: 149.46, total records: 159578 
    Average version length: 150.57, total versions: 2042, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.35 
    Pointer pages: 6, data page slots: 4992 
    Data pages: 3984, average fill: 83% 
    Primary pages: 3980, secondary pages: 4, swept pages: 4 
    Empty pages: 53, full pages: 3918 
    Fill distribution: 
     0 - 19% = 59 
    20 - 39% = 3 
    40 - 59% = 4 
    60 - 79% = 1 
    80 - 99% = 3917 
 
PERF_SPLIT_5 (286) 
    Primary pointer page: 611, Index root page: 612 
    Total formats: 1, used formats: 1 
    Average record length: 148.90, total records: 154847 
    Average version length: 151.29, total versions: 2366, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.39 
    Pointer pages: 8, data page slots: 5184 
    Data pages: 3888, average fill: 82% 
    Primary pages: 3887, secondary pages: 1, swept pages: 1 
    Empty pages: 73, full pages: 3793 
    Fill distribution: 
     0 - 19% = 76 
    20 - 39% = 10 
    40 - 59% = 4 
    60 - 79% = 6 
    80 - 99% = 3792 
 
PERF_SPLIT_6 (287) 
    Primary pointer page: 613, Index root page: 614 
    Total formats: 1, used formats: 1 
    Average record length: 147.63, total records: 167580 
    Average version length: 153.09, total versions: 4531, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.49 
    Pointer pages: 8, data page slots: 4672 
    Data pages: 4168, average fill: 83% 
    Primary pages: 4167, secondary pages: 1, swept pages: 6 
    Empty pages: 35, full pages: 4117 
    Fill distribution: 
     0 - 19% = 39 
    20 - 39% = 5 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 4117 
 
PERF_SPLIT_7 (288) 
    Primary pointer page: 615, Index root page: 616 
    Total formats: 1, used formats: 1 
    Average record length: 146.43, total records: 155481 
    Average version length: 152.61, total versions: 4961, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.58 
    Pointer pages: 5, data page slots: 4392 
    Data pages: 3848, average fill: 84% 
    Primary pages: 3846, secondary pages: 2, swept pages: 7 
    Empty pages: 24, full pages: 3813 
    Fill distribution: 
     0 - 19% = 28 
    20 - 39% = 4 
    40 - 59% = 2 
    60 - 79% = 1 
    80 - 99% = 3813 
 
PERF_SPLIT_8 (289) 
    Primary pointer page: 617, Index root page: 618 
    Total formats: 1, used formats: 1 
    Average record length: 149.51, total records: 156085 
    Average version length: 149.03, total versions: 1581, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.34 
    Pointer pages: 7, data page slots: 5352 
    Data pages: 3872, average fill: 83% 
    Primary pages: 3869, secondary pages: 3, swept pages: 4 
    Empty pages: 38, full pages: 3817 
    Fill distribution: 
     0 - 19% = 40 
    20 - 39% = 9 
    40 - 59% = 3 
    60 - 79% = 4 
    80 - 99% = 3816 
 
PERF_SPLIT_9 (290) 
    Primary pointer page: 619, Index root page: 620 
    Total formats: 1, used formats: 1 
    Average record length: 142.73, total records: 170965 
    Average version length: 153.71, total versions: 10279, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1696.00, compression ratio: 11.88 
    Pointer pages: 5, data page slots: 5800 
    Data pages: 4248, average fill: 84% 
    Primary pages: 4245, secondary pages: 3, swept pages: 1 
    Empty pages: 35, full pages: 4197 
    Fill distribution: 
     0 - 19% = 37 
    20 - 39% = 7 
    40 - 59% = 3 
    60 - 79% = 3 
    80 - 99% = 4198 
 
PHRASES (143) 
    Primary pointer page: 510, Index root page: 511 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PHRASES_ID_DESC (3) 
    Root page: 1510376, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_NAME (2) 
    Root page: 1510375, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PHRASES_UNQ (1) 
    Root page: 1510374, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_PHRASES (0) 
    Root page: 1510373, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
PSTORNED (147) 
    Primary pointer page: 518, Index root page: 519 
    Total formats: 1, used formats: 1 
    Average record length: 51.84, total records: 2129761 
    Average version length: 52.89, total versions: 44565, 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: 25808 
    Data pages: 25808, average fill: 71% 
    Primary pages: 25795, secondary pages: 13, swept pages: 9677 
    Empty pages: 113, full pages: 23653 
    Fill distribution: 
     0 - 19% = 209 
    20 - 39% = 187 
    40 - 59% = 491 
    60 - 79% = 24463 
    80 - 99% = 458 
 
    Index PSTORNED_RCV_ID (1) 
    Root page: 1506208, depth: 3, leaf buckets: 2594, nodes: 2129761 
    Average node length: 5.44, total dup: 1988115, max dup: 1451 
    Average key length: 2.48, compression ratio: 3.62 
    Average prefix length: 8.58, average data length: 0.42 
    Clustering factor: 184694, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 271 
        40 - 59% = 1705 
        60 - 79% = 307 
        80 - 99% = 309 
 
    Index PSTORNED_SND_ID (0) 
    Root page: 1504841, depth: 3, leaf buckets: 2757, nodes: 2129761 
    Average node length: 5.69, total dup: 1912141, max dup: 69 
    Average key length: 2.74, compression ratio: 3.29 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 381352, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 5 
        40 - 59% = 2355 
        60 - 79% = 366 
        80 - 99% = 30 
 
    Index PSTORNED_WORKER_ID (2) 
    Root page: 1508018, depth: 3, leaf buckets: 2148, nodes: 2129761 
    Average node length: 4.96, total dup: 2129661, max dup: 27462 
    Average key length: 2.00, compression ratio: 1.20 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 182255, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 215 
        40 - 59% = 1103 
        60 - 79% = 359 
        80 - 99% = 469 
 
RULES_FOR_PDISTR (148) 
    Primary pointer page: 520, Index root page: 521 
    Total formats: 1, used formats: 1 
    Average record length: 17.00, total records: 4 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 334.00, compression ratio: 19.65 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 2% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_PDISTR_UNQ (0) 
    Root page: 1504339, depth: 1, leaf buckets: 1, nodes: 4 
    Average node length: 11.50, total dup: 0, max dup: 0 
    Average key length: 10.25, compression ratio: 0.88 
    Average prefix length: 1.50, average data length: 7.50 
    Clustering factor: 1, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
RULES_FOR_QDISTR (137) 
    Primary pointer page: 498, Index root page: 499 
    Total formats: 1, used formats: 1 
    Average record length: 32.71, total records: 7 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 332.00, compression ratio: 10.15 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_RCVOP (1) 
    Root page: 1544825, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 5.29, total dup: 2, max dup: 2 
    Average key length: 4.14, compression ratio: 0.72 
    Average prefix length: 1.43, average data length: 1.57 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index RULES_FOR_QDISTR_UNQ (0) 
    Root page: 1544824, depth: 1, leaf buckets: 1, nodes: 7 
    Average node length: 10.14, total dup: 0, max dup: 0 
    Average key length: 8.86, compression ratio: 0.94 
    Average prefix length: 2.14, average data length: 6.14 
    Clustering factor: 1, ratio: 0.14 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SEMAPHORES (152) 
    Primary pointer page: 528, Index root page: 529 
    Total formats: 1, used formats: 1 
    Average record length: 43.40, total records: 5 
    Average version length: 9.00, total versions: 1, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 7.97 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 4% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_SEMAPHORES (0) 
    Root page: 1504327, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 12.40, total dup: 0, max dup: 0 
    Average key length: 11.00, compression ratio: 0.82 
    Average prefix length: 0.60, average data length: 8.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SEMAPHORES_TASK_UNQ (1) 
    Root page: 1504328, depth: 1, leaf buckets: 1, nodes: 5 
    Average node length: 23.40, total dup: 0, max dup: 0 
    Average key length: 22.00, compression ratio: 1.07 
    Average prefix length: 4.20, average data length: 19.40 
    Clustering factor: 1, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
SETTINGS (135) 
    Primary pointer page: 494, Index root page: 495 
    Total formats: 1, used formats: 1 
    Average record length: 97.62, total records: 149 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 1347.00, compression ratio: 13.80 
    Pointer pages: 1, data page slots: 3 
    Data pages: 3, average fill: 70% 
    Primary pages: 3, secondary pages: 0, swept pages: 1 
    Empty pages: 0, full pages: 2 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 1 
    60 - 79% = 0 
    80 - 99% = 2 
 
    Index SETTINGS_MCODE_WM_UNQ (1) 
    Root page: 1544931, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 14.66, total dup: 0, max dup: 0 
    Average key length: 13.55, compression ratio: 2.19 
    Average prefix length: 19.07, average data length: 10.66 
    Clustering factor: 48, ratio: 0.32 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 1 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index SETTINGS_MODE_CODE (0) 
    Root page: 1544828, depth: 1, leaf buckets: 1, nodes: 149 
    Average node length: 25.56, total dup: 0, max dup: 0 
    Average key length: 24.56, compression ratio: 1.63 
    Average prefix length: 18.58, average data length: 21.56 
    Clustering factor: 14, ratio: 0.09 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$DEP_DOCS (129) 
    Primary pointer page: 482, Index root page: 483 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_DEP_DOCS_UNQ (0) 
    Root page: 1544832, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$IDX_RECALC (132) 
    Primary pointer page: 488, Index root page: 489 
    Total formats: 2, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
    Root page: 1544829, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$MON_LOG (133) 
    Primary pointer page: 490, Index root page: 491 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$MON_LOG_TABLE_STATS (134) 
    Primary pointer page: 492, Index root page: 493 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_EST_WHOLE (161) 
    Primary pointer page: 546, Index root page: 547 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$PERF_LOG (160) 
    Primary pointer page: 544, Index root page: 545 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
    Root page: 1504252, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$PERF_MON (131) 
    Primary pointer page: 486, Index root page: 487 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
TMP$RESULT_SET (130) 
    Primary pointer page: 484, Index root page: 485 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_RESULT_SET_DOC (1) 
    Root page: 1544831, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index TMP_RESULT_SET_WARE_DOC (0) 
    Root page: 1544830, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TMP$SHOPPING_CART (128) 
    Primary pointer page: 480, Index root page: 481 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index TMP_SHOPCART_UNQ (0) 
    Root page: 1544833, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TPAUSE (166) 
    Primary pointer page: 557, Index root page: 558 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index RDB$PRIMARY2 (0) 
    Root page: 1504237, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
TRACE_STAT (157) 
    Primary pointer page: 538, Index root page: 539 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
WARES (142) 
    Primary pointer page: 508, Index root page: 509 
    Total formats: 1, used formats: 1 
    Average record length: 77.52, total records: 400 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 444.00, compression ratio: 5.73 
    Pointer pages: 1, data page slots: 6 
    Data pages: 6, average fill: 77% 
    Primary pages: 6, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 5 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 5 
    80 - 99% = 1 
 
    Index FK_WARES_WARE_GROUPS (3) 
    Root page: 1552183, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 3.17, total dup: 392, max dup: 60 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 48, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index PK_WARES (0) 
    Root page: 1510377, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_ID_DESC (2) 
    Root page: 1510382, depth: 1, leaf buckets: 1, nodes: 400 
    Average node length: 11.22, total dup: 0, max dup: 0 
    Average key length: 10.22, compression ratio: 0.88 
    Average prefix length: 1.78, average data length: 7.22 
    Clustering factor: 344, ratio: 0.86 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 1 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARES_NUMB_UNQ (1) 
    Root page: 1510380, depth: 2, leaf buckets: 3, nodes: 400 
    Average node length: 53.25, total dup: 0, max dup: 0 
    Average key length: 52.23, compression ratio: 1.00 
    Average prefix length: 2.74, average data length: 49.25 
    Clustering factor: 355, ratio: 0.89 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 1 
        80 - 99% = 2 
 
WARE_GROUPS (151) 
    Primary pointer page: 526, Index root page: 527 
    Total formats: 1, used formats: 1 
    Average record length: 32.12, total records: 8 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 346.00, compression ratio: 10.77 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 5% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index PK_WARE_GROUPS (0) 
    Root page: 1504329, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 11.25, total dup: 0, max dup: 0 
    Average key length: 10.12, compression ratio: 0.89 
    Average prefix length: 1.75, average data length: 7.25 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index WARE_GROUPS_NAME_UNQ (1) 
    Root page: 1504330, depth: 1, leaf buckets: 1, nodes: 8 
    Average node length: 19.88, total dup: 0, max dup: 0 
    Average key length: 18.12, compression ratio: 0.89 
    Average prefix length: 0.25, average data length: 15.88 
    Clustering factor: 1, ratio: 0.12 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQD_1000_1200 (176) 
    Primary pointer page: 577, Index root page: 578 
    Total formats: 1, used formats: 1 
    Average record length: 41.09, total records: 167699 
    Average version length: 69.18, total versions: 78310, 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: 3, data page slots: 3992 
    Data pages: 3368, average fill: 60% 
    Primary pages: 3368, secondary pages: 0, swept pages: 444 
    Empty pages: 576, full pages: 2280 
    Fill distribution: 
     0 - 19% = 767 
    20 - 39% = 121 
    40 - 59% = 108 
    60 - 79% = 979 
    80 - 99% = 1393 
 
    Index XQD_1000_1200_WA_SO_RO_WKR_SND (0) 
    Root page: 103324, depth: 3, leaf buckets: 248, nodes: 167699 
    Average node length: 6.49, total dup: 145778, max dup: 14 
    Average key length: 3.93, compression ratio: 10.68 
    Average prefix length: 40.20, average data length: 1.80 
    Clustering factor: 28842, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 31 
        40 - 59% = 133 
        60 - 79% = 65 
        80 - 99% = 18 
 
XQD_1000_3300 (178) 
    Primary pointer page: 581, Index root page: 582 
    Total formats: 1, used formats: 1 
    Average record length: 64.34, total records: 7164018 
    Average version length: 68.79, total versions: 552060, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.96 
    Pointer pages: 65, data page slots: 105984 
    Data pages: 105984, average fill: 73% 
    Primary pages: 105982, secondary pages: 2, swept pages: 11245 
    Empty pages: 16, full pages: 89286 
    Fill distribution: 
     0 - 19% = 131 
    20 - 39% = 852 
    40 - 59% = 4867 
    60 - 79% = 97637 
    80 - 99% = 2497 
 
    Index XQD_1000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1480476, depth: 3, leaf buckets: 10730, nodes: 7164018 
    Average node length: 6.51, total dup: 6194366, max dup: 29 
    Average key length: 3.52, compression ratio: 11.92 
    Average prefix length: 40.61, average data length: 1.39 
    Clustering factor: 1677495, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1386 
        40 - 59% = 6013 
        60 - 79% = 2864 
        80 - 99% = 460 
 
    Index XQD_1000_3300_WKR_DOC_ASC (1) 
    Root page: 1486090, depth: 3, leaf buckets: 8521, nodes: 7164018 
    Average node length: 5.40, total dup: 6878548, max dup: 195 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1483449, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 9 
        20 - 39% = 1134 
        40 - 59% = 4631 
        60 - 79% = 1551 
        80 - 99% = 1196 
 
    Index XQD_1000_3300_WKR_DOC_DEC (2) 
    Root page: 1490630, depth: 3, leaf buckets: 8585, nodes: 7164018 
    Average node length: 5.40, total dup: 6878548, max dup: 195 
    Average key length: 2.41, compression ratio: 7.06 
    Average prefix length: 16.63, average data length: 0.37 
    Clustering factor: 1485814, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 1190 
        40 - 59% = 4655 
        60 - 79% = 1572 
        80 - 99% = 1166 
 
XQD_1200_2000 (177) 
    Primary pointer page: 579, Index root page: 580 
    Total formats: 1, used formats: 1 
    Average record length: 66.87, total records: 12147842 
    Average version length: 68.75, total versions: 418423, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.88 
    Pointer pages: 107, data page slots: 174088 
    Data pages: 174088, average fill: 74% 
    Primary pages: 174087, secondary pages: 1, swept pages: 51026 
    Empty pages: 11, full pages: 167432 
    Fill distribution: 
     0 - 19% = 58 
    20 - 39% = 382 
    40 - 59% = 1970 
    60 - 79% = 168433 
    80 - 99% = 3245 
 
    Index XQD_1200_2000_WA_SO_RO_WKR_SND (0) 
    Root page: 1495050, depth: 3, leaf buckets: 18483, nodes: 12144906 
    Average node length: 6.61, total dup: 10586827, max dup: 62 
    Average key length: 3.43, compression ratio: 12.26 
    Average prefix length: 40.70, average data length: 1.30 
    Clustering factor: 2479355, ratio: 0.20 
    Fill distribution: 
         0 - 19% = 18 
        20 - 39% = 2013 
        40 - 59% = 11062 
        60 - 79% = 4713 
        80 - 99% = 677 
 
XQD_2000_3300 (179) 
    Primary pointer page: 583, Index root page: 584 
    Total formats: 1, used formats: 1 
    Average record length: 41.89, total records: 1702278 
    Average version length: 69.09, total versions: 473976, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.01 
    Pointer pages: 27, data page slots: 42776 
    Data pages: 27768, average fill: 63% 
    Primary pages: 27695, secondary pages: 73, swept pages: 3537 
    Empty pages: 1944, full pages: 22058 
    Fill distribution: 
     0 - 19% = 2752 
    20 - 39% = 3534 
    40 - 59% = 2436 
    60 - 79% = 12492 
    80 - 99% = 6554 
 
    Index XQD_2000_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479735, depth: 3, leaf buckets: 1805, nodes: 1404751 
    Average node length: 5.52, total dup: 1347580, max dup: 49 
    Average key length: 2.57, compression ratio: 16.37 
    Average prefix length: 41.47, average data length: 0.53 
    Clustering factor: 94807, ratio: 0.07 
    Fill distribution: 
         0 - 19% = 13 
        20 - 39% = 330 
        40 - 59% = 859 
        60 - 79% = 485 
        80 - 99% = 118 
 
XQD_2100_3300 (180) 
    Primary pointer page: 585, Index root page: 586 
    Total formats: 1, used formats: 1 
    Average record length: 35.80, total records: 1389283 
    Average version length: 69.06, total versions: 184187, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 3.52 
    Pointer pages: 19, data page slots: 30096 
    Data pages: 25751, average fill: 44% 
    Primary pages: 25750, secondary pages: 1, swept pages: 3169 
    Empty pages: 3300, full pages: 13475 
    Fill distribution: 
     0 - 19% = 6189 
    20 - 39% = 4184 
    40 - 59% = 5856 
    60 - 79% = 9071 
    80 - 99% = 451 
 
    Index XQD_2100_3300_WA_SO_RO_WKR_SND (0) 
    Root page: 1479229, depth: 3, leaf buckets: 1176, nodes: 804535 
    Average node length: 5.93, total dup: 741985, max dup: 77 
    Average key length: 2.99, compression ratio: 14.04 
    Average prefix length: 41.09, average data length: 0.91 
    Clustering factor: 117898, ratio: 0.15 
    Fill distribution: 
         0 - 19% = 2 
        20 - 39% = 292 
        40 - 59% = 572 
        60 - 79% = 286 
        80 - 99% = 24 
 
XQD_3300_3400 (181) 
    Primary pointer page: 587, Index root page: 588 
    Total formats: 1, used formats: 1 
    Average record length: 65.52, total records: 9369742 
    Average version length: 68.98, total versions: 521041, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.92 
    Pointer pages: 90, data page slots: 146632 
    Data pages: 146584, average fill: 69% 
    Primary pages: 146560, secondary pages: 24, swept pages: 37257 
    Empty pages: 434, full pages: 85601 
    Fill distribution: 
     0 - 19% = 1164 
    20 - 39% = 4624 
    40 - 59% = 18485 
    60 - 79% = 118659 
    80 - 99% = 3652 
 
    Index XQD_3300_3400_WA_SO_RO_WKR_SND (0) 
    Root page: 1472612, depth: 3, leaf buckets: 13531, nodes: 9362789 
    Average node length: 6.70, total dup: 7765396, max dup: 14 
    Average key length: 3.67, compression ratio: 11.45 
    Average prefix length: 40.50, average data length: 1.50 
    Clustering factor: 2146630, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 1102 
        40 - 59% = 6719 
        60 - 79% = 4951 
        80 - 99% = 758 
 
XQS_1000_1200 (182) 
    Primary pointer page: 589, Index root page: 590 
    Total formats: 1, used formats: 1 
    Average record length: 82.49, total records: 21126458 
    Average version length: 82.92, total versions: 12714, 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: 319272 
    Data pages: 319272, average fill: 81% 
    Primary pages: 319269, secondary pages: 3, swept pages: 11831 
    Empty pages: 4, full pages: 319263 
    Fill distribution: 
     0 - 19% = 5 
    20 - 39% = 2 
    40 - 59% = 0 
    60 - 79% = 48658 
    80 - 99% = 270607 
 
    Index XQS_1000_1200_DOC_ID (1) 
    Root page: 1426738, depth: 3, leaf buckets: 19356, nodes: 21126458 
    Average node length: 5.72, total dup: 20645964, max dup: 145 
    Average key length: 2.16, compression ratio: 4.16 
    Average prefix length: 8.86, average data length: 0.14 
    Clustering factor: 3279683, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 2 
        40 - 59% = 8116 
        60 - 79% = 553 
        80 - 99% = 10680 
 
    Index XQS_1000_1200_RCV_ID (3) 
    Root page: 1457002, depth: 3, leaf buckets: 17136, nodes: 21126458 
    Average node length: 6.31, total dup: 18566283, max dup: 49 
    Average key length: 2.75, compression ratio: 3.27 
    Average prefix length: 8.37, average data length: 0.63 
    Clustering factor: 915288, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 4 
        20 - 39% = 4 
        40 - 59% = 754 
        60 - 79% = 269 
        80 - 99% = 16105 
 
    Index XQS_1000_1200_SND_ID (2) 
    Root page: 1441095, depth: 3, leaf buckets: 21171, nodes: 21126458 
    Average node length: 6.35, total dup: 18484795, max dup: 29 
    Average key length: 2.79, compression ratio: 3.23 
    Average prefix length: 8.34, average data length: 0.66 
    Clustering factor: 3573361, ratio: 0.17 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 1 
        40 - 59% = 8472 
        60 - 79% = 590 
        80 - 99% = 12101 
 
    Index XQS_1000_1200_WORKER_ID (0) 
    Root page: 1413370, depth: 3, leaf buckets: 16093, nodes: 21126458 
    Average node length: 5.56, total dup: 21126358, max dup: 228843 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 944101, ratio: 0.04 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 6 
        40 - 59% = 2918 
        60 - 79% = 382 
        80 - 99% = 12787 
 
XQS_1000_3300 (184) 
    Primary pointer page: 593, Index root page: 594 
    Total formats: 1, used formats: 1 
    Average record length: 78.57, total records: 9812520 
    Average version length: 82.62, total versions: 514244, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.60 
    Pointer pages: 106, data page slots: 172880 
    Data pages: 172832, average fill: 70% 
    Primary pages: 172796, secondary pages: 36, swept pages: 60584 
    Empty pages: 620, full pages: 105167 
    Fill distribution: 
     0 - 19% = 1594 
    20 - 39% = 5673 
    40 - 59% = 22444 
    60 - 79% = 118915 
    80 - 99% = 24206 
 
    Index XQS_1000_3300_DOC_ID (1) 
    Root page: 1367524, depth: 3, leaf buckets: 11364, nodes: 9812520 
    Average node length: 5.37, total dup: 9502412, max dup: 210 
    Average key length: 2.23, compression ratio: 4.03 
    Average prefix length: 8.80, average data length: 0.20 
    Clustering factor: 2249614, ratio: 0.23 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 55 
        40 - 59% = 7846 
        60 - 79% = 3363 
        80 - 99% = 95 
 
    Index XQS_1000_3300_RCV_ID (3) 
    Root page: 1379283, depth: 3, leaf buckets: 13484, nodes: 9812520 
    Average node length: 6.24, total dup: 8134440, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1591977, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 131 
        20 - 39% = 3710 
        40 - 59% = 4310 
        60 - 79% = 2755 
        80 - 99% = 2578 
 
    Index XQS_1000_3300_SND_ID (2) 
    Root page: 1373081, depth: 3, leaf buckets: 12682, nodes: 9812520 
    Average node length: 5.99, total dup: 8517992, max dup: 44 
    Average key length: 2.85, compression ratio: 3.16 
    Average prefix length: 8.28, average data length: 0.72 
    Clustering factor: 2442248, ratio: 0.25 
    Fill distribution: 
         0 - 19% = 5 
        20 - 39% = 52 
        40 - 59% = 8765 
        60 - 79% = 3727 
        80 - 99% = 133 
 
    Index XQS_1000_3300_WORKER_ID (0) 
    Root page: 1362789, depth: 3, leaf buckets: 10425, nodes: 9812520 
    Average node length: 5.14, total dup: 9812420, max dup: 156718 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.42, average data length: 0.00 
    Clustering factor: 1610139, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 36 
        20 - 39% = 1316 
        40 - 59% = 5314 
        60 - 79% = 1765 
        80 - 99% = 1994 
 
XQS_1200_2000 (183) 
    Primary pointer page: 591, Index root page: 592 
    Total formats: 1, used formats: 1 
    Average record length: 79.88, total records: 11339736 
    Average version length: 82.57, total versions: 374568, 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: 117, data page slots: 189808 
    Data pages: 188680, average fill: 74% 
    Primary pages: 188549, secondary pages: 131, swept pages: 56331 
    Empty pages: 1912, full pages: 152889 
    Fill distribution: 
     0 - 19% = 3236 
    20 - 39% = 5076 
    40 - 59% = 12910 
    60 - 79% = 99653 
    80 - 99% = 67805 
 
    Index XQS_1200_2000_DOC_ID (1) 
    Root page: 1392123, depth: 3, leaf buckets: 13108, nodes: 11339736 
    Average node length: 5.30, total dup: 11230094, max dup: 629 
    Average key length: 2.08, compression ratio: 4.33 
    Average prefix length: 8.93, average data length: 0.07 
    Clustering factor: 2372791, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 82 
        40 - 59% = 9075 
        60 - 79% = 3827 
        80 - 99% = 123 
 
    Index XQS_1200_2000_RCV_ID (3) 
    Root page: 1406132, depth: 3, leaf buckets: 10388, nodes: 11339736 
    Average node length: 5.50, total dup: 10844457, max dup: 49 
    Average key length: 2.28, compression ratio: 3.95 
    Average prefix length: 8.77, average data length: 0.23 
    Clustering factor: 719651, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 147 
        20 - 39% = 815 
        40 - 59% = 2482 
        60 - 79% = 1796 
        80 - 99% = 5148 
 
    Index XQS_1200_2000_SND_ID (2) 
    Root page: 1398660, depth: 3, leaf buckets: 14994, nodes: 11339736 
    Average node length: 6.03, total dup: 9895766, max dup: 71 
    Average key length: 2.80, compression ratio: 3.21 
    Average prefix length: 8.32, average data length: 0.68 
    Clustering factor: 2389238, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 7 
        20 - 39% = 108 
        40 - 59% = 10554 
        60 - 79% = 4173 
        80 - 99% = 152 
 
    Index XQS_1200_2000_WORKER_ID (0) 
    Root page: 1386233, depth: 3, leaf buckets: 10834, nodes: 11339736 
    Average node length: 5.23, total dup: 11339636, max dup: 192056 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 707844, ratio: 0.06 
    Fill distribution: 
         0 - 19% = 84 
        20 - 39% = 864 
        40 - 59% = 4796 
        60 - 79% = 1518 
        80 - 99% = 3572 
 
XQS_2000_3300 (185) 
    Primary pointer page: 595, Index root page: 596 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index XQS_2000_3300_DOC_ID (1) 
    Root page: 1361775, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_RCV_ID (3) 
    Root page: 1361777, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_SND_ID (2) 
    Root page: 1361776, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index XQS_2000_3300_WORKER_ID (0) 
    Root page: 1361774, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
XQS_2100_3300 (186) 
    Primary pointer page: 597, Index root page: 598 
    Total formats: 1, used formats: 1 
    Average record length: 79.16, total records: 9893465 
    Average version length: 82.94, total versions: 479420, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.59 
    Pointer pages: 109, data page slots: 176704 
    Data pages: 176632, average fill: 70% 
    Primary pages: 176601, secondary pages: 31, swept pages: 66951 
    Empty pages: 574, full pages: 102797 
    Fill distribution: 
     0 - 19% = 1645 
    20 - 39% = 6793 
    40 - 59% = 25791 
    60 - 79% = 119605 
    80 - 99% = 22798 
 
    Index XQS_2100_3300_DOC_ID (1) 
    Root page: 1344708, depth: 3, leaf buckets: 11924, nodes: 9893465 
    Average node length: 5.19, total dup: 9864236, max dup: 2346 
    Average key length: 2.03, compression ratio: 4.43 
    Average prefix length: 8.97, average data length: 0.03 
    Clustering factor: 2048703, ratio: 0.21 
    Fill distribution: 
         0 - 19% = 38 
        20 - 39% = 1457 
        40 - 59% = 7899 
        60 - 79% = 1891 
        80 - 99% = 639 
 
    Index XQS_2100_3300_RCV_ID (3) 
    Root page: 1355739, depth: 3, leaf buckets: 13621, nodes: 9893465 
    Average node length: 6.26, total dup: 8201133, max dup: 14 
    Average key length: 3.10, compression ratio: 2.90 
    Average prefix length: 8.07, average data length: 0.93 
    Clustering factor: 1554171, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 170 
        20 - 39% = 3752 
        40 - 59% = 4338 
        60 - 79% = 2731 
        80 - 99% = 2630 
 
    Index XQS_2100_3300_SND_ID (2) 
    Root page: 1350071, depth: 3, leaf buckets: 12540, nodes: 9893465 
    Average node length: 5.44, total dup: 9452136, max dup: 99 
    Average key length: 2.29, compression ratio: 3.94 
    Average prefix length: 8.76, average data length: 0.24 
    Clustering factor: 2182923, ratio: 0.22 
    Fill distribution: 
         0 - 19% = 25 
        20 - 39% = 1405 
        40 - 59% = 8809 
        60 - 79% = 1693 
        80 - 99% = 608 
 
    Index XQS_2100_3300_WORKER_ID (0) 
    Root page: 987843, depth: 3, leaf buckets: 10599, nodes: 9893465 
    Average node length: 5.16, total dup: 9893365, max dup: 158473 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 1627589, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 39 
        20 - 39% = 1426 
        40 - 59% = 5414 
        60 - 79% = 1727 
        80 - 99% = 1993 
 
XQS_3300_3400 (187) 
    Primary pointer page: 599, Index root page: 600 
    Total formats: 1, used formats: 1 
    Average record length: 67.44, total records: 579507 
    Average version length: 68.77, total versions: 7210, max versions: 1 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 126.00, compression ratio: 1.87 
    Pointer pages: 5, data page slots: 8096 
    Data pages: 8096, average fill: 75% 
    Primary pages: 8096, secondary pages: 0, swept pages: 3123 
    Empty pages: 2, full pages: 7280 
    Fill distribution: 
     0 - 19% = 4 
    20 - 39% = 7 
    40 - 59% = 140 
    60 - 79% = 7825 
    80 - 99% = 120 
 
    Index XQS_3300_3400_DOC_ID (1) 
    Root page: 43295, depth: 3, leaf buckets: 743, nodes: 579507 
    Average node length: 5.95, total dup: 493236, max dup: 82 
    Average key length: 3.09, compression ratio: 2.91 
    Average prefix length: 8.05, average data length: 0.95 
    Clustering factor: 101913, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 0 
        20 - 39% = 20 
        40 - 59% = 547 
        60 - 79% = 90 
        80 - 99% = 86 
 
    Index XQS_3300_3400_SND_ID (2) 
    Root page: 32585, depth: 3, leaf buckets: 759, nodes: 579507 
    Average node length: 6.15, total dup: 475330, max dup: 19 
    Average key length: 3.29, compression ratio: 2.73 
    Average prefix length: 7.89, average data length: 1.11 
    Clustering factor: 101970, ratio: 0.18 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 22 
        40 - 59% = 542 
        60 - 79% = 88 
        80 - 99% = 106 
 
    Index XQS_3300_3400_WORKER_ID (0) 
    Root page: 377587, depth: 2, leaf buckets: 567, nodes: 579507 
    Average node length: 4.86, total dup: 579407, max dup: 9984 
    Average key length: 2.00, compression ratio: 1.21 
    Average prefix length: 2.41, average data length: 0.00 
    Clustering factor: 90531, ratio: 0.16 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 36 
        40 - 59% = 324 
        60 - 79% = 67 
        80 - 99% = 139 
 
ZDOC_DATA (170) 
    Primary pointer page: 565, Index root page: 566 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZDOC_LIST (169) 
    Primary pointer page: 563, Index root page: 564 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZINVNT_TURNOVER_LOG (171) 
    Primary pointer page: 567, Index root page: 568 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZPDISTR (174) 
    Primary pointer page: 573, Index root page: 574 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPDISTR_ID (0) 
    Root page: 1504230, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZPSTORNED (175) 
    Primary pointer page: 575, Index root page: 576 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZPSTORNED_ID (0) 
    Root page: 1504229, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQDISTR (172) 
    Primary pointer page: 569, Index root page: 570 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQDISTR_ID (0) 
    Root page: 1504235, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
    Root page: 1504236, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZQSTORNED (173) 
    Primary pointer page: 571, Index root page: 572 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index ZQSTORNED_DOC_ID (1) 
    Root page: 1504232, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_ID (0) 
    Root page: 1504231, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_RCV_ID (3) 
    Root page: 1504234, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
    Index ZQSTORNED_SND_ID (2) 
    Root page: 1504233, depth: 1, leaf buckets: 1, nodes: 0 
    Average node length: 0.00, total dup: 0, max dup: 0 
    Average key length: 0.00, compression ratio: 0.00 
    Average prefix length: 0.00, average data length: 0.00 
    Clustering factor: 0, ratio: 0.00 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
ZTMP_DEP_DOCS (168) 
    Primary pointer page: 561, Index root page: 562 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
ZTMP_SHOPPING_CART (167) 
    Primary pointer page: 559, Index root page: 560 
    Total formats: 1, used formats: 0 
    Average record length: 0.00, total records: 0 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 0.00, compression ratio: 0.00 
    Pointer pages: 1, data page slots: 0 
    Data pages: 0, average fill: 0% 
    Primary pages: 0, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 0 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
Z_USED_VIEWS (144) 
    Primary pointer page: 512, Index root page: 513 
    Total formats: 1, used formats: 1 
    Average record length: 29.38, total records: 29 
    Average version length: 0.00, total versions: 0, max versions: 0 
    Average fragment length: 0.00, total fragments: 0, max fragments: 0 
    Average unpacked length: 99.00, compression ratio: 3.37 
    Pointer pages: 1, data page slots: 1 
    Data pages: 1, average fill: 16% 
    Primary pages: 1, secondary pages: 0, swept pages: 0 
    Empty pages: 0, full pages: 0 
    Fill distribution: 
     0 - 19% = 1 
    20 - 39% = 0 
    40 - 59% = 0 
    60 - 79% = 0 
    80 - 99% = 0 
 
    Index Z_USED_VIEWS_UNQ (0) 
    Root page: 1510372, depth: 1, leaf buckets: 1, nodes: 29 
    Average node length: 15.17, total dup: 0, max dup: 0 
    Average key length: 14.14, compression ratio: 1.44 
    Average prefix length: 9.17, average data length: 11.17 
    Clustering factor: 1, ratio: 0.03 
    Fill distribution: 
         0 - 19% = 1 
        20 - 39% = 0 
        40 - 59% = 0 
        60 - 79% = 0 
        80 - 99% = 0 
 
Gstat completion time Wed Mar  6 07:09:52 2024

Record versions statistics, table

TABLE_NAME TOTAL_RECS TOTAL_VERS MAX_VERSIONS VERS_TO_RECS_PRC MAXV_TO_VERS_PRC
DOC_DATA 7787219 105203 1 0.0000 0.0000
DOC_LIST 2266502 53893 2 0.0000 0.0000
FB_ERRORS 2182 757 1 0.0000 0.0000
INVNT_SALDO 400 1525 4 300.0000 0.0000
INVNT_TURNOVER_LOG 110718 90791 1 0.0000 0.0000
MONEY_SALDO 49 238 8 400.0000 0.0000
MONEY_TURNOVER_LOG 1644 1423 1 0.0000 0.0000
PDISTR 809472 39858 3 0.0000 0.0000
PERF_SPLIT_0 168281 2310 1 0.0000 0.0000
PERF_SPLIT_1 152731 2502 1 0.0000 0.0000
PERF_SPLIT_2 182540 35650 1 0.0000 0.0000
PERF_SPLIT_3 137119 4673 1 0.0000 0.0000
PERF_SPLIT_4 159578 2042 1 0.0000 0.0000
PERF_SPLIT_5 154847 2366 1 0.0000 0.0000
PERF_SPLIT_6 167580 4531 1 0.0000 0.0000
PERF_SPLIT_7 155481 4961 1 0.0000 0.0000
PERF_SPLIT_8 156085 1581 1 0.0000 0.0000
PERF_SPLIT_9 170965 10279 1 0.0000 0.0000
PSTORNED 2129761 44565 1 0.0000 0.0000
SEMAPHORES 5 1 1 0.0000 100.0000
XQD_1000_1200 167699 78310 1 0.0000 0.0000
XQD_1000_3300 7164018 552060 1 0.0000 0.0000
XQD_1200_2000 12147842 418423 1 0.0000 0.0000
XQD_2000_3300 1702278 473976 1 0.0000 0.0000
XQD_2100_3300 1389283 184187 1 0.0000 0.0000
XQD_3300_3400 9369742 521041 1 0.0000 0.0000
XQS_1000_1200 21126458 12714 1 0.0000 0.0000
XQS_1000_3300 9812520 514244 1 0.0000 0.0000
XQS_1200_2000 11339736 374568 1 0.0000 0.0000
XQS_2100_3300 9893465 479420 1 0.0000 0.0000
XQS_3300_3400 579507 7210 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 ---
:226: 
:227: mscs-test-161.budzdorov.ru    Wed Mar  6 07:07:57 2024
:228:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:229: 
--- end of diff output ---

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

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