Firebird 4.0 Performance Logs

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

Server and database settings

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

Test configuration settings

File: E:\OLTP-EMUL\src\oltp40_config.win
PARAM_NAME PARAM_VALUE
fbc E:\FB40.TMPINSTANCE
dbnm D:\OLTP-EMUL\oltp40-small.fdb
host localhost
port 3400
usr SYSDBA
pwd masterkey
tmpdir e:\temp\logs.oltp40
working_mode small_03
warm_time 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
file_name_this_host_info ak40
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-03-19 07:56:09.3800 -1 <null> ::1/59020 332971 5005 2

Current test settings

CATEGORY SETTING VAL
COMMON TRACED_UNITS ,,
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
COMMON ENABLE_MON_QUERY 0
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: 5098.77 6964 917779 2016-03-19 04:56 2016-03-19 07:56
customer order: creation 396.88 1060 71438 2016-03-19 04:56 2016-03-19 07:56
customer order: refuse 31.04 75 5587 2016-03-19 04:56 2016-03-19 07:56
order to supplier: creation 101.91 7551 18344 2016-03-19 04:56 2016-03-19 07:56
order to supplier: removal 2.19 75329 392 2016-03-19 04:56 2016-03-19 07:56
invoice (draft): creation 102.01 11615 18361 2016-03-19 04:56 2016-03-19 07:56
invoice (draft): removal 34.02 2414 6124 2016-03-19 04:56 2016-03-19 07:56
invoice accept: apply 61.80 21913 11124 2016-03-19 04:56 2016-03-19 07:56
invoice accept: cancel 15.91 4990 2847 2016-03-19 04:56 2016-03-19 07:56
customer reserve: creation 3010.66 405 541918 2016-03-19 04:56 2016-03-19 07:56
customer reserve: removal 805.23 120 144942 2016-03-19 04:56 2016-03-19 07:56
realization accept: apply 179.91 335 32383 2016-03-19 04:56 2016-03-19 07:56
realization accept: cancel 53.09 221 9556 2016-03-19 04:56 2016-03-19 07:56
payment from customer: creation 131.87 355 23736 2016-03-19 04:56 2016-03-19 07:56
payment from customer: removal 12.56 94 2261 2016-03-19 04:56 2016-03-19 07:56
payment to supplier: creation 109.03 780 19625 2016-03-19 04:56 2016-03-19 07:56
payment to supplier: removal 7.94 149 1429 2016-03-19 04:56 2016-03-19 07:56
service: total inventory turnovers 19.83 1527 3569 2016-03-19 04:56 2016-03-19 07:56
service: total monetary turnovers 22.95 72 4131 2016-03-19 04:56 2016-03-19 07:56
service: refresh index statistics 0.07 3312 12 2016-03-19 04:56 2016-03-19 07:56
Done for 110360 ms, from 8:00:56.23 to 8:02:46.59.

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 3208 62520 57739 4781 7.65 04:56:10 05:14:10
interval # 2, overall 2 5053 95300 90956 4344 4.56 05:14:11 05:32:11
interval # 3, overall 3 5386 103009 96948 6061 5.88 05:32:12 05:50:12
interval # 4, overall 4 5481 104037 98661 5376 5.17 05:50:13 06:08:13
interval # 5, overall 5 5562 105167 100121 5046 4.80 06:08:14 06:26:14
interval # 6, overall 6 5256 102424 94606 7818 7.63 06:26:15 06:44:15
interval # 7, overall 7 5168 97426 93027 4399 4.52 06:44:16 07:02:16
interval # 8, overall 8 5136 95821 92451 3370 3.52 07:02:17 07:20:17
interval # 9, overall 9 5488 103804 98788 5016 4.83 07:20:18 07:38:18
interval # 10, overall 10 5249 97204 94482 2722 2.80 07:38:19 07:56:19
Done for 173560 ms, from 8:05:38.77 to 8:08:32.33.

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 5971.32 0.7654 1.1978 2204 98
WARM_TIME 2 4078.98 0.8769 1.1238 1867 74
WARM_TIME 3 3326.02 0.9189 1.0731 1435 56
WARM_TIME 4 2919.37 0.9170 1.0652 1331 55
WARM_TIME 5 2600.38 0.9567 1.0406 893 43
WARM_TIME 6 2359.89 0.9556 1.0486 1015 41
WARM_TIME 7 2207.05 0.9611 1.0398 903 42
WARM_TIME 8 2100.55 0.9560 1.0361 957 42
WARM_TIME 9 1993.96 0.9703 1.0301 818 43
WARM_TIME 10 1928.91 0.9584 1.0325 770 39
TEST_TIME 11 1888.79 0.9586 1.0469 935 52
TEST_TIME 12 1894.87 0.9566 1.0412 1252 52
TEST_TIME 13 1904.65 0.9562 1.0369 1128 59
TEST_TIME 14 1917.50 0.9564 1.0379 1121 65
TEST_TIME 15 1933.71 0.9607 1.0458 1286 69
TEST_TIME 16 1998.34 0.9487 1.0440 1452 75
TEST_TIME 17 2041.11 0.9620 1.0411 1357 72
TEST_TIME 18 2120.61 0.9464 1.0487 1313 81
TEST_TIME 19 2222.54 0.9480 1.0467 1489 89
TEST_TIME 20 2298.35 0.9616 1.0426 1414 88
TEST_TIME 21 2388.50 0.9555 1.0389 1570 94
TEST_TIME 22 2467.13 0.9601 1.0342 1463 97
TEST_TIME 23 2508.58 0.9738 1.0290 1327 95
TEST_TIME 24 2557.18 0.9674 1.0332 1451 94
TEST_TIME 25 2632.93 0.9633 1.0367 1621 96
TEST_TIME 26 2711.18 0.9681 1.0346 1611 96
TEST_TIME 27 2778.97 0.9720 1.0278 1567 99
TEST_TIME 28 2840.35 0.9697 1.0291 1527 97
TEST_TIME 29 2900.42 0.9730 1.0265 1576 96
TEST_TIME 30 2973.58 0.9679 1.0327 2058 97
TEST_TIME 31 3066.45 0.9691 1.0303 1767 96
TEST_TIME 32 3145.71 0.9730 1.0242 1572 97
TEST_TIME 33 3210.79 0.9730 1.0271 1680 98
TEST_TIME 34 3284.79 0.9745 1.0233 1695 97
TEST_TIME 35 3340.34 0.9775 1.0256 1667 97
TEST_TIME 36 3385.67 0.9837 1.0185 1416 95
TEST_TIME 37 3437.73 0.9760 1.0219 1711 96
TEST_TIME 38 3459.00 0.9889 1.0114 1226 87
TEST_TIME 39 3459.91 0.9853 1.0139 1087 84
TEST_TIME 40 3490.79 0.9798 1.0201 1369 96
TEST_TIME 41 3521.80 0.9865 1.0136 1328 95
TEST_TIME 42 3544.54 0.9831 1.0174 1322 95
TEST_TIME 43 3587.51 0.9818 1.0197 1246 96
TEST_TIME 44 3619.74 0.9877 1.0161 1175 92
TEST_TIME 45 3662.89 0.9818 1.0144 1477 95
TEST_TIME 46 3696.39 0.9834 1.0163 1664 95
TEST_TIME 47 3738.59 0.9834 1.0170 1557 94
TEST_TIME 48 3787.82 0.9829 1.0183 1658 96
TEST_TIME 49 3838.84 0.9843 1.0145 1491 96
TEST_TIME 50 3870.78 0.9860 1.0109 1524 92
TEST_TIME 51 3881.87 0.9883 1.0123 1386 91
TEST_TIME 52 3911.67 0.9853 1.0130 1507 95
TEST_TIME 53 3936.11 0.9878 1.0130 1377 95
TEST_TIME 54 3959.18 0.9884 1.0087 1307 93
TEST_TIME 55 3960.92 0.9899 1.0114 1106 88
TEST_TIME 56 3984.47 0.9875 1.0114 1379 95
TEST_TIME 57 3998.84 0.9901 1.0102 1267 93
TEST_TIME 58 4008.51 0.9904 1.0099 1189 92
TEST_TIME 59 4030.05 0.9878 1.0123 1252 94
TEST_TIME 60 4051.72 0.9901 1.0090 1440 98
TEST_TIME 61 4059.99 0.9904 1.0104 1525 98
TEST_TIME 62 4080.68 0.9891 1.0109 1677 95
TEST_TIME 63 4104.92 0.9890 1.0137 1484 95
TEST_TIME 64 4137.90 0.9899 1.0109 1363 94
TEST_TIME 65 4163.14 0.9893 1.0083 1367 93
TEST_TIME 66 4180.45 0.9889 1.0104 1411 94
TEST_TIME 67 4197.41 0.9913 1.0079 1350 92
TEST_TIME 68 4208.04 0.9905 1.0091 1470 93
TEST_TIME 69 4225.70 0.9903 1.0085 1312 94
TEST_TIME 70 4239.27 0.9909 1.0099 1376 94
TEST_TIME 71 4262.51 0.9903 1.0134 1227 98
TEST_TIME 72 4294.79 0.9918 1.0073 1167 96
TEST_TIME 73 4296.31 0.9932 1.0059 1149 92
TEST_TIME 74 4301.08 0.9912 1.0078 1206 92
TEST_TIME 75 4316.28 0.9909 1.0076 1506 93
TEST_TIME 76 4328.02 0.9916 1.0087 1521 95
TEST_TIME 77 4341.50 0.9927 1.0071 1340 92
TEST_TIME 78 4354.58 0.9912 1.0093 1575 93
TEST_TIME 79 4368.53 0.9933 1.0064 1501 95
TEST_TIME 80 4382.58 0.9906 1.0100 1415 95
TEST_TIME 81 4418.86 0.9893 1.0089 1371 98
TEST_TIME 82 4431.46 0.9938 1.0083 1238 94
TEST_TIME 83 4443.25 0.9935 1.0064 1365 92
TEST_TIME 84 4446.48 0.9937 1.0070 1393 91
TEST_TIME 85 4463.26 0.9914 1.0078 1158 92
TEST_TIME 86 4474.44 0.9936 1.0075 1089 96
TEST_TIME 87 4482.60 0.9942 1.0061 1227 94
TEST_TIME 88 4485.81 0.9940 1.0064 1310 94
TEST_TIME 89 4491.92 0.9937 1.0070 1111 95
TEST_TIME 90 4507.24 0.9924 1.0081 1555 95
TEST_TIME 91 4532.84 0.9914 1.0072 1570 95
TEST_TIME 92 4555.12 0.9914 1.0080 1513 95
TEST_TIME 93 4577.91 0.9923 1.0069 1405 96
TEST_TIME 94 4588.43 0.9939 1.0056 1413 93
TEST_TIME 95 4594.84 0.9936 1.0068 1448 94
TEST_TIME 96 4600.93 0.9950 1.0063 1273 91
TEST_TIME 97 4608.29 0.9943 1.0055 1283 91
TEST_TIME 98 4620.21 0.9927 1.0071 1294 92
TEST_TIME 99 4634.21 0.9939 1.0048 1355 94
TEST_TIME 100 4634.61 0.9947 1.0059 1224 95
TEST_TIME 101 4640.64 0.9947 1.0052 1305 95
TEST_TIME 102 4645.71 0.9943 1.0047 1225 95
TEST_TIME 103 4653.26 0.9934 1.0049 1221 95
TEST_TIME 104 4652.09 0.9955 1.0052 1162 91
TEST_TIME 105 4662.42 0.9934 1.0064 1612 94
TEST_TIME 106 4670.44 0.9952 1.0057 1492 92
TEST_TIME 107 4681.83 0.9939 1.0074 1651 94
TEST_TIME 108 4690.74 0.9962 1.0034 1517 91
TEST_TIME 109 4699.79 0.9923 1.0057 1445 96
TEST_TIME 110 4702.52 0.9960 1.0040 1513 94
TEST_TIME 111 4701.23 0.9953 1.0045 1351 92
TEST_TIME 112 4714.83 0.9927 1.0039 1397 92
TEST_TIME 113 4711.84 0.9956 1.0050 1305 93
TEST_TIME 114 4711.00 0.9963 1.0036 1221 91
TEST_TIME 115 4707.23 0.9957 1.0049 1167 91
TEST_TIME 116 4711.57 0.9953 1.0039 1098 91
TEST_TIME 117 4706.80 0.9963 1.0038 1156 91
TEST_TIME 118 4706.82 0.9952 1.0050 1176 90
TEST_TIME 119 4708.99 0.9961 1.0051 1104 94
TEST_TIME 120 4713.66 0.9957 1.0049 1272 92
TEST_TIME 121 4732.44 0.9926 1.0067 1455 96
TEST_TIME 122 4746.26 0.9956 1.0037 1170 95
TEST_TIME 123 4745.39 0.9958 1.0039 1236 93
TEST_TIME 124 4753.61 0.9941 1.0043 1234 93
TEST_TIME 125 4756.83 0.9956 1.0045 1296 92
TEST_TIME 126 4762.20 0.9954 1.0039 1320 92
TEST_TIME 127 4760.88 0.9962 1.0035 1259 90
TEST_TIME 128 4756.67 0.9965 1.0043 1131 92
TEST_TIME 129 4763.12 0.9952 1.0034 1120 85
TEST_TIME 130 4767.02 0.9949 1.0037 1025 86
TEST_TIME 131 4765.55 0.9963 1.0037 1170 91
TEST_TIME 132 4762.88 0.9967 1.0032 1241 90
TEST_TIME 133 4758.02 0.9967 1.0036 1189 90
TEST_TIME 134 4762.33 0.9952 1.0038 1125 91
TEST_TIME 135 4775.24 0.9936 1.0053 1474 94
TEST_TIME 136 4788.34 0.9952 1.0042 1301 94
TEST_TIME 137 4793.85 0.9958 1.0039 1423 93
TEST_TIME 138 4798.20 0.9957 1.0039 1478 94
TEST_TIME 139 4801.44 0.9960 1.0039 1352 95
TEST_TIME 140 4802.67 0.9965 1.0041 1306 93
TEST_TIME 141 4802.33 0.9971 1.0031 1247 91
TEST_TIME 142 4797.62 0.9970 1.0036 1283 89
TEST_TIME 143 4799.67 0.9962 1.0037 1204 94
TEST_TIME 144 4801.03 0.9964 1.0043 1289 94
TEST_TIME 145 4803.05 0.9970 1.0032 1292 92
TEST_TIME 146 4801.70 0.9966 1.0033 1161 94
TEST_TIME 147 4805.41 0.9957 1.0035 1061 95
TEST_TIME 148 4800.79 0.9977 1.0029 1023 88
TEST_TIME 149 4798.29 0.9967 1.0036 1112 91
TEST_TIME 150 4801.11 0.9964 1.0033 1308 91
TEST_TIME 151 4811.75 0.9944 1.0038 1330 91
TEST_TIME 152 4818.32 0.9959 1.0030 1260 90
TEST_TIME 153 4822.28 0.9956 1.0044 1322 95
TEST_TIME 154 4827.60 0.9967 1.0035 1310 95
TEST_TIME 155 4829.89 0.9967 1.0036 1257 91
TEST_TIME 156 4831.25 0.9969 1.0024 1253 91
TEST_TIME 157 4827.49 0.9968 1.0036 1255 90
TEST_TIME 158 4828.66 0.9970 1.0039 1279 92
TEST_TIME 159 4834.14 0.9964 1.0037 1172 93
TEST_TIME 160 4834.41 0.9974 1.0023 1112 91
TEST_TIME 161 4830.09 0.9970 1.0039 1169 88
TEST_TIME 162 4839.56 0.9957 1.0022 1119 87
TEST_TIME 163 4840.41 0.9959 1.0039 1137 92
TEST_TIME 164 4844.51 0.9969 1.0033 1147 95
TEST_TIME 165 4847.35 0.9967 1.0033 1386 92
TEST_TIME 166 4848.52 0.9970 1.0037 1232 90
TEST_TIME 167 4853.30 0.9967 1.0031 1407 95
TEST_TIME 168 4855.52 0.9966 1.0030 1408 92
TEST_TIME 169 4854.15 0.9973 1.0041 1288 92
TEST_TIME 170 4864.88 0.9960 1.0035 1132 93
TEST_TIME 171 4867.64 0.9970 1.0026 1121 90
TEST_TIME 172 4873.78 0.9955 1.0033 1217 91
TEST_TIME 173 4874.39 0.9974 1.0030 1186 89
TEST_TIME 174 4874.55 0.9972 1.0024 1107 91
TEST_TIME 175 4874.79 0.9967 1.0032 1097 90
TEST_TIME 176 4875.61 0.9973 1.0025 1009 85
TEST_TIME 177 4871.78 0.9976 1.0035 1123 90
TEST_TIME 178 4885.10 0.9952 1.0035 1033 91
TEST_TIME 179 4892.46 0.9964 1.0043 938 90
TEST_TIME 180 4901.23 0.9970 1.0029 1220 89
TEST_TIME 181 4906.63 0.9962 1.0036 1225 92
TEST_TIME 182 4914.25 0.9965 1.0029 1103 90
TEST_TIME 183 4916.07 0.9971 1.0022 1168 88
TEST_TIME 184 4913.07 0.9973 1.0020 1277 88
TEST_TIME 185 4910.49 0.9971 1.0024 1237 88
TEST_TIME 186 4913.82 0.9963 1.0043 1166 92
TEST_TIME 187 4919.02 0.9978 1.0031 1185 91
TEST_TIME 188 4929.44 0.9956 1.0036 1105 92
TEST_TIME 189 4931.88 0.9978 1.0025 1181 93
TEST_TIME 190 4922.44 0.9991 1.0041 389 100
Done for 11960 ms, from 8:08:36.04 to 8:08:48.00.

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 2181 7467 6552 4098 5681 <null> 7225 4007 9870 3149 3641 3438 11682 3119 21580 <null> 408588 313815 <null> 04:56:10 05:14:10
fetches per second 2 2014 7160 4021 3843 3960 4404 5534 4206 4979 4655 3788 3979 13126 3601 16871 3645 256333 97391 <null> 05:14:11 05:32:11
fetches per second 3 1838 7885 4491 <null> 4660 2699 6490 4546 6256 3359 5988 4014 19738 3000 25826 2982 291862 250784 <null> 05:32:12 05:50:12
fetches per second 4 1872 6923 5109 4734 5260 3232 5463 4472 8349 3907 3430 4071 36960 6879 28378 3431 363815 288177 <null> 05:50:13 06:08:13
fetches per second 5 1928 6458 4305 3891 4981 2973 5909 <null> 6461 5331 3302 2873 19733 3632 24117 <null> 358480 248448 <null> 06:08:14 06:26:14
fetches per second 6 1847 5838 5921 <null> 6927 <null> 6806 <null> 6700 <null> 5658 2016 23931 2354 26260 3238 361992 <null> <null> 06:26:15 06:44:15
fetches per second 7 1757 6217 5495 3945 5298 <null> 7040 5052 4216 3693 5738 3663 26396 <null> 15047 3181 458387 294392 <null> 06:44:16 07:02:16
fetches per second 8 1786 5884 5891 <null> 5984 2738 6400 <null> 4186 4482 4781 3079 26067 3755 23249 2900 439438 295958 <null> 07:02:17 07:20:17
fetches per second 9 1662 4909 5059 <null> 5968 3119 6436 4233 6702 3851 3928 3009 22944 2588 20769 3377 <null> 217547 <null> 07:20:18 07:38:18
fetches per second 10 1558 5675 5486 <null> 6491 <null> 5565 4082 3107 <null> 6062 3326 20711 3488 15083 <null> 382752 255978 <null> 07:38:19 07:56:19
marks per second 1 383 684 295 538 299 <null> 413 453 601 445 494 385 642 371 520 <null> 1024 635 <null> 04:56:10 05:14:10
marks per second 2 344 700 325 474 305 515 440 542 376 483 528 417 538 352 511 408 1386 324 <null> 05:14:11 05:32:11
marks per second 3 318 792 277 <null> 285 461 414 503 419 453 453 429 472 417 564 408 1468 777 <null> 05:32:12 05:50:12
marks per second 4 321 652 287 571 296 512 409 549 641 423 433 454 485 531 502 402 1206 801 <null> 05:50:13 06:08:13
marks per second 5 327 596 293 466 313 512 418 <null> 504 578 418 311 500 422 488 <null> 1331 633 <null> 06:08:14 06:26:14
marks per second 6 294 602 239 <null> 233 <null> 354 <null> 318 <null> 366 238 426 269 507 446 1096 <null> <null> 06:26:15 06:44:15
marks per second 7 305 593 289 632 292 <null> 413 556 371 436 450 375 575 <null> 474 430 983 570 <null> 06:44:16 07:02:16
marks per second 8 296 529 257 <null> 286 458 379 <null> 370 474 433 342 411 402 485 404 1078 985 <null> 07:02:17 07:20:17
marks per second 9 288 481 247 <null> 357 472 357 484 388 395 375 319 364 400 454 401 <null> 274 <null> 07:20:18 07:38:18
marks per second 10 281 510 248 <null> 389 <null> 383 478 352 <null> 370 366 371 338 433 <null> 1189 606 <null> 07:38:19 07:56:19
reads/fetches*100 1 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 04:56:10 05:14:10
reads/fetches*100 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:14:11 05:32:11
reads/fetches*100 3 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:32:12 05:50:12
reads/fetches*100 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:50:13 06:08:13
reads/fetches*100 5 0 0 0 0 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 06:08:14 06:26:14
reads/fetches*100 6 0 0 0 <null> 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> <null> 06:26:15 06:44:15
reads/fetches*100 7 0 0 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 0 0 <null> 06:44:16 07:02:16
reads/fetches*100 8 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 07:02:17 07:20:17
reads/fetches*100 9 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 07:20:18 07:38:18
reads/fetches*100 10 0 0 0 <null> 0 <null> 0 0 0 <null> 0 0 0 0 0 <null> 0 0 <null> 07:38:19 07:56:19
writes/marks*100 1 0 0 0 0 0 <null> 0 0 2 0 0 1 0 0 0 <null> 4 0 <null> 04:56:10 05:14:10
writes/marks*100 2 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 3 0 <null> 05:14:11 05:32:11
writes/marks*100 3 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 5 0 <null> 05:32:12 05:50:12
writes/marks*100 4 0 0 0 0 0 0 0 0 1 1 0 0 0 1 0 0 3 0 <null> 05:50:13 06:08:13
writes/marks*100 5 0 0 0 0 0 0 0 <null> 1 1 0 0 0 0 0 <null> 4 0 <null> 06:08:14 06:26:14
writes/marks*100 6 0 0 0 <null> 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 4 <null> <null> 06:26:15 06:44:15
writes/marks*100 7 0 0 0 0 0 <null> 0 0 1 0 0 0 0 <null> 0 0 4 0 <null> 06:44:16 07:02:16
writes/marks*100 8 0 0 0 <null> 0 0 0 <null> 1 0 0 0 0 1 0 0 4 3 <null> 07:02:17 07:20:17
writes/marks*100 9 0 0 0 <null> 0 0 0 0 1 1 0 1 0 0 0 0 <null> 0 <null> 07:20:18 07:38:18
writes/marks*100 10 0 0 0 <null> 0 <null> 0 0 1 <null> 0 0 0 0 0 <null> 5 0 <null> 07:38:19 07:56:19
Done for 9380 ms, from 8:08:49.12 to 8:08:58.50.

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 1540474 1500858 39616 2.57 0 8408 28 39616 2016-03-19 04:56 2016-03-19 07:56
doc_list_biud 1540889 1500858 40031 2.59 0 8065 36 40031 2016-03-19 04:56 2016-03-19 07:56
sp_add_invoice_to_stock 17206 11124 6082 35.34 249 368011 21913 6082 2016-03-19 04:56 2016-03-19 07:56
sp_cancel_adding_invoice 3439 2847 592 17.21 32 131918 4990 592 2016-03-19 04:56 2016-03-19 07:56
sp_cancel_client_order 5867 5587 280 4.77 15 385 75 280 2016-03-19 04:56 2016-03-19 07:56
sp_cancel_customer_reserve 180963 144942 36021 19.90 0 2824 120 36021 2016-03-19 04:56 2016-03-19 07:56
sp_cancel_pay_from_customer 2281 2261 20 0.87 15 1700 94 20 2016-03-19 04:56 2016-03-19 07:56
sp_cancel_pay_to_supplier 1458 1429 29 1.98 15 749 149 29 2016-03-19 04:56 2016-03-19 07:56
sp_cancel_supplier_invoice 7265 6124 1141 15.70 15 8174 2414 1141 2016-03-19 04:56 2016-03-19 07:56
sp_cancel_supplier_order 1327 392 935 70.45 125 431715 75329 935 2016-03-19 04:56 2016-03-19 07:56
sp_cancel_write_off 12262 9556 2706 22.06 0 7493 221 2706 2016-03-19 04:56 2016-03-19 07:56
sp_client_order 71438 71438 0 0.00 62 3807 1060 0 2016-03-19 04:56 2016-03-19 07:56
sp_customer_reserve 541918 541918 0 0.00 0 25382 405 0 2016-03-19 04:56 2016-03-19 07:56
sp_fill_shopping_cart 108143 108143 0 0.00 0 9937 232 0 2016-03-19 04:56 2016-03-19 07:56
sp_fill_shopping_cart_clo_res 541918 541918 0 0.00 0 281 1 0 2016-03-19 04:56 2016-03-19 07:56
sp_get_clo_for_invoice 11124 11124 0 0.00 0 7279 1072 0 2016-03-19 04:56 2016-03-19 07:56
sp_kill_cost_storno 19097 16093 3004 15.73 0 7725 82 3004 2016-03-19 04:56 2016-03-19 07:56
sp_kill_qstorno_ret_qs2qd 381144 305956 75188 19.72 0 8050 100 75188 2016-03-19 04:56 2016-03-19 07:56
sp_kill_qty_storno 252905 212955 39950 15.79 0 8065 251 39950 2016-03-19 04:56 2016-03-19 07:56
sp_lock_selected_doc 70081 60784 9297 13.26 0 141 3 9297 2016-03-19 04:56 2016-03-19 07:56
sp_make_cost_storno 86868 86868 0 0.00 0 8222 275 0 2016-03-19 04:56 2016-03-19 07:56
sp_multiply_rows_for_pdistr 86868 86868 0 0.00 0 842 151 0 2016-03-19 04:56 2016-03-19 07:56
sp_multiply_rows_for_qdistr 71441 71441 0 0.00 0 3183 790 0 2016-03-19 04:56 2016-03-19 07:56
sp_pay_from_customer 23736 23736 0 0.00 46 7632 355 0 2016-03-19 04:56 2016-03-19 07:56
sp_pay_to_supplier 19625 19625 0 0.00 108 8642 780 0 2016-03-19 04:56 2016-03-19 07:56
sp_payment_common 43361 43361 0 0.00 0 4103 29 0 2016-03-19 04:56 2016-03-19 07:56
sp_qd_handle_on_cancel_clo 5867 5587 280 4.77 0 326 51 280 2016-03-19 04:56 2016-03-19 07:56
sp_qd_handle_on_invoice_upd_sts 14394 13971 423 2.93 0 7768 1251 423 2016-03-19 04:56 2016-03-19 07:56
sp_qd_handle_on_reserve_upd_sts 32383 32383 0 0.00 0 1887 133 0 2016-03-19 04:56 2016-03-19 07:56
sp_reserve_write_off 33510 32383 1127 3.36 78 6660 335 1127 2016-03-19 04:56 2016-03-19 07:56
sp_supplier_invoice 18361 18361 0 0.00 124 54205 11615 0 2016-03-19 04:56 2016-03-19 07:56
sp_supplier_order 18344 18344 0 0.00 93 22963 7551 0 2016-03-19 04:56 2016-03-19 07:56
srv_find_qd_qs_mism 872963 833404 39559 4.53 0 454 1 39559 2016-03-19 04:56 2016-03-19 07:56
srv_make_invnt_saldo 3569 3569 0 0.00 156 46914 1527 0 2016-03-19 04:56 2016-03-19 07:56
srv_make_money_saldo 4131 4131 0 0.00 15 3677 72 0 2016-03-19 04:56 2016-03-19 07:56
srv_recalc_idx_stat 12 12 0 0.00 2230 4399 3312 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_add_invoice_to_stock 6082 6082 0 0.00 62 421 143 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_cancel_adding_invoice 449 449 0 0.00 78 2643 1077 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_cancel_client_order 280 280 0 0.00 125 452 232 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_cancel_customer_reserve 71 71 0 0.00 63 327 151 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_cancel_pay_from_customer 20 20 0 0.00 125 436 253 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_cancel_pay_to_supplier 29 29 0 0.00 140 328 232 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_cancel_supplier_invoice 467 467 0 0.00 61 297 146 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_cancel_supplier_order 5076 5076 0 0.00 46 2871 1565 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_cancel_write_off 72 72 0 0.00 62 266 135 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-abend:sp_reserve_write_off 1127 1127 0 0.00 62 370 145 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_add_invoice_to_stock 11199 11199 0 0.00 343 48830 11176 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_cancel_adding_invoice 1205 1205 0 0.00 397 38346 9601 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_cancel_client_order 5587 5587 0 0.00 109 562 259 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_cancel_customer_reserve 2203 2203 0 0.00 125 624 287 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_cancel_pay_from_customer 2261 2261 0 0.00 78 421 200 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_cancel_pay_to_supplier 1429 1429 0 0.00 78 561 201 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_cancel_supplier_invoice 922 922 0 0.00 109 515 260 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 171 411651 53091 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_cancel_write_off 3278 3278 0 0.00 140 733 288 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_client_order 71442 71442 0 0.00 78 812 347 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_customer_reserve 3268 3268 0 0.00 62 593 194 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_pay_from_customer 23736 23736 0 0.00 47 593 231 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_pay_to_supplier 19626 19626 0 0.00 78 609 232 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_reserve_write_off 32383 32383 0 0.00 78 827 318 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_supplier_invoice 18369 18369 0 0.00 15 780 347 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:sp_supplier_order 18348 18348 0 0.00 16 749 349 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:srv_make_invnt_saldo 3569 3569 0 0.00 0 296 29 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:srv_make_money_saldo 4131 4131 0 0.00 0 171 31 0 2016-03-19 04:56 2016-03-19 07:56
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 874 1310 1112 0 2016-03-19 04:56 2016-03-19 07:56
v_add_invoice_to_stock 34412 22248 12164 35.34 0 94 6 12164 2016-03-19 04:56 2016-03-19 07:56
v_all_customers 107324 107324 0 0.00 0 140 5 0 2016-03-19 04:56 2016-03-19 07:56
v_all_suppliers 73942 73942 0 0.00 0 141 6 0 2016-03-19 04:56 2016-03-19 07:56
v_all_wares 142876 142876 0 0.00 0 156 9 0 2016-03-19 04:56 2016-03-19 07:56
v_cancel_adding_invoice 2838 2410 428 15.08 0 452 60 428 2016-03-19 04:56 2016-03-19 07:56
v_cancel_client_order 11734 11174 560 4.77 0 93 5 560 2016-03-19 04:56 2016-03-19 07:56
v_cancel_customer_prepayment 4562 4522 40 0.87 0 63 5 40 2016-03-19 04:56 2016-03-19 07:56
v_cancel_customer_reserve 4548 4406 142 3.12 0 94 6 142 2016-03-19 04:56 2016-03-19 07:56
v_cancel_payment_to_supplier 2916 2858 58 1.98 0 125 6 58 2016-03-19 04:56 2016-03-19 07:56
v_cancel_supplier_invoice 2778 1844 934 33.62 0 93 7 934 2016-03-19 04:56 2016-03-19 07:56
v_cancel_supplier_order 2654 784 1870 70.45 0 109 6 1870 2016-03-19 04:56 2016-03-19 07:56
v_cancel_write_off 6700 6556 144 2.14 0 374 32 144 2016-03-19 04:56 2016-03-19 07:56
v_max_id_clo_ord 18344 18344 0 0.00 0 1014 18 0 2016-03-19 04:56 2016-03-19 07:56
v_max_id_clo_res 3268 3268 0 0.00 0 218 22 0 2016-03-19 04:56 2016-03-19 07:56
v_max_id_ord_sup 18361 18361 0 0.00 0 890 17 0 2016-03-19 04:56 2016-03-19 07:56
v_max_non_paid_invoice 19359 19359 0 0.00 0 171 7 0 2016-03-19 04:56 2016-03-19 07:56
v_max_non_paid_realizn 23736 23736 0 0.00 0 140 6 0 2016-03-19 04:56 2016-03-19 07:56
v_min_id_clo_ord 18344 18344 0 0.00 0 437 13 0 2016-03-19 04:56 2016-03-19 07:56
v_min_id_clo_res 3268 3268 0 0.00 0 359 9 0 2016-03-19 04:56 2016-03-19 07:56
v_min_id_ord_sup 18361 18361 0 0.00 0 951 14 0 2016-03-19 04:56 2016-03-19 07:56
v_min_non_paid_invoice 19625 19625 0 0.00 0 4056 16 0 2016-03-19 04:56 2016-03-19 07:56
v_min_non_paid_realizn 23736 23736 0 0.00 0 265 5 0 2016-03-19 04:56 2016-03-19 07:56
v_our_firm 35552 35552 0 0.00 0 110 5 0 2016-03-19 04:56 2016-03-19 07:56
v_reserve_write_off 67020 64766 2254 3.36 0 125 5 2254 2016-03-19 04:56 2016-03-19 07:56
x_lock_depdocs_on_canc_invoice 12227 8049 4178 34.17 0 684 11 4178 2016-03-19 04:56 2016-03-19 07:56
x_lock_depdocs_on_canc_sup_ord 1326 392 934 70.43 0 31 4 934 2016-03-19 04:56 2016-03-19 07:56
x_make_qstorno_1000_1200 18345 18345 0 0.00 47 21746 6953 0 2016-03-19 04:56 2016-03-19 07:56
x_make_qstorno_1200_2000 18364 18364 0 0.00 46 53175 11060 0 2016-03-19 04:56 2016-03-19 07:56
x_make_qstorno_2100_3300 541918 541918 0 0.00 0 25382 402 0 2016-03-19 04:56 2016-03-19 07:56
Done for 315340 ms, from 8:14:06.69 to 8:19:22.03.

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 115 sp_kill_cost_storno 335544336 2016-03-19 04:59 2016-03-19 07:54
deadlock 8 sp_kill_qstorno_ret_qs2qd 335544336 2016-03-19 05:03 2016-03-19 06:25
deadlock 76 sp_lock_selected_doc 335544336 2016-03-19 05:04 2016-03-19 07:55
deadlock 280 sp_qd_handle_on_cancel_clo 335544336 2016-03-19 04:59 2016-03-19 07:55
deadlock 94 sp_qd_handle_on_invoice_upd_sts 335544336 2016-03-19 04:56 2016-03-19 07:47
concurrent_transaction 7768 sp_lock_selected_doc 335544878 2016-03-19 04:56 2016-03-19 07:56
concurrent_transaction 500 x_lock_depdocs_on_canc_invoice 335544878 2016-03-19 04:56 2016-03-19 07:53
concurrent_transaction 457 x_lock_depdocs_on_canc_sup_ord 335544878 2016-03-19 04:56 2016-03-19 07:55
Done for 9110 ms, from 8:19:31.03 to 8:19:40.14.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 333377
MON$OLDEST_ACTIVE 333378
MON$OLDEST_SNAPSHOT 333378
MON$NEXT_TRANSACTION 333378
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 13:07:49.8140
MON$PAGES 713984
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.32400 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.32400 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.32400 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.32400 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P13"
on disk structure version 12.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 333690
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 333379
Oldest active 333380
Oldest snapshot 333380
Next transaction 333381
Sequence number 0
Next attachment ID 5153
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\OLTP40-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: 46.87, total records: 1672572
Average version length: 47.83, total versions: 17471, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.37
Pointer pages: 12, data page slots: 18592
Data pages: 18592, average fill: 71%
Primary pages: 18592, secondary pages: 0, swept pages: 9160
Empty pages: 1, full pages: 9589
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 92
60 - 79% = 18498
80 - 99% = 0

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 19783, depth: 3, leaf buckets: 7727, nodes: 1672572
Average node length: 19.94, total dup: 0, max dup: 0
Average key length: 17.00, compression ratio: 1.59
Average prefix length: 12.99, average data length: 14.01
Clustering factor: 668001, ratio: 0.40
Fill distribution:
0 - 19% = 253
20 - 39% = 526
40 - 59% = 4927
60 - 79% = 1358
80 - 99% = 663

Index DOC_DATA_ID_DESC (2)
Root page: 46992, depth: 3, leaf buckets: 5662, nodes: 1672572
Average node length: 11.59, total dup: 0, max dup: 0
Average key length: 8.65, compression ratio: 1.04
Average prefix length: 3.35, average data length: 5.65
Clustering factor: 616935, ratio: 0.37
Fill distribution:
0 - 19% = 0
20 - 39% = 1885
40 - 59% = 3776
60 - 79% = 0
80 - 99% = 1

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 161289, depth: 3, leaf buckets: 3068, nodes: 1672572
Average node length: 7.15, total dup: 1142928, max dup: 49
Average key length: 4.21, compression ratio: 2.14
Average prefix length: 7.11, average data length: 1.89
Clustering factor: 626549, ratio: 0.37
Fill distribution:
0 - 19% = 40
20 - 39% = 580
40 - 59% = 2159
60 - 79% = 81
80 - 99% = 208

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 59.56, total records: 578518
Average version length: 60.77, total versions: 8840, max versions: 4
Average fragment length: 6.82, total fragments: 38, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.61
Pointer pages: 5, data page slots: 7512
Data pages: 7512, average fill: 74%
Primary pages: 7508, secondary pages: 4, swept pages: 3870
Empty pages: 0, full pages: 5226
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 96
60 - 79% = 7245
80 - 99% = 166

Index DOC_LIST_ID_DESC (1)
Root page: 230835, depth: 3, leaf buckets: 2120, nodes: 578518
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.92, compression ratio: 1.01
Average prefix length: 3.07, average data length: 5.93
Clustering factor: 178424, ratio: 0.31
Fill distribution:
0 - 19% = 0
20 - 39% = 1112
40 - 59% = 1008
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Root page: 2964, depth: 2, leaf buckets: 706, nodes: 578518
Average node length: 4.86, total dup: 578468, max dup: 44430
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 273994, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 650
60 - 79% = 36
80 - 99% = 20

Index PK_DOC_LIST (0)
Root page: 250349, depth: 3, leaf buckets: 2098, nodes: 578518
Average node length: 11.78, total dup: 0, max dup: 0
Average key length: 8.92, compression ratio: 1.01
Average prefix length: 3.07, average data length: 5.93
Clustering factor: 178424, ratio: 0.31
Fill distribution:
0 - 19% = 64
20 - 39% = 1078
40 - 59% = 879
60 - 79% = 4
80 - 99% = 73

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: 66.81, total records: 400
Average version length: 14.77, total versions: 899307, max versions: 2364
Average fragment length: 20.32, total fragments: 400, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.56
Pointer pages: 3, data page slots: 4632
Data pages: 4632, average fill: 78%
Primary pages: 9, secondary pages: 4623, swept pages: 0
Empty pages: 5, full pages: 4626
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3437
80 - 99% = 1190

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: 6.19, total records: 98588
Average version length: 71.17, total versions: 90022, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 15.52
Pointer pages: 4, data page slots: 5424
Data pages: 3400, average fill: 39%
Primary pages: 3400, secondary pages: 0, swept pages: 349
Empty pages: 408, full pages: 1011
Fill distribution:
0 - 19% = 1591
20 - 39% = 359
40 - 59% = 301
60 - 79% = 389
80 - 99% = 760

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 117569, depth: 3, leaf buckets: 403, nodes: 98588
Average node length: 14.08, total dup: 5325, max dup: 2
Average key length: 11.27, compression ratio: 2.40
Average prefix length: 18.68, average data length: 8.32
Clustering factor: 84365, ratio: 0.86
Fill distribution:
0 - 19% = 4
20 - 39% = 132
40 - 59% = 262
60 - 79% = 4
80 - 99% = 1

MONEY_SALDO (143)
Primary pointer page: 261, Index root page: 262
Total formats: 1, used formats: 1
Average record length: 14.96, total records: 49
Average version length: 9.01, total versions: 50941, max versions: 3856
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.14
Pointer pages: 1, data page slots: 176
Data pages: 176, average fill: 92%
Primary pages: 1, secondary pages: 175, swept pages: 0
Empty pages: 0, full pages: 175
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 175

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: 1.90, total records: 3772
Average version length: 45.42, total versions: 3620, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 33.63
Pointer pages: 1, data page slots: 152
Data pages: 136, average fill: 31%
Primary pages: 136, secondary pages: 0, swept pages: 18
Empty pages: 25, full pages: 28
Fill distribution:
0 - 19% = 87
20 - 39% = 5
40 - 59% = 13
60 - 79% = 6
80 - 99% = 25

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 96669, depth: 2, leaf buckets: 4, nodes: 3772
Average node length: 4.12, total dup: 3699, max dup: 564
Average key length: 2.26, compression ratio: 8.40
Average prefix length: 18.76, average data length: 0.24
Clustering factor: 1673, ratio: 0.44
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2
60 - 79% = 1
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: 23.47, total records: 592084
Average version length: 42.80, total versions: 21176, max versions: 153
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 2.73
Pointer pages: 3, data page slots: 4424
Data pages: 4424, average fill: 71%
Primary pages: 4414, secondary pages: 10, swept pages: 2457
Empty pages: 10, full pages: 2573
Fill distribution:
0 - 19% = 21
20 - 39% = 94
40 - 59% = 361
60 - 79% = 3553
80 - 99% = 395

Index PDISTR_AGENT_ID (4)
Root page: 3600, depth: 2, leaf buckets: 296, nodes: 277778
Average node length: 4.75, total dup: 277729, max dup: 11512
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 40020, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 213
60 - 79% = 48
80 - 99% = 17

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4281, depth: 2, leaf buckets: 327, nodes: 277778
Average node length: 5.73, total dup: 249576, max dup: 54
Average key length: 3.00, compression ratio: 7.34
Average prefix length: 21.10, average data length: 0.90
Clustering factor: 46033, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 38
40 - 59% = 129
60 - 79% = 112
80 - 99% = 48

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3974, depth: 2, leaf buckets: 326, nodes: 277778
Average node length: 5.73, total dup: 249576, max dup: 54
Average key length: 3.00, compression ratio: 7.34
Average prefix length: 21.10, average data length: 0.90
Clustering factor: 46295, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 34
40 - 59% = 127
60 - 79% = 116
80 - 99% = 49

Index PDISTR_SND_ID (1)
Root page: 4313, depth: 2, leaf buckets: 332, nodes: 277778
Average node length: 5.51, total dup: 249576, max dup: 54
Average key length: 2.77, compression ratio: 3.25
Average prefix length: 8.33, average data length: 0.67
Clustering factor: 46418, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 34
40 - 59% = 177
60 - 79% = 91
80 - 99% = 30

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 87228, depth: 2, leaf buckets: 194, nodes: 250821
Average node length: 4.49, total dup: 250630, max dup: 2203
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 63685, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 37
60 - 79% = 105
80 - 99% = 52

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: 147.64, total records: 9057663
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: 1439.57, compression ratio: 9.75
Pointer pages: 129, data page slots: 210528
Data pages: 210528, average fill: 87%
Primary pages: 210528, secondary pages: 0, swept pages: 3
Empty pages: 3, full pages: 210524
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 210524

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 59394, depth: 3, leaf buckets: 9146, nodes: 9057663
Average node length: 5.59, total dup: 7732218, max dup: 61
Average key length: 2.27, compression ratio: 3.53
Average prefix length: 7.78, average data length: 0.21
Clustering factor: 6087981, ratio: 0.67
Fill distribution:
0 - 19% = 21
20 - 39% = 0
40 - 59% = 3187
60 - 79% = 3593
80 - 99% = 2345

Index PERF_LOG_GDSCODE (3)
Root page: 154755, depth: 3, leaf buckets: 9732, nodes: 9057663
Average node length: 4.37, total dup: 9057658, max dup: 8721208
Average key length: 1.04, compression ratio: 0.18
Average prefix length: 0.19, average data length: 0.00
Clustering factor: 345358, ratio: 0.04
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 9703
60 - 79% = 0
80 - 99% = 28

Index PERF_LOG_TRN_DESC (2)
Root page: 43359, depth: 3, leaf buckets: 10032, nodes: 9057663
Average node length: 5.57, total dup: 8761434, max dup: 13082
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 4613681, ratio: 0.51
Fill distribution:
0 - 19% = 3
20 - 39% = 3
40 - 59% = 5877
60 - 79% = 2358
80 - 99% = 1791

Index PERF_LOG_UNIT (1)
Root page: 65474, depth: 3, leaf buckets: 10675, nodes: 9057663
Average node length: 5.49, total dup: 8953416, max dup: 1350344
Average key length: 2.16, compression ratio: 17.43
Average prefix length: 37.50, average data length: 0.15
Clustering factor: 5569245, ratio: 0.61
Fill distribution:
0 - 19% = 17
20 - 39% = 2
40 - 59% = 8421
60 - 79% = 798
80 - 99% = 1437

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: 53.43, total records: 298186
Average version length: 55.47, total versions: 8086, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.50
Pointer pages: 3, data page slots: 3664
Data pages: 3664, average fill: 72%
Primary pages: 3664, secondary pages: 0, swept pages: 1940
Empty pages: 5, full pages: 2683
Fill distribution:
0 - 19% = 21
20 - 39% = 18
40 - 59% = 142
60 - 79% = 3447
80 - 99% = 36

Index PSTORNED_RCV_ID (2)
Root page: 2296, depth: 2, leaf buckets: 381, nodes: 298186
Average node length: 5.96, total dup: 246948, max dup: 732
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 31348, ratio: 0.11
Fill distribution:
0 - 19% = 4
20 - 39% = 23
40 - 59% = 209
60 - 79% = 107
80 - 99% = 38

Index PSTORNED_SND_ID (1)
Root page: 2211, depth: 2, leaf buckets: 318, nodes: 298186
Average node length: 5.53, total dup: 265110, max dup: 366
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.26, average data length: 0.74
Clustering factor: 63015, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 130
60 - 79% = 126
80 - 99% = 55

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: 9.00, total versions: 8205, max versions: 4378
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: 32
Data pages: 32, average fill: 82%
Primary pages: 4, secondary pages: 28, swept pages: 0
Empty pages: 3, full pages: 28
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 28

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: 98.32, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 81%
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: 54.43, total records: 2712
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.50
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 74%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 31
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 31
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: 2.47, total records: 157792
Average version length: 72.19, total versions: 152393, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 55.07
Pointer pages: 5, data page slots: 6696
Data pages: 3007, average fill: 69%
Primary pages: 3005, secondary pages: 2, swept pages: 200
Empty pages: 419, full pages: 1955
Fill distribution:
0 - 19% = 472
20 - 39% = 203
40 - 59% = 293
60 - 79% = 153
80 - 99% = 1886

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 119894, depth: 3, leaf buckets: 451, nodes: 157792
Average node length: 6.13, total dup: 137936, max dup: 29
Average key length: 3.32, compression ratio: 11.15
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 24806, ratio: 0.16
Fill distribution:
0 - 19% = 74
20 - 39% = 336
40 - 59% = 40
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: 65.08, total records: 1488276
Average version length: 71.59, total versions: 146240, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.09
Pointer pages: 14, data page slots: 22512
Data pages: 22512, average fill: 74%
Primary pages: 22512, secondary pages: 0, swept pages: 2908
Empty pages: 18, full pages: 17528
Fill distribution:
0 - 19% = 37
20 - 39% = 111
40 - 59% = 1209
60 - 79% = 18970
80 - 99% = 2185

Index XQD_1000_3300_DOC (1)
Root page: 176165, depth: 3, leaf buckets: 1937, nodes: 1488276
Average node length: 5.17, total dup: 1446258, max dup: 131
Average key length: 2.22, compression ratio: 4.06
Average prefix length: 8.81, average data length: 0.19
Clustering factor: 316076, ratio: 0.21
Fill distribution:
0 - 19% = 20
20 - 39% = 150
40 - 59% = 1635
60 - 79% = 118
80 - 99% = 14

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 107261, depth: 3, leaf buckets: 2313, nodes: 1488276
Average node length: 6.30, total dup: 1296856, max dup: 44
Average key length: 3.34, compression ratio: 11.06
Average prefix length: 35.78, average data length: 1.22
Clustering factor: 397847, ratio: 0.27
Fill distribution:
0 - 19% = 58
20 - 39% = 179
40 - 59% = 1743
60 - 79% = 167
80 - 99% = 166

XQD_1200_2000 (260)
Primary pointer page: 705, Index root page: 706
Total formats: 1, used formats: 1
Average record length: 7.33, total records: 483742
Average version length: 71.98, total versions: 387953, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 18.54
Pointer pages: 7, data page slots: 10528
Data pages: 10464, average fill: 55%
Primary pages: 10460, secondary pages: 4, swept pages: 988
Empty pages: 1441, full pages: 5360
Fill distribution:
0 - 19% = 3076
20 - 39% = 750
40 - 59% = 708
60 - 79% = 1514
80 - 99% = 4416

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 117663, depth: 3, leaf buckets: 654, nodes: 430639
Average node length: 5.95, total dup: 385975, max dup: 109
Average key length: 3.11, compression ratio: 11.88
Average prefix length: 35.99, average data length: 1.01
Clustering factor: 103326, ratio: 0.24
Fill distribution:
0 - 19% = 28
20 - 39% = 165
40 - 59% = 310
60 - 79% = 116
80 - 99% = 35

XQD_2000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 42.76, total records: 2499799
Average version length: 72.13, total versions: 592602, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.18
Pointer pages: 21, data page slots: 33632
Data pages: 33632, average fill: 74%
Primary pages: 33632, secondary pages: 0, swept pages: 896
Empty pages: 43, full pages: 27069
Fill distribution:
0 - 19% = 164
20 - 39% = 901
40 - 59% = 3656
60 - 79% = 14117
80 - 99% = 14794

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 107737, depth: 3, leaf buckets: 3086, nodes: 2012432
Average node length: 5.63, total dup: 1890369, max dup: 99
Average key length: 2.66, compression ratio: 13.90
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 639057, ratio: 0.32
Fill distribution:
0 - 19% = 12
20 - 39% = 1234
40 - 59% = 1374
60 - 79% = 252
80 - 99% = 214

XQD_2100_3300 (263)
Primary pointer page: 734, Index root page: 735
Total formats: 1, used formats: 1
Average record length: 9.05, total records: 3371147
Average version length: 70.33, total versions: 7951, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.03
Pointer pages: 14, data page slots: 21416
Data pages: 21408, average fill: 51%
Primary pages: 21407, secondary pages: 1, swept pages: 4938
Empty pages: 42, full pages: 19934
Fill distribution:
0 - 19% = 86
20 - 39% = 7063
40 - 59% = 5326
60 - 79% = 8864
80 - 99% = 69

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1530, depth: 2, leaf buckets: 32, nodes: 11769
Average node length: 8.75, total dup: 8613, max dup: 27
Average key length: 5.75, compression ratio: 6.44
Average prefix length: 33.52, average data length: 3.48
Clustering factor: 2899, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 17
40 - 59% = 10
60 - 79% = 5
80 - 99% = 0

XQD_3300_3400 (264)
Primary pointer page: 737, Index root page: 738
Total formats: 1, used formats: 1
Average record length: 62.87, total records: 2366543
Average version length: 71.54, total versions: 150530, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.16
Pointer pages: 21, data page slots: 33416
Data pages: 33416, average fill: 75%
Primary pages: 33416, secondary pages: 0, swept pages: 8359
Empty pages: 13, full pages: 25256
Fill distribution:
0 - 19% = 33
20 - 39% = 133
40 - 59% = 1394
60 - 79% = 27377
80 - 99% = 4479

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 41262, depth: 3, leaf buckets: 4777, nodes: 2207947
Average node length: 6.98, total dup: 1763094, max dup: 26
Average key length: 4.01, compression ratio: 9.23
Average prefix length: 35.19, average data length: 1.81
Clustering factor: 605590, ratio: 0.27
Fill distribution:
0 - 19% = 8
20 - 39% = 2911
40 - 59% = 1491
60 - 79% = 199
80 - 99% = 168

XQS_1000_1200 (265)
Primary pointer page: 740, Index root page: 741
Total formats: 1, used formats: 1
Average record length: 83.35, total records: 3770245
Average version length: 84.79, total versions: 34598, 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: 37, data page slots: 58800
Data pages: 58800, average fill: 80%
Primary pages: 58800, secondary pages: 0, swept pages: 25497
Empty pages: 6, full pages: 57169
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 40
60 - 79% = 26352
80 - 99% = 32402

Index XQS_1000_1200_DOC_ID (0)
Root page: 54649, depth: 3, leaf buckets: 3644, nodes: 3770245
Average node length: 5.16, total dup: 3683290, max dup: 130
Average key length: 2.17, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 876300, ratio: 0.23
Fill distribution:
0 - 19% = 6
20 - 39% = 48
40 - 59% = 1325
60 - 79% = 1502
80 - 99% = 763

Index XQS_1000_1200_RCV_ID (2)
Root page: 78654, depth: 3, leaf buckets: 4993, nodes: 3770245
Average node length: 5.65, total dup: 3402689, max dup: 49
Average key length: 2.67, compression ratio: 3.38
Average prefix length: 8.43, average data length: 0.57
Clustering factor: 592302, ratio: 0.16
Fill distribution:
0 - 19% = 44
20 - 39% = 137
40 - 59% = 3962
60 - 79% = 391
80 - 99% = 459

Index XQS_1000_1200_SND_ID (1)
Root page: 48486, depth: 3, leaf buckets: 4130, nodes: 3770245
Average node length: 5.79, total dup: 3297654, max dup: 37
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 926057, ratio: 0.25
Fill distribution:
0 - 19% = 4
20 - 39% = 68
40 - 59% = 1698
60 - 79% = 1409
80 - 99% = 951

XQS_1000_3300 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 80.50, total records: 1516822
Average version length: 83.22, total versions: 48436, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.69
Pointer pages: 16, data page slots: 24944
Data pages: 24944, average fill: 75%
Primary pages: 24944, secondary pages: 0, swept pages: 15555
Empty pages: 12, full pages: 18466
Fill distribution:
0 - 19% = 43
20 - 39% = 144
40 - 59% = 1410
60 - 79% = 14711
80 - 99% = 8636

Index XQS_1000_3300_DOC_ID (0)
Root page: 75516, depth: 3, leaf buckets: 1648, nodes: 1516822
Average node length: 5.14, total dup: 1481285, max dup: 191
Average key length: 2.18, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 322543, ratio: 0.21
Fill distribution:
0 - 19% = 3
20 - 39% = 27
40 - 59% = 983
60 - 79% = 502
80 - 99% = 133

Index XQS_1000_3300_RCV_ID (2)
Root page: 128627, depth: 3, leaf buckets: 2912, nodes: 1516822
Average node length: 6.29, total dup: 1228180, max dup: 14
Average key length: 3.34, compression ratio: 2.70
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 238031, ratio: 0.16
Fill distribution:
0 - 19% = 42
20 - 39% = 1542
40 - 59% = 1108
60 - 79% = 185
80 - 99% = 35

Index XQS_1000_3300_SND_ID (1)
Root page: 65477, depth: 3, leaf buckets: 1855, nodes: 1516822
Average node length: 5.78, total dup: 1329831, max dup: 41
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 347468, ratio: 0.23
Fill distribution:
0 - 19% = 3
20 - 39% = 27
40 - 59% = 1118
60 - 79% = 565
80 - 99% = 142

XQS_1200_2000 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 79.43, total records: 4188469
Average version length: 85.52, total versions: 238109, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.71
Pointer pages: 42, data page slots: 68032
Data pages: 68032, average fill: 77%
Primary pages: 68032, secondary pages: 0, swept pages: 19007
Empty pages: 30, full pages: 57054
Fill distribution:
0 - 19% = 52
20 - 39% = 412
40 - 59% = 2952
60 - 79% = 31805
80 - 99% = 32811

Index XQS_1200_2000_DOC_ID (0)
Root page: 57323, depth: 3, leaf buckets: 4648, nodes: 4188469
Average node length: 5.04, total dup: 4165013, max dup: 631
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 1113732, ratio: 0.27
Fill distribution:
0 - 19% = 4
20 - 39% = 358
40 - 59% = 2824
60 - 79% = 1180
80 - 99% = 282

Index XQS_1200_2000_RCV_ID (2)
Root page: 78658, depth: 3, leaf buckets: 5847, nodes: 4188469
Average node length: 5.49, total dup: 3881697, max dup: 49
Average key length: 2.51, compression ratio: 3.59
Average prefix length: 8.57, average data length: 0.43
Clustering factor: 872182, ratio: 0.21
Fill distribution:
0 - 19% = 44
20 - 39% = 1911
40 - 59% = 2876
60 - 79% = 480
80 - 99% = 536

Index XQS_1200_2000_SND_ID (1)
Root page: 49624, depth: 3, leaf buckets: 5159, nodes: 4188469
Average node length: 5.61, total dup: 3806462, max dup: 109
Average key length: 2.62, compression ratio: 3.43
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 1181836, ratio: 0.28
Fill distribution:
0 - 19% = 6
20 - 39% = 291
40 - 59% = 3233
60 - 79% = 1284
80 - 99% = 345

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: 81.76, total records: 2593959
Average version length: 84.36, total versions: 67247, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.66
Pointer pages: 27, data page slots: 42832
Data pages: 42832, average fill: 76%
Primary pages: 42832, secondary pages: 0, swept pages: 26387
Empty pages: 15, full pages: 30680
Fill distribution:
0 - 19% = 53
20 - 39% = 83
40 - 59% = 1687
60 - 79% = 27371
80 - 99% = 13638

Index XQS_2100_3300_DOC_ID (0)
Root page: 91394, depth: 3, leaf buckets: 2835, nodes: 2593959
Average node length: 5.02, total dup: 2580863, max dup: 1041
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 693870, ratio: 0.27
Fill distribution:
0 - 19% = 24
20 - 39% = 362
40 - 59% = 1396
60 - 79% = 733
80 - 99% = 320

Index XQS_2100_3300_RCV_ID (2)
Root page: 91116, depth: 3, leaf buckets: 5206, nodes: 2593959
Average node length: 6.32, total dup: 2096898, max dup: 14
Average key length: 3.34, compression ratio: 2.69
Average prefix length: 7.85, average data length: 1.15
Clustering factor: 562279, ratio: 0.22
Fill distribution:
0 - 19% = 152
20 - 39% = 2952
40 - 59% = 1823
60 - 79% = 209
80 - 99% = 70

Index XQS_2100_3300_SND_ID (1)
Root page: 78028, depth: 3, leaf buckets: 3057, nodes: 2593959
Average node length: 5.54, total dup: 2382915, max dup: 94
Average key length: 2.57, compression ratio: 3.51
Average prefix length: 8.51, average data length: 0.49
Clustering factor: 726332, ratio: 0.28
Fill distribution:
0 - 19% = 4
20 - 39% = 315
40 - 59% = 1456
60 - 79% = 964
80 - 99% = 318

XQS_3300_3400 (270)
Primary pointer page: 776, Index root page: 777
Total formats: 1, used formats: 1
Average record length: 67.33, total records: 483186
Average version length: 69.47, total versions: 13891, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.02
Pointer pages: 5, data page slots: 6816
Data pages: 6816, average fill: 76%
Primary pages: 6816, secondary pages: 0, swept pages: 4650
Empty pages: 8, full pages: 5953
Fill distribution:
0 - 19% = 27
20 - 39% = 49
40 - 59% = 190
60 - 79% = 6181
80 - 99% = 369

Index XQS_3300_3400_DOC_ID (0)
Root page: 566391, depth: 3, leaf buckets: 542, nodes: 483186
Average node length: 5.35, total dup: 450871, max dup: 118
Average key length: 2.52, compression ratio: 3.58
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 44454, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 51
40 - 59% = 253
60 - 79% = 168
80 - 99% = 69

Index XQS_3300_3400_SND_ID (1)
Root page: 399849, depth: 3, leaf buckets: 616, nodes: 483186
Average node length: 5.93, total dup: 411367, max dup: 29
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 52684, ratio: 0.11
Fill distribution:
0 - 19% = 2
20 - 39% = 59
40 - 59% = 302
60 - 79% = 193
80 - 99% = 60

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 58810 ms, from 8:19:40.43 to 8:20:39.24.

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 1672572 17471 1.0445
DOC_LIST 578518 8840 1.5280
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 899307 224826.7500
INVNT_TURNOVER_LOG 98588 90022 91.3113
MONEY_SALDO 49 50941 103961.2244
MONEY_TURNOVER_LOG 3772 3620 95.9703
OPTYPES 9 0 0.0000
PDISTR 592084 21176 3.5765
PERF_ESTIMATED 250821 0 0.0000
PERF_LOG 9057663 0 0.0000
PSTORNED 298186 8086 2.7117
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 8205 205125.0000
SETTINGS 114 0 0.0000
TRACE_STAT 2712 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 157792 152393 96.5784
XQD_1000_3300 1488276 146240 9.8261
XQD_1200_2000 483742 387953 80.1983
XQD_2000_3300 2499799 592602 23.7059
XQD_2100_3300 3371147 7951 0.2358
XQD_3300_3400 2366543 150530 6.3607
XQS_1000_1200 3770245 34598 0.9176
XQS_1000_3300 1516822 48436 3.1932
XQS_1200_2000 4188469 238109 5.6848
XQS_2100_3300 2593959 67247 2.5924
XQS_3300_3400 483186 13891 2.8748
Z_USED_VIEWS 29 0 0.0000
Done for 2400 ms, from 8:20:52.22 to 8:20:54.62.

Database validation

08:20:54.72 Validation started

08:20:54.75 Relation 140 (DOC_LIST)
08:20:54.75 process pointer page 0 of 5
08:20:54.86 process pointer page 1 of 5
08:20:54.97 process pointer page 2 of 5
08:20:55.08 process pointer page 3 of 5
08:20:55.17 process pointer page 4 of 5
08:20:55.22 Index 1 (PK_DOC_LIST)
08:20:55.47 Index 2 (DOC_LIST_ID_DESC)
08:20:55.73 Index 3 (FK_DOC_LIST_AGENTS)
08:20:55.98 Relation 140 (DOC_LIST) is ok

08:20:55.98 Relation 141 (DOC_DATA)
08:20:55.98 process pointer page 0 of 12
08:20:56.08 process pointer page 1 of 12
08:20:56.17 process pointer page 2 of 12
08:20:56.26 process pointer page 3 of 12
08:20:56.36 process pointer page 4 of 12
08:20:56.45 process pointer page 5 of 12
08:20:56.54 process pointer page 6 of 12
08:20:56.64 process pointer page 7 of 12
08:20:56.73 process pointer page 8 of 12
08:20:56.82 process pointer page 9 of 12
08:20:56.92 process pointer page 10 of 12
08:20:57.01 process pointer page 11 of 12
08:20:57.04 Index 2 (DOC_DATA_DOC_WARE_UNQ)
08:20:57.96 Index 3 (DOC_DATA_ID_DESC)
08:20:58.73 Index 4 (FK_DOC_DATA_DOC_LIST)
08:20:59.40 Relation 141 (DOC_DATA) is ok

08:20:59.40 Relation 147 (INVNT_SALDO)
08:20:59.40 process pointer page 0 of 3
08:21:02.42 process pointer page 1 of 3
08:21:02.46 process pointer page 2 of 3
08:21:02.47 Index 1 (PK_INVNT_SALDO)
08:21:02.47 Relation 147 (INVNT_SALDO) is ok

08:21:02.47 Relation 150 (PDISTR)
08:21:02.47 process pointer page 0 of 3
08:21:02.58 process pointer page 1 of 3
08:21:02.67 process pointer page 2 of 3
08:21:02.75 Index 2 (PDISTR_SND_ID)
08:21:02.85 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
08:21:02.96 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
08:21:03.06 Index 5 (PDISTR_AGENT_ID)
08:21:03.16 Relation 150 (PDISTR) is ok

08:21:03.16 Relation 151 (PSTORNED)
08:21:03.16 process pointer page 0 of 3
08:21:03.25 process pointer page 1 of 3
08:21:03.36 process pointer page 2 of 3
08:21:03.39 Index 2 (PSTORNED_SND_ID)
08:21:03.49 Index 3 (PSTORNED_RCV_ID)
08:21:03.56 Relation 151 (PSTORNED) is ok

08:21:03.56 Relation 156 (SEMAPHORES)
08:21:03.56 process pointer page 0 of 1
08:21:03.59 Index 1 (PK_SEMAPHORES)
08:21:03.59 Index 2 (SEMAPHORES_TASK_UNQ)
08:21:03.59 Relation 156 (SEMAPHORES) is ok

08:21:03.59 Relation 157 (INVNT_TURNOVER_LOG)
08:21:03.59 process pointer page 0 of 4
08:21:03.66 process pointer page 1 of 4
08:21:03.80 process pointer page 2 of 4
08:21:03.84 process pointer page 3 of 4
08:21:03.86 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
08:21:03.94 Relation 157 (INVNT_TURNOVER_LOG) is ok

08:21:03.94 Relation 160 (PERF_ESTIMATED)
08:21:03.94 process pointer page 0 of 2
08:21:04.03 process pointer page 1 of 2
08:21:04.06 Index 1 (PERF_EST_MINUTE_SINCE_START)
08:21:04.14 Relation 160 (PERF_ESTIMATED) is ok

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

08:21:04.14 Relation 162 (PERF_LOG)
08:21:04.14 process pointer page 0 of 129
08:21:04.22 process pointer page 1 of 129
08:21:04.30 process pointer page 2 of 129
08:21:04.37 process pointer page 3 of 129
08:21:04.45 process pointer page 4 of 129
08:21:04.53 process pointer page 5 of 129
08:21:04.61 process pointer page 6 of 129
08:21:04.69 process pointer page 7 of 129
08:21:04.76 process pointer page 8 of 129
08:21:04.84 process pointer page 9 of 129
08:21:04.92 process pointer page 10 of 129
08:21:05.00 process pointer page 11 of 129
08:21:05.08 process pointer page 12 of 129
08:21:05.14 process pointer page 13 of 129
08:21:05.22 process pointer page 14 of 129
08:21:05.30 process pointer page 15 of 129
08:21:05.37 process pointer page 16 of 129
08:21:05.45 process pointer page 17 of 129
08:21:05.53 process pointer page 18 of 129
08:21:05.61 process pointer page 19 of 129
08:21:05.67 process pointer page 20 of 129
08:21:05.75 process pointer page 21 of 129
08:21:05.83 process pointer page 22 of 129
08:21:05.90 process pointer page 23 of 129
08:21:05.98 process pointer page 24 of 129
08:21:06.04 process pointer page 25 of 129
08:21:06.12 process pointer page 26 of 129
08:21:06.20 process pointer page 27 of 129
08:21:06.28 process pointer page 28 of 129
08:21:06.36 process pointer page 29 of 129
08:21:06.43 process pointer page 30 of 129
08:21:06.50 process pointer page 31 of 129
08:21:06.57 process pointer page 32 of 129
08:21:06.65 process pointer page 33 of 129
08:21:06.73 process pointer page 34 of 129
08:21:06.81 process pointer page 35 of 129
08:21:06.87 process pointer page 36 of 129
08:21:06.95 process pointer page 37 of 129
08:21:07.03 process pointer page 38 of 129
08:21:07.10 process pointer page 39 of 129
08:21:07.18 process pointer page 40 of 129
08:21:07.25 process pointer page 41 of 129
08:21:07.32 process pointer page 42 of 129
08:21:07.40 process pointer page 43 of 129
08:21:07.48 process pointer page 44 of 129
08:21:07.56 process pointer page 45 of 129
08:21:07.64 process pointer page 46 of 129
08:21:07.70 process pointer page 47 of 129
08:21:07.78 process pointer page 48 of 129
08:21:07.85 process pointer page 49 of 129
08:21:07.93 process pointer page 50 of 129
08:21:08.01 process pointer page 51 of 129
08:21:08.07 process pointer page 52 of 129
08:21:08.15 process pointer page 53 of 129
08:21:08.23 process pointer page 54 of 129
08:21:08.31 process pointer page 55 of 129
08:21:08.38 process pointer page 56 of 129
08:21:08.45 process pointer page 57 of 129
08:21:08.52 process pointer page 58 of 129
08:21:08.60 process pointer page 59 of 129
08:21:08.68 process pointer page 60 of 129
08:21:08.76 process pointer page 61 of 129
08:21:08.82 process pointer page 62 of 129
08:21:08.90 process pointer page 63 of 129
08:21:08.98 process pointer page 64 of 129
08:21:09.05 process pointer page 65 of 129
08:21:09.13 process pointer page 66 of 129
08:21:09.20 process pointer page 67 of 129
08:21:09.27 process pointer page 68 of 129
08:21:09.35 process pointer page 69 of 129
08:21:09.43 process pointer page 70 of 129
08:21:09.51 process pointer page 71 of 129
08:21:09.59 process pointer page 72 of 129
08:21:09.65 process pointer page 73 of 129
08:21:09.73 process pointer page 74 of 129
08:21:09.80 process pointer page 75 of 129
08:21:09.88 process pointer page 76 of 129
08:21:09.96 process pointer page 77 of 129
08:21:10.04 process pointer page 78 of 129
08:21:10.11 process pointer page 79 of 129
08:21:10.19 process pointer page 80 of 129
08:21:10.27 process pointer page 81 of 129
08:21:10.34 process pointer page 82 of 129
08:21:10.42 process pointer page 83 of 129
08:21:10.50 process pointer page 84 of 129
08:21:10.57 process pointer page 85 of 129
08:21:10.65 process pointer page 86 of 129
08:21:10.73 process pointer page 87 of 129
08:21:10.80 process pointer page 88 of 129
08:21:10.88 process pointer page 89 of 129
08:21:10.95 process pointer page 90 of 129
08:21:11.03 process pointer page 91 of 129
08:21:11.11 process pointer page 92 of 129
08:21:11.18 process pointer page 93 of 129
08:21:11.25 process pointer page 94 of 129
08:21:11.33 process pointer page 95 of 129
08:21:11.40 process pointer page 96 of 129
08:21:11.48 process pointer page 97 of 129
08:21:11.54 process pointer page 98 of 129
08:21:11.62 process pointer page 99 of 129
08:21:11.70 process pointer page 100 of 129
08:21:11.78 process pointer page 101 of 129
08:21:11.86 process pointer page 102 of 129
08:21:11.93 process pointer page 103 of 129
08:21:12.00 process pointer page 104 of 129
08:21:12.07 process pointer page 105 of 129
08:21:12.15 process pointer page 106 of 129
08:21:12.23 process pointer page 107 of 129
08:21:12.29 process pointer page 108 of 129
08:21:12.37 process pointer page 109 of 129
08:21:12.45 process pointer page 110 of 129
08:21:12.53 process pointer page 111 of 129
08:21:12.61 process pointer page 112 of 129
08:21:12.67 process pointer page 113 of 129
08:21:12.75 process pointer page 114 of 129
08:21:12.82 process pointer page 115 of 129
08:21:12.90 process pointer page 116 of 129
08:21:12.98 process pointer page 117 of 129
08:21:13.06 process pointer page 118 of 129
08:21:13.12 process pointer page 119 of 129
08:21:13.20 process pointer page 120 of 129
08:21:13.28 process pointer page 121 of 129
08:21:13.35 process pointer page 122 of 129
08:21:13.43 process pointer page 123 of 129
08:21:13.49 process pointer page 124 of 129
08:21:13.57 process pointer page 125 of 129
08:21:13.65 process pointer page 126 of 129
08:21:13.73 process pointer page 127 of 129
08:21:13.81 process pointer page 128 of 129
08:21:13.88 Index 1 (PERF_LOG_DTS_BEG_DESC)
08:21:18.36 Index 2 (PERF_LOG_UNIT)
08:21:23.76 Index 3 (PERF_LOG_TRN_DESC)
08:21:27.67 Index 4 (PERF_LOG_GDSCODE)
08:21:29.81 Relation 162 (PERF_LOG) is ok

08:21:29.81 Relation 166 (V_STOPTEST)
08:21:29.81 Relation 166 (V_STOPTEST) is ok

08:21:29.81 Relation 183 (V_QDISTR_SOURCE)
08:21:29.81 Relation 183 (V_QDISTR_SOURCE) is ok

08:21:29.81 Relation 184 (V_QSTORNED_SOURCE)
08:21:29.81 Relation 184 (V_QSTORNED_SOURCE) is ok

08:21:29.81 Relation 259 (XQD_1000_1200)
08:21:29.81 process pointer page 0 of 5
08:21:29.94 process pointer page 1 of 5
08:21:30.00 process pointer page 2 of 5
08:21:30.16 process pointer page 3 of 5
08:21:30.19 process pointer page 4 of 5
08:21:30.20 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
08:21:30.26 Relation 259 (XQD_1000_1200) is ok

08:21:30.26 Relation 260 (XQD_1200_2000)
08:21:30.26 process pointer page 0 of 7
08:21:30.42 process pointer page 1 of 7
08:21:30.61 process pointer page 2 of 7
08:21:30.87 process pointer page 3 of 7
08:21:31.06 process pointer page 4 of 7
08:21:31.14 process pointer page 5 of 7
08:21:31.28 process pointer page 6 of 7
08:21:31.36 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
08:21:31.53 Relation 260 (XQD_1200_2000) is ok

08:21:31.53 Relation 261 (XQD_1000_3300)
08:21:31.53 process pointer page 0 of 14
08:21:31.64 process pointer page 1 of 14
08:21:31.75 process pointer page 2 of 14
08:21:31.86 process pointer page 3 of 14
08:21:31.96 process pointer page 4 of 14
08:21:32.06 process pointer page 5 of 14
08:21:32.17 process pointer page 6 of 14
08:21:32.29 process pointer page 7 of 14
08:21:32.39 process pointer page 8 of 14
08:21:32.48 process pointer page 9 of 14
08:21:32.57 process pointer page 10 of 14
08:21:32.68 process pointer page 11 of 14
08:21:32.78 process pointer page 12 of 14
08:21:32.89 process pointer page 13 of 14
08:21:32.98 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
08:21:33.62 Index 2 (XQD_1000_3300_DOC)
08:21:34.13 Relation 261 (XQD_1000_3300) is ok

08:21:34.13 Relation 262 (XQD_2000_3300)
08:21:34.13 process pointer page 0 of 21
08:21:34.29 process pointer page 1 of 21
08:21:34.43 process pointer page 2 of 21
08:21:34.55 process pointer page 3 of 21
08:21:34.69 process pointer page 4 of 21
08:21:34.82 process pointer page 5 of 21
08:21:34.96 process pointer page 6 of 21
08:21:35.08 process pointer page 7 of 21
08:21:35.21 process pointer page 8 of 21
08:21:35.33 process pointer page 9 of 21
08:21:35.47 process pointer page 10 of 21
08:21:35.62 process pointer page 11 of 21
08:21:35.76 process pointer page 12 of 21
08:21:35.90 process pointer page 13 of 21
08:21:36.02 process pointer page 14 of 21
08:21:36.15 process pointer page 15 of 21
08:21:36.29 process pointer page 16 of 21
08:21:36.41 process pointer page 17 of 21
08:21:36.55 process pointer page 18 of 21
08:21:36.60 process pointer page 19 of 21
08:21:36.64 process pointer page 20 of 21
08:21:36.72 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
08:21:37.63 Relation 262 (XQD_2000_3300) is ok

08:21:37.63 Relation 263 (XQD_2100_3300)
08:21:37.63 process pointer page 0 of 14
08:21:37.69 process pointer page 1 of 14
08:21:37.77 process pointer page 2 of 14
08:21:37.83 process pointer page 3 of 14
08:21:37.89 process pointer page 4 of 14
08:21:37.96 process pointer page 5 of 14
08:21:38.02 process pointer page 6 of 14
08:21:38.08 process pointer page 7 of 14
08:21:38.14 process pointer page 8 of 14
08:21:38.21 process pointer page 9 of 14
08:21:38.27 process pointer page 10 of 14
08:21:38.33 process pointer page 11 of 14
08:21:38.40 process pointer page 12 of 14
08:21:38.47 process pointer page 13 of 14
08:21:38.48 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
08:21:38.49 Relation 263 (XQD_2100_3300) is ok

08:21:38.49 Relation 264 (XQD_3300_3400)
08:21:38.49 process pointer page 0 of 21
08:21:38.59 process pointer page 1 of 21
08:21:38.70 process pointer page 2 of 21
08:21:38.80 process pointer page 3 of 21
08:21:38.90 process pointer page 4 of 21
08:21:39.00 process pointer page 5 of 21
08:21:39.09 process pointer page 6 of 21
08:21:39.19 process pointer page 7 of 21
08:21:39.28 process pointer page 8 of 21
08:21:39.39 process pointer page 9 of 21
08:21:39.50 process pointer page 10 of 21
08:21:39.60 process pointer page 11 of 21
08:21:39.70 process pointer page 12 of 21
08:21:39.80 process pointer page 13 of 21
08:21:39.90 process pointer page 14 of 21
08:21:40.01 process pointer page 15 of 21
08:21:40.11 process pointer page 16 of 21
08:21:40.21 process pointer page 17 of 21
08:21:40.32 process pointer page 18 of 21
08:21:40.42 process pointer page 19 of 21
08:21:40.53 process pointer page 20 of 21
08:21:40.57 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
08:21:41.60 Relation 264 (XQD_3300_3400) is ok

08:21:41.60 Relation 265 (XQS_1000_1200)
08:21:41.60 process pointer page 0 of 37
08:21:41.70 process pointer page 1 of 37
08:21:41.77 process pointer page 2 of 37
08:21:41.87 process pointer page 3 of 37
08:21:41.96 process pointer page 4 of 37
08:21:42.05 process pointer page 5 of 37
08:21:42.13 process pointer page 6 of 37
08:21:42.23 process pointer page 7 of 37
08:21:42.32 process pointer page 8 of 37
08:21:42.41 process pointer page 9 of 37
08:21:42.49 process pointer page 10 of 37
08:21:42.58 process pointer page 11 of 37
08:21:42.68 process pointer page 12 of 37
08:21:42.76 process pointer page 13 of 37
08:21:42.85 process pointer page 14 of 37
08:21:42.94 process pointer page 15 of 37
08:21:43.04 process pointer page 16 of 37
08:21:43.11 process pointer page 17 of 37
08:21:43.21 process pointer page 18 of 37
08:21:43.30 process pointer page 19 of 37
08:21:43.40 process pointer page 20 of 37
08:21:43.47 process pointer page 21 of 37
08:21:43.57 process pointer page 22 of 37
08:21:43.66 process pointer page 23 of 37
08:21:43.75 process pointer page 24 of 37
08:21:43.83 process pointer page 25 of 37
08:21:43.93 process pointer page 26 of 37
08:21:44.02 process pointer page 27 of 37
08:21:44.11 process pointer page 28 of 37
08:21:44.19 process pointer page 29 of 37
08:21:44.28 process pointer page 30 of 37
08:21:44.38 process pointer page 31 of 37
08:21:44.47 process pointer page 32 of 37
08:21:44.55 process pointer page 33 of 37
08:21:44.65 process pointer page 34 of 37
08:21:44.74 process pointer page 35 of 37
08:21:44.83 process pointer page 36 of 37
08:21:44.84 Index 1 (XQS_1000_1200_DOC_ID)
08:21:46.06 Index 2 (XQS_1000_1200_SND_ID)
08:21:47.31 Index 3 (XQS_1000_1200_RCV_ID)
08:21:48.45 Relation 265 (XQS_1000_1200) is ok

08:21:48.45 Relation 266 (XQS_1200_2000)
08:21:48.45 process pointer page 0 of 42
08:21:48.54 process pointer page 1 of 42
08:21:48.62 process pointer page 2 of 42
08:21:48.71 process pointer page 3 of 42
08:21:48.79 process pointer page 4 of 42
08:21:48.89 process pointer page 5 of 42
08:21:48.98 process pointer page 6 of 42
08:21:49.06 process pointer page 7 of 42
08:21:49.15 process pointer page 8 of 42
08:21:49.24 process pointer page 9 of 42
08:21:49.34 process pointer page 10 of 42
08:21:49.43 process pointer page 11 of 42
08:21:49.52 process pointer page 12 of 42
08:21:49.62 process pointer page 13 of 42
08:21:49.71 process pointer page 14 of 42
08:21:49.81 process pointer page 15 of 42
08:21:49.90 process pointer page 16 of 42
08:21:50.01 process pointer page 17 of 42
08:21:50.10 process pointer page 18 of 42
08:21:50.20 process pointer page 19 of 42
08:21:50.30 process pointer page 20 of 42
08:21:50.40 process pointer page 21 of 42
08:21:50.49 process pointer page 22 of 42
08:21:50.59 process pointer page 23 of 42
08:21:50.68 process pointer page 24 of 42
08:21:50.79 process pointer page 25 of 42
08:21:50.88 process pointer page 26 of 42
08:21:50.99 process pointer page 27 of 42
08:21:51.08 process pointer page 28 of 42
08:21:51.18 process pointer page 29 of 42
08:21:51.29 process pointer page 30 of 42
08:21:51.40 process pointer page 31 of 42
08:21:51.49 process pointer page 32 of 42
08:21:51.58 process pointer page 33 of 42
08:21:51.69 process pointer page 34 of 42
08:21:51.79 process pointer page 35 of 42
08:21:51.88 process pointer page 36 of 42
08:21:51.99 process pointer page 37 of 42
08:21:52.07 process pointer page 38 of 42
08:21:52.16 process pointer page 39 of 42
08:21:52.27 process pointer page 40 of 42
08:21:52.36 process pointer page 41 of 42
08:21:52.43 Index 1 (XQS_1200_2000_DOC_ID)
08:21:54.02 Index 2 (XQS_1200_2000_SND_ID)
08:21:55.67 Index 3 (XQS_1200_2000_RCV_ID)
08:21:57.06 Relation 266 (XQS_1200_2000) is ok

08:21:57.06 Relation 267 (XQS_1000_3300)
08:21:57.06 process pointer page 0 of 16
08:21:57.14 process pointer page 1 of 16
08:21:57.23 process pointer page 2 of 16
08:21:57.32 process pointer page 3 of 16
08:21:57.42 process pointer page 4 of 16
08:21:57.51 process pointer page 5 of 16
08:21:57.61 process pointer page 6 of 16
08:21:57.70 process pointer page 7 of 16
08:21:57.79 process pointer page 8 of 16
08:21:57.89 process pointer page 9 of 16
08:21:57.96 process pointer page 10 of 16
08:21:58.06 process pointer page 11 of 16
08:21:58.15 process pointer page 12 of 16
08:21:58.25 process pointer page 13 of 16
08:21:58.34 process pointer page 14 of 16
08:21:58.42 process pointer page 15 of 16
08:21:58.45 Index 1 (XQS_1000_3300_DOC_ID)
08:21:59.01 Index 2 (XQS_1000_3300_SND_ID)
08:21:59.59 Index 3 (XQS_1000_3300_RCV_ID)
08:22:00.09 Relation 267 (XQS_1000_3300) is ok

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

08:22:00.09 Relation 269 (XQS_2100_3300)
08:22:00.09 process pointer page 0 of 27
08:22:00.18 process pointer page 1 of 27
08:22:00.27 process pointer page 2 of 27
08:22:00.37 process pointer page 3 of 27
08:22:00.46 process pointer page 4 of 27
08:22:00.54 process pointer page 5 of 27
08:22:00.63 process pointer page 6 of 27
08:22:00.73 process pointer page 7 of 27
08:22:00.82 process pointer page 8 of 27
08:22:00.90 process pointer page 9 of 27
08:22:00.99 process pointer page 10 of 27
08:22:01.08 process pointer page 11 of 27
08:22:01.16 process pointer page 12 of 27
08:22:01.26 process pointer page 13 of 27
08:22:01.35 process pointer page 14 of 27
08:22:01.44 process pointer page 15 of 27
08:22:01.52 process pointer page 16 of 27
08:22:01.61 process pointer page 17 of 27
08:22:01.71 process pointer page 18 of 27
08:22:01.79 process pointer page 19 of 27
08:22:01.88 process pointer page 20 of 27
08:22:01.97 process pointer page 21 of 27
08:22:02.05 process pointer page 22 of 27
08:22:02.15 process pointer page 23 of 27
08:22:02.24 process pointer page 24 of 27
08:22:02.32 process pointer page 25 of 27
08:22:02.41 process pointer page 26 of 27
08:22:02.43 Index 1 (XQS_2100_3300_DOC_ID)
08:22:03.39 Index 2 (XQS_2100_3300_SND_ID)
08:22:04.42 Index 3 (XQS_2100_3300_RCV_ID)
08:22:05.33 Relation 269 (XQS_2100_3300) is ok

08:22:05.33 Relation 270 (XQS_3300_3400)
08:22:05.33 process pointer page 0 of 5
08:22:05.42 process pointer page 1 of 5
08:22:05.51 process pointer page 2 of 5
08:22:05.61 process pointer page 3 of 5
08:22:05.70 process pointer page 4 of 5
08:22:05.70 Index 1 (XQS_3300_3400_DOC_ID)
08:22:05.84 Index 2 (XQS_3300_3400_SND_ID)
08:22:06.00 Relation 270 (XQS_3300_3400) is ok

08:22:06.00 Relation 276 (TRACE_STAT)
08:22:06.00 process pointer page 0 of 1
08:22:06.00 Relation 276 (TRACE_STAT) is ok

08:22:06.00 Validation finished
Done for 71350 ms, from 8:20:54.66 to 8:22:06.01.

Differences between old and current firebird.log

8:22:07.17. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-03-19 08:22 513 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

+++ Start of comparison +++
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Sat Mar 19 08:20:54 2016
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sat Mar 19 08:22:06 2016
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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


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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-03-19 8:22:17.95 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html

Subscribe to IBSurgeon news

Subscribe