Tests

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

Server and database settings

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

Test configuration settings

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

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2017-05-21 06:48:26.6490 -1 <null> ::1/59385 435796 9340 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: 5965.79 3658 1073842 2017-05-21 03:48 2017-05-21 06:48
customer order: creation 458.16 513 82468 2017-05-21 03:48 2017-05-21 06:48
customer order: refuse 38.28 266 6890 2017-05-21 03:48 2017-05-21 06:48
order to supplier: creation 117.72 2262 21189 2017-05-21 03:48 2017-05-21 06:48
order to supplier: removal 2.98 21769 536 2017-05-21 03:48 2017-05-21 06:48
invoice (draft): creation 117.30 3348 21114 2017-05-21 03:48 2017-05-21 06:48
invoice (draft): removal 40.70 526 7326 2017-05-21 03:48 2017-05-21 06:48
invoice accept: apply 64.04 12084 11527 2017-05-21 03:48 2017-05-21 06:48
invoice accept: cancel 18.23 3337 3282 2017-05-21 03:48 2017-05-21 06:48
customer reserve: creation 3414.41 184 614594 2017-05-21 03:48 2017-05-21 06:48
customer reserve: removal 1061.93 75 191148 2017-05-21 03:48 2017-05-21 06:48
realization accept: apply 211.72 624 38109 2017-05-21 03:48 2017-05-21 06:48
realization accept: cancel 89.16 164 16049 2017-05-21 03:48 2017-05-21 06:48
payment from customer: creation 153.02 927 27543 2017-05-21 03:48 2017-05-21 06:48
payment from customer: removal 14.31 145 2576 2017-05-21 03:48 2017-05-21 06:48
payment to supplier: creation 125.47 477 22584 2017-05-21 03:48 2017-05-21 06:48
payment to supplier: removal 8.93 154 1607 2017-05-21 03:48 2017-05-21 06:48
service: total inventory turnovers 10.37 2832 1866 2017-05-21 03:48 2017-05-21 06:48
service: total monetary turnovers 19.01 66 3422 2017-05-21 03:48 2017-05-21 06:48
service: refresh index statistics 0.07 19749 12 2017-05-21 03:48 2017-05-21 06:48
Done for 120820 ms, from 6:54:44.71 to 6:56:45.53.

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 5017 105428 90313 15115 14.34 03:48:27 04:06:27
interval # 2, overall 2 6395 129783 115113 14670 11.30 04:06:28 04:24:28
interval # 3, overall 3 6863 137963 123537 14426 10.46 04:24:29 04:42:29
interval # 4, overall 4 6127 124669 110282 14387 11.54 04:42:30 05:00:30
interval # 5, overall 5 5915 122861 106468 16393 13.34 05:00:31 05:18:31
interval # 6, overall 6 5931 115300 106764 8536 7.40 05:18:32 05:36:32
interval # 7, overall 7 6238 126219 112279 13940 11.04 05:36:33 05:54:33
interval # 8, overall 8 5499 115406 98975 16431 14.24 05:54:34 06:12:34
interval # 9, overall 9 5993 116945 107876 9069 7.75 06:12:35 06:30:35
interval # 10, overall 10 5680 111915 102235 9680 8.65 06:30:36 06:48:36
Done for 282860 ms, from 7:01:23.81 to 7:06:06.67.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
TEST_TIME 1 4536.91 0.5558 1.3703 2178 18
TEST_TIME 2 4040.76 0.7694 1.2127 1242 18
TEST_TIME 3 3876.74 0.8428 1.1157 1461 18
TEST_TIME 4 3866.27 0.8391 1.1260 1594 15
TEST_TIME 5 3837.21 0.9076 1.0929 1733 18
TEST_TIME 6 3877.81 0.9012 1.1053 1780 16
TEST_TIME 7 3989.38 0.9209 1.1041 1694 19
TEST_TIME 8 4247.20 0.9075 1.0860 1708 15
TEST_TIME 9 4415.97 0.9285 1.0741 1810 19
TEST_TIME 10 4573.41 0.9334 1.0602 1520 14
TEST_TIME 11 4674.01 0.9431 1.0522 1680 19
TEST_TIME 12 4751.99 0.9487 1.0467 1593 20
TEST_TIME 13 4799.43 0.9566 1.0542 1674 20
TEST_TIME 14 4863.84 0.9660 1.0461 1457 28
TEST_TIME 15 4885.02 0.9721 1.0310 1365 100
TEST_TIME 16 4918.49 0.9600 1.0321 1639 100
TEST_TIME 17 4960.62 0.9670 1.0299 1415 100
TEST_TIME 18 5036.56 0.9580 1.0420 2029 100
TEST_TIME 19 5150.06 0.9654 1.0353 1924 100
TEST_TIME 20 5285.46 0.9598 1.0333 2070 100
TEST_TIME 21 5353.49 0.9716 1.0302 1953 100
TEST_TIME 22 5439.22 0.9679 1.0324 1591 100
TEST_TIME 23 5533.56 0.9707 1.0286 1711 100
TEST_TIME 24 5605.13 0.9732 1.0272 1720 100
TEST_TIME 25 5662.59 0.9762 1.0222 1715 100
TEST_TIME 26 5683.13 0.9810 1.0178 1682 100
TEST_TIME 27 5676.26 0.9822 1.0183 1385 100
TEST_TIME 28 5712.64 0.9757 1.0183 1410 100
TEST_TIME 29 5712.71 0.9833 1.0200 1409 100
TEST_TIME 30 5726.61 0.9836 1.0149 1184 100
TEST_TIME 31 5730.27 0.9816 1.0111 1323 100
TEST_TIME 32 5686.30 0.9871 1.0129 1133 100
TEST_TIME 33 5624.78 0.9929 1.0181 1175 100
TEST_TIME 34 5643.74 0.9855 1.0152 1573 100
TEST_TIME 35 5635.92 0.9875 1.0153 2165 100
TEST_TIME 36 5688.42 0.9779 1.0159 1934 100
TEST_TIME 37 5691.77 0.9879 1.0114 2028 99
TEST_TIME 38 5696.13 0.9840 1.0187 1816 100
TEST_TIME 39 5741.08 0.9848 1.0141 1797 100
TEST_TIME 40 5808.20 0.9814 1.0187 1651 100
TEST_TIME 41 5834.63 0.9894 1.0155 1696 100
TEST_TIME 42 5880.98 0.9835 1.0190 1456 100
TEST_TIME 43 5926.58 0.9876 1.0148 1482 100
TEST_TIME 44 5948.61 0.9881 1.0122 1401 100
TEST_TIME 45 5940.40 0.9911 1.0109 1371 100
TEST_TIME 46 5967.39 0.9847 1.0107 1189 100
TEST_TIME 47 5980.01 0.9871 1.0117 1153 100
TEST_TIME 48 6014.27 0.9850 1.0135 1970 100
TEST_TIME 49 6043.09 0.9883 1.0123 2022 100
TEST_TIME 50 6053.18 0.9904 1.0169 1625 100
TEST_TIME 51 6081.80 0.9922 1.0089 1808 100
TEST_TIME 52 6048.26 0.9950 1.0131 1612 95
TEST_TIME 53 6080.04 0.9890 1.0076 1649 99
TEST_TIME 54 6071.57 0.9903 1.0065 1656 100
TEST_TIME 55 6033.99 0.9943 1.0074 1581 92
TEST_TIME 56 6046.66 0.9873 1.0091 1407 99
TEST_TIME 57 6038.77 0.9928 1.0061 1729 100
TEST_TIME 58 6011.82 0.9932 1.0042 1712 100
TEST_TIME 59 5961.69 0.9955 1.0069 1525 94
TEST_TIME 60 5937.12 0.9942 1.0163 1489 97
TEST_TIME 61 5978.38 0.9927 1.0096 1212 100
TEST_TIME 62 5995.66 0.9913 1.0096 1272 100
TEST_TIME 63 6028.68 0.9884 1.0127 2028 100
TEST_TIME 64 6080.44 0.9885 1.0115 1841 100
TEST_TIME 65 6131.56 0.9880 1.0077 1649 100
TEST_TIME 66 6132.18 0.9923 1.0078 1555 100
TEST_TIME 67 6116.93 0.9952 1.0046 1608 98
TEST_TIME 68 6128.48 0.9937 1.0086 1504 100
TEST_TIME 69 6132.85 0.9938 1.0061 1544 100
TEST_TIME 70 6132.24 0.9922 1.0069 1412 100
TEST_TIME 71 6112.92 0.9959 1.0083 1524 100
TEST_TIME 72 6095.53 0.9972 1.0082 1441 99
TEST_TIME 73 6090.67 0.9951 1.0076 1282 100
TEST_TIME 74 6080.84 0.9958 1.0046 1376 100
TEST_TIME 75 6054.35 0.9955 1.0072 1311 100
TEST_TIME 76 6042.96 0.9958 1.0047 1291 100
TEST_TIME 77 6015.09 0.9963 1.0066 1323 99
TEST_TIME 78 6020.91 0.9927 1.0053 2399 100
TEST_TIME 79 6017.53 0.9931 1.0071 2272 97
TEST_TIME 80 6019.93 0.9942 1.0094 1781 98
TEST_TIME 81 6042.75 0.9932 1.0070 1714 100
TEST_TIME 82 6053.37 0.9930 1.0064 1578 98
TEST_TIME 83 6055.09 0.9940 1.0058 1531 100
TEST_TIME 84 6068.90 0.9916 1.0086 1500 100
TEST_TIME 85 6083.75 0.9943 1.0067 1239 100
TEST_TIME 86 6082.26 0.9953 1.0056 1409 100
TEST_TIME 87 6080.27 0.9943 1.0028 1521 100
TEST_TIME 88 6052.88 0.9959 1.0055 1361 97
TEST_TIME 89 6055.51 0.9937 1.0052 1251 100
TEST_TIME 90 6048.78 0.9952 1.0078 1283 100
TEST_TIME 91 6045.77 0.9972 1.0047 1062 100
TEST_TIME 92 6026.75 0.9969 1.0064 1302 100
TEST_TIME 93 6016.74 0.9973 1.0036 1317 100
TEST_TIME 94 6011.62 0.9938 1.0062 1926 97
TEST_TIME 95 6024.21 0.9936 1.0084 1691 100
TEST_TIME 96 6033.20 0.9964 1.0044 1799 99
TEST_TIME 97 6044.05 0.9923 1.0067 1632 99
TEST_TIME 98 6064.07 0.9931 1.0047 1532 99
TEST_TIME 99 6052.89 0.9964 1.0034 1509 97
TEST_TIME 100 6061.92 0.9962 1.0074 1394 100
TEST_TIME 101 6071.12 0.9959 1.0064 1395 100
TEST_TIME 102 6067.50 0.9971 1.0058 1407 100
TEST_TIME 103 6065.46 0.9964 1.0030 1569 99
TEST_TIME 104 6054.42 0.9952 1.0037 1332 99
TEST_TIME 105 6040.85 0.9964 1.0054 1146 100
TEST_TIME 106 6028.15 0.9980 1.0018 1404 99
TEST_TIME 107 6003.15 0.9966 1.0032 1154 96
TEST_TIME 108 6008.15 0.9931 1.0076 1058 99
TEST_TIME 109 6031.69 0.9948 1.0026 1792 100
TEST_TIME 110 6025.36 0.9946 1.0057 1747 98
TEST_TIME 111 6059.03 0.9918 1.0037 1583 100
TEST_TIME 112 6046.16 0.9968 1.0036 1724 97
TEST_TIME 113 6045.23 0.9949 1.0047 1701 96
TEST_TIME 114 6040.26 0.9967 1.0037 1620 95
TEST_TIME 115 6036.66 0.9956 1.0028 1434 97
TEST_TIME 116 6028.40 0.9973 1.0028 1533 98
TEST_TIME 117 6013.45 0.9967 1.0024 1590 94
TEST_TIME 118 6008.15 0.9948 1.0080 1207 100
TEST_TIME 119 6027.77 0.9962 1.0038 1226 99
TEST_TIME 120 6027.70 0.9962 1.0040 1196 99
TEST_TIME 121 6027.73 0.9960 1.0044 1306 100
TEST_TIME 122 6037.18 0.9946 1.0034 1252 100
TEST_TIME 123 6046.89 0.9936 1.0053 1869 100
TEST_TIME 124 6062.18 0.9947 1.0052 1737 99
TEST_TIME 125 6066.40 0.9965 1.0047 1650 100
TEST_TIME 126 6064.61 0.9970 1.0045 1530 99
TEST_TIME 127 6059.07 0.9975 1.0036 1776 96
TEST_TIME 128 6064.20 0.9949 1.0019 1541 98
TEST_TIME 129 6046.46 0.9971 1.0029 1589 90
TEST_TIME 130 6037.74 0.9967 1.0035 1354 87
TEST_TIME 131 6047.90 0.9942 1.0030 1045 100
TEST_TIME 132 6034.54 0.9976 1.0047 1226 100
TEST_TIME 133 6038.49 0.9965 1.0031 1363 100
TEST_TIME 134 6028.49 0.9974 1.0014 1485 99
TEST_TIME 135 6006.62 0.9976 1.0026 1366 92
TEST_TIME 136 6003.04 0.9959 1.0022 1270 97
TEST_TIME 137 5993.96 0.9964 1.0049 1195 99
TEST_TIME 138 6004.68 0.9958 1.0036 1371 99
TEST_TIME 139 5999.47 0.9973 1.0038 1965 97
TEST_TIME 140 6001.86 0.9963 1.0036 1839 96
TEST_TIME 141 5998.30 0.9970 1.0038 1641 96
TEST_TIME 142 5997.03 0.9969 1.0030 1448 85
TEST_TIME 143 6010.14 0.9978 1.0012 1290 96
TEST_TIME 144 5985.31 0.9983 1.0021 1155 73
TEST_TIME 145 5988.65 0.9947 1.0020 1300 98
TEST_TIME 146 5977.95 0.9969 1.0030 1455 97
TEST_TIME 147 5976.75 0.9964 1.0031 1148 98
TEST_TIME 148 5974.14 0.9968 1.0021 1304 96
TEST_TIME 149 5964.77 0.9969 1.0025 1404 91
TEST_TIME 150 5953.09 0.9978 1.0044 1385 95
TEST_TIME 151 5958.48 0.9968 1.0044 1020 99
TEST_TIME 152 5957.33 0.9980 1.0020 1076 97
TEST_TIME 153 5957.17 0.9955 1.0030 1458 100
TEST_TIME 154 5952.00 0.9973 1.0030 1794 96
TEST_TIME 155 5962.70 0.9948 1.0023 1706 96
TEST_TIME 156 5957.34 0.9967 1.0055 1419 97
TEST_TIME 157 5972.90 0.9965 1.0027 1533 94
TEST_TIME 158 5975.68 0.9973 1.0017 1770 99
TEST_TIME 159 5971.36 0.9962 1.0026 1606 94
TEST_TIME 160 5994.59 0.9924 1.0049 1220 100
TEST_TIME 161 6001.83 0.9975 1.0020 1272 99
TEST_TIME 162 5993.40 0.9975 1.0043 1370 99
TEST_TIME 163 6000.13 0.9970 1.0028 1336 100
TEST_TIME 164 6005.01 0.9959 1.0045 1239 100
TEST_TIME 165 6007.25 0.9981 1.0028 1267 98
TEST_TIME 166 6008.77 0.9971 1.0025 1214 100
TEST_TIME 167 5994.60 0.9989 1.0014 1293 96
TEST_TIME 168 5979.81 0.9979 1.0025 1341 96
TEST_TIME 169 5982.51 0.9961 1.0031 1774 96
TEST_TIME 170 5983.37 0.9971 1.0027 1631 92
TEST_TIME 171 5987.88 0.9961 1.0053 1421 97
TEST_TIME 172 5993.88 0.9985 1.0017 1514 99
TEST_TIME 173 5989.35 0.9966 1.0028 1631 98
TEST_TIME 174 5984.71 0.9978 1.0026 1507 97
TEST_TIME 175 5984.37 0.9969 1.0025 1468 90
TEST_TIME 176 5981.36 0.9973 1.0031 1469 95
TEST_TIME 177 5977.43 0.9981 1.0020 1391 92
TEST_TIME 178 5975.87 0.9966 1.0023 1264 96
TEST_TIME 179 5969.13 0.9978 1.0033 1276 96
TEST_TIME 180 5959.72 0.9993 1.0010 646 97
Done for 10290 ms, from 7:06:08.40 to 7:06:18.69.

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 56381 83351 52754 134405 59845 17284 57316 71710 49349 40576 64308 63506 74824 90262 99325 49996 255387 520788 <null> 03:48:27 04:06:27
fetches per second 2 51234 74077 49314 <null> 47632 <null> 74347 89611 53221 15837 72156 13655 62141 29522 107431 23784 80654 <null> <null> 04:06:28 04:24:28
fetches per second 3 37249 36095 41962 <null> 35319 3076 61967 99564 20876 22016 49617 688 94720 37225 82893 1444 208229 <null> <null> 04:24:29 04:42:29
fetches per second 4 24617 9463 15781 68826 28507 4803 55845 8106 36604 10196 44645 22261 28334 <null> 48614 19874 31555 189385 <null> 04:42:30 05:00:30
fetches per second 5 15794 29806 3895 19759 21629 32695 9396 36664 9541 3088 13205 1926 18168 4622 14450 3672 <null> 175904 <null> 05:00:31 05:18:31
fetches per second 6 13697 3358 7991 24728 9342 1785 5891 4690 2331 <null> 12457 2164 5271 990 9234 <null> <null> <null> <null> 05:18:32 05:36:32
fetches per second 7 17281 24444 14946 4108 13406 <null> 25821 43348 32339 5799 16226 1533 9762 2693 15671 6128 132436 97510 <null> 05:36:33 05:54:33
fetches per second 8 10238 27042 5297 <null> 14443 7238 41598 4730 130733 5568 3462 3729 21964 9068 14154 <null> 437984 98033 <null> 05:54:34 06:12:34
fetches per second 9 6722 3627 11720 <null> 4581 <null> 8517 <null> 17697 6100 10504 2094 8733 4332 6629 2460 <null> 35267 <null> 06:12:35 06:30:35
fetches per second 10 11224 4021 14236 3761 7573 1686 28360 2950 3161 110900 23678 10723 11170 <null> 15300 4429 101716 26219 <null> 06:30:36 06:48:36
marks per second 1 11988 10769 10868 25520 12603 3799 8010 13697 7135 8189 10720 10841 6054 16476 4636 8040 7975 12974 <null> 03:48:27 04:06:27
marks per second 2 10964 10241 11176 <null> 10657 <null> 9239 12395 7506 3088 10258 2329 4730 4835 7154 3332 8839 <null> <null> 04:06:28 04:24:28
marks per second 3 7489 4973 9106 <null> 7745 735 8084 15476 3819 3447 7383 104 6276 5663 11378 190 24339 <null> <null> 04:24:29 04:42:29
marks per second 4 5217 1090 3019 10588 5984 1155 6687 1143 4076 2057 4522 4519 1740 <null> 5457 2594 890 13503 <null> 04:42:30 05:00:30
marks per second 5 3021 3501 760 4851 4302 5304 953 5361 1142 443 1998 367 764 818 1564 736 <null> 6946 <null> 05:00:31 05:18:31
marks per second 6 2720 418 1436 3397 1404 436 598 642 143 <null> 1461 310 287 140 829 <null> <null> <null> <null> 05:18:32 05:36:32
marks per second 7 3469 3205 2921 1003 2573 <null> 2890 5946 4830 849 1872 220 425 434 2139 885 16011 1830 <null> 05:36:33 05:54:33
marks per second 8 2026 3599 908 <null> 2028 1912 3797 629 3810 833 242 532 922 1503 1442 <null> 43682 972 <null> 05:54:34 06:12:34
marks per second 9 1363 437 1821 <null> 725 <null> 721 <null> 4688 903 1376 311 283 645 511 352 <null> 475 <null> 06:12:35 06:30:35
marks per second 10 2275 508 3005 842 1517 428 3485 414 512 15100 3865 1636 459 <null> 1496 753 5271 2557 <null> 06:30:36 06:48:36
reads/fetches*100 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 03:48:27 04:06:27
reads/fetches*100 2 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> <null> 04:06:28 04:24:28
reads/fetches*100 3 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> <null> 04:24:29 04:42:29
reads/fetches*100 4 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 <null> 04:42:30 05:00:30
reads/fetches*100 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 05:00:31 05:18:31
reads/fetches*100 6 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 0 <null> <null> <null> <null> 05:18:32 05:36:32
reads/fetches*100 7 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:36:33 05:54:33
reads/fetches*100 8 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 05:54:34 06:12:34
reads/fetches*100 9 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 <null> 0 <null> 06:12:35 06:30:35
reads/fetches*100 10 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 <null> 06:30:36 06:48:36
writes/marks*100 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 3 0 <null> 03:48:27 04:06:27
writes/marks*100 2 0 0 0 <null> 0 <null> 0 0 0 1 0 0 0 1 0 0 1 <null> <null> 04:06:28 04:24:28
writes/marks*100 3 0 1 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 1 <null> <null> 04:24:29 04:42:29
writes/marks*100 4 0 0 0 0 0 0 0 0 0 2 0 0 0 <null> 0 0 5 0 <null> 04:42:30 05:00:30
writes/marks*100 5 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 <null> 0 <null> 05:00:31 05:18:31
writes/marks*100 6 1 0 0 0 0 0 0 0 1 <null> 0 0 0 0 0 <null> <null> <null> <null> 05:18:32 05:36:32
writes/marks*100 7 0 0 0 0 0 <null> 0 0 0 1 0 0 0 0 0 0 1 0 <null> 05:36:33 05:54:33
writes/marks*100 8 0 0 0 <null> 0 0 0 0 1 1 0 2 0 0 0 <null> 0 0 <null> 05:54:34 06:12:34
writes/marks*100 9 0 0 0 <null> 0 <null> 0 <null> 0 1 0 0 0 0 0 0 <null> 0 <null> 06:12:35 06:30:35
writes/marks*100 10 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 0 0 <null> 06:30:36 06:48:36
Done for 9020 ms, from 7:06:19.85 to 7:06:28.87.

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 1859166 1738295 120871 6.50 0 15257 52 120871 2017-05-21 03:48 2017-05-21 06:48
doc_list_biud 1859567 1738295 121272 6.52 0 8689 18 121272 2017-05-21 03:48 2017-05-21 06:48
sp_add_invoice_to_stock 19704 11527 8177 41.49 15 139730 12084 8177 2017-05-21 03:48 2017-05-21 06:48
sp_cancel_adding_invoice 4151 3282 869 20.93 0 131898 3337 869 2017-05-21 03:48 2017-05-21 06:48
sp_cancel_client_order 7021 6890 131 1.86 0 6458 266 131 2017-05-21 03:48 2017-05-21 06:48
sp_cancel_customer_reserve 302062 191148 110914 36.71 0 5819 75 110914 2017-05-21 03:48 2017-05-21 06:48
sp_cancel_pay_from_customer 2590 2576 14 0.54 0 2901 145 14 2017-05-21 03:48 2017-05-21 06:48
sp_cancel_pay_to_supplier 1614 1607 7 0.43 0 2902 154 7 2017-05-21 03:48 2017-05-21 06:48
sp_cancel_supplier_invoice 9329 7326 2003 21.47 0 9219 526 2003 2017-05-21 03:48 2017-05-21 06:48
sp_cancel_supplier_order 1577 536 1041 66.01 47 232409 21769 1041 2017-05-21 03:48 2017-05-21 06:48
sp_cancel_write_off 24288 16049 8239 33.92 0 4804 164 8239 2017-05-21 03:48 2017-05-21 06:48
sp_client_order 82468 82468 0 0.00 0 7535 513 0 2017-05-21 03:48 2017-05-21 06:48
sp_customer_reserve 614594 614594 0 0.00 0 8143 184 0 2017-05-21 03:48 2017-05-21 06:48
sp_fill_shopping_cart 125074 124771 303 0.24 0 3759 101 0 2017-05-21 03:48 2017-05-21 06:48
sp_fill_shopping_cart_clo_res 614594 614594 0 0.00 0 7317 14 0 2017-05-21 03:48 2017-05-21 06:48
sp_get_clo_for_invoice 11527 11527 0 0.00 0 9718 356 0 2017-05-21 03:48 2017-05-21 06:48
sp_kill_cost_storno 32286 23514 8772 27.16 0 3276 26 8772 2017-05-21 03:48 2017-05-21 06:48
sp_kill_qstorno_ret_qs2qd 637403 406207 231196 36.27 0 8658 28 231196 2017-05-21 03:48 2017-05-21 06:48
sp_kill_qty_storno 396068 274867 121201 30.60 0 8674 82 121201 2017-05-21 03:48 2017-05-21 06:48
sp_lock_selected_doc 81199 69903 11296 13.91 0 1108 8 11296 2017-05-21 03:48 2017-05-21 06:48
sp_make_cost_storno 99763 99763 0 0.00 0 14476 420 0 2017-05-21 03:48 2017-05-21 06:48
sp_multiply_rows_for_pdistr 99763 99763 0 0.00 0 2590 62 0 2017-05-21 03:48 2017-05-21 06:48
sp_multiply_rows_for_qdistr 82468 82468 0 0.00 0 6427 175 0 2017-05-21 03:48 2017-05-21 06:48
sp_pay_from_customer 27543 27543 0 0.00 0 7987 927 0 2017-05-21 03:48 2017-05-21 06:48
sp_pay_to_supplier 22584 22584 0 0.00 0 9064 477 0 2017-05-21 03:48 2017-05-21 06:48
sp_payment_common 50127 50127 0 0.00 0 2839 64 0 2017-05-21 03:48 2017-05-21 06:48
sp_qd_handle_on_cancel_clo 7017 6890 127 1.80 0 6037 118 127 2017-05-21 03:48 2017-05-21 06:48
sp_qd_handle_on_invoice_upd_sts 15491 14809 682 4.40 0 4992 382 682 2017-05-21 03:48 2017-05-21 06:48
sp_qd_handle_on_reserve_upd_sts 38109 38109 0 0.00 0 2527 51 0 2017-05-21 03:48 2017-05-21 06:48
sp_reserve_write_off 39058 38109 949 2.42 0 8611 624 949 2017-05-21 03:48 2017-05-21 06:48
sp_supplier_invoice 21239 21114 125 0.58 0 30093 3348 0 2017-05-21 03:48 2017-05-21 06:48
sp_supplier_order 21367 21189 178 0.83 0 17347 2262 0 2017-05-21 03:48 2017-05-21 06:48
srv_find_qd_qs_mism 1100307 979426 120881 10.98 0 4774 29 120881 2017-05-21 03:48 2017-05-21 06:48
srv_make_invnt_saldo 1866 1866 0 0.00 0 41761 2832 0 2017-05-21 03:48 2017-05-21 06:48
srv_make_money_saldo 3422 3422 0 0.00 0 4134 66 0 2017-05-21 03:48 2017-05-21 06:48
srv_recalc_idx_stat 12 12 0 0.00 2153 44881 19749 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_add_invoice_to_stock 8177 8177 0 0.00 0 2652 105 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_cancel_adding_invoice 691 691 0 0.00 0 1654 167 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_cancel_client_order 131 131 0 0.00 0 952 107 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_cancel_customer_reserve 55 55 0 0.00 0 530 48 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_cancel_pay_from_customer 14 14 0 0.00 0 437 56 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_cancel_pay_to_supplier 7 7 0 0.00 0 297 91 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_cancel_supplier_invoice 659 659 0 0.00 0 1560 95 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_cancel_supplier_order 13957 13957 0 0.00 0 3510 131 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_cancel_write_off 27 27 0 0.00 0 312 54 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_reserve_write_off 949 949 0 0.00 0 1529 66 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_supplier_invoice 125 125 0 0.00 0 1498 72 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-abend:sp_supplier_order 178 178 0 0.00 0 1513 78 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_add_invoice_to_stock 11527 11527 0 0.00 0 10311 662 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_cancel_adding_invoice 1388 1388 0 0.00 0 10624 831 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_cancel_client_order 6890 6890 0 0.00 0 1903 74 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_cancel_customer_reserve 2573 2573 0 0.00 0 1841 70 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_cancel_pay_from_customer 2576 2576 0 0.00 0 1716 59 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_cancel_pay_to_supplier 1607 1607 0 0.00 0 2138 60 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_cancel_supplier_invoice 877 877 0 0.00 0 1810 84 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_cancel_supplier_order 536 536 0 0.00 0 85347 1796 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_cancel_write_off 3820 3820 0 0.00 0 2340 72 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_client_order 82468 82468 0 0.00 0 3698 84 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_customer_reserve 3732 3732 0 0.00 0 1919 59 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_pay_from_customer 27543 27543 0 0.00 0 2418 74 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_pay_to_supplier 22584 22584 0 0.00 0 2387 65 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_reserve_write_off 38109 38109 0 0.00 0 3151 79 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_supplier_invoice 21114 21114 0 0.00 0 2512 74 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:sp_supplier_order 21189 21189 0 0.00 0 2558 78 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:srv_make_invnt_saldo 1866 1866 0 0.00 0 1497 30 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:srv_make_money_saldo 3422 3422 0 0.00 0 1202 27 0 2017-05-21 03:48 2017-05-21 06:48
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 141 42 0 2017-05-21 03:48 2017-05-21 06:48
v_add_invoice_to_stock 39408 23054 16354 41.49 0 2730 20 16354 2017-05-21 03:48 2017-05-21 06:48
v_all_customers 124288 124288 0 0.00 0 1123 6 0 2017-05-21 03:48 2017-05-21 06:48
v_all_suppliers 86254 85648 606 0.70 0 1342 6 0 2017-05-21 03:48 2017-05-21 06:48
v_all_wares 164936 164936 0 0.00 0 921 5 0 2017-05-21 03:48 2017-05-21 06:48
v_cancel_adding_invoice 3248 2776 472 14.53 0 3120 179 472 2017-05-21 03:48 2017-05-21 06:48
v_cancel_client_order 14042 13780 262 1.86 0 795 7 262 2017-05-21 03:48 2017-05-21 06:48
v_cancel_customer_prepayment 5180 5152 28 0.54 0 2777 9 28 2017-05-21 03:48 2017-05-21 06:48
v_cancel_customer_reserve 5256 5146 110 2.09 0 827 10 110 2017-05-21 03:48 2017-05-21 06:48
v_cancel_payment_to_supplier 3228 3214 14 0.43 0 686 9 14 2017-05-21 03:48 2017-05-21 06:48
v_cancel_supplier_invoice 3072 1754 1318 42.90 0 1092 21 1318 2017-05-21 03:48 2017-05-21 06:48
v_cancel_supplier_order 3154 1072 2082 66.01 0 640 9 2082 2017-05-21 03:48 2017-05-21 06:48
v_cancel_write_off 7694 7640 54 0.70 0 3666 105 54 2017-05-21 03:48 2017-05-21 06:48
v_max_id_clo_ord 21367 21189 178 0.83 0 608 6 0 2017-05-21 03:48 2017-05-21 06:48
v_max_id_clo_res 3732 3732 0 0.00 0 2995 22 0 2017-05-21 03:48 2017-05-21 06:48
v_max_id_ord_sup 21239 21114 125 0.58 0 687 6 0 2017-05-21 03:48 2017-05-21 06:48
v_max_non_paid_invoice 22063 22063 0 0.00 0 1263 6 0 2017-05-21 03:48 2017-05-21 06:48
v_max_non_paid_realizn 27543 27543 0 0.00 0 1373 6 0 2017-05-21 03:48 2017-05-21 06:48
v_min_id_clo_ord 21367 21189 178 0.83 0 1092 7 0 2017-05-21 03:48 2017-05-21 06:48
v_min_id_clo_res 3732 3732 0 0.00 0 3260 12 0 2017-05-21 03:48 2017-05-21 06:48
v_min_id_ord_sup 21239 21114 125 0.58 0 812 7 0 2017-05-21 03:48 2017-05-21 06:48
v_min_non_paid_invoice 22584 22584 0 0.00 0 2776 11 0 2017-05-21 03:48 2017-05-21 06:48
v_min_non_paid_realizn 27543 27543 0 0.00 0 1248 9 0 2017-05-21 03:48 2017-05-21 06:48
v_our_firm 40648 40648 0 0.00 0 812 6 0 2017-05-21 03:48 2017-05-21 06:48
v_reserve_write_off 78116 76218 1898 2.42 0 2761 9 1898 2017-05-21 03:48 2017-05-21 06:48
x_lock_depdocs_on_canc_invoice 18159 9731 8428 46.41 0 2308 36 8428 2017-05-21 03:48 2017-05-21 06:48
x_lock_depdocs_on_canc_sup_ord 1575 536 1039 65.96 0 1700 62 1039 2017-05-21 03:48 2017-05-21 06:48
x_make_qstorno_1000_1200 21367 21189 178 0.83 0 16630 2036 0 2017-05-21 03:48 2017-05-21 06:48
x_make_qstorno_1200_2000 21239 21114 125 0.58 0 29360 3119 0 2017-05-21 03:48 2017-05-21 06:48
x_make_qstorno_2100_3300 614594 614594 0 0.00 0 8112 152 0 2017-05-21 03:48 2017-05-21 06:48
Done for 414070 ms, from 7:13:16.53 to 7:20:10.60.

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 97 sp_kill_cost_storno 335544336 2017-05-21 03:49 2017-05-21 06:45
deadlock 75 sp_kill_qstorno_ret_qs2qd 335544336 2017-05-21 03:52 2017-05-21 06:47
deadlock 2172 sp_lock_selected_doc 335544336 2017-05-21 03:48 2017-05-21 06:48
deadlock 127 sp_qd_handle_on_cancel_clo 335544336 2017-05-21 03:49 2017-05-21 06:47
deadlock 145 sp_qd_handle_on_invoice_upd_sts 335544336 2017-05-21 03:49 2017-05-21 06:43
deadlock 46 x_lock_depdocs_on_canc_invoice 335544336 2017-05-21 04:07 2017-05-21 06:37
deadlock 8 x_lock_depdocs_on_canc_sup_ord 335544336 2017-05-21 04:08 2017-05-21 05:38
user_exc 178 x_make_qstorno_1000_1200 335544517 2017-05-21 03:49 2017-05-21 06:46
user_exc 125 x_make_qstorno_1200_2000 335544517 2017-05-21 03:48 2017-05-21 06:46
concurrent_transaction 7712 sp_lock_selected_doc 335544878 2017-05-21 03:48 2017-05-21 06:48
concurrent_transaction 659 x_lock_depdocs_on_canc_invoice 335544878 2017-05-21 03:48 2017-05-21 06:48
concurrent_transaction 247 x_lock_depdocs_on_canc_sup_ord 335544878 2017-05-21 03:49 2017-05-21 06:47
Done for 11930 ms, from 7:20:21.47 to 7:20:33.40.

MON$DATABASE and FB VERSION info

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

Database statistics, full


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

Variable header data:
Sweep interval: 0
*END*


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

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

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

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

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

Index AGENTS_NAME_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.16, total dup: 0, max dup: 0
Average key length: 15.86, compression ratio: 0.92
Average prefix length: 1.44, average data length: 13.16
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

DOC_DATA (141)
Primary pointer page: 251, Index root page: 252
Total formats: 1, used formats: 1
Average record length: 47.06, total records: 2165286
Average version length: 47.72, total versions: 2393, 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: 15, data page slots: 23480
Data pages: 23480, average fill: 73%
Primary pages: 23480, secondary pages: 0, swept pages: 15090
Empty pages: 7, full pages: 19115
Fill distribution:
0 - 19% = 8
20 - 39% = 9
40 - 59% = 80
60 - 79% = 23379
80 - 99% = 4

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 10480, nodes: 2165286
Average node length: 19.30, total dup: 0, max dup: 0
Average key length: 16.35, compression ratio: 1.65
Average prefix length: 13.65, average data length: 13.35
Clustering factor: 455975, ratio: 0.21
Fill distribution:
0 - 19% = 705
20 - 39% = 2260
40 - 59% = 4951
60 - 79% = 1176
80 - 99% = 1388

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7718, nodes: 2165286
Average node length: 11.65, total dup: 0, max dup: 0
Average key length: 8.69, compression ratio: 1.04
Average prefix length: 3.31, average data length: 5.69
Clustering factor: 431697, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 3446
40 - 59% = 4200
60 - 79% = 64
80 - 99% = 8

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 178807, depth: 3, leaf buckets: 3824, nodes: 2165286
Average node length: 6.81, total dup: 1579320, max dup: 49
Average key length: 3.86, compression ratio: 2.33
Average prefix length: 7.41, average data length: 1.59
Clustering factor: 417283, ratio: 0.19
Fill distribution:
0 - 19% = 150
20 - 39% = 1215
40 - 59% = 1716
60 - 79% = 238
80 - 99% = 505

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.46, total records: 651634
Average version length: 35.71, total versions: 271, max versions: 3
Average fragment length: 22.36, total fragments: 11, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8272
Data pages: 8272, average fill: 75%
Primary pages: 8267, secondary pages: 5, swept pages: 7997
Empty pages: 6, full pages: 7394
Fill distribution:
0 - 19% = 15
20 - 39% = 4
40 - 59% = 40
60 - 79% = 8206
80 - 99% = 7

Index DOC_LIST_ID_DESC (1)
Root page: 183976, depth: 3, leaf buckets: 2396, nodes: 651634
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 150858, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 1310
40 - 59% = 1051
60 - 79% = 31
80 - 99% = 4

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 689, nodes: 651634
Average node length: 4.88, total dup: 651584, max dup: 44766
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 298414, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 596
60 - 79% = 75
80 - 99% = 18

Index PK_DOC_LIST (0)
Root page: 324098, depth: 3, leaf buckets: 1971, nodes: 651634
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.17, average data length: 5.83
Clustering factor: 150858, ratio: 0.23
Fill distribution:
0 - 19% = 161
20 - 39% = 584
40 - 59% = 722
60 - 79% = 233
80 - 99% = 271

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

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

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

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

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

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

INVNT_SALDO (147)
Primary pointer page: 270, Index root page: 271
Total formats: 1, used formats: 1
Average record length: 64.33, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 17.34, total fragments: 383, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.62
Pointer pages: 1, data page slots: 1416
Data pages: 12, average fill: 51%
Primary pages: 4, secondary pages: 8, swept pages: 4
Empty pages: 1, full pages: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 2
60 - 79% = 1
80 - 99% = 3

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 59.62, total records: 10592
Average version length: 71.17, total versions: 1721, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.61
Pointer pages: 2, data page slots: 1704
Data pages: 448, average fill: 28%
Primary pages: 447, secondary pages: 1, swept pages: 280
Empty pages: 85, full pages: 16
Fill distribution:
0 - 19% = 234
20 - 39% = 67
40 - 59% = 60
60 - 79% = 84
80 - 99% = 3

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 51, nodes: 10592
Average node length: 15.32, total dup: 70, max dup: 1
Average key length: 12.49, compression ratio: 2.16
Average prefix length: 17.50, average data length: 9.50
Clustering factor: 9435, ratio: 0.89
Fill distribution:
0 - 19% = 0
20 - 39% = 28
40 - 59% = 20
60 - 79% = 3
80 - 99% = 0

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

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

MONEY_TURNOVER_LOG (142)
Primary pointer page: 260, Index root page: 261
Total formats: 1, used formats: 1
Average record length: 15.20, total records: 157
Average version length: 44.84, total versions: 106, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 4.21
Pointer pages: 1, data page slots: 64
Data pages: 32, average fill: 5%
Primary pages: 32, secondary pages: 0, swept pages: 23
Empty pages: 26, full pages: 0
Fill distribution:
0 - 19% = 29
20 - 39% = 2
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 181186, depth: 2, leaf buckets: 1, nodes: 157
Average node length: 8.13, total dup: 107, max dup: 14
Average key length: 6.36, compression ratio: 2.99
Average prefix length: 14.95, average data length: 4.05
Clustering factor: 80, ratio: 0.51
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 293, Index root page: 294
Total formats: 1, used formats: 1
Average record length: 42.35, total records: 201856
Average version length: 29.94, total versions: 2221, max versions: 7
Average fragment length: 34.25, total fragments: 4, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.51
Pointer pages: 2, data page slots: 2520
Data pages: 2520, average fill: 60%
Primary pages: 2504, secondary pages: 16, swept pages: 2382
Empty pages: 15, full pages: 208
Fill distribution:
0 - 19% = 69
20 - 39% = 173
40 - 59% = 555
60 - 79% = 1712
80 - 99% = 11

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 189, nodes: 201856
Average node length: 4.53, total dup: 201807, max dup: 10153
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 33290, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 16
40 - 59% = 79
60 - 79% = 79
80 - 99% = 15

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 221, nodes: 201856
Average node length: 5.47, total dup: 182046, max dup: 39
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 42883, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 85
60 - 79% = 88
80 - 99% = 31

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 229, nodes: 201856
Average node length: 5.47, total dup: 182046, max dup: 39
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 42897, ratio: 0.21
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 100
60 - 79% = 77
80 - 99% = 31

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 227, nodes: 201856
Average node length: 5.26, total dup: 182046, max dup: 39
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 42926, ratio: 0.21
Fill distribution:
0 - 19% = 0
20 - 39% = 18
40 - 59% = 121
60 - 79% = 66
80 - 99% = 22

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 278859, depth: 2, leaf buckets: 218, nodes: 274200
Average node length: 4.53, total dup: 274019, max dup: 2398
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 40036, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 85
60 - 79% = 69
80 - 99% = 64

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

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

PERF_LOG (163)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 151.52, total records: 11443222
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: 167, data page slots: 271208
Data pages: 271208, average fill: 87%
Primary pages: 271208, secondary pages: 0, swept pages: 3
Empty pages: 2, full pages: 271205
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 271205

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 12808, nodes: 11443222
Average node length: 5.66, total dup: 10589511, max dup: 150
Average key length: 2.18, compression ratio: 3.67
Average prefix length: 7.86, average data length: 0.13
Clustering factor: 4348154, ratio: 0.38
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 6952
60 - 79% = 3941
80 - 99% = 1907

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11276, nodes: 11443222
Average node length: 4.55, total dup: 11443217, max dup: 10540362
Average key length: 1.08, compression ratio: 0.37
Average prefix length: 0.39, average data length: 0.00
Clustering factor: 339780, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11243
60 - 79% = 4
80 - 99% = 29

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 13783, nodes: 11443222
Average node length: 5.72, total dup: 11072809, max dup: 27391
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.79, average data length: 0.21
Clustering factor: 988750, ratio: 0.09
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 9943
60 - 79% = 2097
80 - 99% = 1740

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 13601, nodes: 11443222
Average node length: 5.55, total dup: 11414222, max dup: 1489204
Average key length: 2.07, compression ratio: 18.24
Average prefix length: 37.71, average data length: 0.07
Clustering factor: 6567060, ratio: 0.57
Fill distribution:
0 - 19% = 18
20 - 39% = 2
40 - 59% = 11310
60 - 79% = 650
80 - 99% = 1621

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

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

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

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

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

PSTORNED (151)
Primary pointer page: 301, Index root page: 302
Total formats: 1, used formats: 1
Average record length: 55.09, total records: 485597
Average version length: 55.91, total versions: 1160, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.45
Pointer pages: 4, data page slots: 5792
Data pages: 5792, average fill: 74%
Primary pages: 5792, secondary pages: 0, swept pages: 4102
Empty pages: 1, full pages: 5215
Fill distribution:
0 - 19% = 3
20 - 39% = 8
40 - 59% = 30
60 - 79% = 5749
80 - 99% = 2

Index PSTORNED_RCV_ID (2)
Root page: 609829, depth: 3, leaf buckets: 642, nodes: 485597
Average node length: 5.88, total dup: 414007, max dup: 601
Average key length: 3.07, compression ratio: 2.93
Average prefix length: 8.07, average data length: 0.93
Clustering factor: 62429, ratio: 0.13
Fill distribution:
0 - 19% = 17
20 - 39% = 38
40 - 59% = 386
60 - 79% = 137
80 - 99% = 64

Index PSTORNED_SND_ID (1)
Root page: 780373, depth: 3, leaf buckets: 518, nodes: 485597
Average node length: 5.62, total dup: 432581, max dup: 109
Average key length: 2.81, compression ratio: 3.20
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 118915, ratio: 0.24
Fill distribution:
0 - 19% = 0
20 - 39% = 8
40 - 59% = 219
60 - 79% = 193
80 - 99% = 98

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

XQD_1000_1200 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 39.20, total records: 7067
Average version length: 72.20, total versions: 3231, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.47
Pointer pages: 2, data page slots: 808
Data pages: 392, average fill: 23%
Primary pages: 391, secondary pages: 1, swept pages: 265
Empty pages: 157, full pages: 44
Fill distribution:
0 - 19% = 241
20 - 39% = 54
40 - 59% = 37
60 - 79% = 43
80 - 99% = 17

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 16, nodes: 7067
Average node length: 7.19, total dup: 6094, max dup: 14
Average key length: 4.66, compression ratio: 7.94
Average prefix length: 34.47, average data length: 2.53
Clustering factor: 1169, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 8
40 - 59% = 7
60 - 79% = 0
80 - 99% = 1

XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.75, total records: 1155738
Average version length: 71.57, total versions: 6803, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 12, data page slots: 18032
Data pages: 17968, average fill: 71%
Primary pages: 17968, secondary pages: 0, swept pages: 13159
Empty pages: 102, full pages: 11584
Fill distribution:
0 - 19% = 178
20 - 39% = 351
40 - 59% = 1666
60 - 79% = 15700
80 - 99% = 73

Index XQD_1000_3300_DOC (1)
Root page: 453541, depth: 3, leaf buckets: 1349, nodes: 1155738
Average node length: 5.12, total dup: 1126725, max dup: 134
Average key length: 2.18, compression ratio: 4.12
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 130678, ratio: 0.11
Fill distribution:
0 - 19% = 23
20 - 39% = 84
40 - 59% = 1019
60 - 79% = 55
80 - 99% = 168

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 272330, depth: 3, leaf buckets: 1693, nodes: 1155738
Average node length: 6.25, total dup: 1010118, max dup: 19
Average key length: 3.31, compression ratio: 11.18
Average prefix length: 35.82, average data length: 1.18
Clustering factor: 221749, ratio: 0.19
Fill distribution:
0 - 19% = 25
20 - 39% = 196
40 - 59% = 1224
60 - 79% = 139
80 - 99% = 109

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 36.75, total records: 42996
Average version length: 72.03, total versions: 21100, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 3.70
Pointer pages: 4, data page slots: 4544
Data pages: 2104, average fill: 25%
Primary pages: 2103, secondary pages: 1, swept pages: 1470
Empty pages: 844, full pages: 249
Fill distribution:
0 - 19% = 1181
20 - 39% = 294
40 - 59% = 231
60 - 79% = 268
80 - 99% = 130

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 87, nodes: 42996
Average node length: 6.18, total dup: 37633, max dup: 49
Average key length: 3.56, compression ratio: 10.39
Average prefix length: 35.56, average data length: 1.44
Clustering factor: 5900, ratio: 0.14
Fill distribution:
0 - 19% = 3
20 - 39% = 50
40 - 59% = 26
60 - 79% = 7
80 - 99% = 1

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 70.87, total records: 1712765
Average version length: 71.55, total versions: 30946, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.92
Pointer pages: 18, data page slots: 28024
Data pages: 28000, average fill: 68%
Primary pages: 27999, secondary pages: 1, swept pages: 19883
Empty pages: 315, full pages: 15761
Fill distribution:
0 - 19% = 695
20 - 39% = 1232
40 - 59% = 4148
60 - 79% = 21420
80 - 99% = 505

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 144689, depth: 3, leaf buckets: 2742, nodes: 1712765
Average node length: 5.63, total dup: 1608961, max dup: 49
Average key length: 2.66, compression ratio: 13.89
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 243633, ratio: 0.14
Fill distribution:
0 - 19% = 22
20 - 39% = 1209
40 - 59% = 1114
60 - 79% = 287
80 - 99% = 110

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 47.23, total records: 1923
Average version length: 71.64, total versions: 621, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.88
Pointer pages: 4, data page slots: 2856
Data pages: 424, average fill: 6%
Primary pages: 423, secondary pages: 1, swept pages: 349
Empty pages: 286, full pages: 3
Fill distribution:
0 - 19% = 382
20 - 39% = 24
40 - 59% = 11
60 - 79% = 6
80 - 99% = 1

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 6, nodes: 1923
Average node length: 9.90, total dup: 1449, max dup: 37
Average key length: 7.09, compression ratio: 5.22
Average prefix length: 32.16, average data length: 4.84
Clustering factor: 339, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 71.07, total records: 2692854
Average version length: 71.01, total versions: 14666, 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: 24, data page slots: 38576
Data pages: 38576, average fill: 76%
Primary pages: 38576, secondary pages: 0, swept pages: 28981
Empty pages: 14, full pages: 34060
Fill distribution:
0 - 19% = 46
20 - 39% = 111
40 - 59% = 653
60 - 79% = 37379
80 - 99% = 387

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5571, nodes: 2692854
Average node length: 6.89, total dup: 2177191, max dup: 15
Average key length: 3.92, compression ratio: 9.45
Average prefix length: 35.28, average data length: 1.72
Clustering factor: 526409, ratio: 0.20
Fill distribution:
0 - 19% = 10
20 - 39% = 2984
40 - 59% = 2158
60 - 79% = 268
80 - 99% = 151

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.66, total records: 4749469
Average version length: 84.47, total versions: 1692, 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: 45, data page slots: 73192
Data pages: 73192, average fill: 80%
Primary pages: 73192, secondary pages: 0, swept pages: 28491
Empty pages: 3, full pages: 71846
Fill distribution:
0 - 19% = 4
20 - 39% = 8
40 - 59% = 81
60 - 79% = 22565
80 - 99% = 50534

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4883, nodes: 4749469
Average node length: 5.15, total dup: 4641292, max dup: 134
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 761978, ratio: 0.16
Fill distribution:
0 - 19% = 20
20 - 39% = 111
40 - 59% = 2191
60 - 79% = 1971
80 - 99% = 590

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5323, nodes: 4749469
Average node length: 5.70, total dup: 4250245, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 261699, ratio: 0.06
Fill distribution:
0 - 19% = 42
20 - 39% = 166
40 - 59% = 3190
60 - 79% = 301
80 - 99% = 1624

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5454, nodes: 4749469
Average node length: 5.81, total dup: 4155773, max dup: 27
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 819971, ratio: 0.17
Fill distribution:
0 - 19% = 26
20 - 39% = 131
40 - 59% = 2469
60 - 79% = 2022
80 - 99% = 806

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.87, total records: 2438221
Average version length: 83.66, total versions: 8783, 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: 24, data page slots: 38208
Data pages: 38208, average fill: 78%
Primary pages: 38208, secondary pages: 0, swept pages: 28437
Empty pages: 12, full pages: 35904
Fill distribution:
0 - 19% = 30
20 - 39% = 86
40 - 59% = 359
60 - 79% = 17505
80 - 99% = 20228

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2654, nodes: 2438221
Average node length: 5.15, total dup: 2381259, max dup: 154
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 382206, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 63
40 - 59% = 1629
60 - 79% = 730
80 - 99% = 230

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4224, nodes: 2438221
Average node length: 6.23, total dup: 1999123, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 244998, ratio: 0.10
Fill distribution:
0 - 19% = 127
20 - 39% = 1733
40 - 59% = 1670
60 - 79% = 468
80 - 99% = 226

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 2999, nodes: 2438221
Average node length: 5.81, total dup: 2133316, max dup: 29
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 459951, ratio: 0.19
Fill distribution:
0 - 19% = 18
20 - 39% = 60
40 - 59% = 1838
60 - 79% = 824
80 - 99% = 259

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.50, total records: 5042342
Average version length: 85.30, total versions: 18949, 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: 49, data page slots: 79200
Data pages: 79160, average fill: 79%
Primary pages: 79160, secondary pages: 0, swept pages: 25062
Empty pages: 160, full pages: 73393
Fill distribution:
0 - 19% = 327
20 - 39% = 513
40 - 59% = 1668
60 - 79% = 19294
80 - 99% = 57358

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5440, nodes: 5042342
Average node length: 5.04, total dup: 5012731, max dup: 681
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 754579, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 291
40 - 59% = 3235
60 - 79% = 1403
80 - 99% = 506

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6283, nodes: 5042342
Average node length: 5.54, total dup: 4639702, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 296385, ratio: 0.06
Fill distribution:
0 - 19% = 87
20 - 39% = 1695
40 - 59% = 2660
60 - 79% = 610
80 - 99% = 1231

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 6075, nodes: 5042342
Average node length: 5.69, total dup: 4522283, max dup: 86
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 838759, ratio: 0.17
Fill distribution:
0 - 19% = 5
20 - 39% = 232
40 - 59% = 3606
60 - 79% = 1621
80 - 99% = 611

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

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

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

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

XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 82.52, total records: 3378719
Average version length: 84.96, total versions: 38447, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 33, data page slots: 52408
Data pages: 52408, average fill: 80%
Primary pages: 52408, secondary pages: 0, swept pages: 29929
Empty pages: 3, full pages: 51840
Fill distribution:
0 - 19% = 22
20 - 39% = 56
40 - 59% = 133
60 - 79% = 19044
80 - 99% = 33153

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3666, nodes: 3378719
Average node length: 5.03, total dup: 3361842, max dup: 1220
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 725073, ratio: 0.21
Fill distribution:
0 - 19% = 19
20 - 39% = 336
40 - 59% = 2033
60 - 79% = 877
80 - 99% = 401

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5882, nodes: 3378719
Average node length: 6.25, total dup: 2762065, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 385829, ratio: 0.11
Fill distribution:
0 - 19% = 211
20 - 39% = 2341
40 - 59% = 2414
60 - 79% = 552
80 - 99% = 364

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3998, nodes: 3378719
Average node length: 5.60, total dup: 3076773, max dup: 99
Average key length: 2.62, compression ratio: 3.44
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 766003, ratio: 0.23
Fill distribution:
0 - 19% = 19
20 - 39% = 318
40 - 59% = 2044
60 - 79% = 1146
80 - 99% = 471

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 68.95, total records: 666756
Average version length: 70.29, total versions: 4672, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 9112
Data pages: 9112, average fill: 78%
Primary pages: 9112, secondary pages: 0, swept pages: 5872
Empty pages: 2, full pages: 9104
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 2
60 - 79% = 8965
80 - 99% = 141

Index XQS_3300_3400_DOC_ID (0)
Root page: 176765, depth: 3, leaf buckets: 797, nodes: 666756
Average node length: 5.32, total dup: 628567, max dup: 171
Average key length: 2.44, compression ratio: 3.69
Average prefix length: 8.62, average data length: 0.38
Clustering factor: 56078, ratio: 0.08
Fill distribution:
0 - 19% = 0
20 - 39% = 180
40 - 59% = 332
60 - 79% = 195
80 - 99% = 90

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 892, nodes: 666756
Average node length: 5.93, total dup: 569931, max dup: 29
Average key length: 3.05, compression ratio: 2.95
Average prefix length: 8.10, average data length: 0.90
Clustering factor: 60060, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 205
40 - 59% = 362
60 - 79% = 231
80 - 99% = 94

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Done for 79850 ms, from 7:20:33.83 to 7:21:53.68.

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 2165286 2393 0.1105
DOC_LIST 651634 271 0.0415
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 10592 1721 16.2481
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 157 106 67.5159
OPTYPES 9 0 0.0000
PDISTR 201856 2221 1.1002
PERF_ESTIMATED 274200 0 0.0000
PERF_LOG 11443222 0 0.0000
PSTORNED 485597 1160 0.2388
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 3096 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 7067 3231 45.7195
XQD_1000_3300 1155738 6803 0.5886
XQD_1200_2000 42996 21100 49.0743
XQD_2000_3300 1712765 30946 1.8067
XQD_2100_3300 1923 621 32.2932
XQD_3300_3400 2692854 14666 0.5446
XQS_1000_1200 4749469 1692 0.0356
XQS_1000_3300 2438221 8783 0.3602
XQS_1200_2000 5042342 18949 0.3757
XQS_2100_3300 3378719 38447 1.1379
XQS_3300_3400 666756 4672 0.7007
Z_USED_VIEWS 29 0 0.0000
Done for 2130 ms, from 7:22:05.40 to 7:22:07.53.

Database validation

07:22:07.66 Validation started

07:22:07.68 Relation 140 (DOC_LIST)
07:22:07.68 process pointer page 0 of 6
07:22:07.78 process pointer page 1 of 6
07:22:07.89 process pointer page 2 of 6
07:22:07.97 process pointer page 3 of 6
07:22:08.02 process pointer page 4 of 6
07:22:08.07 process pointer page 5 of 6
07:22:08.07 Index 1 (PK_DOC_LIST)
07:22:08.19 Index 2 (DOC_LIST_ID_DESC)
07:22:08.47 Index 3 (FK_DOC_LIST_AGENTS)
07:22:08.74 Relation 140 (DOC_LIST) is ok

07:22:08.74 Relation 141 (DOC_DATA)
07:22:08.74 process pointer page 0 of 15
07:22:08.85 process pointer page 1 of 15
07:22:08.94 process pointer page 2 of 15
07:22:09.03 process pointer page 3 of 15
07:22:09.11 process pointer page 4 of 15
07:22:09.20 process pointer page 5 of 15
07:22:09.30 process pointer page 6 of 15
07:22:09.33 process pointer page 7 of 15
07:22:09.36 process pointer page 8 of 15
07:22:09.41 process pointer page 9 of 15
07:22:09.44 process pointer page 10 of 15
07:22:09.47 process pointer page 11 of 15
07:22:09.53 process pointer page 12 of 15
07:22:09.59 process pointer page 13 of 15
07:22:09.63 process pointer page 14 of 15
07:22:09.64 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:22:10.51 Index 3 (DOC_DATA_ID_DESC)
07:22:11.45 Index 4 (FK_DOC_DATA_DOC_LIST)
07:22:12.18 Relation 141 (DOC_DATA) is ok

07:22:12.20 Relation 147 (INVNT_SALDO)
07:22:12.20 process pointer page 0 of 1
07:22:12.20 Index 1 (PK_INVNT_SALDO)
07:22:12.20 Relation 147 (INVNT_SALDO) is ok

07:22:12.20 Relation 150 (PDISTR)
07:22:12.20 process pointer page 0 of 2
07:22:12.29 process pointer page 1 of 2
07:22:12.32 Index 2 (PDISTR_SND_ID)
07:22:12.40 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:22:12.45 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:22:12.48 Index 5 (PDISTR_AGENT_ID)
07:22:12.51 Relation 150 (PDISTR) is ok

07:22:12.51 Relation 151 (PSTORNED)
07:22:12.51 process pointer page 0 of 4
07:22:12.54 process pointer page 1 of 4
07:22:12.57 process pointer page 2 of 4
07:22:12.60 process pointer page 3 of 4
07:22:12.62 Index 2 (PSTORNED_SND_ID)
07:22:12.68 Index 3 (PSTORNED_RCV_ID)
07:22:12.73 Relation 151 (PSTORNED) is ok

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

07:22:12.73 Relation 157 (INVNT_TURNOVER_LOG)
07:22:12.73 process pointer page 0 of 2
07:22:12.73 process pointer page 1 of 2
07:22:12.75 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:22:12.75 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:22:12.75 Relation 160 (PERF_ESTIMATED)
07:22:12.75 process pointer page 0 of 2
07:22:12.84 process pointer page 1 of 2
07:22:12.89 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:22:12.96 Relation 160 (PERF_ESTIMATED) is ok

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

07:22:12.96 Relation 162 (TRACE_STAT)
07:22:12.96 process pointer page 0 of 1
07:22:12.96 Relation 162 (TRACE_STAT) is ok

07:22:12.96 Relation 163 (PERF_LOG)
07:22:12.96 process pointer page 0 of 167
07:22:13.04 process pointer page 1 of 167
07:22:13.14 process pointer page 2 of 167
07:22:13.21 process pointer page 3 of 167
07:22:13.29 process pointer page 4 of 167
07:22:13.37 process pointer page 5 of 167
07:22:13.46 process pointer page 6 of 167
07:22:13.54 process pointer page 7 of 167
07:22:13.63 process pointer page 8 of 167
07:22:13.71 process pointer page 9 of 167
07:22:13.79 process pointer page 10 of 167
07:22:13.88 process pointer page 11 of 167
07:22:13.96 process pointer page 12 of 167
07:22:14.04 process pointer page 13 of 167
07:22:14.12 process pointer page 14 of 167
07:22:14.21 process pointer page 15 of 167
07:22:14.29 process pointer page 16 of 167
07:22:14.37 process pointer page 17 of 167
07:22:14.45 process pointer page 18 of 167
07:22:14.54 process pointer page 19 of 167
07:22:14.62 process pointer page 20 of 167
07:22:14.70 process pointer page 21 of 167
07:22:14.77 process pointer page 22 of 167
07:22:14.87 process pointer page 23 of 167
07:22:14.94 process pointer page 24 of 167
07:22:15.02 process pointer page 25 of 167
07:22:15.10 process pointer page 26 of 167
07:22:15.18 process pointer page 27 of 167
07:22:15.26 process pointer page 28 of 167
07:22:15.33 process pointer page 29 of 167
07:22:15.43 process pointer page 30 of 167
07:22:15.51 process pointer page 31 of 167
07:22:15.58 process pointer page 32 of 167
07:22:15.66 process pointer page 33 of 167
07:22:15.74 process pointer page 34 of 167
07:22:15.82 process pointer page 35 of 167
07:22:15.90 process pointer page 36 of 167
07:22:15.97 process pointer page 37 of 167
07:22:16.07 process pointer page 38 of 167
07:22:16.15 process pointer page 39 of 167
07:22:16.22 process pointer page 40 of 167
07:22:16.30 process pointer page 41 of 167
07:22:16.38 process pointer page 42 of 167
07:22:16.46 process pointer page 43 of 167
07:22:16.54 process pointer page 44 of 167
07:22:16.61 process pointer page 45 of 167
07:22:16.69 process pointer page 46 of 167
07:22:16.77 process pointer page 47 of 167
07:22:16.86 process pointer page 48 of 167
07:22:16.94 process pointer page 49 of 167
07:22:17.02 process pointer page 50 of 167
07:22:17.10 process pointer page 51 of 167
07:22:17.18 process pointer page 52 of 167
07:22:17.25 process pointer page 53 of 167
07:22:17.33 process pointer page 54 of 167
07:22:17.43 process pointer page 55 of 167
07:22:17.50 process pointer page 56 of 167
07:22:17.58 process pointer page 57 of 167
07:22:17.66 process pointer page 58 of 167
07:22:17.74 process pointer page 59 of 167
07:22:17.82 process pointer page 60 of 167
07:22:17.89 process pointer page 61 of 167
07:22:17.97 process pointer page 62 of 167
07:22:18.05 process pointer page 63 of 167
07:22:18.13 process pointer page 64 of 167
07:22:18.22 process pointer page 65 of 167
07:22:18.30 process pointer page 66 of 167
07:22:18.38 process pointer page 67 of 167
07:22:18.45 process pointer page 68 of 167
07:22:18.53 process pointer page 69 of 167
07:22:18.61 process pointer page 70 of 167
07:22:18.69 process pointer page 71 of 167
07:22:18.77 process pointer page 72 of 167
07:22:18.86 process pointer page 73 of 167
07:22:18.94 process pointer page 74 of 167
07:22:19.02 process pointer page 75 of 167
07:22:19.09 process pointer page 76 of 167
07:22:19.17 process pointer page 77 of 167
07:22:19.25 process pointer page 78 of 167
07:22:19.33 process pointer page 79 of 167
07:22:19.42 process pointer page 80 of 167
07:22:19.50 process pointer page 81 of 167
07:22:19.58 process pointer page 82 of 167
07:22:19.66 process pointer page 83 of 167
07:22:19.73 process pointer page 84 of 167
07:22:19.81 process pointer page 85 of 167
07:22:19.89 process pointer page 86 of 167
07:22:19.98 process pointer page 87 of 167
07:22:20.06 process pointer page 88 of 167
07:22:20.14 process pointer page 89 of 167
07:22:20.22 process pointer page 90 of 167
07:22:20.30 process pointer page 91 of 167
07:22:20.33 process pointer page 92 of 167
07:22:20.36 process pointer page 93 of 167
07:22:20.39 process pointer page 94 of 167
07:22:20.47 process pointer page 95 of 167
07:22:20.51 process pointer page 96 of 167
07:22:20.56 process pointer page 97 of 167
07:22:20.64 process pointer page 98 of 167
07:22:20.72 process pointer page 99 of 167
07:22:20.81 process pointer page 100 of 167
07:22:20.89 process pointer page 101 of 167
07:22:20.97 process pointer page 102 of 167
07:22:21.06 process pointer page 103 of 167
07:22:21.14 process pointer page 104 of 167
07:22:21.22 process pointer page 105 of 167
07:22:21.29 process pointer page 106 of 167
07:22:21.37 process pointer page 107 of 167
07:22:21.47 process pointer page 108 of 167
07:22:21.54 process pointer page 109 of 167
07:22:21.62 process pointer page 110 of 167
07:22:21.72 process pointer page 111 of 167
07:22:21.79 process pointer page 112 of 167
07:22:21.87 process pointer page 113 of 167
07:22:21.92 process pointer page 114 of 167
07:22:21.95 process pointer page 115 of 167
07:22:21.98 process pointer page 116 of 167
07:22:22.07 process pointer page 117 of 167
07:22:22.17 process pointer page 118 of 167
07:22:22.25 process pointer page 119 of 167
07:22:22.32 process pointer page 120 of 167
07:22:22.40 process pointer page 121 of 167
07:22:22.48 process pointer page 122 of 167
07:22:22.56 process pointer page 123 of 167
07:22:22.64 process pointer page 124 of 167
07:22:22.73 process pointer page 125 of 167
07:22:22.81 process pointer page 126 of 167
07:22:22.89 process pointer page 127 of 167
07:22:22.96 process pointer page 128 of 167
07:22:23.04 process pointer page 129 of 167
07:22:23.12 process pointer page 130 of 167
07:22:23.21 process pointer page 131 of 167
07:22:23.29 process pointer page 132 of 167
07:22:23.37 process pointer page 133 of 167
07:22:23.45 process pointer page 134 of 167
07:22:23.52 process pointer page 135 of 167
07:22:23.62 process pointer page 136 of 167
07:22:23.70 process pointer page 137 of 167
07:22:23.77 process pointer page 138 of 167
07:22:23.85 process pointer page 139 of 167
07:22:23.93 process pointer page 140 of 167
07:22:24.02 process pointer page 141 of 167
07:22:24.10 process pointer page 142 of 167
07:22:24.18 process pointer page 143 of 167
07:22:24.26 process pointer page 144 of 167
07:22:24.34 process pointer page 145 of 167
07:22:24.43 process pointer page 146 of 167
07:22:24.51 process pointer page 147 of 167
07:22:24.59 process pointer page 148 of 167
07:22:24.66 process pointer page 149 of 167
07:22:24.74 process pointer page 150 of 167
07:22:24.84 process pointer page 151 of 167
07:22:24.91 process pointer page 152 of 167
07:22:24.99 process pointer page 153 of 167
07:22:25.07 process pointer page 154 of 167
07:22:25.15 process pointer page 155 of 167
07:22:25.24 process pointer page 156 of 167
07:22:25.32 process pointer page 157 of 167
07:22:25.40 process pointer page 158 of 167
07:22:25.47 process pointer page 159 of 167
07:22:25.55 process pointer page 160 of 167
07:22:25.65 process pointer page 161 of 167
07:22:25.72 process pointer page 162 of 167
07:22:25.80 process pointer page 163 of 167
07:22:25.88 process pointer page 164 of 167
07:22:25.97 process pointer page 165 of 167
07:22:26.05 process pointer page 166 of 167
07:22:26.07 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:22:30.47 Index 2 (PERF_LOG_UNIT)
07:22:36.47 Index 3 (PERF_LOG_TRN_DESC)
07:22:39.76 Index 4 (PERF_LOG_GDSCODE)
07:22:42.15 Relation 163 (PERF_LOG) is ok

07:22:42.15 Relation 167 (V_STOPTEST)
07:22:42.15 Relation 167 (V_STOPTEST) is ok

07:22:42.15 Relation 184 (V_QDISTR_SOURCE)
07:22:42.15 Relation 184 (V_QDISTR_SOURCE) is ok

07:22:42.15 Relation 185 (V_QSTORNED_SOURCE)
07:22:42.15 Relation 185 (V_QSTORNED_SOURCE) is ok

07:22:42.15 Relation 260 (XQD_1000_1200)
07:22:42.15 process pointer page 0 of 2
07:22:42.17 process pointer page 1 of 2
07:22:42.17 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:22:42.18 Relation 260 (XQD_1000_1200) is ok

07:22:42.18 Relation 261 (XQD_1200_2000)
07:22:42.18 process pointer page 0 of 4
07:22:42.23 process pointer page 1 of 4
07:22:42.24 process pointer page 2 of 4
07:22:42.28 process pointer page 3 of 4
07:22:42.29 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:22:42.31 Relation 261 (XQD_1200_2000) is ok

07:22:42.31 Relation 262 (XQD_1000_3300)
07:22:42.31 process pointer page 0 of 12
07:22:42.39 process pointer page 1 of 12
07:22:42.46 process pointer page 2 of 12
07:22:42.56 process pointer page 3 of 12
07:22:42.63 process pointer page 4 of 12
07:22:42.71 process pointer page 5 of 12
07:22:42.81 process pointer page 6 of 12
07:22:42.88 process pointer page 7 of 12
07:22:42.98 process pointer page 8 of 12
07:22:43.06 process pointer page 9 of 12
07:22:43.15 process pointer page 10 of 12
07:22:43.23 process pointer page 11 of 12
07:22:43.23 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:22:43.66 Index 2 (XQD_1000_3300_DOC)
07:22:44.01 Relation 262 (XQD_1000_3300) is ok

07:22:44.01 Relation 263 (XQD_2000_3300)
07:22:44.01 process pointer page 0 of 18
07:22:44.10 process pointer page 1 of 18
07:22:44.19 process pointer page 2 of 18
07:22:44.29 process pointer page 3 of 18
07:22:44.34 process pointer page 4 of 18
07:22:44.37 process pointer page 5 of 18
07:22:44.41 process pointer page 6 of 18
07:22:44.51 process pointer page 7 of 18
07:22:44.54 process pointer page 8 of 18
07:22:44.57 process pointer page 9 of 18
07:22:44.63 process pointer page 10 of 18
07:22:44.71 process pointer page 11 of 18
07:22:44.80 process pointer page 12 of 18
07:22:44.88 process pointer page 13 of 18
07:22:44.97 process pointer page 14 of 18
07:22:45.07 process pointer page 15 of 18
07:22:45.15 process pointer page 16 of 18
07:22:45.24 process pointer page 17 of 18
07:22:45.26 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:22:45.83 Relation 263 (XQD_2000_3300) is ok

07:22:45.83 Relation 264 (XQD_2100_3300)
07:22:45.83 process pointer page 0 of 4
07:22:45.83 process pointer page 1 of 4
07:22:45.83 process pointer page 2 of 4
07:22:45.83 process pointer page 3 of 4
07:22:45.83 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:22:45.83 Relation 264 (XQD_2100_3300) is ok

07:22:45.83 Relation 265 (XQD_3300_3400)
07:22:45.83 process pointer page 0 of 24
07:22:45.93 process pointer page 1 of 24
07:22:46.00 process pointer page 2 of 24
07:22:46.10 process pointer page 3 of 24
07:22:46.19 process pointer page 4 of 24
07:22:46.29 process pointer page 5 of 24
07:22:46.36 process pointer page 6 of 24
07:22:46.46 process pointer page 7 of 24
07:22:46.55 process pointer page 8 of 24
07:22:46.64 process pointer page 9 of 24
07:22:46.72 process pointer page 10 of 24
07:22:46.82 process pointer page 11 of 24
07:22:46.91 process pointer page 12 of 24
07:22:47.00 process pointer page 13 of 24
07:22:47.08 process pointer page 14 of 24
07:22:47.17 process pointer page 15 of 24
07:22:47.27 process pointer page 16 of 24
07:22:47.35 process pointer page 17 of 24
07:22:47.44 process pointer page 18 of 24
07:22:47.53 process pointer page 19 of 24
07:22:47.61 process pointer page 20 of 24
07:22:47.70 process pointer page 21 of 24
07:22:47.80 process pointer page 22 of 24
07:22:47.88 process pointer page 23 of 24
07:22:47.94 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:22:49.11 Relation 265 (XQD_3300_3400) is ok

07:22:49.11 Relation 266 (XQS_1000_1200)
07:22:49.11 process pointer page 0 of 45
07:22:49.19 process pointer page 1 of 45
07:22:49.28 process pointer page 2 of 45
07:22:49.36 process pointer page 3 of 45
07:22:49.45 process pointer page 4 of 45
07:22:49.55 process pointer page 5 of 45
07:22:49.62 process pointer page 6 of 45
07:22:49.72 process pointer page 7 of 45
07:22:49.80 process pointer page 8 of 45
07:22:49.89 process pointer page 9 of 45
07:22:49.98 process pointer page 10 of 45
07:22:50.06 process pointer page 11 of 45
07:22:50.15 process pointer page 12 of 45
07:22:50.25 process pointer page 13 of 45
07:22:50.33 process pointer page 14 of 45
07:22:50.42 process pointer page 15 of 45
07:22:50.50 process pointer page 16 of 45
07:22:50.59 process pointer page 17 of 45
07:22:50.67 process pointer page 18 of 45
07:22:50.76 process pointer page 19 of 45
07:22:50.84 process pointer page 20 of 45
07:22:50.93 process pointer page 21 of 45
07:22:51.01 process pointer page 22 of 45
07:22:51.11 process pointer page 23 of 45
07:22:51.18 process pointer page 24 of 45
07:22:51.26 process pointer page 25 of 45
07:22:51.36 process pointer page 26 of 45
07:22:51.43 process pointer page 27 of 45
07:22:51.53 process pointer page 28 of 45
07:22:51.60 process pointer page 29 of 45
07:22:51.70 process pointer page 30 of 45
07:22:51.78 process pointer page 31 of 45
07:22:51.87 process pointer page 32 of 45
07:22:51.95 process pointer page 33 of 45
07:22:52.04 process pointer page 34 of 45
07:22:52.12 process pointer page 35 of 45
07:22:52.21 process pointer page 36 of 45
07:22:52.31 process pointer page 37 of 45
07:22:52.38 process pointer page 38 of 45
07:22:52.48 process pointer page 39 of 45
07:22:52.56 process pointer page 40 of 45
07:22:52.65 process pointer page 41 of 45
07:22:52.73 process pointer page 42 of 45
07:22:52.82 process pointer page 43 of 45
07:22:52.90 process pointer page 44 of 45
07:22:52.98 Index 1 (XQS_1000_1200_DOC_ID)
07:22:54.33 Index 2 (XQS_1000_1200_SND_ID)
07:22:55.82 Index 3 (XQS_1000_1200_RCV_ID)
07:22:56.77 Relation 266 (XQS_1000_1200) is ok

07:22:56.77 Relation 267 (XQS_1200_2000)
07:22:56.78 process pointer page 0 of 49
07:22:56.88 process pointer page 1 of 49
07:22:56.99 process pointer page 2 of 49
07:22:57.10 process pointer page 3 of 49
07:22:57.19 process pointer page 4 of 49
07:22:57.30 process pointer page 5 of 49
07:22:57.41 process pointer page 6 of 49
07:22:57.52 process pointer page 7 of 49
07:22:57.63 process pointer page 8 of 49
07:22:57.72 process pointer page 9 of 49
07:22:57.81 process pointer page 10 of 49
07:22:57.84 process pointer page 11 of 49
07:22:57.88 process pointer page 12 of 49
07:22:57.95 process pointer page 13 of 49
07:22:58.08 process pointer page 14 of 49
07:22:58.19 process pointer page 15 of 49
07:22:58.28 process pointer page 16 of 49
07:22:58.39 process pointer page 17 of 49
07:22:58.50 process pointer page 18 of 49
07:22:58.59 process pointer page 19 of 49
07:22:58.70 process pointer page 20 of 49
07:22:58.80 process pointer page 21 of 49
07:22:58.91 process pointer page 22 of 49
07:22:59.00 process pointer page 23 of 49
07:22:59.11 process pointer page 24 of 49
07:22:59.22 process pointer page 25 of 49
07:22:59.31 process pointer page 26 of 49
07:22:59.42 process pointer page 27 of 49
07:22:59.53 process pointer page 28 of 49
07:22:59.64 process pointer page 29 of 49
07:22:59.73 process pointer page 30 of 49
07:22:59.84 process pointer page 31 of 49
07:22:59.94 process pointer page 32 of 49
07:23:00.04 process pointer page 33 of 49
07:23:00.14 process pointer page 34 of 49
07:23:00.25 process pointer page 35 of 49
07:23:00.36 process pointer page 36 of 49
07:23:00.45 process pointer page 37 of 49
07:23:00.56 process pointer page 38 of 49
07:23:00.65 process pointer page 39 of 49
07:23:00.76 process pointer page 40 of 49
07:23:00.86 process pointer page 41 of 49
07:23:00.97 process pointer page 42 of 49
07:23:01.06 process pointer page 43 of 49
07:23:01.17 process pointer page 44 of 49
07:23:01.26 process pointer page 45 of 49
07:23:01.37 process pointer page 46 of 49
07:23:01.46 process pointer page 47 of 49
07:23:01.56 process pointer page 48 of 49
07:23:01.62 Index 1 (XQS_1200_2000_DOC_ID)
07:23:03.52 Index 2 (XQS_1200_2000_SND_ID)
07:23:05.58 Index 3 (XQS_1200_2000_RCV_ID)
07:23:08.41 Relation 267 (XQS_1200_2000) is ok

07:23:08.41 Relation 268 (XQS_1000_3300)
07:23:08.41 process pointer page 0 of 24
07:23:08.92 process pointer page 1 of 24
07:23:09.44 process pointer page 2 of 24
07:23:09.95 process pointer page 3 of 24
07:23:10.48 process pointer page 4 of 24
07:23:11.00 process pointer page 5 of 24
07:23:11.51 process pointer page 6 of 24
07:23:12.01 process pointer page 7 of 24
07:23:12.52 process pointer page 8 of 24
07:23:13.02 process pointer page 9 of 24
07:23:13.54 process pointer page 10 of 24
07:23:14.04 process pointer page 11 of 24
07:23:14.54 process pointer page 12 of 24
07:23:15.05 process pointer page 13 of 24
07:23:15.55 process pointer page 14 of 24
07:23:16.07 process pointer page 15 of 24
07:23:16.57 process pointer page 16 of 24
07:23:17.06 process pointer page 17 of 24
07:23:17.56 process pointer page 18 of 24
07:23:18.06 process pointer page 19 of 24
07:23:18.56 process pointer page 20 of 24
07:23:19.06 process pointer page 21 of 24
07:23:19.56 process pointer page 22 of 24
07:23:20.04 process pointer page 23 of 24
07:23:20.20 Index 1 (XQS_1000_3300_DOC_ID)
07:23:21.65 Index 2 (XQS_1000_3300_SND_ID)
07:23:23.40 Index 3 (XQS_1000_3300_RCV_ID)
07:23:25.25 Relation 268 (XQS_1000_3300) is ok

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

07:23:25.27 Relation 270 (XQS_2100_3300)
07:23:25.27 process pointer page 0 of 33
07:23:25.77 process pointer page 1 of 33
07:23:26.28 process pointer page 2 of 33
07:23:26.78 process pointer page 3 of 33
07:23:27.30 process pointer page 4 of 33
07:23:27.80 process pointer page 5 of 33
07:23:28.31 process pointer page 6 of 33
07:23:28.83 process pointer page 7 of 33
07:23:29.33 process pointer page 8 of 33
07:23:29.84 process pointer page 9 of 33
07:23:30.36 process pointer page 10 of 33
07:23:30.85 process pointer page 11 of 33
07:23:31.35 process pointer page 12 of 33
07:23:31.85 process pointer page 13 of 33
07:23:32.37 process pointer page 14 of 33
07:23:32.88 process pointer page 15 of 33
07:23:33.38 process pointer page 16 of 33
07:23:33.90 process pointer page 17 of 33
07:23:34.44 process pointer page 18 of 33
07:23:34.93 process pointer page 19 of 33
07:23:35.43 process pointer page 20 of 33
07:23:35.92 process pointer page 21 of 33
07:23:36.44 process pointer page 22 of 33
07:23:36.94 process pointer page 23 of 33
07:23:37.44 process pointer page 24 of 33
07:23:37.95 process pointer page 25 of 33
07:23:38.45 process pointer page 26 of 33
07:23:38.95 process pointer page 27 of 33
07:23:39.45 process pointer page 28 of 33
07:23:39.95 process pointer page 29 of 33
07:23:40.45 process pointer page 30 of 33
07:23:40.95 process pointer page 31 of 33
07:23:41.38 process pointer page 32 of 33
07:23:41.42 Index 1 (XQS_2100_3300_DOC_ID)
07:23:43.62 Index 2 (XQS_2100_3300_SND_ID)
07:23:45.74 Index 3 (XQS_2100_3300_RCV_ID)
07:23:48.25 Relation 270 (XQS_2100_3300) is ok

07:23:48.25 Relation 271 (XQS_3300_3400)
07:23:48.25 process pointer page 0 of 6
07:23:48.75 process pointer page 1 of 6
07:23:49.23 process pointer page 2 of 6
07:23:49.72 process pointer page 3 of 6
07:23:50.21 process pointer page 4 of 6
07:23:50.70 process pointer page 5 of 6
07:23:50.98 Index 1 (XQS_3300_3400_DOC_ID)
07:23:51.37 Index 2 (XQS_3300_3400_SND_ID)
07:23:51.79 Relation 271 (XQS_3300_3400) is ok

07:23:51.84 Validation finished
Done for 104400 ms, from 7:22:07.55 to 7:23:51.95.

Differences between old and current firebird.log

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

End of gathering firebird.log AFTER test finish.

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

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

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


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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2017-05-21 7:24:03.22 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html