Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 90. 2016-03-07 17:24:43.99.
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-V2.5.6.26979 Firebird 2.5
Server implementation: Firebird/x86-64/Windows NT
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
Classic 2.5.6 D:\OLTP-EMUL\OLTP25-SMALL.FDB ON 0 384 8192

Test configuration settings

File: E:\OLTP-EMUL\src\oltp25_config.win
PARAM_NAME PARAM_VALUE
fbc E:\FB25.TMPINSTANCE\bin\
dbnm D:\OLTP-EMUL\oltp25-small.fdb
host localhost
port 3255
usr SYSDBA
pwd masterke
tmpdir e:\temp\logs.oltp25
working_mode small_03
warm_time 10
test_time 180
idle_time 0
use_mtee 0
is_embed 0
remove_isql_logs if_no_severe_errors
no_auto_undo 1
detailed_info 0
mon_unit_perf 0
trc_unit_perf 1
init_buff 32768
create_with_fw sync
create_with_sweep 0
wait_if_not_exists 0
wait_after_create 0
init_docs 0
wait_for_copy 0
create_with_debug_objects 1
create_with_split_heavy_tabs 1
create_with_separate_qdistr_idx 0
create_with_compound_columns_order most_selective_first
make_html 1
run_db_statistics 1
run_db_validation 1
file_name_with_test_params regular
upload_report 1

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2016-03-07 17:24:23.6870 -1 <null> 127.0.0.1 100823 4280 2

Current test settings

CATEGORY SETTING VAL
COMMON TRACED_UNITS ,,
COMMON ENABLE_MON_QUERY 0
COMMON HALT_TEST_ON_ERRORS ,CK,
COMMON LOG_PK_VIOLATION 0
COMMON QMISM_VERIFY_BITSET 1
COMMON RECALC_IDX_MIN_INTERVAL 15
COMMON ENABLE_RESERVES_WHEN_ADD_INVOICE 1
COMMON ORDER_FOR_OUR_FIRM_PERCENT 25
COMMON ENABLE_FILL_PHRASES 0
COMMON RANDOM_SEEK_VIA_ROWS_LIMIT 0
COMMON C_INVOICE_MIN_PURCHASE 1000
COMMON C_INVOICE_MAX_PURCHASE 2000
COMMON C_INVOICE_MIN_PROFIT_PRC 35
COMMON C_INVOICE_MAX_PROFIT_PRC 80
COMMON C_MIN_COST_TO_BE_SPLITTED 1000
COMMON C_ROWS_TO_MULTIPLY 10
COMMON C_PAYMENT_FROM_CLIENT_MIN_TOTAL 1000
COMMON C_PAYMENT_FROM_CLIENT_MAX_TOTAL 5000
COMMON C_PAYMENT_TO_SUPPLIER_MIN_TOTAL 2000
COMMON C_PAYMENT_TO_SUPPLIER_MAX_TOTAL 15000
COMMON BUILD_WITH_SPLIT_HEAVY_TABS 1
COMMON BUILD_WITH_SEPAR_QDISTR_IDX 0
COMMON BUILD_WITH_QD_COMPOUND_ORDR MOST_SELECTIVE_FIRST
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: 922.32 62391 166018 2016-03-07 14:24 2016-03-07 17:24
customer order: creation 41.34 1036 7441 2016-03-07 14:24 2016-03-07 17:24
customer order: refuse 3.10 42 551 2016-03-07 14:24 2016-03-07 17:24
order to supplier: creation 10.91 8500 1964 2016-03-07 14:24 2016-03-07 17:24
order to supplier: removal 0.25 54649 43 2016-03-07 14:24 2016-03-07 17:24
invoice (draft): creation 10.81 2112 1946 2016-03-07 14:24 2016-03-07 17:24
invoice (draft): removal 1.75 156 303 2016-03-07 14:24 2016-03-07 17:24
invoice accept: apply 4.13 1063005 743 2016-03-07 14:24 2016-03-07 17:24
invoice accept: cancel 0.74 39049 131 2016-03-07 14:24 2016-03-07 17:24
customer reserve: creation 764.19 5637 137555 2016-03-07 14:24 2016-03-07 17:24
customer reserve: removal 25.09 1751 4516 2016-03-07 14:24 2016-03-07 17:24
realization accept: apply 19.61 67 3529 2016-03-07 14:24 2016-03-07 17:24
realization accept: cancel 6.55 46 1173 2016-03-07 14:24 2016-03-07 17:24
payment from customer: creation 14.24 121 2564 2016-03-07 14:24 2016-03-07 17:24
payment from customer: removal 1.40 22 252 2016-03-07 14:24 2016-03-07 17:24
payment to supplier: creation 12.10 298 2153 2016-03-07 14:24 2016-03-07 17:24
payment to supplier: removal 0.77 24 136 2016-03-07 14:24 2016-03-07 17:24
service: total inventory turnovers 2.73 6778 491 2016-03-07 14:24 2016-03-07 17:24
service: total monetary turnovers 2.90 14 516 2016-03-07 14:24 2016-03-07 17:24
service: refresh index statistics 0.07 2120 11 2016-03-07 14:24 2016-03-07 17:24
Done for 5920 ms, from 17:24:58.22 to 17:25:04.14.

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 1309 24891 23570 1321 5.31 14:24:24 14:42:24
interval # 2, overall 2 966 17714 17385 329 1.86 14:42:25 15:00:25
interval # 3, overall 3 923 17395 16614 781 4.49 15:00:26 15:18:26
interval # 4, overall 4 784 14512 14105 407 2.80 15:18:27 15:36:27
interval # 5, overall 5 1101 20614 19813 801 3.89 15:36:28 15:54:28
interval # 6, overall 6 993 18363 17875 488 2.66 15:54:29 16:12:29
interval # 7, overall 7 1290 24422 23223 1199 4.91 16:12:30 16:30:30
interval # 8, overall 8 1262 23061 22710 351 1.52 16:30:31 16:48:31
interval # 9, overall 9 341 7688 6143 1545 20.10 16:48:32 17:06:32
interval # 10, overall 10 254 4835 4580 255 5.27 17:06:33 17:24:33
Done for 11600 ms, from 17:25:12.61 to 17:25:24.21.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
WARM_TIME 1 1832.04 0.5998 1.4972 1163 87
WARM_TIME 2 1766.38 0.7767 1.2967 656 78
WARM_TIME 3 1709.40 0.8934 1.1319 513 77
WARM_TIME 4 1623.34 0.8941 1.0754 499 77
WARM_TIME 5 1507.61 0.9272 1.1124 413 78
WARM_TIME 6 1495.15 0.9349 1.0885 622 80
WARM_TIME 7 1446.64 0.9644 1.0548 361 60
WARM_TIME 8 1499.74 0.8904 1.0741 537 72
WARM_TIME 9 1459.88 0.9809 1.0223 411 60
WARM_TIME 10 1379.68 0.9737 1.0199 455 67
TEST_TIME 11 1335.16 0.9582 1.0364 452 63
TEST_TIME 12 1314.11 0.9653 1.0395 475 63
TEST_TIME 13 1286.55 0.9801 1.0205 408 64
TEST_TIME 14 1245.03 0.9793 1.0169 415 55
TEST_TIME 15 1227.48 0.9627 1.0459 591 49
TEST_TIME 16 1247.85 0.9646 1.0285 528 47
TEST_TIME 17 1245.96 0.9695 1.0291 878 36
TEST_TIME 18 1245.28 0.9724 1.0389 711 20
TEST_TIME 19 1247.05 0.9829 1.0164 508 12
TEST_TIME 20 1215.05 0.9933 1.0145 183 6
TEST_TIME 21 1192.16 0.9930 1.0062 174 4
TEST_TIME 22 1170.91 0.9891 1.0153 167 9
TEST_TIME 23 1154.01 0.9875 1.0151 140 8
TEST_TIME 24 1130.06 0.9935 1.0127 117 5
TEST_TIME 25 1113.34 0.9872 1.0157 162 4
TEST_TIME 26 1103.09 0.9857 1.0112 212 7
TEST_TIME 27 1105.11 0.9779 1.0076 139 7
TEST_TIME 28 1081.94 0.9924 1.0222 273 10
TEST_TIME 29 1069.89 0.9981 1.0038 52 4
TEST_TIME 30 1056.99 0.9900 1.0042 134 5
TEST_TIME 31 1046.30 0.9818 1.0065 202 7
TEST_TIME 32 1030.17 0.9903 1.0015 26 3
TEST_TIME 33 1015.45 0.9853 1.0140 107 6
TEST_TIME 34 1009.28 0.9902 1.0126 213 8
TEST_TIME 35 999.68 0.9932 1.0128 86 4
TEST_TIME 36 987.20 0.9971 1.0026 13 3
TEST_TIME 37 970.92 0.9927 1.0073 180 8
TEST_TIME 38 961.84 0.9901 1.0126 166 8
TEST_TIME 39 951.58 0.9973 1.0072 85 5
TEST_TIME 40 938.07 0.9962 1.0021 32 2
TEST_TIME 41 923.32 0.9980 1.0018 27 2
TEST_TIME 42 922.06 0.9897 1.0061 180 6
TEST_TIME 43 920.96 0.9839 1.0083 126 6
TEST_TIME 44 920.58 0.9925 1.0116 115 7
TEST_TIME 45 929.99 0.9791 1.0158 264 12
TEST_TIME 46 929.55 0.9943 1.0120 226 9
TEST_TIME 47 934.29 0.9865 1.0105 149 9
TEST_TIME 48 932.94 0.9918 1.0015 85 4
TEST_TIME 49 928.93 0.9853 1.0055 129 5
TEST_TIME 50 920.80 0.9941 1.0035 89 4
TEST_TIME 51 907.46 0.9983 1.0035 50 4
TEST_TIME 52 896.51 0.9963 1.0059 37 4
TEST_TIME 53 899.17 0.9902 1.0053 153 5
TEST_TIME 54 892.36 0.9942 1.0133 311 7
TEST_TIME 55 893.33 0.9938 1.0085 158 7
TEST_TIME 56 899.02 0.9843 1.0135 145 7
TEST_TIME 57 910.29 0.9836 1.0080 332 11
TEST_TIME 58 912.87 0.9932 1.0076 66 4
TEST_TIME 59 914.18 0.9950 1.0012 62 4
TEST_TIME 60 902.56 0.9975 1.0071 85 3
TEST_TIME 61 899.75 0.9937 1.0167 77 7
TEST_TIME 62 920.68 0.9776 1.0076 394 10
TEST_TIME 63 922.10 0.9901 1.0114 290 10
TEST_TIME 64 922.50 0.9951 1.0066 274 8
TEST_TIME 65 927.73 0.9856 1.0077 197 8
TEST_TIME 66 932.90 0.9869 1.0093 116 6
TEST_TIME 67 947.60 0.9788 1.0096 282 10
TEST_TIME 68 943.48 0.9992 1.0005 80 2
TEST_TIME 69 937.47 0.9984 1.0044 66 2
TEST_TIME 70 929.02 1.0000 1.0000 1 1
TEST_TIME 71 921.31 0.9999 1.0000 8 1
TEST_TIME 72 915.25 0.9927 1.0059 36 5
TEST_TIME 73 919.18 0.9879 1.0025 97 5
TEST_TIME 74 914.28 0.9969 1.0035 41 6
TEST_TIME 75 908.82 0.9961 1.0009 79 3
TEST_TIME 76 899.34 0.9997 1.0002 38 1
TEST_TIME 77 892.53 0.9967 1.0073 52 3
TEST_TIME 78 887.74 0.9998 1.0002 28 2
TEST_TIME 79 879.74 0.9973 1.0022 57 3
TEST_TIME 80 881.78 0.9874 1.0138 117 7
TEST_TIME 81 886.94 0.9955 1.0055 35 6
TEST_TIME 82 883.36 0.9973 1.0036 121 5
TEST_TIME 83 885.31 0.9909 1.0080 322 10
TEST_TIME 84 886.06 0.9952 1.0073 110 4
TEST_TIME 86 873.57 0.9987 1.0050 5 2
TEST_TIME 87 877.35 0.9931 1.0040 99 5
TEST_TIME 88 883.80 0.9904 1.0012 39 4
TEST_TIME 89 893.06 0.9858 1.0106 358 10
TEST_TIME 90 910.95 0.9797 1.0140 315 12
TEST_TIME 91 927.02 0.9855 1.0125 165 13
TEST_TIME 92 931.60 0.9966 1.0033 161 5
TEST_TIME 93 939.89 0.9906 1.0036 143 9
TEST_TIME 94 935.97 0.9971 1.0052 120 6
TEST_TIME 95 939.44 0.9921 1.0043 225 8
TEST_TIME 96 939.44 0.9939 1.0036 141 9
TEST_TIME 97 939.83 0.9929 1.0045 91 6
TEST_TIME 98 935.81 0.9985 1.0013 42 4
TEST_TIME 99 931.67 0.9956 1.0094 151 7
TEST_TIME 100 935.05 0.9978 1.0028 51 3
TEST_TIME 101 935.65 0.9977 1.0005 15 3
TEST_TIME 102 930.20 0.9966 1.0035 127 7
TEST_TIME 103 931.35 0.9960 1.0033 221 6
TEST_TIME 104 932.38 0.9935 1.0067 156 9
TEST_TIME 105 931.70 0.9978 1.0025 49 4
TEST_TIME 106 931.70 0.9930 1.0081 143 8
TEST_TIME 107 930.71 0.9998 1.0001 34 3
TEST_TIME 108 924.55 0.9975 1.0016 38 5
TEST_TIME 109 926.71 0.9901 1.0074 287 12
TEST_TIME 110 936.33 0.9880 1.0065 121 8
TEST_TIME 111 934.55 0.9995 1.0023 37 3
TEST_TIME 112 931.55 0.9992 1.0015 76 3
TEST_TIME 113 930.47 0.9964 1.0101 117 10
TEST_TIME 114 936.22 0.9979 1.0003 67 4
TEST_TIME 115 934.90 0.9958 1.0005 39 3
TEST_TIME 116 928.31 0.9990 1.0014 18 3
TEST_TIME 117 924.72 0.9967 1.0028 62 3
TEST_TIME 118 928.28 0.9931 1.0049 206 7
TEST_TIME 119 932.29 0.9936 1.0019 146 6
TEST_TIME 120 929.72 0.9963 1.0023 82 5
TEST_TIME 121 929.77 0.9939 1.0045 255 9
TEST_TIME 122 929.68 0.9964 1.0040 50 5
TEST_TIME 123 933.35 0.9958 1.0018 124 5
TEST_TIME 124 940.70 0.9890 1.0046 302 9
TEST_TIME 125 942.67 0.9945 1.0079 119 14
TEST_TIME 126 949.47 0.9928 1.0078 378 11
TEST_TIME 127 950.99 0.9983 1.0026 132 4
TEST_TIME 128 949.73 0.9961 1.0053 106 6
TEST_TIME 129 949.56 0.9977 1.0024 52 5
TEST_TIME 130 947.24 0.9993 1.0004 36 3
TEST_TIME 131 947.59 0.9924 1.0043 168 7
TEST_TIME 132 945.30 0.9995 1.0002 12 1
TEST_TIME 133 940.76 0.9983 1.0005 32 4
TEST_TIME 134 942.41 0.9913 1.0065 259 13
TEST_TIME 135 951.58 0.9894 1.0094 319 14
TEST_TIME 136 955.63 0.9978 1.0046 177 8
TEST_TIME 137 960.09 0.9942 1.0055 64 8
TEST_TIME 138 958.97 0.9994 1.0006 54 4
TEST_TIME 139 960.06 0.9922 1.0028 76 7
TEST_TIME 140 962.57 0.9931 1.0028 163 6
TEST_TIME 141 970.88 0.9872 1.0044 224 10
TEST_TIME 142 971.39 0.9969 1.0058 263 11
TEST_TIME 143 976.26 0.9938 1.0071 153 11
TEST_TIME 144 981.50 0.9948 1.0067 100 10
TEST_TIME 145 988.14 0.9930 1.0074 163 11
TEST_TIME 146 994.54 0.9958 1.0052 105 11
TEST_TIME 147 1006.77 0.9899 1.0084 268 12
TEST_TIME 148 1013.26 0.9952 1.0044 194 11
TEST_TIME 149 1013.95 0.9971 1.0027 58 4
TEST_TIME 150 1023.68 0.9865 1.0113 160 11
TEST_TIME 151 1036.04 0.9926 1.0058 143 9
TEST_TIME 152 1041.66 0.9938 1.0027 171 9
TEST_TIME 153 1043.28 0.9948 1.0009 74 4
TEST_TIME 154 1040.36 0.9972 1.0002 22 3
TEST_TIME 155 1037.52 0.9965 1.0028 48 4
TEST_TIME 156 1041.53 0.9925 1.0031 142 8
TEST_TIME 157 1040.52 0.9977 1.0006 30 3
TEST_TIME 158 1037.37 0.9973 1.0018 19 4
TEST_TIME 159 1033.06 0.9996 1.0003 126 4
TEST_TIME 161 1029.39 0.9939 1.0073 61 6
TEST_TIME 162 1031.29 0.9993 1.0010 112 8
TEST_TIME 163 1030.00 0.9961 1.0010 66 5
TEST_TIME 164 1025.36 0.9995 1.0004 49 5
TEST_TIME 165 1020.31 0.9997 1.0003 42 3
TEST_TIME 166 1017.23 0.9973 1.0015 58 3
TEST_TIME 167 1012.69 0.9999 1.0000 10 1
TEST_TIME 169 1001.25 0.9999 1.0000 5 1
TEST_TIME 170 998.90 0.9971 1.0022 84 3
TEST_TIME 171 996.09 0.9999 1.0000 10 1
TEST_TIME 172 990.98 0.9993 1.0002 70 2
TEST_TIME 173 992.46 0.9935 1.0029 127 7
TEST_TIME 174 990.96 0.9986 1.0011 78 4
TEST_TIME 175 987.55 0.9996 1.0001 20 3
TEST_TIME 176 982.92 0.9996 1.0002 22 3
TEST_TIME 177 981.56 0.9972 1.0021 33 3
TEST_TIME 178 980.64 0.9982 1.0017 116 6
TEST_TIME 179 978.64 0.9981 1.0018 132 6
TEST_TIME 180 976.00 0.9990 1.0014 55 4
TEST_TIME 181 974.79 0.9978 1.0004 49 4
TEST_TIME 182 971.31 0.9985 1.0014 115 8
TEST_TIME 183 967.93 0.9994 1.0008 84 3
TEST_TIME 184 964.16 0.9993 1.0014 90 4
TEST_TIME 185 962.59 0.9976 1.0017 130 6
TEST_TIME 186 960.09 0.9990 1.0011 53 4
TEST_TIME 187 958.09 0.9985 1.0010 111 4
TEST_TIME 188 955.00 0.9989 1.0005 65 3
TEST_TIME 189 950.91 1.0000 1.0000 2 1
TEST_TIME 190 950.22 0.9965 1.0011 219 90
Done for 8970 ms, from 17:25:24.51 to 17:25:33.48.

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 3646 25637 2185 <null> 10538 <null> 4381 <null> 5985 801 19308 <null> 45639 36114 37755 <null> 131749 265550 <null> 14:24:24 14:42:24
fetches per second 3 62141 52937 17992 <null> 59029 <null> 1793 <null> <null> 683 57121 <null> 178202 <null> 246849 62888 112771 1350104 <null> 15:00:26 15:18:26
fetches per second 4 18351 <null> 22736 <null> 23560 <null> 1624 <null> <null> 1183 <null> <null> <null> <null> 261726 <null> 51180 <null> <null> 15:18:27 15:36:27
fetches per second 5 59644 127192 27271 3801 70210 <null> 1715 8071 854 1084 59807 39461 272464 125500 284348 59105 87441 1645601 <null> 15:36:28 15:54:28
fetches per second 7 38788 <null> 34497 <null> <null> <null> 2236 <null> <null> <null> 34170 <null> <null> <null> <null> <null> <null> <null> <null> 16:12:30 16:30:30
fetches per second 8 17877 10517 16979 12630 26750 <null> 2680 <null> <null> <null> 21498 19639 42649 43830 138925 5736 37714 959635 <null> 16:30:31 16:48:31
fetches per second 9 41289 <null> 14077 <null> 77594 <null> 1389 <null> <null> <null> 86643 <null> 105560 <null> 275732 <null> 84581 2200833 <null> 16:48:32 17:06:32
fetches per second 10 20315 <null> <null> <null> <null> <null> 872 <null> <null> <null> 17266 <null> <null> <null> <null> <null> <null> <null> <null> 17:06:33 17:24:33
marks per second 1 709 2275 249 <null> 980 <null> 231 <null> 612 119 3088 <null> 1884 4071 591 <null> 696 2127 <null> 14:24:24 14:42:24
marks per second 3 11184 5562 1270 <null> 4321 <null> 61 <null> <null> 124 9030 <null> 2387 <null> 1864 5944 604 5138 <null> 15:00:26 15:18:26
marks per second 4 3386 <null> 1214 <null> 1192 <null> 43 <null> <null> 180 <null> <null> <null> <null> 4894 <null> 351 <null> <null> 15:18:27 15:36:27
marks per second 5 10131 11040 1495 387 4195 <null> 142 961 64 196 8929 4282 2592 13125 4782 5578 307 7906 <null> 15:36:28 15:54:28
marks per second 7 6811 <null> 2485 <null> <null> <null> 75 <null> <null> <null> 5292 <null> <null> <null> <null> <null> <null> <null> <null> 16:12:30 16:30:30
marks per second 8 3024 1006 864 1312 1436 <null> 68 <null> <null> <null> 2581 2115 1773 4365 663 577 152 3030 <null> 16:30:31 16:48:31
marks per second 9 7833 <null> 669 <null> 3754 <null> 94 <null> <null> <null> 7809 <null> 2733 <null> 4921 <null> 273 6666 <null> 16:48:32 17:06:32
marks per second 10 3369 <null> <null> <null> <null> <null> 65 <null> <null> <null> 3395 <null> <null> <null> <null> <null> <null> <null> <null> 17:06:33 17:24:33
reads/fetches*100 1 20 6 21 <null> 9 <null> 9 <null> 10 13 9 <null> 7 6 5 <null> 13 1 <null> 14:24:24 14:42:24
reads/fetches*100 3 4 5 8 <null> 6 <null> 8 <null> <null> 16 9 <null> 4 <null> 3 6 24 0 <null> 15:00:26 15:18:26
reads/fetches*100 4 6 <null> 8 <null> 7 <null> 9 <null> <null> 12 <null> <null> <null> <null> 3 <null> 27 <null> <null> 15:18:27 15:36:27
reads/fetches*100 5 4 4 7 4 6 <null> 12 4 15 10 7 3 4 3 3 3 27 0 <null> 15:36:28 15:54:28
reads/fetches*100 7 3 <null> 6 <null> <null> <null> 9 <null> <null> <null> 8 <null> <null> <null> <null> <null> <null> <null> <null> 16:12:30 16:30:30
reads/fetches*100 8 6 8 6 3 6 <null> 9 <null> <null> <null> 9 6 6 3 3 6 25 0 <null> 16:30:31 16:48:31
reads/fetches*100 9 6 <null> 6 <null> 6 <null> 12 <null> <null> <null> 9 <null> 7 <null> 3 <null> 29 0 <null> 16:48:32 17:06:32
reads/fetches*100 10 8 <null> <null> <null> <null> <null> 14 <null> <null> <null> 5 <null> <null> <null> <null> <null> <null> <null> <null> 17:06:33 17:24:33
writes/marks*100 1 7 11 6 <null> 6 <null> 2 <null> 21 4 7 <null> 4 0 2 <null> 35 0 <null> 14:24:24 14:42:24
writes/marks*100 3 12 11 9 <null> 6 <null> 2 <null> <null> 3 7 <null> 7 <null> 8 0 47 3 <null> 15:00:26 15:18:26
writes/marks*100 4 11 <null> 7 <null> 8 <null> 2 <null> <null> 4 <null> <null> <null> <null> 8 <null> 52 <null> <null> 15:18:27 15:36:27
writes/marks*100 5 14 13 8 4 7 <null> 2 3 3 2 8 12 11 0 4 0 49 2 <null> 15:36:28 15:54:28
writes/marks*100 7 12 <null> 8 <null> <null> <null> 2 <null> <null> <null> 7 <null> <null> <null> <null> <null> <null> <null> <null> 16:12:30 16:30:30
writes/marks*100 8 11 13 8 5 8 <null> 3 <null> <null> <null> 8 12 6 0 7 0 53 1 <null> 16:30:31 16:48:31
writes/marks*100 9 13 <null> 8 <null> 7 <null> 2 <null> <null> <null> 10 <null> 10 <null> 4 <null> 49 0 <null> 16:48:32 17:06:32
writes/marks*100 10 15 <null> <null> <null> <null> <null> 1 <null> <null> <null> 5 <null> <null> <null> <null> <null> <null> <null> <null> 17:06:33 17:24:33
Done for 7020 ms, from 17:25:33.67 to 17:25:40.69.

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 108043 101889 6154 5.69 0 4836 20 6154 2016-03-07 14:24 2016-03-07 17:24
doc_list_biud 108157 101888 6269 5.79 0 283636 258 6269 2016-03-07 14:24 2016-03-07 17:24
sp_add_invoice_to_stock 1740 743 997 57.29 4835 4664886 1063005 997 2016-03-07 14:24 2016-03-07 17:24
sp_cancel_adding_invoice 205 131 74 36.09 12 482275 39049 74 2016-03-07 14:24 2016-03-07 17:24
sp_cancel_client_order 608 551 57 9.37 0 764 42 57 2016-03-07 14:24 2016-03-07 17:24
sp_cancel_customer_reserve 9288 4516 4772 51.37 0 108933 1751 4772 2016-03-07 14:24 2016-03-07 17:24
sp_cancel_pay_from_customer 253 252 1 0.39 0 156 22 1 2016-03-07 14:24 2016-03-07 17:24
sp_cancel_pay_to_supplier 139 136 3 2.15 0 84 24 3 2016-03-07 14:24 2016-03-07 17:24
sp_cancel_supplier_invoice 402 303 99 24.62 0 2481 156 99 2016-03-07 14:24 2016-03-07 17:24
sp_cancel_supplier_order 110 43 67 60.90 63 991439 54649 67 2016-03-07 14:24 2016-03-07 17:24
sp_cancel_write_off 2539 1173 1366 53.80 0 967 46 1366 2016-03-07 14:24 2016-03-07 17:24
sp_client_order 7441 7441 0 0.00 0 36078 1036 0 2016-03-07 14:24 2016-03-07 17:24
sp_customer_reserve 137555 137555 0 0.00 0 56923 5637 0 2016-03-07 14:24 2016-03-07 17:24
sp_fill_shopping_cart 11351 11351 0 0.00 0 47121 784 0 2016-03-07 14:24 2016-03-07 17:24
sp_fill_shopping_cart_clo_res 137555 137555 0 0.00 0 359 3 0 2016-03-07 14:24 2016-03-07 17:24
sp_get_clo_for_invoice 743 743 0 0.00 0 1123 115 0 2016-03-07 14:24 2016-03-07 17:24
sp_kill_cost_storno 3068 1692 1376 44.85 0 218 6 1376 2016-03-07 14:24 2016-03-07 17:24
sp_kill_qstorno_ret_qs2qd 21433 10551 10882 50.77 0 108844 763 10882 2016-03-07 14:24 2016-03-07 17:24
sp_kill_qty_storno 17228 10989 6239 36.21 0 283636 2389 6239 2016-03-07 14:24 2016-03-07 17:24
sp_lock_selected_doc 7301 5998 1303 17.84 0 62 0 1303 2016-03-07 14:24 2016-03-07 17:24
sp_make_cost_storno 8989 8989 0 0.00 0 2543 96 0 2016-03-07 14:24 2016-03-07 17:24
sp_multiply_rows_for_pdistr 8989 8989 0 0.00 0 452 11 0 2016-03-07 14:24 2016-03-07 17:24
sp_multiply_rows_for_qdistr 7441 7441 0 0.00 0 34986 967 0 2016-03-07 14:24 2016-03-07 17:24
sp_pay_from_customer 2564 2564 0 0.00 31 1201 121 0 2016-03-07 14:24 2016-03-07 17:24
sp_pay_to_supplier 2153 2153 0 0.00 51 2730 298 0 2016-03-07 14:24 2016-03-07 17:24
sp_payment_common 4717 4717 0 0.00 0 297 30 0 2016-03-07 14:24 2016-03-07 17:24
sp_qd_handle_on_cancel_clo 608 551 57 9.37 0 718 20 57 2016-03-07 14:24 2016-03-07 17:24
sp_qd_handle_on_invoice_upd_sts 927 874 53 5.71 0 283636 20662 53 2016-03-07 14:24 2016-03-07 17:24
sp_qd_handle_on_reserve_upd_sts 3531 3529 2 0.05 0 390 15 2 2016-03-07 14:24 2016-03-07 17:24
sp_reserve_write_off 3570 3529 41 1.14 0 733 67 41 2016-03-07 14:24 2016-03-07 17:24
sp_supplier_invoice 1946 1946 0 0.00 31 47168 2112 0 2016-03-07 14:24 2016-03-07 17:24
sp_supplier_order 1964 1964 0 0.00 31 143263 8500 0 2016-03-07 14:24 2016-03-07 17:24
srv_find_qd_qs_mism 60086 53924 6162 10.25 0 4711 19 6162 2016-03-07 14:24 2016-03-07 17:24
srv_make_invnt_saldo 491 491 0 0.00 717 28391 6778 0 2016-03-07 14:24 2016-03-07 17:24
srv_make_money_saldo 516 516 0 0.00 0 125 14 0 2016-03-07 14:24 2016-03-07 17:24
srv_recalc_idx_stat 11 11 0 0.00 1623 2871 2120 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_add_invoice_to_stock 997 997 0 0.00 0 265 10 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_cancel_adding_invoice 247 247 0 0.00 0 156 40 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_cancel_client_order 57 57 0 0.00 0 265 17 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_cancel_customer_reserve 5 5 0 0.00 0 78 31 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_cancel_pay_from_customer 1 1 0 0.00 15 15 15 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_cancel_pay_to_supplier 3 3 0 0.00 0 141 47 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_cancel_supplier_invoice 80 80 0 0.00 0 57 7 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_cancel_supplier_order 539 539 0 0.00 0 359 48 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_cancel_write_off 4 4 0 0.00 0 31 7 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-abend:sp_reserve_write_off 41 41 0 0.00 0 47 8 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_add_invoice_to_stock 753 753 0 0.00 0 4446 496 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_cancel_adding_invoice 80 80 0 0.00 0 2028 191 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_cancel_client_order 551 551 0 0.00 0 265 15 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_cancel_customer_reserve 245 245 0 0.00 0 265 16 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_cancel_pay_from_customer 252 252 0 0.00 0 156 12 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_cancel_pay_to_supplier 136 136 0 0.00 0 172 11 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_cancel_supplier_invoice 59 59 0 0.00 0 78 10 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_cancel_supplier_order 44 44 0 0.00 10 2746 361 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_cancel_write_off 360 360 0 0.00 0 156 13 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_client_order 7475 7475 0 0.00 0 374 18 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_customer_reserve 355 355 0 0.00 0 203 15 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_pay_from_customer 2564 2564 0 0.00 0 249 12 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_pay_to_supplier 2153 2153 0 0.00 0 297 12 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_reserve_write_off 3529 3529 0 0.00 0 328 16 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_supplier_invoice 1946 1946 0 0.00 0 406 18 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:sp_supplier_order 2009 2009 0 0.00 0 343 20 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:srv_make_invnt_saldo 491 491 0 0.00 0 93 5 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:srv_make_money_saldo 516 516 0 0.00 0 109 3 0 2016-03-07 14:24 2016-03-07 17:24
t$perf-norm:srv_recalc_idx_stat 11 11 0 0.00 15 93 26 0 2016-03-07 14:24 2016-03-07 17:24
v_add_invoice_to_stock 3480 1486 1994 57.29 0 47 3 1994 2016-03-07 14:24 2016-03-07 17:24
v_all_customers 11126 11126 0 0.00 0 16 0 0 2016-03-07 14:24 2016-03-07 17:24
v_all_suppliers 7820 7820 0 0.00 0 16 0 0 2016-03-07 14:24 2016-03-07 17:24
v_all_wares 14882 14882 0 0.00 0 16 0 0 2016-03-07 14:24 2016-03-07 17:24
v_cancel_adding_invoice 256 160 96 37.50 0 63 7 96 2016-03-07 14:24 2016-03-07 17:24
v_cancel_client_order 1216 1102 114 9.37 0 16 0 114 2016-03-07 14:24 2016-03-07 17:24
v_cancel_customer_prepayment 506 504 2 0.39 0 31 1 2 2016-03-07 14:24 2016-03-07 17:24
v_cancel_customer_reserve 500 490 10 2.00 0 16 1 10 2016-03-07 14:24 2016-03-07 17:24
v_cancel_payment_to_supplier 278 272 6 2.15 0 16 1 6 2016-03-07 14:24 2016-03-07 17:24
v_cancel_supplier_invoice 278 118 160 57.55 0 31 3 160 2016-03-07 14:24 2016-03-07 17:24
v_cancel_supplier_order 220 86 134 60.90 0 31 1 134 2016-03-07 14:24 2016-03-07 17:24
v_cancel_write_off 728 720 8 1.09 0 47 3 8 2016-03-07 14:24 2016-03-07 17:24
v_max_id_clo_ord 1964 1964 0 0.00 0 1223 51 0 2016-03-07 14:24 2016-03-07 17:24
v_max_id_clo_res 355 355 0 0.00 0 31 3 0 2016-03-07 14:24 2016-03-07 17:24
v_max_id_ord_sup 1946 1946 0 0.00 0 297 8 0 2016-03-07 14:24 2016-03-07 17:24
v_max_non_paid_invoice 2153 2153 0 0.00 0 79 2 0 2016-03-07 14:24 2016-03-07 17:24
v_max_non_paid_realizn 2564 2564 0 0.00 0 63 5 0 2016-03-07 14:24 2016-03-07 17:24
v_min_id_clo_ord 1964 1964 0 0.00 0 1716 75 0 2016-03-07 14:24 2016-03-07 17:24
v_min_id_clo_res 355 355 0 0.00 0 62 2 0 2016-03-07 14:24 2016-03-07 17:24
v_min_id_ord_sup 1946 1946 0 0.00 0 1623 52 0 2016-03-07 14:24 2016-03-07 17:24
v_min_non_paid_invoice 2153 2153 0 0.00 0 281 29 0 2016-03-07 14:24 2016-03-07 17:24
v_min_non_paid_realizn 2564 2564 0 0.00 0 125 14 0 2016-03-07 14:24 2016-03-07 17:24
v_our_firm 3756 3756 0 0.00 0 16 0 0 2016-03-07 14:24 2016-03-07 17:24
v_reserve_write_off 7140 7058 82 1.14 0 63 1 82 2016-03-07 14:24 2016-03-07 17:24
x_lock_depdocs_on_canc_invoice 598 375 223 37.29 0 47 4 223 2016-03-07 14:24 2016-03-07 17:24
x_lock_depdocs_on_canc_sup_ord 110 43 67 60.90 0 16 2 67 2016-03-07 14:24 2016-03-07 17:24
x_make_qstorno_1000_1200 1971 1971 0 0.00 0 132916 5714 0 2016-03-07 14:24 2016-03-07 17:24
x_make_qstorno_1200_2000 1946 1946 0 0.00 0 10709 566 0 2016-03-07 14:24 2016-03-07 17:24
x_make_qstorno_2100_3300 137555 137555 0 0.00 0 56907 5625 0 2016-03-07 14:24 2016-03-07 17:24
Done for 19830 ms, from 17:25:51.83 to 17:26:11.66.

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 5 sp_kill_cost_storno 335544336 2016-03-07 14:29 2016-03-07 16:40
deadlock 1 sp_lock_selected_doc 335544336 2016-03-07 15:09 2016-03-07 15:09
deadlock 5 sp_qd_handle_on_invoice_upd_sts 335544336 2016-03-07 14:27 2016-03-07 16:14
lock_conflict 4 sp_kill_cost_storno 335544345 2016-03-07 14:26 2016-03-07 15:38
lock_conflict 1 sp_kill_qstorno_ret_qs2qd 335544345 2016-03-07 14:41 2016-03-07 14:41
lock_conflict 1124 sp_lock_selected_doc 335544345 2016-03-07 14:24 2016-03-07 17:22
lock_conflict 57 sp_qd_handle_on_cancel_clo 335544345 2016-03-07 14:25 2016-03-07 17:24
lock_conflict 32 sp_qd_handle_on_invoice_upd_sts 335544345 2016-03-07 14:26 2016-03-07 17:16
lock_conflict 2 sp_qd_handle_on_reserve_upd_sts 335544345 2016-03-07 16:00 2016-03-07 16:14
lock_conflict 44 x_lock_depdocs_on_canc_invoice 335544345 2016-03-07 14:26 2016-03-07 16:46
lock_conflict 28 x_lock_depdocs_on_canc_sup_ord 335544345 2016-03-07 14:27 2016-03-07 17:12
Done for 2510 ms, from 17:26:12.52 to 17:26:15.03.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP25-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 101187
MON$OLDEST_ACTIVE 101188
MON$OLDEST_SNAPSHOT 101188
MON$NEXT_TRANSACTION 101188
MON$PAGE_BUFFERS 384
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-12-11 10:02:47.3010
MON$PAGES 196183
MON$STAT_ID 1
MON$BACKUP_STATE 0
ISQL Version: WI-V2.5.6.26979 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.6.26979 Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.6.26979 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.6.26979 Firebird 2.5/tcp (WIN-2BE1UI8LGDL)/P12"
on disk structure version 11.2

Database statistics, full


Database "D:\OLTP-EMUL\oltp25-small.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 105684
Page size 8192
ODS version 11.2
Oldest transaction 101189
Oldest active 101190
Oldest snapshot 101190
Next transaction 101191
Bumped transaction 1
Sequence number 0
Next attachment ID 4460
Implementation ID 24
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 11, 2015 10:02:47
Attributes force write

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File D:\OLTP-EMUL\oltp25-small.fdb is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 259, Index root page: 260
Average record length: 34.62, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 32%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 48
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 0.06, total dup: 48, max dup: 47
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 13.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Depth: 1, leaf buckets: 1, nodes: 50
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 280, Index root page: 281
Average record length: 103.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 28%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 0.84, total dup: 7, max dup: 3
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Depth: 1, leaf buckets: 1, nodes: 19
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 199, Index root page: 200
Average record length: 43.13, total records: 546000
Average version length: 46.06, total versions: 34982, max versions: 1
Data pages: 5800, data page slots: 5800, average fill: 74%
Fill distribution:
0 - 19% = 3
20 - 39% = 11
40 - 59% = 75
60 - 79% = 5510
80 - 99% = 201

Index DOC_DATA_DOC_WARE_UNQ (1)
Depth: 3, leaf buckets: 1911, nodes: 546000
Average data length: 12.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 151
20 - 39% = 38
40 - 59% = 991
60 - 79% = 85
80 - 99% = 646

Index DOC_DATA_ID_DESC (2)
Depth: 3, leaf buckets: 1596, nodes: 546000
Average data length: 5.93, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 26
40 - 59% = 1570
60 - 79% = 0
80 - 99% = 0

Index FK_DOC_DATA_DOC_LIST (3)
Depth: 3, leaf buckets: 602, nodes: 546000
Average data length: 1.05, total dup: 454904, max dup: 49
Fill distribution:
0 - 19% = 15
20 - 39% = 22
40 - 59% = 332
60 - 79% = 3
80 - 99% = 230

DOC_LIST (140)
Primary pointer page: 195, Index root page: 196
Average record length: 57.60, total records: 104587
Average version length: 44.37, total versions: 12335, max versions: 5
Data pages: 1331, data page slots: 1331, average fill: 79%
Fill distribution:
0 - 19% = 5
20 - 39% = 31
40 - 59% = 35
60 - 79% = 610
80 - 99% = 650

Index DOC_LIST_ID_DESC (1)
Depth: 2, leaf buckets: 305, nodes: 104587
Average data length: 6.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 11
40 - 59% = 293
60 - 79% = 1
80 - 99% = 0

Index FK_DOC_LIST_AGENTS (2)
Depth: 2, leaf buckets: 86, nodes: 104587
Average data length: 0.01, total dup: 104537, max dup: 20256
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 49
60 - 79% = 17
80 - 99% = 19

Index PK_DOC_LIST (0)
Depth: 2, leaf buckets: 240, nodes: 104587
Average data length: 6.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 5
20 - 39% = 11
40 - 59% = 153
60 - 79% = 0
80 - 99% = 71

DOC_STATES (153)
Primary pointer page: 257, Index root page: 258
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 13.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 29.75, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 1.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 287, Index root page: 288
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 12, data page slots: 12, average fill: 75%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 758
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 216, Index root page: 217
Average record length: 62.28, total records: 400
Average version length: 14.39, total versions: 122518, max versions: 356
Data pages: 495, data page slots: 495, average fill: 96%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 495

Index PK_INVNT_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 278, Index root page: 279
Average record length: 0.25, total records: 124070
Average version length: 68.37, total versions: 123625, max versions: 1
Data pages: 2463, data page slots: 2692, average fill: 65%
Fill distribution:
0 - 19% = 535
20 - 39% = 159
40 - 59% = 113
60 - 79% = 307
80 - 99% = 1349

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Depth: 3, leaf buckets: 402, nodes: 124070
Average data length: 8.43, total dup: 11568, max dup: 4
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 323
60 - 79% = 71
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 208, Index root page: 209
Average record length: 14.67, total records: 49
Average version length: 9.00, total versions: 6386, max versions: 552
Data pages: 23, data page slots: 23, average fill: 89%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 22

Index PK_MONEY_SALDO (0)
Depth: 1, leaf buckets: 1, nodes: 49
Average data length: 7.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 206, Index root page: 207
Average record length: 0.24, total records: 5326
Average version length: 44.34, total versions: 5298, max versions: 1
Data pages: 74, data page slots: 81, average fill: 71%
Fill distribution:
0 - 19% = 18
20 - 39% = 2
40 - 59% = 0
60 - 79% = 0
80 - 99% = 54

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Depth: 2, leaf buckets: 6, nodes: 5326
Average data length: 0.18, total dup: 5238, max dup: 1102
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 3
60 - 79% = 1
80 - 99% = 0

MON_LOG (164)
Primary pointer page: 303, Index root page: 304
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (165)
Primary pointer page: 316, Index root page: 317
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 186, Index root page: 187
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 9%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 4.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Depth: 1, leaf buckets: 1, nodes: 9
Average data length: 2.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 241, Index root page: 242
Average record length: 25.93, total records: 127737
Average version length: 33.83, total versions: 74268, max versions: 10
Data pages: 1461, data page slots: 1461, average fill: 79%
Fill distribution:
0 - 19% = 2
20 - 39% = 36
40 - 59% = 108
60 - 79% = 483
80 - 99% = 832

Index PDISTR_AGENT_ID (4)
Depth: 2, leaf buckets: 110, nodes: 127737
Average data length: 0.01, total dup: 127688, max dup: 24972
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 63
60 - 79% = 20
80 - 99% = 22

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Depth: 2, leaf buckets: 135, nodes: 127737
Average data length: 0.90, total dup: 114939, max dup: 34
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 72
60 - 79% = 34
80 - 99% = 24

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Depth: 2, leaf buckets: 145, nodes: 127737
Average data length: 0.90, total dup: 114939, max dup: 34
Fill distribution:
0 - 19% = 0
20 - 39% = 9
40 - 59% = 83
60 - 79% = 38
80 - 99% = 15

Index PDISTR_SND_ID (1)
Depth: 2, leaf buckets: 142, nodes: 127737
Average data length: 0.67, total dup: 114939, max dup: 34
Fill distribution:
0 - 19% = 1
20 - 39% = 24
40 - 59% = 62
60 - 79% = 44
80 - 99% = 11

PERF_ESTIMATED (160)
Primary pointer page: 289, Index root page: 290
Average record length: 27.71, total records: 31608
Average version length: 18.00, total versions: 2, max versions: 1
Data pages: 273, data page slots: 273, average fill: 63%
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 0
60 - 79% = 269
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Depth: 2, leaf buckets: 23, nodes: 31608
Average data length: 0.01, total dup: 31420, max dup: 1162
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 8
60 - 79% = 11
80 - 99% = 4

PERF_ISQL_STAT (161)
Primary pointer page: 296, Index root page: 297
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (162)
Primary pointer page: 299, Index root page: 300
Average record length: 146.50, total records: 1766702
Average version length: 153.00, total versions: 1, max versions: 1
Data pages: 40825, data page slots: 40825, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 40824

Index PERF_LOG_DTS_BEG_DESC (0)
Depth: 3, leaf buckets: 2078, nodes: 1766702
Average data length: 0.57, total dup: 1059015, max dup: 34
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1379
60 - 79% = 423
80 - 99% = 276

Index PERF_LOG_GDSCODE (3)
Depth: 3, leaf buckets: 1755, nodes: 1766702
Average data length: 0.00, total dup: 1766697, max dup: 1697526
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1753
60 - 79% = 2
80 - 99% = 0

Index PERF_LOG_TRN_DESC (2)
Depth: 3, leaf buckets: 2102, nodes: 1766702
Average data length: 0.30, total dup: 1684338, max dup: 5651
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1706
60 - 79% = 216
80 - 99% = 180

Index PERF_LOG_UNIT (1)
Depth: 3, leaf buckets: 1984, nodes: 1766702
Average data length: 0.35, total dup: 1706742, max dup: 187928
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 1402
60 - 79% = 305
80 - 99% = 272

PHRASES (145)
Primary pointer page: 212, Index root page: 213
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 248, Index root page: 249
Average record length: 49.32, total records: 100630
Average version length: 54.64, total versions: 10204, max versions: 1
Data pages: 1176, data page slots: 1176, average fill: 77%
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 2
60 - 79% = 1030
80 - 99% = 142

Index PSTORNED_RCV_ID (2)
Depth: 2, leaf buckets: 124, nodes: 100630
Average data length: 1.13, total dup: 83541, max dup: 245
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 111
60 - 79% = 12
80 - 99% = 1

Index PSTORNED_SND_ID (1)
Depth: 2, leaf buckets: 89, nodes: 100630
Average data length: 0.62, total dup: 91556, max dup: 86
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 40
60 - 79% = 33
80 - 99% = 16

RULES_FOR_PDISTR (152)
Primary pointer page: 250, Index root page: 251
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_PDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 7.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 190, Index root page: 191
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 1.57, total dup: 2, max dup: 2
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 6.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 263, Index root page: 264
Average record length: 34.25, total records: 4
Average version length: 9.00, total versions: 1321, max versions: 665
Data pages: 5, data page slots: 5, average fill: 85%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 4

Index PK_SEMAPHORES (0)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 8.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 4
Average data length: 18.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 183, Index root page: 184
Average record length: 97.51, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2, data page slots: 2, average fill: 80%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Depth: 1, leaf buckets: 1, nodes: 114
Average data length: 23.07, total dup: 0, max dup: 0
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: 180, Index root page: 181
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 178, Index root page: 179
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 159, Index root page: 160
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 169, Index root page: 170
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 174, Index root page: 175
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 176, Index root page: 177
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (163)
Primary pointer page: 301, Index root page: 302
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 167, Index root page: 168
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 162, Index root page: 163
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 155, Index root page: 156
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (276)
Primary pointer page: 513, Index root page: 95177
Average record length: 59.78, total records: 459
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 72%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 5
80 - 99% = 0

WARES (144)
Primary pointer page: 210, Index root page: 211
Average record length: 78.00, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 6, data page slots: 6, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 0.14, total dup: 392, max dup: 62
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Depth: 1, leaf buckets: 1, nodes: 400
Average data length: 7.22, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Depth: 2, leaf buckets: 2, nodes: 400
Average data length: 19.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 261, Index root page: 262
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 7.25, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Depth: 1, leaf buckets: 1, nodes: 8
Average data length: 15.88, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (258)
Primary pointer page: 645, Index root page: 646
Average record length: 0.02, total records: 167551
Average version length: 69.42, total versions: 167503, max versions: 1
Data pages: 2565, data page slots: 3228, average fill: 83%
Fill distribution:
0 - 19% = 269
20 - 39% = 54
40 - 59% = 29
60 - 79% = 19
80 - 99% = 2194

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 265, nodes: 167551
Average data length: 1.24, total dup: 146675, max dup: 29
Fill distribution:
0 - 19% = 4
20 - 39% = 114
40 - 59% = 58
60 - 79% = 85
80 - 99% = 4

XQD_1000_3300 (260)
Primary pointer page: 653, Index root page: 654
Average record length: 54.78, total records: 281071
Average version length: 69.19, total versions: 58900, max versions: 1
Data pages: 3978, data page slots: 4114, average fill: 79%
Fill distribution:
0 - 19% = 15
20 - 39% = 51
40 - 59% = 167
60 - 79% = 1842
80 - 99% = 1903

Index XQD_1000_3300_DOC (1)
Depth: 2, leaf buckets: 269, nodes: 281071
Average data length: 0.18, total dup: 273662, max dup: 129
Fill distribution:
0 - 19% = 1
20 - 39% = 62
40 - 59% = 95
60 - 79% = 13
80 - 99% = 98

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 366, nodes: 281071
Average data length: 1.28, total dup: 245528, max dup: 38
Fill distribution:
0 - 19% = 6
20 - 39% = 6
40 - 59% = 207
60 - 79% = 109
80 - 99% = 38

XQD_1200_2000 (259)
Primary pointer page: 648, Index root page: 649
Average record length: 0.22, total records: 214541
Average version length: 69.37, total versions: 213876, max versions: 1
Data pages: 2890, data page slots: 3955, average fill: 94%
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 2
60 - 79% = 7
80 - 99% = 2876

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 365, nodes: 214541
Average data length: 1.08, total dup: 191791, max dup: 112
Fill distribution:
0 - 19% = 8
20 - 39% = 159
40 - 59% = 158
60 - 79% = 37
80 - 99% = 3

XQD_2000_3300 (261)
Primary pointer page: 657, Index root page: 658
Average record length: 17.72, total records: 1195463
Average version length: 68.38, total versions: 889667, max versions: 1
Data pages: 16111, data page slots: 16111, average fill: 89%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 3716
80 - 99% = 12395

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1573, nodes: 1195463
Average data length: 1.11, total dup: 1060372, max dup: 95
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1287
60 - 79% = 168
80 - 99% = 117

XQD_2100_3300 (262)
Primary pointer page: 661, Index root page: 662
Average record length: 3.07, total records: 127823
Average version length: 69.17, total versions: 122158, max versions: 1
Data pages: 3576, data page slots: 4887, average fill: 46%
Fill distribution:
0 - 19% = 1363
20 - 39% = 361
40 - 59% = 411
60 - 79% = 328
80 - 99% = 1113

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 249, nodes: 127823
Average data length: 1.44, total dup: 110510, max dup: 99
Fill distribution:
0 - 19% = 1
20 - 39% = 122
40 - 59% = 119
60 - 79% = 7
80 - 99% = 0

XQD_3300_3400 (263)
Primary pointer page: 664, Index root page: 665
Average record length: 38.28, total records: 922487
Average version length: 68.53, total versions: 409919, max versions: 1
Data pages: 12791, data page slots: 12809, average fill: 83%
Fill distribution:
0 - 19% = 95
20 - 39% = 141
40 - 59% = 282
60 - 79% = 4024
80 - 99% = 8249

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Depth: 3, leaf buckets: 1328, nodes: 922487
Average data length: 1.39, total dup: 790792, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 9
40 - 59% = 1076
60 - 79% = 127
80 - 99% = 116

XQS_1000_1200 (264)
Primary pointer page: 667, Index root page: 668
Average record length: 77.83, total records: 1109991
Average version length: 80.57, total versions: 37116, max versions: 1
Data pages: 16550, data page slots: 16550, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 6375
80 - 99% = 10174

Index XQS_1000_1200_DOC_ID (0)
Depth: 3, leaf buckets: 1222, nodes: 1109991
Average data length: 0.16, total dup: 1084848, max dup: 149
Fill distribution:
0 - 19% = 6
20 - 39% = 0
40 - 59% = 887
60 - 79% = 268
80 - 99% = 61

Index XQS_1000_1200_RCV_ID (2)
Depth: 3, leaf buckets: 898, nodes: 1109991
Average data length: 0.71, total dup: 977449, max dup: 49
Fill distribution:
0 - 19% = 4
20 - 39% = 0
40 - 59% = 176
60 - 79% = 25
80 - 99% = 693

Index XQS_1000_1200_SND_ID (1)
Depth: 3, leaf buckets: 1392, nodes: 1109991
Average data length: 0.74, total dup: 972356, max dup: 40
Fill distribution:
0 - 19% = 10
20 - 39% = 0
40 - 59% = 1000
60 - 79% = 316
80 - 99% = 66

XQS_1000_3300 (266)
Primary pointer page: 678, Index root page: 679
Average record length: 61.93, total records: 762302
Average version length: 80.26, total versions: 175175, max versions: 1
Data pages: 11487, data page slots: 11503, average fill: 82%
Fill distribution:
0 - 19% = 54
20 - 39% = 45
40 - 59% = 87
60 - 79% = 3693
80 - 99% = 7608

Index XQS_1000_3300_DOC_ID (0)
Depth: 3, leaf buckets: 716, nodes: 762302
Average data length: 0.14, total dup: 747412, max dup: 355
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 222
60 - 79% = 380
80 - 99% = 113

Index XQS_1000_3300_RCV_ID (2)
Depth: 3, leaf buckets: 680, nodes: 762302
Average data length: 0.86, total dup: 657267, max dup: 14
Fill distribution:
0 - 19% = 12
20 - 39% = 11
40 - 59% = 190
60 - 79% = 3
80 - 99% = 464

Index XQS_1000_3300_SND_ID (1)
Depth: 3, leaf buckets: 831, nodes: 762302
Average data length: 0.63, total dup: 683993, max dup: 71
Fill distribution:
0 - 19% = 33
20 - 39% = 1
40 - 59% = 263
60 - 79% = 423
80 - 99% = 111

XQS_1200_2000 (265)
Primary pointer page: 673, Index root page: 674
Average record length: 74.72, total records: 1186714
Average version length: 80.90, total versions: 85882, max versions: 1
Data pages: 17695, data page slots: 17695, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 7310
80 - 99% = 10384

Index XQS_1200_2000_DOC_ID (0)
Depth: 3, leaf buckets: 1221, nodes: 1186714
Average data length: 0.05, total dup: 1179842, max dup: 855
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 772
60 - 79% = 336
80 - 99% = 109

Index XQS_1200_2000_RCV_ID (2)
Depth: 3, leaf buckets: 885, nodes: 1186714
Average data length: 0.67, total dup: 1051259, max dup: 49
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 69
60 - 79% = 2
80 - 99% = 812

Index XQS_1200_2000_SND_ID (1)
Depth: 3, leaf buckets: 1380, nodes: 1186714
Average data length: 0.67, total dup: 1054267, max dup: 146
Fill distribution:
0 - 19% = 6
20 - 39% = 2
40 - 59% = 819
60 - 79% = 417
80 - 99% = 136

XQS_2000_3300 (267)
Primary pointer page: 683, Index root page: 684
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (268)
Primary pointer page: 691, Index root page: 692
Average record length: 65.41, total records: 972506
Average version length: 80.35, total versions: 183135, max versions: 1
Data pages: 14825, data page slots: 14859, average fill: 81%
Fill distribution:
0 - 19% = 130
20 - 39% = 147
40 - 59% = 184
60 - 79% = 4200
80 - 99% = 10164

Index XQS_2100_3300_DOC_ID (0)
Depth: 3, leaf buckets: 910, nodes: 972506
Average data length: 0.04, total dup: 967598, max dup: 890
Fill distribution:
0 - 19% = 2
20 - 39% = 16
40 - 59% = 361
60 - 79% = 359
80 - 99% = 172

Index XQS_2100_3300_RCV_ID (2)
Depth: 3, leaf buckets: 1016, nodes: 972506
Average data length: 0.90, total dup: 832713, max dup: 14
Fill distribution:
0 - 19% = 40
20 - 39% = 23
40 - 59% = 464
60 - 79% = 4
80 - 99% = 485

Index XQS_2100_3300_SND_ID (1)
Depth: 3, leaf buckets: 1012, nodes: 972506
Average data length: 0.61, total dup: 874357, max dup: 86
Fill distribution:
0 - 19% = 2
20 - 39% = 11
40 - 59% = 369
60 - 79% = 419
80 - 99% = 211

XQS_3300_3400 (269)
Primary pointer page: 697, Index root page: 698
Average record length: 52.99, total records: 357751
Average version length: 68.25, total versions: 80948, max versions: 1
Data pages: 4817, data page slots: 4817, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2919
80 - 99% = 1898

Index XQS_3300_3400_DOC_ID (0)
Depth: 2, leaf buckets: 332, nodes: 357751
Average data length: 0.23, total dup: 346006, max dup: 199
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 127
60 - 79% = 129
80 - 99% = 75

Index XQS_3300_3400_SND_ID (1)
Depth: 2, leaf buckets: 379, nodes: 357751
Average data length: 0.82, total dup: 311195, max dup: 29
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 144
60 - 79% = 163
80 - 99% = 72

ZDOC_DATA (228)
Primary pointer page: 564, Index root page: 565
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (227)
Primary pointer page: 560, Index root page: 561
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (229)
Primary pointer page: 567, Index root page: 568
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (232)
Primary pointer page: 573, Index root page: 574
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (233)
Primary pointer page: 575, Index root page: 576
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (230)
Primary pointer page: 569, Index root page: 570
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (231)
Primary pointer page: 571, Index root page: 572
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Depth: 1, leaf buckets: 1, nodes: 0
Average data length: 0.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (226)
Primary pointer page: 558, Index root page: 559
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (225)
Primary pointer page: 556, Index root page: 557
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 0, data page slots: 0, average fill: 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: 214, Index root page: 215
Average record length: 29.19, total records: 32
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 1, data page slots: 1, average fill: 18%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Depth: 1, leaf buckets: 1, nodes: 32
Average data length: 10.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 3160 ms, from 17:26:15.63 to 17:26:18.79.

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 546000 34982 6.4069
DOC_LIST 104587 12335 11.7940
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 122518 30629.5000
INVNT_TURNOVER_LOG 124070 123625 99.6413
MONEY_SALDO 49 6386 13032.6530
MONEY_TURNOVER_LOG 5326 5298 99.4742
OPTYPES 9 0 0.0000
PDISTR 127737 74268 58.1413
PERF_ESTIMATED 31608 2 0.0063
PERF_LOG 1766702 1 0.0000
PSTORNED 100630 10204 10.1401
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 1321 33025.0000
SETTINGS 114 0 0.0000
TRACE_STAT 459 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 167551 167503 99.9713
XQD_1000_3300 281071 58900 20.9555
XQD_1200_2000 214541 213876 99.6900
XQD_2000_3300 1195463 889667 74.4202
XQD_2100_3300 127823 122158 95.5680
XQD_3300_3400 922487 409919 44.4362
XQS_1000_1200 1109991 37116 3.3438
XQS_1000_3300 762302 175175 22.9797
XQS_1200_2000 1186714 85882 7.2369
XQS_2100_3300 972506 183135 18.8312
XQS_3300_3400 357751 80948 22.6269
Z_USED_VIEWS 32 0 0.0000
Done for 2170 ms, from 17:26:28.30 to 17:26:30.47.

Database validation

17:26:30.57 Validation started

17:26:30.57 Relation 140 (DOC_LIST)
17:26:30.57 process pointer page 0 of 1
17:26:30.65 Index 1 (PK_DOC_LIST)
17:26:30.68 Index 2 (DOC_LIST_ID_DESC)
17:26:30.69 Index 3 (FK_DOC_LIST_AGENTS)
17:26:30.70 Relation 140 (DOC_LIST) is ok

17:26:30.70 Relation 141 (DOC_DATA)
17:26:30.70 process pointer page 0 of 4
17:26:30.74 process pointer page 1 of 4
17:26:30.78 process pointer page 2 of 4
17:26:30.82 process pointer page 3 of 4
17:26:30.82 Index 2 (DOC_DATA_DOC_WARE_UNQ)
17:26:30.90 Index 3 (DOC_DATA_ID_DESC)
17:26:30.97 Index 4 (FK_DOC_DATA_DOC_LIST)
17:26:31.01 Relation 141 (DOC_DATA) is ok

17:26:31.01 Relation 147 (INVNT_SALDO)
17:26:31.01 process pointer page 0 of 1
17:26:31.18 Index 1 (PK_INVNT_SALDO)
17:26:31.18 Relation 147 (INVNT_SALDO) is ok

17:26:31.18 Relation 150 (PDISTR)
17:26:31.18 process pointer page 0 of 1
17:26:31.22 Index 2 (PDISTR_SND_ID)
17:26:31.23 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
17:26:31.24 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
17:26:31.25 Index 5 (PDISTR_AGENT_ID)
17:26:31.26 Relation 150 (PDISTR) is ok

17:26:31.26 Relation 151 (PSTORNED)
17:26:31.26 process pointer page 0 of 1
17:26:31.28 Index 2 (PSTORNED_SND_ID)
17:26:31.28 Index 3 (PSTORNED_RCV_ID)
17:26:31.29 Relation 151 (PSTORNED) is ok

17:26:31.29 Relation 156 (SEMAPHORES)
17:26:31.29 process pointer page 0 of 1
17:26:31.29 Index 1 (PK_SEMAPHORES)
17:26:31.29 Index 2 (SEMAPHORES_TASK_UNQ)
17:26:31.29 Relation 156 (SEMAPHORES) is ok

17:26:31.29 Relation 157 (INVNT_TURNOVER_LOG)
17:26:31.29 process pointer page 0 of 2
17:26:31.32 process pointer page 1 of 2
17:26:31.34 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
17:26:31.36 Relation 157 (INVNT_TURNOVER_LOG) is ok

17:26:31.36 Relation 160 (PERF_ESTIMATED)
17:26:31.36 process pointer page 0 of 1
17:26:31.36 Index 1 (PERF_EST_MINUTE_SINCE_START)
17:26:31.37 Relation 160 (PERF_ESTIMATED) is ok

17:26:31.37 Relation 161 (PERF_ISQL_STAT)
17:26:31.37 process pointer page 0 of 1
17:26:31.37 Index 1 (PERF_ISQL_STAT_TRN)
17:26:31.37 Relation 161 (PERF_ISQL_STAT) is ok

17:26:31.37 Relation 162 (PERF_LOG)
17:26:31.37 process pointer page 0 of 22
17:26:31.39 process pointer page 1 of 22
17:26:31.41 process pointer page 2 of 22
17:26:31.44 process pointer page 3 of 22
17:26:31.47 process pointer page 4 of 22
17:26:31.49 process pointer page 5 of 22
17:26:31.51 process pointer page 6 of 22
17:26:31.53 process pointer page 7 of 22
17:26:31.56 process pointer page 8 of 22
17:26:31.58 process pointer page 9 of 22
17:26:31.60 process pointer page 10 of 22
17:26:31.62 process pointer page 11 of 22
17:26:31.64 process pointer page 12 of 22
17:26:31.66 process pointer page 13 of 22
17:26:31.68 process pointer page 14 of 22
17:26:31.70 process pointer page 15 of 22
17:26:31.72 process pointer page 16 of 22
17:26:31.74 process pointer page 17 of 22
17:26:31.76 process pointer page 18 of 22
17:26:31.78 process pointer page 19 of 22
17:26:31.79 process pointer page 20 of 22
17:26:31.81 process pointer page 21 of 22
17:26:31.82 Index 1 (PERF_LOG_DTS_BEG_DESC)
17:26:31.97 Index 2 (PERF_LOG_UNIT)
17:26:32.30 Index 3 (PERF_LOG_TRN_DESC)
17:26:32.78 Index 4 (PERF_LOG_GDSCODE)
17:26:33.01 Relation 162 (PERF_LOG) is ok

17:26:33.01 Relation 166 (V_STOPTEST)
17:26:33.01 Relation 166 (V_STOPTEST) is ok

17:26:33.01 Relation 183 (V_QDISTR_SOURCE)
17:26:33.01 Relation 183 (V_QDISTR_SOURCE) is ok

17:26:33.01 Relation 184 (V_QSTORNED_SOURCE)
17:26:33.01 Relation 184 (V_QSTORNED_SOURCE) is ok

17:26:33.01 Relation 258 (XQD_1000_1200)
17:26:33.03 process pointer page 0 of 2
17:26:33.08 process pointer page 1 of 2
17:26:33.11 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
17:26:33.12 Relation 258 (XQD_1000_1200) is ok

17:26:33.12 Relation 259 (XQD_1200_2000)
17:26:33.12 process pointer page 0 of 3
17:26:33.19 process pointer page 1 of 3
17:26:33.22 process pointer page 2 of 3
17:26:33.23 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
17:26:33.25 Relation 259 (XQD_1200_2000) is ok

17:26:33.25 Relation 260 (XQD_1000_3300)
17:26:33.25 process pointer page 0 of 3
17:26:33.28 process pointer page 1 of 3
17:26:33.31 process pointer page 2 of 3
17:26:33.31 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
17:26:33.34 Index 2 (XQD_1000_3300_DOC)
17:26:33.36 Relation 260 (XQD_1000_3300) is ok

17:26:33.36 Relation 261 (XQD_2000_3300)
17:26:33.36 process pointer page 0 of 9
17:26:33.48 process pointer page 1 of 9
17:26:33.58 process pointer page 2 of 9
17:26:33.64 process pointer page 3 of 9
17:26:33.72 process pointer page 4 of 9
17:26:33.78 process pointer page 5 of 9
17:26:33.83 process pointer page 6 of 9
17:26:33.86 process pointer page 7 of 9
17:26:33.89 process pointer page 8 of 9
17:26:33.90 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
17:26:34.00 Relation 261 (XQD_2000_3300) is ok

17:26:34.00 Relation 262 (XQD_2100_3300)
17:26:34.00 process pointer page 0 of 3
17:26:34.03 process pointer page 1 of 3
17:26:34.04 process pointer page 2 of 3
17:26:34.06 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
17:26:34.07 Relation 262 (XQD_2100_3300) is ok

17:26:34.07 Relation 263 (XQD_3300_3400)
17:26:34.07 process pointer page 0 of 7
17:26:34.11 process pointer page 1 of 7
17:26:34.15 process pointer page 2 of 7
17:26:34.18 process pointer page 3 of 7
17:26:34.22 process pointer page 4 of 7
17:26:34.25 process pointer page 5 of 7
17:26:34.28 process pointer page 6 of 7
17:26:34.31 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
17:26:34.39 Relation 263 (XQD_3300_3400) is ok

17:26:34.39 Relation 264 (XQS_1000_1200)
17:26:34.39 process pointer page 0 of 9
17:26:34.42 process pointer page 1 of 9
17:26:34.45 process pointer page 2 of 9
17:26:34.51 process pointer page 3 of 9
17:26:34.56 process pointer page 4 of 9
17:26:34.59 process pointer page 5 of 9
17:26:34.62 process pointer page 6 of 9
17:26:34.67 process pointer page 7 of 9
17:26:34.70 process pointer page 8 of 9
17:26:34.71 Index 1 (XQS_1000_1200_DOC_ID)
17:26:34.81 Index 2 (XQS_1000_1200_SND_ID)
17:26:34.90 Index 3 (XQS_1000_1200_RCV_ID)
17:26:34.96 Relation 264 (XQS_1000_1200) is ok

17:26:34.96 Relation 265 (XQS_1200_2000)
17:26:34.96 process pointer page 0 of 10
17:26:34.98 process pointer page 1 of 10
17:26:35.01 process pointer page 2 of 10
17:26:35.03 process pointer page 3 of 10
17:26:35.06 process pointer page 4 of 10
17:26:35.07 process pointer page 5 of 10
17:26:35.10 process pointer page 6 of 10
17:26:35.14 process pointer page 7 of 10
17:26:35.17 process pointer page 8 of 10
17:26:35.18 process pointer page 9 of 10
17:26:35.20 Index 1 (XQS_1200_2000_DOC_ID)
17:26:35.28 Index 2 (XQS_1200_2000_SND_ID)
17:26:35.35 Index 3 (XQS_1200_2000_RCV_ID)
17:26:35.43 Relation 265 (XQS_1200_2000) is ok

17:26:35.43 Relation 266 (XQS_1000_3300)
17:26:35.43 process pointer page 0 of 6
17:26:35.48 process pointer page 1 of 6
17:26:35.51 process pointer page 2 of 6
17:26:35.59 process pointer page 3 of 6
17:26:35.68 process pointer page 4 of 6
17:26:35.73 process pointer page 5 of 6
17:26:35.76 Index 1 (XQS_1000_3300_DOC_ID)
17:26:35.84 Index 2 (XQS_1000_3300_SND_ID)
17:26:35.90 Index 3 (XQS_1000_3300_RCV_ID)
17:26:35.96 Relation 266 (XQS_1000_3300) is ok

17:26:35.96 Relation 267 (XQS_2000_3300)
17:26:35.96 process pointer page 0 of 1
17:26:35.96 Index 1 (XQS_2000_3300_DOC_ID)
17:26:35.96 Index 2 (XQS_2000_3300_SND_ID)
17:26:35.96 Index 3 (XQS_2000_3300_RCV_ID)
17:26:35.96 Relation 267 (XQS_2000_3300) is ok

17:26:35.96 Relation 268 (XQS_2100_3300)
17:26:35.96 process pointer page 0 of 8
17:26:35.99 process pointer page 1 of 8
17:26:36.02 process pointer page 2 of 8
17:26:36.06 process pointer page 3 of 8
17:26:36.07 process pointer page 4 of 8
17:26:36.18 process pointer page 5 of 8
17:26:36.21 process pointer page 6 of 8
17:26:36.29 process pointer page 7 of 8
17:26:36.31 Index 1 (XQS_2100_3300_DOC_ID)
17:26:36.43 Index 2 (XQS_2100_3300_SND_ID)
17:26:36.54 Index 3 (XQS_2100_3300_RCV_ID)
17:26:36.60 Relation 268 (XQS_2100_3300) is ok

17:26:36.60 Relation 269 (XQS_3300_3400)
17:26:36.60 process pointer page 0 of 3
17:26:36.63 process pointer page 1 of 3
17:26:36.66 process pointer page 2 of 3
17:26:36.68 Index 1 (XQS_3300_3400_DOC_ID)
17:26:36.70 Index 2 (XQS_3300_3400_SND_ID)
17:26:36.73 Relation 269 (XQS_3300_3400) is ok

17:26:36.73 Relation 276 (TRACE_STAT)
17:26:36.73 process pointer page 0 of 1
17:26:36.73 Relation 276 (TRACE_STAT) is ok

17:26:36.73 Validation finished
Done for 6240 ms, from 17:26:30.50 to 17:26:36.74.

Differences between old and current firebird.log

17:26:37.23. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP25\OLTP25_FB_LOG_WHEN_TEST_FINISHED.LOG: 5 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2016-03-07 17:26 309 oltp25_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 +++
result: files match. No new messages appeared in firebird.log during test ran.
+++ End of comparison +++

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


Remove 272 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.oltp25\oltp25_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2016-03-07 17:26:39.07 - end of report, text file: e:\temp\logs.oltp25\oltp25.report.txt, html: e:\temp\logs.oltp25\oltp25.report.html

Subscribe to IBSurgeon news

Subscribe