Tests

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

Server and database settings

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

Test configuration settings

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

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2017-06-13 11:18:27.9320 -1 <null> ::1/64029 416276 9128 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: 5509.28 3732 991671 2017-06-13 08:18 2017-06-13 11:18
customer order: creation 432.54 570 77857 2017-06-13 08:18 2017-06-13 11:18
customer order: refuse 35.43 291 6377 2017-06-13 08:18 2017-06-13 11:18
order to supplier: creation 109.84 2545 19771 2017-06-13 08:18 2017-06-13 11:18
order to supplier: removal 2.70 23134 484 2017-06-13 08:18 2017-06-13 11:18
invoice (draft): creation 109.99 3548 19798 2017-06-13 08:18 2017-06-13 11:18
invoice (draft): removal 37.39 521 6731 2017-06-13 08:18 2017-06-13 11:18
invoice accept: apply 60.17 13322 10831 2017-06-13 08:18 2017-06-13 11:18
invoice accept: cancel 17.92 3229 3226 2017-06-13 08:18 2017-06-13 11:18
customer reserve: creation 3113.76 213 560476 2017-06-13 08:18 2017-06-13 11:18
customer reserve: removal 991.58 79 178484 2017-06-13 08:18 2017-06-13 11:18
realization accept: apply 201.43 601 36258 2017-06-13 08:18 2017-06-13 11:18
realization accept: cancel 85.45 171 15381 2017-06-13 08:18 2017-06-13 11:18
payment from customer: creation 143.34 961 25802 2017-06-13 08:18 2017-06-13 11:18
payment from customer: removal 14.01 157 2521 2017-06-13 08:18 2017-06-13 11:18
payment to supplier: creation 119.82 483 21568 2017-06-13 08:18 2017-06-13 11:18
payment to supplier: removal 8.49 161 1529 2017-06-13 08:18 2017-06-13 11:18
service: total inventory turnovers 8.67 3184 1561 2017-06-13 08:18 2017-06-13 11:18
service: total monetary turnovers 16.68 75 3003 2017-06-13 08:18 2017-06-13 11:18
service: refresh index statistics 0.07 17658 13 2017-06-13 08:18 2017-06-13 11:18
Done for 117770 ms, from 11:23:52.56 to 11:25:50.33.

Performance in DYNAMIC:

ACTION ITRV_NO CNT_OK_PER_MINUTE CNT_ALL CNT_OK CNT_ERR ERR_PRC ITRV_BEG ITRV_END
interval # 1, overall 1 4795 100666 86318 14348 14.25 08:18:28 08:36:28
interval # 2, overall 2 5670 117455 102056 15399 13.11 08:36:29 08:54:29
interval # 3, overall 3 5696 113624 102529 11095 9.76 08:54:30 09:12:30
interval # 4, overall 4 5803 119573 104452 15121 12.65 09:12:31 09:30:31
interval # 5, overall 5 5243 105473 94376 11097 10.52 09:30:32 09:48:32
interval # 6, overall 6 5502 110589 99043 11546 10.44 09:48:33 10:06:33
interval # 7, overall 7 5314 105822 95644 10178 9.62 10:06:34 10:24:34
interval # 8, overall 8 5695 113573 102512 11061 9.74 10:24:35 10:42:35
interval # 9, overall 9 6143 126582 110578 16004 12.64 10:42:36 11:00:36
interval # 10, overall 10 5231 103462 94163 9299 8.99 11:00:37 11:18:37
Done for 211320 ms, from 11:29:18.31 to 11:32:49.63.

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 3416.63 0.4085 1.6094 1856 37
TEST_TIME 2 3250.59 0.8458 1.1899 1060 100
TEST_TIME 3 3094.99 0.8339 1.1927 1599 100
TEST_TIME 4 3324.86 0.8382 1.1518 1737 100
TEST_TIME 5 3434.66 0.8920 1.0992 1173 100
TEST_TIME 6 3477.69 0.9047 1.0919 1566 100
TEST_TIME 7 3571.75 0.9113 1.1027 1637 100
TEST_TIME 8 3742.56 0.9208 1.0725 1472 100
TEST_TIME 9 3813.29 0.9357 1.0707 1490 100
TEST_TIME 10 3958.57 0.9296 1.0711 1720 100
TEST_TIME 11 4067.47 0.9477 1.0506 1367 100
TEST_TIME 12 4146.64 0.9446 1.0478 1689 100
TEST_TIME 13 4227.71 0.9487 1.0408 1467 100
TEST_TIME 14 4283.39 0.9576 1.0416 1452 100
TEST_TIME 15 4422.44 0.9417 1.0468 2043 100
TEST_TIME 16 4550.41 0.9552 1.0485 1698 100
TEST_TIME 17 4666.21 0.9623 1.0401 1714 100
TEST_TIME 18 4729.51 0.9691 1.0373 1597 100
TEST_TIME 19 4779.67 0.9726 1.0186 1770 100
TEST_TIME 20 4748.07 0.9741 1.0208 1522 100
TEST_TIME 21 4727.92 0.9764 1.0150 1161 98
TEST_TIME 22 4630.41 0.9893 1.0257 1083 99
TEST_TIME 23 4654.93 0.9759 1.0225 1593 100
TEST_TIME 24 4670.16 0.9767 1.0264 1389 100
TEST_TIME 25 4719.91 0.9754 1.0282 1557 100
TEST_TIME 26 4788.34 0.9746 1.0237 1702 100
TEST_TIME 27 4826.69 0.9779 1.0193 1570 100
TEST_TIME 28 4847.31 0.9788 1.0185 1399 100
TEST_TIME 29 4844.71 0.9839 1.0176 1328 100
TEST_TIME 30 4882.51 0.9761 1.0269 2091 100
TEST_TIME 31 4965.21 0.9773 1.0228 2077 100
TEST_TIME 32 5023.00 0.9794 1.0245 1625 100
TEST_TIME 33 5106.68 0.9772 1.0232 1897 100
TEST_TIME 34 5152.22 0.9843 1.0140 1450 100
TEST_TIME 35 5186.55 0.9785 1.0143 1793 100
TEST_TIME 36 5219.11 0.9815 1.0138 1499 100
TEST_TIME 37 5212.90 0.9876 1.0124 1656 100
TEST_TIME 38 5200.47 0.9883 1.0204 1309 100
TEST_TIME 39 5262.67 0.9825 1.0101 1395 100
TEST_TIME 40 5249.10 0.9874 1.0069 1300 99
TEST_TIME 41 5201.70 0.9913 1.0074 1050 98
TEST_TIME 42 5158.49 0.9916 1.0149 1298 99
TEST_TIME 43 5191.73 0.9854 1.0164 1128 99
TEST_TIME 44 5192.31 0.9932 1.0100 1166 100
TEST_TIME 45 5219.71 0.9823 1.0098 2164 100
TEST_TIME 46 5229.26 0.9860 1.0264 1911 98
TEST_TIME 47 5318.76 0.9876 1.0142 1443 100
TEST_TIME 48 5323.78 0.9922 1.0095 1661 98
TEST_TIME 49 5362.70 0.9846 1.0146 1752 100
TEST_TIME 50 5366.19 0.9936 1.0081 2000 98
TEST_TIME 51 5364.59 0.9886 1.0099 1710 98
TEST_TIME 52 5366.30 0.9901 1.0105 1622 100
TEST_TIME 53 5373.46 0.9902 1.0091 1174 100
TEST_TIME 54 5381.48 0.9890 1.0106 1462 100
TEST_TIME 55 5398.20 0.9897 1.0099 1319 100
TEST_TIME 56 5396.55 0.9921 1.0077 1531 100
TEST_TIME 57 5390.61 0.9911 1.0093 1400 100
TEST_TIME 58 5404.24 0.9894 1.0116 1192 100
TEST_TIME 59 5402.01 0.9949 1.0115 1241 100
TEST_TIME 60 5424.15 0.9906 1.0112 1657 100
TEST_TIME 61 5430.70 0.9934 1.0090 2225 99
TEST_TIME 62 5464.42 0.9866 1.0082 1639 100
TEST_TIME 63 5495.53 0.9866 1.0070 1602 99
TEST_TIME 64 5470.07 0.9959 1.0115 1291 91
TEST_TIME 65 5485.27 0.9932 1.0051 1668 99
TEST_TIME 66 5464.11 0.9937 1.0068 1757 93
TEST_TIME 67 5480.60 0.9887 1.0054 1573 99
TEST_TIME 68 5460.03 0.9943 1.0099 1459 96
TEST_TIME 69 5461.07 0.9951 1.0069 1433 100
TEST_TIME 70 5480.95 0.9889 1.0115 1297 100
TEST_TIME 71 5497.27 0.9943 1.0058 1093 100
TEST_TIME 72 5486.36 0.9939 1.0069 1450 100
TEST_TIME 73 5497.52 0.9911 1.0100 1208 100
TEST_TIME 74 5502.15 0.9955 1.0064 1271 100
TEST_TIME 75 5510.45 0.9916 1.0101 1899 100
TEST_TIME 76 5534.04 0.9929 1.0068 1918 100
TEST_TIME 77 5541.98 0.9923 1.0084 1764 94
TEST_TIME 78 5550.87 0.9939 1.0032 1810 100
TEST_TIME 79 5525.02 0.9951 1.0091 1195 97
TEST_TIME 80 5521.73 0.9970 1.0046 1607 99
TEST_TIME 81 5519.65 0.9926 1.0055 1432 100
TEST_TIME 82 5500.90 0.9967 1.0039 1575 92
TEST_TIME 83 5481.58 0.9953 1.0081 1327 94
TEST_TIME 84 5494.97 0.9937 1.0042 1121 100
TEST_TIME 85 5480.63 0.9953 1.0051 1528 99
TEST_TIME 86 5477.42 0.9940 1.0053 1454 100
TEST_TIME 87 5456.05 0.9977 1.0035 1331 89
TEST_TIME 88 5453.61 0.9925 1.0053 1260 100
TEST_TIME 89 5435.18 0.9976 1.0042 1434 98
TEST_TIME 90 5435.19 0.9931 1.0038 1675 99
TEST_TIME 91 5442.34 0.9950 1.0038 1608 99
TEST_TIME 92 5426.15 0.9958 1.0068 1923 98
TEST_TIME 93 5431.95 0.9949 1.0050 1614 96
TEST_TIME 94 5437.10 0.9933 1.0071 1436 100
TEST_TIME 95 5439.42 0.9961 1.0080 1391 98
TEST_TIME 96 5450.33 0.9957 1.0033 1424 99
TEST_TIME 97 5448.72 0.9932 1.0082 1178 100
TEST_TIME 98 5459.96 0.9959 1.0064 1468 98
TEST_TIME 99 5452.34 0.9976 1.0025 1367 88
TEST_TIME 100 5451.58 0.9927 1.0033 1009 96
TEST_TIME 101 5440.01 0.9955 1.0046 1313 97
TEST_TIME 102 5440.05 0.9947 1.0070 1088 100
TEST_TIME 103 5440.58 0.9974 1.0022 1372 99
TEST_TIME 104 5424.10 0.9955 1.0054 1289 99
TEST_TIME 105 5416.41 0.9973 1.0057 1283 99
TEST_TIME 106 5421.02 0.9960 1.0029 1799 100
TEST_TIME 107 5421.89 0.9967 1.0033 1800 98
TEST_TIME 108 5444.49 0.9911 1.0032 1326 100
TEST_TIME 109 5431.24 0.9964 1.0037 1738 95
TEST_TIME 110 5435.14 0.9939 1.0029 1491 99
TEST_TIME 111 5426.42 0.9954 1.0072 1290 99
TEST_TIME 112 5446.43 0.9945 1.0045 1388 100
TEST_TIME 113 5465.24 0.9923 1.0039 1428 100
TEST_TIME 114 5460.10 0.9961 1.0083 1376 100
TEST_TIME 115 5477.91 0.9963 1.0036 1297 99
TEST_TIME 116 5472.54 0.9965 1.0026 1382 97
TEST_TIME 117 5472.03 0.9941 1.0034 1127 100
TEST_TIME 118 5467.17 0.9957 1.0033 1269 100
TEST_TIME 119 5447.13 0.9986 1.0015 1097 83
TEST_TIME 120 5423.51 0.9975 1.0024 1116 75
TEST_TIME 121 5425.28 0.9938 1.0051 1403 99
TEST_TIME 122 5435.82 0.9949 1.0039 1549 100
TEST_TIME 123 5449.93 0.9937 1.0029 1598 100
TEST_TIME 124 5432.13 0.9981 1.0021 1355 83
TEST_TIME 125 5422.80 0.9958 1.0030 1235 90
TEST_TIME 126 5423.97 0.9948 1.0047 1399 100
TEST_TIME 127 5425.90 0.9964 1.0032 1606 100
TEST_TIME 128 5418.14 0.9968 1.0029 1486 93
TEST_TIME 129 5424.75 0.9939 1.0061 1252 91
TEST_TIME 130 5435.69 0.9963 1.0020 1231 99
TEST_TIME 131 5417.20 0.9977 1.0027 1320 93
TEST_TIME 132 5413.31 0.9958 1.0039 1248 100
TEST_TIME 133 5407.87 0.9974 1.0045 1265 99
TEST_TIME 134 5405.82 0.9977 1.0038 1185 99
TEST_TIME 135 5397.43 0.9979 1.0023 1313 98
TEST_TIME 136 5400.53 0.9944 1.0036 1633 98
TEST_TIME 137 5404.27 0.9956 1.0080 1414 99
TEST_TIME 138 5424.89 0.9969 1.0049 1497 100
TEST_TIME 139 5436.46 0.9955 1.0031 1339 100
TEST_TIME 140 5438.67 0.9955 1.0037 1337 99
TEST_TIME 141 5450.88 0.9944 1.0043 1273 100
TEST_TIME 142 5462.43 0.9952 1.0061 1262 100
TEST_TIME 143 5471.83 0.9973 1.0022 1221 99
TEST_TIME 144 5455.49 0.9982 1.0023 1276 92
TEST_TIME 145 5459.71 0.9946 1.0051 1004 100
TEST_TIME 146 5471.11 0.9961 1.0040 1192 100
TEST_TIME 147 5463.88 0.9985 1.0023 1255 96
TEST_TIME 148 5453.43 0.9975 1.0022 1176 91
TEST_TIME 149 5459.64 0.9944 1.0022 986 99
TEST_TIME 150 5460.09 0.9956 1.0049 1603 100
TEST_TIME 151 5474.36 0.9956 1.0072 1672 100
TEST_TIME 152 5505.10 0.9950 1.0054 1331 100
TEST_TIME 153 5520.43 0.9960 1.0051 1350 100
TEST_TIME 154 5527.86 0.9972 1.0017 1639 99
TEST_TIME 155 5515.47 0.9974 1.0054 1467 91
TEST_TIME 156 5533.04 0.9957 1.0036 1126 100
TEST_TIME 157 5536.15 0.9966 1.0057 1240 100
TEST_TIME 158 5548.14 0.9972 1.0035 1240 100
TEST_TIME 159 5548.31 0.9973 1.0029 1339 100
TEST_TIME 160 5543.71 0.9975 1.0025 1242 96
TEST_TIME 161 5534.82 0.9978 1.0026 1163 99
TEST_TIME 162 5531.64 0.9970 1.0024 1143 100
TEST_TIME 163 5525.48 0.9981 1.0012 1230 98
TEST_TIME 164 5520.85 0.9959 1.0019 1052 96
TEST_TIME 165 5516.35 0.9967 1.0033 1294 99
TEST_TIME 166 5518.82 0.9968 1.0040 1512 97
TEST_TIME 167 5523.37 0.9971 1.0021 1655 95
TEST_TIME 168 5517.60 0.9971 1.0029 1491 93
TEST_TIME 169 5523.15 0.9964 1.0014 1458 93
TEST_TIME 170 5519.49 0.9962 1.0021 1350 94
TEST_TIME 171 5515.77 0.9969 1.0022 1328 94
TEST_TIME 172 5509.79 0.9974 1.0032 1193 90
TEST_TIME 173 5512.90 0.9969 1.0056 966 98
TEST_TIME 174 5521.58 0.9982 1.0039 1136 99
TEST_TIME 175 5530.71 0.9965 1.0025 1124 100
TEST_TIME 176 5525.64 0.9978 1.0016 1254 99
TEST_TIME 177 5518.46 0.9976 1.0020 1230 98
TEST_TIME 178 5509.70 0.9980 1.0025 1208 97
TEST_TIME 179 5504.80 0.9978 1.0024 1171 94
TEST_TIME 180 5495.20 0.9986 1.0025 435 95
Done for 10980 ms, from 11:32:51.53 to 11:33:02.51.

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 58039 90956 61153 <null> 49091 <null> 82186 <null> 71950 52694 84003 43742 79808 92300 104728 37388 97612 115852 <null> 08:18:28 08:36:28
fetches per second 2 53327 56383 36030 90726 46854 <null> 50571 3859 82128 92624 46335 38122 92133 214800 91233 45750 21405 90321 <null> 08:36:29 08:54:29
fetches per second 3 11808 4671 6504 <null> 8995 1480 10012 <null> 31721 43753 15911 4717 12788 30291 10686 3248 <null> 33344 397 08:54:30 09:12:30
fetches per second 4 20976 33794 27381 65124 23592 9734 26665 31156 14778 <null> 31320 26399 32665 30863 39310 <null> <null> 676500 <null> 09:12:31 09:30:31
fetches per second 5 21612 15205 10605 10054 12512 <null> 13493 <null> 47601 2757 15617 1954 28889 2376 16587 <null> 12306 44454 <null> 09:30:32 09:48:32
fetches per second 6 11528 72511 12455 <null> 9548 1641 4363 17368 20180 2317 13299 2694 17331 6349 14109 7515 11124 <null> <null> 09:48:33 10:06:33
fetches per second 7 10912 12865 18610 <null> 13580 73988 14709 <null> 4497 22809 10684 2512 18101 7745 19746 1865 67081 734056 <null> 10:06:34 10:24:34
fetches per second 8 10457 5396 7266 8276 12193 <null> 6694 <null> 8263 3434 3377 18642 14796 3139 24545 <null> 186748 39333 <null> 10:24:35 10:42:35
fetches per second 9 21767 48858 15096 6015 28808 3474 35524 2449 8700 9459 32530 21065 41370 12563 71146 1498 105601 44099 <null> 10:42:36 11:00:36
fetches per second 10 3117 1426 7680 8093 4019 <null> 2750 3495 1855 2722 6450 3236 3993 49148 5449 3156 <null> 10815 <null> 11:00:37 11:18:37
marks per second 1 12936 12335 13689 <null> 10777 <null> 12990 <null> 12174 10432 14749 5584 6944 15546 7988 7745 11145 9960 <null> 08:18:28 08:36:28
marks per second 2 11642 7695 7688 17689 10152 <null> 6470 672 13230 21421 7879 6048 9239 22400 8736 7294 1928 10260 <null> 08:36:29 08:54:29
marks per second 3 2573 612 1292 <null> 1838 296 1689 <null> 3967 5854 2122 847 1005 4458 1163 666 <null> 716 51 08:54:30 09:12:30
marks per second 4 4588 4755 5845 15033 4670 2460 3506 5292 1752 <null> 4264 5912 2409 7217 7187 <null> <null> 82500 <null> 09:12:31 09:30:31
marks per second 5 4478 1837 2246 1757 2705 <null> 1745 <null> 7161 506 2021 300 1759 461 2390 <null> 544 6831 <null> 09:30:32 09:48:32
marks per second 6 2353 9943 1959 <null> 1929 376 575 3049 2718 405 1794 370 1451 946 2504 1103 530 <null> <null> 09:48:33 10:06:33
marks per second 7 2194 1774 3397 <null> 2666 17632 1912 <null> 690 3461 1559 471 1190 1185 3556 275 7035 11709 <null> 10:06:34 10:24:34
marks per second 8 2256 763 1288 1470 2249 <null> 922 <null> 1001 553 400 2849 658 697 2016 <null> 7101 1047 <null> 10:24:35 10:42:35
marks per second 9 4786 6587 3050 1528 5876 688 5080 386 1104 1532 5053 4142 2000 2127 8615 220 2428 2361 <null> 10:42:36 11:00:36
marks per second 10 657 183 1104 1455 566 <null> 357 560 184 469 930 545 176 3888 814 609 <null> 151 <null> 11:00:37 11:18:37
reads/fetches*100 1 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 08:18:28 08:36:28
reads/fetches*100 2 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 08:36:29 08:54:29
reads/fetches*100 3 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 <null> 0 0 08:54:30 09:12:30
reads/fetches*100 4 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 0 <null> <null> 0 <null> 09:12:31 09:30:31
reads/fetches*100 5 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 09:30:32 09:48:32
reads/fetches*100 6 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> <null> 09:48:33 10:06:33
reads/fetches*100 7 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 10:06:34 10:24:34
reads/fetches*100 8 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 10:24:35 10:42:35
reads/fetches*100 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 10:42:36 11:00:36
reads/fetches*100 10 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 11:00:37 11:18:37
writes/marks*100 1 0 0 0 <null> 0 <null> 0 <null> 1 0 0 0 0 0 0 0 6 2 <null> 08:18:28 08:36:28
writes/marks*100 2 0 0 0 0 0 <null> 0 0 1 0 0 0 0 0 0 0 0 0 <null> 08:36:29 08:54:29
writes/marks*100 3 0 0 0 <null> 0 0 0 <null> 0 1 0 0 0 0 0 1 <null> 0 1 08:54:30 09:12:30
writes/marks*100 4 0 0 0 0 0 0 0 0 0 <null> 0 0 0 1 0 <null> <null> 0 <null> 09:12:31 09:30:31
writes/marks*100 5 1 0 0 0 0 <null> 0 <null> 1 1 0 0 0 0 0 <null> 0 0 <null> 09:30:32 09:48:32
writes/marks*100 6 1 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 0 <null> <null> 09:48:33 10:06:33
writes/marks*100 7 0 0 0 <null> 0 0 0 <null> 0 1 0 0 0 0 0 0 1 0 <null> 10:06:34 10:24:34
writes/marks*100 8 0 0 0 0 0 <null> 0 <null> 1 0 0 0 0 0 0 <null> 4 0 <null> 10:24:35 10:42:35
writes/marks*100 9 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 0 3 0 <null> 10:42:36 11:00:36
writes/marks*100 10 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 11:00:37 11:18:37
Done for 10300 ms, from 11:33:03.74 to 11:33:14.04.

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 1717438 1602960 114478 6.66 0 23837 53 114478 2017-06-13 08:18 2017-06-13 11:18
doc_list_biud 1717897 1602960 114937 6.69 0 18065 20 114937 2017-06-13 08:18 2017-06-13 11:18
sp_add_invoice_to_stock 18425 10831 7594 41.21 15 157467 13322 7594 2017-06-13 08:18 2017-06-13 11:18
sp_cancel_adding_invoice 4077 3226 851 20.87 0 62353 3229 851 2017-06-13 08:18 2017-06-13 11:18
sp_cancel_client_order 6525 6377 148 2.26 0 4836 291 148 2017-06-13 08:18 2017-06-13 11:18
sp_cancel_customer_reserve 283520 178484 105036 37.04 0 3978 79 105036 2017-06-13 08:18 2017-06-13 11:18
sp_cancel_pay_from_customer 2532 2521 11 0.43 0 2138 157 11 2017-06-13 08:18 2017-06-13 11:18
sp_cancel_pay_to_supplier 1534 1529 5 0.32 0 2480 161 5 2017-06-13 08:18 2017-06-13 11:18
sp_cancel_supplier_invoice 8759 6731 2028 23.15 0 18096 521 2028 2017-06-13 08:18 2017-06-13 11:18
sp_cancel_supplier_order 1513 484 1029 68.01 31 228119 23134 1029 2017-06-13 08:18 2017-06-13 11:18
sp_cancel_write_off 23028 15381 7647 33.20 0 13026 171 7647 2017-06-13 08:18 2017-06-13 11:18
sp_client_order 77857 77857 0 0.00 0 24523 570 0 2017-06-13 08:18 2017-06-13 11:18
sp_customer_reserve 560476 560476 0 0.00 0 24539 213 0 2017-06-13 08:18 2017-06-13 11:18
sp_fill_shopping_cart 117686 117426 260 0.22 0 4586 109 0 2017-06-13 08:18 2017-06-13 11:18
sp_fill_shopping_cart_clo_res 560476 560476 0 0.00 0 8705 15 0 2017-06-13 08:18 2017-06-13 11:18
sp_get_clo_for_invoice 10831 10831 0 0.00 0 25288 360 0 2017-06-13 08:18 2017-06-13 11:18
sp_kill_cost_storno 30814 22657 8157 26.47 0 5164 23 8157 2017-06-13 08:18 2017-06-13 11:18
sp_kill_qstorno_ret_qs2qd 598560 379564 218996 36.58 0 18049 29 218996 2017-06-13 08:18 2017-06-13 11:18
sp_kill_qty_storno 372627 257772 114855 30.82 0 18065 87 114855 2017-06-13 08:18 2017-06-13 11:18
sp_lock_selected_doc 76521 66300 10221 13.35 0 2558 8 10221 2017-06-13 08:18 2017-06-13 11:18
sp_make_cost_storno 94459 94459 0 0.00 0 23197 398 0 2017-06-13 08:18 2017-06-13 11:18
sp_multiply_rows_for_pdistr 94459 94459 0 0.00 0 23432 62 0 2017-06-13 08:18 2017-06-13 11:18
sp_multiply_rows_for_qdistr 77857 77857 0 0.00 0 23821 192 0 2017-06-13 08:18 2017-06-13 11:18
sp_pay_from_customer 25802 25802 0 0.00 0 23463 961 0 2017-06-13 08:18 2017-06-13 11:18
sp_pay_to_supplier 21568 21568 0 0.00 0 23915 483 0 2017-06-13 08:18 2017-06-13 11:18
sp_payment_common 47370 47370 0 0.00 0 2418 66 0 2017-06-13 08:18 2017-06-13 11:18
sp_qd_handle_on_cancel_clo 6520 6377 143 2.19 0 3432 125 143 2017-06-13 08:18 2017-06-13 11:18
sp_qd_handle_on_invoice_upd_sts 14744 14057 687 4.65 0 16333 396 687 2017-06-13 08:18 2017-06-13 11:18
sp_qd_handle_on_reserve_upd_sts 36258 36258 0 0.00 0 3401 63 0 2017-06-13 08:18 2017-06-13 11:18
sp_reserve_write_off 36797 36258 539 1.46 0 20779 601 539 2017-06-13 08:18 2017-06-13 11:18
sp_supplier_invoice 19903 19798 105 0.52 0 32292 3548 0 2017-06-13 08:18 2017-06-13 11:18
sp_supplier_order 19926 19771 155 0.77 0 25709 2545 0 2017-06-13 08:18 2017-06-13 11:18
srv_find_qd_qs_mism 1019153 904656 114497 11.23 0 20046 32 114497 2017-06-13 08:18 2017-06-13 11:18
srv_make_invnt_saldo 1561 1561 0 0.00 15 30466 3184 0 2017-06-13 08:18 2017-06-13 11:18
srv_make_money_saldo 3003 3003 0 0.00 0 4587 75 0 2017-06-13 08:18 2017-06-13 11:18
srv_recalc_idx_stat 13 13 0 0.00 1841 50934 17658 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_add_invoice_to_stock 7594 7594 0 0.00 0 2403 111 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_cancel_adding_invoice 653 653 0 0.00 0 6272 186 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_cancel_client_order 148 148 0 0.00 0 936 108 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_cancel_customer_reserve 33 33 0 0.00 0 468 82 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_cancel_pay_from_customer 11 11 0 0.00 0 702 131 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_cancel_pay_to_supplier 5 5 0 0.00 0 109 46 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_cancel_supplier_invoice 615 615 0 0.00 0 1529 113 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_cancel_supplier_order 13252 13252 0 0.00 0 14540 118 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_cancel_write_off 22 22 0 0.00 0 905 138 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_reserve_write_off 539 539 0 0.00 0 1545 84 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_supplier_invoice 105 105 0 0.00 0 1076 113 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-abend:sp_supplier_order 155 155 0 0.00 0 1217 109 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_add_invoice_to_stock 10831 10831 0 0.00 0 19874 684 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_cancel_adding_invoice 1320 1320 0 0.00 0 15163 861 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_cancel_client_order 6377 6377 0 0.00 0 2590 77 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_cancel_customer_reserve 2512 2512 0 0.00 0 1825 78 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_cancel_pay_from_customer 2521 2521 0 0.00 0 1404 56 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_cancel_pay_to_supplier 1529 1529 0 0.00 0 1904 62 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_cancel_supplier_invoice 912 912 0 0.00 0 2043 96 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_cancel_supplier_order 484 484 0 0.00 0 61994 2211 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_cancel_write_off 3556 3556 0 0.00 0 2325 85 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_client_order 77857 77857 0 0.00 0 11263 93 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_customer_reserve 3609 3609 0 0.00 0 1373 66 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_pay_from_customer 25802 25802 0 0.00 0 3011 81 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_pay_to_supplier 21568 21568 0 0.00 0 2511 68 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_reserve_write_off 36258 36258 0 0.00 0 12901 87 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_supplier_invoice 19798 19798 0 0.00 0 22823 85 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:sp_supplier_order 19771 19771 0 0.00 0 2590 86 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:srv_make_invnt_saldo 1561 1561 0 0.00 0 1544 40 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:srv_make_money_saldo 3003 3003 0 0.00 0 2074 30 0 2017-06-13 08:18 2017-06-13 11:18
t$perf-norm:srv_recalc_idx_stat 13 13 0 0.00 0 187 57 0 2017-06-13 08:18 2017-06-13 11:18
v_add_invoice_to_stock 36850 21662 15188 41.21 0 2137 61 15188 2017-06-13 08:18 2017-06-13 11:18
v_all_customers 116982 116982 0 0.00 0 1216 7 0 2017-06-13 08:18 2017-06-13 11:18
v_all_suppliers 80704 80184 520 0.64 0 718 7 0 2017-06-13 08:18 2017-06-13 11:18
v_all_wares 155714 155714 0 0.00 0 2730 5 0 2017-06-13 08:18 2017-06-13 11:18
v_cancel_adding_invoice 3090 2640 450 14.56 0 2667 167 450 2017-06-13 08:18 2017-06-13 11:18
v_cancel_client_order 13050 12754 296 2.26 0 2075 9 296 2017-06-13 08:18 2017-06-13 11:18
v_cancel_customer_prepayment 5064 5042 22 0.43 0 1170 9 22 2017-06-13 08:18 2017-06-13 11:18
v_cancel_customer_reserve 5090 5024 66 1.29 0 1045 10 66 2017-06-13 08:18 2017-06-13 11:18
v_cancel_payment_to_supplier 3068 3058 10 0.32 0 904 11 10 2017-06-13 08:18 2017-06-13 11:18
v_cancel_supplier_invoice 3054 1824 1230 40.27 0 1466 60 1230 2017-06-13 08:18 2017-06-13 11:18
v_cancel_supplier_order 3026 968 2058 68.01 0 406 8 2058 2017-06-13 08:18 2017-06-13 11:18
v_cancel_write_off 7156 7112 44 0.61 0 12604 112 44 2017-06-13 08:18 2017-06-13 11:18
v_max_id_clo_ord 19926 19771 155 0.77 0 484 6 0 2017-06-13 08:18 2017-06-13 11:18
v_max_id_clo_res 3609 3609 0 0.00 0 1077 19 0 2017-06-13 08:18 2017-06-13 11:18
v_max_id_ord_sup 19903 19798 105 0.52 0 796 6 0 2017-06-13 08:18 2017-06-13 11:18
v_max_non_paid_invoice 21045 21045 0 0.00 0 874 6 0 2017-06-13 08:18 2017-06-13 11:18
v_max_non_paid_realizn 25802 25802 0 0.00 0 1857 6 0 2017-06-13 08:18 2017-06-13 11:18
v_min_id_clo_ord 19926 19771 155 0.77 0 2138 9 0 2017-06-13 08:18 2017-06-13 11:18
v_min_id_clo_res 3609 3609 0 0.00 0 515 10 0 2017-06-13 08:18 2017-06-13 11:18
v_min_id_ord_sup 19903 19798 105 0.52 0 2247 8 0 2017-06-13 08:18 2017-06-13 11:18
v_min_non_paid_invoice 21568 21568 0 0.00 0 780 7 0 2017-06-13 08:18 2017-06-13 11:18
v_min_non_paid_realizn 25802 25802 0 0.00 0 765 7 0 2017-06-13 08:18 2017-06-13 11:18
v_our_firm 38732 38732 0 0.00 0 546 7 0 2017-06-13 08:18 2017-06-13 11:18
v_reserve_write_off 73594 72516 1078 1.46 0 1622 10 1078 2017-06-13 08:18 2017-06-13 11:18
x_lock_depdocs_on_canc_invoice 17471 9045 8426 48.22 0 1996 37 8426 2017-06-13 08:18 2017-06-13 11:18
x_lock_depdocs_on_canc_sup_ord 1507 484 1023 67.88 0 2012 72 1023 2017-06-13 08:18 2017-06-13 11:18
x_make_qstorno_1000_1200 19926 19771 155 0.77 0 25428 2301 0 2017-06-13 08:18 2017-06-13 11:18
x_make_qstorno_1200_2000 19903 19798 105 0.52 0 31839 3304 0 2017-06-13 08:18 2017-06-13 11:18
x_make_qstorno_2100_3300 560476 560476 0 0.00 0 24492 180 0 2017-06-13 08:18 2017-06-13 11:18
Done for 412930 ms, from 11:39:56.85 to 11:46:49.78.

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 90 sp_kill_cost_storno 335544336 2017-06-13 08:18 2017-06-13 11:17
deadlock 74 sp_kill_qstorno_ret_qs2qd 335544336 2017-06-13 08:19 2017-06-13 11:17
deadlock 8825 sp_lock_selected_doc 335544336 2017-06-13 08:18 2017-06-13 11:18
deadlock 143 sp_qd_handle_on_cancel_clo 335544336 2017-06-13 08:21 2017-06-13 11:15
deadlock 171 sp_qd_handle_on_invoice_upd_sts 335544336 2017-06-13 08:19 2017-06-13 11:17
deadlock 648 x_lock_depdocs_on_canc_invoice 335544336 2017-06-13 08:18 2017-06-13 11:16
deadlock 261 x_lock_depdocs_on_canc_sup_ord 335544336 2017-06-13 08:19 2017-06-13 11:17
user_exc 155 x_make_qstorno_1000_1200 335544517 2017-06-13 08:18 2017-06-13 11:18
user_exc 105 x_make_qstorno_1200_2000 335544517 2017-06-13 08:18 2017-06-13 11:18
Done for 12110 ms, from 11:46:59.64 to 11:47:11.75.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 417552
MON$OLDEST_ACTIVE 417553
MON$OLDEST_SNAPSHOT 417553
MON$NEXT_TRANSACTION 417553
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 803520
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.669 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.669 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.669 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.669 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0

Database statistics, full


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

Variable header data:
Sweep interval: 0
*END*


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

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

Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.05, total records: 2048483
Average version length: 47.86, total versions: 3442, 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: 22144
Data pages: 22144, average fill: 73%
Primary pages: 22144, secondary pages: 0, swept pages: 12059
Empty pages: 6, full pages: 20107
Fill distribution:
0 - 19% = 7
20 - 39% = 3
40 - 59% = 43
60 - 79% = 22089
80 - 99% = 2

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 9830, nodes: 2048483
Average node length: 19.24, total dup: 0, max dup: 0
Average key length: 16.28, compression ratio: 1.66
Average prefix length: 13.71, average data length: 13.29
Clustering factor: 442639, ratio: 0.22
Fill distribution:
0 - 19% = 695
20 - 39% = 2108
40 - 59% = 4483
60 - 79% = 1180
80 - 99% = 1364

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7301, nodes: 2048483
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.69, compression ratio: 1.04
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 417776, ratio: 0.20
Fill distribution:
0 - 19% = 1
20 - 39% = 3324
40 - 59% = 3904
60 - 79% = 66
80 - 99% = 6

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 176958, depth: 3, leaf buckets: 3547, nodes: 2048483
Average node length: 6.78, total dup: 1505876, max dup: 49
Average key length: 3.83, compression ratio: 2.35
Average prefix length: 7.44, average data length: 1.56
Clustering factor: 404963, ratio: 0.20
Fill distribution:
0 - 19% = 139
20 - 39% = 1105
40 - 59% = 1548
60 - 79% = 259
80 - 99% = 496

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.32, total records: 605382
Average version length: 61.33, total versions: 876, max versions: 2
Average fragment length: 4.00, total fragments: 1, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7640
Data pages: 7640, average fill: 75%
Primary pages: 7639, secondary pages: 1, swept pages: 6792
Empty pages: 6, full pages: 7218
Fill distribution:
0 - 19% = 8
20 - 39% = 1
40 - 59% = 14
60 - 79% = 7586
80 - 99% = 31

Index DOC_LIST_ID_DESC (1)
Root page: 251918, depth: 3, leaf buckets: 2248, nodes: 605382
Average node length: 11.70, 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: 150172, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 1258
40 - 59% = 959
60 - 79% = 31
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 637, nodes: 605382
Average node length: 4.87, total dup: 605332, max dup: 30846
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 271658, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 540
60 - 79% = 86
80 - 99% = 11

Index PK_DOC_LIST (0)
Root page: 332437, depth: 3, leaf buckets: 1825, nodes: 605382
Average node length: 11.70, 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: 150172, ratio: 0.25
Fill distribution:
0 - 19% = 119
20 - 39% = 616
40 - 59% = 638
60 - 79% = 206
80 - 99% = 246

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

Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

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

INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 66.96, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 19.42, total fragments: 382, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.55
Pointer pages: 1, data page slots: 888
Data pages: 28, average fill: 25%
Primary pages: 4, secondary pages: 24, swept pages: 4
Empty pages: 8, full pages: 3
Fill distribution:
0 - 19% = 17
20 - 39% = 7
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 63.62, total records: 5085
Average version length: 71.13, total versions: 543, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.51
Pointer pages: 1, data page slots: 776
Data pages: 328, average fill: 19%
Primary pages: 328, secondary pages: 0, swept pages: 278
Empty pages: 102, full pages: 15
Fill distribution:
0 - 19% = 221
20 - 39% = 50
40 - 59% = 19
60 - 79% = 33
80 - 99% = 5

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 21, nodes: 5085
Average node length: 15.06, total dup: 7, max dup: 1
Average key length: 13.06, compression ratio: 2.07
Average prefix length: 16.94, average data length: 10.06
Clustering factor: 4212, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 13
60 - 79% = 1
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 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: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 23.30, total records: 164
Average version length: 45.17, total versions: 83, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 2.75
Pointer pages: 1, data page slots: 32
Data pages: 29, average fill: 7%
Primary pages: 28, secondary pages: 1, swept pages: 16
Empty pages: 17, full pages: 1
Fill distribution:
0 - 19% = 26
20 - 39% = 2
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 339514, depth: 2, leaf buckets: 1, nodes: 164
Average node length: 7.69, total dup: 124, max dup: 22
Average key length: 5.73, compression ratio: 3.32
Average prefix length: 15.51, average data length: 3.49
Clustering factor: 79, ratio: 0.48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 18.54, total records: 751017
Average version length: 42.61, total versions: 826, max versions: 6
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.45
Pointer pages: 3, data page slots: 4456
Data pages: 4456, average fill: 74%
Primary pages: 4451, secondary pages: 5, swept pages: 3874
Empty pages: 11, full pages: 3867
Fill distribution:
0 - 19% = 19
20 - 39% = 38
40 - 59% = 58
60 - 79% = 3978
80 - 99% = 363

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 233, nodes: 214523
Average node length: 4.89, total dup: 214474, max dup: 12854
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 30581, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 28
40 - 59% = 138
60 - 79% = 60
80 - 99% = 7

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 255, nodes: 214523
Average node length: 5.83, total dup: 193532, max dup: 49
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 34455, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 12
40 - 59% = 123
60 - 79% = 81
80 - 99% = 37

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 250, nodes: 214523
Average node length: 5.83, total dup: 193532, max dup: 49
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 34473, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 8
40 - 59% = 119
60 - 79% = 84
80 - 99% = 38

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 253, nodes: 214523
Average node length: 5.62, total dup: 193532, max dup: 49
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 34472, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 129
60 - 79% = 85
80 - 99% = 21

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 508568, depth: 2, leaf buckets: 201, nodes: 258263
Average node length: 4.50, total dup: 258082, max dup: 2224
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 25967, ratio: 0.10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 61
60 - 79% = 75
80 - 99% = 65

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

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

PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.44, total records: 10707562
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.20
Pointer pages: 156, data page slots: 253648
Data pages: 253648, average fill: 87%
Primary pages: 253648, secondary pages: 0, swept pages: 3
Empty pages: 4, full pages: 253643
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 253643

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 11966, nodes: 10707562
Average node length: 5.64, total dup: 9827043, max dup: 139
Average key length: 2.20, compression ratio: 3.63
Average prefix length: 7.85, average data length: 0.15
Clustering factor: 4094426, ratio: 0.38
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 6561
60 - 79% = 3596
80 - 99% = 1805

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 10490, nodes: 10707562
Average node length: 4.52, total dup: 10707558, max dup: 9853945
Average key length: 1.08, compression ratio: 0.37
Average prefix length: 0.40, average data length: 0.00
Clustering factor: 313061, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 10484
60 - 79% = 2
80 - 99% = 3

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 12864, nodes: 10707562
Average node length: 5.68, total dup: 10354956, max dup: 18819
Average key length: 2.24, compression ratio: 4.01
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 925578, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 9371
60 - 79% = 1902
80 - 99% = 1590

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 12817, nodes: 10707562
Average node length: 5.51, total dup: 10677935, max dup: 1367828
Average key length: 2.07, compression ratio: 18.22
Average prefix length: 37.71, average data length: 0.07
Clustering factor: 6214029, ratio: 0.58
Fill distribution:
0 - 19% = 13
20 - 39% = 4
40 - 59% = 10857
60 - 79% = 620
80 - 99% = 1323

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

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

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

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

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

PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.00, total records: 439690
Average version length: 55.91, total versions: 978, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5216
Data pages: 5216, average fill: 75%
Primary pages: 5216, secondary pages: 0, swept pages: 3447
Empty pages: 1, full pages: 4940
Fill distribution:
0 - 19% = 2
20 - 39% = 6
40 - 59% = 15
60 - 79% = 5191
80 - 99% = 2

Index PSTORNED_RCV_ID (2)
Root page: 683812, depth: 3, leaf buckets: 566, nodes: 439690
Average node length: 5.88, total dup: 373737, max dup: 653
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 54440, ratio: 0.12
Fill distribution:
0 - 19% = 12
20 - 39% = 36
40 - 59% = 325
60 - 79% = 133
80 - 99% = 60

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 474, nodes: 439690
Average node length: 5.59, total dup: 392069, max dup: 132
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 104101, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 211
60 - 79% = 184
80 - 99% = 76

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.76, total records: 2215
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: 63%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 5, full pages: 26
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 1
60 - 79% = 26
80 - 99% = 0

WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

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

Index PK_WARES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

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

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

Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 44.81, total records: 5424
Average version length: 72.21, total versions: 2054, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.03
Pointer pages: 2, data page slots: 1392
Data pages: 448, average fill: 15%
Primary pages: 447, secondary pages: 1, swept pages: 366
Empty pages: 228, full pages: 42
Fill distribution:
0 - 19% = 341
20 - 39% = 51
40 - 59% = 11
60 - 79% = 26
80 - 99% = 19

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 15, nodes: 5424
Average node length: 7.41, total dup: 4688, max dup: 14
Average key length: 4.81, compression ratio: 7.69
Average prefix length: 34.32, average data length: 2.68
Clustering factor: 872, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 9
40 - 59% = 3
60 - 79% = 1
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.89, total records: 1149646
Average version length: 71.80, total versions: 4749, 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: 17176
Data pages: 17168, average fill: 74%
Primary pages: 17168, secondary pages: 0, swept pages: 10831
Empty pages: 44, full pages: 13731
Fill distribution:
0 - 19% = 105
20 - 39% = 201
40 - 59% = 854
60 - 79% = 15927
80 - 99% = 81

Index XQD_1000_3300_DOC (1)
Root page: 408196, depth: 3, leaf buckets: 1335, nodes: 1149646
Average node length: 5.12, total dup: 1120328, max dup: 123
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 132540, ratio: 0.12
Fill distribution:
0 - 19% = 18
20 - 39% = 113
40 - 59% = 979
60 - 79% = 44
80 - 99% = 181

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 245243, depth: 3, leaf buckets: 1641, nodes: 1149646
Average node length: 6.24, total dup: 1004723, max dup: 22
Average key length: 3.31, compression ratio: 11.18
Average prefix length: 35.82, average data length: 1.18
Clustering factor: 223669, ratio: 0.19
Fill distribution:
0 - 19% = 15
20 - 39% = 158
40 - 59% = 1165
60 - 79% = 179
80 - 99% = 124

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 19.40, total records: 86726
Average version length: 72.15, total versions: 4606, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 7.01
Pointer pages: 3, data page slots: 4520
Data pages: 4144, average fill: 12%
Primary pages: 4143, secondary pages: 1, swept pages: 3254
Empty pages: 1357, full pages: 120
Fill distribution:
0 - 19% = 3254
20 - 39% = 597
40 - 59% = 146
60 - 79% = 117
80 - 99% = 30

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 42, nodes: 19557
Average node length: 6.16, total dup: 17386, max dup: 49
Average key length: 3.64, compression ratio: 10.17
Average prefix length: 35.47, average data length: 1.53
Clustering factor: 2481, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 30
40 - 59% = 9
60 - 79% = 3
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 54.34, total records: 2324429
Average version length: 71.68, total versions: 39355, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.50
Pointer pages: 19, data page slots: 30768
Data pages: 30744, average fill: 68%
Primary pages: 30744, secondary pages: 0, swept pages: 14412
Empty pages: 274, full pages: 24849
Fill distribution:
0 - 19% = 497
20 - 39% = 3253
40 - 59% = 2843
60 - 79% = 21146
80 - 99% = 3005

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 194917, depth: 3, leaf buckets: 2728, nodes: 1712719
Average node length: 5.64, total dup: 1607827, max dup: 49
Average key length: 2.67, compression ratio: 13.86
Average prefix length: 36.39, average data length: 0.61
Clustering factor: 220187, ratio: 0.13
Fill distribution:
0 - 19% = 11
20 - 39% = 1277
40 - 59% = 1081
60 - 79% = 225
80 - 99% = 134

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.02, total records: 3463410
Average version length: 70.97, total versions: 904, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.08
Pointer pages: 14, data page slots: 21376
Data pages: 21376, average fill: 52%
Primary pages: 21375, secondary pages: 1, swept pages: 8063
Empty pages: 12, full pages: 20684
Fill distribution:
0 - 19% = 131
20 - 39% = 6332
40 - 59% = 5401
60 - 79% = 9455
80 - 99% = 57

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 7, nodes: 1935
Average node length: 11.13, total dup: 1339, max dup: 19
Average key length: 8.13, compression ratio: 4.55
Average prefix length: 31.18, average data length: 5.82
Clustering factor: 459, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 4
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 62.05, total records: 2940286
Average version length: 71.24, total versions: 17482, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.19
Pointer pages: 24, data page slots: 37848
Data pages: 37848, average fill: 76%
Primary pages: 37848, secondary pages: 0, swept pages: 26362
Empty pages: 20, full pages: 34445
Fill distribution:
0 - 19% = 40
20 - 39% = 221
40 - 59% = 849
60 - 79% = 34256
80 - 99% = 2482

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5184, nodes: 2516669
Average node length: 6.87, total dup: 2039879, max dup: 14
Average key length: 3.90, compression ratio: 9.49
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 473577, ratio: 0.19
Fill distribution:
0 - 19% = 7
20 - 39% = 2827
40 - 59% = 1910
60 - 79% = 262
80 - 99% = 178

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.67, total records: 4546196
Average version length: 84.50, total versions: 1746, 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: 43, data page slots: 69848
Data pages: 69848, average fill: 80%
Primary pages: 69848, secondary pages: 0, swept pages: 25798
Empty pages: 1, full pages: 69521
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 19
60 - 79% = 20478
80 - 99% = 49345

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4613, nodes: 4546196
Average node length: 5.15, total dup: 4442804, max dup: 129
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 736049, ratio: 0.16
Fill distribution:
0 - 19% = 17
20 - 39% = 92
40 - 59% = 2018
60 - 79% = 1857
80 - 99% = 629

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 5070, nodes: 4546196
Average node length: 5.69, total dup: 4072593, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 258847, ratio: 0.06
Fill distribution:
0 - 19% = 55
20 - 39% = 142
40 - 59% = 3013
60 - 79% = 308
80 - 99% = 1552

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5159, nodes: 4546196
Average node length: 5.81, total dup: 3977718, max dup: 25
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 790225, ratio: 0.17
Fill distribution:
0 - 19% = 33
20 - 39% = 113
40 - 59% = 2266
60 - 79% = 1889
80 - 99% = 858

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 82.73, total records: 2281727
Average version length: 83.99, total versions: 12458, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 22, data page slots: 35760
Data pages: 35760, average fill: 78%
Primary pages: 35760, secondary pages: 0, swept pages: 25716
Empty pages: 34, full pages: 33757
Fill distribution:
0 - 19% = 62
20 - 39% = 92
40 - 59% = 395
60 - 79% = 15420
80 - 99% = 19791

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2448, nodes: 2281727
Average node length: 5.15, total dup: 2228423, max dup: 186
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 354182, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 50
40 - 59% = 1440
60 - 79% = 731
80 - 99% = 225

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 3977, nodes: 2281727
Average node length: 6.22, total dup: 1873171, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 231287, ratio: 0.10
Fill distribution:
0 - 19% = 130
20 - 39% = 1693
40 - 59% = 1517
60 - 79% = 414
80 - 99% = 223

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 2775, nodes: 2281727
Average node length: 5.81, total dup: 1996217, max dup: 31
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 427853, ratio: 0.19
Fill distribution:
0 - 19% = 10
20 - 39% = 63
40 - 59% = 1646
60 - 79% = 799
80 - 99% = 257

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.54, total records: 4820200
Average version length: 84.93, total versions: 16477, 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: 46, data page slots: 74936
Data pages: 74888, average fill: 80%
Primary pages: 74888, secondary pages: 0, swept pages: 21537
Empty pages: 149, full pages: 71811
Fill distribution:
0 - 19% = 235
20 - 39% = 284
40 - 59% = 884
60 - 79% = 16427
80 - 99% = 57058

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5134, nodes: 4820200
Average node length: 5.04, total dup: 4792122, max dup: 687
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 716460, ratio: 0.15
Fill distribution:
0 - 19% = 6
20 - 39% = 282
40 - 59% = 2906
60 - 79% = 1445
80 - 99% = 495

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5904, nodes: 4820200
Average node length: 5.53, total dup: 4435491, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 282594, ratio: 0.06
Fill distribution:
0 - 19% = 89
20 - 39% = 1475
40 - 59% = 2532
60 - 79% = 565
80 - 99% = 1243

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5722, nodes: 4820200
Average node length: 5.68, total dup: 4327923, max dup: 69
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 795923, ratio: 0.17
Fill distribution:
0 - 19% = 7
20 - 39% = 195
40 - 59% = 3285
60 - 79% = 1615
80 - 99% = 620

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

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

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

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

XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.10, total records: 3142630
Average version length: 84.34, total versions: 13302, 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: 49224
Data pages: 49224, average fill: 79%
Primary pages: 49224, secondary pages: 0, swept pages: 34448
Empty pages: 29, full pages: 46548
Fill distribution:
0 - 19% = 57
20 - 39% = 78
40 - 59% = 450
60 - 79% = 20125
80 - 99% = 28514

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3409, nodes: 3142630
Average node length: 5.03, total dup: 3126594, max dup: 1212
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 675771, ratio: 0.22
Fill distribution:
0 - 19% = 15
20 - 39% = 338
40 - 59% = 1838
60 - 79% = 845
80 - 99% = 373

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 5533, nodes: 3142630
Average node length: 6.24, total dup: 2574716, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 357845, ratio: 0.11
Fill distribution:
0 - 19% = 208
20 - 39% = 2482
40 - 59% = 1925
60 - 79% = 588
80 - 99% = 330

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 3719, nodes: 3142630
Average node length: 5.60, total dup: 2859610, max dup: 73
Average key length: 2.63, compression ratio: 3.43
Average prefix length: 8.46, average data length: 0.54
Clustering factor: 714727, ratio: 0.23
Fill distribution:
0 - 19% = 10
20 - 39% = 321
40 - 59% = 1893
60 - 79% = 1032
80 - 99% = 463

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.28, total records: 631951
Average version length: 69.78, total versions: 1810, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 6, data page slots: 8688
Data pages: 8688, average fill: 77%
Primary pages: 8688, secondary pages: 0, swept pages: 6429
Empty pages: 6, full pages: 8444
Fill distribution:
0 - 19% = 8
20 - 39% = 9
40 - 59% = 49
60 - 79% = 8577
80 - 99% = 45

Index XQS_3300_3400_DOC_ID (0)
Root page: 227907, depth: 3, leaf buckets: 728, nodes: 631951
Average node length: 5.31, total dup: 595536, max dup: 122
Average key length: 2.44, compression ratio: 3.69
Average prefix length: 8.62, average data length: 0.38
Clustering factor: 54044, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 123
40 - 59% = 318
60 - 79% = 190
80 - 99% = 95

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 827, nodes: 631951
Average node length: 5.93, total dup: 539631, max dup: 25
Average key length: 3.05, compression ratio: 2.95
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 58699, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 145
40 - 59% = 372
60 - 79% = 217
80 - 99% = 90

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 147670 ms, from 11:47:12.35 to 11:49:40.02.

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

TABLE_NAME TOTAL_RECS TOTAL_VERS VERS_PERCENT
AGENTS 50 0 0.0000
BUSINESS_OPS 19 0 0.0000
DOC_DATA 2048483 3442 0.1680
DOC_LIST 605382 876 0.1447
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 5085 543 10.6784
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 164 83 50.6097
OPTYPES 9 0 0.0000
PDISTR 751017 826 0.1099
PERF_ESTIMATED 258263 0 0.0000
PERF_LOG 10707562 0 0.0000
PSTORNED 439690 978 0.2224
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 2215 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 5424 2054 37.8687
XQD_1000_3300 1149646 4749 0.4130
XQD_1200_2000 86726 4606 5.3109
XQD_2000_3300 2324429 39355 1.6931
XQD_2100_3300 3463410 904 0.0261
XQD_3300_3400 2940286 17482 0.5945
XQS_1000_1200 4546196 1746 0.0384
XQS_1000_3300 2281727 12458 0.5459
XQS_1200_2000 4820200 16477 0.3418
XQS_2100_3300 3142630 13302 0.4232
XQS_3300_3400 631951 1810 0.2864
Z_USED_VIEWS 29 0 0.0000
Done for 2550 ms, from 11:49:52.19 to 11:49:54.74.

Database validation

11:49:54.97 Validation started

11:49:54.99 Relation 140 (DOC_LIST)
11:49:54.99 process pointer page 0 of 5
11:49:55.09 process pointer page 1 of 5
11:49:55.20 process pointer page 2 of 5
11:49:55.31 process pointer page 3 of 5
11:49:55.44 process pointer page 4 of 5
11:49:55.52 Index 1 (PK_DOC_LIST)
11:49:55.67 Index 2 (DOC_LIST_ID_DESC)
11:49:55.81 Index 3 (FK_DOC_LIST_AGENTS)
11:49:56.05 Relation 140 (DOC_LIST) is ok

11:49:56.05 Relation 141 (DOC_DATA)
11:49:56.05 process pointer page 0 of 14
11:49:56.16 process pointer page 1 of 14
11:49:56.26 process pointer page 2 of 14
11:49:56.36 process pointer page 3 of 14
11:49:56.47 process pointer page 4 of 14
11:49:56.58 process pointer page 5 of 14
11:49:56.69 process pointer page 6 of 14
11:49:56.78 process pointer page 7 of 14
11:49:56.89 process pointer page 8 of 14
11:49:56.98 process pointer page 9 of 14
11:49:57.09 process pointer page 10 of 14
11:49:57.20 process pointer page 11 of 14
11:49:57.29 process pointer page 12 of 14
11:49:57.40 process pointer page 13 of 14
11:49:57.47 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:49:58.48 Index 3 (DOC_DATA_ID_DESC)
11:49:59.32 Index 4 (FK_DOC_DATA_DOC_LIST)
11:50:00.01 Relation 141 (DOC_DATA) is ok

11:50:00.01 Relation 147 (INVNT_SALDO)
11:50:00.01 process pointer page 0 of 1
11:50:00.01 Index 1 (PK_INVNT_SALDO)
11:50:00.01 Relation 147 (INVNT_SALDO) is ok

11:50:00.01 Relation 150 (PDISTR)
11:50:00.01 process pointer page 0 of 3
11:50:00.10 process pointer page 1 of 3
11:50:00.13 process pointer page 2 of 3
11:50:00.18 Index 2 (PDISTR_SND_ID)
11:50:00.27 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:50:00.35 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:50:00.43 Index 5 (PDISTR_AGENT_ID)
11:50:00.48 Relation 150 (PDISTR) is ok

11:50:00.48 Relation 151 (PSTORNED)
11:50:00.48 process pointer page 0 of 4
11:50:00.51 process pointer page 1 of 4
11:50:00.55 process pointer page 2 of 4
11:50:00.60 process pointer page 3 of 4
11:50:00.60 Index 2 (PSTORNED_SND_ID)
11:50:00.66 Index 3 (PSTORNED_RCV_ID)
11:50:00.73 Relation 151 (PSTORNED) is ok

11:50:00.73 Relation 156 (SEMAPHORES)
11:50:00.73 process pointer page 0 of 1
11:50:00.73 Index 1 (PK_SEMAPHORES)
11:50:00.73 Index 2 (SEMAPHORES_TASK_UNQ)
11:50:00.73 Relation 156 (SEMAPHORES) is ok

11:50:00.73 Relation 157 (INVNT_TURNOVER_LOG)
11:50:00.73 process pointer page 0 of 1
11:50:00.74 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:50:00.74 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:50:00.74 Relation 160 (PERF_ESTIMATED)
11:50:00.74 process pointer page 0 of 2
11:50:00.85 process pointer page 1 of 2
11:50:00.88 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:50:00.94 Relation 160 (PERF_ESTIMATED) is ok

11:50:00.94 Relation 161 (PERF_ISQL_STAT)
11:50:00.94 process pointer page 0 of 1
11:50:00.94 Index 1 (PERF_ISQL_STAT_TRN)
11:50:00.94 Relation 161 (PERF_ISQL_STAT) is ok

11:50:00.94 Relation 162 (TRACE_STAT)
11:50:00.94 process pointer page 0 of 1
11:50:00.94 Relation 162 (TRACE_STAT) is ok

11:50:00.94 Relation 163 (PERF_LOG)
11:50:00.94 process pointer page 0 of 156
11:50:01.04 process pointer page 1 of 156
11:50:01.13 process pointer page 2 of 156
11:50:01.24 process pointer page 3 of 156
11:50:01.30 process pointer page 4 of 156
11:50:01.35 process pointer page 5 of 156
11:50:01.38 process pointer page 6 of 156
11:50:01.46 process pointer page 7 of 156
11:50:01.54 process pointer page 8 of 156
11:50:01.63 process pointer page 9 of 156
11:50:01.72 process pointer page 10 of 156
11:50:01.82 process pointer page 11 of 156
11:50:01.91 process pointer page 12 of 156
11:50:02.01 process pointer page 13 of 156
11:50:02.10 process pointer page 14 of 156
11:50:02.19 process pointer page 15 of 156
11:50:02.29 process pointer page 16 of 156
11:50:02.38 process pointer page 17 of 156
11:50:02.47 process pointer page 18 of 156
11:50:02.57 process pointer page 19 of 156
11:50:02.66 process pointer page 20 of 156
11:50:02.74 process pointer page 21 of 156
11:50:02.83 process pointer page 22 of 156
11:50:02.94 process pointer page 23 of 156
11:50:03.03 process pointer page 24 of 156
11:50:03.13 process pointer page 25 of 156
11:50:03.22 process pointer page 26 of 156
11:50:03.30 process pointer page 27 of 156
11:50:03.39 process pointer page 28 of 156
11:50:03.49 process pointer page 29 of 156
11:50:03.58 process pointer page 30 of 156
11:50:03.66 process pointer page 31 of 156
11:50:03.75 process pointer page 32 of 156
11:50:03.85 process pointer page 33 of 156
11:50:03.94 process pointer page 34 of 156
11:50:04.02 process pointer page 35 of 156
11:50:04.11 process pointer page 36 of 156
11:50:04.20 process pointer page 37 of 156
11:50:04.30 process pointer page 38 of 156
11:50:04.38 process pointer page 39 of 156
11:50:04.47 process pointer page 40 of 156
11:50:04.56 process pointer page 41 of 156
11:50:04.64 process pointer page 42 of 156
11:50:04.74 process pointer page 43 of 156
11:50:04.83 process pointer page 44 of 156
11:50:04.92 process pointer page 45 of 156
11:50:05.00 process pointer page 46 of 156
11:50:05.09 process pointer page 47 of 156
11:50:05.19 process pointer page 48 of 156
11:50:05.28 process pointer page 49 of 156
11:50:05.36 process pointer page 50 of 156
11:50:05.45 process pointer page 51 of 156
11:50:05.55 process pointer page 52 of 156
11:50:05.64 process pointer page 53 of 156
11:50:05.73 process pointer page 54 of 156
11:50:05.81 process pointer page 55 of 156
11:50:05.91 process pointer page 56 of 156
11:50:06.00 process pointer page 57 of 156
11:50:06.09 process pointer page 58 of 156
11:50:06.17 process pointer page 59 of 156
11:50:06.26 process pointer page 60 of 156
11:50:06.36 process pointer page 61 of 156
11:50:06.45 process pointer page 62 of 156
11:50:06.53 process pointer page 63 of 156
11:50:06.62 process pointer page 64 of 156
11:50:06.72 process pointer page 65 of 156
11:50:06.79 process pointer page 66 of 156
11:50:06.89 process pointer page 67 of 156
11:50:06.98 process pointer page 68 of 156
11:50:07.08 process pointer page 69 of 156
11:50:07.17 process pointer page 70 of 156
11:50:07.26 process pointer page 71 of 156
11:50:07.34 process pointer page 72 of 156
11:50:07.43 process pointer page 73 of 156
11:50:07.53 process pointer page 74 of 156
11:50:07.61 process pointer page 75 of 156
11:50:07.70 process pointer page 76 of 156
11:50:07.79 process pointer page 77 of 156
11:50:07.89 process pointer page 78 of 156
11:50:07.98 process pointer page 79 of 156
11:50:08.06 process pointer page 80 of 156
11:50:08.15 process pointer page 81 of 156
11:50:08.25 process pointer page 82 of 156
11:50:08.34 process pointer page 83 of 156
11:50:08.43 process pointer page 84 of 156
11:50:08.51 process pointer page 85 of 156
11:50:08.60 process pointer page 86 of 156
11:50:08.70 process pointer page 87 of 156
11:50:08.79 process pointer page 88 of 156
11:50:08.88 process pointer page 89 of 156
11:50:08.98 process pointer page 90 of 156
11:50:09.06 process pointer page 91 of 156
11:50:09.15 process pointer page 92 of 156
11:50:09.24 process pointer page 93 of 156
11:50:09.34 process pointer page 94 of 156
11:50:09.43 process pointer page 95 of 156
11:50:09.51 process pointer page 96 of 156
11:50:09.60 process pointer page 97 of 156
11:50:09.70 process pointer page 98 of 156
11:50:09.79 process pointer page 99 of 156
11:50:09.88 process pointer page 100 of 156
11:50:09.96 process pointer page 101 of 156
11:50:10.05 process pointer page 102 of 156
11:50:10.15 process pointer page 103 of 156
11:50:10.24 process pointer page 104 of 156
11:50:10.32 process pointer page 105 of 156
11:50:10.41 process pointer page 106 of 156
11:50:10.51 process pointer page 107 of 156
11:50:10.59 process pointer page 108 of 156
11:50:10.68 process pointer page 109 of 156
11:50:10.77 process pointer page 110 of 156
11:50:10.87 process pointer page 111 of 156
11:50:10.94 process pointer page 112 of 156
11:50:11.04 process pointer page 113 of 156
11:50:11.13 process pointer page 114 of 156
11:50:11.22 process pointer page 115 of 156
11:50:11.32 process pointer page 116 of 156
11:50:11.40 process pointer page 117 of 156
11:50:11.49 process pointer page 118 of 156
11:50:11.58 process pointer page 119 of 156
11:50:11.68 process pointer page 120 of 156
11:50:11.77 process pointer page 121 of 156
11:50:11.86 process pointer page 122 of 156
11:50:11.96 process pointer page 123 of 156
11:50:12.05 process pointer page 124 of 156
11:50:12.15 process pointer page 125 of 156
11:50:12.24 process pointer page 126 of 156
11:50:12.33 process pointer page 127 of 156
11:50:12.43 process pointer page 128 of 156
11:50:12.50 process pointer page 129 of 156
11:50:12.60 process pointer page 130 of 156
11:50:12.64 process pointer page 131 of 156
11:50:12.72 process pointer page 132 of 156
11:50:12.80 process pointer page 133 of 156
11:50:12.89 process pointer page 134 of 156
11:50:13.00 process pointer page 135 of 156
11:50:13.10 process pointer page 136 of 156
11:50:13.19 process pointer page 137 of 156
11:50:13.28 process pointer page 138 of 156
11:50:13.38 process pointer page 139 of 156
11:50:13.46 process pointer page 140 of 156
11:50:13.55 process pointer page 141 of 156
11:50:13.64 process pointer page 142 of 156
11:50:13.74 process pointer page 143 of 156
11:50:13.83 process pointer page 144 of 156
11:50:13.92 process pointer page 145 of 156
11:50:14.02 process pointer page 146 of 156
11:50:14.11 process pointer page 147 of 156
11:50:14.20 process pointer page 148 of 156
11:50:14.28 process pointer page 149 of 156
11:50:14.38 process pointer page 150 of 156
11:50:14.47 process pointer page 151 of 156
11:50:14.56 process pointer page 152 of 156
11:50:14.66 process pointer page 153 of 156
11:50:14.69 process pointer page 154 of 156
11:50:14.77 process pointer page 155 of 156
11:50:14.80 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:50:18.84 Index 2 (PERF_LOG_UNIT)
11:50:24.87 Index 3 (PERF_LOG_TRN_DESC)
11:50:27.56 Index 4 (PERF_LOG_GDSCODE)
11:50:30.01 Relation 163 (PERF_LOG) is ok

11:50:30.01 Relation 167 (V_STOPTEST)
11:50:30.01 Relation 167 (V_STOPTEST) is ok

11:50:30.01 Relation 184 (V_QDISTR_SOURCE)
11:50:30.01 Relation 184 (V_QDISTR_SOURCE) is ok

11:50:30.01 Relation 185 (V_QSTORNED_SOURCE)
11:50:30.01 Relation 185 (V_QSTORNED_SOURCE) is ok

11:50:30.01 Relation 260 (XQD_1000_1200)
11:50:30.02 process pointer page 0 of 2
11:50:30.02 process pointer page 1 of 2
11:50:30.04 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:50:30.04 Relation 260 (XQD_1000_1200) is ok

11:50:30.04 Relation 261 (XQD_1200_2000)
11:50:30.04 process pointer page 0 of 3
11:50:30.10 process pointer page 1 of 3
11:50:30.15 process pointer page 2 of 3
11:50:30.19 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:50:30.19 Relation 261 (XQD_1200_2000) is ok

11:50:30.19 Relation 262 (XQD_1000_3300)
11:50:30.19 process pointer page 0 of 11
11:50:30.30 process pointer page 1 of 11
11:50:30.41 process pointer page 2 of 11
11:50:30.51 process pointer page 3 of 11
11:50:30.62 process pointer page 4 of 11
11:50:30.72 process pointer page 5 of 11
11:50:30.82 process pointer page 6 of 11
11:50:30.93 process pointer page 7 of 11
11:50:31.02 process pointer page 8 of 11
11:50:31.13 process pointer page 9 of 11
11:50:31.22 process pointer page 10 of 11
11:50:31.29 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:50:31.71 Index 2 (XQD_1000_3300_DOC)
11:50:32.04 Relation 262 (XQD_1000_3300) is ok

11:50:32.04 Relation 263 (XQD_2000_3300)
11:50:32.05 process pointer page 0 of 19
11:50:32.14 process pointer page 1 of 19
11:50:32.24 process pointer page 2 of 19
11:50:32.35 process pointer page 3 of 19
11:50:32.44 process pointer page 4 of 19
11:50:32.55 process pointer page 5 of 19
11:50:32.66 process pointer page 6 of 19
11:50:32.75 process pointer page 7 of 19
11:50:32.86 process pointer page 8 of 19
11:50:32.96 process pointer page 9 of 19
11:50:33.06 process pointer page 10 of 19
11:50:33.16 process pointer page 11 of 19
11:50:33.27 process pointer page 12 of 19
11:50:33.36 process pointer page 13 of 19
11:50:33.45 process pointer page 14 of 19
11:50:33.56 process pointer page 15 of 19
11:50:33.66 process pointer page 16 of 19
11:50:33.75 process pointer page 17 of 19
11:50:33.84 process pointer page 18 of 19
11:50:33.94 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:50:34.55 Relation 263 (XQD_2000_3300) is ok

11:50:34.55 Relation 264 (XQD_2100_3300)
11:50:34.55 process pointer page 0 of 14
11:50:34.61 process pointer page 1 of 14
11:50:34.67 process pointer page 2 of 14
11:50:34.73 process pointer page 3 of 14
11:50:34.81 process pointer page 4 of 14
11:50:34.87 process pointer page 5 of 14
11:50:34.94 process pointer page 6 of 14
11:50:35.00 process pointer page 7 of 14
11:50:35.08 process pointer page 8 of 14
11:50:35.14 process pointer page 9 of 14
11:50:35.20 process pointer page 10 of 14
11:50:35.26 process pointer page 11 of 14
11:50:35.33 process pointer page 12 of 14
11:50:35.39 process pointer page 13 of 14
11:50:35.40 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:50:35.40 Relation 264 (XQD_2100_3300) is ok

11:50:35.40 Relation 265 (XQD_3300_3400)
11:50:35.40 process pointer page 0 of 24
11:50:35.51 process pointer page 1 of 24
11:50:35.61 process pointer page 2 of 24
11:50:35.72 process pointer page 3 of 24
11:50:35.83 process pointer page 4 of 24
11:50:35.94 process pointer page 5 of 24
11:50:36.04 process pointer page 6 of 24
11:50:36.14 process pointer page 7 of 24
11:50:36.25 process pointer page 8 of 24
11:50:36.36 process pointer page 9 of 24
11:50:36.42 process pointer page 10 of 24
11:50:36.47 process pointer page 11 of 24
11:50:36.51 process pointer page 12 of 24
11:50:36.62 process pointer page 13 of 24
11:50:36.72 process pointer page 14 of 24
11:50:36.82 process pointer page 15 of 24
11:50:36.93 process pointer page 16 of 24
11:50:37.04 process pointer page 17 of 24
11:50:37.15 process pointer page 18 of 24
11:50:37.25 process pointer page 19 of 24
11:50:37.35 process pointer page 20 of 24
11:50:37.46 process pointer page 21 of 24
11:50:37.57 process pointer page 22 of 24
11:50:37.68 process pointer page 23 of 24
11:50:37.70 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:50:38.76 Relation 265 (XQD_3300_3400) is ok

11:50:38.77 Relation 266 (XQS_1000_1200)
11:50:38.77 process pointer page 0 of 43
11:50:38.87 process pointer page 1 of 43
11:50:38.98 process pointer page 2 of 43
11:50:39.09 process pointer page 3 of 43
11:50:39.20 process pointer page 4 of 43
11:50:39.30 process pointer page 5 of 43
11:50:39.41 process pointer page 6 of 43
11:50:39.51 process pointer page 7 of 43
11:50:39.62 process pointer page 8 of 43
11:50:39.73 process pointer page 9 of 43
11:50:39.84 process pointer page 10 of 43
11:50:39.93 process pointer page 11 of 43
11:50:40.04 process pointer page 12 of 43
11:50:40.15 process pointer page 13 of 43
11:50:40.26 process pointer page 14 of 43
11:50:40.37 process pointer page 15 of 43
11:50:40.46 process pointer page 16 of 43
11:50:40.57 process pointer page 17 of 43
11:50:40.68 process pointer page 18 of 43
11:50:40.79 process pointer page 19 of 43
11:50:40.88 process pointer page 20 of 43
11:50:40.99 process pointer page 21 of 43
11:50:41.10 process pointer page 22 of 43
11:50:41.19 process pointer page 23 of 43
11:50:41.30 process pointer page 24 of 43
11:50:41.40 process pointer page 25 of 43
11:50:41.50 process pointer page 26 of 43
11:50:41.61 process pointer page 27 of 43
11:50:41.71 process pointer page 28 of 43
11:50:41.82 process pointer page 29 of 43
11:50:41.93 process pointer page 30 of 43
11:50:42.02 process pointer page 31 of 43
11:50:42.13 process pointer page 32 of 43
11:50:42.24 process pointer page 33 of 43
11:50:42.33 process pointer page 34 of 43
11:50:42.44 process pointer page 35 of 43
11:50:42.55 process pointer page 36 of 43
11:50:42.64 process pointer page 37 of 43
11:50:42.75 process pointer page 38 of 43
11:50:42.86 process pointer page 39 of 43
11:50:42.96 process pointer page 40 of 43
11:50:43.06 process pointer page 41 of 43
11:50:43.17 process pointer page 42 of 43
11:50:43.25 Index 1 (XQS_1000_1200_DOC_ID)
11:50:44.58 Index 2 (XQS_1000_1200_SND_ID)
11:50:45.93 Index 3 (XQS_1000_1200_RCV_ID)
11:50:47.07 Relation 266 (XQS_1000_1200) is ok

11:50:47.07 Relation 267 (XQS_1200_2000)
11:50:47.07 process pointer page 0 of 46
11:50:47.18 process pointer page 1 of 46
11:50:47.29 process pointer page 2 of 46
11:50:47.40 process pointer page 3 of 46
11:50:47.48 process pointer page 4 of 46
11:50:47.56 process pointer page 5 of 46
11:50:47.67 process pointer page 6 of 46
11:50:47.78 process pointer page 7 of 46
11:50:47.90 process pointer page 8 of 46
11:50:48.01 process pointer page 9 of 46
11:50:48.12 process pointer page 10 of 46
11:50:48.24 process pointer page 11 of 46
11:50:48.37 process pointer page 12 of 46
11:50:48.48 process pointer page 13 of 46
11:50:48.52 process pointer page 14 of 46
11:50:48.60 process pointer page 15 of 46
11:50:48.68 process pointer page 16 of 46
11:50:48.74 process pointer page 17 of 46
11:50:48.88 process pointer page 18 of 46
11:50:49.02 process pointer page 19 of 46
11:50:49.15 process pointer page 20 of 46
11:50:49.27 process pointer page 21 of 46
11:50:49.40 process pointer page 22 of 46
11:50:49.52 process pointer page 23 of 46
11:50:49.63 process pointer page 24 of 46
11:50:49.76 process pointer page 25 of 46
11:50:49.88 process pointer page 26 of 46
11:50:49.99 process pointer page 27 of 46
11:50:50.12 process pointer page 28 of 46
11:50:50.24 process pointer page 29 of 46
11:50:50.37 process pointer page 30 of 46
11:50:50.49 process pointer page 31 of 46
11:50:50.60 process pointer page 32 of 46
11:50:50.72 process pointer page 33 of 46
11:50:50.85 process pointer page 34 of 46
11:50:50.97 process pointer page 35 of 46
11:50:51.10 process pointer page 36 of 46
11:50:51.22 process pointer page 37 of 46
11:50:51.35 process pointer page 38 of 46
11:50:51.46 process pointer page 39 of 46
11:50:51.58 process pointer page 40 of 46
11:50:51.71 process pointer page 41 of 46
11:50:51.82 process pointer page 42 of 46
11:50:51.94 process pointer page 43 of 46
11:50:52.07 process pointer page 44 of 46
11:50:52.19 process pointer page 45 of 46
11:50:52.30 Index 1 (XQS_1200_2000_DOC_ID)
11:50:53.88 Index 2 (XQS_1200_2000_SND_ID)
11:50:55.51 Index 3 (XQS_1200_2000_RCV_ID)
11:50:56.82 Relation 267 (XQS_1200_2000) is ok

11:50:56.82 Relation 268 (XQS_1000_3300)
11:50:56.82 process pointer page 0 of 22
11:50:57.31 process pointer page 1 of 22
11:50:57.82 process pointer page 2 of 22
11:50:58.32 process pointer page 3 of 22
11:50:58.84 process pointer page 4 of 22
11:50:59.16 process pointer page 5 of 22
11:50:59.46 process pointer page 6 of 22
11:50:59.73 process pointer page 7 of 22
11:51:00.01 process pointer page 8 of 22
11:51:00.29 process pointer page 9 of 22
11:51:00.60 process pointer page 10 of 22
11:51:00.97 process pointer page 11 of 22
11:51:01.33 process pointer page 12 of 22
11:51:01.71 process pointer page 13 of 22
11:51:02.07 process pointer page 14 of 22
11:51:02.44 process pointer page 15 of 22
11:51:02.80 process pointer page 16 of 22
11:51:03.19 process pointer page 17 of 22
11:51:03.55 process pointer page 18 of 22
11:51:03.92 process pointer page 19 of 22
11:51:04.30 process pointer page 20 of 22
11:51:04.65 process pointer page 21 of 22
11:51:05.00 Index 1 (XQS_1000_3300_DOC_ID)
11:51:06.34 Index 2 (XQS_1000_3300_SND_ID)
11:51:07.79 Index 3 (XQS_1000_3300_RCV_ID)
11:51:09.33 Relation 268 (XQS_1000_3300) is ok

11:51:09.33 Relation 269 (XQS_2000_3300)
11:51:09.33 process pointer page 0 of 1
11:51:09.33 Index 1 (XQS_2000_3300_DOC_ID)
11:51:09.33 Index 2 (XQS_2000_3300_SND_ID)
11:51:09.33 Index 3 (XQS_2000_3300_RCV_ID)
11:51:09.33 Relation 269 (XQS_2000_3300) is ok

11:51:09.33 Relation 270 (XQS_2100_3300)
11:51:09.33 process pointer page 0 of 31
11:51:09.85 process pointer page 1 of 31
11:51:10.35 process pointer page 2 of 31
11:51:10.86 process pointer page 3 of 31
11:51:11.38 process pointer page 4 of 31
11:51:11.74 process pointer page 5 of 31
11:51:12.25 process pointer page 6 of 31
11:51:12.75 process pointer page 7 of 31
11:51:13.28 process pointer page 8 of 31
11:51:13.77 process pointer page 9 of 31
11:51:14.25 process pointer page 10 of 31
11:51:14.75 process pointer page 11 of 31
11:51:15.25 process pointer page 12 of 31
11:51:15.73 process pointer page 13 of 31
11:51:16.21 process pointer page 14 of 31
11:51:16.65 process pointer page 15 of 31
11:51:17.06 process pointer page 16 of 31
11:51:17.48 process pointer page 17 of 31
11:51:17.88 process pointer page 18 of 31
11:51:18.30 process pointer page 19 of 31
11:51:18.74 process pointer page 20 of 31
11:51:19.16 process pointer page 21 of 31
11:51:19.58 process pointer page 22 of 31
11:51:20.05 process pointer page 23 of 31
11:51:20.49 process pointer page 24 of 31
11:51:20.96 process pointer page 25 of 31
11:51:21.36 process pointer page 26 of 31
11:51:21.80 process pointer page 27 of 31
11:51:22.22 process pointer page 28 of 31
11:51:22.63 process pointer page 29 of 31
11:51:23.05 process pointer page 30 of 31
11:51:23.13 Index 1 (XQS_2100_3300_DOC_ID)
11:51:25.03 Index 2 (XQS_2100_3300_SND_ID)
11:51:27.07 Index 3 (XQS_2100_3300_RCV_ID)
11:51:29.29 Relation 270 (XQS_2100_3300) is ok

11:51:29.29 Relation 271 (XQS_3300_3400)
11:51:29.29 process pointer page 0 of 6
11:51:29.80 process pointer page 1 of 6
11:51:30.30 process pointer page 2 of 6
11:51:30.75 process pointer page 3 of 6
11:51:31.24 process pointer page 4 of 6
11:51:31.75 process pointer page 5 of 6
11:51:31.91 Index 1 (XQS_3300_3400_DOC_ID)
11:51:32.25 Index 2 (XQS_3300_3400_SND_ID)
11:51:32.63 Relation 271 (XQS_3300_3400) is ok

11:51:32.63 Validation finished
Done for 98030 ms, from 11:49:54.75 to 11:51:32.78.

Differences between old and current firebird.log

11:51:34.36. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-06-13 11:51 477 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

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

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


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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2017-06-13 11:51:43.70 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html