Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 40. 2016-01-29 16:45:06.78.
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-V3.0.0.32297 Firebird 3.0 Release Candidate 2
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperServer 3.0.0 D:\OLTP-EMUL\OLTP30-SMALL.FDB ON 0 786432 8192

Test configuration settings

File: E:\OLTP-EMUL\src\oltp30_config.win
PARAM_NAME PARAM_VALUE
fbc E:\FB30.TMPINSTANCE
dbnm D:\OLTP-EMUL\oltp30-small.fdb
host localhost
port 3333
usr SYSDBA
pwd masterkey
tmpdir e:\temp\logs.oltp30
working_mode small_03
warm_time 10
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 0
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
upload_report 1

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2016-01-29 16:42:53.0780 -1 <null> ::1/55952 341191 4957 2

Current test settings

CATEGORY SETTING VAL
COMMON TRACED_UNITS ,,
COMMON ENABLE_MON_QUERY 0
COMMON HALT_TEST_ON_ERRORS ,CK,
COMMON LOG_PK_VIOLATION 0
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: 6121.41 3003 1101854 2016-01-29 13:42 2016-01-29 16:42
customer order: creation 400.90 334 72162 2016-01-29 13:42 2016-01-29 16:42
customer order: refuse 32.48 71 5846 2016-01-29 13:42 2016-01-29 16:42
order to supplier: creation 103.54 2039 18638 2016-01-29 13:42 2016-01-29 16:42
order to supplier: removal 2.86 31835 512 2016-01-29 13:42 2016-01-29 16:42
invoice (draft): creation 102.80 3507 18504 2016-01-29 13:42 2016-01-29 16:42
invoice (draft): removal 42.07 763 7530 2016-01-29 13:42 2016-01-29 16:42
invoice accept: apply 62.62 9832 11271 2016-01-29 13:42 2016-01-29 16:42
invoice accept: cancel 20.10 1940 3577 2016-01-29 13:42 2016-01-29 16:42
customer reserve: creation 3567.93 145 642227 2016-01-29 13:42 2016-01-29 16:42
customer reserve: removal 1218.32 55 219298 2016-01-29 13:42 2016-01-29 16:42
realization accept: apply 186.15 193 33507 2016-01-29 13:42 2016-01-29 16:42
realization accept: cancel 69.56 103 12520 2016-01-29 13:42 2016-01-29 16:42
payment from customer: creation 134.34 342 24182 2016-01-29 13:42 2016-01-29 16:42
payment from customer: removal 12.58 54 2252 2016-01-29 13:42 2016-01-29 16:42
payment to supplier: creation 110.01 221 19802 2016-01-29 13:42 2016-01-29 16:42
payment to supplier: removal 7.70 73 1386 2016-01-29 13:42 2016-01-29 16:42
service: total inventory turnovers 24.24 861 4363 2016-01-29 13:42 2016-01-29 16:42
service: total monetary turnovers 23.69 23 4265 2016-01-29 13:42 2016-01-29 16:42
service: refresh index statistics 0.07 4665 12 2016-01-29 13:42 2016-01-29 16:42
Done for 55480 ms, from 16:46:25.85 to 16:47:21.33.

Performance in DYNAMIC:

ACTION ITRV_NO CNT_OK_PER_MINUTE CNT_ALL CNT_OK CNT_ERR ERR_PRC ITRV_BEG ITRV_END
interval # 1, overall 1 5172 100451 93087 7364 7.33 13:42:54 14:00:53
interval # 2, overall 2 5964 114321 107350 6971 6.10 14:00:54 14:18:53
interval # 3, overall 3 5961 115935 107305 8630 7.44 14:18:54 14:36:53
interval # 4, overall 4 6292 120133 113259 6874 5.72 14:36:54 14:54:53
interval # 5, overall 5 6136 114870 110450 4420 3.85 14:54:54 15:12:53
interval # 6, overall 6 6326 124391 113864 10527 8.46 15:12:54 15:30:53
interval # 7, overall 7 6166 119398 110979 8419 7.05 15:30:54 15:48:53
interval # 8, overall 8 5571 111268 100285 10983 9.87 15:48:54 16:06:53
interval # 9, overall 9 6917 131343 124498 6845 5.21 16:06:54 16:24:53
interval # 10, overall 10 6710 128933 120777 8156 6.33 16:24:54 16:42:53
Done for 135470 ms, from 16:49:42.26 to 16:51:57.73.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
WARM_TIME 1 2344.08 0.0627 1.9197 3176 40
WARM_TIME 2 2854.20 0.7883 1.2285 2190 37
WARM_TIME 3 2644.36 0.8841 1.1081 1276 30
WARM_TIME 4 2449.78 0.9000 1.0917 1179 29
WARM_TIME 5 2363.16 0.9054 1.0892 1221 31
WARM_TIME 6 2353.01 0.9116 1.0859 1405 36
WARM_TIME 7 2405.41 0.9105 1.0935 1319 36
WARM_TIME 8 2521.39 0.9128 1.0924 1402 40
WARM_TIME 9 2665.05 0.9187 1.0739 1435 40
WARM_TIME 10 2779.65 0.9266 1.0725 1667 40
TEST_TIME 11 2834.94 0.9560 1.0539 1299 39
TEST_TIME 12 2928.38 0.9353 1.0559 1682 39
TEST_TIME 13 3029.33 0.9422 1.0436 1412 40
TEST_TIME 14 3133.06 0.9371 1.0479 1473 40
TEST_TIME 15 3219.35 0.9518 1.0484 1551 40
TEST_TIME 16 3306.87 0.9569 1.0504 1521 39
TEST_TIME 17 3364.31 0.9717 1.0324 1293 39
TEST_TIME 18 3387.17 0.9684 1.0347 1203 39
TEST_TIME 19 3449.16 0.9627 1.0343 1348 40
TEST_TIME 20 3508.20 0.9661 1.0354 1353 39
TEST_TIME 21 3577.49 0.9670 1.0288 1342 39
TEST_TIME 22 3666.16 0.9583 1.0540 1661 40
TEST_TIME 23 3757.02 0.9852 1.0236 1211 40
TEST_TIME 24 3864.21 0.9537 1.0360 1515 40
TEST_TIME 25 3963.60 0.9697 1.0342 1640 40
TEST_TIME 26 4082.01 0.9655 1.0341 1576 40
TEST_TIME 27 4181.19 0.9721 1.0279 1601 40
TEST_TIME 28 4251.95 0.9771 1.0259 1662 39
TEST_TIME 29 4323.82 0.9741 1.0231 1461 40
TEST_TIME 30 4357.24 0.9815 1.0203 1571 39
TEST_TIME 31 4414.26 0.9746 1.0191 1590 40
TEST_TIME 32 4441.27 0.9812 1.0196 1289 39
TEST_TIME 33 4484.07 0.9793 1.0232 1241 40
TEST_TIME 34 4492.70 0.9912 1.0123 935 40
TEST_TIME 35 4537.10 0.9738 1.0238 1748 40
TEST_TIME 36 4617.40 0.9780 1.0216 1811 39
TEST_TIME 37 4687.44 0.9791 1.0202 1639 40
TEST_TIME 38 4740.58 0.9822 1.0159 1568 40
TEST_TIME 39 4781.83 0.9813 1.0164 1682 39
TEST_TIME 40 4835.87 0.9799 1.0145 1427 39
TEST_TIME 41 4852.77 0.9863 1.0085 1079 39
TEST_TIME 42 4828.03 0.9895 1.0123 848 36
TEST_TIME 43 4854.43 0.9834 1.0140 1487 40
TEST_TIME 44 4888.02 0.9842 1.0150 1459 40
TEST_TIME 45 4906.15 0.9887 1.0121 1444 38
TEST_TIME 46 4916.36 0.9880 1.0127 1353 39
TEST_TIME 47 4924.10 0.9896 1.0116 1338 39
TEST_TIME 48 4940.06 0.9873 1.0122 1214 38
TEST_TIME 49 4945.19 0.9905 1.0098 1009 40
TEST_TIME 50 4954.82 0.9877 1.0110 1803 37
TEST_TIME 51 4970.84 0.9880 1.0119 1676 39
TEST_TIME 52 4994.45 0.9878 1.0116 1672 39
TEST_TIME 53 5023.61 0.9868 1.0120 1566 40
TEST_TIME 54 5053.87 0.9873 1.0130 1694 39
TEST_TIME 55 5082.42 0.9890 1.0117 1704 40
TEST_TIME 56 5114.99 0.9873 1.0146 1596 39
TEST_TIME 57 5167.74 0.9867 1.0124 1607 40
TEST_TIME 58 5204.90 0.9879 1.0073 1201 40
TEST_TIME 59 5202.80 0.9907 1.0100 1490 40
TEST_TIME 60 5219.15 0.9901 1.0089 1524 38
TEST_TIME 61 5224.03 0.9915 1.0087 1357 38
TEST_TIME 62 5239.95 0.9894 1.0081 1317 39
TEST_TIME 63 5239.52 0.9922 1.0076 1308 39
TEST_TIME 64 5242.06 0.9914 1.0041 1316 40
TEST_TIME 65 5246.38 0.9878 1.0109 1983 39
TEST_TIME 66 5298.04 0.9859 1.0131 1780 40
TEST_TIME 67 5327.59 0.9924 1.0096 1732 40
TEST_TIME 68 5345.44 0.9914 1.0093 1654 40
TEST_TIME 69 5363.85 0.9913 1.0067 1586 40
TEST_TIME 70 5380.72 0.9893 1.0064 1557 39
TEST_TIME 71 5385.51 0.9914 1.0094 1413 39
TEST_TIME 72 5406.53 0.9915 1.0080 1286 39
TEST_TIME 73 5413.35 0.9930 1.0079 1237 39
TEST_TIME 74 5428.16 0.9916 1.0065 1295 38
TEST_TIME 75 5429.28 0.9929 1.0063 1333 39
TEST_TIME 76 5419.02 0.9949 1.0057 1154 39
TEST_TIME 77 5406.72 0.9949 1.0052 1091 38
TEST_TIME 78 5393.83 0.9947 1.0050 1132 37
TEST_TIME 79 5388.48 0.9932 1.0050 1130 39
TEST_TIME 80 5396.17 0.9910 1.0100 1355 40
TEST_TIME 81 5427.32 0.9918 1.0084 1519 39
TEST_TIME 82 5443.19 0.9932 1.0071 1457 38
TEST_TIME 83 5450.81 0.9936 1.0072 1351 39
TEST_TIME 84 5462.19 0.9932 1.0063 1554 38
TEST_TIME 85 5466.58 0.9937 1.0064 1414 39
TEST_TIME 86 5465.87 0.9948 1.0056 1291 39
TEST_TIME 87 5475.10 0.9924 1.0093 1049 38
TEST_TIME 88 5491.37 0.9949 1.0039 1233 39
TEST_TIME 89 5477.40 0.9952 1.0049 1345 37
TEST_TIME 90 5474.37 0.9943 1.0060 1080 37
TEST_TIME 91 5488.49 0.9924 1.0068 1102 39
TEST_TIME 92 5491.03 0.9954 1.0052 1186 38
TEST_TIME 93 5497.34 0.9932 1.0045 1122 38
TEST_TIME 94 5493.17 0.9946 1.0052 1240 40
TEST_TIME 95 5500.00 0.9934 1.0052 1543 39
TEST_TIME 96 5499.73 0.9947 1.0099 1686 40
TEST_TIME 97 5531.85 0.9938 1.0059 1456 40
TEST_TIME 98 5539.65 0.9943 1.0056 1591 39
TEST_TIME 99 5545.95 0.9951 1.0057 1471 40
TEST_TIME 100 5554.61 0.9940 1.0082 1518 40
TEST_TIME 101 5570.29 0.9954 1.0071 1554 39
TEST_TIME 102 5576.99 0.9960 1.0051 1610 39
TEST_TIME 103 5590.40 0.9930 1.0077 1175 40
TEST_TIME 104 5598.47 0.9966 1.0044 1363 38
TEST_TIME 105 5611.37 0.9929 1.0039 1121 37
TEST_TIME 106 5615.75 0.9937 1.0046 1017 40
TEST_TIME 107 5614.55 0.9954 1.0050 1015 39
TEST_TIME 108 5609.73 0.9966 1.0044 1172 39
TEST_TIME 109 5600.23 0.9969 1.0022 934 39
TEST_TIME 110 5578.18 0.9970 1.0037 1024 36
TEST_TIME 111 5577.55 0.9948 1.0075 1438 40
TEST_TIME 112 5592.48 0.9958 1.0055 1386 40
TEST_TIME 113 5608.00 0.9938 1.0100 1438 40
TEST_TIME 114 5636.31 0.9962 1.0050 1393 40
TEST_TIME 115 5656.77 0.9926 1.0067 1335 40
TEST_TIME 116 5676.58 0.9946 1.0053 1545 39
TEST_TIME 117 5683.47 0.9955 1.0047 1279 38
TEST_TIME 118 5688.52 0.9953 1.0050 1153 39
TEST_TIME 119 5700.46 0.9944 1.0054 1078 40
TEST_TIME 120 5708.34 0.9957 1.0036 1223 40
TEST_TIME 121 5697.20 0.9973 1.0033 1329 38
TEST_TIME 122 5696.36 0.9952 1.0048 1199 39
TEST_TIME 123 5703.08 0.9954 1.0039 1018 40
TEST_TIME 124 5698.66 0.9966 1.0028 1207 37
TEST_TIME 125 5709.24 0.9929 1.0054 1487 39
TEST_TIME 126 5720.17 0.9955 1.0043 1455 39
TEST_TIME 127 5738.64 0.9932 1.0034 1619 40
TEST_TIME 128 5736.33 0.9960 1.0038 1597 39
TEST_TIME 129 5733.49 0.9965 1.0039 1633 39
TEST_TIME 130 5733.07 0.9963 1.0034 1434 40
TEST_TIME 131 5740.73 0.9945 1.0053 1227 40
TEST_TIME 132 5750.91 0.9960 1.0035 1437 39
TEST_TIME 133 5751.03 0.9960 1.0043 1248 39
TEST_TIME 134 5752.71 0.9965 1.0034 1223 38
TEST_TIME 135 5753.94 0.9958 1.0035 1127 39
TEST_TIME 136 5755.80 0.9958 1.0039 1090 39
TEST_TIME 137 5752.65 0.9971 1.0025 953 39
TEST_TIME 138 5737.93 0.9978 1.0020 1024 38
TEST_TIME 139 5727.13 0.9967 1.0025 851 36
TEST_TIME 140 5726.52 0.9955 1.0036 1151 39
TEST_TIME 141 5726.15 0.9966 1.0031 1129 39
TEST_TIME 142 5730.38 0.9953 1.0037 1086 38
TEST_TIME 143 5735.99 0.9957 1.0039 1187 39
TEST_TIME 144 5743.61 0.9956 1.0030 1179 39
TEST_TIME 145 5738.08 0.9971 1.0032 1086 36
TEST_TIME 146 5736.36 0.9966 1.0039 1012 37
TEST_TIME 147 5737.26 0.9969 1.0024 1089 38
TEST_TIME 148 5734.60 0.9961 1.0044 1251 40
TEST_TIME 149 5738.33 0.9970 1.0038 1191 39
TEST_TIME 150 5735.80 0.9976 1.0025 1053 38
TEST_TIME 151 5731.68 0.9966 1.0027 983 40
TEST_TIME 152 5730.75 0.9963 1.0035 1019 40
TEST_TIME 153 5738.52 0.9956 1.0041 1069 39
TEST_TIME 154 5736.44 0.9979 1.0031 1182 39
TEST_TIME 155 5749.85 0.9943 1.0043 1479 40
TEST_TIME 156 5755.49 0.9969 1.0043 1547 40
TEST_TIME 157 5768.40 0.9956 1.0032 1567 39
TEST_TIME 158 5769.22 0.9967 1.0045 1214 39
TEST_TIME 159 5786.45 0.9952 1.0038 1323 40
TEST_TIME 160 5789.24 0.9970 1.0024 1240 40
TEST_TIME 161 5792.92 0.9955 1.0046 1272 39
TEST_TIME 162 5804.93 0.9963 1.0034 1223 40
TEST_TIME 163 5807.21 0.9969 1.0038 1235 40
TEST_TIME 164 5809.32 0.9973 1.0023 1106 39
TEST_TIME 165 5808.61 0.9964 1.0043 1105 40
TEST_TIME 166 5818.09 0.9967 1.0021 1170 40
TEST_TIME 167 5818.60 0.9965 1.0037 1190 39
TEST_TIME 168 5824.45 0.9967 1.0023 1088 40
TEST_TIME 169 5820.69 0.9970 1.0036 1118 39
TEST_TIME 170 5829.88 0.9961 1.0054 1554 40
TEST_TIME 171 5848.05 0.9964 1.0033 1502 39
TEST_TIME 172 5848.41 0.9974 1.0038 1300 39
TEST_TIME 173 5869.76 0.9945 1.0037 1270 40
TEST_TIME 174 5876.45 0.9967 1.0034 1463 39
TEST_TIME 175 5879.48 0.9972 1.0028 1455 38
TEST_TIME 176 5878.90 0.9972 1.0028 1199 38
TEST_TIME 177 5883.31 0.9964 1.0031 1323 39
TEST_TIME 178 5885.18 0.9972 1.0027 1011 40
TEST_TIME 179 5885.71 0.9970 1.0028 1204 38
TEST_TIME 180 5891.06 0.9963 1.0035 1188 39
TEST_TIME 181 5901.01 0.9964 1.0025 1157 39
TEST_TIME 182 5896.22 0.9978 1.0028 1220 39
TEST_TIME 183 5898.96 0.9969 1.0024 973 40
TEST_TIME 184 5895.19 0.9976 1.0033 1056 38
TEST_TIME 185 5900.46 0.9969 1.0029 1420 37
TEST_TIME 186 5908.15 0.9962 1.0049 1551 39
TEST_TIME 187 5928.37 0.9961 1.0037 1243 39
TEST_TIME 188 5940.96 0.9963 1.0030 1263 38
TEST_TIME 189 5939.51 0.9980 1.0024 1038 40
TEST_TIME 190 5942.22 0.9967 1.0024 1237 40
Done for 10040 ms, from 16:51:59.26 to 16:52:09.30.

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 6573 17149 7709 36245 7644 <null> 21030 15926 14236 8365 9080 8334 31458 13439 49214 5900 347499 184487 <null> 13:42:54 14:00:53
fetches per second 2 6814 34698 9736 14729 14081 37724 23550 13024 16690 13377 9941 10968 36283 18044 36874 9796 312300 255378 <null> 14:00:54 14:18:53
fetches per second 3 7757 19261 7671 35524 12503 11963 28348 14176 19858 15287 14050 11677 36890 11340 30307 22558 350919 280625 <null> 14:18:54 14:36:53
fetches per second 4 6496 18049 10744 12509 9297 11187 21239 20072 21600 12825 11180 7358 46218 12678 34073 12499 428722 352570 <null> 14:36:54 14:54:53
fetches per second 5 8803 16210 9576 10317 15287 10360 30048 12036 36286 11883 14598 9440 53225 18563 29771 9907 437775 319399 <null> 14:54:54 15:12:53
fetches per second 6 11066 15260 13841 39914 14550 10964 26863 20203 32610 11258 16624 21726 45437 30730 24206 7697 235495 247240 <null> 15:12:54 15:30:53
fetches per second 7 9460 17012 11085 18165 19303 6859 23067 12427 35298 29131 12749 9329 34066 8360 28771 11409 163041 105961 <null> 15:30:54 15:48:53
fetches per second 8 7490 14164 10124 <null> 11715 10373 16038 15284 21742 11168 13995 7062 32511 14669 22488 10674 282772 328367 <null> 15:48:54 16:06:53
fetches per second 9 15995 41386 14321 <null> 20438 6876 31024 49010 25705 12883 13807 10691 40475 12357 32451 8411 83604 159621 <null> 16:06:54 16:24:53
fetches per second 10 9725 16611 15736 6459 12512 9145 24638 27016 28221 11653 15091 6794 41609 15638 51939 7430 240109 272136 <null> 16:24:54 16:42:53
marks per second 1 1107 1534 922 3595 895 <null> 1404 1644 1923 1363 1322 946 991 1558 1726 513 2937 1556 <null> 13:42:54 14:00:53
marks per second 2 1187 3215 1167 2004 1796 5758 1435 1317 1620 1439 1172 1145 956 1687 1074 1270 2334 2631 <null> 14:00:54 14:18:53
marks per second 3 1314 1781 909 3645 1461 1911 1916 1758 1640 1498 1464 1286 758 1205 1366 1872 4000 3063 <null> 14:18:54 14:36:53
marks per second 4 1120 1669 1160 1575 844 1867 1231 2169 1620 1390 1069 777 795 1256 1381 1297 3149 1675 <null> 14:36:54 14:54:53
marks per second 5 1446 1452 949 1005 1478 1714 1548 1114 1498 1264 1535 994 1290 1707 1421 1025 2060 2797 <null> 14:54:54 15:12:53
marks per second 6 1807 1396 1609 3430 1743 1509 2091 1861 1529 1239 1811 2143 1514 2991 1294 975 2698 7435 <null> 15:12:54 15:30:53
marks per second 7 1651 1510 1448 1810 2064 1207 1528 1164 1908 2774 1548 968 635 952 1430 1302 5975 1526 <null> 15:30:54 15:48:53
marks per second 8 1244 1310 1070 <null> 1142 1820 1092 1384 1419 1188 1356 747 785 1485 1139 1283 1951 1937 <null> 15:48:54 16:06:53
marks per second 9 2730 3921 2010 <null> 2571 1157 2042 4523 1840 1370 1719 1024 764 1419 1716 1082 2838 3101 <null> 16:06:54 16:24:53
marks per second 10 1609 1568 1629 1035 1328 1482 1425 2497 1129 1215 1430 748 616 1770 1771 800 1441 2579 <null> 16:24:54 16:42:53
reads/fetches*100 1 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 13:42:54 14:00:53
reads/fetches*100 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 14:00:54 14:18:53
reads/fetches*100 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 14:18:54 14:36:53
reads/fetches*100 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 14:36:54 14:54:53
reads/fetches*100 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 14:54:54 15:12:53
reads/fetches*100 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 15:12:54 15:30:53
reads/fetches*100 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 15:30:54 15:48:53
reads/fetches*100 8 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 15:48:54 16:06:53
reads/fetches*100 9 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 16:06:54 16:24:53
reads/fetches*100 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 16:24:54 16:42:53
writes/marks*100 1 0 0 0 0 0 <null> 0 0 1 0 0 0 0 0 0 0 3 0 <null> 13:42:54 14:00:53
writes/marks*100 2 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 4 0 <null> 14:00:54 14:18:53
writes/marks*100 3 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 3 0 <null> 14:18:54 14:36:53
writes/marks*100 4 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 <null> 14:36:54 14:54:53
writes/marks*100 5 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 3 0 <null> 14:54:54 15:12:53
writes/marks*100 6 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 5 1 <null> 15:12:54 15:30:53
writes/marks*100 7 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 4 0 <null> 15:30:54 15:48:53
writes/marks*100 8 0 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 4 0 <null> 15:48:54 16:06:53
writes/marks*100 9 0 0 0 <null> 0 0 0 0 1 2 1 0 0 0 0 1 3 0 <null> 16:06:54 16:24:53
writes/marks*100 10 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 4 0 <null> 16:24:54 16:42:53
Done for 9300 ms, from 16:52:10.47 to 16:52:19.77.

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 1839389 1768605 70784 3.84 0 5226 18 70784 2016-01-29 13:42 2016-01-29 16:42
doc_list_biud 1839695 1768605 71090 3.86 0 6084 15 71090 2016-01-29 13:42 2016-01-29 16:42
sp_add_invoice_to_stock 17382 11271 6111 35.15 47 121485 9832 6111 2016-01-29 13:42 2016-01-29 16:42
sp_cancel_adding_invoice 4151 3577 574 13.82 0 39500 1940 574 2016-01-29 13:42 2016-01-29 16:42
sp_cancel_client_order 6008 5846 162 2.69 0 920 71 162 2016-01-29 13:42 2016-01-29 16:42
sp_cancel_customer_reserve 285064 219298 65766 23.07 0 1653 55 65766 2016-01-29 13:42 2016-01-29 16:42
sp_cancel_pay_from_customer 2262 2252 10 0.44 0 655 54 10 2016-01-29 13:42 2016-01-29 16:42
sp_cancel_pay_to_supplier 1398 1386 12 0.85 0 889 73 12 2016-01-29 13:42 2016-01-29 16:42
sp_cancel_supplier_invoice 8678 7530 1148 13.22 0 7378 763 1148 2016-01-29 13:42 2016-01-29 16:42
sp_cancel_supplier_order 1350 512 838 62.07 31 231345 31835 838 2016-01-29 13:42 2016-01-29 16:42
sp_cancel_write_off 16596 12520 4076 24.56 0 1170 103 4076 2016-01-29 13:42 2016-01-29 16:42
sp_client_order 72162 72162 0 0.00 0 3104 334 0 2016-01-29 13:42 2016-01-29 16:42
sp_customer_reserve 642227 642227 0 0.00 0 6006 145 0 2016-01-29 13:42 2016-01-29 16:42
sp_fill_shopping_cart 109304 109304 0 0.00 0 5398 93 0 2016-01-29 13:42 2016-01-29 16:42
sp_fill_shopping_cart_clo_res 642227 642227 0 0.00 0 874 5 0 2016-01-29 13:42 2016-01-29 16:42
sp_get_clo_for_invoice 11272 11272 0 0.00 0 2792 418 0 2016-01-29 13:42 2016-01-29 16:42
sp_kill_cost_storno 24148 19735 4413 18.27 0 2059 23 4413 2016-01-29 13:42 2016-01-29 16:42
sp_kill_qstorno_ret_qs2qd 595291 459158 136133 22.86 0 6084 30 136133 2016-01-29 13:42 2016-01-29 16:42
sp_kill_qty_storno 365095 294061 71034 19.45 0 6084 80 71034 2016-01-29 13:42 2016-01-29 16:42
sp_lock_selected_doc 70778 62439 8339 11.78 0 639 2 8339 2016-01-29 13:42 2016-01-29 16:42
sp_make_cost_storno 88762 88762 0 0.00 0 4680 143 0 2016-01-29 13:42 2016-01-29 16:42
sp_multiply_rows_for_pdistr 88762 88762 0 0.00 0 874 51 0 2016-01-29 13:42 2016-01-29 16:42
sp_multiply_rows_for_qdistr 72164 72164 0 0.00 0 1841 191 0 2016-01-29 13:42 2016-01-29 16:42
sp_pay_from_customer 24182 24182 0 0.00 15 3933 342 0 2016-01-29 13:42 2016-01-29 16:42
sp_pay_to_supplier 19802 19802 0 0.00 0 3760 221 0 2016-01-29 13:42 2016-01-29 16:42
sp_payment_common 43984 43984 0 0.00 0 1108 25 0 2016-01-29 13:42 2016-01-29 16:42
sp_qd_handle_on_cancel_clo 6008 5846 162 2.69 0 608 31 162 2016-01-29 13:42 2016-01-29 16:42
sp_qd_handle_on_invoice_upd_sts 15320 14848 472 3.08 0 4586 470 472 2016-01-29 13:42 2016-01-29 16:42
sp_qd_handle_on_reserve_upd_sts 33507 33507 0 0.00 0 951 36 0 2016-01-29 13:42 2016-01-29 16:42
sp_reserve_write_off 33999 33507 492 1.44 0 3386 193 492 2016-01-29 13:42 2016-01-29 16:42
sp_supplier_invoice 18504 18504 0 0.00 0 19761 3507 0 2016-01-29 13:42 2016-01-29 16:42
sp_supplier_order 18638 18638 0 0.00 0 8691 2039 0 2016-01-29 13:42 2016-01-29 16:42
srv_find_qd_qs_mism 1078325 1007536 70789 6.56 0 2075 9 70789 2016-01-29 13:42 2016-01-29 16:42
srv_make_invnt_saldo 4363 4363 0 0.00 31 151874 861 0 2016-01-29 13:42 2016-01-29 16:42
srv_make_money_saldo 4265 4265 0 0.00 0 1497 23 0 2016-01-29 13:42 2016-01-29 16:42
srv_recalc_idx_stat 12 12 0 0.00 1857 15756 4665 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_add_invoice_to_stock 6111 6111 0 0.00 0 530 52 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_cancel_adding_invoice 429 429 0 0.00 0 1358 415 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_cancel_client_order 162 162 0 0.00 0 281 81 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_cancel_customer_reserve 25 25 0 0.00 0 281 61 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_cancel_pay_from_customer 10 10 0 0.00 15 203 74 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_cancel_pay_to_supplier 12 12 0 0.00 15 156 79 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_cancel_supplier_invoice 496 496 0 0.00 0 468 55 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_cancel_supplier_order 8399 8399 0 0.00 0 1992 300 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_cancel_write_off 49 49 0 0.00 0 187 54 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-abend:sp_reserve_write_off 492 492 0 0.00 0 375 54 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_add_invoice_to_stock 11288 11288 0 0.00 0 22158 2285 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_cancel_adding_invoice 1248 1248 0 0.00 0 11919 1993 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_cancel_client_order 5846 5846 0 0.00 0 655 79 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_cancel_customer_reserve 2237 2237 0 0.00 0 593 84 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_cancel_pay_from_customer 2252 2252 0 0.00 0 670 59 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_cancel_pay_to_supplier 1386 1386 0 0.00 0 390 59 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_cancel_supplier_invoice 881 881 0 0.00 0 421 76 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_cancel_supplier_order 512 512 0 0.00 0 140011 9355 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_cancel_write_off 3299 3299 0 0.00 0 765 86 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_client_order 72166 72166 0 0.00 0 1186 96 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_customer_reserve 3343 3343 0 0.00 0 1014 56 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_pay_from_customer 24182 24182 0 0.00 0 764 74 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_pay_to_supplier 19802 19802 0 0.00 0 660 68 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_reserve_write_off 33507 33507 0 0.00 0 858 92 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_supplier_invoice 18507 18507 0 0.00 0 1311 94 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:sp_supplier_order 18645 18645 0 0.00 0 858 94 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:srv_make_invnt_saldo 4364 4364 0 0.00 0 265 10 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:srv_make_money_saldo 4265 4265 0 0.00 0 1107 11 0 2016-01-29 13:42 2016-01-29 16:42
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 16 499 240 0 2016-01-29 13:42 2016-01-29 16:42
v_add_invoice_to_stock 34764 22542 12222 35.15 0 842 4 12222 2016-01-29 13:42 2016-01-29 16:42
v_all_customers 108394 108394 0 0.00 0 359 3 0 2016-01-29 13:42 2016-01-29 16:42
v_all_suppliers 81520 81520 0 0.00 0 578 3 0 2016-01-29 13:42 2016-01-29 16:42
v_all_wares 144324 144324 0 0.00 0 374 4 0 2016-01-29 13:42 2016-01-29 16:42
v_cancel_adding_invoice 2784 2496 288 10.34 0 1326 70 288 2016-01-29 13:42 2016-01-29 16:42
v_cancel_client_order 12016 11692 324 2.69 0 234 2 324 2016-01-29 13:42 2016-01-29 16:42
v_cancel_customer_prepayment 4524 4504 20 0.44 0 187 3 20 2016-01-29 13:42 2016-01-29 16:42
v_cancel_customer_reserve 4524 4474 50 1.10 0 187 4 50 2016-01-29 13:42 2016-01-29 16:42
v_cancel_payment_to_supplier 2796 2772 24 0.85 0 858 3 24 2016-01-29 13:42 2016-01-29 16:42
v_cancel_supplier_invoice 2754 1762 992 36.02 0 219 5 992 2016-01-29 13:42 2016-01-29 16:42
v_cancel_supplier_order 2700 1024 1676 62.07 0 312 4 1676 2016-01-29 13:42 2016-01-29 16:42
v_cancel_write_off 6696 6598 98 1.46 0 1014 38 98 2016-01-29 13:42 2016-01-29 16:42
v_max_id_clo_ord 18638 18638 0 0.00 0 271 6 0 2016-01-29 13:42 2016-01-29 16:42
v_max_id_clo_res 3343 3343 0 0.00 0 483 10 0 2016-01-29 13:42 2016-01-29 16:42
v_max_id_ord_sup 18504 18504 0 0.00 0 437 5 0 2016-01-29 13:42 2016-01-29 16:42
v_max_non_paid_invoice 16184 16184 0 0.00 0 281 4 0 2016-01-29 13:42 2016-01-29 16:42
v_max_non_paid_realizn 24182 24182 0 0.00 0 328 3 0 2016-01-29 13:42 2016-01-29 16:42
v_min_id_clo_ord 18638 18638 0 0.00 0 328 6 0 2016-01-29 13:42 2016-01-29 16:42
v_min_id_clo_res 3343 3343 0 0.00 0 1373 6 0 2016-01-29 13:42 2016-01-29 16:42
v_min_id_ord_sup 18504 18504 0 0.00 0 468 5 0 2016-01-29 13:42 2016-01-29 16:42
v_min_non_paid_invoice 19802 19802 0 0.00 0 609 7 0 2016-01-29 13:42 2016-01-29 16:42
v_min_non_paid_realizn 24182 24182 0 0.00 0 500 3 0 2016-01-29 13:42 2016-01-29 16:42
v_our_firm 35930 35930 0 0.00 0 344 3 0 2016-01-29 13:42 2016-01-29 16:42
v_reserve_write_off 67998 67014 984 1.44 0 1045 3 984 2016-01-29 13:42 2016-01-29 16:42
x_lock_depdocs_on_canc_invoice 15712 10226 5486 34.91 0 1092 19 5486 2016-01-29 13:42 2016-01-29 16:42
x_lock_depdocs_on_canc_sup_ord 1349 512 837 62.04 0 422 20 837 2016-01-29 13:42 2016-01-29 16:42
x_make_qstorno_1000_1200 18638 18638 0 0.00 0 7722 1799 0 2016-01-29 13:42 2016-01-29 16:42
x_make_qstorno_1200_2000 18504 18504 0 0.00 0 19340 3296 0 2016-01-29 13:42 2016-01-29 16:42
x_make_qstorno_2100_3300 642227 642227 0 0.00 0 5148 134 0 2016-01-29 13:42 2016-01-29 16:42
Done for 249660 ms, from 16:56:24.11 to 17:00:33.77.

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 68 sp_kill_cost_storno 335544336 2016-01-29 13:45 2016-01-29 16:40
deadlock 9 sp_kill_qstorno_ret_qs2qd 335544336 2016-01-29 13:46 2016-01-29 16:39
deadlock 736 sp_lock_selected_doc 335544336 2016-01-29 13:43 2016-01-29 16:42
deadlock 162 sp_qd_handle_on_cancel_clo 335544336 2016-01-29 13:43 2016-01-29 16:41
deadlock 108 sp_qd_handle_on_invoice_upd_sts 335544336 2016-01-29 13:43 2016-01-29 16:40
deadlock 9 x_lock_depdocs_on_canc_invoice 335544336 2016-01-29 14:28 2016-01-29 16:23
deadlock 1 x_lock_depdocs_on_canc_sup_ord 335544336 2016-01-29 16:42 2016-01-29 16:42
concurrent_transaction 6451 sp_lock_selected_doc 335544878 2016-01-29 13:42 2016-01-29 16:42
concurrent_transaction 438 x_lock_depdocs_on_canc_invoice 335544878 2016-01-29 13:43 2016-01-29 16:42
concurrent_transaction 354 x_lock_depdocs_on_canc_sup_ord 335544878 2016-01-29 13:42 2016-01-29 16:42
Done for 5790 ms, from 17:00:39.40 to 17:00:45.19.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 341496
MON$OLDEST_ACTIVE 341497
MON$OLDEST_SNAPSHOT 341497
MON$NEXT_TRANSACTION 341497
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 2015-12-11 13:07:49.8140
MON$PAGES 713984
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.0.32297 Firebird 3.0 Release Candidate 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.0.32297 Firebird 3.0 Release Candidate 2"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.0.32297 Firebird 3.0 Release Candidate 2/tcp (WIN-2BE1UI8LGDL)/P13"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.0.32297 Firebird 3.0 Release Candidate 2/tcp (WIN-2BE1UI8LGDL)/P13"
on disk structure version 12.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 341777
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 341498
Oldest active 341499
Oldest snapshot 341499
Next transaction 341500
Sequence number 0
Next attachment ID 5073
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 13:07:49
Attributes force write

Variable header data:
Sweep interval: 0
*END*


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

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 34.24, 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.05
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: 322, 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: 324, 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: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 45
Average key length: 2.04, compression ratio: 0.53
Average prefix length: 1.02, 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: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.92, total dup: 0, max dup: 0
Average key length: 16.60, compression ratio: 0.92
Average prefix length: 1.34, average data length: 13.92
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: 320, 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: 332, Index root page: 333
Total formats: 1, used formats: 1
Average record length: 103.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: 996.00, compression ratio: 9.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 28%
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: 336, 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: 337, 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: 335, 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: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.16, total records: 1745670
Average version length: 47.86, total versions: 3423, 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: 12, data page slots: 19016
Data pages: 19016, average fill: 72%
Primary pages: 19016, secondary pages: 0, swept pages: 10998
Empty pages: 5, full pages: 15300
Fill distribution:
0 - 19% = 5
20 - 39% = 3
40 - 59% = 48
60 - 79% = 18958
80 - 99% = 2

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 9779, nodes: 1745670
Average node length: 19.87, total dup: 0, max dup: 0
Average key length: 16.92, compression ratio: 1.60
Average prefix length: 13.07, average data length: 13.93
Clustering factor: 472333, ratio: 0.27
Fill distribution:
0 - 19% = 543
20 - 39% = 3314
40 - 59% = 4758
60 - 79% = 531
80 - 99% = 633

Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 6349, nodes: 1745670
Average node length: 11.57, total dup: 0, max dup: 0
Average key length: 8.63, compression ratio: 1.04
Average prefix length: 3.37, average data length: 5.63
Clustering factor: 451239, ratio: 0.26
Fill distribution:
0 - 19% = 0
20 - 39% = 3477
40 - 59% = 2860
60 - 79% = 12
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 133829, depth: 3, leaf buckets: 3716, nodes: 1745670
Average node length: 7.11, total dup: 1199985, max dup: 49
Average key length: 4.17, compression ratio: 2.16
Average prefix length: 7.14, average data length: 1.86
Clustering factor: 435540, ratio: 0.25
Fill distribution:
0 - 19% = 117
20 - 39% = 1888
40 - 59% = 1433
60 - 79% = 61
80 - 99% = 217

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.42, total records: 597308
Average version length: 35.70, total versions: 1130, max versions: 3
Average fragment length: 15.80, total fragments: 5, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7584
Data pages: 7584, average fill: 75%
Primary pages: 7581, secondary pages: 3, swept pages: 6704
Empty pages: 6, full pages: 6773
Fill distribution:
0 - 19% = 9
20 - 39% = 1
40 - 59% = 18
60 - 79% = 7531
80 - 99% = 25

Index DOC_LIST_ID_DESC (1)
Root page: 205569, depth: 3, leaf buckets: 2264, nodes: 597308
Average node length: 11.74, total dup: 0, max dup: 0
Average key length: 8.89, compression ratio: 1.01
Average prefix length: 3.11, average data length: 5.89
Clustering factor: 164783, ratio: 0.28
Fill distribution:
0 - 19% = 0
20 - 39% = 1334
40 - 59% = 906
60 - 79% = 23
80 - 99% = 1

Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 705, nodes: 597308
Average node length: 4.87, total dup: 597258, max dup: 44627
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 280166, ratio: 0.47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 639
60 - 79% = 46
80 - 99% = 19

Index PK_DOC_LIST (0)
Root page: 225709, depth: 3, leaf buckets: 2108, nodes: 597308
Average node length: 11.74, total dup: 0, max dup: 0
Average key length: 8.88, compression ratio: 1.01
Average prefix length: 3.11, average data length: 5.89
Clustering factor: 164783, ratio: 0.28
Fill distribution:
0 - 19% = 152
20 - 39% = 1059
40 - 59% = 603
60 - 79% = 124
80 - 99% = 170

DOC_STATES (153)
Primary pointer page: 309, Index root page: 310
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: 318, 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: 319, 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: 317, 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: 338, Index root page: 339
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: 340, 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: 269, Index root page: 270
Total formats: 1, used formats: 1
Average record length: 63.05, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 16.51, total fragments: 365, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.65
Pointer pages: 2, data page slots: 544
Data pages: 44, average fill: 18%
Primary pages: 4, secondary pages: 40, swept pages: 4
Empty pages: 12, full pages: 3
Fill distribution:
0 - 19% = 33
20 - 39% = 7
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 52.10, total records: 1653
Average version length: 71.34, total versions: 444, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.84
Pointer pages: 2, data page slots: 1320
Data pages: 224, average fill: 11%
Primary pages: 224, secondary pages: 0, swept pages: 149
Empty pages: 54, full pages: 0
Fill distribution:
0 - 19% = 194
20 - 39% = 20
40 - 59% = 10
60 - 79% = 0
80 - 99% = 0

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 997, depth: 2, leaf buckets: 8, nodes: 1653
Average node length: 18.08, total dup: 1, max dup: 1
Average key length: 15.12, compression ratio: 1.79
Average prefix length: 14.87, average data length: 12.13
Clustering factor: 1262, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 1
60 - 79% = 1
80 - 99% = 1

MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 15.02, 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.13
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: 272, 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: 259, Index root page: 260
Total formats: 1, used formats: 1
Average record length: 14.52, total records: 113
Average version length: 44.97, total versions: 77, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 4.41
Pointer pages: 1, data page slots: 40
Data pages: 18, average fill: 7%
Primary pages: 18, secondary pages: 0, swept pages: 8
Empty pages: 13, full pages: 1
Fill distribution:
0 - 19% = 16
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 93869, depth: 2, leaf buckets: 1, nodes: 113
Average node length: 8.73, total dup: 73, max dup: 19
Average key length: 7.42, compression ratio: 2.56
Average prefix length: 13.93, average data length: 5.07
Clustering factor: 34, ratio: 0.30
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (164)
Primary pointer page: 352, Index root page: 353
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Root page: 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

Index MON_LOG_GDSCODE (2)
Root page: 361, 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: 360, 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: 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

Index PK_MON_LOG (0)
Root page: 359, 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 (165)
Primary pointer page: 364, Index root page: 365
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: 370, 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: 368, 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: 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_TABLE_STATS_TN_UNIT (3)
Root page: 369, 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: 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

OPTYPES (138)
Primary pointer page: 239, Index root page: 240
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: 242, 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: 241, 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: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.22, total records: 216248
Average version length: 32.00, total versions: 1331, max versions: 5
Average fragment length: 33.00, total fragments: 6, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.52
Pointer pages: 2, data page slots: 2496
Data pages: 2496, average fill: 64%
Primary pages: 2490, secondary pages: 6, swept pages: 1979
Empty pages: 11, full pages: 464
Fill distribution:
0 - 19% = 35
20 - 39% = 62
40 - 59% = 358
60 - 79% = 2040
80 - 99% = 1

Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 216, nodes: 216248
Average node length: 4.54, total dup: 216199, max dup: 10349
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 34461, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 25
40 - 59% = 116
60 - 79% = 63
80 - 99% = 12

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 252, nodes: 216248
Average node length: 5.49, total dup: 195185, max dup: 34
Average key length: 2.96, compression ratio: 7.43
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 43291, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 33
40 - 59% = 111
60 - 79% = 78
80 - 99% = 29

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 251, nodes: 216248
Average node length: 5.49, total dup: 195185, max dup: 34
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 43315, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 31
40 - 59% = 105
60 - 79% = 89
80 - 99% = 25

Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 251, nodes: 216248
Average node length: 5.28, total dup: 195185, max dup: 34
Average key length: 2.75, compression ratio: 3.28
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 43318, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 35
40 - 59% = 116
60 - 79% = 83
80 - 99% = 17

PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.99, total records: 256283
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: 2192
Data pages: 2192, average fill: 64%
Primary pages: 2192, secondary pages: 0, swept pages: 0
Empty pages: 1, full pages: 2190
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2190
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 3680, depth: 2, leaf buckets: 202, nodes: 256283
Average node length: 4.50, total dup: 256092, max dup: 3175
Average key length: 2.00, compression ratio: 1.30
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 38464, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 54
60 - 79% = 93
80 - 99% = 54

PERF_ISQL_STAT (161)
Primary pointer page: 344, Index root page: 345
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: 346, 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 (162)
Primary pointer page: 348, Index root page: 349
Total formats: 2, used formats: 2
Average record length: 148.41, total records: 10729375
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: 1442.13, compression ratio: 9.72
Pointer pages: 154, data page slots: 250416
Data pages: 250416, average fill: 87%
Primary pages: 250416, secondary pages: 0, swept pages: 3
Empty pages: 4, full pages: 250411
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 250411

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 11378, nodes: 10729375
Average node length: 5.66, total dup: 9371521, max dup: 125
Average key length: 2.23, compression ratio: 3.59
Average prefix length: 7.81, average data length: 0.18
Clustering factor: 4720640, ratio: 0.44
Fill distribution:
0 - 19% = 14
20 - 39% = 0
40 - 59% = 4985
60 - 79% = 4075
80 - 99% = 2304

Index PERF_LOG_GDSCODE (3)
Root page: 128964, depth: 3, leaf buckets: 11861, nodes: 10729375
Average node length: 4.49, total dup: 10729370, max dup: 10160697
Average key length: 1.05, compression ratio: 0.25
Average prefix length: 0.26, average data length: 0.00
Clustering factor: 320540, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 11833
60 - 79% = 2
80 - 99% = 24

Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 12462, nodes: 10729375
Average node length: 5.65, total dup: 10427008, max dup: 20975
Average key length: 2.21, compression ratio: 4.07
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 1470285, ratio: 0.14
Fill distribution:
0 - 19% = 6
20 - 39% = 4
40 - 59% = 8252
60 - 79% = 2294
80 - 99% = 1906

Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 13123, nodes: 10729375
Average node length: 5.53, total dup: 10674360, max dup: 1475699
Average key length: 2.10, compression ratio: 18.00
Average prefix length: 37.68, average data length: 0.09
Clustering factor: 6408733, ratio: 0.60
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 11006
60 - 79% = 697
80 - 99% = 1407

PHRASES (145)
Primary pointer page: 265, Index root page: 266
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: 279, 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: 278, 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: 277, 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: 276, 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: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.96, total records: 329914
Average version length: 55.90, total versions: 1080, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 3, data page slots: 3952
Data pages: 3952, average fill: 74%
Primary pages: 3952, secondary pages: 0, swept pages: 2687
Empty pages: 7, full pages: 3562
Fill distribution:
0 - 19% = 12
20 - 39% = 5
40 - 59% = 37
60 - 79% = 3893
80 - 99% = 5

Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 423, nodes: 329914
Average node length: 5.82, total dup: 280537, max dup: 750
Average key length: 3.11, compression ratio: 2.89
Average prefix length: 8.04, average data length: 0.96
Clustering factor: 36425, ratio: 0.11
Fill distribution:
0 - 19% = 7
20 - 39% = 28
40 - 59% = 252
60 - 79% = 92
80 - 99% = 44

Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 354, nodes: 329914
Average node length: 5.54, total dup: 293914, max dup: 345
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 69592, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 160
60 - 79% = 138
80 - 99% = 53

RULES_FOR_PDISTR (152)
Primary pointer page: 303, Index root page: 304
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: 308, 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: 243, Index root page: 244
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: 246, 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: 245, 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: 315, Index root page: 316
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: 327, 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: 328, 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: 236, Index root page: 237
Total formats: 1, used formats: 1
Average record length: 97.49, 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.82
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: 238, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.07, total dup: 0, max dup: 0
Average key length: 26.06, compression ratio: 1.70
Average prefix length: 21.23, average data length: 23.07
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: 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$AUTOGEN$SOURCE (135)
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$DEP_DOCS (129)
Primary pointer page: 198, Index root page: 199
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: 200, 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: 207, Index root page: 224
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: 226, 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: 227, Index root page: 228
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: 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$PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 2, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 358, 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: 205, Index root page: 206
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: 201, Index root page: 202
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: 204, 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: 203, 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: 193, Index root page: 194
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: 197, 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 (276)
Primary pointer page: 557, Index root page: 68921
Total formats: 1, used formats: 1
Average record length: 53.88, total records: 6214
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: 136.00, compression ratio: 2.52
Pointer pages: 1, data page slots: 80
Data pages: 80, average fill: 67%
Primary pages: 80, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 72
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 0
60 - 79% = 72
80 - 99% = 0

WARES (144)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 77.53, 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.78
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: 374, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 64
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 48, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Root page: 273, 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: 328, ratio: 0.82
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

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

Index WARES_NUMB_UNQ (1)
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400
Average node length: 52.95, total dup: 0, max dup: 0
Average key length: 51.92, compression ratio: 0.99
Average prefix length: 2.65, average data length: 48.95
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2

WARE_GROUPS (155)
Primary pointer page: 313, Index root page: 314
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: 325, 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: 326, 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 (259)
Primary pointer page: 254, Index root page: 284
Total formats: 1, used formats: 1
Average record length: 57.01, total records: 2355
Average version length: 72.12, total versions: 496, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.39
Pointer pages: 2, data page slots: 1256
Data pages: 152, average fill: 18%
Primary pages: 152, secondary pages: 0, swept pages: 133
Empty pages: 75, full pages: 14
Fill distribution:
0 - 19% = 107
20 - 39% = 15
40 - 59% = 11
60 - 79% = 15
80 - 99% = 4

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1235, depth: 2, leaf buckets: 6, nodes: 2355
Average node length: 7.37, total dup: 2043, max dup: 14
Average key length: 5.36, compression ratio: 6.90
Average prefix length: 33.77, average data length: 3.23
Clustering factor: 348, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

XQD_1000_3300 (261)
Primary pointer page: 708, Index root page: 709
Total formats: 1, used formats: 1
Average record length: 71.62, total records: 979075
Average version length: 71.61, total versions: 7636, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 10, data page slots: 15320
Data pages: 15320, average fill: 71%
Primary pages: 15320, secondary pages: 0, swept pages: 9856
Empty pages: 16, full pages: 9021
Fill distribution:
0 - 19% = 71
20 - 39% = 238
40 - 59% = 1522
60 - 79% = 13463
80 - 99% = 26

Index XQD_1000_3300_DOC (1)
Root page: 313738, depth: 3, leaf buckets: 1072, nodes: 979075
Average node length: 5.12, total dup: 953464, max dup: 123
Average key length: 2.20, compression ratio: 4.10
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 140926, ratio: 0.14
Fill distribution:
0 - 19% = 20
20 - 39% = 83
40 - 59% = 711
60 - 79% = 27
80 - 99% = 231

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 120867, depth: 3, leaf buckets: 1490, nodes: 979075
Average node length: 6.24, total dup: 855475, max dup: 24
Average key length: 3.32, compression ratio: 11.15
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 217942, ratio: 0.22
Fill distribution:
0 - 19% = 38
20 - 39% = 167
40 - 59% = 1014
60 - 79% = 148
80 - 99% = 123

XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 36.99, total records: 15155
Average version length: 72.01, total versions: 7393, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.68
Pointer pages: 4, data page slots: 2816
Data pages: 1416, average fill: 14%
Primary pages: 1415, secondary pages: 1, swept pages: 911
Empty pages: 581, full pages: 55
Fill distribution:
0 - 19% = 1042
20 - 39% = 238
40 - 59% = 66
60 - 79% = 38
80 - 99% = 32

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 523356, depth: 3, leaf buckets: 34, nodes: 15155
Average node length: 6.93, total dup: 13037, max dup: 42
Average key length: 4.04, compression ratio: 9.16
Average prefix length: 35.10, average data length: 1.90
Clustering factor: 2180, ratio: 0.14
Fill distribution:
0 - 19% = 2
20 - 39% = 17
40 - 59% = 12
60 - 79% = 3
80 - 99% = 0

XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 69.64, total records: 1487946
Average version length: 71.86, total versions: 52465, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.95
Pointer pages: 15, data page slots: 24016
Data pages: 23952, average fill: 69%
Primary pages: 23952, secondary pages: 0, swept pages: 14625
Empty pages: 84, full pages: 13312
Fill distribution:
0 - 19% = 253
20 - 39% = 853
40 - 59% = 3316
60 - 79% = 18770
80 - 99% = 760

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 107768, depth: 3, leaf buckets: 2351, nodes: 1487946
Average node length: 5.59, total dup: 1401031, max dup: 77
Average key length: 2.64, compression ratio: 14.01
Average prefix length: 36.42, average data length: 0.58
Clustering factor: 270003, ratio: 0.18
Fill distribution:
0 - 19% = 17
20 - 39% = 1146
40 - 59% = 795
60 - 79% = 219
80 - 99% = 174

XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 8.62, total records: 1445
Average version length: 70.42, total versions: 1271, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.78
Pointer pages: 2, data page slots: 1824
Data pages: 433, average fill: 5%
Primary pages: 433, secondary pages: 0, swept pages: 263
Empty pages: 297, full pages: 9
Fill distribution:
0 - 19% = 407
20 - 39% = 14
40 - 59% = 3
60 - 79% = 6
80 - 99% = 3

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1530, depth: 2, leaf buckets: 6, nodes: 1445
Average node length: 10.02, total dup: 1138, max dup: 31
Average key length: 7.10, compression ratio: 5.21
Average prefix length: 32.11, average data length: 4.89
Clustering factor: 258, ratio: 0.18
Fill distribution:
0 - 19% = 0
20 - 39% = 5
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 70.95, total records: 2255783
Average version length: 71.44, total versions: 16486, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.92
Pointer pages: 21, data page slots: 32656
Data pages: 32656, average fill: 75%
Primary pages: 32656, secondary pages: 0, swept pages: 24367
Empty pages: 6, full pages: 27018
Fill distribution:
0 - 19% = 17
20 - 39% = 54
40 - 59% = 601
60 - 79% = 31694
80 - 99% = 290

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4930, nodes: 2255783
Average node length: 6.98, total dup: 1797312, max dup: 18
Average key length: 4.02, compression ratio: 9.21
Average prefix length: 35.19, average data length: 1.81
Clustering factor: 501324, ratio: 0.22
Fill distribution:
0 - 19% = 2
20 - 39% = 2935
40 - 59% = 1585
60 - 79% = 239
80 - 99% = 169

XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 83.79, total records: 3804429
Average version length: 83.36, total versions: 3584, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 36, data page slots: 58752
Data pages: 58752, average fill: 80%
Primary pages: 58752, secondary pages: 0, swept pages: 25539
Empty pages: 10, full pages: 58128
Fill distribution:
0 - 19% = 10
20 - 39% = 6
40 - 59% = 35
60 - 79% = 21386
80 - 99% = 37315

Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3960, nodes: 3804429
Average node length: 5.15, total dup: 3717724, max dup: 127
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 645581, ratio: 0.17
Fill distribution:
0 - 19% = 12
20 - 39% = 60
40 - 59% = 1737
60 - 79% = 1895
80 - 99% = 256

Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 4930, nodes: 3804429
Average node length: 5.70, total dup: 3398490, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 249885, ratio: 0.07
Fill distribution:
0 - 19% = 49
20 - 39% = 320
40 - 59% = 3658
60 - 79% = 157
80 - 99% = 746

Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 4350, nodes: 3804429
Average node length: 5.79, total dup: 3329066, max dup: 29
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 689614, ratio: 0.18
Fill distribution:
0 - 19% = 8
20 - 39% = 67
40 - 59% = 1747
60 - 79% = 2143
80 - 99% = 385

XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 82.88, total records: 1899638
Average version length: 83.34, total versions: 13667, 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: 19, data page slots: 30264
Data pages: 30264, average fill: 78%
Primary pages: 30264, secondary pages: 0, swept pages: 22401
Empty pages: 18, full pages: 26550
Fill distribution:
0 - 19% = 34
20 - 39% = 77
40 - 59% = 580
60 - 79% = 15482
80 - 99% = 14091

Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1990, nodes: 1899638
Average node length: 5.14, total dup: 1854911, max dup: 203
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 393631, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 38
40 - 59% = 1070
60 - 79% = 626
80 - 99% = 256

Index XQS_1000_3300_RCV_ID (2)
Root page: 87961, depth: 3, leaf buckets: 3482, nodes: 1899638
Average node length: 6.35, total dup: 1525104, max dup: 14
Average key length: 3.38, compression ratio: 2.66
Average prefix length: 7.81, average data length: 1.19
Clustering factor: 261158, ratio: 0.14
Fill distribution:
0 - 19% = 87
20 - 39% = 1639
40 - 59% = 1289
60 - 79% = 293
80 - 99% = 174

Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 2250, nodes: 1899638
Average node length: 5.79, total dup: 1662339, max dup: 33
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 433524, ratio: 0.23
Fill distribution:
0 - 19% = 4
20 - 39% = 46
40 - 59% = 1228
60 - 79% = 703
80 - 99% = 269

XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.47, total records: 4083889
Average version length: 84.37, total versions: 27697, 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: 40, data page slots: 64808
Data pages: 64808, average fill: 78%
Primary pages: 64808, secondary pages: 0, swept pages: 28712
Empty pages: 170, full pages: 58496
Fill distribution:
0 - 19% = 235
20 - 39% = 303
40 - 59% = 1439
60 - 79% = 24066
80 - 99% = 38765

Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4518, nodes: 4083889
Average node length: 5.04, total dup: 4060162, max dup: 680
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 800460, ratio: 0.20
Fill distribution:
0 - 19% = 6
20 - 39% = 419
40 - 59% = 2516
60 - 79% = 1252
80 - 99% = 325

Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 5599, nodes: 4083889
Average node length: 5.48, total dup: 3788025, max dup: 49
Average key length: 2.49, compression ratio: 3.61
Average prefix length: 8.58, average data length: 0.42
Clustering factor: 383340, ratio: 0.09
Fill distribution:
0 - 19% = 72
20 - 39% = 1900
40 - 59% = 2500
60 - 79% = 518
80 - 99% = 609

Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 5006, nodes: 4083889
Average node length: 5.68, total dup: 3658701, max dup: 87
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 848246, ratio: 0.21
Fill distribution:
0 - 19% = 4
20 - 39% = 357
40 - 59% = 2791
60 - 79% = 1442
80 - 99% = 412

XQS_2000_3300 (268)
Primary pointer page: 757, Index root page: 758
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: 760, 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: 762, 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: 761, 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 (269)
Primary pointer page: 763, Index root page: 764
Total formats: 1, used formats: 1
Average record length: 83.39, total records: 2634798
Average version length: 83.91, total versions: 14261, 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: 26, data page slots: 42048
Data pages: 42048, average fill: 78%
Primary pages: 42048, secondary pages: 0, swept pages: 30719
Empty pages: 24, full pages: 36839
Fill distribution:
0 - 19% = 37
20 - 39% = 74
40 - 59% = 702
60 - 79% = 21627
80 - 99% = 19608

Index XQS_2100_3300_DOC_ID (0)
Root page: 94004, depth: 3, leaf buckets: 2950, nodes: 2634798
Average node length: 5.02, total dup: 2622528, max dup: 1226
Average key length: 2.04, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 522807, ratio: 0.20
Fill distribution:
0 - 19% = 23
20 - 39% = 400
40 - 59% = 1563
60 - 79% = 657
80 - 99% = 307

Index XQS_2100_3300_RCV_ID (2)
Root page: 96796, depth: 3, leaf buckets: 4993, nodes: 2634798
Average node length: 6.35, total dup: 2117283, max dup: 14
Average key length: 3.38, compression ratio: 2.67
Average prefix length: 7.82, average data length: 1.18
Clustering factor: 416861, ratio: 0.16
Fill distribution:
0 - 19% = 205
20 - 39% = 2456
40 - 59% = 1714
60 - 79% = 360
80 - 99% = 258

Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 3199, nodes: 2634798
Average node length: 5.53, total dup: 2422971, max dup: 93
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 563890, ratio: 0.21
Fill distribution:
0 - 19% = 16
20 - 39% = 450
40 - 59% = 1576
60 - 79% = 821
80 - 99% = 336

XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 68.66, total records: 384824
Average version length: 69.14, total versions: 3584, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.98
Pointer pages: 4, data page slots: 5328
Data pages: 5328, average fill: 77%
Primary pages: 5328, secondary pages: 0, swept pages: 4047
Empty pages: 6, full pages: 5005
Fill distribution:
0 - 19% = 6
20 - 39% = 5
40 - 59% = 32
60 - 79% = 5211
80 - 99% = 74

Index XQS_3300_3400_DOC_ID (0)
Root page: 2703, depth: 2, leaf buckets: 478, nodes: 384824
Average node length: 5.40, total dup: 354523, max dup: 115
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 41088, ratio: 0.11
Fill distribution:
0 - 19% = 2
20 - 39% = 89
40 - 59% = 238
60 - 79% = 113
80 - 99% = 36

Index XQS_3300_3400_SND_ID (1)
Root page: 592499, depth: 3, leaf buckets: 524, nodes: 384824
Average node length: 5.94, total dup: 324469, max dup: 29
Average key length: 3.15, compression ratio: 2.86
Average prefix length: 8.01, average data length: 0.99
Clustering factor: 46591, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 110
40 - 59% = 242
60 - 79% = 133
80 - 99% = 39

ZDOC_DATA (229)
Primary pointer page: 632, Index root page: 633
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 (228)
Primary pointer page: 630, Index root page: 631
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 (230)
Primary pointer page: 634, Index root page: 635
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 (233)
Primary pointer page: 640, Index root page: 641
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: 650, 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 (234)
Primary pointer page: 642, Index root page: 643
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: 651, 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 (231)
Primary pointer page: 636, Index root page: 637
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: 644, 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: 645, 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 (232)
Primary pointer page: 638, Index root page: 639
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: 647, 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: 646, 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: 649, 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: 648, 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 (227)
Primary pointer page: 628, Index root page: 629
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 (226)
Primary pointer page: 625, Index root page: 626
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: 267, Index root page: 268
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: 280, 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 30720 ms, from 17:00:45.50 to 17:01:16.22.

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 1745670 3423 0.1960
DOC_LIST 597308 1130 0.1891
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 1653 444 26.8602
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 113 77 68.1415
OPTYPES 9 0 0.0000
PDISTR 216248 1331 0.6154
PERF_ESTIMATED 256283 0 0.0000
PERF_LOG 10729375 0 0.0000
PSTORNED 329914 1080 0.3273
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 6214 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 2355 496 21.0615
XQD_1000_3300 979075 7636 0.7799
XQD_1200_2000 15155 7393 48.7825
XQD_2000_3300 1487946 52465 3.5260
XQD_2100_3300 1445 1271 87.9584
XQD_3300_3400 2255783 16486 0.7308
XQS_1000_1200 3804429 3584 0.0942
XQS_1000_3300 1899638 13667 0.7194
XQS_1200_2000 4083889 27697 0.6782
XQS_2100_3300 2634798 14261 0.5412
XQS_3300_3400 384824 3584 0.9313
Z_USED_VIEWS 29 0 0.0000
Done for 1830 ms, from 17:01:26.56 to 17:01:28.39.

Database validation

17:01:28.50 Validation started

17:01:28.52 Relation 140 (DOC_LIST)
17:01:28.52 process pointer page 0 of 5
17:01:28.63 process pointer page 1 of 5
17:01:28.72 process pointer page 2 of 5
17:01:28.80 process pointer page 3 of 5
17:01:28.85 process pointer page 4 of 5
17:01:28.86 Index 1 (PK_DOC_LIST)
17:01:28.97 Index 2 (DOC_LIST_ID_DESC)
17:01:29.11 Index 3 (FK_DOC_LIST_AGENTS)
17:01:29.33 Relation 140 (DOC_LIST) is ok

17:01:29.33 Relation 141 (DOC_DATA)
17:01:29.33 process pointer page 0 of 12
17:01:29.38 process pointer page 1 of 12
17:01:29.41 process pointer page 2 of 12
17:01:29.49 process pointer page 3 of 12
17:01:29.52 process pointer page 4 of 12
17:01:29.58 process pointer page 5 of 12
17:01:29.64 process pointer page 6 of 12
17:01:29.70 process pointer page 7 of 12
17:01:29.74 process pointer page 8 of 12
17:01:29.78 process pointer page 9 of 12
17:01:29.81 process pointer page 10 of 12
17:01:29.86 process pointer page 11 of 12
17:01:29.88 Index 2 (DOC_DATA_DOC_WARE_UNQ)
17:01:30.47 Index 3 (DOC_DATA_ID_DESC)
17:01:30.91 Index 4 (FK_DOC_DATA_DOC_LIST)
17:01:31.14 Relation 141 (DOC_DATA) is ok

17:01:31.14 Relation 147 (INVNT_SALDO)
17:01:31.14 process pointer page 0 of 2
17:01:31.14 process pointer page 1 of 2
17:01:31.14 Index 1 (PK_INVNT_SALDO)
17:01:31.14 Relation 147 (INVNT_SALDO) is ok

17:01:31.14 Relation 150 (PDISTR)
17:01:31.14 process pointer page 0 of 2
17:01:31.17 process pointer page 1 of 2
17:01:31.22 Index 2 (PDISTR_SND_ID)
17:01:31.28 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
17:01:31.33 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
17:01:31.36 Index 5 (PDISTR_AGENT_ID)
17:01:31.39 Relation 150 (PDISTR) is ok

17:01:31.39 Relation 151 (PSTORNED)
17:01:31.39 process pointer page 0 of 3
17:01:31.42 process pointer page 1 of 3
17:01:31.47 process pointer page 2 of 3
17:01:31.48 Index 2 (PSTORNED_SND_ID)
17:01:31.51 Index 3 (PSTORNED_RCV_ID)
17:01:31.54 Relation 151 (PSTORNED) is ok

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

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

17:01:31.54 Relation 160 (PERF_ESTIMATED)
17:01:31.54 process pointer page 0 of 2
17:01:31.58 process pointer page 1 of 2
17:01:31.59 Index 1 (PERF_EST_MINUTE_SINCE_START)
17:01:31.62 Relation 160 (PERF_ESTIMATED) is ok

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

17:01:31.62 Relation 162 (PERF_LOG)
17:01:31.62 process pointer page 0 of 154
17:01:31.64 process pointer page 1 of 154
17:01:31.67 process pointer page 2 of 154
17:01:31.70 process pointer page 3 of 154
17:01:31.72 process pointer page 4 of 154
17:01:31.75 process pointer page 5 of 154
17:01:31.76 process pointer page 6 of 154
17:01:31.78 process pointer page 7 of 154
17:01:31.81 process pointer page 8 of 154
17:01:31.83 process pointer page 9 of 154
17:01:31.86 process pointer page 10 of 154
17:01:31.87 process pointer page 11 of 154
17:01:31.89 process pointer page 12 of 154
17:01:31.92 process pointer page 13 of 154
17:01:31.93 process pointer page 14 of 154
17:01:31.97 process pointer page 15 of 154
17:01:31.98 process pointer page 16 of 154
17:01:32.00 process pointer page 17 of 154
17:01:32.03 process pointer page 18 of 154
17:01:32.04 process pointer page 19 of 154
17:01:32.08 process pointer page 20 of 154
17:01:32.09 process pointer page 21 of 154
17:01:32.11 process pointer page 22 of 154
17:01:32.14 process pointer page 23 of 154
17:01:32.15 process pointer page 24 of 154
17:01:32.17 process pointer page 25 of 154
17:01:32.20 process pointer page 26 of 154
17:01:32.22 process pointer page 27 of 154
17:01:32.23 process pointer page 28 of 154
17:01:32.26 process pointer page 29 of 154
17:01:32.29 process pointer page 30 of 154
17:01:32.31 process pointer page 31 of 154
17:01:32.37 process pointer page 32 of 154
17:01:32.43 process pointer page 33 of 154
17:01:32.51 process pointer page 34 of 154
17:01:32.59 process pointer page 35 of 154
17:01:32.67 process pointer page 36 of 154
17:01:32.70 process pointer page 37 of 154
17:01:32.73 process pointer page 38 of 154
17:01:32.76 process pointer page 39 of 154
17:01:32.79 process pointer page 40 of 154
17:01:32.82 process pointer page 41 of 154
17:01:32.87 process pointer page 42 of 154
17:01:32.93 process pointer page 43 of 154
17:01:32.96 process pointer page 44 of 154
17:01:33.00 process pointer page 45 of 154
17:01:33.03 process pointer page 46 of 154
17:01:33.06 process pointer page 47 of 154
17:01:33.09 process pointer page 48 of 154
17:01:33.15 process pointer page 49 of 154
17:01:33.23 process pointer page 50 of 154
17:01:33.26 process pointer page 51 of 154
17:01:33.31 process pointer page 52 of 154
17:01:33.35 process pointer page 53 of 154
17:01:33.39 process pointer page 54 of 154
17:01:33.46 process pointer page 55 of 154
17:01:33.54 process pointer page 56 of 154
17:01:33.62 process pointer page 57 of 154
17:01:33.65 process pointer page 58 of 154
17:01:33.68 process pointer page 59 of 154
17:01:33.71 process pointer page 60 of 154
17:01:33.74 process pointer page 61 of 154
17:01:33.78 process pointer page 62 of 154
17:01:33.79 process pointer page 63 of 154
17:01:33.82 process pointer page 64 of 154
17:01:33.88 process pointer page 65 of 154
17:01:33.92 process pointer page 66 of 154
17:01:33.93 process pointer page 67 of 154
17:01:33.96 process pointer page 68 of 154
17:01:34.04 process pointer page 69 of 154
17:01:34.12 process pointer page 70 of 154
17:01:34.18 process pointer page 71 of 154
17:01:34.21 process pointer page 72 of 154
17:01:34.24 process pointer page 73 of 154
17:01:34.27 process pointer page 74 of 154
17:01:34.32 process pointer page 75 of 154
17:01:34.38 process pointer page 76 of 154
17:01:34.42 process pointer page 77 of 154
17:01:34.45 process pointer page 78 of 154
17:01:34.48 process pointer page 79 of 154
17:01:34.57 process pointer page 80 of 154
17:01:34.60 process pointer page 81 of 154
17:01:34.63 process pointer page 82 of 154
17:01:34.66 process pointer page 83 of 154
17:01:34.70 process pointer page 84 of 154
17:01:34.73 process pointer page 85 of 154
17:01:34.74 process pointer page 86 of 154
17:01:34.77 process pointer page 87 of 154
17:01:34.81 process pointer page 88 of 154
17:01:34.82 process pointer page 89 of 154
17:01:34.85 process pointer page 90 of 154
17:01:34.88 process pointer page 91 of 154
17:01:34.90 process pointer page 92 of 154
17:01:34.91 process pointer page 93 of 154
17:01:34.95 process pointer page 94 of 154
17:01:34.96 process pointer page 95 of 154
17:01:34.99 process pointer page 96 of 154
17:01:35.01 process pointer page 97 of 154
17:01:35.02 process pointer page 98 of 154
17:01:35.05 process pointer page 99 of 154
17:01:35.09 process pointer page 100 of 154
17:01:35.10 process pointer page 101 of 154
17:01:35.13 process pointer page 102 of 154
17:01:35.16 process pointer page 103 of 154
17:01:35.23 process pointer page 104 of 154
17:01:35.26 process pointer page 105 of 154
17:01:35.29 process pointer page 106 of 154
17:01:35.32 process pointer page 107 of 154
17:01:35.35 process pointer page 108 of 154
17:01:35.37 process pointer page 109 of 154
17:01:35.40 process pointer page 110 of 154
17:01:35.43 process pointer page 111 of 154
17:01:35.44 process pointer page 112 of 154
17:01:35.49 process pointer page 113 of 154
17:01:35.55 process pointer page 114 of 154
17:01:35.60 process pointer page 115 of 154
17:01:35.63 process pointer page 116 of 154
17:01:35.66 process pointer page 117 of 154
17:01:35.71 process pointer page 118 of 154
17:01:35.79 process pointer page 119 of 154
17:01:35.82 process pointer page 120 of 154
17:01:35.85 process pointer page 121 of 154
17:01:35.88 process pointer page 122 of 154
17:01:35.96 process pointer page 123 of 154
17:01:36.02 process pointer page 124 of 154
17:01:36.10 process pointer page 125 of 154
17:01:36.18 process pointer page 126 of 154
17:01:36.21 process pointer page 127 of 154
17:01:36.24 process pointer page 128 of 154
17:01:36.27 process pointer page 129 of 154
17:01:36.30 process pointer page 130 of 154
17:01:36.33 process pointer page 131 of 154
17:01:36.41 process pointer page 132 of 154
17:01:36.44 process pointer page 133 of 154
17:01:36.47 process pointer page 134 of 154
17:01:36.54 process pointer page 135 of 154
17:01:36.61 process pointer page 136 of 154
17:01:36.65 process pointer page 137 of 154
17:01:36.68 process pointer page 138 of 154
17:01:36.71 process pointer page 139 of 154
17:01:36.76 process pointer page 140 of 154
17:01:36.82 process pointer page 141 of 154
17:01:36.90 process pointer page 142 of 154
17:01:36.94 process pointer page 143 of 154
17:01:36.97 process pointer page 144 of 154
17:01:37.00 process pointer page 145 of 154
17:01:37.04 process pointer page 146 of 154
17:01:37.05 process pointer page 147 of 154
17:01:37.11 process pointer page 148 of 154
17:01:37.19 process pointer page 149 of 154
17:01:37.24 process pointer page 150 of 154
17:01:37.27 process pointer page 151 of 154
17:01:37.30 process pointer page 152 of 154
17:01:37.35 process pointer page 153 of 154
17:01:37.38 Index 1 (PERF_LOG_DTS_BEG_DESC)
17:01:39.55 Index 2 (PERF_LOG_UNIT)
17:01:42.12 Index 3 (PERF_LOG_TRN_DESC)
17:01:43.62 Index 4 (PERF_LOG_GDSCODE)
17:01:44.90 Relation 162 (PERF_LOG) is ok

17:01:44.90 Relation 166 (V_STOPTEST)
17:01:44.90 Relation 166 (V_STOPTEST) is ok

17:01:44.90 Relation 183 (V_QDISTR_SOURCE)
17:01:44.90 Relation 183 (V_QDISTR_SOURCE) is ok

17:01:44.90 Relation 184 (V_QSTORNED_SOURCE)
17:01:44.90 Relation 184 (V_QSTORNED_SOURCE) is ok

17:01:44.90 Relation 259 (XQD_1000_1200)
17:01:44.90 process pointer page 0 of 2
17:01:44.91 process pointer page 1 of 2
17:01:44.91 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
17:01:44.91 Relation 259 (XQD_1000_1200) is ok

17:01:44.91 Relation 260 (XQD_1200_2000)
17:01:44.91 process pointer page 0 of 4
17:01:44.91 process pointer page 1 of 4
17:01:44.93 process pointer page 2 of 4
17:01:44.93 process pointer page 3 of 4
17:01:44.93 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
17:01:44.95 Relation 260 (XQD_1200_2000) is ok

17:01:44.95 Relation 261 (XQD_1000_3300)
17:01:44.95 process pointer page 0 of 10
17:01:44.98 process pointer page 1 of 10
17:01:45.02 process pointer page 2 of 10
17:01:45.05 process pointer page 3 of 10
17:01:45.09 process pointer page 4 of 10
17:01:45.12 process pointer page 5 of 10
17:01:45.15 process pointer page 6 of 10
17:01:45.18 process pointer page 7 of 10
17:01:45.21 process pointer page 8 of 10
17:01:45.24 process pointer page 9 of 10
17:01:45.26 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
17:01:45.57 Index 2 (XQD_1000_3300_DOC)
17:01:45.69 Relation 261 (XQD_1000_3300) is ok

17:01:45.69 Relation 262 (XQD_2000_3300)
17:01:45.69 process pointer page 0 of 15
17:01:45.74 process pointer page 1 of 15
17:01:45.77 process pointer page 2 of 15
17:01:45.85 process pointer page 3 of 15
17:01:45.94 process pointer page 4 of 15
17:01:46.04 process pointer page 5 of 15
17:01:46.07 process pointer page 6 of 15
17:01:46.12 process pointer page 7 of 15
17:01:46.16 process pointer page 8 of 15
17:01:46.19 process pointer page 9 of 15
17:01:46.22 process pointer page 10 of 15
17:01:46.27 process pointer page 11 of 15
17:01:46.30 process pointer page 12 of 15
17:01:46.33 process pointer page 13 of 15
17:01:46.36 process pointer page 14 of 15
17:01:46.40 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
17:01:46.55 Relation 262 (XQD_2000_3300) is ok

17:01:46.55 Relation 263 (XQD_2100_3300)
17:01:46.55 process pointer page 0 of 2
17:01:46.55 process pointer page 1 of 2
17:01:46.55 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
17:01:46.55 Relation 263 (XQD_2100_3300) is ok

17:01:46.55 Relation 264 (XQD_3300_3400)
17:01:46.55 process pointer page 0 of 21
17:01:46.58 process pointer page 1 of 21
17:01:46.61 process pointer page 2 of 21
17:01:46.65 process pointer page 3 of 21
17:01:46.68 process pointer page 4 of 21
17:01:46.71 process pointer page 5 of 21
17:01:46.74 process pointer page 6 of 21
17:01:46.75 process pointer page 7 of 21
17:01:46.79 process pointer page 8 of 21
17:01:46.82 process pointer page 9 of 21
17:01:46.85 process pointer page 10 of 21
17:01:46.94 process pointer page 11 of 21
17:01:47.04 process pointer page 12 of 21
17:01:47.07 process pointer page 13 of 21
17:01:47.11 process pointer page 14 of 21
17:01:47.19 process pointer page 15 of 21
17:01:47.25 process pointer page 16 of 21
17:01:47.30 process pointer page 17 of 21
17:01:47.33 process pointer page 18 of 21
17:01:47.38 process pointer page 19 of 21
17:01:47.41 process pointer page 20 of 21
17:01:47.41 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
17:01:47.94 Relation 264 (XQD_3300_3400) is ok

17:01:47.94 Relation 265 (XQS_1000_1200)
17:01:47.94 process pointer page 0 of 36
17:01:47.97 process pointer page 1 of 36
17:01:48.02 process pointer page 2 of 36
17:01:48.07 process pointer page 3 of 36
17:01:48.10 process pointer page 4 of 36
17:01:48.13 process pointer page 5 of 36
17:01:48.16 process pointer page 6 of 36
17:01:48.19 process pointer page 7 of 36
17:01:48.24 process pointer page 8 of 36
17:01:48.25 process pointer page 9 of 36
17:01:48.31 process pointer page 10 of 36
17:01:48.41 process pointer page 11 of 36
17:01:48.52 process pointer page 12 of 36
17:01:48.61 process pointer page 13 of 36
17:01:48.69 process pointer page 14 of 36
17:01:48.74 process pointer page 15 of 36
17:01:48.80 process pointer page 16 of 36
17:01:48.85 process pointer page 17 of 36
17:01:48.89 process pointer page 18 of 36
17:01:48.99 process pointer page 19 of 36
17:01:49.02 process pointer page 20 of 36
17:01:49.05 process pointer page 21 of 36
17:01:49.09 process pointer page 22 of 36
17:01:49.13 process pointer page 23 of 36
17:01:49.17 process pointer page 24 of 36
17:01:49.20 process pointer page 25 of 36
17:01:49.24 process pointer page 26 of 36
17:01:49.27 process pointer page 27 of 36
17:01:49.31 process pointer page 28 of 36
17:01:49.33 process pointer page 29 of 36
17:01:49.36 process pointer page 30 of 36
17:01:49.39 process pointer page 31 of 36
17:01:49.42 process pointer page 32 of 36
17:01:49.45 process pointer page 33 of 36
17:01:49.53 process pointer page 34 of 36
17:01:49.59 process pointer page 35 of 36
17:01:49.63 Index 1 (XQS_1000_1200_DOC_ID)
17:01:50.14 Index 2 (XQS_1000_1200_SND_ID)
17:01:50.72 Index 3 (XQS_1000_1200_RCV_ID)
17:01:51.17 Relation 265 (XQS_1000_1200) is ok

17:01:51.17 Relation 266 (XQS_1200_2000)
17:01:51.17 process pointer page 0 of 40
17:01:51.22 process pointer page 1 of 40
17:01:51.25 process pointer page 2 of 40
17:01:51.29 process pointer page 3 of 40
17:01:51.33 process pointer page 4 of 40
17:01:51.36 process pointer page 5 of 40
17:01:51.39 process pointer page 6 of 40
17:01:51.50 process pointer page 7 of 40
17:01:51.54 process pointer page 8 of 40
17:01:51.59 process pointer page 9 of 40
17:01:51.62 process pointer page 10 of 40
17:01:51.72 process pointer page 11 of 40
17:01:51.81 process pointer page 12 of 40
17:01:51.92 process pointer page 13 of 40
17:01:51.97 process pointer page 14 of 40
17:01:52.00 process pointer page 15 of 40
17:01:52.04 process pointer page 16 of 40
17:01:52.07 process pointer page 17 of 40
17:01:52.12 process pointer page 18 of 40
17:01:52.20 process pointer page 19 of 40
17:01:52.28 process pointer page 20 of 40
17:01:52.32 process pointer page 21 of 40
17:01:52.36 process pointer page 22 of 40
17:01:52.40 process pointer page 23 of 40
17:01:52.43 process pointer page 24 of 40
17:01:52.46 process pointer page 25 of 40
17:01:52.50 process pointer page 26 of 40
17:01:52.54 process pointer page 27 of 40
17:01:52.57 process pointer page 28 of 40
17:01:52.65 process pointer page 29 of 40
17:01:52.68 process pointer page 30 of 40
17:01:52.73 process pointer page 31 of 40
17:01:52.76 process pointer page 32 of 40
17:01:52.79 process pointer page 33 of 40
17:01:52.82 process pointer page 34 of 40
17:01:52.92 process pointer page 35 of 40
17:01:52.99 process pointer page 36 of 40
17:01:53.03 process pointer page 37 of 40
17:01:53.07 process pointer page 38 of 40
17:01:53.10 process pointer page 39 of 40
17:01:53.15 Index 1 (XQS_1200_2000_DOC_ID)
17:01:53.74 Index 2 (XQS_1200_2000_SND_ID)
17:01:54.52 Index 3 (XQS_1200_2000_RCV_ID)
17:01:54.84 Relation 266 (XQS_1200_2000) is ok

17:01:54.84 Relation 267 (XQS_1000_3300)
17:01:54.84 process pointer page 0 of 19
17:01:54.85 process pointer page 1 of 19
17:01:54.88 process pointer page 2 of 19
17:01:54.93 process pointer page 3 of 19
17:01:55.02 process pointer page 4 of 19
17:01:55.07 process pointer page 5 of 19
17:01:55.12 process pointer page 6 of 19
17:01:55.18 process pointer page 7 of 19
17:01:55.29 process pointer page 8 of 19
17:01:55.32 process pointer page 9 of 19
17:01:55.41 process pointer page 10 of 19
17:01:55.51 process pointer page 11 of 19
17:01:55.60 process pointer page 12 of 19
17:01:55.68 process pointer page 13 of 19
17:01:55.72 process pointer page 14 of 19
17:01:55.77 process pointer page 15 of 19
17:01:55.80 process pointer page 16 of 19
17:01:55.87 process pointer page 17 of 19
17:01:55.96 process pointer page 18 of 19
17:01:56.02 Index 1 (XQS_1000_3300_DOC_ID)
17:01:56.32 Index 2 (XQS_1000_3300_SND_ID)
17:01:56.55 Index 3 (XQS_1000_3300_RCV_ID)
17:01:56.96 Relation 267 (XQS_1000_3300) is ok

17:01:56.96 Relation 268 (XQS_2000_3300)
17:01:56.96 process pointer page 0 of 1
17:01:56.96 Index 1 (XQS_2000_3300_DOC_ID)
17:01:56.96 Index 2 (XQS_2000_3300_SND_ID)
17:01:56.96 Index 3 (XQS_2000_3300_RCV_ID)
17:01:56.96 Relation 268 (XQS_2000_3300) is ok

17:01:56.96 Relation 269 (XQS_2100_3300)
17:01:56.96 process pointer page 0 of 26
17:01:56.99 process pointer page 1 of 26
17:01:57.04 process pointer page 2 of 26
17:01:57.07 process pointer page 3 of 26
17:01:57.10 process pointer page 4 of 26
17:01:57.13 process pointer page 5 of 26
17:01:57.18 process pointer page 6 of 26
17:01:57.21 process pointer page 7 of 26
17:01:57.24 process pointer page 8 of 26
17:01:57.28 process pointer page 9 of 26
17:01:57.32 process pointer page 10 of 26
17:01:57.35 process pointer page 11 of 26
17:01:57.38 process pointer page 12 of 26
17:01:57.41 process pointer page 13 of 26
17:01:57.46 process pointer page 14 of 26
17:01:57.49 process pointer page 15 of 26
17:01:57.52 process pointer page 16 of 26
17:01:57.55 process pointer page 17 of 26
17:01:57.61 process pointer page 18 of 26
17:01:57.71 process pointer page 19 of 26
17:01:57.80 process pointer page 20 of 26
17:01:57.89 process pointer page 21 of 26
17:01:57.96 process pointer page 22 of 26
17:01:58.00 process pointer page 23 of 26
17:01:58.03 process pointer page 24 of 26
17:01:58.08 process pointer page 25 of 26
17:01:58.10 Index 1 (XQS_2100_3300_DOC_ID)
17:01:58.36 Index 2 (XQS_2100_3300_SND_ID)
17:01:58.61 Index 3 (XQS_2100_3300_RCV_ID)
17:01:58.84 Relation 269 (XQS_2100_3300) is ok

17:01:58.84 Relation 270 (XQS_3300_3400)
17:01:58.84 process pointer page 0 of 4
17:01:58.88 process pointer page 1 of 4
17:01:58.89 process pointer page 2 of 4
17:01:58.92 process pointer page 3 of 4
17:01:58.94 Index 1 (XQS_3300_3400_DOC_ID)
17:01:58.97 Index 2 (XQS_3300_3400_SND_ID)
17:01:59.00 Relation 270 (XQS_3300_3400) is ok

17:01:59.00 Relation 276 (TRACE_STAT)
17:01:59.00 process pointer page 0 of 1
17:01:59.00 Relation 276 (TRACE_STAT) is ok

17:01:59.00 Validation finished
Done for 30610 ms, from 17:01:28.41 to 17:01:59.02.

Differences between old and current firebird.log

17:01:59.77. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_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:
2016-01-29 17:01 524 oltp30_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 +++
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Fri Jan 29 17:01:28 2016
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Fri Jan 29 17:01:59 2016
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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


Remove 122 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.oltp30\oltp30_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-01-29 17:02:05.40 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html