Tests

Generated by E:\OLTP-EMUL\src\oltp_isql_run_worker.bat, ISQL session #1 of total launched 100. 2017-05-13 6:52:31.27.
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.32721 Firebird 3.0
Server implementation: Firebird/Windows/AMD/Intel/x64
FB_ARCHITECTURE DB_NAME FORCED_WRITES SWEEP_INT PAGE_BUFFERS PAGE_SIZE
SuperServer 3.0.3 D:\OLTP-EMUL\OLTP30-SMALL.FDB ON 0 786432 8192

Test configuration settings

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

Test finish info

FINISH_STATE DTS_END FB_GDSCODE FB_MNEMONA STACK IP TRN_ID ATT_ID EXC_UNIT
NORMAL: TEST_TIME EXPIRED. 2017-05-13 06:49:35.2440 -1 <null> ::1/62984 451329 9339 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: 6413.43 2619 1154418 2017-05-13 03:49 2017-05-13 06:49
customer order: creation 473.91 406 85304 2017-05-13 03:49 2017-05-13 06:49
customer order: refuse 37.91 216 6824 2017-05-13 03:49 2017-05-13 06:49
order to supplier: creation 121.56 1708 21881 2017-05-13 03:49 2017-05-13 06:49
order to supplier: removal 3.40 15619 612 2017-05-13 03:49 2017-05-13 06:49
invoice (draft): creation 122.36 2498 22024 2017-05-13 03:49 2017-05-13 06:49
invoice (draft): removal 45.49 364 8189 2017-05-13 03:49 2017-05-13 06:49
invoice accept: apply 67.53 8709 12156 2017-05-13 03:49 2017-05-13 06:49
invoice accept: cancel 19.99 2077 3598 2017-05-13 03:49 2017-05-13 06:49
customer reserve: creation 3680.79 129 662542 2017-05-13 03:49 2017-05-13 06:49
customer reserve: removal 1191.07 50 214392 2017-05-13 03:49 2017-05-13 06:49
realization accept: apply 216.33 414 38940 2017-05-13 03:49 2017-05-13 06:49
realization accept: cancel 93.39 126 16810 2017-05-13 03:49 2017-05-13 06:49
payment from customer: creation 158.59 757 28547 2017-05-13 03:49 2017-05-13 06:49
payment from customer: removal 14.82 108 2668 2017-05-13 03:49 2017-05-13 06:49
payment to supplier: creation 129.86 388 23374 2017-05-13 03:49 2017-05-13 06:49
payment to supplier: removal 8.86 116 1595 2017-05-13 03:49 2017-05-13 06:49
service: total inventory turnovers 10.24 2262 1844 2017-05-13 03:49 2017-05-13 06:49
service: total monetary turnovers 17.26 61 3106 2017-05-13 03:49 2017-05-13 06:49
service: refresh index statistics 0.07 13750 12 2017-05-13 03:49 2017-05-13 06:49
Done for 126300 ms, from 6:55:35.74 to 6:57:42.04.

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 4909 102019 88368 13651 13.38 03:49:36 04:07:35
interval # 2, overall 2 6968 140491 125423 15068 10.73 04:07:36 04:25:35
interval # 3, overall 3 7071 147096 127282 19814 13.47 04:25:36 04:43:35
interval # 4, overall 4 6657 135559 119831 15728 11.60 04:43:36 05:01:35
interval # 5, overall 5 6267 140266 112809 27457 19.57 05:01:36 05:19:35
interval # 6, overall 6 6988 154332 125778 28554 18.50 05:19:36 05:37:35
interval # 7, overall 7 6499 132999 116982 16017 12.04 05:37:36 05:55:35
interval # 8, overall 8 6278 131235 113012 18223 13.89 05:55:36 06:13:35
interval # 9, overall 9 6011 121457 108191 13266 10.92 06:13:36 06:31:35
interval # 10, overall 10 6486 128733 116742 11991 9.31 06:31:36 06:49:35
Done for 312740 ms, from 7:02:50.65 to 7:08:03.39.

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 3569.66 0.2708 1.5749 2061 72
TEST_TIME 2 3685.13 0.7627 1.2447 1749 99
TEST_TIME 3 3703.43 0.8258 1.2086 1820 99
TEST_TIME 4 3804.74 0.8826 1.1244 1703 99
TEST_TIME 5 3814.02 0.8983 1.1054 1801 99
TEST_TIME 6 3849.88 0.9137 1.0956 1632 99
TEST_TIME 7 3939.89 0.9177 1.0828 1579 99
TEST_TIME 8 4107.22 0.9090 1.1031 2113 99
TEST_TIME 9 4353.90 0.9251 1.0687 1584 99
TEST_TIME 10 4476.32 0.9356 1.0687 1834 99
TEST_TIME 11 4617.62 0.9419 1.0580 1830 99
TEST_TIME 12 4726.92 0.9475 1.0455 1662 99
TEST_TIME 13 4770.25 0.9564 1.0463 1700 99
TEST_TIME 14 4816.84 0.9635 1.0370 1480 99
TEST_TIME 15 4757.47 0.9800 1.0375 1545 99
TEST_TIME 16 4763.94 0.9713 1.0274 1635 99
TEST_TIME 17 4757.91 0.9687 1.0279 1538 98
TEST_TIME 18 4880.64 0.9584 1.0416 1994 99
TEST_TIME 19 4993.81 0.9644 1.0343 2173 99
TEST_TIME 20 5099.15 0.9623 1.0386 1930 99
TEST_TIME 21 5242.24 0.9622 1.0342 1759 99
TEST_TIME 22 5331.87 0.9707 1.0271 1833 99
TEST_TIME 23 5400.29 0.9700 1.0279 1867 99
TEST_TIME 24 5463.70 0.9738 1.0264 1548 99
TEST_TIME 25 5531.85 0.9733 1.0307 1552 99
TEST_TIME 26 5611.03 0.9777 1.0190 1419 99
TEST_TIME 27 5597.37 0.9837 1.0189 1518 99
TEST_TIME 28 5598.98 0.9823 1.0200 1475 99
TEST_TIME 29 5607.30 0.9834 1.0180 1268 99
TEST_TIME 30 5622.27 0.9814 1.0175 1455 99
TEST_TIME 31 5704.00 0.9705 1.0294 2070 99
TEST_TIME 32 5800.80 0.9806 1.0201 2150 99
TEST_TIME 33 5864.12 0.9785 1.0170 1682 99
TEST_TIME 34 5873.94 0.9854 1.0150 1696 99
TEST_TIME 35 5909.38 0.9837 1.0117 1835 99
TEST_TIME 36 5888.48 0.9871 1.0174 1714 97
TEST_TIME 37 5881.88 0.9910 1.0146 1157 99
TEST_TIME 38 5882.30 0.9878 1.0143 1819 99
TEST_TIME 39 5911.92 0.9834 1.0168 1499 99
TEST_TIME 40 5934.49 0.9876 1.0140 1609 99
TEST_TIME 41 5934.44 0.9893 1.0135 1547 99
TEST_TIME 42 5950.52 0.9867 1.0136 1493 99
TEST_TIME 43 5977.81 0.9858 1.0150 1429 99
TEST_TIME 44 6002.17 0.9881 1.0107 1377 99
TEST_TIME 45 6018.54 0.9856 1.0153 1246 99
TEST_TIME 46 6072.75 0.9844 1.0157 2239 99
TEST_TIME 47 6147.49 0.9820 1.0180 2432 99
TEST_TIME 48 6217.54 0.9856 1.0179 2021 99
TEST_TIME 49 6275.34 0.9880 1.0115 1840 99
TEST_TIME 50 6301.39 0.9871 1.0109 1884 99
TEST_TIME 51 6305.62 0.9905 1.0071 1798 99
TEST_TIME 52 6305.17 0.9923 1.0076 1565 98
TEST_TIME 53 6329.50 0.9848 1.0060 1380 99
TEST_TIME 54 6294.60 0.9929 1.0098 1631 98
TEST_TIME 55 6299.63 0.9907 1.0088 1383 99
TEST_TIME 56 6313.18 0.9897 1.0085 1146 98
TEST_TIME 57 6312.18 0.9910 1.0087 1488 99
TEST_TIME 58 6319.62 0.9907 1.0099 1383 99
TEST_TIME 59 6336.41 0.9902 1.0044 1323 99
TEST_TIME 60 6324.79 0.9895 1.0089 1322 99
TEST_TIME 61 6355.82 0.9875 1.0116 2329 99
TEST_TIME 62 6404.33 0.9878 1.0122 1748 99
TEST_TIME 63 6441.75 0.9904 1.0080 1538 99
TEST_TIME 64 6459.15 0.9896 1.0084 1946 99
TEST_TIME 65 6462.40 0.9924 1.0078 1828 99
TEST_TIME 66 6462.95 0.9925 1.0051 1873 99
TEST_TIME 67 6437.26 0.9940 1.0069 1712 95
TEST_TIME 68 6429.35 0.9933 1.0065 1544 96
TEST_TIME 69 6450.47 0.9887 1.0056 1265 99
TEST_TIME 70 6432.54 0.9940 1.0057 1298 99
TEST_TIME 71 6422.16 0.9931 1.0035 1497 99
TEST_TIME 72 6381.38 0.9959 1.0045 1441 98
TEST_TIME 73 6383.60 0.9904 1.0048 1270 98
TEST_TIME 74 6349.54 0.9966 1.0059 1099 98
TEST_TIME 75 6337.90 0.9956 1.0056 1163 99
TEST_TIME 76 6347.60 0.9909 1.0119 1857 99
TEST_TIME 77 6376.68 0.9943 1.0062 2158 98
TEST_TIME 78 6403.82 0.9890 1.0080 1744 98
TEST_TIME 79 6425.40 0.9921 1.0063 1824 99
TEST_TIME 80 6425.99 0.9936 1.0071 1798 99
TEST_TIME 81 6428.42 0.9942 1.0038 1817 99
TEST_TIME 82 6429.39 0.9915 1.0068 1670 98
TEST_TIME 83 6417.71 0.9965 1.0068 1694 99
TEST_TIME 84 6418.80 0.9949 1.0052 1607 99
TEST_TIME 85 6413.00 0.9943 1.0026 1507 99
TEST_TIME 86 6390.37 0.9944 1.0034 1325 95
TEST_TIME 87 6364.20 0.9959 1.0067 1270 97
TEST_TIME 88 6369.85 0.9944 1.0053 1318 99
TEST_TIME 89 6357.31 0.9960 1.0041 1385 99
TEST_TIME 90 6366.28 0.9916 1.0040 1162 99
TEST_TIME 91 6347.95 0.9959 1.0040 2188 97
TEST_TIME 92 6357.36 0.9916 1.0056 1860 98
TEST_TIME 93 6349.94 0.9960 1.0059 1761 87
TEST_TIME 94 6362.85 0.9932 1.0054 1623 98
TEST_TIME 95 6365.21 0.9948 1.0061 1577 99
TEST_TIME 96 6384.39 0.9927 1.0068 1690 99
TEST_TIME 97 6410.51 0.9924 1.0072 1527 99
TEST_TIME 98 6433.98 0.9933 1.0059 1486 99
TEST_TIME 99 6443.13 0.9943 1.0055 1507 99
TEST_TIME 100 6462.26 0.9925 1.0070 1338 99
TEST_TIME 101 6473.22 0.9954 1.0059 1299 99
TEST_TIME 102 6479.00 0.9953 1.0050 1201 99
TEST_TIME 103 6461.31 0.9979 1.0021 1395 97
TEST_TIME 104 6444.50 0.9950 1.0046 1261 98
TEST_TIME 105 6433.05 0.9968 1.0042 1121 99
TEST_TIME 106 6434.77 0.9945 1.0030 2015 99
TEST_TIME 107 6429.91 0.9944 1.0058 1929 99
TEST_TIME 108 6457.90 0.9922 1.0064 1983 99
TEST_TIME 109 6471.70 0.9950 1.0031 1958 98
TEST_TIME 110 6459.01 0.9960 1.0035 1751 97
TEST_TIME 111 6447.62 0.9962 1.0058 1539 97
TEST_TIME 112 6438.16 0.9983 1.0021 1487 82
TEST_TIME 113 6445.25 0.9927 1.0024 1138 92
TEST_TIME 114 6437.28 0.9949 1.0025 1421 91
TEST_TIME 115 6418.26 0.9967 1.0069 1107 88
TEST_TIME 116 6426.29 0.9969 1.0033 1258 96
TEST_TIME 117 6410.58 0.9971 1.0040 1447 97
TEST_TIME 118 6413.59 0.9951 1.0030 1396 98
TEST_TIME 119 6406.29 0.9958 1.0044 1294 99
TEST_TIME 120 6408.41 0.9957 1.0052 1242 99
TEST_TIME 121 6424.15 0.9947 1.0055 1769 99
TEST_TIME 122 6440.93 0.9946 1.0042 1948 99
TEST_TIME 123 6457.76 0.9934 1.0064 1828 99
TEST_TIME 124 6473.16 0.9961 1.0042 1770 99
TEST_TIME 125 6467.32 0.9971 1.0037 1233 98
TEST_TIME 126 6459.26 0.9970 1.0035 1574 94
TEST_TIME 127 6462.27 0.9954 1.0091 1274 99
TEST_TIME 128 6497.95 0.9957 1.0041 1436 99
TEST_TIME 129 6494.54 0.9969 1.0026 1606 97
TEST_TIME 130 6480.69 0.9970 1.0024 1578 97
TEST_TIME 131 6468.76 0.9966 1.0036 1422 96
TEST_TIME 132 6459.88 0.9974 1.0043 1362 97
TEST_TIME 133 6449.66 0.9983 1.0045 1193 97
TEST_TIME 134 6447.20 0.9974 1.0037 1226 99
TEST_TIME 135 6444.68 0.9967 1.0026 1410 99
TEST_TIME 136 6444.75 0.9953 1.0049 1939 99
TEST_TIME 137 6452.09 0.9964 1.0042 2078 97
TEST_TIME 138 6447.08 0.9977 1.0031 1970 94
TEST_TIME 139 6454.22 0.9948 1.0033 1633 95
TEST_TIME 140 6454.43 0.9961 1.0049 1430 96
TEST_TIME 141 6464.59 0.9962 1.0041 1449 98
TEST_TIME 142 6464.08 0.9971 1.0020 1594 99
TEST_TIME 143 6448.11 0.9974 1.0053 1556 99
TEST_TIME 144 6445.92 0.9987 1.0019 1500 98
TEST_TIME 145 6449.50 0.9957 1.0020 1555 98
TEST_TIME 146 6437.28 0.9971 1.0040 1419 98
TEST_TIME 147 6438.61 0.9970 1.0043 1361 98
TEST_TIME 148 6436.84 0.9978 1.0013 1338 99
TEST_TIME 149 6417.75 0.9975 1.0027 1335 98
TEST_TIME 150 6412.81 0.9967 1.0019 1385 88
TEST_TIME 151 6404.24 0.9966 1.0026 1596 93
TEST_TIME 152 6405.98 0.9957 1.0057 1869 96
TEST_TIME 153 6421.47 0.9967 1.0039 1845 93
TEST_TIME 154 6425.45 0.9968 1.0020 1755 98
TEST_TIME 155 6420.02 0.9964 1.0024 1649 96
TEST_TIME 156 6412.95 0.9986 1.0017 1452 93
TEST_TIME 157 6407.20 0.9968 1.0026 1298 96
TEST_TIME 158 6396.21 0.9980 1.0021 1335 88
TEST_TIME 159 6395.10 0.9960 1.0047 1393 95
TEST_TIME 160 6397.44 0.9980 1.0020 1526 95
TEST_TIME 161 6393.40 0.9964 1.0015 1280 98
TEST_TIME 162 6395.02 0.9963 1.0040 1409 97
TEST_TIME 163 6394.68 0.9979 1.0026 1229 99
TEST_TIME 164 6383.58 0.9982 1.0027 1370 98
TEST_TIME 165 6398.74 0.9962 1.0020 1268 99
TEST_TIME 166 6396.02 0.9964 1.0039 1626 96
TEST_TIME 167 6398.88 0.9975 1.0026 1977 95
TEST_TIME 168 6407.29 0.9953 1.0026 1702 92
TEST_TIME 169 6408.65 0.9965 1.0021 1687 89
TEST_TIME 170 6408.46 0.9962 1.0033 1480 87
TEST_TIME 171 6407.22 0.9976 1.0041 1374 79
TEST_TIME 172 6415.05 0.9970 1.0031 1297 85
TEST_TIME 173 6407.59 0.9985 1.0021 1503 77
TEST_TIME 174 6398.49 0.9978 1.0019 1260 81
TEST_TIME 175 6394.51 0.9968 1.0024 1276 76
TEST_TIME 176 6392.12 0.9971 1.0047 1180 91
TEST_TIME 177 6404.43 0.9971 1.0019 1169 98
TEST_TIME 178 6390.26 0.9985 1.0024 1284 95
TEST_TIME 179 6392.21 0.9973 1.0035 1072 98
TEST_TIME 180 6396.28 0.9973 1.0026 697 99
Done for 10700 ms, from 7:08:05.03 to 7:08:15.73.

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 57073 58794 61673 <null> 70992 127589 88729 112478 15819 82014 74070 53204 100054 142091 199017 <null> 88113 315433 <null> 03:49:36 04:07:35
fetches per second 2 59467 158321 54987 <null> 64129 29390 78398 24867 98254 4374 62968 58401 115913 64209 109143 129166 66976 124728 <null> 04:07:36 04:25:35
fetches per second 3 46472 83977 45242 103507 53644 20070 53832 126071 75204 20949 67019 41263 112682 54734 105274 22023 232698 106136 <null> 04:25:36 04:43:35
fetches per second 4 30842 25460 42826 <null> 22690 113047 57145 <null> 18037 7014 31904 21902 51597 15828 55412 <null> 53360 47870 <null> 04:43:36 05:01:35
fetches per second 5 27597 64610 20423 <null> 29461 142216 72244 58320 <null> 117787 35123 5082 29144 4668 64628 19388 152819 13710 <null> 05:01:36 05:19:35
fetches per second 6 34263 115465 45128 <null> 39053 265000 72118 52697 3606 40298 62939 17687 59635 50703 84331 29831 265374 141882 <null> 05:19:36 05:37:35
fetches per second 7 23280 26161 20081 <null> 24414 105603 41032 5176 4707 44660 39655 2327 39513 23016 39867 4808 323199 38909 <null> 05:37:36 05:55:35
fetches per second 8 14553 10958 6171 <null> 15849 <null> 18969 5231 15396 11206 29033 6355 18231 73018 22172 2626 16169 174784 <null> 05:55:36 06:13:35
fetches per second 9 3734 4061 11218 6398 18401 1488 50846 7291 1269 9324 10398 1192 11826 17854 90114 6473 <null> 94811 <null> 06:13:36 06:31:35
fetches per second 10 10033 6676 7062 9997 14840 <null> 28689 10217 1660 3325 5331 713 12116 87484 20375 <null> 40308 70339 <null> 06:31:36 06:49:35
marks per second 1 12356 7290 12976 <null> 15692 26028 11170 18736 2248 17447 11409 8221 5229 30363 7085 <null> 7292 39576 <null> 03:49:36 04:07:35
marks per second 2 12492 19785 12112 <null> 14491 6731 9953 3941 10970 710 9711 8644 6856 9124 7259 20000 16556 7672 <null> 04:07:36 04:25:35
marks per second 3 9320 11338 10039 25750 11963 3575 7112 17814 7659 3380 9840 6362 5969 8393 11147 3099 33613 15175 <null> 04:25:36 04:43:35
marks per second 4 6498 2922 8345 <null> 4564 28142 6598 <null> 2294 1472 3912 3599 2596 3238 6524 <null> 3424 2811 <null> 04:43:36 05:01:35
marks per second 5 5837 8699 4141 <null> 6308 31270 8378 8232 <null> 20017 5433 785 1345 730 9688 3849 18619 994 <null> 05:01:36 05:19:35
marks per second 6 7042 13831 8875 <null> 8178 64933 7938 7531 319 6906 7778 2917 2037 7261 11674 4486 24516 14932 <null> 05:19:36 05:37:35
marks per second 7 4771 3656 3967 <null> 5145 22155 4793 727 712 7439 4991 375 1484 3897 5533 949 13283 344 <null> 05:37:36 05:55:35
marks per second 8 3133 1266 1144 <null> 3249 <null> 2176 729 1444 1657 3421 1090 640 12490 2850 445 1420 7417 <null> 05:55:36 06:13:35
marks per second 9 774 512 1560 990 2561 345 4593 987 132 1423 728 127 314 2653 7190 1136 <null> 872 <null> 06:13:36 06:31:35
marks per second 10 2097 789 972 1557 2302 <null> 2258 1694 171 481 829 104 264 6993 2287 <null> 444 522 <null> 06:31:36 06:49:35
reads/fetches*100 1 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 03:49:36 04:07:35
reads/fetches*100 2 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:07:36 04:25:35
reads/fetches*100 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 04:25:36 04:43:35
reads/fetches*100 4 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 <null> 0 0 <null> 04:43:36 05:01:35
reads/fetches*100 5 0 0 0 <null> 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 <null> 05:01:36 05:19:35
reads/fetches*100 6 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:19:36 05:37:35
reads/fetches*100 7 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:37:36 05:55:35
reads/fetches*100 8 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 05:55:36 06:13:35
reads/fetches*100 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 0 <null> 06:13:36 06:31:35
reads/fetches*100 10 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 06:31:36 06:49:35
writes/marks*100 1 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> 3 0 <null> 03:49:36 04:07:35
writes/marks*100 2 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 2 0 <null> 04:07:36 04:25:35
writes/marks*100 3 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 <null> 04:25:36 04:43:35
writes/marks*100 4 0 0 0 <null> 0 0 0 <null> 1 0 0 0 0 0 0 <null> 3 0 <null> 04:43:36 05:01:35
writes/marks*100 5 0 0 0 <null> 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 <null> 05:01:36 05:19:35
writes/marks*100 6 1 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 2 0 <null> 05:19:36 05:37:35
writes/marks*100 7 0 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 0 0 <null> 05:37:36 05:55:35
writes/marks*100 8 0 0 0 <null> 0 <null> 0 0 1 1 0 0 0 0 0 0 0 0 <null> 05:55:36 06:13:35
writes/marks*100 9 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 <null> 0 <null> 06:13:36 06:31:35
writes/marks*100 10 0 0 0 0 1 <null> 0 0 1 0 0 0 0 0 0 <null> 7 0 <null> 06:31:36 06:49:35
Done for 10190 ms, from 7:08:17.07 to 7:08:27.26.

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 2033865 1866301 167564 8.23 0 11466 37 167564 2017-05-13 03:49 2017-05-13 06:49
doc_list_biud 2034338 1866301 168037 8.26 0 7644 13 168037 2017-05-13 03:49 2017-05-13 06:49
sp_add_invoice_to_stock 20403 12156 8247 40.42 15 135190 8709 8247 2017-05-13 03:49 2017-05-13 06:49
sp_cancel_adding_invoice 4856 3598 1258 25.90 0 54444 2077 1258 2017-05-13 03:49 2017-05-13 06:49
sp_cancel_client_order 6991 6824 167 2.38 0 4072 216 167 2017-05-13 03:49 2017-05-13 06:49
sp_cancel_customer_reserve 372132 214392 157740 42.38 0 6489 50 157740 2017-05-13 03:49 2017-05-13 06:49
sp_cancel_pay_from_customer 2684 2668 16 0.59 0 1669 108 16 2017-05-13 03:49 2017-05-13 06:49
sp_cancel_pay_to_supplier 1599 1595 4 0.25 0 3915 116 4 2017-05-13 03:49 2017-05-13 06:49
sp_cancel_supplier_invoice 10726 8189 2537 23.65 0 7894 364 2537 2017-05-13 03:49 2017-05-13 06:49
sp_cancel_supplier_order 1662 612 1050 63.17 47 187170 15619 1050 2017-05-13 03:49 2017-05-13 06:49
sp_cancel_write_off 24061 16810 7251 30.13 0 3744 126 7251 2017-05-13 03:49 2017-05-13 06:49
sp_client_order 85304 85304 0 0.00 0 6427 406 0 2017-05-13 03:49 2017-05-13 06:49
sp_customer_reserve 662542 662542 0 0.00 0 7457 129 0 2017-05-13 03:49 2017-05-13 06:49
sp_fill_shopping_cart 129532 129209 323 0.24 0 3931 81 0 2017-05-13 03:49 2017-05-13 06:49
sp_fill_shopping_cart_clo_res 662542 662542 0 0.00 0 2699 9 0 2017-05-13 03:49 2017-05-13 06:49
sp_get_clo_for_invoice 12156 12156 0 0.00 0 4165 250 0 2017-05-13 03:49 2017-05-13 06:49
sp_kill_cost_storno 32767 24671 8096 24.70 0 2137 17 8096 2017-05-13 03:49 2017-05-13 06:49
sp_kill_qstorno_ret_qs2qd 778700 454395 324305 41.64 0 7644 19 324305 2017-05-13 03:49 2017-05-13 06:49
sp_kill_qty_storno 469461 301521 167940 35.77 0 7644 59 167940 2017-05-13 03:49 2017-05-13 06:49
sp_lock_selected_doc 83592 71891 11701 13.99 0 3916 6 11701 2017-05-13 03:49 2017-05-13 06:49
sp_make_cost_storno 103017 103017 0 0.00 0 8455 305 0 2017-05-13 03:49 2017-05-13 06:49
sp_multiply_rows_for_pdistr 103017 103017 0 0.00 0 3697 47 0 2017-05-13 03:49 2017-05-13 06:49
sp_multiply_rows_for_qdistr 85304 85304 0 0.00 0 4212 135 0 2017-05-13 03:49 2017-05-13 06:49
sp_pay_from_customer 28547 28547 0 0.00 0 11872 757 0 2017-05-13 03:49 2017-05-13 06:49
sp_pay_to_supplier 23374 23374 0 0.00 0 7707 388 0 2017-05-13 03:49 2017-05-13 06:49
sp_payment_common 51921 51921 0 0.00 0 3697 55 0 2017-05-13 03:49 2017-05-13 06:49
sp_qd_handle_on_cancel_clo 6990 6824 166 2.37 0 2200 92 166 2017-05-13 03:49 2017-05-13 06:49
sp_qd_handle_on_invoice_upd_sts 16809 15754 1055 6.27 0 4727 289 1055 2017-05-13 03:49 2017-05-13 06:49
sp_qd_handle_on_reserve_upd_sts 38940 38940 0 0.00 0 2683 43 0 2017-05-13 03:49 2017-05-13 06:49
sp_reserve_write_off 40116 38940 1176 2.93 0 7332 414 1176 2017-05-13 03:49 2017-05-13 06:49
sp_supplier_invoice 22150 22024 126 0.56 0 32932 2498 0 2017-05-13 03:49 2017-05-13 06:49
sp_supplier_order 22078 21881 197 0.89 0 14445 1708 0 2017-05-13 03:49 2017-05-13 06:49
srv_find_qd_qs_mism 1223371 1055819 167552 13.69 0 4399 20 167552 2017-05-13 03:49 2017-05-13 06:49
srv_make_invnt_saldo 1844 1844 0 0.00 31 44694 2262 0 2017-05-13 03:49 2017-05-13 06:49
srv_make_money_saldo 3106 3106 0 0.00 0 2184 61 0 2017-05-13 03:49 2017-05-13 06:49
srv_recalc_idx_stat 12 12 0 0.00 2106 44959 13750 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_add_invoice_to_stock 8247 8247 0 0.00 0 1685 86 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_cancel_adding_invoice 779 779 0 0.00 0 1794 143 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_cancel_client_order 167 167 0 0.00 0 1732 87 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_cancel_customer_reserve 105 105 0 0.00 0 951 48 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_cancel_pay_from_customer 16 16 0 0.00 0 297 43 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_cancel_pay_to_supplier 4 4 0 0.00 0 0 0 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_cancel_supplier_invoice 649 649 0 0.00 0 1108 85 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_cancel_supplier_order 19081 19081 0 0.00 0 4025 87 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_cancel_write_off 20 20 0 0.00 0 234 52 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_reserve_write_off 1176 1176 0 0.00 0 1201 49 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_supplier_invoice 126 126 0 0.00 0 1217 100 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-abend:sp_supplier_order 197 197 0 0.00 0 1201 63 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_add_invoice_to_stock 12156 12156 0 0.00 0 14243 488 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_cancel_adding_invoice 1384 1384 0 0.00 0 8440 584 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_cancel_client_order 6824 6824 0 0.00 0 2605 63 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_cancel_customer_reserve 2699 2699 0 0.00 0 2652 64 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_cancel_pay_from_customer 2668 2668 0 0.00 0 1919 46 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_cancel_pay_to_supplier 1595 1595 0 0.00 0 1763 46 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_cancel_supplier_invoice 971 971 0 0.00 0 1279 55 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_cancel_supplier_order 612 612 0 0.00 0 42167 1529 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_cancel_write_off 4042 4042 0 0.00 0 2387 65 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_client_order 85304 85304 0 0.00 0 3026 71 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_customer_reserve 3913 3913 0 0.00 0 1841 49 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_pay_from_customer 28547 28547 0 0.00 0 2215 63 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_pay_to_supplier 23374 23374 0 0.00 0 2184 54 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_reserve_write_off 38940 38940 0 0.00 0 2714 65 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_supplier_invoice 22024 22024 0 0.00 0 3339 59 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:sp_supplier_order 21881 21881 0 0.00 0 2730 64 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:srv_make_invnt_saldo 1844 1844 0 0.00 0 780 23 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:srv_make_money_saldo 3106 3106 0 0.00 0 982 27 0 2017-05-13 03:49 2017-05-13 06:49
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 936 136 0 2017-05-13 03:49 2017-05-13 06:49
v_add_invoice_to_stock 40806 24312 16494 40.42 0 3073 15 16494 2017-05-13 03:49 2017-05-13 06:49
v_all_customers 127888 127888 0 0.00 0 1778 5 0 2017-05-13 03:49 2017-05-13 06:49
v_all_suppliers 89708 89062 646 0.72 0 1778 5 0 2017-05-13 03:49 2017-05-13 06:49
v_all_wares 170608 170608 0 0.00 0 1919 4 0 2017-05-13 03:49 2017-05-13 06:49
v_cancel_adding_invoice 3302 2768 534 16.17 0 2449 134 534 2017-05-13 03:49 2017-05-13 06:49
v_cancel_client_order 13982 13648 334 2.38 0 1107 6 334 2017-05-13 03:49 2017-05-13 06:49
v_cancel_customer_prepayment 5368 5336 32 0.59 0 1404 7 32 2017-05-13 03:49 2017-05-13 06:49
v_cancel_customer_reserve 5608 5398 210 3.74 0 1701 9 210 2017-05-13 03:49 2017-05-13 06:49
v_cancel_payment_to_supplier 3198 3190 8 0.25 0 3900 9 8 2017-05-13 03:49 2017-05-13 06:49
v_cancel_supplier_invoice 3240 1942 1298 40.06 0 1061 15 1298 2017-05-13 03:49 2017-05-13 06:49
v_cancel_supplier_order 3324 1224 2100 63.17 0 1045 8 2100 2017-05-13 03:49 2017-05-13 06:49
v_cancel_write_off 8124 8084 40 0.49 0 2293 88 40 2017-05-13 03:49 2017-05-13 06:49
v_max_id_clo_ord 22078 21881 197 0.89 0 858 5 0 2017-05-13 03:49 2017-05-13 06:49
v_max_id_clo_res 3913 3913 0 0.00 0 1123 16 0 2017-05-13 03:49 2017-05-13 06:49
v_max_id_ord_sup 22150 22024 126 0.56 0 1186 5 0 2017-05-13 03:49 2017-05-13 06:49
v_max_non_paid_invoice 22748 22748 0 0.00 0 904 5 0 2017-05-13 03:49 2017-05-13 06:49
v_max_non_paid_realizn 28547 28547 0 0.00 0 1467 5 0 2017-05-13 03:49 2017-05-13 06:49
v_min_id_clo_ord 22078 21881 197 0.89 0 2106 7 0 2017-05-13 03:49 2017-05-13 06:49
v_min_id_clo_res 3913 3913 0 0.00 0 1747 9 0 2017-05-13 03:49 2017-05-13 06:49
v_min_id_ord_sup 22150 22024 126 0.56 0 2200 7 0 2017-05-13 03:49 2017-05-13 06:49
v_min_non_paid_invoice 23374 23374 0 0.00 0 1326 8 0 2017-05-13 03:49 2017-05-13 06:49
v_min_non_paid_realizn 28547 28547 0 0.00 0 1217 7 0 2017-05-13 03:49 2017-05-13 06:49
v_our_firm 42720 42720 0 0.00 0 1326 5 0 2017-05-13 03:49 2017-05-13 06:49
v_reserve_write_off 80232 77880 2352 2.93 0 2403 7 2352 2017-05-13 03:49 2017-05-13 06:49
x_lock_depdocs_on_canc_invoice 20831 10816 10015 48.07 0 1950 26 10015 2017-05-13 03:49 2017-05-13 06:49
x_lock_depdocs_on_canc_sup_ord 1660 612 1048 63.13 0 936 51 1048 2017-05-13 03:49 2017-05-13 06:49
x_make_qstorno_1000_1200 22078 21881 197 0.89 0 13712 1523 0 2017-05-13 03:49 2017-05-13 06:49
x_make_qstorno_1200_2000 22150 22024 126 0.56 0 32401 2312 0 2017-05-13 03:49 2017-05-13 06:49
x_make_qstorno_2100_3300 662542 662542 0 0.00 0 6474 108 0 2017-05-13 03:49 2017-05-13 06:49
Done for 460250 ms, from 7:15:59.78 to 7:23:40.03.

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 70 sp_kill_cost_storno 335544336 2017-05-13 03:50 2017-05-13 06:47
deadlock 82 sp_kill_qstorno_ret_qs2qd 335544336 2017-05-13 03:52 2017-05-13 06:48
deadlock 2895 sp_lock_selected_doc 335544336 2017-05-13 03:49 2017-05-13 06:49
deadlock 166 sp_qd_handle_on_cancel_clo 335544336 2017-05-13 03:50 2017-05-13 06:47
deadlock 193 sp_qd_handle_on_invoice_upd_sts 335544336 2017-05-13 03:50 2017-05-13 06:44
deadlock 63 x_lock_depdocs_on_canc_invoice 335544336 2017-05-13 03:51 2017-05-13 06:49
deadlock 15 x_lock_depdocs_on_canc_sup_ord 335544336 2017-05-13 03:52 2017-05-13 06:30
user_exc 197 x_make_qstorno_1000_1200 335544517 2017-05-13 03:49 2017-05-13 06:48
user_exc 126 x_make_qstorno_1200_2000 335544517 2017-05-13 03:49 2017-05-13 06:47
concurrent_transaction 7320 sp_lock_selected_doc 335544878 2017-05-13 03:49 2017-05-13 06:49
concurrent_transaction 649 x_lock_depdocs_on_canc_invoice 335544878 2017-05-13 03:49 2017-05-13 06:49
concurrent_transaction 240 x_lock_depdocs_on_canc_sup_ord 335544878 2017-05-13 03:50 2017-05-13 06:47
Done for 14960 ms, from 7:23:52.65 to 7:24:07.61.

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

Database statistics, full


Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB"
Database header page information:
Flags 0
Generation 451926
System Change Number 0
Page size 8192
ODS version 12.0
Oldest transaction 451773
Oldest active 451774
Oldest snapshot 451774
Next transaction 451775
Sequence number 0
Next attachment ID 9573
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.13, total records: 2212895
Average version length: 47.88, total versions: 2082, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 15, data page slots: 24024
Data pages: 24024, average fill: 72%
Primary pages: 24024, secondary pages: 0, swept pages: 14082
Empty pages: 2, full pages: 20595
Fill distribution:
0 - 19% = 4
20 - 39% = 8
40 - 59% = 169
60 - 79% = 23840
80 - 99% = 3

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26189, depth: 3, leaf buckets: 10787, nodes: 2212895
Average node length: 19.37, total dup: 0, max dup: 0
Average key length: 16.41, compression ratio: 1.65
Average prefix length: 13.59, average data length: 13.41
Clustering factor: 437969, ratio: 0.20
Fill distribution:
0 - 19% = 747
20 - 39% = 2468
40 - 59% = 4809
60 - 79% = 1291
80 - 99% = 1472

Index DOC_DATA_ID_DESC (2)
Root page: 45719, depth: 3, leaf buckets: 7933, nodes: 2212895
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.68, compression ratio: 1.04
Average prefix length: 3.32, average data length: 5.68
Clustering factor: 420239, ratio: 0.19
Fill distribution:
0 - 19% = 3
20 - 39% = 3717
40 - 59% = 4099
60 - 79% = 102
80 - 99% = 12

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 169166, depth: 3, leaf buckets: 3927, nodes: 2212895
Average node length: 6.85, total dup: 1601733, max dup: 49
Average key length: 3.89, compression ratio: 2.31
Average prefix length: 7.38, average data length: 1.62
Clustering factor: 398357, ratio: 0.18
Fill distribution:
0 - 19% = 199
20 - 39% = 1228
40 - 59% = 1626
60 - 79% = 322
80 - 99% = 552

DOC_LIST (140)
Primary pointer page: 247, Index root page: 248
Total formats: 1, used formats: 1
Average record length: 60.47, total records: 679062
Average version length: 36.19, total versions: 605, max versions: 3
Average fragment length: 22.82, total fragments: 11, max fragments: 1
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8608
Data pages: 8608, average fill: 75%
Primary pages: 8605, secondary pages: 3, swept pages: 7670
Empty pages: 6, full pages: 7928
Fill distribution:
0 - 19% = 13
20 - 39% = 6
40 - 59% = 46
60 - 79% = 8531
80 - 99% = 12

Index DOC_LIST_ID_DESC (1)
Root page: 246960, depth: 3, leaf buckets: 2497, nodes: 679062
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 158338, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 1342
40 - 59% = 1108
60 - 79% = 41
80 - 99% = 6

Index FK_DOC_LIST_AGENTS (2)
Root page: 2807, depth: 2, leaf buckets: 715, nodes: 679062
Average node length: 4.88, total dup: 679012, max dup: 45710
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 310713, ratio: 0.46
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 607
60 - 79% = 90
80 - 99% = 18

Index PK_DOC_LIST (0)
Root page: 329981, depth: 3, leaf buckets: 1944, nodes: 679062
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 158338, ratio: 0.23
Fill distribution:
0 - 19% = 148
20 - 39% = 470
40 - 59% = 710
60 - 79% = 308
80 - 99% = 308

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: 68.94, total records: 400
Average version length: 33.84, total versions: 799, max versions: 2
Average fragment length: 21.68, total fragments: 375, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.51
Pointer pages: 1, data page slots: 16
Data pages: 15, average fill: 73%
Primary pages: 4, secondary pages: 11, swept pages: 0
Empty pages: 3, full pages: 10
Fill distribution:
0 - 19% = 3
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 11

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: 2.46, total records: 21216
Average version length: 70.97, total versions: 20483, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 39.03
Pointer pages: 2, data page slots: 552
Data pages: 400, average fill: 69%
Primary pages: 400, secondary pages: 0, swept pages: 7
Empty pages: 46, full pages: 244
Fill distribution:
0 - 19% = 56
20 - 39% = 18
40 - 59% = 49
60 - 79% = 55
80 - 99% = 222

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1845, depth: 2, leaf buckets: 66, nodes: 21216
Average node length: 13.81, total dup: 1580, max dup: 1
Average key length: 11.50, compression ratio: 2.35
Average prefix length: 18.43, average data length: 8.57
Clustering factor: 15436, ratio: 0.73
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 35
60 - 79% = 26
80 - 99% = 1

MONEY_SALDO (143)
Primary pointer page: 262, Index root page: 263
Total formats: 1, used formats: 1
Average record length: 15.06, 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.12
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: 32.61, total records: 351
Average version length: 45.68, total versions: 106, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.96
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 21%
Primary pages: 15, secondary pages: 1, swept pages: 9
Empty pages: 1, full pages: 1
Fill distribution:
0 - 19% = 11
20 - 39% = 2
40 - 59% = 2
60 - 79% = 0
80 - 99% = 1

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 436137, depth: 2, leaf buckets: 1, nodes: 351
Average node length: 5.65, total dup: 293, max dup: 37
Average key length: 4.52, compression ratio: 4.20
Average prefix length: 16.64, average data length: 2.36
Clustering factor: 177, ratio: 0.50
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (165)
Primary pointer page: 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.18, total records: 258668
Average version length: 32.74, total versions: 3444, max versions: 6
Average fragment length: 33.00, total fragments: 1, max fragments: 1
Average unpacked length: 64.00, compression ratio: 1.52
Pointer pages: 2, data page slots: 3024
Data pages: 3024, average fill: 64%
Primary pages: 3006, secondary pages: 18, swept pages: 1931
Empty pages: 23, full pages: 1363
Fill distribution:
0 - 19% = 96
20 - 39% = 248
40 - 59% = 292
60 - 79% = 2379
80 - 99% = 9

Index PDISTR_AGENT_ID (4)
Root page: 5420, depth: 2, leaf buckets: 240, nodes: 258668
Average node length: 4.60, total dup: 258619, max dup: 12523
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 43840, ratio: 0.17
Fill distribution:
0 - 19% = 0
20 - 39% = 15
40 - 59% = 100
60 - 79% = 104
80 - 99% = 21

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 4740, depth: 2, leaf buckets: 290, nodes: 258668
Average node length: 5.54, total dup: 233318, max dup: 197
Average key length: 2.95, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 57998, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 23
40 - 59% = 127
60 - 79% = 96
80 - 99% = 44

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 4730, depth: 2, leaf buckets: 287, nodes: 258668
Average node length: 5.54, total dup: 233318, max dup: 197
Average key length: 2.95, compression ratio: 7.47
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 58119, ratio: 0.22
Fill distribution:
0 - 19% = 1
20 - 39% = 23
40 - 59% = 113
60 - 79% = 105
80 - 99% = 45

Index PDISTR_SND_ID (1)
Root page: 4894, depth: 2, leaf buckets: 278, nodes: 258668
Average node length: 5.33, total dup: 233318, max dup: 197
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 58068, ratio: 0.22
Fill distribution:
0 - 19% = 3
20 - 39% = 15
40 - 59% = 122
60 - 79% = 101
80 - 99% = 37

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 80763, depth: 2, leaf buckets: 230, nodes: 283521
Average node length: 4.55, total dup: 283340, max dup: 2431
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.57, average data length: 0.00
Clustering factor: 33585, ratio: 0.12
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 95
60 - 79% = 70
80 - 99% = 65

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.69, total records: 12419973
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.18
Pointer pages: 181, data page slots: 294688
Data pages: 294688, average fill: 87%
Primary pages: 294688, secondary pages: 0, swept pages: 3
Empty pages: 4, full pages: 294683
Fill distribution:
0 - 19% = 4
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 294683

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 64458, depth: 3, leaf buckets: 14072, nodes: 12419973
Average node length: 5.68, total dup: 11572192, max dup: 153
Average key length: 2.16, compression ratio: 3.69
Average prefix length: 7.87, average data length: 0.12
Clustering factor: 3865026, ratio: 0.31
Fill distribution:
0 - 19% = 8
20 - 39% = 0
40 - 59% = 7881
60 - 79% = 4063
80 - 99% = 2120

Index PERF_LOG_GDSCODE (3)
Root page: 163628, depth: 3, leaf buckets: 12411, nodes: 12419973
Average node length: 4.62, total dup: 12419968, max dup: 11187347
Average key length: 1.10, compression ratio: 0.45
Average prefix length: 0.50, average data length: 0.00
Clustering factor: 369829, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 12382
60 - 79% = 3
80 - 99% = 25

Index PERF_LOG_TRN_DESC (2)
Root page: 43655, depth: 3, leaf buckets: 15195, nodes: 12419973
Average node length: 5.74, total dup: 12041072, max dup: 24570
Average key length: 2.23, compression ratio: 4.04
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 958541, ratio: 0.08
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 11396
60 - 79% = 2062
80 - 99% = 1735

Index PERF_LOG_UNIT (1)
Root page: 77766, depth: 3, leaf buckets: 15088, nodes: 12419973
Average node length: 5.59, total dup: 12393662, max dup: 1738890
Average key length: 2.07, compression ratio: 18.30
Average prefix length: 37.78, average data length: 0.07
Clustering factor: 6533978, ratio: 0.53
Fill distribution:
0 - 19% = 16
20 - 39% = 1
40 - 59% = 12917
60 - 79% = 600
80 - 99% = 1554

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.10, total records: 438726
Average version length: 55.86, total versions: 853, 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: 5232
Data pages: 5232, average fill: 74%
Primary pages: 5232, secondary pages: 0, swept pages: 3589
Empty pages: 6, full pages: 4820
Fill distribution:
0 - 19% = 7
20 - 39% = 4
40 - 59% = 35
60 - 79% = 5185
80 - 99% = 1

Index PSTORNED_RCV_ID (2)
Root page: 675676, depth: 3, leaf buckets: 588, nodes: 438726
Average node length: 5.92, total dup: 369815, max dup: 443
Average key length: 3.14, compression ratio: 2.87
Average prefix length: 8.02, average data length: 0.98
Clustering factor: 56424, ratio: 0.13
Fill distribution:
0 - 19% = 15
20 - 39% = 53
40 - 59% = 339
60 - 79% = 130
80 - 99% = 51

Index PSTORNED_SND_ID (1)
Root page: 2157, depth: 2, leaf buckets: 471, nodes: 438726
Average node length: 5.60, total dup: 390767, max dup: 105
Average key length: 2.82, compression ratio: 3.20
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 106001, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 210
60 - 79% = 170
80 - 99% = 83

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: 9.00, total versions: 2, max versions: 2
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: 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 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.59, total records: 2701
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.53
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 62%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 7, full pages: 32
Fill distribution:
0 - 19% = 7
20 - 39% = 0
40 - 59% = 1
60 - 79% = 32
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: 27.02, total records: 9474
Average version length: 72.12, total versions: 5922, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 5.03
Pointer pages: 2, data page slots: 872
Data pages: 392, average fill: 32%
Primary pages: 391, secondary pages: 1, swept pages: 122
Empty pages: 117, full pages: 79
Fill distribution:
0 - 19% = 196
20 - 39% = 60
40 - 59% = 42
60 - 79% = 38
80 - 99% = 56

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1346, depth: 2, leaf buckets: 21, nodes: 9474
Average node length: 6.69, total dup: 8179, max dup: 14
Average key length: 4.40, compression ratio: 8.42
Average prefix length: 34.74, average data length: 2.26
Clustering factor: 1479, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 6
60 - 79% = 1
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 729, Index root page: 730
Total formats: 1, used formats: 1
Average record length: 71.49, total records: 1060210
Average version length: 71.51, total versions: 9754, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.90
Pointer pages: 10, data page slots: 16192
Data pages: 16192, average fill: 72%
Primary pages: 16192, secondary pages: 0, swept pages: 9444
Empty pages: 53, full pages: 12360
Fill distribution:
0 - 19% = 185
20 - 39% = 474
40 - 59% = 1026
60 - 79% = 14353
80 - 99% = 154

Index XQD_1000_3300_DOC (1)
Root page: 472893, depth: 3, leaf buckets: 1227, nodes: 1060210
Average node length: 5.13, total dup: 1030774, max dup: 122
Average key length: 2.20, compression ratio: 4.08
Average prefix length: 8.82, average data length: 0.18
Clustering factor: 123603, ratio: 0.12
Fill distribution:
0 - 19% = 15
20 - 39% = 111
40 - 59% = 884
60 - 79% = 46
80 - 99% = 171

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 257811, depth: 3, leaf buckets: 1492, nodes: 1060210
Average node length: 6.26, total dup: 924779, max dup: 16
Average key length: 3.33, compression ratio: 11.12
Average prefix length: 35.80, average data length: 1.20
Clustering factor: 205701, ratio: 0.19
Fill distribution:
0 - 19% = 17
20 - 39% = 138
40 - 59% = 1039
60 - 79% = 145
80 - 99% = 153

XQD_1200_2000 (261)
Primary pointer page: 718, Index root page: 719
Total formats: 1, used formats: 1
Average record length: 48.38, total records: 60293
Average version length: 71.73, total versions: 19663, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.81
Pointer pages: 4, data page slots: 5776
Data pages: 1648, average fill: 44%
Primary pages: 1648, secondary pages: 0, swept pages: 679
Empty pages: 298, full pages: 498
Fill distribution:
0 - 19% = 543
20 - 39% = 225
40 - 59% = 223
60 - 79% = 380
80 - 99% = 277

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1095, depth: 2, leaf buckets: 106, nodes: 60293
Average node length: 6.17, total dup: 52737, max dup: 49
Average key length: 3.51, compression ratio: 10.53
Average prefix length: 35.61, average data length: 1.39
Clustering factor: 6648, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 50
40 - 59% = 40
60 - 79% = 13
80 - 99% = 2

XQD_2000_3300 (263)
Primary pointer page: 735, Index root page: 736
Total formats: 1, used formats: 1
Average record length: 69.54, total records: 1683897
Average version length: 71.83, total versions: 61708, 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: 18, data page slots: 28336
Data pages: 28224, average fill: 66%
Primary pages: 28223, secondary pages: 1, swept pages: 16305
Empty pages: 595, full pages: 16499
Fill distribution:
0 - 19% = 1187
20 - 39% = 1846
40 - 59% = 4036
60 - 79% = 20201
80 - 99% = 954

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 196768, depth: 3, leaf buckets: 2702, nodes: 1683897
Average node length: 5.62, total dup: 1582297, max dup: 49
Average key length: 2.66, compression ratio: 13.90
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 217325, ratio: 0.13
Fill distribution:
0 - 19% = 9
20 - 39% = 1298
40 - 59% = 1059
60 - 79% = 216
80 - 99% = 120

XQD_2100_3300 (264)
Primary pointer page: 738, Index root page: 739
Total formats: 1, used formats: 1
Average record length: 12.52, total records: 43855
Average version length: 71.58, total versions: 36001, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 10.87
Pointer pages: 4, data page slots: 3088
Data pages: 824, average fill: 67%
Primary pages: 821, secondary pages: 3, swept pages: 118
Empty pages: 133, full pages: 585
Fill distribution:
0 - 19% = 175
20 - 39% = 30
40 - 59% = 21
60 - 79% = 60
80 - 99% = 538

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1215, depth: 2, leaf buckets: 62, nodes: 43855
Average node length: 6.08, total dup: 38336, max dup: 67
Average key length: 3.61, compression ratio: 10.24
Average prefix length: 35.51, average data length: 1.49
Clustering factor: 6098, ratio: 0.14
Fill distribution:
0 - 19% = 0
20 - 39% = 10
40 - 59% = 32
60 - 79% = 15
80 - 99% = 5

XQD_3300_3400 (265)
Primary pointer page: 741, Index root page: 742
Total formats: 1, used formats: 1
Average record length: 70.99, total records: 2850781
Average version length: 71.23, total versions: 21249, 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: 26, data page slots: 41280
Data pages: 41280, average fill: 75%
Primary pages: 41280, secondary pages: 0, swept pages: 30947
Empty pages: 57, full pages: 34851
Fill distribution:
0 - 19% = 110
20 - 39% = 201
40 - 59% = 1185
60 - 79% = 39267
80 - 99% = 517

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 40476, depth: 3, leaf buckets: 5921, nodes: 2850781
Average node length: 6.88, total dup: 2306892, max dup: 21
Average key length: 3.90, compression ratio: 9.48
Average prefix length: 35.29, average data length: 1.71
Clustering factor: 518314, ratio: 0.18
Fill distribution:
0 - 19% = 8
20 - 39% = 3046
40 - 59% = 2425
60 - 79% = 288
80 - 99% = 154

XQS_1000_1200 (266)
Primary pointer page: 745, Index root page: 746
Total formats: 1, used formats: 1
Average record length: 83.74, total records: 4856479
Average version length: 84.46, total versions: 1880, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.62
Pointer pages: 46, data page slots: 74648
Data pages: 74648, average fill: 80%
Primary pages: 74648, secondary pages: 0, swept pages: 27718
Empty pages: 2, full pages: 74333
Fill distribution:
0 - 19% = 6
20 - 39% = 8
40 - 59% = 25
60 - 79% = 21378
80 - 99% = 53231

Index XQS_1000_1200_DOC_ID (0)
Root page: 54645, depth: 3, leaf buckets: 4947, nodes: 4856479
Average node length: 5.16, total dup: 4745392, max dup: 124
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 771202, ratio: 0.16
Fill distribution:
0 - 19% = 19
20 - 39% = 85
40 - 59% = 2140
60 - 79% = 2124
80 - 99% = 579

Index XQS_1000_1200_RCV_ID (2)
Root page: 82607, depth: 3, leaf buckets: 5229, nodes: 4856479
Average node length: 5.70, total dup: 4347492, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 238494, ratio: 0.05
Fill distribution:
0 - 19% = 47
20 - 39% = 155
40 - 59% = 2828
60 - 79% = 303
80 - 99% = 1896

Index XQS_1000_1200_SND_ID (1)
Root page: 47515, depth: 3, leaf buckets: 5491, nodes: 4856479
Average node length: 5.81, total dup: 4248215, max dup: 25
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 827016, ratio: 0.17
Fill distribution:
0 - 19% = 26
20 - 39% = 87
40 - 59% = 2308
60 - 79% = 2228
80 - 99% = 842

XQS_1000_3300 (268)
Primary pointer page: 755, Index root page: 756
Total formats: 1, used formats: 1
Average record length: 82.36, total records: 2629914
Average version length: 84.13, total versions: 33984, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 26, data page slots: 41248
Data pages: 41248, average fill: 79%
Primary pages: 41248, secondary pages: 0, swept pages: 28200
Empty pages: 45, full pages: 39008
Fill distribution:
0 - 19% = 72
20 - 39% = 82
40 - 59% = 495
60 - 79% = 16733
80 - 99% = 23866

Index XQS_1000_3300_DOC_ID (0)
Root page: 73800, depth: 3, leaf buckets: 2821, nodes: 2629914
Average node length: 5.15, total dup: 2568446, max dup: 190
Average key length: 2.18, compression ratio: 4.14
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 414325, ratio: 0.16
Fill distribution:
0 - 19% = 5
20 - 39% = 50
40 - 59% = 1669
60 - 79% = 824
80 - 99% = 273

Index XQS_1000_3300_RCV_ID (2)
Root page: 109107, depth: 3, leaf buckets: 4398, nodes: 2629914
Average node length: 6.24, total dup: 2153260, max dup: 14
Average key length: 3.26, compression ratio: 2.76
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 245787, ratio: 0.09
Fill distribution:
0 - 19% = 118
20 - 39% = 1609
40 - 59% = 1820
60 - 79% = 544
80 - 99% = 307

Index XQS_1000_3300_SND_ID (1)
Root page: 63881, depth: 3, leaf buckets: 3180, nodes: 2629914
Average node length: 5.81, total dup: 2300769, max dup: 29
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 497768, ratio: 0.19
Fill distribution:
0 - 19% = 12
20 - 39% = 64
40 - 59% = 1886
60 - 79% = 869
80 - 99% = 349

XQS_1200_2000 (267)
Primary pointer page: 750, Index root page: 751
Total formats: 1, used formats: 1
Average record length: 83.36, total records: 5142286
Average version length: 85.85, total versions: 33162, 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: 51, data page slots: 81992
Data pages: 81896, average fill: 78%
Primary pages: 81896, secondary pages: 0, swept pages: 26193
Empty pages: 683, full pages: 74278
Fill distribution:
0 - 19% = 1020
20 - 39% = 1053
40 - 59% = 2272
60 - 79% = 17412
80 - 99% = 60139

Index XQS_1200_2000_DOC_ID (0)
Root page: 57493, depth: 3, leaf buckets: 5446, nodes: 5142286
Average node length: 5.04, total dup: 5112069, max dup: 647
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 764348, ratio: 0.15
Fill distribution:
0 - 19% = 5
20 - 39% = 273
40 - 59% = 3064
60 - 79% = 1527
80 - 99% = 577

Index XQS_1200_2000_RCV_ID (2)
Root page: 83243, depth: 3, leaf buckets: 6255, nodes: 5142286
Average node length: 5.52, total dup: 4739701, max dup: 49
Average key length: 2.54, compression ratio: 3.55
Average prefix length: 8.54, average data length: 0.46
Clustering factor: 265280, ratio: 0.05
Fill distribution:
0 - 19% = 117
20 - 39% = 1575
40 - 59% = 2533
60 - 79% = 689
80 - 99% = 1341

Index XQS_1200_2000_SND_ID (1)
Root page: 49462, depth: 3, leaf buckets: 6101, nodes: 5142286
Average node length: 5.68, total dup: 4614283, max dup: 86
Average key length: 2.70, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 843807, ratio: 0.16
Fill distribution:
0 - 19% = 7
20 - 39% = 196
40 - 59% = 3526
60 - 79% = 1697
80 - 99% = 675

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

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

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

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

XQS_2100_3300 (270)
Primary pointer page: 767, Index root page: 776
Total formats: 1, used formats: 1
Average record length: 82.61, total records: 3523071
Average version length: 84.24, total versions: 43990, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.65
Pointer pages: 35, data page slots: 55504
Data pages: 55504, average fill: 79%
Primary pages: 55504, secondary pages: 0, swept pages: 37923
Empty pages: 64, full pages: 51103
Fill distribution:
0 - 19% = 102
20 - 39% = 133
40 - 59% = 846
60 - 79% = 21110
80 - 99% = 33313

Index XQS_2100_3300_DOC_ID (0)
Root page: 89055, depth: 3, leaf buckets: 3862, nodes: 3523071
Average node length: 5.03, total dup: 3505942, max dup: 1327
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 705046, ratio: 0.20
Fill distribution:
0 - 19% = 15
20 - 39% = 418
40 - 59% = 2128
60 - 79% = 886
80 - 99% = 415

Index XQS_2100_3300_RCV_ID (2)
Root page: 109104, depth: 3, leaf buckets: 5941, nodes: 3523071
Average node length: 6.25, total dup: 2880247, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 360547, ratio: 0.10
Fill distribution:
0 - 19% = 198
20 - 39% = 2222
40 - 59% = 2378
60 - 79% = 685
80 - 99% = 458

Index XQS_2100_3300_SND_ID (1)
Root page: 77230, depth: 3, leaf buckets: 4251, nodes: 3523071
Average node length: 5.58, total dup: 3217228, max dup: 74
Average key length: 2.60, compression ratio: 3.46
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 751483, ratio: 0.21
Fill distribution:
0 - 19% = 20
20 - 39% = 450
40 - 59% = 2239
60 - 79% = 1097
80 - 99% = 445

XQS_3300_3400 (271)
Primary pointer page: 780, Index root page: 781
Total formats: 1, used formats: 1
Average record length: 69.17, total records: 652825
Average version length: 70.15, total versions: 3276, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 8968
Data pages: 8968, average fill: 77%
Primary pages: 8968, secondary pages: 0, swept pages: 6334
Empty pages: 1, full pages: 8763
Fill distribution:
0 - 19% = 5
20 - 39% = 10
40 - 59% = 29
60 - 79% = 8833
80 - 99% = 91

Index XQS_3300_3400_DOC_ID (0)
Root page: 176029, depth: 3, leaf buckets: 787, nodes: 652825
Average node length: 5.32, total dup: 614704, max dup: 116
Average key length: 2.44, compression ratio: 3.68
Average prefix length: 8.61, average data length: 0.39
Clustering factor: 56001, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 182
40 - 59% = 317
60 - 79% = 195
80 - 99% = 92

Index XQS_3300_3400_SND_ID (1)
Root page: 150306, depth: 3, leaf buckets: 885, nodes: 652825
Average node length: 5.93, total dup: 557436, max dup: 21
Average key length: 3.05, compression ratio: 2.95
Average prefix length: 8.09, average data length: 0.91
Clustering factor: 59146, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 209
40 - 59% = 368
60 - 79% = 209
80 - 99% = 98

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Done for 93150 ms, from 7:24:07.97 to 7:25:41.12.

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 2212895 2082 0.0940
DOC_LIST 679062 605 0.0890
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 799 199.7500
INVNT_TURNOVER_LOG 21216 20483 96.5450
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 351 106 30.1994
OPTYPES 9 0 0.0000
PDISTR 258668 3444 1.3314
PERF_ESTIMATED 283521 0 0.0000
PERF_LOG 12419973 0 0.0000
PSTORNED 438726 853 0.1944
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 2 50.0000
SETTINGS 114 0 0.0000
TRACE_STAT 2701 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 9474 5922 62.5079
XQD_1000_3300 1060210 9754 0.9200
XQD_1200_2000 60293 19663 32.6124
XQD_2000_3300 1683897 61708 3.6645
XQD_2100_3300 43855 36001 82.0909
XQD_3300_3400 2850781 21249 0.7453
XQS_1000_1200 4856479 1880 0.0387
XQS_1000_3300 2629914 33984 1.2922
XQS_1200_2000 5142286 33162 0.6448
XQS_2100_3300 3523071 43990 1.2486
XQS_3300_3400 652825 3276 0.5018
Z_USED_VIEWS 29 0 0.0000
Done for 2730 ms, from 7:25:52.97 to 7:25:55.70.

Database validation

07:25:55.84 Validation started

07:25:55.87 Relation 140 (DOC_LIST)
07:25:55.87 process pointer page 0 of 6
07:25:55.98 process pointer page 1 of 6
07:25:56.08 process pointer page 2 of 6
07:25:56.17 process pointer page 3 of 6
07:25:56.28 process pointer page 4 of 6
07:25:56.36 process pointer page 5 of 6
07:25:56.37 Index 1 (PK_DOC_LIST)
07:25:56.64 Index 2 (DOC_LIST_ID_DESC)
07:25:56.89 Index 3 (FK_DOC_LIST_AGENTS)
07:25:57.00 Relation 140 (DOC_LIST) is ok

07:25:57.00 Relation 141 (DOC_DATA)
07:25:57.00 process pointer page 0 of 15
07:25:57.03 process pointer page 1 of 15
07:25:57.06 process pointer page 2 of 15
07:25:57.09 process pointer page 3 of 15
07:25:57.12 process pointer page 4 of 15
07:25:57.15 process pointer page 5 of 15
07:25:57.18 process pointer page 6 of 15
07:25:57.20 process pointer page 7 of 15
07:25:57.23 process pointer page 8 of 15
07:25:57.26 process pointer page 9 of 15
07:25:57.29 process pointer page 10 of 15
07:25:57.32 process pointer page 11 of 15
07:25:57.34 process pointer page 12 of 15
07:25:57.37 process pointer page 13 of 15
07:25:57.40 process pointer page 14 of 15
07:25:57.42 Index 2 (DOC_DATA_DOC_WARE_UNQ)
07:25:58.38 Index 3 (DOC_DATA_ID_DESC)
07:25:59.32 Index 4 (FK_DOC_DATA_DOC_LIST)
07:26:00.07 Relation 141 (DOC_DATA) is ok

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

07:26:00.07 Relation 150 (PDISTR)
07:26:00.07 process pointer page 0 of 2
07:26:00.16 process pointer page 1 of 2
07:26:00.24 Index 2 (PDISTR_SND_ID)
07:26:00.32 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
07:26:00.41 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
07:26:00.51 Index 5 (PDISTR_AGENT_ID)
07:26:00.58 Relation 150 (PDISTR) is ok

07:26:00.58 Relation 151 (PSTORNED)
07:26:00.58 process pointer page 0 of 4
07:26:00.68 process pointer page 1 of 4
07:26:00.77 process pointer page 2 of 4
07:26:00.85 process pointer page 3 of 4
07:26:00.88 Index 2 (PSTORNED_SND_ID)
07:26:01.02 Index 3 (PSTORNED_RCV_ID)
07:26:01.16 Relation 151 (PSTORNED) is ok

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

07:26:01.16 Relation 157 (INVNT_TURNOVER_LOG)
07:26:01.16 process pointer page 0 of 2
07:26:01.19 process pointer page 1 of 2
07:26:01.21 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
07:26:01.22 Relation 157 (INVNT_TURNOVER_LOG) is ok

07:26:01.22 Relation 160 (PERF_ESTIMATED)
07:26:01.22 process pointer page 0 of 2
07:26:01.32 process pointer page 1 of 2
07:26:01.36 Index 1 (PERF_EST_MINUTE_SINCE_START)
07:26:01.44 Relation 160 (PERF_ESTIMATED) is ok

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

07:26:01.44 Relation 162 (TRACE_STAT)
07:26:01.44 process pointer page 0 of 1
07:26:01.44 Relation 162 (TRACE_STAT) is ok

07:26:01.44 Relation 163 (PERF_LOG)
07:26:01.44 process pointer page 0 of 181
07:26:01.52 process pointer page 1 of 181
07:26:01.60 process pointer page 2 of 181
07:26:01.69 process pointer page 3 of 181
07:26:01.77 process pointer page 4 of 181
07:26:01.85 process pointer page 5 of 181
07:26:01.94 process pointer page 6 of 181
07:26:02.02 process pointer page 7 of 181
07:26:02.10 process pointer page 8 of 181
07:26:02.18 process pointer page 9 of 181
07:26:02.27 process pointer page 10 of 181
07:26:02.35 process pointer page 11 of 181
07:26:02.43 process pointer page 12 of 181
07:26:02.50 process pointer page 13 of 181
07:26:02.60 process pointer page 14 of 181
07:26:02.67 process pointer page 15 of 181
07:26:02.75 process pointer page 16 of 181
07:26:02.85 process pointer page 17 of 181
07:26:02.92 process pointer page 18 of 181
07:26:03.00 process pointer page 19 of 181
07:26:03.08 process pointer page 20 of 181
07:26:03.17 process pointer page 21 of 181
07:26:03.25 process pointer page 22 of 181
07:26:03.33 process pointer page 23 of 181
07:26:03.41 process pointer page 24 of 181
07:26:03.49 process pointer page 25 of 181
07:26:03.56 process pointer page 26 of 181
07:26:03.64 process pointer page 27 of 181
07:26:03.72 process pointer page 28 of 181
07:26:03.81 process pointer page 29 of 181
07:26:03.89 process pointer page 30 of 181
07:26:03.97 process pointer page 31 of 181
07:26:04.05 process pointer page 32 of 181
07:26:04.13 process pointer page 33 of 181
07:26:04.20 process pointer page 34 of 181
07:26:04.30 process pointer page 35 of 181
07:26:04.38 process pointer page 36 of 181
07:26:04.45 process pointer page 37 of 181
07:26:04.53 process pointer page 38 of 181
07:26:04.61 process pointer page 39 of 181
07:26:04.69 process pointer page 40 of 181
07:26:04.77 process pointer page 41 of 181
07:26:04.84 process pointer page 42 of 181
07:26:04.92 process pointer page 43 of 181
07:26:05.00 process pointer page 44 of 181
07:26:05.09 process pointer page 45 of 181
07:26:05.17 process pointer page 46 of 181
07:26:05.25 process pointer page 47 of 181
07:26:05.33 process pointer page 48 of 181
07:26:05.40 process pointer page 49 of 181
07:26:05.48 process pointer page 50 of 181
07:26:05.56 process pointer page 51 of 181
07:26:05.64 process pointer page 52 of 181
07:26:05.73 process pointer page 53 of 181
07:26:05.81 process pointer page 54 of 181
07:26:05.89 process pointer page 55 of 181
07:26:05.97 process pointer page 56 of 181
07:26:06.04 process pointer page 57 of 181
07:26:06.12 process pointer page 58 of 181
07:26:06.20 process pointer page 59 of 181
07:26:06.28 process pointer page 60 of 181
07:26:06.36 process pointer page 61 of 181
07:26:06.43 process pointer page 62 of 181
07:26:06.51 process pointer page 63 of 181
07:26:06.61 process pointer page 64 of 181
07:26:06.68 process pointer page 65 of 181
07:26:06.76 process pointer page 66 of 181
07:26:06.84 process pointer page 67 of 181
07:26:06.92 process pointer page 68 of 181
07:26:07.01 process pointer page 69 of 181
07:26:07.09 process pointer page 70 of 181
07:26:07.17 process pointer page 71 of 181
07:26:07.25 process pointer page 72 of 181
07:26:07.32 process pointer page 73 of 181
07:26:07.40 process pointer page 74 of 181
07:26:07.48 process pointer page 75 of 181
07:26:07.57 process pointer page 76 of 181
07:26:07.65 process pointer page 77 of 181
07:26:07.73 process pointer page 78 of 181
07:26:07.82 process pointer page 79 of 181
07:26:07.90 process pointer page 80 of 181
07:26:07.98 process pointer page 81 of 181
07:26:08.07 process pointer page 82 of 181
07:26:08.15 process pointer page 83 of 181
07:26:08.21 process pointer page 84 of 181
07:26:08.24 process pointer page 85 of 181
07:26:08.32 process pointer page 86 of 181
07:26:08.42 process pointer page 87 of 181
07:26:08.49 process pointer page 88 of 181
07:26:08.57 process pointer page 89 of 181
07:26:08.65 process pointer page 90 of 181
07:26:08.73 process pointer page 91 of 181
07:26:08.82 process pointer page 92 of 181
07:26:08.90 process pointer page 93 of 181
07:26:08.98 process pointer page 94 of 181
07:26:09.07 process pointer page 95 of 181
07:26:09.15 process pointer page 96 of 181
07:26:09.23 process pointer page 97 of 181
07:26:09.30 process pointer page 98 of 181
07:26:09.34 process pointer page 99 of 181
07:26:09.40 process pointer page 100 of 181
07:26:09.43 process pointer page 101 of 181
07:26:09.51 process pointer page 102 of 181
07:26:09.54 process pointer page 103 of 181
07:26:09.62 process pointer page 104 of 181
07:26:09.69 process pointer page 105 of 181
07:26:09.77 process pointer page 106 of 181
07:26:09.85 process pointer page 107 of 181
07:26:09.93 process pointer page 108 of 181
07:26:10.01 process pointer page 109 of 181
07:26:10.10 process pointer page 110 of 181
07:26:10.18 process pointer page 111 of 181
07:26:10.26 process pointer page 112 of 181
07:26:10.33 process pointer page 113 of 181
07:26:10.41 process pointer page 114 of 181
07:26:10.49 process pointer page 115 of 181
07:26:10.57 process pointer page 116 of 181
07:26:10.66 process pointer page 117 of 181
07:26:10.74 process pointer page 118 of 181
07:26:10.82 process pointer page 119 of 181
07:26:10.90 process pointer page 120 of 181
07:26:10.97 process pointer page 121 of 181
07:26:11.07 process pointer page 122 of 181
07:26:11.15 process pointer page 123 of 181
07:26:11.22 process pointer page 124 of 181
07:26:11.30 process pointer page 125 of 181
07:26:11.38 process pointer page 126 of 181
07:26:11.46 process pointer page 127 of 181
07:26:11.55 process pointer page 128 of 181
07:26:11.63 process pointer page 129 of 181
07:26:11.71 process pointer page 130 of 181
07:26:11.79 process pointer page 131 of 181
07:26:11.86 process pointer page 132 of 181
07:26:11.94 process pointer page 133 of 181
07:26:12.03 process pointer page 134 of 181
07:26:12.11 process pointer page 135 of 181
07:26:12.19 process pointer page 136 of 181
07:26:12.27 process pointer page 137 of 181
07:26:12.35 process pointer page 138 of 181
07:26:12.42 process pointer page 139 of 181
07:26:12.52 process pointer page 140 of 181
07:26:12.60 process pointer page 141 of 181
07:26:12.67 process pointer page 142 of 181
07:26:12.75 process pointer page 143 of 181
07:26:12.83 process pointer page 144 of 181
07:26:12.91 process pointer page 145 of 181
07:26:12.99 process pointer page 146 of 181
07:26:13.08 process pointer page 147 of 181
07:26:13.16 process pointer page 148 of 181
07:26:13.20 process pointer page 149 of 181
07:26:13.25 process pointer page 150 of 181
07:26:13.33 process pointer page 151 of 181
07:26:13.41 process pointer page 152 of 181
07:26:13.49 process pointer page 153 of 181
07:26:13.56 process pointer page 154 of 181
07:26:13.66 process pointer page 155 of 181
07:26:13.74 process pointer page 156 of 181
07:26:13.81 process pointer page 157 of 181
07:26:13.89 process pointer page 158 of 181
07:26:13.97 process pointer page 159 of 181
07:26:14.06 process pointer page 160 of 181
07:26:14.14 process pointer page 161 of 181
07:26:14.22 process pointer page 162 of 181
07:26:14.30 process pointer page 163 of 181
07:26:14.37 process pointer page 164 of 181
07:26:14.45 process pointer page 165 of 181
07:26:14.55 process pointer page 166 of 181
07:26:14.62 process pointer page 167 of 181
07:26:14.70 process pointer page 168 of 181
07:26:14.78 process pointer page 169 of 181
07:26:14.86 process pointer page 170 of 181
07:26:14.95 process pointer page 171 of 181
07:26:15.03 process pointer page 172 of 181
07:26:15.11 process pointer page 173 of 181
07:26:15.19 process pointer page 174 of 181
07:26:15.28 process pointer page 175 of 181
07:26:15.36 process pointer page 176 of 181
07:26:15.44 process pointer page 177 of 181
07:26:15.51 process pointer page 178 of 181
07:26:15.61 process pointer page 179 of 181
07:26:15.69 process pointer page 180 of 181
07:26:15.73 Index 1 (PERF_LOG_DTS_BEG_DESC)
07:26:20.22 Index 2 (PERF_LOG_UNIT)
07:26:26.37 Index 3 (PERF_LOG_TRN_DESC)
07:26:29.91 Index 4 (PERF_LOG_GDSCODE)
07:26:32.46 Relation 163 (PERF_LOG) is ok

07:26:32.47 Relation 167 (V_STOPTEST)
07:26:32.47 Relation 167 (V_STOPTEST) is ok

07:26:32.47 Relation 184 (V_QDISTR_SOURCE)
07:26:32.47 Relation 184 (V_QDISTR_SOURCE) is ok

07:26:32.47 Relation 185 (V_QSTORNED_SOURCE)
07:26:32.47 Relation 185 (V_QSTORNED_SOURCE) is ok

07:26:32.47 Relation 260 (XQD_1000_1200)
07:26:32.47 process pointer page 0 of 2
07:26:32.47 process pointer page 1 of 2
07:26:32.47 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
07:26:32.49 Relation 260 (XQD_1000_1200) is ok

07:26:32.49 Relation 261 (XQD_1200_2000)
07:26:32.49 process pointer page 0 of 4
07:26:32.49 process pointer page 1 of 4
07:26:32.49 process pointer page 2 of 4
07:26:32.50 process pointer page 3 of 4
07:26:32.52 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
07:26:32.52 Relation 261 (XQD_1200_2000) is ok

07:26:32.52 Relation 262 (XQD_1000_3300)
07:26:32.52 process pointer page 0 of 10
07:26:32.58 process pointer page 1 of 10
07:26:32.66 process pointer page 2 of 10
07:26:32.69 process pointer page 3 of 10
07:26:32.75 process pointer page 4 of 10
07:26:32.80 process pointer page 5 of 10
07:26:32.83 process pointer page 6 of 10
07:26:32.91 process pointer page 7 of 10
07:26:32.99 process pointer page 8 of 10
07:26:33.06 process pointer page 9 of 10
07:26:33.14 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
07:26:33.47 Index 2 (XQD_1000_3300_DOC)
07:26:33.80 Relation 262 (XQD_1000_3300) is ok

07:26:33.80 Relation 263 (XQD_2000_3300)
07:26:33.80 process pointer page 0 of 18
07:26:33.89 process pointer page 1 of 18
07:26:33.98 process pointer page 2 of 18
07:26:34.09 process pointer page 3 of 18
07:26:34.20 process pointer page 4 of 18
07:26:34.28 process pointer page 5 of 18
07:26:34.39 process pointer page 6 of 18
07:26:34.47 process pointer page 7 of 18
07:26:34.56 process pointer page 8 of 18
07:26:34.66 process pointer page 9 of 18
07:26:34.73 process pointer page 10 of 18
07:26:34.83 process pointer page 11 of 18
07:26:34.90 process pointer page 12 of 18
07:26:34.98 process pointer page 13 of 18
07:26:35.08 process pointer page 14 of 18
07:26:35.15 process pointer page 15 of 18
07:26:35.22 process pointer page 16 of 18
07:26:35.26 process pointer page 17 of 18
07:26:35.26 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
07:26:35.54 Relation 263 (XQD_2000_3300) is ok

07:26:35.54 Relation 264 (XQD_2100_3300)
07:26:35.54 process pointer page 0 of 4
07:26:35.59 process pointer page 1 of 4
07:26:35.64 process pointer page 2 of 4
07:26:35.64 process pointer page 3 of 4
07:26:35.64 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
07:26:35.65 Relation 264 (XQD_2100_3300) is ok

07:26:35.65 Relation 265 (XQD_3300_3400)
07:26:35.65 process pointer page 0 of 26
07:26:35.75 process pointer page 1 of 26
07:26:35.84 process pointer page 2 of 26
07:26:35.93 process pointer page 3 of 26
07:26:36.01 process pointer page 4 of 26
07:26:36.11 process pointer page 5 of 26
07:26:36.20 process pointer page 6 of 26
07:26:36.29 process pointer page 7 of 26
07:26:36.39 process pointer page 8 of 26
07:26:36.46 process pointer page 9 of 26
07:26:36.56 process pointer page 10 of 26
07:26:36.65 process pointer page 11 of 26
07:26:36.75 process pointer page 12 of 26
07:26:36.82 process pointer page 13 of 26
07:26:36.92 process pointer page 14 of 26
07:26:37.01 process pointer page 15 of 26
07:26:37.10 process pointer page 16 of 26
07:26:37.18 process pointer page 17 of 26
07:26:37.28 process pointer page 18 of 26
07:26:37.37 process pointer page 19 of 26
07:26:37.46 process pointer page 20 of 26
07:26:37.54 process pointer page 21 of 26
07:26:37.63 process pointer page 22 of 26
07:26:37.71 process pointer page 23 of 26
07:26:37.81 process pointer page 24 of 26
07:26:37.88 process pointer page 25 of 26
07:26:37.92 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
07:26:39.15 Relation 265 (XQD_3300_3400) is ok

07:26:39.15 Relation 266 (XQS_1000_1200)
07:26:39.16 process pointer page 0 of 46
07:26:39.24 process pointer page 1 of 46
07:26:39.34 process pointer page 2 of 46
07:26:39.43 process pointer page 3 of 46
07:26:39.51 process pointer page 4 of 46
07:26:39.60 process pointer page 5 of 46
07:26:39.69 process pointer page 6 of 46
07:26:39.79 process pointer page 7 of 46
07:26:39.87 process pointer page 8 of 46
07:26:39.96 process pointer page 9 of 46
07:26:40.05 process pointer page 10 of 46
07:26:40.13 process pointer page 11 of 46
07:26:40.22 process pointer page 12 of 46
07:26:40.32 process pointer page 13 of 46
07:26:40.40 process pointer page 14 of 46
07:26:40.49 process pointer page 15 of 46
07:26:40.58 process pointer page 16 of 46
07:26:40.66 process pointer page 17 of 46
07:26:40.75 process pointer page 18 of 46
07:26:40.85 process pointer page 19 of 46
07:26:40.93 process pointer page 20 of 46
07:26:41.02 process pointer page 21 of 46
07:26:41.11 process pointer page 22 of 46
07:26:41.19 process pointer page 23 of 46
07:26:41.29 process pointer page 24 of 46
07:26:41.38 process pointer page 25 of 46
07:26:41.46 process pointer page 26 of 46
07:26:41.55 process pointer page 27 of 46
07:26:41.64 process pointer page 28 of 46
07:26:41.72 process pointer page 29 of 46
07:26:41.82 process pointer page 30 of 46
07:26:41.91 process pointer page 31 of 46
07:26:41.99 process pointer page 32 of 46
07:26:42.08 process pointer page 33 of 46
07:26:42.17 process pointer page 34 of 46
07:26:42.28 process pointer page 35 of 46
07:26:42.44 process pointer page 36 of 46
07:26:42.72 process pointer page 37 of 46
07:26:43.00 process pointer page 38 of 46
07:26:43.30 process pointer page 39 of 46
07:26:43.58 process pointer page 40 of 46
07:26:43.86 process pointer page 41 of 46
07:26:44.23 process pointer page 42 of 46
07:26:44.56 process pointer page 43 of 46
07:26:44.94 process pointer page 44 of 46
07:26:45.26 process pointer page 45 of 46
07:26:45.51 Index 1 (XQS_1000_1200_DOC_ID)
07:26:48.15 Index 2 (XQS_1000_1200_SND_ID)
07:26:50.68 Index 3 (XQS_1000_1200_RCV_ID)
07:26:53.11 Relation 266 (XQS_1000_1200) is ok

07:26:53.11 Relation 267 (XQS_1200_2000)
07:26:53.11 process pointer page 0 of 51
07:26:53.20 process pointer page 1 of 51
07:26:53.31 process pointer page 2 of 51
07:26:53.42 process pointer page 3 of 51
07:26:53.52 process pointer page 4 of 51
07:26:53.62 process pointer page 5 of 51
07:26:53.72 process pointer page 6 of 51
07:26:53.83 process pointer page 7 of 51
07:26:53.94 process pointer page 8 of 51
07:26:54.05 process pointer page 9 of 51
07:26:54.45 process pointer page 10 of 51
07:26:54.87 process pointer page 11 of 51
07:26:55.31 process pointer page 12 of 51
07:26:55.79 process pointer page 13 of 51
07:26:56.23 process pointer page 14 of 51
07:26:56.60 process pointer page 15 of 51
07:26:57.01 process pointer page 16 of 51
07:26:57.38 process pointer page 17 of 51
07:26:57.82 process pointer page 18 of 51
07:26:58.27 process pointer page 19 of 51
07:26:58.73 process pointer page 20 of 51
07:26:59.13 process pointer page 21 of 51
07:26:59.58 process pointer page 22 of 51
07:26:59.99 process pointer page 23 of 51
07:27:00.41 process pointer page 24 of 51
07:27:00.82 process pointer page 25 of 51
07:27:01.24 process pointer page 26 of 51
07:27:01.69 process pointer page 27 of 51
07:27:02.10 process pointer page 28 of 51
07:27:02.49 process pointer page 29 of 51
07:27:02.91 process pointer page 30 of 51
07:27:03.37 process pointer page 31 of 51
07:27:03.84 process pointer page 32 of 51
07:27:04.31 process pointer page 33 of 51
07:27:04.78 process pointer page 34 of 51
07:27:05.25 process pointer page 35 of 51
07:27:05.70 process pointer page 36 of 51
07:27:06.14 process pointer page 37 of 51
07:27:06.57 process pointer page 38 of 51
07:27:07.01 process pointer page 39 of 51
07:27:07.43 process pointer page 40 of 51
07:27:07.87 process pointer page 41 of 51
07:27:08.32 process pointer page 42 of 51
07:27:08.73 process pointer page 43 of 51
07:27:09.12 process pointer page 44 of 51
07:27:09.55 process pointer page 45 of 51
07:27:09.94 process pointer page 46 of 51
07:27:10.36 process pointer page 47 of 51
07:27:10.75 process pointer page 48 of 51
07:27:11.08 process pointer page 49 of 51
07:27:11.50 process pointer page 50 of 51
07:27:11.58 Index 1 (XQS_1200_2000_DOC_ID)
07:27:14.44 Index 2 (XQS_1200_2000_SND_ID)
07:27:17.66 Index 3 (XQS_1200_2000_RCV_ID)
07:27:20.36 Relation 267 (XQS_1200_2000) is ok

07:27:20.36 Relation 268 (XQS_1000_3300)
07:27:20.36 process pointer page 0 of 26
07:27:20.86 process pointer page 1 of 26
07:27:21.36 process pointer page 2 of 26
07:27:21.88 process pointer page 3 of 26
07:27:22.39 process pointer page 4 of 26
07:27:22.87 process pointer page 5 of 26
07:27:23.37 process pointer page 6 of 26
07:27:23.83 process pointer page 7 of 26
07:27:24.31 process pointer page 8 of 26
07:27:24.81 process pointer page 9 of 26
07:27:25.31 process pointer page 10 of 26
07:27:25.79 process pointer page 11 of 26
07:27:26.29 process pointer page 12 of 26
07:27:26.77 process pointer page 13 of 26
07:27:27.27 process pointer page 14 of 26
07:27:27.76 process pointer page 15 of 26
07:27:28.24 process pointer page 16 of 26
07:27:28.71 process pointer page 17 of 26
07:27:29.19 process pointer page 18 of 26
07:27:29.68 process pointer page 19 of 26
07:27:30.18 process pointer page 20 of 26
07:27:30.64 process pointer page 21 of 26
07:27:31.10 process pointer page 22 of 26
07:27:31.55 process pointer page 23 of 26
07:27:31.99 process pointer page 24 of 26
07:27:32.39 process pointer page 25 of 26
07:27:32.50 Index 1 (XQS_1000_3300_DOC_ID)
07:27:33.90 Index 2 (XQS_1000_3300_SND_ID)
07:27:35.70 Index 3 (XQS_1000_3300_RCV_ID)
07:27:37.55 Relation 268 (XQS_1000_3300) is ok

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

07:27:37.55 Relation 270 (XQS_2100_3300)
07:27:37.55 process pointer page 0 of 35
07:27:38.04 process pointer page 1 of 35
07:27:38.54 process pointer page 2 of 35
07:27:39.04 process pointer page 3 of 35
07:27:39.54 process pointer page 4 of 35
07:27:40.02 process pointer page 5 of 35
07:27:40.52 process pointer page 6 of 35
07:27:40.97 process pointer page 7 of 35
07:27:41.45 process pointer page 8 of 35
07:27:41.95 process pointer page 9 of 35
07:27:42.45 process pointer page 10 of 35
07:27:42.97 process pointer page 11 of 35
07:27:43.44 process pointer page 12 of 35
07:27:43.89 process pointer page 13 of 35
07:27:44.37 process pointer page 14 of 35
07:27:44.84 process pointer page 15 of 35
07:27:45.32 process pointer page 16 of 35
07:27:45.79 process pointer page 17 of 35
07:27:46.31 process pointer page 18 of 35
07:27:46.77 process pointer page 19 of 35
07:27:47.23 process pointer page 20 of 35
07:27:47.68 process pointer page 21 of 35
07:27:48.12 process pointer page 22 of 35
07:27:48.58 process pointer page 23 of 35
07:27:49.04 process pointer page 24 of 35
07:27:49.49 process pointer page 25 of 35
07:27:49.96 process pointer page 26 of 35
07:27:50.39 process pointer page 27 of 35
07:27:50.83 process pointer page 28 of 35
07:27:51.27 process pointer page 29 of 35
07:27:51.69 process pointer page 30 of 35
07:27:52.11 process pointer page 31 of 35
07:27:52.53 process pointer page 32 of 35
07:27:52.87 process pointer page 33 of 35
07:27:53.20 process pointer page 34 of 35
07:27:53.20 Index 1 (XQS_2100_3300_DOC_ID)
07:27:55.35 Index 2 (XQS_2100_3300_SND_ID)
07:27:57.29 Index 3 (XQS_2100_3300_RCV_ID)
07:27:59.77 Relation 270 (XQS_2100_3300) is ok

07:27:59.77 Relation 271 (XQS_3300_3400)
07:27:59.77 process pointer page 0 of 6
07:28:00.25 process pointer page 1 of 6
07:28:00.72 process pointer page 2 of 6
07:28:01.17 process pointer page 3 of 6
07:28:01.64 process pointer page 4 of 6
07:28:02.11 process pointer page 5 of 6
07:28:02.30 Index 1 (XQS_3300_3400_DOC_ID)
07:28:02.67 Index 2 (XQS_3300_3400_SND_ID)
07:28:03.08 Relation 271 (XQS_3300_3400) is ok

07:28:03.11 Validation finished
Done for 127470 ms, from 7:25:55.73 to 7:28:03.20.

Differences between old and current firebird.log

7:28:04.75. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-05-13 07:28 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 Sat May 13 07:25:55 2017
7: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Sat May 13 07:28:03 2017
12: Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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


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

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

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