Firebird 4.0 Performance Logs

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 7001.37 2915 1260247 2017-02-07 08:16 2017-02-07 11:16
customer order: creation 528.00 391 95040 2017-02-07 08:16 2017-02-07 11:16
customer order: refuse 43.24 207 7784 2017-02-07 08:16 2017-02-07 11:16
order to supplier: creation 136.47 1695 24565 2017-02-07 08:16 2017-02-07 11:16
order to supplier: removal 3.27 18397 588 2017-02-07 08:16 2017-02-07 11:16
invoice (draft): creation 135.31 2506 24355 2017-02-07 08:16 2017-02-07 11:16
invoice (draft): removal 48.66 424 8758 2017-02-07 08:16 2017-02-07 11:16
invoice accept: apply 71.46 9409 12863 2017-02-07 08:16 2017-02-07 11:16
invoice accept: cancel 21.68 2699 3903 2017-02-07 08:16 2017-02-07 11:16
customer reserve: creation 3941.27 138 709428 2017-02-07 08:16 2017-02-07 11:16
customer reserve: removal 1350.67 56 243120 2017-02-07 08:16 2017-02-07 11:16
realization accept: apply 246.38 361 44348 2017-02-07 08:16 2017-02-07 11:16
realization accept: cancel 95.17 135 17130 2017-02-07 08:16 2017-02-07 11:16
payment from customer: creation 175.74 944 31634 2017-02-07 08:16 2017-02-07 11:16
payment from customer: removal 16.62 93 2992 2017-02-07 08:16 2017-02-07 11:16
payment to supplier: creation 145.57 539 26203 2017-02-07 08:16 2017-02-07 11:16
payment to supplier: removal 10.22 103 1840 2017-02-07 08:16 2017-02-07 11:16
service: total inventory turnovers 10.87 2585 1956 2017-02-07 08:16 2017-02-07 11:16
service: total monetary turnovers 20.71 49 3728 2017-02-07 08:16 2017-02-07 11:16
service: refresh index statistics 0.07 14645 12 2017-02-07 08:16 2017-02-07 11:16
Done for 121300 ms, from 11:19:14.81 to 11:21:16.11.

Performance in DYNAMIC:

ACTION ITRV_NO CNT_OK_PER_MINUTE CNT_ALL CNT_OK CNT_ERR ERR_PRC ITRV_BEG ITRV_END
interval # 1, overall 1 5658 116039 101839 14200 12.24 08:16:31 08:34:31
interval # 2, overall 2 7223 147475 130009 17466 11.84 08:34:32 08:52:32
interval # 3, overall 3 8067 166157 145207 20950 12.61 08:52:33 09:10:33
interval # 4, overall 4 7660 157321 137871 19450 12.36 09:10:34 09:28:34
interval # 5, overall 5 6917 140995 124511 16484 11.69 09:28:35 09:46:35
interval # 6, overall 6 7224 156840 130026 26814 17.10 09:46:36 10:04:36
interval # 7, overall 7 6548 126965 117857 9108 7.17 10:04:37 10:22:37
interval # 8, overall 8 6318 126719 113721 12998 10.26 10:22:38 10:40:38
interval # 9, overall 9 7220 145162 129959 15203 10.47 10:40:39 10:58:39
interval # 10, overall 10 7180 149096 129247 19849 13.31 10:58:40 11:16:40
Done for 282140 ms, from 11:25:59.61 to 11:30:41.75.

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 4721.27 0.4460 1.4669 1912 100
TEST_TIME 2 4454.30 0.7775 1.2531 1598 100
TEST_TIME 3 4384.64 0.8487 1.1446 1871 100
TEST_TIME 4 4305.28 0.8743 1.1109 1648 100
TEST_TIME 5 4410.04 0.8677 1.1299 2179 100
TEST_TIME 6 4722.34 0.8793 1.0891 1654 100
TEST_TIME 7 4855.28 0.9081 1.0973 2256 100
TEST_TIME 8 4985.63 0.9350 1.0398 2112 100
TEST_TIME 9 4938.07 0.9588 1.0302 1990 100
TEST_TIME 10 4817.23 0.9505 1.0430 1259 100
TEST_TIME 11 4826.03 0.9465 1.0539 1915 100
TEST_TIME 12 4914.10 0.9488 1.0594 1963 100
TEST_TIME 13 5082.14 0.9456 1.0521 1744 100
TEST_TIME 14 5180.53 0.9584 1.0364 1622 100
TEST_TIME 15 5294.75 0.9464 1.0467 2435 100
TEST_TIME 16 5424.27 0.9670 1.0332 2735 100
TEST_TIME 17 5511.53 0.9571 1.0484 2328 54
TEST_TIME 18 5644.75 0.9668 1.0373 2223 22
TEST_TIME 19 5698.70 0.9736 1.0272 1662 99
TEST_TIME 20 5766.24 0.9644 1.0336 2015 100
TEST_TIME 21 5873.85 0.9675 1.0304 2036 100
TEST_TIME 22 5932.13 0.9743 1.0276 2096 100
TEST_TIME 23 5972.52 0.9762 1.0242 1935 100
TEST_TIME 24 6007.98 0.9764 1.0209 1367 100
TEST_TIME 25 6024.24 0.9774 1.0246 1714 100
TEST_TIME 26 6095.71 0.9737 1.0216 1475 100
TEST_TIME 27 6115.04 0.9807 1.0202 1448 100
TEST_TIME 28 6122.65 0.9825 1.0183 1610 100
TEST_TIME 29 6135.26 0.9812 1.0219 1426 100
TEST_TIME 30 6221.66 0.9742 1.0268 2341 100
TEST_TIME 31 6359.09 0.9722 1.0241 2343 100
TEST_TIME 32 6436.70 0.9801 1.0165 2463 100
TEST_TIME 33 6399.73 0.9914 1.0120 1873 93
TEST_TIME 34 6375.29 0.9860 1.0179 1781 90
TEST_TIME 35 6373.36 0.9891 1.0174 1537 63
TEST_TIME 36 6418.80 0.9821 1.0180 1560 18
TEST_TIME 37 6473.86 0.9820 1.0158 1643 25
TEST_TIME 38 6496.14 0.9857 1.0122 1192 19
TEST_TIME 39 6480.80 0.9886 1.0127 1459 99
TEST_TIME 40 6494.43 0.9856 1.0130 1746 100
TEST_TIME 41 6511.47 0.9857 1.0137 1542 100
TEST_TIME 42 6516.87 0.9888 1.0118 1597 100
TEST_TIME 43 6523.07 0.9874 1.0103 1455 100
TEST_TIME 44 6515.49 0.9885 1.0097 1454 100
TEST_TIME 45 6587.84 0.9764 1.0197 2014 100
TEST_TIME 46 6669.68 0.9854 1.0182 2103 100
TEST_TIME 47 6751.16 0.9845 1.0167 2324 100
TEST_TIME 48 6836.22 0.9831 1.0145 1977 100
TEST_TIME 49 6890.88 0.9859 1.0128 2053 100
TEST_TIME 50 6891.44 0.9925 1.0122 1757 100
TEST_TIME 51 6910.32 0.9896 1.0123 1703 100
TEST_TIME 52 6925.74 0.9906 1.0095 1590 100
TEST_TIME 53 6963.15 0.9851 1.0102 1554 100
TEST_TIME 54 6968.91 0.9907 1.0117 1581 100
TEST_TIME 55 6966.01 0.9938 1.0086 1213 100
TEST_TIME 56 6953.39 0.9924 1.0049 1405 100
TEST_TIME 57 6943.97 0.9910 1.0096 1295 100
TEST_TIME 58 6912.85 0.9966 1.0049 1100 98
TEST_TIME 59 6850.31 0.9969 1.0055 1439 96
TEST_TIME 60 6856.29 0.9879 1.0109 1816 100
TEST_TIME 61 6916.17 0.9859 1.0115 1888 100
TEST_TIME 62 6959.26 0.9891 1.0087 1954 100
TEST_TIME 63 6975.96 0.9904 1.0104 2140 100
TEST_TIME 64 7018.86 0.9885 1.0119 1822 100
TEST_TIME 65 7060.89 0.9904 1.0084 1928 100
TEST_TIME 66 7077.08 0.9908 1.0099 1833 100
TEST_TIME 67 7105.51 0.9909 1.0116 1663 100
TEST_TIME 68 7131.09 0.9932 1.0048 1669 100
TEST_TIME 69 7115.14 0.9924 1.0079 1600 100
TEST_TIME 70 7137.45 0.9904 1.0092 1424 100
TEST_TIME 71 7147.28 0.9936 1.0060 1544 100
TEST_TIME 72 7134.79 0.9942 1.0063 1511 100
TEST_TIME 73 7143.70 0.9913 1.0030 1377 100
TEST_TIME 74 7122.30 0.9953 1.0051 1258 98
TEST_TIME 75 7100.71 0.9948 1.0062 2066 98
TEST_TIME 76 7113.33 0.9912 1.0109 2033 75
TEST_TIME 77 7141.55 0.9939 1.0070 2101 48
TEST_TIME 78 7146.65 0.9934 1.0046 1897 87
TEST_TIME 79 7119.52 0.9956 1.0061 2137 97
TEST_TIME 80 7126.85 0.9925 1.0044 2011 95
TEST_TIME 81 7105.51 0.9950 1.0054 1944 93
TEST_TIME 82 7105.33 0.9932 1.0046 1888 95
TEST_TIME 83 7087.73 0.9950 1.0029 1752 93
TEST_TIME 84 7100.29 0.9899 1.0071 1297 100
TEST_TIME 85 7098.32 0.9955 1.0067 1435 100
TEST_TIME 86 7094.46 0.9956 1.0046 1754 100
TEST_TIME 87 7083.29 0.9947 1.0051 1639 100
TEST_TIME 88 7073.44 0.9951 1.0038 1688 100
TEST_TIME 89 7086.57 0.9906 1.0083 1331 100
TEST_TIME 90 7090.90 0.9965 1.0039 1903 98
TEST_TIME 91 7078.48 0.9946 1.0062 2026 89
TEST_TIME 92 7093.32 0.9931 1.0073 1748 100
TEST_TIME 93 7113.76 0.9937 1.0041 2100 99
TEST_TIME 94 7098.90 0.9955 1.0044 1947 85
TEST_TIME 95 7096.25 0.9942 1.0054 1908 70
TEST_TIME 96 7091.82 0.9956 1.0036 1833 61
TEST_TIME 97 7078.69 0.9951 1.0051 1764 55
TEST_TIME 98 7090.22 0.9945 1.0030 1288 68
TEST_TIME 99 7084.46 0.9936 1.0045 1380 100
TEST_TIME 100 7064.59 0.9973 1.0024 1764 97
TEST_TIME 101 7044.88 0.9952 1.0035 1530 96
TEST_TIME 102 7034.98 0.9950 1.0064 1451 99
TEST_TIME 103 7036.21 0.9965 1.0039 1430 100
TEST_TIME 104 7039.47 0.9938 1.0037 1467 100
TEST_TIME 105 7049.49 0.9928 1.0063 2176 100
TEST_TIME 106 7080.66 0.9925 1.0062 2314 100
TEST_TIME 107 7104.44 0.9935 1.0050 2165 100
TEST_TIME 108 7110.33 0.9950 1.0034 2046 99
TEST_TIME 109 7092.03 0.9968 1.0040 1933 89
TEST_TIME 110 7084.84 0.9959 1.0033 2014 91
TEST_TIME 111 7069.25 0.9965 1.0043 1743 91
TEST_TIME 112 7073.07 0.9948 1.0053 1637 94
TEST_TIME 113 7068.41 0.9971 1.0037 1582 95
TEST_TIME 114 7052.94 0.9972 1.0052 1446 96
TEST_TIME 115 7054.69 0.9962 1.0032 1575 97
TEST_TIME 116 7044.15 0.9961 1.0055 1517 97
TEST_TIME 117 7034.62 0.9982 1.0023 1586 98
TEST_TIME 118 7009.93 0.9973 1.0033 1631 90
TEST_TIME 119 6997.95 0.9965 1.0024 1533 90
TEST_TIME 120 6984.14 0.9960 1.0051 1585 99
TEST_TIME 121 6987.27 0.9963 1.0037 2321 97
TEST_TIME 122 7003.21 0.9932 1.0057 1995 99
TEST_TIME 123 7006.97 0.9970 1.0034 2025 93
TEST_TIME 124 7014.00 0.9943 1.0053 1846 99
TEST_TIME 125 7013.98 0.9974 1.0049 1870 100
TEST_TIME 126 7017.46 0.9964 1.0027 2037 99
TEST_TIME 127 6999.81 0.9973 1.0035 1831 96
TEST_TIME 128 7005.68 0.9949 1.0047 1682 92
TEST_TIME 129 7020.94 0.9948 1.0026 1585 98
TEST_TIME 130 7013.63 0.9959 1.0041 1465 100
TEST_TIME 131 7007.57 0.9973 1.0020 1866 100
TEST_TIME 132 6982.65 0.9980 1.0025 1837 91
TEST_TIME 133 6971.18 0.9966 1.0029 1603 90
TEST_TIME 134 6962.02 0.9981 1.0027 1422 98
TEST_TIME 135 6947.73 0.9974 1.0021 1676 99
TEST_TIME 136 6937.32 0.9962 1.0059 2507 95
TEST_TIME 137 6947.69 0.9971 1.0039 2311 89
TEST_TIME 138 6948.12 0.9966 1.0042 2176 87
TEST_TIME 139 6955.46 0.9971 1.0025 2102 97
TEST_TIME 140 6946.25 0.9967 1.0056 1972 100
TEST_TIME 141 6952.95 0.9977 1.0026 2037 99
TEST_TIME 142 6945.74 0.9966 1.0030 1982 86
TEST_TIME 143 6939.25 0.9971 1.0035 1708 83
TEST_TIME 144 6934.02 0.9973 1.0047 1520 90
TEST_TIME 145 6938.86 0.9971 1.0021 1559 99
TEST_TIME 146 6933.84 0.9960 1.0038 1383 100
TEST_TIME 147 6932.38 0.9972 1.0018 1711 100
TEST_TIME 148 6914.04 0.9977 1.0024 1563 93
TEST_TIME 149 6921.28 0.9946 1.0019 1374 100
TEST_TIME 150 6910.28 0.9968 1.0034 2390 96
TEST_TIME 151 6925.13 0.9963 1.0041 2132 100
TEST_TIME 152 6935.45 0.9960 1.0034 2198 98
TEST_TIME 153 6932.23 0.9973 1.0027 2062 90
TEST_TIME 154 6935.76 0.9957 1.0055 1747 91
TEST_TIME 155 6942.89 0.9979 1.0029 1950 92
TEST_TIME 156 6935.85 0.9975 1.0040 1832 91
TEST_TIME 157 6935.94 0.9976 1.0026 1624 98
TEST_TIME 158 6938.60 0.9959 1.0045 1559 100
TEST_TIME 159 6939.41 0.9981 1.0032 1502 100
TEST_TIME 160 6945.19 0.9961 1.0042 1503 100
TEST_TIME 161 6952.46 0.9969 1.0027 1409 100
TEST_TIME 162 6970.55 0.9939 1.0031 1236 100
TEST_TIME 163 6970.53 0.9970 1.0037 1347 100
TEST_TIME 164 6974.56 0.9970 1.0029 1199 100
TEST_TIME 165 6989.09 0.9948 1.0048 1659 100
TEST_TIME 166 7004.19 0.9966 1.0024 2124 100
TEST_TIME 167 7000.03 0.9970 1.0037 1776 98
TEST_TIME 168 7004.47 0.9971 1.0045 1896 100
TEST_TIME 169 7015.16 0.9970 1.0027 1849 100
TEST_TIME 170 7020.12 0.9960 1.0036 1812 99
TEST_TIME 171 7037.46 0.9953 1.0043 1596 100
TEST_TIME 172 7048.72 0.9969 1.0030 1594 100
TEST_TIME 173 7036.88 0.9989 1.0014 1692 98
TEST_TIME 174 7021.37 0.9978 1.0033 1463 98
TEST_TIME 175 7014.44 0.9986 1.0017 1488 93
TEST_TIME 176 7002.43 0.9977 1.0040 1335 94
TEST_TIME 177 7007.44 0.9976 1.0020 1493 98
TEST_TIME 178 6994.87 0.9982 1.0032 1330 98
TEST_TIME 179 7002.02 0.9965 1.0035 1220 100
TEST_TIME 180 6995.85 0.9988 1.0007 741 100
Done for 13400 ms, from 11:30:44.37 to 11:30:57.77.

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 49341 103483 44809 <null> 41748 2546 45559 120279 41011 66273 62099 64597 68189 60380 110662 59336 276532 645532 <null> 08:16:31 08:34:31
fetches per second 2 51692 67930 54590 <null> 48854 145684 89228 <null> 40216 150252 61736 40691 106208 <null> 86567 33625 86417 <null> <null> 08:34:32 08:52:32
fetches per second 3 62459 80483 67009 <null> 49100 21843 100795 <null> 20798 71001 57534 33515 86372 32514 150828 126654 145121 <null> <null> 08:52:33 09:10:33
fetches per second 4 52698 51177 48608 74192 39178 <null> 82440 118987 74856 126291 50885 22022 86603 63009 123514 58538 132445 25355 <null> 09:10:34 09:28:34
fetches per second 5 15773 19280 15543 <null> 20802 <null> 36692 <null> 30913 10491 10222 2259 25685 18611 58050 4287 <null> 119377 <null> 09:28:35 09:46:35
fetches per second 6 23462 58150 19900 5134 32222 <null> 62073 <null> 15189 9952 35070 1652 39012 3234 55646 60816 <null> <null> <null> 09:46:36 10:04:36
fetches per second 7 4967 2987 6770 3553 8926 <null> 13854 <null> 13681 12891 5411 9841 7643 5565 11546 2944 108499 141937 <null> 10:04:37 10:22:37
fetches per second 8 6872 4919 9672 <null> 9111 <null> 20510 <null> 2403 4224 5568 2258 14562 3459 7773 4021 <null> 108322 <null> 10:22:38 10:40:38
fetches per second 9 13591 16784 16999 24347 17271 1277 16913 16276 11667 55871 23114 45672 34078 19010 16387 28301 50457 57891 <null> 10:40:39 10:58:39
fetches per second 10 31058 39525 35337 <null> 28020 3869 36147 60611 1833 93385 30412 25652 44890 73192 36481 <null> 215472 180871 <null> 10:58:40 11:16:40
marks per second 1 11108 14605 9531 <null> 8648 551 5846 27043 5211 14178 12517 11185 5964 10019 6206 12282 8585 20234 <null> 08:16:31 08:34:31
marks per second 2 11301 9153 11933 <null> 11003 30562 13156 <null> 6911 24275 12457 5989 4751 <null> 7341 5875 13920 <null> <null> 08:34:32 08:52:32
marks per second 3 13222 10650 14900 <null> 11122 5223 13484 <null> 2828 15762 10864 5172 6560 3428 11670 22071 14301 <null> <null> 08:52:33 09:10:33
marks per second 4 11299 6854 10341 13312 8571 <null> 11198 19166 8150 18755 8696 3381 6117 10310 9881 9230 13651 3067 <null> 09:10:34 09:28:34
marks per second 5 3542 2720 3017 <null> 3924 <null> 4070 <null> 4237 2323 1778 352 1030 2958 3168 1022 <null> 1160 <null> 09:28:35 09:46:35
marks per second 6 5051 7281 3866 859 6955 <null> 8958 <null> 2047 1548 6061 323 1975 492 3308 11764 <null> <null> <null> 09:46:36 10:04:36
marks per second 7 1064 429 792 909 1405 <null> 1714 <null> 1081 2247 908 1278 249 944 896 500 1756 1154 <null> 10:04:37 10:22:37
marks per second 8 1465 622 1143 <null> 1307 <null> 2845 <null> 317 689 1060 365 512 705 936 595 <null> 773 <null> 10:22:38 10:40:38
marks per second 9 2867 2093 3161 4914 3101 237 2573 2658 1520 11775 3759 5027 1084 3368 2127 7084 1591 1998 <null> 10:40:39 10:58:39
marks per second 10 6691 4102 7067 <null> 5260 708 5077 9556 251 15237 5480 3941 1315 12234 6110 <null> 15814 14166 <null> 10:58:40 11:16:40
reads/fetches*100 1 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 08:16:31 08:34:31
reads/fetches*100 2 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 <null> 0 0 0 <null> <null> 08:34:32 08:52:32
reads/fetches*100 3 0 0 0 <null> 0 0 0 <null> 0 0 0 0 0 0 0 0 0 <null> <null> 08:52:33 09:10:33
reads/fetches*100 4 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 09:10:34 09:28:34
reads/fetches*100 5 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 <null> 0 <null> 09:28:35 09:46:35
reads/fetches*100 6 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 <null> <null> <null> 09:46:36 10:04:36
reads/fetches*100 7 0 0 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 <null> 10:04:37 10:22:37
reads/fetches*100 8 0 0 0 <null> 0 <null> 0 <null> 0 0 0 0 0 0 0 0 <null> 0 <null> 10:22:38 10:40:38
reads/fetches*100 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 10:40:39 10:58:39
reads/fetches*100 10 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 10:58:40 11:16:40
writes/marks*100 1 0 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 3 0 <null> 08:16:31 08:34:31
writes/marks*100 2 0 0 0 <null> 0 0 0 <null> 1 0 0 0 0 <null> 0 0 2 <null> <null> 08:34:32 08:52:32
writes/marks*100 3 0 0 1 <null> 0 0 0 <null> 1 0 0 0 0 0 0 0 2 <null> <null> 08:52:33 09:10:33
writes/marks*100 4 0 0 0 0 0 <null> 0 0 1 1 0 0 0 0 0 0 1 0 <null> 09:10:34 09:28:34
writes/marks*100 5 0 0 0 <null> 0 <null> 0 <null> 1 0 0 0 0 0 0 0 <null> 0 <null> 09:28:35 09:46:35
writes/marks*100 6 0 0 0 0 0 <null> 0 <null> 1 0 0 1 0 0 0 0 <null> <null> <null> 09:46:36 10:04:36
writes/marks*100 7 0 0 0 0 0 <null> 0 <null> 1 0 0 1 0 0 0 0 3 0 <null> 10:04:37 10:22:37
writes/marks*100 8 0 0 0 <null> 0 <null> 0 <null> 1 1 0 0 0 0 0 0 <null> 1 <null> 10:22:38 10:40:38
writes/marks*100 9 0 0 0 0 0 1 0 0 1 0 0 0 0 2 0 0 1 0 <null> 10:40:39 10:58:39
writes/marks*100 10 0 0 0 <null> 0 0 0 0 2 0 0 1 0 0 0 <null> 0 0 <null> 10:58:40 11:16:40
Done for 10640 ms, from 11:30:59.19 to 11:31:09.83.

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 2189341 2030565 158776 7.25 0 19703 43 158776 2017-02-07 08:16 2017-02-07 11:16
doc_list_biud 2189880 2030565 159315 7.27 0 27160 14 159315 2017-02-07 08:16 2017-02-07 11:16
sp_add_invoice_to_stock 22826 12863 9963 43.64 0 122102 9409 9963 2017-02-07 08:16 2017-02-07 11:16
sp_cancel_adding_invoice 4969 3903 1066 21.45 0 75629 2699 1066 2017-02-07 08:16 2017-02-07 11:16
sp_cancel_client_order 7967 7784 183 2.29 0 4540 207 183 2017-02-07 08:16 2017-02-07 11:16
sp_cancel_customer_reserve 393211 243120 150091 38.17 0 5943 56 150091 2017-02-07 08:16 2017-02-07 11:16
sp_cancel_pay_from_customer 3003 2992 11 0.36 0 1139 93 11 2017-02-07 08:16 2017-02-07 11:16
sp_cancel_pay_to_supplier 1844 1840 4 0.21 0 1450 103 4 2017-02-07 08:16 2017-02-07 11:16
sp_cancel_supplier_invoice 11179 8758 2421 21.65 0 27487 424 2421 2017-02-07 08:16 2017-02-07 11:16
sp_cancel_supplier_order 1845 588 1257 68.13 15 218759 18397 1257 2017-02-07 08:16 2017-02-07 11:16
sp_cancel_write_off 23698 17130 6568 27.71 0 3167 135 6568 2017-02-07 08:16 2017-02-07 11:16
sp_client_order 95040 95040 0 0.00 0 11903 391 0 2017-02-07 08:16 2017-02-07 11:16
sp_customer_reserve 709428 709428 0 0.00 0 11403 138 0 2017-02-07 08:16 2017-02-07 11:16
sp_fill_shopping_cart 144303 143960 343 0.23 0 5133 80 0 2017-02-07 08:16 2017-02-07 11:16
sp_fill_shopping_cart_clo_res 709428 709428 0 0.00 0 4446 11 0 2017-02-07 08:16 2017-02-07 11:16
sp_get_clo_for_invoice 12863 12863 0 0.00 0 5632 291 0 2017-02-07 08:16 2017-02-07 11:16
sp_kill_cost_storno 33058 25865 7193 21.75 0 999 10 7193 2017-02-07 08:16 2017-02-07 11:16
sp_kill_qstorno_ret_qs2qd 820900 512716 308184 37.54 0 27144 20 308184 2017-02-07 08:16 2017-02-07 11:16
sp_kill_qty_storno 497703 338494 159209 31.98 0 27160 60 159209 2017-02-07 08:16 2017-02-07 11:16
sp_lock_selected_doc 93745 80546 13199 14.07 0 1560 6 13199 2017-02-07 08:16 2017-02-07 11:16
sp_make_cost_storno 115048 115048 0 0.00 0 16348 393 0 2017-02-07 08:16 2017-02-07 11:16
sp_multiply_rows_for_pdistr 115048 115048 0 0.00 0 3697 34 0 2017-02-07 08:16 2017-02-07 11:16
sp_multiply_rows_for_qdistr 95040 95040 0 0.00 0 11154 132 0 2017-02-07 08:16 2017-02-07 11:16
sp_pay_from_customer 31634 31634 0 0.00 0 13431 944 0 2017-02-07 08:16 2017-02-07 11:16
sp_pay_to_supplier 26203 26203 0 0.00 0 14337 539 0 2017-02-07 08:16 2017-02-07 11:16
sp_payment_common 57837 57837 0 0.00 0 13307 49 0 2017-02-07 08:16 2017-02-07 11:16
sp_qd_handle_on_cancel_clo 7961 7784 177 2.22 0 4540 89 177 2017-02-07 08:16 2017-02-07 11:16
sp_qd_handle_on_invoice_upd_sts 17598 16766 832 4.72 0 6833 296 832 2017-02-07 08:16 2017-02-07 11:16
sp_qd_handle_on_reserve_upd_sts 44348 44348 0 0.00 0 16972 37 0 2017-02-07 08:16 2017-02-07 11:16
sp_reserve_write_off 44963 44348 615 1.36 0 19765 361 615 2017-02-07 08:16 2017-02-07 11:16
sp_supplier_invoice 24483 24355 128 0.52 0 33353 2506 0 2017-02-07 08:16 2017-02-07 11:16
sp_supplier_order 24780 24565 215 0.86 0 22464 1695 0 2017-02-07 08:16 2017-02-07 11:16
srv_find_qd_qs_mism 1311982 1153195 158787 12.10 0 3556 23 158787 2017-02-07 08:16 2017-02-07 11:16
srv_make_invnt_saldo 1956 1956 0 0.00 15 37814 2585 0 2017-02-07 08:16 2017-02-07 11:16
srv_make_money_saldo 3728 3728 0 0.00 0 2465 49 0 2017-02-07 08:16 2017-02-07 11:16
srv_recalc_idx_stat 12 12 0 0.00 1716 52541 14645 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_add_invoice_to_stock 9963 9963 0 0.00 0 1560 64 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_cancel_adding_invoice 1013 1013 0 0.00 0 2605 143 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_cancel_client_order 183 183 0 0.00 0 1419 89 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_cancel_customer_reserve 52 52 0 0.00 0 577 68 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_cancel_pay_from_customer 11 11 0 0.00 0 359 55 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_cancel_pay_to_supplier 4 4 0 0.00 0 94 51 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_cancel_supplier_invoice 771 771 0 0.00 0 967 53 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_cancel_supplier_order 18119 18119 0 0.00 0 4275 101 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_cancel_write_off 30 30 0 0.00 0 343 67 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_reserve_write_off 615 615 0 0.00 0 1186 61 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_supplier_invoice 128 128 0 0.00 0 951 58 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-abend:sp_supplier_order 215 215 0 0.00 0 468 40 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_add_invoice_to_stock 12863 12863 0 0.00 0 15428 502 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_cancel_adding_invoice 1616 1616 0 0.00 0 9142 590 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_cancel_client_order 7784 7784 0 0.00 0 1404 41 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_cancel_customer_reserve 3032 3032 0 0.00 0 1030 38 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_cancel_pay_from_customer 2992 2992 0 0.00 0 1217 31 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_cancel_pay_to_supplier 1840 1840 0 0.00 0 1497 33 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_cancel_supplier_invoice 1075 1075 0 0.00 0 921 36 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_cancel_supplier_order 588 588 0 0.00 0 24055 1395 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_cancel_write_off 4408 4408 0 0.00 0 1685 39 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_client_order 95040 95040 0 0.00 0 2559 47 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_customer_reserve 4449 4449 0 0.00 0 1404 33 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_pay_from_customer 31634 31634 0 0.00 0 1872 40 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_pay_to_supplier 26203 26203 0 0.00 0 1607 36 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_reserve_write_off 44348 44348 0 0.00 0 2387 42 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_supplier_invoice 24355 24355 0 0.00 0 9875 43 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:sp_supplier_order 24565 24565 0 0.00 0 1529 43 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:srv_make_invnt_saldo 1956 1956 0 0.00 0 905 12 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:srv_make_money_saldo 3728 3728 0 0.00 0 1560 16 0 2017-02-07 08:16 2017-02-07 11:16
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 640 153 0 2017-02-07 08:16 2017-02-07 11:16
v_add_invoice_to_stock 45652 25726 19926 43.64 0 1263 48 19926 2017-02-07 08:16 2017-02-07 11:16
v_all_customers 142336 142336 0 0.00 0 1108 4 0 2017-02-07 08:16 2017-02-07 11:16
v_all_suppliers 100446 99760 686 0.68 0 780 4 0 2017-02-07 08:16 2017-02-07 11:16
v_all_wares 190080 190080 0 0.00 0 671 4 0 2017-02-07 08:16 2017-02-07 11:16
v_cancel_adding_invoice 3858 3232 626 16.22 0 4821 159 626 2017-02-07 08:16 2017-02-07 11:16
v_cancel_client_order 15934 15568 366 2.29 0 874 5 366 2017-02-07 08:16 2017-02-07 11:16
v_cancel_customer_prepayment 6006 5984 22 0.36 0 593 5 22 2017-02-07 08:16 2017-02-07 11:16
v_cancel_customer_reserve 6168 6064 104 1.68 0 343 6 104 2017-02-07 08:16 2017-02-07 11:16
v_cancel_payment_to_supplier 3688 3680 8 0.21 0 1108 7 8 2017-02-07 08:16 2017-02-07 11:16
v_cancel_supplier_invoice 3692 2150 1542 41.76 0 983 45 1542 2017-02-07 08:16 2017-02-07 11:16
v_cancel_supplier_order 3690 1176 2514 68.13 0 375 6 2514 2017-02-07 08:16 2017-02-07 11:16
v_cancel_write_off 8876 8816 60 0.67 0 2294 102 60 2017-02-07 08:16 2017-02-07 11:16
v_max_id_clo_ord 24780 24565 215 0.86 0 483 5 0 2017-02-07 08:16 2017-02-07 11:16
v_max_id_clo_res 4449 4449 0 0.00 0 1076 13 0 2017-02-07 08:16 2017-02-07 11:16
v_max_id_ord_sup 24483 24355 128 0.52 0 483 4 0 2017-02-07 08:16 2017-02-07 11:16
v_max_non_paid_invoice 25243 25243 0 0.00 0 359 4 0 2017-02-07 08:16 2017-02-07 11:16
v_max_non_paid_realizn 31634 31634 0 0.00 0 608 4 0 2017-02-07 08:16 2017-02-07 11:16
v_min_id_clo_ord 24780 24565 215 0.86 0 1092 5 0 2017-02-07 08:16 2017-02-07 11:16
v_min_id_clo_res 4449 4449 0 0.00 0 1341 7 0 2017-02-07 08:16 2017-02-07 11:16
v_min_id_ord_sup 24483 24355 128 0.52 0 1404 6 0 2017-02-07 08:16 2017-02-07 11:16
v_min_non_paid_invoice 26203 26203 0 0.00 0 873 5 0 2017-02-07 08:16 2017-02-07 11:16
v_min_non_paid_realizn 31634 31634 0 0.00 0 546 4 0 2017-02-07 08:16 2017-02-07 11:16
v_our_firm 47744 47744 0 0.00 0 592 4 0 2017-02-07 08:16 2017-02-07 11:16
v_reserve_write_off 89926 88696 1230 1.36 0 968 6 1230 2017-02-07 08:16 2017-02-07 11:16
x_lock_depdocs_on_canc_invoice 21673 11586 10087 46.54 0 3464 31 10087 2017-02-07 08:16 2017-02-07 11:16
x_lock_depdocs_on_canc_sup_ord 1843 588 1255 68.09 0 983 48 1255 2017-02-07 08:16 2017-02-07 11:16
x_make_qstorno_1000_1200 24780 24565 215 0.86 0 21824 1518 0 2017-02-07 08:16 2017-02-07 11:16
x_make_qstorno_1200_2000 24483 24355 128 0.52 0 32869 2328 0 2017-02-07 08:16 2017-02-07 11:16
x_make_qstorno_2100_3300 709428 709428 0 0.00 0 11388 114 0 2017-02-07 08:16 2017-02-07 11:16
Done for 484070 ms, from 11:39:53.59 to 11:47:57.66.

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

Exceptions occured during test work:

FB_MNEMONA CNT UNIT FB_GDSCODE DTS_BEG DTS_END
deadlock 72 sp_kill_cost_storno 335544336 2017-02-07 08:16 2017-02-07 11:16
deadlock 92 sp_kill_qstorno_ret_qs2qd 335544336 2017-02-07 08:20 2017-02-07 11:13
deadlock 3261 sp_lock_selected_doc 335544336 2017-02-07 08:16 2017-02-07 11:16
deadlock 177 sp_qd_handle_on_cancel_clo 335544336 2017-02-07 08:16 2017-02-07 11:15
deadlock 194 sp_qd_handle_on_invoice_upd_sts 335544336 2017-02-07 08:17 2017-02-07 11:16
deadlock 63 x_lock_depdocs_on_canc_invoice 335544336 2017-02-07 08:18 2017-02-07 11:01
deadlock 13 x_lock_depdocs_on_canc_sup_ord 335544336 2017-02-07 08:22 2017-02-07 10:34
user_exc 215 x_make_qstorno_1000_1200 335544517 2017-02-07 08:18 2017-02-07 11:16
user_exc 128 x_make_qstorno_1200_2000 335544517 2017-02-07 08:16 2017-02-07 11:13
concurrent_transaction 8188 sp_lock_selected_doc 335544878 2017-02-07 08:16 2017-02-07 11:16
concurrent_transaction 799 x_lock_depdocs_on_canc_invoice 335544878 2017-02-07 08:16 2017-02-07 11:16
concurrent_transaction 333 x_lock_depdocs_on_canc_sup_ord 335544878 2017-02-07 08:17 2017-02-07 11:16
Done for 14810 ms, from 11:48:11.07 to 11:48:25.88.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 484493
MON$OLDEST_ACTIVE 484494
MON$OLDEST_SNAPSHOT 484494
MON$NEXT_TRANSACTION 484494
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 951040
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.522 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.522 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.522 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P15"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.522 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P15"
on disk structure version 13.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 484560
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 484495
Oldest active 484496
Oldest snapshot 484496
Next transaction 484497
Sequence number 0
Next attachment ID 9502
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write

Variable header data:
Sweep interval: 0
*END*


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

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

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

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

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

Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.16, total records: 2351258
Average version length: 47.98, total versions: 4874, 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: 16, data page slots: 25536
Data pages: 25536, average fill: 73%
Primary pages: 25536, secondary pages: 0, swept pages: 15112
Empty pages: 1, full pages: 21402
Fill distribution:
0 - 19% = 2
20 - 39% = 4
40 - 59% = 87
60 - 79% = 25437
80 - 99% = 6

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 11667, nodes: 2351258
Average node length: 19.35, total dup: 0, max dup: 0
Average key length: 16.39, compression ratio: 1.65
Average prefix length: 13.61, average data length: 13.39
Clustering factor: 487255, ratio: 0.21
Fill distribution:
0 - 19% = 763
20 - 39% = 2845
40 - 59% = 5463
60 - 79% = 1128
80 - 99% = 1468

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 8435, nodes: 2351258
Average node length: 11.61, total dup: 0, max dup: 0
Average key length: 8.65, compression ratio: 1.04
Average prefix length: 3.34, average data length: 5.66
Clustering factor: 462768, ratio: 0.20
Fill distribution:
0 - 19% = 0
20 - 39% = 4025
40 - 59% = 4308
60 - 79% = 86
80 - 99% = 16

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 178292, depth: 3, leaf buckets: 4235, nodes: 2351258
Average node length: 6.84, total dup: 1706478, max dup: 49
Average key length: 3.88, compression ratio: 2.32
Average prefix length: 7.39, average data length: 1.61
Clustering factor: 444794, ratio: 0.19
Fill distribution:
0 - 19% = 175
20 - 39% = 1473
40 - 59% = 1770
60 - 79% = 267
80 - 99% = 550

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.42, total records: 716774
Average version length: 61.76, total versions: 1532, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 9080
Data pages: 9080, average fill: 75%
Primary pages: 9080, secondary pages: 0, swept pages: 8201
Empty pages: 4, full pages: 8273
Fill distribution:
0 - 19% = 5
20 - 39% = 5
40 - 59% = 36
60 - 79% = 9006
80 - 99% = 28

Index DOC_LIST_ID_DESC (1)
Root page: 252981, depth: 3, leaf buckets: 2663, nodes: 716774
Average node length: 11.69, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 174217, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 1480
40 - 59% = 1142
60 - 79% = 39
80 - 99% = 1

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 756, nodes: 716774
Average node length: 4.89, total dup: 716724, max dup: 42822
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 324846, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 634
60 - 79% = 98
80 - 99% = 24

Index PK_DOC_LIST (0)
Root page: 330554, depth: 3, leaf buckets: 2149, nodes: 716774
Average node length: 11.69, 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: 174217, ratio: 0.24
Fill distribution:
0 - 19% = 143
20 - 39% = 687
40 - 59% = 757
60 - 79% = 262
80 - 99% = 300

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

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

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

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

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

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

INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 66.78, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 19.02, total fragments: 390, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.56
Pointer pages: 1, data page slots: 864
Data pages: 36, average fill: 19%
Primary pages: 4, secondary pages: 32, swept pages: 4
Empty pages: 18, full pages: 3
Fill distribution:
0 - 19% = 21
20 - 39% = 11
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3

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

INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 4.20, total records: 8064
Average version length: 71.14, total versions: 7588, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 22.83
Pointer pages: 2, data page slots: 1360
Data pages: 296, average fill: 37%
Primary pages: 295, secondary pages: 1, swept pages: 89
Empty pages: 90, full pages: 62
Fill distribution:
0 - 19% = 126
20 - 39% = 31
40 - 59% = 49
60 - 79% = 51
80 - 99% = 39

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 42, nodes: 8064
Average node length: 14.08, total dup: 835, max dup: 1
Average key length: 11.75, compression ratio: 2.30
Average prefix length: 18.15, average data length: 8.85
Clustering factor: 6142, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 34
40 - 59% = 8
60 - 79% = 0
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.02, 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.13
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 10.34, total records: 500
Average version length: 45.11, total versions: 388, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 6.19
Pointer pages: 1, data page slots: 40
Data pages: 32, average fill: 15%
Primary pages: 30, secondary pages: 2, swept pages: 17
Empty pages: 20, full pages: 3
Fill distribution:
0 - 19% = 25
20 - 39% = 1
40 - 59% = 2
60 - 79% = 2
80 - 99% = 2

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 318764, depth: 2, leaf buckets: 1, nodes: 500
Average node length: 5.05, total dup: 438, max dup: 112
Average key length: 3.82, compression ratio: 4.97
Average prefix length: 17.30, average data length: 1.70
Clustering factor: 224, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 20.01, total records: 932880
Average version length: 42.60, total versions: 784, max versions: 13
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.20
Pointer pages: 4, data page slots: 5776
Data pages: 5776, average fill: 74%
Primary pages: 5770, secondary pages: 6, swept pages: 4921
Empty pages: 12, full pages: 5044
Fill distribution:
0 - 19% = 28
20 - 39% = 67
40 - 59% = 149
60 - 79% = 5054
80 - 99% = 478

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 321, nodes: 307297
Average node length: 4.90, total dup: 307248, max dup: 16468
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 42182, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 16
40 - 59% = 184
60 - 79% = 109
80 - 99% = 11

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 352, nodes: 307297
Average node length: 5.84, total dup: 277114, max dup: 55
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 47625, ratio: 0.15
Fill distribution:
0 - 19% = 1
20 - 39% = 24
40 - 59% = 147
60 - 79% = 107
80 - 99% = 73

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 343, nodes: 307297
Average node length: 5.84, total dup: 277114, max dup: 55
Average key length: 2.95, compression ratio: 7.46
Average prefix length: 21.15, average data length: 0.85
Clustering factor: 47689, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 19
40 - 59% = 124
60 - 79% = 116
80 - 99% = 84

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 347, nodes: 307297
Average node length: 5.63, total dup: 277114, max dup: 55
Average key length: 2.74, compression ratio: 3.29
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 47739, ratio: 0.16
Fill distribution:
0 - 19% = 3
20 - 39% = 22
40 - 59% = 155
60 - 79% = 109
80 - 99% = 58

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

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 714621, depth: 2, leaf buckets: 261, nodes: 316458
Average node length: 4.60, total dup: 316277, max dup: 2734
Average key length: 2.00, compression ratio: 1.29
Average prefix length: 2.59, average data length: 0.00
Clustering factor: 41884, ratio: 0.13
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 123
60 - 79% = 63
80 - 99% = 74

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

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

PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.86, total records: 13273958
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.17
Pointer pages: 194, data page slots: 315144
Data pages: 315144, average fill: 87%
Primary pages: 315144, secondary pages: 0, swept pages: 3
Empty pages: 6, full pages: 315136
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 1
60 - 79% = 0
80 - 99% = 315136

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 15074, nodes: 13273958
Average node length: 5.72, total dup: 12381112, max dup: 144
Average key length: 2.17, compression ratio: 3.69
Average prefix length: 7.87, average data length: 0.12
Clustering factor: 4604557, ratio: 0.35
Fill distribution:
0 - 19% = 18
20 - 39% = 0
40 - 59% = 8321
60 - 79% = 4481
80 - 99% = 2254

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 13321, nodes: 13273958
Average node length: 4.64, total dup: 13273953, max dup: 12095919
Average key length: 1.09, compression ratio: 0.41
Average prefix length: 0.44, average data length: 0.00
Clustering factor: 400153, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 13289
60 - 79% = 2
80 - 99% = 30

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 16230, nodes: 13273958
Average node length: 5.78, total dup: 12865085, max dup: 38806
Average key length: 2.23, compression ratio: 4.04
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 1047666, ratio: 0.08
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 11911
60 - 79% = 2398
80 - 99% = 1916

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 16305, nodes: 13273958
Average node length: 5.62, total dup: 13247002, max dup: 1774520
Average key length: 2.07, compression ratio: 18.30
Average prefix length: 37.77, average data length: 0.07
Clustering factor: 7285210, ratio: 0.55
Fill distribution:
0 - 19% = 16
20 - 39% = 1
40 - 59% = 14084
60 - 79% = 636
80 - 99% = 1568

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

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

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

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

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

PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 55.10, total records: 434694
Average version length: 56.13, total versions: 896, 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: 5192
Data pages: 5192, average fill: 74%
Primary pages: 5192, secondary pages: 0, swept pages: 3592
Empty pages: 1, full pages: 4666
Fill distribution:
0 - 19% = 9
20 - 39% = 3
40 - 59% = 36
60 - 79% = 5142
80 - 99% = 2

Index PSTORNED_RCV_ID (2)
Root page: 733968, depth: 3, leaf buckets: 599, nodes: 434694
Average node length: 6.00, total dup: 361706, max dup: 688
Average key length: 3.22, compression ratio: 2.80
Average prefix length: 7.95, average data length: 1.05
Clustering factor: 52295, ratio: 0.12
Fill distribution:
0 - 19% = 11
20 - 39% = 25
40 - 59% = 401
60 - 79% = 124
80 - 99% = 38

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 474, nodes: 434694
Average node length: 5.59, total dup: 388014, max dup: 151
Average key length: 2.81, compression ratio: 3.21
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 99392, ratio: 0.23
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 219
60 - 79% = 173
80 - 99% = 75

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.65, total records: 3028
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.52
Pointer pages: 1, data page slots: 40
Data pages: 40, average fill: 69%
Primary pages: 40, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 36
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 1
60 - 79% = 36
80 - 99% = 0

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

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

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

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

Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

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

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

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

XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 50.41, total records: 6554
Average version length: 72.16, total versions: 1981, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.70
Pointer pages: 2, data page slots: 1784
Data pages: 432, average fill: 19%
Primary pages: 431, secondary pages: 1, swept pages: 204
Empty pages: 199, full pages: 50
Fill distribution:
0 - 19% = 309
20 - 39% = 35
40 - 59% = 22
60 - 79% = 57
80 - 99% = 9

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 18, nodes: 6554
Average node length: 7.06, total dup: 5676, max dup: 14
Average key length: 4.63, compression ratio: 8.00
Average prefix length: 34.50, average data length: 2.50
Clustering factor: 1074, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 13
40 - 59% = 3
60 - 79% = 1
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.92, total records: 1313570
Average version length: 71.97, total versions: 4871, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 13, data page slots: 19952
Data pages: 19952, average fill: 72%
Primary pages: 19952, secondary pages: 0, swept pages: 13325
Empty pages: 120, full pages: 14663
Fill distribution:
0 - 19% = 225
20 - 39% = 233
40 - 59% = 1208
60 - 79% = 18241
80 - 99% = 45

Index XQD_1000_3300_DOC (1)
Root page: 533927, depth: 3, leaf buckets: 1506, nodes: 1313570
Average node length: 5.13, total dup: 1279854, max dup: 120
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 144026, ratio: 0.11
Fill distribution:
0 - 19% = 17
20 - 39% = 61
40 - 59% = 1167
60 - 79% = 73
80 - 99% = 188

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 237816, depth: 3, leaf buckets: 1898, nodes: 1313570
Average node length: 6.26, total dup: 1147815, max dup: 15
Average key length: 3.31, compression ratio: 11.18
Average prefix length: 35.82, average data length: 1.18
Clustering factor: 248931, ratio: 0.19
Fill distribution:
0 - 19% = 13
20 - 39% = 159
40 - 59% = 1472
60 - 79% = 155
80 - 99% = 99

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 17.28, total records: 104422
Average version length: 71.95, total versions: 7903, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 7.87
Pointer pages: 4, data page slots: 5680
Data pages: 4592, average fill: 13%
Primary pages: 4590, secondary pages: 2, swept pages: 3771
Empty pages: 1027, full pages: 180
Fill distribution:
0 - 19% = 3721
20 - 39% = 470
40 - 59% = 145
60 - 79% = 148
80 - 99% = 108

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 47, nodes: 22735
Average node length: 6.48, total dup: 19758, max dup: 47
Average key length: 3.81, compression ratio: 9.72
Average prefix length: 35.32, average data length: 1.68
Clustering factor: 2388, ratio: 0.11
Fill distribution:
0 - 19% = 0
20 - 39% = 26
40 - 59% = 18
60 - 79% = 3
80 - 99% = 0

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 53.27, total records: 2891996
Average version length: 71.72, total versions: 40596, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.55
Pointer pages: 24, data page slots: 38272
Data pages: 38272, average fill: 67%
Primary pages: 38272, secondary pages: 0, swept pages: 19523
Empty pages: 231, full pages: 29343
Fill distribution:
0 - 19% = 538
20 - 39% = 4561
40 - 59% = 4112
60 - 79% = 26216
80 - 99% = 2845

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 197853, depth: 3, leaf buckets: 3388, nodes: 2072323
Average node length: 5.64, total dup: 1947317, max dup: 49
Average key length: 2.66, compression ratio: 13.91
Average prefix length: 36.40, average data length: 0.60
Clustering factor: 259356, ratio: 0.13
Fill distribution:
0 - 19% = 19
20 - 39% = 1618
40 - 59% = 1370
60 - 79% = 250
80 - 99% = 131

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.06, total records: 4477696
Average version length: 70.06, total versions: 1115, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.01
Pointer pages: 18, data page slots: 28128
Data pages: 28016, average fill: 51%
Primary pages: 28016, secondary pages: 0, swept pages: 10067
Empty pages: 55, full pages: 27019
Fill distribution:
0 - 19% = 226
20 - 39% = 8792
40 - 59% = 6893
60 - 79% = 12006
80 - 99% = 99

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 20, nodes: 5625
Average node length: 9.55, total dup: 4043, max dup: 16
Average key length: 6.55, compression ratio: 5.65
Average prefix length: 32.73, average data length: 4.27
Clustering factor: 1038, ratio: 0.18
Fill distribution:
0 - 19% = 1
20 - 39% = 15
40 - 59% = 4
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 63.10, total records: 3271739
Average version length: 71.19, total versions: 11818, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.16
Pointer pages: 27, data page slots: 42800
Data pages: 42800, average fill: 76%
Primary pages: 42800, secondary pages: 0, swept pages: 32092
Empty pages: 13, full pages: 37503
Fill distribution:
0 - 19% = 34
20 - 39% = 240
40 - 59% = 1210
60 - 79% = 38966
80 - 99% = 2350

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 6133, nodes: 2841534
Average node length: 6.90, total dup: 2291582, max dup: 14
Average key length: 3.93, compression ratio: 9.42
Average prefix length: 35.26, average data length: 1.74
Clustering factor: 525330, ratio: 0.18
Fill distribution:
0 - 19% = 3
20 - 39% = 3827
40 - 59% = 1895
60 - 79% = 240
80 - 99% = 168

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 84.02, total records: 5229550
Average version length: 84.57, total versions: 2252, 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: 50, data page slots: 80576
Data pages: 80576, average fill: 80%
Primary pages: 80576, secondary pages: 0, swept pages: 30241
Empty pages: 10, full pages: 79812
Fill distribution:
0 - 19% = 14
20 - 39% = 8
40 - 59% = 55
60 - 79% = 22564
80 - 99% = 57935

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 5354, nodes: 5229550
Average node length: 5.16, total dup: 5110342, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 837469, ratio: 0.16
Fill distribution:
0 - 19% = 22
20 - 39% = 110
40 - 59% = 2329
60 - 79% = 2255
80 - 99% = 638

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 5773, nodes: 5229550
Average node length: 5.69, total dup: 4682163, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 271030, ratio: 0.05
Fill distribution:
0 - 19% = 50
20 - 39% = 171
40 - 59% = 3343
60 - 79% = 360
80 - 99% = 1849

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5955, nodes: 5229550
Average node length: 5.80, total dup: 4575464, max dup: 22
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.31, average data length: 0.69
Clustering factor: 897006, ratio: 0.17
Fill distribution:
0 - 19% = 26
20 - 39% = 136
40 - 59% = 2558
60 - 79% = 2376
80 - 99% = 859

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 83.27, total records: 2615261
Average version length: 83.91, total versions: 9820, 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: 26, data page slots: 41288
Data pages: 41288, average fill: 78%
Primary pages: 41288, secondary pages: 0, swept pages: 30970
Empty pages: 22, full pages: 38117
Fill distribution:
0 - 19% = 61
20 - 39% = 123
40 - 59% = 615
60 - 79% = 18423
80 - 99% = 22066

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2836, nodes: 2615261
Average node length: 5.15, total dup: 2553805, max dup: 166
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 429259, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 80
40 - 59% = 1664
60 - 79% = 863
80 - 99% = 228

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4422, nodes: 2615261
Average node length: 6.25, total dup: 2135143, max dup: 14
Average key length: 3.28, compression ratio: 2.74
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 253047, ratio: 0.10
Fill distribution:
0 - 19% = 122
20 - 39% = 1778
40 - 59% = 1645
60 - 79% = 593
80 - 99% = 284

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 3196, nodes: 2615261
Average node length: 5.81, total dup: 2287374, max dup: 30
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 510359, ratio: 0.20
Fill distribution:
0 - 19% = 16
20 - 39% = 63
40 - 59% = 1926
60 - 79% = 891
80 - 99% = 300

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.85, total records: 5568312
Average version length: 85.59, total versions: 20371, 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: 54, data page slots: 87216
Data pages: 87176, average fill: 79%
Primary pages: 87176, secondary pages: 0, swept pages: 24640
Empty pages: 258, full pages: 82708
Fill distribution:
0 - 19% = 450
20 - 39% = 607
40 - 59% = 1270
60 - 79% = 18002
80 - 99% = 66847

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5856, nodes: 5568312
Average node length: 5.04, total dup: 5535545, max dup: 695
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 858685, ratio: 0.15
Fill distribution:
0 - 19% = 8
20 - 39% = 268
40 - 59% = 3201
60 - 79% = 1772
80 - 99% = 607

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 6841, nodes: 5568312
Average node length: 5.52, total dup: 5138424, max dup: 49
Average key length: 2.53, compression ratio: 3.56
Average prefix length: 8.55, average data length: 0.45
Clustering factor: 316968, ratio: 0.06
Fill distribution:
0 - 19% = 97
20 - 39% = 1700
40 - 59% = 2962
60 - 79% = 742
80 - 99% = 1340

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 6557, nodes: 5568312
Average node length: 5.68, total dup: 4996742, max dup: 81
Average key length: 2.69, compression ratio: 3.34
Average prefix length: 8.41, average data length: 0.59
Clustering factor: 942600, ratio: 0.17
Fill distribution:
0 - 19% = 7
20 - 39% = 239
40 - 59% = 3625
60 - 79% = 1952
80 - 99% = 734

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

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

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

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

XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.59, total records: 3519069
Average version length: 84.23, total versions: 7365, 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: 35, data page slots: 55512
Data pages: 55512, average fill: 78%
Primary pages: 55512, secondary pages: 0, swept pages: 41031
Empty pages: 40, full pages: 51320
Fill distribution:
0 - 19% = 78
20 - 39% = 149
40 - 59% = 778
60 - 79% = 23278
80 - 99% = 31229

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3907, nodes: 3519069
Average node length: 5.03, total dup: 3501763, max dup: 1127
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 724430, ratio: 0.21
Fill distribution:
0 - 19% = 20
20 - 39% = 477
40 - 59% = 2114
60 - 79% = 908
80 - 99% = 388

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 6017, nodes: 3519069
Average node length: 6.27, total dup: 2868503, max dup: 14
Average key length: 3.29, compression ratio: 2.74
Average prefix length: 7.90, average data length: 1.10
Clustering factor: 380763, ratio: 0.11
Fill distribution:
0 - 19% = 189
20 - 39% = 2540
40 - 59% = 2130
60 - 79% = 687
80 - 99% = 471

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4297, nodes: 3519069
Average node length: 5.58, total dup: 3212072, max dup: 83
Average key length: 2.60, compression ratio: 3.46
Average prefix length: 8.48, average data length: 0.52
Clustering factor: 770432, ratio: 0.22
Fill distribution:
0 - 19% = 19
20 - 39% = 502
40 - 59% = 2263
60 - 79% = 1050
80 - 99% = 463

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.44, total records: 683617
Average version length: 69.26, total versions: 1629, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.96
Pointer pages: 6, data page slots: 9472
Data pages: 9472, average fill: 77%
Primary pages: 9472, secondary pages: 0, swept pages: 6989
Empty pages: 29, full pages: 9064
Fill distribution:
0 - 19% = 42
20 - 39% = 25
40 - 59% = 70
60 - 79% = 9298
80 - 99% = 37

Index XQS_3300_3400_DOC_ID (0)
Root page: 98623, depth: 3, leaf buckets: 792, nodes: 683617
Average node length: 5.36, total dup: 640882, max dup: 113
Average key length: 2.47, compression ratio: 3.64
Average prefix length: 8.59, average data length: 0.41
Clustering factor: 61388, ratio: 0.09
Fill distribution:
0 - 19% = 1
20 - 39% = 141
40 - 59% = 336
60 - 79% = 220
80 - 99% = 94

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 887, nodes: 683617
Average node length: 5.95, total dup: 581914, max dup: 29
Average key length: 3.07, compression ratio: 2.93
Average prefix length: 8.08, average data length: 0.92
Clustering factor: 66433, ratio: 0.10
Fill distribution:
0 - 19% = 2
20 - 39% = 154
40 - 59% = 389
60 - 79% = 231
80 - 99% = 111

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Done for 193850 ms, from 11:48:26.22 to 11:51:40.07.

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 2351258 4874 0.2072
DOC_LIST 716774 1532 0.2137
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 8064 7588 94.0972
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 500 388 77.6000
OPTYPES 9 0 0.0000
PDISTR 932880 784 0.0840
PERF_ESTIMATED 316458 0 0.0000
PERF_LOG 13273958 0 0.0000
PSTORNED 434694 896 0.2061
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 0 0.0000
SETTINGS 114 0 0.0000
TRACE_STAT 3028 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 6554 1981 30.2258
XQD_1000_3300 1313570 4871 0.3708
XQD_1200_2000 104422 7903 7.5683
XQD_2000_3300 2891996 40596 1.4037
XQD_2100_3300 4477696 1115 0.0249
XQD_3300_3400 3271739 11818 0.3612
XQS_1000_1200 5229550 2252 0.0430
XQS_1000_3300 2615261 9820 0.3754
XQS_1200_2000 5568312 20371 0.3658
XQS_2100_3300 3519069 7365 0.2092
XQS_3300_3400 683617 1629 0.2382
Z_USED_VIEWS 29 0 0.0000
Done for 2650 ms, from 11:51:51.14 to 11:51:53.79.

Database validation

11:51:54.06 Validation started

11:51:54.09 Relation 140 (DOC_LIST)
11:51:54.09 process pointer page 0 of 6
11:51:54.20 process pointer page 1 of 6
11:51:54.29 process pointer page 2 of 6
11:51:54.40 process pointer page 3 of 6
11:51:54.50 process pointer page 4 of 6
11:51:54.59 process pointer page 5 of 6
11:51:54.61 Index 1 (PK_DOC_LIST)
11:51:54.73 Index 2 (DOC_LIST_ID_DESC)
11:51:54.87 Index 3 (FK_DOC_LIST_AGENTS)
11:51:55.17 Relation 140 (DOC_LIST) is ok

11:51:55.17 Relation 141 (DOC_DATA)
11:51:55.17 process pointer page 0 of 16
11:51:55.26 process pointer page 1 of 16
11:51:55.35 process pointer page 2 of 16
11:51:55.45 process pointer page 3 of 16
11:51:55.54 process pointer page 4 of 16
11:51:55.64 process pointer page 5 of 16
11:51:55.73 process pointer page 6 of 16
11:51:55.82 process pointer page 7 of 16
11:51:55.92 process pointer page 8 of 16
11:51:56.01 process pointer page 9 of 16
11:51:56.10 process pointer page 10 of 16
11:51:56.20 process pointer page 11 of 16
11:51:56.29 process pointer page 12 of 16
11:51:56.38 process pointer page 13 of 16
11:51:56.48 process pointer page 14 of 16
11:51:56.57 process pointer page 15 of 16
11:51:56.63 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:51:57.84 Index 3 (DOC_DATA_ID_DESC)
11:51:58.66 Index 4 (FK_DOC_DATA_DOC_LIST)
11:51:59.46 Relation 141 (DOC_DATA) is ok

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

11:51:59.47 Relation 150 (PDISTR)
11:51:59.47 process pointer page 0 of 4
11:51:59.55 process pointer page 1 of 4
11:51:59.64 process pointer page 2 of 4
11:51:59.69 process pointer page 3 of 4
11:51:59.72 Index 2 (PDISTR_SND_ID)
11:51:59.83 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:51:59.96 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:52:00.07 Index 5 (PDISTR_AGENT_ID)
11:52:00.18 Relation 150 (PDISTR) is ok

11:52:00.18 Relation 151 (PSTORNED)
11:52:00.18 process pointer page 0 of 4
11:52:00.27 process pointer page 1 of 4
11:52:00.36 process pointer page 2 of 4
11:52:00.46 process pointer page 3 of 4
11:52:00.47 Index 2 (PSTORNED_SND_ID)
11:52:00.61 Index 3 (PSTORNED_RCV_ID)
11:52:00.74 Relation 151 (PSTORNED) is ok

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

11:52:00.74 Relation 157 (INVNT_TURNOVER_LOG)
11:52:00.74 process pointer page 0 of 2
11:52:00.77 process pointer page 1 of 2
11:52:00.77 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:52:00.77 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:52:00.77 Relation 160 (PERF_ESTIMATED)
11:52:00.77 process pointer page 0 of 2
11:52:00.86 process pointer page 1 of 2
11:52:00.94 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:52:01.02 Relation 160 (PERF_ESTIMATED) is ok

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

11:52:01.02 Relation 162 (TRACE_STAT)
11:52:01.02 process pointer page 0 of 1
11:52:01.03 Relation 162 (TRACE_STAT) is ok

11:52:01.03 Relation 163 (PERF_LOG)
11:52:01.03 process pointer page 0 of 194
11:52:01.11 process pointer page 1 of 194
11:52:01.19 process pointer page 2 of 194
11:52:01.24 process pointer page 3 of 194
11:52:01.27 process pointer page 4 of 194
11:52:01.30 process pointer page 5 of 194
11:52:01.35 process pointer page 6 of 194
11:52:01.38 process pointer page 7 of 194
11:52:01.41 process pointer page 8 of 194
11:52:01.47 process pointer page 9 of 194
11:52:01.53 process pointer page 10 of 194
11:52:01.56 process pointer page 11 of 194
11:52:01.59 process pointer page 12 of 194
11:52:01.63 process pointer page 13 of 194
11:52:01.66 process pointer page 14 of 194
11:52:01.74 process pointer page 15 of 194
11:52:01.81 process pointer page 16 of 194
11:52:01.91 process pointer page 17 of 194
11:52:01.98 process pointer page 18 of 194
11:52:02.08 process pointer page 19 of 194
11:52:02.16 process pointer page 20 of 194
11:52:02.23 process pointer page 21 of 194
11:52:02.31 process pointer page 22 of 194
11:52:02.41 process pointer page 23 of 194
11:52:02.48 process pointer page 24 of 194
11:52:02.56 process pointer page 25 of 194
11:52:02.66 process pointer page 26 of 194
11:52:02.73 process pointer page 27 of 194
11:52:02.81 process pointer page 28 of 194
11:52:02.89 process pointer page 29 of 194
11:52:02.98 process pointer page 30 of 194
11:52:03.06 process pointer page 31 of 194
11:52:03.14 process pointer page 32 of 194
11:52:03.23 process pointer page 33 of 194
11:52:03.31 process pointer page 34 of 194
11:52:03.39 process pointer page 35 of 194
11:52:03.47 process pointer page 36 of 194
11:52:03.50 process pointer page 37 of 194
11:52:03.53 process pointer page 38 of 194
11:52:03.56 process pointer page 39 of 194
11:52:03.59 process pointer page 40 of 194
11:52:03.64 process pointer page 41 of 194
11:52:03.72 process pointer page 42 of 194
11:52:03.81 process pointer page 43 of 194
11:52:03.89 process pointer page 44 of 194
11:52:03.97 process pointer page 45 of 194
11:52:04.04 process pointer page 46 of 194
11:52:04.12 process pointer page 47 of 194
11:52:04.22 process pointer page 48 of 194
11:52:04.29 process pointer page 49 of 194
11:52:04.37 process pointer page 50 of 194
11:52:04.47 process pointer page 51 of 194
11:52:04.50 process pointer page 52 of 194
11:52:04.53 process pointer page 53 of 194
11:52:04.61 process pointer page 54 of 194
11:52:04.64 process pointer page 55 of 194
11:52:04.68 process pointer page 56 of 194
11:52:04.71 process pointer page 57 of 194
11:52:04.75 process pointer page 58 of 194
11:52:04.78 process pointer page 59 of 194
11:52:04.86 process pointer page 60 of 194
11:52:04.93 process pointer page 61 of 194
11:52:05.03 process pointer page 62 of 194
11:52:05.10 process pointer page 63 of 194
11:52:05.14 process pointer page 64 of 194
11:52:05.17 process pointer page 65 of 194
11:52:05.20 process pointer page 66 of 194
11:52:05.28 process pointer page 67 of 194
11:52:05.35 process pointer page 68 of 194
11:52:05.45 process pointer page 69 of 194
11:52:05.53 process pointer page 70 of 194
11:52:05.60 process pointer page 71 of 194
11:52:05.68 process pointer page 72 of 194
11:52:05.78 process pointer page 73 of 194
11:52:05.85 process pointer page 74 of 194
11:52:05.93 process pointer page 75 of 194
11:52:06.03 process pointer page 76 of 194
11:52:06.10 process pointer page 77 of 194
11:52:06.18 process pointer page 78 of 194
11:52:06.27 process pointer page 79 of 194
11:52:06.35 process pointer page 80 of 194
11:52:06.43 process pointer page 81 of 194
11:52:06.52 process pointer page 82 of 194
11:52:06.60 process pointer page 83 of 194
11:52:06.68 process pointer page 84 of 194
11:52:06.76 process pointer page 85 of 194
11:52:06.84 process pointer page 86 of 194
11:52:06.93 process pointer page 87 of 194
11:52:07.01 process pointer page 88 of 194
11:52:07.09 process pointer page 89 of 194
11:52:07.16 process pointer page 90 of 194
11:52:07.26 process pointer page 91 of 194
11:52:07.34 process pointer page 92 of 194
11:52:07.43 process pointer page 93 of 194
11:52:07.51 process pointer page 94 of 194
11:52:07.59 process pointer page 95 of 194
11:52:07.68 process pointer page 96 of 194
11:52:07.76 process pointer page 97 of 194
11:52:07.79 process pointer page 98 of 194
11:52:07.85 process pointer page 99 of 194
11:52:07.93 process pointer page 100 of 194
11:52:08.02 process pointer page 101 of 194
11:52:08.10 process pointer page 102 of 194
11:52:08.18 process pointer page 103 of 194
11:52:08.27 process pointer page 104 of 194
11:52:08.35 process pointer page 105 of 194
11:52:08.43 process pointer page 106 of 194
11:52:08.51 process pointer page 107 of 194
11:52:08.58 process pointer page 108 of 194
11:52:08.68 process pointer page 109 of 194
11:52:08.76 process pointer page 110 of 194
11:52:08.83 process pointer page 111 of 194
11:52:08.93 process pointer page 112 of 194
11:52:09.01 process pointer page 113 of 194
11:52:09.08 process pointer page 114 of 194
11:52:09.18 process pointer page 115 of 194
11:52:09.25 process pointer page 116 of 194
11:52:09.33 process pointer page 117 of 194
11:52:09.43 process pointer page 118 of 194
11:52:09.50 process pointer page 119 of 194
11:52:09.58 process pointer page 120 of 194
11:52:09.68 process pointer page 121 of 194
11:52:09.75 process pointer page 122 of 194
11:52:09.83 process pointer page 123 of 194
11:52:09.91 process pointer page 124 of 194
11:52:10.00 process pointer page 125 of 194
11:52:10.08 process pointer page 126 of 194
11:52:10.16 process pointer page 127 of 194
11:52:10.25 process pointer page 128 of 194
11:52:10.33 process pointer page 129 of 194
11:52:10.41 process pointer page 130 of 194
11:52:10.50 process pointer page 131 of 194
11:52:10.58 process pointer page 132 of 194
11:52:10.66 process pointer page 133 of 194
11:52:10.72 process pointer page 134 of 194
11:52:10.75 process pointer page 135 of 194
11:52:10.78 process pointer page 136 of 194
11:52:10.83 process pointer page 137 of 194
11:52:10.86 process pointer page 138 of 194
11:52:10.92 process pointer page 139 of 194
11:52:11.00 process pointer page 140 of 194
11:52:11.08 process pointer page 141 of 194
11:52:11.17 process pointer page 142 of 194
11:52:11.25 process pointer page 143 of 194
11:52:11.33 process pointer page 144 of 194
11:52:11.41 process pointer page 145 of 194
11:52:11.50 process pointer page 146 of 194
11:52:11.58 process pointer page 147 of 194
11:52:11.66 process pointer page 148 of 194
11:52:11.75 process pointer page 149 of 194
11:52:11.81 process pointer page 150 of 194
11:52:11.84 process pointer page 151 of 194
11:52:11.88 process pointer page 152 of 194
11:52:11.91 process pointer page 153 of 194
11:52:11.94 process pointer page 154 of 194
11:52:12.00 process pointer page 155 of 194
11:52:12.09 process pointer page 156 of 194
11:52:12.17 process pointer page 157 of 194
11:52:12.25 process pointer page 158 of 194
11:52:12.34 process pointer page 159 of 194
11:52:12.42 process pointer page 160 of 194
11:52:12.50 process pointer page 161 of 194
11:52:12.58 process pointer page 162 of 194
11:52:12.67 process pointer page 163 of 194
11:52:12.75 process pointer page 164 of 194
11:52:12.83 process pointer page 165 of 194
11:52:12.92 process pointer page 166 of 194
11:52:13.00 process pointer page 167 of 194
11:52:13.08 process pointer page 168 of 194
11:52:13.17 process pointer page 169 of 194
11:52:13.25 process pointer page 170 of 194
11:52:13.33 process pointer page 171 of 194
11:52:13.42 process pointer page 172 of 194
11:52:13.50 process pointer page 173 of 194
11:52:13.58 process pointer page 174 of 194
11:52:13.61 process pointer page 175 of 194
11:52:13.64 process pointer page 176 of 194
11:52:13.67 process pointer page 177 of 194
11:52:13.70 process pointer page 178 of 194
11:52:13.76 process pointer page 179 of 194
11:52:13.86 process pointer page 180 of 194
11:52:13.93 process pointer page 181 of 194
11:52:14.01 process pointer page 182 of 194
11:52:14.09 process pointer page 183 of 194
11:52:14.17 process pointer page 184 of 194
11:52:14.25 process pointer page 185 of 194
11:52:14.34 process pointer page 186 of 194
11:52:14.42 process pointer page 187 of 194
11:52:14.50 process pointer page 188 of 194
11:52:14.59 process pointer page 189 of 194
11:52:14.67 process pointer page 190 of 194
11:52:14.75 process pointer page 191 of 194
11:52:14.82 process pointer page 192 of 194
11:52:14.92 process pointer page 193 of 194
11:52:14.92 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:52:19.25 Index 2 (PERF_LOG_UNIT)
11:52:25.43 Index 3 (PERF_LOG_TRN_DESC)
11:52:28.97 Index 4 (PERF_LOG_GDSCODE)
11:52:31.31 Relation 163 (PERF_LOG) is ok

11:52:31.31 Relation 167 (V_STOPTEST)
11:52:31.31 Relation 167 (V_STOPTEST) is ok

11:52:31.31 Relation 184 (V_QDISTR_SOURCE)
11:52:31.31 Relation 184 (V_QDISTR_SOURCE) is ok

11:52:31.31 Relation 185 (V_QSTORNED_SOURCE)
11:52:31.31 Relation 185 (V_QSTORNED_SOURCE) is ok

11:52:31.31 Relation 260 (XQD_1000_1200)
11:52:31.33 process pointer page 0 of 2
11:52:31.33 process pointer page 1 of 2
11:52:31.34 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:52:31.34 Relation 260 (XQD_1000_1200) is ok

11:52:31.34 Relation 261 (XQD_1200_2000)
11:52:31.34 process pointer page 0 of 4
11:52:31.41 process pointer page 1 of 4
11:52:31.45 process pointer page 2 of 4
11:52:31.50 process pointer page 3 of 4
11:52:31.52 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:52:31.53 Relation 261 (XQD_1200_2000) is ok

11:52:31.53 Relation 262 (XQD_1000_3300)
11:52:31.53 process pointer page 0 of 13
11:52:31.63 process pointer page 1 of 13
11:52:31.72 process pointer page 2 of 13
11:52:31.80 process pointer page 3 of 13
11:52:31.89 process pointer page 4 of 13
11:52:31.98 process pointer page 5 of 13
11:52:32.06 process pointer page 6 of 13
11:52:32.17 process pointer page 7 of 13
11:52:32.25 process pointer page 8 of 13
11:52:32.34 process pointer page 9 of 13
11:52:32.39 process pointer page 10 of 13
11:52:32.47 process pointer page 11 of 13
11:52:32.50 process pointer page 12 of 13
11:52:32.50 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:52:32.89 Index 2 (XQD_1000_3300_DOC)
11:52:33.28 Relation 262 (XQD_1000_3300) is ok

11:52:33.28 Relation 263 (XQD_2000_3300)
11:52:33.28 process pointer page 0 of 24
11:52:33.36 process pointer page 1 of 24
11:52:33.42 process pointer page 2 of 24
11:52:33.47 process pointer page 3 of 24
11:52:33.50 process pointer page 4 of 24
11:52:33.56 process pointer page 5 of 24
11:52:33.64 process pointer page 6 of 24
11:52:33.73 process pointer page 7 of 24
11:52:33.82 process pointer page 8 of 24
11:52:33.92 process pointer page 9 of 24
11:52:34.00 process pointer page 10 of 24
11:52:34.09 process pointer page 11 of 24
11:52:34.18 process pointer page 12 of 24
11:52:34.28 process pointer page 13 of 24
11:52:34.37 process pointer page 14 of 24
11:52:34.40 process pointer page 15 of 24
11:52:34.48 process pointer page 16 of 24
11:52:34.57 process pointer page 17 of 24
11:52:34.67 process pointer page 18 of 24
11:52:34.70 process pointer page 19 of 24
11:52:34.73 process pointer page 20 of 24
11:52:34.76 process pointer page 21 of 24
11:52:34.84 process pointer page 22 of 24
11:52:34.93 process pointer page 23 of 24
11:52:34.98 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:52:35.65 Relation 263 (XQD_2000_3300) is ok

11:52:35.65 Relation 264 (XQD_2100_3300)
11:52:35.67 process pointer page 0 of 18
11:52:35.73 process pointer page 1 of 18
11:52:35.81 process pointer page 2 of 18
11:52:35.87 process pointer page 3 of 18
11:52:35.95 process pointer page 4 of 18
11:52:36.01 process pointer page 5 of 18
11:52:36.07 process pointer page 6 of 18
11:52:36.15 process pointer page 7 of 18
11:52:36.18 process pointer page 8 of 18
11:52:36.21 process pointer page 9 of 18
11:52:36.23 process pointer page 10 of 18
11:52:36.26 process pointer page 11 of 18
11:52:36.32 process pointer page 12 of 18
11:52:36.38 process pointer page 13 of 18
11:52:36.46 process pointer page 14 of 18
11:52:36.52 process pointer page 15 of 18
11:52:36.59 process pointer page 16 of 18
11:52:36.65 process pointer page 17 of 18
11:52:36.66 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:52:36.66 Relation 264 (XQD_2100_3300) is ok

11:52:36.66 Relation 265 (XQD_3300_3400)
11:52:36.66 process pointer page 0 of 27
11:52:36.76 process pointer page 1 of 27
11:52:36.85 process pointer page 2 of 27
11:52:36.94 process pointer page 3 of 27
11:52:37.04 process pointer page 4 of 27
11:52:37.13 process pointer page 5 of 27
11:52:37.23 process pointer page 6 of 27
11:52:37.32 process pointer page 7 of 27
11:52:37.41 process pointer page 8 of 27
11:52:37.51 process pointer page 9 of 27
11:52:37.60 process pointer page 10 of 27
11:52:37.69 process pointer page 11 of 27
11:52:37.79 process pointer page 12 of 27
11:52:37.83 process pointer page 13 of 27
11:52:37.88 process pointer page 14 of 27
11:52:37.91 process pointer page 15 of 27
11:52:37.99 process pointer page 16 of 27
11:52:38.08 process pointer page 17 of 27
11:52:38.18 process pointer page 18 of 27
11:52:38.27 process pointer page 19 of 27
11:52:38.36 process pointer page 20 of 27
11:52:38.46 process pointer page 21 of 27
11:52:38.55 process pointer page 22 of 27
11:52:38.65 process pointer page 23 of 27
11:52:38.74 process pointer page 24 of 27
11:52:38.83 process pointer page 25 of 27
11:52:38.94 process pointer page 26 of 27
11:52:38.96 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:52:40.03 Relation 265 (XQD_3300_3400) is ok

11:52:40.03 Relation 266 (XQS_1000_1200)
11:52:40.03 process pointer page 0 of 50
11:52:40.13 process pointer page 1 of 50
11:52:40.22 process pointer page 2 of 50
11:52:40.31 process pointer page 3 of 50
11:52:40.41 process pointer page 4 of 50
11:52:40.50 process pointer page 5 of 50
11:52:40.55 process pointer page 6 of 50
11:52:40.58 process pointer page 7 of 50
11:52:40.61 process pointer page 8 of 50
11:52:40.64 process pointer page 9 of 50
11:52:40.69 process pointer page 10 of 50
11:52:40.72 process pointer page 11 of 50
11:52:40.77 process pointer page 12 of 50
11:52:40.78 process pointer page 13 of 50
11:52:40.84 process pointer page 14 of 50
11:52:40.95 process pointer page 15 of 50
11:52:41.06 process pointer page 16 of 50
11:52:41.16 process pointer page 17 of 50
11:52:41.27 process pointer page 18 of 50
11:52:41.38 process pointer page 19 of 50
11:52:41.48 process pointer page 20 of 50
11:52:41.58 process pointer page 21 of 50
11:52:41.69 process pointer page 22 of 50
11:52:41.80 process pointer page 23 of 50
11:52:41.86 process pointer page 24 of 50
11:52:41.94 process pointer page 25 of 50
11:52:42.19 process pointer page 26 of 50
11:52:42.45 process pointer page 27 of 50
11:52:42.76 process pointer page 28 of 50
11:52:43.04 process pointer page 29 of 50
11:52:43.37 process pointer page 30 of 50
11:52:43.64 process pointer page 31 of 50
11:52:43.96 process pointer page 32 of 50
11:52:44.25 process pointer page 33 of 50
11:52:44.53 process pointer page 34 of 50
11:52:44.84 process pointer page 35 of 50
11:52:45.15 process pointer page 36 of 50
11:52:45.43 process pointer page 37 of 50
11:52:45.76 process pointer page 38 of 50
11:52:46.13 process pointer page 39 of 50
11:52:46.46 process pointer page 40 of 50
11:52:46.80 process pointer page 41 of 50
11:52:47.15 process pointer page 42 of 50
11:52:47.51 process pointer page 43 of 50
11:52:47.85 process pointer page 44 of 50
11:52:48.19 process pointer page 45 of 50
11:52:48.54 process pointer page 46 of 50
11:52:48.86 process pointer page 47 of 50
11:52:49.19 process pointer page 48 of 50
11:52:49.50 process pointer page 49 of 50
11:52:49.61 Index 1 (XQS_1000_1200_DOC_ID)
11:52:52.23 Index 2 (XQS_1000_1200_SND_ID)
11:52:54.85 Index 3 (XQS_1000_1200_RCV_ID)
11:52:56.87 Relation 266 (XQS_1000_1200) is ok

11:52:56.87 Relation 267 (XQS_1200_2000)
11:52:56.87 process pointer page 0 of 54
11:52:57.24 process pointer page 1 of 54
11:52:57.58 process pointer page 2 of 54
11:52:57.99 process pointer page 3 of 54
11:52:58.43 process pointer page 4 of 54
11:52:58.85 process pointer page 5 of 54
11:52:59.27 process pointer page 6 of 54
11:52:59.69 process pointer page 7 of 54
11:53:00.13 process pointer page 8 of 54
11:53:00.55 process pointer page 9 of 54
11:53:00.97 process pointer page 10 of 54
11:53:01.42 process pointer page 11 of 54
11:53:01.86 process pointer page 12 of 54
11:53:02.31 process pointer page 13 of 54
11:53:02.78 process pointer page 14 of 54
11:53:03.26 process pointer page 15 of 54
11:53:03.73 process pointer page 16 of 54
11:53:04.20 process pointer page 17 of 54
11:53:04.68 process pointer page 18 of 54
11:53:05.15 process pointer page 19 of 54
11:53:05.63 process pointer page 20 of 54
11:53:06.10 process pointer page 21 of 54
11:53:06.57 process pointer page 22 of 54
11:53:07.05 process pointer page 23 of 54
11:53:07.54 process pointer page 24 of 54
11:53:08.00 process pointer page 25 of 54
11:53:08.47 process pointer page 26 of 54
11:53:08.91 process pointer page 27 of 54
11:53:09.36 process pointer page 28 of 54
11:53:09.81 process pointer page 29 of 54
11:53:10.27 process pointer page 30 of 54
11:53:10.73 process pointer page 31 of 54
11:53:11.20 process pointer page 32 of 54
11:53:11.67 process pointer page 33 of 54
11:53:12.11 process pointer page 34 of 54
11:53:12.54 process pointer page 35 of 54
11:53:12.98 process pointer page 36 of 54
11:53:13.43 process pointer page 37 of 54
11:53:13.87 process pointer page 38 of 54
11:53:14.32 process pointer page 39 of 54
11:53:14.76 process pointer page 40 of 54
11:53:15.20 process pointer page 41 of 54
11:53:15.66 process pointer page 42 of 54
11:53:16.10 process pointer page 43 of 54
11:53:16.52 process pointer page 44 of 54
11:53:16.97 process pointer page 45 of 54
11:53:17.41 process pointer page 46 of 54
11:53:17.83 process pointer page 47 of 54
11:53:18.25 process pointer page 48 of 54
11:53:18.71 process pointer page 49 of 54
11:53:19.14 process pointer page 50 of 54
11:53:19.61 process pointer page 51 of 54
11:53:20.02 process pointer page 52 of 54
11:53:20.39 process pointer page 53 of 54
11:53:20.55 Index 1 (XQS_1200_2000_DOC_ID)
11:53:23.45 Index 2 (XQS_1200_2000_SND_ID)
11:53:26.49 Index 3 (XQS_1200_2000_RCV_ID)
11:53:29.16 Relation 267 (XQS_1200_2000) is ok

11:53:29.16 Relation 268 (XQS_1000_3300)
11:53:29.16 process pointer page 0 of 26
11:53:29.64 process pointer page 1 of 26
11:53:30.13 process pointer page 2 of 26
11:53:30.61 process pointer page 3 of 26
11:53:31.09 process pointer page 4 of 26
11:53:31.58 process pointer page 5 of 26
11:53:32.06 process pointer page 6 of 26
11:53:32.54 process pointer page 7 of 26
11:53:33.03 process pointer page 8 of 26
11:53:33.49 process pointer page 9 of 26
11:53:33.96 process pointer page 10 of 26
11:53:34.45 process pointer page 11 of 26
11:53:34.93 process pointer page 12 of 26
11:53:35.41 process pointer page 13 of 26
11:53:35.88 process pointer page 14 of 26
11:53:36.35 process pointer page 15 of 26
11:53:36.83 process pointer page 16 of 26
11:53:37.29 process pointer page 17 of 26
11:53:37.74 process pointer page 18 of 26
11:53:38.17 process pointer page 19 of 26
11:53:38.64 process pointer page 20 of 26
11:53:39.08 process pointer page 21 of 26
11:53:39.53 process pointer page 22 of 26
11:53:39.95 process pointer page 23 of 26
11:53:40.37 process pointer page 24 of 26
11:53:40.73 process pointer page 25 of 26
11:53:40.83 Index 1 (XQS_1000_3300_DOC_ID)
11:53:42.29 Index 2 (XQS_1000_3300_SND_ID)
11:53:43.74 Index 3 (XQS_1000_3300_RCV_ID)
11:53:45.55 Relation 268 (XQS_1000_3300) is ok

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

11:53:45.55 Relation 270 (XQS_2100_3300)
11:53:45.55 process pointer page 0 of 35
11:53:46.04 process pointer page 1 of 35
11:53:46.52 process pointer page 2 of 35
11:53:47.00 process pointer page 3 of 35
11:53:47.49 process pointer page 4 of 35
11:53:47.96 process pointer page 5 of 35
11:53:48.46 process pointer page 6 of 35
11:53:48.94 process pointer page 7 of 35
11:53:49.42 process pointer page 8 of 35
11:53:49.91 process pointer page 9 of 35
11:53:50.39 process pointer page 10 of 35
11:53:50.86 process pointer page 11 of 35
11:53:51.33 process pointer page 12 of 35
11:53:51.81 process pointer page 13 of 35
11:53:52.29 process pointer page 14 of 35
11:53:52.78 process pointer page 15 of 35
11:53:53.23 process pointer page 16 of 35
11:53:53.70 process pointer page 17 of 35
11:53:54.16 process pointer page 18 of 35
11:53:54.65 process pointer page 19 of 35
11:53:55.12 process pointer page 20 of 35
11:53:55.58 process pointer page 21 of 35
11:53:56.02 process pointer page 22 of 35
11:53:56.46 process pointer page 23 of 35
11:53:56.91 process pointer page 24 of 35
11:53:57.35 process pointer page 25 of 35
11:53:57.78 process pointer page 26 of 35
11:53:58.22 process pointer page 27 of 35
11:53:58.66 process pointer page 28 of 35
11:53:59.09 process pointer page 29 of 35
11:53:59.52 process pointer page 30 of 35
11:53:59.94 process pointer page 31 of 35
11:54:00.34 process pointer page 32 of 35
11:54:00.76 process pointer page 33 of 35
11:54:01.12 process pointer page 34 of 35
11:54:01.12 Index 1 (XQS_2100_3300_DOC_ID)
11:54:03.34 Index 2 (XQS_2100_3300_SND_ID)
11:54:05.55 Index 3 (XQS_2100_3300_RCV_ID)
11:54:07.85 Relation 270 (XQS_2100_3300) is ok

11:54:07.85 Relation 271 (XQS_3300_3400)
11:54:07.85 process pointer page 0 of 6
11:54:08.33 process pointer page 1 of 6
11:54:08.81 process pointer page 2 of 6
11:54:09.30 process pointer page 3 of 6
11:54:09.80 process pointer page 4 of 6
11:54:10.25 process pointer page 5 of 6
11:54:10.58 Index 1 (XQS_3300_3400_DOC_ID)
11:54:10.97 Index 2 (XQS_3300_3400_SND_ID)
11:54:11.39 Relation 271 (XQS_3300_3400) is ok

11:54:11.42 Validation finished
Done for 137760 ms, from 11:51:53.83 to 11:54:11.59.

Differences between old and current firebird.log

11:54:13.73. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-02-07 11:54 509 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

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

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Tue Feb 07 11:51:54 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Tue Feb 07 11:54:11 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

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


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

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

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2017-02-07 11:54:25.08 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html

Subscribe to IBSurgeon news

Subscribe