Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2018-01-12 6:49:39.71.
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.32875 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. 2018-01-12 06:46:31.7980 -1 <null> ::1/61162 401283 9213 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: 5803.41 1243 1044613 2018-01-12 03:46 2018-01-12 06:46
customer order: creation 392.24 263 70603 2018-01-12 03:46 2018-01-12 06:46
customer order: refuse 31.57 135 5683 2018-01-12 03:46 2018-01-12 06:46
order to supplier: creation 100.81 923 18145 2018-01-12 03:46 2018-01-12 06:46
order to supplier: removal 2.86 7887 514 2018-01-12 03:46 2018-01-12 06:46
invoice (draft): creation 99.55 1325 17919 2018-01-12 03:46 2018-01-12 06:46
invoice (draft): removal 40.53 167 7296 2018-01-12 03:46 2018-01-12 06:46
invoice accept: apply 57.79 3657 10403 2018-01-12 03:46 2018-01-12 06:46
invoice accept: cancel 18.85 858 3393 2018-01-12 03:46 2018-01-12 06:46
customer reserve: creation 3327.93 49 599027 2018-01-12 03:46 2018-01-12 06:46
customer reserve: removal 1180.79 21 212543 2018-01-12 03:46 2018-01-12 06:46
realization accept: apply 180.21 305 32437 2018-01-12 03:46 2018-01-12 06:46
realization accept: cancel 90.91 68 16364 2018-01-12 03:46 2018-01-12 06:46
payment from customer: creation 130.93 415 23568 2018-01-12 03:46 2018-01-12 06:46
payment from customer: removal 12.08 84 2174 2018-01-12 03:46 2018-01-12 06:46
payment to supplier: creation 107.17 262 19291 2018-01-12 03:46 2018-01-12 06:46
payment to supplier: removal 7.60 88 1368 2018-01-12 03:46 2018-01-12 06:46
service: total inventory turnovers 10.27 1023 1848 2018-01-12 03:46 2018-01-12 06:46
service: total monetary turnovers 11.25 48 2025 2018-01-12 03:46 2018-01-12 06:46
service: refresh index statistics 0.07 6039 12 2018-01-12 03:46 2018-01-12 06:46
Done for 55870 ms, from 6:51:04.73 to 6:52:00.60.

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 3809 81325 68561 12764 15.70 03:46:32 04:04:32
interval # 2, overall 2 5810 122381 104582 17799 14.54 04:04:33 04:22:33
interval # 3, overall 3 6327 127715 113889 13826 10.83 04:22:34 04:40:34
interval # 4, overall 4 6060 128560 109088 19472 15.15 04:40:35 04:58:35
interval # 5, overall 5 6103 134749 109858 24891 18.47 04:58:36 05:16:36
interval # 6, overall 6 6425 137479 115645 21834 15.88 05:16:37 05:34:37
interval # 7, overall 7 5792 123185 104257 18928 15.37 05:34:38 05:52:38
interval # 8, overall 8 5931 128682 106758 21924 17.04 05:52:39 06:10:39
interval # 9, overall 9 6092 126170 109653 16517 13.09 06:10:40 06:28:40
interval # 10, overall 10 5685 127094 102322 24772 19.49 06:28:41 06:46:41
Done for 145760 ms, from 6:54:27.13 to 6:56:52.89.

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 2443.76 0.2663 1.7436 1665 17
TEST_TIME 2 2634.10 0.8090 1.1916 1396 25
TEST_TIME 3 2447.46 0.8551 1.1556 886 100
TEST_TIME 4 2482.89 0.8558 1.1448 1170 100
TEST_TIME 5 2604.12 0.8733 1.1153 1476 100
TEST_TIME 6 2709.10 0.8968 1.1373 1263 100
TEST_TIME 7 2874.26 0.9189 1.0808 1355 100
TEST_TIME 8 2961.67 0.9181 1.0627 1436 100
TEST_TIME 9 2982.63 0.9385 1.0890 1171 100
TEST_TIME 10 3105.74 0.9413 1.0539 1326 100
TEST_TIME 11 3169.11 0.9390 1.0634 1568 100
TEST_TIME 12 3229.90 0.9567 1.0488 1521 100
TEST_TIME 13 3287.26 0.9512 1.0426 1298 100
TEST_TIME 14 3337.12 0.9544 1.0488 1387 100
TEST_TIME 15 3445.59 0.9481 1.0596 1588 100
TEST_TIME 16 3558.97 0.9618 1.0457 1707 100
TEST_TIME 17 3705.19 0.9500 1.0449 1616 100
TEST_TIME 18 3799.51 0.9624 1.0374 1748 100
TEST_TIME 19 3896.14 0.9584 1.0430 1450 100
TEST_TIME 20 3996.68 0.9659 1.0306 1480 100
TEST_TIME 21 4060.66 0.9661 1.0324 1579 100
TEST_TIME 22 4105.24 0.9748 1.0260 1551 100
TEST_TIME 23 4139.81 0.9732 1.0296 1447 100
TEST_TIME 24 4189.18 0.9768 1.0239 1085 100
TEST_TIME 25 4208.98 0.9784 1.0237 1163 100
TEST_TIME 26 4243.97 0.9762 1.0264 1411 100
TEST_TIME 27 4292.78 0.9771 1.0178 1217 100
TEST_TIME 28 4313.29 0.9768 1.0197 1303 100
TEST_TIME 29 4332.36 0.9802 1.0195 1117 100
TEST_TIME 30 4419.89 0.9660 1.0239 1656 100
TEST_TIME 31 4498.34 0.9736 1.0314 1782 100
TEST_TIME 32 4604.09 0.9763 1.0243 1878 100
TEST_TIME 33 4653.29 0.9827 1.0161 1371 100
TEST_TIME 34 4687.08 0.9791 1.0175 1708 100
TEST_TIME 35 4737.22 0.9781 1.0259 1480 100
TEST_TIME 36 4797.27 0.9849 1.0166 1343 100
TEST_TIME 37 4834.12 0.9817 1.0177 1178 100
TEST_TIME 38 4886.28 0.9804 1.0187 1243 100
TEST_TIME 39 4929.41 0.9839 1.0167 1249 100
TEST_TIME 40 4970.32 0.9831 1.0133 1169 100
TEST_TIME 41 4982.22 0.9862 1.0153 1306 100
TEST_TIME 42 5007.74 0.9861 1.0117 1195 100
TEST_TIME 43 5006.55 0.9884 1.0120 1206 100
TEST_TIME 44 5013.55 0.9876 1.0086 988 100
TEST_TIME 45 5019.65 0.9850 1.0165 1615 100
TEST_TIME 46 5069.73 0.9853 1.0150 1558 100
TEST_TIME 47 5106.89 0.9862 1.0128 1593 100
TEST_TIME 48 5139.12 0.9859 1.0131 1251 100
TEST_TIME 49 5164.42 0.9876 1.0127 1630 100
TEST_TIME 50 5198.20 0.9866 1.0132 1555 100
TEST_TIME 51 5234.69 0.9864 1.0101 1353 100
TEST_TIME 52 5273.87 0.9833 1.0142 1219 100
TEST_TIME 53 5300.98 0.9900 1.0111 1345 100
TEST_TIME 54 5310.97 0.9906 1.0067 1170 100
TEST_TIME 55 5310.18 0.9885 1.0092 1282 100
TEST_TIME 56 5309.23 0.9914 1.0059 1113 100
TEST_TIME 57 5315.50 0.9872 1.0094 1100 100
TEST_TIME 58 5327.42 0.9898 1.0095 1009 100
TEST_TIME 59 5323.24 0.9932 1.0058 1098 100
TEST_TIME 60 5339.15 0.9862 1.0143 1406 100
TEST_TIME 61 5386.50 0.9889 1.0135 1524 100
TEST_TIME 62 5430.51 0.9896 1.0118 1504 100
TEST_TIME 63 5479.82 0.9868 1.0105 1365 100
TEST_TIME 64 5500.01 0.9911 1.0086 1288 100
TEST_TIME 65 5518.43 0.9897 1.0102 1238 100
TEST_TIME 66 5531.83 0.9924 1.0111 1211 100
TEST_TIME 67 5545.95 0.9936 1.0081 1280 100
TEST_TIME 68 5539.03 0.9948 1.0053 1197 100
TEST_TIME 69 5520.02 0.9942 1.0051 1145 100
TEST_TIME 70 5507.04 0.9931 1.0056 1323 99
TEST_TIME 71 5502.35 0.9925 1.0052 1334 100
TEST_TIME 72 5493.85 0.9928 1.0064 1163 100
TEST_TIME 73 5491.01 0.9931 1.0059 1146 100
TEST_TIME 74 5480.83 0.9941 1.0058 1094 100
TEST_TIME 75 5477.36 0.9931 1.0073 1738 100
TEST_TIME 76 5494.93 0.9908 1.0083 1530 100
TEST_TIME 77 5520.65 0.9908 1.0097 1607 100
TEST_TIME 78 5556.58 0.9906 1.0075 1386 100
TEST_TIME 79 5567.71 0.9928 1.0080 1556 100
TEST_TIME 80 5572.00 0.9947 1.0058 1333 100
TEST_TIME 81 5572.28 0.9933 1.0072 1323 100
TEST_TIME 82 5596.50 0.9906 1.0066 1101 100
TEST_TIME 83 5596.83 0.9951 1.0062 1327 100
TEST_TIME 84 5599.70 0.9937 1.0075 1190 100
TEST_TIME 85 5601.00 0.9954 1.0056 1212 100
TEST_TIME 86 5600.62 0.9940 1.0069 1105 100
TEST_TIME 87 5611.13 0.9935 1.0040 1004 100
TEST_TIME 88 5604.80 0.9937 1.0058 1176 100
TEST_TIME 89 5610.30 0.9935 1.0057 984 100
TEST_TIME 90 5607.59 0.9950 1.0087 1562 100
TEST_TIME 91 5630.44 0.9936 1.0055 1282 100
TEST_TIME 92 5636.30 0.9935 1.0050 1556 100
TEST_TIME 93 5658.29 0.9933 1.0054 1303 100
TEST_TIME 94 5656.79 0.9950 1.0041 1588 100
TEST_TIME 95 5661.00 0.9928 1.0053 1416 100
TEST_TIME 96 5670.21 0.9933 1.0057 1290 100
TEST_TIME 97 5671.71 0.9951 1.0056 1455 100
TEST_TIME 98 5675.08 0.9947 1.0053 1325 100
TEST_TIME 99 5689.09 0.9927 1.0057 1149 100
TEST_TIME 100 5699.90 0.9937 1.0060 1150 100
TEST_TIME 101 5693.00 0.9972 1.0029 1181 100
TEST_TIME 102 5677.95 0.9959 1.0041 1170 100
TEST_TIME 103 5685.22 0.9932 1.0076 972 100
TEST_TIME 104 5702.26 0.9950 1.0042 1081 100
TEST_TIME 105 5709.53 0.9934 1.0050 1662 100
TEST_TIME 106 5730.39 0.9919 1.0061 1650 100
TEST_TIME 107 5742.37 0.9946 1.0048 1345 100
TEST_TIME 108 5745.14 0.9951 1.0049 1444 100
TEST_TIME 109 5750.07 0.9948 1.0048 1191 100
TEST_TIME 110 5758.16 0.9943 1.0047 1355 100
TEST_TIME 111 5767.86 0.9939 1.0052 1194 100
TEST_TIME 112 5769.56 0.9960 1.0051 1258 100
TEST_TIME 113 5768.23 0.9965 1.0041 1238 99
TEST_TIME 114 5770.44 0.9949 1.0053 920 100
TEST_TIME 115 5769.62 0.9967 1.0037 1117 100
TEST_TIME 116 5763.27 0.9961 1.0032 1162 100
TEST_TIME 117 5750.31 0.9971 1.0045 1145 99
TEST_TIME 118 5748.41 0.9963 1.0037 963 100
TEST_TIME 119 5735.11 0.9976 1.0019 1042 100
TEST_TIME 120 5726.98 0.9949 1.0027 1298 100
TEST_TIME 121 5726.11 0.9946 1.0079 1631 100
TEST_TIME 122 5749.16 0.9956 1.0025 1651 100
TEST_TIME 123 5738.09 0.9963 1.0052 1600 100
TEST_TIME 124 5745.73 0.9958 1.0057 1381 100
TEST_TIME 125 5751.20 0.9967 1.0044 1155 99
TEST_TIME 126 5751.47 0.9964 1.0043 1243 100
TEST_TIME 127 5763.46 0.9944 1.0052 1230 100
TEST_TIME 128 5769.93 0.9963 1.0047 1025 100
TEST_TIME 129 5775.05 0.9961 1.0048 1139 100
TEST_TIME 130 5774.74 0.9971 1.0031 1183 100
TEST_TIME 131 5773.12 0.9960 1.0046 1086 100
TEST_TIME 132 5773.25 0.9970 1.0035 1021 100
TEST_TIME 133 5771.30 0.9963 1.0026 1055 100
TEST_TIME 134 5761.05 0.9974 1.0029 1030 100
TEST_TIME 135 5758.96 0.9959 1.0045 1335 100
TEST_TIME 136 5764.29 0.9962 1.0034 1571 100
TEST_TIME 137 5763.99 0.9961 1.0034 1326 100
TEST_TIME 138 5766.59 0.9960 1.0041 1543 100
TEST_TIME 139 5774.40 0.9956 1.0045 1426 100
TEST_TIME 140 5778.69 0.9965 1.0036 1333 100
TEST_TIME 141 5783.15 0.9957 1.0017 1436 100
TEST_TIME 142 5786.46 0.9941 1.0039 1220 99
TEST_TIME 143 5785.31 0.9971 1.0015 1355 100
TEST_TIME 144 5771.02 0.9970 1.0033 1416 97
TEST_TIME 145 5776.08 0.9955 1.0024 1182 100
TEST_TIME 146 5772.33 0.9962 1.0034 1120 100
TEST_TIME 147 5769.16 0.9971 1.0034 1204 100
TEST_TIME 148 5773.71 0.9958 1.0047 1054 100
TEST_TIME 149 5783.07 0.9963 1.0033 1103 100
TEST_TIME 150 5787.87 0.9958 1.0054 1627 100
TEST_TIME 151 5803.35 0.9961 1.0026 1461 100
TEST_TIME 152 5808.84 0.9951 1.0036 1483 100
TEST_TIME 153 5814.69 0.9960 1.0040 1473 100
TEST_TIME 154 5816.42 0.9972 1.0037 1419 100
TEST_TIME 155 5825.68 0.9957 1.0045 1100 100
TEST_TIME 156 5831.19 0.9971 1.0030 1296 100
TEST_TIME 157 5833.02 0.9963 1.0028 1164 100
TEST_TIME 158 5835.20 0.9963 1.0025 1179 100
TEST_TIME 159 5829.51 0.9971 1.0031 1197 100
TEST_TIME 160 5824.48 0.9977 1.0031 1130 99
TEST_TIME 161 5818.38 0.9980 1.0018 1154 100
TEST_TIME 162 5809.62 0.9973 1.0023 951 100
TEST_TIME 163 5803.99 0.9971 1.0032 930 100
TEST_TIME 164 5799.53 0.9981 1.0024 1036 99
TEST_TIME 165 5794.25 0.9972 1.0029 1399 99
TEST_TIME 166 5797.56 0.9963 1.0029 1463 100
TEST_TIME 167 5798.05 0.9969 1.0027 1392 100
TEST_TIME 168 5804.08 0.9957 1.0029 1420 100
TEST_TIME 169 5809.33 0.9961 1.0039 1343 99
TEST_TIME 170 5807.36 0.9984 1.0017 1506 100
TEST_TIME 171 5807.90 0.9958 1.0025 1356 99
TEST_TIME 172 5812.08 0.9959 1.0029 968 100
TEST_TIME 173 5823.69 0.9951 1.0026 1021 100
TEST_TIME 174 5822.35 0.9970 1.0027 1124 100
TEST_TIME 175 5819.20 0.9975 1.0023 1093 100
TEST_TIME 176 5810.64 0.9981 1.0024 1125 100
TEST_TIME 177 5810.73 0.9968 1.0021 1060 100
TEST_TIME 178 5808.25 0.9970 1.0021 1063 100
TEST_TIME 179 5796.93 0.9985 1.0031 1144 99
TEST_TIME 180 5793.67 0.9981 1.0016 774 100
Done for 9750 ms, from 6:56:53.80 to 6:57:03.55.

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 66359 113300 53355 94701 52513 131814 78989 89943 49527 75666 49808 78257 76927 144547 126190 97381 96263 452577 <null> 03:46:32 04:04:32
fetches per second 2 51496 40633 58081 65011 47710 <null> 88650 <null> 104425 233800 67162 78195 88034 79284 109854 35592 104307 422242 <null> 04:04:33 04:22:33
fetches per second 3 58295 102857 37625 9872 57517 7217 92983 112309 29825 56844 67121 70161 82268 25300 79129 40277 120603 173136 <null> 04:22:34 04:40:34
fetches per second 4 46558 90581 41931 <null> 57912 <null> 62722 <null> 9381 73623 60553 78852 103943 205083 126578 185750 93003 <null> <null> 04:40:35 04:58:35
fetches per second 5 66657 98164 55526 <null> 52808 <null> 66020 <null> 10459 <null> 88429 98016 87705 119106 86090 15918 <null> <null> <null> 04:58:36 05:16:36
fetches per second 6 34339 88080 60131 <null> 31005 86897 72833 67563 21586 <null> 52417 59941 80735 43915 75845 <null> 75816 502250 <null> 05:16:37 05:34:37
fetches per second 7 23650 17154 37567 <null> 33545 <null> 32421 3546 1756 <null> 39116 38821 54447 <null> 39877 <null> 79135 111176 <null> 05:34:38 05:52:38
fetches per second 8 49279 72682 53004 117262 36120 <null> 30050 <null> 56039 165333 55269 <null> 40616 <null> 42472 <null> 121007 10600 <null> 05:52:39 06:10:39
fetches per second 9 63425 100329 50149 39390 30754 2294 73397 53472 50624 133377 49253 93250 68121 43152 75813 <null> <null> 116996 <null> 06:10:40 06:28:40
fetches per second 10 35036 45068 16627 <null> 36487 7177 24792 <null> 3038 126276 20165 13354 28572 92755 73355 37100 <null> <null> <null> 06:28:41 06:46:41
marks per second 1 14448 14388 11651 14992 11365 28777 9946 18189 6889 17779 7170 13136 6280 25369 5242 14038 13425 30775 <null> 03:46:32 04:04:32
marks per second 2 10755 5663 12906 10532 10508 <null> 11716 <null> 9250 34800 9471 14106 7279 12458 7728 6379 18437 64888 <null> 04:04:33 04:22:33
marks per second 3 12005 11115 8553 2600 13156 1537 11718 15850 4095 11188 9056 10837 5619 5287 8007 5611 12151 22568 <null> 04:22:34 04:40:34
marks per second 4 9452 11457 9456 <null> 12664 <null> 8713 <null> 869 11298 9073 11997 5160 37916 13355 26500 10503 <null> <null> 04:40:35 04:58:35
marks per second 5 13826 12040 12101 <null> 11596 <null> 8463 <null> 1374 <null> 11177 18692 6467 17856 8784 2469 <null> <null> <null> 04:58:36 05:16:36
marks per second 6 7165 10514 12780 <null> 6781 22000 9793 9184 4228 <null> 6615 9647 3536 6739 11541 <null> 8035 39000 <null> 05:16:37 05:34:37
marks per second 7 5050 2193 7834 <null> 7001 <null> 4212 489 222 <null> 5998 5910 2319 <null> 5776 <null> 15931 2571 <null> 05:34:38 05:52:38
marks per second 8 10028 8689 11357 18261 8270 <null> 3326 <null> 8147 29222 4220 <null> 2160 <null> 6977 <null> 21660 423 <null> 05:52:39 06:10:39
marks per second 9 13729 12827 10665 6574 6994 622 9408 7512 6271 20108 7180 17500 2764 6161 10654 <null> <null> 8316 <null> 06:10:40 06:28:40
marks per second 10 7325 5971 3340 <null> 7545 1909 2435 <null> 190 20518 2458 2143 1107 16319 9026 5200 <null> <null> <null> 06:28:41 06:46:41
reads/fetches*100 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 03:46:32 04:04:32
reads/fetches*100 2 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 04:04:33 04:22:33
reads/fetches*100 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:22:34 04:40:34
reads/fetches*100 4 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> <null> 04:40:35 04:58:35
reads/fetches*100 5 0 0 0 <null> 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 <null> <null> <null> 04:58:36 05:16:36
reads/fetches*100 6 0 0 0 <null> 0 0 0 0 0 <null> 0 0 0 0 0 <null> 0 0 <null> 05:16:37 05:34:37
reads/fetches*100 7 0 0 0 <null> 0 <null> 0 0 0 <null> 0 0 0 <null> 0 <null> 0 0 <null> 05:34:38 05:52:38
reads/fetches*100 8 0 0 0 0 0 <null> 0 <null> 0 0 0 <null> 0 <null> 0 <null> 0 0 <null> 05:52:39 06:10:39
reads/fetches*100 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> <null> 0 <null> 06:10:40 06:28:40
reads/fetches*100 10 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 <null> <null> <null> 06:28:41 06:46:41
writes/marks*100 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 10 0 <null> 03:46:32 04:04:32
writes/marks*100 2 0 0 0 0 0 <null> 0 <null> 1 1 0 0 0 0 0 1 1 0 <null> 04:04:33 04:22:33
writes/marks*100 3 0 0 0 0 0 1 0 0 1 0 0 1 0 0 0 0 2 0 <null> 04:22:34 04:40:34
writes/marks*100 4 0 0 0 <null> 0 <null> 0 <null> 3 0 0 0 0 0 0 0 4 <null> <null> 04:40:35 04:58:35
writes/marks*100 5 0 0 0 <null> 0 <null> 0 <null> 2 <null> 0 0 0 0 0 0 <null> <null> <null> 04:58:36 05:16:36
writes/marks*100 6 0 0 0 <null> 0 0 0 0 0 <null> 0 0 0 0 0 <null> 2 0 <null> 05:16:37 05:34:37
writes/marks*100 7 0 0 0 <null> 0 <null> 0 0 1 <null> 0 0 0 <null> 1 <null> 11 0 <null> 05:34:38 05:52:38
writes/marks*100 8 0 0 0 0 0 <null> 0 <null> 0 0 0 <null> 0 <null> 0 <null> 1 0 <null> 05:52:39 06:10:39
writes/marks*100 9 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 <null> <null> 0 <null> 06:10:40 06:28:40
writes/marks*100 10 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 <null> <null> <null> 06:28:41 06:46:41
Done for 8130 ms, from 6:57:04.17 to 6:57:12.30.

Performance in DETAILS:

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL JOB_BEG JOB_END
doc_list_aiud 1862920 1680036 182884 9.81 0 8595 17 182884 2018-01-12 03:46 2018-01-12 06:46
doc_list_biud 1863330 1680036 183294 9.83 0 9033 6 183294 2018-01-12 03:46 2018-01-12 06:46
sp_add_invoice_to_stock 16917 10403 6514 38.50 15 80184 3657 6514 2018-01-12 03:46 2018-01-12 06:46
sp_cancel_adding_invoice 4458 3393 1065 23.88 0 34679 858 1065 2018-01-12 03:46 2018-01-12 06:46
sp_cancel_client_order 5815 5683 132 2.26 0 2699 135 132 2018-01-12 03:46 2018-01-12 06:46
sp_cancel_customer_reserve 384533 212543 171990 44.72 0 4227 21 171990 2018-01-12 03:46 2018-01-12 06:46
sp_cancel_pay_from_customer 2188 2174 14 0.63 0 1638 84 14 2018-01-12 03:46 2018-01-12 06:46
sp_cancel_pay_to_supplier 1372 1368 4 0.29 0 2496 88 4 2018-01-12 03:46 2018-01-12 06:46
sp_cancel_supplier_invoice 9468 7296 2172 22.94 0 9391 167 2172 2018-01-12 03:46 2018-01-12 06:46
sp_cancel_supplier_order 1336 514 822 61.52 31 91479 7887 822 2018-01-12 03:46 2018-01-12 06:46
sp_cancel_write_off 25058 16364 8694 34.69 0 5351 68 8694 2018-01-12 03:46 2018-01-12 06:46
sp_client_order 70603 70603 0 0.00 0 5678 263 0 2018-01-12 03:46 2018-01-12 06:46
sp_customer_reserve 599027 599027 0 0.00 0 6209 49 0 2018-01-12 03:46 2018-01-12 06:46
sp_fill_shopping_cart 106928 106667 261 0.24 0 3386 53 0 2018-01-12 03:46 2018-01-12 06:46
sp_fill_shopping_cart_clo_res 599027 599027 0 0.00 0 3074 3 0 2018-01-12 03:46 2018-01-12 06:46
sp_get_clo_for_invoice 10403 10403 0 0.00 0 4337 139 0 2018-01-12 03:46 2018-01-12 06:46
sp_kill_cost_storno 32756 23299 9457 28.87 0 4914 13 9457 2018-01-12 03:46 2018-01-12 06:46
sp_kill_qstorno_ret_qs2qd 803273 449260 354013 44.07 0 8611 8 354013 2018-01-12 03:46 2018-01-12 06:46
sp_kill_qty_storno 471851 288633 183218 38.82 0 8907 29 183218 2018-01-12 03:46 2018-01-12 06:46
sp_lock_selected_doc 69405 59994 9411 13.55 0 1794 4 9411 2018-01-12 03:46 2018-01-12 06:46
sp_make_cost_storno 85699 85699 0 0.00 0 7629 165 0 2018-01-12 03:46 2018-01-12 06:46
sp_multiply_rows_for_pdistr 85699 85699 0 0.00 0 2153 46 0 2018-01-12 03:46 2018-01-12 06:46
sp_multiply_rows_for_qdistr 70603 70603 0 0.00 0 4306 87 0 2018-01-12 03:46 2018-01-12 06:46
sp_pay_from_customer 23568 23568 0 0.00 0 6973 415 0 2018-01-12 03:46 2018-01-12 06:46
sp_pay_to_supplier 19291 19291 0 0.00 0 4976 262 0 2018-01-12 03:46 2018-01-12 06:46
sp_payment_common 42859 42859 0 0.00 0 2199 40 0 2018-01-12 03:46 2018-01-12 06:46
sp_qd_handle_on_cancel_clo 5812 5683 129 2.21 0 1700 59 129 2018-01-12 03:46 2018-01-12 06:46
sp_qd_handle_on_invoice_upd_sts 14709 13796 913 6.20 0 7675 164 913 2018-01-12 03:46 2018-01-12 06:46
sp_qd_handle_on_reserve_upd_sts 32437 32437 0 0.00 0 1669 33 0 2018-01-12 03:46 2018-01-12 06:46
sp_reserve_write_off 33496 32437 1059 3.16 0 7707 305 1059 2018-01-12 03:46 2018-01-12 06:46
sp_supplier_invoice 18013 17919 94 0.52 0 26286 1325 0 2018-01-12 03:46 2018-01-12 06:46
sp_supplier_order 18312 18145 167 0.91 0 16708 923 0 2018-01-12 03:46 2018-01-12 06:46
srv_find_qd_qs_mism 1144021 961134 182887 15.98 0 4680 7 182887 2018-01-12 03:46 2018-01-12 06:46
srv_make_invnt_saldo 1848 1848 0 0.00 0 17971 1023 0 2018-01-12 03:46 2018-01-12 06:46
srv_make_money_saldo 2025 2025 0 0.00 0 1825 48 0 2018-01-12 03:46 2018-01-12 06:46
srv_recalc_idx_stat 12 12 0 0.00 2184 15195 6039 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_add_invoice_to_stock 6514 6514 0 0.00 0 2137 58 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_cancel_adding_invoice 616 616 0 0.00 0 1092 54 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_cancel_client_order 132 132 0 0.00 0 1279 85 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_cancel_customer_reserve 73 73 0 0.00 0 1233 48 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_cancel_pay_from_customer 14 14 0 0.00 0 296 34 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_cancel_pay_to_supplier 4 4 0 0.00 0 16 7 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_cancel_supplier_invoice 572 572 0 0.00 0 2277 74 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_cancel_supplier_order 20672 20672 0 0.00 0 2980 43 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_cancel_write_off 23 23 0 0.00 0 500 50 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_reserve_write_off 1059 1059 0 0.00 0 1857 41 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_supplier_invoice 94 94 0 0.00 0 827 56 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-abend:sp_supplier_order 167 167 0 0.00 0 1295 38 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_add_invoice_to_stock 10403 10403 0 0.00 0 12152 264 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_cancel_adding_invoice 1197 1197 0 0.00 0 11544 320 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_cancel_client_order 5683 5683 0 0.00 0 2324 52 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_cancel_customer_reserve 2127 2127 0 0.00 0 1560 49 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_cancel_pay_from_customer 2174 2174 0 0.00 0 2308 46 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_cancel_pay_to_supplier 1368 1368 0 0.00 0 1389 37 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_cancel_supplier_invoice 816 816 0 0.00 0 1732 47 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_cancel_supplier_order 514 514 0 0.00 0 17628 938 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_cancel_write_off 3275 3275 0 0.00 0 2886 50 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_client_order 70603 70603 0 0.00 0 4040 58 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_customer_reserve 3349 3349 0 0.00 0 2605 41 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_pay_from_customer 23568 23568 0 0.00 0 2996 50 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_pay_to_supplier 19291 19291 0 0.00 0 2324 42 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_reserve_write_off 32437 32437 0 0.00 0 3713 55 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_supplier_invoice 17919 17919 0 0.00 0 2590 38 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:sp_supplier_order 18145 18145 0 0.00 0 2246 41 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:srv_make_invnt_saldo 1848 1848 0 0.00 0 1357 15 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:srv_make_money_saldo 2025 2025 0 0.00 0 1139 24 0 2018-01-12 03:46 2018-01-12 06:46
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 16 6 0 2018-01-12 03:46 2018-01-12 06:46
v_add_invoice_to_stock 33834 20806 13028 38.50 0 1498 10 13028 2018-01-12 03:46 2018-01-12 06:46
v_all_customers 105878 105878 0 0.00 0 1451 3 0 2018-01-12 03:46 2018-01-12 06:46
v_all_suppliers 73210 72688 522 0.71 0 952 3 0 2018-01-12 03:46 2018-01-12 06:46
v_all_wares 141206 141206 0 0.00 0 1107 2 0 2018-01-12 03:46 2018-01-12 06:46
v_cancel_adding_invoice 2790 2394 396 14.19 0 3276 68 396 2018-01-12 03:46 2018-01-12 06:46
v_cancel_client_order 11630 11366 264 2.26 0 1045 5 264 2018-01-12 03:46 2018-01-12 06:46
v_cancel_customer_prepayment 4376 4348 28 0.63 0 718 5 28 2018-01-12 03:46 2018-01-12 06:46
v_cancel_customer_reserve 4400 4254 146 3.31 0 765 6 146 2018-01-12 03:46 2018-01-12 06:46
v_cancel_payment_to_supplier 2744 2736 8 0.29 0 640 5 8 2018-01-12 03:46 2018-01-12 06:46
v_cancel_supplier_invoice 2776 1632 1144 41.21 0 1420 11 1144 2018-01-12 03:46 2018-01-12 06:46
v_cancel_supplier_order 2672 1028 1644 61.52 0 795 6 1644 2018-01-12 03:46 2018-01-12 06:46
v_cancel_write_off 6596 6550 46 0.69 0 2558 50 46 2018-01-12 03:46 2018-01-12 06:46
v_max_id_clo_ord 18312 18145 167 0.91 0 733 3 0 2018-01-12 03:46 2018-01-12 06:46
v_max_id_clo_res 3349 3349 0 0.00 0 952 14 0 2018-01-12 03:46 2018-01-12 06:46
v_max_id_ord_sup 18013 17919 94 0.52 0 842 3 0 2018-01-12 03:46 2018-01-12 06:46
v_max_non_paid_invoice 19011 19011 0 0.00 0 1388 4 0 2018-01-12 03:46 2018-01-12 06:46
v_max_non_paid_realizn 23568 23568 0 0.00 0 1030 4 0 2018-01-12 03:46 2018-01-12 06:46
v_min_id_clo_ord 18312 18145 167 0.91 0 967 4 0 2018-01-12 03:46 2018-01-12 06:46
v_min_id_clo_res 3349 3349 0 0.00 0 1482 8 0 2018-01-12 03:46 2018-01-12 06:46
v_min_id_ord_sup 18013 17919 94 0.52 0 2059 6 0 2018-01-12 03:46 2018-01-12 06:46
v_min_non_paid_invoice 19291 19291 0 0.00 0 1326 8 0 2018-01-12 03:46 2018-01-12 06:46
v_min_non_paid_realizn 23568 23568 0 0.00 0 1248 7 0 2018-01-12 03:46 2018-01-12 06:46
v_our_firm 35328 35328 0 0.00 0 998 3 0 2018-01-12 03:46 2018-01-12 06:46
v_reserve_write_off 66992 64874 2118 3.16 0 1467 5 2118 2018-01-12 03:46 2018-01-12 06:46
x_lock_depdocs_on_canc_invoice 18761 9873 8888 47.37 0 1669 12 8888 2018-01-12 03:46 2018-01-12 06:46
x_lock_depdocs_on_canc_sup_ord 1336 514 822 61.52 0 827 31 822 2018-01-12 03:46 2018-01-12 06:46
x_make_qstorno_1000_1200 18312 18145 167 0.91 0 16458 801 0 2018-01-12 03:46 2018-01-12 06:46
x_make_qstorno_1200_2000 18013 17919 94 0.52 0 26021 1198 0 2018-01-12 03:46 2018-01-12 06:46
x_make_qstorno_2100_3300 599027 599027 0 0.00 0 6162 41 0 2018-01-12 03:46 2018-01-12 06:46
Done for 232970 ms, from 7:00:58.45 to 7:04:51.42.

Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.

Exceptions occured during test work:

FB_MNEMONA CNT UNIT FB_GDSCODE DTS_BEG DTS_END
deadlock 86 sp_kill_cost_storno 335544336 2018-01-12 03:47 2018-01-12 06:46
deadlock 67 sp_kill_qstorno_ret_qs2qd 335544336 2018-01-12 03:51 2018-01-12 06:43
deadlock 8249 sp_lock_selected_doc 335544336 2018-01-12 03:46 2018-01-12 06:46
deadlock 129 sp_qd_handle_on_cancel_clo 335544336 2018-01-12 03:51 2018-01-12 06:45
deadlock 167 sp_qd_handle_on_invoice_upd_sts 335544336 2018-01-12 03:47 2018-01-12 06:45
deadlock 564 x_lock_depdocs_on_canc_invoice 335544336 2018-01-12 03:47 2018-01-12 06:46
deadlock 142 x_lock_depdocs_on_canc_sup_ord 335544336 2018-01-12 03:48 2018-01-12 06:45
user_exc 167 x_make_qstorno_1000_1200 335544517 2018-01-12 03:47 2018-01-12 06:45
user_exc 94 x_make_qstorno_1200_2000 335544517 2018-01-12 03:47 2018-01-12 06:45
Done for 6440 ms, from 7:04:58.04 to 7:05:04.48.

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 401747
MON$OLDEST_ACTIVE 401748
MON$OLDEST_SNAPSHOT 401748
MON$NEXT_TRANSACTION 401748
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 770720
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.32875 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32875 Firebird 3.0"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32875 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32875 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 12.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Gstat execution time Fri Jan 12 07:05:04 2018

Database header page information:
Flags 0
Generation 401874
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 401749
Oldest active 401750
Oldest snapshot 401750
Next transaction 401751
Sequence number 0
Next attachment ID 9386
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.02, total records: 1968067
Average version length: 47.86, total versions: 1587, 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: 13, data page slots: 21192
Data pages: 21192, average fill: 73%
Primary pages: 21192, secondary pages: 0, swept pages: 12993
Empty pages: 3, full pages: 20381
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 59
60 - 79% = 21124
80 - 99% = 5

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 9443, nodes: 1968067
Average node length: 19.29, total dup: 0, max dup: 0
Average key length: 16.34, compression ratio: 1.65
Average prefix length: 13.66, average data length: 13.34
Clustering factor: 291420, ratio: 0.15
Fill distribution:
0 - 19% = 757
20 - 39% = 2412
40 - 59% = 3524
60 - 79% = 1071
80 - 99% = 1679

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7028, nodes: 1968067
Average node length: 11.65, total dup: 0, max dup: 0
Average key length: 8.70, compression ratio: 1.03
Average prefix length: 3.29, average data length: 5.71
Clustering factor: 286784, ratio: 0.15
Fill distribution:
0 - 19% = 2
20 - 39% = 3251
40 - 59% = 3642
60 - 79% = 117
80 - 99% = 16

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 167904, depth: 3, leaf buckets: 3251, nodes: 1968067
Average node length: 6.80, total dup: 1436008, max dup: 49
Average key length: 3.86, compression ratio: 2.33
Average prefix length: 7.41, average data length: 1.59
Clustering factor: 259307, ratio: 0.13
Fill distribution:
0 - 19% = 154
20 - 39% = 1058
40 - 59% = 1018
60 - 79% = 399
80 - 99% = 622

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.43, total records: 591775
Average version length: 35.56, total versions: 609, max versions: 3
Average fragment length: 44.00, total fragments: 22, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 5, data page slots: 7464
Data pages: 7464, average fill: 75%
Primary pages: 7456, secondary pages: 8, swept pages: 6908
Empty pages: 1, full pages: 7242
Fill distribution:
0 - 19% = 10
20 - 39% = 7
40 - 59% = 21
60 - 79% = 7413
80 - 99% = 13

Index DOC_LIST_ID_DESC (1)
Root page: 235478, depth: 3, leaf buckets: 2142, nodes: 591775
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 117565, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 1111
40 - 59% = 969
60 - 79% = 57
80 - 99% = 5

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 611, nodes: 591775
Average node length: 4.86, total dup: 591725, max dup: 40152
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 268475, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 513
60 - 79% = 74
80 - 99% = 24

Index PK_DOC_LIST (0)
Root page: 340324, depth: 3, leaf buckets: 1486, nodes: 591775
Average node length: 11.67, total dup: 0, max dup: 0
Average key length: 8.82, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 117565, ratio: 0.20
Fill distribution:
0 - 19% = 94
20 - 39% = 280
40 - 59% = 410
60 - 79% = 342
80 - 99% = 360

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.92, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.06, total fragments: 374, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.60
Pointer pages: 1, data page slots: 336
Data pages: 76, average fill: 10%
Primary pages: 4, secondary pages: 72, swept pages: 4
Empty pages: 51, full pages: 3
Fill distribution:
0 - 19% = 61
20 - 39% = 11
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 330, Index root page: 331
Total formats: 1, used formats: 1
Average record length: 24.25, total records: 1958
Average version length: 71.23, total versions: 1292, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 3.96
Pointer pages: 1, data page slots: 400
Data pages: 232, average fill: 12%
Primary pages: 230, secondary pages: 2, swept pages: 143
Empty pages: 109, full pages: 3
Fill distribution:
0 - 19% = 178
20 - 39% = 33
40 - 59% = 16
60 - 79% = 3
80 - 99% = 2

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 10, nodes: 1958
Average node length: 16.68, total dup: 19, max dup: 1
Average key length: 14.70, compression ratio: 1.84
Average prefix length: 15.29, average data length: 11.71
Clustering factor: 1332, ratio: 0.68
Fill distribution:
0 - 19% = 1
20 - 39% = 5
40 - 59% = 3
60 - 79% = 0
80 - 99% = 1

MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 14.96, 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: 6.16, total records: 550
Average version length: 45.38, total versions: 476, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 10.40
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 35%
Primary pages: 15, secondary pages: 1, swept pages: 5
Empty pages: 2, full pages: 5
Fill distribution:
0 - 19% = 9
20 - 39% = 1
40 - 59% = 1
60 - 79% = 2
80 - 99% = 3

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 272, depth: 1, leaf buckets: 1, nodes: 550
Average node length: 4.98, total dup: 482, max dup: 81
Average key length: 3.69, compression ratio: 5.15
Average prefix length: 17.43, average data length: 1.57
Clustering factor: 257, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
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.48, total records: 169846
Average version length: 30.06, total versions: 990, max versions: 5
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.51
Pointer pages: 2, data page slots: 1824
Data pages: 1824, average fill: 69%
Primary pages: 1823, secondary pages: 1, swept pages: 1526
Empty pages: 6, full pages: 579
Fill distribution:
0 - 19% = 10
20 - 39% = 7
40 - 59% = 78
60 - 79% = 1729
80 - 99% = 0

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 149, nodes: 169846
Average node length: 4.39, total dup: 169797, max dup: 8274
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 32304, ratio: 0.19
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 72
60 - 79% = 60
80 - 99% = 14

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 180, nodes: 169846
Average node length: 5.33, total dup: 153257, max dup: 33
Average key length: 2.94, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 45024, ratio: 0.27
Fill distribution:
0 - 19% = 1
20 - 39% = 14
40 - 59% = 72
60 - 79% = 60
80 - 99% = 33

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 183, nodes: 169846
Average node length: 5.33, total dup: 153257, max dup: 33
Average key length: 2.94, compression ratio: 7.48
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 45081, ratio: 0.27
Fill distribution:
0 - 19% = 1
20 - 39% = 19
40 - 59% = 70
60 - 79% = 59
80 - 99% = 34

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 179, nodes: 169846
Average node length: 5.12, total dup: 153257, max dup: 33
Average key length: 2.73, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 45088, ratio: 0.27
Fill distribution:
0 - 19% = 1
20 - 39% = 21
40 - 59% = 63
60 - 79% = 69
80 - 99% = 25

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 213551, depth: 2, leaf buckets: 189, nodes: 234662
Average node length: 4.45, total dup: 234481, max dup: 1877
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.58, average data length: 0.00
Clustering factor: 60127, ratio: 0.26
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 70
60 - 79% = 67
80 - 99% = 51

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.53, total records: 11500583
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: 168, data page slots: 272888
Data pages: 272888, average fill: 87%
Primary pages: 272888, secondary pages: 0, swept pages: 3
Empty pages: 25, full pages: 272859
Fill distribution:
0 - 19% = 28
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 272859

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 13615, nodes: 11500583
Average node length: 5.65, total dup: 10682522, max dup: 150
Average key length: 2.17, compression ratio: 3.68
Average prefix length: 7.87, average data length: 0.13
Clustering factor: 2191544, ratio: 0.19
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 9103
60 - 79% = 2955
80 - 99% = 1555

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 11453, nodes: 11500583
Average node length: 4.60, total dup: 11500579, max dup: 10171498
Average key length: 1.12, compression ratio: 0.52
Average prefix length: 0.58, average data length: 0.00
Clustering factor: 327739, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11451
60 - 79% = 0
80 - 99% = 2

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 14307, nodes: 11500583
Average node length: 5.69, total dup: 11169160, max dup: 33668
Average key length: 2.22, compression ratio: 4.06
Average prefix length: 8.81, average data length: 0.19
Clustering factor: 691985, ratio: 0.06
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 11431
60 - 79% = 1612
80 - 99% = 1259

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 13888, nodes: 11500583
Average node length: 5.55, total dup: 11479596, max dup: 1782802
Average key length: 2.07, compression ratio: 18.36
Average prefix length: 37.85, average data length: 0.06
Clustering factor: 5210239, ratio: 0.45
Fill distribution:
0 - 19% = 12
20 - 39% = 2
40 - 59% = 12053
60 - 79% = 359
80 - 99% = 1462

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.07, total records: 426285
Average version length: 55.81, total versions: 414, 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: 5088
Data pages: 5088, average fill: 74%
Primary pages: 5088, secondary pages: 0, swept pages: 3741
Empty pages: 9, full pages: 4630
Fill distribution:
0 - 19% = 16
20 - 39% = 15
40 - 59% = 32
60 - 79% = 5023
80 - 99% = 2

Index PSTORNED_RCV_ID (2)
Root page: 669133, depth: 3, leaf buckets: 554, nodes: 426285
Average node length: 5.87, total dup: 362097, max dup: 624
Average key length: 3.09, compression ratio: 2.91
Average prefix length: 8.06, average data length: 0.94
Clustering factor: 54993, ratio: 0.13
Fill distribution:
0 - 19% = 8
20 - 39% = 42
40 - 59% = 315
60 - 79% = 137
80 - 99% = 52

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 460, nodes: 426285
Average node length: 5.60, total dup: 379521, max dup: 105
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 105872, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 12
40 - 59% = 196
60 - 79% = 165
80 - 99% = 86

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.45, total records: 2432
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.54
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 69%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 29
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 29
80 - 99% = 0

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

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

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

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

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

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

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

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

XQD_1000_1200 (260)
Primary pointer page: 292, Index root page: 295
Total formats: 1, used formats: 1
Average record length: 30.95, total records: 8674
Average version length: 72.21, total versions: 4956, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.39
Pointer pages: 1, data page slots: 520
Data pages: 464, average fill: 25%
Primary pages: 462, secondary pages: 2, swept pages: 196
Empty pages: 176, full pages: 54
Fill distribution:
0 - 19% = 267
20 - 39% = 68
40 - 59% = 43
60 - 79% = 73
80 - 99% = 13

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 20, nodes: 8674
Average node length: 6.48, total dup: 7442, max dup: 14
Average key length: 4.54, compression ratio: 8.15
Average prefix length: 34.60, average data length: 2.40
Clustering factor: 1443, ratio: 0.17
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 4
60 - 79% = 1
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.87, total records: 648852
Average version length: 71.63, total versions: 2802, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 7, data page slots: 9856
Data pages: 9856, average fill: 72%
Primary pages: 9856, secondary pages: 0, swept pages: 6593
Empty pages: 73, full pages: 6916
Fill distribution:
0 - 19% = 117
20 - 39% = 85
40 - 59% = 571
60 - 79% = 9065
80 - 99% = 18

Index XQD_1000_3300_DOC (1)
Root page: 322915, depth: 3, leaf buckets: 667, nodes: 648852
Average node length: 5.09, total dup: 630664, max dup: 123
Average key length: 2.20, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 76370, ratio: 0.12
Fill distribution:
0 - 19% = 3
20 - 39% = 59
40 - 59% = 392
60 - 79% = 40
80 - 99% = 173

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 263614, depth: 3, leaf buckets: 912, nodes: 648852
Average node length: 6.21, total dup: 566432, max dup: 14
Average key length: 3.32, compression ratio: 11.14
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 129475, ratio: 0.20
Fill distribution:
0 - 19% = 25
20 - 39% = 153
40 - 59% = 445
60 - 79% = 165
80 - 99% = 124

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 31.47, total records: 27865
Average version length: 72.11, total versions: 15692, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.32
Pointer pages: 2, data page slots: 1264
Data pages: 1024, average fill: 35%
Primary pages: 1021, secondary pages: 3, swept pages: 365
Empty pages: 221, full pages: 185
Fill distribution:
0 - 19% = 399
20 - 39% = 207
40 - 59% = 171
60 - 79% = 133
80 - 99% = 114

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 56, nodes: 27865
Average node length: 5.79, total dup: 24218, max dup: 48
Average key length: 3.74, compression ratio: 9.89
Average prefix length: 35.39, average data length: 1.61
Clustering factor: 3327, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 38
40 - 59% = 14
60 - 79% = 2
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.89, total records: 1330470
Average version length: 71.37, total versions: 23913, 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: 13, data page slots: 19640
Data pages: 19624, average fill: 75%
Primary pages: 19624, secondary pages: 0, swept pages: 8009
Empty pages: 186, full pages: 17331
Fill distribution:
0 - 19% = 312
20 - 39% = 370
40 - 59% = 702
60 - 79% = 17774
80 - 99% = 466

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 201465, depth: 3, leaf buckets: 2007, nodes: 1330470
Average node length: 5.56, total dup: 1255310, max dup: 49
Average key length: 2.62, compression ratio: 14.12
Average prefix length: 36.44, average data length: 0.56
Clustering factor: 129642, ratio: 0.10
Fill distribution:
0 - 19% = 12
20 - 39% = 875
40 - 59% = 814
60 - 79% = 130
80 - 99% = 176

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 29.73, total records: 3585
Average version length: 71.88, total versions: 2070, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.57
Pointer pages: 4, data page slots: 768
Data pages: 352, average fill: 14%
Primary pages: 351, secondary pages: 1, swept pages: 242
Empty pages: 182, full pages: 8
Fill distribution:
0 - 19% = 266
20 - 39% = 43
40 - 59% = 24
60 - 79% = 13
80 - 99% = 6

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 9, nodes: 3585
Average node length: 7.79, total dup: 2927, max dup: 48
Average key length: 5.80, compression ratio: 6.38
Average prefix length: 33.38, average data length: 3.62
Clustering factor: 542, ratio: 0.15
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 5
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 71.18, total records: 2645401
Average version length: 70.83, total versions: 8408, 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: 23, data page slots: 37136
Data pages: 37136, average fill: 77%
Primary pages: 37136, secondary pages: 0, swept pages: 26715
Empty pages: 14, full pages: 35901
Fill distribution:
0 - 19% = 25
20 - 39% = 47
40 - 59% = 227
60 - 79% = 36580
80 - 99% = 257

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5326, nodes: 2645401
Average node length: 6.83, total dup: 2152077, max dup: 14
Average key length: 3.85, compression ratio: 9.60
Average prefix length: 35.33, average data length: 1.67
Clustering factor: 409834, ratio: 0.15
Fill distribution:
0 - 19% = 7
20 - 39% = 2799
40 - 59% = 2008
60 - 79% = 312
80 - 99% = 200

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.42, total records: 4276499
Average version length: 84.26, total versions: 348, 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: 41, data page slots: 65536
Data pages: 65536, average fill: 80%
Primary pages: 65536, secondary pages: 0, swept pages: 22893
Empty pages: 1, full pages: 65345
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 14
60 - 79% = 18579
80 - 99% = 46941

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4431, nodes: 4276499
Average node length: 5.15, total dup: 4179140, max dup: 132
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 644987, ratio: 0.15
Fill distribution:
0 - 19% = 21
20 - 39% = 72
40 - 59% = 2088
60 - 79% = 1806
80 - 99% = 444

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 4098, nodes: 4276499
Average node length: 5.71, total dup: 3821597, max dup: 49
Average key length: 2.72, compression ratio: 3.30
Average prefix length: 8.38, average data length: 0.62
Clustering factor: 148759, ratio: 0.03
Fill distribution:
0 - 19% = 33
20 - 39% = 86
40 - 59% = 1552
60 - 79% = 230
80 - 99% = 2197

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 4946, nodes: 4276499
Average node length: 5.81, total dup: 3741877, max dup: 16
Average key length: 2.83, compression ratio: 3.18
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 697341, ratio: 0.16
Fill distribution:
0 - 19% = 25
20 - 39% = 81
40 - 59% = 2309
60 - 79% = 1957
80 - 99% = 574

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 83.15, total records: 2570305
Average version length: 83.28, total versions: 6570, 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: 25, data page slots: 40096
Data pages: 40096, average fill: 79%
Primary pages: 40096, secondary pages: 0, swept pages: 29516
Empty pages: 46, full pages: 38505
Fill distribution:
0 - 19% = 89
20 - 39% = 131
40 - 59% = 382
60 - 79% = 14094
80 - 99% = 25400

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2731, nodes: 2570305
Average node length: 5.15, total dup: 2510208, max dup: 170
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 386045, ratio: 0.15
Fill distribution:
0 - 19% = 2
20 - 39% = 37
40 - 59% = 1597
60 - 79% = 804
80 - 99% = 291

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 3978, nodes: 2570305
Average node length: 6.22, total dup: 2109437, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 193090, ratio: 0.08
Fill distribution:
0 - 19% = 92
20 - 39% = 1330
40 - 59% = 1459
60 - 79% = 650
80 - 99% = 447

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 3098, nodes: 2570305
Average node length: 5.81, total dup: 2248395, max dup: 32
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 471466, ratio: 0.18
Fill distribution:
0 - 19% = 22
20 - 39% = 46
40 - 59% = 1822
60 - 79% = 885
80 - 99% = 323

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.48, total records: 4514202
Average version length: 85.21, total versions: 7028, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 43, data page slots: 70064
Data pages: 70016, average fill: 79%
Primary pages: 70016, secondary pages: 0, swept pages: 16344
Empty pages: 428, full pages: 67638
Fill distribution:
0 - 19% = 571
20 - 39% = 312
40 - 59% = 673
60 - 79% = 11768
80 - 99% = 56692

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 4681, nodes: 4514202
Average node length: 5.04, total dup: 4487623, max dup: 722
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 628506, ratio: 0.14
Fill distribution:
0 - 19% = 7
20 - 39% = 159
40 - 59% = 2602
60 - 79% = 1375
80 - 99% = 538

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 5021, nodes: 4514202
Average node length: 5.52, total dup: 4159137, max dup: 49
Average key length: 2.54, compression ratio: 3.54
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 148893, ratio: 0.03
Fill distribution:
0 - 19% = 108
20 - 39% = 1110
40 - 59% = 1623
60 - 79% = 625
80 - 99% = 1555

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 5292, nodes: 4514202
Average node length: 5.70, total dup: 4042021, max dup: 86
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 702714, ratio: 0.16
Fill distribution:
0 - 19% = 8
20 - 39% = 126
40 - 59% = 3006
60 - 79% = 1538
80 - 99% = 614

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

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

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

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

XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 83.30, total records: 3205031
Average version length: 83.63, total versions: 5929, 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: 31, data page slots: 50032
Data pages: 50032, average fill: 79%
Primary pages: 50032, secondary pages: 0, swept pages: 35588
Empty pages: 90, full pages: 47643
Fill distribution:
0 - 19% = 161
20 - 39% = 199
40 - 59% = 599
60 - 79% = 14903
80 - 99% = 34170

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3483, nodes: 3205031
Average node length: 5.02, total dup: 3189583, max dup: 1225
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 587063, ratio: 0.18
Fill distribution:
0 - 19% = 13
20 - 39% = 347
40 - 59% = 1887
60 - 79% = 848
80 - 99% = 388

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 4894, nodes: 3205031
Average node length: 6.23, total dup: 2630821, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.93, average data length: 1.07
Clustering factor: 251671, ratio: 0.08
Fill distribution:
0 - 19% = 125
20 - 39% = 1616
40 - 59% = 1730
60 - 79% = 804
80 - 99% = 619

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 3826, nodes: 3205031
Average node length: 5.59, total dup: 2923411, max dup: 78
Average key length: 2.61, compression ratio: 3.45
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 632567, ratio: 0.20
Fill distribution:
0 - 19% = 17
20 - 39% = 340
40 - 59% = 2035
60 - 79% = 962
80 - 99% = 472

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.33, total records: 562940
Average version length: 68.99, total versions: 831, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 5, data page slots: 7720
Data pages: 7720, average fill: 77%
Primary pages: 7720, secondary pages: 0, swept pages: 5822
Empty pages: 0, full pages: 7509
Fill distribution:
0 - 19% = 1
20 - 39% = 3
40 - 59% = 33
60 - 79% = 7663
80 - 99% = 20

Index XQS_3300_3400_DOC_ID (0)
Root page: 177164, depth: 3, leaf buckets: 699, nodes: 562940
Average node length: 5.29, total dup: 531112, max dup: 116
Average key length: 2.43, compression ratio: 3.70
Average prefix length: 8.62, average data length: 0.38
Clustering factor: 48003, ratio: 0.09
Fill distribution:
0 - 19% = 0
20 - 39% = 193
40 - 59% = 272
60 - 79% = 176
80 - 99% = 58

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 788, nodes: 562940
Average node length: 5.90, total dup: 481517, max dup: 21
Average key length: 3.04, compression ratio: 2.96
Average prefix length: 8.10, average data length: 0.90
Clustering factor: 50737, ratio: 0.09
Fill distribution:
0 - 19% = 3
20 - 39% = 215
40 - 59% = 330
60 - 79% = 184
80 - 99% = 56

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

Gstat completion time Fri Jan 12 07:05:46 2018

Done for 41490 ms, from 7:05:04.75 to 7:05:46.24.

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 1968067 1587 0.0806
DOC_LIST 591775 609 0.1029
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 1958 1292 65.9856
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 550 476 86.5454
OPTYPES 9 0 0.0000
PDISTR 169846 990 0.5828
PERF_ESTIMATED 234662 0 0.0000
PERF_LOG 11500583 0 0.0000
PSTORNED 426285 414 0.0971
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 2432 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 8674 4956 57.1362
XQD_1000_3300 648852 2802 0.4318
XQD_1200_2000 27865 15692 56.3143
XQD_2000_3300 1330470 23913 1.7973
XQD_2100_3300 3585 2070 57.7405
XQD_3300_3400 2645401 8408 0.3178
XQS_1000_1200 4276499 348 0.0081
XQS_1000_3300 2570305 6570 0.2556
XQS_1200_2000 4514202 7028 0.1556
XQS_2100_3300 3205031 5929 0.1849
XQS_3300_3400 562940 831 0.1476
Z_USED_VIEWS 29 0 0.0000
Done for 2220 ms, from 7:05:53.40 to 7:05:55.62.

Database validation

07:05:55.68 Validation started

07:05:55.70 Relation 140 (DOC_LIST)
07:05:55.70 process pointer page 0 of 5
07:05:55.74 process pointer page 1 of 5
07:05:55.82 process pointer page 2 of 5
07:05:55.91 process pointer page 3 of 5
07:05:56.01 process pointer page 4 of 5
07:05:56.07 Index 1 (PK_DOC_LIST)
07:05:56.20 Index 2 (DOC_LIST_ID_DESC)
07:05:56.30 Index 3 (FK_DOC_LIST_AGENTS)
07:05:56.45 Relation 140 (DOC_LIST) is ok

07:05:56.45 Relation 141 (DOC_DATA)
07:05:56.45 process pointer page 0 of 13
07:05:56.49 process pointer page 1 of 13
07:05:56.52 process pointer page 2 of 13
07:05:56.57 process pointer page 3 of 13
07:05:56.60 process pointer page 4 of 13
07:05:56.63 process pointer page 5 of 13
07:05:56.71 process pointer page 6 of 13
07:05:56.74 process pointer page 7 of 13
07:05:56.77 process pointer page 8 of 13
07:05:56.85 process pointer page 9 of 13
07:05:56.91 process pointer page 10 of 13
07:05:56.98 process pointer page 11 of 13
07:05:57.02 process pointer page 12 of 13
07:05:57.07 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:05:57.71 Index 3 (DOC_DATA_ID_DESC)
07:05:58.04 Index 4 (FK_DOC_DATA_DOC_LIST)
07:05:58.35 Relation 141 (DOC_DATA) is ok

07:05:58.35 Relation 147 (INVNT_SALDO)
07:05:58.35 process pointer page 0 of 1
07:05:58.36 Index 1 (PK_INVNT_SALDO)
07:05:58.36 Relation 147 (INVNT_SALDO) is ok

07:05:58.36 Relation 150 (PDISTR)
07:05:58.36 process pointer page 0 of 2
07:05:58.40 process pointer page 1 of 2
07:05:58.41 Index 2 (PDISTR_SND_ID)
07:05:58.47 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:05:58.54 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:05:58.60 Index 5 (PDISTR_AGENT_ID)
07:05:58.64 Relation 150 (PDISTR) is ok

07:05:58.64 Relation 151 (PSTORNED)
07:05:58.64 process pointer page 0 of 4
07:05:58.74 process pointer page 1 of 4
07:05:58.83 process pointer page 2 of 4
07:05:58.93 process pointer page 3 of 4
07:05:58.93 Index 2 (PSTORNED_SND_ID)
07:05:59.03 Index 3 (PSTORNED_RCV_ID)
07:05:59.08 Relation 151 (PSTORNED) is ok

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

07:05:59.08 Relation 157 (INVNT_TURNOVER_LOG)
07:05:59.08 process pointer page 0 of 1
07:05:59.08 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:05:59.08 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:05:59.08 Relation 160 (PERF_ESTIMATED)
07:05:59.08 process pointer page 0 of 2
07:05:59.13 process pointer page 1 of 2
07:05:59.14 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:05:59.18 Relation 160 (PERF_ESTIMATED) is ok

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

07:05:59.18 Relation 162 (TRACE_STAT)
07:05:59.18 process pointer page 0 of 1
07:05:59.18 Relation 162 (TRACE_STAT) is ok

07:05:59.18 Relation 163 (PERF_LOG)
07:05:59.18 process pointer page 0 of 168
07:05:59.21 process pointer page 1 of 168
07:05:59.24 process pointer page 2 of 168
07:05:59.27 process pointer page 3 of 168
07:05:59.30 process pointer page 4 of 168
07:05:59.32 process pointer page 5 of 168
07:05:59.35 process pointer page 6 of 168
07:05:59.36 process pointer page 7 of 168
07:05:59.39 process pointer page 8 of 168
07:05:59.41 process pointer page 9 of 168
07:05:59.44 process pointer page 10 of 168
07:05:59.47 process pointer page 11 of 168
07:05:59.49 process pointer page 12 of 168
07:05:59.52 process pointer page 13 of 168
07:05:59.53 process pointer page 14 of 168
07:05:59.57 process pointer page 15 of 168
07:05:59.58 process pointer page 16 of 168
07:05:59.61 process pointer page 17 of 168
07:05:59.64 process pointer page 18 of 168
07:05:59.71 process pointer page 19 of 168
07:05:59.78 process pointer page 20 of 168
07:05:59.86 process pointer page 21 of 168
07:05:59.94 process pointer page 22 of 168
07:06:00.03 process pointer page 23 of 168
07:06:00.10 process pointer page 24 of 168
07:06:00.13 process pointer page 25 of 168
07:06:00.17 process pointer page 26 of 168
07:06:00.25 process pointer page 27 of 168
07:06:00.33 process pointer page 28 of 168
07:06:00.41 process pointer page 29 of 168
07:06:00.44 process pointer page 30 of 168
07:06:00.49 process pointer page 31 of 168
07:06:00.52 process pointer page 32 of 168
07:06:00.55 process pointer page 33 of 168
07:06:00.58 process pointer page 34 of 168
07:06:00.61 process pointer page 35 of 168
07:06:00.64 process pointer page 36 of 168
07:06:00.67 process pointer page 37 of 168
07:06:00.70 process pointer page 38 of 168
07:06:00.74 process pointer page 39 of 168
07:06:00.75 process pointer page 40 of 168
07:06:00.78 process pointer page 41 of 168
07:06:00.80 process pointer page 42 of 168
07:06:00.83 process pointer page 43 of 168
07:06:00.86 process pointer page 44 of 168
07:06:00.89 process pointer page 45 of 168
07:06:00.95 process pointer page 46 of 168
07:06:00.98 process pointer page 47 of 168
07:06:01.06 process pointer page 48 of 168
07:06:01.14 process pointer page 49 of 168
07:06:01.22 process pointer page 50 of 168
07:06:01.30 process pointer page 51 of 168
07:06:01.39 process pointer page 52 of 168
07:06:01.47 process pointer page 53 of 168
07:06:01.55 process pointer page 54 of 168
07:06:01.58 process pointer page 55 of 168
07:06:01.61 process pointer page 56 of 168
07:06:01.64 process pointer page 57 of 168
07:06:01.67 process pointer page 58 of 168
07:06:01.72 process pointer page 59 of 168
07:06:01.75 process pointer page 60 of 168
07:06:01.78 process pointer page 61 of 168
07:06:01.81 process pointer page 62 of 168
07:06:01.86 process pointer page 63 of 168
07:06:01.89 process pointer page 64 of 168
07:06:01.91 process pointer page 65 of 168
07:06:01.94 process pointer page 66 of 168
07:06:01.97 process pointer page 67 of 168
07:06:02.00 process pointer page 68 of 168
07:06:02.03 process pointer page 69 of 168
07:06:02.09 process pointer page 70 of 168
07:06:02.14 process pointer page 71 of 168
07:06:02.17 process pointer page 72 of 168
07:06:02.20 process pointer page 73 of 168
07:06:02.25 process pointer page 74 of 168
07:06:02.28 process pointer page 75 of 168
07:06:02.31 process pointer page 76 of 168
07:06:02.33 process pointer page 77 of 168
07:06:02.36 process pointer page 78 of 168
07:06:02.39 process pointer page 79 of 168
07:06:02.42 process pointer page 80 of 168
07:06:02.44 process pointer page 81 of 168
07:06:02.48 process pointer page 82 of 168
07:06:02.50 process pointer page 83 of 168
07:06:02.53 process pointer page 84 of 168
07:06:02.56 process pointer page 85 of 168
07:06:02.58 process pointer page 86 of 168
07:06:02.61 process pointer page 87 of 168
07:06:02.64 process pointer page 88 of 168
07:06:02.65 process pointer page 89 of 168
07:06:02.69 process pointer page 90 of 168
07:06:02.72 process pointer page 91 of 168
07:06:02.75 process pointer page 92 of 168
07:06:02.78 process pointer page 93 of 168
07:06:02.79 process pointer page 94 of 168
07:06:02.83 process pointer page 95 of 168
07:06:02.84 process pointer page 96 of 168
07:06:02.87 process pointer page 97 of 168
07:06:02.92 process pointer page 98 of 168
07:06:02.95 process pointer page 99 of 168
07:06:02.97 process pointer page 100 of 168
07:06:03.00 process pointer page 101 of 168
07:06:03.03 process pointer page 102 of 168
07:06:03.06 process pointer page 103 of 168
07:06:03.08 process pointer page 104 of 168
07:06:03.11 process pointer page 105 of 168
07:06:03.14 process pointer page 106 of 168
07:06:03.15 process pointer page 107 of 168
07:06:03.18 process pointer page 108 of 168
07:06:03.22 process pointer page 109 of 168
07:06:03.25 process pointer page 110 of 168
07:06:03.28 process pointer page 111 of 168
07:06:03.29 process pointer page 112 of 168
07:06:03.32 process pointer page 113 of 168
07:06:03.36 process pointer page 114 of 168
07:06:03.37 process pointer page 115 of 168
07:06:03.42 process pointer page 116 of 168
07:06:03.50 process pointer page 117 of 168
07:06:03.59 process pointer page 118 of 168
07:06:03.65 process pointer page 119 of 168
07:06:03.68 process pointer page 120 of 168
07:06:03.73 process pointer page 121 of 168
07:06:03.76 process pointer page 122 of 168
07:06:03.79 process pointer page 123 of 168
07:06:03.86 process pointer page 124 of 168
07:06:03.89 process pointer page 125 of 168
07:06:03.95 process pointer page 126 of 168
07:06:04.03 process pointer page 127 of 168
07:06:04.10 process pointer page 128 of 168
07:06:04.14 process pointer page 129 of 168
07:06:04.17 process pointer page 130 of 168
07:06:04.20 process pointer page 131 of 168
07:06:04.23 process pointer page 132 of 168
07:06:04.29 process pointer page 133 of 168
07:06:04.35 process pointer page 134 of 168
07:06:04.40 process pointer page 135 of 168
07:06:04.46 process pointer page 136 of 168
07:06:04.49 process pointer page 137 of 168
07:06:04.54 process pointer page 138 of 168
07:06:04.57 process pointer page 139 of 168
07:06:04.60 process pointer page 140 of 168
07:06:04.64 process pointer page 141 of 168
07:06:04.67 process pointer page 142 of 168
07:06:04.68 process pointer page 143 of 168
07:06:04.71 process pointer page 144 of 168
07:06:04.74 process pointer page 145 of 168
07:06:04.78 process pointer page 146 of 168
07:06:04.82 process pointer page 147 of 168
07:06:04.92 process pointer page 148 of 168
07:06:04.99 process pointer page 149 of 168
07:06:05.07 process pointer page 150 of 168
07:06:05.17 process pointer page 151 of 168
07:06:05.24 process pointer page 152 of 168
07:06:05.32 process pointer page 153 of 168
07:06:05.40 process pointer page 154 of 168
07:06:05.48 process pointer page 155 of 168
07:06:05.56 process pointer page 156 of 168
07:06:05.60 process pointer page 157 of 168
07:06:05.63 process pointer page 158 of 168
07:06:05.66 process pointer page 159 of 168
07:06:05.71 process pointer page 160 of 168
07:06:05.74 process pointer page 161 of 168
07:06:05.77 process pointer page 162 of 168
07:06:05.81 process pointer page 163 of 168
07:06:05.84 process pointer page 164 of 168
07:06:05.87 process pointer page 165 of 168
07:06:05.88 process pointer page 166 of 168
07:06:05.91 process pointer page 167 of 168
07:06:05.91 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:06:08.21 Index 2 (PERF_LOG_UNIT)
07:06:11.61 Index 3 (PERF_LOG_TRN_DESC)
07:06:12.90 Index 4 (PERF_LOG_GDSCODE)
07:06:13.93 Relation 163 (PERF_LOG) is ok

07:06:13.93 Relation 167 (V_STOPTEST)
07:06:13.93 Relation 167 (V_STOPTEST) is ok

07:06:13.93 Relation 184 (V_QDISTR_SOURCE)
07:06:13.93 Relation 184 (V_QDISTR_SOURCE) is ok

07:06:13.93 Relation 185 (V_QSTORNED_SOURCE)
07:06:13.93 Relation 185 (V_QSTORNED_SOURCE) is ok

07:06:13.93 Relation 260 (XQD_1000_1200)
07:06:13.93 process pointer page 0 of 1
07:06:13.93 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:06:13.93 Relation 260 (XQD_1000_1200) is ok

07:06:13.93 Relation 261 (XQD_1200_2000)
07:06:13.93 process pointer page 0 of 2
07:06:13.96 process pointer page 1 of 2
07:06:13.96 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:06:13.96 Relation 261 (XQD_1200_2000) is ok

07:06:13.96 Relation 262 (XQD_1000_3300)
07:06:13.96 process pointer page 0 of 7
07:06:14.00 process pointer page 1 of 7
07:06:14.09 process pointer page 2 of 7
07:06:14.12 process pointer page 3 of 7
07:06:14.18 process pointer page 4 of 7
07:06:14.23 process pointer page 5 of 7
07:06:14.26 process pointer page 6 of 7
07:06:14.26 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:06:14.35 Index 2 (XQD_1000_3300_DOC)
07:06:14.42 Relation 262 (XQD_1000_3300) is ok

07:06:14.42 Relation 263 (XQD_2000_3300)
07:06:14.42 process pointer page 0 of 13
07:06:14.45 process pointer page 1 of 13
07:06:14.56 process pointer page 2 of 13
07:06:14.59 process pointer page 3 of 13
07:06:14.63 process pointer page 4 of 13
07:06:14.67 process pointer page 5 of 13
07:06:14.70 process pointer page 6 of 13
07:06:14.73 process pointer page 7 of 13
07:06:14.78 process pointer page 8 of 13
07:06:14.81 process pointer page 9 of 13
07:06:14.84 process pointer page 10 of 13
07:06:14.87 process pointer page 11 of 13
07:06:14.90 process pointer page 12 of 13
07:06:14.90 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:06:15.02 Relation 263 (XQD_2000_3300) is ok

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

07:06:15.02 Relation 265 (XQD_3300_3400)
07:06:15.02 process pointer page 0 of 23
07:06:15.06 process pointer page 1 of 23
07:06:15.09 process pointer page 2 of 23
07:06:15.10 process pointer page 3 of 23
07:06:15.13 process pointer page 4 of 23
07:06:15.17 process pointer page 5 of 23
07:06:15.21 process pointer page 6 of 23
07:06:15.31 process pointer page 7 of 23
07:06:15.40 process pointer page 8 of 23
07:06:15.46 process pointer page 9 of 23
07:06:15.49 process pointer page 10 of 23
07:06:15.56 process pointer page 11 of 23
07:06:15.59 process pointer page 12 of 23
07:06:15.63 process pointer page 13 of 23
07:06:15.70 process pointer page 14 of 23
07:06:15.79 process pointer page 15 of 23
07:06:15.87 process pointer page 16 of 23
07:06:15.96 process pointer page 17 of 23
07:06:16.04 process pointer page 18 of 23
07:06:16.13 process pointer page 19 of 23
07:06:16.23 process pointer page 20 of 23
07:06:16.27 process pointer page 21 of 23
07:06:16.32 process pointer page 22 of 23
07:06:16.35 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:06:16.91 Relation 265 (XQD_3300_3400) is ok

07:06:16.91 Relation 266 (XQS_1000_1200)
07:06:16.91 process pointer page 0 of 41
07:06:16.94 process pointer page 1 of 41
07:06:17.02 process pointer page 2 of 41
07:06:17.12 process pointer page 3 of 41
07:06:17.16 process pointer page 4 of 41
07:06:17.21 process pointer page 5 of 41
07:06:17.24 process pointer page 6 of 41
07:06:17.27 process pointer page 7 of 41
07:06:17.30 process pointer page 8 of 41
07:06:17.35 process pointer page 9 of 41
07:06:17.38 process pointer page 10 of 41
07:06:17.41 process pointer page 11 of 41
07:06:17.46 process pointer page 12 of 41
07:06:17.54 process pointer page 13 of 41
07:06:17.63 process pointer page 14 of 41
07:06:17.71 process pointer page 15 of 41
07:06:17.74 process pointer page 16 of 41
07:06:17.77 process pointer page 17 of 41
07:06:17.83 process pointer page 18 of 41
07:06:17.93 process pointer page 19 of 41
07:06:18.02 process pointer page 20 of 41
07:06:18.11 process pointer page 21 of 41
07:06:18.21 process pointer page 22 of 41
07:06:18.24 process pointer page 23 of 41
07:06:18.30 process pointer page 24 of 41
07:06:18.33 process pointer page 25 of 41
07:06:18.36 process pointer page 26 of 41
07:06:18.43 process pointer page 27 of 41
07:06:18.52 process pointer page 28 of 41
07:06:18.60 process pointer page 29 of 41
07:06:18.69 process pointer page 30 of 41
07:06:18.78 process pointer page 31 of 41
07:06:18.88 process pointer page 32 of 41
07:06:18.96 process pointer page 33 of 41
07:06:19.05 process pointer page 34 of 41
07:06:19.08 process pointer page 35 of 41
07:06:19.16 process pointer page 36 of 41
07:06:19.25 process pointer page 37 of 41
07:06:19.33 process pointer page 38 of 41
07:06:19.42 process pointer page 39 of 41
07:06:19.52 process pointer page 40 of 41
07:06:19.53 Index 1 (XQS_1000_1200_DOC_ID)
07:06:20.05 Index 2 (XQS_1000_1200_SND_ID)
07:06:20.81 Index 3 (XQS_1000_1200_RCV_ID)
07:06:21.20 Relation 266 (XQS_1000_1200) is ok

07:06:21.20 Relation 267 (XQS_1200_2000)
07:06:21.20 process pointer page 0 of 43
07:06:21.30 process pointer page 1 of 43
07:06:21.37 process pointer page 2 of 43
07:06:21.47 process pointer page 3 of 43
07:06:21.56 process pointer page 4 of 43
07:06:21.64 process pointer page 5 of 43
07:06:21.73 process pointer page 6 of 43
07:06:21.83 process pointer page 7 of 43
07:06:21.87 process pointer page 8 of 43
07:06:21.90 process pointer page 9 of 43
07:06:21.94 process pointer page 10 of 43
07:06:22.01 process pointer page 11 of 43
07:06:22.06 process pointer page 12 of 43
07:06:22.12 process pointer page 13 of 43
07:06:22.15 process pointer page 14 of 43
07:06:22.20 process pointer page 15 of 43
07:06:22.23 process pointer page 16 of 43
07:06:22.29 process pointer page 17 of 43
07:06:22.39 process pointer page 18 of 43
07:06:22.48 process pointer page 19 of 43
07:06:22.56 process pointer page 20 of 43
07:06:22.65 process pointer page 21 of 43
07:06:22.75 process pointer page 22 of 43
07:06:22.78 process pointer page 23 of 43
07:06:22.82 process pointer page 24 of 43
07:06:22.90 process pointer page 25 of 43
07:06:22.93 process pointer page 26 of 43
07:06:23.01 process pointer page 27 of 43
07:06:23.09 process pointer page 28 of 43
07:06:23.18 process pointer page 29 of 43
07:06:23.25 process pointer page 30 of 43
07:06:23.28 process pointer page 31 of 43
07:06:23.34 process pointer page 32 of 43
07:06:23.43 process pointer page 33 of 43
07:06:23.51 process pointer page 34 of 43
07:06:23.60 process pointer page 35 of 43
07:06:23.70 process pointer page 36 of 43
07:06:23.73 process pointer page 37 of 43
07:06:23.76 process pointer page 38 of 43
07:06:23.79 process pointer page 39 of 43
07:06:23.87 process pointer page 40 of 43
07:06:23.95 process pointer page 41 of 43
07:06:24.06 process pointer page 42 of 43
07:06:24.09 Index 1 (XQS_1200_2000_DOC_ID)
07:06:24.54 Index 2 (XQS_1200_2000_SND_ID)
07:06:24.96 Index 3 (XQS_1200_2000_RCV_ID)
07:06:25.55 Relation 267 (XQS_1200_2000) is ok

07:06:25.55 Relation 268 (XQS_1000_3300)
07:06:25.57 process pointer page 0 of 25
07:06:25.60 process pointer page 1 of 25
07:06:25.63 process pointer page 2 of 25
07:06:25.66 process pointer page 3 of 25
07:06:25.68 process pointer page 4 of 25
07:06:25.71 process pointer page 5 of 25
07:06:25.74 process pointer page 6 of 25
07:06:25.76 process pointer page 7 of 25
07:06:25.79 process pointer page 8 of 25
07:06:25.80 process pointer page 9 of 25
07:06:25.84 process pointer page 10 of 25
07:06:25.85 process pointer page 11 of 25
07:06:25.88 process pointer page 12 of 25
07:06:25.91 process pointer page 13 of 25
07:06:25.94 process pointer page 14 of 25
07:06:25.98 process pointer page 15 of 25
07:06:26.01 process pointer page 16 of 25
07:06:26.02 process pointer page 17 of 25
07:06:26.09 process pointer page 18 of 25
07:06:26.12 process pointer page 19 of 25
07:06:26.15 process pointer page 20 of 25
07:06:26.19 process pointer page 21 of 25
07:06:26.23 process pointer page 22 of 25
07:06:26.26 process pointer page 23 of 25
07:06:26.29 process pointer page 24 of 25
07:06:26.30 Index 1 (XQS_1000_3300_DOC_ID)
07:06:26.85 Index 2 (XQS_1000_3300_SND_ID)
07:06:27.18 Index 3 (XQS_1000_3300_RCV_ID)
07:06:27.41 Relation 268 (XQS_1000_3300) is ok

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

07:06:27.41 Relation 270 (XQS_2100_3300)
07:06:27.41 process pointer page 0 of 31
07:06:27.44 process pointer page 1 of 31
07:06:27.46 process pointer page 2 of 31
07:06:27.49 process pointer page 3 of 31
07:06:27.52 process pointer page 4 of 31
07:06:27.55 process pointer page 5 of 31
07:06:27.58 process pointer page 6 of 31
07:06:27.61 process pointer page 7 of 31
07:06:27.65 process pointer page 8 of 31
07:06:27.68 process pointer page 9 of 31
07:06:27.74 process pointer page 10 of 31
07:06:27.79 process pointer page 11 of 31
07:06:27.85 process pointer page 12 of 31
07:06:27.88 process pointer page 13 of 31
07:06:27.96 process pointer page 14 of 31
07:06:27.99 process pointer page 15 of 31
07:06:28.05 process pointer page 16 of 31
07:06:28.08 process pointer page 17 of 31
07:06:28.11 process pointer page 18 of 31
07:06:28.16 process pointer page 19 of 31
07:06:28.19 process pointer page 20 of 31
07:06:28.22 process pointer page 21 of 31
07:06:28.27 process pointer page 22 of 31
07:06:28.30 process pointer page 23 of 31
07:06:28.33 process pointer page 24 of 31
07:06:28.36 process pointer page 25 of 31
07:06:28.39 process pointer page 26 of 31
07:06:28.47 process pointer page 27 of 31
07:06:28.52 process pointer page 28 of 31
07:06:28.55 process pointer page 29 of 31
07:06:28.58 process pointer page 30 of 31
07:06:28.61 Index 1 (XQS_2100_3300_DOC_ID)
07:06:29.39 Index 2 (XQS_2100_3300_SND_ID)
07:06:29.81 Index 3 (XQS_2100_3300_RCV_ID)
07:06:30.38 Relation 270 (XQS_2100_3300) is ok

07:06:30.38 Relation 271 (XQS_3300_3400)
07:06:30.38 process pointer page 0 of 5
07:06:30.41 process pointer page 1 of 5
07:06:30.45 process pointer page 2 of 5
07:06:30.55 process pointer page 3 of 5
07:06:30.64 process pointer page 4 of 5
07:06:30.67 Index 1 (XQS_3300_3400_DOC_ID)
07:06:30.73 Index 2 (XQS_3300_3400_SND_ID)
07:06:30.89 Relation 271 (XQS_3300_3400) is ok

07:06:30.91 Validation finished
Done for 35290 ms, from 7:05:55.63 to 7:06:30.92.

Differences between old and current firebird.log

7:06:32.01. 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:
2018-01-12 07:06 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 Fri Jan 12 07:05:55 2018
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Fri Jan 12 07:06:30 2018
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.
2018-01-12 7:06:36.27 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html