Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 40. 2016-02-01 7:57:52.59.
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.32301 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-02-01 07:55:49.7480 -1 <null> ::1/62813 327310 4904 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: 5873.91 2676 1057303 2016-02-01 04:55 2016-02-01 07:55
customer order: creation 380.54 365 68497 2016-02-01 04:55 2016-02-01 07:55
customer order: refuse 30.62 92 5512 2016-02-01 04:55 2016-02-01 07:55
order to supplier: creation 97.29 1878 17512 2016-02-01 04:55 2016-02-01 07:55
order to supplier: removal 2.65 26090 475 2016-02-01 04:55 2016-02-01 07:55
invoice (draft): creation 98.82 2996 17787 2016-02-01 04:55 2016-02-01 07:55
invoice (draft): removal 39.98 524 7196 2016-02-01 04:55 2016-02-01 07:55
invoice accept: apply 60.94 9432 10970 2016-02-01 04:55 2016-02-01 07:55
invoice accept: cancel 19.49 1833 3509 2016-02-01 04:55 2016-02-01 07:55
customer reserve: creation 3429.58 139 617325 2016-02-01 04:55 2016-02-01 07:55
customer reserve: removal 1177.31 51 211915 2016-02-01 04:55 2016-02-01 07:55
realization accept: apply 179.03 223 32225 2016-02-01 04:55 2016-02-01 07:55
realization accept: cancel 65.14 112 11726 2016-02-01 04:55 2016-02-01 07:55
payment from customer: creation 126.86 411 22835 2016-02-01 04:55 2016-02-01 07:55
payment from customer: removal 12.04 69 2168 2016-02-01 04:55 2016-02-01 07:55
payment to supplier: creation 104.10 251 18738 2016-02-01 04:55 2016-02-01 07:55
payment to supplier: removal 6.91 95 1244 2016-02-01 04:55 2016-02-01 07:55
service: total inventory turnovers 21.13 967 3804 2016-02-01 04:55 2016-02-01 07:55
service: total monetary turnovers 21.41 24 3853 2016-02-01 04:55 2016-02-01 07:55
service: refresh index statistics 0.07 5299 12 2016-02-01 04:55 2016-02-01 07:55
Done for 49970 ms, from 7:58:46.77 to 7:59:36.74.

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 5057 96942 91028 5914 6.10 04:55:50 05:13:50
interval # 2, overall 2 5627 107463 101285 6178 5.75 05:13:51 05:31:51
interval # 3, overall 3 6283 119276 113102 6174 5.18 05:31:52 05:49:52
interval # 4, overall 4 5677 110719 102182 8537 7.71 05:49:53 06:07:53
interval # 5, overall 5 5728 110017 103096 6921 6.29 06:07:54 06:25:54
interval # 6, overall 6 5941 116365 106942 9423 8.10 06:25:55 06:43:55
interval # 7, overall 7 6322 121691 113804 7887 6.48 06:43:56 07:01:56
interval # 8, overall 8 6182 123792 111275 12517 10.11 07:01:57 07:19:57
interval # 9, overall 9 6009 122025 108163 13862 11.36 07:19:58 07:37:58
interval # 10, overall 10 5913 117440 106426 11014 9.38 07:37:59 07:55:59
Done for 98530 ms, from 8:01:23.14 to 8:03:01.67.

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 2504.30 0.1964 1.7278 2746 40
WARM_TIME 2 2791.07 0.7753 1.2326 2144 39
WARM_TIME 3 2615.68 0.8770 1.1117 1528 31
WARM_TIME 4 2417.23 0.9023 1.0985 1135 30
WARM_TIME 5 2370.20 0.8962 1.1080 1247 33
WARM_TIME 6 2358.28 0.9280 1.0948 1100 36
WARM_TIME 7 2353.37 0.9404 1.0898 1108 34
WARM_TIME 8 2486.04 0.9027 1.0803 1486 40
WARM_TIME 9 2640.16 0.9043 1.0871 1506 40
WARM_TIME 10 2782.23 0.9284 1.0849 1533 40
TEST_TIME 11 2950.48 0.9302 1.0703 1897 40
TEST_TIME 12 3080.37 0.9397 1.0454 1593 40
TEST_TIME 13 3132.69 0.9489 1.0613 1472 39
TEST_TIME 14 3293.50 0.9374 1.0647 1580 40
TEST_TIME 15 3484.99 0.9391 1.0580 1713 40
TEST_TIME 16 3579.80 0.9656 1.0399 1912 40
TEST_TIME 17 3661.18 0.9570 1.0455 1501 40
TEST_TIME 18 3757.55 0.9621 1.0386 1512 40
TEST_TIME 19 3847.95 0.9608 1.0371 1493 40
TEST_TIME 20 3894.25 0.9735 1.0290 1263 40
TEST_TIME 21 3930.41 0.9710 1.0234 1366 40
TEST_TIME 22 3950.12 0.9720 1.0442 1314 40
TEST_TIME 23 4007.08 0.9846 1.0186 1231 40
TEST_TIME 24 3992.63 0.9797 1.0209 1283 39
TEST_TIME 25 4009.39 0.9759 1.0237 1124 40
TEST_TIME 26 4073.18 0.9689 1.0226 1193 40
TEST_TIME 27 4144.47 0.9678 1.0272 1851 39
TEST_TIME 28 4211.06 0.9748 1.0235 1755 40
TEST_TIME 29 4274.76 0.9735 1.0246 1541 40
TEST_TIME 30 4336.78 0.9767 1.0254 1591 40
TEST_TIME 31 4410.28 0.9757 1.0203 1420 40
TEST_TIME 32 4452.27 0.9791 1.0252 1526 40
TEST_TIME 33 4514.22 0.9805 1.0248 1480 40
TEST_TIME 34 4567.43 0.9830 1.0232 1278 40
TEST_TIME 35 4608.28 0.9852 1.0220 1433 40
TEST_TIME 36 4658.01 0.9830 1.0149 1321 40
TEST_TIME 37 4696.75 0.9794 1.0102 965 40
TEST_TIME 38 4661.42 0.9911 1.0104 806 36
TEST_TIME 39 4670.94 0.9825 1.0195 1160 40
TEST_TIME 40 4672.02 0.9941 1.0062 940 40
TEST_TIME 41 4616.36 0.9935 1.0076 804 37
TEST_TIME 42 4635.96 0.9795 1.0176 1480 39
TEST_TIME 43 4681.27 0.9843 1.0154 1636 39
TEST_TIME 44 4712.18 0.9859 1.0106 1229 40
TEST_TIME 45 4727.53 0.9850 1.0162 1159 40
TEST_TIME 46 4760.94 0.9871 1.0121 1474 40
TEST_TIME 47 4775.68 0.9875 1.0158 1312 39
TEST_TIME 48 4797.22 0.9902 1.0126 1482 40
TEST_TIME 49 4824.01 0.9864 1.0133 1239 40
TEST_TIME 50 4844.80 0.9888 1.0121 1449 39
TEST_TIME 51 4850.44 0.9911 1.0085 1203 40
TEST_TIME 52 4844.04 0.9904 1.0107 1277 39
TEST_TIME 53 4885.36 0.9833 1.0066 1102 40
TEST_TIME 54 4901.27 0.9847 1.0135 1143 40
TEST_TIME 55 4937.93 0.9877 1.0126 1209 40
TEST_TIME 56 4967.01 0.9887 1.0107 1244 40
TEST_TIME 57 4985.71 0.9893 1.0161 1723 40
TEST_TIME 58 5044.51 0.9870 1.0114 1629 40
TEST_TIME 59 5073.19 0.9888 1.0063 1444 40
TEST_TIME 60 5066.60 0.9908 1.0100 1512 40
TEST_TIME 61 5087.22 0.9894 1.0086 1536 39
TEST_TIME 62 5106.02 0.9888 1.0091 1547 40
TEST_TIME 63 5131.61 0.9881 1.0094 1247 40
TEST_TIME 64 5158.79 0.9884 1.0144 1352 40
TEST_TIME 65 5181.08 0.9945 1.0079 1245 40
TEST_TIME 66 5183.72 0.9921 1.0089 1150 40
TEST_TIME 67 5193.19 0.9920 1.0077 1254 38
TEST_TIME 68 5197.08 0.9924 1.0096 1100 40
TEST_TIME 69 5201.00 0.9945 1.0062 1181 37
TEST_TIME 70 5198.79 0.9923 1.0074 1114 40
TEST_TIME 71 5202.70 0.9925 1.0047 1167 40
TEST_TIME 72 5206.49 0.9900 1.0092 1775 39
TEST_TIME 73 5238.17 0.9893 1.0094 1466 40
TEST_TIME 74 5270.45 0.9897 1.0101 1483 40
TEST_TIME 75 5294.23 0.9922 1.0081 1553 39
TEST_TIME 76 5295.45 0.9946 1.0062 1571 40
TEST_TIME 77 5291.32 0.9939 1.0078 1276 39
TEST_TIME 78 5303.31 0.9926 1.0087 1256 40
TEST_TIME 79 5309.86 0.9947 1.0050 1147 38
TEST_TIME 80 5307.39 0.9929 1.0073 1176 38
TEST_TIME 81 5312.45 0.9948 1.0059 1195 40
TEST_TIME 82 5298.76 0.9962 1.0027 801 39
TEST_TIME 83 5276.53 0.9948 1.0054 830 38
TEST_TIME 84 5292.61 0.9904 1.0062 1166 40
TEST_TIME 85 5296.52 0.9936 1.0045 1182 40
TEST_TIME 86 5295.45 0.9930 1.0067 1217 40
TEST_TIME 87 5314.73 0.9916 1.0070 1421 39
TEST_TIME 88 5319.72 0.9946 1.0045 1441 37
TEST_TIME 89 5322.17 0.9928 1.0084 1329 40
TEST_TIME 90 5344.89 0.9930 1.0081 1239 39
TEST_TIME 91 5353.01 0.9955 1.0045 1345 39
TEST_TIME 92 5360.37 0.9922 1.0054 1123 40
TEST_TIME 93 5365.52 0.9936 1.0062 1429 40
TEST_TIME 94 5364.16 0.9957 1.0061 1441 40
TEST_TIME 95 5367.83 0.9948 1.0050 1310 40
TEST_TIME 96 5371.29 0.9939 1.0069 1183 40
TEST_TIME 97 5375.91 0.9956 1.0038 1268 40
TEST_TIME 98 5365.90 0.9954 1.0048 1252 40
TEST_TIME 99 5362.47 0.9953 1.0035 1120 39
TEST_TIME 100 5369.34 0.9921 1.0049 1114 39
TEST_TIME 101 5361.33 0.9964 1.0038 1007 40
TEST_TIME 102 5353.95 0.9953 1.0062 1209 39
TEST_TIME 103 5385.83 0.9905 1.0086 1324 40
TEST_TIME 104 5409.52 0.9948 1.0044 1295 40
TEST_TIME 105 5423.83 0.9932 1.0048 1596 40
TEST_TIME 106 5430.12 0.9943 1.0065 1361 40
TEST_TIME 107 5436.19 0.9959 1.0047 1262 40
TEST_TIME 108 5437.00 0.9952 1.0048 1352 40
TEST_TIME 109 5436.41 0.9957 1.0045 1267 40
TEST_TIME 110 5438.13 0.9951 1.0048 1164 40
TEST_TIME 111 5434.22 0.9965 1.0041 1269 40
TEST_TIME 112 5435.82 0.9948 1.0042 1289 40
TEST_TIME 113 5434.71 0.9955 1.0066 1163 39
TEST_TIME 114 5441.58 0.9965 1.0036 1148 40
TEST_TIME 115 5431.17 0.9967 1.0033 1244 39
TEST_TIME 116 5423.24 0.9961 1.0028 957 40
TEST_TIME 117 5426.20 0.9937 1.0056 1639 40
TEST_TIME 118 5436.31 0.9952 1.0054 1365 40
TEST_TIME 119 5445.58 0.9952 1.0041 1554 38
TEST_TIME 120 5450.50 0.9948 1.0078 1351 40
TEST_TIME 121 5471.61 0.9956 1.0051 1358 40
TEST_TIME 122 5476.21 0.9960 1.0066 1349 39
TEST_TIME 123 5485.86 0.9967 1.0042 1271 40
TEST_TIME 124 5490.39 0.9954 1.0047 1241 40
TEST_TIME 125 5493.34 0.9962 1.0025 1165 39
TEST_TIME 126 5486.81 0.9957 1.0033 1144 39
TEST_TIME 127 5488.15 0.9952 1.0049 1059 40
TEST_TIME 128 5493.02 0.9962 1.0068 1018 40
TEST_TIME 129 5507.99 0.9965 1.0038 1111 40
TEST_TIME 130 5508.28 0.9962 1.0033 1125 38
TEST_TIME 131 5518.29 0.9938 1.0026 959 39
TEST_TIME 132 5521.95 0.9944 1.0048 1360 40
TEST_TIME 133 5530.01 0.9957 1.0054 1228 39
TEST_TIME 134 5539.66 0.9962 1.0035 1378 39
TEST_TIME 135 5551.02 0.9962 1.0048 1150 40
TEST_TIME 136 5562.72 0.9953 1.0046 1478 40
TEST_TIME 137 5571.18 0.9958 1.0036 1352 38
TEST_TIME 138 5572.42 0.9961 1.0054 1037 38
TEST_TIME 139 5578.19 0.9973 1.0025 1115 40
TEST_TIME 140 5575.54 0.9958 1.0028 1000 38
TEST_TIME 141 5565.21 0.9976 1.0025 1175 36
TEST_TIME 142 5591.64 0.9907 1.0035 975 40
TEST_TIME 143 5591.76 0.9965 1.0032 948 40
TEST_TIME 144 5585.82 0.9975 1.0025 1032 40
TEST_TIME 145 5589.80 0.9949 1.0033 1036 39
TEST_TIME 146 5591.82 0.9961 1.0020 1071 40
TEST_TIME 147 5585.80 0.9963 1.0040 1393 40
TEST_TIME 148 5599.56 0.9948 1.0029 1266 40
TEST_TIME 149 5602.66 0.9957 1.0029 1540 39
TEST_TIME 150 5605.88 0.9957 1.0046 1112 40
TEST_TIME 151 5618.00 0.9958 1.0027 1169 40
TEST_TIME 152 5621.24 0.9956 1.0046 1196 40
TEST_TIME 153 5634.25 0.9966 1.0029 1294 40
TEST_TIME 154 5639.09 0.9958 1.0035 1188 40
TEST_TIME 155 5644.30 0.9961 1.0023 1317 39
TEST_TIME 156 5642.06 0.9962 1.0058 1086 40
TEST_TIME 157 5658.76 0.9965 1.0022 1140 40
TEST_TIME 158 5650.29 0.9973 1.0036 1155 40
TEST_TIME 159 5654.49 0.9967 1.0023 980 39
TEST_TIME 160 5650.89 0.9966 1.0032 865 40
TEST_TIME 161 5658.48 0.9960 1.0030 992 40
TEST_TIME 162 5656.78 0.9971 1.0042 1179 40
TEST_TIME 163 5672.45 0.9953 1.0036 1410 39
TEST_TIME 164 5680.95 0.9960 1.0025 1320 40
TEST_TIME 165 5681.95 0.9963 1.0030 1223 39
TEST_TIME 166 5683.59 0.9967 1.0040 1302 40
TEST_TIME 167 5687.01 0.9974 1.0025 1395 40
TEST_TIME 168 5683.98 0.9971 1.0041 1315 39
TEST_TIME 169 5688.65 0.9973 1.0028 1061 40
TEST_TIME 170 5686.34 0.9974 1.0033 1201 39
TEST_TIME 171 5680.24 0.9985 1.0030 1001 40
TEST_TIME 172 5681.43 0.9969 1.0023 1166 40
TEST_TIME 173 5677.58 0.9972 1.0027 1067 40
TEST_TIME 174 5677.76 0.9969 1.0029 936 40
TEST_TIME 175 5681.85 0.9964 1.0029 891 38
TEST_TIME 176 5684.85 0.9967 1.0024 1034 39
TEST_TIME 177 5682.67 0.9971 1.0049 1316 39
TEST_TIME 178 5693.74 0.9976 1.0026 1383 39
TEST_TIME 179 5697.03 0.9964 1.0028 1137 39
TEST_TIME 180 5702.56 0.9962 1.0025 1083 39
TEST_TIME 181 5700.37 0.9973 1.0033 1182 38
TEST_TIME 182 5704.81 0.9970 1.0028 1196 39
TEST_TIME 183 5707.19 0.9970 1.0034 938 38
TEST_TIME 184 5706.29 0.9981 1.0027 1296 39
TEST_TIME 185 5701.70 0.9981 1.0026 1037 40
TEST_TIME 186 5709.04 0.9959 1.0031 1127 39
TEST_TIME 187 5718.27 0.9961 1.0016 1178 40
TEST_TIME 188 5711.44 0.9974 1.0034 1130 39
TEST_TIME 189 5713.36 0.9978 1.0024 1066 39
TEST_TIME 190 5705.70 0.9986 1.0023 848 40
Done for 17630 ms, from 8:03:02.56 to 8:03:20.19.

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 8347 21788 9332 42398 9669 <null> 20773 14280 9545 8134 13149 7679 25501 46867 36890 10785 184198 243773 <null> 04:55:50 05:13:50
fetches per second 2 9374 15019 11675 <null> 10487 <null> 21028 14535 7791 14644 16365 11205 29847 36180 32155 16247 131100 167194 <null> 05:13:51 05:31:51
fetches per second 3 10312 38735 12170 <null> 13436 14787 18057 7980 27230 13758 17126 13699 30580 64965 36000 6068 177705 150203 <null> 05:31:52 05:49:52
fetches per second 4 8173 12549 14272 10555 14741 <null> 18108 13664 13276 22304 17101 7257 32866 7815 41960 8384 177686 130817 <null> 05:49:53 06:07:53
fetches per second 5 7968 17019 10065 16744 13579 11177 21024 11514 24803 8242 18650 13648 38042 23965 18554 11990 301717 242587 <null> 06:07:54 06:25:54
fetches per second 6 14381 14062 13697 <null> 10806 <null> 19855 16531 36899 21067 26442 6794 38710 21773 50850 14186 240960 138636 <null> 06:25:55 06:43:55
fetches per second 7 10320 19314 12952 35630 12131 <null> 27373 17358 26495 7760 13442 7997 43789 32494 31267 10449 124380 190777 <null> 06:43:56 07:01:56
fetches per second 8 15336 14146 28771 64483 23899 12746 45136 18089 24771 110230 26957 6056 53733 7286 36206 8445 138711 327505 <null> 07:01:57 07:19:57
fetches per second 9 13831 32471 11023 27731 23551 5219 27559 78855 26047 18387 14247 7920 35231 9760 46364 23064 75153 258921 <null> 07:19:58 07:37:58
fetches per second 10 13485 32582 13445 <null> 15895 10353 26860 <null> 25654 23394 19597 11627 42278 33028 23567 61562 216708 227411 <null> 07:37:59 07:55:59
marks per second 1 1420 2056 1247 4740 1446 <null> 1450 1406 831 1223 1779 822 1077 5328 2016 1299 2839 5837 <null> 04:55:50 05:13:50
marks per second 2 1651 1379 1678 <null> 1542 <null> 1593 1349 986 1486 1826 1228 1075 3945 1942 1741 7935 3979 <null> 05:13:51 05:31:51
marks per second 3 1790 3681 1875 <null> 2029 1989 1382 836 2656 1569 1709 1550 918 5538 2144 773 3280 2324 <null> 05:31:52 05:49:52
marks per second 4 1346 1149 1759 1254 1741 <null> 1106 1282 1055 2376 1438 729 818 936 1613 857 7103 1203 <null> 05:49:53 06:07:53
marks per second 5 1332 1585 1407 1641 1883 1841 1410 1115 1612 940 1484 1481 707 2257 1086 1333 2012 3815 <null> 06:07:54 06:25:54
marks per second 6 2401 1324 1955 <null> 1564 <null> 1492 1600 2759 2268 3035 745 820 2216 2760 1488 2280 1992 <null> 06:25:55 06:43:55
marks per second 7 1759 1789 1782 3274 1694 <null> 1794 1668 1517 908 1616 772 667 3174 2195 1069 1752 2473 <null> 06:43:56 07:01:56
marks per second 8 2715 1309 4120 5687 3389 2405 3418 1628 1382 10164 3416 799 906 714 2532 734 7390 8574 <null> 07:01:57 07:19:57
marks per second 9 2404 3007 1445 3858 3046 867 1888 7086 2071 1835 1564 782 566 974 3568 2954 1084 4286 <null> 07:19:58 07:37:58
marks per second 10 2224 2819 1766 <null> 2148 1480 1782 <null> 1115 2491 2268 1272 694 3433 1633 7513 2596 2231 <null> 07:37:59 07:55:59
reads/fetches*100 1 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:55:50 05:13:50
reads/fetches*100 2 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:13:51 05:31:51
reads/fetches*100 3 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:31:52 05:49:52
reads/fetches*100 4 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:49:53 06:07:53
reads/fetches*100 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 06:07:54 06:25:54
reads/fetches*100 6 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 06:25:55 06:43:55
reads/fetches*100 7 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 06:43:56 07:01:56
reads/fetches*100 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 07:01:57 07:19:57
reads/fetches*100 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 07:19:58 07:37:58
reads/fetches*100 10 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 07:37:59 07:55:59
writes/marks*100 1 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 4 0 <null> 04:55:50 05:13:50
writes/marks*100 2 0 0 0 <null> 0 <null> 0 0 1 1 0 0 0 0 0 0 2 0 <null> 05:13:51 05:31:51
writes/marks*100 3 0 0 0 <null> 0 0 0 0 1 1 0 0 0 0 0 0 3 0 <null> 05:31:52 05:49:52
writes/marks*100 4 0 0 0 0 0 <null> 0 0 1 1 0 0 0 0 0 0 2 0 <null> 05:49:53 06:07:53
writes/marks*100 5 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 5 0 <null> 06:07:54 06:25:54
writes/marks*100 6 0 0 0 <null> 0 <null> 0 0 1 0 0 0 0 0 0 0 3 0 <null> 06:25:55 06:43:55
writes/marks*100 7 0 0 0 0 0 <null> 0 0 0 0 0 0 1 0 0 0 1 0 <null> 06:43:56 07:01:56
writes/marks*100 8 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 4 2 0 <null> 07:01:57 07:19:57
writes/marks*100 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3 <null> 07:19:58 07:37:58
writes/marks*100 10 0 0 0 <null> 0 0 0 <null> 2 0 0 0 0 0 0 0 1 0 <null> 07:37:59 07:55:59
Done for 12540 ms, from 8:03:22.53 to 8:03:35.07.

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 1779863 1698636 81227 4.56 0 5645 20 81227 2016-02-01 04:55 2016-02-01 07:55
doc_list_biud 1780126 1698636 81490 4.57 0 6162 13 81490 2016-02-01 04:55 2016-02-01 07:55
sp_add_invoice_to_stock 16271 10970 5301 32.57 16 120987 9432 5301 2016-02-01 04:55 2016-02-01 07:55
sp_cancel_adding_invoice 4163 3509 654 15.70 0 43945 1833 654 2016-02-01 04:55 2016-02-01 07:55
sp_cancel_client_order 5655 5512 143 2.52 0 1606 92 143 2016-02-01 04:55 2016-02-01 07:55
sp_cancel_customer_reserve 288281 211915 76366 26.49 0 1794 51 76366 2016-02-01 04:55 2016-02-01 07:55
sp_cancel_pay_from_customer 2173 2168 5 0.23 0 1030 69 5 2016-02-01 04:55 2016-02-01 07:55
sp_cancel_pay_to_supplier 1255 1244 11 0.87 0 1139 95 11 2016-02-01 04:55 2016-02-01 07:55
sp_cancel_supplier_invoice 8344 7196 1148 13.75 0 5305 524 1148 2016-02-01 04:55 2016-02-01 07:55
sp_cancel_supplier_order 1189 475 714 60.05 78 182588 26090 714 2016-02-01 04:55 2016-02-01 07:55
sp_cancel_write_off 15494 11726 3768 24.31 0 2199 112 3768 2016-02-01 04:55 2016-02-01 07:55
sp_client_order 68497 68497 0 0.00 0 3666 365 0 2016-02-01 04:55 2016-02-01 07:55
sp_customer_reserve 617325 617325 0 0.00 0 4227 139 0 2016-02-01 04:55 2016-02-01 07:55
sp_fill_shopping_cart 103796 103796 0 0.00 0 19002 100 0 2016-02-01 04:55 2016-02-01 07:55
sp_fill_shopping_cart_clo_res 617325 617325 0 0.00 0 1576 6 0 2016-02-01 04:55 2016-02-01 07:55
sp_get_clo_for_invoice 10970 10970 0 0.00 0 3748 393 0 2016-02-01 04:55 2016-02-01 07:55
sp_kill_cost_storno 22836 18647 4189 18.34 0 2465 24 4189 2016-02-01 04:55 2016-02-01 07:55
sp_kill_qstorno_ret_qs2qd 600319 443227 157092 26.16 0 5048 24 157092 2016-02-01 04:55 2016-02-01 07:55
sp_kill_qty_storno 364968 283528 81440 22.31 0 6162 69 81440 2016-02-01 04:55 2016-02-01 07:55
sp_lock_selected_doc 67255 60114 7141 10.61 0 967 3 7141 2016-02-01 04:55 2016-02-01 07:55
sp_make_cost_storno 84768 84768 0 0.00 0 4726 162 0 2016-02-01 04:55 2016-02-01 07:55
sp_multiply_rows_for_pdistr 84768 84768 0 0.00 0 1482 57 0 2016-02-01 04:55 2016-02-01 07:55
sp_multiply_rows_for_qdistr 68497 68497 0 0.00 0 2683 191 0 2016-02-01 04:55 2016-02-01 07:55
sp_pay_from_customer 22835 22835 0 0.00 15 4586 411 0 2016-02-01 04:55 2016-02-01 07:55
sp_pay_to_supplier 18738 18738 0 0.00 0 3635 251 0 2016-02-01 04:55 2016-02-01 07:55
sp_payment_common 41573 41573 0 0.00 0 1154 29 0 2016-02-01 04:55 2016-02-01 07:55
sp_qd_handle_on_cancel_clo 5655 5512 143 2.52 0 1388 39 143 2016-02-01 04:55 2016-02-01 07:55
sp_qd_handle_on_invoice_upd_sts 15033 14479 554 3.68 0 6131 411 554 2016-02-01 04:55 2016-02-01 07:55
sp_qd_handle_on_reserve_upd_sts 32225 32225 0 0.00 0 1128 40 0 2016-02-01 04:55 2016-02-01 07:55
sp_reserve_write_off 32542 32225 317 0.97 0 3924 223 317 2016-02-01 04:55 2016-02-01 07:55
sp_supplier_invoice 17787 17787 0 0.00 5 21087 2996 0 2016-02-01 04:55 2016-02-01 07:55
sp_supplier_order 17512 17512 0 0.00 0 9165 1878 0 2016-02-01 04:55 2016-02-01 07:55
srv_find_qd_qs_mism 1049810 968591 81219 7.73 0 2886 11 81219 2016-02-01 04:55 2016-02-01 07:55
srv_make_invnt_saldo 3804 3804 0 0.00 15 48950 967 0 2016-02-01 04:55 2016-02-01 07:55
srv_make_money_saldo 3853 3853 0 0.00 0 1186 24 0 2016-02-01 04:55 2016-02-01 07:55
srv_recalc_idx_stat 12 12 0 0.00 1716 14710 5299 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_add_invoice_to_stock 5301 5301 0 0.00 0 1045 57 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_cancel_adding_invoice 374 374 0 0.00 0 1794 372 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_cancel_client_order 143 143 0 0.00 0 468 88 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_cancel_customer_reserve 16 16 0 0.00 0 218 57 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_cancel_pay_from_customer 5 5 0 0.00 93 499 235 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_cancel_pay_to_supplier 11 11 0 0.00 0 281 119 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_cancel_supplier_invoice 467 467 0 0.00 0 436 57 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_cancel_supplier_order 9460 9460 0 0.00 0 2324 180 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_cancel_write_off 36 36 0 0.00 0 406 54 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-abend:sp_reserve_write_off 317 317 0 0.00 0 765 58 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_add_invoice_to_stock 10978 10978 0 0.00 0 17606 1572 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_cancel_adding_invoice 1251 1251 0 0.00 0 13281 1374 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_cancel_client_order 5512 5512 0 0.00 0 749 86 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_cancel_customer_reserve 2137 2137 0 0.00 0 702 87 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_cancel_pay_from_customer 2168 2168 0 0.00 0 655 66 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_cancel_pay_to_supplier 1244 1244 0 0.00 0 624 61 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_cancel_supplier_invoice 884 884 0 0.00 0 593 78 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_cancel_supplier_order 475 475 0 0.00 0 84528 5703 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_cancel_write_off 3248 3248 0 0.00 0 687 89 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_client_order 68497 68497 0 0.00 0 1154 95 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_customer_reserve 3165 3165 0 0.00 0 1311 62 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_pay_from_customer 22835 22835 0 0.00 0 1029 80 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_pay_to_supplier 18738 18738 0 0.00 0 874 69 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_reserve_write_off 32225 32225 0 0.00 0 1077 94 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_supplier_invoice 17790 17790 0 0.00 0 983 86 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:sp_supplier_order 17513 17513 0 0.00 0 1170 88 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:srv_make_invnt_saldo 3804 3804 0 0.00 0 328 12 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:srv_make_money_saldo 3853 3853 0 0.00 0 312 13 0 2016-02-01 04:55 2016-02-01 07:55
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 16 1467 491 0 2016-02-01 04:55 2016-02-01 07:55
v_add_invoice_to_stock 32542 21940 10602 32.57 0 718 7 10602 2016-02-01 04:55 2016-02-01 07:55
v_all_customers 102522 102522 0 0.00 0 655 4 0 2016-02-01 04:55 2016-02-01 07:55
v_all_suppliers 75330 75330 0 0.00 0 546 4 0 2016-02-01 04:55 2016-02-01 07:55
v_all_wares 136994 136994 0 0.00 0 780 5 0 2016-02-01 04:55 2016-02-01 07:55
v_cancel_adding_invoice 2764 2502 262 9.47 0 2184 78 262 2016-02-01 04:55 2016-02-01 07:55
v_cancel_client_order 11310 11024 286 2.52 0 515 4 286 2016-02-01 04:55 2016-02-01 07:55
v_cancel_customer_prepayment 4346 4336 10 0.23 0 312 4 10 2016-02-01 04:55 2016-02-01 07:55
v_cancel_customer_reserve 4306 4274 32 0.74 0 999 5 32 2016-02-01 04:55 2016-02-01 07:55
v_cancel_payment_to_supplier 2510 2488 22 0.87 0 608 5 22 2016-02-01 04:55 2016-02-01 07:55
v_cancel_supplier_invoice 2702 1768 934 34.56 0 234 7 934 2016-02-01 04:55 2016-02-01 07:55
v_cancel_supplier_order 2378 950 1428 60.05 0 219 6 1428 2016-02-01 04:55 2016-02-01 07:55
v_cancel_write_off 6568 6496 72 1.09 0 1545 49 72 2016-02-01 04:55 2016-02-01 07:55
v_max_id_clo_ord 17512 17512 0 0.00 0 436 6 0 2016-02-01 04:55 2016-02-01 07:55
v_max_id_clo_res 3165 3165 0 0.00 0 374 12 0 2016-02-01 04:55 2016-02-01 07:55
v_max_id_ord_sup 17787 17787 0 0.00 0 359 6 0 2016-02-01 04:55 2016-02-01 07:55
v_max_non_paid_invoice 16372 16372 0 0.00 0 437 4 0 2016-02-01 04:55 2016-02-01 07:55
v_max_non_paid_realizn 22835 22835 0 0.00 0 405 4 0 2016-02-01 04:55 2016-02-01 07:55
v_min_id_clo_ord 17512 17512 0 0.00 0 592 7 0 2016-02-01 04:55 2016-02-01 07:55
v_min_id_clo_res 3165 3165 0 0.00 0 218 6 0 2016-02-01 04:55 2016-02-01 07:55
v_min_id_ord_sup 17787 17787 0 0.00 0 531 6 0 2016-02-01 04:55 2016-02-01 07:55
v_min_non_paid_invoice 18738 18738 0 0.00 0 795 7 0 2016-02-01 04:55 2016-02-01 07:55
v_min_non_paid_realizn 22835 22835 0 0.00 0 702 4 0 2016-02-01 04:55 2016-02-01 07:55
v_our_firm 34472 34472 0 0.00 0 830 4 0 2016-02-01 04:55 2016-02-01 07:55
v_reserve_write_off 65084 64450 634 0.97 0 874 4 634 2016-02-01 04:55 2016-02-01 07:55
x_lock_depdocs_on_canc_invoice 15318 9821 5497 35.88 0 1202 20 5497 2016-02-01 04:55 2016-02-01 07:55
x_lock_depdocs_on_canc_sup_ord 1188 475 713 60.01 0 546 19 713 2016-02-01 04:55 2016-02-01 07:55
x_make_qstorno_1000_1200 17512 17512 0 0.00 0 8992 1631 0 2016-02-01 04:55 2016-02-01 07:55
x_make_qstorno_1200_2000 17787 17787 0 0.00 0 18584 2773 0 2016-02-01 04:55 2016-02-01 07:55
x_make_qstorno_2100_3300 617325 617325 0 0.00 0 4118 126 0 2016-02-01 04:55 2016-02-01 07:55
Done for 194960 ms, from 8:06:42.32 to 8:09:57.28.

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 70 sp_kill_cost_storno 335544336 2016-02-01 04:58 2016-02-01 07:54
deadlock 1 sp_kill_qstorno_ret_qs2qd 335544336 2016-02-01 07:20 2016-02-01 07:20
deadlock 828 sp_lock_selected_doc 335544336 2016-02-01 04:55 2016-02-01 07:55
deadlock 143 sp_qd_handle_on_cancel_clo 335544336 2016-02-01 04:56 2016-02-01 07:52
deadlock 111 sp_qd_handle_on_invoice_upd_sts 335544336 2016-02-01 04:55 2016-02-01 07:54
deadlock 9 x_lock_depdocs_on_canc_invoice 335544336 2016-02-01 05:09 2016-02-01 07:52
deadlock 5 x_lock_depdocs_on_canc_sup_ord 335544336 2016-02-01 04:56 2016-02-01 06:18
concurrent_transaction 5320 sp_lock_selected_doc 335544878 2016-02-01 04:55 2016-02-01 07:55
concurrent_transaction 392 x_lock_depdocs_on_canc_invoice 335544878 2016-02-01 04:55 2016-02-01 07:54
concurrent_transaction 259 x_lock_depdocs_on_canc_sup_ord 335544878 2016-02-01 04:56 2016-02-01 07:55
Done for 5390 ms, from 8:10:01.00 to 8:10:06.39.

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 327877
MON$OLDEST_ACTIVE 327878
MON$OLDEST_SNAPSHOT 327878
MON$NEXT_TRANSACTION 327878
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 681216
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.32301 Firebird 3.0 Release Candidate 2
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.0.32301 Firebird 3.0 Release Candidate 2"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.0.32301 Firebird 3.0 Release Candidate 2/tcp (WIN-2BE1UI8LGDL)/P13"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.0.32301 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 328116
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 327879
Oldest active 327880
Oldest snapshot 327880
Next transaction 327881
Sequence number 0
Next attachment ID 5031
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.12, total records: 1684175
Average version length: 47.77, total versions: 2849, 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: 18240
Data pages: 18240, average fill: 73%
Primary pages: 18240, secondary pages: 0, swept pages: 10036
Empty pages: 0, full pages: 16608
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 48
60 - 79% = 18188
80 - 99% = 1

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 9376, nodes: 1684175
Average node length: 19.85, total dup: 0, max dup: 0
Average key length: 16.90, compression ratio: 1.60
Average prefix length: 13.09, average data length: 13.91
Clustering factor: 428943, ratio: 0.25
Fill distribution:
0 - 19% = 493
20 - 39% = 3296
40 - 59% = 4388
60 - 79% = 516
80 - 99% = 683

Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 6108, nodes: 1684175
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: 407836, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 3322
40 - 59% = 2765
60 - 79% = 21
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 131595, depth: 3, leaf buckets: 3518, nodes: 1684175
Average node length: 7.10, total dup: 1159687, max dup: 49
Average key length: 4.16, compression ratio: 2.16
Average prefix length: 7.15, average data length: 1.85
Clustering factor: 395000, ratio: 0.23
Fill distribution:
0 - 19% = 93
20 - 39% = 1811
40 - 59% = 1297
60 - 79% = 72
80 - 99% = 245

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.39, total records: 574299
Average version length: 35.64, total versions: 1691, max versions: 3
Average fragment length: 15.00, total fragments: 6, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7264
Data pages: 7264, average fill: 75%
Primary pages: 7260, secondary pages: 4, swept pages: 6572
Empty pages: 7, full pages: 6906
Fill distribution:
0 - 19% = 12
20 - 39% = 3
40 - 59% = 15
60 - 79% = 7205
80 - 99% = 29

Index DOC_LIST_ID_DESC (1)
Root page: 203156, depth: 3, leaf buckets: 2177, nodes: 574299
Average node length: 11.73, total dup: 0, max dup: 0
Average key length: 8.88, compression ratio: 1.01
Average prefix length: 3.12, average data length: 5.88
Clustering factor: 155868, ratio: 0.27
Fill distribution:
0 - 19% = 0
20 - 39% = 1325
40 - 59% = 825
60 - 79% = 26
80 - 99% = 1

Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 671, nodes: 574299
Average node length: 4.86, total dup: 574249, max dup: 42994
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 267624, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 613
60 - 79% = 38
80 - 99% = 19

Index PK_DOC_LIST (0)
Root page: 218807, depth: 3, leaf buckets: 1983, nodes: 574299
Average node length: 11.73, total dup: 0, max dup: 0
Average key length: 8.88, compression ratio: 1.01
Average prefix length: 3.12, average data length: 5.88
Clustering factor: 155868, ratio: 0.27
Fill distribution:
0 - 19% = 166
20 - 39% = 1007
40 - 59% = 450
60 - 79% = 161
80 - 99% = 199

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: 64.19, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 17.50, total fragments: 386, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.62
Pointer pages: 2, data page slots: 872
Data pages: 36, average fill: 21%
Primary pages: 4, secondary pages: 32, swept pages: 4
Empty pages: 11, full pages: 3
Fill distribution:
0 - 19% = 23
20 - 39% = 9
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: 53.55, total records: 2895
Average version length: 71.15, total versions: 719, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.79
Pointer pages: 1, data page slots: 616
Data pages: 168, average fill: 21%
Primary pages: 168, secondary pages: 0, swept pages: 108
Empty pages: 41, full pages: 0
Fill distribution:
0 - 19% = 81
20 - 39% = 65
40 - 59% = 15
60 - 79% = 7
80 - 99% = 0

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 997, depth: 2, leaf buckets: 13, nodes: 2895
Average node length: 15.91, total dup: 1, max dup: 1
Average key length: 13.90, compression ratio: 1.94
Average prefix length: 16.09, average data length: 10.91
Clustering factor: 2343, ratio: 0.81
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 6
60 - 79% = 2
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 14.92, 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.15
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: 8.31, total records: 113
Average version length: 45.63, total versions: 93, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 7.70
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 8%
Primary pages: 16, secondary pages: 0, swept pages: 7
Empty pages: 11, full pages: 0
Fill distribution:
0 - 19% = 14
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 99201, depth: 2, leaf buckets: 1, nodes: 113
Average node length: 10.06, total dup: 66, max dup: 12
Average key length: 8.23, compression ratio: 2.31
Average prefix length: 13.18, average data length: 5.82
Clustering factor: 45, ratio: 0.40
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: 211224
Average version length: 30.67, total versions: 1582, max versions: 5
Average fragment length: 33.00, total fragments: 7, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.52
Pointer pages: 2, data page slots: 2320
Data pages: 2320, average fill: 68%
Primary pages: 2314, secondary pages: 6, swept pages: 1744
Empty pages: 4, full pages: 826
Fill distribution:
0 - 19% = 27
20 - 39% = 76
40 - 59% = 114
60 - 79% = 2103
80 - 99% = 0

Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 206, nodes: 211224
Average node length: 4.51, total dup: 211175, max dup: 8831
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 36303, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 128
60 - 79% = 48
80 - 99% = 16

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 229, nodes: 211224
Average node length: 5.46, total dup: 190585, max dup: 54
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 46511, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 19
40 - 59% = 84
60 - 79% = 87
80 - 99% = 38

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 232, nodes: 211224
Average node length: 5.46, total dup: 190585, max dup: 54
Average key length: 2.96, compression ratio: 7.44
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 46555, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 30
40 - 59% = 77
60 - 79% = 84
80 - 99% = 40

Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 234, nodes: 211224
Average node length: 5.25, total dup: 190585, max dup: 54
Average key length: 2.75, compression ratio: 3.27
Average prefix length: 8.35, average data length: 0.65
Clustering factor: 46545, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 106
60 - 79% = 87
80 - 99% = 20

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 7087, depth: 2, leaf buckets: 192, nodes: 243044
Average node length: 4.47, total dup: 242853, max dup: 2745
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 32979, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 54
60 - 79% = 91
80 - 99% = 47

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.45, total records: 10408744
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: 1441.71, compression ratio: 9.71
Pointer pages: 149, data page slots: 243008
Data pages: 243008, average fill: 87%
Primary pages: 243008, secondary pages: 0, swept pages: 3
Empty pages: 0, full pages: 243007
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 243007

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 11043, nodes: 10408744
Average node length: 5.65, total dup: 9080099, max dup: 130
Average key length: 2.23, compression ratio: 3.58
Average prefix length: 7.81, average data length: 0.18
Clustering factor: 4196546, ratio: 0.40
Fill distribution:
0 - 19% = 9
20 - 39% = 0
40 - 59% = 5075
60 - 79% = 3633
80 - 99% = 2326

Index PERF_LOG_GDSCODE (3)
Root page: 129296, depth: 3, leaf buckets: 11479, nodes: 10408744
Average node length: 4.48, total dup: 10408739, max dup: 9782657
Average key length: 1.06, compression ratio: 0.28
Average prefix length: 0.30, average data length: 0.00
Clustering factor: 297569, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11459
60 - 79% = 1
80 - 99% = 19

Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 12170, nodes: 10408744
Average node length: 5.63, total dup: 10119845, max dup: 19733
Average key length: 2.21, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 1100774, ratio: 0.11
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 8286
60 - 79% = 2155
80 - 99% = 1724

Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 12681, nodes: 10408744
Average node length: 5.52, total dup: 10354922, max dup: 1437948
Average key length: 2.10, compression ratio: 18.01
Average prefix length: 37.70, average data length: 0.09
Clustering factor: 6040762, ratio: 0.58
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 10602
60 - 79% = 695
80 - 99% = 1371

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.93, total records: 320714
Average version length: 55.75, total versions: 834, 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: 3816
Data pages: 3816, average fill: 74%
Primary pages: 3816, secondary pages: 0, swept pages: 2396
Empty pages: 8, full pages: 3615
Fill distribution:
0 - 19% = 12
20 - 39% = 3
40 - 59% = 15
60 - 79% = 3786
80 - 99% = 0

Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 405, nodes: 320714
Average node length: 5.83, total dup: 271955, max dup: 990
Average key length: 3.12, compression ratio: 2.88
Average prefix length: 8.03, average data length: 0.97
Clustering factor: 39693, ratio: 0.12
Fill distribution:
0 - 19% = 8
20 - 39% = 18
40 - 59% = 230
60 - 79% = 107
80 - 99% = 42

Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 340, nodes: 320714
Average node length: 5.54, total dup: 285258, max dup: 343
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.27, average data length: 0.73
Clustering factor: 71476, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 154
60 - 79% = 119
80 - 99% = 64

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.85, total records: 5971
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.53
Pointer pages: 1, data page slots: 72
Data pages: 72, average fill: 72%
Primary pages: 72, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 69
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 69
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: 43.00, total records: 5407
Average version length: 72.18, total versions: 2187, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.16
Pointer pages: 2, data page slots: 1048
Data pages: 354, average fill: 20%
Primary pages: 354, secondary pages: 0, swept pages: 222
Empty pages: 126, full pages: 20
Fill distribution:
0 - 19% = 219
20 - 39% = 66
40 - 59% = 36
60 - 79% = 27
80 - 99% = 6

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1235, depth: 2, leaf buckets: 11, nodes: 5407
Average node length: 6.64, total dup: 4714, max dup: 14
Average key length: 4.64, compression ratio: 7.97
Average prefix length: 34.48, average data length: 2.52
Clustering factor: 788, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 4
60 - 79% = 1
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: 855731
Average version length: 71.84, total versions: 6623, 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: 8, data page slots: 13024
Data pages: 13008, average fill: 72%
Primary pages: 13008, secondary pages: 0, swept pages: 8535
Empty pages: 67, full pages: 9194
Fill distribution:
0 - 19% = 98
20 - 39% = 136
40 - 59% = 712
60 - 79% = 12024
80 - 99% = 38

Index XQD_1000_3300_DOC (1)
Root page: 299148, depth: 3, leaf buckets: 962, nodes: 855731
Average node length: 5.11, total dup: 832748, max dup: 120
Average key length: 2.20, compression ratio: 4.09
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 122911, ratio: 0.14
Fill distribution:
0 - 19% = 22
20 - 39% = 90
40 - 59% = 636
60 - 79% = 35
80 - 99% = 179

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 123237, depth: 3, leaf buckets: 1281, nodes: 855731
Average node length: 6.24, total dup: 746804, max dup: 19
Average key length: 3.32, compression ratio: 11.13
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 190164, ratio: 0.22
Fill distribution:
0 - 19% = 27
20 - 39% = 183
40 - 59% = 787
60 - 79% = 157
80 - 99% = 127

XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 31.63, total records: 29975
Average version length: 71.99, total versions: 16826, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.30
Pointer pages: 2, data page slots: 2560
Data pages: 1464, average fill: 27%
Primary pages: 1464, secondary pages: 0, swept pages: 619
Empty pages: 529, full pages: 149
Fill distribution:
0 - 19% = 758
20 - 39% = 254
40 - 59% = 203
60 - 79% = 176
80 - 99% = 73

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 52, nodes: 29975
Average node length: 5.92, total dup: 25862, max dup: 49
Average key length: 3.77, compression ratio: 9.82
Average prefix length: 35.37, average data length: 1.63
Clustering factor: 3587, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 26
40 - 59% = 15
60 - 79% = 8
80 - 99% = 2

XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 69.98, total records: 1385946
Average version length: 71.94, total versions: 42318, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.94
Pointer pages: 14, data page slots: 21248
Data pages: 21216, average fill: 72%
Primary pages: 21216, secondary pages: 0, swept pages: 10641
Empty pages: 133, full pages: 15378
Fill distribution:
0 - 19% = 251
20 - 39% = 425
40 - 59% = 1755
60 - 79% = 17845
80 - 99% = 940

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 107466, depth: 3, leaf buckets: 2166, nodes: 1385946
Average node length: 5.60, total dup: 1302930, max dup: 49
Average key length: 2.65, compression ratio: 13.94
Average prefix length: 36.41, average data length: 0.59
Clustering factor: 202423, ratio: 0.15
Fill distribution:
0 - 19% = 13
20 - 39% = 1074
40 - 59% = 679
60 - 79% = 239
80 - 99% = 161

XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 3.47, total records: 7320
Average version length: 72.09, total versions: 6964, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 39.23
Pointer pages: 2, data page slots: 1720
Data pages: 712, average fill: 14%
Primary pages: 711, secondary pages: 1, swept pages: 394
Empty pages: 436, full pages: 60
Fill distribution:
0 - 19% = 550
20 - 39% = 54
40 - 59% = 27
60 - 79% = 53
80 - 99% = 28

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1530, depth: 2, leaf buckets: 15, nodes: 7320
Average node length: 6.29, total dup: 6617, max dup: 57
Average key length: 4.08, compression ratio: 9.08
Average prefix length: 35.02, average data length: 1.98
Clustering factor: 799, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 3
60 - 79% = 1
80 - 99% = 1

XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 70.99, total records: 2162441
Average version length: 71.19, total versions: 12064, 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: 19, data page slots: 30728
Data pages: 30728, average fill: 76%
Primary pages: 30728, secondary pages: 0, swept pages: 21858
Empty pages: 8, full pages: 28723
Fill distribution:
0 - 19% = 12
20 - 39% = 28
40 - 59% = 264
60 - 79% = 30167
80 - 99% = 257

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4862, nodes: 2162441
Average node length: 7.00, total dup: 1718822, max dup: 14
Average key length: 4.04, compression ratio: 9.16
Average prefix length: 35.17, average data length: 1.83
Clustering factor: 450302, ratio: 0.21
Fill distribution:
0 - 19% = 5
20 - 39% = 3231
40 - 59% = 1267
60 - 79% = 210
80 - 99% = 149

XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 83.68, total records: 3627297
Average version length: 82.94, total versions: 2633, 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: 35, data page slots: 55888
Data pages: 55888, average fill: 80%
Primary pages: 55888, secondary pages: 0, swept pages: 23581
Empty pages: 5, full pages: 55719
Fill distribution:
0 - 19% = 7
20 - 39% = 4
40 - 59% = 9
60 - 79% = 20159
80 - 99% = 35709

Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3797, nodes: 3627297
Average node length: 5.15, total dup: 3544462, max dup: 126
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 600730, ratio: 0.17
Fill distribution:
0 - 19% = 10
20 - 39% = 55
40 - 59% = 1822
60 - 79% = 1647
80 - 99% = 263

Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 4566, nodes: 3627297
Average node length: 5.70, total dup: 3237264, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 214636, ratio: 0.06
Fill distribution:
0 - 19% = 33
20 - 39% = 284
40 - 59% = 3263
60 - 79% = 145
80 - 99% = 841

Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 4213, nodes: 3627297
Average node length: 5.80, total dup: 3173178, max dup: 29
Average key length: 2.82, compression ratio: 3.20
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 643094, ratio: 0.18
Fill distribution:
0 - 19% = 8
20 - 39% = 88
40 - 59% = 1825
60 - 79% = 1953
80 - 99% = 339

XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 82.93, total records: 1881706
Average version length: 83.67, total versions: 10503, 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: 29416
Data pages: 29416, average fill: 79%
Primary pages: 29416, secondary pages: 0, swept pages: 20676
Empty pages: 11, full pages: 28331
Fill distribution:
0 - 19% = 23
20 - 39% = 24
40 - 59% = 149
60 - 79% = 13527
80 - 99% = 15693

Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1968, nodes: 1881706
Average node length: 5.14, total dup: 1837166, max dup: 192
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 380184, ratio: 0.20
Fill distribution:
0 - 19% = 2
20 - 39% = 33
40 - 59% = 1037
60 - 79% = 659
80 - 99% = 237

Index XQS_1000_3300_RCV_ID (2)
Root page: 112481, depth: 3, leaf buckets: 3479, nodes: 1881706
Average node length: 6.35, total dup: 1508801, max dup: 14
Average key length: 3.39, compression ratio: 2.66
Average prefix length: 7.81, average data length: 1.19
Clustering factor: 247310, ratio: 0.13
Fill distribution:
0 - 19% = 89
20 - 39% = 1685
40 - 59% = 1224
60 - 79% = 318
80 - 99% = 163

Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 2211, nodes: 1881706
Average node length: 5.79, total dup: 1646167, max dup: 44
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 422774, ratio: 0.22
Fill distribution:
0 - 19% = 5
20 - 39% = 37
40 - 59% = 1179
60 - 79% = 715
80 - 99% = 275

XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.61, total records: 3877175
Average version length: 84.64, total versions: 14057, 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: 38, data page slots: 60400
Data pages: 60344, average fill: 80%
Primary pages: 60344, secondary pages: 0, swept pages: 17825
Empty pages: 173, full pages: 58242
Fill distribution:
0 - 19% = 212
20 - 39% = 141
40 - 59% = 486
60 - 79% = 17072
80 - 99% = 42433

Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4195, nodes: 3877175
Average node length: 5.04, total dup: 3854545, max dup: 694
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 682930, ratio: 0.18
Fill distribution:
0 - 19% = 3
20 - 39% = 370
40 - 59% = 2193
60 - 79% = 1272
80 - 99% = 357

Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 5146, nodes: 3877175
Average node length: 5.49, total dup: 3589367, max dup: 49
Average key length: 2.50, compression ratio: 3.60
Average prefix length: 8.57, average data length: 0.43
Clustering factor: 275762, ratio: 0.07
Fill distribution:
0 - 19% = 66
20 - 39% = 1571
40 - 59% = 2318
60 - 79% = 523
80 - 99% = 668

Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 4707, nodes: 3877175
Average node length: 5.69, total dup: 3468672, max dup: 104
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 731335, ratio: 0.19
Fill distribution:
0 - 19% = 7
20 - 39% = 319
40 - 59% = 2565
60 - 79% = 1351
80 - 99% = 465

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.38, total records: 2528304
Average version length: 84.35, total versions: 9170, 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: 25, data page slots: 39600
Data pages: 39600, average fill: 79%
Primary pages: 39600, secondary pages: 0, swept pages: 27701
Empty pages: 5, full pages: 38129
Fill distribution:
0 - 19% = 8
20 - 39% = 36
40 - 59% = 260
60 - 79% = 17682
80 - 99% = 21614

Index XQS_2100_3300_DOC_ID (0)
Root page: 90515, depth: 3, leaf buckets: 2816, nodes: 2528304
Average node length: 5.02, total dup: 2516338, max dup: 1363
Average key length: 2.04, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 467460, ratio: 0.18
Fill distribution:
0 - 19% = 26
20 - 39% = 370
40 - 59% = 1508
60 - 79% = 618
80 - 99% = 294

Index XQS_2100_3300_RCV_ID (2)
Root page: 92303, depth: 3, leaf buckets: 4701, nodes: 2528304
Average node length: 6.36, total dup: 2027218, max dup: 14
Average key length: 3.39, compression ratio: 2.66
Average prefix length: 7.81, average data length: 1.19
Clustering factor: 373419, ratio: 0.15
Fill distribution:
0 - 19% = 162
20 - 39% = 2399
40 - 59% = 1437
60 - 79% = 426
80 - 99% = 277

Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 3051, nodes: 2528304
Average node length: 5.54, total dup: 2320220, max dup: 76
Average key length: 2.56, compression ratio: 3.51
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 507982, ratio: 0.20
Fill distribution:
0 - 19% = 16
20 - 39% = 360
40 - 59% = 1551
60 - 79% = 788
80 - 99% = 336

XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 69.02, total records: 370365
Average version length: 69.08, total versions: 1608, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 4, data page slots: 5112
Data pages: 5112, average fill: 77%
Primary pages: 5112, secondary pages: 0, swept pages: 3918
Empty pages: 5, full pages: 4966
Fill distribution:
0 - 19% = 8
20 - 39% = 10
40 - 59% = 19
60 - 79% = 5042
80 - 99% = 33

Index XQS_3300_3400_DOC_ID (0)
Root page: 2703, depth: 2, leaf buckets: 427, nodes: 370365
Average node length: 5.39, total dup: 340976, max dup: 114
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 40326, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 56
40 - 59% = 191
60 - 79% = 130
80 - 99% = 49

Index XQS_3300_3400_SND_ID (1)
Root page: 2473, depth: 2, leaf buckets: 477, nodes: 370365
Average node length: 5.94, total dup: 311880, max dup: 14
Average key length: 3.15, compression ratio: 2.85
Average prefix length: 8.00, average data length: 1.00
Clustering factor: 44180, ratio: 0.12
Fill distribution:
0 - 19% = 2
20 - 39% = 87
40 - 59% = 179
60 - 79% = 157
80 - 99% = 52

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 20310 ms, from 8:10:06.71 to 8:10:27.02.

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 1684175 2849 0.1691
DOC_LIST 574299 1691 0.2944
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 2895 719 24.8359
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 113 93 82.3008
OPTYPES 9 0 0.0000
PDISTR 211224 1582 0.7489
PERF_ESTIMATED 243044 0 0.0000
PERF_LOG 10408744 0 0.0000
PSTORNED 320714 834 0.2600
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 5971 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 5407 2187 40.4475
XQD_1000_3300 855731 6623 0.7739
XQD_1200_2000 29975 16826 56.1334
XQD_2000_3300 1385946 42318 3.0533
XQD_2100_3300 7320 6964 95.1366
XQD_3300_3400 2162441 12064 0.5578
XQS_1000_1200 3627297 2633 0.0725
XQS_1000_3300 1881706 10503 0.5581
XQS_1200_2000 3877175 14057 0.3625
XQS_2100_3300 2528304 9170 0.3626
XQS_3300_3400 370365 1608 0.4341
Z_USED_VIEWS 29 0 0.0000
Done for 2540 ms, from 8:10:35.28 to 8:10:37.82.

Database validation

08:10:38.04 Validation started

08:10:38.04 Relation 140 (DOC_LIST)
08:10:38.04 process pointer page 0 of 5
08:10:38.09 process pointer page 1 of 5
08:10:38.12 process pointer page 2 of 5
08:10:38.15 process pointer page 3 of 5
08:10:38.18 process pointer page 4 of 5
08:10:38.19 Index 1 (PK_DOC_LIST)
08:10:38.29 Index 2 (DOC_LIST_ID_DESC)
08:10:38.37 Index 3 (FK_DOC_LIST_AGENTS)
08:10:38.43 Relation 140 (DOC_LIST) is ok

08:10:38.43 Relation 141 (DOC_DATA)
08:10:38.43 process pointer page 0 of 12
08:10:38.46 process pointer page 1 of 12
08:10:38.48 process pointer page 2 of 12
08:10:38.51 process pointer page 3 of 12
08:10:38.54 process pointer page 4 of 12
08:10:38.57 process pointer page 5 of 12
08:10:38.63 process pointer page 6 of 12
08:10:38.72 process pointer page 7 of 12
08:10:38.82 process pointer page 8 of 12
08:10:38.87 process pointer page 9 of 12
08:10:38.90 process pointer page 10 of 12
08:10:38.93 process pointer page 11 of 12
08:10:38.94 Index 2 (DOC_DATA_DOC_WARE_UNQ)
08:10:39.24 Index 3 (DOC_DATA_ID_DESC)
08:10:39.61 Index 4 (FK_DOC_DATA_DOC_LIST)
08:10:39.82 Relation 141 (DOC_DATA) is ok

08:10:39.82 Relation 147 (INVNT_SALDO)
08:10:39.82 process pointer page 0 of 2
08:10:39.82 process pointer page 1 of 2
08:10:39.82 Index 1 (PK_INVNT_SALDO)
08:10:39.82 Relation 147 (INVNT_SALDO) is ok

08:10:39.82 Relation 150 (PDISTR)
08:10:39.82 process pointer page 0 of 2
08:10:39.85 process pointer page 1 of 2
08:10:39.86 Index 2 (PDISTR_SND_ID)
08:10:39.88 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
08:10:39.89 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
08:10:39.91 Index 5 (PDISTR_AGENT_ID)
08:10:39.93 Relation 150 (PDISTR) is ok

08:10:39.93 Relation 151 (PSTORNED)
08:10:39.93 process pointer page 0 of 3
08:10:39.96 process pointer page 1 of 3
08:10:39.99 process pointer page 2 of 3
08:10:40.00 Index 2 (PSTORNED_SND_ID)
08:10:40.04 Index 3 (PSTORNED_RCV_ID)
08:10:40.07 Relation 151 (PSTORNED) is ok

08:10:40.07 Relation 156 (SEMAPHORES)
08:10:40.07 process pointer page 0 of 1
08:10:40.07 Index 1 (PK_SEMAPHORES)
08:10:40.07 Index 2 (SEMAPHORES_TASK_UNQ)
08:10:40.07 Relation 156 (SEMAPHORES) is ok

08:10:40.07 Relation 157 (INVNT_TURNOVER_LOG)
08:10:40.07 process pointer page 0 of 1
08:10:40.07 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
08:10:40.07 Relation 157 (INVNT_TURNOVER_LOG) is ok

08:10:40.07 Relation 160 (PERF_ESTIMATED)
08:10:40.07 process pointer page 0 of 2
08:10:40.10 process pointer page 1 of 2
08:10:40.10 Index 1 (PERF_EST_MINUTE_SINCE_START)
08:10:40.13 Relation 160 (PERF_ESTIMATED) is ok

08:10:40.13 Relation 161 (PERF_ISQL_STAT)
08:10:40.13 process pointer page 0 of 1
08:10:40.13 Index 1 (PERF_ISQL_STAT_TRN)
08:10:40.13 Relation 161 (PERF_ISQL_STAT) is ok

08:10:40.13 Relation 162 (PERF_LOG)
08:10:40.13 process pointer page 0 of 149
08:10:40.21 process pointer page 1 of 149
08:10:40.27 process pointer page 2 of 149
08:10:40.35 process pointer page 3 of 149
08:10:40.43 process pointer page 4 of 149
08:10:40.52 process pointer page 5 of 149
08:10:40.55 process pointer page 6 of 149
08:10:40.58 process pointer page 7 of 149
08:10:40.61 process pointer page 8 of 149
08:10:40.64 process pointer page 9 of 149
08:10:40.67 process pointer page 10 of 149
08:10:40.71 process pointer page 11 of 149
08:10:40.74 process pointer page 12 of 149
08:10:40.82 process pointer page 13 of 149
08:10:40.85 process pointer page 14 of 149
08:10:40.89 process pointer page 15 of 149
08:10:40.97 process pointer page 16 of 149
08:10:41.00 process pointer page 17 of 149
08:10:41.03 process pointer page 18 of 149
08:10:41.06 process pointer page 19 of 149
08:10:41.10 process pointer page 20 of 149
08:10:41.13 process pointer page 21 of 149
08:10:41.21 process pointer page 22 of 149
08:10:41.27 process pointer page 23 of 149
08:10:41.35 process pointer page 24 of 149
08:10:41.39 process pointer page 25 of 149
08:10:41.42 process pointer page 26 of 149
08:10:41.45 process pointer page 27 of 149
08:10:41.49 process pointer page 28 of 149
08:10:41.50 process pointer page 29 of 149
08:10:41.55 process pointer page 30 of 149
08:10:41.60 process pointer page 31 of 149
08:10:41.63 process pointer page 32 of 149
08:10:41.66 process pointer page 33 of 149
08:10:41.69 process pointer page 34 of 149
08:10:41.77 process pointer page 35 of 149
08:10:41.80 process pointer page 36 of 149
08:10:41.83 process pointer page 37 of 149
08:10:41.86 process pointer page 38 of 149
08:10:41.91 process pointer page 39 of 149
08:10:41.94 process pointer page 40 of 149
08:10:41.97 process pointer page 41 of 149
08:10:42.00 process pointer page 42 of 149
08:10:42.03 process pointer page 43 of 149
08:10:42.06 process pointer page 44 of 149
08:10:42.09 process pointer page 45 of 149
08:10:42.13 process pointer page 46 of 149
08:10:42.14 process pointer page 47 of 149
08:10:42.17 process pointer page 48 of 149
08:10:42.19 process pointer page 49 of 149
08:10:42.22 process pointer page 50 of 149
08:10:42.23 process pointer page 51 of 149
08:10:42.25 process pointer page 52 of 149
08:10:42.28 process pointer page 53 of 149
08:10:42.30 process pointer page 54 of 149
08:10:42.33 process pointer page 55 of 149
08:10:42.34 process pointer page 56 of 149
08:10:42.36 process pointer page 57 of 149
08:10:42.39 process pointer page 58 of 149
08:10:42.41 process pointer page 59 of 149
08:10:42.42 process pointer page 60 of 149
08:10:42.45 process pointer page 61 of 149
08:10:42.48 process pointer page 62 of 149
08:10:42.50 process pointer page 63 of 149
08:10:42.53 process pointer page 64 of 149
08:10:42.56 process pointer page 65 of 149
08:10:42.62 process pointer page 66 of 149
08:10:42.69 process pointer page 67 of 149
08:10:42.72 process pointer page 68 of 149
08:10:42.75 process pointer page 69 of 149
08:10:42.78 process pointer page 70 of 149
08:10:42.86 process pointer page 71 of 149
08:10:42.94 process pointer page 72 of 149
08:10:43.01 process pointer page 73 of 149
08:10:43.09 process pointer page 74 of 149
08:10:43.17 process pointer page 75 of 149
08:10:43.23 process pointer page 76 of 149
08:10:43.26 process pointer page 77 of 149
08:10:43.31 process pointer page 78 of 149
08:10:43.34 process pointer page 79 of 149
08:10:43.37 process pointer page 80 of 149
08:10:43.40 process pointer page 81 of 149
08:10:43.44 process pointer page 82 of 149
08:10:43.47 process pointer page 83 of 149
08:10:43.50 process pointer page 84 of 149
08:10:43.53 process pointer page 85 of 149
08:10:43.55 process pointer page 86 of 149
08:10:43.56 process pointer page 87 of 149
08:10:43.59 process pointer page 88 of 149
08:10:43.61 process pointer page 89 of 149
08:10:43.62 process pointer page 90 of 149
08:10:43.65 process pointer page 91 of 149
08:10:43.69 process pointer page 92 of 149
08:10:43.72 process pointer page 93 of 149
08:10:43.75 process pointer page 94 of 149
08:10:43.78 process pointer page 95 of 149
08:10:43.79 process pointer page 96 of 149
08:10:43.83 process pointer page 97 of 149
08:10:43.84 process pointer page 98 of 149
08:10:43.87 process pointer page 99 of 149
08:10:43.90 process pointer page 100 of 149
08:10:43.92 process pointer page 101 of 149
08:10:43.98 process pointer page 102 of 149
08:10:44.06 process pointer page 103 of 149
08:10:44.11 process pointer page 104 of 149
08:10:44.15 process pointer page 105 of 149
08:10:44.23 process pointer page 106 of 149
08:10:44.29 process pointer page 107 of 149
08:10:44.37 process pointer page 108 of 149
08:10:44.43 process pointer page 109 of 149
08:10:44.47 process pointer page 110 of 149
08:10:44.50 process pointer page 111 of 149
08:10:44.53 process pointer page 112 of 149
08:10:44.57 process pointer page 113 of 149
08:10:44.61 process pointer page 114 of 149
08:10:44.62 process pointer page 115 of 149
08:10:44.65 process pointer page 116 of 149
08:10:44.68 process pointer page 117 of 149
08:10:44.72 process pointer page 118 of 149
08:10:44.73 process pointer page 119 of 149
08:10:44.76 process pointer page 120 of 149
08:10:44.79 process pointer page 121 of 149
08:10:44.81 process pointer page 122 of 149
08:10:44.84 process pointer page 123 of 149
08:10:44.86 process pointer page 124 of 149
08:10:44.89 process pointer page 125 of 149
08:10:44.92 process pointer page 126 of 149
08:10:44.93 process pointer page 127 of 149
08:10:44.96 process pointer page 128 of 149
08:10:44.98 process pointer page 129 of 149
08:10:45.01 process pointer page 130 of 149
08:10:45.03 process pointer page 131 of 149
08:10:45.04 process pointer page 132 of 149
08:10:45.07 process pointer page 133 of 149
08:10:45.09 process pointer page 134 of 149
08:10:45.12 process pointer page 135 of 149
08:10:45.14 process pointer page 136 of 149
08:10:45.15 process pointer page 137 of 149
08:10:45.18 process pointer page 138 of 149
08:10:45.21 process pointer page 139 of 149
08:10:45.25 process pointer page 140 of 149
08:10:45.26 process pointer page 141 of 149
08:10:45.34 process pointer page 142 of 149
08:10:45.42 process pointer page 143 of 149
08:10:45.45 process pointer page 144 of 149
08:10:45.48 process pointer page 145 of 149
08:10:45.51 process pointer page 146 of 149
08:10:45.54 process pointer page 147 of 149
08:10:45.57 process pointer page 148 of 149
08:10:45.59 Index 1 (PERF_LOG_DTS_BEG_DESC)
08:10:46.77 Index 2 (PERF_LOG_UNIT)
08:10:49.58 Index 3 (PERF_LOG_TRN_DESC)
08:10:50.97 Index 4 (PERF_LOG_GDSCODE)
08:10:51.69 Relation 162 (PERF_LOG) is ok

08:10:51.69 Relation 166 (V_STOPTEST)
08:10:51.69 Relation 166 (V_STOPTEST) is ok

08:10:51.69 Relation 183 (V_QDISTR_SOURCE)
08:10:51.69 Relation 183 (V_QDISTR_SOURCE) is ok

08:10:51.69 Relation 184 (V_QSTORNED_SOURCE)
08:10:51.69 Relation 184 (V_QSTORNED_SOURCE) is ok

08:10:51.69 Relation 259 (XQD_1000_1200)
08:10:51.69 process pointer page 0 of 2
08:10:51.69 process pointer page 1 of 2
08:10:51.69 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
08:10:51.69 Relation 259 (XQD_1000_1200) is ok

08:10:51.69 Relation 260 (XQD_1200_2000)
08:10:51.69 process pointer page 0 of 2
08:10:51.72 process pointer page 1 of 2
08:10:51.72 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
08:10:51.74 Relation 260 (XQD_1200_2000) is ok

08:10:51.74 Relation 261 (XQD_1000_3300)
08:10:51.74 process pointer page 0 of 8
08:10:51.81 process pointer page 1 of 8
08:10:51.86 process pointer page 2 of 8
08:10:51.89 process pointer page 3 of 8
08:10:51.95 process pointer page 4 of 8
08:10:51.98 process pointer page 5 of 8
08:10:52.02 process pointer page 6 of 8
08:10:52.05 process pointer page 7 of 8
08:10:52.08 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
08:10:52.19 Index 2 (XQD_1000_3300_DOC)
08:10:52.27 Relation 261 (XQD_1000_3300) is ok

08:10:52.27 Relation 262 (XQD_2000_3300)
08:10:52.27 process pointer page 0 of 14
08:10:52.36 process pointer page 1 of 14
08:10:52.41 process pointer page 2 of 14
08:10:52.45 process pointer page 3 of 14
08:10:52.48 process pointer page 4 of 14
08:10:52.52 process pointer page 5 of 14
08:10:52.56 process pointer page 6 of 14
08:10:52.59 process pointer page 7 of 14
08:10:52.62 process pointer page 8 of 14
08:10:52.66 process pointer page 9 of 14
08:10:52.69 process pointer page 10 of 14
08:10:52.72 process pointer page 11 of 14
08:10:52.75 process pointer page 12 of 14
08:10:52.78 process pointer page 13 of 14
08:10:52.78 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
08:10:52.91 Relation 262 (XQD_2000_3300) is ok

08:10:52.91 Relation 263 (XQD_2100_3300)
08:10:52.91 process pointer page 0 of 2
08:10:52.92 process pointer page 1 of 2
08:10:52.92 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
08:10:52.92 Relation 263 (XQD_2100_3300) is ok

08:10:52.92 Relation 264 (XQD_3300_3400)
08:10:52.92 process pointer page 0 of 19
08:10:53.00 process pointer page 1 of 19
08:10:53.08 process pointer page 2 of 19
08:10:53.17 process pointer page 3 of 19
08:10:53.23 process pointer page 4 of 19
08:10:53.26 process pointer page 5 of 19
08:10:53.31 process pointer page 6 of 19
08:10:53.34 process pointer page 7 of 19
08:10:53.37 process pointer page 8 of 19
08:10:53.40 process pointer page 9 of 19
08:10:53.44 process pointer page 10 of 19
08:10:53.47 process pointer page 11 of 19
08:10:53.50 process pointer page 12 of 19
08:10:53.51 process pointer page 13 of 19
08:10:53.54 process pointer page 14 of 19
08:10:53.58 process pointer page 15 of 19
08:10:53.59 process pointer page 16 of 19
08:10:53.62 process pointer page 17 of 19
08:10:53.64 process pointer page 18 of 19
08:10:53.67 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
08:10:53.92 Relation 264 (XQD_3300_3400) is ok

08:10:53.92 Relation 265 (XQS_1000_1200)
08:10:53.92 process pointer page 0 of 35
08:10:53.95 process pointer page 1 of 35
08:10:53.98 process pointer page 2 of 35
08:10:54.01 process pointer page 3 of 35
08:10:54.04 process pointer page 4 of 35
08:10:54.08 process pointer page 5 of 35
08:10:54.11 process pointer page 6 of 35
08:10:54.14 process pointer page 7 of 35
08:10:54.15 process pointer page 8 of 35
08:10:54.18 process pointer page 9 of 35
08:10:54.22 process pointer page 10 of 35
08:10:54.25 process pointer page 11 of 35
08:10:54.28 process pointer page 12 of 35
08:10:54.31 process pointer page 13 of 35
08:10:54.34 process pointer page 14 of 35
08:10:54.37 process pointer page 15 of 35
08:10:54.40 process pointer page 16 of 35
08:10:54.43 process pointer page 17 of 35
08:10:54.47 process pointer page 18 of 35
08:10:54.53 process pointer page 19 of 35
08:10:54.61 process pointer page 20 of 35
08:10:54.64 process pointer page 21 of 35
08:10:54.67 process pointer page 22 of 35
08:10:54.70 process pointer page 23 of 35
08:10:54.73 process pointer page 24 of 35
08:10:54.76 process pointer page 25 of 35
08:10:54.79 process pointer page 26 of 35
08:10:54.82 process pointer page 27 of 35
08:10:54.86 process pointer page 28 of 35
08:10:54.89 process pointer page 29 of 35
08:10:54.92 process pointer page 30 of 35
08:10:54.95 process pointer page 31 of 35
08:10:54.98 process pointer page 32 of 35
08:10:55.01 process pointer page 33 of 35
08:10:55.03 process pointer page 34 of 35
08:10:55.04 Index 1 (XQS_1000_1200_DOC_ID)
08:10:55.54 Index 2 (XQS_1000_1200_SND_ID)
08:10:56.10 Index 3 (XQS_1000_1200_RCV_ID)
08:10:56.46 Relation 265 (XQS_1000_1200) is ok

08:10:56.46 Relation 266 (XQS_1200_2000)
08:10:56.46 process pointer page 0 of 38
08:10:56.49 process pointer page 1 of 38
08:10:56.54 process pointer page 2 of 38
08:10:56.59 process pointer page 3 of 38
08:10:56.62 process pointer page 4 of 38
08:10:56.65 process pointer page 5 of 38
08:10:56.68 process pointer page 6 of 38
08:10:56.77 process pointer page 7 of 38
08:10:56.82 process pointer page 8 of 38
08:10:56.85 process pointer page 9 of 38
08:10:56.88 process pointer page 10 of 38
08:10:56.91 process pointer page 11 of 38
08:10:56.95 process pointer page 12 of 38
08:10:56.98 process pointer page 13 of 38
08:10:57.01 process pointer page 14 of 38
08:10:57.04 process pointer page 15 of 38
08:10:57.07 process pointer page 16 of 38
08:10:57.10 process pointer page 17 of 38
08:10:57.13 process pointer page 18 of 38
08:10:57.21 process pointer page 19 of 38
08:10:57.26 process pointer page 20 of 38
08:10:57.29 process pointer page 21 of 38
08:10:57.32 process pointer page 22 of 38
08:10:57.41 process pointer page 23 of 38
08:10:57.51 process pointer page 24 of 38
08:10:57.55 process pointer page 25 of 38
08:10:57.59 process pointer page 26 of 38
08:10:57.63 process pointer page 27 of 38
08:10:57.66 process pointer page 28 of 38
08:10:57.69 process pointer page 29 of 38
08:10:57.74 process pointer page 30 of 38
08:10:57.77 process pointer page 31 of 38
08:10:57.82 process pointer page 32 of 38
08:10:57.85 process pointer page 33 of 38
08:10:57.88 process pointer page 34 of 38
08:10:57.91 process pointer page 35 of 38
08:10:57.94 process pointer page 36 of 38
08:10:57.98 process pointer page 37 of 38
08:10:57.98 Index 1 (XQS_1200_2000_DOC_ID)
08:10:58.38 Index 2 (XQS_1200_2000_SND_ID)
08:10:59.13 Index 3 (XQS_1200_2000_RCV_ID)
08:10:59.65 Relation 266 (XQS_1200_2000) is ok

08:10:59.65 Relation 267 (XQS_1000_3300)
08:10:59.65 process pointer page 0 of 19
08:10:59.68 process pointer page 1 of 19
08:10:59.71 process pointer page 2 of 19
08:10:59.74 process pointer page 3 of 19
08:10:59.76 process pointer page 4 of 19
08:10:59.79 process pointer page 5 of 19
08:10:59.81 process pointer page 6 of 19
08:10:59.84 process pointer page 7 of 19
08:10:59.86 process pointer page 8 of 19
08:10:59.89 process pointer page 9 of 19
08:10:59.91 process pointer page 10 of 19
08:10:59.94 process pointer page 11 of 19
08:10:59.97 process pointer page 12 of 19
08:11:00.00 process pointer page 13 of 19
08:11:00.02 process pointer page 14 of 19
08:11:00.05 process pointer page 15 of 19
08:11:00.07 process pointer page 16 of 19
08:11:00.10 process pointer page 17 of 19
08:11:00.12 process pointer page 18 of 19
08:11:00.12 Index 1 (XQS_1000_3300_DOC_ID)
08:11:00.34 Index 2 (XQS_1000_3300_SND_ID)
08:11:00.54 Index 3 (XQS_1000_3300_RCV_ID)
08:11:00.72 Relation 267 (XQS_1000_3300) is ok

08:11:00.76 Relation 268 (XQS_2000_3300)
08:11:00.76 process pointer page 0 of 1
08:11:00.76 Index 1 (XQS_2000_3300_DOC_ID)
08:11:00.77 Index 2 (XQS_2000_3300_SND_ID)
08:11:00.77 Index 3 (XQS_2000_3300_RCV_ID)
08:11:00.77 Relation 268 (XQS_2000_3300) is ok

08:11:00.77 Relation 269 (XQS_2100_3300)
08:11:00.77 process pointer page 0 of 25
08:11:00.80 process pointer page 1 of 25
08:11:00.83 process pointer page 2 of 25
08:11:00.87 process pointer page 3 of 25
08:11:00.90 process pointer page 4 of 25
08:11:00.93 process pointer page 5 of 25
08:11:00.96 process pointer page 6 of 25
08:11:00.97 process pointer page 7 of 25
08:11:01.02 process pointer page 8 of 25
08:11:01.05 process pointer page 9 of 25
08:11:01.07 process pointer page 10 of 25
08:11:01.10 process pointer page 11 of 25
08:11:01.13 process pointer page 12 of 25
08:11:01.15 process pointer page 13 of 25
08:11:01.18 process pointer page 14 of 25
08:11:01.21 process pointer page 15 of 25
08:11:01.24 process pointer page 16 of 25
08:11:01.26 process pointer page 17 of 25
08:11:01.29 process pointer page 18 of 25
08:11:01.30 process pointer page 19 of 25
08:11:01.33 process pointer page 20 of 25
08:11:01.35 process pointer page 21 of 25
08:11:01.38 process pointer page 22 of 25
08:11:01.41 process pointer page 23 of 25
08:11:01.43 process pointer page 24 of 25
08:11:01.44 Index 1 (XQS_2100_3300_DOC_ID)
08:11:01.69 Index 2 (XQS_2100_3300_SND_ID)
08:11:02.16 Index 3 (XQS_2100_3300_RCV_ID)
08:11:02.49 Relation 269 (XQS_2100_3300) is ok

08:11:02.49 Relation 270 (XQS_3300_3400)
08:11:02.49 process pointer page 0 of 4
08:11:02.52 process pointer page 1 of 4
08:11:02.55 process pointer page 2 of 4
08:11:02.57 process pointer page 3 of 4
08:11:02.58 Index 1 (XQS_3300_3400_DOC_ID)
08:11:02.60 Index 2 (XQS_3300_3400_SND_ID)
08:11:02.64 Relation 270 (XQS_3300_3400) is ok

08:11:02.64 Relation 276 (TRACE_STAT)
08:11:02.64 process pointer page 0 of 1
08:11:02.64 Relation 276 (TRACE_STAT) is ok

08:11:02.64 Validation finished
Done for 24760 ms, from 8:10:37.88 to 8:11:02.64.

Differences between old and current firebird.log

8:11:04.09. 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-02-01 08:11 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 Mon Feb 01 08:10:38 2016
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Mon Feb 01 08:11:02 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-02-01 8:11:09.16 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html