Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-01-19 1:37:24.14.
Common Performance Final Results
  1. Test configuration
  2. Test Finish details
  3. Test workload details
  4. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score
  2. Performance, DYNAMIC, 10 intervals
  3. Performance, per MINUTE, since launch
  4. Performance, TRACE data for ISQL #1
  5. Performance, DETAILS per units
  6. MON$-analysis, per business units
  7. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database Statistics, full
  3. Ratio "Versions / Records" for tables
  4. Database Validation Results
  5. New in firebird.log while test was run
  6. Final processing of ISQL logs

Server and database settings

Server version: WI-T4.0.0.503 Firebird 4.0 Unstable
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperServer 4.0.0 D:\OLTP-EMUL\OLTP40-SMALL.FDB ON 0 786432 8192

Test configuration settings

File: E:\OLTP-EMUL\src\oltp40_config.win
PARAM_NAME PARAM_VALUE
fbc E:\FB40.TMPINSTANCE
dbnm D:\OLTP-EMUL\oltp40-small.fdb
host localhost
port 3400
usr SYSDBA
pwd masterkey
tmpdir e:\temp\logs.oltp40
working_mode small_03
warm_time 0
test_time 180
idle_time 0
use_mtee 0
is_embed 0
remove_isql_logs if_no_severe_errors
no_auto_undo 1
detailed_info 0
mon_unit_perf 0
trc_unit_perf 1
init_buff 32768
create_with_fw sync
create_with_sweep 0
wait_if_not_exists 0
wait_after_create 0
init_docs 100000
wait_for_copy 0
create_with_debug_objects 1
create_with_split_heavy_tabs 1
create_with_separate_qdistr_idx 0
create_with_compound_columns_order most_selective_first
make_html 1
run_db_statistics 1
run_db_validation 1
file_name_with_test_params regular
file_name_this_host_info cpu_8x3Ghz_ram_16gb
upload_report 1
max_snapshots_to_store 180
replace_instance 1
etalon_dbnm E:\OLTP-EMUL\oltp40-docs_100000-fw__ON.fdb
used_in_replication 0

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2017-01-19 01:34:29.9260 -1 <null> ::1/62510 399753 9091 2

Current test settings

CATEGORY SETTING VAL
COMMON TRACED_UNITS ,,
COMMON ENABLE_MON_QUERY 0
COMMON HALT_TEST_ON_ERRORS ,CK,
COMMON QMISM_VERIFY_BITSET 1
COMMON RECALC_IDX_MIN_INTERVAL 15
COMMON ENABLE_RESERVES_WHEN_ADD_INVOICE 1
COMMON ORDER_FOR_OUR_FIRM_PERCENT 25
COMMON ENABLE_FILL_PHRASES 0
COMMON RANDOM_SEEK_VIA_ROWS_LIMIT 0
COMMON C_INVOICE_MIN_PURCHASE 1000
COMMON C_INVOICE_MAX_PURCHASE 2000
COMMON C_INVOICE_MIN_PROFIT_PRC 35
COMMON C_INVOICE_MAX_PROFIT_PRC 80
COMMON C_MIN_COST_TO_BE_SPLITTED 1000
COMMON C_ROWS_TO_MULTIPLY 10
COMMON C_PAYMENT_FROM_CLIENT_MIN_TOTAL 1000
COMMON C_PAYMENT_FROM_CLIENT_MAX_TOTAL 5000
COMMON C_PAYMENT_TO_SUPPLIER_MIN_TOTAL 2000
COMMON C_PAYMENT_TO_SUPPLIER_MAX_TOTAL 15000
COMMON BUILD_WITH_SPLIT_HEAVY_TABS 1
COMMON BUILD_WITH_SEPAR_QDISTR_IDX 0
COMMON BUILD_WITH_QD_COMPOUND_ORDR MOST_SELECTIVE_FIRST
SMALL_03 C_WARES_MAX_ID 400
SMALL_03 C_CUSTOMER_DOC_MAX_ROWS 10
SMALL_03 C_SUPPLIER_DOC_MAX_ROWS 50
SMALL_03 C_CUSTOMER_DOC_MAX_QTY 15
SMALL_03 C_SUPPLIER_DOC_MAX_QTY 50
SMALL_03 C_NUMBER_OF_AGENTS 50

Index(es) for heavy-loaded table(s)

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_DOC DOC_ID
XQD_1000_3300 XQD_1000_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1200_2000 XQD_1200_2000_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID

Performance reports

Performance in TOTAL:

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 5617.39 2545 1011131 2017-01-18 22:34 2017-01-19 01:34
customer order: creation 399.01 339 71822 2017-01-18 22:34 2017-01-19 01:34
customer order: refuse 34.02 176 6123 2017-01-18 22:34 2017-01-19 01:34
order to supplier: creation 102.45 1423 18441 2017-01-18 22:34 2017-01-19 01:34
order to supplier: removal 2.84 17569 512 2017-01-18 22:34 2017-01-19 01:34
invoice (draft): creation 102.01 2120 18361 2017-01-18 22:34 2017-01-19 01:34
invoice (draft): removal 37.76 418 6796 2017-01-18 22:34 2017-01-19 01:34
invoice accept: apply 58.13 10041 10464 2017-01-18 22:34 2017-01-19 01:34
invoice accept: cancel 18.26 1865 3286 2017-01-18 22:34 2017-01-19 01:34
customer reserve: creation 3204.64 153 576836 2017-01-18 22:34 2017-01-19 01:34
customer reserve: removal 1092.87 47 196717 2017-01-18 22:34 2017-01-19 01:34
realization accept: apply 187.59 409 33766 2017-01-18 22:34 2017-01-19 01:34
realization accept: cancel 88.38 105 15909 2017-01-18 22:34 2017-01-19 01:34
payment from customer: creation 132.51 682 23852 2017-01-18 22:34 2017-01-19 01:34
payment from customer: removal 12.36 82 2224 2017-01-18 22:34 2017-01-19 01:34
payment to supplier: creation 109.59 284 19726 2017-01-18 22:34 2017-01-19 01:34
payment to supplier: removal 7.56 96 1360 2017-01-18 22:34 2017-01-19 01:34
service: total inventory turnovers 11.55 1972 2079 2017-01-18 22:34 2017-01-19 01:34
service: total monetary turnovers 15.81 38 2845 2017-01-18 22:34 2017-01-19 01:34
service: refresh index statistics 0.07 10539 12 2017-01-18 22:34 2017-01-19 01:34
Done for 37770 ms, from 1:39:07.21 to 1:39:44.98.

Performance in DYNAMIC:

RUNTIME FAULT:

set list on;
-- Get performance report with splitting data to 10 equal time intervals,
-- for last 3 hours of activity:
set width action 24;
set width itrv_no 7;
set width itrv_beg 8;
set width itrv_end 8;
select business_action as action
,cast(interval_no as smallint) as itrv_no
,cnt_ok_per_minute
,cnt_all
,cnt_ok
,cnt_err
,cast(err_prc as numeric(8,2)) as err_prc
,substring(cast(interval_beg as varchar(24)) from 12 for 8) itrv_beg
,substring(cast(interval_end as varchar(24)) from 12 for 8) itrv_end
from rdb$database
left join srv_mon_perf_dynamic p on
-- where
p.business_action containing 'interval'
and p.business_action containing 'overall';
commit;
Statement failed, SQLSTATE = 54000
Implementation limit exceeded
-block size exceeds implementation restriction
-At procedure 'SRV_MON_PERF_DYNAMIC' line: 32, col: 5
After line 7 in file e:\temp\logs.oltp40\make_html_table.tmp.sql
ACTION ITRV_NO CNT_OK_PER_MINUTE CNT_ALL CNT_OK CNT_ERR ERR_PRC ITRV_BEG ITRV_END
Done for 41190 ms, from 1:40:19.18 to 1:41:00.37.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
TEST_TIME 1 3949.52 0.3916 1.5290 1938 11
TEST_TIME 2 3904.70 0.7734 1.1866 1371 18
TEST_TIME 3 3687.27 0.8378 1.1470 1351 13
TEST_TIME 4 3612.66 0.8780 1.1274 1305 16
TEST_TIME 5 3552.51 0.9172 1.1069 991 16
TEST_TIME 6 3682.52 0.8899 1.1054 1405 18
TEST_TIME 7 3855.09 0.9051 1.0738 1634 17
TEST_TIME 8 3962.15 0.9156 1.0859 1801 16
TEST_TIME 9 4096.48 0.9336 1.0724 1562 19
TEST_TIME 10 4221.95 0.9371 1.0660 1666 15
TEST_TIME 11 4333.73 0.9442 1.0516 1506 18
TEST_TIME 12 4431.51 0.9427 1.0631 1763 18
TEST_TIME 13 4603.72 0.9446 1.0650 1426 17
TEST_TIME 14 4730.89 0.9627 1.0400 1342 13
TEST_TIME 15 4790.56 0.9586 1.0408 1517 14
TEST_TIME 16 4841.97 0.9656 1.0342 1441 18
TEST_TIME 17 4891.77 0.9634 1.0289 1422 17
TEST_TIME 18 4917.35 0.9667 1.0360 1280 18
TEST_TIME 19 4978.88 0.9697 1.0278 1348 20
TEST_TIME 20 4983.05 0.9756 1.0231 1082 46
TEST_TIME 21 4995.73 0.9726 1.0282 1478 100
TEST_TIME 22 5073.99 0.9664 1.0306 1582 100
TEST_TIME 23 5172.72 0.9677 1.0316 1645 100
TEST_TIME 24 5241.38 0.9758 1.0242 1635 100
TEST_TIME 25 5292.70 0.9737 1.0235 1700 100
TEST_TIME 26 5337.19 0.9759 1.0272 1542 100
TEST_TIME 27 5404.46 0.9769 1.0250 1502 100
TEST_TIME 28 5454.87 0.9793 1.0207 1277 100
TEST_TIME 29 5457.08 0.9851 1.0126 1423 100
TEST_TIME 30 5483.06 0.9742 1.0189 1335 100
TEST_TIME 31 5497.32 0.9835 1.0172 1396 100
TEST_TIME 32 5503.23 0.9844 1.0139 1189 100
TEST_TIME 33 5467.97 0.9900 1.0095 1281 100
TEST_TIME 34 5493.70 0.9752 1.0185 1121 100
TEST_TIME 35 5507.98 0.9869 1.0095 1199 100
TEST_TIME 36 5522.29 0.9803 1.0175 1659 100
TEST_TIME 37 5574.11 0.9808 1.0186 1737 100
TEST_TIME 38 5629.81 0.9820 1.0167 1540 100
TEST_TIME 39 5630.48 0.9905 1.0134 1457 100
TEST_TIME 40 5623.95 0.9892 1.0090 1466 100
TEST_TIME 41 5607.05 0.9874 1.0130 1452 78
TEST_TIME 42 5617.19 0.9871 1.0119 1486 37
TEST_TIME 43 5630.27 0.9861 1.0119 1415 29
TEST_TIME 44 5642.01 0.9869 1.0129 1393 27
TEST_TIME 45 5631.21 0.9923 1.0089 1113 33
TEST_TIME 46 5598.27 0.9927 1.0075 827 99
TEST_TIME 47 5577.36 0.9898 1.0067 1033 100
TEST_TIME 48 5563.30 0.9883 1.0072 1289 100
TEST_TIME 49 5547.01 0.9926 1.0081 1250 100
TEST_TIME 50 5519.71 0.9928 1.0048 1328 99
TEST_TIME 51 5501.59 0.9883 1.0102 1457 100
TEST_TIME 52 5509.43 0.9894 1.0054 1675 100
TEST_TIME 53 5479.47 0.9919 1.0087 1590 97
TEST_TIME 54 5479.16 0.9901 1.0074 1592 95
TEST_TIME 55 5471.39 0.9905 1.0092 1512 98
TEST_TIME 56 5489.62 0.9920 1.0062 1509 98
TEST_TIME 57 5465.21 0.9930 1.0078 1501 98
TEST_TIME 58 5479.12 0.9879 1.0080 1353 100
TEST_TIME 59 5486.79 0.9895 1.0103 1527 100
TEST_TIME 60 5498.56 0.9915 1.0105 1457 100
TEST_TIME 61 5505.57 0.9926 1.0075 1293 100
TEST_TIME 62 5505.39 0.9913 1.0068 1279 100
TEST_TIME 63 5521.89 0.9879 1.0090 1315 100
TEST_TIME 64 5524.06 0.9929 1.0090 1281 100
TEST_TIME 65 5533.22 0.9919 1.0080 1111 100
TEST_TIME 66 5539.06 0.9925 1.0060 1565 100
TEST_TIME 67 5536.61 0.9914 1.0061 1407 100
TEST_TIME 68 5520.77 0.9941 1.0077 1614 96
TEST_TIME 69 5520.67 0.9931 1.0044 1429 88
TEST_TIME 70 5524.52 0.9894 1.0063 1347 100
TEST_TIME 71 5518.52 0.9932 1.0059 1288 100
TEST_TIME 72 5527.22 0.9907 1.0077 1597 100
TEST_TIME 73 5527.19 0.9939 1.0059 1437 100
TEST_TIME 74 5521.22 0.9934 1.0083 1407 100
TEST_TIME 75 5548.97 0.9899 1.0094 1353 100
TEST_TIME 76 5564.38 0.9935 1.0101 1344 100
TEST_TIME 77 5579.08 0.9944 1.0069 1355 100
TEST_TIME 78 5580.26 0.9938 1.0064 1340 100
TEST_TIME 79 5582.95 0.9932 1.0053 1305 100
TEST_TIME 80 5576.60 0.9939 1.0047 1270 100
TEST_TIME 81 5576.56 0.9923 1.0086 1711 100
TEST_TIME 82 5602.14 0.9918 1.0071 1389 100
TEST_TIME 83 5611.82 0.9938 1.0074 1646 100
TEST_TIME 84 5639.80 0.9904 1.0073 1577 100
TEST_TIME 85 5659.84 0.9919 1.0062 1496 100
TEST_TIME 86 5665.76 0.9935 1.0063 1141 99
TEST_TIME 87 5660.60 0.9957 1.0038 1300 100
TEST_TIME 88 5651.96 0.9941 1.0035 1320 100
TEST_TIME 89 5632.94 0.9956 1.0038 1307 92
TEST_TIME 90 5610.83 0.9965 1.0077 1199 80
TEST_TIME 91 5621.93 0.9947 1.0020 909 100
TEST_TIME 92 5582.98 0.9981 1.0028 919 76
TEST_TIME 93 5580.49 0.9925 1.0035 901 98
TEST_TIME 94 5560.99 0.9963 1.0037 1276 98
TEST_TIME 95 5556.89 0.9938 1.0054 1049 100
TEST_TIME 96 5563.46 0.9938 1.0061 1404 100
TEST_TIME 97 5592.61 0.9906 1.0065 1386 100
TEST_TIME 98 5599.85 0.9950 1.0065 1775 100
TEST_TIME 99 5619.39 0.9929 1.0061 1581 100
TEST_TIME 100 5632.65 0.9937 1.0074 1280 100
TEST_TIME 101 5657.56 0.9931 1.0062 1383 100
TEST_TIME 102 5677.29 0.9929 1.0073 1412 100
TEST_TIME 103 5695.86 0.9943 1.0072 1307 100
TEST_TIME 104 5718.42 0.9936 1.0062 1239 100
TEST_TIME 105 5722.81 0.9958 1.0051 1241 100
TEST_TIME 106 5731.04 0.9943 1.0042 1193 100
TEST_TIME 107 5731.71 0.9947 1.0036 1051 100
TEST_TIME 108 5718.52 0.9966 1.0040 1143 100
TEST_TIME 109 5716.49 0.9951 1.0036 1093 100
TEST_TIME 110 5697.08 0.9979 1.0025 1169 99
TEST_TIME 111 5677.84 0.9968 1.0035 1260 95
TEST_TIME 112 5686.35 0.9930 1.0055 1345 93
TEST_TIME 113 5691.69 0.9957 1.0060 1449 87
TEST_TIME 114 5696.43 0.9963 1.0042 1573 69
TEST_TIME 115 5698.63 0.9951 1.0054 1401 43
TEST_TIME 116 5715.27 0.9938 1.0048 1361 33
TEST_TIME 117 5729.15 0.9938 1.0053 1243 32
TEST_TIME 118 5733.94 0.9959 1.0047 1027 45
TEST_TIME 119 5727.09 0.9975 1.0031 1188 75
TEST_TIME 120 5723.94 0.9953 1.0031 1152 99
TEST_TIME 121 5702.63 0.9986 1.0013 1178 89
TEST_TIME 122 5674.51 0.9980 1.0021 1029 75
TEST_TIME 123 5656.12 0.9972 1.0034 1073 80
TEST_TIME 124 5659.83 0.9947 1.0037 1076 94
TEST_TIME 125 5649.51 0.9975 1.0022 912 73
TEST_TIME 126 5626.78 0.9982 1.0020 921 73
TEST_TIME 127 5608.52 0.9973 1.0028 1211 77
TEST_TIME 128 5602.70 0.9960 1.0035 1249 80
TEST_TIME 129 5617.60 0.9958 1.0021 1488 98
TEST_TIME 130 5612.40 0.9953 1.0049 1397 99
TEST_TIME 131 5627.75 0.9945 1.0053 1341 100
TEST_TIME 132 5646.14 0.9944 1.0056 1395 100
TEST_TIME 133 5661.16 0.9954 1.0052 1428 100
TEST_TIME 134 5670.58 0.9960 1.0042 1127 100
TEST_TIME 135 5673.32 0.9963 1.0053 1237 100
TEST_TIME 136 5686.61 0.9956 1.0043 1162 100
TEST_TIME 137 5703.97 0.9940 1.0049 1105 100
TEST_TIME 138 5709.10 0.9968 1.0041 1202 100
TEST_TIME 139 5717.06 0.9955 1.0036 1163 100
TEST_TIME 140 5716.47 0.9966 1.0017 1124 99
TEST_TIME 141 5706.34 0.9963 1.0037 1276 95
TEST_TIME 142 5710.67 0.9959 1.0033 1335 92
TEST_TIME 143 5715.28 0.9955 1.0025 1283 98
TEST_TIME 144 5709.74 0.9965 1.0043 1125 100
TEST_TIME 145 5706.71 0.9979 1.0018 1289 100
TEST_TIME 146 5705.07 0.9965 1.0028 1307 100
TEST_TIME 147 5694.24 0.9979 1.0032 1319 98
TEST_TIME 148 5688.04 0.9975 1.0019 1328 93
TEST_TIME 149 5671.71 0.9981 1.0022 1173 87
TEST_TIME 150 5663.37 0.9970 1.0023 1279 91
TEST_TIME 151 5664.51 0.9954 1.0032 1147 100
TEST_TIME 152 5675.59 0.9946 1.0031 1058 100
TEST_TIME 153 5663.71 0.9987 1.0019 1165 95
TEST_TIME 154 5657.04 0.9966 1.0027 1084 94
TEST_TIME 155 5648.84 0.9977 1.0046 1073 96
TEST_TIME 156 5655.78 0.9970 1.0044 1348 100
TEST_TIME 157 5669.02 0.9957 1.0030 1481 100
TEST_TIME 158 5661.24 0.9980 1.0025 1442 98
TEST_TIME 159 5657.05 0.9969 1.0026 1420 97
TEST_TIME 160 5651.41 0.9973 1.0029 1399 96
TEST_TIME 161 5647.04 0.9974 1.0028 1431 96
TEST_TIME 162 5644.34 0.9971 1.0024 1353 94
TEST_TIME 163 5642.21 0.9966 1.0029 1170 96
TEST_TIME 164 5635.07 0.9980 1.0026 1084 93
TEST_TIME 165 5636.01 0.9964 1.0021 1020 99
TEST_TIME 166 5636.95 0.9962 1.0028 1140 98
TEST_TIME 167 5648.77 0.9974 1.0010 983 100
TEST_TIME 168 5638.84 0.9968 1.0036 1082 100
TEST_TIME 169 5634.67 0.9984 1.0022 1264 100
TEST_TIME 170 5620.35 0.9988 1.0012 1180 95
TEST_TIME 171 5625.03 0.9961 1.0046 1299 99
TEST_TIME 172 5637.33 0.9965 1.0018 970 100
TEST_TIME 173 5624.01 0.9984 1.0025 1436 98
TEST_TIME 174 5621.68 0.9972 1.0029 1419 97
TEST_TIME 175 5617.47 0.9979 1.0023 1294 97
TEST_TIME 176 5615.37 0.9970 1.0024 1299 97
TEST_TIME 177 5624.86 0.9951 1.0040 1056 100
TEST_TIME 178 5633.54 0.9968 1.0017 1246 100
TEST_TIME 179 5619.84 0.9985 1.0021 1379 95
TEST_TIME 180 5608.04 0.9986 1.0016 705 96
Done for 10680 ms, from 1:41:01.39 to 1:41:12.07.

Performance from TRACE for ISQL instance #1:

TRACED_DATA ITRV_NO SP_CLIENT_ORDER SP_CANCEL_CLIENT_ORDER SP_SUPPLIER_ORDER SP_CANCEL_SUPPLIER_ORDER SP_SUPPLIER_INVOICE SP_CANCEL_SUPPLIER_INVOICE SP_ADD_INVOICE_TO_STOCK SP_CANCEL_ADDING_INVOICE SP_CUSTOMER_RESERVE SP_CANCEL_CUSTOMER_RESERVE SP_RESERVE_WRITE_OFF SP_CANCEL_WRITE_OFF SP_PAY_FROM_CUSTOMER SP_CANCEL_PAY_FROM_CUSTOMER SP_PAY_TO_SUPPLIER SP_CANCEL_PAY_TO_SUPPLIER SRV_MAKE_INVNT_SALDO SRV_MAKE_MONEY_SALDO SRV_RECALC_IDX_STAT ITRV_BEG ITRV_END
fetches per second 1 41381 62225 40899 46877 51864 19767 48912 45270 53069 65428 50766 44709 58683 52240 90868 47675 269003 318823 <null> 22:34:30 22:52:30
fetches per second 2 60135 106685 56819 114047 61201 75599 81052 34526 40235 105700 65620 79088 78598 102883 104740 <null> 103746 229583 <null> 22:52:31 23:10:31
fetches per second 3 23263 5121 20732 160823 28830 2823 42218 <null> 2382 11287 40100 24750 20463 <null> 36851 57170 174785 18260 <null> 23:10:32 23:28:32
fetches per second 4 24104 38965 29104 <null> 23753 3054 58608 84601 6369 54220 41989 36801 45549 46443 33326 50063 11535 136189 <null> 23:28:33 23:46:33
fetches per second 5 61313 90826 63260 <null> 65251 66400 82610 152876 60043 36650 72149 2416 68881 41473 71846 89320 120748 437782 <null> 23:46:34 00:04:34
fetches per second 6 47965 91452 40687 3172 58697 20971 74983 106996 77565 <null> 60385 <null> 80945 115542 87427 12596 89176 738850 <null> 00:04:35 00:22:35
fetches per second 7 10843 13412 15976 <null> 8584 <null> 23937 15680 2134 9114 21218 2379 16822 48048 25075 23044 40737 43481 <null> 00:22:36 00:40:36
fetches per second 8 48963 21685 40270 <null> 29479 31617 58224 <null> 2578 35305 46662 11268 49571 5500 57618 <null> 46766 145675 <null> 00:40:37 00:58:37
fetches per second 9 10827 6715 3665 <null> 17604 <null> 13882 <null> 2971 34460 4963 11744 17857 6018 12098 <null> 155029 38647 <null> 00:58:38 01:16:38
fetches per second 10 8919 31454 22346 5732 11334 1724 39317 <null> 7000 10925 22848 2522 12210 4697 14796 20653 <null> 137140 <null> 01:16:39 01:34:39
marks per second 1 9478 8412 9107 10452 11386 4505 7373 9269 9077 12057 10262 7803 5325 9375 8659 8944 9329 19864 <null> 22:34:30 22:52:30
marks per second 2 13530 15153 12760 23441 13649 15766 12144 6779 5607 21805 11916 14167 6048 18346 11747 <null> 10363 23600 <null> 22:52:31 23:10:31
marks per second 3 5244 687 4520 34625 6402 770 6718 <null> 373 1870 6132 4480 2157 <null> 3637 11602 14235 782 <null> 23:10:32 23:28:32
marks per second 4 5280 5352 6304 <null> 5420 671 8691 13806 901 9077 6221 6736 3125 7433 5216 9118 857 14832 <null> 23:28:33 23:46:33
marks per second 5 13237 12606 13608 <null> 14318 15114 12632 26994 8376 6282 8575 367 3460 7055 13437 16869 20520 33495 <null> 23:46:34 00:04:34
marks per second 6 10208 11452 8905 789 13028 5254 11091 17991 9898 <null> 9298 <null> 4433 18875 16681 2048 9076 43970 <null> 00:04:35 00:22:35
marks per second 7 2373 1841 2923 <null> 1593 <null> 2825 2717 315 1594 3211 395 778 4311 2882 3560 6933 2914 <null> 00:22:36 00:40:36
marks per second 8 10416 3017 7293 <null> 6780 7794 8987 <null> 361 6000 5853 1947 2278 803 9526 <null> 6369 10802 <null> 00:40:37 00:58:37
marks per second 9 2360 890 632 <null> 2706 <null> 1543 <null> 370 3380 711 1635 845 963 1680 <null> 22177 696 <null> 00:58:38 01:16:38
marks per second 10 1872 4918 4402 1376 1899 428 5793 <null> 534 2268 2870 466 464 783 2167 4428 <null> 8802 <null> 01:16:39 01:34:39
reads/fetches*100 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 22:34:30 22:52:30
reads/fetches*100 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 22:52:31 23:10:31
reads/fetches*100 3 0 0 0 0 0 0 0 <null> 0 0 0 0 0 <null> 0 0 0 0 <null> 23:10:32 23:28:32
reads/fetches*100 4 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 23:28:33 23:46:33
reads/fetches*100 5 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 23:46:34 00:04:34
reads/fetches*100 6 0 0 0 0 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 <null> 00:04:35 00:22:35
reads/fetches*100 7 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 00:22:36 00:40:36
reads/fetches*100 8 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 00:40:37 00:58:37
reads/fetches*100 9 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 00:58:38 01:16:38
reads/fetches*100 10 0 0 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 <null> 0 <null> 01:16:39 01:34:39
writes/marks*100 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 3 0 <null> 22:34:30 22:52:30
writes/marks*100 2 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 <null> 3 0 <null> 22:52:31 23:10:31
writes/marks*100 3 0 1 0 0 0 0 0 <null> 0 4 0 0 0 <null> 0 0 5 0 <null> 23:10:32 23:28:32
writes/marks*100 4 0 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 5 0 <null> 23:28:33 23:46:33
writes/marks*100 5 0 0 0 <null> 0 0 0 0 1 1 0 0 0 0 0 0 3 0 <null> 23:46:34 00:04:34
writes/marks*100 6 0 0 0 0 0 0 0 0 0 <null> 0 <null> 0 1 0 0 4 0 <null> 00:04:35 00:22:35
writes/marks*100 7 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 1 3 0 <null> 00:22:36 00:40:36
writes/marks*100 8 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 <null> 2 0 <null> 00:40:37 00:58:37
writes/marks*100 9 0 0 0 <null> 0 <null> 0 <null> 0 1 0 0 0 0 0 <null> 0 0 <null> 00:58:38 01:16:38
writes/marks*100 10 0 0 0 0 0 0 0 <null> 1 0 0 0 0 0 0 0 <null> 0 <null> 01:16:39 01:34:39
Done for 9940 ms, from 1:41:12.59 to 1:41:22.53.

Performance in DETAILS:

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL JOB_BEG JOB_END
doc_list_aiud 1771438 1624833 146605 8.27 0 10047 35 146605 2017-01-18 22:34 2017-01-19 01:34
doc_list_biud 1771867 1624833 147034 8.29 0 11263 12 147034 2017-01-18 22:34 2017-01-19 01:34
sp_add_invoice_to_stock 17181 10464 6717 39.09 15 319426 10041 6717 2017-01-18 22:34 2017-01-19 01:34
sp_cancel_adding_invoice 4292 3286 1006 23.43 0 51917 1865 1006 2017-01-18 22:34 2017-01-19 01:34
sp_cancel_client_order 6246 6123 123 1.96 0 9157 176 123 2017-01-18 22:34 2017-01-19 01:34
sp_cancel_customer_reserve 334275 196717 137558 41.15 0 4306 47 137558 2017-01-18 22:34 2017-01-19 01:34
sp_cancel_pay_from_customer 2233 2224 9 0.40 0 1685 82 9 2017-01-18 22:34 2017-01-19 01:34
sp_cancel_pay_to_supplier 1365 1360 5 0.36 0 1825 96 5 2017-01-18 22:34 2017-01-19 01:34
sp_cancel_supplier_invoice 9169 6796 2373 25.88 0 8876 418 2373 2017-01-18 22:34 2017-01-19 01:34
sp_cancel_supplier_order 1420 512 908 63.94 32 255653 17569 908 2017-01-18 22:34 2017-01-19 01:34
sp_cancel_write_off 22523 15909 6614 29.36 0 5897 105 6614 2017-01-18 22:34 2017-01-19 01:34
sp_client_order 71822 71822 0 0.00 0 9656 339 0 2017-01-18 22:34 2017-01-19 01:34
sp_customer_reserve 576836 576836 0 0.00 0 9610 153 0 2017-01-18 22:34 2017-01-19 01:34
sp_fill_shopping_cart 108925 108624 301 0.27 0 5772 73 0 2017-01-18 22:34 2017-01-19 01:34
sp_fill_shopping_cart_clo_res 576836 576836 0 0.00 0 3339 11 0 2017-01-18 22:34 2017-01-19 01:34
sp_get_clo_for_invoice 10464 10464 0 0.00 0 7083 240 0 2017-01-18 22:34 2017-01-19 01:34
sp_kill_cost_storno 30062 22779 7283 24.22 0 4009 11 7283 2017-01-18 22:34 2017-01-19 01:34
sp_kill_qstorno_ret_qs2qd 700140 416651 283489 40.49 0 8439 18 283489 2017-01-18 22:34 2017-01-19 01:34
sp_kill_qty_storno 420521 273573 146948 34.94 0 11248 52 146948 2017-01-18 22:34 2017-01-19 01:34
sp_lock_selected_doc 71061 62064 8997 12.66 0 2886 8 8997 2017-01-18 22:34 2017-01-19 01:34
sp_make_cost_storno 87808 87808 0 0.00 0 9360 294 0 2017-01-18 22:34 2017-01-19 01:34
sp_multiply_rows_for_pdistr 87808 87808 0 0.00 0 4587 33 0 2017-01-18 22:34 2017-01-19 01:34
sp_multiply_rows_for_qdistr 71822 71822 0 0.00 0 9453 108 0 2017-01-18 22:34 2017-01-19 01:34
sp_pay_from_customer 23852 23852 0 0.00 0 10748 682 0 2017-01-18 22:34 2017-01-19 01:34
sp_pay_to_supplier 19726 19726 0 0.00 0 5928 284 0 2017-01-18 22:34 2017-01-19 01:34
sp_payment_common 43578 43578 0 0.00 0 2169 41 0 2017-01-18 22:34 2017-01-19 01:34
sp_qd_handle_on_cancel_clo 6244 6123 121 1.93 0 9079 74 121 2017-01-18 22:34 2017-01-19 01:34
sp_qd_handle_on_invoice_upd_sts 14589 13750 839 5.75 0 11232 249 839 2017-01-18 22:34 2017-01-19 01:34
sp_qd_handle_on_reserve_upd_sts 33766 33766 0 0.00 0 8783 30 0 2017-01-18 22:34 2017-01-19 01:34
sp_reserve_write_off 34209 33766 443 1.29 0 9454 409 443 2017-01-18 22:34 2017-01-19 01:34
sp_supplier_invoice 18472 18361 111 0.60 0 32900 2120 0 2017-01-18 22:34 2017-01-19 01:34
sp_supplier_order 18631 18441 190 1.01 0 15787 1423 0 2017-01-18 22:34 2017-01-19 01:34
srv_find_qd_qs_mism 1072220 925622 146598 13.67 0 9391 20 146598 2017-01-18 22:34 2017-01-19 01:34
srv_make_invnt_saldo 2079 2079 0 0.00 0 28033 1972 0 2017-01-18 22:34 2017-01-19 01:34
srv_make_money_saldo 2845 2845 0 0.00 0 3339 38 0 2017-01-18 22:34 2017-01-19 01:34
srv_recalc_idx_stat 12 12 0 0.00 2216 28517 10539 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_add_invoice_to_stock 6717 6717 0 0.00 0 2059 55 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_cancel_adding_invoice 791 791 0 0.00 0 3104 128 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_cancel_client_order 123 123 0 0.00 0 999 60 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_cancel_customer_reserve 22 22 0 0.00 0 266 43 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_cancel_pay_from_customer 9 9 0 0.00 0 811 138 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_cancel_pay_to_supplier 5 5 0 0.00 0 31 12 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_cancel_supplier_invoice 519 519 0 0.00 0 1357 46 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_cancel_supplier_order 16556 16556 0 0.00 0 4306 78 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_cancel_write_off 23 23 0 0.00 0 312 38 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_reserve_write_off 443 443 0 0.00 0 2340 42 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_supplier_invoice 111 111 0 0.00 0 1763 48 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-abend:sp_supplier_order 190 190 0 0.00 0 2215 75 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_add_invoice_to_stock 10464 10464 0 0.00 0 12589 474 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_cancel_adding_invoice 1181 1181 0 0.00 0 7816 476 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_cancel_client_order 6123 6123 0 0.00 0 2559 38 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_cancel_customer_reserve 2249 2249 0 0.00 0 1514 35 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_cancel_pay_from_customer 2224 2224 0 0.00 0 2184 28 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_cancel_pay_to_supplier 1360 1360 0 0.00 0 1872 29 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_cancel_supplier_invoice 893 893 0 0.00 0 1623 38 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_cancel_supplier_order 512 512 0 0.00 0 34086 1467 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_cancel_write_off 3292 3292 0 0.00 0 1950 37 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_client_order 71822 71822 0 0.00 0 5756 43 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_customer_reserve 3319 3319 0 0.00 0 1606 29 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_pay_from_customer 23852 23852 0 0.00 0 2278 34 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_pay_to_supplier 19726 19726 0 0.00 0 2558 31 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_reserve_write_off 33766 33766 0 0.00 0 2808 39 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_supplier_invoice 18361 18361 0 0.00 0 8471 41 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:sp_supplier_order 18441 18441 0 0.00 0 3463 41 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:srv_make_invnt_saldo 2079 2079 0 0.00 0 499 11 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:srv_make_money_saldo 2845 2845 0 0.00 0 1436 19 0 2017-01-18 22:34 2017-01-19 01:34
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 499 104 0 2017-01-18 22:34 2017-01-19 01:34
v_add_invoice_to_stock 34362 20928 13434 39.09 0 3588 38 13434 2017-01-18 22:34 2017-01-19 01:34
v_all_customers 107946 107946 0 0.00 0 920 5 0 2017-01-18 22:34 2017-01-19 01:34
v_all_suppliers 75176 74574 602 0.80 0 3104 6 0 2017-01-18 22:34 2017-01-19 01:34
v_all_wares 143644 143644 0 0.00 0 2933 6 0 2017-01-18 22:34 2017-01-19 01:34
v_cancel_adding_invoice 2818 2362 456 16.18 0 4524 114 456 2017-01-18 22:34 2017-01-19 01:34
v_cancel_client_order 12492 12246 246 1.96 0 1575 6 246 2017-01-18 22:34 2017-01-19 01:34
v_cancel_customer_prepayment 4466 4448 18 0.40 0 452 6 18 2017-01-18 22:34 2017-01-19 01:34
v_cancel_customer_reserve 4542 4498 44 0.96 0 749 7 44 2017-01-18 22:34 2017-01-19 01:34
v_cancel_payment_to_supplier 2730 2720 10 0.36 0 1077 8 10 2017-01-18 22:34 2017-01-19 01:34
v_cancel_supplier_invoice 2824 1786 1038 36.75 0 1263 39 1038 2017-01-18 22:34 2017-01-19 01:34
v_cancel_supplier_order 2840 1024 1816 63.94 0 1046 8 1816 2017-01-18 22:34 2017-01-19 01:34
v_cancel_write_off 6630 6584 46 0.69 0 5570 85 46 2017-01-18 22:34 2017-01-19 01:34
v_max_id_clo_ord 18631 18441 190 1.01 0 3058 7 0 2017-01-18 22:34 2017-01-19 01:34
v_max_id_clo_res 3319 3319 0 0.00 0 1155 18 0 2017-01-18 22:34 2017-01-19 01:34
v_max_id_ord_sup 18472 18361 111 0.60 0 1186 6 0 2017-01-18 22:34 2017-01-19 01:34
v_max_non_paid_invoice 19241 19241 0 0.00 0 671 5 0 2017-01-18 22:34 2017-01-19 01:34
v_max_non_paid_realizn 23852 23852 0 0.00 0 717 5 0 2017-01-18 22:34 2017-01-19 01:34
v_min_id_clo_ord 18631 18441 190 1.01 0 1872 8 0 2017-01-18 22:34 2017-01-19 01:34
v_min_id_clo_res 3319 3319 0 0.00 0 609 8 0 2017-01-18 22:34 2017-01-19 01:34
v_min_id_ord_sup 18472 18361 111 0.60 0 1233 8 0 2017-01-18 22:34 2017-01-19 01:34
v_min_non_paid_invoice 19726 19726 0 0.00 0 733 6 0 2017-01-18 22:34 2017-01-19 01:34
v_min_non_paid_realizn 23852 23852 0 0.00 0 702 5 0 2017-01-18 22:34 2017-01-19 01:34
v_our_firm 35698 35698 0 0.00 0 1092 6 0 2017-01-18 22:34 2017-01-19 01:34
v_reserve_write_off 68418 67532 886 1.29 0 1981 6 886 2017-01-18 22:34 2017-01-19 01:34
x_lock_depdocs_on_canc_invoice 17709 9189 8520 48.11 0 3853 24 8520 2017-01-18 22:34 2017-01-19 01:34
x_lock_depdocs_on_canc_sup_ord 1420 512 908 63.94 0 1170 35 908 2017-01-18 22:34 2017-01-19 01:34
x_make_qstorno_1000_1200 18631 18441 190 1.01 0 14337 1266 0 2017-01-18 22:34 2017-01-19 01:34
x_make_qstorno_1200_2000 18472 18361 111 0.60 0 31449 1959 0 2017-01-18 22:34 2017-01-19 01:34
x_make_qstorno_2100_3300 576836 576836 0 0.00 0 9453 130 0 2017-01-18 22:34 2017-01-19 01:34
Done for 298830 ms, from 1:43:54.63 to 1:48:53.46.

Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.

Exceptions occured during test work:

FB_MNEMONA CNT UNIT FB_GDSCODE DTS_BEG DTS_END
deadlock 74 sp_kill_cost_storno 335544336 2017-01-18 22:35 2017-01-19 01:34
deadlock 88 sp_kill_qstorno_ret_qs2qd 335544336 2017-01-18 22:41 2017-01-19 01:31
deadlock 2136 sp_lock_selected_doc 335544336 2017-01-18 22:34 2017-01-19 01:34
deadlock 121 sp_qd_handle_on_cancel_clo 335544336 2017-01-18 22:34 2017-01-19 01:33
deadlock 173 sp_qd_handle_on_invoice_upd_sts 335544336 2017-01-18 22:35 2017-01-19 01:31
deadlock 47 x_lock_depdocs_on_canc_invoice 335544336 2017-01-18 22:38 2017-01-19 01:32
deadlock 15 x_lock_depdocs_on_canc_sup_ord 335544336 2017-01-18 23:05 2017-01-19 01:25
user_exc 190 x_make_qstorno_1000_1200 335544517 2017-01-18 22:40 2017-01-19 01:30
user_exc 111 x_make_qstorno_1200_2000 335544517 2017-01-18 22:35 2017-01-19 01:34
concurrent_transaction 5605 sp_lock_selected_doc 335544878 2017-01-18 22:34 2017-01-19 01:34
concurrent_transaction 535 x_lock_depdocs_on_canc_invoice 335544878 2017-01-18 22:34 2017-01-19 01:34
concurrent_transaction 193 x_lock_depdocs_on_canc_sup_ord 335544878 2017-01-18 22:36 2017-01-19 01:33
Done for 9810 ms, from 1:49:01.48 to 1:49:11.29.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 400289
MON$OLDEST_ACTIVE 400290
MON$OLDEST_SNAPSHOT 400290
MON$NEXT_TRANSACTION 400290
MON$PAGE_BUFFERS 786432
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 2017-01-11 15:15:54.2050
MON$PAGES 787104
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.503 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.503 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.503 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P14"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.503 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P14"
on disk structure version 13.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 400342
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 400291
Oldest active 400292
Oldest snapshot 400292
Next transaction 400293
Sequence number 0
Next attachment ID 9245
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, 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.27
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: 325, 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: 327, 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: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, 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: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
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: 323, 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 (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
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: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
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: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.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 BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
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: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
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 (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 46.99, total records: 1991158
Average version length: 47.75, total versions: 2695, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 14, data page slots: 21480
Data pages: 21480, average fill: 73%
Primary pages: 21480, secondary pages: 0, swept pages: 12319
Empty pages: 4, full pages: 19299
Fill distribution:
0 - 19% = 4
20 - 39% = 8
40 - 59% = 58
60 - 79% = 21405
80 - 99% = 5

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 9840, nodes: 1991158
Average node length: 19.24, total dup: 0, max dup: 0
Average key length: 16.29, compression ratio: 1.66
Average prefix length: 13.71, average data length: 13.29
Clustering factor: 357329, ratio: 0.18
Fill distribution:
0 - 19% = 798
20 - 39% = 2499
40 - 59% = 4069
60 - 79% = 1060
80 - 99% = 1414

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7177, nodes: 1991158
Average node length: 11.65, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 338411, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 3489
40 - 59% = 3579
60 - 79% = 102
80 - 99% = 6

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 174612, depth: 3, leaf buckets: 3393, nodes: 1991158
Average node length: 6.78, total dup: 1462196, max dup: 49
Average key length: 3.83, compression ratio: 2.35
Average prefix length: 7.43, average data length: 1.57
Clustering factor: 324179, ratio: 0.16
Fill distribution:
0 - 19% = 124
20 - 39% = 1173
40 - 59% = 1212
60 - 79% = 358
80 - 99% = 526

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.24, total records: 588650
Average version length: 61.22, total versions: 628, max versions: 2
Average fragment length: 32.50, total fragments: 2, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7440
Data pages: 7440, average fill: 75%
Primary pages: 7438, secondary pages: 2, swept pages: 6720
Empty pages: 2, full pages: 6969
Fill distribution:
0 - 19% = 5
20 - 39% = 9
40 - 59% = 31
60 - 79% = 7379
80 - 99% = 16

Index DOC_LIST_ID_DESC (1)
Root page: 244680, depth: 3, leaf buckets: 2210, nodes: 588650
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.15, average data length: 5.85
Clustering factor: 133732, ratio: 0.23
Fill distribution:
0 - 19% = 1
20 - 39% = 1275
40 - 59% = 893
60 - 79% = 36
80 - 99% = 5

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 614, nodes: 588650
Average node length: 4.86, total dup: 588600, max dup: 30291
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 266271, ratio: 0.45
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 519
60 - 79% = 75
80 - 99% = 19

Index PK_DOC_LIST (0)
Root page: 337698, depth: 3, leaf buckets: 1645, nodes: 588650
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 133732, ratio: 0.23
Fill distribution:
0 - 19% = 94
20 - 39% = 449
40 - 59% = 522
60 - 79% = 302
80 - 99% = 278

DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
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: 321, 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: 322, 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: 320, 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 (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
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: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 64.84, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 17.41, total fragments: 370, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.60
Pointer pages: 1, data page slots: 464
Data pages: 20, average fill: 31%
Primary pages: 7, secondary pages: 13, swept pages: 4
Empty pages: 8, full pages: 3
Fill distribution:
0 - 19% = 9
20 - 39% = 5
40 - 59% = 2
60 - 79% = 1
80 - 99% = 3

Index PK_INVNT_SALDO (0)
Root page: 285, 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: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 65.24, total records: 2327
Average version length: 71.19, total versions: 195, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.47
Pointer pages: 2, data page slots: 344
Data pages: 192, average fill: 15%
Primary pages: 192, secondary pages: 0, swept pages: 168
Empty pages: 41, full pages: 3
Fill distribution:
0 - 19% = 147
20 - 39% = 27
40 - 59% = 14
60 - 79% = 2
80 - 99% = 2

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 11, nodes: 2327
Average node length: 16.17, total dup: 64, max dup: 1
Average key length: 14.19, compression ratio: 1.90
Average prefix length: 15.78, average data length: 11.22
Clustering factor: 1968, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 4
60 - 79% = 1
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.06, total records: 49
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: 32.00, compression ratio: 2.12
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MONEY_SALDO (0)
Root page: 276, 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 (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 45.97, total records: 31
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: 64.00, compression ratio: 1.39
Pointer pages: 1, data page slots: 40
Data pages: 32, average fill: 3%
Primary pages: 31, secondary pages: 1, swept pages: 18
Empty pages: 23, full pages: 0
Fill distribution:
0 - 19% = 32
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 360163, depth: 2, leaf buckets: 1, nodes: 31
Average node length: 13.19, total dup: 13, max dup: 4
Average key length: 11.48, compression ratio: 1.65
Average prefix length: 10.06, average data length: 8.94
Clustering factor: 24, ratio: 0.77
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (165)
Primary pointer page: 356, Index root page: 357
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 MON_LOG_DTS (4)
Root page: 367, 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: 365, 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: 364, 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: 366, 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: 363, 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 (166)
Primary pointer page: 369, Index root page: 370
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 MON_LOG_TABLE_STATS_DTS (4)
Root page: 376, 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_TABLE_STATS_GDSCODE (2)
Root page: 374, 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_TABLE_STATS_ROWSET (1)
Root page: 373, 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_TABLE_STATS_TN_UNIT (3)
Root page: 375, 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_TABLE_STATS (0)
Root page: 372, 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

OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, 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: 376.00, compression ratio: 5.54
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: 244, 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: 243, 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 (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 18.77, total records: 683570
Average version length: 42.85, total versions: 621, max versions: 5
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.41
Pointer pages: 3, data page slots: 4176
Data pages: 4176, average fill: 72%
Primary pages: 4172, secondary pages: 4, swept pages: 3612
Empty pages: 11, full pages: 3220
Fill distribution:
0 - 19% = 28
20 - 39% = 82
40 - 59% = 127
60 - 79% = 3595
80 - 99% = 344

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 214, nodes: 199634
Average node length: 4.86, total dup: 199585, max dup: 12465
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 27367, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 28
40 - 59% = 110
60 - 79% = 65
80 - 99% = 10

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 242, nodes: 199634
Average node length: 5.80, total dup: 180083, max dup: 69
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 30727, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 40
40 - 59% = 90
60 - 79% = 69
80 - 99% = 43

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 245, nodes: 199634
Average node length: 5.80, total dup: 180083, max dup: 69
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 30797, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 42
40 - 59% = 92
60 - 79% = 74
80 - 99% = 37

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 248, nodes: 199634
Average node length: 5.59, total dup: 180083, max dup: 69
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 30790, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 41
40 - 59% = 119
60 - 79% = 63
80 - 99% = 25

PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.96, total records: 239001
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: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2048
Data pages: 2048, average fill: 64%
Primary pages: 2048, secondary pages: 0, swept pages: 0
Empty pages: 6, full pages: 2041
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 1
60 - 79% = 2041
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 363580, depth: 2, leaf buckets: 184, nodes: 239001
Average node length: 4.46, total dup: 238820, max dup: 1937
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 37180, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 46
60 - 79% = 85
80 - 99% = 53

PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
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: 349, 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 (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.50, total records: 10988610
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: 1696.00, compression ratio: 11.19
Pointer pages: 160, data page slots: 260416
Data pages: 260416, average fill: 87%
Primary pages: 260416, secondary pages: 0, swept pages: 3
Empty pages: 3, full pages: 260412
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 260413

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 12667, nodes: 10988610
Average node length: 5.65, total dup: 10109190, max dup: 131
Average key length: 2.20, compression ratio: 3.64
Average prefix length: 7.85, average data length: 0.14
Clustering factor: 3402903, ratio: 0.31
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 7759
60 - 79% = 3216
80 - 99% = 1683

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 10830, nodes: 10988610
Average node length: 4.55, total dup: 10988605, max dup: 9915363
Average key length: 1.10, compression ratio: 0.44
Average prefix length: 0.49, average data length: 0.00
Clustering factor: 318649, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 10806
60 - 79% = 2
80 - 99% = 21

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 13439, nodes: 10988610
Average node length: 5.68, total dup: 10653947, max dup: 21433
Average key length: 2.23, compression ratio: 4.04
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 740205, ratio: 0.07
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 10302
60 - 79% = 1697
80 - 99% = 1437

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 13236, nodes: 10988610
Average node length: 5.53, total dup: 10962806, max dup: 1516212
Average key length: 2.07, compression ratio: 18.29
Average prefix length: 37.79, average data length: 0.07
Clustering factor: 5781591, ratio: 0.53
Fill distribution:
0 - 19% = 7
20 - 39% = 2
40 - 59% = 11419
60 - 79% = 474
80 - 99% = 1334

PHRASES (145)
Primary pointer page: 269, Index root page: 270
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: 283, 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: 282, 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: 281, 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: 280, 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 (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.01, total records: 415677
Average version length: 55.74, total versions: 739, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 4936
Data pages: 4936, average fill: 74%
Primary pages: 4936, secondary pages: 0, swept pages: 3130
Empty pages: 6, full pages: 4635
Fill distribution:
0 - 19% = 9
20 - 39% = 2
40 - 59% = 15
60 - 79% = 4909
80 - 99% = 1

Index PSTORNED_RCV_ID (2)
Root page: 746588, depth: 3, leaf buckets: 527, nodes: 415677
Average node length: 5.84, total dup: 355011, max dup: 653
Average key length: 3.07, compression ratio: 2.93
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 50360, ratio: 0.12
Fill distribution:
0 - 19% = 9
20 - 39% = 38
40 - 59% = 285
60 - 79% = 134
80 - 99% = 61

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 460, nodes: 415677
Average node length: 5.61, total dup: 368760, max dup: 121
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.27, average data length: 0.73
Clustering factor: 98191, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 225
60 - 79% = 170
80 - 99% = 58

RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.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: 336.00, compression ratio: 18.67
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: 310, 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 (139)
Primary pointer page: 245, Index root page: 246
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: 248, 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: 247, 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 (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, 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: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
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: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
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.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 236, Index root page: 237
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$AUTOGEN$SOURCE (135)
Primary pointer page: 234, Index root page: 235
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$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
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: 218, 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: 226, Index root page: 227
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_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 229, 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: 230, Index root page: 231
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: 232, Index root page: 233
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 (164)
Primary pointer page: 354, Index root page: 355
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: 362, 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: 224, Index root page: 225
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: 219, Index root page: 220
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: 222, 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: 221, 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: 211, Index root page: 212
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: 215, 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 (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.59, total records: 2695
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: 376.00, compression ratio: 6.53
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 62%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 32
80 - 99% = 0

WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, 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: 448.00, compression ratio: 5.77
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% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, 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: 277, 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: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 279, 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: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, 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: 352.00, compression ratio: 10.96
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: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
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: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 48.46, total records: 6694
Average version length: 72.10, total versions: 2202, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.81
Pointer pages: 2, data page slots: 1312
Data pages: 408, average fill: 20%
Primary pages: 406, secondary pages: 2, swept pages: 327
Empty pages: 227, full pages: 70
Fill distribution:
0 - 19% = 299
20 - 39% = 21
40 - 59% = 10
60 - 79% = 52
80 - 99% = 26

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 16, nodes: 6694
Average node length: 6.68, total dup: 5774, max dup: 14
Average key length: 4.67, compression ratio: 7.93
Average prefix length: 34.47, average data length: 2.53
Clustering factor: 1064, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 6
60 - 79% = 0
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.97, total records: 949686
Average version length: 71.86, total versions: 2713, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 9, data page slots: 14272
Data pages: 14272, average fill: 73%
Primary pages: 14272, secondary pages: 0, swept pages: 9003
Empty pages: 27, full pages: 11092
Fill distribution:
0 - 19% = 104
20 - 39% = 195
40 - 59% = 772
60 - 79% = 13175
80 - 99% = 26

Index XQD_1000_3300_DOC (1)
Root page: 502130, depth: 3, leaf buckets: 1038, nodes: 949686
Average node length: 5.11, total dup: 924847, max dup: 126
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 100148, ratio: 0.11
Fill distribution:
0 - 19% = 19
20 - 39% = 54
40 - 59% = 720
60 - 79% = 42
80 - 99% = 203

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 313726, depth: 3, leaf buckets: 1372, nodes: 949686
Average node length: 6.24, total dup: 829566, max dup: 14
Average key length: 3.32, compression ratio: 11.15
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 179752, ratio: 0.19
Fill distribution:
0 - 19% = 12
20 - 39% = 157
40 - 59% = 948
60 - 79% = 155
80 - 99% = 100

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 21.08, total records: 91806
Average version length: 71.98, total versions: 2257, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 6.45
Pointer pages: 3, data page slots: 3944
Data pages: 3312, average fill: 15%
Primary pages: 3311, secondary pages: 1, swept pages: 2131
Empty pages: 895, full pages: 142
Fill distribution:
0 - 19% = 2456
20 - 39% = 410
40 - 59% = 208
60 - 79% = 198
80 - 99% = 40

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 45, nodes: 20195
Average node length: 6.32, total dup: 17497, max dup: 45
Average key length: 3.90, compression ratio: 9.48
Average prefix length: 35.23, average data length: 1.77
Clustering factor: 2248, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 31
40 - 59% = 12
60 - 79% = 2
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 50.79, total records: 2199071
Average version length: 71.56, total versions: 41176, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.68
Pointer pages: 18, data page slots: 29240
Data pages: 29232, average fill: 64%
Primary pages: 29232, secondary pages: 0, swept pages: 13530
Empty pages: 360, full pages: 23421
Fill distribution:
0 - 19% = 748
20 - 39% = 4814
40 - 59% = 2778
60 - 79% = 18123
80 - 99% = 2769

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 178540, depth: 3, leaf buckets: 2352, nodes: 1501776
Average node length: 5.63, total dup: 1411480, max dup: 63
Average key length: 2.66, compression ratio: 13.91
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 165902, ratio: 0.11
Fill distribution:
0 - 19% = 16
20 - 39% = 1008
40 - 59% = 999
60 - 79% = 167
80 - 99% = 162

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.01, total records: 3533528
Average version length: 70.94, total versions: 266, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.09
Pointer pages: 14, data page slots: 21896
Data pages: 21872, average fill: 52%
Primary pages: 21871, secondary pages: 1, swept pages: 8291
Empty pages: 21, full pages: 21000
Fill distribution:
0 - 19% = 179
20 - 39% = 6658
40 - 59% = 5393
60 - 79% = 9545
80 - 99% = 97

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 5, nodes: 1065
Average node length: 12.18, total dup: 727, max dup: 14
Average key length: 9.18, compression ratio: 4.03
Average prefix length: 30.14, average data length: 6.86
Clustering factor: 258, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 61.58, total records: 3043660
Average version length: 71.31, total versions: 14186, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.21
Pointer pages: 24, data page slots: 39104
Data pages: 39104, average fill: 75%
Primary pages: 39104, secondary pages: 0, swept pages: 27668
Empty pages: 24, full pages: 35024
Fill distribution:
0 - 19% = 59
20 - 39% = 329
40 - 59% = 1164
60 - 79% = 35022
80 - 99% = 2530

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5427, nodes: 2581799
Average node length: 6.87, total dup: 2092666, max dup: 14
Average key length: 3.90, compression ratio: 9.49
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 456840, ratio: 0.18
Fill distribution:
0 - 19% = 9
20 - 39% = 3121
40 - 59% = 1878
60 - 79% = 249
80 - 99% = 170

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.44, total records: 4296056
Average version length: 84.31, total versions: 1355, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 41, data page slots: 65936
Data pages: 65936, average fill: 80%
Primary pages: 65936, secondary pages: 0, swept pages: 23416
Empty pages: 7, full pages: 65624
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 16
60 - 79% = 19257
80 - 99% = 46650

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4497, nodes: 4296056
Average node length: 5.15, total dup: 4198528, max dup: 130
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 652699, ratio: 0.15
Fill distribution:
0 - 19% = 13
20 - 39% = 118
40 - 59% = 2190
60 - 79% = 1750
80 - 99% = 426

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 4358, nodes: 4296056
Average node length: 5.71, total dup: 3833743, max dup: 49
Average key length: 2.73, compression ratio: 3.30
Average prefix length: 8.38, average data length: 0.62
Clustering factor: 171159, ratio: 0.04
Fill distribution:
0 - 19% = 27
20 - 39% = 102
40 - 59% = 2021
60 - 79% = 275
80 - 99% = 1933

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5021, nodes: 4296056
Average node length: 5.81, total dup: 3759228, max dup: 29
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 707997, ratio: 0.16
Fill distribution:
0 - 19% = 30
20 - 39% = 123
40 - 59% = 2415
60 - 79% = 1810
80 - 99% = 643

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 82.82, total records: 2282017
Average version length: 83.71, total versions: 7861, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 22, data page slots: 35560
Data pages: 35560, average fill: 79%
Primary pages: 35560, secondary pages: 0, swept pages: 24709
Empty pages: 13, full pages: 34260
Fill distribution:
0 - 19% = 35
20 - 39% = 44
40 - 59% = 238
60 - 79% = 14845
80 - 99% = 20398

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2445, nodes: 2282017
Average node length: 5.15, total dup: 2228744, max dup: 180
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 360270, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 49
40 - 59% = 1444
60 - 79% = 706
80 - 99% = 245

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 3779, nodes: 2282017
Average node length: 6.24, total dup: 1865240, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 209747, ratio: 0.09
Fill distribution:
0 - 19% = 105
20 - 39% = 1407
40 - 59% = 1463
60 - 79% = 512
80 - 99% = 292

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 2778, nodes: 2282017
Average node length: 5.81, total dup: 1995968, max dup: 29
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 437420, ratio: 0.19
Fill distribution:
0 - 19% = 13
20 - 39% = 47
40 - 59% = 1699
60 - 79% = 743
80 - 99% = 276

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.43, total records: 4551081
Average version length: 85.20, total versions: 10725, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 44, data page slots: 71032
Data pages: 70992, average fill: 79%
Primary pages: 70992, secondary pages: 0, swept pages: 19648
Empty pages: 377, full pages: 67279
Fill distribution:
0 - 19% = 525
20 - 39% = 416
40 - 59% = 1091
60 - 79% = 13459
80 - 99% = 55501

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 4751, nodes: 4551081
Average node length: 5.04, total dup: 4524366, max dup: 706
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 640070, ratio: 0.14
Fill distribution:
0 - 19% = 5
20 - 39% = 214
40 - 59% = 2587
60 - 79% = 1453
80 - 99% = 492

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5332, nodes: 4551081
Average node length: 5.54, total dup: 4179153, max dup: 49
Average key length: 2.56, compression ratio: 3.52
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 192084, ratio: 0.04
Fill distribution:
0 - 19% = 106
20 - 39% = 1128
40 - 59% = 2198
60 - 79% = 564
80 - 99% = 1336

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5368, nodes: 4551081
Average node length: 5.70, total dup: 4068654, max dup: 73
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 720518, ratio: 0.16
Fill distribution:
0 - 19% = 5
20 - 39% = 189
40 - 59% = 2930
60 - 79% = 1669
80 - 99% = 575

XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
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 (0)
Root page: 823, 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 (2)
Root page: 825, 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 (1)
Root page: 824, 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 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.12, total records: 3088706
Average version length: 83.96, total versions: 9749, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 30, data page slots: 48336
Data pages: 48336, average fill: 79%
Primary pages: 48336, secondary pages: 0, swept pages: 33370
Empty pages: 9, full pages: 45516
Fill distribution:
0 - 19% = 25
20 - 39% = 112
40 - 59% = 500
60 - 79% = 18783
80 - 99% = 28916

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3368, nodes: 3088706
Average node length: 5.02, total dup: 3073188, max dup: 1200
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 645961, ratio: 0.21
Fill distribution:
0 - 19% = 9
20 - 39% = 316
40 - 59% = 1904
60 - 79% = 782
80 - 99% = 357

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 5167, nodes: 3088706
Average node length: 6.25, total dup: 2523570, max dup: 14
Average key length: 3.28, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 312919, ratio: 0.10
Fill distribution:
0 - 19% = 165
20 - 39% = 1963
40 - 59% = 1963
60 - 79% = 676
80 - 99% = 400

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 3703, nodes: 3088706
Average node length: 5.62, total dup: 2803879, max dup: 97
Average key length: 2.64, compression ratio: 3.41
Average prefix length: 8.45, average data length: 0.55
Clustering factor: 685973, ratio: 0.22
Fill distribution:
0 - 19% = 11
20 - 39% = 311
40 - 59% = 2004
60 - 79% = 951
80 - 99% = 426

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.37, total records: 512230
Average version length: 69.73, total versions: 886, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 5, data page slots: 7088
Data pages: 7088, average fill: 77%
Primary pages: 7088, secondary pages: 0, swept pages: 4995
Empty pages: 4, full pages: 6713
Fill distribution:
0 - 19% = 12
20 - 39% = 32
40 - 59% = 74
60 - 79% = 6947
80 - 99% = 23

Index XQS_3300_3400_DOC_ID (0)
Root page: 255197, depth: 3, leaf buckets: 634, nodes: 512230
Average node length: 5.34, total dup: 478891, max dup: 112
Average key length: 2.50, compression ratio: 3.61
Average prefix length: 8.57, average data length: 0.43
Clustering factor: 48315, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 162
40 - 59% = 254
60 - 79% = 164
80 - 99% = 53

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 700, nodes: 512230
Average node length: 5.93, total dup: 435113, max dup: 15
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 50489, ratio: 0.10
Fill distribution:
0 - 19% = 3
20 - 39% = 160
40 - 59% = 299
60 - 79% = 165
80 - 99% = 73

ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
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 (229)
Primary pointer page: 672, Index root page: 673
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 (231)
Primary pointer page: 676, Index root page: 677
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 (234)
Primary pointer page: 682, Index root page: 683
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: 692, 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 (235)
Primary pointer page: 684, Index root page: 685
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: 693, 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 (232)
Primary pointer page: 678, Index root page: 679
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: 686, 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: 687, 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 (233)
Primary pointer page: 680, Index root page: 681
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: 689, 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: 688, 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: 691, 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: 690, 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 (228)
Primary pointer page: 622, Index root page: 623
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 (227)
Primary pointer page: 620, Index root page: 621
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 (146)
Primary pointer page: 271, Index root page: 272
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: 284, 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

Done for 120920 ms, from 1:49:11.71 to 1:51:12.63.

Analyzing DB stat log: obtaining values of total records and versions

TABLE_NAME TOTAL_RECS TOTAL_VERS VERS_PERCENT
AGENTS 50 0 0.0000
BUSINESS_OPS 19 0 0.0000
DOC_DATA 1991158 2695 0.1353
DOC_LIST 588650 628 0.1066
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 2327 195 8.3798
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 31 0 0.0000
OPTYPES 9 0 0.0000
PDISTR 683570 621 0.0908
PERF_ESTIMATED 239001 0 0.0000
PERF_LOG 10988610 0 0.0000
PSTORNED 415677 739 0.1777
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 0 0.0000
SETTINGS 114 0 0.0000
TRACE_STAT 2695 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 6694 2202 32.8951
XQD_1000_3300 949686 2713 0.2856
XQD_1200_2000 91806 2257 2.4584
XQD_2000_3300 2199071 41176 1.8724
XQD_2100_3300 3533528 266 0.0075
XQD_3300_3400 3043660 14186 0.4660
XQS_1000_1200 4296056 1355 0.0315
XQS_1000_3300 2282017 7861 0.3444
XQS_1200_2000 4551081 10725 0.2356
XQS_2100_3300 3088706 9749 0.3156
XQS_3300_3400 512230 886 0.1729
Z_USED_VIEWS 29 0 0.0000
Done for 2310 ms, from 1:51:25.70 to 1:51:28.01.

Database validation

01:51:28.18 Validation started

01:51:28.20 Relation 140 (DOC_LIST)
01:51:28.20 process pointer page 0 of 5
01:51:28.29 process pointer page 1 of 5
01:51:28.40 process pointer page 2 of 5
01:51:28.49 process pointer page 3 of 5
01:51:28.60 process pointer page 4 of 5
01:51:28.65 Index 1 (PK_DOC_LIST)
01:51:28.88 Index 2 (DOC_LIST_ID_DESC)
01:51:29.13 Index 3 (FK_DOC_LIST_AGENTS)
01:51:29.27 Relation 140 (DOC_LIST) is ok

01:51:29.27 Relation 141 (DOC_DATA)
01:51:29.27 process pointer page 0 of 14
01:51:29.31 process pointer page 1 of 14
01:51:29.35 process pointer page 2 of 14
01:51:29.38 process pointer page 3 of 14
01:51:29.45 process pointer page 4 of 14
01:51:29.54 process pointer page 5 of 14
01:51:29.63 process pointer page 6 of 14
01:51:29.73 process pointer page 7 of 14
01:51:29.82 process pointer page 8 of 14
01:51:29.91 process pointer page 9 of 14
01:51:30.01 process pointer page 10 of 14
01:51:30.10 process pointer page 11 of 14
01:51:30.19 process pointer page 12 of 14
01:51:30.27 process pointer page 13 of 14
01:51:30.29 Index 2 (DOC_DATA_DOC_WARE_UNQ)
01:51:31.27 Index 3 (DOC_DATA_ID_DESC)
01:51:32.10 Index 4 (FK_DOC_DATA_DOC_LIST)
01:51:32.53 Relation 141 (DOC_DATA) is ok

01:51:32.53 Relation 147 (INVNT_SALDO)
01:51:32.53 process pointer page 0 of 1
01:51:32.53 Index 1 (PK_INVNT_SALDO)
01:51:32.53 Relation 147 (INVNT_SALDO) is ok

01:51:32.53 Relation 150 (PDISTR)
01:51:32.53 process pointer page 0 of 3
01:51:32.57 process pointer page 1 of 3
01:51:32.60 process pointer page 2 of 3
01:51:32.61 Index 2 (PDISTR_SND_ID)
01:51:32.63 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
01:51:32.68 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
01:51:32.72 Index 5 (PDISTR_AGENT_ID)
01:51:32.75 Relation 150 (PDISTR) is ok

01:51:32.75 Relation 151 (PSTORNED)
01:51:32.75 process pointer page 0 of 4
01:51:32.78 process pointer page 1 of 4
01:51:32.83 process pointer page 2 of 4
01:51:32.86 process pointer page 3 of 4
01:51:32.86 Index 2 (PSTORNED_SND_ID)
01:51:32.91 Index 3 (PSTORNED_RCV_ID)
01:51:32.96 Relation 151 (PSTORNED) is ok

01:51:32.96 Relation 156 (SEMAPHORES)
01:51:32.96 process pointer page 0 of 1
01:51:32.96 Index 1 (PK_SEMAPHORES)
01:51:32.96 Index 2 (SEMAPHORES_TASK_UNQ)
01:51:32.96 Relation 156 (SEMAPHORES) is ok

01:51:32.96 Relation 157 (INVNT_TURNOVER_LOG)
01:51:32.96 process pointer page 0 of 2
01:51:32.96 process pointer page 1 of 2
01:51:32.96 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
01:51:32.96 Relation 157 (INVNT_TURNOVER_LOG) is ok

01:51:32.96 Relation 160 (PERF_ESTIMATED)
01:51:32.96 process pointer page 0 of 2
01:51:32.99 process pointer page 1 of 2
01:51:32.99 Index 1 (PERF_EST_MINUTE_SINCE_START)
01:51:33.02 Relation 160 (PERF_ESTIMATED) is ok

01:51:33.02 Relation 161 (PERF_ISQL_STAT)
01:51:33.02 process pointer page 0 of 1
01:51:33.02 Index 1 (PERF_ISQL_STAT_TRN)
01:51:33.02 Relation 161 (PERF_ISQL_STAT) is ok

01:51:33.02 Relation 162 (TRACE_STAT)
01:51:33.02 process pointer page 0 of 1
01:51:33.02 Relation 162 (TRACE_STAT) is ok

01:51:33.02 Relation 163 (PERF_LOG)
01:51:33.02 process pointer page 0 of 160
01:51:33.07 process pointer page 1 of 160
01:51:33.14 process pointer page 2 of 160
01:51:33.22 process pointer page 3 of 160
01:51:33.30 process pointer page 4 of 160
01:51:33.39 process pointer page 5 of 160
01:51:33.47 process pointer page 6 of 160
01:51:33.55 process pointer page 7 of 160
01:51:33.64 process pointer page 8 of 160
01:51:33.72 process pointer page 9 of 160
01:51:33.80 process pointer page 10 of 160
01:51:33.89 process pointer page 11 of 160
01:51:33.97 process pointer page 12 of 160
01:51:34.05 process pointer page 13 of 160
01:51:34.14 process pointer page 14 of 160
01:51:34.22 process pointer page 15 of 160
01:51:34.30 process pointer page 16 of 160
01:51:34.39 process pointer page 17 of 160
01:51:34.47 process pointer page 18 of 160
01:51:34.55 process pointer page 19 of 160
01:51:34.64 process pointer page 20 of 160
01:51:34.72 process pointer page 21 of 160
01:51:34.80 process pointer page 22 of 160
01:51:34.87 process pointer page 23 of 160
01:51:34.97 process pointer page 24 of 160
01:51:35.05 process pointer page 25 of 160
01:51:35.12 process pointer page 26 of 160
01:51:35.20 process pointer page 27 of 160
01:51:35.28 process pointer page 28 of 160
01:51:35.36 process pointer page 29 of 160
01:51:35.45 process pointer page 30 of 160
01:51:35.53 process pointer page 31 of 160
01:51:35.61 process pointer page 32 of 160
01:51:35.69 process pointer page 33 of 160
01:51:35.76 process pointer page 34 of 160
01:51:35.84 process pointer page 35 of 160
01:51:35.92 process pointer page 36 of 160
01:51:36.00 process pointer page 37 of 160
01:51:36.09 process pointer page 38 of 160
01:51:36.17 process pointer page 39 of 160
01:51:36.25 process pointer page 40 of 160
01:51:36.33 process pointer page 41 of 160
01:51:36.40 process pointer page 42 of 160
01:51:36.48 process pointer page 43 of 160
01:51:36.58 process pointer page 44 of 160
01:51:36.65 process pointer page 45 of 160
01:51:36.73 process pointer page 46 of 160
01:51:36.81 process pointer page 47 of 160
01:51:36.89 process pointer page 48 of 160
01:51:36.92 process pointer page 49 of 160
01:51:36.98 process pointer page 50 of 160
01:51:37.06 process pointer page 51 of 160
01:51:37.14 process pointer page 52 of 160
01:51:37.23 process pointer page 53 of 160
01:51:37.31 process pointer page 54 of 160
01:51:37.39 process pointer page 55 of 160
01:51:37.46 process pointer page 56 of 160
01:51:37.54 process pointer page 57 of 160
01:51:37.64 process pointer page 58 of 160
01:51:37.71 process pointer page 59 of 160
01:51:37.79 process pointer page 60 of 160
01:51:37.87 process pointer page 61 of 160
01:51:37.96 process pointer page 62 of 160
01:51:38.04 process pointer page 63 of 160
01:51:38.10 process pointer page 64 of 160
01:51:38.14 process pointer page 65 of 160
01:51:38.17 process pointer page 66 of 160
01:51:38.20 process pointer page 67 of 160
01:51:38.29 process pointer page 68 of 160
01:51:38.32 process pointer page 69 of 160
01:51:38.35 process pointer page 70 of 160
01:51:38.38 process pointer page 71 of 160
01:51:38.42 process pointer page 72 of 160
01:51:38.46 process pointer page 73 of 160
01:51:38.48 process pointer page 74 of 160
01:51:38.54 process pointer page 75 of 160
01:51:38.57 process pointer page 76 of 160
01:51:38.60 process pointer page 77 of 160
01:51:38.63 process pointer page 78 of 160
01:51:38.67 process pointer page 79 of 160
01:51:38.70 process pointer page 80 of 160
01:51:38.79 process pointer page 81 of 160
01:51:38.87 process pointer page 82 of 160
01:51:38.95 process pointer page 83 of 160
01:51:39.02 process pointer page 84 of 160
01:51:39.10 process pointer page 85 of 160
01:51:39.18 process pointer page 86 of 160
01:51:39.27 process pointer page 87 of 160
01:51:39.35 process pointer page 88 of 160
01:51:39.43 process pointer page 89 of 160
01:51:39.52 process pointer page 90 of 160
01:51:39.60 process pointer page 91 of 160
01:51:39.68 process pointer page 92 of 160
01:51:39.76 process pointer page 93 of 160
01:51:39.85 process pointer page 94 of 160
01:51:39.93 process pointer page 95 of 160
01:51:40.01 process pointer page 96 of 160
01:51:40.09 process pointer page 97 of 160
01:51:40.16 process pointer page 98 of 160
01:51:40.26 process pointer page 99 of 160
01:51:40.33 process pointer page 100 of 160
01:51:40.41 process pointer page 101 of 160
01:51:40.49 process pointer page 102 of 160
01:51:40.57 process pointer page 103 of 160
01:51:40.66 process pointer page 104 of 160
01:51:40.74 process pointer page 105 of 160
01:51:40.82 process pointer page 106 of 160
01:51:40.90 process pointer page 107 of 160
01:51:40.97 process pointer page 108 of 160
01:51:41.07 process pointer page 109 of 160
01:51:41.15 process pointer page 110 of 160
01:51:41.22 process pointer page 111 of 160
01:51:41.32 process pointer page 112 of 160
01:51:41.40 process pointer page 113 of 160
01:51:41.47 process pointer page 114 of 160
01:51:41.55 process pointer page 115 of 160
01:51:41.63 process pointer page 116 of 160
01:51:41.72 process pointer page 117 of 160
01:51:41.80 process pointer page 118 of 160
01:51:41.88 process pointer page 119 of 160
01:51:41.97 process pointer page 120 of 160
01:51:42.05 process pointer page 121 of 160
01:51:42.13 process pointer page 122 of 160
01:51:42.21 process pointer page 123 of 160
01:51:42.30 process pointer page 124 of 160
01:51:42.38 process pointer page 125 of 160
01:51:42.46 process pointer page 126 of 160
01:51:42.53 process pointer page 127 of 160
01:51:42.61 process pointer page 128 of 160
01:51:42.69 process pointer page 129 of 160
01:51:42.77 process pointer page 130 of 160
01:51:42.82 process pointer page 131 of 160
01:51:42.85 process pointer page 132 of 160
01:51:42.92 process pointer page 133 of 160
01:51:43.00 process pointer page 134 of 160
01:51:43.08 process pointer page 135 of 160
01:51:43.16 process pointer page 136 of 160
01:51:43.25 process pointer page 137 of 160
01:51:43.30 process pointer page 138 of 160
01:51:43.35 process pointer page 139 of 160
01:51:43.39 process pointer page 140 of 160
01:51:43.47 process pointer page 141 of 160
01:51:43.56 process pointer page 142 of 160
01:51:43.64 process pointer page 143 of 160
01:51:43.72 process pointer page 144 of 160
01:51:43.80 process pointer page 145 of 160
01:51:43.84 process pointer page 146 of 160
01:51:43.88 process pointer page 147 of 160
01:51:43.91 process pointer page 148 of 160
01:51:43.94 process pointer page 149 of 160
01:51:43.97 process pointer page 150 of 160
01:51:44.00 process pointer page 151 of 160
01:51:44.02 process pointer page 152 of 160
01:51:44.05 process pointer page 153 of 160
01:51:44.08 process pointer page 154 of 160
01:51:44.11 process pointer page 155 of 160
01:51:44.14 process pointer page 156 of 160
01:51:44.17 process pointer page 157 of 160
01:51:44.20 process pointer page 158 of 160
01:51:44.23 process pointer page 159 of 160
01:51:44.25 Index 1 (PERF_LOG_DTS_BEG_DESC)
01:51:47.76 Index 2 (PERF_LOG_UNIT)
01:51:52.80 Index 3 (PERF_LOG_TRN_DESC)
01:51:55.50 Index 4 (PERF_LOG_GDSCODE)
01:51:57.56 Relation 163 (PERF_LOG) is ok

01:51:57.56 Relation 167 (V_STOPTEST)
01:51:57.56 Relation 167 (V_STOPTEST) is ok

01:51:57.56 Relation 184 (V_QDISTR_SOURCE)
01:51:57.56 Relation 184 (V_QDISTR_SOURCE) is ok

01:51:57.56 Relation 185 (V_QSTORNED_SOURCE)
01:51:57.56 Relation 185 (V_QSTORNED_SOURCE) is ok

01:51:57.56 Relation 260 (XQD_1000_1200)
01:51:57.56 process pointer page 0 of 2
01:51:57.56 process pointer page 1 of 2
01:51:57.56 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
01:51:57.56 Relation 260 (XQD_1000_1200) is ok

01:51:57.56 Relation 261 (XQD_1200_2000)
01:51:57.56 process pointer page 0 of 3
01:51:57.59 process pointer page 1 of 3
01:51:57.62 process pointer page 2 of 3
01:51:57.64 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
01:51:57.64 Relation 261 (XQD_1200_2000) is ok

01:51:57.64 Relation 262 (XQD_1000_3300)
01:51:57.64 process pointer page 0 of 9
01:51:57.73 process pointer page 1 of 9
01:51:57.82 process pointer page 2 of 9
01:51:57.92 process pointer page 3 of 9
01:51:58.01 process pointer page 4 of 9
01:51:58.09 process pointer page 5 of 9
01:51:58.18 process pointer page 6 of 9
01:51:58.27 process pointer page 7 of 9
01:51:58.37 process pointer page 8 of 9
01:51:58.43 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
01:51:58.79 Index 2 (XQD_1000_3300_DOC)
01:51:59.05 Relation 262 (XQD_1000_3300) is ok

01:51:59.05 Relation 263 (XQD_2000_3300)
01:51:59.05 process pointer page 0 of 18
01:51:59.15 process pointer page 1 of 18
01:51:59.23 process pointer page 2 of 18
01:51:59.30 process pointer page 3 of 18
01:51:59.40 process pointer page 4 of 18
01:51:59.48 process pointer page 5 of 18
01:51:59.57 process pointer page 6 of 18
01:51:59.65 process pointer page 7 of 18
01:51:59.74 process pointer page 8 of 18
01:51:59.82 process pointer page 9 of 18
01:51:59.91 process pointer page 10 of 18
01:52:00.01 process pointer page 11 of 18
01:52:00.08 process pointer page 12 of 18
01:52:00.18 process pointer page 13 of 18
01:52:00.27 process pointer page 14 of 18
01:52:00.35 process pointer page 15 of 18
01:52:00.44 process pointer page 16 of 18
01:52:00.54 process pointer page 17 of 18
01:52:00.61 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
01:52:00.93 Relation 263 (XQD_2000_3300) is ok

01:52:00.93 Relation 264 (XQD_2100_3300)
01:52:00.93 process pointer page 0 of 14
01:52:00.96 process pointer page 1 of 14
01:52:00.97 process pointer page 2 of 14
01:52:01.00 process pointer page 3 of 14
01:52:01.02 process pointer page 4 of 14
01:52:01.05 process pointer page 5 of 14
01:52:01.08 process pointer page 6 of 14
01:52:01.10 process pointer page 7 of 14
01:52:01.13 process pointer page 8 of 14
01:52:01.15 process pointer page 9 of 14
01:52:01.16 process pointer page 10 of 14
01:52:01.19 process pointer page 11 of 14
01:52:01.21 process pointer page 12 of 14
01:52:01.24 process pointer page 13 of 14
01:52:01.24 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
01:52:01.25 Relation 264 (XQD_2100_3300) is ok

01:52:01.25 Relation 265 (XQD_3300_3400)
01:52:01.25 process pointer page 0 of 24
01:52:01.29 process pointer page 1 of 24
01:52:01.32 process pointer page 2 of 24
01:52:01.36 process pointer page 3 of 24
01:52:01.46 process pointer page 4 of 24
01:52:01.55 process pointer page 5 of 24
01:52:01.64 process pointer page 6 of 24
01:52:01.74 process pointer page 7 of 24
01:52:01.82 process pointer page 8 of 24
01:52:01.91 process pointer page 9 of 24
01:52:02.00 process pointer page 10 of 24
01:52:02.10 process pointer page 11 of 24
01:52:02.19 process pointer page 12 of 24
01:52:02.28 process pointer page 13 of 24
01:52:02.38 process pointer page 14 of 24
01:52:02.47 process pointer page 15 of 24
01:52:02.56 process pointer page 16 of 24
01:52:02.63 process pointer page 17 of 24
01:52:02.67 process pointer page 18 of 24
01:52:02.77 process pointer page 19 of 24
01:52:02.86 process pointer page 20 of 24
01:52:02.95 process pointer page 21 of 24
01:52:03.05 process pointer page 22 of 24
01:52:03.14 process pointer page 23 of 24
01:52:03.24 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
01:52:04.37 Relation 265 (XQD_3300_3400) is ok

01:52:04.37 Relation 266 (XQS_1000_1200)
01:52:04.37 process pointer page 0 of 41
01:52:04.48 process pointer page 1 of 41
01:52:04.59 process pointer page 2 of 41
01:52:04.69 process pointer page 3 of 41
01:52:04.80 process pointer page 4 of 41
01:52:04.90 process pointer page 5 of 41
01:52:05.01 process pointer page 6 of 41
01:52:05.12 process pointer page 7 of 41
01:52:05.23 process pointer page 8 of 41
01:52:05.34 process pointer page 9 of 41
01:52:05.45 process pointer page 10 of 41
01:52:05.56 process pointer page 11 of 41
01:52:05.65 process pointer page 12 of 41
01:52:05.72 process pointer page 13 of 41
01:52:05.78 process pointer page 14 of 41
01:52:05.89 process pointer page 15 of 41
01:52:05.98 process pointer page 16 of 41
01:52:06.09 process pointer page 17 of 41
01:52:06.20 process pointer page 18 of 41
01:52:06.28 process pointer page 19 of 41
01:52:06.34 process pointer page 20 of 41
01:52:06.42 process pointer page 21 of 41
01:52:06.45 process pointer page 22 of 41
01:52:06.50 process pointer page 23 of 41
01:52:06.54 process pointer page 24 of 41
01:52:06.61 process pointer page 25 of 41
01:52:06.67 process pointer page 26 of 41
01:52:06.73 process pointer page 27 of 41
01:52:06.79 process pointer page 28 of 41
01:52:06.90 process pointer page 29 of 41
01:52:06.93 process pointer page 30 of 41
01:52:06.98 process pointer page 31 of 41
01:52:07.03 process pointer page 32 of 41
01:52:07.06 process pointer page 33 of 41
01:52:07.10 process pointer page 34 of 41
01:52:07.21 process pointer page 35 of 41
01:52:07.31 process pointer page 36 of 41
01:52:07.42 process pointer page 37 of 41
01:52:07.53 process pointer page 38 of 41
01:52:07.63 process pointer page 39 of 41
01:52:07.74 process pointer page 40 of 41
01:52:07.78 Index 1 (XQS_1000_1200_DOC_ID)
01:52:08.90 Index 2 (XQS_1000_1200_SND_ID)
01:52:10.26 Index 3 (XQS_1000_1200_RCV_ID)
01:52:11.36 Relation 266 (XQS_1000_1200) is ok

01:52:11.36 Relation 267 (XQS_1200_2000)
01:52:11.36 process pointer page 0 of 44
01:52:11.46 process pointer page 1 of 44
01:52:11.57 process pointer page 2 of 44
01:52:11.68 process pointer page 3 of 44
01:52:11.78 process pointer page 4 of 44
01:52:11.89 process pointer page 5 of 44
01:52:12.00 process pointer page 6 of 44
01:52:12.11 process pointer page 7 of 44
01:52:12.22 process pointer page 8 of 44
01:52:12.28 process pointer page 9 of 44
01:52:12.31 process pointer page 10 of 44
01:52:12.36 process pointer page 11 of 44
01:52:12.41 process pointer page 12 of 44
01:52:12.44 process pointer page 13 of 44
01:52:12.47 process pointer page 14 of 44
01:52:12.50 process pointer page 15 of 44
01:52:12.53 process pointer page 16 of 44
01:52:12.56 process pointer page 17 of 44
01:52:12.60 process pointer page 18 of 44
01:52:12.63 process pointer page 19 of 44
01:52:12.66 process pointer page 20 of 44
01:52:12.69 process pointer page 21 of 44
01:52:12.72 process pointer page 22 of 44
01:52:12.75 process pointer page 23 of 44
01:52:12.77 process pointer page 24 of 44
01:52:12.80 process pointer page 25 of 44
01:52:12.83 process pointer page 26 of 44
01:52:12.86 process pointer page 27 of 44
01:52:12.91 process pointer page 28 of 44
01:52:13.02 process pointer page 29 of 44
01:52:13.08 process pointer page 30 of 44
01:52:13.16 process pointer page 31 of 44
01:52:13.25 process pointer page 32 of 44
01:52:13.36 process pointer page 33 of 44
01:52:13.47 process pointer page 34 of 44
01:52:13.58 process pointer page 35 of 44
01:52:13.67 process pointer page 36 of 44
01:52:13.78 process pointer page 37 of 44
01:52:13.89 process pointer page 38 of 44
01:52:14.00 process pointer page 39 of 44
01:52:14.11 process pointer page 40 of 44
01:52:14.20 process pointer page 41 of 44
01:52:14.31 process pointer page 42 of 44
01:52:14.42 process pointer page 43 of 44
01:52:14.47 Index 1 (XQS_1200_2000_DOC_ID)
01:52:15.97 Index 2 (XQS_1200_2000_SND_ID)
01:52:17.51 Index 3 (XQS_1200_2000_RCV_ID)
01:52:18.16 Relation 267 (XQS_1200_2000) is ok

01:52:18.16 Relation 268 (XQS_1000_3300)
01:52:18.16 process pointer page 0 of 22
01:52:18.20 process pointer page 1 of 22
01:52:18.24 process pointer page 2 of 22
01:52:18.27 process pointer page 3 of 22
01:52:18.32 process pointer page 4 of 22
01:52:18.35 process pointer page 5 of 22
01:52:18.38 process pointer page 6 of 22
01:52:18.41 process pointer page 7 of 22
01:52:18.45 process pointer page 8 of 22
01:52:18.48 process pointer page 9 of 22
01:52:18.55 process pointer page 10 of 22
01:52:18.66 process pointer page 11 of 22
01:52:18.77 process pointer page 12 of 22
01:52:18.88 process pointer page 13 of 22
01:52:18.99 process pointer page 14 of 22
01:52:19.09 process pointer page 15 of 22
01:52:19.16 process pointer page 16 of 22
01:52:19.35 process pointer page 17 of 22
01:52:19.58 process pointer page 18 of 22
01:52:19.83 process pointer page 19 of 22
01:52:20.10 process pointer page 20 of 22
01:52:20.40 process pointer page 21 of 22
01:52:20.65 Index 1 (XQS_1000_3300_DOC_ID)
01:52:21.97 Index 2 (XQS_1000_3300_SND_ID)
01:52:23.47 Index 3 (XQS_1000_3300_RCV_ID)
01:52:24.94 Relation 268 (XQS_1000_3300) is ok

01:52:24.94 Relation 269 (XQS_2000_3300)
01:52:24.94 process pointer page 0 of 1
01:52:24.94 Index 1 (XQS_2000_3300_DOC_ID)
01:52:24.94 Index 2 (XQS_2000_3300_SND_ID)
01:52:24.95 Index 3 (XQS_2000_3300_RCV_ID)
01:52:24.95 Relation 269 (XQS_2000_3300) is ok

01:52:24.95 Relation 270 (XQS_2100_3300)
01:52:24.95 process pointer page 0 of 30
01:52:25.40 process pointer page 1 of 30
01:52:25.90 process pointer page 2 of 30
01:52:26.40 process pointer page 3 of 30
01:52:26.92 process pointer page 4 of 30
01:52:27.42 process pointer page 5 of 30
01:52:27.90 process pointer page 6 of 30
01:52:28.38 process pointer page 7 of 30
01:52:28.88 process pointer page 8 of 30
01:52:29.35 process pointer page 9 of 30
01:52:29.71 process pointer page 10 of 30
01:52:30.15 process pointer page 11 of 30
01:52:30.63 process pointer page 12 of 30
01:52:31.13 process pointer page 13 of 30
01:52:31.63 process pointer page 14 of 30
01:52:32.13 process pointer page 15 of 30
01:52:32.63 process pointer page 16 of 30
01:52:33.11 process pointer page 17 of 30
01:52:33.61 process pointer page 18 of 30
01:52:34.11 process pointer page 19 of 30
01:52:34.61 process pointer page 20 of 30
01:52:35.04 process pointer page 21 of 30
01:52:35.36 process pointer page 22 of 30
01:52:35.73 process pointer page 23 of 30
01:52:36.20 process pointer page 24 of 30
01:52:36.68 process pointer page 25 of 30
01:52:37.15 process pointer page 26 of 30
01:52:37.63 process pointer page 27 of 30
01:52:38.12 process pointer page 28 of 30
01:52:38.57 process pointer page 29 of 30
01:52:38.80 Index 1 (XQS_2100_3300_DOC_ID)
01:52:40.64 Index 2 (XQS_2100_3300_SND_ID)
01:52:42.61 Index 3 (XQS_2100_3300_RCV_ID)
01:52:44.86 Relation 270 (XQS_2100_3300) is ok

01:52:44.86 Relation 271 (XQS_3300_3400)
01:52:44.86 process pointer page 0 of 5
01:52:45.36 process pointer page 1 of 5
01:52:45.85 process pointer page 2 of 5
01:52:46.32 process pointer page 3 of 5
01:52:46.76 process pointer page 4 of 5
01:52:46.88 Index 1 (XQS_3300_3400_DOC_ID)
01:52:47.21 Index 2 (XQS_3300_3400_SND_ID)
01:52:47.54 Relation 271 (XQS_3300_3400) is ok

01:52:47.57 Validation finished
Done for 79650 ms, from 1:51:28.03 to 1:52:47.68.

Differences between old and current firebird.log

1:52:49.74. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-01-19 01:52 509 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

Comparison of old and new firebird.log (get messages that appeared during test):

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Thu Jan 19 01:51:28 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Thu Jan 19 01:52:47 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

Final processing ISQL logs in e:\temp\logs.oltp40


Remove 401 logs of every ISQL session if there were no serious errors.

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2017-01-19 1:52:56.37 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html

Subscribe to IBSurgeon news

Subscribe