|  ACTION  | 
 AVG_TIMES_PER_MINUTE  | 
 AVG_ELAPSED_MS  | 
 SUCCESSFUL_TIMES_DONE  | 
 JOB_BEG  | 
 JOB_END  | 
|  *** OVERALL *** for 180 minutes:  | 
 6474.47  | 
 2618  | 
 1165405  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  customer order: creation  | 
 456.79  | 
 376  | 
 82223  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  customer order: refuse  | 
 38.46  | 
 197  | 
 6923  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  order to supplier: creation  | 
 117.19  | 
 1572  | 
 21094  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  order to supplier: removal  | 
 3.19  | 
 15556  | 
 571  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  invoice (draft): creation  | 
 118.61  | 
 2367  | 
 21349  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  invoice (draft): removal  | 
 45.14  | 
 343  | 
 8126  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  invoice accept: apply  | 
 66.21  | 
 7979  | 
 11917  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  invoice accept: cancel  | 
 20.64  | 
 1898  | 
 3715  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  customer reserve: creation  | 
 3710.39  | 
 115  | 
 667871  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  customer reserve: removal  | 
 1263.29  | 
 44  | 
 227393  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  realization accept: apply  | 
 212.64  | 
 443  | 
 38276  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  realization accept: cancel  | 
 89.83  | 
 122  | 
 16170  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  payment from customer: creation  | 
 154.58  | 
 722  | 
 27825  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  payment from customer: removal  | 
 14.09  | 
 109  | 
 2537  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  payment to supplier: creation  | 
 126.52  | 
 373  | 
 22773  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  payment to supplier: removal  | 
 9.26  | 
 114  | 
 1667  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  service: total inventory turnovers  | 
 10.66  | 
 2019  | 
 1919  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  service: total monetary turnovers  | 
 16.92  | 
 54  | 
 3045  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  service: refresh index statistics  | 
 0.07  | 
 15331  | 
 11  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
 
Done for 78090 ms, from  6:50:26.53 to  6:51:44.62.  
 
|  ACTION  | 
 ITRV_NO  | 
 CNT_OK_PER_MINUTE  | 
 CNT_ALL  | 
 CNT_OK  | 
 CNT_ERR  | 
 ERR_PRC  | 
 ITRV_BEG  | 
 ITRV_END  | 
|  interval #   1, overall  | 
 1  | 
 4752  | 
 99143  | 
 85537  | 
 13606  | 
 13.72  | 
 03:46:46  | 
 04:04:46  | 
|  interval #   2, overall  | 
 2  | 
 6980  | 
 138590  | 
 125643  | 
 12947  | 
 9.34  | 
 04:04:47  | 
 04:22:47  | 
|  interval #   3, overall  | 
 3  | 
 6565  | 
 135092  | 
 118165  | 
 16927  | 
 12.53  | 
 04:22:48  | 
 04:40:48  | 
|  interval #   4, overall  | 
 4  | 
 6829  | 
 143517  | 
 122925  | 
 20592  | 
 14.35  | 
 04:40:49  | 
 04:58:49  | 
|  interval #   5, overall  | 
 5  | 
 6754  | 
 144495  | 
 121578  | 
 22917  | 
 15.86  | 
 04:58:50  | 
 05:16:50  | 
|  interval #   6, overall  | 
 6  | 
 7376  | 
 154713  | 
 132765  | 
 21948  | 
 14.19  | 
 05:16:51  | 
 05:34:51  | 
|  interval #   7, overall  | 
 7  | 
 6941  | 
 142297  | 
 124931  | 
 17366  | 
 12.20  | 
 05:34:52  | 
 05:52:52  | 
|  interval #   8, overall  | 
 8  | 
 6477  | 
 133676  | 
 116589  | 
 17087  | 
 12.78  | 
 05:52:53  | 
 06:10:53  | 
|  interval #   9, overall  | 
 9  | 
 6045  | 
 124552  | 
 108813  | 
 15739  | 
 12.64  | 
 06:10:54  | 
 06:28:54  | 
|  interval #  10, overall  | 
 10  | 
 6026  | 
 125042  | 
 108459  | 
 16583  | 
 13.26  | 
 06:28:55  | 
 06:46:55  | 
 
Done for 198750 ms, from  6:55:09.20 to  6:58:27.95.  
 
|  TEST_PHASE  | 
 MINUTE_SINCE_TEST_START  | 
 AVG_ESTIMATED  | 
 MIN_TO_AVG_RATIO  | 
 MAX_TO_AVG_RATIO  | 
 ROWS_AGGREGATED  | 
 DISTINCT_ATTACHMENTS  | 
|  TEST_TIME  | 
 1  | 
 2790.31  | 
 0.1311  | 
 1.8714  | 
 2588  | 
 25  | 
|  TEST_TIME  | 
 2  | 
 3118.25  | 
 0.8374  | 
 1.2001  | 
 1514  | 
 24  | 
|  TEST_TIME  | 
 3  | 
 2928.15  | 
 0.8521  | 
 1.1479  | 
 1338  | 
 25  | 
|  TEST_TIME  | 
 4  | 
 2743.26  | 
 0.9190  | 
 1.0842  | 
 854  | 
 21  | 
|  TEST_TIME  | 
 5  | 
 2816.10  | 
 0.8450  | 
 1.1030  | 
 1145  | 
 16  | 
|  TEST_TIME  | 
 6  | 
 2797.55  | 
 0.9253  | 
 1.0814  | 
 1023  | 
 26  | 
|  TEST_TIME  | 
 7  | 
 2799.16  | 
 0.9264  | 
 1.0735  | 
 1644  | 
 30  | 
|  TEST_TIME  | 
 8  | 
 2841.21  | 
 0.9254  | 
 1.0746  | 
 1590  | 
 25  | 
|  TEST_TIME  | 
 9  | 
 3051.69  | 
 0.8893  | 
 1.0899  | 
 1469  | 
 22  | 
|  TEST_TIME  | 
 10  | 
 3269.83  | 
 0.9155  | 
 1.0834  | 
 1674  | 
 26  | 
|  TEST_TIME  | 
 11  | 
 3455.66  | 
 0.9319  | 
 1.0764  | 
 1302  | 
 72  | 
|  TEST_TIME  | 
 12  | 
 3588.60  | 
 0.9503  | 
 1.0599  | 
 1494  | 
 100  | 
|  TEST_TIME  | 
 13  | 
 3740.18  | 
 0.9387  | 
 1.0541  | 
 1828  | 
 100  | 
|  TEST_TIME  | 
 14  | 
 3900.63  | 
 0.9386  | 
 1.0678  | 
 1726  | 
 100  | 
|  TEST_TIME  | 
 15  | 
 4088.68  | 
 0.9508  | 
 1.0556  | 
 2063  | 
 100  | 
|  TEST_TIME  | 
 16  | 
 4271.89  | 
 0.9472  | 
 1.0539  | 
 2233  | 
 100  | 
|  TEST_TIME  | 
 17  | 
 4476.58  | 
 0.9474  | 
 1.0517  | 
 2363  | 
 100  | 
|  TEST_TIME  | 
 18  | 
 4649.91  | 
 0.9563  | 
 1.0450  | 
 2047  | 
 100  | 
|  TEST_TIME  | 
 19  | 
 4798.11  | 
 0.9595  | 
 1.0429  | 
 1823  | 
 100  | 
|  TEST_TIME  | 
 20  | 
 4942.16  | 
 0.9619  | 
 1.0368  | 
 1927  | 
 100  | 
|  TEST_TIME  | 
 21  | 
 5062.16  | 
 0.9641  | 
 1.0324  | 
 1558  | 
 100  | 
|  TEST_TIME  | 
 22  | 
 5137.27  | 
 0.9710  | 
 1.0382  | 
 1655  | 
 100  | 
|  TEST_TIME  | 
 23  | 
 5245.95  | 
 0.9730  | 
 1.0256  | 
 1695  | 
 100  | 
|  TEST_TIME  | 
 24  | 
 5287.75  | 
 0.9759  | 
 1.0269  | 
 1518  | 
 100  | 
|  TEST_TIME  | 
 25  | 
 5330.47  | 
 0.9779  | 
 1.0183  | 
 1366  | 
 100  | 
|  TEST_TIME  | 
 26  | 
 5352.20  | 
 0.9752  | 
 1.0251  | 
 1464  | 
 100  | 
|  TEST_TIME  | 
 27  | 
 5371.62  | 
 0.9836  | 
 1.0205  | 
 1276  | 
 100  | 
|  TEST_TIME  | 
 28  | 
 5395.93  | 
 0.9797  | 
 1.0167  | 
 1308  | 
 100  | 
|  TEST_TIME  | 
 29  | 
 5382.54  | 
 0.9844  | 
 1.0157  | 
 1189  | 
 100  | 
|  TEST_TIME  | 
 30  | 
 5429.87  | 
 0.9733  | 
 1.0246  | 
 2361  | 
 100  | 
|  TEST_TIME  | 
 31  | 
 5520.36  | 
 0.9753  | 
 1.0269  | 
 2187  | 
 100  | 
|  TEST_TIME  | 
 32  | 
 5610.97  | 
 0.9788  | 
 1.0214  | 
 1917  | 
 100  | 
|  TEST_TIME  | 
 33  | 
 5669.30  | 
 0.9808  | 
 1.0172  | 
 1615  | 
 100  | 
|  TEST_TIME  | 
 34  | 
 5700.75  | 
 0.9819  | 
 1.0160  | 
 1433  | 
 100  | 
|  TEST_TIME  | 
 35  | 
 5728.60  | 
 0.9822  | 
 1.0195  | 
 1750  | 
 100  | 
|  TEST_TIME  | 
 36  | 
 5797.75  | 
 0.9794  | 
 1.0189  | 
 1677  | 
 100  | 
|  TEST_TIME  | 
 37  | 
 5816.88  | 
 0.9881  | 
 1.0155  | 
 1559  | 
 100  | 
|  TEST_TIME  | 
 38  | 
 5839.20  | 
 0.9850  | 
 1.0145  | 
 1381  | 
 100  | 
|  TEST_TIME  | 
 39  | 
 5850.41  | 
 0.9867  | 
 1.0123  | 
 1324  | 
 100  | 
|  TEST_TIME  | 
 40  | 
 5843.80  | 
 0.9882  | 
 1.0083  | 
 1236  | 
 100  | 
|  TEST_TIME  | 
 41  | 
 5810.59  | 
 0.9893  | 
 1.0122  | 
 1309  | 
 100  | 
|  TEST_TIME  | 
 42  | 
 5806.76  | 
 0.9887  | 
 1.0107  | 
 1295  | 
 100  | 
|  TEST_TIME  | 
 43  | 
 5787.36  | 
 0.9905  | 
 1.0112  | 
 1177  | 
 100  | 
|  TEST_TIME  | 
 44  | 
 5821.16  | 
 0.9825  | 
 1.0114  | 
 1199  | 
 100  | 
|  TEST_TIME  | 
 45  | 
 5848.74  | 
 0.9843  | 
 1.0088  | 
 2002  | 
 100  | 
|  TEST_TIME  | 
 46  | 
 5850.05  | 
 0.9867  | 
 1.0190  | 
 1797  | 
 100  | 
|  TEST_TIME  | 
 47  | 
 5920.00  | 
 0.9856  | 
 1.0105  | 
 1728  | 
 100  | 
|  TEST_TIME  | 
 48  | 
 5912.92  | 
 0.9907  | 
 1.0134  | 
 1665  | 
 100  | 
|  TEST_TIME  | 
 49  | 
 5916.31  | 
 0.9921  | 
 1.0163  | 
 1593  | 
 100  | 
|  TEST_TIME  | 
 50  | 
 5963.06  | 
 0.9882  | 
 1.0132  | 
 1361  | 
 100  | 
|  TEST_TIME  | 
 51  | 
 5997.05  | 
 0.9880  | 
 1.0111  | 
 1841  | 
 100  | 
|  TEST_TIME  | 
 52  | 
 6013.10  | 
 0.9890  | 
 1.0089  | 
 1803  | 
 100  | 
|  TEST_TIME  | 
 53  | 
 6055.96  | 
 0.9829  | 
 1.0100  | 
 1595  | 
 100  | 
|  TEST_TIME  | 
 54  | 
 6062.54  | 
 0.9902  | 
 1.0092  | 
 1576  | 
 100  | 
|  TEST_TIME  | 
 55  | 
 6077.24  | 
 0.9885  | 
 1.0129  | 
 1447  | 
 100  | 
|  TEST_TIME  | 
 56  | 
 6108.77  | 
 0.9897  | 
 1.0093  | 
 1453  | 
 100  | 
|  TEST_TIME  | 
 57  | 
 6108.37  | 
 0.9916  | 
 1.0125  | 
 1425  | 
 100  | 
|  TEST_TIME  | 
 58  | 
 6121.28  | 
 0.9931  | 
 1.0076  | 
 1382  | 
 100  | 
|  TEST_TIME  | 
 59  | 
 6114.32  | 
 0.9916  | 
 1.0074  | 
 1290  | 
 100  | 
|  TEST_TIME  | 
 60  | 
 6139.28  | 
 0.9866  | 
 1.0099  | 
 2164  | 
 100  | 
|  TEST_TIME  | 
 61  | 
 6180.00  | 
 0.9872  | 
 1.0128  | 
 2334  | 
 100  | 
|  TEST_TIME  | 
 62  | 
 6235.11  | 
 0.9876  | 
 1.0098  | 
 1727  | 
 100  | 
|  TEST_TIME  | 
 63  | 
 6275.41  | 
 0.9874  | 
 1.0106  | 
 1571  | 
 100  | 
|  TEST_TIME  | 
 64  | 
 6306.71  | 
 0.9900  | 
 1.0072  | 
 1587  | 
 100  | 
|  TEST_TIME  | 
 65  | 
 6290.96  | 
 0.9942  | 
 1.0045  | 
 1757  | 
 99  | 
|  TEST_TIME  | 
 66  | 
 6280.95  | 
 0.9952  | 
 1.0049  | 
 1545  | 
 98  | 
|  TEST_TIME  | 
 67  | 
 6288.09  | 
 0.9888  | 
 1.0064  | 
 1345  | 
 100  | 
|  TEST_TIME  | 
 68  | 
 6280.92  | 
 0.9928  | 
 1.0094  | 
 1487  | 
 100  | 
|  TEST_TIME  | 
 69  | 
 6295.89  | 
 0.9924  | 
 1.0060  | 
 1503  | 
 100  | 
|  TEST_TIME  | 
 70  | 
 6287.12  | 
 0.9930  | 
 1.0074  | 
 1558  | 
 100  | 
|  TEST_TIME  | 
 71  | 
 6278.67  | 
 0.9946  | 
 1.0033  | 
 1701  | 
 99  | 
|  TEST_TIME  | 
 72  | 
 6258.95  | 
 0.9925  | 
 1.0032  | 
 1171  | 
 100  | 
|  TEST_TIME  | 
 73  | 
 6248.93  | 
 0.9911  | 
 1.0045  | 
 1303  | 
 100  | 
|  TEST_TIME  | 
 74  | 
 6233.92  | 
 0.9933  | 
 1.0083  | 
 1315  | 
 100  | 
|  TEST_TIME  | 
 75  | 
 6273.60  | 
 0.9886  | 
 1.0134  | 
 2086  | 
 100  | 
|  TEST_TIME  | 
 76  | 
 6322.54  | 
 0.9923  | 
 1.0068  | 
 1741  | 
 100  | 
|  TEST_TIME  | 
 77  | 
 6351.94  | 
 0.9892  | 
 1.0092  | 
 1760  | 
 100  | 
|  TEST_TIME  | 
 78  | 
 6383.95  | 
 0.9912  | 
 1.0095  | 
 1590  | 
 100  | 
|  TEST_TIME  | 
 79  | 
 6418.03  | 
 0.9915  | 
 1.0089  | 
 1637  | 
 100  | 
|  TEST_TIME  | 
 80  | 
 6434.50  | 
 0.9938  | 
 1.0060  | 
 1667  | 
 100  | 
|  TEST_TIME  | 
 81  | 
 6437.37  | 
 0.9932  | 
 1.0062  | 
 1533  | 
 100  | 
|  TEST_TIME  | 
 82  | 
 6441.36  | 
 0.9939  | 
 1.0077  | 
 1414  | 
 100  | 
|  TEST_TIME  | 
 83  | 
 6430.61  | 
 0.9972  | 
 1.0034  | 
 1374  | 
 98  | 
|  TEST_TIME  | 
 84  | 
 6443.78  | 
 0.9895  | 
 1.0046  | 
 1083  | 
 100  | 
|  TEST_TIME  | 
 85  | 
 6407.93  | 
 0.9983  | 
 1.0028  | 
 1341  | 
 97  | 
|  TEST_TIME  | 
 86  | 
 6407.69  | 
 0.9947  | 
 1.0046  | 
 1157  | 
 100  | 
|  TEST_TIME  | 
 87  | 
 6389.79  | 
 0.9958  | 
 1.0051  | 
 1105  | 
 100  | 
|  TEST_TIME  | 
 88  | 
 6372.52  | 
 0.9964  | 
 1.0023  | 
 1314  | 
 100  | 
|  TEST_TIME  | 
 89  | 
 6348.73  | 
 0.9968  | 
 1.0025  | 
 1406  | 
 97  | 
|  TEST_TIME  | 
 90  | 
 6336.11  | 
 0.9933  | 
 1.0078  | 
 1396  | 
 100  | 
|  TEST_TIME  | 
 91  | 
 6367.74  | 
 0.9918  | 
 1.0071  | 
 1846  | 
 100  | 
|  TEST_TIME  | 
 92  | 
 6376.56  | 
 0.9948  | 
 1.0064  | 
 2053  | 
 100  | 
|  TEST_TIME  | 
 93  | 
 6378.07  | 
 0.9953  | 
 1.0041  | 
 1948  | 
 99  | 
|  TEST_TIME  | 
 94  | 
 6391.73  | 
 0.9913  | 
 1.0068  | 
 1540  | 
 100  | 
|  TEST_TIME  | 
 95  | 
 6424.45  | 
 0.9911  | 
 1.0083  | 
 1444  | 
 100  | 
|  TEST_TIME  | 
 96  | 
 6449.23  | 
 0.9940  | 
 1.0052  | 
 1708  | 
 100  | 
|  TEST_TIME  | 
 97  | 
 6455.93  | 
 0.9939  | 
 1.0054  | 
 1736  | 
 100  | 
|  TEST_TIME  | 
 98  | 
 6471.60  | 
 0.9927  | 
 1.0073  | 
 1358  | 
 100  | 
|  TEST_TIME  | 
 99  | 
 6488.97  | 
 0.9944  | 
 1.0053  | 
 1443  | 
 100  | 
|  TEST_TIME  | 
 100  | 
 6495.66  | 
 0.9942  | 
 1.0076  | 
 1276  | 
 100  | 
|  TEST_TIME  | 
 101  | 
 6509.22  | 
 0.9955  | 
 1.0046  | 
 1406  | 
 100  | 
|  TEST_TIME  | 
 102  | 
 6501.12  | 
 0.9959  | 
 1.0050  | 
 1341  | 
 100  | 
|  TEST_TIME  | 
 103  | 
 6498.89  | 
 0.9956  | 
 1.0062  | 
 1275  | 
 100  | 
|  TEST_TIME  | 
 104  | 
 6501.70  | 
 0.9963  | 
 1.0038  | 
 1279  | 
 100  | 
|  TEST_TIME  | 
 105  | 
 6495.53  | 
 0.9952  | 
 1.0053  | 
 1582  | 
 100  | 
|  TEST_TIME  | 
 106  | 
 6505.40  | 
 0.9946  | 
 1.0039  | 
 1791  | 
 100  | 
|  TEST_TIME  | 
 107  | 
 6502.26  | 
 0.9950  | 
 1.0076  | 
 1687  | 
 99  | 
|  TEST_TIME  | 
 108  | 
 6519.33  | 
 0.9958  | 
 1.0040  | 
 1576  | 
 100  | 
|  TEST_TIME  | 
 109  | 
 6513.14  | 
 0.9958  | 
 1.0049  | 
 1584  | 
 100  | 
|  TEST_TIME  | 
 110  | 
 6518.74  | 
 0.9950  | 
 1.0046  | 
 1799  | 
 100  | 
|  TEST_TIME  | 
 111  | 
 6523.39  | 
 0.9948  | 
 1.0071  | 
 1442  | 
 100  | 
|  TEST_TIME  | 
 112  | 
 6545.55  | 
 0.9950  | 
 1.0049  | 
 1404  | 
 100  | 
|  TEST_TIME  | 
 113  | 
 6563.68  | 
 0.9933  | 
 1.0039  | 
 1491  | 
 100  | 
|  TEST_TIME  | 
 114  | 
 6565.18  | 
 0.9948  | 
 1.0037  | 
 1284  | 
 100  | 
|  TEST_TIME  | 
 115  | 
 6550.11  | 
 0.9973  | 
 1.0041  | 
 1503  | 
 99  | 
|  TEST_TIME  | 
 116  | 
 6552.04  | 
 0.9959  | 
 1.0043  | 
 1449  | 
 100  | 
|  TEST_TIME  | 
 117  | 
 6550.54  | 
 0.9959  | 
 1.0034  | 
 1279  | 
 100  | 
|  TEST_TIME  | 
 118  | 
 6541.54  | 
 0.9963  | 
 1.0034  | 
 1274  | 
 100  | 
|  TEST_TIME  | 
 119  | 
 6566.30  | 
 0.9912  | 
 1.0033  | 
 1153  | 
 100  | 
|  TEST_TIME  | 
 120  | 
 6558.22  | 
 0.9964  | 
 1.0051  | 
 1493  | 
 100  | 
|  TEST_TIME  | 
 121  | 
 6569.23  | 
 0.9953  | 
 1.0041  | 
 2234  | 
 100  | 
|  TEST_TIME  | 
 122  | 
 6576.12  | 
 0.9965  | 
 1.0025  | 
 1888  | 
 98  | 
|  TEST_TIME  | 
 123  | 
 6575.56  | 
 0.9945  | 
 1.0052  | 
 1474  | 
 99  | 
|  TEST_TIME  | 
 124  | 
 6575.23  | 
 0.9972  | 
 1.0047  | 
 1631  | 
 97  | 
|  TEST_TIME  | 
 125  | 
 6578.48  | 
 0.9961  | 
 1.0022  | 
 1543  | 
 100  | 
|  TEST_TIME  | 
 126  | 
 6563.02  | 
 0.9965  | 
 1.0048  | 
 1624  | 
 97  | 
|  TEST_TIME  | 
 127  | 
 6567.64  | 
 0.9961  | 
 1.0036  | 
 1448  | 
 99  | 
|  TEST_TIME  | 
 128  | 
 6554.39  | 
 0.9978  | 
 1.0051  | 
 1479  | 
 96  | 
|  TEST_TIME  | 
 129  | 
 6553.77  | 
 0.9976  | 
 1.0023  | 
 1486  | 
 95  | 
|  TEST_TIME  | 
 130  | 
 6537.37  | 
 0.9971  | 
 1.0041  | 
 1328  | 
 95  | 
|  TEST_TIME  | 
 131  | 
 6528.25  | 
 0.9978  | 
 1.0020  | 
 1453  | 
 99  | 
|  TEST_TIME  | 
 132  | 
 6522.75  | 
 0.9952  | 
 1.0019  | 
 1444  | 
 97  | 
|  TEST_TIME  | 
 133  | 
 6509.62  | 
 0.9964  | 
 1.0039  | 
 1385  | 
 94  | 
|  TEST_TIME  | 
 134  | 
 6508.35  | 
 0.9966  | 
 1.0047  | 
 1311  | 
 99  | 
|  TEST_TIME  | 
 135  | 
 6522.57  | 
 0.9951  | 
 1.0059  | 
 1989  | 
 100  | 
|  TEST_TIME  | 
 136  | 
 6544.79  | 
 0.9952  | 
 1.0036  | 
 2036  | 
 100  | 
|  TEST_TIME  | 
 137  | 
 6579.47  | 
 0.9926  | 
 1.0056  | 
 1736  | 
 100  | 
|  TEST_TIME  | 
 138  | 
 6589.30  | 
 0.9968  | 
 1.0019  | 
 1774  | 
 100  | 
|  TEST_TIME  | 
 139  | 
 6578.87  | 
 0.9963  | 
 1.0037  | 
 1785  | 
 93  | 
|  TEST_TIME  | 
 140  | 
 6590.47  | 
 0.9948  | 
 1.0036  | 
 1386  | 
 95  | 
|  TEST_TIME  | 
 141  | 
 6581.56  | 
 0.9978  | 
 1.0017  | 
 1469  | 
 95  | 
|  TEST_TIME  | 
 142  | 
 6559.95  | 
 0.9979  | 
 1.0033  | 
 1451  | 
 91  | 
|  TEST_TIME  | 
 143  | 
 6571.79  | 
 0.9945  | 
 1.0039  | 
 1022  | 
 100  | 
|  TEST_TIME  | 
 144  | 
 6564.44  | 
 0.9981  | 
 1.0023  | 
 1522  | 
 98  | 
|  TEST_TIME  | 
 145  | 
 6553.39  | 
 0.9974  | 
 1.0012  | 
 1434  | 
 99  | 
|  TEST_TIME  | 
 146  | 
 6539.39  | 
 0.9965  | 
 1.0045  | 
 1191  | 
 99  | 
|  TEST_TIME  | 
 147  | 
 6543.97  | 
 0.9970  | 
 1.0027  | 
 1239  | 
 100  | 
|  TEST_TIME  | 
 148  | 
 6529.25  | 
 0.9981  | 
 1.0014  | 
 1370  | 
 98  | 
|  TEST_TIME  | 
 149  | 
 6532.71  | 
 0.9941  | 
 1.0036  | 
 1037  | 
 100  | 
|  TEST_TIME  | 
 150  | 
 6531.42  | 
 0.9971  | 
 1.0039  | 
 1241  | 
 100  | 
|  TEST_TIME  | 
 151  | 
 6526.91  | 
 0.9980  | 
 1.0028  | 
 2142  | 
 98  | 
|  TEST_TIME  | 
 152  | 
 6522.32  | 
 0.9969  | 
 1.0035  | 
 1705  | 
 94  | 
|  TEST_TIME  | 
 153  | 
 6529.80  | 
 0.9958  | 
 1.0028  | 
 1407  | 
 91  | 
|  TEST_TIME  | 
 154  | 
 6531.07  | 
 0.9961  | 
 1.0023  | 
 1496  | 
 92  | 
|  TEST_TIME  | 
 155  | 
 6519.18  | 
 0.9977  | 
 1.0026  | 
 1720  | 
 95  | 
|  TEST_TIME  | 
 156  | 
 6524.19  | 
 0.9954  | 
 1.0045  | 
 1408  | 
 99  | 
|  TEST_TIME  | 
 157  | 
 6526.91  | 
 0.9977  | 
 1.0014  | 
 1416  | 
 100  | 
|  TEST_TIME  | 
 158  | 
 6509.67  | 
 0.9978  | 
 1.0022  | 
 1564  | 
 99  | 
|  TEST_TIME  | 
 159  | 
 6508.12  | 
 0.9961  | 
 1.0031  | 
 1420  | 
 97  | 
|  TEST_TIME  | 
 160  | 
 6510.98  | 
 0.9964  | 
 1.0028  | 
 1283  | 
 100  | 
|  TEST_TIME  | 
 161  | 
 6503.62  | 
 0.9977  | 
 1.0034  | 
 1526  | 
 100  | 
|  TEST_TIME  | 
 162  | 
 6501.09  | 
 0.9976  | 
 1.0032  | 
 1383  | 
 100  | 
|  TEST_TIME  | 
 163  | 
 6508.36  | 
 0.9959  | 
 1.0039  | 
 1242  | 
 100  | 
|  TEST_TIME  | 
 164  | 
 6509.29  | 
 0.9977  | 
 1.0031  | 
 1210  | 
 100  | 
|  TEST_TIME  | 
 165  | 
 6509.49  | 
 0.9970  | 
 1.0044  | 
 1379  | 
 100  | 
|  TEST_TIME  | 
 166  | 
 6516.23  | 
 0.9973  | 
 1.0022  | 
 1919  | 
 99  | 
|  TEST_TIME  | 
 167  | 
 6515.28  | 
 0.9964  | 
 1.0038  | 
 1625  | 
 96  | 
|  TEST_TIME  | 
 168  | 
 6514.99  | 
 0.9979  | 
 1.0033  | 
 1642  | 
 93  | 
|  TEST_TIME  | 
 169  | 
 6511.30  | 
 0.9980  | 
 1.0022  | 
 1685  | 
 92  | 
|  TEST_TIME  | 
 170  | 
 6512.93  | 
 0.9961  | 
 1.0031  | 
 1454  | 
 95  | 
|  TEST_TIME  | 
 171  | 
 6514.11  | 
 0.9970  | 
 1.0027  | 
 1417  | 
 99  | 
|  TEST_TIME  | 
 172  | 
 6513.02  | 
 0.9971  | 
 1.0018  | 
 1186  | 
 100  | 
|  TEST_TIME  | 
 173  | 
 6512.19  | 
 0.9961  | 
 1.0043  | 
 1338  | 
 100  | 
|  TEST_TIME  | 
 174  | 
 6510.75  | 
 0.9987  | 
 1.0012  | 
 1292  | 
 92  | 
|  TEST_TIME  | 
 175  | 
 6492.48  | 
 0.9982  | 
 1.0016  | 
 1184  | 
 80  | 
|  TEST_TIME  | 
 176  | 
 6484.16  | 
 0.9972  | 
 1.0022  | 
 1157  | 
 90  | 
|  TEST_TIME  | 
 177  | 
 6480.18  | 
 0.9972  | 
 1.0028  | 
 1214  | 
 89  | 
|  TEST_TIME  | 
 178  | 
 6483.22  | 
 0.9967  | 
 1.0023  | 
 1281  | 
 91  | 
|  TEST_TIME  | 
 179  | 
 6481.87  | 
 0.9969  | 
 1.0029  | 
 1121  | 
 99  | 
|  TEST_TIME  | 
 180  | 
 6469.53  | 
 0.9992  | 
 1.0007  | 
 1042  | 
 99  | 
 
Done for 8500 ms, from  6:58:28.74 to  6:58:37.24.  
 
 
|  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  | 
 46814  | 
 35387  | 
 45415  | 
 <null>  | 
 58083  | 
 71873  | 
 59869  | 
 58580  | 
 69975  | 
 <null>  | 
 70178  | 
 53638  | 
 89544  | 
 68337  | 
 74458  | 
 37014  | 
 470242  | 
 603056  | 
 <null>  | 
 03:46:46  | 
 04:04:46  | 
|  fetches per second  | 
 2  | 
 65433  | 
 55513  | 
 43790  | 
 <null>  | 
 52527  | 
 21341  | 
 75344  | 
 101078  | 
 78977  | 
 159983  | 
 61410  | 
 65836  | 
 63539  | 
 75742  | 
 121772  | 
 64211  | 
 270419  | 
 878033  | 
 <null>  | 
 04:04:47  | 
 04:22:47  | 
|  fetches per second  | 
 3  | 
 39869  | 
 52574  | 
 43838  | 
 <null>  | 
 22457  | 
 103510  | 
 47149  | 
 77452  | 
 39564  | 
 79955  | 
 75852  | 
 44943  | 
 91992  | 
 20589  | 
 105475  | 
 75495  | 
 18309  | 
 313466  | 
 <null>  | 
 04:22:48  | 
 04:40:48  | 
|  fetches per second  | 
 4  | 
 51121  | 
 35624  | 
 49396  | 
 <null>  | 
 64945  | 
 18363  | 
 55832  | 
 46895  | 
 4153  | 
 17059  | 
 67697  | 
 45846  | 
 66901  | 
 75187  | 
 72673  | 
 82102  | 
 144023  | 
 123666  | 
 <null>  | 
 04:40:49  | 
 04:58:49  | 
|  fetches per second  | 
 5  | 
 36824  | 
 39281  | 
 37505  | 
 137067  | 
 37031  | 
 1993  | 
 65094  | 
 1739  | 
 71317  | 
 58309  | 
 66366  | 
 65678  | 
 84270  | 
 31997  | 
 52651  | 
 3397  | 
 350534  | 
 1126714  | 
 <null>  | 
 04:58:50  | 
 05:16:50  | 
|  fetches per second  | 
 6  | 
 42930  | 
 83755  | 
 54236  | 
 <null>  | 
 22037  | 
 4704  | 
 72345  | 
 4753  | 
 42458  | 
 14200  | 
 47385  | 
 23960  | 
 57939  | 
 24616  | 
 76690  | 
 46905  | 
 173231  | 
 497249  | 
 <null>  | 
 05:16:51  | 
 05:34:51  | 
|  fetches per second  | 
 7  | 
 19175  | 
 7679  | 
 22387  | 
 <null>  | 
 19975  | 
 <null>  | 
 29019  | 
 36106  | 
 17235  | 
 90591  | 
 24539  | 
 6103  | 
 45321  | 
 99913  | 
 40631  | 
 13842  | 
 <null>  | 
 191536  | 
 <null>  | 
 05:34:52  | 
 05:52:52  | 
|  fetches per second  | 
 8  | 
 13232  | 
 20939  | 
 13809  | 
 <null>  | 
 18203  | 
 <null>  | 
 14581  | 
 3699  | 
 14946  | 
 39271  | 
 18383  | 
 2047  | 
 48573  | 
 2886  | 
 52198  | 
 <null>  | 
 274398  | 
 99381  | 
 <null>  | 
 05:52:53  | 
 06:10:53  | 
|  fetches per second  | 
 9  | 
 16809  | 
 43903  | 
 2580  | 
 <null>  | 
 19544  | 
 <null>  | 
 30218  | 
 3427  | 
 <null>  | 
 34026  | 
 27520  | 
 2928  | 
 47713  | 
 18911  | 
 3361  | 
 3683  | 
 285000  | 
 121085  | 
 <null>  | 
 06:10:54  | 
 06:28:54  | 
|  fetches per second  | 
 10  | 
 10126  | 
 27972  | 
 16569  | 
 <null>  | 
 11023  | 
 <null>  | 
 31191  | 
 6485  | 
 2431  | 
 6005  | 
 15920  | 
 3510  | 
 69779  | 
 97910  | 
 15174  | 
 55074  | 
 16437  | 
 49973  | 
 <null>  | 
 06:28:55  | 
 06:46:55  | 
|  marks per second  | 
 1  | 
 9931  | 
 4473  | 
 8866  | 
 <null>  | 
 11415  | 
 13483  | 
 7832  | 
 10260  | 
 10409  | 
 <null>  | 
 11194  | 
 8805  | 
 6461  | 
 12503  | 
 3391  | 
 5522  | 
 3823  | 
 12333  | 
 <null>  | 
 03:46:46  | 
 04:04:46  | 
|  marks per second  | 
 2  | 
 13694  | 
 6747  | 
 9929  | 
 <null>  | 
 11752  | 
 4876  | 
 10255  | 
 14213  | 
 11934  | 
 27557  | 
 9162  | 
 11966  | 
 4861  | 
 17470  | 
 8246  | 
 10188  | 
 39142  | 
 49200  | 
 <null>  | 
 04:04:47  | 
 04:22:47  | 
|  marks per second  | 
 3  | 
 8583  | 
 6628  | 
 9749  | 
 <null>  | 
 4759  | 
 23014  | 
 6012  | 
 12022  | 
 5022  | 
 12743  | 
 9373  | 
 6930  | 
 6481  | 
 3329  | 
 9723  | 
 11994  | 
 2469  | 
 31400  | 
 <null>  | 
 04:22:48  | 
 04:40:48  | 
|  marks per second  | 
 4  | 
 10499  | 
 4458  | 
 10765  | 
 <null>  | 
 14553  | 
 4305  | 
 6571  | 
 7757  | 
 590  | 
 2812  | 
 8364  | 
 7192  | 
 4556  | 
 13619  | 
 8902  | 
 15357  | 
 13994  | 
 10538  | 
 <null>  | 
 04:40:49  | 
 04:58:49  | 
|  marks per second  | 
 5  | 
 7992  | 
 5030  | 
 8149  | 
 19309  | 
 7887  | 
 341  | 
 7767  | 
 286  | 
 7478  | 
 9888  | 
 5730  | 
 9901  | 
 3973  | 
 7089  | 
 5963  | 
 527  | 
 59038  | 
 35285  | 
 <null>  | 
 04:58:50  | 
 05:16:50  | 
|  marks per second  | 
 6  | 
 8830  | 
 10530  | 
 10973  | 
 <null>  | 
 4586  | 
 1206  | 
 9096  | 
 691  | 
 6195  | 
 2343  | 
 6223  | 
 4140  | 
 3199  | 
 3556  | 
 13388  | 
 7179  | 
 13081  | 
 11713  | 
 <null>  | 
 05:16:51  | 
 05:34:51  | 
|  marks per second  | 
 7  | 
 3996  | 
 951  | 
 4660  | 
 <null>  | 
 3854  | 
 <null>  | 
 3175  | 
 5077  | 
 2016  | 
 14094  | 
 2925  | 
 1034  | 
 2228  | 
 9308  | 
 5379  | 
 2245  | 
 <null>  | 
 23804  | 
 <null>  | 
 05:34:52  | 
 05:52:52  | 
|  marks per second  | 
 8  | 
 2790  | 
 2895  | 
 2707  | 
 <null>  | 
 4725  | 
 <null>  | 
 1614  | 
 522  | 
 1811  | 
 6014  | 
 3580  | 
 329  | 
 2397  | 
 411  | 
 6478  | 
 <null>  | 
 14729  | 
 3415  | 
 <null>  | 
 05:52:53  | 
 06:10:53  | 
|  marks per second  | 
 9  | 
 3222  | 
 5676  | 
 433  | 
 <null>  | 
 2963  | 
 <null>  | 
 3896  | 
 498  | 
 <null>  | 
 5512  | 
 3038  | 
 480  | 
 1465  | 
 3266  | 
 459  | 
 666  | 
 10469  | 
 1400  | 
 <null>  | 
 06:10:54  | 
 06:28:54  | 
|  marks per second  | 
 10  | 
 2094  | 
 3706  | 
 3083  | 
 <null>  | 
 1746  | 
 <null>  | 
 4055  | 
 900  | 
 365  | 
 835  | 
 1950  | 
 596  | 
 1755  | 
 16934  | 
 1165  | 
 6058  | 
 2540  | 
 633  | 
 <null>  | 
 06:28:55  | 
 06:46:55  | 
|  reads/fetches*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 03:46:46  | 
 04:04:46  | 
|  reads/fetches*100  | 
 2  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:04:47  | 
 04:22:47  | 
|  reads/fetches*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:22:48  | 
 04:40:48  | 
|  reads/fetches*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:40:49  | 
 04:58:49  | 
|  reads/fetches*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:58:50  | 
 05:16:50  | 
|  reads/fetches*100  | 
 6  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 05:16:51  | 
 05:34:51  | 
|  reads/fetches*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:34:52  | 
 05:52:52  | 
|  reads/fetches*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 05:52:53  | 
 06:10:53  | 
|  reads/fetches*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 06:10:54  | 
 06:28:54  | 
|  reads/fetches*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 06:28:55  | 
 06:46:55  | 
|  writes/marks*100  | 
 1  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 4  | 
 0  | 
 <null>  | 
 03:46:46  | 
 04:04:46  | 
|  writes/marks*100  | 
 2  | 
 1  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 1  | 
 2  | 
 0  | 
 <null>  | 
 04:04:47  | 
 04:22:47  | 
|  writes/marks*100  | 
 3  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 04:22:48  | 
 04:40:48  | 
|  writes/marks*100  | 
 4  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:40:49  | 
 04:58:49  | 
|  writes/marks*100  | 
 5  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 04:58:50  | 
 05:16:50  | 
|  writes/marks*100  | 
 6  | 
 0  | 
 0  | 
 1  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 2  | 
 0  | 
 <null>  | 
 05:16:51  | 
 05:34:51  | 
|  writes/marks*100  | 
 7  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 05:34:52  | 
 05:52:52  | 
|  writes/marks*100  | 
 8  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 05:52:53  | 
 06:10:53  | 
|  writes/marks*100  | 
 9  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 1  | 
 0  | 
 4  | 
 0  | 
 <null>  | 
 06:10:54  | 
 06:28:54  | 
|  writes/marks*100  | 
 10  | 
 0  | 
 0  | 
 0  | 
 <null>  | 
 0  | 
 <null>  | 
 0  | 
 0  | 
 1  | 
 1  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 0  | 
 6  | 
 0  | 
 <null>  | 
 06:28:55  | 
 06:46:55  | 
 
Done for 8330 ms, from  6:58:38.21 to  6:58:46.54.  
 
 
|  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  | 
 2043451  | 
 1879875  | 
 163576  | 
 8.00  | 
 0  | 
 9188  | 
 34  | 
 163576  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  doc_list_biud  | 
 2043936  | 
 1879875  | 
 164061  | 
 8.02  | 
 0  | 
 6115  | 
 12  | 
 164061  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_add_invoice_to_stock  | 
 20303  | 
 11917  | 
 8386  | 
 41.30  | 
 15  | 
 168730  | 
 7979  | 
 8386  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_cancel_adding_invoice  | 
 4795  | 
 3715  | 
 1080  | 
 22.52  | 
 0  | 
 55833  | 
 1898  | 
 1080  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_cancel_client_order  | 
 7074  | 
 6923  | 
 151  | 
 2.13  | 
 0  | 
 3073  | 
 197  | 
 151  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_cancel_customer_reserve  | 
 380332  | 
 227393  | 
 152939  | 
 40.21  | 
 0  | 
 3057  | 
 44  | 
 152939  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_cancel_pay_from_customer  | 
 2549  | 
 2537  | 
 12  | 
 0.47  | 
 0  | 
 2106  | 
 109  | 
 12  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_cancel_pay_to_supplier  | 
 1673  | 
 1667  | 
 6  | 
 0.35  | 
 0  | 
 2434  | 
 114  | 
 6  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_cancel_supplier_invoice  | 
 10639  | 
 8126  | 
 2513  | 
 23.62  | 
 0  | 
 7160  | 
 343  | 
 2513  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_cancel_supplier_order  | 
 1635  | 
 571  | 
 1064  | 
 65.07  | 
 0  | 
 137374  | 
 15556  | 
 1064  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_cancel_write_off  | 
 24398  | 
 16170  | 
 8228  | 
 33.72  | 
 0  | 
 3557  | 
 122  | 
 8228  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_client_order  | 
 82223  | 
 82223  | 
 0  | 
 0.00  | 
 0  | 
 7254  | 
 376  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_customer_reserve  | 
 667871  | 
 667871  | 
 0  | 
 0.00  | 
 0  | 
 7581  | 
 115  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_fill_shopping_cart  | 
 124983  | 
 124666  | 
 317  | 
 0.25  | 
 0  | 
 7020  | 
 75  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_fill_shopping_cart_clo_res  | 
 667871  | 
 667871  | 
 0  | 
 0.00  | 
 0  | 
 3042  | 
 8  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_get_clo_for_invoice  | 
 11917  | 
 11917  | 
 0  | 
 0.00  | 
 0  | 
 6708  | 
 243  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_kill_cost_storno  | 
 33048  | 
 24089  | 
 8959  | 
 27.10  | 
 0  | 
 2902  | 
 16  | 
 8959  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_kill_qstorno_ret_qs2qd  | 
 795377  | 
 479653  | 
 315724  | 
 39.69  | 
 0  | 
 5991  | 
 16  | 
 315724  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_kill_qty_storno  | 
 477060  | 
 313091  | 
 163969  | 
 34.37  | 
 0  | 
 5991  | 
 51  | 
 163969  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_lock_selected_doc  | 
 82235  | 
 70601  | 
 11634  | 
 14.14  | 
 0  | 
 2106  | 
 6  | 
 11634  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_make_cost_storno  | 
 100791  | 
 100791  | 
 0  | 
 0.00  | 
 0  | 
 8908  | 
 309  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_multiply_rows_for_pdistr  | 
 100791  | 
 100791  | 
 0  | 
 0.00  | 
 0  | 
 2433  | 
 46  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_multiply_rows_for_qdistr  | 
 82223  | 
 82223  | 
 0  | 
 0.00  | 
 0  | 
 4368  | 
 124  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_pay_from_customer  | 
 27825  | 
 27825  | 
 0  | 
 0.00  | 
 0  | 
 9297  | 
 722  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_pay_to_supplier  | 
 22773  | 
 22773  | 
 0  | 
 0.00  | 
 0  | 
 8533  | 
 373  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_payment_common  | 
 50598  | 
 50598  | 
 0  | 
 0.00  | 
 0  | 
 4227  | 
 52  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_qd_handle_on_cancel_clo  | 
 7072  | 
 6923  | 
 149  | 
 2.10  | 
 0  | 
 2652  | 
 85  | 
 149  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_qd_handle_on_invoice_upd_sts  | 
 16541  | 
 15632  | 
 909  | 
 5.49  | 
 0  | 
 5273  | 
 261  | 
 909  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_qd_handle_on_reserve_upd_sts  | 
 38276  | 
 38276  | 
 0  | 
 0.00  | 
 0  | 
 3354  | 
 38  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_reserve_write_off  | 
 39292  | 
 38276  | 
 1016  | 
 2.58  | 
 0  | 
 7098  | 
 443  | 
 1016  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_supplier_invoice  | 
 21470  | 
 21349  | 
 121  | 
 0.56  | 
 0  | 
 27082  | 
 2367  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  sp_supplier_order  | 
 21290  | 
 21094  | 
 196  | 
 0.92  | 
 0  | 
 13696  | 
 1572  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  srv_find_qd_qs_mism  | 
 1232656  | 
 1069082  | 
 163574  | 
 13.27  | 
 0  | 
 3807  | 
 18  | 
 163574  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  srv_make_invnt_saldo  | 
 1919  | 
 1919  | 
 0  | 
 0.00  | 
 0  | 
 25257  | 
 2019  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  srv_make_money_saldo  | 
 3045  | 
 3045  | 
 0  | 
 0.00  | 
 0  | 
 2402  | 
 54  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  srv_recalc_idx_stat  | 
 11  | 
 11  | 
 0  | 
 0.00  | 
 2511  | 
 35038  | 
 15331  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_add_invoice_to_stock  | 
 8386  | 
 8386  | 
 0  | 
 0.00  | 
 0  | 
 3947  | 
 78  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_cancel_adding_invoice  | 
 753  | 
 753  | 
 0  | 
 0.00  | 
 0  | 
 2012  | 
 164  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_cancel_client_order  | 
 151  | 
 151  | 
 0  | 
 0.00  | 
 0  | 
 1186  | 
 91  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_cancel_customer_reserve  | 
 69  | 
 69  | 
 0  | 
 0.00  | 
 0  | 
 1123  | 
 53  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_cancel_pay_from_customer  | 
 12  | 
 12  | 
 0  | 
 0.00  | 
 0  | 
 1264  | 
 115  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_cancel_pay_to_supplier  | 
 6  | 
 6  | 
 0  | 
 0.00  | 
 0  | 
 687  | 
 210  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_cancel_supplier_invoice  | 
 672  | 
 672  | 
 0  | 
 0.00  | 
 0  | 
 1404  | 
 79  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_cancel_supplier_order  | 
 18647  | 
 18647  | 
 0  | 
 0.00  | 
 0  | 
 3557  | 
 86  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_cancel_write_off  | 
 25  | 
 25  | 
 0  | 
 0.00  | 
 0  | 
 296  | 
 74  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_reserve_write_off  | 
 1016  | 
 1016  | 
 0  | 
 0.00  | 
 0  | 
 1045  | 
 47  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_supplier_invoice  | 
 121  | 
 121  | 
 0  | 
 0.00  | 
 0  | 
 1076  | 
 72  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-abend:sp_supplier_order  | 
 196  | 
 196  | 
 0  | 
 0.00  | 
 0  | 
 1186  | 
 69  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_add_invoice_to_stock  | 
 11917  | 
 11917  | 
 0  | 
 0.00  | 
 0  | 
 11607  | 
 462  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_cancel_adding_invoice  | 
 1370  | 
 1370  | 
 0  | 
 0.00  | 
 0  | 
 8954  | 
 489  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_cancel_client_order  | 
 6923  | 
 6923  | 
 0  | 
 0.00  | 
 0  | 
 2262  | 
 52  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_cancel_customer_reserve  | 
 2552  | 
 2552  | 
 0  | 
 0.00  | 
 0  | 
 1888  | 
 48  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_cancel_pay_from_customer  | 
 2537  | 
 2537  | 
 0  | 
 0.00  | 
 0  | 
 2340  | 
 38  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_cancel_pay_to_supplier  | 
 1667  | 
 1667  | 
 0  | 
 0.00  | 
 0  | 
 1263  | 
 36  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_cancel_supplier_invoice  | 
 938  | 
 938  | 
 0  | 
 0.00  | 
 0  | 
 1654  | 
 57  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_cancel_supplier_order  | 
 571  | 
 571  | 
 0  | 
 0.00  | 
 0  | 
 36083  | 
 1446  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_cancel_write_off  | 
 3850  | 
 3850  | 
 0  | 
 0.00  | 
 0  | 
 1965  | 
 56  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_client_order  | 
 82223  | 
 82223  | 
 0  | 
 0.00  | 
 0  | 
 2621  | 
 62  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_customer_reserve  | 
 3801  | 
 3801  | 
 0  | 
 0.00  | 
 0  | 
 2231  | 
 42  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_pay_from_customer  | 
 27825  | 
 27825  | 
 0  | 
 0.00  | 
 0  | 
 3994  | 
 52  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_pay_to_supplier  | 
 22773  | 
 22773  | 
 0  | 
 0.00  | 
 0  | 
 2449  | 
 44  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_reserve_write_off  | 
 38276  | 
 38276  | 
 0  | 
 0.00  | 
 0  | 
 4009  | 
 57  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_supplier_invoice  | 
 21349  | 
 21349  | 
 0  | 
 0.00  | 
 0  | 
 2605  | 
 51  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:sp_supplier_order  | 
 21094  | 
 21094  | 
 0  | 
 0.00  | 
 0  | 
 2277  | 
 53  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:srv_make_invnt_saldo  | 
 1919  | 
 1919  | 
 0  | 
 0.00  | 
 0  | 
 1591  | 
 22  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:srv_make_money_saldo  | 
 3045  | 
 3045  | 
 0  | 
 0.00  | 
 0  | 
 733  | 
 22  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  t$perf-norm:srv_recalc_idx_stat  | 
 11  | 
 11  | 
 0  | 
 0.00  | 
 0  | 
 982  | 
 112  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_add_invoice_to_stock  | 
 40606  | 
 23834  | 
 16772  | 
 41.30  | 
 0  | 
 2152  | 
 14  | 
 16772  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_all_customers  | 
 123334  | 
 123334  | 
 0  | 
 0.00  | 
 0  | 
 718  | 
 4  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_all_suppliers  | 
 86420  | 
 85786  | 
 634  | 
 0.73  | 
 0  | 
 1435  | 
 4  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_all_wares  | 
 164446  | 
 164446  | 
 0  | 
 0.00  | 
 0  | 
 952  | 
 3  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_cancel_adding_invoice  | 
 3206  | 
 2740  | 
 466  | 
 14.53  | 
 0  | 
 2387  | 
 115  | 
 466  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_cancel_client_order  | 
 14148  | 
 13846  | 
 302  | 
 2.13  | 
 0  | 
 2402  | 
 6  | 
 302  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_cancel_customer_prepayment  | 
 5098  | 
 5074  | 
 24  | 
 0.47  | 
 0  | 
 2091  | 
 7  | 
 24  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_cancel_customer_reserve  | 
 5242  | 
 5104  | 
 138  | 
 2.63  | 
 0  | 
 2387  | 
 8  | 
 138  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_cancel_payment_to_supplier  | 
 3346  | 
 3334  | 
 12  | 
 0.35  | 
 0  | 
 2324  | 
 8  | 
 12  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_cancel_supplier_invoice  | 
 3220  | 
 1876  | 
 1344  | 
 41.73  | 
 0  | 
 1670  | 
 15  | 
 1344  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_cancel_supplier_order  | 
 3270  | 
 1142  | 
 2128  | 
 65.07  | 
 0  | 
 952  | 
 7  | 
 2128  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_cancel_write_off  | 
 7750  | 
 7700  | 
 50  | 
 0.64  | 
 0  | 
 2715  | 
 85  | 
 50  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_max_id_clo_ord  | 
 21290  | 
 21094  | 
 196  | 
 0.92  | 
 0  | 
 998  | 
 4  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_max_id_clo_res  | 
 3801  | 
 3801  | 
 0  | 
 0.00  | 
 0  | 
 1965  | 
 17  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_max_id_ord_sup  | 
 21470  | 
 21349  | 
 121  | 
 0.56  | 
 0  | 
 702  | 
 4  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_max_non_paid_invoice  | 
 22323  | 
 22323  | 
 0  | 
 0.00  | 
 0  | 
 905  | 
 5  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_max_non_paid_realizn  | 
 27825  | 
 27825  | 
 0  | 
 0.00  | 
 0  | 
 983  | 
 5  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_min_id_clo_ord  | 
 21290  | 
 21094  | 
 196  | 
 0.92  | 
 0  | 
 593  | 
 5  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_min_id_clo_res  | 
 3801  | 
 3801  | 
 0  | 
 0.00  | 
 0  | 
 2886  | 
 11  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_min_id_ord_sup  | 
 21470  | 
 21349  | 
 121  | 
 0.56  | 
 0  | 
 1544  | 
 6  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_min_non_paid_invoice  | 
 22773  | 
 22773  | 
 0  | 
 0.00  | 
 0  | 
 2199  | 
 9  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_min_non_paid_realizn  | 
 27825  | 
 27825  | 
 0  | 
 0.00  | 
 0  | 
 1950  | 
 8  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_our_firm  | 
 41112  | 
 41112  | 
 0  | 
 0.00  | 
 0  | 
 749  | 
 5  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  v_reserve_write_off  | 
 78584  | 
 76552  | 
 2032  | 
 2.58  | 
 0  | 
 2464  | 
 7  | 
 2032  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  x_lock_depdocs_on_canc_invoice  | 
 20400  | 
 10903  | 
 9497  | 
 46.55  | 
 0  | 
 2386  | 
 24  | 
 9497  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  x_lock_depdocs_on_canc_sup_ord  | 
 1633  | 
 571  | 
 1062  | 
 65.03  | 
 0  | 
 1294  | 
 46  | 
 1062  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  x_make_qstorno_1000_1200  | 
 21290  | 
 21094  | 
 196  | 
 0.92  | 
 0  | 
 13618  | 
 1405  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  x_make_qstorno_1200_2000  | 
 21470  | 
 21349  | 
 121  | 
 0.56  | 
 0  | 
 26879  | 
 2194  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  x_make_qstorno_2100_3300  | 
 667871  | 
 667871  | 
 0  | 
 0.00  | 
 0  | 
 7566  | 
 95  | 
 0  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
 
Done for 295950 ms, from  7:03:32.46 to  7:08:28.41.  
 
 
 
|  FB_MNEMONA  | 
 CNT  | 
 UNIT  | 
 FB_GDSCODE  | 
 DTS_BEG  | 
 DTS_END  | 
|  deadlock  | 
 85  | 
 sp_kill_cost_storno  | 
 335544336  | 
 2017-12-10 03:47  | 
 2017-12-10 06:45  | 
|  deadlock  | 
 95  | 
 sp_kill_qstorno_ret_qs2qd  | 
 335544336  | 
 2017-12-10 04:02  | 
 2017-12-10 06:45  | 
|  deadlock  | 
 10183  | 
 sp_lock_selected_doc  | 
 335544336  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  deadlock  | 
 149  | 
 sp_qd_handle_on_cancel_clo  | 
 335544336  | 
 2017-12-10 03:58  | 
 2017-12-10 06:43  | 
|  deadlock  | 
 187  | 
 sp_qd_handle_on_invoice_upd_sts  | 
 335544336  | 
 2017-12-10 03:47  | 
 2017-12-10 06:45  | 
|  deadlock  | 
 660  | 
 x_lock_depdocs_on_canc_invoice  | 
 335544336  | 
 2017-12-10 03:46  | 
 2017-12-10 06:46  | 
|  deadlock  | 
 273  | 
 x_lock_depdocs_on_canc_sup_ord  | 
 335544336  | 
 2017-12-10 03:48  | 
 2017-12-10 06:46  | 
|  user_exc  | 
 196  | 
 x_make_qstorno_1000_1200  | 
 335544517  | 
 2017-12-10 03:46  | 
 2017-12-10 06:45  | 
|  user_exc  | 
 121  | 
 x_make_qstorno_1200_2000  | 
 335544517  | 
 2017-12-10 03:48  | 
 2017-12-10 06:44  | 
 
Done for 10330 ms, from  7:08:35.14 to  7:08:45.47.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          443416
 
MON$OLDEST_ACTIVE               443417
 
MON$OLDEST_SNAPSHOT             443417
 
MON$NEXT_TRANSACTION            443417
 
MON$PAGE_BUFFERS                786432
 
MON$SQL_DIALECT                 3
 
MON$SHUTDOWN_MODE               0
 
MON$SWEEP_INTERVAL              0
 
MON$READ_ONLY                   0
 
MON$FORCED_WRITES               1
 
MON$RESERVE_SPACE               1
 
MON$CREATION_DATE               2017-01-11 15:12:20.4040
 
MON$PAGES                       836288
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.3.32852 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32852 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.3.32852 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.3.32852 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P15"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Gstat execution time Sun Dec 10 07:08:45 2017 
 
 
Database header page information: 
 
Flags			0 
 
Generation		443571 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	443418 
 
Oldest active		443419 
 
Oldest snapshot		443419 
 
Next transaction	443420 
 
Sequence number		0 
 
Next attachment ID	9536 
 
Implementation		HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC 
 
Shadow count		0 
 
Page buffers		0 
 
Next header page	0 
 
Database dialect	3 
 
Creation date		Jan 11, 2017 15:12:20 
 
Attributes		force write 
 
 
Variable header data: 
 
Sweep interval:		0 
 
*END* 
 
 
 
Database file sequence: 
 
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file 
 
 
Analyzing database pages ... 
 
AGENTS (154) 
 
Primary pointer page: 311, Index root page: 312 
 
Total formats: 1, used formats: 1 
 
Average record length: 33.58, total records: 50 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 344.00, compression ratio: 10.24 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 31% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_ID_DESC (2) 
 
Root page: 322, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_OUR_FIRM (4) 
 
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 48 
 
Average key length: 2.04, compression ratio: 0.50 
 
Average prefix length: 0.96, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_IS_SUPPLIER (3) 
 
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 44 
 
Average key length: 2.04, compression ratio: 0.54 
 
Average prefix length: 1.04, average data length: 0.06 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index AGENTS_NAME_UNQ (1) 
 
Root page: 321, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.16, total dup: 0, max dup: 0 
 
Average key length: 15.86, compression ratio: 0.92 
 
Average prefix length: 1.44, average data length: 13.16 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_AGENTS (0) 
 
Root page: 320, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
BUSINESS_OPS (158) 
 
Primary pointer page: 332, Index root page: 333 
 
Total formats: 1, used formats: 1 
 
Average record length: 107.00, total records: 19 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1236.00, compression ratio: 11.55 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 29% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BO_UNIT_UNQ (1) 
 
Root page: 336, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 18.00, total dup: 0, max dup: 0 
 
Average key length: 16.95, compression ratio: 1.25 
 
Average prefix length: 7.21, average data length: 14.00 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index BUSINESS_OPS_RND_WGTH (2) 
 
Root page: 337, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 4.05, total dup: 7, max dup: 3 
 
Average key length: 3.00, compression ratio: 0.75 
 
Average prefix length: 1.42, average data length: 0.84 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RDB$1 (0) 
 
Root page: 335, depth: 1, leaf buckets: 1, nodes: 19 
 
Average node length: 5.26, total dup: 0, max dup: 0 
 
Average key length: 4.21, compression ratio: 0.64 
 
Average prefix length: 1.05, average data length: 1.63 
 
Clustering factor: 1, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
DOC_DATA (141) 
 
Primary pointer page: 251, Index root page: 252 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.10, total records: 2170418 
 
Average version length: 47.68, total versions: 3487, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 1.36 
 
Pointer pages: 15, data page slots: 23472 
 
Data pages: 23472, average fill: 73% 
 
Primary pages: 23472, secondary pages: 0, swept pages: 12908 
 
Empty pages: 3, full pages: 21428 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 5 
 
40 - 59% = 51 
 
60 - 79% = 23405 
 
80 - 99% = 7 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 26189, depth: 3, leaf buckets: 10575, nodes: 2170418 
 
Average node length: 19.38, total dup: 0, max dup: 0 
 
Average key length: 16.42, compression ratio: 1.64 
 
Average prefix length: 13.57, average data length: 13.43 
 
Clustering factor: 410666, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 728 
 
20 - 39% = 2582 
 
40 - 59% = 4579 
 
60 - 79% = 1163 
 
80 - 99% = 1523 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 45719, depth: 3, leaf buckets: 7783, nodes: 2170418 
 
Average node length: 11.63, total dup: 0, max dup: 0 
 
Average key length: 8.68, compression ratio: 1.04 
 
Average prefix length: 3.32, average data length: 5.68 
 
Clustering factor: 394169, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 3706 
 
40 - 59% = 3975 
 
60 - 79% = 94 
 
80 - 99% = 8 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 179522, depth: 3, leaf buckets: 3759, nodes: 2170418 
 
Average node length: 6.86, total dup: 1569534, max dup: 49 
 
Average key length: 3.90, compression ratio: 2.31 
 
Average prefix length: 7.37, average data length: 1.63 
 
Clustering factor: 373140, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 142 
 
20 - 39% = 1196 
 
40 - 59% = 1520 
 
60 - 79% = 332 
 
80 - 99% = 569 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 60.35, total records: 667870 
 
Average version length: 37.34, total versions: 3388, max versions: 3 
 
Average fragment length: 18.85, total fragments: 13, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.59 
 
Pointer pages: 6, data page slots: 8448 
 
Data pages: 8448, average fill: 75% 
 
Primary pages: 8444, secondary pages: 4, swept pages: 6414 
 
Empty pages: 6, full pages: 7987 
 
Fill distribution: 
 
0 - 19% = 12 
 
20 - 39% = 8 
 
40 - 59% = 36 
 
60 - 79% = 8338 
 
80 - 99% = 54 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 245867, depth: 3, leaf buckets: 2454, nodes: 667870 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.82, compression ratio: 1.02 
 
Average prefix length: 3.17, average data length: 5.83 
 
Clustering factor: 165240, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1314 
 
40 - 59% = 1085 
 
60 - 79% = 47 
 
80 - 99% = 8 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2807, depth: 2, leaf buckets: 701, nodes: 667870 
 
Average node length: 4.88, total dup: 667820, max dup: 43990 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 305623, ratio: 0.46 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 606 
 
60 - 79% = 71 
 
80 - 99% = 24 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 333415, depth: 3, leaf buckets: 1872, nodes: 667870 
 
Average node length: 11.69, total dup: 0, max dup: 0 
 
Average key length: 8.82, compression ratio: 1.02 
 
Average prefix length: 3.18, average data length: 5.82 
 
Clustering factor: 165240, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 124 
 
20 - 39% = 460 
 
40 - 59% = 663 
 
60 - 79% = 304 
 
80 - 99% = 321 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.50, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 650.00, compression ratio: 9.63 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_MCODE_UNQ (1) 
 
Root page: 318, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 17.75, total dup: 0, max dup: 0 
 
Average key length: 16.50, compression ratio: 1.08 
 
Average prefix length: 4.00, average data length: 13.75 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index DOC_STATES_NAME_UNQ (2) 
 
Root page: 319, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 33.25, total dup: 0, max dup: 0 
 
Average key length: 32.00, compression ratio: 0.99 
 
Average prefix length: 2.50, average data length: 29.25 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_DOC_STATES (0) 
 
Root page: 317, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 4.75, total dup: 0, max dup: 0 
 
Average key length: 3.50, compression ratio: 0.86 
 
Average prefix length: 1.50, average data length: 1.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
FB_ERRORS (159) 
 
Primary pointer page: 338, Index root page: 339 
 
Total formats: 1, used formats: 1 
 
Average record length: 79.56, total records: 758 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 148.00, compression ratio: 1.86 
 
Pointer pages: 1, data page slots: 16 
 
Data pages: 16, average fill: 56% 
 
Primary pages: 16, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 7 
 
 
Index FB_ERRORS_GDS_CODE (0) 
 
Root page: 340, depth: 1, leaf buckets: 1, nodes: 758 
 
Average node length: 4.24, total dup: 0, max dup: 0 
 
Average key length: 3.04, compression ratio: 1.64 
 
Average prefix length: 3.97, average data length: 1.03 
 
Clustering factor: 353, ratio: 0.47 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_SALDO (147) 
 
Primary pointer page: 270, Index root page: 271 
 
Total formats: 1, used formats: 1 
 
Average record length: 65.11, total records: 400 
 
Average version length: 20.79, total versions: 45872, max versions: 128 
 
Average fragment length: 18.07, total fragments: 375, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.60 
 
Pointer pages: 1, data page slots: 568 
 
Data pages: 288, average fill: 77% 
 
Primary pages: 9, secondary pages: 279, swept pages: 0 
 
Empty pages: 5, full pages: 282 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 188 
 
80 - 99% = 95 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 282, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 292, ratio: 0.73 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 3.42, total records: 9251 
 
Average version length: 71.18, total versions: 8807, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 28.07 
 
Pointer pages: 1, data page slots: 1080 
 
Data pages: 440, average fill: 28% 
 
Primary pages: 438, secondary pages: 2, swept pages: 183 
 
Empty pages: 198, full pages: 59 
 
Fill distribution: 
 
0 - 19% = 226 
 
20 - 39% = 75 
 
40 - 59% = 35 
 
60 - 79% = 59 
 
80 - 99% = 45 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 1845, depth: 2, leaf buckets: 35, nodes: 9251 
 
Average node length: 14.43, total dup: 14, max dup: 1 
 
Average key length: 12.49, compression ratio: 2.16 
 
Average prefix length: 17.50, average data length: 9.50 
 
Clustering factor: 8105, ratio: 0.88 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 7 
 
40 - 59% = 23 
 
60 - 79% = 5 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 262, Index root page: 263 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.02, total records: 49 
 
Average version length: 9.02, total versions: 4193, max versions: 1024 
 
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: 24 
 
Data pages: 24, average fill: 60% 
 
Primary pages: 2, secondary pages: 22, swept pages: 0 
 
Empty pages: 1, full pages: 12 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 1 
 
40 - 59% = 7 
 
60 - 79% = 3 
 
80 - 99% = 10 
 
 
Index PK_MONEY_SALDO (0) 
 
Root page: 273, depth: 1, leaf buckets: 1, nodes: 49 
 
Average node length: 11.82, total dup: 0, max dup: 0 
 
Average key length: 10.80, compression ratio: 0.83 
 
Average prefix length: 1.18, average data length: 7.82 
 
Clustering factor: 1, ratio: 0.02 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MONEY_TURNOVER_LOG (142) 
 
Primary pointer page: 260, Index root page: 261 
 
Total formats: 1, used formats: 1 
 
Average record length: 4.67, total records: 525 
 
Average version length: 44.95, total versions: 471, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 13.69 
 
Pointer pages: 1, data page slots: 56 
 
Data pages: 40, average fill: 13% 
 
Primary pages: 38, secondary pages: 2, swept pages: 11 
 
Empty pages: 30, full pages: 4 
 
Fill distribution: 
 
0 - 19% = 33 
 
20 - 39% = 0 
 
40 - 59% = 2 
 
60 - 79% = 2 
 
80 - 99% = 3 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 179693, depth: 2, leaf buckets: 1, nodes: 525 
 
Average node length: 5.21, total dup: 454, max dup: 59 
 
Average key length: 3.76, compression ratio: 5.05 
 
Average prefix length: 17.37, average data length: 1.63 
 
Clustering factor: 251, ratio: 0.48 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG (165) 
 
Primary pointer page: 354, Index root page: 355 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_DTS (4) 
 
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_GDSCODE (2) 
 
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_ROWSET_DESC (1) 
 
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_UNIT (3) 
 
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG (0) 
 
Root page: 361, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG_TABLE_STATS (166) 
 
Primary pointer page: 366, Index root page: 367 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_DTS (4) 
 
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_GDSCODE (2) 
 
Root page: 371, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_ROWSET (1) 
 
Root page: 370, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index MON_LOG_TABLE_STATS_TN_UNIT (3) 
 
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_MON_LOG_TABLE_STATS (0) 
 
Root page: 369, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.89, total records: 9 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 5.54 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 9% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index OPTYPES_MCODE_UNQ (1) 
 
Root page: 242, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 8.56, total dup: 0, max dup: 0 
 
Average key length: 6.89, compression ratio: 0.73 
 
Average prefix length: 0.44, average data length: 4.56 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_OPTYPES (0) 
 
Root page: 241, depth: 1, leaf buckets: 1, nodes: 9 
 
Average node length: 6.11, total dup: 0, max dup: 0 
 
Average key length: 5.00, compression ratio: 0.60 
 
Average prefix length: 0.89, average data length: 2.11 
 
Clustering factor: 1, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PDISTR (150) 
 
Primary pointer page: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 41.80, total records: 218702 
 
Average version length: 31.12, total versions: 7516, max versions: 11 
 
Average fragment length: 34.00, total fragments: 2, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.53 
 
Pointer pages: 2, data page slots: 2560 
 
Data pages: 2560, average fill: 64% 
 
Primary pages: 2542, secondary pages: 18, swept pages: 1218 
 
Empty pages: 20, full pages: 668 
 
Fill distribution: 
 
0 - 19% = 46 
 
20 - 39% = 100 
 
40 - 59% = 404 
 
60 - 79% = 2000 
 
80 - 99% = 10 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 5420, depth: 2, leaf buckets: 210, nodes: 218702 
 
Average node length: 4.55, total dup: 218653, max dup: 11053 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 37054, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 16 
 
40 - 59% = 112 
 
60 - 79% = 65 
 
80 - 99% = 17 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4740, depth: 2, leaf buckets: 239, nodes: 218702 
 
Average node length: 5.49, total dup: 197170, max dup: 48 
 
Average key length: 2.95, compression ratio: 7.46 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 48757, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 12 
 
40 - 59% = 111 
 
60 - 79% = 76 
 
80 - 99% = 39 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 4730, depth: 2, leaf buckets: 240, nodes: 218702 
 
Average node length: 5.49, total dup: 197170, max dup: 48 
 
Average key length: 2.95, compression ratio: 7.45 
 
Average prefix length: 21.15, average data length: 0.85 
 
Clustering factor: 48835, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 14 
 
40 - 59% = 95 
 
60 - 79% = 92 
 
80 - 99% = 38 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4894, depth: 2, leaf buckets: 233, nodes: 218702 
 
Average node length: 5.28, total dup: 197170, max dup: 48 
 
Average key length: 2.74, compression ratio: 3.29 
 
Average prefix length: 8.36, average data length: 0.64 
 
Clustering factor: 48808, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 13 
 
40 - 59% = 97 
 
60 - 79% = 87 
 
80 - 99% = 34 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.97, total records: 275791 
 
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: 2360 
 
Data pages: 2360, average fill: 64% 
 
Primary pages: 2360, secondary pages: 0, swept pages: 0 
 
Empty pages: 4, full pages: 2355 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 2355 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 641901, depth: 2, leaf buckets: 219, nodes: 275791 
 
Average node length: 4.54, total dup: 275610, max dup: 2587 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.59, average data length: 0.00 
 
Clustering factor: 47510, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 2 
 
40 - 59% = 76 
 
60 - 79% = 69 
 
80 - 99% = 72 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PERF_ISQL_STAT_TRN (0) 
 
Root page: 346, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 1, used formats: 1 
 
Average record length: 151.73, total records: 12441050 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1696.00, compression ratio: 11.18 
 
Pointer pages: 181, data page slots: 295304 
 
Data pages: 295304, average fill: 87% 
 
Primary pages: 295304, secondary pages: 0, swept pages: 3 
 
Empty pages: 6, full pages: 295297 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 295297 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 64458, depth: 3, leaf buckets: 14164, nodes: 12441050 
 
Average node length: 5.68, total dup: 11595426, max dup: 142 
 
Average key length: 2.16, compression ratio: 3.69 
 
Average prefix length: 7.87, average data length: 0.12 
 
Clustering factor: 3635155, ratio: 0.29 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 0 
 
40 - 59% = 8034 
 
60 - 79% = 4067 
 
80 - 99% = 2058 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 163628, depth: 3, leaf buckets: 12445, nodes: 12441050 
 
Average node length: 4.62, total dup: 12441046, max dup: 11237016 
 
Average key length: 1.10, compression ratio: 0.44 
 
Average prefix length: 0.48, average data length: 0.00 
 
Clustering factor: 366963, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 12443 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43655, depth: 3, leaf buckets: 15320, nodes: 12441050 
 
Average node length: 5.74, total dup: 12069477, max dup: 27054 
 
Average key length: 2.22, compression ratio: 4.05 
 
Average prefix length: 8.81, average data length: 0.19 
 
Clustering factor: 911802, ratio: 0.07 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 1 
 
40 - 59% = 11606 
 
60 - 79% = 2092 
 
80 - 99% = 1620 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 77766, depth: 3, leaf buckets: 15162, nodes: 12441050 
 
Average node length: 5.59, total dup: 12414852, max dup: 1769733 
 
Average key length: 2.07, compression ratio: 18.31 
 
Average prefix length: 37.80, average data length: 0.07 
 
Clustering factor: 6407016, ratio: 0.51 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 3 
 
40 - 59% = 13065 
 
60 - 79% = 556 
 
80 - 99% = 1522 
 
 
PHRASES (145) 
 
Primary pointer page: 266, Index root page: 267 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_ID_DESC (3) 
 
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_NAME (2) 
 
Root page: 279, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PHRASES_UNQ (1) 
 
Root page: 278, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_PHRASES (0) 
 
Root page: 277, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
PSTORNED (151) 
 
Primary pointer page: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 55.05, total records: 469876 
 
Average version length: 55.83, total versions: 865, 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: 5576 
 
Data pages: 5576, average fill: 75% 
 
Primary pages: 5576, secondary pages: 0, swept pages: 3550 
 
Empty pages: 8, full pages: 5324 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 7 
 
40 - 59% = 17 
 
60 - 79% = 5539 
 
80 - 99% = 2 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 619913, depth: 3, leaf buckets: 609, nodes: 469876 
 
Average node length: 5.92, total dup: 397416, max dup: 604 
 
Average key length: 3.12, compression ratio: 2.88 
 
Average prefix length: 8.03, average data length: 0.97 
 
Clustering factor: 61015, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 28 
 
40 - 59% = 370 
 
60 - 79% = 141 
 
80 - 99% = 63 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2157, depth: 2, leaf buckets: 505, nodes: 469876 
 
Average node length: 5.61, total dup: 419028, max dup: 104 
 
Average key length: 2.81, compression ratio: 3.21 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 115078, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 7 
 
40 - 59% = 226 
 
60 - 79% = 179 
 
80 - 99% = 93 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
Total formats: 1, used formats: 1 
 
Average record length: 18.00, total records: 4 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 336.00, compression ratio: 18.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 2% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_PDISTR_UNQ (0) 
 
Root page: 308, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 11.50, total dup: 0, max dup: 0 
 
Average key length: 10.25, compression ratio: 0.88 
 
Average prefix length: 1.50, average data length: 7.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
RULES_FOR_QDISTR (139) 
 
Primary pointer page: 243, Index root page: 244 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.71, total records: 7 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 332.00, compression ratio: 10.15 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 4% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_RCVOP (1) 
 
Root page: 246, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 5.29, total dup: 2, max dup: 2 
 
Average key length: 4.14, compression ratio: 0.72 
 
Average prefix length: 1.43, average data length: 1.57 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index RULES_FOR_QDISTR_UNQ (0) 
 
Root page: 245, depth: 1, leaf buckets: 1, nodes: 7 
 
Average node length: 10.14, total dup: 0, max dup: 0 
 
Average key length: 8.86, compression ratio: 0.94 
 
Average prefix length: 2.14, average data length: 6.14 
 
Clustering factor: 1, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SEMAPHORES (156) 
 
Primary pointer page: 315, Index root page: 316 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.25, total records: 4 
 
Average version length: 9.00, total versions: 1301, max versions: 1169 
 
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: 7 
 
Data pages: 6, average fill: 72% 
 
Primary pages: 1, secondary pages: 5, swept pages: 0 
 
Empty pages: 0, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 3 
 
80 - 99% = 2 
 
 
Index PK_SEMAPHORES (0) 
 
Root page: 327, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 12.50, total dup: 0, max dup: 0 
 
Average key length: 11.00, compression ratio: 0.82 
 
Average prefix length: 0.50, average data length: 8.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index SEMAPHORES_TASK_UNQ (1) 
 
Root page: 328, depth: 1, leaf buckets: 1, nodes: 4 
 
Average node length: 22.50, total dup: 0, max dup: 0 
 
Average key length: 21.00, compression ratio: 1.07 
 
Average prefix length: 4.00, average data length: 18.50 
 
Clustering factor: 1, ratio: 0.25 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
SETTINGS (137) 
 
Primary pointer page: 236, Index root page: 237 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.31, total records: 114 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 1347.00, compression ratio: 13.70 
 
Pointer pages: 1, data page slots: 2 
 
Data pages: 2, average fill: 80% 
 
Primary pages: 2, secondary pages: 0, swept pages: 2 
 
Empty pages: 0, full pages: 1 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 1 
 
 
Index SETTINGS_MODE_CODE (0) 
 
Root page: 238, depth: 1, leaf buckets: 1, nodes: 114 
 
Average node length: 27.11, total dup: 0, max dup: 0 
 
Average key length: 26.10, compression ratio: 1.70 
 
Average prefix length: 21.18, average data length: 23.11 
 
Clustering factor: 6, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$RAND$CALLS (136) 
 
Primary pointer page: 234, Index root page: 235 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$AUTOGEN$SOURCE (135) 
 
Primary pointer page: 232, Index root page: 233 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_DEP_DOCS_UNQ (0) 
 
Root page: 200, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$IDX_RECALC (132) 
 
Primary pointer page: 207, Index root page: 224 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_IDX_RECALC_IDX_NAME_UNQ (0) 
 
Root page: 226, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG (133) 
 
Primary pointer page: 227, Index root page: 228 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$MON_LOG_TABLE_STATS (134) 
 
Primary pointer page: 230, Index root page: 231 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_LOG (164) 
 
Primary pointer page: 352, Index root page: 353 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0) 
 
Root page: 360, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$PERF_MON (131) 
 
Primary pointer page: 205, Index root page: 206 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$RESULT_SET (130) 
 
Primary pointer page: 201, Index root page: 202 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_DOC (1) 
 
Root page: 204, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_RESULT_SET_WARE_DOC (0) 
 
Root page: 203, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TMP$SHOPPING_CART (128) 
 
Primary pointer page: 193, Index root page: 194 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index TMP_SHOPCART_UNQ (0) 
 
Root page: 197, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
TRACE_STAT (162) 
 
Primary pointer page: 347, Index root page: 348 
 
Total formats: 1, used formats: 1 
 
Average record length: 57.57, total records: 2697 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 376.00, compression ratio: 6.53 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 62% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 7, full pages: 32 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 32 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 264, Index root page: 265 
 
Total formats: 1, used formats: 1 
 
Average record length: 78.23, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 448.00, compression ratio: 5.73 
 
Pointer pages: 1, data page slots: 6 
 
Data pages: 6, average fill: 78% 
 
Primary pages: 6, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 5 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 4 
 
80 - 99% = 2 
 
 
Index FK_WARES_WARE_GROUPS (3) 
 
Root page: 377, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 67 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARES (0) 
 
Root page: 274, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 276, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 11.22, total dup: 0, max dup: 0 
 
Average key length: 10.22, compression ratio: 0.88 
 
Average prefix length: 1.78, average data length: 7.22 
 
Clustering factor: 335, ratio: 0.84 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 507, depth: 2, leaf buckets: 4, nodes: 400 
 
Average node length: 52.86, total dup: 0, max dup: 0 
 
Average key length: 51.84, compression ratio: 1.00 
 
Average prefix length: 2.73, average data length: 48.86 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
Total formats: 1, used formats: 1 
 
Average record length: 32.13, total records: 8 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 352.00, compression ratio: 10.96 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 5% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index PK_WARE_GROUPS (0) 
 
Root page: 325, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 11.25, total dup: 0, max dup: 0 
 
Average key length: 10.13, compression ratio: 0.89 
 
Average prefix length: 1.75, average data length: 7.25 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARE_GROUPS_NAME_UNQ (1) 
 
Root page: 326, depth: 1, leaf buckets: 1, nodes: 8 
 
Average node length: 19.88, total dup: 0, max dup: 0 
 
Average key length: 18.13, compression ratio: 0.89 
 
Average prefix length: 0.25, average data length: 15.88 
 
Clustering factor: 1, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQD_1000_1200 (260) 
 
Primary pointer page: 292, Index root page: 295 
 
Total formats: 1, used formats: 1 
 
Average record length: 14.64, total records: 18445 
 
Average version length: 72.21, total versions: 14708, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 9.29 
 
Pointer pages: 2, data page slots: 1952 
 
Data pages: 520, average fill: 46% 
 
Primary pages: 519, secondary pages: 1, swept pages: 113 
 
Empty pages: 159, full pages: 236 
 
Fill distribution: 
 
0 - 19% = 226 
 
20 - 39% = 34 
 
40 - 59% = 16 
 
60 - 79% = 40 
 
80 - 99% = 204 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1346, depth: 2, leaf buckets: 27, nodes: 18445 
 
Average node length: 5.92, total dup: 16088, max dup: 14 
 
Average key length: 3.81, compression ratio: 9.71 
 
Average prefix length: 35.32, average data length: 1.68 
 
Clustering factor: 2956, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 7 
 
40 - 59% = 11 
 
60 - 79% = 5 
 
80 - 99% = 3 
 
 
XQD_1000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.58, total records: 993807 
 
Average version length: 71.88, total versions: 8259, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.90 
 
Pointer pages: 10, data page slots: 14792 
 
Data pages: 14792, average fill: 74% 
 
Primary pages: 14792, secondary pages: 0, swept pages: 7452 
 
Empty pages: 22, full pages: 11643 
 
Fill distribution: 
 
0 - 19% = 51 
 
20 - 39% = 140 
 
40 - 59% = 626 
 
60 - 79% = 13908 
 
80 - 99% = 67 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 521322, depth: 3, leaf buckets: 1112, nodes: 993807 
 
Average node length: 5.12, total dup: 967315, max dup: 124 
 
Average key length: 2.19, compression ratio: 4.10 
 
Average prefix length: 8.83, average data length: 0.17 
 
Clustering factor: 114452, ratio: 0.12 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 77 
 
40 - 59% = 794 
 
60 - 79% = 41 
 
80 - 99% = 187 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 193506, depth: 3, leaf buckets: 1421, nodes: 993807 
 
Average node length: 6.24, total dup: 867862, max dup: 14 
 
Average key length: 3.32, compression ratio: 11.16 
 
Average prefix length: 35.81, average data length: 1.19 
 
Clustering factor: 192462, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 148 
 
40 - 59% = 995 
 
60 - 79% = 156 
 
80 - 99% = 109 
 
 
XQD_1200_2000 (261) 
 
Primary pointer page: 718, Index root page: 719 
 
Total formats: 1, used formats: 1 
 
Average record length: 22.71, total records: 58873 
 
Average version length: 72.08, total versions: 40353, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 5.99 
 
Pointer pages: 4, data page slots: 4696 
 
Data pages: 1992, average fill: 37% 
 
Primary pages: 1991, secondary pages: 1, swept pages: 402 
 
Empty pages: 711, full pages: 571 
 
Fill distribution: 
 
0 - 19% = 966 
 
20 - 39% = 124 
 
40 - 59% = 150 
 
60 - 79% = 333 
 
80 - 99% = 419 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 832787, depth: 3, leaf buckets: 103, nodes: 58873 
 
Average node length: 6.20, total dup: 51597, max dup: 49 
 
Average key length: 3.48, compression ratio: 10.64 
 
Average prefix length: 35.65, average data length: 1.35 
 
Clustering factor: 6663, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 38 
 
40 - 59% = 38 
 
60 - 79% = 19 
 
80 - 99% = 3 
 
 
XQD_2000_3300 (263) 
 
Primary pointer page: 735, Index root page: 736 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.30, total records: 1641903 
 
Average version length: 71.77, total versions: 42886, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.93 
 
Pointer pages: 17, data page slots: 26312 
 
Data pages: 26152, average fill: 69% 
 
Primary pages: 26151, secondary pages: 1, swept pages: 14240 
 
Empty pages: 455, full pages: 17900 
 
Fill distribution: 
 
0 - 19% = 855 
 
20 - 39% = 1076 
 
40 - 59% = 2677 
 
60 - 79% = 20752 
 
80 - 99% = 792 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 196671, depth: 3, leaf buckets: 2611, nodes: 1641903 
 
Average node length: 5.60, total dup: 1545620, max dup: 49 
 
Average key length: 2.64, compression ratio: 14.00 
 
Average prefix length: 36.41, average data length: 0.59 
 
Clustering factor: 209004, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 1216 
 
40 - 59% = 1060 
 
60 - 79% = 156 
 
80 - 99% = 168 
 
 
XQD_2100_3300 (264) 
 
Primary pointer page: 738, Index root page: 739 
 
Total formats: 1, used formats: 1 
 
Average record length: 7.71, total records: 8177 
 
Average version length: 72.00, total versions: 7279, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 17.64 
 
Pointer pages: 4, data page slots: 2488 
 
Data pages: 1064, average fill: 11% 
 
Primary pages: 1063, secondary pages: 1, swept pages: 302 
 
Empty pages: 644, full pages: 22 
 
Fill distribution: 
 
0 - 19% = 836 
 
20 - 39% = 118 
 
40 - 59% = 69 
 
60 - 79% = 22 
 
80 - 99% = 19 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1215, depth: 2, leaf buckets: 15, nodes: 8177 
 
Average node length: 6.24, total dup: 7342, max dup: 51 
 
Average key length: 4.06, compression ratio: 9.12 
 
Average prefix length: 35.04, average data length: 1.96 
 
Clustering factor: 1177, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 8 
 
40 - 59% = 4 
 
60 - 79% = 2 
 
80 - 99% = 1 
 
 
XQD_3300_3400 (265) 
 
Primary pointer page: 741, Index root page: 742 
 
Total formats: 1, used formats: 1 
 
Average record length: 71.08, total records: 2754607 
 
Average version length: 71.03, total versions: 17601, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.91 
 
Pointer pages: 25, data page slots: 39336 
 
Data pages: 39336, average fill: 76% 
 
Primary pages: 39336, secondary pages: 0, swept pages: 27428 
 
Empty pages: 71, full pages: 35681 
 
Fill distribution: 
 
0 - 19% = 91 
 
20 - 39% = 87 
 
40 - 59% = 589 
 
60 - 79% = 38130 
 
80 - 99% = 439 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 40476, depth: 3, leaf buckets: 5718, nodes: 2754607 
 
Average node length: 6.89, total dup: 2223853, max dup: 15 
 
Average key length: 3.92, compression ratio: 9.45 
 
Average prefix length: 35.28, average data length: 1.72 
 
Clustering factor: 488471, ratio: 0.18 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 3100 
 
40 - 59% = 2155 
 
60 - 79% = 284 
 
80 - 99% = 171 
 
 
XQS_1000_1200 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.73, total records: 4724681 
 
Average version length: 84.79, total versions: 2706, 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: 45, data page slots: 72640 
 
Data pages: 72640, average fill: 80% 
 
Primary pages: 72640, secondary pages: 0, swept pages: 26846 
 
Empty pages: 8, full pages: 72049 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 3 
 
40 - 59% = 37 
 
60 - 79% = 20722 
 
80 - 99% = 51868 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54645, depth: 3, leaf buckets: 4914, nodes: 4724681 
 
Average node length: 5.16, total dup: 4616813, max dup: 135 
 
Average key length: 2.17, compression ratio: 4.15 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 740420, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 20 
 
20 - 39% = 113 
 
40 - 59% = 2326 
 
60 - 79% = 1950 
 
80 - 99% = 505 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 82607, depth: 3, leaf buckets: 4951, nodes: 4724681 
 
Average node length: 5.70, total dup: 4225519, max dup: 49 
 
Average key length: 2.72, compression ratio: 3.31 
 
Average prefix length: 8.39, average data length: 0.61 
 
Clustering factor: 219137, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 44 
 
20 - 39% = 148 
 
40 - 59% = 2477 
 
60 - 79% = 321 
 
80 - 99% = 1961 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 47515, depth: 3, leaf buckets: 5437, nodes: 4724681 
 
Average node length: 5.81, total dup: 4134042, max dup: 28 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 796697, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 23 
 
20 - 39% = 117 
 
40 - 59% = 2478 
 
60 - 79% = 2089 
 
80 - 99% = 730 
 
 
XQS_1000_3300 (268) 
 
Primary pointer page: 755, Index root page: 756 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.02, total records: 2581161 
 
Average version length: 82.88, total versions: 13802, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.64 
 
Pointer pages: 26, data page slots: 40952 
 
Data pages: 40952, average fill: 78% 
 
Primary pages: 40952, secondary pages: 0, swept pages: 30404 
 
Empty pages: 89, full pages: 36985 
 
Fill distribution: 
 
0 - 19% = 148 
 
20 - 39% = 217 
 
40 - 59% = 867 
 
60 - 79% = 17729 
 
80 - 99% = 21991 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 73800, depth: 3, leaf buckets: 2774, nodes: 2581161 
 
Average node length: 5.15, total dup: 2520860, max dup: 187 
 
Average key length: 2.18, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 405343, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 60 
 
40 - 59% = 1649 
 
60 - 79% = 790 
 
80 - 99% = 273 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 109107, depth: 3, leaf buckets: 4253, nodes: 2581161 
 
Average node length: 6.24, total dup: 2110465, max dup: 14 
 
Average key length: 3.27, compression ratio: 2.75 
 
Average prefix length: 7.91, average data length: 1.09 
 
Clustering factor: 234137, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 123 
 
20 - 39% = 1550 
 
40 - 59% = 1663 
 
60 - 79% = 590 
 
80 - 99% = 327 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 63881, depth: 3, leaf buckets: 3154, nodes: 2581161 
 
Average node length: 5.81, total dup: 2258207, max dup: 29 
 
Average key length: 2.84, compression ratio: 3.17 
 
Average prefix length: 8.29, average data length: 0.71 
 
Clustering factor: 487581, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 22 
 
20 - 39% = 75 
 
40 - 59% = 1867 
 
60 - 79% = 894 
 
80 - 99% = 296 
 
 
XQS_1200_2000 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.73, total records: 5008533 
 
Average version length: 85.42, total versions: 10709, 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: 49, data page slots: 78944 
 
Data pages: 78880, average fill: 79% 
 
Primary pages: 78880, secondary pages: 0, swept pages: 24311 
 
Empty pages: 424, full pages: 72890 
 
Fill distribution: 
 
0 - 19% = 640 
 
20 - 39% = 639 
 
40 - 59% = 1782 
 
60 - 79% = 16563 
 
80 - 99% = 59256 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57493, depth: 3, leaf buckets: 5269, nodes: 5008533 
 
Average node length: 5.04, total dup: 4979066, max dup: 725 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 738795, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 186 
 
40 - 59% = 3059 
 
60 - 79% = 1463 
 
80 - 99% = 555 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 83243, depth: 3, leaf buckets: 6060, nodes: 5008533 
 
Average node length: 5.53, total dup: 4613831, max dup: 49 
 
Average key length: 2.54, compression ratio: 3.54 
 
Average prefix length: 8.54, average data length: 0.46 
 
Clustering factor: 246325, ratio: 0.05 
 
Fill distribution: 
 
0 - 19% = 100 
 
20 - 39% = 1542 
 
40 - 59% = 2439 
 
60 - 79% = 608 
 
80 - 99% = 1371 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49462, depth: 3, leaf buckets: 5929, nodes: 5008533 
 
Average node length: 5.69, total dup: 4488674, max dup: 67 
 
Average key length: 2.70, compression ratio: 3.33 
 
Average prefix length: 8.40, average data length: 0.60 
 
Clustering factor: 819239, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 169 
 
40 - 59% = 3459 
 
60 - 79% = 1667 
 
80 - 99% = 630 
 
 
XQS_2000_3300 (269) 
 
Primary pointer page: 761, Index root page: 762 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_DOC_ID (0) 
 
Root page: 763, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_RCV_ID (2) 
 
Root page: 765, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index XQS_2000_3300_SND_ID (1) 
 
Root page: 764, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
XQS_2100_3300 (270) 
 
Primary pointer page: 767, Index root page: 776 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.33, total records: 3410995 
 
Average version length: 83.34, total versions: 13086, 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: 34, data page slots: 53936 
 
Data pages: 53936, average fill: 78% 
 
Primary pages: 53936, secondary pages: 0, swept pages: 38374 
 
Empty pages: 99, full pages: 49356 
 
Fill distribution: 
 
0 - 19% = 171 
 
20 - 39% = 282 
 
40 - 59% = 1042 
 
60 - 79% = 20803 
 
80 - 99% = 31638 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 89055, depth: 3, leaf buckets: 3729, nodes: 3410995 
 
Average node length: 5.03, total dup: 3394297, max dup: 1217 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 663514, ratio: 0.19 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 405 
 
40 - 59% = 2026 
 
60 - 79% = 880 
 
80 - 99% = 402 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 109104, depth: 3, leaf buckets: 5629, nodes: 3410995 
 
Average node length: 6.26, total dup: 2784786, max dup: 14 
 
Average key length: 3.28, compression ratio: 2.75 
 
Average prefix length: 7.90, average data length: 1.10 
 
Clustering factor: 346652, ratio: 0.10 
 
Fill distribution: 
 
0 - 19% = 188 
 
20 - 39% = 2027 
 
40 - 59% = 2200 
 
60 - 79% = 743 
 
80 - 99% = 471 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 77230, depth: 3, leaf buckets: 4121, nodes: 3410995 
 
Average node length: 5.59, total dup: 3109249, max dup: 61 
 
Average key length: 2.61, compression ratio: 3.45 
 
Average prefix length: 8.48, average data length: 0.52 
 
Clustering factor: 709553, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 11 
 
20 - 39% = 425 
 
40 - 59% = 2171 
 
60 - 79% = 1060 
 
80 - 99% = 454 
 
 
XQS_3300_3400 (271) 
 
Primary pointer page: 780, Index root page: 781 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.05, total records: 665026 
 
Average version length: 69.09, total versions: 4123, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.97 
 
Pointer pages: 6, data page slots: 9288 
 
Data pages: 9288, average fill: 76% 
 
Primary pages: 9288, secondary pages: 0, swept pages: 7055 
 
Empty pages: 15, full pages: 8540 
 
Fill distribution: 
 
0 - 19% = 38 
 
20 - 39% = 57 
 
40 - 59% = 194 
 
60 - 79% = 8916 
 
80 - 99% = 83 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 178269, depth: 3, leaf buckets: 813, nodes: 665026 
 
Average node length: 5.31, total dup: 627047, max dup: 135 
 
Average key length: 2.44, compression ratio: 3.70 
 
Average prefix length: 8.62, average data length: 0.38 
 
Clustering factor: 55187, ratio: 0.08 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 204 
 
40 - 59% = 322 
 
60 - 79% = 199 
 
80 - 99% = 86 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 150306, depth: 3, leaf buckets: 908, nodes: 665026 
 
Average node length: 5.93, total dup: 568008, max dup: 23 
 
Average key length: 3.05, compression ratio: 2.95 
 
Average prefix length: 8.09, average data length: 0.91 
 
Clustering factor: 60881, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 215 
 
40 - 59% = 395 
 
60 - 79% = 207 
 
80 - 99% = 90 
 
 
ZDOC_DATA (230) 
 
Primary pointer page: 644, Index root page: 645 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZDOC_LIST (229) 
 
Primary pointer page: 642, Index root page: 643 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZINVNT_TURNOVER_LOG (231) 
 
Primary pointer page: 646, Index root page: 647 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPDISTR (234) 
 
Primary pointer page: 652, Index root page: 653 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPDISTR_ID (0) 
 
Root page: 662, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZPSTORNED (235) 
 
Primary pointer page: 654, Index root page: 655 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZPSTORNED_ID (0) 
 
Root page: 663, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQDISTR (232) 
 
Primary pointer page: 648, Index root page: 649 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_ID (0) 
 
Root page: 656, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQDISTR_WARE_SNDOP_RCVOP (1) 
 
Root page: 657, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZQSTORNED (233) 
 
Primary pointer page: 650, Index root page: 651 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_DOC_ID (1) 
 
Root page: 659, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_ID (0) 
 
Root page: 658, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_RCV_ID (3) 
 
Root page: 661, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index ZQSTORNED_SND_ID (2) 
 
Root page: 660, depth: 1, leaf buckets: 1, nodes: 0 
 
Average node length: 0.00, total dup: 0, max dup: 0 
 
Average key length: 0.00, compression ratio: 0.00 
 
Average prefix length: 0.00, average data length: 0.00 
 
Clustering factor: 0, ratio: 0.00 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_DEP_DOCS (228) 
 
Primary pointer page: 640, Index root page: 641 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
ZTMP_SHOPPING_CART (227) 
 
Primary pointer page: 614, Index root page: 615 
 
Total formats: 1, used formats: 0 
 
Average record length: 0.00, total records: 0 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 0.00, compression ratio: 0.00 
 
Pointer pages: 1, data page slots: 0 
 
Data pages: 0, average fill: 0% 
 
Primary pages: 0, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Z_USED_VIEWS (146) 
 
Primary pointer page: 268, Index root page: 269 
 
Total formats: 1, used formats: 1 
 
Average record length: 29.38, total records: 29 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 99.00, compression ratio: 3.37 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 16% 
 
Primary pages: 1, secondary pages: 0, swept pages: 0 
 
Empty pages: 0, full pages: 0 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index Z_USED_VIEWS_UNQ (0) 
 
Root page: 281, depth: 1, leaf buckets: 1, nodes: 29 
 
Average node length: 15.17, total dup: 0, max dup: 0 
 
Average key length: 14.14, compression ratio: 1.44 
 
Average prefix length: 9.17, average data length: 11.17 
 
Clustering factor: 1, ratio: 0.03 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Gstat completion time Sun Dec 10 07:09:47 2017 
 
 
Done for 61900 ms, from  7:08:45.94 to  7:09:47.84. 
 
 
 
|  TABLE_NAME  | 
 TOTAL_RECS  | 
 TOTAL_VERS  | 
 VERS_PERCENT  | 
|  AGENTS  | 
 50  | 
 0  | 
 0.0000  | 
|  BUSINESS_OPS  | 
 19  | 
 0  | 
 0.0000  | 
|  DOC_DATA  | 
 2170418  | 
 3487  | 
 0.1606  | 
|  DOC_LIST  | 
 667870  | 
 3388  | 
 0.5072  | 
|  DOC_STATES  | 
 4  | 
 0  | 
 0.0000  | 
|  FB_ERRORS  | 
 758  | 
 0  | 
 0.0000  | 
|  INVNT_SALDO  | 
 400  | 
 45872  | 
   11468.0000  | 
|  INVNT_TURNOVER_LOG  | 
 9251  | 
 8807  | 
 95.2005  | 
|  MONEY_SALDO  | 
 49  | 
 4193  | 
   8557.1428  | 
|  MONEY_TURNOVER_LOG  | 
 525  | 
 471  | 
 89.7142  | 
|  OPTYPES  | 
 9  | 
 0  | 
 0.0000  | 
|  PDISTR  | 
 218702  | 
 7516  | 
 3.4366  | 
|  PERF_ESTIMATED  | 
 275791  | 
 0  | 
 0.0000  | 
|  PERF_LOG  | 
 12441050  | 
 0  | 
 0.0000  | 
|  PSTORNED  | 
 469876  | 
 865  | 
 0.1840  | 
|  RULES_FOR_PDISTR  | 
 4  | 
 0  | 
 0.0000  | 
|  RULES_FOR_QDISTR  | 
 7  | 
 0  | 
 0.0000  | 
|  SEMAPHORES  | 
 4  | 
 1301  | 
   32525.0000  | 
|  SETTINGS  | 
 114  | 
 0  | 
 0.0000  | 
|  TRACE_STAT  | 
 2697  | 
 0  | 
 0.0000  | 
|  WARES  | 
 400  | 
 0  | 
 0.0000  | 
|  WARE_GROUPS  | 
 8  | 
 0  | 
 0.0000  | 
|  XQD_1000_1200  | 
 18445  | 
 14708  | 
 79.7397  | 
|  XQD_1000_3300  | 
 993807  | 
 8259  | 
 0.8310  | 
|  XQD_1200_2000  | 
 58873  | 
 40353  | 
 68.5424  | 
|  XQD_2000_3300  | 
 1641903  | 
 42886  | 
 2.6119  | 
|  XQD_2100_3300  | 
 8177  | 
 7279  | 
 89.0179  | 
|  XQD_3300_3400  | 
 2754607  | 
 17601  | 
 0.6389  | 
|  XQS_1000_1200  | 
 4724681  | 
 2706  | 
 0.0572  | 
|  XQS_1000_3300  | 
 2581161  | 
 13802  | 
 0.5347  | 
|  XQS_1200_2000  | 
 5008533  | 
 10709  | 
 0.2138  | 
|  XQS_2100_3300  | 
 3410995  | 
 13086  | 
 0.3836  | 
|  XQS_3300_3400  | 
 665026  | 
 4123  | 
 0.6199  | 
|  Z_USED_VIEWS  | 
 29  | 
 0  | 
 0.0000  | 
 
Done for 2100 ms, from  7:09:59.06 to  7:10:01.16.  
07:10:01.27 Validation started 
 
 
07:10:01.30 Relation 140 (DOC_LIST) 
 
07:10:01.30   process pointer page    0 of    6 
 
07:10:01.41   process pointer page    1 of    6 
 
07:10:01.51   process pointer page    2 of    6 
 
07:10:01.55   process pointer page    3 of    6 
 
07:10:01.60   process pointer page    4 of    6 
 
07:10:01.69   process pointer page    5 of    6 
 
07:10:01.71 Index 1 (PK_DOC_LIST) 
 
07:10:01.88 Index 2 (DOC_LIST_ID_DESC) 
 
07:10:02.01 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:10:02.13 Relation 140 (DOC_LIST) is ok 
 
 
07:10:02.13 Relation 141 (DOC_DATA) 
 
07:10:02.13   process pointer page    0 of   15 
 
07:10:02.24   process pointer page    1 of   15 
 
07:10:02.33   process pointer page    2 of   15 
 
07:10:02.41   process pointer page    3 of   15 
 
07:10:02.46   process pointer page    4 of   15 
 
07:10:02.51   process pointer page    5 of   15 
 
07:10:02.54   process pointer page    6 of   15 
 
07:10:02.57   process pointer page    7 of   15 
 
07:10:02.62   process pointer page    8 of   15 
 
07:10:02.65   process pointer page    9 of   15 
 
07:10:02.68   process pointer page   10 of   15 
 
07:10:02.72   process pointer page   11 of   15 
 
07:10:02.82   process pointer page   12 of   15 
 
07:10:02.93   process pointer page   13 of   15 
 
07:10:02.97   process pointer page   14 of   15 
 
07:10:02.99 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:10:03.38 Index 3 (DOC_DATA_ID_DESC) 
 
07:10:03.96 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:10:04.32 Relation 141 (DOC_DATA) is ok 
 
 
07:10:04.32 Relation 147 (INVNT_SALDO) 
 
07:10:04.32   process pointer page    0 of    1 
 
07:10:04.36 Index 1 (PK_INVNT_SALDO) 
 
07:10:04.36 Relation 147 (INVNT_SALDO) is ok 
 
 
07:10:04.36 Relation 150 (PDISTR) 
 
07:10:04.36   process pointer page    0 of    2 
 
07:10:04.39   process pointer page    1 of    2 
 
07:10:04.42 Index 2 (PDISTR_SND_ID) 
 
07:10:04.44 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:10:04.47 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:10:04.49 Index 5 (PDISTR_AGENT_ID) 
 
07:10:04.50 Relation 150 (PDISTR) is ok 
 
 
07:10:04.50 Relation 151 (PSTORNED) 
 
07:10:04.50   process pointer page    0 of    4 
 
07:10:04.53   process pointer page    1 of    4 
 
07:10:04.57   process pointer page    2 of    4 
 
07:10:04.60   process pointer page    3 of    4 
 
07:10:04.61 Index 2 (PSTORNED_SND_ID) 
 
07:10:04.64 Index 3 (PSTORNED_RCV_ID) 
 
07:10:04.69 Relation 151 (PSTORNED) is ok 
 
 
07:10:04.69 Relation 156 (SEMAPHORES) 
 
07:10:04.69   process pointer page    0 of    1 
 
07:10:04.69 Index 1 (PK_SEMAPHORES) 
 
07:10:04.69 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:10:04.69 Relation 156 (SEMAPHORES) is ok 
 
 
07:10:04.69 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:10:04.69   process pointer page    0 of    1 
 
07:10:04.69 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:10:04.69 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:10:04.69 Relation 160 (PERF_ESTIMATED) 
 
07:10:04.69   process pointer page    0 of    2 
 
07:10:04.72   process pointer page    1 of    2 
 
07:10:04.74 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:10:04.77 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:10:04.77 Relation 161 (PERF_ISQL_STAT) 
 
07:10:04.77   process pointer page    0 of    1 
 
07:10:04.77 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:10:04.77 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:10:04.77 Relation 162 (TRACE_STAT) 
 
07:10:04.77   process pointer page    0 of    1 
 
07:10:04.77 Relation 162 (TRACE_STAT) is ok 
 
 
07:10:04.77 Relation 163 (PERF_LOG) 
 
07:10:04.77   process pointer page    0 of  181 
 
07:10:04.81   process pointer page    1 of  181 
 
07:10:04.85   process pointer page    2 of  181 
 
07:10:04.92   process pointer page    3 of  181 
 
07:10:05.00   process pointer page    4 of  181 
 
07:10:05.10   process pointer page    5 of  181 
 
07:10:05.14   process pointer page    6 of  181 
 
07:10:05.20   process pointer page    7 of  181 
 
07:10:05.30   process pointer page    8 of  181 
 
07:10:05.36   process pointer page    9 of  181 
 
07:10:05.41   process pointer page   10 of  181 
 
07:10:05.44   process pointer page   11 of  181 
 
07:10:05.50   process pointer page   12 of  181 
 
07:10:05.56   process pointer page   13 of  181 
 
07:10:05.61   process pointer page   14 of  181 
 
07:10:05.64   process pointer page   15 of  181 
 
07:10:05.67   process pointer page   16 of  181 
 
07:10:05.70   process pointer page   17 of  181 
 
07:10:05.74   process pointer page   18 of  181 
 
07:10:05.77   process pointer page   19 of  181 
 
07:10:05.80   process pointer page   20 of  181 
 
07:10:05.83   process pointer page   21 of  181 
 
07:10:05.86   process pointer page   22 of  181 
 
07:10:05.89   process pointer page   23 of  181 
 
07:10:05.95   process pointer page   24 of  181 
 
07:10:06.02   process pointer page   25 of  181 
 
07:10:06.05   process pointer page   26 of  181 
 
07:10:06.09   process pointer page   27 of  181 
 
07:10:06.16   process pointer page   28 of  181 
 
07:10:06.25   process pointer page   29 of  181 
 
07:10:06.34   process pointer page   30 of  181 
 
07:10:06.42   process pointer page   31 of  181 
 
07:10:06.52   process pointer page   32 of  181 
 
07:10:06.59   process pointer page   33 of  181 
 
07:10:06.69   process pointer page   34 of  181 
 
07:10:06.76   process pointer page   35 of  181 
 
07:10:06.80   process pointer page   36 of  181 
 
07:10:06.83   process pointer page   37 of  181 
 
07:10:06.89   process pointer page   38 of  181 
 
07:10:06.98   process pointer page   39 of  181 
 
07:10:07.03   process pointer page   40 of  181 
 
07:10:07.06   process pointer page   41 of  181 
 
07:10:07.11   process pointer page   42 of  181 
 
07:10:07.20   process pointer page   43 of  181 
 
07:10:07.28   process pointer page   44 of  181 
 
07:10:07.37   process pointer page   45 of  181 
 
07:10:07.45   process pointer page   46 of  181 
 
07:10:07.50   process pointer page   47 of  181 
 
07:10:07.53   process pointer page   48 of  181 
 
07:10:07.58   process pointer page   49 of  181 
 
07:10:07.67   process pointer page   50 of  181 
 
07:10:07.70   process pointer page   51 of  181 
 
07:10:07.73   process pointer page   52 of  181 
 
07:10:07.76   process pointer page   53 of  181 
 
07:10:07.81   process pointer page   54 of  181 
 
07:10:07.89   process pointer page   55 of  181 
 
07:10:07.93   process pointer page   56 of  181 
 
07:10:07.97   process pointer page   57 of  181 
 
07:10:08.01   process pointer page   58 of  181 
 
07:10:08.04   process pointer page   59 of  181 
 
07:10:08.08   process pointer page   60 of  181 
 
07:10:08.12   process pointer page   61 of  181 
 
07:10:08.20   process pointer page   62 of  181 
 
07:10:08.29   process pointer page   63 of  181 
 
07:10:08.39   process pointer page   64 of  181 
 
07:10:08.47   process pointer page   65 of  181 
 
07:10:08.50   process pointer page   66 of  181 
 
07:10:08.53   process pointer page   67 of  181 
 
07:10:08.57   process pointer page   68 of  181 
 
07:10:08.61   process pointer page   69 of  181 
 
07:10:08.64   process pointer page   70 of  181 
 
07:10:08.68   process pointer page   71 of  181 
 
07:10:08.71   process pointer page   72 of  181 
 
07:10:08.75   process pointer page   73 of  181 
 
07:10:08.78   process pointer page   74 of  181 
 
07:10:08.81   process pointer page   75 of  181 
 
07:10:08.84   process pointer page   76 of  181 
 
07:10:08.87   process pointer page   77 of  181 
 
07:10:08.90   process pointer page   78 of  181 
 
07:10:08.92   process pointer page   79 of  181 
 
07:10:08.95   process pointer page   80 of  181 
 
07:10:08.98   process pointer page   81 of  181 
 
07:10:09.01   process pointer page   82 of  181 
 
07:10:09.03   process pointer page   83 of  181 
 
07:10:09.06   process pointer page   84 of  181 
 
07:10:09.09   process pointer page   85 of  181 
 
07:10:09.10   process pointer page   86 of  181 
 
07:10:09.14   process pointer page   87 of  181 
 
07:10:09.17   process pointer page   88 of  181 
 
07:10:09.20   process pointer page   89 of  181 
 
07:10:09.26   process pointer page   90 of  181 
 
07:10:09.29   process pointer page   91 of  181 
 
07:10:09.32   process pointer page   92 of  181 
 
07:10:09.35   process pointer page   93 of  181 
 
07:10:09.39   process pointer page   94 of  181 
 
07:10:09.42   process pointer page   95 of  181 
 
07:10:09.43   process pointer page   96 of  181 
 
07:10:09.46   process pointer page   97 of  181 
 
07:10:09.48   process pointer page   98 of  181 
 
07:10:09.51   process pointer page   99 of  181 
 
07:10:09.56   process pointer page  100 of  181 
 
07:10:09.59   process pointer page  101 of  181 
 
07:10:09.62   process pointer page  102 of  181 
 
07:10:09.65   process pointer page  103 of  181 
 
07:10:09.71   process pointer page  104 of  181 
 
07:10:09.76   process pointer page  105 of  181 
 
07:10:09.82   process pointer page  106 of  181 
 
07:10:09.85   process pointer page  107 of  181 
 
07:10:09.92   process pointer page  108 of  181 
 
07:10:10.01   process pointer page  109 of  181 
 
07:10:10.07   process pointer page  110 of  181 
 
07:10:10.10   process pointer page  111 of  181 
 
07:10:10.13   process pointer page  112 of  181 
 
07:10:10.20   process pointer page  113 of  181 
 
07:10:10.29   process pointer page  114 of  181 
 
07:10:10.37   process pointer page  115 of  181 
 
07:10:10.46   process pointer page  116 of  181 
 
07:10:10.56   process pointer page  117 of  181 
 
07:10:10.62   process pointer page  118 of  181 
 
07:10:10.65   process pointer page  119 of  181 
 
07:10:10.74   process pointer page  120 of  181 
 
07:10:10.84   process pointer page  121 of  181 
 
07:10:10.91   process pointer page  122 of  181 
 
07:10:10.98   process pointer page  123 of  181 
 
07:10:11.01   process pointer page  124 of  181 
 
07:10:11.04   process pointer page  125 of  181 
 
07:10:11.10   process pointer page  126 of  181 
 
07:10:11.20   process pointer page  127 of  181 
 
07:10:11.29   process pointer page  128 of  181 
 
07:10:11.37   process pointer page  129 of  181 
 
07:10:11.46   process pointer page  130 of  181 
 
07:10:11.55   process pointer page  131 of  181 
 
07:10:11.62   process pointer page  132 of  181 
 
07:10:11.66   process pointer page  133 of  181 
 
07:10:11.69   process pointer page  134 of  181 
 
07:10:11.73   process pointer page  135 of  181 
 
07:10:11.76   process pointer page  136 of  181 
 
07:10:11.79   process pointer page  137 of  181 
 
07:10:11.83   process pointer page  138 of  181 
 
07:10:11.91   process pointer page  139 of  181 
 
07:10:11.94   process pointer page  140 of  181 
 
07:10:11.99   process pointer page  141 of  181 
 
07:10:12.02   process pointer page  142 of  181 
 
07:10:12.05   process pointer page  143 of  181 
 
07:10:12.08   process pointer page  144 of  181 
 
07:10:12.13   process pointer page  145 of  181 
 
07:10:12.22   process pointer page  146 of  181 
 
07:10:12.32   process pointer page  147 of  181 
 
07:10:12.40   process pointer page  148 of  181 
 
07:10:12.49   process pointer page  149 of  181 
 
07:10:12.57   process pointer page  150 of  181 
 
07:10:12.60   process pointer page  151 of  181 
 
07:10:12.63   process pointer page  152 of  181 
 
07:10:12.68   process pointer page  153 of  181 
 
07:10:12.71   process pointer page  154 of  181 
 
07:10:12.74   process pointer page  155 of  181 
 
07:10:12.77   process pointer page  156 of  181 
 
07:10:12.80   process pointer page  157 of  181 
 
07:10:12.83   process pointer page  158 of  181 
 
07:10:12.86   process pointer page  159 of  181 
 
07:10:12.96   process pointer page  160 of  181 
 
07:10:13.04   process pointer page  161 of  181 
 
07:10:13.11   process pointer page  162 of  181 
 
07:10:13.15   process pointer page  163 of  181 
 
07:10:13.19   process pointer page  164 of  181 
 
07:10:13.22   process pointer page  165 of  181 
 
07:10:13.25   process pointer page  166 of  181 
 
07:10:13.29   process pointer page  167 of  181 
 
07:10:13.32   process pointer page  168 of  181 
 
07:10:13.35   process pointer page  169 of  181 
 
07:10:13.38   process pointer page  170 of  181 
 
07:10:13.41   process pointer page  171 of  181 
 
07:10:13.44   process pointer page  172 of  181 
 
07:10:13.52   process pointer page  173 of  181 
 
07:10:13.58   process pointer page  174 of  181 
 
07:10:13.63   process pointer page  175 of  181 
 
07:10:13.72   process pointer page  176 of  181 
 
07:10:13.78   process pointer page  177 of  181 
 
07:10:13.82   process pointer page  178 of  181 
 
07:10:13.85   process pointer page  179 of  181 
 
07:10:13.93   process pointer page  180 of  181 
 
07:10:13.97 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:10:16.22 Index 2 (PERF_LOG_UNIT) 
 
07:10:20.13 Index 3 (PERF_LOG_TRN_DESC) 
 
07:10:22.26 Index 4 (PERF_LOG_GDSCODE) 
 
07:10:23.55 Relation 163 (PERF_LOG) is ok 
 
 
07:10:23.55 Relation 167 (V_STOPTEST) 
 
07:10:23.55 Relation 167 (V_STOPTEST) is ok 
 
 
07:10:23.55 Relation 184 (V_QDISTR_SOURCE) 
 
07:10:23.55 Relation 184 (V_QDISTR_SOURCE) is ok 
 
 
07:10:23.55 Relation 185 (V_QSTORNED_SOURCE) 
 
07:10:23.55 Relation 185 (V_QSTORNED_SOURCE) is ok 
 
 
07:10:23.55 Relation 260 (XQD_1000_1200) 
 
07:10:23.55   process pointer page    0 of    2 
 
07:10:23.57   process pointer page    1 of    2 
 
07:10:23.57 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:10:23.57 Relation 260 (XQD_1000_1200) is ok 
 
 
07:10:23.57 Relation 261 (XQD_1200_2000) 
 
07:10:23.57   process pointer page    0 of    4 
 
07:10:23.58   process pointer page    1 of    4 
 
07:10:23.60   process pointer page    2 of    4 
 
07:10:23.66   process pointer page    3 of    4 
 
07:10:23.68 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:10:23.69 Relation 261 (XQD_1200_2000) is ok 
 
 
07:10:23.69 Relation 262 (XQD_1000_3300) 
 
07:10:23.69   process pointer page    0 of   10 
 
07:10:23.80   process pointer page    1 of   10 
 
07:10:23.89   process pointer page    2 of   10 
 
07:10:23.94   process pointer page    3 of   10 
 
07:10:24.02   process pointer page    4 of   10 
 
07:10:24.11   process pointer page    5 of   10 
 
07:10:24.21   process pointer page    6 of   10 
 
07:10:24.30   process pointer page    7 of   10 
 
07:10:24.38   process pointer page    8 of   10 
 
07:10:24.41   process pointer page    9 of   10 
 
07:10:24.41 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:10:24.55 Index 2 (XQD_1000_3300_DOC) 
 
07:10:24.64 Relation 262 (XQD_1000_3300) is ok 
 
 
07:10:24.64 Relation 263 (XQD_2000_3300) 
 
07:10:24.64   process pointer page    0 of   17 
 
07:10:24.67   process pointer page    1 of   17 
 
07:10:24.70   process pointer page    2 of   17 
 
07:10:24.74   process pointer page    3 of   17 
 
07:10:24.77   process pointer page    4 of   17 
 
07:10:24.80   process pointer page    5 of   17 
 
07:10:24.81   process pointer page    6 of   17 
 
07:10:24.85   process pointer page    7 of   17 
 
07:10:24.89   process pointer page    8 of   17 
 
07:10:24.92   process pointer page    9 of   17 
 
07:10:24.97   process pointer page   10 of   17 
 
07:10:25.00   process pointer page   11 of   17 
 
07:10:25.02   process pointer page   12 of   17 
 
07:10:25.05   process pointer page   13 of   17 
 
07:10:25.08   process pointer page   14 of   17 
 
07:10:25.11   process pointer page   15 of   17 
 
07:10:25.14   process pointer page   16 of   17 
 
07:10:25.14 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:10:25.52 Relation 263 (XQD_2000_3300) is ok 
 
 
07:10:25.52 Relation 264 (XQD_2100_3300) 
 
07:10:25.52   process pointer page    0 of    4 
 
07:10:25.53   process pointer page    1 of    4 
 
07:10:25.55   process pointer page    2 of    4 
 
07:10:25.55   process pointer page    3 of    4 
 
07:10:25.55 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:10:25.55 Relation 264 (XQD_2100_3300) is ok 
 
 
07:10:25.55 Relation 265 (XQD_3300_3400) 
 
07:10:25.55   process pointer page    0 of   25 
 
07:10:25.63   process pointer page    1 of   25 
 
07:10:25.73   process pointer page    2 of   25 
 
07:10:25.84   process pointer page    3 of   25 
 
07:10:25.94   process pointer page    4 of   25 
 
07:10:26.05   process pointer page    5 of   25 
 
07:10:26.12   process pointer page    6 of   25 
 
07:10:26.16   process pointer page    7 of   25 
 
07:10:26.20   process pointer page    8 of   25 
 
07:10:26.30   process pointer page    9 of   25 
 
07:10:26.37   process pointer page   10 of   25 
 
07:10:26.41   process pointer page   11 of   25 
 
07:10:26.50   process pointer page   12 of   25 
 
07:10:26.61   process pointer page   13 of   25 
 
07:10:26.64   process pointer page   14 of   25 
 
07:10:26.69   process pointer page   15 of   25 
 
07:10:26.72   process pointer page   16 of   25 
 
07:10:26.78   process pointer page   17 of   25 
 
07:10:26.87   process pointer page   18 of   25 
 
07:10:26.98   process pointer page   19 of   25 
 
07:10:27.04   process pointer page   20 of   25 
 
07:10:27.08   process pointer page   21 of   25 
 
07:10:27.12   process pointer page   22 of   25 
 
07:10:27.15   process pointer page   23 of   25 
 
07:10:27.19   process pointer page   24 of   25 
 
07:10:27.20 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:10:27.90 Relation 265 (XQD_3300_3400) is ok 
 
 
07:10:27.90 Relation 266 (XQS_1000_1200) 
 
07:10:27.90   process pointer page    0 of   45 
 
07:10:27.95   process pointer page    1 of   45 
 
07:10:27.98   process pointer page    2 of   45 
 
07:10:28.03   process pointer page    3 of   45 
 
07:10:28.06   process pointer page    4 of   45 
 
07:10:28.09   process pointer page    5 of   45 
 
07:10:28.12   process pointer page    6 of   45 
 
07:10:28.15   process pointer page    7 of   45 
 
07:10:28.18   process pointer page    8 of   45 
 
07:10:28.21   process pointer page    9 of   45 
 
07:10:28.25   process pointer page   10 of   45 
 
07:10:28.28   process pointer page   11 of   45 
 
07:10:28.36   process pointer page   12 of   45 
 
07:10:28.45   process pointer page   13 of   45 
 
07:10:28.53   process pointer page   14 of   45 
 
07:10:28.59   process pointer page   15 of   45 
 
07:10:28.68   process pointer page   16 of   45 
 
07:10:28.79   process pointer page   17 of   45 
 
07:10:28.89   process pointer page   18 of   45 
 
07:10:28.98   process pointer page   19 of   45 
 
07:10:29.06   process pointer page   20 of   45 
 
07:10:29.10   process pointer page   21 of   45 
 
07:10:29.15   process pointer page   22 of   45 
 
07:10:29.18   process pointer page   23 of   45 
 
07:10:29.21   process pointer page   24 of   45 
 
07:10:29.24   process pointer page   25 of   45 
 
07:10:29.35   process pointer page   26 of   45 
 
07:10:29.40   process pointer page   27 of   45 
 
07:10:29.48   process pointer page   28 of   45 
 
07:10:29.57   process pointer page   29 of   45 
 
07:10:29.67   process pointer page   30 of   45 
 
07:10:29.70   process pointer page   31 of   45 
 
07:10:29.81   process pointer page   32 of   45 
 
07:10:29.92   process pointer page   33 of   45 
 
07:10:30.01   process pointer page   34 of   45 
 
07:10:30.12   process pointer page   35 of   45 
 
07:10:30.21   process pointer page   36 of   45 
 
07:10:30.32   process pointer page   37 of   45 
 
07:10:30.41   process pointer page   38 of   45 
 
07:10:30.52   process pointer page   39 of   45 
 
07:10:30.59   process pointer page   40 of   45 
 
07:10:30.63   process pointer page   41 of   45 
 
07:10:30.66   process pointer page   42 of   45 
 
07:10:30.71   process pointer page   43 of   45 
 
07:10:30.76   process pointer page   44 of   45 
 
07:10:30.77 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:10:31.38 Index 2 (XQS_1000_1200_SND_ID) 
 
07:10:32.54 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:10:33.46 Relation 266 (XQS_1000_1200) is ok 
 
 
07:10:33.46 Relation 267 (XQS_1200_2000) 
 
07:10:33.46   process pointer page    0 of   49 
 
07:10:33.57   process pointer page    1 of   49 
 
07:10:33.67   process pointer page    2 of   49 
 
07:10:33.77   process pointer page    3 of   49 
 
07:10:33.82   process pointer page    4 of   49 
 
07:10:33.85   process pointer page    5 of   49 
 
07:10:33.89   process pointer page    6 of   49 
 
07:10:33.99   process pointer page    7 of   49 
 
07:10:34.06   process pointer page    8 of   49 
 
07:10:34.11   process pointer page    9 of   49 
 
07:10:34.16   process pointer page   10 of   49 
 
07:10:34.19   process pointer page   11 of   49 
 
07:10:34.24   process pointer page   12 of   49 
 
07:10:34.27   process pointer page   13 of   49 
 
07:10:34.30   process pointer page   14 of   49 
 
07:10:34.35   process pointer page   15 of   49 
 
07:10:34.38   process pointer page   16 of   49 
 
07:10:34.41   process pointer page   17 of   49 
 
07:10:34.50   process pointer page   18 of   49 
 
07:10:34.55   process pointer page   19 of   49 
 
07:10:34.60   process pointer page   20 of   49 
 
07:10:34.63   process pointer page   21 of   49 
 
07:10:34.67   process pointer page   22 of   49 
 
07:10:34.70   process pointer page   23 of   49 
 
07:10:34.74   process pointer page   24 of   49 
 
07:10:34.77   process pointer page   25 of   49 
 
07:10:34.81   process pointer page   26 of   49 
 
07:10:34.83   process pointer page   27 of   49 
 
07:10:34.91   process pointer page   28 of   49 
 
07:10:34.99   process pointer page   29 of   49 
 
07:10:35.02   process pointer page   30 of   49 
 
07:10:35.06   process pointer page   31 of   49 
 
07:10:35.09   process pointer page   32 of   49 
 
07:10:35.13   process pointer page   33 of   49 
 
07:10:35.17   process pointer page   34 of   49 
 
07:10:35.20   process pointer page   35 of   49 
 
07:10:35.23   process pointer page   36 of   49 
 
07:10:35.28   process pointer page   37 of   49 
 
07:10:35.39   process pointer page   38 of   49 
 
07:10:35.48   process pointer page   39 of   49 
 
07:10:35.59   process pointer page   40 of   49 
 
07:10:35.64   process pointer page   41 of   49 
 
07:10:35.67   process pointer page   42 of   49 
 
07:10:35.72   process pointer page   43 of   49 
 
07:10:35.75   process pointer page   44 of   49 
 
07:10:35.80   process pointer page   45 of   49 
 
07:10:35.83   process pointer page   46 of   49 
 
07:10:35.86   process pointer page   47 of   49 
 
07:10:35.89   process pointer page   48 of   49 
 
07:10:35.91 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:10:36.84 Index 2 (XQS_1200_2000_SND_ID) 
 
07:10:37.65 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:10:38.14 Relation 267 (XQS_1200_2000) is ok 
 
 
07:10:38.14 Relation 268 (XQS_1000_3300) 
 
07:10:38.14   process pointer page    0 of   26 
 
07:10:38.18   process pointer page    1 of   26 
 
07:10:38.23   process pointer page    2 of   26 
 
07:10:38.26   process pointer page    3 of   26 
 
07:10:38.31   process pointer page    4 of   26 
 
07:10:38.34   process pointer page    5 of   26 
 
07:10:38.43   process pointer page    6 of   26 
 
07:10:38.54   process pointer page    7 of   26 
 
07:10:38.67   process pointer page    8 of   26 
 
07:10:38.76   process pointer page    9 of   26 
 
07:10:38.81   process pointer page   10 of   26 
 
07:10:38.85   process pointer page   11 of   26 
 
07:10:38.90   process pointer page   12 of   26 
 
07:10:38.99   process pointer page   13 of   26 
 
07:10:39.04   process pointer page   14 of   26 
 
07:10:39.09   process pointer page   15 of   26 
 
07:10:39.13   process pointer page   16 of   26 
 
07:10:39.18   process pointer page   17 of   26 
 
07:10:39.21   process pointer page   18 of   26 
 
07:10:39.26   process pointer page   19 of   26 
 
07:10:39.37   process pointer page   20 of   26 
 
07:10:39.46   process pointer page   21 of   26 
 
07:10:39.51   process pointer page   22 of   26 
 
07:10:39.56   process pointer page   23 of   26 
 
07:10:39.60   process pointer page   24 of   26 
 
07:10:39.63   process pointer page   25 of   26 
 
07:10:39.65 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:10:40.49 Index 2 (XQS_1000_3300_SND_ID) 
 
07:10:41.38 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:10:41.77 Relation 268 (XQS_1000_3300) is ok 
 
 
07:10:41.77 Relation 269 (XQS_2000_3300) 
 
07:10:41.77   process pointer page    0 of    1 
 
07:10:41.77 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:10:41.77 Index 2 (XQS_2000_3300_SND_ID) 
 
07:10:41.77 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:10:41.77 Relation 269 (XQS_2000_3300) is ok 
 
 
07:10:41.77 Relation 270 (XQS_2100_3300) 
 
07:10:41.77   process pointer page    0 of   34 
 
07:10:42.19   process pointer page    1 of   34 
 
07:10:42.60   process pointer page    2 of   34 
 
07:10:43.05   process pointer page    3 of   34 
 
07:10:43.53   process pointer page    4 of   34 
 
07:10:44.00   process pointer page    5 of   34 
 
07:10:44.49   process pointer page    6 of   34 
 
07:10:44.97   process pointer page    7 of   34 
 
07:10:45.44   process pointer page    8 of   34 
 
07:10:45.87   process pointer page    9 of   34 
 
07:10:46.34   process pointer page   10 of   34 
 
07:10:46.81   process pointer page   11 of   34 
 
07:10:47.26   process pointer page   12 of   34 
 
07:10:47.65   process pointer page   13 of   34 
 
07:10:48.00   process pointer page   14 of   34 
 
07:10:48.45   process pointer page   15 of   34 
 
07:10:48.90   process pointer page   16 of   34 
 
07:10:49.35   process pointer page   17 of   34 
 
07:10:49.82   process pointer page   18 of   34 
 
07:10:50.32   process pointer page   19 of   34 
 
07:10:50.76   process pointer page   20 of   34 
 
07:10:51.21   process pointer page   21 of   34 
 
07:10:51.65   process pointer page   22 of   34 
 
07:10:52.08   process pointer page   23 of   34 
 
07:10:52.52   process pointer page   24 of   34 
 
07:10:52.97   process pointer page   25 of   34 
 
07:10:53.36   process pointer page   26 of   34 
 
07:10:53.78   process pointer page   27 of   34 
 
07:10:54.17   process pointer page   28 of   34 
 
07:10:54.63   process pointer page   29 of   34 
 
07:10:55.08   process pointer page   30 of   34 
 
07:10:55.53   process pointer page   31 of   34 
 
07:10:55.97   process pointer page   32 of   34 
 
07:10:56.42   process pointer page   33 of   34 
 
07:10:56.44 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:10:58.12 Index 2 (XQS_2100_3300_SND_ID) 
 
07:10:59.90 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:11:02.10 Relation 270 (XQS_2100_3300) is ok 
 
 
07:11:02.10 Relation 271 (XQS_3300_3400) 
 
07:11:02.10   process pointer page    0 of    6 
 
07:11:02.57   process pointer page    1 of    6 
 
07:11:03.05   process pointer page    2 of    6 
 
07:11:03.53   process pointer page    3 of    6 
 
07:11:04.02   process pointer page    4 of    6 
 
07:11:04.47   process pointer page    5 of    6 
 
07:11:04.77 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:11:05.06 Index 2 (XQS_3300_3400_SND_ID) 
 
07:11:05.36 Relation 271 (XQS_3300_3400) is ok 
 
 
07:11:05.36 Validation finished 
 
Done for 64190 ms, from  7:10:01.20 to  7:11:05.39. 
 
 Differences between old and current firebird.log 
7:11:07.06. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
 
Obtained firebird.log info:
 
Result of DIR command for firebird.log AFTER test finish:
 
2017-12-10  07:11               471 oltp30_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log 
 
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
5:   
 
6:  WIN-2BE1UI8LGDL Sun Dec 10 07:10:01 2017 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Sun Dec 10 07:11:05 2017 
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
Remove 401 logs of every ISQL session if there were no serious errors.  
 Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp30\oltp30_*.*: 
 
 
|  ERRORS_CHECKING_RESULT  | 
|  NO_SEVERE_ERRORS_FOUND  | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2017-12-10  7:11:14.63 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html