Firebird 4.0 Performance Logs

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-07-08 11:20:30.43.
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.686 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-07-08 11:16:42.7850 -1 <null> ::1/51673 412030 9131 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: 5507.46 3731 991343 2017-07-08 08:16 2017-07-08 11:16
customer order: creation 426.55 566 76779 2017-07-08 08:16 2017-07-08 11:16
customer order: refuse 34.37 281 6186 2017-07-08 08:16 2017-07-08 11:16
order to supplier: creation 109.19 2471 19654 2017-07-08 08:16 2017-07-08 11:16
order to supplier: removal 2.69 26525 476 2017-07-08 08:16 2017-07-08 11:16
invoice (draft): creation 108.16 3539 19468 2017-07-08 08:16 2017-07-08 11:16
invoice (draft): removal 35.25 610 6310 2017-07-08 08:16 2017-07-08 11:16
invoice accept: apply 62.05 14975 11169 2017-07-08 08:16 2017-07-08 11:16
invoice accept: cancel 16.72 3537 3009 2017-07-08 08:16 2017-07-08 11:16
customer reserve: creation 3191.48 245 574467 2017-07-08 08:16 2017-07-08 11:16
customer reserve: removal 932.35 89 167823 2017-07-08 08:16 2017-07-08 11:16
realization accept: apply 199.71 550 35947 2017-07-08 08:16 2017-07-08 11:16
realization accept: cancel 83.47 185 15024 2017-07-08 08:16 2017-07-08 11:16
payment from customer: creation 143.32 992 25798 2017-07-08 08:16 2017-07-08 11:16
payment from customer: removal 13.54 149 2438 2017-07-08 08:16 2017-07-08 11:16
payment to supplier: creation 115.96 573 20873 2017-07-08 08:16 2017-07-08 11:16
payment to supplier: removal 8.17 171 1471 2017-07-08 08:16 2017-07-08 11:16
service: total inventory turnovers 7.92 3759 1425 2017-07-08 08:16 2017-07-08 11:16
service: total monetary turnovers 16.75 70 3015 2017-07-08 08:16 2017-07-08 11:16
service: refresh index statistics 0.07 11610 11 2017-07-08 08:16 2017-07-08 11:16
Done for 85990 ms, from 11:21:58.12 to 11:23:24.11.

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 4605 93908 82898 11010 11.72 08:16:43 08:34:43
interval # 2, overall 2 6072 118870 109291 9579 8.06 08:34:44 08:52:44
interval # 3, overall 3 5866 117123 105596 11527 9.84 08:52:45 09:10:45
interval # 4, overall 4 5278 109713 95003 14710 13.41 09:10:46 09:28:46
interval # 5, overall 5 5344 113769 96184 17585 15.46 09:28:47 09:46:47
interval # 6, overall 6 6092 126417 109647 16770 13.27 09:46:48 10:04:48
interval # 7, overall 7 5746 114426 103427 10999 9.61 10:04:49 10:22:49
interval # 8, overall 8 5817 117148 104700 12448 10.63 10:22:50 10:40:50
interval # 9, overall 9 5199 104455 93583 10872 10.41 10:40:51 10:58:51
interval # 10, overall 10 5056 99702 91014 8688 8.71 10:58:52 11:16:52
Done for 159590 ms, from 11:26:02.07 to 11:28:41.66.

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 2120.30 0.3306 1.7223 1915 100
TEST_TIME 2 2732.35 0.6690 1.5270 1846 100
TEST_TIME 3 3324.56 0.8371 1.1688 1484 100
TEST_TIME 4 3324.33 0.8769 1.1383 1416 100
TEST_TIME 5 3368.27 0.9019 1.1027 1756 100
TEST_TIME 6 3412.80 0.9072 1.0898 1706 100
TEST_TIME 7 3518.90 0.9062 1.0872 1751 100
TEST_TIME 8 3640.21 0.9197 1.1028 1699 100
TEST_TIME 9 3870.46 0.9219 1.0673 1440 100
TEST_TIME 10 3981.26 0.9340 1.0597 1733 100
TEST_TIME 11 4066.51 0.9447 1.0463 1551 100
TEST_TIME 12 4107.96 0.9494 1.0527 1508 100
TEST_TIME 13 4150.36 0.9618 1.0438 1519 100
TEST_TIME 14 4186.63 0.9609 1.0383 1573 100
TEST_TIME 15 4269.92 0.9502 1.0413 1859 100
TEST_TIME 16 4367.72 0.9544 1.0398 1554 100
TEST_TIME 17 4469.47 0.9566 1.0525 2095 100
TEST_TIME 18 4551.70 0.9761 1.0139 1564 100
TEST_TIME 19 4422.59 0.9886 1.0160 1016 86
TEST_TIME 20 4428.23 0.9640 1.0248 1168 100
TEST_TIME 21 4449.16 0.9726 1.0238 1813 100
TEST_TIME 22 4504.31 0.9653 1.0293 1541 100
TEST_TIME 23 4604.00 0.9633 1.0370 1616 100
TEST_TIME 24 4703.72 0.9727 1.0271 1367 100
TEST_TIME 25 4768.85 0.9726 1.0330 1440 100
TEST_TIME 26 4828.94 0.9809 1.0231 1365 100
TEST_TIME 27 4883.07 0.9743 1.0233 1412 100
TEST_TIME 28 4894.93 0.9844 1.0145 1328 100
TEST_TIME 29 4882.04 0.9821 1.0183 1259 100
TEST_TIME 30 4927.08 0.9754 1.0190 2161 100
TEST_TIME 31 4936.78 0.9842 1.0186 1852 97
TEST_TIME 32 5043.79 0.9766 1.0221 1647 100
TEST_TIME 33 5105.24 0.9792 1.0198 1717 100
TEST_TIME 34 5150.71 0.9811 1.0248 1774 100
TEST_TIME 35 5237.40 0.9799 1.0236 1573 100
TEST_TIME 36 5277.62 0.9876 1.0108 1604 100
TEST_TIME 37 5251.76 0.9883 1.0224 1214 99
TEST_TIME 38 5309.96 0.9850 1.0153 1427 100
TEST_TIME 39 5327.92 0.9859 1.0105 1422 100
TEST_TIME 40 5319.93 0.9929 1.0091 1421 99
TEST_TIME 41 5292.22 0.9896 1.0119 1353 96
TEST_TIME 42 5262.73 0.9934 1.0157 931 99
TEST_TIME 43 5267.80 0.9913 1.0081 1102 99
TEST_TIME 44 5261.89 0.9863 1.0072 1167 100
TEST_TIME 45 5272.60 0.9828 1.0146 2115 100
TEST_TIME 46 5305.05 0.9868 1.0107 2171 100
TEST_TIME 47 5303.31 0.9895 1.0108 2082 97
TEST_TIME 48 5336.05 0.9839 1.0138 1566 100
TEST_TIME 49 5385.78 0.9839 1.0172 1333 100
TEST_TIME 50 5397.07 0.9948 1.0080 1777 99
TEST_TIME 51 5388.17 0.9899 1.0100 1495 95
TEST_TIME 52 5393.96 0.9895 1.0087 1520 96
TEST_TIME 53 5462.54 0.9881 1.0101 1206 100
TEST_TIME 54 5480.28 0.9882 1.0095 1437 100
TEST_TIME 55 5471.38 0.9927 1.0100 1357 100
TEST_TIME 56 5455.02 0.9950 1.0053 1386 98
TEST_TIME 57 5424.68 0.9932 1.0071 1358 98
TEST_TIME 58 5419.93 0.9906 1.0087 900 100
TEST_TIME 59 5406.80 0.9941 1.0057 1282 100
TEST_TIME 60 5396.82 0.9907 1.0059 1672 100
TEST_TIME 61 5392.55 0.9902 1.0150 1657 96
TEST_TIME 62 5433.52 0.9917 1.0098 1753 100
TEST_TIME 63 5458.09 0.9895 1.0083 1699 100
TEST_TIME 64 5432.54 0.9973 1.0035 1287 82
TEST_TIME 65 5388.69 0.9961 1.0046 1227 72
TEST_TIME 66 5359.79 0.9948 1.0120 1154 90
TEST_TIME 67 5385.85 0.9921 1.0064 1678 99
TEST_TIME 68 5393.47 0.9902 1.0106 1432 99
TEST_TIME 69 5408.51 0.9932 1.0059 1415 99
TEST_TIME 70 5414.36 0.9905 1.0089 1138 100
TEST_TIME 71 5429.16 0.9920 1.0076 1280 100
TEST_TIME 72 5433.00 0.9932 1.0082 1340 100
TEST_TIME 73 5443.46 0.9926 1.0070 1187 100
TEST_TIME 74 5437.69 0.9945 1.0058 1213 100
TEST_TIME 75 5454.40 0.9894 1.0112 1757 100
TEST_TIME 76 5467.36 0.9955 1.0058 1987 100
TEST_TIME 77 5474.40 0.9916 1.0063 1752 95
TEST_TIME 78 5493.82 0.9934 1.0057 1482 100
TEST_TIME 79 5466.35 0.9980 1.0025 1253 80
TEST_TIME 80 5425.09 0.9975 1.0027 1030 67
TEST_TIME 81 5389.62 0.9968 1.0039 1073 71
TEST_TIME 82 5398.53 0.9900 1.0060 970 98
TEST_TIME 83 5391.23 0.9952 1.0051 1492 99
TEST_TIME 84 5368.13 0.9974 1.0082 1136 90
TEST_TIME 85 5389.96 0.9923 1.0047 1063 99
TEST_TIME 86 5391.75 0.9928 1.0066 1113 100
TEST_TIME 87 5395.64 0.9943 1.0061 1351 100
TEST_TIME 88 5393.75 0.9951 1.0048 1193 100
TEST_TIME 89 5390.78 0.9940 1.0078 1288 100
TEST_TIME 90 5404.69 0.9941 1.0051 1963 100
TEST_TIME 91 5397.75 0.9954 1.0084 1535 94
TEST_TIME 92 5432.42 0.9911 1.0079 1710 100
TEST_TIME 93 5457.12 0.9925 1.0069 1750 100
TEST_TIME 94 5478.93 0.9922 1.0062 1674 100
TEST_TIME 95 5508.42 0.9903 1.0034 1536 100
TEST_TIME 96 5509.26 0.9928 1.0053 1368 99
TEST_TIME 97 5501.12 0.9964 1.0036 1478 94
TEST_TIME 98 5501.19 0.9934 1.0042 1203 96
TEST_TIME 99 5487.09 0.9966 1.0088 1216 93
TEST_TIME 100 5502.88 0.9958 1.0023 1208 100
TEST_TIME 101 5490.32 0.9947 1.0040 1175 99
TEST_TIME 102 5499.02 0.9957 1.0054 1142 100
TEST_TIME 103 5499.51 0.9957 1.0043 1174 100
TEST_TIME 104 5494.23 0.9956 1.0057 991 99
TEST_TIME 105 5511.74 0.9930 1.0039 1655 100
TEST_TIME 106 5503.40 0.9960 1.0046 1805 94
TEST_TIME 107 5499.96 0.9958 1.0038 1490 94
TEST_TIME 108 5514.41 0.9963 1.0043 1747 100
TEST_TIME 109 5512.82 0.9954 1.0052 1402 92
TEST_TIME 110 5524.24 0.9940 1.0103 1184 96
TEST_TIME 111 5549.46 0.9966 1.0028 1521 97
TEST_TIME 112 5569.11 0.9903 1.0040 1147 99
TEST_TIME 113 5566.89 0.9956 1.0046 1340 100
TEST_TIME 114 5581.56 0.9932 1.0061 1324 100
TEST_TIME 115 5585.96 0.9965 1.0025 1426 100
TEST_TIME 116 5565.84 0.9974 1.0033 1332 92
TEST_TIME 117 5563.46 0.9951 1.0022 1235 98
TEST_TIME 118 5551.46 0.9959 1.0060 1191 93
TEST_TIME 119 5547.15 0.9983 1.0024 1097 88
TEST_TIME 120 5522.14 0.9984 1.0028 923 75
TEST_TIME 121 5512.25 0.9964 1.0057 1531 90
TEST_TIME 122 5528.26 0.9969 1.0048 1129 97
TEST_TIME 123 5529.51 0.9964 1.0049 1412 100
TEST_TIME 124 5541.93 0.9946 1.0029 1686 100
TEST_TIME 125 5533.59 0.9964 1.0053 1539 96
TEST_TIME 126 5548.13 0.9947 1.0045 1429 95
TEST_TIME 127 5553.00 0.9957 1.0020 1523 99
TEST_TIME 128 5541.37 0.9963 1.0045 1297 95
TEST_TIME 129 5548.14 0.9955 1.0034 1201 92
TEST_TIME 130 5557.42 0.9940 1.0040 1211 100
TEST_TIME 131 5557.63 0.9963 1.0019 1349 99
TEST_TIME 132 5569.93 0.9921 1.0040 1118 100
TEST_TIME 133 5564.88 0.9974 1.0050 1181 100
TEST_TIME 134 5570.10 0.9966 1.0040 1162 100
TEST_TIME 135 5571.37 0.9965 1.0036 1372 100
TEST_TIME 136 5574.74 0.9957 1.0030 1886 100
TEST_TIME 137 5578.51 0.9951 1.0037 1647 93
TEST_TIME 138 5583.58 0.9955 1.0040 1564 90
TEST_TIME 139 5591.67 0.9953 1.0029 1308 93
TEST_TIME 140 5592.43 0.9961 1.0018 1423 99
TEST_TIME 141 5582.60 0.9965 1.0025 1397 96
TEST_TIME 142 5586.50 0.9947 1.0023 1188 96
TEST_TIME 143 5590.81 0.9946 1.0040 1046 99
TEST_TIME 144 5588.18 0.9975 1.0023 1436 99
TEST_TIME 145 5576.88 0.9974 1.0033 1181 94
TEST_TIME 146 5579.17 0.9981 1.0013 1255 95
TEST_TIME 147 5563.92 0.9972 1.0038 1228 93
TEST_TIME 148 5557.34 0.9982 1.0014 1310 92
TEST_TIME 149 5540.23 0.9977 1.0020 1191 89
TEST_TIME 150 5550.40 0.9935 1.0021 1409 98
TEST_TIME 151 5542.41 0.9969 1.0033 1714 95
TEST_TIME 152 5543.87 0.9964 1.0034 1583 94
TEST_TIME 153 5555.06 0.9948 1.0037 1360 100
TEST_TIME 154 5554.52 0.9973 1.0020 1478 98
TEST_TIME 155 5551.98 0.9960 1.0034 1227 97
TEST_TIME 156 5546.77 0.9979 1.0032 1308 96
TEST_TIME 157 5541.27 0.9978 1.0038 1148 98
TEST_TIME 158 5550.43 0.9958 1.0027 1206 100
TEST_TIME 159 5547.67 0.9969 1.0023 1472 100
TEST_TIME 160 5547.69 0.9960 1.0014 1239 100
TEST_TIME 161 5534.81 0.9974 1.0031 1262 96
TEST_TIME 162 5527.35 0.9983 1.0047 1156 94
TEST_TIME 163 5530.51 0.9979 1.0021 1278 98
TEST_TIME 164 5525.63 0.9969 1.0017 1151 92
TEST_TIME 165 5528.68 0.9951 1.0023 1240 96
TEST_TIME 166 5525.96 0.9968 1.0041 1649 94
TEST_TIME 167 5539.96 0.9955 1.0030 1257 99
TEST_TIME 168 5538.78 0.9972 1.0031 1346 91
TEST_TIME 169 5543.01 0.9964 1.0029 1552 91
TEST_TIME 170 5542.59 0.9971 1.0029 1378 88
TEST_TIME 171 5547.53 0.9966 1.0015 1479 87
TEST_TIME 172 5542.70 0.9966 1.0020 1366 90
TEST_TIME 173 5532.75 0.9980 1.0021 1422 82
TEST_TIME 174 5528.31 0.9972 1.0020 1473 81
TEST_TIME 175 5523.77 0.9971 1.0014 1219 82
TEST_TIME 176 5521.91 0.9960 1.0031 866 92
TEST_TIME 177 5521.81 0.9974 1.0024 1198 91
TEST_TIME 178 5514.08 0.9982 1.0021 1130 87
TEST_TIME 179 5508.65 0.9975 1.0022 1153 88
TEST_TIME 180 5500.05 0.9982 1.0013 938 95
Done for 10920 ms, from 11:28:43.17 to 11:28:54.09.

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 61939 85668 53481 <null> 56416 133206 77719 89884 41808 110471 87054 32085 139316 95727 116299 90250 270812 535000 <null> 08:16:43 08:34:43
fetches per second 2 51906 117352 43679 <null> 43010 <null> 60687 4174 55424 88059 52594 1589 90071 2710 104743 <null> 75511 168879 <null> 08:34:44 08:52:44
fetches per second 3 23011 4558 9166 4973 19743 60428 43793 5118 82346 <null> 15864 43158 39560 169172 41608 2748 15130 <null> <null> 08:52:45 09:10:45
fetches per second 4 9058 22382 17046 <null> 11779 5552 25660 13855 14975 5495 11761 6025 25941 12634 32620 1756 62298 21122 <null> 09:10:46 09:28:46
fetches per second 5 22800 26763 11507 <null> 23280 <null> 25431 30947 2528 5873 32709 12506 17916 2103 33353 <null> 65553 937904 <null> 09:28:47 09:46:47
fetches per second 6 16320 16515 22873 <null> 22714 1658 28629 2646 1685 4976 23005 2363 24257 66147 26702 13168 <null> 49759 <null> 09:46:48 10:04:48
fetches per second 7 14093 35360 20507 <null> 5927 <null> 19332 <null> 2864 <null> 19779 2239 16287 94747 6607 <null> <null> 31912 <null> 10:04:49 10:22:49
fetches per second 8 5550 53485 13621 <null> 5513 11166 3744 3419 775 21934 18622 1444 4943 4895 28994 19716 <null> 57128 <null> 10:22:50 10:40:50
fetches per second 9 7686 4765 3193 15133 6064 <null> 16689 <null> 8812 3244 6133 1408 12850 1876 25231 2742 39384 292210 <null> 10:40:51 10:58:51
fetches per second 10 2735 4021 6992 <null> 4055 4897 5103 3849 3067 2051 2952 1490 11715 6361 4925 12649 <null> 126493 <null> 10:58:52 11:16:52
marks per second 1 14038 11949 12020 <null> 12511 29310 11043 18955 6391 19761 15466 5048 8245 19200 9716 13375 22515 45000 <null> 08:16:43 08:34:43
marks per second 2 11451 16036 9621 <null> 9428 <null> 9976 802 8662 16908 8694 262 6849 413 13348 <null> 8083 15905 <null> 08:34:44 08:52:44
marks per second 3 5093 645 1851 1062 4048 13114 6204 874 14115 <null> 1843 6962 2771 24340 4048 418 805 <null> <null> 08:52:45 09:10:45
marks per second 4 1958 2535 3114 <null> 2449 1274 3845 2889 2009 947 1364 1013 1712 1931 1831 341 4320 673 <null> 09:10:46 09:28:46
marks per second 5 4822 3518 2477 <null> 5164 <null> 3353 5440 405 1049 4863 2233 933 401 4346 <null> 8981 16887 <null> 09:28:47 09:46:47
marks per second 6 3513 2350 4454 <null> 4958 342 3464 432 161 852 3991 367 1435 10240 2882 2907 <null> 1085 <null> 09:46:48 10:04:48
marks per second 7 3016 5188 4160 <null> 1148 <null> 2835 <null> 314 <null> 2523 394 937 9633 1423 <null> <null> 603 <null> 10:04:49 10:22:49
marks per second 8 1197 7755 2526 <null> 1138 2455 562 563 100 4407 2298 212 237 789 3298 4413 <null> 1355 <null> 10:22:50 10:40:50
marks per second 9 1652 665 440 2883 1067 <null> 2030 <null> 730 529 1152 186 505 338 3371 578 379 46201 <null> 10:40:51 10:58:51
marks per second 10 593 543 716 <null> 405 1099 633 637 338 352 429 234 410 1079 493 1842 <null> 1632 <null> 10:58:52 11:16:52
reads/fetches*100 1 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 08:16:43 08:34:43
reads/fetches*100 2 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 08:34:44 08:52:44
reads/fetches*100 3 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 0 0 0 <null> <null> 08:52:45 09:10:45
reads/fetches*100 4 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 09:10:46 09:28:46
reads/fetches*100 5 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 09:28:47 09:46:47
reads/fetches*100 6 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 09:46:48 10:04:48
reads/fetches*100 7 0 0 0 <null> 0 <null> 0 <null> 0 <null> 0 0 0 0 0 <null> <null> 0 <null> 10:04:49 10:22:49
reads/fetches*100 8 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 10:22:50 10:40:50
reads/fetches*100 9 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 10:40:51 10:58:51
reads/fetches*100 10 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 10:58:52 11:16:52
writes/marks*100 1 0 0 0 <null> 0 0 0 0 0 1 0 0 0 0 0 0 1 0 <null> 08:16:43 08:34:43
writes/marks*100 2 0 2 0 <null> 0 <null> 0 0 1 1 0 0 0 0 0 <null> 0 0 <null> 08:34:44 08:52:44
writes/marks*100 3 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 0 0 2 <null> <null> 08:52:45 09:10:45
writes/marks*100 4 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 3 0 <null> 09:10:46 09:28:46
writes/marks*100 5 0 0 0 <null> 0 <null> 0 0 1 0 0 0 0 0 0 <null> 1 0 <null> 09:28:47 09:46:47
writes/marks*100 6 0 0 0 <null> 0 0 0 0 0 1 0 0 0 0 0 0 <null> 0 <null> 09:46:48 10:04:48
writes/marks*100 7 0 0 0 <null> 0 <null> 0 <null> 1 <null> 0 0 0 0 0 <null> <null> 0 <null> 10:04:49 10:22:49
writes/marks*100 8 0 0 0 <null> 0 0 0 0 4 0 0 0 1 0 0 0 <null> 0 <null> 10:22:50 10:40:50
writes/marks*100 9 1 1 0 0 0 <null> 0 <null> 1 0 0 0 0 1 0 0 4 0 <null> 10:40:51 10:58:51
writes/marks*100 10 1 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 <null> 0 <null> 10:58:52 11:16:52
Done for 9080 ms, from 11:28:55.22 to 11:29:04.30.

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 1725610 1611742 113868 6.59 0 14929 55 113868 2017-07-08 08:16 2017-07-08 11:16
doc_list_biud 1726011 1611742 114269 6.62 0 20779 21 114269 2017-07-08 08:16 2017-07-08 11:16
sp_add_invoice_to_stock 18398 11169 7229 39.29 15 207933 14975 7229 2017-07-08 08:16 2017-07-08 11:16
sp_cancel_adding_invoice 3887 3009 878 22.58 0 61605 3537 878 2017-07-08 08:16 2017-07-08 11:16
sp_cancel_client_order 6318 6186 132 2.08 0 3183 281 132 2017-07-08 08:16 2017-07-08 11:16
sp_cancel_customer_reserve 273594 167823 105771 38.65 0 14103 89 105771 2017-07-08 08:16 2017-07-08 11:16
sp_cancel_pay_from_customer 2450 2438 12 0.48 0 14944 149 12 2017-07-08 08:16 2017-07-08 11:16
sp_cancel_pay_to_supplier 1476 1471 5 0.33 0 3526 171 5 2017-07-08 08:16 2017-07-08 11:16
sp_cancel_supplier_invoice 8236 6310 1926 23.38 0 21232 610 1926 2017-07-08 08:16 2017-07-08 11:16
sp_cancel_supplier_order 1459 476 983 67.37 46 265590 26525 983 2017-07-08 08:16 2017-07-08 11:16
sp_cancel_write_off 21429 15024 6405 29.88 0 7504 185 6405 2017-07-08 08:16 2017-07-08 11:16
sp_client_order 76779 76779 0 0.00 0 28470 566 0 2017-07-08 08:16 2017-07-08 11:16
sp_customer_reserve 574467 574467 0 0.00 0 27987 245 0 2017-07-08 08:16 2017-07-08 11:16
sp_fill_shopping_cart 116168 115901 267 0.22 0 6319 113 0 2017-07-08 08:16 2017-07-08 11:16
sp_fill_shopping_cart_clo_res 574467 574467 0 0.00 0 8018 17 0 2017-07-08 08:16 2017-07-08 11:16
sp_get_clo_for_invoice 11169 11169 0 0.00 0 5569 377 0 2017-07-08 08:16 2017-07-08 11:16
sp_kill_cost_storno 28829 21942 6887 23.88 0 2792 20 6887 2017-07-08 08:16 2017-07-08 11:16
sp_kill_qstorno_ret_qs2qd 576527 357456 219071 37.99 0 20748 33 219071 2017-07-08 08:16 2017-07-08 11:16
sp_kill_qty_storno 360141 245944 114197 31.70 0 20779 96 114197 2017-07-08 08:16 2017-07-08 11:16
sp_lock_selected_doc 75690 65803 9887 13.06 0 6645 8 9887 2017-07-08 08:16 2017-07-08 11:16
sp_make_cost_storno 93787 93787 0 0.00 0 13073 409 0 2017-07-08 08:16 2017-07-08 11:16
sp_multiply_rows_for_pdistr 93787 93787 0 0.00 0 5959 60 0 2017-07-08 08:16 2017-07-08 11:16
sp_multiply_rows_for_qdistr 76779 76779 0 0.00 0 18002 190 0 2017-07-08 08:16 2017-07-08 11:16
sp_pay_from_customer 25798 25798 0 0.00 15 14352 992 0 2017-07-08 08:16 2017-07-08 11:16
sp_pay_to_supplier 20873 20873 0 0.00 0 13447 573 0 2017-07-08 08:16 2017-07-08 11:16
sp_payment_common 46671 46671 0 0.00 0 1887 68 0 2017-07-08 08:16 2017-07-08 11:16
sp_qd_handle_on_cancel_clo 6312 6186 126 1.99 0 2090 121 126 2017-07-08 08:16 2017-07-08 11:16
sp_qd_handle_on_invoice_upd_sts 14860 14178 682 4.58 0 5928 425 682 2017-07-08 08:16 2017-07-08 11:16
sp_qd_handle_on_reserve_upd_sts 35947 35947 0 0.00 0 2808 58 0 2017-07-08 08:16 2017-07-08 11:16
sp_reserve_write_off 36527 35947 580 1.58 0 9453 550 580 2017-07-08 08:16 2017-07-08 11:16
sp_supplier_invoice 19578 19468 110 0.56 0 27706 3539 0 2017-07-08 08:16 2017-07-08 11:16
sp_supplier_order 19811 19654 157 0.79 0 19141 2471 0 2017-07-08 08:16 2017-07-08 11:16
srv_find_qd_qs_mism 1017476 903553 113923 11.19 0 12885 33 113923 2017-07-08 08:16 2017-07-08 11:16
srv_make_invnt_saldo 1425 1425 0 0.00 31 36301 3759 0 2017-07-08 08:16 2017-07-08 11:16
srv_make_money_saldo 3015 3015 0 0.00 0 1685 70 0 2017-07-08 08:16 2017-07-08 11:16
srv_recalc_idx_stat 11 11 0 0.00 2574 33946 11610 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_add_invoice_to_stock 7229 7229 0 0.00 0 2137 103 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_cancel_adding_invoice 705 705 0 0.00 0 2667 222 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_cancel_client_order 132 132 0 0.00 0 1045 110 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_cancel_customer_reserve 34 34 0 0.00 0 1123 144 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_cancel_pay_from_customer 12 12 0 0.00 0 936 123 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_cancel_pay_to_supplier 5 5 0 0.00 47 421 227 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_cancel_supplier_invoice 628 628 0 0.00 0 1014 84 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_cancel_supplier_order 13107 13107 0 0.00 0 3463 152 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_cancel_write_off 36 36 0 0.00 0 889 84 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_reserve_write_off 580 580 0 0.00 0 2091 100 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_supplier_invoice 110 110 0 0.00 0 733 71 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-abend:sp_supplier_order 157 157 0 0.00 0 967 97 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_add_invoice_to_stock 11169 11169 0 0.00 0 20109 752 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_cancel_adding_invoice 1286 1286 0 0.00 0 8736 882 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_cancel_client_order 6186 6186 0 0.00 0 1903 70 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_cancel_customer_reserve 2455 2455 0 0.00 0 2371 72 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_cancel_pay_from_customer 2438 2438 0 0.00 0 1747 57 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_cancel_pay_to_supplier 1471 1471 0 0.00 0 1825 55 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_cancel_supplier_invoice 844 844 0 0.00 0 1435 70 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_cancel_supplier_order 476 476 0 0.00 0 40311 2218 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_cancel_write_off 3531 3531 0 0.00 0 2028 76 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_client_order 76779 76779 0 0.00 0 2527 84 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_customer_reserve 3519 3519 0 0.00 0 2777 58 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_pay_from_customer 25798 25798 0 0.00 0 2449 74 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_pay_to_supplier 20873 20873 0 0.00 0 2137 66 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_reserve_write_off 35947 35947 0 0.00 0 2808 75 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_supplier_invoice 19468 19468 0 0.00 0 2106 75 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:sp_supplier_order 19654 19654 0 0.00 0 2683 80 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:srv_make_invnt_saldo 1425 1425 0 0.00 0 858 32 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:srv_make_money_saldo 3015 3015 0 0.00 0 983 32 0 2017-07-08 08:16 2017-07-08 11:16
t$perf-norm:srv_recalc_idx_stat 11 11 0 0.00 0 156 35 0 2017-07-08 08:16 2017-07-08 11:16
v_add_invoice_to_stock 36796 22338 14458 39.29 0 6334 39 14458 2017-07-08 08:16 2017-07-08 11:16
v_all_customers 115516 115516 0 0.00 0 1435 7 0 2017-07-08 08:16 2017-07-08 11:16
v_all_suppliers 79096 78562 534 0.67 0 1139 6 0 2017-07-08 08:16 2017-07-08 11:16
v_all_wares 153558 153558 0 0.00 0 1420 5 0 2017-07-08 08:16 2017-07-08 11:16
v_cancel_adding_invoice 3068 2572 496 16.16 0 3572 174 496 2017-07-08 08:16 2017-07-08 11:16
v_cancel_client_order 12636 12372 264 2.08 0 1513 7 264 2017-07-08 08:16 2017-07-08 11:16
v_cancel_customer_prepayment 4900 4876 24 0.48 0 1466 10 24 2017-07-08 08:16 2017-07-08 11:16
v_cancel_customer_reserve 4978 4910 68 1.36 0 1280 10 68 2017-07-08 08:16 2017-07-08 11:16
v_cancel_payment_to_supplier 2952 2942 10 0.33 0 905 11 10 2017-07-08 08:16 2017-07-08 11:16
v_cancel_supplier_invoice 2944 1688 1256 42.66 0 1513 39 1256 2017-07-08 08:16 2017-07-08 11:16
v_cancel_supplier_order 2918 952 1966 67.37 0 702 12 1966 2017-07-08 08:16 2017-07-08 11:16
v_cancel_write_off 7134 7062 72 1.00 0 6147 125 72 2017-07-08 08:16 2017-07-08 11:16
v_max_id_clo_ord 19811 19654 157 0.79 0 1466 6 0 2017-07-08 08:16 2017-07-08 11:16
v_max_id_clo_res 3519 3519 0 0.00 0 811 19 0 2017-07-08 08:16 2017-07-08 11:16
v_max_id_ord_sup 19578 19468 110 0.56 0 921 6 0 2017-07-08 08:16 2017-07-08 11:16
v_max_non_paid_invoice 20714 20714 0 0.00 0 608 6 0 2017-07-08 08:16 2017-07-08 11:16
v_max_non_paid_realizn 25798 25798 0 0.00 0 889 7 0 2017-07-08 08:16 2017-07-08 11:16
v_min_id_clo_ord 19811 19654 157 0.79 0 2262 9 0 2017-07-08 08:16 2017-07-08 11:16
v_min_id_clo_res 3519 3519 0 0.00 0 1592 11 0 2017-07-08 08:16 2017-07-08 11:16
v_min_id_ord_sup 19578 19468 110 0.56 0 1841 10 0 2017-07-08 08:16 2017-07-08 11:16
v_min_non_paid_invoice 20873 20873 0 0.00 0 1701 8 0 2017-07-08 08:16 2017-07-08 11:16
v_min_non_paid_realizn 25798 25798 0 0.00 0 1372 7 0 2017-07-08 08:16 2017-07-08 11:16
v_our_firm 38042 38042 0 0.00 0 1233 7 0 2017-07-08 08:16 2017-07-08 11:16
v_reserve_write_off 73054 71894 1160 1.58 0 6505 10 1160 2017-07-08 08:16 2017-07-08 11:16
x_lock_depdocs_on_canc_invoice 15962 8475 7487 46.90 0 2465 43 7487 2017-07-08 08:16 2017-07-08 11:16
x_lock_depdocs_on_canc_sup_ord 1455 476 979 67.28 0 1357 78 979 2017-07-08 08:16 2017-07-08 11:16
x_make_qstorno_1000_1200 19811 19654 157 0.79 0 18627 2222 0 2017-07-08 08:16 2017-07-08 11:16
x_make_qstorno_1200_2000 19578 19468 110 0.56 0 27456 3286 0 2017-07-08 08:16 2017-07-08 11:16
x_make_qstorno_2100_3300 574467 574467 0 0.00 0 27862 208 0 2017-07-08 08:16 2017-07-08 11:16
Done for 306430 ms, from 11:34:09.62 to 11:39:16.05.

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 80 sp_kill_cost_storno 335544336 2017-07-08 08:17 2017-07-08 11:13
deadlock 79 sp_kill_qstorno_ret_qs2qd 335544336 2017-07-08 08:17 2017-07-08 11:15
deadlock 8533 sp_lock_selected_doc 335544336 2017-07-08 08:16 2017-07-08 11:16
deadlock 126 sp_qd_handle_on_cancel_clo 335544336 2017-07-08 08:17 2017-07-08 11:15
deadlock 153 sp_qd_handle_on_invoice_upd_sts 335544336 2017-07-08 08:17 2017-07-08 11:12
deadlock 639 x_lock_depdocs_on_canc_invoice 335544336 2017-07-08 08:16 2017-07-08 11:16
deadlock 271 x_lock_depdocs_on_canc_sup_ord 335544336 2017-07-08 08:29 2017-07-08 11:16
user_exc 157 x_make_qstorno_1000_1200 335544517 2017-07-08 08:19 2017-07-08 11:13
user_exc 110 x_make_qstorno_1200_2000 335544517 2017-07-08 08:17 2017-07-08 11:14
Done for 9390 ms, from 11:39:22.40 to 11:39:31.79.

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 413805
MON$OLDEST_ACTIVE 413806
MON$OLDEST_SNAPSHOT 413806
MON$NEXT_TRANSACTION 413806
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.686 Firebird 4.0 Alpha 1
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.686 Firebird 4.0 Alpha 1"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.686 Firebird 4.0 Alpha 1/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.686 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 413870
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 413807
Oldest active 413808
Oldest snapshot 413808
Next transaction 413809
Sequence number 0
Next attachment ID 9294
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.01, total records: 2066440
Average version length: 47.90, total versions: 4225, 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: 22456
Data pages: 22456, average fill: 72%
Primary pages: 22456, secondary pages: 0, swept pages: 13863
Empty pages: 1, full pages: 17752
Fill distribution:
0 - 19% = 2
20 - 39% = 16
40 - 59% = 132
60 - 79% = 22299
80 - 99% = 7

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 10005, nodes: 2066440
Average node length: 19.34, total dup: 0, max dup: 0
Average key length: 16.39, compression ratio: 1.65
Average prefix length: 13.61, average data length: 13.39
Clustering factor: 441120, ratio: 0.21
Fill distribution:
0 - 19% = 726
20 - 39% = 2048
40 - 59% = 4705
60 - 79% = 1198
80 - 99% = 1328

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7406, nodes: 2066440
Average node length: 11.65, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.30, average data length: 5.70
Clustering factor: 410368, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 3427
40 - 59% = 3932
60 - 79% = 42
80 - 99% = 5

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 174626, depth: 3, leaf buckets: 3589, nodes: 2066440
Average node length: 6.83, total dup: 1501563, max dup: 49
Average key length: 3.88, compression ratio: 2.32
Average prefix length: 7.39, average data length: 1.61
Clustering factor: 405364, ratio: 0.20
Fill distribution:
0 - 19% = 139
20 - 39% = 1035
40 - 59% = 1655
60 - 79% = 256
80 - 99% = 504

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.32, total records: 626773
Average version length: 61.25, total versions: 1006, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7976
Data pages: 7976, average fill: 75%
Primary pages: 7976, secondary pages: 0, swept pages: 7369
Empty pages: 0, full pages: 6916
Fill distribution:
0 - 19% = 3
20 - 39% = 9
40 - 59% = 56
60 - 79% = 7895
80 - 99% = 13

Index DOC_LIST_ID_DESC (1)
Root page: 251987, depth: 3, leaf buckets: 2318, nodes: 626773
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: 143179, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 1268
40 - 59% = 1027
60 - 79% = 22
80 - 99% = 1

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 658, nodes: 626773
Average node length: 4.87, total dup: 626723, max dup: 34465
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 283955, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 552
60 - 79% = 81
80 - 99% = 25

Index PK_DOC_LIST (0)
Root page: 327770, depth: 3, leaf buckets: 1908, nodes: 626773
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: 143179, ratio: 0.23
Fill distribution:
0 - 19% = 146
20 - 39% = 570
40 - 59% = 723
60 - 79% = 226
80 - 99% = 243

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: 64.10, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 16.68, total fragments: 368, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.62
Pointer pages: 1, data page slots: 248
Data pages: 20, average fill: 31%
Primary pages: 4, secondary pages: 16, swept pages: 4
Empty pages: 6, full pages: 3
Fill distribution:
0 - 19% = 10
20 - 39% = 5
40 - 59% = 1
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: 60.86, total records: 3149
Average version length: 71.30, total versions: 458, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.58
Pointer pages: 2, data page slots: 2280
Data pages: 280, average fill: 14%
Primary pages: 280, secondary pages: 0, swept pages: 224
Empty pages: 91, full pages: 9
Fill distribution:
0 - 19% = 212
20 - 39% = 28
40 - 59% = 29
60 - 79% = 6
80 - 99% = 5

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 16, nodes: 3149
Average node length: 16.18, total dup: 36, max dup: 1
Average key length: 13.86, compression ratio: 1.95
Average prefix length: 16.12, average data length: 10.88
Clustering factor: 2738, ratio: 0.87
Fill distribution:
0 - 19% = 1
20 - 39% = 11
40 - 59% = 2
60 - 79% = 0
80 - 99% = 2

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: 7.88, total records: 249
Average version length: 45.44, total versions: 207, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 8.12
Pointer pages: 1, data page slots: 48
Data pages: 40, average fill: 7%
Primary pages: 38, secondary pages: 2, swept pages: 32
Empty pages: 30, full pages: 2
Fill distribution:
0 - 19% = 36
20 - 39% = 1
40 - 59% = 1
60 - 79% = 2
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 320201, depth: 2, leaf buckets: 1, nodes: 249
Average node length: 7.17, total dup: 188, max dup: 40
Average key length: 5.48, compression ratio: 3.47
Average prefix length: 15.76, average data length: 3.24
Clustering factor: 124, ratio: 0.50
Fill distribution:
0 - 19% = 0
20 - 39% = 1
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: 19.24, total records: 814118
Average version length: 42.59, total versions: 2577, max versions: 6
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.33
Pointer pages: 4, data page slots: 5048
Data pages: 5048, average fill: 72%
Primary pages: 5043, secondary pages: 5, swept pages: 4451
Empty pages: 11, full pages: 3958
Fill distribution:
0 - 19% = 23
20 - 39% = 76
40 - 59% = 230
60 - 79% = 4332
80 - 99% = 387

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 275, nodes: 251719
Average node length: 4.89, total dup: 251670, max dup: 13777
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 34488, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 22
40 - 59% = 187
60 - 79% = 53
80 - 99% = 13

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 295, nodes: 251719
Average node length: 5.83, total dup: 227106, max dup: 39
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 38574, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 21
40 - 59% = 130
60 - 79% = 99
80 - 99% = 44

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 288, nodes: 251719
Average node length: 5.83, total dup: 227106, max dup: 39
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 38611, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 23
40 - 59% = 102
60 - 79% = 102
80 - 99% = 60

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 298, nodes: 251719
Average node length: 5.62, total dup: 227106, max dup: 39
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 38602, ratio: 0.15
Fill distribution:
0 - 19% = 3
20 - 39% = 27
40 - 59% = 140
60 - 79% = 90
80 - 99% = 38

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 67465, depth: 2, leaf buckets: 203, nodes: 254990
Average node length: 4.50, total dup: 254809, max dup: 2170
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 32589, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 71
60 - 79% = 74
80 - 99% = 58

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.53, total records: 10691743
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.19
Pointer pages: 156, data page slots: 253384
Data pages: 253384, average fill: 87%
Primary pages: 253384, secondary pages: 0, swept pages: 3
Empty pages: 5, full pages: 253378
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 253378

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 12000, nodes: 10691743
Average node length: 5.64, total dup: 9808284, max dup: 154
Average key length: 2.20, compression ratio: 3.63
Average prefix length: 7.85, average data length: 0.15
Clustering factor: 4316713, ratio: 0.40
Fill distribution:
0 - 19% = 14
20 - 39% = 0
40 - 59% = 6637
60 - 79% = 3592
80 - 99% = 1757

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

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 12804, nodes: 10691743
Average node length: 5.68, total dup: 10342401, max dup: 17459
Average key length: 2.24, compression ratio: 4.01
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 931661, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 9240
60 - 79% = 1945
80 - 99% = 1617

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 12836, nodes: 10691743
Average node length: 5.51, total dup: 10661810, max dup: 1344564
Average key length: 2.07, compression ratio: 18.20
Average prefix length: 37.69, average data length: 0.07
Clustering factor: 6316111, ratio: 0.59
Fill distribution:
0 - 19% = 13
20 - 39% = 4
40 - 59% = 10915
60 - 79% = 637
80 - 99% = 1267

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: 54.96, total records: 386615
Average version length: 55.91, total versions: 864, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 3, data page slots: 4624
Data pages: 4624, average fill: 74%
Primary pages: 4624, secondary pages: 0, swept pages: 3213
Empty pages: 0, full pages: 4022
Fill distribution:
0 - 19% = 7
20 - 39% = 8
40 - 59% = 36
60 - 79% = 4570
80 - 99% = 3

Index PSTORNED_RCV_ID (2)
Root page: 793552, depth: 3, leaf buckets: 510, nodes: 386615
Average node length: 5.96, total dup: 322814, max dup: 363
Average key length: 3.20, compression ratio: 2.81
Average prefix length: 7.96, average data length: 1.04
Clustering factor: 46946, ratio: 0.12
Fill distribution:
0 - 19% = 9
20 - 39% = 28
40 - 59% = 312
60 - 79% = 119
80 - 99% = 42

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 409, nodes: 386615
Average node length: 5.59, total dup: 343642, max dup: 75
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 91660, ratio: 0.24
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 162
60 - 79% = 163
80 - 99% = 79

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.82, total records: 2315
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.50
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 66%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 27
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 28
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: 48.96, total records: 7141
Average version length: 72.11, total versions: 2300, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.78
Pointer pages: 2, data page slots: 1864
Data pages: 504, average fill: 18%
Primary pages: 501, secondary pages: 3, swept pages: 373
Empty pages: 240, full pages: 40
Fill distribution:
0 - 19% = 350
20 - 39% = 59
40 - 59% = 41
60 - 79% = 48
80 - 99% = 6

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 16, nodes: 7141
Average node length: 6.75, total dup: 6177, max dup: 14
Average key length: 4.57, compression ratio: 8.10
Average prefix length: 34.57, average data length: 2.43
Clustering factor: 1127, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 5
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.28, total records: 1104860
Average version length: 72.01, total versions: 13889, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.91
Pointer pages: 11, data page slots: 17128
Data pages: 17120, average fill: 71%
Primary pages: 17120, secondary pages: 0, swept pages: 10908
Empty pages: 99, full pages: 12081
Fill distribution:
0 - 19% = 296
20 - 39% = 412
40 - 59% = 1252
60 - 79% = 15015
80 - 99% = 145

Index XQD_1000_3300_DOC (1)
Root page: 401180, depth: 3, leaf buckets: 1296, nodes: 1104860
Average node length: 5.13, total dup: 1076121, max dup: 122
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.83, average data length: 0.17
Clustering factor: 126637, ratio: 0.11
Fill distribution:
0 - 19% = 14
20 - 39% = 100
40 - 59% = 984
60 - 79% = 45
80 - 99% = 153

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 235847, depth: 3, leaf buckets: 1615, nodes: 1104860
Average node length: 6.25, total dup: 964776, max dup: 23
Average key length: 3.32, compression ratio: 11.15
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 212539, ratio: 0.19
Fill distribution:
0 - 19% = 17
20 - 39% = 194
40 - 59% = 1154
60 - 79% = 163
80 - 99% = 87

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 13.45, total records: 76161
Average version length: 71.99, total versions: 6345, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 10.12
Pointer pages: 4, data page slots: 5568
Data pages: 4552, average fill: 9%
Primary pages: 4550, secondary pages: 2, swept pages: 4110
Empty pages: 1396, full pages: 80
Fill distribution:
0 - 19% = 3973
20 - 39% = 360
40 - 59% = 108
60 - 79% = 73
80 - 99% = 38

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 26, nodes: 12607
Average node length: 6.72, total dup: 11104, max dup: 48
Average key length: 3.97, compression ratio: 9.32
Average prefix length: 35.15, average data length: 1.85
Clustering factor: 1534, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 13
40 - 59% = 9
60 - 79% = 3
80 - 99% = 1

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 53.78, total records: 2091684
Average version length: 71.81, total versions: 54843, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.53
Pointer pages: 18, data page slots: 29000
Data pages: 28984, average fill: 65%
Primary pages: 28984, secondary pages: 0, swept pages: 16350
Empty pages: 268, full pages: 19318
Fill distribution:
0 - 19% = 666
20 - 39% = 3383
40 - 59% = 3927
60 - 79% = 18560
80 - 99% = 2448

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 191369, depth: 3, leaf buckets: 2485, nodes: 1544662
Average node length: 5.66, total dup: 1446918, max dup: 89
Average key length: 2.69, compression ratio: 13.75
Average prefix length: 36.37, average data length: 0.63
Clustering factor: 216977, ratio: 0.14
Fill distribution:
0 - 19% = 18
20 - 39% = 1130
40 - 59% = 984
60 - 79% = 229
80 - 99% = 124

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: 3494279
Average version length: 69.42, total versions: 1605, 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: 21952
Data pages: 21928, average fill: 51%
Primary pages: 21927, secondary pages: 1, swept pages: 8490
Empty pages: 56, full pages: 20595
Fill distribution:
0 - 19% = 418
20 - 39% = 6600
40 - 59% = 5331
60 - 79% = 9517
80 - 99% = 62

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 11, nodes: 2922
Average node length: 10.54, total dup: 2092, max dup: 22
Average key length: 7.54, compression ratio: 4.91
Average prefix length: 31.74, average data length: 5.26
Clustering factor: 622, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 8
40 - 59% = 3
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.39, total records: 3090524
Average version length: 71.36, total versions: 21157, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.18
Pointer pages: 25, data page slots: 40576
Data pages: 40576, average fill: 75%
Primary pages: 40576, secondary pages: 0, swept pages: 29605
Empty pages: 35, full pages: 34193
Fill distribution:
0 - 19% = 67
20 - 39% = 345
40 - 59% = 1472
60 - 79% = 36370
80 - 99% = 2322

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5478, nodes: 2666622
Average node length: 6.87, total dup: 2163086, max dup: 14
Average key length: 3.89, compression ratio: 9.50
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 511711, ratio: 0.19
Fill distribution:
0 - 19% = 8
20 - 39% = 2865
40 - 59% = 2185
60 - 79% = 270
80 - 99% = 150

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.59, total records: 4495578
Average version length: 84.69, total versions: 2206, 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: 69128
Data pages: 69128, average fill: 80%
Primary pages: 69128, secondary pages: 0, swept pages: 25943
Empty pages: 7, full pages: 68350
Fill distribution:
0 - 19% = 16
20 - 39% = 16
40 - 59% = 40
60 - 79% = 20594
80 - 99% = 48462

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4576, nodes: 4495578
Average node length: 5.15, total dup: 4393070, max dup: 130
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 722365, ratio: 0.16
Fill distribution:
0 - 19% = 16
20 - 39% = 73
40 - 59% = 2044
60 - 79% = 1853
80 - 99% = 590

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 4965, nodes: 4495578
Average node length: 5.70, total dup: 4024530, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 246558, ratio: 0.05
Fill distribution:
0 - 19% = 47
20 - 39% = 141
40 - 59% = 2889
60 - 79% = 267
80 - 99% = 1621

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5128, nodes: 4495578
Average node length: 5.81, total dup: 3933094, max dup: 29
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 776470, ratio: 0.17
Fill distribution:
0 - 19% = 33
20 - 39% = 95
40 - 59% = 2302
60 - 79% = 1888
80 - 99% = 810

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 82.70, total records: 2296945
Average version length: 83.94, total versions: 12286, 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: 23, data page slots: 36336
Data pages: 36336, average fill: 78%
Primary pages: 36336, secondary pages: 0, swept pages: 26939
Empty pages: 35, full pages: 32660
Fill distribution:
0 - 19% = 96
20 - 39% = 147
40 - 59% = 676
60 - 79% = 16713
80 - 99% = 18704

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2480, nodes: 2296945
Average node length: 5.15, total dup: 2243199, max dup: 168
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 362228, ratio: 0.16
Fill distribution:
0 - 19% = 3
20 - 39% = 51
40 - 59% = 1484
60 - 79% = 724
80 - 99% = 218

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4004, nodes: 2296945
Average node length: 6.23, total dup: 1884075, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 231000, ratio: 0.10
Fill distribution:
0 - 19% = 108
20 - 39% = 1688
40 - 59% = 1571
60 - 79% = 427
80 - 99% = 210

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 2813, nodes: 2296945
Average node length: 5.81, total dup: 2009144, max dup: 29
Average key length: 2.84, compression ratio: 3.16
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 433280, ratio: 0.19
Fill distribution:
0 - 19% = 12
20 - 39% = 45
40 - 59% = 1712
60 - 79% = 807
80 - 99% = 237

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.36, total records: 4776546
Average version length: 85.67, total versions: 22560, 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: 74840
Data pages: 74816, average fill: 79%
Primary pages: 74816, secondary pages: 0, swept pages: 22257
Empty pages: 261, full pages: 70024
Fill distribution:
0 - 19% = 389
20 - 39% = 463
40 - 59% = 1434
60 - 79% = 17262
80 - 99% = 55268

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5098, nodes: 4776546
Average node length: 5.04, total dup: 4748564, max dup: 667
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 706614, ratio: 0.15
Fill distribution:
0 - 19% = 7
20 - 39% = 274
40 - 59% = 2898
60 - 79% = 1439
80 - 99% = 480

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 5870, nodes: 4776546
Average node length: 5.54, total dup: 4388800, max dup: 49
Average key length: 2.56, compression ratio: 3.52
Average prefix length: 8.52, average data length: 0.48
Clustering factor: 286391, ratio: 0.06
Fill distribution:
0 - 19% = 92
20 - 39% = 1450
40 - 59% = 2583
60 - 79% = 517
80 - 99% = 1228

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5711, nodes: 4776546
Average node length: 5.68, total dup: 4286517, max dup: 89
Average key length: 2.70, compression ratio: 3.34
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 788132, ratio: 0.17
Fill distribution:
0 - 19% = 6
20 - 39% = 228
40 - 59% = 3286
60 - 79% = 1624
80 - 99% = 567

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: 3277382
Average version length: 84.25, total versions: 14532, 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: 32, data page slots: 51880
Data pages: 51880, average fill: 78%
Primary pages: 51880, secondary pages: 0, swept pages: 37773
Empty pages: 35, full pages: 46759
Fill distribution:
0 - 19% = 99
20 - 39% = 193
40 - 59% = 926
60 - 79% = 22976
80 - 99% = 27686

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3548, nodes: 3277382
Average node length: 5.03, total dup: 3260823, max dup: 1119
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 712049, ratio: 0.22
Fill distribution:
0 - 19% = 24
20 - 39% = 316
40 - 59% = 1939
60 - 79% = 871
80 - 99% = 398

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 5845, nodes: 3277382
Average node length: 6.24, total dup: 2684742, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 375556, ratio: 0.11
Fill distribution:
0 - 19% = 217
20 - 39% = 2586
40 - 59% = 2173
60 - 79% = 548
80 - 99% = 321

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 3844, nodes: 3277382
Average node length: 5.60, total dup: 2983340, max dup: 86
Average key length: 2.62, compression ratio: 3.43
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 751076, ratio: 0.23
Fill distribution:
0 - 19% = 14
20 - 39% = 304
40 - 59% = 1928
60 - 79% = 1098
80 - 99% = 500

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.22, total records: 619649
Average version length: 69.73, total versions: 2264, 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: 8576
Data pages: 8576, average fill: 77%
Primary pages: 8576, secondary pages: 0, swept pages: 6195
Empty pages: 6, full pages: 8088
Fill distribution:
0 - 19% = 15
20 - 39% = 33
40 - 59% = 98
60 - 79% = 8372
80 - 99% = 58

Index XQS_3300_3400_DOC_ID (0)
Root page: 206394, depth: 3, leaf buckets: 754, nodes: 619649
Average node length: 5.32, total dup: 583171, max dup: 119
Average key length: 2.45, compression ratio: 3.67
Average prefix length: 8.61, average data length: 0.39
Clustering factor: 53172, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 178
40 - 59% = 315
60 - 79% = 184
80 - 99% = 74

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 839, nodes: 619649
Average node length: 5.93, total dup: 528758, max dup: 27
Average key length: 3.06, compression ratio: 2.94
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 56733, ratio: 0.09
Fill distribution:
0 - 19% = 4
20 - 39% = 196
40 - 59% = 355
60 - 79% = 193
80 - 99% = 91

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 148820 ms, from 11:39:32.28 to 11:42:01.10.

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 2066440 4225 0.2044
DOC_LIST 626773 1006 0.1605
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 3149 458 14.5442
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 249 207 83.1325
OPTYPES 9 0 0.0000
PDISTR 814118 2577 0.3165
PERF_ESTIMATED 254990 0 0.0000
PERF_LOG 10691743 0 0.0000
PSTORNED 386615 864 0.2234
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 2315 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 7141 2300 32.2083
XQD_1000_3300 1104860 13889 1.2570
XQD_1200_2000 76161 6345 8.3310
XQD_2000_3300 2091684 54843 2.6219
XQD_2100_3300 3494279 1605 0.0459
XQD_3300_3400 3090524 21157 0.6845
XQS_1000_1200 4495578 2206 0.0490
XQS_1000_3300 2296945 12286 0.5348
XQS_1200_2000 4776546 22560 0.4723
XQS_2100_3300 3277382 14532 0.4434
XQS_3300_3400 619649 2264 0.3653
Z_USED_VIEWS 29 0 0.0000
Done for 1970 ms, from 11:42:11.97 to 11:42:13.94.

Database validation

11:42:14.10 Validation started

11:42:14.13 Relation 140 (DOC_LIST)
11:42:14.13 process pointer page 0 of 5
11:42:14.22 process pointer page 1 of 5
11:42:14.33 process pointer page 2 of 5
11:42:14.39 process pointer page 3 of 5
11:42:14.44 process pointer page 4 of 5
11:42:14.47 Index 1 (PK_DOC_LIST)
11:42:14.56 Index 2 (DOC_LIST_ID_DESC)
11:42:14.77 Index 3 (FK_DOC_LIST_AGENTS)
11:42:14.92 Relation 140 (DOC_LIST) is ok

11:42:14.92 Relation 141 (DOC_DATA)
11:42:14.92 process pointer page 0 of 14
11:42:14.97 process pointer page 1 of 14
11:42:15.02 process pointer page 2 of 14
11:42:15.06 process pointer page 3 of 14
11:42:15.16 process pointer page 4 of 14
11:42:15.22 process pointer page 5 of 14
11:42:15.27 process pointer page 6 of 14
11:42:15.36 process pointer page 7 of 14
11:42:15.45 process pointer page 8 of 14
11:42:15.55 process pointer page 9 of 14
11:42:15.64 process pointer page 10 of 14
11:42:15.67 process pointer page 11 of 14
11:42:15.72 process pointer page 12 of 14
11:42:15.75 process pointer page 13 of 14
11:42:15.78 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:42:16.40 Index 3 (DOC_DATA_ID_DESC)
11:42:17.12 Index 4 (FK_DOC_DATA_DOC_LIST)
11:42:17.67 Relation 141 (DOC_DATA) is ok

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

11:42:17.67 Relation 150 (PDISTR)
11:42:17.67 process pointer page 0 of 4
11:42:17.75 process pointer page 1 of 4
11:42:17.84 process pointer page 2 of 4
11:42:17.90 process pointer page 3 of 4
11:42:17.92 Index 2 (PDISTR_SND_ID)
11:42:17.95 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:42:17.98 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:42:18.01 Index 5 (PDISTR_AGENT_ID)
11:42:18.04 Relation 150 (PDISTR) is ok

11:42:18.04 Relation 151 (PSTORNED)
11:42:18.04 process pointer page 0 of 3
11:42:18.09 process pointer page 1 of 3
11:42:18.12 process pointer page 2 of 3
11:42:18.14 Index 2 (PSTORNED_SND_ID)
11:42:18.18 Index 3 (PSTORNED_RCV_ID)
11:42:18.28 Relation 151 (PSTORNED) is ok

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

11:42:18.28 Relation 157 (INVNT_TURNOVER_LOG)
11:42:18.28 process pointer page 0 of 2
11:42:18.28 process pointer page 1 of 2
11:42:18.29 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:42:18.29 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:42:18.29 Relation 160 (PERF_ESTIMATED)
11:42:18.29 process pointer page 0 of 2
11:42:18.39 process pointer page 1 of 2
11:42:18.42 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:42:18.48 Relation 160 (PERF_ESTIMATED) is ok

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

11:42:18.48 Relation 162 (TRACE_STAT)
11:42:18.48 process pointer page 0 of 1
11:42:18.49 Relation 162 (TRACE_STAT) is ok

11:42:18.49 Relation 163 (PERF_LOG)
11:42:18.49 process pointer page 0 of 156
11:42:18.57 process pointer page 1 of 156
11:42:18.65 process pointer page 2 of 156
11:42:18.68 process pointer page 3 of 156
11:42:18.71 process pointer page 4 of 156
11:42:18.76 process pointer page 5 of 156
11:42:18.79 process pointer page 6 of 156
11:42:18.82 process pointer page 7 of 156
11:42:18.85 process pointer page 8 of 156
11:42:18.88 process pointer page 9 of 156
11:42:18.92 process pointer page 10 of 156
11:42:18.93 process pointer page 11 of 156
11:42:18.96 process pointer page 12 of 156
11:42:18.99 process pointer page 13 of 156
11:42:19.01 process pointer page 14 of 156
11:42:19.04 process pointer page 15 of 156
11:42:19.07 process pointer page 16 of 156
11:42:19.09 process pointer page 17 of 156
11:42:19.12 process pointer page 18 of 156
11:42:19.15 process pointer page 19 of 156
11:42:19.18 process pointer page 20 of 156
11:42:19.20 process pointer page 21 of 156
11:42:19.23 process pointer page 22 of 156
11:42:19.24 process pointer page 23 of 156
11:42:19.27 process pointer page 24 of 156
11:42:19.31 process pointer page 25 of 156
11:42:19.32 process pointer page 26 of 156
11:42:19.35 process pointer page 27 of 156
11:42:19.37 process pointer page 28 of 156
11:42:19.40 process pointer page 29 of 156
11:42:19.43 process pointer page 30 of 156
11:42:19.45 process pointer page 31 of 156
11:42:19.48 process pointer page 32 of 156
11:42:19.51 process pointer page 33 of 156
11:42:19.54 process pointer page 34 of 156
11:42:19.57 process pointer page 35 of 156
11:42:19.59 process pointer page 36 of 156
11:42:19.62 process pointer page 37 of 156
11:42:19.63 process pointer page 38 of 156
11:42:19.66 process pointer page 39 of 156
11:42:19.68 process pointer page 40 of 156
11:42:19.71 process pointer page 41 of 156
11:42:19.74 process pointer page 42 of 156
11:42:19.80 process pointer page 43 of 156
11:42:19.87 process pointer page 44 of 156
11:42:19.90 process pointer page 45 of 156
11:42:19.99 process pointer page 46 of 156
11:42:20.02 process pointer page 47 of 156
11:42:20.05 process pointer page 48 of 156
11:42:20.09 process pointer page 49 of 156
11:42:20.12 process pointer page 50 of 156
11:42:20.15 process pointer page 51 of 156
11:42:20.18 process pointer page 52 of 156
11:42:20.21 process pointer page 53 of 156
11:42:20.24 process pointer page 54 of 156
11:42:20.27 process pointer page 55 of 156
11:42:20.29 process pointer page 56 of 156
11:42:20.32 process pointer page 57 of 156
11:42:20.35 process pointer page 58 of 156
11:42:20.38 process pointer page 59 of 156
11:42:20.40 process pointer page 60 of 156
11:42:20.44 process pointer page 61 of 156
11:42:20.49 process pointer page 62 of 156
11:42:20.55 process pointer page 63 of 156
11:42:20.58 process pointer page 64 of 156
11:42:20.66 process pointer page 65 of 156
11:42:20.74 process pointer page 66 of 156
11:42:20.83 process pointer page 67 of 156
11:42:20.91 process pointer page 68 of 156
11:42:20.99 process pointer page 69 of 156
11:42:21.02 process pointer page 70 of 156
11:42:21.05 process pointer page 71 of 156
11:42:21.10 process pointer page 72 of 156
11:42:21.13 process pointer page 73 of 156
11:42:21.16 process pointer page 74 of 156
11:42:21.18 process pointer page 75 of 156
11:42:21.21 process pointer page 76 of 156
11:42:21.24 process pointer page 77 of 156
11:42:21.27 process pointer page 78 of 156
11:42:21.29 process pointer page 79 of 156
11:42:21.32 process pointer page 80 of 156
11:42:21.35 process pointer page 81 of 156
11:42:21.36 process pointer page 82 of 156
11:42:21.40 process pointer page 83 of 156
11:42:21.43 process pointer page 84 of 156
11:42:21.51 process pointer page 85 of 156
11:42:21.54 process pointer page 86 of 156
11:42:21.57 process pointer page 87 of 156
11:42:21.60 process pointer page 88 of 156
11:42:21.63 process pointer page 89 of 156
11:42:21.66 process pointer page 90 of 156
11:42:21.69 process pointer page 91 of 156
11:42:21.77 process pointer page 92 of 156
11:42:21.85 process pointer page 93 of 156
11:42:21.94 process pointer page 94 of 156
11:42:22.02 process pointer page 95 of 156
11:42:22.07 process pointer page 96 of 156
11:42:22.10 process pointer page 97 of 156
11:42:22.16 process pointer page 98 of 156
11:42:22.19 process pointer page 99 of 156
11:42:22.22 process pointer page 100 of 156
11:42:22.27 process pointer page 101 of 156
11:42:22.35 process pointer page 102 of 156
11:42:22.43 process pointer page 103 of 156
11:42:22.52 process pointer page 104 of 156
11:42:22.57 process pointer page 105 of 156
11:42:22.60 process pointer page 106 of 156
11:42:22.63 process pointer page 107 of 156
11:42:22.68 process pointer page 108 of 156
11:42:22.75 process pointer page 109 of 156
11:42:22.83 process pointer page 110 of 156
11:42:22.91 process pointer page 111 of 156
11:42:22.97 process pointer page 112 of 156
11:42:23.00 process pointer page 113 of 156
11:42:23.03 process pointer page 114 of 156
11:42:23.07 process pointer page 115 of 156
11:42:23.10 process pointer page 116 of 156
11:42:23.17 process pointer page 117 of 156
11:42:23.25 process pointer page 118 of 156
11:42:23.33 process pointer page 119 of 156
11:42:23.41 process pointer page 120 of 156
11:42:23.49 process pointer page 121 of 156
11:42:23.56 process pointer page 122 of 156
11:42:23.66 process pointer page 123 of 156
11:42:23.74 process pointer page 124 of 156
11:42:23.81 process pointer page 125 of 156
11:42:23.89 process pointer page 126 of 156
11:42:23.95 process pointer page 127 of 156
11:42:23.99 process pointer page 128 of 156
11:42:24.06 process pointer page 129 of 156
11:42:24.16 process pointer page 130 of 156
11:42:24.24 process pointer page 131 of 156
11:42:24.31 process pointer page 132 of 156
11:42:24.39 process pointer page 133 of 156
11:42:24.48 process pointer page 134 of 156
11:42:24.56 process pointer page 135 of 156
11:42:24.64 process pointer page 136 of 156
11:42:24.67 process pointer page 137 of 156
11:42:24.73 process pointer page 138 of 156
11:42:24.81 process pointer page 139 of 156
11:42:24.91 process pointer page 140 of 156
11:42:24.98 process pointer page 141 of 156
11:42:25.02 process pointer page 142 of 156
11:42:25.05 process pointer page 143 of 156
11:42:25.08 process pointer page 144 of 156
11:42:25.14 process pointer page 145 of 156
11:42:25.20 process pointer page 146 of 156
11:42:25.23 process pointer page 147 of 156
11:42:25.26 process pointer page 148 of 156
11:42:25.30 process pointer page 149 of 156
11:42:25.34 process pointer page 150 of 156
11:42:25.36 process pointer page 151 of 156
11:42:25.39 process pointer page 152 of 156
11:42:25.42 process pointer page 153 of 156
11:42:25.45 process pointer page 154 of 156
11:42:25.55 process pointer page 155 of 156
11:42:25.56 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:42:28.26 Index 2 (PERF_LOG_UNIT)
11:42:31.54 Index 3 (PERF_LOG_TRN_DESC)
11:42:33.58 Index 4 (PERF_LOG_GDSCODE)
11:42:34.52 Relation 163 (PERF_LOG) is ok

11:42:34.52 Relation 167 (V_STOPTEST)
11:42:34.52 Relation 167 (V_STOPTEST) is ok

11:42:34.52 Relation 184 (V_QDISTR_SOURCE)
11:42:34.52 Relation 184 (V_QDISTR_SOURCE) is ok

11:42:34.52 Relation 185 (V_QSTORNED_SOURCE)
11:42:34.52 Relation 185 (V_QSTORNED_SOURCE) is ok

11:42:34.52 Relation 260 (XQD_1000_1200)
11:42:34.52 process pointer page 0 of 2
11:42:34.52 process pointer page 1 of 2
11:42:34.52 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:42:34.53 Relation 260 (XQD_1000_1200) is ok

11:42:34.53 Relation 261 (XQD_1200_2000)
11:42:34.53 process pointer page 0 of 4
11:42:34.55 process pointer page 1 of 4
11:42:34.56 process pointer page 2 of 4
11:42:34.58 process pointer page 3 of 4
11:42:34.58 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:42:34.58 Relation 261 (XQD_1200_2000) is ok

11:42:34.58 Relation 262 (XQD_1000_3300)
11:42:34.58 process pointer page 0 of 11
11:42:34.61 process pointer page 1 of 11
11:42:34.66 process pointer page 2 of 11
11:42:34.72 process pointer page 3 of 11
11:42:34.75 process pointer page 4 of 11
11:42:34.80 process pointer page 5 of 11
11:42:34.83 process pointer page 6 of 11
11:42:34.87 process pointer page 7 of 11
11:42:34.97 process pointer page 8 of 11
11:42:35.06 process pointer page 9 of 11
11:42:35.14 process pointer page 10 of 11
11:42:35.17 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:42:35.51 Index 2 (XQD_1000_3300_DOC)
11:42:35.76 Relation 262 (XQD_1000_3300) is ok

11:42:35.76 Relation 263 (XQD_2000_3300)
11:42:35.76 process pointer page 0 of 18
11:42:35.84 process pointer page 1 of 18
11:42:35.94 process pointer page 2 of 18
11:42:36.01 process pointer page 3 of 18
11:42:36.04 process pointer page 4 of 18
11:42:36.08 process pointer page 5 of 18
11:42:36.11 process pointer page 6 of 18
11:42:36.15 process pointer page 7 of 18
11:42:36.23 process pointer page 8 of 18
11:42:36.33 process pointer page 9 of 18
11:42:36.42 process pointer page 10 of 18
11:42:36.51 process pointer page 11 of 18
11:42:36.59 process pointer page 12 of 18
11:42:36.62 process pointer page 13 of 18
11:42:36.67 process pointer page 14 of 18
11:42:36.70 process pointer page 15 of 18
11:42:36.73 process pointer page 16 of 18
11:42:36.78 process pointer page 17 of 18
11:42:36.86 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:42:37.20 Relation 263 (XQD_2000_3300) is ok

11:42:37.20 Relation 264 (XQD_2100_3300)
11:42:37.20 process pointer page 0 of 14
11:42:37.26 process pointer page 1 of 14
11:42:37.34 process pointer page 2 of 14
11:42:37.40 process pointer page 3 of 14
11:42:37.46 process pointer page 4 of 14
11:42:37.54 process pointer page 5 of 14
11:42:37.60 process pointer page 6 of 14
11:42:37.67 process pointer page 7 of 14
11:42:37.74 process pointer page 8 of 14
11:42:37.81 process pointer page 9 of 14
11:42:37.82 process pointer page 10 of 14
11:42:37.87 process pointer page 11 of 14
11:42:37.93 process pointer page 12 of 14
11:42:38.01 process pointer page 13 of 14
11:42:38.03 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:42:38.03 Relation 264 (XQD_2100_3300) is ok

11:42:38.03 Relation 265 (XQD_3300_3400)
11:42:38.03 process pointer page 0 of 25
11:42:38.12 process pointer page 1 of 25
11:42:38.17 process pointer page 2 of 25
11:42:38.21 process pointer page 3 of 25
11:42:38.24 process pointer page 4 of 25
11:42:38.32 process pointer page 5 of 25
11:42:38.40 process pointer page 6 of 25
11:42:38.49 process pointer page 7 of 25
11:42:38.59 process pointer page 8 of 25
11:42:38.68 process pointer page 9 of 25
11:42:38.76 process pointer page 10 of 25
11:42:38.85 process pointer page 11 of 25
11:42:38.95 process pointer page 12 of 25
11:42:39.04 process pointer page 13 of 25
11:42:39.13 process pointer page 14 of 25
11:42:39.23 process pointer page 15 of 25
11:42:39.32 process pointer page 16 of 25
11:42:39.40 process pointer page 17 of 25
11:42:39.48 process pointer page 18 of 25
11:42:39.52 process pointer page 19 of 25
11:42:39.62 process pointer page 20 of 25
11:42:39.69 process pointer page 21 of 25
11:42:39.79 process pointer page 22 of 25
11:42:39.88 process pointer page 23 of 25
11:42:39.98 process pointer page 24 of 25
11:42:40.07 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:42:40.66 Relation 265 (XQD_3300_3400) is ok

11:42:40.66 Relation 266 (XQS_1000_1200)
11:42:40.66 process pointer page 0 of 43
11:42:40.69 process pointer page 1 of 43
11:42:40.80 process pointer page 2 of 43
11:42:41.04 process pointer page 3 of 43
11:42:41.32 process pointer page 4 of 43
11:42:41.60 process pointer page 5 of 43
11:42:41.91 process pointer page 6 of 43
11:42:42.21 process pointer page 7 of 43
11:42:42.49 process pointer page 8 of 43
11:42:42.78 process pointer page 9 of 43
11:42:43.06 process pointer page 10 of 43
11:42:43.36 process pointer page 11 of 43
11:42:43.66 process pointer page 12 of 43
11:42:43.94 process pointer page 13 of 43
11:42:44.22 process pointer page 14 of 43
11:42:44.50 process pointer page 15 of 43
11:42:44.80 process pointer page 16 of 43
11:42:45.06 process pointer page 17 of 43
11:42:45.36 process pointer page 18 of 43
11:42:45.62 process pointer page 19 of 43
11:42:45.92 process pointer page 20 of 43
11:42:46.20 process pointer page 21 of 43
11:42:46.50 process pointer page 22 of 43
11:42:46.81 process pointer page 23 of 43
11:42:47.12 process pointer page 24 of 43
11:42:47.43 process pointer page 25 of 43
11:42:47.76 process pointer page 26 of 43
11:42:48.09 process pointer page 27 of 43
11:42:48.40 process pointer page 28 of 43
11:42:48.73 process pointer page 29 of 43
11:42:49.04 process pointer page 30 of 43
11:42:49.38 process pointer page 31 of 43
11:42:49.71 process pointer page 32 of 43
11:42:50.05 process pointer page 33 of 43
11:42:50.38 process pointer page 34 of 43
11:42:50.71 process pointer page 35 of 43
11:42:51.05 process pointer page 36 of 43
11:42:51.39 process pointer page 37 of 43
11:42:51.74 process pointer page 38 of 43
11:42:52.07 process pointer page 39 of 43
11:42:52.39 process pointer page 40 of 43
11:42:52.75 process pointer page 41 of 43
11:42:53.11 process pointer page 42 of 43
11:42:53.20 Index 1 (XQS_1000_1200_DOC_ID)
11:42:55.11 Index 2 (XQS_1000_1200_SND_ID)
11:42:56.89 Index 3 (XQS_1000_1200_RCV_ID)
11:42:58.60 Relation 266 (XQS_1000_1200) is ok

11:42:58.60 Relation 267 (XQS_1200_2000)
11:42:58.60 process pointer page 0 of 46
11:42:59.01 process pointer page 1 of 46
11:42:59.40 process pointer page 2 of 46
11:42:59.76 process pointer page 3 of 46
11:43:00.13 process pointer page 4 of 46
11:43:00.51 process pointer page 5 of 46
11:43:00.88 process pointer page 6 of 46
11:43:01.25 process pointer page 7 of 46
11:43:01.63 process pointer page 8 of 46
11:43:02.00 process pointer page 9 of 46
11:43:02.38 process pointer page 10 of 46
11:43:02.74 process pointer page 11 of 46
11:43:03.13 process pointer page 12 of 46
11:43:03.53 process pointer page 13 of 46
11:43:03.86 process pointer page 14 of 46
11:43:04.16 process pointer page 15 of 46
11:43:04.58 process pointer page 16 of 46
11:43:05.00 process pointer page 17 of 46
11:43:05.43 process pointer page 18 of 46
11:43:05.89 process pointer page 19 of 46
11:43:06.34 process pointer page 20 of 46
11:43:06.76 process pointer page 21 of 46
11:43:07.18 process pointer page 22 of 46
11:43:07.60 process pointer page 23 of 46
11:43:08.01 process pointer page 24 of 46
11:43:08.43 process pointer page 25 of 46
11:43:08.85 process pointer page 26 of 46
11:43:09.27 process pointer page 27 of 46
11:43:09.69 process pointer page 28 of 46
11:43:10.13 process pointer page 29 of 46
11:43:10.54 process pointer page 30 of 46
11:43:10.96 process pointer page 31 of 46
11:43:11.38 process pointer page 32 of 46
11:43:11.78 process pointer page 33 of 46
11:43:12.19 process pointer page 34 of 46
11:43:12.58 process pointer page 35 of 46
11:43:13.02 process pointer page 36 of 46
11:43:13.42 process pointer page 37 of 46
11:43:13.80 process pointer page 38 of 46
11:43:14.20 process pointer page 39 of 46
11:43:14.58 process pointer page 40 of 46
11:43:14.98 process pointer page 41 of 46
11:43:15.31 process pointer page 42 of 46
11:43:15.64 process pointer page 43 of 46
11:43:16.00 process pointer page 44 of 46
11:43:16.39 process pointer page 45 of 46
11:43:16.74 Index 1 (XQS_1200_2000_DOC_ID)
11:43:19.10 Index 2 (XQS_1200_2000_SND_ID)
11:43:21.41 Index 3 (XQS_1200_2000_RCV_ID)
11:43:23.39 Relation 267 (XQS_1200_2000) is ok

11:43:23.39 Relation 268 (XQS_1000_3300)
11:43:23.39 process pointer page 0 of 23
11:43:23.87 process pointer page 1 of 23
11:43:24.33 process pointer page 2 of 23
11:43:24.76 process pointer page 3 of 23
11:43:25.20 process pointer page 4 of 23
11:43:25.65 process pointer page 5 of 23
11:43:26.14 process pointer page 6 of 23
11:43:26.51 process pointer page 7 of 23
11:43:26.88 process pointer page 8 of 23
11:43:27.29 process pointer page 9 of 23
11:43:27.74 process pointer page 10 of 23
11:43:28.23 process pointer page 11 of 23
11:43:28.68 process pointer page 12 of 23
11:43:29.12 process pointer page 13 of 23
11:43:29.58 process pointer page 14 of 23
11:43:30.02 process pointer page 15 of 23
11:43:30.46 process pointer page 16 of 23
11:43:30.91 process pointer page 17 of 23
11:43:31.33 process pointer page 18 of 23
11:43:31.72 process pointer page 19 of 23
11:43:32.10 process pointer page 20 of 23
11:43:32.49 process pointer page 21 of 23
11:43:32.86 process pointer page 22 of 23
11:43:32.94 Index 1 (XQS_1000_3300_DOC_ID)
11:43:34.03 Index 2 (XQS_1000_3300_SND_ID)
11:43:35.36 Index 3 (XQS_1000_3300_RCV_ID)
11:43:36.79 Relation 268 (XQS_1000_3300) is ok

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

11:43:36.79 Relation 270 (XQS_2100_3300)
11:43:36.79 process pointer page 0 of 32
11:43:37.27 process pointer page 1 of 32
11:43:37.71 process pointer page 2 of 32
11:43:38.13 process pointer page 3 of 32
11:43:38.46 process pointer page 4 of 32
11:43:38.91 process pointer page 5 of 32
11:43:39.36 process pointer page 6 of 32
11:43:39.82 process pointer page 7 of 32
11:43:40.25 process pointer page 8 of 32
11:43:40.69 process pointer page 9 of 32
11:43:41.16 process pointer page 10 of 32
11:43:41.61 process pointer page 11 of 32
11:43:42.06 process pointer page 12 of 32
11:43:42.50 process pointer page 13 of 32
11:43:42.95 process pointer page 14 of 32
11:43:43.41 process pointer page 15 of 32
11:43:43.86 process pointer page 16 of 32
11:43:44.31 process pointer page 17 of 32
11:43:44.73 process pointer page 18 of 32
11:43:45.18 process pointer page 19 of 32
11:43:45.64 process pointer page 20 of 32
11:43:46.09 process pointer page 21 of 32
11:43:46.53 process pointer page 22 of 32
11:43:46.96 process pointer page 23 of 32
11:43:47.41 process pointer page 24 of 32
11:43:47.85 process pointer page 25 of 32
11:43:48.27 process pointer page 26 of 32
11:43:48.69 process pointer page 27 of 32
11:43:49.08 process pointer page 28 of 32
11:43:49.52 process pointer page 29 of 32
11:43:49.91 process pointer page 30 of 32
11:43:50.27 process pointer page 31 of 32
11:43:50.49 Index 1 (XQS_2100_3300_DOC_ID)
11:43:51.97 Index 2 (XQS_2100_3300_SND_ID)
11:43:53.64 Index 3 (XQS_2100_3300_RCV_ID)
11:43:55.68 Relation 270 (XQS_2100_3300) is ok

11:43:55.68 Relation 271 (XQS_3300_3400)
11:43:55.68 process pointer page 0 of 6
11:43:56.12 process pointer page 1 of 6
11:43:56.56 process pointer page 2 of 6
11:43:56.98 process pointer page 3 of 6
11:43:57.37 process pointer page 4 of 6
11:43:57.77 process pointer page 5 of 6
11:43:57.87 Index 1 (XQS_3300_3400_DOC_ID)
11:43:58.18 Index 2 (XQS_3300_3400_SND_ID)
11:43:58.52 Relation 271 (XQS_3300_3400) is ok

11:43:58.55 Validation finished
Done for 104700 ms, from 11:42:13.95 to 11:43:58.65.

Differences between old and current firebird.log

11:44:00.13. 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-07-08 11:44 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 Sat Jul 08 11:42:14 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sat Jul 08 11:43:58 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-07-08 11:44:07.71 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html
Subscribe