Tests

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

Server and database settings

Server version: WI-V3.0.3.32757 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperServer 3.0.3 D:\OLTP-EMUL\OLTP30-SMALL.FDB ON 0 786432 8192

Test configuration settings

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

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2017-07-22 06:46:42.4660 -1 <null> ::1/59193 401193 9254 2

Current test settings

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

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

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

Performance reports

Performance in TOTAL:

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 5211.28 5116 938030 2017-07-22 03:46 2017-07-22 06:46
customer order: creation 405.98 629 73076 2017-07-22 03:46 2017-07-22 06:46
customer order: refuse 32.07 330 5773 2017-07-22 03:46 2017-07-22 06:46
order to supplier: creation 103.52 2758 18633 2017-07-22 03:46 2017-07-22 06:46
order to supplier: removal 2.73 31570 488 2017-07-22 03:46 2017-07-22 06:46
invoice (draft): creation 104.94 4043 18889 2017-07-22 03:46 2017-07-22 06:46
invoice (draft): removal 36.72 653 6610 2017-07-22 03:46 2017-07-22 06:46
invoice accept: apply 60.01 19868 10802 2017-07-22 03:46 2017-07-22 06:46
invoice accept: cancel 16.17 4111 2911 2017-07-22 03:46 2017-07-22 06:46
customer reserve: creation 3008.24 338 541484 2017-07-22 03:46 2017-07-22 06:46
customer reserve: removal 879.78 111 158361 2017-07-22 03:46 2017-07-22 06:46
realization accept: apply 185.79 771 33443 2017-07-22 03:46 2017-07-22 06:46
realization accept: cancel 80.89 234 14561 2017-07-22 03:46 2017-07-22 06:46
payment from customer: creation 137.22 1199 24700 2017-07-22 03:46 2017-07-22 06:46
payment from customer: removal 12.77 169 2298 2017-07-22 03:46 2017-07-22 06:46
payment to supplier: creation 111.57 1755 20082 2017-07-22 03:46 2017-07-22 06:46
payment to supplier: removal 7.92 174 1425 2017-07-22 03:46 2017-07-22 06:46
service: total inventory turnovers 7.49 4642 1349 2017-07-22 03:46 2017-07-22 06:46
service: total monetary turnovers 17.41 73 3133 2017-07-22 03:46 2017-07-22 06:46
service: refresh index statistics 0.07 23775 12 2017-07-22 03:46 2017-07-22 06:46
Done for 70820 ms, from 6:52:18.49 to 6:53:29.31.

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 4240 87814 76318 11496 13.09 03:46:43 04:04:43
interval # 2, overall 2 4674 92800 84128 8672 9.34 04:04:44 04:22:44
interval # 3, overall 3 5276 103729 94971 8758 8.44 04:22:45 04:40:45
interval # 4, overall 4 5107 99233 91933 7300 7.36 04:40:46 04:58:46
interval # 5, overall 5 5294 105346 95297 10049 9.54 04:58:47 05:16:47
interval # 6, overall 6 4773 94850 85918 8932 9.42 05:16:48 05:34:48
interval # 7, overall 7 5599 115470 100784 14686 12.72 05:34:49 05:52:49
interval # 8, overall 8 5751 113621 103515 10106 8.89 05:52:50 06:10:50
interval # 9, overall 9 5758 117652 103647 14005 11.90 06:10:51 06:28:51
interval # 10, overall 10 5640 114920 101519 13401 11.66 06:28:52 06:46:52
Done for 167870 ms, from 6:56:13.47 to 6:59:01.34.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
TEST_TIME 1 2660.09 0.3319 1.5416 2048 50
TEST_TIME 2 2839.14 0.7297 1.3518 1727 50
TEST_TIME 3 3170.41 0.8071 1.1961 1444 50
TEST_TIME 4 3231.57 0.8805 1.1309 1660 53
TEST_TIME 5 3278.75 0.8975 1.0835 1237 100
TEST_TIME 6 3313.51 0.8934 1.1093 1681 100
TEST_TIME 7 3415.49 0.9224 1.0902 1619 100
TEST_TIME 8 3586.13 0.9086 1.0868 1986 100
TEST_TIME 9 3726.10 0.9298 1.0721 1920 100
TEST_TIME 10 3853.44 0.9330 1.0761 1936 100
TEST_TIME 11 3982.22 0.9467 1.0483 1522 100
TEST_TIME 12 4040.61 0.9471 1.0499 1553 100
TEST_TIME 13 4064.77 0.9635 1.0383 1542 100
TEST_TIME 14 4113.85 0.9527 1.0423 1546 100
TEST_TIME 15 4167.12 0.9604 1.0363 1299 100
TEST_TIME 16 4175.90 0.9695 1.0256 1518 100
TEST_TIME 17 4159.19 0.9692 1.0436 1369 100
TEST_TIME 18 4175.54 0.9818 1.0206 1578 99
TEST_TIME 19 4149.16 0.9730 1.0429 1434 99
TEST_TIME 20 4237.63 0.9701 1.0275 1699 100
TEST_TIME 21 4287.32 0.9678 1.0261 2113 100
TEST_TIME 22 4310.49 0.9742 1.0271 1858 98
TEST_TIME 23 4370.05 0.9716 1.0135 1661 100
TEST_TIME 24 4338.80 0.9783 1.0262 1511 93
TEST_TIME 25 4390.35 0.9736 1.0179 1343 100
TEST_TIME 26 4361.31 0.9853 1.0180 1573 93
TEST_TIME 27 4416.82 0.9680 1.0174 1268 100
TEST_TIME 28 4482.07 0.9668 1.0213 1405 100
TEST_TIME 29 4522.90 0.9772 1.0129 1474 100
TEST_TIME 30 4507.93 0.9830 1.0081 1161 97
TEST_TIME 31 4499.30 0.9775 1.0085 1257 100
TEST_TIME 32 4442.72 0.9895 1.0127 1304 90
TEST_TIME 33 4420.52 0.9869 1.0114 1208 87
TEST_TIME 34 4404.15 0.9853 1.0245 1065 95
TEST_TIME 35 4415.53 0.9927 1.0086 1313 92
TEST_TIME 36 4400.78 0.9839 1.0210 1250 100
TEST_TIME 37 4427.02 0.9881 1.0163 1718 97
TEST_TIME 38 4443.03 0.9860 1.0132 1705 99
TEST_TIME 39 4431.50 0.9898 1.0206 1637 95
TEST_TIME 40 4491.74 0.9817 1.0166 1524 100
TEST_TIME 41 4533.18 0.9827 1.0151 1704 100
TEST_TIME 42 4550.86 0.9871 1.0113 1366 100
TEST_TIME 43 4551.81 0.9876 1.0076 1391 100
TEST_TIME 44 4513.98 0.9930 1.0076 1231 84
TEST_TIME 45 4515.82 0.9848 1.0201 1146 98
TEST_TIME 46 4564.84 0.9872 1.0098 1343 100
TEST_TIME 47 4601.57 0.9871 1.0136 1308 100
TEST_TIME 48 4600.72 0.9927 1.0090 1365 99
TEST_TIME 49 4612.37 0.9859 1.0113 1225 100
TEST_TIME 50 4623.03 0.9888 1.0124 1373 99
TEST_TIME 51 4636.08 0.9897 1.0073 1850 100
TEST_TIME 52 4653.33 0.9843 1.0140 1689 97
TEST_TIME 53 4657.86 0.9940 1.0076 1486 89
TEST_TIME 54 4680.32 0.9842 1.0100 1430 99
TEST_TIME 55 4686.46 0.9903 1.0136 1420 98
TEST_TIME 56 4739.05 0.9872 1.0109 1286 100
TEST_TIME 57 4745.15 0.9919 1.0145 1399 99
TEST_TIME 58 4761.12 0.9937 1.0086 1582 98
TEST_TIME 59 4759.23 0.9922 1.0072 1403 94
TEST_TIME 60 4741.04 0.9942 1.0067 1337 92
TEST_TIME 61 4748.92 0.9885 1.0078 1178 99
TEST_TIME 62 4747.61 0.9941 1.0037 1151 100
TEST_TIME 63 4710.24 0.9956 1.0051 1249 94
TEST_TIME 64 4716.38 0.9881 1.0108 1208 99
TEST_TIME 65 4726.08 0.9932 1.0050 1708 100
TEST_TIME 66 4743.19 0.9862 1.0084 1461 100
TEST_TIME 67 4746.30 0.9927 1.0085 1662 92
TEST_TIME 68 4749.72 0.9929 1.0127 1521 96
TEST_TIME 69 4771.40 0.9935 1.0070 1560 99
TEST_TIME 70 4767.05 0.9935 1.0068 1560 92
TEST_TIME 71 4770.71 0.9919 1.0073 1513 90
TEST_TIME 72 4776.36 0.9921 1.0143 1134 96
TEST_TIME 73 4806.94 0.9940 1.0072 1220 100
TEST_TIME 74 4793.47 0.9964 1.0025 1357 87
TEST_TIME 75 4768.32 0.9944 1.0037 935 87
TEST_TIME 76 4762.92 0.9916 1.0083 1268 100
TEST_TIME 77 4771.90 0.9934 1.0072 1354 100
TEST_TIME 78 4774.86 0.9937 1.0107 1232 100
TEST_TIME 79 4796.85 0.9934 1.0045 1362 99
TEST_TIME 80 4807.32 0.9898 1.0064 1611 98
TEST_TIME 81 4794.32 0.9967 1.0037 1423 82
TEST_TIME 82 4783.20 0.9938 1.0063 1228 86
TEST_TIME 83 4808.77 0.9889 1.0061 1372 97
TEST_TIME 84 4819.81 0.9919 1.0091 1527 94
TEST_TIME 85 4848.71 0.9913 1.0045 1371 100
TEST_TIME 86 4844.06 0.9938 1.0106 1419 99
TEST_TIME 87 4878.10 0.9922 1.0064 1437 100
TEST_TIME 88 4894.79 0.9916 1.0039 1494 100
TEST_TIME 89 4883.53 0.9949 1.0056 1335 98
TEST_TIME 90 4879.82 0.9952 1.0052 1392 92
TEST_TIME 91 4887.08 0.9927 1.0093 1208 98
TEST_TIME 92 4887.04 0.9983 1.0022 1129 92
TEST_TIME 93 4861.46 0.9967 1.0038 1083 84
TEST_TIME 94 4856.61 0.9943 1.0056 1168 97
TEST_TIME 95 4852.14 0.9960 1.0076 1036 98
TEST_TIME 96 4858.61 0.9958 1.0030 1183 91
TEST_TIME 97 4833.12 0.9979 1.0023 956 69
TEST_TIME 98 4808.86 0.9971 1.0031 1064 72
TEST_TIME 99 4798.21 0.9952 1.0050 1162 87
TEST_TIME 100 4802.72 0.9940 1.0055 1306 90
TEST_TIME 101 4823.05 0.9914 1.0042 1432 97
TEST_TIME 102 4828.47 0.9933 1.0044 1315 95
TEST_TIME 103 4841.87 0.9919 1.0046 1146 99
TEST_TIME 104 4835.11 0.9963 1.0051 1313 98
TEST_TIME 105 4838.99 0.9947 1.0059 1243 97
TEST_TIME 106 4859.67 0.9922 1.0057 1111 96
TEST_TIME 107 4880.31 0.9921 1.0028 1070 100
TEST_TIME 108 4862.76 0.9971 1.0041 1125 92
TEST_TIME 109 4878.72 0.9917 1.0051 1064 100
TEST_TIME 110 4872.23 0.9973 1.0035 1417 99
TEST_TIME 111 4878.63 0.9932 1.0074 1508 97
TEST_TIME 112 4905.32 0.9929 1.0055 1423 100
TEST_TIME 113 4923.35 0.9930 1.0060 1288 100
TEST_TIME 114 4944.37 0.9929 1.0066 1490 100
TEST_TIME 115 4951.70 0.9964 1.0065 1404 100
TEST_TIME 116 4970.53 0.9941 1.0049 1494 100
TEST_TIME 117 4966.70 0.9971 1.0050 1373 98
TEST_TIME 118 4972.15 0.9954 1.0035 1396 98
TEST_TIME 119 4972.66 0.9950 1.0031 1160 92
TEST_TIME 120 4966.32 0.9960 1.0049 1132 98
TEST_TIME 121 4964.82 0.9969 1.0024 1126 91
TEST_TIME 122 4959.58 0.9953 1.0051 1113 98
TEST_TIME 123 4960.43 0.9967 1.0041 1080 86
TEST_TIME 124 4961.27 0.9958 1.0037 1138 93
TEST_TIME 125 4961.54 0.9956 1.0035 1221 96
TEST_TIME 126 4974.05 0.9954 1.0028 1541 96
TEST_TIME 127 4983.92 0.9929 1.0044 1374 96
TEST_TIME 128 4996.83 0.9940 1.0052 1321 99
TEST_TIME 129 4998.13 0.9971 1.0030 1593 98
TEST_TIME 130 4994.38 0.9960 1.0045 1416 96
TEST_TIME 131 5007.62 0.9942 1.0043 1445 96
TEST_TIME 132 5002.56 0.9977 1.0046 1291 92
TEST_TIME 133 5018.78 0.9939 1.0029 1112 100
TEST_TIME 134 5015.12 0.9961 1.0037 1391 100
TEST_TIME 135 5013.49 0.9966 1.0019 1239 99
TEST_TIME 136 4999.56 0.9973 1.0024 1293 95
TEST_TIME 137 5016.28 0.9958 1.0017 1166 100
TEST_TIME 138 5006.14 0.9965 1.0023 1179 98
TEST_TIME 139 5001.75 0.9961 1.0032 1142 90
TEST_TIME 140 5022.65 0.9919 1.0046 1339 100
TEST_TIME 141 5033.29 0.9954 1.0042 1384 96
TEST_TIME 142 5038.67 0.9961 1.0067 1367 93
TEST_TIME 143 5057.57 0.9960 1.0063 1477 98
TEST_TIME 144 5073.99 0.9961 1.0027 1211 100
TEST_TIME 145 5078.84 0.9948 1.0038 1313 98
TEST_TIME 146 5073.40 0.9980 1.0030 1427 92
TEST_TIME 147 5099.24 0.9942 1.0040 1162 100
TEST_TIME 148 5097.13 0.9976 1.0019 1415 99
TEST_TIME 149 5104.39 0.9937 1.0024 1100 98
TEST_TIME 150 5094.42 0.9977 1.0030 1102 91
TEST_TIME 151 5102.97 0.9947 1.0018 1143 96
TEST_TIME 152 5091.37 0.9975 1.0030 1123 86
TEST_TIME 153 5097.19 0.9953 1.0039 1147 92
TEST_TIME 154 5102.08 0.9965 1.0049 893 99
TEST_TIME 155 5109.32 0.9970 1.0020 1320 100
TEST_TIME 156 5115.78 0.9967 1.0027 1673 98
TEST_TIME 157 5115.10 0.9965 1.0048 1546 97
TEST_TIME 158 5138.46 0.9939 1.0018 1439 97
TEST_TIME 159 5138.89 0.9954 1.0037 1363 95
TEST_TIME 160 5140.16 0.9972 1.0023 1190 87
TEST_TIME 161 5138.91 0.9964 1.0031 1200 88
TEST_TIME 162 5146.51 0.9954 1.0016 928 89
TEST_TIME 163 5149.62 0.9975 1.0036 994 100
TEST_TIME 164 5156.52 0.9961 1.0018 1221 100
TEST_TIME 165 5154.11 0.9962 1.0020 1293 98
TEST_TIME 166 5159.37 0.9950 1.0027 1060 99
TEST_TIME 167 5149.25 0.9986 1.0013 1235 82
TEST_TIME 168 5138.14 0.9975 1.0033 1024 85
TEST_TIME 169 5134.97 0.9979 1.0022 1139 86
TEST_TIME 170 5136.99 0.9959 1.0046 1170 93
TEST_TIME 171 5145.18 0.9978 1.0039 1448 94
TEST_TIME 172 5163.40 0.9949 1.0012 1162 100
TEST_TIME 173 5152.80 0.9975 1.0029 1101 82
TEST_TIME 174 5157.85 0.9962 1.0035 1200 87
TEST_TIME 175 5167.36 0.9959 1.0054 1306 99
TEST_TIME 176 5182.40 0.9967 1.0033 1107 100
TEST_TIME 177 5197.72 0.9947 1.0041 1201 100
TEST_TIME 178 5207.15 0.9967 1.0015 1165 100
TEST_TIME 179 5204.09 0.9965 1.0020 1247 96
TEST_TIME 180 5203.54 0.9965 1.0014 944 98
Done for 10010 ms, from 6:59:02.39 to 6:59:12.40.

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 58746 16351 42010 96030 49207 50576 50837 84160 127917 137515 65711 56874 63340 <null> 82914 99294 116032 356696 <null> 03:46:43 04:04:43
fetches per second 2 18461 23795 7252 9841 15845 <null> 25134 <null> 3514 61523 14699 47550 10846 9019 16148 2228 9100 45806 <null> 04:04:44 04:22:44
fetches per second 3 8766 6576 10353 <null> 7191 2886 18583 <null> 3194 2160 14381 3970 14426 13240 21592 54115 <null> 113181 <null> 04:22:45 04:40:45
fetches per second 4 4791 4734 3630 <null> 5461 <null> 16557 3174 7212 2386 7133 2363 9682 9298 16233 6543 15640 100974 <null> 04:40:46 04:58:46
fetches per second 5 26490 32156 17929 <null> 15399 <null> 17849 <null> 31418 25526 23565 <null> 32794 1819 33372 126500 28694 69539 <null> 04:58:47 05:16:47
fetches per second 6 2393 3535 6738 11374 4820 2183 5921 <null> 4653 4499 4174 2327 8147 2213 20784 <null> 12713 142106 <null> 05:16:48 05:34:48
fetches per second 7 12348 24428 2906 <null> 7759 17399 5731 6975 15285 3094 10115 9281 19542 19201 18165 9372 <null> 76328 <null> 05:34:49 05:52:49
fetches per second 8 6690 6192 11998 <null> 16344 3082 6822 <null> <null> 3869 6589 <null> 6271 1243 16442 3551 162956 55576 <null> 05:52:50 06:10:50
fetches per second 9 3911 3168 5757 <null> 3606 <null> 13277 <null> 2332 4506 6521 563 10385 24033 5312 1067 47215 249583 <null> 06:10:51 06:28:51
fetches per second 10 15124 25593 4080 <null> 16220 18143 38935 9058 4183 2245 11523 167100 26940 1615 50587 4573 33167 139205 <null> 06:28:52 06:46:52
marks per second 1 12738 1990 9416 19239 10878 11092 7032 13393 22012 26135 11318 9041 5652 <null> 3358 16076 15352 21245 <null> 03:46:43 04:04:43
marks per second 2 3939 3446 1431 2071 3014 <null> 2810 <null> 661 11571 2306 7756 805 1648 535 378 531 704 <null> 04:04:44 04:22:44
marks per second 3 1749 880 1988 <null> 1291 693 2607 <null> 384 324 2354 586 707 2350 822 10534 <null> 4649 <null> 04:22:45 04:40:45
marks per second 4 957 558 623 <null> 821 <null> 2110 471 632 357 1111 357 278 1117 541 1079 1056 1522 <null> 04:40:46 04:58:46
marks per second 5 5333 4239 3631 <null> 2941 <null> 2452 <null> 4243 5763 2934 <null> 1206 257 1564 18500 1085 1067 <null> 04:58:47 05:16:47
marks per second 6 500 467 987 1973 711 501 568 <null> 572 708 593 352 185 350 376 <null> 303 827 <null> 05:16:48 05:34:48
marks per second 7 2479 3041 483 <null> 1417 4561 575 1009 3004 475 1430 1323 705 2623 494 1261 <null> 1096 <null> 05:34:49 05:52:49
marks per second 8 1392 829 2034 <null> 3205 773 693 <null> <null> 590 697 <null> 216 166 657 564 4580 2261 <null> 05:52:50 06:10:50
marks per second 9 785 420 830 <null> 512 <null> 1215 <null> 302 658 827 81 233 3233 228 169 1108 938 <null> 06:10:51 06:28:51
marks per second 10 3087 2992 645 <null> 3475 4719 4421 1290 218 330 1489 14700 1026 186 3854 670 998 1375 <null> 06:28:52 06:46:52
reads/fetches*100 1 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 <null> 03:46:43 04:04:43
reads/fetches*100 2 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 04:04:44 04:22:44
reads/fetches*100 3 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 <null> 0 <null> 04:22:45 04:40:45
reads/fetches*100 4 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:40:46 04:58:46
reads/fetches*100 5 0 0 0 <null> 0 <null> 0 <null> 0 0 0 <null> 0 0 0 0 0 0 <null> 04:58:47 05:16:47
reads/fetches*100 6 0 0 0 0 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 05:16:48 05:34:48
reads/fetches*100 7 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 05:34:49 05:52:49
reads/fetches*100 8 0 0 0 <null> 0 0 0 <null> <null> 0 0 <null> 0 0 0 0 0 0 <null> 05:52:50 06:10:50
reads/fetches*100 9 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 06:10:51 06:28:51
reads/fetches*100 10 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 06:28:52 06:46:52
writes/marks*100 1 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 3 0 <null> 03:46:43 04:04:43
writes/marks*100 2 0 0 0 0 0 <null> 0 <null> 0 1 0 0 0 0 0 0 2 0 <null> 04:04:44 04:22:44
writes/marks*100 3 0 0 0 <null> 0 0 0 <null> 1 1 0 0 0 0 0 0 <null> 0 <null> 04:22:45 04:40:45
writes/marks*100 4 0 0 0 <null> 0 <null> 0 0 0 1 0 0 0 1 0 0 1 0 <null> 04:40:46 04:58:46
writes/marks*100 5 0 0 0 <null> 0 <null> 0 <null> 1 1 0 <null> 0 0 0 0 2 0 <null> 04:58:47 05:16:47
writes/marks*100 6 0 0 0 0 1 0 0 <null> 0 1 0 0 0 0 0 <null> 3 0 <null> 05:16:48 05:34:48
writes/marks*100 7 0 0 0 <null> 0 0 0 0 1 1 0 0 0 1 0 0 <null> 0 <null> 05:34:49 05:52:49
writes/marks*100 8 0 0 0 <null> 0 0 0 <null> <null> 1 0 <null> 0 0 0 0 7 0 <null> 05:52:50 06:10:50
writes/marks*100 9 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 2 0 <null> 06:10:51 06:28:51
writes/marks*100 10 0 0 0 <null> 0 0 0 0 1 1 0 0 0 0 0 3 26 0 <null> 06:28:52 06:46:52
Done for 8660 ms, from 6:59:13.32 to 6:59:21.98.

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 1618165 1521230 96935 5.99 0 11029 84 96769 2017-07-22 03:46 2017-07-22 06:46
doc_list_biud 1618551 1521230 97321 6.01 0 7238 25 97164 2017-07-22 03:46 2017-07-22 06:46
sp_add_invoice_to_stock 17722 10802 6920 39.04 16 269911 19868 6918 2017-07-22 03:46 2017-07-22 06:46
sp_cancel_adding_invoice 3710 2911 799 21.53 0 89622 4111 799 2017-07-22 03:46 2017-07-22 06:46
sp_cancel_client_order 5904 5773 131 2.21 0 4742 330 131 2017-07-22 03:46 2017-07-22 06:46
sp_cancel_customer_reserve 246035 158361 87674 35.63 0 4571 111 87674 2017-07-22 03:46 2017-07-22 06:46
sp_cancel_pay_from_customer 2309 2298 11 0.47 0 1809 169 11 2017-07-22 03:46 2017-07-22 06:46
sp_cancel_pay_to_supplier 1429 1425 4 0.27 0 2995 174 4 2017-07-22 03:46 2017-07-22 06:46
sp_cancel_supplier_invoice 8291 6610 1681 20.27 0 8783 653 1681 2017-07-22 03:46 2017-07-22 06:46
sp_cancel_supplier_order 1402 488 914 65.19 94 307866 31570 914 2017-07-22 03:46 2017-07-22 06:46
sp_cancel_write_off 22251 14561 7690 34.56 0 3307 234 7690 2017-07-22 03:46 2017-07-22 06:46
sp_client_order 73076 73076 0 0.00 0 5741 629 0 2017-07-22 03:46 2017-07-22 06:46
sp_customer_reserve 541568 541484 84 0.01 0 8798 338 0 2017-07-22 03:46 2017-07-22 06:46
sp_fill_shopping_cart 110804 110598 206 0.18 0 4883 123 0 2017-07-22 03:46 2017-07-22 06:46
sp_fill_shopping_cart_clo_res 541569 541484 85 0.01 0 4571 23 0 2017-07-22 03:46 2017-07-22 06:46
sp_get_clo_for_invoice 10804 10802 2 0.01 0 5912 436 0 2017-07-22 03:46 2017-07-22 06:46
sp_kill_cost_storno 29323 21195 8128 27.71 0 2309 28 8128 2017-07-22 03:46 2017-07-22 06:46
sp_kill_qstorno_ret_qs2qd 522264 338381 183883 35.20 0 7191 41 183883 2017-07-22 03:46 2017-07-22 06:46
sp_kill_qty_storno 330033 232949 97084 29.41 0 7207 116 97082 2017-07-22 03:46 2017-07-22 06:46
sp_lock_selected_doc 72044 61842 10202 14.16 0 1747 9 10200 2017-07-22 03:46 2017-07-22 06:46
sp_make_cost_storno 89029 89027 2 0.00 0 10873 788 0 2017-07-22 03:46 2017-07-22 06:46
sp_multiply_rows_for_pdistr 89029 89027 2 0.00 0 2496 73 0 2017-07-22 03:46 2017-07-22 06:46
sp_multiply_rows_for_qdistr 73076 73076 0 0.00 0 4446 210 0 2017-07-22 03:46 2017-07-22 06:46
sp_pay_from_customer 24700 24700 0 0.00 15 7613 1199 0 2017-07-22 03:46 2017-07-22 06:46
sp_pay_to_supplier 20082 20082 0 0.00 0 11169 1755 0 2017-07-22 03:46 2017-07-22 06:46
sp_payment_common 44782 44782 0 0.00 0 3073 77 0 2017-07-22 03:46 2017-07-22 06:46
sp_qd_handle_on_cancel_clo 5899 5773 126 2.13 0 4462 149 126 2017-07-22 03:46 2017-07-22 06:46
sp_qd_handle_on_invoice_upd_sts 14325 13713 612 4.27 0 5085 472 610 2017-07-22 03:46 2017-07-22 06:46
sp_qd_handle_on_reserve_upd_sts 33443 33443 0 0.00 0 2637 74 0 2017-07-22 03:46 2017-07-22 06:46
sp_reserve_write_off 34734 33443 1291 3.71 0 8253 771 1291 2017-07-22 03:46 2017-07-22 06:46
sp_supplier_invoice 18978 18889 89 0.46 0 25802 4043 0 2017-07-22 03:46 2017-07-22 06:46
sp_supplier_order 18750 18633 117 0.62 0 14680 2758 0 2017-07-22 03:46 2017-07-22 06:46
srv_find_qd_qs_mism 949685 852837 96848 10.19 0 5928 41 96764 2017-07-22 03:46 2017-07-22 06:46
srv_make_invnt_saldo 1349 1349 0 0.00 16 77376 4642 0 2017-07-22 03:46 2017-07-22 06:46
srv_make_money_saldo 3133 3133 0 0.00 0 3120 73 0 2017-07-22 03:46 2017-07-22 06:46
srv_recalc_idx_stat 12 12 0 0.00 8190 40326 23775 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_add_invoice_to_stock 6930 6930 0 0.00 0 2356 116 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_cancel_adding_invoice 750 750 0 0.00 0 2418 298 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_cancel_client_order 131 131 0 0.00 0 983 116 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_cancel_customer_reserve 82 82 0 0.00 0 1217 85 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_cancel_pay_from_customer 11 11 0 0.00 0 686 167 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_cancel_pay_to_supplier 4 4 0 0.00 125 437 351 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_cancel_supplier_invoice 573 573 0 0.00 0 1545 110 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_cancel_supplier_order 11085 11085 0 0.00 0 3198 208 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_cancel_write_off 20 20 0 0.00 0 265 71 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_reserve_write_off 1291 1291 0 0.00 0 1732 87 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_supplier_invoice 89 89 0 0.00 0 968 105 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-abend:sp_supplier_order 117 117 0 0.00 0 1311 116 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_add_invoice_to_stock 10802 10802 0 0.00 0 18315 890 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_cancel_adding_invoice 1165 1165 0 0.00 0 10187 964 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_cancel_client_order 5773 5773 0 0.00 0 1856 85 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_cancel_customer_reserve 2252 2252 0 0.00 0 2028 84 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_cancel_pay_from_customer 2298 2298 0 0.00 0 1841 63 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_cancel_pay_to_supplier 1425 1425 0 0.00 0 1576 58 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_cancel_supplier_invoice 894 894 0 0.00 0 2948 108 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_cancel_supplier_order 488 488 0 0.00 0 35677 2579 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_cancel_write_off 3302 3302 0 0.00 0 1638 82 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_client_order 73076 73076 0 0.00 0 3214 98 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_customer_reserve 3425 3425 0 0.00 0 1545 70 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_pay_from_customer 24700 24700 0 0.00 0 2870 84 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_pay_to_supplier 20082 20082 0 0.00 0 1950 85 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_reserve_write_off 33443 33443 0 0.00 0 3603 89 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_supplier_invoice 18889 18889 0 0.00 0 2871 94 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:sp_supplier_order 18633 18633 0 0.00 0 2886 96 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:srv_make_invnt_saldo 1349 1349 0 0.00 0 1389 41 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:srv_make_money_saldo 3133 3133 0 0.00 0 1295 32 0 2017-07-22 03:46 2017-07-22 06:46
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 952 179 0 2017-07-22 03:46 2017-07-22 06:46
v_add_invoice_to_stock 35444 21604 13840 39.04 0 9220 106 13836 2017-07-22 03:46 2017-07-22 06:46
v_all_customers 109800 109800 0 0.00 0 1170 7 0 2017-07-22 03:46 2017-07-22 06:46
v_all_suppliers 75456 75044 412 0.54 0 1076 7 0 2017-07-22 03:46 2017-07-22 06:46
v_all_wares 146152 146152 0 0.00 0 1170 6 0 2017-07-22 03:46 2017-07-22 06:46
v_cancel_adding_invoice 2842 2330 512 18.01 0 2808 196 512 2017-07-22 03:46 2017-07-22 06:46
v_cancel_client_order 11808 11546 262 2.21 0 1576 8 262 2017-07-22 03:46 2017-07-22 06:46
v_cancel_customer_prepayment 4618 4596 22 0.47 0 1311 10 22 2017-07-22 03:46 2017-07-22 06:46
v_cancel_customer_reserve 4668 4504 164 3.51 0 1560 12 164 2017-07-22 03:46 2017-07-22 06:46
v_cancel_payment_to_supplier 2858 2850 8 0.27 0 796 10 8 2017-07-22 03:46 2017-07-22 06:46
v_cancel_supplier_invoice 2934 1788 1146 39.05 0 7551 117 1146 2017-07-22 03:46 2017-07-22 06:46
v_cancel_supplier_order 2804 976 1828 65.19 0 1482 11 1828 2017-07-22 03:46 2017-07-22 06:46
v_cancel_write_off 6644 6604 40 0.60 0 2277 111 40 2017-07-22 03:46 2017-07-22 06:46
v_max_id_clo_ord 18750 18633 117 0.62 0 702 7 0 2017-07-22 03:46 2017-07-22 06:46
v_max_id_clo_res 3425 3425 0 0.00 0 1466 22 0 2017-07-22 03:46 2017-07-22 06:46
v_max_id_ord_sup 18978 18889 89 0.46 0 1030 7 0 2017-07-22 03:46 2017-07-22 06:46
v_max_non_paid_invoice 20082 20082 0 0.00 0 952 7 0 2017-07-22 03:46 2017-07-22 06:46
v_max_non_paid_realizn 24700 24700 0 0.00 0 1045 8 0 2017-07-22 03:46 2017-07-22 06:46
v_min_id_clo_ord 18750 18633 117 0.62 0 1560 9 0 2017-07-22 03:46 2017-07-22 06:46
v_min_id_clo_res 3425 3425 0 0.00 0 1591 12 0 2017-07-22 03:46 2017-07-22 06:46
v_min_id_ord_sup 18978 18889 89 0.46 0 1248 10 0 2017-07-22 03:46 2017-07-22 06:46
v_min_non_paid_invoice 20082 20082 0 0.00 0 1482 12 0 2017-07-22 03:46 2017-07-22 06:46
v_min_non_paid_realizn 24700 24700 0 0.00 0 1076 10 0 2017-07-22 03:46 2017-07-22 06:46
v_our_firm 36352 36352 0 0.00 0 1295 7 0 2017-07-22 03:46 2017-07-22 06:46
v_reserve_write_off 69468 66886 2582 3.71 0 1591 10 2582 2017-07-22 03:46 2017-07-22 06:46
x_lock_depdocs_on_canc_invoice 15420 8627 6793 44.05 0 5647 50 6793 2017-07-22 03:46 2017-07-22 06:46
x_lock_depdocs_on_canc_sup_ord 1398 488 910 65.09 0 1529 88 910 2017-07-22 03:46 2017-07-22 06:46
x_make_qstorno_1000_1200 18750 18633 117 0.62 0 13088 2487 0 2017-07-22 03:46 2017-07-22 06:46
x_make_qstorno_1200_2000 18978 18889 89 0.46 0 25319 3766 0 2017-07-22 03:46 2017-07-22 06:46
x_make_qstorno_2100_3300 541569 541484 85 0.01 0 8752 290 0 2017-07-22 03:46 2017-07-22 06:46
Done for 252620 ms, from 7:03:34.93 to 7:07:47.55.

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 86 sp_kill_cost_storno 335544336 2017-07-22 03:46 2017-07-22 06:41
deadlock 69 sp_kill_qstorno_ret_qs2qd 335544336 2017-07-22 03:53 2017-07-22 06:44
deadlock 8910 sp_lock_selected_doc 335544336 2017-07-22 03:46 2017-07-22 06:46
deadlock 126 sp_qd_handle_on_cancel_clo 335544336 2017-07-22 03:47 2017-07-22 06:41
deadlock 178 sp_qd_handle_on_invoice_upd_sts 335544336 2017-07-22 03:46 2017-07-22 06:46
deadlock 573 x_lock_depdocs_on_canc_invoice 335544336 2017-07-22 03:46 2017-07-22 06:46
deadlock 254 x_lock_depdocs_on_canc_sup_ord 335544336 2017-07-22 03:54 2017-07-22 06:46
user_exc 117 x_make_qstorno_1000_1200 335544517 2017-07-22 03:46 2017-07-22 06:44
user_exc 89 x_make_qstorno_1200_2000 335544517 2017-07-22 03:47 2017-07-22 06:44
user_exc 2 x_make_qstorno_2100_3300 335544517 2017-07-22 06:46 2017-07-22 06:46
Done for 6880 ms, from 7:07:54.69 to 7:08:01.57.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP30-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 401945
MON$OLDEST_ACTIVE 401946
MON$OLDEST_SNAPSHOT 401946
MON$NEXT_TRANSACTION 401946
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:12:20.4040
MON$PAGES 737952
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-V3.0.3.32757 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32757 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32757 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32757 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 402134
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 401947
Oldest active 401948
Oldest snapshot 401948
Next transaction 401949
Sequence number 0
Next attachment ID 9427
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:12:20
Attributes force write

Variable header data:
Sweep interval: 0
*END*


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

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 311, Index root page: 312
Total formats: 1, used formats: 1
Average record length: 33.58, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.24
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Root page: 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: 44
Average key length: 2.04, compression ratio: 0.54
Average prefix length: 1.04, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
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: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.00, total records: 2003261
Average version length: 47.68, total versions: 2982, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 14, data page slots: 21616
Data pages: 21616, average fill: 73%
Primary pages: 21616, secondary pages: 0, swept pages: 12235
Empty pages: 2, full pages: 19841
Fill distribution:
0 - 19% = 3
20 - 39% = 4
40 - 59% = 49
60 - 79% = 21559
80 - 99% = 1

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 9652, nodes: 2003261
Average node length: 19.26, total dup: 0, max dup: 0
Average key length: 16.31, compression ratio: 1.66
Average prefix length: 13.69, average data length: 13.31
Clustering factor: 469084, ratio: 0.23
Fill distribution:
0 - 19% = 550
20 - 39% = 1961
40 - 59% = 5028
60 - 79% = 832
80 - 99% = 1281

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7203, nodes: 2003261
Average node length: 11.67, total dup: 0, max dup: 0
Average key length: 8.71, compression ratio: 1.03
Average prefix length: 3.28, average data length: 5.72
Clustering factor: 431620, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 3427
40 - 59% = 3744
60 - 79% = 31
80 - 99% = 1

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 174410, depth: 3, leaf buckets: 3544, nodes: 2003261
Average node length: 6.79, total dup: 1468229, max dup: 49
Average key length: 3.84, compression ratio: 2.34
Average prefix length: 7.43, average data length: 1.57
Clustering factor: 433731, ratio: 0.22
Fill distribution:
0 - 19% = 110
20 - 39% = 1256
40 - 59% = 1540
60 - 79% = 141
80 - 99% = 497

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.21, total records: 596167
Average version length: 35.42, total versions: 1348, max versions: 3
Average fragment length: 17.71, total fragments: 7, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7528
Data pages: 7528, average fill: 75%
Primary pages: 7526, secondary pages: 2, swept pages: 6752
Empty pages: 6, full pages: 7202
Fill distribution:
0 - 19% = 12
20 - 39% = 4
40 - 59% = 11
60 - 79% = 7472
80 - 99% = 29

Index DOC_LIST_ID_DESC (1)
Root page: 251259, depth: 3, leaf buckets: 2221, nodes: 596167
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 155349, ratio: 0.26
Fill distribution:
0 - 19% = 0
20 - 39% = 1319
40 - 59% = 879
60 - 79% = 23
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 616, nodes: 596167
Average node length: 4.86, total dup: 596117, max dup: 42603
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 271560, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 498
60 - 79% = 90
80 - 99% = 27

Index PK_DOC_LIST (0)
Root page: 313955, depth: 3, leaf buckets: 1888, nodes: 596167
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.84, compression ratio: 1.02
Average prefix length: 3.16, average data length: 5.84
Clustering factor: 155349, ratio: 0.26
Fill distribution:
0 - 19% = 113
20 - 39% = 784
40 - 59% = 629
60 - 79% = 139
80 - 99% = 223

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: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 65.57, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.50, total fragments: 382, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.59
Pointer pages: 2, data page slots: 1024
Data pages: 36, average fill: 21%
Primary pages: 4, secondary pages: 32, swept pages: 4
Empty pages: 8, full pages: 3
Fill distribution:
0 - 19% = 25
20 - 39% = 7
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

Index PK_INVNT_SALDO (0)
Root page: 282, 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: 292, ratio: 0.73
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: 55.11, total records: 1842
Average version length: 71.20, total versions: 416, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.74
Pointer pages: 2, data page slots: 944
Data pages: 184, average fill: 13%
Primary pages: 183, secondary pages: 1, swept pages: 135
Empty pages: 71, full pages: 5
Fill distribution:
0 - 19% = 148
20 - 39% = 19
40 - 59% = 10
60 - 79% = 3
80 - 99% = 4

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 11, nodes: 1842
Average node length: 17.45, total dup: 0, max dup: 0
Average key length: 15.20, compression ratio: 1.78
Average prefix length: 14.80, average data length: 12.20
Clustering factor: 1659, ratio: 0.90
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 3
60 - 79% = 0
80 - 99% = 1

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

Index PK_MONEY_SALDO (0)
Root page: 273, 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: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 45.86, total records: 21
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.40
Pointer pages: 1, data page slots: 24
Data pages: 24, average fill: 2%
Primary pages: 24, secondary pages: 0, swept pages: 20
Empty pages: 18, full pages: 0
Fill distribution:
0 - 19% = 24
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 259736, depth: 2, leaf buckets: 1, nodes: 21
Average node length: 13.76, total dup: 8, max dup: 4
Average key length: 11.76, compression ratio: 1.62
Average prefix length: 9.81, average data length: 9.19
Clustering factor: 11, ratio: 0.52
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

Index MON_LOG_DTS (4)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
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_ROWSET_DESC (1)
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 MON_LOG_UNIT (3)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
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

MON_LOG_TABLE_STATS (166)
Primary pointer page: 366, Index root page: 367
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: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 371, 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: 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_TN_UNIT (3)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
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

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

Index OPTYPES_MCODE_UNQ (1)
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.26, total records: 233395
Average version length: 28.18, total versions: 1866, max versions: 9
Average fragment length: 33.00, total fragments: 1, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.51
Pointer pages: 2, data page slots: 2640
Data pages: 2640, average fill: 66%
Primary pages: 2633, secondary pages: 7, swept pages: 2334
Empty pages: 6, full pages: 699
Fill distribution:
0 - 19% = 16
20 - 39% = 111
40 - 59% = 275
60 - 79% = 2234
80 - 99% = 4

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 215, nodes: 233395
Average node length: 4.56, total dup: 233346, max dup: 8973
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 40295, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 19
40 - 59% = 80
60 - 79% = 94
80 - 99% = 21

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 257, nodes: 233395
Average node length: 5.50, total dup: 210656, max dup: 57
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 51119, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 25
40 - 59% = 109
60 - 79% = 68
80 - 99% = 55

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 252, nodes: 233395
Average node length: 5.50, total dup: 210656, max dup: 57
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 51176, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 24
40 - 59% = 92
60 - 79% = 90
80 - 99% = 46

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 266, nodes: 233395
Average node length: 5.29, total dup: 210656, max dup: 57
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 51215, ratio: 0.22
Fill distribution:
0 - 19% = 2
20 - 39% = 31
40 - 59% = 121
60 - 79% = 90
80 - 99% = 22

PERF_ESTIMATED (160)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 27.97, total records: 243610
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.14
Pointer pages: 2, data page slots: 2088
Data pages: 2088, average fill: 64%
Primary pages: 2088, secondary pages: 0, swept pages: 0
Empty pages: 6, full pages: 2081
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2081
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 4521, depth: 2, leaf buckets: 188, nodes: 243610
Average node length: 4.47, total dup: 243429, max dup: 2112
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 60984, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 47
60 - 79% = 82
80 - 99% = 59

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 (163)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.55, total records: 10124451
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.19
Pointer pages: 147, data page slots: 239904
Data pages: 239904, average fill: 87%
Primary pages: 239904, secondary pages: 0, swept pages: 3
Empty pages: 1, full pages: 239902
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 239902

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 11089, nodes: 10124451
Average node length: 5.61, total dup: 9262419, max dup: 142
Average key length: 2.20, compression ratio: 3.63
Average prefix length: 7.84, average data length: 0.15
Clustering factor: 4731525, ratio: 0.47
Fill distribution:
0 - 19% = 10
20 - 39% = 0
40 - 59% = 5778
60 - 79% = 3456
80 - 99% = 1845

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 9832, nodes: 10124451
Average node length: 4.48, total dup: 10124447, max dup: 9396350
Average key length: 1.07, compression ratio: 0.34
Average prefix length: 0.36, average data length: 0.00
Clustering factor: 303983, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 9828
60 - 79% = 1
80 - 99% = 2

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 11942, nodes: 10124451
Average node length: 5.66, total dup: 9783921, max dup: 15451
Average key length: 2.25, compression ratio: 4.00
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 956033, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 3
40 - 59% = 8449
60 - 79% = 1820
80 - 99% = 1667

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 12069, nodes: 10124451
Average node length: 5.49, total dup: 10092471, max dup: 1182039
Average key length: 2.08, compression ratio: 18.17
Average prefix length: 37.67, average data length: 0.07
Clustering factor: 6368224, ratio: 0.63
Fill distribution:
0 - 19% = 17
20 - 39% = 1
40 - 59% = 10187
60 - 79% = 620
80 - 99% = 1244

PHRASES (145)
Primary pointer page: 266, Index root page: 267
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: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
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_UNQ (1)
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 PK_PHRASES (0)
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

PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 54.74, total records: 393819
Average version length: 55.43, total versions: 995, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 3, data page slots: 4640
Data pages: 4640, average fill: 75%
Primary pages: 4640, secondary pages: 0, swept pages: 2899
Empty pages: 4, full pages: 4493
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 5
60 - 79% = 4630
80 - 99% = 0

Index PSTORNED_RCV_ID (2)
Root page: 661409, depth: 3, leaf buckets: 548, nodes: 393819
Average node length: 5.99, total dup: 327403, max dup: 885
Average key length: 3.23, compression ratio: 2.79
Average prefix length: 7.94, average data length: 1.06
Clustering factor: 51882, ratio: 0.13
Fill distribution:
0 - 19% = 11
20 - 39% = 32
40 - 59% = 373
60 - 79% = 102
80 - 99% = 30

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 421, nodes: 393819
Average node length: 5.55, total dup: 352324, max dup: 135
Average key length: 2.79, compression ratio: 3.22
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 94941, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 11
40 - 59% = 173
60 - 79% = 159
80 - 99% = 77

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

Index RULES_FOR_PDISTR_UNQ (0)
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 243, Index root page: 244
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 315, Index root page: 316
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_SEMAPHORES (0)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 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 (164)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 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

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 (162)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 1
Average record length: 57.80, total records: 2428
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.51
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 69%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 29
80 - 99% = 0

WARES (144)
Primary pointer page: 264, Index root page: 265
Total formats: 1, used formats: 1
Average record length: 78.23, 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.73
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 78%
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: 377, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 67
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: 274, 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: 335, ratio: 0.84
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

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

Index WARES_NUMB_UNQ (1)
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.86, total dup: 0, max dup: 0
Average key length: 51.84, compression ratio: 1.00
Average prefix length: 2.73, average data length: 48.86
Clustering factor: 334, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

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 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 52.81, total records: 3864
Average version length: 72.14, total versions: 1037, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.58
Pointer pages: 2, data page slots: 760
Data pages: 352, average fill: 13%
Primary pages: 352, secondary pages: 0, swept pages: 282
Empty pages: 195, full pages: 32
Fill distribution:
0 - 19% = 284
20 - 39% = 23
40 - 59% = 8
60 - 79% = 28
80 - 99% = 9

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 10, nodes: 3864
Average node length: 7.39, total dup: 3332, max dup: 14
Average key length: 5.14, compression ratio: 7.19
Average prefix length: 33.99, average data length: 3.01
Clustering factor: 622, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 6
40 - 59% = 3
60 - 79% = 0
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 72.00, total records: 1140108
Average version length: 71.73, total versions: 2895, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 11, data page slots: 17272
Data pages: 17264, average fill: 73%
Primary pages: 17264, secondary pages: 0, swept pages: 12057
Empty pages: 110, full pages: 12917
Fill distribution:
0 - 19% = 196
20 - 39% = 229
40 - 59% = 919
60 - 79% = 15886
80 - 99% = 34

Index XQD_1000_3300_DOC (1)
Root page: 339094, depth: 3, leaf buckets: 1321, nodes: 1140108
Average node length: 5.12, total dup: 1111258, max dup: 123
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 131188, ratio: 0.12
Fill distribution:
0 - 19% = 23
20 - 39% = 99
40 - 59% = 970
60 - 79% = 40
80 - 99% = 189

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 230013, depth: 3, leaf buckets: 1641, nodes: 1140108
Average node length: 6.25, total dup: 996040, max dup: 22
Average key length: 3.31, compression ratio: 11.16
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 221608, ratio: 0.19
Fill distribution:
0 - 19% = 26
20 - 39% = 145
40 - 59% = 1198
60 - 79% = 147
80 - 99% = 125

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 50.76, total records: 18213
Average version length: 72.02, total versions: 5404, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.68
Pointer pages: 3, data page slots: 2960
Data pages: 1581, average fill: 14%
Primary pages: 1579, secondary pages: 2, swept pages: 1358
Empty pages: 770, full pages: 101
Fill distribution:
0 - 19% = 1198
20 - 39% = 200
40 - 59% = 49
60 - 79% = 89
80 - 99% = 45

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 36, nodes: 18213
Average node length: 6.29, total dup: 16222, max dup: 48
Average key length: 3.66, compression ratio: 10.11
Average prefix length: 35.45, average data length: 1.55
Clustering factor: 2373, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 18
40 - 59% = 13
60 - 79% = 4
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 69.88, total records: 1472212
Average version length: 71.77, total versions: 47041, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.95
Pointer pages: 15, data page slots: 23824
Data pages: 23696, average fill: 69%
Primary pages: 23695, secondary pages: 1, swept pages: 14286
Empty pages: 423, full pages: 16172
Fill distribution:
0 - 19% = 888
20 - 39% = 1178
40 - 59% = 2255
60 - 79% = 18489
80 - 99% = 886

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 169115, depth: 3, leaf buckets: 2352, nodes: 1472212
Average node length: 5.61, total dup: 1384688, max dup: 49
Average key length: 2.65, compression ratio: 13.94
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 198406, ratio: 0.13
Fill distribution:
0 - 19% = 11
20 - 39% = 1145
40 - 59% = 867
60 - 79% = 216
80 - 99% = 113

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 23.84, total records: 5754
Average version length: 71.39, total versions: 3782, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 5.71
Pointer pages: 3, data page slots: 2096
Data pages: 584, average fill: 13%
Primary pages: 584, secondary pages: 0, swept pages: 469
Empty pages: 370, full pages: 54
Fill distribution:
0 - 19% = 483
20 - 39% = 30
40 - 59% = 14
60 - 79% = 10
80 - 99% = 47

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 15, nodes: 5754
Average node length: 7.86, total dup: 4627, max dup: 49
Average key length: 5.48, compression ratio: 6.75
Average prefix length: 33.71, average data length: 3.29
Clustering factor: 821, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 8
40 - 59% = 6
60 - 79% = 1
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 70.95, total records: 2533837
Average version length: 71.17, total versions: 18186, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.92
Pointer pages: 23, data page slots: 36152
Data pages: 36152, average fill: 76%
Primary pages: 36152, secondary pages: 0, swept pages: 26008
Empty pages: 13, full pages: 33110
Fill distribution:
0 - 19% = 26
20 - 39% = 66
40 - 59% = 504
60 - 79% = 35110
80 - 99% = 446

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5080, nodes: 2533837
Average node length: 6.87, total dup: 2056707, max dup: 19
Average key length: 3.90, compression ratio: 9.50
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 524794, ratio: 0.21
Fill distribution:
0 - 19% = 8
20 - 39% = 2597
40 - 59% = 2010
60 - 79% = 270
80 - 99% = 195

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.47, total records: 4378400
Average version length: 83.99, total versions: 2048, 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: 42, data page slots: 67160
Data pages: 67160, average fill: 80%
Primary pages: 67160, secondary pages: 0, swept pages: 25278
Empty pages: 1, full pages: 66897
Fill distribution:
0 - 19% = 2
20 - 39% = 6
40 - 59% = 23
60 - 79% = 20049
80 - 99% = 47080

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4482, nodes: 4378400
Average node length: 5.15, total dup: 4278445, max dup: 123
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 702455, ratio: 0.16
Fill distribution:
0 - 19% = 20
20 - 39% = 57
40 - 59% = 2069
60 - 79% = 1799
80 - 99% = 537

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 4993, nodes: 4378400
Average node length: 5.70, total dup: 3918966, max dup: 49
Average key length: 2.72, compression ratio: 3.31
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 243687, ratio: 0.06
Fill distribution:
0 - 19% = 40
20 - 39% = 197
40 - 59% = 3110
60 - 79% = 207
80 - 99% = 1439

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 4996, nodes: 4378400
Average node length: 5.81, total dup: 3830262, max dup: 29
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 756147, ratio: 0.17
Fill distribution:
0 - 19% = 23
20 - 39% = 69
40 - 59% = 2272
60 - 79% = 1877
80 - 99% = 755

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.51, total records: 2166589
Average version length: 83.45, total versions: 10617, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 21, data page slots: 33760
Data pages: 33760, average fill: 79%
Primary pages: 33760, secondary pages: 0, swept pages: 24173
Empty pages: 19, full pages: 32315
Fill distribution:
0 - 19% = 35
20 - 39% = 54
40 - 59% = 311
60 - 79% = 14799
80 - 99% = 18561

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2350, nodes: 2166589
Average node length: 5.15, total dup: 2115805, max dup: 198
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 327075, ratio: 0.15
Fill distribution:
0 - 19% = 4
20 - 39% = 39
40 - 59% = 1458
60 - 79% = 644
80 - 99% = 205

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 3801, nodes: 2166589
Average node length: 6.20, total dup: 1785130, max dup: 14
Average key length: 3.23, compression ratio: 2.78
Average prefix length: 7.94, average data length: 1.06
Clustering factor: 232765, ratio: 0.11
Fill distribution:
0 - 19% = 96
20 - 39% = 1706
40 - 59% = 1450
60 - 79% = 356
80 - 99% = 193

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2671, nodes: 2166589
Average node length: 5.82, total dup: 1895239, max dup: 32
Average key length: 2.85, compression ratio: 3.16
Average prefix length: 8.27, average data length: 0.73
Clustering factor: 394727, ratio: 0.18
Fill distribution:
0 - 19% = 26
20 - 39% = 42
40 - 59% = 1655
60 - 79% = 698
80 - 99% = 250

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.37, total records: 4624936
Average version length: 85.48, total versions: 14758, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 44, data page slots: 71440
Data pages: 71440, average fill: 80%
Primary pages: 71440, secondary pages: 0, swept pages: 20130
Empty pages: 59, full pages: 69519
Fill distribution:
0 - 19% = 104
20 - 39% = 156
40 - 59% = 548
60 - 79% = 16578
80 - 99% = 54054

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 4989, nodes: 4624936
Average node length: 5.04, total dup: 4597831, max dup: 754
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 679152, ratio: 0.15
Fill distribution:
0 - 19% = 6
20 - 39% = 286
40 - 59% = 2947
60 - 79% = 1301
80 - 99% = 449

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 5721, nodes: 4624936
Average node length: 5.55, total dup: 4248811, max dup: 49
Average key length: 2.56, compression ratio: 3.51
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 267957, ratio: 0.06
Fill distribution:
0 - 19% = 62
20 - 39% = 1655
40 - 59% = 2264
60 - 79% = 516
80 - 99% = 1224

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5619, nodes: 4624936
Average node length: 5.69, total dup: 4148003, max dup: 87
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 758496, ratio: 0.16
Fill distribution:
0 - 19% = 4
20 - 39% = 250
40 - 59% = 3363
60 - 79% = 1509
80 - 99% = 493

XQS_2000_3300 (269)
Primary pointer page: 761, Index root page: 762
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: 763, 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: 765, 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: 764, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 83.03, total records: 3196406
Average version length: 83.96, total versions: 13371, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 31, data page slots: 50256
Data pages: 50256, average fill: 78%
Primary pages: 50256, secondary pages: 0, swept pages: 36790
Empty pages: 13, full pages: 46439
Fill distribution:
0 - 19% = 31
20 - 39% = 74
40 - 59% = 568
60 - 79% = 22716
80 - 99% = 26867

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3414, nodes: 3196406
Average node length: 5.03, total dup: 3179896, max dup: 1105
Average key length: 2.05, compression ratio: 4.39
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 719099, ratio: 0.22
Fill distribution:
0 - 19% = 25
20 - 39% = 290
40 - 59% = 1793
60 - 79% = 876
80 - 99% = 430

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5838, nodes: 3196406
Average node length: 6.23, total dup: 2625341, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 395930, ratio: 0.12
Fill distribution:
0 - 19% = 182
20 - 39% = 2875
40 - 59% = 2044
60 - 79% = 482
80 - 99% = 255

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3746, nodes: 3196406
Average node length: 5.62, total dup: 2903963, max dup: 54
Average key length: 2.64, compression ratio: 3.41
Average prefix length: 8.45, average data length: 0.55
Clustering factor: 753177, ratio: 0.24
Fill distribution:
0 - 19% = 7
20 - 39% = 265
40 - 59% = 1903
60 - 79% = 1114
80 - 99% = 457

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.09, total records: 669988
Average version length: 69.34, total versions: 2604, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 9360
Data pages: 9360, average fill: 76%
Primary pages: 9360, secondary pages: 0, swept pages: 7022
Empty pages: 10, full pages: 8553
Fill distribution:
0 - 19% = 21
20 - 39% = 90
40 - 59% = 225
60 - 79% = 8959
80 - 99% = 65

Index XQS_3300_3400_DOC_ID (0)
Root page: 174553, depth: 3, leaf buckets: 823, nodes: 669988
Average node length: 5.28, total dup: 635255, max dup: 123
Average key length: 2.40, compression ratio: 3.75
Average prefix length: 8.65, average data length: 0.35
Clustering factor: 52584, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 193
40 - 59% = 345
60 - 79% = 216
80 - 99% = 66

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 915, nodes: 669988
Average node length: 5.91, total dup: 574627, max dup: 27
Average key length: 3.03, compression ratio: 2.97
Average prefix length: 8.11, average data length: 0.89
Clustering factor: 56388, ratio: 0.08
Fill distribution:
0 - 19% = 2
20 - 39% = 216
40 - 59% = 390
60 - 79% = 220
80 - 99% = 87

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

ZDOC_LIST (229)
Primary pointer page: 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

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

ZPDISTR (234)
Primary pointer page: 652, Index root page: 653
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: 662, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (235)
Primary pointer page: 654, Index root page: 655
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: 663, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (232)
Primary pointer page: 648, Index root page: 649
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: 656, 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: 657, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (233)
Primary pointer page: 650, Index root page: 651
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: 659, 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: 658, 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: 661, 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: 660, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (228)
Primary pointer page: 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

ZTMP_SHOPPING_CART (227)
Primary pointer page: 614, Index root page: 615
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: 268, Index root page: 269
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: 281, 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 65350 ms, from 7:08:02.04 to 7:09:07.39.

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 2003261 2982 0.1488
DOC_LIST 596167 1348 0.2261
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 1842 416 22.5841
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 21 0 0.0000
OPTYPES 9 0 0.0000
PDISTR 233395 1866 0.7995
PERF_ESTIMATED 243610 0 0.0000
PERF_LOG 10124451 0 0.0000
PSTORNED 393819 995 0.2526
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 0 0.0000
SETTINGS 114 0 0.0000
TRACE_STAT 2428 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 3864 1037 26.8374
XQD_1000_3300 1140108 2895 0.2539
XQD_1200_2000 18213 5404 29.6711
XQD_2000_3300 1472212 47041 3.1952
XQD_2100_3300 5754 3782 65.7281
XQD_3300_3400 2533837 18186 0.7177
XQS_1000_1200 4378400 2048 0.0467
XQS_1000_3300 2166589 10617 0.4900
XQS_1200_2000 4624936 14758 0.3190
XQS_2100_3300 3196406 13371 0.4183
XQS_3300_3400 669988 2604 0.3886
Z_USED_VIEWS 29 0 0.0000
Done for 1920 ms, from 7:09:20.13 to 7:09:22.05.

Database validation

07:09:22.14 Validation started

07:09:22.16 Relation 140 (DOC_LIST)
07:09:22.16 process pointer page 0 of 5
07:09:22.22 process pointer page 1 of 5
07:09:22.33 process pointer page 2 of 5
07:09:22.43 process pointer page 3 of 5
07:09:22.53 process pointer page 4 of 5
07:09:22.57 Index 1 (PK_DOC_LIST)
07:09:22.71 Index 2 (DOC_LIST_ID_DESC)
07:09:22.92 Index 3 (FK_DOC_LIST_AGENTS)
07:09:23.08 Relation 140 (DOC_LIST) is ok

07:09:23.08 Relation 141 (DOC_DATA)
07:09:23.08 process pointer page 0 of 14
07:09:23.13 process pointer page 1 of 14
07:09:23.16 process pointer page 2 of 14
07:09:23.19 process pointer page 3 of 14
07:09:23.28 process pointer page 4 of 14
07:09:23.38 process pointer page 5 of 14
07:09:23.47 process pointer page 6 of 14
07:09:23.56 process pointer page 7 of 14
07:09:23.66 process pointer page 8 of 14
07:09:23.69 process pointer page 9 of 14
07:09:23.77 process pointer page 10 of 14
07:09:23.86 process pointer page 11 of 14
07:09:23.95 process pointer page 12 of 14
07:09:24.05 process pointer page 13 of 14
07:09:24.06 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:09:24.81 Index 3 (DOC_DATA_ID_DESC)
07:09:25.48 Index 4 (FK_DOC_DATA_DOC_LIST)
07:09:26.00 Relation 141 (DOC_DATA) is ok

07:09:26.00 Relation 147 (INVNT_SALDO)
07:09:26.00 process pointer page 0 of 2
07:09:26.00 process pointer page 1 of 2
07:09:26.00 Index 1 (PK_INVNT_SALDO)
07:09:26.00 Relation 147 (INVNT_SALDO) is ok

07:09:26.00 Relation 150 (PDISTR)
07:09:26.00 process pointer page 0 of 2
07:09:26.04 process pointer page 1 of 2
07:09:26.06 Index 2 (PDISTR_SND_ID)
07:09:26.09 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:09:26.12 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:09:26.15 Index 5 (PDISTR_AGENT_ID)
07:09:26.17 Relation 150 (PDISTR) is ok

07:09:26.17 Relation 151 (PSTORNED)
07:09:26.17 process pointer page 0 of 3
07:09:26.20 process pointer page 1 of 3
07:09:26.23 process pointer page 2 of 3
07:09:26.26 Index 2 (PSTORNED_SND_ID)
07:09:26.31 Index 3 (PSTORNED_RCV_ID)
07:09:26.34 Relation 151 (PSTORNED) is ok

07:09:26.34 Relation 156 (SEMAPHORES)
07:09:26.34 process pointer page 0 of 1
07:09:26.34 Index 1 (PK_SEMAPHORES)
07:09:26.34 Index 2 (SEMAPHORES_TASK_UNQ)
07:09:26.34 Relation 156 (SEMAPHORES) is ok

07:09:26.34 Relation 157 (INVNT_TURNOVER_LOG)
07:09:26.34 process pointer page 0 of 2
07:09:26.34 process pointer page 1 of 2
07:09:26.34 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:09:26.34 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:09:26.34 Relation 160 (PERF_ESTIMATED)
07:09:26.34 process pointer page 0 of 2
07:09:26.37 process pointer page 1 of 2
07:09:26.37 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:09:26.39 Relation 160 (PERF_ESTIMATED) is ok

07:09:26.39 Relation 161 (PERF_ISQL_STAT)
07:09:26.39 process pointer page 0 of 1
07:09:26.39 Index 1 (PERF_ISQL_STAT_TRN)
07:09:26.39 Relation 161 (PERF_ISQL_STAT) is ok

07:09:26.39 Relation 162 (TRACE_STAT)
07:09:26.39 process pointer page 0 of 1
07:09:26.39 Relation 162 (TRACE_STAT) is ok

07:09:26.39 Relation 163 (PERF_LOG)
07:09:26.39 process pointer page 0 of 147
07:09:26.42 process pointer page 1 of 147
07:09:26.45 process pointer page 2 of 147
07:09:26.47 process pointer page 3 of 147
07:09:26.50 process pointer page 4 of 147
07:09:26.53 process pointer page 5 of 147
07:09:26.54 process pointer page 6 of 147
07:09:26.58 process pointer page 7 of 147
07:09:26.59 process pointer page 8 of 147
07:09:26.62 process pointer page 9 of 147
07:09:26.65 process pointer page 10 of 147
07:09:26.67 process pointer page 11 of 147
07:09:26.70 process pointer page 12 of 147
07:09:26.73 process pointer page 13 of 147
07:09:26.76 process pointer page 14 of 147
07:09:26.79 process pointer page 15 of 147
07:09:26.81 process pointer page 16 of 147
07:09:26.84 process pointer page 17 of 147
07:09:26.86 process pointer page 18 of 147
07:09:26.89 process pointer page 19 of 147
07:09:26.92 process pointer page 20 of 147
07:09:26.97 process pointer page 21 of 147
07:09:27.06 process pointer page 22 of 147
07:09:27.14 process pointer page 23 of 147
07:09:27.17 process pointer page 24 of 147
07:09:27.20 process pointer page 25 of 147
07:09:27.23 process pointer page 26 of 147
07:09:27.32 process pointer page 27 of 147
07:09:27.40 process pointer page 28 of 147
07:09:27.45 process pointer page 29 of 147
07:09:27.50 process pointer page 30 of 147
07:09:27.53 process pointer page 31 of 147
07:09:27.56 process pointer page 32 of 147
07:09:27.59 process pointer page 33 of 147
07:09:27.65 process pointer page 34 of 147
07:09:27.71 process pointer page 35 of 147
07:09:27.75 process pointer page 36 of 147
07:09:27.78 process pointer page 37 of 147
07:09:27.81 process pointer page 38 of 147
07:09:27.90 process pointer page 39 of 147
07:09:27.98 process pointer page 40 of 147
07:09:28.06 process pointer page 41 of 147
07:09:28.14 process pointer page 42 of 147
07:09:28.18 process pointer page 43 of 147
07:09:28.23 process pointer page 44 of 147
07:09:28.32 process pointer page 45 of 147
07:09:28.40 process pointer page 46 of 147
07:09:28.48 process pointer page 47 of 147
07:09:28.56 process pointer page 48 of 147
07:09:28.63 process pointer page 49 of 147
07:09:28.73 process pointer page 50 of 147
07:09:28.81 process pointer page 51 of 147
07:09:28.88 process pointer page 52 of 147
07:09:28.93 process pointer page 53 of 147
07:09:28.96 process pointer page 54 of 147
07:09:28.99 process pointer page 55 of 147
07:09:29.02 process pointer page 56 of 147
07:09:29.06 process pointer page 57 of 147
07:09:29.09 process pointer page 58 of 147
07:09:29.12 process pointer page 59 of 147
07:09:29.15 process pointer page 60 of 147
07:09:29.23 process pointer page 61 of 147
07:09:29.27 process pointer page 62 of 147
07:09:29.31 process pointer page 63 of 147
07:09:29.38 process pointer page 64 of 147
07:09:29.48 process pointer page 65 of 147
07:09:29.55 process pointer page 66 of 147
07:09:29.59 process pointer page 67 of 147
07:09:29.65 process pointer page 68 of 147
07:09:29.73 process pointer page 69 of 147
07:09:29.80 process pointer page 70 of 147
07:09:29.88 process pointer page 71 of 147
07:09:29.93 process pointer page 72 of 147
07:09:29.96 process pointer page 73 of 147
07:09:29.99 process pointer page 74 of 147
07:09:30.05 process pointer page 75 of 147
07:09:30.13 process pointer page 76 of 147
07:09:30.19 process pointer page 77 of 147
07:09:30.23 process pointer page 78 of 147
07:09:30.26 process pointer page 79 of 147
07:09:30.30 process pointer page 80 of 147
07:09:30.38 process pointer page 81 of 147
07:09:30.41 process pointer page 82 of 147
07:09:30.48 process pointer page 83 of 147
07:09:30.55 process pointer page 84 of 147
07:09:30.65 process pointer page 85 of 147
07:09:30.72 process pointer page 86 of 147
07:09:30.77 process pointer page 87 of 147
07:09:30.80 process pointer page 88 of 147
07:09:30.83 process pointer page 89 of 147
07:09:30.91 process pointer page 90 of 147
07:09:30.99 process pointer page 91 of 147
07:09:31.07 process pointer page 92 of 147
07:09:31.15 process pointer page 93 of 147
07:09:31.21 process pointer page 94 of 147
07:09:31.24 process pointer page 95 of 147
07:09:31.27 process pointer page 96 of 147
07:09:31.30 process pointer page 97 of 147
07:09:31.40 process pointer page 98 of 147
07:09:31.46 process pointer page 99 of 147
07:09:31.49 process pointer page 100 of 147
07:09:31.55 process pointer page 101 of 147
07:09:31.58 process pointer page 102 of 147
07:09:31.61 process pointer page 103 of 147
07:09:31.65 process pointer page 104 of 147
07:09:31.69 process pointer page 105 of 147
07:09:31.71 process pointer page 106 of 147
07:09:31.74 process pointer page 107 of 147
07:09:31.77 process pointer page 108 of 147
07:09:31.82 process pointer page 109 of 147
07:09:31.89 process pointer page 110 of 147
07:09:31.97 process pointer page 111 of 147
07:09:32.05 process pointer page 112 of 147
07:09:32.08 process pointer page 113 of 147
07:09:32.11 process pointer page 114 of 147
07:09:32.14 process pointer page 115 of 147
07:09:32.18 process pointer page 116 of 147
07:09:32.21 process pointer page 117 of 147
07:09:32.24 process pointer page 118 of 147
07:09:32.27 process pointer page 119 of 147
07:09:32.30 process pointer page 120 of 147
07:09:32.33 process pointer page 121 of 147
07:09:32.39 process pointer page 122 of 147
07:09:32.46 process pointer page 123 of 147
07:09:32.49 process pointer page 124 of 147
07:09:32.52 process pointer page 125 of 147
07:09:32.55 process pointer page 126 of 147
07:09:32.60 process pointer page 127 of 147
07:09:32.67 process pointer page 128 of 147
07:09:32.72 process pointer page 129 of 147
07:09:32.75 process pointer page 130 of 147
07:09:32.78 process pointer page 131 of 147
07:09:32.86 process pointer page 132 of 147
07:09:32.94 process pointer page 133 of 147
07:09:33.03 process pointer page 134 of 147
07:09:33.06 process pointer page 135 of 147
07:09:33.10 process pointer page 136 of 147
07:09:33.13 process pointer page 137 of 147
07:09:33.17 process pointer page 138 of 147
07:09:33.21 process pointer page 139 of 147
07:09:33.22 process pointer page 140 of 147
07:09:33.25 process pointer page 141 of 147
07:09:33.28 process pointer page 142 of 147
07:09:33.35 process pointer page 143 of 147
07:09:33.42 process pointer page 144 of 147
07:09:33.52 process pointer page 145 of 147
07:09:33.60 process pointer page 146 of 147
07:09:33.67 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:09:36.50 Index 2 (PERF_LOG_UNIT)
07:09:39.96 Index 3 (PERF_LOG_TRN_DESC)
07:09:41.41 Index 4 (PERF_LOG_GDSCODE)
07:09:42.66 Relation 163 (PERF_LOG) is ok

07:09:42.66 Relation 167 (V_STOPTEST)
07:09:42.66 Relation 167 (V_STOPTEST) is ok

07:09:42.66 Relation 184 (V_QDISTR_SOURCE)
07:09:42.66 Relation 184 (V_QDISTR_SOURCE) is ok

07:09:42.66 Relation 185 (V_QSTORNED_SOURCE)
07:09:42.66 Relation 185 (V_QSTORNED_SOURCE) is ok

07:09:42.66 Relation 260 (XQD_1000_1200)
07:09:42.66 process pointer page 0 of 2
07:09:42.66 process pointer page 1 of 2
07:09:42.66 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:09:42.67 Relation 260 (XQD_1000_1200) is ok

07:09:42.67 Relation 261 (XQD_1200_2000)
07:09:42.67 process pointer page 0 of 3
07:09:42.67 process pointer page 1 of 3
07:09:42.69 process pointer page 2 of 3
07:09:42.69 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:09:42.69 Relation 261 (XQD_1200_2000) is ok

07:09:42.69 Relation 262 (XQD_1000_3300)
07:09:42.69 process pointer page 0 of 11
07:09:42.72 process pointer page 1 of 11
07:09:42.75 process pointer page 2 of 11
07:09:42.77 process pointer page 3 of 11
07:09:42.80 process pointer page 4 of 11
07:09:42.83 process pointer page 5 of 11
07:09:42.92 process pointer page 6 of 11
07:09:43.00 process pointer page 7 of 11
07:09:43.10 process pointer page 8 of 11
07:09:43.17 process pointer page 9 of 11
07:09:43.25 process pointer page 10 of 11
07:09:43.30 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:09:43.61 Index 2 (XQD_1000_3300_DOC)
07:09:43.74 Relation 262 (XQD_1000_3300) is ok

07:09:43.74 Relation 263 (XQD_2000_3300)
07:09:43.74 process pointer page 0 of 15
07:09:43.77 process pointer page 1 of 15
07:09:43.80 process pointer page 2 of 15
07:09:43.83 process pointer page 3 of 15
07:09:43.86 process pointer page 4 of 15
07:09:43.89 process pointer page 5 of 15
07:09:43.92 process pointer page 6 of 15
07:09:43.95 process pointer page 7 of 15
07:09:43.97 process pointer page 8 of 15
07:09:44.00 process pointer page 9 of 15
07:09:44.03 process pointer page 10 of 15
07:09:44.08 process pointer page 11 of 15
07:09:44.14 process pointer page 12 of 15
07:09:44.17 process pointer page 13 of 15
07:09:44.20 process pointer page 14 of 15
07:09:44.23 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:09:44.66 Relation 263 (XQD_2000_3300) is ok

07:09:44.66 Relation 264 (XQD_2100_3300)
07:09:44.66 process pointer page 0 of 3
07:09:44.69 process pointer page 1 of 3
07:09:44.69 process pointer page 2 of 3
07:09:44.69 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:09:44.69 Relation 264 (XQD_2100_3300) is ok

07:09:44.69 Relation 265 (XQD_3300_3400)
07:09:44.69 process pointer page 0 of 23
07:09:44.78 process pointer page 1 of 23
07:09:44.87 process pointer page 2 of 23
07:09:44.92 process pointer page 3 of 23
07:09:44.97 process pointer page 4 of 23
07:09:45.00 process pointer page 5 of 23
07:09:45.09 process pointer page 6 of 23
07:09:45.14 process pointer page 7 of 23
07:09:45.20 process pointer page 8 of 23
07:09:45.23 process pointer page 9 of 23
07:09:45.33 process pointer page 10 of 23
07:09:45.42 process pointer page 11 of 23
07:09:45.51 process pointer page 12 of 23
07:09:45.59 process pointer page 13 of 23
07:09:45.69 process pointer page 14 of 23
07:09:45.73 process pointer page 15 of 23
07:09:45.76 process pointer page 16 of 23
07:09:45.83 process pointer page 17 of 23
07:09:45.90 process pointer page 18 of 23
07:09:46.00 process pointer page 19 of 23
07:09:46.09 process pointer page 20 of 23
07:09:46.18 process pointer page 21 of 23
07:09:46.26 process pointer page 22 of 23
07:09:46.28 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:09:47.23 Relation 265 (XQD_3300_3400) is ok

07:09:47.23 Relation 266 (XQS_1000_1200)
07:09:47.23 process pointer page 0 of 42
07:09:47.26 process pointer page 1 of 42
07:09:47.29 process pointer page 2 of 42
07:09:47.39 process pointer page 3 of 42
07:09:47.46 process pointer page 4 of 42
07:09:47.56 process pointer page 5 of 42
07:09:47.59 process pointer page 6 of 42
07:09:47.62 process pointer page 7 of 42
07:09:47.65 process pointer page 8 of 42
07:09:47.70 process pointer page 9 of 42
07:09:47.73 process pointer page 10 of 42
07:09:47.76 process pointer page 11 of 42
07:09:47.79 process pointer page 12 of 42
07:09:47.85 process pointer page 13 of 42
07:09:47.93 process pointer page 14 of 42
07:09:47.98 process pointer page 15 of 42
07:09:48.01 process pointer page 16 of 42
07:09:48.04 process pointer page 17 of 42
07:09:48.12 process pointer page 18 of 42
07:09:48.21 process pointer page 19 of 42
07:09:48.26 process pointer page 20 of 42
07:09:48.31 process pointer page 21 of 42
07:09:48.34 process pointer page 22 of 42
07:09:48.37 process pointer page 23 of 42
07:09:48.43 process pointer page 24 of 42
07:09:48.49 process pointer page 25 of 42
07:09:48.52 process pointer page 26 of 42
07:09:48.57 process pointer page 27 of 42
07:09:48.60 process pointer page 28 of 42
07:09:48.63 process pointer page 29 of 42
07:09:48.66 process pointer page 30 of 42
07:09:48.70 process pointer page 31 of 42
07:09:48.73 process pointer page 32 of 42
07:09:48.77 process pointer page 33 of 42
07:09:48.81 process pointer page 34 of 42
07:09:48.84 process pointer page 35 of 42
07:09:48.87 process pointer page 36 of 42
07:09:48.90 process pointer page 37 of 42
07:09:48.93 process pointer page 38 of 42
07:09:48.96 process pointer page 39 of 42
07:09:48.98 process pointer page 40 of 42
07:09:49.01 process pointer page 41 of 42
07:09:49.01 Index 1 (XQS_1000_1200_DOC_ID)
07:09:49.62 Index 2 (XQS_1000_1200_SND_ID)
07:09:50.29 Index 3 (XQS_1000_1200_RCV_ID)
07:09:50.80 Relation 266 (XQS_1000_1200) is ok

07:09:50.80 Relation 267 (XQS_1200_2000)
07:09:50.80 process pointer page 0 of 44
07:09:50.83 process pointer page 1 of 44
07:09:50.90 process pointer page 2 of 44
07:09:50.93 process pointer page 3 of 44
07:09:50.96 process pointer page 4 of 44
07:09:50.99 process pointer page 5 of 44
07:09:51.08 process pointer page 6 of 44
07:09:51.15 process pointer page 7 of 44
07:09:51.19 process pointer page 8 of 44
07:09:51.22 process pointer page 9 of 44
07:09:51.25 process pointer page 10 of 44
07:09:51.30 process pointer page 11 of 44
07:09:51.39 process pointer page 12 of 44
07:09:51.43 process pointer page 13 of 44
07:09:51.47 process pointer page 14 of 44
07:09:51.52 process pointer page 15 of 44
07:09:51.58 process pointer page 16 of 44
07:09:51.68 process pointer page 17 of 44
07:09:51.77 process pointer page 18 of 44
07:09:51.86 process pointer page 19 of 44
07:09:51.96 process pointer page 20 of 44
07:09:52.02 process pointer page 21 of 44
07:09:52.05 process pointer page 22 of 44
07:09:52.08 process pointer page 23 of 44
07:09:52.13 process pointer page 24 of 44
07:09:52.16 process pointer page 25 of 44
07:09:52.21 process pointer page 26 of 44
07:09:52.24 process pointer page 27 of 44
07:09:52.35 process pointer page 28 of 44
07:09:52.38 process pointer page 29 of 44
07:09:52.42 process pointer page 30 of 44
07:09:52.46 process pointer page 31 of 44
07:09:52.52 process pointer page 32 of 44
07:09:52.61 process pointer page 33 of 44
07:09:52.72 process pointer page 34 of 44
07:09:52.78 process pointer page 35 of 44
07:09:52.81 process pointer page 36 of 44
07:09:52.89 process pointer page 37 of 44
07:09:53.00 process pointer page 38 of 44
07:09:53.06 process pointer page 39 of 44
07:09:53.11 process pointer page 40 of 44
07:09:53.14 process pointer page 41 of 44
07:09:53.19 process pointer page 42 of 44
07:09:53.22 process pointer page 43 of 44
07:09:53.25 Index 1 (XQS_1200_2000_DOC_ID)
07:09:54.12 Index 2 (XQS_1200_2000_SND_ID)
07:09:55.14 Index 3 (XQS_1200_2000_RCV_ID)
07:09:55.64 Relation 267 (XQS_1200_2000) is ok

07:09:55.64 Relation 268 (XQS_1000_3300)
07:09:55.64 process pointer page 0 of 21
07:09:55.73 process pointer page 1 of 21
07:09:55.78 process pointer page 2 of 21
07:09:55.87 process pointer page 3 of 21
07:09:55.98 process pointer page 4 of 21
07:09:56.09 process pointer page 5 of 21
07:09:56.57 process pointer page 6 of 21
07:09:57.06 process pointer page 7 of 21
07:09:57.42 process pointer page 8 of 21
07:09:57.73 process pointer page 9 of 21
07:09:58.06 process pointer page 10 of 21
07:09:58.34 process pointer page 11 of 21
07:09:58.60 process pointer page 12 of 21
07:09:58.90 process pointer page 13 of 21
07:09:59.21 process pointer page 14 of 21
07:09:59.49 process pointer page 15 of 21
07:09:59.77 process pointer page 16 of 21
07:10:00.01 process pointer page 17 of 21
07:10:00.30 process pointer page 18 of 21
07:10:00.65 process pointer page 19 of 21
07:10:01.02 process pointer page 20 of 21
07:10:01.29 Index 1 (XQS_1000_3300_DOC_ID)
07:10:02.44 Index 2 (XQS_1000_3300_SND_ID)
07:10:03.70 Index 3 (XQS_1000_3300_RCV_ID)
07:10:05.03 Relation 268 (XQS_1000_3300) is ok

07:10:05.03 Relation 269 (XQS_2000_3300)
07:10:05.03 process pointer page 0 of 1
07:10:05.03 Index 1 (XQS_2000_3300_DOC_ID)
07:10:05.03 Index 2 (XQS_2000_3300_SND_ID)
07:10:05.03 Index 3 (XQS_2000_3300_RCV_ID)
07:10:05.03 Relation 269 (XQS_2000_3300) is ok

07:10:05.03 Relation 270 (XQS_2100_3300)
07:10:05.03 process pointer page 0 of 31
07:10:05.50 process pointer page 1 of 31
07:10:05.95 process pointer page 2 of 31
07:10:06.43 process pointer page 3 of 31
07:10:06.93 process pointer page 4 of 31
07:10:07.42 process pointer page 5 of 31
07:10:07.90 process pointer page 6 of 31
07:10:08.40 process pointer page 7 of 31
07:10:08.88 process pointer page 8 of 31
07:10:09.35 process pointer page 9 of 31
07:10:09.82 process pointer page 10 of 31
07:10:10.27 process pointer page 11 of 31
07:10:10.68 process pointer page 12 of 31
07:10:11.08 process pointer page 13 of 31
07:10:11.44 process pointer page 14 of 31
07:10:11.89 process pointer page 15 of 31
07:10:12.36 process pointer page 16 of 31
07:10:12.88 process pointer page 17 of 31
07:10:13.34 process pointer page 18 of 31
07:10:13.81 process pointer page 19 of 31
07:10:14.28 process pointer page 20 of 31
07:10:14.73 process pointer page 21 of 31
07:10:15.18 process pointer page 22 of 31
07:10:15.65 process pointer page 23 of 31
07:10:16.11 process pointer page 24 of 31
07:10:16.56 process pointer page 25 of 31
07:10:17.03 process pointer page 26 of 31
07:10:17.46 process pointer page 27 of 31
07:10:17.93 process pointer page 28 of 31
07:10:18.38 process pointer page 29 of 31
07:10:18.84 process pointer page 30 of 31
07:10:19.16 Index 1 (XQS_2100_3300_DOC_ID)
07:10:20.69 Index 2 (XQS_2100_3300_SND_ID)
07:10:22.38 Index 3 (XQS_2100_3300_RCV_ID)
07:10:24.67 Relation 270 (XQS_2100_3300) is ok

07:10:24.67 Relation 271 (XQS_3300_3400)
07:10:24.67 process pointer page 0 of 6
07:10:25.18 process pointer page 1 of 6
07:10:25.68 process pointer page 2 of 6
07:10:26.17 process pointer page 3 of 6
07:10:26.64 process pointer page 4 of 6
07:10:27.10 process pointer page 5 of 6
07:10:27.45 Index 1 (XQS_3300_3400_DOC_ID)
07:10:27.85 Index 2 (XQS_3300_3400_SND_ID)
07:10:28.27 Relation 271 (XQS_3300_3400) is ok

07:10:28.32 Validation finished
Done for 66320 ms, from 7:09:22.08 to 7:10:28.40.

Differences between old and current firebird.log

7:10:29.96. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-07-22 07:10 471 oltp30_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Sat Jul 22 07:09:22 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sat Jul 22 07:10:28 2017
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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


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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2017-07-22 7:10:36.49 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html